Enhancements of OpenBOM Formula Editor and Calculations 

Oleg Shilovitsky
Oleg Shilovitsky
25 July, 2019 | 2 min for reading
Enhancements of OpenBOM Formula Editor and Calculations 

The calculation is an important part of the Bill of Materials. I’m sure don’t need to explain why. OpenBOM does have some very unique and powerful calculations features allowing you to do things that are pretty much beyond what you can accomplish with Excel. Think about making roll-ups of cost, mass and other things in multi-level Bill of Materials. I’ve been talking to some engineers using OpenBOM and they have been honest by saying that OpenBOM calculation feature can save tons of time. 

We are working to make it extremely powerful is that not only you can make roll-ups and calculation, but also it combined with flexibility and simplicity of data management in OpenBOM. In fact, these level of simplicity and flexibility is beyond what sophisticated PLM and ERP systems can do. 

All these things I mentioned above are available and you can use them. Today, I want to give you some preview of what is coming next in calculations and formula editor. In the coming release we are going to introduce new functions in formulas to support parentheses to change the order of operations and make it more sophisticated. Those of you who created additional properties for intermediate results can now take a deep pain relief breath. You won’t need it anymore. In a new release, you will be able to make formulas like on the picture above – using arithmetic operations and changing operations order. 

So, in the BOM below, you will be able to apply calculation and combine assembly and material cost with some additional extra. 

In the video below I demonstrate how it works. I hope you will like both, the appearance of new formula edit as well as new features. More functions are coming in formula and calculations later in August.

Conclusion. 

Calculations are extremely important. We are paying huge attention to that by supporting an easy way to extract data from the CAD system and/or Excel, transform it in OpenBOM and make the calculation and other analysis that can help you to develop products faster and without mistakes. 

I hope you will like it. 

Best, Oleg @ openbom.

Let’s get to know each other better. If you live in the Greater Boston area, I invite you for a coffee together (coffee is on me). If not nearby, let’s have a virtual coffee session — I will figure out how to send you a real coffee.

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

Related Posts

Also on OpenBOM

4 6
18 July, 2025

Managing product data is no longer just about locking files in a vault. Modern engineering teams work across disciplines such...

17 July, 2025

Every product starts with an idea—but to turn that idea into a real, physical thing, you need structure, coordination, and...

16 July, 2025

Let’s talk about part numbers today. Every engineering team and manufacturing company needs a clear, consistent part numbering strategy. But...

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...

To the top