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.

Bill of materials dialog with settings and pipe table
Bill of materials of the heat network

Display options

In the Settings section, two display modes and several grouping options are available:

OptionDefaultMeaning
SummaryselectedCombines 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 lockedonReports pipes locked for sizing in separate rows - useful when existing lines are to be considered separately from pipes to be newly laid.
Group by partitiononReports 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 detailsoffExtends 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:

ColumnMeaning
ID / NameIdentifier and display name of the consumer node
PlantAssigned 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.

Stay up to date

New features, tutorials and updates delivered to your inbox.