This dataset contains a SQLite database containing flexibility service data for the latest flexibility service (Tranche 6B – summer 2022). The database also contains DFES scenario based signposting for flexibility services. This data set is displayed on the Network Flexibility map on the NGED website and Flexible Power website. SQL queries are provided to extract data from the database in conjunction with example extracts. The SQL queries list: * Which primary substations are associated with which Constraint Managed Zone (CMZ) for Tranche 6B – summer 2022 flexibility service tender; * Which postcodes are associated with which Constraint Managed Zone (CMZ) for Tranche 6B – summer 2022 flexibility service tender; * Which CMZs are open for the Tranche 6B – summer 2022 flexibility service tender; * CMZ availability windows for the Tranche 6B – summer 2022 flexibility service tender; * CMZ utilisation volumes for the Tranche 6B – summer 2022 flexibility service tender;

# Overview Data files that have been superseded and/or are no longer in active use. # Data The datasets below are historical and have since been superseded. For the latest flexibility data, please go to one of the following pages: - _[Flexibility – Requirements](https://connecteddata.nationalgrid.co.uk/dataset/flexibility-requirements "Flexibility – Requirements")_ - _[Flexibility – Trades Data and Results](https://connecteddata.nationalgrid.co.uk/dataset/flexibility-trades-data-and-results "Flexibility – Trades Data and Results")_ - _[Flexibility – Reports](https://connecteddata.nationalgrid.co.uk/dataset/flexibility-reports "Flexibility – Reports")_

# Overview This section of the Flexibility Group focuses on making available regularly produced reports containing procurement and dispatch data. # Data The _[Procurement_Report.csv](https://connecteddata.nationalgrid.co.uk/dataset/flexibility-reports/resource/b4c5d00b-0009-4da2-84a5-38c7ecde1c69)_ file contains information on the amount of flexibility we have procured in the previous regulatory year(s) and any remaining requirements we may still look to procure moving forward. The _[Dispatch_Report.csv](https://connecteddata.nationalgrid.co.uk/dataset/flexibility-reports/resource/9371a84a-72dd-4e62-b4ff-7bdd37b49496)_ presents information on how much and when we have dispatched flexibility services in the previous regulatory year(s). Both reports align with the Procurement Report and supporting information submitted to Ofgem every year which are available on the [National Grid - Distribution Flexibility Services Reporting](https://www.nationalgrid.co.uk/distribution-flexibility-services-reporting) page. We have kept the same format for consistency.

Latest analysis tranche reference: T8A # Overview We are looking to mitigate a range of constraints across multiple voltage levels on the network. As they involve different methods of assessment and operation, our Constraint Management Zones (CMZs) are split into __HV Zones__, covering constraints at 33kV and above, and __LV Zones__, covering constraints on our 6.6kV and 11kV networks. Our HV Zones have Secure and/or Dynamic products available, and, where applicable, Sustain (also referred to as HV Sustain). In LV Zones we are only looking to procure Sustain services (also referred to as LV Sustain) from providers connected at lower voltages. Sustain is operated the same way across both LV and HV zone, with the same parameters and customer eligibility; HV or LV is only to differentiate between constraint levels. More information on all products can be found in our latest [Procurement Statement](https://www.nationalgrid.co.uk/distribution-flexibility-services-reporting). Information on all the constraints we have assessed can be found in the [Distribution Network Options Assessment (DNOA)](https://connecteddata.nationalgrid.co.uk/dataset/distribution-network-options-assessment-dnoa). We undertake flexibility analysis on a regular basis, and we will keep updating this data in line with the latest tranche of analysis. # Data The data covers overall zonal requirements, including locational data. Full information on HV Zones is available in the _[Flexibility_Database_and_Queries.zip](https://connecteddata.nationalgrid.co.uk/dataset/flexibility-requirements/resource/196bcfb9-0b12-478b-a1c2-173a06655478)_. Some useful information has been extracted into csv data files, and the SQL queries used for this are available within the compressed zip file. However, some reports below have been manually edited to improve readability and reduce the number of files, so running queries may not always produce an exact match. _[OVERVIEW_All_Zones.csv](https://connecteddata.nationalgrid.co.uk/dataset/flexibility-requirements/resource/c70e485e-7715-4e98-87d8-46fdd1684a21)_ provides a list of all Constraint Management Zones (CMZs), both HV and LV, which are or will shortly be open for procurement. This file contains some basic information such as the main product and service type in the zone, and provides an indication of how many zones we have active in each Licence Area. __WHERE__ Information on where we require flexibility services is contained in the following Postcodes and Polygons files, for combined HV and LV zones. These are updated with each tranche of analysis as zones change and as we improve our data accuracy over time. - _[WHERE_All_Postcodes.csv](https://connecteddata.nationalgrid.co.uk/dataset/flexibility-requirements/resource/a9a0ddbf-117c-4b20-82cc-a3689d2422c9)_ - _[WHERE_All_Polygons.gpkg](https://connecteddata.nationalgrid.co.uk/dataset/flexibility-requirements/resource/3ade7e88-44e4-430a-9f43-3eec0e6eab0a)_ As with all geographic data, the Postcodes and Polygons are indicative only and final mapping of assets to zones will be carried out on an asset by asset basis following their registration on [Market Gateway](https://marketgateway.nationalgrid.co.uk/). The list of postcodes is deliberately broad, to avoid excluding assets from participation. Wider work is being carried out to improve the accuracy of this data. __HOW MUCH and WHEN__ We look to procure Sustain services within our LV Zones, which is a simple and less targeted product compared to Secure or Dynamic. _[HOW_MUCH_and_WHEN_LV_Zones.csv](https://connecteddata.nationalgrid.co.uk/dataset/flexibility-requirements/resource/3e2659ed-9df7-4d5f-9410-34363df3b671)_ provides information on how much (minimum and maximum kW) we look to procure, the maximum price we can pay (ceiling price), and the delivery periods, which are the same across all zones. The minimum kW value relates to a minimum we would look to procure in order to defer reinforcement, and NOT to a minimum capacity of an asset. If this is not met, we may decide to progress reinforcement and not award flexibility services. The requirements for our HV zones, such as the estimated peak capacity (MW), energy (MWh), and the ceiling prices, are presented in _[HOW_MUCH_HV_Zones.csv.](https://connecteddata.nationalgrid.co.uk/dataset/flexibility-requirements/resource/4e0e6ddf-9721-4c19-bc68-274eeb460381)_ Moving to ceiling prices means that the maximum price is now linked with the volume of flexibility required, therefore in most cases ceiling prices will decrease over time as the amount of flexibility required generally tends to grow. As the requirements for our HV Zones are more complex, granular, and targeted, information regarding when we may need flexibility services is presented in two forms: - a simplified, monthly breakdown of potential needs over the years (_[WHEN_HV_Zones.csv](https://connecteddata.nationalgrid.co.uk/dataset/flexibility-requirements/resource/44e2cdbe-0f25-4205-a8ff-5d4bb66f2f57)_), which should provide an overview of needs over time, and - as half-hourly peak MW profile data in _[WHEN_HV_Zones_MW_Profiles.csv](https://connecteddata.nationalgrid.co.uk/dataset/flexibility-requirements/resource/266f996e-c51a-4bfe-98bb-8816fcf9e8ef)_ for a year; full profile data is available in the database. Each trade opportunity will contain details of final volumes and delivery periods. Information on trades is available on the _[Flexibility – Trades Data and Results](https://connecteddata.nationalgrid.co.uk/dataset/flexibility-trades-data-and-results)_ page.

