The Industrial Calculation Landscape, the challenge!!!!

Too often over the last 6 months the desire for managed calculations has come up when reviewing a project or site. Drilling in on the requirements it becomes clear, that the enterprise’s/sites are having trouble aligning, managing calculations/ measures and KPIs. Microsoft Excel has become the source of many of the calculations, providing the freedom for engineers to create Adhoc calculations. The Excel paradigm is an isolated one, ending up with 100s / 1000s of calculations. Many of the companies I talk to across different industries have initiatives underway to eliminate Excel as data source, they do not mind it as an analysis tool. The major chunk of work is to understand the current Excel sheets determine the measures and calculation within these, determine the common calculations and data sources, and then determine a way to create and manage calculations/ measures and KPIs with clear governance. Not and Easy Task!!!