{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Employee Timecard"],"not_rendered":{"defined_names":28},"read":"whole","date_system":"1900"}

{"sheet":"Employee Timecard","index":0,"n_rows":138,"n_cols":11,"rows_kept":138,"merged":[[0,1,0,10],[1,1,1,2],[1,4,1,5],[1,6,1,7],[2,1,2,2],[2,4,2,5],[3,0,3,10],[13,0,13,1],[13,3,13,4],[24,0,24,1],[24,3,24,4],[35,0,35,1],[35,3,35,4],[37,0,37,10],[47,0,47,1],[47,3,47,4],[58,0,58,1],[58,3,58,4],[69,0,69,1],[69,3,69,4],[71,0,71,10],[81,0,81,1],[81,3,81,4],[92,0,92,1],[92,3,92,4],[103,0,103,1],[103,3,103,4],[105,0,105,10],[115,0,115,1],[115,3,115,4],[126,0,126,1],[126,3,126,4],[137,0,137,1],[137,3,137,4]]}
["Employee Timecard: ","Daily, Weekly, Monthly, Yearly"]
["Employee Name:",null,null,"E-mail:",null,null,"Year to date totals:",null,{"$f":"SUM(TotalRegularHrs,TotalOvertimeHrs)","v":{"v":45,"d":"45.00"}}]
["Manager:",null,null,"Phone:",null,null,"Regular hrs:",{"$f":"SUM(JanHrs, FebHrs, MarHrs, AprHrs, MayHrs, JuneHrs, JulyHrs, AugHrs, SeptHrs, OctHrs, NovHrs, DecHrs)","v":{"v":40,"d":"40.00"}},null,"Overtime hrs:",{"$f":"SUM(JanOvertime, FebOvertime, MarOverTime, AprOvertime, MayOvertime, JuneOvertime, JulyOvertime, AugOvertime, SeptOvertime, OctOvertime, NovOvertime, DecOvertime)","v":{"v":5,"d":"5.00"}}]
["January, February, March "]
["January","Week 1","Overtime","Week 2","Overtime2","Week 3","Overtime3","Week 4","Overtime4","Week 5","Overtime5"]
["Monday",{"v":8,"d":"8.00"},{"v":2,"d":"2.00"}]
["Tuesday",{"v":8,"d":"8.00"}]
["Wednesday",{"v":8,"d":"8.00"}]
["Thursday",{"v":8,"d":"8.00"},{"v":1,"d":"1.00"}]
["Friday",{"v":8,"d":"8.00"},{"v":2,"d":"2.00"}]
["Saturday"]
["Sunday"]
["Total",{"$f":"SUBTOTAL(109,January[Week 1])","v":{"v":40,"d":"40.00"}},{"$f":"SUBTOTAL(109,January[Overtime])","v":{"v":5,"d":"5.00"}},{"$f":"SUBTOTAL(109,January[Week 2])","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(109,January[Overtime2])","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(109,January[Week 3])","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(109,January[Overtime3])","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(109,January[Week 4])","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(109,January[Overtime4])","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(109,January[Week 5])","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(109,January[Overtime5])","v":{"v":0,"d":"0.00"}}]
["January regular hours:",null,{"$f":"SUM(B13,D13,F13,H13,J13)","v":{"v":40,"d":"40.00"}},"January overtime:",null,{"$f":"SUM(C13,E13,G13,I13,K13)","v":{"v":5,"d":"5.00"}}]
[]
["February","Week 1","Overtime","Week 2","Overtime2","Week 3","Overtime3","Week 4","Overtime4","Week 5","Overtime5"]
["Monday"]
["Tuesday"]
["Wednesday"]
["Thursday"]
["Friday"]
["Saturday"]
["Sunday"]
["Total",{"$f":"SUBTOTAL(109,February[Week 1])","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(109,February[Overtime])","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(109,February[Week 2])","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(109,February[Overtime2])","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(109,February[Week 3])","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(109,February[Overtime3])","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(109,February[Week 4])","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(109,February[Overtime4])","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(109,February[Week 5])","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(109,February[Overtime5])","v":{"v":0,"d":"0.00"}}]
["February regular hours:",null,{"$f":"SUM(B24,D24,F24,H24,J24)","v":{"v":0,"d":"0.00"}},"February overtime:",null,{"$f":"SUM(C24,E24,G24,I24,K24)","v":{"v":0,"d":"0.00"}}]
[]
["March","Week 1","Overtime","Week 2","Overtime2","Week 3","Overtime3","Week 4","Overtime4","Week 5","Overtime5"]
["Monday"]
["Tuesday"]
["Wednesday"]
["Thursday"]
["Friday"]
["Saturday"]
["Sunday"]
["Total",{"$f":"SUBTOTAL(109,March[Week 1])","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(109,March[Overtime])","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(109,March[Week 2])","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(109,March[Overtime2])","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(109,March[Week 3])","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(109,March[Overtime3])","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(109,March[Week 4])","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(109,March[Overtime4])","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(109,March[Week 5])","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(109,March[Overtime5])","v":{"v":0,"d":"0.00"}}]
["March regular hours:",null,{"$f":"SUM(B35,D35,F35,H35,J35)","v":{"v":0,"d":"0.00"}},"March overtime:",null,{"$f":"SUM(C35,E35,G35,I35,K35)","v":{"v":0,"d":"0.00"}}]
[]
["April, May, June"]
["April","Week 1","Overtime","Week 2","Overtime2","Week 3","Overtime3","Week 4","Overtime4","Week 5","Overtime5"]
["Monday"]
["Tuesday"]
["Wednesday"]
["Thursday"]
["Friday"]
["Saturday"]
["Sunday"]
["Total",{"$f":"SUBTOTAL(109,April[Week 1])","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(109,April[Overtime])","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(109,April[Week 2])","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(109,April[Overtime2])","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(109,April[Week 3])","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(109,April[Overtime3])","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(109,April[Week 4])","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(109,April[Overtime4])","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(109,April[Week 5])","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(109,April[Overtime5])","v":{"v":0,"d":"0.00"}}]
["April regular hours:",null,{"$f":"SUM(B47,D47,F47,H47,J47)","v":{"v":0,"d":"0.00"}},"April overtime:",null,{"$f":"SUM(C47,E47,G47,I47,K47)","v":{"v":0,"d":"0.00"}}]
[]
["May","Week 1","Overtime","Week 2","Overtime2","Week 3","Overtime3","Week 4","Overtime4","Week 5","Overtime5"]
["Monday"]
["Tuesday"]
["Wednesday"]
["Thursday"]
["Friday"]
["Saturday"]
["Sunday"]
["Total",{"$f":"SUBTOTAL(109,May[Week 1])","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(109,May[Overtime])","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(109,May[Week 2])","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(109,May[Overtime2])","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(109,May[Week 3])","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(109,May[Overtime3])","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(109,May[Week 4])","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(109,May[Overtime4])","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(109,May[Week 5])","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(109,May[Overtime5])","v":{"v":0,"d":"0.00"}}]
["May regular hours:",null,{"$f":"SUM(B58,D58,F58,H58,J58)","v":{"v":0,"d":"0.00"}},"May overtime:",null,{"$f":"SUM(C58,E58,G58,I58,K58)","v":{"v":0,"d":"0.00"}}]
[]
["June","Week 1","Overtime","Week 2","Overtime2","Week 3","Overtime3","Week 4","Overtime4","Week 5","Overtime5"]
["Monday"]
["Tuesday"]
["Wednesday"]
["Thursday"]
["Friday"]
["Saturday"]
["Sunday"]
["Total",{"$f":"SUBTOTAL(109,June[Week 1])","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(109,June[Overtime])","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(109,June[Week 2])","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(109,June[Overtime2])","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(109,June[Week 3])","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(109,June[Overtime3])","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(109,June[Week 4])","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(109,June[Overtime4])","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(109,June[Week 5])","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(109,June[Overtime5])","v":{"v":0,"d":"0.00"}}]
["June regular hours:",null,{"$f":"SUM(B69,D69,F69,H69,J69)","v":{"v":0,"d":"0.00"}},"June overtime:",null,{"$f":"SUM(C69,E69,G69,I69,K69)","v":{"v":0,"d":"0.00"}}]
[]
["July, August, September  "]
["July","Week 1","Overtime","Week 2","Overtime2","Week 3","Overtime3","Week 4","Overtime4","Week 5","Overtime5"]
["Monday"]
["Tuesday"]
["Wednesday"]
["Thursday"]
["Friday"]
["Saturday"]
["Sunday"]
["Total",{"$f":"SUBTOTAL(109,July[Week 1])","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(109,July[Overtime])","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(109,July[Week 2])","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(109,July[Overtime2])","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(109,July[Week 3])","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(109,July[Overtime3])","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(109,July[Week 4])","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(109,July[Overtime4])","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(109,July[Week 5])","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(109,July[Overtime5])","v":{"v":0,"d":"0.00"}}]
["July regular hours:",null,{"$f":"SUM(B81,D81,F81,H81,J81)","v":{"v":0,"d":"0.00"}},"July overtime:",null,{"$f":"SUM(C81,E81,G81,I81,K81)","v":{"v":0,"d":"0.00"}}]
[]
["August","Week 1","Overtime","Week 2","Overtime2","Week 3","Overtime3","Week 4","Overtime4","Week 5","Overtime5"]
["Monday"]
["Tuesday"]
["Wednesday"]
["Thursday"]
["Friday"]
["Saturday"]
["Sunday"]
["Total",{"$f":"SUBTOTAL(109,August[Week 1])","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(109,August[Overtime])","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(109,August[Week 2])","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(109,August[Overtime2])","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(109,August[Week 3])","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(109,August[Overtime3])","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(109,August[Week 4])","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(109,August[Overtime4])","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(109,August[Week 5])","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(109,August[Overtime5])","v":{"v":0,"d":"0.00"}}]
["August regular hours:",null,{"$f":"SUM(B92,D92,F92,H92,J92)","v":{"v":0,"d":"0.00"}},"August overtime:",null,{"$f":"SUM(C92,E92,G92,I92,K92)","v":{"v":0,"d":"0.00"}}]
[]
["September","Week 1","Overtime","Week 2","Overtime2","Week 3","Overtime3","Week 4","Overtime4","Week 5","Overtime5"]
["Monday"]
["Tuesday"]
["Wednesday"]
["Thursday"]
["Friday"]
["Saturday"]
["Sunday"]
["Total",{"$f":"SUBTOTAL(109,September[Week 1])","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(109,September[Overtime])","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(109,September[Week 2])","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(109,September[Overtime2])","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(109,September[Week 3])","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(109,September[Overtime3])","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(109,September[Week 4])","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(109,September[Overtime4])","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(109,September[Week 5])","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(109,September[Overtime5])","v":{"v":0,"d":"0.00"}}]
["September regular hours:",null,{"$f":"SUM(B103,D103,F103,H103,J103)","v":{"v":0,"d":"0.00"}},"September overtime:",null,{"$f":"SUM(C103,E103,G103,I103,K103)","v":{"v":0,"d":"0.00"}}]
[]
["October, November, December"]
["October","Week 1","Overtime","Week 2","Overtime2","Week 3","Overtime3","Week 4","Overtime4","Week 5","Overtime5"]
["Monday"]
["Tuesday"]
["Wednesday"]
["Thursday"]
["Friday"]
["Saturday"]
["Sunday"]
["Total",{"$f":"SUBTOTAL(109,October[Week 1])","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(109,October[Overtime])","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(109,October[Week 2])","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(109,October[Overtime2])","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(109,October[Week 3])","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(109,October[Overtime3])","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(109,October[Week 4])","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(109,October[Overtime4])","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(109,October[Week 5])","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(109,October[Overtime5])","v":{"v":0,"d":"0.00"}}]
["October regular hours:",null,{"$f":"SUM(B115,D115,F115,H115,J115)","v":{"v":0,"d":"0.00"}},"October overtime:",null,{"$f":"SUM(C115,E115,G115,I115,K115)","v":{"v":0,"d":"0.00"}}]
[]
["November","Week 1","Overtime","Week 2","Overtime2","Week 3","Overtime3","Week 4","Overtime4","Week 5","Overtime5"]
["Monday"]
["Tuesday"]
["Wednesday"]
["Thursday"]
["Friday"]
["Saturday"]
["Sunday"]
["Total",{"$f":"SUBTOTAL(109,November[Week 1])","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(109,November[Overtime])","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(109,November[Week 2])","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(109,November[Overtime2])","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(109,November[Week 3])","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(109,November[Overtime3])","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(109,November[Week 4])","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(109,November[Overtime4])","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(109,November[Week 5])","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(109,November[Overtime5])","v":{"v":0,"d":"0.00"}}]
["November regular hours:",null,{"$f":"SUM(B126,D126,F126,H126,J126)","v":{"v":0,"d":"0.00"}},"November overtime:",null,{"$f":"SUM(C126,E126,G126,I126,K126)","v":{"v":0,"d":"0.00"}}]
[]
["December","Week 1","Overtime","Week 2","Overtime2","Week 3","Overtime3","Week 4","Overtime4","Week 5","Overtime5"]
["Monday"]
["Tuesday"]
["Wednesday"]
["Thursday"]
["Friday"]
["Saturday"]
["Sunday"]
["Total",{"$f":"SUBTOTAL(109,December[Week 1])","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(109,December[Overtime])","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(109,December[Week 2])","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(109,December[Overtime2])","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(109,December[Week 3])","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(109,December[Overtime3])","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(109,December[Week 4])","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(109,December[Overtime4])","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(109,December[Week 5])","v":{"v":0,"d":"0.00"}},{"$f":"SUBTOTAL(109,December[Overtime5])","v":{"v":0,"d":"0.00"}}]
["December regular hours:",null,{"$f":"SUM(B137,D137,F137,H137,J137)","v":{"v":0,"d":"0.00"}},"December overtime:",null,{"$f":"SUM(C137,E137,G137,I137,K137)","v":{"v":0,"d":"0.00"}}]