What's New
Introduction
This page details what's new at www.netareports.com.
7th November, 2009
Balancing Mechanism Data
The following additional messages are now coded for import:
- "Transmission System Demand Forecast, 2-14 days" (BMRA.SYSTEM.TSDFD message)
- "Disaggregated Period Total B-O Acceptance Volume" (BMRA.BM.*.DISPTAV.* message)
The root page for the 2-14 day forecast pages has now had the TSDFD data added to it, providing access to the following new pages:
The Bid-Offer Acceptance Volumes and Estimated Cashflow pages have
been modified to add the new disaggregated numbers for "Tagged Bid Volume", "Repriced Bid Volume",
"Originally Priced Bid Volume", "Tagged Offer Volume", "Repriced Offer Volume" and
"Originally Priced Offer Volume".
5th November, 2009
New Version of the SAA-I0142 File
The new version (7) of the SAA-I0142 file has been released as part of the
November 2009 release and NETA Reports has been coded to import it.
Balancing Mechanism Data
The following additional message is now coded for import:
- "Transmission System Demand Forecast, 2-52 week" (BMRA.SYSTEM.TSDFW message)
The root page for the 2-52 week forecast pages has now had the TSDFW data added to it, providing access to the following new pages:
22nd October, 2009
Balancing Mechanism Data
The following additional messages are now coded for import:
- "Bid-Offer Acceptance Level Flagged" (BMRA.BM.*.BOALF message)
- "Indicative System Price Stack" (BMRA.SYSTEM.ISPSTACK message)
11th August, 2009
New XML-REST Web Services
A new XML-REST Web Service has been added. The 'saa_apd' service returns SAA
energy account period data. For details on the 'saa_apd'
service click here.
24th July, 2009
New BM Unit Data Items
The following items have been added to the BM Unit data tables.
- RCRC - The "Residual Cashflow Reallocation Charge" is used to reallocate
the moneys due to or from parties from energy imbalance settlement back out to participants.
It is also more colloquially known as the beer-fund. The RCRC is calculated inside settlement
to the energy account level. This new field is populated by NETA reports and recreates this
calculation but at the BM unit level.
- Generation Capacity - The generation capacity in MWs reported by BSC parties to
Elexon and published by them on www.elexon.co.uk. This number is changed at least seasonally.
It is also known by some as the name plate capacity.
- Demand Capacity - The demand capacity in MWs reported by BSC parties to
Elexon and published by them on www.elexon.co.uk. This number is changed at least seasonally.
- CO2 - The tonnes of CO2 emitted by a power station when
converting fuel to electricity.
- SO2 - The tonnes of SO2 emitted by a power station when
converting fuel to electricity. Currently a place holder whilst Environment Agency data
is integrated into the system.
- NOx - The tonnes of NOx emitted by a power station when
converting fuel to electricity. Currently a place holder whilst Environment Agency data
is integrated into the system.
New Derived BM Unit Data Items
The following items are now available as derived data items.
- FPN + BOA + ABSV Volume - The FPN Volume plus the BOA Volume plus the applicable
balancing services volume in MWHrs for the half-hourly period. The FPN + BOA + ABSV volume
is at the GSP.
- FPN Percentage of MEL - The notified volume (FPN) modified by balancing actions
(BOA + ABSV) as a percentage proportion of the MEL. This is useful for determining the short
term utilisation of plant from notification data. Only sensible for generation BM units.
- FPN Percentage of GC - The notified volume (FPN) modified by balancing actions
(BOA + ABSV) as a percentage proportion of the generation capacity. This is useful for
determining the utilisation of plant from notification data. Only sensible for generation
BM units.
- Metered Volume Percentage of MEL - The metered volume as a percentage proportion
of the MEL. This is useful for determining the short term utilisation of plant from metered
data. Only sensible for generation BM units.
- Metered Volume Percentage of GC - The metered volume as a percentage proportion
of the generation capacity. This is useful for determining the utilisation of plant from
metered data. Only sensible for generation BM units.
- MEL Percentage of GC - The MEL volume as a percentage proportion of the generation
capacity. This is useful for determining the short term availability of plant compared against
its declared generation capacity. Only sensible for generation BM units.
- MIL Percentage of DC - The MIL volume as a percentage proportion of the demand capacity.
This is useful for determining the short term demand requirement compared against its declared
demand capacity. Only sensible for demand BM units.
Impact of New Items on the System
The new items at BM Unit level have now appeared throughout the system on the various
spreadsheets that contain BM Unit derived information. They will appear as new tabs in
the spreadsheet. All cached spreadsheets that require these new fields have been set to stale.
The new data items are also on the BM Unit data
download page.
XML-REST Web Services
Users have always been able to download a number of data items via an XML-RPC backend interface.
This interface however is quite difficult for ordinary users to use. A new XML-REST interface
has been implemented which is more easy to use for ordinary users. Documentation for
this service is available at the XML-REST section
of the backend pages. Three services have been implemented:
19th May, 2009
NGC Fuel Type Summaries
Two new pages have been added to the fuel type summary section.
- The settlement period fuel type data page is used
to generate a spreadsheet with BM Units grouped by NGC fuel type to arrive at a settlement period
total per fuel type for a time period. Data displayed is volumes and balancing mechanism
acceptance volume, cash-flow and price data.
- The daily NGC fuel type data page is used
to generate a spreadsheet with BM Units grouped by NGC fuel type to arrive at a daily
total per fuel type for a time period. Data displayed is volumes and balancing mechanism
acceptance volume, cash-flow and price data.
Power Station Summaries
A new sub-section has been added to the summary section. The
power station page displays information by power station.
This section has two new pages.
- The settlement period power station data page is used
to generate a spreadsheet with BM Units grouped by power station to arrive at a settlement period
total per power station for a time period. Data displayed is volumes and balancing mechanism
acceptance volume, cash-flow and price data.
- The daily power station data page is used
to generate a spreadsheet with BM Units grouped by power station to arrive at a daily
total per power station for a time period. Data displayed is volumes and balancing mechanism
acceptance volume, cash-flow and price data.
LCPD Data Summaries
A new sub-section has been added to the summary section. The
LCPD data page displays information
on large combustion plants.
- The settlement period LCPD stack data page is used
to generate a spreadsheet with BM Units grouped by LCPD stack to arrive at a settlement period
total per LCPD stack for a time period. Data displayed is volumes and balancing mechanism
acceptance volume, cash-flow and price data.
- The daily LCPD stack data page is used
to generate a spreadsheet with BM Units grouped by LCPD stack to arrive at a daily
total per LCPD stack for a time period. Data displayed is volumes and balancing mechanism
acceptance volume, cash-flow and price data.
Spreadsheet Caching
Spreadsheet caching has been implemented on the site. A background task is now building
spreadsheets. Now instead of waiting for spreadsheets, the spreadsheet will be waiting
pre-built for immediate download.
28th April, 2009
Gas Fired Power Station Summary
The Gas Fired Power Station Summary page has been
fixed. The problem was with the interface to the NGC gas data site but this has been fixed.
Data is available from October 2007.
10th February, 2009
Large Combustion Plant Directive Spreadsheet
A new page has been added. The Large
Combustion Plant Directive Spreadsheet page allows the user to download a summary
of operating hours under the large combustion plant directive. It uses environment
agency numbers with metered volumes and FPN volumes to predict operating hours and
make an educated guess at the closure date of opted out plant.
As a consequence of this work the carbon spreadsheets have been moved to a new
emissions section.
18th January, 2009
New data type restrictions on BM Unit Data Download
The BM Unit Bulk Data Download
page has been modified to provide more ways of selecting groups of BM units
for download. The following data type restrictions have been added:
- EnAppSys Fuel Type - One of the fuel type allocations defined by EnAppSys.
- NGC Fuel Type - One of the fuel type allocations defined by National Grid
for the BMRS Fuel Messages.
- Power Station - The power station.
- LCPD Stack - The large combustion plant directive chimney the BM Unit
exhausts through for hours counting.
- LCPD Unit - The large combustion plant directive unit the BM Unit belongs
to for SO2 and NOx counting.
9th January, 2009
Balancing Mechanism Data
The following additional messages are now being imported:
- "Half-Hourly Generation by Fuel Type" (BMRA.SYSTEM.FUELHH)
- "Instantaneous Generation by Fuel Type" (BMRA.SYSTEM.FUELINST)
28th December, 2008
Balancing Mechanism Data
The "Temperature Data" (BMRA.SYSTEM.TEMP) messages are now being imported.
20th December, 2008
National Demand Forecast (NDF) Data
The National Demand Forecast pages have been implemented
to show national demand forecast (NDF) data. There are four pages:
Transmission System Demand Forecast (TSDF) Data
The Transmission System Demand Forecast pages have been implemented
to show transmission system demand forecast (TSDF) data. There are four pages:
18th December, 2008
Balancing Mechanism Data
The following additional messages are now being imported:
- "National Demand Forecast" (BMRA.SYSTEM.NDF)
- "Transmission System Demand Forecast" (BMRA.SYSTEM.TSDF)
16th December, 2008
Latest ITSDO Data
The view latest initial transmission system demand
outturn data page allows the user to view the latest initial transmission system demand
outturn data from the balancing mechanism reporting service.
ITSDO Data History
The view initial transmission system demand outturn
data history page allows the user to view a history of initial transmission system demand
outturn data from the balancing mechanism reporting service.
ITSDO Data Download
The download initial transmission system demand
outturn data page allows the user to download a file containing initial transmission
system demand outturn data from the balancing mechanism reporting service for a date range.
11th December, 2008
Balancing Mechanism Data
The "Initial Transmission System Demand Out-Turn" (BMRA.SYSTEM.ITSDO) message is now being imported.
9th December, 2008
New variables on BM Unit Data Download
The BM Unit Bulk Data Download page has been modified
to provide more information.
Information on available and declared bid offer pair volumes before acceptances has been summarised
up to the settlement period level. The data builds on the bid offer pair data download completed in
September but modifies it slightly by filtering out sleeper bids and offers (i.e. excessively large
positive or negative prices).
BSUoS charges and metered volume at the NBP has been added.
The BMRS dynamic data has been summarised to the period level. To decide which value to use for the
period, the one that applies for the most time in the settlement period is the one that has been
selected.
The complete list of variables added to the download facility is as follows:
- Total Up-Side Volume Available the total volume available from positive bid offer pairs
after being sliced by MEL/MIL. This number excludes sleeper offers.
- Total Down-Side Vol Available the total volume available from negative bid offer pairs
after being sliced by MEL/MIL. This number excludes sleeper bids.
- Total Up-Side Vol Declared the total volume declared from positive bid offer pairs with
no MEL/MIL slicing. This number excludes sleeper offers.
- Total Down-Side Vol Declared the total volume declared from negative bid offer pairs with
no MEL/MIL slicing. This number excludes sleeper bids.
- Total Up-Side Sleeper Vol Available the total volume available from positive sleeper bid
offer pairs after being sliced by MEL/MIL.
- Total Down-Side Sleeper Vol Available the total volume available from negative sleeper
bid offer pairs after being sliced by MEL/MIL.
- Total Up-Side Sleeper Vol Declared the total volume available from positive sleeper bid
offer pairs with no MEL/MIL slicing.
- Total Down-Side Sleeper Vol Declared the total volume available from negative sleeper
bid offer pairs with no MEL/MIL slicing.
- Offer Cashflow Declared the total offer cashflow declared from positive bid offer pairs
with no MEL/MIL slicing. This number excludes sleeper offers.
- Total Undo-Offer Cashflow Declared the total bid cashflow declared from positive bid
offer pairs with no MEL/MIL slicing. This number excludes sleeper offers.
- Bid Cashflow Declared the total bid cashflow declared from negative bid offer pairs with
no MEL/MIL slicing. This number excludes sleeper offers.
- Total Undo-Bid Cashflow Declared the total offer cashflow declared from negative bid
offer pairs with no MEL/MIL slicing. This number excludes sleeper offers.
- Total Offer Cashflow Available the total offer cashflow available from positive bid
offer pairs after being sliced by MEL/MIL. This number excludes sleeper offers.
- Total Undo-Offer Cashflow Available the total offer cashflow available from positive
bid offer pairs after being sliced by MEL/MIL. This number excludes sleeper offers.
- Bid Cashflow Available the total offer cashflow available from positive bid offer pairs
after being sliced by MEL/MIL. This number excludes sleeper offers.
- Total Undo-Bid Cashflow Available the total offer cashflow available from positive bid
offer pairs after being sliced by MEL/MIL. This number excludes sleeper offers.
- Metered Volume At NBP is the metered volume modified by transmission losses to arrive
at the volume of power at the notional balancing point.
- BSUoS Charge is the BSUoS charge. Balancing Services Use of System (BSUoS) is the charge
levied by National Grid for keeping the lights on.
- Run Down Rate for Export the predominant run down rates for export, i.e. the value that
is in effect for the most time in the period. Five variables for run down rates for export are
available, i.e. rate 1, first elbow, rate 2, second elbow, rate 3.
- Run Down Rate for Import the predominant run down rates for import, i.e. the value that
is in effect for the most time in the period. Five variables for run down rates for import are
available, i.e. rate 1, first elbow, rate 2, second elbow, rate 3.
- Run Up Rate for Export the predominant run up rates for export, i.e. the value that is
in effect for the most time in the period. Five variables for run up rates for export are available,
i.e. rate 1, first elbow, rate 2, second elbow, rate 3.
- Run Up Rate for Import the predominant run up rates for import, i.e. the value that is
in effect for the most time in the period. Five variables for run up rates for import are available,
i.e. rate 1, first elbow, rate 2, second elbow, rate 3.
- Maximum Delivery Period the predominant maximum delivery period, i.e. the value that is
in effect for the most time in the period.
- Maximum Delivery Volume the predominant maximum delivery volume, i.e. the value that is
in effect for the most time in the period.
- Minimum Zero Time the predominant minimum zero time, i.e. the value that is in effect
for the most time in the period.
- Minimum Non-Zero Time the predominant maximum non-zero time, i.e. the value that is in
effect for the most time in the period.
- Notice to Deliver Bids the predominant notice to deliver bids, i.e. the value that is
in effect for the most time in the period.
- Notice to Deliver Offers the predominant notice to deliver offers, i.e. the value that
is in effect for the most time in the period.
- Notice to Deviate from Zero the predominant notice to deviate from zero, i.e. the value
that is in effect for the most time in the period.
- Stable Export Limit is the stable export limit converted to a volume.
- Stable Import Limit is the stable import limit converted to a volume.
New variables on BM Unit Spreadsheets
The spreadsheets that generate BM unit derived data have been modified to add four new worksheets.
- Metered Volume at NBP is the metered volume modified by transmission losses to arrive at the
volume of power at the notional balancing point.
- BSUoS Charge is the BSUoS charge for the entity. Balancing Services Use of System (BSUoS)
is the charge levied by National Grid for keeping the lights on.
- SEL Volume is the stable export limit converted to a volume for the entity and time period.
- SIL Volume is the stable import limit converted to a volume for the entity and time period.
8th December, 2008
System Data Summary
The summary of system data spreadsheet for a time period
page has been changed to add system wide generation utilisation data. The new columns show total generation
FPN+BOA volume, total generation MEL volume, total generation metered volume, percentage total generation
FPN+BOA volume of total generation MEL volume and percentage total generation metered volume of total
generation MEL volume. These numbers allow the user to gain an idea of how much the national system is
stressed.
7th December, 2008
Aggregate Party Charges
The aggregate party charges spreadsheets have been
changed to add another worksheet with values for BSUoS charges.
20th November, 2008
Balancing Mechanism Data
Functionality has been added to display system frequency data.
- The view system frequency data page allows the
user to view the system frequency data from the balancing mechanism reporting service.
- The download system frequency data page allows the user
to download a file containing system frequency data from the balancing mechanism reporting service
for a date range.
11th November, 2008
Balancing Mechanism Data
The following additional messages are now being imported:
- "Non-BM STOR Out-turn" (BMRA.SYSTEM.NONBM)
- "Realtime Transmission System Frequency Data" (BMRA.SYSTEM.FREQ)
Functionality has been added to display Non-BM STOR Out-turn data.
22nd September, 2008
BM Unit Bid Offer Data Bulk Data Download
The BM Unit Bulk Data Download page has been modified
to provide more information. The new modification allows the user to download BM Unit bid offer data.
The new functionality combines data from BMRS data and settlement file data to get the most recent
data for a bid offer pair including the most up to date accepted bid and offer volumes and cashflows.
As always BMRS data whilst only a day behind is frequently inaccurate and is updated in the settlement
files. A little bit of clever analysis has been added which calculates the actual available volume
for the half hour for the bid offer pair. What does this mean? Essentially code has been written that
analyses the bid offer pair profile and FPN profile and MEL/MIL profile to find the proportion (if
any) of the bid offer pair that is available to NGC for balancing. For example, if a power station
BM Unit declares a bid offer pair with a level of 10MW, if the MEL profile is between this value and
the FPN then the all the volume of the bid offer pair will not be able to be utilised because of the
MEL ceiling. This has been quite difficult because it involves adding and subtracting MW profiles
which is logically difficult in code.
Please note that this page has the capability to produce very large files,
very quickly. Always save the output before trying to open it in Excel
because it is very likely that the size of the file will exceed Excel's
65536 line limit. This page is best used for populating your own desktop
databases (like Microsoft Access).
In addition to the BM unit, settlement date and settlement period and bid offer pair number the
data items available are as follows:
- Bid Price the bid price for the bid offer pair.
- Offer Price the offer price for the bid offer pair.
- Bid Cashflow the bid cashflow from bid offer acceptances that intersect this bid offer pair.
- Offer Cashflow the offer cashflow from bid offer acceptances that intersect this bid offer pair.
- Accepted Bid Volume the bid volume from bid offer acceptances that intersect this bid offer pair.
- Accepted Offer Volume any offer volume from bid offer acceptances that intersect this bid offer pair.
- Priced Accepted Bid Volume any bid volume from bid offer acceptances that intersect this bid offer pair that are not arbitrage or NIV tagged.
- Priced Accepted Offer Volume any offer cashflow from bid offer acceptances that intersect this bid offer pair that are not arbitrage of NIV tagged.
- Potential Volume Available the volume available on this bid offer pair after being sliced by MEL/MIL.
- Potential Volume Declared the volume declared on this bid offer pair with no MEL/MIL slicing.
- Potential Bid Cashflow Available the bid cashflow available on this bid offer pair after being sliced by MEL/MIL.
- Potential Offer Cashflow Available the offer cashflow available on this bid offer pair after being sliced by MEL/MIL.
- Potential Bid Cashflow Declared the bid cashflow available on this bid offer pair with no MEL/MIL slicing.
- Potential Offer Cashflow Declared the offer cashflow available on this bid offer pair with no MEL/MIL slicing.
- Time From the start time in minutes from the start of the period.
- Value From the start level.
- Time To the end time in minutes from the start of the period.
- Value To the end level
12th June, 2008
Balancing Mechanism Data
Functionality has been added to display bid and offer data.
1st January, 2008
Gas Fired Power Station Summary
The Gas Fired Power Station Summary page will now not
update as NGC has changed the interface. When the link to the new interface has been created. In
the interim, only data for October, November, December 2007 will be available.
18th December, 2007
Gas Fired Power Station Summary
The Gas Fired Power Station Summary page has been created
to generate spreadsheets summarising gas input, station MWHrs output and derived thermal efficiency of
gas fired BM Units. The CO2 emissions from burning this gas will be added to the spreadsheet
in the near future.
10th December, 2007
Hot Standby Server
For disaster recovery purposes the code base has been updated to allow the maintenance of hot standby
servers that can be used to replace the main server in case of a failure. Although the main server has never
failed this will allow the main server to be replaced with a hot standby system in two hours.
BSC Party and Trading Unit Relationships
The code to update relationships between BSC parties and Trading units has been updated to
derive the relationships using BM Unit data downloaded from the Elexon website for days between
the end of the settlement data and the previous day. This allows interconnector data to be displayed
one day behind instead of 5 working days behind.
Excel Spreadsheet Generator / Download Enhancement
The code to generate Excel spreadsheets has been improved to pass the spreadsheet size in bytes
through to the user's browser providing feedback during the final stage of download to the user's machine.
System Price Summary Spreadsheet Changed
The system price summary spreadsheet
page has been updated to provide more information. Settlement Period level data is now included.
31st October, 2007
Triad Data Summary Spreadsheet
The TNUoS Period Data Spreadsheet for a TNUoS Year
page has been updated to provide more information. Demand forecasts are now included, this
includes day ahead (DF), 2 to 14 days ahead (NDFD) and 2 to 52 weeks ahead (NDFW) data.
The spreadsheet has been modified further to present a table with peak data for each day and
the current predicted Triad numbers as well as a glossary.
15th October, 2007
BM Unit Summary Data changes
The backend processes that bring BM Unit data from settlement files and BMRS data
into summary tables has been finished. This functionality replaces the existing summary
functionality that takes data only from settlement files. The upshot of this change is
that now the summary data pages will have notification data up to a day behind. The
metered volume data remains five working days behind.
All spreadsheets that summarise BM unit data have been changed over to the new data
source. However, interconnector data and spreadsheets that reference BSC party level
information will not show data more recent than five working days behind because they
rely on BM Unit for BSC Party relationships that are derived from settlement data.
Energy Account Data Download
A new page has been added that can be used to download energy account data. The
download energy account data for a date range page
is used to download a CSV file containing energy account data for anything from one to all
BSC parties for a date range at settlement period resolution.
Balancing Mechanism Data
Functionality has been added to display total bid and offer data.
17th September, 2007
Internet Explorer 7 Issues
All pages that create XLS spreadsheets have now been converted to the new progress reporting functionality.
As part of this process the code that is used to select the time range of the spreadsheet has been modified to
allow different periods to be chosen. The allowable time periods are limited by performance concerns and Excel's
column limit of 255 and row limit of 65536. Time periods are:
- Day
- Week
- Month
- Quarter
- Calendar Year
- Financial Year
- TNUoS Period (Nov-Feb)
15th September, 2007
New Server
NETA reports has been moved to a new box. This box has more disk space arranged in a different way and faster
processors and more physical memory to improve performance.
10th September, 2007
Notifying BM Units XML-RPC function added to BMRS Data
A new BMRS XML-RPC service has been added which returns a list of BM Units which have FPN data for a specified date.
This service requires bmrs user priviliges. Visit the
bmra.getBMUnitsWhichNotify page to see more.
23rd August, 2007
Balancing Mechanism Data
The following additional messages are now being imported:
- "Balancing Services Adjustment Data (Post P78)" (BMRA.SYSTEM.NETBSAD)
- "Balancing Services Adjustment Data (Pre P78)" (BMRA.SYSTEM.BSAD)
7th August, 2007
Balancing Mechanism Data
The following additional messages are now being imported:
- "Total Bid Offer Data" (BMRA.SYSTEM.TBOD)
6th August, 2007
Balancing Mechanism Data
Functionality has been added to display 2-14 day and 2 to 52 week forecast data.
The root page for the 2-14 day forecast pages provides access to the following new pages:
The root page for the 2-52 week forecast pages provides access to the following new pages:
XML-RPC functions have been added to download the forecast data to the bmra XML-RPC package as follows:
31st July, 2007
Internet Explorer 7 Issues
Microsoft brought out a new version of its browser, internet explorer (IE),
some months ago. NETA reports customers have now started to upgrade and this
has brought to light an issue. The previous version of IE (6) had a response
time-out of 1 hour, the new version (IE 7) has a response timeout of 30 seconds.
Some of the reports on the site take a long time to generate because they contain
lots of complicated data and this new timeout setting means that IE 7 frequently
gives up when waiting for these big reports to complete. The message that IE7
shows when it times out is not helpful saying things like "Cannot Find Server"
which implies that there is a problem with the site which is not the case.
The solution to this problem is to change the way NETA reports generates reports.
When a report is requested, the user is diverted to a page which shows the progress
on the creation of the report. When the report is finished, a link is presented to
the user to allow them to fetch the generated report. This progress page refreshes
every 15 seconds which means that IE 7 now does not time out. It also provides more
reassurance to the user that something is happening.
Reports that have been changed are as follows:
Progress on conversion of the report generation pages will be reported here as it progresses.
18th July, 2007
Balancing Mechanism Data
The following additional messages are now being imported:
- "Surplus Forecast 2-52 weeks ahead" (BMRA.SYSTEM.OCNMFW)
- "Demand Forecast 2-52 weeks ahead" (BMRA.SYSTEM.NDFW)
17th July, 2007
CO2 Analysis Data
Two new pages have been added to the system to allow analysis of CO2 creation as
a by-product of power generation.
The settlement period level data page is used
to generate a spreadsheet with data at the settlement period level for each generation fuel type with
their contribution to the total CO2 footprint of the power industry.
The aggregated data page is used to generate
a spreadsheet with data from each generation fuel type with their contribution to the total
CO2 footprint of the power industry.
10th July, 2007
Balancing Mechanism Data
The following additional messages are now being imported:
- "Surplus Forecast 2-14 days ahead" (BMRA.SYSTEM.OCNMFD)
- "Demand Forecast 2-14 days ahead" (BMRA.SYSTEM.NDFD)
4th July, 2007
XML-RPC functions added to BMRS Data
Some functions have been added to the XML-RPC backend to allow querying of Balancing Mechanism data.
To access these just requires bmrs user priviliges. The functions are:
29th June, 2007
XML-RPC functions added to BMRS Data
Some functions have been added to the XML-RPC backend to allow querying of Balancing Mechanism data.
To access these just requires bmrs user priviliges. The functions are:
- bmra.getSystemWarningsForADay which returns system warning messages published on the specified day.
- bmra.getLatestINDOData which returns the latest Indicative Demand Out-turn (INDO) data for a specified day.
- bmra.getDynamicData which returns BM Unit single value dynamic data for an effective before date, BM Unit ID and data type.
- bmra.getRampRateData which returns BM Unit ramp rate dynamic data for an effective before date, BM Unit ID and data type.
- bmra.getPTAVandEBOCFData which returns Period Total Acceptance Volumes (PTAV) and Estimated Bid-Offer Cash Flows (EBOCF) for a specified BM Unit and day.
20th June, 2007
Download BM Unit Dynamic Data
The download BM unit ramp rate data page allows
the user to download a file containing the latest BM unit dynamic data from the balancing
mechanism reporting service for a date range.
The download STV BM unit dynamic data page allows
the user to download a file containing single time value BM unit dynamic data from the balancing
mechanism reporting service for a date range.
14th June, 2007
Latest BM Unit Dynamic Data
The view latest BM unit dynamic data
page allows the user to view the latest BM unit dynamic data from the balancing
mechanism reporting service.
History of BM Unit Dynamic Data
The view BM unit dynamic data history
page allows the user to view a history of BM unit dynamic data from the balancing
mechanism reporting service.
7th June, 2007
Bid Offer Acceptance Volume and Cashflow Data
The view Bid-Offer Acceptance Volumes
and Cashflow page allows the user to view the Period Total Bid-Offer Acceptance
Volumes alongside the Estimated Bid-Offer Cashflow data from the balancing mechanism
reporting service.
The download Bid-Offer Acceptance Volumes
and Cashflow page allows the user to download a file containing Period Total Bid-Offer
Acceptance Volumes and Estimated Bid-Offer Cashflow data from the balancing mechanism
reporting service for a date range.
30th May, 2007
Latest BM Unit Profile Data
The view latest BM Unit profile data page
allows the user to view the latest BM unit profile data (FPN, MEL, MIL, QPN, BOAL) for a
given date, period and BM unit from the balancing mechanism reporting service.
History of BM Unit Profile Data
The view history of BM Unit profile data page
allows the user to view the history of BM unit profile data (FPN, MEL, MIL, QPN, BOAL) for a
given date, period and BM unit from the balancing mechanism reporting service.
Download BM Unit Profile Data
The download BM Unit profile data page
allows the user to view the download BM unit profile data (FPN, MEL, MIL, QPN, BOAL) for a
given date and BM unit from the balancing mechanism reporting service.
15th May, 2007
BM Unit Bulk Data Download - BSC Party Filter
A new filter has been added to the
The Bulk Data Download page.
The new filter allows the user to extract settlement period BM Unit data
for a single BSC Party.
4th May, 2007
Demand Forecast (DF) Data
The Demand Forecast pages have been implemented to show
demand forecast (DF) data. There are four pages:
- The view latest demand forecast data page allows the
user to view the latest demand forecast data from the balancing mechanism reporting service.
- The view demand forecast data history page allows
the user to view a history of demand forecast data from the balancing mechanism reporting service.
This view only shows a record of each time the published value changed, i.e. duplicates are omitted.
- The download latest demand forecast data page allows the user
to download a file containing the latest demand forecast data from the balancing mechanism reporting service
for a date range.
- The download history of demand forecast data page allows the user
to download a file containing the full history of demand forecast data from the balancing mechanism reporting service
for a date range.
Indicated Demand (INDDEM) Data
The Indicated Demand pages have been implemented to show
indicated demand (INDDEM) data. There are four pages:
- The view latest indicated demand data page allows the
user to view the latest indicated demand data from the balancing mechanism reporting service.
- The view indicated demand data history page allows
the user to view a history of indicated demand data from the balancing mechanism reporting service.
This view only shows a record of each time the published value changed, i.e. duplicates are omitted.
- The download latest indicated demand data page allows the user
to download a file containing the latest indicated demand data from the balancing mechanism reporting service
for a date range.
- The download history of indicated demand data page allows the user
to download a file containing the full history of indicated demand data from the balancing mechanism reporting service
for a date range.
Indicated Generation (INDGEN) Data
The Indicated Generation pages have been implemented to show
indicated generation (INDGEN) data. There are four pages:
- The view latest indicated generation data page allows the
user to view the latest indicated generation data from the balancing mechanism reporting service.
- The view indicated generation data history page allows
the user to view a history of indicated generation data from the balancing mechanism reporting service.
This view only shows a record of each time the published value changed, i.e. duplicates are omitted.
- The download latest indicated generation data page allows the user
to download a file containing the latest indicated generation data from the balancing mechanism reporting service
for a date range.
- The download history of indicated generation data page allows the user
to download a file containing the full history of indicated generation data from the balancing mechanism reporting service
for a date range.
Indicated Imbalance (IMBALNGC) Data
The Indicated Imbalance pages have been implemented to show
indicated imbalance (IMBALNGC) data. There are four pages:
- The view latest indicated imbalance data page allows the
user to view the latest indicated imbalance data from the balancing mechanism reporting service.
- The view indicated imbalance data history page allows
the user to view a history of indicated imbalance data from the balancing mechanism reporting service.
This view only shows a record of each time the published value changed, i.e. duplicates are omitted.
- The download latest indicated imbalance data page allows the user
to download a file containing the latest indicated imbalance data from the balancing mechanism reporting service
for a date range.
- The download history of indicated imbalance data page allows the user
to download a file containing the full history of indicated imbalance data from the balancing mechanism reporting service
for a date range.
Indicated Margin (MELNGC) Data
The Indicated Margin pages have been implemented to show
indicated margin (MELNGC) data. There are four pages:
- The view latest indicated margin data page allows the
user to view the latest indicated margin data from the balancing mechanism reporting service.
- The view indicated margin data history page allows
the user to view a history of indicated margin data from the balancing mechanism reporting service.
This view only shows a record of each time the published value changed, i.e. duplicates are omitted.
- The download latest indicated margin data page allows the user
to download a file containing the latest indicated margin data from the balancing mechanism reporting service
for a date range.
- The download history of indicated margin data page allows the user
to download a file containing the full history of indicated margin data from the balancing mechanism reporting service
for a date range.
13th April, 2007
INDO Data Download
The download initial demand outturn data page allows the user
to download a file containing initial demand outturn data from the balancing mechanism reporting service
for a date range.
SYSWARN Data Download
The download system warnings page
allows the user to download the system warnings from the balancing mechanism reporting service
for a given date range.
6th April, 2007
INDO Data History
The view initial demand outturn data history
page allows the user to view a history of initial demand outturn data from the balancing
mechanism reporting service.
5th April, 2007
Latest INDO Data
The view latest initial demand outturn data page
allows the user to view the latest initial demand outturn data from the balancing mechanism
reporting service.
23rd March, 2007
Transmission System Warnings by Date
The view transmission system warnings data by
date range page allows the user to view transmission system warnings (NISM, HRDR, DCI)
from the balancing mechanism reporting service for a date range.
7th March, 2007
BMRS System Warnings by Date
The view system warnings data by date page
allows the user to view the system warnings from the balancing mechanism reporting service
for a date.
6th March, 2007
BMRS Latest System Warnings
Work has commenced on the BMRS data display functionality.
The view latest system warnings data page
allows the user to view the latest system warnings from the balancing mechanism reporting service.
28th February, 2007
TNUoS Period Prediction for 2006/7
Using the TNUoS Period Data Spreadsheet for a TNUoS Year
the EnAppSys prediction of TNUoS periods for 2006/7 is as follows:
23rd Jan, Period 35, 57,368 MW (SF)
20th Dec, Period 35, 56,969 MW (R1)
8th Feb, Period 36, 56,736 MW (II)
28th February, 2007
Balancing Mechanism Data
The following additional messages are now being imported:
- "Estimated Buy and Sell Price (Pre P78)" (BMRA.SYSTEM.EBSP)
27th February, 2007
Balancing Mechanism Data
The following additional messages are now being imported:
- "Estimated Buy and Sell Price (Post P78)" (BMRA.SYSTEM.NETEBSP)
- "Credit Default Notice" (BMRA.BP.*.CDN)
25th February, 2007
Balancing Mechanism Data
The following additional messages are now being imported:
- "Market Index Data" (BMRA.SYSTEM.MID)
- "BM Unit Applicable Balancing Services Volume" (BMRA.BM.*.QAS)
21st February, 2007
Balancing Mechanism Data
The import of data from the low grade historical BM service is almost complete.
The additional data now occupies in the region of 200 GB of disk space.
A new section has been added to the "What You Get" section
to detail the new functionality available and planed. This new functionality has been
entitled "Phase 4".
The following messages have been imported:
- "Initial Demand Outurn" (BMRA.SYSTEM.INDO)
- "Demand Forecast" (BMRA.SYSTEM.DF.*)
- "Indicated Demand" (BMRA.SYSTEM.INDDEM.*)
- "Indicated Generation" (BMRA.SYSTEM.INDGEN.*)
- "Indicated Imbalance" (BMRA.SYSTEM.IMBALNGC.*)
- "Indicated Margin" (BMRA.SYSTEM.MELNGC.*)
- "Final Physical Notification" (BMRA.BM.*.FPN)
- "Quiescent Physical Notification" (BMRA.BM.*.QPN)
- "Maximum Export Limit" (BMRA.BM.*.MEL)
- "Maximum Import Limit" (BMRA.BM.*.MIL)
- "Bid-Offer Pairs" (BMRA.BM.*.BOD.*)
- "Bid-Offer Acceptances" (BMRA.BM.*.BOAL)
- "Period B-O Acceptance Volumes" (BMRA.BM.*.BOAV.*)
- "Period Total B-O Acceptance Volume" (BMRA.BM.*.PTAV.*)
- "Estimated period B-O cash flows" (BMRA.BM.*.EBOCF.*)
- "Run Up Rates Export" (BMRA.DYNAMIC.*.RURE)
- "Run Up Rates Import" (BMRA.DYNAMIC.*.RURI)
- "Run Down Rates Export" (BMRA.DYNAMIC.*.RDRE)
- "Run Down Rates Import" (BMRA.DYNAMIC.*.RDRI)
- "Maximum Delivery Period" (BMRA.DYNAMIC.*.MDP)
- "Maximum Delivery Volume" (BMRA.DYNAMIC.*.MDV)
- "Minimum Zero Time" (BMRA.DYNAMIC.*.MZT)
- "Minimum Non-Zero Time" (BMRA.DYNAMIC.*.MNZT)
- "Notice to Deliver Bids" (BMRA.DYNAMIC.*.NTB)
- "Notice to Deliver Offers" (BMRA.DYNAMIC.*.NTO)
- "Notice to Deviate from Zero" (BMRA.DYNAMIC.*.NDZ)
- "Stable Export Limit" (BMRA.DYNAMIC.*.SEL)
- "Stable Import Limit" (BMRA.DYNAMIC.*.SIL)
The following message are still to be imported:
- "Market Index Data" (BMRA.SYSTEM.MID)
- "System Warnings" (BMRA.SYSTEM.SYSWARN)
- "Total Bid Offer Data" (BMRA.SYSTEM.TBOD)
- "Balancing Services Adjustment Data (Pre P78)" (BMRA.SYSTEM.BSAD)
- "BMRS Information Message" (BMRA.INFO.MSG)
- "Estimated Buy and Sell Price (Post P78)" (BMRA.SYSTEM.NETEBSP)
- "Estimated Buy and Sell Price (Pre P78)" (BMRA.SYSTEM.EBSP)
- "Balancing Services Adjustment Data (Post P78)" (BMRA.SYSTEM.NETBSAD)
- "System Messages" (BMRA.SYSTEM.SYSMSG)
- "Surplus Forecast 2-14 days ahead" (BMRA.SYSTEM.OCNMFD)
- "Surplus Forecast 2-52 weeks ahead" (BMRA.SYSTEM.OCNMFW)
- "Demand Forecast 2-14 days ahead" (BMRA.SYSTEM.NDFD)
- "Demand Forecast 2-52 weeks ahead" (BMRA.SYSTEM.NDFW)
- "Credit Default Notice" (BMRA.BP.*.CDN)
- "BM Unit Applicable Balancing Services Volume" (BMRA.BM.*.QAS)
11th February, 2007
Auto-Reporting
The auto-reporting functionality has been improved and some niggles addressed. See
the reports configuration page for more details.
5th February, 2007
BM Unit Bulk Data Download
A new page has been added to the BM Unit summary page.
The Bulk Data Download page is used to extract data from
at BM Unit level using different filters. The first set of filters
allows data to be extracted for BM Units at settlement period level
using a BM Unit restriction based on the BM Unit type which can be
chosen from one of : Notifying BM Units, Notifying CVA BM Units,
Notifying SVA BM Units, Embedded CVA BMUnits ('E_') Only,
Directly Connected CVA BMUnits ('T_' and 'M_') Only,
Interconnector BMUnits ('I_') Only or SVA BMUnits ('2_') Only.
Please note that this page has the capability to produce very large files,
very quickly. Always save the output before trying to open it in Excel
because it is very likely that the size of the file will exceed Excel's
65536 line limit. This page is best used for populating your own desktop
databases (like Microsoft Access).
23rd-31st January, 2007
Problem with Elexon Supplying SAA-I0142 version 6 files
The November release has eventually rippled through to the system that serves P114 data files.
A failure in the copy job at the Elexon end meant that SAA-I0142 files were not available between
Tuesday 23rd and Monday 29th January. The issue was raised with Elexon and has been resolved. This
has caused a back log which has taken a day to get through. The databases are now back-up to date
with SAA data.
15th January, 2007
Balancing Mechanism Reporting Service Historical Data Service Goes Live
Elexon have gone live with the historical BMRS data service and data now goes back to 1st Jan, 2002.
NETA reports has been set on with importing this data and it is estimated that it will take approximately
a month to upload the five and a bit years of data into the database.
15th December, 2006
Triad Data Summary Spreadsheet
A new page has been added to the summary data section.
The TNUoS Period Data Spreadsheet for a TNUoS Year
page is used to generate an excel spreadsheet that contains system period demand
for a TNUoS year (Nov to Feb). The spreadsheet uses the same calculation methodology as NGET
which means that it can be used to validate NGET calculations of TNUoS periods and also
to back up ongoing analysis during a winter so that potential TRIAD periods can be called
with more accuracy. The spreadsheet contains INDO data for each day as well as metered data
as appropriate for as many settlement runs as necessary upto about eight days after the SF
run for the last day of February.
30th November, 2006
Balancing Mechanism Reporting Service Data
After some discussions with Elexon and co-incident with a project they are running internally,
NETA Reports is starting to be modified to take in data from the Balancing Mechanism Reporting Service.
This data is picked up from the BMRS as a large data file with data for the previous day at around
2AM. Although this data is only notification data it will combine with the existing settlement data that
we get five working days behind to add extra value to the service.
The data currently goes back to 10th August, 2006. It is envisaged that this data will be used to
provide BM analysis and summary reporting which is only one day behind. NETA reports is inching towards
real-time market information.
20th July, 2006
BM Units for a Fuel Type Summary for a Settlement Date
A new page has been added to the BM Unit summary section.
The Excel BM Units for Fuel Type Summary for a Settlement Date page
is used to generate an excel spreadsheet that contains summary
data for each BM unit of a fuel type for a settlement date at settlement period resolution.
9th April, 2006
Energy Account Summary for a Settlement Date
A new page has been added to the energy account summary section.
The Excel energy account data for a settlement date page
is used to generate an excel spreadsheet that contains energy account data for all
BSC parties for a settlement date at settlement period resolution.
15th March, 2006
NETA Reports has moved (again)
The system has been moved to a new server set-up. This box has four 64 bit processor cores and 1.5GB of storage.
It should provide enough potential growing room for the system for another two years.
The box is still co-located at its current location where availability has been in excess of 99.8 % in the last year.
20th February, 2006
XML-RPC functions added to Elexon BM Unit Data
Some functions have been added to the XML-RPC backend to allow querying of Elexon
BM Unit data. To access these just requires guest user priviliges.
18th December, 2005
Auto-Reporting Enabled
Phase 3 of the development of www.netareports.com commences. Auto-Reporting
allows the user to define a customisable reports which can then be automatically
emailed to them when the data becomes available on the service.
Current reports available are at the fuel type level, the super party level
and a combinations of fuel type and super party. Reports are also available at
three resolutions, daily, weekly and monthly.
The fuel type level reports allow the user to view which fuel technologies are
used to generate electricity, which fuel technologies get called in the balancing
mechanism and how these fuel technologies perform in non delivery charges.
The super party level reports aggregate data at the level of the ownership
of assets, these reports allow the user to view the market share of super parties
in generation, which super parties get called in the balancing mechanism and how
these super parties perform in non delivery charges.
The super party fuel type reports aggregate data at the super party and fuel
type level allowing the user to see which super parties use which fuel types.
These reports allow the user to see market share in the SVA market and market share
in each individual generation technology.
These reports are accessed via the reports base page .
A subset of the available reports have been made available as a free report which
is available for download at the free report page.
Free reports can be downloaded via the free email page.
6th November, 2005
What You Get Updated
The "what you get" section has been updated with additional detail added to the
phase 1 section and the section for
phase 3 added.
11th August, 2005
New BM Unit Performance Variable Added
A new BM Unit performance variable has been added. This variable called
"Non Delivery Charge Per Accepted MWHr" shows the size of non delivery charges
as a proportion of the number of MWHrs accepted. This gives an indication of
the performance of BM units at meeting their contracted bid offer acceptances
in the balancing mechanism.
8th August, 2005
Energy Account Data Section
Work on the energy account section has started. This allows the user to rate BSC party
performance based on energy account numbers. Data items displayed are as follows :
| BSSC Limited Cost Allocation |
The aggregate BSSC limited cost allocation for the day. |
| Energy Imbalance Charge |
The aggregate energy imbalance charge for the day. |
| Information Imbalance Charge |
The aggregate information imbalance charge for the day. |
| Residual Cashflow Reallocation Charge |
The aggregate R.C.R.C. (beerfund) for the day. |
| Bilateral Contract Volume Net |
The aggregate net bilateral contract volume for the day. |
| Bilateral Contract Volume Absolute |
The aggregate absolute bilateral contract volume for the day. |
| Positive Balancing Services Volume |
The aggregate of all positive balancing services volumes for the day. |
| Negative Balancing Services Volume |
The aggregate of all negative balancing services volumes for the day. |
| Balancing Services Volume Net |
The aggregate net balancing services volume for the day. |
| Balancing Services Volume Absolute |
The aggregate absolute balancing services volume for the day. |
| Energy Imbalance Volume Net |
The aggregate net energy imbalance volume for the day. |
| Energy Imbalance Volume Absolute |
The aggregate absolute energy imbalance volume for the day. |
| Credited Energy Volume Net |
The aggregate net credited energy volume for the day. |
| Credited Energy Volume Absolute |
The aggregate absolute credited energy volume for the day. |
| Energy Imbalance Percentage |
The energy imbalance percentage (absolute energy imbalance volume / absolute bilateral contract volume) for the day. |
| MVRed Energy Volume Net |
The aggregate net MVRed energy volume into the energy account for the day. |
| MVRed Energy Volume Absolute |
The aggregate absolute MVRed energy volume into the energy account for the day. |
Three pages have been added as detailed below.
Energy Account Summary Data for a Date Range.
The Energy Account Summary Data for a Date Range
page displays energy account data aggregated to the BSC party level. Data is shown for one
BSC party and a range of dates.
Energy Account Summary Data for a Settlement Date.
The Energy Account Summary Data for a Settlement Date
page displays data energy account data aggregated to the BSC party level. Data is shown for
all BSC parties for a single settlement date.
Excel Daily Energy Account Summary Data for a Month.
The Excel Daily Energy Account Summary Data for a Month
page is used to generate a spreadsheet containing energy account data aggregated to the BSC
party level. Data is shown for all BSC parties at settlement date resolution for a month.
25th July, 2005
Super Party / Fuel Type Daily Volume Data.
The Super Party / Fuel Type Daily Volume Data
page has been finished. It is used to generate an excel spreadsheet containing daily metered
volume totals for fuel types from BM units grouped by super party. The data is displayed
for a calendar month or the whole date range on the system.
15th July, 2005
Metered Volume Reallocations for a BM Unit
The MVR summary data for a BM Unit
page has been finished. It shows all metered volume reallocations (MVRs) for a
BM Unit over the range of settlement dates the system holds. The data are
collated into one large table. The table is sortable by source
party and BM unit or destination energy account.
Metered Volume Reallocations - Relationships
The MVR summary data - relationships
page has been finished. The page summarises MVR data to generate a table listing
the effective from and to dates of the relationships and the total volume
reallocated for the period. The table is sortable by source
party and BM unit or destination energy account.
13th July, 2005
All Metered Volume Reallocations for a Day
The MVR summary data for a settlement day
page has been finished. It shows all metered volume reallocations (MVRs) for all parties
that MVR. The data are collated into one large table. The table is sortable by source
party and BM unit or destination energy account.
9th July, 2005
Trading Unit Volumes Spreadsheet for a Month
The trading unit volumes spreadsheet
for a month page has been finished. It has been created to generate an excel
spreadsheet that contains trading unit volumes for a month.
It contains six worksheets summarising data as follows :
- Trading unit volumes for a month at settlement period resolution level.
- The minimum of the trading unit volume for each settlement date for a month.
- The maximum of the trading unit volume for each settlement date for a month.
- The total of the trading unit volume for each settlement date for a month.
- The average of the trading unit volume for each settlement date for a month.
- The standard deviation of the trading unit volume for each settlement date for a month.
8th July, 2005
What You Get pages modified.
The what you get pages have been modified. The pages now list
all functionality and show the phase 2 split between basic and enhanced functionality.
7th July, 2005
Summary of System Price Spreadsheet Since the Start of NETA
The Summary of System Price Spreadsheet
Since the Start of NETA page has been finished. It has been created to
generate an excel spreadsheet that contains system price data.
It contains four spreadsheets summarising data at :
- EFA block level.
- settlement date level.
- week level.
- month level.
29th June, 2005
Enhancements to SVA Market Share Spreadsheet Functionality
The SVA Market Share by BSC Party Spreadsheet
for a Month and SVA Market Share by Super Party
Spreadsheet for a Month pages have been enhanced. The spreadsheets show metered volumes
per BSC party and Super party respectively for SVA containers for each GSP group at settlement
date resolution. The enhancements are as follows :
- the inclusion of an aggregate spreadsheet that sums the metered volumes across all GSP
groups to come up with a total per settlement day for each party.
- the inclusion of a summary spreadsheet that sums the metered volumes for all settlement
dates across all GSP groups to arrive at a market share value for the month.
- an option to produce data for the whole date range.
20th June, 2005
Enhancements to Fuel Type Daily Data
The fuel type daily data page which is used
to generate a spreadsheet with ALL BM Units grouped by fuel type to arrive at a daily
total per fuel type has been enhanced. A summary totaling the various parameters by fuel type
for the month has been added to aid in data analysis.
16th June, 2005
Summary of System Data Spreadsheet for a Month
The Summary of System Data
Spreadsheet for a Month page has been finished. It has been created to
generate an excel spreadsheet that contains data at period level and
aggregated at a daily level.
14th June, 2005
Move to New Home Complete
The domain name www.netareports.com now points to the location of the new server
so the move of the site is now complete.
10th June, 2005
BM Units Which Have BOAs Excel Spreadsheet For a Month
The BM Units Which Have BOAs
Excel Spreadsheet For a Month page has been finished. It has been created to
generate an excel spreadsheet that contains summary data for each BM unit that
has had a bid / offer accepted for a month at settlement date resolution.
6th June, 2005
Bid Offer Acceptance Summary by Fuel Type Excel Spreadsheet For a Month
The Bid Offer Acceptance Summary by Fuel Type
Excel Spreadsheet For a Month page has been finished. It has been created to
generate an excel spreadsheet that contains counts of
Bid and Offer Acceptances by fuel type for a month at settlement date resolution. The
spreadsheet contains a system summary worksheet, individual worksheets per
fuel type and worksheets summarising BOA Count, BM Units Participating, Trading
Units Participating and BSC Parties Participating by fuel type.
2nd June, 2005
Enhancements to BM Unit Summary Data
The code that creates summaries of BM Unit performance has been re-written. The
first key change is that the undo bid and offer data has been striped out. Previously
bid and offer volumes were aggregated together in the conventional format. Now accepted
bids which are undoing previously accepted offers are striped out as "undo" offers.
Similarly the corresponding undo bids can be stripped out also. This means there are
now new worksheets and columns in all spreadsheet reports showing the following:
- Total Accepted Undo Bid Volume - The aggregate undo bid volume.
- Total Accepted Undo Offer Volume - The aggregate undo offer volume.
- Undo Bid Cashflow - The aggregate undo bid cashflow.
- Undo Offer Volume - The aggregate undo offer cashflow.
- Undo Bid Price - The aggregate undo bid price.
- Undo Offer Price - The aggregate undo offer price.
Another change is the creation of a BOA Count. This is the number of Bid/Offer
acceptances that touch the time period in question for the entity. i.e. if the report
is daily fuel type data then the report will show the number of BOAs for that fuel type
and that day.
31st May, 2005
NETA Reports has a new home ...
NETA reports currently runs on a rented server in a data centre somewhere in Slough. Today
phase one of a migration process was completed when the system was installed on a new box
running inside a data centre in Middlesbrough. The new platform has more disk space as the
database backend for the server is currently 100GB and forecast to grow to 250GB in six months.
Data updates on the production box will now pause whilst the new box has final testing in its
new location. When data update is complete the DNS settings for the www.netareports.com domain will
redirect to this new box.
One of the enhancements to the system implemented on the new box is a revised BM unit summary
system that splits achieved bid and offer prices to identify reverse prices and volumes.

