How to create a one year chart of 2008 - 2009 financial year electricity price for Queensland NSW, Victoria, Tasmania, or South Australia

First 39 of 39 paragraphs shown A 1 July 2009 upgrade to this web site now allows the much-requested one year data downloads. These download - in a flash - as charts, tables, or .csvs, (for spreadsheets), for all years from 1998. Or you just create data for one day, one week, one month, or one quarter. It's your choice. This guide gives the example How to create a one year chart of 2008 - 2009 financial year electricity price for Queensland. It use the Dispatch data feature, which is one of the four, below.

Your four data tools
1.Dispatch: This creates charts, spreadsheet csvs, or tables for regional price and demand, historic for ten years, current to last 30 minutes, in five minute periods)
2.Stations/DUIDS: Generator or station dispatch charts, spreadsheet csvs, or tableshistoric for ten years; available to previous midnight**.
3.STPASA: Short term supply and demand charts, spreadsheet csvs, or table forecasts by region
4.MTPASA: Medium term supply and demand charts, spreadsheet csvs, or table forecasts by region.
___________________________________________________________________________
How to use the Dispatch data feature in the Do It Yourself NEM data tools:
STEP ONE - SUBSCRIBE:( NB: you may be already enrolled if your company has subscribed, if not call your company Knowledge Manager or Librarian and advise you wish to subscribe);
STEP TWO - LOGON: Logon ( as a subscriber, see below) to any of these sites:
Gas Service: http://www.gas.erisk.net; or
Carbon Service: http://www.carbon.erisk.net; or
Electricity Service: http://www.electricity-week.com.au; or
Energy Daily: http://www.edaily.erisk.net
___________________________________________________________________________
HOW-TO EXAMPLE: one year chart of 2008 - 2009 financial year electricity price for Queensland
LOGON to a site above as a subscriber:
Start at the Lower right of the HOME PAGE: Click - NEM data Tools (it may ask you for your password again)
click - NEM data Tools (it may ask you for your password again)
click - Dispatch
at "Data Set" use dropdown menu (click small arrow-sign, and chose option) to choose QLD Price/Demand;;
at "End Date" choose 1 Jul 2009;
at "Period" use dropdown menu to choose 1 year;
at "Output Format" Leave it unchanged as Graph Comparison;
at "End Time" use dropdown menu to choose Midnight (or 4 am - use your preference);
at "Limit Price to" use dropdown menu to choose $10,000;
Now wait, for the little whirly thing to finish - and presto - a one year graph which will tell you below the average pool price for the year was $33.82/MWh.
To get a table of daily prices:
at "Output Format" use dropdown menu to choose Table;
To get a csv for a spreadsheet for the year;
at "Output Format" use dropdown menu to choose CSV; the .csv file will appear on your desktop of wherever you have set your brower to download-to. Open a new spreadsheet and drag and drop the .csv onto it
___________________________________________________________________________
A little history: EWN Publishing, first published Electricity Week in 1986. It published it each week, since then. In 1998 - with the start of the National Electricity Market (NEM) - EWN also produced internet-access data, from NEMMCO sources, and called it "erisk.net".
81 series of data for five regions update each 30 min: Those erisk.net data services now contain a ten year data history, and you can use them to create time saving spreadsheets, charts and data; and to analyse market conditions, histories and forecasts for the physical pool for Queensland, NSW, Victoria, Tasmania, and South Australia. You can also look at the behaviour of any unit on any day or period up to 2 years.
___________________________________________________________________________
**For a 'how-to" generation unit data, search over one year in the search box (lower right) with these words; "How to create generation unit dispatch charts, and spreadsheets for Queensland NSW, Victoria, Tasmania, or South Australia".

...Log in to read rest of Article or image.