Eggnot

Many thanks for the effort you (and contributors) have put into this. While I have done some minor modelling on DPS I have never taken the time to get into as much detail as you have, rather concentrating on individual spells.

I do have some suggestions though that I have included in the spreadsheet. Nothing fancy, mainly small things that help the overview of data included. These are:

• Table including Tooltip Crit as well as fields for additional crit rating and crit from talents.
  
• Table including the various spell damage you have currently and also room to add (or subtract) more damage.
  
• Table including current spellhit and changes from new gear.

All this can of course be done by just adjusting the figures in the current spreadsheet. However, adding different (short) tables for it do give a better overview. Minor, as I said, but useful none the less.

I would also welcome a table including trinkets. Any passive +dmg is of course included in the earlier data but having on use effects included (and also an approximation of how often it is used, as a perfect use is unlikely) as well as procs and on hit. I did a simple version of it for what I used but to extend that to include Maggy's eye - for example - should be simple (if I had it, I would). Trinkets such as Darkmoon cards are somewhat more complex but hopefully not too tough (have it, so far I've just added a flat full impact from go for it, which of course is not correct).

Again, great work and do keep it up for all of use!

 

Nimh

Very nice spreadsheet.

Erm, can someone do me a favour though please, I only have excel on my work comp, not my home one, and so can't use the spreadsheet at the moment.

If i give you my basic stats would someone be able to work out how much certain stats are worth in comparison to each other please?

Lets say i have 9000 health, 9000 mana, 14% crit (untalented), 100 +hit, 1100 shadowdamage, and 900 fire damage.

With a 43/0/18 spec (Talent Calculator - World of Warcraft), casting CoS, then all my DoTs, then SBing until DoTs need refreshing etc, how much would the following stats be worth in comparison to spelldamage?
1 spell damage = 1
1 spell hit = ?
1 spell crit = ?
1 stamina = ?
1 intellect = ?

And then, the same again, but for a 40/0/21 spec (Talent Calculator - World of Warcraft), and if possible, also for a 0/21/40 shadow build (Talent Calculator - World of Warcraft).

Thanks for anyone who'd be willing to look into it for me.

 

• frmorrison

The free Open Office should open this spreadsheet for you.


Regarding trinkets, this spreadsheet modeled some of them http://www.sloinfo.com/uros/nenad/damage_calc_70i.xls

 

inktomi

Ok. I downloaded this spreadsheet, and have it open in Excel.

How can I add dots in that are not in there when you originally open the spreadsheet?

I'm heavy affliction, but I can't seem to add Curse of Doom into my "rotation" here in this sheet.

How can I get rid of CoE to add CoS.. get rid of Conflag.. etc etc?

I'd like to get my usual boss-mode dots in there.

Unstable Affliction - Corruption - CoD/CoS - Immolate - Siphon Life

 

• frmorrison

The spreadsheet has boxes you check in order to cast the DoT. This is very useful, say when you are UA spec and you want to see if Immolate is worth casting or if Corruption is worth casting if Shadow Destro spec (the answer, it depends).


Regarding Doom, there is another box that says curse used, I think the default is Shadows, so just click it to change it to say Doom, then make sure Doom shows up in the spell section.

 

inktomi

Ah hah!

Chalk that one up to my excel newby status. Thanks for the quick reply.

 

Malakit

Think there is a flaw in the haste rating. It was not changed to 10,5 rating per % but to 15,77 or something close to that.

I have not tested it much as I only got one item with spell haste. But it is pretty simple to test with this command:

/script DEFAULT_CHAT_FRAME:AddMessage(GetCombatRatingBonus(20))

It returns your haste %. As I got the RoAK from BT with 31 haste rating on it returns 1,9658534526825.

 

• frmorrison

I don't think the author is still updating the spreadsheet, but Spell haste rating can easily be changed yourself, just delete the pre-2.2 number and type in 15.77.

 

Malakit

I know you can change it yourself.

And it was updated recently:

1.15 - 2007/09/28

