{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Introduction","1. DGF design choices","2. Landcover Map","3. DGF Calculator","GF to Metric&UKHab","Metric&UKHab to GF"],"not_rendered":{"charts":0,"images":1,"macros":1,"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":"Introduction","index":0,"n_rows":7,"n_cols":4,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,null,null,"TWC Development Greening Factor"]
[]
[null,null,null,"Introduction"]
[null,null,null,"Development Greening Factor (DGF) is required for major planning applications within the borough, through Policy NE4 of the Local Plan to be adopted in late 2026. It is a key policy to deliver the Plan's Forest Community vision and help make new development more climate change ready. DGF is based on Natural England's Urban Greening Factor, which is part of the national Green Infrastructure Framework.\n\nTWC has produced the Development Greening Factor; Interim guidance to give a brief overview and provide links to helpful resources. This is available on our website. It is strongly recommended that you use this and Natural England's Urban Greening Factor Standard User Guide  ( https://designatedsites.naturalengland.org.uk/GreenInfrastructure/UrbanGreeningFactorStandard.aspx ). This Natural England document sets out the standard methodology and landcover definitions that are used in the DGF and UGF process.\n\nThis document contains three tabs in green which you will need to complete:\n\n1. DGF design choices - This should be used to show the evidence sources used to inform an understanding of the development site and its context, as well as how it has informed your design.\n2. Landcover map - Insert in this sheet the map of the proposed landcover types covering all the land within the application's red line boundary.\n3. DGF Calculator - This is a calculation tool which provides your development's combined factor score.\n\nWe ask that an indicative copy of this document is submitted with the development's planning application. A final version will be required post-planning approval, via a pre-commencement condition, once the detailed design is in place.\n\nThe final two tabs, in brown, provide a guide to help convert Biodiversity Net Gain information into those of Natural England's UGF landcover typologies. Although NE's User Guide provides the definitions of each landcover type, these conversion tools, with professional judgement, should provide a useful starting point for those with less experience of UGF."]

{"sheet":"1. DGF design choices","index":1,"n_rows":25,"n_cols":5,"rows_kept":25,"cut":false,"hidden":false,"merged":[[24,2,380,4]]}
[]
[]
[null,null,"TWC Development Greening Factor"]
[null,null,"Evidence and rationale for the DGF design of site"]
[null,null,null,"Application reference number (if available)"]
[null,null,null,"Site Address"]
[null,null,null,"Name of person completing this form"]
[null,null,null,"Date of completion"]
[null,null,null,"Stage of design (Please select one):"]
[null,null,null,"Indicative\n(suitable where applicant wants details agreed at a later stage)",false]
[null,null,null,"Final detailled \n(suitable where applicant wants final details agreed, e.g. condition)",false]
[null,null,"1. Which of the following evidence sources have you used to understand your site's context?"]
[null,null,"Evidence sources (check boxes of sources used)",null,"What do they explain about the site, its context and the proposal?"]
[null,null,false,"Shropshire and Telford & Wrekin Local Nature Strategy"]
[null,null,false,"The Shropshire and Telford & Wrekin Local Nature Recovery Map "]
[null,null,false,"Telford & Wrekin Council Playing Pitch and Outdoor Recreation Strategy"]
[null,null,false,"Telford & Wrekin Council Playing Pitch and Outdoor Recreation Strategy"]
[null,null,false,"Tree Equity Score UK"]
[null,null,false,"Green Infrastructure Map"]
[null,null,false,"The Environmental Benefits from Nature Tool "]
[null,null,false,"ClimateJust "]
[null,null,false,"Other, for example  site surveys, community consultation or pre-application advice.","Please list and explain."]
[]
[null,null,"2. How has this evidence influenced the proposed landcover choices and overall DGF design?"]
[null,null,"Please insert your answer here."]

{"sheet":"2. Landcover Map","index":2,"n_rows":3,"n_cols":3,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,"Proposal's Develoment Greening Factor map"]

{"sheet":"3. DGF Calculator","index":3,"n_rows":37,"n_cols":8,"rows_kept":37,"cut":false,"hidden":false,"merged":[[3,1,7,5]]}
[]
[null,"TWC Greening Factor calculator"]
[]
[null,"Please refer to Natural England's UGF User Guide for description and specification of surface cover types and guidance on completing the UGF calculation: https://designatedsites.naturalengland.org.uk/GreenInfrastructure/UrbanGreeningFactorStandard.aspx  . This spreadsheet is based on Natural England's Urban Greening Factor User Guide Spreadsheet Version 1.1 31012023\n\nThe applicant should complete the yellow highlighted cells with:\n       ·   Details of the development, Biodiversity Metric, author and date of completion\n       ·   Total area for each Surface Cover Type in square meters (m2)\n       ·   Total site area square meters (m2)\n       ·   Habitat reference numbers from your Biodiversity Metric\n       ·   Any additional evidence for category chosen\n"]
[]
[null,null,null,null,null,null,"\nName of person completing calculation\n"]
[null,null,null,null,null,null,"\nDate of calculation\n"]
[null,null,null,null,null,null,"\nBiodiversity Metric reference number\n"]
[null,"No.","Surface Cover Type","Area (m2)","Factor","Value","BNG Metric Habitat reference numbers for parcels included (if subject to BNG)","User comments"]
[null,"\n1\n","Semi-natural vegetation and wetlands retained on site (including existing / mature trees)",null,1,{"$f":"D10*E10","v":0}]
[null,"\n2\n","Semi-natural vegetation established on site",null,1,0]
[null,"\n3\n","Standard / semi-mature trees \n(planted in connected tree pits) ",null,0.9,0]
[null,"\n4\n","Native hedgerow planting \n(using mixed native species)",null,0.8,0]
[null,"\n5\n","Standard / semi-mature trees \n(planted in individual tree pits)",null,0.7,0]
[null,"\n6\n","Food growing, orchards and allotments",null,0.7,0]
[null,"\n7\n","Flower rich perennial and herbaceous planting",null,0.7,0]
[null,"\n8\n","Single Species or mixed hedge planting  \n(including linear planting of mature shrubs)",null,0.6,0]
[null,"\n9\n","Amenity shrub and ground cover planting ",null,0.5,0]
[null,"\n10\n","Amenity grasslands including formal lawns",null,0.4,0]
[null,11,"Intensive green roof \n(meets the Green Roof Organisation / GRO Code)",null,0.8,0]
[null,"\n12\n","Extensive biodiverse green roof \n(meets the GRO Code, may include Biosolar)",null,0.7,0]
[null,"\n13\n","Extensive green roof \n(meets GRO Code)",null,0.5,0]
[null,"\n14\n","Extensive sedum only green roof \n(does not meet the GRO Code)",null,0.3,0]
[null,"\n15\n","Green facades and modular living walls\n(rooted in soil or with irrigation)",null,0.5,0]
[null,"\n16\n","Wetlands and semi-natural open water",null,1,0]
[null,"\n17\n","Rain gardens and vegetated attenuation basins",null,0.7,0]
[null,"\n18\n","Open swales and unplanted detention basins",null,0.5,0]
[null,"\n19\n","Water features (unplanted and chlorinated) ",null,0.2,0]
[null,"\n20\n","Open aggregate and granular paving",null,0.2,0]
[null,"\n21\n","Partially sealed and semi-permeable paving",null,0.1,0]
[null,"\n22\n","Sealed paving (including concrete and asphalt)",null,0,0]
[]
[]
[null,null,null,null,"Total Value",{"$f":"SUM(F10:F31)","v":0}]
[null,null,null,null,"Total Development Site Area (m2)"]
[]
[null,null,null,null,"Urban Greening Factor",{"$f":"F34/F35","v":{"$error":"#DIV/0!"}}]

{"sheet":"GF to Metric&UKHab","index":4,"n_rows":8,"n_cols":25,"rows_kept":8,"cut":false,"hidden":false,"merged":[[3,2,3,10],[2,2,2,10],[5,2,7,2]]}
[]
[]
[null,null,"Guide to comparing Greening Factor surface cover types with Biodiverity Metric and UKHab categories"]
[null,null,"Introduction and Advice\n\nDifferent habitat classification systems are commonly used, but due to their specific function, they often do not completely align. Therefore, we have produced the tables below as a rough guide to help you choose appropriate Greening Factor surface land cover type, based on those measured within your development's Biodiversity Metric and shown on its accompanying UKHab map. The table is intended to be indicative and the formal guidance for each system should be referred to, not least because some categories can be translated in to several others, depending on site specific conditions:\n         Natural England (2023) Urban Greening Factor for England User Guide         https://designatedsites.naturalengland.org.uk/GreenInfrastructure/UrbanGreeningFactorStandard.aspx \n         Defra (2023) Biodiversity Metric guides         https://www.gov.uk/government/publications/statutory-biodiversity-metric-tools-and-guides\n         UKHab Ltd (2023) UK Habiat Classification Version 2.0         https://www.ukhab.org/\n\nWhen we assess your submission we will need to check both the surface cover chosen and the area of this. Our strong recommendation is that you use the development's post-development biodiversity metric comments column to record and evidence your surface cover choice. Please add the area or anticipated width to the linear habitats (e.g. hedgerow will be 1m wide).\nSimilarly please cross-reference the land parcels within the metric (and map) to the Greening Factor calculator. This will enable you to efficiently and effectively evidence your calculation."]
[null,null,"Greening Factor Surface cover type (based on NGIF)","Semi-natural vegetation and wetlands retained on site (including existing / mature trees)","Semi-natural vegetation established on site","Standard / semi-mature trees (planted in connected tree pits) ","Standard / semi-mature trees (planted in individual tree pits)","Native hedgerow planting (using mixed native species)","Single Species or mixed hedge planting (including linear planting of mature shrubs)","Amenity shrub and ground cover planting ","Food growing, orchards and allotments","Flower rich perennial and herbaceous planting","Amenity grasslands including formal lawns","Wetlands and semi-natural open water","Water features (unplanted and chlorinated) ","Rain gardens and vegetated attenuation basins","Open swales and unplanted detention basins","Intensive green roof (meets the Green Roof Organisation / GRO Code)","Extensive biodiverse green roof (meets the GRO Code, may include Biosolar)","Extensive green roof (meets GRO Code)","Extensive sedum only green roof (does not meet the GRO Code)","Green facades and modular living walls (rooted in soil or with irrigation)","Open aggregate and granular paving","Partially sealed and semi-permeable paving","Sealed paving (including concrete and asphalt)"]
[null,null,"Biodiversity Metric habitat (inc UKHab / EUNIS / NE codes)","Many","Many","Individual trees - Urban tree (UKHab 200 to 205; EUNIS NE0014)","Individual trees - Urban tree (UKHab 200 to 205; EUNIS NE0014)","Most hedgerow types (except Non-native and ornamental hedgerow (UKHab h2b))","Hedgerow - Non-native and ornamental hedgerow (UKHab h2b)","Urban - Introduced shrub (UKHab 847)","Cropland habitat types","Urban - Vegetated garden (UKHab 828)","Grassland - Modified grassland (UKHab g4)","Many semi natural habitats within Watercourse and Wetland category types","Lakes - Ornamental lake or pond (UKHab 46)","Urban - Rain garden (UKHab 850)","Watercourse - Ditches (UKHab 50)","Urban - Intensive green roof (UKHab 88)","Urban - Biodiverse green roof (UKHab 87)","Urban - Other green roof (UKHab 89)","Urban - Other green roof (UKHab 89)","Urban - Ground based green wall (UKHab 842)","Urban - Artificial unvegetated, unsealed surface (UKHab u1c)","Urban - Artificial unvegetated, unsealed surface (UKHab u1c)","Urban - Developed land; sealed surface (UKHab u1b)"]
[null,null,null,null,null,"Individual trees - Rural tree (UKHab 200 to 205; EUNIS NE0016)","Individual trees - Rural tree (UKHab 200 to 205; EUNIS NE0016)",null,null,"Urban - Vegetated garden (UKHab 828)","Grassland - Traditional orchards (UKHab 27)","Urban - Ground level planters (UKHab 845)","Grassland - Other neutral grassland (UKHab g3c)",null,null,"Urban - Bioswale (UKHab 849)","Urban - Sustainable drainage system (UKHab 848)",null,"Urban - Other green roof (UKHab 89)",null,null,"Urban - Facade-bound green wall (UKHab 843)"]
[null,null,null,null,null,null,null,null,null,"Urban - Ground level planters (UKHab 845)","Urban - Allotments (UKHab 616)"]

{"sheet":"Metric&UKHab to GF","index":5,"n_rows":31,"n_cols":6,"rows_kept":31,"cut":false,"hidden":false,"merged":[[4,3,4,5],[3,2,3,5],[2,2,2,5]]}
[]
[]
[null,null,"Guide to comparing Biodiverity Metric and UKHab categories with Greening Factor surface cover types"]
[null,null,"Introduction and Advice\n\nDifferent habitat classification systems are commonly used, but due to their specific function, they often do not completely align. Therefore, we have produced the tables below as a rough guide to help you choose appropriate Greening Factor surface land cover type, based on those measured within your development's Biodiversity Metric and shown on its accompanying UKHab map. The table is intended to be indicative and the formal guidance for each system should be referred to, not least because some categories can be translated in to several others, depending on site specific conditions:\n         Natural England (2023) Urban Greening Factor for England User Guide         https://designatedsites.naturalengland.org.uk/GreenInfrastructure/UrbanGreeningFactorStandard.aspx \n         Defra (2023) Biodiversity Metric guides         https://www.gov.uk/government/publications/statutory-biodiversity-metric-tools-and-guides\n         UKHab Ltd (2023) UK Habiat Classification Version 2.0         https://www.ukhab.org/\n\nWhen we assess your submission we will need to check both the surface cover chosen and the area of this. Our strong recommendation is that you use the development's post-development biodiversity metric comments column to record and evidence your surface cover choice. Please add the area or anticipated width to the linear habitats (e.g. hedgerow will be 1m wide).\nSimilarly please cross-reference the land parcels within the metric (and map) to the Greening Factor calculator. This will enable you to efficiently and effectively evidence your calculation."]
[null,null,"Metric & UKHab type","Greening Factor Surface cover type/s"]
[null,null,"Most terrestrial semi-natural habitat types","Semi-natural vegetation and wetlands retained on site (including existing / mature trees)","Semi-natural vegetation established on site"]
[null,null,"Individual trees - Urban tree \n(UKHab 200 to 205; EUNIS NE0014)","Standard / semi-mature trees (planted in connected tree pits) "]
[null,null,"Individual trees - Rural tree \n(UKHab 200 to 205; EUNIS NE0016)","Semi-natural vegetation and wetlands retained on site (including existing / mature trees)","Standard / semi-mature trees (planted in individual tree pits)"]
[null,null,"Most hedgerow types \n(except Non-native and ornamental hedgerow (UKHab h2b))","Semi-natural vegetation and wetlands retained on site (including existing / mature trees)","Native hedgerow planting (using mixed native species)"]
[null,null,"Hedgerow - Non-native and ornamental hedgerow \n(UKHab h2b)","Single Species or mixed hedge planting (including linear planting of mature shrubs)"]
[null,null,"Urban - Introduced shrub \n(UKHab 847)","Amenity shrub and ground cover planting "]
[null,null,"Urban - Vegetated garden \n(UKHab 828)","Amenity shrub and ground cover planting ","Flower rich perennial and herbaceous planting"]
[null,null,"Urban - Ground level planters \n(UKHab 845)","Amenity shrub and ground cover planting ","Flower rich perennial and herbaceous planting"]
[null,null,"Cropland habitat types","Food growing, orchards and allotments"]
[null,null,"Grassland - Traditional orchards \n(UKHab 27)","Semi-natural vegetation and wetlands retained on site (including existing / mature trees)","Food growing, orchards and allotments"]
[null,null,"Urban - Allotments \n(UKHab 616)","Food growing, orchards and allotments"]
[null,null,"Grassland - Modified grassland \n(UKHab g4)","Amenity grasslands including formal lawns"]
[null,null,"Grassland - Other neutral grassland \n(UKHab g3c)","Semi-natural vegetation and wetlands retained on site (including existing / mature trees)","Semi-natural vegetation established on site","Amenity grasslands including formal lawns"]
[null,null,"Many semi natural habitats within Watercourse and Wetland category types","Semi-natural vegetation and wetlands retained on site (including existing / mature trees)","Wetlands and semi-natural open water"]
[null,null,"Lakes - Ornamental lake or pond \n(UKHab 46)","Water features (unplanted and chlorinated) "]
[null,null,"Watercourse - Ditches \n(UKHab 50)","Wetlands and semi-natural open water","Rain gardens and vegetated attenuation basins","Open swales and unplanted detention basins"]
[null,null,"Urban - Sustainable drainage system \n(UKHab 848)","Wetlands and semi-natural open water","Rain gardens and vegetated attenuation basins","Open swales and unplanted detention basins"]
[null,null,"Urban - Bioswale \n(UKHab 849)","Rain gardens and vegetated attenuation basins"]
[null,null,"Urban - Rain garden \n(UKHab 850)","Rain gardens and vegetated attenuation basins"]
[null,null,"Urban - Biodiverse green roof \n(UKHab 87)","Extensive biodiverse green roof (meets the GRO Code, may include Biosolar)"]
[null,null,"Urban - Intensive green roof \n(UKHab 88)","Intensive green roof (meets the Green Roof Organisation / GRO Code)"]
[null,null,"Urban - Other green roof \n(UKHab 89)","Extensive biodiverse green roof (meets the GRO Code, may include Biosolar)","Extensive green roof (meets GRO Code)","Extensive sedum only green roof (does not meet the GRO Code)"]
[null,null,"Urban - Ground based green wall \n(UKHab 842)","Green facades and modular living walls (rooted in soil or with irrigation)"]
[null,null,"Urban - Facade-bound green wall \n(UKHab 843)","Green facades and modular living walls (rooted in soil or with irrigation)"]
[null,null,"Urban - Developed land; sealed surface \n(UKHab u1b)","Sealed paving (including concrete and asphalt)"]
[null,null,"Urban - Artificial unvegetated, unsealed surface \n(UKHab u1c)","Open aggregate and granular paving","Partially sealed and semi-permeable paving"]