{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["Budget Overview","Budget Summary","Monthly Expenses","Additional Data"],"not_rendered":{"charts":1,"images":4,"defined_names":7,"pivot_tables":2},"read":"whole","date_system":"1900"}

{"sheet":"Budget Overview","index":0,"n_rows":12,"n_cols":8,"rows_kept":12,"merged":[[1,1,1,2],[2,1,2,2],[3,1,3,2],[4,1,4,2]]}
[{"$nulls":7}," "]
[null,"Balance"]
[null,"Projected Balance",null,{"$f":"Projected_Income-Projected_Expenses","v":{"v":1585,"d":"£1,585"}},null,"Projected minus expenses"]
[null,"Actual Balance ",null,{"$f":"Actual_Income-Actual_Expenses","v":{"v":1740,"d":"£1,740"}},null,"Actual minus expenses"]
[null,"Difference",null,{"$f":"D4-D3","v":{"v":155,"d":"£155"}},null,"Actual minus projected"]
[null,"Income",{"$nulls":3},"Expenses"]
[null,null,"Projected","Actual",null,"Projected","Actual"]
[null,"Income 1",{"v":6000,"d":"£6,000"},{"v":5800,"d":"£5,800"},null,{"$f":"SUM(Monthly_Expenses_Table[Projected Cost])","v":{"v":7915,"d":"£7,915"}},{"$f":"SUM(Monthly_Expenses_Table[Actual Cost])","v":{"v":7860,"d":"£7,860"}}]
[null,"Income 2",{"v":1000,"d":"£1,000"},{"v":2300,"d":"£2,300"}]
[null,"Extra income",{"v":2500,"d":"£2,500"},{"v":1500,"d":"£1,500"}]
[null,"Total Income",{"$f":"SUM(C8:C10)","v":{"v":9500,"d":"£9,500"}},{"$f":"SUM(D8:D10)","v":{"v":9600,"d":"£9,600"}}]
[null,"Actual Expenses Breakdown"]

{"sheet":"Budget Summary","index":1,"n_rows":41,"n_cols":7,"rows_kept":41}
[null,"Budget Summary",{"$nulls":4}," "]
[]
[null,"Categories","Projected Cost ","Actual Cost ","Difference "]
[null,"Children",{"v":140,"d":"£140"},{"v":140,"d":"£140"},{"v":0,"d":"£0"}]
[null,"Extracurricular Activities",{"v":40,"d":"£40"},{"v":40,"d":"£40"},{"v":0,"d":"£0"}]
[null,"Medical",null,null,{"v":0,"d":"£0"}]
[null,"School Supplies",null,null,{"v":0,"d":"£0"}]
[null,"School Tuition",{"v":100,"d":"£100"},{"v":100,"d":"£100"},{"v":0,"d":"£0"}]
[]
[null,"Entertainment",{"v":400,"d":"£400"},{"v":358,"d":"£358"},{"v":42,"d":"£42"}]
[null,"Concerts",{"v":50,"d":"£50"},{"v":40,"d":"£40"},{"v":10,"d":"£10"}]
[null,"Live Theater",{"v":200,"d":"£200"},{"v":150,"d":"£150"},{"v":50,"d":"£50"}]
[null,"Movies",{"v":50,"d":"£50"},{"v":28,"d":"£28"},{"v":22,"d":"£22"}]
[null,"Music (CDs, Downloads, etc.)",{"v":50,"d":"£50"},{"v":30,"d":"£30"},{"v":20,"d":"£20"}]
[null,"Sporting Events",{"v":0,"d":"£0"},{"v":40,"d":"£40"},{"v":-40,"d":"-£40"}]
[null,"Video/Dvd (Purchase)",{"v":20,"d":"£20"},{"v":50,"d":"£50"},{"v":-30,"d":"-£30"}]
[null,"Video/Dvd (Rental)",{"v":30,"d":"£30"},{"v":20,"d":"£20"},{"v":10,"d":"£10"}]
[]
[null,"Food",{"v":1100,"d":"£1,100"},{"v":1320,"d":"£1,320"},{"v":-220,"d":"-£220"}]
[]
[null,"Gifts and Charity",{"v":100,"d":"£100"},{"v":125,"d":"£125"},{"v":-25,"d":"-£25"}]
[]
[null,"Housing",{"v":2830,"d":"£2,830"},{"v":2702,"d":"£2,702"},{"v":-72,"d":"-£72"}]
[]
[null,"Insurance",{"v":900,"d":"£900"},{"v":900,"d":"£900"},{"v":0,"d":"£0"}]
[]
[null,"Loans",{"v":200,"d":"£200"},{"v":200,"d":"£200"},{"v":0,"d":"£0"}]
[]
[null,"Personal Care",{"v":150,"d":"£150"},{"v":140,"d":"£140"},{"v":10,"d":"£10"}]
[]
[null,"Pets",{"v":170,"d":"£170"},{"v":100,"d":"£100"},{"v":70,"d":"£70"}]
[]
[null,"Taxes",{"v":300,"d":"£300"},{"v":300,"d":"£300"},{"v":0,"d":"£0"}]
[]
[null,"Transportation",{"v":1425,"d":"£1,425"},{"v":1375,"d":"£1,375"},{"v":50,"d":"£50"}]
[]
[null,"Savings",{"v":200,"d":"£200"},{"v":200,"d":"£200"},{"v":0,"d":"£0"}]
[null,"Investment Account",{"v":200,"d":"£200"},{"v":200,"d":"£200"},{"v":0,"d":"£0"}]
[null,"Retirement Account",null,null,{"v":0,"d":"£0"}]
[]
[null,"Grand Total",{"v":7915,"d":"£7,915"},{"v":7860,"d":"£7,860"},{"v":-145,"d":"-£145"}]

