{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Timesheet Document","Timekeeping Instructions","Pay Period Date Lookup"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"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":"Timesheet Document","index":0,"n_rows":43,"n_cols":10,"rows_kept":43,"cut":false,"hidden":false,"merged":[[39,1,39,9],[5,0,5,3],[17,8,17,9],[29,8,29,9],[0,2,2,9],[3,2,4,9],[19,2,19,7],[7,2,7,7],[36,4,36,5],[35,6,35,9],[36,6,36,8],[35,4,35,5],[34,0,34,9]]}
["Department",null,"Timekeeping Document"]
["Employee Name"]
["Employee Number\n (i.e. W0000999999)\nOPTIONAL"]
["Enter the \nFirst Day of the Pay Period","2020-08-09","For use during administrative furlough"]
["Pay Period End Date",{"$f":"VLOOKUP(B4,'Pay Period Date Lookup'!A2:D26,4,FALSE)","v":"2020-08-22"}]
["Insert a \"Y\" in the cell indidcating week(s) furlough hours were used.\nInsert a \"N\" in the cell indidcating week(s) furlough hours were not used.",null,null,null,"Week 1","Y","Week 2","Y"]
[]
["Pay Period Start Date\nWeek 1",{"$f":"VLOOKUP(B4,'Pay Period Date Lookup'!A2:D26,2,FALSE)","v":"2020-08-09"},"Enter hours in the fields below"]
[null,"Day of Week","Reg Hours","Overtime Hours","Furlough","Sick","Vacation","Holiday","Total Hours Reported","Total Hours Paid"]
[null,{"$f":"+B8","v":"2020-08-09"},0,null,0,0,0,0,{"$f":"SUM(C10:H10)","v":0},{"$f":"+I10-E10","v":0}]
[null,{"$f":"+B10+1","v":"2020-08-10"},0,null,0,0,0,0,{"$f":"SUM(C11:H11)","v":0},{"$f":"+I11-E11","v":0}]
[null,{"$f":"+B11+1","v":"2020-08-11"},0,null,0,0,0,0,0,0]
[null,"2020-08-12",0,null,0,0,0,0,0,0]
[null,"2020-08-13",0,null,0,0,0,0,0,0]
[null,"2020-08-14",0,null,0,0,0,0,0,0]
[null,"2020-08-15",0,null,0,0,0,0,0,0]
[null,"Week 1 Total",{"$f":"SUM(C10:C16)","v":0},{"$f":"+IF(C17>40,C17-40,0)","v":0},{"$f":"SUM(E10:E16)","v":0},0,0,0,{"$f":"SUM(I10:I16)","v":0},{"$f":"SUM(J10:J16)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"+IF(AND(E17>0,+I17>40),\"Total hours cannot exceed 40 when furlough hours are reported\",\"Valid\")","v":"Valid"}]
[]
["Pay Period Start Date\nWeek 2",{"$f":"VLOOKUP(B4,'Pay Period Date Lookup'!A2:D26,3,FALSE)","v":"2020-08-16"},"Enter hours in the fields below"]
[null,"Day of Week","Reg Hours","Overtime Hours","Furlough","Sick","Vacation","Holiday","Total Hours Reported","Total Hours Paid"]
[null,{"$f":"+B20","v":"2020-08-16"},0,null,0,0,0,0,{"$f":"SUM(C22:H22)","v":0},{"$f":"+I22-E22","v":0}]
[null,{"$f":"+B22+1","v":"2020-08-17"},0,null,0,0,0,0,{"$f":"SUM(C23:H23)","v":0},0]
[null,{"$f":"+B23+1","v":"2020-08-18"},0,null,0,0,0,0,0,0]
[null,"2020-08-19",0,null,0,0,0,0,0,0]
[null,"2020-08-20",0,null,0,0,0,0,0,0]
[null,"2020-08-21",0,null,0,0,0,0,0,0]
[null,"2020-08-22",0,null,0,0,0,0,0,0]
[null,"Week 2 Total",{"$f":"SUM(C22:C28)","v":0},{"$f":"+IF(C29>40,C29-40,0)","v":0},{"$f":"SUM(E22:E28)","v":0},{"$f":"SUM(F22:F28)","v":0},{"$f":"SUM(G22:G28)","v":0},{"$f":"SUM(H22:H28)","v":0},{"$f":"SUM(I22:I28)","v":0},{"$f":"SUM(J22:J28)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"+IF(AND(E29>0,+I29>40),\"Total hours cannot exceed 40 when furlough hours are reported\",\"Valid\")","v":"Valid"}]
[]
[null,"Totals","Reg Hours","Overtime Hours","Furlough","Sick","Vacation","Holiday","Total Hours Reported","Total Hours Paid"]
[null,null,{"$f":"+C29","v":0},{"$f":"+D29","v":0},0,0,0,0,{"$f":"+I29","v":0},{"$f":"+J29","v":0}]
[]
["By signing below, I certify that, to the best of my knowledge, the information provided on this timesheet document is true and correct. "]
["Employee's Signature",null,null,null,"Supervisor's Signature"]
["Date",null,null,null,"Date"]
[]
[]
[null,"Example - Time must be entered as displayed the example below"]
[null,"Day of Week","Reg Hours","Overtime Hours","Furlough","Sick","Vacation","Holiday","Total Hours Reported","Total Hours Paid"]
[null,"Day / Date",8,null,null,null,null,null,{"$f":"SUM(C42:H42)","v":8},{"$f":"+I42-E42","v":8}]
[null,"Day / Date",null,null,7,null,null,null,7,0]

{"sheet":"Timekeeping Instructions","index":1,"n_rows":24,"n_cols":2,"rows_kept":24,"cut":false,"hidden":false,"merged":[[14,0,14,1],[7,1,7,9],[8,1,8,9],[0,0,0,9],[1,1,1,9],[2,1,2,9],[3,1,3,9],[4,1,4,9],[5,0,6,0],[5,1,6,9],[9,1,9,9],[10,1,10,9],[11,1,11,9],[12,1,12,9],[13,0,13,1],[26,0,26,1],[15,0,15,9],[16,0,16,9],[17,0,17,9],[18,0,18,9],[19,0,19,9],[20,0,20,9],[21,0,21,9],[22,0,22,1],[23,0,23,9],[24,0,24,1],[25,0,25,1]]}
["Timekeeping Instructions"]
["1.","Enter your departme name or number."]
["2.","Enter your full name."]
["3.","Enter your employee number, if known (i.e. W0000999999)"]
["4.","Use the drop down menu to select the first day of the pay period for which the timesheet covers. The Pay Period End Date will automatically populate. "]
["5.","Indicate to the right of \"Week 1\" and \"Week 2\", of the pay period, if furlough time was used. Input a \"Y\" for the week(s) furlough time was used and \"N\" for week(s) furlough time was not used.\n"]
[]
[null,"Only the the week(s) with a \"Y\" will display for time to be entered.\n\n\neKs will be displayed for those with administrative furlough. There is no need to record hours for weeks without administrative furlough."]
["6.","Use the Reg hours column to enter total hours worked for each day. Round to the nearest quarter hour (i.e. 7 hours, 4 minutes would be 7 hours while 7 hours, 11 minutes would be 7.25 hours)."]
[null,"Overtime hours (column D) will automatically populate if needed but should not be needed during weeks with administrative furlough."]
["7.","Use columns E through H to record various types of leave hours. Furlough hours should be recorded in 8 hour increments, ONLY. Other leave types may be recorded in 1 hour increments."]
["8.","Repeat if necessary for any week with administrative furlough. Each timesheet document may only be used for one pay period."]
["9.","Both the employee and their supervisor must sign and date the timesheet document. "]
[]
[]
["Important Considerations"]
["All hours worked must be recorded."]
["All time, including unpaid and paid leave hours, must be recorded."]
["Hours worked + leave taken must not exceed 40 hours per week."]
["It is the employee's responsibility to sign their timesheet document to certify the accuracy of all time recorded. The employee's supervisor will sign to verify and approve the timesheet document."]
["Altering, falsiying, or tampering with time records or recording time on another employee's time record may result in disciplary action, up to and including termination of employment. "]
["Any changes made to the timesheet by the supervisor must be acknowledged by the employee that the changes are valid and are a true representation of all the time worked. "]
[]
["For more information, please reference K-State's PPM 4220"]

{"sheet":"Pay Period Date Lookup","index":2,"n_rows":26,"n_cols":4,"rows_kept":26,"cut":false,"hidden":true,"merged":[]}
["Pay Period Start","Week 1 Start Date","Week 2 Start Date","Pay Period End Date"]
["2020-08-09",{"$f":"A2","v":"2020-08-09"},{"$f":"+A2+7","v":"2020-08-16"},{"$f":"+A2+13","v":"2020-08-22"}]
[{"$f":"+A2+14","v":"2020-08-23"},{"$f":"A3","v":"2020-08-23"},"2020-08-30","2020-09-05"]
[{"$f":"+A3+14","v":"2020-09-06"},"2020-09-06","2020-09-13","2020-09-19"]
["2020-09-20","2020-09-20","2020-09-27","2020-10-03"]
["2020-10-04","2020-10-04","2020-10-11","2020-10-17"]
["2020-10-18","2020-10-18","2020-10-25","2020-10-31"]
["2020-11-01","2020-11-01","2020-11-08","2020-11-14"]
["2020-11-15","2020-11-15","2020-11-22","2020-11-28"]
["2020-11-29","2020-11-29","2020-12-06","2020-12-12"]
["2020-12-13","2020-12-13","2020-12-20","2020-12-26"]
["2020-12-27","2020-12-27","2021-01-03","2021-01-09"]
["2021-01-10","2021-01-10","2021-01-17","2021-01-23"]
["2021-01-24","2021-01-24","2021-01-31","2021-02-06"]
["2021-02-07","2021-02-07","2021-02-14","2021-02-20"]
["2021-02-21","2021-02-21","2021-02-28","2021-03-06"]
["2021-03-07","2021-03-07","2021-03-14","2021-03-20"]
["2021-03-21","2021-03-21","2021-03-28","2021-04-03"]
["2021-04-04","2021-04-04","2021-04-11","2021-04-17"]
["2021-04-18","2021-04-18","2021-04-25","2021-05-01"]
["2021-05-02","2021-05-02","2021-05-09","2021-05-15"]
["2021-05-16","2021-05-16","2021-05-23","2021-05-29"]
["2021-05-30","2021-05-30","2021-06-06","2021-06-12"]
["2021-06-13","2021-06-13","2021-06-20","2021-06-26"]
["2021-06-27","2021-06-27","2021-07-04","2021-07-10"]
["2021-07-11","2021-07-11","2021-07-18","2021-07-24"]