Pages: [1] :: one page |
|
Author |
Thread Statistics | Show CCP posts - 0 post(s) |
Burn Monroe
Bros Before Holes
8
|
Posted - 2017.02.24 08:47:45 -
[1] - Quote
I've been to several sites that list the ore information and indicate the best ore for the mineral. Every site I've seen is incorrect. I'm guessing they never updated at one point or another. Anyhow, I decided to run a query to grab this information from the eve data extract.
https://docs.google.com/spreadsheets/d/1mtqRVCSCDH6q3ZYVk_66FFMoex5j-zU4MzVzvbjPkpE/pubhtml
Anyhow, the query to get this information was...
SELECT invTypes.typeID, invTypes.typeName, invTypeMaterials.quantity, (SELECT a.typeName FROM invTypes a WHERE invTypeMaterials.materialTypeID = a.typeID) mineral, volume, quantity / invTypes.volume perm3 FROM evedata.invMarketGroups, evedata.invTypes, evedata.invTypeMaterials WHERE parentGroupID = 54 AND invTypes.marketGroupID = invMarketGroups.marketGroupID AND invTypes.typeID = invTypeMaterials.typeID ORDER BY mineral, perm3;
|
erg cz
Broz With Froz Dot Dot Dot
551
|
Posted - 2017.02.24 09:54:07 -
[2] - Quote
I think your table is also wrong. You got it right with isogen, but wrong for mexallon, for example. Plagioclase gives you only about 306 items of Mexallon per m3, but Gneiss - 480. The rest of the table seems to be ok.
Absolutely free trial extension. Just click the link and get extra 250 000 SP for free!
|
Burn Monroe
Bros Before Holes
8
|
Posted - 2017.02.24 10:32:56 -
[3] - Quote
Good catch, I had sorted them but apparently didn't go down far enough with the Mexallon to see the Gneiss. I've updated the highlights, but apparently google docs doesn't immediately re-publish, so I'm waiting for it to update. |
Steve Ronuken
Fuzzwork Enterprises Vote Steve Ronuken for CSM
6495
|
Posted - 2017.02.24 12:53:14 -
[4] - Quote
This was an oops on my chart.
I'd hard set the values a while back, and never got round to updating them.
Woo! CSM XI!
Fuzzwork Enterprises
Twitter: @fuzzysteve on Twitter
|
Burn Monroe
Bros Before Holes
9
|
Posted - 2017.02.25 01:26:04 -
[5] - Quote
The question I've been wonder, is there a formula to use that would determine which ores to mine based on all the minerals you want? because ultimately the combination of ores and the amount to mine for them could be very different than the largest mineral type in a particular ore. For example, I've found I rarely need veldspar, as mining other ores for other minerals results in enough tritanium to not need to mine veldspar at all. Or, would it simply be a brute force combination summing calculator to find that number?
|
Steve Ronuken
Fuzzwork Enterprises Vote Steve Ronuken for CSM
6498
|
Posted - 2017.02.25 03:06:24 -
[6] - Quote
It's the kind of problem that linear programming is pretty much designed for.
if you look up the stigler diet problem, it's that, where the foods are replaced with the ore types, and the minerals replace the nutrients. (and the price is replaced by the volume)
Woo! CSM XI!
Fuzzwork Enterprises
Twitter: @fuzzysteve on Twitter
|
|
|
|
Pages: [1] :: one page |
First page | Previous page | Next page | Last page |