| Author |
Topic |
Lachenlaud
Minmatar
Wolfhaven Productions
|
Posted - 2005.05.28 14:34:00 - [ 1]
Edited by: Lachenlaud on 07/07/2005 07:15:57Greetings from Golden Oak Industries!  CURRENT STATUS:  BUGFIX+MAJOR UPDATE 7/7/05 v12.10July 7, 2005 - The EMD has been updated for the "Cold War" patch. It contains updates for all the new skills and all of the new ships as well as the modifications made to existing ships. I have not yet updated the HRL column on the Skills Description tab but will release that in a bug fix later this month. The implant guide has been removed because it is so out of date. (BUGFIX - Corrected the HRL Column on the Skills Description Tab, Correction to Torpedos - now Torpedoes, Minor Cosmetic Adjustments). I've been developing an Eve Skills Chart in Excel for well over a year now, and I am glad that so many of you enjoy it. Please continue to send me bug reports. I would like to thank all the people who have supported me thus far with this project, it has been a long adventure, that will hopefully continue as long as Eve-Online.  This spreadsheet will allow you to calculate how long individual skills will take you to train, set a goal for all your skills, and give you a total time until you reach your goal. The sheet takes into account all of your info once you enter your base attributes from your character, and the current amount of skill points you have invested in each skill. For most users of Excel, it even has an auto-update feature that will pull in your information from the XML provided by CCP on your on-line character sheet. (I only guarantee that the XML update fucntion will work with Excel versions 10.2614.2625 and above.) Some of the things you will find on the spreadsheet are * A skills tracking spreadsheet and monitor * A skills description spreadsheet with skill requirements * A skillset Graph giving you the big picture including Distribution, Attributes, etc. * A skillset summary with non-graphical information on the skillset graph * An ore Yields calculator by Histracko * An ice yields calculator by Histracko * A basic production calculator for mining by Histracko * A ships information page (that will show you what ships you can use based on skills) * A skill guide by Hardin * Very basic instructions on how to use the sheet * My contact informaion * An XML Data Interface page  If you would like to try it out, go here http://www.goi-eve.com/emd/EMDv1210.zip. (PLEASE - Keep the ideas/bug reports coming, and if I'm missing a skill, PLEASE send me a screen cap of it via e-mail at lachenlaud@goi-eve.com) Please note, you must use a web-browser OUTSIDE of eve to download this file and you must have a recent version of Excel and understand a spreadsheet to effectively use this tool. Evemail me with comments/suggestions on it or use the email address located at the bottom of the sheet to contact me outside of Eve. (The structure of the filename is now EMD <for Eve Master Datasheet> + v <for Version> followed by a number #### <for v Number xx.xx>, thus EMDv1200 would be Eve Master Datasheet version 12.00. I hope you all enjoy the update! |
Vilserx |
Posted - 2005.05.28 14:56:00 - [ 2]
Looks good except, unfortunately, I can't get the auto-update working. When I hit Ctrl+G I get a Runtime 1004 error.  |
Thunaraz |
Posted - 2005.05.28 15:16:00 - [ 3]
Edited by: Thunaraz on 28/05/2005 15:16:24 Originally by: Vilserx
Looks good except, unfortunately, I can't get the auto-update working. When I hit Ctrl+G I get a Runtime 1004 error.
As stated - "I only guarantee that the XML update fucntion will work with Excel versions 10.2614.2625 and above." This is a known issue with older versions of Excel. Lach's been trying to fix it forever. What version of excel are you running Vilserx? Go into Excel - Click on the Help Menu, then About Microsoft Excel and you will see the version in the window. |
Vilserx |
Posted - 2005.05.28 16:21:00 - [ 4]
9.0 There you go then |
Lachenlaud
Minmatar
Wolfhaven Productions
|
Posted - 2005.05.28 16:25:00 - [ 5]
Edited by: Lachenlaud on 28/05/2005 16:27:04
5/28/05 v11.52
* Fixed skillcheck on Cerberus and Basilisk (Cerberus was flagged as logistics ship, Basilisk was not) :-P (Thanks for the bug report Kalest)
* Added a user-defined field in the EVE-XML Data sheet for people with multiple characters called 'Character 1,2 or 3'. (Example: If you have more than one character the first character you created is 1, the second is 2, and the third is 3. Thus if you have three characters created in the order of Tom, Richard and Harry, Tom would =1 Richard would =2 and Harry would =3.
* In order for the spreadsheet to autoupdate the correct character, you have to tell it WHICH of the three you are trying to autoupdate FOR in addition to the usual URL character #.)
* Special thanks to Thunaz for bringing his problem to my attention and giving me the incentive and reason to fix it.
NOTE: YOU MUST LOG IN TO EVE-ONLINE.COM in Internet Explorer before using the autoupdate feature and when you do so tell it to SAVE your password or the function may not work. |
Reva Ortov
Net-7 Inc. |
Posted - 2005.05.28 17:59:00 - [ 6]
Great sheet- been using it for awhile Get the mods to unsticky the old one and sticky the chapter II. Thx for the the ore and ice yields- very simple and easy to use. Mobile Refinery and mobile factory skills under industry are missing. Keep up the good work. |
Lachenlaud
Minmatar
Wolfhaven Productions
|
Posted - 2005.05.29 04:43:00 - [ 7]
Originally by: Reva Ortov
Great sheet- been using it for awhile
Get the mods to unsticky the old one and sticky the chapter II.
Thx for the the ore and ice yields- very simple and easy to use.
Mobile Refinery and mobile factory skills under industry are missing.
Keep up the good work.
Thanks Reva - I'll add the two missing skills asap. The mods are going to take care of it soon™ I think. Keep the bug reports coming :) |
Dargon Starjammer
Gallente |
Posted - 2005.05.29 04:49:00 - [ 8]
awsome. thanks alot. good things come to thoes who wait. |
CCP Wrangler
 |
Posted - 2005.05.29 12:02:00 - [ 9]
Glued. |
Treo Vargas |
Posted - 2005.05.29 15:23:00 - [ 10]
This spreadsheet is amazing! I have been using an older version and just got the newest version.
For anyone having problems with the auto-update, you have to use IE. I couldn't get it to work with firefox). |
Lachenlaud
Minmatar
Wolfhaven Productions
|
Posted - 2005.05.29 19:12:00 - [ 11]
Originally by: Wrangler
Glued.
Thank you Vice Admiral |
BillyBong2
Amarr
Destructive Influence
IT Alliance |
Posted - 2005.05.30 03:53:00 - [ 12]
Lachenlaud,
You are da ****nit! Using this for my character now, really helps in determining how much help an implant will be or not be.
Thanks! |
MrVilla
Caldari Provisions |
Posted - 2005.05.31 05:39:00 - [ 13]
Rockets has training multiplyer 1 as far as I know.
Great work!! |
Lachenlaud
Minmatar
Wolfhaven Productions
|
Posted - 2005.05.31 22:53:00 - [ 14]
Originally by: MrVilla
Rockets has training multiplyer 1 as far as I know.
Great work!!
You would be correct Sir! Will be updated in any release from 11.54 and up. |
Radar |
Posted - 2005.06.03 05:50:00 - [ 15]
I apoligize for the newb question, but where would one find their char ID# to load into the XML page before hitting Ctrl-G? |
Fjellu
Celestial Horizon Corp.
United Corporate Ventures |
Posted - 2005.06.03 10:56:00 - [ 16]
Edited by: Fjellu on 03/06/2005 11:00:22
Had to update my Office pack. Microsoft should pay you comission.
Got the macro to semi-work. Following skill is not downloaded.
Gallentean Starship Engineering (small typo in sheet btw)
The 7 new Connections skills seems to be missing
|
MrVilla
Caldari Provisions |
Posted - 2005.06.03 11:09:00 - [ 17]
Originally by: Radar
I apoligize for the newb question, but where would one find their char ID# to load into the XML page before hitting Ctrl-G?
When you log on to view your character skill info on eve-online, you will see it in the end of the url. If my memory serves me right I think it was shown in the help file too (autoupdate.doc) that came with the workbook. |
Lliander |
Posted - 2005.06.04 06:09:00 - [ 18]
Edited by: Lliander on 04/06/2005 06:09:16
Great sheet |
Lachenlaud
Minmatar
Wolfhaven Productions
|
Posted - 2005.06.04 06:10:00 - [ 19]
Originally by: Fjellu
Gallentean Starship Engineering (small typo in sheet btw)
The 7 new Connections skills seems to be missing
Both noted - will be fixed next update release. |
Lachenlaud
Minmatar
Wolfhaven Productions
|
Posted - 2005.06.04 06:15:00 - [ 20]
Originally by: Fjellu
The 7 new Connections skills seems to be missing
Hmm - can't seem to find info on these - care to point me in the right direction Fjellu? |
Fjellu
Celestial Horizon Corp.
United Corporate Ventures |
Posted - 2005.06.04 08:18:00 - [ 21]
Originally by: Lachenlaud
Originally by: Fjellu
The 7 new Connections skills seems to be missing
Hmm - can't seem to find info on these - care to point me in the right direction Fjellu?
http://evegames.hostingbig.com/eve/data/Skills@~32;@~38;@~32;Accessories/Skills/Social/listing.xml The Connections skills are in game, through agent offers for 15k LP's and 10 mil isk. Not DED Connections or Bounty Hunting though (unfortunately) |
Eiye |
Posted - 2005.06.08 11:48:00 - [ 22]
Hey there, where do i get my character number from, i would like to try this sheet out, I saw the number somewhere but cant remember.
Cheers Eiye |
Eiye |
Posted - 2005.06.08 14:49:00 - [ 23]
got it working now,,must say this is an excellent tool, well done! |
Hellspawn01
Amarr |
Posted - 2005.06.10 13:07:00 - [ 24]
Very good work.
Could you change some small things plz? Like remove "Repair drones" and use the skill order in the groups like they are in eve. |
Lachenlaud
Minmatar
Wolfhaven Productions
|
Posted - 2005.06.13 06:34:00 - [ 25]
Originally by: Hellspawn01
Very good work.
Could you change some small things plz? Like remove "Repair drones" and use the skill order in the groups like they are in eve.
Repair drones will eventually be a live skill. Not sure when - but they have published details on it previously. The skills are (except for the categories) in alphabetical order, and will remain that way. I originally had them in 'in-game' order and it was just a bit of a pain to find skills on the sheet for some people (you wouldn't believe the evemail/email I got about it.) |
Eiye |
Posted - 2005.06.14 15:38:00 - [ 26]
When I use the autoupdate function, the only data that I seem to get is information from the news page. Any idea what is going wrong? I am using Office 2003 Pro and IE 6
thanks |
Agrikk |
Posted - 2005.06.15 23:50:00 - [ 27]
Ditto. Office 2003 Pro, XP Pro with SP2. All patched up nice and neat.
But the sheet doesn't update. :( |
Ostirx
Sebiestor tribe |
Posted - 2005.06.16 13:39:00 - [ 28]
I had the same problem but sorted it kind of.
Firstly logged in and ticked the box to saved my password in IE6.
Then went to debug the code, which you do like this.
In excel (office xp) pressed alt-f8 to bring up the macro list.
Then pressed 'step into', which brought up the microsoft visual basic window.
Then pressed f8 which steps through the code one line at a time.
That made it work perfectly.
|
Lachenlaud
Minmatar
Wolfhaven Productions
|
Posted - 2005.06.16 23:13:00 - [ 29]
Originally by: Eiye
When I use the autoupdate function, the only data that I seem to get is information from the news page. Any idea what is going wrong? I am using Office 2003 Pro and IE 6
thanks
Do you have multiple characters on your account? What version of the sheet are you using? |
Eiye |
Posted - 2005.06.17 12:51:00 - [ 30]
I have 2 characters and i'm using version 1152 |
Screenshots & Art
All Channels
EVE MASTER DATASHEET [EMD]Skill Tracking Spreadsheet - COLD WAR UPDATE