National Grid
ICAP Load Profiles Following are downloadable Microsoft Excel files which contain the unitized annual hourly load profiles used for calculating ICAP.

The Excel files are structured as follows:
  • Columns—Represent Hour 1 through 24
    (e.g., Column A = Hour 1 or Hour ending at 1 a.m.)
  • Rows—Represent Day 1 through 365
    (e.g., Row 1 = Day 1 or January 1)
There are 8,760 values in each spreadsheet. These are unitized loads, whereby the sum of the calendar year equals 1 (or is very close to it). The values in each cell represent the fraction of yearly energy used for that hour of the year.

Service Classification for 2007 EDI Load Profile Code
SC-1, SC1B Standard Service (xls) 1SC1, 2SC1
SC-1C Optional Large Time of Use (xls) 1SC1C, 2SC1C
SC-2 Non-Demand (xls) 1SC2, 2SC2
Demand Secondary (xls) 1SC2D
Demand Primary (xls) 2SC2D, 3SC2D
SC-3 Secondary (xls) 1SC3
Primary (xls) 2SC3
Subtransmission (xls) 3SC3
Transmission (xls) 4SC3
Private Area Lighting Private Area Lighting (xls) 1SC1L (xls)
Traffic Signals Traffic Signals (xls) 1SC4L
Street Lighting Street Lighting (xls) 1SC2L, 1SC3L, 1SC5L, 1SC6L