BOM management/cross-referencing

From circuitbending to homebrew stompboxes & synths, keep the DIY spirit alive!

Moderators: Kent, luketeaford, Joe.

Post Reply
Learning to Wiggle
Posts: 22
Joined: Thu Aug 16, 2018 1:38 pm

BOM management/cross-referencing

Post by DJ_JITTER » Tue Oct 23, 2018 1:16 pm

I've got a few builds on the horizon that'll probably share quite a few parts. Does anyone have any tips or software that makes it easy to see how different BOMs match up? It'd be nice if I could have each project as a sheet in Numbers or Excel and automatically match two different resistors as 0603 100kOhms despite having different part numbers on each build.

User avatar
Eric the Red
Ultra Wiggler
Posts: 767
Joined: Tue Jun 02, 2015 12:43 pm
Location: Detroit, MI

Post by Eric the Red » Tue Oct 23, 2018 2:24 pm

You could probably do a V Lookup in Excel?
Tab 1: Part #’s
Tab 2 - X - Each BOM

In Tab 1, Part # would be column A, and column C -X could represent each BOM you have. You could colum B to add everything up in each row.

Abandon all hope, ye who wiggle.

Post Reply

Return to “Music Tech DIY”