{"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":15,"n_cols":7,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
["과일통조림 생산 현황"]
[]
["제품명","생산일자","생산팀","생산단가","목표량","생산량","생산율"]
["원조황도","2019-01-05","생산1팀",1200,1500,1435,{"$f":"F4/E4","v":0.95666666666666667}]
["원조백도","2019-01-05","생산2팀",1200,1500,1518,{"$f":"F5/E5","v":1.012}]
["굿파인애플","2019-01-05","생산3팀",2000,1200,1352,1.1266666666666667]
["믹스후르츠","2019-01-06","생산1팀",2500,1000,1240,1.24]
["망고세븐","2019-01-06","생산2팀",3000,800,786,0.98250000000000004]
["코코넛밀크","2019-01-06","생산3팀",1800,1400,1385,0.98928571428571432]
["리치키위","2019-01-07","생산1팀",1500,1300,1389,1.0684615384615384]
["맛나오렌지","2019-01-07","생산2팀",1150,1600,1579,0.98687499999999995]
["스위트밀감","2019-01-07","생산3팀",1000,2000,2168,1.0840000000000001]
["우리토마토","2019-01-08","생산1팀",950,2500,2579,1.0316000000000001]
["옐로바나나","2019-01-08","생산2팀",1100,1600,1589,0.99312500000000004]
["그린멜론","2019-01-08","생산3팀",3200,800,872,1.0900000000000001]

{"sheet":"기본작업-3","index":2,"n_rows":1,"n_cols":2,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
[null,"상공세무회계사무소 거래처 명단"]

{"sheet":"계산작업","index":3,"n_rows":39,"n_cols":11,"rows_kept":39,"cut":false,"hidden":false,"merged":[[11,0,11,3],[25,0,25,3]]}
["[표1]","가전제품 판매현황",null,null,"(단위 : 만원)",null,"[표2]","신입사원 채용결과"]
["제품명","판매지역","판매가","판매량","판매금액",null,"응시번호","필기","실기","면접","합격여부"]
["냉장고","서울",250,1268,{"$f":"C3*D3","v":317000},null,125001,49,60,55]
["냉장고","경기",250,1109,{"$f":"C4*D4","v":277250},null,125002,85,76,58]
["냉장고","인천",250,1384,346000,null,125003,83,81,82]
["세탁기","서울",120,957,114840,null,125004,94,92,94]
["세탁기","경기",120,1345,161400,null,125005,87,90,91]
["세탁기","인천",120,843,101160,null,125006,64,70,65]
["TV","서울",200,158,31600,null,125007,92,90,69]
["TV","경기",200,1762,352400,null,125008,86,83,79]
["TV","인천",200,989,197800,null,125009,76,73,70]
["냉장고와 TV 판매금액 차이",null,null,null,null,null,125010,57,64,75]
[]
["[표3]","영업사원 실적표",null,null,null,null,"[표4]","회원 관리 현황"]
["사원명","성별","1월판매량","2월판매량","총판매량",null,"회원코드","구매횟수","총결제액","고객등급"]
["손애진","여",653,595,{"$f":"SUM(B16:D16)","v":1248},null,"SG-501",5,1760000]
["이영해","여",311,287,{"$f":"SUM(B17:D17)","v":598},null,"SG-502",12,4230000]
["최민석","남",550,658,1208,null,"SG-503",24,8450000]
["원석빈","남",386,426,812,null,"SG-504",8,2820000]
["하주원","여",828,905,1733,null,"SG-505",11,3880000]
["이병훈","남",644,684,1328,null,"SG-506",22,7750000]
["문소라","여",486,401,887,null,"SG-507",16,5640000]
["장동군","남",385,422,807,null,"SG-508",27,9510000]
["송강후","남",754,706,1460,null,"SG-509",24,8450000]
["고소용","여",381,317,698,null,"SG-510",18,6340000]
["여사원 총판매량 합계",null,null,null,null,null,"SG-511",9,3170000]
[]
["[표5]","사원 관리 현황"]
["사원코드","사원명","성별","부서명","직위"]
["1-G-392","김은희","여","영업부"]
["2-D-284","김주도","남","기획부"]
["8-B-521","유은별","여","영업부"]
["2-S-742","고사장","남","기획부"]
["4-D-823","성준혁","남","영업부",null,null,"<직위표>"]
["4-G-648","임진성","남","기획부",null,null,"직위코드","직위"]
["5-S-478","황진아","여","경리부",null,null,"B","부장"]
["6-S-732","박하나","여","영업부",null,null,"G","과장"]
["5-B-324","강대리","남","경리부",null,null,"D","대리"]
["7-D-543","유서현","여","경리부",null,null,"S","사원"]

{"sheet":"분석작업-1","index":4,"n_rows":20,"n_cols":8,"rows_kept":20,"cut":false,"hidden":false,"merged":[[0,0,0,7]]}
["1학년 중간고사 성적표"]
[]
["성명","성별","국어","영어","수학","과학","사회","총점"]
["윤산이","여",80,83,79,82,81,{"$f":"SUM(C4:G4)","v":405}]
["민우람","남",94,97,91,92,95,{"$f":"SUM(C5:G5)","v":469}]
["변정숙","여",85,88,84,87,86,430]
["한진아","여",76,80,75,78,77,386]
["정우성","남",68,71,67,70,69,345]
["박재오","남",91,92,90,92,92,457]
["남소현","여",48,51,47,50,49,245]
["김정섭","남",76,67,75,80,77,375]
["한예승","여",82,91,81,84,83,421]
["유정만","남",64,67,63,66,65,325]
["강소리","여",94,97,94,96,95,476]
["강선빈","남",67,70,70,69,68,344]
["신유라","여",78,81,77,80,79,395]
["이고은","여",88,94,87,90,89,448]
["배문기","남",94,93,93,96,92,468]
["김병민","남",83,83,82,82,84,414]
["이승학","남",71,74,80,73,72,370]

{"sheet":"분석작업-2","index":5,"n_rows":15,"n_cols":6,"rows_kept":15,"cut":false,"hidden":false,"merged":[[0,0,0,5]]}
["상공백화점 임대 현황"]
[]
["매장명","매장구분","매장위치","보증금","임대료","관리비"]
["MCTRO","패션잡화","1층",150000000,3200000,1400000]
["둑스","패션잡화","1층",180000000,3800000,1600000]
["페리페리","패션잡화","1층",160000000,3400000,1400000]
["발렌슈아","여성의류","2층",210000000,4400000,1900000]
["GStyle","여성의류","2층",200000000,4200000,1800000]
["비비리토","여성의류","2층",240000000,5000000,2200000]
["K4","아웃도어","3층",280000000,5900000,2500000]
["유스페이스","아웃도어","3층",270000000,5700000,2400000]
["네푸","아웃도어","3층",250000000,5300000,2300000]
["짜장나라","중식당","4층",300000000,6300000,2700000]
["볼레오르","양식당","4층",350000000,7400000,3200000]
["민국뚝배기","한식당","4층",320000000,6700000,2900000]

{"sheet":"매크로작업","index":6,"n_rows":13,"n_cols":5,"rows_kept":13,"cut":false,"hidden":false,"merged":[[0,0,0,4]]}
["컴퓨터활용능력 1급 필기 시험 결과"]
[]
["수험번호","컴퓨터일반","스프레드시트","데이터베이스","총점"]
["1708-3401",65,55,80]
["1708-3402",75,70,60]
["1708-3403",90,95,85]
["1708-3404",80,80,85]
["1708-3405",60,45,50]
["1708-3406",40,35,50]
["1708-3407",35,40,50]
["1708-3408",85,80,70]
["1708-3409",75,90,80]
["1708-3410",65,60,50]

{"sheet":"차트작업","index":7,"n_rows":8,"n_cols":5,"rows_kept":8,"cut":false,"hidden":false,"merged":[[0,0,0,4]]}
["스키제품 판매 현황"]
[]
["용품명","입고량","판매가","판매량","판매총액"]
["스키복",100,95000,67,{"$f":"C4*D4","v":6365000}]
["고글",160,35000,146,{"$f":"C5*D5","v":5110000}]
["헬멧",120,40000,97,3880000]
["장갑",150,25000,132,3300000]
["보호대",110,45000,101,4545000]