{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Read me - LAs","Level 1 Screening","Calculations","Sites"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":5,"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":"Read me - LAs","index":0,"n_rows":22,"n_cols":3,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[null,null,"JBA Strategic Flood Risk Assessment Site Screening Tool - v2.0"]
[]
[null,null,"This spreadsheet has been designed to assist local authorities with the selection of development sites for inclusion within their local plan."]
[]
[null,null,"Note on calculations:"]
[null,null,"Site boundaries have been screened against flood risk information to determine the proportion of the site at risk.  The following flood risk information has been used in the assessment\n●  Flood Zones (from Environment Agency Flood Zones and results from detailed hydraulic models)\n●  Environment Agency's Risk of Flooding from Surface Water Map\n●  Environment Agency's Historic Flood Map\n●  Environment Agency's Risk of Flooding from Reservoirs Map\n●  JBA Groundwater Map\nFurther information on sources of data are given in the Level 1 SFRA report"]
[]
[null,null,"Additional information:"]
[null,null,"The sites have also been considered against the following information to provide additional information to support decision making\n●  Canal centrelines - to determine if there is a canal within 100m of the site\n●  Environment Agency's Areas Benefitting from Defences dataset - to determine if the site benefits from formal flood defences\n●  Detailed River Network dataset - to determine if their is a watercourse with a catchment less than 3km2 flowing through or adjacent to a site, which would not have been included in the Environment Agency's Flood Zones"]
[]
[null,null,"Note on Flood Zone and Surface Water percentages:"]
[null,null,"The values quoted in the Level 1 Screening tab show the percentage of the site at flood risk from that particular Flood Zone / event, excluding the percentage of the site at flood risk at a higher risk Flood Zone.  The total percentage of Flood Zone 3b, 3a, 2 and 1 is equal to 100%.  These figures are used to apply the sequential test.\n\nFor example\n50% of a site is in the Flood Zones.  Taking each Flood Zone individually, 50% is in Flood Zone 2 but only 30% is in Flood Zone 3a and only 10% is in Flood Zone 3b.\nIn the Level 1 Screening tab this will be displayed as 10% in Flood Zone 3b, 20% in Flood Zone 3a (as this excludes the 10% in Flood Zone 3b), 20% in Flood Zone 2 (as this excludes the 10% in Flood Zone 3b and 20% in Flood Zone 3a) and 50% in Flood Zone 1. This seeks to avoid double counting and overlapping of flood zones, displayed as distinct seperate percentages in the screening tab.\n\nThe only exception to this is Flood Zone 3a plus climate change (35% allowance for climate change were adopted under the EA guidelines) which can be larger than the existing Flood Zone 2, so is presented as a stand-alone percentage."]
[]
[null,null,"Using the spreadsheet"]
[null,null,"The spreadsheet has been designed to assist the selection of sites.  A number of screening options are available at the top of the Level 1 Screening tab.  Each option will allow sites to be screened against a user defined value.\n\nFor example\nTo select sites that are more than 50% in Flood Zone 2, click on 'Screen sites against a user-defined % in Flood Zone 2' icon, and enter 50 (do not include a % sign) when prompted.\nIn the first instance of using this spreadsheet, a search of sites that are 100% in FZ1 should be taken. This will help determine whether all development needs are within the sites that are covered in this selection. In the event that they are, then no further action needs to be taken to determine which sites should be adopted in the Local Plan for development. Where development needs exists outside of the sites in FZ1, assessment of sites in FZ2 should be made. \n\nThe last column and two screening buttons give an indication of whether the sites are within Flood Zone 1 at low risk of flood risk from all sources under the Council's chosen criteria:\n●  Site is within Flood Zone 1\n●  Site is not within Flood Zone 3a plus climate change\n●  Site is <10% at risk from surface water flooding in the 1 in 1000-year event\n●  Site is <10% within highest risk category in JBA Groundwater map (groundwater is <0.025m below the surface in the 1 in 100-year event). \n●  Site is <25% within second highest risk category in JBA Groundwater map (groundwater is between 0.025m and 0.5m below the surface in the 1 in 100-year event)\n●  Site is not within the Historic Flood Map\n●  Site is not at risk of reservoir flooding\nSewer flooding information is only provided at a postcode scale and is not suitable for a screening exercise but should be considered in any Level 2 assessment.\n"]

{"sheet":"Level 1 Screening","index":1,"n_rows":52,"n_cols":24,"rows_kept":52,"cut":false,"hidden":false,"merged":[[7,0,9,0],[7,1,9,1],[7,2,9,2],[8,19,9,19],[7,3,7,19],[7,23,9,23],[7,21,9,21],[7,20,9,20],[7,22,9,22],[8,3,8,8],[8,17,8,18],[8,9,8,13],[8,16,9,16],[8,14,9,14],[8,15,9,15]]}
[]
[]
[]
[]
[]
[]
[]
["Site code","Site Name","Area (ha)","Proportion of site shown to be at risk (%)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Presence of a watercourse (EA designated main river and/or ordinary watercourse in the OS Open Rivers dataset )","Source of Site","Is the site in FZ1 and at low risk from other sources? (see Read me tab for criteria)","Justification for Level 2 Assessment"]
[null,null,null,"Flood Zones",null,null,null,null,null,"Risk of Flooding from Surface Water (RoFSW)",null,null,null,null,"% within Historic Flood Map","% within Risk of Flooding from Reservoirs (Dry Day)","% within Risk of Flooding from Reservoirs (Wet Day)","JBA Groundwater Flood Map (depth of water level below ground surface in 100 year event)",null,"Total in high risk categories"]
[null,null,null,"% in FZ 3b only ","% in FZ 3a only","Total % within FZ3"," % in FZ 2 only ","% in FZ 1 only ","Total % within FZ 3a 35% climate change ","Total % at surface water risk up to 30-yr","100yr","Total % at surface water risk up to 100-yr","Total % at surface water risk up to 1000 yrs","Total % at surface risk up to 100-yrs + 40% Climate Change",null,null,null,"% within 0 to 0.025m category","% within 0.025 to 0.5m category "]
[{"$f":"Calculations!A2","v":"B3"},{"$f":"Calculations!B2","v":"West Redbourn, Redbourn, AL3 7HZ"},{"$f":"Calculations!C2","v":27.017108634948702},{"$f":"Calculations!E2","v":0},{"$f":"Calculations!L2","v":0},{"$f":"D11+E11","v":0},{"$f":"Calculations!P2","v":0},{"$f":"Calculations!Q2","v":1},{"$f":"Calculations!U2","v":0},{"$f":"Calculations!AG2","v":1.2437611827883967E-2},null,{"$f":"Calculations!AI2","v":2.3156654325981574E-2},{"$f":"Calculations!AK2","v":5.6474136645666896E-2},{"$f":"Calculations!AO2","v":5.411682637939158E-2},{"$f":"Calculations!AA2","v":0},{"$f":"Calculations!AE2","v":5.0710154173501231E-3},{"$f":"Calculations!AC2","v":7.0458603557336016E-3},{"$f":"Calculations!AW2","v":0},{"$f":"Calculations!AU2","v":5.9008644980453034E-3},{"$f":"R11+S11","v":5.9008644980453034E-3},"No",{"$f":"Sites!E2","v":"Residential"},{"$f":"IF(AND($H11=1,I11=0,O11=0,Q11=0,$M11<0.1,$R11<0.1,$S11<0.25,$U11=\"No\"),\"Yes\",\"No\")","v":"No"},"Multiple surface water flow paths present on site"]
[{"$f":"Calculations!A3","v":"M25"},{"$f":"Calculations!B3","v":"Baulk Close, Harpenden, AL5 4LY"},{"$f":"Calculations!C3","v":0.555620455932617},{"$f":"Calculations!E3","v":2.6476409652867353E-2},{"$f":"Calculations!L3","v":-1.3930590013120497E-5},{"$f":"D12+E12","v":2.6462479062854233E-2},{"$f":"Calculations!P3","v":0.18142634957043346},{"$f":"Calculations!Q3","v":0.81857365042956654},{"$f":"Calculations!U3","v":0.20788825035424205},{"$f":"Calculations!AG3","v":0},null,{"$f":"Calculations!AI3","v":4.9864275817051102E-3},{"$f":"Calculations!AK3","v":8.7449154574775576E-2},{"$f":"Calculations!AO3","v":6.0922623164115744E-2},{"$f":"Calculations!AA3","v":0},{"$f":"Calculations!AE3","v":5.4205810038387335E-2},{"$f":"Calculations!AC3","v":0.14321776217538928},{"$f":"Calculations!AW3","v":1.2108017324043097E-2},{"$f":"Calculations!AU3","v":4.4288927695853089E-2},{"$f":"R12+S12","v":5.6396945019896186E-2},"No",{"$f":"Sites!E3","v":"Residential"},{"$f":"IF(AND($H12=1,I12=0,O12=0,Q12=0,$M12<0.1,$R12<0.1,$S12<0.25,$U12=\"No\"),\"Yes\",\"No\")","v":"No"},"Low to moderate risk of multiple sources of flooding"]
[{"$f":"Calculations!A4","v":"M6"},{"$f":"Calculations!B4","v":"South of Harpenden Lane, Redbourn, AL3 7RQ"},{"$f":"Calculations!C4","v":12.5641147644042},{"$f":"Calculations!E4","v":8.359706705352489E-2},{"$f":"Calculations!L4","v":4.6573652609281049E-2},0.13017071966280594,{"$f":"Calculations!P4","v":0.15621378502599356},{"$f":"Calculations!Q4","v":0.84378621497400641},{"$f":"Calculations!U4","v":0.24494009222721991},{"$f":"Calculations!AG4","v":0.16510284375144102},null,{"$f":"Calculations!AI4","v":0.22317353942330428},{"$f":"Calculations!AK4","v":0.4114979975610793},{"$f":"Calculations!AO4","v":0.39075754273544744},{"$f":"Calculations!AA4","v":0},{"$f":"Calculations!AE4","v":0},{"$f":"Calculations!AC4","v":0.33962623486003146},{"$f":"Calculations!AW4","v":0.5149221565808102},{"$f":"Calculations!AU4","v":0.12332241209473506},0.63824456867554524,"Yes",{"$f":"Sites!E4","v":"Residential"},"No","Moderate risk of multiple sources of flooding"]
[{"$f":"Calculations!A5","v":"M5"},{"$f":"Calculations!B5","v":"Sewage Treatment Works, Piggottshill Lane, Harpenden, AL5 5UN"},{"$f":"Calculations!C5","v":4.0995474700927703},{"$f":"Calculations!E5","v":0},{"$f":"Calculations!L5","v":0},0,{"$f":"Calculations!P5","v":0},{"$f":"Calculations!Q5","v":1},{"$f":"Calculations!U5","v":0},{"$f":"Calculations!AG5","v":3.1201739426522955E-2},null,{"$f":"Calculations!AI5","v":0.11147903595912137},{"$f":"Calculations!AK5","v":0.26936131347881459},{"$f":"Calculations!AO5","v":0.26895809773520168},{"$f":"Calculations!AA5","v":0},{"$f":"Calculations!AE5","v":0},{"$f":"Calculations!AC5","v":0},{"$f":"Calculations!AW5","v":0},{"$f":"Calculations!AU5","v":0},0,"No",{"$f":"Sites!E5","v":"Residential"},"No","Moderate surface water flood risk"]
[{"$f":"Calculations!A6","v":"M26"},{"$f":"Calculations!B6","v":"Highway Chipping Depot, Lower Luton Road, AL4 8JJ"},{"$f":"Calculations!C6","v":0.33922189636230404},{"$f":"Calculations!E6","v":2.5850254539318768E-3},{"$f":"Calculations!L6","v":-6.9056534512741859E-6},2.5781198004806026E-3,{"$f":"Calculations!P6","v":0.31923636106463521},{"$f":"Calculations!Q6","v":0.68076363893536485},{"$f":"Calculations!U6","v":0.3218147539187276},{"$f":"Calculations!AG6","v":8.792008470800216E-6},null,{"$f":"Calculations!AI6","v":1.2139122041210976E-3},{"$f":"Calculations!AK6","v":8.5025097070320198E-3},{"$f":"Calculations!AO6","v":5.7968135877342983E-3},{"$f":"Calculations!AA6","v":0},{"$f":"Calculations!AE6","v":5.2765085062877531E-3},{"$f":"Calculations!AC6","v":2.1830686991609893E-2},{"$f":"Calculations!AW6","v":0.16557601130422117},{"$f":"Calculations!AU6","v":6.4498102531555565E-2},0.23007411383577675,"No",{"$f":"Sites!E6","v":"Residential"},"No","Moderate risk of multiple sources of flooding"]
[{"$f":"Calculations!A7","v":"M20"},{"$f":"Calculations!B7","v":"Lower Luton Road, Harpenden, AL5 5AF"},{"$f":"Calculations!C7","v":0.73588062286376899},{"$f":"Calculations!E7","v":4.9071648198304009E-3},{"$f":"Calculations!L7","v":1.3008957559685307E-5},4.9201737773900862E-3,{"$f":"Calculations!P7","v":1.762792522136606E-2},{"$f":"Calculations!Q7","v":0.98237207477863397},{"$f":"Calculations!U7","v":2.2548084873060516E-2},{"$f":"Calculations!AG7","v":0},null,{"$f":"Calculations!AI7","v":0},{"$f":"Calculations!AK7","v":1.5854603183976471E-2},{"$f":"Calculations!AO7","v":2.5049036702371436E-2},{"$f":"Calculations!AA7","v":0},{"$f":"Calculations!AE7","v":2.6728538565233637E-2},{"$f":"Calculations!AC7","v":0.17819007209796447},{"$f":"Calculations!AW7","v":0.5800681116529498},{"$f":"Calculations!AU7","v":9.8895613802857191E-2},0.67896372545580697,"No",{"$f":"Sites!E7","v":"Residential"},"No","High groundwater flood risk"]
[{"$f":"Calculations!A8","v":"B5"},{"$f":"Calculations!B8","v":"Glinwell, Hatfield Road, St Albans, AL4 0HE"},{"$f":"Calculations!C8","v":20.847097465515098},{"$f":"Calculations!E8","v":0},{"$f":"Calculations!L8","v":0.11117132174452736},0.11117132174452736,{"$f":"Calculations!P8","v":2.4865275494540026E-2},{"$f":"Calculations!Q8","v":0.97513472450546002},{"$f":"Calculations!U8","v":0.11117132834865394},{"$f":"Calculations!AG8","v":2.478875793582444E-2},null,{"$f":"Calculations!AI8","v":5.0686299633840255E-2},{"$f":"Calculations!AK8","v":0.25590611822918791},{"$f":"Calculations!AO8","v":0.22476947688028528},{"$f":"Calculations!AA8","v":0},{"$f":"Calculations!AE8","v":0},{"$f":"Calculations!AC8","v":0},{"$f":"Calculations!AW8","v":0.29028715392210042},{"$f":"Calculations!AU8","v":8.2142757381374304E-2},0.37242991130347469,"Yes",{"$f":"Sites!E8","v":"Residential"},"No","Moderate fluvial, groundwater and surface water risk"]
[{"$f":"Calculations!A9","v":"B8"},{"$f":"Calculations!B9","v":"Harper Lane, north of Radlett, WD7 7HU"},{"$f":"Calculations!C9","v":11.401245571136402},{"$f":"Calculations!E9","v":0},{"$f":"Calculations!L9","v":1.3635414183025678E-2},1.3635414183025678E-2,{"$f":"Calculations!P9","v":6.4130058155410178E-3},{"$f":"Calculations!Q9","v":0.99358699418445895},{"$f":"Calculations!U9","v":1.3635422615245774E-2},{"$f":"Calculations!AG9","v":0},null,{"$f":"Calculations!AI9","v":0},{"$f":"Calculations!AK9","v":1.6489311027916096E-2},{"$f":"Calculations!AO9","v":1.2546733094475649E-2},{"$f":"Calculations!AA9","v":0},{"$f":"Calculations!AE9","v":0},{"$f":"Calculations!AC9","v":0},{"$f":"Calculations!AW9","v":2.0364390732339944E-6},{"$f":"Calculations!AU9","v":0},2.0364390732339944E-6,"No",{"$f":"Sites!E9","v":"Residential"},"No","Majority of site at moderate groundwater risk, low fluvial and surface water risk"]
[{"$f":"Calculations!A10","v":"P1"},{"$f":"Calculations!B10","v":"Smallford Works, Smallford Lane, AL4 0SA"},{"$f":"Calculations!C10","v":3.3350426132202098},{"$f":"Calculations!E10","v":0},{"$f":"Calculations!L10","v":3.5007897575828339E-4},3.5007897575828339E-4,{"$f":"Calculations!P10","v":-1.4922300862877692E-7},{"$f":"Calculations!Q10","v":1.0000001492230086},{"$f":"Calculations!U10","v":3.5007583042067714E-4},{"$f":"Calculations!AG10","v":4.0707581663101765E-4},null,{"$f":"Calculations!AI10","v":3.4843833764603249E-3},{"$f":"Calculations!AK10","v":0.46223115507129275},{"$f":"Calculations!AO10","v":0.3832149819250158},{"$f":"Calculations!AA10","v":0},{"$f":"Calculations!AE10","v":0},{"$f":"Calculations!AC10","v":0},{"$f":"Calculations!AW10","v":0.5522448654216402},{"$f":"Calculations!AU10","v":2.5821439180327727E-2},0.57806630460196795,"Yes",{"$f":"Sites!E10","v":"Residential"},"No","Moderate surface water and high groudnwater risk"]
[{"$f":"Calculations!A11","v":"P2"},{"$f":"Calculations!B11","v":"Land at North Orbital Road, AL2 1DL"},{"$f":"Calculations!C11","v":1.8820344963073703},{"$f":"Calculations!E11","v":0},{"$f":"Calculations!L11","v":0},0,{"$f":"Calculations!P11","v":0},{"$f":"Calculations!Q11","v":1},{"$f":"Calculations!U11","v":0},{"$f":"Calculations!AG11","v":1.5739657560128111E-2},null,{"$f":"Calculations!AI11","v":3.019110791563108E-2},{"$f":"Calculations!AK11","v":6.6784376749766269E-2},{"$f":"Calculations!AO11","v":6.4790876416245674E-2},{"$f":"Calculations!AA11","v":0},{"$f":"Calculations!AE11","v":0},{"$f":"Calculations!AC11","v":0},{"$f":"Calculations!AW11","v":0},{"$f":"Calculations!AU11","v":0.93992655547138526},0.93992655547138526,"No",{"$f":"Sites!E11","v":"Community Facilites"},"No","High groundwater flood risk"]
[{"$f":"Calculations!A12","v":"B4"},{"$f":"Calculations!B12","v":"East St Albans, AL4 9JJ"},{"$f":"Calculations!C12","v":21.686293049621501},{"$f":"Calculations!E12","v":0},{"$f":"Calculations!L12","v":0},0,{"$f":"Calculations!P12","v":0},{"$f":"Calculations!Q12","v":1},{"$f":"Calculations!U12","v":0},{"$f":"Calculations!AG12","v":2.5205682457578905E-3},null,{"$f":"Calculations!AI12","v":2.0683838154688907E-2},{"$f":"Calculations!AK12","v":8.6772443689928994E-2},{"$f":"Calculations!AO12","v":7.6638666000625119E-2},{"$f":"Calculations!AA12","v":0},{"$f":"Calculations!AE12","v":0},{"$f":"Calculations!AC12","v":0},{"$f":"Calculations!AW12","v":0},{"$f":"Calculations!AU12","v":0.31154706021597134},0.31154706021597134,"Yes",{"$f":"Sites!E12","v":"Residential"},"No","High groundwater and low surface water risk"]
[{"$f":"Calculations!A13","v":"UC46"},{"$f":"Calculations!B13","v":"Garage Blocks adj. to 76 Oakley Road and 151 Grove Road, Harpenden, AL5 1HJ"},{"$f":"Calculations!C13","v":0.11725029144287101},{"$f":"Calculations!E13","v":0},{"$f":"Calculations!L13","v":0},0,{"$f":"Calculations!P13","v":0},{"$f":"Calculations!Q13","v":1},{"$f":"Calculations!U13","v":0},{"$f":"Calculations!AG13","v":4.4092605700959783E-2},null,{"$f":"Calculations!AI13","v":0.11133211822763607},{"$f":"Calculations!AK13","v":0.41311312250679083},{"$f":"Calculations!AO13","v":0.39946789807060651},{"$f":"Calculations!AA13","v":0},{"$f":"Calculations!AE13","v":0},{"$f":"Calculations!AC13","v":0},{"$f":"Calculations!AW13","v":0},{"$f":"Calculations!AU13","v":0},0,"No",{"$f":"Sites!E13","v":"Residential"},"No","High surface water and moderate groundwater risk"]
[{"$f":"Calculations!A14","v":"UC10"},{"$f":"Calculations!B14","v":"Garage Block rear of 109-179 Hughenden Road, St Albans, AL4 9QW"},{"$f":"Calculations!C14","v":0.27078325119018504},{"$f":"Calculations!E14","v":0},{"$f":"Calculations!L14","v":0},0,{"$f":"Calculations!P14","v":0},{"$f":"Calculations!Q14","v":1},{"$f":"Calculations!U14","v":0},{"$f":"Calculations!AG14","v":0},null,{"$f":"Calculations!AI14","v":0},{"$f":"Calculations!AK14","v":0},{"$f":"Calculations!AO14","v":0},{"$f":"Calculations!AA14","v":0},{"$f":"Calculations!AE14","v":0},{"$f":"Calculations!AC14","v":0},{"$f":"Calculations!AW14","v":0},{"$f":"Calculations!AU14","v":1.0000000860602563},1.0000000860602563,"No",{"$f":"Sites!E14","v":"Residential"},"No","High groundwater flood risk"]
[{"$f":"Calculations!A15","v":"UC12"},{"$f":"Calculations!B15","v":"Garage Block Between Hughenden Road and The Ridgeway, St Albans, AL4 9RH"},{"$f":"Calculations!C15","v":0.22188045806884704},{"$f":"Calculations!E15","v":0},{"$f":"Calculations!L15","v":0},0,{"$f":"Calculations!P15","v":0},{"$f":"Calculations!Q15","v":1},{"$f":"Calculations!U15","v":0},{"$f":"Calculations!AG15","v":0},null,{"$f":"Calculations!AI15","v":0},{"$f":"Calculations!AK15","v":5.281825919005187E-4},{"$f":"Calculations!AO15","v":5.2819688836155737E-4},{"$f":"Calculations!AA15","v":0},{"$f":"Calculations!AE15","v":0},{"$f":"Calculations!AC15","v":0},{"$f":"Calculations!AW15","v":0},{"$f":"Calculations!AU15","v":1.0000008937153126},1.0000008937153126,"No",{"$f":"Sites!E15","v":"Residential"},"No","High groundwater flood risk"]
[{"$f":"Calculations!A16","v":"UC27"},{"$f":"Calculations!B16","v":"Berkeley House, Barnet Road, London Colney, AL2 1BG"},{"$f":"Calculations!C16","v":0.14452916183471601},{"$f":"Calculations!E16","v":0},{"$f":"Calculations!L16","v":0},0,{"$f":"Calculations!P16","v":0.19666417259001848},{"$f":"Calculations!Q16","v":0.80333582740998155},{"$f":"Calculations!U16","v":0},{"$f":"Calculations!AG16","v":0},null,{"$f":"Calculations!AI16","v":0},{"$f":"Calculations!AK16","v":1.3245578055748377E-5},{"$f":"Calculations!AO16","v":1.3247873062757545E-5},{"$f":"Calculations!AA16","v":0.19666342744596291},{"$f":"Calculations!AE16","v":6.1245365831820693E-3},{"$f":"Calculations!AC16","v":0},{"$f":"Calculations!AW16","v":0},{"$f":"Calculations!AU16","v":0},0,"No",{"$f":"Sites!E16","v":"Residential"},"No","Moderate fluvial and groundwater risk"]
[{"$f":"Calculations!A17","v":"UC39"},{"$f":"Calculations!B17","v":"Garage Block to east of 8 Heath Close, Harpenden, AL5 1QN"},{"$f":"Calculations!C17","v":0.12762859039306601},{"$f":"Calculations!E17","v":0},{"$f":"Calculations!L17","v":0},0,{"$f":"Calculations!P17","v":0},{"$f":"Calculations!Q17","v":1},{"$f":"Calculations!U17","v":0},{"$f":"Calculations!AG17","v":0.12617256782924541},null,{"$f":"Calculations!AI17","v":0.3287234380783467},{"$f":"Calculations!AK17","v":0.95204193891458544},{"$f":"Calculations!AO17","v":0.91041821507621878},{"$f":"Calculations!AA17","v":0},{"$f":"Calculations!AE17","v":0},{"$f":"Calculations!AC17","v":0},{"$f":"Calculations!AW17","v":0},{"$f":"Calculations!AU17","v":0},0,"No",{"$f":"Sites!E17","v":"Residential"},"No","High surface water flood risk"]
[{"$f":"Calculations!A18","v":"UC43"},{"$f":"Calculations!B18","v":"Garage block to west of 32-46 Riverside Road, St Albans, AL1 1SD"},{"$f":"Calculations!C18","v":6.0495068359375001E-2},{"$f":"Calculations!E18","v":0},{"$f":"Calculations!L18","v":0},0,{"$f":"Calculations!P18","v":0},{"$f":"Calculations!Q18","v":1},{"$f":"Calculations!U18","v":0},{"$f":"Calculations!AG18","v":0},null,{"$f":"Calculations!AI18","v":0.52018727626119043},{"$f":"Calculations!AK18","v":0.8869751518785467},{"$f":"Calculations!AO18","v":0.81268393500261893},{"$f":"Calculations!AA18","v":0},{"$f":"Calculations!AE18","v":0},{"$f":"Calculations!AC18","v":0},{"$f":"Calculations!AW18","v":0},{"$f":"Calculations!AU18","v":0},0,"No",{"$f":"Sites!E18","v":"Residential"},"No","High surface water flood risk"]
[{"$f":"Calculations!A19","v":"UC17"},{"$f":"Calculations!B19","v":"Garage Block off Cotlandswick, London Colney, AL2 1ED"},{"$f":"Calculations!C19","v":0.11367665710449201},{"$f":"Calculations!E19","v":0},{"$f":"Calculations!L19","v":0},0,{"$f":"Calculations!P19","v":0},{"$f":"Calculations!Q19","v":1},{"$f":"Calculations!U19","v":0},{"$f":"Calculations!AG19","v":0},null,{"$f":"Calculations!AI19","v":9.847179938247641E-2},{"$f":"Calculations!AK19","v":0.57500441524042911},{"$f":"Calculations!AO19","v":0.55851115750506153},{"$f":"Calculations!AA19","v":0},{"$f":"Calculations!AE19","v":0},{"$f":"Calculations!AC19","v":0},{"$f":"Calculations!AW19","v":0},{"$f":"Calculations!AU19","v":0.76826540395883736},{"$f":"R28+S28","v":0.76826540395883736},"No",{"$f":"Sites!E19","v":"Residential"},"No","Moderate risk of all sources of flooding"]
[{"$f":"Calculations!A20","v":"UC32"},{"$f":"Calculations!B20","v":"Garages off Creighton Avenue, St Albans, AL1 2LZ"},{"$f":"Calculations!C20","v":0.13985213088989201},{"$f":"Calculations!E20","v":0},{"$f":"Calculations!L20","v":0},0,{"$f":"Calculations!P20","v":0},{"$f":"Calculations!Q20","v":1},{"$f":"Calculations!U20","v":0},{"$f":"Calculations!AG20","v":0},null,{"$f":"Calculations!AI20","v":0.1430081892405797},{"$f":"Calculations!AK20","v":0.36772859345849485},{"$f":"Calculations!AO20","v":0.34508364684882181},{"$f":"Calculations!AA20","v":0},{"$f":"Calculations!AE20","v":0},{"$f":"Calculations!AC20","v":0},{"$f":"Calculations!AW20","v":0},{"$f":"Calculations!AU20","v":0},0,"No",{"$f":"Sites!E20","v":"Residential"},"No","Moderate surface water flood risk"]
[{"$f":"Calculations!A21","v":"UC26"},{"$f":"Calculations!B21","v":"Garage Block to Malvern Close, St Albans, AL4 9SZ"},{"$f":"Calculations!C21","v":0.13236847610473601},{"$f":"Calculations!E21","v":0},{"$f":"Calculations!L21","v":0},0,{"$f":"Calculations!P21","v":0},{"$f":"Calculations!Q21","v":1},{"$f":"Calculations!U21","v":0},{"$f":"Calculations!AG21","v":0},null,{"$f":"Calculations!AI21","v":0},{"$f":"Calculations!AK21","v":0},{"$f":"Calculations!AO21","v":0},{"$f":"Calculations!AA21","v":0},{"$f":"Calculations!AE21","v":0},{"$f":"Calculations!AC21","v":0},{"$f":"Calculations!AW21","v":0},{"$f":"Calculations!AU21","v":0.99999971222204775},0.99999971222204775,"No",{"$f":"Sites!E21","v":"Residential"},"No","High groundwater flood risk"]
[{"$f":"Calculations!A22","v":"UC24"},{"$f":"Calculations!B22","v":"Garages Rear of Hill End Lane (North), St Albans, AL4 0AE"},{"$f":"Calculations!C22","v":0.20767036819457999},{"$f":"Calculations!E22","v":0},{"$f":"Calculations!L22","v":0},0,{"$f":"Calculations!P22","v":0},{"$f":"Calculations!Q22","v":1},{"$f":"Calculations!U22","v":0},{"$f":"Calculations!AG22","v":0.2898054447243969},null,{"$f":"Calculations!AI22","v":0.40991523741482999},{"$f":"Calculations!AK22","v":0.61224560507456349},{"$f":"Calculations!AO22","v":0.59285319144929061},{"$f":"Calculations!AA22","v":0},{"$f":"Calculations!AE22","v":0},{"$f":"Calculations!AC22","v":0},{"$f":"Calculations!AW22","v":0},{"$f":"Calculations!AU22","v":0},0,"No",{"$f":"Sites!E22","v":"Residential"},"No","High surface water flood risk"]
[{"$f":"Calculations!A23","v":"UC36"},{"$f":"Calculations!B23","v":"Garages off Park Street Lane, Park Street, AL2 2ND"},{"$f":"Calculations!C23","v":0.128678628540039},{"$f":"Calculations!E23","v":0},{"$f":"Calculations!L23","v":0},0,{"$f":"Calculations!P23","v":0},{"$f":"Calculations!Q23","v":1},{"$f":"Calculations!U23","v":0},{"$f":"Calculations!AG23","v":0},null,{"$f":"Calculations!AI23","v":0.19987531935724118},{"$f":"Calculations!AK23","v":0.43259083760509615},{"$f":"Calculations!AO23","v":0.44282001849988423},{"$f":"Calculations!AA23","v":0},{"$f":"Calculations!AE23","v":0},{"$f":"Calculations!AC23","v":0},{"$f":"Calculations!AW23","v":0},{"$f":"Calculations!AU23","v":0},0,"No",{"$f":"Sites!E23","v":"Residential"},"No","Moderate surface water flood risk"]
[{"$f":"Calculations!A24","v":"UC49"},{"$f":"Calculations!B24","v":"Garage Block rear of 18-30 Furse Avenue, St Albans, AL4 9NE"},{"$f":"Calculations!C24","v":0.11884348373413001},{"$f":"Calculations!E24","v":0},{"$f":"Calculations!L24","v":0},0,{"$f":"Calculations!P24","v":0},{"$f":"Calculations!Q24","v":1},{"$f":"Calculations!U24","v":0},{"$f":"Calculations!AG24","v":0},null,{"$f":"Calculations!AI24","v":0},{"$f":"Calculations!AK24","v":9.7489355217477423E-4},{"$f":"Calculations!AO24","v":9.7486405112784391E-4},{"$f":"Calculations!AA24","v":0},{"$f":"Calculations!AE24","v":0},{"$f":"Calculations!AC24","v":0},{"$f":"Calculations!AW24","v":0},{"$f":"Calculations!AU24","v":1.0000010142268234},1.0000010142268234,"No",{"$f":"Sites!E24","v":"Residential"},"No","High groundwater flood risk"]
[{"$f":"Calculations!A25","v":"UC8"},{"$f":"Calculations!B25","v":"Public Hall, 6 Southdown Road, Harpenden, AL5 1TE"},{"$f":"Calculations!C25","v":0.26365607223510701},{"$f":"Calculations!E25","v":0},{"$f":"Calculations!L25","v":0},0,{"$f":"Calculations!P25","v":0},{"$f":"Calculations!Q25","v":1},{"$f":"Calculations!U25","v":0},{"$f":"Calculations!AG25","v":7.1658347574692013E-2},null,{"$f":"Calculations!AI25","v":0.1623667727778374},{"$f":"Calculations!AK25","v":0.38849936216644415},{"$f":"Calculations!AO25","v":0.37573073399176932},{"$f":"Calculations!AA25","v":0},{"$f":"Calculations!AE25","v":0},{"$f":"Calculations!AC25","v":0},{"$f":"Calculations!AW25","v":0},{"$f":"Calculations!AU25","v":0},0,"No",{"$f":"Sites!E25","v":"Residential"},"No","High surface water and moderate groundwater risk"]
[{"$f":"Calculations!A26","v":"OS1"},{"$f":"Calculations!B26","v":"Land to the North of Bricket Wood, bounded by the M25 and A405 North Orbital"},{"$f":"Calculations!C26","v":6.5234667686462409},{"$f":"Calculations!E26","v":0},{"$f":"Calculations!L26","v":0},0,{"$f":"Calculations!P26","v":0},{"$f":"Calculations!Q26","v":1},{"$f":"Calculations!U26","v":0},{"$f":"Calculations!AG26","v":1.3478895263222991E-2},null,{"$f":"Calculations!AI26","v":4.1669577190602526E-2},{"$f":"Calculations!AK26","v":0.12787148078429533},{"$f":"Calculations!AO26","v":0.11866743669077189},{"$f":"Calculations!AA26","v":0},{"$f":"Calculations!AE26","v":0},{"$f":"Calculations!AC26","v":0},{"$f":"Calculations!AW26","v":7.0273154893523884E-2},{"$f":"Calculations!AU26","v":0.54503031732409513},{"$f":"R35+S35","v":0.61530347221761905},"No",{"$f":"Sites!E26","v":"Residential"},"No","High groundwater risk and low surface water risk and "]
[null,{"$f":"Calculations!B27","v":"Harpenden Station Car Park"},{"$f":"Calculations!C27","v":1.2443619270324699},{"$f":"Calculations!E27","v":0},{"$f":"Calculations!L27","v":0},0,{"$f":"Calculations!P27","v":0},{"$f":"Calculations!Q27","v":1},{"$f":"Calculations!U27","v":0},{"$f":"Calculations!AG27","v":0},null,{"$f":"Calculations!AI27","v":1.3334709262856867E-2},{"$f":"Calculations!AK27","v":0.11610116572938767},{"$f":"Calculations!AO27","v":0.10435666035651021},{"$f":"Calculations!AA27","v":0},{"$f":"Calculations!AE27","v":0},{"$f":"Calculations!AC27","v":0},{"$f":"Calculations!AW27","v":0},{"$f":"Calculations!AU27","v":0},0,"No",{"$f":"Sites!E27","v":"Residential"},"No","Moderate surface water flood risk"]
[null,{"$f":"Calculations!B28","v":"44 – 52 Lattimore Road, St Albans"},{"$f":"Calculations!C28","v":0.11373912200927701},{"$f":"Calculations!E28","v":0},{"$f":"Calculations!L28","v":0},0,{"$f":"Calculations!P28","v":0},{"$f":"Calculations!Q28","v":1},{"$f":"Calculations!U28","v":0},{"$f":"Calculations!AG28","v":4.0761469525725423E-2},null,{"$f":"Calculations!AI28","v":0.14803539021060122},{"$f":"Calculations!AK28","v":0.6176195869688148},{"$f":"Calculations!AO28","v":0.5232101947035126},{"$f":"Calculations!AA28","v":0},{"$f":"Calculations!AE28","v":0},{"$f":"Calculations!AC28","v":0},{"$f":"Calculations!AW28","v":0},{"$f":"Calculations!AU28","v":0},0,"No",{"$f":"Sites!E28","v":"Residential"},"No","High surface water flood risk"]
[null,{"$f":"Calculations!B29","v":"Car Park to the rear of Portman House, Therfield Road St Albans"},{"$f":"Calculations!C29","v":0.140915162658691},{"$f":"Calculations!E29","v":0},{"$f":"Calculations!L29","v":0},0,{"$f":"Calculations!P29","v":0},{"$f":"Calculations!Q29","v":1},{"$f":"Calculations!U29","v":0},{"$f":"Calculations!AG29","v":0},null,{"$f":"Calculations!AI29","v":0},{"$f":"Calculations!AK29","v":0.36994348681831812},{"$f":"Calculations!AO29","v":0.33962294762040524},{"$f":"Calculations!AA29","v":0},{"$f":"Calculations!AE29","v":0},{"$f":"Calculations!AC29","v":0},{"$f":"Calculations!AW29","v":0},{"$f":"Calculations!AU29","v":0},0,"No",{"$f":"Sites!E29","v":"Residential"},"No","Moderate surface water flood risk"]
[null,{"$f":"Calculations!B30","v":"Garage Block B off Cotlandswick, London Colney"},{"$f":"Calculations!C30","v":0.11847633285522401},{"$f":"Calculations!E30","v":0},{"$f":"Calculations!L30","v":0},0,{"$f":"Calculations!P30","v":0},{"$f":"Calculations!Q30","v":1},{"$f":"Calculations!U30","v":0},{"$f":"Calculations!AG30","v":0.10444082247899102},null,{"$f":"Calculations!AI30","v":0.30726568265317677},{"$f":"Calculations!AK30","v":0.43861574409691712},{"$f":"Calculations!AO30","v":0.40147751770659301},{"$f":"Calculations!AA30","v":0},{"$f":"Calculations!AE30","v":0},{"$f":"Calculations!AC30","v":0},{"$f":"Calculations!AW30","v":0},{"$f":"Calculations!AU30","v":1.000000023375943},1.000000023375943,"No",{"$f":"Sites!E30","v":"Residential"},"No","High surface water and groundwater risk"]
[null,{"$f":"Calculations!B31","v":"186 Sandridge Road, St Albans"},{"$f":"Calculations!C31","v":0.193903894805908},{"$f":"Calculations!E31","v":0},{"$f":"Calculations!L31","v":0},0,{"$f":"Calculations!P31","v":0},{"$f":"Calculations!Q31","v":1},{"$f":"Calculations!U31","v":0},{"$f":"Calculations!AG31","v":0},null,{"$f":"Calculations!AI31","v":9.1641427274761903E-5},{"$f":"Calculations!AK31","v":0.11575263463120408},{"$f":"Calculations!AO31","v":8.6577362211604753E-2},{"$f":"Calculations!AA31","v":0},{"$f":"Calculations!AE31","v":0},{"$f":"Calculations!AC31","v":0},{"$f":"Calculations!AW31","v":0},{"$f":"Calculations!AU31","v":0},0,"No",{"$f":"Sites!E31","v":"Residential"},"No","Significant surface water flow path on site"]
[null,{"$f":"Calculations!B32","v":"Motor Repair Garage, Park Street Lane, Park Street"},{"$f":"Calculations!C32","v":0.29229255981445301},{"$f":"Calculations!E32","v":0},{"$f":"Calculations!L32","v":0},0,{"$f":"Calculations!P32","v":0},{"$f":"Calculations!Q32","v":1},{"$f":"Calculations!U32","v":0},{"$f":"Calculations!AG32","v":0.15087516925551214},null,{"$f":"Calculations!AI32","v":0.21986495792456193},{"$f":"Calculations!AK32","v":0.33250145747329268},{"$f":"Calculations!AO32","v":0.37650473514988314},{"$f":"Calculations!AA32","v":0},{"$f":"Calculations!AE32","v":0},{"$f":"Calculations!AC32","v":0},{"$f":"Calculations!AW32","v":0},{"$f":"Calculations!AU32","v":6.7245495248268367E-2},6.7245495248268367E-2,"No",{"$f":"Sites!E32","v":"Residential"},"No","High surface water and moderate groundwater risk"]
[null,{"$f":"Calculations!B33","v":"Griffiths Way Retail Park, St Albans AL1 2RJ"},{"$f":"Calculations!C33","v":6.4355016853332501},{"$f":"Calculations!E33","v":0},{"$f":"Calculations!L33","v":0},0,{"$f":"Calculations!P33","v":0},{"$f":"Calculations!Q33","v":1},{"$f":"Calculations!U33","v":0},{"$f":"Calculations!AG33","v":4.7548740558546583E-2},null,{"$f":"Calculations!AI33","v":9.7629746998537825E-2},{"$f":"Calculations!AK33","v":0.26259732423540649},{"$f":"Calculations!AO33","v":0.24676131443566188},{"$f":"Calculations!AA33","v":0},{"$f":"Calculations!AE33","v":0},{"$f":"Calculations!AC33","v":0},{"$f":"Calculations!AW33","v":0},{"$f":"Calculations!AU33","v":0},0,"No",{"$f":"Sites!E33","v":"Residential"},"No","Moderate surface water and groundwater risk"]
[null,{"$f":"Calculations!B34","v":"Affinity Water, 107 Holywell Hill Road St Albans"},{"$f":"Calculations!C34","v":1.22304419784545},{"$f":"Calculations!E34","v":0.18896698544773183},{"$f":"Calculations!L34","v":0.12205240604164425},0.31101939148937607,{"$f":"Calculations!P34","v":0.3533649252511728},{"$f":"Calculations!Q34","v":0.6466350747488272},{"$f":"Calculations!U34","v":0.38184759868868012},{"$f":"Calculations!AG34","v":0.11374686561961482},null,{"$f":"Calculations!AI34","v":0.23298682358061445},{"$f":"Calculations!AK34","v":0.75240437395630977},{"$f":"Calculations!AO34","v":0.69235331081303264},{"$f":"Calculations!AA34","v":0},{"$f":"Calculations!AE34","v":0.12049834657036328},{"$f":"Calculations!AC34","v":0.859742138846329},{"$f":"Calculations!AW34","v":0.62592857420976644},{"$f":"Calculations!AU34","v":2.7109313354939071E-2},0.65303788756470549,"No",{"$f":"Sites!E34","v":"Residential"},"No","High risk of fluvial, surface water and groundwater risk"]
[null,{"$f":"Calculations!B35","v":"50 - 54 Lemsford Road St Albans"},{"$f":"Calculations!C35","v":0.53290887999967607},{"$f":"Calculations!E35","v":0},{"$f":"Calculations!L35","v":0},0,{"$f":"Calculations!P35","v":0},{"$f":"Calculations!Q35","v":1},{"$f":"Calculations!U35","v":0},{"$f":"Calculations!AG35","v":0},null,{"$f":"Calculations!AI35","v":9.0844078511609395E-3},{"$f":"Calculations!AK35","v":5.4524891110988551E-2},{"$f":"Calculations!AO35","v":5.3714878050097802E-2},{"$f":"Calculations!AA35","v":0},{"$f":"Calculations!AE35","v":0},{"$f":"Calculations!AC35","v":0},{"$f":"Calculations!AW35","v":0},{"$f":"Calculations!AU35","v":0},0,"No",{"$f":"Sites!E35","v":"Residential"},"Yes","Significant surface water flow path on site"]
[null,{"$f":"Calculations!B36","v":"Ariston Works"},{"$f":"Calculations!C36","v":2.5174498884538603},{"$f":"Calculations!E36","v":0},{"$f":"Calculations!L36","v":0},0,{"$f":"Calculations!P36","v":0},{"$f":"Calculations!Q36","v":1},{"$f":"Calculations!U36","v":0},{"$f":"Calculations!AG36","v":6.9912017239037779E-3},null,{"$f":"Calculations!AI36","v":9.0567840514208034E-3},{"$f":"Calculations!AK36","v":5.0995555044016094E-2},{"$f":"Calculations!AO36","v":2.8583516399016431E-2},{"$f":"Calculations!AA36","v":0},{"$f":"Calculations!AE36","v":0},{"$f":"Calculations!AC36","v":0},{"$f":"Calculations!AW36","v":0},{"$f":"Calculations!AU36","v":0},0,"No",{"$f":"Sites!E36","v":"Residential with community facilities and primary school"},"Yes","Surface Water ponding at lower lying parts of the site "]
[null,{"$f":"Calculations!B37","v":"Car Park and Garage Block to rear of Telford Court Alma Road St Albans"},{"$f":"Calculations!C37","v":0.48452990035880306},{"$f":"Calculations!E37","v":0},{"$f":"Calculations!L37","v":0},0,{"$f":"Calculations!P37","v":0},{"$f":"Calculations!Q37","v":1},{"$f":"Calculations!U37","v":0},{"$f":"Calculations!AG37","v":3.0091475784124336E-3},null,{"$f":"Calculations!AI37","v":3.8494373298789818E-2},{"$f":"Calculations!AK37","v":5.2959489340416097E-2},{"$f":"Calculations!AO37","v":5.279830717534275E-2},{"$f":"Calculations!AA37","v":0},{"$f":"Calculations!AE37","v":0},{"$f":"Calculations!AC37","v":0},{"$f":"Calculations!AW37","v":0},{"$f":"Calculations!AU37","v":0},0,"No",{"$f":"Sites!E37","v":"Residential"},"Yes","Surface Water ponding at lower lying parts of the site"]
[null,{"$f":"Calculations!B38","v":"52 Victoria Street and 16 New Kent Road, St Albans"},{"$f":"Calculations!C38","v":5.6000000000000001E-2},{"$f":"Calculations!E38","v":0},{"$f":"Calculations!L38","v":0},0,{"$f":"Calculations!P38","v":0},{"$f":"Calculations!Q38","v":1},{"$f":"Calculations!U38","v":0},{"$f":"Calculations!AG38","v":0},null,{"$f":"Calculations!AI38","v":0},{"$f":"Calculations!AK38","v":0},{"$f":"Calculations!AO38","v":0},{"$f":"Calculations!AA38","v":0},{"$f":"Calculations!AE38","v":0},{"$f":"Calculations!AC38","v":0},{"$f":"Calculations!AW38","v":0},{"$f":"Calculations!AU38","v":0},0,"No",{"$f":"Sites!E38","v":"Residential"},"Yes","Not taken forward for Level 2"]
[null,{"$f":"Calculations!B39","v":"Brethrens Meeting Hall Blackwater Lane"},{"$f":"Calculations!C39","v":1.655},{"$f":"Calculations!E39","v":0},{"$f":"Calculations!L39","v":0},0,{"$f":"Calculations!P39","v":0},{"$f":"Calculations!Q39","v":1},{"$f":"Calculations!U39","v":0},{"$f":"Calculations!AG39","v":0},null,{"$f":"Calculations!AI39","v":0},{"$f":"Calculations!AK39","v":0},{"$f":"Calculations!AO39","v":0},{"$f":"Calculations!AA39","v":0},{"$f":"Calculations!AE39","v":0},{"$f":"Calculations!AC39","v":0},{"$f":"Calculations!AW39","v":0},{"$f":"Calculations!AU39","v":0},0,"No",{"$f":"Sites!E39","v":"Residential"},"Yes","Not taken forward for Level 2"]
[null,{"$f":"Calculations!B40","v":"Petrol Filling Station 551 Watford Road Chiswell Green"},{"$f":"Calculations!C40","v":0.69},{"$f":"Calculations!E40","v":0},{"$f":"Calculations!L40","v":0},0,{"$f":"Calculations!P40","v":0},{"$f":"Calculations!Q40","v":1},{"$f":"Calculations!U40","v":0},{"$f":"Calculations!AG40","v":0},null,{"$f":"Calculations!AI40","v":0},{"$f":"Calculations!AK40","v":5.0000000000000001E-3},{"$f":"Calculations!AO40","v":4.7529027369995515E-3},{"$f":"Calculations!AA40","v":0},{"$f":"Calculations!AE40","v":0},{"$f":"Calculations!AC40","v":0},{"$f":"Calculations!AW40","v":0},{"$f":"Calculations!AU40","v":0},0,"No",{"$f":"Sites!E40","v":"Residential"},"Yes","Not taken forward for Level 2"]
[null,{"$f":"Calculations!B41","v":"Telephone Exchange Bowers Way Harpenden AL5 4EP"},{"$f":"Calculations!C41","v":0.219},{"$f":"Calculations!E41","v":0},{"$f":"Calculations!L41","v":0},0,{"$f":"Calculations!P41","v":0},{"$f":"Calculations!Q41","v":1},{"$f":"Calculations!U41","v":0},{"$f":"Calculations!AG41","v":0},null,{"$f":"Calculations!AI41","v":0},{"$f":"Calculations!AK41","v":2E-3},{"$f":"Calculations!AO41","v":3.1687047904920503E-2},{"$f":"Calculations!AA41","v":0},{"$f":"Calculations!AE41","v":0},{"$f":"Calculations!AC41","v":0},{"$f":"Calculations!AW41","v":0},{"$f":"Calculations!AU41","v":0},0,"No",{"$f":"Sites!E41","v":"Residential"},"Yes","Not taken forward for Level 2"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(T11:T50,\">0\")","v":19}]

{"sheet":"Calculations","index":2,"n_rows":41,"n_cols":66,"rows_kept":41,"cut":false,"hidden":false,"merged":[]}
["Site Code","Name","Site (ha)","FZ3b (ha)","FZ3b (%)","FZ3b +21% CC (ha)","FZ3b +21% CC (%)","FZ3b +35% CC (ha)","FZ3b +35% CC (%)","FZ3a (ha)","FZ3a (%)","FZ3a only (%)","FZ2 (ha)","FZ2 (%)",null,"FZ2 only (%)","FZ1 (%)","FZ3a+CC21% (ha)","FZ3a+CC 21% (%)","FZ3a+CC 35% (ha)","FZ3a+CC 35% (%)","FZ2+CC21% (ha)","FZ2+CC21% (%)","FZ2+CC35% (ha)","FZ2+CC35% (%)","HFM (ha)","HFM (%)","RES_WET (ha)","RES_WET (%)","RES_DRY (ha)","RES_DRY (%)","SW30 (ha)","SW30 (%)","SW100 (ha)","SW100 (%)","SW1000 (ha)","SW1000 (%)","SW30 +CC (ha)","SW30 +CC (%)","SW100 +CC (ha)","SW100 +CC (%)","Groundwater Cat 1 (>5m below ground in 1 in 100-year) ",null,"Groundwater Cat 2 (0.5 - 5m below ground in 1 in 100-year) ",null,"Groundwater Cat 3 (0.025 - 0.5m below ground in 1 in 100-year) ",null,"Groundwater Cat 4 (<0.025m below ground in 1 in 100-year) ",null,"Total groundwater in Cat 3 or 4","RoFRS_High _<30yr Only (ha)","RoFRS_High Only (%)","RoFRS_Med _30yr to 100yr Only (ha)","RoFRS_Med Only (%)","RoFRS_Low 100yr to 1000yr Only (ha)","RoFRS_Low Only (%)","RoFRS_Very Low (>1000yr) Only (%)","RoFRS_Very Low (%)","Historic Landfill (ha)","Historic_Landfill (%)","SPZ1 (ha)","SPZ1 (%)","SPZ2 (ha)","SPZ2 (%)","SPZ3 (ha)","SPZ3 (%)"]
["B3","West Redbourn, Redbourn, AL3 7HZ",27.017108634948702,0,{"$f":"D2/C2","v":0},0,{"$f":"F2/C2","v":0},0,{"$f":"H2/C2","v":0},0,{"$f":"J2/C2","v":0},{"$f":"K2-E2","v":0},0,{"$f":"M2/C2","v":0},null,{"$f":"N2-K2","v":0},{"$f":"100%-P2","v":1},0,{"$f":"R2/C2","v":0},0,{"$f":"T2/C2","v":0},0,{"$f":"V2/C2","v":0},0,{"$f":"X2/C2","v":0},0,{"$f":"Z2/C2","v":0},0.19035877465753301,{"$f":"AB2/C2","v":7.0458603557336016E-3},0.137004174420048,{"$f":"AD2/C2","v":5.0710154173501231E-3},0.33602830991326404,{"$f":"AF2/C2","v":1.2437611827883967E-2},0.62562584554699896,{"$f":"AH2/C2","v":2.3156654325981574E-2},1.52576788482092,{"$f":"AJ2/C2","v":5.6474136645666896E-2},0.90276976216441096,{"$f":"AL2/C2","v":3.3414743759686005E-2},1.46208017727068,{"$f":"AN2/C2","v":5.411682637939158E-2},0.89263780438862395,{"$f":"AP2/C2","v":3.3039723696929153E-2},25.684012077895002,{"$f":"AR2/C2","v":0.9506573195871435},0.15942429718380199,{"$f":"AT2/C2","v":5.9008644980453034E-3},0,{"$f":"AV2/C2","v":0},{"$f":"AU2+AW2","v":5.9008644980453034E-3},0,{"$f":"AY2/C2","v":0},0,{"$f":"BA2/C2","v":0},0,{"$f":"BC2/C2","v":0},0,{"$f":"BE2/C2","v":0},0,{"$f":"BG2/C2","v":0},0,{"$f":"BI2/C2","v":0},0,{"$f":"BK2/C2","v":0},27.017108829462501,{"$f":"BM2/C2","v":1.0000000071996527}]
["M25","Baulk Close, Harpenden, AL5 4LY",0.555620455932617,1.47108348027849E-2,2.6476409652867353E-2,1.47108348027849E-2,2.6476409652867353E-2,1.47108348027849E-2,2.6476409652867353E-2,1.4703094682010399E-2,2.6462479062854233E-2,{"$f":"K3-E3","v":-1.3930590013120497E-5},0.11550728574852499,0.2078888286332877,null,{"$f":"N3-K3","v":0.18142634957043346},{"$f":"100%-P3","v":0.81857365042956654},0.115506964444858,0.20788825035424205,0.115506964444858,0.20788825035424205,0.115506964444858,0.20788825035424205,0.115506964444858,0.20788825035424205,0,{"$f":"Z3/C3","v":0},7.9574718317538901E-2,{"$f":"AB3/C3","v":0.14321776217538928},3.01178568877256E-2,{"$f":"AD3/C3","v":5.4205810038387335E-2},0,{"$f":"AF3/C3","v":0},2.7705611664219699E-3,{"$f":"AH3/C3","v":4.9864275817051102E-3},4.8588539135758703E-2,8.7449154574775576E-2,7.8774459151277499E-3,{"$f":"AL3/C3","v":1.4177746393273702E-2},3.3849855659057002E-2,{"$f":"AN3/C3","v":6.0922623164115744E-2},0,{"$f":"AP3/C3","v":0},0.52428576719817699,{"$f":"AR3/C3","v":0.94360414847965901},2.4607834199136602E-2,{"$f":"AT3/C3","v":4.4288927695853089E-2},6.7274621060248504E-3,{"$f":"AV3/C3","v":1.2108017324043097E-2},{"$f":"AU3+AW3","v":5.6396945019896186E-2},0,{"$f":"AY3/C3","v":0},7.4834795460275411E-2,{"$f":"BA3/C3","v":0.13468689761370309},4.0670425284323998E-2,{"$f":"BC3/C3","v":7.3198214446691126E-2},3.7962176439191898E-2,{"$f":"BE3/C3","v":6.8323935941976499E-2},0,{"$f":"BG3/C3","v":0},0,{"$f":"BI3/C3","v":0},0,{"$f":"BK3/C3","v":0},0.55562100682099003,{"$f":"BM3/C3","v":1.0000009914832457}]
["M6","South of Harpenden Lane, Redbourn, AL3 7RQ",12.5641147644042,1.0503231444280801,8.359706705352489E-2,1.0857062726680999,8.6413272484906739E-2,1.2233552892142101,9.7368999898037989E-2,1.6354798608085801,0.13017071966280594,4.6573652609281049E-2,3.59816778365713,0.2863845046887995,null,0.15621378502599356,0.84378621497400641,2.42825814906961,0.19326933847732644,3.0774554291465401,0.24494009222721991,3.8258898519270699,0.30450930476744148,4.1251266681337899,0.32832608946082054,0,0,4.26710299178393,0.33962623486003146,0,0,2.0743710768226,0.16510284375144102,2.8039779616926803,0.22317353942330428,5.1701080666799202,0.4114979975610793,3.6355700890307898,0.28936141998088405,4.9095226119847402,0.39075754273544744,0,0,4.5451381221379199,0.36175554007313732,1.5494369385814,0.12332241209473506,6.4695410700158096,0.5149221565808102,0.63824456867554524,0.76139751883441409,6.0600968163037956E-2,0.47214624209811501,3.7578950125142743E-2,2.3632952883815599,0.18809883009641779,1.3271557883607699E-2,1.0563066425664765E-3,0,0,0,0,0,0,12.5641162038934,1.0000001145714781]
["M5","Sewage Treatment Works, Piggottshill Lane, Harpenden, AL5 5UN",4.0995474700927703,0,0,0,0,0,0,0,0,0,0,0,null,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0.12791301192849602,3.1201739426522955E-2,0.457013599834597,0.11147903595912137,1.10425949121294,0.26936131347881459,0.84725764583055796,0.2066710172309299,1.1026064891313101,0.26895809773520168,0.29423421327414401,7.1772364003748354E-2,3.8053128744782101,0.92822754273219776,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,4.0995472989465798,0.99999995825241883]
["M26","Highway Chipping Depot, Lower Luton Road, AL4 8JJ",0.33922189636230404,8.7689723662759704E-4,2.5850254539318768E-3,8.7689723662759704E-4,2.5850254539318768E-3,8.7689723662759704E-4,2.5850254539318768E-3,8.7455468776823499E-4,2.5781198004806026E-3,-6.9056534512741859E-6,0.10916651847591501,0.32181448086511583,null,0.31923636106463521,0.68076363893536485,0.109166611101679,0.3218147539187276,0.109166611101679,0.3218147539187276,0.109166611101679,0.3218147539187276,0.109166611101679,0.3218147539187276,0,0,7.4054470401857904E-3,2.1830686991609893E-2,1.78990722167476E-3,5.2765085062877531E-3,2.98244178629829E-6,8.792008470800216E-6,4.1178559989930305E-4,1.2139122041210976E-3,2.8842374666583001E-3,8.5025097070320198E-3,7.6214223962437497E-4,2.2467365691817643E-3,1.9664060980900001E-3,5.7968135877342983E-3,0,0,0.26117583822620499,0.76992623715321018,2.1879168652524601E-2,6.4498102531555565E-2,5.6167008546724198E-2,0.16557601130422117,0.23007411383577675,7.6689239809682702E-2,0.22607396701707955,2.7547964904998098E-2,8.1209276878682526E-2,4.73666677805714E-3,1.3963328514024253E-2,0,0,0,0,0.33922200886341602,1.0000003316446056,0.33922200886341602,1.0000003316446056,0.33922200886341602,1.0000003316446056]
["M20","Lower Luton Road, Harpenden, AL5 5AF",0.73588062286376899,3.6110875041119699E-3,4.9071648198304009E-3,3.6110875041119699E-3,4.9071648198304009E-3,3.6110875041119699E-3,4.9071648198304009E-3,3.6206605439038E-3,4.9201737773900862E-3,1.3008957559685307E-5,1.6592709135598599E-2,2.2548098998756146E-2,null,1.762792522136606E-2,0.98237207477863397,1.6592698740772901E-2,2.2548084873060516E-2,1.6592698740772901E-2,2.2548084873060516E-2,1.6592698740772901E-2,2.2548084873060516E-2,1.6592698740772901E-2,2.2548084873060516E-2,0,0,0.13112662124359001,0.17819007209796447,1.9669013607622399E-2,2.6728538565233637E-2,0,0,0,0,1.16670952662825E-2,1.5854603183976471E-2,3.3583109708354999E-3,4.5636627280199659E-3,1.8433100730678501E-2,2.5049036702371436E-2,0,0,0.236244674222443,0.321036682965055,7.2775365883741297E-2,9.8895613802857191E-2,0.42686088330658301,0.5800681116529498,0.67896372545580697,0,0,1.4149592444634299E-2,1.9228108479836633E-2,2.4431383096867199E-3,3.3200198969487059E-3,0,0,0,0,0,0,0,0,0.73588067132479695,1.0000000658544694]
["B5","Glinwell, Hatfield Road, St Albans, AL4 0HE",20.847097465515098,0,0,0,0,0,0,2.3175993797782999,0.11117132174452736,0.11117132174452736,2.8359682015198602,0.13603659723906739,null,2.4865275494540026E-2,0.97513472450546002,2.3175995174551702,0.11117132834865394,2.3175995174551702,0.11117132834865394,2.83596795676972,0.1360365854988172,2.83596795676972,0.1360365854988172,0,0,0,0,0,0,0.516773652737193,2.478875793582444E-2,1.0566622286329701,5.0686299633840255E-2,5.3348997887455107,0.25590611822918791,2.1120912326401902,0.1013134435685339,4.6857911917961497,0.22476947688028528,0,0,0,0,1.71243806921567,8.2142757381374304E-2,6.0516445908010104,0.29028715392210042,0.37242991130347469,0.70657091038447095,3.389301131983808E-2,2.1282952447480299,0.10209072261827425,0,0,0,0,0,0,0,0,19.5580143866189,0.93816486534739063,20.847097499382802,1.0000000016245765]
["B8","Harper Lane, north of Radlett, WD7 7HU",11.401245571136402,0,0,0,0,0,0,0.15546070556483199,1.3635414183025678E-2,1.3635414183025678E-2,0.228576959716941,2.0048419998566696E-2,null,6.4130058155410178E-3,0.99358699418445895,0.15546080170264401,1.3635422615245774E-2,0.15546080170264401,1.3635422615245774E-2,0.22857726372620002,2.0048446663132168E-2,0.22857726372620002,2.0048446663132168E-2,0,0,0,0,0,0,0,0,0,0,0.187998684328119,1.6489311027916096E-2,9.9553223235448497E-3,8.7317848400247802E-4,0.14304838512562101,1.2546733094475649E-2,4.6769909927033604,0.41021754715499814,2.8392203054791501,0.24902720389314054,0,0,2.3217941964598199E-5,2.0364390732339944E-6,2.0364390732339944E-6,0,0,0.22624048850948403,1.9843488774791283E-2,0,0,0,0,0,0,11.401244684598201,0.99999992224198697,11.401244684598201,0.99999992224198697,11.401244684598201,0.99999992224198697]
["P1","Smallford Works, Smallford Lane, AL4 0SA",3.3350426132202098,0,0,0,0,0,0,1.1675283021463599E-3,3.5007897575828339E-4,3.5007897575828339E-4,1.16703063705371E-3,3.4992975274965462E-4,null,-1.4922300862877692E-7,1.0000001492230086,1.1675178123114101E-3,3.5007583042067714E-4,1.1675178123114101E-3,3.5007583042067714E-4,1.16701769756618E-3,3.4992587289292391E-4,1.16701769756618E-3,3.4992587289292391E-4,0,0,0,0,0,0,1.3576151952758601E-3,4.0707581663101765E-4,1.16205670412913E-2,3.4843833764603249E-3,1.5415605993207602,0.46223115507129275,2.6526051541858098E-2,7.9537369137977505E-3,1.2780382947443401,0.3832149819250158,0,0,0,0,8.6115600001066897E-2,2.5821439180327727E-2,1.84176015911323,0.5522448654216402,0.57806630460196795,0,0,1.16705582926474E-3,3.4993730653950128E-4,0,0,0,0,1.08271987209747E-2,3.2464948657793327E-3,0,0,3.3350426756323999,1.0000000187140607,3.3350426756323999,1.0000000187140607]
["P2","Land at North Orbital Road, AL2 1DL",1.8820344963073703,0,0,0,0,0,0,0,0,0,0,0,null,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,2.9622578488226203E-2,1.5739657560128111E-2,5.6820706578956201E-2,3.019110791563108E-2,0.12569050085744801,6.6784376749766269E-2,7.0091910138340902E-2,3.7242627739217389E-2,0.12193866446136201,6.4790876416245674E-2,0,0,0,0,1.76897420139251,0.93992655547138526,0,0,0.93992655547138526,0,0,0,0,0,0,0,0,0,0,0,0,1.88203503873775,1.0000002882148977,1.88203503873775,1.0000002882148977]
["B4","East St Albans, AL4 9JJ",21.686293049621501,0,0,0,0,0,0,0,0,0,0,0,null,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,5.4661781629075999E-2,2.5205682457578905E-3,0.44855577561352605,2.0683838154688907E-2,1.8817726424915802,8.6772443689928994E-2,0.89120004866400704,4.109508465207988E-2,1.66200856982162,7.6638666000625119E-2,0,0,0,0,6.7563008465916301,0.31154706021597134,0,0,0.31154706021597134,0,0,0,0,0,0,0,0,0,0,0,0,0,0,21.686293457376099,1.0000000188024112]
["UC46","Garage Blocks adj. to 76 Oakley Road and 151 Grove Road, Harpenden, AL5 1HJ",0.11725029144287101,0,0,0,0,0,0,0,0,0,0,0,null,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,5.1698708689131307E-3,4.4092605700959783E-2,1.3053723309142501E-2,0.11133211822763607,4.8437634012795702E-2,0.41311312250679083,2.5248229765041E-2,0.21533617916287173,4.6837727470849702E-2,0.39946789807060651,0,0,0.117250407428867,1.0000009892171231,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0.117250407428867,1.0000009892171231]
["UC10","Garage Block rear of 109-179 Hughenden Road, St Albans, AL4 9QW",0.27078325119018504,0,0,0,0,0,0,0,0,0,0,0,null,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0.27078327449386103,1.0000000860602563,0,0,1.0000000860602563,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0.27078327449386103,1.0000000860602563]
["UC12","Garage Block Between Hughenden Road and The Ridgeway, St Albans, AL4 9RH",0.22188045806884704,0,0,0,0,0,0,0,0,0,0,0,null,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1.17193395434878E-4,5.281825919005187E-4,0,0,1.17196567540202E-4,5.2819688836155737E-4,0,0,0,0,0.22188065636681001,1.0000008937153126,0,0,1.0000008937153126,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0.221880631255026,1.0000007805382252]
["UC27","Berkeley House, Barnet Road, London Colney, AL2 1BG",0.14452916183471601,0,0,0,0,0,0,0,0,0,2.8423708027353299E-2,0.19666417259001848,null,0.19666417259001848,0.80333582740998155,0,0,0,0,2.8423646028095301E-2,0.1966637436159816,2.8423646028095301E-2,0.1966637436159816,2.8423600332307501E-2,0.19666342744596291,0,0,8.8517413899335997E-4,6.1245365831820693E-3,0,0,0,0,1.9143722944136201E-6,1.3245578055748377E-5,0,0,1.91470398985306E-6,1.3247873062757545E-5,0,0,0.121868103175542,0.843207707209364,0,0,0,0,0,0,0,2.2516343831287099E-2,0.1557910081637148,5.9074693350725498E-3,4.087389188507403E-2,5.9074693350725498E-3,4.087389188507403E-2,0,0,0,0,0.14452927730538501,1.0000007989437394,0.14452927730538501,1.0000007989437394]
["UC39","Garage Block to east of 8 Heath Close, Harpenden, AL5 1QN",0.12762859039306601,0,0,0,0,0,0,0,0,0,0,0,null,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1.61032269783201E-2,0.12617256782924541,4.1954509031101705E-2,0.3287234380783467,0.12150777065875,0.95204193891458544,7.3728590652100107E-2,0.57768083487432875,0.11619539345834901,0.91041821507621878,0,0,0.12762842325304299,0.99999869041863976,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0.12762842325304299,0.99999869041863976]
["UC43","Garage block to west of 32-46 Riverside Road, St Albans, AL1 1SD",6.0495068359375001E-2,0,0,0,0,0,0,0,0,0,0,0,null,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,3.1468764837097804E-2,0.52018727626119043,5.3657622445959709E-2,0.8869751518785467,3.4007879965308102E-2,0.56215954271316826,4.9163370202549302E-2,0.81268393500261893,0,0,6.0494965256114301E-2,0.99999829567494514,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,6.04950090708491E-2,0.99999901994447626,6.04950090708491E-2,0.99999901994447626,6.04950090708491E-2,0.99999901994447626]
["UC17","Garage Block off Cotlandswick, London Colney, AL2 1ED",0.11367665710449201,0,0,0,0,0,0,0,0,0,0,0,null,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1.1193944972864099E-2,9.847179938247641E-2,6.5364579744855197E-2,0.57500441524042911,3.1767112593228002E-2,0.27945150220266901,6.3489681340735807E-2,0.55851115750506153,0,0,2.6342798399979099E-2,0.2317344569322152,8.7333842891072794E-2,0.76826540395883736,0,0,0.76826540395883736,0,0,0,0,0,0,0,0,0,0,0,0,0.113676640690097,0.99999985560452398,0.113676640690097,0.99999985560452398]
["UC32","Garages off Creighton Avenue, St Albans, AL1 2LZ",0.13985213088989201,0,0,0,0,0,0,0,0,0,0,0,null,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0.02,0.1430081892405797,5.1427627384313307E-2,0.36772859345849485,3.03610780560181E-2,0.2170941398091524,4.8260683347062697E-2,0.34508364684882181,0.13985215387915301,1.0000001643826293,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0.13985215387915301,1.0000001643826293]
["UC26","Garage Block to Malvern Close, St Albans, AL4 9SZ",0.13236847610473601,0,0,0,0,0,0,0,0,0,0,0,null,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0.13236843801200701,0.99999971222204775,0,0,0.99999971222204775,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0.13236843801200701,0.99999971222204775]
["UC24","Garages Rear of Hill End Lane (North), St Albans, AL4 0AE",0.20767036819457999,0,0,0,0,0,0,0,0,0,0,0,null,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,6.0184003410709501E-2,0.2898054447243969,8.512724828250641E-2,0.40991523741482999,0.127145270231348,0.61224560507456349,0.103955847969538,0.50058103557718425,0.12311804055360601,0.59285319144929061,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,2.24317018125435E-2,0.10801590042699673,0.207670354175958,0.99999993249580044]
["UC36","Garages off Park Street Lane, Park Street, AL2 2ND",0.128678628540039,0,0,0,0,0,0,0,0,0,0,0,null,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,2.5719681973892104E-2,0.19987531935724118,5.5665195702010499E-2,0.43259083760509615,3.8590588160598099E-2,0.29989897000332455,5.6981472670639799E-2,0.44282001849988423,0,0,0.12867857306841399,0.99999956891345798,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,5.4017786875602901E-2,0.41978833228545792,0.12867857306841399,0.99999956891345798,0.12867857306841399,0.99999956891345798]
["UC49","Garage Block rear of 18-30 Furse Avenue, St Albans, AL4 9NE",0.11884348373413001,0,0,0,0,0,0,0,0,0,0,0,null,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1.15859746010391E-4,9.7489355217477423E-4,4.0992430025513899E-5,3.4492787267343886E-4,1.158562400032E-4,9.7486405112784391E-4,0,0,0,0,0.11884360426837901,1.0000010142268234,0,0,1.0000010142268234,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0.11884360426837901,1.0000010142268234]
["UC8","Public Hall, 6 Southdown Road, Harpenden, AL5 1TE",0.26365607223510701,0,0,0,0,0,0,0,0,0,0,0,null,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1.8893158464401403E-2,7.1658347574692013E-2,4.2808985572094706E-2,0.1623667727778374,0.102430215894649,0.38849936216644415,7.4097089981470493E-2,0.28103691810821163,9.90636895422837E-2,0.37573073399176932,0,0,0.26365647301926398,1.0000015201021299,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0.25892989670514399,0.982074467354772,0.26365647301926398,1.0000015201021299,0.26365647301926398,1.0000015201021299]
["OS1","Land to the North of Bricket Wood, bounded by the M25 and A405 North Orbital",6.5234667686462409,0,0,0,0,0,0,0,0,0,0,0,null,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,8.7929125327698407E-2,1.3478895263222991E-2,0.27183010206643499,4.1669577190602526E-2,0.834165355553937,0.12787148078429533,0.52387871764235305,8.03067964046775E-2,0.77412307977268202,0.11866743669077189,0,0,0,0,3.5554871629684501,0.54503031732409513,0.45842459067583302,7.0273154893523884E-2,0.61530347221761905,0,0,0,0,0,0,0,0,0,0,6.5234665428601604,0.99999996538863634,6.5234665428601604,0.99999996538863634,6.5234665428601604,0.99999996538863634]
[null,"Harpenden Station Car Park",1.2443619270324699,0,0,0,0,0,0,0,0,0,0,0,null,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1.6593204514746298E-2,1.3334709262856867E-2,0.14447187031773701,0.11610116572938767,5.8641006731573402E-2,4.7125362370592075E-2,0.12985745497990001,0.10435666035651021,1.24436265258831,1.0000005830746057,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1.24436265258831,1.0000005830746057,1.24436265258831,1.0000005830746057,1.24436265258831,1.0000005830746057]
[null,"44 – 52 Lattimore Road, St Albans",0.11373912200927701,0,0,0,0,0,0,0,0,0,0,0,null,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,4.6361737556639103E-3,4.0761469525725423E-2,1.6837415308854502E-2,0.14803539021060122,7.0247509557565299E-2,0.6176195869688148,2.5974588999663401E-2,0.22836987433000241,5.9509468171880402E-2,0.5232101947035126,0.113739122499376,1.0000000043089745,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0.113739122499376,1.0000000043089745,0.113739122499376,1.0000000043089745]
[null,"Car Park to the rear of Portman House, Therfield Road St Albans",0.140915162658691,0,0,0,0,0,0,0,0,0,0,0,null,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,5.2130646619526606E-2,0.36994348681831812,3.5706262493823401E-2,0.25338836375122475,4.7858022906553499E-2,0.33962294762040524,0.14091537091530201,1.0000014778864608,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0.14091537091530201,1.0000014778864608,0.14091537091530201,1.0000014778864608]
[null,"Garage Block B off Cotlandswick, London Colney",0.11847633285522401,0,0,0,0,0,0,0,0,0,0,0,null,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1.2373765647694301E-2,0.10444082247899102,3.6403711293005403E-2,0.30726568265317677,5.1965584893168104E-2,0.43861574409691712,4.0429892999619098E-2,0.34124868676534509,4.7565584021695403E-2,0.40147751770659301,0,0,0,0,0.11847633562472,1.000000023375943,0,0,1.000000023375943,0,0,0,0,0,0,0,0,0,0,0,0,0.118476326249883,0.99999994424759064,0.118476326249883,0.99999994424759064]
[null,"186 Sandridge Road, St Albans",0.193903894805908,0,0,0,0,0,0,0,0,0,0,0,null,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1.7769629674148701E-5,9.1641427274761903E-5,2.2444886689035701E-2,0.11575263463120408,1.6655613149579101E-3,8.5896227954837482E-3,1.6787687734852001E-2,8.6577362211604753E-2,0.19390384799995899,0.99999975861264134,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0.19390384799995899,0.99999975861264134,0.19390384799995899,0.99999975861264134]
[null,"Motor Repair Garage, Park Street Lane, Park Street",0.29229255981445301,0,0,0,0,0,0,0,0,0,0,0,null,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,4.4099689434132505E-2,0.15087516925551214,6.426489136526721E-2,0.21986495792456193,9.7187702146905211E-2,0.33250145747329268,9.0604075942155193E-2,0.30997735966892404,0.110049532819222,0.37650473514988314,0,0,0.27263699941625003,0.93275381210291386,1.9655357942106998E-2,6.7245495248268367E-2,0,0,6.7245495248268367E-2,0,0,0,0,0,0,0,0,0,0,0,0,0.29229236361192001,0.99999932874605801,0.29229236361192001,0.99999932874605801]
[null,"Griffiths Way Retail Park, St Albans AL1 2RJ",6.4355016853332501,0,0,0,0,0,0,0,0,0,0,0,null,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0.30599999999999999,4.7548740558546583E-2,0.628296401347749,9.7629746998537825E-2,1.6899455226809603,0.26259732423540649,0.93231094816166205,0.14486997187591974,1.5880328549257501,0.24676131443566188,4.1621176094955798E-3,6.4674330192177585E-4,6.4313393288258496,0.99935321957620082,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,5.4039529972522402,0.83970967012067632,6.0700493427424496,0.94321307639097041,6.4355016859409897,1.0000000000944356]
[null,"Affinity Water, 107 Holywell Hill Road St Albans",1.22304419784545,0.231114975136194,0.18896698544773183,0.31950699899530899,0.26123912738244598,0.36397297010020302,0.29759592559401232,0.38039046217850397,0.31101939148937607,0.12205240604164425,0.81257138372904203,0.66438431674054887,null,0.3533649252511728,0.6466350747488272,0.43306499675404603,0.35408777337478547,0.46701649003740808,0.38184759868868012,0.9020658127234199,0.73755782032450268,0.91246575272470898,0.74606114344202357,0,0,1.05150263455924,0.859742138846329,0.14737480362285299,0.12049834657036328,0.139117444019176,0.11374686561961482,0.28495318275471199,0.23298682358061445,0.92022380400080295,0.75240437395630977,0.46205157203793901,0.37778812315360505,0.84677869964896701,0.69235331081303264,0,0,7.7499999999999999E-2,6.3366475337952824E-2,3.31558884063324E-2,2.7109313354939071E-2,0.76553831095293001,0.62592857420976644,0.65303788756470549,0.24853447733789999,0.20320972682403915,0.17230806780431701,0.14088457972971041,0.38676671893581904,0.31623282267080655,0,0,0,0,1.2230441872539699,0.99999999134006756,1.2230441872539699,0.99999999134006756,1.2230441872539699,0.99999999134006756]
[null,"50 - 54 Lemsford Road St Albans",0.53290887999967607,0,0,0,0,0,0,0,0,0,0,0,null,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,4.8411616134224405E-3,9.0844078511609395E-3,2.9056798654061203E-2,5.4524891110988551E-2,1.07362500164366E-2,2.0146502374745801E-2,2.8625135500996803E-2,5.3714878050097802E-2,0.53290887999525605,0.99999999999170586,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0.53290887999525605,0.99999999999170586,0.53290887999525605,0.99999999999170586]
[null,"Ariston Works",2.5174498884538603,0,0,0,0,0,0,0,0,0,0,0,null,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1.7600000000000001E-2,6.9912017239037779E-3,2.2800000000000001E-2,9.0567840514208034E-3,0.128378754357201,5.0995555044016094E-2,3.6799999999999999E-2,1.4617967240889715E-2,7.1957570170323004E-2,2.8583516399016431E-2,2.5174498884538603,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,2.5174496412923899,0.99999990182069898,2.5174496412923899,0.99999990182069898]
[null,"Car Park and Garage Block to rear of Telford Court Alma Road St Albans",0.48452990035880306,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"N37-K37","v":0},{"$f":"100%-P37","v":1},0,0,0,0,0,0,0,0,0,0,0,0,0,0,1.4580219763331099E-3,3.0091475784124336E-3,1.8651674858837199E-2,3.8494373298789818E-2,2.5660456093164905E-2,5.2959489340416097E-2,2.0974699301377398E-2,4.328876151058017E-2,2.55823585147823E-2,5.279830717534275E-2,0.48452982945872802,0.99999985367244626,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0.48434900333272501,0.99962665456570565,0.48452982945872802,0.99999985367244626]
[null,"52 Victoria Street and 16 New Kent Road, St Albans",5.6000000000000001E-2,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"N38-K38","v":0},{"$f":"100%-P38","v":1},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,5.6000000000000001E-2,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,5.6000000000000001E-2,1,5.6000000000000001E-2,1,5.6000000000000001E-2,1]
[null,"Brethrens Meeting Hall Blackwater Lane",1.655,0,0,0,0,0,0,0,0,0,0,0,null,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1.655,1]
[null,"Petrol Filling Station 551 Watford Road Chiswell Green",0.69,0,0,0,0,0,0,0,0,0,0,0,null,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,3.4499999999999999E-3,5.0000000000000001E-3,6.2000440380652398E-4,8.985571069659769E-4,3.27950288852969E-3,4.7529027369995515E-3,0,0,0.69,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0.69,1,0.69,1,0.69,1]
[null,"Telephone Exchange Bowers Way Harpenden AL5 4EP",0.219,0,0,0,0,0,0,0,0,0,0,0,null,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,4.3800000000000002E-4,{"$f":"AJ41/C41","v":2E-3},0,0,6.9394634911775898E-3,3.1687047904920503E-2,0.219,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0.219,1,0.219,1,0.219,1]

