Hello, In my previous roll as an Energy Analyst I managed the budget, annual forecasting and variance reporting for the utilities of a portfolio of many buildings. These utilities included such things as electricity, natural gas, steam, diesel, water, etc. I did this by utilizing a data model with multiple sources of data within Excel. The tools I've created using Visual Basic have allowed for automated data entry and processing to enable the streamlining of tasks and improved efficiency. In the forecasting tools I have created I've utilized statistical weather regression models to better address the seasonality of some of the utilities when reporting on monthly variances. I have also created many dynamic dashboards within Excel and programs such as Power BI to automatically slice the data in visuals and gain better insights to the root causes of variances.
I am interested to know more about what you are requiring but I assure you I can provide you an end product that you most certainly will be pleased with.
Best regards,
Brian Willms