{"text_format":"1","workbook":"xlsx","n_sheets":122,"sheets":["홈","중요함수모음","1.기본함수","1.기본함수-정답","2.논리함수","2.논리함수-정답","3. 참조함수","3. 참조함수-정답","4.날짜와 시간함수","4.날짜와 시간함수-정답","5.데이터베이스함수","5.데이터베이스함수-정답","6.기타함수","문서1_기초","문서1_기초 (정답파일)","문서1-견적서","문서1-연습","문서2-강의이력서","문서2-연습","문서3-세금계산서","문서3-연습","자동필터_1","자동필터_1-정답","자동필터(예제)","자동필터(결과)","고급필터","고급필터(결과)","조건부서식1(예제)","조건부서식1(결과)","조건부서식2(예제)","조건부서식2(결과)","조건부서식3(예제)","조건부서식3(결과)","계산(예제)","계산(결과)","날짜(예제)","날짜(결과)","논리(예제)","논리(결과)","데이터베이스1(예제)","데이터베이스1(결과)","데이터베이스2(예제)","데이터베이스2(결과)","데이터베이스3(예제)","데이터베이스3(결과)","문자열1(예제)","문자열1(결과)","문자열2(예제)","문자열2(결과)","수학1(예제)","수학1(결과)","수학2(예제)","수학2(결과)","재무(예제)","재무(결과)","통계1(예제)","통계1(결과)","통계2(예제)","통계2(결과)","찾기1(예제)","찾기1(결과)","찾기2(예제)","찾기2(결과)","찾기3(예제)","찾기3(결과)","정보(예제)","정보(결과)","실습1(예제)","실습1(결과)","배열수식(예제)","배열수식(결과)","배열1(예제)","배열1(결과)","배열2(예제)","배열2(결과)","배열3(예제)","배열3(결과)","사용자정의(예제)","사용자정의(결과)","피벗테이블-1","피벗테이블-1(정답)","피벗테이블-2","통합1(예제)","통합1(예제) (결과)","통합2(예제)","통합3(예제)","통합2(결과)","정렬1(예제) ","정렬1(결과)","정렬2(예제)","정렬2(결과)","부분합1(예제)","부분합1(결과)","부분합2(예제)","부분합2(결과)","데이터표1(예제)","데이터표1(예제)_결과","데이터표2(예제)","데이터표2(결과)","목표값1(예제)","목표값1(결과)","목표값2(예제) ","목표값2(결과)","시나리오1(예제)","시나리오1(결과)","시나리오2(예제)","시나리오2(결과)","분석작업_시나리오","매크로1(예제)","매크로1(결과)","매크로2(예제)","매크로2(결과)","차트1(예제)","차트1(결과)","차트2(예제)","차트2(결과)","차트3(예제)","차트3(결과)","차트","사원현황(예제)","수강등록(예제)","조회(예제)"],"not_rendered":{"charts":6,"images":9,"macros":1,"external_links":4,"defined_names":64,"comments":1,"pivot_tables":1},"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":5,"n_cols":16,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"    "]

{"sheet":"중요함수모음","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"1.기본함수","index":2,"n_rows":36,"n_cols":18,"rows_kept":36,"cut":false,"hidden":false,"merged":[[31,6,35,7],[21,1,21,7],[2,10,2,17],[0,1,0,2],[2,1,2,8],[5,2,5,5],[17,1,19,1],[17,8,19,8],[0,3,0,8],[5,6,5,8],[4,7,4,8]]}
[null," 기본함수 :",null,"SUM, AVERAGE, MAX, MIN, COUNT, COUNTA, COUNTBLANK, RANK"]
[]
[null,"이미남컴퓨터학원 평가표",null,null,null,null,null,null,null,null,"사원 봉사 활동 참여현황"]
[]
[null,"[표1]",null,null,null,null,"작성일:",null,null,null,"[표3]"]
[null,"신상","과목",null,null,null,"평가",null,null,null,"이름","1차","2차","3차","4차","5차","참여횟수","불참횟수"]
[null,"학번","성명","워드","엑셀","파워포인트","총점","평균","순위",null,"유동근","O","O","O","O","O"]
[null,2001,"김종국",69,32,40,null,null,null,null,"전경숙",null,"O","O","O","O"]
[null,2002,"신현준",70,70,60,null,null,null,null,"백수정","O",null,null,null,"O"]
[null,2003,"이재근",60,76,65,null,null,null,null,"안현철","O","O","O","O","O"]
[null,2004,"김민선",50,80,60,null,null,null,null,"고성남","O","O",null,"O"]
[null,2005,"이종원",80,60,70,null,null,null,null,"김종구","O","O",null,"O","O"]
[null,2006,"한고은",90,100,93,null,null,null,null,"박은정","O","O","O",null,"O"]
[null,2007,"김하늘",50,83,75,null,null,null,null,"이태호",null,"O","O"]
[null,2008,"김소원",60,64,64,null,null,null,null,"지준혁","O",null,"O","O","O"]
[null,2009,"장나라",90,80,79,null,null,null,null,"김현서","O","O","O","O","O"]
[null,2010,"김민종",80,40,69,null,null,null,null,"정연우","O","O","O","O","O"]
[null,null,"최대점수",null,null,null,null,null,null,null,"한승숙","O","O",null,"O","O"]
[null,null,"최소점수",null,null,null,null,null,null,null,"오정연",null,"O",null,"O","O"]
[null,null,"인원수"]
[]
[null,"가계부처리"]
[null,"[표2]"]
[null,"구분","문화생활비","식품비","의복비","교육비","총비용","순위"]
[null,"1일",10000,10000,15000,7000]
[null,"2일",20000,15000,30000,8000]
[null,"3일",30000,30000,10000,5000]
[null,"4일",13000,24000,10000,150000]
[null,"5일",100000,5000,100000,10000]
[null,"6일",15000,30000,10000,7000]
[null,"7일",14000,17000,25000,15000]
[null,"총액"]
[null,"평균"]
[null,"최고비용"]
[null,"최소비용"]
[null,"품목개수"]

{"sheet":"1.기본함수-정답","index":3,"n_rows":36,"n_cols":18,"rows_kept":36,"cut":false,"hidden":false,"merged":[[2,10,2,17],[4,7,4,8],[5,2,5,5],[5,6,5,8],[17,1,19,1],[17,8,19,8],[21,1,21,7],[31,6,35,7],[0,1,0,2],[0,3,0,8],[2,1,2,8]]}
[null," 기본함수 :",null,"SUM, AVERAGE, MAX, MIN, COUNT, COUNTA, COUNTBLANK, RANK"]
[]
[null,"이미남컴퓨터학원 평가표",null,null,null,null,null,null,null,null,"사원 봉사 활동 참여현황"]
[]
[null,"[표1]",null,null,null,null,"작성일:",null,null,null,"[표3]"]
[null,"신상","과목",null,null,null,"평가",null,null,null,"이름","1차","2차","3차","4차","5차","참여횟수","불참횟수"]
[null,"학번","성명","워드","엑셀","파워포인트","총점","평균","순위",null,"유동근","O","O","O","O","O",{"$f":"COUNTA(L7:P7)","v":5},{"$f":"COUNTBLANK(L7:P7)","v":0}]
[null,2001,"김종국",69,32,40,{"$f":"SUM(D8:F8)","v":141},{"$f":"AVERAGE(D8:F8)","v":47},{"$f":"RANK(H8,$H$8:$H$17,0)","v":10},null,"전경숙",null,"O","O","O","O",{"$f":"COUNTA(L8:P8)","v":4},{"$f":"COUNTBLANK(L8:P8)","v":1}]
[null,2002,"신현준",70,70,60,{"$f":"SUM(D9:F9)","v":200},{"$f":"AVERAGE(D9:F9)","v":66.666666666666671},{"$f":"RANK(H9,$H$8:$H$17,0)","v":6},null,"백수정","O",null,null,null,"O",2,3]
[null,2003,"이재근",60,76,65,201,67,5,null,"안현철","O","O","O","O","O",5,0]
[null,2004,"김민선",50,80,60,190,63.333333333333336,7,null,"고성남","O","O",null,"O",null,3,2]
[null,2005,"이종원",80,60,70,210,70,3,null,"김종구","O","O",null,"O","O",4,1]
[null,2006,"한고은",90,100,93,283,94.333333333333329,1,null,"박은정","O","O","O",null,"O",4,1]
[null,2007,"김하늘",50,83,75,208,69.333333333333329,4,null,"이태호",null,"O","O",null,null,2,3]
[null,2008,"김소원",60,64,64,188,62.666666666666664,9,null,"지준혁","O",null,"O","O","O",4,1]
[null,2009,"장나라",90,80,79,249,83,2,null,"김현서","O","O","O","O","O",5,0]
[null,2010,"김민종",80,40,69,189,63,8,null,"정연우","O","O","O","O","O",5,0]
[null,null,"최대점수",{"$f":"MAX(D8:D17)","v":90},{"$f":"MAX(E8:E17)","v":100},93,283,94.333333333333329,null,null,"한승숙","O","O",null,"O","O",4,1]
[null,null,"최소점수",{"$f":"MIN(D8:D17)","v":50},{"$f":"MIN(E8:E17)","v":32},40,141,47,null,null,"오정연",null,"O",null,"O","O",3,2]
[null,null,"인원수",{"$f":"COUNT(D8:D17)","v":10},{"$f":"COUNT(E8:E17)","v":10},10,10,10]
[]
[null,"가계부처리"]
[null,"[표2]"]
[null,"구분","문화생활비","식품비","의복비","교육비","총비용","순위"]
[null,"1일",10000,10000,15000,7000,{"$f":"SUM(C25:F25)","v":42000},{"$f":"RANK(G25,$G$25:$G$31,0)","v":7}]
[null,"2일",20000,15000,30000,8000,{"$f":"SUM(C26:F26)","v":73000},{"$f":"RANK(G26,$G$25:$G$31,0)","v":4}]
[null,"3일",30000,30000,10000,5000,75000,3]
[null,"4일",13000,24000,10000,150000,197000,2]
[null,"5일",100000,5000,100000,10000,215000,1]
[null,"6일",15000,30000,10000,7000,62000,6]
[null,"7일",14000,17000,25000,15000,71000,5]
[null,"총액",{"$f":"SUM(C25:C31)","v":202000},{"$f":"SUM(D25:D31)","v":131000},200000,202000]
[null,"평균",{"$f":"AVERAGE(C27)","v":30000},{"$f":"AVERAGE(D27)","v":30000},10000,5000]
[null,"최고비용",{"$f":"MAX(C25:C31)","v":100000},{"$f":"MAX(D25:D31)","v":30000},100000,150000]
[null,"최소비용",{"$f":"MIN(C25:C31)","v":10000},{"$f":"MIN(D25:D31)","v":5000},10000,5000]
[null,"품목개수",{"$f":"COUNT(C25:C31)","v":7},{"$f":"COUNT(D25:D31)","v":7},7,7]

{"sheet":"2.논리함수","index":4,"n_rows":64,"n_cols":15,"rows_kept":64,"cut":false,"hidden":false,"merged":[[50,6,50,8],[47,1,47,11],[3,1,3,11],[1,3,1,11],[28,1,28,9],[28,10,28,11],[30,8,30,11],[39,8,39,11],[6,11,6,12],[10,11,10,12],[6,13,6,14],[1,1,1,2],[16,1,16,5],[16,8,16,9],[16,11,16,13],[7,13,7,14],[8,13,8,14],[10,13,10,14],[11,13,11,14],[12,13,12,14]]}
[]
[null,"논리함수",null," IF, COUNTIF, COUNTIFS, SUMIF, SUMIFS, AVERAGEIF, AVERAGEIFS, AND, OR"]
[]
[null,"신입사원 직무수행 평가"]
[null,"[표1]"]
[null,"사번","성명","영어","컴퓨터","마케팅","총점","평균","합격여부","평균평가"]
[null,20020101,"이미희",54,92,100,null,null,null,null,null,null,null,"인원수"]
[null,20020102,"최고은",67,70,83,null,null,null,null,null,"합격"]
[null,20020103,"안수현",78,76,64,null,null,null,null,null,"불합격"]
[null,20020104,"이민우",80,80,80]
[null,20020105,"한진희",95,83,99,null,null,null,null,null,null,null,"총점합계"]
[null,20020106,"김상진",87,64,67,null,null,null,null,null,"평균이상"]
[null,20020107,"최승희",96,80,96,null,null,null,null,null,"평균이하"]
[null,20020108,"김상옥",93,60,88]
[null,20020109,"최현주",88,76,79]
[null,20020110,"전지연",79,60,75]
[null,null,null,null,null,null,"전체평균",null,null,null,null,"평균점수",null,null,"인원수"]
[null,null,null,null,null,null,null,null,null,null,null,0,"~",20]
[null,"[표2]",null,null,null,null,null,null,null,null,null,20,"~",40]
[null,"수험번호","성명","엑셀","인터넷","평균","합격여부1","합격여부2","평가",null,null,40,"~",60]
[null,"SM20001","이재근",95,88,null,null,null,null,null,null,60,"~",80]
[null,"SM20002","김민선",62,75,null,null,null,null,null,null,80,"~",100]
[null,"SM20003","이종원",86,100]
[null,"SM20004","한고은",60,80]
[null,"SM20007","장나라",100,70]
[null,"SM20008","김민종",77,80]
[null,"SM20009","이준희",80,60]
[]
[null,"제품판매 현황"]
[null,"[표3]"]
[null,"제품코드","분류","단가","판매량","판매금액","담당자",null,"[ 분류/담당자 기준 판매건수 ]"]
[null,"238VM357","아동의류",75300,5,{"$f":"D32*E32","v":376500},"이하원",null,"분류","조승재","이하원","박재민"]
[null,"537RI257","여성의류",72400,13,{"$f":"D33*E33","v":941200},"조승재",null,"여성의류"]
[null,"575HE011","여성의류",31500,12,378000,"이하원",null,"남성의류"]
[null,"254DN251","기타",11400,11,125400,"박재민",null,"아동의류"]
[null,"188KY649","아동의류",24200,30,726000,"조승재",null,"언더웨어"]
[null,"143VI197","남성의류",43400,30,1302000,"조승재",null,"기타"]
[null,"640XM642","남성의류",51900,7,363300,"박재민"]
[null,"661SY624","기타",59200,2,118400,"박재민"]
[null,"877PF846","아동의류",65500,12,786000,"이하원",null,"[ 분류/담당자 기준 판매량 합계 ]"]
[null,"937CR318","아동의류",75100,28,2102800,"조승재",null,"분류","조승재","이하원","박재민"]
[null,"546TK605","언더웨어",26000,8,208000,"조승재",null,"여성의류"]
[null,"897RP526","여성의류",9200,13,119600,"조승재",null,"남성의류"]
[null,"823CC448","언더웨어",45400,23,1044200,"이하원",null,"아동의류"]
[null,"294WR619","여성의류",44500,20,890000,"이하원",null,"언더웨어"]
[null,"582YB244","언더웨어",27500,15,412500,"박재민",null,"기타"]
[]
[null,"영업팀 매출 현황"]
[null,"[표4]"]
[null,"이름","소속","상반기","하반기"]
[null,"유동근","영업3팀",5626,8583,null,"[ 영업팀별 평균 매출량 ]"]
[null,"전경숙","영업2팀",3603,7406,null,"소속","상반기","하반기"]
[null,"백수정","영업2팀",6305,5700,null,"영업1팀"]
[null,"안현철","영업1팀",4905,8619,null,"영업2팀"]
[null,"고성남","영업3팀",4272,4082,null,"영업3팀"]
[null,"민병철","영업2팀",3758,4948]
[null,"조광연","영업1팀",5790,2765]
[null,"김연우","영업3팀",7122,5935]
[null,"김범수","영업2팀",7802,4012]
[null,"임재범","영업1팀",2668,3682]
[null,"박정현","영업3팀",7763,3133]
[null,"오동석","영업1팀",5123,5841]
[null,"이하원","영업1팀",2503,3864]
[null,"박오연","영업2팀",6126,8089]

{"sheet":"2.논리함수-정답","index":5,"n_rows":64,"n_cols":15,"rows_kept":64,"cut":false,"hidden":false,"merged":[[50,6,50,8],[8,13,8,14],[10,11,10,12],[10,13,10,14],[11,13,11,14],[12,13,12,14],[28,1,28,9],[28,10,28,11],[30,8,30,11],[39,8,39,11],[47,1,47,11],[16,1,16,5],[16,8,16,9],[16,11,16,13],[7,13,7,14],[1,1,1,2],[1,3,1,11],[3,1,3,11],[6,11,6,12],[6,13,6,14]]}
[]
[null,"논리함수",null," IF, COUNTIF, COUNTIFS, SUMIF, SUMIFS, AVERAGEIF, AVERAGEIFS, AND, OR"]
[]
[null,"신입사원 직무수행 평가"]
[null,"[표1]"]
[null,"사번","성명","영어","컴퓨터","마케팅","총점","평균","합격여부","평균평가"]
[null,20020101,"이미희",54,92,100,{"$f":"SUM(D7:F7)","v":246},{"$f":"AVERAGE(D7:F7)","v":82},{"$f":"IF(H7>=80,\"합격\",\"불합격\")","v":"합격"},{"$f":"IF(H7>=$H$17,\"평균이상\",\"평균이하\")","v":"평균이상"},null,null,null,"인원수"]
[null,20020102,"최고은",67,70,83,{"$f":"SUM(D8:F8)","v":220},{"$f":"AVERAGE(D8:F8)","v":73.333333333333329},{"$f":"IF(H8>=80,\"합격\",\"불합격\")","v":"불합격"},{"$f":"IF(H8>=$H$17,\"평균이상\",\"평균이하\")","v":"평균이하"},null,"합격",null,{"$f":"COUNTIF($I$7:$I$16,L8)","v":6}]
[null,20020103,"안수현",78,76,64,218,72.666666666666671,"불합격","평균이하",null,"불합격",null,{"$f":"COUNTIF($I$7:$I$16,L9)","v":4}]
[null,20020104,"이민우",80,80,80,240,80,"합격","평균이상"]
[null,20020105,"한진희",95,83,99,277,92.333333333333329,"합격","평균이상",null,null,null,"총점합계"]
[null,20020106,"김상진",87,64,67,218,72.666666666666671,"불합격","평균이하",null,"평균이상",null,{"$f":"SUMIF($J$7:$J$16,L12,$G$7:$G$16)","v":1519}]
[null,20020107,"최승희",96,80,96,272,90.666666666666671,"합격","평균이상",null,"평균이하",null,{"$f":"SUMIF($J$7:$J$16,L13,$G$7:$G$16)","v":870}]
[null,20020108,"김상옥",93,60,88,241,80.333333333333329,"합격","평균이상"]
[null,20020109,"최현주",88,76,79,243,81,"합격","평균이상"]
[null,20020110,"전지연",79,60,75,214,71.333333333333329,"불합격","평균이하"]
[null,null,null,null,null,null,"전체평균",{"$f":"AVERAGE(H7:H16)","v":79.63333333333334},null,null,null,"평균점수",null,null,"인원수"]
[null,null,null,null,null,null,null,null,null,null,null,0,"~",20]
[null,"[표2]",null,null,null,null,null,null,null,null,null,20,"~",40]
[null,"수험번호","성명","엑셀","인터넷","평균","합격여부1","합격여부2","평가",null,null,40,"~",60]
[null,"SM20001","이재근",95,88,{"$f":"AVERAGE(D21:E21)","v":91.5},{"$f":"IF(AND(D21>=80,E21>=80),\"합격\",\"\")","v":"합격"},{"$f":"IF(OR(AND(D21>=70,E21>=70),F21>=80),\"합격\",\"\")","v":"합격"},{"$f":"IF(F21>=90,\"수\",IF(F21>=80,\"우\",IF(F21>=70,\"미\",IF(F21>=60,\"양\",\"가\"))))","v":"수"},null,null,60,"~",80]
[null,"SM20002","김민선",62,75,{"$f":"AVERAGE(D22:E22)","v":68.5},{"$f":"IF(AND(D22>=80,E22>=80),\"합격\",\"\")","v":""},{"$f":"IF(OR(AND(D22>=70,E22>=70),F22>=80),\"합격\",\"\")","v":""},{"$f":"IF(F22>=90,\"수\",IF(F22>=80,\"우\",IF(F22>=70,\"미\",IF(F22>=60,\"양\",\"가\"))))","v":"양"},null,null,80,"~",100]
[null,"SM20003","이종원",86,100,93,"합격","합격","수"]
[null,"SM20004","한고은",60,80,70,"","","미"]
[null,"SM20007","장나라",100,70,85,"","합격","우"]
[null,"SM20008","김민종",77,80,78.5,"","합격","미"]
[null,"SM20009","이준희",80,60,70,"","","미"]
[]
[null,"제품판매 현황"]
[null,"[표3]"]
[null,"제품코드","분류","단가","판매량","판매금액","담당자",null,"[ 분류/담당자 기준 판매건수 ]"]
[null,"238VM357","아동의류",75300,5,{"$f":"D32*E32","v":376500},"이하원",null,"분류","조승재","이하원","박재민"]
[null,"537RI257","여성의류",72400,13,{"$f":"D33*E33","v":941200},"조승재",null,"여성의류",{"$f":"COUNTIFS($C$32:$C$46,$I33,$G$32:$G$46,J$32)","v":2},{"$f":"COUNTIFS($C$32:$C$46,$I33,$G$32:$G$46,K$32)","v":2},0]
[null,"575HE011","여성의류",31500,12,378000,"이하원",null,"남성의류",{"$f":"COUNTIFS($C$32:$C$46,$I34,$G$32:$G$46,J$32)","v":1},0,1]
[null,"254DN251","기타",11400,11,125400,"박재민",null,"아동의류",2,2,0]
[null,"188KY649","아동의류",24200,30,726000,"조승재",null,"언더웨어",1,1,1]
[null,"143VI197","남성의류",43400,30,1302000,"조승재",null,"기타",0,0,2]
[null,"640XM642","남성의류",51900,7,363300,"박재민"]
[null,"661SY624","기타",59200,2,118400,"박재민"]
[null,"877PF846","아동의류",65500,12,786000,"이하원",null,"[ 분류/담당자 기준 판매량 합계 ]"]
[null,"937CR318","아동의류",75100,28,2102800,"조승재",null,"분류","조승재","이하원","박재민"]
[null,"546TK605","언더웨어",26000,8,208000,"조승재",null,"여성의류",{"$f":"SUMIFS($E$32:$E$46,$C$32:$C$46,$I42,$G$32:$G$46,J$41)","v":26},{"$f":"SUMIFS($E$32:$E$46,$C$32:$C$46,$I42,$G$32:$G$46,K$41)","v":32},0]
[null,"897RP526","여성의류",9200,13,119600,"조승재",null,"남성의류",{"$f":"SUMIFS($E$32:$E$46,$C$32:$C$46,$I43,$G$32:$G$46,J$41)","v":30},0,7]
[null,"823CC448","언더웨어",45400,23,1044200,"이하원",null,"아동의류",58,17,0]
[null,"294WR619","여성의류",44500,20,890000,"이하원",null,"언더웨어",8,23,15]
[null,"582YB244","언더웨어",27500,15,412500,"박재민",null,"기타",0,0,13]
[]
[null,"영업팀 매출 현황"]
[null,"[표4]"]
[null,"이름","소속","상반기","하반기"]
[null,"유동근","영업3팀",5626,8583,null,"[ 영업팀별 평균 매출량 ]"]
[null,"전경숙","영업2팀",3603,7406,null,"소속","상반기","하반기"]
[null,"백수정","영업2팀",6305,5700,null,"영업1팀",{"$f":"AVERAGEIF($C$51:$C$64,$G53,D$51:D$64)","v":4197.8},{"$f":"AVERAGEIF($C$51:$C$64,$G53,E$51:E$64)","v":4954.2}]
[null,"안현철","영업1팀",4905,8619,null,"영업2팀",{"$f":"AVERAGEIF($C$51:$C$64,$G54,D$51:D$64)","v":5518.8},6031]
[null,"고성남","영업3팀",4272,4082,null,"영업3팀",6195.75,5433.25]
[null,"민병철","영업2팀",3758,4948]
[null,"조광연","영업1팀",5790,2765]
[null,"김연우","영업3팀",7122,5935]
[null,"김범수","영업2팀",7802,4012]
[null,"임재범","영업1팀",2668,3682]
[null,"박정현","영업3팀",7763,3133]
[null,"오동석","영업1팀",5123,5841]
[null,"이하원","영업1팀",2503,3864]
[null,"박오연","영업2팀",6126,8089]

{"sheet":"3. 참조함수","index":6,"n_rows":43,"n_cols":23,"rows_kept":43,"cut":false,"hidden":false,"merged":[[35,8,35,12],[3,14,3,21],[23,14,23,22],[25,6,25,11],[3,1,3,9],[13,1,13,12],[23,1,23,11],[33,1,33,12],[1,1,1,2],[1,3,1,6],[15,7,15,12],[5,7,5,9],[25,21,25,22],[5,20,5,21],[11,20,11,21]]}
[]
[null,"참조함수",null,"VLOOKUP, HLOOKUP"]
[]
[null,"이미남학원 강사 급여",null,null,null,null,null,null,null,null,null,null,null,null,"제품명으로 단가를 구하고, 수량에 따라 할인율 구하기"]
[null,"[표1]",null,null,null,null,null,null,null,null,null,null,null,null,"[표5]"]
[null,"성명","직급","기본급","직급수당","총액",null,"[급여]",null,null,null,null,null,null,"번호","제품명","단가","수량","할인율",null,"[단가표]"]
[null,"박상민","과장",null,null,null,null,"직급","기본급","직급수당",null,null,null,null,1,"색연필",null,103,null,null,"제품명","단가"]
[null,"엄정화","대리",null,null,null,null,"사원",750000,70000,null,null,null,null,2,"물통",null,95,null,null,"색연필",2500]
[null,"장나라","사원",null,null,null,null,"대리",800000,80000,null,null,null,null,3,"색연필",null,108,null,null,"스케치북",3000]
[null,"박민철","사원",null,null,null,null,"과장",900000,90000,null,null,null,null,4,"스케치북",null,92,null,null,"물통",1800]
[null,"박상면","과장",null,null,null,null,null,null,null,null,null,null,null,5,"물통",null,80]
[null,"장희선","사원",null,null,null,null,null,null,null,null,null,null,null,6,"색연필",null,111,null,null,"[할인율표]"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,"스케치북",null,36,null,null,"수량","할인율"]
[null,"이미남학원 수강생 직업 분포도",null,null,null,null,null,null,null,null,null,null,null,null,8,"색연필",null,20,null,null,0,0]
[null,"[표2]",null,null,null,null,null,null,null,null,null,null,null,null,9,"물통",null,14,null,null,30,0.05]
[null,"연번","이름","직업코드","직업","사용금액",null,"[직업표]",null,null,null,null,null,null,10,"스케치북",null,80,null,null,50,0.15]
[null,1,"김미정",5,null,null,null,"코드",1,2,3,4,5,null,11,"물통",null,25,null,null,100,0.2]
[null,2,"김영정",1,null,null,null,"직업","학생","군인","공무원","교사","회사원",null,12,"색연필",null,78]
[null,3,"김영한",3,null,null,null,"사용금액",100,50,20,50,70,null,13,"스케치북",null,132]
[null,4,"남시정",2,null,null,null,null,null,null,null,null,null,null,14,"색연필",null,46]
[null,5,"민형곤",4]
[null,6,"김시진",5]
[]
[null,"참조함수 연습문제",null,null,null,null,null,null,null,null,null,null,null,null,"평균으로 학점 구하기 "]
[null,"[표3]",null,null,null,null,null,null,null,null,null,null,null,null,"[표6]"]
[null,"성명","주문금액","할인금액","계산금액",null,"[할인금액 표]",null,null,null,null,null,null,null,"이름","국어","영어","수학","평균","학점",null,"[점수 평가표]"]
[null,"심형래",50000,null,null,null,"주문금액",0,10000,20000,40000,80000,null,null,"마은성",64,77,50,null,null,null,"점수","학점"]
[null,"김봉현",10000,null,null,null,"할인금액",null,100,200,300,500,null,null,"전준호",62,82,70,null,null,null,0,"가"]
[null,"이찬호",5000,null,null,null,null,null,null,null,null,null,null,null,"임홍삼",84,92,95,null,null,null,60,"양"]
[null,"박이슈",45000,null,null,null,null,null,null,null,null,null,null,null,"구재석",99,80,75,null,null,null,70,"미"]
[null,"이장군",15000,null,null,null,null,null,null,null,null,null,null,null,"김혜린",87,87,54,null,null,null,80,"우"]
[null,"황건이",95000,null,null,null,null,null,null,null,null,null,null,null,"심영국",70,46,65,null,null,null,90,"수"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"강민수",91,98,85]
[null,"사원연수 평가",null,null,null,null,null,null,null,null,null,null,null,null,"황길호",70,90,85]
[null,"[표4]",null,null,null,null,null,null,null,null,null,null,null,null,"장미자",90,90,88]
[null,"사원명","1차연수","2차연수","3차연수","평균","평가",null,"[점수 평가표]",null,null,null,null,null,"강미란",49,51,94]
[null,"고미근",67,47,61,null,null,null,"평균점수",0,70,80,90]
[null,"나미희",80,90,56,null,null,null,"평가","D","C","B","A"]
[null,"김만재",78,90,78]
[null,"안달호",34,56,65]
[null,"나영일",87,90,100]
[null,"지순화",65,54,45]
[null,"가운데",80,70,60]

{"sheet":"3. 참조함수-정답","index":7,"n_rows":43,"n_cols":23,"rows_kept":43,"cut":false,"hidden":false,"merged":[[33,1,33,12],[35,8,35,12],[11,20,11,21],[13,1,13,12],[15,7,15,12],[23,1,23,11],[23,14,23,22],[25,6,25,11],[25,21,25,22],[1,1,1,2],[1,3,1,6],[3,1,3,9],[3,14,3,21],[5,7,5,9],[5,20,5,21]]}
[]
[null,"참조함수",null,"VLOOKUP, HLOOKUP"]
[]
[null,"이미남학원 강사 급여",null,null,null,null,null,null,null,null,null,null,null,null,"제품명으로 단가를 구하고, 수량에 따라 할인율 구하기"]
[null,"[표1]",null,null,null,null,null,null,null,null,null,null,null,null,"[표5]"]
[null,"성명","직급","기본급","직급수당","총액",null,"[급여]",null,null,null,null,null,null,"번호","제품명","단가","수량","할인율",null,"[단가표]"]
[null,"박상민","과장",{"$f":"VLOOKUP(C7,$H$8:$J$10,2,0)","v":900000},{"$f":"VLOOKUP(C7,$H$8:$J$10,3,0)","v":90000},{"$f":"SUM(D7:E7)","v":990000},null,"직급","기본급","직급수당",null,null,null,null,1,"색연필",null,103,null,null,"제품명","단가"]
[null,"엄정화","대리",{"$f":"VLOOKUP(C8,$H$8:$J$10,2,0)","v":800000},{"$f":"VLOOKUP(C8,$H$8:$J$10,3,0)","v":80000},{"$f":"SUM(D8:E8)","v":880000},null,"사원",750000,70000,null,null,null,null,2,"물통",null,95,null,null,"색연필",2500]
[null,"장나라","사원",750000,70000,820000,null,"대리",800000,80000,null,null,null,null,3,"색연필",null,108,null,null,"스케치북",3000]
[null,"박민철","사원",750000,70000,820000,null,"과장",900000,90000,null,null,null,null,4,"스케치북",null,92,null,null,"물통",1800]
[null,"박상면","과장",900000,90000,990000,null,null,null,null,null,null,null,null,5,"물통",null,80]
[null,"장희선","사원",750000,70000,820000,null,null,null,null,null,null,null,null,6,"색연필",null,111,null,null,"[할인율표]"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,"스케치북",null,36,null,null,"수량","할인율"]
[null,"이미남학원 수강생 직업 분포도",null,null,null,null,null,null,null,null,null,null,null,null,8,"색연필",null,20,null,null,0,0]
[null,"[표2]",null,null,null,null,null,null,null,null,null,null,null,null,9,"물통",null,14,null,null,30,0.05]
[null,"연번","이름","직업코드","직업","사용금액",null,"[작업표]",null,null,null,null,null,null,10,"스케치북",null,80,null,null,50,0.15]
[null,1,"김미정",5,{"$f":"HLOOKUP(D17,$I$17:$M$19,2,0)","v":"회사원"},{"$f":"HLOOKUP(D17,$I$17:$M$19,3,0)","v":70},null,"코드",1,2,3,4,5,null,11,"물통",null,25,null,null,100,0.2]
[null,2,"김영정",1,{"$f":"HLOOKUP(D18,$I$17:$M$19,2,0)","v":"학생"},{"$f":"HLOOKUP(D18,$I$17:$M$19,3,0)","v":100},null,"직업","학생","군인","공무원","교사","회사원",null,12,"색연필",null,78]
[null,3,"김영한",3,"공무원",20,null,"사용금액",100,50,20,50,70,null,13,"스케치북",null,132]
[null,4,"남시정",2,"군인",50,null,null,null,null,null,null,null,null,14,"색연필",null,46]
[null,5,"민형곤",4,"교사",50]
[null,6,"김시진",5,"회사원",70]
[]
[null,"참조함수 연습문제",null,null,null,null,null,null,null,null,null,null,null,null,"평균으로 학점 구하기 "]
[null,"[표3]",null,null,null,null,null,null,null,null,null,null,null,null,"[표6]"]
[null,"성명","주문금액","할인금액","계산금액",null,"[할인금액 표]",null,null,null,null,null,null,null,"이름","국어","영어","수학","평균","학점",null,"[점수 평가표]"]
[null,"심형래",50000,{"$f":"HLOOKUP(C27,$H$27:$L$28,2,1)","v":300},{"$f":"C27-D27","v":49700},null,"주문금액",0,10000,20000,40000,80000,null,null,"마은성",64,77,50,null,null,null,"점수","학점"]
[null,"김봉현",10000,{"$f":"HLOOKUP(C28,$H$27:$L$28,2,1)","v":100},{"$f":"C28-D28","v":9900},null,"할인금액",null,100,200,300,500,null,null,"전준호",62,82,70,null,null,null,0,"가"]
[null,"이찬호",5000,0,5000,null,null,null,null,null,null,null,null,null,"임홍삼",84,92,95,null,null,null,60,"양"]
[null,"박이슈",45000,300,44700,null,null,null,null,null,null,null,null,null,"구재석",99,80,75,null,null,null,70,"미"]
[null,"이장군",15000,100,14900,null,null,null,null,null,null,null,null,null,"김혜린",87,87,54,null,null,null,80,"우"]
[null,"황건이",95000,500,94500,null,null,null,null,null,null,null,null,null,"심영국",70,46,65,null,null,null,90,"수"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"강민수",91,98,85]
[null,"사원연수 평가",null,null,null,null,null,null,null,null,null,null,null,null,"황길호",70,90,85]
[null,"[표4]",null,null,null,null,null,null,null,null,null,null,null,null,"장미자",90,90,88]
[null,"사원명","1차연수","2차연수","3차연수","평균","평가",null,"[점수 평가표]",null,null,null,null,null,"강미란",49,51,94]
[null,"고미근",67,47,61,{"$f":"AVERAGE(C37:E37)","v":58.333333333333336},{"$f":"HLOOKUP(F37,$J$37:$M$38,2,1)","v":"D"},null,"평균점수",0,70,80,90]
[null,"나미희",80,90,56,{"$f":"AVERAGE(C38:E38)","v":75.333333333333329},{"$f":"HLOOKUP(F38,$J$37:$M$38,2,1)","v":"C"},null,"평가","D","C","B","A"]
[null,"김만재",78,90,78,82,"B"]
[null,"안달호",34,56,65,51.666666666666664,"D"]
[null,"나영일",87,90,100,92.333333333333329,"A"]
[null,"지순화",65,54,45,54.666666666666664,"D"]
[null,"가운데",80,70,60,70,"C"]

{"sheet":"4.날짜와 시간함수","index":8,"n_rows":41,"n_cols":11,"rows_kept":41,"cut":false,"hidden":false,"merged":[[27,1,27,7],[42,1,42,7],[43,1,43,7],[44,1,44,7],[1,2,1,7],[14,2,14,5]]}
[]
[null,"날짜시간함수","TODAY, NOW, YEAR, MONTH, DAY, DATE, HOUR, MINUTE, SECOND, TIME, WEEKDAY, CHOOSE"]
[null,"[표1]",null,null,"[표2]"]
[null,"현재날짜+시각",null,null,"현재년도","현재월","현재일","현재날짜"]
[null,"현재날짜"]
[null,"[표4]",null,null,"[표3]"]
[null,"현재날짜","요일",null,"현재시","현재분","현재초","현재시간"]
[null,{"$f":"TODAY()","v":"2020-01-14"}]
[null,{"$f":"B8+1","v":"2020-01-15"}]
[null,{"$f":"B9+1","v":"2020-01-16"}]
[null,"2020-01-17"]
[null,"2020-01-18"]
[null,"2020-01-19"]
[]
[null,"문자열함수","RIGHT, LEFT, MID, LEN, UPPER, LOWER, PROPER",null,null,null,null,null,null,null,{"$f":"WEEKDAY(C5,3)","v":5}]
[null,"[표4]"]
[null,"데이터","LEFT","RIGHT","MID","LEN"]
[null,"750522-2526525"]
[null,"엑셀배우기"]
[null,"I LOVE YOU"]
[]
[null,"[표5]"]
[null,"데이터","ID","REPLACE","SUBSTITUTE","CONCATENATE","SEARCH","ID만 추출"]
[null,"씨앗컴퓨터학원","yi-wonki@hanmail.net"]
[null,"열매컴퓨터학원","won2520179@naver.com"]
[null,"잎새컴퓨터학원","yiwonk71@gmail.com"]
[]
[null,"사원신상명세서"]
[null,"[표6]"]
[null,"입사일","성명","주민등록번호","생년월일","나이","성별","근무년수"]
[null,"1987-12-05","김남주","651102-2015210"]
[null,"1990-02-20","이경배","691022-1252310"]
[null,"1995-05-22","오미영","720210-2023417"]
[null,"1998-11-11","정수진","770310-2112541"]
[null,"1988-07-05","신현준","630630-1253241"]
[null,"1999-01-22","최승원","760521-1523642"]
[null,"1996-02-05","황수경","700328-2154685"]
[null,"1990-02-20","박민우","701203-1546211"]
[null,"1993-06-30","이영주","730420-2156421"]
[null,"1998-01-21","장나라","790513-2254230"]
[null,"1998-07-05","김민종","781250-1235200"]

{"sheet":"4.날짜와 시간함수-정답","index":9,"n_rows":41,"n_cols":11,"rows_kept":41,"cut":false,"hidden":false,"merged":[[44,1,44,7],[1,2,1,7],[14,2,14,5],[27,1,27,7],[42,1,42,7],[43,1,43,7]]}
[]
[null,"날짜시간함수","TODAY, NOW, YEAR, MONTH, DAY, DATE, HOUR, MINUTE, SECOND, TIME, WEEKDAY, CHOOSE"]
[null,"[표1]",null,null,"[표2]"]
[null,"현재날짜+시각",{"$f":"NOW()","v":"2020-01-14T22:11:44.300"},null,"현재년도","현재월","현재일","현재날짜"]
[null,"현재날짜",{"$f":"TODAY()","v":"2020-01-14"},null,{"$f":"YEAR(TODAY())","v":2020},{"$f":"MONTH(TODAY())","v":1},{"$f":"DAY(TODAY())","v":14},{"$f":"DATE(E5,F5,G5)","v":"2020-01-14"}]
[null,"[표4]",null,null,"[표3]"]
[null,"현재날짜","요일",null,"현재시","현재분","현재초","현재시간"]
[null,{"$f":"TODAY()","v":"2020-01-14"},{"$f":"CHOOSE(WEEKDAY(B8,2),\"월요일\",\"화요일\",\"수요일\",\"목요일\",\"금요일\",\"토요일\",\"일요일\")","v":"화요일"},null,{"$f":"HOUR(NOW())","v":22},{"$f":"MINUTE(NOW())","v":11},{"$f":"SECOND(NOW())","v":44},{"$f":"TIME(E8,F8,G8)","v":"22:11:44"}]
[null,{"$f":"B8+1","v":"2020-01-15"},{"$f":"CHOOSE(WEEKDAY(B9,2),\"월요일\",\"화요일\",\"수요일\",\"목요일\",\"금요일\",\"토요일\",\"일요일\")","v":"수요일"}]
[null,{"$f":"B9+1","v":"2020-01-16"},"목요일"]
[null,"2020-01-17","금요일"]
[null,"2020-01-18","토요일"]
[null,"2020-01-19","일요일"]
[]
[null,"문자열함수","RIGHT, LEFT, MID, LEN, UPPER, LOWER, PROPER",null,null,null,null,null,null,null,{"$f":"WEEKDAY(C5,3)","v":1}]
[null,"[표4]"]
[null,"데이터","LEFT","RIGHT","MID","LEN"]
[null,"750522-2526525",{"$f":"LEFT(B18,3)","v":"750"},{"$f":"RIGHT(B18,4)","v":"6525"},{"$f":"MID(B18,8,3)","v":"252"},{"$f":"LEN(B18)","v":14}]
[null,"엑셀배우기"]
[null,"I LOVE YOU",{"$f":"LOWER(B20)","v":"i love you"},{"$f":"UPPER(C20)","v":"I LOVE YOU"},{"$f":"PROPER(D20)","v":"I Love You"}]
[]
[null,"[표5]"]
[null,"데이터","ID","REPLACE","SUBSTITUTE","CONCATENAGE","SEARCH","ID만 추출"]
[null,"씨앗컴퓨터학원","yi-wonki@hanmail.net",{"$f":"REPLACE(B24,3,5,\"그룹\")","v":"씨앗그룹"},{"$f":"SUBSTITUTE(D24,\"그룹\",\"학원\",1)","v":"씨앗학원"},{"$f":"CONCATENATE(LEFT(E24,2),\"컴퓨터\",RIGHT(E24,2))","v":"씨앗컴퓨터학원"},{"$f":"SEARCH(\"@\",C24)","v":9},{"$f":"LEFT(C24,SEARCH(\"@\",C24)-1)","v":"yi-wonki"}]
[null,"열매컴퓨터학원","won2520179@naver.com",{"$f":"REPLACE(B25,3,5,\"그룹\")","v":"열매그룹"},{"$f":"SUBSTITUTE(D25,\"그룹\",\"학원\",1)","v":"열매학원"},{"$f":"CONCATENATE(LEFT(E25,2),\"컴퓨터\",RIGHT(E25,2))","v":"열매컴퓨터학원"},{"$f":"SEARCH(\"@\",C25)","v":11},{"$f":"LEFT(C25,SEARCH(\"@\",C25)-1)","v":"won2520179"}]
[null,"잎새컴퓨터학원","yiwonk71@gmail.com","잎새그룹","잎새학원","잎새컴퓨터학원",9,"yiwonk71"]
[]
[null,"사원신상명세서"]
[null,"[표6]"]
[null,"입사일","성명","주민등록번호","생년월일","나이","성별","근무년수"]
[null,"1987-12-05","김남주","651102-2015210",{"$f":"DATE(LEFT(D31,2),MID(D31,3,2),MID(D31,5,2))","v":"1965-11-02"},{"$f":"YEAR(TODAY())-LEFT(D31,2)-1900+1","v":56},{"$f":"IF(OR(MID(D31,8,1)=\"1\",MID(D31,8,1)=\"3\"),\"남자\",\"여자\")","v":"여자"},{"$f":"YEAR(TODAY())-YEAR(B31)","v":33}]
[null,"1990-02-20","이경배","691022-1252310",{"$f":"DATE(LEFT(D32,2),MID(D32,3,2),MID(D32,5,2))","v":"1969-10-22"},{"$f":"YEAR(TODAY())-LEFT(D32,2)-1900+1","v":52},{"$f":"IF(OR(MID(D32,8,1)=\"1\",MID(D32,8,1)=\"3\"),\"남자\",\"여자\")","v":"남자"},{"$f":"YEAR(TODAY())-YEAR(B32)","v":30}]
[null,"1995-05-22","오미영","720210-2023417","1972-02-10",49,"여자",25]
[null,"1998-11-11","정수진","770310-2112541","1977-03-10",44,"여자",22]
[null,"1988-07-05","신현준","630630-1253241","1963-06-30",58,"남자",32]
[null,"1999-01-22","최승원","760521-1523642","1976-05-21",45,"남자",21]
[null,"1996-02-05","황수경","700328-2154685","1970-03-28",51,"여자",24]
[null,"1990-02-20","박민우","701203-1546211","1970-12-03",51,"남자",30]
[null,"1993-06-30","이영주","730420-2156421","1973-04-20",48,"여자",27]
[null,"1998-01-21","장나라","790513-2254230","1979-05-13",42,"여자",22]
[null,"1998-07-05","김민종","781250-1235200","1979-01-19",43,"남자",22]

{"sheet":"5.데이터베이스함수","index":10,"n_rows":41,"n_cols":13,"rows_kept":41,"cut":false,"hidden":false,"merged":[[31,1,31,5],[36,1,36,5],[40,1,40,5],[1,3,1,5],[5,7,5,8],[6,7,6,8],[1,1,1,2],[10,1,10,5],[14,1,14,5],[19,1,19,5],[23,1,23,5],[27,1,27,5]]}
[]
[null,"데이터베이스 함수",null,"DSUM, DAVEERAGE, DMAX, DMIN, DCOUNT, DCOUNTA, DVAR, DSTDEV 등"]
[null,"[표1]"]
[null,"이름","직급","입사일","기본급","상여금",null,"지역이 '서울특별시'이고 거래량이 5000 이상인 레코드를 찾아 거래량이 합계와 평균을 구하시오"]
[null,"김동식","대리","1999-03-03",8500,5000]
[null,"이민정","부장","2000-10-05",10000,600,null,"거래량의 합계"]
[null,"홍명보","대리","1980-04-02",8000,900,null,"거래량의 평균"]
[null,"박동축","대리","1985-02-02",12000,300,null,"[표2]"]
[null,"김정민","부장","1995-03-02",75000,200,null,"고객번호","거래처명","담당자","지역","거래량","거래금액"]
[null,null,null,null,null,null,null,"LONEP","개성 트레이딩","마은성","경기도",2010,5344000]
[null,"1. 직급이 대리인 사람들의 기본급의 합계를 구하시오.",null,null,null,null,null,"QUEDE","게이트웨이 통상","전준호","대전광역시",5116,23276000]
[null,null,null,null,null,null,null,"LILAS","경동 무역","임홍삼","서울특별시",6834,55708000]
[null,null,null,null,null,null,null,"AROUT","경성 트레이딩","구재석","인천광역시",6753,47148000]
[null,null,null,null,null,null,null,"GALED","광성 교역","김혜린","서울특별시",2818,34249000]
[null,"2. 이름이 김으로 시작하거나, 직급이 부장인 사람들의 상여금합계를 구하시오.",null,null,null,null,null,"TRADH","국제 무역","심영국","서울특별시",3153,39500000]
[null,null,null,null,null,null,null,"DRACD","극동 무역","강민수","서울특별시",3844,48348000]
[null,null,null,null,null,null,null,"ISLAT","글로리아 백화점","황길호","서울특별시",4573,69436000]
[null,null,null,null,null,null,null,"RATTC","금강","장미자","경기도",5751,54570000]
[null,null,null,null,null,null,null,"WELLI","금화 유통","강미란","부산광역시",6646,44453000]
[null,"3. 직급이 부장인 사람들의 기본급의 평균을 구하시오.",null,null,null,null,null,"LETSS","대광 상사","민병철","경기도",7582,65256000]
[null,null,null,null,null,null,null,"SPECD","대성 교역","황영신","서울특별시",5313,5411000]
[null,null,null,null,null,null,null,"COMMI","대진 상사","천용만","서울특별시",6822,41232000]
[null,null,null,null,null,null,null,"ANTON","동광 통상","조자룡","서울특별시",3689,36240000]
[null,"4. 직급이 대리이면서 입사일이 1999년 1월 1일 이전이 사람들의 상여금 평균을 구하시오.",null,null,null,null,null,"CHOPS","동남 상사","강태준","서울특별시",4693,78625000]
[null,null,null,null,null,null,null,"PERIC","동도 교역","하사헌","부산광역시",6328,26590000]
[null,null,null,null,null,null,null,"LEHMS","동방 무역","최한기","서울특별시",2057,18011000]
[null,null,null,null,null,null,null,"GROSR","동성 직배","마창진","서울특별시",7138,11498000]
[null,"5. 직급이 부장인 사람들의 인원수를 구하시오.",null,null,null,null,null,"PRINI","동신 상사","최춘실","전라북도",3269,54240000]
[null,null,null,null,null,null,null,"GOURL","동양 무역","한빈","경기도",6224,71259000]
[null,null,null,null,null,null,null,"THECR","몽블랑 백화점","박찬희","서울특별시",4290,64744000]
[null,null,null,null,null,null,null,"FRANR","미림 백화점","이혜준","경기도",6503,63932000]
[null,"6. 기본급이 10000 이상이거나, 이름이 홍으로 시작하는 사람들의 인원수를 구하시오.",null,null,null,null,null,"QUICK","미성 백화점","호혜경","인천광역시",6623,11499000]
[null,null,null,null,null,null,null,"WILMK","미주 상사","박춘심","서울특별시",6706,77767000]
[null,null,null,null,null,null,null,"ROMEY","백조 백화점","안재혁","경기도",7169,31642000]
[null,null,null,null,null,null,null,"BLONP","베네디스 유통","장선희","서울특별시",7905,14912000]
[null,null,null,null,null,null,null,"QUEEN","사하라 통상","정가진","서울특별시",6822,74354000]
[null,"7. 입사일이 1995년 1월 1일 이후인 사람들의 기본급 중 가장 큰 값을 구하시오.",null,null,null,null,null,"TOMSP","산타페","박영아","경기도",2088,46434000]
[null,null,null,null,null,null,null,"OTTIK","삼선 무역","구재석","경기도",6190,60234000]
[null,null,null,null,null,null,null,"SUPRD","삼양 상사","감성동","서울특별시",5915,38408000]
[null,null,null,null,null,null,null,"TRAIH","삼영 식품","배한석","경기도",5297,31554000]
[null,"8. 입사일이 1995년 1월 1일 이후인 사람들의 상여금 중 가장 작은 값을 구하시오."]

{"sheet":"5.데이터베이스함수-정답","index":11,"n_rows":43,"n_cols":13,"rows_kept":43,"cut":false,"hidden":false,"merged":[[40,1,40,5],[1,1,1,2],[1,3,1,5],[5,7,5,8],[6,7,6,8],[10,1,10,5],[14,1,14,5],[19,1,19,5],[23,1,23,5],[27,1,27,5],[31,1,31,5],[36,1,36,5]]}
[]
[null,"데이터베이스 함수",null,"DSUM, DAVEERAGE, DMAX, DMIN, DCOUNT, DCOUNTA, DVAR, DSTDEV 등"]
[null,"[표1]"]
[null,"이름","직급","입사일","기본급","상여금",null,"지역이 '서울특별시'이고 거래량이 5000 이상인 레코드를 찾아 거래량이 합계와 평균을 구하시오"]
[null,"김동식","대리","1999-03-03",8500,5000]
[null,"이민정","부장","2000-10-05",10000,600,null,"거래량의 합계",null,{"$f":"DSUM(H9:M40,L9,L6:M7)","v":53455},null,"지역","거래량"]
[null,"홍명보","대리","1980-04-02",8000,900,null,"거래량의 평균",null,{"$f":"DAVERAGE(H9:M40,L9,L6:M7)","v":6681.875},null,"서울특별시",">=5000"]
[null,"박동축","대리","1985-02-02",12000,300,null,"[표2]"]
[null,"김정민","부장","1995-03-02",75000,200,null,"고객번호","거래처명","담당자","지역","거래량","거래금액"]
[null,null,null,null,null,null,null,"LONEP","개성 트레이딩","마은성","경기도",2010,5344000]
[null,"1. 직급이 대리인 사람들의 기본급의 합계를 구하시오.",null,null,null,null,null,"QUEDE","게이트웨이 통상","전준호","대전광역시",5116,23276000]
[null,null,"직급",null,null,{"$f":"DSUM(B4:F9,E4,C12:C13)","v":28500},null,"LILAS","경동 무역","임홍삼","서울특별시",6834,55708000]
[null,null,"대리",null,null,null,null,"AROUT","경성 트레이딩","구재석","인천광역시",6753,47148000]
[null,null,null,null,null,null,null,"GALED","광성 교역","김혜린","서울특별시",2818,34249000]
[null,"2. 이름이 김으로 시작하거나, 직급이 부장인 사람들의 상여금합계를 구하시오.",null,null,null,null,null,"TRADH","국제 무역","심영국","서울특별시",3153,39500000]
[null,null,"이름","직급",null,{"$f":"DSUM(B4:F9,F4,C16:D18)","v":5800},null,"DRACD","극동 무역","강민수","서울특별시",3844,48348000]
[null,null,"김*",null,null,null,null,"ISLAT","글로리아 백화점","황길호","서울특별시",4573,69436000]
[null,null,null,"부장",null,null,null,"RATTC","금강","장미자","경기도",5751,54570000]
[null,null,null,null,null,null,null,"WELLI","금화 유통","강미란","부산광역시",6646,44453000]
[null,"3. 직급이 부장인 사람들의 기본급의 평균을 구하시오.",null,null,null,null,null,"LETSS","대광 상사","민병철","경기도",7582,65256000]
[null,null,"직급",null,null,{"$f":"DAVERAGE(B4:F9,E4,C21:C22)","v":42500},null,"SPECD","대성 교역","황영신","서울특별시",5313,5411000]
[null,null,"부장",null,null,null,null,"COMMI","대진 상사","천용만","서울특별시",6822,41232000]
[null,null,null,null,null,null,null,"ANTON","동광 통상","조자룡","서울특별시",3689,36240000]
[null,"4. 직급이 대리이면서 입사일이 1999년 1월 1일 이전이 사람들의 상여금 평균을 구하시오.",null,null,null,null,null,"CHOPS","동남 상사","강태준","서울특별시",4693,78625000]
[null,null,"직급","입사일",null,{"$f":"DAVERAGE(B4:F9,F4,C25:D26)","v":600},null,"PERIC","동도 교역","하사헌","부산광역시",6328,26590000]
[null,null,"대리","<=1999-1-1",null,null,null,"LEHMS","동방 무역","최한기","서울특별시",2057,18011000]
[null,null,null,null,null,null,null,"GROSR","동성 직배","마창진","서울특별시",7138,11498000]
[null,"5. 직급이 부장인 사람들의 인원수를 구하시오.",null,null,null,null,null,"PRINI","동신 상사","최춘실","전라북도",3269,54240000]
[null,null,"직급",null,null,{"$f":"DCOUNT(B4:F9,E4,C29:C30)","v":2},null,"GOURL","동양 무역","한빈","경기도",6224,71259000]
[null,null,"부장",null,null,null,null,"THECR","몽블랑 백화점","박찬희","서울특별시",4290,64744000]
[null,null,null,null,null,null,null,"FRANR","미림 백화점","이혜준","경기도",6503,63932000]
[null,"6. 기본급이 10000 이상이거나, 이름이 홍으로 시작하는 사람들의 인원수를 구하시오.",null,null,null,null,null,"QUICK","미성 백화점","호혜경","인천광역시",6623,11499000]
[null,null,"기본급","이름",null,{"$f":"DCOUNTA(B4:F9,C4,C33:D35)","v":4},null,"WILMK","미주 상사","박춘심","서울특별시",6706,77767000]
[null,null,">=10000",null,null,null,null,"ROMEY","백조 백화점","안재혁","경기도",7169,31642000]
[null,null,null,"홍*",null,null,null,"BLONP","베네디스 유통","장선희","서울특별시",7905,14912000]
[null,null,null,null,null,null,null,"QUEEN","사하라 통상","정가진","서울특별시",6822,74354000]
[null,"7. 입사일이 1995년 1월 1일 이후인 사람들의 기본급 중 가장 큰 값을 구하시오.",null,null,null,null,null,"TOMSP","산타페","박영아","경기도",2088,46434000]
[null,null,"입사일",null,null,{"$f":"DMAX(B4:F9,E4,C38:C39)","v":75000},null,"OTTIK","삼선 무역","구재석","경기도",6190,60234000]
[null,null,">=1995-1-1",null,null,null,null,"SUPRD","삼양 상사","감성동","서울특별시",5915,38408000]
[null,null,null,null,null,null,null,"TRAIH","삼영 식품","배한석","경기도",5297,31554000]
[null,"8. 입사일이 1995년 1월 1일 이후인 사람들의 상여금 중 가장 작은 값을 구하시오."]
[null,null,"입사일",null,null,{"$f":"DMIN(B4:F9,F4,C42:C43)","v":200}]
[null,null,">=1995-1-1"]

{"sheet":"6.기타함수","index":12,"n_rows":108,"n_cols":25,"rows_kept":108,"cut":false,"hidden":false,"merged":[[7,24,7,25],[8,24,8,25],[15,24,15,25],[16,24,16,25],[9,24,9,25],[11,24,11,25],[12,24,12,25],[13,24,13,25],[14,24,14,25],[1,1,1,2],[1,3,1,14],[4,24,4,25],[5,24,5,25],[6,24,6,25]]}
[]
[null,"기타함수",null,"ABS, INT, MOD, QUOTIENT, LARGE, SMALL, VALUE, TEXT, IFERROR, SUMPORDUCT, FREQUENCY, ROW, ROWS, COLUMN, COLUMNS, "]
[]
[null,"[표1]",null,null,null,null,null,null,"[표2]",null,null,null,null,"[표5]",null,null,null,"[표6]"]
[null,"제품명","상반기","하반기","증감","차이","평가",null,"고객명","포인트","쿠폰개수","잔여포인트",null,"순위","상위권","하위권",null,"주문","주문처","제품명","주문횟수","총수량","총금액",null,"제품명"]
[null,"오일 스크럽",6013,2146,null,null,null,null,"유동근",2526,null,null,null,1,null,null,null,"조회",null,null,null,null,null,null,"특제 굴 통조림"]
[null,"버블 오일",4690,4345,null,null,null,null,"전경숙",8562,null,null,null,2,null,null,null,"[표7]",null,null,null,null,null,null,"알파 샐러드 드레싱"]
[null,"미라클 오일",6423,2836,null,null,null,null,"백수정",4985,null,null,null,3,null,null,null,"주문일","주문처","제품명","단가","수량","금액",null,"트로피컬 칵테일"]
[null,"솔트 스크럽",4979,6846,null,null,null,null,"안현철",6966,null,null,null,null,null,null,null,"2012-07-08","미성 백화점","특제 굴 통조림",15000,25,{"$f":"U9*V9","v":375000},null,"앨리스 포장육"]
[null,"버터 바디밤",2742,5725,null,null,null,null,"고성남",4807,null,null,null,null,null,null,null,"2012-07-11","동방 무역","알파 샐러드 드레싱",10000,12,120000,null,"원양 순 상어알"]
[null,"코코넛 샤워젤",2135,5358,null,null,null,null,"박달재",5457,null,null,null,null,null,null,null,"2012-07-12","한진 교역","알파 샐러드 드레싱",10000,15,150000]
[null,"라이스 샤워젤",6155,2344,null,null,null,null,"지준혁",2561,null,null,null,null,null,null,null,"2012-07-15","한진 교역","트로피컬 칵테일",12000,21,252000,null,"주문처"]
[null,"라이스 바디 밀크",4717,6448,null,null,null,null,"박현서",645,null,null,null,null,null,null,null,"2012-07-21","우주 상사","앨리스 포장육",31000,30,930000,null,"미성 백화점"]
[null,"핸드 앤 풋 버터",2815,6442,null,null,null,null,"선채현",1816,null,null,null,null,null,null,null,"2012-07-21","한진 교역","트로피컬 칵테일",12000,20,240000,null,"동방 무역"]
[null,"워싱 그레이스",5499,4900,null,null,null,null,"임선우",7160,null,null,null,null,null,null,null,"2012-07-28","신세계 통상","특제 굴 통조림",15000,30,450000,null,"한진 교역"]
[null,"벨벳 바디크림",2579,3894,null,null,null,null,"이하원",9526,null,null,null,null,null,null,null,"2012-08-08","동방 무역","원양 순 상어알",12000,25,300000,null,"우주 상사"]
[null,"티트리 오일",5294,5815,null,null,null,null,"김여진",7940,null,null,null,null,null,null,null,"2012-08-09","우주 상사","앨리스 포장육",31000,15,465000,null,"신세계 통상"]
[null,"클리어링 로션",6419,5860,null,null,null,null,"맹채연",4657,null,null,null,null,null,null,null,"2012-08-23","우주 상사","알파 샐러드 드레싱",10000,10,100000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2012-08-26","우주 상사","앨리스 포장육",31000,15,465000]
[null,"[표3]",null,null,null,null,null,"[표4]",null,null,null,null,null,null,null,null,null,"2012-09-01","신세계 통상","특제 굴 통조림",15000,40,600000]
[null,"이름","국어","영어","수학","평균",null,"점수",null,"인원",null,null,null,null,null,null,null,"2012-09-02","동방 무역","트로피컬 칵테일",12000,20,240000]
[null,"이재석",88,95,79,{"$f":"ROUND(AVERAGE(C22:E22),0)","v":87},null,0,59,null,null,null,null,null,null,null,null,"2012-09-06","미성 백화점","앨리스 포장육",31000,40,1240000]
[null,"박현서",78,94,83,{"$f":"ROUND(AVERAGE(C23:E23),0)","v":85},null,60,69,null,null,null,null,null,null,null,null,"2012-09-14","신세계 통상","트로피컬 칵테일",12000,5,60000]
[null,"오동건",96,68,59,74,null,70,79,null,null,null,null,null,null,null,null,"2012-09-20","우주 상사","특제 굴 통조림",15000,12,180000]
[null,"김요셉",81,53,68,67,null,80,89,null,null,null,null,null,null,null,null,"2012-09-22","신세계 통상","트로피컬 칵테일",12000,30,360000]
[null,"이하원",91,90,90,90,null,90,100,null,null,null,null,null,null,null,null,"2012-09-28","미성 백화점","앨리스 포장육",31000,8,248000]
[null,"조승재",70,74,75,73,null,null,null,null,null,null,null,null,null,null,null,"2012-10-20","미성 백화점","특제 굴 통조림",15000,20,300000]
[null,"정은우",66,99,91,85,null,null,null,null,null,null,null,null,null,null,null,"2012-10-21","미성 백화점","앨리스 포장육",31000,20,620000]
[null,"선보경",65,58,97,73,null,null,null,null,null,null,null,null,null,null,null,"2012-10-24","미성 백화점","앨리스 포장육",31000,70,2170000]
[null,"김여진",70,70,56,65,null,null,null,null,null,null,null,null,null,null,null,"2012-10-26","우주 상사","특제 굴 통조림",15000,40,600000]
[null,"이채원",87,73,61,74,null,null,null,null,null,null,null,null,null,null,null,"2012-11-01","미성 백화점","앨리스 포장육",31000,36,1116000]
[null,"서지은",95,90,92,92,null,null,null,null,null,null,null,null,null,null,null,"2012-11-16","동방 무역","특제 굴 통조림",15000,20,300000]
[null,"강지현",67,84,68,73,null,null,null,null,null,null,null,null,null,null,null,"2012-11-24","한진 교역","알파 샐러드 드레싱",10000,5,50000]
[null,"박재민",90,57,66,71,null,null,null,null,null,null,null,null,null,null,null,"2012-11-24","우주 상사","알파 샐러드 드레싱",10000,7,70000]
[null,"이규형",95,77,69,80,null,null,null,null,null,null,null,null,null,null,null,"2012-11-29","우주 상사","특제 굴 통조림",15000,6,90000]
[null,"김혁중",45,55,52,51,null,null,null,null,null,null,null,null,null,null,null,"2012-12-08","미성 백화점","트로피컬 칵테일",12000,30,360000]
[null,"김우주",91,88,52,77,null,null,null,null,null,null,null,null,null,null,null,"2012-12-16","한진 교역","트로피컬 칵테일",12000,30,360000]
[null,"정보람",79,54,81,71,null,null,null,null,null,null,null,null,null,null,null,"2012-12-27","미성 백화점","알파 샐러드 드레싱",10000,14,140000]
[null,"장혁철",85,91,71,82,null,null,null,null,null,null,null,null,null,null,null,"2013-01-03","신세계 통상","특제 굴 통조림",15000,5,75000]
[null,"황채령",97,72,87,85,null,null,null,null,null,null,null,null,null,null,null,"2013-01-11","미성 백화점","앨리스 포장육",31000,2,62000]
[null,"박현율",57,67,85,70,null,null,null,null,null,null,null,null,null,null,null,"2013-01-12","미성 백화점","알파 샐러드 드레싱",10000,35,350000]
[null,"방민권",85,94,80,86,null,null,null,null,null,null,null,null,null,null,null,"2013-01-17","신세계 통상","트로피컬 칵테일",12000,8,96000]
[null,"소순규",57,93,77,76,null,null,null,null,null,null,null,null,null,null,null,"2013-01-17","우주 상사","원양 순 상어알",12000,20,240000]
[null,"임현희",89,86,78,84,null,null,null,null,null,null,null,null,null,null,null,"2013-01-17","동방 무역","알파 샐러드 드레싱",10000,10,100000]
[null,"조승철",90,85,98,91,null,null,null,null,null,null,null,null,null,null,null,"2013-01-26","우주 상사","앨리스 포장육",31000,45,1395000]
[null,"백한나",59,94,80,78,null,null,null,null,null,null,null,null,null,null,null,"2013-01-26","신세계 통상","앨리스 포장육",31000,50,1550000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2013-02-08","신세계 통상","앨리스 포장육",31000,10,310000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2013-02-15","신세계 통상","알파 샐러드 드레싱",10000,55,550000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2013-02-17","미성 백화점","트로피컬 칵테일",12000,25,300000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2013-03-13","미성 백화점","트로피컬 칵테일",12000,12,144000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2013-03-20","미성 백화점","알파 샐러드 드레싱",10000,30,300000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2013-03-21","동방 무역","트로피컬 칵테일",12000,60,720000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2013-03-23","우주 상사","원양 순 상어알",12000,20,240000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2013-03-27","미성 백화점","알파 샐러드 드레싱",10000,7,70000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2013-03-30","동방 무역","알파 샐러드 드레싱",10000,5,50000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2013-03-31","우주 상사","알파 샐러드 드레싱",10000,25,250000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2013-04-11","우주 상사","트로피컬 칵테일",15000,14,210000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2013-04-20","동방 무역","트로피컬 칵테일",15000,6,90000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2013-04-27","우주 상사","앨리스 포장육",39000,25,975000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2013-04-28","신세계 통상","특제 굴 통조림",19000,30,570000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2013-05-01","우주 상사","특제 굴 통조림",19000,30,570000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2013-05-04","한진 교역","앨리스 포장육",39000,40,1560000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2013-05-08","동방 무역","원양 순 상어알",15000,24,360000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2013-05-10","동방 무역","원양 순 상어알",15000,9,135000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2013-05-11","한진 교역","트로피컬 칵테일",15000,7,105000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2013-05-19","신세계 통상","특제 굴 통조림",19000,60,1140000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2013-05-24","신세계 통상","앨리스 포장육",39000,8,312000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2013-05-26","우주 상사","알파 샐러드 드레싱",13000,10,130000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2013-05-31","미성 백화점","원양 순 상어알",15000,3,45000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2013-06-06","한진 교역","특제 굴 통조림",19000,25,475000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2013-06-06","미성 백화점","앨리스 포장육",39000,16,624000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2013-06-15","한진 교역","앨리스 포장육",39000,18,702000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2013-06-19","미성 백화점","알파 샐러드 드레싱",13000,18,{"$f":"U73*V73","v":234000}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2013-06-28","미성 백화점","알파 샐러드 드레싱",13000,20,260000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2013-07-03","동방 무역","알파 샐러드 드레싱",13000,60,780000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2013-07-12","한진 교역","원양 순 상어알",15000,30,450000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2013-07-13","미성 백화점","알파 샐러드 드레싱",13000,5,65000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2013-07-18","미성 백화점","앨리스 포장육",39000,100,3900000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2013-07-21","우주 상사","특제 굴 통조림",19000,21,399000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2013-07-24","신세계 통상","특제 굴 통조림",19000,55,1045000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2013-07-27","한진 교역","트로피컬 칵테일",15000,15,225000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2013-08-01","미성 백화점","트로피컬 칵테일",15000,20,300000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2013-08-07","우주 상사","원양 순 상어알",15000,35,525000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2013-08-17","신세계 통상","트로피컬 칵테일",15000,15,225000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2013-08-22","우주 상사","특제 굴 통조림",19000,15,285000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2013-08-23","미성 백화점","알파 샐러드 드레싱",13000,35,455000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2013-09-01","동방 무역","알파 샐러드 드레싱",13000,70,910000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2013-09-01","한진 교역","트로피컬 칵테일",15000,40,600000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2013-09-11","미성 백화점","특제 굴 통조림",19000,30,570000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2013-09-12","신세계 통상","원양 순 상어알",15000,50,750000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2013-09-26","동방 무역","앨리스 포장육",39000,30,1170000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2013-09-26","우주 상사","특제 굴 통조림",19000,6,114000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2013-09-28","신세계 통상","알파 샐러드 드레싱",13000,30,390000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2013-10-02","우주 상사","원양 순 상어알",15000,15,225000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2013-10-02","동방 무역","트로피컬 칵테일",15000,50,750000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2013-10-04","우주 상사","앨리스 포장육",39000,20,780000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2013-10-04","우주 상사","트로피컬 칵테일",15000,30,450000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2013-10-05","한진 교역","앨리스 포장육",39000,8,312000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2013-10-05","동방 무역","트로피컬 칵테일",15000,8,120000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2013-10-10","미성 백화점","원양 순 상어알",15000,35,525000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2013-10-12","신세계 통상","트로피컬 칵테일",15000,28,420000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2013-10-13","신세계 통상","특제 굴 통조림",19000,5,95000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2013-10-18","한진 교역","앨리스 포장육",39000,27,1053000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2013-10-23","미성 백화점","특제 굴 통조림",19000,40,760000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2013-10-30","한진 교역","앨리스 포장육",39000,20,{"$f":"U105*V105","v":780000}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2013-11-06","우주 상사","알파 샐러드 드레싱",13000,2,{"$f":"U106*V106","v":26000}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2013-11-08","한진 교역","특제 굴 통조림",19000,6,{"$f":"U107*V107","v":114000}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2013-11-20","동방 무역","원양 순 상어알",15000,15,{"$f":"U108*V108","v":225000}]

{"sheet":"문서1_기초","index":13,"n_rows":15,"n_cols":7,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
["핸드폰 판매량 현황"]
[]
["제품코드","제조사","가입유형","요금제","약정기간","제품가","판매량"]
["ST-01-A","상승전자","신규가입","LTE 40","24개월",560000,485]
["ST-01-B","LT전자","번호이동","LTE 50","36개월",655000,884]
["ST-01-C","HD전자","기기변경","LTE 60","12개월",545000,623]
["ST-01-D","한국전자","신규가입","LTE 70","24개월",750000,253]
["AL-02-A","상승전자","신규가입","LTE 40","24개월",650000,687]
["AL-02-B","LT전자","번호이동","LTE 50","36개월",575000,541]
["AL-02-C","HD전자","기기변경","LTE 60","12개월",685000,865]
["AL-02-D","한국전자","신규가입","LTE 70","24개월",780000,517]
["UP-01-A","상승전자","신규가입","LTE 40","24개월",590000,347]
["UP-01-B","LT전자","번호이동","LTE 50","36개월",665000,955]
["UP-01-C","HD전자","기기변경","LTE 60","12개월",550000,347]
["UP-01-D","한국전자","신규가입","LTE 70","24개월",795000,438]

{"sheet":"문서1_기초 (정답파일)","index":14,"n_rows":15,"n_cols":7,"rows_kept":15,"cut":false,"hidden":false,"merged":[[0,0,0,6]]}
["♥핸드폰 판매량 현황♥"]
[]
["제품코드","제조사","가입유형","요금제","약정기간","제품가","販賣量"]
["ST-01-A","상승전자","신규가입","LTE 40","24개월",560000,485]
["ST-01-B","LT전자","번호이동","LTE 50","36개월",655000,884]
["ST-01-C","HD전자","기기변경","LTE 60","12개월",545000,623]
["ST-01-D","한국전자","신규가입","LTE 70","24개월",750000,253]
["AL-02-A","상승전자","신규가입","LTE 40","24개월",650000,687]
["AL-02-B","LT전자","번호이동","LTE 50","36개월",575000,541]
["AL-02-C","HD전자","기기변경","LTE 60","12개월",685000,865]
["AL-02-D","한국전자","신규가입","LTE 70","24개월",780000,517]
["UP-01-A","상승전자","신규가입","LTE 40","24개월",590000,347]
["UP-01-B","LT전자","번호이동","LTE 50","36개월",665000,955]
["UP-01-C","HD전자","기기변경","LTE 60","12개월",550000,347]
["UP-01-D","한국전자","신규가입","LTE 70","24개월",795000,438]

{"sheet":"문서1-견적서","index":15,"n_rows":30,"n_cols":9,"rows_kept":30,"cut":false,"hidden":false,"merged":[[0,0,0,8],[1,6,1,8],[2,1,2,3],[2,6,2,8],[3,1,3,3],[3,6,3,8],[15,0,15,1],[16,0,16,1],[17,0,17,1],[4,1,4,2],[4,6,4,8],[5,1,5,2],[6,0,6,3],[8,2,8,3],[8,5,8,7],[14,0,14,1],[9,0,10,1],[9,2,10,2],[9,3,10,3],[9,4,10,4],[9,7,10,7],[9,8,10,8],[11,0,11,1],[12,0,12,1],[13,0,13,1],[9,5,10,5],[9,6,10,6],[18,0,18,1],[19,0,19,1],[27,0,27,1],[28,0,28,1],[29,0,29,1],[20,0,20,1],[30,0,30,8],[21,0,21,1],[22,0,22,1],[23,0,23,1],[24,0,24,1],[25,0,25,1],[26,0,26,1]]}
["_"]
[null,null,null,null,null,null,"www.seeds21.co.kr"]
["수신 :","한림대학교 체육학부",null,null,null,"상호","씨앗컴퓨터학원"]
["참조 :","이 승 준 님",null,null,null,"사업자\n등록번호","221-90-46415"]
["TEL :","033-248-2757(2250)",null,null,null,"주소","강원도 춘천시 후평3동 891-11"]
["FAX :",null,null,null,null,"전호번호","033)\n252-0179","팩스번호","033-253-8150"]
["아래와 같이 견적합니다.",null,null,null,null,"담당","기풍쌤","담당\n전화번호","010-3078-0179"]
[]
[null,null,"합계금액",null,"(",{"$f":"H30","v":6429500},null,null,"원정)"]
["과목",null,"기간","타임","가격","단위","수강인원","합계","비고"]
[]
["컴활2급필기",null,"2주",20,70000,"원",35,{"$f":"E12*G12","v":2450000}]
["컴활2급실기",null,"2주",20,70000,"원",35,{"$f":"E13*G13","v":2450000}]
["필기교재",null,null,null,5000,"원",35,175000]
["실기교재",null,null,null,15000,"원",35,525000]
["필기시험접수료",null,null,null,10700,"원",35,374500]
["실기시험접수료",null,null,null,13000,"원",35,455000]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
["합계",null,null,null,null,null,null,{"$f":"SUM(H12:H29)","v":6429500}]

{"sheet":"문서1-연습","index":16,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"문서2-강의이력서","index":17,"n_rows":34,"n_cols":12,"rows_kept":34,"cut":false,"hidden":false,"merged":[[10,1,10,4],[1,1,5,4],[1,5,1,11],[2,5,3,5],[2,6,2,8],[2,9,2,11],[3,6,3,8],[3,9,3,11],[4,6,4,8],[4,10,4,11],[5,6,5,11],[6,1,6,11],[7,1,7,4],[7,5,7,7],[8,1,8,4],[9,1,9,4],[11,1,11,11],[12,1,12,4],[12,5,12,7],[23,1,23,11],[24,1,24,4],[24,5,24,7],[24,10,24,11],[31,1,31,11],[33,9,33,10],[25,10,25,11],[26,10,26,11],[27,10,27,11],[28,10,28,11],[29,10,29,11],[30,1,30,11]]}
[]
[null,"( 사 진 )",null,null,null,"강의이력서"]
[null,null,null,null,null,"성명",null,null,null,"주민등록번호"]
[]
[null,null,null,null,null,"연락처",null,null,null,"휴대전화"]
[null,null,null,null,null,"현주소"]
[null,"학력사항"]
[null,"학위과정",null,null,null,"기간",null,null,"학교명","전공과목","수료","졸업"]
[null,null,null,null,null,null,"∼"]
[null,null,null,null,null,null,"∼"]
[null,null,null,null,null,null,"∼"]
[null,"강의 경력 사항"]
[null,"근무년월",null,null,null,"기간",null,null,"근무처","직위","주강의시수","비고"]
[null,null,"년",null,"개월",null,"∼"]
[null,null,"년",null,"개월",null,"∼"]
[null,null,"년",null,"개월",null,"∼"]
[null,null,"년",null,"개월",null,"∼"]
[null,null,"년",null,"개월",null,"∼"]
[null,null,"년",null,"개월",null,"∼"]
[null,null,"년",null,"개월",null,"∼"]
[null,null,"년",null,"개월",null,"∼"]
[null,null,"년",null,"개월",null,"∼"]
[null,null,"년",null,"개월",null,"∼"]
[null,"전공 경력 사항"]
[null,"근무년월",null,null,null,"기간",null,null,"근무처","직위","자 격 증"]
[null,null,"년",null,"개월",null,"∼"]
[null,null,"년",null,"개월",null,"∼"]
[null,null,"년",null,"개월",null,"∼"]
[null,null,"년",null,"개월",null,"∼"]
[null,null,"년",null,"개월",null,"∼"]
[null,"상기 사항은 사실과 틀림이 없습니다."]
[null,"2004-06-15"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"(인)"]

{"sheet":"문서2-연습","index":18,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"문서3-세금계산서","index":19,"n_rows":45,"n_cols":33,"rows_kept":45,"cut":false,"hidden":false,"merged":[[1,30,1,32],[2,1,3,12],[2,13,3,13],[2,14,3,17],[2,18,3,18],[2,22,2,24],[2,26,2,27],[2,29,2,31],[3,22,3,24],[5,21,6,26],[5,27,6,27],[5,28,6,31],[5,32,6,32],[7,2,8,4],[7,5,8,16],[7,18,8,20],[7,21,8,32],[4,1,10,1],[4,2,4,4],[4,17,10,17],[4,18,4,20],[5,2,6,4],[5,5,6,10],[5,11,6,11],[5,12,6,15],[5,16,6,16],[5,18,6,20],[14,3,14,8],[14,9,14,11],[14,12,14,14],[14,15,14,19],[14,20,14,25],[14,26,14,32],[9,27,10,27],[9,28,10,32],[11,1,11,4],[11,5,11,17],[11,18,11,32],[12,1,12,2],[12,5,12,6],[12,18,13,32],[13,1,13,2],[13,5,13,6],[9,2,10,4],[9,5,10,10],[9,11,10,11],[9,12,10,16],[9,18,10,20],[9,21,10,26],[16,3,16,8],[16,9,16,11],[16,12,16,14],[16,15,16,19],[16,20,16,25],[16,26,16,32],[15,3,15,8],[15,9,15,11],[15,12,15,14],[15,15,15,19],[15,20,15,25],[15,26,15,32],[18,3,18,8],[18,9,18,11],[18,12,18,14],[18,15,18,19],[18,20,18,25],[18,26,18,32],[17,3,17,8],[17,9,17,11],[17,12,17,14],[17,15,17,19],[17,20,17,25],[17,26,17,32],[19,30,20,31],[19,32,20,32],[20,1,20,5],[20,6,20,10],[20,11,20,15],[20,16,20,20],[20,21,20,25],[19,1,19,5],[19,6,19,10],[19,11,19,15],[19,16,19,20],[19,21,19,25],[19,26,20,29],[24,30,24,32],[25,1,26,12],[25,13,26,13],[25,14,26,17],[25,18,26,18],[25,22,25,24],[25,26,25,27],[25,29,25,31],[26,22,26,24],[28,21,29,26],[28,27,29,27],[28,28,29,31],[28,32,29,32],[30,2,31,4],[30,5,31,16],[30,18,31,20],[30,21,31,32],[27,1,33,1],[27,2,27,4],[27,17,33,17],[27,18,27,20],[28,2,29,4],[28,5,29,10],[28,11,29,11],[28,12,29,15],[28,16,29,16],[28,18,29,20],[37,3,37,8],[37,9,37,11],[37,12,37,14],[37,15,37,19],[37,20,37,25],[37,26,37,32],[32,27,33,27],[32,28,33,32],[34,1,34,4],[34,5,34,17],[34,18,34,32],[35,1,35,2],[35,5,35,6],[35,18,36,32],[36,1,36,2],[36,5,36,6],[32,2,33,4],[32,5,33,10],[32,11,33,11],[32,12,33,16],[32,18,33,20],[32,21,33,26],[39,3,39,8],[39,9,39,11],[39,12,39,14],[39,15,39,19],[39,20,39,25],[39,26,39,32],[38,3,38,8],[38,9,38,11],[38,12,38,14],[38,15,38,19],[38,20,38,25],[38,26,38,32],[41,3,41,8],[41,9,41,11],[41,12,41,14],[41,15,41,19],[41,20,41,25],[41,26,41,32],[40,3,40,8],[40,9,40,11],[40,12,40,14],[40,15,40,19],[40,20,40,25],[40,26,40,32],[42,30,43,31],[42,32,43,32],[43,1,43,5],[43,6,43,10],[43,11,43,15],[43,16,43,20],[43,21,43,25],[42,1,42,5],[42,6,42,10],[42,11,42,15],[42,16,42,20],[42,21,42,25],[42,26,43,29]]}
[]
[null,"[별지 제1호 서식]",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"[청색]"]
[null,"계   산   서",null,null,null,null,null,null,null,null,null,null,null,"(","공급받는자\n보   관   용",null,null,null,")",null,null,null,"책 번 호",null,null,null,null,null,"권",null,null,null,"호"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"일련번호",null,null,null,null,null,"―"]
[null,"공 급 자","등록번호",null,null,2,2,1,"―",9,0,"―",4,6,4,1,5,"공급받는자","등록번호",null,null,null,null,null,"―",null,null,"―"]
[null,null,"상    호\n(법인명)",null,null,"씨앗컴퓨터학원",null,null,null,null,null,"성명","이원기",null,null,null,null,null,"상    호\n(법인명)",null,null,null,null,null,null,null,null,"성명"]
[]
[null,null,"사 업 장\n주    소",null,null,"강원도 춘천시 후평3동 891-11",null,null,null,null,null,null,null,null,null,null,null,null,"사 업 장\n주    소"]
[]
[null,null,"업    태",null,null,"교육.서비스",null,null,null,null,null,"종목","컴퓨터학원",null,null,null,null,null,"업    태",null,null,null,null,null,null,null,null,"종목"]
[]
[null,"작   성",null,null,null,"공    급    가    액",null,null,null,null,null,null,null,null,null,null,null,null,"비   고"]
[null,"년",null,"월","일","공란수",null,"백","십","억","천","백","십","만","천","백","십","일"]
[null,2011,null,10,12,null,null,null,null,null,null,1,8,0,0,0,0,0]
[null,"월","일","품          목",null,null,null,null,null,"규  격",null,null,"수  량",null,null,"단    가",null,null,null,null,"공 급 가 액",null,null,null,null,null,"비고"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"합계금액",null,null,null,null,"현   금",null,null,null,null,"수   표",null,null,null,null,"어   음",null,null,null,null,"외상미수금",null,null,null,null,"위 금액을 ",null,null,null,"영수",null,"함."]
[null,{"$f":"SUM(U16:AD19)","v":0}]
[null,"22226-28131일 ’96.3.27승인",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"인쇄용지(특급)34g/m2 182mm×128mm"]
[]
[]
[null,"[별지 제11호 서식]",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"[적색]"]
[null,"계   산   서",null,null,null,null,null,null,null,null,null,null,null,"(","공  급  자\n보  관  용",null,null,null,")",null,null,null,"책 번 호",null,null,null,{"$f":"IF(ISBLANK(AA3),\"\",AA3)","v":""},null,"권",{"$f":"IF(ISBLANK(AD3),\"\",AD3)","v":""},null,null,"호"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"일련번호",null,null,null,{"$f":"IF(ISBLANK(AA4),\"\",AA4)","v":""},{"$f":"IF(ISBLANK(AB4),\"\",AB4)","v":""},"―",{"$f":"IF(ISBLANK(AD4),\"\",AD4)","v":""},{"$f":"IF(ISBLANK(AE4),\"\",AE4)","v":""},"",""]
[null,"공 급 자","등록번호",null,null,{"$f":"IF(ISBLANK(F5),\"\",F5)","v":2},{"$f":"IF(ISBLANK(G5),\"\",G5)","v":2},{"$f":"IF(ISBLANK(H5),\"\",H5)","v":1},"―",{"$f":"IF(ISBLANK(J5),\"\",J5)","v":9},{"$f":"IF(ISBLANK(K5),\"\",K5)","v":0},"―",{"$f":"IF(ISBLANK(M5),\"\",M5)","v":4},{"$f":"IF(ISBLANK(N5),\"\",N5)","v":6},{"$f":"IF(ISBLANK(O5),\"\",O5)","v":4},1,5,"공급받는자","등록번호",null,null,{"$f":"IF(ISBLANK(V5),\"\",V5)","v":""},{"$f":"IF(ISBLANK(W5),\"\",W5)","v":""},{"$f":"IF(ISBLANK(X5),\"\",X5)","v":""},"―",{"$f":"IF(ISBLANK(Z5),\"\",Z5)","v":""},{"$f":"IF(ISBLANK(AA5),\"\",AA5)","v":""},"―",{"$f":"IF(ISBLANK(AC5),\"\",AC5)","v":""},{"$f":"IF(ISBLANK(AD5),\"\",AD5)","v":""},"","",""]
[null,null,"상    호\n(법인명)",null,null,null,null,null,null,null,null,"성명",{"$f":"IF(ISBLANK(M6),\"\",M6)","v":"이원기"},null,null,null,null,null,"상    호\n(법인명)",null,null,{"$f":"IF(ISBLANK(V6),\"\",V6)","v":""},null,null,null,null,null,"성명",{"$f":"IF(ISBLANK(AC6),\"\",AC6)","v":""}]
[]
[null,null,"사 업 장\n주    소",null,null,{"$f":"IF(ISBLANK(F8),\"\",F8)","v":"강원도 춘천시 후평3동 891-11"},null,null,null,null,null,null,null,null,null,null,null,null,"사 업 장\n주    소",null,null,{"$f":"IF(ISBLANK(V8),\"\",V8)","v":""}]
[]
[null,null,"업    태",null,null,{"$f":"IF(ISBLANK(F10),\"\",F10)","v":"교육.서비스"},null,null,null,null,null,"종목",{"$f":"IF(ISBLANK(M10),\"\",M10)","v":"컴퓨터학원"},null,null,null,null,null,"업    태",null,null,{"$f":"IF(ISBLANK(V10),\"\",V10)","v":""},null,null,null,null,null,"종목",{"$f":"IF(ISBLANK(AC10),\"\",AC10)","v":""}]
[]
[null,"작   성",null,null,null,"공    급    가    액",null,null,null,null,null,null,null,null,null,null,null,null,"비   고"]
[null,"년",null,"월","일","공란수",null,"백","십","억","천","백","십","만","천","백","십","일"]
[null,{"$f":"IF(ISBLANK(B14),\"\",B14)","v":2011},null,{"$f":"IF(ISBLANK(D14),\"\",D14)","v":10},12,"","","","","","",1,8,0,0,0,0,0]
[null,"월","일","품          목",null,null,null,null,null,"규  격",null,null,"수  량",null,null,"단    가",null,null,null,null,"공 급 가 액",null,null,null,null,null,"비고"]
[null,{"$f":"IF(ISBLANK(B16),\"\",B16)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"합계금액",null,null,null,null,"현   금",null,null,null,null,"수   표",null,null,null,null,"어   음",null,null,null,null,"외상미수금",null,null,null,null,"위 금액을 ",null,null,null,{"$f":"IF(ISBLANK(AE20),\"\",AE20)","v":"영수"},null,"함."]
[null,{"$f":"IF(ISBLANK(B21),\"\",B21)","v":0},"","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"22226-28131일 ’96.3.27승인",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"인쇄용지(특급)34g/m2 182mm×128mm"]

{"sheet":"문서3-연습","index":20,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"자동필터_1","index":21,"n_rows":18,"n_cols":8,"rows_kept":18,"cut":false,"hidden":false,"merged":[[0,0,0,7]]}
["사무용품 관리 현황"]
[]
["제품코드","제품명","입고일","입고량","판매가","할인율","판매량","총판매액"]
["GI495","가위","2016-06-29",100,3500,0.1,57,{"$f":"E4*G4-E4*F4*G4","v":179550}]
["PE672","형광펜","2016-06-29",200,2500,0.15,168,{"$f":"E5*G5-E5*F5*G5","v":357000}]
["TM891","투명테이프","2016-06-29",180,1500,0.05,162,230850]
["AH938","A3 용지","2016-06-29",50,8500,0.1,26,198900]
["QZ349","볼펜","2016-06-29",300,1200,0.05,268,305520]
["AH128","A4 용지","2016-06-30",100,8000,0.05,68,516800]
["TM234","양면테이프","2016-06-30",250,1800,0.15,245,374850]
["BB384","포스트잇","2016-06-30",150,2000,0.15,128,217600]
["TM511","박스테이프","2016-06-30",200,1000,0.05,133,126350]
["DO933","칼","2016-06-30",150,1600,0.1,144,207360]
["TM394","라벨테이프","2016-07-01",320,2200,0.15,299,559130]
["CB685","스탬프","2016-07-01",200,3500,0.05,172,571900]
["WD485","수정액","2016-07-01",150,2400,0.15,134,273360]
["TM735","청테이프","2016-07-01",350,1400,0.05,328,436240]
["SU816","샤프","2016-07-01",250,2100,0.1,216,408240]

{"sheet":"자동필터_1-정답","index":22,"n_rows":18,"n_cols":8,"rows_kept":18,"cut":false,"hidden":false,"merged":[[0,0,0,7]]}
["사무용품 관리 현황"]
[]
["제품코드","제품명","입고일","입고량","판매가","할인율","판매량","총판매액"]
["GI495","가위","2016-06-29",100,3500,0.1,57,{"$f":"E4*G4-E4*F4*G4","v":179550}]
["PE672","형광펜","2016-06-29",200,2500,0.15,168,{"$f":"E5*G5-E5*F5*G5","v":357000}]
["TM891","투명테이프","2016-06-29",180,1500,0.05,162,230850]
["AH938","A3 용지","2016-06-29",50,8500,0.1,26,198900]
["QZ349","볼펜","2016-06-29",300,1200,0.05,268,305520]
["AH128","A4 용지","2016-06-30",100,8000,0.05,68,516800]
["TM234","양면테이프","2016-06-30",250,1800,0.15,245,374850]
["BB384","포스트잇","2016-06-30",150,2000,0.15,128,217600]
["TM511","박스테이프","2016-06-30",200,1000,0.05,133,126350]
["DO933","칼","2016-06-30",150,1600,0.1,144,207360]
["TM394","라벨테이프","2016-07-01",320,2200,0.15,299,559130]
["CB685","스탬프","2016-07-01",200,3500,0.05,172,571900]
["WD485","수정액","2016-07-01",150,2400,0.15,134,273360]
["TM735","청테이프","2016-07-01",350,1400,0.05,328,436240]
["SU816","샤프","2016-07-01",250,2100,0.1,216,408240]

{"sheet":"자동필터(예제)","index":23,"n_rows":12,"n_cols":8,"rows_kept":12,"cut":false,"hidden":false,"merged":[[0,1,0,7]]}
[null,"대리점별 보트 판매현황"]
[]
[null,"지역","대리점명","계획수량","판매수량","초과판매","실적률","순위"]
[null,"인천","영남",210,220,10,1.0476190476190477,8]
[null,"강북","강산",140,170,30,1.2142857142857142,4]
[null,"강남","백야",120,150,30,1.25,1]
[null,"부산","광야",180,220,40,1.2222222222222223,3]
[null,"광주","정일",150,180,30,1.2,5]
[null,"대전","남산",120,130,10,1.0833333333333333,7]
[null,"청주","장산",150,155,5,1.0333333333333334,9]
[null,"전주","국제",350,390,40,1.1142857142857143,6]
[null,"대구","동문",190,235,45,1.236842105263158,3]

{"sheet":"자동필터(결과)","index":24,"n_rows":12,"n_cols":8,"rows_kept":12,"cut":false,"hidden":false,"merged":[[0,1,0,7]]}
[null,"대리점별 보트 판매현황"]
[]
[null,"지역","대리점명","계획수량","판매수량","초과판매","실적률","순위"]
[null,"인천","영남",210,220,10,1.0476190476190477,8]
[null,"강북","강산",140,170,30,1.2142857142857142,4]
[null,"강남","백야",120,150,30,1.25,1]
[null,"부산","광야",180,220,40,1.2222222222222223,3]
[null,"광주","정일",150,180,30,1.2,5]
[null,"대전","남산",120,130,10,1.0833333333333333,7]
[null,"청주","장산",150,155,5,1.0333333333333334,9]
[null,"전주","국제",350,390,40,1.1142857142857143,6]
[null,"대구","동문",190,235,45,1.236842105263158,3]

{"sheet":"고급필터","index":25,"n_rows":15,"n_cols":8,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[]
[]
["고객번호","이름","성별","1월 구매실적","2월 구매실적","3월 구매실적","최종주문일","주문횟수"]
["PR-002","김한응","남",135000,55000,135000,"2009-03-21",25]
["PR-016","강흥석","남",140520,135000,152000,"2009-03-18",24]
["SP-006","김미현","남",37000,135000,78000,"2009-03-18",23]
["SP-008","한미우","남",7000,38700,122500,"2009-03-13",19]
["PR-004","한성현","남",38700,78000,38700,"2009-03-12",18]
["NO-011","홍길동","남",34170,78000,34630,"2009-03-11",17]
["NO-013","박은미","여",34630,122500,552200,"2009-03-24",30]
["SP-005","이지영","여",135000,178000,120200,"2009-03-23",27]
["PR-009","이미라","여",78000,2020,135000,"2009-03-16",22]
["PR-011","고수정","여",122500,140520,78000,"2009-03-22",21]
["PR-006","정은희","여",55000,122500,12500,"2009-03-15",20]
["NO-001","이정은","여",0,135000,140520,"2009-03-18",15]

{"sheet":"고급필터(결과)","index":26,"n_rows":25,"n_cols":8,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[]
[]
["고객번호","이름","성별","1월 구매실적","2월 구매실적","3월 구매실적","최종주문일","주문횟수"]
["PR-002","김한응","남",135000,55000,135000,"2009-03-21",25]
["PR-016","강흥석","남",140520,135000,152000,"2009-03-18",24]
["SP-006","김미현","남",37000,135000,78000,"2009-03-18",23]
["SP-008","한미우","남",7000,38700,122500,"2009-03-13",19]
["PR-004","한성현","남",38700,78000,38700,"2009-03-12",18]
["NO-011","홍길동","남",34170,78000,34630,"2009-03-11",17]
["NO-013","박은미","여",34630,122500,552200,"2009-03-24",30]
["SP-005","이지영","여",135000,178000,120200,"2009-03-23",27]
["PR-009","이미라","여",78000,2020,135000,"2009-03-16",22]
["PR-011","고수정","여",122500,140520,78000,"2009-03-22",21]
["PR-006","정은희","여",55000,122500,12500,"2009-03-15",20]
["NO-001","이정은","여",0,135000,140520,"2009-03-18",15]
[]
[]
["성별","주문횟수"]
["남",">=20"]
[]
[]
["고객번호","이름","1월 구매실적","2월 구매실적","3월 구매실적"]
["PR-002","김한응",135000,55000,135000]
["PR-016","강흥석",140520,135000,152000]
["SP-006","김미현",37000,135000,78000]

{"sheet":"조건부서식1(예제)","index":27,"n_rows":17,"n_cols":6,"rows_kept":17,"cut":false,"hidden":false,"merged":[[0,0,0,5]]}
["4사분기 지출현황"]
[]
["항목","품목","10월","11월","12월","합계"]
["문화생활","케이블TV",2000,2000,2000,{"$f":"SUM(C4:E4)","v":6000}]
["세금","전화요금",4000,3500,5000,12500]
["세금","가스요금",5200,4200,4000,13400]
["문화생활","신문대금",12000,12000,12000,36000]
["문화생활","문화생활",20000,15000,60000,95000]
["일상경비","교통비",26000,18000,20000,64000]
["일상경비","생활용품",32000,120000,60000,212000]
["자동차","자동차용품",35000,12000,0,47000]
["일상경비","반찬값",45000,52000,50000,147000]
["일상경비","의류구입",60000,20000,10000,90000]
["자동차","자동차기름",60000,80000,150000,290000]
["양육비","아기식비",75000,80000,65000,220000]
["양육비","아기용품",80000,60000,75000,215000]
["세금","관리비",150000,160000,160000,470000]

{"sheet":"조건부서식1(결과)","index":28,"n_rows":17,"n_cols":6,"rows_kept":17,"cut":false,"hidden":false,"merged":[[0,0,0,5]]}
["4사분기 지출현황"]
[]
["항목","품목","10월","11월","12월","합계"]
["문화생활","케이블TV",2000,2000,2000,{"$f":"SUM(C4:E4)","v":6000}]
["세금","전화요금",4000,3500,5000,12500]
["세금","가스요금",5200,4200,4000,13400]
["문화생활","신문대금",12000,12000,12000,36000]
["문화생활","문화생활",20000,15000,60000,95000]
["일상경비","교통비",26000,18000,20000,64000]
["일상경비","생활용품",32000,120000,60000,212000]
["자동차","자동차용품",35000,12000,0,47000]
["일상경비","반찬값",45000,52000,50000,147000]
["일상경비","의류구입",60000,20000,10000,90000]
["자동차","자동차기름",60000,80000,150000,290000]
["양육비","아기식비",75000,80000,65000,220000]
["양육비","아기용품",80000,60000,75000,215000]
["세금","관리비",150000,160000,160000,470000]

{"sheet":"조건부서식2(예제)","index":29,"n_rows":15,"n_cols":8,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[]
[]
["고객번호","이름","성별","1월 구매실적","2월 구매실적","3월 구매실적","최종주문일","주문횟수"]
["PR-002","김한응","남",135000,55000,135000,"2009-03-21",25]
["PR-016","강흥석","남",140520,135000,152000,"2009-03-18",24]
["SP-006","김미현","남",37000,135000,78000,"2009-03-18",23]
["SP-008","한미우","남",7000,38700,122500,"2009-03-13",19]
["PR-004","한성현","남",38700,78000,38700,"2009-03-12",18]
["NO-011","홍길동","남",34170,78000,34630,"2009-03-11",17]
["NO-013","박은미","여",34630,122500,552200,"2009-03-24",30]
["SP-005","이지영","여",135000,178000,120200,"2009-03-23",27]
["PR-009","이미라","여",78000,2020,135000,"2009-03-16",22]
["PR-011","고수정","여",122500,140520,78000,"2009-03-22",21]
["PR-006","정은희","여",55000,122500,12500,"2009-03-15",20]
["NO-001","이정은","여",0,135000,140520,"2009-03-18",15]

{"sheet":"조건부서식2(결과)","index":30,"n_rows":15,"n_cols":8,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[]
[]
["고객번호","이름","성별","1월 구매실적","2월 구매실적","3월 구매실적","최종주문일","주문횟수"]
["PR-002","김한응","남",135000,55000,135000,"2009-03-21",25]
["PR-016","강흥석","남",140520,135000,152000,"2009-03-18",24]
["SP-006","김미현","남",37000,135000,78000,"2009-03-18",23]
["SP-008","한미우","남",7000,38700,122500,"2009-03-13",19]
["PR-004","한성현","남",38700,78000,38700,"2009-03-12",18]
["NO-011","홍길동","남",34170,78000,34630,"2009-03-11",17]
["NO-013","박은미","여",34630,122500,552200,"2009-03-24",30]
["SP-005","이지영","여",135000,178000,120200,"2009-03-23",27]
["PR-009","이미라","여",78000,2020,135000,"2009-03-16",22]
["PR-011","고수정","여",122500,140520,78000,"2009-03-22",21]
["PR-006","정은희","여",55000,122500,12500,"2009-03-15",20]
["NO-001","이정은","여",0,135000,140520,"2009-03-18",15]

{"sheet":"조건부서식3(예제)","index":31,"n_rows":18,"n_cols":7,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[]
[]
["소속","사원번호","근속년수","기본급","배우자","부양가족","자격증"]
["K-E","TN-032",0,1200000,1,4,0]
["K-E","TN-019",7,1900000,1,3,1]
["K-E","TN-014",9,2300000,1,4,1]
["K-E","TN-005",14,2900000,1,3,0]
["K-E","TN-003",16,3000000,1,2,1]
["K-P","TN-016",8,2000000,1,3,1]
["K-P","TN-002",16,3000000,1,0,1]
["K-P","TN-001",16,3000000,0,0,0]
["S-M","TN-017",8,2000000,1,4,1]
["S-M","TN-007",13,2500000,1,4,0]
["S-M","TN-004",15,2900000,1,0,3]
["S-T","TN-030",2,1300000,1,3,1]
["S-T","TN-013",10,2300000,1,3,3]
["S-T","TN-006",13,2500000,1,2,2]
["S-T","TN-008",13,2500000,0,1,0]

{"sheet":"조건부서식3(결과)","index":32,"n_rows":18,"n_cols":7,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[]
[]
["소속","사원번호","근속년수","기본급","배우자","부양가족","자격증"]
["K-E","TN-032",0,1200000,1,4,0]
["K-E","TN-019",7,1900000,1,3,1]
["K-E","TN-014",9,2300000,1,4,1]
["K-E","TN-005",14,2900000,1,3,0]
["K-E","TN-003",16,3000000,1,2,1]
["K-P","TN-016",8,2000000,1,3,1]
["K-P","TN-002",16,3000000,1,0,1]
["K-P","TN-001",16,3000000,0,0,0]
["S-M","TN-017",8,2000000,1,4,1]
["S-M","TN-007",13,2500000,1,4,0]
["S-M","TN-004",15,2900000,1,0,3]
["S-T","TN-030",2,1300000,1,3,1]
["S-T","TN-013",10,2300000,1,3,3]
["S-T","TN-006",13,2500000,1,2,2]
["S-T","TN-008",13,2500000,0,1,0]

{"sheet":"계산(예제)","index":33,"n_rows":29,"n_cols":9,"rows_kept":29,"cut":false,"hidden":false,"merged":[[17,0,17,1],[27,0,27,1],[28,0,28,1]]}
["[표1] ","품목별 판매 현황",null,null,null,"[표2] ","고공 낙하 회수별 인원"]
["품목명","판매수량","판매금액","이익금액",null,"낙하회수","인원수","누적인원수","누계비율"]
["샤프",327,{"$f":"B3*3000","v":981000},null,null,"3000이상",5,5]
["연필",370,{"$f":"B4*350","v":129500},null,null,"1000이상",20,25]
["만년필",450,{"$f":"B5*6500","v":2925000},null,null,"500이상",15,40]
["색연필",900,{"$f":"B6*340","v":306000},null,null,"100이상",7,47]
["볼펜",789,{"$f":"B7*220","v":173580},null,null,"10이상",3,50]
["플러스펜",670,{"$f":"B8*550","v":368500},null,null,"합계",{"$f":"SUM(G3:G7)","v":50}]
[null,"마진율",0.25]
[null,null,null,null,null,null,"[표4] ","펜던트 판매 현황"]
["[표3] ","사원별 수당지급현황",null,null,null,null,"월","판매량","매출총액"]
["성명","근무년수","기본급","상여비율","수당",null,"1월",75]
["홍기재",15,2550000,0.15,null,null,"2월",65]
["이민찬",9,1500000,0.1,null,null,"3월",56]
["가영수",10,2000000,0.12,null,null,"4월",76]
["류민완",8,2200000,0.1,null,null,"5월",56]
["강술래",4,1300000,7.0000000000000007E-2,null,null,"6월",85]
["추가 상여율",null,0.06]
[null,null,null,null,null,null,"단가","할인율"]
["[표5] ","도서 포인트 관리",null,null,null,null,250000,0.2]
["대출자","대출권수","연체권수","포인트 총계"]
["이원섭",50,23]
["최준기",72,14]
["구현서",85,29]
["안유경",15,2]
["강흥석",78,7]
["조용욱",56,5]
["대출포인트",null,0.11]
["연체포인트",null,-0.06]

{"sheet":"계산(결과)","index":34,"n_rows":29,"n_cols":9,"rows_kept":29,"cut":false,"hidden":false,"merged":[[17,0,17,1],[27,0,27,1],[28,0,28,1]]}
["[표1] ","품목별 판매 현황",null,null,null,"[표2] ","고공 낙하 회수별 인원"]
["품목명","판매수량","판매금액","이익금액",null,"낙하회수","인원수","누적인원수","누계비율"]
["샤프",327,{"$f":"B3*3000","v":981000},{"$f":"C3*$C$9","v":245250},null,"3000이상",5,5,{"$f":"H3/$G$8","v":0.1}]
["연필",370,{"$f":"B4*350","v":129500},{"$f":"C4*$C$9","v":32375},null,"1000이상",20,25,{"$f":"H4/$G$8","v":0.5}]
["만년필",450,{"$f":"B5*6500","v":2925000},731250,null,"500이상",15,40,0.8]
["색연필",900,{"$f":"B6*340","v":306000},76500,null,"100이상",7,47,0.94]
["볼펜",789,{"$f":"B7*220","v":173580},43395,null,"10이상",3,50,1]
["플러스펜",670,{"$f":"B8*550","v":368500},92125,null,"합계",{"$f":"SUM(G3:G7)","v":50}]
[null,"마진율",0.25]
[null,null,null,null,null,null,"[표4] ","펜던트 판매 현황"]
["[표3] ","사원별 수당지급현황",null,null,null,null,"월","판매량","매출총액"]
["성명","근무년수","기본급","상여비율","수당",null,"1월",75,{"$f":"(H12*$G$20)*(1-$H$20)","v":15000000}]
["홍기재",15,2550000,0.15,{"$f":"C13+C13*(D13+$C$18)","v":3085500},null,"2월",65,{"$f":"(H13*$G$20)*(1-$H$20)","v":13000000}]
["이민찬",9,1500000,0.1,{"$f":"C14+C14*(D14+$C$18)","v":1740000},null,"3월",56,11200000]
["가영수",10,2000000,0.12,2360000,null,"4월",76,15200000]
["류민완",8,2200000,0.1,2552000,null,"5월",56,11200000]
["강술래",4,1300000,7.0000000000000007E-2,1469000,null,"6월",85,17000000]
["추가 상여율",null,0.06]
[null,null,null,null,null,null,"단가","할인율"]
["[표5] ","도서 포인트 관리",null,null,null,null,250000,0.2]
["대출자","대출권수","연체권수","포인트 총계"]
["이원섭",50,23,{"$f":"B22*$C$28+C22*$C$29","v":4.12}]
["최준기",72,14,{"$f":"B23*$C$28+C23*$C$29","v":7.08}]
["구현서",85,29,7.6099999999999994]
["안유경",15,2,1.5299999999999998]
["강흥석",78,7,8.16]
["조용욱",56,5,5.86]
["대출포인트",null,0.11]
["연체포인트",null,-0.06]

{"sheet":"날짜(예제)","index":35,"n_rows":2,"n_cols":2,"rows_kept":2,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,3,1,10]]}
[]
[null,"날짜시간함수"]

{"sheet":"날짜(결과)","index":36,"n_rows":15,"n_cols":2,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
["오늘의 날짜",{"$f":"TODAY()","v":"2020-01-14"}]
["오늘의 날짜와 시간",{"$f":"NOW()","v":"2020-01-14T22:11:44.300"}]
[]
["표시 부분","결과"]
["연도(YEAR)",{"$f":"YEAR(B2)","v":2020}]
["월(MONTH)",{"$f":"MONTH(B2)","v":1}]
["일(DAY)",{"$f":"DAY(B2)","v":14}]
["시(HOUR)",{"$f":"HOUR(B2)","v":22}]
["분(MINUTE)",{"$f":"MINUTE(B2)","v":11}]
["초(SECOND)",{"$f":"SECOND(B2)","v":44}]
["날짜(DATE)",{"$f":"DATE(B5,B6,B7)","v":"2020-01-14"}]
["시간(TIME)",{"$f":"TIME(B8,B9,B10)","v":"22:11:44"}]
["요일(WEEKDAY)",{"$f":"WEEKDAY(B2)","v":3}]
["요일(WEEKDAY)-서식",{"$f":"WEEKDAY(B2)","v":3}]
["일련번호(DATEVALUE)",{"$f":"DATEVALUE(\"2012-8-15\")","v":41136}]

{"sheet":"논리(예제)","index":37,"n_rows":23,"n_cols":10,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
["[표1]",null,null,null,null,"[표2]"]
["수험번호","이름","점수","평가",null,"수험번호","성명","최종성적","부서배치"]
[1001,"이나영",78,null,null,1001,"오나라",95]
[1002,"추영조",65,null,null,1002,"유채화",74]
[1003,"탁수민",80,null,null,1003,"김사랑",85]
[1004,"강전한",90,null,null,1004,"한나리",88]
[1005,"김이중",52,null,null,1005,"조절해",60]
[1006,"전대철",42,null,null,1006,"사오정",92]
[1007,"사은봉",80,null,null,1007,"금나라",72]
[1008,"노영철",69]
[1009,"면도영",75]
[]
["[표3]",null,null,null,null,"[표4]"]
["직원코드","근무년수","판매부수","승진여부",null,"연수번호","성명","컴일","시트","평가"]
["1-K001",10,100000,null,null,2002001,"강구석",77,86]
["1-K002",17,150000,null,null,2002002,"이지나",56,100]
["1-K003",15,50000,null,null,2002003,"남인성",76,84]
["1-K004",25,65000,null,null,2002004,"오지혜",56,78]
["2-K001",15,134000,null,null,2002005,"류민철",88,96]
["2-K002",9,74000,null,null,2002006,"김동석",78,56]
["2-K003",12,95000,null,null,2002007,"사인구",67,78]
[null,null,null,null,null,2002008,"푸영아",100,86]
[null,null,null,null,null,2002009,"한남석",42,56]

{"sheet":"논리(결과)","index":38,"n_rows":23,"n_cols":10,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
["[표1]",null,null,null,null,"[표2]"]
["수험번호","이름","점수","평가",null,"수험번호","성명","최종성적","부서배치"]
[1001,"이나영",78,{"$f":"IF(C3>=70,\"합격\",\"불합격\")","v":"합격"},null,1001,"오나라",95,{"$f":"IF(H3>=90,\"기획부\",IF(H3>=80,\"총무부\",\"영업부\"))","v":"기획부"}]
[1002,"추영조",65,{"$f":"IF(C4>=70,\"합격\",\"불합격\")","v":"불합격"},null,1002,"유채화",74,{"$f":"IF(H4>=90,\"기획부\",IF(H4>=80,\"총무부\",\"영업부\"))","v":"영업부"}]
[1003,"탁수민",80,"합격",null,1003,"김사랑",85,"총무부"]
[1004,"강전한",90,"합격",null,1004,"한나리",88,"총무부"]
[1005,"김이중",52,"불합격",null,1005,"조절해",60,"영업부"]
[1006,"전대철",42,"불합격",null,1006,"사오정",92,"기획부"]
[1007,"사은봉",80,"합격",null,1007,"금나라",72,"영업부"]
[1008,"노영철",69,"불합격"]
[1009,"면도영",75,"합격"]
[]
["[표3]",null,null,null,null,"[표4]"]
["직원코드","근무년수","판매부수","승진여부",null,"연수번호","성명","컴일","시트","평가"]
["1-K001",10,100000,{"$f":"IF(AND(B15>=13,C15>=100000),\"승진\",\"\")","v":""},null,2002001,"강구석",77,86,{"$f":"IF(OR(H15>=85,I15>=85),\"이수\",\"\")","v":"이수"}]
["1-K002",17,150000,{"$f":"IF(AND(B16>=13,C16>=100000),\"승진\",\"\")","v":"승진"},null,2002002,"이지나",56,100,{"$f":"IF(OR(H16>=85,I16>=85),\"이수\",\"\")","v":"이수"}]
["1-K003",15,50000,"",null,2002003,"남인성",76,84,""]
["1-K004",25,65000,"",null,2002004,"오지혜",56,78,""]
["2-K001",15,134000,"승진",null,2002005,"류민철",88,96,"이수"]
["2-K002",9,74000,"",null,2002006,"김동석",78,56,""]
["2-K003",12,95000,"",null,2002007,"사인구",67,78,""]
[null,null,null,null,null,2002008,"푸영아",100,86,"이수"]
[null,null,null,null,null,2002009,"한남석",42,56,""]

{"sheet":"데이터베이스1(예제)","index":39,"n_rows":21,"n_cols":7,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[]
[null,"고객ID","성명","고객구분","가입일","거래횟수","총거래금액"]
[null,"T001","우병배","일반","2011-05-06",12,680000]
[null,"T002","표명규","골드","2011-07-15",5,520000]
[null,"T003","손미선","우대","2011-07-21",18,165000]
[null,"T004","윤연숙","우대","2011-08-20",24,438000]
[null,"T005","박찬우","골드","2011-08-21",13,527000]
[null,"T006","안순일","일반","2011-09-15",15,350000]
[null,"T007","이경희","일반","2011-09-18",9,127000]
[null,"T008","황명길","골드","2011-09-25",15,628000]
[null,"T009","박연이","우대","2011-10-05",10,715000]
[null,"T010","김청수","일반","2011-10-12",24,357000]
[null,"T011","임순정","골드","2011-10-19",21,495000]
[]
[]
[null,"고객구분","총거래횟수","평균금액","최고금액","최소금액","회원수"]
[null,"골드"]
[]
[]
[null,"고객ID","성명","고객구분","가입일","거래횟수","총거래금액"]
[null,"T005"]

{"sheet":"데이터베이스1(결과)","index":40,"n_rows":21,"n_cols":7,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[]
[null,"고객ID","성명","고객구분","가입일","거래횟수","총거래금액"]
[null,"T001","우병배","일반","2011-05-06",12,680000]
[null,"T002","표명규","골드","2011-07-15",5,520000]
[null,"T003","손미선","우대","2011-07-21",18,165000]
[null,"T004","윤연숙","우대","2011-08-20",24,438000]
[null,"T005","박찬우","골드","2011-08-21",13,527000]
[null,"T006","안순일","일반","2011-09-15",15,350000]
[null,"T007","이경희","일반","2011-09-18",9,127000]
[null,"T008","황명길","골드","2011-09-25",15,628000]
[null,"T009","박연이","우대","2011-10-05",10,715000]
[null,"T010","김청수","일반","2011-10-12",24,357000]
[null,"T011","임순정","골드","2011-10-19",21,495000]
[]
[]
[null,"고객구분","총거래횟수","평균금액","최고금액","최소금액","회원수"]
[null,"골드",{"$f":"DSUM(B2:G13,5,B16:B17)","v":54},{"$f":"DAVERAGE(B2:G13,6,B16:B17)","v":542500},{"$f":"DMAX(B2:G13,6,B16:B17)","v":628000},{"$f":"DMIN(B2:G13,6,B16:B17)","v":495000},{"$f":"DCOUNT(B2:G13,6,B16:B17)","v":4}]
[]
[]
[null,"고객ID","성명","고객구분","가입일","거래횟수","총거래금액"]
[null,"T005",{"$f":"DGET($B$2:$G$13,C2,$B$20:$B$21)","v":"박찬우"},{"$f":"DGET($B$2:$G$13,D2,$B$20:$B$21)","v":"골드"},"2011-08-21",13,527000]

{"sheet":"데이터베이스2(예제)","index":41,"n_rows":36,"n_cols":9,"rows_kept":36,"cut":false,"hidden":false,"merged":[[36,2,36,3],[36,7,36,8],[11,0,11,2],[11,5,11,7],[22,5,22,6],[23,5,23,6],[35,2,35,3],[35,7,35,8]]}
["[표1]",null,null,null,null,"[표2]"]
["성명","응시구분","1차","2차",null,"대리점","단가","출고수량","판매금액"]
["한가람","P-1",79,97,null,"금성물산",1673,40,{"$f":"G3*H3","v":66920}]
["김은철","P-2",77,89,null,"우주상사",1506,58,87348]
["고사리","P-1",56,76,null,"신안공업",1126,91,102466]
["박은별","P-2",88,80,null,"삼성상사",2953,99,292347]
["성준서","P-1",88,93,null,"금성물산",1423,54,76842]
["이성연","P-2",91,67,null,"신안공업",1338,40,53520]
["박한나","P-1",85,56,null,"금성물산",2310,73,168630]
["이미리","P-1",76,89,null,"종로상사",1937,90,174330]
[]
["P-1의 1차 평균",null,null,null,null,"금성물산 판매금액 합계"]
[]
["[표3]",null,null,null,null,"[표4]"]
["성명","부서","1/4분기","2/4분기",null,"소속","기사","우승횟수","준우승횟수"]
["김남이","영업1부",557,345,null,"상공","김기호",14,20]
["이지영","영업2부",476,513,null,"대한","최종명",2,13]
["하나미","영업1부",231,474,null,"대한","나필승",3,3]
["임진태","영업2부",175,453,null,"서울","고대로",8,5]
["현민대","영업2부",834,401,null,"상공","정상승",5,3]
["한민국","영업1부",597,347,null,"대한","채고다",15,5]
[]
[null,"1/4분기","2/4분기",null,null,"대한팀 우승횟수"]
[]
[]
["[표5]",null,null,null,null,"[표6]"]
["학과","학년","성명","평가점수",null,"직원코드","1사분기","2사분기","상반기합계"]
["디자인",1,"고승수",465,null,"1-J001",92733,46573,{"$f":"G28+H28","v":139306}]
["미디어",2,"구만리",604,null,"1-J002",66191,60400,126591]
["미디어",3,"노상식",383,null,"1-J003",14809,13827,28636]
["디자인",2,"나잘난",465,null,"1-J004",51382,46573,97955]
["미디어",1,"마고수",382,null,"2-J001",19663,17382,37045]
["미디어",2,"박흥철",391,null,"2-J002",22053,49102,71155]
["디자인",3,"사수해",572,null,"2-J003",23900,17206,41106]
[]
[null,null,"400점 이상이거나 2학년",null,null,null,null,"50000~100000의 합"]

{"sheet":"데이터베이스2(결과)","index":42,"n_rows":38,"n_cols":9,"rows_kept":38,"cut":false,"hidden":false,"merged":[[36,2,36,3],[36,7,36,8],[11,0,11,2],[11,5,11,7],[22,5,22,6],[23,5,23,6],[35,2,35,3],[35,7,35,8]]}
["[표1]",null,null,null,null,"[표2]"]
["성명","응시구분","1차","2차",null,"대리점","단가","출고수량","판매금액"]
["한가람","P-1",79,97,null,"금성물산",1673,40,{"$f":"G3*H3","v":66920}]
["김은철","P-2",77,89,null,"우주상사",1506,58,87348]
["고사리","P-1",56,76,null,"신안공업",1126,91,102466]
["박은별","P-2",88,80,null,"삼성상사",2953,99,292347]
["성준서","P-1",88,93,null,"금성물산",1423,54,76842]
["이성연","P-2",91,67,null,"신안공업",1338,40,53520]
["박한나","P-1",85,56,null,"금성물산",2310,73,168630]
["이미리","P-1",76,89,null,"종로상사",1937,90,174330]
[]
["P-1의 1차 평균",null,null,{"$f":"DAVERAGE(A2:D10,3,B2:B3)","v":76.8},null,"금성물산 판매금액 합계",null,null,{"$f":"DSUM(F2:I10,I2,F2:F3)","v":312392}]
[]
["[표3]",null,null,null,null,"[표4]"]
["성명","부서","1/4분기","2/4분기",null,"소속","기사","우승횟수","준우승횟수"]
["김남이","영업1부",557,345,null,"상공","김기호",14,20]
["이지영","영업2부",476,513,null,"대한","최종명",2,13]
["하나미","영업1부",231,474,null,"대한","나필승",3,3]
["임진태","영업2부",175,453,null,"서울","고대로",8,5]
["현민대","영업2부",834,401,null,"상공","정상승",5,3]
["한민국","영업1부",597,347,null,"대한","채고다",15,5]
[]
["부서","1/4분기","2/4분기",null,null,"대한팀 우승횟수",null,"소속","준우승횟수"]
["영업2부",{"$f":"DMAX($A$15:$E$21,C15,$A$23:$A$24)","v":834},{"$f":"DMAX($A$15:$E$21,D15,$A$23:$A$24)","v":513},null,null,{"$f":"DCOUNT(F15:I21,H15,H23:I24)","v":2},null,"대한",">=5"]
[]
["[표5]",null,null,null,null,"[표6]"]
["학과","학년","성명","평가점수",null,"직원코드","1사분기","2사분기","상반기합계"]
["디자인",1,"고승수",465,null,"1-J001",92733,46573,{"$f":"G28+H28","v":139306}]
["미디어",2,"구만리",604,null,"1-J002",66191,60400,126591]
["미디어",3,"노상식",383,null,"1-J003",14809,13827,28636]
["디자인",2,"나잘난",465,null,"1-J004",51382,46573,97955]
["미디어",1,"마고수",382,null,"2-J001",19663,17382,37045]
["미디어",2,"박흥철",391,null,"2-J002",22053,49102,71155]
["디자인",3,"사수해",572,null,"2-J003",23900,17206,41106]
[]
["평가점수","학년","400점 이상이거나 2학년",null,null,"상반기합계","상반기합계","50000~100000의 합"]
[">=400",null,{"$f":"DCOUNTA(A27:D34,C27,A36:B38)&\"명\"","v":"5명"},null,null,">=50000","<=100000",{"$f":"DSUM(F27:I34,4,F36:G37)","v":169110}]
[null,2]

{"sheet":"데이터베이스3(예제)","index":43,"n_rows":16,"n_cols":7,"rows_kept":16,"cut":false,"hidden":false,"merged":[[2,1,6,1],[7,1,11,1],[14,1,15,1]]}
[]
[null,"구분","월","YJ001","YJ002","YJ003","YJ004"]
[null,"판매량","1월",26,43,45,35]
[null,null,"2월",35,38,36,29]
[null,null,"3월",45,26,29,48]
[null,null,"4월",20,17,15,70]
[null,null,"5월",28,28,48,53]
[null,"단가","1월",3500,6200,5400,4800]
[null,null,"2월",3500,6000,5600,4700]
[null,null,"3월",3600,6200,5000,4700]
[null,null,"4월",3300,6500,5300,4500]
[null,null,"5월",3500,6100,5500,4600]
[]
[]
[null,"총판매액","월","YJ001","YJ002","YJ003","YJ004"]
[null,null,"1월"]

{"sheet":"데이터베이스3(결과)","index":44,"n_rows":16,"n_cols":7,"rows_kept":16,"cut":false,"hidden":false,"merged":[[2,1,6,1],[7,1,11,1],[14,1,15,1]]}
[]
[null,"구분","월","YJ001","YJ002","YJ003","YJ004"]
[null,"판매량","1월",26,43,45,35]
[null,null,"2월",35,38,36,29]
[null,null,"3월",45,26,29,48]
[null,null,"4월",20,17,15,70]
[null,null,"5월",28,28,48,53]
[null,"단가","1월",3500,6200,5400,4800]
[null,null,"2월",3500,6000,5600,4700]
[null,null,"3월",3600,6200,5000,4700]
[null,null,"4월",3300,6500,5300,4500]
[null,null,"5월",3500,6100,5500,4600]
[]
[]
[null,"총판매액","월","YJ001","YJ002","YJ003","YJ004"]
[null,null,"1월",{"$f":"DPRODUCT($C$2:$G$12,D2,$C$15:$C$16)","v":91000},{"$f":"DPRODUCT($C$2:$G$12,E2,$C$15:$C$16)","v":266600},243000,168000]

{"sheet":"문자열1(예제)","index":45,"n_rows":13,"n_cols":6,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[]
[null,"성명","주민등록번호","생일","성별","나이"]
[null,"심행래","650218-1584623"]
[null,"김봉현","601204-1864523"]
[null,"이찬호","620718-1845237"]
[null,"박이슈","720124-2356427"]
[null,"이장군","730512-1845615"]
[null,"황건이","760314-1875234"]
[null,"이율용","660217-2485628"]
[null,"장보가","710523-2784652"]
[null,"서정수","640819-1864521"]
[null,"왕순원","610126-2845967"]
[null,"박목일","740630-1875241"]

{"sheet":"문자열1(결과)","index":46,"n_rows":13,"n_cols":6,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[]
[null,"성명","주민등록번호","생일","성별","나이"]
[null,"심행래","650218-1584623",{"$f":"DATE(LEFT(C3,2), MID(C3,3,2), MID(C3,5,2))","v":"1965-02-18"},{"$f":"IF(MID(C3,8,1)=\"1\", \"남자\", \"여자\")","v":"남자"},{"$f":"YEAR(TODAY())-LEFT(C3,2)-1900","v":55}]
[null,"김봉현","601204-1864523",{"$f":"DATE(LEFT(C4,2), MID(C4,3,2), MID(C4,5,2))","v":"1960-12-04"},{"$f":"IF(MID(C4,8,1)=\"1\", \"남자\", \"여자\")","v":"남자"},{"$f":"YEAR(TODAY())-LEFT(C4,2)-1900","v":60}]
[null,"이찬호","620718-1845237","1962-07-18","남자",58]
[null,"박이슈","720124-2356427","1972-01-24","여자",48]
[null,"이장군","730512-1845615","1973-05-12","남자",47]
[null,"황건이","760314-1875234","1976-03-14","남자",44]
[null,"이율용","660217-2485628","1966-02-17","여자",54]
[null,"장보가","710523-2784652","1971-05-23","여자",49]
[null,"서정수","640819-1864521","1964-08-19","남자",56]
[null,"왕순원","610126-2845967","1961-01-26","여자",59]
[null,"박목일","740630-1875241","1974-06-30","남자",46]

{"sheet":"문자열2(예제)","index":47,"n_rows":13,"n_cols":7,"rows_kept":13,"cut":false,"hidden":false,"merged":[[8,2,8,3],[9,2,9,3],[10,2,10,3],[11,2,11,3],[12,2,12,3]]}
[]
[null,"예제","LOWER","UPPER","PROPER","LEN","TRIM"]
[null,"AaAa    a"]
[null,"BB   bbb"]
[null,"CCC  cc"]
[null,"D   dDdD"]
[null,"EE  eee"]
[]
[null,"이름","주민등록번호",null,"생일(문자 형식)","생일(숫자 형식)"]
[null,"김정수","650218-1584623"]
[null,"노주현","601204-1864523"]
[null,"이홍렬","620718-1845237"]
[null,"박영삼","720124-1956427"]

{"sheet":"문자열2(결과)","index":48,"n_rows":13,"n_cols":7,"rows_kept":13,"cut":false,"hidden":false,"merged":[[8,2,8,3],[9,2,9,3],[10,2,10,3],[11,2,11,3],[12,2,12,3]]}
[]
[null,"예제","LOWER","UPPER","PROPER","LEN","TRIM"]
[null,"AaAa    a",{"$f":"LOWER(B3)","v":"aaaa    a"},{"$f":"UPPER(B3)","v":"AAAA    A"},{"$f":"PROPER(B3)","v":"Aaaa    A"},{"$f":"LEN(B3)","v":9},{"$f":"TRIM(B3)","v":"AaAa a"}]
[null,"BB   bbb",{"$f":"LOWER(B4)","v":"bb   bbb"},{"$f":"UPPER(B4)","v":"BB   BBB"},{"$f":"PROPER(B4)","v":"Bb   Bbb"},{"$f":"LEN(B4)","v":8},{"$f":"TRIM(B4)","v":"BB bbb"}]
[null,"CCC  cc","ccc  cc","CCC  CC","Ccc  Cc",7,"CCC cc"]
[null,"D   dDdD","d   dddd","D   DDDD","D   Dddd",8,"D dDdD"]
[null,"EE  eee","ee  eee","EE  EEE","Ee  Eee",7,"EE eee"]
[]
[null,"이름","주민등록번호",null,"생일(문자 형식)","생일(숫자 형식)"]
[null,"김정수","650218-1584623",null,{"$f":"TEXT(LEFT(C10,6),\"##-##-##\")","v":"65-02-18"},{"$f":"VALUE(TEXT(LEFT(C10,6),\"##-##-##\"))","v":"1965-02-18"}]
[null,"노주현","601204-1864523",null,{"$f":"TEXT(LEFT(C11,6),\"##-##-##\")","v":"60-12-04"},{"$f":"VALUE(TEXT(LEFT(C11,6),\"##-##-##\"))","v":"1960-12-04"}]
[null,"이홍렬","620718-1845237",null,"62-07-18","1962-07-18"]
[null,"박영삼","720124-1956427",null,"72-01-24","1972-01-24"]

{"sheet":"수학1(예제)","index":49,"n_rows":19,"n_cols":7,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[]
["1)","숫자","짝수/홀수"]
[null,225]
[null,300]
[null,387]
[null,570]
[]
["2)","숫자","자릿수","TRUNC","ROUND","ROUNDUP","ROUNDDOWN"]
[null,5678.567,2]
[null,5678.567,1]
[null,5678.567,0]
[null,5678.567,-2]
[null,5678.567,-1]
[]
["3)","숫자","INT","ABS"]
[null,456.78899999999999]
[null,-456.78899999999999]
[null,150]
[null,250]

{"sheet":"수학1(결과)","index":50,"n_rows":19,"n_cols":7,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[]
["1)","숫자","짝수/홀수"]
[null,225,{"$f":"IF(MOD(B3,2)=0,\"짝수\",\"홀수\")","v":"홀수"}]
[null,300,{"$f":"IF(MOD(B4,2)=0,\"짝수\",\"홀수\")","v":"짝수"}]
[null,387,"홀수"]
[null,570,"짝수"]
[]
["2)","숫자","자릿수","TRUNC","ROUND","ROUNDUP","ROUNDDOWN"]
[null,5678.567,2,{"$f":"TRUNC(B9,C9)","v":5678.56},{"$f":"ROUND(B9,C9)","v":5678.57},{"$f":"ROUNDUP(B9,C9)","v":5678.5700000000006},{"$f":"ROUNDDOWN(B9,C9)","v":5678.56}]
[null,5678.567,1,{"$f":"TRUNC(B10,C10)","v":5678.5},{"$f":"ROUND(B10,C10)","v":5678.6},{"$f":"ROUNDUP(B10,C10)","v":5678.6},{"$f":"ROUNDDOWN(B10,C10)","v":5678.5}]
[null,5678.567,0,5678,5679,5679,5678]
[null,5678.567,-2,5600,5700,5700,5600]
[null,5678.567,-1,5670,5680,5680,5670]
[]
["3)","숫자","INT","ABS"]
[null,456.78899999999999,{"$f":"INT(B16)","v":456},{"$f":"ABS(B16)","v":456.78899999999999}]
[null,-456.78899999999999,{"$f":"INT(B17)","v":-457},{"$f":"ABS(B17)","v":456.78899999999999}]
[null,150,150,150]
[null,250,250,250]

{"sheet":"수학2(예제)","index":51,"n_rows":19,"n_cols":7,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[]
["• SQRT",25,null,null,null,"• PI"]
[]
["• FACT",5,null,null,null,"• RAND"]
[]
["• POWER",4]
[]
[null,"이름","부서","1월","2월","3월","합계"]
[null,"김상원","영업1부",557,345,721,{"$f":"SUM(D9:F9)","v":1623}]
[null,"이갑봉","영업2부",476,513,174,1163]
[null,"강정희","영업1부",231,474,358,1063]
[null,"김동호","영업1부",175,453,443,1071]
[null,"이남주","영업2부",834,401,743,1978]
[null,"왕영애","영업1부",597,347,346,1290]
[null,"박효남","영업2부",634,530,651,1815]
[]
[]
[null,"부서","인원","1월합계","2월합계","3월합계","총합계"]
[null,"영업1부"]

{"sheet":"수학2(결과)","index":52,"n_rows":19,"n_cols":8,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[]
["• SQRT",25,null,{"$f":"SQRT(B2)","v":5},null,"• PI",null,{"$f":"PI( )","v":3.1415926535897931}]
[]
["• FACT",5,null,{"$f":"FACT(B4)","v":120},null,"• RAND",null,{"$f":"RAND( )","v":0.90791473059905559}]
[]
["• POWER",4,null,{"$f":"POWER(B6,3)","v":64}]
[]
[null,"이름","부서","1월","2월","3월","합계"]
[null,"김상원","영업1부",557,345,721,{"$f":"SUM(D9:F9)","v":1623}]
[null,"이갑봉","영업2부",476,513,174,1163]
[null,"강정희","영업1부",231,474,358,1063]
[null,"김동호","영업1부",175,453,443,1071]
[null,"이남주","영업2부",834,401,743,1978]
[null,"왕영애","영업1부",597,347,346,1290]
[null,"박효남","영업2부",634,530,651,1815]
[]
[]
[null,"부서","인원","1월합계","2월합계","3월합계","총합계"]
[null,"영업1부",{"$f":"COUNTIF(C9:C15, B19)","v":4},{"$f":"SUMIF($C$9:$C$15, $B$19, D9:D15)","v":1560},{"$f":"SUMIF($C$9:$C$15, $B$19, E9:E15)","v":1619},1868,5047]

{"sheet":"재무(예제)","index":53,"n_rows":15,"n_cols":6,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[null,"• FV 함수",null,null,"• PV 함수"]
[]
[null,"연이율",0.06,null,"연이율",0.08]
[null,"기간",1,null,"수령 기간",30]
[null,"월불입액",300000,null,"매월 수령액",100000]
[]
[null,"만기금액",null,null,"연금의 현재가치"]
[]
[null,"• PMT 함수",null,null,"• PMT 함수"]
[]
[null,"연이율",7.4999999999999997E-2,null,"연이율",4.4999999999999998E-2]
[null,"기간",3,null,"기간",5]
[null,"대출금액",50000000,null,"저축총액",50000000]
[]
[null,"월상환액",null,null,"월불입액"]

{"sheet":"재무(결과)","index":54,"n_rows":15,"n_cols":6,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[null,"• FV 함수",null,null,"• PV 함수"]
[]
[null,"연이율",0.06,null,"연이율",0.08]
[null,"기간",1,null,"수령 기간",30]
[null,"월불입액",300000,null,"매월 수령액",100000]
[]
[null,"만기금액",{"$f":"FV(C3/12,C4*12,-C5)","v":3700668.7118698568},null,"연금의 현재가치",{"$f":"PV(F3/12,F4*12,-F5)","v":13628349.413396299}]
[]
[null,"• PMT 함수",null,null,"• PMT 함수"]
[]
[null,"연이율",7.4999999999999997E-2,null,"연이율",4.4999999999999998E-2]
[null,"기간",3,null,"기간",5]
[null,"대출금액",50000000,null,"저축총액",50000000]
[]
[null,"월상환액",{"$f":"PMT(C11/12,C12*12,-C13)","v":1555310.9080328217},null,"월불입액",{"$f":"PMT(F11/12,F12*12,0,-F13)","v":744650.96207583253}]

{"sheet":"통계1(예제)","index":55,"n_rows":31,"n_cols":9,"rows_kept":31,"cut":false,"hidden":false,"merged":[[18,0,18,1],[19,0,19,1]]}
["[표1] ","도서별 대출실적 합계",null,null,null,null,"[표2] ","신입사원 면접결과"]
["구분","4월","5월","6월","평균",null,"성명","면접점수","순위"]
["총서",108,150,97,null,null,"하길주",77]
["사회과학",152,52,110,null,null,"이선호",85]
["인문과학",52,101,89,null,null,"강성수",63]
["공학",100,98,101,null,null,"김보견",45]
["디자인",75,200,36,null,null,"천수만",64]
[null,null,null,null,null,null,"이소영",50]
["[표3]","직급별 연봉액",null,null,null,null,"맹순자",46]
["성명","직급","연봉액",null,null,null,"전기수",78]
["강희정","부장",36483516]
["김민수","사원",12991336,null,"[표4]","영진고등학교 2학년 모의고사 성적 현황"]
["나인성","사원",14230019,null,"성명","1차","2차","3차","점수변동폭"]
["민성진","대리",23122065,null,"배수진",320,341,360]
["박정아","과장",25390984,null,"강경화",296,250,270]
["서진이","사원",20859311,null,"김순응",255,310,322]
["강창우","이사",78945600,null,"고해진",361,308,375]
[null,null,null,null,"박병철",291,342,332]
["2번째 큰값",null,null,null,"이선화",308,367,367]
["2번째 작은 값",null,null,null,"김태민",321,268,297]
[]
["[표5] ","컴퓨터 연수 결과"]
["성명","엑셀","워드","인터넷활용"]
["이지용",87,56,78]
["남진철",98,87,78]
["어인애",45,67,89]
["천우덕",34,99,86]
["민지환",90,87,88]
["박성자",93,54,90]
["표준편차"]
["분산"]

{"sheet":"통계1(결과)","index":56,"n_rows":31,"n_cols":9,"rows_kept":31,"cut":false,"hidden":false,"merged":[[18,0,18,1],[19,0,19,1]]}
["[표1] ","도서별 대출실적 합계",null,null,null,null,"[표2] ","신입사원 면접결과"]
["구분","4월","5월","6월","평균",null,"성명","면접점수","순위"]
["총서",108,150,97,{"$f":"ROUND(AVERAGE(B3:D3),1)","v":118.3},null,"하길주",77,{"$f":"RANK(H3,$H$3:$H$10)&\"등\"","v":"3등"}]
["사회과학",152,52,110,{"$f":"ROUND(AVERAGE(B4:D4),1)","v":104.7},null,"이선호",85,{"$f":"RANK(H4,$H$3:$H$10)&\"등\"","v":"1등"}]
["인문과학",52,101,89,80.7,null,"강성수",63,"5등"]
["공학",100,98,101,99.7,null,"김보견",45,"8등"]
["디자인",75,200,36,103.7,null,"천수만",64,"4등"]
[null,null,null,null,null,null,"이소영",50,"6등"]
["[표3]","직급별 연봉액",null,null,null,null,"맹순자",46,"7등"]
["성명","직급","연봉액",null,null,null,"전기수",78,"2등"]
["강희정","부장",36483516]
["김민수","사원",12991336,null,"[표4]","영진고등학교 2학년 모의고사 성적 현황"]
["나인성","사원",14230019,null,"성명","1차","2차","3차","점수변동폭"]
["민성진","대리",23122065,null,"배수진",320,341,360,{"$f":"MAX(F14:H14)-MIN(F14:H14)","v":40}]
["박정아","과장",25390984,null,"강경화",296,250,270,{"$f":"MAX(F15:H15)-MIN(F15:H15)","v":46}]
["서진이","사원",20859311,null,"김순응",255,310,322,67]
["강창우","이사",78945600,null,"고해진",361,308,375,67]
[null,null,null,null,"박병철",291,342,332,51]
["2번째 큰값",null,{"$f":"LARGE(C11:C17,2)","v":36483516},null,"이선화",308,367,367,59]
["2번째 작은 값",null,{"$f":"SMALL(C11:C17,2)","v":14230019},null,"김태민",321,268,297,53]
[]
["[표5] ","컴퓨터 연수 결과"]
["성명","엑셀","워드","인터넷활용"]
["이지용",87,56,78]
["남진철",98,87,78]
["어인애",45,67,89]
["천우덕",34,99,86]
["민지환",90,87,88]
["박성자",93,54,90]
["표준편차",{"$f":"STDEV(B24:B29)","v":27.573538039214334},{"$f":"STDEV(C24:C29)","v":18.601075237738275},5.4558836742242471]
["분산",{"$f":"VAR(B24:B29)","v":760.3},{"$f":"VAR(C24:C29)","v":346},29.766666666666669]

{"sheet":"통계2(예제)","index":57,"n_rows":23,"n_cols":11,"rows_kept":23,"cut":false,"hidden":false,"merged":[[3,8,3,9],[4,8,4,9],[12,6,12,10]]}
["영어 시험 점수",null,null,null,null,null,"직원 근무 평가"]
[null,null,null,null,null,"성명","입사일","근무점수"]
["이름","영어점수",null,"응시 인원수",null,"박정호","1994-06-06",73]
["강인월",90,null,null,null,"신정희","1997-04-01",68,"70점대"]
["차영국",100,null,null,null,"김용태","1999-05-06",98]
["이미자",85,null,null,null,"김진영","1995-11-01",65]
["류장결",70,null,null,null,"유현숙","1998-01-01",69]
["송태영",95,null,null,null,"최정렬","1998-06-10",80]
["박상영",65,null,null,null,"강창희","1997-09-11",86]
["최현구",80,null,null,null,"천영주","1996-06-10",70]
[null,null,null,null,null,"박인수","1998-05-06",68]
[]
[null,null,"대금 납부 현황",null,null,null,"교재 대금 납부 현황"]
["성명","공통필수","전공필수","전공선택",null,"번호","성명","공통필수","전공필수","전공선택","어학"]
["어동철","O",null,"O",null,101,"이동한","납부",null,"납부"]
["인당수",null,"O",null,null,102,"어형부",null,"납부"]
["기형도","O",null,"O",null,103,"강철민","납부",null,"납부"]
["안지만","O","O",null,null,104,"오지훈",null,"납부",null,"납부"]
["신호연",null,null,"O",null,105,"사용철",null,null,"납부"]
["윤동훈","O","O","O",null,106,"우동철",null,"납부","납부"]
["임미영",null,"O","O",null,107,"유민국","납부","납부",null,"납부"]
["구대성","O",null,"O",null,108,"안동수",null,null,"납부"]
["미납자수",null,null,null,null,null,"미납자수"]

{"sheet":"통계2(결과)","index":58,"n_rows":23,"n_cols":11,"rows_kept":23,"cut":false,"hidden":false,"merged":[[3,8,3,9],[4,8,4,9],[12,6,12,10]]}
["영어 시험 점수",null,null,null,null,null,"직원 근무 평가"]
[null,null,null,null,null,"성명","입사일","근무점수"]
["이름","영어점수",null,"응시 인원수",null,"박정호","1994-06-06",73]
["강인월",90,null,{"$f":"COUNT(B4:B10)","v":7},null,"신정희","1997-04-01",68,"70점대"]
["차영국",100,null,null,null,"김용태","1999-05-06",98,{"$f":"COUNTIF(H3:H11,\">=70\")-COUNTIF(H3:H11,\">80\")","v":3}]
["이미자",85,null,null,null,"김진영","1995-11-01",65]
["류장결",70,null,null,null,"유현숙","1998-01-01",69]
["송태영",95,null,null,null,"최정렬","1998-06-10",80]
["박상영",65,null,null,null,"강창희","1997-09-11",86]
["최현구",80,null,null,null,"천영주","1996-06-10",70]
[null,null,null,null,null,"박인수","1998-05-06",68]
[]
[null,null,"대금 납부 현황",null,null,null,"교재 대금 납부 현황"]
["성명","공통필수","전공필수","전공선택",null,"번호","성명","공통필수","전공필수","전공선택","어학"]
["어동철","O",null,"O",null,101,"이동한","납부",null,"납부"]
["인당수",null,"O",null,null,102,"어형부",null,"납부"]
["기형도","O",null,"O",null,103,"강철민","납부",null,"납부"]
["안지만","O","O",null,null,104,"오지훈",null,"납부",null,"납부"]
["신호연",null,null,"O",null,105,"사용철",null,null,"납부"]
["윤동훈","O","O","O",null,106,"우동철",null,"납부","납부"]
["임미영",null,"O","O",null,107,"유민국","납부","납부",null,"납부"]
["구대성","O",null,"O",null,108,"안동수",null,null,"납부"]
["미납자수",{"$f":"COUNTA(B15:B22)","v":5},{"$f":"COUNTA(C15:C22)","v":4},6,null,null,"미납자수",{"$f":"COUNTBLANK(H15:H22)","v":5},{"$f":"COUNTBLANK(I15:I22)","v":4},3,6]

{"sheet":"찾기1(예제)","index":59,"n_rows":23,"n_cols":13,"rows_kept":23,"cut":false,"hidden":false,"merged":[[11,0,11,3],[11,11,11,12]]}
["[표1]",null,null,null,null,"[표2]",null,null,null,null,"[표3]"]
["고객번호","고객명","고객등급","사은품",null,"위치","이용일수","회원명","비고",null,"성명","수강과목수","수강료"]
["B_Sep1","권태형","GOLD",null,null,"통영",10,"서현진","우수회원",null,"김병수",3]
["B_Sep2","강주호","DIAMOND",null,null,"설악",15,"하태훈","우수회원",null,"차인태",1]
["B_Sep3","김규리","SILVER",null,null,"제주도",11,"안동식","일반회원",null,"정구왕",2]
["C_Tep3","김동화","COPPER",null,null,"안면도",20,"김민철","V.I.P",null,"정재현",3]
["C_Tep4","김서현","GOLD",null,null,"단양",8,"장유익","일반회원",null,"황진하",2]
["C_Tep5","김서희","SILVER",null,null,"삼척",3,"강태공","일반회원",null,"이윤태",1]
["C_Tep6","류은서","GOLD",null,null,null,null,null,null,null,"박한나",3]
["C_Tep7","형민태","COPPER",null,null,null,null,"회원명",null,null,"이미리",4]
[]
["고객등급별 사은품 목록",null,null,null,null,null,null,null,null,null,null,"수강과목별 할인율"]
["C","S","G","D",null,null,null,null,null,null,null,"수강과목수","할인율"]
["없음","전화기","스마트폰","아이패드",null,"[표5]",null,null,null,null,null,1,0]
[null,null,null,null,null,"사원코드","성명","담당부서","근무년수","직위",null,2,0.05]
["[표 4]",null,null,null,null,"A-101","김남이","기획부",16,null,null,4,0.1]
["교수코드","교수명","평가점수","결과",null,"A-201","이지영","영업부",13,null,null,6,0.15]
["CP-0701","한가람",190.15,null,null,"B-312","하나미","기획부",8]
["CP-0503","김은철",166.93,null,null,"C-245","이정훈","영업부",12]
["TC-9505","고사리",182.54,null,null,"A-431","임진태","총무부",4]
["TC-7801","박은별",168.78,null,null,"B-215","강태형","총무부",11]
["PT-0604","성준서",191.54,null,null,"C-456","피정우","총무부",3]
["AC-0906","이성연",170.58,null,null,"B-123","이태민","기획부",15]

{"sheet":"찾기1(결과)","index":60,"n_rows":23,"n_cols":13,"rows_kept":23,"cut":false,"hidden":false,"merged":[[11,0,11,3],[11,11,11,12]]}
["[표1]",null,null,null,null,"[표2]",null,null,null,null,"[표3]"]
["고객번호","고객명","고객등급","사은품",null,"위치","이용일수","회원명","비고",null,"성명","수강과목수","수강료"]
["B_Sep1","권태형","GOLD",{"$f":"HLOOKUP(LEFT(C3,1),$A$13:$D$14,2,0)","v":"스마트폰"},null,"통영",10,"서현진","우수회원",null,"김병수",3,{"$f":"L3*60000*(1-VLOOKUP(L3,$L$14:$M$17,2))","v":171000}]
["B_Sep2","강주호","DIAMOND",{"$f":"HLOOKUP(LEFT(C4,1),$A$13:$D$14,2,0)","v":"아이패드"},null,"설악",15,"하태훈","우수회원",null,"차인태",1,{"$f":"L4*60000*(1-VLOOKUP(L4,$L$14:$M$17,2))","v":60000}]
["B_Sep3","김규리","SILVER","전화기",null,"제주도",11,"안동식","일반회원",null,"정구왕",2,114000]
["C_Tep3","김동화","COPPER","없음",null,"안면도",20,"김민철","V.I.P",null,"정재현",3,171000]
["C_Tep4","김서현","GOLD","스마트폰",null,"단양",8,"장유익","일반회원",null,"황진하",2,114000]
["C_Tep5","김서희","SILVER","전화기",null,"삼척",3,"강태공","일반회원",null,"이윤태",1,60000]
["C_Tep6","류은서","GOLD","스마트폰",null,null,null,null,null,null,"박한나",3,171000]
["C_Tep7","형민태","COPPER","없음",null,null,null,"회원명",{"$f":"VLOOKUP(LARGE(G3:G8,1),G3:I8,2,0)","v":"김민철"},null,"이미리",4,216000]
[]
["고객등급별 사은품 목록",null,null,null,null,null,null,null,null,null,null,"수강과목별 할인율"]
["C","S","G","D",null,null,null,null,null,null,null,"수강과목수","할인율"]
["없음","전화기","스마트폰","아이패드",null,"[표5]",null,null,null,null,null,1,0]
[null,null,null,null,null,"사원코드","성명","담당부서","근무년수","직위",null,2,0.05]
["[표 4]",null,null,null,null,"A-101","김남이","기획부",16,{"$f":"CHOOSE(MID(F16,3,1),\"부장\",\"과장\",\"대리\",\"사원\")","v":"부장"},null,4,0.1]
["교수코드","교수명","평가점수","결과",null,"A-201","이지영","영업부",13,"과장",null,6,0.15]
["CP-0701","한가람",190.15,{"$f":"CHOOSE(RANK(C18,$C$18:$C$23),\"성과급\",\"성과급\",\"\",\"\",\"\",\"감봉\")","v":"성과급"},null,"B-312","하나미","기획부",8,"대리"]
["CP-0503","김은철",166.93,{"$f":"CHOOSE(RANK(C19,$C$18:$C$23),\"성과급\",\"성과급\",\"\",\"\",\"\",\"감봉\")","v":"감봉"},null,"C-245","이정훈","영업부",12,"과장"]
["TC-9505","고사리",182.54,"",null,"A-431","임진태","총무부",4,"사원"]
["TC-7801","박은별",168.78,"",null,"B-215","강태형","총무부",11,"과장"]
["PT-0604","성준서",191.54,"성과급",null,"C-456","피정우","총무부",3,"사원"]
["AC-0906","이성연",170.58,"",null,"B-123","이태민","기획부",15,"부장"]

{"sheet":"찾기2(예제)","index":61,"n_rows":11,"n_cols":6,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[null,"• CHOOSE 함수"]
[null,"날짜 입력","2012-03-31"]
[null,"요일은?"]
[]
[null,"• LOOKUP 함수"]
[null,"점수","학점",null,"점수 입력",80]
[null,0,"가",null,"학       점"]
[null,60,"양"]
[null,70,"미"]
[null,80,"우"]
[null,90,"수"]

{"sheet":"찾기2(결과)","index":62,"n_rows":11,"n_cols":6,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[null,"• CHOOSE 함수"]
[null,"날짜 입력","2012-03-31"]
[null,"요일은?",{"$f":"CHOOSE(WEEKDAY(C2,2),\"월\",\"화\",\"수\",\"목\",\"금\",\"토\",\"일\")","v":"토"}]
[]
[null,"• LOOKUP 함수"]
[null,"점수","학점",null,"점수 입력",80]
[null,0,"가",null,"학       점",{"$f":"LOOKUP(F6, B7:B11, C7:C11)","v":"우"}]
[null,60,"양"]
[null,70,"미"]
[null,80,"우"]
[null,90,"수"]

{"sheet":"찾기3(예제)","index":63,"n_rows":17,"n_cols":7,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[null,"• MATCH, INDEX 함수"]
[null,null,null,null,null,null,"수량에 대한 제품별 할인율"]
[null,"           제품명\n수량","참외","메론","수박","포도","자두"]
[null,0,0,0.01,0.03,0.03,0]
[null,100,0.02,0.03,0.05,0.05,0.03]
[null,200,0.03,0.06,7.0000000000000007E-2,7.0000000000000007E-2,0.05]
[null,300,0.05,0.08,0.1,0.1,0.05]
[null,400,7.0000000000000007E-2,0.1,0.12,0.15,7.0000000000000007E-2]
[null,500,0.1,0.15,0.15,0.2,0.1]
[]
[null,"＊ 주문 제품과 수량"]
[null,"제품명","수박"]
[null,"수량",150]
[null,"행 위치(수량)"]
[null,"열 위치(제품명)"]
[null,"할인율"]
[null,"할인율"]

{"sheet":"찾기3(결과)","index":64,"n_rows":17,"n_cols":7,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[null,"• MATCH, INDEX 함수"]
[null,null,null,null,null,null,"수량에 대한 제품별 할인율"]
[null,"           제품명\n수량","참외","메론","수박","포도","자두"]
[null,0,0,0.01,0.03,0.03,0]
[null,100,0.02,0.03,0.05,0.05,0.03]
[null,200,0.03,0.06,7.0000000000000007E-2,7.0000000000000007E-2,0.05]
[null,300,0.05,0.08,0.1,0.1,0.05]
[null,400,7.0000000000000007E-2,0.1,0.12,0.15,7.0000000000000007E-2]
[null,500,0.1,0.15,0.15,0.2,0.1]
[]
[null,"＊ 주문 제품과 수량"]
[null,"제품명","수박"]
[null,"수량",150]
[null,"행 위치(수량)",{"$f":"MATCH(C13,B4:B9,1)","v":2}]
[null,"열 위치(제품명)",{"$f":"MATCH(C12,C3:G3,0)","v":3}]
[null,"할인율",{"$f":"INDEX(C4:G9,C14,C15)","v":0.05}]
[null,"할인율",{"$f":"INDEX(C4:G9,MATCH(C13,B4:B9,1),MATCH(C12,C3:G3,0))","v":0.05}]

{"sheet":"정보(예제)","index":65,"n_rows":13,"n_cols":11,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,8,1,10],[10,1,10,3]]}
[]
[null,null,null,null,null,null,null,null,"제품목록"]
[null,"번호","품명","규격","수량","단가","공급가액",null,"품명","규격","단가"]
[null,1,"A001",null,10,null,null,null,"A001","Box",235000]
[null,2,"A003",null,15,null,null,null,"A002","개",127000]
[null,3,null,null,null,null,null,null,"A003","개",203000]
[null,4,null,null,null,null,null,null,"A004","개",67000]
[null,5,null,null,null,null,null,null,"A005","Box",103000]
[null,6,null,null,null,null,null,null,"A006","개",54000]
[null,7,null,null,null,null,null,null,"A007","개",135000]
[null,"합계",null,null,null,null,{"$f":"SUM(G4:G10)","v":0},null,"A008","개",113000]
[null,null,null,null,null,null,null,null,"A009","개",114000]
[null,null,null,null,null,null,null,null,"A010","개",192000]

{"sheet":"정보(결과)","index":66,"n_rows":13,"n_cols":11,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,8,1,10],[10,1,10,3]]}
[]
[null,null,null,null,null,null,null,null,"제품목록"]
[null,"번호","품명","규격","수량","단가","공급가액",null,"품명","규격","단가"]
[null,1,"A001",{"$f":"IF(ISBLANK(C4),\"\",VLOOKUP(C4,$I$4:$K$13,2,0))","v":"Box"},10,{"$f":"IF(ISBLANK(C4),\"\",VLOOKUP(C4,$I$4:$K$13,3,0))","v":235000},{"$f":"IF(ISERROR(E4*F4),\"\",E4*F4)","v":2350000},null,"A001","Box",235000]
[null,2,"A003",{"$f":"IF(ISBLANK(C5),\"\",VLOOKUP(C5,$I$4:$K$13,2,0))","v":"개"},15,{"$f":"IF(ISBLANK(C5),\"\",VLOOKUP(C5,$I$4:$K$13,3,0))","v":203000},{"$f":"IF(ISERROR(E5*F5),\"\",E5*F5)","v":3045000},null,"A002","개",127000]
[null,3,null,{"$f":"IF(ISBLANK(C6),\"\",VLOOKUP(C6,$I$4:$K$13,2,0))","v":""},null,"","",null,"A003","개",203000]
[null,4,null,"",null,"","",null,"A004","개",67000]
[null,5,null,"",null,"","",null,"A005","Box",103000]
[null,6,null,"",null,"","",null,"A006","개",54000]
[null,7,null,"",null,"","",null,"A007","개",135000]
[null,"합계",null,null,null,null,{"$f":"SUM(G4:G10)","v":5395000},null,"A008","개",113000]
[null,null,null,null,null,null,null,null,"A009","개",114000]
[null,null,null,null,null,null,null,null,"A010","개",192000]

{"sheet":"실습1(예제)","index":67,"n_rows":35,"n_cols":11,"rows_kept":35,"cut":false,"hidden":false,"merged":[[29,5,29,10],[30,5,30,10]]}
["[표1] 채용 시험 성적",null,null,null,null,null,"[표2] 상여금 지급 현황"]
["수험번호","이름","성별","성적",null,null,null,null,null,null,"(단위:천원)"]
[2004001,"강진정","남",83,null,null,"팀별","성명","사번","본봉","상여금"]
[2004002,"김용민","여",67,null,null,"재무팀","김나래","9711P",1800]
[2004003,"진경만","여",90,null,null,"재무팀","윤기상","9801A",1500]
[2004004,"박자희","남",71,null,null,"영업팀","황선호","9914A",1200]
[2004005,"고현주","여",96,null,null,"영업팀","이재만","9822Q",2200]
[2004006,"성현이","여",98,null,null,"기획팀","허준용","9901B",1300]
[2004007,"임수정","남",100,null,null,"기획팀","방기차","9612P",2000]
[2004008,"주철한","남",53,null,null,"홍보팀","채만종","9912P",1000]
[2004009,"나혼정","여",45]
[null,null,null,null,null,null,"상여금 지급 기준표"]
[null,null,"표준편차(남)",null,null,null,"입사년도","96","97","98","99"]
[null,null,null,null,null,null,"구성비율(%)",0.27,0.35,0.23,0.15]
["[표3] 필기 시험 평가 ",null,null,null,null,null,"상여금",1250,950,870,720]
["성명","영어","전산","상식","평가"]
["장혁준",75,86,85]
["이선돌",92,89,94,null,null,"[표4] 청소년 수련원 입소예약"]
["민영호",50,98,90,null,null,"접수코드","동아리명","입소월","예정인원","수련원명"]
["곽태우",55,90,95,null,null,"K001-1","가야","4월",24]
["전준호",65,85,70,null,null,"K001-2","걸스","5월",32]
["박태식",75,65,40,null,null,"S001-3","한별","5월",45]
["차만석",86,100,95,null,null,"S001-4","참빛","6월",68]
["이미자",85,68,98,null,null,"K002-2","너럭","6월",55]
[null,null,null,null,null,null,"K003-2","참사랑","7월",24]
[null,null,null,null,null,null,"S002-3","새벽","8월",58]
["[표5] 매출 판매 수량 집계",null,null,null,"(단위 : 대)",null,"S001-1","울트라","8월",30]
["판매점","냉장고","홈시어터","세탁기","합계"]
["중구",78,86,75,{"$f":"SUM(C29:D29)","v":161}]
["동구",85,86,95,{"$f":"SUM(C30:D30)","v":181},"중구지점의 냉장고 최대수량과 중구지점의 세탁기 최소수량의 차이"]
["중구",98,78,98,176]
["북구",100,95,98,193]
["동구",85,75,75,150]
["중구",100,95,98,193]
["북구",85,75,75,150]

{"sheet":"실습1(결과)","index":68,"n_rows":35,"n_cols":11,"rows_kept":35,"cut":false,"hidden":false,"merged":[[29,5,29,10],[30,5,30,10]]}
["[표1] 채용 시험 성적",null,null,null,null,null,"[표2] 상여금 지급 현황"]
["수험번호","이름","성별","성적",null,null,null,null,null,null,"(단위:천원)"]
[2004001,"강진정","남",83,null,null,"팀별","성명","사번","본봉","상여금"]
[2004002,"김용민","여",67,null,null,"재무팀","김나래","9711P",1800,{"$f":"HLOOKUP(LEFT(I4,2),$H$13:$K$15,3,0)","v":950}]
[2004003,"진경만","여",90,null,null,"재무팀","윤기상","9801A",1500,{"$f":"HLOOKUP(LEFT(I5,2),$H$13:$K$15,3,0)","v":870}]
[2004004,"박자희","남",71,null,null,"영업팀","황선호","9914A",1200,720]
[2004005,"고현주","여",96,null,null,"영업팀","이재만","9822Q",2200,870]
[2004006,"성현이","여",98,null,null,"기획팀","허준용","9901B",1300,720]
[2004007,"임수정","남",100,null,null,"기획팀","방기차","9612P",2000,1250]
[2004008,"주철한","남",53,null,null,"홍보팀","채만종","9912P",1000,720]
[2004009,"나혼정","여",45]
[null,null,null,null,null,null,"상여금 지급 기준표"]
[null,null,"표준편차(남)",{"$f":"ROUNDUP(DSTDEV(A2:D11,D2,C2:C3),1)","v":19.900000000000002},null,null,"입사년도","96","97","98","99"]
[null,null,null,null,null,null,"구성비율(%)",0.27,0.35,0.23,0.15]
["[표3] 필기 시험 평가 ",null,null,null,null,null,"상여금",1250,950,870,720]
["성명","영어","전산","상식","평가"]
["장혁준",75,86,85,{"$f":"IF(SUM(B17:D17)>=270,\"우수상\",\"\")","v":""}]
["이선돌",92,89,94,{"$f":"IF(SUM(B18:D18)>=270,\"우수상\",\"\")","v":"우수상"},null,"[표4] 청소년 수련원 입소예약"]
["민영호",50,98,90,"",null,"접수코드","동아리명","입소월","예정인원","수련원명"]
["곽태우",55,90,95,"",null,"K001-1","가야","4월",24,{"$f":"CHOOSE(RIGHT(G20,1),\"청평\",\"대성리\",\"대천\",\"파주\")","v":"청평"}]
["전준호",65,85,70,"",null,"K001-2","걸스","5월",32,{"$f":"CHOOSE(RIGHT(G21,1),\"청평\",\"대성리\",\"대천\",\"파주\")","v":"대성리"}]
["박태식",75,65,40,"",null,"S001-3","한별","5월",45,"대천"]
["차만석",86,100,95,"우수상",null,"S001-4","참빛","6월",68,"파주"]
["이미자",85,68,98,"",null,"K002-2","너럭","6월",55,"대성리"]
[null,null,null,null,null,null,"K003-2","참사랑","7월",24,"대성리"]
[null,null,null,null,null,null,"S002-3","새벽","8월",58,"대천"]
["[표5] 매출 판매 수량 집계",null,null,null,"(단위 : 대)",null,"S001-1","울트라","8월",30,"청평"]
["판매점","냉장고","홈시어터","세탁기","합계"]
["중구",78,86,75,{"$f":"SUM(C29:D29)","v":161}]
["동구",85,86,95,{"$f":"SUM(C30:D30)","v":181},"중구지점의 냉장고 최대수량과 중구지점의 세탁기 최소수량의 차이"]
["중구",98,78,98,176,{"$f":"ABS(DMAX(A28:E35,B28,A28:A29)-DMIN(A28:E35,D28,A28:A29))","v":25}]
["북구",100,95,98,193]
["동구",85,75,75,150]
["중구",100,95,98,193]
["북구",85,75,75,150]

{"sheet":"배열수식(예제)","index":69,"n_rows":10,"n_cols":3,"rows_kept":10,"cut":false,"hidden":false,"merged":[[7,0,7,1],[9,0,9,1]]}
[null,"성별","금액"]
["강희정","여",10000]
["김민수","남",15000]
["민성민","남",10000]
["박정아","여",20000]
["나인성","남",17000]
[]
["남자 금액 합계"]
[]
["남자 인원수"]

{"sheet":"배열수식(결과)","index":70,"n_rows":10,"n_cols":3,"rows_kept":10,"cut":false,"hidden":false,"merged":[[7,0,7,1],[9,0,9,1]]}
["이름","성별","금액"]
["강희정","여",10000]
["김민수","남",15000]
["민성민","남",10000]
["박정아","여",20000]
["나인성","남",17000]
[]
["남자 금액 합계",null,{"$f":"SUM((B2:B6=\"남\")*C2:C6)","v":42000}]
[]
["남자 인원수",null,{"$f":"SUM((B2:B6=\"남\")*1)","v":3}]

{"sheet":"배열1(예제)","index":71,"n_rows":33,"n_cols":6,"rows_kept":33,"cut":false,"hidden":false,"merged":[[1,0,1,2]]}
["[표1]"]
["부서별 성적분포"]
["부서","직무수행 평균","인원수"]
["관리부"]
["기술부"]
["기획실"]
["인사부"]
[]
["[표2]"]
["부서명","이름","직무수행","이해판단","성실책임","절충협조"]
["기획실","이나영",82,56,77,91]
["기획실","방극준",85,70,78,62]
["기술부","이원섭",91,62,70,82]
["기술부","정태은",92,90,78,85]
["기획실","최재석",87,85,82,70]
["관리부","최준기",78,68,78,91]
["관리부","이원형",77,78,82,91]
["인사부","홍지원",77,78,76,80]
["기술부","정은숙",96,82,78,56]
["기획실","김지영",84,78,69,70]
["기획실","박영훈",75,79,82,82]
["인사부","이준성",72,92,95,90]
["인사부","전광일",88,95,89,82]
["기술부","유제관",92,68,77,75]
["인사부","김민영",84,56,67,87]
["기획실","도경민",97,89,88,77]
["관리부","인정제",88,69,72,68]
["기술부","최대훈",88,91,78,85]
["인사부","윤여송",66,92,90,97]
["기획실","유근선",92,68,91,91]
["관리부","정환호",81,78,82,77]
["관리부","이응표",76,82,80,75]
["인사부","이지수",98,98,90,80]

{"sheet":"배열1(결과)","index":72,"n_rows":33,"n_cols":6,"rows_kept":33,"cut":false,"hidden":false,"merged":[[1,0,1,2]]}
["[표1]"]
["부서별 성적분포"]
["부서","직무수행 평균","인원수"]
["관리부",{"$f":"AVERAGE(IF($A$11:$A$33=A4,$C$11:$C$33))","v":80},{"$f":"SUM(IF($A$11:$A$33=A4,1))","v":5}]
["기술부",{"$f":"AVERAGE(IF($A$11:$A$33=A5,$C$11:$C$33))","v":91.8},{"$f":"SUM(IF($A$11:$A$33=A5,1))","v":5}]
["기획실",{"$f":"AVERAGE(IF($A$11:$A$33=A6,$C$11:$C$33))","v":86},{"$f":"SUM(IF($A$11:$A$33=A6,1))","v":7}]
["인사부",{"$f":"AVERAGE(IF($A$11:$A$33=A7,$C$11:$C$33))","v":80.833333333333329},{"$f":"SUM(IF($A$11:$A$33=A7,1))","v":6}]
[]
["[표2]"]
["부서명","이름","직무수행","이해판단","성실책임","절충협조"]
["기획실","이나영",82,56,77,91]
["기획실","방극준",85,70,78,62]
["기술부","이원섭",91,62,70,82]
["기술부","정태은",92,90,78,85]
["기획실","최재석",87,85,82,70]
["관리부","최준기",78,68,78,91]
["관리부","이원형",77,78,82,91]
["인사부","홍지원",77,78,76,80]
["기술부","정은숙",96,82,78,56]
["기획실","김지영",84,78,69,70]
["기획실","박영훈",75,79,82,82]
["인사부","이준성",72,92,95,90]
["인사부","전광일",88,95,89,82]
["기술부","유제관",92,68,77,75]
["인사부","김민영",84,56,67,87]
["기획실","도경민",97,89,88,77]
["관리부","인정제",88,69,72,68]
["기술부","최대훈",88,91,78,85]
["인사부","윤여송",66,92,90,97]
["기획실","유근선",92,68,91,91]
["관리부","정환호",81,78,82,77]
["관리부","이응표",76,82,80,75]
["인사부","이지수",98,98,90,80]

{"sheet":"배열2(예제)","index":73,"n_rows":23,"n_cols":13,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
["[표1]"]
["과목명","성명","학과","출석","과제","중간","기말",null,"[표2]"]
["C002","김대성","컴퓨터공학과",18,20,25,20,null,"과목명","전자공학과","컴퓨터공학과"]
["C002","지민희","컴퓨터공학과",20,20,22,18,null,"C002"]
["C002","형민석","컴퓨터공학과",16,19,17,25,null,"P007"]
["C002","이현실","컴퓨터공학과",15,15,13,26,null,"C005"]
["P007","김대성","컴퓨터공학과",20,13,24,26,null,"S006"]
["P007","지민희","컴퓨터공학과",15,20,26,24,null,"P001"]
["P007","이현실","컴퓨터공학과",12,15,20,22]
["P007","이성희","컴퓨터공학과",18,17,18,13,null,"[표3]"]
["P007","송창민","컴퓨터공학과",20,16,24,18,null,"학과","출석","과제","중간","기말"]
["C005","장충태","전자공학과",16,14,10,12,null,"컴퓨터공학과"]
["C005","최종민","전자공학과",19,17,20,20,null,"전자공학과"]
["C005","한가영","전자공학과",17,16,28,17]
["C005","심학철","전자공학과",20,18,30,28]
["S006","한가영","전자공학과",20,20,28,30]
["S006","진명훈","전자공학과",18,13,24,8]
["S006","조인희","전자공학과",20,15,24,12]
["P001","이성희","컴퓨터공학과",20,20,28,28]
["P001","송창민","컴퓨터공학과",20,20,30,20]
["P001","형민석","컴퓨터공학과",18,18,22,28]
["P001","최준석","컴퓨터공학과",16,18,18,22]
["P001","이성희","컴퓨터공학과",12,12,20,12]

{"sheet":"배열2(결과)","index":74,"n_rows":23,"n_cols":13,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
["[표1]"]
["과목명","성명","학과","출석","과제","중간","기말",null,"[표2]"]
["C002","김대성","컴퓨터공학과",18,20,25,20,null,"과목명","전자공학과","컴퓨터공학과"]
["C002","지민희","컴퓨터공학과",20,20,22,18,null,"C002",{"$f":"SUM(($A$3:$A$23=$I4)*($C$3:$C$23=J$3))","v":0},{"$f":"SUM(($A$3:$A$23=$I4)*($C$3:$C$23=K$3))","v":4}]
["C002","형민석","컴퓨터공학과",16,19,17,25,null,"P007",{"$f":"SUM(($A$3:$A$23=$I5)*($C$3:$C$23=J$3))","v":0},{"$f":"SUM(($A$3:$A$23=$I5)*($C$3:$C$23=K$3))","v":5}]
["C002","이현실","컴퓨터공학과",15,15,13,26,null,"C005",{"$f":"SUM(($A$3:$A$23=$I6)*($C$3:$C$23=J$3))","v":4},{"$f":"SUM(($A$3:$A$23=$I6)*($C$3:$C$23=K$3))","v":0}]
["P007","김대성","컴퓨터공학과",20,13,24,26,null,"S006",{"$f":"SUM(($A$3:$A$23=$I7)*($C$3:$C$23=J$3))","v":3},{"$f":"SUM(($A$3:$A$23=$I7)*($C$3:$C$23=K$3))","v":0}]
["P007","지민희","컴퓨터공학과",15,20,26,24,null,"P001",{"$f":"SUM(($A$3:$A$23=$I8)*($C$3:$C$23=J$3))","v":0},{"$f":"SUM(($A$3:$A$23=$I8)*($C$3:$C$23=K$3))","v":5}]
["P007","이현실","컴퓨터공학과",12,15,20,22]
["P007","이성희","컴퓨터공학과",18,17,18,13,null,"[표3]"]
["P007","송창민","컴퓨터공학과",20,16,24,18,null,"학과","출석","과제","중간","기말"]
["C005","장충태","전자공학과",16,14,10,12,null,"컴퓨터공학과",{"$f":"AVERAGE(IF($C$3:$C$23=$I12,D$3:D$23))","v":17.142857142857142},{"$f":"AVERAGE(IF($C$3:$C$23=$I12,E$3:E$23))","v":17.357142857142858},{"$f":"AVERAGE(IF($C$3:$C$23=$I12,F$3:F$23))","v":21.928571428571427},{"$f":"AVERAGE(IF($C$3:$C$23=$I12,G$3:G$23))","v":21.571428571428573}]
["C005","최종민","전자공학과",19,17,20,20,null,"전자공학과",{"$f":"AVERAGE(IF($C$3:$C$23=$I13,D$3:D$23))","v":18.571428571428573},{"$f":"AVERAGE(IF($C$3:$C$23=$I13,E$3:E$23))","v":16.142857142857142},{"$f":"AVERAGE(IF($C$3:$C$23=$I13,F$3:F$23))","v":23.428571428571427},{"$f":"AVERAGE(IF($C$3:$C$23=$I13,G$3:G$23))","v":18.142857142857142}]
["C005","한가영","전자공학과",17,16,28,17]
["C005","심학철","전자공학과",20,18,30,28]
["S006","한가영","전자공학과",20,20,28,30]
["S006","진명훈","전자공학과",18,13,24,8]
["S006","조인희","전자공학과",20,15,24,12]
["P001","이성희","컴퓨터공학과",20,20,28,28]
["P001","송창민","컴퓨터공학과",20,20,30,20]
["P001","형민석","컴퓨터공학과",18,18,22,28]
["P001","최준석","컴퓨터공학과",16,18,18,22]
["P001","이성희","컴퓨터공학과",12,12,20,12]

{"sheet":"배열3(예제)","index":75,"n_rows":23,"n_cols":6,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
["[표1] 분류코드별 최고 월평균임금",null,null,null,"[표2] 분류코드 SA의 업무코드별 종사자수의 합계"]
["분류코드","최고 월평균임금",null,null,"업무코드","종사자수 합계"]
["SA",null,null,null,"분석가"]
["AP",null,null,null,"관리자"]
[null,null,null,null,"기획자"]
["[표3]"]
["분류코드","업무구분","종사자수","월평균임금","전년월평균임금","평균경력"]
["SA","시스템설계분석가",4829,3420000,3100000,8]
["SA","IT컨설턴트",14195,3090000,3000000,5.9]
["AP","시스템SW개발자",8130,2560000,2400000,6.5]
["SA","보안관리자",5797,2540000,2450000,6]
["SA","NW분석가",3168,2290000,2450000,4.9000000000000004]
["AP","응용SW개발자",114054,2200000,2350000,5.4]
["SA","SM관리자",76947,1990000,2100000,6.7]
["AP","웹개발자",15887,1640000,1850000,4.0999999999999996]
["SA","웹관리자",32931,1490000,1650000,3.1]
["AP","통신관리자",31080,1750000,2540000,8.4]
["AP","통신케이블설치",21786,1840000,1910000,10.6]
["AP","멀티미디어기획자",2258,1790000,1950000,3.4]
["SA","망기획자",9470,1520000,1300000,9.6999999999999993]
["SA","PC수리원",37802,1730000,1750000,4.9000000000000004]
["AP","PC강사",21146,1190000,1200000,2.8]
["SA","정보통신관리자",21222,1460000,3300000,12.9]

{"sheet":"배열3(결과)","index":76,"n_rows":23,"n_cols":6,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
["[표1] 분류코드별 최고 월평균임금",null,null,null,"[표2] 분류코드 SA의 업무코드별 종사자수의 합계"]
["분류코드","최고 월평균임금",null,null,"업무코드","종사자수 합계"]
["SA",{"$f":"MAX(IF(($A$8:$A$23=$A3),$D$8:$D$23))","v":3420000},null,null,"분석가",{"$f":"SUM((RIGHT($B$8:$B$23,3)=$E3)*($A$8:$A$23=\"SA\")*$C$8:$C$23)","v":7997}]
["AP",{"$f":"MAX(IF(($A$8:$A$23=$A4),$D$8:$D$23))","v":2560000},null,null,"관리자",{"$f":"SUM((RIGHT($B$8:$B$23,3)=$E4)*($A$8:$A$23=\"SA\")*$C$8:$C$23)","v":136897}]
[null,null,null,null,"기획자",{"$f":"SUM((RIGHT($B$8:$B$23,3)=$E5)*($A$8:$A$23=\"SA\")*$C$8:$C$23)","v":9470}]
["[표3]"]
["분류코드","업무구분","종사자수","월평균임금","전년월평균임금","평균경력"]
["SA","시스템설계분석가",4829,3420000,3100000,8]
["SA","IT컨설턴트",14195,3090000,3000000,5.9]
["AP","시스템SW개발자",8130,2560000,2400000,6.5]
["SA","보안관리자",5797,2540000,2450000,6]
["SA","NW분석가",3168,2290000,2450000,4.9000000000000004]
["AP","응용SW개발자",114054,2200000,2350000,5.4]
["SA","SM관리자",76947,1990000,2100000,6.7]
["AP","웹개발자",15887,1640000,1850000,4.0999999999999996]
["SA","웹관리자",32931,1490000,1650000,3.1]
["AP","통신관리자",31080,1750000,2540000,8.4]
["AP","통신케이블설치",21786,1840000,1910000,10.6]
["AP","멀티미디어기획자",2258,1790000,1950000,3.4]
["SA","망기획자",9470,1520000,1300000,9.6999999999999993]
["SA","PC수리원",37802,1730000,1750000,4.9000000000000004]
["AP","PC강사",21146,1190000,1200000,2.8]
["SA","정보통신관리자",21222,1460000,3300000,12.9]

{"sheet":"사용자정의(예제)","index":77,"n_rows":32,"n_cols":7,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
[]
["과목명","성명","출석","과제","중간","기말","총점"]
["C002","김대성",18,20,25,20]
["P007","이현실",12,15,20,22]
["C005","장충태",16,14,10,12]
["C005","심학철",20,18,30,28]
["S006","한가영",20,20,28,30]
["S006","진명훈",18,13,24,8]
["P001","형민석",18,18,22,28]
["P001","최준석",16,18,18,22]
[]
["[표2]"]
["분류코드","업무구분","종사자수","월평균임금","전년월평균임금","평균경력","보너스지급율"]
["SA","IT컨설턴트",14195,3090000,3000000,5.9]
["AP","시스템SW개발자",8130,2560000,2400000,6.5]
["SA","보안관리자",5797,2540000,2450000,6]
["SA","NW분석가",3168,2290000,2450000,4.9000000000000004]
["AP","통신케이블설치",21786,1840000,1910000,10.6]
["AP","멀티미디어기획자",2258,1790000,1950000,3.4]
["SA","망기획자",9470,1520000,1300000,9.6999999999999993]
["SA","PC수리원",37802,1730000,1750000,4.9000000000000004]
["AP","PC강사",21146,1190000,1200000,2.8]
["SA","정보통신관리자",21222,1460000,3300000,12.9]
[]
["[표3]"]
["사용자","사용량","사용요금"]
["경인에폭시",43]
["고려상사",265]
["고려종합",288]
["SDC",423]
["영원종합",584]
["한국물산",180]

{"sheet":"사용자정의(결과)","index":78,"n_rows":32,"n_cols":7,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
["[표1]"]
["과목명","성명","출석","과제","중간","기말","총점"]
["C002","김대성",18,20,25,20]
["P007","이현실",12,15,20,22]
["C005","장충태",16,14,10,12]
["C005","심학철",20,18,30,28]
["S006","한가영",20,20,28,30]
["S006","진명훈",18,13,24,8]
["P001","형민석",18,18,22,28]
["P001","최준석",16,18,18,22]
[]
["[표2]"]
["분류코드","업무구분","종사자수","월평균임금","전년월평균임금","평균경력","보너스지급율"]
["SA","IT컨설턴트",14195,3090000,3000000,5.9]
["AP","시스템SW개발자",8130,2560000,2400000,6.5]
["SA","보안관리자",5797,2540000,2450000,6]
["SA","NW분석가",3168,2290000,2450000,4.9000000000000004]
["AP","통신케이블설치",21786,1840000,1910000,10.6]
["AP","멀티미디어기획자",2258,1790000,1950000,3.4]
["SA","망기획자",9470,1520000,1300000,9.6999999999999993]
["SA","PC수리원",37802,1730000,1750000,4.9000000000000004]
["AP","PC강사",21146,1190000,1200000,2.8]
["SA","정보통신관리자",21222,1460000,3300000,12.9]
[]
["[표3]"]
["사용자","사용량","사용요금"]
["경인에폭시",43]
["고려상사",265]
["고려종합",288]
["SDC",423]
["영원종합",584]
["한국물산",180]

{"sheet":"피벗테이블-1","index":79,"n_rows":12,"n_cols":8,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,0,1,7]]}
[]
["부서별 급여 현황"]
["부서명","직위","성명","성별","기본급","성과금","세금","실수령액"]
["생산부","부장","최영감","남",3500000,900000,{"$f":"E4*12%","v":420000},{"$f":"E4+F4-G4","v":3980000}]
["영업부","사원","박가이","남",2200000,300000,{"$f":"E5*12%","v":264000},{"$f":"E5+F5-G5","v":2236000}]
["생산부","대리","이승은","여",2400000,500000,288000,2612000]
["생산부","사원","김성산","남",2000000,300000,240000,2060000]
["기획부","부장","강오선","여",3600000,900000,432000,4068000]
["기획부","사원","이재신","남",2200000,300000,264000,2236000]
["영업부","대리","한이주","남",2600000,500000,312000,2788000]
["영업부","과장","한송이","여",3000000,700000,360000,3340000]
["기획부","대리","장나주","여",2500000,500000,300000,2700000]

{"sheet":"피벗테이블-1(정답)","index":80,"n_rows":30,"n_cols":8,"rows_kept":30,"cut":false,"hidden":false,"merged":[[1,0,1,7]]}
[]
["부서별 급여 현황"]
["부서명","직위","성명","성별","기본급","성과금","세금","실수령액"]
["생산부","부장","최영감","남",3500000,900000,{"$f":"E4*12%","v":420000},{"$f":"E4+F4-G4","v":3980000}]
["영업부","사원","박가이","남",2200000,300000,{"$f":"E5*12%","v":264000},{"$f":"E5+F5-G5","v":2236000}]
["생산부","대리","이승은","여",2400000,500000,288000,2612000]
["생산부","사원","김성산","남",2000000,300000,240000,2060000]
["기획부","부장","강오선","여",3600000,900000,432000,4068000]
["기획부","사원","이재신","남",2200000,300000,264000,2236000]
["영업부","대리","한이주","남",2600000,500000,312000,2788000]
["영업부","과장","한송이","여",3000000,700000,360000,3340000]
["기획부","대리","장나주","여",2500000,500000,300000,2700000]
[]
[]
[]
["성명","(모두)"]
[]
[null,"열 레이블"]
["행 레이블","과장","대리","부장","사원","총합계"]
["기획부"]
["합계 : 기본급",null,2500000,3600000,2200000,8300000]
["합계 : 실수령액",null,2700000,4068000,2236000,9004000]
["생산부"]
["합계 : 기본급",null,2400000,3500000,2000000,7900000]
["합계 : 실수령액",null,2612000,3980000,2060000,8652000]
["영업부"]
["합계 : 기본급",3000000,2600000,null,2200000,7800000]
["합계 : 실수령액",3340000,2788000,null,2236000,8364000]
["전체 합계 : 기본급",3000000,7500000,7100000,6400000,24000000]
["전체 합계 : 실수령액",3340000,8100000,8048000,6532000,26020000]

{"sheet":"피벗테이블-2","index":81,"n_rows":15,"n_cols":6,"rows_kept":15,"cut":false,"hidden":false,"merged":[[0,0,0,5]]}
["택배 배송 현황"]
[]
["배송지역","배송시간대","물품종류","수령인","거리(m)","배송료"]
["망원동","오전","식품","본인",550,3400]
["서교동","오후","의류","경비실",680,3200]
["합정동","오전","전자제품","본인",762,3900]
["망원동","오후","의류","가족",510,3000]
["서교동","오전","식품","본인",500,3500]
["합정동","오전","전자제품","가족",680,3600]
["망원동","오후","의류","본인",920,4000]
["서교동","오전","식품","경비실",750,3800]
["합정동","오후","의류","가족",600,3200]
["서교동","오후","의류","경비실",570,3000]
["망원동","오후","전자제품","경비실",480,2800]
["합정동","오전","식품","본인",620,3400]

{"sheet":"통합1(예제)","index":82,"n_rows":27,"n_cols":10,"rows_kept":27,"cut":false,"hidden":false,"merged":[[8,6,8,9],[17,6,17,9]]}
["[표1]  서울지사 판매현황"]
["마트명","1월","2월","3월","2월","3월"]
["A마트",26954,99953,58735,99953,58735]
["B마트",61936,54840,1841,54840,1841]
["C마트",89745,98119,44002,98119,44002]
["D마트",8672,66419,18661,66419,18661]
["E마트",89676,89793,80495,89793,80495]
[]
[null,null,null,null,null,null,"[표4]  1사분기 판매합계"]
["[표2]  경인지사 판매현황",null,null,null,null,null,"마트명","1월","2월","3월"]
["마트명","1월","4월","5월",null,null,"A마트"]
["A마트",83248,17031,3441,null,null,"B마트"]
["B마트",86710,36062,58855,null,null,"C마트"]
["C마트",66189,7570,14183,null,null,"D마트"]
["D마트",25771,95378,21227,null,null,"E마트"]
["E마트",52673,78162,39747]
[]
["[표3]  제주지사 판매현황",null,null,null,null,null,"[표5]  1사분기 판매건수"]
["마트명","1월","2월","3월",null,null,"마트명","1월","2월","3월"]
["A마트",16384,23083,75919,null,null,"A마트"]
["B마트",97165,91526,64461,null,null,"B마트"]
["C마트",88641,9222,94185,null,null,"C마트"]
["D마트",35360,29785,11527,null,null,"D마트"]
["E마트",28245,6548,19700,null,null,"E마트"]
["C마트",88641,9222,94185]
["D마트",35360,29785,11527]
["E마트",28245,6548,19700]

{"sheet":"통합1(예제) (결과)","index":83,"n_rows":27,"n_cols":10,"rows_kept":27,"cut":false,"hidden":false,"merged":[[8,6,8,9],[17,6,17,9]]}
["[표1]  서울지사 판매현황"]
["마트명","1월","2월","3월","2월","3월"]
["A마트",26954,99953,58735,99953,58735]
["B마트",61936,54840,1841,54840,1841]
["C마트",89745,98119,44002,98119,44002]
["D마트",8672,66419,18661,66419,18661]
["E마트",89676,89793,80495,89793,80495]
[]
[null,null,null,null,null,null,"[표4]  1사분기 판매합계"]
["[표2]  경인지사 판매현황",null,null,null,null,null,"마트명","1월","2월","3월"]
["마트명","1월","4월","5월",null,null,"A마트",126586,123036,134654]
["A마트",83248,17031,3441,null,null,"B마트",245811,146366,66302]
["B마트",86710,36062,58855,null,null,"C마트",244575,107341,138187]
["C마트",66189,7570,14183,null,null,"D마트",69803,96204,30188]
["D마트",25771,95378,21227,null,null,"E마트",170594,96341,100195]
["E마트",52673,78162,39747]
[]
["[표3]  제주지사 판매현황",null,null,null,null,null,"[표5]  1사분기 판매건수"]
["마트명","1월","2월","3월",null,null,"마트명","1월","2월","3월"]
["A마트",16384,23083,75919,null,null,"A마트",3,2,2]
["B마트",97165,91526,64461,null,null,"B마트",3,2,2]
["C마트",88641,9222,94185,null,null,"C마트",3,2,2]
["D마트",35360,29785,11527,null,null,"D마트",3,2,2]
["E마트",28245,6548,19700,null,null,"E마트",3,2,2]
["C마트",88641,9222,94185]
["D마트",35360,29785,11527]
["E마트",28245,6548,19700]

{"sheet":"통합2(예제)","index":84,"n_rows":20,"n_cols":11,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
["[표1] 1월"]
["담당자","서울","성남","강원","수원"]
["박신희",850000,214000,106400,957600]
["문경태",750000,247000,99700,897300,null,"[표4] 담당자별 지역별 최대값"]
["정수정",900000,130000,103000,927000,null,"담당자","서울","성남","인천","수원"]
["오금린",750000,204000,95400,858600,null,"박신희"]
[null,null,null,null,null,null,"문경태"]
["[표2] 2월",null,null,null,null,null,"정수정"]
["담당자","서울","성남","인천","부산",null,"오금린"]
["박신희",900000,141000,104100,936900]
["문경태",1000000,107000,110700,996300,null,"[표5] 담당자별 지역별 최소값"]
["정수정",1000000,112000,111200,1000800,null,"담당자","서울","성남","인천","수원"]
["오금린",1000000,167000,116700,1050300,null,"박신희"]
[null,null,null,null,null,null,"문경태"]
["[표3] 3월",null,null,null,null,null,"정수정"]
["담당자","광주","성남","인천","수원",null,"오금린"]
["박신희",850000,242000,109200,982800]
["문경태",900000,157000,105700,951300]
["정수정",1000000,214000,121400,1092600]
["오금린",850000,222000,107200,964800]

{"sheet":"통합3(예제)","index":85,"n_rows":23,"n_cols":11,"rows_kept":23,"cut":false,"hidden":false,"merged":[[0,1,0,4],[0,7,0,10],[12,1,12,4],[12,6,12,10]]}
["[표1]","4월 드라마 시청률(%)",null,null,null,null,"[표2]","5월 드라마 시청률(%)"]
["프로그램","첫째주","둘째주","셋째주","넷째주",null,"프로그램","첫째주","둘째주","셋째주","넷째주"]
["손목시계",14.3,14.5,13.1,14.8,null,"손목시계",12.8,15.2,14.2,14.4]
["동의보감",18.600000000000001,18.899999999999999,17.100000000000001,19.100000000000001,null,"동의보감",16.600000000000001,19.8,18.399999999999999,18.8]
["프라하의인연",20.100000000000001,20.399999999999999,18.399999999999999,20.7,null,"프라하의인연",18.100000000000001,21.4,19.899999999999999,20.3]
["그대와나",14.9,15.1,13.6,15.3,null,"그대와나",13.3,15.9,14.8,15.1]
["목욕탕집여자들",18.5,18.8,16.899999999999999,19.5,null,"목욕탕집여자들",16.5,19.7,18.3,18.7]
["서울의초승달",19.600000000000001,19.899999999999999,17.899999999999999,20.2,null,"서울의초승달",17.5,20.9,19.399999999999999,19.899999999999999]
["내이름은김탁구",21.8,22.1,19.899999999999999,22.4,null,"내이름은김탁구",19.399999999999999,23.2,21.6,22.2]
["시크릿목장",22.3,22.7,20.399999999999999,23.1,null,"시크릿목장",20.2,23.8,22.1,22.6]
["엄마의하늘",17.8,18.100000000000001,16.3,18.399999999999999,null,"엄마의하늘",16.600000000000001,19.5,17.600000000000001,18.100000000000001]
[]
["[표3]","6월 드라마 시청률(%)",null,null,null,null,"2/4분기 드라마 시청률(%)"]
["프로그램","첫째주","둘째주","셋째주","넷째주",null,"프로그램","첫째주","둘째주","셋째주","넷째주"]
["손목시계",14.4,14.9,16.2,14.3,null,"손목시계"]
["동의보감",18.7,19.399999999999999,21.1,18.600000000000001,null,"동의보감"]
["프라하의인연",20.3,21.3,22.8,20.100000000000001,null,"프라하의인연"]
["그대와나",15.6,15.6,16.899999999999999,14.9,null,"그대와나"]
["목욕탕집여자들",18.600000000000001,19.3,21.6,18.5,null,"목욕탕집여자들"]
["서울의초승달",19.7,20.5,22.2,19.5,null,"서울의초승달"]
["내이름은김탁구",21.8,22.7,24.7,21.7,null,"내이름은김탁구"]
["시크릿목장",22.5,23.3,25.3,22.3,null,"시크릿목장"]
["엄마의하늘",18.2,18.600000000000001,20.2,17.8,null,"엄마의하늘"]

{"sheet":"통합2(결과)","index":86,"n_rows":20,"n_cols":11,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
["[표1] 1월"]
["담당자","서울","성남","강원","수원"]
["박신희",850000,214000,106400,957600]
["문경태",750000,247000,99700,897300,null,"[표4] 담당자별 지역별 최대값"]
["정수정",900000,130000,103000,927000,null,"담당자","서울","성남","인천","수원"]
["오금린",750000,204000,95400,858600,null,"박신희",900000,242000,109200,982800]
[null,null,null,null,null,null,"문경태",1000000,247000,110700,951300]
["[표2] 2월",null,null,null,null,null,"정수정",1000000,214000,121400,1092600]
["담당자","서울","성남","인천","부산",null,"오금린",1000000,222000,116700,964800]
["박신희",900000,141000,104100,936900]
["문경태",1000000,107000,110700,996300,null,"[표5] 담당자별 지역별 최소값"]
["정수정",1000000,112000,111200,1000800,null,"담당자","서울","성남","인천","수원"]
["오금린",1000000,167000,116700,1050300,null,"박신희",850000,141000,104100,957600]
[null,null,null,null,null,null,"문경태",750000,107000,105700,897300]
["[표3] 3월",null,null,null,null,null,"정수정",900000,112000,111200,927000]
["담당자","광주","성남","인천","수원",null,"오금린",750000,167000,107200,858600]
["박신희",850000,242000,109200,982800]
["문경태",900000,157000,105700,951300]
["정수정",1000000,214000,121400,1092600]
["오금린",850000,222000,107200,964800]

{"sheet":"정렬1(예제) ","index":87,"n_rows":11,"n_cols":7,"rows_kept":11,"cut":false,"hidden":false,"merged":[[0,0,0,6]]}
["컴퓨터 활용 능력 합격자 발표"]
["수검번호","성명","필기","SP","합계","평균","합격여부"]
[107,"김여울",79,80,{"$f":"SUM(C3:D3)","v":159},{"$f":"AVERAGE(C3:D3)","v":79.5},"합격"]
[106,"류하늘",75,64,139,69.5,"합격"]
[105,"박바다",97,100,197,98.5,"합격"]
[103,"엄지손",100,98,198,99,"합격"]
[101,"이타석",98,85,183,91.5,"합격"]
[100,"장돌뱅",85,80,165,82.5,"합격"]
[104,"강사랑",55,75,130,65,"불합격"]
[102,"김정현",78,79,157,78.5,"불합격"]
[108,"최호수",45,65,110,55,"불합격"]

{"sheet":"정렬1(결과)","index":88,"n_rows":11,"n_cols":7,"rows_kept":11,"cut":false,"hidden":false,"merged":[[0,0,0,6]]}
["컴퓨터 활용 능력 합격자 발표"]
["수검번호","성명","필기","SP","합계","평균","합격여부"]
[107,"김여울",79,80,{"$f":"SUM(C3:D3)","v":159},{"$f":"AVERAGE(C3:D3)","v":79.5},"합격"]
[106,"류하늘",75,64,139,69.5,"합격"]
[105,"박바다",97,100,197,98.5,"합격"]
[103,"엄지손",100,98,198,99,"합격"]
[101,"이타석",98,85,183,91.5,"합격"]
[100,"장돌뱅",85,80,165,82.5,"합격"]
[104,"강사랑",55,75,130,65,"불합격"]
[102,"김정현",78,79,157,78.5,"불합격"]
[108,"최호수",45,65,110,55,"불합격"]

{"sheet":"정렬2(예제)","index":89,"n_rows":21,"n_cols":7,"rows_kept":21,"cut":false,"hidden":false,"merged":[[0,0,0,6],[2,2,2,4],[20,0,20,1]]}
["분유 납품 현황"]
[null,null,null,null,null,null,"단위: t"]
[]
["업체명","구분","전지분유","탈지분유","계","2007년"," 증감량"]
["건욱유업","회원사",25,34,59,41,18]
["경동낙협","조합",12,152,164,123,41]
["경천낙협","조합",14,37,51,43,8]
["남동유업","회원사",78,789,867,934,-67]
["대천우유합","조합",2,182,184,202,-18]
["로우햄우유","회원사",5,99,104,79,25]
["매달유업","비회원사",47,698,745,854,-109]
["모닝콜유업","기타",3,3,6,5,1]
["엠오푸드","기타",12,21,33,35,-2]
["부부우유합","조합",21,888,909,913,-4]
["비록","비회원사",2,198,200,156,44]
["삼양식품","회원사",2,5,7,12,-5]
["육오대학식품","비회원사",5,3,8,12,-4]
["서울우유합","조합",779,1208,1987,1704,283]
["우목촌","기타",24,567,591,552,39]
["청평우유합","조합",7,4,11,8,3]
["합계",null,1038,4888,5926,5673,253]

{"sheet":"정렬2(결과)","index":90,"n_rows":21,"n_cols":7,"rows_kept":21,"cut":false,"hidden":false,"merged":[[0,0,0,6],[2,2,2,4],[20,0,20,1]]}
["분유 납품 현황"]
[null,null,null,null,null,null,"단위: t"]
[]
["업체명","구분","전지분유","탈지분유","계","2007년"," 증감량"]
["경동낙협","조합",12,152,164,123,41]
["경천낙협","조합",14,37,51,43,8]
["대천우유합","조합",2,182,184,202,-18]
["부부우유합","조합",21,888,909,913,-4]
["서울우유합","조합",779,1208,1987,1704,283]
["청평우유합","조합",7,4,11,8,3]
["건욱유업","회원사",25,34,59,41,18]
["남동유업","회원사",78,789,867,934,-67]
["로우햄우유","회원사",5,99,104,79,25]
["삼양식품","회원사",2,5,7,12,-5]
["매달유업","비회원사",47,698,745,854,-109]
["비록","비회원사",2,198,200,156,44]
["육오대학식품","비회원사",5,3,8,12,-4]
["모닝콜유업","기타",3,3,6,5,1]
["엠오푸드","기타",12,21,33,35,-2]
["우목촌","기타",24,567,591,552,39]
["합계",null,1038,4888,5926,5673,253]

{"sheet":"부분합1(예제)","index":91,"n_rows":12,"n_cols":8,"rows_kept":12,"cut":false,"hidden":false,"merged":[[0,1,0,7]]}
[null,"한국근대사 성적"]
[]
[null,"성명","학년","중간","기말","과제","환산점수","평가"]
[null,"김난영","3학년",79,63,7,70.099999999999994,"C"]
[null,"윤종두","1학년",96,89,9,91.9,"A"]
[null,"이재곤","1학년",78,74,8,76.2,"C"]
[null,"이종대","1학년",64,75,7,70.099999999999994,"C"]
[null,"장대철","2학년",54,45,5,49.1,"F"]
[null,"정두호","2학년",86,84,10,86.4,"B"]
[null,"최대식","3학년",85,92,9,89,"A"]
[null,"최만호","2학년",63,65,6,63.7,"D"]
[null,"한주연","1학년",85,86,9,86,"B"]

{"sheet":"부분합1(결과)","index":92,"n_rows":20,"n_cols":8,"rows_kept":20,"cut":false,"hidden":false,"merged":[[0,1,0,7]]}
[null,"한국근대사 성적"]
[]
[null,"성명","학년","중간","기말","과제","환산점수","평가"]
[null,"이종대","1학년",64,75,7,70.099999999999994,"C"]
[null,"윤종두","1학년",96,89,9,91.9,"A"]
[null,"이재곤","1학년",78,74,8,76.2,"C"]
[null,"한주연","1학년",85,86,9,86,"B"]
[null,null,"1학년 최소값",null,null,null,{"$f":"SUBTOTAL(5,G4:G7)","v":70.099999999999994}]
[null,null,"1학년 최대값",null,null,null,{"$f":"SUBTOTAL(4,G4:G7)","v":91.9}]
[null,"정두호","2학년",86,84,10,86.4,"B"]
[null,"장대철","2학년",54,45,5,49.1,"F"]
[null,"최만호","2학년",63,65,6,63.7,"D"]
[null,null,"2학년 최소값",null,null,null,{"$f":"SUBTOTAL(5,G10:G12)","v":49.1}]
[null,null,"2학년 최대값",null,null,null,{"$f":"SUBTOTAL(4,G10:G12)","v":86.4}]
[null,"최대식","3학년",85,92,9,89,"A"]
[null,"김난영","3학년",79,63,7,70.099999999999994,"C"]
[null,null,"3학년 최소값",null,null,null,{"$f":"SUBTOTAL(5,G15:G16)","v":70.099999999999994}]
[null,null,"3학년 최대값",null,null,null,{"$f":"SUBTOTAL(4,G15:G16)","v":89}]
[null,null,"전체 최소값",null,null,null,{"$f":"SUBTOTAL(5,G4:G16)","v":49.1}]
[null,null,"전체 최대값",null,null,null,{"$f":"SUBTOTAL(4,G4:G16)","v":91.9}]

{"sheet":"부분합2(예제)","index":93,"n_rows":14,"n_cols":7,"rows_kept":14,"cut":false,"hidden":false,"merged":[[0,1,0,6]]}
[null,"급여현황"]
[]
[null,"성별","성명","기본급","수당","공제액","실수령액"]
[null,"남","김병학",2000000,600000,260000,2340000]
[null,"남","유주영",2000000,600000,260000,2340000]
[null,"여","박성희",800000,80000,88000,792000]
[null,"여","남주희",1500000,300000,180000,1620000]
[null,"남","조항관",1200000,180000,138000,1242000]
[null,"여","임하영",800000,80000,88000,792000]
[null,"남","한상국",2000000,600000,260000,2340000]
[null,"여","김영숙",1500000,300000,180000,1620000]
[null,"남","문규례",1500000,300000,180000,1620000]
[null,"남","신명섭",1200000,180000,138000,1242000]
[null,"여","김현욱",800000,80000,88000,792000]

{"sheet":"부분합2(결과)","index":94,"n_rows":17,"n_cols":7,"rows_kept":17,"cut":false,"hidden":false,"merged":[[0,1,0,6]]}
[null,"급여현황"]
[]
[null,"성별","성명","기본급","수당","공제액","실수령액"]
[null,"남","김병학",2000000,600000,260000,2340000]
[null,"남","유주영",2000000,600000,260000,2340000]
[null,"남","조항관",1200000,180000,138000,1242000]
[null,"남","한상국",2000000,600000,260000,2340000]
[null,"남","문규례",1500000,300000,180000,1620000]
[null,"남","신명섭",1200000,180000,138000,1242000]
[null,"남 요약",null,null,null,null,{"$f":"SUBTOTAL(9,G4:G9)","v":11124000}]
[null,"여","박성희",800000,80000,88000,792000]
[null,"여","남주희",1500000,300000,180000,1620000]
[null,"여","임하영",800000,80000,88000,792000]
[null,"여","김영숙",1500000,300000,180000,1620000]
[null,"여","김현욱",800000,80000,88000,792000]
[null,"여 요약",null,null,null,null,{"$f":"SUBTOTAL(9,G11:G15)","v":5616000}]
[null,"총합계",null,null,null,null,{"$f":"SUBTOTAL(9,G4:G15)","v":16740000}]

{"sheet":"데이터표1(예제)","index":95,"n_rows":15,"n_cols":10,"rows_kept":15,"cut":false,"hidden":false,"merged":[[3,5,3,9],[5,3,14,3]]}
["영업이익 계산시트"]
[]
["판매량",30]
["판매단가",100,null,null,null,"판매량 "]
["매출액",{"$f":"B3*B4","v":3000},null,null,null,10,20,30,40,50]
[null,null,null,"판\n매\n단\n가",50]
["매출원가",900,null,null,60]
["총이익",{"$f":"B5-B7","v":2100},null,null,70]
[null,null,null,null,80]
["판매비",50,null,null,90]
["관리비",10,null,null,100]
["영업이익",{"$f":"$B$8-$B$10-$B$11","v":2040},null,null,110]
[null,null,null,null,120]
[null,null,null,null,130]
[null,null,null,null,140]

{"sheet":"데이터표1(예제)_결과","index":96,"n_rows":15,"n_cols":10,"rows_kept":15,"cut":false,"hidden":false,"merged":[[3,5,3,9],[5,3,14,3]]}
["영업이익 계산시트"]
[]
["판매량",30]
["판매단가",100,null,null,null,"판매량 "]
["매출액",{"$f":"B3*B4","v":3000},null,null,null,10,20,30,40,50]
[null,null,null,"판\n매\n단\n가",50]
["매출원가",900,null,null,60]
["총이익",{"$f":"B5-B7","v":2100},null,null,70]
[null,null,null,null,80]
["판매비",50,null,null,90]
["관리비",10,null,null,100]
["영업이익",{"$f":"$B$8-$B$10-$B$11","v":2040},null,null,110]
[null,null,null,null,120]
[null,null,null,null,130]
[null,null,null,null,140]

{"sheet":"데이터표2(예제)","index":97,"n_rows":21,"n_cols":7,"rows_kept":21,"cut":false,"hidden":false,"merged":[[8,2,8,6],[10,0,20,0]]}
[]
["대출금",10000000]
["년이자",7.0000000000000007E-2]
["기간",3]
[]
["월상환액",{"$f":"PMT(B3/12,B4*12,-B2)","v":308770.96865371941}]
[]
[]
[null,null,"대출기간"]
[null,null,1,2,3,4,5]
["년이자",0.04]
[null,4.4999999999999998E-2]
[null,0.05]
[null,5.5E-2]
[null,0.06]
[null,6.5000000000000002E-2]
[null,7.0000000000000007E-2]
[null,7.4999999999999997E-2]
[null,0.08]
[null,8.5000000000000006E-2]
[null,0.09]

{"sheet":"데이터표2(결과)","index":98,"n_rows":21,"n_cols":7,"rows_kept":21,"cut":false,"hidden":false,"merged":[[8,2,8,6],[10,0,20,0]]}
[]
["대출금",10000000]
["년이자",7.0000000000000007E-2]
["기간",3]
[]
["월상환액",{"$f":"PMT(B3/12,B4*12,-B2)","v":308770.96865371941}]
[]
[]
[null,null,"대출기간"]
[null,{"$f":"B6","v":308770.96865371941},1,2,3,4,5]
["년이자",0.04,851499.04195557919,434249.22170774051,295239.85006843682,225790.54641689977,184165.22055266352]
[null,4.4999999999999998E-2,853785.21586372063,436478.1155208344,297469.2447837558,228034.86077431258,186430.1924151665]
[null,0.05,856074.81788467127,438713.89734068443,299708.97104665474,230292.93570646518,188712.33644010933]
[null,5.5E-2,858367.84572349582,440956.56158136606,301959.01804310281,232564.75227243194,191011.62171782242]
[null,0.06,860664.29707080638,443206.10252756893,304219.37451555108,234850.29047935616,193328.01529427912]
[null,6.5000000000000002E-2,862964.16960281401,445462.51433510991,306490.02876509784,237149.52928897695,195661.48218728541]
[null,7.0000000000000007E-2,865267.46098138066,447725.79103145417,308770.96865371941,239462.44662442908,198011.98540349538]
[null,7.4999999999999997E-2,867574.16885407211,449995.92651624535,311062.18160656438,241789.01937731233,200379.48595623762]
[null,0.08,869884.29085421062,452272.91456184152,313363.6546143085,244129.22341502484,202763.94288413681]
[null,8.5000000000000006E-2,872197.8246009273,454556.74881386041,315675.37423557398,246483.0335883571,205165.3132705125]
[null,0.09,874514.76769921428,456847.4227917309,317997.32659940684,248850.42373934211,207583.55226354007]

{"sheet":"목표값1(예제)","index":99,"n_rows":5,"n_cols":6,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,"성명","학년","중간","기말","평균"]
[null,"최대식","3학년",85,92,{"$f":"AVERAGE(D5:E5)","v":88.5}]

{"sheet":"목표값1(결과)","index":100,"n_rows":5,"n_cols":6,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,"성명","학년","중간","기말","평균"]
[null,"최대식","3학년",98,92,{"$f":"AVERAGE(D5:E5)","v":95}]

{"sheet":"목표값2(예제) ","index":101,"n_rows":8,"n_cols":3,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"차량 할부금 계산"]
[null,"차량금액",25000000]
[null,"계약금",8000000]
[null,"할부금",17000000]
[null,"연이율",0.105]
[null,"상환기간(개월)",60]
[null,"월납부액",{"$f":"(C5+C5*C6*C7/12)/C7","v":432083.33333333331}]

{"sheet":"목표값2(결과)","index":102,"n_rows":8,"n_cols":3,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"차량 할부금 계산"]
[null,"차량금액",25000000]
[null,"계약금",8000000]
[null,"할부금",17000000]
[null,"연이율",0.105]
[null,"상환기간(개월)",67.661691542215394]
[null,"월납부액",{"$f":"(C5+C5*C6*C7/12)/C7","v":400000.00000027171}]

{"sheet":"시나리오1(예제)","index":103,"n_rows":11,"n_cols":2,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["재고부담률 계산시나리오"]
["항목","현재"]
["생산량",3000]
["판매량",2000]
["판매단가",3000]
["재고단가",300]
[]
["판매액",{"$f":"생산량*판매단가","v":9000000}]
["재고량",{"$f":"생산량-판매량","v":1000}]
["재고비용",{"$f":"재고량*재고단가","v":300000}]
["재고부담률",{"$f":"재고비용/판매액","v":3.3333333333333333E-2}]

{"sheet":"시나리오1(결과)","index":104,"n_rows":12,"n_cols":7,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[]
[null,"시나리오 요약"]
[null,null,null,"현재 값:","생산/판매변화1","생산/판매변화2","생산/판매변화3"]
[]
[null,"변경 셀:"]
[null,null,"생산량",3000,4000,5000,6000]
[null,null,"판매량",2000,3000,4000,5000]
[null,"결과 셀:"]
[null,null,"재고부담률",3.3333333333333298E-2,2.5000000000000001E-2,0.02,1.6666666666666701E-2]
[null,"참고: 현재 값 열은 시나리오 요약 보고서가 작성될 때의"]
[null,"변경 셀 값을 나타냅니다. 각 시나리오의 변경 셀들은"]
[null,"회색으로 표시됩니다."]

{"sheet":"시나리오2(예제)","index":105,"n_rows":15,"n_cols":7,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[]
[null,"영업 현황 분석"]
[null,null,null,null,null,"제품원가",3200]
[null,"판매수량",3000,null,null,"판매가",4600]
[null,"매출액",{"$f":"G4*C4","v":13800000}]
[null,"매출원가",{"$f":"G3*C4","v":9600000}]
[null,"판매수익",{"$f":"C5-C6","v":4200000}]
[]
[null,"총비용",{"$f":"C10+C11+C12+C13","v":1242000}]
[null,"인건비",{"$f":"C5*3%","v":414000}]
[null,"광고비",{"$f":"C5*2.5%","v":345000}]
[null,"일반관리비",{"$f":"C5*2%","v":276000}]
[null,"운송비",{"$f":"C5*1.5%","v":207000}]
[]
[null,"영업이익",{"$f":"C7-C9","v":2958000}]

{"sheet":"시나리오2(결과)","index":106,"n_rows":11,"n_cols":6,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[]
[null,"시나리오 요약"]
[null,null,null,"현재 값:","판매수량 증가","판매수량 감소"]
[]
[null,"변경 셀:"]
[null,null,"판매수량",3000,4000,2000]
[null,"결과 셀:"]
[null,null,"영업이익",2958000,3944000,1972000]
[null,"참고: 현재 값 열은 시나리오 요약 보고서가 작성될 때의"]
[null,"변경 셀 값을 나타냅니다. 각 시나리오의 변경 셀들은"]
[null,"회색으로 표시됩니다."]

{"sheet":"분석작업_시나리오","index":107,"n_rows":40,"n_cols":9,"rows_kept":40,"cut":false,"hidden":false,"merged":[[0,0,0,7],[19,0,19,8],[37,0,37,6]]}
["사원별 급여 지급 현황"]
[]
["사원명","직위","호봉","기본급","초과근로수당","상여금","세금","실지급액"]
["장하다","부장",8,3600000,432000,1800000,525000,{"$f":"D4+D4*$B$17+E4-G4","v":5307000}]
["백만원","대리",4,2000000,240000,1000000,292000,2948000]
["장애자","과장",7,2800000,336000,1400000,408000,4128000]
["정상인","대리",5,2200000,264000,1100000,321000,3243000]
["전용택","부장",4,3400000,408000,1700000,496000,5012000]
["조만근","대리",5,2200000,264000,1100000,321000,3243000]
["허영심","과장",4,2500000,300000,1250000,365000,3685000]
["신기해","사원",3,2000000,240000,1000000,292000,2948000]
["양귀비","부장",2,3100000,372000,1550000,452000,4570000]
["조약돌","사원",1,1800000,216000,900000,262000,2654000]
["강북남","과장",4,2500000,300000,1250000,365000,3685000]
["이겨래","사원",3,2000000,240000,1000000,292000,2948000]
[]
["상여금비율",0.5]
[]
[]
["6월 전자제품 판매현황"]
[]
["제품명","지역","담당자","입고일","입고량","판매단가","판매량","매출액","순이익"]
["프린터","광주","강정동","2012-05-31",50,150000,30,{"$f":"F23*G23","v":4500000},{"$f":"H23*$I$40","v":1350000}]
["스캐너","경기","김국영","2012-06-01",40,250000,38,9500000,2850000]
["프린터","서울","김시운","2012-06-01",50,150000,34,5100000,1530000]
["노트북","서울","남세연","2012-06-01",60,600000,57,34200000,10260000]
["스캐너","부산","문지섭","2012-06-01",80,250000,59,14750000,4425000]
["노트북","강원","박세균","2012-05-31",60,600000,55,33000000,9900000]
["노트북","광주","송미율","2012-05-31",60,600000,60,36000000,10800000]
["프린터","강원","신수라","2012-05-31",40,150000,29,4350000,1305000]
["스캐너","서울","유지원","2012-06-01",50,250000,45,11250000,3375000]
["스캐너","광주","윤서민","2012-05-31",30,250000,19,4750000,1425000]
["스캐너","강원","이민우","2012-05-31",50,250000,47,11750000,3525000]
["프린터","경기","이설화","2012-06-01",30,150000,26,3900000,1170000]
["노트북","경기","조강민","2012-06-01",80,600000,69,41400000,12420000]
["프린터","부산","한기석","2012-06-01",50,150000,40,6000000,1800000]
["노트북","부산","허남용","2012-06-01",60,600000,52,31200000,9360000]
["합계",null,null,null,null,null,null,{"$f":"SUM(H23:H37)","v":251650000},75495000]
[]
[null,null,null,null,null,null,null,"이익률",0.3]

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

{"sheet":"매크로1(결과)","index":109,"n_rows":35,"n_cols":9,"rows_kept":35,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
["관리코드","타이틀명","입고일자","가격","장르","시간","제작년도","대여료","대여기간"]
["DVD-01","7년만의 외출","2001-05-26",25000,"코메디",105,1955,2000,1]
["DVD-02","3000마일","2001-05-29",25300,"액션",125,2001,1000,2]
["DVD-03","대탈주SE","2001-06-01",29500,"액션",175,1963,1000,1]
["DVD-04","빨강머리앤","2001-06-04",23000,"애니메이션",128,1973,1000,2]
["DVD-05","화산고","2001-06-07",25000,"액션",121,2002,1500,1]
["DVD-06","프렌치키스","2001-06-10",25000,"코메디",111,1995,500,2]
["DVD-07","일단 뛰어","2001-07-05",25300,"코메디",110,2002,1500,1]
["DVD-08","타이탄 족의 멸망","2001-07-30",16500,"모험",118,1981,500,2]
["DVD-09","아마겟돈","2001-08-24",29000,"액션",145,1998,500,2]
["DVD-10","아비정전","2001-09-18",22000,"드라마",94,1991,500,2]
["DVD-11","철목련","2001-10-13",25000,"드라마",117,1989,500,2]
["DVD-12","자이언트 로보","2001-11-07",25000,"애니메이션",60,1991,500,2]
["DVD-13","피터팬","2001-12-02",29000,"애니메이션",76,1953,2000,1]
["DVD-14","톰썸의 비밀모험","2001-12-27",25000,"모험",58,1993,500,2]
["DVD-15","반지의 제왕","2002-01-21",29000,"모험",178,2001,1000,2]
["DVD-16","피도 눈물도 없이","2002-02-15",25000,"액션",113,2002,1500,1]
["DVD-17","뿌리","2002-03-03",37000,"드라마",578,1977,3000,2]
["DVD-18","마리이야기","2002-03-19",25300,"애니메이션",80,2002,500,2]
["DVD-19","스몰빌","2002-04-04",16500,"액션",91,2001,1000,2]
["DVD-20","양철북","2002-04-20",19800,"드라마",142,1979,1000,1]
["DVD-21","하드 캐쉬","2002-05-06",22000,"액션",99,2002,1500,1]
["DVD-22","친구","2002-05-22",25300,"드라마",116,2001,1500,1]
["DVD-23","진주만","2002-06-07",49000,"모험",184,2001,3000,2]
["DVD-24","내겐 너무 가벼운 그녀","2002-06-23",27500,"코메디",113,2001,1500,1]
["DVD-25","서부전선 이상없다","2002-07-09",19980,"액션",128,1979,1000,1]
["DVD-26","슬레이어즈  NEXT","2002-07-25",25000,"애니메이션",25,1996,1000,2]
["DVD-27","달마야 놀자","2002-08-10",25300,"코메디",95,2001,1500,1]
["DVD-28","스파이 게임","2002-08-26",25300,"액션",127,2001,1000,2]
["DVD-29","재미있는 영화","2001-05-25",25000,"코메디",126,2002,2000,2]
["DVD-30","콘에어","2001-06-10",24000,"모험",115,1997,1000,1]

{"sheet":"매크로2(예제)","index":110,"n_rows":23,"n_cols":6,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[null,"지점명","담당자","매출금액","받은금액","미수금"]
[null,"강동","채진욱",33000,32010,990]
[null,"강서","박형주",89000,66750,22250]
[null,"강동","채진욱",39780,31824,7956]
[null,"강서","안병찬",94000,58280,35720]
[null,"강동","채진욱",21000,18480,2520]
[null,"강서","안병찬",50000,37500,12500]
[null,"강동","채진욱",19800,9504,10296]
[null,"강서","안병찬",64000,42240,21760]
[null,"강서","채진욱",19000,13490,5510]
[null,"강서","박형주",110000,74800,35200]
[null,"강동","채진욱",18000,9900,8100]
[null,"강서","안병찬",75600,45360,30240]
[null,"강동","채진욱",28000,25760,2240]
[null,"강동","채진욱",26800,19028,7772]
[null,"강동","이은주",79800,57456,22344]
[null,"강동","이은주",84000,79800,4200]
[null,"강서","안병찬",60000,58200,1800]
[null,"강서","박형주",120000,102000,18000]

{"sheet":"매크로2(결과)","index":111,"n_rows":23,"n_cols":6,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[null,"지점명","담당자","매출금액","받은금액","미수금"]
[null,"강동","채진욱",33000,32010,990]
[null,"강서","박형주",89000,66750,22250]
[null,"강동","채진욱",39780,31824,7956]
[null,"강서","안병찬",94000,58280,35720]
[null,"강동","채진욱",21000,18480,2520]
[null,"강서","안병찬",50000,37500,12500]
[null,"강동","채진욱",19800,9504,10296]
[null,"강서","안병찬",64000,42240,21760]
[null,"강서","채진욱",19000,13490,5510]
[null,"강서","박형주",110000,74800,35200]
[null,"강동","채진욱",18000,9900,8100]
[null,"강서","안병찬",75600,45360,30240]
[null,"강동","채진욱",28000,25760,2240]
[null,"강동","채진욱",26800,19028,7772]
[null,"강동","이은주",79800,57456,22344]
[null,"강동","이은주",84000,79800,4200]
[null,"강서","안병찬",60000,58200,1800]
[null,"강서","박형주",120000,102000,18000]

{"sheet":"차트1(예제)","index":112,"n_rows":14,"n_cols":9,"rows_kept":14,"cut":false,"hidden":false,"merged":[[0,0,0,8]]}
["사원입사현황"]
[]
["부서","성명","성별","직위","입사일자","기본급","수당","세금","본봉"]
["자재부","은현희","여","사원","1999-02-27",750000,107000,85700,771300]
["자재부","박성수","남","과장","1997-10-03",900000,132000,103200,928800]
["자재부","문경태","남","과장","1996-01-07",900000,192000,109200,982800]
["자재부","고춘자","여","대리","1992-07-03",850000,118000,96800,871200]
["자재부","오창곤","남","대리","1992-07-02",850000,186000,103600,932400]
["자재부","정수정","여","대리","1996-02-24",850000,164000,101400,912600]
["자재부","채상유","남","대리","1994-10-17",850000,164000,101400,912600]
["자재부","정진영","여","사원","1999-01-14",750000,128000,87800,790200]
["개발부","홍길동","남","대리","1993-12-22",850000,153000,100300,902700]
["개발부","복분자","여","사원","1994-12-16",750000,124000,87400,786600]
["개발부","김수철","남","과장","1993-09-14",900000,242000,114200,1027800]

{"sheet":"차트1(결과)","index":113,"n_rows":14,"n_cols":9,"rows_kept":14,"cut":false,"hidden":false,"merged":[[0,0,0,8]]}
["사원입사현황"]
[]
["부서","성명","성별","직위","입사일자","기본급","수당","세금","본봉"]
["자재부","은현희","여","사원","1999-02-27",750000,107000,85700,771300]
["자재부","박성수","남","과장","1997-10-03",900000,132000,103200,928800]
["자재부","문경태","남","과장","1996-01-07",900000,192000,109200,982800]
["자재부","고춘자","여","대리","1992-07-03",850000,118000,96800,871200]
["자재부","오창곤","남","대리","1992-07-02",850000,186000,103600,932400]
["자재부","정수정","여","대리","1996-02-24",850000,164000,101400,912600]
["자재부","채상유","남","대리","1994-10-17",850000,164000,101400,912600]
["자재부","정진영","여","사원","1999-01-14",750000,128000,87800,790200]
["개발부","홍길동","남","대리","1993-12-22",850000,153000,100300,902700]
["개발부","복분자","여","사원","1994-12-16",750000,124000,87400,786600]
["개발부","김수철","남","과장","1993-09-14",900000,242000,114200,1027800]

{"sheet":"차트2(예제)","index":114,"n_rows":8,"n_cols":5,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[]
["부서별 성적 현황"]
[]
["부서","1차교육","2차교육","3차교육","평균"]
["관리부",47.625,48.125,64,{"$f":"AVERAGE(B5:D5)","v":53.25}]
["기획부",44.9,54.9,62.9,{"$f":"AVERAGE(B6:D6)","v":54.233333333333327}]
["총무부",56.285714285714285,70.571428571428569,46.285714285714285,{"$f":"AVERAGE(B7:D7)","v":57.714285714285715}]
["영업부",62,59.4,42,{"$f":"AVERAGE(B8:D8)","v":54.466666666666669}]

{"sheet":"차트2(결과)","index":115,"n_rows":8,"n_cols":5,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[]
["부서별 성적 현황"]
[]
["부서","1차교육","2차교육","3차교육","평균"]
["관리부",47.625,48.125,64,{"$f":"AVERAGE(B5:D5)","v":53.25}]
["기획부",44.9,54.9,62.9,{"$f":"AVERAGE(B6:D6)","v":54.233333333333327}]
["총무부",56.285714285714285,70.571428571428569,46.285714285714285,{"$f":"AVERAGE(B7:D7)","v":57.714285714285715}]
["영업부",62,59.4,42,{"$f":"AVERAGE(B8:D8)","v":54.466666666666669}]

{"sheet":"차트3(예제)","index":116,"n_rows":15,"n_cols":6,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[null,null,null,"영업 현황"]
[null,"이름","직책","부서","목표액","달성액"]
[null,"김사원","사원","영업2부",35200,35000]
[null,"김흥부","사원","영업2부",12500,21000]
[null,"노지심","부장","영업1부",62500,65000]
[null,"송치윤","부장","영업4부",62533,61890]
[null,"이관우","사원","영업3부",32560,33000]
[null,"이봉주","부장","영업2부",64250,56000]
[null,"이수진","사원","영업4부",45850,43650]
[null,"이양양","사원","영업1부",56800,60000]
[null,"이인상","부장","영업부",54000,50000]
[null,"이충렬","대리","영업4부",45110,45390]
[null,"장유비","부장","영업3부",58000,60000]
[null,"제갈량","대리","영업1부",46200,45000]
[null,"조자룡","사원","영업3부",32560,32660]

{"sheet":"차트3(결과)","index":117,"n_rows":15,"n_cols":6,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[null,null,null,"영업 현황"]
[null,"이름","직책","부서","목표액","달성액"]
[null,"김사원","사원","영업2부",35200,35000]
[null,"김흥부","사원","영업2부",12500,21000]
[null,"노지심","부장","영업1부",62500,65000]
[null,"송치윤","부장","영업4부",62533,61890]
[null,"이관우","사원","영업3부",32560,33000]
[null,"이봉주","부장","영업2부",64250,56000]
[null,"이수진","사원","영업4부",45850,43650]
[null,"이양양","사원","영업1부",56800,60000]
[null,"이인상","부장","영업부",54000,50000]
[null,"이충렬","대리","영업4부",45110,45390]
[null,"장유비","부장","영업3부",58000,60000]
[null,"제갈량","대리","영업1부",46200,45000]
[null,"조자룡","사원","영업3부",32560,32660]

{"sheet":"차트","index":118,"n_rows":10,"n_cols":6,"rows_kept":10,"cut":false,"hidden":false,"merged":[[2,0,2,5]]}
[]
[]
["어린이완구 매출현황"]
["완구명","제조사","대상연령","판매수량","판매단가","총판매액"]
["전동차","토이랜드","36개월~8세",162,180000,{"$f":"D5*E5","v":29160000}]
["블럭세트","키즈토이","12개월~4세",295,75000,22125000]
["실내그네","뽕뽕키즈","36개월~6세",178,60000,10680000]
["교통놀이","왕자공주","24개월~5세",199,68000,13532000]
["킥보드","세계완구","5세~8세",184,42000,7728000]
["자전거","완구랜드","24개월~4세",169,115000,19435000]

{"sheet":"사원현황(예제)","index":119,"n_rows":7,"n_cols":8,"rows_kept":7,"cut":false,"hidden":false,"merged":[[0,1,0,3]]}
[null,"신입사원현황"]
[]
[null,"부서명","사원명","입사일자",null,null,null,"총무부"]
[null,null,null,null,null,null,null,"인사부"]
[null,null,null,null,null,null,null,"영업부"]
[null,null,null,null,null,null,null,"전산부"]
[null,null,null,null,null,null,null,"관리부"]

{"sheet":"수강등록(예제)","index":120,"n_rows":15,"n_cols":11,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
["[표1]"]
["접수자","수강개월","접수코드","과목","과목강사","수강료"]
[]
[]
[null,null,null,null,null,null,null,"[참조표]"]
[null,null,null,null,null,null,null,"접수코드","과목","과목강사","월수강료"]
[null,null,null,null,null,null,null,"A100","국어","신동길",100000]
[null,null,null,null,null,null,null,"A200","고전","김솔유",110000]
[null,null,null,null,null,null,null,"B100","국사","고두심",100000]
[null,null,null,null,null,null,null,"B200","현대사","노현정",100000]
[null,null,null,null,null,null,null,"C100","영어","조예슬",120000]
[null,null,null,null,null,null,null,"C200","문법","박종훈",120000]
[null,null,null,null,null,null,null,"D100","수학","정솔희",110000]
[null,null,null,null,null,null,null,"D200","과탐","김태희",100000]
[null,null,null,null,null,null,null,"E300","사탐","유인촌",100000]

{"sheet":"조회(예제)","index":121,"n_rows":7,"n_cols":4,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[]
["보험종류","월납부액","납부총액","이자총액"]
["건강저축보험",785720,28285904,1714096]
["주택저축보험",779908,28076678,1923322]
["목돈마련보험",774127,27868569,2131431]
["연금저축보험",768378,27661574,2338426]
["무지개저축보험",762659,27455692,2544308]