Assigning footprints to symbols in PCB Design - Real Business Scenario

Scenario Mode

👤 Your Role: You are a PCB design engineer working on a new electronic product.

📋 Request: Your manager wants you to assign correct footprints to all schematic symbols in the PCB design software to ensure proper physical layout and manufacturing.

📊 Data: You have a list of schematic symbols with their reference designators and required footprints. The footprints define the physical package size and pin layout for each component.

🎯 Deliverable: A report showing each symbol with its assigned footprint and a summary dashboard visualizing footprint usage counts.

Sample Data

Reference	Symbol	Required Footprint
R1	Resistor	0603
C1	Capacitor	0805
U1	Microcontroller	QFP-64
D1	Diode	SOD-123
R2	Resistor	0603
C2	Capacitor	0805
U2	Op Amp	SOIC-8
Q1	Transistor	TO-92

1

Step 1: Create a table listing all schematic symbols with their reference designators and required footprints.

Use the sample data table as the base list.

Expected Result

Table with columns: Reference, Symbol, Required Footprint showing 8 rows.

2

Step 2: Assign the required footprint to each symbol in the PCB design software's footprint assignment tool.

For each symbol, select the footprint matching the 'Required Footprint' column (e.g., R1 gets 0603 footprint).

Expected Result

All symbols have footprints assigned matching their required footprint.

3

Step 3: Create a calculated measure to count how many times each footprint is used.

Count of Reference grouped by Required Footprint.

Expected Result

Footprint usage counts: 0603=2, 0805=2, QFP-64=1, SOD-123=1, SOIC-8=1, TO-92=1.

4

Step 4: Build a bar chart visualization showing footprint usage counts.

X-axis: Footprint, Y-axis: Count of symbols assigned.

Expected Result

Bar chart with footprints on X-axis and counts on Y-axis showing usage distribution.

5

Step 5: Prepare a summary report listing each symbol with its assigned footprint and the footprint usage chart.

Combine the table from step 1 and the bar chart from step 4 into one dashboard.

Expected Result

Dashboard showing symbol-footprint assignments and footprint usage distribution.

Final Result

Footprint Assignment Report

Reference | Symbol          | Footprint
----------------------------------------
R1        | Resistor       | 0603
R2        | Resistor       | 0603
C1        | Capacitor      | 0805
C2        | Capacitor      | 0805
U1        | Microcontroller| QFP-64
U2        | Op Amp         | SOIC-8
D1        | Diode          | SOD-123
Q1        | Transistor     | TO-92

Footprint Usage Counts:
0603   |||||| (2)
0805   |||||| (2)
QFP-64 || (1)
SOD-123|| (1)
SOIC-8 || (1)
TO-92  || (1)

✓Resistors and capacitors use the most common footprints (0603 and 0805).

✓Each IC and discrete component has a unique footprint assigned.

✓Footprint assignment matches the required physical packages ensuring manufacturability.

Bonus Challenge

Create a filterable dashboard that lets users select a footprint and see all symbols assigned to it.

Show Hint

Use slicers or filters on the footprint field to dynamically update the symbol list.