Via stitching for ground planes in PCB Design - Cell-by-Cell Formula Trace

Sample Data

This data represents the positions and sizes of vias used to stitch the ground plane on a PCB. Each row shows a via's layer, X and Y coordinates, diameter, and spacing between vias.

Cell	Value
A1	Layer
B1	X (mm)
C1	Y (mm)
D1	Via Diameter (mm)
E1	Spacing (mm)
A2	GND Plane
B2	10
C2	10
D2	0.5
E2	5
A3	GND Plane
B3	15
C3	10
D3	0.5
E3	5
A4	GND Plane
B4	20
C4	10
D4	0.5
E4	5

Formula Trace

COUNTROWS(FILTER(Vias, Vias[Layer] = "GND Plane" && Vias[Spacing] <= 5))

Step 1: FILTER(Vias, Vias[Layer] = "GND Plane" && Vias[Spacing] <= 5)

Step 2: COUNTROWS([Row2, Row3, Row4])

Cell Reference Map

    A         B      C      D           E
1 | Layer   | X(mm) | Y(mm) | Via Dia(mm) | Spacing(mm) |
2 | GND Plane | 10    | 10    | 0.5        | 5           |
3 | GND Plane | 15    | 10    | 0.5        | 5           |
4 | GND Plane | 20    | 10    | 0.5        | 5           |

The formula references the 'Layer' and 'Spacing' columns to filter vias on the ground plane with spacing less or equal to 5 mm.

Result

    A         B      C      D           E      F
1 | Layer   | X(mm) | Y(mm) | Via Dia(mm) | Spacing(mm) | Count |
2 | GND Plane | 10    | 10    | 0.5        | 5           | 3     |

The final result shows that there are 3 vias stitched on the ground plane with spacing 5 mm or less.

Sheet Trace Quiz - 3 Questions

How many vias are counted by the formula?

A 4

B 3

C 2

D 1

Key Result

COUNTROWS(FILTER(Table, Condition)) counts rows meeting a condition.