I've been working on Bolche/Leulier's spreadsheet in order to make it 3.0 ready. I'm currently doing this on my own and have it in a semi-working condition. I'd like to post it somewhere so people can start looking at it and finding any problems in my additions. So until I find a good spot for hosting the file, does anyone have any good ideas for modeling the following talents: Eradication, Backdraft, Demonic Empathy, and Demonic Pact?

Also, does anyone have any recommendations on a spot to host? code.google? sourceforge?


Thanks,
Bakka

I'm working on a "new" version which calculates DPS by pseudo-simulating a fight rather than determining average cast ratios. I figured this was a cleaner way since the number of choices in spell priority are becoming more complex than the old template can really handle (since it really only chooses yes/no for each spell). I have destro and affliction almost done and taking a deep breath before I dive into demonology. I'd be interested to see the one you have when you find a host so that I can maybe borrow some elements where mine lacks.

Ok. I'm going to be using my guild site to host the file temporarily so some can start looking at it.

http://dkpfiles.com/unholylegion/for...ck_dps_v30.xls

A few things about it's current state.
- Loading of talents: though it works, the talents are no longer properly defined so there's no telling what you'll end up loading if you load a spec.
- All TNS(The Next Stat) functionality has been removed for now until I can make sure current stats and dps are relatively correct.
- I'm not entirely certain some of the numbers I'm using for new spells (chaosbolt, haunt, etc) have the correct dmg coefficients and mana usage values.
- Same goes for initial pet stats for a felhunter
- Pet dps implementation still needs work. Pet dps didn't matter too much prior to 3.0 as everyone sacced. Now it needs to be more accurate and alot of the equations for pet dps are very rudimentary.
- Still need to formulate a model for demonic empathy and backdraft.

I'm very glad some people are working on a spreadsheat for 3.0 ^^

Baka's sheat looks very good, I'll take it for sometesting once I have some time. Just browsing over it I saw some problems.

Glyphs will be implemented with this patch so they should be reflected on the sheat.
Items that have one tipe of splldmg (fire or shadow spelldamage) will be changed to give regular spellpower.
You might also want to include former healing gear that can now be usefull for locks.
Spellstone and firestone will now work as oils. Spellstone applys 1% more damage for periodic spells and 40 haste, firestone 1% for direct damage spells and 35 crit.
Some of the destru builds I have seen use incinerate as a filler but shadow bolt after casting conflagrate. This rotation can't be calculated on you sheat.

Thankyou for taking your time to update the sheat. I hope my observations can be usefull for you.

Thanks for the comments. I do have future plans for most of that stuff, but my primary concern atm is getting the spreadsheet just up to being accurate with the data(no glyphs, current gear, etc.) that it has available now.

I wasnt aware of the change to firestones and spellstones; thanks for that information.

What's the logic behind this (SB after conflag)? The only thing I can come up with is because of backdraft. And are you saying they use conflag, 3xsb, immo or just conflag, sb, immo rotations? The first is the only thing I can see which would put backdraft to work, but putting off immolate for that long also seems bad for dps. Granted I havent done any experimenting with it on the beta or tried looking at the math for such an idea, so I'd be interested in seeing any formulas or data others have done on this. As far as the ability to add this, I don't see why I couldnt add some sort of conflag>backdraft cast rotation. I'd been thinking about how to properly model this and I think I know how now, though it would take some work so I'll probably put it off for a bit until I'm confident alot of my other changes are accurate.

Thanks!

Nice update to the sheet, though i have a question.

Is the Life Tap used in the sheet the rank we use at 70 or is it the one at level 80? I ask because my life tap with everything I have plugged in should be around 1400 or so (dismal now, i know) but the sheet is listing it as being around 1900 or so which would coincide with the level 80 rank.

