Pick and place file for assembly in PCB Design - Dashboard Guide

Dashboard Mode - Pick and place file for assembly

Goal

Understand the key information in a pick and place file used for PCB assembly to ensure correct component placement.

Sample Data: Pick and Place File

Ref	Value	Package	X (mm)	Y (mm)	Rotation (°)	Side
R1	10k	0603	12.5	34.2	0	Top
C1	100nF	0603	15.0	34.2	90	Top
U1	MCU	QFN-32	20.0	30.0	180	Top
D1	LED	SMD-1206	10.0	40.0	270	Bottom
R2	1k	0603	13.0	35.0	0	Top
C2	10uF	0805	18.0	32.0	0	Top

Dashboard Components

• KPI Card: Total Components
  Formula: COUNT(Ref) = 6
• KPI Card: Components on Top Side
  Formula: COUNTIF(Side, "Top") = 5
• KPI Card: Components on Bottom Side
  Formula: COUNTIF(Side, "Bottom") = 1
• Bar Chart: Count of Components by Package
  Data: Group by Package, count Ref
  Result: 0603=3, 0805=1, QFN-32=1, SMD-1206=1
• Table: Detailed Component Placement
  Columns: Ref, Value, Package, X (mm), Y (mm), Rotation (°), Side

Dashboard Layout

+-------------------+-------------------+
| Total Components   | Components Top    |
|       [ 6 ]       |       [ 5 ]       |
+-------------------+-------------------+
| Components Bottom  |                   |
|       [ 1 ]       |                   |
+-------------------+-------------------+
|       Bar Chart: Count by Package       |
| 0603 | 3 | 0805 | 1 | QFN-32 | 1 | SMD-1206 | 1 |
+-----------------------------------------+
| Detailed Component Placement Table       |
| Ref | Value | Package | X | Y | Rotation | Side |
| ... (all rows) ...                        |
+-----------------------------------------+

Interactivity

User can filter components by Side (Top or Bottom). When a side is selected, the KPI cards, bar chart, and detailed table update to show only components on that side.

Example: Selecting "Top" updates total components to 5, bar chart to packages only on top side, and table to show only top side components.

Self Check

If you add a filter for Side = "Bottom", which components remain visible?

• KPI Cards: Total Components = 1, Components Top = 0, Components Bottom = 1
• Bar Chart: Shows only package SMD-1206 with count 1
• Table: Shows only component D1

Key Result

Dashboard shows component counts and placement details from a pick and place file for PCB assembly.