{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Monthly budget report","Monthly expenses","Additional data"],"not_rendered":{"charts":1,"defined_names":4,"pivot_tables":2},"read":"whole","date_system":"1900"}

{"sheet":"Monthly budget report","index":0,"n_rows":34,"n_cols":14,"rows_kept":34,"merged":[[7,1,10,1],[7,5,10,5],[7,6,10,6],[12,1,16,1],[12,5,16,5],[12,6,16,6]]}
[null,"Budget overview",{"$nulls":7},"Budget summary"]
[null,"Balance"]
[null,"Projected balance","(Projected minus expenses)",{"$nulls":3},{"$f":"D17-SUM(BudgetDetails[Projected cost])","v":{"v":1585,"d":"£1,585"}}]
[null,"Actual balance ","(Actual minus expenses)",{"$nulls":3},{"$f":"D11-SUM(BudgetDetails[Actual cost])","v":{"v":1740,"d":"£1,740"}}]
[null,"Difference","(Actual minus projected)",{"$nulls":3},{"$f":"G4-G3","v":{"v":155,"d":"£155"}}]
[]
[null,"Income",{"$nulls":3},"Expenses",{"$nulls":3},"Right-click PivotTable below and then click Refresh to update"]
[null,"ACTUAL","Income 1",{"v":5800,"d":"£5,800"},null,"ACTUAL",{"$f":"SUM(BudgetDetails[Actual cost])","v":{"v":7860,"d":"£7,860"}}]
[null,null,"Income 2",{"v":2300,"d":"£2,300"},{"$nulls":6},"Category","Projected Cost ","Actual Cost ","Difference "]
[null,null,"Extra income",{"v":1500,"d":"£1,500"},{"$nulls":6},"Children",{"v":140,"d":"£140"},{"v":140,"d":"£140"},{"v":0,"d":"£0"}]
[null,null,"Total income",{"$f":"SUM(D8:D10)","v":{"v":9600,"d":"£9,600"}}]
[{"$nulls":10},"Entertainment",{"v":400,"d":"£400"},{"v":358,"d":"£358"},{"v":42,"d":"£42"}]
[null,"PROJECTED",{"$nulls":3},"PROJECTED",{"$f":"SUM(BudgetDetails[Projected cost])","v":{"v":7915,"d":"£7,915"}}]
[null,null,"Income 1",{"v":6000,"d":"£6,000"},{"$nulls":6},"Food",{"v":1100,"d":"£1,100"},{"v":1320,"d":"£1,320"},{"v":-220,"d":"-£220"}]
[null,null,"Income 2",{"v":1000,"d":"£1,000"}]
[null,null,"Extra income",{"v":2500,"d":"£2,500"},{"$nulls":6},"Gifts and charity",{"v":100,"d":"£100"},{"v":125,"d":"£125"},{"v":-25,"d":"-£25"}]
[null,null,"Total income",{"$f":"SUM(D14:D16)","v":{"v":9500,"d":"£9,500"}}]
[{"$nulls":10},"Housing",{"v":2830,"d":"£2,830"},{"v":2702,"d":"£2,702"},{"v":128,"d":"£128"}]
[]
[{"$nulls":10},"Insurance",{"v":900,"d":"£900"},{"v":900,"d":"£900"},{"v":0,"d":"£0"}]
[]
[{"$nulls":10},"Loans",{"v":200,"d":"£200"},{"v":200,"d":"£200"},{"v":0,"d":"£0"}]
[]
[{"$nulls":10},"Personal care",{"v":150,"d":"£150"},{"v":140,"d":"£140"},{"v":10,"d":"£10"}]
[]
[{"$nulls":10},"Pets",{"v":170,"d":"£170"},{"v":100,"d":"£100"},{"v":70,"d":"£70"}]
[]
[{"$nulls":10},"Savings or investments",{"v":200,"d":"£200"},{"v":200,"d":"£200"},{"v":0,"d":"£0"}]
[]
[{"$nulls":10},"Taxes",{"v":300,"d":"£300"},{"v":300,"d":"£300"},{"v":0,"d":"£0"}]
[]
[{"$nulls":10},"Transport",{"v":1425,"d":"£1,425"},{"v":1375,"d":"£1,375"},{"v":50,"d":"£50"}]
[]
[{"$nulls":10},"Grand Total",{"v":7915,"d":"£7,915"},{"v":7860,"d":"£7,860"},{"v":55,"d":"£55"}]

{"sheet":"Monthly expenses","index":1,"n_rows":62,"n_cols":7,"rows_kept":62}
[null,"Monthly expenses"]
[null,"Description","Category","Projected cost","Actual cost","Difference","Actual cost overview"]
[null,"Extracurricular activities","Children",{"v":40,"d":"£40"},{"v":40,"d":"£40"},{"$f":"BudgetDetails[[#This Row],[Projected cost]]-BudgetDetails[[#This Row],[Actual cost]]","v":{"v":0,"d":"£0"}},{"$f":"BudgetDetails[[#This Row],[Actual cost]]","v":{"v":40,"d":"£40"}}]
[null,"Medical","Children",null,null,{"$f":"BudgetDetails[[#This Row],[Projected cost]]-BudgetDetails[[#This Row],[Actual cost]]","v":{"v":0,"d":"£0"}},{"$f":"BudgetDetails[[#This Row],[Actual cost]]","v":{"v":0,"d":"£0"}}]
[null,"School supplies","Children",null,null,{"$f":"BudgetDetails[[#This Row],[Projected cost]]-BudgetDetails[[#This Row],[Actual cost]]","v":{"v":0,"d":"£0"}},{"$f":"BudgetDetails[[#This Row],[Actual cost]]","v":{"v":0,"d":"£0"}}]
[null,"School tuition","Children",{"v":100,"d":"£100"},{"v":100,"d":"£100"},{"$f":"BudgetDetails[[#This Row],[Projected cost]]-BudgetDetails[[#This Row],[Actual cost]]","v":{"v":0,"d":"£0"}},{"$f":"BudgetDetails[[#This Row],[Actual cost]]","v":{"v":100,"d":"£100"}}]
[null,"Concerts","Entertainment",{"v":50,"d":"£50"},{"v":40,"d":"£40"},{"$f":"BudgetDetails[[#This Row],[Projected cost]]-BudgetDetails[[#This Row],[Actual cost]]","v":{"v":10,"d":"£10"}},{"$f":"BudgetDetails[[#This Row],[Actual cost]]","v":{"v":40,"d":"£40"}}]
[null,"Live theatre","Entertainment",{"v":200,"d":"£200"},{"v":150,"d":"£150"},{"$f":"BudgetDetails[[#This Row],[Projected cost]]-BudgetDetails[[#This Row],[Actual cost]]","v":{"v":50,"d":"£50"}},{"$f":"BudgetDetails[[#This Row],[Actual cost]]","v":{"v":150,"d":"£150"}}]
[null,"Films","Entertainment",{"v":50,"d":"£50"},{"v":28,"d":"£28"},{"$f":"BudgetDetails[[#This Row],[Projected cost]]-BudgetDetails[[#This Row],[Actual cost]]","v":{"v":22,"d":"£22"}},{"$f":"BudgetDetails[[#This Row],[Actual cost]]","v":{"v":28,"d":"£28"}}]
[null,"Music (CDs, downloads etc.)","Entertainment",{"v":50,"d":"£50"},{"v":30,"d":"£30"},{"$f":"BudgetDetails[[#This Row],[Projected cost]]-BudgetDetails[[#This Row],[Actual cost]]","v":{"v":20,"d":"£20"}},{"$f":"BudgetDetails[[#This Row],[Actual cost]]","v":{"v":30,"d":"£30"}}]
[null,"Sporting events","Entertainment",{"v":0,"d":"£0"},{"v":40,"d":"£40"},{"$f":"BudgetDetails[[#This Row],[Projected cost]]-BudgetDetails[[#This Row],[Actual cost]]","v":{"v":-40,"d":"-£40"}},{"$f":"BudgetDetails[[#This Row],[Actual cost]]","v":{"v":40,"d":"£40"}}]
[null,"Video/DVD (Purchase)","Entertainment",{"v":20,"d":"£20"},{"v":50,"d":"£50"},{"$f":"BudgetDetails[[#This Row],[Projected cost]]-BudgetDetails[[#This Row],[Actual cost]]","v":{"v":-30,"d":"-£30"}},{"$f":"BudgetDetails[[#This Row],[Actual cost]]","v":{"v":50,"d":"£50"}}]
[null,"Video/DVD (Rental)","Entertainment",{"v":30,"d":"£30"},{"v":20,"d":"£20"},{"$f":"BudgetDetails[[#This Row],[Projected cost]]-BudgetDetails[[#This Row],[Actual cost]]","v":{"v":10,"d":"£10"}},{"$f":"BudgetDetails[[#This Row],[Actual cost]]","v":{"v":20,"d":"£20"}}]
[null,"Dining out","Food",{"v":1000,"d":"£1,000"},{"v":1200,"d":"£1,200"},{"$f":"BudgetDetails[[#This Row],[Projected cost]]-BudgetDetails[[#This Row],[Actual cost]]","v":{"v":-200,"d":"-£200"}},{"$f":"BudgetDetails[[#This Row],[Actual cost]]","v":{"v":1200,"d":"£1,200"}}]
[null,"Food and drink","Food",{"v":100,"d":"£100"},{"v":120,"d":"£120"},{"$f":"BudgetDetails[[#This Row],[Projected cost]]-BudgetDetails[[#This Row],[Actual cost]]","v":{"v":-20,"d":"-£20"}},{"$f":"BudgetDetails[[#This Row],[Actual cost]]","v":{"v":120,"d":"£120"}}]
[null,"Charity 1","Gifts and charity",{"v":75,"d":"£75"},{"v":100,"d":"£100"},{"$f":"BudgetDetails[[#This Row],[Projected cost]]-BudgetDetails[[#This Row],[Actual cost]]","v":{"v":-25,"d":"-£25"}},{"$f":"BudgetDetails[[#This Row],[Actual cost]]","v":{"v":100,"d":"£100"}}]
[null,"Charity 2","Gifts and charity",{"v":25,"d":"£25"},{"v":25,"d":"£25"},{"$f":"BudgetDetails[[#This Row],[Projected cost]]-BudgetDetails[[#This Row],[Actual cost]]","v":{"v":0,"d":"£0"}},{"$f":"BudgetDetails[[#This Row],[Actual cost]]","v":{"v":25,"d":"£25"}}]
[null,"Gift 1","Gifts and charity",null,null,{"$f":"BudgetDetails[[#This Row],[Projected cost]]-BudgetDetails[[#This Row],[Actual cost]]","v":{"v":0,"d":"£0"}},{"$f":"BudgetDetails[[#This Row],[Actual cost]]","v":{"v":0,"d":"£0"}}]
[null,"Gift 2","Gifts and charity",null,null,{"$f":"BudgetDetails[[#This Row],[Projected cost]]-BudgetDetails[[#This Row],[Actual cost]]","v":{"v":0,"d":"£0"}},{"$f":"BudgetDetails[[#This Row],[Actual cost]]","v":{"v":0,"d":"£0"}}]
[null,"Cable/Satellite","Housing",{"v":100,"d":"£100"},{"v":100,"d":"£100"},{"$f":"BudgetDetails[[#This Row],[Projected cost]]-BudgetDetails[[#This Row],[Actual cost]]","v":{"v":0,"d":"£0"}},{"$f":"BudgetDetails[[#This Row],[Actual cost]]","v":{"v":100,"d":"£100"}}]
[null,"Electricity","Housing",{"v":45,"d":"£45"},{"v":50,"d":"£50"},{"$f":"BudgetDetails[[#This Row],[Projected cost]]-BudgetDetails[[#This Row],[Actual cost]]","v":{"v":-5,"d":"-£5"}},{"$f":"BudgetDetails[[#This Row],[Actual cost]]","v":{"v":50,"d":"£50"}}]
[null,"Gas","Housing",{"v":300,"d":"£300"},{"v":400,"d":"£400"},{"$f":"BudgetDetails[[#This Row],[Projected cost]]-BudgetDetails[[#This Row],[Actual cost]]","v":{"v":-100,"d":"-£100"}},{"$f":"BudgetDetails[[#This Row],[Actual cost]]","v":{"v":400,"d":"£400"}}]
[null,"House cleaning service","Housing",{"v":200,"d":"£200"},null,{"$f":"BudgetDetails[[#This Row],[Projected cost]]-BudgetDetails[[#This Row],[Actual cost]]","v":{"v":200,"d":"£200"}},{"$f":"BudgetDetails[[#This Row],[Actual cost]]","v":{"v":0,"d":"£0"}}]
[null,"Maintenance","Housing",{"v":200,"d":"£200"},{"v":150,"d":"£150"},{"$f":"BudgetDetails[[#This Row],[Projected cost]]-BudgetDetails[[#This Row],[Actual cost]]","v":{"v":50,"d":"£50"}},{"$f":"BudgetDetails[[#This Row],[Actual cost]]","v":{"v":150,"d":"£150"}}]
[null,"Mortgage or rent","Housing",{"v":1700,"d":"£1,700"},{"v":1700,"d":"£1,700"},{"$f":"BudgetDetails[[#This Row],[Projected cost]]-BudgetDetails[[#This Row],[Actual cost]]","v":{"v":0,"d":"£0"}},{"$f":"BudgetDetails[[#This Row],[Actual cost]]","v":{"v":1700,"d":"£1,700"}}]
[null,"Natural gas/oil","Housing",null,null,{"$f":"BudgetDetails[[#This Row],[Projected cost]]-BudgetDetails[[#This Row],[Actual cost]]","v":{"v":0,"d":"£0"}},{"$f":"BudgetDetails[[#This Row],[Actual cost]]","v":{"v":0,"d":"£0"}}]
[null,"Online/Internet service","Housing",{"v":100,"d":"£100"},{"v":100,"d":"£100"},{"$f":"BudgetDetails[[#This Row],[Projected cost]]-BudgetDetails[[#This Row],[Actual cost]]","v":{"v":0,"d":"£0"}},{"$f":"BudgetDetails[[#This Row],[Actual cost]]","v":{"v":100,"d":"£100"}}]
[null,"Phone (mobile)","Housing",{"v":60,"d":"£60"},{"v":60,"d":"£60"},{"$f":"BudgetDetails[[#This Row],[Projected cost]]-BudgetDetails[[#This Row],[Actual cost]]","v":{"v":0,"d":"£0"}},{"$f":"BudgetDetails[[#This Row],[Actual cost]]","v":{"v":60,"d":"£60"}}]
[null,"Phone (home)","Housing",{"v":35,"d":"£35"},{"v":39,"d":"£39"},{"$f":"BudgetDetails[[#This Row],[Projected cost]]-BudgetDetails[[#This Row],[Actual cost]]","v":{"v":-4,"d":"-£4"}},{"$f":"BudgetDetails[[#This Row],[Actual cost]]","v":{"v":39,"d":"£39"}}]
[null,"Supplies","Housing",{"v":40,"d":"£40"},{"v":55,"d":"£55"},{"$f":"BudgetDetails[[#This Row],[Projected cost]]-BudgetDetails[[#This Row],[Actual cost]]","v":{"v":-15,"d":"-£15"}},{"$f":"BudgetDetails[[#This Row],[Actual cost]]","v":{"v":55,"d":"£55"}}]
[null,"Waste removal and recycle","Housing",{"v":25,"d":"£25"},{"v":22,"d":"£22"},{"$f":"BudgetDetails[[#This Row],[Projected cost]]-BudgetDetails[[#This Row],[Actual cost]]","v":{"v":3,"d":"£3"}},{"$f":"BudgetDetails[[#This Row],[Actual cost]]","v":{"v":22,"d":"£22"}}]
[null,"Water and sewer","Housing",{"v":25,"d":"£25"},{"v":26,"d":"£26"},{"$f":"BudgetDetails[[#This Row],[Projected cost]]-BudgetDetails[[#This Row],[Actual cost]]","v":{"v":-1,"d":"-£1"}},{"$f":"BudgetDetails[[#This Row],[Actual cost]]","v":{"v":26,"d":"£26"}}]
[null,"Health","Insurance",{"v":400,"d":"£400"},{"v":400,"d":"£400"},{"$f":"BudgetDetails[[#This Row],[Projected cost]]-BudgetDetails[[#This Row],[Actual cost]]","v":{"v":0,"d":"£0"}},{"$f":"BudgetDetails[[#This Row],[Actual cost]]","v":{"v":400,"d":"£400"}}]
[null,"Home","Insurance",{"v":400,"d":"£400"},{"v":400,"d":"£400"},{"$f":"BudgetDetails[[#This Row],[Projected cost]]-BudgetDetails[[#This Row],[Actual cost]]","v":{"v":0,"d":"£0"}},{"$f":"BudgetDetails[[#This Row],[Actual cost]]","v":{"v":400,"d":"£400"}}]
[null,"Life","Insurance",{"v":100,"d":"£100"},{"v":100,"d":"£100"},{"$f":"BudgetDetails[[#This Row],[Projected cost]]-BudgetDetails[[#This Row],[Actual cost]]","v":{"v":0,"d":"£0"}},{"$f":"BudgetDetails[[#This Row],[Actual cost]]","v":{"v":100,"d":"£100"}}]
[null,"Credit card 1","Loans",{"v":200,"d":"£200"},{"v":200,"d":"£200"},{"$f":"BudgetDetails[[#This Row],[Projected cost]]-BudgetDetails[[#This Row],[Actual cost]]","v":{"v":0,"d":"£0"}},{"$f":"BudgetDetails[[#This Row],[Actual cost]]","v":{"v":200,"d":"£200"}}]
[null,"Credit card 2","Loans",null,null,{"$f":"BudgetDetails[[#This Row],[Projected cost]]-BudgetDetails[[#This Row],[Actual cost]]","v":{"v":0,"d":"£0"}},{"$f":"BudgetDetails[[#This Row],[Actual cost]]","v":{"v":0,"d":"£0"}}]
[null,"Credit card 3","Loans",null,null,{"$f":"BudgetDetails[[#This Row],[Projected cost]]-BudgetDetails[[#This Row],[Actual cost]]","v":{"v":0,"d":"£0"}},{"$f":"BudgetDetails[[#This Row],[Actual cost]]","v":{"v":0,"d":"£0"}}]
[null,"Personal","Loans",null,null,{"$f":"BudgetDetails[[#This Row],[Projected cost]]-BudgetDetails[[#This Row],[Actual cost]]","v":{"v":0,"d":"£0"}},{"$f":"BudgetDetails[[#This Row],[Actual cost]]","v":{"v":0,"d":"£0"}}]
[null,"Student","Loans",null,null,{"$f":"BudgetDetails[[#This Row],[Projected cost]]-BudgetDetails[[#This Row],[Actual cost]]","v":{"v":0,"d":"£0"}},{"$f":"BudgetDetails[[#This Row],[Actual cost]]","v":{"v":0,"d":"£0"}}]
[null,"Clothing","Personal care",{"v":150,"d":"£150"},{"v":140,"d":"£140"},{"$f":"BudgetDetails[[#This Row],[Projected cost]]-BudgetDetails[[#This Row],[Actual cost]]","v":{"v":10,"d":"£10"}},{"$f":"BudgetDetails[[#This Row],[Actual cost]]","v":{"v":140,"d":"£140"}}]
[null,"Dry cleaning","Personal care",null,null,{"$f":"BudgetDetails[[#This Row],[Projected cost]]-BudgetDetails[[#This Row],[Actual cost]]","v":{"v":0,"d":"£0"}},{"$f":"BudgetDetails[[#This Row],[Actual cost]]","v":{"v":0,"d":"£0"}}]
[null,"Hair/nails","Personal care",null,null,{"$f":"BudgetDetails[[#This Row],[Projected cost]]-BudgetDetails[[#This Row],[Actual cost]]","v":{"v":0,"d":"£0"}},{"$f":"BudgetDetails[[#This Row],[Actual cost]]","v":{"v":0,"d":"£0"}}]
[null,"Health club","Personal care",null,null,{"$f":"BudgetDetails[[#This Row],[Projected cost]]-BudgetDetails[[#This Row],[Actual cost]]","v":{"v":0,"d":"£0"}},{"$f":"BudgetDetails[[#This Row],[Actual cost]]","v":{"v":0,"d":"£0"}}]
[null,"Medical","Personal care",null,null,{"$f":"BudgetDetails[[#This Row],[Projected cost]]-BudgetDetails[[#This Row],[Actual cost]]","v":{"v":0,"d":"£0"}},{"$f":"BudgetDetails[[#This Row],[Actual cost]]","v":{"v":0,"d":"£0"}}]
[null,"Food","Pets",{"v":150,"d":"£150"},{"v":75,"d":"£75"},{"$f":"BudgetDetails[[#This Row],[Projected cost]]-BudgetDetails[[#This Row],[Actual cost]]","v":{"v":75,"d":"£75"}},{"$f":"BudgetDetails[[#This Row],[Actual cost]]","v":{"v":75,"d":"£75"}}]
[null,"Grooming","Pets",{"v":20,"d":"£20"},{"v":25,"d":"£25"},{"$f":"BudgetDetails[[#This Row],[Projected cost]]-BudgetDetails[[#This Row],[Actual cost]]","v":{"v":-5,"d":"-£5"}},{"$f":"BudgetDetails[[#This Row],[Actual cost]]","v":{"v":25,"d":"£25"}}]
[null,"Medical","Pets",null,null,{"$f":"BudgetDetails[[#This Row],[Projected cost]]-BudgetDetails[[#This Row],[Actual cost]]","v":{"v":0,"d":"£0"}},{"$f":"BudgetDetails[[#This Row],[Actual cost]]","v":{"v":0,"d":"£0"}}]
[null,"Toys","Pets",null,null,{"$f":"BudgetDetails[[#This Row],[Projected cost]]-BudgetDetails[[#This Row],[Actual cost]]","v":{"v":0,"d":"£0"}},{"$f":"BudgetDetails[[#This Row],[Actual cost]]","v":{"v":0,"d":"£0"}}]
[null,"Investment account","Savings or investments",{"v":200,"d":"£200"},{"v":200,"d":"£200"},{"$f":"BudgetDetails[[#This Row],[Projected cost]]-BudgetDetails[[#This Row],[Actual cost]]","v":{"v":0,"d":"£0"}},{"$f":"BudgetDetails[[#This Row],[Actual cost]]","v":{"v":200,"d":"£200"}}]
[null,"Retirement account","Savings or investments",null,null,{"$f":"BudgetDetails[[#This Row],[Projected cost]]-BudgetDetails[[#This Row],[Actual cost]]","v":{"v":0,"d":"£0"}},{"$f":"BudgetDetails[[#This Row],[Actual cost]]","v":{"v":0,"d":"£0"}}]
[null,"Income tax","Taxes",{"v":300,"d":"£300"},{"v":300,"d":"£300"},{"$f":"BudgetDetails[[#This Row],[Projected cost]]-BudgetDetails[[#This Row],[Actual cost]]","v":{"v":0,"d":"£0"}},{"$f":"BudgetDetails[[#This Row],[Actual cost]]","v":{"v":300,"d":"£300"}}]
[null,"Local","Taxes",null,null,{"$f":"BudgetDetails[[#This Row],[Projected cost]]-BudgetDetails[[#This Row],[Actual cost]]","v":{"v":0,"d":"£0"}},{"$f":"BudgetDetails[[#This Row],[Actual cost]]","v":{"v":0,"d":"£0"}}]
[null,"Council tax","Taxes",null,null,{"$f":"BudgetDetails[[#This Row],[Projected cost]]-BudgetDetails[[#This Row],[Actual cost]]","v":{"v":0,"d":"£0"}},{"$f":"BudgetDetails[[#This Row],[Actual cost]]","v":{"v":0,"d":"£0"}}]
[null,"Bus/taxi fare","Transport",{"v":100,"d":"£100"},{"v":150,"d":"£150"},{"$f":"BudgetDetails[[#This Row],[Projected cost]]-BudgetDetails[[#This Row],[Actual cost]]","v":{"v":-50,"d":"-£50"}},{"$f":"BudgetDetails[[#This Row],[Actual cost]]","v":{"v":150,"d":"£150"}}]
[null,"Fuel","Transport",{"v":450,"d":"£450"},{"v":400,"d":"£400"},{"$f":"BudgetDetails[[#This Row],[Projected cost]]-BudgetDetails[[#This Row],[Actual cost]]","v":{"v":50,"d":"£50"}},{"$f":"BudgetDetails[[#This Row],[Actual cost]]","v":{"v":400,"d":"£400"}}]
[null,"Insurance","Transport",{"v":300,"d":"£300"},{"v":300,"d":"£300"},{"$f":"BudgetDetails[[#This Row],[Projected cost]]-BudgetDetails[[#This Row],[Actual cost]]","v":{"v":0,"d":"£0"}},{"$f":"BudgetDetails[[#This Row],[Actual cost]]","v":{"v":300,"d":"£300"}}]
[null,"Licensing ","Transport",{"v":25,"d":"£25"},{"v":25,"d":"£25"},{"$f":"BudgetDetails[[#This Row],[Projected cost]]-BudgetDetails[[#This Row],[Actual cost]]","v":{"v":0,"d":"£0"}},{"$f":"BudgetDetails[[#This Row],[Actual cost]]","v":{"v":25,"d":"£25"}}]
[null,"Maintenance","Transport",{"v":100,"d":"£100"},{"v":50,"d":"£50"},{"$f":"BudgetDetails[[#This Row],[Projected cost]]-BudgetDetails[[#This Row],[Actual cost]]","v":{"v":50,"d":"£50"}},{"$f":"BudgetDetails[[#This Row],[Actual cost]]","v":{"v":50,"d":"£50"}}]
[null,"Parking fees","Transport",null,null,{"$f":"BudgetDetails[[#This Row],[Projected cost]]-BudgetDetails[[#This Row],[Actual cost]]","v":{"v":0,"d":"£0"}},{"$f":"BudgetDetails[[#This Row],[Actual cost]]","v":{"v":0,"d":"£0"}}]
[null,"Vehicle payment","Transport",{"v":450,"d":"£450"},{"v":450,"d":"£450"},{"$f":"BudgetDetails[[#This Row],[Projected cost]]-BudgetDetails[[#This Row],[Actual cost]]","v":{"v":0,"d":"£0"}},{"$f":"BudgetDetails[[#This Row],[Actual cost]]","v":{"v":450,"d":"£450"}}]
[null,"Total",null,{"$f":"SUBTOTAL(109,BudgetDetails[Projected cost])","v":{"v":7915,"d":"£7,915"}},{"$f":"SUBTOTAL(109,BudgetDetails[Actual cost])","v":{"v":7860,"d":"£7,860"}},{"$f":"SUBTOTAL(109,BudgetDetails[Difference])","v":{"v":55,"d":"£55"}}]

{"sheet":"Additional data","index":2,"n_rows":15,"n_cols":5,"rows_kept":15}
[null,"PivotTable for Budget overview chart",null,null,"Lookup list for Budget details category"]
[null,"Category","Cost",null,"Budget category lookup"]
[null,"Children",140,null,"Children"]
[null,"Entertainment",358,null,"Entertainment"]
[null,"Food",1320,null,"Food"]
[null,"Gifts and charity",125,null,"Gifts and charity"]
[null,"Housing",2702,null,"Housing"]
[null,"Insurance",900,null,"Insurance"]
[null,"Loans",200,null,"Loans"]
[null,"Personal care",140,null,"Personal care"]
[null,"Pets",100,null,"Pets"]
[null,"Savings or investments",200,null,"Savings or investments"]
[null,"Taxes",300,null,"Taxes"]
[null,"Transport",1375,null,"Transport"]
[null,"Grand Total",7860]