{"text_format":"3","workbook":"xlsx","n_sheets":61,"sheets":["참조연습","계산(예제)","계산(결과)","날짜1(예제)","날짜1(결과)","날짜2(예제)","날짜2(결과)","논리(예제)","논리(결과)","데이터베이스1(예제)","데이터베이스1(결과)","데이터베이스2(예제)","데이터베이스2(결과)","데이터베이스3(예제)","데이터베이스3(결과)","문자열1(예제)","문자열1(결과)","문자열2(예제)","문자열2(결과)","문자열3(예제)","문자열3(결과)","수학1(예제)","수학1(결과)","수학2(예제)","수학2(결과)","재무1(예제)","재무1(결과)","재무2(예제)","재무2(결과)","통계1(예제)","통계1(결과)","통계2(예제)","통계2(결과)","통계3(예제)","통계3(결과)","찾기1(예제)","찾기1(결과)","찾기2(예제)","찾기2(결과)","찾기3(예제)","찾기3(결과)","찾기4(예제)","찾기4(결과)","찾기5(예제)","찾기5(결과)","정보1(예제)","정보1(결과)","정보2(예제)","정보2(결과)","실습1(예제)","실습1(결과)","배열수식(예제)","배열수식(결과)","배열1(예제)","배열1(결과)","배열2(예제)","배열2(결과)","배열3(예제)","배열3(결과)","사용자정의(예제)","사용자정의(결과)"],"not_rendered":{"macros":1,"external_links":2,"defined_names":5,"comments":5},"read":"whole","date_system":"1900"}

{"sheet":"참조연습","index":0,"n_rows":15,"n_cols":6,"rows_kept":15}
[]
[{"$nulls":4},"과목수",2]
[]
[null,"이름","국어","영어","합계","평균"]
[null,"보라돌이",60,60,{"$f":"C5+D5","v":120},{"$f":"E5/$F$2","v":60}]
[null,"뚜비",90,90,{"$f":"C6+D6","v":180},{"$f":"E6/$F$2","v":90}]
[null,"나나",70,70,{"$f":"C7+D7","v":140},70]
[null,"뽀",80,80,{"$f":"C8+D8","v":160},80]
[]
[]
[null,"C6+D6",null,{"$f":"B4","v":"이름"},{"$f":"$B$4","v":"이름"},{"$f":"E5/$F$2","v":60}]
[null,"C6+D7",null,{"$f":"B5","v":"보라돌이"},{"$f":"$B$4","v":"이름"},{"$f":"E6/$F$2","v":90}]
[null,"C6+D8",null,"뚜비","이름",70]
[null,"C6+D9",null,"나나","이름",80]
[null,"C6+D10",null,"뽀","이름",0]

{"sheet":"계산(예제)","index":1,"n_rows":29,"n_cols":9,"rows_kept":29,"merged":[[17,0,17,1],[27,0,27,1],[28,0,28,1]]}
["[표1] ","품목별 판매 현황",{"$nulls":3},"[표2] ","고공 낙하 회수별 인원"]
["품목명","판매수량","판매금액","이익금액",null,"낙하회수","인원수","누적인원수","누계비율"]
["샤프",327,{"$f":"B3*3000","v":{"v":981000,"d":"981,000"}},{"$f":"C3*$C$9","v":{"v":245250,"d":"245,250"}},null,"3000이상",5,5,{"$f":"H3/$G$8","v":{"v":0.1,"d":"10%"}}]
["연필",370,{"$f":"B4*350","v":{"v":129500,"d":"129,500"}},{"$f":"C4*$C$9","v":{"v":32375,"d":"32,375"}},null,"1000이상",20,25,{"$f":"H4/$G$8","v":{"v":0.5,"d":"50%"}}]
["만년필",450,{"$f":"B5*6500","v":{"v":2925000,"d":"2,925,000"}},{"v":731250,"d":"731,250"},null,"500이상",15,40,{"v":0.8,"d":"80%"}]
["색연필",900,{"$f":"B6*340","v":{"v":306000,"d":"306,000"}},{"v":76500,"d":"76,500"},null,"100이상",7,47,{"v":0.94,"d":"94%"}]
["볼펜",789,{"$f":"B7*220","v":{"v":173580,"d":"173,580"}},{"v":43395,"d":"43,395"},null,"10이상",3,50,{"v":1,"d":"100%"}]
["플러스펜",670,{"$f":"B8*550","v":{"v":368500,"d":"368,500"}},{"v":92125,"d":"92,125"},null,"합계",{"$f":"SUM(G3:G7)","v":50}]
[null,"마진율",{"v":0.25,"d":"25%"}]
[{"$nulls":6},"[표4] ","펜던트 판매 현황"]
["[표3] ","사원별 수당지급현황",{"$nulls":4},"월","판매량","매출총액"]
["성명","근무년수","기본급","상여비율","수당",null,"1월",75,{"$f":"(H12*$G$20)*(1-$H$20)","v":{"v":15000000,"d":"15,000,000"}}]
["홍기재",15,{"v":2550000,"d":"2,550,000"},{"v":0.15,"d":"15%"},{"$f":"C13+C13*(D13+$C$18)","v":{"v":3085500,"d":"3,085,500"}},null,"2월",65,{"$f":"(H13*$G$20)*(1-$H$20)","v":{"v":13000000,"d":"13,000,000"}}]
["이민찬",9,{"v":1500000,"d":"1,500,000"},{"v":0.1,"d":"10%"},{"$f":"C14+C14*(D14+$C$18)","v":{"v":1740000,"d":"1,740,000"}},null,"3월",56,{"v":11200000,"d":"11,200,000"}]
["가영수",10,{"v":2000000,"d":"2,000,000"},{"v":0.12,"d":"12%"},{"v":2360000,"d":"2,360,000"},null,"4월",76,{"v":15200000,"d":"15,200,000"}]
["류민완",8,{"v":2200000,"d":"2,200,000"},{"v":0.1,"d":"10%"},{"v":2552000,"d":"2,552,000"},null,"5월",56,{"v":11200000,"d":"11,200,000"}]
["강술래",4,{"v":1300000,"d":"1,300,000"},{"v":0.07,"d":"7%"},{"v":1469000,"d":"1,469,000"},null,"6월",85,{"v":17000000,"d":"17,000,000"}]
["추가 상여율",null,{"v":0.06,"d":"6%"}]
[{"$nulls":6},"단가","할인율"]
["[표5] ","도서 포인트 관리",{"$nulls":4},250000,{"v":0.2,"d":"20%"}]
["대출자","대출권수","연체권수","포인트 총계"]
["이원섭",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.609999999999999]
["안유경",15,2,1.5299999999999998]
["강흥석",78,7,8.16]
["조용욱",56,5,5.86]
["대출포인트",null,{"v":0.11,"d":"11%"}]
["연체포인트",null,{"v":-0.06,"d":"-6%"}]

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

{"sheet":"날짜1(예제)","index":3,"n_rows":28,"n_cols":6,"rows_kept":28,"merged":[[7,4,9,4]]}
["오늘의 날짜",{"$f":"TODAY()","v":"2016-11-28"},null,"=today()","날짜만"]
["오늘의 날짜와 시간",{"$f":"NOW()","v":"2016-11-28T19:10:44.770"},null,"=now()","날짜와 시간을 동시에"]
[]
["표시 부분","결과"]
["연도(YEAR)",{"$f":"YEAR(B1)","v":2016},null,"=YEAR(B1)","연추출. ()안에 반드시 날짜값이 있어야함","=YEAR(TODAY())"]
["월(MONTH)",{"$f":"MONTH(B1)","v":11},null,"=MONTH(B1)","월추출","식의 우선순위 : "]
["일(DAY)",{"$f":"DAY(B1)","v":28},null,"=DAY(B1)","일추출","안에서 밖으로 실행"]
["시(HOUR)",{"$f":"HOUR(B2)","v":19},null,null,"시간이 있는 NOW()이용. TODAY는 불가","결론:"]
["분(MINUTE)",{"$nulls":4},"밖에 있는 함수는 "]
["초(SECOND)",{"$nulls":4},"안에 있는 식의 결과만 본다"]
["날짜(DATE)",{"$f":"DATE(B5,B6,B7)","v":"2016-11-28"},null,{"$f":"DATE(YEAR(TODAY()),MONTH(TODAY()),DAY(TODAY()))","v":"2016-11-28"},"날짜계산할 때 (연, 월)","따라서 중첩함수 가능"]
["시간(TIME)",{"$nulls":3},"시간 계산할 때 (시, 분)"]
["요일(WEEKDAY)",{"$f":"CHOOSE(WEEKDAY(B11,2),\"월\",\"화\",\"수\",\"목\",\"금\",\"토\",\"일\")","v":"월"},{"$f":"CHOOSE(WEEKDAY(B11,1),\"일\",\"월\",\"화\",\"수\",\"목\",\"금\",\"토\",\"일\")","v":"월"}]
["요일(WEEKDAY)-서식"]
["일련번호(DATEVALUE)"]
[]
[]
["*DATE함수의 쓰임"]
["공사시작","공사기간(개월)","완공일"]
["2011-11-11",27,{"$f":"DATE(YEAR(A20),MONTH(A20)+B20,DAY(A20))","v":"2014-02-11"}]
[null,null,{"$f":"EDATE(A20,B20)","v":"2014-02-11"}]
[]
[]
[]
[null,"2016-11-01","2016-11-24","2016-11-25"]
["DAYS360(시작날짜,끝날짜)","일수 차를 구할 때이용",{"$f":"DAYS360(C25,D25)","v":1},{"$f":"D25-C25","v":1}]
["EDATE","N달 전/후의 날짜",{"$f":"EDATE(C25,1)","v":"2016-12-24"}]
["WORKDAY","주말을 제외한 N일 전/후의 날짜",{"$f":"WORKDAY(B25,10)","v":"2016-11-15"}]

{"sheet":"날짜1(결과)","index":4,"n_rows":15,"n_cols":2,"rows_kept":15}
["오늘의 날짜",{"$f":"TODAY()","v":"2016-11-28"}]
["오늘의 날짜와 시간",{"$f":"NOW()","v":"2016-11-28T19:10:44.770"}]
[]
["표시 부분","결과"]
["연도(YEAR)",{"$f":"YEAR(B2)","v":2016}]
["월(MONTH)",{"$f":"MONTH(B2)","v":11}]
["일(DAY)",{"$f":"DAY(B2)","v":28}]
["시(HOUR)",{"$f":"HOUR(B2)","v":19}]
["분(MINUTE)",{"$f":"MINUTE(B2)","v":10}]
["초(SECOND)",{"$f":"SECOND(B2)","v":45}]
["날짜(DATE)",{"$f":"DATE(B5,B6,B7)","v":"2016-11-28"}]
["시간(TIME)",{"$f":"TIME(B8,B9,B10)","v":"19:10:45"}]
["요일(WEEKDAY)",{"$f":"WEEKDAY(B2)","v":2}]
["요일(WEEKDAY)-서식",{"$f":"WEEKDAY(B2)","v":2}]
["일련번호(DATEVALUE)",{"$f":"DATEVALUE(\"2017-8-15\")","v":42962}]

{"sheet":"날짜2(예제)","index":5,"n_rows":26,"n_cols":5,"rows_kept":26}
[]
["[표1]"]
["구입일","구입품목","가격","결제일1(EDATE)","결제일2(EOMONTH)"]
["2017-05-01","침구청소기",{"v":170000,"d":"170,000"}]
["2017-05-15","냉장고",{"v":1200000,"d":"1,200,000"}]
["2017-06-02","청소기",{"v":500000,"d":"500,000"}]
["2017-06-20","제습기",{"v":380000,"d":"380,000"}]
["2017-07-05","에어컨",{"v":1500000,"d":"1,500,000"}]
["2017-07-18","선풍기",{"v":120000,"d":"120,000"}]
[]
["[표2]"]
["주문일","배송기간","배송 예정일"]
["2017-10-09",3]
["2017-10-20",2]
["2017-10-31",5]
["2017-11-05",3]
["2017-11-20",4]
[]
["[표3]"]
["대출일","상환일","대출 기간"]
["2017-01-05","2017-05-03"]
["2017-01-20","2017-06-20"]
["2017-02-12","2017-08-14"]
["2017-02-25","2017-09-20"]
["2017-03-05","2017-10-30"]
["2017-03-18","2017-12-30"]

{"sheet":"날짜2(결과)","index":6,"n_rows":26,"n_cols":5,"rows_kept":26}
[]
["[표1]"]
["구입일","구입품목","가격","결제일1(EDATE)","결제일2(EOMONTH)"]
["2017-05-01","침구청소기",{"v":170000,"d":"170,000"},{"$f":"EDATE(A4,3)","v":"2017-08-01"},{"$f":"EOMONTH(A4,3)","v":"2017-08-31"}]
["2017-05-15","냉장고",{"v":1200000,"d":"1,200,000"},{"$f":"EDATE(A5,3)","v":"2017-08-15"},{"$f":"EOMONTH(A5,3)","v":"2017-08-31"}]
["2017-06-02","청소기",{"v":500000,"d":"500,000"},"2017-09-02","2017-09-30"]
["2017-06-20","제습기",{"v":380000,"d":"380,000"},"2017-09-20","2017-09-30"]
["2017-07-05","에어컨",{"v":1500000,"d":"1,500,000"},"2017-10-05","2017-10-31"]
["2017-07-18","선풍기",{"v":120000,"d":"120,000"},"2017-10-18","2017-10-31"]
[]
["[표2]"]
["주문일","배송기간","배송 예정일"]
["2017-10-09",3,{"$f":"WORKDAY(A13,B13)","v":"2017-10-12"}]
["2017-10-20",2,{"$f":"WORKDAY(A14,B14)","v":"2017-10-24"}]
["2017-10-31",5,"2017-11-07"]
["2017-11-05",3,"2017-11-08"]
["2017-11-20",4,"2017-11-24"]
[]
["[표3]"]
["대출일","상환일","대출 기간"]
["2017-01-05","2017-05-03",{"$f":"YEARFRAC(A21,B21,1)","v":{"v":0.3232876712328767,"d":"32%"}}]
["2017-01-20","2017-06-20",{"$f":"YEARFRAC(A22,B22,1)","v":{"v":0.4136986301369863,"d":"41%"}}]
["2017-02-12","2017-08-14",{"v":0.5013698630136987,"d":"50%"}]
["2017-02-25","2017-09-20",{"v":0.5671232876712329,"d":"57%"}]
["2017-03-05","2017-10-30",{"v":0.6547945205479452,"d":"65%"}]
["2017-03-18","2017-12-30",{"v":0.7863013698630137,"d":"79%"}]

