{"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":64,"n_cols":10,"rows_kept":64,"merged":[[3,1,5,1],[3,2,3,3],[3,6,4,8],[3,9,4,9],[4,2,4,3],[5,2,5,3],[5,6,6,8],[5,9,6,9],[7,1,9,1],[7,2,7,3],[7,6,8,8],[7,9,8,9],[8,2,8,3],[9,2,9,3],[22,6,22,9],[23,1,23,4],[31,6,31,9],[33,1,33,4],[38,6,38,9],[40,1,40,4],[44,6,44,9],[46,1,46,4],[50,6,50,9],[54,1,54,4],[57,6,57,9],[58,6,59,8],[58,9,59,9],[60,6,61,8],[60,9,61,9],[62,6,63,8],[62,9,63,9],[64,1,64,4]]}
[]
[null,"PERSONAL MONTHLY BUDGET"]
[]
[null,"PROJECTED MONTHLY INCOME","Income 1",null,{"v":4300,"d":"$4,300.00"},null,"PROJECTED BALANCE \n(Projected income minus expenses)",null,null,{"$f":"E6-J59","v":{"v":3405,"d":"$3,405.00"}}]
[null,null,"Extra income",null,{"v":300,"d":"$300.00"}]
[null,null,"Total monthly income",null,{"$f":"SUM(E4:E5)","v":{"v":4600,"d":"$4,600.00"}},null,"ACTUAL BALANCE \n(Actual income minus expenses)",null,null,{"$f":"E10-J61","v":{"v":3064,"d":"$3,064.00"}}]
[]
[null,"ACTUAL MONTHLY INCOME","Income 1",null,{"v":4000,"d":"$4,000.00"},null,"DIFFERENCE \n(Actual minus projected)",null,null,{"$f":"J6-J4","v":{"v":-341,"d":"($341.00)"}}]
[null,null,"Extra income",null,{"v":300,"d":"$300.00"}]
[null,null,"Total monthly income",null,{"$f":"SUM(E8:E9)","v":{"v":4300,"d":"$4,300.00"}}]
[]
[null,"HOUSING","Projected Cost","Actual Cost","Difference",null,"ENTERTAINMENT","Projected Cost","Actual Cost","Difference"]
[null,"Mortgage or rent",{"v":1000,"d":"$1,000.00"},{"v":1000,"d":"$1,000.00"},{"$f":"tblHousing[[#This Row],[Projected Cost]]-tblHousing[[#This Row],[Actual Cost]]","v":{"v":0,"d":"$0.00"}},null,"Video/DVD",null,null,{"$f":"tblEntertainment[[#This Row],[Projected Cost]]-tblEntertainment[[#This Row],[Actual Cost]]","v":{"v":0,"d":"$0.00"}}]
[null,"Phone",{"v":54,"d":"$54.00"},{"v":100,"d":"$100.00"},{"$f":"tblHousing[[#This Row],[Projected Cost]]-tblHousing[[#This Row],[Actual Cost]]","v":{"v":-46,"d":"-$46.00"}},null,"CDs",null,null,{"$f":"tblEntertainment[[#This Row],[Projected Cost]]-tblEntertainment[[#This Row],[Actual Cost]]","v":{"v":0,"d":"$0.00"}}]
[null,"Electricity",{"v":44,"d":"$44.00"},{"v":56,"d":"$56.00"},{"$f":"tblHousing[[#This Row],[Projected Cost]]-tblHousing[[#This Row],[Actual Cost]]","v":{"v":-12,"d":"-$12.00"}},null,"Movies",null,null,{"$f":"tblEntertainment[[#This Row],[Projected Cost]]-tblEntertainment[[#This Row],[Actual Cost]]","v":{"v":0,"d":"$0.00"}}]
[null,"Gas",{"v":22,"d":"$22.00"},{"v":28,"d":"$28.00"},{"$f":"tblHousing[[#This Row],[Projected Cost]]-tblHousing[[#This Row],[Actual Cost]]","v":{"v":-6,"d":"-$6.00"}},null,"Concerts",null,null,{"$f":"tblEntertainment[[#This Row],[Projected Cost]]-tblEntertainment[[#This Row],[Actual Cost]]","v":{"v":0,"d":"$0.00"}}]
[null,"Water and sewer",{"v":8,"d":"$8.00"},{"v":8,"d":"$8.00"},{"$f":"tblHousing[[#This Row],[Projected Cost]]-tblHousing[[#This Row],[Actual Cost]]","v":{"v":0,"d":"$0.00"}},null,"Sporting events",null,null,{"$f":"tblEntertainment[[#This Row],[Projected Cost]]-tblEntertainment[[#This Row],[Actual Cost]]","v":{"v":0,"d":"$0.00"}}]
[null,"Cable",{"v":34,"d":"$34.00"},{"v":34,"d":"$34.00"},{"$f":"tblHousing[[#This Row],[Projected Cost]]-tblHousing[[#This Row],[Actual Cost]]","v":{"v":0,"d":"$0.00"}},null,"Live theater",null,null,{"$f":"tblEntertainment[[#This Row],[Projected Cost]]-tblEntertainment[[#This Row],[Actual Cost]]","v":{"v":0,"d":"$0.00"}}]
[null,"Waste removal",{"v":10,"d":"$10.00"},{"v":10,"d":"$10.00"},{"$f":"tblHousing[[#This Row],[Projected Cost]]-tblHousing[[#This Row],[Actual Cost]]","v":{"v":0,"d":"$0.00"}},null,"Other",null,null,{"$f":"tblEntertainment[[#This Row],[Projected Cost]]-tblEntertainment[[#This Row],[Actual Cost]]","v":{"v":0,"d":"$0.00"}}]
[null,"Maintenance or repairs",{"v":23,"d":"$23.00"},{"v":0,"d":"$0.00"},{"$f":"tblHousing[[#This Row],[Projected Cost]]-tblHousing[[#This Row],[Actual Cost]]","v":{"v":23,"d":"$23.00"}},null,"Other",null,null,{"$f":"tblEntertainment[[#This Row],[Projected Cost]]-tblEntertainment[[#This Row],[Actual Cost]]","v":{"v":0,"d":"$0.00"}}]
[null,"Supplies",{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"$f":"tblHousing[[#This Row],[Projected Cost]]-tblHousing[[#This Row],[Actual Cost]]","v":{"v":0,"d":"$0.00"}},null,"Other",null,null,{"$f":"tblEntertainment[[#This Row],[Projected Cost]]-tblEntertainment[[#This Row],[Actual Cost]]","v":{"v":0,"d":"$0.00"}}]
[null,"Other",{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"$f":"tblHousing[[#This Row],[Projected Cost]]-tblHousing[[#This Row],[Actual Cost]]","v":{"v":0,"d":"$0.00"}},null,"Subtotal",null,null,{"$f":"SUBTOTAL(109,tblEntertainment[Difference])","v":{"v":0,"d":"$0.00"}}]
[null,"Subtotal",null,null,{"$f":"SUBTOTAL(109,tblHousing[Difference])","v":{"v":-41,"d":"-$41.00"}}]
[{"$nulls":6},"LOANS","Projected Cost","Actual Cost","Difference"]
[null,"TRANSPORTATION","Projected Cost","Actual Cost","Difference",null,"Personal",null,null,{"$f":"tblLoans[[#This Row],[Projected Cost]]-tblLoans[[#This Row],[Actual Cost]]","v":{"v":0,"d":"$0.00"}}]
[null,"Vehicle payment",null,null,{"$f":"tblTransportation[[#This Row],[Projected Cost]]-tblTransportation[[#This Row],[Actual Cost]]","v":{"v":0,"d":"$0.00"}},null,"Student",null,null,{"$f":"tblLoans[[#This Row],[Projected Cost]]-tblLoans[[#This Row],[Actual Cost]]","v":{"v":0,"d":"$0.00"}}]
[null,"Bus/taxi fare",null,null,{"$f":"tblTransportation[[#This Row],[Projected Cost]]-tblTransportation[[#This Row],[Actual Cost]]","v":{"v":0,"d":"$0.00"}},null,"Credit card",null,null,{"$f":"tblLoans[[#This Row],[Projected Cost]]-tblLoans[[#This Row],[Actual Cost]]","v":{"v":0,"d":"$0.00"}}]
[null,"Insurance",null,null,{"$f":"tblTransportation[[#This Row],[Projected Cost]]-tblTransportation[[#This Row],[Actual Cost]]","v":{"v":0,"d":"$0.00"}},null,"Credit card",null,null,{"$f":"tblLoans[[#This Row],[Projected Cost]]-tblLoans[[#This Row],[Actual Cost]]","v":{"v":0,"d":"$0.00"}}]
[null,"Licensing",null,null,{"$f":"tblTransportation[[#This Row],[Projected Cost]]-tblTransportation[[#This Row],[Actual Cost]]","v":{"v":0,"d":"$0.00"}},null,"Credit card",null,null,{"$f":"tblLoans[[#This Row],[Projected Cost]]-tblLoans[[#This Row],[Actual Cost]]","v":{"v":0,"d":"$0.00"}}]
[null,"Fuel",null,null,{"$f":"tblTransportation[[#This Row],[Projected Cost]]-tblTransportation[[#This Row],[Actual Cost]]","v":{"v":0,"d":"$0.00"}},null,"Other",null,null,{"$f":"tblLoans[[#This Row],[Projected Cost]]-tblLoans[[#This Row],[Actual Cost]]","v":{"v":0,"d":"$0.00"}}]
[null,"Maintenance",null,null,{"$f":"tblTransportation[[#This Row],[Projected Cost]]-tblTransportation[[#This Row],[Actual Cost]]","v":{"v":0,"d":"$0.00"}},null,"Subtotal",null,null,{"$f":"SUBTOTAL(109,tblLoans[Difference])","v":{"v":0,"d":"$0.00"}}]
[null,"Other",null,null,{"$f":"tblTransportation[[#This Row],[Projected Cost]]-tblTransportation[[#This Row],[Actual Cost]]","v":{"v":0,"d":"$0.00"}}]
[null,"Subtotal",null,null,{"$f":"SUBTOTAL(109,tblTransportation[Difference])","v":{"v":0,"d":"$0.00"}},null,"TAXES","Projected Cost","Actual Cost","Difference"]
[{"$nulls":6},"Federal",null,null,{"$f":"tblTaxes[[#This Row],[Projected Cost]]-tblTaxes[[#This Row],[Actual Cost]]","v":{"v":0,"d":"$0.00"}}]
[null,"INSURANCE","Projected Cost","Actual Cost","Difference",null,"State",null,null,{"$f":"tblTaxes[[#This Row],[Projected Cost]]-tblTaxes[[#This Row],[Actual Cost]]","v":{"v":0,"d":"$0.00"}}]
[null,"Home",null,null,{"$f":"tblInsurance[[#This Row],[Projected Cost]]-tblInsurance[[#This Row],[Actual Cost]]","v":{"v":0,"d":"$0.00"}},null,"Local",null,null,{"$f":"tblTaxes[[#This Row],[Projected Cost]]-tblTaxes[[#This Row],[Actual Cost]]","v":{"v":0,"d":"$0.00"}}]
[null,"Health",null,null,{"$f":"tblInsurance[[#This Row],[Projected Cost]]-tblInsurance[[#This Row],[Actual Cost]]","v":{"v":0,"d":"$0.00"}},null,"Other",null,null,{"$f":"tblTaxes[[#This Row],[Projected Cost]]-tblTaxes[[#This Row],[Actual Cost]]","v":{"v":0,"d":"$0.00"}}]
[null,"Life",null,null,{"$f":"tblInsurance[[#This Row],[Projected Cost]]-tblInsurance[[#This Row],[Actual Cost]]","v":{"v":0,"d":"$0.00"}},null,"Subtotal",null,null,{"$f":"SUBTOTAL(109,tblTaxes[Difference])","v":{"v":0,"d":"$0.00"}}]
[null,"Other",null,null,{"$f":"tblInsurance[[#This Row],[Projected Cost]]-tblInsurance[[#This Row],[Actual Cost]]","v":{"v":0,"d":"$0.00"}}]
[null,"Subtotal",null,null,{"$f":"SUBTOTAL(109,tblInsurance[Difference])","v":{"v":0,"d":"$0.00"}},null,"SAVINGS OR INVESTMENTS","Projected Cost","Actual Cost","Difference"]
[{"$nulls":6},"Retirement account",null,null,{"$f":"tblSavings[[#This Row],[Projected Cost]]-tblSavings[[#This Row],[Actual Cost]]","v":{"v":0,"d":"$0.00"}}]
[null,"FOOD","Projected Cost","Actual Cost","Difference",null,"Investment account",null,null,{"$f":"tblSavings[[#This Row],[Projected Cost]]-tblSavings[[#This Row],[Actual Cost]]","v":{"v":0,"d":"$0.00"}}]
[null,"Groceries",null,null,{"$f":"tblFood[[#This Row],[Projected Cost]]-tblFood[[#This Row],[Actual Cost]]","v":{"v":0,"d":"$0.00"}},null,"Other",null,null,{"$f":"tblSavings[[#This Row],[Projected Cost]]-tblSavings[[#This Row],[Actual Cost]]","v":{"v":0,"d":"$0.00"}}]
[null,"Dining out",null,null,{"$f":"tblFood[[#This Row],[Projected Cost]]-tblFood[[#This Row],[Actual Cost]]","v":{"v":0,"d":"$0.00"}},null,"Subtotal",null,null,{"$f":"SUBTOTAL(109,tblSavings[Difference])","v":{"v":0,"d":"$0.00"}}]
[null,"Other",null,null,{"$f":"tblFood[[#This Row],[Projected Cost]]-tblFood[[#This Row],[Actual Cost]]","v":{"v":0,"d":"$0.00"}}]
[null,"Subtotal",null,null,{"$f":"SUBTOTAL(109,tblFood[Difference])","v":{"v":0,"d":"$0.00"}},null,"GIFTS AND DONATIONS","Projected Cost","Actual Cost","Difference"]
[{"$nulls":6},"Charity 1",null,null,{"$f":"tblGifts[[#This Row],[Projected Cost]]-tblGifts[[#This Row],[Actual Cost]]","v":{"v":0,"d":"$0.00"}}]
[null,"PETS","Projected Cost","Actual Cost","Difference",null,"Charity 2",null,null,{"$f":"tblGifts[[#This Row],[Projected Cost]]-tblGifts[[#This Row],[Actual Cost]]","v":{"v":0,"d":"$0.00"}}]
[null,"Food",null,null,{"$f":"tblPets[[#This Row],[Projected Cost]]-tblPets[[#This Row],[Actual Cost]]","v":{"v":0,"d":"$0.00"}},null,"Charity 3",null,null,{"$f":"tblGifts[[#This Row],[Projected Cost]]-tblGifts[[#This Row],[Actual Cost]]","v":{"v":0,"d":"$0.00"}}]
[null,"Medical",null,null,{"$f":"tblPets[[#This Row],[Projected Cost]]-tblPets[[#This Row],[Actual Cost]]","v":{"v":0,"d":"$0.00"}},null,"Subtotal",null,null,{"$f":"SUBTOTAL(109,tblGifts[Difference])","v":{"v":0,"d":"$0.00"}}]
[null,"Grooming",null,null,{"$f":"tblPets[[#This Row],[Projected Cost]]-tblPets[[#This Row],[Actual Cost]]","v":{"v":0,"d":"$0.00"}}]
[null,"Toys",null,null,{"$f":"tblPets[[#This Row],[Projected Cost]]-tblPets[[#This Row],[Actual Cost]]","v":{"v":0,"d":"$0.00"}},null,"LEGAL","Projected Cost","Actual Cost","Difference"]
[null,"Other",null,null,{"$f":"tblPets[[#This Row],[Projected Cost]]-tblPets[[#This Row],[Actual Cost]]","v":{"v":0,"d":"$0.00"}},null,"Attorney",null,null,{"$f":"tblLegal[[#This Row],[Projected Cost]]-tblLegal[[#This Row],[Actual Cost]]","v":{"v":0,"d":"$0.00"}}]
[null,"Subtotal",null,null,{"$f":"SUBTOTAL(109,tblPets[Difference])","v":{"v":0,"d":"$0.00"}},null,"Alimony",null,null,{"$f":"tblLegal[[#This Row],[Projected Cost]]-tblLegal[[#This Row],[Actual Cost]]","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":6},"Payments on lien or judgment",null,null,{"$f":"tblLegal[[#This Row],[Projected Cost]]-tblLegal[[#This Row],[Actual Cost]]","v":{"v":0,"d":"$0.00"}}]
[null,"PERSONAL CARE","Projected Cost","Actual Cost","Difference",null,"Other",null,null,{"$f":"tblLegal[[#This Row],[Projected Cost]]-tblLegal[[#This Row],[Actual Cost]]","v":{"v":0,"d":"$0.00"}}]
[null,"Medical",null,null,{"$f":"tblPersonalCare[[#This Row],[Projected Cost]]-tblPersonalCare[[#This Row],[Actual Cost]]","v":{"v":0,"d":"$0.00"}},null,"Subtotal",null,null,{"$f":"SUBTOTAL(109,tblLegal[Difference])","v":{"v":0,"d":"$0.00"}}]
[null,"Hair/nails",null,null,{"$f":"tblPersonalCare[[#This Row],[Projected Cost]]-tblPersonalCare[[#This Row],[Actual Cost]]","v":{"v":0,"d":"$0.00"}}]
[null,"Clothing",null,null,{"$f":"tblPersonalCare[[#This Row],[Projected Cost]]-tblPersonalCare[[#This Row],[Actual Cost]]","v":{"v":0,"d":"$0.00"}},null,"TOTAL PROJECTED COST",null,null,{"$f":"SUBTOTAL(109,tblHousing[Projected Cost],tblTransportation[Projected Cost],tblInsurance[Projected Cost],tblFood[Projected Cost],tblPets[Projected Cost],tblPersonalCare[Projected Cost],tblEntertainment[Projected Cost],tblLoans[Projected Cost],tblTaxes[Projected Cost],tblSavings[Projected Cost],tblGifts[Projected Cost],tblLegal[Projected Cost])","v":{"v":1195,"d":"$1,195.00"}}]
[null,"Dry cleaning",null,null,{"$f":"tblPersonalCare[[#This Row],[Projected Cost]]-tblPersonalCare[[#This Row],[Actual Cost]]","v":{"v":0,"d":"$0.00"}}]
[null,"Health club",null,null,{"$f":"tblPersonalCare[[#This Row],[Projected Cost]]-tblPersonalCare[[#This Row],[Actual Cost]]","v":{"v":0,"d":"$0.00"}},null,"TOTAL ACTUAL COST",null,null,{"$f":"SUBTOTAL(109,tblHousing[Actual Cost],tblTransportation[Actual Cost],tblInsurance[Actual Cost],tblFood[Actual Cost],tblPets[Actual Cost],tblPersonalCare[Actual Cost],tblEntertainment[Actual Cost],tblLoans[Actual Cost],tblTaxes[Actual Cost],tblSavings[Actual Cost],tblGifts[Actual Cost],tblLegal[Actual Cost])","v":{"v":1236,"d":"$1,236.00"}}]
[null,"Organization dues or fees",null,null,{"$f":"tblPersonalCare[[#This Row],[Projected Cost]]-tblPersonalCare[[#This Row],[Actual Cost]]","v":{"v":0,"d":"$0.00"}}]
[null,"Other",null,null,{"$f":"tblPersonalCare[[#This Row],[Projected Cost]]-tblPersonalCare[[#This Row],[Actual Cost]]","v":{"v":0,"d":"$0.00"}},null,"TOTAL DIFFERENCE",null,null,{"$f":"J59-J61","v":{"v":-41,"d":"($41.00)"}}]
[null,"Subtotal",null,null,{"$f":"SUBTOTAL(109,tblPersonalCare[Difference])","v":{"v":0,"d":"$0.00"}}]