Pages: [1] :: one page |
|
Author |
Thread Statistics | Show CCP posts - 0 post(s) |
Lefty McRightWing
Caldari Provisions Caldari State
0
|
Posted - 2013.05.13 16:50:00 -
[1] - Quote
Is there a spreadsheet or a fast way of extracting the base mineral values of each module/charge/ship in EVE?
I've searched around and can't find a spreadsheet tthat I could manipulate myself. I've found the SQL mass data export but can't get it to make sense in excel.
I just want to know what minerals are in what components, if such a spreadsheet exists let me know, please! I'm trying to make one by hand and as I'm doing it, it has become obvious it will take weeks, especially given excels forumla nuances.
Thanks in advance,
Lefty |
Soldarius
Deadman W0nderland Tribal Band
313
|
Posted - 2013.05.13 20:56:00 -
[2] - Quote
You're going in the right direction by getting the data export. Now you have to extract all the blueprints and their components. tbh, I'm not sure if Excel can handle all that. Someone with more knowledge might post. "How do you kill that which has no life?" |
Tau Cabalander
Retirement Retreat Working Stiffs
1820
|
Posted - 2013.05.13 21:18:00 -
[3] - Quote
Salvage tools: http://eve.podzone.net/wsdb/?op=rig_builder http://www.fuzzwork.co.uk/salvage/ |
Rutger Janssen
Xanadu
75
|
Posted - 2013.05.13 21:57:00 -
[4] - Quote
Get the datadump in an sql datadump. Develop a query that gets you all the data you want in the format you want and export the results. |
RubyPorto
SniggWaffe YOUR VOTES DON'T COUNT
3372
|
Posted - 2013.05.13 22:47:00 -
[5] - Quote
If you're just looking for something to figure out what's worth reprocessing, this might help.
http://www.homo-programmatis.com/EveRefinery/ This is EVE - Everybody Versus Everybody.
"the risk of having your day ruined by other people is the cornerstone with which EVE was built and we want to keep that (infact, this is much more representative of the consensus opinion within CCP)." -CCP Solomon |
Emma Royd
Maddled Gommerils
243
|
Posted - 2013.05.14 05:22:00 -
[6] - Quote
Just be careful if you're aiming to reprocess cheap stuff of the market for the minerals, that you don't get caught out with the "Extra Minerals" that things are appearing with in their requirements. You don't get them back in reprocessing.
|
DeLindsay
Galaxies Fall
129
|
Posted - 2013.05.14 10:42:00 -
[7] - Quote
Both are VERY nice tools, props on the makers.
That is all. |
Steve Ronuken
Fuzzwork Enterprises
1399
|
Posted - 2013.05.14 16:02:00 -
[8] - Quote
Lefty McRightWing wrote:Is there a spreadsheet or a fast way of extracting the base mineral values of each module/charge/ship in EVE?
I've searched around and can't find a spreadsheet tthat I could manipulate myself. I've found the SQL mass data export but can't get it to make sense in excel.
I just want to know what minerals are in what components, if such a spreadsheet exists let me know, please! I'm trying to make one by hand and as I'm doing it, it has become obvious it will take weeks, especially given excels forumla nuances.
Thanks in advance,
Lefty
All you're wanting in the minerals you get back when refining something? Nothing else?
In a spreadsheet of the form:
typeid/typename of the thing,trit,pye,mex,iso,mega,,nocx,morp,zyd
?
As it's easier to build the entire thing, without limiting to minerals:
The query to generate the unpivoted data is:
select it.typeid,it.typename,it2.typename,itm.materialTypeID,quantity from invTypeMaterials itm join invTypes it on (itm.typeID=it.typeID) join invTypes it2 on (it2.typeid=itm.materialTypeID) where it.published=1 order by it.typeid
http://www.fuzzwork.co.uk/resources/materials.txt is the tab separated output. Around 26000 lines. Excel or any other decent spreadsheet will be able to open it no trouble.
If you then pivot it (to turn some rows into columns) you'll get a spreadsheet like this. It's in xlxs format, because of the number of columns. http://www.fuzzwork.co.uk/resources/materials.zip
Which is about 10mb uncompressed, 5 compressed.
If you want it hacked down to /just/ minerals, drop me a mail (due to forum notifications being broken) and I'll bang on it a bit. Steve Ronuken for CSM 9!-á I'm starting early :) Handy tools and an SDE conversion Twitter: @fuzzysteve on Twitter |
Lefty McRightWing
Caldari Provisions Caldari State
0
|
Posted - 2013.05.16 08:11:00 -
[9] - Quote
Steve Ronuken wrote:Lefty McRightWing wrote:Is there a spreadsheet or a fast way of extracting the base mineral values of each module/charge/ship in EVE?
I've searched around and can't find a spreadsheet tthat I could manipulate myself. I've found the SQL mass data export but can't get it to make sense in excel.
I just want to know what minerals are in what components, if such a spreadsheet exists let me know, please! I'm trying to make one by hand and as I'm doing it, it has become obvious it will take weeks, especially given excels forumla nuances.
Thanks in advance,
Lefty All you're wanting in the minerals you get back when refining something? Nothing else? In a spreadsheet of the form: typeid/typename of the thing,trit,pye,mex,iso,mega,,nocx,morp,zyd ? As it's easier to build the entire thing, without limiting to minerals: The query to generate the unpivoted data is: select it.typeid,it.typename,it2.typename,itm.materialTypeID,quantity from invTypeMaterials itm join invTypes it on (itm.typeID=it.typeID) join invTypes it2 on (it2.typeid=itm.materialTypeID) where it.published=1 order by it.typeid http://www.fuzzwork.co.uk/resources/materials.txt is the tab separated output. Around 26000 lines. Excel or any other decent spreadsheet will be able to open it no trouble. If you then pivot it (to turn some rows into columns) you'll get a spreadsheet like this. It's in xlxs format, because of the number of columns. http://www.fuzzwork.co.uk/resources/materials.zipWhich is about 10mb uncompressed, 5 compressed. If you want it hacked down to /just/ minerals, drop me a mail (due to forum notifications being broken) and I'll bang on it a bit.
Big thanks to everyone, especially Steve. TYVM.
|
|
|
|
Pages: [1] :: one page |
First page | Previous page | Next page | Last page |