|
Title: Yet Another BTC<C MiningCalc (not constant Net.Hashpower/Exch.Rate) Post by: scrypt on June 28, 2013, 01:01:39 AM Was disappointed in all these "constant network hashpower/exchange rate" mining profitability calculators.
So, just made the opposite one. Customizable. MS Excel based. Offline. BTC<C. Hope you will find it helpful too. Some screens: http://belarusminsk.s3.amazonaws.com/BitcoinCalcScreen.png http://belarusminsk.s3.amazonaws.com/LitecoinCalcScreen.png WWW: http://belarusminsk.s3.amazonaws.com/MiningCalc.xlsx Torrent: http://belarusminsk.s3.amazonaws.com/MiningCalc.xlsx?torrent Input your estimations of Network Hashpower and Exchange Rate for 50+ steps in time (=up to 2 years for 2 weeks interval), and get Break-even period, Profit and ROI for three kinds of mining hardware of your choice. Cheers. #update 28 June 2013 Published version v0.2-130628: * '356 days in a year' typo was fixed. Now it is 365 8) * One more time step was added. Now there are 54 time steps in total. * Months count in the H column is starting from '0', but not from '1' * Cells A30-35, A47-52 and A64-69 are hardcoded to be just numbers, but not expressions. There is no need for expressions. Title: Re: Yet Another BTC<C MiningCalc (not constant Net.Hashpower/Exch.Rate) Post by: skoolbytes on June 28, 2013, 05:11:38 PM Very nice spreadsheet! Thanks for sharing.
Curious....what is going on with Cells A35, A52 and A69 Title: Re: Yet Another BTC<C MiningCalc (not constant Net.Hashpower/Exch.Rate) Post by: scrypt on June 28, 2013, 05:33:34 PM >what is going on with Cells A35, A52 and A69
Nothing wrong. It is as it was designed ::) - these cells are for 24 months' values, but the time line is just 676 days, which is little less. This is because I chose 13 days interval instead of 14 days to reflect sooner diff retarget as a result of constantly increasing hashpower. Title: Re: Yet Another BTC<C MiningCalc (not constant Net.Hashpower/Exch.Rate) Post by: skoolbytes on June 28, 2013, 06:34:14 PM >what is going on with Cells A35, A52 and A69 Nothing wrong. It is as it was designed ::) - these cells are for 24 months' values, but the time line is just 676 days, which is little less. This is because I chose 13 days interval instead of 14 days to reflect sooner diff retarget as a result of constantly increasing hashpower. ah, makes sense now. Title: Re: Yet Another BTC<C MiningCalc (not constant Net.Hashpower/Exch.Rate) Post by: scrypt on June 28, 2013, 07:45:34 PM Published version v0.2-130628:
* '356 days in a year' typo was fixed. Now it is 365 8) * One more time step was added. Now there are 54 time steps in total. * Months count in the H column is starting from '0', but not from '1' * Cells A30-35, A47-52 and A64-69 are hardcoded to be just numbers, but not expressions. There is no need for expressions. Title: Re: Yet Another BTC<C MiningCalc (not constant Net.Hashpower/Exch.Rate) Post by: scrypt on September 24, 2016, 08:16:25 AM (All rights for this masterpiece ::) now belong to https://telegram.me/jpmorgansocks)
Title: Re: Yet Another BTC<C MiningCalc (not constant Net.Hashpower/Exch.Rate) Post by: leowonderful on September 25, 2016, 01:49:32 AM (All rights for this masterpiece ::) now belong to https://telegram.me/jpmorgansocks) 2013 to 2016? Quite the comeback. Checked out the site and it's giving me an error, not sure if it's due to the transfer or just no maintenance. Still looks to be a nice site... 5gh/s jally? That was quite a long time ago. :) |
