Video blog #8: BOM Beyond Excel

Oleg Shilovitsky
Oleg Shilovitsky
1 May, 2020 | 2 min for reading
Video blog #8: BOM Beyond Excel

In this video, I talk about how to stop using Excel and move to OpenBOM. In fact, most of engineers and companies I meet are convinced that Excel is not good, but they scary of making a change. Excel (or spreadsheet) looks like something they familiar with even it is very bad and leads to many costly mistakes. 

At OpenBOM, we invented a model that can help you to move from Excel to OpenBOM to manage product structure (BOMs) and related data.

1- Catalog (s) 

It is a centralized database of all information about items. Think about it as you Excel with all information such as manufacturer, cost, supplier, description, etc. Every item in catalogs is associated with Part Number. 

2- Bill of Materials with reference-instance model 

Bill of Materials is data about how items used in products. It includes reference instance model capable to connect parts to catalog information as well as parent-child relationships automatically created based on Part Numbers between BOM (Assembly) and items in Assembly BOM. 

3- Multi-level / Flattened BOM 

At any moment of time, you can switch between multi-level (structure BOM) and flattened BOM to provide quantity rollup. 

Watch the video for more details:

Conclusion

All together – catalogs, BOMs, and Flattened models give you a foundation to remove the biggest pains of Excel BOM management. You have a single version of the truth about items (no need to copy / paste between excels), allows you to manage structure (instead of limited Excel indentation and levels), and automatically rollup data (eg. quantity) between multiple levels. 

Check OpenBOM now by registering an account here

Best, Oleg @ openbom dot com.

Want to learn more about PLM? Check out my Beyond PLM blog and PLM Book website

Read OpenBOM customer reviews on G2 Crowd to learn what customers are saying about OpenBOM. 

Related Posts

Also on OpenBOM

4 6
15 July, 2025

How did Abram Scientific replace spreadsheet chaos with seamless CAD and BOM integration using OpenBOM?  In product development—especially in medical...

11 July, 2025

If you work in manufacturing or procurement, you already know the struggle. You need STEP files for CNC programming, PDF...

10 July, 2025

We are excited to share that OpenBOM now offers a completely revamped integration with QuickBooks, bringing your engineering, inventory, and...

9 July, 2025

A few days ago, I posted an article titled Is your data BOMable?, where I explored the readiness of your...

8 July, 2025

Let’s be honest – keeping track of accurate Bills of Materials (BOMs) is one of the biggest challenges in engineering...

3 July, 2025

Walk into any engineering office today, and you’ll see it immediately: Excel open on someone’s screen. Spreadsheets have been the...

2 July, 2025

Engineers rarely build entirely new products from scratch. Whether designing machinery, electronics, or high-tech projects, most products are evolutions of...

1 July, 2025

At OpenBOM, our vision has always been clear – to create an open and flexible information model, built using modern...

30 June, 2025

At OpenBOM, we know that managing changes is one of the most critical – and often challenging – aspects of...

To the top