{"sheet":"논리(예제)","index":7,"n_rows":45,"n_cols":10,"rows_kept":45,"merged":[[23,0,24,0],[23,1,24,1],[23,2,23,3]]}
["[표1]",{"$nulls":4},"[표2]"]
["수험번호","이름","점수","평가",null,"수험번호","성명","최종성적","부서배치"]
[1001,"이나영",78,{"$f":"IF(C3>=90,\"A\",IF(C3>=80,\"B\",IF(C3>=70,\"C\",IF(C3>=60,\"D\",\"F\"))))","v":"C"},null,1001,"오나라",95,{"$f":"H3>=90","v":true}]
[1002,"추영조",65,{"$f":"IF(C4>=90,\"A\",IF(C4>=80,\"B\",IF(C4>=70,\"C\",IF(C4>=60,\"D\",\"F\"))))","v":"D"},null,1002,"유채화",74]
[1003,"탁수민",80,"B",null,1003,"김사랑",85]
[1004,"강전한",90,"A",null,1004,"한나리",88]
[1005,"김이중",52,"F",null,1005,"조절해",60]
[1006,"전대철",42,"F",null,1006,"사오정",92]
[1007,"사은봉",80,"B",null,1007,"금나라",72]
[1008,"노영철",69,"D"]
[1009,"면도영",75,"C"]
[]
["[표3]",{"$nulls":4},"[표4]"]
["직원코드","근무년수","판매부수","승진여부",null,"연수번호","성명","컴일","시트","평가"]
["1-K001",10,{"v":100000,"d":"100,000"},{"$f":"IF(AND(B15>=15,C15>=100000),\"승진\",\" \")","v":" "},null,2002001,"강구석",77,86,{"$f":"IF(OR(H15>=85,I15>=85),\"이수\",\" \")","v":"이수"}]
["1-K002",17,{"v":150000,"d":"150,000"},{"$f":"IF(AND(B16>=15,C16>=100000),\"승진\",\" \")","v":"승진"},null,2002002,"이지나",56,100,{"$f":"IF(OR(H16>=85,I16>=85),\"이수\",\" \")","v":"이수"}]
["1-K003",15,{"v":50000,"d":"50,000"}," ",null,2002003,"남인성",76,84," "]
["1-K004",25,{"v":65000,"d":"65,000"}," ",null,2002004,"오지혜",56,78," "]
["2-K001",15,{"v":134000,"d":"134,000"},"승진",null,2002005,"류민철",88,96,"이수"]
["2-K002",9,{"v":74000,"d":"74,000"}," ",null,2002006,"김동석",78,56," "]
["2-K003",12,{"v":95000,"d":"95,000"}," ",null,2002007,"사인구",67,78," "]
[{"$nulls":5},2002008,"푸영아",100,86,"이수"]
["[표5]",{"$nulls":4},2002009,"한남석",42,56," "]
["성명","기본급","가족수당"]
[null,null,"인원","금액"]
["이세민",{"v":1850000,"d":"1,850,000"},2,{"$f":"IFERROR(C26*100000,\"입력오류\")","v":{"v":200000,"d":"200,000"}}]
["이태건",{"v":1570000,"d":"1,570,000"},1,{"$f":"IFERROR(C27*100000,\"입력오류\")","v":{"v":100000,"d":"100,000"}}]
["오유진",{"v":1330000,"d":"1,330,000"},2,{"v":200000,"d":"200,000"}]
["김주원",{"v":1420000,"d":"1,420,000"},2,{"v":200000,"d":"200,000"}]
["김슬기",{"v":1100000,"d":"1,100,000"},"없음","입력오류"]
["황지호",{"v":1390000,"d":"1,390,000"},1,{"v":100000,"d":"100,000"}]
["임효진",{"v":1240000,"d":"1,240,000"},"없음","입력오류"]
["김종욱",{"v":1480000,"d":"1,480,000"},2,{"v":200000,"d":"200,000"}]
["최혁재",{"v":1350000,"d":"1,350,000"},0,0]
[]
[]
[]
[]
[]
[]
["A",">","B"]
["대상값",null,"제시값"]
[true,null,false]
["참",null,"거짓"]
[1,null,0,"2진수"]

{"sheet":"논리(결과)","index":8,"n_rows":34,"n_cols":10,"rows_kept":34,"merged":[[23,0,24,0],[23,1,24,1],[23,2,23,3]]}
["[표1]",{"$nulls":4},"[표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]",{"$nulls":4},"[표4]"]
["직원코드","근무년수","판매부수","승진여부",null,"연수번호","성명","컴일","시트","평가"]
["1-K001",10,{"v":100000,"d":"100,000"},{"$f":"IF(AND(B15>=15,C15>=100000),\"승진\",\" \")","v":" "},null,2002001,"강구석",77,86,{"$f":"IF(OR(H15>=85,I15>=85),\"이수\",\"\")","v":"이수"}]
["1-K002",17,{"v":150000,"d":"150,000"},{"$f":"IF(AND(B16>=15,C16>=100000),\"승진\",\" \")","v":"승진"},null,2002002,"이지나",56,100,{"$f":"IF(OR(H16>=85,I16>=85),\"이수\",\"\")","v":"이수"}]
["1-K003",15,{"v":50000,"d":"50,000"}," ",null,2002003,"남인성",76,84,""]
["1-K004",25,{"v":65000,"d":"65,000"}," ",null,2002004,"오지혜",56,78,""]
["2-K001",15,{"v":134000,"d":"134,000"},"승진",null,2002005,"류민철",88,96,"이수"]
["2-K002",9,{"v":74000,"d":"74,000"}," ",null,2002006,"김동석",78,56,""]
["2-K003",12,{"v":95000,"d":"95,000"}," ",null,2002007,"사인구",67,78,""]
[{"$nulls":5},2002008,"푸영아",100,86,"이수"]
["[표5]",{"$nulls":4},2002009,"한남석",42,56,""]
["성명","기본급","가족수당"]
[null,null,"인원","금액"]
["이세민",{"v":1850000,"d":"1,850,000"},2,{"$f":"IFERROR(C26*100000,\"입력오류\")","v":{"v":200000,"d":"200,000"}}]
["이태건",{"v":1570000,"d":"1,570,000"},1,{"$f":"IFERROR(C27*100000,\"입력오류\")","v":{"v":100000,"d":"100,000"}}]
["오유진",{"v":1330000,"d":"1,330,000"},2,{"v":200000,"d":"200,000"}]
["김주원",{"v":1420000,"d":"1,420,000"},2,{"v":200000,"d":"200,000"}]
["김슬기",{"v":1100000,"d":"1,100,000"},"없음","입력오류"]
["황지호",{"v":1390000,"d":"1,390,000"},1,{"v":100000,"d":"100,000"}]
["임효진",{"v":1240000,"d":"1,240,000"},"없음","입력오류"]
["김종욱",{"v":1480000,"d":"1,480,000"},2,{"v":200000,"d":"200,000"}]
["최혁재",{"v":1350000,"d":"1,350,000"},0,0]

{"sheet":"데이터베이스1(예제)","index":9,"n_rows":21,"n_cols":9,"rows_kept":21}
[]
[null,"고객ID","성명","고객구분","가입일","거래횟수","총거래금액",null,"고객구분"]
[null,"T001","우병배","일반","2017-05-06",12,{"v":680000,"d":"680,000"}]
[null,"T002","표명규","골드","2017-07-15",5,{"v":520000,"d":"520,000"}]
[null,"T003","손미선","우대","2017-07-21",18,{"v":165000,"d":"165,000"}]
[null,"T004","윤연숙","우대","2017-08-20",24,{"v":438000,"d":"438,000"}]
[null,"T005","박찬우","골드","2017-08-21",13,{"v":527000,"d":"527,000"}]
[null,"T006","안순일","일반","2017-09-15",15,{"v":350000,"d":"350,000"}]
[null,"T007","이경희","일반","2017-09-18",9,{"v":127000,"d":"127,000"}]
[null,"T008","황명길","골드","2017-09-25",15,{"v":628000,"d":"628,000"}]
[null,"T009","박연이","우대","2017-10-05",10,{"v":715000,"d":"715,000"}]
[null,"T010","김청수","일반","2017-10-12",24,{"v":357000,"d":"357,000"}]
[null,"T011","임순정","골드","2017-10-19",21,{"v":495000,"d":"495,000"}]
[{"$nulls":6},{"$f":"DAVERAGE(B2:G13,G2,I2:I3)","v":454727.2727272727}]
[]
[null,"고객구분","총거래횟수","평균금액","최고금액","최소금액","회원수"]
[null,"골드",{"$f":"DSUM(B2:G13,5,B16:B17)","v":54},{"$f":"DAVERAGE(B2:G13,6,B16:B17)","v":{"v":542500,"d":"542,500"}},{"$f":"DMAX(B2:G13,G2,B16:B17)","v":{"v":628000,"d":"628,000"}},{"$f":"DMIN(B2:G13,G2,B16:B17)","v":{"v":495000,"d":"495,000"}},{"$f":"DCOUNT(B2:G13,F2,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":"골드"},"2017-08-21",13,{"v":527000,"d":"₩527,000"}]

{"sheet":"데이터베이스1(결과)","index":10,"n_rows":21,"n_cols":7,"rows_kept":21}
[]
[null,"고객ID","성명","고객구분","가입일","거래횟수","총거래금액"]
[null,"T001","우병배","일반","2017-05-06",12,{"v":680000,"d":"680,000"}]
[null,"T002","표명규","골드","2017-07-15",5,{"v":520000,"d":"520,000"}]
[null,"T003","손미선","우대","2017-07-21",18,{"v":165000,"d":"165,000"}]
[null,"T004","윤연숙","우대","2017-08-20",24,{"v":438000,"d":"438,000"}]
[null,"T005","박찬우","골드","2017-08-21",13,{"v":527000,"d":"527,000"}]
[null,"T006","안순일","일반","2017-09-15",15,{"v":350000,"d":"350,000"}]
[null,"T007","이경희","일반","2017-09-18",9,{"v":127000,"d":"127,000"}]
[null,"T008","황명길","골드","2017-09-25",15,{"v":628000,"d":"628,000"}]
[null,"T009","박연이","우대","2017-10-05",10,{"v":715000,"d":"715,000"}]
[null,"T010","김청수","일반","2017-10-12",24,{"v":357000,"d":"357,000"}]
[null,"T011","임순정","골드","2017-10-19",21,{"v":495000,"d":"495,000"}]
[]
[]
[null,"고객구분","총거래횟수","평균금액","최고금액","최소금액","회원수"]
[null,"골드",{"$f":"DSUM(B2:G13,5,B16:B17)","v":54},{"$f":"DAVERAGE(B2:G13,6,B16:B17)","v":{"v":542500,"d":"542,500"}},{"$f":"DMAX(B2:G13,6,B16:B17)","v":{"v":628000,"d":"628,000"}},{"$f":"DMIN(B2:G13,6,B16:B17)","v":{"v":495000,"d":"495,000"}},{"$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":"골드"},{"$f":"DGET($B$2:$G$13,E2,$B$20:$B$21)","v":"2017-08-21"},{"$f":"DGET($B$2:$G$13,F2,$B$20:$B$21)","v":13},{"$f":"DGET($B$2:$G$13,G2,$B$20:$B$21)","v":{"v":527000,"d":"527,000"}}]

{"sheet":"데이터베이스2(예제)","index":11,"n_rows":38,"n_cols":9,"rows_kept":38,"merged":[[11,0,11,2],[11,5,11,7],[22,5,22,6],[23,5,23,6],[35,2,35,3],[35,7,35,8],[36,2,36,3],[36,7,36,8]]}
["[표1]",{"$nulls":4},"[표2]"]
["성명","응시구분","1차","2차",null,"대리점","단가","출고수량","판매금액"]
["한가람","P-1",79,97,null,"금성물산",{"v":1673,"d":"1,673"},40,{"$f":"G3*H3","v":{"v":66920,"d":"66,920"}}]
["김은철","P-2",77,89,null,"우주상사",{"v":1506,"d":"1,506"},58,{"v":87348,"d":"87,348"}]
["고사리","P-1",56,76,null,"신안공업",{"v":1126,"d":"1,126"},91,{"v":102466,"d":"102,466"}]
["박은별","P-2",88,80,null,"삼성상사",{"v":2953,"d":"2,953"},99,{"v":292347,"d":"292,347"}]
["성준서","P-1",88,93,null,"금성물산",{"v":1423,"d":"1,423"},54,{"v":76842,"d":"76,842"}]
["이성연","P-2",91,67,null,"신안공업",{"v":1338,"d":"1,338"},40,{"v":53520,"d":"53,520"}]
["박한나","P-1",85,56,null,"금성물산",{"v":2310,"d":"2,310"},73,{"v":168630,"d":"168,630"}]
["이미리","P-1",76,89,null,"종로상사",{"v":1937,"d":"1,937"},90,{"v":174330,"d":"174,330"}]
[]
["P-1의 1차 평균",null,null,{"$f":"DAVERAGE(A2:D10,C2,B2:B3)","v":76.8},null,"금성물산 판매금액 합계",null,null,{"$f":"DSUM(F2:I10,I2,F2:F3)","v":{"v":312392,"d":"312,392"}}]
[]
["[표3]",{"$nulls":4},"[표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:$D$21,C15,$A$23:$A$24)","v":834},{"$f":"DMAX($A$15:$D$21,D15,$A$23:$A$24)","v":513},null,null,{"$f":"DCOUNT(F15:I21,H15,H23:I24)","v":2},null,"대한",{"$f":"I16>=5","v":true}]
[]
["[표5]",{"$nulls":4},"[표6]"]
["학과","학년","성명","평가점수",null,"직원코드","1사분기","2사분기","상반기합계"]
["디자인",1,"고승수",465,null,"1-J001",{"v":92733,"d":"92,733"},{"v":46573,"d":"46,573"},{"$f":"G28+H28","v":{"v":139306,"d":"139,306"}}]
["미디어",2,"구만리",604,null,"1-J002",{"v":66191,"d":"66,191"},{"v":60400,"d":"60,400"},{"v":126591,"d":"126,591"}]
["미디어",3,"노상식",383,null,"1-J003",{"v":14809,"d":"14,809"},{"v":13827,"d":"13,827"},{"v":28636,"d":"28,636"}]
["디자인",2,"나잘난",465,null,"1-J004",{"v":51382,"d":"51,382"},{"v":46573,"d":"46,573"},{"v":97955,"d":"97,955"}]
["미디어",1,"마고수",382,null,"2-J001",{"v":19663,"d":"19,663"},{"v":17382,"d":"17,382"},{"v":37045,"d":"37,045"}]
["미디어",2,"박흥철",391,null,"2-J002",{"v":22053,"d":"22,053"},{"v":49102,"d":"49,102"},{"v":71155,"d":"71,155"}]
["디자인",3,"사수해",572,null,"2-J003",{"v":23900,"d":"23,900"},{"v":17206,"d":"17,206"},{"v":41106,"d":"41,106"}]
[]
["평가점수","학년","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,I27,F36:G37)","v":{"v":169110,"d":"169,110"}}]
[null,{"$f":"2","v":2}]

