Bitcoin Forum
March 29, 2024, 02:15:43 PM *
News: Latest Bitcoin Core release: 26.0 [Torrent]
 
   Home   Help Search Login Register More  
Pages: [1]
  Print  
Author Topic: Yet Another BTC&LTC MiningCalc (not constant Net.Hashpower/Exch.Rate)  (Read 1755 times)
scrypt (OP)
Newbie
*
Offline Offline

Activity: 16
Merit: 0


View Profile
June 28, 2013, 01:01:39 AM
Last edit: June 28, 2013, 09:23:03 PM by scrypt
 #1

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&LTC.
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.
1711721743
Hero Member
*
Offline Offline

Posts: 1711721743

View Profile Personal Message (Offline)

Ignore
1711721743
Reply with quote  #2

1711721743
Report to moderator
1711721743
Hero Member
*
Offline Offline

Posts: 1711721743

View Profile Personal Message (Offline)

Ignore
1711721743
Reply with quote  #2

1711721743
Report to moderator
1711721743
Hero Member
*
Offline Offline

Posts: 1711721743

View Profile Personal Message (Offline)

Ignore
1711721743
Reply with quote  #2

1711721743
Report to moderator
"You Asked For Change, We Gave You Coins" -- casascius
Advertised sites are not endorsed by the Bitcoin Forum. They may be unsafe, untrustworthy, or illegal in your jurisdiction.
1711721743
Hero Member
*
Offline Offline

Posts: 1711721743

View Profile Personal Message (Offline)

Ignore
1711721743
Reply with quote  #2

1711721743
Report to moderator
skoolbytes
Newbie
*
Offline Offline

Activity: 23
Merit: 0


View Profile
June 28, 2013, 05:11:38 PM
 #2

Very nice spreadsheet!  Thanks for sharing.

Curious....what is going on with Cells A35, A52 and A69
scrypt (OP)
Newbie
*
Offline Offline

Activity: 16
Merit: 0


View Profile
June 28, 2013, 05:33:34 PM
 #3

>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.
skoolbytes
Newbie
*
Offline Offline

Activity: 23
Merit: 0


View Profile
June 28, 2013, 06:34:14 PM
 #4

>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.

scrypt (OP)
Newbie
*
Offline Offline

Activity: 16
Merit: 0


View Profile
June 28, 2013, 07:45:34 PM
Last edit: June 28, 2013, 09:22:43 PM by scrypt
 #5

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.
scrypt (OP)
Newbie
*
Offline Offline

Activity: 16
Merit: 0


View Profile
September 24, 2016, 08:16:25 AM
Last edit: September 24, 2016, 08:45:37 AM by scrypt
 #6

(All rights for this masterpiece Roll Eyes now belong to https://telegram.me/jpmorgansocks)
leowonderful
Legendary
*
Offline Offline

Activity: 1624
Merit: 1129


Bitcoin FTW!


View Profile
September 25, 2016, 01:49:32 AM
 #7

(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
Pages: [1]
  Print  
 
Jump to:  

Powered by MySQL Powered by PHP Powered by SMF 1.1.19 | SMF © 2006-2009, Simple Machines Valid XHTML 1.0! Valid CSS!