{"sheet":"Monthly Expenses","index":2,"n_rows":61,"n_cols":8,"rows_kept":61}
[{"$nulls":7}," "]
[null,"Description","Category","Projected Cost","Actual Cost","Difference","Actual Cost Overview"]
[null,"Extracurricular Activities","Children",{"v":40,"d":"£40"},{"v":40,"d":"£40"},{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[Projected Cost]]=\"\",Monthly_Expenses_Table[[#This Row],[Actual Cost]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[Projected Cost]]-Monthly_Expenses_Table[[#This Row],[Actual Cost]])","v":{"v":0,"d":"£0"}},{"$f":"Monthly_Expenses_Table[[#This Row],[Actual Cost]]","v":40}]
[null,"Medical","Children",null,null,{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[Projected Cost]]=\"\",Monthly_Expenses_Table[[#This Row],[Actual Cost]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[Projected Cost]]-Monthly_Expenses_Table[[#This Row],[Actual Cost]])","v":""},{"$f":"Monthly_Expenses_Table[[#This Row],[Actual Cost]]","v":0}]
[null,"School Supplies","Children",null,null,{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[Projected Cost]]=\"\",Monthly_Expenses_Table[[#This Row],[Actual Cost]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[Projected Cost]]-Monthly_Expenses_Table[[#This Row],[Actual Cost]])","v":""},{"$f":"Monthly_Expenses_Table[[#This Row],[Actual Cost]]","v":0}]
[null,"School Tuition","Children",{"v":100,"d":"£100"},{"v":100,"d":"£100"},{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[Projected Cost]]=\"\",Monthly_Expenses_Table[[#This Row],[Actual Cost]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[Projected Cost]]-Monthly_Expenses_Table[[#This Row],[Actual Cost]])","v":{"v":0,"d":"£0"}},{"$f":"Monthly_Expenses_Table[[#This Row],[Actual Cost]]","v":100}]
[null,"Concerts","Entertainment",{"v":50,"d":"£50"},{"v":40,"d":"£40"},{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[Projected Cost]]=\"\",Monthly_Expenses_Table[[#This Row],[Actual Cost]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[Projected Cost]]-Monthly_Expenses_Table[[#This Row],[Actual Cost]])","v":{"v":10,"d":"£10"}},{"$f":"Monthly_Expenses_Table[[#This Row],[Actual Cost]]","v":40}]
[null,"Live Theater","Entertainment",{"v":200,"d":"£200"},{"v":150,"d":"£150"},{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[Projected Cost]]=\"\",Monthly_Expenses_Table[[#This Row],[Actual Cost]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[Projected Cost]]-Monthly_Expenses_Table[[#This Row],[Actual Cost]])","v":{"v":50,"d":"£50"}},{"$f":"Monthly_Expenses_Table[[#This Row],[Actual Cost]]","v":150}]
[null,"Movies","Entertainment",{"v":50,"d":"£50"},{"v":28,"d":"£28"},{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[Projected Cost]]=\"\",Monthly_Expenses_Table[[#This Row],[Actual Cost]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[Projected Cost]]-Monthly_Expenses_Table[[#This Row],[Actual Cost]])","v":{"v":22,"d":"£22"}},{"$f":"Monthly_Expenses_Table[[#This Row],[Actual Cost]]","v":28}]
[null,"Music (CDs, Downloads, etc.)","Entertainment",{"v":50,"d":"£50"},{"v":30,"d":"£30"},{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[Projected Cost]]=\"\",Monthly_Expenses_Table[[#This Row],[Actual Cost]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[Projected Cost]]-Monthly_Expenses_Table[[#This Row],[Actual Cost]])","v":{"v":20,"d":"£20"}},{"$f":"Monthly_Expenses_Table[[#This Row],[Actual Cost]]","v":30}]
[null,"Sporting Events","Entertainment",{"v":0,"d":"£0"},{"v":40,"d":"£40"},{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[Projected Cost]]=\"\",Monthly_Expenses_Table[[#This Row],[Actual Cost]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[Projected Cost]]-Monthly_Expenses_Table[[#This Row],[Actual Cost]])","v":{"v":-40,"d":"-£40"}},{"$f":"Monthly_Expenses_Table[[#This Row],[Actual Cost]]","v":40}]
[null,"Video/Dvd (Purchase)","Entertainment",{"v":20,"d":"£20"},{"v":50,"d":"£50"},{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[Projected Cost]]=\"\",Monthly_Expenses_Table[[#This Row],[Actual Cost]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[Projected Cost]]-Monthly_Expenses_Table[[#This Row],[Actual Cost]])","v":{"v":-30,"d":"-£30"}},{"$f":"Monthly_Expenses_Table[[#This Row],[Actual Cost]]","v":50}]
[null,"Video/Dvd (Rental)","Entertainment",{"v":30,"d":"£30"},{"v":20,"d":"£20"},{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[Projected Cost]]=\"\",Monthly_Expenses_Table[[#This Row],[Actual Cost]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[Projected Cost]]-Monthly_Expenses_Table[[#This Row],[Actual Cost]])","v":{"v":10,"d":"£10"}},{"$f":"Monthly_Expenses_Table[[#This Row],[Actual Cost]]","v":20}]
[null,"Dining Out","Food",{"v":1000,"d":"£1,000"},{"v":1200,"d":"£1,200"},{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[Projected Cost]]=\"\",Monthly_Expenses_Table[[#This Row],[Actual Cost]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[Projected Cost]]-Monthly_Expenses_Table[[#This Row],[Actual Cost]])","v":{"v":-200,"d":"-£200"}},{"$f":"Monthly_Expenses_Table[[#This Row],[Actual Cost]]","v":1200}]
[null,"Groceries","Food",{"v":100,"d":"£100"},{"v":120,"d":"£120"},{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[Projected Cost]]=\"\",Monthly_Expenses_Table[[#This Row],[Actual Cost]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[Projected Cost]]-Monthly_Expenses_Table[[#This Row],[Actual Cost]])","v":{"v":-20,"d":"-£20"}},{"$f":"Monthly_Expenses_Table[[#This Row],[Actual Cost]]","v":120}]
[null,"Charity 1","Gifts and Charity",{"v":75,"d":"£75"},{"v":100,"d":"£100"},{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[Projected Cost]]=\"\",Monthly_Expenses_Table[[#This Row],[Actual Cost]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[Projected Cost]]-Monthly_Expenses_Table[[#This Row],[Actual Cost]])","v":{"v":-25,"d":"-£25"}},{"$f":"Monthly_Expenses_Table[[#This Row],[Actual Cost]]","v":100}]
[null,"Charity 2","Gifts and Charity",{"v":25,"d":"£25"},{"v":25,"d":"£25"},{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[Projected Cost]]=\"\",Monthly_Expenses_Table[[#This Row],[Actual Cost]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[Projected Cost]]-Monthly_Expenses_Table[[#This Row],[Actual Cost]])","v":{"v":0,"d":"£0"}},{"$f":"Monthly_Expenses_Table[[#This Row],[Actual Cost]]","v":25}]
[null,"Gift 1","Gifts and Charity",null,null,{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[Projected Cost]]=\"\",Monthly_Expenses_Table[[#This Row],[Actual Cost]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[Projected Cost]]-Monthly_Expenses_Table[[#This Row],[Actual Cost]])","v":""},{"$f":"Monthly_Expenses_Table[[#This Row],[Actual Cost]]","v":0}]
[null,"Gift 2","Gifts and Charity",null,null,{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[Projected Cost]]=\"\",Monthly_Expenses_Table[[#This Row],[Actual Cost]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[Projected Cost]]-Monthly_Expenses_Table[[#This Row],[Actual Cost]])","v":""},{"$f":"Monthly_Expenses_Table[[#This Row],[Actual Cost]]","v":0}]
[null,"Cable/Satellite","Housing",{"v":100,"d":"£100"},{"v":100,"d":"£100"},{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[Projected Cost]]=\"\",Monthly_Expenses_Table[[#This Row],[Actual Cost]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[Projected Cost]]-Monthly_Expenses_Table[[#This Row],[Actual Cost]])","v":{"v":0,"d":"£0"}},{"$f":"Monthly_Expenses_Table[[#This Row],[Actual Cost]]","v":100}]
[null,"Electric","Housing",{"v":45,"d":"£45"},{"v":50,"d":"£50"},{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[Projected Cost]]=\"\",Monthly_Expenses_Table[[#This Row],[Actual Cost]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[Projected Cost]]-Monthly_Expenses_Table[[#This Row],[Actual Cost]])","v":{"v":-5,"d":"-£5"}},{"$f":"Monthly_Expenses_Table[[#This Row],[Actual Cost]]","v":50}]
[null,"Petrol","Housing",{"v":300,"d":"£300"},{"v":400,"d":"£400"},{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[Projected Cost]]=\"\",Monthly_Expenses_Table[[#This Row],[Actual Cost]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[Projected Cost]]-Monthly_Expenses_Table[[#This Row],[Actual Cost]])","v":{"v":-100,"d":"-£100"}},{"$f":"Monthly_Expenses_Table[[#This Row],[Actual Cost]]","v":400}]
[null,"House Cleaning Service","Housing",{"v":200,"d":"£200"},null,{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[Projected Cost]]=\"\",Monthly_Expenses_Table[[#This Row],[Actual Cost]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[Projected Cost]]-Monthly_Expenses_Table[[#This Row],[Actual Cost]])","v":""},{"$f":"Monthly_Expenses_Table[[#This Row],[Actual Cost]]","v":0}]
[null,"Maintenance","Housing",{"v":200,"d":"£200"},{"v":150,"d":"£150"},{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[Projected Cost]]=\"\",Monthly_Expenses_Table[[#This Row],[Actual Cost]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[Projected Cost]]-Monthly_Expenses_Table[[#This Row],[Actual Cost]])","v":{"v":50,"d":"£50"}},{"$f":"Monthly_Expenses_Table[[#This Row],[Actual Cost]]","v":150}]
[null,"Mortgage Or Rent","Housing",{"v":1700,"d":"£1,700"},{"v":1700,"d":"£1,700"},{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[Projected Cost]]=\"\",Monthly_Expenses_Table[[#This Row],[Actual Cost]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[Projected Cost]]-Monthly_Expenses_Table[[#This Row],[Actual Cost]])","v":{"v":0,"d":"£0"}},{"$f":"Monthly_Expenses_Table[[#This Row],[Actual Cost]]","v":1700}]
[null,"Natural Gas/Oil","Housing",null,null,{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[Projected Cost]]=\"\",Monthly_Expenses_Table[[#This Row],[Actual Cost]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[Projected Cost]]-Monthly_Expenses_Table[[#This Row],[Actual Cost]])","v":""},{"$f":"Monthly_Expenses_Table[[#This Row],[Actual Cost]]","v":0}]
[null,"Online/Internet Service","Housing",{"v":100,"d":"£100"},{"v":100,"d":"£100"},{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[Projected Cost]]=\"\",Monthly_Expenses_Table[[#This Row],[Actual Cost]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[Projected Cost]]-Monthly_Expenses_Table[[#This Row],[Actual Cost]])","v":{"v":0,"d":"£0"}},{"$f":"Monthly_Expenses_Table[[#This Row],[Actual Cost]]","v":100}]
[null,"Phone (Mobile)","Housing",{"v":60,"d":"£60"},{"v":60,"d":"£60"},{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[Projected Cost]]=\"\",Monthly_Expenses_Table[[#This Row],[Actual Cost]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[Projected Cost]]-Monthly_Expenses_Table[[#This Row],[Actual Cost]])","v":{"v":0,"d":"£0"}},{"$f":"Monthly_Expenses_Table[[#This Row],[Actual Cost]]","v":60}]
[null,"Phone (Home)","Housing",{"v":35,"d":"£35"},{"v":39,"d":"£39"},{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[Projected Cost]]=\"\",Monthly_Expenses_Table[[#This Row],[Actual Cost]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[Projected Cost]]-Monthly_Expenses_Table[[#This Row],[Actual Cost]])","v":{"v":-4,"d":"-£4"}},{"$f":"Monthly_Expenses_Table[[#This Row],[Actual Cost]]","v":39}]
[null,"Supplies","Housing",{"v":40,"d":"£40"},{"v":55,"d":"£55"},{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[Projected Cost]]=\"\",Monthly_Expenses_Table[[#This Row],[Actual Cost]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[Projected Cost]]-Monthly_Expenses_Table[[#This Row],[Actual Cost]])","v":{"v":-15,"d":"-£15"}},{"$f":"Monthly_Expenses_Table[[#This Row],[Actual Cost]]","v":55}]
[null,"Waste Removal and Recycle","Housing",{"v":25,"d":"£25"},{"v":22,"d":"£22"},{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[Projected Cost]]=\"\",Monthly_Expenses_Table[[#This Row],[Actual Cost]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[Projected Cost]]-Monthly_Expenses_Table[[#This Row],[Actual Cost]])","v":{"v":3,"d":"£3"}},{"$f":"Monthly_Expenses_Table[[#This Row],[Actual Cost]]","v":22}]
[null,"Water and Sewer","Housing",{"v":25,"d":"£25"},{"v":26,"d":"£26"},{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[Projected Cost]]=\"\",Monthly_Expenses_Table[[#This Row],[Actual Cost]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[Projected Cost]]-Monthly_Expenses_Table[[#This Row],[Actual Cost]])","v":{"v":-1,"d":"-£1"}},{"$f":"Monthly_Expenses_Table[[#This Row],[Actual Cost]]","v":26}]
[null,"Health","Insurance",{"v":400,"d":"£400"},{"v":400,"d":"£400"},{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[Projected Cost]]=\"\",Monthly_Expenses_Table[[#This Row],[Actual Cost]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[Projected Cost]]-Monthly_Expenses_Table[[#This Row],[Actual Cost]])","v":{"v":0,"d":"£0"}},{"$f":"Monthly_Expenses_Table[[#This Row],[Actual Cost]]","v":400}]
[null,"Home","Insurance",{"v":400,"d":"£400"},{"v":400,"d":"£400"},{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[Projected Cost]]=\"\",Monthly_Expenses_Table[[#This Row],[Actual Cost]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[Projected Cost]]-Monthly_Expenses_Table[[#This Row],[Actual Cost]])","v":{"v":0,"d":"£0"}},{"$f":"Monthly_Expenses_Table[[#This Row],[Actual Cost]]","v":400}]
[null,"Life","Insurance",{"v":100,"d":"£100"},{"v":100,"d":"£100"},{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[Projected Cost]]=\"\",Monthly_Expenses_Table[[#This Row],[Actual Cost]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[Projected Cost]]-Monthly_Expenses_Table[[#This Row],[Actual Cost]])","v":{"v":0,"d":"£0"}},{"$f":"Monthly_Expenses_Table[[#This Row],[Actual Cost]]","v":100}]
[null,"Credit Card 1","Loans",{"v":200,"d":"£200"},{"v":200,"d":"£200"},{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[Projected Cost]]=\"\",Monthly_Expenses_Table[[#This Row],[Actual Cost]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[Projected Cost]]-Monthly_Expenses_Table[[#This Row],[Actual Cost]])","v":{"v":0,"d":"£0"}},{"$f":"Monthly_Expenses_Table[[#This Row],[Actual Cost]]","v":200}]
[null,"Credit Card 2","Loans",null,null,{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[Projected Cost]]=\"\",Monthly_Expenses_Table[[#This Row],[Actual Cost]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[Projected Cost]]-Monthly_Expenses_Table[[#This Row],[Actual Cost]])","v":""},{"$f":"Monthly_Expenses_Table[[#This Row],[Actual Cost]]","v":0}]
[null,"Credit Card 3","Loans",null,null,{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[Projected Cost]]=\"\",Monthly_Expenses_Table[[#This Row],[Actual Cost]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[Projected Cost]]-Monthly_Expenses_Table[[#This Row],[Actual Cost]])","v":""},{"$f":"Monthly_Expenses_Table[[#This Row],[Actual Cost]]","v":0}]
[null,"Personal","Loans",null,null,{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[Projected Cost]]=\"\",Monthly_Expenses_Table[[#This Row],[Actual Cost]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[Projected Cost]]-Monthly_Expenses_Table[[#This Row],[Actual Cost]])","v":""},{"$f":"Monthly_Expenses_Table[[#This Row],[Actual Cost]]","v":0}]
[null,"Student","Loans",null,null,{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[Projected Cost]]=\"\",Monthly_Expenses_Table[[#This Row],[Actual Cost]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[Projected Cost]]-Monthly_Expenses_Table[[#This Row],[Actual Cost]])","v":""},{"$f":"Monthly_Expenses_Table[[#This Row],[Actual Cost]]","v":0}]
[null,"Clothing","Personal Care",{"v":150,"d":"£150"},{"v":140,"d":"£140"},{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[Projected Cost]]=\"\",Monthly_Expenses_Table[[#This Row],[Actual Cost]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[Projected Cost]]-Monthly_Expenses_Table[[#This Row],[Actual Cost]])","v":{"v":10,"d":"£10"}},{"$f":"Monthly_Expenses_Table[[#This Row],[Actual Cost]]","v":140}]
[null,"Dry Cleaning","Personal Care",null,null,{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[Projected Cost]]=\"\",Monthly_Expenses_Table[[#This Row],[Actual Cost]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[Projected Cost]]-Monthly_Expenses_Table[[#This Row],[Actual Cost]])","v":""},{"$f":"Monthly_Expenses_Table[[#This Row],[Actual Cost]]","v":0}]
[null,"Hair/Nails","Personal Care",null,null,{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[Projected Cost]]=\"\",Monthly_Expenses_Table[[#This Row],[Actual Cost]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[Projected Cost]]-Monthly_Expenses_Table[[#This Row],[Actual Cost]])","v":""},{"$f":"Monthly_Expenses_Table[[#This Row],[Actual Cost]]","v":0}]
[null,"Health Club","Personal Care",null,null,{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[Projected Cost]]=\"\",Monthly_Expenses_Table[[#This Row],[Actual Cost]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[Projected Cost]]-Monthly_Expenses_Table[[#This Row],[Actual Cost]])","v":""},{"$f":"Monthly_Expenses_Table[[#This Row],[Actual Cost]]","v":0}]
[null,"Medical","Personal Care",null,null,{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[Projected Cost]]=\"\",Monthly_Expenses_Table[[#This Row],[Actual Cost]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[Projected Cost]]-Monthly_Expenses_Table[[#This Row],[Actual Cost]])","v":""},{"$f":"Monthly_Expenses_Table[[#This Row],[Actual Cost]]","v":0}]
[null,"Food","Pets",{"v":150,"d":"£150"},{"v":75,"d":"£75"},{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[Projected Cost]]=\"\",Monthly_Expenses_Table[[#This Row],[Actual Cost]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[Projected Cost]]-Monthly_Expenses_Table[[#This Row],[Actual Cost]])","v":{"v":75,"d":"£75"}},{"$f":"Monthly_Expenses_Table[[#This Row],[Actual Cost]]","v":75}]
[null,"Grooming","Pets",{"v":20,"d":"£20"},{"v":25,"d":"£25"},{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[Projected Cost]]=\"\",Monthly_Expenses_Table[[#This Row],[Actual Cost]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[Projected Cost]]-Monthly_Expenses_Table[[#This Row],[Actual Cost]])","v":{"v":-5,"d":"-£5"}},{"$f":"Monthly_Expenses_Table[[#This Row],[Actual Cost]]","v":25}]
[null,"Medical","Pets",null,null,{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[Projected Cost]]=\"\",Monthly_Expenses_Table[[#This Row],[Actual Cost]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[Projected Cost]]-Monthly_Expenses_Table[[#This Row],[Actual Cost]])","v":""},{"$f":"Monthly_Expenses_Table[[#This Row],[Actual Cost]]","v":0}]
[null,"Toys","Pets",null,null,{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[Projected Cost]]=\"\",Monthly_Expenses_Table[[#This Row],[Actual Cost]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[Projected Cost]]-Monthly_Expenses_Table[[#This Row],[Actual Cost]])","v":""},{"$f":"Monthly_Expenses_Table[[#This Row],[Actual Cost]]","v":0}]
[null,"Investment Account","Savings",{"v":200,"d":"£200"},{"v":200,"d":"£200"},{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[Projected Cost]]=\"\",Monthly_Expenses_Table[[#This Row],[Actual Cost]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[Projected Cost]]-Monthly_Expenses_Table[[#This Row],[Actual Cost]])","v":{"v":0,"d":"£0"}},{"$f":"Monthly_Expenses_Table[[#This Row],[Actual Cost]]","v":200}]
[null,"Retirement Account","Savings",null,null,{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[Projected Cost]]=\"\",Monthly_Expenses_Table[[#This Row],[Actual Cost]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[Projected Cost]]-Monthly_Expenses_Table[[#This Row],[Actual Cost]])","v":""},{"$f":"Monthly_Expenses_Table[[#This Row],[Actual Cost]]","v":0}]
[null,"Federal","Taxes",{"v":300,"d":"£300"},{"v":300,"d":"£300"},{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[Projected Cost]]=\"\",Monthly_Expenses_Table[[#This Row],[Actual Cost]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[Projected Cost]]-Monthly_Expenses_Table[[#This Row],[Actual Cost]])","v":{"v":0,"d":"£0"}},{"$f":"Monthly_Expenses_Table[[#This Row],[Actual Cost]]","v":300}]
[null,"Local","Taxes",null,null,{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[Projected Cost]]=\"\",Monthly_Expenses_Table[[#This Row],[Actual Cost]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[Projected Cost]]-Monthly_Expenses_Table[[#This Row],[Actual Cost]])","v":""},{"$f":"Monthly_Expenses_Table[[#This Row],[Actual Cost]]","v":0}]
[null,"State","Taxes",null,null,{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[Projected Cost]]=\"\",Monthly_Expenses_Table[[#This Row],[Actual Cost]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[Projected Cost]]-Monthly_Expenses_Table[[#This Row],[Actual Cost]])","v":""},{"$f":"Monthly_Expenses_Table[[#This Row],[Actual Cost]]","v":0}]
[null,"Bus/Taxi Fare","Transportation",{"v":100,"d":"£100"},{"v":150,"d":"£150"},{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[Projected Cost]]=\"\",Monthly_Expenses_Table[[#This Row],[Actual Cost]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[Projected Cost]]-Monthly_Expenses_Table[[#This Row],[Actual Cost]])","v":{"v":-50,"d":"-£50"}},{"$f":"Monthly_Expenses_Table[[#This Row],[Actual Cost]]","v":150}]
[null,"Fuel","Transportation",{"v":450,"d":"£450"},{"v":400,"d":"£400"},{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[Projected Cost]]=\"\",Monthly_Expenses_Table[[#This Row],[Actual Cost]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[Projected Cost]]-Monthly_Expenses_Table[[#This Row],[Actual Cost]])","v":{"v":50,"d":"£50"}},{"$f":"Monthly_Expenses_Table[[#This Row],[Actual Cost]]","v":400}]
[null,"Insurance","Transportation",{"v":300,"d":"£300"},{"v":300,"d":"£300"},{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[Projected Cost]]=\"\",Monthly_Expenses_Table[[#This Row],[Actual Cost]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[Projected Cost]]-Monthly_Expenses_Table[[#This Row],[Actual Cost]])","v":{"v":0,"d":"£0"}},{"$f":"Monthly_Expenses_Table[[#This Row],[Actual Cost]]","v":300}]
[null,"Licensing ","Transportation",{"v":25,"d":"£25"},{"v":25,"d":"£25"},{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[Projected Cost]]=\"\",Monthly_Expenses_Table[[#This Row],[Actual Cost]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[Projected Cost]]-Monthly_Expenses_Table[[#This Row],[Actual Cost]])","v":{"v":0,"d":"£0"}},{"$f":"Monthly_Expenses_Table[[#This Row],[Actual Cost]]","v":25}]
[null,"Maintenance","Transportation",{"v":100,"d":"£100"},{"v":50,"d":"£50"},{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[Projected Cost]]=\"\",Monthly_Expenses_Table[[#This Row],[Actual Cost]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[Projected Cost]]-Monthly_Expenses_Table[[#This Row],[Actual Cost]])","v":{"v":50,"d":"£50"}},{"$f":"Monthly_Expenses_Table[[#This Row],[Actual Cost]]","v":50}]
[null,"Parking Fees","Transportation",null,null,{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[Projected Cost]]=\"\",Monthly_Expenses_Table[[#This Row],[Actual Cost]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[Projected Cost]]-Monthly_Expenses_Table[[#This Row],[Actual Cost]])","v":""},{"$f":"Monthly_Expenses_Table[[#This Row],[Actual Cost]]","v":0}]
[null,"Vehicle Payment","Transportation",{"v":450,"d":"£450"},{"v":450,"d":"£450"},{"$f":"IF(OR(Monthly_Expenses_Table[[#This Row],[Projected Cost]]=\"\",Monthly_Expenses_Table[[#This Row],[Actual Cost]]=\"\"),\"\",Monthly_Expenses_Table[[#This Row],[Projected Cost]]-Monthly_Expenses_Table[[#This Row],[Actual Cost]])","v":{"v":0,"d":"£0"}},{"$f":"Monthly_Expenses_Table[[#This Row],[Actual Cost]]","v":450}]

