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

Why Do I Like My PLM Excel Spreadsheet?

Why Do I Like My PLM Excel Spreadsheet?
olegshilovitsky
olegshilovitsky
25 May, 2009 | 2 min for reading

I think I will not surprise you with the statement: “the biggest market share in PDM/PLM belongs to Microsoft Excel”. If you disagree, please let me know. So, I wanted to share some thoughts about why I think that Excel is beneficial for PLM…

Below are the top five reasons why I prefer working in Excel to manage my product data and product lifecycle:

  1. Simple. Simple means simple. The idea is simple – one big table. You don’t need training. You can start right now. You realize that “simple is not as simple as you think” as your spreadsheet grows – but until you get there, you are a happy user :).
  2. Flexible. To plan how to manage product data and lifecycle in your organization, you need to spend time and effort. But if your tools are on a white board and flexible to the level of “one size fit all”, you can start right now. The flexibility of Excel allows you to grow as you go. You don’t need to have models – just put your data and search it afterwards.
  3. Absorb any type of data. Often I’d like to be able to introduce a new type of data. MS Excel is there to help you with this. You can easily create a new workbook, worksheet, add columns, delete columns, etc. The beauty of a spreadsheet is that it is all-inclusive J… when you think about vendor-related stuff…
  4. I physically own it. This is true. If you have xls(x) files, you don’t need to be concerned with how to save, copy, and transfer your data. The feeling of ownership of your work is very important and people appreciate it.
  5. Transferable.  This is comes with files. I can send them to anybody. I can control how the files are saved and maintained. So, I can transfer them inside and outside of the organization to facilitate collaboration.

…and one more –

  1. SharePoint friendly. My story nowadays is not complete without saying a few words about working together with Office files and SharePoint. SharePoint provides a new way to manage Office (Excel) files – Excel services and almost transparent conversion between SharePoint lists and Excels. Office Excel files and data are well organized and the content is easy to find.

What is my conclusion?

The bottom line is that Excel spreadsheets have a lot of value in the context of what we are doing in PDM/PLM. But they are failing miserably and this is what is my next blog is about. Just my thoughts…

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
30 May, 2021

The calls to simplify PLM systems are not something new in the industry. Although industry pundits might keep arguing about...

16 November, 2011

ROI is an important topic, and many times I’ve seen customers are not focusing on ROI assessment before starting PDM/PLM...

14 August, 2013

You probably remember my earlier post – PLM cloud concerns and dropbox reality for engineers. My hunch of the corporate reality...

26 November, 2011

Many of the engineers (and not only) are using Microsoft Excel. People are literally lives inside of Excel spreadsheets. When...

19 December, 2016

Last year I’ve made a crazy prediction that your next PLM workflow manager will be a bot. As much as...

13 October, 2009

First of all, I’m sorry about such a topic. Yes, Usability! I think we have been talking about usability for...

1 February, 2025

Martin Eigner’s recent post, 40 Years of PDM/PLM: The Status Quo and the Future (LinkedIn post), caught my attention earlier...

17 February, 2019

I’m continuing to digest and share information about what I’ve seen last week at Solidworks World 2019 in Dallas. Today...

30 October, 2022

Part numbers are hard. Period. There is no topic in engineering and manufacturing organizations that triggers more debates and potentially...

Blogroll

To the top