Excel BOM
For the new ISD Report Manager (from HiCAD 2023), an XML configuration file adapted for Plant Engineering is available with the name HiCAD_Anlagenbau.rm_settings. This configuration file allows the sensible creation of bills of materials (BOMs) of mixed model drawings.
The file is located in the HiCAD sys directory and facilitates in particular the use of a new BOM template for Excel export. This new template HiCAD_Anlagenbau.2800.0.xlsx can also be found in the sys directory of your installation (or as HiCAD_Anlagenbau.EN.2800.0.xlsx in the sub-folder bomtemplates).
Proceed as follows:
- To create a BOM, choose the function Drawing > Itemization/Detailing > BOM.
- In the dialogue window, select HiCAD_Anlagenbau for Configuration in the XML Format section.
- When the BOM is displayed in the ISD Report Manager, select the Create Excel document (with template or script function there.
- After selecting a file name, Excel will open.
In the opened file you will now find the following BOMs (as Excel tables):
Table |
Content |
---|---|
Structure list |
Displays all individual parts and assemblies of a product on the basis of the HiCAD part structure, i.e. a summary of all production stages with logical relationships |
Quantity list |
Displays the quantity per item, i.e. without further summary |
Quantity sum list |
Shows the quantity per article, where length, area and weight are summed up |
Profile totals list |
A grouped layout of the quantity list for articles with length |
Components list |
A grouped layout of the quantity list without even pipes or articles without length |
Bar list |
Similar to the profile totals list, but grouped by delivery length with remainder |
Bar - Summary |
Basically the table headers from the bar list, so a summary of the bar list |
Example:
Plant Engineering Functions (PE) • Settings: Bills of Materials (PE) • HiCAD Basics (PE)