* Change "haste rating -> haste" to the 2.2 value (10.5 haste rating for 1% haste)

 

Wooglin

I thought that spell haste was changed back to a value of around 15.7 ~ 1%, not 10.5 ~ 1%? Can anyone confirm this?

 

Ele'

I confirm:
WoW -> Patch Notes -> Current Patch Notes, patch 2.2.2

 

Bolche

Fixed !

Sorry for the mistake.

I'm still updating the spreadsheet to match the changes in wow mechanics. I don't currently have time to improve it, but I still plan to do it sometime around the end of the month, by adding importants trinkets, metagems, set bonuses etc.

 

plopinou

To know the exact rating conversion for each stat, you just have to look at StatLogic-1.0.lua (ace2 library).

It used to be 40/3 for spell haste and 20/3 for melee haste (@ lvl 60)
Both where changed back to 30/3 = 10 (@lvl60) which is a nerf of 33.33% for melee, and an up of 33.33% for spell.

The general formula for lvl >=60 (directly taken from the code) is :
rating/base_rating * ( (-3/82)*level + (131/41) )
= rating / (base_rating * 1,577) for level 70.

Hence the required 15.77 haste rating to get 1% haste for melee and spell.

 

Debuff

Has anyone else noticed that this spreadsheet seems to be undervaluing +hit? I entered my character stats (normal 41/0/20 build) with 1050 +dmg, 12% hit, and 11% crit and it is telling me to value hit to +dmg at a 1:.59 rate. This seemed a little low to me especially considering about 35%-40% of my damage in a fight comes from shadowbolting. I even tried removing all of my points in suppression and inching my +hit from 0% up. At about 1% hit rating it started valuing +dmg over +hit.

Can anyone account for this? I always heard that it is necessary to have your hit rating maxed out on boss fights or your dps will severely suffer. I assumed when I used this in the past that the reason for such a low value in hit was due to me being affliction and having points in suppression. It was until recently that I noticed the low value of +hit even when I have no points in suppression. Could this be because the nature of an affliction build is that you will get less of a penalty on a resisted spell (which will would likely be a dot assuming no points in suppression) since you only lost 1.5 seconds of cast time as opposed to 2.5 seconds of cast time if you were a SB spamming spec?

 

Alethasis

This is great, thank you tons. Wanted to add that you don't have threat incorporated, of course you'd have to have sufficiency of tank, but if a guild's using a spreadsheet to go off of recruitment, talent points (for myself at least) need to be placed in both Imp Drain Soul and Destructive Reach.

Cool thanks again

 

Farad77

I'm glad someone else noticed it. I'm felguard spec with 1% hit, and the spreadsheet keep telling me that hit=dmg in dps bonus. I was thinking that i would be a funny thing with the felguard spec to be a viable pve spec without capping hit rating. Because as i gain +hit, it's profitability decrease and not +dmg or shadow dmg.

But with affliction...Perhap's there's some kind of bug in the leulier's spreadsheet? Or the common knowledge that +hit is the superior stat for pve is crap?

 

Tacitus

This is a bit hard to search for so I'll need to ask it here. Why do I get different numbers with 23,82 and 23.82? I know that US and EU (dunno about brits) use them differently at decimals, but I'm not getting that much of a difference. When I switch my crit from 23,82 to 23.82 I lose about 300 DPS :/ (1364->1018)

Brotherhood, Peace, Unity

Welcome back, Comrade

 

Vremenno

With the stats you quoted plus 5/5 suppression, only 36% (SB) + 15% (Immo) of your damage is benefitting from hit, assuming you're casting CoS and every other spell. Spell hit rating is really good, but when you can tack on spell damage to your already hit capped, high coefficient spells it gains in utility a lot faster than hit rating will.

Same argument at lower +hit values. Better coefficients plus less cast time lost from a resist. Honestly, I just think everyone got too excited about +hit. I never thought you should aim to cap it at the (even slight) expense of any other stat.

