{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Personal monthly budget"],"not_rendered":{"images":2},"read":"whole","date_system":"1900"}

{"sheet":"Personal monthly budget","index":0,"n_rows":70,"n_cols":11,"rows_kept":70,"merged":[[1,1,1,9],[3,1,5,1],[3,2,3,3],[4,2,4,3],[5,2,5,3],[6,1,8,1],[6,2,6,3],[7,2,7,3],[8,2,8,3],[10,2,10,3],[11,2,11,3],[13,2,13,3],[14,2,14,3]]}
[{"$nulls":10}," "]
[null,"Personal monthly budget"]
[]
[null,"PROJECTED MONTHLY INCOME","Income 1",null,{"v":2500,"d":"$2,500"}]
[null,null,"Extra income",null,{"v":500,"d":"$500"}]
[null,null,"Total monthly income",null,{"$f":"SUM(E4:E5)","v":{"v":3000,"d":"$3,000"}}]
[null,"ACTUAL MONTHLY INCOME","Income 1",null,{"v":2500,"d":"$2,500"}]
[null,null,"Extra income",null,{"v":500,"d":"$500"}]
[null,null,"Total monthly income",null,{"$f":"SUM(E7:E8)","v":{"v":3000,"d":"$3,000"}}]
[]
[null,"TOTAL PROJECTED EXPENSE ","(Combined projected cost)",null,{"$f":"SUM(C29,C39,C46,C52,C60,C70,H28,H37,H44,H50,H56,H63)","v":{"v":2060,"d":"$2,060"}}]
[null,"TOTAL ACTUAL EXPENSE ","(Combined actual cost)",null,{"$f":"SUM(D29,D39,D46,D52,D60,D70,I28,I37,I44,I50,I56,I63)","v":{"v":2040,"d":"$2,040"}}]
[null,"TOTAL EXPENSE DIFFERENCE",null,null,{"$f":"SUM(E29,E39,E46,E52,E60,E70,J28,J37,J44,J50,J56,J63)","v":{"v":20,"d":"$20"}}]
[null,"PROJECTED BALANCE","(Projected income minus expenses)",null,{"$f":"E6-E11","v":{"v":940,"d":"$940"}}]
[null,"ACTUAL BALANCE","(Actual income minus expenses)",null,{"$f":"E9-E12","v":{"v":960,"d":"$960"}}]
[null,"BALANCE DIFFERENCE (Actual minus projected)",null,null,{"$f":"E15-E14","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,"Organization 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"}}]