EQ2U Adds Gear Reports for Characters, Guilds, and Alliances

Written by Feldon on . Posted in EQ2 Data & EQ2U

Imagine the ability to view a spreadsheet of your characters, your friends’ characters, your guild, or your guild alliance, all with their most valuable stats and gear scores (Stamina). Now imagine being able to sort this view by columns, add characters, hide certain guild ranks based on participation or perhaps if you have a main or alt raid force. Or imagine you’ve just joined a group and want to see what gear they’ve got, what upgrades they’ll be rolling for, or what areas you could help them improve on.

Today, EQ2U is happy to announce the introduction of the Gear Report!

We’ve heard from a number of guilds that hand-maintain such a spreadsheet, but there has been a growing desire to be able to automate such a view. Errrorr was the catalyst for this feature as he showed me a screenshot of the stats that their guild tracks for each character. Then I stumbled upon Soresha‘s EQ2 Data site where she has built quite a bit of this functionality for her guild. But we wanted to expand this idea outside of Guilds and allow any group of characters, even Guild Alliances, to build lists of characters and view their stats at a glance.

So how do you access this Gear Report feature?

A button has been added to Character Groups on the EQ2U home page (you must be an EQ2U member to use Character Groups):

You can also access a Gear Report for any Guild by going to their Guild Details page and clicking the Gear Report button:

Finally, you can access a Gear Report from your Character Detail page:

What do the colors mean?

At the bottom of each Gear Report is a blue information box which spells out in additional detail how the stats determine the background colors for the table grid. Different groups of characters and guilds will have different qualities of armor, jewelry, and equipment, so using the Gear Report settings, you are able to adjust the Stamina baseline as needed for your guild or characters.

By the way, I am open to feedback on the algorithms and calculations used to set the colors for fields such as Crit Chance, Crit Bonus, Potency, and Health.

What about Crafters and Soloers?

I really wanted to add a version of this page that reported on a number of Quests and other accomplishments, but there just isn’t enough of this data in the EQ2 Data Feeds to make such a view possible. I hope in the future when we get Quest data to have a whole other tab that shows which players have finished Drinal’s Steward’s quests, their Epic, Epic Repercussions, their Tradeskill Epic, The Coldain Prayer Shawl, etc. etc.

Trackback from your site.

