crazyivan

Found it. Thank you very much.

To anyone else who missed this, the option in OO3 is in Format->Sheet->Show...

 

Snus

It is worth noting that our druid friends have found that the meta does not actually perform how its tooltip indicates.
http://elitistjerks.com/1084228-post113.html

 

illusive_2008

Simple request to put the sorting macro back in the excel version. If it's not to much to ask, if it is I will just get use to openoffice version, no worrys.

 

kahalm

The maker of this great spreadsheet stated, that he only uses excel at work and therefore has not the time to do so (and more people should use open office thanks for that, have to start my laptop every time I want to use the fury spreadsheet)

Some questions from my side:

*Would it be possible to include some dps trinkets which are fabulous for tps (thinking especially of Grims Troll)
*Would it be possible to include Gems/Metagems to the sort-tab
*Would it be possible to include the offwarrior hands (t7.5) into the spreadsheet due to their high stamina, expertise and hit value

 

Asarra

The Icebane set is missing from the spreadsheet. These are awesome items even without the frost resistance (though they lack defense).

[Icebane Chestguard]
[Icebane Girdle]
[Icebane Treads]

 

Taliafears

I lied, THIS is the last release before 3.1 changes:

- added Malygos25 to boss profiles
- adjusted Tauren health calculation to 5% of 8121 instead of 5% of 7941
- added a calculation for the AEP value of the -2% spell damage meta gem
- implemented the magic reduction of Imp. Def. Stance, Imp. Spell Reflect, and Effulgent Gem, updated boss profiles to equalize
- fixed a bug with damage shield and made it a standard physical attack, which evened out to about the same DPS
- apparently damage shield can proc deep wounds, added that
- added Grim Toll
- added the frost set
- added dps valorous gloves, for a threat set
- added averaged trinket effects to the stat ranking calculations (new sheet: Trinkets)

 

Kampfschaf

Deleted as poster below me proved me wrong.

 

Backgoode

Critical block doesn't cause damage without damage shield, so it's not possible for it to proc deep wounds. You can test damage shield causing deep wounds by letting a mob hit you in the butt until it crits.

 

Marathon

Question about using the spreadsheet:

What would I modify from the default settings if I wanted to emphasize:

• threat (a little)?
• threat (a lot)?
• light hits, such as AoE tanking?
• moderate hits, such as holding adds during a boss?

Also, what do each of the boss profiles emphasize? How do I know if the Patchwerk profile thinks mitigation is important or thinks threat is important, or some combination of the two?

 

Taliafears

Weights for threat/mitigation/etc are on each boss profile. You'll have to unhide the Bosses sheet.

 

Lipper

Well first of all, thank you for making the spreadsheet as its very detailed and well put together in general.
Only thing I saw missing from the entire list was Mark of Norgannon. I'm not sure if that was intended, as it is only used for inverse mitigation and threat, but I just thought that I'd throw that out there.

Thanks again for the spreadsheet.

 

Infuria

I'd also like to thank you for doing this. It has become my Bible of Tanking-Gear gemming, planning, and understanding. Do you expect to have an updated sheet shortly after the release of 3.1? (This is sheer curiosity, and by no means am I saying, "Where is 3.1 already!?")

 

Kurianna

I have excel and have been using that version of your spreadsheet, but would like to use the macro'ed version. I downloaded OO3, but can't for the life of me figure out how to open your sheet. The file downloaded from here has nothing in it that I can open (that I can find anyway).

Can anyone give just a brief explaination on how to open the spreadsheet in Open Office?

Thank you.

 

Abso

We picked up [Formula: Enchant Weapon - Blade Ward] so I figured I'd test it out. As a new enchant in 3.1 and having not seen this discussed anywhere else, I decided to post it here. My question from this was really "how good is 200 parry rating that is up 10% of the time?" and how does it compare to Mongoose for an avoidance set.

WWS

Hits: 1229
Crit: 44
Glance: 323
Total Hits: 1596

Procs: 23
Procs resulting in a stack of 2 or more: 3
Estimated proc rate 1.5%
No ICD as evident by parses below.

