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

{"sheet":"주간 근무 시간표","index":0,"n_rows":17,"n_cols":15,"rows_kept":17,"merged":[[0,0,0,14],[1,0,1,8],[3,0,3,2],[3,3,3,8],[3,10,3,12],[3,13,3,14],[4,0,4,2],[4,3,4,8],[4,10,4,12],[4,13,4,14],[6,1,6,2],[6,3,6,4],[6,5,6,6],[6,7,6,8],[6,9,6,10],[6,11,6,12],[6,13,6,14],[7,1,7,2],[7,3,7,4],[7,5,7,6],[7,7,7,8],[7,9,7,10],[7,11,7,12],[7,13,7,14],[10,0,10,14],[13,1,13,2],[13,3,13,4],[13,5,13,6],[13,7,13,8],[13,9,13,10],[13,11,13,12],[13,13,13,14],[14,0,14,12],[14,13,14,14]]}
["회사 이름"]
["[우편 번호, 시/도] [구/군/시] [주소]",{"$nulls":13},"주간 근무 시간표"]
[]
["직원 이름:",{"$nulls":9},"주중 근무 시작일:",null,null,"2006-12-31"]
["관리자 이름:",{"$nulls":9},"주중 근무 종료일:",null,null,{"$f":"IF($N$4=0,\"\",$N$4+6)","v":"2007-01-06"}]
[]
[null,"일요일",null,"월요일",null,"화요일",null,"수요일",null,"목요일",null,"금요일",null,"토요일"]
[null,{"$f":"N4","v":"2006-12-31"},null,{"$f":"IF($N$4=\"\",\"\",$N$4+1)","v":"2007-01-01"},null,{"$f":"IF($N$4=\"\",\"\",$N$4+2)","v":"2007-01-02"},null,{"$f":"IF($N$4=\"\",\"\",$N$4+3)","v":"2007-01-03"},null,{"$f":"IF($N$4=\"\",\"\",$N$4+4)","v":"2007-01-04"},null,{"$f":"IF($N$4=\"\",\"\",$N$4+5)","v":"2007-01-05"},null,{"$f":"IF($N$4=\"\",\"\",$N$4+6)","v":"2007-01-06"}]
["출근 시간",null,"총 시간",null,"총 시간",null,"총 시간",null,"총 시간",null,"총 시간",null,"총 시간",null,"총 시간"]
["퇴근 시간",null,{"$f":"IF((OR(B10=\"\",B9=\"\")),0,IF((B10<B9),((B10-B9)*24)+24,(B10-B9)*24))","v":{"v":0,"d":"0.00"}},null,{"$f":"IF((OR(D10=\"\",D9=\"\")),0,IF((D10<D9),((D10-D9)*24)+24,(D10-D9)*24))","v":{"v":0,"d":"0.00"}},null,{"$f":"IF((OR(F10=\"\",F9=\"\")),0,IF((F10<F9),((F10-F9)*24)+24,(F10-F9)*24))","v":{"v":0,"d":"0.00"}},null,{"$f":"IF((OR(H10=\"\",H9=\"\")),0,IF((H10<H9),((H10-H9)*24)+24,(H10-H9)*24))","v":{"v":0,"d":"0.00"}},null,{"$f":"IF((OR(J10=\"\",J9=\"\")),0,IF((J10<J9),((J10-J9)*24)+24,(J10-J9)*24))","v":{"v":0,"d":"0.00"}},null,{"$f":"IF((OR(L10=\"\",L9=\"\")),0,IF((L10<L9),((L10-L9)*24)+24,(L10-L9)*24))","v":{"v":0,"d":"0.00"}},null,{"$f":"IF((OR(N10=\"\",N9=\"\")),0,IF((N10<N9),((N10-N9)*24)+24,(N10-N9)*24))","v":{"v":0,"d":"0.00"}}]
["점심 시간"]
["출근 시간",null,"총 시간",null,"총 시간",null,"총 시간",null,"총 시간",null,"총 시간",null,"총 시간",null,"총 시간"]
["퇴근 시간",null,{"$f":"IF((OR(B13=\"\",B12=\"\")),0,IF((B13<B12),((B13-B12)*24)+24,(B13-B12)*24))","v":{"v":0,"d":"0.00"}},null,{"$f":"IF((OR(D13=\"\",D12=\"\")),0,IF((D13<D12),((D13-D12)*24)+24,(D13-D12)*24))","v":{"v":0,"d":"0.00"}},null,{"$f":"IF((OR(F13=\"\",F12=\"\")),0,IF((F13<F12),((F13-F12)*24)+24,(F13-F12)*24))","v":{"v":0,"d":"0.00"}},null,{"$f":"IF((OR(H13=\"\",H12=\"\")),0,IF((H13<H12),((H13-H12)*24)+24,(H13-H12)*24))","v":{"v":0,"d":"0.00"}},null,{"$f":"IF((OR(J13=\"\",J12=\"\")),0,IF((J13<J12),((J13-J12)*24)+24,(J13-J12)*24))","v":{"v":0,"d":"0.00"}},null,{"$f":"IF((OR(L13=\"\",L12=\"\")),0,IF((L13<L12),((L13-L12)*24)+24,(L13-L12)*24))","v":{"v":0,"d":"0.00"}},null,{"$f":"IF((OR(N13=\"\",N12=\"\")),0,IF((N13<N12),((N13-N12)*24)+24,(N13-N12)*24))","v":{"v":0,"d":"0.00"}}]
["총 시간",{"$f":"IF(OR(ISTEXT(C10),ISTEXT(C13)),\"C12 또는 C15 셀에 오류가 있습니다.\",(C10+C13))","v":{"v":0,"d":"0.00"}},null,{"$f":"IF(OR(ISTEXT(E10),ISTEXT(E13)),\"C12 또는 C15 셀에 오류가 있습니다.\",(E10+E13))","v":{"v":0,"d":"0.00"}},null,{"$f":"IF(OR(ISTEXT(G10),ISTEXT(G13)),\"C12 또는 C15 셀에 오류가 있습니다.\",(G10+G13))","v":{"v":0,"d":"0.00"}},null,{"$f":"IF(OR(ISTEXT(I10),ISTEXT(I13)),\"C12 또는 C15 셀에 오류가 있습니다.\",(I10+I13))","v":{"v":0,"d":"0.00"}},null,{"$f":"IF(OR(ISTEXT(K10),ISTEXT(K13)),\"C12 또는 C15 셀에 오류가 있습니다.\",(K10+K13))","v":{"v":0,"d":"0.00"}},null,{"$f":"IF(OR(ISTEXT(M10),ISTEXT(M13)),\"C12 또는 C15 셀에 오류가 있습니다.\",(M10+M13))","v":{"v":0,"d":"0.00"}},null,{"$f":"IF(OR(ISTEXT(O10),ISTEXT(O13)),\"C12 또는 C15 셀에 오류가 있습니다.\",(O10+O13))","v":{"v":0,"d":"0.00"}}]
["주간 총 근무 시간",{"$nulls":12},{"$f":"SUM(B14:O14)","v":{"v":0,"d":"0.00"}}]
[]
["직원 서명",{"$nulls":3},"날짜",null,null,"관리자 서명",{"$nulls":5},"날짜"]