{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Schedule","Shifts","Employees"],"not_rendered":{"defined_names":5},"read":"whole","date_system":"1900"}

{"sheet":"Schedule","index":0,"n_rows":33,"n_cols":26,"rows_kept":33,"merged":[[0,0,0,9],[2,1,2,2],[31,0,31,9],[32,0,32,9]]}
["Employee Work Schedule (9 to 5  workday) \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","Paid","Total",null,"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"]
["Employee",{"$f":"B3","v":"2010-01-04"},"2010-01-05","2010-01-06","2010-01-07","2010-01-08","2010-01-09","2010-01-10","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",null,{"$f":"L6","v":"2010-01-04"},"2010-01-05","2010-01-06","2010-01-07","2010-01-08","2010-01-09","2010-01-10"]
["Employee 1","Full Day","Full Day","Half Day (AM)","Full Day","Full Day",null,null,{"$f":"SUM(L7:R7)","v":{"v":36,"d":"36.0"}},{"$f":"SUM(T7:Z7)","v":{"v":540,"d":"$540.00"}},null,{"$f":"IF(B7=\"\",0,VLOOKUP(B7, Shifts, 4,FALSE))","v":8},{"$f":"IF(C7=\"\",0,VLOOKUP(C7, Shifts, 4,FALSE))","v":8},{"$f":"IF(D7=\"\",0,VLOOKUP(D7, Shifts, 4,FALSE))","v":4},{"$f":"IF(E7=\"\",0,VLOOKUP(E7, Shifts, 4,FALSE))","v":8},{"$f":"IF(F7=\"\",0,VLOOKUP(F7, Shifts, 4,FALSE))","v":8},{"$f":"IF(G7=\"\",0,VLOOKUP(G7, Shifts, 4,FALSE))","v":0},{"$f":"IF(H7=\"\",0,VLOOKUP(H7, Shifts, 4,FALSE ))","v":0},null,{"$f":"L7*IF(A7=\"\", 0, VLOOKUP(A7,Employees,2,FALSE))","v":120},{"$f":"M7*IF(A7=\"\", 0, VLOOKUP(A7,Employees,2,FALSE ))","v":120},{"$f":"N7*IF(A7=\"\", 0, VLOOKUP(A7,Employees,2,FALSE))","v":60},{"$f":"O7*IF(A7=\"\", 0, VLOOKUP(A7,Employees,2,FALSE))","v":120},{"$f":"P7*IF(A7=\"\", 0, VLOOKUP(A7,Employees,2, FALSE))","v":120},{"$f":"Q7*IF(A7=\"\", 0, VLOOKUP(A7,Employees,2, FALSE))","v":0},{"$f":"R7*IF(A7=\"\", 0, VLOOKUP(A7,Employees,2, FALSE))","v":0}]
["Employee 2","Full Day","Full Day","Half Day (PM)","Full Day","Full Day",null,null,{"$f":"SUM(L8:R8)","v":{"v":36,"d":"36.0"}},{"$f":"SUM(T8:Z8)","v":{"v":576,"d":"$576.00"}},null,8,8,4,8,8,0,0,null,128,128,64,128,128,0,0]
["Employee 3","Med. Leave (P)","Med. Leave (U)","Med. Leave (P)","Vacation (P)","Vacation (P)",null,null,{"v":32,"d":"32.0"},{"v":544,"d":"$544.00"},null,8,0,8,8,8,0,0,null,136,0,136,136,136,0,0]
[{"$nulls":8},{"v":0,"d":"0.0"},{"v":0,"d":"$0.00"},null,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0]
[{"$nulls":8},{"v":0,"d":"0.0"},{"v":0,"d":"$0.00"},null,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0]
[{"$nulls":8},{"v":0,"d":"0.0"},{"v":0,"d":"$0.00"},null,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0]
[{"$nulls":8},{"v":0,"d":"0.0"},{"v":0,"d":"$0.00"},null,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0]
[{"$nulls":8},{"v":0,"d":"0.0"},{"v":0,"d":"$0.00"},null,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0]
[{"$nulls":8},{"v":0,"d":"0.0"},{"v":0,"d":"$0.00"},null,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0]
[{"$nulls":8},{"v":0,"d":"0.0"},{"v":0,"d":"$0.00"},null,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0]
[{"$nulls":8},{"v":0,"d":"0.0"},{"v":0,"d":"$0.00"},null,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0]
[{"$nulls":8},{"v":0,"d":"0.0"},{"v":0,"d":"$0.00"},null,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0]
[{"$nulls":8},{"v":0,"d":"0.0"},{"v":0,"d":"$0.00"},null,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0]
[{"$nulls":8},{"v":0,"d":"0.0"},{"v":0,"d":"$0.00"},null,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0]
[{"$nulls":8},{"v":0,"d":"0.0"},{"v":0,"d":"$0.00"},null,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0]
[{"$nulls":8},{"v":0,"d":"0.0"},{"v":0,"d":"$0.00"},null,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0]
[{"$nulls":8},{"v":0,"d":"0.0"},{"v":0,"d":"$0.00"},null,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0]
[{"$nulls":8},{"v":0,"d":"0.0"},{"v":0,"d":"$0.00"},null,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0]
[{"$nulls":8},{"v":0,"d":"0.0"},{"v":0,"d":"$0.00"},null,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0]
[{"$nulls":8},{"v":0,"d":"0.0"},{"v":0,"d":"$0.00"},null,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0]
["Total Paid Hours",{"$f":"SUM(L7:L26)","v":{"v":24,"d":"24.0"}},{"$f":"SUM(M7:M26)","v":{"v":16,"d":"16.0"}},{"$f":"SUM(N7:N26)","v":{"v":16,"d":"16.0"}},{"$f":"SUM(O7:O26)","v":{"v":24,"d":"24.0"}},{"$f":"SUM(P7:P26)","v":{"v":24,"d":"24.0"}},{"$f":"SUM(Q7:Q26)","v":{"v":0,"d":"0.0"}},{"v":0,"d":"0.0"},{"$f":"SUM(I7:I26)","v":{"v":104,"d":"104.0"}}]
["Daily Labor Cost",{"$f":"SUM(T7:T26)","v":{"v":384,"d":"$384.00"}},{"$f":"SUM(U7:U26)","v":{"v":248,"d":"$248.00"}},{"$f":"SUM(V7:V26)","v":{"v":260,"d":"$260.00"}},{"$f":"SUM(W7:W26)","v":{"v":384,"d":"$384.00"}},{"$f":"SUM(X7:X26)","v":{"v":384,"d":"$384.00"}},{"$f":"SUM(Y7:Y26)","v":{"v":0,"d":"$0.00"}},{"v":0,"d":"$0.00"},null,{"$f":"SUM(B28:H28)","v":{"v":1660,"d":"$1,660.00"}}]
[]
[]
["Notes: "]
["1) This template worksheet is protected to prevent accidental deletion of the underlying formulas. The password used is \"password\""]
["2) Using this workbook, you can create a weekly work schedule for up to 20 employees and 9 shifts.  Employee names and labor rates are defined in the Employees worksheet. Shifts and shift durations are defined in the Shifts worksheet.  To assign a shift to an employee, click on the corresponding schedule cell and pick a shift from the drop-down list.  Work hours and labor costs are automatically computed based on shift assignments and labor rates.  If your scheduling needs are more than just creating a weekly work schedule, you should use a scheduling program like Snap Schedule (http://www.BMScentral.com)."]

{"sheet":"Shifts","index":1,"n_rows":16,"n_cols":4,"rows_kept":16}
[]
["Shift Description","Starts","Ends","Paid Hrs"]
["Full Day","9:00AM","5:00PM",8]
["Half Day (AM)","9:00AM","1:00PM",4]
["Half Day (PM)","1:00PM","5:00AM",4]
["Vacation (P)","9:00AM","5:00PM",8]
["Vacation (U)","9:00AM","5:00PM",0]
["Med. Leave (P)","9:00AM","5:00PM",8]
["Med. Leave (U)","9:00AM","5:00PM",0]
["Spare 1","9:00AM","5:00PM",0]
["Spare 2","9:00AM","5:00PM",0]
[]
[]
["Notes:"]
["   1) Change shift description, start times, end times, and payable work hours as needed to match your operations. "]
["   2) If you change the shift description or colors, you must manually update the affected shift assignments in the Schedule worksheet"]

{"sheet":"Employees","index":2,"n_rows":25,"n_cols":2,"rows_kept":25}
[]
["Employee Name","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."]