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
3 June, 2012

Files. It is so obvious, right? We are using files everywhere in our life. Documents, Pictures Photos, Excel spreadsheets, CAD...

23 September, 2010

I want to talk about licenses. The topic I’d normally prefer to avoid. Deelip Menezes made a good post about...

9 September, 2011

During the past months, I’ve seen an increased amount of conversations about the future of App Store software model in...

19 June, 2019

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

14 December, 2008

    I want to continue my first PLM Glue Technologies topic (#1 was about data). Sunday is good time...

13 June, 2018

Ola Rollen, CEO of Hexagon started his HxGN LIVE keynote from a heartbreaking video. Greenland’s barnacle goslings undergo one of...

7 May, 2013

Mobile is hyping, trending, skyrocketing… You name it. Everything goes mobile these days. Many developers of enterprise apps are asking...

30 May, 2025

Earlier this week, I had the chance to present at the Share PLM Summit 2025 in Jerez de la Frontera....

16 June, 2024

Timing is everything in business. Manufacturing industry combining supply chain management, product lifecycle and product development process are offering a...

Blogroll

To the top