Remove Advertisements

(3.2.2.1) Tankadin Spreadsheet

Warning: Theorycraft inside.

Moderators: Fridmarr, Worldie, Aergis, theckhd

Re: (3.2.2.1) Tankadin Spreadsheet

Postby Rhî » Sat Nov 21, 2009 4:49 pm

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.
Image
Rhî
 
Posts: 305
Joined: Fri Sep 21, 2007 4:41 am

Fix for trinkets without useful "on use" proc

Postby AnrDaemon » Sat Nov 21, 2009 8:28 pm

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
 
Posts: 5
Joined: Sat Nov 21, 2009 8:17 pm

Re: (3.2.2.1) Tankadin Spreadsheet

Postby AnrDaemon » Sun Nov 22, 2009 12:37 am

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
 
Posts: 5
Joined: Sat Nov 21, 2009 8:17 pm

Re: (3.2.2.1) Tankadin Spreadsheet

Postby AnrDaemon » Sun Nov 22, 2009 9:46 am

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)
AnrDaemon
 
Posts: 5
Joined: Sat Nov 21, 2009 8:17 pm

Re: (3.2.2.1) Tankadin Spreadsheet

Postby Rhî » Mon Nov 23, 2009 2:53 pm

Great Input. Thank you very much!
Image
Rhî
 
Posts: 305
Joined: Fri Sep 21, 2007 4:41 am

Re: (3.2.2.1) Tankadin Spreadsheet

Postby AnrDaemon » Mon Nov 23, 2009 11:05 pm

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.
AnrDaemon
 
Posts: 5
Joined: Sat Nov 21, 2009 8:17 pm

Re: (3.2.2.1) Tankadin Spreadsheet

Postby Rhî » Tue Nov 24, 2009 6:16 am

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.
Image
Rhî
 
Posts: 305
Joined: Fri Sep 21, 2007 4:41 am

Re: (3.2.2.1) Tankadin Spreadsheet

Postby AnrDaemon » Tue Nov 24, 2009 4:39 pm

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

Postby duriek » Fri Dec 18, 2009 1:58 pm

Any ETA on when this wonderful spreadsheet will be updated with 3.3 data and such?
Image
User avatar
duriek
Maintankadonor
 
Posts: 77
Joined: Fri Sep 26, 2008 9:48 pm
Location: New Jersey

Re: (3.2.2.1) Tankadin Spreadsheet

Postby Rhî » Mon Dec 21, 2009 1:53 pm

Yes, not until first or second week of january.
Image
Rhî
 
Posts: 305
Joined: Fri Sep 21, 2007 4:41 am

Re: (3.2.2.1) Tankadin Spreadsheet

Postby gmf1 » Tue Dec 22, 2009 5:58 am

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.
Image
User avatar
gmf1
Maintankadonor
 
Posts: 381
Joined: Tue Jun 03, 2008 12:55 am
Location: Toowoomba, Queensland, Australia

Re: (3.2.2.1) Tankadin Spreadsheet

Postby wakebord99 » Thu Jan 07, 2010 7:26 am

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

Postby Rhî » Thu Jan 07, 2010 11:57 am

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).
Image
Rhî
 
Posts: 305
Joined: Fri Sep 21, 2007 4:41 am

Re: (3.2.2.1) Tankadin Spreadsheet

Postby Rhî » Sat Jan 09, 2010 3:09 pm

A new version is available. See 1st post.
Image
Rhî
 
Posts: 305
Joined: Fri Sep 21, 2007 4:41 am

Re: (3.2.2.1) Tankadin Spreadsheet

Postby Hightin-Uldaman » Tue Jan 12, 2010 12:52 pm

I can't seem to get this thing opened up in Excel. Any help would be greatly appreciated.
Hightin-Uldaman
 
Posts: 21
Joined: Tue Dec 22, 2009 4:22 pm

PreviousNext

Return to Advanced Theorycraft and Calculations

Who is online

Users browsing this forum: No registered users and 1 guest


Remove Advertisements

Who is online

In total there is 1 user online :: 0 registered, 0 hidden and 1 guest (based on users active over the past 5 minutes)
Most users ever online was 380 on Tue Oct 14, 2008 6:28 pm

Users browsing this forum: No registered users and 1 guest