{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["기본작업-1","기본작업-2","기본작업-3","계산작업","분석작업-1","분석작업-2","매크로작업","차트작업"],"not_rendered":{"charts":1,"images":9,"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":15,"n_cols":7,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
["상공마트 상품 입고 현황"]
[]
["분류","상품코드","업체명","상품명","단가","수량","총액"]
["생활","LF-2914","한성산업","순수물티슈",1100,5000,550]
[null,"LF-9066","유명물산","촉촉바디로션",3800,3500,1330]
[null,"LF-5837","포레스트","볼륨업샴푸",2700,4000,1080]
["뷰티","BT-4610","뷰티그린","리얼아이크림",9500,600,570]
[null,"BT-9020","해브앤유","마녀폼클렌징",4500,1200,540]
[null,"BT-5842","티오화학","레드에센스",7600,1000,760]
["식품","FD-7257","다온미트","통통삼겹살",2200,6000,1320]
[null,"FD-4884","우리목장","신선우유",1880,8000,1504]
[null,"FD-6174","넛츠피아","건강한견과",2400,3500,840]
["건강","HS-9033","한울약품","생생루테인",12000,200,240]
[null,"HS-1925","튼튼건강","장안에유산균",13500,1200,1620]
[null,"HS-2178","피바이오","슈퍼오메가",11700,500,585]

{"sheet":"기본작업-3","index":2,"n_rows":13,"n_cols":8,"rows_kept":13,"cut":false,"hidden":false,"merged":[[2,2,2,4],[2,1,3,1],[2,5,2,7],[0,1,0,7]]}
[null,"완제품 점유율 현황"]
[]
[null,"제품코드","2019년",null,null,"2020년"]
[null,null,"원료","완제품","점유율","원료","완제품","점유율"]
[null,"MK29813",965000,1250000,7.0000000000000007E-2,984300,1280000,0.05]
[null,"PH66678",587000,760000,0.02,598700,780000,0.01]
[null,"SN59632",634100,820000,0.08,646800,840000,0.05]
[null,"CM10076",840000,1090000,0.36,856800,1110000,0.39]
[null,"ER46299",904200,1180000,0.02,922300,1200000,0.05]
[null,"GA76051",766000,1000000,0.15,781300,1020000,0.18]
[null,"DF84460",539500,700000,0.02,550300,720000,0.03]
[null,"TG31883",680400,880000,0.27,694000,900000,0.23]
[null,"WL55079",812000,1060000,0.01,828200,1080000,0.01]

{"sheet":"계산작업","index":3,"n_rows":38,"n_cols":10,"rows_kept":38,"cut":false,"hidden":false,"merged":[[22,5,23,5]]}
["[표1]","사내 하프 마라톤",null,null,null,"[표2]","상공클럽 가입 현황"]
["참가번호","선수명","기록","순위",null,null,null,"2022-04-05"]
[10001,"이종혁","01:25:14",null,null,"회원명","가입일","등급"]
[10002,"박준형","01:38:07",null,null,"이연희","2018-03-08"]
[10003,"김희재","01:41:52",null,null,"박장훈","2015-04-09"]
[10004,"김한순","01:22:27",null,null,"강동엽","2020-02-01"]
[10005,"고회식","01:26:33",null,null,"유승희","2013-11-15"]
[10006,"지승대",null,null,null,"황진주","2009-10-09"]
[10007,"박해수","01:37:19",null,null,"어수한","2010-08-09"]
[]
["[표3]","사원 판매 현황",null,null,null,"[표4]","사원 평가 현황"]
["사원명","지점","수량","판매금액",null,"사원명","업무능력","대인관계","회화능력","평가"]
["이세훈","북부",3388,{"$f":"C13*1283","v":4346804},null,"강수진",85,75,66]
["한범준","남부",2461,3157463,null,"최성욱",91,84,90]
["신솔지","북부",2959,3796397,null,"고혜란",75,81,80]
["권지애","남부",3796,4870268,null,"김은주",86,83,87]
["오세민","북부",3502,4493066,null,"이경원",96,97,96]
["조현우","북부",2681,3439723,null,"임선호",92,89,93]
["이명복","남부",4034,5175622,null,"김상욱",61,68,57]
["권지향","남부",3498,4487934,null,"이상희",79,73,81]
[]
[null,null,null,"평균판매금액",null,"<평가기준표>"]
[null,null,null,null,null,"점수",0,70,80,90]
[null,null,null,null,null,null,70,80,90,100]
[null,null,null,null,null,"평가","미흡","보통","양호","우수"]
["[표5]","화장품 판매 현황"]
["제품ID","제조국","분류","판매량","매출액"]
["A293","프랑스","남성",691,{"$f":"D28*12500","v":8637500}]
["S351","미국","여성",567,{"$f":"D29*12500","v":7087500}]
["D687","캐나다","남성",816,10200000]
["K902","미국","여성",733,9162500]
["B325","프랑스","남성",594,7425000]
["C674","캐나다","남성",834,10425000]
["M110","미국","여성",765,9562500]
["P728","프랑스","남성",702,8775000]
["H594","캐나다","남성",627,7837500]
[]
["프랑스","남성",null,"판매량합계","매출액합계"]

{"sheet":"분석작업-1","index":4,"n_rows":16,"n_cols":7,"rows_kept":16,"cut":false,"hidden":false,"merged":[[0,1,0,6]]}
[null,"거래소별 종목 거래 현황"]
[null,null,null,null,null,null,"단위 : 거래량(천), 거래액(천원)"]
[null,"거래소","주체","구분","종목코드","거래량","거래액"]
[null,"코스피","외국인","매도","AZES",648,8035200]
[null,"코스닥","기관","매수","CTRM",1295,34965000]
[null,"코넥스","개인","매도","UKOMV",2476,10622040]
[null,"코넥스","외국인","매수","NSPR",952,12852000]
[null,"코스피","개인","매수","LGHLW",897,6099600]
[null,"코넥스","기관","매도","USWS",1095,23433000]
[null,"코스닥","개인","매도","ACST",3471,38528100]
[null,"코스피","기관","매도","OGEN",2486,70751560]
[null,"코스피","개인","매도","BORR",1649,14824510]
[null,"코스닥","개인","매수","SONM",734,2436880]
[null,"코넥스","기관","매수","REOT",1386,10575180]
[null,"코스닥","외국인","매도","DHXI",574,3989300]
[null,"코스피","기관","매수","TLGT",2240,73024000]

{"sheet":"분석작업-2","index":5,"n_rows":13,"n_cols":7,"rows_kept":13,"cut":false,"hidden":false,"merged":[[0,1,0,6]]}
[null,"부서별 해외직구 현황"]
[null,null,null,null,null,"환율 :",1200]
[null,"부서명","제품코드","제품가(달러)","수량","배송비(달러)","구매금액(원)"]
[null,"영업부","KBP14",150,3,4,{"$f":"(D4*E4*$G$2)+(F4*$G$2)","v":544800}]
[null,"생산부","CLK66",80,1,3,{"$f":"(D5*E5*$G$2)+(F5*$G$2)","v":99600}]
[null,"총무부","SME92",384,2,6,928800]
[null,"영업부","KES20",55,5,12,344400]
[null,"생산부","GHI13",97,2,5,238800]
[null,"총무부","LSH56",265,4,10,1284000]
[null,"총무부","BUA84",200,3,8,729600]
[null,"영업부","WTP11",83,3,7,307200]
[null,"생산부","NVY05",191,2,5,464400]
[null,null,null,null,null,"총구매금액",{"$f":"SUM(G4:G12)","v":4941600}]

{"sheet":"매크로작업","index":6,"n_rows":11,"n_cols":6,"rows_kept":11,"cut":false,"hidden":false,"merged":[[0,1,0,5]]}
[null,"마트별 제품 판매현황"]
[]
[null,"마트","제품","단가","수량","금액"]
[null,"유명마트","신선우유",1200,25]
[null,"한국마트","초코우유",1500,15]
[null,"서울마트","튼튼우유",1800,10]
[null,"대청마트","칼슘우유",1400,20]
[null,"상공마트","아이우유",1600,25]
[null,"대성마트","딸기우유",1500,30]
[null,"하나마트","멸균우유",1700,15]
[null,"바른마트","건강우유",1900,20]

{"sheet":"차트작업","index":7,"n_rows":6,"n_cols":8,"rows_kept":6,"cut":false,"hidden":false,"merged":[[0,1,0,7]]}
[null,"영어학원 등록현황"]
[]
[null,"지역","유치원생","초등학생","중학생","고등학생","대학생","일반인"]
[null,"분당지역",87,129,137,118,45,38]
[null,"일산지역",89,128,145,127,38,42]
[null,"강북지역",75,115,132,109,43,48]