Component orientation conventions in PCB Design - Cell-by-Cell Formula Trace

Sample Data

This table shows components on a PCB with their orientation angles and the location of pin 1 relative to the component outline.

Cell	Value
A1	Component
B1	Orientation
C1	Pin 1 Location
A2	Resistor R1
B2	0
C2	Top-left
A3	Capacitor C1
B3	90
C3	Top-right
A4	IC U1
B4	180
C4	Bottom-right
A5	LED D1
B5	270
C5	Bottom-left

Formula Trace

IF(B2=0, "Pin 1 at Top-left", IF(B2=90, "Pin 1 at Top-right", IF(B2=180, "Pin 1 at Bottom-right", IF(B2=270, "Pin 1 at Bottom-left", "Unknown orientation"))))

Step 1: B2=0

Step 2: IF(TRUE, "Pin 1 at Top-left", ...)

Cell Reference Map

    A          B           C
1 |Component |Orientation|Pin 1 Location
2 |R1        |0         |Top-left
3 |C1        |90        |Top-right
4 |U1        |180       |Bottom-right
5 |D1        |270       |Bottom-left

Formula references cell B2 for orientation angle.

The formula checks the orientation angle in cell B2 to determine the pin 1 location description.

Result

    A          B           D
1 |Component |Orientation|Pin 1 Description
2 |R1        |0         |Pin 1 at Top-left

The formula result for component R1 with orientation 0° is 'Pin 1 at Top-left' shown in column D.

Sheet Trace Quiz - 3 Questions

What does the formula return if the orientation angle in B2 is 90?

A Pin 1 at Top-right

B Pin 1 at Top-left

C Pin 1 at Bottom-right

D Unknown orientation

Key Result

Nested IF statements check orientation angle to return corresponding pin 1 location description.