Via size and drill diameter in PCB Design - Dashboard Guide

Dashboard Mode - Via size and drill diameter

Goal

Understand how via size and drill diameter affect PCB manufacturing and electrical performance.

Sample Data

Via ID	Drill Diameter (mm)	Via Diameter (mm)	Annular Ring Width (mm)	Electrical Resistance (mΩ)
V1	0.3	0.6	0.15	50
V2	0.4	0.8	0.2	35
V3	0.5	1.0	0.25	25
V4	0.6	1.2	0.3	20
V5	0.7	1.4	0.35	15

Dashboard Components

• KPI Card: Average Drill Diameter
  Formula: Average of Drill Diameter column = (0.3+0.4+0.5+0.6+0.7)/5 = 0.5 mm
• KPI Card: Average Electrical Resistance
  Formula: Average of Electrical Resistance column = (50+35+25+20+15)/5 = 29 mΩ
• Bar Chart: Drill Diameter vs Electrical Resistance
  Shows each Via ID on X-axis and Electrical Resistance on Y-axis with bars colored by Drill Diameter size.
• Scatter Plot: Via Diameter vs Electrical Resistance
  X-axis: Via Diameter, Y-axis: Electrical Resistance, points labeled by Via ID to show relationship.
• Table: Full data table with all columns for detailed view.

Dashboard Layout

+----------------------+----------------------+
|  KPI: Avg Drill Dia  |  KPI: Avg Resistance  |
+----------------------+----------------------+
|                      Bar Chart                     |
|           Drill Diameter vs Electrical Resistance  |
+---------------------------------------------------+
|               Scatter Plot: Via Diameter vs Resistance             |
+---------------------------------------------------+
|                         Data Table                          |
+---------------------------------------------------+

Interactivity

User can filter by Via ID or range of Drill Diameter. Filtering updates all components: KPIs recalculate averages, charts update to show only selected vias, and table filters rows accordingly.

Self Check

If you add a filter to show only vias with Drill Diameter >= 0.5 mm, which components update and how?

• Average Drill Diameter KPI updates to average of 0.5, 0.6, 0.7 = 0.6 mm
• Average Electrical Resistance KPI updates to average of 25, 20, 15 = 20 mΩ
• Bar Chart shows only V3, V4, V5 bars
• Scatter Plot shows only points for V3, V4, V5
• Data Table shows only rows for V3, V4, V5

Key Result

Dashboard shows how via drill diameter and size relate to electrical resistance in PCB design.