35 minutes of white swings 3'38'' uptime on Blade Warding or roughly 10% uptime.

Each stack procs 200 parry rating and a 600-800 damage return on next parry per stack.

Sample from a WWS Parse on Yogg-Saron:

4:41'27.062 Abso gains Blade Warding. #828944
4:41'32.268 Abso gains Blade Warding (2). #829306
4:41'34.862 Abso gains Blade Warding (3). #829542
4:41'36.699 Abso Blade Warding was removed from Abso. #829866
4:41'37.109 Abso Blade Warding hits Guardian of Yogg-Saron #182 for 3686 Physical.

The three stack is a 600 parry rating buff and 1800-2400 damage on next parry. The high damage seen here was due to the guardian buffs.

The gear I was testing tonight had 118 parry rating on it, bringing me to 17.06% parry (including DR). Using Whitetooth's numbers, it takes 49.18499 parry rating = 1% parry chance, before diminishing returns.

Ignoring diminishing returns, it would look like:
0 stack: 17.06% parry
1 stack: 21.126% parry (gain 4.066)
2 stack: 25.193% parry (gain 4.066, net 8.132)
3 stack: 29.259% parry (gain 4.066, net 12.198)
4 stack: 33.325% parry (gain 4.066, net 16.264)
5 stack: 37.391% parry (gain 4.066, net 20.33)

Obviously, this would be far too high and we know it won't work like this.

After diminishing returns, it looks like this:
0 stack: 17.06% parry
1 stack: 19.83% parry (gain 2.77)
2 stack: 22.24% parry (gain 2.41, net 5.18)
3 stack: 24.34% parry (gain 2.1, net 7.28)
4 stack: 26.21% parry (gain 1.87, net 9.15)
5 stack: 27.87% parry (gain 1.66, net 10.81)

So far, the proc rate seems alright and the uptime is decent enough. The interesting thing with this enchant is that with seemingly no PPM, it scales well with haste. I'd be curious to compare uptime with Windfury or Improved Icy Talons.

Team Ice US-Illidan
www.teamice.org

 

Jayde

Presuming it's a 1.5% chance, Prot Warriors generally have around 1.2s attack speeds in raids with haste, in addition to using every GCD. That results in roughly (oddly enough) 1.5 attacks per second. That should equal 1 proc every 44.4 seconds or so, or 22.5% uptime.

With 6.66 attacks per 10 seconds, on average, there would seem to be roughly a 10% chance to stack the buff while it is still up. So, the average chance of it stacking to 5 is pretty low.

Unless I'm doing some math wrong (which could easily happen, mostly quick calculator work here!) the average buff from this would be something around 50 parry rating.

Mongoose is, on average, around 63 Agility for me (+- a bit) which is around 0.53% dodge @ ~30% dodge.

A lot of the value will depend on DR targets and such, so I don't think there's a surefire answer. In many gear setups the parry rating may be slightly higher avoidance (perhaps in the 0.6-0.7% range).

Either way, I'd guess the impact is a bit marginal. Mongoose is possibly better due to its higher reliability--however Blade Warding would offer a much bigger impact when it was active due to the fact that it will be up about half as much as Mongoose yet still has a similar or greater average effect.

Hard to say, really.

 

janaka

What bugs me about this enchant is, that it actually counteracts the parry-haste mechanics. You want to attack as fast as possible to get the maximum effect, thus the boss gets more parry-haste, which works against your avoidance. That's kinda... stupid.
On the other hand... are there even tank-threatening bosses in Ulduar that parry-haste?

To add something on-topic: Any chance we get a new version of the sheet anytime soon, Tal?

 

Glory

Found a Bug with Agility,

i set the Boss DPS at 50k and then agility showed up as best Tanking Stat, i looked through the sheet because it was to much to be true.

In the Stats Sheet

Cell F14: =WENN($Bosses.$G$30;1;(1-0.24*$Bosses.$C30*F48*(2/3+1/F58)))*$Bosses.$C30

Should be: =WENN($Bosses.$G$30;1;(1-0.24*$Bosses.$C30*E48*(2/3+1/E58)))*$Bosses.$C30

