{"text_format":"1","workbook":"xlsx","n_sheets":26,"sheets":["Overview","How to use","Enter new data","Week view - LowDep","Week view - HighDep","Week view - ModerateDep","Week view - TotalDep","Week view - Waitbed","Calculation","Day 1","Day 2","Day 3","Day 4","Day 5","Day 6","Day 7","WTE Skills Mix","Daily Comparison graphs","Calculations for wkly graph","Wkly Staffing Comparison Graph","Calculated staffing per hour","JDT Adult - Section A","JDT Child - Section A","JDT - Section B","Appendix D - Hourly Tool","JDT Cummulative Hourly totals"],"not_rendered":{"charts":9,"images":7,"macros":1,"external_links":0,"defined_names":0,"comments":12,"pivot_tables":0},"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":"Overview","index":0,"n_rows":58,"n_cols":1,"rows_kept":58,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Appendices:"]
["How to use BEST"]
["Appendix A - Adult JDT"]
["Appendix B - Nursing workload sheet for confirming patient category"]
["Appendix C -  Children’s JDT"]
["Appendix D - Hourly data collection tool"]
["Appendix E - Cumulative hourly totals"]

{"sheet":"How to use","index":1,"n_rows":123,"n_cols":13,"rows_kept":123,"cut":false,"hidden":false,"merged":[[122,5,122,6],[122,12,122,13]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Enter data",null,null,null,null,null,null,"Return to summary"]

{"sheet":"Enter new data","index":2,"n_rows":35,"n_cols":19,"rows_kept":35,"cut":false,"hidden":false,"merged":[[2,8,2,10],[1,3,1,6]]}
[]
["Name of date range"]
[null,null,null,null,null,null,null,null,"LISTS"]
[null,null,"Day","Month","Year","Number of patients per JDT score",null,null,"Day","Month","Year"]
[null,null,null,null,null,null,null,null,1,"January",2017,null,"Drop down value - day","Real value - Day","Drop down value - month","Real value - month","Real value text","Drop down value - year","Real value - year"]
["Day one",null,null,null,null,"Add/edit data",null,null,2,"February",2018,"Day 1",2,{"$f":"M6-1","v":1},3,{"$f":"O6-1","v":2},{"$f":"IF(P6=0,\" \",IF(P6=1,\"January\",IF(P6=2,\"February\",IF(P6=3,\"March\",IF(P6=4,\"April\",IF(P6=5,\"May\",IF(P6=6,\"June\",IF(P6=7,\"July\",IF(P6=8,\"August\",IF(P6=9,\"September\",IF(P6=10,\"October\",IF(P6=11,\"November\",IF(P6=12,\"December\")))))))))))))","v":"February"},6,{"$f":"IF(R6=1,\" \",IF(R6=2,\"2017\",IF(R6=3,\"2018\",IF(R6=4,\"2019\",IF(R6=5,\"2020\",IF(R6=6,\"2021\",IF(R6=7,\"2022\",IF(R6=8,\"2023\"))))))))","v":"2021"}]
[null,null,null,null,null,null,null,null,3,"March",2019]
["Day two",null,null,null,null,"Add/edit data",null,null,4,"April",2020,"Day 2",3,{"$f":"M8-1","v":2},2,{"$f":"O8-1","v":1},{"$f":"IF(P8=0,\" \",IF(P8=1,\"January\",IF(P8=2,\"February\",IF(P8=3,\"March\",IF(P8=4,\"April\",IF(P8=5,\"May\",IF(P8=6,\"June\",IF(P8=7,\"July\",IF(P8=8,\"August\",IF(P8=9,\"September\",IF(P8=10,\"October\",IF(P8=11,\"November\",IF(P8=12,\"December\")))))))))))))","v":"January"},3,{"$f":"IF(R8=1,\" \",IF(R8=2,\"2017\",IF(R8=3,\"2018\",IF(R8=4,\"2019\",IF(R8=5,\"2020\",IF(R8=6,\"2021\",IF(R8=7,\"2022\",IF(R8=8,\"2023\"))))))))","v":"2018"}]
[null,null,null,null,null,null,null,null,5,"May",2021,null,null,null,null,null," "]
["Day three",null,null,null,null,"Add/edit data",null,null,6,"June",2022,"Day 3",4,3,2,1,"January",3,"2018"]
[null,null,null,null,null,null,null,null,7,"July",2023]
["Day four",null,null,null,null,"Add/edit data",null,null,8,"August",null,"Day 4",5,4,2,1,"January",3,"2018"]
[null,null,null,null,null,null,null,null,9,"September"]
["Day five",null,null,null,null,"Add/edit data",null,null,10,"October",null,"Day 5",6,5,2,1,"January",3,"2018"]
[null,null,null,null,null,null,null,null,11,"November"]
["Day six",null,null,null,null,"Add/edit data",null,null,12,"December",null,"Day 6",7,6,2,1,"January",3,"2018"]
[null,null,null,null,null,null,null,null,13]
["Day seven",null,null,null,null,"Add/edit data",null,null,14,null,null,"Day 7",8,7,2,1,"January",3,"2018"]
[null,null,null,null,null,null,null,null,15]
[null,null,null,null,null,null,null,null,16]
[null,null,null,"Return to 'How to Use' guide",null,null,null,null,17,null,null,null,"Date","Month","Year"]
[null,null,null,null,null,null,null,null,18,null,null,"Day 1",{"$f":"N6","v":1},{"$f":"Q6","v":"February"},{"$f":"S6","v":"2021"},{"$f":"CONCATENATE(M22,\" \",N22,\" \",O22)","v":"1 February 2021"}]
[null,null,null,null,null,null,null,null,19,null,null,"Day 2",{"$f":"N8","v":2},{"$f":"Q8","v":"January"},{"$f":"S8","v":"2018"},{"$f":"CONCATENATE(M23,\" \",N23,\" \",O23)","v":"2 January 2018"}]
[null,null,null,null,null,null,null,null,20,null,null,"Day 3",{"$f":"N10","v":3},{"$f":"Q10","v":"January"},{"$f":"S10","v":"2018"},"3 January 2018"]
[null,null,null,null,null,null,null,null,21,null,null,"Day 4",{"$f":"N12","v":4},{"$f":"Q12","v":"January"},{"$f":"S12","v":"2018"},"4 January 2018"]
[null,null,null,null,null,null,null,null,22,null,null,"Day 5",{"$f":"N14","v":5},{"$f":"Q14","v":"January"},{"$f":"S14","v":"2018"},"5 January 2018"]
[null,null,null,null,null,null,null,null,23,null,null,"Day 6",{"$f":"N16","v":6},{"$f":"Q16","v":"January"},{"$f":"S16","v":"2018"},"6 January 2018"]
[null,null,null,null,null,null,null,null,24,null,null,"Day 7",{"$f":"N18","v":7},{"$f":"Q18","v":"January"},{"$f":"S18","v":"2018"},"7 January 2018"]
[null,null,null,null,null,null,null,null,25]
[null,null,null,null,null,null,null,null,26]
[null,null,null,null,null,null,null,null,27]
[null,null,null,null,null,null,null,null,28]
[null,null,null,null,null,null,null,null,29]
[null,null,null,null,null,null,null,null,30]
[null,null,null,null,null,null,null,null,31]

{"sheet":"Week view - LowDep","index":3,"n_rows":27,"n_cols":12,"rows_kept":27,"cut":false,"hidden":true,"merged":[[0,0,0,7]]}
["LOW DEPENDENCY"]
[]
[null,"Day 1","Day 2","Day 3","Day 4","Day 5","Day 6","Day 7",null,"80th perc","staffing","\"+6.25%\""]
["01:00:00",{"$f":"'Day 1'!C4","v":0},{"$f":"'Day 2'!C4","v":0},{"$f":"'Day 3'!C4","v":0},{"$f":"'Day 4'!C4","v":0},{"$f":"'Day 5'!C4","v":0},{"$f":"'Day 6'!C4","v":0},{"$f":"'Day 7'!C4","v":0},{"$f":"A4","v":4.1666666666666664E-2},{"$f":"IFERROR(PERCENTILE(B4:H4,0.8),0)","v":0},{"$f":"PRODUCT(J4,0.286)","v":0},{"$f":"K4/100 *6.25+K4","v":0}]
["02:00:00",{"$f":"'Day 1'!C5","v":0},{"$f":"'Day 2'!C5","v":0},{"$f":"'Day 3'!C5","v":0},{"$f":"'Day 4'!C5","v":0},{"$f":"'Day 5'!C5","v":0},{"$f":"'Day 6'!C5","v":0},{"$f":"'Day 7'!C5","v":0},8.3333333333333301E-2,{"$f":"IFERROR(PERCENTILE(B5:H5,0.8),0)","v":0},{"$f":"PRODUCT(J5,0.286)","v":0},{"$f":"K5/100 *6.25+K5","v":0}]
["03:00:00",{"$f":"'Day 1'!C6","v":0},{"$f":"'Day 2'!C6","v":0},{"$f":"'Day 3'!C6","v":0},{"$f":"'Day 4'!C6","v":0},{"$f":"'Day 5'!C6","v":0},{"$f":"'Day 6'!C6","v":0},{"$f":"'Day 7'!C6","v":0},0.125,0,0,0]
["04:00:00",{"$f":"'Day 1'!C7","v":0},{"$f":"'Day 2'!C7","v":0},{"$f":"'Day 3'!C7","v":0},{"$f":"'Day 4'!C7","v":0},{"$f":"'Day 5'!C7","v":0},{"$f":"'Day 6'!C7","v":0},{"$f":"'Day 7'!C7","v":0},0.16666666666666699,0,0,0]
["05:00:00",{"$f":"'Day 1'!C8","v":0},{"$f":"'Day 2'!C8","v":0},{"$f":"'Day 3'!C8","v":0},{"$f":"'Day 4'!C8","v":0},{"$f":"'Day 5'!C8","v":0},{"$f":"'Day 6'!C8","v":0},{"$f":"'Day 7'!C8","v":0},0.20833333333333301,0,0,0]
["06:00:00",{"$f":"'Day 1'!C9","v":0},{"$f":"'Day 2'!C9","v":0},{"$f":"'Day 3'!C9","v":0},{"$f":"'Day 4'!C9","v":0},{"$f":"'Day 5'!C9","v":0},{"$f":"'Day 6'!C9","v":0},{"$f":"'Day 7'!C9","v":0},0.25,0,0,0]
["07:00:00",{"$f":"'Day 1'!C10","v":0},{"$f":"'Day 2'!C10","v":0},{"$f":"'Day 3'!C10","v":0},{"$f":"'Day 4'!C10","v":0},{"$f":"'Day 5'!C10","v":0},{"$f":"'Day 6'!C10","v":0},{"$f":"'Day 7'!C10","v":0},0.29166666666666702,0,0,0]
["08:00:00",{"$f":"'Day 1'!C11","v":0},{"$f":"'Day 2'!C11","v":0},{"$f":"'Day 3'!C11","v":0},{"$f":"'Day 4'!C11","v":0},{"$f":"'Day 5'!C11","v":0},{"$f":"'Day 6'!C11","v":0},{"$f":"'Day 7'!C11","v":0},0.33333333333333298,0,0,0]
["09:00:00",{"$f":"'Day 1'!C12","v":0},{"$f":"'Day 2'!C12","v":0},{"$f":"'Day 3'!C12","v":0},{"$f":"'Day 4'!C12","v":0},{"$f":"'Day 5'!C12","v":0},{"$f":"'Day 6'!C12","v":0},{"$f":"'Day 7'!C12","v":0},0.375,0,0,0]
["10:00:00",{"$f":"'Day 1'!C13","v":0},{"$f":"'Day 2'!C13","v":0},{"$f":"'Day 3'!C13","v":0},{"$f":"'Day 4'!C13","v":0},{"$f":"'Day 5'!C13","v":0},{"$f":"'Day 6'!C13","v":0},{"$f":"'Day 7'!C13","v":0},0.41666666666666702,0,0,0]
["11:00:00",{"$f":"'Day 1'!C14","v":0},{"$f":"'Day 2'!C14","v":0},{"$f":"'Day 3'!C14","v":0},{"$f":"'Day 4'!C14","v":0},{"$f":"'Day 5'!C14","v":0},{"$f":"'Day 6'!C14","v":0},{"$f":"'Day 7'!C14","v":0},0.45833333333333398,0,0,0]
["12:00:00",{"$f":"'Day 1'!C15","v":0},{"$f":"'Day 2'!C15","v":0},{"$f":"'Day 3'!C15","v":0},{"$f":"'Day 4'!C15","v":0},{"$f":"'Day 5'!C15","v":0},{"$f":"'Day 6'!C15","v":0},{"$f":"'Day 7'!C15","v":0},0.5,0,0,0]
["13:00:00",{"$f":"'Day 1'!C16","v":0},{"$f":"'Day 2'!C16","v":0},{"$f":"'Day 3'!C16","v":0},{"$f":"'Day 4'!C16","v":0},{"$f":"'Day 5'!C16","v":0},{"$f":"'Day 6'!C16","v":0},{"$f":"'Day 7'!C16","v":0},0.54166666666666696,0,0,0]
["14:00:00",{"$f":"'Day 1'!C17","v":0},{"$f":"'Day 2'!C17","v":0},{"$f":"'Day 3'!C17","v":0},{"$f":"'Day 4'!C17","v":0},{"$f":"'Day 5'!C17","v":0},{"$f":"'Day 6'!C17","v":0},{"$f":"'Day 7'!C17","v":0},0.58333333333333404,0,0,0]
["15:00:00",{"$f":"'Day 1'!C18","v":0},{"$f":"'Day 2'!C18","v":0},{"$f":"'Day 3'!C18","v":0},{"$f":"'Day 4'!C18","v":0},{"$f":"'Day 5'!C18","v":0},{"$f":"'Day 6'!C18","v":0},{"$f":"'Day 7'!C18","v":0},0.625,0,0,0]
["16:00:00",{"$f":"'Day 1'!C19","v":0},{"$f":"'Day 2'!C19","v":0},{"$f":"'Day 3'!C19","v":0},{"$f":"'Day 4'!C19","v":0},{"$f":"'Day 5'!C19","v":0},{"$f":"'Day 6'!C19","v":0},{"$f":"'Day 7'!C19","v":0},0.66666666666666696,0,0,0]
["17:00:00",{"$f":"'Day 1'!C20","v":0},{"$f":"'Day 2'!C20","v":0},{"$f":"'Day 3'!C20","v":0},{"$f":"'Day 4'!C20","v":0},{"$f":"'Day 5'!C20","v":0},{"$f":"'Day 6'!C20","v":0},{"$f":"'Day 7'!C20","v":0},0.70833333333333404,0,0,0]
["18:00:00",{"$f":"'Day 1'!C21","v":0},{"$f":"'Day 2'!C21","v":0},{"$f":"'Day 3'!C21","v":0},{"$f":"'Day 4'!C21","v":0},{"$f":"'Day 5'!C21","v":0},{"$f":"'Day 6'!C21","v":0},{"$f":"'Day 7'!C21","v":0},0.75,0,0,0]
["19:00:00",{"$f":"'Day 1'!C22","v":0},{"$f":"'Day 2'!C22","v":0},{"$f":"'Day 3'!C22","v":0},{"$f":"'Day 4'!C22","v":0},{"$f":"'Day 5'!C22","v":0},{"$f":"'Day 6'!C22","v":0},{"$f":"'Day 7'!C22","v":0},0.79166666666666696,0,0,0]
["20:00:00",{"$f":"'Day 1'!C23","v":0},{"$f":"'Day 2'!C23","v":0},{"$f":"'Day 3'!C23","v":0},{"$f":"'Day 4'!C23","v":0},{"$f":"'Day 5'!C23","v":0},{"$f":"'Day 6'!C23","v":0},{"$f":"'Day 7'!C23","v":0},0.83333333333333404,0,0,0]
["21:00:00",{"$f":"'Day 1'!C24","v":0},{"$f":"'Day 2'!C24","v":0},{"$f":"'Day 3'!C24","v":0},{"$f":"'Day 4'!C24","v":0},{"$f":"'Day 5'!C24","v":0},{"$f":"'Day 6'!C24","v":0},{"$f":"'Day 7'!C24","v":0},0.875,0,0,0]
["22:00:00",{"$f":"'Day 1'!C25","v":0},{"$f":"'Day 2'!C25","v":0},{"$f":"'Day 3'!C25","v":0},{"$f":"'Day 4'!C25","v":0},{"$f":"'Day 5'!C25","v":0},{"$f":"'Day 6'!C25","v":0},{"$f":"'Day 7'!C25","v":0},0.91666666666666696,0,0,0]
["23:00:00",{"$f":"'Day 1'!C26","v":0},{"$f":"'Day 2'!C26","v":0},{"$f":"'Day 3'!C26","v":0},{"$f":"'Day 4'!C26","v":0},{"$f":"'Day 5'!C26","v":0},{"$f":"'Day 6'!C26","v":0},{"$f":"'Day 7'!C26","v":0},0.95833333333333404,0,0,0]
[1,{"$f":"'Day 1'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Day 2'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Day 3'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Day 4'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Day 5'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Day 6'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Day 7'!#REF!","v":{"$error":"#REF!"}},1,0,0,0]

{"sheet":"Week view - HighDep","index":4,"n_rows":27,"n_cols":12,"rows_kept":27,"cut":false,"hidden":true,"merged":[[0,0,0,7]]}
["HIGH DEPENDENCY"]
[]
[null,"Day 1","Day 2","Day 3","Day 4","Day 5","Day 6","Day 7",null,"80th perc","staffing","\"+6.25%\""]
["01:00:00",{"$f":"'Day 1'!E4","v":0},{"$f":"'Day 2'!E4","v":0},{"$f":"'Day 3'!E4","v":0},{"$f":"'Day 4'!E4","v":0},{"$f":"'Day 5'!E4","v":0},{"$f":"'Day 6'!E4","v":0},{"$f":"'Day 7'!E4","v":0},{"$f":"A4","v":4.1666666666666664E-2},{"$f":"IFERROR(PERCENTILE(B4:H4,0.8),0)","v":0},{"$f":"J4","v":0},{"$f":"K4/100 *6.25+K4","v":0}]
["02:00:00",{"$f":"'Day 1'!E5","v":0},{"$f":"'Day 2'!E5","v":0},{"$f":"'Day 3'!E5","v":0},{"$f":"'Day 4'!E5","v":0},{"$f":"'Day 5'!E5","v":0},{"$f":"'Day 6'!E5","v":0},{"$f":"'Day 7'!E5","v":0},8.3333333333333301E-2,{"$f":"IFERROR(PERCENTILE(B5:H5,0.8),0)","v":0},{"$f":"J5","v":0},{"$f":"K5/100 *6.25+K5","v":0}]
["03:00:00",{"$f":"'Day 1'!E6","v":0},{"$f":"'Day 2'!E6","v":0},{"$f":"'Day 3'!E6","v":0},{"$f":"'Day 4'!E6","v":0},{"$f":"'Day 5'!E6","v":0},{"$f":"'Day 6'!E6","v":0},{"$f":"'Day 7'!E6","v":0},0.125,0,0,0]
["04:00:00",{"$f":"'Day 1'!E7","v":0},{"$f":"'Day 2'!E7","v":0},{"$f":"'Day 3'!E7","v":0},{"$f":"'Day 4'!E7","v":0},{"$f":"'Day 5'!E7","v":0},{"$f":"'Day 6'!E7","v":0},{"$f":"'Day 7'!E7","v":0},0.16666666666666699,0,0,0]
["05:00:00",{"$f":"'Day 1'!E8","v":0},{"$f":"'Day 2'!E8","v":0},{"$f":"'Day 3'!E8","v":0},{"$f":"'Day 4'!E8","v":0},{"$f":"'Day 5'!E8","v":0},{"$f":"'Day 6'!E8","v":0},{"$f":"'Day 7'!E8","v":0},0.20833333333333301,0,0,0]
["06:00:00",{"$f":"'Day 1'!E9","v":0},{"$f":"'Day 2'!E9","v":0},{"$f":"'Day 3'!E9","v":0},{"$f":"'Day 4'!E9","v":0},{"$f":"'Day 5'!E9","v":0},{"$f":"'Day 6'!E9","v":0},{"$f":"'Day 7'!E9","v":0},0.25,0,0,0]
["07:00:00",{"$f":"'Day 1'!E10","v":0},{"$f":"'Day 2'!E10","v":0},{"$f":"'Day 3'!E10","v":0},{"$f":"'Day 4'!E10","v":0},{"$f":"'Day 5'!E10","v":0},{"$f":"'Day 6'!E10","v":0},{"$f":"'Day 7'!E10","v":0},0.29166666666666702,0,0,0]
["08:00:00",{"$f":"'Day 1'!E11","v":0},{"$f":"'Day 2'!E11","v":0},{"$f":"'Day 3'!E11","v":0},{"$f":"'Day 4'!E11","v":0},{"$f":"'Day 5'!E11","v":0},{"$f":"'Day 6'!E11","v":0},{"$f":"'Day 7'!E11","v":0},0.33333333333333298,0,0,0]
["09:00:00",{"$f":"'Day 1'!E12","v":0},{"$f":"'Day 2'!E12","v":0},{"$f":"'Day 3'!E12","v":0},{"$f":"'Day 4'!E12","v":0},{"$f":"'Day 5'!E12","v":0},{"$f":"'Day 6'!E12","v":0},{"$f":"'Day 7'!E12","v":0},0.375,0,0,0]
["10:00:00",{"$f":"'Day 1'!E13","v":0},{"$f":"'Day 2'!E13","v":0},{"$f":"'Day 3'!E13","v":0},{"$f":"'Day 4'!E13","v":0},{"$f":"'Day 5'!E13","v":0},{"$f":"'Day 6'!E13","v":0},{"$f":"'Day 7'!E13","v":0},0.41666666666666702,0,0,0]
["11:00:00",{"$f":"'Day 1'!E14","v":0},{"$f":"'Day 2'!E14","v":0},{"$f":"'Day 3'!E14","v":0},{"$f":"'Day 4'!E14","v":0},{"$f":"'Day 5'!E14","v":0},{"$f":"'Day 6'!E14","v":0},{"$f":"'Day 7'!E14","v":0},0.45833333333333398,0,0,0]
["12:00:00",{"$f":"'Day 1'!E15","v":0},{"$f":"'Day 2'!E15","v":0},{"$f":"'Day 3'!E15","v":0},{"$f":"'Day 4'!E15","v":0},{"$f":"'Day 5'!E15","v":0},{"$f":"'Day 6'!E15","v":0},{"$f":"'Day 7'!E15","v":0},0.5,0,0,0]
["13:00:00",{"$f":"'Day 1'!E16","v":0},{"$f":"'Day 2'!E16","v":0},{"$f":"'Day 3'!E16","v":0},{"$f":"'Day 4'!E16","v":0},{"$f":"'Day 5'!E16","v":0},{"$f":"'Day 6'!E16","v":0},{"$f":"'Day 7'!E16","v":0},0.54166666666666696,0,0,0]
["14:00:00",{"$f":"'Day 1'!E17","v":0},{"$f":"'Day 2'!E17","v":0},{"$f":"'Day 3'!E17","v":0},{"$f":"'Day 4'!E17","v":0},{"$f":"'Day 5'!E17","v":0},{"$f":"'Day 6'!E17","v":0},{"$f":"'Day 7'!E17","v":0},0.58333333333333404,0,0,0]
["15:00:00",{"$f":"'Day 1'!E18","v":0},{"$f":"'Day 2'!E18","v":0},{"$f":"'Day 3'!E18","v":0},{"$f":"'Day 4'!E18","v":0},{"$f":"'Day 5'!E18","v":0},{"$f":"'Day 6'!E18","v":0},{"$f":"'Day 7'!E18","v":0},0.625,0,0,0]
["16:00:00",{"$f":"'Day 1'!E19","v":0},{"$f":"'Day 2'!E19","v":0},{"$f":"'Day 3'!E19","v":0},{"$f":"'Day 4'!E19","v":0},{"$f":"'Day 5'!E19","v":0},{"$f":"'Day 6'!E19","v":0},{"$f":"'Day 7'!E19","v":0},0.66666666666666696,0,0,0]
["17:00:00",{"$f":"'Day 1'!E20","v":0},{"$f":"'Day 2'!E20","v":0},{"$f":"'Day 3'!E20","v":0},{"$f":"'Day 4'!E20","v":0},{"$f":"'Day 5'!E20","v":0},{"$f":"'Day 6'!E20","v":0},{"$f":"'Day 7'!E20","v":0},0.70833333333333404,0,0,0]
["18:00:00",{"$f":"'Day 1'!E21","v":0},{"$f":"'Day 2'!E21","v":0},{"$f":"'Day 3'!E21","v":0},{"$f":"'Day 4'!E21","v":0},{"$f":"'Day 5'!E21","v":0},{"$f":"'Day 6'!E21","v":0},{"$f":"'Day 7'!E21","v":0},0.75,0,0,0]
["19:00:00",{"$f":"'Day 1'!E22","v":0},{"$f":"'Day 2'!E22","v":0},{"$f":"'Day 3'!E22","v":0},{"$f":"'Day 4'!E22","v":0},{"$f":"'Day 5'!E22","v":0},{"$f":"'Day 6'!E22","v":0},{"$f":"'Day 7'!E22","v":0},0.79166666666666696,0,0,0]
["20:00:00",{"$f":"'Day 1'!E23","v":0},{"$f":"'Day 2'!E23","v":0},{"$f":"'Day 3'!E23","v":0},{"$f":"'Day 4'!E23","v":0},{"$f":"'Day 5'!E23","v":0},{"$f":"'Day 6'!E23","v":0},{"$f":"'Day 7'!E23","v":0},0.83333333333333404,0,0,0]
["21:00:00",{"$f":"'Day 1'!E24","v":0},{"$f":"'Day 2'!E24","v":0},{"$f":"'Day 3'!E24","v":0},{"$f":"'Day 4'!E24","v":0},{"$f":"'Day 5'!E24","v":0},{"$f":"'Day 6'!E24","v":0},{"$f":"'Day 7'!E24","v":0},0.875,0,0,0]
["22:00:00",{"$f":"'Day 1'!E25","v":0},{"$f":"'Day 2'!E25","v":0},{"$f":"'Day 3'!E25","v":0},{"$f":"'Day 4'!E25","v":0},{"$f":"'Day 5'!E25","v":0},{"$f":"'Day 6'!E25","v":0},{"$f":"'Day 7'!E25","v":0},0.91666666666666696,0,0,0]
["23:00:00",{"$f":"'Day 1'!E26","v":0},{"$f":"'Day 2'!E26","v":0},{"$f":"'Day 3'!E26","v":0},{"$f":"'Day 4'!E26","v":0},{"$f":"'Day 5'!E26","v":0},{"$f":"'Day 6'!E26","v":0},{"$f":"'Day 7'!E26","v":0},0.95833333333333404,0,0,0]
[1,{"$f":"'Day 1'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Day 2'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Day 3'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Day 4'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Day 5'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Day 6'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Day 7'!#REF!","v":{"$error":"#REF!"}},1,0,0,0]

{"sheet":"Week view - ModerateDep","index":5,"n_rows":27,"n_cols":12,"rows_kept":27,"cut":false,"hidden":true,"merged":[[0,0,0,7]]}
["MODERATE DEPENDENCY"]
[]
[null,"Day 1","Day 2","Day 3","Day 4","Day 5","Day 6","Day 7",null,"80th perc","staffing","\"+6.25%\""]
["01:00:00",{"$f":"'Day 1'!D4","v":0},{"$f":"'Day 2'!D4","v":0},{"$f":"'Day 3'!D4","v":0},{"$f":"'Day 4'!D4","v":0},{"$f":"'Day 5'!D4","v":0},{"$f":"'Day 6'!D4","v":0},{"$f":"'Day 7'!D4","v":0},{"$f":"A4","v":4.1666666666666664E-2},{"$f":"IFERROR(PERCENTILE(B4:H4,0.8),0)","v":0},{"$f":"PRODUCT(J4,0.5)","v":0},{"$f":"K4/100 *6.25+K4","v":0}]
["02:00:00",{"$f":"'Day 1'!D5","v":0},{"$f":"'Day 2'!D5","v":0},{"$f":"'Day 3'!D5","v":0},{"$f":"'Day 4'!D5","v":0},{"$f":"'Day 5'!D5","v":0},{"$f":"'Day 6'!D5","v":0},{"$f":"'Day 7'!D5","v":0},8.3333333333333301E-2,{"$f":"IFERROR(PERCENTILE(B5:H5,0.8),0)","v":0},{"$f":"PRODUCT(J5,0.5)","v":0},{"$f":"K5/100 *6.25+K5","v":0}]
["03:00:00",{"$f":"'Day 1'!D6","v":0},{"$f":"'Day 2'!D6","v":0},{"$f":"'Day 3'!D6","v":0},{"$f":"'Day 4'!D6","v":0},{"$f":"'Day 5'!D6","v":0},{"$f":"'Day 6'!D6","v":0},{"$f":"'Day 7'!D6","v":0},0.125,0,0,0]
["04:00:00",{"$f":"'Day 1'!D7","v":0},{"$f":"'Day 2'!D7","v":0},{"$f":"'Day 3'!D7","v":0},{"$f":"'Day 4'!D7","v":0},{"$f":"'Day 5'!D7","v":0},{"$f":"'Day 6'!D7","v":0},{"$f":"'Day 7'!D7","v":0},0.16666666666666699,0,0,0]
["05:00:00",{"$f":"'Day 1'!D8","v":0},{"$f":"'Day 2'!D8","v":0},{"$f":"'Day 3'!D8","v":0},{"$f":"'Day 4'!D8","v":0},{"$f":"'Day 5'!D8","v":0},{"$f":"'Day 6'!D8","v":0},{"$f":"'Day 7'!D8","v":0},0.20833333333333301,0,0,0]
["06:00:00",{"$f":"'Day 1'!D9","v":0},{"$f":"'Day 2'!D9","v":0},{"$f":"'Day 3'!D9","v":0},{"$f":"'Day 4'!D9","v":0},{"$f":"'Day 5'!D9","v":0},{"$f":"'Day 6'!D9","v":0},{"$f":"'Day 7'!D9","v":0},0.25,0,0,0]
["07:00:00",{"$f":"'Day 1'!D10","v":0},{"$f":"'Day 2'!D10","v":0},{"$f":"'Day 3'!D10","v":0},{"$f":"'Day 4'!D10","v":0},{"$f":"'Day 5'!D10","v":0},{"$f":"'Day 6'!D10","v":0},{"$f":"'Day 7'!D10","v":0},0.29166666666666702,0,0,0]
["08:00:00",{"$f":"'Day 1'!D11","v":0},{"$f":"'Day 2'!D11","v":0},{"$f":"'Day 3'!D11","v":0},{"$f":"'Day 4'!D11","v":0},{"$f":"'Day 5'!D11","v":0},{"$f":"'Day 6'!D11","v":0},{"$f":"'Day 7'!D11","v":0},0.33333333333333298,0,0,0]
["09:00:00",{"$f":"'Day 1'!D12","v":0},{"$f":"'Day 2'!D12","v":0},{"$f":"'Day 3'!D12","v":0},{"$f":"'Day 4'!D12","v":0},{"$f":"'Day 5'!D12","v":0},{"$f":"'Day 6'!D12","v":0},{"$f":"'Day 7'!D12","v":0},0.375,0,0,0]
["10:00:00",{"$f":"'Day 1'!D13","v":0},{"$f":"'Day 2'!D13","v":0},{"$f":"'Day 3'!D13","v":0},{"$f":"'Day 4'!D13","v":0},{"$f":"'Day 5'!D13","v":0},{"$f":"'Day 6'!D13","v":0},{"$f":"'Day 7'!D13","v":0},0.41666666666666702,0,0,0]
["11:00:00",{"$f":"'Day 1'!D14","v":0},{"$f":"'Day 2'!D14","v":0},{"$f":"'Day 3'!D14","v":0},{"$f":"'Day 4'!D14","v":0},{"$f":"'Day 5'!D14","v":0},{"$f":"'Day 6'!D14","v":0},{"$f":"'Day 7'!D14","v":0},0.45833333333333398,0,0,0]
["12:00:00",{"$f":"'Day 1'!D15","v":0},{"$f":"'Day 2'!D15","v":0},{"$f":"'Day 3'!D15","v":0},{"$f":"'Day 4'!D15","v":0},{"$f":"'Day 5'!D15","v":0},{"$f":"'Day 6'!D15","v":0},{"$f":"'Day 7'!D15","v":0},0.5,0,0,0]
["13:00:00",{"$f":"'Day 1'!D16","v":0},{"$f":"'Day 2'!D16","v":0},{"$f":"'Day 3'!D16","v":0},{"$f":"'Day 4'!D16","v":0},{"$f":"'Day 5'!D16","v":0},{"$f":"'Day 6'!D16","v":0},{"$f":"'Day 7'!D16","v":0},0.54166666666666696,0,0,0]
["14:00:00",{"$f":"'Day 1'!D17","v":0},{"$f":"'Day 2'!D17","v":0},{"$f":"'Day 3'!D17","v":0},{"$f":"'Day 4'!D17","v":0},{"$f":"'Day 5'!D17","v":0},{"$f":"'Day 6'!D17","v":0},{"$f":"'Day 7'!D17","v":0},0.58333333333333404,0,0,0]
["15:00:00",{"$f":"'Day 1'!D18","v":0},{"$f":"'Day 2'!D18","v":0},{"$f":"'Day 3'!D18","v":0},{"$f":"'Day 4'!D18","v":0},{"$f":"'Day 5'!D18","v":0},{"$f":"'Day 6'!D18","v":0},{"$f":"'Day 7'!D18","v":0},0.625,0,0,0]
["16:00:00",{"$f":"'Day 1'!D19","v":0},{"$f":"'Day 2'!D19","v":0},{"$f":"'Day 3'!D19","v":0},{"$f":"'Day 4'!D19","v":0},{"$f":"'Day 5'!D19","v":0},{"$f":"'Day 6'!D19","v":0},{"$f":"'Day 7'!D19","v":0},0.66666666666666696,0,0,0]
["17:00:00",{"$f":"'Day 1'!D20","v":0},{"$f":"'Day 2'!D20","v":0},{"$f":"'Day 3'!D20","v":0},{"$f":"'Day 4'!D20","v":0},{"$f":"'Day 5'!D20","v":0},{"$f":"'Day 6'!D20","v":0},{"$f":"'Day 7'!D20","v":0},0.70833333333333404,0,0,0]
["18:00:00",{"$f":"'Day 1'!D21","v":0},{"$f":"'Day 2'!D21","v":0},{"$f":"'Day 3'!D21","v":0},{"$f":"'Day 4'!D21","v":0},{"$f":"'Day 5'!D21","v":0},{"$f":"'Day 6'!D21","v":0},{"$f":"'Day 7'!D21","v":0},0.75,0,0,0]
["19:00:00",{"$f":"'Day 1'!D22","v":0},{"$f":"'Day 2'!D22","v":0},{"$f":"'Day 3'!D22","v":0},{"$f":"'Day 4'!D22","v":0},{"$f":"'Day 5'!D22","v":0},{"$f":"'Day 6'!D22","v":0},{"$f":"'Day 7'!D22","v":0},0.79166666666666696,0,0,0]
["20:00:00",{"$f":"'Day 1'!D23","v":0},{"$f":"'Day 2'!D23","v":0},{"$f":"'Day 3'!D23","v":0},{"$f":"'Day 4'!D23","v":0},{"$f":"'Day 5'!D23","v":0},{"$f":"'Day 6'!D23","v":0},{"$f":"'Day 7'!D23","v":0},0.83333333333333404,0,0,0]
["21:00:00",{"$f":"'Day 1'!D24","v":0},{"$f":"'Day 2'!D24","v":0},{"$f":"'Day 3'!D24","v":0},{"$f":"'Day 4'!D24","v":0},{"$f":"'Day 5'!D24","v":0},{"$f":"'Day 6'!D24","v":0},{"$f":"'Day 7'!D24","v":0},0.875,0,0,0]
["22:00:00",{"$f":"'Day 1'!D25","v":0},{"$f":"'Day 2'!D25","v":0},{"$f":"'Day 3'!D25","v":0},{"$f":"'Day 4'!D25","v":0},{"$f":"'Day 5'!D25","v":0},{"$f":"'Day 6'!D25","v":0},{"$f":"'Day 7'!D25","v":0},0.91666666666666696,0,0,0]
["23:00:00",{"$f":"'Day 1'!D26","v":0},{"$f":"'Day 2'!D26","v":0},{"$f":"'Day 3'!D26","v":0},{"$f":"'Day 4'!D26","v":0},{"$f":"'Day 5'!D26","v":0},{"$f":"'Day 6'!D26","v":0},{"$f":"'Day 7'!D26","v":0},0.95833333333333404,0,0,0]
[1,{"$f":"'Day 1'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Day 2'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Day 3'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Day 4'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Day 5'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Day 6'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Day 7'!#REF!","v":{"$error":"#REF!"}},1,0,0,0]

{"sheet":"Week view - TotalDep","index":6,"n_rows":27,"n_cols":12,"rows_kept":27,"cut":false,"hidden":true,"merged":[[0,0,0,7]]}
["TOTAL DEPENDENCY"]
[]
[null,"Day 1","Day 2","Day 3","Day 4","Day 5","Day 6","Day 7",null,"80th perc","staffing","\"+6.25%\""]
["01:00:00",{"$f":"'Day 1'!F4","v":0},{"$f":"'Day 2'!F4","v":0},{"$f":"'Day 3'!F4","v":0},{"$f":"'Day 4'!F4","v":0},{"$f":"'Day 5'!F4","v":0},{"$f":"'Day 6'!F4","v":0},{"$f":"'Day 7'!F4","v":0},{"$f":"A4","v":4.1666666666666664E-2},{"$f":"IFERROR(PERCENTILE(B4:H4,0.8),0)","v":0},{"$f":"J4*2","v":0},{"$f":"K4/100 *6.25+K4","v":0}]
["02:00:00",{"$f":"'Day 1'!F5","v":0},{"$f":"'Day 2'!F5","v":0},{"$f":"'Day 3'!F5","v":0},{"$f":"'Day 4'!F5","v":0},{"$f":"'Day 5'!F5","v":0},{"$f":"'Day 6'!F5","v":0},{"$f":"'Day 7'!F5","v":0},{"$f":"A5","v":8.3333333333333301E-2},{"$f":"IFERROR(PERCENTILE(B5:H5,0.8),0)","v":0},{"$f":"J5*2","v":0},{"$f":"K5/100 *6.25+K5","v":0}]
["03:00:00",{"$f":"'Day 1'!F6","v":0},{"$f":"'Day 2'!F6","v":0},{"$f":"'Day 3'!F6","v":0},{"$f":"'Day 4'!F6","v":0},{"$f":"'Day 5'!F6","v":0},{"$f":"'Day 6'!F6","v":0},{"$f":"'Day 7'!F6","v":0},{"$f":"A6","v":0.125},0,0,0]
["04:00:00",{"$f":"'Day 1'!F7","v":0},{"$f":"'Day 2'!F7","v":0},{"$f":"'Day 3'!F7","v":0},{"$f":"'Day 4'!F7","v":0},{"$f":"'Day 5'!F7","v":0},{"$f":"'Day 6'!F7","v":0},{"$f":"'Day 7'!F7","v":0},0.16666666666666699,0,0,0]
["05:00:00",{"$f":"'Day 1'!F8","v":0},{"$f":"'Day 2'!F8","v":0},{"$f":"'Day 3'!F8","v":0},{"$f":"'Day 4'!F8","v":0},{"$f":"'Day 5'!F8","v":0},{"$f":"'Day 6'!F8","v":0},{"$f":"'Day 7'!F8","v":0},0.20833333333333301,0,0,0]
["06:00:00",{"$f":"'Day 1'!F9","v":0},{"$f":"'Day 2'!F9","v":0},{"$f":"'Day 3'!F9","v":0},{"$f":"'Day 4'!F9","v":0},{"$f":"'Day 5'!F9","v":0},{"$f":"'Day 6'!F9","v":0},{"$f":"'Day 7'!F9","v":0},0.25,0,0,0]
["07:00:00",{"$f":"'Day 1'!F10","v":0},{"$f":"'Day 2'!F10","v":0},{"$f":"'Day 3'!F10","v":0},{"$f":"'Day 4'!F10","v":0},{"$f":"'Day 5'!F10","v":0},{"$f":"'Day 6'!F10","v":0},{"$f":"'Day 7'!F10","v":0},0.29166666666666702,0,0,0]
["08:00:00",{"$f":"'Day 1'!F11","v":0},{"$f":"'Day 2'!F11","v":0},{"$f":"'Day 3'!F11","v":0},{"$f":"'Day 4'!F11","v":0},{"$f":"'Day 5'!F11","v":0},{"$f":"'Day 6'!F11","v":0},{"$f":"'Day 7'!F11","v":0},0.33333333333333298,0,0,0]
["09:00:00",{"$f":"'Day 1'!F12","v":0},{"$f":"'Day 2'!F12","v":0},{"$f":"'Day 3'!F12","v":0},{"$f":"'Day 4'!F12","v":0},{"$f":"'Day 5'!F12","v":0},{"$f":"'Day 6'!F12","v":0},{"$f":"'Day 7'!F12","v":0},0.375,0,0,0]
["10:00:00",{"$f":"'Day 1'!F13","v":0},{"$f":"'Day 2'!F13","v":0},{"$f":"'Day 3'!F13","v":0},{"$f":"'Day 4'!F13","v":0},{"$f":"'Day 5'!F13","v":0},{"$f":"'Day 6'!F13","v":0},{"$f":"'Day 7'!F13","v":0},0.41666666666666702,0,0,0]
["11:00:00",{"$f":"'Day 1'!F14","v":0},{"$f":"'Day 2'!F14","v":0},{"$f":"'Day 3'!F14","v":0},{"$f":"'Day 4'!F14","v":0},{"$f":"'Day 5'!F14","v":0},{"$f":"'Day 6'!F14","v":0},{"$f":"'Day 7'!F14","v":0},0.45833333333333398,0,0,0]
["12:00:00",{"$f":"'Day 1'!F15","v":0},{"$f":"'Day 2'!F15","v":0},{"$f":"'Day 3'!F15","v":0},{"$f":"'Day 4'!F15","v":0},{"$f":"'Day 5'!F15","v":0},{"$f":"'Day 6'!F15","v":0},{"$f":"'Day 7'!F15","v":0},0.5,0,0,0]
["13:00:00",{"$f":"'Day 1'!F16","v":0},{"$f":"'Day 2'!F16","v":0},{"$f":"'Day 3'!F16","v":0},{"$f":"'Day 4'!F16","v":0},{"$f":"'Day 5'!F16","v":0},{"$f":"'Day 6'!F16","v":0},{"$f":"'Day 7'!F16","v":0},0.54166666666666696,0,0,0]
["14:00:00",{"$f":"'Day 1'!F17","v":0},{"$f":"'Day 2'!F17","v":0},{"$f":"'Day 3'!F17","v":0},{"$f":"'Day 4'!F17","v":0},{"$f":"'Day 5'!F17","v":0},{"$f":"'Day 6'!F17","v":0},{"$f":"'Day 7'!F17","v":0},0.58333333333333404,0,0,0]
["15:00:00",{"$f":"'Day 1'!F18","v":0},{"$f":"'Day 2'!F18","v":0},{"$f":"'Day 3'!F18","v":0},{"$f":"'Day 4'!F18","v":0},{"$f":"'Day 5'!F18","v":0},{"$f":"'Day 6'!F18","v":0},{"$f":"'Day 7'!F18","v":0},0.625,0,0,0]
["16:00:00",{"$f":"'Day 1'!F19","v":0},{"$f":"'Day 2'!F19","v":0},{"$f":"'Day 3'!F19","v":0},{"$f":"'Day 4'!F19","v":0},{"$f":"'Day 5'!F19","v":0},{"$f":"'Day 6'!F19","v":0},{"$f":"'Day 7'!F19","v":0},0.66666666666666696,0,0,0]
["17:00:00",{"$f":"'Day 1'!F20","v":0},{"$f":"'Day 2'!F20","v":0},{"$f":"'Day 3'!F20","v":0},{"$f":"'Day 4'!F20","v":0},{"$f":"'Day 5'!F20","v":0},{"$f":"'Day 6'!F20","v":0},{"$f":"'Day 7'!F20","v":0},0.70833333333333404,0,0,0]
["18:00:00",{"$f":"'Day 1'!F21","v":0},{"$f":"'Day 2'!F21","v":0},{"$f":"'Day 3'!F21","v":0},{"$f":"'Day 4'!F21","v":0},{"$f":"'Day 5'!F21","v":0},{"$f":"'Day 6'!F21","v":0},{"$f":"'Day 7'!F21","v":0},0.75,0,0,0]
["19:00:00",{"$f":"'Day 1'!F22","v":0},{"$f":"'Day 2'!F22","v":0},{"$f":"'Day 3'!F22","v":0},{"$f":"'Day 4'!F22","v":0},{"$f":"'Day 5'!F22","v":0},{"$f":"'Day 6'!F22","v":0},{"$f":"'Day 7'!F22","v":0},0.79166666666666696,0,0,0]
["20:00:00",{"$f":"'Day 1'!F23","v":0},{"$f":"'Day 2'!F23","v":0},{"$f":"'Day 3'!F23","v":0},{"$f":"'Day 4'!F23","v":0},{"$f":"'Day 5'!F23","v":0},{"$f":"'Day 6'!F23","v":0},{"$f":"'Day 7'!F23","v":0},0.83333333333333404,0,0,0]
["21:00:00",{"$f":"'Day 1'!F24","v":0},{"$f":"'Day 2'!F24","v":0},{"$f":"'Day 3'!F24","v":0},{"$f":"'Day 4'!F24","v":0},{"$f":"'Day 5'!F24","v":0},{"$f":"'Day 6'!F24","v":0},{"$f":"'Day 7'!F24","v":0},0.875,0,0,0]
["22:00:00",{"$f":"'Day 1'!F25","v":0},{"$f":"'Day 2'!F25","v":0},{"$f":"'Day 3'!F25","v":0},{"$f":"'Day 4'!F25","v":0},{"$f":"'Day 5'!F25","v":0},{"$f":"'Day 6'!F25","v":0},{"$f":"'Day 7'!F25","v":0},0.91666666666666696,0,0,0]
["23:00:00",{"$f":"'Day 1'!F26","v":0},{"$f":"'Day 2'!F26","v":0},{"$f":"'Day 3'!F26","v":0},{"$f":"'Day 4'!F26","v":0},{"$f":"'Day 5'!F26","v":0},{"$f":"'Day 6'!F26","v":0},{"$f":"'Day 7'!F26","v":0},0.95833333333333404,0,0,0]
[1,{"$f":"'Day 1'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Day 2'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Day 3'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Day 4'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Day 5'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Day 6'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Day 7'!#REF!","v":{"$error":"#REF!"}},1,0,0,0]

{"sheet":"Week view - Waitbed","index":7,"n_rows":27,"n_cols":12,"rows_kept":27,"cut":false,"hidden":true,"merged":[[0,0,0,7]]}
["WAIT BED"]
[]
[null,"Day 1","Day 2","Day 3","Day 4","Day 5","Day 6","Day 7",null,"80th perc","staffing","\"+6.25%\""]
["01:00:00",{"$f":"'Day 1'!G4","v":0},{"$f":"'Day 2'!G4","v":0},{"$f":"'Day 3'!G4","v":0},{"$f":"'Day 4'!G4","v":0},{"$f":"'Day 5'!G4","v":0},{"$f":"'Day 6'!G4","v":0},{"$f":"'Day 7'!G4","v":0},{"$f":"A4","v":4.1666666666666664E-2},{"$f":"IFERROR(PERCENTILE(B4:H4,0.8),0)","v":0},{"$f":"PRODUCT(J4,0.2)","v":0},{"$f":"K4/100 *6.25+K4","v":0}]
["02:00:00",{"$f":"'Day 1'!G5","v":0},{"$f":"'Day 2'!G5","v":0},{"$f":"'Day 3'!G5","v":0},{"$f":"'Day 4'!G5","v":0},{"$f":"'Day 5'!G5","v":0},{"$f":"'Day 6'!G5","v":0},{"$f":"'Day 7'!G5","v":0},{"$f":"A5","v":8.3333333333333301E-2},{"$f":"IFERROR(PERCENTILE(B5:H5,0.8),0)","v":0},{"$f":"PRODUCT(J5,0.2)","v":0},{"$f":"K5/100 *6.25+K5","v":0}]
["03:00:00",{"$f":"'Day 1'!G6","v":0},{"$f":"'Day 2'!G6","v":0},{"$f":"'Day 3'!G6","v":0},{"$f":"'Day 4'!G6","v":0},{"$f":"'Day 5'!G6","v":0},{"$f":"'Day 6'!G6","v":0},{"$f":"'Day 7'!G6","v":0},{"$f":"A6","v":0.125},0,0,0]
["04:00:00",{"$f":"'Day 1'!G7","v":0},{"$f":"'Day 2'!G7","v":0},{"$f":"'Day 3'!G7","v":0},{"$f":"'Day 4'!G7","v":0},{"$f":"'Day 5'!G7","v":0},{"$f":"'Day 6'!G7","v":0},{"$f":"'Day 7'!G7","v":0},0.16666666666666699,0,0,0]
["05:00:00",{"$f":"'Day 1'!G8","v":0},{"$f":"'Day 2'!G8","v":0},{"$f":"'Day 3'!G8","v":0},{"$f":"'Day 4'!G8","v":0},{"$f":"'Day 5'!G8","v":0},{"$f":"'Day 6'!G8","v":0},{"$f":"'Day 7'!G8","v":0},0.20833333333333301,0,0,0]
["06:00:00",{"$f":"'Day 1'!G9","v":0},{"$f":"'Day 2'!G9","v":0},{"$f":"'Day 3'!G9","v":0},{"$f":"'Day 4'!G9","v":0},{"$f":"'Day 5'!G9","v":0},{"$f":"'Day 6'!G9","v":0},{"$f":"'Day 7'!G9","v":0},0.25,0,0,0]
["07:00:00",{"$f":"'Day 1'!G10","v":0},{"$f":"'Day 2'!G10","v":0},{"$f":"'Day 3'!G10","v":0},{"$f":"'Day 4'!G10","v":0},{"$f":"'Day 5'!G10","v":0},{"$f":"'Day 6'!G10","v":0},{"$f":"'Day 7'!G10","v":0},0.29166666666666702,0,0,0]
["08:00:00",{"$f":"'Day 1'!G11","v":0},{"$f":"'Day 2'!G11","v":0},{"$f":"'Day 3'!G11","v":0},{"$f":"'Day 4'!G11","v":0},{"$f":"'Day 5'!G11","v":0},{"$f":"'Day 6'!G11","v":0},{"$f":"'Day 7'!G11","v":0},0.33333333333333298,0,0,0]
["09:00:00",{"$f":"'Day 1'!G12","v":0},{"$f":"'Day 2'!G12","v":0},{"$f":"'Day 3'!G12","v":0},{"$f":"'Day 4'!G12","v":0},{"$f":"'Day 5'!G12","v":0},{"$f":"'Day 6'!G12","v":0},{"$f":"'Day 7'!G12","v":0},0.375,0,0,0]
["10:00:00",{"$f":"'Day 1'!G13","v":0},{"$f":"'Day 2'!G13","v":0},{"$f":"'Day 3'!G13","v":0},{"$f":"'Day 4'!G13","v":0},{"$f":"'Day 5'!G13","v":0},{"$f":"'Day 6'!G13","v":0},{"$f":"'Day 7'!G13","v":0},0.41666666666666702,0,0,0]
["11:00:00",{"$f":"'Day 1'!G14","v":0},{"$f":"'Day 2'!G14","v":0},{"$f":"'Day 3'!G14","v":0},{"$f":"'Day 4'!G14","v":0},{"$f":"'Day 5'!G14","v":0},{"$f":"'Day 6'!G14","v":0},{"$f":"'Day 7'!G14","v":0},0.45833333333333398,0,0,0]
["12:00:00",{"$f":"'Day 1'!G15","v":0},{"$f":"'Day 2'!G15","v":0},{"$f":"'Day 3'!G15","v":0},{"$f":"'Day 4'!G15","v":0},{"$f":"'Day 5'!G15","v":0},{"$f":"'Day 6'!G15","v":0},{"$f":"'Day 7'!G15","v":0},0.5,0,0,0]
["13:00:00",{"$f":"'Day 1'!G16","v":0},{"$f":"'Day 2'!G16","v":0},{"$f":"'Day 3'!G16","v":0},{"$f":"'Day 4'!G16","v":0},{"$f":"'Day 5'!G16","v":0},{"$f":"'Day 6'!G16","v":0},{"$f":"'Day 7'!G16","v":0},0.54166666666666696,0,0,0]
["14:00:00",{"$f":"'Day 1'!G17","v":0},{"$f":"'Day 2'!G17","v":0},{"$f":"'Day 3'!G17","v":0},{"$f":"'Day 4'!G17","v":0},{"$f":"'Day 5'!G17","v":0},{"$f":"'Day 6'!G17","v":0},{"$f":"'Day 7'!G17","v":0},0.58333333333333404,0,0,0]
["15:00:00",{"$f":"'Day 1'!G18","v":0},{"$f":"'Day 2'!G18","v":0},{"$f":"'Day 3'!G18","v":0},{"$f":"'Day 4'!G18","v":0},{"$f":"'Day 5'!G18","v":0},{"$f":"'Day 6'!G18","v":0},{"$f":"'Day 7'!G18","v":0},0.625,0,0,0]
["16:00:00",{"$f":"'Day 1'!G19","v":0},{"$f":"'Day 2'!G19","v":0},{"$f":"'Day 3'!G19","v":0},{"$f":"'Day 4'!G19","v":0},{"$f":"'Day 5'!G19","v":0},{"$f":"'Day 6'!G19","v":0},{"$f":"'Day 7'!G19","v":0},0.66666666666666696,0,0,0]
["17:00:00",{"$f":"'Day 1'!G20","v":0},{"$f":"'Day 2'!G20","v":0},{"$f":"'Day 3'!G20","v":0},{"$f":"'Day 4'!G20","v":0},{"$f":"'Day 5'!G20","v":0},{"$f":"'Day 6'!G20","v":0},{"$f":"'Day 7'!G20","v":0},0.70833333333333404,0,0,0]
["18:00:00",{"$f":"'Day 1'!G21","v":0},{"$f":"'Day 2'!G21","v":0},{"$f":"'Day 3'!G21","v":0},{"$f":"'Day 4'!G21","v":0},{"$f":"'Day 5'!G21","v":0},{"$f":"'Day 6'!G21","v":0},{"$f":"'Day 7'!G21","v":0},0.75,0,0,0]
["19:00:00",{"$f":"'Day 1'!G22","v":0},{"$f":"'Day 2'!G22","v":0},{"$f":"'Day 3'!G22","v":0},{"$f":"'Day 4'!G22","v":0},{"$f":"'Day 5'!G22","v":0},{"$f":"'Day 6'!G22","v":0},{"$f":"'Day 7'!G22","v":0},0.79166666666666696,0,0,0]
["20:00:00",{"$f":"'Day 1'!G23","v":0},{"$f":"'Day 2'!G23","v":0},{"$f":"'Day 3'!G23","v":0},{"$f":"'Day 4'!G23","v":0},{"$f":"'Day 5'!G23","v":0},{"$f":"'Day 6'!G23","v":0},{"$f":"'Day 7'!G23","v":0},0.83333333333333404,0,0,0]
["21:00:00",{"$f":"'Day 1'!G24","v":0},{"$f":"'Day 2'!G24","v":0},{"$f":"'Day 3'!G24","v":0},{"$f":"'Day 4'!G24","v":0},{"$f":"'Day 5'!G24","v":0},{"$f":"'Day 6'!G24","v":0},{"$f":"'Day 7'!G24","v":0},0.875,0,0,0]
["22:00:00",{"$f":"'Day 1'!G25","v":0},{"$f":"'Day 2'!G25","v":0},{"$f":"'Day 3'!G25","v":0},{"$f":"'Day 4'!G25","v":0},{"$f":"'Day 5'!G25","v":0},{"$f":"'Day 6'!G25","v":0},{"$f":"'Day 7'!G25","v":0},0.91666666666666696,0,0,0]
["23:00:00",{"$f":"'Day 1'!G26","v":0},{"$f":"'Day 2'!G26","v":0},{"$f":"'Day 3'!G26","v":0},{"$f":"'Day 4'!G26","v":0},{"$f":"'Day 5'!G26","v":0},{"$f":"'Day 6'!G26","v":0},{"$f":"'Day 7'!G26","v":0},0.95833333333333404,0,0,0]
[1,{"$f":"'Day 1'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Day 2'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Day 3'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Day 4'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Day 5'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Day 6'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Day 7'!#REF!","v":{"$error":"#REF!"}},1,0,0,0]

{"sheet":"Calculation","index":8,"n_rows":29,"n_cols":13,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
["Time",null,"Low Dep","Moderate Dep","High Dep","Total Dep","Wait bed Dep","Co-ordinator",null,null,"Total Staffing "]
[null,null,"staff","staff ","staff","Staff","Staff",null,null,"Total Calcu Staff","Rounded Up","current staffing","optimal"]
[]
["01:00:00",null,{"$f":"'Week view - LowDep'!L4","v":0},{"$f":"'Week view - ModerateDep'!L4","v":0},{"$f":"'Week view - HighDep'!L4","v":0},{"$f":"'Week view - TotalDep'!L4","v":0},{"$f":"'Week view - Waitbed'!L4","v":0},1,null,{"$f":"SUM(C4:H4)","v":1},{"$f":"ROUNDUP(J4,0)","v":1}]
["02:00:00",null,{"$f":"'Week view - LowDep'!L5","v":0},{"$f":"'Week view - ModerateDep'!L5","v":0},{"$f":"'Week view - HighDep'!L5","v":0},{"$f":"'Week view - TotalDep'!L5","v":0},{"$f":"'Week view - Waitbed'!L5","v":0},1,null,{"$f":"SUM(C5:H5)","v":1},{"$f":"ROUNDUP(J5,0)","v":1}]
["03:00:00",null,{"$f":"'Week view - LowDep'!L6","v":0},{"$f":"'Week view - ModerateDep'!L6","v":0},{"$f":"'Week view - HighDep'!L6","v":0},{"$f":"'Week view - TotalDep'!L6","v":0},{"$f":"'Week view - Waitbed'!L6","v":0},1,null,1,1]
["04:00:00",null,{"$f":"'Week view - LowDep'!L7","v":0},{"$f":"'Week view - ModerateDep'!L7","v":0},{"$f":"'Week view - HighDep'!L7","v":0},{"$f":"'Week view - TotalDep'!L7","v":0},{"$f":"'Week view - Waitbed'!L7","v":0},1,null,1,1]
["05:00:00",null,{"$f":"'Week view - LowDep'!L8","v":0},{"$f":"'Week view - ModerateDep'!L8","v":0},{"$f":"'Week view - HighDep'!L8","v":0},{"$f":"'Week view - TotalDep'!L8","v":0},{"$f":"'Week view - Waitbed'!L8","v":0},1,null,1,1]
["06:00:00",null,{"$f":"'Week view - LowDep'!L9","v":0},{"$f":"'Week view - ModerateDep'!L9","v":0},{"$f":"'Week view - HighDep'!L9","v":0},{"$f":"'Week view - TotalDep'!L9","v":0},{"$f":"'Week view - Waitbed'!L9","v":0},1,null,1,1]
["07:00:00",null,{"$f":"'Week view - LowDep'!L10","v":0},{"$f":"'Week view - ModerateDep'!L10","v":0},{"$f":"'Week view - HighDep'!L10","v":0},{"$f":"'Week view - TotalDep'!L10","v":0},{"$f":"'Week view - Waitbed'!L10","v":0},1,null,1,1]
["08:00:00",null,{"$f":"'Week view - LowDep'!L11","v":0},{"$f":"'Week view - ModerateDep'!L11","v":0},{"$f":"'Week view - HighDep'!L11","v":0},{"$f":"'Week view - TotalDep'!L11","v":0},{"$f":"'Week view - Waitbed'!L11","v":0},1,null,1,1]
["09:00:00",null,{"$f":"'Week view - LowDep'!L12","v":0},{"$f":"'Week view - ModerateDep'!L12","v":0},{"$f":"'Week view - HighDep'!L12","v":0},{"$f":"'Week view - TotalDep'!L12","v":0},{"$f":"'Week view - Waitbed'!L12","v":0},1,null,1,1]
["10:00:00",null,{"$f":"'Week view - LowDep'!L13","v":0},{"$f":"'Week view - ModerateDep'!L13","v":0},{"$f":"'Week view - HighDep'!L13","v":0},{"$f":"'Week view - TotalDep'!L13","v":0},{"$f":"'Week view - Waitbed'!L13","v":0},1,null,1,1]
["11:00:00",null,{"$f":"'Week view - LowDep'!L14","v":0},{"$f":"'Week view - ModerateDep'!L14","v":0},{"$f":"'Week view - HighDep'!L14","v":0},{"$f":"'Week view - TotalDep'!L14","v":0},{"$f":"'Week view - Waitbed'!L14","v":0},1,null,1,1]
["12:00:00",null,{"$f":"'Week view - LowDep'!L15","v":0},{"$f":"'Week view - ModerateDep'!L15","v":0},{"$f":"'Week view - HighDep'!L15","v":0},{"$f":"'Week view - TotalDep'!L15","v":0},{"$f":"'Week view - Waitbed'!L15","v":0},1,null,1,1]
["13:00:00",null,{"$f":"'Week view - LowDep'!L16","v":0},{"$f":"'Week view - ModerateDep'!L16","v":0},{"$f":"'Week view - HighDep'!L16","v":0},{"$f":"'Week view - TotalDep'!L16","v":0},{"$f":"'Week view - Waitbed'!L16","v":0},1,null,1,1]
["14:00:00",null,{"$f":"'Week view - LowDep'!L17","v":0},{"$f":"'Week view - ModerateDep'!L17","v":0},{"$f":"'Week view - HighDep'!L17","v":0},{"$f":"'Week view - TotalDep'!L17","v":0},{"$f":"'Week view - Waitbed'!L17","v":0},1,null,1,1]
["15:00:00",null,{"$f":"'Week view - LowDep'!L18","v":0},{"$f":"'Week view - ModerateDep'!L18","v":0},{"$f":"'Week view - HighDep'!L18","v":0},{"$f":"'Week view - TotalDep'!L18","v":0},{"$f":"'Week view - Waitbed'!L18","v":0},1,null,1,1]
["16:00:00",null,{"$f":"'Week view - LowDep'!L19","v":0},{"$f":"'Week view - ModerateDep'!L19","v":0},{"$f":"'Week view - HighDep'!L19","v":0},{"$f":"'Week view - TotalDep'!L19","v":0},{"$f":"'Week view - Waitbed'!L19","v":0},1,null,1,1]
["17:00:00",null,{"$f":"'Week view - LowDep'!L20","v":0},{"$f":"'Week view - ModerateDep'!L20","v":0},{"$f":"'Week view - HighDep'!L20","v":0},{"$f":"'Week view - TotalDep'!L20","v":0},{"$f":"'Week view - Waitbed'!L20","v":0},1,null,1,1]
["18:00:00",null,{"$f":"'Week view - LowDep'!L21","v":0},{"$f":"'Week view - ModerateDep'!L21","v":0},{"$f":"'Week view - HighDep'!L21","v":0},{"$f":"'Week view - TotalDep'!L21","v":0},{"$f":"'Week view - Waitbed'!L21","v":0},1,null,1,1]
["19:00:00",null,{"$f":"'Week view - LowDep'!L22","v":0},{"$f":"'Week view - ModerateDep'!L22","v":0},{"$f":"'Week view - HighDep'!L22","v":0},{"$f":"'Week view - TotalDep'!L22","v":0},{"$f":"'Week view - Waitbed'!L22","v":0},1,null,1,1]
["20:00:00",null,{"$f":"'Week view - LowDep'!L23","v":0},{"$f":"'Week view - ModerateDep'!L23","v":0},{"$f":"'Week view - HighDep'!L23","v":0},{"$f":"'Week view - TotalDep'!L23","v":0},{"$f":"'Week view - Waitbed'!L23","v":0},1,null,1,1]
["21:00:00",null,{"$f":"'Week view - LowDep'!L24","v":0},{"$f":"'Week view - ModerateDep'!L24","v":0},{"$f":"'Week view - HighDep'!L24","v":0},{"$f":"'Week view - TotalDep'!L24","v":0},{"$f":"'Week view - Waitbed'!L24","v":0},1,null,1,1]
["22:00:00",null,{"$f":"'Week view - LowDep'!L25","v":0},{"$f":"'Week view - ModerateDep'!L25","v":0},{"$f":"'Week view - HighDep'!L25","v":0},{"$f":"'Week view - TotalDep'!L25","v":0},{"$f":"'Week view - Waitbed'!L25","v":0},1,null,1,1]
["23:00:00",null,{"$f":"'Week view - LowDep'!L26","v":0},{"$f":"'Week view - ModerateDep'!L26","v":0},{"$f":"'Week view - HighDep'!L26","v":0},{"$f":"'Week view - TotalDep'!L26","v":0},{"$f":"'Week view - Waitbed'!L26","v":0},1,null,1,1]
[1,null,{"$f":"'Week view - LowDep'!L27","v":0},{"$f":"'Week view - ModerateDep'!L27","v":0},{"$f":"'Week view - HighDep'!L27","v":0},{"$f":"'Week view - TotalDep'!L27","v":0},{"$f":"'Week view - Waitbed'!L27","v":0},1,null,1,1]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(K4:K28)","v":24}]

{"sheet":"Day 1","index":9,"n_rows":26,"n_cols":19,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Calculated staffing"]
["Day 1","Rostered staffing","Low dependency","Moderate dependency","High dependency","Total dependency","Wait bed",null,null,"References",null,null,null,"Low dependency","Moderate dependency","High dependency","Total dependency","Wait bed","Calculated staffing requirement"]
["00:00:00",null,null,null,null,null,null,{"$f":"A3","v":0}]
["01:00:00",null,null,null,null,null,null,{"$f":"A4","v":4.1666666666666664E-2},null,"JDT Adult Scoring - calculator",null,null,null,{"$f":"C4*0.286","v":0},{"$f":"D4*0.5","v":0},{"$f":"E4*1","v":0},{"$f":"F4*2","v":0},{"$f":"G4*0.2","v":0},{"$f":"SUM(N4:R4)","v":0}]
["02:00:00",null,null,null,null,null,null,{"$f":"A5","v":8.3333333333333301E-2},null,null,null,null,null,{"$f":"C5*0.286","v":0},{"$f":"D5*0.5","v":0},{"$f":"E5*1","v":0},{"$f":"F5*2","v":0},{"$f":"G5*0.2","v":0},{"$f":"SUM(N5:R5)","v":0}]
["03:00:00",null,null,null,null,null,null,{"$f":"A6","v":0.125},null,"JDT Child Scoring - calculator",null,null,null,0,0,0,0,0,0]
["04:00:00",null,null,null,null,null,null,0.16666666666666699,null,null,null,null,null,0,0,0,0,0,0]
["05:00:00",null,null,null,null,null,null,0.20833333333333301,null,null,null,null,null,0,0,0,0,0,0]
["06:00:00",null,null,null,null,null,null,0.25,null,null,null,null,null,0,0,0,0,0,0]
["07:00:00",null,null,null,null,null,null,0.29166666666666702,null,null,null,null,null,0,0,0,0,0,0]
["08:00:00",null,null,null,null,null,null,0.33333333333333298,null,null,null,null,null,0,0,0,0,0,0]
["09:00:00",null,null,null,null,null,null,0.375,null,null,null,null,null,0,0,0,0,0,0]
["10:00:00",null,null,null,null,null,null,0.41666666666666702,null,null,null,null,null,0,0,0,0,0,0]
["11:00:00",null,null,null,null,null,null,0.45833333333333398,null,null,null,null,null,0,0,0,0,0,0]
["12:00:00",null,null,null,null,null,null,0.5,null,null,null,null,null,0,0,0,0,0,0]
["13:00:00",null,null,null,null,null,null,0.54166666666666696,null,null,null,null,null,0,0,0,0,0,0]
["14:00:00",null,null,null,null,null,null,0.58333333333333404,null,null,null,null,null,0,0,0,0,0,0]
["15:00:00",null,null,null,null,null,null,0.625,null,null,null,null,null,0,0,0,0,0,0]
["16:00:00",null,null,null,null,null,null,0.66666666666666696,null,null,null,null,null,0,0,0,0,0,0]
["17:00:00",null,null,null,null,null,null,0.70833333333333404,null,null,null,null,null,0,0,0,0,0,0]
["18:00:00",null,null,null,null,null,null,0.75,null,null,null,null,null,0,0,0,0,0,0]
["19:00:00",null,null,null,null,null,null,0.79166666666666696,null,null,null,null,null,0,0,0,0,0,0]
["20:00:00",null,null,null,null,null,null,0.83333333333333404,null,null,null,null,null,0,0,0,0,0,0]
["21:00:00",null,null,null,null,null,null,0.875,null,null,null,null,null,0,0,0,0,0,0]
["22:00:00",null,null,null,null,null,null,0.91666666666666696,null,null,null,null,null,0,0,0,0,0,0]
["23:00:00",null,null,null,null,null,null,0.95833333333333404,null,null,null,null,null,0,0,0,0,0,0]

{"sheet":"Day 2","index":10,"n_rows":26,"n_cols":19,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Calculated staffing"]
["Day 2","Rostered staffing","Low dependency","Moderate dependency","High dependency","Total dependency","Wait bed",null,null,"References",null,null,null,"Low dependency","Moderate dependency","High dependency","Total dependency","Wait bed","Calculated staffing requirement"]
["00:00:00",null,null,null,null,null,null,{"$f":"A3","v":"00:00:00"},null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(N3:R3)","v":0}]
["01:00:00",null,null,null,null,null,null,"01:00:00",null,"JDT Adult Scoring - calculator",null,null,null,{"$f":"C4*0.286","v":0},{"$f":"D4*0.5","v":0},{"$f":"E4*1","v":0},{"$f":"F4*2","v":0},{"$f":"G4*0.2","v":0},{"$f":"SUM(N4:R4)","v":0}]
["02:00:00",null,null,null,null,null,null,{"$f":"A5","v":"02:00:00"},null,null,null,null,null,{"$f":"C5*0.286","v":0},{"$f":"D5*0.5","v":0},{"$f":"E5*1","v":0},{"$f":"F5*2","v":0},{"$f":"G5*0.2","v":0},{"$f":"SUM(N5:R5)","v":0}]
["03:00:00",null,null,null,null,null,null,{"$f":"A6","v":"03:00:00"},null,"JDT Child Scoring - calculator",null,null,null,0,0,0,0,0,0]
["04:00:00",null,null,null,null,null,null,"04:00:00",null,null,null,null,null,0,0,0,0,0,0]
["05:00:00",null,null,null,null,null,null,"05:00:00",null,null,null,null,null,0,0,0,0,0,0]
["06:00:00",null,null,null,null,null,null,"06:00:00",null,null,null,null,null,0,0,0,0,0,0]
["07:00:00",null,null,null,null,null,null,"07:00:00",null,null,null,null,null,0,0,0,0,0,0]
["08:00:00",null,null,null,null,null,null,"08:00:00",null,null,null,null,null,0,0,0,0,0,0]
["09:00:00",null,null,null,null,null,null,"09:00:00",null,null,null,null,null,0,0,0,0,0,0]
["10:00:00",null,null,null,null,null,null,"10:00:00",null,null,null,null,null,0,0,0,0,0,0]
["11:00:00",null,null,null,null,null,null,"11:00:00",null,null,null,null,null,0,0,0,0,0,0]
["12:00:00",null,null,null,null,null,null,"12:00:00",null,null,null,null,null,0,0,0,0,0,0]
["13:00:00",null,null,null,null,null,null,"13:00:00",null,null,null,null,null,0,0,0,0,0,0]
["14:00:00",null,null,null,null,null,null,"14:00:00",null,null,null,null,null,0,0,0,0,0,0]
["15:00:00",null,null,null,null,null,null,"15:00:00",null,null,null,null,null,0,0,0,0,0,0]
["16:00:00",null,null,null,null,null,null,"16:00:00",null,null,null,null,null,0,0,0,0,0,0]
["17:00:00",null,null,null,null,null,null,"17:00:00",null,null,null,null,null,0,0,0,0,0,0]
["18:00:00",null,null,null,null,null,null,"18:00:00",null,null,null,null,null,0,0,0,0,0,0]
["19:00:00",null,null,null,null,null,null,"19:00:00",null,null,null,null,null,0,0,0,0,0,0]
["20:00:00",null,null,null,null,null,null,"20:00:00",null,null,null,null,null,0,0,0,0,0,0]
["21:00:00",null,null,null,null,null,null,"21:00:00",null,null,null,null,null,0,0,0,0,0,0]
["22:00:00",null,null,null,null,null,null,"22:00:00",null,null,null,null,null,0,0,0,0,0,0]
["23:00:00",null,null,null,null,null,null,"23:00:00",null,null,null,null,null,0,0,0,0,0,0]

{"sheet":"Day 3","index":11,"n_rows":26,"n_cols":19,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Calculated staffing"]
["Day 3","Rostered staffing","Low dependency","Moderate dependency","High dependency","Total dependency","Wait bed",null,null,"References",null,null,null,"Low dependency","Moderate dependency","High dependency","Total dependency","Wait bed","Calculated staffing requirement"]
["00:00:00"]
["01:00:00",null,null,null,null,null,null,{"$f":"A4","v":4.1666666666666664E-2},null,"JDT Adult Scoring - calculator",null,null,null,{"$f":"C4*0.286","v":0},{"$f":"D4*0.5","v":0},{"$f":"E4*1","v":0},{"$f":"F4*2","v":0},{"$f":"G4*0.2","v":0},{"$f":"SUM(N4:R4)","v":0}]
["02:00:00",null,null,null,null,null,null,{"$f":"A5","v":8.3333333333333301E-2},null,null,null,null,null,{"$f":"C5*0.286","v":0},{"$f":"D5*0.5","v":0},{"$f":"E5*1","v":0},{"$f":"F5*2","v":0},{"$f":"G5*0.2","v":0},{"$f":"SUM(N5:R5)","v":0}]
["03:00:00",null,null,null,null,null,null,{"$f":"A6","v":0.125},null,"JDT Child Scoring - calculator",null,null,null,0,0,0,0,0,0]
["04:00:00",null,null,null,null,null,null,0.16666666666666699,null,null,null,null,null,0,0,0,0,0,0]
["05:00:00",null,null,null,null,null,null,0.20833333333333301,null,null,null,null,null,0,0,0,0,0,0]
["06:00:00",null,null,null,null,null,null,0.25,null,null,null,null,null,0,0,0,0,0,0]
["07:00:00",null,null,null,null,null,null,0.29166666666666702,null,null,null,null,null,0,0,0,0,0,0]
["08:00:00",null,null,null,null,null,null,0.33333333333333298,null,null,null,null,null,0,0,0,0,0,0]
["09:00:00",null,null,null,null,null,null,0.375,null,null,null,null,null,0,0,0,0,0,0]
["10:00:00",null,null,null,null,null,null,0.41666666666666702,null,null,null,null,null,0,0,0,0,0,0]
["11:00:00",null,null,null,null,null,null,0.45833333333333398,null,null,null,null,null,0,0,0,0,0,0]
["12:00:00",null,null,null,null,null,null,0.5,null,null,null,null,null,0,0,0,0,0,0]
["13:00:00",null,null,null,null,null,null,0.54166666666666696,null,null,null,null,null,0,0,0,0,0,0]
["14:00:00",null,null,null,null,null,null,0.58333333333333404,null,null,null,null,null,0,0,0,0,0,0]
["15:00:00",null,null,null,null,null,null,0.625,null,null,null,null,null,0,0,0,0,0,0]
["16:00:00",null,null,null,null,null,null,0.66666666666666696,null,null,null,null,null,0,0,0,0,0,0]
["17:00:00",null,null,null,null,null,null,0.70833333333333404,null,null,null,null,null,0,0,0,0,0,0]
["18:00:00",null,null,null,null,null,null,0.75,null,null,null,null,null,0,0,0,0,0,0]
["19:00:00",null,null,null,null,null,null,0.79166666666666696,null,null,null,null,null,0,0,0,0,0,0]
["20:00:00",null,null,null,null,null,null,0.83333333333333404,null,null,null,null,null,0,0,0,0,0,0]
["21:00:00",null,null,null,null,null,null,0.875,null,null,null,null,null,0,0,0,0,0,0]
["22:00:00",null,null,null,null,null,null,0.91666666666666696,null,null,null,null,null,0,0,0,0,0,0]
["23:00:00",null,null,null,null,null,null,0.95833333333333404,null,null,null,null,null,0,0,0,0,0,0]

{"sheet":"Day 4","index":12,"n_rows":26,"n_cols":19,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Calculated staffing"]
["Day 4","Rostered staffing","Low dependency","Moderate dependency","High dependency","Total dependency","Wait bed",null,null,"References",null,null,null,"Low dependency","Moderate dependency","High dependency","Total dependency","Wait bed","Calculated staffing requirement"]
["00:00:00"]
["01:00:00",null,null,null,null,null,null,{"$f":"A4","v":4.1666666666666664E-2},null,"JDT Adult Scoring - calculator",null,null,null,{"$f":"C4*0.286","v":0},{"$f":"D4*0.5","v":0},{"$f":"E4*1","v":0},{"$f":"F4*2","v":0},{"$f":"G4*0.2","v":0},{"$f":"SUM(N4:R4)","v":0}]
["02:00:00",null,null,null,null,null,null,{"$f":"A5","v":8.3333333333333301E-2},null,null,null,null,null,{"$f":"C5*0.286","v":0},{"$f":"D5*0.5","v":0},{"$f":"E5*1","v":0},{"$f":"F5*2","v":0},{"$f":"G5*0.2","v":0},{"$f":"SUM(N5:R5)","v":0}]
["03:00:00",null,null,null,null,null,null,{"$f":"A6","v":0.125},null,"JDT Child Scoring - calculator",null,null,null,0,0,0,0,0,0]
["04:00:00",null,null,null,null,null,null,0.16666666666666699,null,null,null,null,null,0,0,0,0,0,0]
["05:00:00",null,null,null,null,null,null,0.20833333333333301,null,null,null,null,null,0,0,0,0,0,0]
["06:00:00",null,null,null,null,null,null,0.25,null,null,null,null,null,0,0,0,0,0,0]
["07:00:00",null,null,null,null,null,null,0.29166666666666702,null,null,null,null,null,0,0,0,0,0,0]
["08:00:00",null,null,null,null,null,null,0.33333333333333298,null,null,null,null,null,0,0,0,0,0,0]
["09:00:00",null,null,null,null,null,null,0.375,null,null,null,null,null,0,0,0,0,0,0]
["10:00:00",null,null,null,null,null,null,0.41666666666666702,null,null,null,null,null,0,0,0,0,0,0]
["11:00:00",null,null,null,null,null,null,0.45833333333333298,null,null,null,null,null,0,0,0,0,0,0]
["12:00:00",null,null,null,null,null,null,0.5,null,null,null,null,null,0,0,0,0,0,0]
["13:00:00",null,null,null,null,null,null,0.54166666666666696,null,null,null,null,null,0,0,0,0,0,0]
["14:00:00",null,null,null,null,null,null,0.58333333333333304,null,null,null,null,null,0,0,0,0,0,0]
["15:00:00",null,null,null,null,null,null,0.625,null,null,null,null,null,0,0,0,0,0,0]
["16:00:00",null,null,null,null,null,null,0.66666666666666696,null,null,null,null,null,0,0,0,0,0,0]
["17:00:00",null,null,null,null,null,null,0.70833333333333304,null,null,null,null,null,0,0,0,0,0,0]
["18:00:00",null,null,null,null,null,null,0.75,null,null,null,null,null,0,0,0,0,0,0]
["19:00:00",null,null,null,null,null,null,0.79166666666666696,null,null,null,null,null,0,0,0,0,0,0]
["20:00:00",null,null,null,null,null,null,0.83333333333333304,null,null,null,null,null,0,0,0,0,0,0]
["21:00:00",null,null,null,null,null,null,0.875,null,null,null,null,null,0,0,0,0,0,0]
["22:00:00",null,null,null,null,null,null,0.91666666666666696,null,null,null,null,null,0,0,0,0,0,0]
["23:00:00",null,null,null,null,null,null,0.95833333333333304,null,null,null,null,null,0,0,0,0,0,0]

{"sheet":"Day 5","index":13,"n_rows":26,"n_cols":19,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Calculated staffing"]
["Day 5","Rostered staffing","Low dependency","Moderate dependency","High dependency","Total dependency","Wait bed",null,null,"References",null,null,null,"Low dependency","Moderate dependency","High dependency","Total dependency","Wait bed","Calculated staffing requirement"]
["00:00:00",10,1,8,11]
["01:00:00",null,null,null,null,null,null,{"$f":"A4","v":4.1666666666666664E-2},null,"JDT Adult Scoring - calculator",null,null,null,{"$f":"C4*0.286","v":0},{"$f":"D4*0.5","v":0},{"$f":"E4*1","v":0},{"$f":"F4*2","v":0},{"$f":"G4*0.2","v":0},{"$f":"SUM(N4:R4)","v":0}]
["02:00:00",null,null,null,null,null,null,{"$f":"A5","v":8.3333333333333301E-2},null,null,null,null,null,{"$f":"C5*0.286","v":0},{"$f":"D5*0.5","v":0},{"$f":"E5*1","v":0},{"$f":"F5*2","v":0},{"$f":"G5*0.2","v":0},{"$f":"SUM(N5:R5)","v":0}]
["03:00:00",null,null,null,null,null,null,{"$f":"A6","v":0.125},null,"JDT Child Scoring - calculator",null,null,null,0,0,0,0,0,0]
["04:00:00",null,null,null,null,null,null,0.16666666666666699,null,null,null,null,null,0,0,0,0,0,0]
["05:00:00",null,null,null,null,null,null,0.20833333333333301,null,null,null,null,null,0,0,0,0,0,0]
["06:00:00",null,null,null,null,null,null,0.25,null,null,null,null,null,0,0,0,0,0,0]
["07:00:00",null,null,null,null,null,null,0.29166666666666702,null,null,null,null,null,0,0,0,0,0,0]
["08:00:00",null,null,null,null,null,null,0.33333333333333298,null,null,null,null,null,0,0,0,0,0,0]
["09:00:00",null,null,null,null,null,null,0.375,null,null,null,null,null,0,0,0,0,0,0]
["10:00:00",null,null,null,null,null,null,0.41666666666666702,null,null,null,null,null,0,0,0,0,0,0]
["11:00:00",null,null,null,null,null,null,0.45833333333333398,null,null,null,null,null,0,0,0,0,0,0]
["12:00:00",null,null,null,null,null,null,0.5,null,null,null,null,null,0,0,0,0,0,0]
["13:00:00",null,null,null,null,null,null,0.54166666666666696,null,null,null,null,null,0,0,0,0,0,0]
["14:00:00",null,null,null,null,null,null,0.58333333333333404,null,null,null,null,null,0,0,0,0,0,0]
["15:00:00",null,null,null,null,null,null,0.625,null,null,null,null,null,0,0,0,0,0,0]
["16:00:00",null,null,null,null,null,null,0.66666666666666696,null,null,null,null,null,0,0,0,0,0,0]
["17:00:00",null,null,null,null,null,null,0.70833333333333404,null,null,null,null,null,0,0,0,0,0,0]
["18:00:00",null,null,null,null,null,null,0.75,null,null,null,null,null,0,0,0,0,0,0]
["19:00:00",null,null,null,null,null,null,0.79166666666666696,null,null,null,null,null,0,0,0,0,0,0]
["20:00:00",null,null,null,null,null,null,0.83333333333333404,null,null,null,null,null,0,0,0,0,0,0]
["21:00:00",null,null,null,null,null,null,0.875,null,null,null,null,null,0,0,0,0,0,0]
["22:00:00",null,null,null,null,null,null,0.91666666666666696,null,null,null,null,null,0,0,0,0,0,0]
["23:00:00",null,null,null,null,null,null,0.95833333333333404,null,null,null,null,null,0,0,0,0,0,0]

{"sheet":"Day 6","index":14,"n_rows":26,"n_cols":19,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Calculated staffing"]
["Day 6","Rostered staffing","Low dependency","Moderate dependency","High dependency","Total dependency","Wait bed",null,null,"References",null,null,null,"Low dependency","Moderate dependency","High dependency","Total dependency","Wait bed","Calculated staffing requirement"]
["00:00:00"]
["01:00:00",null,null,null,null,null,null,{"$f":"A4","v":4.1666666666666664E-2},null,"JDT Adult Scoring - calculator",null,null,null,{"$f":"C4*0.286","v":0},{"$f":"D4*0.5","v":0},{"$f":"E4*1","v":0},{"$f":"F4*2","v":0},{"$f":"G4*0.2","v":0},{"$f":"SUM(N4:R4)","v":0}]
["02:00:00",null,null,null,null,null,null,{"$f":"A5","v":8.3333333333333301E-2},null,null,null,null,null,{"$f":"C5*0.286","v":0},{"$f":"D5*0.5","v":0},{"$f":"E5*1","v":0},{"$f":"F5*2","v":0},{"$f":"G5*0.2","v":0},{"$f":"SUM(N5:R5)","v":0}]
["03:00:00",null,null,null,null,null,null,{"$f":"A6","v":0.125},null,"JDT Child Scoring - calculator",null,null,null,0,0,0,0,0,0]
["04:00:00",null,null,null,null,null,null,0.16666666666666699,null,null,null,null,null,0,0,0,0,0,0]
["05:00:00",null,null,null,null,null,null,0.20833333333333301,null,null,null,null,null,0,0,0,0,0,0]
["06:00:00",null,null,null,null,null,null,0.25,null,null,null,null,null,0,0,0,0,0,0]
["07:00:00",null,null,null,null,null,null,0.29166666666666702,null,null,null,null,null,0,0,0,0,0,0]
["08:00:00",null,null,null,null,null,null,0.33333333333333298,null,null,null,null,null,0,0,0,0,0,0]
["09:00:00",null,null,null,null,null,null,0.375,null,null,null,null,null,0,0,0,0,0,0]
["10:00:00",null,null,null,null,null,null,0.41666666666666702,null,null,null,null,null,0,0,0,0,0,0]
["11:00:00",null,null,null,null,null,null,0.45833333333333398,null,null,null,null,null,0,0,0,0,0,0]
["12:00:00",null,null,null,null,null,null,0.5,null,null,null,null,null,0,0,0,0,0,0]
["13:00:00",null,null,null,null,null,null,0.54166666666666696,null,null,null,null,null,0,0,0,0,0,0]
["14:00:00",null,null,null,null,null,null,0.58333333333333404,null,null,null,null,null,0,0,0,0,0,0]
["15:00:00",null,null,null,null,null,null,0.625,null,null,null,null,null,0,0,0,0,0,0]
["16:00:00",null,null,null,null,null,null,0.66666666666666696,null,null,null,null,null,0,0,0,0,0,0]
["17:00:00",null,null,null,null,null,null,0.70833333333333404,null,null,null,null,null,0,0,0,0,0,0]
["18:00:00",null,null,null,null,null,null,0.75,null,null,null,null,null,0,0,0,0,0,0]
["19:00:00",null,null,null,null,null,null,0.79166666666666696,null,null,null,null,null,0,0,0,0,0,0]
["20:00:00",null,null,null,null,null,null,0.83333333333333404,null,null,null,null,null,0,0,0,0,0,0]
["21:00:00",null,null,null,null,null,null,0.875,null,null,null,null,null,0,0,0,0,0,0]
["22:00:00",null,null,null,null,null,null,0.91666666666666696,null,null,null,null,null,0,0,0,0,0,0]
["23:00:00",null,null,null,null,null,null,0.95833333333333404,null,null,null,null,null,0,0,0,0,0,0]

{"sheet":"Day 7","index":15,"n_rows":26,"n_cols":19,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Calculated staffing"]
["Day 7","Rostered staffing","Low dependency","Moderate dependency","High dependency","Total dependency","Wait bed",null,null,"References",null,null,null,"Low dependency","Moderate dependency","High dependency","Total dependency","Wait bed","Calculated staffing requirement"]
["00:00:00"]
["01:00:00",null,null,null,null,null,null,{"$f":"A4","v":4.1666666666666664E-2},null,"JDT Adult Scoring - calculator",null,null,null,{"$f":"C4*0.286","v":0},{"$f":"D4*0.5","v":0},{"$f":"E4*1","v":0},{"$f":"F4*2","v":0},{"$f":"G4*0.2","v":0},{"$f":"SUM(N4:R4)","v":0}]
["02:00:00",null,null,null,null,null,null,{"$f":"A5","v":8.3333333333333301E-2},null,null,null,null,null,{"$f":"C5*0.286","v":0},{"$f":"D5*0.5","v":0},{"$f":"E5*1","v":0},{"$f":"F5*2","v":0},{"$f":"G5*0.2","v":0},{"$f":"SUM(N5:R5)","v":0}]
["03:00:00",null,null,null,null,null,null,{"$f":"A6","v":0.125},null,"JDT Child Scoring - calculator",null,null,null,0,0,0,0,0,0]
["04:00:00",null,null,null,null,null,null,0.16666666666666699,null,null,null,null,null,0,0,0,0,0,0]
["05:00:00",null,null,null,null,null,null,0.20833333333333301,null,null,null,null,null,0,0,0,0,0,0]
["06:00:00",null,null,null,null,null,null,0.25,null,null,null,null,null,0,0,0,0,0,0]
["07:00:00",null,null,null,null,null,null,0.29166666666666702,null,null,null,null,null,0,0,0,0,0,0]
["08:00:00",null,null,null,null,null,null,0.33333333333333298,null,null,null,null,null,0,0,0,0,0,0]
["09:00:00",null,null,null,null,null,null,0.375,null,null,null,null,null,0,0,0,0,0,0]
["10:00:00",null,null,null,null,null,null,0.41666666666666702,null,null,null,null,null,0,0,0,0,0,0]
["11:00:00",null,null,null,null,null,null,0.45833333333333398,null,null,null,null,null,0,0,0,0,0,0]
["12:00:00",null,null,null,null,null,null,0.5,null,null,null,null,null,0,0,0,0,0,0]
["13:00:00",null,null,null,null,null,null,0.54166666666666696,null,null,null,null,null,0,0,0,0,0,0]
["14:00:00",null,null,null,null,null,null,0.58333333333333404,null,null,null,null,null,0,0,0,0,0,0]
["15:00:00",null,null,null,null,null,null,0.625,null,null,null,null,null,0,0,0,0,0,0]
["16:00:00",null,null,null,null,null,null,0.66666666666666696,null,null,null,null,null,0,0,0,0,0,0]
["17:00:00",null,null,null,null,null,null,0.70833333333333404,null,null,null,null,null,0,0,0,0,0,0]
["18:00:00",null,null,null,null,null,null,0.75,null,null,null,null,null,0,0,0,0,0,0]
["19:00:00",null,null,null,null,null,null,0.79166666666666696,null,null,null,null,null,0,0,0,0,0,0]
["20:00:00",null,null,null,null,null,null,0.83333333333333404,null,null,null,null,null,0,0,0,0,0,0]
["21:00:00",null,null,null,null,null,null,0.875,null,null,null,null,null,0,0,0,0,0,0]
["22:00:00",null,null,null,null,null,null,0.91666666666666696,null,null,null,null,null,0,0,0,0,0,0]
["23:00:00",null,null,null,null,null,null,0.95833333333333404,null,null,null,null,null,0,0,0,0,0,0]

{"sheet":"WTE Skills Mix","index":16,"n_rows":16,"n_cols":3,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[null,"Whole-time equivalent - ECA BEST TOOL TEST"]
[]
[]
[null,"Daily hours required"]
[null,"Daily hours + on costs @ 25%"]
[null,"Weekly hours"]
[null,"Whole-time equivalent"]
[]
[]
[]
[]
[null,"Skill level","Requirement"]
[null,"Senior Emegency/Emergency Charge Nurses",{"$f":"C7*30%","v":0}]
[null,"Emergency Nurses",{"$f":"40%*C7","v":0}]
[null,"Foundation Staff Nurses",{"$f":"10%*C7","v":0}]
[null,"Clinical Support Workers or Nurse Associates",{"$f":"20%*C7","v":0}]

{"sheet":"Daily Comparison graphs","index":17,"n_rows":38,"n_cols":29,"rows_kept":38,"cut":false,"hidden":false,"merged":[[37,3,37,10],[1,3,1,10],[1,15,1,24],[1,28,1,34],[19,3,19,10],[19,16,19,23],[19,28,19,34]]}
[]
[null,null,null,{"$f":"'Enter new data'!P22","v":"1 February 2021"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Enter new data'!P23","v":"2 January 2018"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Enter new data'!P24","v":"3 January 2018"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,{"$f":"'Enter new data'!P25","v":"4 January 2018"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Enter new data'!P26","v":"5 January 2018"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Enter new data'!P27","v":"6 January 2018"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,{"$f":"'Enter new data'!P28","v":"7 January 2018"}]

{"sheet":"Calculations for wkly graph","index":18,"n_rows":161,"n_cols":25,"rows_kept":161,"cut":false,"hidden":false,"merged":[]}
["Low dependency"]
["Time","Day 1","Day 2","Day 3","Day 4","Day 5","Day 6","Day 7",null,"80th perc","staffing","\"+6.25%\"",null,null,"Time","Low","Mod","High","Total ","Wait bed","Co-ordinator",null,"Staffing - Required (calc)","Staffing - Required (rounded)","Staffing - Planned"]
[1,{"$f":"'Day 1'!C3","v":0},{"$f":"'Day 2'!C3","v":0},{"$f":"'Day 3'!C3","v":0},{"$f":"'Day 4'!C3","v":0},{"$f":"'Day 5'!C3","v":1},{"$f":"'Day 6'!C3","v":0},{"$f":"'Day 7'!C3","v":0},null,{"$f":"PERCENTILE(B3:H3,0.8)","v":0},{"$f":"PRODUCT(J3,0.286)","v":0},{"$f":"K3/100 *6.25+K3","v":0},null,null,"00:00:00",{"$f":"L3","v":0},{"$f":"L30","v":0},{"$f":"L57","v":0},{"$f":"L84","v":0},{"$f":"L111","v":0},1,null,{"$f":"SUM(P3:U3)","v":1},{"$f":"ROUNDUP(W3,0)","v":1},{"$f":"L138","v":2}]
[1.0416666666666701,{"$f":"'Day 1'!C4","v":0},{"$f":"'Day 2'!C4","v":0},{"$f":"'Day 3'!C4","v":0},{"$f":"'Day 4'!C4","v":0},{"$f":"'Day 5'!C4","v":0},{"$f":"'Day 6'!C4","v":0},{"$f":"'Day 7'!C4","v":0},null,{"$f":"PERCENTILE(B4:H4,0.8)","v":0},{"$f":"PRODUCT(J4,0.286)","v":0},{"$f":"K4/100 *6.25+K4","v":0},null,null,1.0416666666666701,{"$f":"L4","v":0},{"$f":"L31","v":0},{"$f":"L58","v":0},{"$f":"L85","v":0},{"$f":"L112","v":0},1,null,{"$f":"SUM(P4:U4)","v":1},{"$f":"ROUNDUP(W4,0)","v":1},{"$f":"L139","v":0}]
[1.0833333333333299,{"$f":"'Day 1'!C5","v":0},{"$f":"'Day 2'!C5","v":0},{"$f":"'Day 3'!C5","v":0},{"$f":"'Day 4'!C5","v":0},{"$f":"'Day 5'!C5","v":0},{"$f":"'Day 6'!C5","v":0},{"$f":"'Day 7'!C5","v":0},null,0,0,0,null,null,1.0833333333333299,0,0,0,0,0,1,null,1,1,0]
[1.125,{"$f":"'Day 1'!C6","v":0},{"$f":"'Day 2'!C6","v":0},{"$f":"'Day 3'!C6","v":0},{"$f":"'Day 4'!C6","v":0},{"$f":"'Day 5'!C6","v":0},{"$f":"'Day 6'!C6","v":0},{"$f":"'Day 7'!C6","v":0},null,0,0,0,null,null,1.125,0,0,0,0,0,1,null,1,1,0]
[1.1666666666666701,{"$f":"'Day 1'!C7","v":0},{"$f":"'Day 2'!C7","v":0},{"$f":"'Day 3'!C7","v":0},{"$f":"'Day 4'!C7","v":0},{"$f":"'Day 5'!C7","v":0},{"$f":"'Day 6'!C7","v":0},{"$f":"'Day 7'!C7","v":0},null,0,0,0,null,null,1.1666666666666701,0,0,0,0,0,1,null,1,1,0]
[1.2083333333333299,{"$f":"'Day 1'!C8","v":0},{"$f":"'Day 2'!C8","v":0},{"$f":"'Day 3'!C8","v":0},{"$f":"'Day 4'!C8","v":0},{"$f":"'Day 5'!C8","v":0},{"$f":"'Day 6'!C8","v":0},{"$f":"'Day 7'!C8","v":0},null,0,0,0,null,null,1.2083333333333299,0,0,0,0,0,1,null,1,1,0]
[1.25,{"$f":"'Day 1'!C9","v":0},{"$f":"'Day 2'!C9","v":0},{"$f":"'Day 3'!C9","v":0},{"$f":"'Day 4'!C9","v":0},{"$f":"'Day 5'!C9","v":0},{"$f":"'Day 6'!C9","v":0},{"$f":"'Day 7'!C9","v":0},null,0,0,0,null,null,1.25,0,0,0,0,0,1,null,1,1,0]
[1.2916666666666701,{"$f":"'Day 1'!C10","v":0},{"$f":"'Day 2'!C10","v":0},{"$f":"'Day 3'!C10","v":0},{"$f":"'Day 4'!C10","v":0},{"$f":"'Day 5'!C10","v":0},{"$f":"'Day 6'!C10","v":0},{"$f":"'Day 7'!C10","v":0},null,0,0,0,null,null,1.2916666666666701,0,0,0,0,0,1,null,1,1,0]
["08:00:00",{"$f":"'Day 1'!C11","v":0},{"$f":"'Day 2'!C11","v":0},{"$f":"'Day 3'!C11","v":0},{"$f":"'Day 4'!C11","v":0},{"$f":"'Day 5'!C11","v":0},{"$f":"'Day 6'!C11","v":0},{"$f":"'Day 7'!C11","v":0},null,0,0,0,null,null,"08:00:00",0,0,0,0,0,1,null,1,1,0]
["09:00:00",{"$f":"'Day 1'!C12","v":0},{"$f":"'Day 2'!C12","v":0},{"$f":"'Day 3'!C12","v":0},{"$f":"'Day 4'!C12","v":0},{"$f":"'Day 5'!C12","v":0},{"$f":"'Day 6'!C12","v":0},{"$f":"'Day 7'!C12","v":0},null,0,0,0,null,null,"09:00:00",0,0,0,0,0,1,null,1,1,0]
["10:00:00",{"$f":"'Day 1'!C13","v":0},{"$f":"'Day 2'!C13","v":0},{"$f":"'Day 3'!C13","v":0},{"$f":"'Day 4'!C13","v":0},{"$f":"'Day 5'!C13","v":0},{"$f":"'Day 6'!C13","v":0},{"$f":"'Day 7'!C13","v":0},null,0,0,0,null,null,"10:00:00",0,0,0,0,0,1,null,1,1,0]
["11:00:00",{"$f":"'Day 1'!C14","v":0},{"$f":"'Day 2'!C14","v":0},{"$f":"'Day 3'!C14","v":0},{"$f":"'Day 4'!C14","v":0},{"$f":"'Day 5'!C14","v":0},{"$f":"'Day 6'!C14","v":0},{"$f":"'Day 7'!C14","v":0},null,0,0,0,null,null,"11:00:00",0,0,0,0,0,1,null,1,1,0]
["12:00:00",{"$f":"'Day 1'!C15","v":0},{"$f":"'Day 2'!C15","v":0},{"$f":"'Day 3'!C15","v":0},{"$f":"'Day 4'!C15","v":0},{"$f":"'Day 5'!C15","v":0},{"$f":"'Day 6'!C15","v":0},{"$f":"'Day 7'!C15","v":0},null,0,0,0,null,null,"12:00:00",0,0,0,0,0,1,null,1,1,0]
["13:00:00",{"$f":"'Day 1'!C16","v":0},{"$f":"'Day 2'!C16","v":0},{"$f":"'Day 3'!C16","v":0},{"$f":"'Day 4'!C16","v":0},{"$f":"'Day 5'!C16","v":0},{"$f":"'Day 6'!C16","v":0},{"$f":"'Day 7'!C16","v":0},null,0,0,0,null,null,"13:00:00",0,0,0,0,0,1,null,1,1,0]
["14:00:00",{"$f":"'Day 1'!C17","v":0},{"$f":"'Day 2'!C17","v":0},{"$f":"'Day 3'!C17","v":0},{"$f":"'Day 4'!C17","v":0},{"$f":"'Day 5'!C17","v":0},{"$f":"'Day 6'!C17","v":0},{"$f":"'Day 7'!C17","v":0},null,0,0,0,null,null,"14:00:00",0,0,0,0,0,1,null,1,1,0]
["15:00:00",{"$f":"'Day 1'!C18","v":0},{"$f":"'Day 2'!C18","v":0},{"$f":"'Day 3'!C18","v":0},{"$f":"'Day 4'!C18","v":0},{"$f":"'Day 5'!C18","v":0},{"$f":"'Day 6'!C18","v":0},{"$f":"'Day 7'!C18","v":0},null,0,0,0,null,null,"15:00:00",0,0,0,0,0,1,null,1,1,0]
["16:00:00",{"$f":"'Day 1'!C19","v":0},{"$f":"'Day 2'!C19","v":0},{"$f":"'Day 3'!C19","v":0},{"$f":"'Day 4'!C19","v":0},{"$f":"'Day 5'!C19","v":0},{"$f":"'Day 6'!C19","v":0},{"$f":"'Day 7'!C19","v":0},null,0,0,0,null,null,"16:00:00",0,0,0,0,0,1,null,1,1,0]
["17:00:00",{"$f":"'Day 1'!C20","v":0},{"$f":"'Day 2'!C20","v":0},{"$f":"'Day 3'!C20","v":0},{"$f":"'Day 4'!C20","v":0},{"$f":"'Day 5'!C20","v":0},{"$f":"'Day 6'!C20","v":0},{"$f":"'Day 7'!C20","v":0},null,0,0,0,null,null,"17:00:00",0,0,0,0,0,1,null,1,1,0]
["18:00:00",{"$f":"'Day 1'!C21","v":0},{"$f":"'Day 2'!C21","v":0},{"$f":"'Day 3'!C21","v":0},{"$f":"'Day 4'!C21","v":0},{"$f":"'Day 5'!C21","v":0},{"$f":"'Day 6'!C21","v":0},{"$f":"'Day 7'!C21","v":0},null,0,0,0,null,null,"18:00:00",0,0,0,0,0,1,null,1,1,0]
["19:00:00",{"$f":"'Day 1'!C22","v":0},{"$f":"'Day 2'!C22","v":0},{"$f":"'Day 3'!C22","v":0},{"$f":"'Day 4'!C22","v":0},{"$f":"'Day 5'!C22","v":0},{"$f":"'Day 6'!C22","v":0},{"$f":"'Day 7'!C22","v":0},null,0,0,0,null,null,"19:00:00",0,0,0,0,0,1,null,1,1,0]
["20:00:00",{"$f":"'Day 1'!C23","v":0},{"$f":"'Day 2'!C23","v":0},{"$f":"'Day 3'!C23","v":0},{"$f":"'Day 4'!C23","v":0},{"$f":"'Day 5'!C23","v":0},{"$f":"'Day 6'!C23","v":0},{"$f":"'Day 7'!C23","v":0},null,0,0,0,null,null,"20:00:00",0,0,0,0,0,1,null,1,1,0]
["21:00:00",{"$f":"'Day 1'!C24","v":0},{"$f":"'Day 2'!C24","v":0},{"$f":"'Day 3'!C24","v":0},{"$f":"'Day 4'!C24","v":0},{"$f":"'Day 5'!C24","v":0},{"$f":"'Day 6'!C24","v":0},{"$f":"'Day 7'!C24","v":0},null,0,0,0,null,null,"21:00:00",0,0,0,0,0,1,null,1,1,0]
["22:00:00",{"$f":"'Day 1'!C25","v":0},{"$f":"'Day 2'!C25","v":0},{"$f":"'Day 3'!C25","v":0},{"$f":"'Day 4'!C25","v":0},{"$f":"'Day 5'!C25","v":0},{"$f":"'Day 6'!C25","v":0},{"$f":"'Day 7'!C25","v":0},null,0,0,0,null,null,"22:00:00",0,0,0,0,0,1,null,1,1,0]
["23:00:00",{"$f":"'Day 1'!C26","v":0},{"$f":"'Day 2'!C26","v":0},{"$f":"'Day 3'!C26","v":0},{"$f":"'Day 4'!C26","v":0},{"$f":"'Day 5'!C26","v":0},{"$f":"'Day 6'!C26","v":0},{"$f":"'Day 7'!C26","v":0},null,0,0,0,null,null,"23:00:00",0,0,0,0,0,1,null,1,1,0]
[]
["Moderate dependency"]
["Time","Day 1","Day 2","Day 3","Day 4","Day 5","Day 6","Day 7",null,"80th perce","staffing","\"+6.25%\""]
[1,{"$f":"'Day 1'!D3","v":0},{"$f":"'Day 2'!D3","v":0},{"$f":"'Day 3'!D3","v":0},{"$f":"'Day 4'!D3","v":0},{"$f":"'Day 5'!D3","v":8},{"$f":"'Day 6'!D3","v":0},{"$f":"'Day 7'!D3","v":0},null,{"$f":"PERCENTILE(B30:H30,0.8)","v":0},{"$f":"PRODUCT(J30,0.5)","v":0},{"$f":"K30/100*6.25 +K30","v":0}]
[1.0416666666666701,{"$f":"'Day 1'!D4","v":0},{"$f":"'Day 2'!D4","v":0},{"$f":"'Day 3'!D4","v":0},{"$f":"'Day 4'!D4","v":0},{"$f":"'Day 5'!D4","v":0},{"$f":"'Day 6'!D4","v":0},{"$f":"'Day 7'!D4","v":0},null,0,{"$f":"PRODUCT(J31,0.5)","v":0},{"$f":"K31/100*6.25 +K31","v":0}]
[1.0833333333333299,{"$f":"'Day 1'!D5","v":0},{"$f":"'Day 2'!D5","v":0},{"$f":"'Day 3'!D5","v":0},{"$f":"'Day 4'!D5","v":0},{"$f":"'Day 5'!D5","v":0},{"$f":"'Day 6'!D5","v":0},{"$f":"'Day 7'!D5","v":0},null,0,0,0]
[1.125,{"$f":"'Day 1'!D6","v":0},{"$f":"'Day 2'!D6","v":0},{"$f":"'Day 3'!D6","v":0},{"$f":"'Day 4'!D6","v":0},{"$f":"'Day 5'!D6","v":0},{"$f":"'Day 6'!D6","v":0},{"$f":"'Day 7'!D6","v":0},null,0,0,0]
[1.1666666666666701,{"$f":"'Day 1'!D7","v":0},{"$f":"'Day 2'!D7","v":0},{"$f":"'Day 3'!D7","v":0},{"$f":"'Day 4'!D7","v":0},{"$f":"'Day 5'!D7","v":0},{"$f":"'Day 6'!D7","v":0},{"$f":"'Day 7'!D7","v":0},null,0,0,0]
[1.2083333333333299,{"$f":"'Day 1'!D8","v":0},{"$f":"'Day 2'!D8","v":0},{"$f":"'Day 3'!D8","v":0},{"$f":"'Day 4'!D8","v":0},{"$f":"'Day 5'!D8","v":0},{"$f":"'Day 6'!D8","v":0},{"$f":"'Day 7'!D8","v":0},null,0,0,0]
[1.25,{"$f":"'Day 1'!D9","v":0},{"$f":"'Day 2'!D9","v":0},{"$f":"'Day 3'!D9","v":0},{"$f":"'Day 4'!D9","v":0},{"$f":"'Day 5'!D9","v":0},{"$f":"'Day 6'!D9","v":0},{"$f":"'Day 7'!D9","v":0},null,0,0,0]
[1.2916666666666701,{"$f":"'Day 1'!D10","v":0},{"$f":"'Day 2'!D10","v":0},{"$f":"'Day 3'!D10","v":0},{"$f":"'Day 4'!D10","v":0},{"$f":"'Day 5'!D10","v":0},{"$f":"'Day 6'!D10","v":0},{"$f":"'Day 7'!D10","v":0},null,0,0,0]
["08:00:00",{"$f":"'Day 1'!D11","v":0},{"$f":"'Day 2'!D11","v":0},{"$f":"'Day 3'!D11","v":0},{"$f":"'Day 4'!D11","v":0},{"$f":"'Day 5'!D11","v":0},{"$f":"'Day 6'!D11","v":0},{"$f":"'Day 7'!D11","v":0},null,0,0,0]
["09:00:00",{"$f":"'Day 1'!D12","v":0},{"$f":"'Day 2'!D12","v":0},{"$f":"'Day 3'!D12","v":0},{"$f":"'Day 4'!D12","v":0},{"$f":"'Day 5'!D12","v":0},{"$f":"'Day 6'!D12","v":0},{"$f":"'Day 7'!D12","v":0},null,0,0,0]
["10:00:00",{"$f":"'Day 1'!D13","v":0},{"$f":"'Day 2'!D13","v":0},{"$f":"'Day 3'!D13","v":0},{"$f":"'Day 4'!D13","v":0},{"$f":"'Day 5'!D13","v":0},{"$f":"'Day 6'!D13","v":0},{"$f":"'Day 7'!D13","v":0},null,0,0,0]
["11:00:00",{"$f":"'Day 1'!D14","v":0},{"$f":"'Day 2'!D14","v":0},{"$f":"'Day 3'!D14","v":0},{"$f":"'Day 4'!D14","v":0},{"$f":"'Day 5'!D14","v":0},{"$f":"'Day 6'!D14","v":0},{"$f":"'Day 7'!D14","v":0},null,0,0,0]
["12:00:00",{"$f":"'Day 1'!D15","v":0},{"$f":"'Day 2'!D15","v":0},{"$f":"'Day 3'!D15","v":0},{"$f":"'Day 4'!D15","v":0},{"$f":"'Day 5'!D15","v":0},{"$f":"'Day 6'!D15","v":0},{"$f":"'Day 7'!D15","v":0},null,0,0,0]
["13:00:00",{"$f":"'Day 1'!D16","v":0},{"$f":"'Day 2'!D16","v":0},{"$f":"'Day 3'!D16","v":0},{"$f":"'Day 4'!D16","v":0},{"$f":"'Day 5'!D16","v":0},{"$f":"'Day 6'!D16","v":0},{"$f":"'Day 7'!D16","v":0},null,0,0,0]
["14:00:00",{"$f":"'Day 1'!D17","v":0},{"$f":"'Day 2'!D17","v":0},{"$f":"'Day 3'!D17","v":0},{"$f":"'Day 4'!D17","v":0},{"$f":"'Day 5'!D17","v":0},{"$f":"'Day 6'!D17","v":0},{"$f":"'Day 7'!D17","v":0},null,0,0,0]
["15:00:00",{"$f":"'Day 1'!D18","v":0},{"$f":"'Day 2'!D18","v":0},{"$f":"'Day 3'!D18","v":0},{"$f":"'Day 4'!D18","v":0},{"$f":"'Day 5'!D18","v":0},{"$f":"'Day 6'!D18","v":0},{"$f":"'Day 7'!D18","v":0},null,0,0,0]
["16:00:00",{"$f":"'Day 1'!D19","v":0},{"$f":"'Day 2'!D19","v":0},{"$f":"'Day 3'!D19","v":0},{"$f":"'Day 4'!D19","v":0},{"$f":"'Day 5'!D19","v":0},{"$f":"'Day 6'!D19","v":0},{"$f":"'Day 7'!D19","v":0},null,0,0,0]
["17:00:00",{"$f":"'Day 1'!D20","v":0},{"$f":"'Day 2'!D20","v":0},{"$f":"'Day 3'!D20","v":0},{"$f":"'Day 4'!D20","v":0},{"$f":"'Day 5'!D20","v":0},{"$f":"'Day 6'!D20","v":0},{"$f":"'Day 7'!D20","v":0},null,0,0,0]
["18:00:00",{"$f":"'Day 1'!D21","v":0},{"$f":"'Day 2'!D21","v":0},{"$f":"'Day 3'!D21","v":0},{"$f":"'Day 4'!D21","v":0},{"$f":"'Day 5'!D21","v":0},{"$f":"'Day 6'!D21","v":0},{"$f":"'Day 7'!D21","v":0},null,0,0,0]
["19:00:00",{"$f":"'Day 1'!D22","v":0},{"$f":"'Day 2'!D22","v":0},{"$f":"'Day 3'!D22","v":0},{"$f":"'Day 4'!D22","v":0},{"$f":"'Day 5'!D22","v":0},{"$f":"'Day 6'!D22","v":0},{"$f":"'Day 7'!D22","v":0},null,0,0,0]
["20:00:00",{"$f":"'Day 1'!D23","v":0},{"$f":"'Day 2'!D23","v":0},{"$f":"'Day 3'!D23","v":0},{"$f":"'Day 4'!D23","v":0},{"$f":"'Day 5'!D23","v":0},{"$f":"'Day 6'!D23","v":0},{"$f":"'Day 7'!D23","v":0},null,0,0,0]
["21:00:00",{"$f":"'Day 1'!D24","v":0},{"$f":"'Day 2'!D24","v":0},{"$f":"'Day 3'!D24","v":0},{"$f":"'Day 4'!D24","v":0},{"$f":"'Day 5'!D24","v":0},{"$f":"'Day 6'!D24","v":0},{"$f":"'Day 7'!D24","v":0},null,0,0,0]
["22:00:00",{"$f":"'Day 1'!D25","v":0},{"$f":"'Day 2'!D25","v":0},{"$f":"'Day 3'!D25","v":0},{"$f":"'Day 4'!D25","v":0},{"$f":"'Day 5'!D25","v":0},{"$f":"'Day 6'!D25","v":0},{"$f":"'Day 7'!D25","v":0},null,0,0,0]
["23:00:00",{"$f":"'Day 1'!D26","v":0},{"$f":"'Day 2'!D26","v":0},{"$f":"'Day 3'!D26","v":0},{"$f":"'Day 4'!D26","v":0},{"$f":"'Day 5'!D26","v":0},{"$f":"'Day 6'!D26","v":0},{"$f":"'Day 7'!D26","v":0},null,0,0,0]
[]
["High dependency"]
["Time","Day 1","Day 2","Day 3","Day 4","Day 5","Day 6","Day 7",null,"80th perc","staffing","\"+6.25%\""]
[1,{"$f":"'Day 1'!E3","v":0},{"$f":"'Day 2'!E3","v":0},{"$f":"'Day 3'!E3","v":0},{"$f":"'Day 4'!E3","v":0},{"$f":"'Day 5'!E3","v":11},{"$f":"'Day 6'!E3","v":0},{"$f":"'Day 7'!E3","v":0},null,{"$f":"PERCENTILE(B57:H57,0.8)","v":0},{"$f":"J57","v":0},{"$f":"K57/100*6.25+K57","v":0}]
[1.0416666666666701,{"$f":"'Day 1'!E4","v":0},{"$f":"'Day 2'!E4","v":0},{"$f":"'Day 3'!E4","v":0},{"$f":"'Day 4'!E4","v":0},{"$f":"'Day 5'!E4","v":0},{"$f":"'Day 6'!E4","v":0},{"$f":"'Day 7'!E4","v":0},null,0,0,{"$f":"K58/100*6.25+K58","v":0}]
[1.0833333333333299,{"$f":"'Day 1'!E5","v":0},{"$f":"'Day 2'!E5","v":0},{"$f":"'Day 3'!E5","v":0},{"$f":"'Day 4'!E5","v":0},{"$f":"'Day 5'!E5","v":0},{"$f":"'Day 6'!E5","v":0},{"$f":"'Day 7'!E5","v":0},null,0,0,0]
[1.125,{"$f":"'Day 1'!E6","v":0},{"$f":"'Day 2'!E6","v":0},{"$f":"'Day 3'!E6","v":0},{"$f":"'Day 4'!E6","v":0},{"$f":"'Day 5'!E6","v":0},{"$f":"'Day 6'!E6","v":0},{"$f":"'Day 7'!E6","v":0},null,0,0,0]
[1.1666666666666701,{"$f":"'Day 1'!E7","v":0},{"$f":"'Day 2'!E7","v":0},{"$f":"'Day 3'!E7","v":0},{"$f":"'Day 4'!E7","v":0},{"$f":"'Day 5'!E7","v":0},{"$f":"'Day 6'!E7","v":0},{"$f":"'Day 7'!E7","v":0},null,0,0,0]
[1.2083333333333299,{"$f":"'Day 1'!E8","v":0},{"$f":"'Day 2'!E8","v":0},{"$f":"'Day 3'!E8","v":0},{"$f":"'Day 4'!E8","v":0},{"$f":"'Day 5'!E8","v":0},{"$f":"'Day 6'!E8","v":0},{"$f":"'Day 7'!E8","v":0},null,0,0,0]
[1.25,{"$f":"'Day 1'!E9","v":0},{"$f":"'Day 2'!E9","v":0},{"$f":"'Day 3'!E9","v":0},{"$f":"'Day 4'!E9","v":0},{"$f":"'Day 5'!E9","v":0},{"$f":"'Day 6'!E9","v":0},{"$f":"'Day 7'!E9","v":0},null,0,0,0]
[1.2916666666666701,{"$f":"'Day 1'!E10","v":0},{"$f":"'Day 2'!E10","v":0},{"$f":"'Day 3'!E10","v":0},{"$f":"'Day 4'!E10","v":0},{"$f":"'Day 5'!E10","v":0},{"$f":"'Day 6'!E10","v":0},{"$f":"'Day 7'!E10","v":0},null,0,0,0]
["08:00:00",{"$f":"'Day 1'!E11","v":0},{"$f":"'Day 2'!E11","v":0},{"$f":"'Day 3'!E11","v":0},{"$f":"'Day 4'!E11","v":0},{"$f":"'Day 5'!E11","v":0},{"$f":"'Day 6'!E11","v":0},{"$f":"'Day 7'!E11","v":0},null,0,0,0]
["09:00:00",{"$f":"'Day 1'!E12","v":0},{"$f":"'Day 2'!E12","v":0},{"$f":"'Day 3'!E12","v":0},{"$f":"'Day 4'!E12","v":0},{"$f":"'Day 5'!E12","v":0},{"$f":"'Day 6'!E12","v":0},{"$f":"'Day 7'!E12","v":0},null,0,0,0]
["10:00:00",{"$f":"'Day 1'!E13","v":0},{"$f":"'Day 2'!E13","v":0},{"$f":"'Day 3'!E13","v":0},{"$f":"'Day 4'!E13","v":0},{"$f":"'Day 5'!E13","v":0},{"$f":"'Day 6'!E13","v":0},{"$f":"'Day 7'!E13","v":0},null,0,0,0]
["11:00:00",{"$f":"'Day 1'!E14","v":0},{"$f":"'Day 2'!E14","v":0},{"$f":"'Day 3'!E14","v":0},{"$f":"'Day 4'!E14","v":0},{"$f":"'Day 5'!E14","v":0},{"$f":"'Day 6'!E14","v":0},{"$f":"'Day 7'!E14","v":0},null,0,0,0]
["12:00:00",{"$f":"'Day 1'!E15","v":0},{"$f":"'Day 2'!E15","v":0},{"$f":"'Day 3'!E15","v":0},{"$f":"'Day 4'!E15","v":0},{"$f":"'Day 5'!E15","v":0},{"$f":"'Day 6'!E15","v":0},{"$f":"'Day 7'!E15","v":0},null,0,0,0]
["13:00:00",{"$f":"'Day 1'!E16","v":0},{"$f":"'Day 2'!E16","v":0},{"$f":"'Day 3'!E16","v":0},{"$f":"'Day 4'!E16","v":0},{"$f":"'Day 5'!E16","v":0},{"$f":"'Day 6'!E16","v":0},{"$f":"'Day 7'!E16","v":0},null,0,0,0]
["14:00:00",{"$f":"'Day 1'!E17","v":0},{"$f":"'Day 2'!E17","v":0},{"$f":"'Day 3'!E17","v":0},{"$f":"'Day 4'!E17","v":0},{"$f":"'Day 5'!E17","v":0},{"$f":"'Day 6'!E17","v":0},{"$f":"'Day 7'!E17","v":0},null,0,0,0]
["15:00:00",{"$f":"'Day 1'!E18","v":0},{"$f":"'Day 2'!E18","v":0},{"$f":"'Day 3'!E18","v":0},{"$f":"'Day 4'!E18","v":0},{"$f":"'Day 5'!E18","v":0},{"$f":"'Day 6'!E18","v":0},{"$f":"'Day 7'!E18","v":0},null,0,0,0]
["16:00:00",{"$f":"'Day 1'!E19","v":0},{"$f":"'Day 2'!E19","v":0},{"$f":"'Day 3'!E19","v":0},{"$f":"'Day 4'!E19","v":0},{"$f":"'Day 5'!E19","v":0},{"$f":"'Day 6'!E19","v":0},{"$f":"'Day 7'!E19","v":0},null,0,0,0]
["17:00:00",{"$f":"'Day 1'!E20","v":0},{"$f":"'Day 2'!E20","v":0},{"$f":"'Day 3'!E20","v":0},{"$f":"'Day 4'!E20","v":0},{"$f":"'Day 5'!E20","v":0},{"$f":"'Day 6'!E20","v":0},{"$f":"'Day 7'!E20","v":0},null,0,0,0]
["18:00:00",{"$f":"'Day 1'!E21","v":0},{"$f":"'Day 2'!E21","v":0},{"$f":"'Day 3'!E21","v":0},{"$f":"'Day 4'!E21","v":0},{"$f":"'Day 5'!E21","v":0},{"$f":"'Day 6'!E21","v":0},{"$f":"'Day 7'!E21","v":0},null,0,0,0]
["19:00:00",{"$f":"'Day 1'!E22","v":0},{"$f":"'Day 2'!E22","v":0},{"$f":"'Day 3'!E22","v":0},{"$f":"'Day 4'!E22","v":0},{"$f":"'Day 5'!E22","v":0},{"$f":"'Day 6'!E22","v":0},{"$f":"'Day 7'!E22","v":0},null,0,0,0]
["20:00:00",{"$f":"'Day 1'!E23","v":0},{"$f":"'Day 2'!E23","v":0},{"$f":"'Day 3'!E23","v":0},{"$f":"'Day 4'!E23","v":0},{"$f":"'Day 5'!E23","v":0},{"$f":"'Day 6'!E23","v":0},{"$f":"'Day 7'!E23","v":0},null,0,0,0]
["21:00:00",{"$f":"'Day 1'!E24","v":0},{"$f":"'Day 2'!E24","v":0},{"$f":"'Day 3'!E24","v":0},{"$f":"'Day 4'!E24","v":0},{"$f":"'Day 5'!E24","v":0},{"$f":"'Day 6'!E24","v":0},{"$f":"'Day 7'!E24","v":0},null,0,0,0]
["22:00:00",{"$f":"'Day 1'!E25","v":0},{"$f":"'Day 2'!E25","v":0},{"$f":"'Day 3'!E25","v":0},{"$f":"'Day 4'!E25","v":0},{"$f":"'Day 5'!E25","v":0},{"$f":"'Day 6'!E25","v":0},{"$f":"'Day 7'!E25","v":0},null,0,0,0]
["23:00:00",{"$f":"'Day 1'!E26","v":0},{"$f":"'Day 2'!E26","v":0},{"$f":"'Day 3'!E26","v":0},{"$f":"'Day 4'!E26","v":0},{"$f":"'Day 5'!E26","v":0},{"$f":"'Day 6'!E26","v":0},{"$f":"'Day 7'!E26","v":0},null,0,0,0]
[]
["Total dependency"]
["Time","Day 1","Day 2","Day 3","Day 4","Day 5","Day 6","Day 7",null,"80th perc","staffing","\"+6.25%\""]
[1,{"$f":"'Day 1'!F3","v":0},{"$f":"'Day 2'!F3","v":0},{"$f":"'Day 3'!F3","v":0},{"$f":"'Day 4'!F3","v":0},{"$f":"'Day 5'!F3","v":0},{"$f":"'Day 6'!F3","v":0},{"$f":"'Day 7'!F3","v":0},null,{"$f":"PERCENTILE(B84:H84,0.8)","v":0},{"$f":"J84*2","v":0},{"$f":"K84/100*6.25+K84","v":0}]
[1.0416666666666701,{"$f":"'Day 1'!F4","v":0},{"$f":"'Day 2'!F4","v":0},{"$f":"'Day 3'!F4","v":0},{"$f":"'Day 4'!F4","v":0},{"$f":"'Day 5'!F4","v":0},{"$f":"'Day 6'!F4","v":0},{"$f":"'Day 7'!F4","v":0},null,0,{"$f":"J85*2","v":0},{"$f":"K85/100*6.25+K85","v":0}]
[1.0833333333333299,{"$f":"'Day 1'!F5","v":0},{"$f":"'Day 2'!F5","v":0},{"$f":"'Day 3'!F5","v":0},{"$f":"'Day 4'!F5","v":0},{"$f":"'Day 5'!F5","v":0},{"$f":"'Day 6'!F5","v":0},{"$f":"'Day 7'!F5","v":0},null,0,0,0]
[1.125,{"$f":"'Day 1'!F6","v":0},{"$f":"'Day 2'!F6","v":0},{"$f":"'Day 3'!F6","v":0},{"$f":"'Day 4'!F6","v":0},{"$f":"'Day 5'!F6","v":0},{"$f":"'Day 6'!F6","v":0},{"$f":"'Day 7'!F6","v":0},null,0,0,0]
[1.1666666666666701,{"$f":"'Day 1'!F7","v":0},{"$f":"'Day 2'!F7","v":0},{"$f":"'Day 3'!F7","v":0},{"$f":"'Day 4'!F7","v":0},{"$f":"'Day 5'!F7","v":0},{"$f":"'Day 6'!F7","v":0},{"$f":"'Day 7'!F7","v":0},null,0,0,0]
[1.2083333333333299,{"$f":"'Day 1'!F8","v":0},{"$f":"'Day 2'!F8","v":0},{"$f":"'Day 3'!F8","v":0},{"$f":"'Day 4'!F8","v":0},{"$f":"'Day 5'!F8","v":0},{"$f":"'Day 6'!F8","v":0},{"$f":"'Day 7'!F8","v":0},null,0,0,0]
[1.25,{"$f":"'Day 1'!F9","v":0},{"$f":"'Day 2'!F9","v":0},{"$f":"'Day 3'!F9","v":0},{"$f":"'Day 4'!F9","v":0},{"$f":"'Day 5'!F9","v":0},{"$f":"'Day 6'!F9","v":0},{"$f":"'Day 7'!F9","v":0},null,0,0,0]
[1.2916666666666701,{"$f":"'Day 1'!F10","v":0},{"$f":"'Day 2'!F10","v":0},{"$f":"'Day 3'!F10","v":0},{"$f":"'Day 4'!F10","v":0},{"$f":"'Day 5'!F10","v":0},{"$f":"'Day 6'!F10","v":0},{"$f":"'Day 7'!F10","v":0},null,0,0,0]
["08:00:00",{"$f":"'Day 1'!F11","v":0},{"$f":"'Day 2'!F11","v":0},{"$f":"'Day 3'!F11","v":0},{"$f":"'Day 4'!F11","v":0},{"$f":"'Day 5'!F11","v":0},{"$f":"'Day 6'!F11","v":0},{"$f":"'Day 7'!F11","v":0},null,0,0,0]
["09:00:00",{"$f":"'Day 1'!F12","v":0},{"$f":"'Day 2'!F12","v":0},{"$f":"'Day 3'!F12","v":0},{"$f":"'Day 4'!F12","v":0},{"$f":"'Day 5'!F12","v":0},{"$f":"'Day 6'!F12","v":0},{"$f":"'Day 7'!F12","v":0},null,0,0,0]
["10:00:00",{"$f":"'Day 1'!F13","v":0},{"$f":"'Day 2'!F13","v":0},{"$f":"'Day 3'!F13","v":0},{"$f":"'Day 4'!F13","v":0},{"$f":"'Day 5'!F13","v":0},{"$f":"'Day 6'!F13","v":0},{"$f":"'Day 7'!F13","v":0},null,0,0,0]
["11:00:00",{"$f":"'Day 1'!F14","v":0},{"$f":"'Day 2'!F14","v":0},{"$f":"'Day 3'!F14","v":0},{"$f":"'Day 4'!F14","v":0},{"$f":"'Day 5'!F14","v":0},{"$f":"'Day 6'!F14","v":0},{"$f":"'Day 7'!F14","v":0},null,0,0,0]
["12:00:00",{"$f":"'Day 1'!F15","v":0},{"$f":"'Day 2'!F15","v":0},{"$f":"'Day 3'!F15","v":0},{"$f":"'Day 4'!F15","v":0},{"$f":"'Day 5'!F15","v":0},{"$f":"'Day 6'!F15","v":0},{"$f":"'Day 7'!F15","v":0},null,0,0,0]
["13:00:00",{"$f":"'Day 1'!F16","v":0},{"$f":"'Day 2'!F16","v":0},{"$f":"'Day 3'!F16","v":0},{"$f":"'Day 4'!F16","v":0},{"$f":"'Day 5'!F16","v":0},{"$f":"'Day 6'!F16","v":0},{"$f":"'Day 7'!F16","v":0},null,0,0,0]
["14:00:00",{"$f":"'Day 1'!F17","v":0},{"$f":"'Day 2'!F17","v":0},{"$f":"'Day 3'!F17","v":0},{"$f":"'Day 4'!F17","v":0},{"$f":"'Day 5'!F17","v":0},{"$f":"'Day 6'!F17","v":0},{"$f":"'Day 7'!F17","v":0},null,0,0,0]
["15:00:00",{"$f":"'Day 1'!F18","v":0},{"$f":"'Day 2'!F18","v":0},{"$f":"'Day 3'!F18","v":0},{"$f":"'Day 4'!F18","v":0},{"$f":"'Day 5'!F18","v":0},{"$f":"'Day 6'!F18","v":0},{"$f":"'Day 7'!F18","v":0},null,0,0,0]
["16:00:00",{"$f":"'Day 1'!F19","v":0},{"$f":"'Day 2'!F19","v":0},{"$f":"'Day 3'!F19","v":0},{"$f":"'Day 4'!F19","v":0},{"$f":"'Day 5'!F19","v":0},{"$f":"'Day 6'!F19","v":0},{"$f":"'Day 7'!F19","v":0},null,0,0,0]
["17:00:00",{"$f":"'Day 1'!F20","v":0},{"$f":"'Day 2'!F20","v":0},{"$f":"'Day 3'!F20","v":0},{"$f":"'Day 4'!F20","v":0},{"$f":"'Day 5'!F20","v":0},{"$f":"'Day 6'!F20","v":0},{"$f":"'Day 7'!F20","v":0},null,0,0,0]
["18:00:00",{"$f":"'Day 1'!F21","v":0},{"$f":"'Day 2'!F21","v":0},{"$f":"'Day 3'!F21","v":0},{"$f":"'Day 4'!F21","v":0},{"$f":"'Day 5'!F21","v":0},{"$f":"'Day 6'!F21","v":0},{"$f":"'Day 7'!F21","v":0},null,0,0,0]
["19:00:00",{"$f":"'Day 1'!F22","v":0},{"$f":"'Day 2'!F22","v":0},{"$f":"'Day 3'!F22","v":0},{"$f":"'Day 4'!F22","v":0},{"$f":"'Day 5'!F22","v":0},{"$f":"'Day 6'!F22","v":0},{"$f":"'Day 7'!F22","v":0},null,0,0,0]
["20:00:00",{"$f":"'Day 1'!F23","v":0},{"$f":"'Day 2'!F23","v":0},{"$f":"'Day 3'!F23","v":0},{"$f":"'Day 4'!F23","v":0},{"$f":"'Day 5'!F23","v":0},{"$f":"'Day 6'!F23","v":0},{"$f":"'Day 7'!F23","v":0},null,0,0,0]
["21:00:00",{"$f":"'Day 1'!F24","v":0},{"$f":"'Day 2'!F24","v":0},{"$f":"'Day 3'!F24","v":0},{"$f":"'Day 4'!F24","v":0},{"$f":"'Day 5'!F24","v":0},{"$f":"'Day 6'!F24","v":0},{"$f":"'Day 7'!F24","v":0},null,0,0,0]
["22:00:00",{"$f":"'Day 1'!F25","v":0},{"$f":"'Day 2'!F25","v":0},{"$f":"'Day 3'!F25","v":0},{"$f":"'Day 4'!F25","v":0},{"$f":"'Day 5'!F25","v":0},{"$f":"'Day 6'!F25","v":0},{"$f":"'Day 7'!F25","v":0},null,0,0,0]
["23:00:00",{"$f":"'Day 1'!F26","v":0},{"$f":"'Day 2'!F26","v":0},{"$f":"'Day 3'!F26","v":0},{"$f":"'Day 4'!F26","v":0},{"$f":"'Day 5'!F26","v":0},{"$f":"'Day 6'!F26","v":0},{"$f":"'Day 7'!F26","v":0},null,0,0,0]
[]
["Wait bed"]
["Time","Day 1","Day 2","Day 3","Day 4","Day 5","Day 6","Day 7",null,"80th perc","staffing","\"+6.25%\""]
[1,{"$f":"'Day 1'!G3","v":0},{"$f":"'Day 2'!G3","v":0},{"$f":"'Day 3'!G3","v":0},{"$f":"'Day 4'!G3","v":0},{"$f":"'Day 5'!G3","v":0},{"$f":"'Day 6'!G3","v":0},{"$f":"'Day 7'!G3","v":0},null,{"$f":"PERCENTILE(B111:H111,0.8)","v":0},{"$f":"PRODUCT(J111,0.2)","v":0},{"$f":"K111/100*6.25+K111","v":0}]
[1.0416666666666701,{"$f":"'Day 1'!G4","v":0},{"$f":"'Day 2'!G4","v":0},{"$f":"'Day 3'!G4","v":0},{"$f":"'Day 4'!G4","v":0},{"$f":"'Day 5'!G4","v":0},{"$f":"'Day 6'!G4","v":0},{"$f":"'Day 7'!G4","v":0},null,0,{"$f":"PRODUCT(J112,0.2)","v":0},{"$f":"K112/100*6.25+K112","v":0}]
[1.0833333333333299,{"$f":"'Day 1'!G5","v":0},{"$f":"'Day 2'!G5","v":0},{"$f":"'Day 3'!G5","v":0},{"$f":"'Day 4'!G5","v":0},{"$f":"'Day 5'!G5","v":0},{"$f":"'Day 6'!G5","v":0},{"$f":"'Day 7'!G5","v":0},null,0,0,0]
[1.125,{"$f":"'Day 1'!G6","v":0},{"$f":"'Day 2'!G6","v":0},{"$f":"'Day 3'!G6","v":0},{"$f":"'Day 4'!G6","v":0},{"$f":"'Day 5'!G6","v":0},{"$f":"'Day 6'!G6","v":0},{"$f":"'Day 7'!G6","v":0},null,0,0,0]
[1.1666666666666701,{"$f":"'Day 1'!G7","v":0},{"$f":"'Day 2'!G7","v":0},{"$f":"'Day 3'!G7","v":0},{"$f":"'Day 4'!G7","v":0},{"$f":"'Day 5'!G7","v":0},{"$f":"'Day 6'!G7","v":0},{"$f":"'Day 7'!G7","v":0},null,0,0,0]
[1.2083333333333299,{"$f":"'Day 1'!G8","v":0},{"$f":"'Day 2'!G8","v":0},{"$f":"'Day 3'!G8","v":0},{"$f":"'Day 4'!G8","v":0},{"$f":"'Day 5'!G8","v":0},{"$f":"'Day 6'!G8","v":0},{"$f":"'Day 7'!G8","v":0},null,0,0,0]
[1.25,{"$f":"'Day 1'!G9","v":0},{"$f":"'Day 2'!G9","v":0},{"$f":"'Day 3'!G9","v":0},{"$f":"'Day 4'!G9","v":0},{"$f":"'Day 5'!G9","v":0},{"$f":"'Day 6'!G9","v":0},{"$f":"'Day 7'!G9","v":0},null,0,0,0]
[1.2916666666666701,{"$f":"'Day 1'!G10","v":0},{"$f":"'Day 2'!G10","v":0},{"$f":"'Day 3'!G10","v":0},{"$f":"'Day 4'!G10","v":0},{"$f":"'Day 5'!G10","v":0},{"$f":"'Day 6'!G10","v":0},{"$f":"'Day 7'!G10","v":0},null,0,0,0]
["08:00:00",{"$f":"'Day 1'!G11","v":0},{"$f":"'Day 2'!G11","v":0},{"$f":"'Day 3'!G11","v":0},{"$f":"'Day 4'!G11","v":0},{"$f":"'Day 5'!G11","v":0},{"$f":"'Day 6'!G11","v":0},{"$f":"'Day 7'!G11","v":0},null,0,0,0]
["09:00:00",{"$f":"'Day 1'!G12","v":0},{"$f":"'Day 2'!G12","v":0},{"$f":"'Day 3'!G12","v":0},{"$f":"'Day 4'!G12","v":0},{"$f":"'Day 5'!G12","v":0},{"$f":"'Day 6'!G12","v":0},{"$f":"'Day 7'!G12","v":0},null,0,0,0]
["10:00:00",{"$f":"'Day 1'!G13","v":0},{"$f":"'Day 2'!G13","v":0},{"$f":"'Day 3'!G13","v":0},{"$f":"'Day 4'!G13","v":0},{"$f":"'Day 5'!G13","v":0},{"$f":"'Day 6'!G13","v":0},{"$f":"'Day 7'!G13","v":0},null,0,0,0]
["11:00:00",{"$f":"'Day 1'!G14","v":0},{"$f":"'Day 2'!G14","v":0},{"$f":"'Day 3'!G14","v":0},{"$f":"'Day 4'!G14","v":0},{"$f":"'Day 5'!G14","v":0},{"$f":"'Day 6'!G14","v":0},{"$f":"'Day 7'!G14","v":0},null,0,0,0]
["12:00:00",{"$f":"'Day 1'!G15","v":0},{"$f":"'Day 2'!G15","v":0},{"$f":"'Day 3'!G15","v":0},{"$f":"'Day 4'!G15","v":0},{"$f":"'Day 5'!G15","v":0},{"$f":"'Day 6'!G15","v":0},{"$f":"'Day 7'!G15","v":0},null,0,0,0]
["13:00:00",{"$f":"'Day 1'!G16","v":0},{"$f":"'Day 2'!G16","v":0},{"$f":"'Day 3'!G16","v":0},{"$f":"'Day 4'!G16","v":0},{"$f":"'Day 5'!G16","v":0},{"$f":"'Day 6'!G16","v":0},{"$f":"'Day 7'!G16","v":0},null,0,0,0]
["14:00:00",{"$f":"'Day 1'!G17","v":0},{"$f":"'Day 2'!G17","v":0},{"$f":"'Day 3'!G17","v":0},{"$f":"'Day 4'!G17","v":0},{"$f":"'Day 5'!G17","v":0},{"$f":"'Day 6'!G17","v":0},{"$f":"'Day 7'!G17","v":0},null,0,0,0]
["15:00:00",{"$f":"'Day 1'!G18","v":0},{"$f":"'Day 2'!G18","v":0},{"$f":"'Day 3'!G18","v":0},{"$f":"'Day 4'!G18","v":0},{"$f":"'Day 5'!G18","v":0},{"$f":"'Day 6'!G18","v":0},{"$f":"'Day 7'!G18","v":0},null,0,0,0]
["16:00:00",{"$f":"'Day 1'!G19","v":0},{"$f":"'Day 2'!G19","v":0},{"$f":"'Day 3'!G19","v":0},{"$f":"'Day 4'!G19","v":0},{"$f":"'Day 5'!G19","v":0},{"$f":"'Day 6'!G19","v":0},{"$f":"'Day 7'!G19","v":0},null,0,0,0]
["17:00:00",{"$f":"'Day 1'!G20","v":0},{"$f":"'Day 2'!G20","v":0},{"$f":"'Day 3'!G20","v":0},{"$f":"'Day 4'!G20","v":0},{"$f":"'Day 5'!G20","v":0},{"$f":"'Day 6'!G20","v":0},{"$f":"'Day 7'!G20","v":0},null,0,0,0]
["18:00:00",{"$f":"'Day 1'!G21","v":0},{"$f":"'Day 2'!G21","v":0},{"$f":"'Day 3'!G21","v":0},{"$f":"'Day 4'!G21","v":0},{"$f":"'Day 5'!G21","v":0},{"$f":"'Day 6'!G21","v":0},{"$f":"'Day 7'!G21","v":0},null,0,0,0]
["19:00:00",{"$f":"'Day 1'!G22","v":0},{"$f":"'Day 2'!G22","v":0},{"$f":"'Day 3'!G22","v":0},{"$f":"'Day 4'!G22","v":0},{"$f":"'Day 5'!G22","v":0},{"$f":"'Day 6'!G22","v":0},{"$f":"'Day 7'!G22","v":0},null,0,0,0]
["20:00:00",{"$f":"'Day 1'!G23","v":0},{"$f":"'Day 2'!G23","v":0},{"$f":"'Day 3'!G23","v":0},{"$f":"'Day 4'!G23","v":0},{"$f":"'Day 5'!G23","v":0},{"$f":"'Day 6'!G23","v":0},{"$f":"'Day 7'!G23","v":0},null,0,0,0]
["21:00:00",{"$f":"'Day 1'!G24","v":0},{"$f":"'Day 2'!G24","v":0},{"$f":"'Day 3'!G24","v":0},{"$f":"'Day 4'!G24","v":0},{"$f":"'Day 5'!G24","v":0},{"$f":"'Day 6'!G24","v":0},{"$f":"'Day 7'!G24","v":0},null,0,0,0]
["22:00:00",{"$f":"'Day 1'!G25","v":0},{"$f":"'Day 2'!G25","v":0},{"$f":"'Day 3'!G25","v":0},{"$f":"'Day 4'!G25","v":0},{"$f":"'Day 5'!G25","v":0},{"$f":"'Day 6'!G25","v":0},{"$f":"'Day 7'!G25","v":0},null,0,0,0]
["23:00:00",{"$f":"'Day 1'!G26","v":0},{"$f":"'Day 2'!G26","v":0},{"$f":"'Day 3'!G26","v":0},{"$f":"'Day 4'!G26","v":0},{"$f":"'Day 5'!G26","v":0},{"$f":"'Day 6'!G26","v":0},{"$f":"'Day 7'!G26","v":0},null,0,0,0]
[]
["Rostered staffing"]
["Time","Day 1","Day 2","Day 3","Day 4","Day 5","Day 6","Day 7",null,null,"Average","Average (rounded)"]
[1,{"$f":"'Day 1'!B3","v":0},{"$f":"'Day 2'!B3","v":0},{"$f":"'Day 3'!B3","v":0},{"$f":"'Day 4'!B3","v":0},{"$f":"'Day 5'!B3","v":10},{"$f":"'Day 6'!B3","v":0},{"$f":"'Day 7'!B3","v":0},null,null,{"$f":"AVERAGE(B138:H138)","v":1.4285714285714286},{"$f":"ROUNDUP(K138,0)","v":2}]
[1.0416666666666701,{"$f":"'Day 1'!B4","v":0},{"$f":"'Day 2'!B4","v":0},{"$f":"'Day 3'!B4","v":0},{"$f":"'Day 4'!B4","v":0},{"$f":"'Day 5'!B4","v":0},{"$f":"'Day 6'!B4","v":0},{"$f":"'Day 7'!B4","v":0},null,null,{"$f":"AVERAGE(B139:H139)","v":0},{"$f":"ROUNDUP(K139,0)","v":0}]
[1.0833333333333299,{"$f":"'Day 1'!B5","v":0},{"$f":"'Day 2'!B5","v":0},{"$f":"'Day 3'!B5","v":0},{"$f":"'Day 4'!B5","v":0},{"$f":"'Day 5'!B5","v":0},{"$f":"'Day 6'!B5","v":0},{"$f":"'Day 7'!B5","v":0},null,null,0,0]
[1.125,{"$f":"'Day 1'!B6","v":0},{"$f":"'Day 2'!B6","v":0},{"$f":"'Day 3'!B6","v":0},{"$f":"'Day 4'!B6","v":0},{"$f":"'Day 5'!B6","v":0},{"$f":"'Day 6'!B6","v":0},{"$f":"'Day 7'!B6","v":0},null,null,0,0]
[1.1666666666666701,{"$f":"'Day 1'!B7","v":0},{"$f":"'Day 2'!B7","v":0},{"$f":"'Day 3'!B7","v":0},{"$f":"'Day 4'!B7","v":0},{"$f":"'Day 5'!B7","v":0},{"$f":"'Day 6'!B7","v":0},{"$f":"'Day 7'!B7","v":0},null,null,0,0]
[1.2083333333333299,{"$f":"'Day 1'!B8","v":0},{"$f":"'Day 2'!B8","v":0},{"$f":"'Day 3'!B8","v":0},{"$f":"'Day 4'!B8","v":0},{"$f":"'Day 5'!B8","v":0},{"$f":"'Day 6'!B8","v":0},{"$f":"'Day 7'!B8","v":0},null,null,0,0]
[1.25,{"$f":"'Day 1'!B9","v":0},{"$f":"'Day 2'!B9","v":0},{"$f":"'Day 3'!B9","v":0},{"$f":"'Day 4'!B9","v":0},{"$f":"'Day 5'!B9","v":0},{"$f":"'Day 6'!B9","v":0},{"$f":"'Day 7'!B9","v":0},null,null,0,0]
[1.2916666666666701,{"$f":"'Day 1'!B10","v":0},{"$f":"'Day 2'!B10","v":0},{"$f":"'Day 3'!B10","v":0},{"$f":"'Day 4'!B10","v":0},{"$f":"'Day 5'!B10","v":0},{"$f":"'Day 6'!B10","v":0},{"$f":"'Day 7'!B10","v":0},null,null,0,0]
["08:00:00",{"$f":"'Day 1'!B11","v":0},{"$f":"'Day 2'!B11","v":0},{"$f":"'Day 3'!B11","v":0},{"$f":"'Day 4'!B11","v":0},{"$f":"'Day 5'!B11","v":0},{"$f":"'Day 6'!B11","v":0},{"$f":"'Day 7'!B11","v":0},null,null,0,0]
["09:00:00",{"$f":"'Day 1'!B12","v":0},{"$f":"'Day 2'!B12","v":0},{"$f":"'Day 3'!B12","v":0},{"$f":"'Day 4'!B12","v":0},{"$f":"'Day 5'!B12","v":0},{"$f":"'Day 6'!B12","v":0},{"$f":"'Day 7'!B12","v":0},null,null,0,0]
["10:00:00",{"$f":"'Day 1'!B13","v":0},{"$f":"'Day 2'!B13","v":0},{"$f":"'Day 3'!B13","v":0},{"$f":"'Day 4'!B13","v":0},{"$f":"'Day 5'!B13","v":0},{"$f":"'Day 6'!B13","v":0},{"$f":"'Day 7'!B13","v":0},null,null,0,0]
["11:00:00",{"$f":"'Day 1'!B14","v":0},{"$f":"'Day 2'!B14","v":0},{"$f":"'Day 3'!B14","v":0},{"$f":"'Day 4'!B14","v":0},{"$f":"'Day 5'!B14","v":0},{"$f":"'Day 6'!B14","v":0},{"$f":"'Day 7'!B14","v":0},null,null,0,0]
["12:00:00",{"$f":"'Day 1'!B15","v":0},{"$f":"'Day 2'!B15","v":0},{"$f":"'Day 3'!B15","v":0},{"$f":"'Day 4'!B15","v":0},{"$f":"'Day 5'!B15","v":0},{"$f":"'Day 6'!B15","v":0},{"$f":"'Day 7'!B15","v":0},null,null,0,0]
["13:00:00",{"$f":"'Day 1'!B16","v":0},{"$f":"'Day 2'!B16","v":0},{"$f":"'Day 3'!B16","v":0},{"$f":"'Day 4'!B16","v":0},{"$f":"'Day 5'!B16","v":0},{"$f":"'Day 6'!B16","v":0},{"$f":"'Day 7'!B16","v":0},null,null,0,0]
["14:00:00",{"$f":"'Day 1'!B17","v":0},{"$f":"'Day 2'!B17","v":0},{"$f":"'Day 3'!B17","v":0},{"$f":"'Day 4'!B17","v":0},{"$f":"'Day 5'!B17","v":0},{"$f":"'Day 6'!B17","v":0},{"$f":"'Day 7'!B17","v":0},null,null,0,0]
["15:00:00",{"$f":"'Day 1'!B18","v":0},{"$f":"'Day 2'!B18","v":0},{"$f":"'Day 3'!B18","v":0},{"$f":"'Day 4'!B18","v":0},{"$f":"'Day 5'!B18","v":0},{"$f":"'Day 6'!B18","v":0},{"$f":"'Day 7'!B18","v":0},null,null,0,0]
["16:00:00",{"$f":"'Day 1'!B19","v":0},{"$f":"'Day 2'!B19","v":0},{"$f":"'Day 3'!B19","v":0},{"$f":"'Day 4'!B19","v":0},{"$f":"'Day 5'!B19","v":0},{"$f":"'Day 6'!B19","v":0},{"$f":"'Day 7'!B19","v":0},null,null,0,0]
["17:00:00",{"$f":"'Day 1'!B20","v":0},{"$f":"'Day 2'!B20","v":0},{"$f":"'Day 3'!B20","v":0},{"$f":"'Day 4'!B20","v":0},{"$f":"'Day 5'!B20","v":0},{"$f":"'Day 6'!B20","v":0},{"$f":"'Day 7'!B20","v":0},null,null,0,0]
["18:00:00",{"$f":"'Day 1'!B21","v":0},{"$f":"'Day 2'!B21","v":0},{"$f":"'Day 3'!B21","v":0},{"$f":"'Day 4'!B21","v":0},{"$f":"'Day 5'!B21","v":0},{"$f":"'Day 6'!B21","v":0},{"$f":"'Day 7'!B21","v":0},null,null,0,0]
["19:00:00",{"$f":"'Day 1'!B22","v":0},{"$f":"'Day 2'!B22","v":0},{"$f":"'Day 3'!B22","v":0},{"$f":"'Day 4'!B22","v":0},{"$f":"'Day 5'!B22","v":0},{"$f":"'Day 6'!B22","v":0},{"$f":"'Day 7'!B22","v":0},null,null,0,0]
["20:00:00",{"$f":"'Day 1'!B23","v":0},{"$f":"'Day 2'!B23","v":0},{"$f":"'Day 3'!B23","v":0},{"$f":"'Day 4'!B23","v":0},{"$f":"'Day 5'!B23","v":0},{"$f":"'Day 6'!B23","v":0},{"$f":"'Day 7'!B23","v":0},null,null,0,0]
["21:00:00",{"$f":"'Day 1'!B24","v":0},{"$f":"'Day 2'!B24","v":0},{"$f":"'Day 3'!B24","v":0},{"$f":"'Day 4'!B24","v":0},{"$f":"'Day 5'!B24","v":0},{"$f":"'Day 6'!B24","v":0},{"$f":"'Day 7'!B24","v":0},null,null,0,0]
["22:00:00",{"$f":"'Day 1'!B25","v":0},{"$f":"'Day 2'!B25","v":0},{"$f":"'Day 3'!B25","v":0},{"$f":"'Day 4'!B25","v":0},{"$f":"'Day 5'!B25","v":0},{"$f":"'Day 6'!B25","v":0},{"$f":"'Day 7'!B25","v":0},null,null,0,0]
["23:00:00",{"$f":"'Day 1'!B26","v":0},{"$f":"'Day 2'!B26","v":0},{"$f":"'Day 3'!B26","v":0},{"$f":"'Day 4'!B26","v":0},{"$f":"'Day 5'!B26","v":0},{"$f":"'Day 6'!B26","v":0},{"$f":"'Day 7'!B26","v":0},null,null,0,0]

{"sheet":"Wkly Staffing Comparison Graph","index":19,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Calculated staffing per hour","index":20,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"JDT Adult - Section A","index":21,"n_rows":18,"n_cols":8,"rows_kept":18,"cut":false,"hidden":false,"merged":[[2,1,3,5],[13,1,13,4],[15,1,15,2]]}
[null,null,null,"JDT Section A"]
[]
[null,"Choose one box (3,2,1) from each component (one or more factors in the box is sufficient to receive the allocation). Place each rating in the highlighted rating column. The scores will then be added to give an overall JDT dependency score."]
[]
[]
[null,"Component",3,2,1,"Rating"]
[null,"Communication","Complete impairment due to either loss of one or more senses\n\nPain being at the higher range of the visual analogue scale\n\nUnresponsive\n\nLanguage barrier\n\nExtensive behavioural problems","Impairment or potential for impairment of one or more senses\n\nPain at the mid range of the visual analogue scale\n\nResponding only to verbal/pain stimulation\n\nDifficulty due to language barrier\n\nAnxious/tearful/distressed","Able to communicate through all senses\n\nPain at the lower range of the visual analogue scale\n\nAlert\n\nNo language barrier\n\nCo-operative/relaxed",2]
[null,"ABC","Cardiac/Respiratory Arrest (or risk of arrest)\n\nComplete impairment of ABC or Shock\n","Risk of impairment to\nairway breathing or circulation\n(potential for shock due to\ncondition)","No ABC problems\n\nMinor wounds",3]
[null,"Mobility","Total immobility","Partial mobility loss\n\nPatient requires trolley/wheelchair\n","Fully mobile\n\nMinor limb problem",3]
[null,"Eating, drinking, elimination and personal care","Total loss of bowel/bladder function and/or\nhyperemesis\n\nTotal loss of independent self care\n","Partial loss of bowel/bladder function and/or\nvomiting\n\nPartial loss of independent self care\n","Normal bowel/bladder control. No vomiting\n\nAble to maintain independent self care\n",3]
[null,"Environmental safety, health and social needs","Demonstrates danger to self or others\n\nAppears to require extensive social support\n","Appears unable to fully understand risks \n\nAppears to require some social support\n","Shows total ability to fully understand risks\n\nDoes not appear to require social support\n",3]
[null,"Triage","Red or Orange","Yellow","Green or Blue",3]
[]
[null,"Total JDT rating =",null,null,null,{"$f":"SUM(F7:F12)","v":17}]
[null,"6 – 7 = Low dependency\n8 – 12 = Moderate dependency\n13 – 15 = High dependency\n16 - 18 = Total dependency","Overall score = 0\nOverall score = 1\nOverall score = 2\nOverall score = 3",null,"Dependency score = ",{"$f":"IF(AND(F14>=6,F14<=7),\"0\",IF(AND(F14>=8,F14<=12),\"1\",IF(AND(F14>=13,F14<=15),\"2\",IF(AND(F14>=16,F14<=18),\"3\",\"ERROR - PLEASE REVIEW SCORING\"))))","v":"3"}]
[null,"Based on your rating, this patient is classed as having",null,{"$f":"(IF(F15=\"0\",\" Low dependency\",IF(F15=\"1\",\" Moderate dependency\",IF(F15=\"2\", \" High dependency\",IF(F15=\"3\",\" Total dependency\")))))","v":" Total dependency"},null,null,null,"Return to week overview"]
[]
[null,null,null,null,null,null,null,"Return to 'How to Use' guide"]

{"sheet":"JDT Child - Section A","index":22,"n_rows":18,"n_cols":8,"rows_kept":18,"cut":false,"hidden":false,"merged":[[2,1,3,5],[13,1,13,4],[15,1,15,2]]}
[null,null,null,"JDT Section A Paediatric Version"]
[]
[null,"Choose one box (3,2,1) from each component (one or more factors in the box is sufficient to receive the allocation). Place each rating in the highlighted rating column. The scores will then be added to give an overall JDT dependency score."]
[]
[]
[null,"Component",3,2,1,"Rating"]
[null,"Communication","Complete impairment due to loss of one or more senses in child over 2years and/or carer.\n\n\nPain being at the higher range of the visual analogue scale\n\n\nUnresponsive\n\n\nLanguage barrier in child over 2 years or carer.\n\n\nExtensive behavioural problems unable to be distracted.\n\n","Impairment or potential for impairment of one or more senses in child over 2years or carer\n\n\nPain at the mid range of the visual analogue scale\n\n\nResponding only to verbal/pain stimulation\n\n\nDifficulty due to language barrier in child over 2 years or carer.\n\n\nAnxious/tearful/distressed but able to be distracted with significant effort.\n\n","Able to communicate through all senses in a way normal for developmental stage.\n\n\nPain at the lower range of the visual analogue scale\n\n\nAlert or having normal daytime nap, but rousable.\n\n\nNo language barrier of child over 2 years or carer.\n\n\nCo-operative/relaxed, needs no or minimal distraction.\n\n",1]
[null,"ABC","Cardiac/Respiratory Arrest (or risk of arrest)\n\n\nComplete impairment of ABC or Shock (e.g. >or = 6 on PAWS Score or equivalent PEWS)\n\n","Risk of impairment to\nairway breathing or circulation\n(potential for shock due to\ncondition)\n(e.g. >/= 2 but < 6 on PAWS or equivalent PEWS or significant Burns/Scalds)","No ABC problems (e.g. PAWS/PEWS <2)\n\n\nMinor wounds",1]
[null,"Mobility","Total immobility of child normally mobile.\n","Partial mobility loss of child > 4 years or too big to be carried by carer.\n\n\nPatient requires trolley/wheelchair to be pushed by staff member. (Often with child sat on carer’s lap)\n\n","Fully mobile child appropriate to developmental stage\n\n\nMinor limb problem",1]
[null,"Eating, drinking, elimination and personal care","Total loss of bowel/bladder function in child usually continent and/or\nhyperemesis\n\n\nTotal loss of normal level of self care\n\n","Partial loss of bowel/bladder function in child usually continent and/or\nvomiting\n\n\nPartial loss of normal level of self care","Normal bowel/bladder control. No vomiting\n\n\nAble to maintain normal level of self care",1]
[null,"Environmental safety, health and social needs","Demonstrates danger to self or others. Or is at danger form significant other. Requiring constant staff supervision.\n\n\nAppears to require extensive social support and/or has immediate safeguarding needs.(e.g Child unable to be safely discharged)\n\n","Appears unable to fully understand risks but has carer who is responsible and able to protect from harm with support from staff.\n\nAppears to require some social support and/or has safeguarding needs that can wait until next working day,(e.g. Child can be safely discharged, but requires some communication and documentation with health visitor/ school nurse or social services)","Shows total ability to fully understand risks or has a carer who is protecting from harm.\n\n\nDoes not appear to require social support, has no safeguarding needs.",3]
[null,"Triage","Red or Orange","Yellow","Green or Blue",1]
[]
[null,"Total JDT rating =",null,null,null,{"$f":"SUM(F7:F12)","v":8}]
[null,"6 – 7 = Low dependency\n8 – 12 = Moderate dependency\n13 – 15 = High dependency\n16 - 18 = Total dependency","Overall score = 0\nOverall score = 1\nOverall score = 2\nOverall score = 3",null,"Dependency score = ",{"$f":"IF(AND(F14>=6,F14<=7),\"0\",IF(AND(F14>=8,F14<=12),\"1\",IF(AND(F14>=13,F14<=15),\"2\",IF(AND(F14>=16,F14<=18),\"3\",\"ERROR - PLEASE REVIEW SCORING\"))))","v":"1"}]
[null,"Based on your rating, this patient is classed as having",null,{"$f":"(IF(F15=\"0\",\" Low dependency\",IF(F15=\"1\",\" Moderate dependency\",IF(F15=\"2\", \" High dependency\",IF(F15=\"3\",\" Total dependency\")))))","v":" Moderate dependency"},null,null,null,"Return to week overview"]
[]
[null,null,null,null,null,null,null,"Return to 'How to Use' guide"]

{"sheet":"JDT - Section B","index":23,"n_rows":17,"n_cols":5,"rows_kept":17,"cut":false,"hidden":false,"merged":[[3,0,4,4]]}
[]
[null,null,"JDT Section B"]
[]
["Once the dependency score has been obtained in section A, section B should reflect the nursing workload."]
[]
[]
["Component","Total Dependency 3","High Dependency 2","Moderate Dependency 1","Low Dependency 0"]
["Communication","Nurse present at all times (one - one) (D/I) \n\nConstant attention due to behavioural problems/need for psychological support (D)\n\nConstant support/frequent contact with relatives (I) \n\nMay require analgesia IM/IV\n\n","Constant observation (but not requiring one - one) (D/I)\n\nFrequent attention due to behavioural problems/need for psychological support (D)\n\nFrequent support/contact of relatives/friends due to severity/death of patient (I)\n\nMay require analgesia IM/IV","Nurse available in calling distance (D/I)\n\nReassurance/psychological support (D)\n\nMay require relatives to be informed/explanation (I)\n\nMay require analgesia IM/IV\n","Nurse available in the department (D/I)\n\nReassurance (D)"]
["ABC","Frequent (15 minutes) vital signs (D) \n\nConstant airway/breathing attention (D) \n\nResuscitation (D) \n\nRapid IV fluids (D) \n\nExtensive or time consuming interventions/tests (D/I)","Vital signs 1/2 - 1 hourly (D)\n\nObservation/intervention with airway/breathing (oxygen administration) (D)\n\nFrequent IV fluids (D)\n\nRequire various blood tests (D/I)","Vital signs 2-4 hourly (D)\n\nIV fluids (D)","Vital signs once only (D)"]
["Mobility","Frequent pressure area care (D)\n\nConstant elimination support (D) \n\nExtensive or time consuming interventions/tests (D/I)","Pressure area care 1-2 hours (D) \n\nRequire x-rays/scans (D/I)","Pressure area care 4/6 hourly (D)","Nil specific"]
["Eating, drinking, elimination and personal care","Requires constant attention to care","Assistance with bedpans/urinals (D)","Assistance with toiletry/commode/walking to toilet (D)","Nil Specific"]
["Environmental safety, health and social needs","Constant attention due to behavioural problems (D) \n\nIf discharged will require complex discharge arrangements involving more than one service provider (I) \n\nAdmission planning (I) \n\nWill require escorting to wards/departments (D) \n\nExtensive time consuming health promotion/self care advice required (D)","Frequent attention due to behavioural problems (D) \n\nIf discharged will require complex discharge arrangements involving more than one service provider (I)\n\nMay require admission planning (I) \n\nWill require escorting to wards/departments (D) \n\nMore extensive health promotion/self care advice required (D)","May require some discharge planning linked with one service provider (I) \n\nMay require admission planning (I) \n\nMay require escorting to wards/departments (D) \n\nRequires some health promotion/self care guidance (D)","Discharge planning is uncomplicated (I) \n\nSome health promotion/self care may be required (D)"]
[]
[]
[null,null,null,null,"Return to week overview"]
[]
[null,null,null,null,"Return to 'How to Use' guide"]

{"sheet":"Appendix D - Hourly Tool","index":24,"n_rows":17,"n_cols":3,"rows_kept":17,"cut":false,"hidden":false,"merged":[[3,1,4,2],[1,1,1,2]]}
[]
[null,"B.E.S.T Data Collection Tool"]
[]
[null,"Once the dependency score has been obtained in section A, section B should reflect the nursing workload."]
[]
[]
[null,"Hour","e.g. 00:00"]
[null,"Number of Total Dependency patients present"]
[null,"Number of High Dependency patients present"]
[null,"Number of Moderate Dependency patients present"]
[null,"Number of Low Dependency patients booked in within the hour. (Score only once, even if present for several hours)"]
[null,"Number of patients with a decision to admit who are awaiting a bed (Not ITU/HDU/CCU)"]
[]
[]
[null,null,"Return to week overview"]
[]
[null,null,"Return to 'How to Use' guide"]

{"sheet":"JDT Cummulative Hourly totals","index":25,"n_rows":15,"n_cols":25,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,0,1,24],[12,22,12,24],[14,22,14,24]]}
[]
["JDT Cummulative Hourly Totals"]
[]
[]
[null,"00:00 - 01:00","01:00 - 02:00","02:00 - 03:00","03:00 - 04:00","04:00 - 05:00","05:00 -06:00","06:00 - 07:00","07:00 - 08:00","08:00 - 09:00","09:00 - 10:00","10:00 - 11:00","11:00 - 12:00","12:00 - 13:00","13:00 - 14:00","14:00 -15:00","15:00 - 16:00","16:00 - 17:00","17:00 - 18:00","18:00 - 19:00","19:00 - 20:00","20:00 - 21:00","21:00 - 22:00","22:00 - 23:00","23:00 - 00:00"]
["Number of Total Dependency patients"]
["Number of High Dependency patients"]
["Number of Moderate Dependency patients"]
["Number of Low Dependency patients"]
["Number of patients awaiting a bed"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Return to week overview"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Return to 'How to Use' guide"]