| Pages: 1 2 3 4 5 6 7 8 :: [one page] |
| Author |
Thread Statistics | Show CCP posts - 1 post(s) |

Jublie
|
Posted - 2006.04.29 16:33:00 -
[1]
Edited by: Jublie on 29/04/2006 16:41:08 Edited by: Jublie on 29/04/2006 16:40:28 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.
Last Update: April 28, 2006 Microsoft Excel EMDv1405.zip OpenOffice.org EMDv1405.zip My webpage: www.troiess.com
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
Special Note: Blatantly plagiarized from AnnaJoy
Jublie JellyBean! Keeper of EVE Master Datasheet. |

Dv8Mutt
|
Posted - 2006.05.02 14:21:00 -
[2]
So much information... 
|

Aberthain
|
Posted - 2006.05.07 15:59:00 -
[3]
Got a question for ya. What's the port the macro uses to update? It doesn't want to work behind my gateway at home here...
|

Aberthain
|
Posted - 2006.05.08 15:45:00 -
[4]
I wonder why this one isn't a sticky...
|

Camel Light
|
Posted - 2006.05.08 21:03:00 -
[5]
thank you for your spread sheet.
its awesome and i just realised that im 220 days off from my goal ):
|

Qwynn
|
Posted - 2006.05.08 21:04:00 -
[6]
Originally by: Camel Light thank you for your spread sheet.
its awesome and i just realised that im 220 days off from my goal ):
stupid alt... victuri te salutant - The Legion |

Serenity2005
|
Posted - 2006.05.08 21:40:00 -
[7]
Hi, tnks for sharing chef! I'll install it tommorow on my desktop! Just goy this eary feeling i sometimes do not want to know how incredably long some things take  
regards, Seren
|

dets
|
Posted - 2006.05.08 22:57:00 -
[8]
i like, keep up the good work.
|

Jublie
|
Posted - 2006.05.10 00:03:00 -
[9]
Originally by: Aberthain Got a question for ya. What's the port the macro uses to update? It doesn't want to work behind my gateway at home here...
I'm not sure how Excel connects to the internet, it is something we'll have to look up.
Jublie JellyBean! Keeper of EVE Master Datasheet. Thread: here |

FatHed
|
Posted - 2006.05.10 01:03:00 -
[10]
Quote: Originally by: AberthainGot a question for ya. What's the port the macro uses to update? It doesn't want to work behind my gateway at home here...
I'm not sure how Excel connects to the internet, it is something we'll have to look up.
It uses port 80, it's just getting the xml from this web server, which runs on port 80. I think you have to set your excel macro security to low for excel to access the net.
If you can't get it to work over the net, go to your character page and right-click, save as on the xml data link, then use the import xml button in the sheet to load it from your local drive.
Hope that helps.
|

Tripoli
|
Posted - 2006.05.10 03:50:00 -
[11]
The EMD is missing two skills: Bloodraiders Encryption Methods & Serpentis Encryption Methods.  ---
280 of 312 skills trained. |

Eight8Eight
|
Posted - 2006.05.10 07:58:00 -
[12]
Very nice work on this I can see you spent alot of time on it for the community good work.
|

GonzoWCS
|
Posted - 2006.05.10 14:39:00 -
[13]
Love this tool
Thanks! |

Jublie
|
Posted - 2006.05.14 16:30:00 -
[14]
Originally by: FatHed
Quote: Originally by: AberthainGot a question for ya. What's the port the macro uses to update? It doesn't want to work behind my gateway at home here...
I'm not sure how Excel connects to the internet, it is something we'll have to look up.
It uses port 80, it's just getting the xml from this web server, which runs on port 80. I think you have to set your excel macro security to low for excel to access the net.
If you can't get it to work over the net, go to your character page and right-click, save as on the xml data link, then use the import xml button in the sheet to load it from your local drive.
Hope that helps.
Yay! Thanks for clearing that up.
Originally by: Tripoli The EMD is missing two skills: Bloodraiders Encryption Methods & Serpentis Encryption Methods. 
I don't suppose you have any links to those skills? I would assume they are like the other encryption methods skills.
Jublie JellyBean! Keeper of EVE Master Datasheet. Thread: here |

Snarfster Ekoki
|
Posted - 2006.05.14 20:40:00 -
[15]
Excellent, this really ought to be a sticky.. (hint?)
|

Julietta Octavian
|
Posted - 2006.05.15 17:22:00 -
[16]
Excellent spreadsheet! Thanks. I did find an error I thought to let you know about. Cells D65 and D66 on the Skill description page need to be corrected. Sequence is out of order and should be 76 and 77 instead of 77 and 76.
Keep up the good work and WHEN WILL THIS BE STICKIED!!!??
Julietta PIE Inc.
|

Troye
|
Posted - 2006.05.15 17:32:00 -
[17]
Damm I have microsoft Word but not exel for some reason.  _______________________________________________
|

Jublie
|
Posted - 2006.05.16 02:55:00 -
[18]
Originally by: Julietta Octavian Excellent spreadsheet! Thanks. I did find an error I thought to let you know about. Cells D65 and D66 on the Skill description page need to be corrected. Sequence is out of order and should be 76 and 77 instead of 77 and 76.
Fixed in version 14.06!
Updates include:
- Fixed fill-down formulas including several on Skill Descriptions sheet.
- Updated cargo size for Providence ships.
- Updated required skills for most skills.
- Updated ice types on Ice Yields and Mining Production sheets.
- Updated Bonus sheet! It is almost done

After the Bonus sheet is done I want to replace the Ice/Ore mining sheets with something much more interactive and indepth. In my spare time I'll try to add the faction/elite ships to the ships sheet.
Jublie JellyBean! Keeper of EVE Master Datasheet. Thread: here |

Choralone
|
Posted - 2006.05.16 04:31:00 -
[19]
No offense, but shouldn't a boatload of thanks go to Lachenlaud, because this is essentially an update of his work?
|

Phoenix9bird
|
Posted - 2006.05.16 04:36:00 -
[20]
There has been a few thanks to various people who have worked on this EXCEL file.. but Jublie has been quite helpful in keeping the work alive!!!!
Keep up the good work.. and keeping the file alive... and for using it too!! ***************
I wont bite.. But I'll have a drink with ya!
The face behind Phoenix9bird http://myeve.eve-online.c |

Tripoli
|
Posted - 2006.05.16 05:05:00 -
[21]
Originally by: Jublie
Originally by: Tripoli The EMD is missing two skills: Bloodraiders Encryption Methods & Serpentis Encryption Methods. 
I don't suppose you have any links to those skills? I would assume they are like the other encryption methods skills.
They are the same, yes. ---
280 of 312 skills trained. |

Standing Bear
|
Posted - 2006.05.16 13:31:00 -
[22]
Edited by: Standing Bear on 16/05/2006 13:33:10 Jubile has maintained the credit links and information to the original creator who started and others who have updated this program.
Her improvements to the original are greatly appreciated and I hope she continues her efforts here for a long time!
|

Jublie
|
Posted - 2006.05.17 22:49:00 -
[23]
Originally by: Choralone No offense, but shouldn't a boatload of thanks go to Lachenlaud, because this is essentially an update of his work?
Lachenlaud and AnnaJoy both did a wonderful job and they should not be forgotten. I'll add a Credits section in the next update to include those who have donated their time!
Jublie JellyBean! Keeper of EVE Master Datasheet. Thread: here |

Phoenix9bird
|
Posted - 2006.05.17 23:28:00 -
[24]
Jublie!!!
i was wondering.. would u be able to make some small facial changes to the skills tab and maybe highlight the one we are currently training??? i know there is a "T" to indicate.. but sometimes its just alittle hard to see lol.. and can there be a refresh button where i can see the time tick.. on that sheet to indictate time remaining.. its the closest thing i got to a training sheet lol
any progress on the possibele idea of training sheet we had???
great sheet.. great work!!!
The Face behind: Phoenix9bird Recuiting: ANZAC |

Jublie
|
Posted - 2006.05.18 01:46:00 -
[25]
Originally by: Phoenix9bird Jublie!!!
i was wondering.. would u be able to make some small facial changes to the skills tab and maybe highlight the one we are currently training??? i know there is a "T" to indicate.. but sometimes its just alittle hard to see lol.. and can there be a refresh button where i can see the time tick.. on that sheet to indictate time remaining.. its the closest thing i got to a training sheet lol
any progress on the possibele idea of training sheet we had???
great sheet.. great work!!!
I was planning on a few updates for the skills sheet to include your character bloodline, wallet balance, corp and even your implant names. I'll add some conditional formatting to make the current skill in training more visible too. As for clock to show when a skill will complete is a bit tricky, but I'll see what I can do :)
Oh, I'm still working on that split skill training. I have a few more things to add before I let you test it :)
Jublie JellyBean! Keeper of EVE Master Datasheet. Thread: here |

Phoenix9bird
|
Posted - 2006.05.18 04:17:00 -
[26]
/me rubs her hands
yummy yummy yuummm the things i await to dooo.........
/me drools
gimme gimme gimme..
/me calms down..
ok mate.. whenever ur ready.. i am too.. hit me when it is..
The Face behind: Phoenix9bird Recuiting: ANZAC |

dets
|
Posted - 2006.05.18 19:01:00 -
[27]
I like it it is a great work.
|

Kirse
|
Posted - 2006.05.19 13:54:00 -
[28]
Edited by: Kirse on 19/05/2006 14:01:31
Originally by: Jublie Masakaa and Hopka, can you both check and see if you have msxml3.dll and comdlg32.dll? I think you may be missing one of those files.
When using the Import-XML button, I had this same problem. "Compile error: Can't find project or library" in Ln 303 Col 75 of the modXML_Importer. I thought this was odd since I just reinstalled windows and office a few weeks ago and v1401 worked last April. However all is well.. Downloading and registering comdlg32.ocx from the instructions here fixed this problem.
The link you provided in your quoted text to comdlg32.ocx (named .dll in the url?) gave me the error ""C:\WINDOWS\System32\comdlg32.ocx" is not an executable file and no registration helper is registered for this file type." when RegSvr32 tried to register it. Your file downloads as 22k and the one that worked is 194k (file version 6.00.8877).
Thanks a lot for your continued support and development of this spreadsheet, and thanks to everyone who have also contributed their time and effort!!
|

Jublie
|
Posted - 2006.05.19 23:02:00 -
[29]
Originally by: Kirse Edited by: Kirse on 19/05/2006 14:01:31
Originally by: Jublie Masakaa and Hopka, can you both check and see if you have msxml3.dll and comdlg32.dll? I think you may be missing one of those files.
When using the Import-XML button, I had this same problem. "Compile error: Can't find project or library" in Ln 303 Col 75 of the modXML_Importer. I thought this was odd since I just reinstalled windows and office a few weeks ago and v1401 worked last April. However all is well.. Downloading and registering comdlg32.ocx from the instructions here fixed this problem.
The link you provided in your quoted text to comdlg32.ocx (named .dll in the url?) gave me the error ""C:\WINDOWS\System32\comdlg32.ocx" is not an executable file and no registration helper is registered for this file type." when RegSvr32 tried to register it. Your file downloads as 22k and the one that worked is 194k (file version 6.00.8877).
Thanks a lot for your continued support and development of this spreadsheet, and thanks to everyone who have also contributed their time and effort!!
After version 14.02, I think, EMD did not require comdlg32.ocx! Yet, every time I remove it from the VBA project it shows up a week later! In VBA, you can click on Tools -> References and remove any missing libraries. That should fix it the Compile Errors.
Jublie JellyBean! Keeper of EVE Master Datasheet. Thread: here |

GonzoWCS
|
Posted - 2006.05.20 16:29:00 -
[30]
Thanks for all you do!
Salute! |

Julietta Octavian
|
Posted - 2006.05.23 16:28:00 -
[31]
Bartering and Black Market trading are still on the skill list. Do they exist?
|

Jatar Poli
|
Posted - 2006.05.23 20:18:00 -
[32]
Those skills can only be acquired at character creation. Check out the character creation page for what class get them.
|

LLeBRing
|
Posted - 2006.05.24 00:21:00 -
[33]
Found this tool very useful. Great job 
Nuttin but corn bread en chicken for this fella  |

Micah Junfir
|
Posted - 2006.05.27 05:34:00 -
[34]
Ok, so I am looking at this spreadsheet in Excel, and on the Eve-XML Data tab, there's an I10 field that you apparently have to edit. I have edited it as needed, and I have entered my character # into the yellow field at the top of the page. However, if I try to click the "'I10'XML already Imported? Click here" button, I get the following error:
Run-time error '1004': Method 'range' of object '_worksheet' failed
Am I doing something wrong here?
|

Velsie Young
|
Posted - 2006.05.27 11:36:00 -
[35]
I encountered the same problem (using Excel 2003). It seems it is failing at all such PasteSpecial on Range.
Are there some steps that we miss?
thanks.
Join channel: "Eve University" or read here |

Jublie
|
Posted - 2006.05.29 16:19:00 -
[36]
Originally by: Micah Junfir Ok, so I am looking at this spreadsheet in Excel, and on the Eve-XML Data tab, there's an I10 field that you apparently have to edit. I have edited it as needed, and I have entered my character # into the yellow field at the top of the page. However, if I try to click the "'I10'XML already Imported? Click here" button, I get the following error:
Run-time error '1004': Method 'range' of object '_worksheet' failed
Am I doing something wrong here?
Fixed! It had something to do with the scope of Range() inside a worksheet module. Not sure why it didn't come up during testing or compiling. You can redownload EMDv1406.
Jublie JellyBean! Keeper of EVE Master Datasheet. Thread: here |

Eewec Ourbyni
|
Posted - 2006.05.31 13:11:00 -
[37]
OK, I've yet to find out exactly where the second xml file is dl'd from, but there are in fact two. This is why the current XP amount for a currently training skill isn't correct and needs manually adjusting. I've yet to find out exaclty what path this secondary XML sheet is located at, when I do find out I'll send the details along.
the layout of the second xml file is something like:
Quote: <?xml version="1.0" encoding="iso-8859-1" ?> - <charactersheet> - <characters> - <character timeInCache="0" timeLeftInCache="3599985" name="<My char name>" characterID="<My char ID>"> <race><My Race></race> <bloodLine><My Bloodline></bloodLine> <gender><My Gender></gender> <corporationName><My Corp></corporationName> <balance><My ISK Balance></balance> - <attributeEnhancers timeInCache="31" timeLeftInCache="86399969"> - <perceptionBonus> <augmentatorName>Low-grade Slave Alpha</augmentatorName> <augmentatorValue>2</augmentatorValue> </perceptionBonus> - <willpowerBonus> <augmentatorName>Limited Neural Boost</augmentatorName> <augmentatorValue>1</augmentatorValue> </willpowerBonus> - <charismaBonus> <augmentatorName>Limited Social Adaptation Chip - Beta</augmentatorName> <augmentatorValue>2</augmentatorValue> </charismaBonus> - <memoryBonus> <augmentatorName>Low-grade Slave Beta</augmentatorName> <augmentatorValue>2</augmentatorValue> </memoryBonus> - <intelligenceBonus> <augmentatorName>Limited Cybernetic Subprocessor</augmentatorName> <augmentatorValue>1</augmentatorValue> </intelligenceBonus> </attributeEnhancers> - <attributes> <intelligence>11</intelligence> <charisma>6</charisma> <perception>7</perception> <memory>8</memory> <willpower>7</willpower> </attributes> - <skillTraining> - <skill typeID="<Skill ID>" trainingStartTime="31/05/2006 05:39:56" trainingEndTime="31/05/2006 13:18:39"> <characterID><My Char ID></characterID> <startSP><SP of skill when I started training that skill></startSP> <destinationSP><SP for next lvl></destinationSP> <trainingToLevel><Next lvl></trainingToLevel> </skill> </skillTraining> </character> </characters> </charactersheet>
I'm trying to extract from someone exactly how you get that file... so far no luck... but I am trying. I'll update folks with any progress made.
This is a sig...
-- You think this guys post is nuts.... you should see his bio --
... good, ain't it! |

Merlin Kilor
|
Posted - 2006.05.31 15:31:00 -
[38]
Small error in ship bonus sheet:
Cell R2 is =VLOOKUP($C$3,Ships_VLookUp,6,0) and it should be =VLOOKUP($C$3,Ships_VLookUp,7,0)
This gets rid of a !VALUE error I was getting
|

Daetlus Marconia
|
Posted - 2006.05.31 18:43:00 -
[39]
Sticky?
Join channel: "Eve University" or read here |

Jublie
|
Posted - 2006.06.01 17:19:00 -
[40]
Originally by: Merlin Kilor Small error in ship bonus sheet:
Cell R2 is =VLOOKUP($C$3,Ships_VLookUp,6,0) and it should be =VLOOKUP($C$3,Ships_VLookUp,7,0)
This gets rid of a !VALUE error I was getting
It has always worked correctly for me, but I'll keep an eye on it. Is it for a particular ship? Does anyone else have this error? I know there was a problem with v14.02 that was looking up the wrong column, but I fixed it for v14.03.
Jublie JellyBean! Keeper of EVE Master Datasheet. Thread: here |

Merlin Kilor
|
Posted - 2006.06.02 15:57:00 -
[41]
Originally by: Jublie
Originally by: Merlin Kilor Small error in ship bonus sheet:
Cell R2 is =VLOOKUP($C$3,Ships_VLookUp,6,0) and it should be =VLOOKUP($C$3,Ships_VLookUp,7,0)
This gets rid of a !VALUE error I was getting
It has always worked correctly for me, but I'll keep an eye on it. Is it for a particular ship? Does anyone else have this error? I know there was a problem with v14.02 that was looking up the wrong column, but I fixed it for v14.03.
No, this happens for any ship. The "time to train" is the value the is entered into field with the original formula. It should be the base speed.
|

TadpoIe
|
Posted - 2006.06.07 01:10:00 -
[42]
wow looking at it in open office man it looks complicated 
|

Retsil Evad
|
Posted - 2006.06.11 13:09:00 -
[43]
Originally by: Merlin Kilor Edited by: Merlin Kilor on 02/06/2006 16:44:54 Edited by: Merlin Kilor on 02/06/2006 16:44:09
Originally by: Jublie
Originally by: Merlin Kilor Small error in ship bonus sheet:
Cell R2 is =VLOOKUP($C$3,Ships_VLookUp,6,0) and it should be =VLOOKUP($C$3,Ships_VLookUp,7,0)
This gets rid of a !VALUE error I was getting
It has always worked correctly for me, but I'll keep an eye on it. Is it for a particular ship? Does anyone else have this error? I know there was a problem with v14.02 that was looking up the wrong column, but I fixed it for v14.03.
No, this happens for any ship. It might be a difference between versions of Excel. I am using the Excel that is included in MS Office 2003 Pro, because there is a one-off error in all VLOOKUP cells. I will check it out when I get home.
Just to confirm I got the same thing. But there are some other things too, such as the fact I have a magical raven that has 4 launcher hard points, 5 turret hard points, and can lock a maximum of 75 targets at a distance of up to 923.9km. However I am a bit worried as I have no armour HP and 115 structure HP. This is very disappointing about the 0 armour HP becuase it wastes the 46000% EM resistance that my armour has.
Also those small and medium turret damage bonuses will come in handy for killing frigs although I may make use of the rocket and standard missile bonuses instead.
Interstingly I can control 4 heavy drones that I cannot use but can only send them to 20K out with my 4 levels of scout drone operation.
Could you please fix this problem in the ships tab. Other than this the sheet is coming along very nicely.
CIGAR Corp is Recruiting |

Jublie
|
Posted - 2006.06.12 23:17:00 -
[44]
Retsil Evad: I'll look in to it again.
Sorry I haven't posted lately, I was sick most of last week and being busy at work cuts in to my EMD spreadsheet time.
I hope to have version 14.07 out soon with lots of updates, which is why it is taking me so long. I also have a new ore/ice mining sheet that you enter how many minerals you need, what astroids are available to you to mine and then it will tell you the best astroids amounts for mining - even how long it will take you to mine all your minerals. I'm not completely happy with the mining sheet so it is still a work in progress.
Jublie JellyBean! Keeper of EVE Master Datasheet. Thread: here |

Jublie
|
Posted - 2006.06.19 15:02:00 -
[45]
Merlin Kilor or Retsil Evad: I've tried to find something wrong while I've been updating the Bonus sheet and I still do not see anything. Would one of you two mind e-mailing me your copy so I can see this error?
Thanks!
Jublie JellyBean! Keeper of EVE Master Datasheet. Thread: here |

SquiggFSM
|
Posted - 2006.06.21 12:17:00 -
[46]
I've noticed since the static data patch on Tuesday that the EMD is not picking up any implants you have installed, but then neither is EveMon so this could be a server side issue...
|

Spectre 6567
|
Posted - 2006.06.21 21:57:00 -
[47]
Great Sheet
Thank you |

Jublie
|
Posted - 2006.06.23 17:35:00 -
[48]
Originally by: SquiggFSM I've noticed since the static data patch on Tuesday that the EMD is not picking up any implants you have installed, but then neither is EveMon so this could be a server side issue...
Because the implant information is not in the XML. Let us hope they put that back in soon!
Jublie JellyBean! Keeper of EVE Master Datasheet. Thread: here |

Merlin Kilor
|
Posted - 2006.06.25 13:28:00 -
[49]
Originally by: Jublie Merlin Kilor or Retsil Evad: I've tried to find something wrong while I've been updating the Bonus sheet and I still do not see anything. Would one of you two mind e-mailing me your copy so I can see this error?
Thanks!
I sent you a screenshot via email. The error really doesn't matter anymore since you changed the Bonus sheet.
|

Shurikane
|
Posted - 2006.06.25 15:06:00 -
[50]
Something strange I noticed in the OpenOffice version.
The skill "Repair Drone Operation" seems broken on the Skills sheet. It shows a blank value for the skill points required and a time of zero. Entering a skill points value effectively breaks the sheet's calculation.
|

Jublie
|
Posted - 2006.06.25 16:19:00 -
[51]
Originally by: Shurikane Something strange I noticed in the OpenOffice version.
The skill "Repair Drone Operation" seems broken on the Skills sheet. It shows a blank value for the skill points required and a time of zero. Entering a skill points value effectively breaks the sheet's calculation.
That is another annoying issue with OpenOffice. Right click on the Rank for Repair Drone and click on 'Format Cells...' Change the Category to Number. Click on OK and in change the value from '3 to just 3. That should fix it! I'll also upload the quick fix.
Merlin Kilor: Thank you! I found out I had added an extra column on the Ships sheet (column D) for the ship hull type. If you remove that column it will fix the Bonus sheet. Lucky v14.07 doesn't have that problem.
Jublie JellyBean! Keeper of EVE Master Datasheet. Thread: here |

LLeBRing
|
Posted - 2006.06.25 17:28:00 -
[52]
Edited by: LLeBRing on 25/06/2006 17:31:53
People who have the capital remote armor repair systems skill causes the excel file to return a error and only read 'some' of the sp's.
for example, past this into mechanics and you'll see
Quote:
<skill typeName="Capital Remote Armor Repair Systems" typeID="24568"> <groupID>269</groupID> <flag>7</flag> <rank>10</rank> <skillpoints>2500</skillpoints> <level>1</level> <skilllevel1>2500</skilllevel1> <skilllevel2>14143</skilllevel2> <skilllevel3>80000</skilllevel3> <skilllevel4>452549</skilllevel4> <skilllevel5>2560000</skilllevel5> </skill>
if you delete this from the xml file, then it will load correctly
Nuttin but corn bread en chicken for this fella  |

Jublie
|
Posted - 2006.06.26 12:56:00 -
[53]
LLeBRing: Here is your quick fix if you want to do it your self. Change the skill name(cell A175) from "Capital Remote Armor Repair" to "Capital Remote Armor Repair Systems". Then click on Tools in the menu bar -> Macros -> Run Macro, select Cell_Label_Maintenance and click Ok. That will update the look up labels for you. All set!
I'll also upload the fix this evening when I get home from work, cause I can't use Tripod from work for what ever reason.  Jublie JellyBean! Keeper of EVE Master Datasheet. Thread: here |

Ming'Lai Sing
|
Posted - 2006.06.26 16:56:00 -
[54]
This Spreadsheet Rox |

Jumpster
|
Posted - 2006.06.27 00:10:00 -
[55]
Would anyone be interested in a smaller version of this wonderful spreadsheet for the Palm?
|

Victoria Solsist
|
Posted - 2006.06.28 11:46:00 -
[56]
I use it.
Thanks!! |

Shurikane
|
Posted - 2006.06.30 01:43:00 -
[57]
Another bug in the OpenOffice version:
The "can learn?" fields have their effects inverted between Fighters and Gallente Drone Specialization.
The fix is to go to cells D20 and D21 in the Skill Descriptions sheet and invert the cells they refer to in the formulas.
|

Larsel
|
Posted - 2006.07.03 19:45:00 -
[58]
I cant get this new version (1407) to import the data. I just keep getting Query failed to connect message. Is anyone else having this problem or know how to get around it? It still works ok in 1405 when I use the I10 method, but I cant get even that method to work in 1407
PS This spreadsheet is the best spreadsheet I have ever worked with
|

Phoenix9bird
|
Posted - 2006.07.04 00:33:00 -
[59]
yer jublie..
i too have tried the new 1407 version and i cant connect either.. something change? The Face of: Phoenix9bird Join Us |

Elune Ferret
|
Posted - 2006.07.04 11:04:00 -
[60]
I have the same problem, and use the same fix (Stick to 14.05). I'm trying to solve it, by copying the data from my 14.05 sheet to the 14.07 sheet, but I can't find the rigth info to copy. As to the promises of 14.07 I like the Formatting of the skills, i've fitled around with some similar things, because I focus mostly on maxing the skills. So I've added a format that greys out the skill once it's learned to level 5. I like to see something like that for 14.08. I use the "conditioned formatting -> Formula is (=$H162=0)" use pattern 2. from rigth". Sorry to sound a bit weird here, what is does is check the value in colum "H" to see if I've maxed the skill (=0 or less), if so it adds a pattern to the cell with black dots, so I can still see the skill name and other info, but it kinda fades to the background. I've also modified the cell A9 to something like [=SAMMENK¦DNING("You have learned ";COUNT.IF(C14:C334;"<>0");" skills of which you have maxed out ";COUNT.IF(C14:C334;"=5");" skills from a total of ";COUNT(C14:C334);" skills and have ";((COUNT.IF(C14:C334;"<>5")-4)-(T¦L.HVIS(C14:C334;"<>0")));" to learn and ";(COUNT.IF(C14:C334;"<>5")-4);" remaining to max out!")]
But I'm looking forward to use 14.07 as it looks a lot better then 14.05 infowise. _______________________________________________ Still waiting for ingame voice, with sound modifications for RP effort. _______________________________________________ |

Ian Luxor
|
Posted - 2006.07.04 12:36:00 -
[61]
Great !!
Thank you very much
|

BeePee
|
Posted - 2006.07.05 20:40:00 -
[62]
I got the same error as Micah Junfir. I simply fixed it by de-merging cells O3 to O7 and S3 to S7 in the "Skill" sheet.
|

Jublie
|
Posted - 2006.07.06 22:34:00 -
[63]
Originally by: BeePee I got the same error as Micah Junfir. I simply fixed it by de-merging cells O3 to O7 and S3 to S7 in the "Skill" sheet.
Oops! I was playing around with adding more information about your character to the skills sheet and forgot that I merged those cells! I unmerged those cells and uploaded it.
Shurikane: I back tracked those switched cells to v14.04. Are you using the latest version?
Larsel, Phoenix: Connection problems? Try this, put in your character # in to cell B2 then use the CTRL-G and let it fail. What that does is put your character # in the URL string. Then try the I10 edit.
Elune Ferret: More great ideas! I'll get that in to v14.08.
Just a quick note: I've added 5 new skills (in the Science group) in v14.07, so copying your old cells to the new spreadsheet could be a problem.
Jublie JellyBean! Keeper of EVE Master Datasheet. Thread: here |

Elune Ferret
|
Posted - 2006.07.07 13:19:00 -
[64]
Idea's to 14.08, i've already noted the formatting of the skill that are maxed out. But I have had a problem for a while where I'm mining and collecting a great load of minerals, like 100 billion trit, 10 billion pyirete and so forth, think the minerals required to build a brand new Oblisk (Gallente Freighter). Using the various mining sheets, provided me with little info on what ore's to mine in what amounts to achive these goals. so I've copied and modified the mining yield sheet to instead of putting in the diffrent minerals you need for each ore, you type them into the total needed. and added an extra colum to type in what amounts of ore you already have. This then fills the mineral matrix with the minimum amounts of minerals left to get from the diffrent kinds of ore. Here's and exsample: You need 10 million tritanium and 50.000 Pyerite and 1 million Isogen. Looking through this sheet I see that mining 2.799.864 units of Veldspar, 825.840 units of Scordite and 86.000 units of Omber would make me mine the least amount of ore to get the requested minerals. It's not always the best thing to just mine a single kind of ore if you're in need of a specific set of minerals. If you like I'll send my 14.05 sheet where it's in so you can have look maybe perfect it and intergrate it into the working set. _______________________________________________ Still waiting for ingame voice, with sound modifications for RP effort. _______________________________________________ |

Gawain Gringolet
|
Posted - 2006.07.07 22:18:00 -
[65]
A quick question:
How often does EVE update to the source XML file? I ask because I am 3 hours away from Frig 4 but the spreadsheet say 7.5 hours.
Great app by the way, works very well so far.
|

JoeT
|
Posted - 2006.07.08 18:22:00 -
[66]
there use to be some cool graphs on the old one, any chance we will be seeing them soon on yours?
I tried to mess with it using openoffice --- Murder Murder, yes indeed, K-I-L-L-I-N-G
|

Jublie
|
Posted - 2006.07.09 00:19:00 -
[67]
Originally by: Elune Ferret Idea's to 14.08, i've already noted the formatting of the skill that are maxed out. But I have had a problem for a while where I'm mining and collecting a great load of minerals, like 100 billion trit, 10 billion pyirete and so forth, think the minerals required to build a brand new Oblisk (Gallente Freighter). Using the various mining sheets, provided me with little info on what ore's to mine in what amounts to achive these goals. so I've copied and modified the mining yield sheet to instead of putting in the diffrent minerals you need for each ore, you type them into the total needed. and added an extra colum to type in what amounts of ore you already have. This then fills the mineral matrix with the minimum amounts of minerals left to get from the diffrent kinds of ore. Here's and exsample: You need 10 million tritanium and 50.000 Pyerite and 1 million Isogen. Looking through this sheet I see that mining 2.799.864 units of Veldspar, 825.840 units of Scordite and 86.000 units of Omber would make me mine the least amount of ore to get the requested minerals. It's not always the best thing to just mine a single kind of ore if you're in need of a specific set of minerals. If you like I'll send my 14.05 sheet where it's in so you can have look maybe perfect it and intergrate it into the working set.
Try my new Mining Calc sheet on 14.07. There is a small error in the formulas where it shows you to over mine which is why its kind of hush hush. But you can enter how many minerals you need, how many you have on hand, what ores are available to you, what ores you have on hand and it will calculate how much of what ore to mine to mine and about how long that will take. Try it out.
Originally by: Gawain Gringolet A quick question:
How often does EVE update to the source XML file? I ask because I am 3 hours away from Frig 4 but the spreadsheet say 7.5 hours.
Great app by the way, works very well so far.
EVE only updates their XML file when you complete or start/stop skills. Also it does not include implants since the last patch.
Originally by: JoeT there use to be some cool graphs on the old one, any chance we will be seeing them soon on yours?
I tried to mess with it using openoffice
I had problems converting the charts in the Excel version to OpenOffice. IĘll try to put them back in 
Jublie JellyBean! Keeper of EVE Master Datasheet. Thread: here |

TapDance Hannigan
|
Posted - 2006.07.11 13:14:00 -
[68]
Thanks Jublie |

Elune Ferret
|
Posted - 2006.07.11 14:04:00 -
[69]
Originally by: Jublie Try my new Mining Calc sheet on 14.07. There is a small error in the formulas where it shows you to over mine which is why its kind of hush hush. But you can enter how many minerals you need, how many you have on hand, what ores are available to you, what ores you have on hand and it will calculate how much of what ore to mine to mine and about how long that will take. Try it out.
I've tried out the Mining Calc, seems nice, does excatly what I was going fore. even found a bug. "X'ing Jaspet, makes it kernite or something". (Row 50 needs to be 51).
2. Futher suggestions for 14.08 skills!: someskills are unlearnable like "Biologi" and "Black market trading", consider removing them from the list/hide/do something active to have them in the sheet? Currently I do some seperate calculations where I remove them, by subtracting their values from the totals. _______________________________________________ Still waiting for ingame voice, with sound modifications for RP effort. _______________________________________________ |

Victoria Solsist
|
Posted - 2006.07.18 12:17:00 -
[70]
Keep up the great work Jublie!!
Thanks |

Efren
|
Posted - 2006.07.18 17:38:00 -
[71]
Just wanted to inform you that the spreadsheet doesn't work in Excel 2007 after you enable the content and then try to save it and load it later. I'm not sure if this is the fault of Excel 2007 or the spreadsheet. But I wanted to let people know that it doesn't work quite right.
BTW, Great Spreadsheet I've used it for quite a while now and appricated the work you have done with it!
|

GonzoWCS
|
Posted - 2006.07.24 12:51:00 -
[72]
Originally by: Efren Just wanted to inform you that the spreadsheet doesn't work in Excel 2007 after you enable the content and then try to save it and load it later. I'm not sure if this is the fault of Excel 2007 or the spreadsheet. But I wanted to let people know that it doesn't work quite right.
BTW, Great Spreadsheet I've used it for quite a while now and appricated the work you have done with it!
Thanks for the heads up Efren! |

Jublie
Gallente
|
Posted - 2006.07.25 03:22:00 -
[73]
Originally by: Efren Just wanted to inform you that the spreadsheet doesn't work in Excel 2007 after you enable the content and then try to save it and load it later. I'm not sure if this is the fault of Excel 2007 or the spreadsheet. But I wanted to let people know that it doesn't work quite right.
BTW, Great Spreadsheet I've used it for quite a while now and appricated the work you have done with it!
I tried EMD with Excel 2007 a few months ago and nothing but problems. I'll wait until it is closer to release before I worry about compatability issues. Though it looks great and easy to use, it has a long ways to go! 
Jublie JellyBean! Keeper of EVE Master Datasheet. Thread: here |

TapDance Hannigan
|
Posted - 2006.08.09 14:07:00 -
[74]
When are we goign to get an update Jublie?
<hugs> |

Jublie
Gallente Omega Fleet Enterprises
|
Posted - 2006.08.15 22:50:00 -
[75]
Originally by: TapDance Hannigan When are we goign to get an update Jublie?
<hugs>
Yes, I'm still here. I still have the unfinished 14.08 but we started a couple new projects at work which are keeping me busy!
Jublie JellyBean! Keeper of EVE Master Datasheet. Thread: here |

Rumbaar
Solitary Forsaken
|
Posted - 2006.08.16 02:10:00 -
[76]
Fantastic work Jublie I had been using since 1405 and it's been quite helpful to say the least.
Just note Drone Sharpshooting no longer requires Sharpshooter skill.
Looking for custom banners? click above, Feedback section. |

Octavian Stratus
Caldari Perkone
|
Posted - 2006.08.21 13:20:00 -
[77]
Jublie,
Looking for another "fix" of this great skill tool
Thanks Octavian |

blacknight9
Caldari Research Associates
|
Posted - 2006.08.21 15:38:00 -
[78]
EMD is a great skill manager. I've used it and it's quite usefull. Keep up the good work.
|

Armach
|
Posted - 2006.08.21 23:30:00 -
[79]
Hi Jublie,
Great work first off... I was wondering where you get your data from for all of the skills? Does CCP supply an XML file with all the info on it?
|

Jublie
Gallente Omega Fleet Enterprises
|
Posted - 2006.08.25 11:19:00 -
[80]
Originally by: Armach Hi Jublie,
Great work first off... I was wondering where you get your data from for all of the skills? Does CCP supply an XML file with all the info on it?
To a limit, check out this dev thread. There is a file that has skill names but not details. Jublie JellyBean! Keeper of EVE Master Datasheet. Thread: here |

Traderguy
|
Posted - 2006.08.26 11:54:00 -
[81]
This looks cool, but, being a bit ignorant of Excels workings, I find that the buttons when selected just show a graphic that can be adjusted in size but does not perform the intended macro function, there must be a way to make the button function as such but Im at a loss to work out how. pls enlighten me guru's.
|

SkullyP Winebo
|
Posted - 2006.08.31 17:41:00 -
[82]
Very Nice
Thanks Jublie |

30mm RRA
|
Posted - 2006.09.10 19:03:00 -
[83]
We know you are working hard Jublie! Any word on the latest update?
Thanks |

Rumbaar
Solitary Forsaken
|
Posted - 2006.09.11 04:15:00 -
[84]
Also Drone Navigation no longer requires Navigation to train. ___________________
Custom banner? Click above or EVEmail |

CozmoKramer
|
Posted - 2006.09.11 13:22:00 -
[85]
Edited by: CozmoKramer on 11/09/2006 13:23:23 Hello !
I'm trying to switch over from my old format of EMD to the new 14.07. I'm having problems with the Import button. When I select my xml sheet, I get a "Type Mismatch error" which points me to the
cBalance = Grab_Node_Value(nCharacter, "balance")
code line. Is this a know thing. I've looked through this thread and didn't find anything. Any help anybody could offer would be appreciated.
[EDIT] : I'm running Excel 2k3 SP2 off of WinXP
Thanks Jublie of keeping this awesome tool going.
Coz
|

CozmoKramer
|
Posted - 2006.09.11 13:24:00 -
[86]
Forgot to mention : I'm running Excel 2k3 SP2 off of WinXP.
|

Djerv Dvergbjerk
|
Posted - 2006.09.13 11:38:00 -
[87]
Originally by: CozmoKramer Edited by: CozmoKramer on 11/09/2006 13:23:23 Hello !
I'm trying to switch over from my old format of EMD to the new 14.07. I'm having problems with the Import button. When I select my xml sheet, I get a "Type Mismatch error" which points me to the
cBalance = Grab_Node_Value(nCharacter, "balance")
code line. Is this a know thing. I've looked through this thread and didn't find anything. Any help anybody could offer would be appreciated.
[EDIT] : I'm running Excel 2k3 SP2 off of WinXP
Thanks Jublie of keeping this awesome tool going.
Coz
I had the same error, using Norwegian number format in WinXP. Switched to English/Us and the error went away.
The problem is the decimal character, for instance 1.234,56 in Norwegian is the same as 1,234.56 in English (One thousand two hundred and thirtyfour point fiftysix)
Other than that, great product!
Djerv
|

CozmoKramer
|
Posted - 2006.09.13 13:30:00 -
[88]
Originally by: Djerv Dvergbjerk
I had the same error, using Norwegian number format in WinXP. Switched to English/Us and the error went away.
The problem is the decimal character, for instance 1.234,56 in Norwegian is the same as 1,234.56 in English (One thousand two hundred and thirtyfour point fiftysix)
Other than that, great product!
Djerv
Hey Djerv,
Thanks. It worked out by simply changing the Country/Language setting.
Although it took like 3 minutes to load the XML data. But I blame that on running 2 instances of Eve on my XP machine with 256 megs of RAM 
Cozmo
|

Mr Xofar
Minmatar
|
Posted - 2006.09.14 08:06:00 -
[89]
Jublie, would you mind if I used the skill data which I assume you so painstakingly typed in? This is the first good source of Excel data I've been able to find for my own training time calculator/planner. I've already extracted the data I need from two sheets; Skillanmes, rank, primary, secondary, and requirements. I know the data itself is owned by CCP, but I'm asking you for use of the work you've done to compile the data in a useful format. Here is my (very new) site...Mr Xofar's EVE Site
[---------------------------------------------] Incompetent |

Nixxrite
|
Posted - 2006.09.14 09:20:00 -
[90]
I've been using 1407 and noticed a minor bug. I'm not sure if anyone has the same problem, as I've not read the thread fully, but the skill in training start date always defaults to 20/06/2006. This used to work (in a fashion) so the only thing I can think of is the XML has changed?
BTW, Great sheet  
|

Ohmy Fugod
Caldari
|
Posted - 2006.10.01 07:01:00 -
[91]
Edited by: Ohmy Fugod on 01/10/2006 07:29:43
I think we're witnesses of a miracle, I just used the eve forums search tool and worked.
So glad I found the thread hehe :-)
Anyway, has there been any update I might be missing, or is v.1407 the last one?
Thanks a lot, and keep up the great work :-) -+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+
Quod Natura non da, Salamantica non praesta |

Auren I'del
|
Posted - 2006.10.26 09:16:00 -
[92]
I'm still not happy about this post loosing its glue.
Couldnt a mod just make a tread and put all these programs, and workbooks in it? Then I wouldnt have to search for it all the time.
|

Akichita
|
Posted - 2006.10.26 17:06:00 -
[93]
Unfortunately, it looks like Jubilee has been overcome by events. I would beseech her to come back to this very useful tool.
|

Jublie
Gallente Omega Fleet Enterprises
|
Posted - 2006.10.26 23:50:00 -
[94]
Hey guys! I'm still around, just very busy with work and stuff. I'll try and get you the next EMD with the fixes and patches ASAP!
Jublie JellyBean! Keeper of EVE Master Datasheet. Thread: here |

DCN BlackDragon
Gallente Red Eclipse Inc. The Cyrene Initiative
|
Posted - 2006.10.27 18:34:00 -
[95]
Did I miss the boat on this? Isn't this the same as eve mon? I know by downloading that i'd probably answer my own question, but that is not currently an option.
|

Akichita
|
Posted - 2006.10.27 19:52:00 -
[96]
Good news to hear, Jubile!!!
No this is not Evemon. EMD is an excellent Excel spreadsheet and a so-so Open Office spreadsheet. It is similar to Evemon and presents data, training, and ship information differently. If you do not have Excell then get the free version of Open office to try it out. Some of the ease of use is missing in Open Office but it will work.
|

Jublie
Gallente Omega Fleet Enterprises
|
Posted - 2006.10.28 22:47:00 -
[97]
I have ver 14.08 uploaded. Excel version.
Details:
- Fix Character Creation sheet not including "Small Hybrid Turrent" correctly
- Changed Shield Compensations requires from Tactical to Shield Operation
- Removed Navigation as a requirement for Drone Navigation
- Changed XML Import cBalance varaible from type Double to Currency. Does that fix it?
- Add Mining Upgrades and Ganged and Foreman options to Mining Yield. (Thanks Mik Nostrebor!)
- Fixed formula for Heavy Drone damage on Bonus sheet.
- Fixed formula for Armor HP total on Bonus sheet.
I should have the OpenOffice fixes done soon enough. 
Jublie JellyBean! Keeper of EVE Master Datasheet. Thread: here |

Damfoose
Kinetic Vector Freelancer Alliance
|
Posted - 2006.11.08 21:39:00 -
[98]
I have been looking for an upgraded EDM for a while now b the eve search tool was not working, im a very happy bunny now ive found this , Thanks alot for all the hard work that goes into such a tool
|

Terrin Moneymaker
|
Posted - 2006.11.10 02:05:00 -
[99]
I just found this spreadsheet, it looks awesome. Keep up the good work!
|

CozmoKramer
|
Posted - 2006.11.24 15:51:00 -
[100]
Jublie o/
I know you'll probably be asked this a few gazillion times and whatnot, and I'm sorry if I'm just one of the people who end up bothering you. If you feel a sudden urge to pod me, let me know, I'll make my pod available 
Will you be releasing an updated verion for the Kali release coming up on Tuesday ?
Keep it up Jublie !
Cozmo
|

Kraik Graeme
RONA Corporation
|
Posted - 2006.11.29 08:34:00 -
[101]
Yes Id like a revelations version very much as well. Some of the other character managers might be really cool and platform independent and whatnot, but EMD still gives me the best overview with the Skills page, plus all the other bonus stuff. Thumbs up from here for all your work Jublie
|

Jublie
Gallente Omega Fleet Enterprises
|
Posted - 2006.11.29 14:48:00 -
[102]
Hey guys!
I will do the updates as soon as I can. Looks like 15 new skills so I'll push those out before my vacation starts on Friday. And when I get back I will add the new ships and update the old ones.
Jublie JellyBean! Keeper of EVE Master Datasheet. Thread: here |

Jublie
Gallente Omega Fleet Enterprises
|
Posted - 2006.12.01 00:05:00 -
[103]
EVE Master Datasheet ver 14.09 Excel
Details:
- Added prompt in XML Impporter, questions if you want to update Implants. Implants were not longer included so they were being reset to zero.
- Added new skills, renamed others.
- Changed Tier 2 Learning skills prerequisites levels from 5 to 4.
- Changed prerequisites for ore processing.
- Added Tier 2 Battlecruiser (4) and Tier 3 Battleships (4) names and skills to the Ships sheets. (Need to fill in ship stats and update Bonus sheet)
- Updated skill descriptions
Enjoy!!!
Jublie JellyBean! Keeper of EVE Master Datasheet. Thread: here |

Mooogie
|
Posted - 2006.12.01 04:11:00 -
[104]
Thank you for updating this wonderful spreadsheet!! It's a very nice tool and viable alternative to EVEMon.
Thank you for also including and OpenOffice version, but if I might, would it be too much to ask for xml (offline, preferrably) file import functionality for the ODS version of this spreadsheet? I and many other would really appreciate that.
|

Morkus Rex
Amarr Vure
|
Posted - 2006.12.01 12:04:00 -
[105]
Nice sheet, but you still have a few bugs in it. It claims I have "Amarr Encryption Methods" and no "Amarrian Starship Engineering" you need to swap these two skills on the Skills sheet!

_ If you hope to survive in this viscious universe, you must continue to adapt and adjust to the evolution of EVE... "the strong live and the weak die"
|

Tessa Vaako
Ars Caelestis Ascendant Frontier
|
Posted - 2006.12.01 14:49:00 -
[106]
Thanks for the update!
Teething problems: EVE-XML Data Tab - Skill list in the mechanic section does not match the order in the Skills tab. This causes the Launcher Rigging and Kinetic Armor Compensation skills to incorrectly populate.
- Contracting and Corporate Contracting is missing.
Skills Tab Projectile Rigging isn't included in the Carebear or Killer graphs. (Skills tab, column AC is not set) Nanite Control isn't included in the Carebear or Killer graphs. (Skills tab, column AC is not set) -- Just how awesome are you BoB?
|

xiVexus
F.R.E.E. Explorer EVE Animal Control
|
Posted - 2006.12.01 18:00:00 -
[107]
Edited by: xiVexus on 01/12/2006 18:00:49 - Contracting and Corporation Contracting are missing from the EVE-XML Data spreadsheet, so the imports get bumped 2 fields off or so.
(oops, saw this was mentioned in the last post)
Thanks for this file by the way... amazing the work that has been done here.
|

Jublie
Gallente Omega Fleet Enterprises
|
Posted - 2006.12.02 16:32:00 -
[108]
Originally by: Mooogie Thank you for updating this wonderful spreadsheet!! It's a very nice tool and viable alternative to EVEMon.
Thank you for also including and OpenOffice version, but if I might, would it be too much to ask for xml (offline, preferrably) file import functionality for the ODS version of this spreadsheet? I and many other would really appreciate that.
Yes, it is to much work for me. I hardly ever use OpenOffice and when I do I keep that session as short as possible. If someone else has the code to import their character XML I'll be more than happy to host it!
Morkus Rex, Tessa Vaako, and xiVexus - done! Redownload v14.09 
Jublie JellyBean! Keeper of EVE Master Datasheet. Thread: here |

Tessa Vaako
Ars Caelestis Ascendant Frontier
|
Posted - 2006.12.05 15:11:00 -
[109]
Thanks for your efforts!
-- Just how awesome are you BoB?
|

GonzoWCS
The Shadow Order The Shadow Ascension
|
Posted - 2006.12.07 13:35:00 -
[110]
Thanks for the Update Jublie and All of the Hard Work!!! |

Octavian Stratus
Caldari Perkone
|
Posted - 2006.12.11 12:58:00 -
[111]
Thank you Jublie!!
|

SkullyP Winebo
|
Posted - 2006.12.14 14:17:00 -
[112]
Yeah Baby!! Updated and Current
Thanks
|

Victoria Solsist
|
Posted - 2006.12.20 19:53:00 -
[113]
As usual Great Stuff!! |
|

Kreul Intentions
Forum Moderator Interstellar Services Department

|
Posted - 2006.12.28 20:22:00 -
[114]
Use this on my main and alt. Very good tool indeed. Keep up the great work.
|
|

TapDance Hannigan
|
Posted - 2007.01.05 14:58:00 -
[115]
Thanks
Jublie |

GonzoWCS
The Shadow Order
|
Posted - 2007.01.24 15:12:00 -
[116]
How is the latest update coming Jublie??
Thanks for all you do!
|

Jublie
Gallente Omega Fleet Enterprises
|
Posted - 2007.01.24 21:07:00 -
[117]
As a matter of fact, its done!
I have v14.10 uploaded. Excel and OpenOffice
Details:
- Added Revelations skills to OpenOffice.org version.
- Updated Ships sheet: Structure, Armor, Shields.
- Updated stats for new ships.
- Fixed misc erros on bonus sheet.
- Fixed VBA code for Bonus sheet.
Every time I use OOo Calc I want to pull my hair out! It is such a difficult application to use sometimes! Jublie JellyBean! Keeper of EVE Master Datasheet. Thread: here |

pulse1976
Minmatar FarCry Inc Curse Alliance
|
Posted - 2007.01.25 12:19:00 -
[118]
Jublie - you're the best!
Keep up the great work!
|

Auren I'del
Minmatar Anarchy Empire
|
Posted - 2007.01.25 12:20:00 -
[119]
Great work as always. 
Just one question. When I dl the XML file on to my pc and try to impotr it I get a runtime error 13.
Do you know whats wrong?
|

Regalis
Tok'Ra Inc
|
Posted - 2007.01.25 13:44:00 -
[120]
Edited by: Regalis on 25/01/2007 13:42:15 Great spreadsheet! I use it all the time . I have found one thing wrong, in your skill descriptions, under requirements for Salvage, it shows you need to have Survey 5 you only need Survey 3, and it also says you need Mechanic 5, i think it's 3 for that as well. Cheers and great work!!! Reg
|

Gharrett Iknow
|
Posted - 2007.01.25 15:18:00 -
[121]
Great Job !!!! i find it excellent, even if i'm a noob of the game and use the skill descriptions to learn something about.... Because i did not owe exel but only an exel reader i think that the spread will not work for me right ????
Thank you very much and go on !!!!
P.S. sorry to all for my bad english 
|

Jublie
Gallente Omega Fleet Enterprises
|
Posted - 2007.01.25 18:42:00 -
[122]
Originally by: Auren I'del Great work as always. 
Just one question. When I dl the XML file on to my pc and try to impotr it I get a runtime error 13.
Do you know whats wrong?
Hmm. That might be due to ISK conversion. Where commas are periods and vice vera. If you have Excel 2003 (v11) click on Options-> International tab and change the seperators. I'll look in to a better fix for this error.
-Or- If you don't care to see your balance on the sheet you can comment out the line by preceding it with a "REM " or an apostraphy "'"
Originally by: Regalis Edited by: Regalis on 25/01/2007 13:42:15 Great spreadsheet! I use it all the time . I have found one thing wrong, in your skill descriptions, under requirements for Salvage, it shows you need to have Survey 5 you only need Survey 3, and it also says you need Mechanic 5, i think it's 3 for that as well. Cheers and great work!!! Reg
I totally forgot about patch 28028! I did a fix and you can download v14.10a
Gharrett Iknow: The Excel reader is just that, a reader where you can not change values. You can try OpenOffice.org and download Calc or the whole package - its are free! But be sure to use the OpenOffice version of EMD because the Excel version will show you errors.
Jublie JellyBean! Keeper of EVE Master Datasheet. Thread: here |

Horchan
|
Posted - 2007.01.26 08:16:00 -
[123]
Originally by: Jublie Edited by: Jublie on 25/01/2007 18:13:44 Every time I use OOo Calc I want to pull my hair out! It is such a difficult application to use sometimes!
Just curious, but what do you find difficult with OOo Calc?
|

Jublie
Gallente Omega Fleet Enterprises
|
Posted - 2007.02.01 14:58:00 -
[124]
Originally by: Horchan
Originally by: Jublie Edited by: Jublie on 25/01/2007 18:13:44 Every time I use OOo Calc I want to pull my hair out! It is such a difficult application to use sometimes!
Just curious, but what do you find difficult with OOo Calc?
Where to begin!
- Lack of documentation (all help sends you to the OOo forum!)
- Cells -have- to be formatted for the data-type being used.
- Errors are easy to generate (due to cell-formats)
- Cell styles are not always represented correctly
- Calculation speeds.
- Cumbersome menial tasks.
- Slow cell lookup functions.
For OOo BASIC
- BASIC lack of data-type for function calls
- BASIC local/global scope.
- No Userforms.
- Undocumented Object model.
If you don't know what is wrong, then I'm sure you will not mind using it. Anyway, I've been using Excel for 7 years and have created all sorts of interactive spreadsheet for databases, data input, and web page access. Though I do have some issues with Excel too!
Jublie JellyBean! Keeper of EVE Master Datasheet. Thread: here |

Spectre 6567
|
Posted - 2007.02.05 20:55:00 -
[125]
I use it and lub it!
Thanks Jublie! |

30mm RRA
|
Posted - 2007.02.07 19:26:00 -
[126]
Thanks for the Update |

Nar Ti
|
Posted - 2007.02.18 02:44:00 -
[127]
Thanks for this wonderful spreadsheet.
If I had a whish list would be that if I mark a skill that I want mastered and this skill is "un-available" because I'm short on some requirement, would be that the skill(s) I need to have that skill available would be tagged with the proper amount I require to train it.
IE.: in my case to get my mining barge ... I need barge III, and for that skill I'm short Astreology (III) & industry (V)
|

Jublie
Gallente Omega Fleet Enterprises
|
Posted - 2007.02.20 18:57:00 -
[128]
That is a great idea! I have always wanted to simplify the requirements on the Skill Description sheet by adding skill trees and VBA code and that is a great reason to do it. My only problem is if someone takes over development of EMD I don't want to give them to much VBA code to do.
I also want to redo the Skills sheet with interactive ActionPanes, but that requires everyone to have Excel 2003/2007. I know a lot of users still use Excel '97 and 2000/XP which does not support the new .NET features.
Jublie JellyBean! Keeper of EVE Master Datasheet. Thread: here |

30mm RRA
|
Posted - 2007.03.08 16:36:00 -
[129]
Jublie,
We luv ya... Need another fix of this great tool!!
Thanks |

GonzoWCS
The Shadow Order
|
Posted - 2007.03.15 18:51:00 -
[130]
Any word on the next update Jublie?
Thanks Again GonzoWCS Director, Industrial Engineering Group |

SkullyP Winebo
The Shadow Order
|
Posted - 2007.03.18 17:42:00 -
[131]
Yes Jublie how is the next update coming? |

Anakin Walkskyer
|
Posted - 2007.03.19 21:09:00 -
[132]
Umm..What version of excel do ya need im trying to open it in excel but its now working
|

Jublie
Gallente Omega Fleet Enterprises
|
Posted - 2007.03.21 18:02:00 -
[133]
I have been busy with work here lately and it is also end of the quarter. With all that I haven't had time to do much else.
As for the next update, it is mostly little fixes here and there; no new content. Some one did ask me if there was a Salvage spreadsheet, but I am still unfamiliar with that, so if anyone has a sheet they would like to share with the community or need help further developing, please let me know!
Jublie JellyBean! Keeper of EVE Master Datasheet. Thread: here |

GonzoWCS
The Shadow Order
|
Posted - 2007.04.03 14:21:00 -
[134]
Thanks for the Info Jublie!
GonzoWCS Director, Industrial Engineering Group |

Tybr
|
Posted - 2007.04.08 16:34:00 -
[135]
Without being over dramatic...I really really needed this precious information.
Thank you very much from the most new of the Noobish.
|

Retsil Evad
Caldari Coalition of Inter-Galactic Addicted Rodents
|
Posted - 2007.04.25 07:20:00 -
[136]
Edited by: Retsil Evad on 25/04/2007 07:19:30 Will the changes made to the way the character sheet works be incorporated into the way EMD updates?
BTW, there is a bug in the bonus sheet relating to drones. It shows the drone range 20k short of the actual range
CIGAR Corp is Recruiting |

30mm RRA
|
Posted - 2007.05.03 16:36:00 -
[137]
Jublie we miss you!! |

Victoria Solsist
|
Posted - 2007.05.08 13:22:00 -
[138]
Yes work is a suxor.... EMD is better.. Jublie we need some EMD luvin' |

waiting
|
Posted - 2007.05.29 17:58:00 -
[139]
hi Jublie,
if you acquire the yan tung technology, the xml import fails with run time error 1004 method range of object _global failed.
I'm not up to looking at your code, but did manage to delete the skill from the file, then apply the skill manually.
Cheers and keep up the good work.
|

Tessa Vaako
Ars ex Discordia GoonSwarm
|
Posted - 2007.05.29 18:12:00 -
[140]
Just a post in support of this great product!
I'm still using it every day.  --
|

Jublie
Gallente Omega Fleet Enterprises
|
Posted - 2007.06.06 03:03:00 -
[141]
So guess what? Finished some projects at work and I finally got around to doing some bug fixes!
EMD v14.11 for Excel and I'll have OpenOffice up soon.
Details:
- Fixed cell lookup reference on Skills sheet (swapped V237, V238)
- Changed Refining Requirements from 5 to 4 for Plagioclase Processing, Pyroxeres Processing, Scordite Processing, and Veldspar Processing.
- Added missing Dominix and Megathron to Large Damage Hybrid guns bonus VB code.
- Fixed Gunnery Bonus formulas on Bonus sheet.
Retsil Evad: Okey Dokey, I'll tweak the Drone Range formula
waiting: Right, Yan Jung probably has some tricky spelling in the XML... could you copy and paste just the skill name? Thanks!
Thank you all for your support!
Jublie JellyBean! Keeper of EVE Master Datasheet. Thread: here |

BlinkE MagilaCutty
Caldari Hydra Alliance
|
Posted - 2007.06.12 14:22:00 -
[142]
Thanks!!
|

Damia
Cutting Edge Incorporated RAZOR Alliance
|
Posted - 2007.06.20 20:15:00 -
[143]
Welcome to Revelations II ... time for an update ! (please?) __________________________________ :Signed: |

Ikuu
|
Posted - 2007.06.20 20:59:00 -
[144]
I'm curious, how accurate is the SP/min in the database? As I'm getting different amounts in the spreadsheet than say EveMon.
|

Ayamie
|
Posted - 2007.06.20 23:27:00 -
[145]
Yes I am already working on updating! The new API might take me an extra day, need to brush up no that again.
Ikuu: Make sure you enter you Implant attributes! Other than that, EMD doesn't show seconds.
|

Jublie
Gallente Omega Fleet Enterprises
|
Posted - 2007.06.22 23:06:00 -
[146]
EMD ver 14.12 is done! For Excel.
Sorry, I don't have this one for OpenOffice.org yet, but that is next on my list.
Details:
- Added Revelations II skills.
- Added the API way of retrieving your Character Sheet and Skill in Training.
- Fixed a few formulas on the Ship Bonus sheet.
A few notes about the API: I wrote the code in a couple hours this morning so it is mostly untested beyond using my own character. Also there are some skills that I could not find a skillID for so they will will not update, but shouldn't give you any errors.
Jublie JellyBean! Keeper of EVE Master Datasheet. Thread: here |

Gharrett Iknow
|
Posted - 2007.06.25 12:53:00 -
[147]
As always, Thank you very much for your Great Work !!!!

|

Yansong
|
Posted - 2007.06.27 11:45:00 -
[148]
Just tried 14.12 and when I try to import xml I recieve a Run-Time error '1004': Method "Range of object_Global' failed. I'm using Excel 2003. Seems to import about the top 3 or 4 lines of data into the spreadsheed skill area and then errors. ?? (
|

Damia
Cutting Edge Incorporated RAZOR Alliance
|
Posted - 2007.06.27 21:07:00 -
[149]
skill prerequisites for Capital Remote Hull Repair Systems skill do not seem to be calculating correctly. __________________________________ :Signed: |

Jublie
Omega Fleet Enterprises
|
Posted - 2007.06.29 02:09:00 -
[150]
Here is the next revision of EMD v14.13 Excel
Details:
- Updated Ships stats for Faction/Elite Ships.
- Updated EVE API code.
- Fixed Capital Hull Repair 'Can Use'
- Updated XML_Import code for more error checking.
- Updated all Skill Descriptions
Yansong: Sorry about that! Turned error checking back on and added some clear responses! It should now continue to update if it runs in to a bad skill too!
Damia: Oops! I was adding Revelations II skills when I noticed few were not in order, just forgot to sort them on the Descriptions sheet which goofed up the formulas 
Jublie JellyBean! Keeper of EVE Master Datasheet. Thread: here |

Barry Blaes
|
Posted - 2007.07.01 16:12:00 -
[151]
Edited by: Barry Blaes on 01/07/2007 16:12:02 Hi Jublie,
Something quick.
Thermodynamics is a rank 3 skill not a rank 4.
Fuzzy.
Originally by: Jublie Here is the next revision of EMD v14.13 Excel
Details:
- Updated Ships stats for Faction/Elite Ships.
- Updated EVE API code.
- Fixed Capital Hull Repair 'Can Use'
- Updated XML_Import code for more error checking.
- Updated all Skill Descriptions
Yansong: Sorry about that! Turned error checking back on and added some clear responses! It should now continue to update if it runs in to a bad skill too!
Damia: Oops! I was adding Revelations II skills when I noticed few were not in order, just forgot to sort them on the Descriptions sheet which goofed up the formulas 
|

Yansong
|
Posted - 2007.07.02 15:03:00 -
[152]
Thanks for the update! ) It imports much better now. I get a Failed Range(Starbase Defense Management") 1004 Method 'Range'of object'_Global' failed But it still loads the rest of the data. Thanks again. What great work!
|

Jublie
Omega Fleet Enterprises
|
Posted - 2007.07.02 18:25:00 -
[153]
Barry Blaes: Fixed for the current version of Excel and OpenOffice.org
Yansong: I'll add the skill in the next version so you don't get that error again :)
Jublie JellyBean! Keeper of EVE Master Datasheet. Thread: here |

Cairste Lakota
Caldari Gun Metal Priests The Makhai
|
Posted - 2007.07.03 17:38:00 -
[154]
I'd like to lobby that the following skills be promoted to "Killer" from "Carebear"
* Scout Drone Operation - Required for light combat drones. All non-combat drones (Logistics, Mining, etc.) only require the "Drones" skill * Repair Systems - 99.9% of use is in combat. Note: Remote Armor Repair Systems already listed as "Killer" * Defender Missiles - Mostly unused, but would only be used in combat * Biology - Used now for Combat Boosters * Nanite Control - Combat booster related * Neurotoxin Recovery - Combat booster related * Signal Acquisition - Note: Astrometric Pinpointing and Astrometric Triangulation are listed as "Killer"
Borderline skills * Cynosural Field Theory * Evasive Maneuvering * Fuel Conservation
-- Cairste |

30mm RRA
|
Posted - 2007.07.05 00:50:00 -
[155]
Thanks Again Jublie!! |

Octavian Stratus
Caldari Perkone
|
Posted - 2007.07.09 17:34:00 -
[156]
Nice timing with the new patch.
Thanks |

30mm RRA
|
Posted - 2007.07.11 12:14:00 -
[157]
Thanks for the update Jublie!! |

Spectre 6567
|
Posted - 2007.07.12 11:46:00 -
[158]
Nice to have this planner at our fingertips!!! |

Contralto
Gallente Federal Research Labs
|
Posted - 2007.07.16 09:21:00 -
[159]
Having trouble accessing the site or the download, I can get the Google cached version but ofc no download. Any one got another mirror for the file? ---------- Gallente and Minmater Faction standings transfer service, fast and efficient service, 2 days to 5.0 4 days to 7.0. Evemail for info, 1 year and many satisfied customers |

CozmoKramer
|
Posted - 2007.07.17 12:27:00 -
[160]
I am currently using version 14.12, so I don't know if this has been fixed.
However, Interdictors is a Rank 5 skill.
Thanks Jublie for the continued efforts !
|

GonzoWCS
The Shadow Order
|
Posted - 2007.07.18 12:15:00 -
[161]
The latest is 1413, and still has Interdictors as a Level 2 Skill. Might want to check this please Jublie.
Thanks so much for this wonderful tool and your hard work!! |

Jublie
Omega Fleet Enterprises
|
Posted - 2007.07.28 02:38:00 -
[162]
EMDv14.14 Excel and OOo and Excel New Look
Details:
- Added skill Starbase Defense Management
- Fixed Turret damage bonus formula on Bonus sheet.
- Added base 20km to Drone control range on Bonus sheet.
- Added Dominix to Drone damage/hp on Bonus sheet.
- Fixed Rank for Interdictors skill.
- Fixed a API code for Loading Character sheets from a saved XML file.
- Added Salvaging Production sheet by Gustav Qc (for Excel until I convert to OOo)
I included a preview of the new look. The reason for such big changes it to make it easier to update skills on patch day. With the new API system you will be update your EMD with skill updates and skill changes without looking here for the last skill updates(not yet, but code coming soon!) I also add Jump Clone implants selection which is a neat little feature that should have been added a long time ago! There is also a Hide/Show button to hide the extra data and show more skills.. well play with it. There are still a few bug and asthetics to be done too. Comments and suggestions will be greatly appreciated!
Jublie JellyBean! Keeper of EVE Master Datasheet. Thread: here |

Octavian Stratus
Caldari Perkone
|
Posted - 2007.07.30 12:34:00 -
[163]
Yeah Baby a new version... Luv It!!
|

Victoria Solsist
|
Posted - 2007.08.01 11:30:00 -
[164]
Thanks Jublie |

Jack Rowanburn
SkyGen Enterprises
|
Posted - 2007.08.02 06:54:00 -
[165]
You, sir, deserve a sticky and a medal. Awesome stuff. ------------- Freedom is the right of all sentient species - Optimus Prime |

SkullyP Winebo
Penumbra Squadron Hydra Alliance
|
Posted - 2007.08.06 12:02:00 -
[166]
Skully Like EMD
|

GonzoWCS
The Shadow Order
|
Posted - 2007.08.20 12:41:00 -
[167]
Column D, Row 239: Number Format Not Consistent with rest of sheet
Salute! |

J'Mkarr Soban
Amarr Shadows of the Dead Aftermath Alliance
|
Posted - 2007.08.27 09:09:00 -
[168]
Mining Foreman and Mining Director leadership skills aren't linked properly. Apparently I can train Director before Foreman according to the main sheet, but the Skills Description sheet is correct. ----------------------------- "Oh, we're sorry, you had the 'NakedAmarrChicks' bit flagged in your account somehow." "Wait, why was there even a flag for that to begin with?" "..." |

CozmoKramer
|
Posted - 2007.08.28 11:20:00 -
[169]
Am I the only one that constantly refreshes this thread on patch day, hoping to find a new version with the new skills and all ? 
Jublie, I know people are posting lots of little bugs with your spreadsheet. It only means that they are actually using it and that they want it to get better. Keep up the good work 
|

GonzoWCS
The Shadow Order
|
Posted - 2007.08.28 12:53:00 -
[170]
Was downloading the XML file today and noticed something very interesting:
The Implants were once again embedded in the file. Even got "data" in W3 - W8 on the Skills Page
Looks like maybe CCP fixed the implants bug.
Wanted you to know Jublie, and as always thanks for being YOU!!
Salute GonzoWCS, Director IEG The Shadow Order
|

Jublie
Omega Fleet Enterprises
|
Posted - 2007.08.30 11:27:00 -
[171]
Yes, thank you for all the bug reports posted here and via e-mail! And yay about the Implants data being back! I'll certainly add the code for API now.
I'll have it posted Friday after work, like I always do!
Jublie JellyBean! Keeper of EVE Master Datasheet. Thread: here |

Jublie
Omega Fleet Enterprises
|
Posted - 2007.09.01 00:06:00 -
[172]
EMDv1415 Excel and OpenOffice.org and NewLook
Details:
- Revelations 2.2
- Updated ship stats for Raven (Cap Capacity, Cap Recharge, Shield Recharge)
- Added Capital Industrial Ship Rorqual
- Added Skills Industrial Reconfiguration and Capital Industrial Ships
- Sorted Mining Director and Mining Forman
- Added Implants to API and removed msgbox in XML Import.
Please note, the OOo version does not have any API code.
Enjoy!
Jublie JellyBean! Keeper of EVE Master Datasheet. Thread: here |

Margarite Viceous
|
Posted - 2007.09.04 12:34:00 -
[173]
Thanks Jublie,
Just downladed it after the long weekend..
|

Octavian Stratus
Caldari Perkone
|
Posted - 2007.09.06 16:47:00 -
[174]
Thank you for your hard work |

SkullyP Winebo
23rd Armor Hydra Alliance
|
Posted - 2007.09.11 13:14:00 -
[175]
Ohh Yeah Baby. StickY?
|

BlinkE MagilaCutty
Caldari
|
Posted - 2007.09.13 12:04:00 -
[176]
I am using this now. I don't have to be connected and can plan skill path easily.
Thanks |

Mya Chrystal
Dead Men Walking
|
Posted - 2007.09.15 10:02:00 -
[177]
Thanks for this, it has helped out a lot. I like the different tabs you have.
Just a couple of things though... On the Minig Calc page (I think that should be Mining Calc) cell D143 which relates to jaspet, it points to E50 which is kernite. Overall, I think this is one very handy spreadsheet.
I really like the Carebear or Killer page too  I think you have done very well with this.   
|

Polaris Rome
|
Posted - 2007.09.15 10:55:00 -
[178]
How do i get my API Key????
|

Mya Chrystal
Dead Men Walking
|
Posted - 2007.09.15 12:06:00 -
[179]
Originally by: Polaris Rome How do i get my API Key????
try EVE API
|

CozmoKramer
|
Posted - 2007.09.16 14:54:00 -
[180]
Julie,
I've found a reference that doesn't seem to work. The worksheet says I can't use Transport Ships because I do not have SpaceShip Command lvl3, but I do have it to lvl5.
Something minor, but I'm sure you'll be able to quickly fix it.
Cozmo
|

Jublie
Omega Fleet Enterprises
|
Posted - 2007.09.17 11:30:00 -
[181]
Originally by: CozmoKramer
I've found a reference that doesn't seem to work. The worksheet says I can't use Transport Ships because I do not have SpaceShip Command lvl3, but I do have it to lvl5.
Hmm. The Excel version works like it should. I'll check the OOo version too. Thanks!
Originally by: Mya Chrystal
On the Minig Calc page (I think that should be Mining Calc) cell D143 which relates to jaspet, it points to E50 which is kernite.
I see it too! It has been a very long time since I've played with that worksheet. 
And THANK YOU everytone for the wonderful comments!  Jublie JellyBean! Keeper of EVE Master Datasheet. Thread: here |

Victoria Solsist
|
Posted - 2007.09.20 12:12:00 -
[182]
Thanks for the Update!!
|

BlinkE MagilaCutty
Caldari
|
Posted - 2007.09.25 13:11:00 -
[183]
Yup - Absolutely the BEST!!
|

Margarite Viceous
|
Posted - 2007.09.28 17:13:00 -
[184]
Thanks Jublie
|

Octavian Stratus
Caldari Perkone
|
Posted - 2007.10.08 12:40:00 -
[185]
Folks Use this... It is simply amazing!
Thanks Jublie
|

Damia
Cutting Edge Incorporated RAZOR Alliance
|
Posted - 2007.10.22 19:17:00 -
[186]
Edited by: Damia on 22/10/2007 19:17:59
some bugs in v14.15, in the mechanic skills section.
Capital Remote Armor Repair Systems ... I have trained to 3, but it still shows I have not learned it yet. Capital Remote Hull Repair Systems ... Can't even train this yet, but it's telling me I already have it. Capital Repair Systems ... I have trained to 4, but it still shows I have not learned it yet. Capital Ship Construction ... Could train it, but have not, but it's telling me I already have it.
hope these get fixed for the next revision. love the spreadsheet. __________________________________ :Signed: |

GonzoWCS
The Shadow Order
|
Posted - 2007.10.26 14:07:00 -
[187]
As of today getting the following error when I try to "Import XML"
"Failed to grab "charactersheet" node 424" "Object Required"
This just started happening
Thanks
|

CONCORD Curate
|
Posted - 2007.10.27 21:43:00 -
[188]
Same as reported by Gonzo "Failed to grab "charactersheet" node. 424 Object Required
|

Amarr Citizen3645735
|
Posted - 2007.10.27 21:43:00 -
[189]
Same as reported by Gonzo "Failed to grab "charactersheet" node. 424 Object Required
|

CONCORD Curate
|
Posted - 2007.10.27 21:51:00 -
[190]
Looks like CCP has made major changes in the xml file for download. (
|

Amarr Citizen3645735
|
Posted - 2007.10.27 21:51:00 -
[191]
Looks like CCP has made major changes in the xml file for download. (
|

Octavian Stratus
Caldari Perkone
|
Posted - 2007.10.29 00:08:00 -
[192]
Same as reported above.
|

Jublie
Omega Fleet Enterprises
|
Posted - 2007.10.29 14:04:00 -
[193]
Yes, they changed the character sheet to be exactly the same as the API character sheet!
If you are VBA savy, you can enter the the following lines in module "modXML_Importer" starting at line 134:
- Call API_Character_Sheet(xml)
- Exit Sub
All that does is reroute the xml to the API character parser.
I'll certainly post the next update in the next couple of days. 
Jublie JellyBean! Keeper of EVE Master Datasheet. Thread: here |

Jublie
Omega Fleet Enterprises
|
Posted - 2007.11.02 13:27:00 -
[194]
Here is the fix! EMDv14.16 Excel and NewLook
Details:
- Updated XML Import to support both old XML files and new API XML.
- Updating Mining Calc sheet. Cell D143 referencing wrong cell.
Jublie JellyBean! Keeper of EVE Master Datasheet. Thread: here |

CONCORD Curate
|
Posted - 2007.11.05 18:28:00 -
[195]
THANK YOU! )
|

Amarr Citizen3645735
|
Posted - 2007.11.05 18:28:00 -
[196]
THANK YOU! )
|

CozmoKramer
|
Posted - 2007.11.06 14:38:00 -
[197]
Thanks Jublie for the 14.16 update. API interface is much easier to use now.
Well done.
|

CozmoKramer
|
Posted - 2007.11.07 14:53:00 -
[198]
Although, I have thoughts (oh noes )
I'd like to petition some changes in the Skillset Summary tab. I use that tab quite a bit, espescially to compare characters. But, everytime I load a new copy of the EMD, I have to redo the same changes it gets annoying and I don't get why it's setup the way it is at the moment.
Could you please : - Remove all decimal points for the "Quantity of Skill levels" (I can't have Science lvl 2.87 anyways). - Remove all decimal points in the Total SP column (column I). - Add the "Use 1000 seperator (,)" check box for the Total SP column and line 21.
I know these are only aesthetic changes, but they are the kind of things that drive you nuts after a while.
Thanks Jublie
|

Octavian Stratus
Caldari Perkone
|
Posted - 2007.11.19 20:27:00 -
[199]
Thanks Again Jublie!!
|

Victoria Solsist
|
Posted - 2007.11.21 13:12:00 -
[200]
Originally by: CozmoKramer Thanks Jublie for the 14.16 update. API interface is much easier to use now.
Well done.
Here Here!! You do wonderful work
|

xiVexus
|
Posted - 2007.11.25 18:57:00 -
[201]
Originally by: Damia some bugs in v14.15, in the mechanic skills section.
Capital Remote Armor Repair Systems ... I have trained to 3, but it still shows I have not learned it yet. Capital Remote Hull Repair Systems ... Can't even train this yet, but it's telling me I already have it. Capital Repair Systems ... I have trained to 4, but it still shows I have not learned it yet. Capital Ship Construction ... Could train it, but have not, but it's telling me I already have it.
hope these get fixed for the next revision. love the spreadsheet.
Looks like these are still bugs. I'm getting them also.
|

CozmoKramer
|
Posted - 2007.12.06 14:06:00 -
[202]
/me hopes Julie called in sick @ work today to spit out a new updated version
Good luck J.
Coz
|

Jublie
Omega Fleet Enterprises
|
Posted - 2007.12.07 14:53:00 -
[203]
I'm working on the update, at work, today. I hope to finish it soon. :) Jublie JellyBean! Keeper of EVE Master Datasheet. Thread: here |

Ib Amilo
Caldari Serenity Inc
|
Posted - 2007.12.10 09:19:00 -
[204]
Minor bug
In the "Skill Descriptions" sheet, the mining director and foreman prereqs seem to be borked. I.e. Regardless of your leadership skill, the "Leadership 1" cell remains red for Mining Foreman. On Mining Director, the "Mining Foreman 5" cell is green even with 0 skill in Mining Foreman, and the "Leadership 5" cell is green for Leadership 1 and above.
Member of ICSC, builder of Capital Ships. Fluffy dice included! |

Quinlan Rowe
Minmatar Republic University
|
Posted - 2007.12.10 16:43:00 -
[205]
Thanks for this I am a noob to eve and this is helping me out greatly. I definately needed the help to focus me on my development. :)
|

Myrkon
|
Posted - 2007.12.12 02:17:00 -
[206]
Any word on when the new sheet will be available ? The patch has been out for a week now 
|

Jublie
Omega Fleet Enterprises
|
Posted - 2007.12.12 14:47:00 -
[207]
Here is your update!
EMDv14.17 Excel and NewLook
Trinity Release:
- Added 8 new skills!
- Added 20 new ships!
I'll have OpenOffice.org update some time this week.
Oh, I also added a new feature - you can now add skills on your own on patch day so you don't have to wait for me (one reason why this is so late). From Excel click on Tools -> Macro -> Macros... and run "Add-a-Skill". When the dialog pops up you can manually enter a skill or click on "From EVE-Online" and it go out to the web and pick up the new skills! (I'm sure there will be bugs and formatting errors, so it will need some touch up.)
Jublie JellyBean! Keeper of EVE Master Datasheet. Thread: here |

Margarite Viceous
|
Posted - 2007.12.17 13:24:00 -
[208]
Thanks Jublie
|

Vinerya
The Wings of Maak Ushra'Khan
|
Posted - 2007.12.19 16:12:00 -
[209]
One error in EMDv1417.xls i think  In Bonus sheet : The ship bonus (E25) is negative, but i actually add more sig. example : Base sig 31 for a Stiletto, -5% sig bonus giving 32.55 
The formulae is =C25*(1-D25)*(1-E25)*(1-F25)*(1-G25) Change for =C25*(1+D25)*(1+E25)*(1+F25)*(1+G25)  -----
|

CozmoKramer
Capital Shipyard
|
Posted - 2008.01.02 21:46:00 -
[210]
Here's another little correction for the next release :
Black Ops (skill) requires Jump Drive Calibration lvl 4 (not 5)
o/
|

GonzoWCS
The Shadow Order
|
Posted - 2008.01.14 14:45:00 -
[211]
Awesome Work Jublie!!
|

Spectre 6567
Minmatar Republic Military School
|
Posted - 2008.01.17 13:22:00 -
[212]
Thanks Jublie
|

Octavian Stratus
Caldari Perkone
|
Posted - 2008.02.05 12:24:00 -
[213]
What new and exciting updates do you have in the works Jublie?
|

CozmoKramer
Capital Shipyard
|
Posted - 2008.02.19 14:54:00 -
[214]
Any word Jublie on an updated version ?
i.e. containing fixes and completed ships page ?
Thanks !
Cozmo
|

Victoria Solsist
|
Posted - 2008.03.03 12:58:00 -
[215]
Originally by: CozmoKramer Any word Jublie on an updated version ?
i.e. containing fixes and completed ships page ?
Thanks !
Cozmo
Yes Jublie, when is the next version coming out?
Victoria
|

Retsil Evad
Caldari The Arrow Project Morsus Mihi
|
Posted - 2008.03.05 08:28:00 -
[216]
Originally by: Jublie
Oh, I also added a new feature - you can now add skills on your own on patch day so you don't have to wait for me (one reason why this is so late). From Excel click on Tools -> Macro -> Macros... and run "Add-a-Skill". When the dialog pops up you can manually enter a skill or click on "From EVE-Online" and it go out to the web and pick up the new skills!
Is there a plan to do the same thing for new ships?
============== Office use ONLY ==============
BRING BACK EVE TV!!!!!!! |

GonzoWCS
|
Posted - 2008.03.13 11:35:00 -
[217]
Jublie, With the latest patch on the streets, can we expect an update from you soon?
Salute!
|

Retsil Evad
The Arrow Project Morsus Mihi
|
Posted - 2008.03.16 11:47:00 -
[218]
Unfortunately I have a bad feeling that Jublie is no longer maintaining EMD. There has been nothing from her since mid December.
============== Office use ONLY ==============
BRING BACK EVE TV!!!!!!! |

Gabriel Aaron
Omega Fleet Enterprises Executive Outcomes
|
Posted - 2008.03.16 12:13:00 -
[219]
I have seen her in corp chat not too long ago I think. I will ask her about it if I see her.
Omega Fleet Enterprises is Recruiting! |

SkullyP Winebo
The Shadow Order SMASH Alliance
|
Posted - 2008.03.19 12:05:00 -
[220]
Originally by: Gabriel Aaron I have seen her in corp chat not too long ago I think. I will ask her about it if I see her.
Thanks Gabriel!
|

Retsil Evad
The Arrow Project Morsus Mihi
|
Posted - 2008.03.21 08:23:00 -
[221]
Originally by: Gabriel Aaron I have seen her in corp chat not too long ago I think. I will ask her about it if I see her.
Any word on the status of the datasheet, Gabriel?
============== Office use ONLY ==============
BRING BACK EVE TV!!!!!!! |

CozmoKramer
Capital Shipyard
|
Posted - 2008.03.25 17:42:00 -
[222]
Thanks Jublie for your hard work.
It was appreciated - take care o/
|

TapDance Hannigan
Sebiestor tribe
|
Posted - 2008.04.01 12:06:00 -
[223]
Any News Jublie?
Thanks
|

Demiurgis
Amarr g guild
|
Posted - 2008.04.09 22:20:00 -
[224]
this is pretty impressive, definately my new EVE tool...EveMon isnt really what I am looking for.
I am working on programming my own personal EVE tool in python for a class that is essentially this in a system tray app. Evemon's extra features messing with my client made me not really want to use it. Thanks for this!
|

TapDance Hannigan
Minmatar Sebiestor tribe
|
Posted - 2008.04.21 13:52:00 -
[225]
Jublie, We miss you baby!!
|

TapDance Hannigan
Minmatar Sebiestor tribe
|
Posted - 2008.04.28 13:14:00 -
[226]
I am assuming that Jublie is no longer actively working this??
Thanks |

BillyBong2
Amarr COLD-Wing The Fourth District
|
Posted - 2008.05.19 17:18:00 -
[227]
Any information?
http://coldwing.100luz.com.ar/board/ |

Slot Ghar's
|
Posted - 2008.06.03 11:20:00 -
[228]
I've tried to adjourn the last version of EMD with the option "Tools/Macro/Macro's....." as i read on Jublie's website but then i get error message....  There is someone that understand how to fix this ? Thank you all very much, and thank you Jublie for the work you have done......
|

TapDance Hannigan
Sebiestor tribe
|
Posted - 2008.06.20 12:09:00 -
[229]
Jublie... We miss you!!!!
|

Jublie
Aliastra
|
Posted - 2008.06.27 16:16:00 -
[230]
Hey guys! I certainly didn't mean to skip out on all of you like this. I moved back in December to a very nice place and since then of failed to play EVE or maintain EMD.
With EVE I got really bored with the missions and ratting, oh the monotony of it! And of course the corp politics got annoying so I just left EVE all together.
As for EMD, it is one of the best projects I have ever worked on and I have learned a great deal about EVE, Excel and XML in that time. I can continue to do small items like skill updates, bug fixes, and little patches, but I really donĘt have the time or desire to add new features or overhauls like I use to. I also do not want to update OpenOffice.org version anymore, what a nightmare that was.
So, if there is anything I can do for you and EMD it would be best to e-mail me directly at amberlillies-at-yahoo-dot-com. And if anyone wants to ask a questions about how to add a new feature or already created something marvelous for EMD you are welcome to get in touch with me.
Take care all of you! 
Jublie
Jublie JellyBean! Keeper of EVE Master Datasheet. Thread: here |
| |
|
| Pages: 1 2 3 4 5 6 7 8 :: [one page] |