Creating custom footprints in PCB Design - Formula Evaluation Walkthrough

Sample Data

This data represents the pad layout for a custom PCB footprint with pad names, their X and Y positions in millimeters, and pad sizes.

Cell	Value
A1	Pad Name
B1	X Position (mm)
C1	Y Position (mm)
D1	Pad Size (mm)
A2	Pad1
B2	0
C2	0
D2	1.5
A3	Pad2
B3	5
C3	0
D3	1.5
A4	Pad3
B4	0
C4	5
D4	1.5
A5	Pad4
B5	5
C5	5
D5	1.5

Formula Trace

Calculate footprint bounding box width = MAX(B2:B5) - MIN(B2:B5)

Step 1: MAX(B2:B5)

Step 2: MIN(B2:B5)

Step 3: MAX(B2:B5) - MIN(B2:B5)

Cell Reference Map

    B   
  +-----+
2 |  0  |
3 |  5  |
4 |  0  |
5 |  5  |

The formula uses the X Position values in cells B2 to B5 to calculate the footprint width.

Result

    A       B       C       D       E
1 | Pad Name | X Pos  | Y Pos  | Size  |
2 | Pad1     | 0      | 0      | 1.5   |
3 | Pad2     | 5      | 0      | 1.5   |
4 | Pad3     | 0      | 5      | 1.5   |
5 | Pad4     | 5      | 5      | 1.5   |
6 | Footprint Width: 5 mm                   |

The footprint width calculated from the pad X positions is 5 mm, shown below the pad data.

Sheet Trace Quiz - 3 Questions

What is the maximum X position among the pads?

A 0

B 1.5

C 5

D 10

Key Result

Calculate footprint dimension by subtracting minimum coordinate from maximum coordinate in pad positions.