{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Main","자료입력"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"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":"Main","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"자료입력","index":1,"n_rows":356,"n_cols":6,"rows_kept":356,"cut":false,"hidden":true,"merged":[[0,0,0,1]]}
["□ 학교운영위원회 구성 자료 입력"]
["구  분","자료 입력","작성 방법","비  고"]
["학교명","천안중앙초등학교","정식학교명칭입력",null,null,"sheets(\"자료입력\").range(\"b"]
["우편번호",31115,"숫자만입력"]
["주소","충청남도 천안시 동남구 단대로 21-7","도로명주소입력"]
["전화번호","041-622-6422","041-111-1111"]
["팩스번호","041-622-6423","041-111-1111"]
["홈페이지주소","http://heemang.caees.kr"]
["학생수",580,"3. 1.자 학생수 기준"]
["학년도",2022,"숫자(해당 학년도)"]
["업무담당부서","행정실"]
["업무담당부서장직위",{"$f":"IF(B11=\"행정실\",\"행정실장\",\"교감\")","v":"행정실장"},"텍스트"]
["교장성명","김교장"]
["교감성명","김교감"]
["행정실장성명","김실장"]
["업무담당자성명","김담당"]
["운영위원기수",2,"차기 구성예정 위원회 기수","숫자(위원회 구성 기수)"]
["운영위원수",{"$f":"SUM(B19:B21)","v":10},"자동계산"]
["학부모위원수",5,"숫자"]
["교직원위원수",4,"숫자"]
["지역위원수",1,"숫자"]
["부위원장수",1,"숫자"]
[{"$f":"(B17-1) & \"기 임기만료일자\"","v":"1기 임기만료일자"},"2021-03-31","현재 위원회","날짜형식입력(2020-01-01)"]
[null,{"$f":"YEAR(B23)","v":2021},"자동계산"]
[null,{"$f":"MONTH(B23)","v":3},"자동계산"]
[null,{"$f":"DAY(B23)","v":31},"자동계산"]
[null,{"$f":"TEXT(WEEKDAY(B23,1),\"aaa\")","v":"수"},"자동계산"]
[{"$f":"B17 & \"기 임기시작일자\"","v":"2기 임기시작일자"},{"$f":"B23+1","v":"2021-04-01"},"구성대상 위원회 ","날짜형식입력(2020-01-01)"]
[null,{"$f":"YEAR(B28)","v":2021},"자동계산"]
[null,{"$f":"MONTH(B28)","v":4},"자동계산"]
[null,{"$f":"DAY(B28)","v":1},"자동계산"]
[null,{"$f":"TEXT(WEEKDAY(B28,1),\"aaa\")","v":"목"},"자동계산"]
["학부모/교원위원 구성일 기준",10,"위원회 규정 참고 입력","숫자"]
[null,"2021-03-21",{"$f":"B23-B33","v":"2021-03-21"},"날짜형식입력(2020-01-01)"]
[null,{"$f":"YEAR(B34)","v":2021},"자동계산"]
[null,{"$f":"MONTH(B34)","v":3},"자동계산"]
[null,{"$f":"DAY(B34)","v":21},"자동계산"]
[null,{"$f":"TEXT(WEEKDAY(B34,1),\"aaa\")","v":"일"},"자동계산"]
["지역위원 구성일 기준",1,"위원회 규정 참고 입력"]
["지역위원 구성일자","2021-03-31",{"$f":"B28-B39","v":"2021-03-31"},"날짜형식입력(2020-01-01)"]
[null,{"$f":"YEAR(B40)","v":2021},"자동계산"]
[null,{"$f":"MONTH(B40)","v":3},"자동계산"]
[null,{"$f":"DAY(B40)","v":31},"자동계산"]
[null,{"$f":"TEXT(WEEKDAY(B40,1),\"aaa\")","v":"수"},"자동계산"]
["선출 홍보시작일자","2021-03-02","학교자체 홍보실시","날짜형식입력(2020-01-01)"]
[null,{"$f":"YEAR(B45)","v":2021},"자동계산"]
[null,{"$f":"MONTH(B45)","v":3},"자동계산"]
[null,{"$f":"DAY(B45)","v":2},"자동계산"]
[null,{"$f":"TEXT(WEEKDAY(B45,1),\"aaa\")","v":"화"},"자동계산"]
["(선출관리위원회)구성 및 임기시작일자","2021-03-02",null,"날짜형식입력(2020-01-01)"]
[null,{"$f":"YEAR(B50)","v":2021},"자동계산"]
[null,{"$f":"MONTH(B50)","v":3},"자동계산"]
[null,{"$f":"DAY(B50)","v":2},"자동계산"]
[null,{"$f":"TEXT(WEEKDAY(B50,1),\"aaa\")","v":"화"},"자동계산"]
["(선출관리위원회)회의일자","2021-03-03",null,"날짜형식입력(2020-01-01)"]
[null,{"$f":"YEAR(B55)","v":2021},"자동계산"]
[null,{"$f":"MONTH(B55)","v":3},"자동계산"]
[null,{"$f":"DAY(B55)","v":3},"자동계산"]
["시간","13:00","자동계산"]
["선출관리위원수",{"$f":"B61+B62","v":9},"자동계산"]
["(선출관리)교직원위원수",{"$f":"COUNTA(B63:B66)","v":4},"자동계산"]
["(선출관리)학부모위원수",{"$f":"COUNTA(B67:B71)","v":5},"자동계산"]
["교직원위원","김위원"]
["교직원위원","김교직1"]
["교직원위원","김교직2"]
["교직원위원","김교직3"]
["학부모위원","김학부1"]
["학부모위원","김학부2"]
["학부모위원","김학부3"]
["학부모위원","김학부4"]
["학부모위원","김학부5"]
["(선출관리) 위원장명","김위원"]
["(선출관리) 부위원장명","김학부2"]
["학부모위원선거방법","가정통신문 회신, 직접투표, 온라인투표","선거방법 선택"]
["학부모위원선거일자","2021-03-19",{"$f":"B34","v":"2021-03-21"},"날짜형식입력(2020-01-01)"]
[null,{"$f":"YEAR(B75)","v":2021},"자동계산"]
[null,{"$f":"MONTH(B75)","v":3},"자동계산"]
[null,{"$f":"DAY(B75)","v":19},"자동계산"]
[null,{"$f":"TEXT(WEEKDAY(B75,1),\"aaa\")","v":"금"},"자동계산"]
["투표시작시간","9:00",null,"24시간 시간형식입력(17:30)"]
["투표마감시간","18:00",null,"24시간 시간형식입력(17:30)"]
["장소","체육관"]
["학부모위원선거공고일자",15,"숫자만 입력"]
[null,"2021-03-03",{"$f":"B75-B83","v":"2021-03-04"},"날짜형식입력(2020-01-01)"]
[null,{"$f":"YEAR(B84)","v":2021},"자동계산"]
[null,{"$f":"MONTH(B84)","v":3},"자동계산"]
[null,{"$f":"DAY(B84)","v":3},"자동계산"]
[null,{"$f":"TEXT(WEEKDAY(B84,1),\"aaa\")","v":"수"},"자동계산"]
["학부모선거인 명부작성",{"$f":"B84","v":"2021-03-03"},"공고일자 기준","날짜형식입력(2020-01-01)"]
[null,{"$f":"YEAR(B89)","v":2021},"자동계산"]
[null,{"$f":"MONTH(B89)","v":3},"자동계산"]
[null,{"$f":"DAY(B89)","v":3},"자동계산"]
[null,{"$f":"TEXT(WEEKDAY(B89,1),\"aaa\")","v":"수"},"자동계산"]
["학부모위원후보 등록기한",7]
["학부모후보등록시작일자","2021-03-08",null,"날짜형식입력(2020-01-01)"]
[null,{"$f":"YEAR(B95)","v":2021},"자동계산"]
[null,{"$f":"MONTH(B95)","v":3},"자동계산"]
[null,{"$f":"DAY(B95)","v":8},"자동계산"]
[null,{"$f":"TEXT(WEEKDAY(B95,1),\"aaa\")","v":"월"},"자동계산"]
["학부모후보등록마감일자","2021-03-10",{"$f":"B75-B94","v":"2021-03-12"}]
[null,{"$f":"YEAR(B100)","v":2021},"자동계산"]
[null,{"$f":"MONTH(B100)","v":3},"자동계산"]
[null,{"$f":"DAY(B100)","v":10},"자동계산"]
[null,{"$f":"TEXT(WEEKDAY(B100,1),\"aaa\")","v":"수"},"자동계산"]
["학부모선거공보기한",3]
["학부모선거공보일자","2021-03-11",{"$f":"B75-3","v":"2021-03-16"},"날짜형식입력(2020-01-01)"]
[null,{"$f":"YEAR(B106)","v":2021},"자동계산"]
[null,{"$f":"MONTH(B106)","v":3},"자동계산"]
[null,{"$f":"DAY(B106)","v":11},"자동계산"]
[null,{"$f":"TEXT(WEEKDAY(B106,1),\"aaa\")","v":"목"},"자동계산"]
["교원위원선거방법","교직원 전체회의에서 직접투표(온라인 설문조사 및 투표 병행)"]
["교원위원선거일자","2021-03-18",{"$f":"B34","v":"2021-03-21"},"날짜형식입력(2020-01-01)"]
[null,{"$f":"YEAR(B112)","v":2021},"자동계산"]
[null,{"$f":"MONTH(B112)","v":3},"자동계산"]
[null,{"$f":"DAY(B112)","v":18},"자동계산"]
[null,{"$f":"TEXT(WEEKDAY(B112,1),\"aaa\")","v":"목"},"자동계산"]
["교원위원선거시간","15:00",null,"24시간 시간형식입력(17:30)"]
["장소","교무실"]
["교원위원선거공고일자기준",15,"숫자만 입력"]
[null,"2021-03-03",{"$f":"B112-B119","v":"2021-03-03"},"날짜형식입력(2020-01-01)"]
[null,{"$f":"YEAR(B120)","v":2021},"자동계산"]
[null,{"$f":"MONTH(B120)","v":3},"자동계산"]
[null,{"$f":"DAY(B120)","v":3},"자동계산"]
[null,{"$f":"TEXT(WEEKDAY(B120,1),\"aaa\")","v":"수"},"자동계산"]
["교원위원후보 등록기한기준",7,"숫자만 입력"]
["교원위원후보등록시작일자","2021-03-09",null,"날짜형식입력(2020-01-01)"]
[null,{"$f":"YEAR(B126)","v":2021},"자동계산"]
[null,{"$f":"MONTH(B126)","v":3},"자동계산"]
[null,{"$f":"DAY(B126)","v":9},"자동계산"]
[null,{"$f":"TEXT(WEEKDAY(B126,1),\"aaa\")","v":"화"},"자동계산"]
["교원위원후보등록마감일자","2021-03-11",{"$f":"B112-B125","v":"2021-03-11"},"날짜형식입력(2020-01-01)"]
[null,{"$f":"YEAR(B131)","v":2021},"자동계산"]
[null,{"$f":"MONTH(B131)","v":3},"자동계산"]
[null,{"$f":"DAY(B131)","v":11},"자동계산"]
[null,{"$f":"TEXT(WEEKDAY(B131,1),\"aaa\")","v":"목"},"자동계산"]
["교원선거인 명부작성",{"$f":"B120","v":"2021-03-03"},"공고일자 기준","날짜형식입력(2020-01-01)"]
[null,{"$f":"YEAR(B136)","v":2021},"자동계산"]
[null,{"$f":"MONTH(B136)","v":3},"자동계산"]
[null,{"$f":"DAY(B136)","v":3},"자동계산"]
[null,{"$f":"TEXT(WEEKDAY(B136,1),\"aaa\")","v":"수"},"자동계산"]
["교원선거공보일자","2021-03-12",null,"날짜형식입력(2020-01-01)"]
[null,{"$f":"YEAR(B141)","v":2021},"자동계산"]
[null,{"$f":"MONTH(B141)","v":3},"자동계산"]
[null,{"$f":"DAY(B141)","v":12},"자동계산"]
[null,{"$f":"TEXT(WEEKDAY(B141,1),\"aaa\")","v":"금"},"자동계산"]
["학부모위원입후보자수",{"$f":"COUNTA(B147,B156,B165,B174,B183,B192,B201,B210,B219,B228)","v":10}]
["학부모위원입후보자1성명","김갑돌"]
["접수일자","2020-01-01",null,"날짜형식입력(2020-01-01)"]
["생년월일","1977-08-22",null,"날짜형식입력(2020-01-01)"]
["성별","남"]
["경력","운영위원"]
["학생 학년",1]
["학생반",2]
["학생 성명","김갑이"]
["주소","힐스테이츠"]
["학부모위원입후보자2성명","김갑순"]
["접수일자","2020-01-02",null,"날짜형식입력(2020-01-01)"]
["생년월일","1988-01-14",null,"날짜형식입력(2020-01-01)"]
["성별","남"]
["경력"]
["학생 학년",3]
["학생반",1]
["학생 성명","김순이"]
["주소","코아루"]
["학부모위원입후보자3 성명","김갑순"]
["접수일자","2020-01-02",null,"날짜형식입력(2020-01-01)"]
["생년월일","1988-01-14",null,"날짜형식입력(2020-01-01)"]
["성별","남"]
["경력"]
["학생 학년",3]
["학생반",1]
["학생 성명","김순이"]
["주소","코아루"]
["학부모위원입후보자4 성명","김갑순"]
["접수일자","2020-01-02",null,"날짜형식입력(2020-01-01)"]
["생년월일","1988-01-14",null,"날짜형식입력(2020-01-01)"]
["성별","남"]
["경력"]
["학생 학년",3]
["학생반",1]
["학생 성명","김순이"]
["주소","코아루"]
["학부모위원입후보자5 성명","김갑순"]
["접수일자","2020-01-02",null,"날짜형식입력(2020-01-01)"]
["생년월일","1988-01-14",null,"날짜형식입력(2020-01-01)"]
["성별","남"]
["경력"]
["학생 학년",3]
["학생반",1]
["학생 성명","김순이"]
["주소","코아루"]
["학부모위원입후보자6 성명","김갑순"]
["접수일자","2020-01-02",null,"날짜형식입력(2020-01-01)"]
["생년월일","1988-01-14",null,"날짜형식입력(2020-01-01)"]
["성별","남"]
["경력"]
["학생 학년",3]
["학생반",1]
["학생 성명","김순이"]
["주소","코아루"]
["학부모위원입후보자7 성명","김갑순"]
["접수일자","2020-01-02",null,"날짜형식입력(2020-01-01)"]
["생년월일","1988-01-14",null,"날짜형식입력(2020-01-01)"]
["성별","남"]
["경력"]
["학생 학년",3]
["학생반",1]
["학생 성명","김순이"]
["주소","코아루"]
["학부모위원입후보자8 성명","김갑순"]
["접수일자","2020-01-02",null,"날짜형식입력(2020-01-01)"]
["생년월일","1988-01-14",null,"날짜형식입력(2020-01-01)"]
["성별","남"]
["경력"]
["학생 학년",3]
["학생반",1]
["학생 성명","김순이"]
["주소","코아루"]
["학부모위원입후보자9 성명","김갑순"]
["접수일자","2020-01-02",null,"날짜형식입력(2020-01-01)"]
["생년월일","1988-01-14",null,"날짜형식입력(2020-01-01)"]
["성별","남"]
["경력"]
["학생 학년",3]
["학생반",1]
["학생 성명","김순이"]
["주소","코아루"]
["학부모위원입후보자10 성명","정갑돌"]
["접수일자","2020-01-02",null,"날짜형식입력(2020-01-01)"]
["생년월일","1988-01-14",null,"날짜형식입력(2020-01-01)"]
["성별","남"]
["경력"]
["학생 학년",3]
["학생반",1]
["학생 성명","김순이"]
["주소","코아루"]
["교원위원입후보자수",{"$f":"COUNTA(B238:B247)","v":4}]
["교원위원입후보자성명1","이교원"]
["교원위원입후보자성명2","정행정"]
["교원위원입후보자성명3","정교사"]
["교원위원입후보자성명4","박담당"]
["교원위원입후보자성명5"]
["교원위원입후보자성명6"]
["교원위원입후보자성명7"]
["교원위원입후보자성명8"]
["교원위원입후보자성명9"]
["교원위원입후보자성명10"]
["학부모위원당선자공고일자","2021-03-20",null,"날짜형식입력(2020-01-01)"]
[null,{"$f":"YEAR(B248)","v":2021}]
[null,{"$f":"MONTH(B248)","v":3}]
[null,{"$f":"DAY(B248)","v":20}]
[null,{"$f":"TEXT(WEEKDAY(B248,1),\"aaa\")","v":"토"}]
["학부모위원당선자수",{"$f":"COUNTA(B254,B263,B272,B281,B290,B299,B308,B317,B326,B335)","v":10},"자동계산"]
["학부모위원당선자1성명","김갑돌"]
["접수일자","2020-01-01",null,"날짜형식입력(2020-01-01)"]
["생년월일","1977-08-22",null,"날짜형식입력(2020-01-01)"]
["성별","남"]
["경력","운영위원"]
["학생 학년",1]
["학생반",2]
["학생 성명","김갑이"]
["주소","힐스테이츠"]
["학부모위원당선자2성명","김갑순"]
["접수일자","2020-01-02",null,"날짜형식입력(2020-01-01)"]
["생년월일","1988-01-14",null,"날짜형식입력(2020-01-01)"]
["성별","남"]
["경력"]
["학생 학년",3]
["학생반",1]
["학생 성명","김순이"]
["주소","코아루"]
["학부모위원당선자3성명","김갑순"]
["접수일자","2020-01-02",null,"날짜형식입력(2020-01-01)"]
["생년월일","1988-01-14",null,"날짜형식입력(2020-01-01)"]
["성별","남"]
["경력"]
["학생 학년",3]
["학생반",1]
["학생 성명","김순이"]
["주소","코아루"]
["학부모위원당선자4성명","김갑순"]
["접수일자","2020-01-02",null,"날짜형식입력(2020-01-01)"]
["생년월일","1988-01-14",null,"날짜형식입력(2020-01-01)"]
["성별","남"]
["경력"]
["학생 학년",3]
["학생반",1]
["학생 성명","김순이"]
["주소","코아루"]
["학부모위원당선자5성명","김갑순"]
["접수일자","2020-01-02",null,"날짜형식입력(2020-01-01)"]
["생년월일","1988-01-14",null,"날짜형식입력(2020-01-01)"]
["성별","남"]
["경력"]
["학생 학년",3]
["학생반",1]
["학생 성명","김순이"]
["주소","코아루"]
["학부모위원당선자6성명","김갑순"]
["접수일자","2020-01-02",null,"날짜형식입력(2020-01-01)"]
["생년월일","1988-01-14",null,"날짜형식입력(2020-01-01)"]
["성별","남"]
["경력"]
["학생 학년",3]
["학생반",1]
["학생 성명","김순이"]
["주소","코아루"]
["학부모위원당선자7성명","김갑순"]
["접수일자","2020-01-02",null,"날짜형식입력(2020-01-01)"]
["생년월일","1988-01-14",null,"날짜형식입력(2020-01-01)"]
["성별","남"]
["경력"]
["학생 학년",3]
["학생반",1]
["학생 성명","김순이"]
["주소","코아루"]
["학부모위원당선자8성명","김갑순"]
["접수일자","2020-01-02",null,"날짜형식입력(2020-01-01)"]
["생년월일","1988-01-14",null,"날짜형식입력(2020-01-01)"]
["성별","남"]
["경력"]
["학생 학년",3]
["학생반",1]
["학생 성명","김순이"]
["주소","코아루"]
["학부모위원당선자9성명","김갑순"]
["접수일자","2020-01-02",null,"날짜형식입력(2020-01-01)"]
["생년월일","1988-01-14",null,"날짜형식입력(2020-01-01)"]
["성별","남"]
["경력"]
["학생 학년",3]
["학생반",1]
["학생 성명","김순이"]
["주소","코아루"]
["학부모위원당선자10성명","정갑돌"]
["접수일자","2020-01-02",null,"날짜형식입력(2020-01-01)"]
["생년월일","1988-01-14",null,"날짜형식입력(2020-01-01)"]
["성별","남"]
["경력"]
["학생 학년",3]
["학생반",1]
["학생 성명","김순이"]
["주소","코아루"]
["교원위원당선자1 성명","김행정"]
["교원위원당선자2 성명","김교무"]
["교원위원당선자3 성명","김연구"]
["교원위원당선자4 성명","김안전"]
["교원위원당선자5 성명"]
["교원위원당선자6 성명"]
["교원위원당선자7 성명"]
["교원위원당선자8 성명"]
["교원위원당선자9 성명"]
["교원위원당선자10 성명"]
["지역위원당선자1성명"]
["지역위원당선자2성명"]
["지역위원당선자3성명"]