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

{"sheet":"Start","index":0,"n_rows":8,"n_cols":2,"rows_kept":8}
[null,"About this template"]
[null,"Track your hours daily, weekly, monthly and annually in this employee timecard."]
[null,"Fill in basic information like employee name, manager name, email address, and phone number. "]
[null,"Add your hours to each month table. Log regular hours and overtime hours in separate columns for each weekday of each week. "]
[null,"Total working, regular, and overtime hours are automatically calculated. "]
[null,"Notes:  "]
[null,"Additional instructions have been provided in column A in YEARLY TIMESHEET worksheet. This text has been intentionally hidden. To remove text, select column A, then select DELETE. To unhide text, select column A, then change font color. "]
[null,"To learn more about tables, press SHIFT and then F10 within a table, select the TABLE option, and then select ALTERNATIVE TEXT."]

{"sheet":"Yearly timesheet","index":1,"n_rows":138,"n_cols":15,"rows_kept":138,"merged":[[1,1,22,1],[1,5,1,6],[2,5,2,6],[3,5,3,6]]}
[]
[null,"EMPLOYEE TIMECARD",null,null,"Employee name:","Mohan Narang",null,"Regular hrs.:",null,"Overtime hrs.:",null,"Total",null,"Manager:"]
[{"$nulls":4},"E-mail:","mohan@example.com",null,{"$f":"RegularHrs","v":400},null,{"$f":"Overtime_hrs","v":2},null,{"$f":"RegularHrs+Overtime_hrs","v":402},null,"Shir Rosenstein"]
[{"$nulls":4},"Phone:","(212) 555-0123"]
[]
[]
[" ",{"$nulls":3},"January, February, March   |   Employee timecard: daily, weekly, monthly, yearly"]
[" ",{"$nulls":3},"January","Week 1","Overtime","Week 2","Overtime  ","Week 3","Overtime   ","Week 4","Overtime    ","Week 5","Overtime     "]
[" ",{"$nulls":3},"Monday",{"v":8,"d":"8.0"},null,{"v":8,"d":"8.0"},null,{"v":8,"d":"8.0"},null,{"v":8,"d":"8.0"},null,{"v":8,"d":"8.0"}]
[" ",{"$nulls":3},"Tuesday",{"v":8,"d":"8.0"},{"v":2,"d":"2.0"},{"v":8,"d":"8.0"},null,{"v":8,"d":"8.0"},null,{"v":8,"d":"8.0"},null,{"v":8,"d":"8.0"}]
[" ",{"$nulls":3},"Wednesday",{"v":8,"d":"8.0"},null,{"v":8,"d":"8.0"},null,{"v":8,"d":"8.0"},null,{"v":8,"d":"8.0"},null,{"v":8,"d":"8.0"}]
[{"$nulls":4},"Thursday",{"v":8,"d":"8.0"},null,{"v":8,"d":"8.0"},null,{"v":8,"d":"8.0"},null,{"v":8,"d":"8.0"},null,{"v":8,"d":"8.0"}]
[{"$nulls":4},"Friday",{"v":8,"d":"8.0"},null,{"v":8,"d":"8.0"},null,{"v":8,"d":"8.0"},null,{"v":8,"d":"8.0"},null,{"v":8,"d":"8.0"}]
[{"$nulls":4},"Saturday"]
[" ",{"$nulls":3},"Sunday"]
[" ",{"$nulls":3},"Total weekly hours",{"$f":"SUM(F9:F15)","v":{"v":40,"d":"40.0"}},{"v":2,"d":"2.0"},{"v":40,"d":"40.0"},{"v":0,"d":"0.0"},{"v":40,"d":"40.0"},{"v":0,"d":"0.0"},{"v":40,"d":"40.0"},{"v":0,"d":"0.0"},{"v":40,"d":"40.0"},{"v":0,"d":"0.0"}]
[" ",{"$nulls":3},{"$f":"TEXT(DATEVALUE(January[[#Headers],[January]]&\"  \"&YEAR(TODAY())),\"mmm.\")&\" Total: Regular hours\"","v":"Jan. Total: Regular hours"},{"$f":"SUM(January[Week 1],January[Week 2],January[Week 3],January[Week 4],January[Week 5])","v":{"v":200,"d":"200.0"}},{"$nulls":5},{"$f":"TEXT(DATEVALUE(January[[#Headers],[January]]&\"  \"&YEAR(TODAY())),\"mmm.\")&\" total: Overtime\"","v":"Jan. total: Overtime"},null,{"$f":"SUM(January[Overtime],January[[Overtime  ]],January[[Overtime   ]],January[[Overtime    ]],January[[Overtime     ]])","v":{"v":2,"d":"2.0"}}]
[]
[" ",{"$nulls":3},"February","Week 1","Overtime","Week 2","Overtime  ","Week 3","Overtime   ","Week 4","Overtime    ","Week 5","Overtime     "]
[{"$nulls":4},"Monday",{"v":8,"d":"8.0"},null,{"v":8,"d":"8.0"},null,{"v":8,"d":"8.0"},null,{"v":8,"d":"8.0"},null,{"v":8,"d":"8.0"}]
[{"$nulls":4},"Tuesday",{"v":8,"d":"8.0"},{"v":2,"d":"2.0"},{"v":8,"d":"8.0"},null,{"v":8,"d":"8.0"},null,{"v":8,"d":"8.0"},null,{"v":8,"d":"8.0"}]
[{"$nulls":4},"Wednesday",{"v":8,"d":"8.0"},null,{"v":8,"d":"8.0"},null,{"v":8,"d":"8.0"},null,{"v":8,"d":"8.0"},null,{"v":8,"d":"8.0"}]
[{"$nulls":4},"Thursday",{"v":8,"d":"8.0"},null,{"v":8,"d":"8.0"},null,{"v":8,"d":"8.0"},3.5,{"v":8,"d":"8.0"},null,{"v":8,"d":"8.0"}]
[{"$nulls":4},"Friday",{"v":8,"d":"8.0"},null,{"v":8,"d":"8.0"},null,{"v":8,"d":"8.0"},null,{"v":8,"d":"8.0"},null,{"v":8,"d":"8.0"}]
[{"$nulls":4},"Saturday"]
[{"$nulls":4},"Sunday"]
[{"$nulls":4},"Total weekly hours",{"$f":"SUM(F20:F26)","v":{"v":40,"d":"40.0"}},{"v":2,"d":"2.0"},{"v":40,"d":"40.0"},{"v":0,"d":"0.0"},{"v":40,"d":"40.0"},3.5,{"v":40,"d":"40.0"},{"v":0,"d":"0.0"},{"v":40,"d":"40.0"},{"v":0,"d":"0.0"}]
[" ",{"$nulls":3},{"$f":"TEXT(DATEVALUE(February[[#Headers],[February]]&\"  \"&YEAR(TODAY())),\"mmm.\")&\" total: Regular hours\"","v":"Feb. total: Regular hours"},{"$f":"SUM(February[Week 1],February[Week 2],February[Week 3],February[Week 4],February[Week 5])","v":{"v":200,"d":"200.0"}},{"$nulls":5},{"$f":"TEXT(DATEVALUE(February[[#Headers],[February]]&\" \"&YEAR(TODAY())),\"mmm.\")&\" total: Overtime\"","v":"Feb. total: Overtime"},null,{"$f":"SUM(February[Overtime],February[[Overtime  ]],February[[Overtime   ]],February[[Overtime    ]],February[[Overtime     ]])","v":5.5}]
[]
[" ",{"$nulls":3},"March","Week 1","Overtime","Week 2","Overtime  ","Week 3","Overtime ","Week 4","Overtime    ","Week 5","Overtime     "]
[{"$nulls":4},"Monday"]
[{"$nulls":4},"Tuesday"]
[{"$nulls":4},"Wednesday"]
[{"$nulls":4},"Thursday"]
[{"$nulls":4},"Friday"]
[{"$nulls":4},"Saturday"]
[{"$nulls":4},"Sunday"]
[{"$nulls":4},"Total weekly hours",{"$f":"SUM(F31:F37)","v":{"v":0,"d":"0.0"}},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"}]
[" ",{"$nulls":3},{"$f":"TEXT(DATEVALUE(March[[#Headers],[March]]&\" \"&YEAR(TODAY())),\"mmm.\")&\" total: Regular hours\"","v":"Mar. total: Regular hours"},{"$f":"SUM(March[Week 1],March[Week 2],March[Week 3],March[Week 4],March[Week 5])","v":{"v":0,"d":"0.0"}},{"$nulls":5},{"$f":"TEXT(DATEVALUE(March[[#Headers],[March]]&\" \"&YEAR(TODAY())),\"mmm.\")&\" total: Overtime\"","v":"Mar. total: Overtime"},null,{"$f":"SUM(March[Overtime],March[[Overtime  ]],March[[Overtime ]],March[[Overtime    ]],March[[Overtime     ]])","v":{"v":0,"d":"0.0"}}]
[" ",{"$nulls":3},"April, May, June   |   Employee Timecard: Daily, Weekly, Monthly, Yearly"]
[" ",{"$nulls":3},"April","Week 1","Overtime","Week 2","Overtime  ","Week 3","Overtime   ","Week 4","Overtime    ","Week 5","Overtime     "]
[{"$nulls":4},"Monday"]
[{"$nulls":4},"Tuesday"]
[{"$nulls":4},"Wednesday"]
[{"$nulls":4},"Thursday"]
[{"$nulls":4},"Friday"]
[{"$nulls":4},"Saturday"]
[{"$nulls":4},"Sunday"]
[{"$nulls":4},"Total weekly hours",{"$f":"SUM(F42:F48)","v":{"v":0,"d":"0.0"}},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"}]
[" ",{"$nulls":3},{"$f":"TEXT(DATEVALUE(April[[#Headers],[April]]&\" \"&YEAR(TODAY())),\"mmm.\")&\" total: Regular hours\"","v":"Apr. total: Regular hours"},{"$f":"SUM(April[Week 1],April[Week 2],April[Week 3],April[Week 4],April[Week 5])","v":{"v":0,"d":"0.0"}},{"$nulls":5},{"$f":"TEXT(DATEVALUE(April[[#Headers],[April]]&\" \"&YEAR(TODAY())),\"mmm.\")&\" total: Overtime\"","v":"Apr. total: Overtime"},null,{"$f":"SUM(April[Overtime],April[[Overtime  ]],April[[Overtime   ]],April[[Overtime    ]],April[[Overtime     ]])","v":{"v":0,"d":"0.0"}}]
[]
[" ",{"$nulls":3},"May","Week 1","Overtime","Week 2","Overtime  ","Week 3","Overtime   ","Week 4","Overtime    ","Week 5","Overtime     "]
[{"$nulls":4},"Monday"]
[{"$nulls":4},"Tuesday"]
[{"$nulls":4},"Wednesday"]
[{"$nulls":4},"Thursday"]
[{"$nulls":4},"Friday"]
[{"$nulls":4},"Saturday"]
[{"$nulls":4},"Sunday"]
[{"$nulls":4},"Total weekly hours",{"$f":"SUM(F53:F59)","v":{"v":0,"d":"0.0"}},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"}]
[" ",{"$nulls":3},{"$f":"TEXT(DATEVALUE(May[[#Headers],[May]]&\" \"&YEAR(TODAY())),\"mmm.\")&\" total: Regular hours\"","v":"May. total: Regular hours"},{"$f":"SUM(May[Week 1],May[Week 2],May[Week 3],May[Week 4],May[Week 5])","v":{"v":0,"d":"0.0"}},{"$nulls":5},{"$f":"TEXT(DATEVALUE(May[[#Headers],[May]]&\" \"&YEAR(TODAY())),\"mmm.\")&\" total: Overtime\"","v":"May. total: Overtime"},null,{"$f":"SUM(May[Overtime],May[[Overtime  ]],May[[Overtime   ]],May[[Overtime    ]],May[[Overtime     ]])","v":{"v":0,"d":"0.0"}}]
[]
[" ",{"$nulls":3},"June","Week 1","Overtime","Week 2","Overtime  ","Week 3","Overtime   ","Week 4","Overtime    ","Week 5","Overtime     "]
[{"$nulls":4},"Monday"]
[{"$nulls":4},"Tuesday"]
[{"$nulls":4},"Wednesday"]
[{"$nulls":4},"Thursday"]
[{"$nulls":4},"Friday"]
[{"$nulls":4},"Saturday"]
[{"$nulls":4},"Sunday"]
[{"$nulls":4},"Total weekly hours",{"$f":"SUM(F64:F70)","v":{"v":0,"d":"0.0"}},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"}]
[" ",{"$nulls":3},{"$f":"TEXT(DATEVALUE(June[[#Headers],[June]]&\" \"&YEAR(TODAY())),\"mmm.\")&\" total: Regular hours\"","v":"Jun. total: Regular hours"},{"$f":"SUM(June[Week 1],June[Week 2],June[Week 3],June[Week 4],June[Week 5])","v":{"v":0,"d":"0.0"}},{"$nulls":5},{"$f":"TEXT(DATEVALUE(June[[#Headers],[June]]&\" \"&YEAR(TODAY())),\"mmm.\")&\" total: Overtime\"","v":"Jun. total: Overtime"},null,{"$f":"SUM(June[Overtime],June[[Overtime  ]],June[[Overtime   ]],June[[Overtime    ]],June[[Overtime     ]])","v":{"v":0,"d":"0.0"}}]
[" ",{"$nulls":3},"July, August, September   |   Employee Timecard: Daily, Weekly, Monthly, Yearly"]
[" ",{"$nulls":3},"July","Week 1","Overtime","Week 2","Overtime ","Week 3","Overtime  ","Week 4","Overtime   ","Week 5","Overtime     "]
[{"$nulls":4},"Monday"]
[{"$nulls":4},"Tuesday"]
[{"$nulls":4},"Wednesday"]
[{"$nulls":4},"Thursday"]
[{"$nulls":4},"Friday"]
[{"$nulls":4},"Saturday"]
[{"$nulls":4},"Sunday"]
[{"$nulls":4},"Total weekly hours",{"$f":"SUM(F75:F81)","v":{"v":0,"d":"0.0"}},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"}]
[" ",{"$nulls":3},{"$f":"TEXT(DATEVALUE(July[[#Headers],[July]]&\" \"&YEAR(TODAY())),\"mmm.\")&\" total: Regular hours\"","v":"Jul. total: Regular hours"},{"$f":"SUM(July[Week 1],July[Week 2],July[Week 3],July[Week 4],July[Week 5])","v":{"v":0,"d":"0.0"}},{"$nulls":5},{"$f":"TEXT(DATEVALUE(July[[#Headers],[July]]&\" \"&YEAR(TODAY())),\"mmm.\")&\" total: Overtime\"","v":"Jul. total: Overtime"},null,{"$f":"SUM(July[Overtime],July[[Overtime ]],July[[Overtime  ]],July[[Overtime   ]],July[[Overtime     ]])","v":{"v":0,"d":"0.0"}}]
[]
[" ",{"$nulls":3},"August","Week 1","Overtime","Week 2","Overtime ","Week 3","Overtime   ","Week 4","Overtime  ","Week 5","Overtime    "]
[{"$nulls":4},"Monday"]
[{"$nulls":4},"Tuesday"]
[{"$nulls":4},"Wednesday"]
[{"$nulls":4},"Thursday"]
[{"$nulls":4},"Friday"]
[{"$nulls":4},"Saturday"]
[{"$nulls":4},"Sunday"]
[{"$nulls":4},"Total weekly hours",{"$f":"SUBTOTAL(109,August[Week 1])","v":{"v":0,"d":"0.0"}},{"$f":"SUBTOTAL(109,August[Overtime])","v":{"v":0,"d":"0.0"}},{"$f":"SUBTOTAL(109,August[Week 2])","v":{"v":0,"d":"0.0"}},{"$f":"SUBTOTAL(109,August[[Overtime ]])","v":{"v":0,"d":"0.0"}},{"$f":"SUBTOTAL(109,August[Week 3])","v":{"v":0,"d":"0.0"}},{"$f":"SUBTOTAL(109,August[[Overtime   ]])","v":{"v":0,"d":"0.0"}},{"$f":"SUBTOTAL(109,August[Week 4])","v":{"v":0,"d":"0.0"}},{"$f":"SUBTOTAL(109,August[[Overtime  ]])","v":{"v":0,"d":"0.0"}},{"$f":"SUBTOTAL(109,August[Week 5])","v":{"v":0,"d":"0.0"}},{"$f":"SUBTOTAL(109,August[[Overtime    ]])","v":{"v":0,"d":"0.0"}}]
[" ",{"$nulls":3},{"$f":"TEXT(DATEVALUE(August[[#Headers],[August]]&\" \"&YEAR(TODAY())),\"mmm.\")&\" total: Regular hours\"","v":"Aug. total: Regular hours"},{"$f":"SUM(August[Week 1],August[Week 2],August[Week 3],August[Week 4],August[Week 5])","v":{"v":0,"d":"0.0"}},{"$nulls":5},{"$f":"TEXT(DATEVALUE(August[[#Headers],[August]]&\" \"&YEAR(TODAY())),\"mmm.\")&\" total: Overtime\"","v":"Aug. total: Overtime"},null,{"$f":"SUM(August[Overtime],August[[Overtime ]],August[[Overtime   ]],August[[Overtime  ]],August[[Overtime    ]])","v":{"v":0,"d":"0.0"}}]
[]
[" ",{"$nulls":3},"September","Week 1","Overtime","Week 2","Overtime ","Week 3","Overtime  ","Week 4","Overtime   ","Week 5","Overtime    "]
[{"$nulls":4},"Monday"]
[{"$nulls":4},"Tuesday"]
[{"$nulls":4},"Wednesday"]
[{"$nulls":4},"Thursday"]
[{"$nulls":4},"Friday"]
[{"$nulls":4},"Saturday"]
[{"$nulls":4},"Sunday"]
[{"$nulls":4},"Total weekly hours",{"$f":"SUBTOTAL(109,September[Week 1])","v":{"v":0,"d":"0.0"}},{"$f":"SUBTOTAL(109,September[Overtime])","v":{"v":0,"d":"0.0"}},{"$f":"SUBTOTAL(109,September[Week 2])","v":{"v":0,"d":"0.0"}},{"$f":"SUBTOTAL(109,September[[Overtime ]])","v":{"v":0,"d":"0.0"}},{"$f":"SUBTOTAL(109,September[Week 3])","v":{"v":0,"d":"0.0"}},{"$f":"SUBTOTAL(109,September[[Overtime  ]])","v":{"v":0,"d":"0.0"}},{"$f":"SUBTOTAL(109,September[Week 4])","v":{"v":0,"d":"0.0"}},{"$f":"SUBTOTAL(109,September[[Overtime   ]])","v":{"v":0,"d":"0.0"}},{"$f":"SUBTOTAL(109,September[Week 5])","v":{"v":0,"d":"0.0"}},{"$f":"SUBTOTAL(109,September[[Overtime    ]])","v":{"v":0,"d":"0.0"}}]
[" ",{"$nulls":3},{"$f":"TEXT(DATEVALUE(September[[#Headers],[September]]&\" \"&YEAR(TODAY())),\"mmm.\")&\" total: Regular hours\"","v":"Sep. total: Regular hours"},{"$f":"SUM(September[Week 1],September[Week 2],September[Week 3],September[Week 4],September[Week 5])","v":{"v":0,"d":"0.0"}},{"$nulls":5},{"$f":"TEXT(DATEVALUE(September[[#Headers],[September]]&\" \"&YEAR(TODAY())),\"mmm.\")&\" total: Overtime\"","v":"Sep. total: Overtime"},null,{"$f":"SUM(September[Overtime],September[[Overtime ]],September[[Overtime  ]],September[[Overtime   ]],September[[Overtime    ]])","v":{"v":0,"d":"0.0"}}]
[" ",{"$nulls":3},"October, November, December   |   Employee Timecard: Daily, Weekly, Monthly, Yearly"]
[" ",{"$nulls":3},"October","Week 1","Overtime","Week 2","Overtime ","Week 3","Overtime  ","Week 4","Overtime   ","Week 5","Overtime    "]
[{"$nulls":4},"Monday"]
[{"$nulls":4},"Tuesday"]
[{"$nulls":4},"Wednesday"]
[{"$nulls":4},"Thursday"]
[{"$nulls":4},"Friday"]
[{"$nulls":4},"Saturday"]
[{"$nulls":4},"Sunday"]
[{"$nulls":4},"Total weekly hours",{"$f":"SUBTOTAL(109,October[Week 1])","v":{"v":0,"d":"0.0"}},{"$f":"SUBTOTAL(109,October[Overtime])","v":{"v":0,"d":"0.0"}},{"$f":"SUBTOTAL(109,October[Week 2])","v":{"v":0,"d":"0.0"}},{"$f":"SUBTOTAL(109,October[[Overtime ]])","v":{"v":0,"d":"0.0"}},{"$f":"SUBTOTAL(109,October[Week 3])","v":{"v":0,"d":"0.0"}},{"$f":"SUBTOTAL(109,October[[Overtime  ]])","v":{"v":0,"d":"0.0"}},{"$f":"SUBTOTAL(109,October[Week 4])","v":{"v":0,"d":"0.0"}},{"$f":"SUBTOTAL(109,October[[Overtime   ]])","v":{"v":0,"d":"0.0"}},{"$f":"SUBTOTAL(109,October[Week 5])","v":{"v":0,"d":"0.0"}},{"$f":"SUBTOTAL(109,October[[Overtime    ]])","v":{"v":0,"d":"0.0"}}]
[" ",{"$nulls":3},{"$f":"TEXT(DATEVALUE(October[[#Headers],[October]]&\" \"&YEAR(TODAY())),\"mmm.\")&\" total: Regular hours\"","v":"Oct. total: Regular hours"},{"$f":"SUM(October[Week 1],October[Week 2],October[Week 3],October[Week 4],October[Week 5])","v":{"v":0,"d":"0.0"}},{"$nulls":5},{"$f":"TEXT(DATEVALUE(October[[#Headers],[October]]&\" \"&YEAR(TODAY())),\"mmm.\")&\" total: Overtime\"","v":"Oct. total: Overtime"},null,{"$f":"SUM(October[Overtime],October[[Overtime ]],October[[Overtime  ]],October[[Overtime   ]],October[[Overtime    ]])","v":{"v":0,"d":"0.0"}}]
[]
[" ",{"$nulls":3},"November","Week 1","Overtime","Week 2","Overtime ","Week 3","Overtime  ","Week 4","Overtime    ","Week 5","Overtime     "]
[{"$nulls":4},"Monday"]
[{"$nulls":4},"Tuesday"]
[{"$nulls":4},"Wednesday"]
[{"$nulls":4},"Thursday"]
[{"$nulls":4},"Friday"]
[{"$nulls":4},"Saturday"]
[{"$nulls":4},"Sunday"]
[{"$nulls":4},"Total weekly hours",{"$f":"SUBTOTAL(109,November[Week 1])","v":{"v":0,"d":"0.0"}},{"$f":"SUBTOTAL(109,November[Overtime])","v":{"v":0,"d":"0.0"}},{"$f":"SUBTOTAL(109,November[Week 2])","v":{"v":0,"d":"0.0"}},{"$f":"SUBTOTAL(109,November[[Overtime ]])","v":{"v":0,"d":"0.0"}},{"$f":"SUBTOTAL(109,November[Week 3])","v":{"v":0,"d":"0.0"}},{"$f":"SUBTOTAL(109,November[[Overtime  ]])","v":{"v":0,"d":"0.0"}},{"$f":"SUBTOTAL(109,November[Week 4])","v":{"v":0,"d":"0.0"}},{"$f":"SUBTOTAL(109,November[[Overtime    ]])","v":{"v":0,"d":"0.0"}},{"$f":"SUBTOTAL(109,November[Week 5])","v":{"v":0,"d":"0.0"}},{"$f":"SUBTOTAL(109,November[[Overtime     ]])","v":{"v":0,"d":"0.0"}}]
[" ",{"$nulls":3},{"$f":"TEXT(DATEVALUE(November[[#Headers],[November]]&\" \"&YEAR(TODAY())),\"mmm.\")&\" total: Regular hours\"","v":"Nov. total: Regular hours"},{"$f":"SUM(November[Week 1],November[Week 2],November[Week 3],November[Week 4],November[Week 5])","v":{"v":0,"d":"0.0"}},{"$nulls":5},{"$f":"TEXT(DATEVALUE(November[[#Headers],[November]]&\" \"&YEAR(TODAY())),\"mmm.\")&\" total: Overtime\"","v":"Nov. total: Overtime"},null,{"$f":"SUM(November[Overtime],November[[Overtime ]],November[[Overtime  ]],November[[Overtime    ]],November[[Overtime     ]])","v":{"v":0,"d":"0.0"}}]
[]
[" ",{"$nulls":3},"December","Week 1","Overtime","Week 2","Overtime ","Week 3","Overtime  ","Week 4","Overtime   ","Week 5","Overtime    "]
[{"$nulls":4},"Monday"]
[{"$nulls":4},"Tuesday"]
[{"$nulls":4},"Wednesday"]
[{"$nulls":4},"Thursday"]
[{"$nulls":4},"Friday"]
[{"$nulls":4},"Saturday"]
[{"$nulls":4},"Sunday"]
[{"$nulls":4},"Total weekly hours",{"$f":"SUBTOTAL(109,December[Week 1])","v":{"v":0,"d":"0.0"}},{"$f":"SUBTOTAL(109,December[Overtime])","v":{"v":0,"d":"0.0"}},{"$f":"SUBTOTAL(109,December[Week 2])","v":{"v":0,"d":"0.0"}},{"$f":"SUBTOTAL(109,December[[Overtime ]])","v":{"v":0,"d":"0.0"}},{"$f":"SUBTOTAL(109,December[Week 3])","v":{"v":0,"d":"0.0"}},{"$f":"SUBTOTAL(109,December[[Overtime  ]])","v":{"v":0,"d":"0.0"}},{"$f":"SUBTOTAL(109,December[Week 4])","v":{"v":0,"d":"0.0"}},{"$f":"SUBTOTAL(109,December[[Overtime   ]])","v":{"v":0,"d":"0.0"}},{"$f":"SUBTOTAL(109,December[Week 5])","v":{"v":0,"d":"0.0"}},{"$f":"SUBTOTAL(109,December[[Overtime    ]])","v":{"v":0,"d":"0.0"}}]
[" ",{"$nulls":3},{"$f":"TEXT(DATEVALUE(December[[#Headers],[December]]&\" \"&YEAR(TODAY())),\"mmm.\")&\" total: Regular hours\"","v":"Dec. total: Regular hours"},{"$f":"SUM(December[Week 1],December[Week 2],December[Week 3],December[Week 4],December[Week 5])","v":{"v":0,"d":"0.0"}},{"$nulls":5},{"$f":"TEXT(DATEVALUE(December[[#Headers],[December]]&\" \"&YEAR(TODAY())),\"mmm.\")&\" total: Overtime\"","v":"Dec. total: Overtime"},null,{"$f":"SUM(L130:L136,N130:N136,P130:P136,R130:R136,T130:T136)","v":{"v":0,"d":"0.0"}}]