Comments (50)

  • Filly67

    |

    Wow, you guys amaze me with the amount of work you do.

    Reply

  • Nyna

    |

    this looks really useful for players personally,
    and for guilds to easily spot people with crappy gear 🙂
    thanks

    Reply

  • Nyna

    |

    please add a :
    SORT by total STA points

    maybe also option to sort by INT, STR, AGI

    anyway, sorting by total STA of gear makes it easy to spot people with worst gear – and maybe help them upgrade.

    Reply

    • Feldon

      |

      I tried sorting by total stamina points but for some reason it went haywire. I will try something else to get it working.

      EQ2U actually has a full Settings ability which I have yet to use. One setting could be Guild minimum level on Gear Reports.

      Reply

  • Nyna

    |

    also the default guild report should be lv 95, not 90,
    so you dont have to reload it every time you go check…

    Reply

  • Nyna

    |

    nobody cares what people wear at lv 90 anyway.
    and it lowers server load.

    Reply

  • cmors

    |

    Thank you for such a wonderful tool.

    Reply

  • Loch

    |

    Amazing work!!

    Is there any way to pull up a gear report of all of my characters? I have them loaded into a group already, but can’t seem to find any other way than to add them all manually each time to compare them.

    Reply

  • Loch

    |

    Nevermind. Found it. That was stupid of me, it’s shown above.

    Reply

  • Errrorr

    |

    Feldon and Co have done a great job on this and it really has made my life so much easier already. A big Kudos to them for making it, and for all the time/effort involved!

    Reply

  • Liftik

    |

    Damn Feldon, you guys rock. When *was* the last time you got any sleep?

    Reply

  • Crazygnome

    |

    You guys are awesome! Thank you for all your hard work!

    Reply

  • Quabi

    |

    Holy crap, this is amazing.

    One suggestion: It’d be better to just sort CB/pot by whichever is higher, and then ideally say which that is in the tooltip (or whatever). Most Enchanters and Melee Priests prioritize CB over Potency.

    Reply

  • Mecrab

    |

    Great stuff, ya’ll rock!

    Mecrab

    Reply

  • Arzania

    |

    This is awesome! Thank you!

    Reply

  • Trepide@Storms

    |

    You guys are amazing!! Thx alot for this awesome work. I’ll be able to trash all pen-and-paper records of my alts.

    You rock!

    Reply

  • Twyxx

    |

    Very nice, guys!

    Reply

  • Coprsedancer

    |

    Can you include / exclude individuals in that that will overlap from rank excluding?
    if so please let me know how thanks.

    Reply

  • micc

    |

    lol all the wow players are ruining this game. the gear report is garbage and a bad idea plain and simple. it will counter act the idea of soe getting people to group more because a player has 300 gear score and you need 320 but yet the player for a casual player is pretty dam good at that class.

    Reply

    • Feldon

      |

      lol all the wow players are ruining this game. the gear report is garbage and a bad idea plain and simple. it will counter act the idea of soe getting people to group more because a player has 300 gear score and you need 320 but yet the player for a casual player is pretty dam good at that class.

      Since I’ve never played WoW, your comment is rather idiotic.

      Reply

  • Quabi

    |

    Another suggestion if I’m dreaming: Seeing the average (mean and median?) values for the entire group would be really cool.

    And as far as the pot/CB sorting: Instead of picking one, it might be better to just average the two values for each player. Some people try to balance those two stats while others heavily favor one over the other.

    Reply

  • Kaelric

    |

    great tool, thank you – it helps to quickly figure which toon needs which item worked on…

    one quick question – any hope that EQ2U will be able to display correct item stats for refined/experimented items? Or is that just not in the feed?

    Reply

  • LimeSplitpaw

    |

    Wow what a nice feture!
    I wish I could have my charecters marked as “my charecters” and being able to perma add them to the list I made for gear comparing, I see I can temporarily add them but have them in both places would still be nice.

    I’m hoping that in future I could pick and choose what to compare, I like to be able to compare my characters transmuting skill for example!

    In the gear reports list I would like to see item/rune names such as Stout or Dauntless Devotion as a quick source to what effect on gear me or others have as help to not get two effects that don’t stack by mistake. just names might not always help but it many cases it would be nice.

    Reply

  • Le Clown

    |

    I <3 YOU SHELDONATOR!

    Reply

  • Le Clown

    |

    feldonator*…too much Big Bang

    Reply

  • Valarnin

    |

    I would love to use this, but until it can take into account both experimenting and item effects that boost stats, it’s not that helpful. A fair amount of the best-in-slot gear is MC Fabled Experimented gear.

    Experiment stats are available on the data feed under the modifiers element.

    As for effects from items, I’m still tweaking it but I’ve been fairly successful using this PHP code: http://pastebin.com/ueYDjwEA

    Reply

    • Feldon

      |

      I would love to use this, but until it can take into account both experimenting and item effects that boost stats, it’s not that helpful. A fair amount of the best-in-slot gear is MC Fabled Experimented gear.
      Experiment stats are available on the data feed under the modifiers element.
      As for effects from items, I’m still tweaking it but I’ve been fairly successful using this PHP code: http://pastebin.com/ueYDjwEA

      Thanks for the feedback.

      We’ve been asking for experimentation and refining data since November.. I didn’t know the data was present now. We’ll certainly take a look at it.

      Reply

    • Feldon

      |

      Experiment stats are available on the data feed under the modifiers element.

      As for effects from items, I’m still tweaking it but I’ve been fairly successful using this PHP code: http://pastebin.com/ueYDjwEA

      Feldon, you should also check my post on the forums if you can’t see it with your default query:
      https://forums.station.sony.com/soe/index.php?threads/bug-with-c-resolve-and-equipmentslot_list-modifiers-on-experimented-gear.11500062101/

      I got the impression from your post that SOE had added clear data for reading Experimented and Refined data equipped on a Character. It looks like what you’ve got is rather circuitous (and requires 3 Regexes) and requires a double download of the character. I haven’t tested it, but wouldn’t your code give false positives on a character wearing Stamina or Agility adornments?

      I suppose we can look into handling these the way you’re suggesting, but to me, the data really should be clear and unambiguous, as the Reforged data is.

      Reply

  • Deannan

    |

    Wonderful additions.

    Feature Requests:

    1) Sort by for all columns (STA, etc).
    2) Sort by Gear Type (Fighter Plate, Fighter Leather, Healer Plate, Scout Chain, etc. This makes it easier to quickly scan through and see who needs what gear.).
    3) Ability to share the link to all watched characters, as well as, being able to import a watched set of characters into your own lists. (IE. I have my raid alliance all sorted on my login. Give me a link or something I can send to my raid alliance members so that they have access to the same information and can easily add the same list to their login. Would save time on adding all the characters over for each person.)

    Reply

    • Feldon

      |

      Feature Requests:

      1) Sort by for all columns (STA, etc).

      The reason I didn’t allow this is, I’d have to go back to separate columns for left and right Rings, Wrists, and Earrings. Also Weapons would never sort properly due to the possibility of two-handed weapons.

      2) Sort by Gear Type (Fighter Plate, Fighter Leather, Healer Plate, Scout Chain, etc. This makes it easier to quickly scan through and see who needs what gear.).

      Sounds like a good idea.

      3) Ability to share the link to all watched characters, as well as, being able to import a watched set of characters into your own lists. (IE. I have my raid alliance all sorted on my login. Give me a link or something I can send to my raid alliance members so that they have access to the same information and can easily add the same list to their login. Would save time on adding all the characters over for each person.)

      We can look into the possibility of sharing entire Character Groups.

      For the time being, Gear Report generates “portable” permanent URLs, so you should be able to copy the lengthy URL (with up to ~100 character names) and e-mail it to a friend or guildmate.

      Reply

  • Wanyen

    |

    I know I originally asked for/suggested a filter by last login if that data was available, and perhaps it is not.

    An alternative that might just as effective is a ‘last updated date’ on a per profile basis as a filter, so MIA/effectively inactive players who retain rank can be filtered out.

    Reply

    • Feldon

      |

      I’m going to look at adding the ability to exclude specific characters from a Guild report.
      And I know people want to be able to click an X and remove characters from a Character report.

      Reply

  • Valarnin

    |

    I got the impression from your post that SOE had added clear data for reading Experimented and Refined data equipped on a Character. It looks like what you’ve got is rather circuitous (and requires 3 Regexes) and requires a double download of the character. I haven’t tested it, but wouldn’t your code give false positives on a character wearing Stamina or Agility adornments?

    I suppose we can look into handling these the way you’re suggesting, but to me, the data really should be clear and unambiguous, as the Reforged data is.

    The PHP code I posted was to pull +stats from the effects of items, such as the WE x2 chest pieces that have a +50 to all stats in their effect that doesn’t show in their main stats ([eq2u]Breastplate of the All-Blocker[/eq2u]).

    The experimenting data IS available clearly in the data feeds, but only if you don’t c:resolve the modifiers field (that’s what the SOE forum post is for).

    Reply

    • Feldon

      |

      The experimenting data IS available clearly in the data feeds, but only if you don’t c:resolve the modifiers field (that’s what the SOE forum post is for).

      So, we can have EITHER Reforging data OR Refining/Experimentation data. 😉

      I’ll talk to Dedith on Monday and look at some options.

      Reply

  • micc

    |

    feldon you have always been a idiot !!

    Reply

  • Kinya

    |

    Great job Feldon. Thank you so much.

    @Micc best idea – stop visiting eq2wire pages

    Reply

    • Feldon

      |

      @Micc best idea – stop visiting eq2wire pages

      If you hate a site, why read it?

      Reply

  • Rotthan

    |

    Awesome Job Feldon. Thanks for all the work you do !!

    Reply

  • Valarnin

    |

    So, we can have EITHER Reforging data OR Refining/Experimentation data. 😉

    I’ll talk to Dedith on Monday and look at some options.

    The strange thing is, the boosts attribute is available from either data set, and tells you how many times a stat has been experimented. I’m doing the math on my end, as I posted in the SOE thread.

    Reply

  • Catharz

    |

    Awesome work guys. I’ve been considering implementing something similar in our loot system, but now I don’t have to. 🙂

    Reply

  • Necromancer

    |

    I know I have given you a ton of crap over the years Feldon, but you do an amazing job with both this site and EQ2U.

    Reply

  • Abyss

    |

    For ALL of your hard work and those that have contributed to this point, I salute you.

    Reply

  • pluto

    |

    Feldon,

    Dude you rock! Our guild has a forum just for crappy gear. It’s hard to track and rarely gets updated. You saved us a LOT of effort. Thank you!

    Reply

  • Feldon

    |

    Valarnin,

    Thank you for the kick in the butt on looking into Experimented. I did not realize that the “boosts” value was coming through reliably, and it looks like we don’t need to change anything in how we pull characters to support it.

    Unfortunately, Refined *stats* are coming through, but absolutely no indicator that a Refined rare was used or which stats are affected by Refining.

    I have verified that Aniathor is wearing a Refined, Experimented (5x) cloak, but nowhere does the data tell you the item is Refined. The stats are just higher by 10%. With 3 experiments + using a refined rare, the stat increases by 27.5%.

    I need to look at this before I just roll out support for Experimented items. And I don’t want to do crazy math on equipped items.

    Reply

  • Brauner

    |

    Adding “experimental” and “refined” stats will be great when it gets rolled out, but even as it is — Amazing work! Wow this is great! We can check on our various raid forces, and our own alts. To the whole EQ2U team -> Bravo! This is Brilliant!

    Reply

  • Ferrek

    |

    Love it! Now I do not have to sort out 40 something raiders in my guild to see who needs to replace what items, and get their booties adorned still!!!

    As a guild leader, you just cut my weekly worklaod in half, thanks!

    Reply

  • pluto

    |

    Feldon is there any way to add spells to the report? This is now the best recruitment tool we have access to. If a spell category could be created to identify crappy spells in the guild it will be of substantial help for purposes of quick reference.

    Reply

  • pluto

    |

    It really helps guild leadership track how well players are managing their raid mains. The adorn thing was a huge help, but a spell category will make this the best damn guild management out there for EQ2. You would help us enforce quality and attention to detail.

    Reply

  • Jamiria

    |

    As always, you did an awesome job !

    I have a small concern though : I’d like to create two groups for my guild : one for mains and one for raiding alts (we are quite casual and rely on many of those to compensante for low attendance of some mains) Then I’d like to display a gear report for this two groups on the same page, but in separate tables.

    Is that possible already, or do you plan to add such a feature ?

    Reply

Leave a comment

You must be logged in to post a comment.


Powered by Warp Theme Framework