{"text_format":"3","workbook":"xlsx","n_sheets":5,"sheets":["Schedule","Shifts","Employees","Teams","Additional Info"],"not_rendered":{"images":2,"defined_names":7},"read":"whole","date_system":"1900"}

{"sheet":"Schedule","index":0,"n_rows":37,"n_cols":89,"rows_kept":37,"merged":[[0,0,0,30],[2,1,2,4],[31,0,31,21],[32,0,32,16],[33,0,33,21]]}
["6 On 2 Off Rotating Shift Schedule\n[Company Name]\n"]
[]
["Period Start Date :","2010-01-04"]
[]
[null,{"$f":"B3","v":"2010-01-04"},{"$f":"B5+1","v":"2010-01-05"},"2010-01-06","2010-01-07","2010-01-08","2010-01-09","2010-01-10","2010-01-11","2010-01-12","2010-01-13","2010-01-14","2010-01-15","2010-01-16","2010-01-17","2010-01-18","2010-01-19","2010-01-20","2010-01-21","2010-01-22","2010-01-23","2010-01-24","2010-01-25","2010-01-26","2010-01-27","2010-01-28","2010-01-29","2010-01-30","2010-01-31","Paid","Total",null,"Shift Hours","Shift Hours","Shift Hours","Shift Hours","Shift Hours","Shift Hours","Shift Hours","Shift Hours","Shift Hours","Shift Hours","Shift Hours","Shift Hours","Shift Hours","Shift Hours","Shift Hours","Shift Hours","Shift Hours","Shift Hours","Shift Hours","Shift Hours","Shift Hours","Shift Hours","Shift Hours","Shift Hours","Shift Hours","Shift Hours","Shift Hours","Shift Hours",null,"Labor Cost","Labor Cost","Labor Cost","Labor Cost","Labor Cost","Labor Cost","Labor Cost","Labor Cost","Labor Cost","Labor Cost","Labor Cost","Labor Cost","Labor Cost","Labor Cost","Labor Cost","Labor Cost","Labor Cost","Labor Cost","Labor Cost","Labor Cost","Labor Cost","Labor Cost","Labor Cost","Labor Cost","Labor Cost","Labor Cost","Labor Cost","Labor Cost"]
["Team",{"$f":"B3","v":"2010-01-04"},"2010-01-05","2010-01-06","2010-01-07","2010-01-08","2010-01-09","2010-01-10","2010-01-11","2010-01-12","2010-01-13","2010-01-14","2010-01-15","2010-01-16","2010-01-17","2010-01-18","2010-01-19","2010-01-20","2010-01-21","2010-01-22","2010-01-23","2010-01-24","2010-01-25","2010-01-26","2010-01-27","2010-01-28","2010-01-29","2010-01-30","2010-01-31","Hours","Labor Cost",null,{"$f":"B6","v":"2010-01-04"},"2010-01-05","2010-01-06","2010-01-07","2010-01-08","2010-01-09","2010-01-10","2010-01-11","2010-01-12","2010-01-13","2010-01-14","2010-01-15","2010-01-16","2010-01-17","2010-01-18","2010-01-19","2010-01-20","2010-01-21","2010-01-22","2010-01-23","2010-01-24","2010-01-25","2010-01-26","2010-01-27","2010-01-28","2010-01-29","2010-01-30","2010-01-31",null,{"$f":"AG6","v":"2010-01-04"},"2010-01-05","2010-01-06","2010-01-07","2010-01-08","2010-01-09","2010-01-10","2010-01-11","2010-01-12","2010-01-13","2010-01-14","2010-01-15","2010-01-16","2010-01-17","2010-01-18","2010-01-19","2010-01-20","2010-01-21","2010-01-22","2010-01-23","2010-01-24","2010-01-25","2010-01-26","2010-01-27","2010-01-28","2010-01-29","2010-01-30","2010-01-31"]
["Team 1","Day","Day","Day","Day","Day","Day",null,null,"Swing","Swing","Swing","Swing","Swing","Swing",null,null,"Night","Night","Night","Night","Night","Night",{"$nulls":6},{"$f":"SUM(AG7:BH7)","v":{"v":720,"d":"720.0"}},{"$f":"SUM(BJ7:CK7)","v":{"v":12240,"d":"$12,240.00"}},null,{"$f":"IF(B7=\"\",0,VLOOKUP(B7, Shifts, 4,FALSE)*HLOOKUP(A7,Teams,3,FALSE))","v":40},{"$f":"IF(C7=\"\",0,VLOOKUP(C7, Shifts, 4,FALSE)*HLOOKUP(A7,Teams,3,FALSE))","v":40},{"$f":"IF(D7=\"\",0,VLOOKUP(D7, Shifts, 4,FALSE)*HLOOKUP(A7,Teams,3,FALSE))","v":40},{"$f":"IF(E7=\"\",0,VLOOKUP(E7, Shifts, 4,FALSE)*HLOOKUP(A7,Teams,3,FALSE))","v":40},{"$f":"IF(F7=\"\",0,VLOOKUP(F7, Shifts, 4,FALSE)*HLOOKUP(A7,Teams,3,FALSE))","v":40},{"$f":"IF(G7=\"\",0,VLOOKUP(G7, Shifts, 4,FALSE)*HLOOKUP(A7,Teams,3,FALSE))","v":40},{"$f":"IF(H7=\"\",0,VLOOKUP(H7, Shifts, 4,FALSE)*HLOOKUP(A7,Teams,3,FALSE))","v":0},{"$f":"IF(I7=\"\",0,VLOOKUP(I7, Shifts, 4,FALSE)*HLOOKUP(A7,Teams,3,FALSE))","v":0},{"$f":"IF(J7=\"\",0,VLOOKUP(J7, Shifts, 4,FALSE)*HLOOKUP(A7,Teams,3,FALSE))","v":40},{"$f":"IF(K7=\"\",0,VLOOKUP(K7, Shifts, 4,FALSE)*HLOOKUP(A7,Teams,3,FALSE))","v":40},{"$f":"IF(L7=\"\",0,VLOOKUP(L7, Shifts, 4,FALSE)*HLOOKUP(A7,Teams,3,FALSE))","v":40},{"$f":"IF(M7=\"\",0,VLOOKUP(M7, Shifts, 4,FALSE)*HLOOKUP(A7,Teams,3,FALSE))","v":40},{"$f":"IF(N7=\"\",0,VLOOKUP(N7, Shifts, 4,FALSE)*HLOOKUP(A7,Teams,3,FALSE))","v":40},{"$f":"IF(O7=\"\",0,VLOOKUP(O7, Shifts, 4,FALSE)*HLOOKUP(A7,Teams,3,FALSE))","v":40},{"$f":"IF(P7=\"\",0,VLOOKUP(P7, Shifts, 4,FALSE)*HLOOKUP(A7,Teams,3,FALSE))","v":0},{"$f":"IF(Q7=\"\",0,VLOOKUP(Q7, Shifts, 4,FALSE)*HLOOKUP(A7,Teams,3,FALSE))","v":0},{"$f":"IF(R7=\"\",0,VLOOKUP(R7, Shifts, 4,FALSE)*HLOOKUP(A7,Teams,3,FALSE))","v":40},{"$f":"IF(S7=\"\",0,VLOOKUP(S7, Shifts, 4,FALSE)*HLOOKUP(A7,Teams,3,FALSE))","v":40},{"$f":"IF(T7=\"\",0,VLOOKUP(T7, Shifts, 4,FALSE)*HLOOKUP(A7,Teams,3,FALSE))","v":40},{"$f":"IF(U7=\"\",0,VLOOKUP(U7, Shifts, 4,FALSE)*HLOOKUP(A7,Teams,3,FALSE))","v":40},{"$f":"IF(V7=\"\",0,VLOOKUP(V7, Shifts, 4,FALSE)*HLOOKUP(A7,Teams,3,FALSE))","v":40},{"$f":"IF(W7=\"\",0,VLOOKUP(W7, Shifts, 4,FALSE)*HLOOKUP(A7,Teams,3,FALSE))","v":40},{"$f":"IF(X7=\"\",0,VLOOKUP(X7, Shifts, 4,FALSE)*HLOOKUP(A7,Teams,3,FALSE))","v":0},{"$f":"IF(Y7=\"\",0,VLOOKUP(Y7, Shifts, 4,FALSE)*HLOOKUP(A7,Teams,3,FALSE))","v":0},{"$f":"IF(Z7=\"\",0,VLOOKUP(Z7, Shifts, 4,FALSE)*HLOOKUP(A7,Teams,3,FALSE))","v":0},{"$f":"IF(AA7=\"\",0,VLOOKUP(AA7, Shifts, 4,FALSE)*HLOOKUP(A7,Teams,3,FALSE))","v":0},{"$f":"IF(AB7=\"\",0,VLOOKUP(AB7, Shifts, 4,FALSE)*HLOOKUP(A7,Teams,3,FALSE))","v":0},{"$f":"IF(AC7=\"\",0,VLOOKUP(AC7, Shifts, 4,FALSE)*HLOOKUP(A7,Teams,3,FALSE))","v":0},null,{"$f":"AG7*IF(B7=\"\", 0, HLOOKUP(A7,Teams,4,FALSE))","v":680},{"$f":"AH7*IF(C7=\"\", 0, HLOOKUP(A7,Teams,4,FALSE))","v":680},{"$f":"AI7*IF(D7=\"\", 0, HLOOKUP(A7,Teams,4,FALSE))","v":680},{"$f":"AJ7*IF(E7=\"\", 0, HLOOKUP(A7,Teams,4,FALSE))","v":680},{"$f":"AK7*IF(F7=\"\", 0, HLOOKUP(A7,Teams,4,FALSE))","v":680},{"$f":"AL7*IF(G7=\"\", 0, HLOOKUP(A7,Teams,4,FALSE))","v":680},{"$f":"AM7*IF(H7=\"\", 0, HLOOKUP(A7,Teams,4,FALSE))","v":0},{"$f":"AN7*IF(I7=\"\", 0, HLOOKUP(A7,Teams,4,FALSE))","v":0},{"$f":"AO7*IF(J7=\"\", 0, HLOOKUP(A7,Teams,4,FALSE))","v":680},{"$f":"AP7*IF(K7=\"\", 0, HLOOKUP(A7,Teams,4,FALSE))","v":680},{"$f":"AQ7*IF(L7=\"\", 0, HLOOKUP(A7,Teams,4,FALSE))","v":680},{"$f":"AR7*IF(M7=\"\", 0, HLOOKUP(A7,Teams,4,FALSE))","v":680},{"$f":"AS7*IF(N7=\"\", 0, HLOOKUP(A7,Teams,4,FALSE))","v":680},{"$f":"AT7*IF(O7=\"\", 0, HLOOKUP(A7,Teams,4,FALSE))","v":680},{"$f":"AU7*IF(P7=\"\", 0, HLOOKUP(A7,Teams,4,FALSE))","v":0},{"$f":"AV7*IF(Q7=\"\", 0, HLOOKUP(A7,Teams,4,FALSE))","v":0},{"$f":"AW7*IF(R7=\"\", 0, HLOOKUP(A7,Teams,4,FALSE))","v":680},{"$f":"AX7*IF(S7=\"\", 0, HLOOKUP(A7,Teams,4,FALSE))","v":680},{"$f":"AY7*IF(T7=\"\", 0, HLOOKUP(A7,Teams,4,FALSE))","v":680},{"$f":"AZ7*IF(U7=\"\", 0, HLOOKUP(A7,Teams,4,FALSE))","v":680},{"$f":"BA7*IF(V7=\"\", 0, HLOOKUP(A7,Teams,4,FALSE))","v":680},{"$f":"BB7*IF(W7=\"\", 0, HLOOKUP(A7,Teams,4,FALSE))","v":680},{"$f":"BC7*IF(X7=\"\", 0, HLOOKUP(A7,Teams,4,FALSE))","v":0},{"$f":"BD7*IF(Y7=\"\", 0, HLOOKUP(A7,Teams,4,FALSE))","v":0},{"$f":"BE7*IF(Z7=\"\", 0, HLOOKUP(A7,Teams,4,FALSE))","v":0},{"$f":"BF7*IF(AA7=\"\", 0, HLOOKUP(A7,Teams,4,FALSE))","v":0},{"$f":"BG7*IF(AB7=\"\", 0, HLOOKUP(A7,Teams,4,FALSE))","v":0},{"$f":"BH7*IF(AC7=\"\", 0, HLOOKUP(A7,Teams,4,FALSE))","v":0}]
["Team 2",null,null,"Swing","Swing","Swing","Swing","Swing","Swing",null,null,"Night","Night","Night","Night","Night","Night",null,null,"Day","Day","Day","Day","Day","Day",{"$nulls":4},{"$f":"SUM(AG8:BH8)","v":{"v":720,"d":"720.0"}},{"$f":"SUM(BJ8:CK8)","v":{"v":15840,"d":"$15,840.00"}},null,0,0,40,40,40,40,40,40,0,0,40,40,40,40,40,40,0,0,40,40,40,40,40,40,0,0,0,0,null,0,0,880,880,880,880,880,880,0,0,880,880,880,880,880,880,0,0,880,880,880,880,880,880,0,0,0,0]
["Team 3","Night","Night","Night","Night",null,null,"Day","Day","Day","Day","Day","Day",null,null,"Swing","Swing","Swing","Swing","Swing","Swing",null,null,"Night","Night",{"$nulls":4},{"$f":"SUM(AG9:BH9)","v":{"v":720,"d":"720.0"}},{"$f":"SUM(BJ9:CK9)","v":{"v":19440,"d":"$19,440.00"}},null,40,40,40,40,0,0,40,40,40,40,40,40,0,0,40,40,40,40,40,40,0,0,40,40,0,0,0,0,null,1080,1080,1080,1080,0,0,1080,1080,1080,1080,1080,1080,0,0,1080,1080,1080,1080,1080,1080,0,0,1080,1080,0,0,0,0]
["Team 4","Swing","Swing",null,null,"Night","Night","Night","Night","Night","Night",null,null,"Day","Day","Day","Day","Day","Day",null,null,"Swing","Swing","Swing","Swing",{"$nulls":4},{"$f":"SUM(AG10:BH10)","v":{"v":720,"d":"720.0"}},{"$f":"SUM(BJ10:CK10)","v":{"v":23040,"d":"$23,040.00"}},null,40,40,0,0,40,40,40,40,40,40,0,0,40,40,40,40,40,40,0,0,40,40,40,40,0,0,0,0,null,1280,1280,0,0,1280,1280,1280,1280,1280,1280,0,0,1280,1280,1280,1280,1280,1280,0,0,1280,1280,1280,1280,0,0,0,0]
[{"$nulls":29},{"$f":"SUM(AG11:BD11)","v":{"v":0,"d":"0.0"}},{"$f":"SUM(BJ11:CG11)","v":{"v":0,"d":"$0.00"}},null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":29},{"v":0,"d":"0.0"},{"v":0,"d":"$0.00"},null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":29},{"v":0,"d":"0.0"},{"v":0,"d":"$0.00"},null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":29},{"v":0,"d":"0.0"},{"v":0,"d":"$0.00"},null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":29},{"v":0,"d":"0.0"},{"v":0,"d":"$0.00"},null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":29},{"v":0,"d":"0.0"},{"v":0,"d":"$0.00"},null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":29},{"v":0,"d":"0.0"},{"v":0,"d":"$0.00"},null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":29},{"v":0,"d":"0.0"},{"v":0,"d":"$0.00"},null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":29},{"v":0,"d":"0.0"},{"v":0,"d":"$0.00"},null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":29},{"v":0,"d":"0.0"},{"v":0,"d":"$0.00"},null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":29},{"v":0,"d":"0.0"},{"v":0,"d":"$0.00"},null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":29},{"v":0,"d":"0.0"},{"v":0,"d":"$0.00"},null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":29},{"v":0,"d":"0.0"},{"v":0,"d":"$0.00"},null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":29},{"v":0,"d":"0.0"},{"v":0,"d":"$0.00"},null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":29},{"v":0,"d":"0.0"},{"v":0,"d":"$0.00"},null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":29},{"v":0,"d":"0.0"},{"v":0,"d":"$0.00"},null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Total Paid Hours",{"$f":"SUM(AG7:AG26)","v":{"v":120,"d":"120.0"}},{"v":120,"d":"120.0"},{"v":120,"d":"120.0"},{"v":120,"d":"120.0"},{"v":120,"d":"120.0"},{"v":120,"d":"120.0"},{"v":120,"d":"120.0"},{"v":120,"d":"120.0"},{"v":120,"d":"120.0"},{"v":120,"d":"120.0"},{"v":120,"d":"120.0"},{"v":120,"d":"120.0"},{"v":120,"d":"120.0"},{"v":120,"d":"120.0"},{"v":120,"d":"120.0"},{"v":120,"d":"120.0"},{"v":120,"d":"120.0"},{"v":120,"d":"120.0"},{"v":120,"d":"120.0"},{"v":120,"d":"120.0"},{"v":120,"d":"120.0"},{"v":120,"d":"120.0"},{"v":120,"d":"120.0"},{"v":120,"d":"120.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"$f":"SUM(AD7:AD26)","v":{"v":2880,"d":"2,880.0"}}]
["Daily Labor Cost",{"$f":"SUM(BJ7:BJ26)","v":{"v":3040,"d":"$3,040.00"}},{"v":3040,"d":"$3,040.00"},{"v":2640,"d":"$2,640.00"},{"v":2640,"d":"$2,640.00"},{"v":2840,"d":"$2,840.00"},{"v":2840,"d":"$2,840.00"},{"v":3240,"d":"$3,240.00"},{"v":3240,"d":"$3,240.00"},{"v":3040,"d":"$3,040.00"},{"v":3040,"d":"$3,040.00"},{"v":2640,"d":"$2,640.00"},{"v":2640,"d":"$2,640.00"},{"v":2840,"d":"$2,840.00"},{"v":2840,"d":"$2,840.00"},{"v":3240,"d":"$3,240.00"},{"v":3240,"d":"$3,240.00"},{"v":3040,"d":"$3,040.00"},{"v":3040,"d":"$3,040.00"},{"v":2640,"d":"$2,640.00"},{"v":2640,"d":"$2,640.00"},{"v":2840,"d":"$2,840.00"},{"v":2840,"d":"$2,840.00"},{"v":3240,"d":"$3,240.00"},{"v":3240,"d":"$3,240.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},null,{"$f":"SUM(AE7:AE26)","v":{"v":70560,"d":"$70,560.00"}}]
[]
[]
["Notes: "]
["1) This worksheet is protected to prevent accidental deletion of the underlying formulas in summary cells. The password used is \"password\""]
["2) Do not change the shift patterns as they are required to implement the work schedule.  Use the Teams worksheet to assign employees to teams."]
[]
[]
[]
[{"$nulls":6}," "]

{"sheet":"Shifts","index":1,"n_rows":9,"n_cols":4,"rows_kept":9}
[]
["Shift","Starts","Ends","Paid Hrs"]
["Day","7:00AM","3:00PM",8]
["Swing","3:00PM","11:00PM",8]
["Night","11:00PM","7:00AM",8]
[]
[]
["Notes:"]
["   1) Change shift start times, end times, and payable work hours as needed to match your operations. "]

{"sheet":"Employees","index":2,"n_rows":25,"n_cols":2,"rows_kept":25}
[]
["Employee","Hourly Rate"]
["Employee 1",{"v":15,"d":"$15.00"}]
["Employee 2",{"v":16,"d":"$16.00"}]
["Employee 3",{"v":17,"d":"$17.00"}]
["Employee 4",{"v":18,"d":"$18.00"}]
["Employee 5",{"v":19,"d":"$19.00"}]
["Employee 6",{"v":20,"d":"$20.00"}]
["Employee 7",{"v":21,"d":"$21.00"}]
["Employee 8",{"v":22,"d":"$22.00"}]
["Employee 9",{"v":23,"d":"$23.00"}]
["Employee 10",{"v":24,"d":"$24.00"}]
["Employee 11",{"v":25,"d":"$25.00"}]
["Employee 12",{"v":26,"d":"$26.00"}]
["Employee 13",{"v":27,"d":"$27.00"}]
["Employee 14",{"v":28,"d":"$28.00"}]
["Employee 15",{"v":29,"d":"$29.00"}]
["Employee 16",{"v":30,"d":"$30.00"}]
["Employee 17",{"v":31,"d":"$31.00"}]
["Employee 18",{"v":32,"d":"$32.00"}]
["Employee 19",{"v":33,"d":"$33.00"}]
["Employee 20",{"v":34,"d":"$34.00"}]
[]
["Notes: "]
["   1) Change employee names and hourly rates as needed to reflect your actual data. A maximum of 20 employees is allowed."]

{"sheet":"Teams","index":3,"n_rows":29,"n_cols":10,"rows_kept":29,"merged":[[28,0,28,13]]}
[]
["Position","Team 1","Team 2","Team 3","Team 4",null,"Hourly Rate A","Hourly Rate B","Hourly Rate C","Hourly Rate D"]
["Sum",{"$f":"SUM(G6:G25)","v":{"v":85,"d":"$85.00"}},{"$f":"SUM(H6:H25)","v":{"v":110,"d":"$110.00"}},{"$f":"SUM(I6:I25)","v":{"v":135,"d":"$135.00"}},{"$f":"SUM(J6:J25)","v":{"v":160,"d":"$160.00"}}]
["Count",{"$f":"COUNTA(B6:B25)","v":5},{"$f":"COUNTA(C6:C25)","v":5},{"$f":"COUNTA(D6:D25)","v":5},{"$f":"COUNTA(E6:E25)","v":5}]
["Avg",{"$f":"IF(B4=0,0,B3/B4)","v":{"v":17,"d":"$17.00"}},{"$f":"IF(C4=0,0,C3/C4)","v":{"v":22,"d":"$22.00"}},{"$f":"IF(D4=0,0,D3/D4)","v":{"v":27,"d":"$27.00"}},{"$f":"IF(E4=0,0,E3/E4)","v":{"v":32,"d":"$32.00"}}]
[1,"Employee 1","Employee 6","Employee 11","Employee 16",null,{"$f":"IF(B6=\"\", 0, VLOOKUP(B6,Employees,2,FALSE))","v":{"v":15,"d":"$15.00"}},{"$f":"IF(C6=\"\", 0, VLOOKUP(C6,Employees,2,FALSE))","v":{"v":20,"d":"$20.00"}},{"$f":"IF(D6=\"\", 0, VLOOKUP(D6,Employees,2,FALSE))","v":{"v":25,"d":"$25.00"}},{"$f":"IF(E6=\"\", 0, VLOOKUP(E6,Employees,2,FALSE))","v":{"v":30,"d":"$30.00"}}]
[2,"Employee 2","Employee 7","Employee 12","Employee 17",null,{"v":16,"d":"$16.00"},{"v":21,"d":"$21.00"},{"v":26,"d":"$26.00"},{"v":31,"d":"$31.00"}]
[3,"Employee 3","Employee 8","Employee 13","Employee 18",null,{"v":17,"d":"$17.00"},{"v":22,"d":"$22.00"},{"v":27,"d":"$27.00"},{"v":32,"d":"$32.00"}]
[4,"Employee 4","Employee 9","Employee 14","Employee 19",null,{"v":18,"d":"$18.00"},{"v":23,"d":"$23.00"},{"v":28,"d":"$28.00"},{"v":33,"d":"$33.00"}]
[5,"Employee 5","Employee 10","Employee 15","Employee 20",null,{"v":19,"d":"$19.00"},{"v":24,"d":"$24.00"},{"v":29,"d":"$29.00"},{"v":34,"d":"$34.00"}]
[6,{"$nulls":5},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"}]
[7,{"$nulls":5},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"}]
[8,{"$nulls":5},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"}]
[9,{"$nulls":5},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"}]
[10,{"$nulls":5},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"}]
[11,{"$nulls":5},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"}]
[12,{"$nulls":5},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"}]
[13,{"$nulls":5},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"}]
[14,{"$nulls":5},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"}]
[15,{"$nulls":5},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"}]
[16,{"$nulls":5},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"}]
[17,{"$nulls":5},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"}]
[18,{"$nulls":5},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"}]
[19,{"$nulls":5},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"}]
[20,{"$nulls":5},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"}]
[]
[]
["Notes: "]
["1) Change or delete the employee assignments under each team as needed to reflect your actual data.  You should have an equal number of employees under each team to provide a balanced coverage.  Up to 5 employees are allowed in each team."]

{"sheet":"Additional Info","index":4,"n_rows":2,"n_cols":1,"rows_kept":2,"merged":[[0,0,0,12],[1,0,1,12],[2,0,2,15]]}
["This is a simple employee scheduling template for the 6 On 2 Off rotating shift schedule. Work hours and labor costs are automatically computed based on the prescribed shift patterns, the number of employees on each team, and labor rates. \n"]
["The 6 On 2 off rotating shift schedule is a relatively slow rotating schedule that uses 4 teams and three 8-hr shifts to provide 24/7 coverage. Each team rotates through the following sequence every 24 days: 6 day shifts, 2 days off, 6 swing shifts, 2 days off, 6 night shifts, 2 days off.\n"]