# Overview This dataset contains information on what we will look to put forward in our upcoming trades, with the aim to provide more visibility ahead of the actual trade opportunities. For general Constraint Management Zone (CMZ) information and overall requirements, please go to the _[Flexibility – Requirements](https://connecteddata.nationalgrid.co.uk/dataset/flexibility-requirements)_ page. National Grid facilitates its flexibility procurement activity through its online portal, _[Market Gateway](https://marketgateway.nationalgrid.co.uk/)_. Flexibility Service Providers (FSPs) seeking an award to deliver flexibility services should register on the Market Gateway and complete the pre-qualification requirements to enable their eligibility to enter into flexibility Trades. Pre-qualification is always open and can be completed at any time. Further guidance on this process is available _[here](https://flexiblepower.wpdserv.net/downloads/1121)_. Any questions should be sent to _[nged.flexiblepower@nationalgrid.co.uk](mailto:nged.flexiblepower@nationalgrid.co.uk)_. # Data Currently, this dataset only covers Long Term and Sustain trade opportunities in detail. _[Long_Term_Trade_Parameters.csv](https://connecteddata.nationalgrid.co.uk/dataset/flexibility-trades-data-and-results/resource/a45f323a-c0f6-4a2c-bdc2-bb442ec97c42)_ includes information for Secure and/or Dynamic flexibility products within HV Zones, such as peak MW requirements (min, max), ceiling prices, and delivery windows (dates, times, days required). As Sustain is the same product across both HV and LV zones, _[Sustain_Trade_Parameters.csv](https://connecteddata.nationalgrid.co.uk/dataset/flexibility-trades-data-and-results/resource/47f87588-f05d-4a44-83ca-c1f90b101cdc)_ contains information for all zones where Sustain is available. This information includes the capacity we need (minimum and maximum kW), the maximum price we can pay (ceiling price £/kW/season), and service delivery windows (dates, times, days required). For our HV Zones, graphs have been created to help visualise our Long Term and Sustain (where applicable) MW profile needs over time. These have been packaged into _[Long_Term_Trade_Graphs.zip](https://connecteddata.nationalgrid.co.uk/dataset/flexibility-trades-data-and-results/resource/5f6ce48d-d1cd-4716-8124-93392cce49fd)_. The trade results are presented in the _[Trade_Results.csv](https://connecteddata.nationalgrid.co.uk/dataset/flexibility-trades-data-and-results/resource/d2eb8939-1509-44b8-8ab2-108f80aa4d14)_ file in detail, and in _[Trade_Results_Summary.csv](https://connecteddata.nationalgrid.co.uk/dataset/flexibility-trades-data-and-results/resource/0e0b3921-c4d0-494c-a5ca-f529ad328ee3)_ in a more simplified, aggregated view. The weekly trade auction results are presented in the _[Weekly_Trade_Results.csv](https://connecteddata.nationalgrid.co.uk/dataset/flexibility-trades-data-and-results/resource/234b31a0-599b-4a46-9f15-b05bcbe60e77)_ and _[Weekly_Trade_Results_Summary.csv](https://connecteddata.nationalgrid.co.uk/dataset/flexibility-trades-data-and-results/resource/72b618d2-34c2-4347-8786-111d1cc93ce2)_ .