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.


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
23 February, 2024

In the space of product lifecycle management (PLM), a very important question usually triggers many discussions: Should companies first refine…

22 February, 2024

In the complex world of purchasing and supply chain management, navigating through the complexities of product records, Bills of Materials…

21 February, 2024

I haven’t had a chance to meet a manufacturing company that was not interested in cost analysis or cost management….

20 February, 2024

I’m excited to share with you the latest updates to OpenBOM. But before we delve into the details, I want…

17 February, 2024

Despite the widespread adoption of digital technologies like computers, mobile devices, the internet, and various digital services, Excel continues to…

16 February, 2024

Dealing with mistakes made by suppliers is a crucial aspect of managing manufacturing processes and ensuring product quality and timely…

16 February, 2024

In the rapidly evolving landscape of modern product development, the complexity and need for collaboration are at an all-time high….

14 February, 2024

Bill of Materials (BOM) management is an essential component of product development, manufacturing, and supply chain management processes. These processes…

13 February, 2024

Newton, MA  – OpenBOM, a leading provider of cloud-based PDM and PLM software helping manufacturing companies to manage their digital…

To the top