Bitcoin Forum
September 23, 2017, 07:50:56 AM *
News: Latest stable version of Bitcoin Core: 0.15.0.1  [Torrent]. (New!)
 
   Home   Help Search Donate Login Register  
Pages: [1]
  Print  
Author Topic: Simple Mining Worksheet - Difficulty vs. BTC  (Read 1689 times)
BkkCoins
Hero Member
*****
Offline Offline

Activity: 784


firstbits:1MinerQ


View Profile WWW
September 03, 2011, 08:57:09 AM
 #1

I made up a simple spreadsheet to see the range of values as difficulty and btc price change. Also wanted to compare for different power consumption levels. Below is two screen snaps.

One for 360W (that's my 2x 5830) and one for 36W (potential 6x FPGA rig).





OpenOffice spreadsheet here. (updated)
I colour coded it for "good - green" being over $5/day and "give up - red" under 50 cents/day.

Comments welcome, or if you see an error let me know.

1506153056
Hero Member
*
Offline Offline

Posts: 1506153056

View Profile Personal Message (Offline)

Ignore
1506153056
Reply with quote  #2

1506153056
Report to moderator
Every time a block is mined, a certain amount of BTC (called the subsidy) is created out of thin air and given to the miner. The subsidy halves every four years and will reach 0 in about 130 years.
Advertised sites are not endorsed by the Bitcoin Forum. They may be unsafe, untrustworthy, or illegal in your jurisdiction. Advertise here.
1506153056
Hero Member
*
Offline Offline

Posts: 1506153056

View Profile Personal Message (Offline)

Ignore
1506153056
Reply with quote  #2

1506153056
Report to moderator
1506153056
Hero Member
*
Offline Offline

Posts: 1506153056

View Profile Personal Message (Offline)

Ignore
1506153056
Reply with quote  #2

1506153056
Report to moderator
twmz
Hero Member
*****
Offline Offline

Activity: 737



View Profile
September 03, 2011, 09:34:50 PM
 #2

Great spreadsheet!  Thanks!

Here is an Excel version for anyone that doesn't have OpenOffice.  Note, the original OpenOffice version does open in Google Docs as well for anyone that doesn't have either.

http://dl.dropbox.com/u/1169716/MiningProfitMatrix.xls

Was I helpful?  1TwmzX1wBxNF2qtAJRhdKmi2WyLZ5VHRs
WoT, GPG

Bitrated user: ewal.
deslok
Sr. Member
****
Offline Offline

Activity: 462


It's all about the game, and how you play it


View Profile
September 03, 2011, 09:43:05 PM
 #3

Also note excel 2007+ can open open office files!

"If we don't hang together, by Heavens we shall hang separately." - Benjamin Franklin

If you found that funny or something i said useful i always appreciate spare change
1PczDQHfEj3dJgp6wN3CXPft1bGB23TzTM
twmz
Hero Member
*****
Offline Offline

Activity: 737



View Profile
September 03, 2011, 09:43:54 PM
 #4

Also note excel 2007+ can open open office files!

Excel 2011 for Mac can not Smiley

Was I helpful?  1TwmzX1wBxNF2qtAJRhdKmi2WyLZ5VHRs
WoT, GPG

Bitrated user: ewal.
jamesg
VIP
Legendary
*
Offline Offline

Activity: 1358


AKA: gigavps


View Profile
September 04, 2011, 01:54:09 AM
 #5

Great spreadsheet! This will be very useful going forward.
BkkCoins
Hero Member
*****
Offline Offline

Activity: 784


firstbits:1MinerQ


View Profile WWW
September 04, 2011, 03:14:43 AM
 #6

Thanks for feedback and conversions.

I made it because it helps to see the range of numbers all laid out even though I know it's simple linear relationships. I can print it and by running my finger over see what happens as price/difficulty changes.

vapourminer
Legendary
*
Offline Offline

Activity: 1359

what is this "brake pedal" you speak of?


View Profile
September 04, 2011, 12:49:05 PM
 #7

thanks!

Ive run the online ones on occasion but I too like printed tables. also makes it easier to explain things to the wife.
Pages: [1]
  Print  
 
Jump to:  

Sponsored by , a Bitcoin-accepting VPN.
Powered by MySQL Powered by PHP Powered by SMF 1.1.19 | SMF © 2006-2009, Simple Machines Valid XHTML 1.0! Valid CSS!