{"text_format":"3","workbook":"xls","n_sheets":8,"sheets":["학교회계예산 총괄표","정현원표","학급편성표및 학생수 조서","과년도수입금 미 수입액 조서","학교회계 세출예산 성질조사표","수업료및 학교운영비 징수결정현황","수익자부담교육비 징수액 산출근거","학교 회계 직원 퇴직금 적립 현황"],"not_rendered":{"external_links":1},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"학교회계예산 총괄표","index":0,"n_rows":17,"n_cols":8,"rows_kept":17,"merged":[[0,0,0,7],[3,0,3,3],[3,4,3,7],[5,1,6,1],[5,2,6,2],[5,3,6,3],[5,4,6,4],[5,5,6,5],[5,6,6,6],[5,7,6,7]],"flags":["formulas_cached_only"]}
["2009학년도 학교회계 예산 총괄표"]
[]
["동화중학교",{"$nulls":6},"(단위:천원)"]
["세 입 결 산",{"$nulls":3},"세 출 결 산"]
["관별","2009예산액","2008예산액","비교증감","관별","2009예산액","2008예산액","비교증감"]
["사용료 및",300,300,0,"인 건 비",{"v":2685549,"d":"2,685,549"},{"v":2614992,"d":"2,614,992"},{"v":70557,"d":"70,557"}]
["수 수 료"]
["전 입 금",{"v":75000,"d":"75,000"},{"v":25500,"d":"25,500"},{"v":49500,"d":"49,500"},"관리운영비",{"v":243050,"d":"243,050"},{"v":362290,"d":"362,290"},{"v":-119240,"d":"-119,240 "}]
["원조\n보조금",{"v":2623118,"d":"2,623,118"},{"v":3661630,"d":"3,661,630"},{"v":-1038512,"d":"-1,038,512 "},"연구장학비",0,0,0]
["이 월 금",{"v":268181,"d":"268,181"},{"v":102400,"d":"102,400"},{"v":165781,"d":"165,781"},"입시관리비",0,0,0]
["과년도수입",0,0,0,"재산조성비",{"v":36000,"d":"36,000"},{"v":810548,"d":"810,548"},{"v":-774548,"d":"-774,548 "}]
["적 립 금",0,0,0,"적 립 금",0,0,0]
["차 입 금",0,0,0,"과년도지출",0,0,0]
["학교운영지원비",{"v":583502,"d":"583,502"},{"v":569482,"d":"569,482"},{"v":14020,"d":"14,020"},"상환반환금",0,0,0]
["잡 수 입",{"v":1000,"d":"1,000"},{"v":1000,"d":"1,000"},0,"예 비 비",{"v":3000,"d":"3,000"},{"v":3000,"d":"3,000"},0]
[{"$nulls":3},0,"학교운영지원비",{"v":583502,"d":"583,502"},{"v":569482,"d":"569,482"},{"v":14020,"d":"14,020"}]
["계",{"v":3551101,"d":"3,551,101"},{"v":4360312,"d":"4,360,312"},{"v":-809211,"d":"-809,211 "},"계",{"v":3551101,"d":"3,551,101"},{"v":4360312,"d":"4,360,312"},{"v":-809211,"d":"-809,211 "}]

{"sheet":"정현원표","index":1,"n_rows":9,"n_cols":16,"rows_kept":9,"merged":[[0,0,0,15],[2,13,2,15],[3,0,5,0],[3,1,3,5],[3,6,3,11],[3,12,3,14],[3,15,5,15],[4,1,5,1],[4,2,5,2],[4,3,5,3],[4,4,5,4],[4,5,5,5],[4,6,5,6],[4,7,5,7],[4,8,5,8],[4,9,5,9],[4,10,5,10],[4,11,5,11],[4,14,5,14]],"flags":["formulas_cached_only"]}
["정・현원표"]
[]
[{"$nulls":13},"동화중학교"]
["구분","교원",{"$nulls":4},"일반직",{"$nulls":5},"기능직",null,null,"합계"]
[null,"교장","교감","주임","교사","소계","5급","6급","7급","8급","9급","소계",9,10,"소계"]
[{"$nulls":12},"등급","등급"]
["정원",1,1,10,33,45,1,null,null,1,0,2,1,2,3,50]
["현원",1,1,10,33,45,1,null,null,1,0,2,1,2,3,50]
["중감",0,0,0,0,0,0,null,null,0,0,0,0,0,0,0]

{"sheet":"학급편성표및 학생수 조서","index":2,"n_rows":8,"n_cols":6,"rows_kept":8,"merged":[[0,0,0,5],[2,0,3,0],[2,1,2,2],[2,3,2,4],[2,5,3,5]],"flags":["formulas_cached_only"]}
["학급편성표 및 학생수 조서"]
["동화중학교"]
["학년별","학급수",null,"학생수",null,"비고"]
[null,"인가","편성","정원","편성"]
["1학년",6,6,250,250]
["2학년",12,12,442,442]
["3학년",8,8,296,296]
["계",26,26,988,988]

