{"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":11,"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":69,"n_cols":11,"rows_kept":69,"cut":false,"hidden":false,"merged":[[60,0,60,1],[60,6,60,10],[68,0,68,5],[68,6,68,10],[63,6,63,10],[64,6,64,10],[65,6,65,10],[66,6,66,10],[67,6,67,10],[57,0,57,1],[57,6,57,10],[58,0,58,1],[58,6,58,10],[59,0,59,1],[59,6,59,10],[54,0,54,1],[54,6,54,10],[55,0,55,1],[55,6,55,10],[56,0,56,1],[56,6,56,10],[51,0,51,1],[51,6,51,10],[52,0,52,1],[52,6,52,10],[53,0,53,1],[53,6,53,10],[48,0,48,1],[48,6,48,10],[49,0,49,1],[49,6,49,10],[50,0,50,1],[50,6,50,10],[45,0,45,1],[45,6,45,10],[46,0,46,1],[46,6,46,10],[47,0,47,1],[47,6,47,10],[42,0,42,1],[42,6,42,10],[43,0,43,1],[43,6,43,10],[44,0,44,1],[44,6,44,10],[39,0,39,1],[39,6,39,10],[40,0,40,1],[40,6,40,10],[41,0,41,1],[41,6,41,10],[36,0,36,1],[36,6,36,10],[37,0,37,1],[37,6,37,10],[38,0,38,1],[38,6,38,10],[33,0,33,1],[33,6,33,10],[34,0,34,1],[34,6,34,10],[35,0,35,1],[35,6,35,10],[30,0,30,1],[30,6,30,10],[31,0,31,1],[31,6,31,10],[32,0,32,1],[32,6,32,10],[27,0,27,1],[27,6,27,10],[28,0,28,1],[28,6,28,10],[29,0,29,1],[29,6,29,10],[20,9,20,10],[21,9,21,10],[11,0,11,2],[12,0,12,2],[13,0,13,2],[14,0,14,2],[16,0,16,2],[18,0,18,2],[16,8,16,9],[23,0,23,10],[25,0,25,1],[25,6,25,10],[26,0,26,1],[26,6,26,10],[7,0,7,2],[9,0,9,2],[6,0,6,2],[0,0,0,10],[1,0,1,10],[3,7,3,10],[5,0,5,2],[5,8,5,9],[3,0,3,2]]}
[{"$f":"VLOOKUP(Data!I10,Data!A2:B11,2,FALSE)","v":"NA"}]
["Week Commencing: "]
[]
["Requested Skills Mix (Staff):",null,null,"RN","Carer","Snr Carer","Total","Expected Occupancy"]
[]
["AM:",null,null,null,null,null,{"$f":"SUM(D6:F6)","v":0},null,{"$f":"SUM(J10:J13)","v":0}]
["PM:",null,null,null,null,null,{"$f":"SUM(D7:F7)","v":0}]
["ND:",null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,"Dependency","No of Res","Hours"]
["Requested Skills Mix (Hours):",null,null,"RN","Carer",null,"Total",null,"Low",null,2.5]
[null,null,null,null,null,null,null,null,"Medium",null,3]
["AM:",null,null,{"$f":"IF(Budget!$B$1=\"NA\",0,VLOOKUP(Shifts!$B1,Shifts!$A$6:$E$29,4,FALSE)*D6)","v":0},{"$f":"IF(Budget!$B$1=\"NA\",0,VLOOKUP(Shifts!$B1,Shifts!$A$6:$E$29,5,FALSE)*SUM(E6:F6))","v":0},null,{"$f":"SUM(D12:F12)","v":0},null,"High",null,4]
["PM:",null,null,{"$f":"IF(Budget!$B$1=\"NA\",0,VLOOKUP(Shifts!$B2,Shifts!$A$6:$E$29,4,FALSE)*D7)","v":0},{"$f":"IF(Budget!$B$1=\"NA\",0,VLOOKUP(Shifts!$B2,Shifts!$A$6:$E$29,5,FALSE)*SUM(E7:F7))","v":0},null,{"$f":"SUM(D13:F13)","v":0},null,"Very High",null,4.5]
["ND:",null,null,{"$f":"IF(Budget!$B$1=\"NA\",0,VLOOKUP(Shifts!$B3,Shifts!$A$6:$E$29,4,FALSE)*D8)","v":0},{"$f":"IF(Budget!$B$1=\"NA\",0,VLOOKUP(Shifts!$B3,Shifts!$A$6:$E$29,5,FALSE)*SUM(E8:F8))","v":0},null,0]
["TOTAL:",null,null,{"$f":"SUM(D12:D14)","v":0},{"$f":"SUM(E12:E14)","v":0},null,{"$f":"SUM(G12:G14)","v":0},null,"Dependency-related"]
[null,null,null,null,null,null,null,null,"Care Assistant Hours"]
["Budget:",null,null,{"$f":"IF(Budget!$B$1=\"NA\",0,VLOOKUP(Budget!$B$1,Budget!$A$7:$E$134,4,FALSE))","v":0},{"$f":"IF(Budget!$B$1=\"NA\",0,VLOOKUP(Budget!$B$1,Budget!$A$7:$E$134,5,FALSE))","v":0},null,{"$f":"SUM(D17:F17)","v":0},null,{"$f":"(J10*K10)+(J11*K11)+(J12*K12)+(J13*K13)","v":0}]
[]
["Under\\(Over) Budget",null,null,{"$f":"+D17-D15","v":0},{"$f":"+E17-E15","v":0},null,{"$f":"+G17-G15","v":0}]
[]
["Rota Reviewed",null,null,null,"Yes\\No",null,"EFHL Text sent",null,null,"Yes\\No"]
["Supernumeray status reviewed",null,null,null,"Yes\\No",null,"All vacancies notified to HR",null,null,"Yes\\No"]
[]
["Agency shifts requested:"]
[]
[null,null,"RN","Carer","Snr Carer","Total Hrs","Comments"]
[]
["Monday"]
["AM",null,null,null,null,{"$f":"SUM(C29:E29)","v":0}]
["PM",null,null,null,null,{"$f":"SUM(C30:E30)","v":0}]
["ND",null,null,null,null,0]
[]
["Tuesday"]
["AM",null,null,null,null,{"$f":"SUM(C34:E34)","v":0}]
["PM",null,null,null,null,{"$f":"SUM(C35:E35)","v":0}]
["ND",null,null,null,null,0]
[]
["Wednesday"]
["AM",null,null,null,null,{"$f":"SUM(C39:E39)","v":0}]
["PM",null,null,null,null,{"$f":"SUM(C40:E40)","v":0}]
["ND",null,null,null,null,0]
[]
["Thursday"]
["AM",null,null,null,null,{"$f":"SUM(C44:E44)","v":0}]
["PM",null,null,null,null,{"$f":"SUM(C45:E45)","v":0}]
["ND",null,null,null,null,0]
[]
["Friday"]
["AM",null,null,null,null,{"$f":"SUM(C49:E49)","v":0}]
["PM",null,null,null,null,{"$f":"SUM(C50:E50)","v":0}]
["ND",null,null,null,null,0]
[]
["Saturday"]
["AM",null,null,null,null,{"$f":"SUM(C54:E54)","v":0}]
["PM",null,null,null,null,{"$f":"SUM(C55:E55)","v":0}]
["ND",null,null,null,null,0]
[]
["Sunday"]
["AM",null,null,null,null,{"$f":"SUM(C59:E59)","v":0}]
["PM",null,null,null,null,{"$f":"SUM(C60:E60)","v":0}]
["ND",null,null,null,null,0]
["Total",null,{"$f":"SUM(C29:C61)","v":0},0,0,{"$f":"SUM(F29:F61)","v":0}]
[]
[null,null,"RN","Carer","Snr Carer","Total","Comments"]
["Vacant Hours",null,null,null,null,{"$f":"SUM(C65:E65)","v":0}]
["Annual Leave Hours",null,null,null,null,{"$f":"SUM(C66:E66)","v":0}]
["Absence Hours",null,null,null,null,0]
["Overtime Hours",null,null,null,null,0]
["Ver 1.4_2526"]

