{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["RawData","Tabulated","Pivot Totals"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"comments":0,"pivot_tables":1},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"RawData","index":0,"n_rows":47,"n_cols":6,"rows_kept":47,"cut":false,"hidden":false,"merged":[]}
["Empl","Punch","Machine","Code","InOut","CVE"]
[2,"2017-09-18T08:22:50",2,255,0,0]
[4,"2017-09-18T08:05:27",2,255,0,0]
[11,"2017-09-18T07:16:13",2,255,0,0]
[11,"2017-09-18T10:00:23",2,255,0,0]
[11,"2017-09-19T08:09:40",2,255,0,0]
[12,"2017-09-18T07:37:53",2,255,0,0]
[15,"2017-09-18T07:57:11",2,255,0,0]
[17,"2017-09-18T07:27:28",2,255,0,0]
[18,"2017-09-18T08:05:15",2,255,0,0]
[19,"2017-09-18T09:34:28",2,255,0,0]
[19,"2017-09-18T12:08:36",2,255,0,0]
[19,"2017-09-19T08:29:19",2,255,0,0]
[19,"2017-09-19T10:34:57",2,255,0,0]
[25,"2017-09-18T08:02:25",2,255,0,0]
[25,"2017-09-18T12:04:25",2,255,0,0]
[25,"2017-09-19T08:10:06",2,255,0,0]
[33,"2017-09-18T08:02:34",2,255,0,0]
[33,"2017-09-19T08:09:58",2,255,0,0]
[34,"2017-09-18T07:52:25",2,255,0,0]
[39,"2017-09-18T08:44:01",2,255,0,0]
[45,"2017-09-18T08:06:15",2,255,0,0]
[45,"2017-09-18T10:57:10",2,255,0,0]
[48,"2017-09-18T08:02:49",2,255,0,0]
[68,"2017-09-18T08:00:25",2,255,0,0]
[68,"2017-09-19T08:20:35",2,255,0,0]
[74,"2017-09-18T08:08:49",2,255,0,0]
[92,"2017-09-18T09:04:19",2,255,0,0]
[92,"2017-09-18T12:01:47",2,255,0,0]
[93,"2017-09-18T08:01:43",2,255,0,0]
[93,"2017-09-18T12:01:35",2,255,0,0]
[109,"2017-09-18T09:19:21",2,255,0,0]
[359,"2017-09-18T06:36:43",2,255,0,0]
[625,"2017-09-19T08:10:24",2,255,0,0]
[1011,"2017-09-18T07:54:57",2,255,0,0]
[1278,"2017-09-18T09:18:07",2,255,0,0]
[3148,"2017-09-18T07:55:09",2,255,0,0]
[3148,"2017-09-18T12:01:41",2,255,0,0]
[4028,"2017-09-18T07:54:51",2,255,0,0]
[4028,"2017-09-19T08:10:52",2,255,0,0]
[4777,"2017-09-18T06:57:22",2,255,0,0]
[4939,"2017-09-18T07:35:38",2,255,0,0]
[6174,"2017-09-18T08:01:28",2,255,0,0]
[6348,"2017-09-18T07:53:45",2,255,0,0]
[7895,"2017-09-18T07:55:03",2,255,0,0]
[9368,"2017-09-18T07:43:37",2,255,0,0]
[9659,"2017-09-18T07:59:45",2,255,0,0]

