Pull-up and pull-down resistors in schematic in PCB Design - Real Business Scenario

Scenario Mode

👤 Your Role: You are an electronics design analyst working with PCB schematics.

📋 Request: Your manager wants a report showing how pull-up and pull-down resistors are used in the current schematic designs to ensure signal stability.

📊 Data: You have a dataset listing schematic components with columns: ComponentID, Type (Resistor, Capacitor, etc.), Value (Ohms), ConnectionNode, Function (Pull-up, Pull-down, Other), and SignalName.

🎯 Deliverable: Create a dashboard report summarizing the count and distribution of pull-up and pull-down resistors by signal, including a chart showing their usage frequency.

Sample Data

ComponentID	Type	Value (Ohms)	ConnectionNode	Function	SignalName
R1	Resistor	10k	Node1	Pull-up	RESET
R2	Resistor	10k	Node2	Pull-down	ENABLE
R3	Resistor	4.7k	Node3	Pull-up	DATA
R4	Resistor	10k	Node4	Other	VCC
R5	Resistor	10k	Node5	Pull-down	CLK
C1	Capacitor	100nF	Node6	Other	RESET
R6	Resistor	10k	Node7	Pull-up	ENABLE
R7	Resistor	10k	Node8	Pull-down	DATA

1

Step 1: Filter the dataset to include only resistors with Function as 'Pull-up' or 'Pull-down'.

Filter rows where Type = 'Resistor' AND Function IN ('Pull-up', 'Pull-down')

Expected Result

Rows R1, R2, R3, R5, R6, R7

2

Step 2: Create a pivot table with SignalName as rows and Function as columns, counting ComponentID.

Pivot table: Rows = SignalName, Columns = Function, Values = COUNT(ComponentID)

Expected Result

Table showing counts of pull-up and pull-down resistors per signal: RESET(1 pull-up,0 pull-down), ENABLE(1 pull-up,1 pull-down), DATA(1 pull-up,1 pull-down), CLK(0 pull-up,1 pull-down)

3

Step 3: Create a bar chart visualizing the count of pull-up and pull-down resistors per signal from the pivot table.

Bar chart: X-axis = SignalName, Y-axis = Count, Series = Function (Pull-up, Pull-down)

Expected Result

Bar chart showing pull-up and pull-down resistor counts side by side for each signal

4

Step 4: Calculate total counts of pull-up and pull-down resistors across all signals.

Measure PullUpCount = COUNTROWS(FILTER(Table, Function = 'Pull-up')) Measure PullDownCount = COUNTROWS(FILTER(Table, Function = 'Pull-down'))

Expected Result

PullUpCount = 3, PullDownCount = 3

5

Step 5: Add a card visual showing total pull-up resistors and another for total pull-down resistors.

Use PullUpCount and PullDownCount measures in card visuals

Expected Result

Two cards showing 'Pull-up Resistors: 3' and 'Pull-down Resistors: 3'

Final Result

Bar Chart

↓

Cards

✓Pull-up and pull-down resistors are evenly used in the schematic with 3 each.

✓Signals ENABLE and DATA have both pull-up and pull-down resistors, indicating careful signal control.

✓RESET signal uses only a pull-up resistor, while CLK uses only a pull-down resistor.

Bonus Challenge

Create a measure to calculate the percentage of pull-up resistors relative to total resistors in the schematic.

Show Hint

Use COUNTROWS to count pull-up resistors and total resistors, then divide and format as percentage.