Upload xlsx-template

This page describes the format and structure of the dispoGas upload xlsx format and template.

Generate upload template from dispoGas

You can easily create your dispoGas upload xlsx template by performing the following 3 steps:

1. In your dispoGas app, go to the Nomination View
2. Select “Export xlsx"
   1. This will save a csv document in your default download folder. This file contains all the nomination tracks with their external ids for the selected day, with their current values and nicely formatted column labels.
3. Open the created file

tip

This is it. You already have your fully working upload template, which you can use directly for uploading position to dispoGas via the UI or automated file upload.

Template description

File type and sheet name

The xlsx template definition for the upload is very simple and straight forward.

1. Your excel file must have an .xlsx extension
2. Your upload data must be stored in a sheet, which has the string gasday (not case sensitive) in its sheet name.
   1. Valid Sheetnames (examples):
      1. 20230607GasDayImport
      2. Dayahead_gasday
      3. GASDAY_IMPORT
3. If your excel file contains multiple sheets with the term gasday in their names, all of those sheets will be imported.
4. Sheets which don't match this criteria will be ignored during the import.

Sheet structure

Each imported sheet must have the following structure, starting with Cell A1:

• 📅Gasday: Date of the Gasday the values are valid for in format: dd.MM.YYYY
• 🆔External Reference: Unique reference per row, which is used to identify the correct nomination track. The reference is configured in the nomination Track definition of the Message definition screen and can be adjusted to your external IDs. We recommend following the Nomination Track External ID Naming Convention though.
• 📈Quantities (e.g. 06:00-07:00):
  • Provide all positions in MWh
  • Use . (dot) as a comma separator if you nominate also kWh
  • Use positive values if you
    • Buy gas at a VTP or similar point
    • Nominate an Entry at an interconnection point (IP)
    • Withdraw gas from storage
  • Use negative values if you
    • Sell gas at a VTP or similar point
    • Nominate an Exit at an interconnection point (IP)
    • Inject gas into storage
  • One row can have positive and negative values in the different hours. Do not split one row into two for buy and sell.
  • For daily granularity use only the first hourly column
  • You can have both hourly and daily granularity rows in one sheet

The uploaded values can be both fixed or formula based, dispoGas will upload regardless.

Floating point problems with Excel formulas

When using formulas for calculating the quantities in your upload excel, please add rounding to 3 digits to your Excel formulas. If you don't, it is possible that uploaded values in dispoGas will differ from the results you see in Excel. This can happen due to floating point arithmetic issues in Excel itself.

Daylight Saving handling

Ideally you will use templates with 25 hours for the daylightsaving on last Saturday (Gasday) in October (long day) and with 23 hours during daylightsaving switch back to summer time on the last Saturday (Gasday) in March (short day). You can extract these formats directly from dispoGas if you select the respective days before you export them:

Long Day: On last Saturday (Gasday) in October: Please provide 25 hourly value columns. The column for extra hour must be entered chronologically between 01:00-02:00 and 02:00-03:00. In our example this hour has the label: 02:00-02:00.

Short Day: On last Saturday (Gasday) in March: Please provide 23 hourly value columns. Please merge the columns from 01:00-02:00 and 02:00-03:00 to a single column. In our examples we show this column with the label 01:00-03:00.

info

dispoGas has a setting, which explicitly allows imports of 24 hour templates on 25/23 hours days.

• If set to false, dispoGas will fully reject the import of a file with 24 timestamps on such a day.
• If set to true, dispoGas will import and
  • Long day: The value provided of hour 02:00 - 03:00 is also used for the extra hour
  • Short day: The value provide for hour 02:00 - 03:00 will be ignored

The User is warned with during the import about this: