Uploading Variations from a CSV
To upload a variation from a CSV file:
- Navigate to the Variations Page
- From the My Contract menu at the top of any project page, select the My Variations link.
- If you are a Prime Subcontractor with an on-system Sub-Tier Subcontractor working for you, select the Subcontract Variations link from the Subcontracts menu at the top of any page to go to the Subcontract Variations tab of the Variations page. You can only access the page in this way if you have Sub-Tiers with a contract on the application.
- 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.
- 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.
- 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.
Last Published Monday, February 5, 2024