{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Time sheet","Special_Days"],"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":"Time sheet","index":0,"n_rows":72,"n_cols":15,"rows_kept":72,"cut":false,"hidden":false,"merged":[[13,3,13,9],[13,12,13,14],[67,2,67,9],[15,21,15,22],[60,2,60,9],[54,8,54,12],[52,4,52,12],[52,13,52,14],[54,13,54,14]]}
[null,"Directions:"]
[]
[null,null,"Step 1:  Enter the date of the start of the pay period (a Sunday)"]
[null,null,"2019-03-31","<-- enter date here, in this shaded cell"]
[null,null,"Step 2:  Enter your name and ID in the blanks provided"]
[null,null,"Step 3:  Enter your hours in the appropriate cells (to the nearest quarter hour, x.00, x.25, x.50, x.75)"]
[null,null,"Step 3:  Print, get signatures and deliver to the Payroll Office as soon as possible"]
[]
[]
[]
[null,null,"Messiah College Staff Timesheet"]
[]
[]
[null,null,"Employee: ",null,null,null,null,null,null,null,null,"ID #:"]
[null,null,null,"      ( Last Name, Legal First Name)"]
[]
[null,null,"start:","Sun","Mon","Tue","Wed","Thur","Fri","Sat","Pay Rate"]
[null,null,{"$f":"TEXT($C$4,\"mmm d, yyyy\")","v":"Mar 31, 2019"},{"$f":"TEXT($C$4,\"d\")","v":"31"},{"$f":"TEXT($C$4+1,\"d\")","v":"1"},{"$f":"TEXT($C$4+2,\"d\")","v":"2"},{"$f":"TEXT($C$4+3,\"d\")","v":"3"},{"$f":"TEXT($C$4+4,\"d\")","v":"4"},{"$f":"TEXT($C$4+5,\"d\")","v":"5"},{"$f":"TEXT($C$4+6,\"d\")","v":"6"},"Regular","Overtime1"]
[null,null,"Regular",null,null,null,null,null,null,null,{"$f":"IF(H65>0,H65,0)","v":0},{"$f":"+SUM(D19:J19)-IF(H65>0,H65,0)","v":0}]
[null,null,"Holiday2",null,null,null,null,null,null,null,{"$f":"IF(N65>0,N65,0)","v":0},{"$f":"+SUM(D20:J20)-IF(N65>0,N65,0)","v":0}]
[null,null,"Closed2",null,null,null,null,null,null,null,{"$f":"IF(K65>0,K65,0)","v":0},{"$f":"+SUM(D21:J21)-IF(K65>0,K65,0)","v":0}]
[null,null,"Sick/Dr. Appt.",null,null,null,null,null,null,null,{"$f":"SUM(D22:J22)","v":0}]
[null,null,"Vacation",null,null,null,null,null,null,null,{"$f":"SUM(D23:J23)","v":0}]
[null,null,"Personal",null,null,null,null,null,null,null,{"$f":"SUM(D24:J24)","v":0}]
[null,null,"Funeral ",null,null,null,null,null,null,null,0]
[null,null,"Emergency2",null,null,null,null,null,null,null,null,{"$f":"SUM(D26:J26)","v":0}]
[null,null,"TOTAL",{"$f":"SUM(D19:D26)","v":0},0,0,0,0,0,0,0,0]
[]
[null,null,"end:","Sun","Mon","Tue","Wed","Thur","Fri","Sat","Pay Rate",null,null,"        Totals"]
[null,null,{"$f":"TEXT($C$4+13,\"mmm d, yyyy\")","v":"Apr 13, 2019"},{"$f":"TEXT($C$4+7,\"d\")","v":"7"},{"$f":"TEXT($C$4+8,\"d\")","v":"8"},{"$f":"TEXT($C$4+9,\"d\")","v":"9"},{"$f":"TEXT($C$4+10,\"d\")","v":"10"},{"$f":"TEXT($C$4+11,\"d\")","v":"11"},{"$f":"TEXT($C$4+12,\"d\")","v":"12"},{"$f":"TEXT($C$4+13,\"d\")","v":"13"},"Regular","Overtime1",null,"Regular","Overtime1"]
[null,null,"Regular",null,null,null,null,null,null,null,{"$f":"IF(H72>0,H72,0)","v":0},{"$f":"+SUM(D31:J31)-IF(H72>0,H72,0)","v":0},"REG",{"$f":"+K31+K19","v":0},{"$f":"+L31+L19","v":0}]
[null,null,"Holiday2",null,null,null,null,null,null,null,{"$f":"IF(N72>0,N72,0)","v":0},{"$f":"+SUM(D32:J32)-IF(N72>0,N72,0)","v":0},"HOL",{"$f":"+K32+K20","v":0},{"$f":"+L20+L32","v":0}]
[null,null,"Closed2",null,null,null,null,null,null,null,{"$f":"IF(K72>0,K72,0)","v":0},{"$f":"+SUM(D33:J33)-IF(K72>0,K72,0)","v":0},"EMG",0,{"$f":"+L21+L33","v":0}]
[null,null,"Sick/Dr. Appt.",null,null,null,null,null,null,null,{"$f":"SUM(D34:J34)","v":0},null,"SCK",0]
[null,null,"Vacation",null,null,null,null,null,null,null,{"$f":"SUM(D35:J35)","v":0},null,"VAC",0]
[null,null,"Personal",null,null,null,null,null,null,null,0,null,"PER",0]
[null,null,"Funeral ",null,null,null,null,null,null,null,0,null,"FUN",0]
[null,null,"Emergency2",null,null,null,null,null,null,null,null,{"$f":"SUM(D38:J38)","v":0},"EME",null,{"$f":"+L38+L26","v":0}]
[null,null,"TOTAL",{"$f":"SUM(D31:D38)","v":0},0,0,0,0,0,0,0,0,null,{"$f":"+K39+K27","v":0},{"$f":"+L27+L39","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+N39+O39","v":0}]
[null,null,"1 Overtime is determined by the total of regular, closed and the larger of holiday or emergency hours."]
[null,null,"2 See the \"Special_Days\" page for instructions on recording holiday, closed and emergency hours."]
[]
[null,null,{"$f":"+D14","v":0},null,null,null,null,"   Enter any unusual hours, adjustments, or comments:"]
[null,null,{"$f":"\"OVT: \"&IF(SUM(O31:O33)>0,TEXT(SUM(O31:O33),\"#0.00\"),\"\")","v":"OVT: "},{"$f":"\"EME: \"&IF(O38>0,TEXT(O38,\"#0.00\"),\"\")","v":"EME: "}]
[null,null,{"$f":"\"PER: \"&IF(N36>0,TEXT(N36,\"#0.00\"),\"\")","v":"PER: "},{"$f":"\"EMG: \"&IF(N33>0,TEXT(N33,\"#0.00\"),\"\")","v":"EMG: "}]
[null,null,{"$f":"\"REG: \"&IF(N31>0,TEXT(N31,\"#0.00\"),\"\")","v":"REG: "},{"$f":"\"FUN: \"&IF(N37>0,TEXT(N37,\"#0.00\"),\"\")","v":"FUN: "}]
[null,null,{"$f":"\"SCK: \"&IF(N34>0,TEXT(N34,\"#0.00\"),\"\")","v":"SCK: "},{"$f":"\"HOL: \"&IF(N32>0,TEXT(N32,\"#0.00\"),\"\")","v":"HOL: "}]
[null,null,{"$f":"\"VAC: \"&IF(N35>0,TEXT(N35,\"#0.00\"),\"\")","v":"VAC: "},{"$f":"\"LOB: \"","v":"LOB: "}]
[null,null,{"$f":"O40","v":0}]
[]
[null,null,"Payroll Deadline:  received in Payroll on TUESDAY after the last day in the period (add 1 day for holidays)."]
[null,null,"Employee Signature ___",null,null,null,null,null,null,null,null,null,null,"Date "]
[]
[null,null,"Approved by ___________________________________ |",null,null,null,null,null,"__________________________",null,null,null,null,"Date "]
[null,null,null,null,"sign name",null,null,null,null,"print name",null,null,null,null,"to Payroll by Tuesday"]
[]
[]
[]
[]
[null,null,"OT & Regular Hrs. Proof Accumulators, Week #1"]
[null,null,"MAX (hol,eme)",{"$f":"IF(D20>0,MAX(D20,D26),D20)","v":0},0,0,0,0,0,0]
[null,null,null,"SUM (reg,max,clo)",{"$f":"SUM(D19:J19,D21:J21,D62:J62)","v":0},null,"SUM reg",{"$f":"SUM(D19:J19)","v":0},null,"SUM clo",{"$f":"SUM(D21:J21)","v":0},null,"SUM hol",{"$f":"SUM(D20:J20)","v":0}]
[null,null,null,"legal limit for regular",40,null,"minus ovt",{"$f":"+E65","v":0},null,"minus ovt",{"$f":"IF(H65<0,ABS(H65),0)","v":0},null,"minus ovt",{"$f":"IF(K65<0,ABS(K65),0)","v":0}]
[null,null,null,"thus, ovt=",{"$f":"IF(E63-E64>0,E63-E64,0)","v":0},null,"calculated reg",{"$f":"H63-H64","v":0},null,"calculated clo",{"$f":"+K63-K64","v":0},null,"calculated hol",{"$f":"+N63-N64","v":0}]
[]
[]
[null,null,"OT & Regular Hrs. Proof Accumulators, Week #2"]
[null,null,"MAX (hol,eme)",{"$f":"IF(D32>0,MAX(D32,D38),D32)","v":0},0,0,0,0,0,0]
[null,null,null,"SUM (reg,max,clo)",{"$f":"SUM(D31:J31,D33:J33,D69:J69)","v":0},null,"SUM reg",{"$f":"SUM(D31:J31)","v":0},null,"SUM clo",{"$f":"SUM(D33:J33)","v":0},null,"SUM hol",{"$f":"SUM(D32:J32)","v":0}]
[null,null,null,"legal limit for regular",40,null,"minus ovt",{"$f":"+E72","v":0},null,"minus ovt",{"$f":"IF(H72<0,ABS(H72),0)","v":0},null,"minus ovt",{"$f":"IF(K72<0,ABS(K72),0)","v":0}]
[null,null,null,"thus, ovt=",{"$f":"IF(E70-E71>0,E70-E71,0)","v":0},null,"calculated reg",{"$f":"+H70-H71","v":0},null,"calculated clo",{"$f":"+K70-K71","v":0},null,"calculated hol",{"$f":"+N70-N71","v":0}]

{"sheet":"Special_Days","index":1,"n_rows":40,"n_cols":5,"rows_kept":40,"cut":false,"hidden":false,"merged":[[10,1,11,1],[14,1,15,1],[16,1,17,1],[18,1,19,1],[36,1,37,1],[32,1,35,1],[26,1,27,1],[30,1,31,1]]}
["- How to Record Hours -"]
["for special types of hours and days"]
[]
["For more information on any of these items or other items not addressed here, please contact the Payroll Office"]
["directly. Additional details are also often available from the Human Resources Policy and Procedure Manual."]
[]
["Essential Employees:"]
["       and Non-Essential employees deemed essential in order to address a college emergency"]
[null,"       "]
[null,"Type of Day","Hours","Record As","Pay Rate"]
[null,"Holiday","regularly scheduled","Holiday","regular"]
[null,null,"worked on holiday","Emergency","time and half"]
[null,"Christmas Closed","regularly scheduled","Closed","regular"]
[null,"(non-holiday days)","worked during closed period","Regular","regular"]
[null,"Emergency Closed","regularly scheduled","Closed","regular"]
[null,null,"worked during closed period","Emergency","time and half"]
[null,"Called in for Emergency","regularly scheduled","(not applicable)","--"]
[null,null,"worked","Emergency","time and half"]
[null,"Jury Duty","regularly scheduled","Regular","regular"]
[null,null,"worked","(not possible)","--"]
["NOTE:  Essential employees unable to work will be required to use personal time or vacation time."]
["NOTE:  For reference, also indicate the days for jury duty in the comments section."]
[]
["Non-Essential Employees:"]
[]
[null,"Type of Day","Hours","Record As","Pay Rate"]
[null,"Holiday","regularly scheduled","Holiday","regular"]
[null,null,"worked on holiday","(do not record)","--"]
[null,"Christmas Closed","regularly scheduled","Closed","regular"]
[null,"(non-holiday days)","worked during closed period","(do not record)","--"]
[null,"Emergency Closed","regularly scheduled","Closed","regular"]
[null,null,"worked during closed period","(do not record)","--"]
[null,"Called in for Emergency","Due to the type of College emergency, a non-essential"]
[null,null,"employee can be deemed essential to address the"]
[null,null,"emergency. If this occurs, record hours according to"]
[null,null,"the Essential Employees chart found above."]
[null,"Jury Duty","regularly scheduled","Regular","regular"]
[null,null,"worked","(not possible)","--"]
["NOTE:  Total reported hours for the day should not exceed the employee's regularly scheduled hours."]
["NOTE:  For reference, also indicate the days for jury duty in the comments section."]