{"sheet":"데이터베이스2(결과)","index":12,"n_rows":38,"n_cols":9,"rows_kept":38,"merged":[[11,0,11,2],[11,5,11,7],[22,5,22,6],[23,5,23,6],[35,2,35,3],[35,7,35,8],[36,2,36,3],[36,7,36,8]]}
["[표1]",{"$nulls":4},"[표2]"]
["성명","응시구분","1차","2차",null,"대리점","단가","출고수량","판매금액"]
["한가람","P-1",79,97,null,"금성물산",{"v":1673,"d":"1,673"},40,{"$f":"G3*H3","v":{"v":66920,"d":"66,920"}}]
["김은철","P-2",77,89,null,"우주상사",{"v":1506,"d":"1,506"},58,{"v":87348,"d":"87,348"}]
["고사리","P-1",56,76,null,"신안공업",{"v":1126,"d":"1,126"},91,{"v":102466,"d":"102,466"}]
["박은별","P-2",88,80,null,"삼성상사",{"v":2953,"d":"2,953"},99,{"v":292347,"d":"292,347"}]
["성준서","P-1",88,93,null,"금성물산",{"v":1423,"d":"1,423"},54,{"v":76842,"d":"76,842"}]
["이성연","P-2",91,67,null,"신안공업",{"v":1338,"d":"1,338"},40,{"v":53520,"d":"53,520"}]
["박한나","P-1",85,56,null,"금성물산",{"v":2310,"d":"2,310"},73,{"v":168630,"d":"168,630"}]
["이미리","P-1",76,89,null,"종로상사",{"v":1937,"d":"1,937"},90,{"v":174330,"d":"174,330"}]
[]
["P-1의 1차 평균",null,null,{"$f":"DAVERAGE(A2:D10,C2,B2:B3)","v":76.8},null,"금성물산 판매금액 합계",null,null,{"$f":"DSUM(F2:I10,I2,F2:F3)","v":{"v":312392,"d":"312,392"}}]
[]
["[표3]",{"$nulls":4},"[표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:$D$21,C15,$A$23:$A$24)","v":834},{"$f":"DMAX($A$15:$D$21,D15,$A$23:$A$24)","v":513},null,null,{"$f":"DCOUNT(F15:I21,H15,H23:I24)","v":2},null,"대한",">=5"]
[]
["[표5]",{"$nulls":4},"[표6]"]
["학과","학년","성명","평가점수",null,"직원코드","1사분기","2사분기","상반기합계"]
["디자인",1,"고승수",465,null,"1-J001",{"v":92733,"d":"92,733"},{"v":46573,"d":"46,573"},{"$f":"G28+H28","v":{"v":139306,"d":"139,306"}}]
["미디어",2,"구만리",604,null,"1-J002",{"v":66191,"d":"66,191"},{"v":60400,"d":"60,400"},{"v":126591,"d":"126,591"}]
["미디어",3,"노상식",383,null,"1-J003",{"v":14809,"d":"14,809"},{"v":13827,"d":"13,827"},{"v":28636,"d":"28,636"}]
["디자인",2,"나잘난",465,null,"1-J004",{"v":51382,"d":"51,382"},{"v":46573,"d":"46,573"},{"v":97955,"d":"97,955"}]
["미디어",1,"마고수",382,null,"2-J001",{"v":19663,"d":"19,663"},{"v":17382,"d":"17,382"},{"v":37045,"d":"37,045"}]
["미디어",2,"박흥철",391,null,"2-J002",{"v":22053,"d":"22,053"},{"v":49102,"d":"49,102"},{"v":71155,"d":"71,155"}]
["디자인",3,"사수해",572,null,"2-J003",{"v":23900,"d":"23,900"},{"v":17206,"d":"17,206"},{"v":41106,"d":"41,106"}]
[]
["평가점수","학년","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,I27,F36:G37)","v":{"v":169110,"d":"169,110"}}]
[null,2]

{"sheet":"데이터베이스3(예제)","index":13,"n_rows":16,"n_cols":7,"rows_kept":16,"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":14,"n_rows":16,"n_cols":7,"rows_kept":16,"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":{"v":91000,"d":"91,000"}},{"$f":"DPRODUCT($C$2:$G$12,E2,$C$15:$C$16)","v":{"v":266600,"d":"266,600"}},{"v":243000,"d":"243,000"},{"v":168000,"d":"168,000"}]

{"sheet":"문자열1(예제)","index":15,"n_rows":38,"n_cols":15,"rows_kept":38,"merged":[[9,13,12,13]]}
[]
[null,"성명","주민등록번호","정확도","생년월일","성별","나이","나이지수","나이2","끝자리 사은품","게이지방식"]
[null,"심행래","650218-1584623",{"$f":"IF(LEN(C3)=14,\"\",\"틀림\")","v":""},{"$f":"DATE(LEFT(C3,2)+IF(MID(C3,8,1)*1<3,1900,2000),MID(C3,3,2),MID(C3,5,2))","v":"1965-02-18"},{"$f":"IF(OR(MID(C3,8,1)=\"1\",MID(C3,8,1)=\"3\"),\"남\",\"여\")","v":"남"},{"$f":"YEAR(TODAY())-LEFT(C3,2)-1900","v":51},{"$f":"REPT(\"★\",QUOTIENT(G3,10))","v":"★★★★★"},{"$f":"YEAR(TODAY())-YEAR(E3)","v":51},{"$f":"IF(RIGHT(G3,1)=\"0\",\"꽝! 다음 기회에\",REPT(\"♥\",RIGHT(G3,1)))","v":"♥"},{"$f":"REPT(\"♥\",RIGHT(G3,1))&REPT(\"♡\",9-RIGHT(G3,1))","v":"♥♡♡♡♡♡♡♡♡"},null,"조건의 3요소"]
[null,"김봉현","601204-1864523",{"$f":"IF(LEN(C4)=14,\"\",\"틀림\")","v":""},{"$f":"DATE(LEFT(C4,2)+IF(MID(C4,8,1)<\"3\",\"1900\",\"2000\"),MID(C4,3,2),MID(C4,5,2))","v":"1960-12-04"},{"$f":"IF(OR(MID(C4,8,1)=\"1\",MID(C4,8,1)=\"3\"),\"남\",\"여\")","v":"남"},{"$f":"YEAR(TODAY())-LEFT(C4,2)-1900","v":56},{"$f":"REPT(\"★\",QUOTIENT(G4,10))","v":"★★★★★"},{"$f":"YEAR(TODAY())-YEAR(E4)","v":56},{"$f":"IF(RIGHT(G4,1)=\"0\",\"꽝! 다음 기회에\",REPT(\"♥\",RIGHT(G4,1)))","v":"♥♥♥♥♥♥"},{"$f":"REPT(\"♥\",RIGHT(G4,1))&REPT(\"♡\",9-RIGHT(G4,1))","v":"♥♥♥♥♥♥♡♡♡"},null,"대상값, 기호, 제시값"]
[null,"이찬호","620718-1845237","","1962-07-18","남",{"$f":"YEAR(TODAY())-LEFT(C5,2)-1900","v":54},"★★★★★",54,"♥♥♥♥","♥♥♥♥♡♡♡♡♡",null,"숫자","문자열추출"]
[null,"박이슈","720124-2356427","","1972-01-24","여",44,"★★★★",44,"♥♥♥♥","♥♥♥♥♡♡♡♡♡",null,1,624879135,624879135]
[null,"이장군","730512-1845615","","1973-05-12","남",43,"★★★★",43,"♥♥♥","♥♥♥♡♡♡♡♡♡",null,2]
[null,"황건이","760314-1875234","","1976-03-14","남",40,"★★★★",40,"꽝! 다음 기회에","♡♡♡♡♡♡♡♡♡",null,{"$f":"SUM(M6:M7)=3","v":true},{"$f":"MID(N6,5,1)=7","v":false}]
[null,"이율용","660217-2485628","","1966-02-17","여",50,"★★★★★",50,"꽝! 다음 기회에","♡♡♡♡♡♡♡♡♡",null,null,"=MID(J6,5,1)=7","=MID(J6,5,1)=\"7\""]
[null,"장보가","710523-2784652","","1971-05-23","여",45,"★★★★",45,"♥♥♥♥♥","♥♥♥♥♥♡♡♡♡",null,"따라서","우리가 구하는 모든 결과는 무조건 문자!"]
[null,"서정수","640819-1864521","","1964-08-19","남",52,"★★★★★",52,"♥♥","♥♥♡♡♡♡♡♡♡",null,"LEFT"]
[null,"왕순원","610126-2845967","","1961-01-26","여",55,"★★★★★",55,"♥♥♥♥♥","♥♥♥♥♥♡♡♡♡",null,"MID"]
[null,"박목일","120630-3875241","","2012-06-30","남",{"$f":"YEAR(TODAY())-LEFT(C13,2)-IF(MID(C13,8,1)*1<3,1900,2000)","v":4},"",4,"♥♥♥♥","♥♥♥♥♡♡♡♡♡",null,"RIGHT"]
[]
[]
[]
[null,null,"봉준쌤은 천재입니다.",null,"=LEFT(C17,3)",{"$nulls":4},"DATE(LEFT(C4,2)+IF(MID(C3,8,1)<3,\"0\",\"100\"),MID(C4,3,2),MID(C4,5,2))"]
[]
[]
[null,"2016-11-25",{"$f":"LEFT(C17,3)","v":"봉준쌤"},null,15485]
[null,{"$f":"LEN(C17)","v":11},"=LEN(C17)"]
[null,{"$f":"LEFT(E20,1)*1","v":1},"=LEFT(D20,1)*1"]
[null,{"$f":"VALUE(LEFT(E20,1))","v":1},"=VALUE(LEFT(D20,1))"]
[]
[null,{"$f":"TEXT(B20,\"YYYY년 M월 D일\")","v":"2016년 11월 25일"},"=TEXT(B20,\"YYYY년 M월 D일\")"]
[null,{"$f":"TEXT(E20,\"0원\")","v":"15485원"},"=TEXT(D20,\"0원\")"]
[null,{"$f":"TEXT(E20,\"#,##0원\")","v":"15,485원"},"=TEXT(D20,\"#,##0원\")",null,"000을 쓰면 값이 없을 때에도 0 동원해서 3자리만큼 강제로 써넣게 됨. 따라서 #으로."]
[null,{"$f":"TEXT(E20,\"#,###,천원\")","v":"15천원"},"=TEXT(D20,\"#,###,천원\")",null,"반올림하여 천단위로"]
[]
[null,"최","봉",null,"준"]
[null,{"$f":"B30&C30&E30","v":"최봉준"},"=B30&C30&D30",null,"이어 붙일 때"]
[null,{"$f":"CONCATENATE(B30,C30,E30)","v":"최봉준"},"=CONCATENATE(B27,C27,D27)",null,"&연산자와 같은 역할"]
[]
[null,"최봉준"]
[null,{"$f":"FIND(\"봉\",B34)","v":2},"=FIND(\"봉\",B30)",null,"글자 단위로 찾음"]
[null,{"$f":"FINDB(\"봉\",B34)","v":3},"=FINDB(\"봉\",B30)",null,"바이트 단위로 찾음. 한글은 2바이트, 숫자는 1바이트임. 봉은 4바이트째지만 시작값을 찾으므로 3임"]
[]
[null,{"$f":"REPT(\"★\",5)","v":"★★★★★"},"=REPT(\"★\",5)"]

