{"text_format":"1","workbook":"xlsx","n_sheets":14,"sheets":["1월","2월","3월","4월","5월","6월","7월","8월","9월","10월","11월","12월","종합","세부항목"],"not_rendered":{"charts":2,"images":0,"macros":1,"external_links":0,"defined_names":31,"comments":12,"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":143,"n_cols":19,"rows_kept":143,"cut":false,"hidden":false,"merged":[[1,0,2,0],[3,0,20,0],[4,19,4,20],[4,22,4,25],[8,12,8,13],[8,16,8,17],[21,2,21,3],[28,20,28,21]]}
[]
["2020-01-10","전체보기","수입보기","날짜내림정렬","금액 \\ 표시하기",null,null,null,"노트"]
[null,"12월 이월금",null,"날짜오름정렬"]
["예산\n사용\n현황","지출내역","사용 예산","실사용금액","예산사용율","예산 잔액","초과 지출 소명"]
[null,"저축_투자",410000,{"$f":"SUMIF($C$25:$C$1000,B5,$F$25:$F$1000)","v":410000},{"$f":"D5/C5","v":1},{"$f":"C5-D5","v":0}]
[null,"주거",397500,365020,0.91828930817610066,32480]
[null,"식비",500000,535140,1.0702799999999999,-35140]
[null,"생활용품",50000,195040,3.9007999999999998,-145040]
[null,"의복_미용",30000,49000,1.6333333333333333,-19000,null,null,"주거",{"$f":"SUMIF($C$25:$C$1000,I9,$F$25:$F$1000)","v":365020},"전체",null,"수입내용",null,"비율",null,"고정지출",null,"비율"]
[null,"건강",50000,27900,0.55800000000000005,22100,null,null,"관리비",{"$f":"SUMIF($D$25:$D$1000,I10,$F$25:$F$1000)","v":113490},{"$f":"J10/$J$9","v":0.31091447043997589},null,"월급",{"$f":"SUMIF($D$25:$D$1000,M10,$F$25:$F$1000)","v":7138000},{"$f":"N10/N13","v":0.85638769479580712},null,"신한저축",{"$f":"SUMIF($D$25:$D$1000,Q10,$F$25:$F$1000)","v":0},{"$f":"R10/$R$17","v":0}]
[null,"자기계발",50000,85591,1.7118199999999999,-35591,null,null,"도시가스",66660,0.1826201304038135,null,"기타수입",{"$f":"SUMIF($D$25:$D$1000,M11,$F$25:$F$1000)","v":1197010},{"$f":"N11/N13","v":0.14361230520419291},null,"저축",{"$f":"SUMIF($D$25:$D$1000,Q11,$F$25:$F$1000)","v":410000},0.36531307776268013]
[null,"자동차",200000,160596,0.80298000000000003,39404,null,null,"대출이자",97160,0.2661771957700948,null,"이자",{"$f":"SUMIF($D$25:$D$1000,M12,$F$25:$F$1000)","v":0},{"$f":"N12/N13","v":0},null,"CCC",{"$f":"SUMIF($D$25:$D$1000,Q12,$F$25:$F$1000)","v":50000},4.4550375336912217E-2]
[null,"육아",200000,260980,1.3048999999999999,-60980,null,null,"수리/청소",0,0,null,"합계",{"$f":"SUM(N10:N12)","v":8335010},null,null,"손해보험",{"$f":"SUMIF($D$25:$D$1000,Q13,$F$25:$F$1000)","v":42718},3.8062058672844318E-2]
[null,"보험",42718,42718,1,0,null,null,"렌탈비",65800,0.18026409511807573,null,null,null,null,null,"교육비",{"$f":"SUMIF($D$25:$D$1000,Q14,$F$25:$F$1000)","v":132580},0.11812977524335642]
[null,"이벤트",50000,17000,0.34,33000,null,null,"KT인터넷",21910,6.0024108268040111E-2,null,null,null,null,null,"주거",{"$f":"SUMIF($C$26:$C$1000,Q15,$F$25:$F$1000)","v":182587},0.16268638763281582]
[null,"섬김비",250000,0,0,250000,null,null,null,null,null,null,null,null,null,null,"자동차",{"$f":"SUMIF($C$26:$C$1000,Q16,$F$25:$F$1000)","v":304440},0.27125832535139111]
[null,"헌금",300000,337000,1.1233333333333333,-37000,null,null,"식비",{"$f":"SUMIF($C$26:$C$1000,I17,$F$25:$F$1000)","v":845791},"전체",null,"자동차",{"$f":"SUMIF($C$26:$C$1000,M17,$F$25:$F$1000)","v":304440},"전체",null,"합계",{"$f":"SUM(R10:R16)","v":1122325}]
[null,"기부",115000,95000,0.82608695652173914,20000,null,null,"식자재",{"$f":"SUMIF($D$25:$D$1000,I18,$F$25:$F$1000)","v":421790},{"$f":"J18/$J$17","v":0.49869293950869659},null,"주유비",{"$f":"SUMIF($D$25:$D$1000,M18,$F$25:$F$1000)","v":150596},{"$f":"N18/$N$17","v":0.49466561555643146}]
[null,"통신비",120000,110870,0.92391666666666672,9130,null,null,"외식",{"$f":"SUMIF($D$25:$D$1000,I19,$F$25:$F$1000)","v":94700},{"$f":"J19/$J$17","v":0.11196619495832895},null,"택시비",{"$f":"SUMIF($D$25:$D$1000,M19,$F$25:$F$1000)","v":22100},{"$f":"N19/$N$17","v":7.2592300617527264E-2},null,"섬김비",{"$f":"SUMIF($D$25:$D$1000,Q19,$F$25:$F$1000)","v":0}]
[null,"기타",30000,30000,1,0,null,null,"간식비",{"$f":"SUMIF($D$25:$D$1000,I20,$F$25:$F$1000)","v":28850},{"$f":"J20/$J$17","v":3.4110081568614468E-2},null,"보험/세금",{"$f":"SUMIF($D$25:$D$1000,M20,$F$25:$F$1000)","v":0},{"$f":"N20/$N$17","v":0}]
[null,"합계",{"$f":"SUM(C5:C20)","v":2795218},{"$f":"SUM(D5:D20)","v":2721855},"예산-실사용금액",{"$f":"SUM(F5:F20)","v":73363},null,null,null,null,null,null,"주차/통행료",{"$f":"SUMIF($D$25:$D$1000,M21,$F$25:$F$1000)","v":0},{"$f":"N21/$N$17","v":0}]
[null,"총수입-총지출",{"$f":"N13-D21","v":5613155}]
[]
["날짜","계좌","대분류","소분류","내용","금액","수입지출"]
["2019-01-10","신한은행","식비","식자재","테스트",94690,"지출",""]
["2019-01-10","신한은행","수입","월급","테스트",2687110,"수입",""]
["2019-01-10","NH스마트 알림","기타","은행수수료","테스트",800,"지출",""]
["2019-01-10","신한은행","수입","기타수입","테스트",117010,"수입",""]
["2019-01-10","하나카드","주거","렌탈비","테스트",44900,"지출",""]
["2019-01-10","신한은행","기타","은행수수료","테스트",1000,"지출",""]
["2019-01-10","현금","육아","장난감","테스트",2000,"지출",""]
["2019-01-11","NH스마트 알림","저축_투자","저축","테스트",50000,"지출",""]
["2019-01-11","NH스마트 알림","저축_투자","저축","테스트",30000,"지출",""]
["2019-01-11","신한은행","전월카드지출","","테스트",87610,"지출",""]
["2019-01-11","신한은행","자동차","소모품/수리","테스트",10000,"지출",""]
["2019-01-11","신한은행","경조사","가족/친지","테스트",100000,"지출",""]
["2019-01-11","현금","기타","기타","테스트",2500,"지출",""]
["2019-01-11","NH스마트 알림","저축_투자","저축","테스트",30000,"지출",""]
["2019-01-12","현금","생활용품","기타용품","테스트",3700,"지출",""]
["2019-01-12","현금","육아","교육비","테스트",4000,"지출",""]
["2019-01-12","하나카드","주거","KT인터넷","테스트",21910,"지출",""]
["2019-01-12","하나카드","식비","간식비","테스트",900,"지출",""]
["2019-01-12","하나카드","식비","간식비","테스트",1800,"지출",""]
["2019-01-13","신한은행","식비","식자재","테스트",3000,"지출",""]
["2019-01-13","신한은행","식비","식자재","테스트",13810,"지출",""]
["2019-01-13","현금","헌금","셀모임","테스트",5000,"지출",""]
["2019-01-13","현금","헌금","주일헌금","테스트",2000,"지출",""]
["2019-01-13","현금","헌금","십일조","테스트",270000,"지출",""]
["2019-01-13","신한은행","육아","장난감","테스트",20000,"지출",""]
["2019-01-14","신한은행","자동차","주유비","테스트",40087,"지출",""]
["2019-01-14","신한은행","주거","대출이자","테스트",97160,"지출",""]
["2019-01-15","NH스마트 알림","기부","컨패션","테스트",45000,"지출",""]
["2019-01-15","NH스마트 알림","기부","CCC","테스트",50000,"지출",""]
["2019-01-15","NH스마트 알림","저축_투자","저축","테스트",300000,"지출",""]
["2019-01-15","하나카드","식비","식자재","테스트",9440,"지출",""]
["2019-01-15","하나카드","건강","병원/약국","테스트",2100,"지출",""]
["2019-01-15","하나카드","건강","병원/약국","테스트",2400,"지출",""]
["2019-01-16","하나카드","기타","택시비","테스트",3900,"지출",""]
["2019-01-16","하나카드","식비","식자재","테스트",23130,"지출",""]
["2019-01-16","하나카드","식비","식자재","테스트",25500,"지출",""]
["2019-01-16","신한은행","경조사","지인","테스트",19800,"지출",""]
["2019-01-16","하나카드","통신비","김인철","테스트",66410,"지출",""]
["2019-01-16","하나카드","통신비","김진령","테스트",44460,"지출",""]
["2019-01-17","하나카드","경조사","지인","테스트",37000,"지출",""]
["2019-01-18","하나카드","식비","식자재","테스트",2900,"지출",""]
["2019-01-19","신한은행","주거","도시가스","테스트",66660,"지출",""]
["2019-01-19","신한은행","식비","식자재","테스트",10420,"지출",""]
["2019-01-19","신한은행","식비","식자재","테스트",8000,"지출",""]
["2019-01-20","하나카드","식비","식자재","테스트",25880,"지출"]
["2019-01-20","하나카드","의복_미용","의류/잡화","테스트",39000,"지출",""]
["2019-01-21","신한은행","건강","병원/약국","테스트",7000,"지출",""]
["2019-01-21","신한은행","보험","손해보험","테스트",14210,"지출",""]
["2019-01-21","신한은행","보험","손해보험","테스트",14090,"지출",""]
["2019-01-21","하나카드","주거","렌탈비","테스트",20900,"지출",""]
["2019-01-22","하나카드","기타","택시비","테스트",4500,"지출",""]
["2019-01-22","하나카드","식비","외식","테스트",28300,"지출",""]
["2019-01-22","하나카드","기타","택시비","테스트",3700,"지출",""]
["2019-01-23","하나카드","기타","택시비","테스트",3400,"지출",""]
["2019-01-23","하나카드","식비","간식비","테스트",3200,"지출",""]
["2019-01-24","하나카드","식비","식자재","테스트",2480,"지출",""]
["2019-01-24","하나카드","식비","식자재","테스트",30380,"지출",""]
["2019-01-24","하나카드","자동차","주유비","테스트",36351,"지출",""]
["2019-01-24","하나카드","식비","식자재","테스트",140060,"지출",""]
["2019-01-24","하나카드","생활용품","기타용품","테스트",129500,"지출",""]
["2019-01-24","하나카드","식비","외식","테스트",4500,"지출",""]
["2019-01-24","하나카드","식비","외식","테스트",11500,"지출",""]
["2019-01-25","신한은행","수입","","테스트",100000,"수입",""]
["2019-01-25","신한은행","수입","기타수입","테스트",100000,"수입",""]
["2019-01-25","하나카드","생활용품","기타용품","테스트",17500,"지출",""]
["2019-01-25","하나카드","식비","","테스트",-10200,"지출",""]
["2019-01-25","하나카드","식비","식자재","테스트",10200,"지출",""]
["2019-01-26","신한은행","식비","외식","테스트",33000,"지출",""]
["2019-01-26","신한은행","생활용품","기타용품","테스트",3500,"지출",""]
["2019-01-27","신한은행","육아","육아용품","테스트",22400,"지출",""]
["2019-01-27","현금","수입","기타수입","테스트",100000,"수입",""]
["2019-01-27","현금","경조사","지인","테스트",20000,"지출",""]
["2019-01-27","현금","헌금","주일헌금","테스트",10000,"지출",""]
["2019-01-28","신한은행","식비","식자재","테스트",4000,"지출"]
["2019-01-28","신한은행","생활용품","기타용품","테스트",4500,"지출"]
["2019-01-28","하나카드","주거","관리비","테스트",113490,"지출"]
["2019-01-28","하나카드","기타","택시비","테스트",2800,"지출"]
["2019-01-28","하나카드","건강","병원/약국","테스트",2700,"지출"]
["2019-01-28","하나카드","건강","병원/약국","테스트",7100,"지출"]
["2019-01-29","신한은행","경조사","지인","테스트",4000,"지출"]
["2019-01-29","신한은행","육아","장난감","테스트",49000,"지출"]
["2019-01-29","하나카드","식비","식자재","테스트",8900,"지출"]
["2019-01-29","신한은행","자기계발","도서/문구","테스트",10250,"지출"]
["2019-01-29","신한은행","헌금","기타헌금","테스트",50000,"지출"]
["2019-01-29","신한은행","육아","육아용품","테스트",32400,"지출"]
["2019-01-30","삼성","자기계발","기타","테스트",75341,"지출"]
["2019-01-31","신한은행","생활용품","기타용품","테스트",10500,"지출"]
["2019-01-31","신한은행","수입","월급","테스트",4450890,"수입"]
["2019-01-31","하나카드","기타","택배비","테스트",3600,"지출"]
["2019-02-02","하나카드","생활용품","기타용품","테스트",25840,"지출"]
["2019-02-02","신한은행","식비","외식","테스트",1400,"지출"]
["2019-02-02","신한은행","식비","외식","테스트",12300,"지출"]
["2019-02-02","신한은행","식비","식자재","테스트",4500,"지출"]
["2019-02-02","신한은행","식비","외식","테스트",3700,"지출"]
["2019-02-02","하나카드","기타","택시비","테스트",3800,"지출"]
["2019-02-02","현금","의복_미용","세탁/수선","테스트",10000,"지출"]
["2019-02-03","신한은행","건강","병원/약국","테스트",6600,"지출"]
["2019-02-03","신한은행","식비","간식비","테스트",8400,"지출"]
["2019-02-03","신한은행","식비","간식비","테스트",5100,"지출"]
["2019-02-03","신한은행","식비","간식비","테스트",3000,"지출"]
["2019-02-03","하나카드","경조사","가족/친지","테스트",160000,"지출"]
["2019-02-03","하나카드","자동차","주유비","테스트",44021,"지출"]
["2019-02-04","신한은행","이벤트","놀이방","테스트",17000,"지출"]
["2019-02-04","신한은행","경조사","지인","테스트",20000,"지출"]
["2019-02-05","하나카드","보험","손해보험","테스트",14418,"지출"]
["2019-02-05","신한은행","육아","장난감","테스트",2600,"지출"]
["2019-02-05","현금","경조사","가족/친지","테스트",200000,"지출"]
["2019-02-05","현금","경조사","가족/친지","테스트",30000,"지출"]
["2019-02-05","현금","경조사","가족/친지","테스트",100000,"지출"]
["2019-02-05","현금","수입","기타수입","테스트",210000,"수입"]
["2019-02-05","현금","수입","기타수입","테스트",50000,"수입"]
["2019-02-05","현금","수입","기타수입","테스트",30000,"수입"]
["2019-02-05","현금","수입","기타수입","테스트",50000,"수입"]
["2019-02-05","현금","수입","기타수입","테스트",40000,"수입"]
["2019-02-06","신한은행","식비","식자재","테스트",4500,"지출"]
["2019-02-06","하나카드","식비","간식비","테스트",6450,"지출"]
["2019-02-06","하나카드","자동차","주유비","테스트",30137,"지출"]
["2019-02-07","NH스마트 알림","육아","교육비","테스트",128580,"지출"]
["2020-02-25","농협","수입","기타수입","LB휴넷 장모님 칠순 ",500000,"수입"]

{"sheet":"2월","index":1,"n_rows":106,"n_cols":22,"rows_kept":106,"cut":false,"hidden":false,"merged":[[1,0,2,0],[3,0,20,0],[4,19,4,20],[4,22,4,25],[8,12,8,13],[8,16,8,17],[21,2,21,3],[28,20,28,21]]}
[]
["2020-02-10","전체보기","수입보기","날짜내림정렬","금액 \\ 표시하기",null,null,null,"노트"]
[null,"1월 이월금",null,"날짜오름정렬"]
["예산\n사용\n현황","지출내역","사용 예산","실사용금액","예산사용율","예산 잔액","초과 지출 소명"]
[null,"저축_투자",410000,{"$f":"SUMIF($C$25:$C$1000,B5,$F$25:$F$1000)","v":110000},{"$f":"D5/C5","v":0.26829268292682928},{"$f":"C5-D5","v":300000}]
[null,"주거",397500,415900,1.0462893081761007,-18400]
[null,"식비",500000,726280,1.4525600000000001,-226280]
[null,"생활용품",50000,347010,6.9401999999999999,-297010]
[null,"의복_미용",30000,10000,0.33333333333333331,20000,null,null,"주거",{"$f":"SUMIF($C$25:$C$1000,I9,$F$25:$F$1000)","v":415900},"전체",null,"수입내용",null,"비율",null,"고정지출",null,"비율",null,"육아"]
[null,"건강",50000,45900,0.91800000000000004,4100,null,null,"관리비",{"$f":"SUMIF($D$25:$D$1000,I10,$F$25:$F$1000)","v":138680},{"$f":"J10/$J$9","v":0.3334455397932195},null,"월급",{"$f":"SUMIF($D$25:$D$1000,M10,$F$25:$F$1000)","v":2559570},{"$f":"N10/N13","v":0.92002357956485636},null,"신한저축",{"$f":"SUMIF($D$25:$D$1000,Q10,$F$25:$F$1000)","v":0},{"$f":"R10/$R$17","v":0},null,"육아용품",{"$f":"SUMIF($D$25:$D$1000,U10,$F$25:$F$1000)","v":0}]
[null,"자기계발",50000,141600,2.8319999999999999,-91600,null,null,"도시가스",{"$f":"SUMIF($D$25:$D$297,I11,$F$25:$F$1000)","v":95290},0.22911757634046645,null,"기타수입",{"$f":"SUMIF($D$25:$D$253,M11,$F$25:$F$1000)","v":222500},{"$f":"N11/N13","v":7.9976420435143622E-2},null,"저축",{"$f":"SUMIF($D$25:$D$1000,Q11,$F$25:$F$1000)","v":110000},3.5513885929398394E-2,null,"교육비",{"$f":"SUMIF($D$25:$D$1000,U11,$F$25:$F$1000)","v":60000}]
[null,"자동차",200000,83497,0.41748499999999999,116503,null,null,"대출이자",{"$f":"SUMIF($D$25:$D$1000,I12,$F$25:$F$1000)","v":88080},0.21178167828805,null,"이자",{"$f":"SUMIF($D$25:$D$253,M12,$F$25:$F$1000)","v":0},{"$f":"N12/N13","v":0},null,"CCC",{"$f":"SUMIF($D$25:$D$1000,Q12,$F$25:$F$1000)","v":95000},3.0671083302662251E-2,null,"장난감",{"$f":"SUMIF($D$25:$D$1000,U12,$F$25:$F$1000)","v":0}]
[null,"육아",200000,60000,0.3,140000,null,null,"수리/청소",{"$f":"SUMIF($D$25:$D$1000,I13,$F$25:$F$1000)","v":0},0,null,"합계",{"$f":"SUM(N10:N12)","v":2782070},null,null,"손해보험",{"$f":"SUMIF($D$25:$D$1000,Q13,$F$25:$F$1000)","v":27730},8.9527277892928869E-3,null,null,{"$f":"SUBTOTAL(9,V10:V12)","v":60000}]
[null,"보험",42718,27730,0.64914087738189985,14988,null,null,"렌탈비",{"$f":"SUMIF($D$25:$D$1000,I14,$F$25:$F$1000)","v":65800},0.15821110843952874,null,null,null,null,null,"교육비",{"$f":"SUMIF($D$25:$D$1000,Q14,$F$25:$F$1000)","v":60000},1.937121050694458E-2]
[null,"이벤트",50000,0,0,50000,null,null,"KT인터넷",{"$f":"SUMIF($D$25:$D$1000,I15,$F$25:$F$1000)","v":28050},6.7444097138735268E-2,null,null,null,null,null,"주거",{"$f":"SUMIF($C$26:$C$1000,Q15,$F$25:$F$1000)","v":2760320},0.89117899644215437]
[null,"섬김비",250000,32000,0.128,218000,null,null,null,null,null,null,null,null,null,null,"자동차",{"$f":"SUMIF($C$26:$C$1000,Q16,$F$25:$F$1000)","v":44330},1.4312096029547553E-2]
[null,"헌금",300000,250000,0.83333333333333337,50000,null,null,"식비",{"$f":"SUMIF($C$26:$C$1000,I17,$F$25:$F$1000)","v":1307500},"전체",null,"자동차",{"$f":"SUMIF($C$26:$C$1000,M17,$F$25:$F$1000)","v":44330},"전체",null,"합계",{"$f":"SUM(R10:R16)","v":3097380}]
[null,"기부",115000,95000,0.82608695652173914,20000,null,null,"식자재",{"$f":"SUMIF($D$25:$D$1000,I18,$F$25:$F$1000)","v":538290},{"$f":"J18/$J$17","v":0.41169407265774377},null,"주유비",{"$f":"SUMIF($D$25:$D$1000,M18,$F$25:$F$1000)","v":83497},{"$f":"N18/$N$17","v":1.8835325964358223}]
[null,"통신비",120000,193060,1.6088333333333333,-73060,null,null,"외식",{"$f":"SUMIF($D$25:$D$297,I19,$F$25:$F$1000)","v":138400},{"$f":"J19/$J$17","v":0.10585086042065009},null,"택시비",{"$f":"SUMIF($D$25:$D$1000,M19,$F$25:$F$1000)","v":0},{"$f":"N19/$N$17","v":0},null,"섬김비",{"$f":"SUMIF($D$25:$D$1000,Q19,$F$25:$F$1000)","v":0}]
[null,"기타",30000,51058,1.7019333333333333,-21058,null,null,"간식비",{"$f":"SUMIF($D$25:$D$297,I20,$F$25:$F$1000)","v":49590},{"$f":"J20/$J$17","v":3.792734225621415E-2},null,"보험/세금",{"$f":"SUMIF($D$25:$D$1000,M20,$F$25:$F$1000)","v":0},{"$f":"N20/$N$17","v":0}]
[null,"합계",{"$f":"SUM(C5:C20)","v":2795218},{"$f":"SUM(D5:D20)","v":2589035},"예산-실사용금액",{"$f":"SUM(F5:F20)","v":206183},null,null,null,null,null,null,"주차/통행료",{"$f":"SUMIF($D$25:$D$1000,M21,$F$25:$F$1000)","v":0},{"$f":"N21/$N$17","v":0}]
[null,"총수입-총지출",{"$f":"N13-D21","v":193035}]
[]
["날짜","계좌","대분류","소분류","내용","금액","수입지출"]
["2020-03-02","하나카드","건강","병원/약국","은파약국",17000,"지출",""]
["2020-02-29","하나카드","식비","식자재","두배로쇼핑",15150,"지출",""]
["2020-02-29","하나카드","식비","간식비","신일슈퍼",27340,"지출",""]
["2020-02-29","하나카드","식비","식자재","두배로쇼핑",34760,"지출",""]
["2020-02-28","신한은행","식비","외식","위메프커핑_피자",14900,"지출",""]
["2020-02-27","하나카드","식비","식자재","두배로쇼핑",21440,"지출",""]
["2020-02-27","하나카드","건강","병원/약국","은혜산부인과의원",21900,"지출",""]
["2020-02-27","신한은행","생활용품","기타용품","토스＿쿠팡 진령 좀약",14900,"지출",""]
["2020-02-26","신한은행","식비","외식","위메프커핑_갤치킨",13000,"지출",""]
["2020-02-26","하나카드","주거","관리비","아파트관리비",138680,"지출",""]
["2020-02-26","하나카드","식비","식자재","두배로쇼핑",16260,"지출",""]
["2020-02-25","신한은행","수입","기타수입","아동수당",100000,"수입",""]
["2020-02-25","하나카드","식비","식자재","두배로쇼핑",9510,"지출",""]
["2020-02-25","신한은행","수입","기타수입","양육수당",100000,"수입",""]
["2020-02-24","신한은행","생활용품","기타용품","토스＿쿠팡 아기용품",60750,"지출",""]
["2020-02-23","하나카드","식비","식자재","경선정육점",15000,"지출",""]
["2020-02-23","하나카드","식비","식자재","두배로쇼핑",23630,"지출",""]
["2020-02-23","하나카드","식비","식자재","두배로쇼핑",17830,"지출",""]
["2020-02-22","하나카드","자동차","주유비","에스제이상사국제충",41801,"지출",""]
["2020-02-22","신한은행","기타","은행수수료","대출이자",58,"지출",""]
["2020-02-21","신한은행","보험","손해보험","DB손",13520,"지출",""]
["2020-02-21","신한은행","보험","손해보험","DB손",14210,"지출",""]
["2020-02-20","신한은행","주거","도시가스","토스＿군산도시",95290,"지출",""]
["2020-02-20","하나카드","식비","식자재","두배로쇼핑",17540,"지출",""]
["2020-02-20","하나카드","식비","식자재","경선정육점",13000,"지출",""]
["2020-02-20","하나카드","식비","식자재","두배로쇼핑",22400,"지출",""]
["2020-02-20","신한은행","자기계발","문화생활","쿠팡 3d펜",84500,"지출",""]
["2020-02-20","하나카드","주거","렌탈비","엘지전자(주)렌탈케",20900,"지출",""]
["2020-02-19","하나카드","식비","식자재","두배로쇼핑",12150,"지출",""]
["2020-02-19","하나카드","건강","병원/약국","은파약국",7000,"지출",""]
["2020-02-19","하나카드","식비","식자재","삼거리정육점",8000,"지출",""]
["2020-02-17","신한은행","생활용품","기타용품","쿠팡 노트8 젤리케이스",2000,"지출",""]
["2020-02-17","신한은행","의복_미용","미용/헤어","토스＿이순화",10000,"지출",""]
["2020-02-16","신한은행","식비","외식","요기요 족발",35000,"지출",""]
["2020-02-16","신한","생활용품","가전/가구","11번가 제습기 ((8/12)) ",27220,"지출",""]
["2020-02-16","신한","생활용품","가전/가구","G마켓 재습기 ((8/12)) ",26600,"지출",""]
["2020-02-16","하나카드","식비","외식","김밥명가 교회 점심",20500,"지출",""]
["2020-02-16","신한은행","헌금","십일조","십일조",250000,"지출",""]
["2020-02-15","하나카드","생활용품","기타용품","한길문고 건전지",8800,"지출",""]
["2020-02-15","하나카드","자기계발","도서/문구","한길문고나운점",16000,"지출",""]
["2020-02-15","하나카드","자기계발","도서/문구","한길문고나운점",15000,"지출",""]
["2020-02-14","신한은행","기타","기타","토스＿권영만 빌려줌",50000,"지출",""]
["2020-02-14","신한은행","주거","대출이자","",88080,"지출",""]
["2020-02-13","신한은행","식비","외식","맥도날드_나이",17200,"지출",""]
["2020-02-13","신한은행","생활용품","기타용품","쿠팡",39040,"지출"]
["2020-02-13","하나카드","주거","KT인터넷","KT유선상품",28050,"지출",""]
["2020-02-13","신한은행","육아","교육비","토스＿（사）한 큐티정기구독",60000,"지출",""]
["2020-02-12","하나카드","식비","식자재","두배로쇼핑",30170,"지출",""]
["2020-02-12","신한은행","생활용품","기타용품","쿠팡",61030,"지출",""]
["2020-02-12","신한은행","식비","외식","요기요 비비큐",18000,"지출",""]
["2020-02-12","신한은행","생활용품","기타용품","쿠팡 생필픔",28530,"지출",""]
["2020-02-12","신한은행","생활용품","기타용품","쿠팡",40780,"지출",""]
["2020-02-12","신한은행","식비","식자재","쿠팡",46980,"지출",""]
["2020-02-12","신한은행","식비","식자재","쿠팡 고등어",26900,"지출",""]
["2020-02-12","하나카드","통신비","","LGU+통신요금자동서비스번호",86620,"지출",""]
["2020-02-12","하나카드","통신비","","LGU+통신요금자동서비스번호",106440,"지출",""]
["2020-02-12","신한은행","식비","식자재","토스＿전동식 신일청과",6700,"지출",""]
["2020-02-10","하나카드","식비","식자재","두배로쇼핑",31160,"지출",""]
["2020-02-10","하나카드","식비","식자재","경선정육점",13300,"지출",""]
["2020-02-10","신한은행","수입","월급","엘비휴넷(주)",2559570,"수입",""]
["2020-02-10","하나카드","주거","렌탈비","엘지전자(주)렌탈",44900,"지출",""]
["2020-02-10","신한","자기계발","도서/문구","리디북스",6500,"지출",""]
["2020-02-10","신한은행","섬김비","지인","토스＿천신지 이레씨",32000,"지출",""]
["2020-02-10","신한은행","기타","은행수수료","SMS",1000,"지출",""]
["2020-02-14","농협","수입","기타수입","공유기",22500,"수입",""]
["2020-02-11","농협","저축_투자","저축","3개통장",110000,"지출",""]
["2020-02-17","농협","기부","CCC","CCC/ 컨밴션",95000,"지출",""]
["2020-03-09","신한은행","식비","식자재","쿠팡 고등어 20마리",26500,"지출",""]
["2020-03-09","하나카드","자동차","주유비","에스제이상사국제",41696,"지출",""]
["2020-03-09","신한은행","자기계발","스터디","토스＿옥션김진 youtube준비",14880,"지출",""]
["2020-03-09","신한은행","식비","식자재","쿠팡",36900,"지출",""]
["2020-03-09","신한은행","생활용품","기타용품","토스＿쿠팡",37360,"지출",""]
["2020-03-08","하나카드","식비","외식","한국맥도날드(유)",19800,"지출",""]
["2020-03-08","하나카드","식비","간식비","신일슈퍼",22250,"지출"]
["2020-03-08","신한은행","수입","","쿠팡",8300,"수입"]
["2020-03-08","신한은행","식비","식자재","쿠팡",8300,"지출"]
["2020-03-05","신한은행","식비","식자재","쿠팡",10570,"지출"]
["2020-03-05","하나카드","식비","식자재","경선정육점",5500,"지출"]
["2020-03-05","하나카드","식비","식자재","두배로쇼핑",37180,"지출"]
["2020-03-04","신한은행","자기계발","문화생활","쿠팡 커튼 봉",4720,"지출"]
["2020-03-03","하나카드","식비","식자재","두배로쇼핑",9460,"지출"]
["2020-03-03","하나카드","식비","식자재","경선정육점",22000,"지출"]

{"sheet":"3월","index":2,"n_rows":170,"n_cols":22,"rows_kept":170,"cut":false,"hidden":false,"merged":[[1,0,2,0],[3,0,20,0],[4,19,4,20],[4,22,4,25],[8,12,8,13],[8,16,8,17],[21,2,21,3],[28,20,28,21]]}
[]
["2020-03-10","전체보기","수입보기","날짜내림정렬","금액 \\ 표시하기",null,null,null,"노트"]
[null,"2월 이월금",null,"날짜오름정렬"]
["예산\n사용\n현황","지출내역","사용 예산","실사용금액","예산사용율","예산 잔액","초과 지출 소명"]
[null,"저축_투자",410000,{"$f":"SUMIF($C$25:$C$1000,B5,$F$25:$F$1000)","v":100000},{"$f":"D5/C5","v":0.24390243902439024},{"$f":"C5-D5","v":310000}]
[null,"주거",397500,396850,0.99836477987421379,650]
[null,"식비",500000,936608,1.873216,-436608]
[null,"생활용품",50000,350530,7.0106000000000002,-300530]
[null,"의복_미용",30000,10000,0.33333333333333331,20000,null,null,"주거",{"$f":"SUMIF($C$25:$C$1000,I9,$F$25:$F$1000)","v":396850},"전체",null,"수입내용",null,"비율",null,"고정지출",null,"비율",null,"육아"]
[null,"건강",50000,637190,12.7438,-587190,"시원이심장진단",null,"관리비",{"$f":"SUMIF($D$25:$D$1000,I10,$F$25:$F$1000)","v":128930},{"$f":"J10/$J$9","v":0.32488345722565198},null,"월급",{"$f":"SUMIF($D$25:$D$1000,M10,$F$25:$F$1000)","v":3984860},{"$f":"N10/N13","v":0.82636583266800079},null,"신한저축",{"$f":"SUMIF($D$25:$D$1000,Q10,$F$25:$F$1000)","v":0},{"$f":"R10/$R$17","v":0},null,"육아용품",{"$f":"SUMIF($D$25:$D$1000,U10,$F$25:$F$1000)","v":228840}]
[null,"자기계발",50000,6500,0.13,43500,null,null,"도시가스",{"$f":"SUMIF($D$25:$D$297,I11,$F$25:$F$1000)","v":91670},0.23099407836714123,null,"기타수입",{"$f":"SUMIF($D$25:$D$253,M11,$F$25:$F$1000)","v":837000},{"$f":"N11/N13","v":0.17357402818244974},null,"저축",{"$f":"SUMIF($D$25:$D$1000,Q11,$F$25:$F$1000)","v":100000},0.2965687001393873,null,"교육비",{"$f":"SUMIF($D$25:$D$1000,U11,$F$25:$F$1000)","v":23000}]
[null,"자동차",200000,85092,0.42546,114908,null,null,"대출이자",{"$f":"SUMIF($D$25:$D$1000,I12,$F$25:$F$1000)","v":82400},0.20763512662214942,null,"이자",{"$f":"SUMIF($D$25:$D$253,M12,$F$25:$F$1000)","v":290},{"$f":"N12/N13","v":6.0139149549474822E-5},null,"CCC",{"$f":"SUMIF($D$25:$D$1000,Q12,$F$25:$F$1000)","v":50000},0.14828435006969365,null,"장난감",{"$f":"SUMIF($D$25:$D$1000,U12,$F$25:$F$1000)","v":64500}]
[null,"육아",200000,316340,1.5817000000000001,-116340,null,null,"수리/청소",{"$f":"SUMIF($D$25:$D$1000,I13,$F$25:$F$1000)","v":0},0,null,"합계",{"$f":"SUM(N10:N12)","v":4822150},null,null,"손해보험",{"$f":"SUMIF($D$25:$D$1000,Q13,$F$25:$F$1000)","v":27730},8.2238500548652102E-2,null,null,{"$f":"SUBTOTAL(9,V10:V12)","v":316340}]
[null,"보험",42718,27730,0.64914087738189985,14988,null,null,"렌탈비",{"$f":"SUMIF($D$25:$D$1000,I14,$F$25:$F$1000)","v":65800},0.16580572004535718,null,null,null,null,null,"교육비",{"$f":"SUMIF($D$25:$D$1000,Q14,$F$25:$F$1000)","v":23000},6.8210801032059079E-2]
[null,"이벤트",50000,0,0,50000,null,null,"KT인터넷",{"$f":"SUMIF($D$25:$D$1000,I15,$F$25:$F$1000)","v":28050},7.0681617739700137E-2,null,null,null,null,null,"주거",{"$f":"SUMIF($C$26:$C$1000,Q15,$F$25:$F$1000)","v":91060},0.27005545834692607]
[null,"섬김비",250000,11290,4.5159999999999999E-2,238710,null,null,null,null,null,null,null,null,null,null,"자동차",{"$f":"SUMIF($C$26:$C$1000,Q16,$F$25:$F$1000)","v":45400},0.13464218986328183]
[null,"헌금",300000,0,0,300000,null,null,"식비",{"$f":"SUMIF($C$26:$C$1000,I17,$F$25:$F$1000)","v":1909190},"전체",null,"자동차",{"$f":"SUMIF($C$26:$C$1000,M17,$F$25:$F$1000)","v":45400},"전체",null,"합계",{"$f":"SUM(R10:R16)","v":337190}]
[null,"기부",115000,95000,0.82608695652173914,20000,null,null,"식자재",{"$f":"SUMIF($D$25:$D$1000,I18,$F$25:$F$1000)","v":656180},{"$f":"J18/$J$17","v":0.3436954939005547},null,"주유비",{"$f":"SUMIF($D$25:$D$1000,M18,$F$25:$F$1000)","v":85092},{"$f":"N18/$N$17","v":1.874273127753304}]
[null,"통신비",120000,176330,1.4694166666666666,-56330,null,null,"외식",{"$f":"SUMIF($D$25:$D$297,I19,$F$25:$F$1000)","v":145055},{"$f":"J19/$J$17","v":7.5977246895280195E-2},null,"택시비",{"$f":"SUMIF($D$25:$D$1000,M19,$F$25:$F$1000)","v":0},{"$f":"N19/$N$17","v":0},null,"섬김비",{"$f":"SUMIF($D$25:$D$1000,Q19,$F$25:$F$1000)","v":0}]
[null,"기타",30000,17729,0.59096666666666664,12271,null,null,"간식비",{"$f":"SUMIF($D$25:$D$297,I20,$F$25:$F$1000)","v":91830},{"$f":"J20/$J$17","v":4.8098932007814829E-2},null,"보험/세금",{"$f":"SUMIF($D$25:$D$1000,M20,$F$25:$F$1000)","v":0},{"$f":"N20/$N$17","v":0}]
[null,"합계",{"$f":"SUM(C5:C20)","v":2795218},{"$f":"SUM(D5:D20)","v":3167189},"예산-실사용금액",{"$f":"SUM(F5:F20)","v":-371971},null,null,null,null,null,null,"주차/통행료",{"$f":"SUMIF($D$25:$D$1000,M21,$F$25:$F$1000)","v":0},{"$f":"N21/$N$17","v":0}]
[null,"총수입-총지출",{"$f":"N13-D21","v":1654961}]
[]
["날짜","계좌","대분류","소분류","내용","금액","수입지출"]
["2020-04-09","하나카드","식비","간식비","파리바게뜨군산나 상품권 +3000",3000,"지출",""]
["2020-04-09","하나카드","건강","병원/약국","하나약국",2000,"지출",""]
["2020-04-09","하나카드","식비","외식","GS25군산스카이점 진령 두유",15000,"지출",""]
["2020-04-09","하나카드","식비","외식","짜장면집",5000,"지출",""]
["2020-04-09","하나카드","건강","병원/약국","하나약국",9000,"지출",""]
["2020-04-09","하나카드","건강","병원/약국","군산우리들소아과의",5000,"지출",""]
["2020-04-09","하나카드","건강","병원/약국","군산우리들소아과의",-1200,"지출",""]
["2020-04-09","하나카드","건강","병원/약국","군산우리들소아과의",1200,"지출",""]
["2020-04-09","하나카드","식비","식자재","두배로쇼핑",10200,"지출",""]
["2020-04-09","하나카드","육아","육아용품","(주)와이식자재마 분유",44100,"지출",""]
["2020-04-08","하나카드","건강","병원/약국","해맑은연합소아청소 시원이 황달 진료비",6900,"지출",""]
["2020-04-08","하나카드","건강","병원/약국","힘찬온누리약국 손소독재",12000,"지출",""]
["2020-04-08","하나카드","식비","외식","버거킹군산조촌DT점",8900,"지출",""]
["2020-04-07","신한은행","생활용품","가전/가구","쿠팡 서브 모니터",139000,"지출",""]
["2020-04-07","신한은행","섬김비","가족/친지","쿠팡 뉴텔라 1kg 아버지 ㅎ",11290,"지출",""]
["2020-04-07","하나카드","식비","식자재","경선정육점",6000,"지출",""]
["2020-04-07","하나카드","식비","식자재","경선정육점",11000,"지출",""]
["2020-04-07","하나카드","식비","식자재","두배로쇼핑",6700,"지출",""]
["2020-04-07","하나카드","건강","병원/약국","은파약국",3000,"지출",""]
["2020-04-06","하나카드","자동차","주유비","에스제이상사국제",41450,"지출",""]
["2020-04-06","하나카드","식비","식자재","두배로쇼핑",4000,"지출",""]
["2020-04-05","하나카드","식비","외식","아이맘편의점",3900,"지출",""]
["2020-04-05","하나카드","건강","병원/약국","은혜산부인과의원",100000,"지출",""]
["2020-04-04","신한은행","식비","외식","요기요 가족 치킨",36000,"지출",""]
["2020-04-04","신한은행","식비","외식","아이맘편의점",2750,"지출",""]
["2020-04-04","신한은행","건강","병원/약국","다정한약국",3000,"지출",""]
["2020-04-03","신한은행","육아","교육비","햇님토이",23000,"지출",""]
["2020-04-03","신한은행","생활용품","가전/가구","쿠첸군산서비 수리비",40000,"지출",""]
["2020-04-02","신한은행","건강","병원/약국","은파약국",9000,"지출",""]
["2020-04-02","하나카드","육아","장난감","탑오피스",17200,"지출",""]
["2020-04-02","신한은행","식비","식자재","두배로쇼핑",6000,"지출",""]
["2020-04-02","신한은행","식비","간식비","빵지순례",4000,"지출",""]
["2020-04-02","신한은행","식비","식자재","두배로쇼핑",3900,"지출",""]
["2020-04-02","하나카드","건강","병원/약국","은혜산부인과의원",31100,"지출",""]
["2020-04-02","신한은행","육아","육아용품","토스＿쿠팡",20700,"지출",""]
["2020-04-01","신한은행","식비","간식비","신일슈퍼",5350,"지출",""]
["2020-03-31","신한은행","건강","병원/약국","중부약국",3000,"지출",""]
["2020-03-31","신한은행","건강","병원/약국","은파약국",3000,"지출",""]
["2020-03-30","신한은행","식비","식자재","두배로쇼핑",8240,"지출",""]
["2020-03-30","신한은행","육아","장난감","토스＿쿠팡 상원예원 선물 (셋째 출산)",47300,"지출",""]
["2020-03-29","신한은행","식비","식자재","두배로쇼핑",13500,"지출",""]
["2020-03-29","신한은행","식비","식자재","군산엑스마트",81350,"지출",""]
["2020-03-29","하나카드","식비","식자재","두배로쇼핑",-8080,"지출",""]
["2020-03-29","하나카드","식비","식자재","두배로쇼핑",5100,"지출",""]
["2020-03-29","하나카드","식비","식자재","두배로쇼핑",8080,"지출"]
["2020-03-29","신한은행","식비","간식비","신일슈퍼",17800,"지출",""]
["2020-03-28","신한은행","식비","식자재","쿠팡",3360,"지출",""]
["2020-03-28","신한은행","식비","식자재","두배로쇼핑",7780,"지출",""]
["2020-03-27","신한은행","식비","식자재","두배로쇼핑",5100,"지출",""]
["2020-03-27","신한은행","육아","육아용품","토스＿쿠팡",72910,"지출",""]
["2020-03-27","하나카드","식비","식자재","두배로쇼핑",8100,"지출",""]
["2020-03-26","하나카드","식비","간식비","빵지순례",6500,"지출",""]
["2020-03-26","하나카드","식비","식자재","경선정육점",6000,"지출",""]
["2020-03-26","하나카드","식비","식자재","두배로쇼핑",23650,"지출",""]
["2020-03-26","하나카드","의복_미용","미용/헤어","싹뚝",10000,"지출",""]
["2020-03-26","하나카드","건강","병원/약국","은혜산부인과의원",36600,"지출",""]
["2020-03-26","하나카드","건강","병원/약국","우주영상의학과의원",2500,"지출",""]
["2020-03-26","하나카드","기타","택배비","(주)한진",3500,"지출",""]
["2020-03-26","하나카드","주거","관리비","아파트관리비",128930,"지출",""]
["2020-03-25","하나카드","식비","간식비","신일슈퍼",2250,"지출",""]
["2020-03-25","하나카드","식비","식자재","두배로쇼핑",10500,"지출",""]
["2020-03-25","신한은행","기타","기타","토스＿박주일 로또 꽝",5500,"지출",""]
["2020-03-25","신한은행","수입","기타수입","아동수당",100000,"수입",""]
["2020-03-24","신한은행","식비","외식","위메프커핑_갤 똑복기",15905,"지출",""]
["2020-03-24","하나카드","식비","식자재","경선정육점",9000,"지출",""]
["2020-03-23","신한은행","보험","손해보험","DB손",14210,"지출",""]
["2020-03-23","신한은행","보험","손해보험","DB손",13520,"지출",""]
["2020-03-22","하나카드","식비","식자재","두배로쇼핑",5180,"지출",""]
["2020-03-22","하나카드","식비","식자재","경선정육점",6000,"지출",""]
["2020-03-22","하나카드","식비","간식비","신일슈퍼",4400,"지출",""]
["2020-03-22","하나카드","식비","식자재","두배로쇼핑",35000,"지출",""]
["2020-03-22","신한은행","육아","육아용품","토스＿쿠팡",34730,"지출",""]
["2020-03-22","신한은행","육아","육아용품","토스＿쿠팡",42400,"지출",""]
["2020-03-21","하나카드","자동차","주유비","에스제이상사국제",43642,"지출"]
["2020-03-21","신한은행","식비","간식비","신일슈퍼",2250,"지출"]
["2020-03-21","하나카드","식비","식자재","두배로쇼핑",3750,"지출"]
["2020-03-21","신한은행","기타","은행수수료","대출이자",1329,"지출"]
["2020-03-21","신한은행","수입","이자","예금이자",290,"수입"]
["2020-03-20","신한은행","생활용품","기타용품","토스＿11번가, 욕실매트",89760,"지출"]
["2020-03-20","신한은행","생활용품","기타용품","쿠팡 테이프",10000,"지출"]
["2020-03-20","신한은행","기타","기타","쿠팡와우월회비",2900,"지출"]
["2020-03-20","신한은행","생활용품","기타용품","쿠팡",20150,"지출"]
["2020-03-20","신한은행","생활용품","기타용품","쿠팡",15900,"지출"]
["2020-03-20","신한은행","생활용품","기타용품","쿠팡",62320,"지출"]
["2020-03-20","하나카드","주거","렌탈비","엘지전자(주)렌탈",20900,"지출"]
["2020-03-20","하나카드","식비","식자재","두배로쇼핑",7500,"지출"]
["2020-03-19","하나카드","식비","식자재","두배로쇼핑",13730,"지출"]
["2020-03-19","하나카드","식비","간식비","빵지순례",3000,"지출"]
["2020-03-19","하나카드","식비","","우리들소아청소년과",4800,"지출"]
["2020-03-19","하나카드","건강","병원/약국","은혜산부인과의원",10600,"지출"]
["2020-03-19","신한은행","주거","도시가스","토스＿군산도시",91670,"지출"]
["2020-03-19","하나카드","식비","간식비","이마트24군산미공군",1200,"지출"]
["2020-03-19","하나카드","기타","택배비","(주)한진",3500,"지출"]
["2020-03-18","하나카드","식비","식자재","경선정육점",11000,"지출"]
["2020-03-18","하나카드","식비","간식비","신일슈퍼",9000,"지출"]
["2020-03-18","하나카드","식비","간식비","빵지순례",7000,"지출"]
["2020-03-18","하나카드","건강","병원/약국","원광대학교병원",68500,"지출"]
["2020-03-18","하나카드","건강","병원/약국","원광대학교병원",23600,"지출"]
["2020-03-18","하나카드","건강","병원/약국","전북대학교병원컬러",12800,"지출"]
["2020-03-18","하나카드","건강","병원/약국","전북대학교병원",48800,"지출"]
["2020-03-18","하나카드","식비","외식","한국맥도날드(유)군",29100,"지출"]
["2020-03-18","신한은행","육아","육아용품","토스＿이소연 젖병",14000,"지출"]
["2020-03-17","하나카드","식비","간식비","빵지순례",7500,"지출"]
["2020-03-17","하나카드","식비","식자재","두배로쇼핑",3980,"지출"]
["2020-03-17","하나카드","식비","간식비","신일슈퍼",2280,"지출"]
["2020-03-16","신한은행","주거","대출이자","",82400,"지출"]
["2020-03-16","신한","식비","","11번가 제습기 ((9/12)) ",27220,"지출"]
["2020-03-16","신한","생활용품","가전/가구","G마켓 재습기 ((9/12)) ",-26600,"지출"]
["2020-03-15","하나카드","식비","식자재","경선정육점",12000,"지출"]
["2020-03-15","하나카드","식비","간식비","신일슈퍼",2250,"지출"]
["2020-03-15","하나카드","식비","외식","한국맥도날드(유)군",28500,"지출"]
["2020-03-14","하나카드","식비","식자재","두배로쇼핑",70000,"지출"]
["2020-03-14","신한은행","식비","식자재","쿠팡",13300,"지출"]
["2020-03-14","하나카드","식비","간식비","신일슈퍼",10250,"지출"]
["2020-03-14","하나카드","식비","간식비","신일슈퍼",3800,"지출"]
["2020-03-14","하나카드","식비","식자재","두배로쇼핑",43240,"지출"]
["2020-03-14","신한은행","식비","식자재","쿠팡",9400,"지출"]
["2020-03-13","신한은행","식비","식자재","쿠팡",20320,"지출"]
["2020-03-13","신한은행","식비","식자재","쿠팡",13020,"지출"]
["2020-03-13","신한은행","식비","","토스＿김인철",163,"지출"]
["2020-03-13","신한은행","식비","","토스＿김시윤",11360,"지출"]
["2020-03-13","하나카드","주거","KT인터넷","KT유선상품",28050,"지출"]
["2020-03-12","하나카드","식비","식자재","경선정육점",12800,"지출"]
["2020-03-12","하나카드","식비","식자재","두배로쇼핑",1200,"지출"]
["2020-03-12","하나카드","식비","식자재","두배로쇼핑",2880,"지출"]
["2020-03-12","하나카드","건강","병원/약국","은혜산부인과의원",80600,"지출"]
["2020-03-12","하나카드","식비","식자재","두배로쇼핑",28740,"지출"]
["2020-03-11","신한은행","식비","식자재","카드",74100,"지출"]
["2020-03-11","하나카드","통신비","","LGU+통신요금자동서비스번호",62830,"지출"]
["2020-03-11","하나카드","통신비","","LGU+통신요금자동서비스번호",113500,"지출"]
["2020-03-10","신한은행","수입","월급","엘비휴넷㈜ 연말정산",3984860,"수입"]
["2020-03-10","신한","자기계발","도서/문구","리디북스",6500,"지출"]
["2020-03-10","신한은행","기타","은행수수료","SMS",1000,"지출"]
["2020-03-10","하나카드","주거","렌탈비","엘지전자(주)렌탈",44900,"지출"]
["2020-03-10","하나카드","식비","식자재","경선정육점",5500,"지출"]
["2020-03-10","하나카드","식비","식자재","두배로쇼핑",8160,"지출"]
["2020-03-10","하나카드","식비","식자재","경선정육점",12500,"지출"]
["2020-03-11","농협","저축_투자","저축","3개통장",100000,"지출"]
["2020-03-16","농협","기부","CCC","ccc",50000,"지출"]
["2020-03-16","농협","기부","컨패션","컨팬션",45000,"지출"]
["2020-03-19","농협","수입","기타수입","공유기",37000,"수입"]
["2020-04-03","농협","수입","기타수입","출산축하, 김광수",300000,"수입"]
["2020-04-04","농협","수입","기타수입","출산축하, 박시형",100000,"수입"]
["2020-04-05","농협","수입","기타수입","출산축하, 김현철",300000,"수입"]
["2020-04-08","군산사랑","식비","식자재","두배로쇼핑",13400,"지출"]
["2020-04-08","군산사랑","건강","병원/약국","은혜산부인과의원",166190,"지출"]

{"sheet":"4월","index":3,"n_rows":114,"n_cols":22,"rows_kept":114,"cut":false,"hidden":false,"merged":[[1,0,2,0],[3,0,20,0],[4,19,4,20],[4,22,4,25],[8,12,8,13],[8,16,8,17],[21,2,21,3],[28,20,28,21]]}
[]
["2020-04-10","전체보기","수입보기","날짜내림정렬","금액 \\ 표시하기",null,null,null,"노트"]
[null,"3월 이월금",null,"날짜오름정렬"]
["예산\n사용\n현황","지출내역","사용 예산","실사용금액","예산사용율","예산 잔액","초과 지출 소명"]
[null,"저축_투자",410000,{"$f":"SUMIF($C$25:$C$999,B5,$F$25:$F$999)","v":0},{"$f":"D5/C5","v":0},{"$f":"C5-D5","v":410000}]
[null,"주거",397500,322220,0.81061635220125783,75280]
[null,"식비",500000,652840,1.30568,-152840]
[null,"생활용품",50000,25820,0.51639999999999997,24180]
[null,"의복_미용",30000,135900,4.53,-105900,"시원이 출산",null,"주거",{"$f":"SUMIF($C$25:$C$999,I9,$F$25:$F$999)","v":322220},"전체",null,"수입내용",null,"비율",null,"고정지출",null,"비율",null,"육아"]
[null,"건강",50000,20100,0.40200000000000002,29900,null,null,"관리비",{"$f":"SUMIF($D$25:$D$999,I10,$F$25:$F$999)","v":139470},{"$f":"J10/$J$9","v":0.43284091614424924},null,"월급",{"$f":"SUMIF($D$25:$D$999,M10,$F$25:$F$999)","v":2559570},{"$f":"N10/N13","v":0.74665044762796562},null,"신한저축",{"$f":"SUMIF($D$25:$D$999,Q10,$F$25:$F$999)","v":0},{"$f":"R10/$R$17","v":0},null,"육아용품",{"$f":"SUMIF($D$25:$D$999,U10,$F$25:$F$999)","v":181590}]
[null,"자기계발",50000,6500,0.13,43500,null,null,"도시가스",{"$f":"SUMIF($D$25:$D$296,I11,$F$25:$F$999)","v":820},2.5448451368630127E-3,null,"기타수입",{"$f":"SUMIF($D$25:$D$252,M11,$F$25:$F$999)","v":868500},{"$f":"N11/N13","v":0.25334955237203444},null,"저축",{"$f":"SUMIF($D$25:$D$999,Q11,$F$25:$F$999)","v":0},0,null,"교육비",{"$f":"SUMIF($D$25:$D$999,U11,$F$25:$F$999)","v":74000}]
[null,"자동차",200000,41036,0.20518,158964,null,null,"대출이자",{"$f":"SUMIF($D$25:$D$999,I12,$F$25:$F$999)","v":88080},0.27335360933523678,null,"이자",{"$f":"SUMIF($D$25:$D$252,M12,$F$25:$F$999)","v":0},{"$f":"N12/N13","v":0},null,"CCC",{"$f":"SUMIF($D$25:$D$999,Q12,$F$25:$F$999)","v":0},0,null,"장난감",{"$f":"SUMIF($D$25:$D$999,U12,$F$25:$F$999)","v":83000}]
[null,"육아",200000,338590,1.69295,-138590,null,null,"수리/청소",{"$f":"SUMIF($D$25:$D$999,I13,$F$25:$F$999)","v":0},0,null,"합계",{"$f":"SUM(N10:N12)","v":3428070},null,null,"손해보험",{"$f":"SUMIF($D$25:$D$999,Q13,$F$25:$F$999)","v":27730},0.1614556040756914,null,null,{"$f":"SUBTOTAL(9,V10:V12)","v":338590}]
[null,"보험",42718,27730,0.64914087738189985,14988,null,null,"렌탈비",{"$f":"SUMIF($D$25:$D$999,I14,$F$25:$F$999)","v":65800},0.20420830488486127,null,null,null,null,null,"교육비",{"$f":"SUMIF($D$25:$D$999,Q14,$F$25:$F$999)","v":74000},0.43085880640465796]
[null,"이벤트",50000,0,0,50000,null,null,"KT인터넷",{"$f":"SUMIF($D$25:$D$999,I15,$F$25:$F$999)","v":28050},8.7052324498789649E-2,null,null,null,null,null,"주거",{"$f":"SUMIF($C$26:$C$999,Q15,$F$25:$F$999)","v":41420},0.24116448326055312]
[null,"섬김비",250000,660500,2.6419999999999999,-410500,null,null,null,null,null,null,null,null,null,null,"자동차",{"$f":"SUMIF($C$26:$C$999,Q16,$F$25:$F$999)","v":28600},0.16652110625909752]
[null,"헌금",300000,200000,0.66666666666666663,100000,null,null,"식비",{"$f":"SUMIF($C$26:$C$999,I17,$F$25:$F$999)","v":1259772},"전체",null,"자동차",{"$f":"SUMIF($C$26:$C$999,M17,$F$25:$F$999)","v":28600},"전체",null,"합계",{"$f":"SUM(R10:R16)","v":171750}]
[null,"기부",115000,0,0,115000,null,null,"식자재",{"$f":"SUMIF($D$25:$D$999,I18,$F$25:$F$999)","v":493600},{"$f":"J18/$J$17","v":0.39181693195276607},null,"주유비",{"$f":"SUMIF($D$25:$D$999,M18,$F$25:$F$999)","v":41036},{"$f":"N18/$N$17","v":1.4348251748251748}]
[null,"통신비",120000,137680,1.1473333333333333,-17680,null,null,"외식",{"$f":"SUMIF($D$25:$D$296,I19,$F$25:$F$999)","v":135600},{"$f":"J19/$J$17","v":0.10763852506644059},null,"택시비",{"$f":"SUMIF($D$25:$D$999,M19,$F$25:$F$999)","v":0},{"$f":"N19/$N$17","v":0},null,"섬김비",{"$f":"SUMIF($D$25:$D$999,Q19,$F$25:$F$999)","v":0}]
[null,"기타",30000,14822,0.49406666666666665,15178,null,null,"간식비",{"$f":"SUMIF($D$25:$D$296,I20,$F$25:$F$999)","v":23640},{"$f":"J20/$J$17","v":1.8765300387689202E-2},null,"보험/세금",{"$f":"SUMIF($D$25:$D$999,M20,$F$25:$F$999)","v":0},{"$f":"N20/$N$17","v":0}]
[null,"합계",{"$f":"SUM(C5:C20)","v":2795218},{"$f":"SUM(D5:D20)","v":2583738},"예산-실사용금액",{"$f":"SUM(F5:F20)","v":211480},null,null,null,null,null,null,"주차/통행료",{"$f":"SUMIF($D$25:$D$999,M21,$F$25:$F$999)","v":0},{"$f":"N21/$N$17","v":0}]
[null,"총수입-총지출",{"$f":"N13-D21","v":844332}]
[]
["날짜","계좌","대분류","소분류","내용","금액","수입지출"]
["2020-05-06","신한은행","육아","육아용품","토스＿쿠팡 예원이 쉬통",39380,"지출",""]
["2020-05-06","하나카드","식비","식자재","두배로쇼핑",26350,"지출",""]
["2020-05-06","하나카드","식비","식자재","경선정육점",6700,"지출",""]
["2020-05-05","신한은행","식비","외식","요기요",26500,"지출",""]
["2020-05-03","하나카드","식비","식자재","두배로쇼핑",24090,"지출",""]
["2020-05-02","신한은행","육아","육아용품","토스＿쿠팡 예원이 선캡",8500,"지출",""]
["2020-05-02","하나카드","식비","식자재","경선정육점",17000,"지출",""]
["2020-05-01","하나카드","식비","식자재","두배로쇼핑",19860,"지출",""]
["2020-04-30","신한은행","육아","육아용품","쿠팡 보솜이 기저귀2단계 ",39800,"지출",""]
["2020-04-30","하나카드","식비","식자재","두배로쇼핑",28090,"지출",""]
["2020-04-30","하나카드","식비","식자재","두배로쇼핑",4050,"지출",""]
["2020-04-28","신한은행","육아","장난감","쿠팡 상원이 레고 5월5일 용",47500,"지출",""]
["2020-04-28","하나카드","식비","식자재","두배로쇼핑",5050,"지출",""]
["2020-04-28","하나카드","식비","식자재","경선정육점",28600,"지출",""]
["2020-04-28","하나카드","자동차","주유비","에스제이상사국제충",41036,"지출",""]
["2020-04-28","신한은행","육아","장난감","쿠팡 예원이 콩순이 냉장고",35500,"지출",""]
["2020-04-27","신한은행","육아","육아용품","쿠팡 손세정네",10300,"지출",""]
["2020-04-27","하나카드","식비","외식","한국맥도날드(유)군",17100,"지출",""]
["2020-04-27","하나카드","주거","관리비","아파트관리비",139470,"지출",""]
["2020-04-26","하나카드","식비","식자재","두배로쇼핑",25260,"지출",""]
["2020-04-26","하나카드","식비","식자재","두배로쇼핑",7960,"지출",""]
["2020-04-26","신한은행","식비","식자재","경선정육점",22800,"지출",""]
["2020-04-25","신한은행","식비","식자재","두배로쇼핑",7800,"지출",""]
["2020-04-25","신한은행","육아","육아용품","토스＿정세희 아기띠 중고나라",33000,"지출",""]
["2020-04-25","신한은행","식비","외식","요기요",19900,"지출",""]
["2020-04-25","신한은행","건강","병원/약국","하나약국",6000,"지출",""]
["2020-04-25","신한은행","건강","병원/약국","군산우리들소아",1100,"지출",""]
["2020-04-24","신한은행","식비","식자재","두배로쇼핑",9180,"지출",""]
["2020-04-24","신한은행","의복_미용","미용/헤어","싹뚝",7000,"지출",""]
["2020-04-24","신한은행","식비","식자재","삼거리정육점",6000,"지출",""]
["2020-04-24","신한은행","수입","기타수입","아동수당",100000,"수입",""]
["2020-04-23","신한은행","식비","식자재","두배로쇼핑",12250,"지출",""]
["2020-04-23","신한은행","식비","간식비","정읍떡집",9000,"지출",""]
["2020-04-23","신한은행","주거","도시가스","토스＿군산도시",820,"지출",""]
["2020-04-21","신한은행","보험","손해보험","DB손",13520,"지출",""]
["2020-04-21","신한은행","보험","손해보험","DB손",14210,"지출",""]
["2020-04-21","신한은행","의복_미용","의류/잡화","네이버페이결제 운동화",118900,"지출",""]
["2020-04-21","신한은행","기타","택배비","(주)한진",3500,"지출",""]
["2020-04-20","신한은행","기타","기타","쿠팡와우월회비",2900,"지출",""]
["2020-04-20","하나카드","주거","렌탈비","엘지전자(주)렌탈케",20900,"지출",""]
["2020-04-18","신한은행","기타","은행수수료","대출이자",5122,"지출",""]
["2020-04-17","신한은행","식비","외식","요기요",18000,"지출",""]
["2020-04-17","신한은행","의복_미용","미용/헤어","토스＿이순화",10000,"지출",""]
["2020-04-17","신한은행","섬김비","지인","떡향 상원이 출생기념",60000,"지출",""]
["2020-04-17","신한은행","식비","식자재","두배로쇼핑",32300,"지출"]
["2020-04-17","신한은행","식비","식자재","㈜이마트에브리",9900,"지출",""]
["2020-04-17","신한은행","육아","육아용품","쿠팡 분유",50610,"지출",""]
["2020-04-16","신한은행","식비","식자재","두배로쇼핑",21410,"지출",""]
["2020-04-16","신한은행","식비","식자재","두배로쇼핑",6250,"지출",""]
["2020-04-16","하나카드","주거","렌탈비","엘지전자(주)렌탈케",44900,"지출",""]
["2020-04-16","신한","생활용품","가전/가구","11번가 제습기 ((10/12)) ",27220,"지출",""]
["2020-04-16","신한","생활용품","가전/가구","G마켓 재습기 ((10/12)) ",-26600,"지출",""]
["2020-04-16","하나카드","주거","KT인터넷","KT유선상품",28050,"지출",""]
["2020-04-16","신한은행","기타","기타","GS25소룡상떼 바운서 나눔 과장",3300,"지출",""]
["2020-04-15","신한은행","식비","식자재","두배로쇼핑",32770,"지출",""]
["2020-04-14","신한은행","주거","대출이자","대출이자",88080,"지출",""]
["2020-04-14","신한은행","식비","식자재","두배로쇼핑",3900,"지출",""]
["2020-04-13","신한은행","식비","식자재","카드 ???",40400,"지출",""]
["2020-04-13","신한은행","식비","외식","요기요",18000,"지출",""]
["2020-04-13","신한은행","식비","간식비","신일슈퍼",8340,"지출",""]
["2020-04-13","신한은행","식비","외식","한국맥도날드",13600,"지출",""]
["2020-04-13","하나카드","통신비","김인철","LGU+통신요금자동서비스번호",103100,"지출",""]
["2020-04-13","하나카드","통신비","김진령","LGU+통신요금자동서비스번호",34580,"지출",""]
["2020-04-12","신한은행","식비","식자재","두배로쇼핑",4010,"지출",""]
["2020-04-12","신한은행","육아","교육비","햇님토이 상워니 예워니 선물",74000,"지출",""]
["2020-04-11","신한은행","건강","병원/약국","하나약국",3000,"지출",""]
["2020-04-11","신한은행","생활용품","기타용품","쿠팡 케이블",6700,"지출",""]
["2020-04-11","신한은행","생활용품","기타용품","쿠팡",18500,"지출",""]
["2020-04-11","신한은행","식비","간식비","주식회사와이 303호 과자",6300,"지출",""]
["2020-04-11","신한은행","식비","외식","한국맥도날드 303호 점심",22500,"지출",""]
["2020-04-11","하나카드","건강","병원/약국","군산우리들소아과의",5000,"지출",""]
["2020-04-10","신한","수입","월급","월급",2559570,"수입",""]
["2020-04-10","신한","자기계발","도서/문구","리디북스",6500,"지출"]
["2020-04-10","하나카드","건강","병원/약국","군산우리들소아과의",5000,"지출"]
["2020-04-17","농협","수입","기타수입","출산축하, 큰형님",300000,"수입"]
["2020-04-21","농협","수입","기타수입","공유기",18500,"수입"]
["2020-04-24","농협","수입","기타수입","아동수당",100000,"수입"]
["2020-04-24","농협","수입","기타수입","양육수당",200000,"수입"]
["2020-05-05","농협","수입","기타수입","김현철-어린이날선물비",100000,"수입"]
["2020-05-07","농협","섬김비","가족/친지","어버이날-처가",200500,"지출"]
["2020-05-07","농협","섬김비","가족/친지","어버이날-친가",400000,"지출"]
["2020-05-03","현금","헌금","기타헌금","감사헌금",200000,"지출"]
["2020-04-21","군산사랑","식비","식자재","두배로쇼핑",20880,"지출"]
["2020-04-21","군산사랑","식비","식자재","경선정육점",5800,"지출"]
["2020-04-19","군산사랑","식비","식자재","두배로쇼핑",19060,"지출"]
["2020-04-15","군산사랑","식비","식자재","두배로쇼핑",3980,"지출"]
["2020-04-15","군산사랑","식비","식자재","두배로쇼핑",9800,"지출"]
["2020-04-14","군산사랑","식비","식자재","두배로쇼핑",5400,"지출"]
["2020-04-14","군산사랑","식비","식자재","두배로쇼핑",26700,"지출"]
["2020-04-12","군산사랑","수입","기타수입","출산축하, 이동건집사님",50000,"수입"]

{"sheet":"5월","index":4,"n_rows":140,"n_cols":22,"rows_kept":140,"cut":false,"hidden":false,"merged":[[1,0,2,0],[3,0,20,0],[4,19,4,20],[4,22,4,25],[8,12,8,13],[8,16,8,17],[21,2,21,3],[28,20,28,21]]}
[]
["2020-05-10","전체보기","수입보기","날짜내림정렬","금액 \\ 표시하기",null,null,null,"노트"]
[null,"4월 이월금",null,"날짜오름정렬"]
["예산\n사용\n현황","지출내역","사용 예산","실사용금액","예산사용율","예산 잔액","초과 지출 소명"]
[null,"저축_투자",410000,{"$f":"SUMIF($C$25:$C$999,B5,$F$25:$F$999)","v":110000},{"$f":"D5/C5","v":0.26829268292682928},{"$f":"C5-D5","v":300000}]
[null,"주거",397500,447590,1.1260125786163522,-50090]
[null,"식비",500000,628440,1.25688,-128440]
[null,"생활용품",50000,114130,2.2826,-64130]
[null,"의복_미용",30000,17000,0.56666666666666665,13000,null,null,"주거",{"$f":"SUMIF($C$25:$C$999,I9,$F$25:$F$999)","v":447590},"전체",null,"수입내용",null,"비율",null,"고정지출",null,"비율",null,"육아"]
[null,"건강",50000,200300,4.0060000000000002,-150300,null,null,"관리비",{"$f":"SUMIF($D$25:$D$999,I10,$F$25:$F$999)","v":151050},{"$f":"J10/$J$9","v":0.33747402756987421},null,"월급",{"$f":"SUMIF($D$25:$D$999,M10,$F$25:$F$999)","v":2516970},{"$f":"N10/N13","v":0.53891150141206345},null,"신한저축",{"$f":"SUMIF($D$25:$D$999,Q10,$F$25:$F$999)","v":0},{"$f":"R10/$R$17","v":0},null,"육아용품",{"$f":"SUMIF($D$25:$D$999,U10,$F$25:$F$999)","v":490680}]
[null,"자기계발",50000,6500,0.13,43500,null,null,"도시가스",{"$f":"SUMIF($D$25:$D$296,I11,$F$25:$F$999)","v":117450},0.26240532630308988,null,"기타수입",{"$f":"SUMIF($D$25:$D$252,M11,$F$25:$F$999)","v":2153500},{"$f":"N11/N13","v":0.46108849858793655},null,"저축",{"$f":"SUMIF($D$25:$D$999,Q11,$F$25:$F$999)","v":110000},0.22503493155869422,null,"교육비",{"$f":"SUMIF($D$25:$D$999,U11,$F$25:$F$999)","v":65000}]
[null,"자동차",200000,86686,0.43342999999999998,113314,null,null,"대출이자",{"$f":"SUMIF($D$25:$D$999,I12,$F$25:$F$999)","v":85240},0.19044214571371121,null,"이자",{"$f":"SUMIF($D$25:$D$252,M12,$F$25:$F$999)","v":0},{"$f":"N12/N13","v":0},null,"CCC",{"$f":"SUMIF($D$25:$D$999,Q12,$F$25:$F$999)","v":0},0,null,"장난감",{"$f":"SUMIF($D$25:$D$999,U12,$F$25:$F$999)","v":30733}]
[null,"육아",200000,586413,2.9320650000000001,-386413,null,null,"수리/청소",{"$f":"SUMIF($D$25:$D$999,I13,$F$25:$F$999)","v":0},0,null,"합계",{"$f":"SUM(N10:N12)","v":4670470},null,null,"손해보험",{"$f":"SUMIF($D$25:$D$999,Q13,$F$25:$F$999)","v":25540},5.2249019563718642E-2,null,null,{"$f":"SUBTOTAL(9,V10:V12)","v":586413}]
[null,"보험",42718,25540,0.5978744323236107,17178,null,null,"렌탈비",{"$f":"SUMIF($D$25:$D$999,I14,$F$25:$F$999)","v":65800},0.14700953998078597,null,null,null,null,null,"교육비",{"$f":"SUMIF($D$25:$D$999,Q14,$F$25:$F$999)","v":65000},0.13297518683013751]
[null,"이벤트",50000,0,0,50000,null,null,"KT인터넷",{"$f":"SUMIF($D$25:$D$999,I15,$F$25:$F$999)","v":28050},6.2668960432538709E-2,null,null,null,null,null,"주거",{"$f":"SUMIF($C$26:$C$999,Q15,$F$25:$F$999)","v":80333},0.1643430105173144]
[null,"섬김비",250000,200050,0.80020000000000002,49950,null,null,null,null,null,null,null,null,null,null,"자동차",{"$f":"SUMIF($C$26:$C$999,Q16,$F$25:$F$999)","v":207940},0.42539785153013526]
[null,"헌금",300000,0,0,300000,null,null,"식비",{"$f":"SUMIF($C$26:$C$999,I17,$F$25:$F$999)","v":1078265},"전체",null,"자동차",{"$f":"SUMIF($C$26:$C$999,M17,$F$25:$F$999)","v":207940},"전체",null,"합계",{"$f":"SUM(R10:R16)","v":488813}]
[null,"기부",115000,0,0,115000,null,null,"식자재",{"$f":"SUMIF($D$25:$D$999,I18,$F$25:$F$999)","v":395360},{"$f":"J18/$J$17","v":0.3666631115727581},null,"주유비",{"$f":"SUMIF($D$25:$D$999,M18,$F$25:$F$999)","v":86686},{"$f":"N18/$N$17","v":0.41687986919303643}]
[null,"통신비",120000,247360,2.0613333333333332,-127360,null,null,"외식",{"$f":"SUMIF($D$25:$D$296,I19,$F$25:$F$999)","v":160000},{"$f":"J19/$J$17","v":0.14838652835805669},null,"택시비",{"$f":"SUMIF($D$25:$D$999,M19,$F$25:$F$999)","v":0},{"$f":"N19/$N$17","v":0},null,"섬김비",{"$f":"SUMIF($D$25:$D$999,Q19,$F$25:$F$999)","v":0}]
[null,"기타",30000,54218,1.8072666666666666,-24218,null,null,"간식비",{"$f":"SUMIF($D$25:$D$296,I20,$F$25:$F$999)","v":73080},{"$f":"J20/$J$17","v":6.7775546827542388E-2},null,"보험/세금",{"$f":"SUMIF($D$25:$D$999,M20,$F$25:$F$999)","v":0},{"$f":"N20/$N$17","v":0}]
[null,"합계",{"$f":"SUM(C5:C20)","v":2795218},{"$f":"SUM(D5:D20)","v":2724227},"예산-실사용금액",{"$f":"SUM(F5:F20)","v":70991},null,null,null,null,null,null,"주차/통행료",{"$f":"SUMIF($D$25:$D$999,M21,$F$25:$F$999)","v":0},{"$f":"N21/$N$17","v":0}]
[null,"총수입-총지출",{"$f":"N13-D21","v":1946243}]
[]
["날짜","계좌","대분류","소분류","내용","금액","수입지출"]
["2020-06-08","하나카드","식비","간식비","신일슈퍼",8550,"지출",""]
["2020-06-08","하나카드","기타","기타","엑스세대서점???",1000,"지출",""]
["2020-06-07","하나카드","식비","식자재","두배로쇼핑",5980,"지출",""]
["2020-06-07","하나카드","식비","간식비","빵지순례",2000,"지출",""]
["2020-06-07","하나카드","식비","간식비","빵지순례",13000,"지출",""]
["2020-06-07","하나카드","생활용품","기타용품","창조철물공고 싱크대 꼭지",10000,"지출",""]
["2020-06-07","하나카드","자동차","주유비","에스제이상사국제충",23820,"지출",""]
["2020-06-06","하나카드","식비","식자재","경선정육점",6000,"지출",""]
["2020-06-06","하나카드","식비","식자재","두배로쇼핑",16860,"지출",""]
["2020-06-06","하나카드","식비","외식","전설의스테이크갈비 시형네",66000,"지출",""]
["2020-06-05","신한","식비","식자재","긴급재난지원금두배로쇼핑",17800,"지출",""]
["2020-06-05","하나카드","기타","택배비","우정사업본부(우체국) 세승이 옷",4500,"지출",""]
["2020-06-04","신한","건강","병원/약국","군산우리들시원이 예방",130000,"지출",""]
["2020-06-03","신한은행","육아","육아용품","쿠팡",40800,"지출",""]
["2020-06-03","신한은행","육아","육아용품","쿠팡",26600,"지출",""]
["2020-06-03","신한","식비","식자재","두배로쇼핑",14000,"지출",""]
["2020-06-03","신한은행","수입","","삼성카드",17369,"수입",""]
["2020-06-02","신한","식비","식자재","두배로쇼핑",3580,"지출",""]
["2020-06-01","신한","식비","간식비","이마트24군",2500,"지출",""]
["2020-06-01","신한은행","생활용품","가전/가구","스마일페이",4750,"지출",""]
["2020-06-01","신한","식비","간식비","신일슈퍼",2850,"지출",""]
["2020-06-01","신한은행","육아","육아용품","김유진 젖병",10000,"지출",""]
["2020-05-31","신한","식비","식자재","경선정육점",12000,"지출",""]
["2020-05-31","신한","식비","식자재","두배로쇼핑",27970,"지출",""]
["2020-05-31","신한","식비","간식비","신일슈퍼",12950,"지출",""]
["2020-05-30","신한","식비","식자재","두배로쇼핑",43700,"지출",""]
["2020-05-30","신한은행","기타","기타","씨브이에스넷??",2600,"지출",""]
["2020-05-30","신한","건강","건강용품","긴급재난지원금안경나라군",60000,"지출",""]
["2020-05-30","신한","식비","외식","긴급재난지원금한국맥도날",22800,"지출",""]
["2020-05-30","신한","생활용품","","긴급재난지원금다이소나 정리하",31000,"지출",""]
["2020-05-29","신한","식비","외식","긴급재난지원금슈퍼떡볶킹",20000,"지출",""]
["2020-05-29","신한","식비","외식","긴급재난지원금CU변산해",10200,"지출",""]
["2020-05-29","신한","자동차","주유비","긴급재난지원금변산대박",34656,"지출",""]
["2020-05-29","신한","식비","외식","긴급재난지원금솜리닭집",18000,"지출",""]
["2020-05-29","신한","생활용품","기타용품","긴급재난지원금쿠첸군산",2000,"지출",""]
["2020-05-28","신한","식비","식자재","긴급재난지원금신일슈퍼",7700,"지출",""]
["2020-05-28","신한","식비","식자재","긴급재난지원금신일슈퍼",1700,"지출",""]
["2020-05-28","하나카드","육아","장난감","MojangABStockholmS 마크던전",24900,"지출",""]
["2020-05-27","신한","의복_미용","미용/헤어","긴급재난지원금싹뚝 상원",7000,"지출",""]
["2020-05-27","하나카드","주거","관리비","아파트관리비",151050,"지출",""]
["2020-05-27","신한","식비","식자재","긴급재난지원금두배로쇼핑",3980,"지출",""]
["2020-05-27","신한은행","육아","육아용품","쿠팡",4890,"지출",""]
["2020-05-26","신한","기타","기타","긴급재난지원금엑스세대서",12500,"지출",""]
["2020-05-26","신한","식비","식자재","긴급재난지원금두배로쇼핑",2500,"지출",""]
["2020-05-26","신한","식비","식자재","긴급재난지원금경선정육점",19300,"지출"]
["2020-05-26","신한","기타","기타","긴급재난지원금엑스세대서",19300,"지출",""]
["2020-05-26","신한은행","의복_미용","미용/헤어","토스＿이순화",10000,"지출",""]
["2020-05-25","신한은행","수입","","양육수당",100000,"수입",""]
["2020-05-25","신한은행","수입","기타수입","아동수당",100000,"수입",""]
["2020-05-25","하나카드","식비","식자재","경선정육점",6080,"지출",""]
["2020-05-25","신한","식비","식자재","긴급재난지원금두배로쇼핑",9500,"지출",""]
["2020-05-25","신한","식비","식자재","긴급재난지원금두배로쇼핑",13860,"지출",""]
["2020-05-24","신한","식비","식자재","긴급재난지원금두배로쇼핑",8700,"지출",""]
["2020-05-24","신한","식비","간식비","긴급재난지원금빵지순례",3500,"지출",""]
["2020-05-24","신한","식비","식자재","긴급재난지원금두배로쇼핑",17230,"지출",""]
["2020-05-23","신한","식비","식자재","긴급재난지원금두배로쇼핑",3540,"지출",""]
["2020-05-23","신한","식비","식자재","긴급재난지원금경선정육점",16300,"지출",""]
["2020-05-23","하나카드","식비","식자재","두배로쇼핑",7960,"지출",""]
["2020-05-23","신한","기타","기타","긴급재난지원금엑스세대서",5000,"지출",""]
["2020-05-23","신한","식비","식자재","긴급재난지원금좋은마트",9420,"지출",""]
["2020-05-23","신한은행","기타","은행수수료","대출이자",5418,"지출",""]
["2020-05-22","신한은행","육아","육아용품","쿠팡",8870,"지출",""]
["2020-05-22","신한","식비","식자재","긴급재난지원금신일슈퍼",12950,"지출",""]
["2020-05-22","신한","식비","식자재","긴급재난지원금신일슈퍼",11130,"지출",""]
["2020-05-22","신한","건강","병원/약국","긴급재난지원금으뜸정형외",10300,"지출",""]
["2020-05-22","신한","생활용품","","티머니개인",3300,"지출",""]
["2020-05-21","신한은행","주거","도시가스","토스＿군산도시",117450,"지출",""]
["2020-05-21","신한","식비","간식비","긴급재난지원금파리바게뜨",14150,"지출",""]
["2020-05-21","신한은행","보험","손해보험","DB손",11330,"지출",""]
["2020-05-21","신한은행","보험","손해보험","DB손",14210,"지출",""]
["2020-05-21","신한","식비","간식비","긴급재난지원금이마트24군",1200,"지출",""]
["2020-05-21","신한","식비","식자재","긴급재난지원금두배로쇼핑",6960,"지출",""]
["2020-05-21","신한은행","육아","육아용품","쿠팡",27500,"지출",""]
["2020-05-20","신한은행","육아","육아용품","쿠팡",11500,"지출"]
["2020-05-20","신한","식비","식자재","긴급재난지원금경선정육점",17000,"지출"]
["2020-05-20","신한은행","육아","육아용품","토스＿쿠팡",65060,"지출"]
["2020-05-20","신한","육아","교육비","긴급재난지원금나운스포츠 태권도 하복",65000,"지출"]
["2020-05-20","신한은행","기타","기타","쿠팡와우월회비",2900,"지출"]
["2020-05-20","삼성","육아","장난감","WWWROBLOXCOM",5833,"지출"]
["2020-05-20","하나카드","주거","렌탈비","엘지전자(주)렌탈케",20900,"지출"]
["2020-05-20","신한은행","육아","육아용품","쿠팡 분유",55710,"지출"]
["2020-05-18","하나카드","식비","식자재","두배로쇼핑",3790,"지출"]
["2020-05-18","신한은행","육아","육아용품","쿠팡",70310,"지출"]
["2020-05-16","신한","생활용품","가전/가구","11번가 제습기 ((11/12)) ",27220,"지출"]
["2020-05-16","신한","생활용품","가전/가구","G마켓 재습기 ((11/12)) ",-26600,"지출"]
["2020-05-16","하나카드","식비","식자재","두배로쇼핑",16540,"지출"]
["2020-05-15","하나카드","식비","간식비","이마트24군산미공군점",1100,"지출"]
["2020-05-15","하나카드","식비","간식비","신일슈퍼",9880,"지출"]
["2020-05-14","신한은행","육아","육아용품","쿠팡",22800,"지출"]
["2020-05-14","신한은행","육아","육아용품","토스＿쿠팡",26620,"지출"]
["2020-05-14","신한은행","주거","대출이자","",85240,"지출"]
["2020-05-13","신한은행","육아","육아용품","쿠팡",36580,"지출"]
["2020-05-13","하나카드","주거","KT인터넷","KT유선상품",28050,"지출"]
["2020-05-13","하나카드","통신비","김진령","LGU+통신요금자동서비스번호",59620,"지출"]
["2020-05-13","하나카드","통신비","김인철","LGU+통신요금자동서비스번호",187740,"지출"]
["2020-05-12","하나카드","자동차","주유비","에스제이상사국제",28210,"지출"]
["2020-05-12","농협","수입","기타수입","장모님 / 시원이 축하금^^",300000,"수입"]
["2020-05-12","신한은행","육아","육아용품","토스＿쿠팡",31500,"지출"]
["2020-05-11","하나카드","식비","외식","원조나포순대",23000,"지출"]
["2020-05-11","신한은행","육아","육아용품","토스＿쿠팡",51940,"지출"]
["2020-05-11","신한은행","식비","식자재","카드",33400,"지출"]
["2020-05-11","하나카드","식비","간식비","신일슈퍼",1400,"지출"]
["2020-05-11","신한은행","기타","은행수수료","SMS",1000,"지출"]
["2020-05-11","하나카드","주거","렌탈비","엘지전자(주)렌탈",44900,"지출"]
["2020-05-10","신한","자기계발","도서/문구","리디북스",6500,"지출"]
["2020-05-09","하나카드","식비","식자재","두배로쇼핑",17930,"지출"]
["2020-05-08","신한은행","수입","월급","엘비휴넷(주)",2516970,"수입"]
["2020-05-08","신한은행","생활용품","기타용품","쿠팡",9880,"지출"]
["2020-06-17","농협","생활용품","기타용품","이불정리함",52580,"지출"]
["2020-06-06","농협","수입","기타수입","박시형 군산 방문 후 용돈",200000,"수입"]
["2020-05-29","농협","수입","기타수입","최하늘",23500,"수입"]
["2020-05-31","농협","수입","기타수입","임정화",30000,"수입"]
["2020-05-19","농협","수입","기타수입","보건소산후조리",500000,"수입"]
["2020-05-15","농협","수입","기타수입","여성가족과",1000000,"수입"]
["2020-05-11","농협","저축_투자","저축","저축",110000,"지출"]
["2020-05-07","농협","섬김비","가족/친지","장모님 장인",200050,"지출"]

{"sheet":"6월","index":5,"n_rows":125,"n_cols":22,"rows_kept":125,"cut":false,"hidden":false,"merged":[[1,0,2,0],[3,0,20,0],[4,19,4,20],[4,22,4,25],[8,12,8,13],[8,16,8,17],[21,2,21,3],[28,20,28,21]]}
[]
["2020-06-10","전체보기","수입보기","날짜내림정렬","금액 \\ 표시하기",null,null,null,"노트"]
[null,"5월 이월금",null,"날짜오름정렬"]
["예산\n사용\n현황","지출내역","사용 예산","실사용금액","예산사용율","예산 잔액","초과 지출 소명"]
[null,"저축_투자",410000,{"$f":"SUMIF($C$25:$C$997,B5,$F$25:$F$997)","v":0},{"$f":"D5/C5","v":0},{"$f":"C5-D5","v":410000}]
[null,"주거",397500,407170,1.0243270440251573,-9670]
[null,"식비",500000,849340,1.69868,-349340]
[null,"생활용품",50000,437525,8.7505000000000006,-387525]
[null,"의복_미용",30000,17000,0.56666666666666665,13000,null,null,"주거",{"$f":"SUMIF($C$25:$C$997,I9,$F$25:$F$997)","v":407170},"전체",null,"수입내용",null,"비율",null,"고정지출",null,"비율",null,"육아"]
[null,"건강",50000,228044,4.56088,-178044,null,null,"관리비",{"$f":"SUMIF($D$25:$D$997,I10,$F$25:$F$997)","v":145270},{"$f":"J10/$J$9","v":0.35677972345703268},null,"월급",{"$f":"SUMIF($D$25:$D$997,M10,$F$25:$F$997)","v":2700640},{"$f":"N10/N13","v":0.96427011874493207},null,"신한저축",{"$f":"SUMIF($D$25:$D$997,Q10,$F$25:$F$997)","v":0},{"$f":"R10/$R$17","v":0},null,"육아용품",{"$f":"SUMIF($D$25:$D$997,U10,$F$25:$F$997)","v":131290}]
[null,"자기계발",50000,24143,0.48286000000000001,25857,null,null,"도시가스",{"$f":"SUMIF($D$25:$D$294,I11,$F$25:$F$997)","v":58660},0.14406758847655771,null,"기타수입",{"$f":"SUMIF($D$25:$D$250,M11,$F$25:$F$997)","v":100000},{"$f":"N11/N13","v":3.5705244636268889E-2},null,"저축",{"$f":"SUMIF($D$25:$D$997,Q11,$F$25:$F$997)","v":0},0,null,"교육비",{"$f":"SUMIF($D$25:$D$997,U11,$F$25:$F$997)","v":0}]
[null,"자동차",200000,35466,0.17732999999999999,164534,null,null,"대출이자",{"$f":"SUMIF($D$25:$D$997,I12,$F$25:$F$997)","v":82170},0.20180759879165949,null,"이자",{"$f":"SUMIF($D$25:$D$250,M12,$F$25:$F$997)","v":69},{"$f":"N12/N13","v":2.4636618799025532E-5},null,"CCC",{"$f":"SUMIF($D$25:$D$997,Q12,$F$25:$F$997)","v":0},0,null,"장난감",{"$f":"SUMIF($D$25:$D$997,U12,$F$25:$F$997)","v":240348}]
[null,"육아",200000,371638,1.85819,-171638,null,null,"수리/청소",{"$f":"SUMIF($D$25:$D$997,I13,$F$25:$F$997)","v":0},0,null,"합계",{"$f":"SUM(N10:N12)","v":2800709},null,null,"손해보험",{"$f":"SUMIF($D$25:$D$997,Q13,$F$25:$F$997)","v":137999},0.30146649219349048,null,null,{"$f":"SUBTOTAL(9,V10:V12)","v":371638}]
[null,"보험",42718,137999,3.2304649094058711,-95281,null,null,"렌탈비",{"$f":"SUMIF($D$25:$D$997,I14,$F$25:$F$997)","v":93020},0.22845494510892256,null,null,null,null,null,"교육비",{"$f":"SUMIF($D$25:$D$997,Q14,$F$25:$F$997)","v":0},0]
[null,"이벤트",50000,0,0,50000,null,null,"KT인터넷",{"$f":"SUMIF($D$25:$D$997,I15,$F$25:$F$997)","v":28050},6.8890144165827547E-2,null,null,null,null,null,"주거",{"$f":"SUMIF($C$26:$C$997,Q15,$F$25:$F$997)","v":305560},0.66751281788015093]
[null,"섬김비",250000,130900,0.52359999999999995,119100,null,null,null,null,null,null,null,null,null,null,"자동차",{"$f":"SUMIF($C$26:$C$997,Q16,$F$25:$F$997)","v":14200},3.1020689926358629E-2]
[null,"헌금",300000,0,0,300000,null,null,"식비",{"$f":"SUMIF($C$26:$C$997,I17,$F$25:$F$997)","v":1081938},"전체",null,"자동차",{"$f":"SUMIF($C$26:$C$997,M17,$F$25:$F$997)","v":14200},"전체",null,"합계",{"$f":"SUM(R10:R16)","v":457759}]
[null,"기부",115000,0,0,115000,null,null,"식자재",{"$f":"SUMIF($D$25:$D$997,I18,$F$25:$F$997)","v":649930},{"$f":"J18/$J$17","v":0.60070909793352301},null,"주유비",{"$f":"SUMIF($D$25:$D$997,M18,$F$25:$F$997)","v":35466},{"$f":"N18/$N$17","v":2.497605633802817}]
[null,"통신비",120000,120120,1.0009999999999999,-120,null,null,"외식",{"$f":"SUMIF($D$25:$D$294,I19,$F$25:$F$997)","v":53100},{"$f":"J19/$J$17","v":4.9078597849414658E-2},null,"택시비",{"$f":"SUMIF($D$25:$D$997,M19,$F$25:$F$997)","v":4000},{"$f":"N19/$N$17","v":0.28169014084507044},null,"섬김비",{"$f":"SUMIF($D$25:$D$997,Q19,$F$25:$F$997)","v":0}]
[null,"기타",30000,48916,1.6305333333333334,-18916,null,null,"간식비",{"$f":"SUMIF($D$25:$D$294,I20,$F$25:$F$997)","v":143010},{"$f":"J20/$J$17","v":0.13217947793681339},null,"보험/세금",{"$f":"SUMIF($D$25:$D$997,M20,$F$25:$F$997)","v":0},{"$f":"N20/$N$17","v":0}]
[null,"합계",{"$f":"SUM(C5:C20)","v":2795218},{"$f":"SUM(D5:D20)","v":2808261},"예산-실사용금액",{"$f":"SUM(F5:F20)","v":-13043},null,null,null,null,null,null,"주차/통행료",{"$f":"SUMIF($D$25:$D$997,M21,$F$25:$F$997)","v":0},{"$f":"N21/$N$17","v":0}]
[null,"총수입-총지출",{"$f":"N13-D21","v":-7552}]
[]
["날짜","계좌","대분류","소분류","내용","금액","수입지출"]
["2020-07-08","삼성","육아","장난감","Xsolla 로블록스 결제",24641,"지출",""]
["2020-07-08","신한은행","기타","기타","엑스세대서점",4000,"지출",""]
["2020-07-08","신한은행","기타","기타","엑스세대서점",2000,"지출",""]
["2020-07-08","신한은행","육아","장난감","쿠팡 예원이 핑크 머리핀",7900,"지출",""]
["2020-07-08","신한은행","육아","장난감","정지원 예원이 머리 띠",15560,"지출",""]
["2020-07-08","신한은행","육아","장난감","쿠팡 머리핑",10000,"지출",""]
["2020-07-08","신한은행","육아","장난감","쿠팡 머리띠 헤어",8900,"지출",""]
["2020-07-08","신한은행","육아","장난감","쿠팡 상원이 포켓몬 피규어",70000,"지출",""]
["2020-07-08","신한은행","식비","식자재","두배로쇼핑",6970,"지출",""]
["2020-07-06","신한은행","육아","장난감","쿠팡 크로마키 천",55837,"지출",""]
["2020-07-06","삼성","자기계발","문화생활","BINARYFORTRESS 바탕화면 프로그램",17643,"지출",""]
["2020-07-05","신한은행","섬김비","지인","요기요 피자",29900,"지출",""]
["2020-07-05","신한은행","생활용품","기타용품","쿠팡정기배송",86175,"지출",""]
["2020-07-04","신한은행","육아","육아용품","쿠팡 모이스쳐/ 세타필",51680,"지출",""]
["2020-07-04","신한은행","생활용품","기타용품","쿠팡 초강력 실리콘",5600,"지출",""]
["2020-07-04","신한은행","식비","식자재","쿠팡 멸치/굵은거 잔거",48300,"지출",""]
["2020-07-04","하나카드","식비","식자재","경선정육점",10000,"지출",""]
["2020-07-04","신한은행","의복_미용","미용/헤어","싹뚝",7000,"지출",""]
["2020-07-04","신한은행","식비","식자재","두배로쇼핑",17420,"지출",""]
["2020-07-03","신한은행","식비","간식비","명랑시대쌀핫도",3600,"지출",""]
["2020-07-02","신한은행","식비","식자재","쿠팡 김치",19900,"지출",""]
["2020-07-02","신한은행","식비","간식비","신일슈퍼",41300,"지출",""]
["2020-07-02","신한은행","건강","병원/약국","서현약국",2400,"지출",""]
["2020-07-02","신한은행","건강","병원/약국","양지산부인과",56900,"지출",""]
["2020-07-02","신한은행","기타","택시비","이비카드택시법",4000,"지출",""]
["2020-06-29","신한은행","육아","장난감","쿠팡헬로키티 핑크 큐션",17900,"지출",""]
["2020-06-29","하나카드","식비","식자재","두배로쇼핑",15000,"지출",""]
["2020-06-29","하나카드","식비","식자재","두배로쇼핑",19210,"지출",""]
["2020-06-27","신한은행","의복_미용","미용/헤어","이순화",10000,"지출",""]
["2020-06-27","신한은행","생활용품","기타용품","쿠팡 침대 방수 메트리스 커버",35800,"지출",""]
["2020-06-26","하나카드","식비","식자재","두배로쇼핑",22120,"지출",""]
["2020-06-26","하나카드","식비","식자재","경선정육점",11000,"지출",""]
["2020-06-26","신한","식비","간식비","신일슈퍼",13750,"지출",""]
["2020-06-26","신한","건강","병원/약국","다정한약국",58500,"지출",""]
["2020-06-26","신한","건강","병원/약국","다정한약국",13644,"지출",""]
["2020-06-26","신한은행","섬김비","지인","요기요",19000,"지출",""]
["2020-06-25","신한은행","식비","간식비","쿠팡 누탤라",10110,"지출",""]
["2020-06-25","신한은행","수입","기타수입","아동수당",100000,"수입",""]
["2020-06-25","하나카드","주거","관리비","아파트관리비",145270,"지출",""]
["2020-06-25","신한은행","수입","","양육수당",100000,"수입",""]
["2020-06-24","하나카드","식비","간식비","이마트24군산미공군점",4700,"지출",""]
["2020-06-24","현금","생활용품","가전/가구","2층침대",200000,"지출",""]
["2020-06-24","신한은행","생활용품","기타용품","쿠팡 수세미",14200,"지출"]
["2020-06-23","하나카드","자동차","주유비","에스제이상사국제충",35466,"지출",""]
["2020-06-23","삼성","보험","손해보험","DB손해보험 ((1/10)) ",112459,"지출",""]
["2020-06-23","하나카드","식비","식자재","군산엑스마트",172430,"지출",""]
["2020-06-22","신한","식비","식자재","두배로쇼핑",29180,"지출",""]
["2020-06-22","신한","식비","식자재","경선정육점",11000,"지출",""]
["2020-06-22","신한은행","생활용품","기타용품","쿠팡방향제",16650,"지출",""]
["2020-06-22","신한은행","보험","손해보험","DB손",11330,"지출",""]
["2020-06-22","신한은행","보험","손해보험","DB손",14210,"지출",""]
["2020-06-22","하나카드","주거","렌탈비","엘지전자(주)렌탈케",20900,"지출",""]
["2020-06-20","하나카드","식비","식자재","두배로쇼핑",11280,"지출",""]
["2020-06-20","하나카드","식비","","카페오라(CAFEORA)",3300,"지출",""]
["2020-06-20","신한은행","기타","기타","쿠팡와우월회비",2900,"지출",""]
["2020-06-20","하나카드","식비","식자재","두배로쇼핑",8230,"지출",""]
["2020-06-20","신한은행","기타","은행수수료","대출이자",16,"지출",""]
["2020-06-20","신한은행","수입","이자","예금이자",69,"수입",""]
["2020-06-19","신한","식비","식자재","경선정육점",26800,"지출",""]
["2020-06-19","신한은행","주거","도시가스","군산도시가스",58660,"지출",""]
["2020-06-18","신한은행","생활용품","기타용품","쿠팡 스마트폰 거치대",24400,"지출",""]
["2020-06-18","신한은행","육아","장난감","쿠팡",20710,"지출",""]
["2020-06-18","신한은행","식비","간식비","버거킹 (영재와)",44100,"지출",""]
["2020-06-18","하나카드","건강","병원/약국","코로나 검사",84600,"지출",""]
["2020-06-17","신한은행","섬김비","지인","요기요",14000,"지출",""]
["2020-06-17","신한은행","섬김비","지인","요기요",28000,"지출",""]
["2020-06-17","하나카드","기타","택배비","우정사업본부(우체국)",3500,"지출",""]
["2020-06-17","신한은행","생활용품","기타용품","쿠팡 공청 필터 2개",54300,"지출",""]
["2020-06-17","신한은행","식비","식자재","쿠팡 고등어 20마리",28500,"지출",""]
["2020-06-16","신한","주거","렌탈비","11번가 제습기 ((12/12)) ",27220,"지출",""]
["2020-06-16","신한","생활용품","가전/가구","G마켓 재습기 ((12/12)) ",-26600,"지출"]
["2020-06-15","신한은행","육아","육아용품","쿠팡 쪽쪽이",10900,"지출"]
["2020-06-15","신한","건강","병원/약국","다정한약국 진령 담",12000,"지출"]
["2020-06-15","하나카드","주거","KT인터넷","KT유선상품",28050,"지출"]
["2020-06-15","신한은행","주거","대출이자","",82170,"지출"]
["2020-06-14","신한","기타","기타","주식회사??",28000,"지출"]
["2020-06-14","신한","식비","간식비","신일슈퍼",8000,"지출"]
["2020-06-14","신한은행","섬김비","지인","요기요 명길 집사님댁과 함께",40000,"지출"]
["2020-06-13","신한","식비","외식","비에이치씨 치킨",18000,"지출"]
["2020-06-13","신한은행","육아","육아용품","쿠팡 올리브 기름",9210,"지출"]
["2020-06-13","신한","식비","식자재","두배로쇼핑",3950,"지출"]
["2020-06-13","신한","식비","간식비","신일슈퍼",13000,"지출"]
["2020-06-13","신한은행","생활용품","기타용품","쿠팡 비대",27000,"지출"]
["2020-06-12","신한은행","육아","장난감","쿠팡 식충식물",8900,"지출"]
["2020-06-12","신한은행","육아","육아용품","쿠팡 분유",59500,"지출"]
["2020-06-11","신한","식비","간식비","이마트24군",2200,"지출"]
["2020-06-11","신한은행","기타","택배비","(주)한진",3500,"지출"]
["2020-06-11","신한은행","식비","식자재","카드",36700,"지출"]
["2020-06-11","신한은행","식비","식자재","쿠팡 진령 식빵재료",26240,"지출"]
["2020-06-11","하나카드","통신비","","LGU+통신요금자동서비스번호",90510,"지출"]
["2020-06-11","하나카드","통신비","","LGU+통신요금자동서비스번호",29610,"지출"]
["2020-06-10","신한","식비","외식","한국맥도날",17100,"지출"]
["2020-06-10","신한","식비","외식","비에이치씨 치킨",18000,"지출"]
["2020-06-10","현금","식비","식자재","식자재 혜택 초기부담금",96000,"지출"]
["2020-06-10","하나카드","주거","렌탈비","엘지전자(주)렌탈",44900,"지출"]
["2020-06-10","신한은행","수입","월급","엘비휴넷(주)",2700640,"수입"]
["2020-06-10","신한","자기계발","도서/문구","리디북스",6500,"지출"]
["2020-06-10","신한","식비","식자재","경선정육점",12000,"지출"]
["2020-06-10","신한","식비","식자재","두배로쇼핑",17700,"지출"]
["2020-06-10","신한은행","기타","은행수수료","SMS",1000,"지출"]
["2020-06-10","신한","식비","간식비","신일슈퍼",2250,"지출"]

{"sheet":"7월","index":6,"n_rows":97,"n_cols":22,"rows_kept":97,"cut":false,"hidden":false,"merged":[[1,0,2,0],[3,0,20,0],[4,19,4,20],[4,22,4,25],[8,12,8,13],[8,16,8,17],[21,2,21,3],[28,20,28,21]]}
[]
["2020-07-10","전체보기","수입보기","날짜내림정렬","금액 \\ 표시하기",null,null,null,"노트"]
[null,"6월 이월금",null,"날짜오름정렬"]
["예산\n사용\n현황","지출내역","사용 예산","실사용금액","예산사용율","예산 잔액","초과 지출 소명"]
[null,"저축_투자",410000,{"$f":"SUMIF($C$25:$C$1000,B5,$F$25:$F$1000)","v":0},{"$f":"D5/C5","v":0},{"$f":"C5-D5","v":410000}]
[null,"주거",397500,0,0,397500]
[null,"식비",500000,0,0,500000]
[null,"생활용품",50000,0,0,50000]
[null,"의복_미용",30000,0,0,30000,null,null,"주거",{"$f":"SUMIF($C$25:$C$1000,I9,$F$25:$F$1000)","v":0},"전체",null,"수입내용",null,"비율",null,"고정지출",null,"비율",null,"육아"]
[null,"건강",50000,0,0,50000,null,null,"관리비",{"$f":"SUMIF($D$25:$D$1000,I10,$F$25:$F$1000)","v":0},{"$f":"J10/$J$9","v":{"$error":"#DIV/0!"}},null,"월급",{"$f":"SUMIF($D$25:$D$1000,M10,$F$25:$F$1000)","v":0},{"$f":"N10/N13","v":{"$error":"#DIV/0!"}},null,"신한저축",{"$f":"SUMIF($D$25:$D$1000,Q10,$F$25:$F$1000)","v":0},{"$f":"R10/$R$17","v":{"$error":"#DIV/0!"}},null,"육아용품",{"$f":"SUMIF($D$25:$D$1000,U10,$F$25:$F$1000)","v":0}]
[null,"자기계발",50000,0,0,50000,null,null,"도시가스",{"$f":"SUMIF($D$25:$D$297,I11,$F$25:$F$1000)","v":0},{"$error":"#DIV/0!"},null,"기타수입",{"$f":"SUMIF($D$25:$D$253,M11,$F$25:$F$1000)","v":0},{"$f":"N11/N13","v":{"$error":"#DIV/0!"}},null,"저축",{"$f":"SUMIF($D$25:$D$1000,Q11,$F$25:$F$1000)","v":0},{"$error":"#DIV/0!"},null,"교육비",{"$f":"SUMIF($D$25:$D$1000,U11,$F$25:$F$1000)","v":0}]
[null,"자동차",200000,0,0,200000,null,null,"대출이자",{"$f":"SUMIF($D$25:$D$1000,I12,$F$25:$F$1000)","v":0},{"$error":"#DIV/0!"},null,"이자",{"$f":"SUMIF($D$25:$D$253,M12,$F$25:$F$1000)","v":0},{"$f":"N12/N13","v":{"$error":"#DIV/0!"}},null,"CCC",{"$f":"SUMIF($D$25:$D$1000,Q12,$F$25:$F$1000)","v":0},{"$error":"#DIV/0!"},null,"장난감",{"$f":"SUMIF($D$25:$D$1000,U12,$F$25:$F$1000)","v":0}]
[null,"육아",200000,0,0,200000,null,null,"수리/청소",{"$f":"SUMIF($D$25:$D$1000,I13,$F$25:$F$1000)","v":0},{"$error":"#DIV/0!"},null,"합계",{"$f":"SUM(N10:N12)","v":0},null,null,"손해보험",{"$f":"SUMIF($D$25:$D$1000,Q13,$F$25:$F$1000)","v":0},{"$error":"#DIV/0!"},null,null,{"$f":"SUBTOTAL(9,V10:V12)","v":0}]
[null,"보험",42718,0,0,42718,null,null,"렌탈비",{"$f":"SUMIF($D$25:$D$1000,I14,$F$25:$F$1000)","v":0},{"$error":"#DIV/0!"},null,null,null,null,null,"교육비",{"$f":"SUMIF($D$25:$D$1000,Q14,$F$25:$F$1000)","v":0},{"$error":"#DIV/0!"}]
[null,"이벤트",50000,0,0,50000,null,null,"KT인터넷",{"$f":"SUMIF($D$25:$D$1000,I15,$F$25:$F$1000)","v":0},{"$error":"#DIV/0!"},null,null,null,null,null,"주거",{"$f":"SUMIF($C$26:$C$1000,Q15,$F$25:$F$1000)","v":0},{"$error":"#DIV/0!"}]
[null,"섬김비",250000,0,0,250000,null,null,null,null,null,null,null,null,null,null,"자동차",{"$f":"SUMIF($C$26:$C$1000,Q16,$F$25:$F$1000)","v":0},{"$error":"#DIV/0!"}]
[null,"헌금",300000,0,0,300000,null,null,"식비",{"$f":"SUMIF($C$26:$C$1000,I17,$F$25:$F$1000)","v":0},"전체",null,"자동차",{"$f":"SUMIF($C$26:$C$1000,M17,$F$25:$F$1000)","v":0},"전체",null,"합계",{"$f":"SUM(R10:R16)","v":0}]
[null,"기부",115000,0,0,115000,null,null,"식자재",{"$f":"SUMIF($D$25:$D$1000,I18,$F$25:$F$1000)","v":0},{"$f":"J18/$J$17","v":{"$error":"#DIV/0!"}},null,"주유비",{"$f":"SUMIF($D$25:$D$1000,M18,$F$25:$F$1000)","v":0},{"$f":"N18/$N$17","v":{"$error":"#DIV/0!"}}]
[null,"통신비",120000,0,0,120000,null,null,"외식",{"$f":"SUMIF($D$25:$D$297,I19,$F$25:$F$1000)","v":0},{"$f":"J19/$J$17","v":{"$error":"#DIV/0!"}},null,"택시비",{"$f":"SUMIF($D$25:$D$1000,M19,$F$25:$F$1000)","v":0},{"$f":"N19/$N$17","v":{"$error":"#DIV/0!"}},null,"섬김비",{"$f":"SUMIF($D$25:$D$1000,Q19,$F$25:$F$1000)","v":0}]
[null,"기타",30000,null,0,30000,null,null,"간식비",{"$f":"SUMIF($D$25:$D$297,I20,$F$25:$F$1000)","v":0},{"$f":"J20/$J$17","v":{"$error":"#DIV/0!"}},null,"보험/세금",{"$f":"SUMIF($D$25:$D$1000,M20,$F$25:$F$1000)","v":0},{"$f":"N20/$N$17","v":{"$error":"#DIV/0!"}}]
[null,"합계",{"$f":"SUM(C5:C20)","v":2795218},{"$f":"SUM(D5:D20)","v":0},"예산-실사용금액",{"$f":"SUM(F5:F20)","v":2795218},null,null,null,null,null,null,"주차/통행료",{"$f":"SUMIF($D$25:$D$1000,M21,$F$25:$F$1000)","v":0},{"$f":"N21/$N$17","v":{"$error":"#DIV/0!"}}]
[null,"총수입-총지출",{"$f":"N13-D21","v":0}]
[]
["날짜","계좌","대분류","소분류","내용","금액","수입지출"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]

{"sheet":"8월","index":7,"n_rows":97,"n_cols":22,"rows_kept":97,"cut":false,"hidden":false,"merged":[[1,0,2,0],[3,0,20,0],[4,19,4,20],[4,22,4,25],[8,12,8,13],[8,16,8,17],[21,2,21,3],[28,20,28,21]]}
[]
["2020-08-10","전체보기","수입보기","날짜내림정렬","금액 \\ 표시하기",null,null,null,"노트"]
[null,"7월 이월금",null,"날짜오름정렬"]
["예산\n사용\n현황","지출내역","사용 예산","실사용금액","예산사용율","예산 잔액","초과 지출 소명"]
[null,"저축_투자",410000,{"$f":"SUMIF($C$25:$C$1000,B5,$F$25:$F$1000)","v":0},{"$f":"D5/C5","v":0},{"$f":"C5-D5","v":410000}]
[null,"주거",397500,0,0,397500]
[null,"식비",500000,0,0,500000]
[null,"생활용품",50000,0,0,50000]
[null,"의복_미용",30000,0,0,30000,null,null,"주거",{"$f":"SUMIF($C$25:$C$1000,I9,$F$25:$F$1000)","v":0},"전체",null,"수입내용",null,"비율",null,"고정지출",null,"비율",null,"육아"]
[null,"건강",50000,0,0,50000,null,null,"관리비",{"$f":"SUMIF($D$25:$D$1000,I10,$F$25:$F$1000)","v":0},{"$f":"J10/$J$9","v":{"$error":"#DIV/0!"}},null,"월급",{"$f":"SUMIF($D$25:$D$1000,M10,$F$25:$F$1000)","v":0},{"$f":"N10/N13","v":{"$error":"#DIV/0!"}},null,"신한저축",{"$f":"SUMIF($D$25:$D$1000,Q10,$F$25:$F$1000)","v":0},{"$f":"R10/$R$17","v":{"$error":"#DIV/0!"}},null,"육아용품",{"$f":"SUMIF($D$25:$D$1000,U10,$F$25:$F$1000)","v":0}]
[null,"자기계발",50000,0,0,50000,null,null,"도시가스",{"$f":"SUMIF($D$25:$D$297,I11,$F$25:$F$1000)","v":0},{"$error":"#DIV/0!"},null,"기타수입",{"$f":"SUMIF($D$25:$D$253,M11,$F$25:$F$1000)","v":0},{"$f":"N11/N13","v":{"$error":"#DIV/0!"}},null,"저축",{"$f":"SUMIF($D$25:$D$1000,Q11,$F$25:$F$1000)","v":0},{"$error":"#DIV/0!"},null,"교육비",{"$f":"SUMIF($D$25:$D$1000,U11,$F$25:$F$1000)","v":0}]
[null,"자동차",200000,0,0,200000,null,null,"대출이자",{"$f":"SUMIF($D$25:$D$1000,I12,$F$25:$F$1000)","v":0},{"$error":"#DIV/0!"},null,"이자",{"$f":"SUMIF($D$25:$D$253,M12,$F$25:$F$1000)","v":0},{"$f":"N12/N13","v":{"$error":"#DIV/0!"}},null,"CCC",{"$f":"SUMIF($D$25:$D$1000,Q12,$F$25:$F$1000)","v":0},{"$error":"#DIV/0!"},null,"장난감",{"$f":"SUMIF($D$25:$D$1000,U12,$F$25:$F$1000)","v":0}]
[null,"육아",200000,0,0,200000,null,null,"수리/청소",{"$f":"SUMIF($D$25:$D$1000,I13,$F$25:$F$1000)","v":0},{"$error":"#DIV/0!"},null,"합계",{"$f":"SUM(N10:N12)","v":0},null,null,"손해보험",{"$f":"SUMIF($D$25:$D$1000,Q13,$F$25:$F$1000)","v":0},{"$error":"#DIV/0!"},null,null,{"$f":"SUBTOTAL(9,V10:V12)","v":0}]
[null,"보험",42718,0,0,42718,null,null,"렌탈비",{"$f":"SUMIF($D$25:$D$1000,I14,$F$25:$F$1000)","v":0},{"$error":"#DIV/0!"},null,null,null,null,null,"교육비",{"$f":"SUMIF($D$25:$D$1000,Q14,$F$25:$F$1000)","v":0},{"$error":"#DIV/0!"}]
[null,"이벤트",50000,0,0,50000,null,null,"KT인터넷",{"$f":"SUMIF($D$25:$D$1000,I15,$F$25:$F$1000)","v":0},{"$error":"#DIV/0!"},null,null,null,null,null,"주거",{"$f":"SUMIF($C$26:$C$1000,Q15,$F$25:$F$1000)","v":0},{"$error":"#DIV/0!"}]
[null,"섬김비",250000,0,0,250000,null,null,null,null,null,null,null,null,null,null,"자동차",{"$f":"SUMIF($C$26:$C$1000,Q16,$F$25:$F$1000)","v":0},{"$error":"#DIV/0!"}]
[null,"헌금",300000,0,0,300000,null,null,"식비",{"$f":"SUMIF($C$26:$C$1000,I17,$F$25:$F$1000)","v":0},"전체",null,"자동차",{"$f":"SUMIF($C$26:$C$1000,M17,$F$25:$F$1000)","v":0},"전체",null,"합계",{"$f":"SUM(R10:R16)","v":0}]
[null,"기부",115000,0,0,115000,null,null,"식자재",{"$f":"SUMIF($D$25:$D$1000,I18,$F$25:$F$1000)","v":0},{"$f":"J18/$J$17","v":{"$error":"#DIV/0!"}},null,"주유비",{"$f":"SUMIF($D$25:$D$1000,M18,$F$25:$F$1000)","v":0},{"$f":"N18/$N$17","v":{"$error":"#DIV/0!"}}]
[null,"통신비",120000,0,0,120000,null,null,"외식",{"$f":"SUMIF($D$25:$D$297,I19,$F$25:$F$1000)","v":0},{"$f":"J19/$J$17","v":{"$error":"#DIV/0!"}},null,"택시비",{"$f":"SUMIF($D$25:$D$1000,M19,$F$25:$F$1000)","v":0},{"$f":"N19/$N$17","v":{"$error":"#DIV/0!"}},null,"섬김비",{"$f":"SUMIF($D$25:$D$1000,Q19,$F$25:$F$1000)","v":0}]
[null,"기타",30000,0,0,30000,null,null,"간식비",{"$f":"SUMIF($D$25:$D$297,I20,$F$25:$F$1000)","v":0},{"$f":"J20/$J$17","v":{"$error":"#DIV/0!"}},null,"보험/세금",{"$f":"SUMIF($D$25:$D$1000,M20,$F$25:$F$1000)","v":0},{"$f":"N20/$N$17","v":{"$error":"#DIV/0!"}}]
[null,"합계",{"$f":"SUM(C5:C20)","v":2795218},{"$f":"SUM(D5:D20)","v":0},"예산-실사용금액",{"$f":"SUM(F5:F20)","v":2795218},null,null,null,null,null,null,"주차/통행료",{"$f":"SUMIF($D$25:$D$1000,M21,$F$25:$F$1000)","v":0},{"$f":"N21/$N$17","v":{"$error":"#DIV/0!"}}]
[null,"총수입-총지출",{"$f":"N13-D21","v":0}]
[]
["날짜","계좌","대분류","소분류","내용","금액","수입지출"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[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,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,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,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]

{"sheet":"9월","index":8,"n_rows":97,"n_cols":22,"rows_kept":97,"cut":false,"hidden":false,"merged":[[1,0,2,0],[3,0,20,0],[4,19,4,20],[4,22,4,25],[8,12,8,13],[8,16,8,17],[21,2,21,3],[28,20,28,21]]}
[]
["2020-09-10","전체보기","수입보기","날짜내림정렬","금액 \\ 표시하기",null,null,null,"노트"]
[null,"8월 이월금",null,"날짜오름정렬"]
["예산\n사용\n현황","지출내역","사용 예산","실사용금액","예산사용율","예산 잔액","초과 지출 소명"]
[null,"저축_투자",410000,{"$f":"SUMIF($C$25:$C$1000,B5,$F$25:$F$1000)","v":0},{"$f":"D5/C5","v":0},{"$f":"C5-D5","v":410000}]
[null,"주거",397500,0,0,397500]
[null,"식비",500000,0,0,500000]
[null,"생활용품",50000,0,0,50000]
[null,"의복_미용",30000,0,0,30000,null,null,"주거",{"$f":"SUMIF($C$25:$C$1000,I9,$F$25:$F$1000)","v":0},"전체",null,"수입내용",null,"비율",null,"고정지출",null,"비율",null,"육아"]
[null,"건강",50000,0,0,50000,null,null,"관리비",{"$f":"SUMIF($D$25:$D$1000,I10,$F$25:$F$1000)","v":0},{"$f":"J10/$J$9","v":{"$error":"#DIV/0!"}},null,"월급",{"$f":"SUMIF($D$25:$D$1000,M10,$F$25:$F$1000)","v":0},{"$f":"N10/N13","v":{"$error":"#DIV/0!"}},null,"신한저축",{"$f":"SUMIF($D$25:$D$1000,Q10,$F$25:$F$1000)","v":0},{"$f":"R10/$R$17","v":{"$error":"#DIV/0!"}},null,"육아용품",{"$f":"SUMIF($D$25:$D$1000,U10,$F$25:$F$1000)","v":0}]
[null,"자기계발",50000,0,0,50000,null,null,"도시가스",{"$f":"SUMIF($D$25:$D$297,I11,$F$25:$F$1000)","v":0},{"$error":"#DIV/0!"},null,"기타수입",{"$f":"SUMIF($D$25:$D$253,M11,$F$25:$F$1000)","v":0},{"$f":"N11/N13","v":{"$error":"#DIV/0!"}},null,"저축",{"$f":"SUMIF($D$25:$D$1000,Q11,$F$25:$F$1000)","v":0},{"$error":"#DIV/0!"},null,"교육비",{"$f":"SUMIF($D$25:$D$1000,U11,$F$25:$F$1000)","v":0}]
[null,"자동차",200000,0,0,200000,null,null,"대출이자",{"$f":"SUMIF($D$25:$D$1000,I12,$F$25:$F$1000)","v":0},{"$error":"#DIV/0!"},null,"이자",{"$f":"SUMIF($D$25:$D$253,M12,$F$25:$F$1000)","v":0},{"$f":"N12/N13","v":{"$error":"#DIV/0!"}},null,"CCC",{"$f":"SUMIF($D$25:$D$1000,Q12,$F$25:$F$1000)","v":0},{"$error":"#DIV/0!"},null,"장난감",{"$f":"SUMIF($D$25:$D$1000,U12,$F$25:$F$1000)","v":0}]
[null,"육아",200000,0,0,200000,null,null,"수리/청소",{"$f":"SUMIF($D$25:$D$1000,I13,$F$25:$F$1000)","v":0},{"$error":"#DIV/0!"},null,"합계",{"$f":"SUM(N10:N12)","v":0},null,null,"손해보험",{"$f":"SUMIF($D$25:$D$1000,Q13,$F$25:$F$1000)","v":0},{"$error":"#DIV/0!"},null,null,{"$f":"SUBTOTAL(9,V10:V12)","v":0}]
[null,"보험",42718,0,0,42718,null,null,"렌탈비",{"$f":"SUMIF($D$25:$D$1000,I14,$F$25:$F$1000)","v":0},{"$error":"#DIV/0!"},null,null,null,null,null,"교육비",{"$f":"SUMIF($D$25:$D$1000,Q14,$F$25:$F$1000)","v":0},{"$error":"#DIV/0!"}]
[null,"이벤트",50000,0,0,50000,null,null,"KT인터넷",{"$f":"SUMIF($D$25:$D$1000,I15,$F$25:$F$1000)","v":0},{"$error":"#DIV/0!"},null,null,null,null,null,"주거",{"$f":"SUMIF($C$26:$C$1000,Q15,$F$25:$F$1000)","v":0},{"$error":"#DIV/0!"}]
[null,"섬김비",250000,0,0,250000,null,null,null,null,null,null,null,null,null,null,"자동차",{"$f":"SUMIF($C$26:$C$1000,Q16,$F$25:$F$1000)","v":0},{"$error":"#DIV/0!"}]
[null,"헌금",300000,0,0,300000,null,null,"식비",{"$f":"SUMIF($C$26:$C$1000,I17,$F$25:$F$1000)","v":0},"전체",null,"자동차",{"$f":"SUMIF($C$26:$C$1000,M17,$F$25:$F$1000)","v":0},"전체",null,"합계",{"$f":"SUM(R10:R16)","v":0}]
[null,"기부",115000,0,0,115000,null,null,"식자재",{"$f":"SUMIF($D$25:$D$1000,I18,$F$25:$F$1000)","v":0},{"$f":"J18/$J$17","v":{"$error":"#DIV/0!"}},null,"주유비",{"$f":"SUMIF($D$25:$D$1000,M18,$F$25:$F$1000)","v":0},{"$f":"N18/$N$17","v":{"$error":"#DIV/0!"}}]
[null,"통신비",120000,0,0,120000,null,null,"외식",{"$f":"SUMIF($D$25:$D$297,I19,$F$25:$F$1000)","v":0},{"$f":"J19/$J$17","v":{"$error":"#DIV/0!"}},null,"택시비",{"$f":"SUMIF($D$25:$D$1000,M19,$F$25:$F$1000)","v":0},{"$f":"N19/$N$17","v":{"$error":"#DIV/0!"}},null,"섬김비",{"$f":"SUMIF($D$25:$D$1000,Q19,$F$25:$F$1000)","v":0}]
[null,"기타",30000,0,0,30000,null,null,"간식비",{"$f":"SUMIF($D$25:$D$297,I20,$F$25:$F$1000)","v":0},{"$f":"J20/$J$17","v":{"$error":"#DIV/0!"}},null,"보험/세금",{"$f":"SUMIF($D$25:$D$1000,M20,$F$25:$F$1000)","v":0},{"$f":"N20/$N$17","v":{"$error":"#DIV/0!"}}]
[null,"합계",{"$f":"SUM(C5:C20)","v":2795218},{"$f":"SUM(D5:D20)","v":0},"예산-실사용금액",{"$f":"SUM(F5:F20)","v":2795218},null,null,null,null,null,null,"주차/통행료",{"$f":"SUMIF($D$25:$D$1000,M21,$F$25:$F$1000)","v":0},{"$f":"N21/$N$17","v":{"$error":"#DIV/0!"}}]
[null,"총수입-총지출",{"$f":"N13-D21","v":0}]
[]
["날짜","계좌","대분류","소분류","내용","금액","수입지출"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[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,""]

{"sheet":"10월","index":9,"n_rows":97,"n_cols":22,"rows_kept":97,"cut":false,"hidden":false,"merged":[[1,0,2,0],[3,0,20,0],[4,19,4,20],[4,22,4,25],[8,12,8,13],[8,16,8,17],[21,2,21,3],[28,20,28,21]]}
[]
["2020-10-10","전체보기","수입보기","날짜내림정렬","금액 \\ 표시하기",null,null,null,"노트"]
[null,"9월 이월금",null,"날짜오름정렬"]
["예산\n사용\n현황","지출내역","사용 예산","실사용금액","예산사용율","예산 잔액","초과 지출 소명"]
[null,"저축_투자",410000,{"$f":"SUMIF($C$25:$C$1000,B5,$F$25:$F$1000)","v":0},{"$f":"D5/C5","v":0},{"$f":"C5-D5","v":410000}]
[null,"주거",397500,0,0,397500]
[null,"식비",500000,0,0,500000]
[null,"생활용품",50000,0,0,50000]
[null,"의복_미용",30000,0,0,30000,null,null,"주거",{"$f":"SUMIF($C$25:$C$1000,I9,$F$25:$F$1000)","v":0},"전체",null,"수입내용",null,"비율",null,"고정지출",null,"비율",null,"육아"]
[null,"건강",50000,0,0,50000,null,null,"관리비",{"$f":"SUMIF($D$25:$D$1000,I10,$F$25:$F$1000)","v":0},{"$f":"J10/$J$9","v":{"$error":"#DIV/0!"}},null,"월급",{"$f":"SUMIF($D$25:$D$1000,M10,$F$25:$F$1000)","v":0},{"$f":"N10/N13","v":{"$error":"#DIV/0!"}},null,"신한저축",{"$f":"SUMIF($D$25:$D$1000,Q10,$F$25:$F$1000)","v":0},{"$f":"R10/$R$17","v":{"$error":"#DIV/0!"}},null,"육아용품",{"$f":"SUMIF($D$25:$D$1000,U10,$F$25:$F$1000)","v":0}]
[null,"자기계발",50000,0,0,50000,null,null,"도시가스",{"$f":"SUMIF($D$25:$D$297,I11,$F$25:$F$1000)","v":0},{"$error":"#DIV/0!"},null,"기타수입",{"$f":"SUMIF($D$25:$D$253,M11,$F$25:$F$1000)","v":0},{"$f":"N11/N13","v":{"$error":"#DIV/0!"}},null,"저축",{"$f":"SUMIF($D$25:$D$1000,Q11,$F$25:$F$1000)","v":0},{"$error":"#DIV/0!"},null,"교육비",{"$f":"SUMIF($D$25:$D$1000,U11,$F$25:$F$1000)","v":0}]
[null,"자동차",200000,0,0,200000,null,null,"대출이자",{"$f":"SUMIF($D$25:$D$1000,I12,$F$25:$F$1000)","v":0},{"$error":"#DIV/0!"},null,"이자",{"$f":"SUMIF($D$25:$D$253,M12,$F$25:$F$1000)","v":0},{"$f":"N12/N13","v":{"$error":"#DIV/0!"}},null,"CCC",{"$f":"SUMIF($D$25:$D$1000,Q12,$F$25:$F$1000)","v":0},{"$error":"#DIV/0!"},null,"장난감",{"$f":"SUMIF($D$25:$D$1000,U12,$F$25:$F$1000)","v":0}]
[null,"육아",200000,0,0,200000,null,null,"수리/청소",{"$f":"SUMIF($D$25:$D$1000,I13,$F$25:$F$1000)","v":0},{"$error":"#DIV/0!"},null,"합계",{"$f":"SUM(N10:N12)","v":0},null,null,"손해보험",{"$f":"SUMIF($D$25:$D$1000,Q13,$F$25:$F$1000)","v":0},{"$error":"#DIV/0!"},null,null,{"$f":"SUBTOTAL(9,V10:V12)","v":0}]
[null,"보험",42718,0,0,42718,null,null,"렌탈비",{"$f":"SUMIF($D$25:$D$1000,I14,$F$25:$F$1000)","v":0},{"$error":"#DIV/0!"},null,null,null,null,null,"교육비",{"$f":"SUMIF($D$25:$D$1000,Q14,$F$25:$F$1000)","v":0},{"$error":"#DIV/0!"}]
[null,"이벤트",50000,0,0,50000,null,null,"KT인터넷",{"$f":"SUMIF($D$25:$D$1000,I15,$F$25:$F$1000)","v":0},{"$error":"#DIV/0!"},null,null,null,null,null,"주거",{"$f":"SUMIF($C$26:$C$1000,Q15,$F$25:$F$1000)","v":0},{"$error":"#DIV/0!"}]
[null,"섬김비",250000,0,0,250000,null,null,null,null,null,null,null,null,null,null,"자동차",{"$f":"SUMIF($C$26:$C$1000,Q16,$F$25:$F$1000)","v":0},{"$error":"#DIV/0!"}]
[null,"헌금",300000,0,0,300000,null,null,"식비",{"$f":"SUMIF($C$26:$C$1000,I17,$F$25:$F$1000)","v":0},"전체",null,"자동차",{"$f":"SUMIF($C$26:$C$1000,M17,$F$25:$F$1000)","v":0},"전체",null,"합계",{"$f":"SUM(R10:R16)","v":0}]
[null,"기부",115000,0,0,115000,null,null,"식자재",{"$f":"SUMIF($D$25:$D$1000,I18,$F$25:$F$1000)","v":0},{"$f":"J18/$J$17","v":{"$error":"#DIV/0!"}},null,"주유비",{"$f":"SUMIF($D$25:$D$1000,M18,$F$25:$F$1000)","v":0},{"$f":"N18/$N$17","v":{"$error":"#DIV/0!"}}]
[null,"통신비",120000,0,0,120000,null,null,"외식",{"$f":"SUMIF($D$25:$D$297,I19,$F$25:$F$1000)","v":0},{"$f":"J19/$J$17","v":{"$error":"#DIV/0!"}},null,"택시비",{"$f":"SUMIF($D$25:$D$1000,M19,$F$25:$F$1000)","v":0},{"$f":"N19/$N$17","v":{"$error":"#DIV/0!"}},null,"섬김비",{"$f":"SUMIF($D$25:$D$1000,Q19,$F$25:$F$1000)","v":0}]
[null,"기타",30000,0,0,30000,null,null,"간식비",{"$f":"SUMIF($D$25:$D$297,I20,$F$25:$F$1000)","v":0},{"$f":"J20/$J$17","v":{"$error":"#DIV/0!"}},null,"보험/세금",{"$f":"SUMIF($D$25:$D$1000,M20,$F$25:$F$1000)","v":0},{"$f":"N20/$N$17","v":{"$error":"#DIV/0!"}}]
[null,"합계",{"$f":"SUM(C5:C20)","v":2795218},{"$f":"SUM(D5:D20)","v":0},"예산-실사용금액",{"$f":"SUM(F5:F20)","v":2795218},null,null,null,null,null,null,"주차/통행료",{"$f":"SUMIF($D$25:$D$1000,M21,$F$25:$F$1000)","v":0},{"$f":"N21/$N$17","v":{"$error":"#DIV/0!"}}]
[null,"총수입-총지출",{"$f":"N13-D21","v":0}]
[]
["날짜","계좌","대분류","소분류","내용","금액","수입지출"]
[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,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,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,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,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,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,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,""]
[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,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,null,null,""]
[null,null,null,null,null,null,null,""]

{"sheet":"11월","index":10,"n_rows":125,"n_cols":22,"rows_kept":125,"cut":false,"hidden":false,"merged":[[1,0,2,0],[3,0,20,0],[4,19,4,20],[4,22,4,25],[8,12,8,13],[8,16,8,17],[21,2,21,3],[28,20,28,21]]}
[]
["2020-11-10","전체보기","수입보기","날짜내림정렬","금액 \\ 표시하기",null,null,null,"노트"]
[null,"10월 이월금",null,"날짜오름정렬"]
["예산\n사용\n현황","지출내역","사용 예산","실사용금액","예산사용율","예산 잔액","초과 지출 소명"]
[null,"저축_투자",410000,{"$f":"SUMIF($C$25:$C$999,B5,$F$25:$F$999)","v":0},{"$f":"D5/C5","v":0},{"$f":"C5-D5","v":410000}]
[null,"주거",397500,{"$f":"SUMIF($C$25:$C$999,B6,$F$25:$F$999)","v":302080},0.75994968553459119,95420]
[null,"식비",500000,{"$f":"SUMIF($C$25:$C$999,B7,$F$25:$F$999)","v":720821},1.4416420000000001,-220821]
[null,"생활용품",50000,{"$f":"SUMIF($C$25:$C$999,B8,$F$25:$F$999)","v":166080},3.3216000000000001,-116080]
[null,"의복_미용",30000,{"$f":"SUMIF($C$25:$C$999,B9,$F$25:$F$999)","v":0},0,30000,null,null,"주거",{"$f":"SUMIF($C$25:$C$999,I9,$F$25:$F$999)","v":302080},"전체",null,"수입내용",null,"비율",null,"고정지출",null,"비율",null,"육아"]
[null,"건강",50000,{"$f":"SUMIF($C$25:$C$999,B10,$F$25:$F$999)","v":34020},0.6804,15980,null,null,"관리비",{"$f":"SUMIF($D$25:$D$999,I10,$F$25:$F$999)","v":147260},{"$f":"J10/$J$9","v":0.48748675847457629},null,"월급",{"$f":"SUMIF($D$25:$D$999,M10,$F$25:$F$999)","v":2686050},{"$f":"N10/N13","v":0.96410688968252545},null,"신한저축",{"$f":"SUMIF($D$25:$D$999,Q10,$F$25:$F$999)","v":0},{"$f":"R10/$R$17","v":0},null,"육아용품",{"$f":"SUMIF($D$25:$D$999,U10,$F$25:$F$999)","v":150350}]
[null,"자기계발",50000,{"$f":"SUMIF($C$25:$C$999,B11,$F$25:$F$999)","v":6500},0.13,43500,null,null,"도시가스",{"$f":"SUMIF($D$25:$D$296,I11,$F$25:$F$999)","v":17880},5.9189618644067798E-2,null,"기타수입",{"$f":"SUMIF($D$25:$D$252,M11,$F$25:$F$999)","v":100000},{"$f":"N11/N13","v":3.5893110317474559E-2},null,"저축",{"$f":"SUMIF($D$25:$D$999,Q11,$F$25:$F$999)","v":0},0,null,"교육비",{"$f":"SUMIF($D$25:$D$999,U11,$F$25:$F$999)","v":170300}]
[null,"자동차",200000,{"$f":"SUMIF($C$25:$C$999,B12,$F$25:$F$999)","v":71260},0.35630000000000001,128740,null,null,"대출이자",{"$f":"SUMIF($D$25:$D$999,I12,$F$25:$F$999)","v":71140},0.23550052966101695,null,"이자",{"$f":"SUMIF($D$25:$D$252,M12,$F$25:$F$999)","v":0},{"$f":"N12/N13","v":0},null,"CCC",{"$f":"SUMIF($D$25:$D$999,Q12,$F$25:$F$999)","v":0},0,null,"장난감",{"$f":"SUMIF($D$25:$D$999,U12,$F$25:$F$999)","v":54000}]
[null,"육아",200000,{"$f":"SUMIF($C$25:$C$999,B13,$F$25:$F$999)","v":374650},1.8732500000000001,-174650,null,null,"수리/청소",{"$f":"SUMIF($D$25:$D$999,I13,$F$25:$F$999)","v":0},0,null,"합계",{"$f":"SUM(N10:N12)","v":2786050},null,null,"손해보험",{"$f":"SUMIF($D$25:$D$999,Q13,$F$25:$F$999)","v":25540},5.1351959980054367E-2,null,null,{"$f":"SUBTOTAL(9,V10:V12)","v":374650}]
[null,"보험",42718,{"$f":"SUMIF($C$25:$C$999,B14,$F$25:$F$999)","v":25540},0.5978744323236107,17178,null,null,"렌탈비",{"$f":"SUMIF($D$25:$D$999,I14,$F$25:$F$999)","v":65800},0.21782309322033899,null,null,null,null,null,"교육비",{"$f":"SUMIF($D$25:$D$999,Q14,$F$25:$F$999)","v":170300},0.34241342148015891]
[null,"이벤트",50000,{"$f":"SUMIF($C$25:$C$999,B15,$F$25:$F$999)","v":0},0,50000,null,null,"KT인터넷",{"$f":"SUMIF($D$25:$D$999,I15,$F$25:$F$999)","v":0},0,null,null,null,null,null,"주거",{"$f":"SUMIF($C$26:$C$999,Q15,$F$25:$F$999)","v":195512},0.39310588878701602]
[null,"섬김비",250000,{"$f":"SUMIF($C$25:$C$999,B16,$F$25:$F$999)","v":359170},1.43668,-109170,null,null,null,null,null,null,null,null,null,null,"자동차",{"$f":"SUMIF($C$26:$C$999,Q16,$F$25:$F$999)","v":106000},0.21312872975277067]
[null,"헌금",300000,{"$f":"SUMIF($C$25:$C$999,B17,$F$25:$F$999)","v":350000},1.1666666666666667,-50000,null,null,"식비",{"$f":"SUMIF($C$26:$C$999,I17,$F$25:$F$999)","v":1510775},"전체",null,"자동차",{"$f":"SUMIF($C$26:$C$999,M17,$F$25:$F$999)","v":106000},"전체",null,"합계",{"$f":"SUM(R10:R16)","v":497352}]
[null,"기부",115000,{"$f":"SUMIF($C$25:$C$999,B18,$F$25:$F$999)","v":0},0,115000,null,null,"식자재",{"$f":"SUMIF($D$25:$D$999,I18,$F$25:$F$999)","v":411430},{"$f":"J18/$J$17","v":0.27233042643676258},null,"주유비",{"$f":"SUMIF($D$25:$D$999,M18,$F$25:$F$999)","v":71260},{"$f":"N18/$N$17","v":0.6722641509433962}]
[null,"통신비",120000,{"$f":"SUMIF($C$25:$C$999,B19,$F$25:$F$999)","v":0},0,120000,null,null,"외식",{"$f":"SUMIF($D$25:$D$296,I19,$F$25:$F$999)","v":170132},{"$f":"J19/$J$17","v":0.11261240092005759},null,"택시비",{"$f":"SUMIF($D$25:$D$999,M19,$F$25:$F$999)","v":0},{"$f":"N19/$N$17","v":0},null,"섬김비",{"$f":"SUMIF($D$25:$D$999,Q19,$F$25:$F$999)","v":0}]
[null,"기타",30000,{"$f":"SUMIF($C$25:$C$999,B20,$F$25:$F$999)","v":3900},0.13,26100,null,null,"간식비",{"$f":"SUMIF($D$25:$D$296,I20,$F$25:$F$999)","v":26800},{"$f":"J20/$J$17","v":1.7739239794145389E-2},null,"보험/세금",{"$f":"SUMIF($D$25:$D$999,M20,$F$25:$F$999)","v":0},{"$f":"N20/$N$17","v":0}]
[null,"합계",{"$f":"SUM(C5:C20)","v":2795218},{"$f":"SUM(D5:D20)","v":2414021},"예산-실사용금액",{"$f":"SUM(F5:F20)","v":381197},null,null,null,null,null,null,"주차/통행료",{"$f":"SUMIF($D$25:$D$999,M21,$F$25:$F$999)","v":0},{"$f":"N21/$N$17","v":0}]
[null,"총수입-총지출",{"$f":"N13-D21","v":372029}]
[]
["날짜","계좌","대분류","소분류","내용","금액","수입지출"]
["2020-12-03","하나카드","섬김비","가족/친지","쿠팡(쿠페이)",12500,"지출",""]
["2020-12-03","하나카드","육아","육아용품","쿠팡(쿠페이) 예원이 소파베드",49000,"지출",""]
["2020-12-02","하나카드","육아","육아용품","쿠팡(쿠페이) 예원이 캐노피",32980,"지출",""]
["2020-12-02","하나카드","생활용품","기타용품","창조철물공고 미니 드라이버",4500,"지출",""]
["2020-12-01","하나카드","식비","간식비","이마트24군산미공군",1200,"지출",""]
["2020-11-30","하나카드","섬김비","가족/친지","쿠팡(쿠페이)",41410,"지출",""]
["2020-11-30","하나카드","식비","식자재","신일슈퍼",3700,"지출",""]
["2020-11-30","하나카드","식비","간식비","신일슈퍼",-4000,"지출",""]
["2020-11-30","하나카드","식비","식자재","두배로쇼핑",2000,"지출",""]
["2020-11-30","하나카드","식비","식자재","경선정육점",19000,"지출",""]
["2020-11-30","하나카드","식비","식자재","두배로쇼핑",5370,"지출",""]
["2020-11-30","하나카드","식비","간식비","신일슈퍼",1700,"지출",""]
["2020-11-30","하나카드","식비","간식비","신일슈퍼",4000,"지출",""]
["2020-11-29","하나카드","육아","육아용품","햇님토이 아이들 열쇠",4000,"지출",""]
["2020-11-29","하나카드","식비","식자재","신일슈퍼",1100,"지출",""]
["2020-11-29","하나카드","식비","식자재","두배로쇼핑",24220,"지출",""]
["2020-11-29","하나카드","식비","식자재","경선정육점",13800,"지출",""]
["2020-11-28","하나카드","식비","식자재","(주)이마트에브리",115240,"지출",""]
["2020-11-27","하나카드","식비","식자재","두배로쇼핑",6000,"지출",""]
["2020-11-27","신한은행","식비","외식","강민영 족발주문",37000,"지출",""]
["2020-11-26","하나카드","식비","간식비","이마트24군산미공군",2400,"지출",""]
["2020-11-26","하나카드","섬김비","가족/친지","쿠팡(쿠페이)",41000,"지출",""]
["2020-11-26","하나카드","생활용품","기타용품","쿠팡(쿠페이) 시계줄 3개",7580,"지출",""]
["2020-11-26","하나카드","식비","식자재","두배로쇼핑",15210,"지출",""]
["2020-11-26","하나카드","식비","식자재","경선정육점",6000,"지출",""]
["2020-11-25","하나카드","자동차","주유비","에스제이상사국제",33666,"지출",""]
["2020-11-25","하나카드","식비","간식비","이마트24군산미공군",1200,"지출",""]
["2020-11-25","하나카드","생활용품","기타용품","쿠팡(쿠페이) 패드 보호필름",10300,"지출",""]
["2020-11-25","하나카드","주거","관리비","아파트관리비",147260,"지출",""]
["2020-11-25","신한은행","주거","도시가스","군산도시가스",17880,"지출",""]
["2020-11-25","신한은행","수입","기타수입","아동수당",100000,"수입",""]
["2020-11-24","현금","생활용품","기타용품","쿠팡 립케어 4개",9500,"지출",""]
["2020-11-24","하나카드","식비","식자재","두배로쇼핑",12800,"지출",""]
["2020-11-24","하나카드","식비","식자재","두배로쇼핑",4500,"지출",""]
["2020-11-24","하나카드","식비","식자재","경선정육점",4000,"지출",""]
["2020-11-23","현금","생활용품","기타용품","휠타수세미 30개",14200,"지출",""]
["2020-11-23","신한은행","보험","손해보험","DB손",11330,"지출",""]
["2020-11-23","신한은행","보험","손해보험","DB손",14210,"지출",""]
["2020-11-23","하나카드","섬김비","가족/친지","쿠팡(쿠페이)",14200,"지출",""]
["2020-11-23","하나카드","식비","식자재","두배로쇼핑",3600,"지출",""]
["2020-11-23","하나카드","식비","식자재","두배로쇼핑",11550,"지출",""]
["2020-11-23","삼성","식비","","DB손해보험 ((6/10)) ",112459,"지출",""]
["2020-11-22","하나카드","식비","간식비","신일슈퍼",2500,"지출",""]
["2020-11-22","하나카드","식비","식자재","경선정육점",19400,"지출",""]
["2020-11-22","하나카드","육아","육아용품","쿠팡(쿠페이) 아기과자",12000,"지출"]
["2020-11-22","하나카드","식비","식자재","두배로쇼핑",6900,"지출",""]
["2020-11-22","하나카드","육아","육아용품","쿠팡(쿠페이) 분유3통",45470,"지출",""]
["2020-11-21","하나카드","식비","외식","유한회사알지피코리",16000,"지출",""]
["2020-11-21","하나카드","식비","간식비","파리바게뜨(제일점)",3300,"지출",""]
["2020-11-21","하나카드","건강","병원/약국","백제약국",2200,"지출",""]
["2020-11-21","하나카드","건강","병원/약국","전종율소아과",3000,"지출",""]
["2020-11-20","하나카드","식비","간식비","신일슈퍼",2700,"지출",""]
["2020-11-20","삼성","식비","외식","AAFESKUNSANANTHONYS 피자 사감",19832,"지출",""]
["2020-11-20","하나카드","주거","렌탈비","엘지전자(주)렌탈케",20900,"지출",""]
["2020-11-20","신한은행","기타","기타","쿠팡와우월회비",2900,"지출",""]
["2020-11-19","삼성","섬김비","지인","AAFESKUNSANANTHONYS 회사 사람들과 피자",47830,"지출",""]
["2020-11-18","하나카드","식비","식자재","두배로쇼핑",10680,"지출",""]
["2020-11-18","하나카드","생활용품","기타용품","쿠팡(쿠페이) 미밴드 잘못 구매함",3200,"지출",""]
["2020-11-17","하나카드","생활용품","기타용품","쿠팡(쿠페이) 납흡입기",6900,"지출",""]
["2020-11-17","하나카드","건강","병원/약국","백제약국",2700,"지출",""]
["2020-11-17","하나카드","건강","병원/약국","전종율소아과",4400,"지출",""]
["2020-11-16","신한은행","전월카드지출","","삼성카드주식회",112400,"지출",""]
["2020-11-16","하나카드","건강","건강용품","쿠팡(쿠페이)푸쉬업 바",8220,"지출",""]
["2020-11-16","신한은행","주거","대출이자","",71140,"지출",""]
["2020-11-15","하나카드","식비","외식","유한회사알지피코리",52000,"지출",""]
["2020-11-15","하나카드","건강","병원/약국","아이약국",3600,"지출",""]
["2020-11-15","하나카드","건강","병원/약국","군산메디베베소아청소",6000,"지출",""]
["2020-11-14","하나카드","식비","식자재","두배로쇼핑",19260,"지출",""]
["2020-11-14","하나카드","식비","외식","유한회사알지피코리요기요",29700,"지출",""]
["2020-11-14","하나카드","식비","간식비","신일슈퍼",5500,"지출",""]
["2020-11-13","신한은행","전월카드지출","","하나카드",1217664,"지출",""]
["2020-11-13","하나카드","육아","교육비","햇님토이",79000,"지출",""]
["2020-11-13","하나카드","식비","간식비","이마트24군산미공군",1300,"지출",""]
["2020-11-13","하나카드","섬김비","가족/친지","쿠팡(쿠페이)",8500,"지출"]
["2020-11-12","하나카드","식비","간식비","이마트24군산미공군",5000,"지출"]
["2020-11-11","신한은행","생활용품","기타용품","최가영 놀이매트 맘카페",100000,"지출"]
["2020-11-11","하나카드","자동차","주유비","에스제이상사국제",37594,"지출"]
["2020-11-11","신한은행","전월카드지출","","우리00",566670,"지출"]
["2020-11-11","신한은행","식비","식자재","카드",56500,"지출"]
["2020-11-11","신한은행","육아","교육비","해나라유치원",91300,"지출"]
["2020-11-10","신한은행","수입","월급","엘비휴넷(주)",2686050,"수입"]
["2020-11-10","현금","헌금","십일조","십일조",350000,"지출"]
["2020-11-10","신한","자기계발","도서/문구","리디북스",6500,"지출"]
["2020-11-10","하나카드","식비","식자재","쿠팡(쿠페이) 김치",35900,"지출"]
["2020-11-10","하나카드","육아","육아용품","쿠팡(쿠페이) 유기농 쌀과자",6900,"지출"]
["2020-11-10","하나카드","생활용품","기타용품","쿠팡(쿠페이) 고속충전케이블 3개",9900,"지출"]
["2020-11-10","하나카드","주거","렌탈비","엘지전자(주)렌탈",44900,"지출"]
["2020-11-10","신한은행","기타","은행수수료","SMS",1000,"지출"]
["2020-12-09","신한은행","미분류","","군산시청선유2",1900,"지출"]
["2020-12-08","하나카드","식비","외식","맥도날드군산나운D",13600,"지출"]
["2020-12-08","하나카드","식비","외식","맥도날드군산나운DT",2000,"지출"]
["2020-12-07","하나카드","섬김비","가족/친지","쿠팡(쿠페이)",9730,"지출"]
["2020-12-07","하나카드","육아","장난감","햇님토이",54000,"지출"]
["2020-12-07","하나카드","건강","병원/약국","백제약국",1400,"지출"]
["2020-12-07","하나카드","건강","병원/약국","전종율소아과",2500,"지출"]
["2020-12-07","하나카드","섬김비","가족/친지","쿠팡(쿠페이)",29900,"지출"]
["2020-12-06","하나카드","섬김비","가족/친지","쿠팡(쿠페이)",78900,"지출"]
["2020-12-06","하나카드","식비","식자재","두배로쇼핑",14700,"지출"]
["2020-12-05","하나카드","섬김비","가족/친지","쿠팡(쿠페이)",49200,"지출"]
["2020-12-04","하나카드","미분류","","유한회사알지피코",18000,"지출"]
["2020-12-04","하나카드","섬김비","지인","신풍인삼면옥(백양원과 공주)",26000,"지출"]

{"sheet":"12월","index":11,"n_rows":97,"n_cols":22,"rows_kept":97,"cut":false,"hidden":false,"merged":[[1,0,2,0],[3,0,20,0],[4,19,4,20],[4,22,4,25],[8,12,8,13],[8,16,8,17],[21,2,21,3],[28,20,28,21]]}
[]
["2020-12-10","전체보기","수입보기","날짜내림정렬","금액 \\ 표시하기",null,null,null,"노트"]
[null,"11월 이월금",null,"날짜오름정렬"]
["예산\n사용\n현황","지출내역","사용 예산","실사용금액","예산사용율","예산 잔액","초과 지출 소명"]
[null,"저축_투자",410000,{"$f":"SUMIF($C$25:$C$1000,B5,$F$25:$F$1000)","v":0},{"$f":"D5/C5","v":0},{"$f":"C5-D5","v":410000}]
[null,"주거",397500,261920,0.65891823899371071,135580]
[null,"식비",500000,268299,0.53659800000000002,231701]
[null,"생활용품",50000,38070,0.76139999999999997,11930]
[null,"의복_미용",30000,0,0,30000,null,null,"주거",{"$f":"SUMIF($C$25:$C$1000,I9,$F$25:$F$1000)","v":261920},"전체",null,"수입내용",null,"비율",null,"고정지출",null,"비율",null,"육아"]
[null,"건강",50000,0,0,50000,null,null,"관리비",{"$f":"SUMIF($D$25:$D$1000,I10,$F$25:$F$1000)","v":150940},{"$f":"J10/$J$9","v":0.57628283445326822},null,"월급",{"$f":"SUMIF($D$25:$D$1000,M10,$F$25:$F$1000)","v":2650150},{"$f":"N10/N13","v":0.96363834699925455},null,"신한저축",{"$f":"SUMIF($D$25:$D$1000,Q10,$F$25:$F$1000)","v":0},{"$f":"R10/$R$17","v":0},null,"육아용품",{"$f":"SUMIF($D$25:$D$1000,U10,$F$25:$F$1000)","v":191230}]
[null,"자기계발",50000,32300,0.64600000000000002,17700,null,null,"도시가스",{"$f":"SUMIF($D$25:$D$297,I11,$F$25:$F$1000)","v":45180},0.17249541844838118,null,"기타수입",{"$f":"SUMIF($D$25:$D$253,M11,$F$25:$F$1000)","v":100000},{"$f":"N11/N13","v":3.6361653000745411E-2},null,"저축",{"$f":"SUMIF($D$25:$D$1000,Q11,$F$25:$F$1000)","v":0},0,null,"교육비",{"$f":"SUMIF($D$25:$D$1000,U11,$F$25:$F$1000)","v":124500}]
[null,"자동차",200000,181810,0.90905000000000002,18190,null,null,"대출이자",{"$f":"SUMIF($D$25:$D$1000,I12,$F$25:$F$1000)","v":0},0,null,"이자",{"$f":"SUMIF($D$25:$D$253,M12,$F$25:$F$1000)","v":0},{"$f":"N12/N13","v":0},null,"CCC",{"$f":"SUMIF($D$25:$D$1000,Q12,$F$25:$F$1000)","v":0},0,null,"장난감",{"$f":"SUMIF($D$25:$D$1000,U12,$F$25:$F$1000)","v":41000}]
[null,"육아",200000,356730,1.78365,-156730,null,null,"수리/청소",{"$f":"SUMIF($D$25:$D$1000,I13,$F$25:$F$1000)","v":0},0,null,"합계",{"$f":"SUM(N10:N12)","v":2750150},null,null,"손해보험",{"$f":"SUMIF($D$25:$D$1000,Q13,$F$25:$F$1000)","v":25540},1.3060745250010483E-2,null,null,{"$f":"SUBTOTAL(9,V10:V12)","v":356730}]
[null,"보험",42718,25540,0.5978744323236107,17178,null,null,"렌탈비",{"$f":"SUMIF($D$25:$D$1000,I14,$F$25:$F$1000)","v":65800},0.25122174709835066,null,null,null,null,null,"교육비",{"$f":"SUMIF($D$25:$D$1000,Q14,$F$25:$F$1000)","v":124500},6.3667297714420715E-2]
[null,"이벤트",50000,0,0,50000,null,null,"KT인터넷",{"$f":"SUMIF($D$25:$D$1000,I15,$F$25:$F$1000)","v":0},0,null,null,null,null,null,"주거",{"$f":"SUMIF($C$26:$C$1000,Q15,$F$25:$F$1000)","v":263588},0.13479466401565243]
[null,"섬김비",250000,0,0,250000,null,null,null,null,null,null,null,null,null,null,"자동차",{"$f":"SUMIF($C$26:$C$1000,Q16,$F$25:$F$1000)","v":1541850},0.78847729301991631]
[null,"헌금",300000,0,0,300000,null,null,"식비",{"$f":"SUMIF($C$26:$C$1000,I17,$F$25:$F$1000)","v":1137377},"전체",null,"자동차",{"$f":"SUMIF($C$26:$C$1000,M17,$F$25:$F$1000)","v":1541850},"전체",null,"합계",{"$f":"SUM(R10:R16)","v":1955478}]
[null,"기부",115000,0,0,115000,null,null,"식자재",{"$f":"SUMIF($D$25:$D$1000,I18,$F$25:$F$1000)","v":108340},{"$f":"J18/$J$17","v":9.5254256064611825E-2},null,"주유비",{"$f":"SUMIF($D$25:$D$1000,M18,$F$25:$F$1000)","v":0},{"$f":"N18/$N$17","v":0}]
[null,"통신비",120000,0,0,120000,null,null,"외식",{"$f":"SUMIF($D$25:$D$297,I19,$F$25:$F$1000)","v":43000},{"$f":"J19/$J$17","v":3.7806285866515674E-2},null,"택시비",{"$f":"SUMIF($D$25:$D$1000,M19,$F$25:$F$1000)","v":0},{"$f":"N19/$N$17","v":0},null,"섬김비",{"$f":"SUMIF($D$25:$D$1000,Q19,$F$25:$F$1000)","v":0}]
[null,"기타",30000,3900,0.13,26100,null,null,"간식비",{"$f":"SUMIF($D$25:$D$297,I20,$F$25:$F$1000)","v":4500},{"$f":"J20/$J$17","v":3.9564717767283843E-3},null,"보험/세금",{"$f":"SUMIF($D$25:$D$1000,M20,$F$25:$F$1000)","v":181810},{"$f":"N20/$N$17","v":0.1179167882738269}]
[null,"합계",{"$f":"SUM(C5:C20)","v":2795218},{"$f":"SUM(D5:D20)","v":1168569},"예산-실사용금액",{"$f":"SUM(F5:F20)","v":1626649},null,null,null,null,null,null,"주차/통행료",{"$f":"SUMIF($D$25:$D$1000,M21,$F$25:$F$1000)","v":0},{"$f":"N21/$N$17","v":0}]
[null,"총수입-총지출",{"$f":"N13-D21","v":1581581}]
[]
["날짜","계좌","대분류","소분류","내용","금액","수입지출"]
["2020-12-28","하나카드","육아","육아용품","쿠팡(쿠페이)",17200,"지출",""]
["2020-12-28","하나카드","주거","관리비","아파트관리비",150940,"지출",""]
["2020-12-27","하나카드","식비","식자재","두배로쇼핑",3000,"지출",""]
["2020-12-27","하나카드","육아","육아용품","쿠팡(쿠페이) 아이들 선물",45400,"지출",""]
["2020-12-27","하나카드","식비","식자재","두배로쇼핑",6850,"지출",""]
["2020-12-27","하나카드","식비","식자재","두배로쇼핑",12000,"지출",""]
["2020-12-27","하나카드","생활용품","가전/가구","쿠팡(쿠페이) 옷걸이",9900,"지출",""]
["2020-12-27","하나카드","생활용품","가전/가구","쿠팡(쿠페이)빈백쇼파 6개월 무이자 ((1/6)) ",23170,"지출",""]
["2020-12-26","하나카드","식비","식자재","경선정육점",6000,"지출",""]
["2020-12-26","하나카드","식비","식자재","두배로쇼핑",17660,"지출",""]
["2020-12-26","하나카드","육아","육아용품","쿠팡(쿠페이) 분유",46060,"지출",""]
["2020-12-25","하나카드","식비","식자재","두배로쇼핑",40410,"지출",""]
["2020-12-25","하나카드","식비","식자재","두배로쇼핑",2420,"지출",""]
["2020-12-24","하나카드","육아","장난감","햇님토이",1000,"지출",""]
["2020-12-24","하나카드","육아","장난감","햇님토이",40000,"지출",""]
["2020-12-24","하나카드","자기계발","도서/문구","한길문고나운점",25800,"지출",""]
["2020-12-24","하나카드","육아","육아용품","쿠팡(쿠페이)",7500,"지출",""]
["2020-12-24","하나카드","육아","육아용품","쿠팡(쿠페이)",48890,"지출",""]
["2020-12-24","신한은행","수입","기타수입","아동수당",100000,"수입",""]
["2020-12-24","하나카드","식비","간식비","신일슈퍼",4500,"지출",""]
["2020-12-23","하나카드","식비","식자재","경선정육점",13500,"지출",""]
["2020-12-23","삼성","식비","","DB손해보험 ((7/10)) ",112459,"지출",""]
["2020-12-21","신한은행","보험","손해보험","DB손",14210,"지출",""]
["2020-12-21","신한은행","보험","손해보험","DB손",11330,"지출",""]
["2020-12-21","하나카드","식비","외식","유한회사알지피코리",43000,"지출",""]
["2020-12-21","하나카드","주거","렌탈비","엘지전자(주)렌탈케",20900,"지출",""]
["2020-12-20","신한은행","주거","도시가스","군산도시가스",45180,"지출",""]
["2020-12-20","신한은행","기타","기타","쿠팡와우월회비",2900,"지출",""]
["2020-12-19","신한은행","미분류","","0919~1218",349,"수입",""]
["2020-12-15","신한은행","전월카드지출","","삼성카드주식회",182488,"지출",""]
["2020-12-15","하나카드","주거","렌탈비","엘지전자(주)렌탈케",44900,"지출",""]
["2020-12-14","신한은행","전월카드지출","","하나카드",1541850,"지출",""]
["2020-12-14","신한은행","자동차","보험/세금","김인철_군산시",181810,"지출",""]
["2020-12-14","신한은행","미분류","","",68850,"지출",""]
["2020-12-11","신한은행","전월카드지출","","우리00",689217,"지출",""]
["2020-12-11","신한은행","식비","식자재","카드",6500,"지출",""]
["2020-12-11","하나카드","생활용품","기타용품","한길문고",5000,"지출",""]
["2020-12-11","신한은행","육아","교육비","해나라유치원",124500,"지출",""]
["2020-12-10","하나카드","육아","육아용품","쿠팡(쿠페이) 물티슈",26180,"지출",""]
["2020-12-10","신한은행","수입","월급","엘비휴넷(주)",2650150,"수입",""]
["2020-12-10","신한","자기계발","도서/문구","리디북스",6500,"지출",""]
["2020-12-10","신한은행","기타","은행수수료","SMS",1000,"지출",""]
[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,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,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,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,""]

{"sheet":"종합","index":12,"n_rows":15,"n_cols":20,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,4,1,19],[1,0,2,0],[1,1,2,1],[1,2,2,2],[1,3,2,3]]}
["2019년 "]
["월","수입","총지출","잔액","지출"]
[null,null,null,null,"저축_투자","주거","식비","생활용품","의복_미용","건강","자기계발","자동차","육아","보험","이벤트","경조사","헌금","기부","통신비","기타"]
["1월",{"$f":"'1월'!$N$13","v":8335010},{"$f":"'1월'!$D$21","v":2721855},{"$f":"B4-C4","v":5613155},{"$f":"'1월'!$D$5","v":410000},{"$f":"'1월'!$D$6","v":365020},{"$f":"'1월'!$D$7","v":535140},{"$f":"'1월'!$D$8","v":195040},{"$f":"'1월'!$D$9","v":49000},{"$f":"'1월'!$D$10","v":27900},{"$f":"'1월'!$D$11","v":85591},{"$f":"'1월'!$D$12","v":160596},{"$f":"'1월'!$D$13","v":260980},{"$f":"'1월'!$D$14","v":42718},{"$f":"'1월'!$D$15","v":17000},{"$f":"'1월'!$D$16","v":0},{"$f":"'1월'!$D$17","v":337000},{"$f":"'1월'!$D$18","v":95000},{"$f":"'1월'!$D$19","v":110870},{"$f":"'1월'!$D$20","v":30000}]
["2월",{"$f":"'2월'!$N$13","v":2782070},{"$f":"'2월'!$D$21","v":2589035},193035,{"$f":"'2월'!$D$5","v":110000},{"$f":"'2월'!$D$6","v":415900},{"$f":"'2월'!$D$7","v":726280},{"$f":"'2월'!$D$8","v":347010},{"$f":"'2월'!$D$9","v":10000},{"$f":"'2월'!$D$10","v":45900},{"$f":"'2월'!$D$11","v":141600},{"$f":"'2월'!$D$12","v":83497},{"$f":"'2월'!$D$13","v":60000},{"$f":"'2월'!$D$14","v":27730},{"$f":"'2월'!$D$15","v":0},{"$f":"'2월'!$D$16","v":32000},{"$f":"'2월'!$D$17","v":250000},{"$f":"'2월'!$D$18","v":95000},{"$f":"'2월'!$D$19","v":193060},{"$f":"'2월'!$D$20","v":51058}]
["3월",{"$f":"'3월'!$N$13","v":4822150},{"$f":"'3월'!$D$21","v":3167189},1654961,{"$f":"'3월'!$D$5","v":100000},{"$f":"'3월'!$D$6","v":396850},{"$f":"'3월'!$D$7","v":936608},{"$f":"'3월'!$D$8","v":350530},{"$f":"'3월'!$D$9","v":10000},{"$f":"'3월'!$D$10","v":637190},{"$f":"'3월'!$D$11","v":6500},{"$f":"'3월'!$D$12","v":85092},{"$f":"'3월'!$D$13","v":316340},{"$f":"'3월'!$D$14","v":27730},{"$f":"'3월'!$D$15","v":0},{"$f":"'3월'!$D$16","v":11290},{"$f":"'3월'!$D$17","v":0},{"$f":"'3월'!$D$18","v":95000},{"$f":"'3월'!$D$19","v":176330},{"$f":"'3월'!$D$20","v":17729}]
["4월",{"$f":"'4월'!$N$13","v":3428070},{"$f":"'4월'!$D$21","v":2583738},844332,{"$f":"'4월'!$D$5","v":0},{"$f":"'4월'!$D$6","v":322220},{"$f":"'4월'!$D$7","v":652840},{"$f":"'4월'!$D$8","v":25820},{"$f":"'4월'!$D$9","v":135900},{"$f":"'4월'!$D$10","v":20100},{"$f":"'4월'!$D$11","v":6500},{"$f":"'4월'!$D$12","v":41036},{"$f":"'4월'!$D$13","v":338590},{"$f":"'4월'!$D$14","v":27730},{"$f":"'4월'!$D$15","v":0},{"$f":"'4월'!$D$16","v":660500},{"$f":"'4월'!$D$17","v":200000},{"$f":"'4월'!$D$18","v":0},{"$f":"'4월'!$D$19","v":137680},{"$f":"'4월'!$D$20","v":14822}]
["5월",{"$f":"'5월'!$N$13","v":4670470},{"$f":"'5월'!$D$21","v":2724227},1946243,{"$f":"'5월'!$D$5","v":110000},{"$f":"'5월'!$D$6","v":447590},{"$f":"'5월'!$D$7","v":628440},{"$f":"'5월'!$D$8","v":114130},{"$f":"'5월'!$D$9","v":17000},{"$f":"'5월'!$D$10","v":200300},{"$f":"'5월'!$D$11","v":6500},{"$f":"'5월'!$D$12","v":86686},{"$f":"'5월'!$D$13","v":586413},{"$f":"'5월'!$D$14","v":25540},{"$f":"'5월'!$D$15","v":0},{"$f":"'5월'!$D$16","v":200050},{"$f":"'5월'!$D$17","v":0},{"$f":"'5월'!$D$18","v":0},{"$f":"'5월'!$D$19","v":247360},{"$f":"'5월'!$D$20","v":54218}]
["6월",{"$f":"'6월'!$N$13","v":2800709},{"$f":"'6월'!$D$21","v":2808261},-7552,{"$f":"'6월'!$D$5","v":0},{"$f":"'6월'!$D$6","v":407170},{"$f":"'6월'!$D$7","v":849340},{"$f":"'6월'!$D$8","v":437525},{"$f":"'6월'!$D$9","v":17000},{"$f":"'6월'!$D$10","v":228044},{"$f":"'6월'!$D$11","v":24143},{"$f":"'6월'!$D$12","v":35466},{"$f":"'6월'!$D$13","v":371638},{"$f":"'6월'!$D$14","v":137999},{"$f":"'6월'!$D$15","v":0},{"$f":"'6월'!$D$16","v":130900},{"$f":"'6월'!$D$17","v":0},{"$f":"'6월'!$D$18","v":0},{"$f":"'6월'!$D$19","v":120120},{"$f":"'6월'!$D$20","v":48916}]
["7월",{"$f":"'7월'!$N$13","v":0},{"$f":"'7월'!$D$21","v":0},0,{"$f":"'7월'!$D$5","v":0},{"$f":"'7월'!$D$6","v":0},{"$f":"'7월'!$D$7","v":0},{"$f":"'7월'!$D$8","v":0},{"$f":"'7월'!$D$9","v":0},{"$f":"'7월'!$D$10","v":0},{"$f":"'7월'!$D$11","v":0},{"$f":"'7월'!$D$12","v":0},{"$f":"'7월'!$D$13","v":0},{"$f":"'7월'!$D$14","v":0},{"$f":"'7월'!$D$15","v":0},{"$f":"'7월'!$D$16","v":0},{"$f":"'7월'!$D$17","v":0},{"$f":"'7월'!$D$18","v":0},{"$f":"'7월'!$D$19","v":0},{"$f":"'7월'!$D$20","v":0}]
["8월",{"$f":"'8월'!$N$13","v":0},{"$f":"'8월'!$D$21","v":0},0,{"$f":"'8월'!$D$5","v":0},{"$f":"'8월'!$D$6","v":0},{"$f":"'8월'!$D$7","v":0},{"$f":"'8월'!$D$8","v":0},{"$f":"'8월'!$D$9","v":0},{"$f":"'8월'!$D$10","v":0},{"$f":"'8월'!$D$11","v":0},{"$f":"'8월'!$D$12","v":0},{"$f":"'8월'!$D$13","v":0},{"$f":"'8월'!$D$14","v":0},{"$f":"'8월'!$D$15","v":0},{"$f":"'8월'!$D$16","v":0},{"$f":"'8월'!$D$17","v":0},{"$f":"'8월'!$D$18","v":0},{"$f":"'8월'!$D$19","v":0},{"$f":"'8월'!$D$20","v":0}]
["9월",{"$f":"'9월'!$N$13","v":0},{"$f":"'9월'!$D$21","v":0},0,{"$f":"'9월'!$D$5","v":0},{"$f":"'9월'!$D$6","v":0},{"$f":"'9월'!$D$7","v":0},{"$f":"'9월'!$D$8","v":0},{"$f":"'9월'!$D$9","v":0},{"$f":"'9월'!$D$10","v":0},{"$f":"'9월'!$D$11","v":0},{"$f":"'9월'!$D$12","v":0},{"$f":"'9월'!$D$13","v":0},{"$f":"'9월'!$D$14","v":0},{"$f":"'9월'!$D$15","v":0},{"$f":"'9월'!$D$16","v":0},{"$f":"'9월'!$D$17","v":0},{"$f":"'9월'!$D$18","v":0},{"$f":"'9월'!$D$19","v":0},{"$f":"'9월'!$D$20","v":0}]
["10월",{"$f":"'10월'!$N$13","v":0},{"$f":"'10월'!$D$21","v":0},0,{"$f":"'10월'!$D$5","v":0},{"$f":"'10월'!$D$6","v":0},{"$f":"'10월'!$D$7","v":0},{"$f":"'10월'!$D$8","v":0},{"$f":"'10월'!$D$9","v":0},{"$f":"'10월'!$D$10","v":0},{"$f":"'10월'!$D$11","v":0},{"$f":"'10월'!$D$12","v":0},{"$f":"'10월'!$D$13","v":0},{"$f":"'10월'!$D$14","v":0},{"$f":"'10월'!$D$15","v":0},{"$f":"'10월'!$D$16","v":0},{"$f":"'10월'!$D$17","v":0},{"$f":"'10월'!$D$18","v":0},{"$f":"'10월'!$D$19","v":0},{"$f":"'10월'!$D$20","v":0}]
["11월",{"$f":"'11월'!$N$13","v":2786050},{"$f":"'11월'!$D$21","v":2414021},372029,{"$f":"'11월'!$D$5","v":0},{"$f":"'11월'!$D$6","v":302080},{"$f":"'11월'!$D$7","v":720821},{"$f":"'11월'!$D$8","v":166080},{"$f":"'11월'!$D$9","v":0},{"$f":"'11월'!$D$10","v":34020},{"$f":"'11월'!$D$11","v":6500},{"$f":"'11월'!$D$12","v":71260},{"$f":"'11월'!$D$13","v":374650},{"$f":"'11월'!$D$14","v":25540},{"$f":"'11월'!$D$15","v":0},{"$f":"'11월'!$D$16","v":359170},{"$f":"'11월'!$D$17","v":350000},{"$f":"'11월'!$D$18","v":0},{"$f":"'11월'!$D$19","v":0},{"$f":"'11월'!$D$20","v":3900}]
["12월",{"$f":"'12월'!$N$13","v":2750150},{"$f":"'12월'!$D$21","v":1168569},1581581,{"$f":"'12월'!$D$5","v":0},{"$f":"'12월'!$D$6","v":261920},{"$f":"'12월'!$D$7","v":268299},{"$f":"'12월'!$D$8","v":38070},{"$f":"'12월'!$D$9","v":0},{"$f":"'12월'!$D$10","v":0},{"$f":"'12월'!$D$11","v":32300},{"$f":"'12월'!$D$12","v":181810},{"$f":"'12월'!$D$13","v":356730},{"$f":"'12월'!$D$14","v":25540},{"$f":"'12월'!$D$15","v":0},{"$f":"'12월'!$D$16","v":0},{"$f":"'12월'!$D$17","v":0},{"$f":"'12월'!$D$18","v":0},{"$f":"'12월'!$D$19","v":0},{"$f":"'12월'!$D$20","v":3900}]

{"sheet":"세부항목","index":13,"n_rows":24,"n_cols":18,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
["결제방법","수입","저축_투자","주거","식비","생활용품","의복_미용","건강","자기계발","자동차","육아","보험","이벤트","섬김비","헌금","기부","통신비","기타"]
["신한은행","월급","신한저축","관리비","식자재","가전/가구","의류/잡화","병원/약국","스터디","주유비","육아용품","암보험","소풍","가족/친지","십일조","CCC","김인철","택시비"]
["하나카드","기타수입","저축","도시가스","간식비","기타용품","미용/헤어","건강용품","운동","보험/세금","교육비","실비보험","놀이방","지인","주일헌금","컨패션","김진령","택배비"]
["신한카드","이자",null,"대출이자","외식",null,"세탁/수선",null,"도서/문구","소모품/수리","장난감","손해보험","기타","기타","셀모임","치킨캠프",null,"기타"]
["삼성카드",null,null,"수리/청소",null,null,null,null,"문화생활","주차/통행료",null,null,null,null,"기타헌금","섬김비"]
["현금",null,null,"렌탈비",null,null,null,null,"기타"]
["군산사랑",null,null,"KT인터넷"]
[]
[null,null,null,null,null,null,null,null,"자기계발 아래 '기타'항목을 추가해 보겠습니다."]
[]
[]
[null,null,null,"안녕하세요 지금부터 대항목 소항목 추가 삭제방법을 알려드리겠습니다."]
[]
[]
[]
["신한생명㈜",18343837]
["키움증권",23000000]
["농협",2030673]
["미국주식","120달러"]
[]
["농협,김진령",361294]
["농협,김인철",257911]
["농협,섬김비",821692]
["농협,치캠",292802,"공금"]