Arena Blog

How to find where a component is used in your BOMs: Arena BOMControl vs. Excel

linked-in icon twitter-icon facebook-icon

If you make a change to one of the components on a bill of materials (BOM)—say you’ve found a superior component or your current component is going end-of-life—you need to know with complete confidence whether the component appears in other BOMs. Not knowing where a component is used isn’t just inconvenient, it can also cause scrap and rework if a modification intended for one BOM continues to cause problems in another.

How do you find where a component is used in your BOMs in Excel?

If you manage your BOMs with Excel, you have to open each spreadsheet and manually search for the component. Keep in mind that searching in Excel is no picnic—I know I’ve missed things because Excel searched the cell I was in rather than the whole spreadsheet. And in a company with active new development, multiple engineers each consulting spreadsheets on their own desktop, and multiple products with multiple revisions—just finding the right BOMs to comb through can be a hassle.

How do you check where a component is used in your BOMs in Arena BOMControl?

When you drill into a component in Arena BOMControl, you get a single aggregated list of every BOM that contains the component, whether at the first level or the fifth.

Here’s an example of what a BOM looks like in BOMControl—every BOM line has a pop-up that tells you where else a component is used.

Arena BOMControl where used

BOMControl even tells you if the part is used as a substitute in another BOM.

BOMControl in Arena

And if you include a component on a change order, BOMControl automatically notifies you of other assemblies that reference that component, and give the option to include those assemblies on the change order before submitting.

When comparing BOMControl with Excel, there’s simply no competition. Better where-used functionality is built into BOMControl, helping you make informed part choices and save time searching through spreadsheets.

About the Author

Chris Vickery

Chris woke up one day and realized he had been at Arena since 2005, creating all of the user manuals and written content in BOMControl. He can usually be found ...

Read More 


Why You Should Be Using The Pdx File Standard The point of purchasing a PLM or PDM system is to simplify and centralize your BOMs and other product data. ...
Read more

Intelligent vs. non-intelligent part numbering – who's winning the debate? Your part numbering scheme is ultimately adopted by every team with a stake in product development—from design and engineering to ...
Read more

MVP—Minimum viable product An MVP strategy allows product developers to work more closely with customers and align product features to actual use. Recently, ...
Read more