Elitist Jerks Warrior DPS Calculation Spreadsheet

 12/14/08, 7:48 PM #91 landsoul Myrmidon Champion     Landsoul Worgen Warrior   Alterac Mountains Why are there numbers next to trinket calculations? That's an ordered list it helps me keep track of things, I used it before but its not so needed now. How are trinkets calculated? Average uptime * value of proc Uptime = duration / (ICD + time to reproc) Time to reproc can vary depending on the trinket For example darkmoon card greatness has a 15 duration, 45 ICD and a 35% on all hits proc. =$\frac{15}{45+\frac{1}{0.35*\text{HitsPerSecond}}}$ with 1.5 hits per second, this card gets 31.98% uptime. thusly, the value of the proc is 95.94 strength. >--Coaching Site--< Private coaching / Warrior Resource >--Stream--< Tues, Wed, 7 Eastern.
 12/15/08, 10:54 AM #92 DarkS Von Kaiser     Darks Undead Warrior   Daggerspine (EU) About Enchants: +32 Attack Power is unavailable. I know +16 STR is better but isn't available for Ring enchanting at this moment Thanks for the awesome spreadsheet Landsoul.
 12/15/08, 12:01 PM #93 zinv Glass Joe   Zinv Night Elf Warrior   Madmortem (EU) something seems to be off with the crit rating conversion to crit% I have 33.28% crit unbuffed and the spreadsheet says i have 29.76 unbuffed and in the hit table it says i have a 26.63% chance to crit. When i add the flat modifiers of BLood poisoning and Rampage the hit table critchance goes up to 34.65
 12/15/08, 3:06 PM #94 Amyannirving Von Kaiser   Motormaster Human Warrior   Windrunner Is there some kind of unknown bug with the way scourgebane works right now, or should it be better than +85AP against undead? Every version of the spreadsheet has reported scourgebane as not being as good as greater savagery against undead. This shouldn't be the case right?
 12/15/08, 6:18 PM #95 landsoul Myrmidon Champion     Landsoul Worgen Warrior   Alterac Mountains Scourgebane isnt put in yet. Why would you put Scourgebane on a weapon versus straight AP? In fact, I don't even know why I still have those names loaded in the list. I'll take them out I guess. Zinv, if you have "Boss" in the Mlevel cell, it subtracts 4.8% from your crit rating. That is the crit rating depression found on bosses from new research. Due to your unbuffed crit being wrong, you should double check everything. Make sure "Berserker Stance?" cell has a 1 in it, make sure you are using the right gems, etc. Seems to work fine for me. >--Coaching Site--< Private coaching / Warrior Resource >--Stream--< Tues, Wed, 7 Eastern.
 12/15/08, 7:09 PM #96 zinv Glass Joe   Zinv Night Elf Warrior   Madmortem (EU) i checked, twice
 12/15/08, 7:35 PM #97 Slevin Glass Joe   Slevin Human Warrior   Ravencrest (EU) World of Warcraft PTR Patch 3.0.8 Hunters: Call of the Wild: The benefit from this pet talent now applies to only the Hunter and their own pet. WoW -> Test Realm Patch Notes
 12/16/08, 3:14 AM #98 Bluefish Piston Honda     Tazjina Troll Shaman   Lethon Landsoul, when I open the 2003 version of 2.110 in Office 2003 and flip to the Lookup tables, the gem SEP values for items with sockets are #VALUE!. On the black sidebar on the left, R Y and B are all #VALUE! and so is max. The SEP macro runs but doesn't fix any of the missing values, and the Sort button gives the following dialog: Microsoft Visual Basic popup, "Run-time error '438': Object doesn't support this property or method." One of the available options is Debug; when I hit that I am taken to the code of Module6, line: ActiveWorkbook.Worksheets("Lookup").Sort.SortFields.Clear It's basically the second line from the top. As far as I can tell I've followed the directions on the first page; in 2003, Excel Options -> Formulas becomes Tools -> Options -> Calculation, and the editable field (.many0s1) is max change, not min. Excel Options -> Trust becomes Tools -> Options -> Security -> Macro Security... and I have that set to no security. Thank you for continuing to support 2003 for those of us who are broke and/or have stingy schools...
 12/16/08, 5:32 AM #99 landsoul Myrmidon Champion     Landsoul Worgen Warrior   Alterac Mountains I think I know what's wrong. '03 can't nest more than 7 times. I'll have to problem solve a little bit more to fix the logic of the gems. >--Coaching Site--< Private coaching / Warrior Resource >--Stream--< Tues, Wed, 7 Eastern.
