Elitist Jerks Warrior DPS Calculation Spreadsheet

 04/21/09, 7:34 PM #631 bchorn Von Kaiser   Elfhorñ Night Elf Warrior   Icecrown Big fan of the spreadsheet Landsoul. Please keep up the excellent work. Found a cosmetic issue with the spreadsheet. Cell E4 is not reflecting the correct ArP when Mace Specialization is selected. Instead of increasing ArP by 3% for each talent point, the cell is only reflecting .3% for each talent point. The cell used in the actual DPS calculations (C58) is reflecting the correct percentage increase.
 04/21/09, 7:36 PM #632 remix1 Von Kaiser   remix Gnome Warrior   Tichondrius http://static.mmo-champion.com/mmoc/...on6_9806_1.jpg New BiS Arms weapon =/
04/21/09, 8:14 PM   #633
Glass Joe

Tauren Warrior

Thaurissan
 Originally Posted by Ghostcrawler Computing the cap is a little tricky unless you are already familiar with how World of Warcraft armor works. There is an armor constant we’ll call C. C is derived as follows (in some pseudocode): If (level<60) C=400+85*targetlevel Else C=400+85*targetlevel+4.5*85*(targetlevel-59); For a level 80 target, C=15232.5. For a level 83, C=16635. The cap for Armor Penetration then is: (armor + C)/3. A level 80 warrior creature has 9729 armor. C=15232.5. So, the cap is (9729+15232.5)/3=8320.5. Let’s say a player has 30% armor penetration from armor penetration rating and no other modifiers that complicate the calculation (talents, Battle Stance, Sunder Armor, etc.). The game chooses the minimum of 8320.5 and 9729, so 8320.5. That is multiplied by 30% = 2496.15, and so that much armor is ignored. The effective armor on the target is 7232.85 (9729-2496.15). From a player point of view, the armor penetration rating didn’t ignore the full 30%, but instead ignored 25.66%. (85.5% as effective as expected).

 04/22/09, 12:39 AM #634 stompingbull Glass Joe   stompingbull Tauren Warrior   Moon Guard This makes me sad. I despise arena, the idea of having to arena for a bis weapon makes me sad. I hope a new weapon somehow magicaly appears in ulduar.
 04/22/09, 2:48 AM #635 Thairne Von Kaiser   Thairne Tauren Warrior   Nathrezim (EU) I´d say Algalon will have a say in this
 04/22/09, 6:40 AM #636 EaE Glass Joe   Whare Draenei Warrior   Karazhan (EU) There is something wrong with default talents placement on Arms page. You can't possibly have both Improved Execute and Strength of Arms at the same time -- there are better talents to have than SoA for the points remaining after you take Imp. Execute.
04/22/09, 7:12 AM   #637
Grayson Carlyle
Take what ye can;

Tauren Warrior

Turalyon
 Originally Posted by EaE There is something wrong with default talents placement on Arms page. You can't possibly have both Improved Execute and Strength of Arms at the same time -- there are better talents to have than SoA for the points remaining after you take Imp. Execute.
On the first part, aye. There are 73 points spent to get all the ones checked off that are in the default list. The second part isn't true though. Improved Execute is actually a very minor DPS gain; quite a bit less than 4% more strength. They are the first 2 talents you want to drop if you need all the ones in Arms. If you don't need the expertise because you're stuck with too much, then you want to drop Weapon Mastery, not SoA.

04/22/09, 7:51 AM   #638
EaE
Glass Joe

Draenei Warrior

Karazhan (EU)
 Originally Posted by Grayson Carlyle If you don't need the expertise because you're stuck with too much, then you want to drop Weapon Mastery, not SoA.
