|
Author |
Thread Statistics | Show CCP posts - 0 post(s) |
Lachenlaud
|
Posted - 2004.05.05 01:52:00 -
[1]
Edited by: Lachenlaud on 28/05/2005 23:27:11 Greetings from Golden Oak Industries!
I'm developing an Eve Skills Chart in Excel. It 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.
BUGFIX/MAJOR UPDATE 5/28/05 v11.52 If you would like to try it out, go here http://www.goi-eve.com/emd/EMDv1152.zip.
May 28, 2005 - Ok I've added the missing skills and made a few other tweaks to the sheet. Sorry for the misfire on shipping v11.xx without them. Should all work fine now
May 26, 2005 - Firstly - Many apologies to all who have been waiting so long for this update. This release has some major patches to it. Ships tab has been updated once again. A new 'Production' tab is also included. The skills should all be available now as well. MOST IMPORTANTLY!! The AUTOUPDATE FEATURE IS WORKING!! PLEASE TEST IT! I have once again included the AutoUpdate.doc file to the Zip to give you an idea as to how to set this up. (Note: Minor bug fix to change Chief Tactical Officer to Starbase Tactical Office v11.01)
Extra Special Thanks go to Histracko for all his hard work in helping with the sheet - were it not for his extra-efforts to keep me motivated and all the time he's spent on updating things to help me out it wouldn't be here today.
(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 EMDv1100 would be Eve Master Datasheet version 11.00. Major updates change the primary first digit, while minor updates change the sub number .xx)
THANK YOU FOR THE STICKY!!!
SPECIAL NOTE TO THE FORUM OPS: This post has become long and unwieldy. Would it be possible for you to delete everything between this post and MY last post in this thread? Pretty Please??
Regards,
[email protected] http://www.goi-eve.com/forums/ Check out the Eve Master Datasheet here!! |
Lachenlaud
|
Posted - 2004.05.05 15:33:00 -
[2]
Originally by: Feek Looks very interesting, I'll have a play at work later today. I currently use a combination of my own (not very complicated spreadsheet) and Eveskillmon.
Very cool. I plan on making improvements to this skill sheet as I go forward. So any feedback you have will be of help.
[email protected] http://www.goi-eve.com/forums/ Check out the Eve Master Datasheet here!! |
Lachenlaud
|
Posted - 2004.05.05 15:44:00 -
[3]
Originally by: Kees You appear to have missed out 'research' skill in science.
Yep, saw that - already added it to my revisions list.
Originally by: Kees Also, the attributes calculated in the spreadsheet don't appear to match my actual ones in game. For example: I started the game as a sebiestor tinkerer which gives me a starting attribute of 11 int, I have an int implant of +3 and analytical mind trained to lvl 5. I ngame i have a total int of 22, in the spreadsheet i have an int of 19.
Hmmmm... am I misunderstanding how this works?
11 Base INT +5 from skill +3 from implant -- 19 Total INT
Is there something else that affects your INT that I'm not accounting for? Boosters, drugs, etc? Anyone know the answer to this one?
Or is it possible you have a graphical bug that is affecting your in-game display.
Anyone can enlighten me about this, please feel free.
Originally by: Kees I would like to help with the above, but do not know the correct formulae, also you have used lookup tables which baffle me :)
The formula works on my character (so far) but I don't have any implants (yet). It was my understanding that the implants gave a number of points based on the level of implant. Can you double check to see how the bonus is worded on your particular implant?
Originally by: Kees Anyway, what you have produced is very nice. Keep up the good work.
I shall! Keep up the feedback! Thanks much!
Originally by: Kees Just noticed you have Guerilla tactics as a rank 3 skill, is it not rank 2?
Hmmm - I'll check on it in game. Pretty sure it said 3, but I'll add this to 'The List'.
Thanks again!
[email protected] http://www.goi-eve.com/forums/ Check out the Eve Master Datasheet here!! |
Lachenlaud
|
Posted - 2004.05.05 18:26:00 -
[4]
Originally by: CrayC Another thing to add to the list, is your "days to current skill goal". It adds more days when I set my goal to a lower level and even with no goals set, it shows 200+ days to goal
Can you email me an example of this? Please place the file in a ZIP before sending or my email will filter it out. Highlight the area you're talking about and give me examples in the file. My email addy is in the sheet.
[email protected] http://www.goi-eve.com/forums/ Check out the Eve Master Datasheet here!! |
Lachenlaud
|
Posted - 2004.05.05 18:29:00 -
[5]
Edited by: Lachenlaud on 05/05/2004 18:52:44 Edited by: Lachenlaud on 05/05/2004 18:51:14
Originally by: Namarus Remember that the learning skill increases your attributes by 0.02% per level.
So learning 5 will increase your attributes by 10%.
I misunderstood the above... it's actually boosting the skill level 2% per level. All fixed.
[email protected] http://www.goi-eve.com/forums/ Check out the Eve Master Datasheet here!! |
Lachenlaud
|
Posted - 2004.05.05 18:40:00 -
[6]
Originally by: Selak Zorander To fix it all you ave to do is expand Column F a little bit. You currently have a formula like this: IF(D12=0,0-E12,IF(D12=1,SUM((250*B12)-E12),IF(D12=2,SUM((1414*B12)-E12),IF(D12=3,SUM((8000*B12)-E12),IF(D12=4,SUM((45255*B12)-E12),IF(D12=5,SUM((256000*B12)-E12),"ERR!")))))) To fix it you just have to add a check to see if that is greater than or less than zero like this: IF(IF(D12=0,0-E12,IF(D12=1,SUM((250*B12)-E12),IF(D12=2,SUM((1414*B12)-...
That will remove the negative training time to reach goals.
I'll have to look at that.
Thanks!
[email protected] http://www.goi-eve.com/forums/ Check out the Eve Master Datasheet here!! |
Lachenlaud
|
Posted - 2004.05.05 18:49:00 -
[7]
Originally by: Ithildin (Intelligence + Analytical Mind + Implant) * Learning = Actual Intelligence Raw Intelligence = 19, so the actual intelligence would thus be (with Learning 5) 19*1.1 = 20.9 In game this is floored, and is thus shown as 20. Since Kees say he's got 22 ingame his basic intelligence ought to be 12, not 11.
Ahh! I think I understand now. Instead of calculating the 'learning' skill into the individual Per Minute Rates.... I should look at it as an 'Attribute' bonus and apply it thus. Means I have to change a few formulas, but it makes sense.
The eve documentation is a bit deceiving. on this (see previous post).
[email protected] http://www.goi-eve.com/forums/ Check out the Eve Master Datasheet here!! |
Lachenlaud
|
Posted - 2004.05.05 22:58:00 -
[8]
Originally by: Mesa Nice sheet - much prettier than my effort :-)
The formula for skill points (this will simplify a lot of the cells): 2^((2.5*lvl)-2.5)*250*rank
Also I'd change it to calc current skill points from current level rather than the other way round - it's much quicker to put in levels (although arguably not as accurate if you change skills before reaching the next level).
Lastly it's nice if you put in a priority column - that way you can plan ahead and focus on the skills you want to train 1st (and if you split across two sheets you can use autofilter to show only the high priority skills).
Well well - someone thinks along the same lines I do. ;-> Though I'll be continuing to calc on skill points rather than level because the whole purpose of the last few columns is to give me an idea how long i have to go.
Can you simplify this for me - not sure I understand what I'm looking at:
2^((2.5*lvl)-2.5)*250*rank
put it as if you were putting in on a chalkboard for a math class.
Just posted an update by the way - the URL has changed since I changed the file name! I made it shorter. Also - for those of you who don't realize it - the first character is a ZERO not an OH.
[email protected] http://www.goi-eve.com/forums/ Check out the Eve Master Datasheet here!! |
Lachenlaud
|
Posted - 2004.05.05 23:10:00 -
[9]
Originally by: Crato Edited by: Crato on 05/05/2004 23:09:47 found a error.
Motion Prediction is Rank 2 not rank 3 and Guerrilla Tactics is Rank 2 not rank 3
Working on it
[email protected] http://www.goi-eve.com/forums/ Check out the Eve Master Datasheet here!! |
Lachenlaud
|
Posted - 2004.05.06 03:14:00 -
[10]
Originally by: Kees Hehe looks like we are keeping you busy Lachenlaud. But a mighty fine effort you are making :)
Anyway, I'll be totaly honest with those who posted in reply to my comment about my INT> I cant actually remember what my starting INT was, but it is 22 now and I have a +3 implant, learning 5 and analytical mind 5. I did read another post that said sebiestor tinkeres started with 11. I must be confused somewher along the way ( although with 22 int i should never be confused :) )
Well I'm guessing it should have been 12. Cuz that's how the math works out. That's fixed on the sheet btw.
[email protected] http://www.goi-eve.com/forums/ Check out the Eve Master Datasheet here!! |
|
Lachenlaud
|
Posted - 2004.05.06 03:18:00 -
[11]
Edited by: Lachenlaud on 06/05/2004 04:00:56
Originally by: Crato 1 more thing i have lvl 4 on this skill:
Research Project Management / Rank 8 / SP: 362039 of 2048000
but you need 1 more point on your excel to make lvl4
Lets see... mathimatically it works out that 45255*8=362040, whereas 45255 is the number of skill points you need to get level 4 on a rank=1 skill.... multiply that by 8... well, you get the idea.
Looks like another eve bug to me. Unless the devs do math differently (if one of them would care to comment?).
You're saying you're at skill level 4 with 1 point less than that. I'll fudge it for now, but that's just plain weird. The update is already posted
Anyone else have any ideas about this?
[email protected] http://www.goi-eve.com/forums/ Check out the Eve Master Datasheet here!! |
Lachenlaud
|
Posted - 2004.05.06 13:32:00 -
[12]
Edited by: Lachenlaud on 06/05/2004 13:54:45
Originally by: Mesa It's caused by a rounding error - the formula I posted earlier doesn't suffer from this. There's nothing really to explain about the formula - try it and you'll see it's works. If you really don't want to use the formula then use 45254.834 not 45255 and round off after multiplying by rank. The rounding error will also happen on lvl 2 skill point calcs as it's really 1414.213562. It's only rounded at the end after multiplying by rank. The other levels (1,3 and 5) work out to a round number before multiplying by rank so you won't get rounding errors on them.
The formula for skill points (this will simplify a lot of the cells): 2^((2.5*lvl)-2.5)*250*rank
Originally by: Lachenlaud I'd LIKE to use this - IF I understood what the heck I'm looking at. What is the ^ symbol supposed to represent? I understand the rest of it.
Never mind - I got it now... What you're saying is that it's two to the power of... etc etc
The lights all came on at once.
Regards,
[email protected] http://www.goi-eve.com/forums/ Check out the Eve Master Datasheet here!! |
Lachenlaud
|
Posted - 2004.05.06 23:39:00 -
[13]
Originally by: Kees Hi again Lachenlaud :)
Anyway, a few further points for you. Consider it a bug report
One of the social skills on the skill description page has a typo. It should say bonus.
The tempest on the ships page says 450 shield, it should be 4450 i think.
Finally, I get an error with my metallurgy skill. I currently am at lvl 4 with 248,193 points, when i enter goal of lvl 5 the 'time to goal' comes up as ERR.
Hope this helps rather than gives you more work
THANK YOU so much for the input!
Should be all fixed! Give it a bash!
Regards,
[email protected] http://www.goi-eve.com/forums/ Check out the Eve Master Datasheet here!! |
Lachenlaud
|
Posted - 2004.05.07 16:40:00 -
[14]
Originally by: Hellspawn01 Edited by: Hellspawn01 on 07/05/2004 15:27:39 Can u make the fields which shows the hrs/time to in a diffrent way like XX:XX instead of XX,XX?
Not quite sure what you're asking me to do here.
Current format of the time fields is as follows:
If the number of hours remaining is less than 24, it displays as hours - ex. - HH.FF h (whereas HH=whole hours and FF=decimal fraction of an hour, and h=hours visual designator)
If the number of hours is 24 or over it displays as days - ex. - DD.FF (whereas DD=whole days, and FF=decimal fraction of a day, and d=days visual designator)
Are you asking me to change the time display to be actual HH:MM in Hours and Minutes respectively?
That is eventually the plan, but I have yet to implement it. Please keep an eye out for it in a future release if that's the case, if not, contact me with further explaination of your concept.
Regards,
[email protected] http://www.goi-eve.com/forums/ Check out the Eve Master Datasheet here!! |
Lachenlaud
|
Posted - 2004.05.12 05:21:00 -
[15]
Originally by: Choralone Awesome tool.
You are missing the skill "Trade" at the moment, though. It is identical to Leadership as far as time to train, primary & secondary skills, etc. I just pasted a copy of the "Leadership" row below "Interceptors" and renamed it "Trade" on the copy I downloaded.
Could you do me a favor on this and email me screen prints of the attr/req.skills tabs on this?
Thanks!
[email protected] http://www.goi-eve.com/forums/ Check out the Eve Master Datasheet here!! |
Lachenlaud
|
Posted - 2004.05.12 05:22:00 -
[16]
Originally by: Zansin hmmmm im intruieged i would perhaps like a guide on how exactly to work this magical moving picture if i do say so myself im a bit of a dumbass
I added instructions to the latest version of the sheet. Should be easier to understand now.
Regards,
[email protected] http://www.goi-eve.com/forums/ Check out the Eve Master Datasheet here!! |
Lachenlaud
|
Posted - 2004.05.12 05:23:00 -
[17]
Originally by: Fjellu Excellent spreadsheet. Please keep the updates coming
Funny you should mention this.... I just updated it (5/11/04 MDT). Check it out!
Regards,
[email protected] http://www.goi-eve.com/forums/ Check out the Eve Master Datasheet here!! |
Lachenlaud
|
Posted - 2004.05.12 05:26:00 -
[18]
Originally by: Darwen
Originally by: Lachenlaud
Originally by: Hellspawn01
Can u make the fields which shows the hrs/time to in a diffrent way like XX:XX instead of XX,XX?
Not quite sure what you're asking me to do here. <SNIP> Are you asking me to change the time display to be actual HH:MM in Hours and Minutes respectively?
I think it's safe to assume this. Some people may also not realize that it is fraction of an hour/day. Just a little bit more math will make it a lot more user friendly.
Ok, its done! Now it shows Days/Hours/Minutes for each one (Next/Goal/Max)!
Enjoy!
[email protected] http://www.goi-eve.com/forums/ Check out the Eve Master Datasheet here!! |
Lachenlaud
|
Posted - 2004.05.12 12:35:00 -
[19]
Originally by: Efeu Hi There, you are missing the Skills Biology and Mnemonics in your calculation :) Somehow my Char ended up with both of them from creation.
Please e-mail me screenprints from the game showing the info tabs for the attributes and required skills for each. The email addy can be found in the bottom of the spreadsheet.
Thanks!
[email protected] http://www.goi-eve.com/forums/ Check out the Eve Master Datasheet here!! |
Lachenlaud
|
Posted - 2004.05.12 14:00:00 -
[20]
Originally by: Kees No criticism or bug reporting, just keep up the good work.
Any suggestions on what I should add next?
[email protected] http://www.goi-eve.com/forums/ Check out the Eve Master Datasheet here!! |
|
Lachenlaud
|
Posted - 2004.05.12 16:53:00 -
[21]
Originally by: Kees Well......
Now that you mention it :)
I don't know if it is appropriate for the spreadsheet, but I have a spreadsheet myself that uses bits of other ppl's spreadsheets. I use it to determine selling costs of items I make. However, it is very customised to my personal skills and the bp's I own.
What I would like is either a ss or db that contains ALL (if possible) BP data for unresearched blueprints. From this, with a little tinkering, any user could input their relevant skills and also input intended research plans such as PE or ME. This in turn would give the user a projected cost in terms of minerals, isk and time required for BP copying, manufacturing and all things related.
Great idea! I'll look into it!
[email protected] http://www.goi-eve.com/forums/ Check out the Eve Master Datasheet here!! |
Lachenlaud
|
Posted - 2004.05.12 16:55:00 -
[22]
Originally by: Deadeye Blind Thanks for all the hard work. I do have a question though...What does HRL mean on the skills page?
Thanks again for making this available.
HRL = Highest Level Required. Basically - if you get a skill with an HRL# to That level, then you can learn all skills that are associated with it. If you get ALL the HRL skills to their respective numbers, you should (in theory) be able to learn any other skill in the game.
Regards,
[email protected] http://www.goi-eve.com/forums/ Check out the Eve Master Datasheet here!! |
Lachenlaud
|
Posted - 2004.05.16 14:43:00 -
[23]
Edited by: Lachenlaud on 16/05/2004 17:22:47
Originally by: Linus Freyr Pehaps make the ships and implants sheets lists so that you can sort easily by various things i.e looking for a mem implant in Minmatar space you can sort by min and find it easier. I think you need excel 2003 for this though, but just something I did to my implant sheet but can't do to my ship sheet as you protected it But very nice work and thanks for the effort thats gone into it
I've put in the sort function (it's simple enough). It's included in v2.02!
As to the protected status - All you have to do to 'unprotect' the sheet is go to tools, protection, unprotect sheet. I just did that so I wouldn't accidentally type over it.
Thanks so much for the feedback!
[email protected] http://www.goi-eve.com/forums/ Check out the Eve Master Datasheet here!! |
Lachenlaud
|
Posted - 2004.05.16 14:45:00 -
[24]
Originally by: Skarj Very nice sheet, good use of the ol' functions + formulas there ;) Worthy of a sticky my son!
Thanks for the feedback!
[email protected] http://www.goi-eve.com/forums/ Check out the Eve Master Datasheet here!! |
Lachenlaud
|
Posted - 2004.05.21 18:36:00 -
[25]
Originally by: SummerRider This spreedsheet is a great tool. I started using version 200. Will have to see what you've done in 300.
Thanks for the feedback! I'll be releasing 4.00 soonÖ. Going to be adding a Missions Logsheet and an Alliance tracker, as well as a few other corp management tools (Shares Tracking/Mining Op Tracking/Etc).
If anyone else can think of a few things they'd like to see, I'd be happy to see about adding them in.
[email protected] http://www.goi-eve.com/forums/ Check out the Eve Master Datasheet here!! |
Lachenlaud
|
Posted - 2004.05.29 15:36:00 -
[26]
Originally by: Oskiy
Originally by: Lachenlaud I'll be releasing 4.00 soonÖ. Going to be adding a Missions Logsheet and an Alliance tracker, as well as a few other corp management tools (Shares Tracking/Mining Op Tracking/Etc).
How's this coming? (Mainly wanted to bump this back to the front)
It's coming along - I'll be uploading it this weekend on or by the 31st of May!
[email protected] http://www.goi-eve.com/forums/ Check out the Eve Master Datasheet here!! |
Lachenlaud
|
Posted - 2004.05.29 15:38:00 -
[27]
Originally by: ChernoChiel i love ur skill chart!!
though the total time to goal doesnt add up quite right...
and in ur previous version, u disbalbed editting of fields, which was quite handy tbh. could u do that again in the next version? (or make it PW protected) cuz im afraid im gonna mess up the chart :S
thanx for your work on this very handy excel sheet :D
Thanks!
The total time doesn't add up quite right because of rounding on the 'Minutes'. I didn't want to be so anal as to add a 'seconds' column. Just seemed like overkill to me.
I'll lock out the formula fields again in v4 and leave instructions on how to unlock it for those that want to in the sheet.
[email protected] http://www.goi-eve.com/forums/ Check out the Eve Master Datasheet here!! |
Lachenlaud
|
Posted - 2004.06.01 01:34:00 -
[28]
Originally by: ChernoChiel imo u dont have to put the hours and days and stuff in it. just the hour. everybody can guess that 72.35 hours equals 3 days and 20 minutes.
the days is easy to calculate in excel (divide by 24) and the hours should be clear enough. (in my oh so humble opinion btw ;P )
I put it IN there cuz people asked for it. Anyhow - NEW version posted! Enjoy!
[email protected] http://www.goi-eve.com/forums/ Check out the Eve Master Datasheet here!! |
Lachenlaud
|
Posted - 2004.06.02 13:29:00 -
[29]
Originally by: Shooter Mclean Just downloaded this sheet to see what goes on. I feel it may help me understand the mechanics of the game a bit better.
Many thanks
If I have any ideas I will post them.
Cool deal! Hope it helps you out!
[email protected] http://www.goi-eve.com/forums/ Check out the Eve Master Datasheet here!! |
Lachenlaud
|
Posted - 2004.06.06 20:23:00 -
[30]
Originally by: ChernoChiel v400 is even better :)
wicked stuff m8 thanx for all ur work on it!
but one thing, all these new versions make it a bit crappy to use the newest one... u gotta copy/pase all the Skill points into the next sheet...
but little effort for a great way to plan ur skills :)
Once I get all the features to where I want them to be - it is very likely that i will turn it into an 'installable' program that you will simply have to update without cutting/pasting stuff. Thats a bit down the road though.
[email protected] http://www.goi-eve.com/forums/ Check out the Eve Master Datasheet here!! |
|
Lachenlaud
|
Posted - 2004.06.06 20:24:00 -
[31]
Originally by: number 258
this is amazing!!! keep up the good work
My thanks! And I shall!
[email protected] http://www.goi-eve.com/forums/ Check out the Eve Master Datasheet here!! |
Lachenlaud
|
Posted - 2004.06.08 14:43:00 -
[32]
Originally by: Aloris Crow This definitely deserves a sticky, Keep up the awesome work.
One thing I would change is the OreCalc sheet, It would be nice if it was a little more versatile for yield rates. Maybe allow the user to just add in the station efficiency and the cut the station takes to calculate the end yield. Also a price for buying and selling the ore, handy for those who aren't sure whether their ore will be worth more in a processed or unprocessed state.
Since I'm not in a corp, or be in a position to be producing equipment I can't comment on those sections, but I hope you stick at this, it shows a hell of a lot of promise.
Excellent ideas all! I'll look at this next. Just finished making some changes (not yet released) to the 'Research' page of the sheet. It now calculates the 'Finish' time on a research slot and flags you when it's done. Some other cosmetic changes and bug fixes. Should be a v4.0x release by this coming weekend.
[email protected] http://www.goi-eve.com/forums/ Check out the Eve Master Datasheet here!! |
Lachenlaud
|
Posted - 2004.06.12 14:37:00 -
[33]
Ok, bunch of updates have been done! Check out Version 5.00!
[email protected] http://www.goi-eve.com/forums/ Check out the Eve Master Datasheet here!! |
Lachenlaud
|
Posted - 2004.06.23 00:10:00 -
[34]
Originally by: Aloris Crow Just noticed some small errors, the Iteron's cargo sizes are wrong.
Should be: Mk I : 3000 Mk II : 3750 Mk III : 4875 Mk IV : 5250 Mk V : 6000
Again, keep it up, it's an awesome help to have this.
FIXED! v6.00!
[email protected] http://www.goi-eve.com/forums/ Check out the Eve Master Datasheet here!! |
Lachenlaud
|
Posted - 2004.06.23 00:11:00 -
[35]
Originally by: Plutu A few ideas for your awesome skills chart:
1)Automatic checkmark next to "have skill" in "skills" tab if you have any skillpoints in that skill. Something like: =IF(($F$13)>0,"YES","NO"), (I know the formula is not correct) - could also introduce red/green color codes instead of yes/no.
2)A third kind of color code (yellow) next to "have skill" in "skills" tab if you are able to begin training a specific skill (you have the requirements) but have not yet begun training it. (alot of work, I know)
These are added! v6.00!
[email protected] http://www.goi-eve.com/forums/ Check out the Eve Master Datasheet here!! |
Lachenlaud
|
Posted - 2004.06.23 00:12:00 -
[36]
Originally by: Eridicus In the production calculations would it be possible if the needed ammount is <0 of the onhand you return a negative number or notated number (suchaswithinparans) of how much remains to get?
I'll have to look at this one. The production page is by no means complete yet though! Thanks for the idea!
[email protected] http://www.goi-eve.com/forums/ Check out the Eve Master Datasheet here!! |
Lachenlaud
|
Posted - 2004.07.02 04:07:00 -
[37]
Originally by: AtoningUnifex Very nice work.
But you're missing 2 skills which are readily available on the market... Cloaking Covert Ops
Already added - and will be coming out with the next version!
[email protected] http://www.goi-eve.com/forums/ Check out the Eve Master Datasheet here!! |
Lachenlaud
|
Posted - 2004.07.02 04:07:00 -
[38]
Originally by: AtoningUnifex Very nice work.
But you're missing 2 skills which are readily available on the market... Cloaking Covert Ops
Already added - and will be coming out with the next version!
[email protected] http://www.goi-eve.com/forums/ Check out the Eve Master Datasheet here!! |
Lachenlaud
|
Posted - 2004.07.02 04:08:00 -
[39]
Originally by: Iskander Great stuff, I'm looking forward to setting this up when I'm at home. What chance an option to sync up with EVE-DB or EVE-DB source files? You should sell this back to CCP and improve their Character Info section on the web!!
Dunno about the source files or DB - it's excel so I should be able to do something with a vbasic macro or somesuch. I'll look into this.
If CCP wants it, they can have it - just like anyone else. It's free to all - I do this because I enjoy it. Of course, I'd GLADLY accept a STICKY as a token of appreciation. :-P
[email protected] http://www.goi-eve.com/forums/ Check out the Eve Master Datasheet here!! |
Lachenlaud
|
Posted - 2004.07.02 04:08:00 -
[40]
Originally by: Iskander Great stuff, I'm looking forward to setting this up when I'm at home. What chance an option to sync up with EVE-DB or EVE-DB source files? You should sell this back to CCP and improve their Character Info section on the web!!
Dunno about the source files or DB - it's excel so I should be able to do something with a vbasic macro or somesuch. I'll look into this.
If CCP wants it, they can have it - just like anyone else. It's free to all - I do this because I enjoy it. Of course, I'd GLADLY accept a STICKY as a token of appreciation. :-P
[email protected] http://www.goi-eve.com/forums/ Check out the Eve Master Datasheet here!! |
|
Lachenlaud
|
Posted - 2004.07.02 04:09:00 -
[41]
Originally by: YoYonis Sweet love the new version.
Thanks!
I should be releasing the NEXT version some time around the 10th or 11th.
[email protected] http://www.goi-eve.com/forums/ Check out the Eve Master Datasheet here!! |
Lachenlaud
|
Posted - 2004.07.02 04:09:00 -
[42]
Originally by: YoYonis Sweet love the new version.
Thanks!
I should be releasing the NEXT version some time around the 10th or 11th.
[email protected] http://www.goi-eve.com/forums/ Check out the Eve Master Datasheet here!! |
Lachenlaud
|
Posted - 2004.07.13 05:24:00 -
[43]
Originally by: Reva Ortov I stumbled across your thread while browsing the forums and tried out your sheet. Its really great for my needs. Its a lot of work and you should get a sticky
Thanks for the feedback.
Just a note - am attempting to include some really cool functions in the next release - hence the delay. Hope it's worth it! It will be out by the weekend of the 17th (or soonÖ as some might say ;-))
[email protected] http://www.goi-eve.com/forums/ Check out the Eve Master Datasheet here!! |
Lachenlaud
|
Posted - 2004.07.13 05:24:00 -
[44]
Originally by: Reva Ortov I stumbled across your thread while browsing the forums and tried out your sheet. Its really great for my needs. Its a lot of work and you should get a sticky
Thanks for the feedback.
Just a note - am attempting to include some really cool functions in the next release - hence the delay. Hope it's worth it! It will be out by the weekend of the 17th (or soonÖ as some might say ;-))
[email protected] http://www.goi-eve.com/forums/ Check out the Eve Master Datasheet here!! |
Lachenlaud
|
Posted - 2004.07.15 05:31:00 -
[45]
Originally by: Eridicus how did you get five pages of comments and go this log and this many updates and still no sticky. Who'd you upset? ;-)
Dunno.... guess the Moderator doesn't like my face or sumthin....
[email protected] http://www.goi-eve.com/forums/ Check out the Eve Master Datasheet here!! |
Lachenlaud
|
Posted - 2004.07.15 05:31:00 -
[46]
Originally by: Eridicus how did you get five pages of comments and go this log and this many updates and still no sticky. Who'd you upset? ;-)
Dunno.... guess the Moderator doesn't like my face or sumthin....
[email protected] http://www.goi-eve.com/forums/ Check out the Eve Master Datasheet here!! |
Lachenlaud
|
Posted - 2004.07.15 23:24:00 -
[47]
Bug fixes, bug fixes, bug fixes....
Just updated the release to v7.01.
Hopefully this will make things a bit smoother.
[email protected] http://www.goi-eve.com/forums/ Check out the Eve Master Datasheet here!! |
Lachenlaud
|
Posted - 2004.07.15 23:24:00 -
[48]
Bug fixes, bug fixes, bug fixes....
Just updated the release to v7.01.
Hopefully this will make things a bit smoother.
[email protected] http://www.goi-eve.com/forums/ Check out the Eve Master Datasheet here!! |
Lachenlaud
|
Posted - 2004.07.16 01:44:00 -
[49]
Oh.. forgot to mention... one of the side effects of the new AutoUpdate feature (if it works for you...):
It WILL show you your base attribs! :-D
One flaw I'm already aware of - it does NOT take into account +1 Implants (because the Eve XML document doesn't - not because of a failing in the sheet.... hope they fix that).
[email protected] http://www.goi-eve.com/forums/ Check out the Eve Master Datasheet here!! |
Lachenlaud
|
Posted - 2004.07.16 01:44:00 -
[50]
Oh.. forgot to mention... one of the side effects of the new AutoUpdate feature (if it works for you...):
It WILL show you your base attribs! :-D
One flaw I'm already aware of - it does NOT take into account +1 Implants (because the Eve XML document doesn't - not because of a failing in the sheet.... hope they fix that).
[email protected] http://www.goi-eve.com/forums/ Check out the Eve Master Datasheet here!! |
|
Lachenlaud
|
Posted - 2004.07.17 04:47:00 -
[51]
I believe the runtime error 1004 has something to do with the Win2K versions of excel. I'm going to play with this on a friends computer and see if I can't get it to work there.
[email protected] http://www.goi-eve.com/forums/ Check out the Eve Master Datasheet here!! |
Lachenlaud
|
Posted - 2004.07.17 04:47:00 -
[52]
I believe the runtime error 1004 has something to do with the Win2K versions of excel. I'm going to play with this on a friends computer and see if I can't get it to work there.
[email protected] http://www.goi-eve.com/forums/ Check out the Eve Master Datasheet here!! |
Lachenlaud
|
Posted - 2004.07.18 15:29:00 -
[53]
Originally by: carnezac hi sheet look great but im getting this error Selection.QueryTable.Refresh BackgroundQuery:=False
What error # was associated with this?
[email protected] http://www.goi-eve.com/forums/ Check out the Eve Master Datasheet here!! |
Lachenlaud
|
Posted - 2004.07.18 15:29:00 -
[54]
Originally by: carnezac hi sheet look great but im getting this error Selection.QueryTable.Refresh BackgroundQuery:=False
What error # was associated with this?
[email protected] http://www.goi-eve.com/forums/ Check out the Eve Master Datasheet here!! |
Lachenlaud
|
Posted - 2004.07.18 15:31:00 -
[55]
Originally by: loladoll very nice indeed. Big thumbs up I used the autoupdate, but it didn't upload all my skills (darc ochre processing, hemophrite processing, torpedoes, longe range targeting werent showing after download). They are mentioned in the xml file however
Thanks.
Try updating again after you do it the first time. I've noticed that sometimes lag can cause it to not update certain skills. I have all of the ones mentioned above, and they do update for me....so it's not a spreadsheet issue.
[email protected] http://www.goi-eve.com/forums/ Check out the Eve Master Datasheet here!! |
Lachenlaud
|
Posted - 2004.07.18 15:31:00 -
[56]
Originally by: loladoll very nice indeed. Big thumbs up I used the autoupdate, but it didn't upload all my skills (darc ochre processing, hemophrite processing, torpedoes, longe range targeting werent showing after download). They are mentioned in the xml file however
Thanks.
Try updating again after you do it the first time. I've noticed that sometimes lag can cause it to not update certain skills. I have all of the ones mentioned above, and they do update for me....so it's not a spreadsheet issue.
[email protected] http://www.goi-eve.com/forums/ Check out the Eve Master Datasheet here!! |
Lachenlaud
|
Posted - 2004.07.21 14:18:00 -
[57]
Originally by: Ryco I dont beleive this is the problem Im having depsite the fact that Im getting a run time error as well. Ive screwed with the sheet creating my own query and that query works. But I did not change any access rules.
Can you send me a copy of your query that works Ryco?
[email protected] http://www.goi-eve.com/forums/ Check out the Eve Master Datasheet here!! |
Lachenlaud
|
Posted - 2004.07.21 14:18:00 -
[58]
Originally by: Ryco I dont beleive this is the problem Im having depsite the fact that Im getting a run time error as well. Ive screwed with the sheet creating my own query and that query works. But I did not change any access rules.
Can you send me a copy of your query that works Ryco?
[email protected] http://www.goi-eve.com/forums/ Check out the Eve Master Datasheet here!! |
Lachenlaud
|
Posted - 2004.07.21 14:20:00 -
[59]
Originally by: Marina DuMans First, thx for the work on this spreadsheet. very impressive.
Just wanted to tell you that with you graphiccal element in skills sheets, the speadsheet doesn't work anymoe in OpenOffice. I was so happy to use a free software ....
Doesn't OpenOffice ask you what tabs to import?
If so - just skip the chart.
[email protected] http://www.goi-eve.com/forums/ Check out the Eve Master Datasheet here!! |
Lachenlaud
|
Posted - 2004.07.21 14:20:00 -
[60]
Originally by: Marina DuMans First, thx for the work on this spreadsheet. very impressive.
Just wanted to tell you that with you graphiccal element in skills sheets, the speadsheet doesn't work anymoe in OpenOffice. I was so happy to use a free software ....
Doesn't OpenOffice ask you what tabs to import?
If so - just skip the chart.
[email protected] http://www.goi-eve.com/forums/ Check out the Eve Master Datasheet here!! |
|
Lachenlaud
|
Posted - 2004.07.23 04:17:00 -
[61]
Edited by: Lachenlaud on 23/07/2004 04:39:30
Originally by: Girard DeSade How is this going to be different than the Eve-I Character Manager?
Well lets see.... 1) It's a spreadsheet 2) People can look and see what is going on at the back-end if they choose to at any time 3) It can be changed at a whim to suite your personal needs/desires/requirements (assuming you know how to use excel) 4) If someone already has excel it doesn't require them to install 'yet another program'
Does it matter if it differs or does the same thing? Frankly I've never even looked at the 'Character Manager' and don't care to since it would require I install 'yet another program' on my system, and one with single purpose functionality... eg - EVE. I can do anything with excel... whether its eve related or not... shrug - doesn't matter much to me in either case.... I put the Eve Skills Spreadsheet together originally with myself in mind, ended up sharing it with a few people - and it was suggested I post it. Thus, I continue to develop it.
Nice try at hijacking my thread by the way. Cheap - but nice. (Oh - and thanks for the bump )
[email protected] http://www.goi-eve.com/forums/ Check out the Eve Master Datasheet here!! |
Lachenlaud
|
Posted - 2004.07.23 04:17:00 -
[62]
Edited by: Lachenlaud on 23/07/2004 04:39:30
Originally by: Girard DeSade How is this going to be different than the Eve-I Character Manager?
Well lets see.... 1) It's a spreadsheet 2) People can look and see what is going on at the back-end if they choose to at any time 3) It can be changed at a whim to suite your personal needs/desires/requirements (assuming you know how to use excel) 4) If someone already has excel it doesn't require them to install 'yet another program'
Does it matter if it differs or does the same thing? Frankly I've never even looked at the 'Character Manager' and don't care to since it would require I install 'yet another program' on my system, and one with single purpose functionality... eg - EVE. I can do anything with excel... whether its eve related or not... shrug - doesn't matter much to me in either case.... I put the Eve Skills Spreadsheet together originally with myself in mind, ended up sharing it with a few people - and it was suggested I post it. Thus, I continue to develop it.
Nice try at hijacking my thread by the way. Cheap - but nice. (Oh - and thanks for the bump )
[email protected] http://www.goi-eve.com/forums/ Check out the Eve Master Datasheet here!! |
Lachenlaud
|
Posted - 2004.07.23 04:23:00 -
[63]
Originally by: Riddari Nice work with the Excel sheet but the Character Manager totally blows my mind, what a fantastic piece of program!
Thanks.... but it's ok if you use the "character manager", really.... I don't mind. I am sure it's a lovely piece of work.... I just refuse to use any compiled code that can have access to my password and login for a game or service I pay for with a credit card. Something that isn't at all necessary with my spreadsheet since you can log on to the eve website seperately and it can then go and open a web session to grab the info it needs (not to mention look at the code at any time since it's not compiled.)
Call me paranoid....
[email protected] http://www.goi-eve.com/forums/ Check out the Eve Master Datasheet here!! |
Lachenlaud
|
Posted - 2004.07.23 04:23:00 -
[64]
Originally by: Riddari Nice work with the Excel sheet but the Character Manager totally blows my mind, what a fantastic piece of program!
Thanks.... but it's ok if you use the "character manager", really.... I don't mind. I am sure it's a lovely piece of work.... I just refuse to use any compiled code that can have access to my password and login for a game or service I pay for with a credit card. Something that isn't at all necessary with my spreadsheet since you can log on to the eve website seperately and it can then go and open a web session to grab the info it needs (not to mention look at the code at any time since it's not compiled.)
Call me paranoid....
[email protected] http://www.goi-eve.com/forums/ Check out the Eve Master Datasheet here!! |
Lachenlaud
|
Posted - 2004.07.23 04:33:00 -
[65]
Originally by: Fubar Excel 2000 would require the use of the Microsoft XML, version 2.0 (or greater) library for XML parsing. This provides the DOMDocument class.
I would also use the Microsoft WinHTTP Services, version 5.1 to retrieve the XML file. This provides the WinHttpRequest class.
Fubar - can you provide links for us that I can include with the spreadsheet zip for people who have excel 2000?
[email protected] http://www.goi-eve.com/forums/ Check out the Eve Master Datasheet here!! |
Lachenlaud
|
Posted - 2004.07.23 04:33:00 -
[66]
Originally by: Fubar Excel 2000 would require the use of the Microsoft XML, version 2.0 (or greater) library for XML parsing. This provides the DOMDocument class.
I would also use the Microsoft WinHTTP Services, version 5.1 to retrieve the XML file. This provides the WinHttpRequest class.
Fubar - can you provide links for us that I can include with the spreadsheet zip for people who have excel 2000?
[email protected] http://www.goi-eve.com/forums/ Check out the Eve Master Datasheet here!! |
Lachenlaud
|
Posted - 2004.07.23 04:37:00 -
[67]
Originally by: Grayson Burrows The graph ends up taking two tabs of space instead of one which offsets all of the other tabs by that extra one. If you were to move the graph tab to the very end of the list, it would probably fix issues with OpenOffice.
Since all the formulas are based on the 'Tab Name' and not location - it's not a problem for me to move the Chart tab to the 'end' of the row... I am curious however as to what the name of the 'second' tab that is generated for the chart is called.
I may have to install OpenOffice to see for myself...
[email protected] http://www.goi-eve.com/forums/ Check out the Eve Master Datasheet here!! |
Lachenlaud
|
Posted - 2004.07.23 04:37:00 -
[68]
Originally by: Grayson Burrows The graph ends up taking two tabs of space instead of one which offsets all of the other tabs by that extra one. If you were to move the graph tab to the very end of the list, it would probably fix issues with OpenOffice.
Since all the formulas are based on the 'Tab Name' and not location - it's not a problem for me to move the Chart tab to the 'end' of the row... I am curious however as to what the name of the 'second' tab that is generated for the chart is called.
I may have to install OpenOffice to see for myself...
[email protected] http://www.goi-eve.com/forums/ Check out the Eve Master Datasheet here!! |
Lachenlaud
|
Posted - 2004.07.23 04:40:00 -
[69]
Originally by: TDR Xander Girard : I prefer the spreadsheet layout of this than the char manager in that link you provided...
I guess its personal preference
EXACTLY!
[email protected] http://www.goi-eve.com/forums/ Check out the Eve Master Datasheet here!! |
Lachenlaud
|
Posted - 2004.07.23 04:40:00 -
[70]
Originally by: TDR Xander Girard : I prefer the spreadsheet layout of this than the char manager in that link you provided...
I guess its personal preference
EXACTLY!
[email protected] http://www.goi-eve.com/forums/ Check out the Eve Master Datasheet here!! |
|
Lachenlaud
|
Posted - 2004.07.26 14:17:00 -
[71]
Originally by: Grayson Burrows That's the nasty part. The second graph tab ends up taking the tab name of the tab immediately after Skillset Graph (Skill Descriptions). The contents of every tab gets bumped to the right by one. Basicly, every tab after the Skillset Graph tab ends up with the wrong contents. The last tab ends up with a default name of "Sheet17" since the bump created a requirement for another tab to hold data.
Ahhhhh I see! Well that makes some sense I suppose - though Open Office needs to get their act together if they wish to compete.
I'll see what I can do about moving the graph page to the end.
[email protected] http://www.goi-eve.com/forums/ Check out the Eve Master Datasheet here!! |
Lachenlaud
|
Posted - 2004.07.26 14:17:00 -
[72]
Originally by: Grayson Burrows That's the nasty part. The second graph tab ends up taking the tab name of the tab immediately after Skillset Graph (Skill Descriptions). The contents of every tab gets bumped to the right by one. Basicly, every tab after the Skillset Graph tab ends up with the wrong contents. The last tab ends up with a default name of "Sheet17" since the bump created a requirement for another tab to hold data.
Ahhhhh I see! Well that makes some sense I suppose - though Open Office needs to get their act together if they wish to compete.
I'll see what I can do about moving the graph page to the end.
[email protected] http://www.goi-eve.com/forums/ Check out the Eve Master Datasheet here!! |
Lachenlaud
|
Posted - 2004.07.26 14:19:00 -
[73]
Originally by: Imhotep Khem I like it.
My time does not seem to match what even is saying though. I have added all my attributes. All the learning skill values. (Figure out to enter skill points and not skill level) And the current value of the skill. But Eve is saying i have an extra day or so from what the spread sheet is saying.
Example, I have learning 5 and the rest learning skills at 4. To train one of them to 5 eve: 7D 3M 29s sheet: 5D 30M
Any idea whats up?
mem 15 int 11 per 15 cha 11 wil 12
Can you send me a screenshot of what eve is saynig and a populated copy of the sheet?
[email protected] http://www.goi-eve.com/forums/ Check out the Eve Master Datasheet here!! |
Lachenlaud
|
Posted - 2004.07.26 14:19:00 -
[74]
Originally by: IZON Hey LL have you tried running Skill Checker in the spreadsheet that comes with the open source programme OpenOffice v1.1? I'm not using excel, would you mind taking a look at it ? I just wanted to know if skill checker performs worse under OpenOffice.
Not sure what you're asking me for here? Can you clarify?
[email protected] http://www.goi-eve.com/forums/ Check out the Eve Master Datasheet here!! |
Lachenlaud
|
Posted - 2004.07.26 14:19:00 -
[75]
Originally by: Imhotep Khem I like it.
My time does not seem to match what even is saying though. I have added all my attributes. All the learning skill values. (Figure out to enter skill points and not skill level) And the current value of the skill. But Eve is saying i have an extra day or so from what the spread sheet is saying.
Example, I have learning 5 and the rest learning skills at 4. To train one of them to 5 eve: 7D 3M 29s sheet: 5D 30M
Any idea whats up?
mem 15 int 11 per 15 cha 11 wil 12
Can you send me a screenshot of what eve is saynig and a populated copy of the sheet?
[email protected] http://www.goi-eve.com/forums/ Check out the Eve Master Datasheet here!! |
Lachenlaud
|
Posted - 2004.07.26 14:19:00 -
[76]
Originally by: IZON Hey LL have you tried running Skill Checker in the spreadsheet that comes with the open source programme OpenOffice v1.1? I'm not using excel, would you mind taking a look at it ? I just wanted to know if skill checker performs worse under OpenOffice.
Not sure what you're asking me for here? Can you clarify?
[email protected] http://www.goi-eve.com/forums/ Check out the Eve Master Datasheet here!! |
Lachenlaud
|
Posted - 2004.07.26 14:22:00 -
[77]
Originally by: Loud Bob Edited by: Loud Bob on 26/07/2004 14:18:58 Just a quick question:
I have an average of 24.6 SP's per minute, is that good or bad?
I get 33.6 SP's in Leadership & Trade (is Trade in the game yet?) 27 in Spaceship Command/ Missle Launcher OP's & Gunnery 25.3 in Navigation 24.8 in Electronics/Engineering/Mechanics & Science 21.5 in Industry & Social 18.7 in Drones & a pityful 18.2 in Corp Managment
Thats with all Learning skills at level 5 & 4x(+3)implants (missing memory +3 implant)
That's better than I have :)
[email protected] http://www.goi-eve.com/forums/ Check out the Eve Master Datasheet here!! |
Lachenlaud
|
Posted - 2004.07.26 14:22:00 -
[78]
Originally by: Loud Bob Edited by: Loud Bob on 26/07/2004 14:18:58 Just a quick question:
I have an average of 24.6 SP's per minute, is that good or bad?
I get 33.6 SP's in Leadership & Trade (is Trade in the game yet?) 27 in Spaceship Command/ Missle Launcher OP's & Gunnery 25.3 in Navigation 24.8 in Electronics/Engineering/Mechanics & Science 21.5 in Industry & Social 18.7 in Drones & a pityful 18.2 in Corp Managment
Thats with all Learning skills at level 5 & 4x(+3)implants (missing memory +3 implant)
That's better than I have :)
[email protected] http://www.goi-eve.com/forums/ Check out the Eve Master Datasheet here!! |
Lachenlaud
|
Posted - 2004.07.27 19:02:00 -
[79]
Originally by: Vidur Tried the auto update, didnt work. I was logged in but all I got was that it wasnt my character. I then tried too edit the macro to read a manualy downloaded xml file. But since I never used macros before I failed to get it to work.
Is it possible for you to change the macro to import a manualy downloaded xml file?
/Vidur
Actually someone just sent me something that does JUST THAT. I will be adding it to the next version if it works properly (haven't tested it yet).
[email protected] http://www.goi-eve.com/forums/ Check out the Eve Master Datasheet here!! |
Lachenlaud
|
Posted - 2004.07.27 19:02:00 -
[80]
Originally by: Dajar Binks hum well, it's not working for me too.
I put my ID number and hit CTRL-G, it seem to do some work, and when all is finish, no data appear (no name, no skill, ...etc...)
On the XML data page - does it say "Download is good" or "Retry Download" afterwards?
[email protected] http://www.goi-eve.com/forums/ Check out the Eve Master Datasheet here!! |
|
Lachenlaud
|
Posted - 2004.07.27 19:02:00 -
[81]
Originally by: Vidur Tried the auto update, didnt work. I was logged in but all I got was that it wasnt my character. I then tried too edit the macro to read a manualy downloaded xml file. But since I never used macros before I failed to get it to work.
Is it possible for you to change the macro to import a manualy downloaded xml file?
/Vidur
Actually someone just sent me something that does JUST THAT. I will be adding it to the next version if it works properly (haven't tested it yet).
[email protected] http://www.goi-eve.com/forums/ Check out the Eve Master Datasheet here!! |
Lachenlaud
|
Posted - 2004.07.27 19:02:00 -
[82]
Originally by: Dajar Binks hum well, it's not working for me too.
I put my ID number and hit CTRL-G, it seem to do some work, and when all is finish, no data appear (no name, no skill, ...etc...)
On the XML data page - does it say "Download is good" or "Retry Download" afterwards?
[email protected] http://www.goi-eve.com/forums/ Check out the Eve Master Datasheet here!! |
Lachenlaud
|
Posted - 2004.07.27 19:03:00 -
[83]
Originally by: Vidur Another small bug is that the skill "Long Range Targeting" isnÆt spelt right. This makes the skill not updating at all in the sheet.
I'll look at this. THANKS!
[email protected] http://www.goi-eve.com/forums/ Check out the Eve Master Datasheet here!! |
Lachenlaud
|
Posted - 2004.07.27 19:03:00 -
[84]
Originally by: Vidur Another small bug is that the skill "Long Range Targeting" isnÆt spelt right. This makes the skill not updating at all in the sheet.
I'll look at this. THANKS!
[email protected] http://www.goi-eve.com/forums/ Check out the Eve Master Datasheet here!! |
Lachenlaud
|
Posted - 2004.07.30 23:42:00 -
[85]
Originally by: Symeonis Porphory Some other strange occurence when downloading your stats: The skill I was training showed up with 7,070,193 skillpoints, level 4, with -5,790,193 to go to lvl 5.
What time zone are you in?
I discovered something with the formulas in the auto-update.... they don't take into account your present 'TIME ZONE'.
I've fixed that and will be making yet another 'patch release' this weekend to account for that and certain other bugs that have been identified.
[email protected] http://www.goi-eve.com/forums/ Check out the Eve Master Datasheet here!! |
Lachenlaud
|
Posted - 2004.07.30 23:42:00 -
[86]
Originally by: Symeonis Porphory Some other strange occurence when downloading your stats: The skill I was training showed up with 7,070,193 skillpoints, level 4, with -5,790,193 to go to lvl 5.
What time zone are you in?
I discovered something with the formulas in the auto-update.... they don't take into account your present 'TIME ZONE'.
I've fixed that and will be making yet another 'patch release' this weekend to account for that and certain other bugs that have been identified.
[email protected] http://www.goi-eve.com/forums/ Check out the Eve Master Datasheet here!! |
Lachenlaud
|
Posted - 2004.07.30 23:43:00 -
[87]
Originally by: ChernoChiel i have discovered a little error in ur auto update thingy...
in eve i have 70 skills, and in ur sheet it says 65.
long range targetting wont update. it says i have weapon disruption, which i dont have (yet :P ) he wont update torpedos
the rest is ok. so i think he doesnt count the total correctly...
Yep - bug fix release coming this weekend. :)
[email protected] http://www.goi-eve.com/forums/ Check out the Eve Master Datasheet here!! |
Lachenlaud
|
Posted - 2004.07.30 23:43:00 -
[88]
Originally by: ChernoChiel i have discovered a little error in ur auto update thingy...
in eve i have 70 skills, and in ur sheet it says 65.
long range targetting wont update. it says i have weapon disruption, which i dont have (yet :P ) he wont update torpedos
the rest is ok. so i think he doesnt count the total correctly...
Yep - bug fix release coming this weekend. :)
[email protected] http://www.goi-eve.com/forums/ Check out the Eve Master Datasheet here!! |
Lachenlaud
|
Posted - 2004.08.01 17:02:00 -
[89]
Originally by: Sherkaner *stealth sticky*
YAY!
/me jumps up and down for joy!
[email protected] http://www.goi-eve.com/forums/ Check out the Eve Master Datasheet here!! |
Lachenlaud
|
Posted - 2004.08.01 17:02:00 -
[90]
Originally by: Sherkaner *stealth sticky*
YAY!
/me jumps up and down for joy!
[email protected] http://www.goi-eve.com/forums/ Check out the Eve Master Datasheet here!! |
|
Lachenlaud
|
Posted - 2004.08.01 17:03:00 -
[91]
Originally by: Vincent Vlados Heyya Lachenlaud!
Had some problems with the autoupdate feature with Excel 2000 as mentioned earlier in this thead.
For details on redistributing of the MSXML and Win HTTP, check this document on MSDN http://msdn.microsoft.com/library/default.asp?url=/library/en-us/xmlsdk/html/sdk_redistributing.asp Cheers!
YES! Thank you Vincent!
I'll look into this right away!
[email protected] http://www.goi-eve.com/forums/ Check out the Eve Master Datasheet here!! |
Lachenlaud
|
Posted - 2004.08.01 17:03:00 -
[92]
Originally by: Vincent Vlados Heyya Lachenlaud!
Had some problems with the autoupdate feature with Excel 2000 as mentioned earlier in this thead.
For details on redistributing of the MSXML and Win HTTP, check this document on MSDN http://msdn.microsoft.com/library/default.asp?url=/library/en-us/xmlsdk/html/sdk_redistributing.asp Cheers!
YES! Thank you Vincent!
I'll look into this right away!
[email protected] http://www.goi-eve.com/forums/ Check out the Eve Master Datasheet here!! |
Lachenlaud
|
Posted - 2004.08.01 21:34:00 -
[93]
Originally by: DarkStar251 Just getting a 'retry download' here :(
Using Excel 2003 (11.6113.5703), Firefox as my main browser, but both Firefox and IE opend and logged into EVE Insider.
Is there any sort of macro error log in Excel?
TIA for any help :D
Not sure - I use Office XP so there might be something different about excel 2003. I do know that even though YOU are using Firefox for you main browser - Excel will default to IE in the background regardless.
Try opening your character in IE and then running the macro.
[email protected] http://www.goi-eve.com/forums/ Check out the Eve Master Datasheet here!! |
Lachenlaud
|
Posted - 2004.08.01 21:34:00 -
[94]
Originally by: DarkStar251 Just getting a 'retry download' here :(
Using Excel 2003 (11.6113.5703), Firefox as my main browser, but both Firefox and IE opend and logged into EVE Insider.
Is there any sort of macro error log in Excel?
TIA for any help :D
Not sure - I use Office XP so there might be something different about excel 2003. I do know that even though YOU are using Firefox for you main browser - Excel will default to IE in the background regardless.
Try opening your character in IE and then running the macro.
[email protected] http://www.goi-eve.com/forums/ Check out the Eve Master Datasheet here!! |
Lachenlaud
|
Posted - 2004.08.05 05:41:00 -
[95]
My appologies for the next release taking so long - I'm working out a bunch of issues with the AutoUpdate and OpenOffice stuff.
Hopefully will have something this weekend.
[email protected] http://www.goi-eve.com/forums/ Check out the Eve Master Datasheet here!! |
Lachenlaud
|
Posted - 2004.08.05 05:41:00 -
[96]
My appologies for the next release taking so long - I'm working out a bunch of issues with the AutoUpdate and OpenOffice stuff.
Hopefully will have something this weekend.
[email protected] http://www.goi-eve.com/forums/ Check out the Eve Master Datasheet here!! |
Lachenlaud
|
Posted - 2004.09.09 02:18:00 -
[97]
Originally by: NakedGun i dont know if any1 has asked b4 (too many posts on this thread to read thro' lol) but is there any chance of getting a html / web based version of this up? I dont use excel and dont really want to have to install it.. I would greatly appreciate a html / web based version..
One word... SECURITY. I personally am paranoid about it. Here's the problem in a nutshell: In order for the autoupdate to work - you would have to expose your password to Eve on an unsecured connection. This means anyone tapping in (myself included since it would be running on a server I have control of) would theoretically be able to GET your account info.
I have yet to think of a way to do this without requiring your password to access the XML info.
I could post a version that doesn't auto-update - but that would be a step down from where I'm headed with this. Since it's in an Excel file that doesn't require you to connect to anything directly (since you log on to eve as usual through your browser to autoupdate) there is no danger of anyone gaining access to your account unless you are careless.
Anyone have any ideas for me on this? Come up with a reasonable method and I'll be happy to try it.
[email protected] http://www.goi-eve.com/forums/ Check out the Eve Master Datasheet here!! |
Lachenlaud
|
Posted - 2004.09.09 02:18:00 -
[98]
Originally by: NakedGun i dont know if any1 has asked b4 (too many posts on this thread to read thro' lol) but is there any chance of getting a html / web based version of this up? I dont use excel and dont really want to have to install it.. I would greatly appreciate a html / web based version..
One word... SECURITY. I personally am paranoid about it. Here's the problem in a nutshell: In order for the autoupdate to work - you would have to expose your password to Eve on an unsecured connection. This means anyone tapping in (myself included since it would be running on a server I have control of) would theoretically be able to GET your account info.
I have yet to think of a way to do this without requiring your password to access the XML info.
I could post a version that doesn't auto-update - but that would be a step down from where I'm headed with this. Since it's in an Excel file that doesn't require you to connect to anything directly (since you log on to eve as usual through your browser to autoupdate) there is no danger of anyone gaining access to your account unless you are careless.
Anyone have any ideas for me on this? Come up with a reasonable method and I'll be happy to try it.
[email protected] http://www.goi-eve.com/forums/ Check out the Eve Master Datasheet here!! |
Lachenlaud
|
Posted - 2004.09.30 05:17:00 -
[99]
Originally by: PhasmaNL What I really would like to know is when a version is released which is updated for the Advanced Learning skills! :)
You got it. Version 8.00 now up for download.
[email protected] http://www.goi-eve.com/forums/ Check out the Eve Master Datasheet here!! |
Lachenlaud
|
Posted - 2004.09.30 05:17:00 -
[100]
Originally by: PhasmaNL What I really would like to know is when a version is released which is updated for the Advanced Learning skills! :)
You got it. Version 8.00 now up for download.
[email protected] http://www.goi-eve.com/forums/ Check out the Eve Master Datasheet here!! |
|
Lachenlaud
|
Posted - 2004.10.01 12:53:00 -
[101]
Originally by: AtoningUnifex Yep, does that for me too (still).
run time error 1004 application defined or object defined error.
using Win2k Pro & Office 2000.
I think someone said earlier in this thread that Office 2000 doesn't have xml support, so I guess that's the reason for the error.
Vincent posted this previously in the thread.
For details on redistributing of the MSXML and Win HTTP, check this document on MSDN http://msdn.microsoft.com/library/default.asp?url=/library/en-us/xmlsdk/html/sdk_redistributing.asp
I'm going to check this out tonight.
[email protected] http://www.goi-eve.com/forums/ Check out the Eve Master Datasheet here!! |
Lachenlaud
|
Posted - 2004.10.01 12:53:00 -
[102]
Originally by: AtoningUnifex Yep, does that for me too (still).
run time error 1004 application defined or object defined error.
using Win2k Pro & Office 2000.
I think someone said earlier in this thread that Office 2000 doesn't have xml support, so I guess that's the reason for the error.
Vincent posted this previously in the thread.
For details on redistributing of the MSXML and Win HTTP, check this document on MSDN http://msdn.microsoft.com/library/default.asp?url=/library/en-us/xmlsdk/html/sdk_redistributing.asp
I'm going to check this out tonight.
[email protected] http://www.goi-eve.com/forums/ Check out the Eve Master Datasheet here!! |
Lachenlaud
|
Posted - 2004.11.25 15:32:00 -
[103]
New version 9 POSTED! See first message in this thread!
[email protected] http://www.goi-eve.com/forums/ Check out the Eve Master Datasheet here!! |
Lachenlaud
|
Posted - 2004.11.25 15:32:00 -
[104]
New version 9 POSTED! See first message in this thread!
[email protected] http://www.goi-eve.com/forums/ Check out the Eve Master Datasheet here!! |
Lachenlaud
|
Posted - 2004.12.04 16:07:00 -
[105]
Originally by: Kiithnaras You also haven't updated your ship list in a while. For the sake of the less-experienced, please do so on your next release.
Very true. As I stated in a previous post - this sheet was designed for SKILL tracking. I have, however received a contribution from someone that is supposed to have updates for all the new ships. I'll see if I can integrate it.
[email protected] http://www.goi-eve.com/forums/ Check out the Eve Master Datasheet here!! |
Lachenlaud
|
Posted - 2004.12.04 16:07:00 -
[106]
Originally by: Kiithnaras You also haven't updated your ship list in a while. For the sake of the less-experienced, please do so on your next release.
Very true. As I stated in a previous post - this sheet was designed for SKILL tracking. I have, however received a contribution from someone that is supposed to have updates for all the new ships. I'll see if I can integrate it.
[email protected] http://www.goi-eve.com/forums/ Check out the Eve Master Datasheet here!! |
Lachenlaud
|
Posted - 2004.12.16 22:07:00 -
[107]
Originally by: Nasferty Hi :D This is extreamly handy skill chart but I have one small problem , the learning skills do not affect my Final skills :/ How come ? This worked but all of a sudden it quit working , I've tried to download the sheet couple of times but nothing works :/
Cheers again ! A true masterpiece
Please email me a zipped copy of your version of the sheet and I'll take a looksee...
[email protected] http://www.goi-eve.com/forums/ Check out the Eve Master Datasheet here!! |
Lachenlaud
|
Posted - 2004.12.16 22:07:00 -
[108]
Originally by: Nasferty Hi :D This is extreamly handy skill chart but I have one small problem , the learning skills do not affect my Final skills :/ How come ? This worked but all of a sudden it quit working , I've tried to download the sheet couple of times but nothing works :/
Cheers again ! A true masterpiece
Please email me a zipped copy of your version of the sheet and I'll take a looksee...
[email protected] http://www.goi-eve.com/forums/ Check out the Eve Master Datasheet here!! |
Lachenlaud
|
Posted - 2004.12.18 05:14:00 -
[109]
Originally by: Nasferty Its the same I downloaded from the link you posted :/
Well I got your zip file and it works just fine here. Must be something wrong with your system. The Learning skill updates as it should from what I can see. Sorry I can't be of more help.
[email protected] http://www.goi-eve.com/forums/ Check out the Eve Master Datasheet here!! |
Lachenlaud
|
Posted - 2004.12.18 05:14:00 -
[110]
Originally by: Nasferty Its the same I downloaded from the link you posted :/
Well I got your zip file and it works just fine here. Must be something wrong with your system. The Learning skill updates as it should from what I can see. Sorry I can't be of more help.
[email protected] http://www.goi-eve.com/forums/ Check out the Eve Master Datasheet here!! |
|
Lachenlaud
|
Posted - 2005.01.26 01:53:00 -
[111]
Edited by: Lachenlaud on 26/01/2005 04:14:04 I've posted Version 10 of the spreadsheet.
[email protected] http://www.goi-eve.com/forums/ Check out the Eve Master Datasheet here!! |
Lachenlaud
|
Posted - 2005.01.26 04:14:00 -
[112]
WHOOPS!
The author of the Ore/Ice calc came to me with bug fixes right after release!
v10.01 now available!
[email protected] http://www.goi-eve.com/forums/ Check out the Eve Master Datasheet here!! |
Lachenlaud
|
Posted - 2005.02.02 23:03:00 -
[113]
Originally by: Cearz I've tried several different things to get the AutoUpdate working but no luck. I'm logged onto Eve Insider. Do I just go to my character page and copy the number in the address bar into the spreadsheet or what? All it shows after I hit CTRL+G is "Retry Download" and the Eve News over to the side.
Yes the character number is the one from the eve insider character sheet URL.
Also - you may (occasionally) have to do the CTRL+G 2x in order for it to actually grab the data. (It's a cookie issue with Eve-Online)
[email protected] http://www.goi-eve.com/forums/ Check out the Eve Master Datasheet here!! |
Lachenlaud
|
Posted - 2005.02.02 23:04:00 -
[114]
Originally by: Namarus Problem I have with the spreadsheet is that when I have skill points over the amount required to gain a level 5 in a skill the spreadsheet shows 1 level lower.
For example I have the learning skill at 256410 sp, max is 256000. As such I'm informed that I only have level 4 in the skill, when I have level 5.
I also have the same problem with the mechanic skill.
This problem arose when they had skill learning from usage. ie learning increased everytime you trained a skill.
Nothing I can do about your 'learning skill' issues. If you actually have more skill points in a skill than you are supposed to - I would petition CCP about it.
I will see if I can make a 'mod' to the sheet that will 'stamp' a 5 in there if you exceed 'max' skills - but no promises.
[email protected] http://www.goi-eve.com/forums/ Check out the Eve Master Datasheet here!! |
Lachenlaud
|
Posted - 2005.05.12 02:21:00 -
[115]
Hey all - just wanted to let ya'll know - I +WILL+ be releasing an update for the sheet very soon - I've been VERY busy with XF up until recently - but am now free of such duties to pursue the things I truly enjoy.
Look for the new version before the end of May'05. :)
[email protected] http://www.goi-eve.com/forums/ Check out the Eve Master Datasheet here!! |
Lachenlaud
|
Posted - 2005.05.27 04:42:00 -
[116]
Hello gang! Just wanted to let you all know that the Eve Master Datasheet has been updated and posted!
AUTOUPDATE should NOW be working. I've included a file called autoupdate.doc (word) that gives instructions on how to set it up.
Note to the Forum Ops: Any chance of deleting all the posts in this thread between the original and this one? It's a bit cluttered.
[email protected] http://www.goi-eve.com/forums/ Check out the Eve Master Datasheet here!! |
Lachenlaud
|
Posted - 2005.05.27 05:18:00 -
[117]
WHOOPS!
Chief Tactical Officer should have been Starbase Tactical Officer!
Updated to 11.01!
POSTED!
[email protected] http://www.goi-eve.com/forums/ Check out the Eve Master Datasheet here!! |
Lachenlaud
|
Posted - 2005.05.27 06:13:00 -
[118]
Originally by: Auren I'del Is it just me or are there some skills missing? I cant find Target painting, Frequency modulation, Long distance jamming, Signal dispersjon, Signal suppression +++
Any resons why these skills arn't in yet?
Cuz I'm a goofnugget
Email me a list and I'll get them added ASAP with v11.02
[email protected] http://www.goi-eve.com/forums/ Check out the Eve Master Datasheet here!! |
Lachenlaud
|
Posted - 2005.05.27 06:15:00 -
[119]
Oh a couple of Known Issues:
Office 2000 Professional gets a Runtime error 1004 (whatever the heck that is) when trying to use AutoUpdate. If anyone has ideas - pass 'em on. Meanwhile I'll research a possible workaround.
Also - You MUST use Internet Explorer when logging in to the Eve 'My Characters' section or the spreadsheet won't see it as being logged in.
[email protected] http://www.goi-eve.com/forums/ Check out the Eve Master Datasheet here!! |
Lachenlaud
|
Posted - 2005.05.27 06:30:00 -
[120]
Ok I AM a goofnugget
Missed 12 Skills:
ELECTRONICS * Frequency Modulation * Long Distance Jamming * Signal Dispersion * Signal Suppression * Signature Focusing * Target Painting * Turret Destabilization
MISSILES * Cruise Missile Specialization * Heavy Missile Specialization * Light Missile Specialization * Rocket Specialization * Torpedo Specialization
I'll get these added ASAP and post a revised bug-fix version by the weekend. Sorry for the screw-up.
[email protected] http://www.goi-eve.com/forums/ Check out the Eve Master Datasheet here!! |
|
Lachenlaud
|
Posted - 2005.05.28 07:05:00 -
[121]
Originally by: Auren I'del When will the skill Repair Drone Operation actually be implemented in EVE?
No Clue - unless a CCP rep wants to jump in here and answer this for you
[email protected] http://www.goi-eve.com/forums/ Check out the Eve Master Datasheet here!! |
Lachenlaud
|
Posted - 2005.05.28 07:10:00 -
[122]
Bugfix v11.50 posted.
* Added the 12 missing Electronics and Missile skills * Tweaked some cosmetics * Updated HRL for skill learning on Skill Description tab
Enjoy!
[email protected] http://www.goi-eve.com/forums/ Check out the Eve Master Datasheet here!! |
Lachenlaud
|
Posted - 2005.05.28 14:48:00 -
[123]
I asked the forum mods for help with this thread to clean it up a bit.
They suggested I create a new post (which can be found here) and said they would lock this one.
So - please use the new thread for additional replies, comments, or bug reports.
[email protected] http://www.goi-eve.com/forums/ Check out the Eve Master Datasheet here!! |
|
|
|