EVE Search - Odyssey and Excel

All Channels

Science and Industry

Odyssey and Excel

» Click here to find additional results for this topic using Google

Monitor this thread via RSS [?]

Pages: 1 :: [one page]
Author	Thread Statistics \| Show CCP posts - 0 post(s)
SgtMaj Plumley Caldari Provisions Caldari State 0	Posted - 2013.06.20 17:33:00 - [1] - Quote 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 1554	Posted - 2013.06.20 18:30:00 - [2] - Quote 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. Steve Ronuken for CSM 9!-á I'm starting early :) Handy tools and an SDE conversion Twitter: @fuzzysteve on Twitter
SgtMaj Plumley Caldari Provisions Caldari State 0	Posted - 2013.06.22 15:50:00 - [3] - Quote 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 Xanadu 82	Posted - 2013.06.22 18:56:00 - [4] - Quote Fermionic condensates are now extra materials which are listed in ramTypeRequirements
Steve Ronuken Fuzzwork Enterprises 1564	Posted - 2013.06.22 19:11:00 - [5] - Quote 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. Steve Ronuken for CSM 9!-á I'm starting early :) Handy tools and an SDE conversion Twitter: @fuzzysteve on Twitter
Bill Rackner Nightweave Operations Revenant Alliance 0	Posted - 2013.06.23 02:35:00 - [6] - Quote 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 1569	Posted - 2013.06.23 05:19:00 - [7] - Quote 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 Steve Ronuken for CSM 9!-á I'm starting early :) Handy tools and an SDE conversion Twitter: @fuzzysteve on Twitter
SgtMaj Plumley Caldari Provisions Caldari State 0	Posted - 2013.06.24 16:31:00 - [8] - Quote Cool, thanks. Once I get my spreadsheets all linked, i'll gladly share if anyone is interested.
SgtMaj Plumley Caldari Provisions Caldari State 0	Posted - 2013.06.24 21:13:00 - [9] - Quote 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 Nightweave Operations Revenant Alliance 0	Posted - 2013.07.01 09:46:00 - [10] - Quote Thanks Steve, I'll start updated my old db now.

Pages: 1 :: [one page]

COPYRIGHT NOTICE
EVE Online, the EVE logo, EVE and all associated logos and designs are the intellectual property of CCP hf. All artwork, screenshots, characters, vehicles, storylines, world facts or other recognizable features of the intellectual property relating to these trademarks are likewise the intellectual property of CCP hf. EVE Online and the EVE logo are the registered trademarks of CCP hf. All rights are reserved worldwide. All other trademarks are the property of their respective owners. CCP hf. has granted permission to EVE-Search.com to use EVE Online and all associated logos and designs for promotional and information purposes on its website but does not endorse, and is not in any way affiliated with, EVE-Search.com. CCP is in no way responsible for the content on or functioning of this website, nor can it be liable for any damage arising from the use of this website.