The Quantity Table
The quantity table is the central output of every takeoff in Sparkel. It's where items (rows) live, where quantities are displayed, and where you organise the work before exporting or sending to a supplier. Understanding how it's structured — and how it differs from a standard BIM schedule — is key to using Sparkel efficiently.
How it differs from a BIM schedule
A BIM schedule (in Revit, Navisworks, or Solibri) is generated from the model. The tool reads the model's elements and their properties, and produces a list. You get what the model gives you.
Sparkel's quantity table is the opposite: you define the rows, then populate them. You create an item for "External concrete walls C30", link the relevant elements, and the quantity fills in. The structure of the table reflects your commercial intent — not the model's classification system.
This distinction matters most when models are incomplete or inconsistently modelled, which is the norm rather than the exception on most projects.
Items and units
Each row in the table is an item with:
A name you define
A unit of measurement (m², m³, m, pcs, kg, etc.)
A quantity, calculated from linked elements or shapes
A count of linked elements or shapes
You can edit item names and units at any time. Changing a unit will recalculate the quantity based on the same linked geometry.
Creating and editing items
In the Resources panel, click + New Resource.
Enter a name and select a unit.
Click the blue checkmark to save.
To edit, click the pencil icon on the item row.
To delete, select the item and click the red trash icon. Note: deleted items cannot be restored.
Dynamic quantities
Dynamic quantities let you define a formula for an item's quantity rather than reading it directly from geometry. For example, you can multiply a linked element's volume by a material density to get weight in kg, or add a percentage waste factor to a measured area. This is configured per item and makes the table directly usable for procurement without a separate calculation step. This capability works alongside BIM linking — you link the elements, then the formula transforms the raw geometric value into the quantity you actually need.
Grouping and labels
Use labels to group items by phase, zone, subcontractor package, or any other category that makes sense for your project. Labels filter the table view and control which items are included in an Excel export or a supplier order.
Visual traceability
Every item in the table is visually traceable — click any item to see its linked elements or shapes highlighted in the viewer. This is what makes Sparkel quantities verifiable. You're never looking at a number without being able to see exactly what generated it.