Preparing a bid or offer file

To prepare a Bid See Relevant Rules or Procedures or Offer Energy, Dispatch, FCAS Offer, MNSP, MTPASA Bid or Offer submission File, you can create it from scratch or you can export an existing Bid or Offer and change the data, copy, pasting, and editing rows to add more Bids or Offers to your file. Exporting an existing Bid or Offer is the easiest option. For help, see Exporting Bids and Offers.

It is important to maintain the Bid File structure, matching the columns (including the blank ones). Each column is a vital placeholder and without them, the SRA system cannot read your file. Extra columns in files also cause rejection of the file.

Csv file structure

Bid file

The table below explains the data in the Bid File See Relevant Rules or Procedures. You must include the mandatory data identified in the first column with an asterisk (*), otherwise your Bid File is not valid and is not accepted (do not include the asterisk in your file).

Column or Label

SRA Enter Bid field

Comments

COLUMN A*

n/a

C or D in column A indicates you can change data in the row – all data must be in upper case.

I in column A indicates a data structure; do not change data in the row – all data must be in upper case.

NEM*

n/a

Do not change – must be in upper case.

SRBID*

n/a

Do not change – must be in upper case.

PARTID

n/a

Enter your Participant ID in upper case

NEMMCO*

n/a

Do not change – must be in upper case.

FILE DATE AND TIME

n/a

Enter the file date and time. For SRA Web Portal uploads, the system enters the correct date and time on file upload.

COLUMN D*

n/a

Always 2 (file version number), do not change or your file will be rejected.

SETTLEMENT RESIDUE BID*

n/a

Do not change – must be in upper case.

For Auction Id, <AuctionID>

n/a

Enter the Auction ID. For SRA Web Portal uploads, the system enters the correct date and time on file upload.

RESIDUE_PRICE_BID*

Bid ID/Price

Indicates data in the row are the Bid ID and Price. The Option ID in this row must match the Option ID in the relevant RESIDUE_FUNDS_BID row. For example, in the spreadsheet example on page Page 1, the Option 1 bid price is 10 and the corresponding Tranche, Directional Interconnector, From Region and Units are: C2010Q3T04, NSW1-QLD1, NSW1, 100.

RESIDUE_FUNDS_BID*

Tranche, Directional Interconnector, Units

Indicates data in the row are the details for the Tranche, Directional Interconnector, From Region and Units. See the comments in RESIDUE_PRICE_BID.

AUCTIONID

Auction ID

Enter the Auction ID. For SRA Web Portal uploads, the system enters the correct date and time on file upload.

OPTIONID*

Bid ID/Price

Required, enter the Bid ID number.

BIDPRICE*

Bid ID/Price

Required; enter your Bid Price.

CONTRACTID*

Tranche

Required; enter the Tranche ID.

INTERCONNECTORID*

Directional Interconnector

Required; enter the Directional Interconnector.

REGIONID*

Directional Interconnector

Required, enter the Region ID.

UNITS*

Units

Required, enter the units you are bidding.

Creating a bid spreadsheet

Creating a bid plain text file