Hardware tally

Check material quantities and cable lengths in your Condui project. Export the hardware tally to Excel or CSV with ETIM classifications or as a Robaws bill of quantities.

:ui-icon[tally] Hardware tally counts the items in your project and exports them to Excel or CSV, with optional ETIM classifications or a Robaws bill of quantities. Export is available in the hosted editor and Community Edition, without a Premium project.

Material list grouped by type

Check the quantities

  1. Open :ui-icon[tally] Hardware tally at the top of the editor.
  2. Expand the categories and compare quantities with the one-wire diagram and situation plan.
  3. Correct missing or duplicate items and multipliers in :ui-icon[properties] Properties.

The count follows electrical project objects. Text and background images are excluded; several plan placements of the same object do not automatically mean extra material.

Export to Excel or CSV

  1. Open :ui-icon[menu] Menu > Export > Material list. You can also search for Export material list with Ctrl/Cmd+K.
  2. Set Preset to Standard.
  3. Set File format to Excel (.xlsx) or CSV (.csv).
  4. Select the required Categories. The preview shows the selected groups, quantities and units.
  5. Check Skip items in the grid panel. It is enabled by default; disable it to include these items.
  6. Check the cable options below and click Export.

The file contains one row per material group, with category, description, quantity, unit and details. Components are counted in pieces, cables in metres. Open the downloaded file and check the totals before ordering or preparing a quotation.

Cable lengths, margin and rounding

Cable margin (%) defaults to 30% and accepts any valid percentage from 0 upwards. Condui first totals the known lengths per cable group, then applies the margin. Round cable lengths up to whole metres rounds that result upwards to whole metres. Without this option, exports use at most two decimal places. For example, 10.2 m with 30% margin becomes 13.26 m, or 14 m with rounding.

In the editor with cable routes enabled, turn on Include plan-based cable estimates to include calculated plan lengths. This option is enabled by default; these groups show Estimated length in their details. Without cable routes, the option is hidden. Check the plan scale and routes and treat the lengths as estimates.

A cable run without a length is omitted, rather than counted as one piece. If only some lengths in a group are known, Condui exports the known total marked Partial length. Complete the missing lengths in the project and export again. Cable options are disabled when no cable category is selected.

Export with ETIM classifications

ETIM assigns standard codes to technical product types and properties. The ETIM preset adds these classifications to your material list.

  1. Open Menu > Export > Material list, or search for ETIM with Ctrl/Cmd+K and open Export material list.
  2. Set Preset to ETIM.
  3. Set File format to Excel (.xlsx) or CSV (.csv).
  4. Check the categories, cable margin and preview, then click Export.

Quantities, units and cable options work as they do with Standard. Six columns are added:

ColumnMeaning
ETIM releaseThe classification release used, currently 10.0.
ETIM classThe product class, for example EC000042 for a miniature circuit breaker (MCB).
ETIM class nameThe official English name of the class.
ETIM class versionThe version of that class within the ETIM release.
ETIM properties (JSON)Known properties using EF codes and, where needed, EV codes for enumerated values.
ETIM sourceAttribution to ETIM International and the licence.

For a miniature circuit breaker, {"EF000227":16} means a rated current of 16 A. Numeric properties use the unit defined by the ETIM class: a residual-current sensitivity of 30 mA is stored there as 0.03 A. This JSON column is intended for further data processing.

Condui classifies items including circuit breakers, residual-current devices, ordinary socket outlets, switches, electricity meters and selected cable types. Unknown or ambiguous items remain in the list with empty class and property fields. Examples include light points, distribution boards, custom cable types and VOB bundles containing several wires. Missing properties are not filled in using assumptions.

The export contains no supplier article numbers or prices and is not an ETIM xChange product catalogue. For an order or quotation, you still need to match material requirements to actual articles. Export again after project changes.

A bill of quantities for Robaws

  1. Set Preset to Robaws — meetstaat. The format becomes Excel (.xlsx).
  2. Check the categories, cable margin and preview.
  3. Click Export.
  4. In a Robaws offer, choose Upload and map Omschrijving, Aantal and Eenheid to the three columns.

The Robaws export is a bill of quantities, without article import or article catalogue integration. Add prices and article data in Robaws. Estimated or partial lengths appear in the description. Files do not follow project changes: export again after editing.

No rows visible? Select at least one category containing material. If cable export is disabled, enter a valid cable margin of 0 or more.