I know there are quite a few of these out here, but here is my own version.
This spreadsheet will give you the projected difficulty of Bitcoin by you inputting the Network Hashrate... I know there has been a huge search of "What will difficulty be when..."
So I created this as kind of a ruler:
To think of what the Network Hash rate will be when all ASIC's come out just crunch some basic numbers:
Avalon is shipping about 1500 units in batches 1 thru 3 .. each unit is roughly 70 gigahash .. so 70 * 1500 = 105,000 Gigahash or 105 Terrahash
BFL has 75,000 chips, each supposed to produce 7.5 Ghash so 75000 * 7.5 = 562,500 gigahash or 562.5 Terrahash
Lets just assume there will be some gpu miners staying around so lets just estimate another 80 terrahash on top of those two to account for ASICMiner and gpu and misc..
So you're looking at after bfl sells out of all their current ordered chips, all avalons are online, and all gpus stay up, you're at a total of 747.5 terrahash would be the network hash rate..
Obviously there are quite a few variables that im not accounting for and this is just a rough estimate. But with my chart you can see that at that network hash rate you're looking at the difficulty level of about 98 million ish...
So anyway, here is the link: (you can edit what you want, but please only change the yellow cells... dont eff up the spreadsheet and make me re-upload it)
https://docs.google.com/spreadsheet/ccc?key=0Apgy2pGhFTindG1qdzdtNEMwdUs4d1JfYVVCVlZ6dnc&usp=sharingBTW - I just threw a new sheet up so you can view the same setup with Litecoin as well... that way you can try to guess what difficulty will be once the ASIC's take over BTC and all the gpu miners move to LTC
Please let me knwo if there are any errors, or if you think you can improve this
Donations greatly appreciated: 1RainQeE1kx9aqDg1AvLiM3Z1FzJUnSfc (BTC) | Laos1Cb2QN7o2uCsqv713tvE7vvdhHRnTN (LTC)