{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Yearly Timesheet"],"not_rendered":{"defined_names":2},"read":"whole","date_system":"1900"}

{"sheet":"Yearly Timesheet","index":0,"n_rows":140,"n_cols":12,"rows_kept":140,"merged":[[0,1,1,11],[2,6,2,7],[2,8,2,9],[5,1,5,11],[15,3,15,4],[26,3,26,4],[37,3,37,4],[39,1,39,11],[49,3,49,4],[60,3,60,4],[71,3,71,4],[73,1,73,11],[83,3,83,4],[94,3,94,4],[105,3,105,4],[107,1,107,11],[117,3,117,4],[128,3,128,4],[139,3,139,4]]}
[null,"Employee Time sheet"]
[]
[null,"Employee name:",null,"Email address:",null,null,"Year to date totals:"]
[null,"Manager:",null,"Phone number:",null,null,"Regular hours:",{"$f":"SUM(C16,C27,C38,C50,C61,C72,C84,C95,C106,C118,C129,C140)","v":0},"Overtime hours:",{"$f":"SUM(F16,F27,F38,F50,F61,F72,F84,F95,F106,F118,F129,F140)","v":0},"Total:",{"$f":"SUM(H4,J4)","v":0}]
[]
[null,"January, February, March      Employee time sheet: Daily, Weekly, Monthly, Yearly"]
[null,"January","Week 1","Overtime","Week 2","Overtime ","Week 3","Overtime  ","Week 4","Overtime   ","Week 5","Overtime    "]
[null,"Monday"]
[null,"Tuesday"]
[null,"Wednesday"]
[null,"Thursday"]
[null,"Friday"]
[null,"Saturday"]
[null,"Sunday"]
[null,"Total weekly hours",{"$f":"SUBTOTAL(109,January[Week 1])","v":0},{"$f":"SUBTOTAL(109,January[Overtime])","v":0},{"$f":"SUBTOTAL(109,January[Week 2])","v":0},{"$f":"SUBTOTAL(109,January[[Overtime ]])","v":0},{"$f":"SUBTOTAL(109,January[Week 3])","v":0},{"$f":"SUBTOTAL(109,January[[Overtime  ]])","v":0},{"$f":"SUBTOTAL(109,January[Week 4])","v":0},{"$f":"SUBTOTAL(109,January[[Overtime   ]])","v":0},{"$f":"SUBTOTAL(109,January[Week 5])","v":0},{"$f":"SUBTOTAL(109,January[[Overtime    ]])","v":0}]
[null,"Jan. total: Regular hours",{"$f":"SUM(January[[#Totals],[Week 1]],January[[#Totals],[Week 2]],January[[#Totals],[Week 3]],January[[#Totals],[Week 4]],January[[#Totals],[Week 5]])","v":0},"Jan. total: Overtime",null,{"$f":"SUM(January[[#Totals],[Overtime]],January[[#Totals],[Overtime ]],January[[#Totals],[Overtime  ]],January[[#Totals],[Overtime   ]],January[[#Totals],[Overtime    ]])","v":0}]
[]
[null,"February","Week 1","Overtime","Week 2","Overtime ","Week 3","Overtime  ","Week 4","Overtime   ","Week 5","Overtime    "]
[null,"Monday"]
[null,"Tuesday"]
[null,"Wednesday"]
[null,"Thursday"]
[null,"Friday"]
[null,"Saturday"]
[null,"Sunday"]
[null,"Total weekly hours",{"$f":"SUBTOTAL(109,February[Week 1])","v":0},{"$f":"SUBTOTAL(109,February[Overtime])","v":0},{"$f":"SUBTOTAL(109,February[Week 2])","v":0},{"$f":"SUBTOTAL(109,February[[Overtime ]])","v":0},{"$f":"SUBTOTAL(109,February[Week 3])","v":0},{"$f":"SUBTOTAL(109,February[[Overtime  ]])","v":0},{"$f":"SUBTOTAL(109,February[Week 4])","v":0},{"$f":"SUBTOTAL(109,February[[Overtime   ]])","v":0},{"$f":"SUBTOTAL(109,February[Week 5])","v":0},{"$f":"SUBTOTAL(109,February[[Overtime    ]])","v":0}]
[null,"Feb. total: Regular hours",{"$f":"SUM(February[[#Totals],[Week 1]],February[[#Totals],[Week 2]],February[[#Totals],[Week 3]],February[[#Totals],[Week 4]],February[[#Totals],[Week 5]])","v":0},"Feb. total: Overtime",null,{"$f":"SUM(February[[#Totals],[Overtime]],February[[#Totals],[Overtime ]],February[[#Totals],[Overtime  ]],February[[#Totals],[Overtime   ]],February[[#Totals],[Overtime    ]])","v":0}]
[]
[null,"March","Week 1","Overtime","Week 2","Overtime ","Week 3","Overtime  ","Week 4","Overtime   ","Week 5","Overtime    "]
[null,"Monday"]
[null,"Tuesday"]
[null,"Wednesday"]
[null,"Thursday"]
[null,"Friday"]
[null,"Saturday"]
[null,"Sunday"]
[null,"Total weekly hours",{"$f":"SUBTOTAL(109,March[Week 1])","v":0},{"$f":"SUBTOTAL(109,March[Overtime])","v":0},{"$f":"SUBTOTAL(109,March[Week 2])","v":0},{"$f":"SUBTOTAL(109,March[[Overtime ]])","v":0},{"$f":"SUBTOTAL(109,March[Week 3])","v":0},{"$f":"SUBTOTAL(109,March[[Overtime  ]])","v":0},{"$f":"SUBTOTAL(109,March[Week 4])","v":0},{"$f":"SUBTOTAL(109,March[[Overtime   ]])","v":0},{"$f":"SUBTOTAL(109,March[Week 5])","v":0},{"$f":"SUBTOTAL(109,March[[Overtime    ]])","v":0}]
[null,"Mar. total: Regular hours",{"$f":"SUM(March[[#Totals],[Week 1]],March[[#Totals],[Week 2]],March[[#Totals],[Week 3]],March[[#Totals],[Week 4]],March[[#Totals],[Week 5]])","v":0},"Mar. total: Overtime",null,{"$f":"SUM(March[[#Totals],[Overtime]],March[[#Totals],[Overtime ]],March[[#Totals],[Overtime  ]],March[[#Totals],[Overtime   ]],March[[#Totals],[Overtime    ]])","v":0}]
[]
[null,"April, May, June      Employee time sheet: Daily, Weekly, Monthly, Yearly"]
[null,"April","Week 1","Overtime","Week 2","Overtime ","Week 3","Overtime  ","Week 4","Overtime   ","Week 5","Overtime    "]
[null,"Monday"]
[null,"Tuesday"]
[null,"Wednesday"]
[null,"Thursday"]
[null,"Friday"]
[null,"Saturday"]
[null,"Sunday"]
[null,"Total weekly hours",{"$f":"SUBTOTAL(109,April[Week 1])","v":0},{"$f":"SUBTOTAL(109,April[Overtime])","v":0},{"$f":"SUBTOTAL(109,April[Week 2])","v":0},{"$f":"SUBTOTAL(109,April[[Overtime ]])","v":0},{"$f":"SUBTOTAL(109,April[Week 3])","v":0},{"$f":"SUBTOTAL(109,April[[Overtime  ]])","v":0},{"$f":"SUBTOTAL(109,April[Week 4])","v":0},{"$f":"SUBTOTAL(109,April[[Overtime   ]])","v":0},{"$f":"SUBTOTAL(109,April[Week 5])","v":0},{"$f":"SUBTOTAL(109,April[[Overtime    ]])","v":0}]
[null,"Apr. total: Regular hours",{"$f":"SUM(April[[#Totals],[Week 1]],April[[#Totals],[Week 2]],April[[#Totals],[Week 3]],April[[#Totals],[Week 4]],April[[#Totals],[Week 5]])","v":0},"Apr. total: Overtime",null,{"$f":"SUM(April[[#Totals],[Overtime]],April[[#Totals],[Overtime ]],April[[#Totals],[Overtime  ]],April[[#Totals],[Overtime   ]],April[[#Totals],[Overtime    ]])","v":0}]
[]
[null,"May","Week 1","Overtime","Week 2","Overtime ","Week 3","Overtime  ","Week 4","Overtime   ","Week 5","Overtime    "]
[null,"Monday"]
[null,"Tuesday"]
[null,"Wednesday"]
[null,"Thursday"]
[null,"Friday"]
[null,"Saturday"]
[null,"Sunday"]
[null,"Total weekly hours",{"$f":"SUBTOTAL(109,May[Week 1])","v":0},{"$f":"SUBTOTAL(109,May[Overtime])","v":0},{"$f":"SUBTOTAL(109,May[Week 2])","v":0},{"$f":"SUBTOTAL(109,May[[Overtime ]])","v":0},{"$f":"SUBTOTAL(109,May[Week 3])","v":0},{"$f":"SUBTOTAL(109,May[[Overtime  ]])","v":0},{"$f":"SUBTOTAL(109,May[Week 4])","v":0},{"$f":"SUBTOTAL(109,May[[Overtime   ]])","v":0},{"$f":"SUBTOTAL(109,May[Week 5])","v":0},{"$f":"SUBTOTAL(109,May[[Overtime    ]])","v":0}]
[null,"May total: Regular hours",{"$f":"SUM(May[[#Totals],[Week 1]],May[[#Totals],[Week 2]],May[[#Totals],[Week 3]],May[[#Totals],[Week 4]],May[[#Totals],[Week 5]])","v":0},"May total: Overtime",null,{"$f":"SUM(May[[#Totals],[Overtime]],May[[#Totals],[Overtime ]],May[[#Totals],[Overtime  ]],May[[#Totals],[Overtime   ]],May[[#Totals],[Overtime    ]])","v":0}]
[]
[null,"June","Week 1","Overtime","Week 2","Overtime ","Week 3","Overtime  ","Week 4","Overtime   ","Week 5","Overtime    "]
[null,"Monday"]
[null,"Tuesday"]
[null,"Wednesday"]
[null,"Thursday"]
[null,"Friday"]
[null,"Saturday"]
[null,"Sunday"]
[null,"Total weekly hours",{"$f":"SUBTOTAL(109,June[Week 1])","v":0},{"$f":"SUBTOTAL(109,June[Overtime])","v":0},{"$f":"SUBTOTAL(109,June[Week 2])","v":0},{"$f":"SUBTOTAL(109,June[[Overtime ]])","v":0},{"$f":"SUBTOTAL(109,June[Week 3])","v":0},{"$f":"SUBTOTAL(109,June[[Overtime  ]])","v":0},{"$f":"SUBTOTAL(109,June[Week 4])","v":0},{"$f":"SUBTOTAL(109,June[[Overtime   ]])","v":0},{"$f":"SUBTOTAL(109,June[Week 5])","v":0},{"$f":"SUBTOTAL(109,June[[Overtime    ]])","v":0}]
[null,"June total: Regular hours",{"$f":"SUM(June[[#Totals],[Week 1]],June[[#Totals],[Week 2]],June[[#Totals],[Week 3]],June[[#Totals],[Week 4]],June[[#Totals],[Week 5]])","v":0},"June total: Overtime",null,{"$f":"SUM(June[[#Totals],[Overtime]],June[[#Totals],[Overtime ]],June[[#Totals],[Overtime  ]],June[[#Totals],[Overtime   ]],June[[#Totals],[Overtime    ]])","v":0}]
[]
[null,"July, August, September      Employee time sheet: Daily, Weekly, Monthly, Yearly"]
[null,"July","Week 1","Overtime","Week 2","Overtime ","Week 3","Overtime  ","Week 4","Overtime   ","Week 5","Overtime    "]
[null,"Monday"]
[null,"Tuesday"]
[null,"Wednesday"]
[null,"Thursday"]
[null,"Friday"]
[null,"Saturday"]
[null,"Sunday"]
[null,"Total weekly hours",{"$f":"SUBTOTAL(109,July[Week 1])","v":0},{"$f":"SUBTOTAL(109,July[Overtime])","v":0},{"$f":"SUBTOTAL(109,July[Week 2])","v":0},{"$f":"SUBTOTAL(109,July[[Overtime ]])","v":0},{"$f":"SUBTOTAL(109,July[Week 3])","v":0},{"$f":"SUBTOTAL(109,July[[Overtime  ]])","v":0},{"$f":"SUBTOTAL(109,July[Week 4])","v":0},{"$f":"SUBTOTAL(109,July[[Overtime   ]])","v":0},{"$f":"SUBTOTAL(109,July[Week 5])","v":0},{"$f":"SUBTOTAL(109,July[[Overtime    ]])","v":0}]
[null,"July total: Regular hours",{"$f":"SUM(July[[#Totals],[Week 1]],July[[#Totals],[Week 2]],July[[#Totals],[Week 3]],July[[#Totals],[Week 4]],July[[#Totals],[Week 5]])","v":0},"July total: Overtime",null,{"$f":"SUM(July[[#Totals],[Overtime]],July[[#Totals],[Overtime ]],July[[#Totals],[Overtime  ]],July[[#Totals],[Overtime   ]],July[[#Totals],[Overtime    ]])","v":0}]
[]
[null,"August","Week 1","Overtime","Week 2","Overtime ","Week 3","Overtime  ","Week 4","Overtime   ","Week 5","Overtime    "]
[null,"Monday"]
[null,"Tuesday"]
[null,"Wednesday"]
[null,"Thursday"]
[null,"Friday"]
[null,"Saturday"]
[null,"Sunday"]
[null,"Total weekly hours",{"$f":"SUBTOTAL(109,August[Week 1])","v":0},{"$f":"SUBTOTAL(109,August[Overtime])","v":0},{"$f":"SUBTOTAL(109,August[Week 2])","v":0},{"$f":"SUBTOTAL(109,August[[Overtime ]])","v":0},{"$f":"SUBTOTAL(109,August[Week 3])","v":0},{"$f":"SUBTOTAL(109,August[[Overtime  ]])","v":0},{"$f":"SUBTOTAL(109,August[Week 4])","v":0},{"$f":"SUBTOTAL(109,August[[Overtime   ]])","v":0},{"$f":"SUBTOTAL(109,August[Week 5])","v":0},{"$f":"SUBTOTAL(109,August[[Overtime    ]])","v":0}]
[null,"Aug. total: Regular hours",{"$f":"SUM(August[[#Totals],[Week 1]],August[[#Totals],[Week 2]],August[[#Totals],[Week 3]],August[[#Totals],[Week 4]],August[[#Totals],[Week 5]])","v":0},"Aug. total: Overtime",null,{"$f":"SUM(August[[#Totals],[Overtime]],August[[#Totals],[Overtime ]],August[[#Totals],[Overtime  ]],August[[#Totals],[Overtime   ]],August[[#Totals],[Overtime    ]])","v":0}]
[]
[null,"September","Week 1","Overtime","Week 2","Overtime ","Week 3","Overtime  ","Week 4","Overtime   ","Week 5","Overtime    "]
[null,"Monday"]
[null,"Tuesday"]
[null,"Wednesday"]
[null,"Thursday"]
[null,"Friday"]
[null,"Saturday"]
[null,"Sunday"]
[null,"Total weekly hours",{"$f":"SUBTOTAL(109,September[Week 1])","v":0},{"$f":"SUBTOTAL(109,September[Overtime])","v":0},{"$f":"SUBTOTAL(109,September[Week 2])","v":0},{"$f":"SUBTOTAL(109,September[[Overtime ]])","v":0},{"$f":"SUBTOTAL(109,September[Week 3])","v":0},{"$f":"SUBTOTAL(109,September[[Overtime  ]])","v":0},{"$f":"SUBTOTAL(109,September[Week 4])","v":0},{"$f":"SUBTOTAL(109,September[[Overtime   ]])","v":0},{"$f":"SUBTOTAL(109,September[Week 5])","v":0},{"$f":"SUBTOTAL(109,September[[Overtime    ]])","v":0}]
[null,"Sept. total: Regular hours",{"$f":"SUM(September[[#Totals],[Week 1]],September[[#Totals],[Week 2]],September[[#Totals],[Week 3]],September[[#Totals],[Week 4]],September[[#Totals],[Week 5]])","v":0},"Sept. total: Overtime",null,{"$f":"SUM(September[[#Totals],[Overtime]],September[[#Totals],[Overtime ]],September[[#Totals],[Overtime  ]],September[[#Totals],[Overtime   ]],September[[#Totals],[Overtime    ]])","v":0}]
[]
[null,"October, November, December      Employee time sheet: Daily, Weekly, Monthly, Yearly"]
[null,"October","Week 1","Overtime","Week 2","Overtime ","Week 3","Overtime  ","Week 4","Overtime   ","Week 5","Overtime    "]
[null,"Monday"]
[null,"Tuesday"]
[null,"Wednesday"]
[null,"Thursday"]
[null,"Friday"]
[null,"Saturday"]
[null,"Sunday"]
[null,"Total weekly hours",{"$f":"SUBTOTAL(109,October[Week 1])","v":0},{"$f":"SUBTOTAL(109,October[Overtime])","v":0},{"$f":"SUBTOTAL(109,October[Week 2])","v":0},{"$f":"SUBTOTAL(109,October[[Overtime ]])","v":0},{"$f":"SUBTOTAL(109,October[Week 3])","v":0},{"$f":"SUBTOTAL(109,October[[Overtime  ]])","v":0},{"$f":"SUBTOTAL(109,October[Week 4])","v":0},{"$f":"SUBTOTAL(109,October[[Overtime   ]])","v":0},{"$f":"SUBTOTAL(109,October[Week 5])","v":0},{"$f":"SUBTOTAL(109,October[[Overtime    ]])","v":0}]
[null,"Oct. total: Regular hours",{"$f":"SUM(October[[#Totals],[Week 1]],October[[#Totals],[Week 2]],October[[#Totals],[Week 3]],October[[#Totals],[Week 4]],October[[#Totals],[Week 5]])","v":0},"Oct. total: Overtime",null,{"$f":"SUM(October[[#Totals],[Overtime]],October[[#Totals],[Overtime ]],October[[#Totals],[Overtime  ]],October[[#Totals],[Overtime   ]],October[[#Totals],[Overtime    ]])","v":0}]
[]
[null,"November","Week 1","Overtime","Week 2","Overtime ","Week 3","Overtime  ","Week 4","Overtime   ","Week 5","Overtime    "]
[null,"Monday"]
[null,"Tuesday"]
[null,"Wednesday"]
[null,"Thursday"]
[null,"Friday"]
[null,"Saturday"]
[null,"Sunday"]
[null,"Total weekly hours",{"$f":"SUBTOTAL(109,November[Week 1])","v":0},{"$f":"SUBTOTAL(109,November[Overtime])","v":0},{"$f":"SUBTOTAL(109,November[Week 2])","v":0},{"$f":"SUBTOTAL(109,November[[Overtime ]])","v":0},{"$f":"SUBTOTAL(109,November[Week 3])","v":0},{"$f":"SUBTOTAL(109,November[[Overtime  ]])","v":0},{"$f":"SUBTOTAL(109,November[Week 4])","v":0},{"$f":"SUBTOTAL(109,November[[Overtime   ]])","v":0},{"$f":"SUBTOTAL(109,November[Week 5])","v":0},{"$f":"SUBTOTAL(109,November[[Overtime    ]])","v":0}]
[null,"Nov. total: Regular hours",{"$f":"SUM(November[[#Totals],[Week 1]],November[[#Totals],[Week 2]],November[[#Totals],[Week 3]],November[[#Totals],[Week 4]],November[[#Totals],[Week 5]])","v":0},"Nov. total: Overtime",null,{"$f":"SUM(November[[#Totals],[Overtime]],November[[#Totals],[Overtime ]],November[[#Totals],[Overtime  ]],November[[#Totals],[Overtime   ]],November[[#Totals],[Overtime    ]])","v":0}]
[]
[null,"December","Week 1","Overtime","Week 2","Overtime ","Week 3","Overtime  ","Week 4","Overtime   ","Week 5","Overtime    "]
[null,"Monday"]
[null,"Tuesday"]
[null,"Wednesday"]
[null,"Thursday"]
[null,"Friday"]
[null,"Saturday"]
[null,"Sunday"]
[null,"Total weekly hours",{"$f":"SUBTOTAL(109,December[Week 1])","v":0},{"$f":"SUBTOTAL(109,December[Overtime])","v":0},{"$f":"SUBTOTAL(109,December[Week 2])","v":0},{"$f":"SUBTOTAL(109,December[[Overtime ]])","v":0},{"$f":"SUBTOTAL(109,December[Week 3])","v":0},{"$f":"SUBTOTAL(109,December[[Overtime  ]])","v":0},{"$f":"SUBTOTAL(109,December[Week 4])","v":0},{"$f":"SUBTOTAL(109,December[[Overtime   ]])","v":0},{"$f":"SUBTOTAL(109,December[Week 5])","v":0},{"$f":"SUBTOTAL(109,December[[Overtime    ]])","v":0}]
[null,"Dec. total: Regular hours",{"$f":"SUM(December[[#Totals],[Week 1]],December[[#Totals],[Week 2]],December[[#Totals],[Week 3]],December[[#Totals],[Week 4]],December[[#Totals],[Week 5]])","v":0},"Dec. total: Overtime",null,{"$f":"SUM(December[[#Totals],[Overtime]],December[[#Totals],[Overtime ]],December[[#Totals],[Overtime  ]],December[[#Totals],[Overtime   ]],December[[#Totals],[Overtime    ]])","v":0}]