Comsof Bill of Materials

The network calculation produces a network plan as a drawing and a bill of materials.

The “Bill of Materials” button opens the bill of material in Excel format. It consists of various worksheets.


The following table sheets are created by default:

  • Summary
  • Overview
  • Change Price
  • Phase 1
  • Phase 2
  • Parts list for each network distribution cabinet
  • Parts list for each main distributor
  • Parts list for each backbone distributor
  • Parts list for each area


The summary consists of 4 parts: 

  1. Calculation information—a summary of the calculation information.
  2. Cost Breakdown – The cost breakdown is a breakdown of the costs per network layer differentiated by provision and activation.
  3. The pie chart displays the results of the cost breakdown.
  4. Results—the total cost of the project divided into:
    • Deployment Cost per Home Passed
    • Deployment Cost per Home Activated
    • Activation Cost per Home (drops)
    • Total Cost per Home Activated (drops)
    • Total Expected Revenue






This is where you can find all materials required to extend the network. The entries are grouped thematically. The sheet is divided into various columns. 

Columns and their meanings

  • “Material and labour costs” are the specifications from the rules.
  • The “Volume” has been determined by the optimization. 
  • “Total” and “Total Cost” are determined by the calculation.
  • The “HP/HA” designation is used to distinguish between passive-network costs (HP) and active-network costs (HA).
  • “Unit” means the identification of the number per meter or per piece.


If material is provided with a price of €0.00 in the rules, the row for this item is hidden in the bill of materials. Excess cable lengths are not shown individually in the bill of materials, but are included in the lengths of the corresponding cables.


Change Price

This is where you have the option of testing how changes in the prices of individual items affect the calculated costs. Please note that changes you make here do not affect the rules or the calculation.

Phase 1 and Phase 2

If, for example, drops are not to be extended in the first step—the first phase—this can be controlled via the attribute “Connection type” at the demand point. Regardless of the value in “Connection type”, all terminators will be planned. The demand points or their connection elements intended for later extension are given the value “2” in the “Phase” attribute. All network elements to be set up in the first step are given the value “1”. The corresponding records are assigned to the Phase 1 and Phase 2 tabs accordingly. 

BoM per Distribution Point

This list contains the costs after the distribution point up to the buildings. 

BoM per Centre Office

This list contains the costs after the POP including the associated network distribution points up to the building.  

BoM per Backbone Distributor

This list contains the costs after the backbone distribution cabinet up to the building. 

BoM per SubArea

This list shows the costs per subarea.