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

{"sheet":"근무 시간 기록표","index":0,"n_rows":22,"n_cols":8,"rows_kept":22,"merged":[[0,1,0,7],[1,2,1,3],[1,6,1,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],[15,1,15,2],[16,1,16,2],[17,1,17,2],[18,3,18,6],[20,3,20,6]]}
[null,"근무 시간 기록표"]
[null,"직원",{"$nulls":3},"관리자:"]
[null,"나머지 주소",{"$nulls":3},"직원 전화 번호:"]
[null,"[주소 2]",{"$nulls":3},"직원 전자 메일:"]
[null,"시/도, 우편 번호"]
[null,"주 종료 날짜:",{"$f":"TODAY()","v":"2019-04-30"}]
[]
[null,"요일","날짜","정규 근무 시간","초과 근무 시간 ","병가","휴가","요약"]
[null,{"$f":"IFERROR(TEXT(근무시간기록표[[#This Row],[날짜]],\"aaaa\"), \"\")","v":"수요일"},{"$f":"IFERROR(IF($C$6=0,\"\",$C$6-6), \"\")","v":"2019-04-24"},{"$nulls":4},{"$f":"IFERROR(IF(SUM(D9:G9)>24,\"요약 > 24 시간.\",SUM(D9:G9)), \"\")","v":{"v":0,"d":"0.00"}}]
[null,{"$f":"IFERROR(TEXT(근무시간기록표[[#This Row],[날짜]],\"aaaa\"), \"\")","v":"목요일"},{"$f":"IFERROR(IF($C$6=0,\"\",$C$6-5), \"\")","v":"2019-04-25"},{"$nulls":4},{"$f":"IFERROR(IF(SUM(D10:G10)>24,\"요약 > 24 시간.\",SUM(D10:G10)), \"\")","v":{"v":0,"d":"0.00"}}]
[null,{"$f":"IFERROR(TEXT(근무시간기록표[[#This Row],[날짜]],\"aaaa\"), \"\")","v":"금요일"},{"$f":"IFERROR(IF($C$6=0,\"\",$C$6-4), \"\")","v":"2019-04-26"},{"$nulls":4},{"v":0,"d":"0.00"}]
[null,{"$f":"IFERROR(TEXT(근무시간기록표[[#This Row],[날짜]],\"aaaa\"), \"\")","v":"토요일"},{"$f":"IFERROR(IF($C$6=0,\"\",$C$6-3), \"\")","v":"2019-04-27"},{"$nulls":4},{"v":0,"d":"0.00"}]
[null,{"$f":"IFERROR(TEXT(근무시간기록표[[#This Row],[날짜]],\"aaaa\"), \"\")","v":"일요일"},{"$f":"IFERROR(IF($C$6=0,\"\",$C$6-2), \"\")","v":"2019-04-28"},{"$nulls":4},{"v":0,"d":"0.00"}]
[null,{"$f":"IFERROR(TEXT(근무시간기록표[[#This Row],[날짜]],\"aaaa\"), \"\")","v":"월요일"},{"$f":"IFERROR(IF($C$6=0,\"\",$C$6-1), \"\")","v":"2019-04-29"},{"$nulls":4},{"v":0,"d":"0.00"}]
[null,{"$f":"IFERROR(TEXT(근무시간기록표[[#This Row],[날짜]],\"aaaa\"), \"\")","v":"화요일"},{"$f":"IFERROR(IF($C$6=0,\"\",$C$6), \"\")","v":"2019-04-30"},{"$nulls":4},{"v":0,"d":"0.00"}]
[null,"시간 합계",null,{"$f":"IFERROR(SUM(D9:D15), \"\")","v":{"v":0,"d":"0.00"}},{"$f":"IFERROR(SUM(E9:E15), \"\")","v":{"v":0,"d":"0.00"}},{"$f":"IFERROR(SUM(F9:F15), \"\")","v":{"v":0,"d":"0.00"}},{"$f":"IFERROR(SUM(G9:G15), \"\")","v":{"v":0,"d":"0.00"}},{"$f":"IFERROR(SUM(H9:H15), \"\")","v":{"v":0,"d":"0.00"}}]
[null,"시간당 급여"]
[null,"급여 합계",null,{"$f":"IFERROR(D16*D17, \"\")","v":0},{"$f":"IFERROR(E16*E17, \"\")","v":0},{"$f":"IFERROR(F16*F17, \"\")","v":0},{"$f":"IFERROR(G16*G17, \"\")","v":0},{"$f":"IFERROR(SUM(D18:G18), \"\")","v":0}]
[]
[{"$nulls":3},"직원 서명",{"$nulls":3},"날짜"]
[]
[{"$nulls":3},"관리자 서명",{"$nulls":3},"날짜"]