{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["기본작업-1","기본작업-2","계산작업","분석작업-1","분석작업-2","기타작업-1","기타작업-2","기타작업-3"],"not_rendered":{"charts":2,"images":9,"macros":1,"external_links":0,"defined_names":3,"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":32,"n_cols":7,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
["[표1]"]
["관리코드","타이틀명","입고일자","가격","장르","시간","대여료"]
["DVD-01","7년만의 외출","2017-05-26",25000,"코메디",105,2000]
["DVD-02","3000마일","2017-05-29",25300,"액션",125,1000]
["DVD-03","대탈주SE","2017-06-01",29500,"액션",175,1000]
["DVD-04","빨강머리앤","2017-06-04",23000,"애니메이션",128,1000]
["DVD-05","화산고","2017-06-07",25000,"액션",121,1500]
["DVD-06","프렌치키스","2017-06-10",25000,"코메디",111,500]
["DVD-07","일단 뛰어","2017-07-05",25300,"코메디",110,1500]
["DVD-08","타이탄 족의 멸망","2017-07-30",16500,"모험",118,500]
["DVD-09","아마겟돈","2017-08-24",29000,"액션",145,500]
["DVD-10","아비정전","2017-09-18",22000,"드라마",94,500]
["DVD-11","철목련","2017-10-13",25000,"드라마",117,500]
["DVD-12","자이언트 로보","2017-11-07",25000,"애니메이션",60,500]
["DVD-13","피터팬","2017-12-02",29000,"애니메이션",76,2000]
["DVD-14","톰썸의 비밀모험","2017-12-27",25000,"모험",58,500]
["DVD-15","반지의 제왕","2018-01-21",29000,"모험",178,1000]
["DVD-16","피도 눈물도 없이","2018-02-15",25000,"액션",113,1500]
["DVD-17","뿌리","2018-03-03",37000,"드라마",578,3000]
["DVD-18","마리이야기","2018-03-19",25300,"애니메이션",80,500]
["DVD-19","스몰빌","2018-04-04",16500,"액션",91,1000]
["DVD-20","양철북","2018-04-20",19800,"드라마",142,1000]
["DVD-21","하드 캐쉬","2018-05-06",22000,"액션",99,1500]
["DVD-22","친구","2018-05-22",25300,"드라마",116,1500]
["DVD-23","진주만","2018-06-07",49000,"모험",184,3000]
["DVD-24","내겐 너무 가벼운 그녀","2018-06-23",27500,"코메디",113,1500]
["DVD-25","서부전선 이상없다","2018-07-09",19980,"액션",128,1000]
["DVD-26","슬레이어즈  NEXT","2018-07-25",25000,"애니메이션",25,1000]
["DVD-27","달마야 놀자","2018-08-10",25300,"코메디",95,1500]
["DVD-28","스파이 게임","2018-08-26",25300,"액션",127,1000]
["DVD-29","재미있는 영화","2017-05-25",25000,"코메디",126,2000]
["DVD-30","콘에어","2017-06-10",24000,"모험",115,1000]

{"sheet":"기본작업-2","index":1,"n_rows":8,"n_cols":7,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["[표1]"]
["이름","학과","과제","출석","중간","기말","총점"]
["김민국","전자공학과",18,13,16,23,{"$f":"SUM(C3:F3)","v":70}]
["최신국","컴퓨터공학과",18,20,17,15,70]
["박억남","전자공학과",17,18,19,30,84]
["조민정","전자공학과",15,12,17,24,68]
["이재건","전자공학과",20,15,25,27,87]
["서승범","전자공학과",12,15,26,15,68]

{"sheet":"계산작업","index":2,"n_rows":43,"n_cols":10,"rows_kept":43,"cut":false,"hidden":false,"merged":[[36,0,36,1]]}
[]
["[표1]"]
["과목ID","이름","학과","과제","출석","중간","기말","총점","전공여부","등급"]
["C003","이현정","컴퓨터공학과",13,11,23,30]
["S002","송수정","컴퓨터공학과",19,10,16,26]
["C004","문병용","컴퓨터공학과",14,11,15,25]
["C007","김혜영","컴퓨터공학과",20,15,21,15]
["C008","이문성","전자공학과",10,15,22,27]
["P005","우용표","전자공학과",14,12,27,28]
["S003","김후영","컴퓨터공학과",16,19,15,23]
["P002","김민국","컴퓨터공학과",18,13,16,23]
["S004","최신국","컴퓨터공학과",18,20,17,15]
["P006","박억남","전자공학과",17,18,19,30]
["P008","조민정","전자공학과",15,12,17,24]
["C007","이재건","전자공학과",20,15,25,27]
["S003","서승범","전자공학과",12,15,26,15]
["C003","박인성","컴퓨터공학과",11,10,28,21]
["S005","김주우","컴퓨터공학과",14,10,22,29]
["C001","이건홍","전자공학과",20,10,29,18]
["S002","이용현","컴퓨터공학과",17,16,24,22]
["P007","나웅선","전자공학과",11,16,24,16]
["C004","김보미","컴퓨터공학과",18,10,23,30]
["C002","성도식","전자공학과",10,12,28,18]
["P007","유성진","전자공학과",13,13,28,29]
[]
["[표2]"]
["강의코드","C","S","P","강의진행",1,3,7]
["전공","교양","전공선택","전공필수","과목","영어","한국어","기타"]
[]
["[표3]"]
["강의코드","컴퓨터공학과","전자공학과","과제","출석","중간","기말"]
["C"]
["S"]
["P"]
[]
["[표4]"]
["중간+기말",null,"등급"]
[51,60,"A"]
[41,50,"B"]
[31,40,"C"]
[21,30,"D"]
[11,20,"E"]
[1,10,"F"]

{"sheet":"분석작업-1","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"분석작업-2","index":4,"n_rows":8,"n_cols":7,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["[표1]",null,null,null,null,"[표2]"]
["생산기간","생산량","판매량","판매율",null,"판매량","판매율"]
["1월",2850,2000,{"$f":"C3/B3","v":0.70175438596491224}]
["2월",2450,1020,0.41632653061224489,null,1000]
["3월",3128,2500,0.79923273657289007,null,1200]
["4월",2580,2300,0.89147286821705429,null,1400]
["5월",1780,1280,0.7191011235955056,null,1600]
["6월",3300,3160,0.95757575757575752,null,1800]

{"sheet":"기타작업-1","index":5,"n_rows":8,"n_cols":3,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[]
["[표1]"]
["제품명","판매금액","할인금액"]
["세탁기",2350000,{"$f":"IF(B4>=2000000,B4*85%,B4*90%)","v":1997500}]
["카세트",510000,{"$f":"IF(B5>=2000000,B5*85%,B5*90%)","v":459000}]
["건조기",2300000,1955000]
["냉장고",3540000,3009000]
["청소기",1250000,1125000]

{"sheet":"기타작업-2","index":6,"n_rows":14,"n_cols":6,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["[표1]"]
["종목명","종가","전일비","등락률(%)","시가총액(억원)","상장주식수"]
["남원물산",43150,1250,2.8968713789107765,190984,70360294]
["한국산업",70500,990,1.4042553191489362,188630,112582975]
["종일제강",34450,1120,-3.2510885341074021,177652,172557131]
["성대상사",214200,13850,6.4659197012138199,311300,703628100]
["유명반도체",108500,9800,-9.0322580645161281,302977,125456133]
["우리제약",126000,24800,-19.682539682539684,257309,213668187]
["진흥화학",103000,7850,-7.6213592233009706,229318,415111537]
["한국제지",41750,8250,19.760479041916167,159576,48374832]
["신한양조",29800,1820,6.1073825503355703,144844,67789652]
["서울전자",122100,13540,11.08927108927109,229422,248651378]
["일성증권",87200,3520,4.0366972477064227,197009,15618197]
["두성전자",192000,34000,-17.708333333333336,512514,728002365]

{"sheet":"기타작업-3","index":7,"n_rows":5,"n_cols":3,"rows_kept":5,"cut":false,"hidden":false,"merged":[[0,0,0,2]]}
["제품 판매 현황"]
[]
["[표1]"]
["제품명","수량","금액"]
["카세트",1,"540,000원"]