{"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":37,"n_cols":8,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
["[표1]"]
["구매일","구분코드","부서명","비품명","취득원가","내용연수","잔존가치","감가상각비"]
["2016-05-18","A9332K","기획부","쇼파",400000,5,100000,60000]
["2020-05-08","A4713C","기획부","프린터",350000,1,280000,70000]
["2017-05-02","A4809N","기획부","냉온풍기",3540000,4,2000000,385000]
["2019-05-09","B9774N","영업부","에어컨",1200000,2,750000,225000]
["2016-05-13","C5988N","인사부","에어컨",2350000,5,800000,310000]
["2019-04-13","D2625K","홍보부","책상",250000,2,150000,50000]
["2019-05-08","E8614K","총무부","의자",250000,2,180000,35000]
["2020-04-08","A1286C","기획부","컴퓨터",780000,1,650000,130000]
["2020-05-13","D5938C","홍보부","복합기",1100000,1,950000,150000]
["2017-05-14","A1840C","기획부","복합기",1950000,4,1000000,237500]
["2017-05-18","B9656K","영업부","테이블",600000,4,300000,75000]
["2016-05-06","B5593K","영업부","의자",210000,5,50000,32000]
["2020-04-14","D2591N","홍보부","전기히터",32000,1,20000,12000]
["2016-05-16","E2469K","총무부","쇼파",1000000,5,300000,140000]
["2016-04-15","A4583C","기획부","프린터",560000,5,50000,102000]
["2017-05-20","E0990N","총무부","전기히터",25000,4,5000,5000]
["2020-04-06","D5474K","홍보부","책상",300000,1,250000,50000]
["2019-04-17","B6485K","영업부","쇼파",1500000,2,900000,300000]
["2018-04-21","C7921N","인사부","전기히터",39000,3,10000,9666]
["2020-04-09","C7798N","인사부","에어컨",150000,1,120000,30000]
["2019-04-27","D7039K","홍보부","의자",195000,2,90000,52500]
["2019-04-17","D9051C","홍보부","컴퓨터",1860000,2,1300000,280000]
["2019-05-26","E2409N","총무부","선풍기",50000,2,20000,15000]
["2020-04-14","B4163C","영업부","컴퓨터",1235000,1,1000000,235000]
["2018-04-07","E0187K","총무부","쇼파",3000000,3,2300000,233333]
["2019-05-23","B2839C","영업부","스캐너",250000,2,100000,75000]
["2018-05-07","C8958C","인사부","프린터",990000,3,560000,143333]
["2017-04-01","C4016N","인사부","냉온풍기",2300000,4,700000,400000]
[]
["조건"]
[{"$f":"AND(LEFT(B3,1)=\"A\",E3>=1000000,F3>=AVERAGE($F$3:$F$30))","v":false}]
[]
["부서명","비품명","취득원가","내용연수","감가상각비"]
["기획부","냉온풍기",3540000,4,385000]
["기획부","복합기",1950000,4,237500]

{"sheet":"기본작업-2","index":1,"n_rows":43,"n_cols":8,"rows_kept":43,"cut":false,"hidden":false,"merged":[]}
["[표1]"]
["구매일","구분코드","부서명","비품명","취득원가","내용연수","잔존가치","감가상각비"]
["2017-04-12","A6762N","기획부","냉온풍기",3540000,4,2000000,385000]
["2017-04-12","D5381K","홍보부","냉온풍기",2300000,4,700000,400000]
["2020-05-22","D7050C","홍보부","복합기",1100000,1,950000,150000]
["2017-04-14","E9323K","총무부","복합기",1950000,4,1000000,237500]
["2017-05-28","A9786C","기획부","복합기",1950000,4,1000000,237500]
["2020-04-26","B2452C","영업부","복합기",1100000,1,950000,150000]
["2019-05-25","A4463N","기획부","선풍기",50000,2,20000,15000]
["2019-05-20","E8955K","총무부","선풍기",50000,2,20000,15000]
["2018-04-15","E3847K","총무부","쇼파",3000000,3,2300000,233333.33333333299]
["2019-04-21","B9885K","영업부","쇼파",1500000,2,900000,300000]
["2016-04-13","D2741N","홍보부","쇼파",1000000,5,300000,140000]
["2016-04-14","A8923K","기획부","쇼파",1000000,5,300000,140000]
["2016-04-26","C2471K","인사부","쇼파",400000,5,100000,60000]
["2016-05-16","D1809K","홍보부","쇼파",400000,5,100000,60000]
["2019-05-09","B7228C","영업부","스캐너",250000,2,100000,75000]
["2016-05-04","C9759N","인사부","에어컨",2350000,5,800000,310000]
["2019-05-02","B5658N","영업부","에어컨",1200000,2,750000,225000]
["2020-05-30","A5413C","기획부","에어컨",150000,1,120000,30000]
["2020-05-29","C0722K","인사부","에어컨",150000,1,120000,30000]
["2019-05-06","E3508K","총무부","의자",250000,2,180000,35000]
["2016-05-20","D2211C","홍보부","의자",210000,5,50000,32000]
["2019-04-29","B1895N","영업부","의자",195000,2,90000,52500]
["2019-05-21","D7076C","홍보부","의자",195000,2,90000,52500]
["2019-05-19","E3624C","총무부","의자",250000,2,180000,35000]
["2017-04-24","E2453N","총무부","전기히터",25000,4,5000,5000]
["2018-04-11","C2458N","인사부","전기히터",39000,3,10000,9666.6666666666697]
["2020-04-01","B5695K","영업부","전기히터",32000,1,20000,12000]
["2020-05-12","E4556N","총무부","전기히터",32000,1,20000,12000]
["2017-05-13","B6613N","영업부","전기히터",25000,4,5000,5000]
["2019-04-02","D2651K","홍보부","책상",250000,2,150000,50000]
["2020-04-28","D3061K","홍보부","책상",300000,1,250000,50000]
["2020-04-02","B7582K","영업부","책상",300000,1,250000,50000]
["2020-04-03","B1084C","영업부","컴퓨터",1235000,1,1000000,235000]
["2020-04-24","A2837C","기획부","컴퓨터",780000,1,650000,130000]
["2019-05-02","D2590K","홍보부","컴퓨터",1860000,2,1300000,280000]
["2020-04-22","E6700C","총무부","컴퓨터",780000,1,650000,130000]
["2019-05-11","D1560N","홍보부","컴퓨터",1860000,2,1300000,280000]
["2017-04-16","C9545N","인사부","테이블",600000,4,300000,75000]
["2016-04-28","A8064C","기획부","프린터",560000,5,50000,102000]
["2020-04-04","C9625C","인사부","프린터",350000,1,280000,70000]
["2018-04-24","C9805N","인사부","프린터",990000,3,560000,143333.33333333299]

{"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,"자격미달","많음",{"$f":"fn담보여부(D5,E5)","v":"필수"}]
["이지형","1975-08-09","U01",9000000,50,0.04,"보류","보통",{"$f":"fn담보여부(D6,E6)","v":""}]
["안덕구","1994-06-15","B02",2100000,50,0.02,"적격","적음",{"$f":"fn담보여부(D7,E7)","v":""}]
["한태수","1993-12-18","B02",6000000,70,0.03,"자격미달","적음",{"$f":"fn담보여부(D8,E8)","v":""}]
["사오정","2002-12-04","B01",13900000,80,0.05,"자격미달","보통",{"$f":"fn담보여부(D9,E9)","v":"보류"}]
["이미영","1979-11-08","S01",2500000,80,0.03,"적격","적음",{"$f":"fn담보여부(D10,E10)","v":""}]
["김성룡","1983-08-10","S02",80000000,100,0.05,"자격미달","많음",{"$f":"fn담보여부(D11,E11)","v":"보류"}]
["김기자","1978-04-05","U02",40000000,50,0.04,"보류","많음",{"$f":"fn담보여부(D12,E12)","v":"보류"}]
["구기자","1966-05-10","S01",8000000,20,0.05,"보류","보통",{"$f":"fn담보여부(D13,E13)","v":""}]
["유민한","1960-09-19","B01",30000000,10,0.03,"보류","가계부담",{"$f":"fn담보여부(D14,E14)","v":"보류"}]
["맹지오","1974-04-12","B01",25000000,60,0.04,"보류","보통",{"$f":"fn담보여부(D15,E15)","v":"보류"}]
["이철희","1989-07-14","S01",70000000,70,0.04,"자격미달","가계부담",{"$f":"fn담보여부(D16,E16)","v":"필수"}]
["우주태","1999-12-21","S01",16500000,20,0.02,"자격미달","많음",{"$f":"fn담보여부(D17,E17)","v":"보류"}]
["이희용","1970-08-08","B02",73200000,90,0.02,"자격미달","많음",{"$f":"fn담보여부(D18,E18)","v":"보류"}]
["이미경","2002-05-24","U01",90000000,60,0.02,"자격미달","가계부담",{"$f":"fn담보여부(D19,E19)","v":"필수"}]
["한명구","1978-01-09","S02",2500000,90,0.04,"적격","적음",{"$f":"fn담보여부(D20,E20)","v":""}]
["김철수","1988-10-09","B01",75000000,40,0.05,"자격미달","가계부담",{"$f":"fn담보여부(D21,E21)","v":"필수"}]
["박병서","1978-05-24","B01",50000000,100,0.02,"자격미달","많음",{"$f":"fn담보여부(D22,E22)","v":"보류"}]
["박철형","1969-05-29","S02",10600000,30,0.02,"보류","보통",{"$f":"fn담보여부(D23,E23)","v":"보류"}]
["박연서","1976-03-07","S02",30000000,60,0.02,"보류","많음",{"$f":"fn담보여부(D24,E24)","v":"보류"}]
["김오지","1961-03-12","S01",2000000,30,0.05,"적격","적음",{"$f":"fn담보여부(D25,E25)","v":""}]
["장창하","1979-09-02","B01",91400000,40,0.02,"자격미달","가계부담",{"$f":"fn담보여부(D26,E26)","v":"필수"}]
["서울이","1969-07-13","U02",30000000,90,0.03,"보류","보통",{"$f":"fn담보여부(D27,E27)","v":"보류"}]
["오동추","2001-03-01","B02",1000000,20,0.05,"자격미달","적음",{"$f":"fn담보여부(D28,E28)","v":""}]
[]
["[표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":15,"n_cols":4,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[]
["수급자등급","(모두)"]
[]
["성별","일수","평균 : 본인부담금","평균 : 공단부담금"]
["남",null,32250,259312.5]
[null,"1-5",16285.714285714286,181000]
[null,"6-10",36000,326000]
[null,"11-15",31300,221700]
[null,"16-20",68266.666666666672,447733.33333333331]
["여",null,33460,276340]
[null,"1-5",25100,180400]
[null,"6-10",17500,427500]
[null,"11-15",15600,262400]
[null,"16-20",84000,331000]
["총합계",null,32715.384615384617,265861.53846153844]

{"sheet":"분석작업-2","index":4,"n_rows":23,"n_cols":8,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
[null,"[표1] 1분기",null,null,null,"[표2] 2분기"]
[null,"제품명","목표량","생산량",null,"제품명","목표량","생산량"]
[null,"냉장고",1350,1267,null,"냉장고",2000,1850]
[null,"TV",1000,1102,null,"TV",1500,1102]
[null,"세탁기",1200,1384,null,"세탁기",1300,1050]
[null,"인덕션",1150,1036,null,"인덕션",850,800]
[null,"의류건조기",900,932,null,"의류건조기",1000,1025]
[]
[null,"[표3] 3분기",null,null,null,"[표4] 4분기"]
[null,"제품명","목표량","생산량",null,"제품명","목표량","생산량"]
[null,"냉장고",2050,2000,null,"냉장고",2000,2010]
[null,"TV",1500,1450,null,"TV",1500,1600]
[null,"세탁기",1000,1200,null,"세탁기",1350,1290]
[null,"인덕션",1450,1500,null,"인덕션",1200,1230]
[null,"의류건조기",1300,1450,null,"의류건조기",1200,1000]
[]
[null,"[표5] 제품별 평균"]
[null,"제품명","목표량","생산량"]
[null,"냉장고",1850,1781.75]
[null,"TV",1375,1313.5]
[null,"세탁기",1212.5,1231]
[null,"인덕션",1162.5,1141.5]
[null,"의류건조기",1100,1101.75]

{"sheet":"기타작업-1","index":5,"n_rows":23,"n_cols":7,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
[]
["[표1]"]
["신청번호","잡지명","신청구분","구독기간","구독부수","구독요금","결제방법"]
["SJ001","상공수학","신규",1,5,1116000,1]
["SJ002","바둑돌","재구독",2,3,720000,0]
["SJ003","영화2019","재구독",2,1,336000,1]
["SJ004","상공과학","신규",1,5,883499.99999999988,"오류"]
["SJ005","바둑돌","재구독",1,3,382500,1]
["SJ006","영화2019","구독",1,2,369600,-1]
["SJ007","상공수학","재구독",2,5,1920000,0]
["SJ008","영화2019","신규",1,4,781200,-1]
["SJ009","상공수학","재구독",1,1,204000,0]
["SJ010","상공수학","재구독",2,5,1920000,1]
["SJ011","상공과학","구독",1,4,668800,-1]
["SJ012","영화2019","재구독",1,1,178500,1]
["SJ013","바둑돌","재구독",1,3,382500,-1]
["SJ014","바둑돌","신규",1,5,697500,1]
["SJ015","상공과학","재구독",1,5,807500,1]
["SJ016","바둑돌","재구독",2,4,960000,"오류"]
["SJ017","영화2019","재구독",1,5,892500,0]
["SJ018","바둑돌","신규",1,1,139500,1]
["SJ019","상공과학","신규",1,2,353400,0]
["SJ020","상공과학","구독",2,4,1292000,1]

{"sheet":"기타작업-2","index":6,"n_rows":8,"n_cols":4,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[]
[null,"[표1] 대상별 참가인원/참가비 평균"]
[null,"대상","참가인원","참가비"]
[null,"어린이",30.5,161505]
[null,"청소년",20.125,282391.25]
[null,"주부",15.125,236118.75]
[null,"직장인",16.1428571428571,228250]
[null,"어르신",16.75,144502.5]

{"sheet":"기타작업-3","index":7,"n_rows":11,"n_cols":9,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[]
["[표1]",null,null,null,null,null,null,"[표2]"]
["환자코드","성명","진료과목","담당의사","진료일","진료시간",null,"진료과목","담당의사"]
["A254","홍길동","흉부외과","박종식","2024-02-26","AM 09:40",null,"호흡기내과","김지수"]
["B842","장길산","소화기내과","남민종","2024-02-27","AM 10:00",null,"피부과","김종남"]
[null,null,null,null,null,null,null,"흉부외과","박종식"]
[null,null,null,null,null,null,null,"소화기내과","남민종"]
[null,null,null,null,null,null,null,"신경외과","임지영"]
[null,null,null,null,null,null,null,"정형외과","하석태"]
[null,null,null,null,null,null,null,"가정의학과","편영표"]
[null,null,null,null,null,null,null,"산부인과","곽수지"]