Do It Yourself (DIY) PLM and Microsoft Excel Services

Many of the engineers (and not only) are using Microsoft Excel. People are literally lives inside of Excel spreadsheets. When it comes to PDM and PLM, I prefer to call it DIY (Do It Yourself) PLM. If you really on the DIY path, I think you need to be aware about so-called Excel Services available in Microsoft SharePoint since version 2007. In 2010, Microsoft improved significantly the capabilities of Excel Services.

You can read more about Excel Services by navigating to the following link. In addition, I found a very interesting video interview with Jon Campbell, program manager within Microsoft Excel services team. It was made almost a year ago. At the same time, I found it still something you use to educate yourself about SharePoint Excel Services.

Note, Excel services are very sophisticated. I was screening another article about Excel services – Excel Services in SharePoint. Here is the set of recommendation how to use Excel services to build a custom application:

Custom Applications: Excel Services help create custom applications—for example, ASP.NET applications—that can:

1. Call Excel Web Services to access, parameterize, and calculate workbooks.

2. Open, refresh external data, set cells or ranges, recalculate, participate in collaborative editing sessions with other applications or people, save, and save as.

3. Use custom workflows to schedule calculation operations or send e-mail notifications.

Above all this, in multiple server configurations, Excel Services load-balances requests across multiple Excel Calculation Services occurrences in a farm configuration. If your installation includes multiple application servers, Excel Services will balance the load in an attempt to help ensure that no single application server is overloaded by requests.

What is my conclusion? SharePoint is wide adopted by manufacturing enterprise companies. To use Excel as a platform to develop you DIY PLM solution can be an interesting option. However, I want to warn you about an appropriate resource planning and service budge allocation. DIY normally on the expensive side. SharePoint is not an exclusion from this list. Just my thoughts…

Best, Oleg

2 Responses to Do It Yourself (DIY) PLM and Microsoft Excel Services

  1. [...] talks about DIY (Do It Yourself) PLM, and  I have seen examples of Excel spreadsheets managing Excel spreadsheets and Email archives.  [...]

  2. You get a companion and a friend you can actually rely on in times of trouble.
    The excellent packing is necessary to move the goods safely to
    the new location. Professional removal agencies of Noida address this
    problem. You would also observe that the agent
    is capable of managing trucking logistics for all types of
    airfreight and ocean freight import and export services.
    It is important for the crew to be aware of the handling procedures when it comes to high tech
    gadgets and furniture. Don’t forget newspapers Believe it or not, plenty
    of people still advertise in the newspaper.

    Internet speed at Symphony is many times your present
    speed and also you can download and upload your video
    easily. Our yarmulkes and Kippah Los Angeles show the
    distinguishing stamp of quality, and a half-century of practice and proficiency.
    There are a number of parameters which make it to the ideal cleaning system.
    For example, a pharmaceutical manufacturer may invest in new 1,000-litre capacity reactor vessels, a
    property company purchases a 500-vehicle capacity city-centre car park, and a
    ‘multiplex’ cinema is built with 10 screens and a total capacity
    of 2,500 seats.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s


Get every new post delivered to your Inbox.

Join 250 other followers

%d bloggers like this: