How to fill the rate sheet

Explaining how to fill the rate sheet with your data.

Please find some general rules below on how to work with the rate sheet:

  • Do not modify the Rate Structure, or shuffle columns and rows around.
  • No entry should be made in the grey cells. These are "read only" and only for your information
  • Yellow cells are mandatory fields. An entry will be required in those fields otherwise the system will mark this as error.
  • White cells are optional fields. You are not required to add any information in those fields but you are free to do so.

  • Please pay attention to the tender instructions as the customer might have given customer specific validation rules
  • Columns can contain additional comments to clarify what is required. Put your mouse cursor over the excel column header to see the comments.

Important: The IDs in the first column must be matching with the ones in the downloaded rate sheet. Otherwise the system will not recognize the document as a rate sheet.