{"sheet":"과년도수입금 미 수입액 조서","index":3,"n_rows":9,"n_cols":8,"rows_kept":9,"merged":[[0,0,1,7],[6,0,6,2],[6,3,7,3],[6,4,7,4],[6,5,7,5],[6,6,7,6],[6,7,7,7]],"flags":["formulas_cached_only"]}
["과년도 수입금 미 수입액 조서"]
[]
[]
[]
[]
["동화중학교",{"$nulls":6},"(단위:천원)"]
["과목",null,null,"예산액","징수결정액","수입액","미수입액","산출기초(원)"]
["관","항","목"]
["과년도수입","과년도수입","납교금",{"v":1776,"d":"1,776"},{"v":1776,"d":"1,776"},0,{"v":1776,"d":"1,776"},"44,000 x 40명 \n= 1,776,000"]

{"sheet":"학교회계 세출예산 성질조사표","index":4,"n_rows":38,"n_cols":5,"rows_kept":38,"merged":[[0,0,1,4],[4,0,4,1],[4,2,4,4]],"flags":["formulas_cached_only"]}
["학교 회계 세출 예산 성질조사표"]
[]
[]
["동화중학교",{"$nulls":3},"(단위 : 천원)"]
["구분",null,"예산성질별내역"]
["관명","과목명","결산액","관   내\n구성비","전   체\n구성비"]
["인건비","교원봉급",{"v":1452267,"d":"1,452,267"},{"v":54.077099319357046,"d":"54.1"},{"v":40.89624598117598,"d":"40.9"}]
[null,"사무원봉급",{"v":103521,"d":"103,521"},{"v":3.8547425498473493,"d":"3.9"},{"v":2.915180390532401,"d":"2.9"}]
[null,"교원수당",{"v":268976,"d":"268,976"},{"v":10.015680220319942,"d":"10.0"},{"v":7.574439589299206,"d":"7.6"}]
[null,"사무원수당",{"v":12201,"d":"12,201"},{"v":0.45432051323584116,"d":"0.5"},{"v":0.34358358154273844,"d":"0.3"}]
[null,"연금부담금",{"v":79478,"d":"79,478"},{"v":2.9594693673435115,"d":"3.0"},{"v":2.2381227681217744,"d":"2.2"}]
[null,"건강보험부담금",{"v":38945,"d":"38,945"},{"v":1.450169034338975,"d":"1.5"},{"v":1.0967021213984056,"d":"1.1"}]
[null,"재해보상부담금",{"v":5853,"d":"5,853"},{"v":0.21794426391028424,"d":"0.2"},{"v":0.1648221213646134,"d":"0.2"}]
[null,"초과근무수당",{"v":58758,"d":"58,758"},{"v":2.18793252329412,"d":"2.2"},{"v":1.6546417575844785,"d":"1.7"}]
[null,"복리후생비",{"v":519256,"d":"519,256"},{"v":19.335189936955164,"d":"19.3"},{"v":14.622394575654143,"d":"14.6"}]
[null,"기타수당",{"v":146294,"d":"146,294"},{"v":5.447452271397767,"d":"5.4"},{"v":4.119680065421964,"d":"4.1"}]
[null,"소계",{"v":2685549,"d":"2,685,549"},{"v":100,"d":"100.0"},{"v":75.6258129520957,"d":"75.6"}]
["관리운영비","공통운영비",{"v":197450,"d":"197,450"},65.6,{"v":5.560247371167422,"d":"5.6"}]
[null,"교수학습활동비",{"v":45600,"d":"45,600"},34.4,{"v":1.2841087876689512,"d":"1.3"}]
[null,"소계",{"v":243050,"d":"243,050"},{"v":100,"d":"100.0"},{"v":6.844356158836372,"d":"6.8"}]
["재산조성비","시설비",{"v":36000,"d":"36,000"},{"v":100,"d":"100.0"},{"v":1.0137700955281195,"d":"1.0"}]
[null,"소계",{"v":36000,"d":"36,000"},{"v":100,"d":"100.0"},{"v":1.0137700955281195,"d":"1.0"}]
["예비비","예비비",{"v":3000,"d":"3,000"},{"v":100,"d":"100.0"},{"v":0.08448084129400994,"d":"0.1"}]
[null,"소계",{"v":3000,"d":"3,000"},{"v":100,"d":"100.0"},{"v":0.08448084129400994,"d":"0.1"}]
["학교운영지원비","교원연구비",{"v":30360,"d":"30,360"},{"v":5.203066998913457,"d":"5.2"},{"v":0.8549461138953807,"d":"0.9"}]
[null,"학생복리비",{"v":31600,"d":"31,600"},{"v":5.41557698174128,"d":"5.4"},{"v":0.8898648616302381,"d":"0.9"}]
[null,"관리수당",{"v":4560,"d":"4,560"},{"v":0.7814883239474758,"d":"0.8"},{"v":0.1284108787668951,"d":"0.1"}]
[null,"학교회계직원수당",{"v":23463,"d":"23,463"},{"v":4.0210659089429,"d":"4.0"},{"v":0.6607246597604518,"d":"0.7"}]
[null,"퇴직급여",{"v":1100,"d":"1,100"},{"v":0.18851692025048758,"d":"0.2"},{"v":0.03097630847447031,"d":"0.0"}]
[null,"일반운영비",{"v":33600,"d":"33,600"},{"v":5.758335018560348,"d":"5.8"},{"v":0.9461854224929114,"d":"0.9"}]
[null,"학교교육비",{"v":20200,"d":"20,200"},{"v":3.4618561718725895,"d":"3.5"},{"v":0.5688376647130002,"d":"0.6"}]
[null,"시설비",{"v":15219,"d":"15,219"},{"v":2.6082172811747,"d":"2.6"},{"v":0.4285713078845124,"d":"0.4"}]
[null,"특기적성비",{"v":1400,"d":"1,400"},{"v":0.2399306257733478,"d":"0.2"},{"v":0.03942439260387131,"d":"0.0"}]
[null,"현장학습비",{"v":46000,"d":"46,000"},{"v":7.883434846838572,"d":"7.9"},{"v":1.2953728998414857,"d":"1.3"}]
[null,"앨범비",{"v":16000,"d":"16,000"},{"v":2.7420642945525464,"d":"2.7"},{"v":0.4505644869013864,"d":"0.5"}]
[null,"급식비",{"v":360000,"d":"360,000"},{"v":61.6964466274323,"d":"61.7"},{"v":10.137700955281193,"d":"10.1"}]
[null,"소계",{"v":583502,"d":"583,502"},{"v":100,"d":"100.0"},{"v":16.431579952245798,"d":"16.4"}]
[null,"총계",{"v":3551101,"d":"3,551,101"},{"v":100,"d":"100.0"},{"v":100,"d":"100.0"}]

