{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["기본작업-1","기본작업-2","계산작업","분석작업-1","분석작업-2","기타작업-1","기타작업-2","기타작업-3"],"not_rendered":{"charts":1,"images":1,"macros":1,"external_links":0,"defined_names":5,"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":44,"n_cols":6,"rows_kept":44,"cut":false,"hidden":false,"merged":[]}
["[표1]"]
["이름","거래처명","물품코드","물품명","판매수량","판매금액"]
["고희모","삼부연","2022F-22","SPACE",17,161500]
["김경명","오리엔탈","2023T-32","Kid Jump",16,147840]
["김샘아","덕구","2023D-07","BASIC",16,148480]
["명언명","솔루코","2021S-25","FANTASY",10,150000]
["명언명","예카","2023X-08","PATCH",18,127152]
["박진철","십이선녀","2023I-37","Four AIR",11,116160]
["박진철","정동","2022V-27","썸머",16,134880]
["백인금","파랑새","20213Y-14","티코",13,149500]
["백지희","오리엔탈","2022F-40","Fish",11,143990]
["백한기","블루","2023D-10","TEMPO",12,104400]
["백한기","로얄시그","2022V-27","썸머",13,109590]
["서진발","비룡","2023I-37","Four AIR",11,116160]
["서해수","정동","2022F-37","Four AIR",10,105600]
["성생경","파랑새","2022R-02","Arena",12,154440]
["소미금","벅스","2021S-23","RAIDEN",17,161500]
["소샘생","주전골","2022V-27","썸머",13,109590]
["송현수","비룡","2022R-11","포커스",11,124300]
["송현수","레이크","2023U-32","테라",11,163350]
["이샘인","리젠시트","2022F-22","SPACE",15,142500]
["정미선","엔키노","2022M-19","리듬",10,132000]
["정미선","오리엔탈","2023T-32","Kid Jump",10,92400]
["지승언","리젠시트","2021Y-16","클래식",12,145200]
["지승천","이랑","2022V-27","썸머",12,101160]
["차오명","오리엔탈","2021S-39","Feel",10,134200]
["채왕태","밀레니엄","2023I-24","PUMPKIN",11,165000]
["최대준","토왕성","2023D-07","BASIC",11,145200]
["최전봉","코미디","2022R-28","프랜드",11,163350]
["최전봉","리젠시트","2022V-13","터보하이",11,143000]
["추리봉","제로","2022Y-05","Access",11,154880]
["추순혜","토왕성","2021S-39","Feel",10,134200]
[]
["조건"]
[{"$f":"AND(LEFT(C3,4)=\"2023\",RIGHT(C3,1)<>\"2\")","v":false}]
[]
["이름","거래처명","물품코드","물품명","판매수량","판매금액"]
["김샘아","덕구","2023D-07","BASIC",16,148480]
["명언명","예카","2023X-08","PATCH",18,127152]
["박진철","십이선녀","2023I-37","Four AIR",11,116160]
["백한기","블루","2023D-10","TEMPO",12,104400]
["서진발","비룡","2023I-37","Four AIR",11,116160]
["채왕태","밀레니엄","2023I-24","PUMPKIN",11,165000]
["최대준","토왕성","2023D-07","BASIC",11,145200]

{"sheet":"기본작업-2","index":1,"n_rows":51,"n_cols":11,"rows_kept":51,"cut":false,"hidden":false,"merged":[]}
["[표1]"]
["순번","상품코드","지역코드","매출수량","매출액","이익액","매출수수료","상품명","단가","제조경비","지역명"]
[1,"p-11","S-0001",640,1024000,256000,15360,"NAVCAN",1600,1200,"서울"]
[2,"p-15","S-0001",180,720000,180000,10800,"Four",2200,1650,"서울"]
[3,"p-15","S-0006",190,760000,190000,11400,"Four",2200,1650,"경남"]
[4,"p-01","S-0001",830,6059000,1514750,90885,"wing",4500,722,"서울"]
[5,"p-12","S-0009",490,3479000,869750,52185,"Kid Jump",7100,5325,"전북"]
[6,"p-03","S-0003",580,1102000,275500,16530,"Transfer",1900,1425,"강원"]
[7,"p-19","S-0008",250,1620000,405000,24300,"FANTASY",3000,2250,"전남"]
[8,"p-11","S-0008",110,176000,44000,2640,"NAVCAN",1600,1200,"전남"]
[9,"p-05","S-0007",810,891000,222750,13365,"SPACE",1100,825,"경북"]
[10,"p-10","S-0010",780,2652000,663000,39780,"PATCH",3400,2550,"제주"]
[11,"p-19","S-0009",710,2130000,532500,31950,"FANTASY",3000,2250,"전북"]
[12,"p-12","S-0004",180,1278000,319500,19170,"Kid Jump",7100,5325,"충남"]
[13,"p-12","S-0003",120,480000,120000,7200,"Kid Jump",7100,5325,"강원"]
[14,"p-16","S-0008",590,5251000,1312750,78765,"FLASH",8900,6675,"전남"]
[15,"p-12","S-0009",830,5893000,1473250,88395,"Kid Jump",7100,5325,"전북"]
[16,"p-07","S-0007",490,3724000,931000,55860,"RAIDEN",7600,5700,"경북"]
[17,"p-09","S-0010",150,1320000,330000,19800,"PLAYER",8800,6600,"제주"]
[18,"p-16","S-0002",90,801000,200250,12015,"FLASH",8900,6675,"경기"]
[19,"p-10","S-0010",290,986000,246500,14790,"PATCH",3400,2550,"제주"]
[20,"p-03","S-0006",740,1406000,351500,21090,"Transfer",1900,1425,"경남"]
[21,"p-05","S-0008",920,1012000,253000,15180,"SPACE",1100,825,"전남"]
[22,"p-12","S-0001",570,4047000,1011750,60705,"Kid Jump",7100,5325,"서울"]
[23,"p-10","S-0006",690,2346000,586500,35190,"PATCH",3400,2550,"경남"]
[24,"p-15","S-0010",860,1892000,473000,28380,"Four",2200,1650,"제주"]
[25,"p-08","S-0007",620,2480000,620000,37200,"PUMPKIN",4000,3000,"경북"]
[26,"p-14","S-0004",940,5264000,1316000,78960,"HI",5600,4200,"충남"]
[27,"p-09","S-0010",950,8360000,2090000,125400,"PLAYER",8800,6600,"제주"]
[28,"p-17","S-0003",60,408000,102000,6120,"Fish",6800,5100,"강원"]
[29,"p-08","S-0005",160,640000,160000,9600,"PUMPKIN",4000,3000,"충북"]
[30,"p-01","S-0001",740,5402000,1350500,81030,"wing",4500,722,"서울"]
[31,"p-12","S-0002",460,3266000,816500,48990,"Kid Jump",7100,5325,"경기"]
[32,"p-13","S-0006",920,2024000,506000,30360,"JAEHO",2200,1650,"경남"]
[33,"p-10","S-0009",710,6177000,1544250,92655,"PATCH",3400,2550,"전북"]
[34,"p-09","S-0007",630,5481000,1370250,82215,"PLAYER",8800,6600,"경북"]
[35,"p-13","S-0005",230,506000,126500,7590,"JAEHO",2200,1650,"충북"]
[36,"p-17","S-0006",560,3808000,952000,57120,"Fish",6800,5100,"경남"]
[37,"p-02","S-0002",250,675000,168750,10125,"WHITE",2700,2025,"경기"]
[38,"p-10","S-0006",660,2244000,561000,33660,"PATCH",3400,2550,"경남"]
[39,"p-01","S-0005",490,3577000,894250,53655,"wing",4500,722,"충북"]
[40,"p-14","S-0002",530,2968000,742000,44520,"HI",5600,4200,"경기"]
[41,"p-01","S-0001",630,4599000,1149750,68985,"wing",4500,722,"서울"]
[42,"p-09","S-0009",20,176000,44000,2640,"PLAYER",8800,6600,"전북"]
[43,"p-11","S-0010",770,1232000,308000,18480,"NAVCAN",1600,1200,"제주"]
[44,"p-16","S-0001",640,5696000,1424000,85440,"FLASH",8900,6675,"서울"]
[45,"p-08","S-0005",990,3960000,990000,59400,"PUMPKIN",4000,3000,"충북"]
[46,"p-08","S-0002",150,600000,150000,9000,"PUMPKIN",4000,3000,"경기"]
[47,"p-03","S-0001",820,1558000,389500,23370,"Transfer",1900,1425,"서울"]
[48,"p-19","S-0007",960,2880000,720000,43200,"FANTASY",3000,2250,"경북"]
[49,"p-17","S-0004",910,6188000,1547000,92820,"Fish",6800,5100,"충남"]

{"sheet":"계산작업","index":2,"n_rows":37,"n_cols":9,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
["[표1]",null,null,null,null,null,null,"기준일 :","2022-01-01"]
["성명","생년월일","지점","대출금액","월기간","연이율","자격","가계부담","담보여부"]
["장길산","1966-04-14","S02",2500000,20,0.05,{"$f":"IF(AND(YEAR($I$1)-YEAR(B3)>=25,D3<3000000),\"적격\",IF(AND(YEAR($I$1)-YEAR(B3)>=35,D3<50000000),\"보류\",\"자격미달\"))","v":"적격"},{"$f":"VLOOKUP(PMT(F3/12,E3,-D3),$A$32:$B$35,2)","v":"보통"},{"$f":"fn담보여부(D3,E3)","v":""}]
["윤수아","1996-10-09","U01",3500000,40,0.02,{"$f":"IF(AND(YEAR($I$1)-YEAR(B4)>=25,D4<3000000),\"적격\",IF(AND(YEAR($I$1)-YEAR(B4)>=35,D4<50000000),\"보류\",\"자격미달\"))","v":"자격미달"},{"$f":"VLOOKUP(PMT(F4/12,E4,-D4),$A$32:$B$35,2)","v":"적음"},{"$f":"fn담보여부(D4,E4)","v":""}]
["오두환","1967-06-01","U02",50000000,60,0.05,"자격미달","많음","필수"]
["이지형","1975-08-09","U01",9000000,50,0.04,"보류","보통",""]
["안덕구","1994-06-15","B02",2100000,50,0.02,"적격","적음",""]
["한태수","1993-12-18","B02",6000000,70,0.03,"자격미달","적음",""]
["사오정","2002-12-04","B01",13900000,80,0.05,"자격미달","보통","보류"]
["이미영","1979-11-08","S01",2500000,80,0.03,"적격","적음",""]
["김성룡","1983-08-10","S02",80000000,100,0.05,"자격미달","많음","보류"]
["김기자","1978-04-05","U02",40000000,50,0.04,"보류","많음","보류"]
["구기자","1966-05-10","S01",8000000,20,0.05,"보류","보통",""]
["유민한","1960-09-19","B01",30000000,10,0.03,"보류","가계부담","보류"]
["맹지오","1974-04-12","B01",25000000,60,0.04,"보류","보통","보류"]
["이철희","1989-07-14","S01",70000000,70,0.04,"자격미달","가계부담","필수"]
["우주태","1999-12-21","S01",16500000,20,0.02,"자격미달","많음","보류"]
["이희용","1970-08-08","B02",73200000,90,0.02,"자격미달","많음","보류"]
["이미경","2002-05-24","U01",90000000,60,0.02,"자격미달","가계부담","필수"]
["한명구","1978-01-09","S02",2500000,90,0.04,"적격","적음",""]
["김철수","1988-10-09","B01",75000000,40,0.05,"자격미달","가계부담","필수"]
["박병서","1978-05-24","B01",50000000,100,0.02,"자격미달","많음","보류"]
["박철형","1969-05-29","S02",10600000,30,0.02,"보류","보통","보류"]
["박연서","1976-03-07","S02",30000000,60,0.02,"보류","많음","보류"]
["김오지","1961-03-12","S01",2000000,30,0.05,"적격","적음",""]
["장창하","1979-09-02","B01",91400000,40,0.02,"자격미달","가계부담","필수"]
["서울이","1969-07-13","U02",30000000,90,0.03,"보류","보통","보류"]
["오동추","2001-03-01","B02",1000000,20,0.05,"자격미달","적음",""]
[]
["[표2] 월상환금액에 따른 가계부담",null,null,"[표3] 지점별 최대 매출금액의 전체 순위",null,null,"[표4] 지역별 대출금액의 합계"]
["월상환금액","가계부담",null,"지점","최대 대출금액 순위",null,"지역코드","지역","대출금액합계"]
[0,"적음",null,"S01",{"$f":"_xlfn.RANK.EQ(MAX(IF($C$3:$C$28=D32,$D$3:$D$28)),$D$3:$D$28)","v":6},null,"S","서울",{"$f":"SUM(IF(LEFT($C$3:$C$28,1)=G32,$D$3:$D$28))","v":224600000}]
[100000,"보통",null,"S02",{"$f":"_xlfn.RANK.EQ(MAX(IF($C$3:$C$28=D33,$D$3:$D$28)),$D$3:$D$28)","v":3},null,"B","부산",{"$f":"SUM(IF(LEFT($C$3:$C$28,1)=G33,$D$3:$D$28))","v":367600000}]
[500000,"많음",null,"B01",{"$f":"_xlfn.RANK.EQ(MAX(IF($C$3:$C$28=D34,$D$3:$D$28)),$D$3:$D$28)","v":1},null,"U","울산",{"$f":"SUM(IF(LEFT($C$3:$C$28,1)=G34,$D$3:$D$28))","v":222500000}]
[1000000,"가계부담",null,"B02",{"$f":"_xlfn.RANK.EQ(MAX(IF($C$3:$C$28=D35,$D$3:$D$28)),$D$3:$D$28)","v":5}]
[null,null,null,"U01",{"$f":"_xlfn.RANK.EQ(MAX(IF($C$3:$C$28=D36,$D$3:$D$28)),$D$3:$D$28)","v":2}]
[null,null,null,"U02",{"$f":"_xlfn.RANK.EQ(MAX(IF($C$3:$C$28=D37,$D$3:$D$28)),$D$3:$D$28)","v":7}]

{"sheet":"분석작업-1","index":3,"n_rows":19,"n_cols":6,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[]
[null,"합계 : 받은점수",null,"성별"]
[null,"과목","항목","남","여","총합계"]
[null,"과학",null,0.19575856443719414,9.6247960848287115E-2,0.29200652528548127]
[null,null,"기말고사",3.4257748776508973E-2,0,3.4257748776508973E-2]
[null,null,"발표",2.936378466557912E-2,0,2.936378466557912E-2]
[null,null,"실험",0.10277324632952692,6.3621533442088096E-2,0.16639477977161501]
[null,null,"중간고사",2.936378466557912E-2,3.2626427406199018E-2,6.1990212071778142E-2]
[null,"국어",null,0.17618270799347471,0.1598694942903752,0.33605220228384991]
[null,null,"기말고사",7.6672104404567704E-2,0,7.6672104404567704E-2]
[null,null,"발표",6.3621533442088096E-2,4.0783034257748776E-2,0.10440456769983687]
[null,null,"중간고사",3.588907014681892E-2,4.0783034257748776E-2,7.6672104404567704E-2]
[null,null,"포트폴리오",0,7.8303425774877644E-2,7.8303425774877644E-2]
[null,"사회",null,0.24306688417618272,0.12887438825448613,0.37194127243066882]
[null,null,"기말고사",3.588907014681892E-2,2.936378466557912E-2,6.5252854812398037E-2]
[null,null,"발표",3.9151712887438822E-2,3.0995106035889071E-2,7.01468189233279E-2]
[null,null,"중간고사",7.177814029363784E-2,3.9151712887438822E-2,0.11092985318107668]
[null,null,"포트폴리오",9.6247960848287115E-2,2.936378466557912E-2,0.12561174551386622]
[null,"총합계",null,0.6150081566068516,0.38499184339314846,1]

{"sheet":"분석작업-2","index":4,"n_rows":42,"n_cols":6,"rows_kept":42,"cut":false,"hidden":false,"merged":[]}
["[표1]"]
["대출번호","성명","대출지점","대출종류","대출금액","기간"]
["J02-01","김춘복","경기","주택자금대출",15000000,60]
["J02-38","이민주","경기","주택자금대출",27000000,48]
["K02-59","이성재","경기","국민주택기금대출",7000000,30]
["M02-14","이영민","경기","무보증신용대출",5000000,30]
["Y02-26","이재철","경기","예부적금담보대출",2500000,12]
["M02-12","이진태","경기","무보증신용대출",3000000,24]
["K02-28","임현석","경기","국민주택기금대출",10000000,30]
["M02-06","최철식","경기","무보증신용대출",2000000,36]
["Y02-67","형연주","경기","예부적금담보대출",1000000,48]
[{"$f":"SUBTOTAL(3,A3:A11)","v":9},null,"경기 개수"]
[null,null,"경기 요약",null,{"$f":"SUBTOTAL(9,E3:E11)","v":72500000}]
["K03-52","국선재","부산","국민주택기금대출",6000000,24]
["Y03-88","김상진","부산","예부적금담보대출",4000000,48]
["K03-05","민승렬","부산","국민주택기금대출",15000000,60]
["J03-26","민애라","부산","주택자금대출",12000000,60]
["M03-37","박순영","부산","무보증신용대출",10000000,36]
["Y03-08","설진구","부산","예부적금담보대출",2000000,60]
[{"$f":"SUBTOTAL(3,A14:A19)","v":6},null,"부산 개수"]
[null,null,"부산 요약",null,{"$f":"SUBTOTAL(9,E14:E19)","v":49000000}]
["M01-23","구준식","서울","무보증신용대출",5000000,30]
["Y01-07","도희철","서울","예부적금담보대출",3000000,36]
["M01-27","박세희","서울","무보증신용대출",8000000,30]
["J01-42","성철수","서울","주택자금대출",15000000,30]
["K01-02","오태열","서울","국민주택기금대출",7000000,24]
["M01-64","이영진","서울","무보증신용대출",3000000,24]
["K01-38","정대식","서울","국민주택기금대출",5000000,18]
["M01-37","최만용","서울","무보증신용대출",5000000,36]
[{"$f":"SUBTOTAL(3,A22:A29)","v":8},null,"서울 개수"]
[null,null,"서울 요약",null,{"$f":"SUBTOTAL(9,E22:E29)","v":51000000}]
["M04-08","김진석","충청","무보증신용대출",5000000,18]
["J04-26","남지철","충청","주택자금대출",15000000,60]
["J04-31","민인희","충청","주택자금대출",35000000,24]
["K04-35","박철형","충청","국민주택기금대출",5000000,24]
["K04-02","우진우","충청","국민주택기금대출",5000000,30]
["Y04-48","장우석","충청","예부적금담보대출",3000000,36]
["Y04-15","진영태","충청","예부적금담보대출",3000000,36]
[{"$f":"SUBTOTAL(3,A32:A38)","v":7},null,"충청 개수"]
[null,null,"충청 요약",null,{"$f":"SUBTOTAL(9,E32:E38)","v":71000000}]
[{"$f":"SUBTOTAL(3,A3:A38)","v":30},null,"전체 개수"]
[null,null,"총합계",null,{"$f":"SUBTOTAL(9,E3:E38)","v":243500000}]

{"sheet":"기타작업-1","index":5,"n_rows":13,"n_cols":3,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[]
["[표1] 연도별 질병에 따른 사망 증감률"]
["사망원인",2019,2020]
["뇌혈관 질환",-0.06,1.4E-2]
["심장 질환",-3.2000000000000001E-2,4.2999999999999997E-2]
[" 폐암",0.04,6.0000000000000001E-3]
["간암",-5.0000000000000001E-3,0]
["위암",-1.2999999999999999E-2,-0.02]
["당뇨병",-7.5999999999999998E-2,4.3999999999999997E-2]
["자살","※","※"]
["폐렴",-7.0000000000000001E-3,-0.04]
["간 질환",-5.1999999999999998E-2,7.0999999999999994E-2]
["운수사고",-9.9000000000000005E-2,-6.0999999999999999E-2]

{"sheet":"기타작업-2","index":6,"n_rows":11,"n_cols":7,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[]
["[표1]","지역별 연령별 접종 현황"]
[null,"10대","20대","30대","40대","50대","60대"]
["서울",null,310,null,null,586]
["경기",320,150,null,250,512,430]
["경남",null,255,null,320,null,550]
["경북",null,null,320,null,null,139]
["전북",null,524,null,106,234]
["전남",null,null,486,null,318,457]
["강원",299,362,null,574]
["제주",null,null,null,null,307]

{"sheet":"기타작업-3","index":7,"n_rows":4,"n_cols":7,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
[]
["[표1]","판매 현황"]
["성명","판매일","할부기간","수량","단가","금액","할인금액"]
["홍길동","2022-06-13","일시불",5,25000,125000,"12,500원"]