Solder mask expansion in PCB Design - Dashboard Guide

Dashboard Mode - Solder mask expansion

Dashboard Goal

Understand how solder mask expansion affects PCB manufacturing quality and yield by analyzing expansion values and defect rates.

Sample Data

PCB_ID	Solder Mask Expansion (µm)	Defect Count	Total Pads	Yield (%)
PCB001	50	2	100	98
PCB002	70	5	120	95.8
PCB003	40	1	110	99.1
PCB004	80	7	130	94.6
PCB005	60	3	115	97.4
PCB006	55	2	105	98.1

Dashboard Components

• KPI Card: Average Solder Mask Expansion
  Formula: Average = SUM([Solder Mask Expansion (µm)]) / COUNT([PCB_ID])
  Result: (50+70+40+80+60+55)/6 = 59.17 µm
• KPI Card: Average Defect Rate (%)
  Formula: Defect Rate per PCB = (Defect Count / Total Pads) * 100
  Average Defect Rate = AVERAGE((Defect Count / Total Pads) * 100)
  Calculations:
  PCB001: 2/100*100=2%
  PCB002: 5/120*100=4.17%
  PCB003: 1/110*100=0.91%
  PCB004: 7/130*100=5.38%
  PCB005: 3/115*100=2.61%
  PCB006: 2/105*100=1.90%
  Average = (2+4.17+0.91+5.38+2.61+1.90)/6 = 2.83%
• Line Chart: Solder Mask Expansion vs Yield
  X-axis: Solder Mask Expansion (µm)
  Y-axis: Yield (%)
  Shows how yield changes with expansion values.
• Bar Chart: Defect Count per PCB
  X-axis: PCB_ID
  Y-axis: Defect Count
  Highlights which PCBs have higher defects.
• Table: Detailed PCB Data
  Shows all columns for detailed inspection.

Dashboard Layout

+----------------------+----------------------+
|  KPI: Avg Expansion   |  KPI: Avg Defect Rate |
|      (59.17 µm)       |       (2.83 %)        |
+----------------------+----------------------+
|                                              |
|      Line Chart: Expansion vs Yield           |
|                                              |
+----------------------+----------------------+
|  Bar Chart: Defect Count  |  Table: PCB Details  |
|       per PCB             |                      |
+----------------------+----------------------+
    

Interactivity

A filter slider for Solder Mask Expansion allows selecting a range (e.g., 40 to 70 µm).
When adjusted, the KPI cards, line chart, bar chart, and table update to show data only for PCBs within that expansion range.
This helps analyze how defect rates and yield behave for specific expansion values.
The table supports sorting by any column for deeper analysis.

Self Check

If you add a filter to show only PCBs with Solder Mask Expansion <= 60 µm, which components update and what changes occur?

• KPI Cards recalculate averages only for PCBs with expansion ≤ 60 µm (PCB001, PCB003, PCB005, PCB006).
• Line chart redraws to show yield for these PCBs only.
• Bar chart shows defect counts only for these PCBs.
• Table filters to show only these PCBs.

This helps focus on lower expansion values and their quality impact.

Key Result

Dashboard analyzing solder mask expansion impact on PCB defect rates and yield.