6 reasons why you should not use spreadsheets for energy management

Submitted by Carina Lima on Wed, 05/18/2016 - 18:59
Many companies manage and control energy-related processes with multiple electronic spreadsheets, in most cases doing everything from data collection to information analysis and report generation. Energy management teams are faced with the challenge of finding adequate management systems that not only include all of the tools and features needed to manage daily operations and promote continuous improvement, but also that are highly usable, with simple and intuitive interfaces, well integrated to existing systems, and easily accessible from different devices.

The Viridis platform for energy and utilities management provides capabilities of monitoring, planning, contracting, costing, measurement and verification, simulation, and optimization of energy consumption – in an integrated way. This integration completely eliminates the need to use spreadsheets, in addition to allowing greater control, security, and quality of information. Data concerning energy consumption can be captured by the platform in real time, immediately treated in terms of quality and inserted into a contextualization mechanism that facilitates more robust and comprehensive analyses. Otherwise the Viridis platform also facilitates the incorporation of processes and tools that are commonly implemented in spreadsheets by users: forms for manual entry of data (for metrics that do not have physical meters), production plans used for prediction of energy consumption, forms for entry and verification of invoice data, spreadsheets that represent business rules in specific tasks and pivot tables for querying and visualization of combinations of data – all are of course covered by the Viridis platform and its interface components in order to facilitate the internalization of the tool and the rapid capture of value by users.