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.
 

List of what the list are for at https://www.fuzzwork.co.uk/dump/lates

Author
Serenit Adoulin
Stille Gewalt
#1 - 2015-08-02 19:41:54 UTC
So I have made myself a tool in a google docs table for production of t1 and t2 items with a lot of workarounds, which I am proud of nevertheless

But now I changed corp and I would like to build myself a new tool that is more complete and is easier to maintain.

Reading this https://forums.eveonline.com/default.aspx?g=posts&t=412172 post helped me out a ton with the implementation of the Blueprint requirement list (used to fill out manually how much of xyz material 123 needed for production)


And i learned about the importdata function.

But looking at https://www.fuzzwork.co.uk/dump/lates there are a ton of xml sheets with lists i have no real clue of what they contain. But seem to be usefull if I knew better.

So is there a website or anything else where I can look up what a individual list there shows me?

I allready figured that

industryActivityMaterials.xls gives me the materialrequirements of a blueprint and If it is a production or an Invention process.

Any help is appreciated. I'm just doing this as a hobby and have near no experience besides a trading spreadsheet tutorial from youtube and my previous production sheet project

comands used are mainly , vlookup, IF, importxml (eve central prices), concadenate(from the tutorial, to pull multible prices at once), and subsitute to convert the importent numbers into strings that could be added to other numbers.

thanks for your time.

Plleasure Hub
Municorn
#2 - 2015-08-02 19:53:37 UTC
Great question! I would love to see a breakdown of this, too. I am guessing here, but I believe Steve has many of the database tables from CCP's Static Data Export, as well as some custom tables he made himself by running queries.

Check this page out:
http://wiki.eve-id.net/Category:CCP_DB_Tables

You'll recognize a bunch of those on Steve's website, but he also has files that aren't listed on that wiki.

"There's no meaningful difference between a real and a virtual world. It's pointless to ask anyone who they really are. All you can do is accept and believe in them, because whoever they are in your mind, is their true identity." — Kazuto Kirigaya

Zifrian
The Frog Pond
Ribbit.
#3 - 2015-08-02 21:11:21 UTC
Plleasure Hub wrote:
Great question! I would love to see a breakdown of this, too. I am guessing here, but I believe Steve has many of the database tables from CCP's Static Data Export, as well as some custom tables he made himself by running queries.

Check this page out:
http://wiki.eve-id.net/Category:CCP_DB_Tables

You'll recognize a bunch of those on Steve's website, but he also has files that aren't listed on that wiki.

That's the general site for documentation. However, it's a bit out of date. CCP doesn't have time to document the SDE so you can check the tech forums and see about adding your information to the documentation on github.

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

Import CCP's SDE - EVE SDE Database Builder