Bitcoin Forum
April 24, 2014, 01:56:25 PM *
News: Due to the OpenSSL heartbleed bug, changing your forum password is recommended.
 
   Home   Help Search Donate Login Register  
Pages: [1]
  Print  
Author Topic: Bitcoin mine or invest spreadsheet & mining rig comparison spreadsheet  (Read 8692 times)
O_Shovah
Sr. Member
****
Offline Offline

Activity: 410


Watercooling the world of mining


View Profile

Ignore
January 03, 2012, 05:45:28 PM
 #1

I have reworked the "Bitcoin mine or invest" sheet orginaly created by SgtSpike.
[Spreadsheet: Invest in BTC or mining hardware?]

And i have created a spreadsheet comparing some examples of current mining technology:

GPU's,FPGA boards,and other technologies.


[Status]: active(15.06.2013)

[Pending]: reworking with current ASIC specs


Downloads

Bitcoin mine or invest 1.48 (Excel)

Bitcoin mine or invest 1.48 (Open office)


Comparison of mining rig examples 1.0 (Currently outdated, FPGA+GPU only)


Changelog

-03/01/12 changed download links to dropbox public;Modified sheet for less confusion on data entry.

-15/06/13 reworked mine or invest spreadsheet. Exel and Open office now avaidable.

Use

The Column A contains a description of the input data wich is to be entered into the cell on the right of it (within column B).
Likewise the output data is described and given in E and F.There an input by the user is not intended.


Please report any bugs you might encounter and give new ideas and wishes what you would like to see.
Especially the comparison sheet will be expanded in the future.

If you are a producer of mining equipment you would like to see listed. Please PM me with the data so i may add your setup.


1398347785
Hero Member
*
Offline Offline

Posts: 1398347785

View Profile Personal Message (Offline)

Ignore
1398347785
Reply with quote  #2

1398347785
Report to moderator
No Gods or Kings. Only Bitcoin
Advertised sites are not endorsed by the Bitcoin Forum. They may be unsafe, untrustworthy, or illegal in your jurisdiction. Advertise here.
1398347785
Hero Member
*
Offline Offline

Posts: 1398347785

View Profile Personal Message (Offline)

Ignore
1398347785
Reply with quote  #2

1398347785
Report to moderator
1398347785
Hero Member
*
Offline Offline

Posts: 1398347785

View Profile Personal Message (Offline)

Ignore
1398347785
Reply with quote  #2

1398347785
Report to moderator
1398347785
Hero Member
*
Offline Offline

Posts: 1398347785

View Profile Personal Message (Offline)

Ignore
1398347785
Reply with quote  #2

1398347785
Report to moderator
1398347785
Hero Member
*
Offline Offline

Posts: 1398347785

View Profile Personal Message (Offline)

Ignore
1398347785
Reply with quote  #2

1398347785
Report to moderator
Inaba
Hero Member
*****
Offline Offline

Activity: 1120



View Profile WWW

Ignore
January 03, 2012, 06:07:19 PM
 #2

Would be interesting, but I'll be damned if I'm putting in the info to download it.

You might consider hosting it on a not crappy file hosting site if you want better uptake.  Sounds interesting, though.  Let me know if it's available elsewhere.  (I suggest maybe using a public Dropbox share or if you must use a filehosting site, Megauplaod)


If you're searching these lines for a point, you've probably missed it.  There was never anything there in the first place.
O_Shovah
Sr. Member
****
Offline Offline

Activity: 410


Watercooling the world of mining


View Profile

Ignore
January 03, 2012, 06:39:10 PM
 #3

Edit:
Links changed to dropbox.

Sorry for the upload mess.

Inaba
Hero Member
*****
Offline Offline

Activity: 1120



View Profile WWW

Ignore
January 03, 2012, 09:44:35 PM
 #4

Thanks!  I think the sheet is kind of broken though.  The data column, which appears to be the column to the left of the "example" column, doesn't do much of anything.  Looking at the formulas, it seems the "example" column is suppose to be the actual data entry column, which is kind of confusing. 

It also appears to break with 0 values in B6, B9, and B10.


If you're searching these lines for a point, you've probably missed it.  There was never anything there in the first place.
O_Shovah
Sr. Member
****
Offline Offline

Activity: 410


Watercooling the world of mining


View Profile

Ignore
January 03, 2012, 10:05:55 PM
 #5

I asume you refer to the bitcoin mine or invest sheet ?

Wich column do you refer to as "example column" please C ?

One of the values in B6 , B9 and B10 has to be non zero.
Basically the entire B column ecept the "checkvalues" box at the bottom contains values to be changed/entered by the user.

Im not shure if i clearifyed the issue.
Please ask again if not.

Inaba
Hero Member
*****
Offline Offline

Activity: 1120



View Profile WWW

Ignore
January 03, 2012, 10:18:57 PM
 #6

Yes, column C appears (to me at least) to be the data entry column and column B appears to be an example column.

For my calculation, B6, 9 and 10 are 0, as my costs are 0 for the items in question (they are already paid for and wattage for components is already figured into the wattage of the cards - I take my readings with a Kill-A-Watt meter for the whole system - much more accurate than figuring theoretical draw of an individual card + components).


If you're searching these lines for a point, you've probably missed it.  There was never anything there in the first place.
O_Shovah
Sr. Member
****
Offline Offline

Activity: 410


Watercooling the world of mining


View Profile

Ignore
January 03, 2012, 10:37:11 PM
 #7

I changed the files on the dropbox repository.
The column to enter your data is B alone. So the yellow and green panels in theat column.
(except that "out of order" one actually Wink
In the A column each cell describes wich data should be entered in the cell to the right of it.
The 0's in your B parts should now do it

Inaba
Hero Member
*****
Offline Offline

Activity: 1120



View Profile WWW

Ignore
January 03, 2012, 11:49:43 PM
 #8

Link to github repo?

If you're searching these lines for a point, you've probably missed it.  There was never anything there in the first place.
jddebug
Sr. Member
****
Offline Offline

Activity: 365



View Profile

Ignore
January 04, 2012, 07:58:54 AM
 #9

I need some help with what the checkvalues are about.

Thank you.
O_Shovah
Sr. Member
****
Offline Offline

Activity: 410


Watercooling the world of mining


View Profile

Ignore
January 04, 2012, 12:12:33 PM
 #10

The checkvalues are not to be changed by you if you mean that.
They are a way without using macros for the output cells like expected profit  and so on,
to display error and information messages in case the calculations eg run beyond the maximum timeframe (1096days)
Eg G20 and G29 use these values.

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!