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

{"sheet":"Family Monthly Budget","index":0,"n_rows":73,"n_cols":9,"rows_kept":73,"merged":[[0,0,0,8],[2,5,2,6],[5,1,6,1],[5,2,6,2],[5,3,6,3],[7,5,8,6],[27,6,28,6],[27,7,28,7],[27,8,28,8]]}
["Family Monthly Budget"]
[]
[null,"Total Projected Cost","Total Actual Cost","Total Difference",null,"Projected Monthly Income"]
[null,{"$f":"SUM(B19,B30,B37,B43,B55,B63,B73,G37,G46,G53,G60,G66,G73)","v":{"v":1195,"d":"$1,195"}},{"$f":"SUM(C19,C30,C37,C43,C55,C63,C73,H37,H46,H53,H60,H66,H73)","v":{"v":1236,"d":"$1,236"}},{"$f":"SUM(D19,D30,D37,D43,D55,D63,D73,I37,I46,I53,I60,I66,I73)","v":{"v":-41,"d":"($41)"}},null,"Income 1",{"v":4000,"d":"$4,000"}]
[{"$nulls":5},"Income 2",{"v":1300,"d":"$1,300"}]
[null,"Projected Cost","Actual Cost","Difference",null,"Extra income",{"v":300,"d":"$300"}]
["Housing",{"$nulls":4},"Total monthly income",{"$f":"SUM(G4:G6)","v":{"v":5600,"d":"$5,600"}}]
["Mortgage or rent",{"v":1000,"d":"$1,000"},{"v":1000,"d":"$1,000"},{"$f":"B8-C8","v":{"v":0,"d":"$0"}},null,"Actual Monthly Income"]
["Second mortgage or rent",{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"$f":"B9-C9","v":{"v":0,"d":"$0"}}]
["Phone",{"v":54,"d":"$54"},{"v":100,"d":"$100"},{"v":-46,"d":"($46)"},null,"Income 1",{"v":4000,"d":"$4,000"}]
["Electricity",{"v":44,"d":"$44"},{"v":56,"d":"$56"},{"v":-12,"d":"($12)"},null,"Income 2",{"v":1300,"d":"$1,300"}]
["Gas",{"v":22,"d":"$22"},{"v":28,"d":"$28"},{"v":-6,"d":"($6)"},null,"Extra income",{"v":300,"d":"$300"}]
["Water and sewer",{"v":8,"d":"$8"},{"v":8,"d":"$8"},{"v":0,"d":"$0"},null,"Total monthly income",{"$f":"SUM(G10:G12)","v":{"v":5600,"d":"$5,600"}}]
["Cable",{"v":34,"d":"$34"},{"v":34,"d":"$34"},{"v":0,"d":"$0"}]
["Waste removal",{"v":10,"d":"$10"},{"v":10,"d":"$10"},{"v":0,"d":"$0"},null,"Projected balance\n(Projected income minus expenses)",{"$f":"G7-B4","v":{"v":4405,"d":"$4,405"}}]
["Maintenance or repairs",{"v":23,"d":"$23"},{"v":0,"d":"$0"},{"v":23,"d":"$23"}]
["Supplies",{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},null,"Actual balance\n(Actual income minus expenses)",{"$f":"G13-C4","v":{"v":4364,"d":"$4,364"}}]
["Other",{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"}]
["Subtotals",{"$f":"SUM(B8:B18)","v":{"v":1195,"d":"$1,195"}},{"$f":"SUM(C8:C18)","v":{"v":1236,"d":"$1,236"}},{"$f":"SUM(D8:D18)","v":{"v":-41,"d":"($41)"}},null,"Difference (Actual minus projected)",{"$f":"G17-G15","v":{"v":-41,"d":"($41)"}}]
[]
["Transportation"]
["Vehicle 1 payment",null,null,{"v":0,"d":"$0"}]
["Vehicle 2 payment",null,null,{"v":0,"d":"$0"}]
["Bus/taxi fare",null,null,{"v":0,"d":"$0"}]
["Insurance",null,null,{"v":0,"d":"$0"}]
["Licensing",null,null,{"v":0,"d":"$0"}]
["Fuel",null,null,{"v":0,"d":"$0"}]
["Maintenance",null,null,{"v":0,"d":"$0"},null,null,"Projected Cost","Actual Cost","Difference"]
["Other",null,null,{"v":0,"d":"$0"},null,"Entertainment"]
["Subtotals",{"$f":"SUM(B22:B29)","v":{"v":0,"d":"$0"}},{"$f":"SUM(C22:C29)","v":{"v":0,"d":"$0"}},{"$f":"SUM(D22:D29)","v":{"v":0,"d":"$0"}},null,"Video/DVD",null,null,{"$f":"G30-H30","v":{"v":0,"d":"$0"}}]
[{"$nulls":5},"CDs",null,null,{"$f":"G31-H31","v":{"v":0,"d":"$0"}}]
["Insurance",{"$nulls":4},"Movies",null,null,{"$f":"G32-H32","v":{"v":0,"d":"$0"}}]
["Home",null,null,{"v":0,"d":"$0"},null,"Concerts",null,null,{"$f":"G33-H33","v":{"v":0,"d":"$0"}}]
["Health",null,null,{"v":0,"d":"$0"},null,"Sporting events",null,null,{"$f":"G34-H34","v":{"v":0,"d":"$0"}}]
["Life",null,null,{"v":0,"d":"$0"},null,"Live theater",null,null,{"$f":"G35-H35","v":{"v":0,"d":"$0"}}]
["Other",null,null,{"v":0,"d":"$0"},null,"Other",null,null,{"v":0,"d":"$0"}]
["Subtotals",{"$f":"SUM(B33:B36)","v":{"v":0,"d":"$0"}},{"$f":"SUM(C33:C36)","v":{"v":0,"d":"$0"}},{"$f":"SUM(D33:D36)","v":{"v":0,"d":"$0"}},null,"Subtotals",{"$f":"SUM(G30:G36)","v":{"v":0,"d":"$0"}},{"$f":"SUM(H30:H36)","v":{"v":0,"d":"$0"}},{"$f":"SUM(I30:I36)","v":{"v":0,"d":"$0"}}]
[]
["Food",{"$nulls":4},"Loans"]
["Groceries",null,null,{"v":0,"d":"$0"},null,"Personal",null,null,{"v":0,"d":"$0"}]
["Dining out",null,null,{"v":0,"d":"$0"},null,"Student",null,null,{"v":0,"d":"$0"}]
["Other",null,null,{"v":0,"d":"$0"},null,"Credit card",null,null,{"v":0,"d":"$0"}]
["Subtotals",{"$f":"SUM(B40:B42)","v":{"v":0,"d":"$0"}},{"$f":"SUM(C40:C42)","v":{"v":0,"d":"$0"}},{"$f":"SUM(D40:D42)","v":{"v":0,"d":"$0"}},null,"Credit card",null,null,{"v":0,"d":"$0"}]
[{"$nulls":5},"Credit card",null,null,{"v":0,"d":"$0"}]
["Children",{"$nulls":4},"Other",null,null,{"v":0,"d":"$0"}]
["Medical",null,null,{"v":0,"d":"$0"},null,"Subtotals",{"$f":"SUM(G40:G45)","v":{"v":0,"d":"$0"}},{"$f":"SUM(H40:H45)","v":{"v":0,"d":"$0"}},{"$f":"SUM(I40:I45)","v":{"v":0,"d":"$0"}}]
["Clothing",null,null,{"v":0,"d":"$0"}]
["School tuition",null,null,{"v":0,"d":"$0"},null,"Taxes"]
["School supplies",null,null,{"v":0,"d":"$0"},null,"Federal",null,null,{"v":0,"d":"$0"}]
["Organization dues or fees",null,null,{"v":0,"d":"$0"},null,"State",null,null,{"v":0,"d":"$0"}]
["Lunch money",null,null,{"v":0,"d":"$0"},null,"Local",null,null,{"v":0,"d":"$0"}]
["Child care",null,null,{"v":0,"d":"$0"},null,"Other",null,null,{"v":0,"d":"$0"}]
["Toys/games",null,null,{"v":0,"d":"$0"},null,"Subtotals",{"$f":"SUM(G49:G52)","v":{"v":0,"d":"$0"}},{"$f":"SUM(H49:H52)","v":{"v":0,"d":"$0"}},{"$f":"SUM(I49:I52)","v":{"v":0,"d":"$0"}}]
["Other",null,null,{"v":0,"d":"$0"}]
["Subtotals",{"$f":"SUM(B46:B54)","v":{"v":0,"d":"$0"}},{"$f":"SUM(C46:C54)","v":{"v":0,"d":"$0"}},{"$f":"SUM(D46:D54)","v":{"v":0,"d":"$0"}},null,"Savings or Investments"]
[{"$nulls":5},"Retirement account",null,null,{"v":0,"d":"$0"}]
["Pets",{"$nulls":4},"Investment account",null,null,{"v":0,"d":"$0"}]
["Food",null,null,{"v":0,"d":"$0"},null,"College",null,null,{"v":0,"d":"$0"}]
["Medical",null,null,{"v":0,"d":"$0"},null,"Other",null,null,{"v":0,"d":"$0"}]
["Grooming",null,null,{"v":0,"d":"$0"},null,"Subtotals",{"$f":"SUM(G56:G59)","v":{"v":0,"d":"$0"}},{"$f":"SUM(H56:H59)","v":{"v":0,"d":"$0"}},{"$f":"SUM(I56:I59)","v":{"v":0,"d":"$0"}}]
["Toys",null,null,{"v":0,"d":"$0"}]
["Other",null,null,{"v":0,"d":"$0"},null,"Gifts and Donations"]
["Subtotals",{"$f":"SUM(B58:B62)","v":{"v":0,"d":"$0"}},{"$f":"SUM(C58:C62)","v":{"v":0,"d":"$0"}},{"$f":"SUM(D58:D62)","v":{"v":0,"d":"$0"}},null,"Charity 1",null,null,{"$f":"G63-H63","v":{"v":0,"d":"$0"}}]
[{"$nulls":5},"Charity 2",null,null,{"$f":"G64-H64","v":{"v":0,"d":"$0"}}]
["Personal Care",{"$nulls":4},"Charity 3",null,null,{"$f":"G65-H65","v":{"v":0,"d":"$0"}}]
["Medical",null,null,{"v":0,"d":"$0"},null,"Subtotals",{"$f":"SUM(G63:G65)","v":{"v":0,"d":"$0"}},{"$f":"SUM(H63:H65)","v":{"v":0,"d":"$0"}},{"$f":"SUM(I63:I65)","v":{"v":0,"d":"$0"}}]
["Hair/nails",null,null,{"v":0,"d":"$0"}]
["Clothing",null,null,{"v":0,"d":"$0"},null,"Legal"]
["Dry cleaning",null,null,{"v":0,"d":"$0"},null,"Attorney",null,null,{"$f":"G69-H69","v":{"v":0,"d":"$0"}}]
["Health club",null,null,{"v":0,"d":"$0"},null,"Alimony",null,null,{"$f":"G70-H70","v":{"v":0,"d":"$0"}}]
["Organization dues or fees",null,null,{"v":0,"d":"$0"},null,"Payments on lien or judgment",null,null,{"$f":"G71-H71","v":{"v":0,"d":"$0"}}]
["Other",null,null,{"v":0,"d":"$0"},null,"Other",null,null,{"$f":"G72-H72","v":{"v":0,"d":"$0"}}]
["Subtotals",{"$f":"SUM(B66:B72)","v":{"v":0,"d":"$0"}},{"$f":"SUM(C66:C72)","v":{"v":0,"d":"$0"}},{"$f":"SUM(D66:D72)","v":{"v":0,"d":"$0"}},null,"Subtotals",{"$f":"SUM(G69:G72)","v":{"v":0,"d":"$0"}},{"$f":"SUM(H69:H72)","v":{"v":0,"d":"$0"}},{"$f":"SUM(I69:I72)","v":{"v":0,"d":"$0"}}]