ICAP Bid Upload File Format - ISO New England



[pic]

ISO New England Inc.

Locational Forward Reserve Bid Upload File Formats

SMS Locational Forward Reserve Bid File Upload Tracking Table

|Ref Number |Change |Updated By |Date |

|1 |Created for July 2005 Release |A. Tosenko |08/24/04 |

|2 |Modified for 2006 Release: removed Auction Id, Resource Type, Combined MW |A. Tosenko |01/12/06 |

|3 |Updated URL on the XML file |A. Tosenko |09/28/06 |

| | | | |

| | | | |

| | | | |

Table of Contents

CSV File Format 4

Locational Forward Reserve Bid Upload File Format 4

Locational Forward Reserve Bid Upload File Example 5

Locational Forward Reserve Bid Upload File Definitions 8

XML File Format 10

XML Locational Forward Reserve Bid Upload File Format 10

XML Locational Forward Reserve Bid Upload File Example 11

XML Locational Forward Reserve Upload File Definitions 14

CSV File Format

Locational Forward Reserve Bid Upload File Format

,,

***

,,

,,

. . .

,,

,,

,,

. . .

,,

***

,,

,,

. . .

,,

,,

,,

. . .

,,

***

Locational Forward Reserve Bid Upload File Example

Locational Forward Reserve

6,10/01/2004,06/01/2005

***

900

TMNSR

1,50.725,20.00

2,10.000,22.50

3,10.000,25.00

4,20.000,29.99

5,30.000,32.00

6,20.000,36.00

7,20.000,40.00

8,10.000,48.00

9,10.000,48.99

10,10.000,50.00

11,20,51.00

12,20,52.50

13,20,55.00

14,20,59.99

15,20,62.00

16,20,66.00

17,20,70.00

18,20,78.00

19,20,78.99

20,20,80.00

TMOR

1,50.000,20.00

2,10.000,22.50

3,10.000,25.00

4,20.000,29.99

5,30.000,32.00

6,20.000,36.00

7,20.000,40.00

8,10.000,48.00

9,10.000,48.99

10,10.000,50.00

11,10,51.00

12,10,52.50

13,10,55.00

14,10,59.99

15,10,62.00

16,10,66.00

17,10,70.00

18,10,78.00

19,10,78.99

20,10,80.00

***

901

TMOR

1,50.000,20.00

2,10.000,22.50

3,10.000,25.00

4,20.000,29.99

5,30.000,32.00

6,20.000,36.00

7,20.000,40.00

8,10.000,48.00

9,10.000,48.99

10,10.000,50.00

11,10,51.00

12,10,52.50

13,10,55.00

14,10,59.99

15,10,62.00

16,10,66.00

17,10,70.00

18,10,78.00

19,10,78.99

20,10,80.00

***

902

TMOR

1,20,40.00

2,20,42.50

3,20,45.00

4,20,49.99

5,20,52.00

6,20,56.00

7,20,60.00

8,20,68.00

9,20,68.99

10,20,70.00

11,20.00

12,10.000,122.50

13,10.000,125.00

14,20.000,129.99

15,30.000,132.00

16,20.000,136.00

17,20.000,140.00

18,10.000,148.00

19,10.000,148.99

20,10.000,150.00

CSV Locational Forward Reserve Bid Upload File Definitions

|Field |Description |Format |Required |

|Component |Defines the type of upload file. In this case, the type should be: Locational Forward|Specify: Locational Forward Reserve (not case sensitive; |Yes |

| |Reserve. |underscore can be substituted for space) | |

| | | | |

|CustomerId |Contains the identification number of the Participant for which bid data is being |Maximum length is 9 characters. |Yes |

| |submitted. | | |

| | | | |

| | | | |

|StartDate |Contains the Auction Service Period Start Date. |MM/DD/YYYY |Yes |

|EndDate |Contains the Auction Service Period End Date. |MM/DD/YYYY |Yes |

| | | | |

|Reserve Zone delimiter |Contains the delimiter that indicates the beginning of a Reserve Zone bid data. |Specify : *** |Yes |

| | | | |

|ReserveZoneId |Contains unique identification number of the reserve zone for which bid data is being |Maximum length is 9 characters. |Yes |

| |submitted. | | |

| | | | |

| | | | |

|ProductType |Contains the product type of the Locational Forward Reserve market, the bid is |Specify: TMNSR or TMOR (not case sensitive) |Yes |

