{"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":41,"n_cols":37,"rows_kept":41,"cut":false,"hidden":false,"merged":[[40,3,40,7],[36,10,36,11],[38,10,38,11],[0,12,0,15],[2,1,2,3],[4,1,4,4],[36,3,36,7],[6,0,6,1],[7,0,7,1],[8,0,8,1],[9,0,9,1],[38,3,38,7],[6,4,6,5],[7,4,7,5],[8,4,8,5],[9,4,9,5]]}
["BRYN MAWR COLLEGE BI-WEEKLY TIME SHEET",null,null,null,null,null,null,null,"PAY PERIOD ENDING DATE:",null,null,null,null,null,null,null,null,"v1.53",null,null,"BES","BEW","BIR","DIS","FNL","HOL","HLW","JUR","ONC","OVT","PER","PLV","REG","SCE","SCO","VAC","WCP"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(G34:R34)","v":0}]
["ID:",null,null,null,null,null,null,null,null,null,"EARNINGS CODES:",null,null,null,null,null,null,null,null,null,{"$f":"IF(C8=\"ONC\",0,D8)+IF(C9=\"ONC\",0,D9)+IF(C10=\"ONC\",0,D10)+IF(G8=\"ONC\",0,H8)+IF(G9=\"ONC\",0,H9)+IF(G10=\"ONC\",0,H10)","v":0}]
[null,null,null,null,null,null,null,null,"REG","Regular"]
["NAME:",null,null,null,null,null,null,null,"BES","Bad Weather/Emergency Day Scheduled",null,null,null,null,"OVT","Overtime"]
[null,null,null,null,null,null,null,null,"BEW","Bad Weather/Emergency Day Worked",null,null,null,null,"*Record under \"OTHER\""]
["16-DIGIT ACCT",null,"CODE","HOURS","16-DIGIT ACCT",null,"CODE","HOURS","HOL","Holiday Scheduled",null,null,null,null,"BIR","Birthday"]
[null,null,null,null,null,null,null,null,"HLW","Holiday Worked",null,null,null,null,"DIS","Disability"]
[null,null,null,null,null,null,null,null,"PER","Personal",null,null,null,null,"FNL","Funeral"]
[null,null,null,null,null,null,null,null,"SCE","Sick",null,null,null,null,"JUR","Jury"]
[null,null,null,null,null,null,null,null,"SCO","Sick Other",null,null,null,null,"PLV","Parental Leave"]
["EARNINGS DETAIL:",null,null,null,null,null,null,null,"VAC","Vacation",null,null,null,null,"WCP","Worker's Compensation"]
["Record number of hours per day in the appropriate earnings code column.  ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"worked","other","toward ot","ot","move up",null,null,"start calc","out1 hour","out2 hour"]
["Week 1","Date","Time In","Time Out","Time In","Time Out","REG","SCE","SCO","VAC","PER","BES","BEW","HOL","HLW","OTHER","*CODE","OVT"]
["Fri",{"$f":"IF($M$1=\"\",\"\",IF(A15=\"Fri\",$M$1-13,IF(A15=\"Sat\",$M$1-12,IF(A15=\"Sun\",$M$1-11,IF(A15=\"Mon\",$M$1-10,IF(A15=\"Tues\",$M$1-9,IF(A15=\"Wed\",$M$1-8,IF(A15=\"Thurs\",$M$1-7,\"\"))))))))","v":""},null,null,null,null,{"$f":"IF((T15-M15-O15-R15)>0,ROUND(T15-M15-O15-R15,2),0)","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M15>0,0,IF(W15-W14+X16>0,IF((W15-W14+X16)>(T15-O15),T15-O15,W15-W14+X16),0))","v":0},null,{"$f":"IF(AA15=0,0,(AB15+ROUND(MINUTE(D15)/60,2))-(HOUR(C15)+ROUND(MINUTE(C15)/60,2))+(AC15+ROUND(MINUTE(F15)/60,2))-(HOUR(E15)+ROUND(MINUTE(E15)/60,2)))","v":0},{"$f":"SUM(H15:L15)+N15+P15","v":0},{"$f":"IF(M15>0,IF(V14+T15+U15-O15>40,40,V14+T15+U15-O15),V14+T15+U15-O15)","v":0},{"$f":"IF(V15>40,V15-40,0)","v":0},{"$f":"IF((W15-W14-R15)<0,X16-R15+W15,ROUND(W15-W14-R15+X16,2))","v":0},null,null,{"$f":"IF(C15<>\"\",IF(D15<>\"\",1,IF(F15<>\"\",1,0)),IF(E15<>\"\",IF(F15<>\"\",1,0),0))","v":0},{"$f":"IF(AA15=1,IF(D15=\"\",0,IF(HOUR(D15)=0,IF(HOUR(C15)=0,0,24),HOUR(D15))),0)","v":0},{"$f":"IF(AA15=1,IF(F15=\"\",0,IF(HOUR(F15)=0,IF(E15=\"\",IF(HOUR(C15)=0,0,24),IF(HOUR(E15)=0,0,24)),HOUR(F15))),0)","v":0}]
["Sat",{"$f":"IF($M$1=\"\",\"\",IF(A16=\"Fri\",$M$1-13,IF(A16=\"Sat\",$M$1-12,IF(A16=\"Sun\",$M$1-11,IF(A16=\"Mon\",$M$1-10,IF(A16=\"Tues\",$M$1-9,IF(A16=\"Wed\",$M$1-8,IF(A16=\"Thurs\",$M$1-7,\"\"))))))))","v":""},null,null,null,null,{"$f":"IF((T16-M16-O16-R16)>0,ROUND(T16-M16-O16-R16,2),0)","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M16>0,0,IF(W16-W15+X17>0,IF((W16-W15+X17)>(T16-O16),T16-O16,W16-W15+X17),0))","v":0},null,{"$f":"IF(AA16=0,0,(AB16+ROUND(MINUTE(D16)/60,2))-(HOUR(C16)+ROUND(MINUTE(C16)/60,2))+(AC16+ROUND(MINUTE(F16)/60,2))-(HOUR(E16)+ROUND(MINUTE(E16)/60,2)))","v":0},{"$f":"SUM(H16:L16)+N16+P16","v":0},{"$f":"IF(M16>0,IF(V15+T16+U16-O16>40,40,V15+T16+U16-O16),V15+T16+U16-O16)","v":0},{"$f":"IF(V16>40,V16-40,0)","v":0},0,null,null,{"$f":"IF(C16<>\"\",IF(D16<>\"\",1,IF(F16<>\"\",1,0)),IF(E16<>\"\",IF(F16<>\"\",1,0),0))","v":0},{"$f":"IF(AA16=1,IF(D16=\"\",0,IF(HOUR(D16)=0,IF(HOUR(C16)=0,0,24),HOUR(D16))),0)","v":0},{"$f":"IF(AA16=1,IF(F16=\"\",0,IF(HOUR(F16)=0,IF(E16=\"\",IF(HOUR(C16)=0,0,24),IF(HOUR(E16)=0,0,24)),HOUR(F16))),0)","v":0}]
["Sun","",null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,0,null,0,0,0,0,0,null,null,0,0,0]
["Mon","",null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,0,null,0,0,0,0,0,null,null,0,0,0]
["Tues","",null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,0,null,0,0,0,0,0,null,null,0,0,0]
["Wed","",null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,0,null,0,0,0,0,0,null,null,0,0,0]
["Thurs","",null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,0,null,0,0,0,0,0,null,null,0,0,0]
["Subtotal Week 1:",null,null,null,null,null,{"$f":"SUM(G15:G21)","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(R15:R21)","v":0}]
[]
["Week 2","Date","Time In","Time Out","Time In","Time Out","REG","SCE","SCO","VAC","PER","BES","BEW","HOL","HLW","OTHER","*CODE","OVT"]
["Fri",{"$f":"IF($M$1=\"\",\"\",IF(A25=\"Fri\",$M$1-6,IF(A25=\"Sat\",$M$1-5,IF(A25=\"Sun\",$M$1-4,IF(A25=\"Mon\",$M$1-3,IF(A25=\"Tues\",$M$1-2,IF(A25=\"Wed\",$M$1-1,IF(A25=\"Thurs\",$M$1,\"\"))))))))","v":""},null,null,null,null,{"$f":"IF((T25-M25-O25-R25)>0,ROUND(T25-M25-O25-R25,2),0)","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M25>0,0,IF(W25-W24+X26>0,IF((W25-W24+X26)>(T25-O25),T25-O25,W25-W24+X26),0))","v":0},null,{"$f":"IF(AA25=0,0,(AB25+ROUND(MINUTE(D25)/60,2))-(HOUR(C25)+ROUND(MINUTE(C25)/60,2))+(AC25+ROUND(MINUTE(F25)/60,2))-(HOUR(E25)+ROUND(MINUTE(E25)/60,2)))","v":0},{"$f":"SUM(H25:L25)+N25+P25","v":0},{"$f":"IF(M25>0,IF(V24+T25+U25-O25>40,40,V24+T25+U25-O25),V24+T25+U25-O25)","v":0},{"$f":"IF(V25>40,V25-40,0)","v":0},{"$f":"IF((W25-W24-R25)<0,X26-R25+W25,ROUND(W25-W24-R25+X26,2))","v":0},null,null,{"$f":"IF(C25<>\"\",IF(D25<>\"\",1,IF(F25<>\"\",1,0)),IF(E25<>\"\",IF(F25<>\"\",1,0),0))","v":0},{"$f":"IF(AA25=1,IF(D25=\"\",0,IF(HOUR(D25)=0,IF(HOUR(C25)=0,0,24),HOUR(D25))),0)","v":0},{"$f":"IF(AA25=1,IF(F25=\"\",0,IF(HOUR(F25)=0,IF(E25=\"\",IF(HOUR(C25)=0,0,24),IF(HOUR(E25)=0,0,24)),HOUR(F25))),0)","v":0}]
["Sat",{"$f":"IF($M$1=\"\",\"\",IF(A26=\"Fri\",$M$1-6,IF(A26=\"Sat\",$M$1-5,IF(A26=\"Sun\",$M$1-4,IF(A26=\"Mon\",$M$1-3,IF(A26=\"Tues\",$M$1-2,IF(A26=\"Wed\",$M$1-1,IF(A26=\"Thurs\",$M$1,\"\"))))))))","v":""},null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,0,null,0,{"$f":"SUM(H26:L26)+N26+P26","v":0},0,0,0,null,null,{"$f":"IF(C26<>\"\",IF(D26<>\"\",1,IF(F26<>\"\",1,0)),IF(E26<>\"\",IF(F26<>\"\",1,0),0))","v":0},0,0]
["Sun","",null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,0,null,0,0,0,0,0,null,null,0,0,0]
["Mon","",null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,0,null,0,0,0,0,0,null,null,0,0,0]
["Tues","",null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,0,null,0,0,0,0,0,null,null,0,0,0]
["Wed","",null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,0,null,0,0,0,0,0,null,null,0,0,0]
["Thurs","",null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,0,null,0,0,0,0,0,null,null,0,0,0]
["Subtotal Week 2:",null,null,null,null,null,{"$f":"SUM(G25:G31)","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(R25:R31)","v":0}]
[]
["Earnings Code Grand Totals:",null,null,null,null,null,{"$f":"G22+G32","v":0},{"$f":"H22+H32","v":0},0,0,0,0,0,0,0,0,0,0]
["Pay Period Total Hours:",null,null,{"$f":"SUM(G34:R34)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SHIFT HOURS:"]
["Employee Signature:",null,null,null,null,null,null,null,null,"Date:",null,null,null,null,null,"REG","OVT"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Evening: "]
["Supervisor Signature:",null,null,null,null,null,null,null,null,"Date:",null,null,null,null,"Night: "]
[]
["Supervisor Printed Name:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Shift Hours: ",{"$f":"P38+Q38+P39+Q39","v":0}]