Two sharp-eyed readers recently commented that the results showing in The Spike Line didn’t match what they calculated using the formulas shown on the page, and those in turn skewed what was showing in the charts. Their comments spurred me to take a look at the spreadsheet that I update daily and underpins what you see on both “The Spike Line” and “Today in Oil” pages. As it turns out, the readers were correct – there were some deviations between the calculations in the spreadsheet and the displayed formulas.
The differences were not dramatic; the actual variances were between roughly 1 and 3 cents. That was enough, though, to throw off when the numbers and charts predicted a spike. I’ve since adjusted the spreadsheet calculations to match the formulas, so anyone doing the math should be reaching the same result. Ohio was not affected, as the formula and calculation matched.
Thanks for following The Gas Game and letting us know! -CP