Bird
0
0
PCB Designbi_tool~10 mins

Version control for PCB projects in PCB Design - Cell-by-Cell Formula Trace

Choose your learning style9 modes available
LearnWhyDeepSheetTryChallengeScenarioRecallDash
Sample Data

This table shows PCB project versions with dates and change descriptions.

CellValue
A1Project
B1Version
C1Date
D1Changes
A2MainBoard
B2v1.0
C22024-01-10
D2Initial design
A3MainBoard
B3v1.1
C32024-02-15
D3Added USB port
A4SensorModule
B4v2.0
C42024-03-05
D4Updated sensor layout
A5MainBoard
B5v1.2
C52024-04-01
D5Fixed power circuit
Formula Trace
MAXIFS(B2:B5, A2:A5, "MainBoard")
Step 1: Filter versions where Project = "MainBoard"
Step 2: Find max version from ["v1.0", "v1.1", "v1.2"]
Cell Reference Map
    A        B        C          D
1 |Project |Version |Date     |Changes
2 |MainBoard|v1.0   |2024-01-10|Initial design
3 |MainBoard|v1.1   |2024-02-15|Added USB port
4 |SensorModule|v2.0   |2024-03-05|Updated sensor layout
5 |MainBoard|v1.2   |2024-04-01|Fixed power circuit

Formula references B2:B5 for versions and A2:A5 for projects.
The formula uses the Version column (B2:B5) filtered by Project column (A2:A5) to find the latest MainBoard version.
Result
    A        B        C          D
1 |Project |Version |Date     |Changes
2 |MainBoard|v1.0   |2024-01-10|Initial design
3 |MainBoard|v1.1   |2024-02-15|Added USB port
4 |SensorModule|v2.0   |2024-03-05|Updated sensor layout
5 |MainBoard|v1.2   |2024-04-01|Fixed power circuit

Result: Latest MainBoard version is v1.2
The formula result shows the latest version for the MainBoard project is v1.2.
Sheet Trace Quiz - 3 Questions
Test your understanding
Which versions are considered when finding the latest MainBoard version?
A["v2.0"]
B["v1.0", "v2.0"]
C["v1.0", "v1.1", "v1.2"]
D["v1.1", "v2.0"]
Key Result
MAXIFS(range_to_maximize, criteria_range, criteria) finds the maximum value in a range filtered by criteria.