(3.2.0.2) Tankadin Spreadsheet

Great. Been waiting for this.

Things are much easier with a spreadsheet of gear.

mandm413 wrote:

Florisia wrote:I actually use the Teldrassil Protector. I normally don't get a chance to run anything outside of heroics(taking care of an infant is taxing on my raiding life ). Definately a good idea to add it.

All in all, this is great. Lets me easily add up things without having to do it myself.

I am about a week away from having the Teldrassil Protector myself but you don't have any of the weapons from the ragemane quest which is the hammer I have right now. I see though that you have many older weapons than that listed. Also you don't have Dabri's or some of the other trinkets from BC that many of us that didn't run kara still use.


Great spread sheet thanks again.

i'm in the same boat. have hammer of quiet mourning and it's not in the spreadsheet

The New Ulduar enchants for weapons don't seem to be in there either, Blade Warding and Blood Draining.

Question: Is BlockCap on this accurate (amends dodge/etc levels to those against an 83) or is it only against same level enemies (100 percent)?

nice site. Will read up on a lot of this.

Corman wrote:Question: Is BlockCap on this accurate (amends dodge/etc levels to those against an 83) or is it only against same level enemies (100 percent)?

Correct versus selected enemy level.

If you choose, that your enemy is level 80, your shown stats are like the ingame player sheet.
If you choose, that your enemy is level 83, your stats are reduced by the proper amount.

Ty!

On a seperate note, the stats for Shiedwall of the Breaker will need to be updated, it leaves off the expertise...
Sadly, despite getting it last night, its actually worse nearly everything, my Heroes' Surrender outdoing it on both threat and dtps :/
Slight, nay microscopic, EH boost but not worth it, imo.

New version is available; see 1st post.

Is there any way that I can add the updated stats for Shiver to this even if it's manually?

You've encountered a nice error.

Yes, if you have some office skills, you can easily change the item by yourself. The sheet 'mainhand' is hidden. you have to make it visible. after that, you see all available weapons with their stats, including shiver.

I found it, and changed it, thanks for putting this together, it's a fantastic help

Small suggestion, would it be at all possible to add Agility to the stat comparison for avoidance?

Hey, this spreadsheet is wonderful, and i want to thank you for taking the time to put something like this together

One thing i was hoping you might add in your next update is the PvP shoulder enchant that quite a few tanks are using (+30 Stam +15 Resil). Ever since the diminishing returns on avoidance, I've switched over to prioritizing stamina, especially for hard modes, and i know this enchant is on my enchant list. Just need to check if they fit into my gear with respect to going under 540 defense and what my health would look like (was using WoW Sandbox, but it seems to be a tad innacurate).

much appreciated!
-JC

Nitra wrote:Small suggestion, would it be at all possible to add Agility to the stat comparison for avoidance?

I don't think, that I will add this in the near future. Time is a rare jewel at the moment and this feature would require some coding.

JohnnyC wrote:Hey, this spreadsheet is wonderful, and i want to thank you for taking the time to put something like this together

One thing i was hoping you might add in your next update is the PvP shoulder enchant that quite a few tanks are using (+30 Stam +15 Resil). Ever since the diminishing returns on avoidance, I've switched over to prioritizing stamina, especially for hard modes, and i know this enchant is on my enchant list. Just need to check if they fit into my gear with respect to going under 540 defense and what my health would look like (was using WoW Sandbox, but it seems to be a tad innacurate).

much appreciated!
-JC

That's a quick thing. Will add this, but do not expect a updated version too soon.

I noticed a tiny error in the Stats_Calc sheet that was giving me one more stamina than expected. For reference here is the character I was using to check this: http://www.wowarmory.com/character-shee ... &n=Forsyte

Now the spreadsheet gives me 1787 Stamina rather than the expected 1786. What I found is that the game rounds the stamina two separate times, once for base stamina and toughness and once for stamina from gear and buffs. When I take (base+toughness+gear)*1.08*1.06, I get 1787 like the spreadsheet gives. If, however, I use the formula [(base+toughness)*1.08*1.06]+[gear*1.08*1.06] (I am using the square brackets here to mean the greatest integer/floor function), I get 1786 as the armory and client show. I'm assuming that stamina from buffs will be added to the second half as they show as "green" in the client tooltips. Thus, I think the correct formula for Stats_Calc!B17 should be =FLOOR(SUM(C17,H17)*I17*J17*K17, 1)+FLOOR(SUM(D17:G17)*I17*J17*K17,1)

On another note, I also noticed that the human base health seems to be off by 20 at level 80 (24614-17680=6934 base health w/o stamina)