His periods are 4 months between estimates, then after a year he gets an actual reading to catch up. Boy what a mess. Their estimates are way off. I have to cut his final reading by 60% and equally apply to the previous 3 estimates to get a reasonable number for each period.
(Click on the image to get a larger version)
Thus in the column marked A what I did was multiply his actual reading for that period by .6, or 60%. The 2874 in the first one was then added equally to the previous estimates to give the values in B. I then averaged those values from 2005 to 2007 before the smart meter went in so as to get the deviation from that baseline for C.
At least with the smart meters that will be eliminated. But look at the huge jump! (Data from the B column)
This is his deviation from the baseline (data from C)
Yes, there was a 3 time increase in his consumption, and from then on a 100% increase from the baseline. And nothing changed on his farm except the smart meter.
That's not all, there is also something weird with their "daily" consumption. Notice column D. The column to the left of that is the actual consumption divided by the number of days. The one to the left of that column is the number H1 says he consumed per day on average. Prior to the smart meter they match, but not after the smart meter, they are higher by 4kWh per day, one is 8kWh too high. Whats up with that?