{"text_format":"1","workbook":"xlsx","n_sheets":14,"sheets":["Content","Executive Summary","Staff&Patient Survey Dashboard","VSM (full) ","Time Ob (Lead TOF)","Time Ob (Cycle - ADA)","Time Ob (Cycle - Nurse)","Time Ob (Cycle - Doctor)","Staff Feedback Survey Data","Staff Feedback Survey Data 1","Staff Survey pivot table","Patient Survey data","Patient Survey data 1","Patient Survey pivot tables"],"not_rendered":{"charts":8,"images":2,"macros":0,"external_links":0,"defined_names":36,"comments":0,"pivot_tables":9},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Content","index":0,"n_rows":7,"n_cols":4,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Document/Tab","Definition","Required for this project?"]
[null,"Executive summary","An executive summary is a brief overview of the project that explains the purpose of the project, the methodology used, the key findings, and the recommendations for improvement.","Yes"]
[null,"Staff&Patient Survey Dashboard","A Patient and staff surveys are an important tool for continuous improvement projects because they provide a direct perspective from the people who are most affected by the process under review. The dashboard provide a summary of this data.","Yes"]
[null," Value Stream Map ","A Value Stream Map provides the entire process flow view from start to finish. It aids in creating plans to optimize the process and helps identify wastes depicted by Kaizen Bursts.","Yes"]
[null,"Time observation sheets (Lead)"," Time observation sheets are used to collect data on the amount of time it takes to complete the entire process. This data can then be used to identify areas for improvement, such as reducing waste or bottlenecks.","Yes"]
[null,"Time observation sheets (Cycle)"," Time observation sheets are used to collect data on the amount of time it takes an operator to complete his work. This data can then be used to identify areas for improvement, such as reducing waste or bottlenecks.","Yes"]

{"sheet":"Executive Summary","index":1,"n_rows":3,"n_cols":2,"rows_kept":3,"cut":false,"hidden":false,"merged":[[2,1,24,1]]}
[]
[null," Executive Summary"]
[null,"SDEC is the provision of same day care for emergency patients who would otherwise be admitted to hospital. (NHS England)\n\nThe roll out and development of Same Day Emergency Care (SDEC) is a central strand of NHS England’s Urgent and Emergency Care Strategy which is designed to support Trust’s nationally in dealing with increasing acute demand, crowding in Emergency departments and the need to restore critical services following the pandemic. (NHS Benchmarking)\nUnder this care model, patients presenting at hospital with relevant conditions can be rapidly assessed, diagnosed and treated without being admitted to a ward, and if clinically safe to do so, will go home the same day their care is provided. (NHS England)\n\nFollowing the implementation of the RAFTING Model, the KGH ED Team in partnership with the Continuous Improvement Team and other stakeholders, have continued work in KGH ED to re-design and re-launch KGH SDEC. \n\nThe Team buildt on the successes from the RAFTING project and used learning points to engage staff and map out the plans for the SDEC project. This facilitated being able to respond to changes or adaptations required, while providing quality care to patients and ensuring the best process was running at all times. \n\nStaff feedback about the change process has been positive, with 100% of staff surveyed stating they have a clear understanding of their role in SDEC. The positive impact on patients was clearly demonstrated as 100% felt that they received good care and 86% felt that their plan was clearly communicated to them.    \n\nWith regards to the data collected, please see a summary below:\n\n1.\tLead Time, the time it takes from when a patient is allocated to SDEC to when they are discharged from SDEC is: 4hrs. 32mins.  \n\n2.\tProcessing Time, the time the process takes without waiting and walking time is: 2hrs 15mins.\n\n3.\tWaiting Time, the time the patient is waiting for the next step within the process to happen: 1hr 36mins.\n\n4.\t16 improvement opportunities were observed with 13% of these having initiatives already started or completed to address them. \n\nMain themes identified for continuous improvement following the implementation of SDEC are as follows:  \n \n\tRefine Processes to reduce observed process waste\n\tAddress IT related limitations \n\tConitnue Communication/Education with ED staff and other departments\n\nLearning from this project, key lessons are as follows: \n\n1.\tFollowing the Trust Continuous Improvement Methodology facilitated reduction of avoidable process wastes.\n\n2.\tPlanning and involvement of all relevant staff groups promoted preparation for the changes and  facilitated readiness to respond to any challenges. \n\n3.\tWide engagement, communication and education with staff facilitated smooth navigation of the change process. \n"]

{"sheet":"Staff&Patient Survey Dashboard","index":2,"n_rows":28,"n_cols":2,"rows_kept":28,"cut":false,"hidden":false,"merged":[[1,1,1,28],[27,1,27,28]]}
[]
[null,"Staff survey (SDEC)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Patient survey (SDEC)"]

{"sheet":"VSM (full) ","index":3,"n_rows":36,"n_cols":21,"rows_kept":36,"cut":false,"hidden":false,"merged":[[28,15,28,16]]}
[]
[null,"Process Boundaries"]
["From: ","When patient is allocated to SDEC."]
["To: ","When patient is discharged from SDEC."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"I am allocated to SDEC",null,"The ADA is taking my blood test and perform my ECG",null,"I am seen by a Nurse",null,"I am seen by a Doctor",null," I go for a scan/test (out of SDEC)",null,"Nurse does my Observations (Vital Signs)",null,"I am discharged from SDEC",null,null,null,null,null,"Wait time median"]
[null,"The patient is allocated to SDEC from RAFTING. The exclusions criteria have been assessed and the patient will be classified safe to sit or trolley.",null,"The ADA will take the blood tests requested from RAFTING doctor and ECG if requried",null,"The nurse is taking the vital sign and other tests if required (i.e. urine sample/oregnancy test)",null,"The doctor assess medical notes, assess the history of the patients and assess the patient physically if needed. At this point, the diagnostics are requested. ",null,"The patient is now taken to diagnostic department and have the test done. ",null,"Before being discharge the nurse takes vital signs. ",null,"Patient leaves SDEC "]
[null,null,null,"ADA X 1",null,"NURSE X 1",null,"DOCTOR X 1",null,"PORTER X 1",null,"NURSE X 1",null,null,null,null,null,null,null,null,{"$f":"B29+C28+D29+F29","v":"01:11:30"}]
[null,null,"00:21:00",null,"00:03:00",null,"00:31:00",null,"00:16:00",null,"00:18:00",null,"00:07:00"]
[null,"00:00:00",null,"00:27:30",null,"00:23:00",null,"01:27:57",null,"00:35:30",null,"00:03:00",null,"00:00:00",null,"Totals",null,null,null,null,{"$f":"U27+T27+T26","v":"01:11:30"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lead Time",{"$f":"B29+C28+D29+E28+F29+G28+H29+I28+J29+K28+L29+M28+N29","v":"04:32:57"}]
["CT:","00:00:00","CT:","00:27:30","CT:","00:23:00","CT:","01:27:57","CT:","00:35:30","CT:","00:03:00","CT:","00:00:00",null,"Processing Time",{"$f":"D32+F32+H32+J32+L32+N32","v":"02:15:57"}]
["PT:","00:00:00","PT:","00:27:30","PT:","00:23:00","PT:","00:46:57","PT:","00:35:30","PT:","00:03:00","PT:","00:00:00",null,"Change Over Time",{"$f":"D33+F33+H33+J33+L33+N33","v":"00:00:00"}]
["CO","00:00:00","CO","00:00:00","CO","00:00:00","CO","00:00:00","CO","00:00:00","CO","00:00:00","CO","00:00:00",null,"Value Added (VA) Time",{"$f":"D34+F34+H34+J34+L34+N34","v":"01:39:30"}]
["VA:","00:00:00","VA:","00:09:00","VA:","00:23:00","VA:","00:29:00","VA:","00:35:30","VA:","00:03:00","VA:","00:00:00",null,"Non Value Added (NVA) Time",{"$f":"C28+D35+E28+F35+G28+H35+I28+J35+K28+L35+M28+N35","v":"02:53:27"}]
["NVA:","00:00:00","NVA:","00:18:30","NVA:","00:00:00","NVA:","00:58:57","NVA:","00:00:00","NVA:","00:00:00","NVA:","00:00:00",null,"% VA",{"$f":"Q33/Q30","v":0.36453562923612381}]
["%VA:","00:00:00","%VA:",0.33,"%VA:",1,"%VA:",0.33,"%VA:",1,"%VA:",1,"%VA:","00:00:00"]

{"sheet":"Time Ob (Lead TOF)","index":4,"n_rows":45,"n_cols":17,"rows_kept":45,"cut":false,"hidden":false,"merged":[[27,1,28,1],[27,2,28,2],[25,1,26,1],[25,2,26,2],[33,1,34,1],[33,2,34,2],[29,1,30,1],[29,2,30,2],[31,1,32,1],[31,2,32,2],[19,1,20,1],[19,2,20,2],[23,1,24,1],[23,2,24,2],[21,1,22,1],[21,2,22,2],[17,1,18,1],[11,1,12,1],[11,2,12,2],[4,2,4,3],[4,4,4,5],[13,1,14,1],[13,2,14,2],[15,1,16,1],[15,2,16,2],[17,2,18,2],[3,12,3,14],[3,15,3,16],[9,1,10,1],[9,2,10,2],[4,12,4,14],[4,15,4,16],[3,2,3,3],[3,4,3,5],[3,6,3,8],[3,9,3,10],[4,9,4,10],[0,1,0,38],[1,1,1,2],[2,2,2,3],[2,4,2,5],[2,9,2,10],[2,12,2,14],[2,15,2,16]]}
[null,"Time Observation Form - Lead Time "]
[null,"Process Boundaries"]
[null,"From","Pt Allocated to SDEC",null,"Process",null,"Patient journey through SDEC",null,null,"Time Available (mins)",null,null,"Date",null,null,"12/06/2023 - 13/06/2023"]
[null,"To","Pt Leaves SDEC",null,"Cycle",null,"All",null,null,"Demand",null,null,"Time",null,null,"08:00 - 16:00"]
[null,"Area","KGH - SDEC",null,"Operator Title",null,"All",null,null,"Takt Time (Sec)",null,null,"Completed By",null,null,"L. Dobbie"]
[]
[null,null,null,null,"Patient Scored >>","YES","YES","YES","YES","YES","YES","YES"]
[null,null,null,null,null,null,null,null,null,"Most Frequent Task Time"]
[null,"Step #","Description of Operation","The step is VA/NVA based on customer view","Waiting/Walking Time (W) / Processing Time (P)",1,2,3,4,5,6,7,"Include zero values in Mode","Mode","Include zero values in Median","Median","Selected Value\n(User input required)"]
[null,1,"Pt allocated to SDEC",null,null,"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[null,null,null,"VA","P",{"$f":"IF(ISBLANK(F10),\"\",IF(ISBLANK(F12),\"\",ROUND(F12-F10,10)))","v":"00:00:00"},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","NO",{"$f":"IFERROR(IF(M11=\"NO\",MODE(IF($F$7:$L$7=\"YES\",IF(F11:L11>0,F11:L11))),MODE(IF($F$7:$L$7=\"YES\",F11:L11))),\"\")","v":""},"NO",{"$f":"IFERROR(IF(O11=\"NO\",MEDIAN(IF($F$7:$L$7=\"YES\",IF(F11:L11>0,F11:L11))),MEDIAN(IF($F$7:$L$7=\"YES\",F11:L11))),\"\")","v":""},"Mode"]
[null,{"$f":"B10+1","v":2},"Pt waits",null,null,"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[null,null,null,"NVA","W",{"$f":"IF(ISBLANK(F12),\"\",IF(ISBLANK(F14),\"\",ROUND(F14-F12,10)))","v":"00:53:00"},"00:00:00","00:33:00","00:00:00","00:21:00","00:14:00","00:06:00","NO",{"$f":"IFERROR(IF(M13=\"NO\",MODE(IF($F$7:$L$7=\"YES\",IF(F13:L13>0,F13:L13))),MODE(IF($F$7:$L$7=\"YES\",F13:L13))),\"\")","v":""},"NO",{"$f":"IFERROR(IF(O13=\"NO\",MEDIAN(IF($F$7:$L$7=\"YES\",IF(F13:L13>0,F13:L13))),MEDIAN(IF($F$7:$L$7=\"YES\",F13:L13))),\"\")","v":"00:21:00"},{"$f":"IF(N13=\"\",\"Median\",\"Mode\")","v":"Median"}]
[null,{"$f":"B12+1","v":3},"HCA / ADA Obs",null,null,"00:53:00","00:00:00","00:33:00","00:00:00","00:21:00","00:14:00","00:06:00"]
[null,null,null,"VA","P",{"$f":"IF(ISBLANK(F14),\"\",IF(ISBLANK(F16),\"\",ROUND(F16-F14,10)))","v":"00:09:00"},"00:00:00","00:08:00","00:15:00","00:15:00","00:05:00","00:10:00","NO",{"$f":"IFERROR(IF(M15=\"NO\",MODE(IF($F$7:$L$7=\"YES\",IF(F15:L15>0,F15:L15))),MODE(IF($F$7:$L$7=\"YES\",F15:L15))),\"\")","v":"00:15:00"},"NO",{"$f":"IFERROR(IF(O15=\"NO\",MEDIAN(IF($F$7:$L$7=\"YES\",IF(F15:L15>0,F15:L15))),MEDIAN(IF($F$7:$L$7=\"YES\",F15:L15))),\"\")","v":"00:09:30"},{"$f":"IF(N15=\"\",\"Median\",\"Mode\")","v":"Mode"}]
[null,{"$f":"B14+1","v":4},"Pt waits",null,null,"01:02:00","00:00:00","00:41:00","00:15:00","00:36:00","00:19:00","00:16:00"]
[null,null,null,"NVA","W",{"$f":"IF(ISBLANK(F16),\"\",IF(ISBLANK(F18),\"\",ROUND(F18-F16,10)))","v":"00:03:00"},"00:01:00","00:02:00","00:00:00","00:18:00","00:12:00","00:00:00","NO",{"$f":"IFERROR(IF(M17=\"NO\",MODE(IF($F$7:$L$7=\"YES\",IF(F17:L17>0,F17:L17))),MODE(IF($F$7:$L$7=\"YES\",F17:L17))),\"\")","v":""},"NO",{"$f":"IFERROR(IF(O17=\"NO\",MEDIAN(IF($F$7:$L$7=\"YES\",IF(F17:L17>0,F17:L17))),MEDIAN(IF($F$7:$L$7=\"YES\",F17:L17))),\"\")","v":"00:03:00"},{"$f":"IF(N17=\"\",\"Median\",\"Mode\")","v":"Median"}]
[null,{"$f":"B16+1","v":5},"Nurse attends",null,null,"01:05:00","00:01:00","00:43:00","00:15:00","00:54:00","00:31:00","00:16:00"]
[null,null,null,"VA","P",{"$f":"IF(ISBLANK(F18),\"\",IF(ISBLANK(F20),\"\",ROUND(F20-F18,10)))","v":"00:00:00"},"00:54:00","00:19:00","00:27:00","00:44:00","00:15:00","00:50:00","NO",{"$f":"IFERROR(IF(M19=\"NO\",MODE(IF($F$7:$L$7=\"YES\",IF(F19:L19>0,F19:L19))),MODE(IF($F$7:$L$7=\"YES\",F19:L19))),\"\")","v":""},"NO",{"$f":"IFERROR(IF(O19=\"NO\",MEDIAN(IF($F$7:$L$7=\"YES\",IF(F19:L19>0,F19:L19))),MEDIAN(IF($F$7:$L$7=\"YES\",F19:L19))),\"\")","v":"00:35:30"},{"$f":"IF(N19=\"\",\"Median\",\"Mode\")","v":"Median"}]
[null,{"$f":"B18+1","v":6},"Pt waits",null,null,"01:05:00","00:55:00","01:02:00","00:42:00","01:38:00","00:46:00","01:06:00"]
[null,null,null,"NVA","W",{"$f":"IF(ISBLANK(F20),\"\",IF(ISBLANK(F22),\"\",ROUND(F22-F20,10)))","v":"01:01:00"},"01:12:00","01:05:00","00:09:00","00:31:00","00:26:00","00:13:00","NO",{"$f":"IFERROR(IF(M21=\"NO\",MODE(IF($F$7:$L$7=\"YES\",IF(F21:L21>0,F21:L21))),MODE(IF($F$7:$L$7=\"YES\",F21:L21))),\"\")","v":""},"NO",{"$f":"IFERROR(IF(O21=\"NO\",MEDIAN(IF($F$7:$L$7=\"YES\",IF(F21:L21>0,F21:L21))),MEDIAN(IF($F$7:$L$7=\"YES\",F21:L21))),\"\")","v":"00:31:00"},{"$f":"IF(N21=\"\",\"Median\",\"Mode\")","v":"Median"}]
[null,{"$f":"B20+1","v":7},"Doctor attends",null,null,"02:06:00","02:07:00","02:07:00","00:51:00","02:09:00","01:12:00","01:19:00"]
[null,null,null,"VA","P",{"$f":"IF(ISBLANK(F22),\"\",IF(ISBLANK(F24),\"\",ROUND(F24-F22,10)))","v":"00:01:00"},"00:10:00","00:10:00","00:04:00","00:00:00","00:06:00","00:00:00","NO",{"$f":"IFERROR(IF(M23=\"NO\",MODE(IF($F$7:$L$7=\"YES\",IF(F23:L23>0,F23:L23))),MODE(IF($F$7:$L$7=\"YES\",F23:L23))),\"\")","v":"00:10:00"},"NO",{"$f":"IFERROR(IF(O23=\"NO\",MEDIAN(IF($F$7:$L$7=\"YES\",IF(F23:L23>0,F23:L23))),MEDIAN(IF($F$7:$L$7=\"YES\",F23:L23))),\"\")","v":"00:06:00"},{"$f":"IF(N23=\"\",\"Median\",\"Mode\")","v":"Mode"}]
[null,{"$f":"B22+1","v":8},"Pt waits",null,null,"02:07:00","02:17:00","02:17:00","00:55:00","02:09:00","01:18:00","01:19:00"]
[null,null,null,"NVA","W",{"$f":"IF(ISBLANK(F24),\"\",IF(ISBLANK(F26),\"\",ROUND(F26-F24,10)))","v":"00:00:00"},"00:32:00","00:07:00","00:00:00","00:00:00","00:25:00","00:04:00","NO",{"$f":"IFERROR(IF(M25=\"NO\",MODE(IF($F$7:$L$7=\"YES\",IF(F25:L25>0,F25:L25))),MODE(IF($F$7:$L$7=\"YES\",F25:L25))),\"\")","v":""},"NO",{"$f":"IFERROR(IF(O25=\"NO\",MEDIAN(IF($F$7:$L$7=\"YES\",IF(F25:L25>0,F25:L25))),MEDIAN(IF($F$7:$L$7=\"YES\",F25:L25))),\"\")","v":"00:16:00"},{"$f":"IF(N25=\"\",\"Median\",\"Mode\")","v":"Median"}]
[null,{"$f":"B24+1","v":9},"Pt goes for scan / test out of SDEC",null,null,"02:07:00","02:49:00","02:24:00","00:55:00","02:09:00","01:43:00","01:23:00"]
[null,null,null,"VA","P",{"$f":"IF(ISBLANK(F26),\"\",IF(ISBLANK(F28),\"\",ROUND(F28-F26,10)))","v":"00:15:00"},"00:08:00","00:03:00","00:21:00","00:11:00","00:13:00","00:21:00","NO",{"$f":"IFERROR(IF(M27=\"NO\",MODE(IF($F$7:$L$7=\"YES\",IF(F27:L27>0,F27:L27))),MODE(IF($F$7:$L$7=\"YES\",F27:L27))),\"\")","v":"00:21:00"},"NO",{"$f":"IFERROR(IF(O27=\"NO\",MEDIAN(IF($F$7:$L$7=\"YES\",IF(F27:L27>0,F27:L27))),MEDIAN(IF($F$7:$L$7=\"YES\",F27:L27))),\"\")","v":"00:13:00"},{"$f":"IF(N27=\"\",\"Median\",\"Mode\")","v":"Mode"}]
[null,{"$f":"B26+1","v":10},"Pt waits",null,null,"02:22:00","02:57:00","02:27:00","01:16:00","02:20:00","01:56:00","01:44:00"]
[null,null,null,"NVA","W",{"$f":"IF(ISBLANK(F28),\"\",IF(ISBLANK(F30),\"\",ROUND(F30-F28,10)))","v":"00:03:00"},"02:05:00","00:39:00","00:18:00","00:00:00","00:00:00","00:12:00","NO",{"$f":"IFERROR(IF(M29=\"NO\",MODE(IF($F$7:$L$7=\"YES\",IF(F29:L29>0,F29:L29))),MODE(IF($F$7:$L$7=\"YES\",F29:L29))),\"\")","v":""},"NO",{"$f":"IFERROR(IF(O29=\"NO\",MEDIAN(IF($F$7:$L$7=\"YES\",IF(F29:L29>0,F29:L29))),MEDIAN(IF($F$7:$L$7=\"YES\",F29:L29))),\"\")","v":"00:18:00"},{"$f":"IF(N29=\"\",\"Median\",\"Mode\")","v":"Median"}]
[null,{"$f":"B28+1","v":11},"Nurse Obs",null,null,"02:25:00","05:02:00","03:06:00","01:34:00","02:20:00","01:56:00","01:56:00"]
[null,null,null,"VA","P",{"$f":"IF(ISBLANK(F30),\"\",IF(ISBLANK(F32),\"\",ROUND(F32-F30,10)))","v":"00:02:00"},"00:04:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","NO",{"$f":"IFERROR(IF(M31=\"NO\",MODE(IF($F$7:$L$7=\"YES\",IF(F31:L31>0,F31:L31))),MODE(IF($F$7:$L$7=\"YES\",F31:L31))),\"\")","v":""},"NO",{"$f":"IFERROR(IF(O31=\"NO\",MEDIAN(IF($F$7:$L$7=\"YES\",IF(F31:L31>0,F31:L31))),MEDIAN(IF($F$7:$L$7=\"YES\",F31:L31))),\"\")","v":"00:03:00"},{"$f":"IF(N31=\"\",\"Median\",\"Mode\")","v":"Median"}]
[null,{"$f":"B30+1","v":12},"Pt waits",null,null,"02:27:00","05:06:00","03:06:00","01:34:00","02:20:00","01:56:00","01:56:00"]
[null,null,null,"NVA","W",{"$f":"IF(ISBLANK(F32),\"\",IF(ISBLANK(F34),\"\",ROUND(F34-F32,10)))","v":"00:03:00"},"00:12:00","00:00:00","00:00:00","00:08:00","00:06:00","00:00:00","NO",{"$f":"IFERROR(IF(M33=\"NO\",MODE(IF($F$7:$L$7=\"YES\",IF(F33:L33>0,F33:L33))),MODE(IF($F$7:$L$7=\"YES\",F33:L33))),\"\")","v":""},"NO",{"$f":"IFERROR(IF(O33=\"NO\",MEDIAN(IF($F$7:$L$7=\"YES\",IF(F33:L33>0,F33:L33))),MEDIAN(IF($F$7:$L$7=\"YES\",F33:L33))),\"\")","v":"00:07:00"},{"$f":"IF(N33=\"\",\"Median\",\"Mode\")","v":"Median"}]
[null,{"$f":"B32+1","v":13},"Discharged",null,null,"02:30:00","05:18:00","03:06:00","01:34:00","02:28:00","02:02:00","01:56:00"]
[null,null,null,null,null,null,null,null,null,null,null,null,"NO",{"$f":"IFERROR(IF(M35=\"NO\",MODE(IF($F$7:$L$7=\"YES\",IF(F35:L35>0,F35:L35))),MODE(IF($F$7:$L$7=\"YES\",F35:L35))),\"\")","v":""},"NO",{"$f":"IFERROR(IF(O35=\"NO\",MEDIAN(IF($F$7:$L$7=\"YES\",IF(F35:L35>0,F35:L35))),MEDIAN(IF($F$7:$L$7=\"YES\",F35:L35))),\"\")","v":""},{"$f":"IF(N35=\"\",\"Median\",\"Mode\")","v":"Median"}]
[]
[null,null,"Time For One Observation",null,null,"02:30:00","05:18:00","03:06:00","01:34:00","02:28:00","02:02:00","01:56:00",null,null,null,{"$f":"P38+P39","v":"03:00:30"}]
[null,null,"Minus Walking/Wait Time","W",null,{"$f":"SUMIF($E$10:$E$35,\"W\",F10:F35)","v":"02:03:00"},"04:02:00","02:26:00","00:27:00","01:18:00","01:23:00","00:35:00",null,null,null,{"$f":"SUMIFS(P10:P35,E10:E35,\"W\",Q10:Q35,\"median\")+SUMIFS(N10:N35,E10:E35,\"W\",Q10:Q35,\"Mode\")","v":"01:36:00"}]
[null,null,".= Processing Time","P",null,{"$f":"SUMIF($E$10:$E$33,\"P\",F10:F33)","v":"00:27:00"},"01:16:00","00:40:00","01:07:00","01:10:00","00:39:00","01:21:00",null,null,null,{"$f":"SUMIFS(P10:P35,E10:E35,\"P\",Q10:Q35,\"median\")+SUMIFS(N10:N35,E10:E35,\"P\",Q10:Q35,\"Mode\")","v":"01:24:30"}]
[]
[null,null,"Value add Total","VA",null,{"$f":"SUMIF($D$10:$D$33,\"VA\",F10:F33)","v":"00:27:00"},"01:16:00","00:40:00","01:07:00","01:10:00","00:39:00","01:21:00",null,null,null,{"$f":"SUMIFS(P10:P35,D10:D35,\"VA\",Q10:Q35,\"median\")+SUMIFS(N10:N35,D10:D35,\"VA\",Q10:Q35,\"Mode\")","v":"01:24:30"}]
[null,null,"Non Value Add Total","NVA",null,{"$f":"SUMIF($D$10:$D$33,\"NVA\",F10:F33)","v":"02:03:00"},"04:02:00","02:26:00","00:27:00","01:18:00","01:23:00","00:35:00",null,null,null,{"$f":"SUMIFS(P10:P35,D10:D35,\"NVA\",Q10:Q35,\"median\")+SUMIFS(N10:N35,D10:D35,\"NVA\",Q10:Q35,\"Mode\")","v":"01:36:00"}]
[]
[null,null,"Value add Total (%)","VA",null,{"$f":"F41/F37","v":0.18},0.23899371079245282,0.21505376283870964,0.71276595778723406,0.47297297383783782,0.31967213193442628,0.69827586082758619,null,null,null,{"$f":"P41/P37","v":0.4681440443600034}]
[null,null,"Non Value Add Total (%)","NVA",null,{"$f":"F42/F37","v":0.8199999993599999},0.76100628905660372,0.78494623664516128,0.28723404255319152,0.52702702735135132,0.68032786898360664,0.30172413848275859,null,null,null,{"$f":"P42/P37","v":0.53185595563999666}]

{"sheet":"Time Ob (Cycle - ADA)","index":5,"n_rows":32,"n_cols":15,"rows_kept":32,"cut":false,"hidden":false,"merged":[[25,1,26,1],[25,2,26,2],[25,3,26,3],[21,1,22,1],[21,2,22,2],[21,3,22,3],[23,1,24,1],[23,2,24,2],[23,3,24,3],[17,1,18,1],[17,2,18,2],[17,3,18,3],[19,1,20,1],[19,2,20,2],[19,3,20,3],[13,1,14,1],[13,2,14,2],[13,3,14,3],[15,1,16,1],[15,2,16,2],[15,3,16,3],[9,1,10,1],[9,2,10,2],[9,3,10,3],[7,3,7,11],[11,1,12,1],[11,2,12,2],[11,3,12,3],[4,2,4,3],[4,4,4,5],[4,9,4,10],[4,12,4,13],[4,14,4,15],[3,12,3,13],[3,14,3,15],[0,1,0,37],[1,1,1,2],[2,2,2,3],[2,4,2,5],[2,9,2,10],[2,12,2,13],[2,14,2,15],[3,2,3,3],[3,4,3,5],[3,6,3,8],[3,9,3,10]]}
[null,"Time Observation Form -  ADA Cycle Time "]
[null,"Process Boundaries"]
[null,"From","Identify next patient for blood test and/or ECG",null,"Process",null,"ADA carries out blood test and/or ECG",null,null,"Time Available (mins)",null,null,"Date",null,"2023-05-05"]
[null,"To","Blood test and/or ECG completed for patient",null,"Cycle",null,"ADA",null,null,"Demand",null,null,"Time",null,"09:00 - 12:00"]
[null,"Area","KGH ED",null,"Operator Title",null,"ADA",null,null,"Takt Time (Sec)",null,null,"Completed By",null,"Neha"]
[]
[]
[null,null,null,"Most Frequent Task Time"]
[null,"Step #","Description of Operation","Waste","Waiting Time (W) / Processing Time (P)",1,2,3,4,5,6,7,"Mode","Median","Selected Value\n(User input required)"]
[null,{"$f":"ROW(B1)","v":1},"Find next patient in Careflow and print patient paperwork",null,null,"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[null,null,null,null,"P",{"$f":"IF(ISBLANK(F10),\"\",IF(ISBLANK(F12),\"\",F12-F10))","v":"00:00:00"},"00:00:00","00:00:00","00:00:00","00:00:00","00:02:00","00:03:00",null,"00:02:30","Median"]
[null,2,"Prepare blood test tray",null,null,"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:02:00","00:03:00"]
[null,null,null,null,"P",{"$f":"IF(ISBLANK(F12),\"\",IF(ISBLANK(F14),\"\",F14-F12))","v":"00:00:00"},"00:00:00","00:00:00","00:00:00","00:00:00","00:03:00","00:01:00",null,"00:02:00","Median"]
[null,3,"Call patient to ADA room",null,null,"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:05:00","00:04:00"]
[null,null,null,null,"P",{"$f":"IF(ISBLANK(F14),\"\",IF(ISBLANK(F16),\"\",F16-F14))","v":"00:03:00"},"00:00:00","00:00:00","00:00:00","00:00:00","00:04:00","00:06:00",null,"00:04:00","Median"]
[null,4,"Do blood test",null,null,"00:03:00","00:00:00","00:00:00","00:00:00","00:00:00","00:09:00","00:10:00"]
[null,null,null,null,"P","00:06:00",{"$f":"IF(ISBLANK(G16),\"\",IF(ISBLANK(G18),\"\",G18-G16))","v":"00:06:00"},"00:03:00","00:04:00","00:05:00","00:03:00","00:04:00",null,{"$f":"IFERROR(MEDIAN(F17:L17),\"\")","v":"00:04:00"},"Median"]
[null,5,"Do ECG",null,null,"00:00:00","00:06:00","00:03:00","00:04:00","00:05:00","00:12:00","00:14:00"]
[null,null,null,null,"P","00:00:00",{"$f":"IF(ISBLANK(G18),\"\",IF(ISBLANK(G20),\"\",G20-G18))","v":"00:05:00"},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:05:00",null,"Mode"]
[null,4,"Label & bag samples.  \nDo blood gas test.",null,null,"00:09:00","00:11:00","00:03:00","00:04:00","00:05:00","00:12:00","00:14:00"]
[null,null,null,null,"P",{"$f":"IF(ISBLANK(F20),\"\",IF(ISBLANK(F22),\"\",F22-F20))","v":"00:03:00"},"00:05:00","00:05:00","00:08:00","00:07:00","00:04:00","00:04:00",{"$f":"IFERROR(MODE(F21:L21),\"\")","v":""},{"$f":"IFERROR(MEDIAN(F21:L21),\"\")","v":"00:05:00"},"Median"]
[null,6,"Take blood gas and /or ECG results to doctor",null,null,"00:12:00","00:16:00","00:08:00","00:12:00","00:12:00","00:16:00","00:18:00"]
[null,null,null,null,"P",{"$f":"IF(ISBLANK(F22),\"\",IF(ISBLANK(F24),\"\",F24-F22))","v":"00:01:00"},"00:02:00",{"$f":"IF(ISBLANK(H22),\"\",IF(ISBLANK(H24),\"\",H24-H22))","v":"00:00:00"},{"$f":"IF(ISBLANK(I22),\"\",IF(ISBLANK(I24),\"\",I24-I22))","v":"00:00:00"},{"$f":"IF(ISBLANK(J22),\"\",IF(ISBLANK(J24),\"\",J24-J22))","v":"00:00:00"},{"$f":"IF(ISBLANK(K22),\"\",IF(ISBLANK(K24),\"\",K24-K22))","v":"00:00:00"},{"$f":"IF(ISBLANK(L22),\"\",IF(ISBLANK(L24),\"\",L24-L22))","v":"00:00:00"},null,"00:01:30","Median"]
[null,7,"Take sample to POD machine",null,null,"00:13:00","00:18:00","00:08:00","00:12:00","00:12:00","00:16:00","00:18:00"]
[null,null,null,null,"P",{"$f":"IF(ISBLANK(F24),\"\",IF(ISBLANK(F26),\"\",F26-F24))","v":"00:01:00"},"00:06:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00",null,"00:03:30","Median"]
[null,8,"End",null,null,"00:14:00","00:24:00","00:08:00","00:12:00","00:12:00","00:16:00","00:18:00"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(MODE(F27:L27),\"\")","v":""},{"$f":"IFERROR(MEDIAN(F27:L27),\"\")","v":""}]
[]
[]
[null,null,"Time For One Observation",null,null,{"$f":"F31+F32","v":"00:14:00"},"00:24:00","00:08:00","00:12:00","00:12:00","00:16:00","00:18:00",null,{"$f":"N31+N32","v":"00:27:30"}]
[null,null,"Minus Walking/Wait Time","W",null,{"$f":"SUMIF($E$10:$E$28,\"W\",F10:F28)","v":"00:00:00"},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00",null,{"$f":"SUMIFS(N10:N27,E10:E27,\"W\",O10:O27,\"median\")+SUMIFS(M10:M27,E10:E27,\"W\",O10:O27,\"Mode\")","v":"00:00:00"}]
[null,null,".= Processing Time","P",null,{"$f":"SUMIF($E$10:$E$28,\"P\",F10:F28)","v":"00:14:00"},"00:24:00","00:08:00","00:12:00","00:12:00","00:16:00","00:18:00",null,{"$f":"SUMIFS(N10:N27,E10:E27,\"P\",O10:O27,\"median\")+SUMIFS(M10:M27,E10:E27,\"P\",O10:O27,\"Mode\")","v":"00:27:30"}]

{"sheet":"Time Ob (Cycle - Nurse)","index":6,"n_rows":31,"n_cols":21,"rows_kept":31,"cut":false,"hidden":false,"merged":[[23,1,24,1],[23,3,24,3],[25,1,26,1],[25,2,26,2],[25,3,26,3],[23,2,24,2],[21,1,22,1],[21,2,22,2],[21,3,22,3],[17,3,18,3],[19,1,20,1],[17,2,18,2],[19,2,20,2],[17,1,18,1],[19,3,20,3],[15,1,16,1],[15,3,16,3],[13,1,14,1],[15,2,16,2],[13,3,14,3],[13,2,14,2],[9,1,10,1],[9,2,10,2],[9,3,10,3],[11,1,12,1],[11,2,12,2],[11,3,12,3],[0,1,0,43],[1,1,1,2],[2,2,2,3],[2,14,2,15],[2,17,2,19],[2,20,2,21],[2,4,2,6],[2,12,2,13],[3,17,3,19],[3,20,3,21],[4,2,4,3],[4,14,4,15],[4,17,4,19],[4,20,4,21],[3,2,3,3],[3,14,3,15],[3,4,3,6],[4,4,4,6],[3,7,3,13],[4,12,4,13]]}
[null,"Time Observation Form - Cycle Time Nurse"]
[null,"Process Boundaries"]
[null,"From","Nurse first contact with patient in SDEC",null,"Process",null,null,"Patient journey through SDEC",null,null,null,null,null,null,"Time Available (mins)",null,null,"Date",null,null,"2023-06-12"]
[null,"To","Patient discharged from SDEC",null,"Cycle",null,null,"SDEC Nurse Assessment and Treatment ",null,null,null,null,null,null,"Demand",null,null,"Time",null,null,"08.45 - 16:45"]
[null,"Area","KGH SDEC",null,"Operator Title",null,null,"Nurse",null,null,null,null,null,null,"Takt Time (Sec)",null,null,"Completed By",null,null,"G. Allick"]
[]
[null,null,null,null,"Patient Scored >>","YES","YES","YES","YES","YES","YES","YES"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Most Frequent Task Time"]
[null,"Step #","Description of Operation","Waste","Waiting/Walking Time (W) / Processing Time (P)",1,2,3,4,5,6,7,"Include zero values in Mode","Mode","Include zero values in Median","Median","Selected Value\n(User input required)"]
[null,1,"Nurse initial contact",null,null,"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[null,null,null,null,"P","00:01:00","00:00:00","00:01:00","00:01:00","00:01:00","00:04:00","00:04:00","NO",{"$f":"IFERROR(IF(M11=\"NO\",MODE(IF($F$7:$L$7=\"YES\",IF(F11:L11>0,F11:L11))),MODE(IF($F$7:$L$7=\"YES\",F11:L11))),\"\")","v":"00:01:00"},"NO",{"$f":"IFERROR(IF(O11=\"NO\",MEDIAN(IF($F$7:$L$7=\"YES\",IF(F11:L11>0,F11:L11))),MEDIAN(IF($F$7:$L$7=\"YES\",F11:L11))),\"\")","v":"00:01:00"},"Mode"]
[null,2,"Nurse check urine",null,null,"00:01:00","00:00:00"]
[null,null,null,null,"P","00:03:00","00:09:00",null,null,null,null,null,"NO",{"$f":"IFERROR(IF(M13=\"NO\",MODE(IF($F$7:$L$7=\"YES\",IF(F13:L13>0,F13:L13))),MODE(IF($F$7:$L$7=\"YES\",F13:L13))),\"\")","v":""},"NO",{"$f":"IFERROR(IF(O13=\"NO\",MEDIAN(IF($F$7:$L$7=\"YES\",IF(F13:L13>0,F13:L13))),MEDIAN(IF($F$7:$L$7=\"YES\",F13:L13))),\"\")","v":"00:06:00"},{"$f":"IF(N13=\"\",\"Median\",\"Mode\")","v":"Median"}]
[null,3,"Nurse does Observations",null,null,"00:04:00","00:09:00","00:01:00","00:01:00",null,"00:04:00","00:04:00"]
[null,null,null,null,"P","00:01:00","00:01:00","00:02:00","00:04:00",null,"00:07:00","00:01:00","NO",{"$f":"IFERROR(IF(M15=\"NO\",MODE(IF($F$7:$L$7=\"YES\",IF(F15:L15>0,F15:L15))),MODE(IF($F$7:$L$7=\"YES\",F15:L15))),\"\")","v":"00:01:00"},"NO",{"$f":"IFERROR(IF(O15=\"NO\",MEDIAN(IF($F$7:$L$7=\"YES\",IF(F15:L15>0,F15:L15))),MEDIAN(IF($F$7:$L$7=\"YES\",F15:L15))),\"\")","v":"00:01:30"},{"$f":"IF(N15=\"\",\"Median\",\"Mode\")","v":"Mode"}]
[null,4,"Nurse removes cannula",null,null,"00:05:00"]
[null,null,null,null,"P","00:03:00",null,null,null,null,null,null,"NO",{"$f":"IFERROR(IF(M17=\"NO\",MODE(IF($F$7:$L$7=\"YES\",IF(F17:L17>0,F17:L17))),MODE(IF($F$7:$L$7=\"YES\",F17:L17))),\"\")","v":""},"NO",{"$f":"IFERROR(IF(O17=\"NO\",MEDIAN(IF($F$7:$L$7=\"YES\",IF(F17:L17>0,F17:L17))),MEDIAN(IF($F$7:$L$7=\"YES\",F17:L17))),\"\")","v":"00:03:00"},{"$f":"IF(N17=\"\",\"Median\",\"Mode\")","v":"Median"}]
[null,5,"Nurse adminsters Treatment",null,null,null,null,"00:03:00",null,"00:01:00","00:11:00","00:05:00"]
[null,null,null,null,"P",null,null,"00:07:00",null,"00:07:00","00:10:00","00:03:00","NO",{"$f":"IFERROR(IF(M19=\"NO\",MODE(IF($F$7:$L$7=\"YES\",IF(F19:L19>0,F19:L19))),MODE(IF($F$7:$L$7=\"YES\",F19:L19))),\"\")","v":"00:07:00"},"NO",{"$f":"IFERROR(IF(O19=\"NO\",MEDIAN(IF($F$7:$L$7=\"YES\",IF(F19:L19>0,F19:L19))),MEDIAN(IF($F$7:$L$7=\"YES\",F19:L19))),\"\")","v":"00:07:00"},{"$f":"IF(N19=\"\",\"Median\",\"Mode\")","v":"Mode"}]
[null,6,"Nurse checks Treatment",null,null,null,null,"00:10:00"]
[null,null,null,null,"P",null,null,"00:02:00",null,null,null,null,"NO",{"$f":"IFERROR(IF(M21=\"NO\",MODE(IF($F$7:$L$7=\"YES\",IF(F21:L21>0,F21:L21))),MODE(IF($F$7:$L$7=\"YES\",F21:L21))),\"\")","v":""},"NO",{"$f":"IFERROR(IF(O21=\"NO\",MEDIAN(IF($F$7:$L$7=\"YES\",IF(F21:L21>0,F21:L21))),MEDIAN(IF($F$7:$L$7=\"YES\",F21:L21))),\"\")","v":"00:02:00"},{"$f":"IF(N21=\"\",\"Median\",\"Mode\")","v":"Median"}]
[null,9,"Nurse Prepares Patient to be moved on to trolley for Scan/Xray",null,null,null,null,null,null,"00:08:00",null,"00:08:00"]
[null,null,null,null,"P",null,null,null,null,"00:01:00",null,"00:01:00","NO",{"$f":"IFERROR(IF(M23=\"NO\",MODE(IF($F$7:$L$7=\"YES\",IF(F23:L23>0,F23:L23))),MODE(IF($F$7:$L$7=\"YES\",F23:L23))),\"\")","v":"00:01:00"},"NO",{"$f":"IFERROR(IF(O23=\"NO\",MEDIAN(IF($F$7:$L$7=\"YES\",IF(F23:L23>0,F23:L23))),MEDIAN(IF($F$7:$L$7=\"YES\",F23:L23))),\"\")","v":"00:01:00"},{"$f":"IF(N23=\"\",\"Median\",\"Mode\")","v":"Mode"}]
[null,10,"Nurse does discharge Observations",null,null,"00:08:00","00:10:00",null,null,"00:09:00",null,"00:09:00"]
[null,null,null,null,"P","00:00:00","00:04:00",null,null,"00:02:00",null,"00:02:00","NO",{"$f":"IFERROR(IF(M25=\"NO\",MODE(IF($F$7:$L$7=\"YES\",IF(F25:L25>0,F25:L25))),MODE(IF($F$7:$L$7=\"YES\",F25:L25))),\"\")","v":"00:02:00"},"NO",{"$f":"IFERROR(IF(O25=\"NO\",MEDIAN(IF($F$7:$L$7=\"YES\",IF(F25:L25>0,F25:L25))),MEDIAN(IF($F$7:$L$7=\"YES\",F25:L25))),\"\")","v":"00:02:00"},{"$f":"IF(N25=\"\",\"Median\",\"Mode\")","v":"Mode"}]
[null,11,"END",null,null,"00:08:00","00:14:00","00:12:00","00:05:00","00:11:00","00:21:00","00:11:00"]
[]
[]
[null,null,"Time For One Observation",null,null,{"$f":"F30+F31","v":"00:08:00"},{"$f":"G30+G31","v":"00:14:00"},"00:12:00","00:05:00","00:11:00","00:21:00","00:11:00",null,null,null,{"$f":"P30+P31","v":"00:23:00"}]
[null,null,"Minus Walking/Wait Time","W",null,{"$f":"SUMIF($E$10:$E$27,\"W\",F10:F27)","v":"00:00:00"},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00",null,null,null,{"$f":"SUMIFS(P10:P27,E10:E27,\"W\",Q10:Q27,\"median\")+SUMIFS(N10:N27,E10:E27,\"W\",Q10:Q27,\"Mode\")","v":"00:00:00"}]
[null,null,".= Processing Time","P",null,{"$f":"SUMIF($E$10:$E$27,\"P\",F10:F27)","v":"00:08:00"},"00:14:00","00:12:00","00:05:00","00:11:00","00:21:00","00:11:00",null,null,null,{"$f":"SUMIFS(P10:P27,E10:E27,\"P\",Q10:Q27,\"median\")+SUMIFS(N10:N27,E10:E27,\"P\",Q10:Q27,\"Mode\")","v":"00:23:00"}]

{"sheet":"Time Ob (Cycle - Doctor)","index":7,"n_rows":29,"n_cols":17,"rows_kept":29,"cut":false,"hidden":false,"merged":[[21,1,22,1],[21,2,22,2],[21,3,22,3],[23,1,24,1],[23,2,24,2],[23,3,24,3],[19,1,20,1],[19,2,20,2],[19,3,20,3],[13,1,14,1],[13,2,14,2],[13,3,14,3],[15,1,16,1],[15,2,16,2],[15,3,16,3],[17,1,18,1],[17,2,18,2],[17,3,18,3],[4,2,4,3],[4,4,4,5],[4,9,4,10],[4,12,4,14],[4,15,4,16],[9,1,10,1],[9,2,10,2],[9,3,10,3],[11,1,12,1],[11,2,12,2],[11,3,12,3],[3,2,3,3],[3,4,3,5],[3,6,3,8],[3,9,3,10],[0,1,0,38],[1,1,1,2],[2,2,2,3],[2,4,2,5],[2,9,2,10],[2,12,2,14],[2,15,2,16],[3,12,3,14],[3,15,3,16]]}
[null,"Time Observation Form - Cycle Time Doctor  "]
[null,"Process Boundaries"]
[null,"From","Doctors first contact with patient in SDEC",null,"Process",null,"Patient journey through SDEC",null,null,"Time Available (mins)",null,null,"Date",null,null,"13-14/06/2023"]
[null,"To","Patient discharged from SDEC",null,"Cycle",null,"SDEC Doctor Assessment and Treatment",null,null,"Demand",null,null,"Time",null,null,"09:00 - 16:00"]
[null,"Area","KGH SDEC",null,"Operator Title",null,"Doctor",null,null,"Takt Time (Sec)",null,null,"Completed By",null,null,"E. King "]
[]
[null,null,null,null,"Patient Scored >>","YES","YES","YES","YES","YES","YES","YES"]
[null,null,null,null,null,null,null,null,"Most Frequent Task Time"]
[null,"Step #","Description of Operation","Waste","Waiting/Walking Time (W) / Processing Time (P)",1,2,3,4,5,6,7,"Include zero values in Mode","Mode","Include zero values in Median","Median","Selected Value\n(User input required)"]
[null,1,"Doctor Checks Patient Notes",null,null,"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
[null,null,null,null,"P",{"$f":"IF(ISBLANK(F10),\"\",IF(ISBLANK(F12),\"\",ROUND(F12-F10,10)))","v":"00:03:00"},{"$f":"IF(ISBLANK(G10),\"\",IF(ISBLANK(G12),\"\",ROUND(G12-G10,10)))","v":"00:10:00"},"00:02:00","00:05:00","00:01:00","00:01:00","00:08:05","NO",{"$f":"IFERROR(IF(M11=\"NO\",MODE(IF($F$7:$L$7=\"YES\",IF(F11:L11>0,F11:L11))),MODE(IF($F$7:$L$7=\"YES\",F11:L11))),\"\")","v":"00:01:00"},"NO",{"$f":"IFERROR(IF(O11=\"NO\",MEDIAN(IF($F$7:$L$7=\"YES\",IF(F11:L11>0,F11:L11))),MEDIAN(IF($F$7:$L$7=\"YES\",F11:L11))),\"\")","v":"00:03:00"},"Mode"]
[null,{"$f":"B10+1","v":2},"Doctor Collects Patient",null,null,"00:03:00","00:10:00","00:02:00","00:05:00","00:01:00","00:01:00","00:08:05"]
[null,null,null,null,"W",{"$f":"IF(ISBLANK(F12),\"\",IF(ISBLANK(F14),\"\",ROUND(F14-F12,10)))","v":"00:01:00"},"00:01:00","00:02:00","00:01:00","00:01:00","00:01:00","00:00:00","NO",{"$f":"IFERROR(IF(M13=\"NO\",MODE(IF($F$7:$L$7=\"YES\",IF(F13:L13>0,F13:L13))),MODE(IF($F$7:$L$7=\"YES\",F13:L13))),\"\")","v":"00:01:00"},"NO",{"$f":"IFERROR(IF(O13=\"NO\",MEDIAN(IF($F$7:$L$7=\"YES\",IF(F13:L13>0,F13:L13))),MEDIAN(IF($F$7:$L$7=\"YES\",F13:L13))),\"\")","v":"00:01:00"},{"$f":"IF(N13=\"\",\"Median\",\"Mode\")","v":"Mode"}]
[null,{"$f":"B12+1","v":3},"Doctor Examines Patient",null,null,"00:04:00","00:11:00","00:04:00","00:06:00","00:02:00","00:02:00","00:08:05"]
[null,null,null,null,"P",{"$f":"IF(ISBLANK(F14),\"\",IF(ISBLANK(F16),\"\",ROUND(F16-F14,10)))","v":"00:28:00"},"00:18:00","00:10:00","00:07:00","00:11:00","00:15:00","00:08:21","NO",{"$f":"IFERROR(IF(M15=\"NO\",MODE(IF($F$7:$L$7=\"YES\",IF(F15:L15>0,F15:L15))),MODE(IF($F$7:$L$7=\"YES\",F15:L15))),\"\")","v":""},"NO",{"$f":"IFERROR(IF(O15=\"NO\",MEDIAN(IF($F$7:$L$7=\"YES\",IF(F15:L15>0,F15:L15))),MEDIAN(IF($F$7:$L$7=\"YES\",F15:L15))),\"\")","v":"00:11:00"},{"$f":"IF(N15=\"\",\"Median\",\"Mode\")","v":"Median"}]
[null,{"$f":"B14+1","v":4},"Extra Tests Requested",null,null,"00:32:00","00:29:00","00:14:00","00:13:00","00:13:00","00:17:00","00:16:26"]
[null,null,null,null,"P",{"$f":"IF(ISBLANK(F16),\"\",IF(ISBLANK(F18),\"\",ROUND(F18-F16,10)))","v":"00:03:00"},"00:06:00","00:03:00","00:00:00","00:00:00","00:00:00","00:04:37","NO",{"$f":"IFERROR(IF(M17=\"NO\",MODE(IF($F$7:$L$7=\"YES\",IF(F17:L17>0,F17:L17))),MODE(IF($F$7:$L$7=\"YES\",F17:L17))),\"\")","v":"00:03:00"},"NO",{"$f":"IFERROR(IF(O17=\"NO\",MEDIAN(IF($F$7:$L$7=\"YES\",IF(F17:L17>0,F17:L17))),MEDIAN(IF($F$7:$L$7=\"YES\",F17:L17))),\"\")","v":"00:03:48.500"},{"$f":"IF(N17=\"\",\"Median\",\"Mode\")","v":"Mode"}]
[null,{"$f":"B16+1","v":5},"Doctor Waits for Results",null,null,"00:35:00","00:35:00","00:17:00","00:13:00","00:13:00","00:17:00","00:21:03"]
[null,null,null,null,"W",{"$f":"IF(ISBLANK(F18),\"\",IF(ISBLANK(F20),\"\",ROUND(F20-F18,10)))","v":"00:47:00"},"00:40:00","00:40:00","00:36:00","00:46:00","00:30:00","01:24:16","NO",{"$f":"IFERROR(IF(M19=\"NO\",MODE(IF($F$7:$L$7=\"YES\",IF(F19:L19>0,F19:L19))),MODE(IF($F$7:$L$7=\"YES\",F19:L19))),\"\")","v":"00:40:00"},"NO",{"$f":"IFERROR(IF(O19=\"NO\",MEDIAN(IF($F$7:$L$7=\"YES\",IF(F19:L19>0,F19:L19))),MEDIAN(IF($F$7:$L$7=\"YES\",F19:L19))),\"\")","v":"00:40:00"},{"$f":"IF(N19=\"\",\"Median\",\"Mode\")","v":"Mode"}]
[null,{"$f":"B18+1","v":6},"Doctor Evaluates Results",null,null,"01:22:00","01:15:00","00:57:00","00:49:00","00:59:00","00:47:00","01:45:19"]
[null,null,null,null,"P",{"$f":"IF(ISBLANK(F20),\"\",IF(ISBLANK(F22),\"\",ROUND(F22-F20,10)))","v":"00:10:00"},"00:15:00","00:19:00","00:06:00","00:18:00","00:08:00","00:17:54","NO",{"$f":"IFERROR(IF(M21=\"NO\",MODE(IF($F$7:$L$7=\"YES\",IF(F21:L21>0,F21:L21))),MODE(IF($F$7:$L$7=\"YES\",F21:L21))),\"\")","v":""},"NO",{"$f":"IFERROR(IF(O21=\"NO\",MEDIAN(IF($F$7:$L$7=\"YES\",IF(F21:L21>0,F21:L21))),MEDIAN(IF($F$7:$L$7=\"YES\",F21:L21))),\"\")","v":"00:15:00"},{"$f":"IF(N21=\"\",\"Median\",\"Mode\")","v":"Median"}]
[null,{"$f":"B20+1","v":7},"Doctor Updates Careflow",null,null,"01:32:00","01:30:00","01:16:00","00:55:00","01:17:00","00:55:00","02:03:13"]
[null,null,null,null,"P",{"$f":"IF(ISBLANK(F22),\"\",IF(ISBLANK(F24),\"\",ROUND(F24-F22,10)))","v":"00:10:00"},"00:22:00","00:09:00","00:26:00","00:21:00","00:16:00","00:16:57","NO",{"$f":"IFERROR(IF(M23=\"NO\",MODE(IF($F$7:$L$7=\"YES\",IF(F23:L23>0,F23:L23))),MODE(IF($F$7:$L$7=\"YES\",F23:L23))),\"\")","v":""},"NO",{"$f":"IFERROR(IF(O23=\"NO\",MEDIAN(IF($F$7:$L$7=\"YES\",IF(F23:L23>0,F23:L23))),MEDIAN(IF($F$7:$L$7=\"YES\",F23:L23))),\"\")","v":"00:16:57"},{"$f":"IF(N23=\"\",\"Median\",\"Mode\")","v":"Median"}]
[null,{"$f":"B22+1","v":8},"Patient Discharged from SDEC",null,null,"01:42:00","01:52:00","01:25:00","01:21:00","01:38:00","01:11:00","02:20:10"]
[null,null,null,null,"P",null,null,null,null,null,null,null,"NO",{"$f":"IFERROR(IF(M25=\"NO\",MODE(IF($F$7:$L$7=\"YES\",IF(F25:L25>0,F25:L25))),MODE(IF($F$7:$L$7=\"YES\",F25:L25))),\"\")","v":""},"NO",{"$f":"IFERROR(IF(O25=\"NO\",MEDIAN(IF($F$7:$L$7=\"YES\",IF(F25:L25>0,F25:L25))),MEDIAN(IF($F$7:$L$7=\"YES\",F25:L25))),\"\")","v":""},{"$f":"IF(N25=\"\",\"Median\",\"Mode\")","v":"Median"}]
[]
[null,null,"Time For One Observation",null,null,{"$f":"F28+F29","v":"01:42:00"},"01:52:00","01:25:00","01:21:00","01:38:00","01:11:00","02:20:10",null,null,null,{"$f":"P28+P29","v":"01:27:57"}]
[null,null,"Minus Walking/Wait Time","W",null,{"$f":"SUMIF($E$10:$E$25,\"W\",F10:F25)","v":"00:48:00"},"00:41:00","00:42:00","00:37:00","00:47:00","00:31:00","01:24:16",null,null,null,{"$f":"SUMIFS(P10:P25,E10:E25,\"W\",Q10:Q25,\"median\")+SUMIFS(N10:N25,E10:E25,\"W\",Q10:Q25,\"Mode\")","v":"00:41:00"}]
[null,null,".= Processing Time","P",null,{"$f":"SUMIF($E$10:$E$25,\"P\",F10:F25)","v":"00:54:00"},"01:11:00","00:43:00","00:44:00","00:51:00","00:40:00","00:55:54",null,null,null,{"$f":"SUMIFS(P10:P25,E10:E25,\"P\",Q10:Q25,\"median\")+SUMIFS(N10:N25,E10:E25,\"P\",Q10:Q25,\"Mode\")","v":"00:46:57"}]

{"sheet":"Staff Feedback Survey Data","index":8,"n_rows":14,"n_cols":17,"rows_kept":14,"cut":false,"hidden":true,"merged":[]}
["No","Date","Role","Q1: How would you rate the new process from 1 - 5?","Why? ","Q1: How would you rate the new process from 1 - 5 Themed","Q2: Have you been clearly communicated what you should be doing? ","Comments ","Q2: Have you been clearly communicated what you should be doing? Themed","Q3: If you could describe this process  in a word, what would you choose? ","Q3: If you could describe this process  in a word, what would you choose? Themed","Q4: If you could change anything, what would you change? ","Q4: If you could change anything, what would you change? Themed","Q4: If you could change anything, what would you change? High Themed","Q5: What do you think should have been done better? ","Q5: What do you think should have been done better? Themed","Q5: What do you think should have been done better? High Themed"]
[1,"2023-06-09","Doctor (F2)",4,"Good flow of patients, but issue with ultrasound not prioritising SDEC patients","Patient flow ","Yes","Huddles are good. ","All clearly communicated","Structured","Working","Having to check the system for patients that may be suitable for SDEC from rafting.","IT systems monitoring","IT","Better communication with other departments- some had not heard of SDEC.","Clearer communication.","Communication"]
[2,"2023-06-09","Nurse in Charge",4,"Appropriate patients are being identified for the are. Only problems today are IT related (Patient Flow and Care Flow not mirroring) ","Clear Criteria ","Yes","Received email before but prefers learning on the job/in practice.","All clearly communicated","Efficient","Working","IT systems - Patient Flow and Care Flow need to mirror each other so staff don't have to type in information twice.","IT systems mirroring","IT","It could have been made more clear that Majors B will no longer exist and become SDEC as we thought SDEC was just going to be part of the area. ","Clearer communication.","Communication"]
[3,"2023-06-09","Nurse in Charge",5,"Exclusions are clear - we know what type of patients are suitable. Huddles are working well. ","Clear Criteria ","Yes","Email received and also had MS Teams session about Patient Flow Whiteboard. ","All clearly communicated","Excellent","Working","IT systems - not mirroring each other, have to enter data in severak places e.g. on VitalPac and Care Flow","IT systems mirroring","IT","Having a visible list of all staff who have received training on the new process so you know who is on shift that know what is happening and who may need more support. ","Training database.","Training"]
[4,"2023-06-09","HCA ",4,"It's a new process but going well so far. Good flow today. ","Patient flow","Yes","Clear on patient criteria and on own role. ","All clearly communicated","Good","Working","SDEC patients not visible on VitalPac Device of HCA in waiting area for monitoring of obs. ","IT systems errors","IT"]
[5,"2023-06-13","Doctor",4,"Good flow of patients. Still room for improvement with examination room set up","Patient flow ","Yes","Confident and competent","All clearly communicated","Good","Working","Entering information on Care Flow is very time consuming","IT systems mirroring","IT","Set up of examination rooms- have already changed once","Layout","Layout"]
[6,"2023-06-13","Nurse in Charge",3,"Very new process and first day for staff member. IT related issues","IT","Yes","Read the presentation but otherwise learning as I go.","All clearly communicated","Okay","Working","IT system","IT system","IT","More training on IT system","IT Training","Training"]
[7,"2023-06-14","Doctor",4,"Good flow in SDEC but can see patients waiting to be moved over from 'Rafting'.","Patient flow","Yes","Good commication between others and at huddles","All clearly communicated","Good","Working","All the duplicate information required to be added onto Careflow","IT systems mirroring","IT","Communication with other departments, unless you have worked on SDEC some people are still unaware.","Clearer communication.","Communication"]
[8,null,"Question 5 Comment from 1",null,null,null,null,null,null,null,null,null,null,"Communication"]
[9,null,"Question 5 Comment from 2",null,null,null,null,null,null,null,null,null,null,"Communication"]
[10,null,"Question 5 Comment from 3",null,null,null,null,null,null,null,null,null,null,"Training"]
[11,null,"Question 5 Comment from 4",null,null,null,null,null,null,null,null,null,null,"Layout"]
[12,null,"Question 5 Comment from 5",null,null,null,null,null,null,null,null,null,null,"Training"]
[13,null,"Question 5 Comment from 6",null,null,null,null,null,null,null,null,null,null,"Communication"]

{"sheet":"Staff Feedback Survey Data 1","index":9,"n_rows":43,"n_cols":17,"rows_kept":43,"cut":false,"hidden":true,"merged":[]}
["No","Date","Role","Q1: How would you rate the new process from 1 - 5?","Why? ","Q1: How would you rate the new process from 1 - 5 Themed","Q2: Have you been clearly communicated what you should be doing? ","Comments ","Q2: Have you been clearly communicated what you should be doing? Themed","Q3: If you could describe this process  in a word, what would you choose? ","Q3: If you could describe this process  in a word, what would you choose? Themed","Q4: If you could change anything, what would you change? ","Q4: If you could change anything, what would you change? Themed","Q4: If you could change anything, what would you change? High Themed","Q5: What do you think should have been done better? ","Q5: What do you think should have been done better? Themed","Q5: What do you think should have been done better? High Themed"]
[1,"2023-06-09","Doctor (F2)",4,"Good flow of patients, but issue with ultrasound not prioritising SDEC patients","Patient flow ","Yes","Huddles are good. ","Huddles","Structured","Working","Having to check the system for patients that may be suitable for SDEC from rafting.","IT systems monitoring","IT","Better communication with other departments- some had not heard of SDEC.","Clearer communication.","Communication"]
[2,"2023-06-09","Nurse in Charge",4,"Appropriate patients are being identified for the are. Only problems today are IT related (Patient Flow and Care Flow not mirroring) ","IT - Patient Flow and Care Flow systems","Yes ","Received email before but prefers learning on the job/in practice.","Practical Learning","Efficient","Working ","IT systems - Patient Flow and Care Flow need to mirror each other so staff don't have to type in information twice.","IT systems mirroring","IT","It could have been made more clear that Majors B will no longer exist and become SDEC as we thought SDEC was just going to be part of the area. ","Clearer communication.","Communication"]
[3,"2023-06-09","Nurse in Charge",5,"Exclusions are clear - we know what type of patients are suitable. Huddles are working well. ","Clear Criteria ","Yes","Email received and also had MS Teams session about Patient Flow Whiteboard. ","MS Teams sessions","Excellent","Working ","IT systems - not mirroring each other, have to enter data in severak places e.g. on VitalPac and Care Flow","IT systems mirroring","IT","Having a visible list of all staff who have received training on the new process so you know who is on shift that know what is happening and who may need more support. ","Training database.","Training"]
[4,"2023-06-09","HCA ",4,"It's a new process but going well so far. Good flow today. ","Patient flow","Yes","Clear on patient criteria and on own role. ","Criteria + Roles ","Good","Working","SDEC patients not visible on VitalPac Device of HCA in waiting area for monitoring of obs. ","IT systems errors","IT","N/A","N/A","N/A"]
[5,"2023-06-13","Doctor",4,"Good flow of patients. Still room for improvement with examination room set up","Patient flow ","Yes","Confident and competent","Criteria + Roles ","Good","Working","Entering information on Care Flow is very time consuming","IT mirroring","IT","Set up of examination rooms- have already changed once","Layout","Layout"]
[6,"2023-06-13","Nurse in Charge",3,"Very new process and first day for staff member. IT related issues","IT","Yes and no","Read the presentation but otherwise learning as I go.","Practical Learning ","Okay","Working","IT system","IT system","IT","More training on IT system","IT Training","Training"]
[7,"2023-06-14","Doctor",4,"Good flow in SDEC but can see patients waiting to be moved over from 'Rafting'.","Patient flow","Yes","Good commication between others and at huddles","Huddles","Good","Working","All the duplicate information required to be added onto Careflow","IT systems mirroring","IT","Communication with other departments, unless you have worked on SDEC some people are still unaware.","Clearer communication.","Communication"]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[15]
[16]
[17]
[18]
[19]
[20]
[21]
[22]
[23]
[24]
[25]
[26]
[27]
[28]
[29]
[30]
[31]
[32]
[33]
[34]
[35]
[36]
[37]
[38]
[39]
[40]
[41]
[42]

{"sheet":"Staff Survey pivot table","index":10,"n_rows":24,"n_cols":34,"rows_kept":24,"cut":false,"hidden":true,"merged":[[2,1,2,12],[2,14,2,15],[2,19,2,20],[2,25,2,26],[2,30,2,31]]}
[]
[]
[null,"Process rating. (Median)",null,null,null,null,null,null,null,null,null,null,null,null,"Process rating reason",null,null,null,null,"Understanding your role.",null,null,null,null,null,"Describe Process in one word.",null,null,null,null,"What would you change?"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",{"$f":"SUM(P7:P1048576)","v":7},null,null,null,"Total",{"$f":"SUM(V7:V1048576)","v":7},null,null,null,null,"Total",{"$f":"SUM(AA7:AA1048576)","v":7},null,null,null,"Total",{"$f":"SUM(AF7:AF1048576)","v":13}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Count of No",null,null,null,null,"Count of No",null,null,null,null,null,"Count of No",null,null,null,null,"Count of No"]
[null,"Role","Q1: How would you rate the new process from 1 - 5?",null,null,null,null,null,null,null,"Role","Process rating.","Process Median",null,"Q1: How would you rate the new process from 1 - 5 Themed","Total",null,null,null,"Q2: Have you been clearly communicated what you should be doing? Themed","Q2: Have you been clearly communicated what you should be doing? ","Total",null,null,null,"Q3: If you could describe this process  in a word, what would you choose? Themed","Total",null,null,null,"Q4: If you could change anything, what would you change? High Themed","Total"]
[null,"Doctor (F2)",4,null,null,null,null,null,null,null,{"$f":"$B$7","v":"Doctor (F2)"},{"$f":"C7","v":4},{"$f":"MEDIAN(L7:L1048576)","v":4},null,"Patient flow ",2,{"$f":"O7","v":"Patient flow "},{"$f":"P7/$P$4","v":0.2857142857142857},null,"All clearly communicated","Yes",7,{"$f":"T7","v":"All clearly communicated"},{"$f":"V7/$U$4","v":1},null,"Working",7,{"$f":"Z7","v":"Working"},{"$f":"(AA8+AA7)/AA4","v":1},null,"Communication",3,{"$f":"AE7","v":"Communication"},{"$f":"AF7/$AF$4","v":0.23076923076923078}]
[null,"Nurse in Charge",3,null,null,null,null,null,null,null,{"$f":"$B$8","v":"Nurse in Charge"},3,null,null,"Clear Criteria ",2,{"$f":"O8","v":"Clear Criteria "},{"$f":"P8/$P$4","v":0.2857142857142857},null,null,null,null,null,null,null,null,null,null,null,null,"IT",7,{"$f":"AE8","v":"IT"},{"$f":"AF8/$AF$4","v":0.53846153846153844}]
[null,null,4,null,null,null,null,null,null,null,{"$f":"$B$8","v":"Nurse in Charge"},4,null,null,"Patient flow",2,"Patient flow",0.2857142857142857,null,null,null,null,null,null,null,null,null,null,null,null,"Layout",1,{"$f":"AE9","v":"Layout"},7.6923076923076927E-2]
[null,null,5,null,null,null,null,null,null,null,"Nurse in Charge",5,null,null,"IT",1,"IT",0.14285714285714285,null,null,null,null,null,null,null,null,null,null,null,null,"Training",2,{"$f":"AE10","v":"Training"},0.15384615384615385]
[null,"HCA ",4,null,null,null,null,null,null,null,{"$f":"$B$11","v":"HCA "},4]
[null,"Doctor",4,null,null,null,null,null,null,null,{"$f":"$B$12","v":"Doctor"},4]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"z"]

{"sheet":"Patient Survey data","index":11,"n_rows":9,"n_cols":12,"rows_kept":9,"cut":false,"hidden":true,"merged":[]}
[]
["No","Date","Patient","Q1: Did you receive good care today? If no, specify the reason why","Q1: Did you receive good care today? If no, specify the reason why  (One Word)","Why? ","Q2: Have you been clearly communicated what your plan was? ","Q2: Have you been clearly communicated what your plan was?  (One Word)","Q3: If you could describe this process  in a word, what would you choose? ","Q3: If you could describe this process  in a word, what would you choose? Themed","Q4: If you could change anything, what would you change? ","Q4: If you could change anything, what would you change? Themed"]
[1,"2023-06-09","Patient","Not dissatisfied or satisfied, good care but unknown wait time","Yes","Wait time","Clear communication of plan but unknown wait time, may be returning tomorrow for ultrasound.","Yes","Inconsistent","Poor","Would rather be told to come back tomorrow rather than wait","Waiting"]
[2,"2023-06-13","Patient","Yes, but it took too much time.","Yes","Wait time","Yes","Yes","Good","Working","Make it a shorter time. ","Waiting"]
[3,"2023-06-13","Patient","Yes, expected to wait a lot longer","Yes","Wait time","Yes, both doctor and nurses have confirmed plan","Yes","Great","Working","More privacy between chairs","Privacy"]
[4,"2023-06-14","Patient","Average, didn't have to wait long to be seen but ideally need a bed to lay flat. Was told we couldn't lay on the beds even though they were free.","Yes","Suitable equipment","Unknown as waiting for results","No ","Okay","Working","Would be more comfortable to lay in a bed","Equipment"]
[5,"2023-06-14","Patient","Yes, staff were nice","Yes","Staff","Yes","Yes","Good","Working","Patient had to walk between assessment area and waiting area multiple times, uncomfortable to walk.","Layout"]
[6,"2023-06-14","Patient","Yes, but wait was very long","Yes","Wait time","Yes","Yes","Good","Working","Less time waiting","Waiting "]
[7,"2023-06-14","Patient","Yes, doctors very good but were not informed when we could leave","Yes","Staff","Yes","Yes","Good","Working","More staff","Staff"]

{"sheet":"Patient Survey data 1","index":12,"n_rows":9,"n_cols":11,"rows_kept":9,"cut":false,"hidden":true,"merged":[]}
[]
["No","Date","Patient","Q1: Did you receive good care today? If no, specify the reason why","Why? ","Q2: Have you been clearly communicated what your plan was? ","Q2: Have you been clearly communicated what your plan was?  (One Word)","Q3: If you could describe this process  in a word, what would you choose? ","Q3: If you could describe this process  in a word, what would you choose? Themed","Q4: If you could change anything, what would you change? ","Q4: If you could change anything, what would you change? Themed"]
[1,"2023-06-09","Patient","Not dissatisfied or satisfied, good care but unknown wait time","Wait time","Clear communication of plan but unknown wait time, may be returning tomorrow for ultrasound.","Yes","Inconsistent","Poor","Would rather be told to come back tomorrow rather than wait","Waiting"]
[2,"2023-06-13","Patient","Yes, but it took too much time.","Wait time","Yes","Yes","Good","Working","Make it a shorter time. ","Waiting"]
[3,"2023-06-13","Patient","Yes, expected to wait a lot longer","Wait time","Yes, both doctor and nurses have confirmed plan","Yes","Great","Working","More privacy between chairs","Privacy"]
[4,"2023-06-14","Patient","Average, didn't have to wait long to be seen but ideally need a bed to lay flat. Was told we couldn't lay on the beds even though they were free.","Suitable equipment","Unknown as waiting for results","No ","Okay","Working","Would be more comfortable to lay in a bed","Equipment"]
[5,"2023-06-14","Patient","Yes, staff were nice","Staff","Yes","Yes","Good","Working","Patient had to walk between assessment area and waiting area multiple times, uncomfortable to walk.","Layout"]
[6,"2023-06-14","Patient","Yes, but wait was very long","Wait time","Yes","Yes","Good","Working","Less time waiting","Waiting "]
[7,"2023-06-14","Patient","Yes, doctors very good but were not informed when we could leave","Staff","Yes","Yes","Good","Working","More staff","Staff"]

{"sheet":"Patient Survey pivot tables","index":13,"n_rows":13,"n_cols":26,"rows_kept":13,"cut":false,"hidden":true,"merged":[[1,1,1,5],[1,9,1,12],[1,15,1,18]]}
[]
[null,"Did you recieve good care today?",null,null,null,null,null,null,null,"Was your plan communicated clearly?  ",null,null,null,null,null,"Was your plan communicated clearly?  ",null,null,null,null,null,null,"Was your plan communicated clearly?  "]
[]
[]
[null,"Total",{"$f":"SUM(C7:C1048576)","v":7},null,null,null,null,null,null,"Total",{"$f":"SUM(K7:K1048576)","v":7},null,null,null,null,"Total",{"$f":"SUM(Q8:Q1048576)","v":7},null,null,null,null,null,"Total",{"$f":"SUM(X8:X1048576)","v":7}]
[null,"Count of Patient",null,"Did you recieve good care today?",null,null,null,null,null,"Count of Patient",null,"Did you recieve good care today?",null,null,null,"Count of Patient",null,"Did you recieve good care today?",null,null,null,null,"Count of Patient",null,"Did you recieve good care today?"]
[null,"Q1: Did you receive good care today? If no, specify the reason why  (One Word)","Total",null,"Did you recieve good care today?",null,null,null,null,"Q2: Have you been clearly communicated what your plan was?  (One Word)","Total",null,null,null,null,"Q3: If you could describe this process  in a word, what would you choose? Themed","Total",null,null,null,null,null,"Q4: If you could change anything, what would you change? Themed","Total"]
[null,"Yes",7,{"$f":"B8","v":"Yes"},{"$f":"C8/C5","v":1},null,null,null,null,"Yes",6,{"$f":"J8","v":"Yes"},{"$f":"K8/$K$5","v":0.8571428571428571},null,null,"Poor",1,{"$f":"P8","v":"Poor"},{"$f":"Q8/$Q$5","v":0.14285714285714285},null,null,null,"Waiting",2,{"$f":"W8","v":"Waiting"},{"$f":"X8/$X$5","v":0.2857142857142857}]
[null,null,null,null,null,null,null,null,null,"No ",1,{"$f":"J9","v":"No "},{"$f":"K9/$K$5","v":0.14285714285714285},null,null,"Working",6,{"$f":"P9","v":"Working"},{"$f":"Q9/$Q$5","v":0.8571428571428571},null,null,null,"Privacy",1,{"$f":"W9","v":"Privacy"},{"$f":"X9/$X$5","v":0.14285714285714285}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Equipment",1,"Equipment",0.14285714285714285]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Layout",1,"Layout",0.14285714285714285]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Waiting ",1,"Waiting ",0.14285714285714285]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Staff",1,{"$f":"W13","v":"Staff"},{"$f":"X13/$X$5","v":0.14285714285714285}]