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 3DTools ▸ SOQ opens the schedule in a pane.

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

  • 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 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 (bulking factor, topsoil depths, stockpiling) are the same.

Settings that change the schedule

Setting

What it changes

Bulking factor, 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?