Drill file generation in PCB Design - Dashboard Guide

Dashboard Mode - Drill file generation

Goal

Understand the drill hole counts and sizes in a PCB design to optimize manufacturing.

Sample Data: Drill Holes

Hole Size (mm)	Count
0.8	120
1.0	80
1.2	50
1.5	30
2.0	20
2.5	10

Dashboard Components

• KPI Card: Total Drill Holes
  Formula: Sum of all hole counts = 120 + 80 + 50 + 30 + 20 + 10 = 310
• Bar Chart: Drill Hole Counts by Size
  X-axis: Hole Size (mm)
  Y-axis: Count
  Shows how many holes of each size exist
• Pie Chart: Percentage Distribution of Hole Sizes
  Shows proportion of each hole size count relative to total holes
• Table: Drill Hole Details
  Shows Hole Size and Count columns from sample data

Dashboard Layout

+----------------------+----------------------+
|      KPI Card        |      Pie Chart       |
|  Total Drill Holes: 310|  Hole Size % Share  |
+----------------------+----------------------+
|                  Bar Chart                   |
|          Drill Hole Counts by Size           |
+---------------------------------------------+
|                  Data Table                  |
|             Drill Hole Details               |
+---------------------------------------------+

Interactivity

A filter slider allows selecting a range of hole sizes (e.g., 0.8mm to 1.5mm). When adjusted:

• KPI Card updates total holes in selected size range.
• Bar Chart shows counts only for selected sizes.
• Pie Chart updates to show percentage distribution for selected sizes.
• Data Table filters rows to selected hole sizes.

Self Check

If you set the hole size filter to 1.0mm to 2.0mm, which components update and what is the new total drill hole count?

Answer: All components update. The new total is 80 + 50 + 30 + 20 = 180 holes.

Key Result

Dashboard showing drill hole counts and size distribution for PCB manufacturing optimization.