How to create electricity generation-unit dispatch charts, and spreadsheets for Queensland, NSW, Victoria, Tasmania, or South Australia |
First 51 of 51 paragraphs shown A 1 July 2009 upgrade to this web site now allows the much-requested one year data downloads by generation unit for all years from 1998 to the current 30 minutes, for any date-range. (In this example we show the market behaviour of gas plant in Tasmania as the new Tamar plant took over from Bell Bay 2). This example gives six months; but a 1 year is made the same way. We chose six months here because it gave more detail, of the transition. Or by the day: Or you just create data for one day, one week, one month, or one quarter. Its your choice. This guide gives the example of how to create electricity generation-unit dispatch charts, and spreadsheets. Your four data options: This guide shows how to use one of the four options below; Stations/DUIDS. A DUID is the Dispatch Unit Identitification Number 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: Dispatch by individual unit or power station. Also can compare or relate with other units in the same or different regions. 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 Do It Yourself data tools for Stations/DUIDS : STEP ONE - SUBSCRIBE: Try to logon. Test these sites for access. 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 They each have the erisk data service available and your company may already subscribe (see lower right column on HOME page in each) It you can't get in: Call your internal company Knowledge Manager or Librarian and advise you wish to subscribe); If you find you can get in with no password: Then - you have found that your firm has a subscription with IP access. That makes it password-free within your company, and you will neeed no password. STEP TWO - LOGON: Once you are able to logon (as a subscriber, see below) to any of these sites; follow the steps below: ___________________________________________________________________________ HOW-TO EXAMPLE: How to create electricity generation-unit dispatch charts, and spreadsheets for Tasmania. In this case, we view the activity of gas plants in Tasmania. To replicate the chart above, follow these steps: LOGON to a site above as a subscriber: GO TO Lower right of HOME PAGE Start at the Lower right of the HOME PAGE: click - NEM data Tools (it may ask you for your password again) click - Stations/DUIDS moving horizontally at first box leave it set at Dispatch Units/DUIDs; at second box chose Tasmaia; at third box select all gas generation types (Gas Turbine-Gas and Thermal-Gas) at fourth box chose all units Bell Bay, Bell Bay 3, Tamar Valley and TVCC at fifth box chose all units bbthree2, bbthree3, bellbay1, bellbay2 ,tvcc201, tvpp104 at "End Date" choose 2 Jul 2009; at "Period" use dropdown menu to choose six months; (1 year for a longer range) at "Output Format" use dropdown menu to chose Cumulative; at "End Time" use dropdown menu to choose Midnight (or 4 am - use your preference); Now wait, for the little whirly thing to finish - and presto - a graph which shows the transition to the Tamar plant. (if you later go to Dispatch data and create price charts for the same period you will find the change created large price impacts in Tasmania). To get a table of Tasman Gas Units dispatch for that six months: at "Output Format" use dropdown menu to choose Table; To get a csv for a spreadsheet for the period; 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 has 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" of price and demand data, cut paste and search over one year in the search box (lower right) with these words; "How to create a one year chart of 2008 - 2009 financial year electricity price for Queensland NSW, Victoria, Tasmania, or South Australia" (2009-07-02) *The data is a subscriber-service. At 1 July 2009, guest access was changed to a pay-by-use "token access". So, now, the very lowest-cost way to get electricity data and news is to subscribe for one year for corporate access. To do this, email accounts@erisk.net for a quote, or call 61 2 9818 8877 to talk. The subscriber rate for the service is $1412 a quarter. That gives access for all staff, across one company. It includes a flow of original news from primary sources, market notices and current data charts, optional pdf newsletters, daily weekly or twice weekly. (News-flow will differ for varous topic services, but the data service stays the same). "password-free" internal IP access is provided. The rate for additional companies in the group is $8.85 a week each additional company. ...Log in to read rest of Article or image. |