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
14 January, 2010

I’m happy to inform you that mobile version of Daily PLM Think Tank on iPhone is available now. Search for...

6 July, 2015

In engineering world, digital vs. analog differentiation can be explained in a very precise manner –  analog is using electrical signals. Opposite...

10 April, 2020

Yesterday was the Passover evening. This is a usual time for family and friends to get together around the table....

27 April, 2011

I’m attending Aras Community Event 2011 these days in The Henrly Hotel in Dearborn, MI. You can have more information...

26 April, 2017

For long time, enterprise integration is one of the biggest challenges manufacturing companies are facing during PLM implementations. PLM integration can be...

3 January, 2013

It is always interesting to take a look and see what posts drove the most attention of my readers in...

10 March, 2011

Virtualization becomes an important piece of modern technological solutions. The time of physical servers is over. Businesses are actively seeking...

19 February, 2010

When somebody is asking me what is the number one PLM software problem, my instant answer is – complexity. Yes,...

10 April, 2018

If you always do what you always did, you’ll always get what you always got. Often Henry Ford is credited...

Blogroll

To the top