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

<Component>

<CustomerId>,<StartDate>,<EndDate>

***

<ReserveZoneId>

<ProductType>

<Block1>,<MW1>,<Price1>

<Block2>,<MW2>, <Price2>

. . .

<Block20>,<MW20>, <Price20>

<ProductType>

<Block1>,<MW1>,<Price1>

<Block2>,<MW2>, <Price2>

. . .

<Block20>,<MW20>, <Price20>

***

<ReserveZoneId>

<ProductType>

<Block1>,<MW1>,<Price1>

<Block2>,<MW2>, <Price2>

. . .

<Block20>,<MW20>, <Price20>

<ProductType>

<Block1>,<MW1>,<Price1>

<Block2>,<MW2>, <Price2>

. . .

<Block20>,<MW20>, <Price20>

***

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 Reserve. / Specify: Locational Forward Reserve (not case sensitive; underscore can be substituted for space) / Yes
CustomerId / Contains the identification number of the Participant for which bid data is being submitted. / Maximum length is 9 characters. / Yes
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 submitted. / Maximum length is 9 characters. / Yes
ProductType / Contains the product type of the Locational Forward Reserve market, the bid is 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. / Specify: TMNSR or TMOR (not case sensitive) / Yes
Block
(Block1 – Block20) / Contains the number of a bid block, should be a whole number from 1 to 20. Bid may be submitted with up to twenty blocks for each of TMNSR and/or TMOR reserve bid. / Specify a number: 1 to 20 / Yes
MW
(MW1 – MW20) / Contains up to twenty MW block values that may be submitted for each of TMNSR and/or TMOR reserve bid.
MW value must be >= 1. / Total length cannot exceed 10 characters, which includes 3 decimal places. / Yes
Price
(Price1 – Price20) / Contains Price values that correspond to the MW blocks above. These amounts must be in ascending order. Up to 20 different non-negative prices ($ per MW-Month) may be submitted for each of TMNSR and/or TMOR reserve bid.
Price value should not exceed the Auction Offer Price Cap. / Total length cannot exceed 10 characters, which includes 2 decimal places. / Yes

Page 14 of 14

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 “http://www.iso-ne.com/support/tech/dtd/sms/LocationalForwardReserveBid_1_0.dtd”. 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:

<?xml version="1.0" encoding="ISO-8859-1"?>

<!DOCTYPE LocationalForwardReserveBid PUBLIC '-//ISO New England, Inc//DTD LocationalForwardReserveBid Submission 1.0//EN' 'http://www.iso-ne.com/support/tech/dtd/sms/LocationalForwardReserveBid_1_0.dtd'>

Upload Type / Public Id / ISO-NE published System Id
XML Locational Forward Reserve Bid Upload / -//ISO New England, Inc//DTD LocationalForwardReserveBid Submission 1.0//EN / http://www.iso-ne.com/support/tech/dtd/sms/LocationalForwardReserveBid_1_0.dtd

XML Locational Forward Reserve Bid Upload File Example

<?xml version="1.0" encoding="ISO-8859-1" ?>

<!DOCTYPE LocationalForwardReserveBid PUBLIC '-//ISO New England, Inc//DTD LocationalForwardReserveBid Submission 1.0//EN' 'http://www.iso-ne.com/support/tech/dtd/sms/LocationalForwardReserveBid_1_0.dtd'

<LocationalForwardReserveBid Component="LOCATIONAL_FORWARD_RESERVE" >

<Auction CustomerId="6" StartDate="10/01/2004" EndDate="06/01/2005">

<ReserveZone ReserveZoneId="900">

<ProductType Type="TMNSR">

<Bid Block="1" MW="50.725" Price="20.00" />

<Bid Block="2" MW="10.000" Price="22.50" />

<Bid Block="3" MW="10.000" Price="25.0" />

<Bid Block="4" MW="20.000" Price="29.99" />

<Bid Block="5" MW="30.000" Price="32.00" />

<Bid Block="6" MW="20.000" Price="36.00" />

<Bid Block="7" MW="20.000" Price="40.00" />

<Bid Block="8" MW="10.000" Price="48.00" />

<Bid Block="9" MW="10.000" Price="48.99" />

<Bid Block="10" MW="10.000" Price="50.00" />

<Bid Block="11" MW="10" Price="51.00" />

<Bid Block="12" MW="10" Price="52.50" />

<Bid Block="13" MW="10" Price="52.99" />

