Thank you so much for your video. I recently became interested in energy, and this helps me understand better because I come from a non-traditional background.
So, I have a few homes. One for me, one for my father and one for my inlaws. My son is about to move out as well. I considered building one spreadsheet with addresses on the X and various readings on Y. On Y, I could have 'water', 'power', 'heat' and so on. Now every heading will have several columns. e.g. January reading| Feb Reading| March | April| and so on.after each column, I want to see how many units we have used. And in the next column, there should be the difference already calculated. Can you please throw some ideas...
Forecasting typically requires the annual increase or decrease rate. At the moment, I don't have a widely accepted rate that I can use as an example for energy forecasting. However, I have created a video in the past on forecasting retirement investments, and the concepts involved are similar. Once you have your data, you can simply plug it in. I recommend watching the video below to see if it provides any assistance. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-daYF4ksCBW4.html