OZ-ENERGY-ANALYSIS.ORG - open science for the new millennium
THE STORIES | DATA | ANALYSIS | MODELS | LITERATURE | DISCUSSIONS
status: [24th Jan 2012] Round Three (R3)
Electricity use (demand) data for the National Electricity Market (NEM) states, 1999 to 2011 inclusive.
The data presented here (and as discussed below) is the AEMO "price_demand" data, repackaged from 700+ csv files into a single demand flatfile, and alternatively as basic yearly CSV files.
The demand data covers the NEM (National Electricity Market - Australia), consisting of SA, QLD, NSW, VIC, TAS and a region SNOWY (now disbanded). Data for mainland states starts in Dec 1998; Tasmania starts in May 2005; the SNOWY region was disbanded into NSW and VIC from July 2008, and in any case the values involved are small compared with these states.
This is Round Three data (first presented here 19th January 2012); it includes data to end 2011. This data page is one of three closely connected pages: (this) demand data page, the Electricity Price Data page and the Price, Demand and Value - Electricity Market Analysis page.
There are at least two versions of demand data provided publicly by AEMO; that given here (dug out as indicated on the price data page), and that found in: http://www.nemweb.com.au/REPORTS/CURRENT/HistDemand/ and http://www.nemweb.com.au/REPORTS/ARCHIVE/HistDemand/ These two versions are not identical, but are highly similar. Unless and until some reason to revert to the above HistDemand data arises, we will now use the "price_demand" data.
Most data runs Jan 1999 - Dec 2011 inclusive. The 30 min data is the 'raw' data, with daily and weekly averages derivative from this. In constructing the daily average data we allowed up to three null ('NaN') data points (and the average that day is calculated from the remaining 47 or 46 or 45 data values); this suffices to patch all the missing data, of which there is very little in any case. The weekly averages are built as the average of all seven daily values; the weekly data drops the last day or two of each year in order to give a clean 52 weeks of data for each year. Units are MW average over the time interval.
Also, here are some basic CSV files containing the thirty minute data for the NEM states for each of the years: 2009, 2010, and 2011 (can provide other years in this format if requested).
First we look at an overall picture in terms of the weekly average use. No smoothing (beyond the averaging).
A wide browser window will give the plots in pairs.
In all cases the 'y-axis' range represents a doubling.
Some comments at the end.
It is interesting to note the seasonal patterns in the various states, and how these combine to give the overall NEM demand. The strong summer peaks in SA are thought to correspond to paticularly hot periods.
It is of particular interest to examine the high demand extremes. The following plots show the demand extremes in an overall view, year-by-year, for each of the NEM states (based on the 30 min data). The 100 point represents the 1% level; that is the demand level that is exceeded 1% of the time. Note also that individual plots link through to PDF versions that show an expanded view down to 0.01% (i.e. 10-2).
When these plots were first done (see comment 6 below), looking at the years up to and including 2009, growth in the demand extremes was almost stepwise (especially apparent for SA and VIC). With the addition of the 2010 and 2011 data, we see some moderation in the demand extremes. It would be great to understand what underlies this.
Here are the cut-off values (in MW) for the demand extremes, as in the plots above (for 2009, 2010 & 2011).
2011| level | SA | VIC | TAS | NSW | QLD |
| 10% | 1850 | 6840 | 1370 | 10390 | 6900 |
| 1% | 2390 | 7590 | 1560 | 12130 | 7770 |
| 0.1% | 3060 | 8670 | 1640 | 13970 | 8330 |
| 0.01% | 3360 | 9530 | 1690 | 14530 | 8820 |
| level | SA | VIC | TAS | NSW | QLD |
| 10% | 1960 | 7060 | 1390 | 10520 | 7030 |
| 1% | 2520 | 7970 | 1560 | 12050 | 8030 |
| 0.1% | 3010 | 9320 | 1650 | 13290 | 8740 |
| 0.01% | 3120 | 9840 | 1690 | 13470 | 8880 |
| level | SA | VIC | TAS | NSW | QLD |
| 10% | 1950 | 6970 | 1330 | 10680 | 7200 |
| 1% | 2790 | 8460 | 1510 | 12540 | 8180 |
| 0.1% | 3210 | 10110 | 1610 | 13450 | 8640 |
| 0.01% | 3320 | 10390 | 1660 | 14040 | 8760 |
It is seen that, for SA and VIC especially, the last 10% of the demand requires the system (generation and distribution) to be half as big again as that required for the other 90% of the time.
This is a data page, concerned mostly with presenting the raw data, having a place to discuss any data-centric issues, and including here straight data characterisation works.
There are other aspects of the demand data that can usefully be characterised, including the daily cycle; however, this is it for the 'head post' for now [Jan 2012]. Any further work and commentary can proceed in the open discussion below.
| 6 |
francis |




| 8 |
francis |
| 9 |
francis |
fc - Jan. 2012
Post Comment: