Pages: [1] 2 3 4 5 6 7 8 9 :: one page |
|
Author |
Thread Statistics | Show CCP posts - 0 post(s) |
AnnaJoy
|
Posted - 2005.12.15 19:03:00 -
[1]
Greetings from The Avalon Foundation!
CURRENT STATUS: BUGFIX+MAJOR UPDATE 7/7/05 v12.10
December 15, 2005 - The EMD is being updated for the "Red Moon Rising" patch. It will contain updates for all the new skills and all of the new ships as well as the modifications made to existing ships and skills.
I'm working to transition the Eve Skills Chart from Lachenlaud so that many of you can continue to enjoy it. Please send bug reports to both Lachenlaud and myself. Until he actually replies with his consent I can only offer a "beta" version of the sheet. Its not fair to him for someone to just take over without his consent. I also want to see an RMR updated sheet and that is why i've worked to get his latest copy up to date and provide it to you in the meantime.
Originally by: Lachenlaud
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 out the original, go Here.
For the beta copy I have created from the above sheet go here.
Originally by: Lachenlaud
(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 [email protected])
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 as much as Lachenlaud's updates.
|
Dr Tetrahydrocannabinol
|
Posted - 2005.12.15 19:07:00 -
[2]
cool ---------------------------------------------
Oveur > CUZ IM EXTREEEEEEEEEEEEEEME!!!! |
Tessa Vaako
|
Posted - 2005.12.16 14:08:00 -
[3]
XML import function seems to be broken.
Import occured, but did not assign SPs to their proper skills. -- Don't Run. You'll Only Die Tired. |
Sharcy
|
Posted - 2005.12.16 15:21:00 -
[4]
AnnaJoy, please see my reply in the original thread...
-- Press [Alt][F4] for my witty signature... |
Karash Amerius
|
Posted - 2005.12.16 16:16:00 -
[5]
You know this sheet has never worked for me...even the old one.
Not sure what could be different on your end than mine.
|
Tessa Vaako
|
Posted - 2005.12.16 16:29:00 -
[6]
Ok, I fixed the XML Macro.
Here is what needs to be done: 1) Copy the skill listing fromt the Skills tab (A13:A330) and paste it to the Eve-XML tab (A10:A327)
2) On the Eve-XML tab, copy the row (B290:H290) and paste it into the block B291:H327.
3) Update the macro with the code below, which has been adjusted to handle the extra skills.
4) Enjoy!
Sub Update_From_Eve_Online() ' Update_From_Eve_Online Macro ' Macro recorded 5/26/05 by Lachenlaud ' ' Keyboard Shortcut: Ctrl+g ' ActiveWindow.ScrollWorkbookTabs Position:=xlLast Sheets("EVE-XML Data").Select Range("I9").Select Selection.QueryTable.Refresh BackgroundQuery:=False Range("G2:G6").Select Selection.Copy ActiveWindow.ScrollWorkbookTabs Position:=xlFirst Sheets("Skills").Select Range("O3:O7").Select Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=False ActiveWindow.ScrollWorkbookTabs Position:=xlLast Sheets("EVE-XML Data").Select Range("H2:H6").Select Application.CutCopyMode = False Selection.Copy ActiveWindow.ScrollWorkbookTabs Position:=xlFirst Sheets("Skills").Select Range("S3:S7").Select Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=False ActiveWindow.ScrollWorkbookTabs Position:=xlLast Sheets("EVE-XML Data").Select Range("F10:F327").Select Application.CutCopyMode = False Selection.Copy ActiveWindow.ScrollWorkbookTabs Position:=xlFirst Sheets("Skills").Select ActiveWindow.SmallScroll Down:=-78 Range("E13:E327").Select Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=False ActiveWindow.SmallScroll Down:=6 Range("K13:K327").Select Range("K327").Activate Application.CutCopyMode = False Selection.Copy ActiveWindow.ScrollWorkbookTabs Position:=xlLast Sheets("EVE-XML Data").Select ActiveWindow.SmallScroll Down:=129 Range("B10:B327").Select Range("B327").Activate Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=False ActiveWindow.SmallScroll Down:=-12 Range("H10:H327").Select Range("H327").Activate Application.CutCopyMode = False Selection.Copy ActiveWindow.ScrollWorkbookTabs Position:=xlFirst Sheets("Skills").Select ActiveWindow.SmallScroll Down:=135 Range("E13:E327").Select Range("E327").Activate Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=False ActiveWindow.ScrollWorkbookTabs Position:=xlLast Sheets("EVE-XML Data").Select Range("J1").Select Application.CutCopyMode = False Selection.Copy ActiveWindow.ScrollWorkbookTabs Position:=xlFirst Sheets("Skills").Select Range("D5").Select Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=False ActiveWindow.ScrollWorkbookTabs Position:=xlLast Sheets("EVE-XML Data").Select Range("B2:C3").Select ActiveWindow.ScrollWorkbookTabs Position:=xlFirst Sheets("Skills").Select Range("C5:E5").Select End Sub -- Don't Run. You'll Only Die Tired. |
AnnaJoy
|
Posted - 2005.12.16 17:33:00 -
[7]
Hehe, I did this while I was at work today. Its now avialable in the link above as v1301.
Originally by: Tessa Vaako Ok, I fixed the XML Macro.
Here is what needs to be done: 1) Copy the skill listing fromt the Skills tab (A13:A330) and paste it to the Eve-XML tab (A10:A327)
2) On the Eve-XML tab, copy the row (B290:H290) and paste it into the block B291:H327.
3) Update the macro with the code below, which has been adjusted to handle the extra skills.
4) Enjoy!
Sub Update_From_Eve_Online() ' Update_From_Eve_Online Macro ' Macro recorded 5/26/05 by Lachenlaud ' ' Keyboard Shortcut: Ctrl+g ' ActiveWindow.ScrollWorkbookTabs Position:=xlLast Sheets("EVE-XML Data").Select Range("I9").Select Selection.QueryTable.Refresh BackgroundQuery:=False Range("G2:G6").Select Selection.Copy ActiveWindow.ScrollWorkbookTabs Position:=xlFirst Sheets("Skills").Select Range("O3:O7").Select Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=False ActiveWindow.ScrollWorkbookTabs Position:=xlLast Sheets("EVE-XML Data").Select Range("H2:H6").Select Application.CutCopyMode = False Selection.Copy ActiveWindow.ScrollWorkbookTabs Position:=xlFirst Sheets("Skills").Select Range("S3:S7").Select Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=False ActiveWindow.ScrollWorkbookTabs Position:=xlLast Sheets("EVE-XML Data").Select Range("F10:F327").Select Application.CutCopyMode = False Selection.Copy ActiveWindow.ScrollWorkbookTabs Position:=xlFirst Sheets("Skills").Select ActiveWindow.SmallScroll Down:=-78 Range("E13:E327").Select Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=False ActiveWindow.SmallScroll Down:=6 Range("K13:K327").Select Range("K327").Activate Application.CutCopyMode = False Selection.Copy ActiveWindow.ScrollWorkbookTabs Position:=xlLast Sheets("EVE-XML Data").Select ActiveWindow.SmallScroll Down:=129 Range("B10:B327").Select Range("B327").Activate Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=False ActiveWindow.SmallScroll Down:=-12 Range("H10:H327").Select Range("H327").Activate Application.CutCopyMode = False Selection.Copy ActiveWindow.ScrollWorkbookTabs Position:=xlFirst Sheets("Skills").Select ActiveWindow.SmallScroll Down:=135 Range("E13:E327").Select Range("E327").Activate Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=False ActiveWindow.ScrollWorkbookTabs Position:=xlLast Sheets("EVE-XML Data").Select Range("J1").Select Application.CutCopyMode = False Selection.Copy ActiveWindow.ScrollWorkbookTabs Position:=xlFirst Sheets("Skills").Select Range("D5").Select Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=False ActiveWindow.ScrollWorkbookTabs Position:=xlLast Sheets("EVE-XML Data").Select Range("B2:C3").Select ActiveWindow.ScrollWorkbookTabs Position:=xlFirst Sheets("Skills").Select Range("C5:E5").Select End Sub
|
Tessa Vaako
|
Posted - 2005.12.16 20:03:00 -
[8]
I fixed it while "working" as well... :)
Thanks for picking this up.
There is also a small bug where a couple of the new drone skills don't get picked up for the "Carebear or Killer" graph. -- Don't Run. You'll Only Die Tired. |
AnnaJoy
|
Posted - 2005.12.16 20:43:00 -
[9]
Originally by: Tessa Vaako There is also a small bug where a couple of the new drone skills don't get picked up for the "Carebear or Killer" graph.
I'll look into it, i thought i had it but i probably missed it... -_-
|
Krycheck Artstad
|
Posted - 2005.12.17 03:32:00 -
[10]
for the life of me I can't get my character ID....when I click on "my character" on eve-online.com and enter my username and password...it always redirects me to eve insider news. everytime. all day, and day. what do I do, or what am i doing wrong?
thanks
|
|
AnnaJoy
|
Posted - 2005.12.17 04:01:00 -
[11]
Originally by: Krycheck Artstad for the life of me I can't get my character ID....when I click on "my character" on eve-online.com and enter my username and password...it always redirects me to eve insider news. everytime. all day, and day. what do I do, or what am i doing wrong?
thanks
Looks like they may have taking down character sheets for a while. =( don't know when they might be back up
|
AnnaJoy
|
Posted - 2005.12.17 04:04:00 -
[12]
I need some people who use the original to please test this "alpha" copy of 13.10 It has all the skills listed in it but its been edited in Open Office. I want to know if the thing still works. please let me know. the link is above and here is a Quick Link.
Thanks
AJ
|
AnnaJoy
|
Posted - 2005.12.17 17:43:00 -
[13]
Originally by: AnnaJoy I need some people who use the original to please test this "alpha" copy of 13.10 It has all the skills listed in it but its been edited in Open Office. I want to know if the thing still works. please let me know. the link is above and here is a Quick Link.
Thanks
AJ
Did anyone try out this edited copy and if so, were you able to run the macro to get your character data? I need to know so that I can either continue to edit it with OO or wait until I am back at work to use Excel instead.
AJ
|
Jatar Poli
|
Posted - 2005.12.17 23:33:00 -
[14]
Character sheet is down. But I did find one thing you could change. On the ore yield page Jaspet, Hemorphite and Hedbergite should have Zydrine. U10=8; U11=28; U12=32. I will test the download when the character sheet is online again. It seems everything else is ok.
|
AnnaJoy
|
Posted - 2005.12.18 00:56:00 -
[15]
Originally by: Jatar Poli Character sheet is down. But I did find one thing you could change. On the ore yield page Jaspet, Hemorphite and Hedbergite should have Zydrine. U10=8; U11=28; U12=32. I will test the download when the character sheet is online again. It seems everything else is ok.
Thanks, I was uncomfortable modifing it in OO and then saying its ready only too see a thread of flames talking about the import being broke again...
|
Jatar Poli
|
Posted - 2005.12.18 01:28:00 -
[16]
I have made a few fixes to the Charts. Either they got broke in OO or were broke to start with. I have corrected them to the 1210 version. I have also include a couple of sheets I designed; a Mining Yield and BluePrint Production sheet for you to review to see if you want to include in the final release. Link
|
AnnaJoy
|
Posted - 2005.12.18 21:38:00 -
[17]
Originally by: Jatar Poli I have made a few fixes to the Charts. Either they got broke in OO or were broke to start with. I have corrected them to the 1210 version. I have also include a couple of sheets I designed; a Mining Yield and BluePrint Production sheet for you to review to see if you want to include in the final release. Link
Yeah, seems that editing in OO did cause this. So i'll do fixes at work. in the mean time, i'm working to convert the sheet to open office for those who don't use Excel.
|
Quinntum
|
Posted - 2005.12.19 06:12:00 -
[18]
Edited by: Quinntum on 19/12/2005 06:14:44 Is it just me, or does the My Character Doh.. nm, its not just me. :D
Quinntum |
Ayla Vanir
|
Posted - 2005.12.19 07:17:00 -
[19]
Originally by: AnnaJoy <snip> in the mean time, i'm working to convert the sheet to open office for those who don't use Excel.
Thank you!
|
AnnaJoy
|
Posted - 2005.12.19 17:33:00 -
[20]
I have updated the sheet to 13.10 having edited the sheet at work for the new skill descriptions. It is now posted to my website. I am still working to gather all the stats of the new ships. I am also still working to update the sheet in OpenOffice. Its quite the experience if anyone has looked into porting Excel to OO.
Thanks for tuning in.
|
|
Brad Stone
|
Posted - 2005.12.19 22:38:00 -
[21]
AnnaJoy - two words: Bleepin Awesome.
Thankls for both the RMR updates and for fixing the cml download. Works a treat for me
|
DiNoer
|
Posted - 2005.12.19 23:00:00 -
[22]
Hi,
Could someone tell me what ports excel uses to comunicate with the EVE db? And preferably if there is away to manually add the xml data to the spread sheet. I am behind a really tough 3rd party firewall so I am guessing this is what the problem with my update.
G8 work team on the awsome tool!
|
magneto
|
Posted - 2005.12.19 23:47:00 -
[23]
Where is your website, AnnaJoy? Or wait can I just download the new character manager 13.10 with your clicky above?
|
AnnaJoy
|
Posted - 2005.12.19 23:50:00 -
[24]
Originally by: DiNoer Hi,
Could someone tell me what ports excel uses to comunicate with the EVE db? And preferably if there is away to manually add the xml data to the spread sheet. I am behind a really tough 3rd party firewall so I am guessing this is what the problem with my update.
G8 work team on the awsome tool!
It doesn't it tries to do a query of the website itself. An easier way to do it is to go to my character, click your character, right click the "XML Data" link and save it to your hard drive.
When you are done, open the sheet, right click in box I9 and find edit query and click that. When the screen pops up, at the top will be an address. type in that spot "file://<path>" where <path> is where you saved the sheet, like "c:\eve\data.asp.xml" and hit return. then hit CTRL+G and it will use the one on your hard drive.
AJ
|
AnnaJoy
|
Posted - 2005.12.20 00:09:00 -
[25]
Originally by: magneto Where is your website, AnnaJoy? Or wait can I just download the new character manager 13.10 with your clicky above?
The second link in the first post has the link to download the file.
|
Grifft
|
Posted - 2005.12.20 05:32:00 -
[26]
I am not having any luck with updating from the xml. I used the old sheet for the last few months but I can't seem to get this one to update. I am using Excel 2003. Is this working for someone else?
|
Rogue Meercat
|
Posted - 2005.12.20 07:24:00 -
[27]
Edited by: Rogue Meercat on 20/12/2005 07:31:43 Edit: Just tried it with 1310 and all worked just fine. Proper flag now for in training.
I have been able to successfully transfer the XML to my system from the website and all went flawlessly. However, I did find a problem. The data as to what is under training is not correct. It seems to be off by around 10 cells or so. I currently have Iron Will training to L5 and it shows me as having "Armored Warfare Specialist" training. It looks like things were added into the sheet but the training section was not updated. This is with the 1302 version of the spreadsheet but I dont see anything in the messages saying it was seen and fixed......
Rogue Meercat
|
Sharcy
|
Posted - 2005.12.20 07:54:00 -
[28]
Originally by: AnnaJoy I have updated the sheet to 13.10 having edited the sheet at work for the new skill descriptions. It is now posted to my website. I am still working to gather all the stats of the new ships.
Fantastic AnnaJoy, thanks. Please consider that many ship stats of existing ships have also changed, so you may need to go over all of them.
Mods, can we have this thread stickied again as the original was?
-- Press [Alt][F4] for my witty signature... |
Living Thanatos
|
Posted - 2005.12.20 20:11:00 -
[29]
Anna, Thanks for updating the sheet, I will start using it and let you know if something doesn't work out.
|
AnnaJoy
|
Posted - 2005.12.20 23:10:00 -
[30]
Originally by: Sharcy
Fantastic AnnaJoy, thanks. Please consider that many ship stats of existing ships have also changed, so you may need to go over all of them.
Thanks. Yes, i am working to update all ship info as many of them have changed at least drone bay size.
AJ
|
|
|
|
|
Pages: [1] 2 3 4 5 6 7 8 9 :: one page |
First page | Previous page | Next page | Last page |