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.
 

T2 BPC Bill of Materials

Author
Paul Impact
School of Applied Knowledge
Caldari State
#1 - 2013-10-24 16:11:56 UTC
When manufacturing a T2 BPC do you need the materials listed under "Materials" or only those under "Extra materials" or both?

The reason I ask is that when looking up the consumed materials on Chruker's site it lists both however in TypeRequirements in the official data dump only the extra materials are listed during the manufacturing process.
Abdiel Kavash
Deep Core Mining Inc.
Caldari State
#2 - 2013-10-24 16:19:53 UTC
You need both.
Paul Impact
School of Applied Knowledge
Caldari State
#3 - 2013-10-24 16:23:00 UTC  |  Edited by: Paul Impact
Thanks. Any idea where to find the "Materials" list for T2 BPC's in the datadump?

EDIT: Seems like the T1 materials are listed under TypeMaterials.
Abdiel Kavash
Deep Core Mining Inc.
Caldari State
#4 - 2013-10-24 17:21:40 UTC
Huttan Funaila
Caldari Provisions
Caldari State
#5 - 2013-10-24 17:32:24 UTC
Paul Impact
School of Applied Knowledge
Caldari State
#6 - 2013-10-24 19:11:40 UTC  |  Edited by: Paul Impact
So TypeRequirements accounts for the "Extra Materials" and TypeMaterials accounts for "Materials" and re-processing data.

One question, for items like the Vargur which don't require minerals to manufacture but produce minerals when re-processed how am I supposed to determine which items are actually used during manufacturing from the TypeMaterials DB?
Zifrian
Federal Defense Union
Gallente Federation
#7 - 2013-10-24 20:02:18 UTC
This question is more of a Tech forum question. You'll find more links and such there as well.

Here's an old thread on this that might help: http://oldforums.eveonline.com/?a=topic&threadID=1220024

Maximze your Industry Potential! - Download EVE Isk per Hour!

Import CCP's SDE - EVE SDE Database Builder

Paul Impact
School of Applied Knowledge
Caldari State
#8 - 2013-10-24 20:34:13 UTC
I think taking away the T1 reprocess amount from the T2 bill of materials in the DB is the only way to get the amount of materials needed to be added for the T2 job. I was hoping there might be a table with the values listed but I can achieve the desired effect.
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#9 - 2013-10-24 20:59:16 UTC
http://www.fuzzwork.co.uk/2012/10/24/eve-sde-sql-blueprint-details/

There's no table that contains a complete BOM.

Here's a single query for mysql
https://www.fuzzwork.co.uk/2013/07/21/updated-bill-of-materials-bom-sql-for-the-sde/

and the same for sql server.
https://www.fuzzwork.co.uk/2013/09/02/bom-sql-server-guest-post/


(though it doesn't quite work with things like damaging RAM, due to rounding)

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter