Author

Topic: Yet Another BTC&LTC MiningCalc (not constant Net.Hashpower/Exch.Rate) (Read 1759 times)

legendary
Activity: 1624
Merit: 1129
Bitcoin FTW!
(All rights for this masterpiece Roll Eyes 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. Smiley
newbie
Activity: 16
Merit: 0
(All rights for this masterpiece Roll Eyes now belong to https://telegram.me/jpmorgansocks)
newbie
Activity: 16
Merit: 0
Published version v0.2-130628:
* '356 days in a year' typo was fixed. Now it is 365  Cool
* 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.
newbie
Activity: 23
Merit: 0
>what is going on with Cells A35, A52 and A69
Nothing wrong. It is as it was designed Roll Eyes - 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.

newbie
Activity: 16
Merit: 0
>what is going on with Cells A35, A52 and A69
Nothing wrong. It is as it was designed Roll Eyes - 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.
newbie
Activity: 23
Merit: 0
Very nice spreadsheet!  Thanks for sharing.

Curious....what is going on with Cells A35, A52 and A69
newbie
Activity: 16
Merit: 0
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  Cool
* 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: