{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["현금 흐름","월별 수입","월 지출","차트 데이터"],"not_rendered":{"charts":1,"defined_names":10},"read":"whole","date_system":"1900"}

{"sheet":"현금 흐름","index":0,"n_rows":9,"n_cols":5,"rows_kept":9}
[null,"이름"]
[null,"가족 예산"]
[null,{"$f":"TEXT(TODAY(),\"m월\")","v":"1월"}]
[null,{"$f":"YEAR(TODAY())","v":2017}]
[null,"참고: 현금 흐름 표는 월 수입 및 월 지출 워크시트의 항목에 따라 자동으로 계산됩니다."]
[null,"현금 흐름","예상","실제","차이"]
[null,"총 수입",{"$f":"수입[[#Totals],[예상]]","v":{"v":5700,"d":"5,700"}},{"$f":"수입[[#Totals],[실제]]","v":{"v":5500,"d":"5,500"}},{"$f":"수입[[#Totals],[차이]]","v":-200}]
[null,"총 지출",{"$f":"경비[[#Totals],[예상]]","v":{"v":3603,"d":"3,603"}},{"$f":"경비[[#Totals],[실제]]","v":{"v":3655,"d":"3,655"}},{"$f":"경비[[#Totals],[차이]]","v":-52}]
[null,"총 현금",{"$f":"C7-C8","v":{"v":2097,"d":"2,097"}},{"$f":"D7-D8","v":{"v":1845,"d":"1,845"}},{"$f":"SUBTOTAL(109,현금_흐름[차이])","v":-252}]

{"sheet":"월별 수입","index":1,"n_rows":9,"n_cols":5,"rows_kept":9}
[null,{"$f":"이름","v":"이름"}]
[null,{"$f":"예산_제목","v":"가족 예산"}]
[null,{"$f":"월","v":"1월"}]
[null,{"$f":"연도","v":2017}]
[null,"월별 수입","예상","실제","차이"]
[null,"수입 1",{"v":4000,"d":"4,000"},{"v":4000,"d":"4,000"},{"$f":"수입[[#This Row],[실제]]-수입[[#This Row],[예상]]","v":0}]
[null,"수입 2",{"v":1400,"d":"1,400"},{"v":1500,"d":"1,500"},{"$f":"수입[[#This Row],[실제]]-수입[[#This Row],[예상]]","v":100}]
[null,"기타 수입",300,0,{"$f":"수입[[#This Row],[실제]]-수입[[#This Row],[예상]]","v":-300}]
[null,"총 수입",{"$f":"SUBTOTAL(109,수입[예상])","v":{"v":5700,"d":"5,700"}},{"$f":"SUBTOTAL(109,수입[실제])","v":{"v":5500,"d":"5,500"}},{"$f":"SUBTOTAL(109,수입[차이])","v":-200}]

{"sheet":"월 지출","index":2,"n_rows":26,"n_cols":5,"rows_kept":26}
[null,{"$f":"이름","v":"이름"}]
[null,{"$f":"예산_제목","v":"가족 예산"}]
[null,{"$f":"월","v":"1월"}]
[null,{"$f":"연도","v":2017}]
[null,"월 지출","예상","실제","차이"]
[null,"주거비",{"v":1500,"d":"1,500"},{"v":1500,"d":"1,500"},{"$f":"경비[[#This Row],[예상]]-경비[[#This Row],[실제]]","v":0}]
[null,"식료품",250,280,{"$f":"경비[[#This Row],[예상]]-경비[[#This Row],[실제]]","v":-30}]
[null,"전화",38,38,{"$f":"경비[[#This Row],[예상]]-경비[[#This Row],[실제]]","v":0}]
[null,"전기/가스",65,78,{"$f":"경비[[#This Row],[예상]]-경비[[#This Row],[실제]]","v":-13}]
[null,"상하수도/쓰레기",25,21,{"$f":"경비[[#This Row],[예상]]-경비[[#This Row],[실제]]","v":4}]
[null,"케이블 TV",75,83,{"$f":"경비[[#This Row],[예상]]-경비[[#This Row],[실제]]","v":-8}]
[null,"인터넷",60,60,{"$f":"경비[[#This Row],[예상]]-경비[[#This Row],[실제]]","v":0}]
[null,"유지 보수/수리",0,60,{"$f":"경비[[#This Row],[예상]]-경비[[#This Row],[실제]]","v":-60}]
[null,"육아",180,150,{"$f":"경비[[#This Row],[예상]]-경비[[#This Row],[실제]]","v":30}]
[null,"등록금",250,250,{"$f":"경비[[#This Row],[예상]]-경비[[#This Row],[실제]]","v":0}]
[null,"애완동물",75,80,{"$f":"경비[[#This Row],[예상]]-경비[[#This Row],[실제]]","v":-5}]
[null,"교통비",280,260,{"$f":"경비[[#This Row],[예상]]-경비[[#This Row],[실제]]","v":20}]
[null,"개인 관리",75,65,{"$f":"경비[[#This Row],[예상]]-경비[[#This Row],[실제]]","v":10}]
[null,"보험",255,255,{"$f":"경비[[#This Row],[예상]]-경비[[#This Row],[실제]]","v":0}]
[null,"신용 카드",100,100,{"$f":"경비[[#This Row],[예상]]-경비[[#This Row],[실제]]","v":0}]
[null,"대출",0,0,{"$f":"경비[[#This Row],[예상]]-경비[[#This Row],[실제]]","v":0}]
[null,"세금",0,0,{"$f":"경비[[#This Row],[예상]]-경비[[#This Row],[실제]]","v":0}]
[null,"선물/기부",150,150,{"$f":"경비[[#This Row],[예상]]-경비[[#This Row],[실제]]","v":0}]
[null,"저축",225,225,{"$f":"경비[[#This Row],[예상]]-경비[[#This Row],[실제]]","v":0}]
[null,"기타",0,0,{"$f":"경비[[#This Row],[예상]]-경비[[#This Row],[실제]]","v":0}]
[null,"총",{"$f":"SUBTOTAL(109,경비[예상])","v":{"v":3603,"d":"3,603"}},{"$f":"SUBTOTAL(109,경비[실제])","v":{"v":3655,"d":"3,655"}},{"$f":"SUBTOTAL(109,경비[차이])","v":-52}]

{"sheet":"차트 데이터","index":3,"n_rows":6,"n_cols":4,"rows_kept":6,"hidden":true}
[null,"차트 데이터"]
[]
[null,null,"예상","실제"]
[null,"현금 흐름",{"$f":"현금_흐름[[#Totals],[예상]]","v":2097},{"$f":"현금_흐름[[#Totals],[실제]]","v":1845}]
[null,"월별 수입",{"$f":"수입[[#Totals],[예상]]","v":5700},{"$f":"수입[[#Totals],[실제]]","v":5500}]
[null,"월 지출",{"$f":"경비[[#Totals],[예상]]","v":3603},{"$f":"경비[[#Totals],[실제]]","v":3655}]