Design review checklist in PCB Design - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to check if all components have footprints assigned.

PCB Design

IF(ISBLANK([1]), "Missing footprint", "OK")

Drag options to blanks, or click blank then click option'

AComponents[Footprint]

BComponents[Value]

CComponents[Reference]

DComponents[Layer]

Attempts:

3 left

💡 Hint

Common Mistakes

Checking the Value or Reference fields instead of Footprint.

The footprint field defines the physical package of a component. Checking if it is blank helps identify missing footprints.

2fill in blank

medium

Complete the code to calculate the total number of nets in the design.

PCB Design

COUNTROWS([1])

Drag options to blanks, or click blank then click option'

AComponents

BPads

CLayers

DNets

Attempts:

3 left

💡 Hint

Common Mistakes

Counting Components or Pads instead of Nets.

The Nets table contains all the electrical connections. Counting its rows gives the total nets.

3fill in blank

hard

Fix the error in the expression to find components missing designators.

PCB Design

FILTER(Components, [1] = "")

Drag options to blanks, or click blank then click option'

AComponents[Footprint]

BComponents[Designator]

CComponents[Value]

DComponents[Layer]

Attempts:

3 left

💡 Hint

Common Mistakes

Filtering by Value or Footprint instead of Designator.

The Designator field identifies components uniquely. Filtering where it is empty finds missing designators.

4fill in blank

hard

Fill both blanks to calculate the count of components on the top layer.

PCB Design

COUNTROWS(FILTER(Components, [1] = [2]))

Drag options to blanks, or click blank then click option'

AComponents[Layer]

B"Top"

C"Bottom"

DComponents[Value]

Attempts:

3 left

💡 Hint

Common Mistakes

Using Value field or wrong layer name in filter.

Filtering Components where Layer equals "Top" counts components on the top PCB layer.

5fill in blank

hard

Fill all three blanks to create a measure that sums the total component count by value for resistors.

PCB Design

SUMX(FILTER(Components, [1] = [2]), [3])

Drag options to blanks, or click blank then click option'

AComponents[Value]

B"Resistor"

C1

DComponents[Footprint]

Attempts:

3 left

💡 Hint

Common Mistakes

Summing Footprint or wrong filter value.

This sums 1 for each component where Value equals "Resistor", effectively counting resistors.