Bitcoin Forum
June 25, 2024, 11:30:54 AM *
News: Latest Bitcoin Core release: 27.0 [Torrent]
 
   Home   Help Search Login Register More  
Pages: [1]
  Print  
Author Topic: Mining Rig Calculation Spreadsheet  (Read 801 times)
Ophion (OP)
Newbie
*
Offline Offline

Activity: 2
Merit: 0


View Profile
December 27, 2013, 10:43:21 PM
 #1

Hey Everyone

The last couple of days ive spend some time to make a nice spreadsheet.
I made it so i could calculate the profit i would make/day and time till return of investment.
Since i didnt want to keep it for my self:

Example
https://docs.google.com/spreadsheet/ccc?key=0At8fizmac4xtdERrOWRuSWE5STVhQ2FmZTFIMThXclE&usp=sharing
Clean
https://docs.google.com/spreadsheet/ccc?key=0At8fizmac4xtdEZ3UnFKLWxPMVFfWHp0Vlo5YWNlS1E&usp=sharing

Greetz & HF Mining,

Ophion
Tibarian
Newbie
*
Offline Offline

Activity: 1
Merit: 0


View Profile
December 27, 2013, 10:58:10 PM
 #2

Looks great!
odolvlobo
Legendary
*
Offline Offline

Activity: 4354
Merit: 3274



View Profile
December 28, 2013, 12:06:13 AM
 #3

You show the current revenue as "the important part", but the most important part is future revenue. Your "Time till return of investment" is only valid if it is less than 10 or so days. You need a model that predicts future difficulty values so that you can come up with a reasonable result.

Join an anti-signature campaign: Click ignore on the members of signature campaigns.
PGP Fingerprint: 6B6BC26599EC24EF7E29A405EAF050539D0B2925 Signing address: 13GAVJo8YaAuenj6keiEykwxWUZ7jMoSLt
Ophion (OP)
Newbie
*
Offline Offline

Activity: 2
Merit: 0


View Profile
December 28, 2013, 07:56:13 AM
 #4

While i thought of the idea of implementing that,
i feel most coins are currently to unstable to unleash a single mathematical
function over all of them and predict the future profit.

Im planning on getting this up on a website and taking educated guesses based
on the currency and difficulty fluctuations of the past few weeks, this would
also include an integrated version of the coin prices etc(and maybe even actual
part prices). But this is not easely achieved in a spreadsheet (or i dont know how).

For now i just wanted to share the spreadsheet,
u can however, if u predict the currency will go up, put a slightly higher number
in the Coin Profit part (around B51). I know its a bit of a crappy workaround,
but still...

Well, i hope everyone has fun with the spreadsheet for now
infinitybo
Newbie
*
Offline Offline

Activity: 28
Merit: 0


View Profile
December 28, 2013, 09:14:23 AM
 #5

@Ophion Firstable That's great to come here because you will get some good advice here.
jimmyjimmy
Newbie
*
Offline Offline

Activity: 28
Merit: 0


View Profile
January 07, 2014, 05:49:11 AM
 #6

it's indispensable to me right now to use these spreadsheets
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!