Rallik

A few bugs in the latest version:

The +dmg% calculation in X45 uses .02 for Sanctified Retribution instead of .03

The Death Wish uptime calculation uses 1/(6/(1+.11*IntensifyRage)) which gives a wrong value. It should be 1/(6*(1-.11*IntensifyRage)). The 33% off for 3 talent points makes it 67% cooldown time, not 1/133%=75%.

Abomination's Might is (1+.1*H54*I54) instead of (1+.1*H54*I54/100)

Yellow attack crit bonuses are stacking wrong. 1.272 with meta+impale should be 1.266. Changing it to: "=(2+0.1*V10)*(1+0.03*M141+0.01*V14*I27)-1" fixes the problem.

Also, all the raid buffs that don't stack just multiply together instead of taking the maximum effect. A simple MAX(buff1 calculation;buff2 calculation) surrounding them should fix it in pretty much every case.

 

• landsoul

Crit stacking bonuses are correct. This was proven on EJ when RED first came out.

Sanctified ret is 2% only, not 3. The hunter buff goes up to 3.

Death wish: *(1+0.2*deathwish*1/(6/(1+0.11*talent))) this value goes up when talent goes up, no error here. Imagine A*1/5 with talent and A*1/6 without.

Also, any buff that is different multiplies on itself. I'm not gonna take so many extra coding steps so early in development. If you are too stupid to stack the same type of buff that doesn't stack in the game you are just retarded and I don't want to help you. It's clearly laid out and one should learn to play before they use my sheet.

 

• landsoul

I Got a release ready for the 5% TG, Deep wounds nerf, and 5 second / 50% BT patch. I'll post it during the patch maintenance.

Oh and By The Way, if you don't have glaives, start working on your TG equipment.

 

Nikodermos

at 80 the glavies are still viable ? or you talking the 2-3 weeks of 70 still left? If you mean that they are still viable at 80 i'll be a lil heartbroken that they are the only viable option next to TG, i am hopefully that a DW Arms or single 2h'er arms build will emerge and still be a viable option.

 

Machinator

I would double check that, I tested a while ago and found a crit with impale and RED was 2.266 of normal. I dont have the test log anymore but I might be able to do another.

"Information is ammunition."

 

Ceara

I have a couple questions.. I've searched for the answers, but all I seem to be able to find are stats for dual weilding.

I normally play a mage, but with the last patch, have finally been able to trying my Warrior out in PvE as Arms. I'm loving arms, and just picked up the Badge axe, but can't figure out what to put on the axe. I had orignally thought Mongoose would be the way to go, hearing it procs based on PPM, but I've been seeing some things stating that Executioner is the way to go. Any help is appreciated.

Also, quick question that I think I know the answer to, but I'm looking for 9% (142) hit as arms using a two-hander, yes?

Cheers, thanks.

 

Gruntle

You have made an error here landsoul, Rallik is correct.

In your version having 3/3 Intensify rage makes the cd of Deathwish 180/(1+0.33)=135 s. The real value is 180*(1-0.33) = 121 s, which was what Rallik pointed out.

 

Rallik

I tested in game with BT before making the post. RED/Impale was exactly 3% more damage than just Impale. That would be 2.266, not 2.272.

Sanctified Ret will be 3% in the expansion. I didn't notice it's still only 2% currently on live.

Death Wish does have an error. Your implementation clearly will result in 1/(6/1.33) = 1/4.5 for uptime, when in reality it is 1/4(30 seconds out of 120).

