{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["1월","2월","3월","4월","5월","6월","7월","8월","9월","10월","11월","12월"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":12,"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":36,"n_cols":15,"rows_kept":36,"cut":false,"hidden":false,"merged":[[0,2,1,3],[1,4,1,8]]}
[null,null,{"$f":"YEAR($E$1)","v":2021},null,"2021-01-05",null,{"$f":"DAY($E$1)","v":5}]
[null,null,null,null,"출퇴근 기록부"]
[null,null,{"$f":"MONTH($E$1)","v":1},{"$f":"DAY(DATE(YEAR(E1),MONTH(E1)+1,1)-1)","v":"1900-01-31"},"근무일수","근무일수",{"$f":"E36","v":"1900-01-23"},{"$f":"G36","v":115.00000000000001},"급여",{"$f":"ROUND(I36,-1)","v":1002800}]
["날짜끄러오기","변환","날짜","출근시간","퇴근시간","근무수식","근무시간","시금","일급","비고",null,{"$f":"MONTH(E1)+1","v":2},{"$f":"DATE($C$1,$L$4,N4)","v":"2021-02-01"},1,{"$f":"DAY(DATE(YEAR(M4),MONTH(M4)+1,1)-1)","v":"1900-01-28"}]
[{"$f":"(YEAR($E$1)&\"/\"&MONTH($E$1)&\"/\"&DAY($E$1))+N4-$N$4","v":"2021-01-05"},{"$f":"TEXT(A5,\"d\")","v":"5"},{"$f":"DATE($C$1,C3,B5)","v":"2021-01-05"},"19:00:00","00:00:00",{"$f":"IF(D5<E5,(E5-D5)*1440,IF(E5=\"\",0,IF(D5>E5,(1+E5-D5)*1440)))/60","v":5.0000000000000009},{"$f":"IF(E5=\"\",\"\",F5)","v":5.0000000000000009},8720,{"$f":"IF(G5=\"\",\"\",G5*$H$5)","v":43600.000000000007},null,null,null,{"$f":"DATE($C$1,$L$4,N5)","v":"2021-02-02"},2,{"$f":"TEXT(C5,\"aaa\")","v":"화"}]
["2021-01-06","6",{"$f":"IF(C5=\"\",\"\",IF($B$5=B6,\"\",IF(DAY($B$5)<=DAY(B6),DATE($C$1,$C$3,B6),DATE($C$1,$C$3+1,B6))))","v":"2021-01-06"},"19:00:00","00:00:00",{"$f":"IF(D6<E6,(E6-D6)*1440,IF(E6=\"\",0,IF(D6>E6,(1+E6-D6)*1440)))/60","v":5.0000000000000009},{"$f":"IF(E6=\"\",\"\",F6)","v":5.0000000000000009},null,{"$f":"IF(G6=\"\",\"\",G6*$H$5)","v":43600.000000000007},null,null,null,{"$f":"DATE($C$1,$L$4,N6)","v":"2021-02-03"},3,{"$f":"TEXT(C6,\"aaa\")","v":"수"}]
["2021-01-07","7",{"$f":"IF(C6=\"\",\"\",IF($B$5=B7,\"\",IF(DAY($B$5)<=DAY(B7),DATE($C$1,$C$3,B7),DATE($C$1,$C$3+1,B7))))","v":"2021-01-07"},"19:00:00","00:00:00",{"$f":"IF(D7<E7,(E7-D7)*1440,IF(E7=\"\",0,IF(D7>E7,(1+E7-D7)*1440)))/60","v":5.0000000000000009},5.0000000000000009,null,{"$f":"IF(G7=\"\",\"\",G7*$H$5)","v":43600.000000000007},null,null,null,"2021-02-04",4,"목"]
["2021-01-08","8","2021-01-08","19:00:00","00:00:00",{"$f":"IF(D8<E8,(E8-D8)*1440,IF(E8=\"\",0,IF(D8>E8,(1+E8-D8)*1440)))/60","v":5.0000000000000009},5.0000000000000009,null,43600.000000000007,null,null,null,"2021-02-05",5,"금"]
["2021-01-09","9","2021-01-09",null,null,{"$f":"IF(D9<E9,(E9-D9)*1440,IF(E9=\"\",0,IF(D9>E9,(1+E9-D9)*1440)))/60","v":0},"",null,"",null,null,null,"2021-02-06",6,{"$f":"TEXT(C9,\"aaa\")","v":"토"}]
["2021-01-10","10","2021-01-10",null,null,{"$f":"IF(D10<E10,(E10-D10)*1440,IF(E10=\"\",0,IF(D10>E10,(1+E10-D10)*1440)))/60","v":0},{"$f":"IF(E10=\"\",\"\",F10)","v":""},null,"",null,null,null,"2021-02-07",7,"일"]
["2021-01-11","11","2021-01-11","19:00:00","00:00:00",5.0000000000000009,5.0000000000000009,null,43600.000000000007,null,null,null,"2021-02-08",8,"월"]
["2021-01-12","12","2021-01-12","19:00:00","00:00:00",5.0000000000000009,5.0000000000000009,null,43600.000000000007,null,null,null,"2021-02-09",9,"화"]
["2021-01-13","13","2021-01-13","19:00:00","00:00:00",5.0000000000000009,5.0000000000000009,null,43600.000000000007,null,null,null,"2021-02-10",10,"수"]
["2021-01-14","14","2021-01-14","19:00:00","00:00:00",{"$f":"IF(D14<E14,(E14-D14)*1440,IF(E14=\"\",0,IF(D14>E14,(1+E14-D14)*1440)))/60","v":5.0000000000000009},{"$f":"IF(E14=\"\",\"\",F14)","v":5.0000000000000009},null,43600.000000000007,null,null,null,"2021-02-11",11,"목"]
["2021-01-15","15","2021-01-15","19:00:00","00:30:00",{"$f":"IF(D15<E15,(E15-D15)*1440,IF(E15=\"\",0,IF(D15>E15,(1+E15-D15)*1440)))/60","v":5.4999999999999991},{"$f":"IF(E15=\"\",\"\",F15)","v":5.4999999999999991},null,47959.999999999993,null,null,null,"2021-02-12",12,"금"]
["2021-01-16","16","2021-01-16",null,null,{"$f":"IF(D16<E16,(E16-D16)*1440,IF(E16=\"\",0,IF(D16>E16,(1+E16-D16)*1440)))/60","v":0},"",null,"",null,null,null,"2021-02-13",13,"토"]
["2021-01-17","17","2021-01-17",null,null,0,"",null,"",null,null,null,"2021-02-14",14,"일"]
["2021-01-18","18","2021-01-18","19:00:00","00:00:00",5.0000000000000009,5.0000000000000009,null,43600.000000000007,null,null,null,"2021-02-15",15,"월"]
["2021-01-19","19","2021-01-19","19:00:00","00:00:00",5.0000000000000009,5.0000000000000009,null,43600.000000000007,null,null,null,"2021-02-16",16,"화"]
["2021-01-20","20","2021-01-20","19:00:00","00:00:00",5.0000000000000009,5.0000000000000009,null,43600.000000000007,null,null,null,"2021-02-17",17,"수"]
["2021-01-21","21","2021-01-21","19:00:00","00:00:00",5.0000000000000009,5.0000000000000009,null,43600.000000000007,null,null,null,"2021-02-18",18,"목"]
["2021-01-22","22","2021-01-22","19:00:00","00:00:00",5.0000000000000009,5.0000000000000009,null,43600.000000000007,null,null,null,"2021-02-19",19,"금"]
["2021-01-23","23","2021-01-23",null,null,0,"",null,"",null,null,null,"2021-02-20",20,"토"]
["2021-01-24","24","2021-01-24",null,null,0,"",null,"",null,null,null,"2021-02-21",21,"일"]
["2021-01-25","25","2021-01-25","19:00:00","23:00:00",4.0000000000000018,4.0000000000000018,null,34880.000000000015,null,null,null,"2021-02-22",22,"월"]
["2021-01-26","26","2021-01-26","19:00:00","00:00:00",5.0000000000000009,5.0000000000000009,null,43600.000000000007,null,null,null,"2021-02-23",23,"화"]
["2021-01-27","27","2021-01-27","19:00:00","00:00:00",5.0000000000000009,5.0000000000000009,null,43600.000000000007,null,null,null,"2021-02-24",24,"수"]
["2021-01-28","28","2021-01-28","19:00:00","00:30:00",5.4999999999999991,5.4999999999999991,null,47959.999999999993,null,null,null,"2021-02-25",25,"목"]
["2021-01-29","29","2021-01-29","19:00:00","00:00:00",5.0000000000000009,5.0000000000000009,null,43600.000000000007,null,null,null,"2021-02-26",26,"금"]
["2021-01-30","30","2021-01-30",null,null,0,"",null,"",null,null,null,"2021-02-27",27,"토"]
["2021-01-31","31","2021-01-31",null,null,0,"",null,"",null,null,null,"2021-02-28",28,"일"]
["2021-02-01","1","2021-02-01","19:00:00","00:00:00",5.0000000000000009,5.0000000000000009,null,43600.000000000007,null,null,null,"2021-03-01",29,"월"]
["2021-02-02","2","2021-02-02","19:00:00","00:00:00",5.0000000000000009,5.0000000000000009,null,43600.000000000007,null,null,null,"2021-03-02",30,"화"]
["2021-02-03","3","2021-02-03","19:00:00","00:00:00",5.0000000000000009,5.0000000000000009,null,43600.000000000007,null,null,null,"2021-03-03",31,"수"]
["2021-02-04","4","2021-02-04","19:00:00","00:00:00",5.0000000000000009,5.0000000000000009,null,43600.000000000007,null,null,null,null,null,"목"]
[null,null,"합계",null,{"$f":"COUNT(E5:E35)","v":"1900-01-23"},{"$f":"SUM(F5:F35)","v":115.00000000000001},{"$f":"SUM(G5:G35)","v":115.00000000000001},null,{"$f":"SUM(I5:I35)","v":1002800.0000000001}]

{"sheet":"2월","index":1,"n_rows":36,"n_cols":15,"rows_kept":36,"cut":false,"hidden":false,"merged":[[0,2,1,3],[1,4,1,8]]}
[null,null,{"$f":"YEAR($E$1)","v":2021},null,{"$f":"'1월'!$E$1+'1월'!$D$3","v":"2021-02-05"},null,{"$f":"DAY($E$1)","v":5}]
[null,null,null,null,"출퇴근 기록부"]
[null,null,{"$f":"MONTH($E$1)","v":2},{"$f":"DAY(DATE(YEAR(E1),MONTH(E1)+1,1)-1)","v":"1900-01-28"},"근무일수","근무일수",{"$f":"E36","v":"1900-01-12"},{"$f":"G36","v":72},"급여",{"$f":"I36","v":627840}]
["날짜끄러오기","변환","날짜","출근시간","퇴근시간","근무수식","근무시간","시금","일급","비고",null,{"$f":"MONTH(E1)+1","v":3},{"$f":"DATE($C$1,$L$4,N4)","v":"2021-03-01"},1,{"$f":"DAY(DATE(YEAR(M4),MONTH(M4)+1,1)-1)","v":"1900-01-31"}]
[{"$f":"(YEAR($E$1)&\"/\"&MONTH($E$1)&\"/\"&DAY($E$1))+N4-$N$4","v":"2021-02-05"},{"$f":"TEXT(A5,\"d\")","v":"5"},{"$f":"DATE($C$1,C3,B5)","v":"2021-02-05"},"18:00:00","00:00:00",{"$f":"IF(D5<E5,(E5-D5)*1440,IF(E5=\"\",0,IF(D5>E5,(1+E5-D5)*1440)))/60","v":6},{"$f":"IF(E5=\"\",\"\",F5)","v":6},{"$f":"'1월'!H5","v":8720},{"$f":"IF(G5=\"\",\"\",G5*$H$5)","v":52320},null,null,null,{"$f":"DATE($C$1,$L$4,N5)","v":"2021-03-02"},2,{"$f":"TEXT(C5,\"aaa\")","v":"금"}]
[{"$f":"(YEAR($E$1)&\"/\"&MONTH($E$1)&\"/\"&DAY($E$1))+N5-$N$4","v":"2021-02-06"},"6",{"$f":"IF(C5=\"\",\"\",IF($B$5=B6,\"\",IF(DAY($B$5)<=DAY(B6),DATE($C$1,$C$3,B6),DATE($C$1,$C$3+1,B6))))","v":"2021-02-06"},"18:00:00","00:00:00",{"$f":"IF(D6<E6,(E6-D6)*1440,IF(E6=\"\",0,IF(D6>E6,(1+E6-D6)*1440)))/60","v":6},{"$f":"IF(E6=\"\",\"\",F6)","v":6},null,{"$f":"IF(G6=\"\",\"\",G6*$H$5)","v":52320},null,null,null,{"$f":"DATE($C$1,$L$4,N6)","v":"2021-03-03"},3,{"$f":"TEXT(C6,\"aaa\")","v":"토"}]
[{"$f":"(YEAR($E$1)&\"/\"&MONTH($E$1)&\"/\"&DAY($E$1))+N6-$N$4","v":"2021-02-07"},"7",{"$f":"IF(C6=\"\",\"\",IF($B$5=B7,\"\",IF(DAY($B$5)<=DAY(B7),DATE($C$1,$C$3,B7),DATE($C$1,$C$3+1,B7))))","v":"2021-02-07"},"18:00:00","00:00:00",{"$f":"IF(D7<E7,(E7-D7)*1440,IF(E7=\"\",0,IF(D7>E7,(1+E7-D7)*1440)))/60","v":6},6,null,{"$f":"IF(G7=\"\",\"\",G7*$H$5)","v":52320},null,null,null,"2021-03-04",4,"일"]
["2021-02-08","8","2021-02-08",null,null,{"$f":"IF(D8<E8,(E8-D8)*1440,IF(E8=\"\",0,IF(D8>E8,(1+E8-D8)*1440)))/60","v":0},"",null,"",null,null,null,"2021-03-05",5,"월"]
["2021-02-09","9","2021-02-09",null,null,{"$f":"IF(D9<E9,(E9-D9)*1440,IF(E9=\"\",0,IF(D9>E9,(1+E9-D9)*1440)))/60","v":0},"",null,"",null,null,null,"2021-03-06",6,{"$f":"TEXT(C9,\"aaa\")","v":"화"}]
["2021-02-10","10","2021-02-10",null,null,{"$f":"IF(D10<E10,(E10-D10)*1440,IF(E10=\"\",0,IF(D10>E10,(1+E10-D10)*1440)))/60","v":0},{"$f":"IF(E10=\"\",\"\",F10)","v":""},null,"",null,null,null,"2021-03-07",7,"수"]
["2021-02-11","11","2021-02-11",null,null,0,"",null,"",null,null,null,"2021-03-08",8,"목"]
["2021-02-12","12","2021-02-12","18:00:00","00:00:00",6,6,null,52320,null,null,null,"2021-03-09",9,"금"]
["2021-02-13","13","2021-02-13","18:00:00","00:00:00",6,6,null,52320,null,null,null,"2021-03-10",10,"토"]
["2021-02-14","14","2021-02-14","18:00:00","00:00:00",{"$f":"IF(D14<E14,(E14-D14)*1440,IF(E14=\"\",0,IF(D14>E14,(1+E14-D14)*1440)))/60","v":6},{"$f":"IF(E14=\"\",\"\",F14)","v":6},null,52320,null,null,null,"2021-03-11",11,"일"]
["2021-02-15","15","2021-02-15",null,null,{"$f":"IF(D15<E15,(E15-D15)*1440,IF(E15=\"\",0,IF(D15>E15,(1+E15-D15)*1440)))/60","v":0},{"$f":"IF(E15=\"\",\"\",F15)","v":""},null,"",null,null,null,"2021-03-12",12,"월"]
["2021-02-16","16","2021-02-16",null,null,{"$f":"IF(D16<E16,(E16-D16)*1440,IF(E16=\"\",0,IF(D16>E16,(1+E16-D16)*1440)))/60","v":0},"",null,"",null,null,null,"2021-03-13",13,"화"]
["2021-02-17","17","2021-02-17",null,null,0,"",null,"",null,null,null,"2021-03-14",14,"수"]
["2021-02-18","18","2021-02-18",null,null,0,"",null,"",null,null,null,"2021-03-15",15,"목"]
["2021-02-19","19","2021-02-19","18:00:00","00:00:00",6,6,null,52320,null,null,null,"2021-03-16",16,"금"]
["2021-02-20","20","2021-02-20","18:00:00","00:00:00",6,6,null,52320,null,null,null,"2021-03-17",17,"토"]
["2021-02-21","21","2021-02-21","18:00:00","00:00:00",6,6,null,52320,null,null,null,"2021-03-18",18,"일"]
["2021-02-22","22","2021-02-22",null,null,0,"",null,"",null,null,null,"2021-03-19",19,"월"]
["2021-02-23","23","2021-02-23",null,null,0,"",null,"",null,null,null,"2021-03-20",20,"화"]
["2021-02-24","24","2021-02-24",null,null,0,"",null,"",null,null,null,"2021-03-21",21,"수"]
["2021-02-25","25","2021-02-25",null,null,0,"",null,"",null,null,null,"2021-03-22",22,"목"]
["2021-02-26","26","2021-02-26","18:00:00","00:00:00",6,6,null,52320,null,null,null,"2021-03-23",23,"금"]
["2021-02-27","27","2021-02-27","18:00:00","00:00:00",6,6,null,52320,null,null,null,"2021-03-24",24,"토"]
["2021-02-28","28","2021-02-28","18:00:00","00:00:00",6,6,null,52320,null,null,null,"2021-03-25",25,"일"]
["2021-03-01","1","2021-03-01",null,null,0,"",null,"",null,null,null,"2021-03-26",26,"월"]
["2021-03-02","2","2021-03-02",null,null,0,"",null,"",null,null,null,"2021-03-27",27,"화"]
["2021-03-03","3","2021-03-03",null,null,0,"",null,"",null,null,null,"2021-03-28",28,"수"]
["2021-03-04","4","2021-03-04",null,null,0,"",null,"",null,null,null,"2021-03-29",29,"목"]
["2021-03-05","5","",null,null,0,"",null,"",null,null,null,"2021-03-30",30,""]
["2021-03-06","6","",null,null,0,"",null,"",null,null,null,"2021-03-31",31,""]
["2021-03-07","7","",null,null,0,"",null,"",null,null,null,null,null,""]
[null,null,"합계",null,{"$f":"COUNT(E5:E35)","v":"1900-01-12"},{"$f":"SUM(F5:F35)","v":72},{"$f":"SUM(G5:G35)","v":72},null,{"$f":"SUM(I5:I35)","v":627840}]

{"sheet":"3월","index":2,"n_rows":36,"n_cols":15,"rows_kept":36,"cut":false,"hidden":false,"merged":[[0,2,1,3],[1,4,1,8]]}
[null,null,{"$f":"YEAR($E$1)","v":2021},null,{"$f":"'2월'!$E$1+'2월'!$D$3","v":"2021-03-05"},null,{"$f":"DAY($E$1)","v":5}]
[null,null,null,null,"출퇴근 기록부"]
[null,null,{"$f":"MONTH($E$1)","v":3},{"$f":"DAY(DATE(YEAR(E1),MONTH(E1)+1,1)-1)","v":"1900-01-31"},"근무일수","근무일수",{"$f":"E36","v":"00:00:00"},{"$f":"G36","v":0},"급여",{"$f":"I36","v":0}]
["날짜끄러오기","변환","날짜","출근시간","퇴근시간","근무수식","근무시간","시금","일급","비고",null,{"$f":"MONTH(E1)+1","v":4},{"$f":"DATE($C$1,$L$4,N4)","v":"2021-04-01"},1,{"$f":"DAY(DATE(YEAR(M4),MONTH(M4)+1,1)-1)","v":"1900-01-30"}]
[{"$f":"(YEAR($E$1)&\"/\"&MONTH($E$1)&\"/\"&DAY($E$1))+N4-$N$4","v":"2021-03-05"},{"$f":"TEXT(A5,\"d\")","v":"5"},{"$f":"DATE($C$1,C3,B5)","v":"2021-03-05"},null,null,{"$f":"IF(D5<E5,(E5-D5)*1440,IF(E5=\"\",0,IF(D5>E5,(1+E5-D5)*1440)))/60","v":0},{"$f":"IF(E5=\"\",\"\",F5)","v":""},{"$f":"'1월'!H5","v":8720},{"$f":"IF(G5=\"\",\"\",G5*$H$5)","v":""},null,null,null,{"$f":"DATE($C$1,$L$4,N5)","v":"2021-04-02"},2]
[{"$f":"(YEAR($E$1)&\"/\"&MONTH($E$1)&\"/\"&DAY($E$1))+N5-$N$4","v":"2021-03-06"},"6",{"$f":"IF(C5=\"\",\"\",IF($B$5=B6,\"\",IF(DAY($B$5)<=DAY(B6),DATE($C$1,$C$3,B6),DATE($C$1,$C$3+1,B6))))","v":"2021-03-06"},null,null,{"$f":"IF(D6<E6,(E6-D6)*1440,IF(E6=\"\",0,IF(D6>E6,(1+E6-D6)*1440)))/60","v":0},{"$f":"IF(E6=\"\",\"\",F6)","v":""},null,{"$f":"IF(G6=\"\",\"\",G6*$H$5)","v":""},null,null,null,{"$f":"DATE($C$1,$L$4,N6)","v":"2021-04-03"},3]
[{"$f":"(YEAR($E$1)&\"/\"&MONTH($E$1)&\"/\"&DAY($E$1))+N6-$N$4","v":"2021-03-07"},"7",{"$f":"IF(C6=\"\",\"\",IF($B$5=B7,\"\",IF(DAY($B$5)<=DAY(B7),DATE($C$1,$C$3,B7),DATE($C$1,$C$3+1,B7))))","v":"2021-03-07"},null,null,{"$f":"IF(D7<E7,(E7-D7)*1440,IF(E7=\"\",0,IF(D7>E7,(1+E7-D7)*1440)))/60","v":0},"",null,{"$f":"IF(G7=\"\",\"\",G7*$H$5)","v":""},null,null,null,"2021-04-04",4]
["2021-03-08","8","2021-03-08",null,null,{"$f":"IF(D8<E8,(E8-D8)*1440,IF(E8=\"\",0,IF(D8>E8,(1+E8-D8)*1440)))/60","v":0},"",null,"",null,null,null,"2021-04-05",5]
["2021-03-09","9","2021-03-09",null,null,{"$f":"IF(D9<E9,(E9-D9)*1440,IF(E9=\"\",0,IF(D9>E9,(1+E9-D9)*1440)))/60","v":0},"",null,"",null,null,null,"2021-04-06",6]
["2021-03-10","10","2021-03-10",null,null,{"$f":"IF(D10<E10,(E10-D10)*1440,IF(E10=\"\",0,IF(D10>E10,(1+E10-D10)*1440)))/60","v":0},{"$f":"IF(E10=\"\",\"\",F10)","v":""},null,"",null,null,null,"2021-04-07",7]
["2021-03-11","11","2021-03-11",null,null,0,"",null,"",null,null,null,"2021-04-08",8]
["2021-03-12","12","2021-03-12",null,null,0,"",null,"",null,null,null,"2021-04-09",9]
["2021-03-13","13","2021-03-13",null,null,0,"",null,"",null,null,null,"2021-04-10",10]
["2021-03-14","14","2021-03-14",null,null,{"$f":"IF(D14<E14,(E14-D14)*1440,IF(E14=\"\",0,IF(D14>E14,(1+E14-D14)*1440)))/60","v":0},{"$f":"IF(E14=\"\",\"\",F14)","v":""},null,"",null,null,null,"2021-04-11",11]
["2021-03-15","15","2021-03-15",null,null,{"$f":"IF(D15<E15,(E15-D15)*1440,IF(E15=\"\",0,IF(D15>E15,(1+E15-D15)*1440)))/60","v":0},{"$f":"IF(E15=\"\",\"\",F15)","v":""},null,"",null,null,null,"2021-04-12",12]
["2021-03-16","16","2021-03-16",null,null,{"$f":"IF(D16<E16,(E16-D16)*1440,IF(E16=\"\",0,IF(D16>E16,(1+E16-D16)*1440)))/60","v":0},"",null,"",null,null,null,"2021-04-13",13]
["2021-03-17","17","2021-03-17",null,null,0,"",null,"",null,null,null,"2021-04-14",14]
["2021-03-18","18","2021-03-18",null,null,0,"",null,"",null,null,null,"2021-04-15",15]
["2021-03-19","19","2021-03-19",null,null,0,"",null,"",null,null,null,"2021-04-16",16]
["2021-03-20","20","2021-03-20",null,null,0,"",null,"",null,null,null,"2021-04-17",17]
["2021-03-21","21","2021-03-21",null,null,0,"",null,"",null,null,null,"2021-04-18",18]
["2021-03-22","22","2021-03-22",null,null,0,"",null,"",null,null,null,"2021-04-19",19]
["2021-03-23","23","2021-03-23",null,null,0,"",null,"",null,null,null,"2021-04-20",20]
["2021-03-24","24","2021-03-24",null,null,0,"",null,"",null,null,null,"2021-04-21",21]
["2021-03-25","25","2021-03-25",null,null,0,"",null,"",null,null,null,"2021-04-22",22]
["2021-03-26","26","2021-03-26",null,null,0,"",null,"",null,null,null,"2021-04-23",23]
["2021-03-27","27","2021-03-27",null,null,0,"",null,"",null,null,null,"2021-04-24",24]
["2021-03-28","28","2021-03-28",null,null,0,"",null,"",null,null,null,"2021-04-25",25]
["2021-03-29","29","2021-03-29",null,null,0,"",null,"",null,null,null,"2021-04-26",26]
["2021-03-30","30","2021-03-30",null,null,0,"",null,"",null,null,null,"2021-04-27",27]
["2021-03-31","31","2021-03-31",null,null,0,"",null,"",null,null,null,"2021-04-28",28]
["2021-04-01","1","2021-04-01",null,null,0,"",null,"",null,null,null,"2021-04-29",29]
["2021-04-02","2","2021-04-02",null,null,0,"",null,"",null,null,null,"2021-04-30",30]
["2021-04-03","3","2021-04-03",null,null,0,"",null,"",null,null,null,"2021-05-01",31]
["2021-04-04","4","2021-04-04",null,null,0,"",null,""]
[null,null,"합계",null,{"$f":"COUNT(E5:E35)","v":"00:00:00"},{"$f":"SUM(F5:F35)","v":0},{"$f":"SUM(G5:G35)","v":0},null,{"$f":"SUM(I5:I35)","v":0}]

{"sheet":"4월","index":3,"n_rows":38,"n_cols":15,"rows_kept":38,"cut":false,"hidden":false,"merged":[[0,2,1,3],[1,4,1,8]]}
[null,null,{"$f":"YEAR($E$1)","v":2021},null,{"$f":"'3월'!$E$1+'3월'!$D$3","v":"2021-04-05"},null,{"$f":"DAY($E$1)","v":5}]
[null,null,null,null,"출퇴근 기록부"]
[null,null,{"$f":"MONTH($E$1)","v":4},{"$f":"DAY(DATE(YEAR(E1),MONTH(E1)+1,1)-1)","v":"1900-01-30"},"근무일수","근무일수",{"$f":"E36","v":"00:00:00"},{"$f":"G36","v":0},"급여",{"$f":"I36","v":0}]
["날짜끄러오기","변환","날짜","출근시간","퇴근시간","근무수식","근무시간","시금","일급","비고",null,{"$f":"MONTH(E1)+1","v":5},{"$f":"DATE($C$1,$L$4,N4)","v":"2021-05-01"},1,{"$f":"DAY(DATE(YEAR(M4),MONTH(M4)+1,1)-1)","v":"1900-01-31"}]
[{"$f":"(YEAR($E$1)&\"/\"&MONTH($E$1)&\"/\"&DAY($E$1))+N4-$N$4","v":"2021-04-05"},{"$f":"TEXT(A5,\"d\")","v":"5"},{"$f":"DATE($C$1,C3,B5)","v":"2021-04-05"},null,null,{"$f":"IF(D5<E5,(E5-D5)*1440,IF(E5=\"\",0,IF(D5>E5,(1+E5-D5)*1440)))/60","v":0},{"$f":"IF(E5=\"\",\"\",F5)","v":""},{"$f":"'1월'!H5","v":8720},{"$f":"IF(G5=\"\",\"\",G5*$H$5)","v":""},null,null,null,{"$f":"DATE($C$1,$L$4,N5)","v":"2021-05-02"},2]
[{"$f":"(YEAR($E$1)&\"/\"&MONTH($E$1)&\"/\"&DAY($E$1))+N5-$N$4","v":"2021-04-06"},"6",{"$f":"IF(C5=\"\",\"\",IF($B$5=B6,\"\",IF(DAY($B$5)<=DAY(B6),DATE($C$1,$C$3,B6),DATE($C$1,$C$3+1,B6))))","v":"2021-04-06"},null,null,{"$f":"IF(D6<E6,(E6-D6)*1440,IF(E6=\"\",0,IF(D6>E6,(1+E6-D6)*1440)))/60","v":0},{"$f":"IF(E6=\"\",\"\",F6)","v":""},null,{"$f":"IF(G6=\"\",\"\",G6*$H$5)","v":""},null,null,null,{"$f":"DATE($C$1,$L$4,N6)","v":"2021-05-03"},3]
[{"$f":"(YEAR($E$1)&\"/\"&MONTH($E$1)&\"/\"&DAY($E$1))+N6-$N$4","v":"2021-04-07"},"7",{"$f":"IF(C6=\"\",\"\",IF($B$5=B7,\"\",IF(DAY($B$5)<=DAY(B7),DATE($C$1,$C$3,B7),DATE($C$1,$C$3+1,B7))))","v":"2021-04-07"},null,null,{"$f":"IF(D7<E7,(E7-D7)*1440,IF(E7=\"\",0,IF(D7>E7,(1+E7-D7)*1440)))/60","v":0},"",null,{"$f":"IF(G7=\"\",\"\",G7*$H$5)","v":""},null,null,null,"2021-05-04",4]
["2021-04-08","8","2021-04-08",null,null,{"$f":"IF(D8<E8,(E8-D8)*1440,IF(E8=\"\",0,IF(D8>E8,(1+E8-D8)*1440)))/60","v":0},"",null,"",null,null,null,"2021-05-05",5]
["2021-04-09","9","2021-04-09",null,null,{"$f":"IF(D9<E9,(E9-D9)*1440,IF(E9=\"\",0,IF(D9>E9,(1+E9-D9)*1440)))/60","v":0},"",null,"",null,null,null,"2021-05-06",6]
["2021-04-10","10","2021-04-10",null,null,{"$f":"IF(D10<E10,(E10-D10)*1440,IF(E10=\"\",0,IF(D10>E10,(1+E10-D10)*1440)))/60","v":0},{"$f":"IF(E10=\"\",\"\",F10)","v":""},null,"",null,null,null,"2021-05-07",7]
["2021-04-11","11","2021-04-11",null,null,0,"",null,"",null,null,null,"2021-05-08",8]
["2021-04-12","12","2021-04-12",null,null,0,"",null,"",null,null,null,"2021-05-09",9]
["2021-04-13","13","2021-04-13",null,null,0,"",null,"",null,null,null,"2021-05-10",10]
["2021-04-14","14","2021-04-14",null,null,{"$f":"IF(D14<E14,(E14-D14)*1440,IF(E14=\"\",0,IF(D14>E14,(1+E14-D14)*1440)))/60","v":0},{"$f":"IF(E14=\"\",\"\",F14)","v":""},null,"",null,null,null,"2021-05-11",11]
["2021-04-15","15","2021-04-15",null,null,{"$f":"IF(D15<E15,(E15-D15)*1440,IF(E15=\"\",0,IF(D15>E15,(1+E15-D15)*1440)))/60","v":0},{"$f":"IF(E15=\"\",\"\",F15)","v":""},null,"",null,null,null,"2021-05-12",12]
["2021-04-16","16","2021-04-16",null,null,{"$f":"IF(D16<E16,(E16-D16)*1440,IF(E16=\"\",0,IF(D16>E16,(1+E16-D16)*1440)))/60","v":0},"",null,"",null,null,null,"2021-05-13",13]
["2021-04-17","17","2021-04-17",null,null,0,"",null,"",null,null,null,"2021-05-14",14]
["2021-04-18","18","2021-04-18",null,null,0,"",null,"",null,null,null,"2021-05-15",15]
["2021-04-19","19","2021-04-19",null,null,0,"",null,"",null,null,null,"2021-05-16",16]
["2021-04-20","20","2021-04-20",null,null,0,"",null,"",null,null,null,"2021-05-17",17]
["2021-04-21","21","2021-04-21",null,null,0,"",null,"",null,null,null,"2021-05-18",18]
["2021-04-22","22","2021-04-22",null,null,0,"",null,"",null,null,null,"2021-05-19",19]
["2021-04-23","23","2021-04-23",null,null,0,"",null,"",null,null,null,"2021-05-20",20]
["2021-04-24","24","2021-04-24",null,null,0,"",null,"",null,null,null,"2021-05-21",21]
["2021-04-25","25","2021-04-25",null,null,0,"",null,"",null,null,null,"2021-05-22",22]
["2021-04-26","26","2021-04-26",null,null,0,"",null,"",null,null,null,"2021-05-23",23]
["2021-04-27","27","2021-04-27",null,null,0,"",null,"",null,null,null,"2021-05-24",24]
["2021-04-28","28","2021-04-28",null,null,0,"",null,"",null,null,null,"2021-05-25",25]
["2021-04-29","29","2021-04-29",null,null,0,"",null,"",null,null,null,"2021-05-26",26]
["2021-04-30","30","2021-04-30",null,null,0,"",null,"",null,null,null,"2021-05-27",27]
["2021-05-01","1","2021-05-01",null,null,0,"",null,"",null,null,null,"2021-05-28",28]
["2021-05-02","2","2021-05-02",null,null,0,"",null,"",null,null,null,"2021-05-29",29]
["2021-05-03","3","2021-05-03",null,null,{"$f":"IF(D33<E33,(E33-D33)*1440,IF(E33=\"\",0,IF(D33>E33,(1+E33-D33)*1440)))/60","v":0},{"$f":"IF(E33=\"\",\"\",F33)","v":""},null,"",null,null,null,"2021-05-30",30]
["2021-05-04","4","2021-05-04",null,null,0,"",null,"",null,null,null,"2021-05-31",31]
["2021-05-05","5","",null,null,0,"",null,""]
[null,null,"합계",null,{"$f":"COUNT(E5:E35)","v":"00:00:00"},{"$f":"SUM(F5:F35)","v":0},{"$f":"SUM(G5:G35)","v":0},null,{"$f":"SUM(I5:I35)","v":0}]
[]
[null,null,null,null,null,null,50,null,600000]

{"sheet":"5월","index":4,"n_rows":39,"n_cols":15,"rows_kept":39,"cut":false,"hidden":false,"merged":[[0,2,1,3],[1,4,1,8]]}
[null,null,{"$f":"YEAR($E$1)","v":2021},null,{"$f":"'4월'!$E$1+'4월'!$D$3","v":"2021-05-05"},null,{"$f":"DAY($E$1)","v":5}]
[null,null,null,null,"출퇴근 기록부"]
[null,null,{"$f":"MONTH($E$1)","v":5},{"$f":"DAY(DATE(YEAR(E1),MONTH(E1)+1,1)-1)","v":"1900-01-31"},"근무일수","근무일수",{"$f":"E36","v":"00:00:00"},{"$f":"G36","v":0},"급여",{"$f":"I36","v":0}]
["날짜끄러오기","변환","날짜","출근시간","퇴근시간","근무수식","근무시간","시금","일급","비고",null,{"$f":"MONTH(E1)+1","v":6},{"$f":"DATE($C$1,$L$4,N4)","v":"2021-06-01"},1,{"$f":"DAY(DATE(YEAR(M4),MONTH(M4)+1,1)-1)","v":"1900-01-30"}]
[{"$f":"(YEAR($E$1)&\"/\"&MONTH($E$1)&\"/\"&DAY($E$1))+N4-$N$4","v":"2021-05-05"},{"$f":"TEXT(A5,\"d\")","v":"5"},{"$f":"DATE($C$1,C3,B5)","v":"2021-05-05"},null,null,{"$f":"IF(D5<E5,(E5-D5)*1440,IF(E5=\"\",0,IF(D5>E5,(1+E5-D5)*1440)))/60","v":0},{"$f":"IF(E5=\"\",\"\",F5)","v":""},{"$f":"'1월'!H5","v":8720},{"$f":"IF(G5=\"\",\"\",G5*$H$5)","v":""},null,null,null,{"$f":"DATE($C$1,$L$4,N5)","v":"2021-06-02"},2]
[{"$f":"(YEAR($E$1)&\"/\"&MONTH($E$1)&\"/\"&DAY($E$1))+N5-$N$4","v":"2021-05-06"},"6",{"$f":"IF(C5=\"\",\"\",IF($B$5=B6,\"\",IF(DAY($B$5)<=DAY(B6),DATE($C$1,$C$3,B6),DATE($C$1,$C$3+1,B6))))","v":"2021-05-06"},null,null,{"$f":"IF(D6<E6,(E6-D6)*1440,IF(E6=\"\",0,IF(D6>E6,(1+E6-D6)*1440)))/60","v":0},{"$f":"IF(E6=\"\",\"\",F6)","v":""},null,{"$f":"IF(G6=\"\",\"\",G6*$H$5)","v":""},null,null,null,{"$f":"DATE($C$1,$L$4,N6)","v":"2021-06-03"},3]
[{"$f":"(YEAR($E$1)&\"/\"&MONTH($E$1)&\"/\"&DAY($E$1))+N6-$N$4","v":"2021-05-07"},"7",{"$f":"IF(C6=\"\",\"\",IF($B$5=B7,\"\",IF(DAY($B$5)<=DAY(B7),DATE($C$1,$C$3,B7),DATE($C$1,$C$3+1,B7))))","v":"2021-05-07"},null,null,{"$f":"IF(D7<E7,(E7-D7)*1440,IF(E7=\"\",0,IF(D7>E7,(1+E7-D7)*1440)))/60","v":0},"",null,{"$f":"IF(G7=\"\",\"\",G7*$H$5)","v":""},null,null,null,"2021-06-04",4]
["2021-05-08","8","2021-05-08",null,null,{"$f":"IF(D8<E8,(E8-D8)*1440,IF(E8=\"\",0,IF(D8>E8,(1+E8-D8)*1440)))/60","v":0},"",null,"",null,null,null,"2021-06-05",5]
["2021-05-09","9","2021-05-09",null,null,{"$f":"IF(D9<E9,(E9-D9)*1440,IF(E9=\"\",0,IF(D9>E9,(1+E9-D9)*1440)))/60","v":0},"",null,"",null,null,null,"2021-06-06",6]
["2021-05-10","10","2021-05-10",null,null,{"$f":"IF(D10<E10,(E10-D10)*1440,IF(E10=\"\",0,IF(D10>E10,(1+E10-D10)*1440)))/60","v":0},{"$f":"IF(E10=\"\",\"\",F10)","v":""},null,"",null,null,null,"2021-06-07",7]
["2021-05-11","11","2021-05-11",null,null,0,"",null,"",null,null,null,"2021-06-08",8]
["2021-05-12","12","2021-05-12",null,null,0,"",null,"",null,null,null,"2021-06-09",9]
["2021-05-13","13","2021-05-13",null,null,0,"",null,"",null,null,null,"2021-06-10",10]
["2021-05-14","14","2021-05-14",null,null,{"$f":"IF(D14<E14,(E14-D14)*1440,IF(E14=\"\",0,IF(D14>E14,(1+E14-D14)*1440)))/60","v":0},{"$f":"IF(E14=\"\",\"\",F14)","v":""},null,"",null,null,null,"2021-06-11",11]
["2021-05-15","15","2021-05-15",null,null,{"$f":"IF(D15<E15,(E15-D15)*1440,IF(E15=\"\",0,IF(D15>E15,(1+E15-D15)*1440)))/60","v":0},{"$f":"IF(E15=\"\",\"\",F15)","v":""},null,"",null,null,null,"2021-06-12",12]
["2021-05-16","16","2021-05-16",null,null,{"$f":"IF(D16<E16,(E16-D16)*1440,IF(E16=\"\",0,IF(D16>E16,(1+E16-D16)*1440)))/60","v":0},"",null,"",null,null,null,"2021-06-13",13]
["2021-05-17","17","2021-05-17",null,null,0,"",null,"",null,null,null,"2021-06-14",14]
["2021-05-18","18","2021-05-18",null,null,0,"",null,"",null,null,null,"2021-06-15",15]
["2021-05-19","19","2021-05-19",null,null,0,"",null,"",null,null,null,"2021-06-16",16]
["2021-05-20","20","2021-05-20",null,null,0,"",null,"",null,null,null,"2021-06-17",17]
["2021-05-21","21","2021-05-21",null,null,0,"",null,"",null,null,null,"2021-06-18",18]
["2021-05-22","22","2021-05-22",null,null,0,"",null,"",null,null,null,"2021-06-19",19]
["2021-05-23","23","2021-05-23",null,null,0,"",null,"",null,null,null,"2021-06-20",20]
["2021-05-24","24","2021-05-24",null,null,0,"",null,"",null,null,null,"2021-06-21",21]
["2021-05-25","25","2021-05-25",null,null,0,"",null,"",null,null,null,"2021-06-22",22]
["2021-05-26","26","2021-05-26",null,null,0,"",null,"",null,null,null,"2021-06-23",23]
["2021-05-27","27","2021-05-27",null,null,0,"",null,"",null,null,null,"2021-06-24",24]
["2021-05-28","28","2021-05-28",null,null,0,"",null,"",null,null,null,"2021-06-25",25]
["2021-05-29","29","2021-05-29",null,null,{"$f":"IF(D29<E29,(E29-D29)*1440,IF(E29=\"\",0,IF(D29>E29,(1+E29-D29)*1440)))/60","v":0},{"$f":"IF(E29=\"\",\"\",F29)","v":""},null,"",null,null,null,"2021-06-26",26]
["2021-05-30","30","2021-05-30",null,null,0,"",null,"",null,null,null,"2021-06-27",27]
["2021-05-31","31","2021-05-31",null,null,0,"",null,"",null,null,null,"2021-06-28",28]
["2021-06-01","1","2021-06-01",null,null,0,"",null,"",null,null,null,"2021-06-29",29]
["2021-06-02",{"$f":"TEXT(A33,\"d\")","v":"2"},"2021-06-02",null,null,0,"",null,"",null,null,null,"2021-06-30",30]
["2021-06-03",{"$f":"TEXT(A34,\"d\")","v":"3"},"2021-06-03",null,null,0,"",null,"",null,null,null,"2021-07-01",31]
["2021-06-04","4","2021-06-04",null,null,0,"",null,""]
[null,null,"합계",null,{"$f":"COUNT(E5:E35)","v":"00:00:00"},{"$f":"SUM(F5:F35)","v":0},{"$f":"SUM(G5:G35)","v":0},null,{"$f":"SUM(I5:I35)","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,535000]

{"sheet":"6월","index":5,"n_rows":36,"n_cols":15,"rows_kept":36,"cut":false,"hidden":false,"merged":[[0,2,1,3],[1,4,1,8]]}
[null,null,{"$f":"YEAR($E$1)","v":2021},null,{"$f":"'5월'!$E$1+'5월'!$D$3","v":"2021-06-05"},null,{"$f":"DAY($E$1)","v":5}]
[null,null,null,null,"출퇴근 기록부"]
[null,null,{"$f":"MONTH($E$1)","v":6},{"$f":"DAY(DATE(YEAR(E1),MONTH(E1)+1,1)-1)","v":"1900-01-30"},"근무일수","근무일수",{"$f":"E36","v":"00:00:00"},{"$f":"G36","v":0},"급여",{"$f":"I36","v":0}]
["날짜끄러오기","변환","날짜","출근시간","퇴근시간","근무수식","근무시간","시금","일급","비고",null,{"$f":"MONTH(E1)+1","v":7},{"$f":"DATE($C$1,$L$4,N4)","v":"2021-07-01"},1,{"$f":"DAY(DATE(YEAR(M4),MONTH(M4)+1,1)-1)","v":"1900-01-31"}]
[{"$f":"(YEAR($E$1)&\"/\"&MONTH($E$1)&\"/\"&DAY($E$1))+N4-$N$4","v":"2021-06-05"},{"$f":"TEXT(A5,\"d\")","v":"5"},{"$f":"DATE($C$1,C3,B5)","v":"2021-06-05"},null,null,{"$f":"IF(D5<E5,(E5-D5)*1440,IF(E5=\"\",0,IF(D5>E5,(1+E5-D5)*1440)))/60","v":0},{"$f":"IF(E5=\"\",\"\",F5)","v":""},{"$f":"'1월'!H5","v":8720},{"$f":"IF(G5=\"\",\"\",G5*$H$5)","v":""},null,null,null,{"$f":"DATE($C$1,$L$4,N5)","v":"2021-07-02"},2]
[{"$f":"(YEAR($E$1)&\"/\"&MONTH($E$1)&\"/\"&DAY($E$1))+N5-$N$4","v":"2021-06-06"},"6",{"$f":"IF(C5=\"\",\"\",IF($B$5=B6,\"\",IF(DAY($B$5)<=DAY(B6),DATE($C$1,$C$3,B6),DATE($C$1,$C$3+1,B6))))","v":"2021-06-06"},null,null,{"$f":"IF(D6<E6,(E6-D6)*1440,IF(E6=\"\",0,IF(D6>E6,(1+E6-D6)*1440)))/60","v":0},{"$f":"IF(E6=\"\",\"\",F6)","v":""},null,{"$f":"IF(G6=\"\",\"\",G6*$H$5)","v":""},null,null,null,{"$f":"DATE($C$1,$L$4,N6)","v":"2021-07-03"},3]
[{"$f":"(YEAR($E$1)&\"/\"&MONTH($E$1)&\"/\"&DAY($E$1))+N6-$N$4","v":"2021-06-07"},"7",{"$f":"IF(C6=\"\",\"\",IF($B$5=B7,\"\",IF(DAY($B$5)<=DAY(B7),DATE($C$1,$C$3,B7),DATE($C$1,$C$3+1,B7))))","v":"2021-06-07"},null,null,{"$f":"IF(D7<E7,(E7-D7)*1440,IF(E7=\"\",0,IF(D7>E7,(1+E7-D7)*1440)))/60","v":0},"",null,{"$f":"IF(G7=\"\",\"\",G7*$H$5)","v":""},null,null,null,"2021-07-04",4]
["2021-06-08","8","2021-06-08",null,null,{"$f":"IF(D8<E8,(E8-D8)*1440,IF(E8=\"\",0,IF(D8>E8,(1+E8-D8)*1440)))/60","v":0},"",null,"",null,null,null,"2021-07-05",5]
["2021-06-09","9","2021-06-09",null,null,{"$f":"IF(D9<E9,(E9-D9)*1440,IF(E9=\"\",0,IF(D9>E9,(1+E9-D9)*1440)))/60","v":0},"",null,"",null,null,null,"2021-07-06",6]
["2021-06-10","10","2021-06-10",null,null,{"$f":"IF(D10<E10,(E10-D10)*1440,IF(E10=\"\",0,IF(D10>E10,(1+E10-D10)*1440)))/60","v":0},{"$f":"IF(E10=\"\",\"\",F10)","v":""},null,"",null,null,null,"2021-07-07",7]
["2021-06-11","11","2021-06-11",null,null,0,"",null,"",null,null,null,"2021-07-08",8]
["2021-06-12","12","2021-06-12",null,null,0,"",null,"",null,null,null,"2021-07-09",9]
["2021-06-13","13","2021-06-13",null,null,0,"",null,"",null,null,null,"2021-07-10",10]
["2021-06-14","14","2021-06-14",null,null,{"$f":"IF(D14<E14,(E14-D14)*1440,IF(E14=\"\",0,IF(D14>E14,(1+E14-D14)*1440)))/60","v":0},{"$f":"IF(E14=\"\",\"\",F14)","v":""},null,"",null,null,null,"2021-07-11",11]
["2021-06-15","15","2021-06-15",null,null,{"$f":"IF(D15<E15,(E15-D15)*1440,IF(E15=\"\",0,IF(D15>E15,(1+E15-D15)*1440)))/60","v":0},{"$f":"IF(E15=\"\",\"\",F15)","v":""},null,"",null,null,null,"2021-07-12",12]
["2021-06-16","16","2021-06-16",null,null,{"$f":"IF(D16<E16,(E16-D16)*1440,IF(E16=\"\",0,IF(D16>E16,(1+E16-D16)*1440)))/60","v":0},"",null,"",null,null,null,"2021-07-13",13]
["2021-06-17","17","2021-06-17",null,null,0,"",null,"",null,null,null,"2021-07-14",14]
["2021-06-18","18","2021-06-18",null,null,0,"",null,"",null,null,null,"2021-07-15",15]
["2021-06-19","19","2021-06-19",null,null,0,"",null,"",null,null,null,"2021-07-16",16]
["2021-06-20","20","2021-06-20",null,null,0,"",null,"",null,null,null,"2021-07-17",17]
["2021-06-21","21","2021-06-21",null,null,0,"",null,"",null,null,null,"2021-07-18",18]
["2021-06-22","22","2021-06-22",null,null,0,"",null,"",null,null,null,"2021-07-19",19]
["2021-06-23","23","2021-06-23",null,null,0,"",null,"",null,null,null,"2021-07-20",20]
["2021-06-24","24","2021-06-24",null,null,0,"",null,"",null,null,null,"2021-07-21",21]
["2021-06-25","25","2021-06-25",null,null,0,"",null,"",null,null,null,"2021-07-22",22]
["2021-06-26","26","2021-06-26",null,null,0,"",null,"",null,null,null,"2021-07-23",23]
["2021-06-27","27","2021-06-27",null,null,0,"",null,"",null,null,null,"2021-07-24",24]
["2021-06-28","28","2021-06-28",null,null,0,"",null,"",null,null,null,"2021-07-25",25]
["2021-06-29","29","2021-06-29",null,null,0,"",null,"",null,null,null,"2021-07-26",26]
["2021-06-30","30","2021-06-30",null,null,0,"",null,"",null,null,null,"2021-07-27",27]
["2021-07-01","1","2021-07-01",null,null,0,"",null,"",null,null,null,"2021-07-28",28]
["2021-07-02","2","2021-07-02",null,null,0,"",null,"",null,null,null,"2021-07-29",29]
["2021-07-03","3","2021-07-03",null,null,0,"",null,"",null,null,null,"2021-07-30",30]
["2021-07-04","4","2021-07-04",null,null,0,"",null,"",null,null,null,"2021-07-31",31]
["2021-07-05","5","",null,null,0,"",null,""]
[null,null,"합계",null,{"$f":"COUNT(E5:E35)","v":"00:00:00"},{"$f":"SUM(F5:F35)","v":0},{"$f":"SUM(G5:G35)","v":0},null,{"$f":"SUM(I5:I35)","v":0}]

{"sheet":"7월","index":6,"n_rows":36,"n_cols":15,"rows_kept":36,"cut":false,"hidden":false,"merged":[[0,2,1,3],[1,4,1,8]]}
[null,null,{"$f":"YEAR($E$1)","v":2021},null,{"$f":"'6월'!$E$1+'6월'!$D$3","v":"2021-07-05"},null,{"$f":"DAY($E$1)","v":5}]
[null,null,null,null,"출퇴근 기록부"]
[null,null,{"$f":"MONTH($E$1)","v":7},{"$f":"DAY(DATE(YEAR(E1),MONTH(E1)+1,1)-1)","v":"1900-01-31"},"근무일수","근무일수",{"$f":"E36","v":"00:00:00"},{"$f":"G36","v":0},"급여",{"$f":"I36","v":0}]
["날짜끄러오기","변환","날짜","출근시간","퇴근시간","근무수식","근무시간","시금","일급","비고",null,{"$f":"MONTH(E1)+1","v":8},{"$f":"DATE($C$1,$L$4,N4)","v":"2021-08-01"},1,{"$f":"DAY(DATE(YEAR(M4),MONTH(M4)+1,1)-1)","v":"1900-01-31"}]
[{"$f":"(YEAR($E$1)&\"/\"&MONTH($E$1)&\"/\"&DAY($E$1))+N4-$N$4","v":"2021-07-05"},{"$f":"TEXT(A5,\"d\")","v":"5"},{"$f":"DATE($C$1,C3,B5)","v":"2021-07-05"},null,null,{"$f":"IF(D5<E5,(E5-D5)*1440,IF(E5=\"\",0,IF(D5>E5,(1+E5-D5)*1440)))/60","v":0},{"$f":"IF(E5=\"\",\"\",F5)","v":""},{"$f":"'1월'!H5","v":8720},{"$f":"IF(G5=\"\",\"\",G5*$H$5)","v":""},null,null,null,{"$f":"DATE($C$1,$L$4,N5)","v":"2021-08-02"},2]
[{"$f":"(YEAR($E$1)&\"/\"&MONTH($E$1)&\"/\"&DAY($E$1))+N5-$N$4","v":"2021-07-06"},"6",{"$f":"IF(C5=\"\",\"\",IF($B$5=B6,\"\",IF(DAY($B$5)<=DAY(B6),DATE($C$1,$C$3,B6),DATE($C$1,$C$3+1,B6))))","v":"2021-07-06"},null,null,{"$f":"IF(D6<E6,(E6-D6)*1440,IF(E6=\"\",0,IF(D6>E6,(1+E6-D6)*1440)))/60","v":0},{"$f":"IF(E6=\"\",\"\",F6)","v":""},null,{"$f":"IF(G6=\"\",\"\",G6*$H$5)","v":""},null,null,null,{"$f":"DATE($C$1,$L$4,N6)","v":"2021-08-03"},3]
[{"$f":"(YEAR($E$1)&\"/\"&MONTH($E$1)&\"/\"&DAY($E$1))+N6-$N$4","v":"2021-07-07"},"7",{"$f":"IF(C6=\"\",\"\",IF($B$5=B7,\"\",IF(DAY($B$5)<=DAY(B7),DATE($C$1,$C$3,B7),DATE($C$1,$C$3+1,B7))))","v":"2021-07-07"},null,null,{"$f":"IF(D7<E7,(E7-D7)*1440,IF(E7=\"\",0,IF(D7>E7,(1+E7-D7)*1440)))/60","v":0},"",null,{"$f":"IF(G7=\"\",\"\",G7*$H$5)","v":""},null,null,null,"2021-08-04",4]
["2021-07-08","8","2021-07-08",null,null,{"$f":"IF(D8<E8,(E8-D8)*1440,IF(E8=\"\",0,IF(D8>E8,(1+E8-D8)*1440)))/60","v":0},"",null,"",null,null,null,"2021-08-05",5]
["2021-07-09","9","2021-07-09",null,null,{"$f":"IF(D9<E9,(E9-D9)*1440,IF(E9=\"\",0,IF(D9>E9,(1+E9-D9)*1440)))/60","v":0},"",null,"",null,null,null,"2021-08-06",6]
["2021-07-10","10","2021-07-10",null,null,{"$f":"IF(D10<E10,(E10-D10)*1440,IF(E10=\"\",0,IF(D10>E10,(1+E10-D10)*1440)))/60","v":0},{"$f":"IF(E10=\"\",\"\",F10)","v":""},null,"",null,null,null,"2021-08-07",7]
["2021-07-11","11","2021-07-11",null,null,0,"",null,"",null,null,null,"2021-08-08",8]
["2021-07-12","12","2021-07-12",null,null,0,"",null,"",null,null,null,"2021-08-09",9]
["2021-07-13","13","2021-07-13",null,null,0,"",null,"",null,null,null,"2021-08-10",10]
["2021-07-14","14","2021-07-14",null,null,{"$f":"IF(D14<E14,(E14-D14)*1440,IF(E14=\"\",0,IF(D14>E14,(1+E14-D14)*1440)))/60","v":0},{"$f":"IF(E14=\"\",\"\",F14)","v":""},null,"",null,null,null,"2021-08-11",11]
["2021-07-15","15","2021-07-15",null,null,{"$f":"IF(D15<E15,(E15-D15)*1440,IF(E15=\"\",0,IF(D15>E15,(1+E15-D15)*1440)))/60","v":0},{"$f":"IF(E15=\"\",\"\",F15)","v":""},null,"",null,null,null,"2021-08-12",12]
["2021-07-16","16","2021-07-16",null,null,{"$f":"IF(D16<E16,(E16-D16)*1440,IF(E16=\"\",0,IF(D16>E16,(1+E16-D16)*1440)))/60","v":0},"",null,"",null,null,null,"2021-08-13",13]
["2021-07-17","17","2021-07-17",null,null,0,"",null,"",null,null,null,"2021-08-14",14]
["2021-07-18","18","2021-07-18",null,null,0,"",null,"",null,null,null,"2021-08-15",15]
["2021-07-19","19","2021-07-19",null,null,0,"",null,"",null,null,null,"2021-08-16",16]
["2021-07-20","20","2021-07-20",null,null,0,"",null,"",null,null,null,"2021-08-17",17]
["2021-07-21","21","2021-07-21",null,null,0,"",null,"",null,null,null,"2021-08-18",18]
["2021-07-22","22","2021-07-22",null,null,0,"",null,"",null,null,null,"2021-08-19",19]
["2021-07-23","23","2021-07-23",null,null,0,"",null,"",null,null,null,"2021-08-20",20]
["2021-07-24","24","2021-07-24",null,null,0,"",null,"",null,null,null,"2021-08-21",21]
["2021-07-25","25","2021-07-25",null,null,0,"",null,"",null,null,null,"2021-08-22",22]
["2021-07-26","26","2021-07-26",null,null,0,"",null,"",null,null,null,"2021-08-23",23]
["2021-07-27","27","2021-07-27",null,null,0,"",null,"",null,null,null,"2021-08-24",24]
["2021-07-28","28","2021-07-28",null,null,0,"",null,"",null,null,null,"2021-08-25",25]
["2021-07-29","29","2021-07-29",null,null,0,"",null,"",null,null,null,"2021-08-26",26]
["2021-07-30","30","2021-07-30",null,null,0,"",null,"",null,null,null,"2021-08-27",27]
["2021-07-31","31","2021-07-31",null,null,0,"",null,"",null,null,null,"2021-08-28",28]
["2021-08-01","1","2021-08-01",null,null,0,"",null,"",null,null,null,"2021-08-29",29]
["2021-08-02","2","2021-08-02",null,null,0,"",null,"",null,null,null,"2021-08-30",30]
["2021-08-03","3","2021-08-03",null,null,0,"",null,"",null,null,null,"2021-08-31",31]
["2021-08-04","4","2021-08-04",null,null,0,"",null,""]
[null,null,"합계",null,{"$f":"COUNT(E5:E35)","v":"00:00:00"},{"$f":"SUM(F5:F35)","v":0},{"$f":"SUM(G5:G35)","v":0},null,{"$f":"SUM(I5:I35)","v":0}]

{"sheet":"8월","index":7,"n_rows":36,"n_cols":15,"rows_kept":36,"cut":false,"hidden":false,"merged":[[0,2,1,3],[1,4,1,8]]}
[null,null,{"$f":"YEAR($E$1)","v":2021},null,{"$f":"'7월'!$E$1+'7월'!$D$3","v":"2021-08-05"},null,{"$f":"DAY($E$1)","v":5}]
[null,null,null,null,"출퇴근 기록부"]
[null,null,{"$f":"MONTH($E$1)","v":8},{"$f":"DAY(DATE(YEAR(E1),MONTH(E1)+1,1)-1)","v":"1900-01-31"},"근무일수","근무일수",{"$f":"E36","v":"00:00:00"},{"$f":"G36","v":0},"급여",{"$f":"I36","v":0}]
["날짜끄러오기","변환","날짜","출근시간","퇴근시간","근무수식","근무시간","시금","일급","비고",null,{"$f":"MONTH(E1)+1","v":9},{"$f":"DATE($C$1,$L$4,N4)","v":"2021-09-01"},1,{"$f":"DAY(DATE(YEAR(M4),MONTH(M4)+1,1)-1)","v":"1900-01-30"}]
[{"$f":"(YEAR($E$1)&\"/\"&MONTH($E$1)&\"/\"&DAY($E$1))+N4-$N$4","v":"2021-08-05"},{"$f":"TEXT(A5,\"d\")","v":"5"},{"$f":"DATE($C$1,C3,B5)","v":"2021-08-05"},null,null,{"$f":"IF(D5<E5,(E5-D5)*1440,IF(E5=\"\",0,IF(D5>E5,(1+E5-D5)*1440)))/60","v":0},{"$f":"IF(E5=\"\",\"\",F5)","v":""},{"$f":"'1월'!H5","v":8720},{"$f":"IF(G5=\"\",\"\",G5*$H$5)","v":""},null,null,null,{"$f":"DATE($C$1,$L$4,N5)","v":"2021-09-02"},2]
[{"$f":"(YEAR($E$1)&\"/\"&MONTH($E$1)&\"/\"&DAY($E$1))+N5-$N$4","v":"2021-08-06"},"6",{"$f":"IF(C5=\"\",\"\",IF($B$5=B6,\"\",IF(DAY($B$5)<=DAY(B6),DATE($C$1,$C$3,B6),DATE($C$1,$C$3+1,B6))))","v":"2021-08-06"},null,null,{"$f":"IF(D6<E6,(E6-D6)*1440,IF(E6=\"\",0,IF(D6>E6,(1+E6-D6)*1440)))/60","v":0},{"$f":"IF(E6=\"\",\"\",F6)","v":""},null,{"$f":"IF(G6=\"\",\"\",G6*$H$5)","v":""},null,null,null,{"$f":"DATE($C$1,$L$4,N6)","v":"2021-09-03"},3]
[{"$f":"(YEAR($E$1)&\"/\"&MONTH($E$1)&\"/\"&DAY($E$1))+N6-$N$4","v":"2021-08-07"},"7",{"$f":"IF(C6=\"\",\"\",IF($B$5=B7,\"\",IF(DAY($B$5)<=DAY(B7),DATE($C$1,$C$3,B7),DATE($C$1,$C$3+1,B7))))","v":"2021-08-07"},null,null,{"$f":"IF(D7<E7,(E7-D7)*1440,IF(E7=\"\",0,IF(D7>E7,(1+E7-D7)*1440)))/60","v":0},"",null,{"$f":"IF(G7=\"\",\"\",G7*$H$5)","v":""},null,null,null,"2021-09-04",4]
["2021-08-08","8","2021-08-08",null,null,{"$f":"IF(D8<E8,(E8-D8)*1440,IF(E8=\"\",0,IF(D8>E8,(1+E8-D8)*1440)))/60","v":0},"",null,"",null,null,null,"2021-09-05",5]
["2021-08-09","9","2021-08-09",null,null,{"$f":"IF(D9<E9,(E9-D9)*1440,IF(E9=\"\",0,IF(D9>E9,(1+E9-D9)*1440)))/60","v":0},"",null,"",null,null,null,"2021-09-06",6]
["2021-08-10","10","2021-08-10",null,null,{"$f":"IF(D10<E10,(E10-D10)*1440,IF(E10=\"\",0,IF(D10>E10,(1+E10-D10)*1440)))/60","v":0},{"$f":"IF(E10=\"\",\"\",F10)","v":""},null,"",null,null,null,"2021-09-07",7]
["2021-08-11","11","2021-08-11",null,null,0,"",null,"",null,null,null,"2021-09-08",8]
["2021-08-12","12","2021-08-12",null,null,0,"",null,"",null,null,null,"2021-09-09",9]
["2021-08-13","13","2021-08-13",null,null,0,"",null,"",null,null,null,"2021-09-10",10]
["2021-08-14","14","2021-08-14",null,null,{"$f":"IF(D14<E14,(E14-D14)*1440,IF(E14=\"\",0,IF(D14>E14,(1+E14-D14)*1440)))/60","v":0},{"$f":"IF(E14=\"\",\"\",F14)","v":""},null,"",null,null,null,"2021-09-11",11]
["2021-08-15","15","2021-08-15",null,null,{"$f":"IF(D15<E15,(E15-D15)*1440,IF(E15=\"\",0,IF(D15>E15,(1+E15-D15)*1440)))/60","v":0},{"$f":"IF(E15=\"\",\"\",F15)","v":""},null,"",null,null,null,"2021-09-12",12]
["2021-08-16","16","2021-08-16",null,null,{"$f":"IF(D16<E16,(E16-D16)*1440,IF(E16=\"\",0,IF(D16>E16,(1+E16-D16)*1440)))/60","v":0},"",null,"",null,null,null,"2021-09-13",13]
["2021-08-17","17","2021-08-17",null,null,0,"",null,"",null,null,null,"2021-09-14",14]
["2021-08-18","18","2021-08-18",null,null,0,"",null,"",null,null,null,"2021-09-15",15]
["2021-08-19","19","2021-08-19",null,null,0,"",null,"",null,null,null,"2021-09-16",16]
["2021-08-20","20","2021-08-20",null,null,0,"",null,"",null,null,null,"2021-09-17",17]
["2021-08-21","21","2021-08-21",null,null,0,"",null,"",null,null,null,"2021-09-18",18]
["2021-08-22","22","2021-08-22",null,null,0,"",null,"",null,null,null,"2021-09-19",19]
["2021-08-23","23","2021-08-23",null,null,0,"",null,"",null,null,null,"2021-09-20",20]
["2021-08-24","24","2021-08-24",null,null,0,"",null,"",null,null,null,"2021-09-21",21]
["2021-08-25","25","2021-08-25",null,null,0,"",null,"",null,null,null,"2021-09-22",22]
["2021-08-26","26","2021-08-26",null,null,0,"",null,"",null,null,null,"2021-09-23",23]
["2021-08-27","27","2021-08-27",null,null,0,"",null,"",null,null,null,"2021-09-24",24]
["2021-08-28","28","2021-08-28",null,null,0,"",null,"",null,null,null,"2021-09-25",25]
["2021-08-29","29","2021-08-29",null,null,0,"",null,"",null,null,null,"2021-09-26",26]
["2021-08-30","30","2021-08-30",null,null,0,"",null,"",null,null,null,"2021-09-27",27]
["2021-08-31","31","2021-08-31",null,null,0,"",null,"",null,null,null,"2021-09-28",28]
["2021-09-01","1","2021-09-01",null,null,0,"",null,"",null,null,null,"2021-09-29",29]
["2021-09-02","2","2021-09-02",null,null,0,"",null,"",null,null,null,"2021-09-30",30]
["2021-09-03","3","2021-09-03",null,null,0,"",null,"",null,null,null,"2021-10-01",31]
["2021-09-04","4","2021-09-04",null,null,0,"",null,""]
[null,null,"합계",null,{"$f":"COUNT(E5:E35)","v":"00:00:00"},{"$f":"SUM(F5:F35)","v":0},{"$f":"SUM(G5:G35)","v":0},null,{"$f":"SUM(I5:I35)","v":0}]

{"sheet":"9월","index":8,"n_rows":36,"n_cols":15,"rows_kept":36,"cut":false,"hidden":false,"merged":[[0,2,1,3],[1,4,1,8]]}
[null,null,{"$f":"YEAR($E$1)","v":2021},null,{"$f":"'8월'!$E$1+'8월'!$D$3","v":"2021-09-05"},null,{"$f":"DAY($E$1)","v":5}]
[null,null,null,null,"출퇴근 기록부"]
[null,null,{"$f":"MONTH($E$1)","v":9},{"$f":"DAY(DATE(YEAR(E1),MONTH(E1)+1,1)-1)","v":"1900-01-30"},"근무일수","근무일수",{"$f":"E36","v":"00:00:00"},{"$f":"G36","v":0},"급여",{"$f":"I36","v":0}]
["날짜끄러오기","변환","날짜","출근시간","퇴근시간","근무수식","근무시간","시금","일급","비고",null,{"$f":"MONTH(E1)+1","v":10},{"$f":"DATE($C$1,$L$4,N4)","v":"2021-10-01"},1,{"$f":"DAY(DATE(YEAR(M4),MONTH(M4)+1,1)-1)","v":"1900-01-31"}]
[{"$f":"(YEAR($E$1)&\"/\"&MONTH($E$1)&\"/\"&DAY($E$1))+N4-$N$4","v":"2021-09-05"},{"$f":"TEXT(A5,\"d\")","v":"5"},{"$f":"DATE($C$1,C3,B5)","v":"2021-09-05"},null,null,{"$f":"IF(D5<E5,(E5-D5)*1440,IF(E5=\"\",0,IF(D5>E5,(1+E5-D5)*1440)))/60","v":0},{"$f":"IF(E5=\"\",\"\",F5)","v":""},{"$f":"'1월'!H5","v":8720},{"$f":"IF(G5=\"\",\"\",G5*$H$5)","v":""},null,null,null,{"$f":"DATE($C$1,$L$4,N5)","v":"2021-10-02"},2]
[{"$f":"(YEAR($E$1)&\"/\"&MONTH($E$1)&\"/\"&DAY($E$1))+N5-$N$4","v":"2021-09-06"},"6",{"$f":"IF(C5=\"\",\"\",IF($B$5=B6,\"\",IF(DAY($B$5)<=DAY(B6),DATE($C$1,$C$3,B6),DATE($C$1,$C$3+1,B6))))","v":"2021-09-06"},null,null,{"$f":"IF(D6<E6,(E6-D6)*1440,IF(E6=\"\",0,IF(D6>E6,(1+E6-D6)*1440)))/60","v":0},{"$f":"IF(E6=\"\",\"\",F6)","v":""},null,{"$f":"IF(G6=\"\",\"\",G6*$H$5)","v":""},null,null,null,{"$f":"DATE($C$1,$L$4,N6)","v":"2021-10-03"},3]
[{"$f":"(YEAR($E$1)&\"/\"&MONTH($E$1)&\"/\"&DAY($E$1))+N6-$N$4","v":"2021-09-07"},"7",{"$f":"IF(C6=\"\",\"\",IF($B$5=B7,\"\",IF(DAY($B$5)<=DAY(B7),DATE($C$1,$C$3,B7),DATE($C$1,$C$3+1,B7))))","v":"2021-09-07"},null,null,{"$f":"IF(D7<E7,(E7-D7)*1440,IF(E7=\"\",0,IF(D7>E7,(1+E7-D7)*1440)))/60","v":0},"",null,{"$f":"IF(G7=\"\",\"\",G7*$H$5)","v":""},null,null,null,"2021-10-04",4]
["2021-09-08","8","2021-09-08",null,null,{"$f":"IF(D8<E8,(E8-D8)*1440,IF(E8=\"\",0,IF(D8>E8,(1+E8-D8)*1440)))/60","v":0},"",null,"",null,null,null,"2021-10-05",5]
["2021-09-09","9","2021-09-09",null,null,{"$f":"IF(D9<E9,(E9-D9)*1440,IF(E9=\"\",0,IF(D9>E9,(1+E9-D9)*1440)))/60","v":0},"",null,"",null,null,null,"2021-10-06",6]
["2021-09-10","10","2021-09-10",null,null,{"$f":"IF(D10<E10,(E10-D10)*1440,IF(E10=\"\",0,IF(D10>E10,(1+E10-D10)*1440)))/60","v":0},{"$f":"IF(E10=\"\",\"\",F10)","v":""},null,"",null,null,null,"2021-10-07",7]
["2021-09-11","11","2021-09-11",null,null,0,"",null,"",null,null,null,"2021-10-08",8]
["2021-09-12","12","2021-09-12",null,null,0,"",null,"",null,null,null,"2021-10-09",9]
["2021-09-13","13","2021-09-13",null,null,0,"",null,"",null,null,null,"2021-10-10",10]
["2021-09-14","14","2021-09-14",null,null,{"$f":"IF(D14<E14,(E14-D14)*1440,IF(E14=\"\",0,IF(D14>E14,(1+E14-D14)*1440)))/60","v":0},{"$f":"IF(E14=\"\",\"\",F14)","v":""},null,"",null,null,null,"2021-10-11",11]
["2021-09-15","15","2021-09-15",null,null,{"$f":"IF(D15<E15,(E15-D15)*1440,IF(E15=\"\",0,IF(D15>E15,(1+E15-D15)*1440)))/60","v":0},{"$f":"IF(E15=\"\",\"\",F15)","v":""},null,"",null,null,null,"2021-10-12",12]
["2021-09-16","16","2021-09-16",null,null,{"$f":"IF(D16<E16,(E16-D16)*1440,IF(E16=\"\",0,IF(D16>E16,(1+E16-D16)*1440)))/60","v":0},"",null,"",null,null,null,"2021-10-13",13]
["2021-09-17","17","2021-09-17",null,null,0,"",null,"",null,null,null,"2021-10-14",14]
["2021-09-18","18","2021-09-18",null,null,0,"",null,"",null,null,null,"2021-10-15",15]
["2021-09-19","19","2021-09-19",null,null,0,"",null,"",null,null,null,"2021-10-16",16]
["2021-09-20","20","2021-09-20",null,null,0,"",null,"",null,null,null,"2021-10-17",17]
["2021-09-21","21","2021-09-21",null,null,0,"",null,"",null,null,null,"2021-10-18",18]
["2021-09-22","22","2021-09-22",null,null,0,"",null,"",null,null,null,"2021-10-19",19]
["2021-09-23","23","2021-09-23",null,null,0,"",null,"",null,null,null,"2021-10-20",20]
["2021-09-24","24","2021-09-24",null,null,0,"",null,"",null,null,null,"2021-10-21",21]
["2021-09-25","25","2021-09-25",null,null,0,"",null,"",null,null,null,"2021-10-22",22]
["2021-09-26","26","2021-09-26",null,null,0,"",null,"",null,null,null,"2021-10-23",23]
["2021-09-27","27","2021-09-27",null,null,0,"",null,"",null,null,null,"2021-10-24",24]
["2021-09-28","28","2021-09-28",null,null,0,"",null,"",null,null,null,"2021-10-25",25]
["2021-09-29","29","2021-09-29",null,null,0,"",null,"",null,null,null,"2021-10-26",26]
["2021-09-30","30","2021-09-30",null,null,0,"",null,"",null,null,null,"2021-10-27",27]
["2021-10-01","1","2021-10-01",null,null,0,"",null,"",null,null,null,"2021-10-28",28]
["2021-10-02","2","2021-10-02",null,null,0,"",null,"",null,null,null,"2021-10-29",29]
["2021-10-03","3","2021-10-03",null,null,0,"",null,"",null,null,null,"2021-10-30",30]
["2021-10-04","4","2021-10-04",null,null,0,"",null,"",null,null,null,"2021-10-31",31]
["2021-10-05","5","",null,null,0,"",null,""]
[null,null,"합계",null,{"$f":"COUNT(E5:E35)","v":"00:00:00"},{"$f":"SUM(F5:F35)","v":0},{"$f":"SUM(G5:G35)","v":0},null,{"$f":"SUM(I5:I35)","v":0}]

{"sheet":"10월","index":9,"n_rows":36,"n_cols":15,"rows_kept":36,"cut":false,"hidden":false,"merged":[[0,2,1,3],[1,4,1,8]]}
[null,null,{"$f":"YEAR($E$1)","v":2021},null,{"$f":"'9월'!$E$1+'9월'!$D$3","v":"2021-10-05"},null,{"$f":"DAY($E$1)","v":5}]
[null,null,null,null,"출퇴근 기록부"]
[null,null,{"$f":"MONTH($E$1)","v":10},{"$f":"DAY(DATE(YEAR(E1),MONTH(E1)+1,1)-1)","v":"1900-01-31"},"근무일수","근무일수",{"$f":"E36","v":"00:00:00"},{"$f":"G36","v":0},"급여",{"$f":"I36","v":0}]
["날짜끄러오기","변환","날짜","출근시간","퇴근시간","근무수식","근무시간","시금","일급","비고",null,{"$f":"MONTH(E1)+1","v":11},{"$f":"DATE($C$1,$L$4,N4)","v":"2021-11-01"},1,{"$f":"DAY(DATE(YEAR(M4),MONTH(M4)+1,1)-1)","v":"1900-01-30"}]
[{"$f":"(YEAR($E$1)&\"/\"&MONTH($E$1)&\"/\"&DAY($E$1))+N4-$N$4","v":"2021-10-05"},{"$f":"TEXT(A5,\"d\")","v":"5"},{"$f":"DATE($C$1,C3,B5)","v":"2021-10-05"},null,null,{"$f":"IF(D5<E5,(E5-D5)*1440,IF(E5=\"\",0,IF(D5>E5,(1+E5-D5)*1440)))/60","v":0},{"$f":"IF(E5=\"\",\"\",F5)","v":""},{"$f":"'1월'!H5","v":8720},{"$f":"IF(G5=\"\",\"\",G5*$H$5)","v":""},null,null,null,{"$f":"DATE($C$1,$L$4,N5)","v":"2021-11-02"},2]
[{"$f":"(YEAR($E$1)&\"/\"&MONTH($E$1)&\"/\"&DAY($E$1))+N5-$N$4","v":"2021-10-06"},"6",{"$f":"IF(C5=\"\",\"\",IF($B$5=B6,\"\",IF(DAY($B$5)<=DAY(B6),DATE($C$1,$C$3,B6),DATE($C$1,$C$3+1,B6))))","v":"2021-10-06"},null,null,{"$f":"IF(D6<E6,(E6-D6)*1440,IF(E6=\"\",0,IF(D6>E6,(1+E6-D6)*1440)))/60","v":0},{"$f":"IF(E6=\"\",\"\",F6)","v":""},null,{"$f":"IF(G6=\"\",\"\",G6*$H$5)","v":""},null,null,null,{"$f":"DATE($C$1,$L$4,N6)","v":"2021-11-03"},3]
[{"$f":"(YEAR($E$1)&\"/\"&MONTH($E$1)&\"/\"&DAY($E$1))+N6-$N$4","v":"2021-10-07"},"7",{"$f":"IF(C6=\"\",\"\",IF($B$5=B7,\"\",IF(DAY($B$5)<=DAY(B7),DATE($C$1,$C$3,B7),DATE($C$1,$C$3+1,B7))))","v":"2021-10-07"},null,null,{"$f":"IF(D7<E7,(E7-D7)*1440,IF(E7=\"\",0,IF(D7>E7,(1+E7-D7)*1440)))/60","v":0},"",null,{"$f":"IF(G7=\"\",\"\",G7*$H$5)","v":""},null,null,null,"2021-11-04",4]
["2021-10-08","8","2021-10-08",null,null,{"$f":"IF(D8<E8,(E8-D8)*1440,IF(E8=\"\",0,IF(D8>E8,(1+E8-D8)*1440)))/60","v":0},"",null,"",null,null,null,"2021-11-05",5]
["2021-10-09","9","2021-10-09",null,null,{"$f":"IF(D9<E9,(E9-D9)*1440,IF(E9=\"\",0,IF(D9>E9,(1+E9-D9)*1440)))/60","v":0},"",null,"",null,null,null,"2021-11-06",6]
["2021-10-10","10","2021-10-10",null,null,{"$f":"IF(D10<E10,(E10-D10)*1440,IF(E10=\"\",0,IF(D10>E10,(1+E10-D10)*1440)))/60","v":0},{"$f":"IF(E10=\"\",\"\",F10)","v":""},null,"",null,null,null,"2021-11-07",7]
["2021-10-11","11","2021-10-11",null,null,0,"",null,"",null,null,null,"2021-11-08",8]
["2021-10-12","12","2021-10-12",null,null,0,"",null,"",null,null,null,"2021-11-09",9]
["2021-10-13","13","2021-10-13",null,null,0,"",null,"",null,null,null,"2021-11-10",10]
["2021-10-14","14","2021-10-14",null,null,{"$f":"IF(D14<E14,(E14-D14)*1440,IF(E14=\"\",0,IF(D14>E14,(1+E14-D14)*1440)))/60","v":0},{"$f":"IF(E14=\"\",\"\",F14)","v":""},null,"",null,null,null,"2021-11-11",11]
["2021-10-15","15","2021-10-15",null,null,{"$f":"IF(D15<E15,(E15-D15)*1440,IF(E15=\"\",0,IF(D15>E15,(1+E15-D15)*1440)))/60","v":0},{"$f":"IF(E15=\"\",\"\",F15)","v":""},null,"",null,null,null,"2021-11-12",12]
["2021-10-16","16","2021-10-16",null,null,{"$f":"IF(D16<E16,(E16-D16)*1440,IF(E16=\"\",0,IF(D16>E16,(1+E16-D16)*1440)))/60","v":0},"",null,"",null,null,null,"2021-11-13",13]
["2021-10-17","17","2021-10-17",null,null,0,"",null,"",null,null,null,"2021-11-14",14]
["2021-10-18","18","2021-10-18",null,null,0,"",null,"",null,null,null,"2021-11-15",15]
["2021-10-19","19","2021-10-19",null,null,0,"",null,"",null,null,null,"2021-11-16",16]
["2021-10-20","20","2021-10-20",null,null,0,"",null,"",null,null,null,"2021-11-17",17]
["2021-10-21","21","2021-10-21",null,null,0,"",null,"",null,null,null,"2021-11-18",18]
["2021-10-22","22","2021-10-22",null,null,0,"",null,"",null,null,null,"2021-11-19",19]
["2021-10-23","23","2021-10-23",null,null,0,"",null,"",null,null,null,"2021-11-20",20]
["2021-10-24","24","2021-10-24",null,null,0,"",null,"",null,null,null,"2021-11-21",21]
["2021-10-25","25","2021-10-25",null,null,0,"",null,"",null,null,null,"2021-11-22",22]
["2021-10-26","26","2021-10-26",null,null,0,"",null,"",null,null,null,"2021-11-23",23]
["2021-10-27","27","2021-10-27",null,null,0,"",null,"",null,null,null,"2021-11-24",24]
["2021-10-28","28","2021-10-28",null,null,0,"",null,"",null,null,null,"2021-11-25",25]
["2021-10-29","29","2021-10-29",null,null,0,"",null,"",null,null,null,"2021-11-26",26]
["2021-10-30","30","2021-10-30",null,null,0,"",null,"",null,null,null,"2021-11-27",27]
["2021-10-31","31","2021-10-31",null,null,0,"",null,"",null,null,null,"2021-11-28",28]
["2021-11-01","1","2021-11-01",null,null,0,"",null,"",null,null,null,"2021-11-29",29]
["2021-11-02","2","2021-11-02",null,null,0,"",null,"",null,null,null,"2021-11-30",30]
["2021-11-03","3","2021-11-03",null,null,0,"",null,"",null,null,null,"2021-12-01",31]
["2021-11-04","4","2021-11-04",null,null,0,"",null,""]
[null,null,"합계",null,{"$f":"COUNT(E5:E35)","v":"00:00:00"},{"$f":"SUM(F5:F35)","v":0},{"$f":"SUM(G5:G35)","v":0},null,{"$f":"SUM(I5:I35)","v":0}]

{"sheet":"11월","index":10,"n_rows":36,"n_cols":15,"rows_kept":36,"cut":false,"hidden":false,"merged":[[0,2,1,3],[1,4,1,8]]}
[null,null,{"$f":"YEAR($E$1)","v":2021},null,{"$f":"'10월'!$E$1+'10월'!$D$3","v":"2021-11-05"},null,{"$f":"DAY($E$1)","v":5}]
[null,null,null,null,"출퇴근 기록부"]
[null,null,{"$f":"MONTH($E$1)","v":11},{"$f":"DAY(DATE(YEAR(E1),MONTH(E1)+1,1)-1)","v":"1900-01-30"},"근무일수","근무일수",{"$f":"E36","v":"00:00:00"},{"$f":"G36","v":0},"급여",{"$f":"I36","v":0}]
["날짜끄러오기","변환","날짜","출근시간","퇴근시간","근무수식","근무시간","시금","일급","비고",null,{"$f":"MONTH(E1)+1","v":12},{"$f":"DATE($C$1,$L$4,N4)","v":"2021-12-01"},1,{"$f":"DAY(DATE(YEAR(M4),MONTH(M4)+1,1)-1)","v":"1900-01-31"}]
[{"$f":"(YEAR($E$1)&\"/\"&MONTH($E$1)&\"/\"&DAY($E$1))+N4-$N$4","v":"2021-11-05"},{"$f":"TEXT(A5,\"d\")","v":"5"},{"$f":"DATE($C$1,C3,B5)","v":"2021-11-05"},null,null,{"$f":"IF(D5<E5,(E5-D5)*1440,IF(E5=\"\",0,IF(D5>E5,(1+E5-D5)*1440)))/60","v":0},{"$f":"IF(E5=\"\",\"\",F5)","v":""},{"$f":"'1월'!H5","v":8720},{"$f":"IF(G5=\"\",\"\",G5*$H$5)","v":""},null,null,null,{"$f":"DATE($C$1,$L$4,N5)","v":"2021-12-02"},2]
[{"$f":"(YEAR($E$1)&\"/\"&MONTH($E$1)&\"/\"&DAY($E$1))+N5-$N$4","v":"2021-11-06"},"6",{"$f":"IF(C5=\"\",\"\",IF($B$5=B6,\"\",IF(DAY($B$5)<=DAY(B6),DATE($C$1,$C$3,B6),DATE($C$1,$C$3+1,B6))))","v":"2021-11-06"},null,null,{"$f":"IF(D6<E6,(E6-D6)*1440,IF(E6=\"\",0,IF(D6>E6,(1+E6-D6)*1440)))/60","v":0},{"$f":"IF(E6=\"\",\"\",F6)","v":""},null,{"$f":"IF(G6=\"\",\"\",G6*$H$5)","v":""},null,null,null,{"$f":"DATE($C$1,$L$4,N6)","v":"2021-12-03"},3]
[{"$f":"(YEAR($E$1)&\"/\"&MONTH($E$1)&\"/\"&DAY($E$1))+N6-$N$4","v":"2021-11-07"},"7",{"$f":"IF(C6=\"\",\"\",IF($B$5=B7,\"\",IF(DAY($B$5)<=DAY(B7),DATE($C$1,$C$3,B7),DATE($C$1,$C$3+1,B7))))","v":"2021-11-07"},null,null,{"$f":"IF(D7<E7,(E7-D7)*1440,IF(E7=\"\",0,IF(D7>E7,(1+E7-D7)*1440)))/60","v":0},"",null,{"$f":"IF(G7=\"\",\"\",G7*$H$5)","v":""},null,null,null,"2021-12-04",4]
["2021-11-08","8","2021-11-08",null,null,{"$f":"IF(D8<E8,(E8-D8)*1440,IF(E8=\"\",0,IF(D8>E8,(1+E8-D8)*1440)))/60","v":0},"",null,"",null,null,null,"2021-12-05",5]
["2021-11-09","9","2021-11-09",null,null,{"$f":"IF(D9<E9,(E9-D9)*1440,IF(E9=\"\",0,IF(D9>E9,(1+E9-D9)*1440)))/60","v":0},"",null,"",null,null,null,"2021-12-06",6]
["2021-11-10","10","2021-11-10",null,null,{"$f":"IF(D10<E10,(E10-D10)*1440,IF(E10=\"\",0,IF(D10>E10,(1+E10-D10)*1440)))/60","v":0},{"$f":"IF(E10=\"\",\"\",F10)","v":""},null,"",null,null,null,"2021-12-07",7]
["2021-11-11","11","2021-11-11",null,null,0,"",null,"",null,null,null,"2021-12-08",8]
["2021-11-12","12","2021-11-12",null,null,0,"",null,"",null,null,null,"2021-12-09",9]
["2021-11-13","13","2021-11-13",null,null,0,"",null,"",null,null,null,"2021-12-10",10]
["2021-11-14","14","2021-11-14",null,null,{"$f":"IF(D14<E14,(E14-D14)*1440,IF(E14=\"\",0,IF(D14>E14,(1+E14-D14)*1440)))/60","v":0},{"$f":"IF(E14=\"\",\"\",F14)","v":""},null,"",null,null,null,"2021-12-11",11]
["2021-11-15","15","2021-11-15",null,null,{"$f":"IF(D15<E15,(E15-D15)*1440,IF(E15=\"\",0,IF(D15>E15,(1+E15-D15)*1440)))/60","v":0},{"$f":"IF(E15=\"\",\"\",F15)","v":""},null,"",null,null,null,"2021-12-12",12]
["2021-11-16","16","2021-11-16",null,null,{"$f":"IF(D16<E16,(E16-D16)*1440,IF(E16=\"\",0,IF(D16>E16,(1+E16-D16)*1440)))/60","v":0},"",null,"",null,null,null,"2021-12-13",13]
["2021-11-17","17","2021-11-17",null,null,0,"",null,"",null,null,null,"2021-12-14",14]
["2021-11-18","18","2021-11-18",null,null,0,"",null,"",null,null,null,"2021-12-15",15]
["2021-11-19","19","2021-11-19",null,null,0,"",null,"",null,null,null,"2021-12-16",16]
["2021-11-20","20","2021-11-20",null,null,0,"",null,"",null,null,null,"2021-12-17",17]
["2021-11-21","21","2021-11-21",null,null,0,"",null,"",null,null,null,"2021-12-18",18]
["2021-11-22","22","2021-11-22",null,null,0,"",null,"",null,null,null,"2021-12-19",19]
["2021-11-23","23","2021-11-23",null,null,0,"",null,"",null,null,null,"2021-12-20",20]
["2021-11-24","24","2021-11-24",null,null,0,"",null,"",null,null,null,"2021-12-21",21]
["2021-11-25","25","2021-11-25",null,null,0,"",null,"",null,null,null,"2021-12-22",22]
["2021-11-26","26","2021-11-26",null,null,0,"",null,"",null,null,null,"2021-12-23",23]
["2021-11-27","27","2021-11-27",null,null,0,"",null,"",null,null,null,"2021-12-24",24]
["2021-11-28","28","2021-11-28",null,null,0,"",null,"",null,null,null,"2021-12-25",25]
["2021-11-29","29","2021-11-29",null,null,0,"",null,"",null,null,null,"2021-12-26",26]
["2021-11-30","30","2021-11-30",null,null,0,"",null,"",null,null,null,"2021-12-27",27]
["2021-12-01","1","2021-12-01",null,null,0,"",null,"",null,null,null,"2021-12-28",28]
["2021-12-02","2","2021-12-02",null,null,0,"",null,"",null,null,null,"2021-12-29",29]
["2021-12-03","3","2021-12-03",null,null,0,"",null,"",null,null,null,"2021-12-30",30]
["2021-12-04","4","2021-12-04",null,null,0,"",null,"",null,null,null,"2021-12-31",31]
["2021-12-05","5","",null,null,0,"",null,""]
[null,null,"합계",null,{"$f":"COUNT(E5:E35)","v":"00:00:00"},{"$f":"SUM(F5:F35)","v":0},{"$f":"SUM(G5:G35)","v":0},null,{"$f":"SUM(I5:I35)","v":0}]

{"sheet":"12월","index":11,"n_rows":36,"n_cols":15,"rows_kept":36,"cut":false,"hidden":false,"merged":[[0,2,1,3],[1,4,1,8]]}
[null,null,{"$f":"YEAR($E$1)","v":2021},null,{"$f":"'11월'!$E$1+'11월'!$D$3","v":"2021-12-05"},null,{"$f":"DAY($E$1)","v":5}]
[null,null,null,null,"출퇴근 기록부"]
[null,null,{"$f":"MONTH($E$1)","v":12},{"$f":"DAY(DATE(YEAR(E1),MONTH(E1)+1,1)-1)","v":"1900-01-31"},"근무일수","근무일수",{"$f":"E36","v":"00:00:00"},{"$f":"G36","v":0},"급여",{"$f":"I36","v":0},null,null,{"$f":"C1+1","v":2022}]
["날짜끄러오기","변환","날짜","출근시간","퇴근시간","근무수식","근무시간","시금","일급","비고",null,{"$f":"13-MONTH(E1)","v":1},{"$f":"DATE($M$3,$L$4,N4)","v":"2022-01-01"},1,{"$f":"DAY(DATE(YEAR(M4),MONTH(M4)+1,1)-1)","v":"1900-01-31"}]
[{"$f":"(YEAR($E$1)&\"/\"&MONTH($E$1)&\"/\"&DAY($E$1))+N4-$N$4","v":"2021-12-05"},{"$f":"TEXT(A5,\"d\")","v":"5"},{"$f":"DATE($C$1,C3,B5)","v":"2021-12-05"},null,null,{"$f":"IF(D5<E5,(E5-D5)*1440,IF(E5=\"\",0,IF(D5>E5,(1+E5-D5)*1440)))/60","v":0},{"$f":"IF(E5=\"\",\"\",F5)","v":""},{"$f":"'1월'!H5","v":8720},{"$f":"IF(G5=\"\",\"\",G5*$H$5)","v":""},null,null,null,{"$f":"DATE($M$3,$L$4,N5)","v":"2022-01-02"},2]
[{"$f":"(YEAR($E$1)&\"/\"&MONTH($E$1)&\"/\"&DAY($E$1))+N5-$N$4","v":"2021-12-06"},"6",{"$f":"IF(C5=\"\",\"\",IF($B$5=B6,\"\",IF(DAY($B$5)<=DAY(B6),DATE($C$1,$C$3,B6),DATE($C$1,$C$3+1,B6))))","v":"2021-12-06"},null,null,{"$f":"IF(D6<E6,(E6-D6)*1440,IF(E6=\"\",0,IF(D6>E6,(1+E6-D6)*1440)))/60","v":0},{"$f":"IF(E6=\"\",\"\",F6)","v":""},null,{"$f":"IF(G6=\"\",\"\",G6*$H$5)","v":""},null,null,null,{"$f":"DATE($M$3,$L$4,N6)","v":"2022-01-03"},3]
[{"$f":"(YEAR($E$1)&\"/\"&MONTH($E$1)&\"/\"&DAY($E$1))+N6-$N$4","v":"2021-12-07"},"7",{"$f":"IF(C6=\"\",\"\",IF($B$5=B7,\"\",IF(DAY($B$5)<=DAY(B7),DATE($C$1,$C$3,B7),DATE($C$1,$C$3+1,B7))))","v":"2021-12-07"},null,null,{"$f":"IF(D7<E7,(E7-D7)*1440,IF(E7=\"\",0,IF(D7>E7,(1+E7-D7)*1440)))/60","v":0},"",null,{"$f":"IF(G7=\"\",\"\",G7*$H$5)","v":""},null,null,null,"2022-01-04",4]
["2021-12-08","8","2021-12-08",null,null,{"$f":"IF(D8<E8,(E8-D8)*1440,IF(E8=\"\",0,IF(D8>E8,(1+E8-D8)*1440)))/60","v":0},"",null,"",null,null,null,"2022-01-05",5]
["2021-12-09","9","2021-12-09",null,null,{"$f":"IF(D9<E9,(E9-D9)*1440,IF(E9=\"\",0,IF(D9>E9,(1+E9-D9)*1440)))/60","v":0},"",null,"",null,null,null,"2022-01-06",6]
["2021-12-10","10","2021-12-10",null,null,{"$f":"IF(D10<E10,(E10-D10)*1440,IF(E10=\"\",0,IF(D10>E10,(1+E10-D10)*1440)))/60","v":0},{"$f":"IF(E10=\"\",\"\",F10)","v":""},null,"",null,null,null,"2022-01-07",7]
["2021-12-11","11","2021-12-11",null,null,0,"",null,"",null,null,null,"2022-01-08",8]
["2021-12-12","12","2021-12-12",null,null,0,"",null,"",null,null,null,"2022-01-09",9]
["2021-12-13","13","2021-12-13",null,null,0,"",null,"",null,null,null,"2022-01-10",10]
["2021-12-14","14","2021-12-14",null,null,{"$f":"IF(D14<E14,(E14-D14)*1440,IF(E14=\"\",0,IF(D14>E14,(1+E14-D14)*1440)))/60","v":0},{"$f":"IF(E14=\"\",\"\",F14)","v":""},null,"",null,null,null,"2022-01-11",11]
["2021-12-15","15","2021-12-15",null,null,{"$f":"IF(D15<E15,(E15-D15)*1440,IF(E15=\"\",0,IF(D15>E15,(1+E15-D15)*1440)))/60","v":0},{"$f":"IF(E15=\"\",\"\",F15)","v":""},null,"",null,null,null,"2022-01-12",12]
["2021-12-16","16","2021-12-16",null,null,{"$f":"IF(D16<E16,(E16-D16)*1440,IF(E16=\"\",0,IF(D16>E16,(1+E16-D16)*1440)))/60","v":0},"",null,"",null,null,null,"2022-01-13",13]
["2021-12-17","17","2021-12-17",null,null,0,"",null,"",null,null,null,"2022-01-14",14]
["2021-12-18","18","2021-12-18",null,null,0,"",null,"",null,null,null,"2022-01-15",15]
["2021-12-19","19","2021-12-19",null,null,0,"",null,"",null,null,null,"2022-01-16",16]
["2021-12-20","20","2021-12-20",null,null,0,"",null,"",null,null,null,"2022-01-17",17]
["2021-12-21","21","2021-12-21",null,null,0,"",null,"",null,null,null,"2022-01-18",18]
["2021-12-22","22","2021-12-22",null,null,0,"",null,"",null,null,null,"2022-01-19",19]
["2021-12-23","23","2021-12-23",null,null,0,"",null,"",null,null,null,"2022-01-20",20]
["2021-12-24","24","2021-12-24",null,null,0,"",null,"",null,null,null,"2022-01-21",21]
["2021-12-25","25","2021-12-25",null,null,0,"",null,"",null,null,null,"2022-01-22",22]
["2021-12-26","26","2021-12-26",null,null,0,"",null,"",null,null,null,"2022-01-23",23]
["2021-12-27","27","2021-12-27",null,null,0,"",null,"",null,null,null,"2022-01-24",24]
["2021-12-28","28","2021-12-28",null,null,0,"",null,"",null,null,null,"2022-01-25",25]
["2021-12-29","29","2021-12-29",null,null,0,"",null,"",null,null,null,"2022-01-26",26]
["2021-12-30","30","2021-12-30",null,null,0,"",null,"",null,null,null,"2022-01-27",27]
["2021-12-31","31","2021-12-31",null,null,0,"",null,"",null,null,null,"2022-01-28",28]
["2022-01-01","1","2022-01-01",null,null,0,"",null,"",null,null,null,"2022-01-29",29]
["2022-01-02","2","2022-01-02",null,null,0,"",null,"",null,null,null,"2022-01-30",30]
["2022-01-03","3","2022-01-03",null,null,0,"",null,"",null,null,null,"2022-01-31",31]
["2022-01-04","4","2022-01-04",null,null,0,"",null,""]
[null,null,"합계",null,{"$f":"COUNT(E5:E35)","v":"00:00:00"},{"$f":"SUM(F5:F35)","v":0},{"$f":"SUM(G5:G35)","v":0},null,{"$f":"SUM(I5:I35)","v":0}]