• Ren

Crusader is only 1PPM if all you do is auto-attack without Flurry.

Mongoose is a flat 2%, so it won't be affected by the haste nerf.

 

• LodeRunner

Hm. In yesterday's Archimonde parse of 6.5 minutes had 7 Mongoose procs. I guess I'm just unlucky.

 

Davia

Keep in mind Loderunner that when you proc a Mongoose with it already up to refresh it, WWS cannot record that, it only records when you gain the buff, not if it refreshes before wearing off.

 

• LodeRunner

Stop trying to poke holes in my airtight argument you communist.

 

Grayson Carlyle

Because procs as ppm are converted to a chance on hit based on weapon speed. For ease, a 2.7 second weapon swings 22.22 times per minute, so it has a 4.5% chance per swing of proccing. 22.22 swings + 6 WWs + 10 BTs + 4 WF swings + 20 hamstrings = 62.22 attacks or 15.555 attacks within the 15s span of our chosen proc. Plug that into the uptime formula 1-(1-P)^(D/S) you get 1-(1-0.045)^10 = 51.14% uptime. Less than what I remember because of the WF nerf and I believe the spreadsheet used base weapon speed for proc chance, not post-haste speed as what is now generally accepted. But 31 str is still better than 20.

I was wrong with that; it was in the converting to a haste rating equilavence, but of course if you lower the haste rating value relative to a %, you're also reciprocally increasing the amount you get from it, so it won't have an affect at all.

 

Do0mbringer

Well, I've been reading this topic for awhile, but this is my first post. I'm trying to figure out how to get more dps out of my current gear.

The Armory

1823 ap unbuffed zerk
218 hit rating with Natasha's Choker(Natasha's Choker - Items - World of Warcraft)
208 Hit rating with the necklace I have on in the armory.
30.33 Crit unbuffed zerk.

I've been debating whether I should ditch some of my gems in favor of str/crit or pure str gems.

So any suggestions you guys can make would be great. I use a basic WW>BT>BT>WW rotation with other things thrown in (hamstring/heroic/cleave) depending on situation.

Edit: Crunching a few numbers quickly I came up with
All +8 str gems putting me at
1977 ap unbuffed
209 hit
28.34% crit

Leaving a few pieces as is puts me at
1924 ap
212 hit
29.11% crit

which of those if either seems like the bigger improvement over what I currently have.

 

dr_AllCOM3

I'm redoing the Warrior sheet right now. Most of it is finished and looks nice (no items in there yet), but I have some questions and things I don't understand.

1. Is a WF attack affected by Impale? I don't think so, since I gives rage.

2. Rage generation. I don't fully understand the formula used there.
(Mainhand normal hit as an example) Especially both speed things, rest is clear. I think it is somewhat calculated down to rage/sec. How and why?
WF is nowhere calculated for additional rage, so I want to add that. Can't borrow rage generation from other classes sheets .

3. More haste, less rage per hit? And on instant hits? Both haste rating and flurry?

4. Windfury damage. Gruntle suggested "- Windfury incorrectly modeled, should only proc on hit or crit, not on swing (would be good if someone else could look at this, I think it is incorrect in the sheet).". Isn't that already done in the Adjusted Windfury Damage (Miss and Dodge are considered) and Adjusted Mainhand Damage (same)?

More or less done:
- Ignore Armor (have something to improve it even more, but stuff above first)
- Base miss 9/28%
- WF and haste nerf
- Buffs cleaned up and more cosmetic things

Half done:
- 2h incl. Slam Cycle (need good ideas)

To do:
- Items, items, items
- Gems properly
- Threat
- Save/Load item configs (should not be that hard)
- Maybe some more clicky stuff, when everything else works

Gone:
- Unbuffed damage and other uninteresting stuff

I hope I can do it .

 

Apate

If I may be so bold as to make/repeat a suggestion - save the items for last or for later. Unless you use one of the DBs from the armory crawler, most users will probably find that one or more items that they use aren't listed. If the sheet was set up to accept raw stat input from the character sheet combined with the usual talent/buff options, everyone would be coming from the same place, and you won't have 6 people posting about how they can't add such and such item, or they got an error when they did something, or "this sheet is outdated because it doesn't have my ___", etc.

And, in advance, thank you very much (however you choose to do it) and godspeed

See you, auntie.

 

dr_AllCOM3

I was thinking about "You want it in? then give it to me" . Especially that crappy blue stuff.
But math things first. Go!

 

Elic

It is based off the formula from:
Formulas:Rage generation - WoWWiki, the Warcraft wiki

The Weaponspeed is the tooltip value and is not effected by haste or flurry. The adjustedWeaponSpeed is (attack speed) and turns the output from units of rage to rage/second. I used the average rage/s to figure out how much rage would be available in a cycle.

