Skip to main content

Interpreting Schedule of Quantities table data

Information explaining the SoQ table and how to interpret it

Written by Allsite Support

Every Level AI run produces a schedule of quantities (SoQ): the whole job priced as work items — earthworks, retaining, roading, drainage, water supply, landscaping and the preliminary and general items — one row per item of work.

Where to find it

  • In Civil 3D — Tools ▸ SOQ opens the schedule in a pane.

The Tools panel of the Allsite.ai ribbon with the Tools dropdown open. The menu lists Cut/Fill Qty, SOQ, Lot Report, Road Report and Zoom EW Extent; SOQ is outlined.

  • In the Allsite.ai web app — Design ▸ Design data ▸ Schedule of Quantities, for the project's latest run.

The Allsite.ai web app sidebar for a project. The Design group is expanded, and inside it Design data lists Cutfill, Schedule of Quantities, Lot report, Road report, Storm capacity and Sanitary capacity. Schedule of Quantities is outlined.

  • As a CSV — the download button in the pane saves the schedule for the latest Level AI run to your Downloads folder, ready to drop into a cost estimate.

The Schedule of Quantities page in dark mode. Three filters (Category, Sub category and Stage) sit above a table with the columns Category, Sub category, Stage, Quantity with its unit, Option and Description. Rows cover topsoil, bulk earthworks, winter earthworks, retaining walls, stormwater pipes and manholes, and carriageways.

The Schedule of Quantities page. Numbered markers: 1 Category, 2 Sub category, 3 Stage, 4 Quantity with its unit, 5 Option, 6 Description. The three filters above the table narrow it by Category, Sub category and Stage.

The columns

Column

What it is

Category

The section of works: Establishment, Demolition, Contamination, Sediment, Earthworks, Retaining, Roading Public, Roading Private, Water Supply, Stormwater, Wastewater, Landscaping, Services, Contributions. Rows are ordered in that sequence.

Sub Category

The trade grouping within the category — Topsoil, Bulk Earthworks, Service Trenches, Retaining Walls, Pipes, Manholes, Carriageways, Footpaths, Driveways, Marking and Signage, and so on.

Stage

The construction stage the item belongs to. 0 means the item is not staged.

Option

The column that catches people out. An option is an alternative way of doing the same work, not extra work. Blank means the base case. See below.

Sort

A sort key only. It is a large computed number that puts the rows in a sensible order (category, then sub-category, type, material, size and depth). It is not a quantity, a price or a code — ignore it.

Units

The unit for that row — yd³/m³, yd²/m², ft/m, each, item. The schedule mixes units, so it is always read per row.

Description

The item of work as it would read in a tender document, including what the rate is deemed to cover ("including handling, spreading, compacting in layers etc.").

Quantity

The measured quantity in that row's units.

Options: do not add them up

Rows that share a category, sub-category and description but differ in Option are alternatives. Summing the Quantity column over a whole category without looking at Option will double- or triple-count the work.

Two examples you will see on most projects:

  • Topsoil options — Topsoil - Import, Topsoil - Place, Topsoil - Screen, Topsoil - Screen - Place, Topsoil - Waste, Topsoil - Sold. These are the different ways of dealing with the same topsoil. Pick the one that matches how the job will actually be run.

  • Winter Earthworks — these rows are an adjustment to the base earthworks for working in wet conditions, using the winter unsuitable and lime-stabilisation percentages from your settings. They are the difference from the base case, so some of them are negative: less cut goes straight to fill, and more goes to stockpile, lime stabilisation or waste. Add them to the base rows only if the earthworks are being priced as a winter job.

What gets measured

  • Proposed work is measured. Items marked to be abandoned or removed are measured too, as removal items ("Remove Existing").

  • Existing features that stay as they are do not appear — there is nothing to price.

  • Earthworks quantities are the same ones reported in the cut/fill table, expressed as priced items. If a volume looks wrong, check it there first — the settings that drive it (cut and fill factors, topsoil depths, stockpiling) are the same.

Settings that change the schedule

Setting

What it changes

Cut and fill factors, topsoil depths, topsoil stockpiling

Every earthworks and topsoil quantity, exactly as in the cut/fill table.

Pavement structures and road types

The roading layer rows — surface, basecourse, sub-base, stabilisation, geogrid and coatings are measured from the pavement structure assigned to each road.

Staging

Splits the schedule by stage, so each stage can be priced on its own.

Common questions

Why is the same description in the schedule more than once?
Check the Option and Stage columns. Different options are alternatives; different stages are separate parcels of work.

Why is a quantity negative?
Adjustment rows can be negative — most often the Winter Earthworks rows, which are the difference from the base case rather than a standalone quantity.

What is the huge number in the Sort column?
A sort key, nothing more. It orders the schedule the way an estimator expects to read it.

Can I total the Quantity column?
Only within one set of units, and only after choosing between the options. Totalling a whole category across yd³, yd² and ft adds unlike things together.

Something is described as "Unknown".
That means an object in the model has a type, material or size the schedule does not recognise, and it is also raised as a review item on the run. Fix the object's attributes and re-run.

The cut/fill table reports the earthworks volumes per earthworks area behind these quantities: Tools ▸ Cut/Fill Qty in Civil 3D, or Design ▸ Design data ▸ Cutfill in the web app. Contact the Allsite.ai support team if a quantity does not look right for your site.

Did this answer your question?