Science & Industry

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;

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.

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?