Elitist Jerks Warrior DPS Calculation Spreadsheet

 01/15/09, 1:30 PM #181 ebs2002 Von Kaiser   Ebs Orc Warrior   Sisters of Elune In addition to the lack of expertise food buff, I have discovered another expertise-related bug. The racial expertise section is off: it adds 3*L24 expertise, but that doesn't apply to every race. Orcs at least get +5 instead. Consider making it a dropdown box for 0, 3 or 5, and taking out the multiplier.
 01/16/09, 6:19 PM #182 Fortitude Glass Joe     Carcerin Tauren Warrior   Destromath I don't really understand the "proc" column (GA) for the trinkets lookup. I thought it might mean the value of what procs modified by it's uptime or some sort of SEP, but neither makes sense with the values I see. I tried searching, but the closest thing I can find is post 91 about how uptime is calculated. What I'm really looking for is an SEP on trinkets, ideally based on my stats in the sheet, but I'm assuming there's some reason that's not in there and that I'm just missing the explanation. Also, is there a reason that some weapons have different SEP as an OH rather than a MH? I see this for most of them and also see lots of polearms in the OH list which doesn't really make sense. Finally thank you Landsoul, it's a great tool.
 01/17/09, 8:41 PM #183 bcswen Glass Joe   Sporozoite Draenei Priest   Gorgonnash The value in the proc column refers to the corresponding average stat gain in the 'Procs' area in the Item Selection page. I suppose you could manually calculate the SEP based on that value. Weapons have different SEP based on which hand they are in because weapon speed and damage produce different results accordingly. For example, the bigger deep wounds ticks provided by a slow weapon would be more beneficial if the weapon is in the main hand, whereas the benefit is lesser if it's in the off hand. You can see this effect in the spreadsheet SEP where the REALLY slow weapons have a much higher SEP value when in the main hand. Fast weapons in the offhand provide consistent rage that is not affected by heroic strike usage, which probably accounts for them having a higher SEP when in the offhand, though I am not sure if this is modeled in the sheet.
 01/17/09, 9:03 PM #184 landsoul Myrmidon Champion     Landsoul Worgen Warrior   Alterac Mountains Polearms are there in case I start working on Arms models. Please save all your questions until the next version, which will be done within the week. Remember it's still in BETA form so it's not entirely a finished product yet. >--Coaching Site--< Private coaching / Warrior Resource >--Stream--< Tues, Wed, 7 Eastern.
 01/19/09, 1:50 AM #185 Megalith Glass Joe   Megalith Tauren Warrior   Jaedenar (EU) Thanks for a great spreadsheet! For the next update i wonder if it would be possible to implement two rows with stats, unbuffed and fully buffed? Bit like there was in dr_Allcom's spreadsheet so it was easy to see the benefit of the different buffs one got. Right now what can be seen is unbuffed stats but not the result after buffs (and talents)?
 01/19/09, 4:12 AM #186 Mightybeast Glass Joe   Mightybeast Tauren Warrior   Aggramar Great Spreadsheet I really like this spreadsheet. It looks very useful. I've tried to read through this forum and figure out how to use the spreadsheet on my own and I have a few things I can't seem to figure out. For one, what is the expertise cap assumed to be? I thought it was 6.25% but according to the spreadsheet im still undercapped at that level. Also if that is the case, is there a way for me to manually change the cap in the spreadsheet? Because I never get dodged in raids (or at least I thought I wasnt). ALso, for each item that I enter in, do I have to manually switch all bonuses and sockets? And I don't understand what SEP is. Just so you know i'm not a tard I actually know a bit of excel programming myself but I just need a few pointers.
 01/19/09, 10:23 AM #187 iwt2001 Glass Joe   Jaegen Human Warrior   Anetheron I know the way this spreadsheet calculates racial expertise has been brought up before but I still haven't been able to figure it out. If the boxes under Racial Expertise is supposed to be binary (values 0 or 1 only) and the values under Spec Activator-Axe-Sword-Mace is supposed to be the amount your racial expertise gives, then it's not working for me. Entering any values under Spec Activator result in no change. The only way I can get the numbers to change is to enter values 1-5 under Racial Expertise. Below is an example: I'm an orc. I get +5 to axes. If the expertise cap is 209.856 (6.4% base dodge * 32.78998947) untalented, 144.276 (2 * 32.78998947) with weapon mastery, and 103.2885 (5 * 8.1974973675) with the axe racial, then I should see exactly zero dps increase if I set my gear to have >= 104 expertise rating with both Racial Expertise boxes set to 1 and Activator boxes set to 5 while wielding axes. This is not the case. I have tried it with all sorts of weapons, buffs, gem settings, with no effect. The closest approximation to getting it to work was when I set Racial Expertise boxes to 2 with still came out to be lower than what I would get if I had 5 expertise (but 3 resulted in too large of an expertise bonus). In summary: Spec activator boxes don't work for me, and Racial Expertise boxes are off target. Please help/fix.
