The ugly truth about digital transformation – first, get rid of spreadsheets

Oleg Shilovitsky
Oleg Shilovitsky
24 April, 2019 | 3 min for reading
The ugly truth about digital transformation – first, get rid of spreadsheets

Digital Transformation is one of the fanciest words in a modern lexicon of technologist, strategist and marketing people. Digital is such a sweet word. It makes you feel happy just by saying it. Unfortunately, “digital transformation” marketing gives a false sense of power. It feels like just by saying word digital, companies can transform themselves and push forward in a new trajectory.

My attention was caught by Aras PLM blog – Live from ACE 2019. The following passage was my favorite.

It’s easy to get excited about AI, AR, and the 3D visual experience. However, let’s be real. The first step is to get rid of your spreadsheets and paper documentation – to get an accurate product data baseline. We’re not just talking a digital CAD model, but data that includes access to performance data, as-built parts, and previous maintenance work history for everyone from technicians to product managers.

The passage was resonating with what I can see a brutal reality of many manufacturing teams, contractors and suppliers using OpenBOM. Majority of the companies coming to OpenBOM are using Excel or Spreadsheets. They love the flexibility and use it often. All of them are getting to the point when spreadsheets cannot be used as a reliable source of information and communication.

The story is very much repeating, so you can wake me up in the middle of the night and I can tell it to you. Here is an outline, I’ve heard literally thousands of time.

1- Our company is creating the design and then need to communicate product information between members of the team to finalize Bill of Materials.

2- We pull the information into Excel and send it to team members using email. After some time we’ve got lost and barely can find latest Excel.

3- After we have done, the information is manually imported into ERP system. Mistakes are normal, so information going to ERP is not exactly the one team worked on.

At OpenBOM we created some fundamental technologies helping to automate BOM creations, share BOM between members of the team and across multiple organizations and later to import BOM automatically in ERP systems.

The following 3 videos can give you some examples of these process and how OpenBOM helps companies to overcome communication and data management challenges while helping to escape spreadsheets.

This is an example of how easy OpenBOM can get data from CAD system and create BOM including all information and references to CAD files and PDFs

Next video gives you an idea of what means real-time collaboration and how teams can “stay on the same BOM” while located in different countries and geographies.

Finally, this video shows you how simple to push data from OpenBOM to ERP system (it can be any downstream system).

Conclusion.

OpenBOM is simplifying data management for manufacturing teams. Easy import from Excel of CAD tools allows you to bring data and escape Excel data management. Real-time collaboration in OpenBOM allows you to share information easily. Open API and export tools solve the problem of downstream information sharing. All together, OpenBOM helps you to escape the misery of Excel BOM management.

Check OpenBOM today by registering to a FREE user account.

Best, Oleg

P.S. 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
15 March, 2024

In the complex landscape of product development, managing costs efficiently is paramount for success. Yet, traditional methods such as spreadsheets…

15 March, 2024

What manufacturers need in a supplier when they are a startup is usually going to be different than what they…

14 March, 2024

Revision control, an integral part of Product Data Management (PDM) and Product Lifecycle Management (PLM) systems, plays a crucial role…

12 March, 2024

In today’s dynamic engineering and manufacturing processes, managing changes effectively is crucial for organizational success. Whether it’s product design alterations,…

9 March, 2024

In the complex world of product data management, where dependencies and components intertwine across multiple levels, having the ability to…

8 March, 2024

Taking your product idea from concept to product launch and successfully selling your product takes a lot of work. In…

8 March, 2024

Earlier today, we hosted our (almost regular) OpenBOM Live Demo Sessions. Keep in mind that if you missed one of…

6 March, 2024

In engineering and manufacturing, data is inherently structured and interconnected. This starts with basic assembly-component relationships and expands to encompass…

5 March, 2024

In the evolving landscape of digital transformation, companies are increasingly moving away from traditional, often manual systems towards more sophisticated,…

To the top