The amount of aff debuffs needs to go to 15 up from 12.
Soul Siphon - WoWWiki

What a great tool...thanks for the effort in putting it together and keeping it updated and thanks to the community for collaborating to make it better.

One thing I've noticed, though, is that the spreadsheet has gotten really quite complicated. A lot of casual players now use it, with people of varying Excel ability diving in and playing around with the assumptions. Accordingly, I've met a lot of people out there who are worried they aren't setting it up or using it correctly.

I think adding a relatively robust guide for first-time use, either as a sheet in the model or on your website as a FAQ would be really helpful as the community of users continues to grow. I've searched the forums and elsewhere and have really struggled to find a guide that helps the average user get the most out of the spreadsheet.

If this already exists somewhere and is accurate, would someone please link it? I'd write it myself, but I'm not particularly talented at explaining things in simple, intuitive ways...

Cheers--Kruck

Hmm, after a long time waiting for the new spreadsheet by Leulier, I've made my own.
I am not sure if my calculates are correct. After a many tests and measurements i got this one HERE
for my affliction wl (56/0/15) with the "Corruption", "Siphon Life"- and "Curse of Agony"-glyphe.
And today: I can find the spreadsheet here nevertheless i want you to proof it

(I didn't add trinkets, gems, individual talents, potions and some other things, because I found this thread here)
and now i want to know if it it's worth to work on

I only have the german version of excel, i hope it is compatible to the english version...

perhaps this spreadsheet could become its own thread, but i'm not sure

edit: my guildmates realize a little bug with Eradication... i will fix it


-Racheengel

The spreadsheet is giving me #DIV/0! error's in the dps bonus and +dmg sections for hit rating and haste (other places two but those are the more important sections) but all the other stats are calculating fine.

Running it on latest version of open office.

which version do you have? or which version shall i export my spreadsheet to avoid the DIV/0 error? (i have the german version 2003...)

Is anyone else having trouble w/ the new version of Leuliers's Spreadsheet? I get N/A for all DPS values after loading from the armory...

I think that's a an issue with the iterative calcs. Here's how I fixed it: Go to the DPS sheet and look for spells with NA against them. Toggle them off and on again and it should clear.

***

One gear request - a lot of players I know are still raiding with a few pieces of T6/Sunwell gear. Could those items be added back into the gear list, especially since the checkboxes to include/exclude them are still visible?

Ok I was playing around with your spreadsheet and did see something weird. With my talent mix and gear it listed 4579 dps with night fall and glyph of corruption. If I dropped night fall and did not get anything to replace it my listed dps would go up to 4594. If I dropped the glyph but kept nightfall it would go down to 4550. If I dropped both night fall and the glyph it would go down to 4521.

So it may be weighting the glyph more that 2/2 in nightfall. And 2/2 in nightfall + glyph = dps loss.

Didn't fix it I literately had to turn every spell off to clear the N/A, turning them back on just gave me the error again. I have had no problems with earlier versions of the spreadsheet...

fixed by disabling then re-enabling all spell fields.

also found a bug - Demonic Empowerment is lowering incinerate damage, I can only guess the spreadsheet is still counting it as though it triggers gcd.

I found that the gear import didn't recognise my Meta gem (using +25/+run speed) and as a result was returning a #N/A value for that cell (G9), which cascaded into all the other DPS calculations. Changing the Meta to the equivalent Ember gem fixed the problem, and I need to replace that Meta anyways

Regarding the Talents sheet: The 'Destro Imp Incinerate' build seems to be short of a few points, its 0/3/56 as far as I can tell when it should be 2/13/56(or thereabouts). On a minor almost cosmetic point it might be worthwhile setting up the 'load from talents' template to use Immolate and Corruption as standard, as I suspect they'll be a DPS increase for most other builds and should be encouraged.

Talents sheet - Didn't import Imp Demonic Tactics correctly. I have 3 points but it only showed as me having 2.

With a 1 minute cooldown, making it pretty good

I'm pretty sure the fire seed effect was removed.

Took me a minute, but here is the post I was thinking of: World of Warcraft (en) Forums -> Fire seed not working.

Great spreadsheet!

But could you do something about the pet buffs? especially melee buffs to the felguard. it can be hard to find out exactly how much crit/haste/AP get gets from buffs on my own.

Thx

I'm sure this has come up before, but the spreadsheet doesn't operate properly in Mac Excel. When opening, it generates an error about renaming cells (which it does), and then breaks everything.

I've noticed this as well, I believe the intellect to crit % ratio is wrong. On my character screen 938 intellect is giving me 7.33% crit while the spreadsheet is calculating it to be 11.439%. So 938/7.33 = 127.9673 therefore the amount of crit% your int gives you should be about intellect/127.9673.

Indeed. Here is the error:

Thanks for the spreadsheet... since I cant delete my post.

New version, you know the drill

I'm currently working on getting the Imp pet dps correct but I need some help. According to wowhead, the rank 9 firebolt does 199-223 dmg. According to my own tooltip with 0 talent pts spent, it does 213-239. And using the L80 dummy and letting the imp go to town, I see a range of 224-250. I'm wearing 0 gear so there should be no boost to his dmg. Anyone else able to duplicate these results or have a reason why I would be seeing these results?


Thanks!

Forgot I'm an orc so the difference between observed and tooltip is the orc racial. However I'm still curious whether or not everyone else has a tooltip of 213-239 for their imp firebolt spell (with no talents). In which case wowhead is simply wrong. Or do some people have the same tooltip as wowhead in which case, why is mine different.

Orc racial and/or glyphs possibly.