{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Lawn and Garden Care"],"not_rendered":{"charts":1,"images":1},"read":"whole","date_system":"1900"}

{"sheet":"Lawn and Garden Care","index":0,"n_rows":45,"n_cols":13,"rows_kept":45,"merged":[[1,1,3,4],[1,5,2,12],[3,9,3,12],[5,7,5,8],[6,7,7,8],[7,1,7,5],[8,7,8,8],[16,1,16,5],[23,1,23,3],[23,7,23,9],[25,1,25,4],[25,7,25,12],[30,1,30,4],[30,7,30,12],[35,7,35,12],[38,1,38,4],[40,7,40,12]]}
[]
[{"$nulls":5},"Lawn and garden care cost calculator"]
[]
[{"$nulls":9},"Calculations for the year"]
[]
[null,"Gardening Equipment",{"$nulls":5},{"$f":"\"Grand total for this year\" & \"\"&L4","v":"Grand total for this year"}]
[null,"Item","Maker/supplier","Quantity","Cost/tool","Cost/yr",null,{"$f":"SUM(I12,I16,I21)","v":{"v":0,"d":"$0.00"}}]
[null,"Tools"]
[null,"Hand tools",null,null,{"v":0,"d":"$0.00"},{"$f":"[Column3]*[Column4]","v":{"v":0,"d":"$0.00"}},null,"Total costs by area"]
[null,"Hoses",null,null,{"v":0,"d":"$0.00"},{"$f":"[Column3]*[Column4]","v":{"v":0,"d":"$0.00"}},null,"Tools",{"$f":"_tools[[#Totals],[Column4]]","v":{"v":0,"d":"$0.00"}}]
[null,"Pruning shears",null,null,{"v":0,"d":"$0.00"},{"$f":"[Column3]*[Column4]","v":{"v":0,"d":"$0.00"}},null,"Ornaments & misc",{"$f":"_misc[[#Totals],[Column4]]","v":{"v":0,"d":"$0.00"}}]
[null,"Gloves",null,null,{"v":0,"d":"$0.00"},{"$f":"[Column3]*[Column4]","v":{"v":0,"d":"$0.00"}},null,"Total",{"$f":"SUM(I10:I11)","v":{"v":0,"d":"$0.00"}}]
[null,"Coveralls/clothes",null,null,{"v":0,"d":"$0.00"},{"$f":"[Column3]*[Column4]","v":{"v":0,"d":"$0.00"}},null,"Lawn care",{"$f":"_lawn[[#Totals],[Column4]]","v":{"v":0,"d":"$0.00"}}]
[null,"Boots",null,null,{"v":0,"d":"$0.00"},{"$f":"[Column3]*[Column4]","v":{"v":0,"d":"$0.00"}},null,"Plant and bed care",{"$f":"_plantcare[[#Totals],[Column4]]","v":{"v":0,"d":"$0.00"}}]
[null,"Hat",null,null,{"v":0,"d":"$0.00"},{"$f":"[Column3]*[Column4]","v":{"v":0,"d":"$0.00"}},null,"Shrubs and tree care",{"$f":"_treecare[[#Totals],[Column4]]","v":{"v":0,"d":"$0.00"}}]
[null,"Tools total cost",null,null,{"$f":"SUBTOTAL(109,[Column4])","v":{"v":0,"d":"$0.00"}},{"$f":"SUBTOTAL(109,[Column5])","v":{"v":0,"d":"$0.00"}},null,"Total",{"$f":"SUM(I13:I15)","v":{"v":0,"d":"$0.00"}}]
[null,"Ornaments/Misc",{"$nulls":5},"Vegetables",{"$f":"_vegetables[[#Totals],[Column6]]","v":{"v":0,"d":"$0.00"}}]
[null,"Statuary",null,null,{"v":0,"d":"$0.00"},{"$f":"[Column3]*[Column4]","v":{"v":0,"d":"$0.00"}},null,"Flowers",{"$f":"_flowers[[#Totals],[Column6]]","v":{"v":0,"d":"$0.00"}}]
[null,"Bird/bat feeders",null,null,{"v":0,"d":"$0.00"},{"$f":"[Column3]*[Column4]","v":{"v":0,"d":"$0.00"}},null,"Seeds and bulbs",{"$f":"_seeds[[#Totals],[Column6]]","v":{"v":0,"d":"$0.00"}}]
[null,"Bird seed/ food",null,null,{"v":0,"d":"$0.00"},{"$f":"[Column3]*[Column4]","v":{"v":0,"d":"$0.00"}},null,"Trees and shrubs",{"$f":"_trees[[#Totals],[Column6]]","v":{"v":0,"d":"$0.00"}}]
[null,"Wind flags",null,null,{"v":0,"d":"$0.00"},{"$f":"[Column3]*[Column4]","v":{"v":0,"d":"$0.00"}},null,"Total",{"$f":"SUM(I17:I20)","v":{"v":0,"d":"$0.00"}}]
[null,"Total misc cost",null,null,{"$f":"SUBTOTAL(109,[Column4])","v":{"v":0,"d":"$0.00"}},{"$f":"SUBTOTAL(109,[Column5])","v":{"v":0,"d":"$0.00"}},null,"Grand total",{"$f":"SUM(I12,I16,I21)","v":{"v":0,"d":"$0.00"}}]
[]
[null,"Garden care",{"$nulls":5},"Garden plants and seeding plan"]
[null,"Item","Company or Service","Times/mth","Cost/yr",null,null,"Item","Supplier","When to plant","Quantity","Cost/item","Cost/yr"]
[null,"Lawn care",{"$nulls":5},"Vegetables"]
[null,"Fertilizers",null,null,{"v":0,"d":"$0.00"},{"$nulls":6},{"v":0,"d":"$0.00"},{"$f":"[Column4]*[Column5]","v":{"v":0,"d":"$0.00"}}]
[null,"Aeration",null,null,{"v":0,"d":"$0.00"},{"$nulls":6},{"v":0,"d":"$0.00"},{"$f":"[Column4]*[Column5]","v":{"v":0,"d":"$0.00"}}]
[null,"Mowing/raking",null,null,{"v":0,"d":"$0.00"},{"$nulls":6},{"v":0,"d":"$0.00"},{"$f":"[Column4]*[Column5]","v":{"v":0,"d":"$0.00"}}]
[null,"Total lawn care",null,null,{"$f":"SUBTOTAL(109,[Column4])","v":{"v":0,"d":"$0.00"}},null,null,"Total vegetables cost",{"$nulls":3},{"$f":"SUBTOTAL(109,[Column5])","v":{"v":0,"d":"$0.00"}},{"$f":"SUBTOTAL(109,[Column6])","v":{"v":0,"d":"$0.00"}}]
[null,"Plant and bed care",{"$nulls":5},"Flowers"]
[null,"Mulch",null,null,{"v":0,"d":"$0.00"},{"$nulls":6},{"v":0,"d":"$0.00"},{"$f":"[Column4]*[Column5]","v":{"v":0,"d":"$0.00"}}]
[null,"Tilling by machine",null,null,{"v":0,"d":"$0.00"},{"$nulls":6},{"v":0,"d":"$0.00"},{"$f":"[Column4]*[Column5]","v":{"v":0,"d":"$0.00"}}]
[null,"Topsoil",null,null,{"v":0,"d":"$0.00"},{"$nulls":6},{"v":0,"d":"$0.00"},{"$f":"[Column4]*[Column5]","v":{"v":0,"d":"$0.00"}}]
[null,"Weeding/spray",null,null,{"v":0,"d":"$0.00"},null,null,"Total flowers cost",{"$nulls":3},{"$f":"SUBTOTAL(109,[Column5])","v":{"v":0,"d":"$0.00"}},{"$f":"SUBTOTAL(109,[Column6])","v":{"v":0,"d":"$0.00"}}]
[null,"Watering",null,null,{"v":0,"d":"$0.00"},null,null,"Seeds and bulbs"]
[null,"Fertilizer",null,null,{"v":0,"d":"$0.00"},{"$nulls":6},{"v":0,"d":"$0.00"},{"$f":"[Column4]*[Column5]","v":{"v":0,"d":"$0.00"}}]
[null,"Total plant care",null,null,{"$f":"SUBTOTAL(109,[Column4])","v":{"v":0,"d":"$0.00"}},{"$nulls":6},{"v":0,"d":"$0.00"},{"$f":"[Column4]*[Column5]","v":{"v":0,"d":"$0.00"}}]
[null,"Shrubs and tree care",{"$nulls":9},{"v":0,"d":"$0.00"},{"$f":"[Column4]*[Column5]","v":{"v":0,"d":"$0.00"}}]
[null,"Pruning",null,null,{"v":0,"d":"$0.00"},null,null,"Total seeds cost",{"$nulls":3},{"$f":"SUBTOTAL(109,[Column5])","v":{"v":0,"d":"$0.00"}},{"$f":"SUBTOTAL(109,[Column6])","v":{"v":0,"d":"$0.00"}}]
[null,"Mulch",null,null,{"v":0,"d":"$0.00"},null,null,"Trees and shrubs"]
[null,"Fertilizers",null,null,{"v":0,"d":"$0.00"},{"$nulls":6},{"v":0,"d":"$0.00"},{"$f":"[Column4]*[Column5]","v":{"v":0,"d":"$0.00"}}]
[null,"Protective fencing",null,null,{"v":0,"d":"$0.00"},{"$nulls":6},{"v":0,"d":"$0.00"},{"$f":"[Column4]*[Column5]","v":{"v":0,"d":"$0.00"}}]
[null,"Leaf collection",null,null,{"v":0,"d":"$0.00"},{"$nulls":6},{"v":0,"d":"$0.00"},{"$f":"[Column4]*[Column5]","v":{"v":0,"d":"$0.00"}}]
[null,"Total tree care",null,null,{"$f":"SUBTOTAL(109,[Column4])","v":{"v":0,"d":"$0.00"}},null,null,"Total trees cost",{"$nulls":3},{"$f":"SUBTOTAL(109,[Column5])","v":{"v":0,"d":"$0.00"}},{"$f":"SUBTOTAL(109,[Column6])","v":{"v":0,"d":"$0.00"}}]