{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Time Card"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":7,"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 Card","index":0,"n_rows":34,"n_cols":8,"rows_kept":34,"cut":false,"hidden":false,"merged":[[28,3,28,6],[30,3,30,6],[6,2,6,3],[6,6,6,7],[23,1,27,7],[5,1,5,7],[18,1,18,2],[19,1,19,2],[8,2,8,3],[8,6,8,7],[7,2,7,3],[7,6,7,7]]}
[]
[]
[]
[]
[]
[null,"Exempt Staff Leave Attendance Time Card"]
[null,"Employee",null,null,null,"Supervisor:"]
[null,"Work Area",null,null,null,"A# of Employee IF Known"]
[null,"Week ending:",null,null,null,"Scheduled Hours per week",40]
[]
[null,"Day","Date","Regular Worked Hours","Paid Leave Used","Leave Without Pay (LWOP) Used","Holiday","Total Daily Hours"]
[null,{"$f":"IFERROR(TEXT(TimeCard[[#This Row],[Date]],\"aaaa\"), \"\")","v":""},{"$f":"IFERROR(IF($C$9=0,\"\",$C$9-6), \"\")","v":""},null,null,null,null,{"$f":"IFERROR(IF(SUM(D12:G12)>24,\"Total > 24 hours.\",SUM(D12:G12)-TimeCard[[#This Row],[Leave Without Pay (LWOP) Used]]), \"\")","v":0}]
[null,{"$f":"IFERROR(TEXT(TimeCard[[#This Row],[Date]],\"aaaa\"), \"\")","v":""},{"$f":"IFERROR(IF($C$9=0,\"\",$C$9-5), \"\")","v":""},null,null,null,null,{"$f":"IFERROR(IF(SUM(D13:G13)>24,\"Total > 24 hours.\",SUM(D13:G13)-TimeCard[[#This Row],[Leave Without Pay (LWOP) Used]]), \"\")","v":0}]
[null,{"$f":"IFERROR(TEXT(TimeCard[[#This Row],[Date]],\"aaaa\"), \"\")","v":""},{"$f":"IFERROR(IF($C$9=0,\"\",$C$9-4), \"\")","v":""},null,null,null,null,{"$f":"IFERROR(IF(SUM(D14:G14)>24,\"Total > 24 hours.\",SUM(D14:G14)-TimeCard[[#This Row],[Leave Without Pay (LWOP) Used]]), \"\")","v":0}]
[null,{"$f":"IFERROR(TEXT(TimeCard[[#This Row],[Date]],\"aaaa\"), \"\")","v":""},{"$f":"IFERROR(IF($C$9=0,\"\",$C$9-3), \"\")","v":""},null,null,null,null,{"$f":"IFERROR(IF(SUM(D15:G15)>24,\"Total > 24 hours.\",SUM(D15:G15)-TimeCard[[#This Row],[Leave Without Pay (LWOP) Used]]), \"\")","v":0}]
[null,{"$f":"IFERROR(TEXT(TimeCard[[#This Row],[Date]],\"aaaa\"), \"\")","v":""},{"$f":"IFERROR(IF($C$9=0,\"\",$C$9-2), \"\")","v":""},null,null,null,null,{"$f":"IFERROR(IF(SUM(D16:G16)>24,\"Total > 24 hours.\",SUM(D16:G16)-TimeCard[[#This Row],[Leave Without Pay (LWOP) Used]]), \"\")","v":0}]
[null,{"$f":"IFERROR(TEXT(TimeCard[[#This Row],[Date]],\"aaaa\"), \"\")","v":""},{"$f":"IFERROR(IF($C$9=0,\"\",$C$9-1), \"\")","v":""},null,null,null,null,{"$f":"IFERROR(IF(SUM(D17:G17)>24,\"Total > 24 hours.\",SUM(D17:G17)-TimeCard[[#This Row],[Leave Without Pay (LWOP) Used]]), \"\")","v":0}]
[null,{"$f":"IFERROR(TEXT(TimeCard[[#This Row],[Date]],\"aaaa\"), \"\")","v":""},{"$f":"IFERROR(IF($C$9=0,\"\",$C$9), \"\")","v":""},null,null,null,null,{"$f":"IFERROR(IF(SUM(D18:G18)>24,\"Total > 24 hours.\",SUM(D18:G18)-TimeCard[[#This Row],[Leave Without Pay (LWOP) Used]]), \"\")","v":0}]
[null,"Total hours",null,null,null,null,null,{"$f":"IFERROR(SUM(H12:H18), \"\")","v":0}]
[null,"Hours over scheduled hours per week",null,null,null,null,null,{"$f":"IF(H19-G9 >0,H19-G9,0)","v":0}]
[]
[null,"Supervisor Emails the completed form to the HRS Leave Admin DL *IF* Overtime Pay or Straight Pay is owed the Employee."]
[null,"Supervisor RETAINS their Employee's completed forms. "]
[null,"Instructions:  Supervisors are responsible for the accuracy of this form.  Supervisors collect this form from each of their (normally) overtime exempt staff FOR WEEKS WHEN THE EMPLOYEE USES Mandatory Furlough Leave Without Pay (Furlough LWOP).  Supervisors retain this record for state or college audit purposes and shall email only those weeks when an employee surpasses scheduled hours resulting additional straight pay or overtime pay."]
[]
[]
[]
[]
[]
[null,null,null,"Employee signature",null,null,null,"Date"]
[]
[null,null,null,"Manager signature",null,null,null,"Date"]
[]
[null,null,null,null,null,null,null,"Exempt_Staff_Leave_Attendance_Record_2020_07ver1.xlsm"]