{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["2주간 근무 시간 기록표"],"not_rendered":{"defined_names":9},"read":"whole","date_system":"1900"}

{"sheet":"2주간 근무 시간 기록표","index":0,"n_rows":31,"n_cols":8,"rows_kept":31,"merged":[[0,1,0,7],[2,2,2,3],[2,6,2,7],[3,2,3,3],[3,6,3,7],[4,2,4,3],[5,2,5,3],[5,6,5,7],[6,2,6,3],[6,6,6,7],[27,3,27,6],[28,3,28,6],[29,3,29,6],[30,3,30,6]]}
[null,"2주간 근무 시간 기록표"]
[null,"회사 이름"]
[null,"나머지 주소",{"$nulls":3},"급여 기간 시작 날짜:",{"$f":"TODAY()","v":"2022-01-21"}]
[null,"[주소 2]",{"$nulls":3},"급여 기간 종료 날짜:",{"$f":"IFERROR(IF($G$3=\"\",\"\",$G$3+13), \"\")","v":"2022-02-03"}]
[null,"시/도, 우편 번호"]
[null,"직원:",{"$nulls":3},"직원 전화 번호:"]
[null,"관리자:",{"$nulls":3},"직원 전자 메일:"]
[]
[null,"요일","날짜","규정 근무 시간","초과 근무 시간","병가","휴가","요약"]
[null,{"$f":"IFERROR(TEXT(근무시간기록표[[#This Row],[날짜]],\"aaaa\"), \"\")","v":"Friday"},{"$f":"G3","v":"2022-01-21"},{"$nulls":4},{"$f":"IFERROR(SUM(D10:G10), \"\")","v":{"v":0,"d":"0.00"}}]
[null,{"$f":"IFERROR(TEXT(근무시간기록표[[#This Row],[날짜]],\"aaaa\"), \"\")","v":"Saturday"},{"$f":"IF($G$3=\"\",\"\",$G$3+1)","v":"2022-01-22"},{"$nulls":4},{"$f":"IFERROR(SUM(D11:G11), \"\")","v":{"v":0,"d":"0.00"}}]
[null,{"$f":"IFERROR(TEXT(근무시간기록표[[#This Row],[날짜]],\"aaaa\"), \"\")","v":"Sunday"},{"$f":"IF($G$3=\"\",\"\",$G$3+2)","v":"2022-01-23"},{"$nulls":4},{"$f":"IFERROR(SUM(D12:G12), \"\")","v":{"v":0,"d":"0.00"}}]
[null,{"$f":"IFERROR(TEXT(근무시간기록표[[#This Row],[날짜]],\"aaaa\"), \"\")","v":"Monday"},{"$f":"IF($G$3=\"\",\"\",$G$3+3)","v":"2022-01-24"},{"$nulls":4},{"$f":"IFERROR(SUM(D13:G13), \"\")","v":{"v":0,"d":"0.00"}}]
[null,{"$f":"IFERROR(TEXT(근무시간기록표[[#This Row],[날짜]],\"aaaa\"), \"\")","v":"Tuesday"},{"$f":"IF($G$3=\"\",\"\",$G$3+4)","v":"2022-01-25"},{"$nulls":4},{"$f":"IFERROR(SUM(D14:G14), \"\")","v":{"v":0,"d":"0.00"}}]
[null,{"$f":"IFERROR(TEXT(근무시간기록표[[#This Row],[날짜]],\"aaaa\"), \"\")","v":"Wednesday"},{"$f":"IF($G$3=\"\",\"\",$G$3+5)","v":"2022-01-26"},{"$nulls":4},{"$f":"IFERROR(SUM(D15:G15), \"\")","v":{"v":0,"d":"0.00"}}]
[null,{"$f":"IFERROR(TEXT(근무시간기록표[[#This Row],[날짜]],\"aaaa\"), \"\")","v":"Thursday"},{"$f":"IF($G$3=\"\",\"\",$G$3+6)","v":"2022-01-27"},{"$nulls":4},{"v":0,"d":"0.00"}]
[null,{"$f":"IFERROR(TEXT(근무시간기록표[[#This Row],[날짜]],\"aaaa\"), \"\")","v":"Friday"},{"$f":"IF($G$3=\"\",\"\",$G$3+7)","v":"2022-01-28"},{"$nulls":4},{"v":0,"d":"0.00"}]
[null,{"$f":"IFERROR(TEXT(근무시간기록표[[#This Row],[날짜]],\"aaaa\"), \"\")","v":"Saturday"},{"$f":"IF($G$3=\"\",\"\",$G$3+8)","v":"2022-01-29"},{"$nulls":4},{"v":0,"d":"0.00"}]
[null,{"$f":"IFERROR(TEXT(근무시간기록표[[#This Row],[날짜]],\"aaaa\"), \"\")","v":"Sunday"},{"$f":"IF($G$3=\"\",\"\",$G$3+9)","v":"2022-01-30"},{"$nulls":4},{"v":0,"d":"0.00"}]
[null,{"$f":"IFERROR(TEXT(근무시간기록표[[#This Row],[날짜]],\"aaaa\"), \"\")","v":"Monday"},{"$f":"IF($G$3=\"\",\"\",$G$3+10)","v":"2022-01-31"},{"$nulls":4},{"v":0,"d":"0.00"}]
[null,{"$f":"IFERROR(TEXT(근무시간기록표[[#This Row],[날짜]],\"aaaa\"), \"\")","v":"Tuesday"},{"$f":"IF($G$3=\"\",\"\",$G$3+11)","v":"2022-02-01"},{"$nulls":4},{"v":0,"d":"0.00"}]
[null,{"$f":"IFERROR(TEXT(근무시간기록표[[#This Row],[날짜]],\"aaaa\"), \"\")","v":"Wednesday"},{"$f":"IF($G$3=\"\",\"\",$G$3+12)","v":"2022-02-02"},{"$nulls":4},{"v":0,"d":"0.00"}]
[null,{"$f":"IFERROR(TEXT(근무시간기록표[[#This Row],[날짜]],\"aaaa\"), \"\")","v":"Thursday"},{"$f":"IF($G$3=\"\",\"\",$G$3+13)","v":"2022-02-03"},{"$nulls":4},{"v":0,"d":"0.00"}]
[null,null,"시간 합계",{"$f":"IFERROR(SUM(D10:D23), \"\")","v":{"v":0,"d":"0.00"}},{"$f":"IFERROR(SUM(E10:E23), \"\")","v":{"v":0,"d":"0.00"}},{"$f":"IFERROR(SUM(F10:F23), \"\")","v":{"v":0,"d":"0.00"}},{"$f":"IFERROR(SUM(G10:G23), \"\")","v":{"v":0,"d":"0.00"}},{"$f":"IFERROR(SUM(H10:H23), \"\")","v":{"v":0,"d":"0.00"}}]
[null,null,"시간당 급여"]
[null,null,"급여 합계",{"$f":"IFERROR(D24*D25, \"\")","v":{"v":0,"d":"₩0"}},{"$f":"IFERROR(E24*E25, \"\")","v":{"v":0,"d":"₩0"}},{"$f":"IFERROR(F24*F25, \"\")","v":{"v":0,"d":"₩0"}},{"$f":"IFERROR(G24*G25, \"\")","v":{"v":0,"d":"₩0"}},{"$f":"IFERROR(SUM(D26:G26), \"\")","v":{"v":0,"d":"₩0"}}]
[]
[]
[{"$nulls":3},"직원 서명",{"$nulls":3},"날짜"]
[]
[{"$nulls":3},"관리자 서명",{"$nulls":3},"날짜"]