EVE Technology Lab

Hey, quick question. I'm trying to understand how to get the needed materials for manufacturing T2 items from the data dump. I have a picture which pretty much sums it up.

oi40.tinypic.com/25ksy2f.jpg

I suppose that the "extra" minerals is what you get from reprocessing it? But then how am I supposed to know that building it requires 4219 (without waste) Mexallon for example? Is there another table?

Thanks in advance!

To bet the basic material list for creation:
select typeid,name,greatest(sum(quantity),0) quantity from (select invTypes.typeid typeid,invTypes.typeName name,quantity from invTypes,invTypeMaterials where invTypeMaterials.materialTypeID=invTypes.typeID and invTypeMaterials.TypeID=? union select invTypes.typeid typeid,invTypes.typeName name,invTypeMaterials.quantity*r.quantity*-1 quantity from invTypes,invTypeMaterials,ramTypeRequirements r,invBlueprintTypes bt where invTypeMaterials.materialTypeID=invTypes.typeID and invTypeMaterials.TypeID =r.requiredTypeID and r.typeID = bt.blueprintTypeID AND r.activityID = 1 and bt.productTypeID=? and r.recycle=1) t group by typeid,name

Explanation: Take the list from invTypeMaterials. Then subtract the list of materials for any module in the extra materials list, which is marked as recyclable, multipled by the number of items being used. If it's ever less than 0, round it off to 0.

Apply ME waste (by the percentage mentioned in invBlueprintTypes) and Production Efficiency waste. Remember than negative ME waste is handled differently.

Then you add the extra items on top. If they exist in the main list, then they also have PE waste applied (not ME waste)



If you're just looking for somewhere the numbers are run for you (at different ME values) take a look at the blueprint calculator on my site.