{"text_format":"3","workbook":"xlsx","n_sheets":5,"sheets":["Summary","Monthly income","Monthly expenses","Monthly savings","Chart Data"],"not_rendered":{"charts":2,"defined_names":15},"read":"whole","date_system":"1900"}

{"sheet":"Summary","index":0,"n_rows":10,"n_cols":3,"rows_kept":10,"merged":[[2,1,9,1],[2,4,10,8]]}
[null,"Personal budget"]
[null,"Percentage of income spent","Summary"]
[null,null,"TOTAL MONTHLY INCOME"]
[null,null,{"$f":"SUM(MonthlyIncome[[#All],[AMOUNT]])","v":{"v":3750,"d":"$3,750"}}]
[null,null,"TOTAL MONTHLY EXPENSES"]
[null,null,{"$f":"SUM(MonthlyExpenses[[#All],[AMOUNT]])","v":{"v":2336,"d":"$2,336"}}]
[null,null,"TOTAL MONTHLY SAVINGS"]
[null,null,{"$f":"SUM(Savings[[#All],[AMOUNT]])","v":{"v":550,"d":"$550"}}]
[null,null,"CASH BALANCE"]
[null,null,{"$f":"TotalMonthlyIncome-TotalMonthlyExpenses-TotalMonthlySavings","v":{"v":864,"d":"$864"}}]

{"sheet":"Monthly income","index":1,"n_rows":6,"n_cols":3,"rows_kept":6}
[null,{"$f":"BudgetTitle","v":"Personal budget"}]
[null,"Monthly income"]
[null,"ITEM","AMOUNT"]
[null,"Income source 1",{"v":2500,"d":"$2,500.00"}]
[null,"Income source 2",{"v":1000,"d":"$1,000.00"}]
[null,"Other",{"v":250,"d":"$250.00"}]

{"sheet":"Monthly expenses","index":2,"n_rows":16,"n_cols":4,"rows_kept":16}
[null,{"$f":"BudgetTitle","v":"Personal budget"}]
[null,"Monthly expenses"]
[null,"ITEM","DUE DATE","AMOUNT"]
[null,"Rent/mortgage","Date",{"v":800,"d":"$800.00"}]
[null,"Electric","Date",{"v":120,"d":"$120.00"}]
[null,"Gas","Date",{"v":50,"d":"$50.00"}]
[null,"Cell phone","Date",{"v":45,"d":"$45.00"}]
[null,"Groceries","Date",{"v":500,"d":"$500.00"}]
[null,"Car payment","Date",{"v":273,"d":"$273.00"}]
[null,"Auto expenses","Date",{"v":120,"d":"$120.00"}]
[null,"Student loans","Date",{"v":50,"d":"$50.00"}]
[null,"Credit cards","Date",{"v":100,"d":"$100.00"}]
[null,"Auto Insurance","Date",{"v":78,"d":"$78.00"}]
[null,"Personal care","Date",{"v":50,"d":"$50.00"}]
[null,"Entertainment","Date",{"v":100,"d":"$100.00"}]
[null,"Miscellaneous","Date",{"v":50,"d":"$50.00"}]

{"sheet":"Monthly savings","index":3,"n_rows":6,"n_cols":3,"rows_kept":6}
[null,{"$f":"BudgetTitle","v":"Personal budget"}]
[null,"Monthly savings"]
[null,"DATE","AMOUNT"]
[null,"Date",{"v":200,"d":"$200.00"}]
[null,"Date",{"v":250,"d":"$250.00"}]
[null,"Date",{"v":100,"d":"$100.00"}]

{"sheet":"Chart Data","index":4,"n_rows":6,"n_cols":2,"rows_kept":6,"hidden":true}
[]
[null,"CHART DATA"]
[]
[null,{"$f":"MIN(1,1-B5)","v":{"v":0.37706666666666666,"d":"38%"}}]
[null,{"$f":"MIN(TotalMonthlyExpenses/TotalMonthlyIncome,1)","v":{"v":0.6229333333333333,"d":"62%"}}]
[null,{"$f":"(TotalMonthlyExpenses/TotalMonthlyIncome)>1","v":false}]