I just checked the spreadsheet and yes, you are right SoA > WM. Thank you for pointing that out.

 04/22/09, 2:06 PM #639 pudgi Glass Joe   Pudgi Human Warrior   Neptulon (EU) No sure if this has been brought up but it seem as The World of Warcraft Armory is not valid in armory profile window, is it another adress or isent EU version valid?
 04/22/09, 2:45 PM #640 Mia Glass Joe   Mia Orc Warrior   Dragonblight (EU) The spreadsheet looks for The World of Warcraft Armory while the website is: The World of Warcraft Armory Edit: Strange. When I click the link here, it works.. Last edited by Mia : 04/22/09 at 3:00 PM.
 04/22/09, 3:30 PM #641 Necronom Glass Joe   Necronom Undead Warrior   Demon Soul Im having some trouble with the spreadsheet for excel 97. When I open it, i get an error message saying Microsoft Excel cannot calculate a formula (circular reference?) And if I go to the arms page, My dps does not change as I change gear, or even race. If I run an SEP calculation with all the gear in the default setting (that is, as you open the spreadsheet) All the SEP fields show #DIV/0! Am I missing something (this is version 402c)
 04/22/09, 4:22 PM #642 Grim13 Piston Honda     Olaf Orc Warrior   Malorne Oh, hey there buddy. So Landsoul is the caretaker of 'The Sheet" these days, eh? Good, smart guy if I remember right. I've been kind of thinking about playing a little bit again, so I thought I'd pop in here and say 'hey' and take a look at the state of modern spreadsheet-dom.
 04/22/09, 4:54 PM #643 acsido Glass Joe   Acsido Dwarf Warrior   Deathwing I noticed a slight mistake in version 2.4. I havent got the new one because filefront won't work for me so if this was fixed already im sorry. For the helm [Guise of the Midgard Serpent], the spreadsheet has the socket bonus listed as 16 ap when in live it is actually 32 ap. This is the biggest socket bonus I've ever seen and likely is a mistake, but for now its at 32 ap.
 04/22/09, 5:44 PM #644 rea123 Glass Joe   Alphadodo Human Warrior   Azjol-Nerub (EU) @ Pudgi and Mia - please see my posts in the last 1 or 2 pages regarding Armory Import. Essentially the URL is correct; you can ignore the "&lang=en_us" and dual-spec has broken the talent lookup response format. The fix for this is fairly simple if you know how to follow VBA; I have given in a previous post a corrected XPath search query to parse the talents, along with a couple of other relatively small fixes to get the macro nearly working. The only remaining issue I have now determined is due to the armory itself having problems with tooltip lookups (I have seen these occur while browsing the armory normally). Unfortunately, this is causing the macro to halt with an error. In my local copy, I have updated the ValidateEnchant() method to be more resilient to this error. The item gets no enchant, but this is easy to fix by hand after the script completes. I would be happy to describe my local changes more completely, but I believe Landsoul is aware of the issues and will no doubt find time between Ulduar runs to address them more fully than my local hacks. Edit: Just in case: the site you want (for EU) is "eu.wowarmory.com". In particular you must not include the "http://" prefix.
 04/22/09, 5:44 PM #645 Grim13 Piston Honda     Olaf Orc Warrior   Malorne 1. When dual-wielding two hand weapons, does it use the 7 or the 3.5 value for a hit in normalized rage generation? 2. Can trinket proc effecs happen off of off-hand whirlwinds? (currently set to no) Weapon enchants, yes. 3. I need some help with a way to organize gem selection better. 4. I would like someone to help with the programming of Arms. There's a lot of conditions where it makes referencing cells messy and there's got to be a better way to organize it than the way I have it now without it breaking all over the place. 1. First, I am operating under the assumption that a 2hO benefits from both DW spec and 2H Spec, yes? I spent awhile effectively writing, and then deleting, an essay on this topic. After a lot of thought on how this part of the system seems to work behind the scenes, I would be shocked if it was anything other than 3.5. Based upon the way they would have had to code various other 2hO interactions to get them to work the way they do, it would be 3.5. My prime example is DW Spec. In order to be flagged for the OH dmg bonus, the MH vs. OH var would have to have priority over the 2h vs. MH var. While it is possible that they could code it the other way around for rage gen, I can't see any reason why they would. Not to mention that 3.5 just makes the most sense. The vibe I get from Titan's Grip is one of adding 2h weapons to DW, as opposed to adding DW to 2h weapons. This leads me to believe that OH rules have priority over 2H rules. 2. Very, very tricky. First, about OH weapon procs, I think the obvious answer is yes. Moving on to OH WW, on the one hand, it is an OH, but on the other, it is yellow. Let's evaluate what we know. The damage appears as two separate events, both yellow. Single hit yellow attacks, like Bloodthirst or MS, use the MH proc rate. OH proc rates are already being calculated in order to support OH weapon and enchant procs, so tracking OH yellows would not require adding too much code or calculation overhead. What we do not know for sure is if the game tracks an OH WW hit as simply another yellow (MH proc rate), an OH yellow (OH proc rate) or simply considers it the same hit as the MH WW and the 2 displayed #s are for display only (no proc) When I was working on the old sheet, I went with the second method. I tracked and calculated OH yellow attacks as distinct events, and calculated separate proc rates for them. For things like trinket procs, I combined the MH and OH rates. Remember to use (a1+a2)-(a1*a2) rather than a simple sum. What I cannot recall for sure is if I based this upon observed data or theory. 3. & 4. I may be able to help out, but I can't commit to anything just yet. It will depend upon if I play again and how serious I get if I do. On the table would be 1) Do nothing, 2) Help out 3) Re-write from scratch using a fully modular design. Anyway, I hope my ramblings helped in some way.

 Elitist Jerks Warrior DPS Calculation Spreadsheet