Ensuring your data is good quality, consistent and reliable is important to be able to understand and report on your energy data. Choosing the correct system to do this is key to successfully utilising your data to identify anomalies, optimise your energy efficiency and make cost savings.
Despite spreadsheets being a popular tool to manage energy data due to their flexibility and easy to use calculations, using them to keep large amounts of data can lead to big problems. This was proven during the beginning of the COVID-19 pandemic when Public Health England used a spreadsheet to keep track of COVID cases, leading to the loss of 16,000 COVID-19 test results in England.
So, what are the limitations of spreadsheets? And why should they not be used as a replacement for databases?
What are the limits of Spreadsheets?
Spreadsheets have some great qualities, they are flexible and easy to understand, with the ability to integrate...