Announcement

**Sanna** · 05-02-2003, 12:13 PM

hoooooly piece of crap.
that is really really really cool.
that's the sort of thing I wish I could get to while IN game.

And DUDE! row 1 doesn't move, it sits still while the other rows scroll under it! how did you do that?

that is niftyness, dude.

**Inyidd** · 05-02-2003, 12:27 PM

Originally posted by Sanna

And DUDE! row 1 doesn't move, it sits still while the other rows scroll under it! how did you do that?

Click on the first field in the second row, click on Window, then Freeze Panes. I always have to find that one again because it's in such a weird place!

--Inyidd

**Tathagata** · 05-03-2003, 08:23 PM

Thanks, Im glad you like it.
As Inyidd has said, to freeze panes you just split the window then freeze panes.

I agree, wish I could access it without leaving the game, but since I know nothing of XML that wont be happening, hehe.

Just in case you are not sure how to sort, just click on any cell that has data in it, then select Data (from the file menu) and Sort. This will give you the option to sort on any colum either ascending or descending. Sorting this way will ensure the data doesnt get mixed up.

**Sanna** · 05-03-2003, 09:51 PM

i found the sort function by complete and total accident.

I assume when it has a skill of 0, that is completely unknown? ^_^ threw me for a sec when i first saw that.

uber niftiness. ^_^

**Tathagata** · 05-04-2003, 06:22 PM

Oh yes, sorry I forgot to mention that. Just to keep data in the field, if the Trivial value is unknown I have put a zero in. I intend to scour around and try to find values for those missing, but havent done so yet.

**Tathagata** · 05-06-2003, 02:23 AM

Just an update. Ive added it to the above link.

Ive managed to find many of the trivials that are not listed here on EQTraders, although I have made mention of the source so that you know to take them with a grain of salt.

Ive also zipped the file up to save download time, its only about 50kb now.

**Cavel** · 05-06-2003, 09:20 AM

As a fellow HIE smith I would like to say Thank you... Also have you considered running your monitor at a higher resolution and running in windows mode to keep both this spreadsheet and EQ up at the same time?

Example Set EQ resolution to 1024x768 and set monitor for 1240x1024 open spread sheet open eq and go into windows mode. Then based on the way you have the sheet set up you should be able to scroll the sheet to the appropriate area so the info is visible for you and you are still in EQ. If you plan on playing in windows mode and having another app open I would suggest 1gig of ram instead of the 512 that SOE needs for EQ.

**Meirril** · 05-06-2003, 07:19 PM

I suggest 1 gig of ram just to play EQ peroid. For what your talking about I'd suggest at least 2 gig of ram, maybe 3?

**Tathagata** · 05-06-2003, 10:17 PM

Nice idea, thank you Cavel.

Glad that someone besides me finds it useful too

Announcement

Possibly a useful tool

Possibly a useful tool

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Mistress Tinkbang Tankboom - Ak'Anon, Tarew Marr Gneehugging Chantaranga of the 66th Mez Break - AA:59	Assisted by Nakigoe Sennamida, Druidess of 65 Foraged Steamfont Springwaters - AA:8 Quartic, Darkie Wizzy of 52 Self-Snares - Best Crit: 1680.
[BK-210 // BR-250 // BS-203 // FL-200 // JC-240 // PT-200 // TL-200 ]---[ TK-179 // RS-182 // FS-165 ]-- Points: 1503/1750 -- Shawl: EIGHT and wearing it ^_^.

Mistress Tinkbang Tankboom - Ak'Anon, Tarew Marr Gneehugging Chantaranga of the 66th Mez Break - AA:59	Assisted by Nakigoe Sennamida, Druidess of 65 Foraged Steamfont Springwaters - AA:8 Quartic, Darkie Wizzy of 52 Self-Snares - Best Crit: 1680.
[BK-210 // BR-250 // BS-203 // FL-200 // JC-240 // PT-200 // TL-200 ]---[ TK-179 // RS-182 // FS-165 ]-- Points: 1503/1750 -- Shawl: EIGHT and wearing it ^_^.