There are other Cells not refering to the right place in the Adj speed section but without wrong output.
The F coulumn is for Expertise Threat Stats and Agility Tanking Stats which causes the fault. For Expertise as Tanking Stat it is refered correctly.

 

Taliafears

It's been so long since I had a chance to mess with this that I don't even know what I intended to do next. I'll go ahead and release it for now since it's got most of the 3.1 gear added, if not all.

- starting changes for 3.1
- added emblem of conquest belt, legs, and neck
- added Runed Orb blacksmith belt and boots
- adjusted boss armor values to 10645 per testing posted in Combat Ratings thread
- adjusted sunder to 20% armor piercing and faerie fire to 5%, made them multiplicative with each other and ArP, for now
- repaired some formulas related to buffed stat totals
- adjusted defensive stance damage modifier to -5% (was -10%)
- adjusted stamina (up) on Wall of Terror (shield), Inexorable Sabatons (boots), and Fleshless Girdle (belt)
- added all the new 3.1 gear I could find
- adjusted ArP rating so that ArP is 25% better
- purged remaining Burning Crusade items and a few greens to tighten the lists
- added Blood Draining and Blade Ward weapon enchants, but for now they just have intuitive AEP values (not theorycrafted)
- adjusted flask of stoneblood to 1300 hp

 

Infuria

Thank you very much for updating it! It is a tremendous tool for deciding on gemming/enchanting & future upgrades.

I'd like to point out, though, that the glyph of Shield Wall is not included in the udpated version. (For that matter, the t7 4-set bonus is non-existant if I'm not mistaken.) Also, you have 5 levels of spell reflect available. (should be 2)

 

Fellwraith

I came across a minor issue with the spiked deathdealer's stats in the spreadsheet, I think you may have confused them with the greave of the iron army off hardmode mimiron 10.

 

ZorbaTHut

Ran into a few bugs in the spreadsheet.

* Reticulated Armor Glove eng enchant is missing (800 armor)
* On the Gems worksheet, "Special" (L2) points at "Crit" on the gearlist worksheet. I assume it should be hardcoded as 1 instead? Note that these spots only show integer numbers, so it shows as 1 when (on my sheet) it ends up being about 0.52.
* This one's kind of complicated and arguably not a bug I was confused by behavior which caused my overall gear EAC to drop hugely when upgrading my equipment. I eventually tracked it down to a bit of gear I'd misentered, making it think that my defense was 539. As a result, the value of defense was *enormous*, and all of my equipment was being hugely overvalued thanks to the amount of defense on them. Once I switched to the upgrade, my defense increased to 541, the value of defense plummeted, all my gear score plummeted at the same time, and, confusingly, my EAC dropped from ~90k to ~60k.

I'm not really sure what the fix for that latter one is, or even if it should be fixed, but maybe it could highlight the defense column in red if defense is under cap? At least that'd make errors of this form easier to recognize.

 

todemax

If you're somehow below the defense cap with your equipped gear, you can just enable a defense potion and copy the value from I2 over to I3 in Gearlist, and then disable the potion. You can then multiply I3 by some factor until you reach statweighings where the optimal gear for you makes you defense capped.

 

ZorbaTHut

Yeah, I managed to figure out what the problem was and fix it - remember, the problem ended up being "I'd chosen the wrong equipment" - I'm just saying that it'd be better if the problem didn't exist in the first place, or if it was better at telling you "hey this is a problem you should fix this ASAP".

Another fix I came up with is that maybe it should just assume the player cannot be crit at any point - i.e. assume infinite resillience - and, again, highlight defense in giant red flashing numbers in the off chance that that's not the case.

Really, the overall objection is "making your equipment worse should not, in any situation, result in a 50% increase in EAC".

 

iamgrimm

[Ironbark Faceguard] is currently in the spreadsheet as 68 DEF instead of the 62 that is actually on it.

 

Thorgrim

One little error found: the Stalwart Monarch Topaz is listed incorrectly in the sheet as +8 dodge rating/+8 expertise rating; the actual gem is +8 dodge rating/+8 defense rating.