Analytics header

Thursday, December 29, 2011

Why Do We Still Use Spreadsheets?

Sometimes I find some unfinished article while cleaning up – something I should obviously do more regularly! So here is one of these excerpts that I found particularly relevant as I am discussing the topic of “Manufacturing Intelligence” with a number of companies.

Manufacturing systems software vendors continuously tell us that you cannot have visibility into your operations without a software application, which I have to agree is generally true. This forces us to sift through the onslaught of offerings full of buzz words such as “metrics”, “digital dashboards”, and “business intelligence platforms”. Yet, it is remarkable that one of the most commonly used tools to capture and manage information from the shop floor is The Spreadsheet - typically Microsoft’s Excel. In some cases, even with a major ERP system investment, the Spreadsheet is still the primary source of timely data collection about the manufacturing operations. In other cases, expensive solutions are put in place to capture and collect data from automation equipment but fail to provide the information in a useable context and once again users resort to the spreadsheet.


Why is it then that manufacturing organizations resort to solutions that are based on a spreadsheet? It is typically not because of lack of understanding about information systems or the skills required to use them. It is because a spreadsheet provides the flexibility and ability to manage and present shop floor information in the most useable and advantageous manner. (By the way the common term for “manage and use” is “information consumption”.) Remember that a manufacturing manager’s main focus is productivity and quality. They use this information to obtain metrics about the value stream that they are trying to manage because they need to know how they are performing in real time. This need is similar to that of a sport’s team, where you know where you stand at every second of the game. You don’t have to wait until tomorrow morning’s newspaper to know who won the game. Running a manufacturing operation without real time metrics is like bowling without being able to see the pins. You can see some of the action, you know that something happened, but you don’t know what the result was.

Of course in recent years, manufacturers have gained some visibility with the increased application of technology, but they are still far from what is possible. I also believe that most of the vendors are clearly aware of the needs and I hope that they we will soon start to see Manufacturing Intelligence applications with the flexibility and convenience that we really need.

8 comments:

caster wheel said...

Thank you about the information.............

Unknown said...

Nice information. The Spreadsheet is still the main resource of appropriate information selection about the generating operations. The main objective of a spreadsheet is to process numbers. Just as Term procedures written text, and can do a lot more than just structure it into sections and create it out, Succeed can do a lot more than just add up. It can do mathematical research far beyond what you'd need at schools, and it can plot graphs, rank data, and even execute some of the features of a database. A spreadsheet provides the versatility and capability to handle and existing store floor information in the most useful and beneficial way. SWOT Analysis Report

Hari said...

Amazing article. Your blog helped me to improve my skills and thank you for giving this kind of pleasant informative blogs. Keep doing...!
JMeter Training in Chennai
Advanced Excel Training in Chennai
Embedded System Course Chennai
Linux Training in Chennai
Pega Training in Chennai
Tableau Training in Chennai
Unix Training in Chennai
Spark Training in Chennai
Oracle Training in Chennai
Oracle DBA Training in Chennai
JMeter Training in Porur

shiny said...

I am amazed by your well comprehensible write-up. You are courageous to produce a spectacular content, which seems incredible. . Web Designing Course Training in Chennai | Web Designing Course Training in annanagar | Web Designing Course Training in omr | Web Designing Course Training in porur | Web Designing Course Training in tambaram | Web Designing Course Training in velachery

rajmohan1140 said...

Thanks so much for a detailed post! It is very helpful for. Your post is helpful to avoid the mistakes.


Java Training in Chennai

Java Course in Chennai


Back linker said...

ZModeler 3.4.1 Build 1194 Crack is a powerful application, it can make 3D models for video games, you can also effortlessly make models for other uses. Zmodeler 3 License Crack

Back linker said...

In this article, We are going to share with you some unused and working free License Key & Activation Code for Kaspersky Internet Security. Kaspersky Internet Security Activation Code Free

The Blogger Worlds said...

First day of school quotes your education is AN integral element of your living since the primary day of faculty to the last. School First Day Wishes