These forums have been archived and are now read-only.

The new forums are live and can be found at https://forums.eveonline.com/

Science & Industry

 
  • Topic is locked indefinitely.
 

Best ore for the mineral

First post
Author
Burn Monroe
La Explorers
#1 - 2017-02-24 08:47:45 UTC  |  Edited by: Burn Monroe
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
ErgoDron
#2 - 2017-02-24 09:54:07 UTC
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.
Burn Monroe
La Explorers
#3 - 2017-02-24 10:32:56 UTC
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
#4 - 2017-02-24 12:53:14 UTC
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
La Explorers
#5 - 2017-02-25 01:26:04 UTC
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
#6 - 2017-02-25 03:06:24 UTC
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