Why were items removed from the spreadsheet? It makes it a much bigger hassle to compare items/gems/etc. when I have to manually recalculate the stats each time.

I've gotta agree. The old spreadsheet made it very simple to compare gear setups and gems without a lot of hassle. Now I have to recalculate the stats manually to see what's better, and comparing different gem setups is a huge pain.

I'm not necessarily complaining as the author isn't getting anything really for making the spreadsheet, I'm just curious why the older, and apparently in many peoples' opinions better, spreadsheet was abandoned.

Just think about what a hassle it is to add and edit all those items, not to mention a good interface. It is VERY much work. If you want correct and updated DPS you have to live with it.


edit:
another small update, see first post

drALLCOM you have the links switched on the OP. The English flagged link is actually the German link
and the German flagged link is actually the English link.

A point of confusion for me is should I enter the total values of my stats or just the values that total from the equipment themselves (eg, not race or talents)?

I'm leaning towards just what's printed on the gear and the spreadsheet is smart enough to add in everything else, but I'm not sure.

Also, the hidden cells for the off-hand attack table are making crit% be whatever's left after miss/dodge/glance instead of using crit%.

*ok, it's because I'm an Orc. It's adding the value of K25 (off-hand expertise from racial). It's not able to get crit value for off hand out of C8 for some reason, in addition.

Some of this may be from my total inability to get it to accept I'm dual wielding and not slamming.

Thanks for adding the devastate rotation!

I believe devastate crits should be calculated as
((weapon dmg*50%)+5*35)*(Crit multiplier)
The current version does not give the crit multiplier to the 5*35.

Example to show that this is probably the correct mechanic:Suesse - WWS
Max non-crit:586
Max crit: 1191
I have crit dmg meta no impale

Does the spreadsheet automatically calculate the AP awarded by Improved Berserker stance, or does it assume that the AP I input has it already calculated?

There's a bug in the bloodthirst damage calculation for 2H cycles--it's referencing the wrong cell for attack power.

I should mention, that it has to be in Battle Stance .

I have to agree here, needless to say that the point here is to know which gear to take and how much dps will you be able to do with it, comparing with the other gears, I don't think its any useful to know how much DPS I can nowadays

If you want the old way, I believe the links to the "old" spreadsheet is still out there.


What would be useful is adding a block of what another 1 str, 1 crit, 1 hit, 1 haste, 10 armor pen would do to your dps, which helps you make Pawn weights and Lootzor weights.

How does one get this to accept dual wielding? It certainly isn't by entering data on the off-hand weapon, that causes errors.

talents - durchbohren combobox can only choose 0/1

I went ahead and modded the new and old sheets to be able to work together, so you can still input gear and stuff the old way, while having the benefit of the updated calculations. It's still a bit messy in some ways, but it should do the job as intended.

Integrated DPS spreadsheets


Grim13 Modification changelog:
'Gear' sheets now reference dr_AllCOM3's new spreadsheet for DPS values
Removed 'Talents', 'Buffed DPS' and 'Talents_Buffs' from use
Added Gear2, Gear3,…,Gear6 to correspond to Set1, Set2,…,Set6 on the new spreadsheet
New spreadsheet references the Gear1, Gear2,…,Gear6 sheets for character stat data entry, rather than rely on user input
Renamed "Warrior_DPS_2.xls" to "Warrior_Sim.xls"
Automatically opens "Warrior_Sim.xls"
Added 'DPS Summary' sheet, which is a copy of the 'DPS' sheet in the new spreadsheet
Corrected an incorrect cell reference for 2h bloodthirst on the new spreadsheet
Added 'DPS vs.' to each 'Gear' sheet, which allows the selection of another 'Gear' sheet to compare DPS with, expressed as a percentage
Updated "Buffed Threat" sheet to work with the new version…sort of. Should be a decent approximation, but only works with Gear1 at present
Modified various save and load .vba functions to be compatible w/ multiple 'Gear' sheets
Added 'Talent Spec' drop-down list referencing talents on the new spreadsheet (Remember, talents and buffs must be input on the NEW spreadsheet, Warrior_Sim.xls)

Geat Job on combining the two spreadsheets.
I noticed a bug when using a DW set up if you equip the S3 slow axe in the offhand the dps jumps about 90dps over the S3 sword
Edit looks like the offhand crit rate is jumping 25% when equiping an axe not sure why.

Hi folks,

Hopefully this is the proper place to pose this question. I've read a great deal of this thread and couldn't find a definitive answer. Apologies in advance if I simply didn't search hard enough.

My question is this: If I am a human warrior wielding a sword in my main-hand and a dagger/claw/axe in my off-hand, does the 5 expertise listed on my character sheet (gained from the human racial for wielding a sword) apply to off-hand attacks (which are being made with a non-sword/mace)?

Thanks for any clarification.

Thank you kindly for the pointer, I'll make sure to re-read that thread from here on before asking any questions.

That said, I do have another question.

Which is going to provide a better benefit to overall dps.

5 expertise to the offhand (from using a specialized weapon)...

...or an off-hand weapon of the same speed as the main-hand.

I know that weapons of identical speed are supposed to provide extra attacks from Flurry. is that enough to outweigh the -1.25% parry from specialization?

Afternoon all. Long time reader, first time poster.

I loved the combined spreadsheet that Grim has put together, it's a perfect blend of both sheets, however I am having a similar problem to Barmbul.

I'm a Human Warrior but for some reason the S3 1H slow axe gives ~10dps more than the 1h sword in the MH and in the OH gives ~90dps extra, by using the "wrong" weapon for my race.

Worst thing is that there seems to be no difference in stats to justify the error. I'm not noticing any jump in crit or whatever.

if you look at the set tab on the warrior_sim.xls page when you equip a axe in the offhand the crit shown on the Set tab goes up by 25%

I found the problem. Remember, the new sheet was never tested for DW, as dr_allCOM is a 2h warrior now. It turns out that the OH racial expertise bonus was getting involved in the OH crit rate formula, when it shouldn't have been, at least not directly. I'll get it corrected and post an updated version later today, after I finish up some more additions and tweaks I was already working on.

If I remember correctly, there was no evidence to support the 'same speed = extra flurried attacks' in Disquette's flurry thread. Use the spreadsheet, and figure out what is best.

Also remember that flurry uptime is going to be somewhere around 85% or more anyways. So even if it were true, the vast majority of the time your flurry will be refreshed before that extra charge came into play anyways, severely mitigating the benefit you may have initialy thought it represented. Even if it were true.