{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["무작정따라하기","기출01"],"not_rendered":{"charts":0,"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":"무작정따라하기","index":0,"n_rows":32,"n_cols":10,"rows_kept":32,"cut":false,"hidden":false,"merged":[[11,5,12,5],[25,0,25,2]]}
["[표1]","대출금 내역",null,null,null,"[표2]","영어듣기 평가"]
["접수코드","고객명","대출금액","대출금리",null,"이름","1차점수","2차점수","결과"]
["001-M-1121","김현민",15000000,{"$f":"VLOOKUP(MID(A3,5,1),$A$12:$C$14,3,0)","v":4.2000000000000003E-2},null,"안기자",83,90,{"$f":"HLOOKUP(AVERAGE(G3:H3),$F$12:$J$14,3,1)","v":"우수"}]
["002-C-3241","우지혜",5500000,{"$f":"VLOOKUP(MID(A4,5,1),$A$12:$C$14,3,0)","v":0.03},null,"여규식",77,72,{"$f":"HLOOKUP(AVERAGE(G4:H4),$F$12:$J$14,3,1)","v":"보통"}]
["003-S-2345","강수인",6400000,2.1999999999999999E-2,null,"오선길",93,92,"최우수"]
["004-S-4532","안정호",20000000,2.1999999999999999E-2,null,"이준모",91,95,"최우수"]
["005-C-3421","유현상",10000000,0.03,null,"강민찬",59,43,"노력"]
["006-M-4567","도야지",90000000,4.2000000000000003E-2,null,"김현수",67,64,"보통"]
["007-C-2341","최우영",4500000,0.03,null,"구성태",88,85,"우수"]
[]
["코드","대출상품","대출금리",null,null,"<결과기준표>"]
["S","학자금",2.1999999999999999E-2,null,null,"평균",0,60,80,90]
["C","출산",0.03,null,null,null,59,79,89,100]
["M","결혼자금",4.2000000000000003E-2,null,null,"결과","노력","보통","우수","최우수"]
[]
["[표3]","성적표",null,null,null,"[표4]","영어회화 평가 결과"]
["성명","성별","성적","비고",null,"사원코드","성적","성명","성명 (3등)"]
["강성권","남",89,{"$f":"CHOOSE(_xlfn.RANK.EQ(C18,$C$18:$C$24,0),\"최우수\",\"우수\",\"보통\",\"노력\",\"노력\",\"노력\",\"노력\")","v":"노력"},null,"ds-043",85,"정지호",{"$f":"VLOOKUP(LARGE(G18:G26,3),G18:H26,2,0)","v":"도지영"}]
["이길순","남",94,{"$f":"CHOOSE(_xlfn.RANK.EQ(C19,$C$18:$C$24,0),\"최우수\",\"우수\",\"보통\",\"노력\",\"노력\",\"노력\",\"노력\")","v":"보통"},null,"ds-078",56,"방정수"]
["하길주","여",83,"노력",null,"ds-053",90,"도지영"]
["이선호","여",94,"보통",null,"ds-068",78,"박철환"]
["강성수","남",95,"우수",null,"ds-063",53,"성인수"]
["김보견","여",96,"최우수",null,"ds-048",45,"소지성"]
["천수만","남",79,"노력",null,"ds-058",98,"심학성"]
[null,null,null,null,null,"ds-073",86,"윤자요"]
["노력인 학생의 성적 합계",null,null,{"$f":"SUMIF(D18:D24,\"노력\",C18:C24)","v":251},null,"ds-083",100,"최주영"]
[]
["[표5]","품목별 생산량"]
["품목","생산량","상자당 개수","상자(나머지)"]
["사과",255,24,{"$f":"INT(B30/C30)&\"(\"&MOD(B30,C30)&\")\"","v":"10(15)"}]
["배",185,35,{"$f":"INT(B31/C31)&\"(\"&MOD(B31,C31)&\")\"","v":"5(10)"}]
["복숭아",330,25,"13(5)"]

{"sheet":"기출01","index":1,"n_rows":31,"n_cols":10,"rows_kept":31,"cut":false,"hidden":false,"merged":[[28,8,29,9],[30,0,30,2],[30,8,30,9]]}
["[표1] ","상공전자 사원 현황",null,null,null,"[표2] ","상공 문구 판매 현황"]
["사원코드","성명","근무년수","소속부서",null,"제품명","판매가격","판매수량","판매금액","할인액"]
["H203-1","이지원",12,null,null,"다이어리",2550,55,140250]
["K102-2","나오미",13,null,null,"수첩",12350,65,802750]
["B333-3","권경애",8,null,null,"명함꽂이",3450,60,207000]
["D104-2","강수영",15,null,null,"딱풀",765,100,76500]
["F405-3","나우선",19,null,null,"붓",7650,77,589050]
["G306-4","임철수",28]
["H203-1","이미지",18,null,null,"<할인율표>"]
["S592-2","김은소",9,null,null,"판매수량",1,40,70]
[null,null,null,null,null,"할인율",0,0.03,0.06]
["[표3] ","학생관리"]
["이름","성별","학생코드","학과",null,"<학과표>"]
["최성완","남","s102935",null,null,"코드","학과"]
["이안나","여","e569007",null,null,"b","business"]
["박영선","여","b667418",null,null,"s","software"]
["심재준","남","a963403",null,null,"a","architecture"]
["이승호","남","e860225",null,null,"e","electronic"]
["신영숙","여","s439118"]
["김영수","남","b937474"]
[]
["[표4] ","급여 지급 현황",null,null,null,"[표5]","화물운송비용"]
["사원명","부서명","근무년수","급여",null,"거래처","지역","비용"]
["박소현","홍보부",14,4350000,null,"튼튼산업","지방",360000]
["손동준","기획부",12,4100000,null,"한국산업","수도권",210000]
["고현희","홍보부",11,3900000,null,"하나산업","수도권",225000]
["윤정민","홍보부",8,3500000,null,"대명산업","지방",385000]
["김민서","기획부",7,3450000,null,"유진산업","지방",420000]
["이중희","기획부",6,3200000,null,"국민산업","수도권",215000,"비용이 가장 비싼\n지방 거래처"]
["조현성","홍보부",3,2750000,null,"유명산업","지방",465000]
["홍보부 대리 급여 합계",null,null,null,null,"군자산업","지방",390000]