{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["1월"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"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":"1월","index":0,"n_rows":37,"n_cols":9,"rows_kept":37,"cut":false,"hidden":false,"merged":[[0,1,0,8],[36,1,36,6],[36,7,36,8],[1,1,2,1],[1,2,2,2],[1,3,2,3],[1,5,2,5],[1,6,2,6],[1,7,2,7],[1,8,2,8]]}
[null,"근무일지(시간근무)"]
[null,"월수",{"$f":"COUNT(B5:B35)","v":"1900-01-31"},"근무일수",null,{"$f":"COUNT(D5:D36)","v":"1900-01-29"},{"$f":"SUM(F5:F36)","v":232},"급여",{"$f":"H37","v":1501000}]
[null,null,null,null,"근무일수"]
[null,"날짜","출근시간","퇴근시간","근무수식","근무시간","시금","일급","비고"]
[null,"2016-09-01","08:00:00","16:00:00",{"$f":"IF(C5<D5,(D5-C5)*1440,IF(D5=\"\",0,IF(C5>D5,(1+D5-C5)*1440)))/60","v":8},{"$f":"IF(D5=\"\",\"\",E5)","v":8},6470,{"$f":"IF(D5=\"\",\"\",ROUND((E5*$G$5),-1))","v":51760}]
[null,{"$f":"IF($B$5=\"\",\"\",B5+1)","v":"2016-09-02"},"08:00:00","16:00:00",{"$f":"IF(C6<D6,(D6-C6)*1440,IF(D6=\"\",0,IF(C6>D6,(1+D6-C6)*1440)))/60","v":8},{"$f":"IF(D6=\"\",\"\",E6)","v":8},null,51760]
[null,{"$f":"IF($B$5=\"\",\"\",B6+1)","v":"2016-09-03"},"08:00:00","16:00:00",{"$f":"IF(C7<D7,(D7-C7)*1440,IF(D7=\"\",0,IF(C7>D7,(1+D7-C7)*1440)))/60","v":8},8,null,51760]
[null,"2016-09-04","08:00:00","16:00:00",{"$f":"IF(C8<D8,(D8-C8)*1440,IF(D8=\"\",0,IF(C8>D8,(1+D8-C8)*1440)))/60","v":8},8,null,51760]
[null,"2016-09-05","08:00:00","16:00:00",{"$f":"IF(C9<D9,(D9-C9)*1440,IF(D9=\"\",0,IF(C9>D9,(1+D9-C9)*1440)))/60","v":8},8,null,51760]
[null,"2016-09-06","08:00:00","16:00:00",{"$f":"IF(C10<D10,(D10-C10)*1440,IF(D10=\"\",0,IF(C10>D10,(1+D10-C10)*1440)))/60","v":8},{"$f":"IF(D10=\"\",\"\",E10)","v":8},null,{"$f":"IF(D10=\"\",\"\",ROUND((E10*$G$5),-1))","v":51760}]
[null,"2016-09-07","08:00:00","16:00:00",8,8,null,51760]
[null,"2016-09-08","08:00:00","16:00:00",8,8,null,51760]
[null,"2016-09-09","08:00:00","16:00:00",8,8,null,51760]
[null,"2016-09-10","08:00:00","16:00:00",{"$f":"IF(C14<D14,(D14-C14)*1440,IF(D14=\"\",0,IF(C14>D14,(1+D14-C14)*1440)))/60","v":8},{"$f":"IF(D14=\"\",\"\",E14)","v":8},null,{"$f":"IF(D14=\"\",\"\",ROUND((E14*$G$5),-1))","v":51760}]
[null,"2016-09-11",null,null,{"$f":"IF(C15<D15,(D15-C15)*1440,IF(D15=\"\",0,IF(C15>D15,(1+D15-C15)*1440)))/60","v":0},"",null,""]
[null,"2016-09-12","08:00:00","16:00:00",8,8,null,51760]
[null,"2016-09-13","08:00:00","16:00:00",8,8,null,51760]
[null,"2016-09-14","08:00:00","16:00:00",8,8,null,51760]
[null,"2016-09-15","08:00:00","16:00:00",8,8,null,51760]
[null,"2016-09-16","08:00:00","16:00:00",8,8,null,51760]
[null,"2016-09-17","08:00:00","16:00:00",8,8,null,51760]
[null,"2016-09-18","08:00:00","16:00:00",8,8,null,51760]
[null,"2016-09-19","08:00:00","16:00:00",8,8,null,51760]
[null,"2016-09-20","08:00:00","16:00:00",8,8,null,51760]
[null,"2016-09-21","08:00:00","16:00:00",8,8,null,51760]
[null,"2016-09-22","08:00:00","16:00:00",8,8,null,51760]
[null,"2016-09-23","08:00:00","16:00:00",8,8,null,51760]
[null,"2016-09-24","08:00:00","16:00:00",8,8,null,51760]
[null,"2016-09-25",null,null,0,"",null,""]
[null,"2016-09-26","08:00:00","16:00:00",8,8,null,51760]
[null,"2016-09-27","08:00:00","16:00:00",8,8,null,51760]
[null,"2016-09-28","08:00:00","16:00:00",8,8,null,51760]
[null,"2016-09-29","08:00:00","16:00:00",8,8,null,51760]
[null,"2016-09-30","08:00:00","16:00:00",8,8,null,51760]
[null,"2016-10-01","08:00:00","16:00:00",8,8,null,51760]
[]
[null,"합계",null,null,null,null,null,{"$f":"ROUND(SUM(H5:H36),-3)","v":1501000}]