{"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":[[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 theatre",{"v":200,"d":"£200"},{"v":150,"d":"£150"},{"v":50,"d":"£50"}]
[null,"Films",{"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,"Transport",{"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 theatre","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,"Films","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,"Food and drink","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,"Electricity","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,"Gas","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,"Income tax","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,"Council tax","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","Transport",{"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","Transport",{"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","Transport",{"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 ","Transport",{"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","Transport",{"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","Transport",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","Transport",{"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,"Children",{"v":140,"d":"£140"},null,"Children"]
[null,"Entertainment",{"v":358,"d":"£358"},null,"Entertainment"]
[null,"Food",{"v":1320,"d":"£1,320"},null,"Food"]
[null,"Gifts and charity",{"v":125,"d":"£125"},null,"Gifts and charity"]
[null,"Housing",{"v":2702,"d":"£2,702"},null,"Housing"]
[null,"Insurance",{"v":900,"d":"£900"},null,"Insurance"]
[null,"Loans",{"v":200,"d":"£200"},null,"Loans"]
[null,"Personal care",{"v":140,"d":"£140"},null,"Personal care"]
[null,"Pets",{"v":100,"d":"£100"},null,"Pets"]
[null,"Savings",{"v":200,"d":"£200"},null,"Savings"]
[null,"Taxes",{"v":300,"d":"£300"},null,"Taxes"]
[null,"Transport",{"v":1375,"d":"£1,375"},null,"Transport"]
[null,"Grand Total",{"v":7860,"d":"£7,860"}]