{% extends "base.html" %} {% block title %} » CSV CRC {% endblock %} {% block nav %} CSV CRC {% endblock %} {% block content %}

Download CRC CSV

For financial year starting April {{input_text('year', start_date.year, 4, 4)}}

The CRC report has a row for each supply. A supply is in one of the the following categories at any one time:

HH
Measurement classes C (Half Hourly Metered in 100kW premises) and E (Half Hourly Metered not 100kW).
AMR
Measurement class A (Non Half Hourly Metered) but HH non-settlement data used rather than settlement register reads.
NHH
Measurement class A (Non Half Hourly Metered) but with register reads only.
Unmetered
Measurement class B (Non Half Hourly Unmetered)

The report works out the number of days with actual data for each category and totals them up to give the 'Total Actual Days'. It then works out the maximum possible number of days with actual data for each supply category (HH, AMR, NHH or Unmetered) and totals them up to give the 'Total Max Actual Days'. If (actual / maximum) >= 183 / 365, the supply is classed as 'Actual' for the CRC period, otherwise it is classed as 'Estimated'. The total (estimated + actual) kWh are given for each category.

For a period of time (the span) when a supply is in the NHH category, the kWh and number of normal days are worked out as follows.

  • All reads that aren't 'actual' are discarded.
  • If there are < 2 reads, then the billed kWh is found, and two reads are added after the span that reflect the billed kWh rate.
  • The remaining reads are ordered by time. Working backwards in time from the start of the span, the first two reads are kept and earlier ones are discarded. Working forwards in time from the start of the span to the end of the span, the earliest and latest reads are kept and any others are discarded. Working forwards in time from the end of the span, the first two reads are kept, and the later ones are discarded.
  • With the reads still in order, all the segments are considered. A segment is just a read and the next read, so for n reads there are n - 1 segments. The kWh for each segment is calculated.
  • If the two reads of a segment lie within the span, the days of the segment are added to the actual days. The kWh of the segment is added to the total kWh.
  • If a read lies outside the span, no days are added to the actual days. The kWh for the segment is multiplied by (days of segment that are also in the period) / (total days in segment), and then added to the total kWh.
  • If there are parts of the span not covered by a segment, the gap is filled with a pro-rata of the segment before the gap, or if there is not segment before the gap, the segment after the gap.
  • If there's a meter change at some point along the line of reads, there will be two reads for the same point in time. One of the reads is the end of the preceding segment, and the other one is the beginning of the succeeding segment, so it's always the case that the two reads that make up a segment belong to the same meter.

For AMR and HH categories, the kWh figure is found by summing:

  • The sum of the kWh of all the half-hours that lie within the period.
  • The average kWh of present HHs over the period, multiplied by the number of missing half-hours.

The number of actual days is found by (number of actual half-hours / 48).

For unmetered supplies, the kWh for the span is: agreed_annual_kwh * (span / period). The agreed_annual_kwh is the annual consumption stated on the connection agreement with the DNO.

Download CRC Special Events CSV

For financial year starting April {{input_text('year', start_date.year, 4, 4)}}
{% endblock %}