(3.2.2.1) Tankadin Spreadsheet
Moderators: Fridmarr, Worldie, Aergis, theckhd
Re: (3.2.2.1) Tankadin Spreadsheet
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.
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.
 Rhî
 Posts: 305
 Joined: Fri Sep 21, 2007 4:41 am
Fix for trinkets without useful "on use" proc
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".
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
 Posts: 5
 Joined: Sat Nov 21, 2009 8:17 pm
Re: (3.2.2.1) Tankadin Spreadsheet
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)
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
 Posts: 5
 Joined: Sat Nov 21, 2009 8:17 pm
Re: (3.2.2.1) Tankadin Spreadsheet
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((B14C14)/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 =PreDR 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)
Fixes as follows:
Stats_Calc.D99 =ROUNDDOWN(C14/IF($Stats.C8<80;24,9999779921467;59,89);2)%
Stats_Calc.E99 =ROUNDDOWN((B14C14)/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 =PreDR 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)
 AnrDaemon
 Posts: 5
 Joined: Sat Nov 21, 2009 8:17 pm
Re: (3.2.2.1) Tankadin Spreadsheet
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.
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.
 AnrDaemon
 Posts: 5
 Joined: Sat Nov 21, 2009 8:17 pm
Re: (3.2.2.1) Tankadin Spreadsheet
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.
 Rhî
 Posts: 305
 Joined: Fri Sep 21, 2007 4:41 am
Re: (3.2.2.1) Tankadin Spreadsheet
Rhî wrote: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.
 AnrDaemon
 Posts: 5
 Joined: Sat Nov 21, 2009 8:17 pm
Re: (3.2.2.1) Tankadin Spreadsheet
Any ETA on when this wonderful spreadsheet will be updated with 3.3 data and such?

duriek  Maintankadonor
 Posts: 77
 Joined: Fri Sep 26, 2008 9:48 pm
 Location: New Jersey
Re: (3.2.2.1) Tankadin Spreadsheet
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.

gmf1  Maintankadonor
 Posts: 381
 Joined: Tue Jun 03, 2008 12:55 am
 Location: Toowoomba, Queensland, Australia
Re: (3.2.2.1) Tankadin Spreadsheet
I can't wait to see the new updates. Thanks again for all your hard work!
 wakebord99
 Posts: 13
 Joined: Thu Jan 07, 2010 7:06 am
Re: (3.2.2.1) Tankadin Spreadsheet
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. ICCDebuff; Armor calculation).
 Rhî
 Posts: 305
 Joined: Fri Sep 21, 2007 4:41 am
Re: (3.2.2.1) Tankadin Spreadsheet
I can't seem to get this thing opened up in Excel. Any help would be greatly appreciated.
 HightinUldaman
 Posts: 21
 Joined: Tue Dec 22, 2009 4:22 pm
Return to Advanced Theorycraft and Calculations
Who is online
Users browsing this forum: No registered users and 1 guest