Bird
0
0
PCB Designbi_tool~8 mins

Mounting hole placement in PCB Design - Dashboard Guide

Choose your learning style9 modes available
LearnWhyDeepSheetTryChallengeScenarioRecallDash
Dashboard Mode - Mounting hole placement
Goal: Analyze Mounting Hole Placement for PCB Design

This dashboard helps engineers check the positions and sizes of mounting holes on a PCB to ensure proper fit and stability.

Sample Data: Mounting Hole Coordinates and Sizes
Hole IDX Position (mm)Y Position (mm)Diameter (mm)
H110103
H290103
H390503
H410503
H550304
Dashboard Components
  • KPI Card: Total Number of Mounting Holes = 5
  • KPI Card: Average Hole Diameter = 3.2 mm (Formula: AVERAGE(Diameter))
  • Scatter Plot: Hole Positions (X vs Y) with point size representing Diameter
  • Table: Detailed Hole Data with conditional formatting highlighting holes with diameter > 3 mm
  • Calculated Measure: Max Distance Between Holes = 89.44 mm (calculated using distance formula between all hole pairs)
Layout
+----------------------+----------------------+
|  KPI: Total Holes    |  KPI: Avg Diameter    |
|       (5)            |       (3.2 mm)        |
+----------------------+----------------------+
|                      Scatter Plot (Hole Positions)             |
|                      (X vs Y, size = Diameter)                 |
+---------------------------------------------------------------+
|                      Table: Hole Details                       |
+---------------------------------------------------------------+
|                      KPI: Max Distance Between Holes          |
|                              (89.44 mm)                      |
+---------------------------------------------------------------+
Interactivity

User can filter holes by diameter range using a slider. Filtering updates:

  • The scatter plot to show only holes within the selected diameter range.
  • The table to list only filtered holes.
  • KPI cards recalculate total holes and average diameter for the filtered set.
  • Max distance recalculates based on filtered holes.
Self-Check Question

If you add a filter to show only holes with diameter greater than 3 mm, which holes remain and how do the KPIs update?

Answer: Hole H5 (4 mm) remains. Total holes = 1, Average diameter = 4 mm, Max distance = 0 mm (only one hole), scatter plot and table show only H5.

Key Result
Dashboard shows mounting hole count, average diameter, positions on PCB, and max distance between holes with interactive diameter filtering.