<Bid Block="14" MW="10" Price="53.00" />

<Bid Block="15" MW="10" Price="55.00" />

<Bid Block="16" MW="10" Price="56.00" />

<Bid Block="17" MW="10" Price="60.00" />

<Bid Block="18" MW="10" Price="68.00" />

<Bid Block="19" MW="10" Price="68.99" />

<Bid Block="20" MW="10" Price="70.00" />

</ProductType>

<ProductType Type="TMOR">

<Bid Block="1" MW="20" Price="40.00" />

<Bid Block="2" MW="20" Price="42.50" />

<Bid Block="3" MW="20" Price="45.0" />

<Bid Block="4" MW="20" Price="49.99" />

<Bid Block="5" MW="20" Price="52.00" />

<Bid Block="6" MW="20" Price="56.00" />

<Bid Block="7" MW="20" Price="60.00" />

<Bid Block="8" MW="20" Price="68.00" />

<Bid Block="9" MW="20" Price="68.99" />

<Bid Block="10" MW="20" Price="70.00" />

<Bid Block="11" MW="10" Price="71.00" />

<Bid Block="12" MW="10" Price="72.50" />

<Bid Block="13" MW="10" Price="72.99" />

<Bid Block="14" MW="10" Price="73.00" />

<Bid Block="15" MW="10" Price="75.00" />

<Bid Block="16" MW="10" Price="76.00" />

<Bid Block="17" MW="10" Price="80.00" />

<Bid Block="18" MW="10" Price="88.00" />

<Bid Block="19" MW="10" Price="89.99" />

<Bid Block="20" MW="10" Price="90.01" />

</ProductType>

</ReserveZone>

<ReserveZone ReserveZoneId="902">

<ProductType Type="TMOR">

<Bid Block="1" MW="20" Price="40.00" />

<Bid Block="2" MW="20" Price="42.50" />

<Bid Block="3" MW="20" Price="45.0" />

<Bid Block="4" MW="20" Price="49.99" />

<Bid Block="5" MW="20" Price="52.00" />

<Bid Block="6" MW="20" Price="56.00" />

<Bid Block="7" MW="20" Price="60.00" />

<Bid Block="8" MW="20" Price="68.00" />

<Bid Block="9" MW="20" Price="68.99" />

<Bid Block="10" MW="20" Price="70.00" />

</ProductType>

</ReserveZone>

<ReserveZone ReserveZoneId="903">

<ProductType Type="TMOR">

<Bid Block="1" MW="20" Price="40.00" />

<Bid Block="2" MW="20" Price="42.50" />

<Bid Block="3" MW="20" Price="45.0" />

<Bid Block="4" MW="20" Price="49.99" />

<Bid Block="5" MW="20" Price="52.00" />

<Bid Block="6" MW="20" Price="56.00" />

<Bid Block="7" MW="20" Price="60.00" />

<Bid Block="8" MW="20" Price="68.00" />

<Bid Block="9" MW="20" Price="68.99" />

<Bid Block="10" MW="20" Price="70.00" />

</ProductType>

</ReserveZone>

</Auction>

</FrBid>

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 should be: LOCATIONAL_FORWARD_RESERVE. / Specify: LOCATIONAL_FORWARD_RESERVE (case sensitive) / Yes
ELEMENT Auction
CustomerId / Contains the identification number of the Participant for which bid data is being submitted. / Maximum length is 9 characters. / Yes
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 submitted. / Maximum length is 9 characters. / Yes
ELEMENT ProductType
Type / Contains the product type of the Locational Forward Reserve market, the bid is 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. / Specify: TMNSR or TMOR (not case sensitive) / Yes
ELEMENT Bid
Block / Contains the number of a bid block. Block should be a whole number from 1 to 20. Bid may be submitted with up to twenty blocks for each of TMNSR and/or TMOR reserve bid. / Specify a number: 1 to 20 / Yes
MW / Contains up to twenty MW block values that may be submitted for each of TMNSR and/or TMOR reserve bid.
MW value must be >= 1. / Total length cannot exceed 10 characters, which includes 3 decimal places. / Yes
Price / Contains Price values that correspond to the MW blocks above. These amounts must be in ascending order. Up to 20 different non-negative prices ($ per MW-Month) may be submitted for each of TMNSR and/or TMOR reserve bid.
Price value cannot exceed the Auction Offer Price Cap. / Total length cannot exceed 10 characters, which includes 2 decimal places. / Yes

Page 14 of 14