pf

New post made as Chalon is no longer maintaining the sheet. If there are any bugs/comments about this sheet, please post them into this new topic instead of the old one. I will also try to keep the current version updated in this post with the date released for those lazy people who don't care about discussion pertaining to the sheet.

If you do not have M$ excel and would like to view the spreadsheet, simply use OpenOffice Calc available free for download at: http://www.openoffice.org

http://rogue.bleedo.net/

Thank you Bleedo for the new hosting. If his site crashes and burns, I will update filefront/savefile.

Version 2.2.3 3/20/2007
Added a new option for the calculation of +skill based on http://blue.cardplace.com/newcache/en/166546791.htm , If this post is true, +skill is about twice as good as agility for DPS on boss-mobs.
Added an option for sockets on cloaks.
Added AEP values on the talents page with a link to sp00n aka Surprise's (Wrathbringer (EU)) gear comparison website.
Added a Pawn import string on the Talents page as well.
Added 3s/5s/5r to the list of cycles for Combat Daggers.
Fixed amount of +skill given from racials and talents.
Changed stats on Vengeance wrap.
Changed Deadly Poison VII to follow a Poisson distribution. This is not 100% accurate, but is 100 times better than what was used previously. It now correctly accounts for using it on both weapons as well.
Changed The Night Blade to follow a Poisson distribution as well. However, to prevent circular references, amount of special attacks used is estimated based upon the spec you choose.

Known Issues:
Hemo debuff is affected by +crit on next-stat sheet when in actuality, it should only receive a very slight boost. (for nextstat values, unselect the hemo debuff to be more accurate)
Sometimes, the most optimal cycle is not chosen by the cycle sheet because it calculates proc damage after figuring out which cycle to use.
Vitality, Sinister Calling, and Deadliness do not always round off correctly to match in game values.
Seal Fate does not affect non-mutilate builds.
Some non-physical effects are affected by bloodfrenzy, and some physical ones are not, also % increases are not properly represented on the dps breakdown.
Next-stat sheet does not account for cycle changes due to increased crit/hit%. If you use 4/9 bs or seal fate, +crit will be worth slightly more, and with combat potency, +hit will be worth slightly more.
Next-stat sheet does not correctly account for crusader/mongoose/wastewalker 4p/etc and as such, data will be slightly off when using the enchant.
Mongoose with seal fate is slightly undervalued since the gained crit% from mongoose does not count toward combo points.
On-use trinkets use an average of the stats they provide. Combining these trinkets with cooldowns or waiting for full energy etc will give these trinkets better dps.
Combat Potency is not fully modeled with Mutilate. Since this spec cannot exist, there was no reason to correctly model it.
After some testing on Windfury, it appears as if sometimes more than just the extra attack can receive the windfury attack power bonus, only the extra attack recieves the bonus in the modeling.
Windfury modeling is not 100% correct due to a hidden 3 second cooldown.
The sheet assumes that there are non-integer values for skill level obtained from skill rating. The game probably only use integer values.
Sometimes, activating the 2p Netherblade set bonus causes your dps to go down because the cycle sheet assumes you are wasting CP instead of SND.

 

rj

This thing rocks, thank you for your hard work pf.

 

♦ Kalman

Having devised the original and helped out with the merge, I'd like to point out three things about the little line labeled "CP/Cycle analysis sheet merged".

1) This means that the DPS contributions from Relentless Strikes, Ruthlessness, and other CP/energy related talents are modeled far more accurately, making the sheet valid for build DPS comparisons. It also leaves the capability open to add in SF modeling in the future, although SF modeling will always be much less accurate due to the difficulty of modeling SF's waste component (crits when already at 4 CP, etc.)

2) If you have a dagger MH, it assumes you want to backstab. Otherwise, it'll hemo if you have the talent and SS if you don't.

3) We added the most common/best cycles we could think of. If you think your cycle is better, add it and see. If it is, let us know. If you don't know how to add a cycle, let us know, but it's really not that hard to figure out.

<Melador> Incidentally, these last few pages are why people hate lawyers.
<Viator> I really don't want to go all Kalman here.

Clearly law school has done wonders for me.

 

rvnlrd

Thanks alot for this.

Btw, it's Winterfall Firewater not Winterspring Firewater. Not a big deal but might want to change that.

 

Lodfish

Thanks for all your hard work on this PF, Kalman, and if you're out there, Chalon. =o)

 

pf

ty Demi:

Uploaded a new version fixing the error.

 

pf

Ok, Valar did the TF proc modelling. Since noone in my guild has a TF, my knowledge of it is limited. Anyway, I'll explain each modelling so you can choose which one you want to use.

