{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Monthly Family Budget"],"read":"whole","date_system":"1900"}

{"sheet":"Monthly Family Budget","index":0,"n_rows":67,"n_cols":10,"rows_kept":67}
[null,"Monthly Family Budget"]
[null,"Summary Table","Total\nProjected Cost","Total\nActual Cost","Total\nDifference",null,"Projected Monthly Income Source","Amount"]
[null,null,{"$f":"Housing[[#Totals],[Projected\nCost]]+Transport[[#Totals],[Projected\nCost]]+Insurance[[#Totals],[Projected\nCost]]+Food[[#Totals],[Projected\nCost]]+Children[[#Totals],[Projected\nCost]]+Legal[[#Totals],[Projected\nCost]]+Savings[[#Totals],[Projected\nCost]]+Loans[[#Totals],[Projected\nCost]]+Entertainment[[#Totals],[Projected\nCost]]+Taxes[[#Totals],[Projected \nCost]]+PersonalCare[[#Totals],[Projected\nCost]]+Pets[[#Totals],[Projected\nCost]]+Gifts[[#Totals],[Projected\nCost]]","v":{"v":1203,"d":"£1,203"}},{"$f":"Housing[[#Totals],[Actual\nCost]]+Transport[[#Totals],[Actual\nCost]]+Insurance[[#Totals],[Actual\nCost]]+Food[[#Totals],[Actual\nCost]]+Children[[#Totals],[Actual\nCost]]+Legal[[#Totals],[Actual\nCost]]+Savings[[#Totals],[Actual\nCost]]+Loans[[#Totals],[Actual\nCost]]+Entertainment[[#Totals],[Actual\nCost]]+Taxes[[#Totals],[Actual \nCost]]+PersonalCare[[#Totals],[Actual\nCost]]+Pets[[#Totals],[Actual\nCost]]+Gifts[[#Totals],[Actual\nCost]]","v":{"v":1317,"d":"£1,317"}},{"$f":"Housing[[#Totals],[Difference]]+Transport[[#Totals],[Difference]]+Insurance[[#Totals],[Difference]]+Food[[#Totals],[Difference]]+Children[[#Totals],[Difference]]+Legal[[#Totals],[Difference]]+Savings[[#Totals],[Difference]]+Loans[[#Totals],[Difference]]+Entertainment[[#Totals],[Difference]]+Taxes[[#Totals],[Difference]]+PersonalCare[[#Totals],[Difference]]+Pets[[#Totals],[Difference]]+Gifts[[#Totals],[Difference]]","v":{"v":-114,"d":"-£114"}},null,"Income 1",{"v":4000,"d":"£4,000"}]
[{"$nulls":6},"Income 2",{"v":1200,"d":"£1,200"}]
[null,"Housing","Projected\nCost","Actual\nCost","Difference",null,"Extra income",{"v":300,"d":"£300"}]
[null,"Mortgage or rent",{"v":1000,"d":"£1,000"},{"v":1000,"d":"£1,000"},{"$f":"Housing[Projected\nCost]-Housing[Actual\nCost]","v":{"v":0,"d":"£0"}},null,"Total monthly income",{"$f":"SUM(H3:H5)","v":{"v":5500,"d":"£5,500"}}]
[null,"Second mortgage or rent",{"v":0,"d":"£0"},{"v":0,"d":"£0"},{"$f":"Housing[Projected\nCost]-Housing[Actual\nCost]","v":{"v":0,"d":"£0"}}]
[null,"Phone",{"v":62,"d":"£62"},{"v":100,"d":"£100"},{"$f":"Housing[Projected\nCost]-Housing[Actual\nCost]","v":{"v":-38,"d":"-£38"}},null,"Actual Monthly Income Source","Amount"]
[null,"Electricity",{"v":44,"d":"£44"},{"v":125,"d":"£125"},{"$f":"Housing[Projected\nCost]-Housing[Actual\nCost]","v":{"v":-81,"d":"-£81"}},null,"Income 1",{"v":4000,"d":"£4,000"}]
[null,"Gas",{"v":22,"d":"£22"},{"v":35,"d":"£35"},{"$f":"Housing[Projected\nCost]-Housing[Actual\nCost]","v":{"v":-13,"d":"-£13"}},null,"Income 2",{"v":1200,"d":"£1,200"}]
[null,"Water and sewer",{"v":8,"d":"£8"},{"v":8,"d":"£8"},{"$f":"Housing[Projected\nCost]-Housing[Actual\nCost]","v":{"v":0,"d":"£0"}},null,"Extra income",{"v":300,"d":"£300"}]
[null,"Cable",{"v":34,"d":"£34"},{"v":39,"d":"£39"},{"$f":"Housing[Projected\nCost]-Housing[Actual\nCost]","v":{"v":-5,"d":"-£5"}},null,"Total monthly income",{"$f":"SUM(H9:H11)","v":{"v":5500,"d":"£5,500"}}]
[null,"Waste removal",{"v":10,"d":"£10"},{"v":10,"d":"£10"},{"$f":"Housing[Projected\nCost]-Housing[Actual\nCost]","v":{"v":0,"d":"£0"}}]
[null,"Maintenance or repairs",{"v":23,"d":"£23"},{"v":0,"d":"£0"},{"$f":"Housing[Projected\nCost]-Housing[Actual\nCost]","v":{"v":23,"d":"£23"}},null,"Balance","Amount"]
[null,"Supplies",{"v":0,"d":"£0"},{"v":0,"d":"£0"},{"$f":"Housing[Projected\nCost]-Housing[Actual\nCost]","v":{"v":0,"d":"£0"}},null,"Projected balance",{"$f":"SUM(H6-'Monthly Family Budget'!$C$3:$C$3)","v":{"v":4297,"d":"£4,297"}}]
[null,"Other",{"v":0,"d":"£0"},{"v":0,"d":"£0"},{"$f":"Housing[Projected\nCost]-Housing[Actual\nCost]","v":{"v":0,"d":"£0"}},null,"Actual balance",{"$f":"SUM(H12-D3)","v":{"v":4183,"d":"£4,183"}}]
[null,"Total",{"$f":"SUBTOTAL(109,Housing[Projected\nCost])","v":{"v":1203,"d":"£1,203"}},{"$f":"SUBTOTAL(109,Housing[Actual\nCost])","v":{"v":1317,"d":"£1,317"}},{"$f":"SUBTOTAL(109,Housing[Difference])","v":{"v":-114,"d":"-£114"}},null,"Difference",{"$f":"SUM(H16-H15)","v":{"v":-114,"d":"-£114"}}]
[]
[null,"Transport","Projected\nCost","Actual\nCost","Difference",null,"Loans","Projected\nCost","Actual\nCost","Difference"]
[null,"Vehicle 1 payment",null,null,{"$f":"Transport[Projected\nCost]-Transport[Actual\nCost]","v":{"v":0,"d":"£0"}},null,"Personal",null,null,{"$f":"Loans[Projected\nCost]-Loans[Actual\nCost]","v":{"v":0,"d":"£0"}}]
[null,"Vehicle 2 payment",null,null,{"$f":"Transport[Projected\nCost]-Transport[Actual\nCost]","v":{"v":0,"d":"£0"}},null,"Student",null,null,{"$f":"Loans[Projected\nCost]-Loans[Actual\nCost]","v":{"v":0,"d":"£0"}}]
[null,"Bus/taxi fare",null,null,{"$f":"Transport[Projected\nCost]-Transport[Actual\nCost]","v":{"v":0,"d":"£0"}},null,"Credit card",null,null,{"$f":"Loans[Projected\nCost]-Loans[Actual\nCost]","v":{"v":0,"d":"£0"}}]
[null,"Insurance",null,null,{"$f":"Transport[Projected\nCost]-Transport[Actual\nCost]","v":{"v":0,"d":"£0"}},null,"Credit card",null,null,{"$f":"Loans[Projected\nCost]-Loans[Actual\nCost]","v":{"v":0,"d":"£0"}}]
[null,"Licensing",null,null,{"$f":"Transport[Projected\nCost]-Transport[Actual\nCost]","v":{"v":0,"d":"£0"}},null,"Credit card",null,null,{"$f":"Loans[Projected\nCost]-Loans[Actual\nCost]","v":{"v":0,"d":"£0"}}]
[null,"Fuel",null,null,{"$f":"Transport[Projected\nCost]-Transport[Actual\nCost]","v":{"v":0,"d":"£0"}},null,"Other",null,null,{"$f":"Loans[Projected\nCost]-Loans[Actual\nCost]","v":{"v":0,"d":"£0"}}]
[null,"Maintenance",null,null,{"$f":"Transport[Projected\nCost]-Transport[Actual\nCost]","v":{"v":0,"d":"£0"}},null,"Total",{"$f":"SUBTOTAL(109,Loans[Projected\nCost])","v":{"v":0,"d":"£0"}},{"$f":"SUBTOTAL(109,Loans[Actual\nCost])","v":{"v":0,"d":"£0"}},{"$f":"SUBTOTAL(109,Loans[Difference])","v":{"v":0,"d":"£0"}}]
[null,"Other",null,null,{"$f":"Transport[Projected\nCost]-Transport[Actual\nCost]","v":{"v":0,"d":"£0"}}]
[null,"Total",{"$f":"SUBTOTAL(109,Transport[Projected\nCost])","v":{"v":0,"d":"£0"}},{"$f":"SUBTOTAL(109,Transport[Actual\nCost])","v":{"v":0,"d":"£0"}},{"$f":"SUBTOTAL(109,Transport[Difference])","v":{"v":0,"d":"£0"}},null,"Entertainment","Projected\nCost","Actual\nCost","Difference"]
[{"$nulls":6},"Videos/DVDs",null,null,{"$f":"Entertainment[Projected\nCost]-Entertainment[Actual\nCost]","v":{"v":0,"d":"£0"}}]
[null,"Insurance","Projected\nCost","Actual\nCost","Difference",null,"CDs",null,null,{"$f":"Entertainment[Projected\nCost]-Entertainment[Actual\nCost]","v":{"v":0,"d":"£0"}}]
[null,"Home",null,null,{"$f":"Insurance[Projected\nCost]-Insurance[Actual\nCost]","v":{"v":0,"d":"£0"}},null,"Films",null,null,{"$f":"Entertainment[Projected\nCost]-Entertainment[Actual\nCost]","v":{"v":0,"d":"£0"}}]
[null,"Health",null,null,{"$f":"Insurance[Projected\nCost]-Insurance[Actual\nCost]","v":{"v":0,"d":"£0"}},null,"Concerts",null,null,{"$f":"Entertainment[Projected\nCost]-Entertainment[Actual\nCost]","v":{"v":0,"d":"£0"}}]
[null,"Life",null,null,{"$f":"Insurance[Projected\nCost]-Insurance[Actual\nCost]","v":{"v":0,"d":"£0"}},null,"Sporting events",null,null,{"$f":"Entertainment[Projected\nCost]-Entertainment[Actual\nCost]","v":{"v":0,"d":"£0"}}]
[null,"Other",null,null,{"$f":"Insurance[Projected\nCost]-Insurance[Actual\nCost]","v":{"v":0,"d":"£0"}},null,"Live theatre",null,null,{"$f":"Entertainment[Projected\nCost]-Entertainment[Actual\nCost]","v":{"v":0,"d":"£0"}}]
[null,"Total",{"$f":"SUBTOTAL(109,Insurance[Projected\nCost])","v":{"v":0,"d":"£0"}},{"$f":"SUBTOTAL(109,Insurance[Actual\nCost])","v":{"v":0,"d":"£0"}},{"$f":"SUBTOTAL(109,Insurance[Difference])","v":{"v":0,"d":"£0"}},null,"Other",null,null,{"$f":"Entertainment[Projected\nCost]-Entertainment[Actual\nCost]","v":{"v":0,"d":"£0"}}]
[{"$nulls":6},"Total",{"$f":"SUBTOTAL(109,Entertainment[Projected\nCost])","v":{"v":0,"d":"£0"}},{"$f":"SUBTOTAL(109,Entertainment[Actual\nCost])","v":{"v":0,"d":"£0"}},{"$f":"SUBTOTAL(109,Entertainment[Difference])","v":{"v":0,"d":"£0"}}]
[null,"Food","Projected\nCost","Actual\nCost","Difference"]
[null,"Food and drink",null,null,{"$f":"Food[Projected\nCost]-Food[Actual\nCost]","v":{"v":0,"d":"£0"}},null,"Taxes","Projected \nCost","Actual \nCost","Difference"]
[null,"Dining out",null,null,{"$f":"Food[Projected\nCost]-Food[Actual\nCost]","v":{"v":0,"d":"£0"}},null,"Income tax",null,null,{"$f":"Taxes[Projected \nCost]-Taxes[Actual \nCost]","v":{"v":0,"d":"£0"}}]
[null,"Other",null,null,{"$f":"Food[Projected\nCost]-Food[Actual\nCost]","v":{"v":0,"d":"£0"}},null,"Council tax",null,null,{"$f":"Taxes[Projected \nCost]-Taxes[Actual \nCost]","v":{"v":0,"d":"£0"}}]
[null,"Total",{"$f":"SUBTOTAL(109,Food[Projected\nCost])","v":{"v":0,"d":"£0"}},{"$f":"SUBTOTAL(109,Food[Actual\nCost])","v":{"v":0,"d":"£0"}},{"$f":"SUBTOTAL(109,Food[Difference])","v":{"v":0,"d":"£0"}},null,"VAT/Corporation tax",null,null,{"$f":"Taxes[Projected \nCost]-Taxes[Actual \nCost]","v":{"v":0,"d":"£0"}}]
[{"$nulls":6},"Other",null,null,{"$f":"Taxes[Projected \nCost]-Taxes[Actual \nCost]","v":{"v":0,"d":"£0"}}]
[null,"Children","Projected\nCost","Actual\nCost","Difference",null,"Total",{"$f":"SUBTOTAL(109,Taxes[Projected \nCost])","v":{"v":0,"d":"£0"}},{"$f":"SUBTOTAL(109,Taxes[Actual \nCost])","v":{"v":0,"d":"£0"}},{"$f":"SUBTOTAL(109,Taxes[Difference])","v":{"v":0,"d":"£0"}}]
[null,"Medical",null,null,{"$f":"Children[Projected\nCost]-Children[Actual\nCost]","v":{"v":0,"d":"£0"}}]
[null,"Clothing",null,null,{"$f":"Children[Projected\nCost]-Children[Actual\nCost]","v":{"v":0,"d":"£0"}},null,"Personal Care","Projected\nCost","Actual\nCost","Difference"]
[null,"School tuition",null,null,{"$f":"Children[Projected\nCost]-Children[Actual\nCost]","v":{"v":0,"d":"£0"}},null,"Medical",null,null,{"$f":"PersonalCare[Projected\nCost]-PersonalCare[Actual\nCost]","v":{"v":0,"d":"£0"}}]
[null,"School supplies",null,null,{"$f":"Children[Projected\nCost]-Children[Actual\nCost]","v":{"v":0,"d":"£0"}},null,"Hair/nails",null,null,{"$f":"PersonalCare[Projected\nCost]-PersonalCare[Actual\nCost]","v":{"v":0,"d":"£0"}}]
[null,"Organisation dues or fees",null,null,{"$f":"Children[Projected\nCost]-Children[Actual\nCost]","v":{"v":0,"d":"£0"}},null,"Clothing",null,null,{"$f":"PersonalCare[Projected\nCost]-PersonalCare[Actual\nCost]","v":{"v":0,"d":"£0"}}]
[null,"Lunch money",null,null,{"$f":"Children[Projected\nCost]-Children[Actual\nCost]","v":{"v":0,"d":"£0"}},null,"Dry cleaning",null,null,{"$f":"PersonalCare[Projected\nCost]-PersonalCare[Actual\nCost]","v":{"v":0,"d":"£0"}}]
[null,"Childcare",null,null,{"$f":"Children[Projected\nCost]-Children[Actual\nCost]","v":{"v":0,"d":"£0"}},null,"Health club",null,null,{"$f":"PersonalCare[Projected\nCost]-PersonalCare[Actual\nCost]","v":{"v":0,"d":"£0"}}]
[null,"Toys/games",null,null,{"$f":"Children[Projected\nCost]-Children[Actual\nCost]","v":{"v":0,"d":"£0"}},null,"Organisation dues/fees",null,null,{"$f":"PersonalCare[Projected\nCost]-PersonalCare[Actual\nCost]","v":{"v":0,"d":"£0"}}]
[null,"Other",null,null,{"$f":"Children[Projected\nCost]-Children[Actual\nCost]","v":{"v":0,"d":"£0"}},null,"Other",null,null,{"$f":"PersonalCare[Projected\nCost]-PersonalCare[Actual\nCost]","v":{"v":0,"d":"£0"}}]
[null,"Total",{"$f":"SUBTOTAL(109,Children[Projected\nCost])","v":{"v":0,"d":"£0"}},{"$f":"SUBTOTAL(109,Children[Actual\nCost])","v":{"v":0,"d":"£0"}},{"$f":"SUBTOTAL(109,Children[Difference])","v":{"v":0,"d":"£0"}},null,"Total",{"$f":"SUBTOTAL(109,PersonalCare[Projected\nCost])","v":{"v":0,"d":"£0"}},{"$f":"SUBTOTAL(109,PersonalCare[Actual\nCost])","v":{"v":0,"d":"£0"}},{"$f":"SUBTOTAL(109,PersonalCare[Difference])","v":{"v":0,"d":"£0"}}]
[]
[null,"Legal","Projected\nCost","Actual\nCost","Difference",null,"Pets","Projected\nCost","Actual\nCost","Difference"]
[null,"Lawyer",null,null,{"$f":"Legal[Projected\nCost]-Legal[Actual\nCost]","v":{"v":0,"d":"£0"}},null,"Food",null,null,{"$f":"Pets[Projected\nCost]-Pets[Actual\nCost]","v":{"v":0,"d":"£0"}}]
[null,"Spousal maintenance support",null,null,{"$f":"Legal[Projected\nCost]-Legal[Actual\nCost]","v":{"v":0,"d":"£0"}},null,"Medical",null,null,{"$f":"Pets[Projected\nCost]-Pets[Actual\nCost]","v":{"v":0,"d":"£0"}}]
[null,"Payments",null,null,{"$f":"Legal[Projected\nCost]-Legal[Actual\nCost]","v":{"v":0,"d":"£0"}},null,"Grooming",null,null,{"$f":"Pets[Projected\nCost]-Pets[Actual\nCost]","v":{"v":0,"d":"£0"}}]
[null,"Other",null,null,{"$f":"Legal[Projected\nCost]-Legal[Actual\nCost]","v":{"v":0,"d":"£0"}},null,"Toys",null,null,{"$f":"Pets[Projected\nCost]-Pets[Actual\nCost]","v":{"v":0,"d":"£0"}}]
[null,"Total",{"$f":"SUBTOTAL(109,Legal[Projected\nCost])","v":{"v":0,"d":"£0"}},{"$f":"SUBTOTAL(109,Legal[Actual\nCost])","v":{"v":0,"d":"£0"}},{"$f":"SUBTOTAL(109,Legal[Difference])","v":{"v":0,"d":"£0"}},null,"Other",null,null,{"$f":"Pets[Projected\nCost]-Pets[Actual\nCost]","v":{"v":0,"d":"£0"}}]
[{"$nulls":6},"Total",{"$f":"SUBTOTAL(109,Pets[Projected\nCost])","v":{"v":0,"d":"£0"}},{"$f":"SUBTOTAL(109,Pets[Actual\nCost])","v":{"v":0,"d":"£0"}},{"$f":"SUBTOTAL(109,Pets[Difference])","v":{"v":0,"d":"£0"}}]
[null,"Savings/Investments","Projected\nCost","Actual\nCost","Difference"]
[null,"Retirement account",null,null,{"$f":"Savings[Projected\nCost]-Savings[Actual\nCost]","v":{"v":0,"d":"£0"}},null,"Gifts and Donations","Projected\nCost","Actual\nCost","Difference"]
[null,"Investment account",null,null,{"$f":"Savings[Projected\nCost]-Savings[Actual\nCost]","v":{"v":0,"d":"£0"}},null,"Charity 1",null,null,{"$f":"Gifts[Projected\nCost]-Gifts[Actual\nCost]","v":{"v":0,"d":"£0"}}]
[null,"University",null,null,{"$f":"Savings[Projected\nCost]-Savings[Actual\nCost]","v":{"v":0,"d":"£0"}},null,"Charity 2",null,null,{"$f":"Gifts[Projected\nCost]-Gifts[Actual\nCost]","v":{"v":0,"d":"£0"}}]
[null,"Other",null,null,{"$f":"Savings[Projected\nCost]-Savings[Actual\nCost]","v":{"v":0,"d":"£0"}},null,"Charity 3",null,null,{"$f":"Gifts[Projected\nCost]-Gifts[Actual\nCost]","v":{"v":0,"d":"£0"}}]
[null,"Total",{"$f":"SUBTOTAL(109,Savings[Projected\nCost])","v":{"v":0,"d":"£0"}},{"$f":"SUBTOTAL(109,Savings[Actual\nCost])","v":{"v":0,"d":"£0"}},{"$f":"SUBTOTAL(109,Savings[Difference])","v":{"v":0,"d":"£0"}},null,"Total",{"$f":"SUBTOTAL(109,Gifts[Projected\nCost])","v":{"v":0,"d":"£0"}},{"$f":"SUBTOTAL(109,Gifts[Actual\nCost])","v":{"v":0,"d":"£0"}},{"$f":"SUBTOTAL(109,Gifts[Difference])","v":{"v":0,"d":"£0"}}]