{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["INSTRUCTIONS - Please Read","Part 1 - Tree Costs","Part 2 - Other Capital Items ","Part 3 - Match Funding","Part 4 - Totals","Dropdowns HIDDEN","Costs HIDDEN"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":3,"defined_names":26,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"INSTRUCTIONS - Please Read","index":0,"n_rows":2,"n_cols":4,"rows_kept":2,"cut":false,"hidden":false,"merged":[[0,1,0,2],[1,1,9,3]]}
[null,"Local Authority Treescapes Fund\nApplication Form - Project Cost Calculator",null,"Version 1.0 01/23"]
[null,"Guidance on completing this form - FY 2024 - 2025\n\nThis form must be completed and submitted alongside your main LATF application form. You must complete the LATF Project Cost Calculator to show your estimate of costs and submit this with your application. \n\nThe LATF 2024/25 application is made up of an application form (available from https://www.gov.uk/guidance/local-authority-treescapes-fund) and the four worksheets in this workbook. You can view the worksheets by clicking the tabs at the bottom of this window, or by clicking the \"next tab\" buttons. When you have completed all the worksheets you will be able to see your \"cost per tree\" displayed in the 'Part 4 - Totals' tab.\n\nCompleting this workbook:\nThere are specific instructions for completing each worksheet. These are placed at the top of the worksheet, in a grey box like this one. \nYou should read the instructions before scrolling down or across to complete the required fields in the worksheet. \nIf you are viewing the form in Microsoft Excel, all mandatory fields will be highlighted in yellow until they are completed (this functionality may not be available if opening the form in other software). Fields that do not require input from you will be filled in grey and will be locked for editing. If the information that you submit in the LATF Application Form does not match the information that you submit in this workbook, values from this workbook will supercede the values in your LATF Application Form. The information in this workbook will form the basis of your agreement if your application is successful.\nIf you are paying for any of your trees through matched funding, please only include them on the 'Part 3 - Matched Funding' tab.  \n\nAgreement Length:\nYou may apply for either a one year agreement - where all planting must be completed within the financial year 2023/24. \n\nReturning the application form:\nIt is strongly preferred that you email this Project Cost Calculator, once completed, to LATF@forestrycommission.gov.uk\nPlease do not convert the file to .pdf or any other format before emailing. Please save your Cost Calculator with your Lead Local Authority Name and LATF Reference Number in the file name.                \nThis Project Cost Calculator should be submitted alongside your completed LATF Application Form.                                                                                                                                                                                                                        \nYou should only submit one Cost Calculator with your application - if you have multiple Cost Calculators (from various authorities) please combine into one where possible.  \n\nPrinting the application form:\nIf you wish to print this form, you will need to set your own print area for each of these worksheets by clicking on the 'Page Layout' tab at the top, selecting the area you wish to print, and clicking on 'Print Area' > 'Set Print Area'.\n\nHow we will use your information:\nWe are required to collect a number of personal details of the applicant (and, where relevant, the agent) in order to process your application. \nPlease see the LATF Application Form and LATF Guidance to Applicants for further information on how we will use your information. \n"]

{"sheet":"Part 1 - Tree Costs","index":1,"n_rows":136,"n_cols":10,"rows_kept":136,"cut":false,"hidden":false,"merged":[[69,1,69,2],[49,6,49,7],[50,6,50,7],[47,1,47,5],[25,2,25,3],[26,2,26,3],[29,1,29,5],[32,6,32,7],[31,6,31,7]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Lead Local Authority Name:"]
[null,"LATF Agreement Reference Number:"]
[]
[]
[null,"Table 1 - Year One Tree Costs (Trees Planted 2024/2025). This table must consist of at least 50% cost of your total planting.\nThe maintenance costs in this table should only relate to trees planted in FY 2024/2025."]
[]
[null,"A","B","C","D","E","F",null,"G","H"]
[null,"Item","Unit Type","Applicant's Cost \nPer Unit","Estimated Number of Units","Total estimated cost of item","FC standard cost (per unit)",null,"Total FC estimated cost ","Total estimated cost as a percentage of Total FC cost"]
[null,"E.g. Tree planting","Tree",1.5,250,{"$f":"IF(D34=\"\", \"AUTO\",D34*E34)","v":375},1.6,"/ tree",{"$f":"IF(D34=\"\",\"AUTO\",G34*E34)","v":400},{"$f":"IF(E34=\"\",\"AUTO\",F34/I34)","v":0.9375}]
[null,"Standard Trees (Planting 2024/25 Only)\nSize (Trunk Width 6-8cm up to 16-18cm)\n(For LATF, any standards planted in urban or peri-urban areas must be direct replacements.)","Tree",null,null,{"$f":"IF(D35=\"\", \"AUTO\",D35*E35)","v":"AUTO"},270.44,"/ tree",{"$f":"IF(D35=\"\",\"AUTO\",G35*E35)","v":"AUTO"},{"$f":"IFERROR(IF(E35=\"\",\"AUTO\",F35/I35),\"\")","v":"AUTO"}]
[null,"Standard Trees (Maintenance FY 2025/2026)","Tree",null,{"$f":"IF(E35=\"\",\"AUTO\",E35*1)","v":"AUTO"},{"$f":"IF(D36=\"\", \"AUTO\",D36*E36)","v":"AUTO"},189,"/ tree",{"$f":"IF(D36=\"\",\"AUTO\",G36*E36)","v":"AUTO"},{"$f":"IFERROR(IF(E36=\"AUTO\",\"AUTO\",F36/I36),\"\")","v":"AUTO"}]
[null,"Standard Trees (Maintenance FY 2026/2027)","Tree",{"$f":"IF(D36=\"\",\"AUTO\",D36*1)","v":"AUTO"},{"$f":"IF(E35=\"\",\"AUTO\",E35*1)","v":"AUTO"},{"$f":"IF(D37=\"AUTO\", \"AUTO\",D37*E37)","v":"AUTO"},189,"/ tree",{"$f":"IF(D37=\"AUTO\",\"AUTO\",G37*E37)","v":"AUTO"},{"$f":"IFERROR(IF(E37=\"AUTO\",\"AUTO\",F37/I37),\"\")","v":"AUTO"}]
[null,"Standard Trees (Maintenance FY 2027/2028)","Tree",{"$f":"IF(D36=\"\",\"AUTO\",D36*1)","v":"AUTO"},{"$f":"IF(E35=\"\",\"AUTO\",E35*1)","v":"AUTO"},{"$f":"IF(D38=\"AUTO\", \"AUTO\",D38*E38)","v":"AUTO"},189,"/ tree",{"$f":"IF(D38=\"AUTO\",\"AUTO\",G38*E38)","v":"AUTO"},{"$f":"IFERROR(IF(E38=\"AUTO\",\"AUTO\",F38/I38),\"\")","v":"AUTO"}]
[null,"Feathers (Planting 2024/25 Only)\nSize (Height Approx 150-175cm with side branches)","Tree",null,null,{"$f":"IF(D39=\"\", \"AUTO\",D39*E39)","v":"AUTO"},3.79,"/ tree",{"$f":"IF(D39=\"\",\"AUTO\",G39*E39)","v":"AUTO"},{"$f":"IFERROR(IF(E39=\"\",\"AUTO\",F39/I39),\"\")","v":"AUTO"}]
[null,"Feathers (Maintenance FY 2025/2026)","Tree",null,{"$f":"IF(E39=\"\",\"AUTO\",E39*1)","v":"AUTO"},{"$f":"IF(D40=\"\", \"AUTO\",D40*E40)","v":"AUTO"},0.14000000000000001,"/ tree",{"$f":"IF(D40=\"\",\"AUTO\",G40*E40)","v":"AUTO"},{"$f":"IFERROR(IF(E40=\"AUTO\",\"AUTO\",F40/I40),\"\")","v":"AUTO"}]
[null,"Feathers (Maintenance FY 2026/2027)","Tree",{"$f":"IF(D40=\"\",\"AUTO\",D40*1)","v":"AUTO"},{"$f":"IF(E39=\"\",\"AUTO\",E39*1)","v":"AUTO"},{"$f":"IF(D41=\"AUTO\", \"AUTO\",D41*E41)","v":"AUTO"},0.14000000000000001,"/ tree",{"$f":"IF(D41=\"AUTO\",\"AUTO\",G41*E41)","v":"AUTO"},{"$f":"IFERROR(IF(E41=\"AUTO\",\"AUTO\",F41/I41),\"\")","v":"AUTO"}]
[null,"Feathers (Maintenance FY 2027/2028)","Tree",{"$f":"IF(D40=\"\",\"AUTO\",D40*1)","v":"AUTO"},{"$f":"IF(E39=\"\",\"AUTO\",E39*1)","v":"AUTO"},{"$f":"IF(D42=\"AUTO\", \"AUTO\",D42*E42)","v":"AUTO"},0.14000000000000001,"/ tree",{"$f":"IF(D42=\"AUTO\",\"AUTO\",G42*E42)","v":"AUTO"},{"$f":"IFERROR(IF(E42=\"AUTO\",\"AUTO\",F42/I42),\"\")","v":"AUTO"}]
[null,"Whips (Planting 2024/25 Only)\nSize (Height Approx 100-125cm)","Tree",null,null,{"$f":"IF(D43=\"\", \"AUTO\",D43*E43)","v":"AUTO"},2.29,"/ tree",{"$f":"IF(D43=\"\",\"AUTO\",G43*E43)","v":"AUTO"},{"$f":"IFERROR(IF(E43=\"\",\"AUTO\",F43/I43),\"\")","v":"AUTO"}]
[null,"Whips (Maintenance FY 2025/2026)","Tree",null,{"$f":"IF(E43=\"\",\"AUTO\",E43*1)","v":"AUTO"},{"$f":"IF(D44=\"\", \"AUTO\",D44*E44)","v":"AUTO"},0.14000000000000001,"/ tree",{"$f":"IF(D44=\"\",\"AUTO\",G44*E44)","v":"AUTO"},{"$f":"IF(E44=\"AUTO\",\"AUTO\",F44/I44)","v":"AUTO"}]
[null,"Whips (Maintenance FY 2026/2027)","Tree",{"$f":"IF(D44=\"\",\"AUTO\",D44*1)","v":"AUTO"},{"$f":"IF(E43=\"\",\"AUTO\",E43*1)","v":"AUTO"},{"$f":"IF(D45=\"AUTO\", \"AUTO\",D45*E45)","v":"AUTO"},0.14000000000000001,"/ tree",{"$f":"IF(D45=\"AUTO\",\"AUTO\",G45*E45)","v":"AUTO"},{"$f":"IF(E45=\"AUTO\",\"AUTO\",F45/I45)","v":"AUTO"}]
[null,"Whips (Maintenance FY 2027/2028)","Tree",{"$f":"IF(D44=\"\",\"AUTO\",D44*1)","v":"AUTO"},{"$f":"IF(E43=\"\",\"AUTO\",E43*1)","v":"AUTO"},{"$f":"IF(D46=\"AUTO\", \"AUTO\",D46*E46)","v":"AUTO"},0.14000000000000001,"/ tree",{"$f":"IF(D46=\"AUTO\",\"AUTO\",G46*E46)","v":"AUTO"},"AUTO"]
[]
[null,"Table 2 - Year Two Tree Costs (Trees Planted FY 2025/2026). Only fill this table in if you are applying for a Two Year Agreement. \nThe maintenance costs in this table should only relate to trees planted in FY 2025/2026."]
[]
[null,"A","B","C","D","E","F",null,"G","H"]
[null,"Item","Unit Type","Applicant's Estimated Cost \nPer Unit","Estimated Number of Units","Total estimated cost of item","FC standard cost (per unit)",null,"Total FC estimated cost ","Total estimated cost as a percentage of Total FC cost"]
[null,"E.g. Tree planting","Tree",1.5,250,{"$f":"IF(D52=\"\", \"AUTO\",D52*E52)","v":375},1.6,"/ tree",{"$f":"IF(D52=\"\",\"AUTO\",G52*E52)","v":400},{"$f":"IF(E52=\"\",\"AUTO\",F52/I52)","v":0.9375}]
[null,"Standard Trees (Planting 2025/2026 Only)\nSize (Trunk Width 6-8cm up to 16-18cm)","Tree",null,null,{"$f":"IF(D53=\"\", \"AUTO\",D53*E53)","v":"AUTO"},270.44,"/ tree",{"$f":"IF(D53=\"\",\"AUTO\",G53*E53)","v":"AUTO"},{"$f":"IF(E53=\"\",\"AUTO\",F53/I53)","v":"AUTO"}]
[null,"Standard Trees (Maintenance FY 2026/2027)","Tree",null,{"$f":"IF(E53=\"\",\"AUTO\",E53*1)","v":"AUTO"},{"$f":"IF(D54=\"\", \"AUTO\",D54*E54)","v":"AUTO"},189,"/ tree",{"$f":"IF(D54=\"\",\"AUTO\",G54*E54)","v":"AUTO"},{"$f":"IF(E54=\"AUTO\",\"AUTO\",F54/I54)","v":"AUTO"}]
[null,"Standard Trees (Maintenance FY 2027/2028)","Tree",{"$f":"IF(D54=\"\",\"AUTO\",D54*1)","v":"AUTO"},{"$f":"IF(E53=\"\",\"AUTO\",E53*1)","v":"AUTO"},{"$f":"IF(D55=\"AUTO\", \"AUTO\",D55*E55)","v":"AUTO"},189,"/ tree",{"$f":"IF(D55=\"AUTO\",\"AUTO\",G55*E55)","v":"AUTO"},{"$f":"IF(E55=\"AUTO\",\"AUTO\",F55/I55)","v":"AUTO"}]
[null,"Standard Trees (Maintenance FY 2028/2029)","Tree",{"$f":"IF(D54=\"\",\"AUTO\",D54*1)","v":"AUTO"},{"$f":"IF(E53=\"\",\"AUTO\",E53*1)","v":"AUTO"},{"$f":"IF(D56=\"AUTO\", \"AUTO\",D56*E56)","v":"AUTO"},189,"/ tree",{"$f":"IF(D56=\"AUTO\",\"AUTO\",G56*E56)","v":"AUTO"},"AUTO"]
[null,"Feathers (Planting 2025/2026 Only)\nSize (Height Approx 150-175cm with side branches)","Tree",null,null,{"$f":"IF(D57=\"\", \"AUTO\",D57*E57)","v":"AUTO"},3.79,"/ tree",{"$f":"IF(D57=\"\",\"AUTO\",G57*E57)","v":"AUTO"},{"$f":"IF(E57=\"\",\"AUTO\",F57/I57)","v":"AUTO"}]
[null,"Feathers (Maintenance FY 2026/2027)","Tree",null,{"$f":"IF(E57=\"\",\"AUTO\",E57*1)","v":"AUTO"},{"$f":"IF(D58=\"\", \"AUTO\",D58*E58)","v":"AUTO"},0.14000000000000001,"/ tree",{"$f":"IF(D58=\"\",\"AUTO\",G58*E58)","v":"AUTO"},{"$f":"IF(E58=\"AUTO\",\"AUTO\",F58/I58)","v":"AUTO"}]
[null,"Feathers (Maintenance FY 2027/2028)","Tree",{"$f":"IF(D58=\"\",\"AUTO\",D58*1)","v":"AUTO"},{"$f":"IF(E57=\"\",\"AUTO\",E57*1)","v":"AUTO"},{"$f":"IF(D59=\"AUTO\", \"AUTO\",D59*E59)","v":"AUTO"},0.14000000000000001,"/ tree",{"$f":"IF(D59=\"AUTO\",\"AUTO\",G59*E59)","v":"AUTO"},{"$f":"IF(E59=\"AUTO\",\"AUTO\",F59/I59)","v":"AUTO"}]
[null,"Feathers (Maintenance FY 2028/2029)","Tree",{"$f":"IF(D58=\"\",\"AUTO\",D58*1)","v":"AUTO"},{"$f":"IF(E57=\"\",\"AUTO\",E57*1)","v":"AUTO"},{"$f":"IF(D60=\"AUTO\", \"AUTO\",D60*E60)","v":"AUTO"},0.14000000000000001,"/ tree",{"$f":"IF(D60=\"AUTO\",\"AUTO\",G60*E60)","v":"AUTO"},"AUTO"]
[null,"Whips (Planting 2025/2026 Only)\nSize (Height Approx 100-125cm)","Tree",null,null,{"$f":"IF(D61=\"\", \"AUTO\",D61*E61)","v":"AUTO"},2.29,"/ tree",{"$f":"IF(D61=\"\",\"AUTO\",G61*E61)","v":"AUTO"},"AUTO"]
[null,"Whips (Maintenance FY 2026/2027)","Tree",null,{"$f":"IF(E61=\"\",\"AUTO\",E61*1)","v":"AUTO"},{"$f":"IF(D62=\"\", \"AUTO\",D62*E62)","v":"AUTO"},0.14000000000000001,"/ tree",{"$f":"IF(D62=\"\",\"AUTO\",G62*E62)","v":"AUTO"},{"$f":"IF(E62=\"AUTO\",\"AUTO\",F62/I62)","v":"AUTO"}]
[null,"Whips (Maintenance FY 2027/2028)","Tree",{"$f":"IF(D62=\"\",\"AUTO\",D62*1)","v":"AUTO"},{"$f":"IF(E61=\"\",\"AUTO\",E61*1)","v":"AUTO"},{"$f":"IF(D63=\"AUTO\", \"AUTO\",D63*E63)","v":"AUTO"},0.14000000000000001,"/ tree",{"$f":"IF(D63=\"AUTO\",\"AUTO\",G63*E63)","v":"AUTO"},{"$f":"IF(E63=\"AUTO\",\"AUTO\",F63/I63)","v":"AUTO"}]
[null,"Whips (Maintenance FY 2028/2029)","Tree",{"$f":"IF(D62=\"\",\"AUTO\",D62*1)","v":"AUTO"},{"$f":"IF(E61=\"\",\"AUTO\",E61*1)","v":"AUTO"},{"$f":"IF(D64=\"AUTO\", \"AUTO\",D64*E64)","v":"AUTO"},0.14000000000000001,"/ tree",{"$f":"IF(D64=\"AUTO\",\"AUTO\",G64*E64)","v":"AUTO"},"AUTO"]
[]
[null,"Total Number of Trees to be planted 2024/25",{"$f":"SUM(E35,E39,E43)","v":0},null,"Total planting costs \n2024/25",{"$f":"SUM(F35,F39,F43)","v":0}]
[null,"Total Number of Trees to be planted 2025/26",{"$f":"SUM(E53,E57,E61)","v":0},null,"Total planting costs \n2025/26",{"$f":"SUM(F53,F57,F61)","v":0}]
[null,"Total Number of Trees (whole project)",{"$f":"SUM(C66:C67)","v":0},null,"Total maintenance costs \n2025/26",{"$f":"SUM(F36,F40,F44)","v":0}]
[null,null,null,null,"Total planting + maintenance costs 2025/26",{"$f":"SUM(F36,F40,F44,F53,F57,F61)","v":0}]
[null,null,null,null,"Total maintenance costs \n2026/27",{"$f":"SUM(F37,F41,F45,F54,F58,F62)","v":0}]
[null,null,null,null,"Total Project Tree Costs:",{"$f":"SUM(F35:F46,F53:F64)","v":0}]
[]
[null,null,null,null,"Total maintenance costs for 2027/28 for 2Year planting agreements:",{"$f":"SUM(F56,F60,F64)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"For a full breakdown of maintenance across all years, please see 'Part 4 - Totals'."]

{"sheet":"Part 2 - Other Capital Items ","index":2,"n_rows":71,"n_cols":11,"rows_kept":71,"cut":false,"hidden":false,"merged":[[70,1,70,2],[0,2,0,3],[1,2,1,3],[68,1,68,2],[69,1,69,2]]}
[null,"Lead Local Authority Name:",{"$f":"IF('Part 1 - Tree Costs'!C26=\"\",\"AUTO\",'Part 1 - Tree Costs'!$C$26)","v":"AUTO"}]
[null,"LATF Agreement Reference Number:",{"$f":"IF('Part 1 - Tree Costs'!C27=\"\",\"AUTO\",'Part 1 - Tree Costs'!$C$27)","v":"AUTO"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"))"]
[null,"Table 1 - Capital Costs FY 2024/25"]
[null,"Enter estimated costs for any capital items that you will use in FY 2024/25 only."]
[null,"A","B","C","D","E","F","G","H","J"]
[null,"Item","Natural Colonisation or Standard Planting Site","Unit Type\n(Please Complete if Entering Item, (Column A) Manually)","Applicant's Estimated Cost \nPer Unit","Estimated Number of Units","Total Estimated Cost of Item","FC Standard Cost\n Per Unit","Total FC Estimated cost ","Total Estimated Cost as a Percentage of Total FC Cost"]
[null,null,null,{"$f":"IF((B20)=\"Deer Fencing\",\"Metre\",IF((B20)=\"Sheep Netting\",\"Metre\",IF((B20)=\"Temporary Deer Fencing\",\"Metre\",IF((B20)=\"Rabbit Fencing\",\"Metre\",IF((B20)=\"Sheep Netting\",\"Metre\",IF((B20)=\"Stone Wall Top Netting\",\"Metre\",IF((B20)=\"Field Gates\",\"Gate\",IF((B20)=\"Badger Gates\",\"Gate\",IF((B20)=\"Deer Vehicle Gates\",\"Gate\",IF((B20)=\"Deer Pedestrian Gates\",\"Gate\",IF((B20)=\"Watering Bags\",\"Bag\",IF((B20)=\"Ground Preparation for Natural Colonisation\",\"Per Hectare\",\" \"))))))))))))","v":" "},null,null,{"$f":"IF(E20=\"\", \"AUTO\",E20*F20)","v":"AUTO"},{"$f":"IF((B20)=\"Deer Fencing\", 8.55,IF((B20)=\"Sheep Netting\", 6.13,IF((B20)=\"Temporary Deer Fencing\", 6.5,IF((B20)=\"Rabbit Fencing\", 3.13,IF((B20)=\"Sheep Netting\",4.5,IF((B20)=\"Stone Wall Top Netting\",4.5,IF((B20)=\"Field Gates\",168.75,IF((B20)=\"Badger Gates\", 430.76,IF((B20)=\"Deer Vehicle Gates\",430.76,IF((B20)=\"Deer Pedestrian Gates\",339.85,IF((B20)=\"Watering Bags\",\"24.40\",IF((B20)=\"Ground Preparation for Natural Colonisation\",121.86,\" \"))))))))))))","v":" "},{"$f":"IFERROR(IF(E20=\"\",\"AUTO\",H20*F20), \"AUTO\")","v":"AUTO"},{"$f":"IFERROR(IF(F20=\"\",\"AUTO\",G20/I20), \"AUTO\")","v":"AUTO"}]
[null,null,null,{"$f":"IF((B21)=\"Deer Fencing\",\"Metre\",IF((B21)=\"Sheep Netting\",\"Metre\",IF((B21)=\"Temporary Deer Fencing\",\"Metre\",IF((B21)=\"Rabbit Fencing\",\"Metre\",IF((B21)=\"Sheep Netting\",\"Metre\",IF((B21)=\"Stone Wall Top Netting\",\"Metre\",IF((B21)=\"Field Gates\",\"Gate\",IF((B21)=\"Badger Gates\",\"Gate\",IF((B21)=\"Deer Vehicle Gates\",\"Gate\",IF((B21)=\"Deer Pedestrian Gates\",\"Gate\",IF((B21)=\"Watering Bags\",\"Bag\",IF((B21)=\"Ground Preparation for Natural Colonisation\",\"Per Hectare\",\" \"))))))))))))","v":" "},null,null,"AUTO"," ",{"$f":"IFERROR(IF(E21=\"\",\"AUTO\",H21*F21), \"AUTO\")","v":"AUTO"},{"$f":"IFERROR(IF(F21=\"\",\"AUTO\",G21/I21), \"AUTO\")","v":"AUTO"}]
[null,null,null,{"$f":"IF((B22)=\"Deer Fencing\",\"Metre\",IF((B22)=\"Sheep Netting\",\"Metre\",IF((B22)=\"Temporary Deer Fencing\",\"Metre\",IF((B22)=\"Rabbit Fencing\",\"Metre\",IF((B22)=\"Sheep Netting\",\"Metre\",IF((B22)=\"Stone Wall Top Netting\",\"Metre\",IF((B22)=\"Field Gates\",\"Gate\",IF((B22)=\"Badger Gates\",\"Gate\",IF((B22)=\"Deer Vehicle Gates\",\"Gate\",IF((B22)=\"Deer Pedestrian Gates\",\"Gate\",IF((B22)=\"Watering Bags\",\"Bag\",IF((B22)=\"Ground Preparation for Natural Colonisation\",\"Per Hectare\",\" \"))))))))))))","v":" "},null,null,"AUTO"," ","AUTO","AUTO"]
[null,null,null," ",null,null,"AUTO"," ","AUTO","AUTO"]
[null,null,null," ",null,null,"AUTO"," ","AUTO","AUTO"]
[null,null,null," ",null,null,"AUTO"," ","AUTO","AUTO"]
[null,null,null," ",null,null,"AUTO"," ","AUTO","AUTO"]
[null,null,null," ",null,null,"AUTO"," ","AUTO","AUTO"]
[null,null,null," ",null,null,"AUTO"," ","AUTO","AUTO"]
[null,null,null," ",null,null,"AUTO"," ","AUTO","AUTO"]
[null,null,null," ",null,null,{"$f":"IF(E30=\"\", \"AUTO\",E30*F30)","v":"AUTO"}," ","AUTO","AUTO"]
[null,null,null," ",null,null,"AUTO"," ",{"$f":"IFERROR(IF(E31=\"\",\"AUTO\",H31*F31), \"AUTO\")","v":"AUTO"},{"$f":"IFERROR(IF(F31=\"\",\"AUTO\",G31/I31), \"AUTO\")","v":"AUTO"}]
[null,null,null," ",null,null,"AUTO"," ","AUTO","AUTO"]
[null,null,null,{"$f":"IF((B33)=\"Deer Fencing\",\"Metre\",IF((B33)=\"Sheep Netting\",\"Metre\",IF((B33)=\"Temporary Deer Fencing\",\"Metre\",IF((B33)=\"Rabbit Fencing\",\"Metre\",IF((B33)=\"Sheep Netting\",\"Metre\",IF((B33)=\"Stone Wall Top Netting\",\"Metre\",IF((B33)=\"Field Gates\",\"Gate\",IF((B33)=\"Badger Gates\",\"Gate\",IF((B33)=\"Deer Vehicle Gates\",\"Gate\",IF((B33)=\"Deer Pedestrian Gates\",\"Gate\",IF((B33)=\"Watering Bags\",\"Bag\",IF((B33)=\"Ground Preparation for Natural Colonisation\",\"Per Hectare\",\" \"))))))))))))","v":" "},null,null,"AUTO",{"$f":"IF((B33)=\"Deer Fencing\", 8.55,IF((B33)=\"Sheep Netting\", 6.13,IF((B33)=\"Temporary Deer Fencing\", 6.5,IF((B33)=\"Rabbit Fencing\", 3.13,IF((B33)=\"Sheep Netting\",4.5,IF((B33)=\"Stone Wall Top Netting\",4.5,IF((B33)=\"Field Gates\",168.75,IF((B33)=\"Badger Gates\", 430.76,IF((B33)=\"Deer Vehicle Gates\",430.76,IF((B33)=\"Deer Pedestrian Gates\",339.85,IF((B33)=\"Watering Bags\",\"24.40\",IF((B33)=\"Ground Preparation for Natural Colonisation\",121.86,\" \"))))))))))))","v":" "},"AUTO","AUTO"]
[null,null,null," ",null,null,"AUTO"," ","AUTO","AUTO"]
[null,null,null," ",null,null,"AUTO"," ","AUTO","AUTO"]
[null,null,null," ",null,null,"AUTO"," ","AUTO","AUTO"]
[null,null,null," ",null,null,"AUTO"," ","AUTO","AUTO"]
[null,null,null," ",null,null,"AUTO"," ","AUTO","AUTO"]
[null,null,null,{"$f":"IF((B39)=\"Deer Fencing\",\"Metre\",IF((B39)=\"Sheep Netting\",\"Metre\",IF((B39)=\"Temporary Deer Fencing\",\"Metre\",IF((B39)=\"Rabbit Fencing\",\"Metre\",IF((B39)=\"Sheep Netting\",\"Metre\",IF((B39)=\"Stone Wall Top Netting\",\"Metre\",IF((B39)=\"Field Gates\",\"Gate\",IF((B39)=\"Badger Gates\",\"Gate\",IF((B39)=\"Deer Vehicle Gates\",\"Gate\",IF((B39)=\"Deer Pedestrian Gates\",\"Gate\",IF((B39)=\"Watering Bags\",\"Bag\",IF((B39)=\"Ground Preparation for Natural Colonisation\",\"Per Hectare\",\" \"))))))))))))","v":" "},null,null,{"$f":"IF(E39=\"\", \"AUTO\",E39*F39)","v":"AUTO"},{"$f":"IF((B39)=\"Deer Fencing\", 8.55,IF((B39)=\"Sheep Netting\", 6.13,IF((B39)=\"Temporary Deer Fencing\", 6.5,IF((B39)=\"Rabbit Fencing\", 3.13,IF((B39)=\"Sheep Netting\",4.5,IF((B39)=\"Stone Wall Top Netting\",4.5,IF((B39)=\"Field Gates\",168.75,IF((B39)=\"Badger Gates\", 430.76,IF((B39)=\"Deer Vehicle Gates\",430.76,IF((B39)=\"Deer Pedestrian Gates\",339.85,IF((B39)=\"Watering Bags\",\"24.40\",IF((B39)=\"Ground Preparation for Natural Colonisation\",121.86,\" \"))))))))))))","v":" "},{"$f":"IFERROR(IF(E39=\"\",\"AUTO\",H39*F39), \"AUTO\")","v":"AUTO"},{"$f":"IFERROR(IF(F39=\"\",\"AUTO\",G39/I39), \"AUTO\")","v":"AUTO"}]
[]
[]
[]
[]
[]
[]
[null,"Table 2 - Capital Costs 2025/26"]
[null,"Enter estimated costs for any capital items that you will use to help you plant trees in FY 2025/26 only. "]
[null,"A","B","C","D","E","F","G","H","J"]
[null,"Item","Natural Colonisation or Standard Planting Site","Unit Type\n(please complete if entering Item, (column A) manually)","Applicant's Estimated Cost \nPer Unit","Estimated Number of Units","Total estimated cost of item","FC Standard Cost\n Per Unit","Total FC estimated cost ","Total estimated cost as a percentage of Total FC cost"]
[null,null,null,{"$f":"IF((B50)=\"Deer Fencing\",\"Metre\",IF((B50)=\"Sheep Netting\",\"Metre\",IF((B50)=\"Temporary Deer Fencing\",\"Metre\",IF((B50)=\"Rabbit Fencing\",\"Metre\",IF((B50)=\"Sheep Netting\",\"Metre\",IF((B50)=\"Stone Wall Top Netting\",\"Metre\",IF((B50)=\"Field Gates\",\"Gate\",IF((B50)=\"Badger Gates\",\"Gate\",IF((B50)=\"Deer Vehicle Gates\",\"Gate\",IF((B50)=\"Deer Pedestrian Gates\",\"Gate\",IF((B50)=\"Watering Bags\",\"Bag\",IF((B50)=\"Ground Preparation for Natural Colonisation\",\"Per Hectare\",\" \"))))))))))))","v":" "},null,null,{"$f":"IF(E50=\"\", \"AUTO\", E50*F50)","v":"AUTO"},{"$f":"IF((B50)=\"Deer Fencing\", 8.55,IF((B50)=\"Sheep Netting\", 6.13,IF((B50)=\"Temporary Deer Fencing\", 6.5,IF((B50)=\"Rabbit Fencing\", 3.13,IF((B50)=\"Sheep Netting\",4.5,IF((B50)=\"Stone Wall Top Netting\",4.5,IF((B50)=\"Field Gates\",168.75,IF((B50)=\"Badger Gates\", 430.76,IF((B50)=\"Deer Vehicle Gates\",430.76,IF((B50)=\"Deer Pedestrian Gates\",339.85,IF((B50)=\"Watering Bags\",\"24.40\",IF((B50)=\"Ground Preparation for Natural Colonisation\",121.86,\" \"))))))))))))","v":" "},{"$f":"IFERROR(IF(E50=\"\",\"AUTO\",H50*F50), \"AUTO\")","v":"AUTO"},{"$f":"IFERROR(IF(F50=\"\",\"AUTO\",G50/I50), \"AUTO\")","v":"AUTO"}]
[null,null,null," ",null,null,"AUTO"," ",{"$f":"IFERROR(IF(E51=\"\",\"AUTO\",H51*F51), \"AUTO\")","v":"AUTO"},{"$f":"IFERROR(IF(F51=\"\",\"AUTO\",G51/I51), \"AUTO\")","v":"AUTO"}]
[null,null,null," ",null,null,"AUTO"," ","AUTO","AUTO"]
[null,null,null," ",null,null,"AUTO"," ","AUTO","AUTO"]
[null,null,null," ",null,null,"AUTO"," ","AUTO","AUTO"]
[null,null,null," ",null,null,"AUTO"," ","AUTO","AUTO"]
[null,null,null," ",null,null,"AUTO"," ","AUTO","AUTO"]
[null,null,null," ",null,null,"AUTO"," ","AUTO","AUTO"]
[null,null,null," ",null,null,"AUTO"," ","AUTO","AUTO"]
[null,null,null," ",null,null,"AUTO"," ","AUTO","AUTO"]
[null,null,null," ",null,null,"AUTO"," ","AUTO","AUTO"]
[null,null,null," ",null,null,"AUTO"," ",{"$f":"IFERROR(IF(E61=\"\",\"AUTO\",H61*F61), \"AUTO\")","v":"AUTO"},{"$f":"IFERROR(IF(F61=\"\",\"AUTO\",G61/I61), \"AUTO\")","v":"AUTO"}]
[null,null,null,{"$f":"IF((B62)=\"Deer Fencing\",\"Metre\",IF((B62)=\"Sheep Netting\",\"Metre\",IF((B62)=\"Temporary Deer Fencing\",\"Metre\",IF((B62)=\"Rabbit Fencing\",\"Metre\",IF((B62)=\"Sheep Netting\",\"Metre\",IF((B62)=\"Stone Wall Top Netting\",\"Metre\",IF((B62)=\"Field Gates\",\"Gate\",IF((B62)=\"Badger Gates\",\"Gate\",IF((B62)=\"Deer Vehicle Gates\",\"Gate\",IF((B62)=\"Deer Pedestrian Gates\",\"Gate\",IF((B62)=\"Watering Bags\",\"Bag\",IF((B62)=\"Ground Preparation for Natural Colonisation\",\"Per Hectare\",\" \"))))))))))))","v":" "},null,null,{"$f":"IF(E62=\"\", \"AUTO\", E62*F62)","v":"AUTO"},{"$f":"IF((B62)=\"Deer Fencing\", 8.55,IF((B62)=\"Sheep Netting\", 6.13,IF((B62)=\"Temporary Deer Fencing\", 6.5,IF((B62)=\"Rabbit Fencing\", 3.13,IF((B62)=\"Sheep Netting\",4.5,IF((B62)=\"Stone Wall Top Netting\",4.5,IF((B62)=\"Field Gates\",168.75,IF((B62)=\"Badger Gates\", 430.76,IF((B62)=\"Deer Vehicle Gates\",430.76,IF((B62)=\"Deer Pedestrian Gates\",339.85,IF((B62)=\"Watering Bags\",\"24.40\",IF((B62)=\"Ground Preparation for Natural Colonisation\",121.86,\" \"))))))))))))","v":" "},{"$f":"IFERROR(IF(E62=\"\",\"AUTO\",H62*F62), \"AUTO\")","v":"AUTO"},{"$f":"IFERROR(IF(F62=\"\",\"AUTO\",G62/I62), \"AUTO\")","v":"AUTO"}]
[null,null,null,{"$f":"IF((B63)=\"Deer Fencing\",\"Metre\",IF((B63)=\"Sheep Netting\",\"Metre\",IF((B63)=\"Temporary Deer Fencing\",\"Metre\",IF((B63)=\"Rabbit Fencing\",\"Metre\",IF((B63)=\"Sheep Netting\",\"Metre\",IF((B63)=\"Stone Wall Top Netting\",\"Metre\",IF((B63)=\"Field Gates\",\"Gate\",IF((B63)=\"Badger Gates\",\"Gate\",IF((B63)=\"Deer Vehicle Gates\",\"Gate\",IF((B63)=\"Deer Pedestrian Gates\",\"Gate\",IF((B63)=\"Watering Bags\",\"Bag\",IF((B63)=\"Ground Preparation for Natural Colonisation\",\"Per Hectare\",\" \"))))))))))))","v":" "},null,null,{"$f":"IF(E63=\"\", \"AUTO\", E63*F63)","v":"AUTO"},{"$f":"IF((B63)=\"Deer Fencing\", 8.55,IF((B63)=\"Sheep Netting\", 6.13,IF((B63)=\"Temporary Deer Fencing\", 6.5,IF((B63)=\"Rabbit Fencing\", 3.13,IF((B63)=\"Sheep Netting\",4.5,IF((B63)=\"Stone Wall Top Netting\",4.5,IF((B63)=\"Field Gates\",168.75,IF((B63)=\"Badger Gates\", 430.76,IF((B63)=\"Deer Vehicle Gates\",430.76,IF((B63)=\"Deer Pedestrian Gates\",339.85,IF((B63)=\"Watering Bags\",\"24.40\",IF((B63)=\"Ground Preparation for Natural Colonisation\",121.86,\" \"))))))))))))","v":" "},{"$f":"IFERROR(IF(E63=\"\",\"AUTO\",H63*F63), \"AUTO\")","v":"AUTO"},{"$f":"IFERROR(IF(F63=\"\",\"AUTO\",G63/I63), \"AUTO\")","v":"AUTO"}]
[]
[]
[]
[]
[]
[null,"Total Cost of Capital Items 2024/25",null,{"$f":"SUM(Table1[Total Estimated Cost of Item])","v":0}]
[null,"Total Cost of Capital Items 2025/26",null,{"$f":"SUM(Table2[Total estimated cost of item])","v":0}]
[null,"Total Cost of Capital Items - Both Years",null,{"$f":"SUM(D69:D70)","v":0}]

{"sheet":"Part 3 - Match Funding","index":3,"n_rows":63,"n_cols":8,"rows_kept":63,"cut":false,"hidden":false,"merged":[[39,1,39,2],[38,1,38,7],[34,5,34,6],[33,5,33,6],[62,6,62,7],[63,3,63,5],[35,5,35,6],[25,5,25,6],[29,5,29,6],[30,5,30,6],[32,5,32,6],[3,1,3,6],[20,5,20,6],[31,5,31,6],[0,2,0,3],[1,2,1,3],[18,5,18,6],[19,1,19,2],[26,5,26,6],[27,5,27,6],[15,1,15,7],[21,5,21,6],[22,5,22,6],[23,5,23,6],[24,5,24,6],[28,5,28,6]]}
[null,"Lead Local Authority Name:",{"$f":"IF('Part 1 - Tree Costs'!C26=\"\",\"AUTO\",'Part 1 - Tree Costs'!$C$26)","v":"AUTO"}]
[null,"LATF Agreement Reference Number:",{"$f":"IF('Part 1 - Tree Costs'!C27=\"\",\"AUTO\",'Part 1 - Tree Costs'!$C$27)","v":"AUTO"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Table 1 - Monetary Contributions (All Years)"]
[null,"A","B","C","D","E",null,"F"]
[null,"Source of Funding","Amount Contributed","Funding confirmation received","Type of funding","Briefly describe what the funding will be used for",null,"Briefly detail any conditions attached to this contribution"]
[null,"EG: Trees for Cities",5000,"Yes","Private Finance","EG: Community consultation meeting and building a web page to recruit volunteers to help with maintenance.",null,"EG: Trees for Cities branding on website"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Table 2 - Contributions in Kind (All Years)"]
[null,"A","B","C","D","E","F"]
[null,"Source of Contribution","Item","Unit Type","Value of contribution \nper unit","Number of units","Total value of contribution"]
[null,"EG: Friends of Leafy Park","EG: Volunteer Tree Planting","EG: Hour",10,60,{"$f":"IF(F43=\"\",\"AUTO\",F43*E43)","v":600}]
[null,"EG: Fred's Garden Centre","EG: Donated Spades","EG: Spade",20,10,200]
[null,null,null,null,null,null,"AUTO"]
[null,null,null,null,null,null,"AUTO"]
[null,null,null,null,null,null,"AUTO"]
[null,null,null,null,null,null,"AUTO"]
[null,null,null,null,null,null,"AUTO"]
[null,null,null,null,null,null,"AUTO"]
[null,null,null,null,null,null,"AUTO"]
[null,null,null,null,null,null,"AUTO"]
[null,null,null,null,null,null,"AUTO"]
[null,null,null,null,null,null,"AUTO"]
[null,null,null,null,null,null,"AUTO"]
[null,null,null,null,null,null,"AUTO"]
[null,null,null,null,null,null,"AUTO"]
[null,null,null,null,null,null,"AUTO"]
[]
[null,"Total Monetary Contributions",{"$f":"SUM(C24:C36)","v":0}]
[null,"Total Value of Contributions in Kind",{"$f":"SUM(G45:G58)","v":0}]
[null,"Total Match Funding (Total Monetary Contributions + Total Value of Contributions in Kind)",{"$f":"C60+C61","v":0}]
[null,"Total Match Funding as a % of LATF Proposed Agreement Value",{"$f":"'Part 4 - Totals'!D7/'Part 4 - Totals'!D13","v":{"$error":"#DIV/0!"}}]

{"sheet":"Part 4 - Totals","index":4,"n_rows":31,"n_cols":8,"rows_kept":31,"cut":false,"hidden":false,"merged":[[0,2,0,3],[1,2,1,3],[20,1,20,2],[4,1,4,2],[19,1,19,2],[3,1,3,2],[10,1,10,2],[13,1,13,2],[9,1,9,2],[12,1,12,2],[8,1,8,2],[6,1,6,2]]}
[null,"Lead Local Authority Name:",{"$f":"IF('Part 1 - Tree Costs'!C26=\"\",\"AUTO\",'Part 1 - Tree Costs'!$C$26)","v":"AUTO"}]
[null,"LATF Agreement Reference Number:",{"$f":"IF('Part 1 - Tree Costs'!C27=\"\",\"AUTO\",'Part 1 - Tree Costs'!$C$27)","v":"AUTO"}]
[]
[null,"Total Tree Costs (Including Maintenance):",null,{"$f":"'Part 1 - Tree Costs'!F71","v":0}]
[null,"Total Capital Costs:",null,{"$f":"'Part 2 - Other Capital Items '!D71","v":0}]
[]
[null,"Total Value of Match Funding:",null,{"$f":"'Part 3 - Match Funding'!C62","v":0}]
[]
[null,"Total Project Costs (Total LATF Proposed Agreement Value + Total Value of Match Funding):",null,{"$f":"SUM(D4:D5,D7)","v":0}]
[null,"Number of Trees to be planted",null,{"$f":"'Part 1 - Tree Costs'!C68","v":0}]
[null,"Total Cost Per Tree to be planted planted",null,{"$f":"IFERROR(D9/D10,0)","v":0}]
[]
[null,"Total LATF Proposed Agreement Value (must be greater than £50,000):",null,{"$f":"D4+D5","v":0}]
[null,"Total LATF Cost Per Tree",null,{"$f":"IFERROR(D13/D10,0)","v":0}]
[]
[null,"Breakdown of Agreement Value by Year"]
[null,"2024/25","2025/26","2026/27","2027/28"]
[null,{"$f":"'Part 1 - Tree Costs'!F66 + 'Part 2 - Other Capital Items '!D69","v":0},{"$f":"'Part 1 - Tree Costs'!F69 + 'Part 2 - Other Capital Items '!D70","v":0},{"$f":"'Part 1 - Tree Costs'!F70","v":0},{"$f":"D18","v":0}]
[]
[null,"Breakdown of Agreement Value by Claim"]
[null,"2024/25",null,"2025/26","2026/27","2027/28",null,"2028/29"]
[null,"Pre-Planting Claim 1 \n(Acceptance of Offer)","Post-Planting Claim 2 \n(March 2025)","Maintenance Claim 1\n(March 2026)","Maintenance Claim 2\n(March 2027)","Maintenance Claim 3 \n(March 2028)",null,"Claim 7\n(March 2029)"]
[null,{"$f":"B18/2","v":0},{"$f":"B18/2","v":0},{"$f":"(('Part 1 - Tree Costs'!F67+'Part 2 - Other Capital Items '!D70)/2) +'Part 1 - Tree Costs'!F68","v":0},{"$f":"D18","v":0},{"$f":"E18","v":0},null,{"$f":"F18","v":0}]
[null,"Upfront payment - 50% of planting costs and capital items for 2024/25 planting","Remainder of 2024/25 planting costs and capital item","Maintenance payment for trees planted 2024/25.\n\n","Maintenance payment for trees planted 2024/25","Maintenance payment for trees planted 2024/25",null,"Remaining maintenance payment for trees planted 2025/26 (Applicable if two year planting period)"]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"Next Tab\n\"Part 4 - Totals\""]

{"sheet":"Dropdowns HIDDEN","index":5,"n_rows":5,"n_cols":4,"rows_kept":5,"cut":false,"hidden":true,"merged":[]}
["Yes","Yes","High","UTCF Priority Places "]
["No - INELIGIBLE","No","Medium","Blueskies National Tree Map"]
[null,null,"Low","Proximitree"]
[null,null,"N/A","i-Tree Eco"]
[null,null,null,"i-Tree Canopy"]

{"sheet":"Costs HIDDEN","index":6,"n_rows":4,"n_cols":8,"rows_kept":4,"cut":false,"hidden":true,"merged":[]}
["FOUR INSTALMENTS","Capital","%","Establishment (x1)","%","Establishment (x3)","%","Total"]
["Standard",135.22999999999999,0.32295273804121982,94.5,0.22568242065292671,{"$f":"D2*3","v":283.5},0.67704726195878007,{"$f":"SUM(B2,F2)","v":418.73}]
["Feather",1.69,0.88947368421052631,7.0000000000000007E-2,3.6842105263157898E-2,{"$f":"D3*3","v":0.21000000000000002},0.11052631578947369,{"$f":"SUM(B3,F3)","v":1.9}]
["Whip",0.94,0.81739130434782614,7.0000000000000007E-2,6.0869565217391314E-2,{"$f":"D4*3","v":0.21000000000000002},0.18260869565217394,{"$f":"SUM(B4,F4)","v":1.1499999999999999}]