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

How PLM can beat Excel? Or Blue Ocean’s ideas on how to improve usability…

How PLM can beat Excel? Or Blue Ocean’s ideas on how to improve usability…
olegshilovitsky
olegshilovitsky
2 March, 2009 | 2 min for reading

It looks like PDM is constantly running after Microsoft Excel. Lately PLM has also joined the chase.… While looking at the history of Excel applications, I’ve noticed a number of features in PDM/PLM systems that have been repeated systematically after similar features were introduced in MS Excel. In release after release, you can see sort, filter, groups, nested trees, etc.

 

Actually, PLM vendors are pretty aware about such competition. You can see multiple blogs and white papers comparing Excel capabilities and explaining why particular work can be done better in PLM compared to Excel. On the other hand, Excel provides people with a very flexible and open environment in which people can feel very secure about the way they manipulate data. In my opinion, this is a key reason for the continuing popularity of Excel. The PLM environment delivers specific functionality (i.e. for Bill of Material management) but put constraints on data manipulation. Therefore, in the end, it loses potentially attractive features.

Each new release of PLM software creates new features that simulate Excel capabilities on top of data models and constraints that Product Data Management established. So, how do you break this cyclic development and make customers happier?

In my view, the adoption of MS Excel services is a viable option to steer away from this feature competition. Excel services is one way to improve the PLM/Excel relationship, improve user adoption and get more functionality for the PLM environment.



PLM systems need to map the data models and PLM services to an Excel service model. It will allow you to render data and use more functionality inside of Excel So, useful data manipulation such as sorting, filtering and others will be easy available for the product development environment. In addition Excel services will not require data to be copied/imported/exported. Actually, Excel service-based implementation will be more SOA compliant and improve data consistency inside the organization.

I’d like to know if you have any experience with Excel services in your organization or have tried to implement it as part of your software.

Recent Posts

Also on BeyondPLM

4 6
17 May, 2016

Few weeks ago I posted a story about cloud CAD and Dropbox Infinite Project. Apparently it was not only me...

5 August, 2009

Product Lifecycle Management is going full speed to social tools and technologies. With two companies, PTC and DS articulated their...

14 July, 2010

Social is trending these days. We can see this, analyzing the broad change in the Internet trend usages these days....

9 February, 2016

I’m slowly digesting news from Solidworks World 2016, which took place last week. You can take a look on some...

20 August, 2012

Despite hot weather and summer vacation time, I can see quite many cloud discussions trending around. I was following OSCON...

28 November, 2024

Product Lifecycle Management (PLM) is a concept that has been around for decades. Being in this business for the last...

7 January, 2024

The complexity is on the rise in the modern manufacturing industry and industrial companies. There are multiple dimensions of the...

31 March, 2021

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

19 June, 2014

This week is very fruitful for PLM events. PTC Live 2014, Siemens PLM connection, GrabCAD media event. Twitter and other...

Blogroll

To the top