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
31 March, 2021

I had a conversion earlier this week about the BOM revision process. I used the abbreviation “FFF” in my response...

25 April, 2016

Process is one of the fundamental elements in existing product lifecycle system. Most of existing PLM systems are build around...

10 July, 2013

Mobile development is skyrocketing these days. Everybody wants to be mobile. Enterprise vendors slowly discovering the power of mobile apps....

23 November, 2015

Last week at PI Congress in Boston, I attended the presentation – Utilizing Industrie 4.0, IoT and Related Platforms to...

29 January, 2023

It is 2023 and any manufacturing company in the world at a certain moment of its existence will ask a...

6 December, 2008

  How to improve PLM processes before PLM system using BPMN. In many situations when I talked with customers they...

8 July, 2010

Almost two months ago, I had a chance to read a blog article by Mobile Beat with some intriguing name...

23 November, 2018

There are roughly 6,500 spoken languages in the world today. However, about 2,000 of those languages have fewer than 1,000...

24 January, 2013

Many years ago, one of my mentors told me that “the worst pencil is better than the best memory”. I...

Blogroll

To the top