Mounting hole placement in PCB Design - Cell-by-Cell Formula Trace

Sample Data

This data shows mounting hole IDs with their X and Y positions on a PCB board. Board dimensions and calculated center coordinates are included. The distance from hole H1 to the board center is calculated.

Cell	Value
A1	Hole ID
B1	X Position (mm)
C1	Y Position (mm)
A2	H1
B2	10
C2	5
A3	H2
B3	90
C3	5
A4	H3
B4	10
C4	45
A5	H4
B5	90
C5	45
A6	Board Width (mm)
B6	100
A7	Board Height (mm)
B7	50
A8	Center X
B8	=B6/2
A9	Center Y
B9	=B7/2
A10	Distance H1 to Center
B10	=SQRT((B2-B8)^2+(C2-B9)^2)

Formula Trace

=SQRT((B2-B8)^2+(C2-B9)^2)

Step 1: B6/2

Step 2: B8

Step 3: B7/2

Step 4: B9

Step 5: (B2-B8)

Step 6: (B2-B8)^2

Step 7: (C2-B9)

Step 8: (C2-B9)^2

Step 9: (B2-B8)^2 + (C2-B9)^2

Step 10: SQRT(2000)

Cell Reference Map

    A       B       C
1 | Hole ID | X Pos  | Y Pos  
2 |   H1    |  10    |   5    
3 |   H2    |  90    |   5    
4 |   H3    |  10    |  45    
5 |   H4    |  90    |  45    
6 | Board W |  100   |        
7 | Board H |  50    |        
8 | CenterX |  =B6/2 |        
9 | CenterY |  =B7/2 |        
10| Dist H1 | =SQRT((B2-B8)^2+(C2-B9)^2) |

Arrows:
B8 <- B6
B9 <- B7
B10 <- B2, B8, C2, B9

This map shows the cells used in the formula for distance calculation. Center X (B8) depends on Board Width (B6). Center Y (B9) depends on Board Height (B7). Distance (B10) depends on hole H1's X (B2), Y (C2), and center coordinates (B8, B9).

Result

    A       B       C
1 | Hole ID | X Pos  | Y Pos  
2 |   H1    |  10    |   5    
3 |   H2    |  90    |   5    
4 |   H3    |  10    |  45    
5 |   H4    |  90    |  45    
6 | Board W |  100   |        
7 | Board H |  50    |        
8 | CenterX |  50     |        
9 | CenterY |  25     |        
10| Dist H1 | 44.72   |        

The final result shows the calculated center coordinates of the board (50 mm, 25 mm) and the distance from hole H1 to the center as approximately 44.72 mm.

Sheet Trace Quiz - 3 Questions

What is the value of Center X (cell B8)?

A 100

B 50

C 25

D 10

Key Result

Distance from a point to center is calculated using the Pythagorean theorem: SQRT((X - CenterX)^2 + (Y - CenterY)^2).