It is starting to really ****ing annoying me now I already explained my use of this calculator MANY times and why its JUST AS USEFUL OR BETTER THAN USING SPREADSHEETS. I'll quote again.
Please allow me to 'sperg out' for a moment. But people need to understand this.
Difficulty and $/BTC are inexorably linked.
This image has been resized. Click this bar to view the full image. The original image is sized 830x803.
Price leads Difficulty, always. Difficulty drives price, never. This relationship has remained constant during all recored history, and it will take a very fundamental change in this relationship for this ever to be any different.
It is very important to understand this relationship if you hope to ever make sense of change in Difficulty and what causes it.
The correlation coefficient of this relationship is .977, which means it is very robust. (a value of 1 would mean it is an exact match)
The moving average is a simple 12 week moving average of price, which always lags the current price. This correlation can be slightly enhanced by applying a special weighting to this moving average. It is not useful for projecting beyond the next increase in Difficulty unless you know what is going to happen to price. However, if you are trying to produce a business plan with contingencies relating to $/BTC and Difficulty you just might find this information useful.