{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["Cash Flow","Monthly Income","Monthly Expense","CHART DATA"],"not_rendered":{"charts":1,"defined_names":10},"read":"whole","date_system":"1900"}

{"sheet":"Cash Flow","index":0,"n_rows":9,"n_cols":5,"rows_kept":9}
[null,"Name"]
[null,"Family Budget"]
[null,{"$f":"TEXT(TODAY(),\"mmmm\")","v":"September"}]
[null,{"$f":"YEAR(TODAY())","v":2017}]
[null,"Note: Cash Flow table is automatically calculated based on entries from the Monthly Income and Monthly Expense worksheets"]
[null,"Cash Flow","Projected","Actual","Variance"]
[null,"Total Income",{"$f":"Income[[#Totals],[Projected]]","v":{"v":5700,"d":"5,700"}},{"$f":"Income[[#Totals],[Actual]]","v":{"v":5500,"d":"5,500"}},{"$f":"Income[[#Totals],[Variance]]","v":-200}]
[null,"Total Expense",{"$f":"Expense[[#Totals],[Projected]]","v":{"v":3603,"d":"3,603"}},{"$f":"Expense[[#Totals],[Actual]]","v":{"v":3655,"d":"3,655"}},{"$f":"Expense[[#Totals],[Variance]]","v":-52}]
[null,"Total Cash",{"$f":"C7-C8","v":{"v":2097,"d":"2,097"}},{"$f":"D7-D8","v":{"v":1845,"d":"1,845"}},{"$f":"SUBTOTAL(109,CashFlow[Variance])","v":-252}]

{"sheet":"Monthly Income","index":1,"n_rows":9,"n_cols":5,"rows_kept":9}
[null,{"$f":"Name","v":"Name"}]
[null,{"$f":"BudgetTitle","v":"Family Budget"}]
[null,{"$f":"Month","v":"September"}]
[null,{"$f":"Year","v":2017}]
[null,"Monthly Income","Projected","Actual","Variance"]
[null,"Income 1",{"v":4000,"d":"4,000"},{"v":4000,"d":"4,000"},{"$f":"Income[[#This Row],[Actual]]-Income[[#This Row],[Projected]]","v":0}]
[null,"Income 2",{"v":1400,"d":"1,400"},{"v":1500,"d":"1,500"},{"$f":"Income[[#This Row],[Actual]]-Income[[#This Row],[Projected]]","v":100}]
[null,"Other Income",300,0,{"$f":"Income[[#This Row],[Actual]]-Income[[#This Row],[Projected]]","v":-300}]
[null,"Total Income",{"$f":"SUBTOTAL(109,Income[Projected])","v":{"v":5700,"d":"5,700"}},{"$f":"SUBTOTAL(109,Income[Actual])","v":{"v":5500,"d":"5,500"}},{"$f":"SUBTOTAL(109,Income[Variance])","v":-200}]

{"sheet":"Monthly Expense","index":2,"n_rows":26,"n_cols":5,"rows_kept":26}
[null,{"$f":"Name","v":"Name"}]
[null,{"$f":"BudgetTitle","v":"Family Budget"}]
[null,{"$f":"Month","v":"September"}]
[null,{"$f":"Year","v":2017}]
[null,"Monthly Expense","Projected","Actual","Variance"]
[null,"Housing",{"v":1500,"d":"1,500"},{"v":1500,"d":"1,500"},{"$f":"Expense[[#This Row],[Projected]]-Expense[[#This Row],[Actual]]","v":0}]
[null,"Groceries",250,280,{"$f":"Expense[[#This Row],[Projected]]-Expense[[#This Row],[Actual]]","v":-30}]
[null,"Telephone",38,38,{"$f":"Expense[[#This Row],[Projected]]-Expense[[#This Row],[Actual]]","v":0}]
[null,"Electric / Gas",65,78,{"$f":"Expense[[#This Row],[Projected]]-Expense[[#This Row],[Actual]]","v":-13}]
[null,"Water / Sewage / Waste Disposal",25,21,{"$f":"Expense[[#This Row],[Projected]]-Expense[[#This Row],[Actual]]","v":4}]
[null,"Cable TV",75,83,{"$f":"Expense[[#This Row],[Projected]]-Expense[[#This Row],[Actual]]","v":-8}]
[null,"Internet",60,60,{"$f":"Expense[[#This Row],[Projected]]-Expense[[#This Row],[Actual]]","v":0}]
[null,"Maintenance / Repairs",0,60,{"$f":"Expense[[#This Row],[Projected]]-Expense[[#This Row],[Actual]]","v":-60}]
[null,"Childcare",180,150,{"$f":"Expense[[#This Row],[Projected]]-Expense[[#This Row],[Actual]]","v":30}]
[null,"Tuition",250,250,{"$f":"Expense[[#This Row],[Projected]]-Expense[[#This Row],[Actual]]","v":0}]
[null,"Pets",75,80,{"$f":"Expense[[#This Row],[Projected]]-Expense[[#This Row],[Actual]]","v":-5}]
[null,"Transport",280,260,{"$f":"Expense[[#This Row],[Projected]]-Expense[[#This Row],[Actual]]","v":20}]
[null,"Personal Care",75,65,{"$f":"Expense[[#This Row],[Projected]]-Expense[[#This Row],[Actual]]","v":10}]
[null,"Insurance",255,255,{"$f":"Expense[[#This Row],[Projected]]-Expense[[#This Row],[Actual]]","v":0}]
[null,"Credit Cards",100,100,{"$f":"Expense[[#This Row],[Projected]]-Expense[[#This Row],[Actual]]","v":0}]
[null,"Loans",0,0,{"$f":"Expense[[#This Row],[Projected]]-Expense[[#This Row],[Actual]]","v":0}]
[null,"Taxes",0,0,{"$f":"Expense[[#This Row],[Projected]]-Expense[[#This Row],[Actual]]","v":0}]
[null,"Gifts / Charity",150,150,{"$f":"Expense[[#This Row],[Projected]]-Expense[[#This Row],[Actual]]","v":0}]
[null,"Savings",225,225,{"$f":"Expense[[#This Row],[Projected]]-Expense[[#This Row],[Actual]]","v":0}]
[null,"Other",0,0,{"$f":"Expense[[#This Row],[Projected]]-Expense[[#This Row],[Actual]]","v":0}]
[null,"Total",{"$f":"SUBTOTAL(109,Expense[Projected])","v":{"v":3603,"d":"3,603"}},{"$f":"SUBTOTAL(109,Expense[Actual])","v":{"v":3655,"d":"3,655"}},{"$f":"SUBTOTAL(109,Expense[Variance])","v":-52}]

{"sheet":"CHART DATA","index":3,"n_rows":6,"n_cols":4,"rows_kept":6,"hidden":true}
[null,"CHART DATA"]
[]
[null,null,"Projected","Actual"]
[null,"Cash Flow",{"$f":"CashFlow[[#Totals],[Projected]]","v":2097},{"$f":"CashFlow[[#Totals],[Actual]]","v":1845}]
[null,"Monthly Income",{"$f":"Income[[#Totals],[Projected]]","v":5700},{"$f":"Income[[#Totals],[Actual]]","v":5500}]
[null,"Monthly Expense",{"$f":"Expense[[#Totals],[Projected]]","v":3603},{"$f":"Expense[[#Totals],[Actual]]","v":3655}]