Bill of materials and lists
What the plan needs for electrics, network and smart home: devices per room, cable metres with rings, patch panel, switch and PoE. Plus patch list, labels, function list, equipment report, exports and sheets.Before you order material or ask an electrician for a quote, you want to know what your plan needs. The bill of materials counts everything you placed and drew for electrics, network and smart home: devices, boxes, cable metres with rings and the distributor. The totals in the editor are free. The exports as PDF, Excel and CSV, the patch list, the labels, the function list and the equipment report come with Premium.
Open the template in the editorThe bill of materials in the editor
In the left bar under Building services, choose the Network & smart home or Electrical tool. On the right the Bill of materials section shows:
- Devices by storey and room, plus the totals of sockets (a double socket counts two), switches and dimmers, light outlets and flush boxes. Boxes side by side at one height share a multiple frame; the list counts 2-, 3- or 4-gang frames.
- Cables per type in metres, with rings: network and bus cable in 100 or 500 m, NYM in 50 or 100 m, coax and fibre too.
- Cable per circuit: the metres of each power circuit, the electrical bill of materials.
- Distributor, boxes and accessories: patch panel with ports, switch ports, PoE budget, network cabinet in rack units (U), for SAT sockets the multiswitch, for a door intercom the door and indoor stations and door openers, for sun shading kind, drive and box with the motors' power.
With nothing on the plan yet, the section says so. The bill of materials has no prices.
How RoomPlanning counts the cables
The cable quantity is a guideline for ordering:
| Part of the run | Guideline |
|---|---|
| horizontal run | along the drawn wire in its route zone |
| vertical | from the zone (ceiling, screed or wall) to each device's height |
| between storeys | risers by storey height, through riser points |
| reserve | 2 m at the distributor, 0.3 m at every device |
| waste | everything times 1.1 |
Network, antenna and fibre cables run as a star: each socket gets its own cable along the shortest way through your drawn wires to the distributor, through riser points between storeys too. Riser points at the same spot on two storeys are joined by themselves. Power circuits, on the other hand, count the drawn wire from device to device.
Patch list and labels
The patch list names for every used port on the patch panel the socket's label, the room and the cable length. It works out when your sockets are labelled and have a port: Label all in the Network & smart home section labels every network socket and access point from storey, room and number, for example “GF-ST-01”, and Suggest network assigns the ports by itself (Plan a network).
The labels come as a list of their own for a label printer, one line per device.
Export (Premium)
With Premium, Export lists in the Bill of materials section offers:
- Bill of materials as PDF, as Excel (XLSX) or as CSV;
- Patch list (CSV);
- Labels for a label printer (CSV);
- Function list (CSV) with each control, its function, the devices it controls and the actuator channel (Smart home and function list);
- Equipment report (PDF) with one page per storey: for each room sockets, light outlets, data and TV, placed and required after DIN 18015-2 and RAL-RG 678, with the date.
Excel and LibreOffice open the CSV files with umlauts; in German they use a semicolon and a decimal comma. On Free, Export lists shows the crown and the way to Premium; guests sign up first.
Lists on sheets
Under Drawings you set up sheets for printing. Under Add, the Building services section offers the bill of materials, the patch list, the function list and the equipment report, plus a storey's legends per system and Wi-Fi map. With Premium the lists and the Wi-Fi map show the data of the plan; on Free a note with the crown stands in their place.
Building services sheet set creates in one step an electrical plan with its legend and a network plan with legends per system for every storey, plus the bill of materials and the patch list, all on A3 landscape at the largest scale that fits (Drawings and export).
Good to know
- All quantities are guideline values without guarantee. What is actually installed is up to the electrician on site.
- The bill of materials knows only the wires you draw. So draw the ones that are “obvious” too.
- How many sockets a room needs and how big patch panel and network cabinet get, the network sockets calculator works out without a plan too.