Bird
0
0
PCB Designbi_tool~10 mins

Assigning footprints to symbols in PCB Design - Cell-by-Cell Formula Trace

Choose your learning style9 modes available
LearnWhyDeepSheetTryChallengeScenarioRecallDash
Sample Data

This table shows electronic symbols and their assigned PCB footprints.

CellValue
A1Symbol
B1Footprint
A2Resistor
B2R_0805
A3Capacitor
B3C_0603
A4LED
B4LED_1206
A5Microcontroller
B5QFP_64
Formula Trace
LOOKUP(Symbol, SymbolList, FootprintList)
Step 1: LOOKUP("Capacitor", ["Resistor", "Capacitor", "LED", "Microcontroller"], ["R_0805", "C_0603", "LED_1206", "QFP_64"])
Cell Reference Map
   A           B
1 Symbol     Footprint
2 Resistor   R_0805
3 Capacitor  C_0603  <-- Lookup target
4 LED        LED_1206
5 Microcontroller QFP_64
The formula looks up the symbol 'Capacitor' in column A and returns the footprint from column B.
Result
   A           B
1 Symbol     Footprint
2 Resistor   R_0805
3 Capacitor  C_0603  <-- Result of lookup
4 LED        LED_1206
5 Microcontroller QFP_64
The result shows that the symbol 'Capacitor' is assigned the footprint 'C_0603'.
Sheet Trace Quiz - 3 Questions
Test your understanding
What footprint is assigned to the symbol 'LED'?
AC_0603
BR_0805
CLED_1206
DQFP_64
Key Result
LOOKUP(symbol, symbol_list, footprint_list) returns the footprint assigned to the symbol.