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 July, 2020

I’m catching up more on Siemens RealizeLIVE and today I want to talk about flexibility and customization. I learned about...

2 August, 2016

Our environment is getting more distributed then ever. The borders between work, home and mobile environments are blurring. What is the...

4 February, 2015

3D printing is changing the way we can manufacturing products. Which potentially means changes in how companies are going to...

14 April, 2016

Manufacturing companies are owning large volumes of engineering data in CAD files, PDF and other formats derivatives from design. One...

23 September, 2011

I wanted to talk about Windows 8 today. Despite lots of talks we had about Macs, iPads and web during...

21 August, 2014

The new normal – we need less money to build software these days. My attention caught Andreessen Horowitz article The...

23 March, 2016

Desktop virtualization is a technology that separates you desktop environment and installed apps from the physical computer. It became popular...

25 November, 2009

The Google Wave invites pushed to the community for the last 1-2 months are starting to bring some fruitful results....

21 July, 2010

I read MCADCafe article – PLMIG announces a 10-Year PLM Industry Vision. It navigates you to PLM IG (Interest Group) where...

Blogroll

To the top