• You've discovered RedGuides 📕 an EverQuest multi-boxing community 🛡️🧙🗡️. We want you to play several EQ characters at once, come join us and say hello! 👋
  • IS THIS SITE UGLY? Click "RG3" at the very bottom-left of this page to change it. To dismiss this notice, click the X --->

Tip - Quick Look Gear Spreadsheet (1 Viewer)

Joined
Jul 24, 2019
RedCents
9,957¢
Just thought I'd share a spreadsheet (Toon Names removed) I use for keeping track of gear of 54 toons in a really quick manner. I can easily decide who needs what in a matter of seconds when looting a chest - conditional formatting changes colors of gear automatically.

I only worry about the HP of the item - because I realized after a while - Nothing else Matters. - Good name for a song!


1657524465798.png
 

Attachments

  • Quick Look Gear.xlsx
    31.8 KB · Views: 5
Joined
Sep 27, 2020
RedCents
3,870¢
I might be in trouble. My first thought was "Hmm, this would do nicely in a Google sheet". Primarily because sharing the link and allowing others to make copies would be easy. And then my mind went to "I wonder what it would take to write a Lua to maintain it?". Now I'm deep into research on just that.
 
Joined
Oct 26, 2020
RedCents
400¢
Just thought I'd share a spreadsheet (Toon Names removed) I use for keeping track of gear of 54 toons in a really quick manner. I can easily decide who needs what in a matter of seconds when looting a chest - conditional formatting changes colors of gear automatically.

I only worry about the HP of the item - because I realized after a while - Nothing else Matters. - Good name for a song!


View attachment 40777
Thanks for sharing. Have you thought about just coding based on class instead of all the eye straining yellow red?

EX: Tank Classes (Grey), Heal Classes (Pink...yea sense of humor!), CC (Teal...because sense of humor!), and DPS Caster & DPS Melee...

Just a thought...that way you can fill each bucket first. EX: Tanks get geared first, healers second, cc third, then dps...or whatever rule set you'd like to follow
 
Joined
Jul 24, 2019
RedCents
9,957¢
Have you thought about just coding based on class instead of all the eye straining yellow red?
Yeah - I tried Many Many different color combo's - but always came back to the Green - Yellow - Red Gradient fill that Excel has as its standard.

I can Filter by class very easily - and I find the Red - is an instant Shout - to upgrade those items.

Tanks are Solid - Priest classes - I have some clerics who desperately need to get some good charm's.
1657581909073.png

1657581947947.png

Here is a macro to get All your gear for all your toons written to a Gear.ini file. Save it as a .mac file and run it on ALL toons...


Gear Macro:
Sub Main
    /declare Tag string outer
    /if (${Param0.Length}) /varset Tag ${Param0}
    /echo Outputting gear and stats to Gear.ini [${Tag}Gear]


    
/ini "Gear.ini" "${Tag}Gear" "${Me}","${InvSlot[0].Item.HP}","${InvSlot[1].Item.HP}","${InvSlot[2].Item.HP}","${InvSlot[3].Item.HP}","${InvSlot[4].Item.HP}","${InvSlot[5].Item.HP}","${InvSlot[6].Item.HP}","${InvSlot[7].Item.HP}","${InvSlot[8].Item.HP}","${InvSlot[9].Item.HP}","${InvSlot[10].Item.HP}","${InvSlot[11].Item.HP}","${InvSlot[12].Item.HP}","${InvSlot[13].Item.HP}","${InvSlot[14].Item.HP}","${InvSlot[15].Item.HP}","${InvSlot[16].Item.HP}","${InvSlot[17].Item.HP}","${InvSlot[18].Item.HP}","${InvSlot[19].Item.HP}","${InvSlot[20].Item.HP}"
    
/return

Oh..Wait - you will still need to do your 2hander.
 

Addict

Well-known member
Joined
Aug 18, 2019
RedCents
556¢
I might be in trouble. My first thought was "Hmm, this would do nicely in a Google sheet". Primarily because sharing the link and allowing others to make copies would be easy. And then my mind went to "I wonder what it would take to write a Lua to maintain it?". Now I'm deep into research on just that.
A table that is shown in the UI for only group leader/raid leader/set specific toon. Have that toon who displays the the table to user create observers on other toons to observe their gear, or if that is too cumbersome then just query the gear every minute or a button that once pressed queries all toons for gear in raid/group. Initially doesn't sound like the hardest thing to implement.
 
Last edited:
Joined
Sep 27, 2020
RedCents
3,870¢
A table that is shown in the UI for only group leader/raid leader/set specific toon. Have that toon who displays the the table to user create observers on other toons to observe their gear, or if that is too cumbersome then just query the gear every minute or a button that once pressed queries all toons for gear in raid/group. Initially doesn't sound like the hardest thing to implement.

The in-game stuff isn't the issue I was thinking about. Updating the sheet based on that data is where the issue will be. Thankfully I've done other work with the Google API.
 

Addict

Well-known member
Joined
Aug 18, 2019
RedCents
556¢
The in-game stuff isn't the issue I was thinking about. Updating the sheet based on that data is where the issue will be. Thankfully I've done other work with the Google API.
Oh I think I misunderstood you then. I was thinking about having a table view written in Lua that would ingame show the gear and values for all toons and you could make decision based on that.
 
Joined
Sep 27, 2020
RedCents
3,870¢
Oh I think I misunderstood you then. I was thinking about having a table view written in Lua that would ingame show the gear and values for all toons and you could make decision based on that.

That would be simpler from a data storage perspective. Recreating all the spreadsheet logic wouldn't be terribly difficult either. But yeah, my mind went to meshing Lua with Google Sheets.
 

Users who are viewing this thread

Top