{"sheet":"수업료및 학교운영비 징수결정현황","index":5,"n_rows":15,"n_cols":12,"rows_kept":15,"merged":[[0,0,1,11],[4,10,4,11],[5,0,6,1],[5,2,5,3],[5,4,5,5],[5,6,5,7],[5,8,5,9],[5,10,5,11],[7,0,8,0],[9,0,10,0],[11,0,12,0],[13,0,14,0]],"flags":["formulas_cached_only"]}
[" 수업료 및 학교운영지원비 징수 결정 현황"]
[]
[]
[null,"2009년 예산"]
["동화중학교",{"$nulls":9},"(단위 : 천원)"]
["       구분\n\n\n  학년별",null,"학생수 및 총액\n(A)",null,"전 액 면 제\n(B)",null,"부 분 면 제\n(C)",null,"잔 액 징 수\n(D=A-B)",null,"징 수 액 계\n(E=D+C)"]
[null,null,"학생수","금액","학생수","금액","학생수","금액","학생수","금액","학생수","금액"]
[1,"회비수입",280,{"v":49728,"d":"49,728"},7,{"v":1243,"d":"1,243"},"-","-",273,{"v":48485,"d":"48,485"},273,{"v":48485,"d":"48,485"}]
[null,"계",null,{"v":49728,"d":"49,728"},null,{"v":1243,"d":"1,243"},null,"-",null,{"v":48485,"d":"48,485"},null,{"v":48485,"d":"48,485"}]
[2,"회비수입",248,{"v":44044,"d":"44,044"},5,888,"-","-",243,{"v":43156,"d":"43,156"},243,{"v":43156,"d":"43,156"}]
[null,"계",null,{"v":44044,"d":"44,044"},null,888,null,"-",null,{"v":43156,"d":"43,156"},null,{"v":43156,"d":"43,156"}]
[3,"회비수입",441,{"v":78321,"d":"78,321"},12,{"v":2131,"d":"2,131"},"-","-",429,{"v":76190,"d":"76,190"},429,{"v":76190,"d":"76,190"}]
[null,"계",null,{"v":78321,"d":"78,321"},null,{"v":2131,"d":"2,131"},null,"-",null,{"v":76190,"d":"76,190"},null,{"v":76190,"d":"76,190"}]
["계","회비수입",969,{"v":172093,"d":"172,093"},24,{"v":4262,"d":"4,262"},"-","-",945,{"v":167831,"d":"167,831"},945,{"v":167831,"d":"167,831"}]
[null,"계",null,{"v":172093,"d":"172,093"},24,{"v":4262,"d":"4,262"},0,"-",945,{"v":167831,"d":"167,831"},945,{"v":167831,"d":"167,831"}]

