{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Weekly","Data","Budget","Shifts"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":10,"comments":0,"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":"Weekly","index":0,"n_rows":39,"n_cols":11,"rows_kept":39,"cut":false,"hidden":false,"merged":[[30,0,30,1],[30,6,30,10],[38,0,38,5],[38,6,38,10],[37,0,37,10],[31,0,31,1],[31,6,31,10],[35,0,35,1],[35,3,35,4],[35,6,35,7],[36,0,36,2],[28,0,28,1],[28,6,28,10],[29,0,29,1],[29,6,29,10],[27,0,27,1],[27,6,27,10],[26,0,26,1],[26,6,26,10],[24,0,24,1],[24,6,24,10],[25,0,25,1],[25,6,25,10],[22,0,22,1],[22,6,22,10],[23,0,23,1],[23,6,23,10],[21,0,21,1],[21,6,21,10],[20,0,20,1],[20,6,20,10],[18,0,18,1],[18,6,18,10],[19,0,19,1],[19,6,19,10],[11,9,11,10],[12,9,12,10],[5,0,5,2],[7,0,7,2],[9,0,9,2],[14,0,14,10],[16,0,16,1],[16,6,16,10],[17,0,17,1],[17,6,17,10],[3,0,3,2],[0,0,0,10],[1,0,1,10],[3,7,3,10],[5,8,5,9]]}
[{"$f":"VLOOKUP(Data!I10,Data!A2:B11,2,FALSE)","v":"NA"}]
["Week Commencing: "]
[]
["Requested Skills Mix (Hours):",null,null,"Chef","FSA",null,"Total","Expected Occupancy"]
[]
["TOTAL:",null,null,null,null,null,{"$f":"SUM(D6:F6)","v":0}]
[]
["Budget:",null,null,{"$f":"IF(Budget!$B$1=\"NA\",0,VLOOKUP(Budget!$B$1,Budget!$A$7:$E$125,4,FALSE))","v":0},{"$f":"IF(Budget!$B$1=\"NA\",0,VLOOKUP(Budget!$B$1,Budget!$A$7:$E$125,5,FALSE))","v":0},null,{"$f":"SUM(D8:F8)","v":0}]
[]
["Under\\(Over) Budget",null,null,{"$f":"+D8-D6","v":0},{"$f":"+E8-E6","v":0},null,{"$f":"+G8-G6","v":0}]
[]
["Rota Reviewed",null,null,null,"Yes\\No",null,"EFHL Text sent",null,null,"Yes\\No"]
[null,null,null,null,null,null,"All vacancies notified to HR",null,null,"Yes\\No"]
[]
["Agency shifts requested:"]
[]
[null,null,"Chef","FSA",null,"Total Hrs","Comments"]
[]
["Monday",null,null,null,null,{"$f":"SUM(C19:E19)","v":0}]
[]
["Tuesday",null,null,null,null,{"$f":"SUM(C21:E21)","v":0}]
[]
["Wednesday",null,null,null,null,{"$f":"SUM(C23:E23)","v":0}]
[]
["Thursday",null,null,null,null,{"$f":"SUM(C25:E25)","v":0}]
[]
["Friday",null,null,null,null,{"$f":"SUM(C27:E27)","v":0}]
[]
["Saturday",null,null,null,null,{"$f":"SUM(C29:E29)","v":0}]
[]
["Sunday",null,null,null,null,{"$f":"SUM(C31:E31)","v":0}]
[]
["Total",null,{"$f":"SUM(C19:C31)","v":0},0,null,{"$f":"SUM(F19:F31)","v":0}]
[]
["Comment on strategy for action taken by home to cover vacant shifts"]
["Vacant Hours:",null,null,"Annual Leave:",null,null,"Absence Hours:",null,null,"Total:",{"$f":"+I36+F36+C36","v":0}]
["Overtime Hours picked up:"]
[]
["Ver 1.3_2526"]

