Pages: [1] :: one page |
|
Author |
Thread Statistics | Show CCP posts - 0 post(s) |
Sentry Skills
|
Posted - 2010.03.10 03:42:00 -
[1]
Hello, I am the creator of EXCEL-Builder, I am looking for a current itemdata base in xls. Or if any one has a static updating database with this data.
thx
|
Lutz Major
Austriae Est Imperare Orbi Universo
|
Posted - 2010.03.10 07:53:00 -
[2]
I've uploaded a csv export of the invTypes table to http://www.eve-notifications.com/downloads/invTypes.zip. Let me know, if you need more tables.
|
Sentry Skills
|
Posted - 2010.03.11 10:40:00 -
[3]
Thanks, but that isn't what i am looking for.
I need a list of all "Product Names" like All Charges All Commodity Items All Deployable Items All Drones All Modules All Ships All Structures (POS, Outpost, ect)
Then I need the following data for all items
(Table data needed) Product Name Max runs Batch Size Base Wastage Factor Manufacturing Time Research Copy Time Tritanium Pyerite Mexallon Isogen Nocxium Zydrine Megacyte Morphite BLD RAM 1 BLD RAM 1 damage Per run BLD RAM 1 Qty BLD RAM 2 BLD RAM 2 damage Per run BLD RAM 2 Qty BLD Tech 1 Item BLD Tech 1 Item Qty BLD Component 1 BLD Component 1 Qty BLD Component 1 Waste BLD Component 2 BLD Component 2 Qty BLD Component 3 BLD Component 3 Qty BLD Component 4 BLD Component 4 Qty BLD Component 5 BLD Component 5 Qty BLD Component 6 BLD Component 6 Qty BLD Component 7 BLD Component 7 Qty BLD Component 8 BLD Component 8 Qty BLD Component 9 BLD Component 9 Qty BLD Component 10 BLD Component 10 Qty BLD Component 11 BLD Component 11 Qty BLD Component 12 BLD Component 12 Qty BLD Component 13 BLD Component 13 Qty BLD Component 14 BLD Component 14 Qty BLD Component 15 BLD Component 15 Qty BLD Component 16 BLD Component 16 Qty BLD Component 17 BLD Component 17 Qty BLD Component 18 BLD Component 18 Qty productivityModifier
if anyone can help please.
|
Jercy Fravowitz
School of Applied Knowledge
|
Posted - 2010.03.11 11:50:00 -
[4]
Originally by: Sentry Skills I need a list of all "Product Names" like
thats in the invTypes table you got already.
Originally by: Sentry Skills Then I need the following data for all items
this sounds like you have some funny ideas about how eve manufacturing works. how do you f.ex. fit something into your data model where part of the tritanium has me-level waste applied, but some of the tritanium does not?
Originally by: Sentry Skills if anyone can help please.
you are probably better off getting the mssql dump, and importing parts of it into excel yourself.
hints here: dom100 thread
|
Tonto Auri
Vhero' Multipurpose Corp
|
Posted - 2010.03.11 22:21:00 -
[5]
Or just grab EVE Master Sheet... -- Thanks CCP for cu |
Sentry Skills
|
Posted - 2010.03.12 08:19:00 -
[6]
A old buddy of mine Fubar helped me out with this issue. I have everything i need now. Another master peace at work. Thanks again Fubar.
Provide me a link to the EVE Master Sheet and I'll see what I am in for.
|
Sentry Skills
|
Posted - 2010.03.12 08:29:00 -
[7]
Originally by: Jercy Fravowitz
Originally by: Sentry Skills I need a list of all "Product Names" like
thats in the invTypes table you got already.
Originally by: Sentry Skills Then I need the following data for all items
this sounds like you have some funny ideas about how eve manufacturing works. how do you f.ex. fit something into your data model where part of the tritanium has me-level waste applied, but some of the tritanium does not?
Check this http://www.eveonline.com/ingameboard.asp?a=topic&threadID=1017322&page=1
|
Tonto Auri
Vhero' Multipurpose Corp
|
Posted - 2010.03.12 12:32:00 -
[8]
Originally by: Sentry Skills A old buddy of mine Fubar helped me out with this issue. I have everything i need now. Another master peace at work. Thanks again Fubar.
Provide me a link to the EVE Master Sheet and I'll see what I am in for.
Your google-foo is weak today? http://www.eveonline.com/ingameboard.asp?a=topic&threadID=1107558 -- Thanks CCP for cu |
Jercy Fravowitz
School of Applied Knowledge
|
Posted - 2010.03.12 13:07:00 -
[9]
Originally by: Sentry Skills Check this http://www.eveonline.com/ingameboard.asp?a=topic&threadID=1017322&page=1
unable to figure out how to use this so i cant check. but i am pretty sure the calculations will be wrong. very wrong.
example: how many units of trit does it take to build one run of concussion bomb at ME:0 and wastefree skills/facility? you wont be able to get the right result (1414572) with your data model.
|
Fubar
Eagle Eye Inc.
|
Posted - 2010.03.12 14:35:00 -
[10]
Originally by: Jercy Fravowitz
but i am pretty sure the calculations will be wrong. very wrong.
example: how many units of trit does it take to build one run of concussion bomb at ME:0 and wastefree skills/facility? you wont be able to get the right result (1414572) with your data model.
You are making an assumption on how the table is built. The mineral columns only contain minerals that have waste.
I haven't verified that Sentry Skills is using the table properly but I can if she so desires.
I created this table structure about 4 years ago at the request of an excel spreadsheet developer. I update the data with every new patch.
Here is the data for the concussion bomb.
Blueprint Name: Concussion Bomb Blueprint Product Name: Concussion Bomb Category Name: Charge Group Name: Bomb Market Group: Ammunition & Charges - Bombs Max runs: 300 Batch Size: 20 Base Wastage Factor: 0,1 Manufacturing Time: 600 Productivity Modifier: 120 Research Material Time: 12000 Research Copy Time: 12000 Research Productivity Time: 12000 Tritanium: 10000 Pyerite: 100 Mexallon: 10 Isogen: 10 Nocxium: 10 Zydrine: 10 Megacyte: 10 Morphite: 0 Tech Level: 1 BLD RAM 1: 0 BLD RAM 1 damage Per run: 0 BLD RAM 2: 0 BLD RAM 2 damage Per run: 0 BLD Tech 1 Item: 0 BLD Component 1: Isogen BLD Component 1 Qty: 10070 BLD Component 1 Waste: 0 BLD Component 2: Megacyte BLD Component 2 Qty: 370 BLD Component 2 Waste: 0 BLD Component 3: Mexallon BLD Component 3 Qty: 63982 BLD Component 3 Waste: 0 BLD Component 4: Nocxium BLD Component 4 Qty: 2342 BLD Component 4 Waste: 0 BLD Component 5: Pyerite BLD Component 5 Qty: 632432 BLD Component 5 Waste: 0 BLD Component 6: Tritanium BLD Component 6 Qty: 1403572 BLD Component 6 Waste: 0 BLD Component 7: Zydrine BLD Component 7 Qty: 1446 BLD Component 7 Waste: 0
|
|
Jercy Fravowitz
School of Applied Knowledge
|
Posted - 2010.03.12 15:11:00 -
[11]
Originally by: Fubar Here is the data for the concussion bomb.
ah. that is distinctly different from what is used in the xls sentry linked to and can indeed be used to do the right calculation.
|
Sentry Skills
|
Posted - 2010.03.12 20:01:00 -
[12]
The EXCEL-Builder was made about 3 years or so ago. At the time, all the data was 99.9% on point. I'll have a full working sheet in about 2 or 3 weeks. I looked at "The master eve file" it was more of market tool, when compaired to my builder.
|
|
|
|
Pages: [1] :: one page |
First page | Previous page | Next page | Last page |