{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["YEARLY TIMESHEET"],"read":"whole","date_system":"1900"}

{"sheet":"YEARLY TIMESHEET","index":0,"n_rows":141,"n_cols":12,"rows_kept":141,"merged":[[3,2,3,3],[3,5,3,6],[4,2,4,3],[4,5,4,6]]}
[]
[null,"EMPLOYEE TIMECARD"]
[]
[null,"Employee Name:",null,null,"E-mail:",{"$nulls":3},"Regular hrs:",{"$f":"SUMIF(B:B,\"*Regular hours\",C:D)","v":31}]
[null,"Manager:",null,null,"Phone:",{"$nulls":3},"Overtime hrs:",{"$f":"SUMIF(D:D,\"*Overtime\",F:F)","v":4},"Total:",{"$f":"SUM(J4:J5)","v":35}]
[]
[null,"January, February, March      Employee Timecard: Daily, Weekly, Monthly, Yearly"]
[null,"January","Week 1","Overtime","Week 2","Overtime","Week 3","Overtime","Week 4","Overtime","Week 5","Overtime"]
[null,"Monday",{"v":8,"d":"8.0"}]
[null,"Tuesday",{"v":8,"d":"8.0"},{"v":2,"d":"2.0"}]
[null,"Wednesday"]
[null,"Thursday"]
[null,"Friday"]
[null,"Saturday"]
[null,"Sunday"]
[null,"Total weekly hours",{"$f":"SUM(C9:C15)","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"}]
[null,{"$f":"TEXT(DATEVALUE(B8&\" 1, \"&YEAR(TODAY())),\"mmm.\")&\" total: Regular hours\"","v":"Jan. total: Regular hours"},{"$f":"SUMIF(C8:L8,\"<>Overtime\",C16:L16)","v":{"v":16,"d":"16.0"}},{"$f":"TEXT(DATEVALUE(B8&\" 1, \"&YEAR(TODAY())),\"mmm.\")&\" total: Overtime\"","v":"Jan. total: Overtime"},null,{"$f":"SUMIF(C8:L8,\"Overtime\",C16:L16)","v":{"v":2,"d":"2.0"}}]
[]
[null,"February","Week 1","Overtime","Week 2","Overtime","Week 3","Overtime","Week 4","Overtime","Week 5","Overtime"]
[null,"Monday",{"v":8,"d":"8.0"},{"v":2,"d":"2.0"}]
[null,"Tuesday",{"v":7,"d":"7.0"}]
[null,"Wednesday"]
[null,"Thursday"]
[null,"Friday"]
[null,"Saturday"]
[null,"Sunday"]
[null,"Total weekly hours",{"$f":"SUM(C20:C26)","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"}]
[null,{"$f":"TEXT(DATEVALUE(B19&\" 1, \"&YEAR(TODAY())),\"mmm.\")&\" total: Regular hours\"","v":"Feb. total: Regular hours"},{"$f":"SUMIF(C19:L19,\"<>Overtime\",C27:L27)","v":{"v":15,"d":"15.0"}},{"$f":"TEXT(DATEVALUE(B19&\" 1, \"&YEAR(TODAY())),\"mmm.\")&\" total: Overtime\"","v":"Feb. total: Overtime"},null,{"$f":"SUMIF(C19:L19,\"Overtime\",C27:L27)","v":{"v":2,"d":"2.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":"SUM(C31:C37)","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"}]
[null,{"$f":"TEXT(DATEVALUE(B30&\" 1, \"&YEAR(TODAY())),\"mmm.\")&\" total: Regular hours\"","v":"Mar. total: Regular hours"},{"$f":"SUMIF(C30:L30,\"<>Overtime\",C38:L38)","v":{"v":0,"d":"0.0"}},{"$f":"TEXT(DATEVALUE(B30&\" 1, \"&YEAR(TODAY())),\"mmm.\")&\" total: Overtime\"","v":"Mar. total: Overtime"},null,{"$f":"SUMIF(C30:L30,\"Overtime\",C38:L38)","v":{"v":0,"d":"0.0"}}]
[]
[null,"April, May, June      Employee Timecard: 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":"SUM(C43:C49)","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"}]
[null,{"$f":"TEXT(DATEVALUE(B42&\" 1, \"&YEAR(TODAY())),\"mmm.\")&\" total: Regular hours\"","v":"Apr. total: Regular hours"},{"$f":"SUMIF(C42:L42,\"<>Overtime\",C50:L50)","v":{"v":0,"d":"0.0"}},{"$f":"TEXT(DATEVALUE(B42&\" 1, \"&YEAR(TODAY())),\"mmm.\")&\" total: Overtime\"","v":"Apr. total: Overtime"},null,{"$f":"SUMIF(C42:L42,\"Overtime\",C50:L50)","v":{"v":0,"d":"0.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":"SUM(C54:C60)","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"}]
[null,{"$f":"TEXT(DATEVALUE(B53&\" 1, \"&YEAR(TODAY())),\"mmm.\")&\" total: Regular hours\"","v":"May. total: Regular hours"},{"$f":"SUMIF(C53:L53,\"<>Overtime\",C61:L61)","v":{"v":0,"d":"0.0"}},{"$f":"TEXT(DATEVALUE(B53&\" 1, \"&YEAR(TODAY())),\"mmm.\")&\" total: Overtime\"","v":"May. total: Overtime"},null,{"$f":"SUMIF(C53:L53,\"Overtime\",C61:L61)","v":{"v":0,"d":"0.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":"SUM(C65:C71)","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"}]
[null,{"$f":"TEXT(DATEVALUE(B64&\" 1, \"&YEAR(TODAY())),\"mmm.\")&\" total: Regular hours\"","v":"Jun. total: Regular hours"},{"$f":"SUMIF(C64:L64,\"<>Overtime\",C72:L72)","v":{"v":0,"d":"0.0"}},{"$f":"TEXT(DATEVALUE(B64&\" 1, \"&YEAR(TODAY())),\"mmm.\")&\" total: Overtime\"","v":"Jun. total: Overtime"},null,{"$f":"SUMIF(C64:L64,\"Overtime\",C72:L72)","v":{"v":0,"d":"0.0"}}]
[]
[null,"July, August, September      Employee Timecard: 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":"SUM(C77:C83)","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"}]
[null,{"$f":"TEXT(DATEVALUE(B76&\" 1, \"&YEAR(TODAY())),\"mmm.\")&\" total: Regular hours\"","v":"Jul. total: Regular hours"},{"$f":"SUMIF(C76:L76,\"<>Overtime\",C84:L84)","v":{"v":0,"d":"0.0"}},{"$f":"TEXT(DATEVALUE(B76&\" 1, \"&YEAR(TODAY())),\"mmm.\")&\" total: Overtime\"","v":"Jul. total: Overtime"},null,{"$f":"SUMIF(C76:L76,\"Overtime\",C84:L84)","v":{"v":0,"d":"0.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":"SUM(C88:C94)","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"}]
[null,{"$f":"TEXT(DATEVALUE(B87&\" 1, \"&YEAR(TODAY())),\"mmm.\")&\" total: Regular hours\"","v":"Aug. total: Regular hours"},{"$f":"SUMIF(C87:L87,\"<>Overtime\",C95:L95)","v":{"v":0,"d":"0.0"}},{"$f":"TEXT(DATEVALUE(B87&\" 1, \"&YEAR(TODAY())),\"mmm.\")&\" total: Overtime\"","v":"Aug. total: Overtime"},null,{"$f":"SUMIF(C87:L87,\"Overtime\",C95:L95)","v":{"v":0,"d":"0.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":"SUM(C99:C105)","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"}]
[null,{"$f":"TEXT(DATEVALUE(B98&\" 1, \"&YEAR(TODAY())),\"mmm.\")&\" total: Regular hours\"","v":"Sep. total: Regular hours"},{"$f":"SUMIF(C98:L98,\"<>Overtime\",C106:L106)","v":{"v":0,"d":"0.0"}},{"$f":"TEXT(DATEVALUE(B98&\" 1, \"&YEAR(TODAY())),\"mmm.\")&\" total: Overtime\"","v":"Sep. total: Overtime"},null,{"$f":"SUMIF(C98:L98,\"Overtime\",C106:L106)","v":{"v":0,"d":"0.0"}}]
[]
[null,"October, November, December      Employee Timecard: 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":"SUM(C111:C117)","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"}]
[null,{"$f":"TEXT(DATEVALUE(B110&\" 1, \"&YEAR(TODAY())),\"mmm.\")&\" total: Regular hours\"","v":"Oct. total: Regular hours"},{"$f":"SUMIF(C110:L110,\"<>Overtime\",C118:L118)","v":{"v":0,"d":"0.0"}},{"$f":"TEXT(DATEVALUE(B110&\" 1, \"&YEAR(TODAY())),\"mmm.\")&\" total: Overtime\"","v":"Oct. total: Overtime"},null,{"$f":"SUMIF(C110:L110,\"Overtime\",C118:L118)","v":{"v":0,"d":"0.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":"SUM(C122:C128)","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"}]
[null,{"$f":"TEXT(DATEVALUE(B121&\" 1, \"&YEAR(TODAY())),\"mmm.\")&\" total: Regular hours\"","v":"Nov. total: Regular hours"},{"$f":"SUMIF(C121:L121,\"<>Overtime\",C129:L129)","v":{"v":0,"d":"0.0"}},{"$f":"TEXT(DATEVALUE(B121&\" 1, \"&YEAR(TODAY())),\"mmm.\")&\" total: Overtime\"","v":"Nov. total: Overtime"},null,{"$f":"SUMIF(C121:L121,\"Overtime\",C129:L129)","v":{"v":0,"d":"0.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":"SUM(C133:C139)","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"}]
[null,{"$f":"TEXT(DATEVALUE(B132&\" 1, \"&YEAR(TODAY())),\"mmm.\")&\" total: Regular hours\"","v":"Dec. total: Regular hours"},{"$f":"SUMIF(C132:L132,\"<>Overtime\",C140:L140)","v":{"v":0,"d":"0.0"}},{"$f":"TEXT(DATEVALUE(B132&\" 1, \"&YEAR(TODAY())),\"mmm.\")&\" total: Overtime\"","v":"Dec. total: Overtime"},null,{"$f":"SUMIF(C132:L132,\"Overtime\",C140:L140)","v":{"v":0,"d":"0.0"}}]