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.
 

Odyssey and Excel
Author
Previous Topic Next Topic
SgtMaj Plumley
Short Bus Pole Dancers
#1 - 2013-06-20 17:33:50 UTC
Does anyone have the new manufacturing build requirements for Odyssey in excel format (Piv Tables)? I am no good with sql type of DBs, but am rather decent with Excel.

I simply need the data dump in excel so that I can build my own PIV tables.

I would be more than grateful for any help or guidance.
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#2 - 2013-06-20 18:30:13 UTC
I've not pivoted them, due to the large number of columns, if you were to pivot them all.

However:
http://www.fuzzwork.co.uk/dump/odyssey-1.0.7-89602/

Should be of interest.

Specifically:
invTypes
InvTypeMaterials
ramTypeRequirements

As an alternate option, you could use the XML tables from my blueprint calculator to load in data as required.


7zip will unzip bz2's with no trouble.

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
SgtMaj Plumley
Short Bus Pole Dancers
#3 - 2013-06-22 15:50:05 UTC
i found something interesting in the data downloads from your site.

While linking my sheets and doing vlookup functions, i noticed that there are none of the constructions components use fermionic condensates for the invtypematerials.

I checked this across jitonomic, and fermionic condensates are used.

Antimatter Reactor Units is my example component
Rutger Janssen
Chanuur
The Initiative.
#4 - 2013-06-22 18:56:34 UTC
Fermionic condensates are now extra materials which are listed in ramTypeRequirements
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#5 - 2013-06-22 19:11:40 UTC
Rutger Janssen wrote:
Fermionic condensates are now extra materials which are listed in ramTypeRequirements



exactly this.

Extra Materials are not returned on recycling, and are not affected by ME waste. They are affected by Production Efficiency waste if, and only if, they appear in the base materials too.

You're wanting the items from ramTypeRequirements when it's activity 8. It's indexed by the blueprint type, rather than the product type.

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Bill Rackner
Catapan Enterprises UK
#6 - 2013-06-23 02:35:10 UTC
Is there a conversion to an MS Access DB of the data ?
EveHQ used to produce one with all the relationships established, but have not done so for a couple of years.
I'd rather not have to start setting up and learning SQL from scratch, when most of my work is with Excel and Access
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#7 - 2013-06-23 05:19:05 UTC
Bill Rackner wrote:
Is there a conversion to an MS Access DB of the data ?
EveHQ used to produce one with all the relationships established, but have not done so for a couple of years.
I'd rather not have to start setting up and learning SQL from scratch, when most of my work is with Excel and Access



Because I'm a nice guy: http://www.fuzzwork.co.uk/dump/odyssey-1.0.7-89602/odyssey107-89602.zip

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
SgtMaj Plumley
Short Bus Pole Dancers
#8 - 2013-06-24 16:31:11 UTC
Cool, thanks. Once I get my spreadsheets all linked, i'll gladly share if anyone is interested.
SgtMaj Plumley
Short Bus Pole Dancers
#9 - 2013-06-24 21:13:37 UTC
I am having issues linking the bp list to the materials. What is the relationship with the bp list and typematerials? I guess my problem is getting antimatter reactor component (for example) with the other intermediate material required to build one component. Lastly, does ME affect the ramtyperequirement differently than typematerial?
Bill Rackner
Catapan Enterprises UK
#10 - 2013-07-01 09:46:53 UTC
Thanks Steve, I'll start updated my old db now.Big smile