Bill of materials
Bill of materials of the heat network: evaluate pipe lengths, fittings, fluid volume and consumers in tables, group them and export them to Excel
VICUS Districts Page 6 of 6 in this chapter
Overview
The bill of materials compiles the quantities of the heat network in tables: pipe lengths per pipe type, number of fittings per type and dimension, the fluid volume, as well as a consumer list with connection powers and connection pipes. The tables can be grouped, sorted, copied to the clipboard and exported together as an Excel workbook - as a basis for tendering, cost estimation and material procurement.
Opening
- Menu Network › Bill of materials …
- alternatively the
Bill of materials … button in the Pipes tab of the network properties window
Via the Network: selection list at the top the network to be evaluated is chosen (this also sets the active network of the project). The dialog updates automatically when the network geometry in the project changes.
Below are the Settings section and four tabs with one table each: Pipes, Pipe fittings, Fluid volume and Consumers.

Display options
In the Settings section, two display modes and several grouping options are available:
| Option | Default | Meaning |
|---|---|---|
| Summary | selected | Combines identical pipe types or fitting types into a single row with total length or total count. |
| Individual list | - | Lists each pipe section or each fitting individually with ID. The grouping options cannot be used in this mode; partition and lock status are always shown as columns. |
| Group by locked | on | Reports pipes locked for sizing in separate rows - useful when existing lines are to be considered separately from pipes to be newly laid. |
| Group by partition | on | Reports the lengths separately per network partition. Partitions arise when previously independent networks are merged into one network via Add to current network; each part keeps the name of its origin network. If the sub-networks are modeled e.g. per construction phase or supply zone, the quantities can be reported separately. |
| Show fitting details | off | Extends the fitting table by manufacturer, product and the inlet/outlet diameters of each fitting; when disabled, fittings are combined by type only. |
All tables can be sorted by clicking on the column headers; number columns are sorted numerically.
Practical tip
For a reliable bill of materials, first run the pipe sizing - only then do the routes carry real pipe types and the fittings are up to date. With Group by locked you separate existing lines from pipes to be newly laid, so that only the quantities actually to be procured enter your cost estimation. Via Export to Excel… all tables land in one workbook directly in your spreadsheet application.
Pipes table
The Pipes tab lists the pipe lengths of the network. All lengths are installed pipe lengths, not trench lengths: where supply and return are laid as two single pipes, a metre of trench yields two metres of pipe; a twin pipe carries both in one and yields one metre.
In the summary the table contains per row: pipe material ID, optionally partition and lock status (depending on the grouping), manufacturer, product, name, pipe layout (single/twin pipe), outer diameter [mm], wall thickness [mm] and the lengths split by usage: Connection length [m] (house connection pipes), Distribution length [m] (distribution pipes) and Total length [m]. The connection length includes the in-house installation pipes of the transfer stations, provided their pipe length is defined in the plant configuration. In the individual list the pipe section ID of the individual pipe section takes the place of the pipe type.
Pipe fittings table
The Pipe fittings tab counts the fittings of the network. In the summary the table contains: type (e.g. Elbow 90°, T-piece, reducer), optionally partition and lock status, pipe layout as well as count [-]. With Show fitting details, manufacturer, product, main diameter [mm], branch/reduced diameter [mm] and straight-run diameter [mm] are added. The individual list shows for each fitting its assignment state, the node ID, the pipe usage and all detail columns.
For single pipes, fittings are counted separately in supply and return; for twin pipes one fitting is applied per twin pipe section.
Fluid volume table
The Fluid volume tab reports the fluid volume of the network in [m³] - per partition with Group by partition, otherwise as one row for the whole network. The volume follows from the inside diameter and the installed length of all pipes; pipes with incomplete parameters contribute no volume.
Consumers table
The Consumers tab lists all transfer stations with:
| Column | Meaning |
|---|---|
| ID / Name | Identifier and display name of the consumer node |
| Plant | Assigned plant configuration of the transfer station |
| Connection power [kW] | Installed connection power |
| Heating power [kW] | Maximum heating power from the building demand |
| Connection pipe size [mm] | Dimension of the house connection pipe |
| Connection pipe length [m] | Length of the house connection pipe |
Copy and export
Copy in each tab copies the respective table to the clipboard, e.g. for pasting into a spreadsheet application.
- Export to Excel… at the bottom of the dialog saves all tables in one Excel workbook (
*.xlsx) with one worksheet per tab. Numbers are written as numbers so that Excel can calculate with them directly. The button is only operable when a network is active.