A blog by Oleg Shilovitsky
Information & Comments about Engineering and Manufacturing Software

PLM Excel Spreadsheets: From Odes to Woes

PLM Excel Spreadsheets: From Odes to Woes
olegshilovitsky
olegshilovitsky
26 May, 2009 | 3 min for reading

Although I love my PLM Spreadsheets, it is a sort-of “Love and Hate” relationship. Since it’s so easy to start with Excel, we always do…, but what is the price of this easy move? So, I decided to follow-up my love letter to Excel with some “hate” statements.

1. It becomes complex within time. You always start with something simple to do. A few columns; simple formulas. But life adds additional parameters, and data to manage…. and then you can hardly manage it at all. You don’t remember all your excel dependencies. The Copy/Paste you loved in the beginning is no longer an easy task…

2. You cannot change it easily. At the beginning of your Excel story, it seems so easy to change. You can send it to any person, add information, delete, manage reports, etc. But as time goes by, nobody remembers the really good relationships you built in Excel. To touch data in Excel becomes so complex! I’ve seen many organizations who have an “Excel Manager” duty. These people are called “mission critical Excels”.

3. Data is not only in Excel. Your PLM life is not in Excel only. A lot of information exists in CAD, Designs, ERP, or in additional legacy applications. In my view, Excel is a very bad integration tool. You cannot easily point to information residing in other systems. But to manage these relationships, it’s really important to have the right data in your hands when you need it.

4. Where is my latest Excel? I’m sure you have asked this question many times. Is it the one connected to your mail? Is it the one on your laptop, or is it the one in SharePoint? When you have multiple Excels, and especially if you have multiple versions of these Excels, you will really be lost…

5. Hidden cost of dependencies. At the beginning of the Excel journey, it so easy to send an Excel file to your colleagues. You just attach it to your mail and it’s delivered. But as soon as your Excel becomes complex such as being connected to other data sources or linked to other Excels, you cannot encapsulate it so easily. So, sometimes sending it via email isn’t so trivial.

What is my conclusion?

I still really like my PLM Excel, but before building my PLM system on Excel grounds, I would like to try to find ways to avoid these hidden Excel problems. How should I do this? Keeping it simple is a good recommendation in theory, but not always easy an easy task to put into practice. I will think about a few recommendations and possible solutions and will come back to you in future posts. I’ll record the recommendations in an Excel sheet before posting them here. Or maybe not….

[UPDATE 2021] There is a better way. I built openbom.com to help many engineers, manufacturing, and construction companies to solve this age pain of managing BOMs and product information in Excels. Please check this out – openbom.com. The registration is free. 

Best, Oleg 

Disclaimer: I’m co-founder and CEO of OpenBOM developing a digital network-based platform that manages product data and connects manufacturers and their supply chain networksMy opinion can be unintentionally biased.

Recent Posts

Also on BeyondPLM

4 6
25 December, 2015

My recent article “What is wrong with PLM of Things? led me to have discussions online and offline about integration of IoT and...

5 July, 2019

AI is a new trend. It brings a new wave of technological disruption across industries. Think about Web and Mobile...

7 April, 2024

The complexity of products has grown enormously for the last decade. The growing number of manufacturing companies are moving their...

9 January, 2017

Talk to any manufacturing company and they can easy convince you that their products, environment, engineering and manufacturing processes are...

18 February, 2014

While industry is clearly moving to the cloud, the question about choosing right cloud model is getting more important. In my...

3 October, 2012

I’m in Moscow these days to attend the first Autodesk University Russia (AU.Ru). Even so, I feel like attending multiple...

16 June, 2015

Culture can eat strategy for breakfast and technology for lunch. When it comes to PLM, the implementation and organizational alignment...

16 February, 2018

I’m polishing my presentation for PLMx conference next week in Hamburg. If you haven’t heard about the event, check here...

3 June, 2016

Integration is hard. Especially when it comes to such complex environment as engineering and manufacturing. Zerowait-state article PLM Dilemma and...

Blogroll

To the top