| Pages: 1 2 [3] 4 5 6 7 8 9 :: one page |
| Author |
Thread Statistics | Show CCP posts - 0 post(s) |
AnnaJoy
   |
Posted - 2006.01.09 16:35:00 -
[61]
 Originally by: Codeslave
unfortunately Im on a mac as my main rig. And you cant edit webqueries in excel on a mac. you have to edit the qry file directly. Any way to have a file selector or something for the xml file
I will see what i can do about this, sounds like a pain so we'll see if i can fix it up.
|
BillyBong2
|
Posted - 2006.01.09 16:40:00 -
[62]
I have tried a few of the fixes to put in the query. Everytime I do, they keep bringing the player page info, the Eve Online newsletter, and other links. It doens't seem to go past that.
Even if I am logged in here, the spreadsheet still pulls from the Player News Page. Any ideas? I have put just my number in the query, I have right-clicked and saved the data.....
Nothing. I do not mind putting the info in myself, but just would like to get the automatic setup.
Siggy by Esturary |
AnnaJoy
|
Posted - 2006.01.09 17:10:00 -
[63]
Originally by: BillyBong2
I have tried a few of the fixes to put in the query. Everytime I do, they keep bringing the player page info, the Eve Online newsletter, and other links. It doens't seem to go past that.
Even if I am logged in here, the spreadsheet still pulls from the Player News Page. Any ideas? I have put just my number in the query, I have right-clicked and saved the data.....
Nothing. I do not mind putting the info in myself, but just would like to get the automatic setup.
Ah, this would be because currently the "My Character" portion is broke again. It seems to go up and down with this latest patch, but thats why you aren't able to get to the info. Hopefully this will be fixed again soon
AJ
|
BillyBong2
|
Posted - 2006.01.09 17:24:00 -
[64]
Rock on Anna!
Aprreciate the work oyu have done with skill sheet. Really helps with the planning of my character.
Again, thanks!
Siggy by Esturary |
MajiiK
|
Posted - 2006.01.09 17:47:00 -
[65]
Just a small observtion (love the work alot btw, thanks!)
Japsite should give out zydrine If Im not misteken, but in the oreproduction and teh other chart its missing (on both)
Havent checked on rest of ore though, just that one Ive found so far
Kepp up the GREAT work =)
|
BillyBong2
|
Posted - 2006.01.09 18:25:00 -
[66]
Observation:
Transport Ships is listing the SECONDARY requirements as the primary requirements. So, with Industry 5 and industrial 3, it is saying can learn.
We know that you must have Industrial ship to 5 of your specific race. Just and FYI and i have everything manually in :)
Siggy by Esturary |
AnnaJoy
|
Posted - 2006.01.10 23:40:00 -
[67]
Ok guys, tomorrow i should have an update 13.21 that should include all the new stats of the frigate and destroyer class ships. Been working quite a while gathering all the data. so i hope its worth it. I'll continue to add ships and do releases in a reasonably manner. I will also be trying to gather info on faction ships as i have time but this will be after the normal ships are all done.
Thanks
AJ
|
Jim Way
|
Posted - 2006.01.11 21:55:00 -
[68]
Edited by: Jim Way on 11/01/2006 22:07:18
Edited by: Jim Way on 11/01/2006 21:57:59
Is there anything like an MS Word viewer (MS released one...) for MS Excel? Something that would maybe be easier than porting to Openoffice?
Here's what I was thinking of ;)
http://www.microsoft.com/downloads/details.aspx?FamilyID=c8378bf4-996c-4569-b547-75edbd03aaf0&displaylang=EN
Unfortunately, if you don't have the full version of Excel, you just get to look at the preloaded data :( Please continue porting to Openoffice
|
AnnaJoy
|
Posted - 2006.01.13 02:21:00 -
[69]
Posted a new version today that included Mining Foreman and Mining Director. Also i have almost all of the Amarr Frigats and Destroyers stats put in, and their skill requirements are all in. I know it looks like i deleted the others, but because the data was inacurate with the new patch, i have hidden them until i can get all their data in.
Please enjoy.
AJ
|
Thufur
|
Posted - 2006.01.15 15:29:00 -
[70]
I'm using Star Office 8 so i'm assuming it is similar to OO as I can't get the update to even attempt to perform. I loved Lach's version of this and I salute you for continuing his work. But I switched from Microsoft Office to Star and I would really like to use this again as I can't switch back.
|
Leeloominai D'Sabat
|
Posted - 2006.01.15 17:00:00 -
[71]
Something I have always noticed about this spreadsheet is that the requirements for 'Repair Drone Operation' have always been wrong. with the version 1320 I fixed it myself, b ut with version 1321 the cells are protected and I can't fix it myself.
For reference, the actual requirements for the skill 'Repair Drone Operation' are:
Drones lvl 5
Drone Durability lvl 1
|
AnnaJoy
|
Posted - 2006.01.15 17:17:00 -
[72]
I will look into Star Office vs Open Office but i believe the two are interchangable, espically in the area of Macros and the programming language of Basic.
If you wish to fix the information yourself, just go up to the tools and protection and unprotect. I did not put a password, i just made it so that someone didn't accidently modify the contents.
|
Gythar
|
Posted - 2006.01.17 22:22:00 -
[73]
G'Day Annajoy,
Just found the 13.21 version just as I was going to post here to point out a bug in 13.10. Fortunately, this bug does not exist in 13.21. 
Please keep up the good work, and I am looking forward to the OO.org friendly version.
Cheers,
Gythar
|
Mobius Timewalker
|
Posted - 2006.01.18 11:18:00 -
[74]
damm this prgram is good..just wish i could get it to work with OO :-p
Ah well time to dig out my old copy of excel then
|
MajiiK
|
Posted - 2006.01.18 15:01:00 -
[75]
Can anyone lemme know how to manually edit the ore minerals yield?
Been playing around with it a bit, but cant seem to get it all together.
|
BillyBong2
|
Posted - 2006.01.18 20:42:00 -
[76]
What exactly are you looking for?
You can change the isk amount at the bottom. Click in the refine amount column and type in HOW MUCH ore you have on hand. Then the spreadsheet will do the rest.
It will tell you how many refines you will get, the far left column will tell you how trit you will have after the refines. Far right hand column will tell you how much isk you will have based on your isk price in the bottom left cell.
Hope that helps.
Siggy by Esturary |
MajiiK
|
Posted - 2006.01.19 15:07:00 -
[77]
Originally by: BillyBong2
What exactly are you looking for?
You can change the isk amount at the bottom. Click in the refine amount column and type in HOW MUCH ore you have on hand. Then the spreadsheet will do the rest.
It will tell you how many refines you will get, the far left column will tell you how trit you will have after the refines. Far right hand column will tell you how much isk you will have based on your isk price in the bottom left cell.
Hope that helps.
I ment to fix it so the ore displays proper yield of minerals. i.e jaspet not showing any zydrines.
We use it as a handy big scale mining op tool, and its a minor bug, but would be great to have it displaying all yields excact =)
|
AnnaJoy
|
Posted - 2006.01.20 02:43:00 -
[78]
School has kept me very busy the past few days, hince, no update. to address the ore question, i have updated those fields on the sheet i am currently working on. I was going to wait to post all the frigate/destroyer data before I put up the fixed one, but I can attempt to put it up tomorrow. Tomorrow, check My Eve Page for a link to 13.22, I'll then update this place when i return home from work. Sadly, i used to be able to get to the eve item database and now even that is locked out from where i work and i have yet to find a new loophole to allow me viewing access to it. until then i have to write the data down on paper, then go to work and have time to type it in.
In other important news, I found the information i was looking for in order to parse and place XML data into OpenOffice so as soon as i have some more time, i will be attempting to produce an OpenOffice variant of the updater.
Thanks for all the great comments and i hope to get these out to you.
AJ
P.S. If you want to try and attempt to modify the ore values yourself, you have to unhide the data between each of the ore columns, modify the formulas that draw off of the tables to the right of the large table, and then modify the data on the table on the right to produce the correct values in the visible yellow portions. All-in-all it took me 30 min to find and fix all the required data.
|
Gythar
|
Posted - 2006.01.20 11:01:00 -
[79]
G'Day Annajoy,
I have found some more corrections to be made in the spreadsheet.
The skills of Bartering & Black Market Trading have been removed from the game. I was looking at getting them and when the skills weren't listed in the market place...
Keep up the good work.
Thanks,
Gythar
|
Brad Stone
|
Posted - 2006.01.20 11:22:00 -
[80]
Dunno about batering but Black Market IS in the game - but you can only get it at character creation (not sure of the race/subrace/career choices) One of our corp members has it and she does all our drug running...
Originally by: Gythar
G'Day Annajoy,
I have found some more corrections to be made in the spreadsheet.
The skills of Bartering & Black Market Trading have been removed from the game. I was looking at getting them and when the skills weren't listed in the market place...
Keep up the good work.
Thanks,
Gythar
|
AnnaJoy
|
Posted - 2006.01.20 22:32:00 -
[81]
I hate excuses, but my work locked down my access to my webserver while at work. meaning i did not get to upload my file, I am uploading it and modifying the pages now, thanks and sorry...
AJ
|
Spiffae
|
Posted - 2006.01.21 02:51:00 -
[82]
Quick question - my learning skills - should they be adding points in the bonus line of my characteristics, or do i have to manually update the base? For now, though I have Analytical Mind 3 and Iron Will 3, my stats remain unchanged, which affects calculation time.
|
AnnaJoy
|
Posted - 2006.01.21 07:20:00 -
[83]
Originally by: Spiffae
Quick question - my learning skills - should they be adding points in the bonus line of my characteristics, or do i have to manually update the base? For now, though I have Analytical Mind 3 and Iron Will 3, my stats remain unchanged, which affects calculation time.
Yes, there are 3 spots in the list, 1 for base attributes, 1 for skills, and a third for implants. when you put the number of points in your learning skills, it will calculate the level and should put it in the second column, which will add to the base and produce a total. That total should be what you see in the attributes portion of your character sheet in game. if it isn't, adjust the base so that the total equals the in-game character sheet.
AJ
|
Gythar
|
Posted - 2006.01.22 04:19:00 -
[84]
Originally by: Brad Stone
Dunno about batering but Black Market IS in the game - but you can only get it at character creation (not sure of the race/subrace/career choices) One of our corp members has it and she does all our drug running...
Originally by: Gythar
G'Day Annajoy,
I have found some more corrections to be made in the spreadsheet.
The skills of Bartering & Black Market Trading have been removed from the game. I was looking at getting them and when the skills weren't listed in the market place...
Keep up the good work.
Thanks,
Gythar
G'Day Brad,
Thanks for the info about Black Market skill. Oh well, I'll just have to make do without then.
Cheers,
Gythar.
|
Jacyro
|
Posted - 2006.01.22 11:14:00 -
[85]
I am having a difficult time updating the sheet (ctrl-g) as well. It seems to work as far as getting teh data from the web, but then it asks me to choose where to put the info and click "enter" or to click "paste". Now, I have no idea what cell it is refering to, does anyone here? I have entered my character number enetered on the "eve-xml" tab. Do I need to enetr my base attributes first? I just don't see anything written in the instructions that say which cell on which tab to select to put the info in. I am also geting the news links added to the "eve-xml" tab as was stated earlier in this thread.
I would really appreciate some help with this.
Thank you 
-----------------------------------------------
"Eve is a sandbox.
Pick up a shovel and make yourself a castle."
-Vegeta |
Eru Aesir
|
Posted - 2006.01.22 14:14:00 -
[86]
Still getting "error 1004" any time I try to use this, any ideas?
|
Eewec Ourbyni
|
Posted - 2006.01.22 18:35:00 -
[87]
Edited by: Eewec Ourbyni on 22/01/2006 18:35:59
Hi, good to see someone take up the reigns. Btw, when it was updating I noticed that the ranges seem to be two cells short... for example when it's updating the current skill points column it stops at Tycoon... not sure why.
|
Jacyro
|
Posted - 2006.01.22 22:26:00 -
[88]
Originally by: Eewec Ourbyni
Edited by: Eewec Ourbyni on 22/01/2006 18:56:33
Hi, good to see someone take up the reigns. Btw, when it was updating I noticed that the ranges seem to be two cells short... for example when it's updating the current skill points column it stops at Tycoon... not sure why.
Also about the xml query thing... the following happens:
1) Put my char id in cell B2 of the Eve-XML Data sheet
2) hit ctrl+g
3) see sheets update but with the main eve homepage details (not very helpful)
4) go to the Eve-XML Data sheet
5) right click on the web link in cell I12
6) select "Edit Query"
7) In the address part of the bar the following is there:
"http://myeve.eve-online.com/character/xml.asp?characterID=["CHARID","Enter%20Eve%20Character%20ID"]&sid=<edited for someone's security>"
Anna, you might want to change the file you have up for DL'ing... it seems to have a someones char id in...
8) right now for the interesting bit, change that to "http://myeve.eve-online.com/", minus the quotes of course.
9) navigate to "My Character" etc and bring up the XML page, click the little yellow arrow so it becomes a green tick in the top left corner and then click "import" at the bottom of the window.
10) hit ctrl+g... everything should now update from the correct data.
Note: Once your at the right place to hit import the address looks something like:
http://myeve.eve-online.com/character/xml.asp?characterID=<my char id>
Don't know if you can simply replace <my char id> and get straight to that page... if someone who knows more about macro's could look at just what's going on and see if there is an easy way to change the sheet and macro so it gives the right address straight off perhaps.
The above was done from a totally fresh dl'ing of the beta version.
Thank you. That fixed my issue.
-----------------------------------------------
"Eve is a sandbox.
Pick up a shovel and make yourself a castle."
-Vegeta |
AnnaJoy
|
Posted - 2006.01.23 00:17:00 -
[89]
Ummm yeah, sorry about that, seems i forgot to update that when i added the mining foreman and mining director skills. I'll work to fix that tomorrow when i get to work. Thanks for pointing it out. sorry.
AJ
|
Gythar
|
Posted - 2006.01.26 11:45:00 -
[90]
Since this thread has gone a little quiet lately, I thought I would give it a helping hand.
Also, AJ, any news on the OO version of this magnificent utility?
Thanks,
Gythar
Happy "Customer"
|
| |
|
| Pages: 1 2 [3] 4 5 6 7 8 9 :: one page |
| First page | Previous page | Next page | Last page |