Applies to Excel-based
Bills of Materials. Applies to Excel-based
Bills of Materials.
The default template, Bomtemp.xls, contains columns for ITEM NO., QTY., PART NO., and DESCRIPTION. The SolidWorks software populates the columns in the default template automatically. Other templates supplied with the software add the following columns to the default format.
|
BOM template file name |
Columns added to default format |
|
Bomtemp-Material.xls |
MATERIAL |
|
Bomtemp-StockSize.xls |
STOCK SIZE |
|
Bomtemp-Vendor.xls |
VENDOR NO |
|
Bomtemp-Weight.xls |
WEIGHT |
|
Piping BOM Template.xls |
CUT LENGTH |
|
Bomtemp-All.xls |
VENDOR NO, WEIGHT, STOCK SIZE, MATERIAL |
You must add the custom properties into the parts of your assembly in order to take advantage of the additional columns in these templates.