NETA Reports' New Home
14th May, 2005
SVA Market Share by BSC Party Spreadsheet for a Month
The SVA Market Share by BSC Party Spreadsheet
for a Month page has been finished. It has been created to generate an excel
spreadsheet that contains metered volumes per BSC party for SVA containers for
each GSP group at settlement date resolution.
New Concept Introduced
A new concept has been introduced at www.netareports.com, that of the "Super Party".
The super party is a collection of BSC parties all owned by the same group. The
creation of super parties will allow further aggregation of data at the level
of big organisations such as RWE - Npower and E.on - Powergen.
SVA Market Share by Super Party Spreadsheet for a Month
The SVA Market Share by Super Party
Spreadsheet for a Month page has been finished. It has been created to
generate an excel spreadsheet that contains metered volumes per Super party
for SVA containers for each GSP group at settlement date resolution.
13th May, 2005
Excel BM Unit Summary Aggregated at BSC Party Level for a Month
The Excel BM Unit
Summary Aggregated at BSC Party Level for a Month page
has been finished. It has been created to generate an excel spreadsheet that contains summary
data aggregated at BSC Party level for BM units for a month at settlement date resolution.
Excel BM Units Summary Aggregated at BSC Party for a Fuel Type for a Month
The Excel BM Units Summary
Aggregated at BSC Party for a Fuel Type for a Month page
has been finished. It has been created to generate an excel spreadsheet that contains summary
data aggregated at BSC Party level for BM units for a Fuel Type
for a month at settlement date resolution.
12th May, 2005
Excel BM Units for Fuel Type Summary for a Month
The Excel BM Units for Fuel Type Summary for a Month page
has been finished. It has been created to generate an excel spreadsheet that contains summary
data for each BM unit of a fuel type for a month at settlement date resolution.
8th May, 2005
SVA Container Fuel Types
The "SVA Container" fuel type has been disaggregated to the 14 GSP groups to
allow market share by GSP group to be analysed.
Excel Interconnector Daily Data for a Month
The excel interconnector daily data for a month page
has been finished. It has been created to display interconnector trades for a month for all
interconnectors at a settlement date resolution.
7th May, 2005
Excel BM Unit Daily Data for a Month
The excel BM unit daily data for a month page
has been finished. It has been created to display BM unit data for a month for all
BM units at a settlement date resolution.
2nd May, 2005
Elexon Period Charges Spreadsheet
A page has been written in the summary section of the site that generates an excel
spreadsheet that contains period party charges for a month for each BSC Party.
Click here to view the page.
24th April, 2005
Fuel Type Data for a Day
The fuel type data for a day page is used
to generate a spreadsheet with ALL BM Units grouped by fuel type to arrive at a total
value for a settlement period per fuel type for a day. A days data is generated. Data displayed
is volumes and balancing mechanism acceptance volume, cashflow and price data.
15th April, 2005
First RF Data Arrives
The final reconcilliation settlement numbers have arrived in the database for settlement date
24th February, 2004.
13th April, 2005
Excel Interconnector Period Data for a Month
The excel interconnector period data for a month page
has been finished. It has been created to display interconnector trades for a month for all
interconnectors at a settlement period resolution.
12th April, 2005
CDCA-I042 Data Condition Report Commissioned
Code to display an overview of the status of BM unit metered volumes as
a colour coded map has been commissioned.
Click here to view the page.
1st April, 2005
CDCA-I029 History Display Commissioned
Code to display a history of CDCA 29 aggregated GSP group take volumes as they change over
settlement runs has been commissioned. Click
here to view the page.
CDCA-I030 History Displays Commissioned
Code to display a history of CDCA 30 aggregated interconnector volumes
in a GSP group as they change over settlement runs has been commissioned.
Click here to view the page.
Code to display a history of CDCA 30 aggregated grid supply point volumes
in a GSP group as they change over settlement runs has been commissioned.
Click here to view the page.
Code to display a history of CDCA 30 aggregated inter GSP group connection
volumes in a GSP group as they change over settlement runs has been commissioned.
Click here to view the page.
CDCA-I042 History Display Commissioned
Code to display a history of CDCA 42 aggregated meter volumes as they change
over settlement runs has been commissioned.
Click here to view the page.
21st March, 2005
BM Units Summary by Fuel Type
Two new pages have been added to the dressed data section.
-
The CVA fuel type volume data page is used
to generate a spreadsheet with CVA BM Units grouped by fuel type to arrive at a daily
total per fuel type. A months data is generated.
-
The fuel type data page is used
to generate a spreadsheet with ALL BM Units grouped by fuel type to arrive at a daily
total per fuel type. A months data is generated. Data displayed is volumes and balancing mechanism
acceptance volume, cashflow and price data.
5th March, 2005
Data File Download
The download data files page has been finished. It is used to download
data files for a file type and settlement date.
28th February, 2005
Interconnector Trade Data
The interconnector trade data page has been finished. It
has been created to display interconnector trades for a settlement date and interconnector.
16th February, 2005
Elexon BM Unit Data
The Elexon BM Unit data pages have been changed to
aggregate BM Unit data downloaded from the Elexon website at new levels.
The fuel type details page displays data extracted
from Elexon BM Unit data at the fuel type level.
The system summary data page aggregates data extracted
from Elexon BM Unit data at the system level.
1st February, 2005
Elexon BM Unit Data
The Elexon BM Unit data page is used to access data
extracted from data downloaded from the Elexon website. The data is downloaded from the
CRS Registration Data section of the Elexon website.
The BM Unit details page displays data extracted
from Elexon BM Unit data at the BM Unit level.
The BSC Party summary data page aggregates data extracted
from Elexon BM Unit data at the BSC Party level.
10th January, 2005
BM Unit Summary Data
Two new pages have been written summarising BM unit performance.
Using the BM Unit summary data for a settlement date
page the user can compare the performance of BM units on different parameters.
The choices of parameter to analyse on are as follows:
- All BM Units Ordered By Name
- All Interconnector BM Units Ordered By Name
- Order By Total Accepted Bid Volume
- Order By Total Accepted Offer Volume
- Order By Bid Cashflow
- Order By Offer Cashflow
- Order By Information Imbalance Volume
- Order By Non Delivery Charge
- Order By Non Delivered Bid Volume
- Order By Non Delivered Offer Volume
- Order By Bid Price
- Order By Offer Price
- Order By FPN
- Order By Metered Volume
- Order By Bid / Offer Volume
Using the BM Unit summary data for a date range page
the user can view a summary of all data for a BM Unit for a range of settlement dates.
10th October, 2004
Elexon Daily Charges Spreadsheet
A page has been written in the summary section of the site that generates an excel
spreadsheet that contains daily party charges for a month for each BSC Party.
Click here to view the page.
5th September, 2004
"What You Get" Section Started
A new section of the site has been added which details the deliverables of the
www.netareports.com web-service. This section will constantly be update as the
web-service grows. The section has been entitled "What You Get" and
can be found by following this link.
3rd September, 2004
BOD Page Commissioned
A new page has been completed to view submitted bid and offer data (BOD) for a
BM unit that notifies its position to NGC. Data can either be displayed as notified
to NGC or as date/time profiles for a settlement period.
Click here to view the page.
BOA Page Commissioned
A new page has been completed to view bid and offer acceptances data (BOA) for
a BM unit that notifies its position to NGC. Data can either be displayed as
notified by NGC or as date/time profiles for each acceptance.
Click here to view the page.
1st September, 2004
FPN, MEL and MIL Page Commissioned
A new page has been completed to view profiles of final physical notification
(FPN), maximum export limit (MEL) and maximum import limit (MIL) for a BM unit
that notifies its position to NGC. Data can either be displayed as notified to NGC
or as date/time profiles for a day.
Click here to view the page.
30th August, 2004
CDCA 42 Daily Data
A new page has been added to the CDCA 42 data pages that generates an excel
spreadsheet that contains total generation values for each BM Unit for a month.
Click here to view the page.
18th August, 2004
MVR Pages Commissioned
Two new sets of pages have been completed to show metered volume re-allocation
data. The MVRs out pages show metered volume
re-allocations from BM units to other BSC parties. The
MVRs in pages show metered volume
re-allocations from BM units of other BSC parties to an energy account.
7th August, 2004
Licence Agreement Changed
The licence agreement for accessing data on the site
has been changed after comments from Elexon.
16th July, 2004
Licence Agreement Completed
The licence agreement for accessing data on the site
has been completed.
11th July, 2004
BM Unit (BPx) Pages Commissioned
The BM unit (BPx) pages
have been commissioned. These pages show data at an BM Unit level
(BPx records) at a settlement period resolution.
The data comes from the SAA-I0142 files. This page includes the following
parameters :
- Information Imbalance Cashflow - The charge for not delivering to FPN modified by any bids or offers. Always zero because prices for information imbalance are zero.
- BM Unit Period Non Delivery Charge - Amount of bid / offer acceptance not delivered.
- Period FPN - The volume declared as an FPN.
- Period BM Unit Bid Offer Volume - The volume required to be delivered as any bid and offer acceptances.
- Period Information Imbalance Volume - The difference between the FPN modified by any bids or offers and the volume generated / consumed by the BM unit.
- Period Expected Metered Volume - The FPN modified by any bids or offers.
- BM Unit Metered Volume - The total volume generated / consumed by the BM unit.
- Period BM Unit Non Delivered Bid Volume - The amount of an accepted bid that has not been delivered.
- Period BM Unit Non Delivered Offer Volume - The amount of an accepted offer that has not been delivered.
- Transmission Loss Factor - The transmission loss factor of the BM Unit.
- Transmission Loss Multiplier - The transmission loss multiplier of the BM Unit.
- Trading Unit - The trading unit the BM Unit sits in.
- Total Trading Unit Metered Volume - The total volume of the trading unit the BM Unit sits in.
- BM Unit Applicable Balancing Services Volume - The energy the BM unit has delivered to the balancing mechanism.
Energy Account (APD) Pages Commissioned
The energy account (APD) pages
have been commissioned. These pages show data at an energy account level
(APD records) at a settlement period resolution.
The data comes from the SAA-I0142 files. This page includes the following
parameters :
- BSSC Limited Cost Allocation
- Energy Imbalance Charge
- Information Imbalance Charge
- Residual Cashflow Reallocation Charge
- Account Bilateral Contract Volume - The net contract position on the energy account.
- Account Period Balancing Services Volume
- Account Energy Imbalance Volume
- Account Credited Energy Volume - The energy consumed (-ve) or generated (+ve) (modified by LLF/TLM)
- Residual Cashflow Reallocation Proportion
9th July, 2004
SSL Implemented
EnAppSys has chosen thawte to provide
an SSL certificate to secure entry of personal data and display of sensitive
market data.
8th July, 2004
System Parameters (SPI) Pages Commissioned
The system parameters (SPI) pages
have been commissioned. These pages show the system parameter
records at a settlement period resolution.
The data comes from the SAA-I0142 files. This page includes the following
parameters at a whole system level:
- System Buy Price - The price paid for topping up a BSC parties imbalance.
- System Sell Price - The price paid for spill in a BSC parties imbalance.
- Price Derivation - The system prices derivation rule.
- Total Demand
- Total Generation
- Total Period Applicable Balancing Services Volume
- Information Imbalance Price 1
- Information Imbalance Price 2
- Notional Reserve Limit
- Total NIV Tagged Volume
- Arbitrage Flag
- Continuous Acceptance Duration Limit
- Deminimis Acceptance Threshold
- Buy Price Cost Adjustment
- Buy Price Volume Adjustment
- Buy Price Price Adjust
- Net System Buy Price Volume Adjustment
- Sell Price Cost Adjustment
- Sell Price Volume Adjustment
- Net System Sell Price Volume Adjustment
- Sell Price Price Adjust
Trading Unit Total Volume Pages Commissioned
The trading unit total volume data pages
have been commissioned. These pages show the total volume for each trading unit
at a settlement period resolution. The data comes from the SAA-I0142 files.
6th July, 2004
Market Index Data Pages Commissioned
The Market Index data pages
have been commissioned. These pages show the market index data provided by
APX and UKPX at a settlement period resolution. The data comes from the SAA-I0142
files.
5th July, 2004
Period Elexon Party Charges Pages Commissioned
The Period Elexon Party Charges pages
have been commissioned. These pages show the elexon charges payable / received
by a BSC Party at a settlement period resolution. The data comes from the SAA-I0142
files.
4th July, 2004
System Beerfund Page Commissioned
The System beerfund pages
have been commissioned to display the system residual cashflow reallocation
charge (A.K.A. the beerfund) data from the SAA-I0142 files on a period basis.
System Parameters (SSD) Pages Commissioned
The system parameters (SSD) pages
have been commissioned to display system parameter data from the
SAA-I0142 files on a period basis. This page includes the following
parameters at a whole system level:
- Period BSSC Limited Costs
- System Operator BM Cashflow
- Information Imbalance Price 1
- Information Imbalance Price 2
- System Buy Price - The price paid for topping up a BSC parties imbalance.
- System Sell Price - The price paid for spill in a BSC parties imbalance.
- Price Derivation - The system prices derivation rule.
- Total System BM Cashflow
- Total System Energy Imbalance Cashflow
- Total System Non Delivery Charge
- System Total Accepted Bid Volume
- System Total Unpriced Accepted Bid Volume
- System Total Priced Accepted Bid Volume
- Total System Energy Contract Volume
- NIV Tagged System Total Unpriced Bid Volume
- System Total Accepted Offer Volume
- NIV Tagged System Total Unpriced Offer Volume
- Net Imbalance Volume
- Total NIV Tagged Volume
- NIV Tagged SBVA
- NIV Tagged SSVA
- System Total Unpriced Accepted Offer Volume
- System Total Priced Accepted Offer Volume
- Total System Energy Imbalance Volume
- Total System Period Credited Energy Volume - Maintained for Compatibility with previous versions of the SAA-I014 file.
- Residual Cashflow Reallocation Denominator
- Total System Residual Cashflow
- Total System Information Imbalance Charge
- Sell Price Cost Adjustment
- Buy Price Cost Adjustment
- Sell Price Volume Adjustment
- Buy Price Volume Adjustment
- Net System Sell Price Volume Adjustment
- Net System Buy Price Volume Adjustment
- Sell Price Price Adjust
- Buy Price Price Adjust
- System Operator Reference Price - Maintained for Compatibility with previous versions of the SAA-I014 file.
- Total Period Applicable Balancing Services Volume
- System Operator Production Imbalance
- System Operator Consumption Imbalance
- NIV Untagged EBCA
- NIV Untagged EBVA
- NIV Untagged ESCA
- NIV Untagged ESVA
3rd July, 2004
System Prices Pages Commissioned
The System Prices pages
have been commissioned to display the system buy and sell price data from the
SAA-I0142 files.
2nd July, 2004
Aggregate Elexon Party Charges Pages Modified
The Aggregate Elexon Party Charges pages
have been modified to include another column showing the net credit to the BSC party.
XML-RPC Interface to SAA Data Commissioned
An XML-RPC package has been added that allows access to SAA data.
23rd June, 2004
First SAA-I0142 Display Commissioned
The first pages (of many) showing SAA-I0142 data has been written and commissioned.
The Aggregate Elexon Party Charges pages shows
summarised data at a day level on credits and debits for all BSC parties.
- BSSC Limited Cost Allocation - always zero.
- BM Unit Cashflow - Total amount of money made / lost by a BSC Party on
the balancing mechanism.
- Energy Imbalance Cashflow - Total amount of money made / lost by a BSC
Party being short / spilling against their contract position.
- Information Imbalance Cashflow - Since the information imbalance prices are
zero this value is always zero.
- Non Delivery Charge - Total charge for not delivering bid and offers in
the balancing mechanism.
- Residual Cashflow Reallocation Charge - Money redistributed from Energy
Imbalance Cashflows, A.K.A. "The Beerfund".
18th June, 2004
Fixed Bug in Page Hit Tracking
A bug in page hit tracking that caused a database connection pool runaway has been fixed.
16th June, 2004
Implemented Page Hit Tracking
The site now tracks page hits to allow a better understanding of the user experience.
15th June, 2004
Elexon Web Site Relaunch
The Elexon web site has been relaunched
and many of the links on this site to their site have "gone dead". When their site
settles down, the locations of the information linked to will be found out and the
links re-established. In the meantime, some links to Elexon will not work.
14th June, 2004
CDCA-I030 Display Commissioned
Code to display data from the imported CDCA-I030 files was commissioned.
XML-RPC 'utils' Package Commissioned
An XML-RPC package has been added that provides simple utility functionality.
XML-RPC Interface to CDCA Data Commissioned
An XML-RPC package has been added that allows access to CDCA data.
12th June, 2004
XML-RPC Interface Commissioned
The XML-RPC interface has been commissioned on the site. Using the XML-RPC
interface the user can integrate all the metering, settlement and balancing
mechanism data into their own applications with little pain. The user validation
code has been written to allow the user to fetch a user token which enables
access to restricted data.
11th June, 2004
CDCA-I029 Display Commissioned
Code to display data from the imported CDCA-I029 files was commissioned.
8th June, 2004
User Model Completed
User management has been incorporated and methods of switching off
certain areas of the site have been implemented. This is the prelude to
implementing all the pages to display data from the imported data files.
Users can now register,
log in,
and log out of the site to access more
content.
Data Page Structure Created
The data page structure has been completed.
To access the structure requires the user to be
registered and
logged in.
13th May, 2004
Elexon Server Connection Problems
Problems with access to the elexon data server have been solved.
1st May, 2004
Terms and Conditions Section Completed
The section of the site detailing the terms
and conditions of use of the NETA Reports web-service has been
completed.
30th April, 2004
CDCA-I0301 Import Commissioned
Code to import data from the CDCA-I0301 files was commissioned.
All file imports are now complete.
22nd April, 2004
SAA-I0142 Import Commissioned
Code to import data from the SAA-I0142 files was commissioned.
30th March, 2004
CDCA-I029 Import Commissioned
Code to import data from the CDCA-I029 files was commissioned.
16th March, 2004
CDCA-I042 Display Commissioned
Code to display data from the imported CDCA-I042 files was commissioned.
15th March, 2004
CDCA-I042 Import Commissioned
Code to import data from the CDCA-I042 files was commissioned.
6th March, 2004
File Copying Commissioned
Code to copy data from the Elexon P114 server is written and commissioned. Code to
categorise the data flows is written and commissioned.
5th March, 2004
Connection to Elexon P114 Server
The NETA Reports website is connected to the
Elexon P114 server. Code to scan for the presence
of new files on the server is written and commissioned.
26th February, 2004
NETA Reports Website Live
The NETA Reports website goes live.
P114 Licence Signed
EnAppSys Ltd signs P114 licence number 1.
24th February, 2004
P114 Go-Live Day
As part of the CVA
February 2004 release Modification Proposal P114 Entitlement of Licence Exemptable Generators
("LEGs") and other nontrading Parties to BSC Membership without Evidence of Trading was implemented.
This change to the rules governing the wholesale electricity market in England and Wales allows the
creation of licenced data providers who can manipulate and resell market data to other licenced data
users. EnAppSys Ltd will become a licenced data provider.
|