{"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]]}
["5/4-9 Compressed Work Schedule\n[Company Name]\n"]
[]
["Period Start Date :","2010-03-29",{"$nulls":3}," (Must begin on a Monday)"]
[]
[null,{"$f":"B3","v":"2010-03-29"},{"$f":"B5+1","v":"2010-03-30"},"2010-03-31","2010-04-01","2010-04-02","2010-04-03","2010-04-04","2010-04-05","2010-04-06","2010-04-07","2010-04-08","2010-04-09","2010-04-10","2010-04-11","2010-04-12","2010-04-13","2010-04-14","2010-04-15","2010-04-16","2010-04-17","2010-04-18","2010-04-19","2010-04-20","2010-04-21","2010-04-22","2010-04-23","2010-04-24","2010-04-25","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-03-29"},"2010-03-30","2010-03-31","2010-04-01","2010-04-02","2010-04-03","2010-04-04","2010-04-05","2010-04-06","2010-04-07","2010-04-08","2010-04-09","2010-04-10","2010-04-11","2010-04-12","2010-04-13","2010-04-14","2010-04-15","2010-04-16","2010-04-17","2010-04-18","2010-04-19","2010-04-20","2010-04-21","2010-04-22","2010-04-23","2010-04-24","2010-04-25","Hours","Labor Cost",null,{"$f":"B6","v":"2010-03-29"},"2010-03-30","2010-03-31","2010-04-01","2010-04-02","2010-04-03","2010-04-04","2010-04-05","2010-04-06","2010-04-07","2010-04-08","2010-04-09","2010-04-10","2010-04-11","2010-04-12","2010-04-13","2010-04-14","2010-04-15","2010-04-16","2010-04-17","2010-04-18","2010-04-19","2010-04-20","2010-04-21","2010-04-22","2010-04-23","2010-04-24","2010-04-25",null,{"$f":"AG6","v":"2010-03-29"},"2010-03-30","2010-03-31","2010-04-01","2010-04-02","2010-04-03","2010-04-04","2010-04-05","2010-04-06","2010-04-07","2010-04-08","2010-04-09","2010-04-10","2010-04-11","2010-04-12","2010-04-13","2010-04-14","2010-04-15","2010-04-16","2010-04-17","2010-04-18","2010-04-19","2010-04-20","2010-04-21","2010-04-22","2010-04-23","2010-04-24","2010-04-25"]
["Team 1","Shift B ","Shift B ","Shift B ","Shift B ","Shift A ",{"$nulls":3},"Shift B ","Shift B ","Shift B ","Shift B ",{"$nulls":3},"Shift B ","Shift B ","Shift B ","Shift B ",null,null,"Shift B ","Shift B ","Shift B ","Shift B ","Shift A ",null,null,{"$f":"SUM(AG7:BH7)","v":{"v":1600,"d":"1600.0"}},{"$f":"SUM(BJ7:CK7)","v":{"v":31200,"d":"$31,200.00"}},null,{"$f":"IF(B7=\"\",0,VLOOKUP(B7, Shifts, 4,FALSE)*HLOOKUP(A7,Teams,3,FALSE))","v":90},{"$f":"IF(C7=\"\",0,VLOOKUP(C7, Shifts, 4,FALSE)*HLOOKUP(A7,Teams,3,FALSE))","v":90},{"$f":"IF(D7=\"\",0,VLOOKUP(D7, Shifts, 4,FALSE)*HLOOKUP(A7,Teams,3,FALSE))","v":90},{"$f":"IF(E7=\"\",0,VLOOKUP(E7, Shifts, 4,FALSE)*HLOOKUP(A7,Teams,3,FALSE))","v":90},{"$f":"IF(F7=\"\",0,VLOOKUP(F7, Shifts, 4,FALSE)*HLOOKUP(A7,Teams,3,FALSE))","v":80},{"$f":"IF(G7=\"\",0,VLOOKUP(G7, Shifts, 4,FALSE)*HLOOKUP(A7,Teams,3,FALSE))","v":0},{"$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":90},{"$f":"IF(K7=\"\",0,VLOOKUP(K7, Shifts, 4,FALSE)*HLOOKUP(A7,Teams,3,FALSE))","v":90},{"$f":"IF(L7=\"\",0,VLOOKUP(L7, Shifts, 4,FALSE)*HLOOKUP(A7,Teams,3,FALSE))","v":90},{"$f":"IF(M7=\"\",0,VLOOKUP(M7, Shifts, 4,FALSE)*HLOOKUP(A7,Teams,3,FALSE))","v":90},{"$f":"IF(N7=\"\",0,VLOOKUP(N7, Shifts, 4,FALSE)*HLOOKUP(A7,Teams,3,FALSE))","v":0},{"$f":"IF(O7=\"\",0,VLOOKUP(O7, Shifts, 4,FALSE)*HLOOKUP(A7,Teams,3,FALSE))","v":0},{"$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":90},{"$f":"IF(R7=\"\",0,VLOOKUP(R7, Shifts, 4,FALSE)*HLOOKUP(A7,Teams,3,FALSE))","v":90},{"$f":"IF(S7=\"\",0,VLOOKUP(S7, Shifts, 4,FALSE)*HLOOKUP(A7,Teams,3,FALSE))","v":90},{"$f":"IF(T7=\"\",0,VLOOKUP(T7, Shifts, 4,FALSE)*HLOOKUP(A7,Teams,3,FALSE))","v":90},{"$f":"IF(U7=\"\",0,VLOOKUP(U7, Shifts, 4,FALSE)*HLOOKUP(A7,Teams,3,FALSE))","v":0},{"$f":"IF(V7=\"\",0,VLOOKUP(V7, Shifts, 4,FALSE)*HLOOKUP(A7,Teams,3,FALSE))","v":0},{"$f":"IF(W7=\"\",0,VLOOKUP(W7, Shifts, 4,FALSE)*HLOOKUP(A7,Teams,3,FALSE))","v":90},{"$f":"IF(X7=\"\",0,VLOOKUP(X7, Shifts, 4,FALSE)*HLOOKUP(A7,Teams,3,FALSE))","v":90},{"$f":"IF(Y7=\"\",0,VLOOKUP(Y7, Shifts, 4,FALSE)*HLOOKUP(A7,Teams,3,FALSE))","v":90},{"$f":"IF(Z7=\"\",0,VLOOKUP(Z7, Shifts, 4,FALSE)*HLOOKUP(A7,Teams,3,FALSE))","v":90},{"$f":"IF(AA7=\"\",0,VLOOKUP(AA7, Shifts, 4,FALSE)*HLOOKUP(A7,Teams,3,FALSE))","v":80},{"$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":1755},{"$f":"AH7*IF(C7=\"\", 0, HLOOKUP(A7,Teams,4,FALSE))","v":1755},{"$f":"AI7*IF(D7=\"\", 0, HLOOKUP(A7,Teams,4,FALSE))","v":1755},{"$f":"AJ7*IF(E7=\"\", 0, HLOOKUP(A7,Teams,4,FALSE))","v":1755},{"$f":"AK7*IF(F7=\"\", 0, HLOOKUP(A7,Teams,4,FALSE))","v":1560},{"$f":"AL7*IF(G7=\"\", 0, HLOOKUP(A7,Teams,4,FALSE))","v":0},{"$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":1755},{"$f":"AP7*IF(K7=\"\", 0, HLOOKUP(A7,Teams,4,FALSE))","v":1755},{"$f":"AQ7*IF(L7=\"\", 0, HLOOKUP(A7,Teams,4,FALSE))","v":1755},{"$f":"AR7*IF(M7=\"\", 0, HLOOKUP(A7,Teams,4,FALSE))","v":1755},{"$f":"AS7*IF(N7=\"\", 0, HLOOKUP(A7,Teams,4,FALSE))","v":0},{"$f":"AT7*IF(O7=\"\", 0, HLOOKUP(A7,Teams,4,FALSE))","v":0},{"$f":"AU7*IF(P7=\"\", 0, HLOOKUP(A7,Teams,4,FALSE))","v":0},{"$f":"AV7*IF(Q7=\"\", 0, HLOOKUP(A7,Teams,4,FALSE))","v":1755},{"$f":"AW7*IF(R7=\"\", 0, HLOOKUP(A7,Teams,4,FALSE))","v":1755},{"$f":"AX7*IF(S7=\"\", 0, HLOOKUP(A7,Teams,4,FALSE))","v":1755},{"$f":"AY7*IF(T7=\"\", 0, HLOOKUP(A7,Teams,4,FALSE))","v":1755},{"$f":"AZ7*IF(U7=\"\", 0, HLOOKUP(A7,Teams,4,FALSE))","v":0},{"$f":"BA7*IF(V7=\"\", 0, HLOOKUP(A7,Teams,4,FALSE))","v":0},{"$f":"BB7*IF(W7=\"\", 0, HLOOKUP(A7,Teams,4,FALSE))","v":1755},{"$f":"BC7*IF(X7=\"\", 0, HLOOKUP(A7,Teams,4,FALSE))","v":1755},{"$f":"BD7*IF(Y7=\"\", 0, HLOOKUP(A7,Teams,4,FALSE))","v":1755},{"$f":"BE7*IF(Z7=\"\", 0, HLOOKUP(A7,Teams,4,FALSE))","v":1755},{"$f":"BF7*IF(AA7=\"\", 0, HLOOKUP(A7,Teams,4,FALSE))","v":1560},{"$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,"Shift B ","Shift B ","Shift B ","Shift B ",null,null,"Shift B ","Shift B ","Shift B ","Shift B ","Shift A ",null,null,"Shift B ","Shift B ","Shift B ","Shift B ","Shift A ",{"$nulls":3},"Shift B ","Shift B ","Shift B ","Shift B ",null,null,{"$f":"SUM(AG8:BH8)","v":{"v":1600,"d":"1600.0"}},{"$f":"SUM(BJ8:CK8)","v":{"v":47200,"d":"$47,200.00"}},null,0,{"$f":"IF(C8=\"\",0,VLOOKUP(C8, Shifts, 4,FALSE)*HLOOKUP(A8,Teams,3,FALSE))","v":90},{"$f":"IF(D8=\"\",0,VLOOKUP(D8, Shifts, 4,FALSE)*HLOOKUP(A8,Teams,3,FALSE))","v":90},90,90,0,0,90,90,90,90,80,0,0,90,90,90,90,80,0,0,0,90,90,90,90,0,0,null,0,{"$f":"AH8*IF(C8=\"\", 0, HLOOKUP(A8,Teams,4,FALSE))","v":2655},{"$f":"AI8*IF(D8=\"\", 0, HLOOKUP(A8,Teams,4,FALSE))","v":2655},2655,2655,0,0,2655,2655,2655,2655,2360,0,0,2655,2655,2655,2655,2360,0,0,0,2655,2655,2655,2655,0,0]
["Team 3",{"$nulls":28},{"$f":"SUM(AG9:BH9)","v":{"v":0,"d":"0.0"}},{"$f":"SUM(BJ9:CK9)","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]
["Team 4",{"$nulls":28},{"$f":"SUM(AG10:BH10)","v":{"v":0,"d":"0.0"}},{"$f":"SUM(BJ10:CK10)","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},{"$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":90,"d":"90.0"}},{"v":180,"d":"180.0"},{"$f":"SUM(AI7:AI26)","v":{"v":180,"d":"180.0"}},{"v":180,"d":"180.0"},{"v":170,"d":"170.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":90,"d":"90.0"},{"v":180,"d":"180.0"},{"v":180,"d":"180.0"},{"v":180,"d":"180.0"},{"v":170,"d":"170.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":90,"d":"90.0"},{"$f":"SUM(AV7:AV26)","v":{"v":180,"d":"180.0"}},{"v":180,"d":"180.0"},{"v":180,"d":"180.0"},{"v":170,"d":"170.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":90,"d":"90.0"},{"v":180,"d":"180.0"},{"v":180,"d":"180.0"},{"v":180,"d":"180.0"},{"v":170,"d":"170.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"$f":"SUM(AD7:AD26)","v":{"v":3200,"d":"3,200.0"}}]
["Daily Labor Cost",{"$f":"SUM(BJ7:BJ26)","v":{"v":1755,"d":"$1,755.00"}},{"v":4410,"d":"$4,410.00"},{"v":4410,"d":"$4,410.00"},{"$f":"SUM(BM7:BM26)","v":{"v":4410,"d":"$4,410.00"}},{"v":4215,"d":"$4,215.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":2655,"d":"$2,655.00"},{"v":4410,"d":"$4,410.00"},{"v":4410,"d":"$4,410.00"},{"v":4410,"d":"$4,410.00"},{"v":4115,"d":"$4,115.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":2655,"d":"$2,655.00"},{"v":4410,"d":"$4,410.00"},{"v":4410,"d":"$4,410.00"},{"v":4410,"d":"$4,410.00"},{"v":4115,"d":"$4,115.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":1755,"d":"$1,755.00"},{"v":4410,"d":"$4,410.00"},{"v":4410,"d":"$4,410.00"},{"v":4410,"d":"$4,410.00"},{"v":4215,"d":"$4,215.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},null,{"$f":"SUM(AE7:AE26)","v":{"v":78400,"d":"$78,400.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":8,"n_cols":4,"rows_kept":8}
[]
["Shift","Starts","Ends","Paid Hrs"]
["Shift A ","7:00AM","3:00PM",8]
["Shift B ","7:00AM","4:00PM",9]
[]
[]
["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":8,"rows_kept":29,"merged":[[28,0,28,13]]}
[]
["Position","Team 1","Team 2",null,"Hourly Rate A","Hourly Rate B","Hourly Rate C","Hourly Rate D"]
["Sum",{"$f":"SUM(E6:E25)","v":{"v":195,"d":"$195.00"}},{"$f":"SUM(F6:F25)","v":{"v":295,"d":"$295.00"}}]
["Count",{"$f":"COUNTA(B6:B25)","v":10},{"$f":"COUNTA(C6:C25)","v":10}]
["Avg",{"$f":"IF(B4=0,0,B3/B4)","v":{"v":19.5,"d":"$19.50"}},{"$f":"IF(C4=0,0,C3/C4)","v":{"v":29.5,"d":"$29.50"}}]
[1,"Employee 1","Employee 11",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":25,"d":"$25.00"}},{"$f":"IF(#REF!=\"\", 0, VLOOKUP(#REF!,Employees,2,FALSE))","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"\", 0, VLOOKUP(#REF!,Employees,2,FALSE))","v":{"$error":"#REF!"}}]
[2,"Employee 2","Employee 12",null,{"v":16,"d":"$16.00"},{"v":26,"d":"$26.00"},{"$f":"IF(#REF!=\"\", 0, VLOOKUP(#REF!,Employees,2,FALSE))","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"\", 0, VLOOKUP(#REF!,Employees,2,FALSE))","v":{"$error":"#REF!"}}]
[3,"Employee 3","Employee 13",null,{"v":17,"d":"$17.00"},{"v":27,"d":"$27.00"},{"$f":"IF(#REF!=\"\", 0, VLOOKUP(#REF!,Employees,2,FALSE))","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"\", 0, VLOOKUP(#REF!,Employees,2,FALSE))","v":{"$error":"#REF!"}}]
[4,"Employee 4","Employee 14",null,{"v":18,"d":"$18.00"},{"v":28,"d":"$28.00"},{"$f":"IF(#REF!=\"\", 0, VLOOKUP(#REF!,Employees,2,FALSE))","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"\", 0, VLOOKUP(#REF!,Employees,2,FALSE))","v":{"$error":"#REF!"}}]
[5,"Employee 5","Employee 15",null,{"v":19,"d":"$19.00"},{"v":29,"d":"$29.00"},{"$f":"IF(#REF!=\"\", 0, VLOOKUP(#REF!,Employees,2,FALSE))","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"\", 0, VLOOKUP(#REF!,Employees,2,FALSE))","v":{"$error":"#REF!"}}]
[6,"Employee 6","Employee 16",null,{"v":20,"d":"$20.00"},{"v":30,"d":"$30.00"},{"$f":"IF(#REF!=\"\", 0, VLOOKUP(#REF!,Employees,2,FALSE))","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"\", 0, VLOOKUP(#REF!,Employees,2,FALSE))","v":{"$error":"#REF!"}}]
[7,"Employee 7","Employee 17",null,{"v":21,"d":"$21.00"},{"v":31,"d":"$31.00"},{"$f":"IF(#REF!=\"\", 0, VLOOKUP(#REF!,Employees,2,FALSE))","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"\", 0, VLOOKUP(#REF!,Employees,2,FALSE))","v":{"$error":"#REF!"}}]
[8,"Employee 8","Employee 18",null,{"v":22,"d":"$22.00"},{"v":32,"d":"$32.00"},{"$f":"IF(#REF!=\"\", 0, VLOOKUP(#REF!,Employees,2,FALSE))","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"\", 0, VLOOKUP(#REF!,Employees,2,FALSE))","v":{"$error":"#REF!"}}]
[9,"Employee 9","Employee 19",null,{"v":23,"d":"$23.00"},{"v":33,"d":"$33.00"},{"$f":"IF(#REF!=\"\", 0, VLOOKUP(#REF!,Employees,2,FALSE))","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"\", 0, VLOOKUP(#REF!,Employees,2,FALSE))","v":{"$error":"#REF!"}}]
[10,"Employee 10","Employee 20",null,{"v":24,"d":"$24.00"},{"v":34,"d":"$34.00"},{"$f":"IF(#REF!=\"\", 0, VLOOKUP(#REF!,Employees,2,FALSE))","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"\", 0, VLOOKUP(#REF!,Employees,2,FALSE))","v":{"$error":"#REF!"}}]
[11,{"$nulls":3},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"$f":"IF(#REF!=\"\", 0, VLOOKUP(#REF!,Employees,2,FALSE))","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"\", 0, VLOOKUP(#REF!,Employees,2,FALSE))","v":{"$error":"#REF!"}}]
[12,{"$nulls":3},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"$f":"IF(#REF!=\"\", 0, VLOOKUP(#REF!,Employees,2,FALSE))","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"\", 0, VLOOKUP(#REF!,Employees,2,FALSE))","v":{"$error":"#REF!"}}]
[13,{"$nulls":3},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"$f":"IF(#REF!=\"\", 0, VLOOKUP(#REF!,Employees,2,FALSE))","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"\", 0, VLOOKUP(#REF!,Employees,2,FALSE))","v":{"$error":"#REF!"}}]
[14,{"$nulls":3},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"$f":"IF(#REF!=\"\", 0, VLOOKUP(#REF!,Employees,2,FALSE))","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"\", 0, VLOOKUP(#REF!,Employees,2,FALSE))","v":{"$error":"#REF!"}}]
[15,{"$nulls":3},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"$f":"IF(#REF!=\"\", 0, VLOOKUP(#REF!,Employees,2,FALSE))","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"\", 0, VLOOKUP(#REF!,Employees,2,FALSE))","v":{"$error":"#REF!"}}]
[16,{"$nulls":3},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"$f":"IF(#REF!=\"\", 0, VLOOKUP(#REF!,Employees,2,FALSE))","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"\", 0, VLOOKUP(#REF!,Employees,2,FALSE))","v":{"$error":"#REF!"}}]
[17,{"$nulls":3},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"$f":"IF(#REF!=\"\", 0, VLOOKUP(#REF!,Employees,2,FALSE))","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"\", 0, VLOOKUP(#REF!,Employees,2,FALSE))","v":{"$error":"#REF!"}}]
[18,{"$nulls":3},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"$f":"IF(#REF!=\"\", 0, VLOOKUP(#REF!,Employees,2,FALSE))","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"\", 0, VLOOKUP(#REF!,Employees,2,FALSE))","v":{"$error":"#REF!"}}]
[19,{"$nulls":3},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"$f":"IF(#REF!=\"\", 0, VLOOKUP(#REF!,Employees,2,FALSE))","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"\", 0, VLOOKUP(#REF!,Employees,2,FALSE))","v":{"$error":"#REF!"}}]
[20,{"$nulls":3},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"$f":"IF(#REF!=\"\", 0, VLOOKUP(#REF!,Employees,2,FALSE))","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"\", 0, VLOOKUP(#REF!,Employees,2,FALSE))","v":{"$error":"#REF!"}}]
[]
[]
["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 10 employees are allowed in each team."]

{"sheet":"Additional Info","index":4,"n_rows":3,"n_cols":1,"rows_kept":3,"merged":[[1,0,1,12],[2,0,2,12],[3,0,3,15]]}
[]
["This is a simple employee scheduling template for creating and printing 5/4-9 compressed work schedules. 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 5/4-9 work schedule, also known as the Flexible 5/4-9 Work Schedule, allows employees to fulfill their work requirement of 80 hours in a biweekly pay period over nine workdays (i.e., five days one week and four days the other week). For eight of the workdays, an employee works nine hours and for one workday, the employee works eight hours and has one regular day off each biweekly pay period. \n"]