Elitist Jerks Warrior DPS Calculation Spreadsheet

 12/20/08, 3:10 AM #121 landsoul Myrmidon Champion     Landsoul Worgen Warrior   Alterac Mountains No matter how I try to simplify the heroic strike calculations, they always diverge as I suspected. Ebs2002, If you can find some way to make it converge by your means, please tell me how. >--Coaching Site--< Private coaching / Warrior Resource >--Stream--< Tues, Wed, 7 Eastern.
12/20/08, 9:45 PM   #122
nponoBegHuk
Glass Joe

Gnome Warlock

Turalyon (EU)
 Originally Posted by landsoul No matter how I try to simplify the heroic strike calculations, they always diverge as I suspected.
uhm... Heroic Strike calculations should be easy once you set it's rage cost to something like
`BaseCost - TalentDiscount + RageGeneratedByAverageMainHandSwing`
Or maybe I understood wrong the point

EDIT: Okay I read more posts, but still can't see where the problem is. I did a DPS warrior spreadsheet some time ago for myself, would be glad to contribute to your awesome work but you'd had to PM me with precise description of the problem(s) because my forum reading skills aren't great

Last edited by nponoBegHuk : 12/20/08 at 10:21 PM. Reason: Misread a post

12/21/08, 10:33 AM   #123
landsoul
Myrmidon Champion

Worgen Warrior

Alterac Mountains
 Originally Posted by nponoBegHuk `BaseCost - TalentDiscount + RageGeneratedByAverageMainHandSwing` Or maybe I understood wrong the point
The thing is that's how its done now. People were wondering if it was possible to not do it this way once the heroic strike frequency is determined, and have the total rage gained from white DPS modified off that percentage, and recalculate the rage available for heroics and also remove the RageGeneratedByAverageMainHandSwing cost of the strike. I say it is not possible, because I have tried it different ways this way all diverging. Someone said it was possible, but haven't shown how yet.

>--Coaching Site--< Private coaching / Warrior Resource
>--Stream--< Tues, Wed, 7 Eastern.

 12/21/08, 11:11 PM #124 ebs2002 Von Kaiser   Ebs Orc Warrior   Sisters of Elune Okay, so you're right; once I set all the variables at once it started to diverge. The solution I came upon, then, is to have a WhiteDPS temp value that the rage value looks at, and keeping the RageGenMH field's functionality. The actual white DPS should be the current formula with the MH portion multiplied by %noHS, but the rage generation formula should be based off how much white DPS you'd do if you did no HSes. Doing it this way reports the same %HS freq that the current sheet shows, but will report a more accurate whiteDPS portion (~800 instead of 2000). This somehow is causing the SEP calcs to cause an Excel crash, and I don't know enough about debugging macros or excel macros in general to find out how/why it's happening. One other thing you may want to include in the rage calcs is the cost of slam and deathwish, as these would take precedence over Heroic Strikes
 12/22/08, 1:56 PM #125 Rallik Piston Honda   Rallik Orc Warrior   Mal'Ganis Could you add mixology with a flask to the AP Flask choices? It's 244 AP.
 12/23/08, 5:33 AM #126 landsoul Myrmidon Champion     Landsoul Worgen Warrior   Alterac Mountains Slam cost is included. Deathwish is not. The deathwish cost would not make any real difference at all really. This is an interesting solution, but I don't think it would add any accuracy to the calculations. I think you don't understand how I set it up. I take the full white damage without heroic strikes, and then add the amount of DPS doing heroic strikes on the calculated frequency of main hand attacks does. What's wrong with doing that? And yes sure I can add mixology. I got an update coming with item changes anyway. >--Coaching Site--< Private coaching / Warrior Resource >--Stream--< Tues, Wed, 7 Eastern.
 12/23/08, 10:44 AM #127 Saizul Von Kaiser   Saizul Troll Mage   Shadow Council When I open the spreadsheet using Excel 97, I immediately get a warning that it contains circular references. Any idea how to address that?
 12/23/08, 11:15 AM #128 Saimias Glass Joe   Saimias Human Warrior   Crushridge Removed Last edited by Saimias : 12/23/08 at 12:06 PM.
 12/23/08, 3:56 PM #129 Jevade Glass Joe   Jevade Orc Warrior   Daggerspine Quick Questions I just had some quick questions regarding the Look Up tab. I would like to confirm that the gem SEP is included into the total SEP for any given item? How is the GEM SEP calculated? Does it assume socket bonus and appropriate gem colors? Also when considering an item such as [Signet of Edward the Odd] that does not have a proc value assigned, could i assume that there has not been an accurate model for it yet and thus there is no proc value added to its SEP value or maybe the proc value just hasnâ€™t been added to the lookup tab yet? Furthermore does this reflect the DPS estimation by putting this in your current gear setup, in other words are we getting the full DPS added to the estimation when we include items that have no proc value assigned on the look up tab? Thanks for all the information.
 12/24/08, 12:58 PM #130 Corobi Glass Joe   Lovejuice Undead Death Knight   Ghostlands Naked lvl 80 Orc HP is 9551 with 161 Stamina. That's as TG Fury, so there shouldn't be any bonuses to stamina or HP.
 12/25/08, 3:21 PM #131 landsoul Myrmidon Champion     Landsoul Worgen Warrior   Alterac Mountains For any given item, it is sorted based on its total SEP, which includes a choice between max gem setup or matching the blue gems for socket bonus. For Signet, there is an accurate model for it, however the proc is not included in the SEP calculation. Once you load it into your gear on the Set1 page, the proc calculation automatically adds itself in. >--Coaching Site--< Private coaching / Warrior Resource >--Stream--< Tues, Wed, 7 Eastern.
 12/25/08, 4:11 PM #132 overvolting Glass Joe   fortyoznaga Undead Warrior   Bonechewer undead stats stats for undead lvl 80 AP, 566 (+3 from att giving 569) STR, 173 Hit Points, 9541 Stamina, 160 Agility, 111 Armor 222
 12/25/08, 8:38 PM #133 Hopside Glass Joe   Bullcrits Tauren Warrior   Nathrezim Found a bug in the spreadsheet. When I changed the glove enchant to none, the sheet bugs out and returns nul values for everything.
 12/26/08, 5:17 AM #134 Aegien Von Kaiser   Aegien Tauren Warrior   Uldum I had this happen as well with excel 2004 on OSX.
 12/27/08, 7:31 PM #135 DarthGreg Von Kaiser     Deegee Orc Warrior   Mug'thol Would it possible to include a switch to toggle between 5% penalty TG and 0% penalty TG?

 Elitist Jerks Warrior DPS Calculation Spreadsheet