{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["기본작업-1","기본작업-2","기본작업-3","계산작업","시나리오 요약","분석작업-1","분석작업-2","매크로작업","차트작업"],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":0,"defined_names":4,"comments":1,"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":"기본작업-1","index":0,"n_rows":7,"n_cols":7,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["상공마트 인사기록"]
[]
["사번","성명","부서","입사일자","직통번호","주소지","실적"]
["Jmk-3585","김충희","경리부","2015-05-18","02) 302-4915","강북구 삼양동",12530]
["Gpc-2273","박선종","식품부","2017-02-18","02) 853-1520","도봉구 쌍문동",35127]
["Aud-3927","이국명","총무부","2016-03-01","02) 652-4593","마포구 도화동",65238]
["Sbu-4528","최미란","가전부","2018-11-15","02) 526-2694","성북구 돈암동",58260]

{"sheet":"기본작업-2","index":1,"n_rows":13,"n_cols":8,"rows_kept":13,"cut":false,"hidden":false,"merged":[[2,7,3,7],[4,0,5,0],[6,0,8,0],[9,0,11,0],[12,0,12,1],[2,0,3,0],[2,1,3,1],[2,2,2,3],[2,5,2,6]]}
["상공유통 3월 라면류 매출현황"]
[]
["제품군","제품명","강북",null,"강서","경기",null,"제품별합계"]
[null,null,"삼양마트","수유마트","화곡마트","김포마트","강화마트"]
["짜장","왕짜장면",25,58,56,32,24,{"$f":"SUM(C5:G5)","v":195}]
[null,"첨짜장면",52,36,27,47,36,{"$f":"SUM(C6:G6)","v":198}]
["짬뽕","왕짬뽕면",125,156,204,157,347,989]
[null,"첨짬뽕면",34,62,62,34,82,274]
[null,"핫짬뽕면",85,36,75,64,28,288]
["비빔면","열무비빔면",68,92,51,73,54,338]
[null,"고추장면",31,30,42,17,25,145]
[null,"메밀면",106,88,124,64,72,454]
["마트별합계",null,{"$f":"SUM(C5:C12)","v":526},{"$f":"SUM(D5:D12)","v":558},641,488,668,2881]

{"sheet":"기본작업-3","index":2,"n_rows":15,"n_cols":7,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
["상공상사 3월분 급여지급명세서"]
[]
["사번","성명","직위","기본급","제수당","상여금","총급여"]
["SJ01-023","민제필","부장",4273000,882000,{"$f":"D4*0.25","v":1068250},{"$f":"SUM(D4:F4)","v":6223250}]
["SJ04-012","나일형","과장",3697000,724000,{"$f":"D5*0.25","v":924250},{"$f":"SUM(D5:F5)","v":5345250}]
["SJ11-002","제선영","주임",2856000,430000,714000,4000000]
["SJ10-021","박민준","대리",3047000,524000,761750,4332750]
["SJ09-015","최세연","대리",3140000,480000,785000,4405000]
["SJ13-007","장태현","사원",2510000,320000,627500,3457500]
["SJ06-019","추양선","과장",3506000,542000,876500,4924500]
["SJ08-004","피종현","대리",3200000,360000,800000,4360000]
["SJ12-031","김나리","주임",2734000,324000,683500,3741500]
["SJ12-012","이정선","사원",2473000,268000,618250,3359250]
["SJ13-003","박청국","주임",2810000,302000,702500,3814500]
["SJ09-001","김평순","대리",2980000,347000,745000,4072000]

{"sheet":"계산작업","index":3,"n_rows":39,"n_cols":10,"rows_kept":39,"cut":false,"hidden":false,"merged":[[11,5,12,8],[11,9,12,9]]}
["[표1]",null,null,null,null,"[표2]"]
["지점","이름","매출액","순위",null,"이름","부서","직위","기본급","상여금"]
["동부","김연주",28561500,null,null,"박영덕","영업부","부장",3560000,2512000]
["서부","홍기민",38651200,null,null,"주민경","생산부","과장",3256000,1826000]
["남부","채동식",19560000,null,null,"태진형","총무부","사원",2560000,1282000]
["북부","이민섭",32470000,null,null,"최민수","생산부","대리",3075000,1568000]
["서부","길기훈",56587200,"1위",null,"김평주","생산부","주임",2856000,1240000]
["남부","남재영",36521700,null,null,"한서라","영업부","사원",2473000,1195000]
["동부","민기영",52438600,"2위",null,"이국선","총무부","사원",2372000,1153000]
["북부","박소연",37542300,null,null,"송나정","영업부","주임",2903000,1200000]
[]
["지점",null,"동부지점 합계",null,null,"상여금이 1,200,000원 보다 크면서, \n평균기본급이상인 인원수",null,null,null,{"$f":"COUNTIFS(J3:J10,\">1200000\", I3:I10,\">=\"&AVERAGE(I3:I10))&\"명\"","v":"3명"}]
["동부",null,{"$f":"ROUNDUP(DSUM(A2:D10,C2,A12:A13),-3)","v":81001000}]
[]
["[표3]",null,null,null,null,"[표4]"]
["학번","이름","주민등록번호","성별",null,"이름","국사","상식","총점","순위"]
["M1602001","이민영","990218-2304567",{"$f":"CHOOSE(MID(C17,8,1),\"남\",\"여\",\"남\",\"여\")","v":"여"},null,"이후정",82,94,{"$f":"SUM(G17:H17)","v":176},{"$f":"IF(LARGE($I$17:$I$24,1)=I17,\"최우수\",IF(LARGE($I$17:$I$24,2)=I17,\"우수\",\"\"))","v":"우수"}]
["M1602002","도홍진","010802-3065821",{"$f":"CHOOSE(MID(C18,8,1),\"남\",\"여\",\"남\",\"여\")","v":"남"},null,"백천경",63,83,146,""]
["M1602003","박수진","011115-4356712","여",null,"민경배",76,86,162,""]
["M1602004","최만수","980723-1935645","남",null,"김태하",62,88,150,""]
["M1602005","조용덕","991225-1328650","남",null,"이사랑",92,96,188,"최우수"]
["M1602006","김태훈","021222-3264328","남",null,"곽난영",85,80,165,""]
["M1602007","편승주","010123-3652942","남",null,"장채리",62,77,139,""]
["M1602008","곽나래","001015-4685201","여",null,"봉전미",73,68,141,""]
[]
[]
["[표5]"]
["원서번호","이름","거주지","지원학과"]
["M-120","이민수","서울시 강북구",{"$f":"IFERROR(HLOOKUP(LEFT(A29,1),$B$38:$D$39,2,FALSE),\"코드오류\")","v":"멀티미디어"}]
["N-082","김병훈","대전시 대덕구",{"$f":"IFERROR(HLOOKUP(LEFT(A30,1),$B$38:$D$39,2,FALSE),\"코드오류\")","v":"네트워크"}]
["S-035","최주영","인천시 남동구","소프트웨어"]
["M-072","길미라","서울시 성북구","멀티미디어"]
["S-141","나태후","경기도 김포시","소프트웨어"]
["N-033","전영태","경기도 고양시","네트워크"]
["M-037","조영선","강원도 춘천시","멀티미디어"]
["A-028","박민혜","서울시 마포구","코드오류"]
[]
["학과코드","S","N","M"]
["학 과 명","소프트웨어","네트워크","멀티미디어"]

{"sheet":"시나리오 요약","index":4,"n_rows":11,"n_cols":6,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[]
[null,"시나리오 요약"]
[null,null,null,"현재 값:","비율인상","비율인하"]
[null,null,null,null,"만든 사람 Name 날짜 2012-03-03\n수정한 사람 Mihyun Chung 날짜 2020-07-06","만든 사람 Name 날짜 2012-03-03"]
[null,"변경 셀:"]
[null,null,"집행률계",62.443791869321799,80,50]
[null,"결과 셀:"]
[null,null,"집행액합계",845027.48228870297,1082608.8,676630.5]
[null,"참고: 현재 값 열은 시나리오 요약 보고서가 작성될 때의"]
[null,"변경 셀 값을 나타냅니다. 각 시나리오의 변경 셀들은"]
[null,"회색으로 표시됩니다."]

{"sheet":"분석작업-1","index":5,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["[표1] 공영개발 예산과목별 집행현황"]
[]
["항목","예산","집행액","집행률"]
["인건비",221653,{"$f":"B4*D4/100","v":83563.181000000011},37.700000000000003]
["사무관리비",15000,12745.5,84.97]
["공공운영비",21827,8453.597099999999,38.729999999999997]
["국내여비",9720,1922.616,19.78]
["예비비",2347,0,0]
["시설비",1082714,275767.25579999998,25.47]
["합계",{"$f":"SUM(B4:B9)","v":1353261},{"$f":"B10*D10/100","v":845027.48228870286},62.443791869321799]

{"sheet":"분석작업-2","index":6,"n_rows":17,"n_cols":7,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
["[표1] 상공상사 야구동호회 회원명부"]
[]
["포지션","이름","부서","나이","가입기간","참여도","비고"]
["투수","이해탁","총무부",32,"6년","A급"]
["투수","왕전빈","경리부",26,"1년","C급"]
["투수","주병선","생산부",28,"2년","B급"]
["포수","김신수","생산부",30,"6년","B급"]
["포수","허웅진","구매부",34,"8년","A급","감독"]
["내야수","박평천","총무부",43,"8년","A급","회장"]
["내야수","갈문주","생산부",31,"4년","C급"]
["내야수","민조항","영업부",27,"3년","B급"]
["내야수","최배훈","영업부",26,"1년","A급"]
["외야수","길주병","생산부",41,"8년","C급"]
["외야수","김빈우","경리부",32,"5년","A급","총무"]
["외야수","한민국","구매부",33,"7년","B급"]
["외야수","나대영","생산부",26,"2년","A급"]
["외야수","편대민","영업부",28,"4년","B급"]

{"sheet":"매크로작업","index":7,"n_rows":14,"n_cols":14,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["[표1] 발화요인에 대한 월별 화재 발생건수 현황"]
[]
["발화요인","1월","2월","3월","4월","5월","6월","7월","8월","9월","10월","11월","12월","평균"]
["전기적요인",1239,1006,853,786,795,835,1156,924,683,664,763,959,{"$f":"AVERAGE(B4:M4)","v":888.58333333333337}]
["기계적요인",537,372,332,330,306,265,313,289,306,320,292,410,{"$f":"AVERAGE(B5:M5)","v":339.33333333333331}]
["화학적요인",26,26,22,28,19,36,28,26,26,14,30,18,24.916666666666668]
["가스누출",26,22,8,19,13,16,17,17,11,23,23,22,18.083333333333332]
["교통사고",55,33,43,42,43,47,42,40,41,45,47,54,44.333333333333336]
["부주의",2306,2173,3210,2470,1468,1399,738,704,1269,1397,1258,1846,1686.5]
["기타(실화)",103,79,96,84,53,52,52,54,50,66,69,103,71.75]
["자연적요인",4,2,3,102,22,36,101,81,14,14,4,3,32.166666666666664]
["방화",38,43,56,48,54,29,38,29,38,42,38,35,40.666666666666664]
["방화의심",148,149,209,198,167,132,98,102,125,144,166,124,146.83333333333334]
["미상",521,420,430,428,313,327,247,221,306,345,344,455,363.08333333333331]

{"sheet":"차트작업","index":8,"n_rows":7,"n_cols":6,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["정보통신서비스별 세부인력"]
[]
["서비스","2016년","2017년","2018년","2019년","2019년"]
["기간통신서비스",45010,43023,43848,43454,43755]
["별정통신서비스",6158,6268,6400,6664,6702]
["부가통신서비스",28628,40404,43044,50824,52981]
["방송서비스",28395,28484,27048,26714,26383]