RE: Latas
The sheet is meant for L70 currently (I'll update it for 80 once wrath comes out and I know the majority of what I have is accurate). The equation I have for lifetap is for L70 so if you would please post what your spirit was at the time of casting the lifetap, the amount it returned, the amount of dmg you took, and whether or not you have any point in improved LT, I would appreciate it.

RE: Daidai
- Malediction is increasing spell damage. I'm treating it as if it was a buff (like BoK); it's effect is listed on the Gear_Buffs sheet.
- Firebolt fixed. Thanks for the find.
- I didn't have ISB working for anything properly in the version posted. I've added that and will post the new version this weekend once I fix a few more things.
- Fixed. Thanks again.
- Please supply the same data as requested of Latas.
- In regards to the crit difference, if you can post your spreadsheet somewhere so I can see exactly what values you're using I can probably debug this better.

Thank you both for the feedback. I should have a new version available sometime tomorrow.

The sheet is listing my spirit as 174 but the life tap value is showing at 1962, which doesn't seem to follow the 710+(3*spirit) formula that it should be taking from for the level 70 version. Following the set formula it should be listed at 1232. This is also without any points in improved life tap.

New version : http://dkpfiles.com/unholylegion/for...ck_dps_v30.xls

A few things to note, The Next Stat data is out of whack. I'm going to hold off on fixing it until I get other issues ironed out first.

I've been unable to replicate either of your life tap problems. I have 150 spirit and it shows 1100 lifetap (or roughly). I've even played with it on Beta and put pts into Imp LT and it still comes out with the right numbers. Perhaps that version of the spreadsheet I hadnt gotten around to fixing the LT value yet. You should see =(710+spirit*3)*(1+imp_lt/10) in cell L8 on the DPS worksheet.

Notes about using the backdraft sequence. If you put points into backdraft and use conflag it assumes you're using the backdraft sequence. Regardless of whether or not you have immolate in the sequence, make sure you are still using it on the main selection. However if you use chaosbolt in the sequence, do not select it in the area.

I also fixed malediction, I checked the beta and malediction wasnt affecting your item spellpower as I thought it was. So it is now present in the dmg equations.

Look forward to hearing any more problems, comments, or suggestions.

ISB should not affect dots
World of Warcraft - English (NA) Forums -> [bug] ISB not affecting dots

I've been testing some things on the ptr and Haunt seems to affect Doom for me.

Drain life and drain soul are affected by shadow embrace.

Strangely shadow embrace doesn't affect doom, and haunt doesn't affect drain life ore drain soul

ISB affects haunt (since it 's not a dot)

Shouldn't improved soul leech increase the Imp's dps since it keeps him from going out of mana?

Bakka, i testet the new spreadsheet, and it looks fine basicly.
I think, we are near a realistic simulating spreadsheet, great work.

I did some tests with a Affli-spec 53/3/5, casting 15minutes on a dummy.
I got 1800dps, the Spreadsheet calculates 2050. I am not sure, were the issue is, i do not think having problems with my rota (maybe 50-100dps, but not 200+).
I will do some tries again.

Regarding the chaosbolt, i think i forgot to learn Rank2 (if this rank is available).....actual i have only 1.36seconds casttime after Bane on the PTR. I will check that after work. My fault, i hope i did the same fault with Haunt

But i am really in doubt with Backdraft. The Tests on the PTR are showing no significant dps-increase with Backdraft (definitly the tests are heavy depending on critluck, but i did a lot).
The spreadsheet calculates +200dps when activating Backdraft.
Maybe there are bugs on the PTR (critbonus for conflag for example).

Regarding the MC-Uptime: Immolate cannot trigger mc, only the shadowspells.
Maybe it would be better, decouple corr and coa.

It wouldn't surprise me if I still have some outstanding errors preventing accuracy. Something to make sure though is if you're doing test dummy work to remove all the debuffs from the spreadsheet. They account for roughly 200dps for an affliction spec.

Rank 2 Chaosbolt is a 2.5s cast. Bane would only bring it to 2.0. You have a ton of haste if you're getting it to 1.36.

I find it hard to believe backdraft wouldn't show a significant dps increase. The 30% haste boost to 3 spells post conflag should show significant increase. It effectively allows you to get an extra incinerate off per Immolate rotation.

I assumed MC would be triggered by immolate as the tooltip indicates periodic damage. Damn blizzard and their inaccurate tooltips. What do you mean by decoupling corr and coa? The MC model changes based on what dots are being used; so in that sense they are decoupled.

If i decide not using corr, only coa, mc-uptime wents to zero (i cut out immo, cause it doesn`t effect mc).

Okay, i definitly forgot learning Rank2 of CB....and with that maybe haunt, if there is a Rank2. This makes me happy...

I do all calculations without any debuffs first, and check them on a dummy.

Regarding backdraft: a lot of people do not see increased dps, when using backdraft.
What i noticed: backdraft is fine to stabilize dps (when the rota is fine i noticed an increase of 50dps), but i haven`t seen a dps increase up to 200.
After reading some issues with conflag and F&B i think it is a problem/bug on PTR with conflag and its Crit-Bonus.

I compare a static cb-immo-inc-inc with a backdraft-implemented rota.

Fixed on my end. Under the models sheet change the coa formula from use_corr to use_curse. Bad copy/paste apparently.

Thanks Bakka, especially for such time when we were all confused with our specs, you actually worked the spreadsheet again for us. By the way, it shows that with haunt i can throw up to 2k dps when I actually tried on the dummy with putting up at most with 1.3k dps. I'm not sure what went wrong, but with Haunt spec, do we put our felhunter into combat to attack or just to dark pact? Also, I did try it on PTR without any other addons but only recount, however, I should assume I should not be doing such a great different of dps that shows on your spreadsheet compared to what I have really tested on dummy?

I've spent a few hours on the beta testing stuff and found quite a few issues in some equations. So the next version I post will have a few fixes.

It will also include glyphs.

The calculator uses haunt as a spell not a talent, so just enable it if you have haunt. As for the haunt spec pet usage, with imp felhunterx2 put the fh on attack and it will regen mana faster than you can dark pact it off him. DP also returns more mana than LT w/ imp LT(at least it does with my crappy spirit) so it's more efficient to DP with a felpuppy. It gives you infinite uptime.

Thanks for your reply. Looking forward for your updates. And thanks for that extra information about felhunter. By the way, I was wondering why spec 3/3 Malediction when the recommended spell is CoA?

Because it's a 3% dmg increase to all your spells.

And while we wait on the servers to come up and find out what again they've changed:
http://dkpfiles.com/unholylegion/for...ck_dps_v30.xls

This may be a stupid question, But is there an easy way to update an older spread sheet from version to version, or do I have to rebuild it each time?

Thanks

Also, can you add [Purified Shadowsong Amethyst] to possible gems?

the patch notes can be read here, quite a lot of changes from the last ptr

WoW -> Patch Notes -> Current Patch Notes