
02-22-2009, 10:26 AM
| | New Registrant | | Join Date: Feb 2009
Posts: 13
| | | Landsoul's Spreadsheet and DPS
I've been using Landsoul's spreadsheet to help me make gear decisions/targets, and I've begun to question whether it's taking me down the right path.
Typically, I'd gear for the hit/exp cap however possible, then max out STR/AP, and hope for the best. Armory Link for one setup.
I've been tinkering with the spreadsheet to see what my "max" is for now, and I'm coming up with:
3788AP
166 Hit
36.25% Crit
17 Exp
7.65% Haste (I'm using two Skullclad Cleavers for now)
This includes using: Pendant of the Outcast Hero over Collar of Dissolution Dragonfriend Bracers over Bracers of Lost Sentiments Death Inured Sabatons over Ravaging Sabatons
I have a few choices for my chest, but I'm sticking with the Heroes' Breastplate over these: Tunic of Disslocation, Chestplate of the Risen Soldier
Basically, I feel like I'm gimped on hit now, probably overly dependent on crit, and maybe need a little more expertise. However, if I swap things in/out to do that (e.g. Staggering Legplate for the Heroes' ones, rings, etc.), the spreadsheet is saying nah-ah.
Is it worth it to roll with this barely over the cap setup and put out reliable DPS?
| 
02-22-2009, 12:51 PM
| | swat cats | | Join Date: Apr 2008
Posts: 279
| | |
Should be. AP and crit are a warriors two most valuable friends. Expertise would be next until you hit the cap, which is 18 with Weapon Mastery talented.
__________________ | 
02-22-2009, 11:52 PM
| | Registrant | | Join Date: Oct 2008
Posts: 78
| | |
you can get away with 17 exp, the dodge cap is estimated somewhere between 6.25 and 6.5
hit rating is all about how well you can manage your rage. After your capped hit rating will theoretically give you less dps than crit/ap.
The problem with using that spreadsheet it cannot run an actual simulation of dps, only calculate it based on an infinite amount of time. It can model rage on you missing 16 white hits out of 100, but it will only model it by a perfect scenario of missing 1 hit every 6 swings, which any player can run a perfect rotation with since it is enough rage in theory. It cannot account for the probability of missing three times in a row, which will destroy your dps on some fights, or the probability of never missing one hit with 0 hit rating, which will blow your dps out of the water.
so if you find yourself rage starved with that setup, then it means you are getting unlucky or not properly managing your rage
the general rule is you can usually get away with less hit when your crit and ap go up because each hit is going to be generating more rage anyway
the bottom line is use whatever is most comfortable
keep in mind of the buffs that the spread sheet is factoring, as it does play a huge role on how you should be geared. Buffs like windfury and such are huge when it comes to rage generation, and trying to gear yourself based on test dummy experience is a mistake, since you will perform much differently in a raid situation.
| 
02-23-2009, 12:14 PM
| | Established Registrant | | Join Date: Jan 2008 Location: Pennsylvania
Posts: 1,374
| | |
Note that 17expertise may be 17.0 or 17.8 expertise. The higher this number gets, the less valuable expertise becomes.
And yes, I've also noticed that Landsoul's sheet doesn't like giving you a ton of hit over the cap. In my experience, this is true; you don't need 300 hit. However, you need to be careful about your HS usage, and pop your bloodrage more liberally to ensure you deal with rage starvation as best as possible.
I went from 350 to 250 hit a week or so back, and at first I thought that his sheet was steering me wrong due to my apparent rage starvation. In fact what was happening is that I had gotten used to being able to spam HS, rather than watching my rage more closely, and this caused misses to be crippling.
Now, I watch my rage and only HS when over 50 rage, and I'm beating my old best records (finally broke 5k on Patchwerk, for instance).
| 
02-23-2009, 04:58 PM
| | I PUG your mom. | | Join Date: Sep 2008
Posts: 1,386
| | |
I've just started using this spreadsheet and find it pretty good right now for deciding what to fix first.
| 
02-23-2009, 10:35 PM
| | swat cats | | Join Date: Apr 2008
Posts: 279
| | |
Frankly for warriors, you really don't need a spreadsheet. The rules for gearing are pretty cut and dry. Get hit soft capped and as close as you can to expertise soft cap without gimping your ap and crit. Once you reach those marks, then gear for AP then crit (though you want at least around 28%-30% crit in beserker stance to maintain Rampage and Flury most of the time).
__________________ | 
02-24-2009, 03:24 AM
| | New Registrant | | Join Date: Sep 2008
Posts: 11
| | |
If you want to talk with absolutes then 10 dps increase is 10 dps increase and this is when spreadsheets come handy, especially when the difference of 2 pieces you can get is hard to estimate with first look. For example: if i equip this i loose 30 ap to gain 20 hit and 10 crit, does it worth it?
Sheet isnt a bible but a tool and as for hit ratings after so many years there is nothing to add except that at the end it comes down to personal taste when it affects the personal pov of when we are rage starved or not. Minimalistic approach, i know, but its all been said millions of times.
| 
02-24-2009, 08:23 PM
| | New Registrant | | Join Date: Feb 2009
Posts: 13
| | |
I agree Rampart on your thought about making it simple, and that's typically what we all do, but the spreadsheet does come in handy to evaluate that new piece of shiny plate or weird leather that drops and has haste or armor pen - stats we don't typically factor in at all. Yes STR/AP and Crit are the primary drivers of DPS, but these other stats are helpful in some moderation.
| 
08-12-2009, 11:31 PM
| | New Registrant | | Join Date: Jul 2008
Posts: 2
| | |
Hoping for the best or stacking things were you think they should go just means that your warrior is either your alt or you don't care about your dps imo lol. I'm sure there are some small errors in the spreadsheet or things that need to be updated now that there have been some changed to us. But having solid numbers and statistics based on pure numbers.... at least to me.... seems to make a lot more sense.
I did fairly good dmg before using the spreadsheet, but there were a few things I was having trouble making a decision on and I gave it a try... I'm not gonna lie I spent a good few hours playing with it and plugging in different things with spec and gear but that's why I love the spreedsheet, it shows you the most minuscule changes in your stats, potential dps output, etc. To me, that's a win win. My dmg went up over 500 damage per second from some of the adjustments I made using the spreadsheet. And my dmg was almost exactly what it said that it would be. No a spreadsheet isn't the end all be all... but if you take the time to test it out and try the things it suggests are better and they are... then duh it's worth it. (That being said I'm not fury, I'm arms. I have no clue how well it works for the fury side of things but I would assume just as well since it takes into account what spec you plug in.)
There is controversy on every warrior thread you see about what stats and such to stack and if you look at the the numbers yourself the spreadsheet acts as nothing more then a calculator that cuts out hours and thousands of gold testing things manually. For example... none of you has even mentioned armor pen... all I see is hit/exp/str/ap..... and armor pen makes a huge difference especially as arms.
I suggest actually toying with it. It's not that scary... just a giant calculator with wow items in it. And it is really helpful. If nothing else see what you could swap and try it on a test dummy. Worst thing that can happen is you don't like it and don't keep using it.
Like Arretheil said 10 dps is 10 dps, and it all adds up very quickly. The small things that a spreadsheet can see that you may not are what make the difference b/w a good warrior and a great warrior imo.
~Auralie
Last edited by Auralie; 08-13-2009 at 12:19 AM..
| 
08-13-2009, 02:06 AM
|  | Sponsor | | Join Date: Feb 2008
Posts: 415
| | Source: Auralie
For example... none of you has even mentioned armor pen... all I see is hit/exp/str/ap..... and armor pen makes a huge difference especially as arms. | this was a thread from back in february, when arms and arp was basically worthless. thats why they didn't mention it.
__________________
-Jimmy | xFire: blkhwk20k | 
08-13-2009, 11:29 AM
|  | CM and Wall-O-Text'er | | Join Date: Jul 2007
Posts: 9,253
| | |
Closed to prevent further necro.
__________________ 
READ THIS: Posting & Chat Rules Source: Turelliax
I will never be a kaz.. no one can reach the utter awesomeness of you. | |
Posting Rules
| You may not post new threads You may not post replies You may not post attachments You may not edit your posts HTML code is Off | | | | World of Warcraft™ and Blizzard Entertainment® are all trademarks or registered trademarks of Blizzard Entertainment in the United States and/or other countries. These terms and all related materials, logos, and images are copyright © Blizzard Entertainment. This site is in no way associated with or endorsed by Blizzard Entertainment®. |
|