12/16/08, 11:06 AM   #100
Amyannirving
Von Kaiser

Human Warrior

Windrunner
 Originally Posted by landsoul Scourgebane isnt put in yet. Why would you put Scourgebane on a weapon versus straight AP? In fact, I don't even know why I still have those names loaded in the list. I'll take them out I guess. Zinv, if you have "Boss" in the Mlevel cell, it subtracts 4.8% from your crit rating. That is the crit rating depression found on bosses from new research. Due to your unbuffed crit being wrong, you should double check everything. Make sure "Berserker Stance?" cell has a 1 in it, make sure you are using the right gems, etc. Seems to work fine for me.
Doesn't scourgebane give you 140 additional AP against undead? I would think that against undead mobs it would be better than the +85 you get from greater savagery or the +110 you get from massacre. So I just slapped it on one of those Ebon Blade rep swords for use as my "Naxx weapon". Does that not make sense?

 12/16/08, 11:53 AM #101 ebs2002 Von Kaiser   Ebs Orc Warrior   Sisters of Elune Found a bug that gave me the N/A error: Hand enchant lookup is: =VLOOKUP(J7,Lookup!GD250:GP258,2,FALSE) Should be: =VLOOKUP(J7,Lookup!GD250:GP259,2,FALSE) Note the range should be to 259, not 258 (259 contains the "none" option). Note: I use 'none' as enchant/gems to calculate my SEPs before deciding on an enchant/gem (find the upgrade with the most SEP, select it, then re-calculate).
 12/16/08, 3:39 PM #102 landsoul Myrmidon Champion     Landsoul Worgen Warrior   Alterac Mountains Fix uploaded. >--Coaching Site--< Private coaching / Warrior Resource >--Stream--< Tues, Wed, 7 Eastern.
 12/17/08, 4:37 AM #103 NobleHelium Von Kaiser   Nob Night Elf Warrior   Uther I get a run-time error when I try to click the sort-by-SEP button for the item lookup tab. It says "Run-time error '438': Object doesn't support this property or method." Clicking debug shows that the line that causes the error is in Module6, subroutine SortLookup(), second line, which reads, "ActiveWorkbook.Worksheets("Lookup").Sort.SortFields.Clear". I am using the .xls version of the spreadsheet on Excel 2003. You should probably add Wicked Monarch Topaz (16 AP + 8 Crit), because Inscribed Monarch Topaz (8 STR + 8 Crit) is not actually in the game right now. Also consider adding Stoneskin Totem, which increases armor by 1150, with 20% more talented. I imagine it doesn't stack with Devotion Aura, but I haven't tested it.
 12/17/08, 12:52 PM #104 Eliminate2 Von Kaiser   Elimjr Gnome Warrior   Kil'Jaeden Couple of questions. 1) Is there any way you can implement a possible switch to turn off all buffs, minus the warrior ones. 2) I see there is a 114ap option for bracers. I tried looking for it on wowhead. Didn't come up with what actually provides that bonus. 3) I ran into a bug with the 2.111, Whenever I try to swap out one of the +27str gem to +20 str gem. The SEP value go to #N/A. Even trying to switch it back to +27 str. It still never recovers from it. Breakin the spreadsheet. I'm on excel97. EDIT: tried it out with various gems. The one that seem problematic was the +20 str. For example, I dl'd the sheet, did nothing to change anything. Try to swap the +27 str gem out of the chest to +20str gem. Hit teh SEP button. All value but STR goes to #N/A. Try switching the gem back to the 27str, then SEP button, still shows #N/A Edit: it seems all the +20 stat gems does this as well. Last edited by Eliminate2 : 12/17/08 at 2:55 PM.
12/17/08, 1:00 PM   #105
Xerophyte
King Hippo

Awnh
Tauren Warrior

No WoW Account (EU)
 Originally Posted by Eliminate2 2) I see there is a 114ap option for bracers. I tried looking for it on wowhead. Didn't come up with what actually provides that bonus.
Fur Lining - Attack Power - Spell - World of Warcraft

 Elitist Jerks Warrior DPS Calculation Spreadsheet