+ Reply to Thread
Page 3 of 6 FirstFirst 1 2 3 4 5 ... LastLast
Results 41 to 60 of 115

Thread: 'Complete' Protection Warrior DPS/TPS spreadsheet

  1. #41
    Join Date
    Jun 2009
    Location
    Belgium
    Posts
    2,344
    Now updated with some small fixes
    Quote Originally Posted by Ion
    Damn old people, screwin' with my grind.
    Mists of Pandaria Protection Warrior Spreadsheet
    Warlords of Draenor One Minute Field Guides

  2. #42
    Join Date
    Jun 2009
    Location
    Belgium
    Posts
    2,344
    Just a question; would people be interested in a tab with defensive stats?

    Considering how many defensive stats I already needed for the Parry haste, adding a few more to calculate avoidance & EH numbers wouldn't be too hard to add I reckon. As long as anyone is actually interested in them
    Quote Originally Posted by Ion
    Damn old people, screwin' with my grind.
    Mists of Pandaria Protection Warrior Spreadsheet
    Warlords of Draenor One Minute Field Guides

  3. #43
    Join Date
    Mar 2009
    Location
    germany
    Posts
    105
    I'd be very interested.

    The more a spreadsheet tells you (while staying clean and simple), the less different spreadsheets you need.

  4. #44
    Join Date
    Oct 2009
    Posts
    1
    Awesome sheet, it puts allot of light on why I was having aggro/threat issues. Def. sheet waould be a great idea.

    http://eviscerated.net
    Last edited by r9sid9nt9vil; 10-20-2009 at 03:52 PM. Reason: noob mistake...

  5. #45
    Join Date
    Jun 2009
    Location
    Belgium
    Posts
    2,344
    Working on it now, V1.05 will contain T10 bonuses & defensive stats!!
    Quote Originally Posted by Ion
    Damn old people, screwin' with my grind.
    Mists of Pandaria Protection Warrior Spreadsheet
    Warlords of Draenor One Minute Field Guides

  6. #46
    Join Date
    Jul 2009
    Location
    Cornwall, Ontario, Canada
    Posts
    875
    Last night on Tankingtips.com, a guest appearance by Wartotem's Spreadsheet.


    That's right, Vene refers to your illustrious spreadsheet in his latest blog.

    You are slowly becoming famous Wartotem

    Be a Champion, not a hero.
    Drae

    http://www.zetbit.com/sig-1454507.jpg


  7. #47
    Join Date
    Jun 2009
    Location
    Belgium
    Posts
    2,344
    I noticed the attention, the # of downloads ofthe latest version doubled today O_o

    More incentive for me to keep working on it, knowing people use it
    Quote Originally Posted by Ion
    Damn old people, screwin' with my grind.
    Mists of Pandaria Protection Warrior Spreadsheet
    Warlords of Draenor One Minute Field Guides

  8. #48
    Join Date
    Jul 2009
    Location
    Cornwall, Ontario, Canada
    Posts
    875
    Keep up teh good work man, it is appreciated

    Be a Champion, not a hero.
    Drae

    http://www.zetbit.com/sig-1454507.jpg


  9. #49
    Join Date
    Oct 2008
    Location
    Linköping, Sweden
    Posts
    58
    Nice that you're getting so much attention. A thing that doesn't really matter than much since prot warriors rarely have ArP while tanking anyways. I did some testing the other day and I believe there is an error in cell "E17" Actual Boss Armor.

    When Sunder Armor or similar is used on a target you are reducing the Armor and then also the "ArP cap".

    If I have understood everything in your sheet this is the "ArP cap"

    From cell E17:
    MIN(E9;(E9+400+85*E8+4,5*85*(E8-59))/3)

    You are using the base armor when it should be the armor after the armor% reducing debuffs:

    MIN(E9*(1-(E43+E44));(E9*(1-(E43+E44))+400+85*E8+4,5*85*(E8-59))/3)

    Unfortunately I didn't save my test values but if you don't believe me, I can do the testing again. Keep up the good work!

  10. #50
    Join Date
    Jun 2009
    Location
    Belgium
    Posts
    2,344
    Hmmm, thought I had it right, I'll look into it.

    I'll slam some sunders on a dummy and throw some conc blows & shockwaves at it
    Last edited by Airowird; 10-21-2009 at 11:07 PM.
    Quote Originally Posted by Ion
    Damn old people, screwin' with my grind.
    Mists of Pandaria Protection Warrior Spreadsheet
    Warlords of Draenor One Minute Field Guides

  11. #51
    Join Date
    Jan 2009
    Posts
    8
    This may be overkill, but have you given any thought into including Damage Shield?

    It's usually only a small threat number, but when I'm in a full unhittable set for Anub Hard, I see Damage shield hits around 1200 (with SB and trinkets popped).

  12. #52
    Join Date
    Jun 2009
    Location
    Belgium
    Posts
    2,344
    I've thought of adding Damage Shield, but I didn't consider it worth it for pure TPS output, because I needed so much more stats for it. Now that I am working on a complete spreadsheet, that will be one of the things I will add, as well as Retri aura and Thorns.

    @Rashor: Think I'll need some test results because it seems I only have 78 ArP in my bank, which I find too small to provide accurate testing results.
    If you or anyone else could give me the numbers of the armor reduction on a dummy for:
    * Unbuffed
    * Sunder stack
    * High(pref 300+ atleast) ArP rating
    * Both of the above
    I'ld be very greatful
    Last edited by Airowird; 10-23-2009 at 05:18 PM.
    Quote Originally Posted by Ion
    Damn old people, screwin' with my grind.
    Mists of Pandaria Protection Warrior Spreadsheet
    Warlords of Draenor One Minute Field Guides

  13. #53
    Join Date
    Oct 2008
    Location
    Georgia
    Posts
    142
    Quote Originally Posted by WarTotem View Post
    Small Warning: I use OpenOffice.org for spreadsheets, which I then convert to .xls format to upload it here. This could possibly give problems in future versions when certain code is incompatible with Excel. Unfortunately, I can't do anything about that except upload the original file in a zip everytime, so if you have problems with the MS-Excel format and wish to see the original .ods file, let me know.
    I would certainly appreciate the .ods file.
    [Female Tauren Warrior]

  14. #54
    Join Date
    Oct 2008
    Location
    Linköping, Sweden
    Posts
    58
    Quote Originally Posted by WarTotem View Post
    I've thought of adding Damage Shield, but I didn't consider it worth it for pure TPS output, because I needed so much more stats for it. Now that I am working on a complete spreadsheet, that will be one of the things I will add, as well as Retri aura and Thorns.

    @Rashor: Think I'll need some test results because it seems I only have 78 ArP in my bank, which I find too small to provide accurate testing results.
    If you or anyone else could give me the numbers of the armor reduction on a dummy for:
    * Unbuffed
    * Sunder stack
    * High(pref 300+ atleast) ArP rating
    * Both of the above
    I'ld be very greatful

    I'll try to find the time in the beginning of the week.

  15. #55
    Join Date
    Jun 2009
    Location
    Belgium
    Posts
    2,344
    Quote Originally Posted by Karilyn View Post
    I would certainly appreciate the .ods file.
    I'll upload an ODS zip as well tomorrow then.
    Quote Originally Posted by Ion
    Damn old people, screwin' with my grind.
    Mists of Pandaria Protection Warrior Spreadsheet
    Warlords of Draenor One Minute Field Guides

  16. #56
    Join Date
    Oct 2008
    Location
    Linköping, Sweden
    Posts
    58
    Ok, here we go. I used Thunder Clap for the testing since it hits for the same every time(more or less) and it has a shorter CD than CB and Shockwave. Before I started testing I tried doing Thunder Claps on a friend to make sure I had the formula correct(since I know his armor). My testing shows me that a boss dummy has 11 621 Armor. This is the specc I used:

    Talent Calculator - World of Warcraft

    Damage formula for Thunder Clap:

    (Basedmg+AP*APcoeff) * Defstance * Mitigation * imp. TC * 1h-spec.

    (300+AP*0,12) * 0,95 * Mitigation * 1,3 * 1,1

    Armor formula:

    Armor/(Armor+400+85*(Target level+4,5*(Target level-59)))

    ArP Cap formula:

    This is where our formulas differ:

    WarTotems formula:
    MIN((Armor+400+85*Target level+4,5*85*(Target level-59))/3;Armor)

    Rashors formula:
    MIN(((Armor*(1-0,04*Sunders))+400+85*Target level+4,5*85*(Target level-59))/3;Armor*(1-0,04*Sunders))

    Where "Sunders" is the number of sunders on the target. The difference is that my formula reduces the ArP cap aswell when you put up sunders(and buffs that reduces armor by a %).

    So the actual armor with my formula will be:
    Armor*(1-0,04*Sunders) - ARPrating/1400 * MIN(((Armor*(1-0,04*Sunders))+400+85*Target level+4,5*85*(Target level-59))/3;Armor*(1-0,04*Sunders))

    Which is then inserted in the Armor Formula and you get the mitigation that is used in the Thunder Clap formula.


    I got the "Actual DMG" from doing 10 Thunder Claps with each setup and then took the average value.





    The only case where our values should differ is with both Sunders and ArP Rating and as you can see my model is more exact. On a sidenote: If your model was correct that would mean that it would be possible to reduce the armor by more than 100%, in theory. I'm a bit tired so please check it for errors.

  17. #57
    Join Date
    Jun 2009
    Location
    Belgium
    Posts
    2,344
    You're right, it would be able to penetrate more than 100% total armor (assuming the separate ArP cap is 100%)

    Thanks for the numbers, I'll change it now & update it when I release the next version
    Quote Originally Posted by Ion
    Damn old people, screwin' with my grind.
    Mists of Pandaria Protection Warrior Spreadsheet
    Warlords of Draenor One Minute Field Guides

  18. #58
    Join Date
    Jun 2009
    Location
    Belgium
    Posts
    2,344
    V1.O6 release: Now with Stat Weights!!
    Quote Originally Posted by Ion
    Damn old people, screwin' with my grind.
    Mists of Pandaria Protection Warrior Spreadsheet
    Warlords of Draenor One Minute Field Guides

  19. #59
    Join Date
    May 2009
    Posts
    2
    According to the spreadsheet my heroic throw appearently does more threat than devastate/shockwave/concussion blow, anyone else getting this?



    Every thread i read so far they say Shield slam > CB/SW > Deva for tps, seems a bit odd.

  20. #60
    Join Date
    Feb 2009
    Posts
    7
    Aye. For me it says that Heroic Throw is slightly more threat than Shield Slam (even with glyph), which is entirely possible. I have yet to confirm this.

    There is (I think?) a small amount of travel time involved with HT even at close range. You still probably don't want to use it unless everything else is on CD and your rage is very low.

+ 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