| 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) |
AtoningUnifex
   |
Posted - 2004.10.01 09:04:00 -
[301]
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.
------------------------
Collector and flyer of starships
|
AtoningUnifex
|
Posted - 2004.10.01 09:04:00 -
[302]
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.
------------------------
Collector and flyer of starships
|
Lachenlaud
|
Posted - 2004.10.01 12:53:00 -
[303]
 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 -
[304]
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!! |
Hardin
|
Posted - 2004.10.01 15:54:00 -
[305]
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.
Yep same problem...
|
Hardin
|
Posted - 2004.10.01 15:54:00 -
[306]
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.
Yep same problem...
|
Major Glitch
|
Posted - 2004.10.01 17:33:00 -
[307]
using winxp and office 2002, I follow the instructions exactly as they are in the autoupdate.doc but nothing shows as updated. The auto updater, by my understanding, should be filling in every line of a fresh EMDv8 sheet, but instead it just refreshes itself and shows N/A on the name line and blanks everywhere else. Anyone else getting this problem?
Glitch
|
Major Glitch
|
Posted - 2004.10.01 17:33:00 -
[308]
using winxp and office 2002, I follow the instructions exactly as they are in the autoupdate.doc but nothing shows as updated. The auto updater, by my understanding, should be filling in every line of a fresh EMDv8 sheet, but instead it just refreshes itself and shows N/A on the name line and blanks everywhere else. Anyone else getting this problem?
Glitch
|
Vidur
|
Posted - 2004.10.01 21:33:00 -
[309]
Edited by: Vidur on 01/10/2004 21:34:53
Some minor error in the sheet
Two trade skills missing:
Visibility & Wholesale
Two skills miss spelt:
Scrap Metal Processing --> Scrapmetal Processing
Hemophrite Processing --> Hemorphite Processing
I also have problem with out update, doing the xml download manualy to a file
and then changing the macro to read it from disk, then it work part from the
skill currently traning.
|
Vidur
|
Posted - 2004.10.01 21:33:00 -
[310]
Edited by: Vidur on 01/10/2004 21:34:53
Some minor error in the sheet
Two trade skills missing:
Visibility & Wholesale
Two skills miss spelt:
Scrap Metal Processing --> Scrapmetal Processing
Hemophrite Processing --> Hemorphite Processing
I also have problem with out update, doing the xml download manualy to a file
and then changing the macro to read it from disk, then it work part from the
skill currently traning.
|
|
|
Qayos
|
Posted - 2004.10.02 03:44:00 -
[311]
Edited by: Qayos on 02/10/2004 03:51:43
Originally by: Neni
I try doing the update and I continue to get ### on all cells under "time to." Any idea what may be going on?
I get the same thing. Doesn't seem to work. Is this thing outdated now? Did they change teh XML format or something? I'm using WinXP Pro, OfficeXP, and followed the directions.
Also...
The ships are out of date? I don't know if the data is wrong or was changed, but I know at least the cargo capacities of the Wreath and Hoarder are incorrect. I assume this means there are likely other errors as well?
If the auto updater worked this thing would just be awesome... not sure if I trust the data on ships though, since the only time I've checked it it's been off by a good 30-60%.
Impressive work though... almost ;)
|
Qayos
|
Posted - 2004.10.02 03:44:00 -
[312]
Edited by: Qayos on 02/10/2004 03:51:43
Originally by: Neni
I try doing the update and I continue to get ### on all cells under "time to." Any idea what may be going on?
I get the same thing. Doesn't seem to work. Is this thing outdated now? Did they change teh XML format or something? I'm using WinXP Pro, OfficeXP, and followed the directions.
Also...
The ships are out of date? I don't know if the data is wrong or was changed, but I know at least the cargo capacities of the Wreath and Hoarder are incorrect. I assume this means there are likely other errors as well?
If the auto updater worked this thing would just be awesome... not sure if I trust the data on ships though, since the only time I've checked it it's been off by a good 30-60%.
Impressive work though... almost ;)
|
Nemar Tel'Narin
|
Posted - 2004.10.02 05:02:00 -
[313]
Edited by: Nemar Tel'Narin on 02/10/2004 05:05:50
GREAT WORK!!!! A+++++ work
Well I finally got the update to work but had to do the 2x update but from first page instead of xml page.
Was just thinking it was about time for another update and boom there it is. Thanks for all your hard work man. You deserve to get some money for all your trouble. Not from me but start accepting donations for all your trouble.
To all of you who complain about this thing try making your own and then complain.
|
Nemar Tel'Narin
|
Posted - 2004.10.02 05:02:00 -
[314]
Edited by: Nemar Tel'Narin on 02/10/2004 05:05:50
GREAT WORK!!!! A+++++ work
Well I finally got the update to work but had to do the 2x update but from first page instead of xml page.
Was just thinking it was about time for another update and boom there it is. Thanks for all your hard work man. You deserve to get some money for all your trouble. Not from me but start accepting donations for all your trouble.
To all of you who complain about this thing try making your own and then complain.
|
Plutu
|
Posted - 2004.10.02 14:42:00 -
[315]
Originally by: Vidur
Edited by: Vidur on 01/10/2004 21:34:53
I also have problem with out update, doing the xml download manualy to a file
and then changing the macro to read it from disk, then it work part from the
skill currently traning.
How do you change the makro to read it from disk.????
Would like to know since the autoupdate doesn't work for me either and I would hate to type everything in manually.
I get the run-time error 1004 aswell.
|
Plutu
|
Posted - 2004.10.02 14:42:00 -
[316]
Originally by: Vidur
Edited by: Vidur on 01/10/2004 21:34:53
I also have problem with out update, doing the xml download manualy to a file
and then changing the macro to read it from disk, then it work part from the
skill currently traning.
How do you change the makro to read it from disk.????
Would like to know since the autoupdate doesn't work for me either and I would hate to type everything in manually.
I get the run-time error 1004 aswell.
|
Vidur
|
Posted - 2004.10.02 23:10:00 -
[317]
Edited by: Vidur on 02/10/2004 23:12:35
Originally by: Plutu
Originally by: Vidur
Edited by: Vidur on 01/10/2004 21:34:53
I also have problem with out update, doing the xml download manualy to a file
and then changing the macro to read it from disk, then it work part from the
skill currently traning.
How do you change the makro to read it from disk.????
Would like to know since the autoupdate doesn't work for me either and I would hate to type everything in manually.
I get the run-time error 1004 aswell.
I open up the macro with Microsoft Script Editor. I then located the the line where myeve was accessed and replaced the url with a simple file name of the xml file. In the EVE-XML Data part of the macro
locate the string "myeve.eve-online.com" then edit that line to look like this:
<x:URLString HRef="xml2.xml"/>
Then access the character info, right click on the XML Data and save it to the same location as you
keep the excel sheet. Then Simply press ctrl-G to read the file.
One thing thats bugging still is that it cant read the skill currently traning, so you have to enter
that one manualy. After that you have done that all looks ok.
Hope this helps.
|
Vidur
|
Posted - 2004.10.02 23:10:00 -
[318]
Edited by: Vidur on 02/10/2004 23:12:35
Originally by: Plutu
Originally by: Vidur
Edited by: Vidur on 01/10/2004 21:34:53
I also have problem with out update, doing the xml download manualy to a file
and then changing the macro to read it from disk, then it work part from the
skill currently traning.
How do you change the makro to read it from disk.????
Would like to know since the autoupdate doesn't work for me either and I would hate to type everything in manually.
I get the run-time error 1004 aswell.
I open up the macro with Microsoft Script Editor. I then located the the line where myeve was accessed and replaced the url with a simple file name of the xml file. In the EVE-XML Data part of the macro
locate the string "myeve.eve-online.com" then edit that line to look like this:
<x:URLString HRef="xml2.xml"/>
Then access the character info, right click on the XML Data and save it to the same location as you
keep the excel sheet. Then Simply press ctrl-G to read the file.
One thing thats bugging still is that it cant read the skill currently traning, so you have to enter
that one manualy. After that you have done that all looks ok.
Hope this helps.
|
Shayla Sh'inlux
|
Posted - 2004.10.04 06:52:00 -
[319]
Hey there!
Great sheet, but I noticed 2 minor mistakes.
Presence doesn't have Empathy V as a requirement and Gallente Battleship can be learned without Space Ship Command IV, at least according to your sheet.
-------------------------------------------------------
"Do you really think that's air you're breathing?" |
Shayla Sh'inlux
|
Posted - 2004.10.04 06:52:00 -
[320]
Hey there!
Great sheet, but I noticed 2 minor mistakes.
Presence doesn't have Empathy V as a requirement and Gallente Battleship can be learned without Space Ship Command IV, at least according to your sheet.
-------------------------------------------------------
"Do you really think that's air you're breathing?" |
|
|
Trinsia
|
Posted - 2004.10.05 00:36:00 -
[321]
ok after loading my charetor i noticed there where alot of problems with the can learn yes/no in the column. i tracked it down to the skill descriptions page.
there are 7 hiden colums V,W,X,Y,Z,AA,AB.
here is a example of V65
=IF(VLOOKUP(F65,Skills!$A$13:$C$212,3,0)>='Skill Descriptions'!G51,1,0)
ok this line takes the name of the first skill needed as a prerec for this skill F65 looking this skill name up on the skills page getting you current skill lvl, then checks it to G51 and put a 1 flag if you meet the prereg in this skill. this is incorrect the line should read
=IF(VLOOKUP(F65,Skills!$A$13:$C$212,3,0)>='Skill Descriptions'!G65,1,0)
so that its reading the lvl needed for this first prereg skill from the same line not another skills prereg line.
so you have to fix all the V,W,X,Y,Z,AA,AB to have the same number as the line there on to read the right skill lvl needed.
example for line 65
V65 would be F65 and G65 for the numbers in the formula.
W65 would be H65 and I65 for the numbers in the formula.
X65 would be J65 and K65 for the numbers in the formula.
Y65 would be L65 and M65 for the numbers in the formula.
Z65 would be N65 and O65 for the numbers in the formula.
AA65 would be P65 and Q65 for the numbers in the formula.
AB65 would be R65 and S65 for the numbers in the formula.
this needs to be fixed on all the hiding lines 3 to 201, colum V to AB.
some notes to unhide the lines to work easyer push the uper left corner of the Skill Discriptions page then excel tree commands format-->column-->unhide
later to rehide them after you fix them ctrl select V to AB and excel tree command format-->column-->hide
hope this helps you all out. great sheet i realy like it.
|
Trinsia
|
Posted - 2004.10.05 00:36:00 -
[322]
ok after loading my charetor i noticed there where alot of problems with the can learn yes/no in the column. i tracked it down to the skill descriptions page.
there are 7 hiden colums V,W,X,Y,Z,AA,AB.
here is a example of V65
=IF(VLOOKUP(F65,Skills!$A$13:$C$212,3,0)>='Skill Descriptions'!G51,1,0)
ok this line takes the name of the first skill needed as a prerec for this skill F65 looking this skill name up on the skills page getting you current skill lvl, then checks it to G51 and put a 1 flag if you meet the prereg in this skill. this is incorrect the line should read
=IF(VLOOKUP(F65,Skills!$A$13:$C$212,3,0)>='Skill Descriptions'!G65,1,0)
so that its reading the lvl needed for this first prereg skill from the same line not another skills prereg line.
so you have to fix all the V,W,X,Y,Z,AA,AB to have the same number as the line there on to read the right skill lvl needed.
example for line 65
V65 would be F65 and G65 for the numbers in the formula.
W65 would be H65 and I65 for the numbers in the formula.
X65 would be J65 and K65 for the numbers in the formula.
Y65 would be L65 and M65 for the numbers in the formula.
Z65 would be N65 and O65 for the numbers in the formula.
AA65 would be P65 and Q65 for the numbers in the formula.
AB65 would be R65 and S65 for the numbers in the formula.
this needs to be fixed on all the hiding lines 3 to 201, colum V to AB.
some notes to unhide the lines to work easyer push the uper left corner of the Skill Discriptions page then excel tree commands format-->column-->unhide
later to rehide them after you fix them ctrl select V to AB and excel tree command format-->column-->hide
hope this helps you all out. great sheet i realy like it.
|
Ronif Saarin
|
Posted - 2004.10.13 13:18:00 -
[323]
Superb spreadsheet..
I made the changes suggested by Trinsea and it all works perfectly.
Thanks to you both 
---------------------
"When you look into the abyss, the abyss also looks into you" -Neitchze
|
Ronif Saarin
|
Posted - 2004.10.13 13:18:00 -
[324]
Superb spreadsheet..
I made the changes suggested by Trinsea and it all works perfectly.
Thanks to you both
---------------------
"When you look into the abyss, the abyss also looks into you" -Neitchze
|
Moadyb
|
Posted - 2004.10.14 08:37:00 -
[325]
Very nice sheet, but it keeps spitting out wrong numbers. Not sure if I am doing something wrong here or whether I missed out something obvious.
Simple example, Mem +18, Int +17, training Instant Recall from lvl 4 to lvl 5,
in-game timer shows me 5 days 10 hours
Eve skill sheet shows me 6 days 17 hours ?!
Sheet is complete empty 'cept for the attributions and having put current level of instant recall at 4.
Could someone enlighten me here how I can get eve skill sheet to correctly show 5 d, 10 hours (or a least a number close due to the rounding)?
|
Moadyb
|
Posted - 2004.10.14 08:37:00 -
[326]
Very nice sheet, but it keeps spitting out wrong numbers. Not sure if I am doing something wrong here or whether I missed out something obvious.
Simple example, Mem +18, Int +17, training Instant Recall from lvl 4 to lvl 5,
in-game timer shows me 5 days 10 hours
Eve skill sheet shows me 6 days 17 hours ?!
Sheet is complete empty 'cept for the attributions and having put current level of instant recall at 4.
Could someone enlighten me here how I can get eve skill sheet to correctly show 5 d, 10 hours (or a least a number close due to the rounding)?
|
Messar Emino
|
Posted - 2004.10.14 13:40:00 -
[327]
Originally by: Moadyb
Very nice sheet, but it keeps spitting out wrong numbers. Not sure if I am doing something wrong here or whether I missed out something obvious.
Simple example, Mem +18, Int +17, training Instant Recall from lvl 4 to lvl 5,
in-game timer shows me 5 days 10 hours
Eve skill sheet shows me 6 days 17 hours ?!
Sheet is complete empty 'cept for the attributions and having put current level of instant recall at 4.
Could someone enlighten me here how I can get eve skill sheet to correctly show 5 d, 10 hours (or a least a number close due to the rounding)?
Make sure your Learning skill is set correctly. Learning affects the training time for all skills, since it modifies all your attributes by a small percentage.
|
Messar Emino
|
Posted - 2004.10.14 13:40:00 -
[328]
Originally by: Moadyb
Very nice sheet, but it keeps spitting out wrong numbers. Not sure if I am doing something wrong here or whether I missed out something obvious.
Simple example, Mem +18, Int +17, training Instant Recall from lvl 4 to lvl 5,
in-game timer shows me 5 days 10 hours
Eve skill sheet shows me 6 days 17 hours ?!
Sheet is complete empty 'cept for the attributions and having put current level of instant recall at 4.
Could someone enlighten me here how I can get eve skill sheet to correctly show 5 d, 10 hours (or a least a number close due to the rounding)?
Make sure your Learning skill is set correctly. Learning affects the training time for all skills, since it modifies all your attributes by a small percentage.
|
Moadyb
|
Posted - 2004.10.15 19:21:00 -
[329]
attributes and also learning skill are correctly (well presumable correct) keyed in. I still get wrong numbers.
|
Moadyb
|
Posted - 2004.10.15 19:21:00 -
[330]
attributes and also learning skill are correctly (well presumable correct) keyed in. I still get wrong numbers.
|
|
|
|
|
| |
|
| 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 |