EMI reduction techniques in PCB Design - Cell-by-Cell Formula Trace

Sample Data

Common EMI reduction techniques used in PCB design with brief explanations.

Cell	Value
A1	Technique
B1	Description
A2	Shielding
B2	Using conductive or magnetic barriers to block EMI
A3	Filtering
B3	Adding components to block unwanted frequencies
A4	Grounding
B4	Creating a reference point to reduce noise
A5	PCB Layout
B5	Optimizing trace routing and layer stacking
A6	Decoupling Capacitors
B6	Placing capacitors near ICs to reduce noise
A7	Twisted Pair Wiring
B7	Twisting wires to cancel EMI signals

Formula Trace

COUNTIF(A2:A7, "*ing")

Step 1: Check each cell in A2:A7 if it ends with 'ing'

Step 2: Filtering (ends with 'ing') -> TRUE

Step 3: Grounding (ends with 'ing') -> TRUE

Step 4: PCB Layout (ends with 'ing') -> FALSE

Step 5: Decoupling Capacitors (ends with 'ing') -> TRUE

Step 6: Twisted Pair Wiring (ends with 'ing') -> TRUE

Step 7: Sum of TRUE counts

Cell Reference Map

   A           B
1 Technique   Description
2 Shielding   Using conductive or magnetic barriers to block EMI
3 Filtering  Adding components to block unwanted frequencies
4 Grounding  Creating a reference point to reduce noise
5 PCB Layout Optimizing trace routing and layer stacking
6 Decoupling Capacitors Placing capacitors near ICs to reduce noise
7 Twisted Pair Wiring Twisting wires to cancel EMI signals

The formula checks the Technique names in cells A2 through A7 to count how many end with 'ing'.

Result

   A           B                      C
1 Technique   Description             Count
2 Shielding   Using conductive...     
3 Filtering  Adding components...     
4 Grounding  Creating a reference...  
5 PCB Layout Optimizing trace...      
6 Decoupling Capacitors Placing capacitors... 
7 Twisted Pair Wiring Twisting wires...      
8                                5

The count 5 in cell C8 shows how many techniques end with 'ing'.

Sheet Trace Quiz - 3 Questions

How many techniques in the list end with 'ing'?

A 5

B 4

C 6

D 3

Key Result

COUNTIF(range, "*ing") counts cells in range ending with 'ing'.