{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["기본작업-1","기본작업-2","기본작업-3","계산작업","분석작업-1","분석작업-2","매크로작업","차트작업"],"not_rendered":{"charts":1,"images":0,"macros":0,"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":"기본작업-1","index":0,"n_rows":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["국제컨벤션센터 행사 예약현황"]

{"sheet":"기본작업-2","index":1,"n_rows":13,"n_cols":6,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["홈쇼핑 매출 현황"]
[]
["구분","상품코드","상품명","방송일","가격","판매량"]
["출산/유아동","B-82763","Snow Buddy","2021-09-18",29800,2685]
[null,"B-68528","창의력 수학교구","2021-09-18",39800,2071]
["식품","F-10835","명작 볶음밥","2021-09-13",50080,1254]
[null,"F-82568","부대찌개","2021-09-13",19910,1385]
["의류","W-37623","블라우스 3종","2021-09-14",31960,2462]
[null,"W-76612","카라 버튼 롱 자켓","2021-09-15",26980,1668]
["뷰티","B-82856","펄샤이닝샴푸","2021-09-15",48000,2136]
[null,"B-28685","루비아이크림","2021-09-17",97000,2299]
["생활/주방","L-72587","후라이팬 세트","2021-09-17",52120,1674]
[null,"L-35727","스텐 냄비세트 5종","2021-09-17",194900,1184]

{"sheet":"기본작업-3","index":2,"n_rows":15,"n_cols":6,"rows_kept":15,"cut":false,"hidden":false,"merged":[[0,0,0,5]]}
["코스닥 주요시세정보"]
[]
["종목명","종가","전일비","등락률(%)","시가총액(억원)","상장주식수"]
["셀트리온헬스케어",71100,"100(↑)",0.14000000000000001,99914,140527]
["신라젠",64800,"1,600(↓)",-0.72,45658,70460]
["바이로메드",266500,"3,700(↓)",-1.37,42523,15956]
["포스코메미칼",62000,"500(↑)",0.81,36623,59070]
["메디톡스",610200,"11,500(↓)",-1.85,34516,5657]
["에이치엘비",84900,"1,600(↓)",-1.85,33311,39235]
["CJ ENM",221800,"1,600(↓)",-0.72,48639,21929]
["펄어비스",187400,"3,800(↑)",2.0699999999999998,24391,13016]
["SK머티리얼즈",172100,"1,100(↑)",0.64,18153,10548]
["휴젤",407900,"7,900(↑)",1.98,17777,4358]
["파라다이스",18800,"150(↓)",-0.79,17097,90943]
["제넥신",79100,"1,400(↓)",-1.74,16172,20445]

{"sheet":"계산작업","index":3,"n_rows":38,"n_cols":11,"rows_kept":38,"cut":false,"hidden":false,"merged":[[11,0,11,4],[11,6,11,9],[12,0,12,4]]}
["[표1]","제품 재고 현황",null,null,null,null,"[표2]","임금지급표"]
["제품코드","생산원가","입고량","판매량","재고량",null,"성명","부서명","직위","호봉","기본급"]
["COD-101",16500,220,189,{"$f":"C3-D3","v":31},null,"김영식","생산부","대리",3,2198000]
["COD-102",19500,220,207,{"$f":"C4-D4","v":13},null,"유현진","생산부","사원",3,1856000]
["COD-103",22500,220,198,22,null,"한신영","생산부","과장",2,2477000]
["COD-201",13500,220,199,21,null,"박성민","영업부","대리",1,1964000]
["COD-202",15500,220,170,50,null,"전현중","영업부","사원",2,1697000]
["COD-203",17500,220,152,68,null,"강서희","영업부","과장",5,2897000]
["COD-301",11500,220,194,26,null,"임청아","홍보부","대리",3,2195000]
["COD-302",14500,220,201,19,null,"김상호","홍보부","사원",2,1699000]
["COD-303",16500,220,180,40,null,"윤다희","홍보부","과장",4,2695000]
["평균판매량 이상이면서 재고량이 20 미만인 수",null,null,null,null,null,"생산부 기본급 평균"]
[]
[]
["[표3]","회원 관리 현황",null,null,null,null,"[표4]","핸드볼 선수권대회"]
["등록일자","구분","회원명","성별","회원코드",null,"국가","승","패","준결승"]
["2021-03-01","golf","김은수","여",null,null,"대한민국",8,1]
["2021-03-07","fit","김종숙","여",null,null,"중국",4,5]
["2021-03-07","swim","이선미","여",null,null,"일본",6,3]
["2021-03-11","golf","이정우","남",null,null,"싱가포르",2,7]
["2021-03-15","fit","차형섭","남",null,null,"인도",3,6]
["2021-03-15","fit","최경원","남",null,null,"베트남",7,2]
["2021-03-16","golf","한고은","여",null,null,"홍콩",1,8]
["2021-03-18","swim","홍진영","여",null,null,"쿠웨이트",5,4]
["2021-03-23","swim","황재윤","남",null,null,"카타르",6,3]
["2021-03-30","fit","박신혜","여",null,null,"이란",3,6]
[]
["[표5]","기부 현황",null,null,"<기준표>"]
["회원코드","사용요금","결과",null,"초과","이하","표시"]
["GIV-01",43690,null,null,0,200,"★"]
["GIV-02",34300,null,null,200,400,"★★"]
["GIV-03",43840,null,null,400,600,"★★★"]
["GIV-04",28100,null,null,600,800,"★★★★"]
["GIV-05",34170,null,null,800,1000,"★★★★★"]
["GIV-06",31670]
["GIV-07",26380]
["GIV-08",31520]
["GIV-09",46060]

{"sheet":"분석작업-1","index":4,"n_rows":21,"n_cols":9,"rows_kept":21,"cut":false,"hidden":false,"merged":[[0,0,0,1],[10,3,10,8],[12,1,20,1]]}
["자동차 할부금 납입표"]
[]
["차량총액",45000000]
["계약금",1000000]
["인도금",9000000]
["할부원금",35000000]
["이율(년)",0.06]
["납입기간(월)",60]
["월납입액",{"$f":"PMT(B7/12,B8,-B6)","v":676648.0535299771}]
[]
[null,null,null,"납입기간(월)"]
[null,null,null,24,30,36,40,46,50]
[null,"이율(년)",0.02]
[null,null,2.5000000000000001E-2]
[null,null,0.03]
[null,null,3.5000000000000003E-2]
[null,null,0.04]
[null,null,4.4999999999999998E-2]
[null,null,0.05]
[null,null,5.5E-2]
[null,null,0.06]

{"sheet":"분석작업-2","index":5,"n_rows":16,"n_cols":8,"rows_kept":16,"cut":false,"hidden":false,"merged":[[0,0,0,7]]}
["도시락 판매 현황"]
[]
["구분","도시락명","열량(kcal)","판매가","입고량","판매량","재고량","총판매액"]
["일반","불고기덮밥",512,4500,100,87,{"$f":"E4-F4","v":13},{"$f":"D4*F4","v":391500}]
["건강","쇠고기미역국",460,4200,120,112,{"$f":"E5-F5","v":8},{"$f":"D5*F5","v":470400}]
["일반","등심돈까스",486,4700,120,107,13,502900]
["스페셜","명품한정식",623,7800,60,45,15,351000]
["일반","제육쌈밥",481,5200,150,145,5,754000]
["스페셜","일품오리구이",397,6300,70,64,6,403200]
["일반","김치볶음밥",414,4000,150,149,1,596000]
["스페셜","한우갈비구이",504,8000,50,42,8,336000]
["일반","오므라이스",375,4800,100,89,11,427200]
["건강","건강현미정식",389,4600,100,92,8,423200]
["스페셜","황제해물찜",582,7600,70,64,6,486400]
["일반","삼겹살구이",577,5800,120,118,2,684400]
["건강","곤드레나물밥",426,6300,100,93,7,585900]

{"sheet":"매크로작업","index":6,"n_rows":9,"n_cols":6,"rows_kept":9,"cut":false,"hidden":false,"merged":[[0,0,0,5]]}
["분기별 화재 발생건수표"]
[]
["장소","1분기","2분기","3분기","4분기","합계"]
["주택",27,21,25,28]
["시설",46,42,48,39]
["위험물",29,33,37,28]
["운송",15,18,13,17]
["임야",11,13,9,15]
["기타",32,27,30,23]

{"sheet":"차트작업","index":7,"n_rows":9,"n_cols":8,"rows_kept":9,"cut":false,"hidden":false,"merged":[[0,0,0,7]]}
["1학기 중간고사 성적표"]
[]
["학생명","국어","영어","수학","과학","사회","총점","평균"]
["오윤하",72,93,79,75,76,{"$f":"SUM(B4:F4)","v":395},{"$f":"AVERAGE(B4:F4)","v":79}]
["박태형",80,82,80,83,86,411,82.2]
["홍승아",70,83,81,82,89,405,81]
["김현수",84,89,80,86,81,420,84]
["손진철",91,80,92,91,88,442,88.4]
["유관영",95,91,94,92,97,{"$f":"SUM(B9:F9)","v":469},93.8]