"So many extra coding steps" took me about 5-10 minutes to completely implement for every buff on the sheet. It mostly involved the incredibly arduous task of typing MAX(, replacing a '*' or '+' with ';', and adding a closing parentheses. Mind-boggling, I know. There was no need to get angry when I made a simple suggestion for the sake of proper design.

 

• landsoul

I'm not trying to alienate, I just get frustrated. Got a lot on my plate right now.

I'm sorry Rallik I did misread your deathwish correction. I'll get that changed. Sorry.

 

• landsoul

I personally tested RED, again. Rallik, Machinator your test is Fubar somehow. Try different high AP levels against diff targets.

I sundered a priest down to zero armor.

My crit BT hit him for 3395 with 3256 AP.

3256 AP *.45*1.02(unending fury) = 1494.504 BT hit.

3395 / 1494.504 = 2.271656683..... so therefore my formula for RED is correct. I know it does not make sense but that's how it is.

 

Shha

It does make sense in a way with RED. Its only showing up with impale. The way RED works is:

Normal hit is 100% damage Crit is 200% - that means crit "bonus" is 100% of damage. Impale adds "20% more critical bonus" so final critical bonus is 100%*1.2 = 120%.

With RED Normal hit is 100% damage. Crit is 200%*1.03=206%. Crit "bonus" becomes 106%. Impale adds "20% more critical bonus" so final crit bonus is 106%*1.2 =127.2%.

I guess the main issue here is a bit deceiving wording on RED. In case of warriors it should say "increases critical damage bonus by 6%" and it would fix confusion.

 

Rallik

Weird, I'll check again when I get off work. I only compared Impale to Impale/RED and had a damage increase of 1.0300xxxxxx. If the multiplier went from 2.2 to 2.272, I'd expect that to have been 1.032 or 1.033. I wonder if there's any chance Unending Fury can mess with the results?

 

chiznitz

Landsoul do you plan on releasing the latest build before the patch? I'd love to find out what gems/enchants I'm going to need going forward. Love your spreadsheet, thanks for the hard work.

 

• landsoul

Working on a working excel version also as we speak, and yes I can release both on Sunday or Monday hopefully. All the hard work is almost done then I just fill in all the formulas and compare correctness.

This includes the 5% penalty to TG
Whatever they are trying to do with Sudden Death
Deep Wounds nerf
lowering of Bloodthirst to 5 second cooldown
Unlocking "Wrecking Crew"

Things that are being looked at that I might be able to get a handle on making average formulas for
New ways sword specialization works?
Mostly Optimal DW-arms rotations including Sudden Death (I don't know about the strength of this after the patch)

I'm guessing that TG - Incite might be the best way to go for most people. Please don't quote me on that. It's a guess.

 

dr_AllCOM3

Yeah, that and the SD nerf have hurt those abuse specs. Now it's either TG or proper 2h Arms.

Don't bother making your sheet for lv70, just go straight for 80.

DocsDK UI
Simulator

 

• landsoul

It's already made for 80, its universal for both atm, if you ever bothered to look at it. You'll see once I get the excel one out.

 

dr_AllCOM3

I always scroll down right to the formulas .

DocsDK UI
Simulator

 

Mylilwarrior

What's gonna be the best spec after 3.0.3 you think? TG/Incite,DW Arms,Arms?

Edit: or TG/DW their nerfing DW so that it dosen't stack right? or is that when Wotlk comes out?

 

DarkS

Landsoul, can you tell us if you're doing a change from ODS (OpenOffice) to XLS (MS Office) or you'll keep both versions? I see this change as another Microsoft win and makes me a sad panda...

 

Tatari

Disclaimer: Open office is on my laptop which is in the shits, so I can't check out all of your formulas at this time.

Is the current version of the spreadsheet (incorporating 9155 changes, I believe) using rank 1 deep wounds for offhand crits, Execute crits and Bloodthirst crits like it is on Beta? Also, has this (bug?) been acknowledged? I couldn't find anything on either the beta Bug Report forums or the Warrior forums.

 

• landsoul

Okay, here's the new release in all three wonderful shreadsheet languages. The Excel ones are recommended obviously. The Excel sheet is conveniently automatic and looks much nicer in general. I didn't get around to learning to macro it for SEP yet, but I'll get around to doing that later becasue the migration to Excel required me to re-write everything by hand. Fortunately it came out picture perfect with no errors and matched the OO sheet down to a pin tip. The majority of the change was to the 5% TG Penalty, off-hand wounds nerf, and the 5 second BT cooldown. Enjoy playing with it.

Excel 2007+
FuryDPS2.001BetaExcel07.xlsm - FileFront.com

Excel 1997-2003
FuryDPS2.001BetaExcel97.xls - FileFront.com

Open Office
FuryDPS2.001BETAOO.ods - FileFront.com

 

rejdakon

I've tried determining soem SEP values for lvl 70 from the newest version, although only crudely due to being at work. Equip used was mainly best-in-slot S4/T6 equivalent with only 2 sunwell-pieces, no glaives.

The numbers I came up with suprised me a little.

Here's what I came up with for 15/46 dual wielding 1h-weapons:

Str 1,00
Crit 1,00
Hit 0,30
Haste 0,65
Arp 0,80
Exp 1,55

Now for 5/56 TG:

Str 1,00
Crit 0,90
Hit 0,20
Haste 0,60
Arp 1,05
Exp 1,60

This was soft-capped on hit for specials after 5% TG-penalty.

Two things that surprised me:

1.) Hit comes out at an extremely low value. While I expected it to fall behind after the 14% mark, I did not expect it to yield only a little more than 1/7 the value it offers before reaching the soft cap. Although, considering the pretty low percentage of white damage, it does make sense.

2.) Arp seems to perform rather well with both specs. With TG it even comes out second after expertise and slightly above strength. What puzzles me, though, is the fact that it seems to be worth 30% more with TG than with 1h-fury spec. I did not have enough time to think about this at length, but at the moment I can't see the reason for this increase with TG.

