+ Reply to Thread
Results 1 to 20 of 20

Thread: Avoidance Calculation for Plate Wearers

  1. #1
    Join Date
    Jun 2009
    Location
    Alaska
    Posts
    367

    Avoidance Calculation for Plate Wearers

    You need to have gmail to test this. You insert your values on the first page the calc will pop out on the 2nd. It will incorporate buffs that you would see in a raid. I have also included a separate buffs with approx uptime of mongoose and bladeward to see what the overall avoidance gain would be. The bladeward only assumes one stack and does not account for procs.

    There is separate calculation pages for Deathknights, Warriors, and Paladins.

    Avoidance Spreadsheets

    Note:This is only for avoidance and does not assume Boss level

    EDIT: Thank you to Satrina for the base values.

    Updated: So you can enter your naked Dodge, Parry, and Miss. For Nightelfs add 2% miss to talents or base.

    Updated: Can now specify DK runeforging

    Updated: Has 3.2 Calculations as well.
    Last edited by Tarigar; 07-09-2009 at 10:25 AM.
    True Bonding Occurs when you wipe your raid and then your raid wipes you in return - Tarigar

  2. #2
    Join Date
    Apr 2008
    Posts
    1,399
    One problem right off the bat, set def, dodge and everything to Zero, set Agi to 73. Now we all should know for a warrior 73.529412 agi = 1% dodge and the calculator properly says 73 agi would give 0.9928 Dodge from Agility, but then it also calculates that .9928 % dodge would give 1.03% Dodge after Diminishing Returns. You know i havent studied much about DR... but to my knowledge DR should never increase your avoidance amount greater than the normal value.

  3. #3
    Join Date
    Jun 2009
    Location
    Alaska
    Posts
    367
    Quote Originally Posted by Lizana View Post
    One problem right off the bat, set def, dodge and everything to Zero, set Agi to 73. Now we all should know for a warrior 73.529412 agi = 1% dodge and the calculator properly says 73 agi would give 0.9928 Dodge from Agility, but then it also calculates that .9928 % dodge would give 1.03% Dodge after Diminishing Returns. You know i havent studied much about DR... but to my knowledge DR should never increase your avoidance amount greater than the normal value.
    You rounded

    And it is rounding as well. You should try adding real values.
    True Bonding Occurs when you wipe your raid and then your raid wipes you in return - Tarigar

  4. #4
    Join Date
    Apr 2008
    Posts
    1,399
    I rounded what? I am posting strait off your spreadsheet..

  5. #5
    Join Date
    Jun 2009
    Location
    Alaska
    Posts
    367
    If you go 73 and not 73.529412 then you rounded. And this was data pulled from Satrina's Dr thread the formulas match hers. But try inserting real values into the formula. Also you have to realize that the agi-dodge% is not accurate because it goes even further than the 6th decimal place. Anytime you cut off values it will throw off calculations .
    Last edited by Tarigar; 06-19-2009 at 09:00 PM.
    True Bonding Occurs when you wipe your raid and then your raid wipes you in return - Tarigar

  6. #6
    Join Date
    Apr 2008
    Posts
    1,399
    I am talking about the part where you have a person input their value, I input 73, and according to your sheet it gives 1.03% dodge after DR. I am not rounding, i am adding in a legit number of possible agi you could be adding. The dodge after DR value is incorrect in its calculation because it is saying .9928 % dodge becomes 1.03 when DR is calculated and this is false.

  7. #7
    Join Date
    Apr 2008
    Location
    Portland, OR, USA
    Posts
    191
    Tarigar, You really need to reread Lizana's post. You clearly stopped after you saw "73" and "73.529412 agi = 1% dodge".

    The concern noted isn't that 73 AGI showed .9928, as Lizana noted that .9928 is the correct value.

    The concern is that your Diminishing Returns calculation says that .9928 nominal is being converted to 1.03 after DR.

    Whether or not such a concern is even worth worrying about is a different issue.

  8. #8
    Join Date
    Jun 2009
    Location
    Alaska
    Posts
    367
    Quote Originally Posted by Lizana View Post
    I am talking about the part where you have a person input their value, I input 73, and according to your sheet it gives 1.03% dodge after DR. I am not rounding, i am adding in a legit number of possible agi you could be adding. The dodge after DR value is incorrect in its calculation because it is saying .9928 % dodge becomes 1.03 when DR is calculated and this is false.
    The calculation is correct unless someone elses math is wrong. This is also not intended to calculate what 1% dodge in comparison to agility the intent behind the spreadsheet is to calculate the actual avoidance you would gain by equipping specific pieces of gear.

    If you think my math is wrong then please show me the correct math .
    True Bonding Occurs when you wipe your raid and then your raid wipes you in return - Tarigar

  9. #9
    Join Date
    Jul 2007
    Location
    Canadia
    Posts
    3,523
    Lizana: The DR curves for dodge and parry do give increasing returns when your rating is under about 100 and/or you have no (or very low defense). You could have seen that in the DR post. Just a quirk of the math.

    Tarigar: You do have some small errors in your spreadsheet. I hate the google spreadsheet like nothing else and it's late, so I'll look at it more tomorrow and reply to your PM.

    Edit:
    All classes have a different Defense rating-skill ratio and deathknights have different parry and dodge caps. I have used live data to test this.
    I'm interested in seeing (and I'm sure Whitetooth would be too) the data you collected to deduce that all three classes suddenly have different defense conversion numbers. If that's true, it is a very recent change. Same with caps - warriors, paladins, and death knights all shared the same caps in testing for 3.0, so again that would be a very recent change.

    Edit2: I can exactly reproduce armoury dodge and parry numbers using same defense rating conversion and cap values for me, our prot paladin, and our dk tank. Suggest you re-think the above statement and check your maths. A good starting place is to not use the exact converted defense skill. The game truncates all decimals (not rounding: 142.9232 counts as 142.) Now really for bed!
    Last edited by Satrina; 06-19-2009 at 11:39 PM.
    Got a question? Try here: Evil Empire Guides and here: Tankspot Guides and Articles Library first!

  10. #10
    Join Date
    Apr 2008
    Posts
    1,399
    Thanks Satrina, i must have forgotten that somewhere along the way ( also i hate calculating DR on avoidance :P)

    Also has the miss DR been verified for the other classes besides warriors. I remember the testing done to prove warrior miss DR, but havent been able to find a confirmed test for pally or DK miss DR

  11. #11
    Join Date
    Oct 2008
    Posts
    4,930
    I was going to say, according to numbers I've seen courtesy of EJ, all the plate wearers have the same Dodge and Parry caps. Where did you find info suggesting otherwise? I haven't remotely tested it myself, so I can only tout other listings. =)
    The (Old) Book on Death Knight Tanking
    The New Testament on Death Knight Tanking
    -----------------------------------------
    Quote Originally Posted by Horacio View Post
    Who f-ing divided by zero?!?

  12. #12
    Join Date
    Jul 2007
    Location
    Canadia
    Posts
    3,523
    Stoneskin Gargoyle is a special case
    - It adds 25 defense skill directly, and does not add any rating
    - Its 1% gain of dodge/parry/miss are not subject to diminishing returns

    If you have a deathknight with 550 defense that has rune of stoneskin gargoyle, you do not use the +150 defense as the base for your DR calculations, but instead remove the 25 from SSG and calculate from 125 defense skill, then add the extra 1% dodge, parry, and miss when you add the rest of the non-diminished avoidances.

    Another thing that I need to remember to add to the avoidance DR article is the base dodge values, as they vary with class:
    Warrior, Deathknight = 3.463600
    Paladin = 3.268500
    Druid = 4.951000
    Got a question? Try here: Evil Empire Guides and here: Tankspot Guides and Articles Library first!

  13. #13
    Join Date
    Jul 2007
    Location
    Canadia
    Posts
    3,523
    Here is a step by step for getting the correct values, using my current armoury:

    142 defense skill
    335 dodge rating
    221 parry rating
    22 agility from gear (lulz)
    113 agility when naked
    3.463600 base dodge for a warrior
    73.529412 agility/1% dodge for a warrior
    k = 0.956
    39.34799 dodge rating/1% dodge undiminished
    49.18499 parry rating/1% parry undiminished
    I have 5/5 deflection and 5/5 anticipation

    Dodge
    Undiminished dodge = anticipation + base + dodge from naked agility
    = 5.00 + 3.4636 + (113/73.529412)
    = 10.000400%

    Pre-diminished dodge = dodge from defense + dodge from rating + doge from agility on gear
    = 142 * 0.04 + 335/39.347990 + 22/73.529412
    = 14.492977%

    Diminished dodge = 1/(1/c + k/pre-diminished)
    = 1/(1/88.129021 + 0.956/14.492977)
    = 12.934940%

    Total dodge = 10.000400 + 12.934940
    = 22.93534% (armoury shows 22.94%)

    Parry
    Undiminished parry = deflection + base
    = 5.000000 + 5.000000
    = 10.000000%

    Pre-diminished parry = parry from defense + parry from rating
    = 142 * 0.04 + 221/49.184990
    = 10.173241%

    Diminished parry = 1/(1/c + k/pre-diminished)
    = 1/(1/47.003525 + 0.956/10.173241)
    = 8.677014%

    Total parry = 10.000000 + 8.677014
    = 18.677014% (armoury shows 18.68%)

    Miss
    Undiminished miss = base
    = 5.000000%

    Pre-diminished miss = miss from defense
    = 142 * 0.04
    = 5.680000%

    Diminished miss = 1/(1/c + k/pre-diminished)
    = 1/(1/16.000000 + 0.956/5.680000)
    = 4.332571%

    Total miss = 5.000000 + 4.332571
    = 9.332571%
    Last edited by Satrina; 06-20-2009 at 09:43 AM.
    Got a question? Try here: Evil Empire Guides and here: Tankspot Guides and Articles Library first!

  14. #14
    Join Date
    Apr 2008
    Posts
    1,399
    Quote Originally Posted by Tarigar View Post
    I used the base dodge i had completely naked(4.96). I know it is factoring in base agility as well.

    That wouldn't be different from race to race would it?

    And I realised I need to remove the 25 from SSG their total defense as i was using their defense rating and that's where it screwed up my math.
    Base agi is different from race to race. Also your not factoring in NE avoidance anywhere or giving the option to.

  15. #15
    Join Date
    Jun 2009
    Location
    Alaska
    Posts
    367
    Quote Originally Posted by Lizana View Post
    Base agi is different from race to race. Also your not factoring in NE avoidance anywhere or giving the option to.
    You can specify 2% miss on the talent portion to make up for the NE avoidance.
    True Bonding Occurs when you wipe your raid and then your raid wipes you in return - Tarigar

  16. #16
    Join Date
    Jul 2007
    Location
    Canadia
    Posts
    3,523
    Base dodge varies on class, base agility on race.

    Here's a deathknight (not our guild's since he is not in tank gear now, just a random DK)
    (The World of Warcraft Armory)

    Has stoneskin gargoyle
    117 defense skill
    483 dodge rating
    527 parry rating
    134 agility from gear
    110 agility when naked
    3.463600 base dodge for a deathknight
    73.529412 agility/1% dodge for a deathknight
    k = 0.956
    39.34799 dodge rating/1% dodge undiminished
    49.18499 parry rating/1% parry undiminished
    Has 5/5 anticipation

    Dodge
    Undiminished dodge = anticipation + base + dodge from naked agility + stoneskin gargoyle
    = 5.00 + 3.4636 + (110/73.529412) + 1
    = 10.959600%

    Pre-diminished dodge = dodge from defense + dodge from rating + doge from agility on gear
    = 117 * 0.04 + 483/39.347990 + 134/73.529412
    = 18.777487%

    Diminished dodge = 1/(1/c + k/pre-diminished)
    = 1/(1/88.129021 + 0.956/18.777487)
    = 16.061927%

    Total dodge = 10.959600 + 16.061927
    = 27.021527% (armoury shows 27.02%)

    Parry
    Undiminished parry = base + stoneskin gargoyle
    = 5.000000 + 1.000000
    = 6.000000%

    Pre-diminished parry = parry from defense + parry from rating
    = 117 * 0.04 + 527/49.184990
    = 15.394651

    Diminished parry = 1/(1/c + k/pre-diminished)
    = 1/(1/47.003525 + 0.956/15.394651)
    = 11.994076%

    Total parry = 6.000000 + 11.994076
    = 17.994076% (armoury shows 17.99%)

    Miss
    Undiminished miss = base + stoneskin gargoyle
    = 5.000000 + 1.000000
    = 6.000000%

    Pre-diminished miss = miss from defense
    = 117 * 0.04
    = 4.680000%

    Diminished miss = 1/(1/c + k/pre-diminished)
    = 1/(1/16.000000 + 0.956/4.680000)
    = 3.748498

    Total miss = 6.000000 + 3.748498
    = 9.748498%
    Last edited by Satrina; 06-20-2009 at 09:51 AM.
    Got a question? Try here: Evil Empire Guides and here: Tankspot Guides and Articles Library first!

  17. #17
    Join Date
    Jun 2009
    Location
    Alaska
    Posts
    367
    Quote Originally Posted by Satrina View Post
    Base dodge varies on class, base agility on race.

    Here's a deathknight (not our guild's since he is not in tank gear now, just a ranom DK)
    (The World of Warcraft Armory)

    <snip> - please don't quote walls of text
    Yeah I realised the rune was throwing me off yesterday and realised it when comparing satorri's and the dk from my guild.
    Last edited by Satrina; 06-20-2009 at 09:54 AM.
    True Bonding Occurs when you wipe your raid and then your raid wipes you in return - Tarigar

  18. #18
    Join Date
    Jul 2007
    Location
    Canadia
    Posts
    3,523
    All good then!
    Got a question? Try here: Evil Empire Guides and here: Tankspot Guides and Articles Library first!

  19. #19
    Join Date
    Jun 2009
    Location
    Alaska
    Posts
    367
    Updated so that way it will round down when doing the defense rating-skill conversion.
    True Bonding Occurs when you wipe your raid and then your raid wipes you in return - Tarigar

  20. #20
    Join Date
    Oct 2008
    Posts
    4,930
    Thanks for writing all that out Satrina, I don't often fret the avoidance calculations but it's really nice to see it with the numbers. =)
    The (Old) Book on Death Knight Tanking
    The New Testament on Death Knight Tanking
    -----------------------------------------
    Quote Originally Posted by Horacio View Post
    Who f-ing divided by zero?!?

+ Reply to Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts