Rogue Gear Spreadsheet - Page 3

Anddacin · 05/20/07, 6:57 PM

Hmm, just a couple of questions:

1. Is there a way to see the values or a ranking of other gear once I have my gear laid out? (Ie: I have helm1 selected, can I see if helms2-5 would be positive or negative upgrades?).

2. Is there a cell that shows expected dps?

3. Do the values listed in the UI represent anything like an AEP, DPS, or are they just arbitrary comparison numbers?

Thanks

• Aldriana · 05/20/07, 7:42 PM

1) At the moment, the way to do this is to pull up the "armor" sheet and see which have higher scores and which have lower scores. We're working on UI improvements for this; we're currently a planning a "largest upgrades from instance X" table - i.e. a list of the largest upgrades available in Karazhan, or in Heroics, or in SSC - or whatever. In terms of differences within a particular slot - it would be straightforward to add a column to the armor sheet that would give the difference between a piece of equipment and your current gear - do people think this would be helpful?

2) Expected DPS is sort of buried in the sheet right now - if you look at the end of column B on the sword or dagger sheet (as appropriate), you will find a dps number. Since this was initially designed as a gear comparison tool rather than an explicit dps calculator, I didn't initially worry about making it particularly user-accessible. However, again, if it's a feature people think is helpful, it's not a hard feature to add to display that dps number in a more prominent location.

3) The offense values are in Effective AP. The defense values are in Effective Stamina. The total column is a weighted sum of the two (speficially, offense + .6 * defense).

And as a general update on progress: we're almost ready to release 0.4; we've been held up by some compatability issues between Excel and OpenOffice, but are getting close to a completed revision, which will include, among other things, the improved UI, full socketing support, the new test realm items, and an updated of Warp Spring Coil to reflect the recent change to it on test.

astearns · 05/20/07, 9:16 PM

On (1), my dream UI would add the current delta in ranking to the field for the name of the item. In the popup, you'd see:

Cowl of Defiance (+87.7)
Helm of the Claw (0.0)
Wastewalker Helm (-7.5)

and/or the cell ranges for the gear slots would either automatically sort based on the current totals or there would be a button to push to sort them (this way the popup would always show the upgrades above your current gear).

Anddacin · 05/20/07, 11:49 PM

Originally Posted by Aldriana

1) At the moment, the way to do this is to pull up the "armor" sheet and see which have higher scores and which have lower scores. We're working on UI improvements for this; we're currently a planning a "largest upgrades from instance X" table - i.e. a list of the largest upgrades available in Karazhan, or in Heroics, or in SSC - or whatever. In terms of differences within a particular slot - it would be straightforward to add a column to the armor sheet that would give the difference between a piece of equipment and your current gear - do people think this would be helpful?

2) Expected DPS is sort of buried in the sheet right now - if you look at the end of column B on the sword or dagger sheet (as appropriate), you will find a dps number. Since this was initially designed as a gear comparison tool rather than an explicit dps calculator, I didn't initially worry about making it particularly user-accessible. However, again, if it's a feature people think is helpful, it's not a hard feature to add to display that dps number in a more prominent location.

3) The offense values are in Effective AP. The defense values are in Effective Stamina. The total column is a weighted sum of the two (speficially, offense + .6 * defense).

And as a general update on progress: we're almost ready to release 0.4; we've been held up by some compatability issues between Excel and OpenOffice, but are getting close to a completed revision, which will include, among other things, the improved UI, full socketing support, the new test realm items, and an updated of Warp Spring Coil to reflect the recent change to it on test.

For #3, is there a user-editable cell for the weighting of defense? (Essentially going for a max dps feel).

• Aldriana · 05/21/07, 12:05 AM

If you want to go max dps, you can just look at straight offense. That said, changing the weighting is potentially a valuable feature; it doesn't exist right now, but it's on the list to be added somewhere down the line.

Cyn · 05/21/07, 1:01 AM

i'd like to suggest that the gladiator gear gets added, aswell as "Sun-Gilded Shouldercaps", they are better shoulders than some of the others listed in the spread sheet

tsigo · 05/21/07, 1:06 AM

This looks promising. I like that the gear selection is limited to the higher-end items and I don't have to go through a bunch of garbage I'd never wear.

I do notice it's missing a few gems (Bright Living Ruby, Bold Ornate Ruby, Jagged Talasite, notably). Is that just part of 0.3's socketing being non-functional? I'd also prefer that the gems show the stats rather than, or in addition to, the names. I always get the names mixed up

Small UI suggestion. The drop-down arrow on each piece of gear partially covers the rating next to it. If you're just going through each piece seeing how it changes the rating, it's a minor annoyance to click off the selection cell. Making the value cell a bit wider is probably enough of a fix.

• Aldriana · 05/21/07, 1:19 AM

Bright Living Ruby was put in but misnamed, because I'm dumb. Will be fixed in next release.

PvP gems I didn't put in because... I don't PvP, so I didn't think of it. Again, I'll add it.

General theory to gear selection is to take the best thing that can be gotten out of 5 mans, and anything better - theory being that any serious raider should be at that gear level. By that logic, I suppose Sun Gilded Shouldercaps - and maybe Warp Splinter's Thorn, and a few others - should work their way in. If you see any other notable omissions, let me know and I'll add them.

tsigo · 05/21/07, 1:51 AM

Sethekk Feather-Darts, sadly still one of the best Thrown weapons =/

• Aldriana · 05/21/07, 2:03 AM

Originally Posted by tsigo

Sethekk Feather-Darts, sadly still one of the best Thrown weapons =/

They score significantly below Felsteel Whisper Knives, which is why they weren't included.

Tosa · 05/21/07, 8:54 PM

Would Braided Eternium Chain be worth adding?

• Aldriana · 05/21/07, 9:53 PM

Version 0.4: http://www.savefile.com/files/741152

Changelog:
Overhauled UI
New test realm items added/updated
Warp Spring Coil updated for new proc rate
Fixed bug that was sometimes causing a miscomputation of weapon speed.

Many thanks to Darlal for the UI improvements.

Known Bugs:
*Some features have compatability problems with OpenOffice
*Optimal enchant calculation gets confused by multiple enchants of the same name (i.e. Mongoose on OH vs Mongoose on MH; Assault to Bracers vs Assault to Gloves, etc.)

Darlal · 05/21/07, 10:10 PM

As a note, the fix I will most likely be going with for the enchants is to enforce unique names. Mongoose will become Mongoose (MH) and Mongoose (OH).

FYI, there is also a very slight calculation error in the total values for weapons and armor (1-3 points, max). These will all be fixed in the next release.

Please keep your wish list coming and I'll keep adding features (within reason). Soon to come: personalized balances between offense and defensive stats and zone information/filters.

• Aldriana · 05/21/07, 10:40 PM

In the same spirit:

Coming from the formula side of things within the next couple of releases:
*A better model of Windfury
*Deathmantle 4/5 set bonus
*Ability to mix MH and OH weapon types.
*Dynamically adjusted dagger cycle
*Updates to new items/stats as more information about them is learned.

We're also looking into a way to warn people if they are above the hit cap with a given set of gear.

LiteSabre · 05/21/07, 10:45 PM

So Warp-Spring Coil is STILL sub-par compared to even the poison vial? *sadface*