{"text_format":"2","workbook":"xlsx","n_sheets":1,"sheets":["Aug"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":"Aug","index":0,"n_rows":27,"n_cols":8,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
["DATE","IN","LUNCH","OUT","Total","Under","Over","Est"]
[]
["2010-08-02","8:00 AM","0:00","8:00 AM",{"$f":"SUM(D3,-B3,-C3)*24","v":"0.00"},{"$f":"IF(B3=D3,0,IF(E3>8,0,8-E3))","v":"8.00"},{"$f":"IF(E3>8,E3-8,0)","v":"0.00"},{"$f":"IF(E3>0,0,8)","v":"0.00"}]
[{"$f":"SUM(A3,1)","v":" Tue, August 03, 2010"},"8:00 AM","0:00","8:00 AM","0.00","8.00","0.00","0.00"]
[" Wed, August 04, 2010","8:00 AM","0:00","8:00 AM","0.00","0.00","0.00","8.00"]
[" Thu, August 05, 2010","8:00 AM","0:00","8:00 AM","0.00","0.00","0.00","8.00"]
[" Fri, August 06, 2010","8:00 AM","0:00","8:00 AM","0.00","0.00","0.00","8.00"]
[null,null," "," "]
[{"$f":"SUM(A7,3)","v":" Mon, August 09, 2010"},"8:00 AM","0:00","8:00 AM",{"$f":"SUM(D9,-B9,-C9)*24","v":"0.00"},{"$f":"IF(B9=D9,0,IF(E9>8,0,8-E9))","v":"0.00"},{"$f":"IF(E9>8,E9-8,0)","v":"0.00"},{"$f":"IF(E9>0,0,8)","v":"8.00"}]
[{"$f":"SUM(A9,1)","v":" Tue, August 10, 2010"},"8:00 AM","0:00","8:00 AM","0.00","0.00","0.00","8.00"]
[" Wed, August 11, 2010","8:00 AM","0:00","8:00 AM","0.00","0.00","0.00","8.00"]
[" Thu, August 12, 2010","8:00 AM","0:00","8:00 AM","0.00","0.00","0.00","8.00"]
[" Fri, August 13, 2010","8:00 AM","0:00","8:00 AM","0.00","0.00","0.00","8.00"]
["Total",null,null,{"$f":"COUNT(D3:D13)*8","v":"80.00"},{"$f":"SUM(E3:E13)","v":"0.00"},"16.00","0.00",{"$f":"SUM(H3:H13)+E14","v":"64.00"}]
[]
[{"$f":"SUM(A13,3)","v":" Mon, August 16, 2010"},"8:00 AM","0:00","8:00 AM",{"$f":"SUM(D16,-B16,-C16)*24","v":"0.00"},{"$f":"IF(B16=D16,0,IF(E16>8,0,8-E16))","v":"0.00"},{"$f":"IF(E16>8,E16-8,0)","v":"0.00"},{"$f":"IF(E16>0,0,8)","v":"8.00"}]
[{"$f":"SUM(A16,1)","v":" Tue, August 17, 2010"},"8:00 AM","0:00","8:00 AM","0.00","0.00","0.00","8.00"]
[" Wed, August 18, 2010","8:00 AM","0:00","8:00 AM","0.00","0.00","0.00","8.00"]
[" Thu, August 19, 2010","8:00 AM","0:00","8:00 AM","0.00","0.00","0.00","8.00"]
[" Fri, August 20, 2010","8:00 AM","0:00","8:00 AM","0.00","0.00","0.00","8.00"]
[null,null," "," "]
[{"$f":"SUM(A20,3)","v":" Mon, August 23, 2010"},"8:00 AM","0:00","8:00 AM",{"$f":"SUM(D22,-B22,-C22)*24","v":"0.00"},{"$f":"IF(B22=D22,0,IF(E22>8,0,8-E22))","v":"0.00"},{"$f":"IF(E22>8,E22-8,0)","v":"0.00"},{"$f":"IF(E22>0,0,8)","v":"8.00"}]
[{"$f":"SUM(A22,1)","v":" Tue, August 24, 2010"},"8:00 AM","0:00","8:00 AM","0.00","0.00","0.00","8.00"]
[" Wed, August 25, 2010","8:00 AM","0:00","8:00 AM","0.00","0.00","0.00","8.00"]
[" Thu, August 26, 2010","8:00 AM","0:00","8:00 AM","0.00","0.00","0.00","8.00"]
[" Fri, August 27, 2010","8:00 AM","0:00","8:00 AM","0.00","0.00","0.00","8.00"]
["Total",null,null,{"$f":"COUNT(D16:D26)*8","v":"80.00"},{"$f":"SUM(E16:E26)","v":"0.00"},"0.00","0.00",{"$f":"IF(F27<G27,D27+ABS(F27-G27),D27-ABS(F27-G27))","v":"80.00"}]