Video Card Price vs Performance vs Watts Excel Doc

[carbonc]

Here is a new Excel Doc I'm working on
Tell me what you think.

Prices updated...
ROI Added...
Overclocked MH/s

UPDATED June 5th





Donations: 18W5htHMBMEBYUSkEqqEzANbizJZp5Q1pu

[BitcoinsWallet]

Great work, carbonc!

[carbonc]

had a calc error.  Its fixed now

[zale]

Very nice! Can you add the 6850 and 6870 please?

[SgtSpike]

I created a very similar spreadsheet.

I also created a second sheet with system build costs included ($125/card additional cost), and the 5850 still won out, though the 5870 was much closer than with just the cost of the cards included.  This was when the 5850 was at $140 though.

[fnord123]

Very nice - add the 6870 too please

[Sukrim]

We need data for 6xxx budget series... (6670 etc)!

Also it would be cool to have this on Google docs, might even be possible to embed it in the Wiki like this then.

Another 2 columns that would be interesting: "cost after x days with y Cents/kWh running 24/7"(buying + electricity derived from Watts), "billions/trillions/quadrillions(?) of hashes checked in these x days"

I guess I could hack together something like that quickly...

[carbonc]

Added

6950
6870
6850

[carbonc]

We need data for 6xxx budget series... (6670 etc)!

I don't have MH/s data from that series.
Getting my data from here:

https://en.bitcoin.it/wiki/Mining_hardware_comparison

[Basiley]

very optimistic numbers for both 5850's, 5870, 68x0.
hardly many even overclocked fit that range.

[Clipse]

We need data for 6xxx budget series... (6670 etc)!

I don't have MH/s data from that series.
Getting my data from here:

https://en.bitcoin.it/wiki/Mining_hardware_comparison

I think these stats are fine for avg users who plan to run graphics card at basicly stock.

For instance, the hd5850 listed as 314mhash/s while with minimal overclocking every single hd5850 of mine do 350mhash/s+

[carbonc]

I agree about the average users but every card will perform as expected with these results on average
Overclocking only degrades the cards and shortens its life and many card manufactures will probaby vary with results.

I would presume that overclocking each card will give a certian percentage increase across the board.
This atleast gives users a baseline to start from...

[Clipse]

I agree about the average users but every card will perform as expected with these results on average
Overclocking only degrades the cards and shortens its life and many card manufactures will probaby vary with results.

I would presume that overclocking each card will give a certian percentage increase across the board.
This atleast gives users a baseline to start from...

How about adding another column on the spreadsheet to take into considering costs when overclocking with a modest 15% performance increase.

Would give a realistic result for those interested in buying something with overclocking taken into consideration.

[Sukrim]

Would give a realistic result for those interested in buying something with overclocking taken into consideration.

300 MH/s on a 6870 is only possible with heavy overclocking imho, I run at ~990 MHz (already overclocked!) and have ~280 MH/s!
Another ~10% more as in this Excel sheet is quite hard to manage...

[0815miner]

Ok, 5970 vs 6990 is wrong in W

5970 needs 294w if you don't try overclocking, right!
But the 6990 needs "just" 375w in same case.

I don't know there this data came from, but if its from here "https://en.bitcoin.it/wiki/Mining_hardware_comparison" you have to research all data if they are clocked or normal - if they are real live or manufacturer informations.

Next: 188w for the 5870

[carbonc]

Ok, I'll do some more research.
Add in Stock vs Overclock seen by users... maybe an average overclock instead of max...?

Not everyone will be able to get the max MH/s some other user has posted.

Sorry for the typos on some of the readings.

I havn't built in a direct data pull from that wiki yet.
I'd like it to be real time with prices and user's MH/s results.

Maybe I would be better suited building a database with user entry capability.

[airdata]

Great post!

I'm just starting out... currently have 1 4870 and 1 4670 running with a 6870 and 5770 to replace those in the mail.  I'm wanting to gauge 3-4 weeks worth of results with these cards before moving forward with additional builds.

[0815miner]

Ok, I'll do some more research.
Add in Stock vs Overclock seen by users... maybe an average overclock instead of max...?

Not everyone will be able to get the max MH/s some other user has posted.

You are right. overclocking depends on your cooling. (and your nuts) 

Next problem:   
The whole thing becomes really difficult if you try to calculate a rig with 3 or 4 cards.
You need to install different power supplies...
You perhaps can overclock four 5870, but whats about four 6990 with the same cooling..?

I tried to answer this, but my calculation and prices are in € and wouldn't fit here.

[Sukrim]

Here's a (imho) more useful representation (click on picture to see bigger version):



Y axis:
Total Megahashes (MH/s*60*60*24*[#ofdays]) until that day divided by EUR spent until that day (calculated from Wattage + costs per kWh)
X axis:
days

Here you can see that if you just plan to mine short term, a 5830 can be a VERY useful investment --> in the longer run however a 5970 might be hard to beat.

It's also quite fun to play around with electricity costs or MH/s for example and see the lines jump + rearrange!

It might also be useful to determine if you want to spend for example 500€ in the next 90 days to determine which card would bring the most performance until then.
(Multiple cards btw. have exactly the same ratios - 2 cards cost twice as much, use twice as much electricity and also calculate twice as many hashes)

[0815miner]

Here's a (imho) more useful representation (click on picture to see bigger version):

https://i.imgur.com/DnYJyl.jpg

Y axis:
Total Megahashes (MH/s*60*60*24*[#ofdays]) until that day divided by EUR spent until that day (calculated from Wattage + costs per kWh)
X axis:
days

Here you can see that if you just plan to mine short term, a 5830 can be a VERY useful investment --> in the longer run however a 5970 might be hard to beat.

It's also quite fun to play around with electricity costs or MH/s for example and see the lines jump + rearrange!

It might also be useful to determine if you want to spend for example 500€ in the next 90 days to determine which card would bring the most performance until then.
(Multiple cards btw. have exactly the same ratios - 2 cards cost twice as much, use twice as much electricity and also calculate twice as many hashes)

Problem 1:
You can't calculate the hardware and power together, because hadware is something you can sell again.

Problem 2:
where ist the 5870? (best w/h card in my calc)