{"sheet":"Additional Data","index":3,"n_rows":17,"n_cols":6,"rows_kept":17}
[{"$nulls":5}," "]
[null,"PivotTable for Budget Chart",null,null,"Category List"]
[]
[null,"Categories","Cost",null,"To add a category, type below"]
[null,"Pets",{"v":100,"d":"£100"},null,"Children"]
[null,"Gifts and Charity",{"v":125,"d":"£125"},null,"Entertainment"]
[null,"Children",{"v":140,"d":"£140"},null,"Food"]
[null,"Personal Care",{"v":140,"d":"£140"},null,"Gifts and Charity"]
[null,"Savings",{"v":200,"d":"£200"},null,"Housing"]
[null,"Loans",{"v":200,"d":"£200"},null,"Insurance"]
[null,"Taxes",{"v":300,"d":"£300"},null,"Loans"]
[null,"Entertainment",{"v":358,"d":"£358"},null,"Personal Care"]
[null,"Insurance",{"v":900,"d":"£900"},null,"Pets"]
[null,"Food",{"v":1320,"d":"£1,320"},null,"Savings"]
[null,"Transportation",{"v":1375,"d":"£1,375"},null,"Taxes"]
[null,"Housing",{"v":2702,"d":"£2,702"},null,"Transportation"]
[null,"Grand Total",{"v":7860,"d":"£7,860"}]