{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["기본작업-1","기본작업-2","기본작업-3","계산작업","분석작업-2","분석작업-1","매크로작업","차트작업"],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":0,"defined_names":1,"comments":0,"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":"기본작업-1","index":0,"n_rows":9,"n_cols":6,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["배드민턴센터 회원명단"]
[]
["회원명","성별","회원코드","수강일","연락처","납입회비"]
["박영민","남","YM-1035","월,수,금","010-6954-8697",120000]
["조호준","남","HJ-1068","화,목,토","010-6847-6833",100000]
["윤미나","여","MN-1086","화,목,토","010-9853-2381",90000]
["김은소","여","ES-1268","월,수,금","010-7895-5552",120000]
["민나영","여","NY-2305","화,목,토","010-3218-9987",120000]
["김진성","남","JS-2048","월,수,금","010-5874-6985",110000]

{"sheet":"기본작업-2","index":1,"n_rows":12,"n_cols":8,"rows_kept":12,"cut":false,"hidden":false,"merged":[[0,0,0,7],[3,0,5,0],[6,0,8,0],[9,0,11,0]]}
["상공회사 사원관리현황"]
[]
["부서","사원명","성별","직책","학력","資格證","입사년도","연봉"]
["관리부","허미진","여","과장","대학원졸","정보처리",2005,4600]
[null,"무기한","남","대리","대졸","워드프로세서",2009,3600]
[null,"강하지","남","사원","고졸","컴퓨터활용능력",2012,2400]
["기획부","고요한","남","과장","고졸","워드프로세서",2004,4800]
[null,"이백원","남","대리","대졸","정보처리",2008,3800]
[null,"정수기","여","사원","대학원졸","컴퓨터활용능력",2011,2500]
["영업부","신수학","여","과장","대졸","워드프로세서",2006,4400]
[null,"최첨단","남","대리","고졸","컴퓨터활용능력",2009,3600]
[null,"박두식","남","사원","대졸","정보처리",2013,2000]

{"sheet":"기본작업-3","index":2,"n_rows":15,"n_cols":6,"rows_kept":15,"cut":false,"hidden":false,"merged":[[0,0,0,5]]}
["아파트 분양가 분석 현황"]
[]
["위치","아파트명","구분","전용면적","세대수","분양가(3.3㎡당)"]
["서울","자이야","일반","148㎡",600,15000000]
["서울","푸르자나","일반","85㎡",1000,10000000]
["서울","LH","임대","101㎡",1500,8000000]
["경기","좀편한세상","일반","148㎡",800,10000000]
["경기","아이파크","일반","85㎡",1500,8000000]
["경기","LH","임대","101㎡",2000,6000000]
["인천","아이파크","일반","148㎡",500,10000000]
["인천","자이야","일반","85㎡",800,7500000]
["인천","LH","임대","101㎡",1000,5500000]
["대전","좀편한세상","일반","148㎡",700,8000000]
["대전","푸르자나","일반","85㎡",1300,7000000]
["대전","LH","임대","101㎡",1400,5000000]

{"sheet":"계산작업","index":3,"n_rows":38,"n_cols":15,"rows_kept":38,"cut":false,"hidden":false,"merged":[[13,3,13,5],[12,3,12,5],[1,13,1,14],[29,7,29,8],[28,7,28,8]]}
["[표1]","중간고사 성적표",null,null,null,null,null,"[표2]","제품판매현황"]
["성명","성별","국어","영어","수학","총점",null,"제품코드","대리점","판매량","재고량","총판매액",null,"<판매가표>"]
["이용해","여",88,89,90,{"$f":"SUM(C3:E3)","v":267},null,"C-823","마포",65,35,{"$f":"J3*VLOOKUP(LEFT(H3,1),$N$3:$O$6,2,FALSE)","v":52000000},null,"코드","판매가"]
["왕고집","남",79,85,69,{"$f":"SUM(C4:E4)","v":233},null,"C-823","강남",80,20,{"$f":"J4*VLOOKUP(LEFT(H4,1),$N$3:$O$6,2,FALSE)","v":64000000},null,"C",800000]
["안면상","여",92,90,89,271,null,"C-823","노원",77,23,61600000,null,"W",950000]
["경운기","남",94,95,89,278,null,"R-121","마포",61,39,73200000,null,"R",1200000]
["김치국","남",86,93,90,269,null,"R-121","강남",82,18,98400000]
["오지람","여",90,95,92,277,null,"R-121","노원",74,26,88800000]
["최고운","여",88,84,80,252,null,"W-118","마포",73,27,69350000]
["남달리","남",77,80,79,236,null,"W-118","강남",86,14,81700000]
["오심판","남",80,85,90,255,null,"W-118","노원",89,11,84550000]
[]
["성별","영어","수학","조건에 맞는 학생의 총점 평균",null,null,null,"[표4]","수영장 회원 현황"]
["남",">=90",null,{"$f":"ROUND(DAVERAGE(A2:F11,6,A13:C15),1)","v":272.8},null,null,null,"회원코드","성명","성별","수강요일","주민등록번호"]
["여",null,">=90",null,null,null,null,"SE-501","정보훈",{"$f":"CHOOSE(MID(L15,8,1),\"남\",\"여\",\"남\",\"여\")","v":"남"},"월, 수","890621-1******"]
[null,null,null,null,null,null,null,"SE-502","김우유",{"$f":"CHOOSE(MID(L16,8,1),\"남\",\"여\",\"남\",\"여\")","v":"여"},"월, 수","910508-2******"]
["[표3]","1/4분기 매출결과",null,null,null,"단위 : 만원",null,"SE-503","한효연","남","월, 수","890731-1******"]
["도서코드","구분","1월","2월","3월","결과",null,"SE-504","김만복","남","월, 수","881001-1******"]
["IT-25","수험서",6500,7560,8020,{"$f":"IF(AND(C19>=AVERAGE($C$19:$C$26),D19>=AVERAGE($D$19:$D$26),E19>=AVERAGE($E$19:$E$26)),\"효자도서\",\"\")","v":""},null,"SE-505","김민주","여","월, 수","951212-2******"]
["EC-60","경제/경영",8620,7925,7620,{"$f":"IF(AND(C20>=AVERAGE($C$19:$C$26),D20>=AVERAGE($D$19:$D$26),E20>=AVERAGE($E$19:$E$26)),\"효자도서\",\"\")","v":""},null,"SE-506","성인수","여","월, 수","900816-2******"]
["RF-10","교양",8802,8357,8687,"효자도서",null,"SE-507","유재명","남","화, 목","011115-3******"]
["FT-41","소설",7896,7900,8240,"",null,"SE-508","최미영","남","화, 목","000507-3******"]
["HB-49","취미",8438,8320,8345,"효자도서",null,"SE-509","강신국","여","화, 목","010909-4******"]
["HT-33","건강",6874,7000,7320,"",null,"SE-510","임미희","여","화, 목","010227-4******"]
["PC-52","컴퓨터",8576,7982,8800,"",null,"SE-511","나영식","남","화, 목","021026-3******"]
["TV-77","여행",9318,8972,9200,"효자도서",null,"SE-512","이원해","여","화, 목","000411-4******"]
[]
["[표5]","승진심사 결과표"]
["성명","성별","부서","근태","시험","승진여부",null,"여사원 승진자 수"]
["전기판","남","영업부",90,94,"승진",null,{"$f":"COUNTIFS(B30:B38,\"여\",F30:F38,\"승진\")&\"명\"","v":"2명"}]
["백수인","여","경리부",84,67]
["공양미","여","제작부",92,95,"승진"]
["이나중","남","경리부",93,94,"승진"]
["배사공","남","영업부",81,57]
["이용자","여","제작부",76,82]
["신주사","여","제작부",94,92,"승진"]
["임신중","여","영업부",57,91]
["이대로","남","경리부",92,99,"승진"]

{"sheet":"분석작업-2","index":4,"n_rows":32,"n_cols":7,"rows_kept":32,"cut":false,"hidden":false,"merged":[[0,0,0,6]]}
["동호회 회원 현황"]
[]
["지역","성명","성별","나이","직업","연락처","기부금"]
["충북","현도용","남",42,"대학교수","010-3214-6987",350000]
["충북","전용택","남",30,"회사원","010-6757-2121",300000]
["충북","장수옥","여",32,"회계사","010-5798-3127",350000]
["충북 요약",null,null,null,null,null,{"$f":"SUBTOTAL(9,G4:G6)","v":1000000}]
["충북 최대",null,null,{"$f":"SUBTOTAL(4,D4:D6)","v":42}]
["서울","한동호","남",35,"회사원","010-6547-3274",250000]
["서울","무진장","남",45,"대학교수","010-3355-6674",250000]
["서울","우양아","여",24,"대학생","010-2178-2008",120000]
["서울","전대용","남",28,"자영업","010-9357-9956",600000]
["서울 요약",null,null,null,null,null,{"$f":"SUBTOTAL(9,G9:G12)","v":1220000}]
["서울 최대",null,null,{"$f":"SUBTOTAL(4,D9:D12)","v":45}]
["부산","조금만","남",31,"회사원","010-3247-5665",200000]
["부산","강도인","남",29,"자영업","010-3547-8222",380000]
["부산","유인원","남",41,"회사원","010-3617-5744",200000]
["부산 요약",null,null,null,null,null,{"$f":"SUBTOTAL(9,G15:G17)","v":780000}]
["부산 최대",null,null,{"$f":"SUBTOTAL(4,D15:D17)","v":41}]
["대전","고기주","여",34,"자영업","010-9374-5274",300000]
["대전","허수리","여",34,"변호사","010-7827-1610",400000]
["대전","감사용","남",27,"대학생","010-3274-1092",100000]
["대전 요약",null,null,null,null,null,{"$f":"SUBTOTAL(9,G20:G22)","v":800000}]
["대전 최대",null,null,{"$f":"SUBTOTAL(4,D20:D22)","v":34}]
["경기","김만우","남",28,"대학생","010-3488-3541",100000]
["경기","고향이","여",33,"의사","010-3574-7257",500000]
["경기","선구안","여",29,"자영업","010-6279-2918",550000]
["경기","이리온","여",34,"회사원","010-4698-1007",250000]
["경기 요약",null,null,null,null,null,{"$f":"SUBTOTAL(9,G25:G28)","v":1400000}]
["경기 최대",null,null,{"$f":"SUBTOTAL(4,D25:D28)","v":34}]
["총합계",null,null,null,null,null,{"$f":"SUBTOTAL(9,G4:G28)","v":5200000}]
["전체 최대값",null,null,{"$f":"SUBTOTAL(4,D4:D28)","v":45}]

{"sheet":"분석작업-1","index":5,"n_rows":24,"n_cols":8,"rows_kept":24,"cut":false,"hidden":false,"merged":[[0,0,0,7]]}
["통조림 가공생산 현황"]
[]
["생산코드","생산일","가공팀","가공품명","생산원가","생산수량","불량율","목표매출액"]
["35-T-01","2023-01-15","가공1팀","참치",980,100000,9.1000000000000004E-3,{"$f":"F4*E4+(E4*F4)*35%","v":132300000}]
["12-P-01","2023-02-04","가공1팀","파인애플",540,110000,6.4999999999999997E-3,{"$f":"F5*E5+(E5*F5)*35%","v":80190000}]
["90-C-01","2023-01-16","가공1팀","닭가슴살",700,135000,5.3E-3,127575000]
["48-S-01","2023-01-05","가공1팀","꽁치",980,120000,5.4000000000000003E-3,158760000]
["35-T-02","2023-01-19","가공2팀","참치",540,135000,5.7999999999999996E-3,98415000]
["12-P-02","2023-02-08","가공2팀","파인애플",700,120000,8.8000000000000005E-3,113400000]
["90-C-02","2023-01-21","가공2팀","닭가슴살",980,125000,7.6E-3,165375000]
["48-S-02","2023-02-11","가공2팀","꽁치",540,125000,5.0000000000000001E-3,91125000]
["35-T-03","2023-02-15","가공3팀","참치",700,115000,4.7000000000000002E-3,108675000]
["12-P-03","2023-02-24","가공3팀","파인애플",980,100000,8.9999999999999993E-3,132300000]
["90-C-03","2023-02-13","가공3팀","닭가슴살",540,115000,5.7000000000000002E-3,83835000]
["48-S-03","2023-01-17","가공3팀","꽁치",700,120000,5.4000000000000003E-3,113400000]
[]
[]
["가공품명","(모두)"]
[]
["평균 : 목표매출액","열 레이블"]
["행 레이블","가공1팀","가공2팀","가공3팀"]
["1월",139545000,131895000,113400000]
["2월",80190000,102262500,108270000]
["총합계",124706250,117078750,109552500]

{"sheet":"매크로작업","index":6,"n_rows":15,"n_cols":6,"rows_kept":15,"cut":false,"hidden":false,"merged":[[0,0,0,5],[14,0,14,2]]}
["4월 카드 사용 내역"]
[]
["사용일자","사용가맹점","할부기간","사용금액","할인금액","결제금액"]
["2022-04-05","서울바게트",null,15000,null,{"$f":"D4-E4","v":15000}]
["2022-04-08","디마트(마포)",3,98000,5000,{"$f":"D5-E5","v":93000}]
["2022-04-10","로우마트",12,1200000,null,1200000]
["2022-04-12","상공의원",null,4800,null,4800]
["2022-04-13","상공주유소",null,70000,3500,66500]
["2022-04-18","축산물전문점",null,56000,null,56000]
["2022-04-21","맛나식당",null,99000,9900,89100]
["2022-04-22","영화박스",null,30000,null,30000]
["2022-04-25","상공주유소",null,80000,4000,76000]
["2022-04-26","디마트(마포)",3,132000,5000,127000]
["2022-04-29","TV홈쇼핑",6,180000,5000,175000]
["합계",null,null,{"$f":"SUM(D4:D14)","v":1964800},{"$f":"SUM(E4:E14)","v":32400},1932400]

{"sheet":"차트작업","index":7,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":false,"merged":[[0,0,0,4]]}
["우리나라 수출현황"]
[]
["품명","수출지역","수출단가","수출량","수출총액"]
["스마트폰","북아메리카",720000,3400,{"$f":"C4*D4","v":2448000000}]
["냉장고","남아메리카",1340000,2500,{"$f":"C5*D5","v":3350000000}]
["자동차","아시아",24000000,1000,24000000000]
["석유제품","오세아니아",600000,2800,1680000000]
["컴퓨터","유럽",850000,3000,2550000000]
["섬유","중동",500000,3200,1600000000]
["3D TV","아프리카",1200000,2800,3360000000]