Bill of Materials (BOM) export in PCB Design - Cell-by-Cell Formula Trace

Sample Data

This data represents a simple Bill of Materials for a PCB design with components, their quantities, unit prices, and a column for total cost to be calculated.

Cell	Value
A1	Component
B1	Quantity
C1	Unit Price
D1	Total Cost
A2	Resistor 10k
B2	50
C2	0.05
D2
A3	Capacitor 100nF
B3	30
C3	0.10
D3
A4	IC 555 Timer
B4	10
C4	1.50
D4

Formula Trace

=B2*C2

Step 1: B2 * C2

Step 2: 50 * 0.05

Cell Reference Map

    A           B           C           D
1 |Component | Quantity  | Unit Price | Total Cost
2 |Resistor 10k |    50     |    0.05    |   ->   
3 |Capacitor 100nF |    30     |    0.10    |        
4 |IC 555 Timer |    10     |    1.50    |        

Arrow points from B2 and C2 to D2 indicating the formula =B2*C2

Cells B2 and C2 are referenced in the formula to calculate the total cost in D2.

Result

    A           B           C           D
1 |Component | Quantity  | Unit Price | Total Cost
2 |Resistor 10k |    50     |    0.05    |   2.5  
3 |Capacitor 100nF |    30     |    0.10    |        
4 |IC 555 Timer |    10     |    1.50    |        

The total cost for Resistor 10k is calculated as 2.5 and displayed in cell D2.

Sheet Trace Quiz - 3 Questions

What does the formula =B2*C2 calculate?

A Total cost for the component in row 2

B Sum of quantity and unit price

C Difference between quantity and unit price

D Quantity divided by unit price

Key Result

Multiply quantity by unit price to get total cost per component.