{"sheet":"문자열1(결과)","index":16,"n_rows":13,"n_cols":6,"rows_kept":13}
[]
[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":51}]
[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":56}]
[null,"이찬호","620718-1845237","1962-07-18","남자",54]
[null,"박이슈","720124-2356427","1972-01-24","여자",44]
[null,"이장군","730512-1845615","1973-05-12","남자",43]
[null,"황건이","760314-1875234","1976-03-14","남자",40]
[null,"이율용","660217-2485628","1966-02-17","여자",50]
[null,"장보가","710523-2784652","1971-05-23","여자",45]
[null,"서정수","640819-1864521","1964-08-19","남자",52]
[null,"왕순원","610126-2845967","1961-01-26","여자",55]
[null,"박목일","740630-1875241","1974-06-30","남자",42]

{"sheet":"문자열2(예제)","index":17,"n_rows":13,"n_cols":7,"rows_kept":13,"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":18,"n_rows":13,"n_cols":7,"rows_kept":13,"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":"문자열3(예제)","index":19,"n_rows":18,"n_cols":4,"rows_kept":18}
[null,null,"대소문자 구분O","대소문자 구분X"]
["찾을 문자열","대상","문자의 위치(FIND)","문자의 위치(SEARCH)"]
["EXCEL","Microsoft Excel 2007",{"$f":"FIND(\"E\",B3)","v":11}]
["POINT","MICROSOFT POWERPOINT 2007"]
["Soft","microsoft access 2007"]
["서초동","서울 서초구 서초동 1625-7"]
[55,"전화번호 : 02-555-3029"]
[]
[null,"똑같은 글자가 여러 개일 경우 맨 첫번째 것의 위치를 찾는다"]
[]
["이름","E-MAIL","ID","FIND함수"]
["보라돌이","bora123@naver.com",{"$f":"LEFT(B12,FIND(\"@\",B12)-1)","v":"bora123"},{"$f":"FIND(\"@\",B12)-1","v":7}]
["뚜비","ddoo345@nate.com",{"$f":"LEFT(B13,FIND(\"@\",B13)-1)","v":"ddoo345"},{"$f":"FIND(\"@\",B13)-1","v":7}]
["나나","nana1@gmail.com","nana1",5]
["뽀","bbo12345@hanmail.net","bbo12345",8]
[]
[]
[null,"하이퍼링크 제거하기"]

{"sheet":"문자열3(결과)","index":20,"n_rows":7,"n_cols":4,"rows_kept":7}
[]
["찾을 문자열","대상","문자의 위치(FIND)","문자의 위치(SEARCH)"]
["EXCEL","Microsoft Excel 2007",{"$f":"IFERROR(FIND(A3,B3),\"에러\")","v":"에러"},{"$f":"IFERROR(SEARCH(A3,B3),\"에러\")","v":11}]
["POINT","MICROSOFT POWERPOINT 2007",{"$f":"IFERROR(FIND(A4,B4),\"에러\")","v":16},{"$f":"IFERROR(SEARCH(A4,B4),\"에러\")","v":16}]
["Soft","microsoft access 2007","에러",6]
["서초동","서울 서초구 서초동 1625-7",8,8]
[55,"전화번호 : 02-555-3029",11,11]

{"sheet":"수학1(예제)","index":21,"n_rows":25,"n_cols":7,"rows_kept":25}
[]
["1)","숫자","짝수/홀수","MOD(값,나눌수)","나머지를 구함"]
[null,225,{"$f":"IF(MOD(B3,2)=1,\"홀\",\"짝\")","v":"홀"},"=MOD(B3,2)",null,1234.5678]
[null,300,{"$f":"IF(MOD(B4,2)=1,\"홀\",\"짝\")","v":"짝"},null,"=ROUND(F2,2)","=ROUNDUP(F2,2)","=ROUNDDOWN(F2,2)"]
[null,387,"홀",null,{"$f":"ROUND(F3,2)","v":1234.57},{"$f":"ROUNDUP(F3,-3)","v":2000},{"$f":"ROUNDDOWN(F3,2)","v":1234.56}]
[null,570,"짝",null,"쓰는 법","(값,자릿수)"]
[{"$nulls":3},"내림(버림)","반올림","올림","내림(버림)"]
["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.789,{"$f":"INT(B16)","v":456},{"$f":"ABS(B16)","v":456.789}]
[null,-456.789,{"$f":"INT(B17)","v":-457},{"$f":"ABS(B17)","v":456.789}]
[null,{"v":150,"d":"150.00"}]
[null,{"v":250,"d":"250.00"}]
[]
[]
[null,"저 값을 백의 자리에서 반올림하여 천의 자리까지 표시하시오."]
[null,"4567 -> 5000"]
[]
[null,"IF식을 세울 때 [조건식의 대상값->조건식->IF함수 완성] 순서로 진행하도록 연습하자 "]

{"sheet":"수학1(결과)","index":22,"n_rows":19,"n_cols":7,"rows_kept":19}
[]
["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.570000000001},{"$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.789,{"$f":"INT(B16)","v":456},{"$f":"ABS(B16)","v":456.789}]
[null,-456.789,{"$f":"INT(B17)","v":-457},{"$f":"ABS(B17)","v":456.789}]
[null,{"v":150,"d":"150.00"},150,150]
[null,{"v":250,"d":"250.00"},250,250]

{"sheet":"수학2(예제)","index":23,"n_rows":24,"n_cols":12,"rows_kept":24,"merged":[[17,7,17,9],[18,7,18,9]]}
[]
["• SQRT",25,{"$nulls":3},"• PI"]
[]
["• FACT",5,{"$nulls":3},"• 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]
[{"$nulls":3},{"$f":"SUMIF(C9:C15,\"=영업2부\",D9:D15)","v":1944}]
[]
[null,"부서","인원","1월합계","2월합계","3월합계",null,"1월~3월이 400 이상인 합계"]
[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,null,{"$f":"SUMIFS(G9:G15,D9:D15,D12,E9:E15,E12,F9:F15,F12)","v":1071},{"$nulls":3},2886]
[]
[]
[]
[]
[null,"김씨 중 영업 1부의 1월 합계",null,null,{"$f":"SUMIFS(D9:D15,B9:B15,\"김*\",C9:C15,\"영업1부\")","v":732}]

{"sheet":"수학2(결과)","index":24,"n_rows":19,"n_cols":8,"rows_kept":19,"merged":[[17,7,17,9],[18,7,18,9]]}
[]
["• SQRT",25,null,{"$f":"SQRT(B2)","v":5},null,"• PI",null,{"$f":"PI( )","v":3.141592653589793}]
[]
["• FACT",5,null,{"$f":"FACT(B4)","v":120},null,"• RAND",null,{"$f":"RAND( )","v":0.6805660441157542}]
[]
["• 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월~3월이 400 이상인 합계"]
[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},{"$f":"SUMIF($C$9:$C$15, $B$19,F9:F15)","v":1868},null,{"$f":"SUMIFS(G9:G15,D9:D15,\">=400\",E9:E15,\">=400\",F9:F15,\">=400\")","v":3793}]

{"sheet":"재무1(예제)","index":25,"n_rows":15,"n_cols":6,"rows_kept":15}
[null,"• FV 함수","미래가치 (적금)",null,"• PV 함수","현재가치 (연금)"]
[]
[null,"연이율",{"v":0.06,"d":"6%"},null,"연이율",{"v":0.08,"d":"8%"}]
[null,"기간",{"v":1,"d":"1년"},null,"수령 기간",{"v":30,"d":"30년"}]
[null,"월불입액",{"v":300000,"d":"300,000"},null,"매월 수령액",{"v":100000,"d":"100,000"}]
[]
[null,"만기금액",{"$f":"FV(C3/12,C4*12,-C5)","v":{"v":3700668.711869857,"d":"₩3,700,669"}},null,"연금의 현재가치",{"$f":"PV(F3/12,F4*12,-F5)","v":{"v":13628349.413396299,"d":"₩13,628,349"}}]
[]
[null,"• PMT 함수",null,null,"• PMT 함수"]
[]
[null,"연이율",{"v":0.075,"d":"7.5%"},null,"연이율",{"v":0.045,"d":"4.5%"}]
[null,"기간",{"v":3,"d":"3년"},null,"기간",{"v":5,"d":"5년"}]
[null,"대출금액",{"v":50000000,"d":"50,000,000"},null,"저축총액",{"v":50000000,"d":"50,000,000"}]
[]
[null,"월상환액",{"$f":"PMT(C11/12,C12*12,-C13)","v":{"v":1555310.9080328094,"d":"₩1,555,311"}},null,"월불입액"]

{"sheet":"재무1(결과)","index":26,"n_rows":15,"n_cols":6,"rows_kept":15}
[null,"• FV 함수",null,null,"• PV 함수"]
[]
[null,"연이율",{"v":0.06,"d":"6%"},null,"연이율",{"v":0.08,"d":"8%"}]
[null,"기간",{"v":1,"d":"1년"},null,"수령 기간",{"v":30,"d":"30년"}]
[null,"월불입액",{"v":300000,"d":"300,000"},null,"매월 수령액",{"v":100000,"d":"100,000"}]
[]
[null,"만기금액",{"$f":"FV(C3/12,C4*12,-C5)","v":{"v":3700668.711869857,"d":"₩3,700,669"}},null,"연금의 현재가치",{"$f":"PV(F3/12,F4*12,-F5)","v":{"v":13628349.413396299,"d":"₩13,628,349"}}]
[]
[null,"• PMT 함수",null,null,"• PMT 함수"]
[]
[null,"연이율",{"v":0.075,"d":"7.5%"},null,"연이율",{"v":0.045,"d":"4.5%"}]
[null,"기간",{"v":3,"d":"3년"},null,"기간",{"v":5,"d":"5년"}]
[null,"대출금액",{"v":50000000,"d":"50,000,000"},null,"저축총액",{"v":50000000,"d":"50,000,000"}]
[]
[null,"월상환액",{"$f":"PMT(C11/12,C12*12,-C13)","v":{"v":1555310.9080328094,"d":"₩1,555,311"}},null,"월불입액",{"$f":"PMT(F11/12,F12*12,0,-F13)","v":{"v":744650.9620758491,"d":"₩744,651"}}]

{"sheet":"재무2(예제)","index":27,"n_rows":27,"n_cols":6,"rows_kept":27}
[null,"•AMORDEGRC 함수",null,null,"• AMORLINC 함수"]
[]
[null,"자산취득가",{"v":33540000,"d":"33,540,000"},null,"자산취득가",{"v":33540000,"d":"33,540,000"}]
[null,"자산취득일","2017-08-19",null,"자산취득일","2017-08-19"]
[null,"첫째 회계 기간의 마지막 날짜","2017-12-31",null,"첫째 회계 기간의 마지막 날짜","2017-12-31"]
[null,"잔존 가치",{"v":28000000,"d":"28,000,000"},null,"잔존 가치",{"v":28000000,"d":"28,000,000"}]
[null,"기간",1,null,"기간",1]
[null,"감가상각률",{"v":0.15,"d":"15%"},null,"감가상각률",{"v":0.15,"d":"15%"}]
[null,"날짜 체계",1,null,"날짜 체계",1]
[null,"감가상각액(AMORDEGRC)",null,null,"감가상각액(AMORLINC)"]
[]
[null,"• DB 함수",null,null,"• DDB 함수"]
[]
[null,"자산취득가",{"v":33540000,"d":"33,540,000"},null,"비용",{"v":33540000,"d":"33,540,000"}]
[null,"잔존가치",{"v":15000000,"d":"15,000,000"},null,"잔존가치",{"v":15000000,"d":"15,000,000"}]
[null,"년수(수명)",10,null,"년수(수명)",10]
[null,"기간",3,null,"기간",3]
[null,"첫해의 사용 개월수",8,null,"잔액이 감소하는 비율"]
[null,"감가상각액(DB)",null,null,"감가상각액(DDB)"]
[]
[null,"• SLN 함수",null,null,"• SYD 함수"]
[]
[null,"비용",{"v":33540000,"d":"33,540,000"},null,"비용",{"v":33540000,"d":"33,540,000"}]
[null,"잔존가치",{"v":15000000,"d":"15,000,000"},null,"잔존가치",{"v":15000000,"d":"15,000,000"}]
[null,"년수",10,null,"년수",10]
[null,"감가상각액(SLN)",null,null,"년차",3]
[{"$nulls":4},"감가상각액(SYD)"]

{"sheet":"재무2(결과)","index":28,"n_rows":27,"n_cols":6,"rows_kept":27}
[null,"•AMORDEGRC 함수",null,null,"• AMORLINC 함수"]
[]
[null,"자산취득가",{"v":33540000,"d":"33,540,000"},null,"자산취득가",{"v":33540000,"d":"33,540,000"}]
[null,"자산취득일","2017-08-19",null,"자산취득일","2017-08-19"]
[null,"첫째 회계 기간의 마지막 날짜","2017-12-31",null,"첫째 회계 기간의 마지막 날짜","2017-12-31"]
[null,"잔존 가치",{"v":28000000,"d":"28,000,000"},null,"잔존 가치",{"v":28000000,"d":"28,000,000"}]
[null,"기간",1,null,"기간",1]
[null,"감가상각률",{"v":0.15,"d":"15%"},null,"감가상각률",{"v":0.15,"d":"15%"}]
[null,"날짜 체계",1,null,"날짜 체계",1]
[null,"감가상각액(AMORDEGRC)",{"$f":"AMORDEGRC(C3,C4,C5,C6,C7,C8,C9)","v":{"v":10845940,"d":"₩10,845,940"}},null,"감가상각액(AMORLINC)",{"$f":"AMORLINC(F3,F4,F5,F6,F7,F8,F9)","v":{"v":3693002.7397260275,"d":"₩3,693,003"}}]
[]
[null,"• DB 함수",null,null,"• DDB 함수"]
[]
[null,"자산취득가",{"v":33540000,"d":"33,540,000"},null,"비용",{"v":33540000,"d":"33,540,000"}]
[null,"잔존가치",{"v":15000000,"d":"15,000,000"},null,"잔존가치",{"v":15000000,"d":"15,000,000"}]
[null,"년수(수명)",10,null,"년수(수명)",10]
[null,"기간",3,null,"기간",3]
[null,"첫해의 사용 개월수",8,null,"잔액이 감소하는 비율"]
[null,"감가상각액(DB)",{"$f":"DB(C14,C15,C16,C17,C18)","v":{"v":2261356.97788,"d":"₩2,261,357"}},null,"감가상각액(DDB)",{"$f":"DDB(F14,F15,F16,F17)","v":{"v":4293120.000000001,"d":"₩4,293,120"}}]
[]
[null,"• SLN 함수",null,null,"• SYD 함수"]
[]
[null,"비용",{"v":33540000,"d":"33,540,000"},null,"비용",{"v":33540000,"d":"33,540,000"}]
[null,"잔존가치",{"v":15000000,"d":"15,000,000"},null,"잔존가치",{"v":15000000,"d":"15,000,000"}]
[null,"년수",10,null,"년수",10]
[null,"감가상각액(SLN)",{"$f":"SLN(C23,C24,C25)","v":{"v":1854000,"d":"₩1,854,000"}},null,"년차",3]
[{"$nulls":4},"감가상각액(SYD)",{"$f":"SYD(F23,F24,F25,F26)","v":{"v":2696727.272727273,"d":"₩2,696,727"}}]

{"sheet":"통계1(예제)","index":29,"n_rows":31,"n_cols":10,"rows_kept":31,"merged":[[18,0,18,1],[19,0,19,1]]}
["[표1] ","도서별 대출실적 합계",{"$nulls":4},"[표2] ","신입사원 면접결과"]
["구분","4월","5월","6월","평균",null,"성명","면접점수","순위","RANK(기준값,참조영역)"]
["총서",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]
[{"$nulls":6},"이소영",50,6]
["[표3]","직급별 연봉액",{"$nulls":4},"맹순자",46,7]
["성명","직급","연봉액",{"$nulls":3},"전기수",78,2]
["강희정","부장",{"v":36483516,"d":"36,483,516"}]
["김민수","사원",{"v":12991336,"d":"12,991,336"},null,"[표4]","영진고등학교 2학년 모의고사 성적 현황"]
["나인성","사원",{"v":14230019,"d":"14,230,019"},null,"성명","1차","2차","3차","점수변동폭"]
["민성진","대리",{"v":23122065,"d":"23,122,065"},null,"배수진",320,341,360,{"$f":"MAX(F14:H14)-MIN(F14:H14)","v":40},"=최고값-최소값"]
["박정아","과장",{"v":25390984,"d":"25,390,984"},null,"강경화",296,250,270,{"$f":"MAX(F15:H15)-MIN(F15:H15)","v":46}]
["서진이","사원",{"v":20859311,"d":"20,859,311"},null,"김순응",255,310,322,67]
["강창우","이사",{"v":78945600,"d":"78,945,600"},null,"고해진",361,308,375,67]
[{"$nulls":4},"박병철",291,342,332,51]
["3번째 큰값",null,{"$f":"LARGE(C11:C17,LEFT(A19,1))","v":{"v":25390984,"d":"25,390,984"}},null,"이선화",308,367,367,59]
["2번째 작은 값",null,{"$f":"SMALL(C11:C17,2)","v":{"v":14230019,"d":"14,230,019"}},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":{"v":27.573538039214334,"d":"27.57"}},{"$f":"STDEV(C24:C29)","v":{"v":18.601075237738275,"d":"18.60"}},{"v":5.4558836742242915,"d":"5.46"}]
["분산",{"$f":"VAR(B24:B29)","v":{"v":760.3,"d":"760.30"}},{"$f":"VAR(C24:C29)","v":{"v":346,"d":"346.00"}},{"v":29.766666666667152,"d":"29.77"}]

{"sheet":"통계1(결과)","index":30,"n_rows":31,"n_cols":9,"rows_kept":31,"merged":[[18,0,18,1],[19,0,19,1]]}
["[표1] ","도서별 대출실적 합계",{"$nulls":4},"[표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,{"$f":"ROUND(AVERAGE(B5:D5),1)","v":80.7},null,"강성수",63,"5등"]
["공학",100,98,101,{"$f":"ROUND(AVERAGE(B6:D6),1)","v":99.7},null,"김보견",45,"8등"]
["디자인",75,200,36,{"$f":"ROUND(AVERAGE(B7:D7),1)","v":103.7},null,"천수만",64,"4등"]
[{"$nulls":6},"이소영",50,"6등"]
["[표3]","직급별 연봉액",{"$nulls":4},"맹순자",46,"7등"]
["성명","직급","연봉액",{"$nulls":3},"전기수",78,"2등"]
["강희정","부장",{"v":36483516,"d":"36,483,516"}]
["김민수","사원",{"v":12991336,"d":"12,991,336"},null,"[표4]","영진고등학교 2학년 모의고사 성적 현황"]
["나인성","사원",{"v":14230019,"d":"14,230,019"},null,"성명","1차","2차","3차","점수변동폭"]
["민성진","대리",{"v":23122065,"d":"23,122,065"},null,"배수진",320,341,360,{"$f":"MAX(F14:H14)-MIN(F14:H14)","v":40}]
["박정아","과장",{"v":25390984,"d":"25,390,984"},null,"강경화",296,250,270,{"$f":"MAX(F15:H15)-MIN(F15:H15)","v":46}]
["서진이","사원",{"v":20859311,"d":"20,859,311"},null,"김순응",255,310,322,67]
["강창우","이사",{"v":78945600,"d":"78,945,600"},null,"고해진",361,308,375,67]
[{"$nulls":4},"박병철",291,342,332,51]
["2번째 큰값",null,{"$f":"LARGE(C11:C17,2)","v":{"v":36483516,"d":"36,483,516"}},null,"이선화",308,367,367,59]
["2번째 작은 값",null,{"$f":"SMALL(C11:C17,2)","v":{"v":14230019,"d":"14,230,019"}},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":{"v":27.573538039214334,"d":"27.57"}},{"$f":"STDEV(C24:C29)","v":{"v":18.601075237738275,"d":"18.60"}},{"$f":"STDEV(D24:D29)","v":{"v":5.4558836742242915,"d":"5.46"}}]
["분산",{"$f":"VAR(B24:B29)","v":{"v":760.3,"d":"760.30"}},{"$f":"VAR(C24:C29)","v":{"v":346,"d":"346.00"}},{"$f":"VAR(D24:D29)","v":{"v":29.766666666667152,"d":"29.77"}}]

{"sheet":"통계2(예제)","index":31,"n_rows":23,"n_cols":11,"rows_kept":23,"merged":[[3,8,3,9],[4,8,4,9],[12,6,12,10]]}
["영어 시험 점수",{"$nulls":5},"직원 근무 평가"]
[{"$nulls":5},"성명","입사일","근무점수"]
["이름","영어점수",null,"응시 인원수",null,"박정호","1994-06-06",73]
["강인월",90,{"$nulls":3},"신정희","1997-04-01",68,"70점대"]
["차영국",100,{"$nulls":3},"김용태","1999-05-06",98]
["이미자",85,{"$nulls":3},"김진영","1995-11-01",65]
["류장결",70,{"$nulls":3},"유현숙","1998-01-01",69]
["송태영",95,{"$nulls":3},"최정렬","1998-06-10",80]
["박상영",65,{"$nulls":3},"강창희","1997-09-11",86]
["최현구",80,{"$nulls":3},"천영주","1996-06-10",70]
[{"$nulls":5},"박인수","1998-05-06",68]
[]
[null,null,"대금 납부 현황",{"$nulls":3},"교재 대금 납부 현황"]
["성명","공통필수","전공필수","전공선택",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,"납부"]
["미납자수",{"$nulls":5},"미납자수"]

{"sheet":"통계2(결과)","index":32,"n_rows":23,"n_cols":11,"rows_kept":23,"merged":[[3,8,3,9],[4,8,4,9],[12,6,12,10]]}
["영어 시험 점수",{"$nulls":5},"직원 근무 평가"]
[{"$nulls":5},"성명","입사일","근무점수"]
["이름","영어점수",null,"응시 인원수",null,"박정호","1994-06-06",73]
["강인월",90,null,{"$f":"COUNT(B4:B10)","v":7},null,"신정희","1997-04-01",68,"70점대"]
["차영국",100,{"$nulls":3},"김용태","1999-05-06",98,{"$f":"COUNTIF(H3:H11,\">=70\")-COUNTIF(H3:H11,\">=80\")","v":2}]
["이미자",85,{"$nulls":3},"김진영","1995-11-01",65]
["류장결",70,{"$nulls":3},"유현숙","1998-01-01",69]
["송태영",95,{"$nulls":3},"최정렬","1998-06-10",80]
["박상영",65,{"$nulls":3},"강창희","1997-09-11",86]
["최현구",80,{"$nulls":3},"천영주","1996-06-10",70]
[{"$nulls":5},"박인수","1998-05-06",68]
[]
[null,null,"대금 납부 현황",{"$nulls":3},"교재 대금 납부 현황"]
["성명","공통필수","전공필수","전공선택",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},{"$f":"COUNTA(D15:D22)","v":6},null,null,"미납자수",{"$f":"COUNTBLANK(H15:H22)","v":5},{"$f":"COUNTBLANK(I15:I22)","v":4},{"$f":"COUNTBLANK(J15:J22)","v":3},{"$f":"COUNTBLANK(K15:K22)","v":6}]

{"sheet":"통계3(예제)","index":33,"n_rows":20,"n_cols":11,"rows_kept":20,"merged":[[0,1,0,7],[2,9,4,9],[2,10,4,10],[5,9,7,9],[5,10,7,10],[8,9,10,9],[8,10,10,10],[11,9,12,9],[11,10,12,10]]}
[null,"[표1] 차량운송현황"]
[]
[null,"일자","차량번호","거래처","도착지","수량","협력사","지급액",null,"① 도착지가 '영천'인 지급액의 평균은?",{"$f":"AVERAGEIF(E4:E20,\"영천\",H4:H20)","v":{"v":350142.85714285716,"d":"350,143"}}]
[null,"2017-01-11",1416,"구상공업","영천",8,"자차",{"v":424000,"d":"424,000"}]
[null,"2017-01-11",1705,"구상공업","영천",18,"전국",{"v":337000,"d":"337,000"}]
[null,"2017-01-13",1935,"구상공업","의왕",7,"자차",{"v":299000,"d":"299,000"},null,"② 도착지가 '고령'이면서 협력사가 '자차'인 \n지급액의 평균은?",{"$f":"AVERAGEIFS(H4:H20,E4:E20,\"고령\",G4:G20,\"자차\")","v":{"v":174000,"d":"174,000"}}]
[null,"2017-01-23",3229,"구상공업","영천",12,"전국",{"v":212000,"d":"212,000"}]
[null,"2017-01-30",5326,"구상공업","서울",13,"전국",{"v":304000,"d":"304,000"}]
[null,"2017-01-06",1126,"초석산업","군위","ERROR","자차",{"v":194000,"d":"194,000"},null,"③ 거래처가 '초석산업', 도착지 '영천', \n수량 >=10 조건을 모두 만족한 건수는?",{"$f":"COUNTIFS(D4:D20,\"초석산업\",E4:E20,\"영천\",F4:F20,\">=10\")","v":3}]
[null,"2017-01-08",1355,"초석산업","고령",12,"자차",{"v":190000,"d":"190,000"}]
[null,"2017-01-08",1355,"초석산업","고령",10,"자차",{"v":158000,"d":"158,000"}]
[null,"2017-01-10",1343,"초석산업","고령",8,"한성",{"v":126000,"d":"126,000"},null,"④ 수량에서 최대값은?"]
[null,"2017-01-10",1343,"초석산업","고령",18,"한성",{"v":284000,"d":"284,000"}]
[null,"2017-01-11",1667,"초석산업","구미",3,"황소",{"v":424000,"d":"424,000"}]
[null,"2017-01-16",1919,"초석산업","구미",20,"황소",{"v":357000,"d":"357,000"}]
[null,"2017-01-19",2731,"초석산업","영천",24,"한성",{"v":424000,"d":"424,000"}]
[null,"2017-01-23",3629,"초석산업","군위","ERROR","자차",{"v":212000,"d":"212,000"}]
[null,"2017-01-27",4306,"초석산업","영천",24,"한성",{"v":424000,"d":"424,000"}]
[null,"2017-01-28",5301,"초석산업","영천",16,"황소",{"v":306000,"d":"306,000"}]
[null,"2017-01-09",1336,"홍신기업","영천",12,"전국",{"v":324000,"d":"324,000"}]

{"sheet":"통계3(결과)","index":34,"n_rows":20,"n_cols":11,"rows_kept":20,"merged":[[0,1,0,7],[2,9,4,9],[2,10,4,10],[5,9,7,9],[5,10,7,10],[8,9,10,9],[8,10,10,10],[11,9,12,9],[11,10,12,10]]}
[null,"[표1] 차량운송현황"]
[]
[null,"일자","차량번호","거래처","도착지","수량","협력사","지급액",null,"① 도착지가 '영천'인 지급액의 평균은?",{"$f":"AVERAGEIF(E4:E20,\"영천\",H4:H20)","v":{"v":350142.85714285716,"d":"350,143"}}]
[null,"2017-01-11",1416,"구상공업","영천",8,"자차",{"v":424000,"d":"424,000"}]
[null,"2017-01-11",1705,"구상공업","영천",18,"전국",{"v":337000,"d":"337,000"}]
[null,"2017-01-13",1935,"구상공업","의왕",7,"자차",{"v":299000,"d":"299,000"},null,"② 도착지가 '고령'이면서 협력사가 '자차'인 \n지급액의 평균은?",{"$f":"AVERAGEIFS(H4:H20,E4:E20,\"고령\",G4:G20,\"자차\")","v":{"v":174000,"d":"174,000"}}]
[null,"2017-01-23",3229,"구상공업","영천",12,"전국",{"v":212000,"d":"212,000"}]
[null,"2017-01-30",5326,"구상공업","서울",13,"전국",{"v":304000,"d":"304,000"}]
[null,"2017-01-06",1126,"초석산업","군위","ERROR","자차",{"v":194000,"d":"194,000"},null,"③ 거래처가 '초석산업', 도착지 '영천', \n수량 >=10 조건을 모두 만족한 건수는?",{"$f":"COUNTIFS(D4:D20,\"초석산업\",E4:E20,\"영천\",F4:F20,\">=10\")","v":3}]
[null,"2017-01-08",1355,"초석산업","고령",12,"자차",{"v":190000,"d":"190,000"}]
[null,"2017-01-08",1355,"초석산업","고령",10,"자차",{"v":158000,"d":"158,000"}]
[null,"2017-01-10",1343,"초석산업","고령",8,"한성",{"v":126000,"d":"126,000"},null,"④ 수량에서 최대값은?",{"$f":"MAXA(F4:F20)","v":24}]
[null,"2017-01-10",1343,"초석산업","고령",18,"한성",{"v":284000,"d":"284,000"}]
[null,"2017-01-11",1667,"초석산업","구미",3,"황소",{"v":424000,"d":"424,000"}]
[null,"2017-01-16",1919,"초석산업","구미",20,"황소",{"v":357000,"d":"357,000"}]
[null,"2017-01-19",2731,"초석산업","영천",24,"한성",{"v":424000,"d":"424,000"}]
[null,"2017-01-23",3629,"초석산업","군위","ERROR","자차",{"v":212000,"d":"212,000"}]
[null,"2017-01-27",4306,"초석산업","영천",24,"한성",{"v":424000,"d":"424,000"}]
[null,"2017-01-28",5301,"초석산업","영천",16,"황소",{"v":306000,"d":"306,000"}]
[null,"2017-01-09",1336,"홍신기업","영천",12,"전국",{"v":324000,"d":"324,000"}]

{"sheet":"찾기1(예제)","index":35,"n_rows":23,"n_cols":13,"rows_kept":23,"merged":[[11,0,11,3],[11,11,11,12]]}
["[표1]",{"$nulls":4},"[표2]",{"$nulls":4},"[표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",{"$nulls":7},"박한나",3]
["C_Tep7","형민태","COPPER",{"$nulls":4},"회원명",null,null,"이미리",4]
[]
["고객등급별 사은품 목록",{"$nulls":10},"수강과목별 할인율"]
["C","S","G","D",{"$nulls":7},"수강과목수","할인율"]
["없음","전화기","스마트폰","아이패드",null,"[표5]",{"$nulls":5},1,{"v":0,"d":"0%"}]
[{"$nulls":5},"사원코드","성명","담당부서","근무년수","직위",null,2,{"v":0.05,"d":"5%"}]
["[표 4]",{"$nulls":4},"A-101","김남이","기획부",16,null,null,4,{"v":0.1,"d":"10%"}]
["교수코드","교수명","평가점수","결과",null,"A-201","이지영","영업부",13,null,null,6,{"v":0.15,"d":"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":36,"n_rows":23,"n_cols":13,"rows_kept":23,"merged":[[11,0,11,3],[11,11,11,12]]}
["[표1]",{"$nulls":4},"[표2]",{"$nulls":4},"[표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":{"v":171000,"d":"171,000"}}]
["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":{"v":60000,"d":"60,000"}}]
["B_Sep3","김규리","SILVER","전화기",null,"제주도",11,"안동식","일반회원",null,"정구왕",2,{"v":114000,"d":"114,000"}]
["C_Tep3","김동화","COPPER","없음",null,"안면도",20,"김민철","V.I.P",null,"정재현",3,{"v":171000,"d":"171,000"}]
["C_Tep4","김서현","GOLD","스마트폰",null,"단양",8,"장유익","일반회원",null,"황진하",2,{"v":114000,"d":"114,000"}]
["C_Tep5","김서희","SILVER","전화기",null,"삼척",3,"강태공","일반회원",null,"이윤태",1,{"v":60000,"d":"60,000"}]
["C_Tep6","류은서","GOLD","스마트폰",{"$nulls":6},"박한나",3,{"v":171000,"d":"171,000"}]
["C_Tep7","형민태","COPPER","없음",{"$nulls":3},"회원명",{"$f":"VLOOKUP(LARGE(G3:G8,1),G3:I8,2,0)","v":"김민철"},null,"이미리",4,{"v":216000,"d":"216,000"}]
[]
["고객등급별 사은품 목록",{"$nulls":10},"수강과목별 할인율"]
["C","S","G","D",{"$nulls":7},"수강과목수","할인율"]
["없음","전화기","스마트폰","아이패드",null,"[표5]",{"$nulls":5},1,{"v":0,"d":"0%"}]
[{"$nulls":5},"사원코드","성명","담당부서","근무년수","직위",null,2,{"v":0.05,"d":"5%"}]
["[표 4]",{"$nulls":4},"A-101","김남이","기획부",16,{"$f":"CHOOSE(MID(F16,3,1),\"부장\",\"과장\",\"대리\",\"사원\")","v":"부장"},null,4,{"v":0.1,"d":"10%"}]
["교수코드","교수명","평가점수","결과",null,"A-201","이지영","영업부",13,"과장",null,6,{"v":0.15,"d":"15%"}]
["CP-0701","한가람",190.15,{"$f":"CHOOSE(RANK(C18,$C$18:$C$23),\"성과급\",\"성과급\",\"\",\"\",\"\",\"감봉\")","v":"성과급"},null,"B-312","하나미","기획부",8,"대리"]
["CP-0503","김은철",166.93,"감봉",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":37,"n_rows":11,"n_cols":6,"rows_kept":11}
[null,"• CHOOSE 함수"]
[null,"날짜 입력","2017-03-31"]
[null,"요일은?"]
[]
[null,"• LOOKUP 함수"]
[null,"점수","학점",null,"점수 입력",80]
[null,0,"가",null,"학       점"]
[null,60,"양"]
[null,70,"미"]
[null,80,"우"]
[null,90,"수"]

{"sheet":"찾기2(결과)","index":38,"n_rows":11,"n_cols":6,"rows_kept":11}
[null,"• CHOOSE 함수"]
[null,"날짜 입력","2017-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":39,"n_rows":17,"n_cols":7,"rows_kept":17}
[null,"• MATCH, INDEX 함수"]
[{"$nulls":6},"수량에 대한 제품별 할인율"]
[null,"              제품명\n수량","참외","메론","수박","포도","자두"]
[null,0,{"v":0,"d":"0%"},{"v":0.01,"d":"1%"},{"v":0.03,"d":"3%"},{"v":0.03,"d":"3%"},{"v":0,"d":"0%"}]
[null,100,{"v":0.02,"d":"2%"},{"v":0.03,"d":"3%"},{"v":0.05,"d":"5%"},{"v":0.05,"d":"5%"},{"v":0.03,"d":"3%"}]
[null,200,{"v":0.03,"d":"3%"},{"v":0.06,"d":"6%"},{"v":0.07,"d":"7%"},{"v":0.07,"d":"7%"},{"v":0.05,"d":"5%"}]
[null,300,{"v":0.05,"d":"5%"},{"v":0.08,"d":"8%"},{"v":0.1,"d":"10%"},{"v":0.1,"d":"10%"},{"v":0.05,"d":"5%"}]
[null,400,{"v":0.07,"d":"7%"},{"v":0.1,"d":"10%"},{"v":0.12,"d":"12%"},{"v":0.15,"d":"15%"},{"v":0.07,"d":"7%"}]
[null,500,{"v":0.1,"d":"10%"},{"v":0.15,"d":"15%"},{"v":0.15,"d":"15%"},{"v":0.2,"d":"20%"},{"v":0.1,"d":"10%"}]
[]
[null,"＊ 주문 제품과 수량"]
[null,"제품명","수박"]
[null,"수량",150]
[null,"행 위치(수량)"]
[null,"열 위치(제품명)"]
[null,"할인율"]
[null,"할인율"]

{"sheet":"찾기3(결과)","index":40,"n_rows":17,"n_cols":7,"rows_kept":17}
[null,"• MATCH, INDEX 함수"]
[{"$nulls":6},"수량에 대한 제품별 할인율"]
[null,"              제품명\n수량","참외","메론","수박","포도","자두"]
[null,0,{"v":0,"d":"0%"},{"v":0.01,"d":"1%"},{"v":0.03,"d":"3%"},{"v":0.03,"d":"3%"},{"v":0,"d":"0%"}]
[null,100,{"v":0.02,"d":"2%"},{"v":0.03,"d":"3%"},{"v":0.05,"d":"5%"},{"v":0.05,"d":"5%"},{"v":0.03,"d":"3%"}]
[null,200,{"v":0.03,"d":"3%"},{"v":0.06,"d":"6%"},{"v":0.07,"d":"7%"},{"v":0.07,"d":"7%"},{"v":0.05,"d":"5%"}]
[null,300,{"v":0.05,"d":"5%"},{"v":0.08,"d":"8%"},{"v":0.1,"d":"10%"},{"v":0.1,"d":"10%"},{"v":0.05,"d":"5%"}]
[null,400,{"v":0.07,"d":"7%"},{"v":0.1,"d":"10%"},{"v":0.12,"d":"12%"},{"v":0.15,"d":"15%"},{"v":0.07,"d":"7%"}]
[null,500,{"v":0.1,"d":"10%"},{"v":0.15,"d":"15%"},{"v":0.15,"d":"15%"},{"v":0.2,"d":"20%"},{"v":0.1,"d":"10%"}]
[]
[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":{"v":0.05,"d":"5%"}}]
[null,"할인율",{"$f":"INDEX(C4:G9,MATCH(C13,B4:B9,1),MATCH(C12,C3:G3,0))","v":{"v":0.05,"d":"5%"}}]

{"sheet":"찾기4(예제)","index":41,"n_rows":13,"n_cols":6,"rows_kept":13,"merged":[[1,2,1,5],[3,0,7,0],[9,1,9,3],[9,4,9,5],[10,1,10,3],[10,4,10,5],[11,1,11,3],[11,4,11,5],[12,1,12,3],[12,4,12,5]]}
[]
[null,null,"열번호(COLUMN)"]
[null,"[표1]"]
["행번호(ROW)",null,"EXCEL","EXCEL","EXCEL","EXCEL"]
[null,null,"EXCEL","EXCEL","EXCEL","EXCEL"]
[null,null,"EXCEL","EXCEL","EXCEL","EXCEL"]
[null,null,"EXCEL","EXCEL","EXCEL","EXCEL"]
[null,null,"EXCEL","EXCEL","EXCEL","EXCEL"]
[]
[null,"① [B3:F8] 영역의 열의 개수는?"]
[null,"② [B3:F8] 영역의 행의 개수는?"]
[null,"③ [B2] 셀의 열 번호는?"]
[null,"④ [B2] 셀의 행 번호는?"]

{"sheet":"찾기4(결과)","index":42,"n_rows":13,"n_cols":6,"rows_kept":13,"merged":[[1,2,1,5],[3,0,7,0],[9,1,9,3],[9,4,9,5],[10,1,10,3],[10,4,10,5],[11,1,11,3],[11,4,11,5],[12,1,12,3],[12,4,12,5]]}
[]
[null,null,"열번호(COLUMN)"]
[null,"[표1]",{"$f":"COLUMN()-2","v":1},{"$f":"COLUMN()-2","v":2},{"$f":"COLUMN()-2","v":3},{"$f":"COLUMN()-2","v":4}]
["행번호(ROW)",{"$f":"ROW()-3","v":1},"EXCEL","EXCEL","EXCEL","EXCEL"]
[null,{"$f":"ROW()-3","v":2},"EXCEL","EXCEL","EXCEL","EXCEL"]
[null,{"$f":"ROW()-3","v":3},"EXCEL","EXCEL","EXCEL","EXCEL"]
[null,{"$f":"ROW()-3","v":4},"EXCEL","EXCEL","EXCEL","EXCEL"]
[null,{"$f":"ROW()-3","v":5},"EXCEL","EXCEL","EXCEL","EXCEL"]
[]
[null,"① [B3:F8] 영역의 열의 개수는?",null,null,{"$f":"COLUMNS(B3:F8)","v":5}]
[null,"② [B3:F8] 영역의 행의 개수는?",null,null,{"$f":"ROWS(B3:F8)","v":6}]
[null,"③ [B2] 셀의 열 번호는?",null,null,{"$f":"COLUMN(B2)","v":2}]
[null,"④ [B2] 셀의 행 번호는?",null,null,{"$f":"ROW(B2)","v":2}]

{"sheet":"찾기5(예제)","index":43,"n_rows":37,"n_cols":11,"rows_kept":37,"merged":[[1,0,12,0],[1,1,4,1],[3,7,7,7],[5,1,8,1],[8,8,8,9],[9,1,12,1],[13,0,24,0],[13,1,16,1],[17,1,20,1],[21,1,24,1],[25,0,36,0],[25,1,28,1],[29,1,32,1],[33,1,36,1]]}
["[표1] 부서별 매출표",null,null,"단위: 천원"]
[2013,"국내영업부","1사분기",{"v":77340,"d":"77,340"},{"$nulls":3},"[표2] 부서별 연도 매출현황"]
[null,null,"2사분기",{"v":117283,"d":"117,283"},{"$nulls":3},"년도","부서",null,1]
[null,null,"3사분기",{"v":160097,"d":"160,097"},{"$nulls":3},2015,"기간","매출액"]
[null,null,"4사분기",{"v":101905,"d":"101,905"},{"$nulls":4},"1사분기"]
[null,"특수사업부","1사분기",{"v":34080,"d":"34,080"},{"$nulls":4},"2사분기"]
[null,null,"2사분기",{"v":80158,"d":"80,158"},{"$nulls":4},"3사분기"]
[null,null,"3사분기",{"v":54017,"d":"54,017"},{"$nulls":4},"4사분기"]
[null,null,"4사분기",{"v":93638.472834,"d":"93,638"},{"$nulls":3},"합계",{"$f":"SUM(J5:J8)","v":0}]
[null,"장비수출부","1사분기",{"v":190234,"d":"190,234"}]
[null,null,"2사분기",{"v":51467,"d":"51,467"},{"$nulls":3},"[표3] 부서코드"]
[null,null,"3사분기",{"v":139523,"d":"139,523"},{"$nulls":3},"부서번호","부서명","문서 담당자","행번호"]
[null,null,"4사분기",{"v":36850,"d":"36,850"},{"$nulls":3},1,"국내영업부","박무열",0]
[2014,"국내영업부","1사분기",{"v":216385,"d":"216,385"},{"$nulls":3},2,"특수사업부","김선영",4]
[null,null,"2사분기",{"v":139824,"d":"139,824"},{"$nulls":3},3,"장비수출부","조진호",8]
[null,null,"3사분기",{"v":37693,"d":"37,693"}]
[null,null,"4사분기",{"v":28396,"d":"28,396"}]
[null,"특수사업부","1사분기",{"v":101905,"d":"101,905"}]
[null,null,"2사분기",{"v":126662,"d":"126,662"}]
[null,null,"3사분기",{"v":38928,"d":"38,928"}]
[null,null,"4사분기",{"v":34060,"d":"34,060"}]
[null,"장비수출부","1사분기",{"v":47539.308103,"d":"47,539"}]
[null,null,"2사분기",{"v":66859.377169,"d":"66,859"}]
[null,null,"3사분기",{"v":38928,"d":"38,928"}]
[null,null,"4사분기",{"v":10609,"d":"10,609"}]
[2015,"국내영업부","1사분기",{"v":8310,"d":"8,310"}]
[null,null,"2사분기",{"v":4902,"d":"4,902"}]
[null,null,"3사분기",{"v":6354,"d":"6,354"}]
[null,null,"4사분기",{"v":3604,"d":"3,604"}]
[null,"특수사업부","1사분기",{"v":3709,"d":"3,709"}]
[null,null,"2사분기",{"v":10102,"d":"10,102"}]
[null,null,"3사분기",{"v":10609,"d":"10,609"}]
[null,null,"4사분기",{"v":8310,"d":"8,310"}]
[null,"장비수출부","1사분기",{"v":10102,"d":"10,102"}]
[null,null,"2사분기",{"v":6354,"d":"6,354"}]
[null,null,"3사분기",{"v":3604,"d":"3,604"}]
[null,null,"4사분기",{"v":6334,"d":"6,334"}]

{"sheet":"찾기5(결과)","index":44,"n_rows":37,"n_cols":11,"rows_kept":37,"merged":[[1,0,12,0],[1,1,4,1],[3,7,7,7],[5,1,8,1],[8,8,8,9],[9,1,12,1],[13,0,24,0],[13,1,16,1],[17,1,20,1],[21,1,24,1],[25,0,36,0],[25,1,28,1],[29,1,32,1],[33,1,36,1]]}
["[표1] 부서별 매출표",null,null,"단위: 천원"]
[2013,"국내영업부","1사분기",{"v":77340,"d":"77,340"},{"$nulls":3},"[표2] 부서별 연도 매출현황"]
[null,null,"2사분기",{"v":117283,"d":"117,283"},{"$nulls":3},"년도","부서",null,1]
[null,null,"3사분기",{"v":160097,"d":"160,097"},{"$nulls":3},2015,"기간","매출액"]
[null,null,"4사분기",{"v":101905,"d":"101,905"},{"$nulls":4},"1사분기",{"$f":"INDIRECT(ADDRESS(IF($H$4=2013,0,IF($H$4=2014,12,24))+VLOOKUP($K$3,$H$13:$K$15,4)+ROW()-3,COLUMN()-6))","v":{"v":8310,"d":"8,310"}}]
[null,"특수사업부","1사분기",{"v":34080,"d":"34,080"},{"$nulls":4},"2사분기",{"$f":"INDIRECT(ADDRESS(IF($H$4=2013,0,IF($H$4=2014,12,24))+VLOOKUP($K$3,$H$13:$K$15,4)+ROW()-3,COLUMN()-6))","v":{"v":4902,"d":"4,902"}}]
[null,null,"2사분기",{"v":80158,"d":"80,158"},{"$nulls":4},"3사분기",{"v":6354,"d":"6,354"}]
[null,null,"3사분기",{"v":54017,"d":"54,017"},{"$nulls":4},"4사분기",{"v":3604,"d":"3,604"}]
[null,null,"4사분기",{"v":93638.472834,"d":"93,638"},{"$nulls":3},"합계",{"$f":"SUM(J5:J8)","v":{"v":23170,"d":"₩23,170"}}]
[null,"장비수출부","1사분기",{"v":190234,"d":"190,234"}]
[null,null,"2사분기",{"v":51467,"d":"51,467"},{"$nulls":3},"[표3] 부서코드"]
[null,null,"3사분기",{"v":139523,"d":"139,523"},{"$nulls":3},"부서번호","부서명","문서 담당자","행번호"]
[null,null,"4사분기",{"v":36850,"d":"36,850"},{"$nulls":3},1,"국내영업부","박무열",0]
[2014,"국내영업부","1사분기",{"v":216385,"d":"216,385"},{"$nulls":3},2,"특수사업부","김선영",4]
[null,null,"2사분기",{"v":139824,"d":"139,824"},{"$nulls":3},3,"장비수출부","조진호",8]
[null,null,"3사분기",{"v":37693,"d":"37,693"}]
[null,null,"4사분기",{"v":28396,"d":"28,396"}]
[null,"특수사업부","1사분기",{"v":101905,"d":"101,905"}]
[null,null,"2사분기",{"v":126662,"d":"126,662"}]
[null,null,"3사분기",{"v":38928,"d":"38,928"}]
[null,null,"4사분기",{"v":34060,"d":"34,060"}]
[null,"장비수출부","1사분기",{"v":47539.308103,"d":"47,539"}]
[null,null,"2사분기",{"v":66859.377169,"d":"66,859"}]
[null,null,"3사분기",{"v":38928,"d":"38,928"}]
[null,null,"4사분기",{"v":10609,"d":"10,609"}]
[2015,"국내영업부","1사분기",{"v":8310,"d":"8,310"}]
[null,null,"2사분기",{"v":4902,"d":"4,902"}]
[null,null,"3사분기",{"v":6354,"d":"6,354"}]
[null,null,"4사분기",{"v":3604,"d":"3,604"}]
[null,"특수사업부","1사분기",{"v":3709,"d":"3,709"}]
[null,null,"2사분기",{"v":10102,"d":"10,102"}]
[null,null,"3사분기",{"v":10609,"d":"10,609"}]
[null,null,"4사분기",{"v":8310,"d":"8,310"}]
[null,"장비수출부","1사분기",{"v":10102,"d":"10,102"}]
[null,null,"2사분기",{"v":6354,"d":"6,354"}]
[null,null,"3사분기",{"v":3604,"d":"3,604"}]
[null,null,"4사분기",{"v":6334,"d":"6,334"}]

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

{"sheet":"정보1(결과)","index":46,"n_rows":13,"n_cols":11,"rows_kept":13,"merged":[[1,8,1,10],[10,1,10,3]]}
[]
[{"$nulls":8},"제품목록"]
[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":{"v":235000,"d":"235,000"}},{"$f":"IF(ISERROR(E4*F4),\"\",E4*F4)","v":{"v":2350000,"d":"2,350,000"}},null,"A001","Box",{"v":235000,"d":"235,000"}]
[null,2,"A003","개",15,{"$f":"IF(ISBLANK(C5),\"\",VLOOKUP(C5,$I$4:$K$13,3,0))","v":{"v":203000,"d":"203,000"}},{"$f":"IF(ISERROR(E5*F5),\"\",E5*F5)","v":{"v":3045000,"d":"3,045,000"}},null,"A002","개",{"v":127000,"d":"127,000"}]
[null,3,null,"",null,"","",null,"A003","개",{"v":203000,"d":"203,000"}]
[null,4,null,"",null,"","",null,"A004","개",{"v":67000,"d":"67,000"}]
[null,5,null,"",null,"","",null,"A005","Box",{"v":103000,"d":"103,000"}]
[null,6,null,"",null,"","",null,"A006","개",{"v":54000,"d":"54,000"}]
[null,7,null,"",null,"","",null,"A007","개",{"v":135000,"d":"135,000"}]
[null,"합계",{"$nulls":4},{"$f":"SUM(G4:G10)","v":{"v":5395000,"d":"₩5,395,000"}},null,"A008","개",{"v":113000,"d":"113,000"}]
[{"$nulls":8},"A009","개",{"v":114000,"d":"114,000"}]
[{"$nulls":8},"A010","개",{"v":192000,"d":"192,000"}]

{"sheet":"정보2(예제)","index":47,"n_rows":18,"n_cols":8,"rows_kept":18,"merged":[[12,0,12,6]]}
["컴퓨터 특기적성 입금"]
[{"$nulls":6},"수강코드","A2225-5"]
["번호","이름","주민번호","성별","좌석","구분","할인률","수강료"]
[null,"김은미","98xxxx-212xxxx",null,null,"일반",null,{"$f":"$E$15-($E$15*G4)","v":{"v":20000,"d":"20,000"}}]
[null,"장희진","99xxxx-232xxxx",null,null,"생활보호대상자",null,{"$f":"$E$15-($E$15*G5)","v":{"v":20000,"d":"20,000"}}]
[null,"김원민","97xxxx-132xxxx",null,null,"일반",null,{"v":20000,"d":"20,000"}]
[null,"이해미","05xxxx-432xxxx",null,null,"일반",null,{"v":20000,"d":"20,000"}]
[null,"한장수","99xxxx-142xxxx",null,null,"일반",null,{"v":20000,"d":"20,000"}]
[null,"노민혁","00xxxx-356xxxx",null,null,"기초생활수급자",null,{"v":20000,"d":"20,000"}]
[null,"이기화","98xxxx-285xxxx",null,null,"국가유공자",null,{"v":20000,"d":"20,000"}]
[null,"황인서","01xxxx-432xxxx",null,null,"일반",null,{"v":20000,"d":"20,000"}]
[null,"성연정","97xxxx-232xxxx",null,null,"일반",null,{"v":20000,"d":"20,000"}]
["합계",{"$nulls":6},{"$f":"SUM(H4:H12)","v":{"v":180000,"d":"180,000"}}]
[]
["할인 대상자","수강료할인",null,"수강료",{"v":20000,"d":"20,000"}]
["생활보호대상자",{"v":0.2,"d":"20%"}]
["기초생활수급자",{"v":0.1,"d":"10%"}]
["국가유공자",{"v":0.05,"d":"5%"}]

{"sheet":"정보2(결과)","index":48,"n_rows":18,"n_cols":8,"rows_kept":18,"merged":[[12,0,12,6]]}
["컴퓨터 특기적성 입금"]
[{"$nulls":6},"수강코드","A2225-5"]
["번호","이름","주민번호","성별","좌석","구분","할인률","수강료"]
[{"$f":"CELL(\"contents\",$H$2)&\"-\"&CELL(\"row\",A1)","v":"A2225-5-1"},"김은미","98xxxx-212xxxx",{"$f":"IF(ISODD(MID(C4,8,1)),\"남\",\"여\")","v":"여"},{"$f":"IF(ISEVEN(LEFT(C4,2)),\"2분단\",\"1분단\")","v":"2분단"},"일반",{"$f":"IF(TYPE(VLOOKUP(F4,$A$16:$B$18,2,FALSE))=1,VLOOKUP(F4,$A$16:$B$18,2,FALSE),0)","v":0},{"$f":"$E$15-($E$15*G4)","v":{"v":20000,"d":"20,000"}}]
[{"$f":"CELL(\"contents\",$H$2)&\"-\"&CELL(\"row\",A2)","v":"A2225-5-2"},"장희진","99xxxx-232xxxx",{"$f":"IF(ISODD(MID(C5,8,1)),\"남\",\"여\")","v":"여"},{"$f":"IF(ISEVEN(LEFT(C5,2)),\"2분단\",\"1분단\")","v":"1분단"},"생활보호대상자",{"$f":"IF(TYPE(VLOOKUP(F5,$A$16:$B$18,2,FALSE))=1,VLOOKUP(F5,$A$16:$B$18,2,FALSE),0)","v":0.2},{"$f":"$E$15-($E$15*G5)","v":{"v":16000,"d":"16,000"}}]
["A2225-5-3","김원민","97xxxx-132xxxx","남","1분단","일반",0,{"v":20000,"d":"20,000"}]
["A2225-5-4","이해미","05xxxx-432xxxx","여","1분단","일반",0,{"v":20000,"d":"20,000"}]
["A2225-5-5","한장수","99xxxx-142xxxx","남","1분단","일반",0,{"v":20000,"d":"20,000"}]
["A2225-5-6","노민혁","00xxxx-356xxxx","남","2분단","기초생활수급자",0.1,{"v":18000,"d":"18,000"}]
["A2225-5-7","이기화","98xxxx-285xxxx","여","2분단","국가유공자",0.05,{"v":19000,"d":"19,000"}]
["A2225-5-8","황인서","01xxxx-432xxxx","여","1분단","일반",0,{"v":20000,"d":"20,000"}]
["A2225-5-9","성연정","97xxxx-232xxxx","여","1분단","일반",0,{"v":20000,"d":"20,000"}]
["합계",{"$nulls":6},{"$f":"SUM(H4:H12)","v":{"v":173000,"d":"173,000"}}]
[]
["할인 대상자","수강료할인",null,"수강료",{"v":20000,"d":"20,000"}]
["생활보호대상자",{"v":0.2,"d":"20%"}]
["기초생활수급자",{"v":0.1,"d":"10%"}]
["국가유공자",{"v":0.05,"d":"5%"}]

{"sheet":"실습1(예제)","index":49,"n_rows":35,"n_cols":11,"rows_kept":35,"merged":[[29,5,29,10],[30,5,30,10]]}
["[표1] 채용 시험 성적",{"$nulls":5},"[표2] 상여금 지급 현황"]
["수험번호","이름","성별","성적",{"$nulls":6},"(단위:천원)"]
[2004001,"강진정","남",83,null,null,"팀별","성명","사번","본봉","상여금"]
[2004002,"김용민","여",67,null,null,"재무팀","김나래","9711P",{"v":1800,"d":"1,800"}]
[2004003,"진경만","여",90,null,null,"재무팀","윤기상","9801A",{"v":1500,"d":"1,500"}]
[2004004,"박자희","남",71,null,null,"영업팀","황선호","9914A",{"v":1200,"d":"1,200"}]
[2004005,"고현주","여",96,null,null,"영업팀","이재만","9822Q",{"v":2200,"d":"2,200"}]
[2004006,"성현이","여",98,null,null,"기획팀","허준용","9901B",{"v":1300,"d":"1,300"}]
[2004007,"임수정","남",100,null,null,"기획팀","방기차","9612P",{"v":2000,"d":"2,000"}]
[2004008,"주철한","남",53,null,null,"홍보팀","채만종","9912P",{"v":1000,"d":"1,000"}]
[2004009,"나혼정","여",45]
[{"$nulls":6},"상여금 지급 기준표"]
[null,null,"표준편차(남)",{"$nulls":3},"입사년도","96","97","98","99"]
[{"$nulls":6},"구성비율(%)",{"v":0.27,"d":"27%"},{"v":0.35,"d":"35%"},{"v":0.23,"d":"23%"},{"v":0.15,"d":"15%"}]
["[표3] 필기 시험 평가 ",{"$nulls":5},"상여금",{"v":1250,"d":"1,250"},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]
[{"$nulls":6},"K003-2","참사랑","7월",24]
[{"$nulls":6},"S002-3","새벽","8월",58]
["[표5] 매출 판매 수량 집계",{"$nulls":3},"(단위 : 대)",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":50,"n_rows":35,"n_cols":11,"rows_kept":35,"merged":[[29,5,29,10],[30,5,30,10]]}
["[표1] 채용 시험 성적",{"$nulls":5},"[표2] 상여금 지급 현황"]
["수험번호","이름","성별","성적",{"$nulls":6},"(단위:천원)"]
[2004001,"강진정","남",83,null,null,"팀별","성명","사번","본봉","상여금"]
[2004002,"김용민","여",67,null,null,"재무팀","김나래","9711P",{"v":1800,"d":"1,800"},{"$f":"HLOOKUP(LEFT(I4,2),$H$13:$K$15,3,0)","v":950}]
[2004003,"진경만","여",90,null,null,"재무팀","윤기상","9801A",{"v":1500,"d":"1,500"},{"$f":"HLOOKUP(LEFT(I5,2),$H$13:$K$15,3,0)","v":870}]
[2004004,"박자희","남",71,null,null,"영업팀","황선호","9914A",{"v":1200,"d":"1,200"},720]
[2004005,"고현주","여",96,null,null,"영업팀","이재만","9822Q",{"v":2200,"d":"2,200"},870]
[2004006,"성현이","여",98,null,null,"기획팀","허준용","9901B",{"v":1300,"d":"1,300"},720]
[2004007,"임수정","남",100,null,null,"기획팀","방기차","9612P",{"v":2000,"d":"2,000"},{"v":1250,"d":"1,250"}]
[2004008,"주철한","남",53,null,null,"홍보팀","채만종","9912P",{"v":1000,"d":"1,000"},720]
[2004009,"나혼정","여",45]
[{"$nulls":6},"상여금 지급 기준표"]
[null,null,"표준편차(남)",{"$f":"ROUNDUP(DSTDEV(A2:D11,D2,C2:C3),1)","v":{"v":19.900000000000002,"d":"19.9"}},null,null,"입사년도","96","97","98","99"]
[{"$nulls":6},"구성비율(%)",{"v":0.27,"d":"27%"},{"v":0.35,"d":"35%"},{"v":0.23,"d":"23%"},{"v":0.15,"d":"15%"}]
["[표3] 필기 시험 평가 ",{"$nulls":5},"상여금",{"v":1250,"d":"1,250"},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,"대성리"]
[{"$nulls":6},"K003-2","참사랑","7월",24,"대성리"]
[{"$nulls":6},"S002-3","새벽","8월",58,"대천"]
["[표5] 매출 판매 수량 집계",{"$nulls":3},"(단위 : 대)",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":51,"n_rows":10,"n_cols":3,"rows_kept":10,"merged":[[7,0,7,1],[9,0,9,1]]}
["이름","성별","금액"]
["강희정","여",{"v":10000,"d":"10,000"}]
["김민수","남",{"v":15000,"d":"15,000"}]
["민성민","남",{"v":10000,"d":"10,000"}]
["박정아","여",{"v":20000,"d":"20,000"}]
["나인성","남",{"v":17000,"d":"17,000"}]
[]
["남자 금액 합계"]
[]
["남자 인원수"]

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

{"sheet":"배열1(예제)","index":53,"n_rows":33,"n_cols":6,"rows_kept":33,"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":54,"n_rows":33,"n_cols":6,"rows_kept":33,"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.83333333333333},{"$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":55,"n_rows":23,"n_cols":13,"rows_kept":23}
["[표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":56,"n_rows":23,"n_cols":13,"rows_kept":23}
["[표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":{"v":17.142857142857142,"d":"17.1"}},{"$f":"AVERAGE(IF($C$3:$C$23=$I12,E$3:E$23))","v":{"v":17.357142857142858,"d":"17.4"}},{"$f":"AVERAGE(IF($C$3:$C$23=$I12,F$3:F$23))","v":{"v":21.928571428571427,"d":"21.9"}},{"$f":"AVERAGE(IF($C$3:$C$23=$I12,G$3:G$23))","v":{"v":21.571428571428573,"d":"21.6"}}]
["C005","최종민","전자공학과",19,17,20,20,null,"전자공학과",{"$f":"AVERAGE(IF($C$3:$C$23=$I13,D$3:D$23))","v":{"v":18.571428571428573,"d":"18.6"}},{"$f":"AVERAGE(IF($C$3:$C$23=$I13,E$3:E$23))","v":{"v":16.142857142857142,"d":"16.1"}},{"$f":"AVERAGE(IF($C$3:$C$23=$I13,F$3:F$23))","v":{"v":23.428571428571427,"d":"23.4"}},{"$f":"AVERAGE(IF($C$3:$C$23=$I13,G$3:G$23))","v":{"v":18.142857142857142,"d":"18.1"}}]
["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":57,"n_rows":23,"n_cols":6,"rows_kept":23}
["[표1] 분류코드별 최고 월평균임금",{"$nulls":3},"[표2] 분류코드 SA의 업무코드별 종사자수의 합계"]
["분류코드","최고 월평균임금",null,null,"업무코드","종사자수 합계"]
["SA",{"$nulls":3},"분석가"]
["AP",{"$nulls":3},"관리자"]
[{"$nulls":4},"기획자"]
["[표3]"]
["분류코드","업무구분","종사자수","월평균임금","전년월평균임금","평균경력"]
["SA","시스템설계분석가",{"v":4829,"d":"4,829"},{"v":3420000,"d":"3,420,000"},{"v":3100000,"d":"3,100,000"},8]
["SA","IT컨설턴트",{"v":14195,"d":"14,195"},{"v":3090000,"d":"3,090,000"},{"v":3000000,"d":"3,000,000"},5.9]
["AP","시스템SW개발자",{"v":8130,"d":"8,130"},{"v":2560000,"d":"2,560,000"},{"v":2400000,"d":"2,400,000"},6.5]
["SA","보안관리자",{"v":5797,"d":"5,797"},{"v":2540000,"d":"2,540,000"},{"v":2450000,"d":"2,450,000"},6]
["SA","NW분석가",{"v":3168,"d":"3,168"},{"v":2290000,"d":"2,290,000"},{"v":2450000,"d":"2,450,000"},4.9]
["AP","응용SW개발자",{"v":114054,"d":"114,054"},{"v":2200000,"d":"2,200,000"},{"v":2350000,"d":"2,350,000"},5.4]
["SA","SM관리자",{"v":76947,"d":"76,947"},{"v":1990000,"d":"1,990,000"},{"v":2100000,"d":"2,100,000"},6.7]
["AP","웹개발자",{"v":15887,"d":"15,887"},{"v":1640000,"d":"1,640,000"},{"v":1850000,"d":"1,850,000"},4.1]
["SA","웹관리자",{"v":32931,"d":"32,931"},{"v":1490000,"d":"1,490,000"},{"v":1650000,"d":"1,650,000"},3.1]
["AP","통신관리자",{"v":31080,"d":"31,080"},{"v":1750000,"d":"1,750,000"},{"v":2540000,"d":"2,540,000"},8.4]
["AP","통신케이블설치",{"v":21786,"d":"21,786"},{"v":1840000,"d":"1,840,000"},{"v":1910000,"d":"1,910,000"},10.6]
["AP","멀티미디어기획자",{"v":2258,"d":"2,258"},{"v":1790000,"d":"1,790,000"},{"v":1950000,"d":"1,950,000"},3.4]
["SA","망기획자",{"v":9470,"d":"9,470"},{"v":1520000,"d":"1,520,000"},{"v":1300000,"d":"1,300,000"},9.7]
["SA","PC수리원",{"v":37802,"d":"37,802"},{"v":1730000,"d":"1,730,000"},{"v":1750000,"d":"1,750,000"},4.9]
["AP","PC강사",{"v":21146,"d":"21,146"},{"v":1190000,"d":"1,190,000"},{"v":1200000,"d":"1,200,000"},2.8]
["SA","정보통신관리자",{"v":21222,"d":"21,222"},{"v":1460000,"d":"1,460,000"},{"v":3300000,"d":"3,300,000"},12.9]

{"sheet":"배열3(결과)","index":58,"n_rows":23,"n_cols":6,"rows_kept":23}
["[표1] 분류코드별 최고 월평균임금",{"$nulls":3},"[표2] 분류코드 SA의 업무코드별 종사자수의 합계"]
["분류코드","최고 월평균임금",null,null,"업무코드","종사자수 합계"]
["SA",{"$f":"MAX(IF(($A$8:$A$23=$A3),$D$8:$D$23))","v":{"v":3420000,"d":"3,420,000"}},null,null,"분석가",{"$f":"SUM((RIGHT($B$8:$B$23,3)=$E3)*($A$8:$A$23=\"SA\")*$C$8:$C$23)","v":{"v":7997,"d":"7,997"}}]
["AP",{"$f":"MAX(IF(($A$8:$A$23=$A4),$D$8:$D$23))","v":{"v":2560000,"d":"2,560,000"}},null,null,"관리자",{"$f":"SUM((RIGHT($B$8:$B$23,3)=$E4)*($A$8:$A$23=\"SA\")*$C$8:$C$23)","v":{"v":136897,"d":"136,897"}}]
[{"$nulls":4},"기획자",{"$f":"SUM((RIGHT($B$8:$B$23,3)=$E5)*($A$8:$A$23=\"SA\")*$C$8:$C$23)","v":{"v":9470,"d":"9,470"}}]
["[표3]"]
["분류코드","업무구분","종사자수","월평균임금","전년월평균임금","평균경력"]
["SA","시스템설계분석가",{"v":4829,"d":"4,829"},{"v":3420000,"d":"3,420,000"},{"v":3100000,"d":"3,100,000"},8]
["SA","IT컨설턴트",{"v":14195,"d":"14,195"},{"v":3090000,"d":"3,090,000"},{"v":3000000,"d":"3,000,000"},5.9]
["AP","시스템SW개발자",{"v":8130,"d":"8,130"},{"v":2560000,"d":"2,560,000"},{"v":2400000,"d":"2,400,000"},6.5]
["SA","보안관리자",{"v":5797,"d":"5,797"},{"v":2540000,"d":"2,540,000"},{"v":2450000,"d":"2,450,000"},6]
["SA","NW분석가",{"v":3168,"d":"3,168"},{"v":2290000,"d":"2,290,000"},{"v":2450000,"d":"2,450,000"},4.9]
["AP","응용SW개발자",{"v":114054,"d":"114,054"},{"v":2200000,"d":"2,200,000"},{"v":2350000,"d":"2,350,000"},5.4]
["SA","SM관리자",{"v":76947,"d":"76,947"},{"v":1990000,"d":"1,990,000"},{"v":2100000,"d":"2,100,000"},6.7]
["AP","웹개발자",{"v":15887,"d":"15,887"},{"v":1640000,"d":"1,640,000"},{"v":1850000,"d":"1,850,000"},4.1]
["SA","웹관리자",{"v":32931,"d":"32,931"},{"v":1490000,"d":"1,490,000"},{"v":1650000,"d":"1,650,000"},3.1]
["AP","통신관리자",{"v":31080,"d":"31,080"},{"v":1750000,"d":"1,750,000"},{"v":2540000,"d":"2,540,000"},8.4]
["AP","통신케이블설치",{"v":21786,"d":"21,786"},{"v":1840000,"d":"1,840,000"},{"v":1910000,"d":"1,910,000"},10.6]
["AP","멀티미디어기획자",{"v":2258,"d":"2,258"},{"v":1790000,"d":"1,790,000"},{"v":1950000,"d":"1,950,000"},3.4]
["SA","망기획자",{"v":9470,"d":"9,470"},{"v":1520000,"d":"1,520,000"},{"v":1300000,"d":"1,300,000"},9.7]
["SA","PC수리원",{"v":37802,"d":"37,802"},{"v":1730000,"d":"1,730,000"},{"v":1750000,"d":"1,750,000"},4.9]
["AP","PC강사",{"v":21146,"d":"21,146"},{"v":1190000,"d":"1,190,000"},{"v":1200000,"d":"1,200,000"},2.8]
["SA","정보통신관리자",{"v":21222,"d":"21,222"},{"v":1460000,"d":"1,460,000"},{"v":3300000,"d":"3,300,000"},12.9]

{"sheet":"사용자정의(예제)","index":59,"n_rows":32,"n_cols":7,"rows_kept":32}
["[표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컨설턴트",{"v":14195,"d":"14,195"},{"v":3090000,"d":"3,090,000"},{"v":3000000,"d":"3,000,000"},5.9]
["AP","시스템SW개발자",{"v":8130,"d":"8,130"},{"v":2560000,"d":"2,560,000"},{"v":2400000,"d":"2,400,000"},6.5]
["SA","보안관리자",{"v":5797,"d":"5,797"},{"v":2540000,"d":"2,540,000"},{"v":2450000,"d":"2,450,000"},6]
["SA","NW분석가",{"v":3168,"d":"3,168"},{"v":2290000,"d":"2,290,000"},{"v":2450000,"d":"2,450,000"},4.9]
["AP","통신케이블설치",{"v":21786,"d":"21,786"},{"v":1840000,"d":"1,840,000"},{"v":1910000,"d":"1,910,000"},10.6]
["AP","멀티미디어기획자",{"v":2258,"d":"2,258"},{"v":1790000,"d":"1,790,000"},{"v":1950000,"d":"1,950,000"},3.4]
["SA","망기획자",{"v":9470,"d":"9,470"},{"v":1520000,"d":"1,520,000"},{"v":1300000,"d":"1,300,000"},9.7]
["SA","PC수리원",{"v":37802,"d":"37,802"},{"v":1730000,"d":"1,730,000"},{"v":1750000,"d":"1,750,000"},4.9]
["AP","PC강사",{"v":21146,"d":"21,146"},{"v":1190000,"d":"1,190,000"},{"v":1200000,"d":"1,200,000"},2.8]
["SA","정보통신관리자",{"v":21222,"d":"21,222"},{"v":1460000,"d":"1,460,000"},{"v":3300000,"d":"3,300,000"},12.9]
[]
["[표3]"]
["사용자","사용량","사용요금"]
["경인에폭시",43]
["고려상사",265]
["고려종합",288]
["SDC",423]
["영원종합",584]
["한국물산",180]

{"sheet":"사용자정의(결과)","index":60,"n_rows":32,"n_cols":7,"rows_kept":32}
["[표1]"]
["과목명","성명","출석","과제","중간","기말","총점"]
["C002","김대성",18,20,25,20,{"$f":"fn총점결과(C3,D3,E3,F3)","v":83}]
["P007","이현실",12,15,20,22,{"$f":"fn총점결과(C4,D4,E4,F4)","v":69}]
["C005","장충태",16,14,10,12,52]
["C005","심학철",20,18,30,28,96]
["S006","한가영",20,20,28,30,98]
["S006","진명훈",18,13,24,8,63]
["P001","형민석",18,18,22,28,86]
["P001","최준석",16,18,18,22,74]
[]
["[표2]"]
["분류코드","업무구분","종사자수","월평균임금","전년월평균임금","평균경력","보너스지급율"]
["SA","IT컨설턴트",{"v":14195,"d":"14,195"},{"v":3090000,"d":"3,090,000"},{"v":3000000,"d":"3,000,000"},5.9,{"$f":"ks보너스지급율결과(D14,E14)","v":{"v":0.1,"d":"10%"}}]
["AP","시스템SW개발자",{"v":8130,"d":"8,130"},{"v":2560000,"d":"2,560,000"},{"v":2400000,"d":"2,400,000"},6.5,{"$f":"ks보너스지급율결과(D15,E15)","v":{"v":0.05,"d":"5%"}}]
["SA","보안관리자",{"v":5797,"d":"5,797"},{"v":2540000,"d":"2,540,000"},{"v":2450000,"d":"2,450,000"},6,{"v":0.1,"d":"10%"}]
["SA","NW분석가",{"v":3168,"d":"3,168"},{"v":2290000,"d":"2,290,000"},{"v":2450000,"d":"2,450,000"},4.9,{"v":0.1,"d":"10%"}]
["AP","통신케이블설치",{"v":21786,"d":"21,786"},{"v":1840000,"d":"1,840,000"},{"v":1910000,"d":"1,910,000"},10.6,{"v":0.1,"d":"10%"}]
["AP","멀티미디어기획자",{"v":2258,"d":"2,258"},{"v":1790000,"d":"1,790,000"},{"v":1950000,"d":"1,950,000"},3.4,{"v":0.1,"d":"10%"}]
["SA","망기획자",{"v":9470,"d":"9,470"},{"v":1520000,"d":"1,520,000"},{"v":1300000,"d":"1,300,000"},9.7,{"v":0.05,"d":"5%"}]
["SA","PC수리원",{"v":37802,"d":"37,802"},{"v":1730000,"d":"1,730,000"},{"v":1750000,"d":"1,750,000"},4.9,{"v":0.1,"d":"10%"}]
["AP","PC강사",{"v":21146,"d":"21,146"},{"v":1190000,"d":"1,190,000"},{"v":1200000,"d":"1,200,000"},2.8,{"v":0.1,"d":"10%"}]
["SA","정보통신관리자",{"v":21222,"d":"21,222"},{"v":1460000,"d":"1,460,000"},{"v":3300000,"d":"3,300,000"},12.9,{"v":0.1,"d":"10%"}]
[]
["[표3]"]
["사용자","사용량","사용요금"]
["경인에폭시",43,{"$f":"fn에너지요금결과(B27)","v":{"v":12900,"d":"12,900"}}]
["고려상사",265,{"v":26500,"d":"26,500"}]
["고려종합",288,{"v":28800,"d":"28,800"}]
["SDC",423,{"v":84600,"d":"84,600"}]
["영원종합",584,{"v":116800,"d":"116,800"}]
["한국물산",180,{"v":9000,"d":"9,000"}]