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

{"sheet":"Personal Monthly Budget","index":0,"n_rows":62,"n_cols":10,"rows_kept":62,"merged":[[0,1,0,9],[2,1,4,1],[2,2,2,3],[2,7,2,8],[3,2,3,3],[3,7,3,8],[4,2,4,3],[4,6,4,8],[5,1,7,1],[5,2,5,3],[5,7,5,8],[6,2,6,3],[6,7,6,8],[7,2,7,3],[7,6,7,8],[20,6,20,9],[21,1,21,4],[29,6,29,9],[31,1,31,4],[36,6,36,9],[38,1,38,4],[42,6,42,9],[44,1,44,4],[48,6,48,9],[52,1,52,4],[55,6,55,9]]}
[null,"Personal Monthly Budget"]
[]
[null,"PROJECTED MONTHLY INCOME","Income 1",null,{"v":2500,"d":"£2,500"},null,"TOTAL PROJECTED EXPENSE ","(Projected income minus expenses)",null,{"$f":"SUM(C21,C31,C38,C44,C52,C62,H20,H29,H36,H42,H48,H55)","v":{"v":2060,"d":"£2,060"}}]
[null,null,"Extra income",null,{"v":500,"d":"£500"},null,"TOTAL ACTUAL EXPENSE ","(Actual income minus expenses)",null,{"$f":"SUM(D21,D31,D38,D44,D52,D62,I20,I29,I36,I42,I48,I55)","v":{"v":2040,"d":"£2,040"}}]
[null,null,"Total monthly income",null,{"$f":"SUM(E3:E4)","v":{"v":3000,"d":"£3,000"}},null,"Total expense difference",null,null,{"$f":"SUM(E21,E31,E38,E44,E52,E62,J20,J29,J36,J42,J48,J55)","v":{"v":20,"d":"£20"}}]
[null,"ACTUAL MONTHLY INCOME","Income 1",null,{"v":2500,"d":"£2,500"},null,"PROJECTED BALANCE","(Projected income minus expenses)",null,{"$f":"E5-J3","v":{"v":940,"d":"£940"}}]
[null,null,"Extra income",null,{"v":500,"d":"£500"},null,"ACTUAL BALANCE","(Actual income minus expenses)",null,{"$f":"E8-J4","v":{"v":960,"d":"£960"}}]
[null,null,"Total monthly income",null,{"$f":"SUM(E6:E7)","v":{"v":3000,"d":"£3,000"}},null,"BALANCE DIFFERENCE (Actual minus projected)",null,null,{"$f":"J7-J6","v":{"v":20,"d":"£20"}}]
[]
[null,"HOUSING","Projected Cost","Actual Cost","Difference",null,"ENTERTAINMENT","Projected Cost","Actual Cost","Difference"]
[null,"Mortgage or rent",{"v":1500,"d":"£1,500"},{"v":1400,"d":"£1,400"},{"$f":"Housing[[#This Row],[Projected Cost]]-Housing[[#This Row],[Actual Cost]]","v":{"v":100,"d":"£100"}},null,"Videos/DVDs",{"v":0,"d":"£0"},{"v":50,"d":"£50"},{"$f":"Entertainment[[#This Row],[Projected Cost]]-Entertainment[[#This Row],[Actual Cost]]","v":{"v":-50,"d":"-£50"}}]
[null,"Phone Number",{"v":60,"d":"£60"},{"v":100,"d":"£100"},{"$f":"Housing[[#This Row],[Projected Cost]]-Housing[[#This Row],[Actual Cost]]","v":{"v":-40,"d":"-£40"}},null,"CDs",null,null,{"$f":"Entertainment[[#This Row],[Projected Cost]]-Entertainment[[#This Row],[Actual Cost]]","v":{"v":0,"d":"£0"}}]
[null,"Electricity",{"v":50,"d":"£50"},{"v":60,"d":"£60"},{"$f":"Housing[[#This Row],[Projected Cost]]-Housing[[#This Row],[Actual Cost]]","v":{"v":-10,"d":"-£10"}},null,"Films",null,null,{"$f":"Entertainment[[#This Row],[Projected Cost]]-Entertainment[[#This Row],[Actual Cost]]","v":{"v":0,"d":"£0"}}]
[null,"Gas",{"v":200,"d":"£200"},{"v":180,"d":"£180"},{"$f":"Housing[[#This Row],[Projected Cost]]-Housing[[#This Row],[Actual Cost]]","v":{"v":20,"d":"£20"}},null,"Concerts",null,null,{"$f":"Entertainment[[#This Row],[Projected Cost]]-Entertainment[[#This Row],[Actual Cost]]","v":{"v":0,"d":"£0"}}]
[null,"Water and sewer",null,null,{"$f":"Housing[[#This Row],[Projected Cost]]-Housing[[#This Row],[Actual Cost]]","v":{"v":0,"d":"£0"}},null,"Sporting events",null,null,{"$f":"Entertainment[[#This Row],[Projected Cost]]-Entertainment[[#This Row],[Actual Cost]]","v":{"v":0,"d":"£0"}}]
[null,"Cable",null,null,{"$f":"Housing[[#This Row],[Projected Cost]]-Housing[[#This Row],[Actual Cost]]","v":{"v":0,"d":"£0"}},null,"Live theatre",null,null,{"$f":"Entertainment[[#This Row],[Projected Cost]]-Entertainment[[#This Row],[Actual Cost]]","v":{"v":0,"d":"£0"}}]
[null,"Waste removal",null,null,{"$f":"Housing[[#This Row],[Projected Cost]]-Housing[[#This Row],[Actual Cost]]","v":{"v":0,"d":"£0"}},null,"Other",null,null,{"$f":"Entertainment[[#This Row],[Projected Cost]]-Entertainment[[#This Row],[Actual Cost]]","v":{"v":0,"d":"£0"}}]
[null,"Maintenance or repairs",null,null,{"$f":"Housing[[#This Row],[Projected Cost]]-Housing[[#This Row],[Actual Cost]]","v":{"v":0,"d":"£0"}},null,"Other",null,null,{"$f":"Entertainment[[#This Row],[Projected Cost]]-Entertainment[[#This Row],[Actual Cost]]","v":{"v":0,"d":"£0"}}]
[null,"Supplies",null,null,{"$f":"Housing[[#This Row],[Projected Cost]]-Housing[[#This Row],[Actual Cost]]","v":{"v":0,"d":"£0"}},null,"Other",null,null,{"$f":"Entertainment[[#This Row],[Projected Cost]]-Entertainment[[#This Row],[Actual Cost]]","v":{"v":0,"d":"£0"}}]
[null,"Other",null,null,{"$f":"Housing[[#This Row],[Projected Cost]]-Housing[[#This Row],[Actual Cost]]","v":{"v":0,"d":"£0"}},null,"Total",{"$f":"SUBTOTAL(109,Entertainment[Projected Cost])","v":{"v":0,"d":"£0"}},{"$f":"SUBTOTAL(109,Entertainment[Actual Cost])","v":{"v":50,"d":"£50"}},{"$f":"SUBTOTAL(109,Entertainment[Difference])","v":{"v":-50,"d":"-£50"}}]
[null,"Total",{"$f":"SUBTOTAL(109,Housing[Projected Cost])","v":{"v":1810,"d":"£1,810"}},{"$f":"SUBTOTAL(109,Housing[Actual Cost])","v":{"v":1740,"d":"£1,740"}},{"$f":"SUBTOTAL(109,Housing[Difference])","v":{"v":70,"d":"£70"}}]
[{"$nulls":6},"LOANS","Projected Cost","Actual Cost","Difference"]
[null,"TRANSPORT","Projected Cost","Actual Cost","Difference",null,"Personal",null,null,{"$f":"Loans[[#This Row],[Projected Cost]]-Loans[[#This Row],[Actual Cost]]","v":{"v":0,"d":"£0"}}]
[null,"Vehicle payment",{"v":250,"d":"£250"},{"v":250,"d":"£250"},{"$f":"Transport[[#This Row],[Projected Cost]]-Transport[[#This Row],[Actual Cost]]","v":{"v":0,"d":"£0"}},null,"Student",null,null,{"$f":"Loans[[#This Row],[Projected Cost]]-Loans[[#This Row],[Actual Cost]]","v":{"v":0,"d":"£0"}}]
[null,"Bus/taxi fare",null,null,{"$f":"Transport[[#This Row],[Projected Cost]]-Transport[[#This Row],[Actual Cost]]","v":{"v":0,"d":"£0"}},null,"Credit card",null,null,{"$f":"Loans[[#This Row],[Projected Cost]]-Loans[[#This Row],[Actual Cost]]","v":{"v":0,"d":"£0"}}]
[null,"Insurance",null,null,{"$f":"Transport[[#This Row],[Projected Cost]]-Transport[[#This Row],[Actual Cost]]","v":{"v":0,"d":"£0"}},null,"Credit card",null,null,{"$f":"Loans[[#This Row],[Projected Cost]]-Loans[[#This Row],[Actual Cost]]","v":{"v":0,"d":"£0"}}]
[null,"Licensing",null,null,{"$f":"Transport[[#This Row],[Projected Cost]]-Transport[[#This Row],[Actual Cost]]","v":{"v":0,"d":"£0"}},null,"Credit card",null,null,{"$f":"Loans[[#This Row],[Projected Cost]]-Loans[[#This Row],[Actual Cost]]","v":{"v":0,"d":"£0"}}]
[null,"Fuel",null,null,{"$f":"Transport[[#This Row],[Projected Cost]]-Transport[[#This Row],[Actual Cost]]","v":{"v":0,"d":"£0"}},null,"Other",null,null,{"$f":"Loans[[#This Row],[Projected Cost]]-Loans[[#This Row],[Actual Cost]]","v":{"v":0,"d":"£0"}}]
[null,"Maintenance",null,null,{"$f":"Transport[[#This Row],[Projected Cost]]-Transport[[#This Row],[Actual Cost]]","v":{"v":0,"d":"£0"}},null,"Total",{"$f":"SUBTOTAL(109,Loans[Projected Cost])","v":{"v":0,"d":"£0"}},{"$f":"SUBTOTAL(109,Loans[Actual Cost])","v":{"v":0,"d":"£0"}},{"$f":"SUBTOTAL(109,Loans[Difference])","v":{"v":0,"d":"£0"}}]
[null,"Other",null,null,{"$f":"Transport[[#This Row],[Projected Cost]]-Transport[[#This Row],[Actual Cost]]","v":{"v":0,"d":"£0"}}]
[null,"Total",{"$f":"SUBTOTAL(109,Transport[Projected Cost])","v":{"v":250,"d":"£250"}},{"$f":"SUBTOTAL(109,Transport[Actual Cost])","v":{"v":250,"d":"£250"}},{"$f":"SUBTOTAL(109,Transport[Difference])","v":{"v":0,"d":"£0"}},null,"TAXES","Projected Cost","Actual Cost","Difference"]
[{"$nulls":6},"Income tax",null,null,{"$f":"Taxes[[#This Row],[Projected Cost]]-Taxes[[#This Row],[Actual Cost]]","v":{"v":0,"d":"£0"}}]
[null,"INSURANCE","Projected Cost","Actual Cost","Difference",null,"Council tax",null,null,{"$f":"Taxes[[#This Row],[Projected Cost]]-Taxes[[#This Row],[Actual Cost]]","v":{"v":0,"d":"£0"}}]
[null,"Home",null,null,{"$f":"Insurance[[#This Row],[Projected Cost]]-Insurance[[#This Row],[Actual Cost]]","v":{"v":0,"d":"£0"}},null,"VAT/Corporation tax",null,null,{"$f":"Taxes[[#This Row],[Projected Cost]]-Taxes[[#This Row],[Actual Cost]]","v":{"v":0,"d":"£0"}}]
[null,"Health",null,null,{"$f":"Insurance[[#This Row],[Projected Cost]]-Insurance[[#This Row],[Actual Cost]]","v":{"v":0,"d":"£0"}},null,"Other",null,null,{"$f":"Taxes[[#This Row],[Projected Cost]]-Taxes[[#This Row],[Actual Cost]]","v":{"v":0,"d":"£0"}}]
[null,"Life",null,null,{"$f":"Insurance[[#This Row],[Projected Cost]]-Insurance[[#This Row],[Actual Cost]]","v":{"v":0,"d":"£0"}},null,"Total",{"$f":"SUBTOTAL(109,Taxes[Projected Cost])","v":{"v":0,"d":"£0"}},{"$f":"SUBTOTAL(109,Taxes[Actual Cost])","v":{"v":0,"d":"£0"}},{"$f":"SUBTOTAL(109,Taxes[Difference])","v":{"v":0,"d":"£0"}}]
[null,"Other",null,null,{"$f":"Insurance[[#This Row],[Projected Cost]]-Insurance[[#This Row],[Actual Cost]]","v":{"v":0,"d":"£0"}}]
[null,"Total",{"$f":"SUBTOTAL(109,Insurance[Projected Cost])","v":{"v":0,"d":"£0"}},{"$f":"SUBTOTAL(109,Insurance[Actual Cost])","v":{"v":0,"d":"£0"}},{"$f":"SUBTOTAL(109,Insurance[Difference])","v":{"v":0,"d":"£0"}},null,"SAVINGS OR INVESTMENTS","Projected Cost","Actual Cost","Difference"]
[{"$nulls":6},"Retirement account",null,null,{"$f":"SavingsOrInvestment[[#This Row],[Projected Cost]]-SavingsOrInvestment[[#This Row],[Actual Cost]]","v":{"v":0,"d":"£0"}}]
[null,"FOOD","Projected Cost","Actual Cost","Difference",null,"Investment account",null,null,{"$f":"SavingsOrInvestment[[#This Row],[Projected Cost]]-SavingsOrInvestment[[#This Row],[Actual Cost]]","v":{"v":0,"d":"£0"}}]
[null,"Food and drink",null,null,{"$f":"Food[[#This Row],[Projected Cost]]-Food[[#This Row],[Actual Cost]]","v":{"v":0,"d":"£0"}},null,"Other",null,null,{"$f":"SavingsOrInvestment[[#This Row],[Projected Cost]]-SavingsOrInvestment[[#This Row],[Actual Cost]]","v":{"v":0,"d":"£0"}}]
[null,"Dining out",null,null,{"$f":"Food[[#This Row],[Projected Cost]]-Food[[#This Row],[Actual Cost]]","v":{"v":0,"d":"£0"}},null,"Total",{"$f":"SUBTOTAL(109,SavingsOrInvestment[Projected Cost])","v":{"v":0,"d":"£0"}},{"$f":"SUBTOTAL(109,SavingsOrInvestment[Actual Cost])","v":{"v":0,"d":"£0"}},{"$f":"SUBTOTAL(109,SavingsOrInvestment[Difference])","v":{"v":0,"d":"£0"}}]
[null,"Other",null,null,{"$f":"Food[[#This Row],[Projected Cost]]-Food[[#This Row],[Actual Cost]]","v":{"v":0,"d":"£0"}}]
[null,"Total",{"$f":"SUBTOTAL(109,Food[Projected Cost])","v":{"v":0,"d":"£0"}},{"$f":"SUBTOTAL(109,Food[Actual Cost])","v":{"v":0,"d":"£0"}},{"$f":"SUBTOTAL(109,Food[Difference])","v":{"v":0,"d":"£0"}},null,"PRESENTS AND DONATIONS","Projected Cost","Actual Cost","Difference"]
[{"$nulls":6},"Charity 1",null,null,{"$f":"PresentsAndDonations[[#This Row],[Projected Cost]]-PresentsAndDonations[[#This Row],[Actual Cost]]","v":{"v":0,"d":"£0"}}]
[null,"PETS","Projected Cost","Actual Cost","Difference",null,"Charity 2",null,null,{"$f":"PresentsAndDonations[[#This Row],[Projected Cost]]-PresentsAndDonations[[#This Row],[Actual Cost]]","v":{"v":0,"d":"£0"}}]
[null,"Food",null,null,{"$f":"Pets[[#This Row],[Projected Cost]]-Pets[[#This Row],[Actual Cost]]","v":{"v":0,"d":"£0"}},null,"Charity 3",null,null,{"$f":"PresentsAndDonations[[#This Row],[Projected Cost]]-PresentsAndDonations[[#This Row],[Actual Cost]]","v":{"v":0,"d":"£0"}}]
[null,"Medical",null,null,{"$f":"Pets[[#This Row],[Projected Cost]]-Pets[[#This Row],[Actual Cost]]","v":{"v":0,"d":"£0"}},null,"Total",{"$f":"SUBTOTAL(109,PresentsAndDonations[Projected Cost])","v":{"v":0,"d":"£0"}},{"$f":"SUBTOTAL(109,PresentsAndDonations[Actual Cost])","v":{"v":0,"d":"£0"}},{"$f":"SUBTOTAL(109,PresentsAndDonations[Difference])","v":{"v":0,"d":"£0"}}]
[null,"Grooming",null,null,{"$f":"Pets[[#This Row],[Projected Cost]]-Pets[[#This Row],[Actual Cost]]","v":{"v":0,"d":"£0"}}]
[null,"Toys",null,null,{"$f":"Pets[[#This Row],[Projected Cost]]-Pets[[#This Row],[Actual Cost]]","v":{"v":0,"d":"£0"}},null,"LEGAL","Projected Cost","Actual Cost","Difference"]
[null,"Other",null,null,{"$f":"Pets[[#This Row],[Projected Cost]]-Pets[[#This Row],[Actual Cost]]","v":{"v":0,"d":"£0"}},null,"Lawyer",null,null,{"$f":"Legal[[#This Row],[Projected Cost]]-Legal[[#This Row],[Actual Cost]]","v":{"v":0,"d":"£0"}}]
[null,"Total",{"$f":"SUBTOTAL(109,Pets[Projected Cost])","v":{"v":0,"d":"£0"}},{"$f":"SUBTOTAL(109,Pets[Actual Cost])","v":{"v":0,"d":"£0"}},{"$f":"SUBTOTAL(109,Pets[Difference])","v":{"v":0,"d":"£0"}},null,"Spousal maintenance support",null,null,{"$f":"Legal[[#This Row],[Projected Cost]]-Legal[[#This Row],[Actual Cost]]","v":{"v":0,"d":"£0"}}]
[{"$nulls":6},"Payments on lien or judgment",null,null,{"$f":"Legal[[#This Row],[Projected Cost]]-Legal[[#This Row],[Actual Cost]]","v":{"v":0,"d":"£0"}}]
[null,"PERSONAL CARE","Projected Cost","Actual Cost","Difference",null,"Other",null,null,{"$f":"Legal[[#This Row],[Projected Cost]]-Legal[[#This Row],[Actual Cost]]","v":{"v":0,"d":"£0"}}]
[null,"Medical",null,null,{"$f":"PersonalCare[[#This Row],[Projected Cost]]-PersonalCare[[#This Row],[Actual Cost]]","v":{"v":0,"d":"£0"}},null,"Total",{"$f":"SUBTOTAL(109,Legal[Projected Cost])","v":{"v":0,"d":"£0"}},{"$f":"SUBTOTAL(109,Legal[Actual Cost])","v":{"v":0,"d":"£0"}},{"$f":"SUBTOTAL(109,Legal[Difference])","v":{"v":0,"d":"£0"}}]
[null,"Hair/nails",null,null,{"$f":"PersonalCare[[#This Row],[Projected Cost]]-PersonalCare[[#This Row],[Actual Cost]]","v":{"v":0,"d":"£0"}}]
[null,"Clothing",null,null,{"$f":"PersonalCare[[#This Row],[Projected Cost]]-PersonalCare[[#This Row],[Actual Cost]]","v":{"v":0,"d":"£0"}}]
[null,"Dry cleaning",null,null,{"$f":"PersonalCare[[#This Row],[Projected Cost]]-PersonalCare[[#This Row],[Actual Cost]]","v":{"v":0,"d":"£0"}}]
[null,"Health club",null,null,{"$f":"PersonalCare[[#This Row],[Projected Cost]]-PersonalCare[[#This Row],[Actual Cost]]","v":{"v":0,"d":"£0"}}]
[null,"Organisation dues or fees",null,null,{"$f":"PersonalCare[[#This Row],[Projected Cost]]-PersonalCare[[#This Row],[Actual Cost]]","v":{"v":0,"d":"£0"}}]
[null,"Other",null,null,{"$f":"PersonalCare[[#This Row],[Projected Cost]]-PersonalCare[[#This Row],[Actual Cost]]","v":{"v":0,"d":"£0"}}]
[null,"Total",{"$f":"SUBTOTAL(109,PersonalCare[Projected Cost])","v":{"v":0,"d":"£0"}},{"$f":"SUBTOTAL(109,PersonalCare[Actual Cost])","v":{"v":0,"d":"£0"}},{"$f":"SUBTOTAL(109,PersonalCare[Difference])","v":{"v":0,"d":"£0"}}]