{"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":26,"rows_kept":54,"cut":false,"hidden":false,"merged":[[53,3,53,8],[49,11,49,12],[51,11,51,12],[49,3,49,8],[51,3,51,8],[0,11,0,12],[2,5,2,8],[2,1,2,2],[4,9,4,12],[6,9,6,10],[2,9,2,12],[6,2,6,4],[4,5,4,8],[6,5,6,8],[4,1,4,3],[8,8,14,13],[32,8,36,13],[37,8,47,13],[23,8,27,13],[28,8,30,13],[15,8,22,13]]}
["BRYN MAWR COLLEGE STUDENT TIME SHEET",null,null,null,null,null,null,null,null,null,"PAY PERIOD ENDING DATE:",null,null,"v1.41"]
[]
["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,"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",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($L$1=\"\",\"\",IF(A11=\"Wed\",$L$1-13,IF(A11=\"Thurs\",$L$1-12,IF(A11=\"Fri\",$L$1-11,IF(A11=\"Sat\",$L$1-10,IF(A11=\"Sun\",$L$1-9,IF(A11=\"Mon\",$L$1-8,IF(A11=\"Tues\",$L$1-7,\"\"))))))))","v":""},null,null,{"$f":"P11","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(IF(U11=0,0,V11+MINUTE(D11)/60-HOUR(C11)-MINUTE(C11)/60), 2)","v":0},{"$f":"P11","v":0},null,null,null,{"$f":"IF(C11<>\"\", IF(D11 <> \"\", 1, 0), 0)","v":0},{"$f":"IF(U11=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":"2021-09-07"}]
[null,{"$f":"IF($L$1=\"\",\"\",IF(A12=\"Wed\",$L$1-13,IF(A12=\"Thurs\",$L$1-12,IF(A12=\"Fri\",$L$1-11,IF(A12=\"Sat\",$L$1-10,IF(A12=\"Sun\",$L$1-9,IF(A12=\"Mon\",$L$1-8,IF(A12=\"Tues\",$L$1-7,\"\"))))))))","v":""},null,null,{"$f":"IF(P12=0,0,P12-F12)","v":0},{"$f":"IF(P12=0,0,IF(Q12>40,Q12-40-R11,0))","v":0},null,null,null,null,null,null,null,null,null,{"$f":"ROUND(IF(U12=0,0,V12+MINUTE(D12)/60-HOUR(C12)-MINUTE(C12)/60), 2)","v":0},{"$f":"Q11+P12","v":0},{"$f":"R11+IF(Q12>40,Q12-40-R11,0)","v":0},null,null,{"$f":"IF(C12<>\"\", IF(D12 <> \"\", 1, 0), 0)","v":0},{"$f":"IF(U12=1,IF(D12=\"\",0,IF(HOUR(C12)>HOUR(D12),HOUR(D12)+24,HOUR(D12))),0)","v":0},null,null,"Thurs",{"$f":"Z11-14","v":"2021-08-24"}]
[null,"",null,null,{"$f":"IF(P13=0,0,P13-F13)","v":0},{"$f":"IF(P13=0,0,IF(Q13>40,Q13-40-R12,0))","v":0},null,null,null,null,null,null,null,null,null,{"$f":"ROUND(IF(U13=0,0,V13+MINUTE(D13)/60-HOUR(C13)-MINUTE(C13)/60), 2)","v":0},{"$f":"Q12+P13","v":0},0,null,null,0,0,null,null,"Fri",{"$f":"Z12-14","v":"2021-08-10"}]
[null,"",null,null,0,0,null,null,null,null,null,null,null,null,null,0,0,0,null,null,0,0,null,null,"Sat","2021-07-27"]
[null,"",null,null,0,0,null,null,null,null,null,null,null,null,null,0,0,0,null,null,0,0,null,null,"Sun","2021-07-13"]
[null,"",null,null,0,0,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,"Mon","2021-06-29"]
[null,"",null,null,0,0,null,null,null,null,null,null,null,null,null,0,0,0,null,null,0,0,null,null,"Tues","2021-06-15"]
[null,"",null,null,0,0,null,null,null,null,null,null,null,null,null,0,0,0,null,null,0,0,null,null,null,"2021-06-01"]
[null,"",null,null,0,0,null,null,null,null,null,null,null,null,null,0,0,0,null,null,0,0,null,null,null,"2021-05-18"]
[null,"",null,null,0,0,null,null,null,null,null,null,null,null,null,0,0,0,null,null,0,0,null,null,null,"2021-05-04"]
[null,"",null,null,0,0,null,null,null,null,null,null,null,null,null,0,0,0,null,null,0,0,null,null,null,"2021-04-20"]
[null,"",null,null,0,0,null,null,null,null,null,null,null,null,null,0,0,0,null,null,0,0,null,null,null,"2021-04-06"]
[null,"",null,null,0,0,null,null,null,null,null,null,null,null,null,0,0,0,null,null,0,0,null,null,null,"2021-03-23"]
[null,"",null,null,0,0,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,"2021-03-09"]
[null,"",null,null,0,0,null,null,null,null,null,null,null,null,null,0,0,0,null,null,0,0,null,null,null,"2021-02-23"]
["Subtotal Week 1:",null,null,null,{"$f":"SUM(E11:E25)","v":0},{"$f":"SUM(F12:F25)","v":0},{"$f":"SUM(G11:G25)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-02-09"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-01-26"]
["Week 2","Date","Time In","Time Out","Regular","Overtime","Sick",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-01-12"]
[null,{"$f":"IF($L$1=\"\",\"\",IF(A29=\"Wed\",$L$1-6,IF(A29=\"Thurs\",$L$1-5,IF(A29=\"Fri\",$L$1-4,IF(A29=\"Sat\",$L$1-3,IF(A29=\"Sun\",$L$1-2,IF(A29=\"Mon\",$L$1-1,IF(A29=\"Tues\",$L$1,\"\"))))))))","v":""},null,null,{"$f":"P29","v":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,{"$f":"ROUND(IF(U29=0,0,V29+MINUTE(D29)/60-HOUR(C29)-MINUTE(C29)/60), 2)","v":0},{"$f":"P29","v":0},null,null,null,{"$f":"IF(C29<>\"\", IF(D29 <> \"\", 1, 0), 0)","v":0},{"$f":"IF(U29=1,IF(D29=\"\",0,IF(HOUR(C29)>HOUR(D29),HOUR(D29)+24,HOUR(D29))),0)","v":0},null,null,null,"2020-12-29"]
[null,{"$f":"IF($L$1=\"\",\"\",IF(A30=\"Wed\",$L$1-6,IF(A30=\"Thurs\",$L$1-5,IF(A30=\"Fri\",$L$1-4,IF(A30=\"Sat\",$L$1-3,IF(A30=\"Sun\",$L$1-2,IF(A30=\"Mon\",$L$1-1,IF(A30=\"Tues\",$L$1,\"\"))))))))","v":""},null,null,{"$f":"IF(P30=0,0,P30-F30)","v":0},{"$f":"IF(P30=0,0,IF(Q30>40,Q30-40-R29,0))","v":0},null,null,null,null,null,null,null,null,null,{"$f":"ROUND(IF(U30=0,0,V30+MINUTE(D30)/60-HOUR(C30)-MINUTE(C30)/60), 2)","v":0},{"$f":"Q29+P30","v":0},{"$f":"R29+IF(Q30>40,Q30-40-R29,0)","v":0},null,null,0,0,null,null,null,"2020-12-15"]
[null,"",null,null,{"$f":"IF(P31=0,0,P31-F31)","v":0},{"$f":"IF(P31=0,0,IF(Q31>40,Q31-40-R30,0))","v":0},null,null,null,null,null,null,null,null,null,{"$f":"ROUND(IF(U31=0,0,V31+MINUTE(D31)/60-HOUR(C31)-MINUTE(C31)/60), 2)","v":0},0,0,null,null,0,0,null,null,null,"2020-12-01"]
[null,"",null,null,0,0,null,null,null,null,null,null,null,null,null,0,0,0,null,null,0,0,null,null,null,"2020-11-17"]
[null,"",null,null,0,0,null,null,"Recording Sick Hours:\nIf you were unable to work previously scheduled hours either in person or remotely due to illness or exposure to COVID-19, record your scheduled hours in the Sick column. You will be paid until the designed allotment of hours has been expended.\n",null,null,null,null,null,null,0,0,0,null,null,0,0,null,null,null,"2020-11-03"]
[null,"",null,null,0,0,null,null,null,null,null,null,null,null,null,0,0,0,null,null,0,0,null,null,null,"2020-10-20"]
[null,"",null,null,0,0,null,null,null,null,null,null,null,null,null,0,0,0,null,null,0,0,null,null,null,"2020-10-06"]
[null,"",null,null,0,0,null,null,null,null,null,null,null,null,null,0,0,0,null,null,0,0,null,null,null,"2020-09-22"]
[null,"",null,null,0,0,null,null,null,null,null,null,null,null,null,0,0,0,null,null,0,0,null,null,null,"2020-09-08"]
[null,"",null,null,0,0,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,0,0,0,null,null,0,0]
[null,"",null,null,0,0,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,0,0,0,null,null,0,0]
[null,"",null,null,0,0,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,0,0,{"$f":"IF(P43=0,0,R42+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}]
[]
["Grand Totals:",null,null,null,{"$f":"E26+E44","v":0},{"$f":"F26+F44","v":0},{"$f":"G26+G44","v":0}]
[]
["Pay Period Total Hours:",null,null,{"$f":"E46+F46+G46","v":0}]
[]
["Employee Signature:",null,null,null,null,null,null,null,null,null,"Date:"]
[]
["Supervisor Signature:",null,null,null,null,null,null,null,null,null,"Date:"]
[]
["Supervisor's Printed Name:"]