Grimmlokk

Any plan to put maces in? Not really mace spec specifically(though it would be nice), but just the ability to at least equip them? For those poor rogues stuck with Fool's Banes etc until better drops.

 

Cel

Socket bonus seems to be broken for Gloves of Dexterous Manipulation:

"There is much pleasure to be gained from useless knowledge." - Bertrand Russell

Alpha is recruiting... go go.

 

Graecus

WW shoulders / WW chest socket also broken.
Edgewalker boots, when worn and regardless of socket, suggest Edgewalker boots as an upgrade.

Precision in Paradise

 

Darlal

The upgrade module (as it currently is) suggests the top 3 scoring items in that slot. If you already have one of them, it will still suggest it.

Also, the Socket Bonus? column is actually telling you if it is optimal to go after the socket bonus, not if you already have it (this should be made more clear on the sheet).

I'm more worried about the fel leather boots in the image above. I thought I'd quashed all the counting bugs where it showed the "optimal" as worse than the current, but I clearly missed one. I'll go try to hunt it down.

 

Ghond

thanks for that info. Its awesome to have a place to go to for intelligible answers.
keep up the good work.

 

Graecus

Sorry I wasn't specific enough. I have EW boots, and with the gems it suggests socketed, it STILL suggests the EW boots and shows a DPS upgrade.



edit: And thanks for clarifying the "Yes / No" in the socket bonus. I was under the impression that it was indeed telling me the socket bonus was met or not.

Precision in Paradise

 

Darlal

Ah! I will look into this. My gut feeling is that this is due to a known error causing "Total" value to be off slightly (1-3 points). Are you using "total" values in this case?

I was a bit unsure what text to put in that socketing column. The information there is meant to let the user know if they should be pursuing the socket bonuses or not (that seemed more useful than telling them if they were already getting them).

 

Graecus

Not quite sure what you meant by "using 'total' values".

I think that's appropriate right there. "Pursue Socket Bonus?" "Attempt socket bonus?" "Go for Socket Bonus?" or something of the like, though I know you're short on real estate there.

Precision in Paradise

 

Darlal

I would like to know what value weighting are you using. There are three options, offensive, defensive, and Total. I know there's a small error in the Total calculation (not to say that offensive and defensive are perfect). Just trying to get a bit more info on the bug.

 

Graecus

Ah sorry heh. Offensive.

Also, Assault to gloves is +26ap, not +24 as is listed.

Precision in Paradise

 

Darlal

Thanks for the info, I've caught the bug...it's actually the same bug Aldriana mentioned earlier with gem values. The entire gem module is a bit confusing at the moment and will be cleaned up in the next version (along with some nice new trinket modeling and other tricks).

 

• Aldriana

Known bug, fix already in the works:

 

Cel

Oh wow, I didn't realize that's what that column meant. Thanks. :]

I guess it would be difficult, but is there a way for the spreadsheet to know if your meta gem is active? The way it suggests I set up my gems would turn off my meta, so I can't go for the optimal setup. I try not to rely on sheets too much, anyway, but it's just something I noticed.

And the reason the optimal is being showed as negative is because it suggests I use Cat's Swiftness rather than Dexterity... if you assigned a value to the run speed higher than 6 agility's worth, then that would fix the problem, I think. It is difficult to come up with a value for runspeed as the whole purpose is sustained nonmobile dps. Perhaps just make it such that Cat's Swiftness isn't suggested?

"There is much pleasure to be gained from useless knowledge." - Bertrand Russell

Alpha is recruiting... go go.

 

Darlal

There is no value associated with the speed increase, and I don't think there are any plans to add one. The purpose of this sheet is to optimize gear for damage, not additional effects.

Meta gems: Currently the sheet does track which gems are active, but it does not use this information anyplace. The reason for this is that it gets really difficult to optimize gear with 3 rounds of iteration without switching to a database (see previous discussion).

For example:

here's what the statement is:
if Added RAP (relative attack power) from best metagem > RAP lost by replacing gems with other color gems -> resocket gear to activate the gems

what we do currently:

