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

PLM and One Big Spreadsheet

PLM and One Big Spreadsheet
olegshilovitsky
olegshilovitsky
12 May, 2010 | 2 min for reading

Everybody in the engineering and manufacturing loves MS Excel. I had chance to write about it multiple times before. You can take a look on few of my previous talks about MS Excel and PLM- Why do I like my PLM Spreadsheets? and PLM Excel Spreadsheets: From Odes to Woes. The reaction of customers on using spreadsheets in PLM is always positive. In my view, there are few aspects why Excel is welcome in the engineering communities- flexibility, granularity and ownership. You can always define what you want, format it in the way you want and what is the most important piece – own it! Nobody will take your Excel file. You can keep it everywhere, you can access it anytime, and you can do with this everything. There is no special licenses, no training needed. However, the biggest disadvantage of such a way is NO collaboration. Yes, you can send your Excels back and forth via email, but this is not what I’d call collaboration in the modern world.

Real Time Collaboration and Spreadsheets
Google and Microsoft are two companies that understand the power of spreadsheets very well. These days both companies are working to take Excel and spreadsheets to the next level of collaboration. You can see recent announcement of last version of Google docs is presenting ability to work collaboratively on Google Docs. Together with new features that closing some of the gaps with MS Excel, you can see Google Spreadsheets as a decent tool to take care of PLM data.

[youtube=http://www.youtube.com/watch?v=6_hJ3R8jEZM&]

In parallel, coming announcement of Microsoft SharePoint 2010 later this week will introduce new set of the functionality a-la Excel related to data handling in the spreadsheet and collaboration. Microsoft Excel Services is a very interesting technology started in SharePoint 2007 and getting many enhancements in the new version of SharePoint

[youtube=http://www.youtube.com/watch?v=kxWe4bwdyzk&]

PLM Big Spreadsheet
I see spreadsheet as a way to innovate in PLM. In the end, if this is the best way to collaborate between people in design, engineering and manufacturing, we can take it as a lowest possible denominator in our PLM applications. I found multiple time during meeting with customers, the capabilities of PDM/PLM products compared with capabilities of Excel or spreadsheets. Think about mapping all PLM data you have to a single big spreadsheet and give it to users.

What is my conclusion? In my view, PLM needs to shift strategies in achievement of sophisticated features. Low gear… The next PLM sophistication can come from the side of simplicity. Make all requirements, documents, BOMs, manufacturing plans available in Excel-like format and give it to customers. This will be One Big PLM Spreedsheet. I think it will be cool. What is your take on this?

Just my thoughts…
Best, Oleg

Share

Recent Posts

Also on BeyondPLM

4 6
6 December, 2019

Everyone needs data. But nobody wants to manage it. I’ve learned it for many years of working with the engineering...

4 May, 2016

Many years ago, I’ve been writing applications for AutoCAD. Back in that days, AutoCAD was a starting point for engineers...

24 December, 2008
4 August, 2009

Thank you for Jim Brown’s post yesterday. Why is implementing PLM is hard? Now, I’m officially starting my collection of...

1 April, 2012

Note, this is NOT 1st April post :). Multi-CAD and PLM. Endless story… Few weeks ago, I published my post The...

12 July, 2016

It usually takes time to implement PLM system. One of the reasons for that is heavy customization and adaptations of...

9 December, 2008

Mashup technologies started first as web applications that combined data from multiple sources into single integrated tool. In many cases...

10 December, 2023

The credit for the picture above goes to Martin Eigner book about System Lifecycle Management. I’d like to continue the...

12 December, 2021

For the last decade, PLM and information technology have become the foundation for building a competitive edge. PLM expanded and...

Blogroll

To the top