{"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 Timesheet."]
[null,"Fill in basic information like Employee Name, Manager Name, Email address and Phone number. "]
[null,"Add your hours to each month’s table. Log regular hours and overtime hours in separate columns for each weekday of each week. "]
[null,"Total Working, Regular and Overtime hours are calculated automatically. "]
[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 colour. "]
[null,"To learn more about tables, press SHIFT and then F10 within a table, select the TABLE option, then select ALTERNATIVE TEXT."]

{"sheet":"YEARLY TIMESHEET","index":1,"n_rows":132,"n_cols":15,"rows_kept":132,"merged":[[0,1,0,2],[0,4,0,14],[10,6,10,7],[21,6,21,7],[32,6,32,7],[33,4,33,14],[43,6,43,7],[54,6,54,7],[65,6,65,7],[66,4,66,14],[76,6,76,7],[87,6,87,7],[98,6,98,7],[99,4,99,14],[109,6,109,7],[120,6,120,7],[131,6,131,7]]}
["Create a daily, weekly, monthly or yearly Employee timesheet in this worksheet. \nHelpful instructions for how to use this workbook are in cells in this column. Arrow-down to get started.\nTitle of this worksheet is in cell to the right and January, February, March quarter heading is in cell E1.","EMPLOYEE \nTIMESHEET",null,null,"January, February, March      Employee Timesheet: Daily, Weekly, Monthly, Yearly"]
["Enter Employee Name in cell C2 and regular and overtime hours in January table starting in cell E2.","Employee Name:",null,null,"January","Week 1","Overtime","Week 2","Overtime  ","Week 3","Overtime   ","Week 4","Overtime    ","Week 5","Overtime     "]
["Enter Manager name in cell C3.","Manager:",null,null,"Monday",{"v":8,"d":"8.0"}]
["Enter Email address in cell C4.","Email Address:",null,null,"Tuesday",{"v":8,"d":"8.0"},{"v":2,"d":"2.0"}]
["Enter Phone number in cell C5. Next instruction is in cell A9.","Phone Number:",null,null,"Wednesday"]
[{"$nulls":4},"Thursday"]
[{"$nulls":4},"Friday"]
[{"$nulls":4},"Saturday"]
["Annual total regular hours are auto-calculated in cell C9.","Regular hrs.:",{"$f":"RegularHrs","v":31},null,"Sunday"]
["Annual total overtime hours are auto-calculated in cell C10.","Overtime hrs.:",{"$f":"Overtime_hrs","v":4},null,"Total weekly hours",{"$f":"SUM(F3:F9)","v":{"v":16,"d":"16.0"}},{"v":2,"d":"2.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"}]
["Annual overall total hours are auto-calculated in cell C11. January total regular hours in cell F11 and January total overtime hours in cell I11 are auto-calculated. Next instruction is in cell A13.","Total",{"$f":"RegularHrs+Overtime_hrs","v":35},null,{"$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":16,"d":"16.0"}},{"$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"}}]
[]
["Enter regular and overtime hours in February table starting in cell E13. Next instruction is in cell A22.",{"$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"}]
[{"$nulls":4},"Tuesday",{"v":7,"d":"7.0"},{"v":2,"d":"2.0"}]
[{"$nulls":4},"Wednesday"]
[{"$nulls":4},"Thursday"]
[{"$nulls":4},"Friday"]
[{"$nulls":4},"Saturday"]
[{"$nulls":4},"Sunday"]
[{"$nulls":4},"Total weekly hours",{"$f":"SUM(F14:F20)","v":{"v":15,"d":"15.0"}},{"v":2,"d":"2.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"}]
["February total regular hours in cell F22 and February total overtime hours in cell I22 are auto-calculated. Next instruction is in cell A24.",{"$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":15,"d":"15.0"}},{"$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":{"v":2,"d":"2.0"}}]
[]
["Enter regular and overtime hours in March table starting in cell E24. Next instruction is in cell A33.",{"$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(F25:F31)","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"}]
["March total regular hours in cell F33 and March total overtime hours in cell I33 are auto-calculated.",{"$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"}},{"$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"}}]
["April, May, June second quarter heading is in cell E34. ",{"$nulls":3},"April, May, June      Employee Timesheet: Daily, Weekly, Monthly, Yearly"]
["Enter regular and overtime hours for April in table starting in cell E35. Next instruction is in cell A44.",{"$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(F36:F42)","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"}]
["April total regular hours in cell F44 and April total overtime hours in cell I44 are auto-calculated. Next instruction is in cell A46.",{"$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"}},{"$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"}}]
[]
["Enter regular and overtime hours for May in table starting in cell E46. Next instruction is in cell A55.",{"$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(F47:F53)","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"}]
["May total regular hours in cell F55 and May total overtime hours in cell I55 are auto-calculated. Next instruction is in cell A57.",{"$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"}},{"$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"}}]
[]
["Enter regular and overtime hours for June in table starting in cell E57. Next instruction is in cell A66.",{"$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(F58:F64)","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"}]
["June total regular hours in cell F66 and June total overtime hours in cell I66 are auto-calculated.",{"$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"}},{"$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"}}]
["July, August, September third quarter heading is in cell E67. ",{"$nulls":3},"July, August, September      Employee Timesheet: Daily, Weekly, Monthly, Yearly"]
["Enter regular and overtime hours for July in table starting in cell E68. Next instruction is in cell A77.",{"$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(F69:F75)","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"}]
["July total regular hours in cell F77 and July total overtime hours in cell I77 are auto-calculated. Next instruction is in cell A79.",{"$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"}},{"$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"}}]
[]
["Enter regular and overtime hours for August in table starting in cell E79. Next instruction is in cell A88.",{"$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"}}]
["August total regular hours in cell F88 and August total overtime hours in cell I88 are auto-calculated. Next instruction is in cell A90.",{"$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"}},{"$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"}}]
[]
["Enter regular and overtime hours for September in table starting in cell E90. Next instruction is in cell A99.",{"$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"}}]
["September total regular hours in cell F99 and September total overtime hours in cell I99 are auto-calculated.",{"$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"}},{"$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"}}]
["October, November, December fourth quarter heading is in cell E100. ",{"$nulls":3},"October, November, December      Employee Timesheet: Daily, Weekly, Monthly, Yearly"]
["Enter regular and overtime hours for October in table starting in cell E101. Next instruction is in cell A110.",{"$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"}}]
["October total regular hours in cell F110 and October total overtime hours in cell I110 are auto-calculated. Next instruction is in cell A112.",{"$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"}},{"$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"}}]
[]
["Enter regular and overtime hours for November in table starting in cell E112. Next instruction is in cell A121.",{"$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"}}]
["November total regular hours in cell F121 and November total overtime hours in cell I121 are auto-calculated. Next instruction is in cell A123.",{"$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"}},{"$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"}}]
[]
["Enter regular and overtime hours for December in table starting in cell E123. Next instruction is in cell A132.",{"$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"}}]
["December total regular hours in cell F132 and December total overtime hours in cell I132 are auto-calculated.",{"$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"}},{"$f":"TEXT(DATEVALUE(December[[#Headers],[December]]&\" \"&YEAR(TODAY())),\"mmm.\")&\" total: Overtime\"","v":"Dec. total: Overtime"},null,{"$f":"SUM(G124:G130,I124:I130,K124:K130,M124:M130,O124:O130)","v":{"v":0,"d":"0.0"}}]