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
17 June, 2019

I continue to reflect on everything I’ve learned last week at PTC LiveWorx. One of the most important messages was...

23 July, 2010

I want to talk about what I consider as one of the most controversial topics in the industry – PDM...

21 July, 2010

Data formats is an interesting topic in the context of engineering and manufacturing. Manufacturing company is relaying on a significant...

6 April, 2012

One year ago, I posted – PLM and Post-PC era. It is interesting to read back and think about the...

23 June, 2016

Unless you live under a rock, I’m sure you’ve heard about one of the largest acquisitions in tech world – Microsoft...

10 August, 2013

Customization is a great deal in every enterprise software deployment. Despite all efforts of vendors to invent out of the...

24 August, 2011

Communication methods are interesting. These days lots of things are changing in this space. Internet, Web 2.0, Video communication converted...

3 October, 2020

A single source of truth is the paradigm that sells PLM and many other systems. PDM and PLM providers used...

15 October, 2013

My recent post about top pros and cons to have a special CAD file sharing tools drove some interesting conversation...

Blogroll

To the top