{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["기본작업-1","기본작업-2","계산작업","분석작업-1","분석작업-2","기타작업-1","기타작업-2","기타작업-3"],"not_rendered":{"charts":1,"images":9,"macros":1,"external_links":0,"defined_names":8,"comments":0,"pivot_tables":0},"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":28,"n_cols":14,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
[]
[null,"환자번호","이름","성별","나이","수급자등급","수급자유형","서비스명","이용일수","이용시간","이용일구분","급여비용","공단부담금","본인부담금"]
[null,"A8952","사미인","여",67,1,"기초생활","방문목욕",4,40,"평일",400000,400000,0]
[null,"B6891","안태호","남",84,3,"일반","방문목욕",1,4,"평일",40000,32000,8000]
[null,"A3717","이영심","여",74,2,"기타","방문간호",7,35,"평일",350000,315000,35000]
[null,"C8576","김지민","여",79,3,"기타","단기보호",3,18,"평일",180000,162000,18000]
[null,"D4273","송준석","남",81,5,"일반","방문요양",4,24,"평일",240000,192000,48000]
[null,"A9679","임보미","여",93,1,"기초생활","방문간호",4,28,"평일",280000,280000,0]
[null,"D7978","이수상","남",64,5,"기타","단기보호",2,12,"휴일",156000,140400,15600]
[null,"C5822","도우미","여",80,4,"일반","방문목욕",2,12,"휴일",156000,124800,31200]
[null,"D3886","홍태완","남",93,4,"일반","방문간호",4,24,"심야",288000,230400,57600]
[null,"A8240","은종서","남",50,2,"기타","방문간호",3,18,"평일",180000,162000,18000]
[null,"D1787","조용희","여",95,1,"일반","방문목욕",3,27,"평일",270000,216000,54000]
[null,"A1495","은수저","남",65,1,"기초생활","방문간호",5,20,"평일",200000,200000,0]
[null,"D1971","김미향","여",73,5,"기초생활","단기보호",7,59,"심야",650000,500000,150000]
[null,"D4877","양순호","남",82,1,"기타","방문목욕",6,54,"심야",648000,583200,64800]
[null,"A7371","김장철","남",51,2,"기타","방문목욕",2,16,"심야",192000,172800,19200]
[null,"B7149","남호진","남",83,1,"기초생활","방문요양",1,4,"평일",40000,40000,0]
[null,"C1749","우태영","여",56,1,"기초생활","방문요양",6,54,"평일",540000,540000,0]
[null,"A9810","이다음","남",89,2,"일반","방문간호",6,36,"평일",360000,288000,72000]
[null,"C3897","차주인","남",88,5,"기초생활","방문요양",7,28,"휴일",364000,364000,0]
[null,"D1595","왕건이","남",64,5,"일반","방문요양",2,8,"휴일",104000,83200,20800]
[null,"A6220","윤철수","남",89,3,"기초생활","방문요양",1,4,"심야",48000,48000,0]
[null,"D6798","황국영","남",53,1,"기초생활","방문요양",5,45,"휴일",585000,585000,0]
[null,"A1899","고인숙","여",53,4,"기타","단기보호",1,8,"평일",80000,72000,8000]
[null,"D6171","강다구","남",77,1,"일반","방문목욕",7,70,"평일",700000,560000,140000]
[null,"C3852","나진만","남",85,3,"기타","단기보호",5,40,"휴일",520000,468000,52000]
[null,"A5662","박소희","여",79,5,"일반","단기보호",2,16,"심야",192000,153600,38400]

{"sheet":"기본작업-2","index":1,"n_rows":28,"n_cols":14,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
[]
[null,"환자번호","이름","성별","나이","수급자등급","수급자유형","서비스명","이용일수","이용시간","이용일구분","급여비용","공단부담금","본인부담금"]
[null,"A8952","사미인","여",67,1,"기초생활","방문목욕",4,40,"평일",400000,400000,0]
[null,"B6891","안태호","남",84,3,"일반","방문목욕",1,4,"평일",40000,32000,8000]
[null,"A3717","이영심","여",74,2,"기타","방문간호",7,35,"평일",350000,315000,35000]
[null,"C8576","김지민","여",79,3,"기타","단기보호",3,18,"평일",180000,162000,18000]
[null,"D4273","송준석","남",81,5,"일반","방문요양",4,24,"평일",240000,192000,48000]
[null,"A9679","임보미","여",93,1,"기초생활","방문간호",4,28,"평일",280000,280000,0]
[null,"D7978","이수상","남",64,5,"기타","단기보호",2,12,"휴일",156000,140400,15600]
[null,"C5822","도우미","여",80,4,"일반","방문목욕",2,12,"휴일",156000,124800,31200]
[null,"D3886","홍태완","남",93,4,"일반","방문간호",4,24,"심야",288000,230400,57600]
[null,"A8240","은종서","남",50,2,"기타","방문간호",3,18,"평일",180000,162000,18000]
[null,"D1787","조용희","여",95,1,"일반","방문목욕",3,27,"평일",270000,216000,54000]
[null,"A1495","은수저","남",65,1,"기초생활","방문간호",5,20,"평일",200000,200000,0]
[null,"D1971","김미향","여",73,5,"기초생활","단기보호",7,59,"심야",650000,500000,150000]
[null,"D4877","양순호","남",82,1,"기타","방문목욕",6,54,"심야",648000,583200,64800]
[null,"A7371","김장철","남",51,2,"기타","방문목욕",2,16,"심야",192000,172800,19200]
[null,"B7149","남호진","남",83,1,"기초생활","방문요양",1,4,"평일",40000,40000,0]
[null,"C1749","우태영","여",56,1,"기초생활","방문요양",6,54,"평일",540000,540000,0]
[null,"A9810","이다음","남",89,2,"일반","방문간호",6,36,"평일",360000,288000,72000]
[null,"C3897","차주인","남",88,5,"기초생활","방문요양",7,28,"휴일",364000,364000,0]
[null,"D1595","왕건이","남",64,5,"일반","방문요양",2,8,"휴일",104000,83200,20800]
[null,"A6220","윤철수","남",89,3,"기초생활","방문요양",1,4,"심야",48000,48000,0]
[null,"D6798","황국영","남",53,1,"기초생활","방문요양",5,45,"휴일",585000,585000,0]
[null,"A1899","고인숙","여",53,4,"기타","단기보호",1,8,"평일",80000,72000,8000]
[null,"D6171","강다구","남",77,1,"일반","방문목욕",7,70,"평일",700000,560000,140000]
[null,"C3852","나진만","남",85,3,"기타","단기보호",5,40,"휴일",520000,468000,52000]
[null,"A5662","박소희","여",79,5,"일반","단기보호",2,16,"심야",192000,153600,38400]

{"sheet":"계산작업","index":2,"n_rows":55,"n_cols":15,"rows_kept":55,"cut":false,"hidden":false,"merged":[[37,7,37,8]]}
[]
[null,"[표1]"]
[null,"환자번호","이름","성별","나이","수급자등급","수급자유형","서비스명","이용일수","이용시간","이용일구분","급여비용","공단부담금","본인부담금","기타"]
[null,"A8952","사미인","여",67,1,"기초생활","방문목욕",4,40,"평일",{"$f":"J4*IF(K4=\"평일\",10000,IF(K4=\"심야\",12000,13000))","v":400000},null,0]
[null,"B6891","안태호","남",84,3,"일반","방문목욕",1,4,"평일",{"$f":"J5*IF(K5=\"평일\",10000,IF(K5=\"심야\",12000,13000))","v":40000},null,8000]
[null,"A3717","이영심","여",74,2,"기타","방문간호",7,35,"평일",350000,null,35000]
[null,"C8576","김지민","여",79,3,"기타","단기보호",3,18,"평일",180000,null,18000]
[null,"D4273","송준석","남",81,5,"일반","방문요양",4,24,"평일",240000,null,48000]
[null,"A9679","임보미","여",93,1,"기초생활","방문간호",4,28,"평일",280000,null,0]
[null,"D7978","이수상","남",64,5,"기타","단기보호",2,12,"휴일",156000,null,15600]
[null,"C5822","도우미","여",80,4,"일반","방문목욕",2,12,"휴일",156000,null,31200]
[null,"D3886","홍태완","남",93,4,"일반","방문간호",4,24,"심야",288000,null,57600]
[null,"A8240","은종서","남",50,2,"기타","방문간호",3,18,"평일",180000,null,18000]
[null,"D1787","조용희","여",95,1,"일반","방문목욕",3,27,"평일",270000,null,54000]
[null,"A1495","은수저","남",65,1,"기초생활","방문간호",5,20,"평일",200000,null,0]
[null,"D1971","김미향","여",73,5,"기초생활","단기보호",7,59,"심야",650000,null,150000]
[null,"D4877","양순호","남",82,1,"기타","방문목욕",6,54,"심야",648000,null,64800]
[null,"A7371","김장철","남",51,2,"기타","방문목욕",2,16,"심야",192000,null,19200]
[null,"B7149","남호진","남",83,1,"기초생활","방문요양",1,4,"평일",40000,null,0]
[null,"C1749","우태영","여",56,1,"기초생활","방문요양",6,54,"평일",540000,null,0]
[null,"A9810","이다음","남",89,2,"일반","방문간호",6,36,"평일",{"$f":"J21*IF(K21=\"평일\",10000,IF(K21=\"심야\",12000,13000))","v":360000},null,72000]
[null,"C3897","차주인","남",88,5,"기초생활","방문요양",7,28,"휴일",364000,null,0]
[null,"D1595","왕건이","남",64,5,"일반","방문요양",2,8,"휴일",104000,null,20800]
[null,"A6220","윤철수","남",89,3,"기초생활","방문요양",1,4,"심야",48000,null,0]
[null,"D6798","황국영","남",53,1,"기초생활","방문요양",5,45,"휴일",585000,null,0]
[null,"A1899","고인숙","여",53,4,"기타","단기보호",1,8,"평일",80000,null,8000]
[null,"D6171","강다구","남",77,1,"일반","방문목욕",7,70,"평일",700000,null,140000]
[null,"C3852","나진만","남",85,3,"기타","단기보호",5,40,"휴일",520000,null,52000]
[null,"A5662","박소희","여",79,5,"일반","단기보호",2,16,"심야",192000,null,38400]
[]
[null,"[표2] 월한도액",null,null,null,null,null,null,"[표3] 본인부담비율",null,null,"[표4] 일당"]
[null,"등급",5,4,3,2,1,null,"수급자유형","본인부담비율",null,"등급","전문요양병원","노인요양병원","공동생활가정"]
[null,"월한도액",500000,600000,700000,800000,900000,null,"일반",0.2,null,5,54200,57300,52100]
[null,null,null,null,null,null,null,null,"기타",0.1,null,4,48200,52300,49000]
[null,null,null,null,null,null,null,null,"기초생활",0,null,3,45200,47000,44200]
[null,"[표5] 수급자등급별 서비스명별 이용일수의 합",null,null,null,null,null,null,null,null,null,2,45200,47000,44200]
[null,"수급자등급","방문요양","방문목욕","방문간호","단기보호",null,"[표6] 나이별 빈도수",null,null,null,1,45200,47000,44200]
[null,5,null,null,null,null,null,"나이",null,"빈도수"]
[null,4,null,null,null,null,null,50,64]
[null,3,null,null,null,null,null,65,74]
[null,2,null,null,null,null,null,75,84]
[null,1,null,null,null,null,null,85,100]
[]
[null,"[표7]"]
[null,"환자번호","보호시설","수급자등급","이용일수","급여"]
[null,"D347","전문요양병원",1,6]
[null,"A7367","공동생활가정",2,2]
[null,"B4549","전문요양병원",1,1]
[null,"C8949","노인요양병원",1,6]
[null,"A9670","전문요양병원",2,6]
[null,"C4397","전문요양병원",5,7]
[null,"A2345","공동생활가정",4,1]
[null,"D3432","노인요양병원",1,7]
[null,"C4572","노인요양병원",3,5]
[null,"A3421","노인요양병원",2,3]

{"sheet":"분석작업-1","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"분석작업-2","index":4,"n_rows":28,"n_cols":10,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
[]
[null,"환자번호","이름","성별","나이","수급자등급","수급자유형","서비스명","이용일수","이용시간"]
[null,"A1495","은수저","남",65,1,"기초생활","방문간호",5,20]
[null,"A1899","고인숙","여",53,4,"기타","단기보호",1,8]
[null,"A3717","이영심","여",74,2,"기타","방문간호",7,35]
[null,"A5662","박소희","여",79,5,"일반","단기보호",2,16]
[null,"A6220","윤철수","남",89,3,"기초생활","방문요양",1,4]
[null,"A7371","김장철","남",51,2,"기타","방문목욕",2,16]
[null,"A8240","은종서","남",50,2,"기타","방문간호",3,18]
[null,"A8952","사미인","여",67,1,"기초생활","방문목욕",4,40]
[null,"A9679","임보미","여",93,1,"기초생활","방문간호",4,28]
[null,"A9810","이다음","남",89,2,"일반","방문간호",6,36]
[null,"B6891","안태호","남",84,3,"일반","방문목욕",1,4]
[null,"B7149","남호진","남",83,1,"기초생활","방문요양",1,4]
[null,"C1749","우태영","여",56,1,"기초생활","방문요양",6,54]
[null,"C3852","나진만","남",85,3,"기타","단기보호",5,40]
[null,"C3897","차주인","남",88,5,"기초생활","방문요양",7,28]
[null,"C5822","도우미","여",80,4,"일반","방문목욕",2,12]
[null,"C8576","김지민","여",79,3,"기타","단기보호",3,18]
[null,"D1595","왕건이","남",64,5,"일반","방문요양",2,8]
[null,"D1787","조용희","여",95,1,"일반","방문목욕",3,27]
[null,"D1971","김미향","여",73,5,"기초생활","단기보호",7,59]
[null,"D3886","홍태완","남",93,4,"일반","방문간호",4,24]
[null,"D4273","송준석","남",81,5,"일반","방문요양",4,24]
[null,"D4877","양순호","남",82,1,"기타","방문목욕",6,54]
[null,"D6171","강다구","남",77,1,"일반","방문목욕",7,70]
[null,"D6798","황국영","남",53,1,"기초생활","방문요양",5,45]
[null,"D7978","이수상","남",64,5,"기타","단기보호",2,12]

{"sheet":"기타작업-1","index":5,"n_rows":8,"n_cols":5,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[]
[null,"연도","노인인구수","수급자수","수급율"]
[null,2020,5930000,2075000,{"$f":"D3/C3","v":0.34991568296795955}]
[null,2019,5354000,2005000,{"$f":"D4/C4","v":0.3744863653343295}]
[null,2018,5530500,1950000,0.3525901817195552]
[null,2017,4950000,1815000,0.36666666666666664]
[null,2016,4800000,1905000,0.39687499999999998]
[null,2015,4870000,1875000,0.38501026694045176]

{"sheet":"기타작업-2","index":6,"n_rows":28,"n_cols":10,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
[]
[null,"환자번호","이름","성별","나이","수급자등급","수급자유형","서비스명","이용일수","이용시간"]
[null,"C8576","김지민","여",79,3,"기타","단기보호",3,18]
[null,"D7978","이수상","남",64,5,"기타","단기보호",2,12]
[null,"D1971","김미향","여",73,5,"기초생활","단기보호",7,59]
[null,"A1899","고인숙","여",53,4,"기타","단기보호",1,8]
[null,"C3852","나진만","남",85,3,"기타","단기보호",5,40]
[null,"A5662","박소희","여",79,5,"일반","단기보호",2,16]
[null,"A3717","이영심","여",74,2,"기타","방문간호",7,35]
[null,"A9679","임보미","여",93,1,"기초생활","방문간호",4,28]
[null,"D3886","홍태완","남",93,4,"일반","방문간호",4,24]
[null,"A8240","은종서","남",50,2,"기타","방문간호",3,18]
[null,"A1495","은수저","남",65,1,"기초생활","방문간호",5,20]
[null,"A9810","이다음","남",89,2,"일반","방문간호",6,36]
[null,"A8952","사미인","여",67,1,"기초생활","방문목욕",4,40]
[null,"B6891","안태호","남",84,3,"일반","방문목욕",1,4]
[null,"C5822","도우미","여",80,4,"일반","방문목욕",2,12]
[null,"D1787","조용희","여",95,1,"일반","방문목욕",3,27]
[null,"D4877","양순호","남",82,1,"기타","방문목욕",6,54]
[null,"A7371","김장철","남",51,2,"기타","방문목욕",2,16]
[null,"D6171","강다구","남",77,1,"일반","방문목욕",7,70]
[null,"D4273","송준석","남",81,5,"일반","방문요양",4,24]
[null,"B7149","남호진","남",83,1,"기초생활","방문요양",1,4]
[null,"C1749","우태영","여",56,1,"기초생활","방문요양",6,54]
[null,"C3897","차주인","남",88,5,"기초생활","방문요양",7,28]
[null,"D1595","왕건이","남",64,5,"일반","방문요양",2,8]
[null,"A6220","윤철수","남",89,3,"기초생활","방문요양",1,4]
[null,"D6798","황국영","남",53,1,"기초생활","방문요양",5,45]

{"sheet":"기타작업-3","index":7,"n_rows":13,"n_cols":10,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"[표1] 서비스 예약 현황"]
[null,"환자번호","이름","성별","나이","수급자등급","수급자유형","서비스명",null,"수급자유형"]
[null,"K0541","홍길동","여자",50,5,"일반","방문목욕",null,"일반"]
[null,"S5125","이양훈","남자",92,2,"기타","방문목욕",null,"기타"]
[null,null,null,null,null,null,null,null,null,"기초생활"]
[]
[null,null,null,null,null,null,null,null,null,"서비스명"]
[null,null,null,null,null,null,null,null,null,"방문요양"]
[null,null,null,null,null,null,null,null,null,"방문목욕"]
[null,null,null,null,null,null,null,null,null,"방문간호"]
[null,null,null,null,null,null,null,null,null,"단기보호"]