{"sheet":"Data","index":1,"n_rows":11,"n_cols":9,"rows_kept":11,"cut":false,"hidden":true,"merged":[]}
["Lookup","Home","OSM","Manager","Admin","HR","Finance"]
[1,"Cotswold","helen.grice@elizabethfinn.co.uk; james.hamilton@elizabethfinn.co.uk","rares.pop@elizabethfinn.co.uk","samantha.weller@elizabethfinn.co.uk","peter.norgate@elizabethfinn.co.uk","jonathan.crisp@elizabethfinn.co.uk","OSM",{"$f":"VLOOKUP($I$10,$A$2:$G$34,3,FALSE)","v":0}]
[{"$f":"+A2+1","v":2},"Eversfield","helen.grice@elizabethfinn.co.uk; james.hamilton@elizabethfinn.co.uk","josephine.gbadamosi@elizabethfinn.co.uk","kate.mcdonald@elizabethfinn.co.uk","peter.norgate@elizabethfinn.co.uk","jonathan.crisp@elizabethfinn.co.uk","Manager",{"$f":"VLOOKUP($I$10,$A$2:$G$34,4,FALSE)","v":0}]
[{"$f":"+A3+1","v":3},"Grove Court","helen.grice@elizabethfinn.co.uk; james.hamilton@elizabethfinn.co.uk","kelly.lockwood@elizabethfinn.co.uk","sarah.pettitt@elizabethfinn.co.uk","peter.norgate@elizabethfinn.co.uk","jonathan.crisp@elizabethfinn.co.uk","Admin",{"$f":"VLOOKUP($I$10,$A$2:$G$34,5,FALSE)","v":0}]
[4,"Halliwell","helen.grice@elizabethfinn.co.uk; james.hamilton@elizabethfinn.co.uk","karl.pay@elizabethfinn.co.uk","shonagh.walker@elizabethfinn.co.uk","peter.norgate@elizabethfinn.co.uk","jonathan.crisp@elizabethfinn.co.uk","HR",{"$f":"VLOOKUP($I$10,$A$2:$G$34,6,FALSE)","v":0}]
[5,"Merlewood","helen.grice@elizabethfinn.co.uk; james.hamilton@elizabethfinn.co.uk","debbie.vellender@elizabethfinn.co.uk","claire.davis@elizabethfinn.co.uk","peter.norgate@elizabethfinn.co.uk","jonathan.crisp@elizabethfinn.co.uk","Finance",{"$f":"VLOOKUP($I$10,$A$2:$G$34,7,FALSE)","v":0}]
[6,"Rashwood","helen.grice@elizabethfinn.co.uk; james.hamilton@elizabethfinn.co.uk","rachel.wilson@elizabethfinn.co.uk","lucy.reizlein@elizabethfinn.co.uk","peter.norgate@elizabethfinn.co.uk","jonathan.crisp@elizabethfinn.co.uk"]
[7,"Rush Court","helen.grice@elizabethfinn.co.uk; james.hamilton@elizabethfinn.co.uk","nike.ajewole@elizabethfinn.co.uk","mary.middleton@elizabethfinn.co.uk","peter.norgate@elizabethfinn.co.uk","jonathan.crisp@elizabethfinn.co.uk","Notify",{"$f":"+Data!I2","v":0}]
[8,"The Lodge","helen.grice@elizabethfinn.co.uk; james.hamilton@elizabethfinn.co.uk","deborah.skinner@elizabethfinn.co.uk","nicola.cheriton@elizabethfinn.co.uk","peter.norgate@elizabethfinn.co.uk","jonathan.crisp@elizabethfinn.co.uk","CC",{"$f":"Data!I3&\";\"&Data!I4&\";\"&Data!I5&\";\"&Data!I6","v":"0;0;0;0"}]
[9,null,null,null,null,null,null,"Link",10]
[10,"NA"]

