Greysir

I saw the same thing in the old spreadsheet, where upgrading from T4 to T5 shoulders was a decrease in dps. After fiddling I found that it was due to me gaining/losing the 2pc T4 bonus (-5 rage to whirlwind). As you said, the latest spreadsheet shows an increase when upgrading the shoulders. I don't know if there was a bug fix, or a bug introduced... maybe someone that has dug into the spreadsheet formulas more can comment. But it also goes to show that while the spreadsheet is an *amazing* tool (thanks to all that have worked on it!) you should never accept it as gospel.

 

Grimrage

Definitely true. Something this complex is bound to have a flaw or two. I was thinking it was the loss of the T4 bonus as well, but had the same thought that if that were the case then the new one is bugged. Would love to know if that's the case.

 

seasonlight

Choker of Serrated Blades Choker of Serrated Blades - Items - World of Warcraft


vs
Pendant of the Perilous Pendant of the Perilous - Items - World of Warcraft

in my current gear set, for hyjal/bt respectively

 

ckaparos

Im using the standard 17/44 spec in the spread sheet, the rest of my gear
looks like this The World of Warcraft Armory I think you and I have similar gear/raid progression. Even with the silent grips gemed up with 2 x 10 str gems i get 1190 dps on the spread sheet with the grips, But with pillagers I get 1200dps so the spread sheet is saying im losing 10 dps with the silent grips.

 

dr_AllCOM3

Here is a testverion (so don't complain unless you want to help):
Testversion
Mainly new Flurry and it's somewhat slit up between Slam and DW.
2h seems to be a bit too good or DW too bad.
Maybe you can give me some input until tomorrow .

 

Tectonic

Can you add a line to socket neck pieces as well as lines to enchant rings?

I also noticed that Potency is no longer available for a MH enchant.

 

Darkrenown

S2 and S3 2h axes still use mace skill

 

dr_AllCOM3

No.


Yes, but that's not what I'm after right now.

 

haplohamilton

I haven't downloaded a spreadsheet in awhile and was wondering if ring enchants have been placed into the spreadsheets yet.

 

Taruo

Download the spreadsheet and explore it.
Nonetheless he answered your very question in the post just above yours.
You can easily add the ring enchants yourself in the spreadsheet.

 

haplohamilton

I must have missed the mention of ring enchants in the post above mine and looked mainly at the potency and neckpiece socket questions. I downloaded the spreadsheet and noticed the section for manual entries. Thanks for the help.

 

Barmbul

Is expertise that good? I switched talon of ashara out for the fang of Vashj and it was almost a 25dps increase and it seems to go against the new WW mechanic.

Armory profile

 

rayijin

You have to manually remove the gems from the spreadsheet when you switch gloves.

 

Danath

I'm seeing an important loss of DPS, sorry. About 14 DPS using Arena S2 Sword.

 

Fearos

Quick question.

Do you remember making any formatting changes between 9.1.4 and 9.1.6 (and the new test one?)

i use excel 2k7 and every time i open .6 or greater i get an error saying it had to fix some formatting information to prevent document corruption.


It appears to have to do with the miss % box. as it doesn't show up on the newer ones.

 

Barmbul

Ive tried it on two machines with the same results also with ssc gear and BT hyjal gear some one else care to chime in.

Armory profile

 

Barmbul

ok something is very buggy with the expertise. As a tauren almost no change going from a dagger to a sword offhand but as a human the dps jump from a dagger offhand to a Sword is almost 75 dps increase. As a Tauren going from the S3 axe to the Fang of Vashj is a dps increase of about 25.
Danath try changing your racial from Human to Tauren and see what is does.

Armory profile

 

Danath

Are you using the new test version?

 

Gruntle

I tested changing s3 axe for Fang of vashj in the 9.1.6 version, came out as a ~20 dps loss. Maybe something buggy with the test version. Also keep in mind that when using circular references you may have to "update" the calculations a couple of times before they show the correct figure (i.e. reselect the weapon a couple of times).

 

dr_AllCOM3

Dodge went into negatives. Still a very impressive (read overpowered) weapon.


Anyway, tell me about why DW isn't much better than 2h.
I think the rage generation has to be adjusted to 4 swings per cycle and not plain rage/s. Right now you get rage as if you weren't slamming, just normal autoattacking.
Wouldn't the old cycle model be better? But what to do with leftover rage. It's not wasted, it just gets used later (next cycle).

Edit: Anyone still here?

 

klisk

Ok well I am very new to spread sheets and how they help with stats and such. Well I downloaded your lovely little program and needless to say it was fairly simple. I'm post because I'm just curious as to what I'm looking for in terms of what my dps is. I'm looking at the Buffed DPS page after I've entered all my gear and spec on the previous pages and some of these are filled with #N/A so it really only helps me with how much I miss :/ Any help on how this actually works would be great sorry to waste/use your time for my own insolence.

Edit: Also I'm just wondering as I was pointed to here to check and see if my gear was at a good ratio for the amount of hit and crit I have. Is there a particular place I need to go in your Spreadsheet or would I find it elsewhere? Also at this time as I am fairly new to DPS in raids I'm trying to perfect my output with a cycle but as of now I WW BT and wait for BT and then WW again and just rinse repeat with hamstrings rebuffing and such. Help in showing which 'cycle' I use would be nice too :P sorry for the text wall. Thx

 

Gruntle

Assuming that you're using the 9.1.6 version (the TEST version seems to have some bugs in it for now, only try that if you want to help out making the sheets better) and using MS Excel, you should be able to just press the "Fix It" button on the Gear page. Press it a couple of times, the N/A's should go away. If they don't, post again, I might be able to help you out. You will then get a value for Buffed dps out. To compare different equipment just switch some stuff and see how the total dps changes (the dps given on the Gear page is the total dps, white+yellow+execute).

To find out how valuable stats are (str, crit, hit, agi, haste, -armor), press the SEP button on the right hand side of the GEAR page. This will compute how much dps you gain by adding 10 str/crit.../100-armor. You can normalize by the strengh value by dividing each of the figures with the value for str, giving true SEP (Strength Equivalent Points). On that scale, str will have a value 1 (not surprising), the other will depend on your gear and build. E.g., for my DW 17/44 kara gear I get something like str=1, AP=0.5, agi=0.6, crit=0.8, hit=0.6, haste=0.95. That makes it easy to compare items when you're playing (just compute the total value of an item coadding the stats and multiplying by the SEP values).

Good luck

 

Gruntle

Well, you should ofc compute rage/s for the true cycle length including slam cast times. Wouldn't it be easy to do that? Calculate the mean time for 4 swings and (with flurry), then add 4*(0.5+latency) to that number. The true rage/sec could then be calculated. Would that work or does the circularity mess things up?

As to the leftover rage, what do you do with it as 2h? Couldn't you just do like for the DW cycles, where it gets transformed into HS (isn't it already?). If there is still rage left after this I think it should just be lost, you can't really do anything with it anyway in this highly theoretical situation. We're anyway only after average values here, in a real situation you will get rage starved sometimes and sit at 100 rage other times.

 

klisk

So should I be able to see flurry uptime and all that or? Is there some I jsut don't see I dunno I have all of my gear input granted i put some other gear in the bottom of gear because I wore legs that were not on the list. LMK Thx

Edit:

Rage Available #N/A Rage per/s: #N/A Talents #N/A Flurry Chance #N/A
Rage from Dmg (included) 0.00 Mhhit #N/A WFhit #N/A Flurry Uptime #N/A
Mhglance #N/A WFglance #N/A Time between crit #N/A
Cycle Info Mhcrit #N/A WFcrit #N/A Time between WF Attacks #N/A
Length #N/A Ohhit #N/A Extrahit 0.00 Time between Extra Attacks 0.00
Cycles per fight #N/A Ohglance #N/A Extraglance 0.00
Instant hits #N/A Ohcrit #N/A Extracrit 0.00

Kind of a cluster but that is some of what I'm seeing atm. Dunno if that can help you help me

 

dr_AllCOM3

I save it of course for the next cycle. I rarely get to HS, so I think it will be quite a realistic thing.


My main concern is still, why Slam is so good or why DW isn't.