{"sheet":"수익자부담교육비 징수액 산출근거","index":6,"n_rows":18,"n_cols":9,"rows_kept":18,"merged":[[0,0,0,8],[3,0,5,0],[3,1,5,1],[3,2,3,3],[3,5,3,6],[3,7,3,8],[4,2,5,2],[4,3,5,3],[4,5,5,5],[4,6,5,6],[4,7,5,7],[6,0,7,0],[6,1,7,1],[6,2,7,2],[6,3,7,3],[6,4,7,4],[6,5,7,5],[6,7,7,7],[6,8,7,8],[8,0,10,0],[8,1,10,1],[8,2,10,2],[8,3,10,3],[8,4,10,4],[8,5,10,5],[8,7,10,7],[8,8,10,8],[11,0,12,0],[11,1,12,1],[11,2,12,2],[11,3,12,3],[11,4,12,4],[11,5,12,5],[11,7,12,7],[11,8,12,8],[13,0,14,0],[13,1,14,1],[13,2,14,2],[13,3,14,3],[13,4,14,4],[13,5,14,5],[13,6,14,6],[13,7,14,7],[13,8,14,8]],"flags":["formulas_cached_only"]}
["수익자 부담 교육비 징수액 산출 근거"]
[]
["동화중학교",{"$nulls":7},"(단위 : 원)"]
["교육\n활동명","횟수","실시기간",null,"실시","세 출",null,"세 입"]
[null,null,"부터","까지","기간","소요예산액(A)","산출세부내역","참여학생수(B)","1인당"]
[{"$nulls":8},"부담액(A/B)"]
["특기적성\n교육비",12,"2009.03.01","2010.02.28","1년",{"v":1400000,"d":"1,400,000"},"10,000 x 2개월x 70명",70,{"v":20000,"d":"20,000"}]
[]
["수학여행경비",1,"2009.04.01","2009.04.03","2박3일",{"v":25000000,"d":"25,000,000"},{"v":100000,"d":"100,000"},250,{"v":100000,"d":"100,000"}]
[{"$nulls":6},"x 250명"]
[{"$nulls":6}," =25,000,000"]
["극기훈련비",1,"2009.04.01","2009.04.03","2박3일",{"v":21000000,"d":"21,000,000"},"70,000 x 300명",300,{"v":70000,"d":"70,000"}]
[{"$nulls":6}," =21,000,000"]
["앨범비",1,{"$nulls":3},{"v":16000000,"d":"16,000,000"},"50,000 x 8개월 x 900명\n=16,000,000",400,{"v":40000,"d":"40,000"}]
[]
["급식비",8,"2009.03.01","2010.02.28","1년",{"v":360000000,"d":"360,000,000"},"50,000 x 9개월 x 900명\n=360,000,000",900,{"v":400000,"d":"400,000"}]
[]
["계",{"$nulls":4},{"v":423400000,"d":"423,400,000"},null,null,{"v":630000,"d":"630,000"}]

{"sheet":"학교 회계 직원 퇴직금 적립 현황","index":7,"n_rows":11,"n_cols":12,"rows_kept":11,"merged":[[0,0,0,11],[3,10,3,11],[4,1,5,4],[4,5,5,7],[4,8,5,9],[4,11,7,11],[6,4,7,4],[6,7,7,7],[6,9,7,9],[8,1,9,1],[8,2,9,2],[8,3,9,3],[8,4,9,4],[8,5,9,5],[8,6,9,6],[8,7,9,7],[8,8,9,8],[8,9,9,9],[8,10,9,10]],"flags":["formulas_cached_only"]}
["2009학년도 학교 회계 직원 퇴직금 적립 현황"]
[]
[]
["동화중학교",{"$nulls":9},"(단위:원)"]
["구분","기적립현황",{"$nulls":3},"2008학년도 적립현황",null,null,"2009학년도\n퇴직금 지급",null,"적립금","비고"]
[{"$nulls":10},"이월금"]
["직종별","적립","퇴직","예금","소계","적립","퇴직금","적립액","지급","지급액"]
[null,"인원","적립금","이자",null,"인원","예산액",null,"인원"]
["사무",{"$nulls":3},0,1,{"v":1000000,"d":"1,000,000"},{"v":1000000,"d":"1,000,000"},1,{"v":1100000,"d":"1,100,000"},{"v":2100000,"d":"2,100,000"}]
["보조"]
["계",{"$nulls":6},{"v":1000000,"d":"1,000,000"},null,{"v":1100000,"d":"1,100,000"},{"v":2100000,"d":"2,100,000"}]