Ok, have some time to further explain some info on the spreadsheet.
For 12 Month Cost and Consumption Sheet:
This should be your actual historical consumption taken from previous bills. The more data here the better. You can use 2,3 or more years of history here. We have Southern California...