{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Guidance","Project Costs Table","Example Table"],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":0,"defined_names":0,"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":"Guidance","index":0,"n_rows":50,"n_cols":1,"rows_kept":50,"cut":false,"hidden":false,"merged":[]}
["Farming in Protected Landscapes - Application Template - Annex A: Project Costs Table - Guidance"]
[]
["You must discuss the project and seek support from your Farming in Protected Landscapes officer to complete Annex A."]
[]
["Completing Manually"]
["Please print and complete all fields in the \"Project Costs Table\" and submit with your application form to your Protected Landscapes officer."]
["To add new rows, please follow the instructions in the \"To add new rows in Project Costs Table\" section."]
[]
["Completing Electronically"]
["Please complete all fields in the \"Project Costs Table.\""]
["Data will be autopopulated in the following fields. Please do not amend the formulae in these columns and fields:\n\nColumn O: \"Total Item/ Activity Cost (£)\"\nColumn R: \"Total FiPL Grant Request (£)\"\nTotals (not including Match Funding and Applicant Contribution). "]
[]
["To add new rows, please follow the instructions in the \"To add new rows in Project Costs Table\" section."]
[]
["Notes"]
[]
["All years refer to Financial Years.  The FiPL Grant Request amounts entered should be what the applicant will receive in those years only."]
["Your Farming in Protected Landscapes officer will be able to advise on the payment and intervention rates for each item."]
["The total Match Funding, Total Grant Request and Total Cost of Project must also be entered onto the Application Template (in \"Project Cost Summary\" table)."]
[]
["Match funding applies to third party funding only and does not include any contribution of your own funds to the project. "]
[]
["VAT"]
[]
["If you are able to reclaim VAT from HMRC, please exclude VAT from the figures given in this project costs section and Annex A."]
[" "]
["If you are not VAT registered, you will be able to include VAT in the project costs and your grant request, but you must complete Annex B (Not Registered for VAT Form) and include as part of your application."]
[]
["Table Column Notes "]
[]
["For \"Location Reference\" column:"]
["please ensure these details are captured on the Application Template map."]
[]
["For \"FiPL Payment Basis\" column: "]
["Where an activity has a CS equivalent, costs must be at the same payment rate and the same intervention rate.   For these project activities, please complete the \"Standard Payment Rate Items\" columns as labelled in the table."]
["Where an activity does not have a CS equivalent, project costs can be on an actual cost basis using comparative quotes or benchmarked comparisons. If you select \"Actual Cost\", please complete the \"Actual Cost Rate\" columns and detail the quotes or benchmarked costs in Columns V-X."]
[]
["For \"Unit of Measurement\" column:"]
["Please enter the relevant unit of measurement applicable to your project activity, using abbreviations where possible e.g. metres shown as \"m\", hectares as \"ha\""]
[]
["To add new rows in Project Costs Table"]
[]
["1. Highlight the last activity row in the Project Costs table \ni.e. in the row with the  \"+\" sign, hover over the Excel row number to the left of the table (in the \"Example\" table, this is row 35).  \nA small right-pointing arrow will appear - click once to highlight the row."]
[]
["2. Go to \"Home\" in the Excel ribbon"]
["3. In the \"Cells\" section, click on the \"Insert\" icon"]
[]
[]
[]
["4. A new row will appear on top of the \"+\" sign row.  Please note you will need to manually add an \"Item/Activity #\" for this row."]

