Home

eAuctionyzer_Manual_1.1

Contents

1. Bid scenario Scenario characteristic Bid informations Name Bid Scenario 1 Bids quick view Path informations Tag Add i Bid count on a path Dedicated tace DE_AT PSEO ELES MAVIR CZ SK 9 DE AT 0 0 136 133 a IERI zx Sunny PSEO 0 0 0 0 Windy ELES 3 0 0 0 0 MAVIR 2 0 0 ol 0 CZ SK 14 2 2 65 gt Sum of requested volume per path DE_AT PSEO ELES MAVIR CZ SK DE AT 0 1255 1151 165 4 PSEO 0 0 0 ol 0 Delete ELES 65 0 0 0 0 MAVIR 25 0 o 0 o Date Mar 2 2011 5 Add CZ SK 125 10 40 554 Ole Dedicated dates Average price on a path PETI Y DE AT PSEO ELES MAVIR CZ SK 2011 03 02 DE AT 0 00 0 00 5 85 8 70 1 78 PSEO 0 00 0 00 0 00 0 00 0 00 ELES 1 05 000 0 00 000 0 00 MAVIR 1 12 0 00 0 00 0 00 0 00 CZ SK 4 58 4 75 5 54 5 03 0 00 v Show Generate Import Delete Auctions used Auctions bid scenario is used Owen bid scenario Back Delete Save Duplicate 03 3 2 3 Show the Bids All bids can be shown in a table by pressing Show at the bid scenario editing screen Figure 18 The Bid list view will be displayed Figure 19 For each bid product source sink requested volume and price is shown The bids are sort
2. co 2011 2 11 H01 OA 2011 2 11 H02 2011 2 11 H03 ME pE AEsPS PSEGDE ELEG DE ELESSPREMAVIRSDE IMAVIRSPS MAVIRSSEL 2011 2 11 H04 Day 2041 27 11 122 0 201112111 HOS Day2011 2 11 H02 270 0 394 0 561 0 361 0 105 0 143 0 122 0 DING E Day 2011 2 11 H03 270 0 397 0 561 0 361 0 105 0 143 0 122 0 Day 2011 2 11 H04 270 0 391 0 561 0 361 0 105 0 143 0 122 0 2011 2 11 H07 Day 20117 2 11 H05 270 0 391 0 561 0 361 0 105 0 143 0 122 0 2011 2 11 H08 Day 2011 2 11 H06 270 0 391 0 561 0 361 0 105 0 143 0 122 0 2011 2 11 H09 Day2011 2 11 HO0 270 0 391 0 561 0 361 0 105 0 143 0 122 0 2011 2 11 H10 Day 2041 27 11 H08 270 0 391 0 561 0 361 0 105 0 143 0 122 0 2011 2 11 H11 Day 2011727 11 H09 75 0 415 0 L 338 0 92 0 216 0 111 0 600 0 2011 2111 H12 Day 2041 2 11 H10 75 0 415 0 338 0 92 0 216 0 111 0 600 0 2011 2111 H13 Day 201942419 Ht1 75 0 415 0 338 0 92 0 216 0 1110 600 0 Day 2011 27 11 H12 75 0 415 0 338 0 92 0 216 0 1110 600 0 2011 2 11 H14 Day 2011 24 11 H13 75 0 415 0 338 0 92 0 2160 1110 600 0 2011 2 11 H15 Day 2011 2 11 H14 75 0 4150 338 0 92 0 216 0 1110 600 0 2011 2 11 H16 Day 2044 2711 15 75 0 415 0 338 0 92 0 216 0 1150 600 0 2011 2 11 H17 Day 2011 2 11 H16 75 0 415 0 338 0 92 0 216 0 111 0 600 0 2011 2 11 H18 Day 2041 27 14 H17 47 0 113 0 1725 0 66 0 658 0 83 0 752 0 2041 2 11 H19 Day 2011
3. W X SZ iN Aa N No N AS X SN Fu S AN The filename of the imported PTDF defines the auction type and the date a PTDF is designed for Depending on the auction type the filename has to contain the following signs e _Y lt YYYY gt _ fora yearly auction e M lt YYYYMM gt _ for a monthly auction and _ lt YYYYMMDD gt _ lt HHMM gt _2D lt DayNumber 1 7 gt _ for a daily hourly auction Page 12 of 46 eAuctionyzer Manual As example the published PTDF from CEE CAO for the first hour of the first of April 2010 is called Public 20100401 0000 2D4 CEEO csv The file itself includes a header line and the technical parameter lines The header must be Critical Branch Case Source Sink TMF AMF AMF Factors SOURCE SINK Figure 6 shows a part of a PTDF matrix Figure 6 PTDF matrix Critical Branch Case Source Sink TMF AMF AMF MAVIR gt PSEO MAVIR gt ELES PSEO gt MAVIR PSEO gt ELES ELES gt MAVIR ELES gt PSEO LINE 00001 n 0 APG ELES 360 1 276 2 404 1 0 0159 0 1048 0 0159 0 1207 0 1048 0 1207 LINE 00001 n 1LINE APG ELES 360 1 280 4 399 9 0 0173 0 1155 0 0173 0 1328 0 1155 0 1328 LINE 00003 n 0 CEPS CEPS 1369 629 9 1486 0 0446 0 0028 0 0446 0 0418 0 0028 0 0418 LINE 00003 n 1LINE CEPS CEPS 1369 288 6 1693 0 0671 0 0159 0 0671 0 0512 0 0159 0 0512 LINE 00003 n 1LINE CEPS CEPS 1369 620 1 1493 0 0481 0 0032 0 0481 0 0449 0 0032 0 0449 LINE 00003
4. eAuctionyzer Manual Views Bid graph view v BID LIST PRODUCT SCENARIO SOURCE SINK REQUES ACCEPTE PRICE MCP PAYMENT H01 DE AT MAVIR 10 10 19 50 13 51 135 10 4 H01 1 DE_AT MAVIR 10 101 17 39 13 51 136 10 H01 q 1 DE_AT MAVIR 10 10 15 64 13 51 135 10 H01 1 DE AT MAVIR 5 5 15 40 13 51 67 55 H01 1 DE AT MAVIR 10 10 1528 13 51 13510 Sum Save as chart by amCharts com Result for bids on path Bid FI accented 20 Not Accepted e 5 uu E eo g amp Capacity in MW 575 862 1149 The path view Figure 36 displays an overview of the result for each path source sink pair in a matrix Three elements can be displayed the requested volume the accepted volume and the market clearing price The element can be selected over the drop down menu In case of multiple product selection the market clearing price cannot be calculated and shown because there are different MCPs for different products on the same path In the upper section the results are shown as table and in the lower section as graph Figure 36 Result view for the paths 03 5 2 4 Results Selections Scenarios N Own 001 a v Aggregate Scenar ios Products Code Hours H01 1 v Aggregate Products Source Sink Code Code DE AT IDE AT Ss ELES ELES MAVIR CZ SK C
5. Delete PTDF Show PTDF Day 2011 2 11 HO7 Day 2011 2 11 H08 Day 2011 2 11 H09 zd Day AONTA E ts DD chart by amCharts com Day 2011 2 11 H11 Day 2011 2 11 H12 Day 2011 2 11 H13 2500 Day 2011 2 11 H14 Day 2011 2 11 H15 Day 2011 2 11 H16 2000 Day 2011 2 11 H17 Max Capacities on border Source M cz x B uw Day 2011 2 11 H18 E 500 BD ces Day 2011 2 11 H19 E B esto Day 2011 2 11 H20 2 Day 2011 2 11 H21 81000 Bos Day 2011 2 11 H22 S Day 2011 2 11 H23 Day 2011 2 11 H24 en e DE_AT PSEO ELES MAWIR CZ SK Sink By clicking Show PTDF Figure 7 the full information for the PTDF can be shown Figure 8 This view includes the calculation of the maximum none simultaneously available capacities if capacities are allocated on different paths Therefore at Assumed simultaneously fixed capacities the assumed allocated capacities can be defined The impact on the assumed allocated capacities on the still none simultaneously available capacities is shown in the matrix Free non concurrent transmission capacity If a value in this matrix is shown in red the input of the allocated capacities is invalidate Figure 8 PTDF view PTDF detail view Auction type Daily auction Max capacity matrix for PTDF FromiTo DE AT ELES CONEA PSEO Sum export DE AT 319 0 1910 2400 270 0 1020 0 ELES 561 0 4800 7710 367 0 2173 0 CZ SK 618 0 985 0
6. Date and Own but not to changes at the bid structure The bid structure will not be editable if a bid scenario is used in an auction scenario 03 3 4 Duplicate a Bid Scenario As mentioned at saving and deleting bid scenarios a bid structure is only editable if the bid scenario is not used in any auction scenario The button Duplicate copies the whole bid scenario including the bids and saves it under new ID The original scenario will not be touched and the new scenario will be editable in all ways because it is not used in any auction scenario 03 3 5 Search and Select a Bid Scenario To search for a bid scenario go to navigation bar Bid and List The Bid scenario selection view Figure 20 is displayed 3 3 5 1 Set up the Search Filter First a filter for the bid scenarios can be defined On the left side under Search for a bid scenario at Figure 20 A filter includes the name tags dates and products A scenario is only shown in Matching scenarios if it includes these phrases defined by the filter It can also be declared if a scenario has to match all of the tags or only one to be shown in the list Additionally only the own or the market scenarios can be shown At Matching scenarios the scenarios are ordered by an internal number ID depending on the order of construction 3 3 5 2 Select a Bid Scenario A bid scenario is selected by a click on it in the Matching scenarios list After this the bid scenario
7. eAuctionyzer Manual To start the eAuctionyzer go to the installation directory see 02 2 and run the file eAuctionyzer jar The program starts loads the general data and shows the Startup screen To get to the requested program functionality use the navigation bar see 01 3 1 At the first startup please register apply for a license see 02 5 and set the GAMS path see 02 4 3 05 2 PIDF PTDFs Power Transfer Distribution Factors are used for the auction and stored in matrices The PTDFs are published by the CAO on their webpage 03 2 1 PTDF Import To import a PTDF matrix the Import PTDF from local system screen has to be called Figure 5 Therefore press in the navigation PTDF and then Import on the left Tt is possible to import one PTDF as csv file or multiple PTDFs via one zip file By clicking Search the file system opens and a csv or zip file can be selected Via Import the file s will be imported into the system Figure 5 PTDF import screen after pressing search Import PTDF from local system Filename i Xx Look In Eigene Dateien M ca a es 7 Bluetooth CH jardir y Public 2 Cc Downloads c old y TraderT Eigene Bilder PTDFs Cd Eigene Musik Cd TraderToolinstallCDZip c Visual Studio 2008 3 PTDFs zip 03 2 2 PTDF Filename and Layout te DT lt c RR W WSI NAA Za
8. ES 50 INF MAVIR INF INF _ CZ SK 20 INF v 03 4 1 4 Run the Auction If at minimum one PTDF and one bid scenario is selected the auction scenario can be calculated by pressing the button Run Auction at Auction Functions This will start the internal process of the model generation and after the model is fully generated it will be calculated by an external program called GAMS see 02 4 During the calculation next to the button Run Auction the text working will be shown Figure 28 An exact forecast of the calculation time is not possible because it is non linear dependent on the given bids per product the size of the PTDFs and other constraints It can be seconds for a short model up a few minutes in case that many data have to be handled For a more detailed view on the calculation times a short study was done and can be seen in Appendix B CALCULATION TIMES Figure 28 Auction scenario screen while calculation Auction functionality Run Auction working 0 475 03 4 1 5 Show the Results After the calculation the button Show Result is available Figure 29 By a click on it the results will be shown See 03 5 Figure 29 Auction scenario screen after calculation Auction functionality Run Auction finished Show Result 03 4 1 6 Save the Auction Scenario In the lower section of the Auction Functions Figure 24 the save section is displayed By pressing Save or
9. Enhanced Capacity Auction Management Tool GAMS General Algebraic Modeling System MCP Market Clearing Price PTDF Power Transfer Distribution Factor TMF Total Maximum Flow eAuctionyzer Manual Page 46 of 46
10. list It is possible to add multiple scenarios from different dates to the Selected scenarios list By selecting a bid scenario in the Selected scenarios list and pressing Delete the bid scenario will be removed from this auction scenario Figure 26 Bid scenario selection panel Select Bid Bid scenarios Selected scenarios February v comb 1D Name own i Em _ sc001 wi j Sun Mon Tue YY Thu Fri Sat Available scenarios D Name B Own 36 neu LE a z add Delete 03 4 1 3 Define Import and Export Limits There is also the possibility to use limits for single market areas An import limit defines the maximum capacity that can be imported to a market area an export limit the maximum capacity that can be exported At an auction it can be defined if limits should be used or not By marking Use Limits the defined limits in the table below will be used In the table for each market area an import and an export limit can be defined The maximum possible limit for one area is 100 000 MW no limit is defined by a negative value and shown as INF infinite Figure 27 shows the limit definition screen of the auction scenario Page 26 of 46 eAuctionyzer Manual Figure 27 Import Export limit selection panel Select Limits Import Export Limits _ Use Limits Area Maximpor MaxExport DEAT INF INF PSEO 30 INF
11. n 1LINE CEPS CEPS 1369 570 3 1523 0 0485 0 0042 0 0485 0 0444 0 0042 0 0444 LINE 00003 n 1LINE CEPS CEPS 1369 620 5 1493 0 0504 0 0029 0 0504 0 0475 0 0029 0 0475 LINE 00003 n 1LINE_CEPS CEPS 1369 6015 7 1494 0 0423 0 0012 0 0423 0 0435 0 0012 0 0435 LINE 00009 n 0 CEPS CEPS 1368 5 778 2 1337 0 0446 0 0028 0 0446 0 0418 0 0028 0 0418 LINE 00009 n 1LINE CEPS CEPS 1368 5 718 8 1374 0 0485 0 0042 0 0485 0 0444 0 0042 0 0444 LINE 00007 n 0 PSEO CEPS 1392 6 927 1 1409 0 2004 0 0059 0 2004 0 1944 0 0059 0 1944 LINE 00007 n 1LINE PSEO CEPS 1392 6 751 8 1521 0 2609 0 0131 0 2609 0 2478 0 0131 0 2478 LINE 00004 n 0 CEPS CEPS 1222 5 299 9 1557 0 0516 0 0301 0 0516 0 0215 0 0301 0 0215 LINE 00004 n 1LINE CEPS CEPS 12225 30 6 1671 0 0704 0 0313 0 0704 0 0392 0 0313 0 0392 LINE 00004 n 1LINE CEPS CEPS 1222 5 276 3 1571 0 059 0 031 0 059 0 0281 0 031 0 0281 LINE 00004 n 1LINE CEPS CEPS 1222 5 250 3 1613 0 0507 0 031 0 0507 0 0198 0 031 0 0198 LINE 00004 n 1LINE CEPS CEPS 1222 5 453 9 1466 0 0418 0 0265 0 0418 0 0152 0 0265 0 0152 LINE 00004 n 1LINE CEPS CEPS 12225 92 9 1609 0 0704 0 0313 0 0704 0 0392 0 0313 0 0392 LINE 00004 n 1LINE CEPS CEPS 1222 5 276 8 1572 0 0651 0 0305 0 0651 0 0346 0 0305 0 0346 03 2 3 Overview on the imported PTDF s The imported PTDFs can be shown at PTDF list view via PTDF and List The PTDFs are split up into different auction types Depending on the pressed button Day Month or
12. 1 ELES PSEO 0 0 0 00 H01 1 PSEO MAVIR 0 0 7 53 H01 1 PSEO CZ SK u u 11 14 H01 1 PSEO DE AT u 0 0 00 H01 1 PSEO ELES 0 0 4 25 Sum 05 5 2 7 Product View The product view Figure 40 displays the results for different products and one path source sink combination In the upper section for each product the requested volume the accepted volume and the market clearing price is shown in a table and in the lower section the result is shown as graph Page 33 of 46 eAuctionyzer Manual Figure 40 Result view for the products Results Selections Views Scenarios Product view w ID Name wn 11 st for runntim aj PRODUCT RESULTS R Bid Scenario Result for the selected products y Aggregate Scenarios Product Requested Accepted MCP H01 200 0 18 83 4 Products H03 200 0 19 55 Sade HS H05 200 126 10 13 H01 1 a H14 200 0 20 41 po po T pos 0 0 1 Sum ij EMEN m EX chart by amCharts com Result for path DE ATto CZ SK 250 Value a Accepted Bl not accepted E D mo E e o Q 2 Q ly C Aggregate Products Source Sink Hos Code Code IDE AT Product PSEO PSEO ELES ELES zi MAVIR MAVIR CZ SK lt CZK Aggregate Aggregate 03 5 2 8 Sum the Result Elements In the result table a section can be selected by marking it For the selected region the sums of the single
13. 185 0 18 86 Sum chart by amCharts com Result for source DE AT 1 400 1 200 1 000 Capacity in MW co 8 m e o a e e ty e e v Aggregate Products Source Sink Code Code DE AT PSEO ELES MAYIR CZ SK lt DECAT Ed PSEO PSEO ELES ELES Sink MAVIR MAVIR CZ SK CZ SK v Aggregate Aggregate 03 5 2 5 Sink View gl Value a Accepted Bl not accepted E w a The sink view Figure 38 displays the result for all sources to one sink The sink can be selected over the drop down menu The elements in the drop down list depend on the selected sink areas For each source sink combination the requested volume the accepted volume and the market clearing price is shown At the lower area of the view the results are shown as graph Figure 38 Result view for all sources and one sink Results Selections Views Scenarios Sink view PTDF ID Name Own 1 sc001 a RESULTS for a selected sink Select Sink ELES i y Bid Scenario i y Aggregate Scenarios Result Table Products Source Requested Volume Accepted Volume MCP DE AT 1265 30 15 70 4 Code Hours PSEO ol 0 9 69 H01 1 ELES 0 0 NaN MAVIR 0 0 5 52 CZ SK 40 20 5 52 w Sum Save as m chart by amCharts com Result for sink E
14. 2 11 Ht8 47 0 113 0 17250 66 0 658 0 83 0 752 0 2011 2 11 H20 Day 2011 2 11 Ht9_ 47 0 113 0 1725 0 66 0 658 0 83 0 752 0 201412111 H24 Day2011 2 11 H20 47 0 113 0 1725 0 66 0 658 0 83 0 752 0 Day 2011 24 11 H21 47 0 113 0 1725 0 66 0 658 0 83 0 752 0 2011 2 11 H22 Day 2011 27 11 H22 47 0 113 0 1725 0 66 0 658 0 83 0 752 0 2011 2 11 H23 Day 2011 27 11 H23 47 0 113 0 1725 0 66 0 658 0 83 0 752 0 2011 2 11 H24 Day 2011 2 11 H24 47 0 113 0 1725 0 66 0 658 0 83 0 752 0 Page 16 of 46 eAuctionyzer Manual Figure 13 PTDF graph view for selected borders z List Search Single View 1to 1 1toall Alito 1 All to all Day Wem ve February lv 2011 E One source to one sink View for the selected PTDF s un ue le u ri Ir Source Borders n Code B Source A DE AT DE AT Bid Scenario PSEO IDE AT ELES ELES PSEO IDE AT MAVIR PSEO ELE From 90 00 To 24 00 ote 24 CZ SK ELES IDE AT Day 2011 2 11 H01 Day 2011 2 11 H02 switch Maximum 6 borders are shown Day 2011 2 11 H03 El Day 2011 2 11 H04 chart by amCharts com Day 2011 2 11 H05 Day 2011 2 11 H06 em Day 2011 2 11 H07 Max Capacities on border Day 2011 2 11 H08 ii Borders Day 2011 2 11 H09 Day 2011 2 11 H10 Wy DE at psEO Day 2011 2 11 H11 1 600 PSEO DE AT
15. 2187 0 376 0 4165 0 MAVIR 105 0 122 0 126 0 143 0 496 0 Ir PSEO zm 780 0 297 0 434 0 1902 0 M Sum import area mealies ters 1150 0 9757 0 Bid Scenario Year Month Day Time 2010 4 1 H04 Calulate capacities Assumed simultaneously fixed capacities Free non concurrent transmission capacity From To DE AT ELES ez 8K MAVIR PSEO Sum export FromiTo DE AT ELES CZ SK MAVIR PSEO Sum export B DE_AT 0 0 0 0 D DE AT 319 0 1910 240 0 ELES 0 0 0 0 0 ELES 561 0 480 0 771 0 co CZ SK ol 2 0 0 0 CZ SK 618 0 985 0 2187 0 Auction MAVIR o 0 0 o 0 MAVIR 105 0 1220 126 0 PSEO 0 0 0 0 0 PSEO 391 0 7800 2970 4340 Sum Import 0 0 0 Sum import 1675 0 2206 0 1094 0 3632 0 1150 0 Reset mil Data Setting 03 2 4 PTDF Comparison Another feature of the PTDF analysis is the comparison of different PTDFs especially their capacities Four different views are available one source to one sink 1 to 1 single path one source to all sinks 1 to all export capacities all sources to one sink all to 1 import capacities all sources to all sinks all to all selected paths These views illustrate the changes at the PTDFs over the course of time Page 14 of 46 eAuctionyzer Manual 03 2 4 1 1 to 1 View The one to one view shows the changes of the capacities on the selected path By selecting a market
16. 50 H01 1 DE AT MAVIR 10 10 17 39 H01 1 DE AT MAVIR 10 10 15 64 H01 1 DEAT MAVIR 5 5 15 40 H01 1 DE AT MAVIR 10 10 1526 H01 1 DE AT MAVIR 5 5 14 88 H01 1 DE AT MAVIR 15 15 14 76 H01 1 DE AT MAVIR 20 20 1451 H01 1 DE AT MAVIR 25 25 1426 H01 1 DE AT MAVIR 5 5 1414 H01 1 DE AT MAVIR 5 5 1410 H01 1 DE AT MAVIR 30 30 1401 H01 1 DEAT MAVIR 35 25 1376 1376 344 00 H01 1 DE AT MAVIR 5 0 13 52 13 76 0 00 H01 1 DE AT MAVIR 10 0 13 52 13 76 0 00 H01 1 DEAT MAVIR 40 0 13 51 13 76 0 00 H01 1 DE AT MAVIR 10 0 1329 13 76 0 00 H01 1 DE AT MAVIR 5 0 13 10 13 76 0 00 H01 1 DE AT MAVIR 10 0 13 01 13 76 0 00 me Sum C Only awarded bids 03 5 2 2 Bid Graph View The bid graph view shows the bids for one source sink combination as graph The accepted bids are shown in green the not accepted bids in red Figure 35 shows the bid graph view for the border from DE AT to PSEO Page 30 of 46 Figure 35 Result graph view for the bids i a Beck 03 5 2 3 Results Selections Scenarios ID Name Own 1 sc001 O Aggregate Scenarios Products Code Hours H01 1 Ex Aggregate Products Source Sink Code Code DE AT IDE AT PSEO PSEO ELES ELES MAVIR MAVIR CZ SK CZ SK Aggregate Aggregate Path View
17. Day 2011 2 11 H12 Day 2011 2 11 H13 1 400 ELES DE AT Day 2011 2 11 H14 ELES PSEO Day 2011 2 11 H15 4 200 Day 2011 2 11 H16 E MAVIR DE AT Day 2011 2 11 H17 000 Day 2011 2 11 H18 2 Day 2011 2 11 H19 3 Day 2011 2 11 H20 S Day 2011 2 11 H21 Day 2011 2 11 H22 Day 2011 2 11 H23 Day 2011 2 11 H24 Day 2011 42411 H01 Day 2011 2 11 HO Day 2011 2 11 H13 Day 2011 2 11 H19 PTDF 03 2 5 PTDF Search If it is not known for which dates or auction types PTDFs really exist there is also the possibility to search for them There can be switch between list and search at the upper section of the list side of the PTDF List View By clicking Search the search functionality will be opened Afterwards two dates can be selected All PTDFs that lie between these two dates are shown in the Available PTDFs List There is also the possibility to show only the yearly monthly or daily PTDFs In the middle section the Available PTDFs List is shown There you can see all PTDFs that match the given search criteria s By selecting the PTDFs and pressing Add they will bid added to the Selected PTDFs List in the lower section of the view All selected PTDFs will be shown in the PTDF Comparison Views see 03 2 4 This gives the user not only the possibility of searching for the PTDFs but also of comparing PTDFs of different days and auction types Figure 14
18. ELES CZ Sk MAVIR PSEO DE AT 20 amp 0 ELES 0 0 sol i CZ_SK 0 0 0 0 MAVIR oo oo 4o PSEO oo oo 220 Update C Auto update PSEO o 0 297 0 Sum Import Dj 319 1094 1011 Back Submit Page 24 of 46 eAuctionyzer Manual 03 3 6 4 Submit or Drop the Bids The generated bids will be submitted by pressing the button Submit Afterwards the view changes to the Bid scenario edit view If only Back will be pressed the generated bids will be rejected while going back to the Bid scenario edit view In any case the changes will be finally submitted by saving the bid scenario by pressing Save at the Bid Scenario Edit View Figure 18 see 03 3 3 03 4 Auction Auction Scenarios There are two different auction types First a full day auction that auction s a full day and as second a single PTDF auction that will auction only one single PTDF Figure 23 Minimized auction flow screen 03 4 1 Set Up an Auction Scenario A new auction scenario can be generated by going to Auction and then to New in the navigation bar The Auction scenario screen will be opened First the auction flow type has to be indicated either full day auction or single ptdf auction Figure 24 Afterwards the PTDF s and bid scenarios have to be selected as well as import and export limits can be defined Figure 24 Auction functionality
19. Requirements 02 1 1 Program Requirements 02 1 2 Operating System 02 1 3 Free Harddiskspace 02 2 Installation of eAuctionyzer on Windows Computers 02 3 Update of eAuctionyzer 02 4 Installation of GAMS 02 4 1 02 4 2 02 4 3 02 5 02 5 1 02 5 2 02 5 3 03 1 03 2 03 2 1 03 2 2 03 2 3 03 2 4 03 2 5 03 3 03 3 1 03 3 2 03 3 3 03 3 4 03 3 5 03 3 6 03 4 03 4 1 03 4 2 03 5 Installation GAMS License Integration of GAMS License of the Software Shipping License Request a License Extend the License APPLICATION DESCRIPTION Program Startup PTDF PIDF Import PTDF Filename and Layout Overview on the imported PTDF s PTDF Comparison PTDF Search Bid Scenarios Bid Scenario Layout Generate a New Bid Scenario Save and Delete Bid Scenarios Duplicate a Bid Scenario Search and Select a Bid Scenario Bid Generator Auction Auction Scenarios Set Up an Auction Scenario Open a Saved Auction Scenario Results eAuctionyzer Manual O O O WO oo 00 00 O CO N NNN N NN NN PR KP PR KP HE PE EE PE EH EH PMP EH EH EH EH EH HE PE EE BH O U U1 UU NJ N NY WO 0 WON R W N NN NN KF FP FP KF O O O O Page 4 of 46 eAuctionyzer Manual 03 5 1 Element Selections 29 03 5 2 Select the View 29 03 6 Sensitivity Analysis 34 03 6 1 Setup of Sensitivity Analysis 35 03 6 2 Run of Sensitivity Analysis 35 03 6 3 Open a Calculated Sensitivity Analysis 35 03 6 4 Delete a Sensitivity Analysis a Sensitivity Analy
20. These are the name tags and dates The flag for own bid scenario can be set too Tags can be inserted by writing them next to Tag and afterwards press Add or the RETURN key Multiple elements can be inserted with as separator For deleting the element it has to be selected at Dedicated and then pressed Delete Dates are added by opening the calendar selecting a date and pressing Add next to the field 03 3 2 2 Add Bids to a Scenario After defining the characteristic information bids can be added to the scenario You may add single bids described at 03 3 2 4 generate bids with the bid generator see 03 3 6 or import whole strategies from csv files To import a whole strategy the button Import has to be pressed The file system opens and a csv file can be selected Figure 16 Page 19 of 46 eAuctionyzer Manual Figure 16 Import bids to a scenario by pressing Import Bid scenario Scenario characteristic Bid informations Name Bid Scenario 1 Bids quick view Path informations Product Bidcount Bid count on a path Tag Add Dedicated tags Windy Sumy Look In Eigene Dateien M a 8 a 9 BIDS_157 csv BH 9 BIDS 2010 06 10 csv O 3 Kopie von Public_20090810_0000_2D7_PDTF1 csv D LFB DAILY 01 01 2011 published bids csv D my new graph original csv gt Delete Fy Publ
21. Year only the PTDFs for this auction type are shown At Day a date has to be selected by the calendar and afterwards it is possible to define a more specific time span Only the PTDFs for this day that lie between the start and the end time are displayed For monthly and yearly PTDFs only a period of time has to be defined A PTDF can be selected by clicking on it in the list Primary the quick information for the PTDF is shown Figure 7 illustrates the selection model for daily auctions the list with the matching PTDFs and the quick information for the selected PTDF 2011 2 11 HO7 Page 13 of 46 Figure 7 PTDF list view ow Wem vem February v m 2011 4 Single View 1to 1 1to all All to 1 All to all PTDF quick information eAuctionyzer Manual Sun Mon Tue Wed Thu Fri Sat Auction type Daily auction Year Month Day Time 2011 2 11 HOF Max capacity matrix for PTDF From To DE AT PSEO ELES MAVIR CZ SK Sum export DE AT 270 0 319 0 2400 1910 1020 0 PSEO 391 0 7800 4340 2970 1902 0 ELES 567 0 367 0 771 0 480 0 MAVIR 1050 1430 1220 126 0 Day 2011 2 11 H01 CZ SK 618 0 id 985 0 2187 0 Day 2011 2 11 H02 Sum import 1675 0 1150 0 2206 0 3632 0 1084 0 Day 2011 2 11 H03 Save view as Day 2011 2 11 H04 Day 2011 2 11 H05 Day 2011 2 11 H06 PTDF functionality
22. are available by pressing Show Result at the Auction scenario view Figure 24 Different views and selections are available for an auction at the result section Figure 32 Page 28 of 46 eAuctionyzer Manual Figure 32 Result view Results Selections Views Scenarios Pamvew J Name sc001 1 PATH RESULTS Select element to show Requested Volume Z Aggregate Scenarios Result for the selected element Products Aggregate Products Source Sink Ol aggregate C Aggregate 03 5 1 Element Selections It is possible to select the elements which should be presented in the single tables Figure 33 It differs in bid scenarios products areas as source market areas and areas as sink market areas By selecting the desired elements in the tables the results for these elements will be shown In case of multi selection some elements must be aggregated to receive a significant result Figure 33 Selection region at result view Selections Scenarios Aggregate Scenarios Products Aggregate Products Source aggregate aggregate 03 5 2 Select the View Seven views are available bid table bid graph path source sink full and product view The single view can be selected by selecting it in the combo box on the upper side of the view Page 29 of 46 03 5 2 1 Bid Table View eAuctionyzer Manual The bid view Fig
23. area as source area and one as sink area the capacities for the selected PTDFs are shown in a table Figure 9 shows the view for PSEO as source DE AT as sink and the selected PTDF matrices Figure 9 PTDF one source to one sink view Single View 1to 1 1to all Allto 1 All to all One source to one sink View for the selected PTDF s Source PSEO w Sink DE AT Bid Scenario Time Capacity Day 2011 24 11 H01 3910 B From ao 00 To 24 00 oto24 Day 2011427 11 H02 391 0 gt Day 2011 2 11 H01 Day 2011 24 11 H03 331 0 Day 20114 24 11 H04 391 0 Auction INL PEEL NE ET 391 0 Day 2011 2711 H03 Day 2011 24 11 HOG 391 0 Day 2011 2 11 H04 Day 2011 24 11 HOF 391 0 Day 2011 2 11 H05 Day 20117 27 14 H08 391 0 Day 2011 2 11 H06 Day 2011 24 11 H09 415 0 Day 2011 2 11 H07 Day 2011 27 11 H10 415 0 Data Day 2011 2 11 H08 Day 2011 27 11 H1 415 0 Day 2011 2 11 H09 Day 2011 24 11 H12 415 0 Day 2011 2 11 H10 Day 2011 24 11 H13 415 0 j Day 2011 27 11 H14 415 0 Day 2011 2 11 H11 Day 2011 27 11 H15 415 0 Day 2011 2 11 H12 Day 2011 27 11 H16 415 0 Day 2011 2 11 H13 Day 2011 2 11 H17 113 0 Day 2011 2 11 H14 Day 2011 2 11 418 113 0 Day 2011 2 11 H15 Day 2011 27 11 H19 113 0 Day 2011 2 11 H16 Day 2011 24 11 420 113 0 Day 2011 2 11 H17 Day 2011 24 11 H21 113 0 D
24. columns or elements are calculated and shown under the table in the fields labeled by Sum Figure 41 shows a schematic illustration Figure 41 Summing at result view ECET HU 1 DEAT ELS 10 10 1170 1037 10370 Ho 1 DEAT HES S8 5 H8 1037 5188 H0 1 DEAT ELES 5 5 1150 10 37 5185 H0 1 DEAT ELES 10 10 1128 1037 10370 Ho 1 DEAT ELES 8 X 8 1108 1037 8296 LH _ DEAT LER S mos tos stas HO 1 DEAT ELES 7 7 1078 1037 7259 HM 1 DEAT EES 2 2 1077 1037 2074 Ho 1 T 8 8 i088 RATE EE Sum 87 87 902 19 03 6 Sensitivity Analysis One of the major features of the software is the execution of sensitivity analysis The sensitivity analysis shows the changes of the results by different additional allocated amounts of capacity at one path The sensitivity analysis is part of an auction scenario Figure 23 and illustrated in Figure 42 Figure 42 Sensitivity analysis panel of an auction scenario Sensitivity Analysis Sensitivity analysis scenario setup Calculated sensititivity analysis Select source DE AT v EEE R WNE analysis list Select sink E pa from D in 50 to 200 MV Start volume 50 H 2 H03 Requested volume 100 3 3 H05 Stepsize in MW 10 3 4 H14 Run Page 34 of 46 eAuctionyzer Manual 03 6 1 Setup of Sensitivity Analysis A sensitivity analysis
25. l E hart b Charts From s0 0017 To 24 00 oto 24 TUM UEM 2011 2 11 H01 6 000 Auction des HOS Max Capacities on border 2011 2 11 H03 2011 2 11 H04 2011 2 11 H05 Bm 2011 2 11 H06 5 000 PSEG SDE AT 2011 2 11 H07 ERESSE HAT 2011 2 11 H08 A 2011 2 11 HO9 mayir DE ar 2011 2 11 H10 4 000 CZ SK DE AT 2011 2 11 H11 iios in 2011 2 11 H12 Sum Import 2011 2 11 H13 zDE AT 2011 2 11 H14 E un 2011 2 11 H15 E 2011 2 11 H16 2011 2 11 H17 H 2011 2 11 H18 S 2011 2 11 H19 000 2011 2 11 H20 2011 2 11 H21 2011 2 11 H22 2011 2 11 H23 1 000 2011 2 11 H24 Day 2011 2 11 HO1 Day2011 2 11 H07 Day2011 2 11 H13 Day 2011 72 11 H19 PTDF zd Save As 03 2 4 3 All to all View At the all to all view the shown paths can be specified In the upper section of the view the shown borders can by defined By selecting different market areas as source and sink areas the available borders are shown next These borders can be selected or deselected and only the data for the selected borders are shown in the table By pressing switch the data can be shown in a graph Figure 12 shows the data of the all to all view in a table and Figure 13 the belonging graph Figure 12 PTDF table view for selected borders PTDF D Bid Scenario All to all From 00 00 To 24 004 Oto 24
26. products one path Product BASE w Add 00030 z 00031 test1 iz i Delete C Including all of the products 7 Show own bid scenarios 7 Show market bid scenarios 03 3 6 Bid Generator Another possibility to add bids is to generate bids by statistical behaviors The bid generator provides this powerful functionality To open the bid generator the button Generate has to be pressed at Bid scenario edit view Figure 18 It opens the bid generator Figure 21 amp Figure 22 The bid generator is basically split up into two methods region and path wise generation of bids 03 3 6 1 General Settings First the method has to be selected The method is either region wide see 03 3 6 3 or path wise see 03 3 6 2 As next step the product for which bids should be generated has to be declared The third part is to select the statistical method Four statistical methods are available flat distribution normal distribution concave and convex distribution Depending on the distribution method the distribution parameter has to be defined For a detailed definition of the statistic methods see Appendix A STATISTIC METHOD DESCRIPTION The last part of the general settings are the bid volumes The generated bids will have the volumes in MWh defined in this field Different volumes can be separated by The volumes must be whole numbers greater than zero There will be an equal deviation of the
27. sink In the table the requested volume the accepted volume and the market clearing price for this path is shown for each step 03 6 5 3 Step Comparison Element View The step comparison element view compares one element Requested volume accepted volume or MCP over the selected steps and paths The table has a column for each path in which the results for each step is displayed 03 6 5 4 Step Comparison Full View The full view displays all elements of the result set in a table It can be selected for which steps sources and sinks the requested volume the accepted volume and the market clearing prices should be shown The table is sorted by step source and then by sink Page 36 of 46 eAuctionyzer Manual 03 6 5 5 Single Step Path View The single step path view displays the overview results for all paths of one step It correlates to the result path view see 03 5 2 3 and shows the requested volume the accepted volume or the MCP for all paths in a matrix 03 7 Data Management and Presettings Some of the used and stored data can be personalized and initialized This function provides a faster and better usage of the main program functionalities Also the not editable data can be shown to get a fast overview on the data used in the background of the program e g the existing products 03 7 1 Manage the Market Areas A market area consists of market zones The binding of the zones to the market area cannot be managed
28. will be submitted Figure 3 Integrating GAMS path y Standard paths 3 ml TER ao Gams exe file C Programme GAMS22 5 gams exe Select Look In Desktop 5 c Es rm PTDF import path D Benutzer HartliebS Desktop PDTF Select C Desktop J Test_PTDF b eAuctionyzert1 C testiMG Bid import path D Benutzer HartliebS Eigene Dateien Select eWorldAuctionyzer TraderToolRunable C FileDir Save as path D Benutzer HartliebS Desktop Select EI GB test Save dl File Name DiBenutzetHartliebStDesktop Files of Type All Files x Page 10 of 46 eAuctionyzer Manual 02 5 License of the Software 02 5 1 Shipping License eAuctionyzer is shipped with no guilty license No functionality will be available A license has to be applied for Therefore go in eAuctionyzer to Setting License Figure 4 At an update there is no need to apply for a new license The license of the previous version will be kept 02 5 2 Request a License A license can be requested under Setting License e Fill in the personal data e Press Generate Registry File This opens the local file system and the registry file can be stored anywhere at the local system e Send this file to tradertool riecado at e By the given data RIECADO generates a license file e g filename lt name gt _license lic with an expiration date in case of a temporary l
29. 0 319 0 240 0 191 0 Day 2011 2 11 H05 Day 2011 27 11 H08 270 0 319 0 240 0 191 0 Day 2011 2 11 H06 Day 2011 24 11 409 75 0 411 0 231 0 303 0 Day 2011 2 11 H07 Day 2011 2 11 H10 75 0 411 0 231 0 303 0 Day 2011 2 11 H08 Day 2011 2 11 H11 75 0 411 0 231 0 303 0 Day 2011 2 11 H09 Day 2011 2 11 H12 75 0 411 0 231 0 303 0 Day 2011 2 11 H10 Day 2011 2 11 H13 75 0 411 0 231 0 303 0 Day 2011 2 11 H14 75 0 411 0 231 0 303 0 Day 20102014 H11 Day 2011 2 11 H15 75 0 411 0 231 0 303 0 Day 2011 2 11 H12 Day 2011 2 11 H16 75 0 411 0 231 0 303 0 Day 2011 2 11 H13 Day 2011 27 11 H17 47 0 168 0 110 0 149 0 Day 2011 2 11 H14 Day 20117 2711 H18 47 0 168 0 110 0 149 0 Day 2011 2 11 H15 Day 20114 24 11 H19 47 0 168 0 110 0 149 0 Day 2011 2 11 H16 Day 2011 2 11 420 47 0 168 0 110 0 149 0 Day 2011 2 11 H17 Day 2011 27 11 H21 47 0 168 0 110 0 149 0 Day 2011 2 11 H18 Day 2011 2 11 H22 47 0 168 0 110 0 149 0 Day 2011 2 11 423 47 0 168 0 110 0 149 0 Doy 2011 2111 H19 Day 2011 2 11 H24 47 0 168 0 110 0 149 0 Day 2011 2 11 H20 Day 2011 2 11 H21 Day 2011 2 11 H22 Day 2011 2 11 H23 Day 2011 2 11 H24 __Save As Page 15 of 46 eAuctionyzer Manual Figure 11 PTDF graph view for all sources to one sink All to 1 All sources to one sink View for the selected PTDF s Sink DE AT e Bid Scenario of 5
30. ATIC ILLUSTRATION OF A FLAT DISTRIBUTION SCHEMATIC ILLUSTRATION OF A NORMAL DISTRIBUTION SCHEMATIC ILLUSTRATION OF A CONVEX DISTRIBUTION SCHEMATIC ILLUSTRATION OF A CONCAVE DISTRIBUTION OVERVIEW ON CALCULATION TIMES eAuctionyzer Manual 34 34 34 36 37 38 38 39 39 40 42 43 43 44 45 Page 7 of 46 eAuctionyzer Manual 01 INTRODUCTION This manual describes the usage of the eAuctionyzer for market analysis of load flow based capacity auctions in CEE Central Eastern Europe region This manual conducts all installation processes proceedings and the analysis 01 1 Target Group The target group for the eAuctionyzer are market participants user of ECAMT Enhanced Capacity Auction Management Tool which is in use for CEE CAO Central Auction Office located in Freising 01 2 Writing Conventions Buttons that have to be clicked by the user are underlined in the text Names and terms are under quotation marks drop down by clicking with the mouse cursor on a drop down selection combo box a list box is displayed to see all available choices Select one of the items The selected item remains visible in the assigned field The screenshots help to visualize the verbal description The enclosed data may not coincide with real data 01 3 General Principles and User Guidance 01 3 1 Navigation 01 3 1 1 Navigation Menu The navigation menu is located on the left side The navigation menu contains menu items to access
31. H02 Day 2011 2 8 H03 Day 2011 2 8 H04 Day 2011 2 8 H05 Delete Save As Day 2009 8 10 H01 Day 2010 7 3 H23 Day 2011 2 11 H19 Month 2011 3 PTDF 03 3 Bid Scenarios A bid scenario defines a bidding structure strategy for an auction 03 3 1 Bid Scenario Layout A bid scenario includes a name a list of tags dates the bids split by the products and a flag for own or market scenario 03 3 1 1 Tag Tags are descriptions that can be free assigned and are designed for facilitating the search e g summer sunny sunday windy cold 03 3 1 2 Date Dates must be allocated to show that the scenario is dedicated to a specific day If no date is allocated the scenario will not be selectable at the auction scenario screen see 3 4 03 3 1 3 Product Products are individual auction availability elements which can be bid for In a bid scenario there can be bids for daily products e g HO1 H02 bids for monthly or yearly auctions are signed by the product BASE Further information on the products are described at 03 7 3 03 3 1 4 Own Bid Scenario The flag Own bid scenario defines whether a scenario simulates a market behavior or the own bids As described later auctions see 03 4 1 2 can be calculated with more than one bid scenario The idea is to take one scenario for market behaviors and one to simulate the own strategy At the results see 03 5 the different scenarios ca
32. K DE AT 5 240 H01 CZ SK DE_AT 10 210 Delete Save as Add a single bid Product Source Sink Volume Price BASE v pe ar DE_AT gt ol 0 00 Add Page 21 of 46 eAuctionyzer Manual 03 3 2 4 Add Single Bids A single bid can be added at the bottom part of the Bid list view Figure 19 By selecting product source and sink inserting volume and price and afterwards click on Add a bid will be added to the list Source and sink must be different and the volume and the price greater than zero The list will be reordered see 03 3 2 3 03 3 2 5 Delete Bids Bids can be deleted by selecting the bids at Bid list view and click on Delete next to the table All selected bids will be deleted 03 3 2 6 Export the Bid List The shown bids in the bid list can be exported as csv file to the local file system By pressing Save As the local file system opens and a save directory can be selected 03 3 3 Save and Delete Bid Scenarios A bid scenario or the entered changes are saved through a click on Save at the Bid scenario edit view Figure 18 Only after this action the changes will be committed Leaving the screen by pressing Back or a button in the navigation bar will reject the changes By pressing Delete the whole scenario will be deleted A scenario can only be deleted when it is not used in an auction otherwise the button Delete will not be available In this case also a save will only refer to the changes at Name Tag
33. LES 1 400 Value 1200 BH Accepted Bl not accepted 1 000 E E me E 800 2 S 600 z pu 400 yv Aggregate Products 200 Source Sink Code Code DE AT PSEO ELES MA VIR CZ SK DE AT DE AT PSEO PSE ace ELES ELES MAVIR MAVIR CZ SK CZ_SK Aggregate Aggregate Page 32 of 46 05 5 2 6 Full View eAuctionyzer Manual The full view Figure 39 displays the results for all existing paths products and scenarios he entries are sorted by product bid scenario source area and sink area and show the requested volume the accepted volume and the MCP for this result By pressing Aggregate under the selected elements this elements will be summed up In case of multiple source sink areas or products the MCPs cannot be calculated Figure 39 Result view for the full path results Views Full view v Full View Result Table Product Scenario Source Sink Req Acc Mcp H01 1 MAVIR CZ SK 0 0 3 51 4 H01 1 MAVIR DE_AT 25 25 0 00 H01 1 MAVIR ELES 0 0 0 00 H01 1 MAVIR PSEO 0 0 0 00 H01 1 CZ SK MAVIR 554 554 0 00 H01 1 CZ SK DE AT 125 125 0 00 H01 1 CZ SK ELES 40 40 0 00 H01 1 CZ SK PSEO 10 10 0 00 H01 1 DE_AT MAVIR 1151 175 13 76 H01 1 DE_AT CZ SK 165 0 17 27 H01 1 DE_AT ELES 1265 87 10 37 H01 1 DE_AT PSEO 0 0 6 13 H01 1 ELES MAVIR u 0 3 39 H01 1 ELES CZ SK 30 0 6 90 H01 1 ELES DE_AT 65 65 0 00 H01
34. On the right side by selecting a PTDF the approximated capacities can be defined The capacities for the calculation will only be taken when the price on this path is greater than zero The auto update option enables that the depending matrices will automatically be updated if the data in the corresponding table matrix changes By pressing Generate the bids will be generated Figure 22 Bid generator with region wide view Bid generator Select method Region wise v Select product H01_ wiv Statistic method Normal distribution v Deviation MCP Value 10 00 Bid volumes 5 1 0 Generate bids for the region Statistic average price Statistic capacities by a ptdf Select PTDF Product H01 Market prices Area Price DE AT 20 0 4 ELES j CZ SK pn Auto update MAVIR 24 0 H z PSEO 260 v Update PTDF 2010 471 H01 v Maximum capacities per path for PTDF FromiTo DE AT ELES CZ SK MAVIR PSEO Sum Export DE AT 319 191 240 270 1020 ELES 561 480 774 361 CZ SK em 985 2187 MAVIR 1 05 422 126 PSEO 391 780 297 434 Sum Import 1675 2206 1902 1094 3632 1150 Update Calculation capacities per path From To DE_AT ELES CZ SK MAVIR PSEO Sum export DE AT 319 191 240 1020 ELES 0 480 774 o CZ SK MAVIR o o 126 Market clearing prices for calculation DE AT
35. PG CEPS 85 00 0 01 H19 APG CEPS 85 00 0 01 H18 APG CEPS 85 00 0 01 H17 APG CEPS 85 00 0 01 H16 APG CEPS 85 00 0 01 H15 APG CEPS 85 00 0 01 H14 APG CEPS 85 00 0 01 H13 APG CEPS 85 00 0 01 H12 APG CEPS 85 00 0 01 H11 APG CEPS 85 00 0 01 H10 APG CEPS 85 00 0 01 H09 APG CEPS 85 00 0 01 Hos APG CEPS 85 00 0 01 H07 APG CEPS 85 00 0 01 H06 APG CEPS 85 00 0 01 H05 APG CEPS 85 00 0 01 H04 APG CEPS 85 00 0 01 H03 APG CEPS 85 00 0 01 H02 APG CEPS 85 00 0 01 H02 ELES APG 20 00 0 51 H02 ELES APG 5 00 0 47 H02 ELES APG 10 00 0 45 H02 ELES APG 5 00 0 38 H02 ELES APG 5 00 1 15 H02 ELES APG 50 00 1 02 H02 ELES APG 10 00 0 97 The order of the columns is irrelevant as well as additional text in the header fields or additional columns After the import of the bids the quick view for the bids are re calculated The quick view includes a bid count per product as well as path information Page 20 of 46 eAuctionyzer Manual that can be shown for each product The path information is split up into three matrices first showing the bid count second the requested volume and the third the average price of the bids for each path The three matrices Figure 18 on the right side present the bid count the requested volume and the average price of the bids for each path If lines or elements are ignored in case of inconsistent data an information will be displayed after the import Figure 18 Full bid scenario edition view
36. RIECADO Regional Energy Capacity Auction Data Operator GmbH Version 1 1 USER MANUAL RIECADO eAuctionyzer Version 1 1 LEGAL NOTES Microsoft MS MS DOS and Windows are trademarks of the Microsoft Corporation It is not allowed to pass on or copy this document The use of the content has to be permitted Acting against claims damages All rights reserved especially in case of taking out a patent The screenshots serve as samples and do not bind to a special functionality Technical subject to change without prior notice ISSUED BY RIECADO GmbH Regional Energy Capacity Auction Data Operator Gesellschaft m b H Palais Liechtenstein AlserbachstraBe 14 16 A 1090 Vienna T 43 0 1 319 07 01 Fax Ext 70 E office riecado at W www riecado at eAuctionyzer Manual DOCUMENT MANAGEMENT Permission to Change Stefan Hartlieb RIECADO GmbH Wien Andreas Wolf RIECADO GmbH Wien Document Status Final Document History VERSION STATUS DATE RESPONSIBLE REASON FOR CHANGE 0 1 Completed 20 07 2010 Stefan Hartlieb Finishing 0 1 Beta 0 2 Completed 18 11 2010 Stefan Hartlieb Finishing 0 2 Beta 1 0 Completed 17 12 2010 Stefan Hartlieb Release 1 0 1 1 Completed 22 03 2011 Stefan Hartlieb Release 1 1 Page 3 of 46 TABLE OF CONTENTS 01 INTRODUCTION 01 1 Target Group 01 2 Writing Conventions 01 3 General Principles and User Guidance 01 3 1 Navigation 02 INSTALLATION AND SYSTEM REQUIREMENTS 02 1 System
37. Save as the auction scenario will be saved If an existing auction scenario has been opened Save as saves a copy of the original scenario with the done changes and Save will overwrite the original Figure 30 Auction scenario save section Save auction scenario Save Name New Auction Save Save as The saved parts are the auction type full day or single PTDF in case of a single PTDF the selected PTDF in case of a full day the date the selected bid scenarios the save name and if the auction was calculated and has a result After the auction scenario has been saved the sensitivity analysis panel will be shown see 03 6 and sensitivity analyses can be calculated Page 27 of 46 03 4 1 7 Close an Auction Scenario eAuctionyzer Manual If at minimum one sensitivity analysis see 03 6 is calculated for the auction scenario the auction scenario will not be editable anymore This is done to keep the data consistent because if afterwards the auction scenario will be changed the sensitivity analyses would not correspond to the auction scenario anymore In this case Save As generates an editable copy of the auction scenario without the sensitivity analyses corresponding to the original auction scenario 03 4 2 Open a Saved Auction Scenario A saved auction scenario can be opened over the screen available under Auction and then List The Auction list view Figure 31 will be shown By selecting an auction scenario in the
38. T BIDS TO A SCENARIO BY PRESSING IMPORT PART OF A POSSIBLE BID IMPORT FILE FULL BID SCENARIO EDITION VIEW BID LIST VIEW BID SCENARIO SELECTION VIEW BID GENERATOR WITH PATH WISE VIEW BID GENERATOR WITH REGION WIDE VIEW MINIMIZED AUCTION FLOW SCREEN AUCTION FUNCTIONALITY PANEL PTDF SELECTION PANEL BID SCENARIO SELECTION PANEL IMPORT EXPORT LIMIT SELECTION PANEL AUCTION SCENARIO SCREEN WHILE CALCULATION AUCTION SCENARIO SCREEN AFTER CALCULATION AUCTION SCENARIO SAVE SECTION AUCTION SCENARIO LIST RESULT VIEW SELECTION REGION AT RESULT VIEW RESULT TABLE VIEW FOR THE BIDS RESULT GRAPH VIEW FOR THE BIDS RESULT VIEW FOR THE PATHS RESULT VIEW FOR ONE SOURCE AND ALL SINKS RESULT VIEW FOR ALL SOURCES AND ONE SINK RESULT VIEW FOR THE FULL PATH RESULTS 8 10 10 11 12 13 14 14 15 15 16 16 17 18 19 20 20 21 21 23 24 24 25 25 26 26 27 27 27 27 28 29 29 30 31 31 32 32 33 Page 6 of 46 FIGURE 40 FIGURE 41 FIGURE 42 FIGURE 43 RESULT VIEW FOR THE PRODUCTS SUMMING AT RESULT VIEW SENSITIVITY ANALYSIS PANEL OF AN AUCTION SCENARIO SENSITIVITY ANALYSIS RESULT PANEL WITH THE STEP COMPARISON PATH VIEW FIGURE 44 FIGURE 45 FIGURE 46 FIGURE 47 FIGURE 48 FIGURE 49 FIGURE 50 FIGURE 51 FIGURE 52 FIGURE 53 FIGURE 54 MARKET AREA MANAGEMENT MARKET PRICE MANAGEMENT PRODUCT LIST STANDARD IMPORT AND EXPORT LIMITS STANDARD PATH DEFINITION VIEW BLOCKED BID SCENARIO SCHEM
39. The products used in the program can be shown under Data and Products Figure 46 They are split up into auction able and bid able Auction able are all products that can be used for an auction bid able all products for which bids can be set up in a bid scenario This differentiation has the advantage because it is not useful to differ bids for nearly equal products E g for a month with 30 or 31 days it should be able to use the same bids of a bid scenario Actual there can be bids for each hour of the day HO1 to H24 and for monthly or yearly auctions bids with the product BASE are used Also another simplification has been done There is only one monthly auction able product instead of four and one yearly product instead of two This only infects the payment value See 03 5 2 1 of a bid in the results because they are multiplied by the hours in a constant way The maximum error deviations of the payment value that will occur are two days on a normal February with 28 days In that case the payment value will be 6 67 to high The most likely deviation occurs on 31 days months In that case the payment value will be 3 33 to low In a leap year the error against a normal year is 0 23 The MCP and the accepted volumes of a result are NOT affected Block bids and linked bids are not implemented yet as they are also not used within CAO IT Figure 46 Product list Code Name Type Hours Bid able Acution able For Monthly an Yearl
40. Z SK Aggregate Aggregate Back Source View Views Path view PATH RESULTS Select element to show Accepted Volume Result for the selected element From To DE AT PSEO ELES MAVIR CZ_SK DE AT 0 30 218 oja PSEO 0 0 0 0 0 ELES 85 0 0 0 0 MAVIR 25 0 o 0 0 CZ_SK 125 10 20 554 oje Sum Save all Save as chart by amCharts com Accepted capacities 600 Source B czs 500 B vun E 400 B ces E m0 esto o S B oe ar 3 200 100 DE_AT PSEO ELES MAVIR CZ SK Sink The source view Figure 37 displays the results for one source to all sinks The source can be selected over the drop down menu The elements in the drop down list depend Page 31 of 46 eAuctionyzer Manual on the selected source areas For each source sink combination the requested volume the accepted volume and the market clearing price is shown At the lower area of the view the results are shown as graph Figure 37 Result view for one source and all sinks Results Selections Views Scenarios Source view v RESULTS for a selected source Select Source DE_AT ID Name Own 1 scoot v Aggregate Scenarios Result Table Sink Requested Volume Accepted volume MCP Products DE_AT 0 NaN 4 Code Hours PSEO 0 0 6 02 H01 1 a ELES 1265 30 15 70 MAVIR 1151 218 13 51 CZ SK
41. ado e uctionyzer Browse 02 3 Update of eAuctionyzer If a previous version of eAuctionyzer is running on your system please copy the file eAuctionyzer update 1 x exe to the installation directory After running the file your version of eAuctionyzer will be updated to version 1 x All previous data will be available 02 4 Installation of GAMS 02 4 1 Installation Auctions are calculated on the basis of an external program called GAMS www gams com For installing GAMS go to the webpage and follow the installation instructions http www gams com dd docs gams win install pdf 2011 03 01 The installation of GAMS Version 23 5 needs about 320 MB of free hard disk space At the first start of eAuctionyzer GAMS has to be integrated to the system see 02 4 3 02 4 2 GAMS License With eAuctionyzer also a GAMS license is provided GAMS Run Time Base Module CPLEX MIP The depending license file gamslice txt is sent to you with the program data During the GAMS installation at point 2 Copy the GAMS license file select the provided license file gamslice txt 02 4 3 Integration of GAMS To integrate this functionality the gams exe has to be assigned Therefore go to Setting and Setting Figure 3 By Selecting next to GAMS path the file system opens and the gams exe usually under C Program Files Gams lt gt gams exe the installation directory of GAMS see 02 4 1 can be selected With a click on Save the changes
42. ay 2011 2 11 H18 Day 2011 2 11 H22 143 0 Day 2011 2 11 H23 113 0 Dey 20 T CEN sin Day 2011 24 11 H24 113 0 Day 2011 2 11 H20 Day 2011 2 11 H21 Day 2011 2 11 H22 Day 2011 2 11 H23 Day 2011 2 11 H24 o Saeas 03 2 4 2 1 to all amp all to 1 View The one to all view shows all exports from the market area selected as source the all to one view all imports to the market area selected as sink In the table the capacities for each path are shown if no concurrency exists By clicking the button switch the values can be shown as interactive graph Figure 10 shows the table screen of the one to all view and Figure 11 the graph for the all to one view Figure 10 PTDF table view for one source to all sinks 1to all Allto 1 All to all One source to all sinks View for the selected PTDF s Source DE AT v 22 23 switch Time PSEO ELES MAVIR CZ SK Day 2011 2 11 H01 270 0 319 0 240 0 191 0 From 00 00 To 24 007 Oto 24 Day 2011 2 11 H02 270 0 319 0 240 0 191 0 Day 2011 2 11 H01 Day 2011 24 11 403 270 0 319 0 240 0 191 0 Day 2011 2 11 H02 Day 2011 24 11 H04 270 0 319 0 240 0 191 0 Day 2011 2 11 HOS 270 0 319 0 240 0 191 0 Day 2011 2111 H03 Day 2011 2 11 HOG 270 0 319 0 240 0 191 0 Day 2011 2 11 H04 Day 2011 2 11 H07 270
43. bid volumes to the bids 03 3 6 2 Path Wise Bid Generation At a path wise generation Figure 21 the source and the sink of the path have to be defined Also the price level on which the distribution will be laid in case of a flat distribution all prices are on that level has to be defined The requested volume defines how many volume the bids should have in sum By pressing Generate the bids will be generated Page 23 of 46 eAuctionyzer Manual Figure 21 Bid generator with path wise view Bid generator Select method Path wise Dd Select product H01 v Statistic method Normal distribution w Deviation MCP Value 10 00 Bid volumes 5 10 Generate for one path Source Sink Price Level Requested Volume ELES w CZ_SK gt 1 00 100 Generate Back Submit 03 3 6 3 Region Wide Bid Generation The region wide generation Figure 22 is a little bit more sophisticated For a region wide generation for each path a price level and a capacity have to be declared In a way for better overview the price levels can be derived from the market prices and the capacities from a PTDF matrix With the defined market prices in the Market prices table the price levels approximated market clearing price for the paths will be calculated by the difference between the two market prices The approximated MCP will be calculated by pressing the button Update next to the table
44. can only be done for requested volumes at one border in one direction The definition of the border and the direction is done by selecting one market area as source area and one as sink area Afterwards the start volume and the additional requested volume has to be defined and the step size this capacity should be approximated declared E g if the start volume is O and the additional requested volume is 100 and the step size is 10 then the sensitivity analysis will calculate 11 steps with additional amounts of O 10 20 30 40 50 60 70 80 90 and 100 MW 03 6 2 Run of Sensitivity Analysis By pressing Run the sensitivity analysis is calculated For each PTDF of the auction a own sensitivity analysis is calculated At each step of each PTDF a full auction single PTDF auction see 03 4 will be calculated E g for a full day 24 PTDFs and 10 steps 240 single PTDF auctions will be calculated This might take a long time During the calculation next to the button Run the actual progress is shown It shows for which PTDF and for which additional amount the auction is actually calculated After the calculation the sensitivity result will be shown in the Calculated sensitivity analysis list If in minimum one sensitivity analysis is performed for an auction scenario the auction scenario will be closed see 03 4 1 7 This means that the PTDFs and the bid scenarios an auction scenario is calculated for cannot be changed anymore 03 6 3 Open a Cal
45. chematic illustration of a concave distribution Concave Distribution Price in Bid Number Page 44 of 46 APPENDIX B CALUCLATION TIMES eAuctionyzer Manual The calculation where done on a standard laptop Intel Core2 CPU T7400 2 16GHz AGB RAM This is done because an exact approximation of the calculation time before calculating the model is not possible This section provides a short overview how long the calculation could take in case of different amount of data s The results are split up by the PTDF count how many PTDFs PTDF length how many branches in average per PTDF the general bid count the range of bid counts per product the range of bid counts per path the range of volume per path and the calculation time Figure 54 Overview on calculation times PTDF Avg count Branches 1 600 1 600 4 600 4 600 4 600 1 1500 1 1500 23 1500 23 1500 23 1500 Bids 200 1000 4000 800 452 200 1000 4600 23000 471 Bids per product 200 1000 1000 200 1 374 200 1000 200 1000 1 374 Bids per path 10 50 50 10 0 137 10 50 10 50 0 137 Volume per path 200 1000 1000 200 O 1265 200 1000 200 1000 O 1265 Time 2 sec 9 sec 35 sec 6sec 3sec 5 sec 24 sec 2 min 37 sec 10 min 20 sec 47 sec Page 45 of 46 APPENDIX C SHORT TERMS AMF Available Maximum Flow CAO Central Allocation Office CEE Central Eastern Europe ECAMT
46. culated Sensitivity Analysis If a sensitivity analysis is calculated for an auction scenario the auction scenario cannot be changed anymore The calculated sensitivity analyses are shown at Calculated sensitivity analysis In the list they are separated by the sensitivity analysis scenarios and for each scenario and each PTDF a sensitivity analysis exists One single sensitivity analysis has to be selected and by pressing the button Open or a double click the results of this sensitivity analysis are shown see 03 6 5 03 6 4 Delete a Sensitivity Analysis a Sensitivity Analysis Scenario A sensitivity analysis can be deleted by selecting it at Calculated sensitivity analysis and pressing the button Delete It is possible to delete one single sensitivity analysis or a whole sensitivity analysis scenario by selecting the corresponding element in the list If no sensitivity analysis exists for an auction scenario the auction scenario will be editable again 03 6 5 Sensitivity Analysis Results After opening a sensitivity analysis by pressing the button Open 03 6 3 the Sensitivity analysis result screen is shown Figure 43 There are four different views 03 6 5 2 to 03 6 5 5 available They are split up into Step comparisons views and Single step views Step comparison views compare a part of the results over the different steps and the single step view shows the whole result for one step Page 35 of 46 eAuctionyzer Manual Figur
47. d with 100 000 MW Not limit is defined by a negative value and shown as INF infinite The defined limits will be automatically written to the Limit Screen at auctions Figure 47 Standard import and export limits Import Export Limits E Max Import Max Export INF F EN Pseo 30 INF ELES 50 INF MAVIR INF INF MS 20 INF v 03 7 5 Predefine Import Paths Standard import paths can be defined under Setting und Setting Figure 48 The paths can be defined for importing PTDFs and bid scenarios from external files as for saving files out from the system In all cases the local file system will be opened The standard path defines at which location the file system will be opened This allows the user that always the same directory will be opened for the same process For the definition of the standard path the button Select next to PTDF import path Bid import path Save as path has to be pressed The file system opens and a directory can be chosen With a click on Save the changes will be submitted Figure 48 Standard path definition view y Standard paths SST r Gams exe file C Programme GAMS22 5 gams exe Select Look In a Desktop M m PTDF import path D Benutzer HartliebS Desktop PDTF Select 5 Desktop Test PTDF c eAuctionyzer11 testiMG Bid import path D amp Benutzer HartliebS Eigene Dateien Select eWorldAuc
48. e 43 Sensitivity analysis result panel with the step comparison path view PSEO gt DE AT 10 100 Selections Views Selection Steps c Views ls L Step Additional volume M CH Steps comparision view 4 Path view O 0 NO Or I CO 9 CO Ext i ie 219i mi e I 38 TD m mo gt q e ie je w 2 m m ng E o o o 9 0 OM m e m e e e e Cz SK _ MAVIR Cz SK MAVIR Saveas Back 3 0 5 1 Select the View and the View Selections At the View selection section the desired view can be selected Depending on the selected view at Steps Source and Sink different selections are possible At the step comparison views the steps that should be compared can be selected by marking them at single step view only on step can be selected Also the sources and the sinks that should be shown must be selected In case of the step comparison path view only one source and only one sink can be selected in all other cases a multiple selection of the areas is possible 03 6 5 2 Step Comparison Path View The step comparison path view displays the results for on path over the selected steps The steps that should be shown have to be selected at Selections Steps and afterwards one path must be selected by selecting one source and one
49. ed alphabetically by product source sink and at last by descending prices The bids can be filtered by products Only the bids attributed by the selected products in the list are presented Figure 19 Bid list view Bid informations Products BID LIST BASE PRODUCT SOURCE SINK REQUESTED V PRICE Hon H01 CZ SK DE AT 5 2 51 H02 H01 CZ SK DE AT 10 2 43 _ a H01 CZ SK DE AT 10 241 H01 CZ SK DE AT 10 240 H04 H01 CZ SK DE AT 5 2 36 H05 H01 CZSK DEAT 5 2 36 H06 H01 CZ SK DE AT 10 2 36 H07 H01 CZ SK DE AT 1 2 36 Hos H01 CZ SK DE AT 1 2 34 H09 H01 CZ SK DE AT 5 2 30 110 H01 CZ SK DE AT 1 2 28 ln H01 CZ SK DE AT 1 2 28 H01 CZ SK DE AT 5 2 28 H12 HOT CZ SK DE AT 1 2 27 H13 H01 CZ SK DE AT 10 2 25 H14 H01 CZ SK DE AT 5 2 24 H15 H01 CZ SK DE AT 5 2 23 H16 H01 CZ SK DE AT 10 2 22 H17 H01 CZ SK DE AT 1 221 H18 HD1 CZ SK DE AT 5 221 luis H01 CZ SK DE AT 1 221 H01 CZ SK DE AT 1 221 H20 Hot CZ SK DE AT 1 2 20 H21 H01 CZ SK DE AT 1 2 20 H22 H01 CZ SK DE AT 5 219 H23 H01 CZ SK DE AT 5 218 H24 H01 CZ SK DE AT 10 218 H01 CZ SK DE AT 10 247 H01 CZ SK DE AT 1 245 HD1 CZ SK DE AT 5 243 H01 CZ SK DE AT 5 242 H01 CZ SK DE AT 5 242 H01 CZ SK DE AT 10 242 H01 CZ SK DE AT 5 211 H01 CZ SK DEAT 1 210 H01 CZ SK DE AT 10 240 H01 CZ S
50. from the program If there are changes in this structure this has to be managed external in the data structure But for load flow based auctions only the market areas are meaningful The existing market areas can be shown in Data and Market Areas Figure 44 For a better use of the program the order of the market areas can be changed This can be done by selecting a market area in the table and pressing either the button Up or Down The market area will be shifted one position up or down in the list In every view multiple market areas occur the areas will be sorted by this order In addition a major source area and a major sink area can be selected In every case source or sink can be chosen the predefined major will be preselected This smoothes the usage if e g a trader is only concerned about one border Figure 44 Market area management 03 7 2 Market Prices The market prices are the actual energy price approximations of the user in the single market areas The market prices are used for the calculation of the approximated market clearing prices at the bid generator see 03 3 6 For an easier use they can be predefined at Data and Market Prices Figure 45 so that they have not to be inserted each time for new Actually there can only be one price level stored Page 37 of 46 eAuctionyzer Manual Figure 45 Market price management 03 7 3 Products
51. ic_20080810_1700_2D7_PDTF1 csv Date Mar 2 2011 E3 add FT ji m E Dedicated dates File Name LFB DAILY 01 01 2011 published bids csv 2011 03 01 E SS M 2011 03 02 Files of Type IcsvFiles v Select Cancel mn Show Generate Import Bids LI Delete Auctions used C Own bid scenario s Tg Auctions bid scenario is used Back Delete Save Duplicate 03 3 2 2 1 Layout of a Bid File A bid file has a header line and the bid lines The header line has to contain Source Sink Product Volume or Capacity Price or Preis Source and sink are either market areas or zones At import zones will be converted to the corresponding market area Not defined market areas or zones see 03 7 1 will be ignored Product should be a common used product HO1 to H24 or BASE If the product is not defined see 03 7 3 the entry of the file will be ignored The volume is the amount of power and has to be in whole numbers in MWh The price is the amount of money in Euro per MW and hour MWh The comma separator is either a or a No thousands separator is used The price and the volume must be positive Figure 17 Part of a possible bid import file Product Source zone Sinkzone Capacity Angebotspreis EUR MWh H24 APG CEPS 85 00 0 01 H23 APG CEPS 85 00 0 01 H22 APG CEPS 85 00 0 01 H21 APG CEPS 85 00 0 01 H20 A
52. icense and sends it back to the given email e By Search under Import license file the file can be selected e By Install the license will be installed e The status of the license or the expire date can be seen under Actual license information at Figure 4 02 5 3 Extend the License If there is the need to extend the license e g the expire date has pasted by repeat the steps in 02 5 2 You will get a new license file with a new expiration date from RIECADO Figure 4 Registry and license screen License amp Register System For Your Software Personal Data Actuall license information Last First Name Hartlieb Stefan Expire Date 2010 10 26 Company Riecado Address AlserbachstraBe 14 16 Import license file Zip Code Town 11090 Vienna Country Austria Search Install Email stefan hartliebt cismogroup com Save Registry File xl Phone 43 0 1 319 07 01 374 Look In amp 9 System C v ig amp ca SE Save C Addon C Programme Generate registry file CH DEV EJ Programs C3 Dokumente und Einstellungen cA WINDOWS E fsc tmp y auction out 20100810 115911 ES MSOCache CM mydata 4 il gt File Name hartlieb F egistry obj Files of Type All Files Page 11 of 46 03 APPLICATION DESCRIPTION 03 1 Program Startup
53. id scenario Scenario characteristic Bid informations Name empty matrices marketprices Bids quick view Path informations Tag Ad Dedicated tags Auction E Date aj Add atit Dedicated dates 2011 03 11 ES PSEO MAVIR ELES 8 37 7 41 0 00 0 00 0 99 0 00 0 00 0 00 iz 0 57 0 00 Bids Show Generate Import Auctions used Auctions bid scenario is used Setting z Coa O Own bid scenario Back Delete Save Duplicate Page 40 of 46 eAuctionyzer Manual 04 CONTACT INFORMATION General questions tradertoolOriecado at or andreas wolfQriecado at Technical support stefan hartliebOriecado at 43 0 1 319 07 01 374 Homepage WWW riecado at Page 41 of 46 eAuctionyzer Manual APPENDIX A STATISTIC METHOD DESCRIPTION This section gives a detailed view on the available statistical methods used to generate bids with the bid generator See 03 3 6 There are four different statistic distributions available Flat distribution Normal distribution Convex distribution Concave distribution Flat Distribution A flat distribution allots all elements at the same level The level which remains constant is the only parameter that is used for this distribution Figure 50 shows a schematic illustration of a flat distribution Figure 50 Schematic illus
54. k space The program kernel and execution files will take about 30 MB of hard disk space More space than the program files the computation data bid scenarios 03 3 PTDFs 03 2 and auction scenarios 03 4 will take An average PTDF matrix with 1500 branches has about 300 KB a bid scenario with 1000 bids per product 900 KB In that case the data for a day for each hour a PTDF 224 PTDFs and one scenario will be 8 MB for a month 30 times a day it will be 240 MB and for a year 365 times a day 3GB Also the sensitivity analysis will take a lot of disc space PLEASE ENSURE THAT THERE IS ENOUGHT FREE HARDDISC SPACE FOR THE DATA 02 2 Installation of eAuctionyzer on Windows Computers e eAuctionyzer does not need any specific installations e he program and the corresponding data are sent to eAuctionyzer users by email in a self extracting zip format www winzip com e Save the given File eAuctionyzer install 1 x exe to the local file system e Run the file and select an installation directory and press Unzip Figure 2 e eAuctionyzer can now be started by running the file eAuctionyzer jar under the installation directory e The functionality of the software will only be available after licensing the software see 02 5 Page 9 of 46 eAuctionyzer Manual Figure 2 Installation of eAuctionyzer To unzip all files to the specified folder press the Unzip button Close Unzip to dir C Program Files Riec
55. list and clicking Open or making a double click the auction scenario will be opened and the Auction scenario view will be shown with the corresponding data Figure 31 Auction scenario list Bid Scenario List of all saved auctions Name PTDF Date ScenariolDs Type Results name1 2010 11 10 1 2 FULL DAY New Auction1 2010 7125 2 FULL DAY New Auction6 2010 7125 123 FULL DAY New Auctions 2010 7 3 i 2 FULL DAY New Auction6 20101712 1 23 FULL DAY New Auction 20104713 FULL DAY New Auction 2010 7 FULL DAY New Auction 20101741 SINGLE PTDF BigAuction 2010 41 FULL DAY big one 2010 41 FULL DAY big one single 201 0 4 1 SINGLE PTDF CalTimeSingle 2010 7 1 SINGLE PTDF month001 2010 7 SINGLE PTDF month2 2010 7 31 SINGLE PTDF month3 2010 7131 SINGLE PTDF test_model 2010 41 SINGLE PTDF test model 2010 41 SINGLE PTDF New Auction 23 201071 0 1 4 OO 00 00 OO P Cn I E ND B SINGLE PTDF New Auction 2010 10 11 SINGLE PTDF CIEEJEIEEIEIEJERIEJEIEJEEIEJEIJEJEJ New Auction 2010 10 11 2010 10 11 New Auction 2010 10 1 FULL DAY FULL DAY SINGLE PTDF R K 03 5 Results Open The results of a calculated auction
56. n be analyzed separately Page 18 of 46 eAuctionyzer Manual 03 3 1 5 Bid Each bid includes product source sink capacity and price All bids together define a bidding scenario 03 3 1 6 Auctions Used The auctions used shows in which auction scenario the bid scenario is used for If a bid scenario is used in an auction scenario the bid structure cannot be changed anymore This is a matter of keeping the data consistent because if the bid structure changes the results of each auction this bid scenario is used will change too and the results will not be guilty anymore until they are new calculated 03 3 2 Generate a New Bid Scenario A new bid scenario will be generated by going to Bid Scenario at the navigation bar and then to New This opens an empty Bid scenario edition view Figure 15 Figure 15 Empty bid scenario edition view Name Bids quick view Path informations Product Bidcount Bid count on a path lal Tag Add Sum of requested volume per path E Delete Add z Dedicated dates Average price on a pa Date Bids Show la Gener ate import y Delete ns i E Auctions usec C Own bid scenario A s Auctions bid scenario is used Back Delete Save Duplicate 03 3 2 1 Entering the Bid Scenario Characteristics At first the bid scenario characteristic information is entered
57. panel Auction Functions Full day auction Auction functionality Run Auction Save auction scenario Save Name New Auction Save Saveas 03 4 1 1 Select the PTDF The PTDFs are selected to a date If there are PTDFs for the selected day in case of a full day auction all PTDFs will be match to the corresponding product and for all of these PTDFs the auction will be calculated In case of a single PTDF auction one of the PTDFs of the list has to be selected by marking it In this case the matching monthly and yearly PTDFs will be shown too The auction will be calculated for the selected PTDF Page 25 of 46 eAuctionyzer Manual Figure 25 PTDF selection panel Select PTDFs PTDF s February v 20115 Year 2011 Sun Mon Tue YY Thu Fri Sat Day 2011 2111 H01 r 1 2 Day 2011 2 11 H02 Day 2011 2 11 H03 I y 11 H04 11 H05 H06 11 H07 11 H08 111 H09 111 H10 g N e NON ON ON NON ON ON ON OI 03 4 1 2 Select the Bid Scenarios The bid scenarios will also be selected over a calendar Each bid scenario has dedicated dates see 03 3 1 2 and on that dates it will be shown in the calendar If a bid scenario has no date it will not be shown At Available scenarios all scenarios will be shown for the selected date By selecting a scenario and pressing Add under to the table the scenario will be added to the Selected scenarios
58. quick information is presented By clicking Edit the Bid edit view will be opened and the scenario can be edited Page 22 of 46 eAuctionyzer Manual Figure 20 Bid scenario selection view y Search for a bid scenario Matching scenarios Bid scenario quick information Name 00001 For all products one scenario aj Name 00002 Base all paths Tag add Tag a j E M 00003 product H01 all paths 00004 Bids for product H01 00005 Bids for product H02 00006 Bids for product H03 00007 Bids for product H04 00008 Bids for product H05 00009 Bids for product H06 100010 Bids for product H07 00011 Bids for product H08 100012 Bids for product H09 00013 Bids for product H10 Date x s I Delete 00014 Bids for product H11 L Including all of the tags 00015 Bids for product H12 E ala 1 00016 Bids for product H13 Date E3 ada p 100017 Bids for product H14 2 00018 Bids for product H15 00019 Bids for product H16 00020 Bids for product H17 00021 Bids for product H18 100022 Bids for product H19 00023 Bids for product H20 IE 00024 Bids for product H21 Product Product Bid count 00025 Bids for product H22 00026 Bids for product H23 00027 Bids for product H24 100028 Bids for product BASE Delete a ek al ofthe dates 00029 All
59. shows the PTDF search view in combination with the graph of the one to all view for PTDFs of different days and auction types Page 17 of 46 eAuctionyzer Manual Figure 14 PTDF search view in combination with the 1 to all view List Search Single View 1to 1 1 to all Alito 1 Ali to all From Date IMar 7 2000 One source to all sinks View for the selected PTDF s 4 To Date Source ES El DE_AT v Mar 7 2011 ra x M v Yearly PTDFs 7 Monthly PTDFs Bid Scenario 7 Daily PTDFs switch From 00 00 To 24 00 Oto 24 chart by amCharts com B Available PTDFs Month 2009 1 a ZG Auction Month 2009 6 Max Capacities on border Day 2009 8 10 H01 Day 2009 9 26 H01 45 000 Borders Year 2010 i DE AT sPSEO Day 2010 4 1 H01 40 000 Day 2010 4 1 H02 DE AT ELES Day 2010 4 1 HO3 Day 2010 4 1 HO4 35 000 Day 2010 4 1 H05 Day 2010 4 1 H06 ik Day 2010 4 1 H07 v 30 000 Data E DE AT MAVIR DE AT CZ sk DE AT Sum Export Setting Add i Selected PTDFs e Day 2009 8 10 H01 amp Year 2010 So 000 Q Day 2010 4 1 H01 S Day 2010 4 1 H23 Month 2010 7 Day 2010 7 1 H01 Day 2010 7 1 H03 10 000 Day 2010 7 1 H05 Day 2010 7 1 H14 Day 2010 7 2 H01 Day 2010 7 3 H23 Day 2010 10 1 H01 Year 2011 Day 2011 2 8 H01 Day 2011 2 8
60. sis Scenario 35 03 6 5 Sensitivity Analysis Results 35 03 7 Data Management and Presettings 37 03 7 1 Manage the Market Areas 37 03 7 2 Market Prices 37 03 7 3 Products 38 03 7 4 Predefine Import and Export Limits 38 03 7 5 Predefine Import Paths 39 03 8 Other Functionality 39 03 8 1 Export the Shown Tables 39 03 8 2 Block Functionality 39 04 CONTACT INFORMATION 41 APPENDIX A STATISTIC METHOD DESCRIPTION 42 APPENDIX B CALUCLATION TIMES 45 APPENDIX C SHORT TERMS 46 Page 5 of 46 eAuctionyzer Manual TABLE OF FIGURES FIGURE 1 FIGURE 2 FIGURE 3 FIGURE 4 FIGURE 5 FIGURE 6 FIGURE 7 FIGURE 8 FIGURE 9 FIGURE 10 FIGURE 11 FIGURE 12 FIGURE 13 FIGURE 14 FIGURE 15 FIGURE 16 FIGURE 17 FIGURE 18 FIGURE 19 FIGURE 20 FIGURE 21 FIGURE 22 FIGURE 23 FIGURE 24 FIGURE 25 FIGURE 26 FIGURE 27 FIGURE 28 FIGURE 29 FIGURE 30 FIGURE 31 FIGURE 32 FIGURE 33 FIGURE 34 FIGURE 35 FIGURE 36 FIGURE 37 FIGURE 38 FIGURE 39 NAVIGATION BAR INSTALLATION OF EAUCTIONYZER INTEGRATING GAMS PATH REGISTRY AND LICENSE SCREEN PTDF IMPORT SCREEN AFTER PRESSING SEARCH PTDF MATRIX PTDF LIST VIEW PTDF VIEW PTDF ONE SOURCE TO ONE SINK VIEW PTDF TABLE VIEW FOR ONE SOURCE TO ALL SINKS PTDF GRAPH VIEW FOR ALL SOURCES TO ONE SINK PTDF TABLE VIEW FOR SELECTED BORDERS PTDF GRAPH VIEW FOR SELECTED BORDERS PTDF SEARCH VIEW IN COMBINATION WITH THE 1 TO ALL VIEW EMPTY BID SCENARIO EDITION VIEW IMPOR
61. the available main functions of the application For several entries corresponding sub menus exist which will be viewable by clicking on the desired menu point The navigation can be used independently from the previously used functionality 1 3 1 2 Navigation Bar For selecting the relevant menu choose the respective link in the navigation bar on the left hand side Afterwards select the corresponding link in the sub menu Figure 1 Navigation bar riecadoms Page 8 of 46 eAuctionyzer Manual 02 INSTALLATION AND SYSTEM REQUIREMENTS 02 1 System Requirements 02 1 1 Program Requirements eAuctionyzer is designed with Java www java com To run eAuctionyzer Java version 6 is needed Java is platform independent and preinstalled under Windows from Windows XP on If it is not installed at your operating system go to the webpage download it and follow the installation instructions The shown graphs in eAuctionyzer are done with Flash If it s not preinstalled go to the webpage get adobe com de flashplayer download it Adobe Flash Player for Windows Internet Explorer and install it on your computer Otherwise the graphs will not be shown 02 1 2 Operating System eAuctionyzer is tested under different Windows platforms XP Vista 7 and an operation on these systems is assured On older Windows platforms or other operating systems MAC or Linux the software is not tested and should not be used 02 1 3 Free Hard dis
62. tionyzer TraderToolRunable C FileDir Save as path D Benutzer HartliebS Desktop Select C GB File Name D iBenutzertHartliebStDesktop Files of Type All Files 03 8 Other Functionality 03 8 1 Export the Shown Tables The shown tables can be exported from the system and saved as csv file This is possible if the button Save as exists under a table or a matrix The button Save all will appear if there are more than one table selections possible By a click on the button the local file system opens and the save directory and save name can be defined Save all saves all possible tables of the view in one file Save as the one that is currently shown 03 8 2 Block Functionality In special cases some elements have to be blocked to keep the data consistent In this case the element is not editable anymore Bid scenarios have to be blocked if they are used in auction scenarios Figure 49 shows a blocked bid scenario The buttons Delete Generate and Import are not available Auction scenarios have to be blocked if there exists a sensitivity analysis for this auction scenario In both cases a copy without the Page 39 of 46 eAuctionyzer Manual corresponding elements can be applied For a bid scenario this is done by the button Duplicate see 03 3 4 and for an auction scenario with the button Save As see 03 4 1 6 Figure 49 Blocked Bid Scenario B
63. tration of a flat distribution Flat Distribution 100 80 60 Price in 40 Bid Number Normal Distribution The most likely distribution for market clearing prices is the normal distribution It allots the elements by a gaussian function The two parameters for a gaussian function are the mean and the variance The mean defines the standard price level and the variance the spreading of the elements In the bid generator the variance can be inserted relatively to the mean In that case the variance is defined by mean 1 value E g if the price level MCP mean is 100 and the inserted value is 10 then the variance is 10 100 divided by 10 That means that the most values will range between 90 and 110 68 and 95 of the values between 80 and 120 Mathematically there is no upper or lower bound Theoretically a market price can be infinity too A lower bound is defined by zero because there are no negative bids existing Figure 51 shows the schematic price levels for a normal distribution The most prices are around the center at one level On the upper and lower range of the scope there are a few extreme values Page 42 of 46 eAuctionyzer Manual Figure 51 Schematic illustration of a normal distribution Normal Distribution 140 100 1 101 201 301 401 501 601 701 801 901 Bid Number Convex Distribution A convex distribution most likely simulates a market order In that case a few bids are
64. ure 34 shows a table with all bids used in the auction see 03 4 1 2 For each bid additional to the data shown in the Bid table see 03 3 2 3 the accepted volume the market clearing price MCP and the approximated payment value is shown The payment value is calculated as MCP Accepted Volume Hours of the Product This is only an approximation For a year a standard year and not a leap year is taken and for a month a 30 days month is taken So the payment value can be imprecise The maximum deviation is 2 days in case of February and this will be 6 67 1 day of a leap year are 0 23 A detailed view on this issue is shown in the section products see 03 7 3 Figure 34 Result table view for the bids Views Bid view BID LIST PRODUCT SCENARIO SOURCE SINK REQUES CCEPTE PRICE Hor 1 DE AT CZ SK 5 0 3 06 H01 1 DEAT CZ sk 5 0 3 06 H01 1 DEAT CZSK 5 0 3 02 H01 1 DE AT CZ SK 5 0 3 02 H01 1 DEAT CZ SK 5 0 1 96 HO1 1 DE AT CZ SK 10 0 1 90 H01 1 DE AT CZ SK 5 0 1 77 H01 1 DE AT CZ SK 5 0 1 57 H01 1 DEAT CZSK 5 0 1 45 H01 1 DE AT CZ SK 5 0 1 35 H01 1 DE AT CZ SK 5 0 1 25 H01 1 DE AT CZ SK 5 0 1 15 Hor 1 DEAT CZ SK 10 0 1 07 H01 1 DE AT CZ SK 5 0 1 05 H01 1 DE_AT cz sk 85 0 0 01 Ha 1 DE AT MAVIR 10 10 19
65. very high but after the highest bids a very hard decay will occur The distribution is defined by a saddle point and a maximum The saddle point is equal to the price level and the maximum is defined as multiplier of this level E g if the price level is defined with 100 and the value for the maximum is 4 the maximum occurring price will be up to 400 4 100 The most values of this distribution will be between the saddle point an zero The upper bound of this distribution is the maximum value the lower bound is zero Figure 52 shows a schematic illustration of a convex distribution Figure 52 Schematic illustration of a convex distribution Convex Distribution Price in Concave Distribution A concave distribution has a slow decrease on the upper side of the saddle point and a fast at the lower side of the saddle point The distribution is defined by two parameters the saddle point and the maximum value The saddle point is defined by the price level and the maximum value is defined relatively to the corresponding price level price level multiplied by the value E g if the price level saddle point is defined by 100 and the maximum value is defined by 1 3 the maximum price will be 130 100 1 3 The generated prices will be between 130 and zero The most values Page 43 of 46 eAuctionyzer Manual between 130 and 100 and fewer between 100 and zero Figure 53 shows a schematic illustration of a concave distribution Figure 53 S
66. y v Hour 01 00 00 Hourl __ Hour 02 01 00 Hourh Hour 03 02 00 Hourly _ Hour 04 03 00 Hourly Hour 05 04 00 Hourly Hour 06 05 00 Hourly Hour 07 06 00 Hourly Hour 08 07 00 Hourly Hour 09 08 00 Hourly Hour 10 09 00 Hourly Hour 11 10 00 Hourly Hour 12 11 00 Hourly Hour 13 12 00 Hourly y y y y y y y y y y Hour 14 13 00 Hour Hour 15 14 00 Hour Hour 16 15 00 Hourl Hour 17 16 00 Hourl Hour 18 17 00 Hourh Hour 19 18 00 Hour Hour 20 19 00 Hour Hour 21 20 00 Hour Hour 22 21 00 Hour Hour 23 22 00 Hour H24 Hour 24 23 00 Hourly 1 MONTH 30 Days Month Yearly 720 SII IIIS IS IIT IIT IT IIS TIT IIT SRI CIC CIC ROI CIS RESI RESI RESI ROI RO 03 7 4 Predefine Import and Export Limits The import limits maybe used in auctions can be predefined at Data and I E Limits Figure 47 For each market area and import and an export limit can be defined The Page 38 of 46 eAuctionyzer Manual maximum of the limit is limite

Download Pdf Manuals

Related Search

Related Contents

Deta-Cut - Detax.de  Briggs & Stratton 8 User's Manual  User Manual of Motion Detection Clock Camera  fiche technique  ADTRAN Total Access 832 User's Manual  USANDO EL ASIENTO DE SEGURIDAD CORRECTAMENTE  

Copyright © All rights reserved. Failed to retrieve file