01/19/09, 11:46 AM   #188
Alexsiss
Von Kaiser

Blood Elf Warrior

Doomhammer
 Originally Posted by Mightybeast I really like this spreadsheet. It looks very useful. I've tried to read through this forum and figure out how to use the spreadsheet on my own and I have a few things I can't seem to figure out. For one, what is the expertise cap assumed to be? I thought it was 6.25% but according to the spreadsheet im still undercapped at that level. Also if that is the case, is there a way for me to manually change the cap in the spreadsheet? Because I never get dodged in raids (or at least I thought I wasnt). ALso, for each item that I enter in, do I have to manually switch all bonuses and sockets? And I don't understand what SEP is. Just so you know i'm not a tard I actually know a bit of excel programming myself but I just need a few pointers.
Plugging in your gear the value of exp drops to to 0 because you are at cap. 4.5% + 2% from talents I am assuming thats where your confusion is coming from. And i really cant answer your other question haven't been using the sheet long enough.

 01/19/09, 2:14 PM #189 Rallik Piston Honda   Rallik Orc Warrior   Mal'Ganis berserking I've got a question about how you do enchant uptime... maybe I'm just missing something here. You currently have: 1.2/(1/T143)/100 which simplifies to 1.2*T143/100 for the chance to proc berserking for example. 1.2 being the enchant's PPM, and T143 being the base attack speed of the weapon, this is for MH. With a 3.5 speed weapon, this is a 4.2% chance on hit to proc and gives around a 45% predicted uptime for zerking. I thought though that the chance on hit for a wep enchant to proc was: PPM/AttacksPerMin which is 1.2/(60/T143) which simplifies to 1.2*T143/60 = 7% chance to proc on hit. This gives an uptime of 60-65%. Attacks per min * chance to proc = PPM. (60/3.5) * .07 = 1.2. It all checks out. Last edited by Rallik : 01/19/09 at 2:25 PM.
 01/19/09, 10:08 PM #190 Mightybeast Glass Joe   Mightybeast Tauren Warrior   Aggramar I understand now the estimated dodge rate is assumed to be 6.4%. However I am curious as to how the SEP works and what exactly does it mean. For some reason it is showing me Runeblade of Demonstratable power will give me more dps than my Titansteel destroyer. Is this right? I lose hit rating and will be undercapped if I switch, so is it calculating if I gem for hit after I switch? And if I see an item above my current item in SEP in the lookup table is it a gaurnteed upgrade (assuming i gem correctly)?
 01/19/09, 11:04 PM #191 landsoul Myrmidon Champion     Landsoul Worgen Warrior   Alterac Mountains Check the front page for the massive update. Finally done with it! @Mightbeast: Actually the Titansteel Destroyer is a pretty crappy weapon for it's level, while Runeblades are most excellent. It may not be worth the small DPS gain to switch and regem the hit back in and lose the stamina. You have to take everything with consideration. Also, for the 1000th time on these forums, the dodge cap is above 6.25 and below 6.5% percent. Just because you don't ever realize yourself get dodged doesn't mean it doesn't happen to you or other people. @Rallik: The uptime is derived from its 1.2 PPM yes, but it has to take into account special attacks, as well as the proc refreshing itself. The formula is of the form: $\text{ProcUptime}= 1 - (1 - \frac{\text{PPM}*\text{WepSpd}}{100})^{Dv}$ Where D is the duration of the buff and v is the amount of attacks per second that can proc the buff. >--Coaching Site--< Private coaching / Warrior Resource >--Stream--< Tues, Wed, 7 Eastern.
 01/19/09, 11:28 PM #192 NobleHelium Von Kaiser   Nob Night Elf Warrior   Uther Nice interface changes. There's a bug with ring sockets though, when I switch a ring to Greatring of Collision it says "16" where it should say the socket color. Also, the SEP macro seems broken on the .xls version. When I press the button I get the error "Run-time error '1004': This operation requires the merged cells to be identically sized." Clicking debug says the error occurs on the line: Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=False in the SEP() function. In addition, the error occurs when cells AM-AN on row 29 are highlighted. Last edited by NobleHelium : 01/19/09 at 11:40 PM. Reason: found another bug with the spreadsheet
 01/19/09, 11:54 PM #193 landsoul Myrmidon Champion     Landsoul Worgen Warrior   Alterac Mountains Sigh.. Are you kidding me.. Anyone with '97 able to get a crack on the solution? There's no way I can check it since I don't have the older excel. Is it only because AM:AN are merged for formatting reasons? Quick fix for the Ring Socket bug: in AA14 and AA16 the code should say: AA14: =IF(VLOOKUP(T14,Lookup!FN2:GA222,12,FALSE)=0,"",VLOOKUP(T14,Lookup!FN2:GA222,12,FALSE )) AA16: =IF(VLOOKUP(T16,Lookup!FN2:GA222,12,FALSE)=0,"",VLOOKUP(T16,Lookup!FN2:GA222,12,FALSE )) I accidentally put 14 instead of 12 in the first Vlookup Argument. >--Coaching Site--< Private coaching / Warrior Resource >--Stream--< Tues, Wed, 7 Eastern.
 01/20/09, 12:14 AM #194 Kaan Piston Honda     Khanan Orc Warrior   Blackrock (EU) Again awesome work, Landsoul. Now the spreadsheet isn't far from being perfect. I've found a minor bug in [Shoulderguards of Opportunity]. 4 Armor Penetration instead 4 AP socket bonus. Edit: found some more: "Target Level" Boss and Level 83 are different from each other (I know from older versions that these were actually the same); when I select "Player" it bugs out. I use the Excel '07 version. Last edited by Kaan : 01/20/09 at 12:38 AM.