{"sheet":"Data","index":1,"n_rows":11,"n_cols":9,"rows_kept":11,"cut":false,"hidden":false,"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,"NA",null,null,null,null,null,"Link",10]
[10,"NA"]

{"sheet":"Budget","index":2,"n_rows":134,"n_cols":5,"rows_kept":134,"cut":false,"hidden":true,"merged":[]}
[null,{"$f":"IF(HomeName=\"NA\",\"NA\",HomeName&Weekly!I6)","v":"NA"}]
[]
[]
[]
[null,null,null,"Hours"]
["Lookup","Home","Occupancy","RN","CA"]
[{"$f":"B7&C7","v":"Cotswold41"},"Cotswold",41,45.29,153.5]
[{"$f":"B8&C8","v":"Cotswold42"},"Cotswold",42,45.29,177.5]
["Cotswold43","Cotswold",43,45.29,177.5]
["Cotswold44","Cotswold",44,45.29,177.5]
["Cotswold45","Cotswold",45,45.29,177.5]
["Cotswold46","Cotswold",46,45.29,177.5]
["Cotswold47","Cotswold",47,45.29,190.5]
["Cotswold48","Cotswold",48,45.29,190.5]
["Cotswold49","Cotswold",49,45.29,190.5]
["Cotswold50","Cotswold",50,45.29,190.5]
[{"$f":"B17&C17","v":"Cotswold51"},"Cotswold",51,45.29,190.5]
[{"$f":"B18&C18","v":"Eversfield33"},"Eversfield",33,29.64,161.75]
["Eversfield34","Eversfield",34,29.64,161.75]
["Eversfield35","Eversfield",35,29.64,161.75]
["Eversfield36","Eversfield",36,29.64,161.75]
["Eversfield37","Eversfield",37,29.64,161.75]
["Eversfield38","Eversfield",38,29.64,174]
["Eversfield39","Eversfield",39,29.64,174]
["Eversfield40","Eversfield",40,29.64,174]
["Eversfield41","Eversfield",41,29.64,174]
["Eversfield42","Eversfield",42,29.64,174]
["Eversfield43","Eversfield",43,29.64,198.5]
["Eversfield44","Eversfield",44,29.64,198.5]
["Eversfield45","Eversfield",45,29.64,198.5]
["Eversfield46","Eversfield",46,29.64,198.5]
["Eversfield47","Eversfield",47,29.64,198.5]
["Eversfield48","Eversfield",48,29.64,210.75]
["Eversfield49","Eversfield",49,29.64,210.75]
["Eversfield50","Eversfield",50,29.64,210.75]
["Eversfield51","Eversfield",51,29.64,210.75]
["Eversfield52","Eversfield",52,29.64,210.75]
["Grove Court50","Grove Court",50,34.71,191.96]
["Grove Court51","Grove Court",51,34.71,216.71]
["Grove Court52","Grove Court",52,34.71,216.71]
["Grove Court53","Grove Court",53,34.71,216.71]
["Grove Court54","Grove Court",54,34.71,216.71]
["Grove Court55","Grove Court",55,34.71,216.71]
["Grove Court56","Grove Court",56,34.71,216.71]
["Grove Court57","Grove Court",57,34.71,229.21]
["Grove Court58","Grove Court",58,34.71,229.21]
["Grove Court59","Grove Court",59,34.71,229.21]
["Grove Court60","Grove Court",60,34.71,229.21]
[{"$f":"B49&C49","v":"Grove Court61"},"Grove Court",61,34.71,229.21]
["Halliwell54","Halliwell",54,63.04,193.6]
["Halliwell55","Halliwell",55,63.04,218.6]
["Halliwell56","Halliwell",56,63.04,218.6]
["Halliwell57","Halliwell",57,63.04,218.6]
["Halliwell58","Halliwell",58,63.04,218.6]
["Halliwell59","Halliwell",59,63.04,218.6]
["Halliwell60","Halliwell",60,63.04,232]
["Halliwell61","Halliwell",61,63.04,232]
["Halliwell62","Halliwell",62,63.04,232]
[{"$f":"B59&C59","v":"Halliwell63"},"Halliwell",63,63.04,232]
["Halliwell64","Halliwell",64,63.04,232]
["Merlewood31","Merlewood",31,56.29,106.5]
["Merlewood32","Merlewood",32,56.29,106.5]
["Merlewood33","Merlewood",33,56.29,106.5]
["Merlewood34","Merlewood",34,56.29,106.5]
["Merlewood35","Merlewood",35,56.29,117.5]
["Merlewood36","Merlewood",36,56.29,117.5]
["Merlewood37","Merlewood",37,56.29,117.5]
["Merlewood38","Merlewood",38,56.29,117.5]
["Merlewood39","Merlewood",39,56.29,117.5]
["Merlewood40","Merlewood",40,56.29,131.5]
["Merlewood41","Merlewood",41,56.29,131.5]
["Merlewood42","Merlewood",42,56.29,131.5]
["Merlewood43","Merlewood",43,56.29,131.5]
["Merlewood44","Merlewood",44,56.29,131.5]
["Merlewood45","Merlewood",45,56.29,156.5]
["Merlewood46","Merlewood",46,56.29,156.5]
["Merlewood47","Merlewood",47,56.29,156.5]
["Merlewood48","Merlewood",48,56.29,156.5]
["Merlewood49","Merlewood",49,56.29,156.5]
["Merlewood50","Merlewood",50,56.29,170.5]
["Merlewood51","Merlewood",51,56.29,170.5]
["Merlewood52","Merlewood",52,56.29,170.5]
[{"$f":"B83&C83","v":"Merlewood53"},"Merlewood",53,56.29,170.5]
["Merlewood54","Merlewood",54,56.29,170.5]
["Rashwood37","Rashwood",37,56.79,{"$f":"+E86","v":161.75}]
["Rashwood38","Rashwood",38,56.79,{"$f":"+E87-13","v":161.75}]
["Rashwood39","Rashwood",39,56.79,{"$f":"+E88","v":174.75}]
["Rashwood40","Rashwood",40,56.79,174.75]
["Rashwood41","Rashwood",41,56.79,174.75]
["Rashwood42","Rashwood",42,56.79,{"$f":"+E91","v":174.75}]
["Rashwood43","Rashwood",43,56.79,{"$f":"+E92-13-11","v":174.75}]
["Rashwood44","Rashwood",44,56.79,{"$f":"+E93","v":198.75}]
["Rashwood45","Rashwood",45,56.79,198.75]
["Rashwood46","Rashwood",46,56.79,198.75]
["Rashwood47","Rashwood",47,56.79,{"$f":"+E96","v":198.75}]
["Rashwood48","Rashwood",48,56.79,{"$f":"+E97-13","v":198.75}]
[{"$f":"B97&C97","v":"Rashwood49"},"Rashwood",49,56.79,211.75]
["Rashwood50","Rashwood",50,56.79,211.75]
["Rashwood51","Rashwood",51,56.79,211.75]
["Rashwood52","Rashwood",52,56.79,211.75]
["Rashwood53","Rashwood",53,56.79,211.75]
["Rush Court30","Rush Court",30,44.54,{"$f":"+E103","v":120.25}]
["Rush Court31","Rush Court",31,44.54,120.25]
[{"$f":"B104&C104","v":"Rush Court32"},"Rush Court",32,44.54,{"$f":"+E105","v":120.25}]
[{"$f":"B105&C105","v":"Rush Court33"},"Rush Court",33,44.54,{"$f":"+E106-13.5","v":120.25}]
["Rush Court34","Rush Court",34,44.54,{"$f":"+E107","v":133.75}]
["Rush Court35","Rush Court",35,44.54,133.75]
["Rush Court36","Rush Court",36,44.54,133.75]
["Rush Court37","Rush Court",37,44.54,{"$f":"+E110","v":133.75}]
["Rush Court38","Rush Court",38,44.54,{"$f":"+E111-13.5-11.25","v":133.75}]
["Rush Court39","Rush Court",39,44.54,{"$f":"+E112","v":158.5}]
["Rush Court40","Rush Court",40,44.54,158.5]
["Rush Court41","Rush Court",41,44.54,158.5]
["Rush Court42","Rush Court",42,44.54,{"$f":"+E115","v":158.5}]
["Rush Court43","Rush Court",43,44.54,{"$f":"+E116-13.5","v":158.5}]
["Rush Court44","Rush Court",44,44.54,172]
["Rush Court45","Rush Court",45,44.54,172]
["Rush Court46","Rush Court",46,44.54,172]
["Rush Court47","Rush Court",47,44.54,172]
[{"$f":"B120&C120","v":"Rush Court48"},"Rush Court",48,44.54,172]
[{"$f":"B121&C121","v":"The Lodge48"},"The Lodge",48,56.72,{"$f":"+E122","v":204.93}]
["The Lodge49","The Lodge",49,56.72,204.93]
["The Lodge50","The Lodge",50,56.72,{"$f":"+E124-13-12","v":204.93}]
["The Lodge51","The Lodge",51,56.72,229.93]
["The Lodge52","The Lodge",52,56.72,229.93]
["The Lodge53","The Lodge",53,56.72,229.93]
[{"$f":"B127&C127","v":"The Lodge54"},"The Lodge",54,56.72,{"$f":"+E128","v":229.93}]
[{"$f":"B128&C128","v":"The Lodge55"},"The Lodge",55,56.72,{"$f":"+E129-13","v":229.93}]
["The Lodge56","The Lodge",56,56.72,242.93]
["The Lodge57","The Lodge",57,56.72,242.93]
["The Lodge58","The Lodge",58,56.72,242.93]
["The Lodge59","The Lodge",59,56.72,242.93]
["The Lodge60","The Lodge",60,56.72,242.93]
["The Lodge61","The Lodge",61,56.72,242.93]

{"sheet":"Shifts","index":3,"n_rows":29,"n_cols":5,"rows_kept":29,"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,6.5]
["CotswoldPM","Cotswold","PM",7,6.5]
["CotswoldND","Cotswold","ND",11,11]
["EversfieldAM","Eversfield","AM",6.125,6]
["EversfieldPM","Eversfield","PM",6.125,6]
["EversfieldND","Eversfield","ND",12.25,12]
["Grove CourtAM","Grove Court","AM",6.25,6.25]
["Grove CourtPM","Grove Court","PM",6.25,6.25]
["Grove CourtND","Grove Court","ND",12.25,12.25]
["HalliwellAM","Halliwell","AM",6.75,6.75]
["HalliwellPM","Halliwell","PM",6.75,6.75]
["HalliwellND","Halliwell","ND",11.5,11.5]
["MerlewoodAM","Merlewood","AM",7,7]
["MerlewoodPM","Merlewood","PM",7,7]
["MerlewoodND","Merlewood","ND",11,11]
["RashwoodAM","Rashwood","AM",6.75,6.5]
["RashwoodPM","Rashwood","PM",6.75,6.5]
["RashwoodND","Rashwood","ND",11.25,11]
["Rush CourtAM","Rush Court","AM",6.75,6.75]
["Rush CourtPM","Rush Court","PM",6.75,6.75]
["Rush CourtND","Rush Court","ND",11.25,11.25]
["The LodgeAM","The Lodge","AM",6.25,6.5]
["The LodgePM","The Lodge","PM",6.25,6.5]
["The LodgeND","The Lodge","ND",12,12]