a) determine the RAP of current armor ungemmed
b) determine if it is better to socket the armor with all of the top gem, or to get the socket bonus
c) determine which metagems are active with this configuration
______________________________________________________

this is what we would need to do:

a) determine the RAP of current armor ungemmed
b) determine if it is better to socket the armor with all of the top gem, or to get the socket bonus
c) determine which metagems are active with this configuration
d) compare current total value with total value using the best metagem
i) figure out what gems need to be added to activate the best metagem
ii) figure out which gems provide the least RAP difference when replaced (this needs to include socket bonuses)

adding D requires a full gemming module, not a string of if->then logic. It's not impossible, but it's not in at the moment.

The easiest way to do this in excel that I can think of is to create a matrix of gemming options (alreaady parially done) for each armor piece.

Create a new matrix of all values and counts of gems for each color that would activate the optimal meta gem that includes socket bonuses (this is not easy and requires sorting options that basic excel doesn't seem to have).

Compare the sum of the individual maximums with the sum of the meta-active maximums.

Anyway, it's not impossible, but it's not something that will be done right away. Just use common sense and replace your weakest gems first.

 

• Aldriana

In that case, the fact that it recommends cat's swiftness to boots would seem to be a bug, yes?

 

Darlal

Yep. Sadly, I'm confirming that the bug. The "recommended" total should NEVER be less than the equipped value.

 

Anddacin

I'm impressed with the amount of work and the speed at which you few are dealing with this. Nice job

 

saw11719

One small gripe.

No PvP gems.

 

• Aldriana

We're getting to it - along with the heroic unique-equipped gems. Trick is, they're a little harder to deal with because they need to be options for equipping gear, but *not* in terms of calculating optimal socketing (since you can only have one). It's on the list of things to add, but they need to be handled a bit differently than the usual blue crafted gems which is why it's not there yet.

 

saw11719

Could you perhaps filter a cell check for said unique gems? If equipped then it wont show as an option? Or perhaps you could give the top three gem upgrades in a drop down. This would allow this gem to show as an upgrade, and provide the next best choices.

Just trying to help

 

Cragzop

What might work is a set of checkboxes for which zones etc are included for the gear upgrades.

That way pure PvE folks won't get their gear selections filled by PvP gear etc. It would also help eliminate slow pokes like me who are in Kara not seeing a list full of SS gear.

 

LiteSabre

Does the spreadsheet account for the hit cap? Because even though I'm currently capped at 308, the sheet still suggests Glinting Noble Topaz as better than Delicate Living Ruby for my red slots. Also, my gear's hit rating on the sheet comes out to 280, while I added it up in-game myself just to make sure and got 308. Are there any errors I should be aware of that might have caused the discrepancy?

 

Xizenta

This sheet wont stop counting the contribution of hit past the cap... I noticed aldrianna put an absolute value somewhere that would cause this.

 

• Aldriana

Yes, it currently pays no attention to the hit cap. When I was writing the initial version, it kept confusing the heck out me that the value of a piece of gear would suddenly drop by a third the instant you hit the hit cap, which isn't an accurate assessment of the situation at all; the value of that piece of gear is as high as ever, it's just that the combination of gear you happen to be using has a little too much +hit on it. So I specifically calculated the incremental value of hit in a way that ignores the hit cap entirely.

The problem with this solution, of course, is that it'll keep recommending high hit items even after you're hit capped, so specific upgrades off whatever gear you happen to be wearing might not actually be upgrades due to the hit mechanics. It's not clear to me if there's a better way of doing this in the end, since high hit items *are* good and *should* score highly - they just shouldn't be recommended as upgrades for people already at the hit cap. Unfortunately, I can't think of any good way of writing that into the spreadsheet.

As a short term solution, we're planning on adding a message warning you when you're over the hit cap, so at least you're aware that there's an issue.

 

koaschten

A simple Solution might be to have an item value calculated with and without hit cap. That way you could have a simple if-statement to make decisions on the upgrade item part once you hit the hit-cap. You even could add a column to the spreadsheet showing value with and without hit taken into consideration.

edit: Is there an "easy" way to add items? I tried adding a row, copying formulas and inserting stats etc. but items wouldnt show up in the dropdown