Options to Streamline PLM Collaboration: Microsoft vs. Google

Options to Streamline PLM Collaboration: Microsoft vs. Google

After starting a massive Excel discussion last week and continuing this week, I got a lot of comments that I was too Microsoft-oriented. And, folks in Redmond, I love you, but we need to check whether or not this is blind love. I will not talk much about the Microsoft option. I think that Microsoft has a major market presence (I think some people commented on my Excel article they have seen about 90% of users are using Excel for BOM management). Excel is very popular, but becomes messy over time.

What are the alternatives to multiple MS Excel attachments that create one big mixed BOM salad on our tables? One of the possible ways is to move online. This is really nice! Think about being able to keep your BOM tables online (actually, I discussed cloud options last month – Host PLM Data using Cloud Services , Should PLM take Excel to the Cloud?). And this is time I also was thinking about Office online alternatives, and came up with Google Apps. I polled your Google Apps opinion last week in PLM Prompt Should PLM think about Google Apps?  You also need to check what was result of Kate’s Cloud Watching, but I’ve seen definite interest in this.

So, the main idea is to be able to co-edit document information (spreadsheets, in our case) online. This simplifies the editing process of potential Bill of Materials and allows many participants to edit/view them at the same time. As this is an advantage, where is the drawback? For Excel, one of the big disadvantages of PLM Spreadsheets is how to connect it to multiple data sources – design, manufacturing etc. This is still a problem in my view. One interesting possibility is the connection as demonstrated by Google Apps and Salesforce.com. Another option is to move forward with cloud applications, but these seem still to be in their infancy. 

Google Docs in Plain English

Google Apps and Salesforce.com 

I can see that collaboration in the future with Google Apps has a nice potential, but what is going on with the parallel Microsoft option? There are two main options for organizing my big Bill of Materials salad created in MS Excel. One is to move it to MS SharePoint. This is a really beautiful option. The combination of MS SharePoint Lists and MS Excel interoperability works fine. You can almost seamlessly move an Excel to SharePoint List and populate an Excel View based on a MOSS Web Part – or just export a MOSS list to Excel. There are practical things you can do tomorrow with MOSS 2007, and this is a real benefit vs. Google Apps, since it don’t have the grace of leveraging all MS Excel install bases for this purpose. But at the same time, Google Apps is really a leader in providing online collaboration with Gmail and Google Docs. Even if Microsoft is proposing to host MS SharePoint, I think this is still far from a real production for manufacturing organizations.

 SharePoint online

SharePoint Online

Combination of SharePoint and Unified Communication also can bring additional benefits. I wrote about this back to SolidWorks World. SharePoint Social Platform capability for SolidWorks

And to be fair enough, discussing all online collaboration option, I think I have to mention Arena Solutions option. This company has already been providing online Bill of Materials collaboration for many years. Although I don’t know if Arena is Excel-friendly, I had a chance to read a few white papers  explaining Arena’s benefits vs. MS Excel. Based on what I read, I think this is a more competing rather than coexisting offering.

 So, I think there are pros and cons on how to streamline collaboration. I’m looking forward to discussing this with you, as usual.


Share This Post

  • I would characterize Arena as “Excel friendly”, in the sense that it is very easy to import an excel BOM into Arena and start to use a PLM BOM mgt capability (or export it to excel format for other uses). And I would definitely say it is “competitive” in the respect that once someone starts managing their BOM in Arena they stop doing so in their excel spreadsheet (anything else would be a data management nightmare). That said, once someone goes to Arena they don’t uninstall excel, it is still on the desktop and used for the hundreds of general purpose or simple offline calculations (that is if they haven’t already uninstalled excel to use google apps for free)

  • Mark
    Thanks for you clarification about Arena. So, I’d clarify by saying they are friendly to acquire excel, but since data was acquired Excel stops to be an option to work on these Bill of Materials. So, what is not clear how they will continue to use Excel or Google Apps for calculations etc?

  • Pingback: Excel’s Role in PLM Systems | Columns and Rows by eXpresso()

  • Pingback: Excel’s Role in PLM Systems | Columns and Rows by eXpresso()