{"sheet":"Tabulated","index":1,"n_rows":39,"n_cols":11,"rows_kept":39,"cut":false,"hidden":false,"merged":[]}
["Empl","PunchDate","P1","P2","P3","P4","P5","P6","P7","P8","Total Hrs"]
[2,"2017-09-18",42996.349189814813,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(PunchesWithTotals[P2]),0,PunchesWithTotals[P2]-PunchesWithTotals[P1])+IF(ISBLANK(PunchesWithTotals[P4]),0,PunchesWithTotals[P4]-PunchesWithTotals[P3])+IF(ISBLANK(PunchesWithTotals[P6]),0,PunchesWithTotals[P6]-PunchesWithTotals[P5])+IF(ISBLANK(PunchesWithTotals[P8]),0,PunchesWithTotals[P8]-PunchesWithTotals[P7])","v":"00:00:00"}]
[4,"2017-09-18",42996.337118055555,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(PunchesWithTotals[P2]),0,PunchesWithTotals[P2]-PunchesWithTotals[P1])+IF(ISBLANK(PunchesWithTotals[P4]),0,PunchesWithTotals[P4]-PunchesWithTotals[P3])+IF(ISBLANK(PunchesWithTotals[P6]),0,PunchesWithTotals[P6]-PunchesWithTotals[P5])+IF(ISBLANK(PunchesWithTotals[P8]),0,PunchesWithTotals[P8]-PunchesWithTotals[P7])","v":"00:00:00"}]
[11,"2017-09-18",42996.302928240744,42996.416932870372,null,null,null,null,null,null,{"$f":"IF(ISBLANK(PunchesWithTotals[P2]),0,PunchesWithTotals[P2]-PunchesWithTotals[P1])+IF(ISBLANK(PunchesWithTotals[P4]),0,PunchesWithTotals[P4]-PunchesWithTotals[P3])+IF(ISBLANK(PunchesWithTotals[P6]),0,PunchesWithTotals[P6]-PunchesWithTotals[P5])+IF(ISBLANK(PunchesWithTotals[P8]),0,PunchesWithTotals[P8]-PunchesWithTotals[P7])","v":"02:44:10"}]
[11,"2017-09-19",42997.340046296296,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(PunchesWithTotals[P2]),0,PunchesWithTotals[P2]-PunchesWithTotals[P1])+IF(ISBLANK(PunchesWithTotals[P4]),0,PunchesWithTotals[P4]-PunchesWithTotals[P3])+IF(ISBLANK(PunchesWithTotals[P6]),0,PunchesWithTotals[P6]-PunchesWithTotals[P5])+IF(ISBLANK(PunchesWithTotals[P8]),0,PunchesWithTotals[P8]-PunchesWithTotals[P7])","v":"00:00:00"}]
[12,"2017-09-18",42996.317974537036,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(PunchesWithTotals[P2]),0,PunchesWithTotals[P2]-PunchesWithTotals[P1])+IF(ISBLANK(PunchesWithTotals[P4]),0,PunchesWithTotals[P4]-PunchesWithTotals[P3])+IF(ISBLANK(PunchesWithTotals[P6]),0,PunchesWithTotals[P6]-PunchesWithTotals[P5])+IF(ISBLANK(PunchesWithTotals[P8]),0,PunchesWithTotals[P8]-PunchesWithTotals[P7])","v":"00:00:00"}]
[15,"2017-09-18",42996.331377314818,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(PunchesWithTotals[P2]),0,PunchesWithTotals[P2]-PunchesWithTotals[P1])+IF(ISBLANK(PunchesWithTotals[P4]),0,PunchesWithTotals[P4]-PunchesWithTotals[P3])+IF(ISBLANK(PunchesWithTotals[P6]),0,PunchesWithTotals[P6]-PunchesWithTotals[P5])+IF(ISBLANK(PunchesWithTotals[P8]),0,PunchesWithTotals[P8]-PunchesWithTotals[P7])","v":"00:00:00"}]
[17,"2017-09-18",42996.310740740744,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(PunchesWithTotals[P2]),0,PunchesWithTotals[P2]-PunchesWithTotals[P1])+IF(ISBLANK(PunchesWithTotals[P4]),0,PunchesWithTotals[P4]-PunchesWithTotals[P3])+IF(ISBLANK(PunchesWithTotals[P6]),0,PunchesWithTotals[P6]-PunchesWithTotals[P5])+IF(ISBLANK(PunchesWithTotals[P8]),0,PunchesWithTotals[P8]-PunchesWithTotals[P7])","v":"00:00:00"}]
[18,"2017-09-18",42996.33697916667,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(PunchesWithTotals[P2]),0,PunchesWithTotals[P2]-PunchesWithTotals[P1])+IF(ISBLANK(PunchesWithTotals[P4]),0,PunchesWithTotals[P4]-PunchesWithTotals[P3])+IF(ISBLANK(PunchesWithTotals[P6]),0,PunchesWithTotals[P6]-PunchesWithTotals[P5])+IF(ISBLANK(PunchesWithTotals[P8]),0,PunchesWithTotals[P8]-PunchesWithTotals[P7])","v":"00:00:00"}]
[19,"2017-09-18",42996.398935185185,42996.505972222221,null,null,null,null,null,null,{"$f":"IF(ISBLANK(PunchesWithTotals[P2]),0,PunchesWithTotals[P2]-PunchesWithTotals[P1])+IF(ISBLANK(PunchesWithTotals[P4]),0,PunchesWithTotals[P4]-PunchesWithTotals[P3])+IF(ISBLANK(PunchesWithTotals[P6]),0,PunchesWithTotals[P6]-PunchesWithTotals[P5])+IF(ISBLANK(PunchesWithTotals[P8]),0,PunchesWithTotals[P8]-PunchesWithTotals[P7])","v":"02:34:08"}]
[19,"2017-09-19",42997.353692129633,42997.440937500003,null,null,null,null,null,null,{"$f":"IF(ISBLANK(PunchesWithTotals[P2]),0,PunchesWithTotals[P2]-PunchesWithTotals[P1])+IF(ISBLANK(PunchesWithTotals[P4]),0,PunchesWithTotals[P4]-PunchesWithTotals[P3])+IF(ISBLANK(PunchesWithTotals[P6]),0,PunchesWithTotals[P6]-PunchesWithTotals[P5])+IF(ISBLANK(PunchesWithTotals[P8]),0,PunchesWithTotals[P8]-PunchesWithTotals[P7])","v":"02:05:38"}]
[25,"2017-09-18",42996.335011574076,42996.503067129626,null,null,null,null,null,null,{"$f":"IF(ISBLANK(PunchesWithTotals[P2]),0,PunchesWithTotals[P2]-PunchesWithTotals[P1])+IF(ISBLANK(PunchesWithTotals[P4]),0,PunchesWithTotals[P4]-PunchesWithTotals[P3])+IF(ISBLANK(PunchesWithTotals[P6]),0,PunchesWithTotals[P6]-PunchesWithTotals[P5])+IF(ISBLANK(PunchesWithTotals[P8]),0,PunchesWithTotals[P8]-PunchesWithTotals[P7])","v":"04:02:00"}]
[25,"2017-09-19",42997.34034722222,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(PunchesWithTotals[P2]),0,PunchesWithTotals[P2]-PunchesWithTotals[P1])+IF(ISBLANK(PunchesWithTotals[P4]),0,PunchesWithTotals[P4]-PunchesWithTotals[P3])+IF(ISBLANK(PunchesWithTotals[P6]),0,PunchesWithTotals[P6]-PunchesWithTotals[P5])+IF(ISBLANK(PunchesWithTotals[P8]),0,PunchesWithTotals[P8]-PunchesWithTotals[P7])","v":"00:00:00"}]
[33,"2017-09-18",42996.335115740738,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(PunchesWithTotals[P2]),0,PunchesWithTotals[P2]-PunchesWithTotals[P1])+IF(ISBLANK(PunchesWithTotals[P4]),0,PunchesWithTotals[P4]-PunchesWithTotals[P3])+IF(ISBLANK(PunchesWithTotals[P6]),0,PunchesWithTotals[P6]-PunchesWithTotals[P5])+IF(ISBLANK(PunchesWithTotals[P8]),0,PunchesWithTotals[P8]-PunchesWithTotals[P7])","v":"00:00:00"}]
[33,"2017-09-19",42997.340254629627,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(PunchesWithTotals[P2]),0,PunchesWithTotals[P2]-PunchesWithTotals[P1])+IF(ISBLANK(PunchesWithTotals[P4]),0,PunchesWithTotals[P4]-PunchesWithTotals[P3])+IF(ISBLANK(PunchesWithTotals[P6]),0,PunchesWithTotals[P6]-PunchesWithTotals[P5])+IF(ISBLANK(PunchesWithTotals[P8]),0,PunchesWithTotals[P8]-PunchesWithTotals[P7])","v":"00:00:00"}]
[34,"2017-09-18",42996.328067129631,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(PunchesWithTotals[P2]),0,PunchesWithTotals[P2]-PunchesWithTotals[P1])+IF(ISBLANK(PunchesWithTotals[P4]),0,PunchesWithTotals[P4]-PunchesWithTotals[P3])+IF(ISBLANK(PunchesWithTotals[P6]),0,PunchesWithTotals[P6]-PunchesWithTotals[P5])+IF(ISBLANK(PunchesWithTotals[P8]),0,PunchesWithTotals[P8]-PunchesWithTotals[P7])","v":"00:00:00"}]
[39,"2017-09-18",42996.363900462966,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(PunchesWithTotals[P2]),0,PunchesWithTotals[P2]-PunchesWithTotals[P1])+IF(ISBLANK(PunchesWithTotals[P4]),0,PunchesWithTotals[P4]-PunchesWithTotals[P3])+IF(ISBLANK(PunchesWithTotals[P6]),0,PunchesWithTotals[P6]-PunchesWithTotals[P5])+IF(ISBLANK(PunchesWithTotals[P8]),0,PunchesWithTotals[P8]-PunchesWithTotals[P7])","v":"00:00:00"}]
[45,"2017-09-18",42996.337673611109,42996.456365740742,null,null,null,null,null,null,{"$f":"IF(ISBLANK(PunchesWithTotals[P2]),0,PunchesWithTotals[P2]-PunchesWithTotals[P1])+IF(ISBLANK(PunchesWithTotals[P4]),0,PunchesWithTotals[P4]-PunchesWithTotals[P3])+IF(ISBLANK(PunchesWithTotals[P6]),0,PunchesWithTotals[P6]-PunchesWithTotals[P5])+IF(ISBLANK(PunchesWithTotals[P8]),0,PunchesWithTotals[P8]-PunchesWithTotals[P7])","v":"02:50:55"}]
[48,"2017-09-18",42996.335289351853,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(PunchesWithTotals[P2]),0,PunchesWithTotals[P2]-PunchesWithTotals[P1])+IF(ISBLANK(PunchesWithTotals[P4]),0,PunchesWithTotals[P4]-PunchesWithTotals[P3])+IF(ISBLANK(PunchesWithTotals[P6]),0,PunchesWithTotals[P6]-PunchesWithTotals[P5])+IF(ISBLANK(PunchesWithTotals[P8]),0,PunchesWithTotals[P8]-PunchesWithTotals[P7])","v":"00:00:00"}]
[68,"2017-09-18",42996.333622685182,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(PunchesWithTotals[P2]),0,PunchesWithTotals[P2]-PunchesWithTotals[P1])+IF(ISBLANK(PunchesWithTotals[P4]),0,PunchesWithTotals[P4]-PunchesWithTotals[P3])+IF(ISBLANK(PunchesWithTotals[P6]),0,PunchesWithTotals[P6]-PunchesWithTotals[P5])+IF(ISBLANK(PunchesWithTotals[P8]),0,PunchesWithTotals[P8]-PunchesWithTotals[P7])","v":"00:00:00"}]
[68,"2017-09-19",42997.347627314812,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(PunchesWithTotals[P2]),0,PunchesWithTotals[P2]-PunchesWithTotals[P1])+IF(ISBLANK(PunchesWithTotals[P4]),0,PunchesWithTotals[P4]-PunchesWithTotals[P3])+IF(ISBLANK(PunchesWithTotals[P6]),0,PunchesWithTotals[P6]-PunchesWithTotals[P5])+IF(ISBLANK(PunchesWithTotals[P8]),0,PunchesWithTotals[P8]-PunchesWithTotals[P7])","v":"00:00:00"}]
[74,"2017-09-18",42996.339456018519,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(PunchesWithTotals[P2]),0,PunchesWithTotals[P2]-PunchesWithTotals[P1])+IF(ISBLANK(PunchesWithTotals[P4]),0,PunchesWithTotals[P4]-PunchesWithTotals[P3])+IF(ISBLANK(PunchesWithTotals[P6]),0,PunchesWithTotals[P6]-PunchesWithTotals[P5])+IF(ISBLANK(PunchesWithTotals[P8]),0,PunchesWithTotals[P8]-PunchesWithTotals[P7])","v":"00:00:00"}]
[92,"2017-09-18",42996.377997685187,42996.501238425924,null,null,null,null,null,null,{"$f":"IF(ISBLANK(PunchesWithTotals[P2]),0,PunchesWithTotals[P2]-PunchesWithTotals[P1])+IF(ISBLANK(PunchesWithTotals[P4]),0,PunchesWithTotals[P4]-PunchesWithTotals[P3])+IF(ISBLANK(PunchesWithTotals[P6]),0,PunchesWithTotals[P6]-PunchesWithTotals[P5])+IF(ISBLANK(PunchesWithTotals[P8]),0,PunchesWithTotals[P8]-PunchesWithTotals[P7])","v":"02:57:28"}]
[93,"2017-09-18",42996.33452546296,42996.501099537039,null,null,null,null,null,null,{"$f":"IF(ISBLANK(PunchesWithTotals[P2]),0,PunchesWithTotals[P2]-PunchesWithTotals[P1])+IF(ISBLANK(PunchesWithTotals[P4]),0,PunchesWithTotals[P4]-PunchesWithTotals[P3])+IF(ISBLANK(PunchesWithTotals[P6]),0,PunchesWithTotals[P6]-PunchesWithTotals[P5])+IF(ISBLANK(PunchesWithTotals[P8]),0,PunchesWithTotals[P8]-PunchesWithTotals[P7])","v":"03:59:52"}]
[109,"2017-09-18",42996.388437499998,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(PunchesWithTotals[P2]),0,PunchesWithTotals[P2]-PunchesWithTotals[P1])+IF(ISBLANK(PunchesWithTotals[P4]),0,PunchesWithTotals[P4]-PunchesWithTotals[P3])+IF(ISBLANK(PunchesWithTotals[P6]),0,PunchesWithTotals[P6]-PunchesWithTotals[P5])+IF(ISBLANK(PunchesWithTotals[P8]),0,PunchesWithTotals[P8]-PunchesWithTotals[P7])","v":"00:00:00"}]
[359,"2017-09-18",42996.275497685187,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(PunchesWithTotals[P2]),0,PunchesWithTotals[P2]-PunchesWithTotals[P1])+IF(ISBLANK(PunchesWithTotals[P4]),0,PunchesWithTotals[P4]-PunchesWithTotals[P3])+IF(ISBLANK(PunchesWithTotals[P6]),0,PunchesWithTotals[P6]-PunchesWithTotals[P5])+IF(ISBLANK(PunchesWithTotals[P8]),0,PunchesWithTotals[P8]-PunchesWithTotals[P7])","v":"00:00:00"}]
[625,"2017-09-19",42997.340555555558,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(PunchesWithTotals[P2]),0,PunchesWithTotals[P2]-PunchesWithTotals[P1])+IF(ISBLANK(PunchesWithTotals[P4]),0,PunchesWithTotals[P4]-PunchesWithTotals[P3])+IF(ISBLANK(PunchesWithTotals[P6]),0,PunchesWithTotals[P6]-PunchesWithTotals[P5])+IF(ISBLANK(PunchesWithTotals[P8]),0,PunchesWithTotals[P8]-PunchesWithTotals[P7])","v":"00:00:00"}]
[1011,"2017-09-18",42996.329826388886,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(PunchesWithTotals[P2]),0,PunchesWithTotals[P2]-PunchesWithTotals[P1])+IF(ISBLANK(PunchesWithTotals[P4]),0,PunchesWithTotals[P4]-PunchesWithTotals[P3])+IF(ISBLANK(PunchesWithTotals[P6]),0,PunchesWithTotals[P6]-PunchesWithTotals[P5])+IF(ISBLANK(PunchesWithTotals[P8]),0,PunchesWithTotals[P8]-PunchesWithTotals[P7])","v":"00:00:00"}]
[1278,"2017-09-18",42996.38758101852,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(PunchesWithTotals[P2]),0,PunchesWithTotals[P2]-PunchesWithTotals[P1])+IF(ISBLANK(PunchesWithTotals[P4]),0,PunchesWithTotals[P4]-PunchesWithTotals[P3])+IF(ISBLANK(PunchesWithTotals[P6]),0,PunchesWithTotals[P6]-PunchesWithTotals[P5])+IF(ISBLANK(PunchesWithTotals[P8]),0,PunchesWithTotals[P8]-PunchesWithTotals[P7])","v":"00:00:00"}]
[3148,"2017-09-18",42996.329965277779,42996.501168981478,null,null,null,null,null,null,{"$f":"IF(ISBLANK(PunchesWithTotals[P2]),0,PunchesWithTotals[P2]-PunchesWithTotals[P1])+IF(ISBLANK(PunchesWithTotals[P4]),0,PunchesWithTotals[P4]-PunchesWithTotals[P3])+IF(ISBLANK(PunchesWithTotals[P6]),0,PunchesWithTotals[P6]-PunchesWithTotals[P5])+IF(ISBLANK(PunchesWithTotals[P8]),0,PunchesWithTotals[P8]-PunchesWithTotals[P7])","v":"04:06:32"}]
[4028,"2017-09-18",42996.329756944448,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(PunchesWithTotals[P2]),0,PunchesWithTotals[P2]-PunchesWithTotals[P1])+IF(ISBLANK(PunchesWithTotals[P4]),0,PunchesWithTotals[P4]-PunchesWithTotals[P3])+IF(ISBLANK(PunchesWithTotals[P6]),0,PunchesWithTotals[P6]-PunchesWithTotals[P5])+IF(ISBLANK(PunchesWithTotals[P8]),0,PunchesWithTotals[P8]-PunchesWithTotals[P7])","v":"00:00:00"}]
[4028,"2017-09-19",42997.340879629628,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(PunchesWithTotals[P2]),0,PunchesWithTotals[P2]-PunchesWithTotals[P1])+IF(ISBLANK(PunchesWithTotals[P4]),0,PunchesWithTotals[P4]-PunchesWithTotals[P3])+IF(ISBLANK(PunchesWithTotals[P6]),0,PunchesWithTotals[P6]-PunchesWithTotals[P5])+IF(ISBLANK(PunchesWithTotals[P8]),0,PunchesWithTotals[P8]-PunchesWithTotals[P7])","v":"00:00:00"}]
[4777,"2017-09-18",42996.289837962962,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(PunchesWithTotals[P2]),0,PunchesWithTotals[P2]-PunchesWithTotals[P1])+IF(ISBLANK(PunchesWithTotals[P4]),0,PunchesWithTotals[P4]-PunchesWithTotals[P3])+IF(ISBLANK(PunchesWithTotals[P6]),0,PunchesWithTotals[P6]-PunchesWithTotals[P5])+IF(ISBLANK(PunchesWithTotals[P8]),0,PunchesWithTotals[P8]-PunchesWithTotals[P7])","v":"00:00:00"}]
[4939,"2017-09-18",42996.316412037035,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(PunchesWithTotals[P2]),0,PunchesWithTotals[P2]-PunchesWithTotals[P1])+IF(ISBLANK(PunchesWithTotals[P4]),0,PunchesWithTotals[P4]-PunchesWithTotals[P3])+IF(ISBLANK(PunchesWithTotals[P6]),0,PunchesWithTotals[P6]-PunchesWithTotals[P5])+IF(ISBLANK(PunchesWithTotals[P8]),0,PunchesWithTotals[P8]-PunchesWithTotals[P7])","v":"00:00:00"}]
[6174,"2017-09-18",42996.334351851852,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(PunchesWithTotals[P2]),0,PunchesWithTotals[P2]-PunchesWithTotals[P1])+IF(ISBLANK(PunchesWithTotals[P4]),0,PunchesWithTotals[P4]-PunchesWithTotals[P3])+IF(ISBLANK(PunchesWithTotals[P6]),0,PunchesWithTotals[P6]-PunchesWithTotals[P5])+IF(ISBLANK(PunchesWithTotals[P8]),0,PunchesWithTotals[P8]-PunchesWithTotals[P7])","v":"00:00:00"}]
[6348,"2017-09-18",42996.328993055555,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(PunchesWithTotals[P2]),0,PunchesWithTotals[P2]-PunchesWithTotals[P1])+IF(ISBLANK(PunchesWithTotals[P4]),0,PunchesWithTotals[P4]-PunchesWithTotals[P3])+IF(ISBLANK(PunchesWithTotals[P6]),0,PunchesWithTotals[P6]-PunchesWithTotals[P5])+IF(ISBLANK(PunchesWithTotals[P8]),0,PunchesWithTotals[P8]-PunchesWithTotals[P7])","v":"00:00:00"}]
[7895,"2017-09-18",42996.329895833333,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(PunchesWithTotals[P2]),0,PunchesWithTotals[P2]-PunchesWithTotals[P1])+IF(ISBLANK(PunchesWithTotals[P4]),0,PunchesWithTotals[P4]-PunchesWithTotals[P3])+IF(ISBLANK(PunchesWithTotals[P6]),0,PunchesWithTotals[P6]-PunchesWithTotals[P5])+IF(ISBLANK(PunchesWithTotals[P8]),0,PunchesWithTotals[P8]-PunchesWithTotals[P7])","v":"00:00:00"}]
[9368,"2017-09-18",42996.321956018517,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(PunchesWithTotals[P2]),0,PunchesWithTotals[P2]-PunchesWithTotals[P1])+IF(ISBLANK(PunchesWithTotals[P4]),0,PunchesWithTotals[P4]-PunchesWithTotals[P3])+IF(ISBLANK(PunchesWithTotals[P6]),0,PunchesWithTotals[P6]-PunchesWithTotals[P5])+IF(ISBLANK(PunchesWithTotals[P8]),0,PunchesWithTotals[P8]-PunchesWithTotals[P7])","v":"00:00:00"}]
[9659,"2017-09-18",42996.33315972222,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(PunchesWithTotals[P2]),0,PunchesWithTotals[P2]-PunchesWithTotals[P1])+IF(ISBLANK(PunchesWithTotals[P4]),0,PunchesWithTotals[P4]-PunchesWithTotals[P3])+IF(ISBLANK(PunchesWithTotals[P6]),0,PunchesWithTotals[P6]-PunchesWithTotals[P5])+IF(ISBLANK(PunchesWithTotals[P8]),0,PunchesWithTotals[P8]-PunchesWithTotals[P7])","v":"00:00:00"}]

{"sheet":"Pivot Totals","index":2,"n_rows":36,"n_cols":2,"rows_kept":36,"cut":false,"hidden":false,"merged":[]}
["PunchDate","(All)"]
[]
["Row Labels","Sum of Total Hrs"]
[2,0]
[4,0]
[11,0.11400462962962964]
[12,0]
[15,0]
[17,0]
[18,0]
[19,0.19428240740740743]
[25,0.16805555555555554]
[33,0]
[34,0]
[39,0]
[45,0.11869212962962962]
[48,0]
[68,0]
[74,0]
[92,0.12324074074074075]
[93,0.16657407407407407]
[109,0]
[359,0]
[625,0]
[1011,0]
[1278,0]
[3148,0.17120370370370372]
[4028,0]
[4777,0]
[4939,0]
[6174,0]
[6348,0]
[7895,0]
[9368,0]
[9659,0]
["Grand Total",1.0560532407407408]