supercres

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

 

Kruck-US

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

 

Racheengel

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

 

Seir

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.

 

Racheengel

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...)

 

Phearbot

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...

 

Kruck-US

I may be wrong, but I believe this is a common problem with spreadsheets that use iteration. I fixed it by turning spells off on the dps tab, especially corruption...clearing the error out of the calcs...then turning them back on.

 

Lurker37

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?

 

Evyle

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.

 

Phearbot

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...

 

Seir

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.

 

Turmeric

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.

 

Rozzenwyn

Is Lightweave Embroidery calculated? I see it is listed as a back enchant but it causes no change in DPS when I use it. So I checked it out on the enchants tab and see no data there for it. It must make some change in DPS even if its very small. This is easy for me to get so trying to decide whether or not its useful or if I need to round up mats for the haste enchant instead.

Also can Fire Seed be added to the consumables area like where flamecap is. I'd add it myself but not sure how to calculate its worth. It's 200 spellpower for 10 secs and makes you more vulnerable to magic.

 

Rozzenwyn

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

 

Leshrac89

With a 1 minute cooldown, making it pretty good

 

Desaix

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.

 

Mardal

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

 

Mindaika

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.

 

imtsensational

Is there anyone else besides me who has inaccurate crit ratings? On the DPS tab, my total crit % is listed as 18.54%. My character only has 14.66%. I have a total of 387 listed on the Gear_Buffs tab, no raid buffs/consumables, and no talent points invested into +crit.


I had this problem with v303e, but with v303g, the crit % got inflated even more. What's going on?

 

Aedius

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.

 

Altyera

Indeed. Here is the error:

 

• Nokbane

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

 

Bakka

New version, you know the drill

 

Bakka

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.

 

Akj

Orc racial and/or glyphs possibly.