Regular model:
Uses the white dps only TF's DPS (or about 40ish). Then it adds 23 damage per white swing (instants/evis/sword procs not included). This 23 damage cannot crit, nor can it be resisted. Finally, it adds the proc dps assuming a 6ppm proc of 300 nature damage which can be resisted.


Alt model:
Adds the +nature damage as physical damage. This lets it be added more accurately into sinister strike calculations. Then it calculates the proc in the same manner as above.

Both modellings have upsides and downsides. I'm not sure which one is more accurate, but I'd use model 1 if you are worried about BWL, and model 2 for MC/AQ/Naxx as armor values are much lesser outside bwl. If anyone knows exactly how the +nature damage with TF works (can it crit, can it be resisted etc, is it added to sinister strike or evis, etc), please feel to tell me.

 

LadyVex

Ok I am a noob but what the heck program can I download to let me view that? ;p

 

pf

www.openoffice.org

You need openoffice Calc.

 

LadyVex

TY sir.

 

roq

pf
Would you rather have Bugs posted here or on the WoW boards? Which boards do you check more often. Oh and did you get the Offhand enchant bug i posted on the WoW boards earlier?

 

Voljun

Thanks for the update on TF. I would love to test out the nature damage portion of it, however I am not sure of the best way to test it out. I do know that it works through BoP. I haven't seen it crit or be resisted, and don't know if it works on SS or Evis.

If you want, get a guildie and we can test it out :).

 

pf

It really does not matter. It will be seen no matter where you post it. But, if you post it here rather than the WoW boards, you might get an intelligent response from someone else before I see it.

The extra combo points you gain are ignored in a 5snd cycle, if you have a different cycle, they will help it. Instead of actually saying you backstab more, it is modelled as if each backstab costs an appropriate amount of less energy. (if this is wrong, I'm sure kalman will say so)

I will look at adding that buff. I know there are a lot of buffs that are not in currently, and thats just one of them.

 

Roland

Very nice work, and even more accurate than the last iteration.

 

pf

Using BoP is the only way I can see reliably testing it (unless the combat log makes note of the NR portion). I might have to take you up on the offer, but probably not anytime soon as non-raid play time is becoming harder to come by lately.

ty, and releasing new versions is usually about being more accurate. Unfortunately, we are not perfect and have to keep fixing stuff that we did wrong to begin with :)

 

• frmorrison

Thanks for the good work Pf.

I wouldn't worry about testing TF too much. Very few people have it and may replace it soon to give it much worry.

Millions of words are written annually purporting to tell how to beat the races, whereas the best possible advice on the subject is found in the three monosyllables: 'Do not try.'

 

♦ castille

Any idea how Combat Potency is going to be modelled yet? ;)

23:40:55> [Illidan Stormrage's] [Shear] was blocked by [Castille].

 

♦ Kalman

There's a coefficient in there called EEC which is used to handle energy generating/consuming abilities. Unfortunately, it'll probably require a circular reference, as SnD uptime affects CP energy generation, but energy generation affects SnD uptime.

<Melador> Incidentally, these last few pages are why people hate lawyers.
<Viator> I really don't want to go all Kalman here.

Clearly law school has done wonders for me.

 

pf

It is always nice to get things done correctly. Especially when blizzard could easily make a lot of weapons that include +magic damage. And testing really shouldnt take a long time. Should be fairly obvious if it crits and if it can be resisted. 2 BoP's is probably all that is required.

 

• frmorrison

Good point, magic damage on melee weapons is a neat dynamic and may be used again. Since the nature damage should count as a spell, it should do the 1.5 crit using your spell crit rate (which I assume for a Rogue would be around int/59.5), which is less than 1%. Rogues in the beta should be able to see the spell crit rate (assuming the client allows you to select it).

I have seen screenshots showing resists, but it could have been a case of the combat log being wrong.

Millions of words are written annually purporting to tell how to beat the races, whereas the best possible advice on the subject is found in the three monosyllables: 'Do not try.'

 

• Andeh

So I was playing around with the latest spreadsheet (2.0.1), comparing my current gear to if I picked up a nice new MH dagger, like Maexxna's Fang (and of course swapping in the essential ACLG). With ideal Horde raid buffs, I was surprised just how close swords came to daggers (within 11 DPS). Is this due to changes in your Windfury model, to the new cycle features, to the implemented Ruthlessness/SND talents, or a combination? I might really rethink switching to daggers if this is the case.

<Skunkworks> - Progression Raiding in Two Nights per Week

 

pf

Or does the nature damage work a lot like arcane shot and continue with the melee critrate/multiplier. Does it crit independantly of the sword (this would be near impossible to test)? A paladin in solid NR gear and a few BoPs should answer most questions about the proc.