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

{"sheet":"2주간 근무 시간 기록표","index":0,"n_rows":28,"n_cols":8,"rows_kept":28,"merged":[[0,1,0,5],[1,1,1,5],[1,6,1,7],[2,1,2,2],[2,3,2,4],[2,6,2,7],[3,1,3,2],[3,3,3,4],[4,1,4,2],[4,3,4,4],[25,1,25,4],[26,1,26,4],[27,1,27,4]]}
[null,"회사 이름"]
[null,"나머지 주소, 주소 2, 시/도, 우편 번호",{"$nulls":4},"주간 근무 시간 기록표(휴가 포함)"]
[null,"직원:",{"$nulls":3},"직원 전화 번호:"]
[null,"직원 전자 메일:",{"$nulls":3},"급여 기간 시작 날짜:",null,{"$f":"TODAY()","v":"2022-05-25"}]
[null,"관리자:",{"$nulls":3},"급여 기간 종료 날짜:",null,{"$f":"IF($H$4=\"\",\"\",$H$4+13)","v":"2022-06-07"}]
[]
[null,"요일","날짜","정규 근무 시간","초과 근무 시간","병가","휴가 시간","요약"]
[null,{"$f":"IFERROR(TEXT(작업표[[#This Row],[날짜]],\"aaaa\"), \"\")","v":"수요일"},{"$f":"H4","v":"2022-05-25"},{"v":8,"d":"8.00"},{"$nulls":3},{"$f":"IFERROR(SUM(D8:G8), \"\")","v":{"v":8,"d":"8.00"}}]
[null,{"$f":"IFERROR(TEXT(작업표[[#This Row],[날짜]],\"aaaa\"), \"\")","v":"목요일"},{"$f":"IF($H$4=\"\",\"\",$H$4+1)","v":"2022-05-26"},{"v":8,"d":"8.00"},{"v":2,"d":"2.00"},null,null,{"$f":"IFERROR(SUM(D9:G9), \"\")","v":{"v":10,"d":"10.00"}}]
[null,{"$f":"IFERROR(TEXT(작업표[[#This Row],[날짜]],\"aaaa\"), \"\")","v":"금요일"},{"$f":"IF($H$4=\"\",\"\",$H$4+2)","v":"2022-05-27"},null,null,{"v":8,"d":"8.00"},null,{"v":8,"d":"8.00"}]
[null,{"$f":"IFERROR(TEXT(작업표[[#This Row],[날짜]],\"aaaa\"), \"\")","v":"토요일"},{"$f":"IF($H$4=\"\",\"\",$H$4+3)","v":"2022-05-28"},{"$nulls":3},{"v":8,"d":"8.00"},{"v":8,"d":"8.00"}]
[null,{"$f":"IFERROR(TEXT(작업표[[#This Row],[날짜]],\"aaaa\"), \"\")","v":"일요일"},{"$f":"IF($H$4=\"\",\"\",$H$4+4)","v":"2022-05-29"},{"$nulls":4},0]
[null,{"$f":"IFERROR(TEXT(작업표[[#This Row],[날짜]],\"aaaa\"), \"\")","v":"월요일"},{"$f":"IF($H$4=\"\",\"\",$H$4+5)","v":"2022-05-30"},{"$nulls":4},0]
[null,{"$f":"IFERROR(TEXT(작업표[[#This Row],[날짜]],\"aaaa\"), \"\")","v":"화요일"},{"$f":"IF($H$4=\"\",\"\",$H$4+6)","v":"2022-05-31"},{"$nulls":4},0]
[null,{"$f":"IFERROR(TEXT(작업표[[#This Row],[날짜]],\"aaaa\"), \"\")","v":"수요일"},{"$f":"IF($H$4=\"\",\"\",$H$4+7)","v":"2022-06-01"},{"$nulls":4},0]
[null,{"$f":"IFERROR(TEXT(작업표[[#This Row],[날짜]],\"aaaa\"), \"\")","v":"목요일"},{"$f":"IF($H$4=\"\",\"\",$H$4+8)","v":"2022-06-02"},{"$nulls":4},0]
[null,{"$f":"IFERROR(TEXT(작업표[[#This Row],[날짜]],\"aaaa\"), \"\")","v":"금요일"},{"$f":"IF($H$4=\"\",\"\",$H$4+9)","v":"2022-06-03"},{"$nulls":4},0]
[null,{"$f":"IFERROR(TEXT(작업표[[#This Row],[날짜]],\"aaaa\"), \"\")","v":"토요일"},{"$f":"IF($H$4=\"\",\"\",$H$4+10)","v":"2022-06-04"},{"$nulls":4},0]
[null,{"$f":"IFERROR(TEXT(작업표[[#This Row],[날짜]],\"aaaa\"), \"\")","v":"일요일"},{"$f":"IF($H$4=\"\",\"\",$H$4+11)","v":"2022-06-05"},{"$nulls":4},0]
[null,{"$f":"IFERROR(TEXT(작업표[[#This Row],[날짜]],\"aaaa\"), \"\")","v":"월요일"},{"$f":"IF($H$4=\"\",\"\",$H$4+12)","v":"2022-06-06"},{"$nulls":4},0]
[null,{"$f":"IFERROR(TEXT(작업표[[#This Row],[날짜]],\"aaaa\"), \"\")","v":"화요일"},{"$f":"IF($H$4=\"\",\"\",$H$4+13)","v":"2022-06-07"},{"$nulls":4},0]
[null,null,"요약",{"$f":"SUBTOTAL(109,작업표[정규 근무 시간])","v":{"v":16,"d":"16.00"}},{"$f":"SUBTOTAL(109,작업표[초과 근무 시간])","v":{"v":2,"d":"2.00"}},{"$f":"SUBTOTAL(109,작업표[병가])","v":{"v":8,"d":"8.00"}},{"$f":"SUBTOTAL(109,작업표[휴가 시간])","v":{"v":8,"d":"8.00"}},{"$f":"SUBTOTAL(109,작업표[요약])","v":{"v":34,"d":"34.00"}}]
[null,null,"시간당 급여",{"v":10,"d":"₩10.00"},{"v":15,"d":"₩15.00"},{"v":10,"d":"₩10.00"},{"v":10,"d":"₩10.00"}]
[null,null,"급여 합계",{"$f":"IFERROR(SUM(D23*작업표[[#Totals],[정규 근무 시간]]), \"\")","v":{"v":160,"d":"₩160.00"}},{"$f":"IFERROR(SUM(E23*작업표[[#Totals],[초과 근무 시간]]), \"\")","v":{"v":30,"d":"₩30.00"}},{"$f":"IFERROR(SUM(F23*작업표[[#Totals],[병가]]), \"\")","v":{"v":80,"d":"₩80.00"}},{"$f":"IFERROR(SUM(G23*작업표[[#Totals],[휴가 시간]]), \"\")","v":{"v":80,"d":"₩80.00"}},{"$f":"IFERROR(SUM(D24:G24), \"\")","v":{"v":350,"d":"₩350.00"}}]
[]
[null,"직원 서명",{"$nulls":4},"날짜"]
[]
[null,"관리자 서명",{"$nulls":4},"날짜"]