{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Time Sheet"],"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":"Time Sheet","index":0,"n_rows":54,"n_cols":27,"rows_kept":54,"cut":false,"hidden":false,"merged":[[38,9,46,14],[8,9,12,14],[13,9,18,14],[19,9,22,14],[23,9,25,14],[26,9,31,14],[32,9,37,14],[0,12,0,13],[2,5,2,9],[2,1,2,2],[4,10,4,13],[6,10,6,11],[2,10,2,13],[6,2,6,4],[4,5,4,9],[6,5,6,9],[4,1,4,3],[53,3,53,9],[49,12,49,13],[51,12,51,13],[49,3,49,9],[51,3,51,9]]}
["BRYN MAWR COLLEGE STUDENT TIME SHEET",null,null,null,null,null,null,null,null,null,null,"PAY PERIOD ENDING DATE:",null,null,"v1.51"]
[]
["ID:",null,null,null,null,"DEPARTMENT NAME:"]
[]
["NAME:",null,null,null,null,"16-DIGIT ACCOUNT:"]
[]
[null,null,null,null,null,"RATE OF PAY:"]
[]
["Record Time In and Time Out for each day worked.",null,null,null,null,null,null,null,null,"Identification:\nYour 7 digit BMC ID number (Haverford ID’s are not accepted), Legal Name (no nicknames), 16-digit Account Code and Rate of Pay are required.  If you do not have this information, ask your supervisor.  If you currently have multiple jobs, a separate time sheet must be completed for each of your jobs for each pay period for which you are submitting hours."]
["Week 1","Date","Time In","Time Out","Regular","Overtime","Sick","Prem",null,null,null,null,null,null,null,null,"worked","cumulative","ot cumul",null,null,"start calc","out hour",null,null,null,"pay period"]
[null,{"$f":"IF($M$1=\"\",\"\",IF(A11=\"Wed\",$M$1-13,IF(A11=\"Thurs\",$M$1-12,IF(A11=\"Fri\",$M$1-11,IF(A11=\"Sat\",$M$1-10,IF(A11=\"Sun\",$M$1-9,IF(A11=\"Mon\",$M$1-8,IF(A11=\"Tues\",$M$1-7,\"\"))))))))","v":""},null,null,{"$f":"Q11","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(IF(V11=0,0,W11+MINUTE(D11)/60-HOUR(C11)-MINUTE(C11)/60), 2)","v":0},{"$f":"Q11","v":0},null,null,null,{"$f":"IF(C11<>\"\", IF(D11 <> \"\", 1, 0), 0)","v":0},{"$f":"IF(V11=1,IF(D11=\"\",0,IF(HOUR(C11)>HOUR(D11),HOUR(D11)+24,HOUR(D11))),0)","v":0},null,null,"Wed",{"$f":"DATEVALUE(TEXT(TODAY(), \"mm/dd/yyyy\")) + 14 - MOD((DATEVALUE(TEXT(TODAY(), \"mm/dd/yyyy\")) - DATEVALUE(\"1/12/2010\")), 14)","v":"2022-09-20"}]
[null,{"$f":"IF($M$1=\"\",\"\",IF(A12=\"Wed\",$M$1-13,IF(A12=\"Thurs\",$M$1-12,IF(A12=\"Fri\",$M$1-11,IF(A12=\"Sat\",$M$1-10,IF(A12=\"Sun\",$M$1-9,IF(A12=\"Mon\",$M$1-8,IF(A12=\"Tues\",$M$1-7,\"\"))))))))","v":""},null,null,{"$f":"IF(Q12=0,0,Q12-F12)","v":0},{"$f":"IF(Q12=0,0,IF(R12>40,R12-40-S11,0))","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(IF(V12=0,0,W12+MINUTE(D12)/60-HOUR(C12)-MINUTE(C12)/60), 2)","v":0},{"$f":"R11+Q12","v":0},{"$f":"S11+IF(R12>40,R12-40-S11,0)","v":0},null,null,{"$f":"IF(C12<>\"\", IF(D12 <> \"\", 1, 0), 0)","v":0},{"$f":"IF(V12=1,IF(D12=\"\",0,IF(HOUR(C12)>HOUR(D12),HOUR(D12)+24,HOUR(D12))),0)","v":0},null,null,"Thurs",{"$f":"AA11-14","v":"2022-09-06"}]
[null,"",null,null,{"$f":"IF(Q13=0,0,Q13-F13)","v":0},{"$f":"IF(Q13=0,0,IF(R13>40,R13-40-S12,0))","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(IF(V13=0,0,W13+MINUTE(D13)/60-HOUR(C13)-MINUTE(C13)/60), 2)","v":0},{"$f":"R12+Q13","v":0},0,null,null,0,0,null,null,"Fri",{"$f":"AA12-14","v":"2022-08-23"}]
[null,"",null,null,0,0,null,null,null,"Recording Date and Time: \nEnter the period ending date according to the payroll schedule.  You will need to complete a separate time sheet if you need to submit hours from a prior pay period.  When entering the dates worked, simply choose the day of the week you worked and the date will be automatically populated for you.  Time should be recorded by using numbers 1 to 12 to identify the hours in a day and 01 through 59 to identify the minutes in a day and indicate AM or PM (Please remember that noon is 12 PM).",null,null,null,null,null,null,0,0,0,null,null,0,0,null,null,"Sat","2022-08-09"]
[null,"",null,null,0,0,null,null,null,null,null,null,null,null,null,null,0,0,0,null,null,0,0,null,null,"Sun","2022-07-26"]
[null,"",null,null,0,0,null,null,null,null,null,null,null,null,null,null,0,0,0,null,null,0,0,null,null,"Mon","2022-07-12"]
[null,"",null,null,0,0,null,null,null,null,null,null,null,null,null,null,0,0,0,null,null,0,0,null,null,"Tues","2022-06-28"]
[null,"",null,null,0,0,null,null,null,null,null,null,null,null,null,null,0,0,0,null,null,0,0,null,null,null,"2022-06-14"]
[null,"",null,null,0,0,null,null,null,null,null,null,null,null,null,null,0,0,0,null,null,0,0,null,null,null,"2022-05-31"]
[null,"",null,null,0,0,null,null,null,"Recording Time In and Out and Hours Worked: \nYou are required to record your time in and out for each day worked.  If you take multiple breaks during any given day, you must add it on a new line by choosing the same day of the week. The hours per day will be automatically calculated for you.",null,null,null,null,null,null,0,0,0,null,null,0,0,null,null,null,"2022-05-17"]
[null,"",null,null,0,0,null,null,null,null,null,null,null,null,null,null,0,0,0,null,null,0,0,null,null,null,"2022-05-03"]
[null,"",null,null,0,0,null,null,null,null,null,null,null,null,null,null,0,0,0,null,null,0,0,null,null,null,"2022-04-19"]
[null,"",null,null,0,0,null,null,null,null,null,null,null,null,null,null,0,0,0,null,null,0,0,null,null,null,"2022-04-05"]
[null,"",null,null,0,0,null,null,null,"Recording Overtime Hours: \nOvertime does not occur until your hours exceed forty hours in a work week.  When overtime is applicable, Excel will calculate it automatically.",null,null,null,null,null,null,0,0,0,null,null,0,0,null,null,null,"2022-03-22"]
[null,"",null,null,0,0,null,null,null,null,null,null,null,null,null,null,0,0,0,null,null,0,0,null,null,null,"2022-03-08"]
["Subtotal Week 1:",null,null,null,{"$f":"SUM(E11:E25)","v":0},{"$f":"SUM(F12:F25)","v":0},{"$f":"SUM(G11:G25)","v":0},{"$f":"SUM(H11:H25)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2022-02-22"]
[null,null,null,null,null,null,null,null,null,"Recording Sick Hours:\nEligible students are allotted a maximum of 5 hours of paid sick time that can be taken between July 1 -December 31 and another 5 hours of paid sick time that can be taken between January 1-June 30.  Only students who work or are expected to work a minimum of 75 hours during the designated 6-month period are eligible for paid sick leave.  Students are required to track their use of their paid sick leave.  Record your scheduled hours that are eligible in the Sick column.\n",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2022-02-08"]
["Week 2","Date","Time In","Time Out","Regular","Overtime","Sick","Prem",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2022-01-25"]
[null,{"$f":"IF($M$1=\"\",\"\",IF(A29=\"Wed\",$M$1-6,IF(A29=\"Thurs\",$M$1-5,IF(A29=\"Fri\",$M$1-4,IF(A29=\"Sat\",$M$1-3,IF(A29=\"Sun\",$M$1-2,IF(A29=\"Mon\",$M$1-1,IF(A29=\"Tues\",$M$1,\"\"))))))))","v":""},null,null,{"$f":"Q29","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(IF(V29=0,0,W29+MINUTE(D29)/60-HOUR(C29)-MINUTE(C29)/60), 2)","v":0},{"$f":"Q29","v":0},null,null,null,{"$f":"IF(C29<>\"\", IF(D29 <> \"\", 1, 0), 0)","v":0},{"$f":"IF(V29=1,IF(D29=\"\",0,IF(HOUR(C29)>HOUR(D29),HOUR(D29)+24,HOUR(D29))),0)","v":0},null,null,null,"2022-01-11"]
[null,{"$f":"IF($M$1=\"\",\"\",IF(A30=\"Wed\",$M$1-6,IF(A30=\"Thurs\",$M$1-5,IF(A30=\"Fri\",$M$1-4,IF(A30=\"Sat\",$M$1-3,IF(A30=\"Sun\",$M$1-2,IF(A30=\"Mon\",$M$1-1,IF(A30=\"Tues\",$M$1,\"\"))))))))","v":""},null,null,{"$f":"IF(Q30=0,0,Q30-F30)","v":0},{"$f":"IF(Q30=0,0,IF(R30>40,R30-40-S29,0))","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(IF(V30=0,0,W30+MINUTE(D30)/60-HOUR(C30)-MINUTE(C30)/60), 2)","v":0},{"$f":"R29+Q30","v":0},{"$f":"S29+IF(R30>40,R30-40-S29,0)","v":0},null,null,0,0,null,null,null,"2021-12-28"]
[null,"",null,null,{"$f":"IF(Q31=0,0,Q31-F31)","v":0},{"$f":"IF(Q31=0,0,IF(R31>40,R31-40-S30,0))","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(IF(V31=0,0,W31+MINUTE(D31)/60-HOUR(C31)-MINUTE(C31)/60), 2)","v":0},0,0,null,null,0,0,null,null,null,"2021-12-14"]
[null,"",null,null,0,0,null,null,null,null,null,null,null,null,null,null,0,0,0,null,null,0,0,null,null,null,"2021-11-30"]
[null,"",null,null,0,0,null,null,null,"Recording Premium Hours: \nStudents required to work during a student-focused campus-wide event should report their hours worked under student premium pay (SPP).  For May Day all hours worked are eligible for SPP.  For Fall Convocation & Picnic hours worked between 4-8pm are eligible for SPP. For Pre-Winter Break Holiday Dinner hours worked between 4-8pm are eligible for SPP.  Record your scheduled hours that are eligible in the Premium column.",null,null,null,null,null,null,0,0,0,null,null,0,0,null,null,null,"2021-11-16"]
[null,"",null,null,0,0,null,null,null,null,null,null,null,null,null,null,0,0,0,null,null,0,0,null,null,null,"2021-11-02"]
[null,"",null,null,0,0,null,null,null,null,null,null,null,null,null,null,0,0,0,null,null,0,0,null,null,null,"2021-10-19"]
[null,"",null,null,0,0,null,null,null,null,null,null,null,null,null,null,0,0,0,null,null,0,0,null,null,null,"2021-10-05"]
[null,"",null,null,0,0,null,null,null,null,null,null,null,null,null,null,0,0,0,null,null,0,0,null,null,null,"2021-09-21"]
[null,"",null,null,0,0,null,null,null,null,null,null,null,null,null,null,0,0,0,null,null,0,0]
[null,"",null,null,0,0,null,null,null,"Signatures: \nWhen your time sheet has been completed, print it, sign it and give it to your supervisor for his/her signature.  Save a copy for your records.\n\nYour signed time sheet must then be sent to campus box 1680 A or via campus mail to the Payroll Office.\n\nYour signature indicates that you agree that the totaled hours are correct as recorded on your time sheet.\n\nYour supervisor’s signature is necessary to authorize payment for your hours.  Your time sheet will not be processed without your supervisor’s signature.",null,null,null,null,null,null,0,0,0,null,null,0,0]
[null,"",null,null,0,0,null,null,null,null,null,null,null,null,null,null,0,0,0,null,null,0,0]
[null,"",null,null,0,0,null,null,null,null,null,null,null,null,null,null,0,0,0,null,null,0,0]
[null,"",null,null,0,0,null,null,null,null,null,null,null,null,null,null,0,0,0,null,null,0,0]
[null,"",null,null,0,0,null,null,null,null,null,null,null,null,null,null,0,0,{"$f":"IF(Q43=0,0,S42+F43)","v":0},null,null,0,0]
["Subtotal Week 2:",null,null,null,{"$f":"SUM(E29:E43)","v":0},{"$f":"SUM(F30:F43)","v":0},{"$f":"SUM(G29:G43)","v":0},{"$f":"SUM(H29:H43)","v":0}]
[]
["Grand Totals:",null,null,null,{"$f":"E26+E44","v":0},{"$f":"F26+F44","v":0},{"$f":"G26+G44","v":0},{"$f":"H26+H44","v":0}]
[]
["Pay Period Total Hours:",null,null,{"$f":"E46+F46+G46+H46","v":0}]
[]
["Employee Signature:",null,null,null,null,null,null,null,null,null,null,"Date:"]
[]
["Supervisor Signature:",null,null,null,null,null,null,null,null,null,null,"Date:"]
[]
["Supervisor's Printed Name:"]