Having said that, I'm just trying to explain what I'm seeing. But the values don't feel odd to me, at all.


Just tried this and it messed up the whole spread sheet for me... Nearly everything is showing #VALUE! now. And won't change back.

 

Gaborn

Deactivate both Dark Pact and Life Tap, and activate them again. It usually works for me.

 

Vremenno

Ah, that worked out to set it back to normal.

But, still having any damage, crit or hit value with a comma in it will show "#VALUE!" in all relevant columns. So much for recreating the problem. Are you using the most recent version (1.15 - 2007/09/28), Tacitus?

 

Altyera

This started out as a rough calculator to assist me in planning my own gear strategy. After using it quite a bit, I decided that I wanted the ability to quickly compare more gear without manually calculating and recalculating the various DPS values for different specs, etc. Since I was making it functional, I figured I might as well make it pretty. And if I was making it pretty, I might as well make it simple to use and post it for other people. So here we are.

http://raiding.isserious.biz/files/W...rison_v0.1.xls

This is a Gear Comparison spreadsheet designed to be used as a companion to Leulier's spreadsheet. After determining your "The Next Stat" values for a given spec at a current gear level, input them into this spreadsheet to determine the exact DPS value of any piece of gear (except trinkets, which are difficult to quantify and already covered in great depth here). All of the top items for raiding warlocks are already included in the spreadsheet and the pre-entered items can be replaced or expanded upon without limitation.

The calculations are fairly simple, so I don't foresee many bugs cropping up, and I'm not sure how much effort I'm willing to put into expanding functionality. That said, I welcome any feedback that people may have.

 

rochan

This is a really good tool for min-maxers. I had created a similar spreadsheet (although not as purty :P) for myself to choose which items to get from BT/Hyjal, but I was too lazy to add the new ZA items.

Although it's easy to add items, I'm sure most readers of this forum would want to see some more "entry-level" items in addition to the best of the best.

-Also, if you're adding the Raid DPS from ISB from crit stat, you may want to add a Raid DPS from ISB from haste stat.

-Also maybe a box to relate how 1 shadow dmg = dmg, fire dmg = dmg etc.

-Could indicate beside each item what zone it drops from

PS. Damn vestments of the sea witch sooo overpowered! only dropped once for us

 

Altyera

/lazy

Probably a good idea, but the whole concept of ISB uptime/consumption in a raiding environment is so nebulous and difficult to model that the miniscule effect of spell haste is absolutely dwarfed by the magnitude of my "hmm about 3,000 raid damage per proc" guesstimate. Crit rating (and therefore proc rate) at least scales linearly with the nebula rather than getting lost in it.

Yeah, that occurred to me, but incorporating the conversion would have required massive modification at that point, so for now I'm hoping people can take a queue from the +shadow items I've included and convert their own values in the base stats.

How about plugging Wowhead at the top of the sheet? /lazy

Us too. My ninja skills were finely honed that evening.

 

• frmorrison

This looks nice, basically it is a buffed lootzor (since it has haste calculated and you can set the values of gems, rather than using blue gems or having all 14 damage gems).

Damn, the drop drop is really superior itemization, 3 sockets plus mixing 5 stats ftw.

However, another example of really good itemization is ignoring stam/int, like the Belt of Blasting or the Anger spark gloves. I was surprised Anger-spark ranked so high.


For feedback, I would like to be able to enter a value for stamina, like you have for int. While stam will not kill a boss for you, it will help you live and fuel your life taps, so I give personally give it a value of .15.

Edit: More feedback, Cuffs of Devastation have a yellow socket (no socket is shown) and when sockets are there, you assume the same color is used and that turns on the bonus. If you want it to remain that way, I think you should write a note.

 

Trickykid

I added a dynamic way for the DPS spreadsheet to include ISB uptime for haste and crit (after you entered in some basic data for the shadow-DPSers in your typical raid). Unfortunately this doesn't stay the same across any variation in play. I have it running off of the Leulier spreadsheet using the cast%s I set up on there. If