Import anticipated costs using a Microsoft Excel file
To import anticipated costs from Microsoft Excel, you must select the Itemized Breakdown method of documenting anticipated costs in Settings > Feature Settings > Procurement.
If you change the method of documenting anticipated costs, any existing anticipated costs will be deleted.
Prepare a Microsoft Excel file for import
- Open a blank Microsoft Excel spreadsheet or download the sample file.
- Label the first row, which specifies the column names, as shown in the table below.
Make sure that all the required fields are included. Field names do not contain any spacing within the word, or before and after.
Make sure that the sheet is labeled as Sheet1.
- Start entering data from the second row.
- Save the file in Excel 97-2003 format (*.xls).
- Close the file to enable Sage Construction Management to import the data.
Import the file
- Go to Projects and select the project in the Quick Select section.
- On the Project Home page, select Procurement Overview under the Procurement section.
- In the Procurement Stats - Forecasted Costs and Out to Bid section, select the three dots menu at the end of the Anticipated Costs row and select Import From Excel.
- Optional: To update the pricing of imported items if their item code matches the code in the local work item database, select the respective option.
- Select Choose File and find the file to be imported on your local drive.
The data will be imported automatically.
Microsoft Excel import sample
Anticipated costs sample file.
Anticipated costs file fields
| Column name / First row | Required (*) | Field Type | Comments |
| PrimeContractNumber | * | Text | The prime contract number must exist in Sage Construction Management before importing. |
| ItemCode | Text | Optional: Sage Construction Management will check the work items table based on the ItemCode field. If an item exists, then the work item's total cost rate can be used as the anticipated cost item's unit price. | |
| ItemDescription | * | Text | |
| ItemUnit | * | Text | |
| ItemQuantity | * | Number | |
| ItemUnitPrice | * | Number | |
| ItemResource | * | Text |
Options: M, L, E, S, O
If the field id not specified, the default value is M. |
| ItemCostCode | * | Text | The job cost code must exist in Sage Construction Management before importing. |
| ItemEstimatedDate | Date |
Estimated date. Recommended date format: DD-MMM-YYYY (example: 15-Oct-2023) US supported format: MM-DD-YYYY (example: 10/15/2023) ISO supported format: YYYY-MM-DD (example: 2023-10-15) |