{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["INSTRUCTIONS","FULL ROTA"],"not_rendered":{"charts":0,"images":2,"macros":0,"external_links":0,"defined_names":2,"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":"INSTRUCTIONS","index":0,"n_rows":36,"n_cols":34,"rows_kept":36,"cut":false,"hidden":false,"merged":[[32,26,32,28],[33,26,33,28],[34,26,34,28],[35,26,35,28],[35,29,35,31],[3,29,5,29],[3,30,5,30],[3,31,5,31],[27,26,27,27],[30,26,30,28],[31,26,31,28],[3,17,3,18],[3,20,3,21],[3,24,5,25],[3,26,5,26],[3,27,5,27],[3,28,5,28],[1,1,1,22],[1,25,1,26],[1,27,1,28],[2,25,2,26],[2,29,2,30],[3,2,3,3],[3,5,3,6],[3,8,3,9],[3,11,3,12],[3,14,3,15]]}
[]
[null,"Your business name here",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Forecasted takings",null,8000,null,null,"Budget",0.25]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"This Rota",null,{"$f":"AF28/AB2","v":6.25E-2}]
["Week Ending",null,"MONDAY",null,null,"TUESDAY",null,null,"WEDNESDAY",null,null,"THURSDAY",null,null,"FRIDAY",null,null,"SATURDAY",null,null,"SUNDAY",null,null,null,"Hourly or \nSalary?",null,"PAY RATE","HOURS"," GROSS PAY","E'ER \nN.I.","E'ER PENSION","TOTAL \nCOST"]
["23.11.25",null,"START","FINISH",null,"START","FINISH",null,"START","FINISH",null,"START","FINISH",null,"START","FINISH",null,"START","FINISH",null,"START","FINISH"]
[]
["Name 1",null,null,null,{"$f":"IF(C7>D7,(24-((C7-D7)*24)),(D7-C7)*24)","v":0},null,null,{"$f":"IF(F7>G7,(24-((F7-G7)*24)),(G7-F7)*24)","v":0},null,null,{"$f":"IF(I7>J7,(24-((I7-J7)*24)),(J7-I7)*24)","v":0},null,null,{"$f":"IF(L7>M7,(24-((L7-M7)*24)),(M7-L7)*24)","v":0},null,null,{"$f":"IF(O7>P7,(24-((O7-P7)*24)),(P7-O7)*24)","v":0},null,null,{"$f":"IF(R7>S7,(24-((R7-S7)*24)),(S7-R7)*24)","v":0},null,null,{"$f":"IF(U7>V7,(24-((U7-V7)*24)),(V7-U7)*24)","v":0},null,"S",{"$f":"IF(A7=A6,\"\",A7)","v":"Name 1"},500,{"$f":"SUMIF(A:A,Z7,E:E)+SUMIF(A:A,Z7,H:H)+SUMIF(A:A,Z7,K:K)+SUMIF(A:A,Z7,N:N)+SUMIF(A:A,Z7,Q:Q)+SUMIF(A:A,Z7,T:T)+SUMIF(A:A,Z7,W:W)","v":0},{"$f":"IF(Y7=\"S\",AA7,AB7*AA7)","v":500},{"$f":"IF(AC7>=$Z$31,(AC7-$Z$31)*$Z$32,0)","v":0},{"$f":"IF(AC7>=$Z$34,(AC7-$Z$35)*$Z$33,0)","v":0},{"$f":"SUM(AC7:AE7)","v":500},null,"H"]
["Name 2",null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,"H",{"$f":"IF(A8=A7,\"\",A8)","v":"Name 2"},15,0,{"$f":"IF(Y8=\"S\",AA8,AB8*AA8)","v":0},{"$f":"IF(AC8>=$Z$31,(AC8-$Z$31)*$Z$32,0)","v":0},0,{"$f":"SUM(AC8:AE8)","v":0},null,"S"]
["Name 3",null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,"H",{"$f":"IF(A9=A8,\"\",A9)","v":"Name 3"},15,0,0,0,0,0]
["Name 4",null,null,null,{"$f":"IF(C10>D10,(24-((C10-D10)*24)),(D10-C10)*24)","v":0},null,null,{"$f":"IF(F10>G10,(24-((F10-G10)*24)),(G10-F10)*24)","v":0},null,null,{"$f":"IF(I10>J10,(24-((I10-J10)*24)),(J10-I10)*24)","v":0},null,null,{"$f":"IF(L10>M10,(24-((L10-M10)*24)),(M10-L10)*24)","v":0},null,null,{"$f":"IF(O10>P10,(24-((O10-P10)*24)),(P10-O10)*24)","v":0},null,null,{"$f":"IF(R10>S10,(24-((R10-S10)*24)),(S10-R10)*24)","v":0},null,null,{"$f":"IF(U10>V10,(24-((U10-V10)*24)),(V10-U10)*24)","v":0},null,"H",{"$f":"IF(A10=A9,\"\",A10)","v":"Name 4"},9,0,0,0,0,0]
["Name 5",null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,"H","Name 5",8.5,0,0,0,0,0]
["Name 6",null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,"H","Name 6",8.5,0,0,0,0,0]
["Name 7",null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,"H","Name 7",8.5,0,0,0,0,0]
["Name 8",null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,"H","Name 8",7.5,0,0,0,0,0]
["Name 9",null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,"H","Name 9",7.5,0,0,0,0,0]
["Name 10",null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,"H","Name 10",11,0,0,0,0,0]
["Name 11",null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,"H","Name 11",7.5,0,0,0,0,0]
[null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,"H",0,7.5,0,0,0,0,0]
[null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,"H","",7.5,0,0,0,0,0]
[null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,"H","",7.5,0,0,0,0,0]
[null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,"H","",7.5,0,0,0,0,0]
[null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,"H","",7,0,0,0,0,0]
[null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,"H","",7.5,0,0,0,0,0]
[null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,"H","",7.5,0,0,0,0,0]
[null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,"H","",7.5,0,0,0,0,0]
[null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,"H","",7.5,0,0,0,0,0]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTALS",null,{"$f":"SUM(AC7:AC26)","v":500},{"$f":"SUM(AD7:AD26)","v":0},0,500]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Secondary threshold (weekly) "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Secondary Class 1 NIC"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Employer contribution"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Enrollment threshold"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pension threshold"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Holiday accrual %",null,null,"www.roslyns.co.uk"]

{"sheet":"FULL ROTA","index":1,"n_rows":36,"n_cols":49,"rows_kept":36,"cut":false,"hidden":false,"merged":[[1,1,1,22],[1,25,1,26],[1,27,1,28],[3,11,3,12],[3,14,3,15],[3,24,5,25],[3,17,3,18],[3,20,3,21],[3,2,3,3],[3,5,3,6],[3,8,3,9],[2,25,2,26],[3,28,5,28],[3,27,5,27],[2,29,2,30],[3,26,5,26],[3,29,5,29],[3,30,5,30],[3,32,5,32],[3,31,5,31],[27,31,27,32],[35,29,35,31],[35,26,35,28],[34,26,34,28],[33,26,33,28],[27,26,27,27],[30,29,33,31],[32,26,32,28],[31,26,31,28],[30,26,30,28]]}
[]
[null,"My Vet - Bristol",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Forecasted takings",null,25000,null,null,"Budget",0.35,null,null,null,null,"Yes"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"This Rota",null,{"$f":"AF28/(AB2/1.2)","v":0.34481105796923073},null,null,null,null,"No"]
["Week Ending",null,"MONDAY",null,null,"TUESDAY",null,null,"WEDNESDAY",null,null,"THURSDAY",null,null,"FRIDAY",null,null,"SATURDAY",null,null,"SUNDAY",null,null,null,"Hourly or \nSalary?",null,"PAY RATE","HOURS"," GROSS PAY","E'ER \nN.I.","E'ER PENSION","TOTAL \nCOST","Pension?"]
["23.11.25",null,"START","FINISH",null,"START","FINISH",null,"START","FINISH",null,"START","FINISH",null,"START","FINISH",null,"START","FINISH",null,"START","FINISH"]
[]
["Practice manager",null,"08:00:00","16:00:00",{"$f":"IF(C7>D7,(24-((C7-D7)*24)),(D7-C7)*24)","v":8},"12:00:00","18:00:00",{"$f":"IF(F7>G7,(24-((F7-G7)*24)),(G7-F7)*24)","v":6},"08:00:00","16:00:00",{"$f":"IF(I7>J7,(24-((I7-J7)*24)),(J7-I7)*24)","v":8},"12:00:00","18:00:00",{"$f":"IF(L7>M7,(24-((L7-M7)*24)),(M7-L7)*24)","v":6},"08:00:00","16:00:00",{"$f":"IF(O7>P7,(24-((O7-P7)*24)),(P7-O7)*24)","v":8},"12:00:00","18:00:00",{"$f":"IF(R7>S7,(24-((R7-S7)*24)),(S7-R7)*24)","v":6},null,null,{"$f":"IF(U7>V7,(24-((U7-V7)*24)),(V7-U7)*24)","v":0},null,"S",{"$f":"IF(A7=A6,\"\",A7)","v":"Practice manager"},961.54,{"$f":"SUMIF(A:A,Z7,E:E)+SUMIF(A:A,Z7,H:H)+SUMIF(A:A,Z7,K:K)+SUMIF(A:A,Z7,N:N)+SUMIF(A:A,Z7,Q:Q)+SUMIF(A:A,Z7,T:T)+SUMIF(A:A,Z7,W:W)","v":42},{"$f":"IF(Y7=\"S\",AA7,AB7*AA7)","v":961.54},{"$f":"IF(AC7>=$Z$31,(AC7-$Z$31)*$Z$32,0)","v":129.80792307692309},{"$f":"IF(AG7=\"No\", 0, IF(AC7>=$Z$34, (AC7-$Z$35)*$Z$33, 0))","v":25.246199999999998},{"$f":"SUM(AC7:AE7)","v":1116.5941230769231},"Yes","H"]
["Asst practise manager",null,"12:00:00","18:00:00",6,"08:00:00","16:00:00",8,"12:00:00","18:00:00",6,"08:00:00","16:00:00",8,"12:00:00","18:00:00",6,"08:00:00","16:00:00",8,null,null,0,null,"S",{"$f":"IF(A8=A7,\"\",A8)","v":"Asst practise manager"},673.08,42,{"$f":"IF(Y8=\"S\",AA8,AB8*AA8)","v":673.08},{"$f":"IF(AC8>=$Z$31,(AC8-$Z$31)*$Z$32,0)","v":86.538923076923098},{"$f":"IF(AG8=\"No\", 0, IF(AC8>=$Z$34, (AC8-$Z$35)*$Z$33, 0))","v":16.592400000000001},{"$f":"SUM(AC8:AE8)","v":776.21132307692312},"Yes","S"]
["Receptionist",null,"09:00:00","17:00:00",8,"09:00:00","17:00:00",8,"09:00:00","17:00:00",8,"09:00:00","17:00:00",8,"09:00:00","17:00:00",8,"09:00:00","17:00:00",8,null,null,0,null,"H",{"$f":"IF(A9=A8,\"\",A9)","v":"Receptionist"},12,48,576,71.976923076923086,13.68,661.65692307692302,"Yes"]
["Head Vet",null,"08:00:00","16:00:00",{"$f":"IF(C10>D10,(24-((C10-D10)*24)),(D10-C10)*24)","v":8},"08:00:00","16:00:00",{"$f":"IF(F10>G10,(24-((F10-G10)*24)),(G10-F10)*24)","v":8},null,null,{"$f":"IF(I10>J10,(24-((I10-J10)*24)),(J10-I10)*24)","v":0},"08:00:00","16:00:00",{"$f":"IF(L10>M10,(24-((L10-M10)*24)),(M10-L10)*24)","v":8},"08:00:00","16:00:00",{"$f":"IF(O10>P10,(24-((O10-P10)*24)),(P10-O10)*24)","v":8},"08:00:00","16:00:00",{"$f":"IF(R10>S10,(24-((R10-S10)*24)),(S10-R10)*24)","v":8},"08:00:00","14:00:00",{"$f":"IF(U10>V10,(24-((U10-V10)*24)),(V10-U10)*24)","v":6.0000000000000018},null,"S",{"$f":"IF(A10=A9,\"\",A10)","v":"Head Vet"},1346.15,46,1346.15,187.49942307692308,36.784500000000001,1570.4339230769231,"Yes"]
["F/T Vet",null,"09:00:00","17:00:00",8,"09:00:00","17:00:00",8,"08:00:00","16:00:00",8,null,null,0,null,null,0,"09:00:00","17:00:00",8,"08:00:00","14:00:00",6.0000000000000018,null,"S","F/T Vet",769.23,38,769.23,100.96142307692308,19.476900000000001,889.66832307692312,"Yes"]
["F/T Vet 2",null,null,null,0,"09:00:00","17:00:00",8,"08:00:00","16:00:00",8,"09:00:00","17:00:00",8,"09:00:00","17:00:00",8,null,null,0,null,null,0,null,"S","F/T Vet 2",769.23,32,769.23,100.96142307692308,19.476900000000001,889.66832307692312,"Yes"]
["Vet nurse",null,"09:00:00","17:00:00",8,null,null,0,null,null,0,"09:00:00","17:00:00",8,null,null,0,null,null,0,"08:00:00","14:00:00",6.0000000000000018,null,"H","Vet nurse",17,22,374,41.676923076923089,7.62,423.29692307692312,"Yes"]
["Vet nurse 2",null,"09:00:00","17:00:00",8,null,null,0,"08:00:00","16:00:00",8,null,null,0,"09:00:00","17:00:00",8,"09:00:00","17:00:00",8,null,null,0,null,"H","Vet nurse 2",13,32,416,47.976923076923086,8.879999999999999,472.85692307692307,"Yes"]
["Vet nurse 3",null,null,null,0,"09:00:00","17:00:00",8,null,null,0,"09:00:00","17:00:00",8,"09:00:00","17:00:00",8,"09:00:00","17:00:00",8,"08:00:00","16:00:00",8,null,"H","Vet nurse 3",8.5,40,340,36.57692307692308,6.6,383.17692307692312,"Yes"]
[null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,"H",0,11,0,0,0,0,0,"Yes"]
[null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,"H","",7.5,0,0,0,0,0,"Yes"]
[null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,"H","",7.5,0,0,0,0,0,"Yes"]
[null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,"H","",7.5,0,0,0,0,0,"Yes"]
[null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,"H","",7.5,0,0,0,0,0,"Yes"]
[null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,"H","",7.5,0,0,0,0,0,"Yes"]
[null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,"H","",7,0,0,0,0,0,"Yes"]
[null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,"H","",7.5,0,0,0,0,0,"Yes"]
[null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,"H","",7.5,0,0,0,0,0,"Yes"]
[null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,"H","",7.5,0,0,0,0,0,"Yes"]
[null,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,"H","",7.5,0,0,0,0,0,"Yes",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTALS",null,{"$f":"SUM(AC7:AC26)","v":6225.23},{"$f":"SUM(AD7:AD26)","v":803.97680769230783},154.3569,{"$f":"IF(AW26=TRUE, AI28 + (AI28 * Z36), AI28)","v":7183.5637076923076},null,null,{"$f":"SUM(AF7:AF26)","v":7183.5637076923076}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,96.153846153846104,"Secondary threshold (weekly) "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.15,"Secondary Class 1 NIC"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.03,"Employer contribution"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,192,"Enrollment threshold"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,120,"Pension threshold"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.1207,"Holiday accrual %",null,null,"www.roslyns.co.uk"]