Excel BOM, Calculate Weights

<< Click to Display Table of Contents >>

Navigation:  The BOM > The Excel BOM > Customize the Excel BOM >

Excel BOM, Calculate Weights

Calculate Weights in Excel BOM

The calculation of weight totals requires special settings:

Use TOTAL_QTY instead of QTY for the formulas

Uncheck the option for in-context parts

These settings would avoid miscalculations due to the fact that the same weight is calculated twice for some components.