Manufacturing constraints awareness in PCB Design - Dashboard Guide

Dashboard Mode - Manufacturing constraints awareness

Goal

Understand how manufacturing constraints affect PCB design to avoid costly errors and delays.

Sample Data: PCB Manufacturing Constraints

Constraint	Description	Max Value	Unit	Current Design Value	Status
Minimum Trace Width	Smallest allowed width of copper traces	0.15	mm	0.12	Too Narrow
Minimum Trace Spacing	Smallest gap between two traces	0.2	mm	0.25	OK
Drill Hole Diameter	Smallest hole size for vias and pads	0.3	mm	0.35	OK
Board Thickness	Thickness of the PCB	1.6	mm	1.6	OK
Minimum Annular Ring	Minimum copper ring around drilled holes	0.15	mm	0.1	Too Small
Maximum Panel Size	Max size of PCB panel for manufacturing	300	mm	280	OK

Dashboard Components

• KPI Cards:
  • Count of Constraints OK: COUNTROWS(FILTER(Constraints, Constraints[Status] = "OK")) = 4
  • Count of Constraints Violated: COUNTROWS(FILTER(Constraints, Constraints[Status] <> "OK")) = 2
• Bar Chart: Constraint Status Counts
  • X-axis: Status (OK, Too Narrow, Too Small)
  • Y-axis: Number of Constraints
• Table: Detailed Constraints Table
  • Shows all columns from sample data
• Gauge Chart: Percentage of Constraints Met
  • Formula: DIVIDE(COUNTROWS(FILTER(Constraints, Constraints[Status] = "OK")), COUNTROWS(Constraints)) * 100 = 66.67%

Dashboard Layout

+----------------------+-------------------------+
|  KPI: Constraints OK |  KPI: Constraints Violated |
|        (4)           |           (2)           |
+----------------------+-------------------------+
|                      Bar Chart: Constraint Status Counts             |
|                             (OK=4, Violated=2)                      |
+---------------------------------------------------------------------+
|                         Detailed Constraints Table                  |
+---------------------------------------------------------------------+
|                      Gauge: % Constraints Met (66.67%)              |
+---------------------------------------------------------------------+
  

Interactivity

Filter by Status (OK, Too Narrow, Too Small) updates all components:

• KPI cards update counts accordingly.
• Bar chart filters to show only selected statuses.
• Table shows only constraints matching filter.
• Gauge recalculates percentage of constraints met for filtered data.

Self Check

If you add a filter for Status = "OK", which components update and how?

• KPI Cards: Constraints OK shows 4, Constraints Violated shows 0.
• Bar Chart: Only the bar for OK status is visible with count 4.
• Table: Shows only 4 rows with Status OK.
• Gauge: Shows 100% since all filtered constraints are OK.

Key Result

Dashboard shows PCB manufacturing constraints status highlighting violations and compliance.