01/20/09, 12:36 AM   #195
Rallik
Piston Honda

Orc Warrior

Mal'Ganis
 Originally Posted by landsoul @Rallik: The uptime is derived from its 1.2 PPM yes, but it has to take into account special attacks, as well as the proc refreshing itself. The formula is of the form: $\text{ProcUptime}= 1 - (1 - \frac{\text{PPM}*\text{WepSpd}}{100})^{Dv}$ Where D is the duration of the buff and v is the amount of attacks per second that can proc the buff.
I understand how it all works, but the only part I'm concerned with is the center of that formula $\frac{\text{PPM}*\text{WepSpd}}{100}$ which should be the percent chance on every attack for the enchant to activate. What I'm asking is, why are you dividing by 100 and not 60? (PPM*WepSpd)/100 is a meaningless number. (PPM*WepSpd)/60 is by definition the percent chance a proc would need to activate per hit to come out to an expected value equal to the PPM.

With real numbers, 1.2 PPM and a 3.5 speed weapon. 1.2*3.5/100 = 4.2%. 60/3.5 ~= 17.14 attacks per minute. Attacks per minute * chance on hit to activate = expected PPM. 17.14 * 4.2% = .72, when it should be 1.2.

Or to put it another way, if you had an enchant with 60 PPM and had a 1 speed weapon, it should be obvious as hell that your chance on hit to activate would be 100%. Using: PPM*wepspd/100 will give 60% instead.

Last edited by Rallik : 01/20/09 at 12:52 AM.

 Elitist Jerks Warrior DPS Calculation Spreadsheet