What the schedule of rates is
The schedule of rates (SOR) is a hierarchical breakdown of all priced items in a project. It defines the items, quantities, and rates that feed into Applications and Variations. Items are arranged in the estimate's sections, in a tree of parent sections and child items.
Viewing the schedule of rates
- 1
Open a project and click Budgets in the project sidebar.
- 2
Click View Schedule of Rates in the page header.
- 3
Expand and collapse sections to navigate the hierarchy, or click Expand All to open every section.
The table has these columns:
| Column | What it shows |
|---|---|
| Description | The section or item description |
| Size | The item's size |
| Cost Code | The cost code the line belongs to |
| Quantity | The quantity |
| Rate | The rate per unit |
| Total | The line total |
Ductwork and insulation jobs also show Specification and Definition columns.
Filtering by cost code
Use the Cost Code filter above the table to narrow the view to a specific cost code. This is useful on large projects with many sections.
Changing a line's cost code
If you have permission to edit the schedule of rates, you can move a line to a different cost code.
- 1
Click the cost code on the line you want to change. The Update Cost Code dialog opens.
- 2
Select the new cost code from the dropdown.
- 3
Click Update.
Reports and exports
- Generate Report — in the page header, creates a schedule of rates report.
- View Budgets — in the page header, takes you back to the Budgets page.
- Export — tick lines in the table, then click Export to download them as a CSV file, listed A to Z.
How the schedule of rates connects to other modules
The SOR feeds data into several project modules:
- Applications — when creating an Application, you claim quantities against SOR line items.
- Variations — Variation items can be added from or omitted from the SOR.
- Budgets — cost-code budgets come from the Buying List imported with the estimate.
- Buying list — imported alongside the schedule of rates. It is the list you order from.
Importing a schedule of rates
Until a schedule of rates has been imported, the project's Project Dashboard shows an Import a Project card. Drop your Ensign Estimate (.zip) or your Excel file on it. Excel files open in the Import Wizard. For an Ensign Estimate, see Importing an Ensign Estimate.
Next steps
- Import Wizard — import cost codes, buying lists, and schedules of rates.
- Budgets — view budget analysis by cost code.
- The Project Dashboard — see the project's figures once the schedule of rates is imported.