{"sheet":"Sites","index":3,"n_rows":41,"n_cols":9,"rows_kept":41,"cut":false,"hidden":false,"merged":[]}
["Site_code","Site_name","Area_ha","Settlement","Proposed use","Former use","Deliverabilty","Core Strategy Spatial Policy Area","Source"]
["B3"," West Redbourn, Redbourne, AL3 7HZ",27.017108829500003,null,"Residential",null,"Not developable within the next 15 years",null,"HELAA_Sites_Not_Deliverable"]
["B4","East St Albans, AL4 9JJ",21.686293457400001,null,"Residential",null,"Potentially developable",null,"HELAA_sites_with_potential"]
["B5","Glinwell, Hatfield Road, St Albans, AL4 0HE",20.8470974994,null,"Residential",null,"Potentially developable in part",null,"HELAA_sites_with_potential"]
["B8","Harper Lane, north of Radlett, WD7 7HU",11.4012446846,null,"Residential",null,"Potentially developable in part",null,"HELAA_sites_with_potential"]
["M20","Lower Luton Road, Harpenden, AL5 5AF",0.73588067130000001,null,"Residential",null,"Potentially developable in part",null,"HELAA_sites_with_potential"]
["M25"," Baulk Close, Harpenden, AL5 4LY",0.55562100680000004,null,"Residential",null,"Not developable within the next 15 years",null,"HELAA_Sites_Not_Deliverable"]
["M26","Highway Chipping Depot, Lower Luton Roa, AL4 8JJ",0.33922200889999998,null,"Residential",null,"Potentially developable",null,"HELAA_sites_with_potential"]
["M5","Sewage Treatment Works, Piggottshill Lane, Harpenden, AL5 5UN",4.0995472989000001,null,"Residential",null,"Not developable within the next 15 years",null,"HELAA_Sites_Not_Deliverable"]
["M6 "," South of Harpenden Lane, Redbourn, AL3 7RQ",12.564116203899999,null,"Residential",null,"Potentially developable",null,"HELAA_sites_with_potential"]
["OS1","Land to the North of Bricket Wood, bounded by the M25 and A405 North Orbital",6.5233111778000001,null,"Community Facilites",null,"Not developable within the next 15 years",null,"HELAA_Sites_Not_Deliverable"]
["P1","Smallford Works, Smallford Lane, AL4 0SA",3.3350426756,null,"Residential",null,"Not developable within the next 15 years",null,"HELAA_Sites_Not_Deliverable"]
["P2","Land at North Orbital Road, AL2 1DL",1.8820350386999998,null,"Residential",null,"Potentially developable",null,"HELAA_sites_with_potential"]
["UC10","Garage Block rear of 109-179 Hughenden Road, St Albans, AL4 9QW",0.2707832745,null,"Residential",null,"Not developable within the next 15 years",null,"HELAA_Sites_Not_Deliverable"]
["UC12","Garage Block Between Hughenden Road and The Ridgeway, St Albans, AL4 9RH",0.22188063129999999,null,"Residential",null,"Potentially developable in part",null,"HELAA_sites_with_potential"]
["UC17","Garage Block off Cotlandswick, London Colney, AL2 1ED",0.11367664070000001,null,"Residential",null,"Not developable within the next 15 years",null,"HELAA_Sites_Not_Deliverable"]
["UC24","Garages Rear of Hill End Lane (North), St Albans, AL4 0AE",0.20767035420000002,null,"Residential",null,"Not developable within the next 15 years",null,"HELAA_Sites_Not_Deliverable"]
["UC26","Garage Block to Malvern Close, St Albans, AL4 9SZ",0.132368438,null,"Residential",null,"Not developable within the next 15 years",null,"HELAA_Sites_Not_Deliverable"]
["UC27","Berkeley House, Barnet Road, London Colney, AL2 1BG",0.14452927729999998,null,"Residential",null,"Not developable within the next 15 years",null,"HELAA_Sites_Not_Deliverable"]
["UC32","Garages off Creighton Avenue, St Albans, AL1 2LZ",0.1398521539,null,"Residential",null,"Potentially developable in part",null,"HELAA_sites_with_potential"]
["UC36","Garages off Park Street Lane, Park Street, AL2 2ND",0.1286785731,null,"Residential",null,"Not developable within the next 15 years",null,"HELAA_Sites_Not_Deliverable"]
["UC39","Garage Block to east of 8 Heath Close, Harpenden, AL5 1QN",0.12762842330000002,null,"Residential",null,"Not developable within the next 15 years",null,"HELAA_Sites_Not_Deliverable"]
["UC43","Garage block to west of 32-46 Riverside Road, St Albans, AL1 1SD",6.0495009100000004E-2,null,"Residential",null,"Not developable within the next 15 years",null,"HELAA_Sites_Not_Deliverable"]
["UC46","Garage Blocks adj. to 76 Oakley Road and 151 Grove Road, Harpenden, AL5 1HJ",0.11725040739999999,null,"Residential",null,"Not developable within the next 15 years",null,"HELAA_Sites_Not_Deliverable"]
["UC49","Garage Block rear of 18-30 Furse Avenue, St Albans, AL4 9NE",0.11884360429999999,null,"Residential",null,"Potentially developable in part",null,"HELAA_sites_with_potential"]
["UC8","Public Hall, 6 Southdown Road, Harpenden, AL5 1TE",0.263656473,null,"Residential",null,"Not developable within the next 15 years",null,"HELAA_Sites_Not_Deliverable"]
["N/A","Harpenden Station Car Park",1.2443619270324699,null,"Residential",null,null,null,"Regulation 19 sites for inclusion in Local Plan"]
["N/A","44 – 52 Lattimore Road, St Albans",0.11373912200927701,null,"Residential",null,null,null,"Regulation 19 sites for inclusion in Local Plan"]
["N/A","Car Park to the rear of Portman House, Therfield Road St Albans",0.140915162658691,null,"Residential",null,null,null,"Regulation 19 sites for inclusion in Local Plan"]
["N/A","Garage Block B off Cotlandswick, London Colney",0.11847633285522401,null,"Residential",null,null,null,"Regulation 19 sites for inclusion in Local Plan"]
["N/A","186 Sandridge Road, St Albans",0.193903894805908,null,"Residential",null,null,null,"Regulation 19 sites for inclusion in Local Plan"]
["N/A","Motor Repair Garage, Park Street Lane, Park Street",0.29229255981445301,null,"Residential",null,null,null,"Regulation 19 sites for inclusion in Local Plan"]
["N/A","Griffiths Way Retail Park, St Albans AL1 2RJ",6.4355016853332501,null,"Residential",null,null,null,"Regulation 19 sites for inclusion in Local Plan"]
["N/A","Affinity Water, 107 Holywell Hill Road St Albans",1.22304419784545,null,"Residential",null,null,null,"Regulation 19 sites for inclusion in Local Plan"]
["N/A","50 - 54 Lemsford Road St Albans",0.53290887999967607,null,"Residential",null,null,null,"Regulation 19 sites for inclusion in Local Plan"]
["N/A","Ariston Works",2.5174498884538603,null,"Residential with community facilities and primary school",null,null,null,"Regulation 19 sites for inclusion in Local Plan"]
["N/A","Car Park and Garage Block to rear of Telford Court Alma Road St Albans",0.48452990035880306,null,"Residential",null,null,null,"Regulation 19 sites for inclusion in Local Plan"]
["N/A","`",5.6000000000000001E-2,null,"Residential",null,null,null,"Regulation 19 sites for inclusion in Local Plan"]
["N/A","Brethrens Meeting Hall Blackwater Lane",1.655,null,"Residential",null,null,null,"Regulation 19 sites for inclusion in Local Plan"]
["N/A","Petrol Filling Station 551 Watford Road Chiswell Green",0.69,null,"Residential",null,null,null,"Regulation 19 sites for inclusion in Local Plan"]
["N/A","Telephone Exchange Bowers Way Harpenden AL5 4EP",0.219,null,"Residential",null,null,null,"Regulation 19 sites for inclusion in Local Plan"]