EDW Technology Logo
Phone us on:
+44 (0)8448 802 489

Profile Building & Forecasting

Profile building

ERS has the ability to build sets of profiles to support the creation of forecasts for non-half hourly metering. The Profile Builder framework is situated within the ERS core application. The NHH profiling tool creates Half Hourly Profiles using the Market Domain Data and Teleswitch Interval Data from the systems databases and enables users to apply Sunset Variables, Temperature Variables and Settlement Days.

The profile set consists of the PPC (Period Profile Coefficients) generated for every settlement period for every settlement day for a range of dates, for the Time Pattern Regimes for every Standard Settlement Configuration for combinations of GSP Group and Profile Class. A profile set is complete once these PPC have been calculated for every combination of GSP Group and Profile Class.

Profile building - Create profile screenshot

The Profile Builder Framework consists of the following interfaces and allows the user to easily navigate between them:

  • Maintain Profile Sets
  • Profile Set Activation History
  • Load Static Data
  • Load MDD
  • Load Time Pattern Switching Indicators
  • Reports (CSV export, graphs and clipboard options)'

Profiling - Mathematical Formula


In order to price new business a forecast of forward consumption needs to be made available to the pricing team. The ERS Quote Lab Generate Forecast user interface allows your users to import historical consumptions files for a series of MPANS and generate a forecast for each case.

Quote Lab will forecast consumption forward for each half-hourly period for a period of 6 years. This ensures that your pricing team can create several quote iterations for up to a 6-year contractual term without needing to create additional consumption forecasts.

A number of data validation routines are applied and exceptions are created, where appropriate, relating to the completeness and validity of the customer's historical consumption data, including:

  • valid MPAN combination (as per Market Domain Standard Settlement Configurations)
  • for HH meters all half-hourly consumption periods are present – at least 365 contiguous settlement dates
  • should not contain more than 4 contiguous settlement periods where the consumption value is 0
  • should not contain more than 10 periods of zero consumption
  • the maximum demand evidenced in the file should not exceed the Agreed Supply Capacity if this has been captured for the MPAN
  • the load factor for the consumption in the file is not less than [Business Rule] and not more than [Business Rule].

Forecasts are stored within the ERS application for use during the pricing process, forecast can be exported in CSV format.

Back to Overview Button


EDW House
Radian Court
Milton Keynes
Tel: +44 (0)8448 802 489
Email: info@edwtech.com

Contact Us