In any case, I'm looking forward to having SEP calculations in the sheet in order to get some refined numbers.


Also, some suggestions/comments concerning the sheet:

- When selecting an item, it would be nice for the sheet to update gem-sockets and socket-bonuses for that slot automatically.
- The green cells for trinkets do currently not display anything in the excel version (they did in the previous OO version, iirc) which makes a bit hard to add trinkets.
- I am gettingweird results for expertise. The hit table seems to show 3% less dodge chance for the mob than it should. At 0 exp rating, no racial expertise and no weapon mastery i still only get 3,2% of dodge. Am I overlooking something there?

 

Roywyn

1) Before the yellow cap, + hit increases hits and crits for yellows due to the 2-roll system on yellow.
At 50% crit chance and 1% miss, 1% more hit adds 0.5% crit and 0.5% hit to yellows.

2) ArPen doesn't affect Deep Wounds, which are a significant amount of Damage that a TG spec doesn't have.
Hence ArP being worse for Deep Wounds specs.

The Blue Bar and you - the complete Fire Mage 2.4 mana compendium: http://elitistjerks.com/658230-post3191.html

DPS spec and class comparison in Naxxramas gear: http://code.google.com/p/simulationc...i/SampleOutput

And [Timbal's Focusing Crystal] doesn't proc on AM.
Neither does [The Egg of Mortal Essence] since 3.1.

 

• landsoul

That's a rather unreasonable request for me to take on. Just open Wowhead and type the item in the box it will tell you when colors it has.

That's cosmetic only. What are you trying to add? I put all the popular epic trinkets that you ever could use.

You need to be more specific so I can reproduce this. Sounds like you have Weapon mastery 2/2 and something else activated. What is the mob level and recheck your talents and expertise levels?

Oh and what is 5/56 TG? You should go 2/51/8 with incite that's the best.

 

Kaan

One more time thanks for the work, Landsoul.

The spreadsheet is showing me dual Executioner as the best option with 53/8 TG spec - it's coming ahead +16 dps on offhand versus Mongoose. My question: is this working as intended?

edit:
Got the same problem. The spreadsheet is showing 3,2% "DodgeM/DodgeO" with zero expertise and 0/2 Weapon Mastery, should be 6,2% I think.