Zone priority for overlapping fills in PCB Design - Cell-by-Cell Formula Trace

Sample Data

This data represents three overlapping copper fill zones on a PCB. Each zone has a name, a priority number (lower number means higher priority), and the area it covers in square millimeters.

Cell	Value
A1	Zone Name
B1	Priority
C1	Area (sq mm)
A2	Zone 1
B2	1
C2	50
A3	Zone 2
B3	2
C3	30
A4	Zone 3
B4	3
C4	20

Formula Trace

MAXX(FILTER(Zones, Zones[Area (sq mm)] > 0), Zones[Priority])

Step 1: FILTER(Zones, Zones[Area (sq mm)] > 0)

Step 2: MAXX([Zone 1, Zone 2, Zone 3], Zones[Priority])

Cell Reference Map

    A         B         C
1 |Zone Name|Priority |Area    |
2 |Zone 1   |1        |50      |
3 |Zone 2   |2        |30      |
4 |Zone 3   |3        |20      |

The formula uses the Priority and Area columns from all zones to determine the highest priority number among zones with area greater than zero.

Result

    A         B         C         D
1 |Zone Name|Priority |Area    |Max Priority|
2 |Zone 1   |1        |50      |3          |
3 |Zone 2   |2        |30      |          |
4 |Zone 3   |3        |20      |          |

The result '3' in cell D2 shows the highest priority number among overlapping zones with area > 0, indicating Zone 3 has the lowest priority.

Sheet Trace Quiz - 3 Questions

Which zones are included when filtering by area > 0?

A Zone 1, Zone 2, Zone 3

B Zone 1 only

C Zone 2 and Zone 3 only

D No zones

Key Result

MAXX(FILTER(Table, Condition), Table[Priority]) finds the highest priority value among filtered rows.