{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["WC Single Year Blank Template","WC Multiple Year Blank Template","Guidance WC Template","Example WC Single Year","Example WC Multiple Year"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"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":"WC Single Year Blank Template","index":0,"n_rows":36,"n_cols":19,"rows_kept":36,"cut":false,"hidden":false,"merged":[[2,0,2,1],[0,0,0,9],[1,0,1,9],[2,4,2,5],[4,0,4,1],[2,2,2,3],[4,2,4,3],[2,6,2,9],[4,4,4,6],[4,7,4,9],[7,1,7,2],[6,1,6,2],[8,1,8,2],[9,1,9,2],[12,1,12,2],[13,1,13,2],[14,1,14,2],[8,8,14,8],[15,1,15,2],[16,1,16,2],[16,8,22,8],[29,1,29,2],[17,1,17,2],[20,1,20,2],[21,1,21,2],[19,1,19,2],[22,1,22,2],[23,1,23,2],[24,1,24,2],[25,1,25,2],[28,1,28,2],[30,1,30,2],[31,1,31,2],[32,1,32,2],[33,1,33,2],[35,1,35,2],[34,1,34,2],[24,8,30,8],[23,3,23,7],[15,3,15,7],[32,9,35,9],[34,3,34,4],[35,3,35,7],[33,6,33,7],[34,6,34,7],[31,3,31,7],[32,3,32,7],[33,3,33,4]]}
["TABLE - WOODLAND CREATION COMPONENT AREAS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Woodland Creation Option"]
["This table is to be completed by the Applicant at the Application and Claim Stage. A separate Component Areas table is required for each Land Parcel / woodland block. Guidance for completing this table, and an example, can be found on the other worksheets listed (see the tabs at the bottom of the workbook).",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Conifer"]
["BRN:",null,null,null,"Location Code:",null,null,null,null,null,null,null,null,null,null,null,null,null,"Diverse Conifer"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Broadleaves"]
["Application Name:",null,null,null,"Land Parcel Identifier (LPID)\nOR \nIndividual Woodland Name:",null,null,null,null,null,null,null,null,null,null,null,null,null,"Native Scots Pine"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Native Upland Birch"]
[null,1,null,2,3,4,5,6,7,8,null,null,null,null,null,null,null,null,"Native Broadleaves"]
[null,"Woodland Creation Option",null,"Map identifier(s)","Claim Year","Planted Species","Stocking density (stems/ha)","Component Area (ha)","Total (ha)","% Component",null,null,null,null,null,null,null,null,"Native Low-density Broadleaves"]
[null,"Woodland Creation Option",null,null,null,null,null,null,null,{"$f":"H9/I16","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,"Small or Farm Woodland"]
[null,null,null,null,null,null,null,null,null,{"$f":"H10/I16","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,"Native Broadleaves in Northern and Western Isles"]
[null,null,null,null,null,null,null,null,null,{"$f":"H11/I16","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,{"$f":"H12/I16","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,{"$f":"H13/I16","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,{"$f":"H14/I16","v":{"$error":"#DIV/0!"}}]
[null,"Designed Open Ground",null,null,null,"DOG",null,null,null,{"$f":"H15/I16","v":{"$error":"#DIV/0!"}}]
[null,"Total For Option",null,null,null,null,null,null,{"$f":"SUM(H9:H16)","v":0},1]
[null,"Woodland Creation Option",null,null,null,null,null,null,null,{"$f":"H17/I24","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,{"$f":"H18/I24","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,{"$f":"H19/I24","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,{"$f":"H20/I24","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,{"$f":"H21/I24","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,{"$f":"H22/I24","v":{"$error":"#DIV/0!"}}]
[null,"Designed Open Ground",null,null,null,"DOG",null,null,null,{"$f":"H23/I24","v":{"$error":"#DIV/0!"}}]
[null,"Total For Option",null,null,null,null,null,null,{"$f":"SUM(H17:H24)","v":0},1]
[null,"Woodland Creation Option",null,null,null,null,null,null,null,{"$f":"H25/I32","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,{"$f":"H26/I32","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,{"$f":"H27/I32","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,{"$f":"H28/I32","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,{"$f":"H29/I32","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,{"$f":"H30/I32","v":{"$error":"#DIV/0!"}}]
[null,"Designed Open Ground",null,null,null,"DOG",null,null,null,{"$f":"H31/I32","v":{"$error":"#DIV/0!"}}]
[null,"Total For Option",null,null,null,null,null,null,{"$f":"SUM(H25:H31)","v":0},1]
["A","Total Area \n(all Options combined)",null,null,null,null,null,null,{"$f":"SUM(I32,I24,I16)","v":0}]
["B","Other Land (if any) – Unplantable areas",null,null,null,"OL"]
["C","Other Land (if any) – designed open areas > grant aidable % ",null,null,null,"DOG"]
["D","Total area within  Woodland Creation Perimeter Boundary",null,null,null,null,null,null,{"$f":"SUM(I33:I35)","v":0}]

{"sheet":"WC Multiple Year Blank Template","index":1,"n_rows":53,"n_cols":19,"rows_kept":53,"cut":false,"hidden":false,"merged":[[47,1,47,2],[47,3,47,7],[48,1,48,2],[48,3,48,7],[36,8,40,8],[37,1,37,2],[38,1,38,2],[39,1,39,2],[40,1,40,2],[29,1,29,2],[30,1,30,2],[31,1,31,2],[32,1,32,2],[41,3,41,7],[49,9,52,9],[50,1,50,2],[50,3,50,4],[50,6,50,7],[51,1,51,2],[51,3,51,4],[51,6,51,7],[52,3,52,7],[52,1,52,2],[28,1,28,2],[28,3,28,7],[35,1,35,2],[35,3,35,7],[49,1,49,2],[49,3,49,7],[33,1,33,2],[36,1,36,2],[46,1,46,2],[45,1,45,2],[44,1,44,2],[43,1,43,2],[42,1,42,2],[41,1,41,2],[34,1,34,2],[34,3,34,7],[21,1,21,2],[21,3,21,7],[22,1,22,2],[22,3,22,7],[23,1,23,2],[23,8,27,8],[24,1,24,2],[25,1,25,2],[26,1,26,2],[27,1,27,2],[14,1,14,2],[14,3,14,7],[15,1,15,2],[15,8,20,8],[16,1,16,2],[18,1,18,2],[19,1,19,2],[20,1,20,2],[17,1,17,2],[8,1,8,2],[8,8,13,8],[9,1,9,2],[11,1,11,2],[12,1,12,2],[13,1,13,2],[7,1,7,2],[0,0,0,9],[1,0,1,9],[2,0,2,1],[2,2,2,3],[2,4,2,5],[2,6,2,9],[4,0,4,1],[4,2,4,3],[4,4,4,6],[4,7,4,9],[6,1,6,2]]}
["TABLE - WOODLAND CREATION COMPONENT AREAS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Woodland Creation Option"]
["This table is to be completed by the Applicant at the Application and Claim Stage. A separate Component Areas table is required for each Land Parcel / woodland block. Guidance for completing this table, and an example, can be found on the other worksheets listed (see the tabs at the bottom of the workbook).",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Conifer"]
["BRN:",null,null,null,"Location Code:",null,null,null,null,null,null,null,null,null,null,null,null,null,"Diverse Conifer"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Broadleaves"]
["Application Name:",null,null,null,"Land Parcel Identifier (LPID)\nOR \nIndividual Woodland Name:",null,null,null,null,null,null,null,null,null,null,null,null,null,"Native Scots Pine"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Native Upland Birch"]
[null,1,null,2,3,4,5,6,7,8,null,null,null,null,null,null,null,null,"Native Broadleaves"]
[null,"Woodland Creation Option",null,"Map identifier(s)","Claim Year","Planted Species","Stocking density (stems/ha)","Component Area (ha)","Total (ha)","% Component",null,null,null,null,null,null,null,null,"Native Low-density Broadleaves"]
[null,"Woodland Creation Option",null,null,null,null,null,null,null,{"$f":"H9/I23","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,"Small or Farm Woodland"]
[null,null,null,null,null,null,null,null,null,{"$f":"H10/I23","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,"Native Broadleaves in Northern and Western Isles"]
[null,null,null,null,null,null,null,null,null,{"$f":"H11/I23","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,{"$f":"H12/I23","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,{"$f":"H13/I23","v":{"$error":"#DIV/0!"}}]
[null,"Designed Open Ground",null,null,null,"DOG",null,null,null,{"$f":"H14/I23","v":{"$error":"#DIV/0!"}}]
[null,"Total For Cpt",null,null,null,null,null,null,{"$f":"SUM(H9:H15)","v":0}]
[null,"Woodland Creation Option",null,null,null,null,null,null,null,{"$f":"H16/I23","v":{"$error":"#DIV/0!"}}]
[null,"2nd claim year",null,null,null,null,null,null,null,{"$f":"H17/I23","v":{"$error":"#DIV/0!"}}]
[null,"2nd claim year",null,null,null,null,null,null,null,{"$f":"H18/I23","v":{"$error":"#DIV/0!"}}]
[null,"2nd claim year",null,null,null,null,null,null,null,{"$f":"H19/I23","v":{"$error":"#DIV/0!"}}]
[null,"2nd claim year",null,null,null,null,null,null,null,{"$f":"H20/I23","v":{"$error":"#DIV/0!"}}]
[null,"Designed Open Ground",null,null,null,"DOG",null,null,null,{"$f":"H21/I23","v":{"$error":"#DIV/0!"}}]
[null,"Total For Cpt",null,null,null,null,null,null,{"$f":"SUM(H16:H21)","v":0}]
[null,"Total For Option",null,null,null,null,null,null,{"$f":"SUM(I15+I22)","v":0},1]
[null,"Woodland Creation Option",null,null,null,null,null,null,null,{"$f":"H24/I36","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,{"$f":"H25/I36","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,{"$f":"H26/I36","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,{"$f":"H27/I36","v":{"$error":"#DIV/0!"}}]
[null,"Designed Open Ground",null,null,null,"DOG",null,null,null,{"$f":"H28/I36","v":{"$error":"#DIV/0!"}}]
[null,"Total For Cpt",null,null,null,null,null,null,{"$f":"SUM(H24:H29)","v":0}]
[null,"Woodland Creation Option",null,null,null,null,null,null,null,{"$f":"H30/I36","v":{"$error":"#DIV/0!"}}]
[null,"2nd claim year",null,null,null,null,null,null,null,{"$f":"H31/I36","v":{"$error":"#DIV/0!"}}]
[null,"2nd claim year",null,null,null,null,null,null,null,{"$f":"H32/I36","v":{"$error":"#DIV/0!"}}]
[null,"2nd claim year",null,null,null,null,null,null,null,{"$f":"H33/I36","v":{"$error":"#DIV/0!"}}]
[null,"Designed Open Ground",null,null,null,"DOG",null,null,null,{"$f":"H34/I36","v":{"$error":"#DIV/0!"}}]
[null,"Total For Cpt",null,null,null,null,null,null,{"$f":"SUM(H30:H35)","v":0}]
[null,"Total For Option",null,null,null,null,null,null,{"$f":"SUM(I29+I35)","v":0},1]
[null,"Woodland Creation Option",null,null,null,null,null,null,null,{"$f":"H37/I49","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,{"$f":"H38/I49","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,{"$f":"H39/I49","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,{"$f":"H40/I49","v":{"$error":"#DIV/0!"}}]
[null,"Designed Open Ground",null,null,null,"DOG",null,null,null,{"$f":"H41/I49","v":{"$error":"#DIV/0!"}}]
[null,"Total For Cpt",null,null,null,null,null,null,{"$f":"SUM(H37:H42)","v":0}]
[null,"Woodland Creation Option",null,null,null,null,null,null,null,{"$f":"H43/I49","v":{"$error":"#DIV/0!"}}]
[null,"2nd claim year",null,null,null,null,null,null,null,{"$f":"H44/I49","v":{"$error":"#DIV/0!"}}]
[null,"2nd claim year",null,null,null,null,null,null,null,{"$f":"H45/I49","v":{"$error":"#DIV/0!"}}]
[null,"2nd claim year",null,null,null,null,null,null,null,{"$f":"H46/I49","v":{"$error":"#DIV/0!"}}]
[null,"Designed Open Ground",null,null,null,"DOG",null,null,null,{"$f":"H47/I49","v":{"$error":"#DIV/0!"}}]
[null,"Total For Cpt",null,null,null,null,null,null,{"$f":"SUM(H43:H48)","v":0}]
[null,"Total For Option",null,null,null,null,null,null,{"$f":"SUM(I42:I48)","v":0},1]
["A","Total Area \n(all Options combined)",null,null,null,null,null,null,{"$f":"SUM(I23,I36,I49)","v":0}]
["B","Other Land (if any) – Unplantable areas",null,null,null,"OL"]
["C","Other Land (if any) – designed open areas > grant aidable % ",null,null,null,"DOG"]
["D","Total area within  Woodland Creation Perimeter Boundary",null,null,null,null,null,null,{"$f":"SUM(I50:I52)","v":0}]

{"sheet":"Guidance WC Template","index":2,"n_rows":23,"n_cols":1,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
["Notes on completing Table for WC that will be carried out within a Woodland Block"]
[]
["You must fill in a new table for each different LPID or different woodland block you are planting. \nIf you are planting a block over more than year, you should use the multiple year blank template. \nWe do intend to make this table much more user friendly by adding programming to allow you to enter additional rows and compartments. But for now, a lot of the formatting cannot be locked down. Whilst we develop an intelligent spreadsheet that can be populated within the parameters that our webpages must adhere to, we urge you to use the multiple year table or the single year table as appropriate (or both). if you do have to enter or delete additional rows, please be aware that the formula may well change in the percentage and total cells."]
[]
["BRN - enter the name of your Business Reference Number"]
["Location Code - enter the name of your Location Code of where the application is set."]
["Application Name - the name of your application to the Forestry Grant Scheme"]
["Land Parcel identifier or Individual Woodland name - either the Land Parcel identifier (LPID) if you are going to plant up the entire LP or the name of the woodland block if you are in the process of requesting a new LPID because you are planning to plant up part of the current LPID or your proposed planting is taking place over more than one LPID."]
[]
["Column 1 – Insert the Woodland Creation Option being delivered. If your Option is to be delivered over two or more claim years, please itemise the species to be planted in each of the years and provide a sub total for each year and a total for all the years for the Option."]
["Column 2 – Insert the appropriate map reference to ensure each species is identified on the species planting map "]
["Column 3 – Insert the year you will be claiming grant on the capital element of initial planting. That is once all the trees have been planted for that year according to your application/contract."]
["Column 4 – Insert each of the Species types being planted within the identified area on the species planting map. Use the species as listed in: http://scotland.forestry.gov.uk/images/corporate/pdf/speciesabbreviationsfelling.pdf\nAlso insert the amount of Designed Open Ground, if required. "]
["Column 5 – Insert the minimum stocking density you will plant for the species. "]
["Column 6 – Insert the component area for the species and designed open ground. "]
["Column 7 - Insert the total area for each option (and claim year sub total for options planted over two or more claim years). This total is for the grant aided areas only."]
["Column 8 – Insert the % breakdown of species/OG by area for each option. The total for option row should add up to 100%"]
[]
[]
["Row A – Insert total area for all woodland creation options. The value in Row A must not exceed the value in Row D, Column 7."]
["Row B – Insert the total of the Other Land areas that are unplantable. OL can be made up of any unplantable areas of greater than 0.25ha as identified on planting map (eg: scree, small lochs, extensive areas of peat over 50cm deep, etc..). These areas of Other Land must be identified at the planting planning stage and the areas marked out of your proposed area before beginning your landscape design."]
["Row C – Insert the total of all any additional open ground areas, of greater than 0.25ha each, as identified on your designed planting map (eg: Applications may include higher percentages of Designed Open Ground but in such cases, where this exceeds the maximum allowed under the woodland creation options, these excess unplanted open areas will not be included within the payable grant area and should be classed as excess open ground on the components table)"]
["Row D – Insert the total area contained within the Woodland Creation perimeter boundary. The total in Row C should equate to the permanent WC perimeter boundary area(s) marked on the ground.  This is the outermost boundary of each separate woodland creation block.  This may be made up of different woodland creation options that, in very large scale applications, might be planted over a couple of planting seasons but importantly, within this boundary you will include all of your Designed Open Ground. This perimeter boundary should be the same boundary as your proposed boundary fences. Other Land that will not be grant aided but is part of the woodland creation layout should also be included in this boundary."]

{"sheet":"Example WC Single Year","index":3,"n_rows":36,"n_cols":19,"rows_kept":36,"cut":false,"hidden":false,"merged":[[31,1,31,2],[31,3,31,7],[32,1,32,2],[32,3,32,7],[32,9,35,9],[33,1,33,2],[33,3,33,4],[33,6,33,7],[34,1,34,2],[34,3,34,4],[34,6,34,7],[35,1,35,2],[35,3,35,7],[23,1,23,2],[23,3,23,7],[24,1,24,2],[24,8,30,8],[25,1,25,2],[28,1,28,2],[29,1,29,2],[30,1,30,2],[19,1,19,2],[20,1,20,2],[21,1,21,2],[16,8,22,8],[17,1,17,2],[22,1,22,2],[13,1,13,2],[14,1,14,2],[15,1,15,2],[16,1,16,2],[8,8,14,8],[15,3,15,7],[8,1,8,2],[9,1,9,2],[12,1,12,2],[7,1,7,2],[0,0,0,9],[1,0,1,9],[2,0,2,1],[2,2,2,3],[2,4,2,5],[2,6,2,9],[4,0,4,1],[4,2,4,3],[4,4,4,6],[4,7,4,9],[6,1,6,2]]}
["TABLE - WOODLAND CREATION COMPONENT AREAS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Woodland Creation Option"]
["This table is to be completed by the Applicant at the Application and Claim Stage. A separate Component Areas table is required for each Land Parcel / woodland block. Guidance for completing this table, and an example, can be found on the other worksheets listed (see the tabs at the bottom of the workbook).",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Conifer"]
["BRN:",null,123456,null,"Location Code:",null,"067/6271",null,null,null,null,null,null,null,null,null,null,null,"Diverse Conifer"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Broadleaves"]
["Application Name:",null,"Leckie Hill Woods",null,"Land Parcel Identifier (LPID)\nOR \nIndividual Woodland Name:",null,null,"Cpt 6 Ladny's Field",null,null,null,null,null,null,null,null,null,null,"Native Scots Pine"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Native Upland Birch"]
[null,1,null,2,3,4,5,6,7,8,null,null,null,null,null,null,null,null,"Native Broadleaves"]
[null,"Woodland Creation Option",null,"Map identifier(s)","Claim Year","Planted Species","Stocking density (stems/ha)","Component Area (ha)","Total (ha)","% Component",null,null,null,null,null,null,null,null,"Native Low-density Broadleaves"]
[null,"Conifer",null,"Cpt 6",2016,"SS",2500,3.63,null,{"$f":"H9/I16","v":0.71456692913385822},null,null,null,null,null,null,null,null,"Small or Farm Woodland"]
[null,null,null,"Cpt 6",2016,"EL",2500,0.7,null,{"$f":"H10/I16","v":0.13779527559055116},null,null,null,null,null,null,null,null,"Native Broadleaves in Northern and Western Isles"]
[null,null,null,"Cpt 6",2016,"AR",1100,0.25,null,{"$f":"H11/I16","v":4.9212598425196846E-2}]
[null,null,null,null,null,null,null,null,null,{"$f":"H12/I16","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"H13/I16","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"H14/I16","v":0}]
[null,"Designed Open Ground",null,"Cpt 6",2016,"DOG",null,0.5,null,{"$f":"H15/I16","v":9.8425196850393692E-2}]
[null,"Total For Option",null,null,null,null,null,null,{"$f":"SUM(H9:H16)","v":5.08},1]
[null,"Woodland Creation Option",null,null,null,null,null,null,null,{"$f":"H17/I24","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,{"$f":"H18/I24","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,{"$f":"H19/I24","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,{"$f":"H20/I24","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,{"$f":"H21/I24","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,{"$f":"H22/I24","v":{"$error":"#DIV/0!"}}]
[null,"Designed Open Ground",null,null,null,"DOG",null,null,null,{"$f":"H23/I24","v":{"$error":"#DIV/0!"}}]
[null,"Total For Option",null,null,null,null,null,null,{"$f":"SUM(H17:H24)","v":0},1]
[null,"Woodland Creation Option",null,null,null,null,null,null,null,{"$f":"H25/I32","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,{"$f":"H26/I32","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,{"$f":"H27/I32","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,{"$f":"H28/I32","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,{"$f":"H29/I32","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,{"$f":"H30/I32","v":{"$error":"#DIV/0!"}}]
[null,"Designed Open Ground",null,null,null,"DOG",null,null,null,{"$f":"H31/I32","v":{"$error":"#DIV/0!"}}]
[null,"Total For Option",null,null,null,null,null,null,{"$f":"SUM(H25:H31)","v":0},1]
["A","Total Area \n(all Options combined)",null,null,null,null,null,null,{"$f":"SUM(I32,I24,I16)","v":5.08}]
["B","Other Land (if any) – Unplantable areas",null,null,null,"OL"]
["C","Other Land (if any) – designed open areas > grant aidable % ",null,null,null,"DOG",null,null,0.03]
["D","Total area within  Woodland Creation Perimeter Boundary",null,null,null,null,null,null,{"$f":"SUM(I33:I35)","v":5.1100000000000003}]

{"sheet":"Example WC Multiple Year","index":4,"n_rows":53,"n_cols":19,"rows_kept":53,"cut":false,"hidden":false,"merged":[[49,1,49,2],[49,3,49,7],[49,9,52,9],[50,1,50,2],[50,3,50,4],[50,6,50,7],[51,1,51,2],[51,3,51,4],[51,6,51,7],[52,1,52,2],[52,3,52,7],[45,1,45,2],[46,1,46,2],[47,1,47,2],[47,3,47,7],[48,1,48,2],[48,3,48,7],[41,1,41,2],[41,3,41,7],[42,1,42,2],[43,1,43,2],[44,1,44,2],[36,1,36,2],[36,8,40,8],[37,1,37,2],[38,1,38,2],[39,1,39,2],[40,1,40,2],[32,1,32,2],[33,1,33,2],[34,1,34,2],[34,3,34,7],[35,1,35,2],[35,3,35,7],[28,1,28,2],[28,3,28,7],[29,1,29,2],[30,1,30,2],[31,1,31,2],[8,8,13,8],[14,3,14,7],[15,8,20,8],[21,3,21,7],[23,8,27,8],[22,3,22,7],[1,0,1,9],[2,0,2,1],[4,0,4,1],[0,0,0,9],[7,1,7,2],[6,1,6,2],[2,4,2,5],[4,4,4,6],[2,6,2,9],[2,2,2,3],[4,2,4,3],[4,7,4,9],[8,1,8,2],[9,1,9,2],[12,1,12,2],[13,1,13,2],[14,1,14,2],[15,1,15,2],[17,1,17,2],[11,1,11,2],[22,1,22,2],[19,1,19,2],[20,1,20,2],[16,1,16,2],[21,1,21,2],[18,1,18,2],[24,1,24,2],[25,1,25,2],[26,1,26,2],[27,1,27,2],[23,1,23,2]]}
["TABLE - WOODLAND CREATION COMPONENT AREAS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Woodland Creation Option"]
["This table is to be completed by the Applicant at the Application and Claim Stage. A separate Component Areas table is required for each Land Parcel / woodland block. Guidance for completing this table, and an example, can be found on the other worksheets listed (see the tabs at the bottom of the workbook).",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Conifer"]
["BRN:",null,123456,null,"Location Code:",null,"067/6271",null,null,null,null,null,null,null,null,null,null,null,"Diverse Conifer"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Broadleaves"]
["Application Name:",null,"Leckie Hill Woods",null,"Land Parcel Identifier (LPID)\nOR \nIndividual Woodland Name:",null,null,"Leckie Hill Woods Cpts 1-5\nNN666036",null,null,null,null,null,null,null,null,null,null,"Native Scots Pine"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Native Upland Birch"]
[null,1,null,2,3,4,5,6,7,8,null,null,null,null,null,null,null,null,"Native Broadleaves"]
[null,"Woodland Creation Option",null,"Map identifier(s)","Claim Year","Planted Species","Stocking density (stems/ha)","Component Area (ha)","Total (ha)","% Component",null,null,null,null,null,null,null,null,"Native Low-density Broadleaves"]
[null,"Conifer",null,"Cpt 1",2016,"SS",2500,4.78,null,{"$f":"H9/I23","v":0.3054313099041534},null,null,null,null,null,null,null,null,"Small or Farm Woodland"]
[null,null,null,"Cpt 1",2016,"EL",2500,0.66,null,{"$f":"H10/I23","v":4.2172523961661344E-2},null,null,null,null,null,null,null,null,"Native Broadleaves in Northern and Western Isles"]
[null,null,null,"Cpt 1",2016,"WSH",1100,0.2,null,{"$f":"H11/I23","v":1.2779552715654953E-2}]
[null,null,null,"Cpt 1",2016,"Bi",1100,1.36,null,{"$f":"H12/I23","v":8.6900958466453682E-2}]
[null,null,null,null,null,null,null,null,null,{"$f":"H13/I23","v":0}]
[null,"Designed Open Ground",null,"Cpt1",2016,"DOG",null,0.59,null,{"$f":"H14/I23","v":3.769968051118211E-2}]
[null,"Total For Cpt",null,null,null,null,null,null,{"$f":"SUM(H9:H15)","v":7.5900000000000007}]
[null,"Conifer",null,"Cpt 2",2017,"SS",2500,6.68,null,{"$f":"H16/I23","v":0.42683706070287541}]
[null,"2nd claim year",null,"Cpt 2",2017,"EL",2500,1.38,null,{"$f":"H17/I23","v":8.8178913738019171E-2}]
[null,"2nd claim year",null,null,null,null,null,null,null,{"$f":"H18/I23","v":0}]
[null,"2nd claim year",null,null,null,null,null,null,null,{"$f":"H19/I23","v":0}]
[null,"2nd claim year",null,null,null,null,null,null,null,{"$f":"H20/I23","v":0}]
[null,"Designed Open Ground",null,"Cpt 3",2017,"DOG",null,0,null,{"$f":"H21/I23","v":0}]
[null,"Total For Cpt",null,null,null,null,null,null,{"$f":"SUM(H16:H21)","v":8.0599999999999987}]
[null,"Total For Option",null,null,null,null,null,null,{"$f":"SUM(I15+I22)","v":15.649999999999999},1]
[null,"Diverse Conifer",null,"Cpt 4",2016,"DF",2500,1.31,null,{"$f":"H24/I36","v":0.16034271725826194}]
[null,null,null,"Cpt 4",2016,"EL",2500,1.18,null,{"$f":"H25/I36","v":0.14443084455324356}]
[null,null,null,"Cpt 4",2016,"GWL",1100,0.16,null,{"$f":"H26/I36","v":1.9583843329253368E-2}]
[null,null,null,null,null,null,null,null,null,{"$f":"H27/I36","v":0}]
[null,"Designed Open Ground",null,"Cpt 4",2016,"DOG",null,0.4,null,{"$f":"H28/I36","v":4.8959608323133418E-2}]
[null,"Total For Cpt",null,null,null,null,null,null,{"$f":"SUM(H24:H29)","v":3.0500000000000003}]
[null,"Diverse Conifer",null,"Cpt 3",2017,"DF",2500,2.59,null,{"$f":"H30/I36","v":0.31701346389228885}]
[null,"2nd claim year",null,"Cpt 3",2017,"EL",2500,2.0099999999999998,null,{"$f":"H31/I36","v":0.24602203182374538}]
[null,"2nd claim year",null,"Cpt 3",2017,"GWL",1100,0.11,null,{"$f":"H32/I36","v":1.346389228886169E-2}]
[null,"2nd claim year",null,null,null,null,null,null,null,{"$f":"H33/I36","v":0}]
[null,"Designed Open Ground",null,"Cpt 3",2017,"DOG",null,0.41,null,{"$f":"H34/I36","v":5.0183598531211751E-2}]
[null,"Total For Cpt",null,null,null,null,null,null,{"$f":"SUM(H30:H35)","v":5.12}]
[null,"Total For Option",null,null,null,null,null,null,{"$f":"SUM(I29+I35)","v":8.17},1]
[null,"Native Upland Birch",null,"Cpt 5",2016,"BI",1600,1.84,null,{"$f":"H37/I49","v":0.71042471042471045}]
[null,null,null,"Cpt 5",2016,"AR",1600,0.5,null,{"$f":"H38/I49","v":0.19305019305019305}]
[null,null,null,null,null,null,null,null,null,{"$f":"H39/I49","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"H40/I49","v":0}]
[null,"Designed Open Ground",null,"Cpt 5",2016,"DOG",null,0.25,null,{"$f":"H41/I49","v":9.6525096525096526E-2}]
[null,"Total For Cpt",null,null,null,null,null,null,{"$f":"SUM(H37:H42)","v":2.59}]
[null,"Woodland Creation Option",null,null,null,null,null,null,null,{"$f":"H43/I49","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"H44/I49","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"H45/I49","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"H46/I49","v":0}]
[null,"Designed Open Ground",null,null,null,"DOG",null,null,null,{"$f":"H47/I49","v":0}]
[null,"Total For Cpt",null,null,null,null,null,null,{"$f":"SUM(H43:H48)","v":0}]
[null,"Total For Option",null,null,null,null,null,null,{"$f":"SUM(I42:I48)","v":2.59},1]
["A","Total Area \n(all Options combined)",null,null,null,null,null,null,{"$f":"SUM(I23,I36,I49)","v":26.41}]
["B","Other Land (if any) – Unplantable areas",null,null,null,"OL"]
["C","Other Land (if any) – designed open areas > grant aidable % ",null,null,null,"DOG"]
["D","Total area within  Woodland Creation Perimeter Boundary",null,null,null,null,null,null,{"$f":"SUM(I50:I52)","v":26.41}]