{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["접수창","접수대장","Sheet1","Sheet2","경력증명서","경력증명서-2","경력증명서 (FAX)","경력증명서 (FAX)-2","수정사항"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":0,"defined_names":22,"comments":6,"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":"접수창","index":0,"n_rows":49,"n_cols":2,"rows_kept":49,"cut":false,"hidden":false,"merged":[[48,1,49,10],[35,1,36,10],[22,1,23,10],[8,1,9,10]]}
[]
[]
[]
[]
[]
[]
[]
[]
[null,"자료 입력하기"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"자료 검색하기 (한글성명 활용)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"자료 수정하기 (→를 통해 목록을 보고 수정하여 저장)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"자료 출력하기 (출력을 누르고 일반/팩스민원용 선택)"]

{"sheet":"접수대장","index":1,"n_rows":3,"n_cols":102,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["입력일자","등록번호","국문 성명","한자 성명","주민등록번호","주소지","퇴직사유","1.부 터","1.까 지","1.직 급","1.직 위","1.근무 부서","2.부 터","2.까 지","2.직 급","2.최종 직위","2.근무 부서","3.부 터","3.까 지","3.직 급","3.최종 직위","3.근무 부서","4.부 터","4.까 지","4.직 급","4.최종 직위","4.근무 부서","5.부 터","5.까 지","5.직 급","5.최종 직위","5.근무 부서","6.부 터","6.까 지","6.직 급","6.최종 직위","6.근무 부서","7.부 터","7.까 지","7.직 급","7.최종 직위","7.근무 부서","8.부 터","8.까 지","8.직 급","8.최종 직위","8.근무 부서","9.부 터","9.까 지","9.직 급","9.최종 직위","9.근무 부서","1.포상연월일","1.포상종류","1.포상시행청","2.포상연월일","2.포상종류","2.포상시행청","3.포상연월일","3.포상종류","3.포상시행청","4.포상연월일","4.포상종류","4.포상시행청","1.징계연월일","1.징계종류","1.징계시행청","2.징계연월일","2.징계종류","2.징계시행청","3.징계연월일","3.징계종류","3.징계시행청","4.징계연월일","4.징계종류","4.징계시행청","1.직위해제연월일","1.직위해제사유","1.직위해제처분청","2.직위해제연월일","2.직위해제사유","2.직위해제처분청","총경력","직급","1경력","2경력","3경력","4경력","5경력","6경력","7경력","8경력","9경력","1과목","2과목","3과목","4과목","5과목","6과목","7과목","8과목","9과목"]
["2011-01-11 오전 9:58:49",1,"홍길동","洪길동","840101-1111111","서울 영등포구 여의도동  국회","재직중","2011-01-01","2011-01-31","직급1","직위1","부서1","2011-02-01","2011-02-28","직급2","직위2","부서2","2011-03-01","2011-03-31","직급3","직위3","부서3","2011-04-01","2011-04-30","직급4","직위4","부서4","2011-05-01","2011-05-31","직급5","직위5","부서5","2011-06-01","2011-06-30","직급6","직위6","부서6","2011-07-01","2011-07-31","직급7","직위7","부서7","2011-08-01","2011-08-31","직급8","직위8","부서8","2011-09-01","2011-10-11","직급9","직위9","부서9","2011-01-01","종류1","시행청1","2011-02-01","종류2","시행청2","2011-03-01","종류3","시행청3","2011-04-01","종류4","시행청4","2011-05-01","종류1","시행청1","2011-06-01","종류2","시행청2","2011-07-01","종류3","시행청3","2011-08-01","종류4","시행청4","2011-09-01","사유1","처분청1","2011-10-01","사유2","처분청2","  ",""," 년 개월 일"," 년 개월 일"," 년 개월 일"," 년 개월 일"," 년 개월 일"," 년 개월 일"," 년 개월 일"," 년 개월 일"," 년 개월 일","국어","영어","수학","사회","과학","국어","영어","수학","사회"]
["2011-01-11 오전 9:59:49",2,"홍길동","洪길동","840102-2222222","서울 영등포구 여의도동  국회","재직중","2011-01-01","2011-01-31","직급1","직위1","부서1","2011-02-01","2011-02-28","직급2","직위2","부서2","2011-03-01","2011-03-31","직급3","직위3","부서3","2011-04-01","2011-04-30","직급4","직위4","부서4","2011-05-01","2011-05-31","직급5","직위5","부서5","2011-06-01","2011-06-30","직급6","직위6","부서6","2011-07-01","2011-07-31","직급7","직위7","부서7","2011-08-01","2011-08-31","직급8","직위8","부서8","2011-09-01","2019-12-31","직급9","직위9","부서9","2011-01-01","종류1","시행청1","2011-02-01","종류2","시행청2","2011-03-01","종류3","시행청3","2011-04-01","종류4","시행청4","2011-05-01","종류1","시행청1","2011-06-01","종류2","시행청2","2011-07-01","종류3","시행청3","2011-08-01","종류4","시행청4","2011-09-01","사유1","처분청1","2011-10-01","사유2","처분청2","  ",""," 년 개월 일"," 년 개월 일"," 년 개월 일"," 년 개월 일"," 년 개월 일"," 년 개월 일"," 년 개월 일"," 년 개월 일"," 년 개월 일","국어","영어","수학","사회","과학","국어","영어","수학","사회"]

{"sheet":"Sheet1","index":2,"n_rows":18,"n_cols":12,"rows_kept":18,"cut":false,"hidden":true,"merged":[]}
["입력일","등록번호","퇴직사유","오늘날짜",null,"퇴직사유 정재"]
[{"$f":"NOW()","v":"2020-01-07T16:39:31.930"},{"$f":"MAX(접수대장!B:B)+1","v":3},null,{"$f":"TODAY()","v":"2020-01-07"},null,{"$f":"C2","v":0}]
["기간 계산",null,"년","월","일","정재 년","정재 월","정재 일",null,null,null,{"$f":"SUM(L4:L12)","v":0}]
[null,null,{"$f":"IF(A4=\"\",\"\",DATEDIF(A4,B4+1,\"y\"))","v":""},{"$f":"IF(A4=\"\",\"\",DATEDIF(A4,B4+1,\"ym\"))","v":""},{"$f":"IF(A4=\"\",\"\",DATEDIF(A4,B4+1,\"md\"))","v":""},{"$f":"IF(C4=0,\"\",C4&\" 년\")","v":" 년"},{"$f":"IF(D4=0,\"\",D4&\" 개월\")","v":" 개월"},{"$f":"IF(E4=0,\"\",E4&\" 일\")","v":" 일"},{"$f":"IF(ISERROR(F4&G4&H4),\"\",F4&G4&H4)","v":" 년 개월 일"},{"$f":"A4","v":"00:00:00"},{"$f":"B4","v":"00:00:00"},{"$f":"IF(B4=TODAY(),1,0)","v":0}]
[null,null,{"$f":"IF(A5=\"\",\"\",DATEDIF(A5,B5+1,\"y\"))","v":""},{"$f":"IF(A5=\"\",\"\",DATEDIF(A5,B5+1,\"ym\"))","v":""},{"$f":"IF(A5=\"\",\"\",DATEDIF(A5,B5+1,\"md\"))","v":""},{"$f":"IF(C5=0,\"\",C5&\" 년\")","v":" 년"},{"$f":"IF(D5=0,\"\",D5&\" 개월\")","v":" 개월"},{"$f":"IF(E5=0,\"\",E5&\" 일\")","v":" 일"},{"$f":"IF(ISERROR(F5&G5&H5),\"\",F5&G5&H5)","v":" 년 개월 일"},{"$f":"A5","v":"00:00:00"},{"$f":"B5","v":"00:00:00"},{"$f":"IF(B5=TODAY(),1,0)","v":0}]
[null,null,"","",""," 년"," 개월"," 일"," 년 개월 일","00:00:00","00:00:00",0]
[null,null,"","",""," 년"," 개월"," 일"," 년 개월 일","00:00:00","00:00:00",0]
[null,null,"","",""," 년"," 개월"," 일"," 년 개월 일","00:00:00","00:00:00",0]
[null,null,"","",""," 년"," 개월"," 일"," 년 개월 일","00:00:00","00:00:00",0]
[null,null,"","",""," 년"," 개월"," 일"," 년 개월 일","00:00:00","00:00:00",0]
[null,null,"","",""," 년"," 개월"," 일"," 년 개월 일","00:00:00","00:00:00",0]
[null,null,"","",""," 년"," 개월"," 일"," 년 개월 일","00:00:00","00:00:00",0]
["발급번호","R100000000-2019-000",{"$f":"SUM(C4:C12)","v":0},{"$f":"SUM(D4:D12)","v":0},{"$f":"SUM(E4:E12)","v":0},{"$f":"IF(C13=0,\"\",C13&\" 년\")","v":""},{"$f":"IF(D13=0,\"\",D13&\" 개월\")","v":""},{"$f":"IF(E13=0,\"\",E13&\" 일\")","v":""},{"$f":"IF(ISERROR(F13&G13&H13),\"\",F13&G13&H13)","v":""},{"$f":"TODAY()","v":"2020-01-07"},{"$f":"MONTH(J13)&\"월 \"","v":"1월 "}]
["담당자","홍길순",{"$f":"C13+INT((D13+INT(E13/30))/12)","v":0},{"$f":"IF(D13+INT(E13/30)<12,D13+INT(E13/30),D13+INT(E13/30)-INT((D13+INT(E13/30))/12)*12)","v":0},{"$f":"E13-INT(E13/30)*30","v":0},{"$f":"IF(C14=0,\"\",C14&\"년\")","v":""},{"$f":"IF(D14=0,\"\",D14&\"개월\")","v":""},{"$f":"IF(E14=0,\"\",E14&\"일\")","v":""},{"$f":"IF(ISERROR(F14&\" \"&G14&\" \"&H14),\"\",F14&\" \"&G14&\" \"&H14)","v":"  "},null,{"$f":"YEAR(J13)&\"년 \"","v":"2020년 "}]
["기관","서울고등학교"]
["발급용도","학교제출용"]
["기관 연락처","02)1234-1234"]
["직인",{"$f":"B15&\"장\"","v":"서울고등학교장"}]

{"sheet":"Sheet2","index":3,"n_rows":9,"n_cols":13,"rows_kept":9,"cut":false,"hidden":true,"merged":[]}
[null,"선택번호",1,2,3,4,5,6,7,8,9]
[2,"직위",{"$f":"C3","v":0},{"$f":"D3","v":0},0,0,0,0,0,0,0,{"$f":"MAX(C8:K8)","v":0},{"$f":"IF(ISERROR(HLOOKUP(L2,C:K, A2+1, FALSE)),\"\",HLOOKUP(L2,C:K, A2+1, FALSE))","v":""}]
[]
[3,"직급",{"$f":"C5","v":0},0,0,0,0,0,0,0,0,{"$f":"MAX(C9:K9)","v":0},{"$f":"IF(ISERROR(HLOOKUP(L4,C:K, A4+1, FALSE)),\"\",HLOOKUP(L4,C:K, A4+1, FALSE))","v":""}]
[]
[5,null,{"$f":"CONCATENATE(C5,\" \",C3)","v":" "},{"$f":"CONCATENATE(D5,\" \",D3)","v":" "}," "," "," "," "," "," "," ",{"$f":"MAX(L2:L5)","v":0},{"$f":"IF(ISERROR(HLOOKUP(L6,C:K, A6+1, FALSE)),\"\",HLOOKUP(L6,C:K, A6+1, FALSE))","v":""}]
[]
[null,"직위",{"$f":"IF(C3=0,\"\",1)","v":""},{"$f":"IF(D3=0,\"\",2)","v":""},{"$f":"IF(E3=0,\"\",3)","v":""},{"$f":"IF(F3=0,\"\",4)","v":""},{"$f":"IF(G3=0,\"\",5)","v":""},{"$f":"IF(H3=0,\"\",6)","v":""},{"$f":"IF(I3=0,\"\",7)","v":""},{"$f":"IF(J3=0,\"\",8)","v":""},{"$f":"IF(K3=0,\"\",9)","v":""}]
[null,"직급",{"$f":"IF(C4=0,\"\",1)","v":""},{"$f":"IF(D4=0,\"\",2)","v":""},{"$f":"IF(E4=0,\"\",3)","v":""},{"$f":"IF(F4=0,\"\",4)","v":""},{"$f":"IF(G4=0,\"\",5)","v":""},{"$f":"IF(H4=0,\"\",6)","v":""},{"$f":"IF(I4=0,\"\",7)","v":""},{"$f":"IF(J4=0,\"\",8)","v":""},{"$f":"IF(K4=0,\"\",9)","v":""}]

{"sheet":"경력증명서","index":4,"n_rows":31,"n_cols":7,"rows_kept":31,"cut":false,"hidden":false,"merged":[[18,0,23,0],[5,6,6,6],[5,1,5,2],[5,3,6,3],[5,4,6,4],[16,1,16,2],[16,4,16,6],[18,4,18,6],[18,1,18,3],[2,5,3,6],[4,2,4,6],[17,1,17,6],[0,0,0,2],[1,0,1,6],[2,0,4,0],[2,1,3,1],[2,4,3,4],[5,5,6,5],[5,0,15,0],[31,2,31,4],[24,0,26,0],[24,2,24,4],[24,5,24,6],[25,2,25,4],[29,0,29,6],[27,1,27,6],[28,0,28,6],[30,2,30,4],[26,2,26,4],[26,5,26,6],[25,5,25,6]]}
[{"$f":"IF(ISERROR(\"발급번호 : \"&Sheet1!B13 &\" 호\"),\"\",\"발급번호 : \"&Sheet1!B13 &\" 호\")","v":"발급번호 : R100000000-2019-000 호"}]
["경   력   증   명   서"]
["인적\n사항","성  명","한 글",null,"생년월일",{"$f":"IF(ISERROR(IF(VALUE(MID(H3,8,1))<=2,\"19\",\"20\")&LEFT(H3,2)&\". \"&MID(H3,3,2)&\". \"&MID(H3,5,2)&\".\"),,IF(VALUE(MID(H3,8,1))<=2,\"19\",\"20\")&LEFT(H3,2)&\". \"&MID(H3,3,2)&\". \"&MID(H3,5,2)&\".\")","v":0}]
[null,null,"한 자"]
[null,"주  소"]
["경력\n사항","근무 기간",null,"직  급","직  위","근무 부서","담당\n과목"]
[null,"부   터","까  지"]
[null,{"$f":"IF(ISERROR(Sheet1!J4),\"\",Sheet1!J4)","v":"00:00:00"},{"$f":"IF(ISERROR(Sheet1!K4),\"\",Sheet1!K4)","v":"00:00:00"},{"$f":"IF(ISERROR(Sheet2!C$4),\"\",Sheet2!C$4)","v":0},{"$f":"IF(ISERROR(Sheet2!C2),\"\",Sheet2!C2)","v":0}]
[null,{"$f":"IF(ISERROR(Sheet1!J5),\"\",Sheet1!J5)","v":"00:00:00"},{"$f":"IF(ISERROR(Sheet1!K5),\"\",Sheet1!K5)","v":"00:00:00"},{"$f":"IF(ISERROR(Sheet2!D$4),\"\",Sheet2!D$4)","v":0},{"$f":"IF(ISERROR(Sheet2!D2),\"\",Sheet2!D2)","v":0}]
[null,{"$f":"IF(ISERROR(Sheet1!J6),\"\",Sheet1!J6)","v":"00:00:00"},{"$f":"IF(ISERROR(Sheet1!K6),\"\",Sheet1!K6)","v":"00:00:00"},{"$f":"IF(ISERROR(Sheet2!E$4),\"\",Sheet2!E$4)","v":0},{"$f":"IF(ISERROR(Sheet2!E2),\"\",Sheet2!E2)","v":0}]
[null,{"$f":"IF(ISERROR(Sheet1!J7),\"\",Sheet1!J7)","v":"00:00:00"},{"$f":"IF(ISERROR(Sheet1!K7),\"\",Sheet1!K7)","v":"00:00:00"},{"$f":"IF(ISERROR(Sheet2!F$4),\"\",Sheet2!F$4)","v":0},{"$f":"IF(ISERROR(Sheet2!F2),\"\",Sheet2!F2)","v":0}]
[null,{"$f":"IF(ISERROR(Sheet1!J8),\"\",Sheet1!J8)","v":"00:00:00"},{"$f":"IF(ISERROR(Sheet1!K8),\"\",Sheet1!K8)","v":"00:00:00"},{"$f":"IF(ISERROR(Sheet2!G$4),\"\",Sheet2!G$4)","v":0},{"$f":"IF(ISERROR(Sheet2!G2),\"\",Sheet2!G2)","v":0}]
[null,{"$f":"IF(ISERROR(Sheet1!J9),\"\",Sheet1!J9)","v":"00:00:00"},{"$f":"IF(ISERROR(Sheet1!K9),\"\",Sheet1!K9)","v":"00:00:00"},{"$f":"IF(ISERROR(Sheet2!H$4),\"\",Sheet2!H$4)","v":0},{"$f":"IF(ISERROR(Sheet2!H2),\"\",Sheet2!H2)","v":0}]
[null,{"$f":"IF(ISERROR(Sheet1!J10),\"\",Sheet1!J10)","v":"00:00:00"},{"$f":"IF(ISERROR(Sheet1!K10),\"\",Sheet1!K10)","v":"00:00:00"},{"$f":"IF(ISERROR(Sheet2!I$4),\"\",Sheet2!I$4)","v":0},{"$f":"IF(ISERROR(Sheet2!I2),\"\",Sheet2!I2)","v":0}]
[null,{"$f":"IF(ISERROR(Sheet1!J11),\"\",Sheet1!J11)","v":"00:00:00"},{"$f":"IF(ISERROR(Sheet1!K11),\"\",Sheet1!K11)","v":"00:00:00"},{"$f":"IF(ISERROR(Sheet2!J$4),\"\",Sheet2!J$4)","v":0},{"$f":"IF(ISERROR(Sheet2!J2),\"\",Sheet2!J2)","v":0}]
[null,{"$f":"IF(ISERROR(Sheet1!J12),\"\",Sheet1!J12)","v":"00:00:00"},{"$f":"IF(ISERROR(Sheet1!K12),\"\",Sheet1!K12)","v":"00:00:00"},{"$f":"IF(ISERROR(Sheet2!K$4),\"\",Sheet2!K$4)","v":0},{"$f":"IF(ISERROR(Sheet2!K2),\"\",Sheet2!K2)","v":0}]
["근무연한",{"$f":"IF(ISERROR(Sheet1!I14),\"\",Sheet1!I14)","v":"  "},null,"최종직위(직급)",{"$f":"IF(ISERROR(Sheet2!M6),\"\",Sheet2!M6)","v":""}]
["퇴직사유",{"$f":"IF(ISERROR(Sheet1!F2),\"\",Sheet1!F2)","v":0}]
["상벌\n사항","포     상",null,null,"징     계"]
[null,"연월일","종  류","시 행 청","연월일","종 류","시행청"]
[]
[]
[]
[]
["직위\n해제","연월일","사                      유",null,null," 처분청"]
[]
[]
["용도"]
["위와 같이 증명합니다."]
[{"$f":"TODAY()","v":"2020-01-07"}]
[null,null,{"$f":"IF(ISERROR(Sheet1!B15 &\" 장\"),\"\",Sheet1!B15 &\" 장\")","v":"서울고등학교 장"}]

{"sheet":"경력증명서-2","index":5,"n_rows":31,"n_cols":7,"rows_kept":31,"cut":false,"hidden":false,"merged":[[16,1,16,2],[16,4,16,6],[27,1,27,6],[28,0,28,6],[24,0,26,0],[25,5,25,6],[25,2,25,4],[31,2,31,4],[26,2,26,4],[26,5,26,6],[24,2,24,4],[24,5,24,6],[30,2,30,4],[29,0,29,6],[15,5,15,6],[17,1,17,6],[18,0,23,0],[18,1,18,3],[18,4,18,6],[5,0,15,0],[5,1,5,2],[5,3,6,3],[5,4,6,4],[7,5,7,6],[5,5,6,6],[12,5,12,6],[13,5,13,6],[14,5,14,6],[8,5,8,6],[9,5,9,6],[10,5,10,6],[11,5,11,6],[0,0,0,2],[1,0,1,6],[2,0,4,0],[2,1,3,1],[2,4,3,4],[2,5,3,6],[4,2,4,6]]}
[{"$f":"IF(ISERROR(\"발급번호 : \"&Sheet1!B13 &\" 호\"),\"\",\"발급번호 : \"&Sheet1!B13 &\" 호\")","v":"발급번호 : R100000000-2019-000 호"}]
["경   력   증   명   서"]
["인적\n사항","성  명","한 글",{"$f":"경력증명서!D3","v":0},"생년월일",{"$f":"경력증명서!F3","v":0}]
[null,null,"한 자",{"$f":"경력증명서!D4","v":0}]
[null,"주  소",{"$f":"경력증명서!C5","v":0}]
["경력\n사항","근무 기간",null,"직  급","직  위","근무 부서"]
[null,"부   터","까  지"]
[null,{"$f":"경력증명서!B8","v":"00:00:00"},{"$f":"경력증명서!C8","v":"00:00:00"},{"$f":"경력증명서!D8","v":0},{"$f":"경력증명서!E8","v":0},{"$f":"경력증명서!F8","v":0}]
[null,{"$f":"경력증명서!B9","v":"00:00:00"},{"$f":"경력증명서!C9","v":"00:00:00"},{"$f":"경력증명서!D9","v":0},{"$f":"경력증명서!E9","v":0},{"$f":"경력증명서!F9","v":0}]
[null,{"$f":"경력증명서!B10","v":"00:00:00"},{"$f":"경력증명서!C10","v":"00:00:00"},{"$f":"경력증명서!D10","v":0},{"$f":"경력증명서!E10","v":0},{"$f":"경력증명서!F10","v":0}]
[null,{"$f":"경력증명서!B11","v":"00:00:00"},{"$f":"경력증명서!C11","v":"00:00:00"},{"$f":"경력증명서!D11","v":0},{"$f":"경력증명서!E11","v":0},{"$f":"경력증명서!F11","v":0}]
[null,{"$f":"경력증명서!B12","v":"00:00:00"},{"$f":"경력증명서!C12","v":"00:00:00"},{"$f":"경력증명서!D12","v":0},{"$f":"경력증명서!E12","v":0},{"$f":"경력증명서!F12","v":0}]
[null,{"$f":"경력증명서!B13","v":"00:00:00"},{"$f":"경력증명서!C13","v":"00:00:00"},{"$f":"경력증명서!D13","v":0},{"$f":"경력증명서!E13","v":0},{"$f":"경력증명서!F13","v":0}]
[null,{"$f":"경력증명서!B14","v":"00:00:00"},{"$f":"경력증명서!C14","v":"00:00:00"},{"$f":"경력증명서!D14","v":0},{"$f":"경력증명서!E14","v":0},{"$f":"경력증명서!F14","v":0}]
[null,{"$f":"경력증명서!B15","v":"00:00:00"},{"$f":"경력증명서!C15","v":"00:00:00"},{"$f":"경력증명서!D15","v":0},{"$f":"경력증명서!E15","v":0},{"$f":"경력증명서!F15","v":0}]
[null,{"$f":"경력증명서!B16","v":"00:00:00"},{"$f":"경력증명서!C16","v":"00:00:00"},{"$f":"경력증명서!D16","v":0},{"$f":"경력증명서!E16","v":0},{"$f":"경력증명서!F16","v":0}]
["근무연한",{"$f":"경력증명서!B17","v":"  "},null,"최종직위(직급)",{"$f":"경력증명서!E17","v":""}]
["퇴직사유",{"$f":"경력증명서!B18","v":0}]
["상벌\n사항","포     상",null,null,"징     계"]
[null,"연월일","종  류","시 행 청","연월일","종 류","시행청"]
[null,{"$f":"경력증명서!B21","v":"00:00:00"},{"$f":"경력증명서!C21","v":"00:00:00"},{"$f":"경력증명서!D21","v":"00:00:00"},{"$f":"경력증명서!E21","v":"00:00:00"},{"$f":"경력증명서!F21","v":"00:00:00"},{"$f":"경력증명서!G21","v":"00:00:00"}]
[null,{"$f":"경력증명서!B22","v":"00:00:00"},{"$f":"경력증명서!C22","v":"00:00:00"},{"$f":"경력증명서!D22","v":"00:00:00"},{"$f":"경력증명서!E22","v":"00:00:00"},{"$f":"경력증명서!F22","v":"00:00:00"},{"$f":"경력증명서!G22","v":"00:00:00"}]
[null,{"$f":"경력증명서!B23","v":"00:00:00"},{"$f":"경력증명서!C23","v":"00:00:00"},{"$f":"경력증명서!D23","v":"00:00:00"},{"$f":"경력증명서!E23","v":"00:00:00"},{"$f":"경력증명서!F23","v":"00:00:00"},{"$f":"경력증명서!G23","v":"00:00:00"}]
[null,{"$f":"경력증명서!B24","v":"00:00:00"},{"$f":"경력증명서!C24","v":"00:00:00"},{"$f":"경력증명서!D24","v":"00:00:00"},{"$f":"경력증명서!E24","v":"00:00:00"},{"$f":"경력증명서!F24","v":"00:00:00"},{"$f":"경력증명서!G24","v":"00:00:00"}]
["직위\n해제","연월일","사                      유",null,null," 처분청"]
[null,{"$f":"경력증명서!B26","v":"00:00:00"},{"$f":"경력증명서!C26","v":0},null,null,{"$f":"경력증명서!F26","v":0}]
[null,{"$f":"경력증명서!B27","v":"00:00:00"},{"$f":"경력증명서!C27","v":0},null,null,{"$f":"경력증명서!F27","v":0}]
["용도",{"$f":"경력증명서!B28","v":"00:00:00"}]
["위와 같이 증명합니다."]
[{"$f":"TODAY()","v":"2020-01-07"}]
[null,null,{"$f":"IF(ISERROR(Sheet1!B15 &\" 장\"),\"\",Sheet1!B15 &\" 장\")","v":"서울고등학교 장"}]

{"sheet":"경력증명서 (FAX)","index":6,"n_rows":39,"n_cols":9,"rows_kept":39,"cut":false,"hidden":false,"merged":[[18,0,23,0],[5,6,6,6],[5,1,5,2],[5,3,6,3],[5,4,6,4],[16,1,16,2],[16,4,16,6],[18,4,18,6],[18,1,18,3],[2,5,3,6],[4,2,4,6],[17,1,17,6],[0,0,0,2],[1,0,1,6],[2,0,4,0],[2,1,3,1],[2,4,3,4],[5,5,6,5],[5,0,15,0],[24,0,26,0],[24,2,24,4],[24,5,24,6],[25,2,25,4],[29,0,29,6],[27,1,27,6],[28,0,28,6],[29,8,29,10],[26,2,26,4],[26,5,26,6],[25,5,25,6],[31,2,31,4]]}
[{"$f":"IF(ISERROR(\"발급번호 : \"&Sheet1!B13 &\" 호\"),\"\",\"발급번호 : \"&Sheet1!B13 &\" 호\")","v":"발급번호 : R100000000-2019-000 호"}]
["경   력   증   명   서"]
["인적\n사항","성  명","한 글",{"$f":"경력증명서!D3","v":0},"생년월일",{"$f":"경력증명서!F3","v":0}]
[null,null,"한 자",{"$f":"경력증명서!D4","v":0}]
[null,"주  소",{"$f":"경력증명서!C5","v":0}]
["경력\n사항","근무 기간",null,"직  급","직  위","근무 부서","담당\n과목"]
[null,"부   터","까  지"]
[null,{"$f":"경력증명서!B8","v":"00:00:00"},{"$f":"경력증명서!C8","v":"00:00:00"},{"$f":"경력증명서!D8","v":0},{"$f":"경력증명서!E8","v":0},{"$f":"경력증명서!F8","v":0},{"$f":"경력증명서!G8","v":0}]
[null,{"$f":"경력증명서!B9","v":"00:00:00"},{"$f":"경력증명서!C9","v":"00:00:00"},{"$f":"경력증명서!D9","v":0},{"$f":"경력증명서!E9","v":0},{"$f":"경력증명서!F9","v":0},{"$f":"경력증명서!G9","v":0}]
[null,{"$f":"경력증명서!B10","v":"00:00:00"},{"$f":"경력증명서!C10","v":"00:00:00"},{"$f":"경력증명서!D10","v":0},{"$f":"경력증명서!E10","v":0},{"$f":"경력증명서!F10","v":0},{"$f":"경력증명서!G10","v":0}]
[null,{"$f":"경력증명서!B11","v":"00:00:00"},{"$f":"경력증명서!C11","v":"00:00:00"},{"$f":"경력증명서!D11","v":0},{"$f":"경력증명서!E11","v":0},{"$f":"경력증명서!F11","v":0},{"$f":"경력증명서!G11","v":0}]
[null,{"$f":"경력증명서!B12","v":"00:00:00"},{"$f":"경력증명서!C12","v":"00:00:00"},{"$f":"경력증명서!D12","v":0},{"$f":"경력증명서!E12","v":0},{"$f":"경력증명서!F12","v":0},{"$f":"경력증명서!G12","v":0}]
[null,{"$f":"경력증명서!B13","v":"00:00:00"},{"$f":"경력증명서!C13","v":"00:00:00"},{"$f":"경력증명서!D13","v":0},{"$f":"경력증명서!E13","v":0},{"$f":"경력증명서!F13","v":0},{"$f":"경력증명서!G13","v":0}]
[null,{"$f":"경력증명서!B14","v":"00:00:00"},{"$f":"경력증명서!C14","v":"00:00:00"},{"$f":"경력증명서!D14","v":0},{"$f":"경력증명서!E14","v":0},{"$f":"경력증명서!F14","v":0},{"$f":"경력증명서!G14","v":0}]
[null,{"$f":"경력증명서!B15","v":"00:00:00"},{"$f":"경력증명서!C15","v":"00:00:00"},{"$f":"경력증명서!D15","v":0},{"$f":"경력증명서!E15","v":0},{"$f":"경력증명서!F15","v":0},{"$f":"경력증명서!G15","v":0}]
[null,{"$f":"경력증명서!B16","v":"00:00:00"},{"$f":"경력증명서!C16","v":"00:00:00"},{"$f":"경력증명서!D16","v":0},{"$f":"경력증명서!E16","v":0},{"$f":"경력증명서!F16","v":0},{"$f":"경력증명서!G16","v":0}]
["근무연한",{"$f":"경력증명서!B17","v":"  "},null,"최종직위(직급)",{"$f":"경력증명서!E17","v":""}]
["퇴직사유",{"$f":"경력증명서!B18","v":0}]
["상벌\n사항","포     상",null,null,"징     계"]
[null,"연월일","종  류","시 행 청","연월일","종 류","시행청"]
[null,{"$f":"경력증명서!B21","v":"00:00:00"},{"$f":"경력증명서!C21","v":"00:00:00"},{"$f":"경력증명서!D21","v":"00:00:00"},{"$f":"경력증명서!E21","v":"00:00:00"},{"$f":"경력증명서!F21","v":"00:00:00"},{"$f":"경력증명서!G21","v":"00:00:00"}]
[null,{"$f":"경력증명서!B22","v":"00:00:00"},{"$f":"경력증명서!C22","v":"00:00:00"},{"$f":"경력증명서!D22","v":"00:00:00"},{"$f":"경력증명서!E22","v":"00:00:00"},{"$f":"경력증명서!F22","v":"00:00:00"},{"$f":"경력증명서!G22","v":"00:00:00"}]
[null,{"$f":"경력증명서!B23","v":"00:00:00"},{"$f":"경력증명서!C23","v":"00:00:00"},{"$f":"경력증명서!D23","v":"00:00:00"},{"$f":"경력증명서!E23","v":"00:00:00"},{"$f":"경력증명서!F23","v":"00:00:00"},{"$f":"경력증명서!G23","v":"00:00:00"}]
[null,{"$f":"경력증명서!B24","v":"00:00:00"},{"$f":"경력증명서!C24","v":"00:00:00"},{"$f":"경력증명서!D24","v":"00:00:00"},{"$f":"경력증명서!E24","v":"00:00:00"},{"$f":"경력증명서!F24","v":"00:00:00"},{"$f":"경력증명서!G24","v":"00:00:00"}]
["직위\n해제","연월일","사                      유",null,null," 처분청"]
[null,{"$f":"경력증명서!B26","v":"00:00:00"},{"$f":"경력증명서!C26","v":"00:00:00"},null,null,{"$f":"경력증명서!F26","v":0}]
[null,{"$f":"경력증명서!B27","v":"00:00:00"},{"$f":"경력증명서!C27","v":"00:00:00"},null,null,{"$f":"경력증명서!F27","v":0}]
["용도",{"$f":"경력증명서!B28","v":"00:00:00"}]
["위와 같이 증명합니다."]
[{"$f":"TODAY()","v":"2020-01-07"},null,null,null,null,null,null,null,{"$f":"IF(ISERROR(Sheet1!B15 &\" 장\"),\"\",Sheet1!B15 &\" 장\")","v":"서울고등학교 장"}]
[]
[]
[]
[null,null,null,null,null,"인"]
[]
[]
[]
[]
[null,null,null,null,null,null,"            인"]

{"sheet":"경력증명서 (FAX)-2","index":7,"n_rows":39,"n_cols":9,"rows_kept":39,"cut":false,"hidden":false,"merged":[[16,1,16,2],[16,4,16,6],[17,1,17,6],[29,8,29,10],[31,2,31,4],[24,2,24,4],[27,1,27,6],[28,0,28,6],[29,0,29,6],[26,2,26,4],[26,5,26,6],[24,5,24,6],[25,2,25,4],[25,5,25,6],[18,0,23,0],[18,1,18,3],[18,4,18,6],[24,0,26,0],[5,0,15,0],[5,1,5,2],[5,3,6,3],[5,4,6,4],[10,5,10,6],[11,5,11,6],[5,5,6,6],[12,5,12,6],[13,5,13,6],[14,5,14,6],[15,5,15,6],[7,5,7,6],[8,5,8,6],[9,5,9,6],[0,0,0,2],[1,0,1,6],[2,0,4,0],[2,1,3,1],[2,4,3,4],[2,5,3,6],[4,2,4,6]]}
[{"$f":"IF(ISERROR(\"발급번호 : \"&Sheet1!B13 &\" 호\"),\"\",\"발급번호 : \"&Sheet1!B13 &\" 호\")","v":"발급번호 : R100000000-2019-000 호"}]
["경   력   증   명   서"]
["인적\n사항","성  명","한 글",{"$f":"경력증명서!D3","v":0},"생년월일",{"$f":"경력증명서!F3","v":0}]
[null,null,"한 자",{"$f":"경력증명서!D4","v":0}]
[null,"주  소",{"$f":"경력증명서!C5","v":0}]
["경력\n사항","근무 기간",null,"직  급","직  위","근무 부서"]
[null,"부   터","까  지"]
[null,{"$f":"경력증명서!B8","v":"00:00:00"},{"$f":"경력증명서!C8","v":"00:00:00"},{"$f":"경력증명서!D8","v":0},{"$f":"경력증명서!E8","v":0},{"$f":"경력증명서!F8","v":0}]
[null,{"$f":"경력증명서!B9","v":"00:00:00"},{"$f":"경력증명서!C9","v":"00:00:00"},{"$f":"경력증명서!D9","v":0},{"$f":"경력증명서!E9","v":0},{"$f":"경력증명서!F9","v":0}]
[null,{"$f":"경력증명서!B10","v":"00:00:00"},{"$f":"경력증명서!C10","v":"00:00:00"},{"$f":"경력증명서!D10","v":0},{"$f":"경력증명서!E10","v":0},{"$f":"경력증명서!F10","v":0}]
[null,{"$f":"경력증명서!B11","v":"00:00:00"},{"$f":"경력증명서!C11","v":"00:00:00"},{"$f":"경력증명서!D11","v":0},{"$f":"경력증명서!E11","v":0},{"$f":"경력증명서!F11","v":0}]
[null,{"$f":"경력증명서!B12","v":"00:00:00"},{"$f":"경력증명서!C12","v":"00:00:00"},{"$f":"경력증명서!D12","v":0},{"$f":"경력증명서!E12","v":0},{"$f":"경력증명서!F12","v":0}]
[null,{"$f":"경력증명서!B13","v":"00:00:00"},{"$f":"경력증명서!C13","v":"00:00:00"},{"$f":"경력증명서!D13","v":0},{"$f":"경력증명서!E13","v":0},{"$f":"경력증명서!F13","v":0}]
[null,{"$f":"경력증명서!B14","v":"00:00:00"},{"$f":"경력증명서!C14","v":"00:00:00"},{"$f":"경력증명서!D14","v":0},{"$f":"경력증명서!E14","v":0},{"$f":"경력증명서!F14","v":0}]
[null,{"$f":"경력증명서!B15","v":"00:00:00"},{"$f":"경력증명서!C15","v":"00:00:00"},{"$f":"경력증명서!D15","v":0},{"$f":"경력증명서!E15","v":0},{"$f":"경력증명서!F15","v":0}]
[null,{"$f":"경력증명서!B16","v":"00:00:00"},{"$f":"경력증명서!C16","v":"00:00:00"},{"$f":"경력증명서!D16","v":0},{"$f":"경력증명서!E16","v":0},{"$f":"경력증명서!F16","v":0}]
["근무연한",{"$f":"경력증명서!B17","v":"  "},null,"최종직위(직급)",{"$f":"경력증명서!E17","v":""}]
["퇴직사유",{"$f":"경력증명서!B18","v":0}]
["상벌\n사항","포     상",null,null,"징     계"]
[null,"연월일","종  류","시 행 청","연월일","종 류","시행청"]
[null,{"$f":"경력증명서!B21","v":"00:00:00"},{"$f":"경력증명서!C21","v":"00:00:00"},{"$f":"경력증명서!D21","v":"00:00:00"},{"$f":"경력증명서!E21","v":"00:00:00"},{"$f":"경력증명서!F21","v":"00:00:00"},{"$f":"경력증명서!G21","v":"00:00:00"}]
[null,{"$f":"경력증명서!B22","v":"00:00:00"},{"$f":"경력증명서!C22","v":"00:00:00"},{"$f":"경력증명서!D22","v":"00:00:00"},{"$f":"경력증명서!E22","v":"00:00:00"},{"$f":"경력증명서!F22","v":"00:00:00"},{"$f":"경력증명서!G22","v":"00:00:00"}]
[null,{"$f":"경력증명서!B23","v":"00:00:00"},{"$f":"경력증명서!C23","v":"00:00:00"},{"$f":"경력증명서!D23","v":"00:00:00"},{"$f":"경력증명서!E23","v":"00:00:00"},{"$f":"경력증명서!F23","v":"00:00:00"},{"$f":"경력증명서!G23","v":"00:00:00"}]
[null,{"$f":"경력증명서!B24","v":"00:00:00"},{"$f":"경력증명서!C24","v":"00:00:00"},{"$f":"경력증명서!D24","v":"00:00:00"},{"$f":"경력증명서!E24","v":"00:00:00"},{"$f":"경력증명서!F24","v":"00:00:00"},{"$f":"경력증명서!G24","v":"00:00:00"}]
["직위\n해제","연월일","사                      유",null,null," 처분청"]
[null,{"$f":"경력증명서!B26","v":"00:00:00"},{"$f":"경력증명서!C26","v":"00:00:00"},null,null,{"$f":"경력증명서!F26","v":0}]
[null,{"$f":"경력증명서!B27","v":"00:00:00"},{"$f":"경력증명서!C27","v":"00:00:00"},null,null,{"$f":"경력증명서!F27","v":0}]
["용도",{"$f":"경력증명서!B28","v":"00:00:00"}]
["위와 같이 증명합니다."]
[{"$f":"TODAY()","v":"2020-01-07"},null,null,null,null,null,null,null,{"$f":"IF(ISERROR(Sheet1!B15 &\" 장\"),\"\",Sheet1!B15 &\" 장\")","v":"서울고등학교 장"}]
[]
[]
[]
[null,null,null,null,null,"인"]
[]
[]
[]
[]
[null,null,null,null,null,null,"            인"]

{"sheet":"수정사항","index":8,"n_rows":23,"n_cols":4,"rows_kept":23,"cut":false,"hidden":false,"merged":[[19,1,19,7],[18,1,18,7],[12,1,12,7],[16,1,16,7],[15,1,15,7],[22,1,22,7],[0,0,1,0],[0,1,1,2],[2,0,2,1],[14,1,14,7],[11,0,11,1],[9,1,9,7],[5,1,5,7],[8,0,8,1],[13,1,13,7],[21,1,21,5],[20,1,20,7],[3,1,3,7],[6,1,6,7],[17,1,17,7],[4,1,4,7]]}
["수정일자:","2011-10-11T14:31:41.250",null,{"$f":"COUNTA(A:A)","v":16}]
[]
["☆ 기능 추가"]
["2011-01-22","네이스 발급창 생성 (IE8에서 접속 가능)"]
[null,"자료 수정창에서 각자료마다의 근무년수를 팁정보로 노출"]
["2011-05-30","당시 지도과목란 추가 (옵션)"]
["2011-06-02","인터넷 주소 검색창 추가"]
[]
["☆ 기능 제거"]
["2011-01-22","수정창에서 =today()로 오늘날짜를 입력하는 방식 제거 (오류발생됨)"]
[]
["☆ 세부기능 변경",null,{"$f":"COUNTA(A:A)","v":16}]
["2011-01-10","경력증명서 종료일자가 오늘날짜일 경우 '20OO년 OO월 현재까지'로 나타남"]
["2011-01-22","검색을 주민등록번호에서 이름검색으로 바꿈"]
[null,"최종 직급, 직위가 나타나도록 바로잡음 (종전: 최종 직급, 최종 직위따로 나타나는 문제 해결)"]
[null,"날짜정보 입력시 자동 하이픈 추가 (1234-12-12)"]
["2011-02-01","네이스 발급창 연결방법 개선 (보안문제로 인해 IE창을 별도로 연결)"]
["2011-06-01","유저폼1 캡션에 학교명 기재"]
["2011-06-02","저장된자료만 출력에서 출력버튼을 누를경우 현재화면 출력으로 변경, 수정자료는 별도로 저장해야함"]
["2011-10-11","근무기간을 수정시 총 근무연한도 실시간 반영되도록 수정"]
[null,"최종근무일자가 오늘일 경우 자동으로 퇴직사유에 '재직중'으로 출력되도록 수정"]
["2015-03-11","PC-FAX로 팩스 바로  송신"]
["2019-12-18","주민번호대신 생년월일로 출력"]