(3.2.2.1) Tankadin Spreadsheet

[Rhî]

What happens, if I say "Yes, it's better"? And what happens, if I say "No, it's not as good as Rawr"?

In my humble opinion both are well coded. This spreadsheet's development is older than Rawr's Protecion paladin section. Rawr was a long time (in the beginning) really bad. That was long time ago.

[AnrDaemon]

Fix for trinkets without useful "on use" proc, like Ruby Hare:

Trinket_Calc.F6 =IF(ISNA(E19);0;E19)
Trinket_Calc.G6 =IF(ISNA(E33);0;E33)

Trinket_Calc.E16 =VLOOKUP(TRUE();$Trinket_Calc.F9:G18;2;0)
Trinket_Calc.E33 =VLOOKUP(TRUE();$Trinket_Calc.F23:G32;2;0)

P.S.
Before asking "which is better", please define "better".

[AnrDaemon]

Since when Draenei base AGI is 92? >.<
Draenei.B82 =152
Draenei.D82 =87
Draenei.F82 =142
Draenei.H82 =99
Draenei.J82 =107

Finger.G18 =48 (All stats for this item is wrong...)
Shoulder.G20 =59 (Again, all stats for this item is wrong...)

Items_Raw.AE13 =IF(AC13="Active";VLOOKUP($Items.C102;$Finger.$A3:$IV145;255;0);0) (Ahhhrrrr!!!! It was like puzzle, before I noticed the wrong first reference!)

Don't know about other ranks, but STA from Mining (Rank 6) is 60 points.

The true formula for Armor is quite bad. First, bonuses from talents and Austere meta applied multiplicatively. Second, it's not straight 1*2*3, armor from i.e. The Leviathan's Coil or Glyph of Indomitability not gets bonused at all. Thus, it need different treatment.

Items.D155 =SUM(D93:D127)
Items.D156 =SUM(D3:D91;D129:D154)
Stas_Calc.C26 =ROUND(($Items.D156*(1+$Talents.L12*0,02)*IF($Items.C7="Austere Earthsiege Diamond (+32 Stamina, +2% Armor Value from Items)";1,02;1));0)+$Items.D155
(And yes, Armor is rounded up for a fraction >= .5)

Stats_Calc.G99 =$Talents.L10% (It's not surprized me, Deflection and Anticipation 5/5 both is the standard tanking build, but for the sake of truth... L10)

[AnrDaemon]

Okay... Dodge calculation, despite the "3.2.2", is not yet "3.2".
Fixes as follows:

Stats_Calc.D99 =ROUNDDOWN(C14/IF($Stats.C8<80;24,9999779921467;59,89);2)%
Stats_Calc.E99 =ROUNDDOWN((B14-C14)/IF($Stats.C8<80;24,9999779921467;59,88);2)%
Stats_Calc.F99 =ROUNDDOWN(($Items.N156+IF(Stats.J20="Libram of Defiance";200;0))/VLOOKUP($Stats.C8;$'Combat Ratings'.$A4:$IV83;33;0);2)%
Stats_Calc.H99 =((C93-($Stats.C46*5))*0,04)%
Stats_Calc.I99 =ROUNDDOWN((D93+E93)*0,04;2)%
Stats_Calc.J98 =Pre-DR dodge from gear
Stats_Calc.J99 =E99+F99+I99
Stats_Calc.K98 =Diminished dodge
Stats_Calc.K99 =ROUNDDOWN(1/(0,011347+0,956/(J99*100));2)%
Stats_Calc.B99 =IF((SUM(D14:G14)*H14)=0; SUM(C99:I99); K99+C99+D99+G99+H99)

[Rhî]

Great Input. Thank you very much!

[AnrDaemon]

Be mindful, I didn't tested my changes extensively.
I just tried to get on paper the same values I see in game.
So far, they do match.

BTW, I quite not understand the comparison moment.
Checking with calculator, I have higher total avoidance and objectively higher HP.
But comparison showing me +HP, -Avoidance. Didn't digged formula.

Aaaa!!! One more moment. Could you please replace all "SUMME" with "SUM" in module? Or better, remove that module entirely and just put proper math in cells. It won't affect the calculation speed much, but will definitely save you a day. Especially - for armor calculations, which you can't just replace now and then.

[Rhî]

I do not understand what you mean with the comparison part, but "summe" has to be "summe", because of the localization version of Open Office. As far as I can see, english code is rejected for my german client. And the "module" (macro) is necessary for calculations.

[AnrDaemon]

I do not understand what you mean with the comparison part, but "summe" has to be "summe", because of the localization version of Open Office. As far as I can see, english code is rejected for my german client. And the "module" (macro) is necessary for calculations.

It does not work on my english OOo.
And i'm afraid if I install localized one, it will not work either...
Gonna think about solution, once I get to understanding of that sheet.

[duriek]

Any ETA on when this wonderful spreadsheet will be updated with 3.3 data and such?

[Rhî]

Yes, not until first or second week of january.

[gmf1]

Awesome Look forward to it, thank you again for making an invaluable recourse, trying to figure out gear without it or using rawr just isn't the same.

[wakebord99]

I can't wait to see the new updates. Thanks again for all your hard work!

[Rhî]

Probably this sunday. Won't expect much. I'm very short on time at the moment. I've tried to add every new item (probably overseen some or some with wrong stats) and mechanic changes (i.e. ICC-Debuff; Armor calculation).

[Rhî]

A new version is available. See 1st post.

[Hightin-Uldaman]

I can't seem to get this thing opened up in Excel. Any help would be greatly appreciated.