{"sheet":"Project Costs Table","index":1,"n_rows":40,"n_cols":23,"rows_kept":40,"cut":false,"hidden":false,"merged":[[39,0,39,16],[38,0,38,16],[36,0,36,16],[35,0,35,11],[2,18,2,21],[2,5,2,6],[2,7,2,8],[2,10,2,11],[2,12,2,13],[2,15,2,16],[37,0,37,16]]}
["Farming in Protected Landscapes - Application Template - Annex A: Project Costs Table"]
["Please read the \"Guidance\" section before completing the table."]
[null,null,null,null,null,"* payment rates as advised by:",null,"[insert PL officer name]",null,null,"Quantity",null,"Cost (£)",null,null,"FiPL Grant Request (£)",null,null,"Actual Cost Quotes\n(Actual cost items only. If not applicable, please leave blank)"]
["Item / Activity #","Location Reference - e.g. parcel ID, SBI number, postcode, name of field","Description of Item/ Activity","Capital / Revenue","FiPL Payment Basis*","FiPL Payment Rate Code*\n- standard payment rate items only","FiPL Payment Rate Value (£) *\n- standard payment rate items only","FiPL Intervention Rate (%)*\n- actual cost items only","FiPL Quantity","Unit of Measurement","Quantity - 2023/24","Quantity - 2024/25","Cost - 2023/24","Cost - 2024/25","Total Item/ Activity \nCost (£)","FiPL Grant Request (£) - 2023/24","FiPL Grant Request (£) - 2024/25","Total FiPL Grant Request (£)","Quote 1 \n(quote chosen for project activity) (£)","Quote 2 (£)","Quote 3 (£)","Rationale for the specification chosen and costs","Additional Notes for Project Activity"]
[1,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF((SUM(M5:N5))=0,\"\",SUM(M5:N5))","v":""},null,null,{"$f":"IF((SUM(P5:Q5))=0,\"\",SUM(P5:Q5))","v":""}]
[2,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF((SUM(M6:N6))=0,\"\",SUM(M6:N6))","v":""},null,null,{"$f":"IF((SUM(P6:Q6))=0,\"\",SUM(P6:Q6))","v":""}]
[3,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,""]
[4,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,""]
[5,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,""]
[6,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,""]
[7,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,""]
[8,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,""]
[9,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,""]
[10,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,""]
[11,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,""]
[12,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,""]
[13,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,""]
[14,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,""]
[15,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,""]
[16,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,""]
[17,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,""]
[18,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,""]
[19,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,""]
[20,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,""]
[21,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,""]
[22,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,""]
[23,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,""]
[24,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,""]
[25,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,""]
[26,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,""]
[27,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,""]
[28,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,""]
[29,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,""]
[30,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,""]
["+",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,""]
["Totals (£)",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF((SUM(M5:M35))=0,\"\",SUM(M5:M35))","v":""},{"$f":"IF((SUM(N5:N35))=0,\"\",SUM(N5:N35))","v":""},"","","",""]
["Total Applicant Contribution to Project (£)"]
["Total Match Funding (£)"]
["Total FiPL Grant Request (total amount of funding you are applying for) (£)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"R36","v":""}]
["Total cost of project (£)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"O36","v":""}]

{"sheet":"Example Table","index":2,"n_rows":40,"n_cols":23,"rows_kept":40,"cut":false,"hidden":false,"merged":[[2,18,2,21],[35,0,35,11],[36,0,36,16],[38,0,38,16],[39,0,39,16],[2,10,2,11],[2,12,2,13],[2,15,2,16],[37,0,37,16],[2,5,2,6],[2,7,2,8]]}
["Farming in Protected Landscapes - Application Template - Annex A: Project Costs Table - Completed Examples"]
["Please read the \"Guidance\" section before completing the table."]
[null,null,null,null,null,"* payment rates as advised by:",null,"P.Landscape",null,null,"Quantity",null,"Cost (£)",null,null,"FiPL Grant Request (£)",null,null,"Actual Cost Quotes\n(Actual cost items only. If not applicable, please leave blank)"]
["Item / Activity #","Location Reference - e.g. parcel ID, postcode, name of field","Description of Item/ Activity","Capital / Revenue","FiPL Payment Basis*","FiPL Payment Rate Code*\n- standard payment rate items only","FiPL Payment Rate Value (£) *\n- standard payment rate items only","FiPL Intervention Rate (%)*\n- actual cost items only","FiPL Quantity","Unit of Measurement","Quantity - 2023/24","Quantity - 2024/25","Cost - 2023/24","Cost - 2024/25","Total Item/ Activity \nCost (£)","FiPL Grant Request (£) - 2023/24","FiPL Grant Request (£) - 2024/25","Total FiPL Grant Request (£)","Quote 1 \n(quote chosen for project activity) (£)","Quote 2 (£)","Quote 3 (£)","Rationale for the specification chosen and costs","Additional Notes for Project Activity"]
[1,"AB12345678","Tree planting","Cap","CS rate","TE2",24,"N/A",3,"m/ ha/ no.",2,1,150,100,{"$f":"IF((SUM(M5:N5))=0, \"\",SUM(M5:N5))","v":250},150,100,{"$f":"IF((SUM(P5:Q5))=0, \"\",SUM(P5:Q5))","v":250}]
[2,"X monument, Y Hill","Interpretation panel","Cap","Actual Cost","N/A","N/A",0.8,1,"unit",1,0,5000,0,{"$f":"IF((SUM(M6:N6))=0, \"\",SUM(M6:N6))","v":5000},4000,0,4000,5000,5600,5700,"Local supplier presenting best value for money."]
[3,"AB12345678","species rich grass mgmt","Rev","CS rate","GS6",182,"N/A",2,"ha",2,2,364,364,728,364,364,728]
[4,"AB12345678","Fencing","Cap","CS rate","FG2",4.9000000000000004,"N/A",200,"m",100,100,490,490,980,490,490,980]
[5,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF((SUM(M9:N9))=0, \"\",SUM(M9:N9))","v":""},null,null,""]
[6,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,""]
[7,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,""]
[8,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,""]
[9,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,""]
[10,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,""]
[11,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,""]
[12,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,""]
[13,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,""]
[14,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,""]
[15]
[16]
[17]
[18]
[19]
[20]
[21]
[22]
[23]
[24]
[25,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF((SUM(M29:N29))=0, \"\",SUM(M29:N29))","v":""},null,null,{"$f":"IF((SUM(P29:Q29))=0, \"\",SUM(P29:Q29))","v":""}]
[26,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF((SUM(M30:N30))=0, \"\",SUM(M30:N30))","v":""},null,null,{"$f":"IF((SUM(P30:Q30))=0, \"\",SUM(P30:Q30))","v":""}]
[27,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF((SUM(M31:N31))=0, \"\",SUM(M31:N31))","v":""},null,null,{"$f":"IF((SUM(P31:Q31))=0, \"\",SUM(P31:Q31))","v":""}]
[28,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF((SUM(M32:N32))=0, \"\",SUM(M32:N32))","v":""},null,null,{"$f":"IF((SUM(P32:Q32))=0, \"\",SUM(P32:Q32))","v":""}]
[29]
[30]
["+",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF((SUM(M35:N35))=0, \"\",SUM(M35:N35))","v":""},null,null,{"$f":"IF((SUM(P35:Q35))=0, \"\",SUM(P35:Q35))","v":""}]
["Totals (£)",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF((SUM(M5:M35))=0, \"\",SUM(M5:M35))","v":6004},{"$f":"IF((SUM(N5:N35))=0, \"\",SUM(N5:N35))","v":954},6958,5004,954,5958]
["Total Applicant Contribution to Project (£)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1000]
["Total Match Funding (£)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Total FiPL Grant Request (total amount of funding you are applying for) (£)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"R36","v":5958}]
["Total cost of project (£)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"O36","v":6958}]