{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["GARDEN BUDGET","LIST"],"not_rendered":{"charts":2,"images":1,"defined_names":12},"read":"whole","date_system":"1900"}

{"sheet":"GARDEN BUDGET","index":0,"n_rows":15,"n_cols":10,"rows_kept":15,"merged":[[0,1,0,6],[0,8,3,8],[0,9,3,9],[1,3,6,6],[4,8,6,9]]}
[null,"GARDEN BUDGET",{"$nulls":6},"Slicer to filter garden budget by type is in this cell.","Slicer to filter garden budget by plants is in this cell."]
[null,"BUDGETED AMOUNT","Pie chart showing Budgeted Amount versus Total Costs is in this cell. Plant Expenses chart is in cell to the right.","Column chart showing Plants Expenses is in this cell. Slicers to filter garden budget by Type and Plants are in cells I1 and J1, and information is in cell I5, to the right."]
[null,{"v":290,"d":"£290.00"}]
[null,"TOTAL COSTS",{"$f":"BudgetedAmount","v":{"v":290,"d":"£290.00"}}]
[null,{"$f":"SUM(GardenBudget[TOTAL])","v":{"v":231.94,"d":"£231.94"}},{"$f":"TotalCosts","v":{"v":231.94,"d":"£231.94"}},{"$nulls":5},"INFO:To add a new row to the data table, select the bottom-right cell in the table, just above the total row, and press Tab."]
[null,"DIFFERENCE"]
[null,{"$f":"BudgetedAmount-TotalCosts","v":{"v":58.06,"d":"£58.06"}}]
[null,"TYPE","PLANTS","DESCRIPTION","QUANTITY","COST","TOTAL"]
[null,"PLANTS","Rhododendron","Flowering evergreen",2,{"v":35,"d":"£35.00"},{"$f":"GardenBudget[[#This Row],[QUANTITY]]*GardenBudget[[#This Row],[COST]]","v":{"v":70,"d":"£70.00"}}]
[null,"FLOWERS","Petunia","Annual, purple and white",6,{"v":1.99,"d":"£1.99"},{"$f":"GardenBudget[[#This Row],[QUANTITY]]*GardenBudget[[#This Row],[COST]]","v":{"v":11.94,"d":"£11.94"}}]
[null,"TREES","Japanese Maple","Leafy tree",1,{"v":150,"d":"£150.00"},{"$f":"GardenBudget[[#This Row],[QUANTITY]]*GardenBudget[[#This Row],[COST]]","v":{"v":150,"d":"£150.00"}}]
[{"$nulls":6},{"$f":"GardenBudget[[#This Row],[QUANTITY]]*GardenBudget[[#This Row],[COST]]","v":{"v":0,"d":"£0.00"}}]
[{"$nulls":6},{"$f":"GardenBudget[[#This Row],[QUANTITY]]*GardenBudget[[#This Row],[COST]]","v":{"v":0,"d":"£0.00"}}]
[{"$nulls":6},{"$f":"GardenBudget[[#This Row],[QUANTITY]]*GardenBudget[[#This Row],[COST]]","v":{"v":0,"d":"£0.00"}}]
[null,"TOTAL PLANTS",{"$nulls":4},{"$f":"SUBTOTAL(109,GardenBudget[TOTAL])","v":{"v":231.94,"d":"£231.94"}}]

{"sheet":"LIST","index":1,"n_rows":13,"n_cols":2,"rows_kept":13}
[null,"GARDEN AREAS"]
[null,"TYPE"]
[null,"PLANTS"]
[null,"FLOWERS"]
[null,"TREES"]
[null,"SEEDS"]
[null,"PLANT FOOD"]
[null,"SOIL"]
[null,"MULCH"]
[null,"FERTILISER/COMPOST"]
[null,"HERBICIDES/PESTICIDES"]
[null,"FENCING"]
[null,"FURNITURE/STATUARY"]