{"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":[[3,0,3,2],[0,0,0,10],[1,0,1,10],[3,7,3,10],[5,8,5,9],[14,0,14,10],[16,0,16,1],[16,6,16,10],[17,0,17,1],[17,6,17,10],[11,9,11,10],[12,9,12,10],[5,0,5,2],[7,0,7,2],[9,0,9,2],[20,0,20,1],[20,6,20,10],[18,0,18,1],[18,6,18,10],[19,0,19,1],[19,6,19,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],[26,0,26,1],[26,6,26,10],[24,0,24,1],[24,6,24,10],[25,0,25,1],[25,6,25,10],[28,0,28,1],[28,6,28,10],[29,0,29,1],[29,6,29,10],[27,0,27,1],[27,6,27,10],[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],[34,0,34,1],[34,3,34,4],[34,6,34,7],[35,0,35,2]]}
[{"$f":"VLOOKUP(Data!I10,Data!A2:B11,2,FALSE)","v":"NA"}]
["Week Commencing: "]
[]
["Requested Skills Mix (Hours):",null,null,"Laundry","Domestic",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$127,4,FALSE))","v":0},{"$f":"IF(Budget!$B$1=\"NA\",0,VLOOKUP(Budget!$B$1,Budget!$A$7:$E$127,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,"Laundry","Domestic",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}]
[]
["Vacant Hours:",null,null,null,null,null,"Absence Hours:",null,null,"Total:",{"$f":"+I35+F35+C35","v":0}]
["Overtime Hours picked up:"]
["Comment on strategy for action taken by home to cover vacant shifts"]
[]
["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":127,"n_cols":5,"rows_kept":127,"cut":false,"hidden":true,"merged":[]}
[null,{"$f":"IF(HomeName=\"NA\",\"NA\",HomeName&Weekly!I6)","v":"NA"}]
[]
[]
[]
[null,null,null,"Hours"]
["Lookup","Home","Occupancy","Laundry","Domestic"]
[{"$f":"B7&C7","v":"Cotswold41"},"Cotswold",41,null,246]
[{"$f":"B8&C8","v":"Cotswold42"},"Cotswold",42,null,246]
["Cotswold43","Cotswold",43,null,246]
["Cotswold44","Cotswold",44,null,252]
["Cotswold45","Cotswold",45,null,252]
["Cotswold46","Cotswold",46,null,252]
["Cotswold47","Cotswold",47,null,252]
["Cotswold48","Cotswold",48,null,252]
["Cotswold49","Cotswold",49,null,252]
["Cotswold50","Cotswold",50,null,252]
[{"$f":"B17&C17","v":"Cotswold51"},"Cotswold",51,null,252]
["Eversfield36","Eversfield",36,null,{"$f":"214.5-6","v":208.5}]
["Eversfield37","Eversfield",37,null,214.5]
["Eversfield38","Eversfield",38,null,214.5]
["Eversfield39","Eversfield",39,null,214.5]
["Eversfield40","Eversfield",40,null,214.5]
["Eversfield41","Eversfield",41,null,214.5]
["Eversfield42","Eversfield",42,null,214.5]
["Eversfield43","Eversfield",43,null,214.5]
["Eversfield44","Eversfield",44,null,214.5]
["Eversfield45","Eversfield",45,null,220.5]
["Eversfield46","Eversfield",46,null,220.5]
["Eversfield47","Eversfield",47,null,220.5]
["Eversfield48","Eversfield",48,null,220.5]
["Eversfield49","Eversfield",49,null,220.5]
["Eversfield50","Eversfield",50,null,220.5]
["Eversfield51","Eversfield",51,null,220.5]
["Eversfield52","Eversfield",52,null,220.5]
["Eversfield36","Eversfield",36,null,230]
["Grove Court51","Grove Court",51,null,230]
["Grove Court52","Grove Court",52,null,230]
["Grove Court53","Grove Court",53,null,230]
["Grove Court54","Grove Court",54,null,238]
["Grove Court55","Grove Court",55,null,238]
["Grove Court56","Grove Court",56,null,238]
["Grove Court57","Grove Court",57,null,238]
["Grove Court58","Grove Court",58,null,238]
["Grove Court59","Grove Court",59,null,238]
["Grove Court60","Grove Court",60,null,238]
["Grove Court61","Grove Court",61,null,238]
["Halliwell54","Halliwell",54,null,274]
["Halliwell55","Halliwell",55,null,274]
["Halliwell56","Halliwell",56,null,274]
["Halliwell57","Halliwell",57,null,280]
["Halliwell58","Halliwell",58,null,280]
["Halliwell59","Halliwell",59,null,280]
["Halliwell60","Halliwell",60,null,280]
["Halliwell61","Halliwell",61,null,280]
["Halliwell62","Halliwell",62,null,280]
["Halliwell63","Halliwell",63,null,280]
["Halliwell64","Halliwell",64,null,280]
["Merlewood31","Merlewood",31,null,{"$f":"181.5-7.5","v":174}]
["Merlewood32","Merlewood",32,null,174]
["Merlewood33","Merlewood",33,null,174]
["Merlewood34","Merlewood",34,null,174]
["Merlewood35","Merlewood",35,null,174]
["Merlewood36","Merlewood",36,null,174]
["Merlewood37","Merlewood",37,null,174]
["Merlewood38","Merlewood",38,null,{"$f":"181.5-7.5","v":174}]
["Merlewood39","Merlewood",39,null,{"$f":"189-7.5","v":181.5}]
["Merlewood40","Merlewood",40,null,181.5]
["Merlewood41","Merlewood",41,null,181.5]
["Merlewood42","Merlewood",42,null,181.5]
["Merlewood43","Merlewood",43,null,181.5]
["Merlewood44","Merlewood",44,null,181.5]
["Merlewood45","Merlewood",45,null,181.5]
["Merlewood46","Merlewood",46,null,{"$f":"189-7.5","v":181.5}]
["Merlewood47","Merlewood",47,null,189]
["Merlewood48","Merlewood",48,null,189]
["Merlewood49","Merlewood",49,null,189]
["Merlewood50","Merlewood",50,null,189]
["Merlewood51","Merlewood",51,null,189]
["Merlewood52","Merlewood",52,null,189]
[{"$f":"B80&C80","v":"Merlewood53"},"Merlewood",53,null,189]
["Merlewood54","Merlewood",54,null,189]
["Rashwood37","Rashwood",37,null,{"$f":"185-7.5","v":177.5}]
["Rashwood38","Rashwood",38,null,{"$f":"192.5-7.5","v":185}]
["Rashwood39","Rashwood",39,null,185]
["Rashwood40","Rashwood",40,null,185]
["Rashwood41","Rashwood",41,null,185]
["Rashwood42","Rashwood",42,null,185]
["Rashwood43","Rashwood",43,null,185]
["Rashwood44","Rashwood",44,null,185]
["Rashwood45","Rashwood",45,null,{"$f":"192.5-7.5","v":185}]
["Rashwood46","Rashwood",46,null,192.5]
["Rashwood47","Rashwood",47,null,192.5]
["Rashwood48","Rashwood",48,null,192.5]
[{"$f":"B94&C94","v":"Rashwood49"},"Rashwood",49,null,192.5]
["Rashwood50","Rashwood",50,null,192.5]
["Rashwood51","Rashwood",51,null,192.5]
["Rashwood52","Rashwood",52,null,192.5]
["Rashwood53","Rashwood",53,null,192.5]
["Rush Court32","Rush Court",32,null,{"$f":"153-7","v":146}]
["Rush Court33","Rush Court",33,null,153]
["Rush Court34","Rush Court",34,null,153]
["Rush Court35","Rush Court",35,null,153]
["Rush Court36","Rush Court",36,null,153]
["Rush Court37","Rush Court",37,null,153]
["Rush Court38","Rush Court",38,null,153]
["Rush Court39","Rush Court",39,null,153]
["Rush Court40","Rush Court",40,null,153]
["Rush Court41","Rush Court",41,null,160]
["Rush Court42","Rush Court",42,null,160]
["Rush Court43","Rush Court",43,null,160]
["Rush Court44","Rush Court",44,null,160]
["Rush Court45","Rush Court",45,null,160]
["Rush Court46","Rush Court",46,null,160]
["Rush Court47","Rush Court",47,null,160]
[{"$f":"B115&C115","v":"Rush Court48"},"Rush Court",48,null,160]
["The Lodge50","The Lodge",50,null,224.3]
["The Lodge51","The Lodge",51,null,224.3]
["The Lodge52","The Lodge",52,null,224.3]
["The Lodge53","The Lodge",53,null,230.3]
["The Lodge54","The Lodge",54,null,230.3]
["The Lodge55","The Lodge",55,null,230.3]
["The Lodge56","The Lodge",56,null,230.3]
["The Lodge57","The Lodge",57,null,230.3]
["The Lodge58","The Lodge",58,null,230.3]
["The Lodge59","The Lodge",59,null,230.3]
["The Lodge60","The Lodge",60,null,230.3]
["The Lodge61","The Lodge",61,null,230.3]

{"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]