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
31 May, 2010

I was reading ‘Why does Facebook fail for Product Development? (and how to fix it)” article by Jim Brown. Jim...

6 February, 2018

I’m attending SOLIDWORKS Word this week in sunny Los Angeles. It is an annual pilgrimage of Solidworks users from all...

14 September, 2012

File Sharing on the cloud. Who is not doing it these days? It sounds so simple and straightforward. Dropbox was...

19 June, 2019

Many years ago, I’ve been following research papers of George J. Klir related to system approach in solving problems. My...

20 July, 2012

Let’s talk about User Interface today. Something that we call UX (User Experience) nowadays. The importance of user experience can...

12 February, 2025

A few days ago, my attention was caught by a picture shared by Jeff Winter – optimization vs transformation. I...

30 November, 2010

Vendor Lock-In is painful. I think, customers in the space of CAD/PLM even more sensitive to this issue. Proprietary CAD...

27 October, 2018

Data was always in the center of any PDM and PLM applications. The ability of PLM system to manage complex...

18 October, 2012

Open Source Software (OSS) is a wonderful thing. For the last decade, open source changed the world of software development....

Blogroll

To the top