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.

10 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

Subhash Komuravelli said...

Nice blog, very interesting to read
I have bookmarked this article page as i received good information from this.

Cloud Based ERP Software in India | ERP Software Companies in Hyderabad

ERP Hyderabad | ERP Software Providers in Hyderabad

Anonymous said...

Great Article. This Blog Contain Good information about ERP Software. Thanks For sharing this blog. Can you please do more articles like this blog.


machine maintenance software price in us
machine maintenance software development in us
crm software development cost in us
erp in chennai
crm software development cost in chennai
cloud erp in chennai

Mounika said...

Very good explanations of the ERP software basics, it's good to know that! A friend of mine has implemented a company which is best erp software in hyderabad right now, she provides cloud based erp software in hyderabad, so I hope it goes well for her.
Best regards

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

Banumadhu said...

Useful article which was very helpful. also interesting and contains good information.
to know about python training course , use the below link.

Python Training in chennai

Python Course in chennai

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


aishu said...

I read your article it is very interesting and every concept is very clear, thank you so much for sharing. AWS Certification Course in Chennai