{"sheet":"Budget","index":2,"n_rows":125,"n_cols":5,"rows_kept":125,"cut":false,"hidden":true,"merged":[]}
[null,{"$f":"IF(HomeName=\"NA\",\"NA\",HomeName&Weekly!I6)","v":"NA"}]
[]
[]
[]
[null,null,null,"Hours"]
["Lookup","Home","Occupancy","Chef","FSA"]
[{"$f":"B7&C7","v":"Cotswold41"},"Cotswold",41,114,154.25]
[{"$f":"B8&C8","v":"Cotswold42"},"Cotswold",42,114,154.25]
["Cotswold43","Cotswold",43,114,154.25]
["Cotswold44","Cotswold",44,114,159.25]
["Cotswold45","Cotswold",45,114,159.25]
["Cotswold46","Cotswold",46,114,159.25]
["Cotswold47","Cotswold",47,114,159.25]
["Cotswold48","Cotswold",48,114,159.25]
["Cotswold49","Cotswold",49,114,159.25]
["Cotswold50","Cotswold",50,114,159.25]
[{"$f":"B17&C17","v":"Cotswold51"},"Cotswold",51,114,159.25]
["Eversfield35","Eversfield",35,71.3,{"$f":"+E19","v":147.25}]
["Eversfield36","Eversfield",36,71.3,147.25]
["Eversfield37","Eversfield",37,71.3,153.25]
["Eversfield38","Eversfield",38,71.3,153.25]
["Eversfield39","Eversfield",39,71.3,153.25]
["Eversfield40","Eversfield",40,71.3,153.25]
["Eversfield41","Eversfield",41,71.3,153.25]
["Eversfield42","Eversfield",42,71.3,153.25]
["Eversfield43","Eversfield",43,71.3,153.25]
["Eversfield44","Eversfield",44,71.3,153.25]
["Eversfield45","Eversfield",45,71.3,159.25]
["Eversfield46","Eversfield",46,71.3,159.25]
["Eversfield47","Eversfield",47,71.3,159.25]
["Eversfield48","Eversfield",48,71.3,159.25]
["Eversfield49","Eversfield",49,71.3,159.25]
["Eversfield50","Eversfield",50,71.3,159.25]
["Eversfield51","Eversfield",51,71.3,159.25]
["Eversfield52","Eversfield",52,71.3,159.25]
["Grove Court51","Grove Court",51,105,265]
["Grove Court52","Grove Court",52,105,265]
["Grove Court53","Grove Court",53,105,265]
["Grove Court54","Grove Court",54,105,273]
["Grove Court55","Grove Court",55,105,273]
["Grove Court56","Grove Court",56,105,273]
["Grove Court57","Grove Court",57,105,273]
["Grove Court58","Grove Court",58,105,273]
["Grove Court59","Grove Court",59,105,273]
["Grove Court60","Grove Court",60,105,273]
["Grove Court61","Grove Court",61,105,273]
["Halliwell54","Halliwell",54,112.5,215.5]
["Halliwell55","Halliwell",55,112.5,215.5]
["Halliwell56","Halliwell",56,112.5,215.5]
["Halliwell57","Halliwell",57,112.5,224]
["Halliwell58","Halliwell",58,112.5,224]
["Halliwell59","Halliwell",59,112.5,224]
["Halliwell60","Halliwell",60,112.5,224]
["Halliwell61","Halliwell",61,112.5,224]
["Halliwell62","Halliwell",62,112.5,224]
["Halliwell63","Halliwell",63,112.5,224]
["Halliwell64","Halliwell",64,112.5,224]
["Merlewood33","Merlewood",33,97.5,{"$f":"188.5-7.5","v":181}]
["Merlewood34","Merlewood",34,97.5,181]
["Merlewood35","Merlewood",35,97.5,181]
["Merlewood36","Merlewood",36,97.5,181]
["Merlewood37","Merlewood",37,97.5,181]
["Merlewood38","Merlewood",38,97.5,{"$f":"188.5-7.5","v":181}]
["Merlewood39","Merlewood",39,97.5,188.5]
["Merlewood40","Merlewood",40,97.5,188.5]
["Merlewood41","Merlewood",41,97.5,188.5]
["Merlewood42","Merlewood",42,97.5,188.5]
["Merlewood43","Merlewood",43,97.5,188.5]
["Merlewood44","Merlewood",44,97.5,188.5]
["Merlewood45","Merlewood",45,97.5,188.5]
["Merlewood46","Merlewood",46,97.5,188.5]
["Merlewood47","Merlewood",47,97.5,196]
["Merlewood48","Merlewood",48,97.5,196]
["Merlewood49","Merlewood",49,97.5,196]
["Merlewood50","Merlewood",50,97.5,196]
["Merlewood51","Merlewood",51,97.5,196]
["Merlewood52","Merlewood",52,97.5,196]
["Merlewood53","Merlewood",53,97.5,196]
["Merlewood54","Merlewood",54,97.5,196]
["Rashwood37","Rashwood",37,107.5,{"$f":"196.3-5","v":191.3}]
["Rashwood38","Rashwood",38,107.5,{"$f":"201.3-5","v":196.3}]
["Rashwood39","Rashwood",39,107.5,196.3]
["Rashwood40","Rashwood",40,107.5,196.3]
["Rashwood41","Rashwood",41,107.5,196.3]
["Rashwood42","Rashwood",42,107.5,196.3]
["Rashwood43","Rashwood",43,107.5,196.3]
["Rashwood44","Rashwood",44,107.5,196.3]
["Rashwood45","Rashwood",45,107.5,{"$f":"201.3-5","v":196.3}]
["Rashwood46","Rashwood",46,107.5,201.3]
["Rashwood47","Rashwood",47,107.5,201.3]
["Rashwood48","Rashwood",48,107.5,201.3]
[{"$f":"B92&C92","v":"Rashwood49"},"Rashwood",49,107.5,201.3]
["Rashwood50","Rashwood",50,107.5,201.3]
["Rashwood51","Rashwood",51,107.5,201.3]
["Rashwood52","Rashwood",52,107.5,201.3]
["Rashwood53","Rashwood",53,107.5,201.3]
["Rush Court32","Rush Court",32,100,{"$f":"160.5-7.5","v":153}]
["Rush Court33","Rush Court",33,100,160.5]
["Rush Court34","Rush Court",34,100,160.5]
["Rush Court35","Rush Court",35,100,160.5]
["Rush Court36","Rush Court",36,100,160.5]
["Rush Court37","Rush Court",37,100,160.5]
["Rush Court38","Rush Court",38,100,160.5]
["Rush Court39","Rush Court",39,100,160.5]
["Rush Court40","Rush Court",40,100,160.5]
["Rush Court41","Rush Court",41,100,168]
["Rush Court42","Rush Court",42,100,168]
["Rush Court43","Rush Court",43,100,168]
["Rush Court44","Rush Court",44,100,168]
["Rush Court45","Rush Court",45,100,168]
["Rush Court46","Rush Court",46,100,168]
["Rush Court47","Rush Court",47,100,168]
[{"$f":"B113&C113","v":"Rush Court48"},"Rush Court",48,100,168]
["The Lodge50","The Lodge",50,112.5,199.1]
["The Lodge51","The Lodge",51,112.5,199.1]
["The Lodge52","The Lodge",52,112.5,199.1]
["The Lodge53","The Lodge",53,112.5,205.1]
["The Lodge54","The Lodge",54,112.5,205.1]
["The Lodge55","The Lodge",55,112.5,205.1]
["The Lodge56","The Lodge",56,112.5,205.1]
["The Lodge57","The Lodge",57,112.5,205.1]
["The Lodge58","The Lodge",58,112.5,205.1]
["The Lodge59","The Lodge",59,112.5,205.1]
["The Lodge60","The Lodge",60,112.5,205.1]
["The Lodge61","The Lodge",61,112.5,205.1]

