EVE Search - PI Planet & Product Matrix v1.0 now Available

Search EVE-Online forums for:

All Channels

Science and Industry

PI Planet & Product Matrix v1.0 now Available

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

Monitor this thread via RSS [?]

Pages: [1] 2 :: one page

Author	Thread Statistics \| Show CCP posts - 0 post(s)
Snidely Backlash Backlash Enterprises	Posted - 2010.05.29 13:14:00 - [1] Introducing a new PI tool: PI Planet & Product Matrix - Tier-based representation of the PI products and building blocks. - Drill down to the individual planets required. - Selections for up to 6 planet types with resulting matrix of available materials. - Stoplight color coding for simple interpretation. Legends provided. - Simple Excel 2007 workbook; no macros, only self-contained table lookups and conditional formats. File can be downloaded at Eve-Files: http://dl.eve-files.com/media/1005/PI_Planet__Product_Matrix_v10.zip Seeking feedback on any errors or simple upgrade ideas. Positive and negative critiques welcome. Similar to many other tools out there, but with an enhanced, easy to interpret presentation for deciding which combination of planets will best meet a character's PI plan.
Zerixx	Posted - 2010.05.29 14:02:00 - [2] Edited by: Zerixx on 29/05/2010 14:02:18 ta very much for effort..checking out now
Mukutep Gallente The Freelancer's Mining Cartel	Posted - 2010.05.29 14:31:00 - [3] This is exactly something I was looking for - where you can select the planets you have and it shows you what you can make. Well done.
CheckSum Hashfail	Posted - 2010.05.29 15:48:00 - [4] any way to provide this is in .xls format?
Zerixx	Posted - 2010.05.29 15:51:00 - [5] Edited by: Zerixx on 29/05/2010 15:51:43 would it be possible to expand it to 9 planets instead of 6 ? just in case someone have access to all of the types
Louis deGuerre Gallente Amicus Morte Shock an Awe	Posted - 2010.05.29 18:29:00 - [6] Edited by: Louis deGuerre on 29/05/2010 18:29:57 Looks nice. It does not work in OpenOffice 3.1.1, had to upgrade to 3.2.0 to make it work. Nice work ! EDIT : Delay that, still doesn't work in OpenOffice. Sol: A microwarp drive? In a battleship? Are you insane? They arenFt built for this! Clear Skies - The Movie
De'Veldrin Minmatar Special Projects Executive The Obsidian Legion	Posted - 2010.05.29 20:11:00 - [7] Nicely done! --Vel
AtlantisX	Posted - 2010.05.30 02:00:00 - [8] Also having problems viewing this in Openoffice. Tried the Microsoft Excel Viewer, but didn't allow me to play with the dropdown menus. Converting using Openoffice and other options to xls didn't work for me either :(
Xanriaa	Posted - 2010.05.30 05:06:00 - [9] Very nice, thanks for the hard work. For those of you that have a version of Office that is earlier than 2007, check out this KB article from Microsoft: http://support.microsoft.com/kb/924074 The article will give you a link to the updates needed for your version of Office. For those without office, you can get the xlsx viewer from: http://www.microsoft.com/downloads/details.aspx?familyid=1cd6acf9-ce06-4e1c-8dcf-f33f669dbc3a&displaylang=en Hope that helps :-)
Snidely Backlash Backlash Enterprises	Posted - 2010.05.30 11:23:00 - [10] Originally by: CheckSum Hashfail any way to provide this is in .xls format? In order to avoid VBA macros, I've used Excel 2007 table header references that don't exist in Excel 2003. So a 2003 version would require significant rework and I doubt I'll get to it. Sorry. The Excel 2007 viewer from MS is a good option. Originally by: Zerixx would it be possible to expand it to 9 planets instead of 6 ? just in case someone have access to all of the types I'm not sure I understand the point of expanding beyond 6 planets. With full skills, 6 planets is the maximum "commandable" and with 6 planets you can already reach full access to all components anyway. If you just want to see the product tiers without color codes, just leave the selection fields blank (red tiers) or filled with an optimum 6 planets (green tiers).

Javajunky	Posted - 2010.05.30 11:36:00 - [11] Great Work!
AtlantisX	Posted - 2010.05.30 11:53:00 - [12] Originally by: Xanriaa For those without office, you can get the xlsx viewer from: http://www.microsoft.com/downloads/details.aspx?familyid=1cd6acf9-ce06-4e1c-8dcf-f33f669dbc3a&displaylang=en I have tried the xlsx viewer, and it does not allow me to change the planets I have access to. The dropdown menu arror is there, but unclickable. It's a shame, the spreadsheet looks real useful. Does anyone have any other workarounds? Also, regarding 6 or more planets, many people are using alts to have several planets worth of production (like I intend to use one of each planet for extraction, and two planets for the factories). While I understand it's impossible to create an arbitary number of planets, 12 would probably be the most reasonable for most players. Tis an awesome sheet though. Exactly what I was looking for.
Snidely Backlash Backlash Enterprises	Posted - 2010.05.30 12:41:00 - [13] Sorry to hear about the 2007 viewer not working. I didn't realize there was that big of a playerbase still using Excel 2003. I'll see if I can't rebuild this thing from the ground up again with Excel 2003 compatibility (ugh). As a workaround, for those with the 2007 viewer that can't use the planet pulldowns, can you try manually typing in the planet name in the cell. Make sure you match the name shown on the bottom table of planet resources. If that works could you please post your successful method. Finally, can someone confirm the player that runs EVE-FILES? Is it Chribba? It's simply the best support idea for users that I've ever seen, and one that gaming companies should be ashamed to have to leave to users to create.
AtlantisX	Posted - 2010.05.30 14:41:00 - [14] Confirming that EVE-Files is owned by Chribba.
Snidely Backlash Backlash Enterprises	Posted - 2010.05.30 16:16:00 - [15] I've rebuilt the tool using an Excel 2003 native format. During my Excel 2007 save, I show no incompatibilities, but I could use a confirmation from someone who actually has Excel 2003. No idea if the 2003 version will work on OpenOffice, it still uses table lookups and referencing. New download link on original post. Feedback welcome.
AtlantisX	Posted - 2010.05.30 17:09:00 - [16] Works great in openoffice now. Thanks for your hard work.
Brock Nelson Caldari Flux Technologies Inc SRS.	Posted - 2010.05.30 18:26:00 - [17] Confirming that it works on Excel 2003. This is an excellent work and will be useful for me to determine how to utilize planets within my chosen system. Thanks Store
Issaqauh	Posted - 2010.05.30 19:09:00 - [18] The first version did not work with Excel 2008 for Mac. The v101 I confirmed does work with Mac Excel 2008. Thanks for the update.
Snidely Backlash Backlash Enterprises	Posted - 2010.05.30 20:46:00 - [19] Good to hear that the current version works on all systems now. For the future, I'll take a look at adding broad extraction and processing assignments with units/volumes. And many thanks to those who donated ISK. Not expected, but very much appreciated.
Kann Du	Posted - 2010.05.30 21:07:00 - [20] thanks a lot for this, i was in the process of making my own and getting a headache for my trouble


Chribba Otherworld Enterprises Otherworld Empire	Posted - 2010.05.31 18:33:00 - [21] Originally by: AtlantisX Confirming that EVE-Files is owned by Chribba. I too confirm this. Secure 3rd party service \| my in-game channel 'Holy Veldspar'

Facepalm Amarr Battlestars Wildly Inappropriate.	Posted - 2010.06.01 08:09:00 - [22] Quote: Originally by: Zerixx would it be possible to expand it to 9 planets instead of 6 ? just in case someone have access to all of the types I'm not sure I understand the point of expanding beyond 6 planets. With full skills, 6 planets is the maximum "commandable" and with 6 planets you can already reach full access to all components anyway. If you just want to see the product tiers without color codes, just leave the selection fields blank (red tiers) or filled with an optimum 6 planets (green tiers). People with alts. Also people/corps working in tandom with each other. Regardless, nice work! Will follow its progress.
Caldari 5 Amarr The Element Syndicate Hand That Feeds	Posted - 2010.06.01 08:17:00 - [23] Originally by: Facepalm Quote: Originally by: Zerixx would it be possible to expand it to 9 planets instead of 6 ? just in case someone have access to all of the types I'm not sure I understand the point of expanding beyond 6 planets. With full skills, 6 planets is the maximum "commandable" and with 6 planets you can already reach full access to all components anyway. If you just want to see the product tiers without color codes, just leave the selection fields blank (red tiers) or filled with an optimum 6 planets (green tiers). People with alts. Also people/corps working in tandom with each other. Regardless, nice work! Will follow its progress. Would it be possible to create a Corp Version of this file with different tabs/sheets for different Characters? (maybe a sheet that is a template that we can copy multiple times?)
Ki Shodan Gallente deep blue	Posted - 2010.06.01 13:59:00 - [24] Originally by: Snidely Backlash PI Planet & Product Matrix Excellent! -- Evemail me, if my name is used as guarantor!
Arot Svaer	Posted - 2010.06.01 16:07:00 - [25] Excellent Job! This will be very useful.
Psionist	Posted - 2010.06.02 03:26:00 - [26] Thanks!
Chilton Haynes	Posted - 2010.06.02 04:49:00 - [27] excellent...
Rellana1	Posted - 2010.06.02 11:19:00 - [28] confirming it doesn't work with XL viewer,as I can't open the drop-down boxes. Anyone been able to get it to work?
Casiella Truza Ecliptic Rift New Eden Research.	Posted - 2010.06.02 18:41:00 - [29] Another shout of thanks here!
Razaschi	Posted - 2010.06.02 18:52:00 - [30] thanks for your work ... possibly you could enhance it by placing a list of regions in which a kind of planet can be found kind regards



Pages: [1] 2 :: one page
First page \| Previous page \| Next page \| Last 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.