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

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

EVE Technology Lab

 
  • Topic is locked indefinitely.
 

looking for a list of all manufacturables and their MINERAL ONLY requirements
Author
Previous Topic Next Topic
Wingmate
Perkone
Caldari State
#1 - 2013-07-30 23:33:46 UTC
as the title says, i'm looking for a list of all manufacturables that are made with minerals, and what those mineral requirements are. i specifically only need minerals (working on updating a reprocessing and mineral compression sheet).

gdocs or excel format would be delicious. ideally this just has mineral names along the top, typeIDs along the left, and then filled in info. if i knew more about the API i could pull this with transpose(importxml(whatever)) but i can't get the xml to do what i want.

thanks in advance.

i make spreadsheets for pretty cheap. contact me for more info.

https://forums.eveonline.com/default.aspx?g=posts&t=197433
Omega Flames
Caldari Provisions
Caldari State
#2 - 2013-07-31 01:53:03 UTC
the only way your going to get all of that is by sorting throu the data dumps for eve..assuming they show all that info (ive never needed to look at them yet myself)
Louis Vitton
Viziam
Amarr Empire
#3 - 2013-07-31 02:36:31 UTC
Here is a google doc i just knocked up from the data dump with mysql.
The below shows meta 0 items if you need all items

https://docs.google.com/spreadsheet/ccc?key=0ApWI2uCWkUlJdDhZQVo5a3Q0Sll0dkVmVTdBR2ptV1E&usp=sharing
This is another one that may help: https://forums.eveonline.com/default.aspx?g=warning&l=https%3a%2f%2fwww.fuzzwork.co.uk%2fresources%2fbasicmaterials.zip&domain=fuzzwork.co.uk

https://forums.eveonline.com/default.aspx?g=posts&m=3372998#post3372998

what the above gives you is the base values for the items / perfect values for the blueprints.
When building items they quiet often want be perfect and will have waste and other things associated with them based on blueprint me and skills.
Please see here for the maths involved.
http://wiki.eve-id.net/Equations
https://www.fuzzwork.co.uk/2012/10/24/eve-sde-sql-blueprint-details/

The SQL used to generate this is;
original source: http://wiki.eve-id.net/Reprocessing_Materials
It has been modified to produce only meta 0 with base value above 0 (this removed all other meta levels and some rigs)
Quote:

SELECT
t1.typeID,
t1.typeName,
coalesce(t2.valueFloat, t2.valueInt) AS metalevel,
t1.groupID,
t3.groupName,
t1.volume,
t1.basePrice,
SUM(CASE WHEN m1.materialTypeID = 34 THEN m1.quantity ELSE 0 END) AS Tritanium,
SUM(CASE WHEN m1.materialTypeID = 35 THEN m1.quantity ELSE 0 END) AS Pyerite,
SUM(CASE WHEN m1.materialTypeID = 36 THEN m1.quantity ELSE 0 END) AS Mexallon,
SUM(CASE WHEN m1.materialTypeID = 37 THEN m1.quantity ELSE 0 END) AS Isogen,
SUM(CASE WHEN m1.materialTypeID = 38 THEN m1.quantity ELSE 0 END) AS Nocxium,
SUM(CASE WHEN m1.materialTypeID = 39 THEN m1.quantity ELSE 0 END) AS Zydrine,
SUM(CASE WHEN m1.materialTypeID = 40 THEN m1.quantity ELSE 0 END) AS Megacyte,
SUM(CASE WHEN m1.materialTypeID = 11399 THEN m1.quantity ELSE 0 END) AS Morphite
FROM invTypes t1
INNER JOIN dgmTypeAttributes t2 ON t1.typeID = t2.typeID AND t2.attributeID = 633 AND t1.published = 1 AND t2.valueInt = 0
INNER JOIN invGroups t3 ON t1.groupID = t3.groupID
INNER JOIN invTypeMaterials m1 ON t1.typeID = m1.typeID
INNER JOIN invBlueprintTypes ON m1.typeID = invBlueprintTypes.productTypeID
WHERE t1.published = 1
AND t3.allowManufacture = 1
AND t1.basePrice > 0.00
GROUP BY
t1.typeID,
t1.typeName,
coalesce(t2.valueFloat,t2.valueInt),
t1.groupID,
t3.groupName,
t1.volume,
t1.basePrice
ORDER BY t1.typeName
Wingmate
Perkone
Caldari State
#4 - 2013-07-31 13:28:49 UTC
louis, cool story, i was googling this info and came across a post of yours from a while back with helpful information as well. that's two i owe you now =)

thanks dude!

i make spreadsheets for pretty cheap. contact me for more info.

https://forums.eveonline.com/default.aspx?g=posts&t=197433
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#5 - 2013-07-31 15:00:10 UTC
Wingmate wrote:
i was googling this info


<3

Always nice to see people doing some research on their own Smile

This is just one of the slightly more complicated questions

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Wingmate
Perkone
Caldari State
#6 - 2013-07-31 15:09:36 UTC
incidentally, as far as i can see, i just increased my mineral compression efficiency for isogen and megacyte by like six hundred percent. so yes, this was very helpful =)

i make spreadsheets for pretty cheap. contact me for more info.

https://forums.eveonline.com/default.aspx?g=posts&t=197433
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#7 - 2013-07-31 15:15:08 UTC
https://www.fuzzwork.co.uk/compression/ Blink

Radio XL?
Multifrequency XL?


Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Wingmate
Perkone
Caldari State
#8 - 2013-07-31 15:35:45 UTC  |  Edited by: Wingmate
mjolnir cruise and torps! i needed something with a ton of iso and a reasonable amount of trit without a ton of other stuff. i got a rag into 3mm3 with 2% waste, and into 3 JFs with a bit more =) as for mega, i already had stuff like gas harvesters there, but putting in covert cynos and normal cynos (which have a lot of everything honestly) allowed me to fix both nox and mega.

you guys rock =D

i make spreadsheets for pretty cheap. contact me for more info.

https://forums.eveonline.com/default.aspx?g=posts&t=197433