Follow

Calculating Cost and Using Excel Equations in a Bill of Materials

Barry Shiong

First you will want to add a Cost Property to the BOM template:

  1. Insert a new column where you want the information to appear. The new column must be to the left of the column marked $$END.
  2. Enter the column heading for the property you want to display in that column, and press Enter. The name appears in the Formula Bar in the Excel toolbar. This column heading does not need to match the custom property name.
  3. Click the cell to select it, then click Insert, Name, Define and type in the name of the property that you want to appear in this column. This cell name replaces the default alphanumeric cell name that appears in the Name Box in the Excel toolbar whenever you click a cell.
  4. The cell name is listed in the Names in workbook list for the selected cell. This name must match the name of the property from the part or sub-assembly document, and must not contain any spaces.
  5. Click Add, then click OK.
  6. Back in SolidWorks, select the drawing view to use for the BOM and go to Insert > Tables > Excel Based Bill of Materials.
  7. You can then add equations and rows to the Bill of Material to calculate cost.

Please see Bill of Materials Custom Properties and Bill of Material Overview in the help file for additional information.

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments