{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Instructions","Penal Claim","PCHS","Overtime Claim","OTCHS","Additional Hours for Part Time ","AHPTHS","Version Control"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":false,"merged":[[6,0,88,13],[0,0,1,9],[2,0,5,13],[0,10,1,13]]}
["COVID-19 Bulk Timesheets - Instructions"]

{"sheet":"Penal Claim","index":1,"n_rows":49,"n_cols":16,"rows_kept":49,"cut":false,"hidden":false,"merged":[[42,0,43,1],[44,0,45,1],[46,0,47,1],[42,2,43,6],[42,7,43,7],[5,2,6,2],[5,0,6,0],[5,1,6,1],[5,15,6,15],[5,14,6,14],[5,9,6,9],[5,4,6,4],[5,10,6,12],[5,13,6,13],[6,5,6,8],[48,11,49,12],[48,13,49,13],[44,2,45,3],[44,4,45,4],[44,5,45,6],[44,7,45,7],[46,2,47,6],[46,7,47,7],[42,9,49,10],[44,11,45,12],[46,11,47,12],[42,13,43,13],[42,11,43,12],[44,13,45,13],[46,13,47,13]]}
[]
[]
["Penal Claim Sheet for multiple employees"]
["Only complete this timesheet if the employee(s) are eligible for penal payments on their ordinary rostered hours"]
["Employee Number","First Name","Last Name","Date","Day of the week","Start Time of Rostered shift","Break Time Start","Break Time End","End Time of Rostered shift","Total Rostered Hours","P.25","P.5","P 1","Manager Name","Comments","Auto Warnings"]
["Mandatory","Mandatory","Mandatory","Mandatory","Auto Calculated","Mandatory","Mandatory","Mandatory","Mandatory","Auto Calculated","Payroll Use Only",null,null,"Mandatory","Comments if required. If an employee took leave on a particular day, note it clearly in this column.","Auto Populates"]
[null,null,null,"Please enter in as dd/mm/yyyy",null,"Please use strict 24 hour time format. Use of any other time format will result in an error."]
[12345,"FirstName","LastName","2020-03-30",{"$f":"IF(D8=\"\",\"\",TEXT(D8,\"dddd\"))","v":"Monday"},"16:00:00","20:00:00","20:30:00","00:00:00",7.5,3.5,null,null,"Manager Full Name","Example Only"]
[23456,"SecondFirst","SecondLast","2020-04-03","Friday","14:00:00","18:00:00","18:30:00","22:00:00",7.5,2,null,null,"Manager Full Name","Example Only"]
[23456,"SecondFirst","SecondLast","2020-04-05","Sunday","14:00:00","18:00:00","18:30:00","22:00:00",7.5,2,null,7.5,"Manager Full Name","Example only - Sick leave"]
[null,null,null,null,"",null,null,null,null,{"$f":"PCHS!E4","v":0},null,null,null,null,null,{"$f":"IF(J11>10.5,\"Employee rostered shift cannot exceed 10.5 hours\",IF(J11<0,\"Employee rostered shift cannot be negative\",\"\"))","v":""}]
[null,null,null,null,"",null,null,null,null,{"$f":"PCHS!E5","v":0},null,null,null,null,null,{"$f":"IF(J12>10.5,\"Employee rostered shift cannot exceed 10.5 hours\",IF(J12<0,\"Employee rostered shift cannot be negative\",\"\"))","v":""}]
[null,null,null,null,"",null,null,null,null,{"$f":"PCHS!E6","v":0},null,null,null,null,null,""]
[null,null,null,null,"",null,null,null,null,{"$f":"PCHS!E7","v":0},null,null,null,null,null,""]
[null,null,null,null,"",null,null,null,null,{"$f":"PCHS!E8","v":0},null,null,null,null,null,""]
[null,null,null,null,"",null,null,null,null,{"$f":"PCHS!E9","v":0},null,null,null,null,null,""]
[null,null,null,null,"",null,null,null,null,{"$f":"PCHS!E10","v":0},null,null,null,null,null,""]
[null,null,null,null,"",null,null,null,null,{"$f":"PCHS!E11","v":0},null,null,null,null,null,""]
[null,null,null,null,"",null,null,null,null,{"$f":"PCHS!E12","v":0},null,null,null,null,null,""]
[null,null,null,null,"",null,null,null,null,{"$f":"PCHS!E13","v":0},null,null,null,null,null,""]
[null,null,null,null,"",null,null,null,null,{"$f":"PCHS!E14","v":0},null,null,null,null,null,""]
[null,null,null,null,"",null,null,null,null,{"$f":"PCHS!E15","v":0},null,null,null,null,null,""]
[null,null,null,null,"",null,null,null,null,{"$f":"PCHS!E16","v":0},null,null,null,null,null,""]
[null,null,null,null,"",null,null,null,null,{"$f":"PCHS!E17","v":0},null,null,null,null,null,""]
[null,null,null,null,"",null,null,null,null,{"$f":"PCHS!E18","v":0},null,null,null,null,null,""]
[null,null,null,null,"",null,null,null,null,{"$f":"PCHS!E19","v":0},null,null,null,null,null,""]
[null,null,null,null,"",null,null,null,null,{"$f":"PCHS!E20","v":0},null,null,null,null,null,""]
[null,null,null,null,"",null,null,null,null,{"$f":"PCHS!E21","v":0},null,null,null,null,null,""]
[null,null,null,null,"",null,null,null,null,{"$f":"PCHS!E22","v":0},null,null,null,null,null,""]
[null,null,null,null,"",null,null,null,null,{"$f":"PCHS!E23","v":0},null,null,null,null,null,""]
[null,null,null,null,"",null,null,null,null,{"$f":"PCHS!E24","v":0},null,null,null,null,null,""]
[null,null,null,null,"",null,null,null,null,{"$f":"PCHS!E25","v":0},null,null,null,null,null,""]
[null,null,null,null,"",null,null,null,null,{"$f":"PCHS!E26","v":0},null,null,null,null,null,""]
[null,null,null,null,"",null,null,null,null,{"$f":"PCHS!E27","v":0},null,null,null,null,null,""]
[null,null,null,null,"",null,null,null,null,{"$f":"PCHS!E28","v":0},null,null,null,null,null,""]
[null,null,null,null,"",null,null,null,null,{"$f":"PCHS!E29","v":0},null,null,null,null,null,""]
[null,null,null,null,"",null,null,null,null,{"$f":"PCHS!E30","v":0},null,null,null,null,null,""]
[null,null,null,null,"",null,null,null,null,{"$f":"PCHS!E31","v":0},null,null,null,null,null,""]
[null,null,null,null,"",null,null,null,null,{"$f":"PCHS!E32","v":0},null,null,null,null,null,""]
[null,null,null,null,"",null,null,null,null,{"$f":"PCHS!E33","v":0},null,null,null,null,null,""]
[null,null,null,null,"",null,null,null,null,{"$f":"PCHS!E34","v":0},null,null,null,null,null,""]
[]
["Prepared by:",null,null,null,null,null,null,{"$f":"IF(C43=\"\",\"Required\",\"\")","v":"Required"},null,"Payroll use only:",null,"Processed by"]
[]
["Approved by:",null,null,null,"Contact No:",null,null,{"$f":"IF(C45=\"\",\"Required\",IF(F45=\"\",\"Required\",\"\"))","v":"Required"},null,null,null,"Verified by"]
[]
["Date:",null,null,null,null,null,null,{"$f":"IF(C47=\"\",\"Required\",\"\")","v":"Required"},null,null,null,"Payslip checked by:"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Pay Period Ending:"]

{"sheet":"PCHS","index":2,"n_rows":33,"n_cols":5,"rows_kept":33,"cut":false,"hidden":true,"merged":[]}
["ST","ADJ","Break","ADJ","Total std"]
[]
[]
[{"$f":"('Penal Claim'!I11-'Penal Claim'!F11)*24","v":0},{"$f":"IF(A4<0,A4+24,A4)","v":0},{"$f":"('Penal Claim'!H11-'Penal Claim'!G11)*24","v":0},{"$f":"IF(C4<0,C4+24,C4)","v":0},{"$f":"B4-D4","v":0}]
[{"$f":"('Penal Claim'!I12-'Penal Claim'!F12)*24","v":0},{"$f":"IF(A5<0,A5+24,A5)","v":0},{"$f":"('Penal Claim'!H12-'Penal Claim'!G12)*24","v":0},{"$f":"IF(C5<0,C5+24,C5)","v":0},{"$f":"B5-D5","v":0}]
[{"$f":"('Penal Claim'!I13-'Penal Claim'!F13)*24","v":0},0,{"$f":"('Penal Claim'!H13-'Penal Claim'!G13)*24","v":0},0,0]
[{"$f":"('Penal Claim'!I14-'Penal Claim'!F14)*24","v":0},0,{"$f":"('Penal Claim'!H14-'Penal Claim'!G14)*24","v":0},0,0]
[{"$f":"('Penal Claim'!I15-'Penal Claim'!F15)*24","v":0},0,{"$f":"('Penal Claim'!H15-'Penal Claim'!G15)*24","v":0},0,0]
[{"$f":"('Penal Claim'!I16-'Penal Claim'!F16)*24","v":0},0,{"$f":"('Penal Claim'!H16-'Penal Claim'!G16)*24","v":0},0,0]
[{"$f":"('Penal Claim'!I17-'Penal Claim'!F17)*24","v":0},0,{"$f":"('Penal Claim'!H17-'Penal Claim'!G17)*24","v":0},0,0]
[{"$f":"('Penal Claim'!I18-'Penal Claim'!F18)*24","v":0},0,{"$f":"('Penal Claim'!H18-'Penal Claim'!G18)*24","v":0},0,0]
[{"$f":"('Penal Claim'!I19-'Penal Claim'!F19)*24","v":0},0,{"$f":"('Penal Claim'!H19-'Penal Claim'!G19)*24","v":0},0,0]
[{"$f":"('Penal Claim'!I20-'Penal Claim'!F20)*24","v":0},0,{"$f":"('Penal Claim'!H20-'Penal Claim'!G20)*24","v":0},0,0]
[{"$f":"('Penal Claim'!I21-'Penal Claim'!F21)*24","v":0},0,{"$f":"('Penal Claim'!H21-'Penal Claim'!G21)*24","v":0},0,0]
[{"$f":"('Penal Claim'!I22-'Penal Claim'!F22)*24","v":0},0,{"$f":"('Penal Claim'!H22-'Penal Claim'!G22)*24","v":0},0,0]
[{"$f":"('Penal Claim'!I23-'Penal Claim'!F23)*24","v":0},0,{"$f":"('Penal Claim'!H23-'Penal Claim'!G23)*24","v":0},0,0]
[{"$f":"('Penal Claim'!I24-'Penal Claim'!F24)*24","v":0},0,{"$f":"('Penal Claim'!H24-'Penal Claim'!G24)*24","v":0},0,0]
[{"$f":"('Penal Claim'!I25-'Penal Claim'!F25)*24","v":0},0,{"$f":"('Penal Claim'!H25-'Penal Claim'!G25)*24","v":0},0,0]
[{"$f":"('Penal Claim'!I26-'Penal Claim'!F26)*24","v":0},0,{"$f":"('Penal Claim'!H26-'Penal Claim'!G26)*24","v":0},0,0]
[{"$f":"('Penal Claim'!I27-'Penal Claim'!F27)*24","v":0},0,{"$f":"('Penal Claim'!H27-'Penal Claim'!G27)*24","v":0},0,0]
[{"$f":"('Penal Claim'!I28-'Penal Claim'!F28)*24","v":0},0,{"$f":"('Penal Claim'!H28-'Penal Claim'!G28)*24","v":0},0,0]
[{"$f":"('Penal Claim'!I29-'Penal Claim'!F29)*24","v":0},0,{"$f":"('Penal Claim'!H29-'Penal Claim'!G29)*24","v":0},0,0]
[{"$f":"('Penal Claim'!I30-'Penal Claim'!F30)*24","v":0},0,{"$f":"('Penal Claim'!H30-'Penal Claim'!G30)*24","v":0},0,0]
[{"$f":"('Penal Claim'!I31-'Penal Claim'!F31)*24","v":0},0,{"$f":"('Penal Claim'!H31-'Penal Claim'!G31)*24","v":0},0,0]
[{"$f":"('Penal Claim'!I32-'Penal Claim'!F32)*24","v":0},0,{"$f":"('Penal Claim'!H32-'Penal Claim'!G32)*24","v":0},0,0]
[{"$f":"('Penal Claim'!I33-'Penal Claim'!F33)*24","v":0},0,{"$f":"('Penal Claim'!H33-'Penal Claim'!G33)*24","v":0},0,0]
[{"$f":"('Penal Claim'!I34-'Penal Claim'!F34)*24","v":0},0,{"$f":"('Penal Claim'!H34-'Penal Claim'!G34)*24","v":0},0,0]
[{"$f":"('Penal Claim'!I35-'Penal Claim'!F35)*24","v":0},0,{"$f":"('Penal Claim'!H35-'Penal Claim'!G35)*24","v":0},0,0]
[{"$f":"('Penal Claim'!I36-'Penal Claim'!F36)*24","v":0},0,{"$f":"('Penal Claim'!H36-'Penal Claim'!G36)*24","v":0},0,0]
[{"$f":"('Penal Claim'!I37-'Penal Claim'!F37)*24","v":0},0,{"$f":"('Penal Claim'!H37-'Penal Claim'!G37)*24","v":0},0,0]
[{"$f":"('Penal Claim'!I38-'Penal Claim'!F38)*24","v":0},0,{"$f":"('Penal Claim'!H38-'Penal Claim'!G38)*24","v":0},0,0]
[{"$f":"('Penal Claim'!I39-'Penal Claim'!F39)*24","v":0},0,{"$f":"('Penal Claim'!H39-'Penal Claim'!G39)*24","v":0},0,0]
[{"$f":"('Penal Claim'!I40-'Penal Claim'!F40)*24","v":0},0,{"$f":"('Penal Claim'!H40-'Penal Claim'!G40)*24","v":0},0,0]

{"sheet":"Overtime Claim","index":3,"n_rows":48,"n_cols":23,"rows_kept":48,"cut":false,"hidden":false,"merged":[[10,22,11,22],[4,22,7,22],[10,20,11,20],[10,21,11,21],[8,2,9,2],[10,17,11,17],[10,18,11,19],[8,17,9,17],[8,20,9,20],[8,21,9,21],[10,5,11,5],[10,4,11,4],[10,6,11,9],[10,10,11,10],[10,11,11,14],[10,15,11,15],[8,15,9,15],[8,16,9,16],[8,0,9,0],[8,1,9,1],[10,0,11,2],[8,5,9,5],[8,4,9,4],[8,6,8,9],[8,10,9,10],[8,11,8,14],[8,3,9,3],[10,3,41,3],[47,14,48,15],[43,16,44,17],[45,0,46,1],[45,8,46,8],[43,0,44,1],[43,8,44,8],[47,0,48,1],[47,8,48,8],[4,1,7,21],[4,0,7,0],[8,18,8,19],[43,18,44,19],[45,16,48,19],[43,10,48,11],[43,2,44,7],[47,2,48,7],[45,5,46,5],[45,6,46,7],[45,2,46,4],[43,12,44,13],[45,12,46,13],[47,12,48,13],[43,14,44,15],[45,14,46,15]]}
[]
[]
["Overtime Claim for Full Time Employees"]
["Only complete this timesheet for employees who work full time."]
["Comments"]
[]
[]
[]
["Emp no","First name","Last name","Blank","Date DD/MM/YYYY","Day","Hours worked during Ordinary Time",null,null,null,"Total","Hours worked during Overtime",null,null,null,"Total OT Hours","OT or TOIL","Total TOIL","Payroll Use Only",null,"Total Hours for the day","Paid Meal Claim ($15)","Payroll Use Only"]
[null,null,null,null,null,null,"Start Time","Break Start","Break End","Finish Time",null,"Start Time","Break Start","Break End","Finish Time",null,null,null,"Total T1.5","Total T2",null,null,"Comments/Adjustments/Corrections"]
["Mandatory",null,null,null,"Type in format dd/mm/yyyy","Auto Calculated","Please enter in 24 hour time format. Using any other time format may result in an error.",null,null,null,"Auto Calc'd","Please enter in 24 hour time format. Using any other time format may result in an error.",null,null,null,"Overtime will be paid after the completion of 8 hours (unless you are on a FWA)","Blank for OT","Automatically calculated if applicable"," T1.5 = Paid for first 3 hrs unless,\nT2.0 = in excess of 3 continuous hours, between 10pm to 6am, between midday Saturday and 6am Monday and on a Public Holiday\n",null,"Normal shift plus overtime hours","Emp. must work at least two hours after a meal break","Use this box to show changes - e.g. if employee did not work 8 hours prior to claiming overtime a note might say \"OT hours 2.5 rather than 3\""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," T for TOIL"]
[12345,"FirstName","LastName",null,"2019-01-07","Tuesday","08:00:00","12:00:00","12:30:00","16:30:00",8,"17:00:00","19:00:00","19:30:00","22:00:00",4.5,null,null,3,1.5,12.5,"x"]
[23456,"SecondFirst","SecondLast",null,"2020-01-07","Tuesday","08:30:00","12:30:00","13:00:00","17:00:00",8,"17:00:00",null,null,"20:00:00",3,"T",3,null,null,11]
[null,null,null,null,null,{"$f":"IF(E15=\"\",\"\",TEXT(E15,\"dddd\"))","v":""},null,null,null,null,{"$f":"OTCHS!G10","v":0},null,null,null,null,{"$f":"OTCHS!L10","v":0},null,{"$f":"IF(Q15=\"T\",P15,\"\")","v":""},null,null,{"$f":"K15+P15","v":0}]
[null,null,null,null,null,{"$f":"IF(E16=\"\",\"\",TEXT(E16,\"dddd\"))","v":""},null,null,null,null,{"$f":"OTCHS!G11","v":0},null,null,null,null,{"$f":"OTCHS!L11","v":0},null,{"$f":"IF(Q16=\"T\",P16,\"\")","v":""},null,null,{"$f":"K16+P16","v":0}]
[null,null,null,null,null,"",null,null,null,null,{"$f":"OTCHS!G12","v":0},null,null,null,null,{"$f":"OTCHS!L12","v":0},null,"",null,null,0]
[null,null,null,null,null,"",null,null,null,null,{"$f":"OTCHS!G13","v":0},null,null,null,null,{"$f":"OTCHS!L13","v":0},null,"",null,null,0]
[null,null,null,null,null,"",null,null,null,null,{"$f":"OTCHS!G14","v":0},null,null,null,null,{"$f":"OTCHS!L14","v":0},null,"",null,null,0]
[null,null,null,null,null,"",null,null,null,null,{"$f":"OTCHS!G15","v":0},null,null,null,null,{"$f":"OTCHS!L15","v":0},null,"",null,null,0]
[null,null,null,null,null,"",null,null,null,null,{"$f":"OTCHS!G16","v":0},null,null,null,null,{"$f":"OTCHS!L16","v":0},null,"",null,null,0]
[null,null,null,null,null,"",null,null,null,null,{"$f":"OTCHS!G17","v":0},null,null,null,null,{"$f":"OTCHS!L17","v":0},null,"",null,null,0]
[null,null,null,null,null,"",null,null,null,null,{"$f":"OTCHS!G18","v":0},null,null,null,null,{"$f":"OTCHS!L18","v":0},null,"",null,null,0]
[null,null,null,null,null,"",null,null,null,null,{"$f":"OTCHS!G19","v":0},null,null,null,null,{"$f":"OTCHS!L19","v":0},null,"",null,null,0]
[null,null,null,null,null,"",null,null,null,null,{"$f":"OTCHS!G20","v":0},null,null,null,null,{"$f":"OTCHS!L20","v":0},null,"",null,null,0]
[null,null,null,null,null,"",null,null,null,null,{"$f":"OTCHS!G21","v":0},null,null,null,null,{"$f":"OTCHS!L21","v":0},null,"",null,null,0]
[null,null,null,null,null,"",null,null,null,null,{"$f":"OTCHS!G22","v":0},null,null,null,null,{"$f":"OTCHS!L22","v":0},null,"",null,null,0]
[null,null,null,null,null,"",null,null,null,null,{"$f":"OTCHS!G23","v":0},null,null,null,null,{"$f":"OTCHS!L23","v":0},null,"",null,null,0]
[null,null,null,null,null,"",null,null,null,null,{"$f":"OTCHS!G24","v":0},null,null,null,null,{"$f":"OTCHS!L24","v":0},null,"",null,null,0]
[null,null,null,null,null,"",null,null,null,null,{"$f":"OTCHS!G25","v":0},null,null,null,null,{"$f":"OTCHS!L25","v":0},null,"",null,null,0]
[null,null,null,null,null,"",null,null,null,null,{"$f":"OTCHS!G26","v":0},null,null,null,null,{"$f":"OTCHS!L26","v":0},null,"",null,null,0]
[null,null,null,null,null,"",null,null,null,null,{"$f":"OTCHS!G27","v":0},null,null,null,null,{"$f":"OTCHS!L27","v":0},null,"",null,null,0]
[null,null,null,null,null,"",null,null,null,null,{"$f":"OTCHS!G28","v":0},null,null,null,null,{"$f":"OTCHS!L28","v":0},null,"",null,null,0]
[null,null,null,null,null,"",null,null,null,null,{"$f":"OTCHS!G29","v":0},null,null,null,null,{"$f":"OTCHS!L29","v":0},null,"",null,null,0]
[null,null,null,null,null,"",null,null,null,null,{"$f":"OTCHS!G30","v":0},null,null,null,null,{"$f":"OTCHS!L30","v":0},null,"",null,null,0]
[null,null,null,null,null,"",null,null,null,null,{"$f":"OTCHS!G31","v":0},null,null,null,null,{"$f":"OTCHS!L31","v":0},null,"",null,null,0]
[null,null,null,null,null,"",null,null,null,null,{"$f":"OTCHS!G32","v":0},null,null,null,null,{"$f":"OTCHS!L32","v":0},null,"",null,null,0]
[null,null,null,null,null,"",null,null,null,null,{"$f":"OTCHS!G33","v":0},null,null,null,null,{"$f":"OTCHS!L33","v":0},null,"",null,null,0]
[null,null,null,null,null,"",null,null,null,null,{"$f":"OTCHS!G34","v":0},null,null,null,null,{"$f":"OTCHS!L34","v":0},null,"",null,null,0]
[null,null,null,null,null,"",null,null,null,null,{"$f":"OTCHS!G35","v":0},null,null,null,null,{"$f":"OTCHS!L35","v":0},null,"",null,null,0]
[null,null,null,null,null,"",null,null,null,null,{"$f":"OTCHS!G36","v":0},null,null,null,null,{"$f":"OTCHS!L36","v":0},null,"",null,null,0]
[null,null,null,null,null,"",null,null,null,null,{"$f":"OTCHS!G37","v":0},null,null,null,null,{"$f":"OTCHS!L37","v":0},null,"",null,null,0]
[]
["Prepared by:",null,null,null,null,null,null,null,{"$f":"IF(C44=\"\",\"Required\",\"\")","v":"Required"},null,"Payroll use only:",null,"Processed by",null,null,null,"Pay period ending:"]
[]
["Approved by:",null,null,null,null,"Contact No:",null,null,{"$f":"IF(C46=\"\",\"Required\",IF(G46=\"\",\"Required\",\"\"))","v":"Required"},null,null,null,"Verified by"]
[]
["Date:",null,null,null,null,null,null,null,{"$f":"IF(C48=\"\",\"Required\",\"\")","v":"Required"},null,null,null,"Payslip checked by:"]

{"sheet":"OTCHS","index":4,"n_rows":37,"n_cols":12,"rows_kept":37,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
[]
[]
[null,null,"ST","ADJ","STB","ADJ","Total ST","OT","ADJ","OT B","ADJ","Total OT"]
[]
[]
[null,null,{"$f":"('Overtime Claim'!J15-'Overtime Claim'!G15)*24","v":0},{"$f":"IF(C10<0,C10+24,C10)","v":0},{"$f":"('Overtime Claim'!I15-'Overtime Claim'!H15)*24","v":0},{"$f":"IF(E10<0,E10+24,E10)","v":0},{"$f":"D10-F10","v":0},{"$f":"('Overtime Claim'!O15-'Overtime Claim'!L15)*24","v":0},{"$f":"IF(H10<0,H10+24,H10)","v":0},{"$f":"('Overtime Claim'!N15-'Overtime Claim'!M15)*24","v":0},{"$f":"IF(J10<0,J10+24,J10)","v":0},{"$f":"I10-K10","v":0}]
[null,null,{"$f":"('Overtime Claim'!J16-'Overtime Claim'!G16)*24","v":0},{"$f":"IF(C11<0,C11+24,C11)","v":0},{"$f":"('Overtime Claim'!I16-'Overtime Claim'!H16)*24","v":0},{"$f":"IF(E11<0,E11+24,E11)","v":0},{"$f":"D11-F11","v":0},{"$f":"('Overtime Claim'!O16-'Overtime Claim'!L16)*24","v":0},0,{"$f":"('Overtime Claim'!N16-'Overtime Claim'!M16)*24","v":0},0,0]
[null,null,{"$f":"('Overtime Claim'!J17-'Overtime Claim'!G17)*24","v":0},0,{"$f":"('Overtime Claim'!I17-'Overtime Claim'!H17)*24","v":0},0,0,{"$f":"('Overtime Claim'!O17-'Overtime Claim'!L17)*24","v":0},0,{"$f":"('Overtime Claim'!N17-'Overtime Claim'!M17)*24","v":0},0,0]
[null,null,{"$f":"('Overtime Claim'!J18-'Overtime Claim'!G18)*24","v":0},0,{"$f":"('Overtime Claim'!I18-'Overtime Claim'!H18)*24","v":0},0,0,{"$f":"('Overtime Claim'!O18-'Overtime Claim'!L18)*24","v":0},0,{"$f":"('Overtime Claim'!N18-'Overtime Claim'!M18)*24","v":0},0,0]
[null,null,{"$f":"('Overtime Claim'!J19-'Overtime Claim'!G19)*24","v":0},0,{"$f":"('Overtime Claim'!I19-'Overtime Claim'!H19)*24","v":0},0,0,{"$f":"('Overtime Claim'!O19-'Overtime Claim'!L19)*24","v":0},0,{"$f":"('Overtime Claim'!N19-'Overtime Claim'!M19)*24","v":0},0,0]
[null,null,{"$f":"('Overtime Claim'!J20-'Overtime Claim'!G20)*24","v":0},0,{"$f":"('Overtime Claim'!I20-'Overtime Claim'!H20)*24","v":0},0,0,{"$f":"('Overtime Claim'!O20-'Overtime Claim'!L20)*24","v":0},0,{"$f":"('Overtime Claim'!N20-'Overtime Claim'!M20)*24","v":0},0,0]
[null,null,{"$f":"('Overtime Claim'!J21-'Overtime Claim'!G21)*24","v":0},0,{"$f":"('Overtime Claim'!I21-'Overtime Claim'!H21)*24","v":0},0,0,{"$f":"('Overtime Claim'!O21-'Overtime Claim'!L21)*24","v":0},0,{"$f":"('Overtime Claim'!N21-'Overtime Claim'!M21)*24","v":0},0,0]
[null,null,{"$f":"('Overtime Claim'!J22-'Overtime Claim'!G22)*24","v":0},0,{"$f":"('Overtime Claim'!I22-'Overtime Claim'!H22)*24","v":0},0,0,{"$f":"('Overtime Claim'!O22-'Overtime Claim'!L22)*24","v":0},0,{"$f":"('Overtime Claim'!N22-'Overtime Claim'!M22)*24","v":0},0,0]
[null,null,{"$f":"('Overtime Claim'!J23-'Overtime Claim'!G23)*24","v":0},0,{"$f":"('Overtime Claim'!I23-'Overtime Claim'!H23)*24","v":0},0,0,{"$f":"('Overtime Claim'!O23-'Overtime Claim'!L23)*24","v":0},0,{"$f":"('Overtime Claim'!N23-'Overtime Claim'!M23)*24","v":0},0,0]
[null,null,{"$f":"('Overtime Claim'!J24-'Overtime Claim'!G24)*24","v":0},0,{"$f":"('Overtime Claim'!I24-'Overtime Claim'!H24)*24","v":0},0,0,{"$f":"('Overtime Claim'!O24-'Overtime Claim'!L24)*24","v":0},0,{"$f":"('Overtime Claim'!N24-'Overtime Claim'!M24)*24","v":0},0,0]
[null,null,{"$f":"('Overtime Claim'!J25-'Overtime Claim'!G25)*24","v":0},0,{"$f":"('Overtime Claim'!I25-'Overtime Claim'!H25)*24","v":0},0,0,{"$f":"('Overtime Claim'!O25-'Overtime Claim'!L25)*24","v":0},0,{"$f":"('Overtime Claim'!N25-'Overtime Claim'!M25)*24","v":0},0,0]
[null,null,{"$f":"('Overtime Claim'!J26-'Overtime Claim'!G26)*24","v":0},0,{"$f":"('Overtime Claim'!I26-'Overtime Claim'!H26)*24","v":0},0,0,{"$f":"('Overtime Claim'!O26-'Overtime Claim'!L26)*24","v":0},0,{"$f":"('Overtime Claim'!N26-'Overtime Claim'!M26)*24","v":0},0,0]
[null,null,{"$f":"('Overtime Claim'!J27-'Overtime Claim'!G27)*24","v":0},0,{"$f":"('Overtime Claim'!I27-'Overtime Claim'!H27)*24","v":0},0,0,{"$f":"('Overtime Claim'!O27-'Overtime Claim'!L27)*24","v":0},0,{"$f":"('Overtime Claim'!N27-'Overtime Claim'!M27)*24","v":0},0,0]
[null,null,{"$f":"('Overtime Claim'!J28-'Overtime Claim'!G28)*24","v":0},0,{"$f":"('Overtime Claim'!I28-'Overtime Claim'!H28)*24","v":0},0,0,{"$f":"('Overtime Claim'!O28-'Overtime Claim'!L28)*24","v":0},0,{"$f":"('Overtime Claim'!N28-'Overtime Claim'!M28)*24","v":0},0,0]
[null,null,{"$f":"('Overtime Claim'!J29-'Overtime Claim'!G29)*24","v":0},0,{"$f":"('Overtime Claim'!I29-'Overtime Claim'!H29)*24","v":0},0,0,{"$f":"('Overtime Claim'!O29-'Overtime Claim'!L29)*24","v":0},0,{"$f":"('Overtime Claim'!N29-'Overtime Claim'!M29)*24","v":0},0,0]
[null,null,{"$f":"('Overtime Claim'!J30-'Overtime Claim'!G30)*24","v":0},0,{"$f":"('Overtime Claim'!I30-'Overtime Claim'!H30)*24","v":0},0,0,{"$f":"('Overtime Claim'!O30-'Overtime Claim'!L30)*24","v":0},0,{"$f":"('Overtime Claim'!N30-'Overtime Claim'!M30)*24","v":0},0,0]
[null,null,{"$f":"('Overtime Claim'!J31-'Overtime Claim'!G31)*24","v":0},0,{"$f":"('Overtime Claim'!I31-'Overtime Claim'!H31)*24","v":0},0,0,{"$f":"('Overtime Claim'!O31-'Overtime Claim'!L31)*24","v":0},0,{"$f":"('Overtime Claim'!N31-'Overtime Claim'!M31)*24","v":0},0,0]
[null,null,{"$f":"('Overtime Claim'!J32-'Overtime Claim'!G32)*24","v":0},0,{"$f":"('Overtime Claim'!I32-'Overtime Claim'!H32)*24","v":0},0,0,{"$f":"('Overtime Claim'!O32-'Overtime Claim'!L32)*24","v":0},0,{"$f":"('Overtime Claim'!N32-'Overtime Claim'!M32)*24","v":0},0,0]
[null,null,{"$f":"('Overtime Claim'!J33-'Overtime Claim'!G33)*24","v":0},0,{"$f":"('Overtime Claim'!I33-'Overtime Claim'!H33)*24","v":0},0,0,{"$f":"('Overtime Claim'!O33-'Overtime Claim'!L33)*24","v":0},0,{"$f":"('Overtime Claim'!N33-'Overtime Claim'!M33)*24","v":0},0,0]
[null,null,{"$f":"('Overtime Claim'!J34-'Overtime Claim'!G34)*24","v":0},0,{"$f":"('Overtime Claim'!I34-'Overtime Claim'!H34)*24","v":0},0,0,{"$f":"('Overtime Claim'!O34-'Overtime Claim'!L34)*24","v":0},0,{"$f":"('Overtime Claim'!N34-'Overtime Claim'!M34)*24","v":0},0,0]
[null,null,{"$f":"('Overtime Claim'!J35-'Overtime Claim'!G35)*24","v":0},0,{"$f":"('Overtime Claim'!I35-'Overtime Claim'!H35)*24","v":0},0,0,{"$f":"('Overtime Claim'!O35-'Overtime Claim'!L35)*24","v":0},0,{"$f":"('Overtime Claim'!N35-'Overtime Claim'!M35)*24","v":0},0,0]
[null,null,{"$f":"('Overtime Claim'!J36-'Overtime Claim'!G36)*24","v":0},0,{"$f":"('Overtime Claim'!I36-'Overtime Claim'!H36)*24","v":0},0,0,{"$f":"('Overtime Claim'!O36-'Overtime Claim'!L36)*24","v":0},0,{"$f":"('Overtime Claim'!N36-'Overtime Claim'!M36)*24","v":0},0,0]
[null,null,{"$f":"('Overtime Claim'!J37-'Overtime Claim'!G37)*24","v":0},0,{"$f":"('Overtime Claim'!I37-'Overtime Claim'!H37)*24","v":0},0,0,{"$f":"('Overtime Claim'!O37-'Overtime Claim'!L37)*24","v":0},0,{"$f":"('Overtime Claim'!N37-'Overtime Claim'!M37)*24","v":0},0,0]
[null,null,{"$f":"('Overtime Claim'!J38-'Overtime Claim'!G38)*24","v":0},0,{"$f":"('Overtime Claim'!I38-'Overtime Claim'!H38)*24","v":0},0,0,{"$f":"('Overtime Claim'!O38-'Overtime Claim'!L38)*24","v":0},0,{"$f":"('Overtime Claim'!N38-'Overtime Claim'!M38)*24","v":0},0,0]
[null,null,{"$f":"('Overtime Claim'!J39-'Overtime Claim'!G39)*24","v":0},0,{"$f":"('Overtime Claim'!I39-'Overtime Claim'!H39)*24","v":0},0,0,{"$f":"('Overtime Claim'!O39-'Overtime Claim'!L39)*24","v":0},0,{"$f":"('Overtime Claim'!N39-'Overtime Claim'!M39)*24","v":0},0,0]
[null,null,{"$f":"('Overtime Claim'!J40-'Overtime Claim'!G40)*24","v":0},0,{"$f":"('Overtime Claim'!I40-'Overtime Claim'!H40)*24","v":0},0,0,{"$f":"('Overtime Claim'!O40-'Overtime Claim'!L40)*24","v":0},0,{"$f":"('Overtime Claim'!N40-'Overtime Claim'!M40)*24","v":0},0,0]
[null,null,{"$f":"('Overtime Claim'!J41-'Overtime Claim'!G41)*24","v":0},0,{"$f":"('Overtime Claim'!I41-'Overtime Claim'!H41)*24","v":0},0,0,{"$f":"('Overtime Claim'!O41-'Overtime Claim'!L41)*24","v":0},0,{"$f":"('Overtime Claim'!N41-'Overtime Claim'!M41)*24","v":0},0,0]
[null,null,{"$f":"('Overtime Claim'!J42-'Overtime Claim'!G42)*24","v":0},0,{"$f":"('Overtime Claim'!I42-'Overtime Claim'!H42)*24","v":0},0,0,{"$f":"('Overtime Claim'!O42-'Overtime Claim'!L42)*24","v":0},0,{"$f":"('Overtime Claim'!N42-'Overtime Claim'!M42)*24","v":0},0,0]

{"sheet":"Additional Hours for Part Time ","index":5,"n_rows":41,"n_cols":24,"rows_kept":41,"cut":false,"hidden":false,"merged":[[10,23,11,23],[8,6,8,9],[8,0,9,0],[8,1,9,1],[8,2,9,2],[8,5,9,5],[8,4,9,4],[8,10,9,10],[8,11,8,14],[8,15,9,15],[8,16,9,16],[8,17,9,17],[10,21,11,21],[10,22,11,22],[10,18,11,20],[8,21,9,21],[8,22,9,22],[10,15,11,15],[10,17,11,17],[10,0,11,2],[10,5,11,5],[10,4,11,4],[10,6,11,9],[10,10,11,10],[10,11,11,14],[38,8,39,8],[38,0,39,1],[36,16,37,17],[36,0,37,1],[40,0,41,1],[40,12,41,13],[40,2,41,7],[40,8,41,8],[4,0,7,0],[4,1,7,22],[8,18,8,20],[36,18,37,19],[38,16,41,19],[36,14,37,15],[38,14,39,15],[40,14,41,15],[36,10,41,11],[36,12,37,13],[38,12,39,13],[36,2,37,7],[36,8,37,8],[38,2,39,4],[38,5,39,5],[38,6,39,7]]}
[]
[]
["Additional Hours worked for part time employees"]
["Only complete this timesheet for part time employees"]
["Comments"]
[]
[]
[]
["Emp no","First name","Last name",null,"Date DD/MM/YYYY","Day","Hours worked during Ordinary Time",null,null,null,"Total","Additional hours worked",null,null,null,"Total Additional Hours","Additional Hours or TOIL","Total TOIL","Payroll Use Only",null,null,"Total Hours for the day","Paid Meal Claim ($15)","Payroll Use Only"]
[null,null,null,null,null,null,"Start Time","Break Start","Break End","Finish Time",null,"Start Time","Break Start","Break End","Finish Time",null,null,null,"Total T1","Total T1.5","Total T2",null,null,"Comments/Adjustments/Corrections"]
["Mandatory",null,null,null,"Type in format dd/mm/yyyy","Auto Generated","Please enter in 24 hour time format. Using any other time format may result in an error.",null,null,null,"Auto Calc'd","Please enter in 24 hour time format. Using any other time format may result in an error.",null,null,null,"Auto Calc'd","Blank for Additional Hours","Automatically calculated if applicable","T1 = Additional hours up to 40 hours for Part-Time employees                                                                      After 40 hours: T1.5 = Paid for first 3 hrs unless,\nT2.0 = in excess of 3 continuous hours, between 10pm to 6am, between midday Saturday and 6am Monday and on a Public Holiday\n",null,null,"Normal shift plus overtime hours","Emp. must work at least two hours after a meal break. Emp. must work in excess of 40 hours per week to claim","Use this box to show changes - e.g. if employee did not work 8 hours prior to claiming overtime a note might say \"OT hours 2.5 rather than 3\""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," T for TOIL"]
[12345,"FirstName","LastName",null,"2019-01-07","Tuesday","08:00:00","12:00:00","12:30:00","16:30:00",8,"17:00:00","19:00:00","19:30:00","22:00:00",4.5,null,null,null,3,1.5,12.5,"x"]
[23456,"SecondFirst","SecondLast",null,"2020-01-07","Tuesday","08:30:00","12:30:00","13:00:00","17:00:00",8,"17:00:00",null,null,"20:00:00",3,"T",3,null,null,null,11]
[null,null,null,null,null,{"$f":"IF(E15=\"\",\"\",TEXT(E15,\"dddd\"))","v":""},null,null,null,null,{"$f":"AHPTHS!H9","v":0},null,null,null,null,{"$f":"AHPTHS!M9","v":0},null,{"$f":"IF(Q15=\"T\",P15,\"\")","v":""},null,null,null,{"$f":"K15+P15","v":0}]
[null,null,null,null,null,{"$f":"IF(E16=\"\",\"\",TEXT(E16,\"dddd\"))","v":""},null,null,null,null,{"$f":"AHPTHS!H10","v":0},null,null,null,null,{"$f":"AHPTHS!M10","v":0},null,{"$f":"IF(Q16=\"T\",P16,\"\")","v":""},null,null,null,{"$f":"K16+P16","v":0}]
[null,null,null,null,null,"",null,null,null,null,{"$f":"AHPTHS!H11","v":0},null,null,null,null,{"$f":"AHPTHS!M11","v":0},null,"",null,null,null,0]
[null,null,null,null,null,"",null,null,null,null,{"$f":"AHPTHS!H12","v":0},null,null,null,null,{"$f":"AHPTHS!M12","v":0},null,"",null,null,null,0]
[null,null,null,null,null,"",null,null,null,null,{"$f":"AHPTHS!H13","v":0},null,null,null,null,{"$f":"AHPTHS!M13","v":0},null,"",null,null,null,0]
[null,null,null,null,null,"",null,null,null,null,{"$f":"AHPTHS!H14","v":0},null,null,null,null,{"$f":"AHPTHS!M14","v":0},null,"",null,null,null,0]
[null,null,null,null,null,"",null,null,null,null,{"$f":"AHPTHS!H15","v":0},null,null,null,null,{"$f":"AHPTHS!M15","v":0},null,"",null,null,null,0]
[null,null,null,null,null,"",null,null,null,null,{"$f":"AHPTHS!H16","v":0},null,null,null,null,{"$f":"AHPTHS!M16","v":0},null,"",null,null,null,0]
[null,null,null,null,null,"",null,null,null,null,{"$f":"AHPTHS!H17","v":0},null,null,null,null,{"$f":"AHPTHS!M17","v":0},null,"",null,null,null,0]
[null,null,null,null,null,"",null,null,null,null,{"$f":"AHPTHS!H18","v":0},null,null,null,null,{"$f":"AHPTHS!M18","v":0},null,"",null,null,null,0]
[null,null,null,null,null,"",null,null,null,null,{"$f":"AHPTHS!H19","v":0},null,null,null,null,{"$f":"AHPTHS!M19","v":0},null,"",null,null,null,0]
[null,null,null,null,null,"",null,null,null,null,{"$f":"AHPTHS!H20","v":0},null,null,null,null,{"$f":"AHPTHS!M20","v":0},null,"",null,null,null,0]
[null,null,null,null,null,"",null,null,null,null,{"$f":"AHPTHS!H21","v":0},null,null,null,null,{"$f":"AHPTHS!M21","v":0},null,"",null,null,null,0]
[null,null,null,null,null,"",null,null,null,null,{"$f":"AHPTHS!H22","v":0},null,null,null,null,{"$f":"AHPTHS!M22","v":0},null,"",null,null,null,0]
[null,null,null,null,null,"",null,null,null,null,{"$f":"AHPTHS!H23","v":0},null,null,null,null,{"$f":"AHPTHS!M23","v":0},null,"",null,null,null,0]
[null,null,null,null,null,"",null,null,null,null,{"$f":"AHPTHS!H24","v":0},null,null,null,null,{"$f":"AHPTHS!M24","v":0},null,"",null,null,null,0]
[null,null,null,null,null,"",null,null,null,null,{"$f":"AHPTHS!H25","v":0},null,null,null,null,{"$f":"AHPTHS!M25","v":0},null,"",null,null,null,0]
[null,null,null,null,null,"",null,null,null,null,{"$f":"AHPTHS!H26","v":0},null,null,null,null,{"$f":"AHPTHS!M26","v":0},null,"",null,null,null,0]
[null,null,null,null,null,"",null,null,null,null,{"$f":"AHPTHS!H27","v":0},null,null,null,null,{"$f":"AHPTHS!M27","v":0},null,"",null,null,null,0]
[null,null,null,null,null,"",null,null,null,null,{"$f":"AHPTHS!H28","v":0},null,null,null,null,{"$f":"AHPTHS!M28","v":0},null,"",null,null,null,0]
[null,null,null,null,null,"",null,null,null,null,{"$f":"AHPTHS!H29","v":0},null,null,null,null,{"$f":"AHPTHS!M29","v":0},null,"",null,null,null,0]
[]
["Prepared by:",null,null,null,null,null,null,null,{"$f":"IF(C37=\"\",\"Required\",\"\")","v":"Required"},null,"Payroll use only:",null,"Processed by",null,null,null,"Pay period ending:"]
[]
["Approved by:",null,null,null,null,"Contact No:",null,null,{"$f":"IF(C39=\"\",\"Required\",IF(G39=\"\",\"Required\",\"\"))","v":"Required"},null,null,null,"Verified by"]
[]
["Date:",null,null,null,null,null,null,null,{"$f":"IF(C41=\"\",\"Required\",\"\")","v":"Required"},null,null,null,"Payslip checked by:"]

{"sheet":"AHPTHS","index":6,"n_rows":29,"n_cols":13,"rows_kept":29,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"ST","ADJ","STB","ADJ","Total ST","OT","ADJ","OT B","ADJ","Total OT"]
[null,null,null,{"$f":"('Additional Hours for Part Time '!J15-'Additional Hours for Part Time '!G15)*24","v":0},{"$f":"IF(D9<0,D9+24,D9)","v":0},{"$f":"('Additional Hours for Part Time '!I15-'Additional Hours for Part Time '!H15)*24","v":0},{"$f":"IF(F9<0,F9+24,F9)","v":0},{"$f":"E9-G9","v":0},{"$f":"('Additional Hours for Part Time '!O15-'Additional Hours for Part Time '!L15)*24","v":0},{"$f":"IF(I9<0,I9+24,I9)","v":0},{"$f":"('Additional Hours for Part Time '!N15-'Additional Hours for Part Time '!M15)*24","v":0},{"$f":"IF(K9<0,K9+24,K9)","v":0},{"$f":"J9-L9","v":0}]
[null,null,null,{"$f":"('Additional Hours for Part Time '!J16-'Additional Hours for Part Time '!G16)*24","v":0},{"$f":"IF(D10<0,D10+24,D10)","v":0},{"$f":"('Additional Hours for Part Time '!I16-'Additional Hours for Part Time '!H16)*24","v":0},{"$f":"IF(F10<0,F10+24,F10)","v":0},{"$f":"E10-G10","v":0},{"$f":"('Additional Hours for Part Time '!O16-'Additional Hours for Part Time '!L16)*24","v":0},{"$f":"IF(I10<0,I10+24,I10)","v":0},{"$f":"('Additional Hours for Part Time '!N16-'Additional Hours for Part Time '!M16)*24","v":0},{"$f":"IF(K10<0,K10+24,K10)","v":0},{"$f":"J10-L10","v":0}]
[null,null,null,{"$f":"('Additional Hours for Part Time '!J17-'Additional Hours for Part Time '!G17)*24","v":0},0,{"$f":"('Additional Hours for Part Time '!I17-'Additional Hours for Part Time '!H17)*24","v":0},0,0,{"$f":"('Additional Hours for Part Time '!O17-'Additional Hours for Part Time '!L17)*24","v":0},0,{"$f":"('Additional Hours for Part Time '!N17-'Additional Hours for Part Time '!M17)*24","v":0},0,0]
[null,null,null,{"$f":"('Additional Hours for Part Time '!J18-'Additional Hours for Part Time '!G18)*24","v":0},0,{"$f":"('Additional Hours for Part Time '!I18-'Additional Hours for Part Time '!H18)*24","v":0},0,0,{"$f":"('Additional Hours for Part Time '!O18-'Additional Hours for Part Time '!L18)*24","v":0},0,{"$f":"('Additional Hours for Part Time '!N18-'Additional Hours for Part Time '!M18)*24","v":0},0,0]
[null,null,null,{"$f":"('Additional Hours for Part Time '!J19-'Additional Hours for Part Time '!G19)*24","v":0},0,{"$f":"('Additional Hours for Part Time '!I19-'Additional Hours for Part Time '!H19)*24","v":0},0,0,{"$f":"('Additional Hours for Part Time '!O19-'Additional Hours for Part Time '!L19)*24","v":0},0,{"$f":"('Additional Hours for Part Time '!N19-'Additional Hours for Part Time '!M19)*24","v":0},0,0]
[null,null,null,{"$f":"('Additional Hours for Part Time '!J20-'Additional Hours for Part Time '!G20)*24","v":0},0,{"$f":"('Additional Hours for Part Time '!I20-'Additional Hours for Part Time '!H20)*24","v":0},0,0,{"$f":"('Additional Hours for Part Time '!O20-'Additional Hours for Part Time '!L20)*24","v":0},0,{"$f":"('Additional Hours for Part Time '!N20-'Additional Hours for Part Time '!M20)*24","v":0},0,0]
[null,null,null,{"$f":"('Additional Hours for Part Time '!J21-'Additional Hours for Part Time '!G21)*24","v":0},0,{"$f":"('Additional Hours for Part Time '!I21-'Additional Hours for Part Time '!H21)*24","v":0},0,0,{"$f":"('Additional Hours for Part Time '!O21-'Additional Hours for Part Time '!L21)*24","v":0},0,{"$f":"('Additional Hours for Part Time '!N21-'Additional Hours for Part Time '!M21)*24","v":0},0,0]
[null,null,null,{"$f":"('Additional Hours for Part Time '!J22-'Additional Hours for Part Time '!G22)*24","v":0},0,{"$f":"('Additional Hours for Part Time '!I22-'Additional Hours for Part Time '!H22)*24","v":0},0,0,{"$f":"('Additional Hours for Part Time '!O22-'Additional Hours for Part Time '!L22)*24","v":0},0,{"$f":"('Additional Hours for Part Time '!N22-'Additional Hours for Part Time '!M22)*24","v":0},0,0]
[null,null,null,{"$f":"('Additional Hours for Part Time '!J23-'Additional Hours for Part Time '!G23)*24","v":0},0,{"$f":"('Additional Hours for Part Time '!I23-'Additional Hours for Part Time '!H23)*24","v":0},0,0,{"$f":"('Additional Hours for Part Time '!O23-'Additional Hours for Part Time '!L23)*24","v":0},0,{"$f":"('Additional Hours for Part Time '!N23-'Additional Hours for Part Time '!M23)*24","v":0},0,0]
[null,null,null,{"$f":"('Additional Hours for Part Time '!J24-'Additional Hours for Part Time '!G24)*24","v":0},0,{"$f":"('Additional Hours for Part Time '!I24-'Additional Hours for Part Time '!H24)*24","v":0},0,0,{"$f":"('Additional Hours for Part Time '!O24-'Additional Hours for Part Time '!L24)*24","v":0},0,{"$f":"('Additional Hours for Part Time '!N24-'Additional Hours for Part Time '!M24)*24","v":0},0,0]
[null,null,null,{"$f":"('Additional Hours for Part Time '!J25-'Additional Hours for Part Time '!G25)*24","v":0},0,{"$f":"('Additional Hours for Part Time '!I25-'Additional Hours for Part Time '!H25)*24","v":0},0,0,{"$f":"('Additional Hours for Part Time '!O25-'Additional Hours for Part Time '!L25)*24","v":0},0,{"$f":"('Additional Hours for Part Time '!N25-'Additional Hours for Part Time '!M25)*24","v":0},0,0]
[null,null,null,{"$f":"('Additional Hours for Part Time '!J26-'Additional Hours for Part Time '!G26)*24","v":0},0,{"$f":"('Additional Hours for Part Time '!I26-'Additional Hours for Part Time '!H26)*24","v":0},0,0,{"$f":"('Additional Hours for Part Time '!O26-'Additional Hours for Part Time '!L26)*24","v":0},0,{"$f":"('Additional Hours for Part Time '!N26-'Additional Hours for Part Time '!M26)*24","v":0},0,0]
[null,null,null,{"$f":"('Additional Hours for Part Time '!J27-'Additional Hours for Part Time '!G27)*24","v":0},0,{"$f":"('Additional Hours for Part Time '!I27-'Additional Hours for Part Time '!H27)*24","v":0},0,0,{"$f":"('Additional Hours for Part Time '!O27-'Additional Hours for Part Time '!L27)*24","v":0},0,{"$f":"('Additional Hours for Part Time '!N27-'Additional Hours for Part Time '!M27)*24","v":0},0,0]
[null,null,null,{"$f":"('Additional Hours for Part Time '!J28-'Additional Hours for Part Time '!G28)*24","v":0},0,{"$f":"('Additional Hours for Part Time '!I28-'Additional Hours for Part Time '!H28)*24","v":0},0,0,{"$f":"('Additional Hours for Part Time '!O28-'Additional Hours for Part Time '!L28)*24","v":0},0,{"$f":"('Additional Hours for Part Time '!N28-'Additional Hours for Part Time '!M28)*24","v":0},0,0]
[null,null,null,{"$f":"('Additional Hours for Part Time '!J29-'Additional Hours for Part Time '!G29)*24","v":0},0,{"$f":"('Additional Hours for Part Time '!I29-'Additional Hours for Part Time '!H29)*24","v":0},0,0,{"$f":"('Additional Hours for Part Time '!O29-'Additional Hours for Part Time '!L29)*24","v":0},0,{"$f":"('Additional Hours for Part Time '!N29-'Additional Hours for Part Time '!M29)*24","v":0},0,0]
[null,null,null,{"$f":"('Additional Hours for Part Time '!J30-'Additional Hours for Part Time '!G30)*24","v":0},0,{"$f":"('Additional Hours for Part Time '!I30-'Additional Hours for Part Time '!H30)*24","v":0},0,0,{"$f":"('Additional Hours for Part Time '!O30-'Additional Hours for Part Time '!L30)*24","v":0},0,{"$f":"('Additional Hours for Part Time '!N30-'Additional Hours for Part Time '!M30)*24","v":0},0,0]
[null,null,null,{"$f":"('Additional Hours for Part Time '!J31-'Additional Hours for Part Time '!G31)*24","v":0},0,{"$f":"('Additional Hours for Part Time '!I31-'Additional Hours for Part Time '!H31)*24","v":0},0,0,{"$f":"('Additional Hours for Part Time '!O31-'Additional Hours for Part Time '!L31)*24","v":0},0,{"$f":"('Additional Hours for Part Time '!N31-'Additional Hours for Part Time '!M31)*24","v":0},0,0]
[null,null,null,{"$f":"('Additional Hours for Part Time '!J32-'Additional Hours for Part Time '!G32)*24","v":0},0,{"$f":"('Additional Hours for Part Time '!I32-'Additional Hours for Part Time '!H32)*24","v":0},0,0,{"$f":"('Additional Hours for Part Time '!O32-'Additional Hours for Part Time '!L32)*24","v":0},0,{"$f":"('Additional Hours for Part Time '!N32-'Additional Hours for Part Time '!M32)*24","v":0},0,0]
[null,null,null,{"$f":"('Additional Hours for Part Time '!J33-'Additional Hours for Part Time '!G33)*24","v":0},0,{"$f":"('Additional Hours for Part Time '!I33-'Additional Hours for Part Time '!H33)*24","v":0},0,0,{"$f":"('Additional Hours for Part Time '!O33-'Additional Hours for Part Time '!L33)*24","v":0},0,{"$f":"('Additional Hours for Part Time '!N33-'Additional Hours for Part Time '!M33)*24","v":0},0,0]
[null,null,null,{"$f":"('Additional Hours for Part Time '!J34-'Additional Hours for Part Time '!G34)*24","v":0},0,{"$f":"('Additional Hours for Part Time '!I34-'Additional Hours for Part Time '!H34)*24","v":0},0,0,{"$f":"('Additional Hours for Part Time '!O34-'Additional Hours for Part Time '!L34)*24","v":0},0,{"$f":"('Additional Hours for Part Time '!N34-'Additional Hours for Part Time '!M34)*24","v":0},0,0]
[null,null,null,{"$f":"('Additional Hours for Part Time '!J35-'Additional Hours for Part Time '!G35)*24","v":0},{"$f":"IF(D29<0,D29+24,D29)","v":0},{"$f":"('Additional Hours for Part Time '!I35-'Additional Hours for Part Time '!H35)*24","v":0},0,0,{"$f":"('Additional Hours for Part Time '!O35-'Additional Hours for Part Time '!L35)*24","v":0},0,{"$f":"('Additional Hours for Part Time '!N35-'Additional Hours for Part Time '!M35)*24","v":0},0,0]

{"sheet":"Version Control","index":7,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[[0,0,28,8]]}