{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["Monthly income","Monthly Savings","Monthly Expenses","Chart Data"],"not_rendered":{"charts":1,"defined_names":10},"read":"whole","date_system":"1900"}

{"sheet":"Monthly income","index":0,"n_rows":16,"n_cols":3,"rows_kept":16,"merged":[[2,1,9,1],[11,1,11,2]]}
[null,"Budget"]
[null,"% of income spent","Summary"]
[null,"% of income spent pie chart. The percentage value can be found in cell below","Total Monthly Income"]
[null,null,{"$f":"SUM(Income[Amount])","v":{"v":3750,"d":"£3,750"}}]
[null,null,"Total Monthly Expenses"]
[null,null,{"$f":"SUM(Expenses[[#All],[Amount]])","v":{"v":2058,"d":"£2,058"}}]
[null,null,"Total Monthly Savings"]
[null,null,{"$f":"SUM(Savings[[#All],[Amount]])","v":{"v":550,"d":"£550"}}]
[null,null,"Cash Balance"]
[null,null,{"$f":"Total_Monthly_Income-Total_Monthly_Expenses-Total_Monthly_Savings","v":{"v":1142,"d":"£1,142"}}]
[null,{"$f":"MIN(Total_Monthly_Expenses/Total_Monthly_Income,1)","v":{"v":0.5488,"d":"55%"}}]
[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 Savings","index":1,"n_rows":6,"n_cols":3,"rows_kept":6}
[null,{"$f":"BudgetTitle","v":"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":"Monthly Expenses","index":2,"n_rows":12,"n_cols":3,"rows_kept":12}
[null,{"$f":"BudgetTitle","v":"Budget"}]
[null,"Monthly Expenses"]
[null,"Item","Amount"]
[null,"Rent/mortgage",{"v":800,"d":"£800.00"}]
[null,"Electricity",{"v":120,"d":"£120.00"}]
[null,"Gas",{"v":50,"d":"£50.00"}]
[null,"Mobile phone",{"v":45,"d":"£45.00"}]
[null,"Food and household supplies",{"v":500,"d":"£500.00"}]
[null,"Car payment",{"v":273,"d":"£273.00"}]
[null,"Credit cards",{"v":120,"d":"£120.00"}]
[null,"Car insurance",{"v":50,"d":"£50.00"}]
[null,"Miscellaneous",{"v":100,"d":"£100.00"}]

{"sheet":"Chart Data","index":3,"n_rows":4,"n_cols":2,"rows_kept":4,"hidden":true}
[null,"CHART DATA"]
[null,{"$f":"MIN(1-B3,1)","v":{"v":0.45120000000000005,"d":"45%"}}]
[null,{"$f":"MIN(Total_Monthly_Expenses/Total_Monthly_Income,1)","v":{"v":0.5488,"d":"55%"}}]
[null,{"$f":"(Total_Monthly_Expenses/Total_Monthly_Income)>1","v":false}]