Uploading Variations from a CSV

To upload a variation from a CSV file:

  1. Navigate to the Variations Page
  2. Select the Download Sample CSV link to download a template of the format your variations must follow.

    If your variations are recorded in another Excel workbook, simply copy and paste the data into the template.

  3. Complete the following:
    • Number: Your internal variation number
    • Title: A heading to identify the variation
    • Budget Amount: The total value of the variation
    • Description: A summary of the works/materials covered by the variation
    • Optional. Work Started: Indicates whether the corresponding works have commenced
    • Optional. Proceed Date: Indicates the starting date of the works. A proceed date is required if the Work Started field is marked as Y.

      You will need to complete all required fields in a row that has data in it – the system will not accept files with incomplete records. When complete, save the file as a CSV to your computer.

      Note: Do not add dollar signs ($) or special characters to the Budget Amount column. Doing so will result in an error when uploading the file.

  4. Select Choose File to browse your computer for the saved CSV. Open the file from the explorer window and select Upload New from CSV. Your variations will automatically fill in the Request Variation page, ready to be submitted.

    See Request Variations Tab.