hejsan

I'm using OpenOffice for this, but it gives me loads of Err:502

do u need excel?

 

Boevis

Same. Last working version I had for openoffice was v.461

 

Deathwing

Hmmm, looks like a lot more people use openoffice than I expected. I have some more theorycraft to work out, but after I release the next version, I'll work some more on getting openoffice working.

 

corpsesmashkill

That Windfury nerf, it it's true, won't be as bad as it seems. Yes no longer getting rage on WF procs will suck hard. But there a pluses to it which will offset the nerf some(or alot?).

1. Just as in anything which procs an extra attack( sword spec, HoJ etc.), if it procs on an instant attack it does truly grant you a free "extra attack". It just makes your next normal swing occur immediately( same functionality as parrying an attack http://www.wowwiki.com/Formulas:Parry). So if you get a WF proc on a bloodthirst, it will just make you swing and then reset your swing timer. And if the proc occured immediately after your last normal swing you almost gained a full extra attack, and if it occured right before when your next normal swing would have occured, you gained almost nothing. A windfury proc off an instant never grants a "full" WF proc. Yellow windfuries would have no such hidden drawback.

2. Yellow windfuries will not consume flurry charges, while still giving a chance to proc flurry. This would take one drastically closer to the exalted state of "perma flurry".

 

igmas

Uhm why isn't there a Flametongue as an option on horde buffs. Its pretty imba if your stuck as a dagger rogue's battle shouter.

 

Boevis

1. fill out a profile
2. find the Rogue Spreadsheet on these forums and give them to your Rogues, WF is always better for you by a few dozen DPS, while Agi is rarely better than WF for rogues by more than a couple DPS. Your raid will gain more by using WF over GoA in a melee group if the group has at least 1 warrior.

 

ildon

The rogue spreadsheet doesn't have flametongue either. Has anyone actually figured out GoA + flametongue vs. WF only for rogues? The extra hits aren't exactly generating energy for them.

 

Boevis

Flametongue: http://www.thottbot.com/?sp=16387
assuming low is 1.3 speed and the high is 4.0 speed, it works out to +12.15 DPS on White (15.8 with SnD up) +3.5 DPS on backstabs (1.8 speed dagger) +8.5 DPS on SS (2.8 speed) So 24.3 DPS swords, 19.3 DPS daggers. Actual numbers will be lower with miss %.

Instant Poison: http://www.thottbot.com/?sp=11343
By my simple 'lunchbreak math' 130 average damage, 25% chance (3/8 BF), +32.5 per hit. +23.5 DPS white daggers, +5.4 DPS on backstabs, +15.1 DPS white swords, +8.1 DPS on SS. 28.9 Daggers, 23.2 Swords. According to the spreadsheets, 24.5 DPS daggers, 21.74 DPS swords, lower than mine because of miss %.

So Instant Poison beats out Flametongue totem.

Instant Poison + GoA (run the spreadsheet yourself) is not significantly superior than WF for rogues in any situation. WF is significantly superior than GoA + Critstones for warriors (crit stones > flametongue) Raid DPS goes up with use of WF over GoA when warriors or Sword Rogues are involved

 

Boevis

So I don't start another thread about BC ... I heard rumor that Blizzard was going to keep 'legendaries, legendary' and buff their stats in BC, haven't seen anything about it on here though .... Bullcrap, or potentially true?

 

Karr

There was a blue post stating that they'd like to 'upgrade' legendaries in BC but really didn't elaborate. This is pretty vague and could be interpreted to be anywhere from having some quest to boost the states like you mentioned or he could just mean upgrading legendaries by more/better. I personally hope for the former as I'd love to see more usage out of my HoR (130dps @lvl 70 pls!).

I don't have time to search for the post but it was also in response to introducing artifacts into the game.

http://ctprofiles.net/16388

 

hubar

An off topic question:

I just recently won a bid for Severance.

Does anyone have experience with 2H fury with this axe?

Say, in patchwerk fight, which one would produce more DPS? DW (MH, hatchet of sundered blue, OH, CEC) or 2H fury with severance?

My gear is at http://ctprofiles.net/30276

Thanks!

 

Kint

You should try using the spreadsheet and see what sort of results you get. But to answer your question, DW will do more damage.

 

Armagedon

I have to go ahead and apologize for being so noob about this... When I use the macro for my particular gear to get a crit vs. hit vs. AP comparison I get alot of numbers in the bottom right side of the spreadsheet (good I think). My problem comes in when i want to do a straight comparison. (e.g. 1 crit = 2.04 hit = 24 AP) What math do I use here based on the numbers that are spit out to get the comparisons shown in my example. Any help would be greatly appreciated and again, I apologize for my ignorance and oversight in this matter.

 

Khalim

The macro's are just to produce the data points for the graphs which dont really have much of an use at the momement but look pretty :)

If you want those ratios for your current gear use the solver function in excell with raw stats field ticked. Solve for how much crit, AP, hit (one at a time) is required to get 1 DPS, 10 DPs or whatever increase you want. Set the parameters to be >0 and <100 for crit and hit and <3000 for AP. Once you know how much crit, AP, hit you need to get 1 more DPS you can do a simple division to get the ratios for Crit vs AP etc.

The solver function is available under the Tools menu. If its not there use Tools > addins to add it in. Use the excell help on the solver if you are not sure how to use it.

http://ctprofiles.net/2868856

 

Armagedon

Thank you so very much. :D

 

Aced

Hey, I am missing someting in this spreadsheet or what? Why i get better DPS with cape of black baron than with cloak of concentrated hatred(my profile: http://uploadhut.com/view.php/166395.xls). It's not big deal..but i just want to know what I am doing wrong, beacuse with more AP and more crit, and even +hit(ok..im 2h and hited max +hit) is a bit strange to have less dps, isnt it?:) So..it's wrong something with spreadsheet or with me?

 

Turpin

It's not a huge dps boost but there is extra dps generated from parrying. You can see the link below for a previous discussion.

http://forums.elitistjerks.com/viewtopic.php?id=7108

I did some tests myself and found results that are relatively consistant with the "parry decreases the time remaining in your current auto attack by 50%". This averages out to a 25% decrease in time of your current attack, or a 33% increase in attack speed for 1 swing. The equations would look like this:

DPS from Parry = (33% * Your Average Non-Instant Hit Damage* Your Parry Rate)/Enemy Attack Speed

Since it is based on the speed of incoming melee hits (and multiple mobs makes it more complicated), might be hard to get it in the spreadsheet but this behavior does exist so it would be nice to document it somewhere :-D . I will probably try to get it on the Satrina site along with a few other odds and ends i have been looking at at some point.

 

Deathwing

Turpin, I've thought of adding this for a while. I'm trying to keep the spreadsheet as self-contained as possible. Mob attack speed is quite variable. And on raids, as a warrior, you really shouldn't try get hit, which is what this spreadsheet is designed for. It's the same reason I left out rage generated from AE damage...you really don't know how much damage a warrior is going to take. In the end, I only use the mechanics I can control 100%.

Aced, that's a problem with my spreadsheet. I have the error fixed on my current spreadsheet. The miss table when it approaches 0 is a bit off. In your case, the Cape of the Black Baron had a -.4 chance to miss, and the Cloak of Concentrated Hatred had 0 chance to miss, giving the black baron the slight edge it needed to beat you in DPS.

 

Thorb

I'm sure you are working on this, but just bumping for good measure. Any news on the new talent? New MS, 10% berserker stance bonus, etc? They should all be pretty easy to put into the model.

 

Deathwing

Yeah, I'm updating the talents now. Problem I'm running into right now is something like Windfury works totally different now than it does in the expac. Should I stick with current release mechanics, expac mechanics, or release two spreadsheets?

 

Brissa

Until the expansion is actually relased I think 2 sheets might be the way to go (im assuming its not a huge extra workload for you).

Another relevant question is that since TBC gear is not implemented in the spreadsheet do we have any information on what kind of stats we can be expected to have at 69-70 so one can properly evaluate the different specs against each other.

Currently it should be obvious that with current gear MS should have a big advantage over BT because of its added base damage while BT is completely AP dependant and will keep scaling faster as you get updated gear.

 

Aced

Thanks for the answer, DLed new release and it works.

PS: I'm using 2h ATM (waiting for DW MH-weapon), and im wondering how can improved slam help if global CD is 1.5s? Or im missing someting? (Hm..or maybe is global cd 1s..nvm then-tested now..)

 

Beatrice

Why don't you just release one spreadsheet, and have two buff options?

Windfury(Release)
and
Windfury(TBC)

That way you can check which one you want. Also, you can get everything in one self contained lil package. It will also let people compare how the change will really affect them!

http://sig.gamerdna.com/quizzes/INFL...ks/Shuraki.png

 

Grailyn

Put out 1 more 'final' spreadsheet for pre-xpac then make everything from there forward xpac only. Have links to both until xpac hits.

Don't see a real good reason to put all that much more effort into anything pre-xpac anymore.

http://armory.worldofwarcraft.com/ch...ther&n=Grailyn

 

majk

Was wondering if you could put in world buffs as optional buffs? Its not that often you raid with these but since this spreadsheet covers so many areas of warrior dps its might be a handy addition for those wanting to compare items on say loatheb etc.

First post here also so thanks for all the work youve done with this Deathwing. Greatly appreciated.