Topic: Yet Another BTC<C MiningCalc (not constant Net.Hashpower/Exch.Rate) (Read 1778 times)
September 24, 2016, 08:49:32 PM
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.
September 24, 2016, 03:16:25 AM
(All rights for this masterpiece 
now belong to https://telegram.me/jpmorgansocks)
now belong to https://telegram.me/jpmorgansocks) June 28, 2013, 02:45:34 PM
Published version v0.2-130628:
* '356 days in a year' typo was fixed. Now it is 365
* 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.
* '356 days in a year' typo was fixed. Now it is 365
* 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.
June 28, 2013, 01: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.
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.
June 28, 2013, 12: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.
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. June 28, 2013, 12:11:38 PM
Very nice spreadsheet! Thanks for sharing.
Curious....what is going on with Cells A35, A52 and A69
Curious....what is going on with Cells A35, A52 and A69
June 27, 2013, 08:01:39 PM
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
* 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.
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
* 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.
Jump to: