| Pages: 1 2 3 4 5 6 7 8 9 10 11 12 13 [14] 15 .. 15 :: one page |
| Author |
Thread Statistics | Show CCP posts - 0 post(s) |
Lachenlaud
   |
Posted - 2005.02.02 23:04:00 -
[391]
 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!! |
Dargon Starjammer
|
Posted - 2005.02.03 20:26:00 -
[392]
ok i got it to work.. except it doesn't want to show my atributes right and i have to keep manulay puting them in. it refuses to acpet that from my char and it just keeps doing iots own thing. and it doesn't list level 0 skills in the skill summary.
|
UK Glum
|
Posted - 2005.02.04 12:56:00 -
[393]
I too can now get the spreadsheet to autoupdate with 2x ctrl-G. However I also experience the problem of the base attributes resetting back to 8 for each.
|
Caelandra
|
Posted - 2005.02.04 16:24:00 -
[394]
I'm also having the attribute problem, but I am having another problem as well..
I try to download the information for this character, but everytime I do so, my character name changes to the name of one of my alts. I am positive that I have entered in the number correctly, becuase on the XML sheet it gives me the numbers for all three of my characters.
Any thoughts?
|
Fjellu
|
Posted - 2005.02.07 10:21:00 -
[395]
In spreadsheet there is a Chief Tactical Officer skill (rank 2) under Corp mgmt. Can't find such a skill, but I have a Starbase Tactical Officer skill (rank 5), which is not listed in the sheet.
|
Dargon Starjammer
|
Posted - 2005.02.08 01:06:00 -
[396]
ow another glitch. i have the mineing barge skill at level 5 and can fly a large barge. yet in your ship section were you list all the ships you can fly curently in game (your lacking the new trsnport ships and mabe some faction ships.) it says i can't fly them and i checked threw my skill on the sheet.
|
Fjellu
|
Posted - 2005.02.09 11:01:00 -
[397]
Same with Cerberus for me
|
UK Glum
|
Posted - 2005.02.09 12:41:00 -
[398]
seem to have another bit of a problem. of you have more than one excel spreadhseet open then the ctrl-G tries to run against the other spreadsheet and fails with a subscript error
|
Vilserx
|
Posted - 2005.02.16 11:11:00 -
[399]
Hmm.
I enter my ID# into that cell, press Ctrl + G and get a Run-time Visual Basic Error 1004. Any ideas? (I haven't altered any other fields) and am doing this on the EVE-XML DATA sheet.
---------------------------
VSX EVE Design |
Gangonn
|
Posted - 2005.02.16 15:49:00 -
[400]
I've noticed that you get an error if you have any other spreadsheets open. Close all other sheets and you don't get any errors. You may need to 'Get' the info twice before it works. I've learnt a lot from this sheet and am currently working on my own one now which is mainly presentation and looks :)
|
Torne
|
Posted - 2005.02.23 11:09:00 -
[401]
The autoupdate doesn't work for me no matter how many times I hit ctrl-g - I'm logged in fine in IE and there are no errors, it just doesn't update anything.. I don't have any other spreadsheets open or anything.. ideas?
|
Torne
|
Posted - 2005.02.23 11:25:00 -
[402]
Aha, got it working now; forgot to check 'save password' on the IE login box. The attributes don't update, but if you select cell J1 (with your character name in it) and drag down to copy that formula into J2-J6 (the attributes, stuck on 8) then it works perfectly ;)
|
Auren I'del
|
Posted - 2005.03.04 14:43:00 -
[403]
Edited by: Auren I''del on 04/03/2005 14:43:18
Hi there. I get the message "Run time error '1004'" when I push ctrl+g, and when i choose debug i get the following line marked:
Selection.QueryTable.Refresh BackgroundQuery:=False
in module 2 .
Any ideas?
|
Azadkiel
|
Posted - 2005.03.07 18:18:00 -
[404]
same here.
|
Fubar
|
Posted - 2005.03.08 15:47:00 -
[405]
Originally by: Auren I'del
Edited by: Auren I''del on 04/03/2005 14:43:18
Hi there. I get the message "Run time error '1004'" when I push ctrl+g, and when i choose debug i get the following line marked:
Selection.QueryTable.Refresh BackgroundQuery:=False
in module 2 .
Any ideas?
The autoupdate will only work in Excel XP and Excel 2003. Versions of Excel 2000 and below do not support xml web queries.
|
Farret
|
Posted - 2005.03.18 09:41:00 -
[406]
Edited by: Farret on 18/03/2005 10:11:31
Ok. I used this worksheet back before they took down the character sheet on web site.
OK Sorta got it working with reading more thru this and clicking the save password although with me running 2 accounts on same puter that's a bit of a prob. Minor. But it's pulling up the wrong character name when I have the right number in for the character on the account I want, and the attributes not working. I tried to copy the formula like the previous post said and I don't see a formula when I click in J1 area with is more then just one section there. More like J-L/1-2.
Input plz
|
UK Glum
|
Posted - 2005.03.18 11:04:00 -
[407]
on the "EVE-XML data" sheet in j1 you should see
=HLOOKUP(I1,$I$10:$IV$11,2,0)
repeat that for cells j2 thru j6
|
Devric
|
Posted - 2005.03.21 12:55:00 -
[408]
Edited by: Devric on 21/03/2005 13:22:49
Originally by: Dargon Starjammer
ow another glitch. i have the mineing barge skill at level 5 and can fly a large barge. yet in your ship section were you list all the ships you can fly curently in game (your lacking the new trsnport ships and mabe some faction ships.) it says i can't fly them and i checked threw my skill on the sheet.
Change the content of the cells D125-D127 on the "Ships" tab by decreasing the number of "X" by 4 in each cell. IE cell D125 goes from =IF(BZ125="XXXXXXXXXXXXXX";"YES";"NO") to =IF(BZ125="XXXXXXXXXX";"YES";"NO")
And by the way: I found a missing skill: Starbase Tactical Officer in the Corporation Management group.
Primary attribute: Memory
Secondary attribute: Charisma
Training time multiplier: X5
Required skills: Corporation Management level 2 (Primary) and Leadership level 4 (Secondary)
__________________________________________________________
Knowledge is when you don't know what you don't know. |
Dargon Starjammer
|
Posted - 2005.03.21 19:28:00 -
[409]
he also doesn't have the transport ship skill for the t2 industrials in it as well. infact ihaven't seen him make a post in a long time.
|
Histracko
|
Posted - 2005.03.23 15:36:00 -
[410]
hey all, i am the author of the ore calc sheets. just letting you know that lachenlaud hasn't died and there is a new version of the EMD in his possession that is being tweaked, it will be posted as soon as its done. some changes should inclued the new skills for T2 industrials, and a reverse calculation sheet for ore and ice yields(i.e. you enter ammout of min you need and the sheet spits out ammt of ore needed to get that yield.
---------------------------
!!Bookmarking Master!!
If you need a route or system bookmarked just EVE-mail or convo me and we'll work something out |
Dargon Starjammer
|
Posted - 2005.04.06 22:33:00 -
[411]
Edited by: Dargon Starjammer on 06/04/2005 22:34:49
i'm guessing he is going to release it after the enxt patch is released?
|
Auren I'del
|
Posted - 2005.04.21 08:53:00 -
[412]
Will this sheet be updated with the new skills and ships?
Have made my own adjustments but not sure if they are totaly correct ;)
Anyway....thanks for a great "prog"!
|
chefron
|
Posted - 2005.04.24 11:17:00 -
[413]
i gotta say it, this is a very useful tool indeed, grats to all those involved with the production of this tool and thanks in advance for all future productions
***Any comments made here are of a personel nature unless stated*** |
Grayson Burrows
|
Posted - 2005.04.29 13:56:00 -
[414]
Lach is alive, patience. 
|
Lachenlaud
|
Posted - 2005.05.12 02:21:00 -
[415]
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!! |
BillyBong2
|
Posted - 2005.05.14 16:58:00 -
[416]
Awesome, glad to hear Lachenlaud!
|
Hellspawn01
|
Posted - 2005.05.24 16:50:00 -
[417]
In an earlier version, there was a tab stating how much SP needed for next skill lvl. Its gone with the latest version. Any chance to bring it back in?
---------------------------------------------
Eve is not game, it¦s a way of life! |
MrBadidea
|
Posted - 2005.05.26 02:04:00 -
[418]
Has anybody else noticed the automatic update feature ceace functionality?
|
Lachenlaud
|
Posted - 2005.05.27 04:42:00 -
[419]
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 -
[420]
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!! |
| |
|
| Pages: 1 2 3 4 5 6 7 8 9 10 11 12 13 [14] 15 .. 15 :: one page |
| First page | Previous page | Next page | Last page |