Same rage per hit, hit more often. No rage on instant hits besides WF, which is probably same formula as MH. If you wanted to keep the rage/s, add rageFromWFhit/averageTimeBetweenWFProcs


Yeah, it was modeled in at the last step (Adjusted Damage). I don't know if the results are identical.

 

Elic

I would agree about leaving the items out until they can be always up to date (armory something or other). Data entry single-handedly killed my enthusiasm for working on this spreadsheet.

 

dr_AllCOM3

DPS Sheet 0.2.1

Feel free to have a look and tell me about my stupid mistakes .


A good description about adding your own items should do it. Anyway, not really a big problem .

 

Gruntle

Thanks a lot for doing the upgrade, I was thinking about doing it, but too much RL stuff happening.

Well, the WF damage is just added as 0.2*adjusted WF damage in the Adjusted Mainhand Damage cell. I'm not dead certain, but the total MH damage is from three terms, hits, crits and WF. The hit damage is mulitlied by the hit chance and crit damage multilplied by the crit chance. The WF damage, however is just multiplied by 0.2, implying that it has a 0.2 proc rate over all swings. This is not correct, the "adjusted proc rate" for WF is 0.2*(hit+crit) which is what I put in my version of the sheet. This brings down WF damage by quite a margin, and decreases the total damage by a few percent.

Another thing I noticed which might be easy to miss is that there is a WF term in the flurry uptime calculations regarding instants triggering flurry, this needs to be removed since WF nerf (I mentioned this some posts ago, not sure you saw that).

Haven't checked your new version of the sheet, will do so. Again thanks a lot.

 

Graul

Is the bonus attack power on the Windfury hit factored in?

 

dr_AllCOM3

I have in Adjusted Dmg (Hit+Glance+Crit)*0,2*WF. Seems to be what you want.

Can WF glance? I think so and assumed it.



@Graul
Yes, always was.
Maybe WF totem talent option later.

 

Gruntle

Your question was whether WF can proc of a glance right?

Well, I'm not sure if it can. Would be good if someone could check this somehow (I might run with WF on our raid on sunday, but perhaps someone knows). If it can, then your expression for the adjusted MH damage seems right to me (that change was not in the current version of the spreadsheet right?).

I think I did read somewhere that the WF attacks themselves count as yellow attacks (and they do in the spreadsheet, using the miss rate for yellow attacks) and as such, cannot glance but I'm not sure.

Took a quick look at your spreadsheet, looks very nice, a bit more ordered than the previous version.

 

Nisall

The Shaman's Windfury Weapon proc is a yellow attack, but Windfury Totem procs white attacks.

 

Gruntle

Do he extra attacks use the yellow or white hit mechanics? Currently they use the same miss chance as the specials in the spreadsheet, is this wrong then? Maybe they are treated as white without the DW penalty (i.e. 9% miss). If this is wrong the old spreadsheet really overvalued WF (close to 40% with both this and the proc chance over all swings error).

 

Nite_Moogle

Windfury procs of any sort are never treated as dual wield attacks. The standard special attack miss rate of 9% always applies.

 

Machinator

Im pretty sure windfury is treated as a normal MH swing. I know it can glance, and it might have the same hit rate as normal attacks.

Is the two roll system for specials proven enough for spreadsheets?

Also maybe you can explain how that flurry formula works? or is it just a copy from the old sheet?

"Information is ammunition."

 

Opalira

dr_AllCOM3, thanks a lot for making an updated version of the spreadsheet, the old one had become just about useless. I'm currently in the process of adding my gear.

The old spreadsheet provided SEP (strength equivalency points?) values for stats based on your current gear and buffs, and this seems to be absent in your version. I found this to be very useful data and if there is anyway to get it back I would be very happy.

 

Gruntle

The SEP values in the old sheet were obtained by using a simple macro that added 1 to the stats (str,agi,hit,crit) and checked the damage increase. The increase in damage from agi/hit/crit is then normalised by the damage increase of +1 str, giving SEP values (Strength Equivalent Points). I'm no expert at doing macros in excel/OpenOffice so I can't really add such a macro to the sheet.

While it's a bit boring to do this manually it can probably be done quite easily by putting in 1 in the manual entry boxes in the new sheet for the different stats and writing down how much extra dps you get (one at a time). Then divide each of these values with the strength damage increase.

 

dr_AllCOM3

I left it out because it's not that important.
We aren't exactly in a hurry.

 

Avoch

None of the items I enter into the latest spreadsheet are appearing in the drop down boxes, I'm using Excel 2007.

 

Apate

Offhand, I'd recommend inserting a row amidst current data to add new data, instead of tacking it onto the end, if that is what you did. It's worked for me in the past.

See you, auntie.