| |submitted for. The type should be TMNSR or TMOR. A bid may be submitted for one of or | | |

| |both TMNSR and TMOR reserve product at any Reserve Zone. | | |

| | | | |

|Block |Contains the number of a bid block, should be a whole number from 1 to 20. Bid may be |Specify a number: 1 to 20 |Yes |

|(Block1 – Block20) |submitted with up to twenty blocks for each of TMNSR and/or TMOR reserve bid. | | |

|MW |Contains up to twenty MW block values that may be submitted for each of TMNSR and/or |Total length cannot exceed 10 characters, which includes 3|Yes |

|(MW1 – MW20) |TMOR reserve bid. |decimal places. | |

| |MW value must be >= 1. | | |

|Price |Contains Price values that correspond to the MW blocks above. These amounts must be |Total length cannot exceed 10 characters, which includes 2|Yes |

|(Price1 – Price20) |in ascending order. Up to 20 different non-negative prices ($ per MW-Month) may be |decimal places. | |

| |submitted for each of TMNSR and/or TMOR reserve bid. | | |

| |Price value should not exceed the Auction Offer Price Cap. | | |

XML File Format

The following table contains the “Public Id” and “System Id” for Locational Forward Reserve Bid upload file.

The “Public Id” is a unique name describing the file format. When a customer uploads a file to a system at ISO-NE, the system recognizes the file format based on the Public Id.

The “System Id” is a URL where the file format itself can be retrieved. Anyone may download the file format from the System Id URL and read it. For instance, the file format for XML Locational Forward Reserve Bid Upload may be read in a web browser like Internet Explorer by opening the URL “”. The System Id has other purposes as well. When a customer views an upload file in a tool like Internet Explorer, the tool uses the System Id to download the file format and process the upload file for display.

Every XML upload file is expected to start with two lines: the XML line, and a DOCTYPE line with the Public Id and the System Id. For instance, an XML Locational Forward Reserve Bid Upload file must begin with these two lines:

|Upload Type |Public Id |ISO-NE published System Id |

|XML Locational Forward Reserve Bid|-//ISO New England, Inc//DTD LocationalForwardReserveBid Submission | |

|Upload |1.0//EN | |

XML Locational Forward Reserve Bid Upload File Example

XML Locational Forward Reserve Bid Upload File Definitions

|Attribute |Description |Format |Required |

|ELEMENT LocationalForwardReserveBid |

|Component |Defines the component where the uploaded file belongs. In this case, the component |Specify: LOCATIONAL_FORWARD_RESERVE (case |Yes |

| |should be: LOCATIONAL_FORWARD_RESERVE. |sensitive) | |

|ELEMENT Auction |

|CustomerId |Contains the identification number of the Participant for which bid data is being |Maximum length is 9 characters. |Yes |

| |submitted. | | |

| | | | |

| | | | |

|StartDate |Contains the Auction Service Period Start Date. |MM/DD/YYYY |Yes |

|EndDate |Contains the Auction Service Period End Date. |MM/DD/YYYY |Yes |

|ELEMENT ReserveZone |

|ReserveZoneId |Contains unique identification number of the reserve zone for which bid data is being |Maximum length is 9 characters. |Yes |

| |submitted. | | |

| | | | |

|ELEMENT ProductType |

|Type |Contains the product type of the Locational Forward Reserve market, the bid is |Specify: TMNSR or TMOR (not case sensitive) |Yes |

| |submitted for. The type should be TMNSR or TMOR. A bid may be submitted for one of or | | |

| |both TMNSR and TMOR reserve at any Reserve Zone. | | |

|ELEMENT Bid |

|Block |Contains the number of a bid block. Block should be a whole number from 1 to 20. Bid |Specify a number: 1 to 20 |Yes |

| |may be submitted with up to twenty blocks for each of TMNSR and/or TMOR reserve bid. | | |

|MW |Contains up to twenty MW block values that may be submitted for each of TMNSR and/or |Total length cannot exceed 10 characters, which |Yes |

| |TMOR reserve bid. |includes 3 decimal places. | |

| |MW value must be >= 1. | | |

|Price |Contains Price values that correspond to the MW blocks above. These amounts must be |Total length cannot exceed 10 characters, which |Yes |

| |in ascending order. Up to 20 different non-negative prices ($ per MW-Month) may be |includes 2 decimal places. | |

| |submitted for each of TMNSR and/or TMOR reserve bid. | | |

| |Price value cannot exceed the Auction Offer Price Cap. | | |

................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download