{"sheet":"Shifts","index":3,"n_rows":32,"n_cols":5,"rows_kept":32,"cut":false,"hidden":true,"merged":[]}
[null,{"$f":"HomeName&\"AM\"","v":"NAAM"}]
[null,{"$f":"HomeName&\"PM\"","v":"NAPM"}]
[null,{"$f":"HomeName&\"ND\"","v":"NAND"}]
[]
["Lookup","Home","Shift","RN","Carer"]
[{"$f":"+B6&C6","v":"CotswoldAM"},"Cotswold","AM",7,7]
["CotswoldPM","Cotswold","PM",7,7]
["CotswoldND","Cotswold","ND",11,11]
["EversfieldAM","Eversfield","AM",7,7]
["EversfieldPM","Eversfield","PM",7,7]
["EversfieldND","Eversfield","ND",11,11]
["Grove CourtAM","Grove Court","AM",7,7]
["Grove CourtPM","Grove Court","PM",7,7]
["Grove CourtND","Grove Court","ND",11,11]
["HalliwellAM","Halliwell","AM",7,7]
["HalliwellPM","Halliwell","PM",7,7]
["HalliwellND","Halliwell","ND",11,11]
["Hampden HouseAM","Hampden House","AM",7,7]
["Hampden HousePM","Hampden House","PM",7,7]
["Hampden HouseND","Hampden House","ND",11,11]
["MerlewoodAM","Merlewood","AM",7,7]
["MerlewoodPM","Merlewood","PM",7,7]
["MerlewoodND","Merlewood","ND",11,11]
["RashwoodAM","Rashwood","AM",7,7]
["RashwoodPM","Rashwood","PM",7,7]
["RashwoodND","Rashwood","ND",11,11]
["Rush CourtAM","Rush Court","AM",7,7]
["Rush CourtPM","Rush Court","PM",7,7]
["Rush CourtND","Rush Court","ND",11,11]
["The LodgeAM","The Lodge","AM",7,7]
["The LodgePM","The Lodge","PM",7,7]
["The LodgeND","The Lodge","ND",11,11]