Bill of Materials (BOM) export in PCB Design - Dashboard Guide

Dashboard Mode - Bill of Materials (BOM) export

Goal

Understand the total quantity and cost of components needed for a PCB project by analyzing the Bill of Materials (BOM) export.

Sample Data

Component	Part Number	Quantity	Unit Cost ($)	Category
Resistor 10kΩ	R10K-1	50	0.05	Passive
Capacitor 100nF	C100N-1	30	0.10	Passive
Microcontroller	MCU-123	1	3.50	Active
LED Green	LED-G-5MM	10	0.20	Optoelectronic
Connector USB	USB-CONN-1	2	1.00	Connector
Crystal 16MHz	XTAL-16M	1	0.75	Passive
Voltage Regulator	VR-5V	1	1.25	Active

Dashboard Components

• Total Components Count: Shows the sum of all component quantities.
  Formula: SUM(Quantity) = 50+30+1+10+2+1+1 = 95
• Total Cost: Calculates total cost by multiplying quantity and unit cost for each component and summing.
  Formula: SUMX(BOM, Quantity * Unit Cost) = (50*0.05)+(30*0.10)+(1*3.50)+(10*0.20)+(2*1.00)+(1*0.75)+(1*1.25) = 2.5+3+3.5+2+2+0.75+1.25 = 15.0
• Cost by Category: Bar chart showing total cost grouped by Category.
  Calculation: Sum of (Quantity * Unit Cost) per Category:
  • Passive: (50*0.05)+(30*0.10)+(1*0.75) = 2.5+3+0.75 = 6.25
  • Active: (1*3.50)+(1*1.25) = 3.5+1.25 = 4.75
  • Optoelectronic: (10*0.20) = 2.0
  • Connector: (2*1.00) = 2.0
• Component Details Table: Lists all components with columns: Component, Part Number, Quantity, Unit Cost, Total Cost (Quantity * Unit Cost).

Dashboard Layout

+----------------------+----------------------+
| Total Components: 95 | Total Cost: $15.00   |
+----------------------+----------------------+
|                      Cost by Category Bar Chart                      |
|  Passive | Active | Optoelectronic | Connector                        |
+---------------------------------------------------------------------+
| Component Details Table (all columns including Total Cost)          |
+---------------------------------------------------------------------+

Interactivity

A category filter allows selecting one or multiple categories. When a category is selected, the Total Components and Total Cost KPIs update to show sums only for selected categories. The Cost by Category bar chart highlights the selected categories. The Component Details Table filters to show only components in the selected categories.

Self Check

If you add a filter to show only the 'Passive' category, which components and totals update?

• Total Components: 50 + 30 + 1 = 81
• Total Cost: 6.25
• Cost by Category: Only 'Passive' bar highlighted
• Component Details Table: Shows Resistor 10kΩ, Capacitor 100nF, Crystal 16MHz only

Key Result

Dashboard shows total quantities and costs of PCB components from BOM with category breakdown and detailed table.