Workflows / Schedules and quantities, live from the model
Schedules and quantities, live from the model
Door, window, room and quantity schedules read live from the BIM model: type in a cell and the model changes, add formulas, filters, charts and cross tables, and round trip any schedule through Excel.
- Available
- Free account
What it is
A schedule in Calq is the model's data, live. It is not a table exported once and left to go stale: every row stands for elements of the model, every figure is read from them when you look, and a value you type goes back into the model as one undoable step.
One definition lays the schedule out on the board and on a sheet, so what you print is what you edited.
What a schedule can do
- Fields with their own heading, unit, decimals and total
- Formulas between fields
- Filters on all or any condition, sorts with headers, footers and blank lines
- Pick lists in a cell: the Type column offers the model's types, then the catalogue's
- Fields of another element found by geometry, such as the room a door opens from
- Several kinds of element in one schedule, type schedules and key schedules
- Charts and cross tables kept with the schedule and drawn on the sheet too
How it goes
- Open a schedule of doors, windows, rooms or any kind, or start from a template
- Choose the fields, filter and sort
- Type, paste or pick values in the cells: the model follows, and a cell that cannot be written says why
- Select rows to see them in the model, or open a 3D view of just those rows
- Place the schedule on a sheet, or save it as Excel
Excel and back
Every schedule saves as an Excel workbook with a Calq Id column that carries what each row stands for. Edit the sheet and bring it back, as Excel or CSV: each row finds its elements, a cell that differs is written, one that does not is left, and what cannot be written comes back listed with its reason.
A measured column, such as a length or an area, is never overwritten from a sheet: the model is what is measured.
Columns Calq measures for you
- Model check: the faults the model check finds on each row
- Brief: each room against its line of the programme
- Information need: each element against the IDS requirements you loaded
- Cost from a rate you give, and carbon in kgCO2e from the element's materials
- Colours: a column's values shown as tones on the plan and in 3D
Quantities, numbering and issues
Quantities are taken off the model's own geometry: lengths, areas, volumes and counts by type, as a schedule like any other. A schedule can be compared with a past state of the model to show what changed. Doors and rooms are renumbered in one step, and rows with a problem become BCF issues for the team.
Good to know
Schedules, the Excel round trip and quantities are on the free account. A cost is only as good as the rate behind it: Calq multiplies your rate by what it measured and names where a published figure comes from. Calq AI and a connected MCP assistant edit schedules and set their values with the same write-back.
Questions
Can I edit a BIM schedule and have the model update?
Yes. In Calq a value typed, pasted or picked in a schedule cell is written into the model as one undoable step, and a cell that cannot be written says why.
Can I export a schedule to Excel and import it back?
Yes. Every schedule saves as Excel with a Calq Id column, and the edited sheet comes back as Excel or CSV: changed cells are written, and what is refused is listed with its reason.
Does Calq do quantity takeoff?
Yes. Lengths, areas, volumes and counts are measured from the model's geometry by type, on the free account, and export to Excel.
Can a schedule use formulas?
Yes. A field can be a formula over other fields, with its own unit, decimals and total.
Can I put charts on a sheet?
Yes. A chart is kept with its schedule, such as a column, bar, donut or treemap chart, and the same drawing appears on the board and on the sheet.
Are schedules free in Calq?
Yes. Schedules, quantities and the Excel round trip are on the free account.