Via size and drill diameter in PCB Design - Cell-by-Cell Formula Trace

Sample Data

This data shows different types of vias used in PCB design with their drill diameters and overall via sizes.

Cell	Value
A1	Via Type
B1	Drill Diameter (mm)
C1	Via Size (mm)
A2	Microvia
B2	0.15
C2	0.30
A3	Standard Via
B3	0.30
C3	0.60
A4	Large Via
B4	0.50
C4	1.00

Formula Trace

=C2 - B2

Step 1: C2 - B2

Step 2: 0.30 - 0.15

Cell Reference Map

     A           B               C
  +-------+-------+---------------+
1 | Via   | Drill | Via Size      |
  | Type  | Diam. |               |
  +-------+-------+---------------+
2 | Micro | 0.15  | 0.30          |
  +-------+-------+---------------+

Arrows: C2 and B2 feed into formula =C2 - B2

The formula subtracts the drill diameter in B2 from the via size in C2 for the Microvia row.

Result

     A           B               C           D
  +-------+-------+---------------+------------+
1 | Via   | Drill | Via Size      | Annular    |
  | Type  | Diam. |               | Ring Width |
  +-------+-------+---------------+------------+
2 | Micro | 0.15  | 0.30          | 0.15       |
  +-------+-------+---------------+------------+

The result 0.15 in cell D2 shows the annular ring width for the Microvia, calculated by subtracting drill diameter from via size.

Sheet Trace Quiz - 3 Questions

What does the formula =C2 - B2 calculate?

A The sum of drill diameter and via size

B The total drill diameter

C The annular ring width of the via

D The difference between two via types

Key Result

Subtract drill diameter from via size to find annular ring width