[top]IF(Gear!B11

Aten · 10/26/07, 5:36 AM

Originally Posted by Chadw

I only get that error if I have Dragonstrike in my main hand when I switch the race to human. I haven't had that error with any other mace or sword but it seems there is an error with the human racial in the new spreadsheet.

Yep thats exactly my MH, and i had S2 fist weapon to my OH, had to had it as dagger, tho cause it seems that fist isnt working properlly too.

BTW how do i had Doomplate set i still have 2 pieces and i want to put the + 35 hit.

Yes i know they suck but fighting againt tanks a and priest with prio sucks.

EDIT: The caracteres show on the AGI collumn, and all over the place in Buffed tab, also on the enhants tab just on mongoose, and executioner in MH and OH, still dunno why Executioner get changed cause i dont select it wahtsoever.

Milfeulle · 10/26/07, 1:45 PM

I think I have found the problem in regards to the Dragonmaw+Human being borked.

In Buffed_DPS Sheet, there is an identical error in the MH Crit Racial and OH Crit Racial fields:

[top]IF(Gear!B11

"Human",IF(Gear!D13="2h Mace",1%,IF(Gear!D13="2h Sword",1%,IF(Gear!D13="Sword",1%,IF(Gear!D13="Mace",22,0)))),0)+IF(Gear!B11="Orc",IF(Gear!D13="2h Axe",1%,IF(Gear!D13="Axe",1%,0)),0)

As you can see in the bolded part, mace is currently giving 2200% bonus crit. So, changing the "22" (I assume this was for crit rating) in the formulae back to 1% fixes the problem.

EDIT:

P.S.: I see that the current version of the spreadsheet is giving expertise for Weapon Mastery. Since it is -2% dodge now, is it equivalent to edit the expertise given to 8 (assuming 2 points) instead?

Gruntle · 10/27/07, 1:56 PM

To model Weapon mastery you could also unclick the talent points and just change Base dodge on the Buffed dps page to 3.6% instead of 5.6%.

The problems with "###" in the cells is probably caused by too narrow columns in the display (that's what it shows for me anyway), just widen the column by clicking on the border and dragging it to make it broader, the numbers should appear then.

dr_AllCOM3 · 10/27/07, 4:51 PM

I made an update.
Some fixes of things you mentioned.
Also now threat. Have a look into it and report wrong stuff.

[Prism of Inner Calm] is kinda underwhelming

.

Talida · 10/27/07, 7:19 PM

Thanks for the great work dr_AllCOM3, but i wonder if it is possible to add the ring enchants to the sheet, as well as the SV Hunter skill Expose Weakness (w/ dropdown menu to set the agility of the SV Hunter). That would be a great improvement for me and some others i guess.

Talida

Randor · 10/27/07, 8:05 PM

Come 2.3, + 4 stat should be the only ring enchant a warrior uses, be it dps or tanking.

Rhaeti · 10/28/07, 3:53 AM

Originally Posted by Talida

Thanks for the great work dr_AllCOM3, but i wonder if it is possible to add the ring enchants to the sheet, as well as the SV Hunter skill Expose Weakness (w/ dropdown menu to set the agility of the SV Hunter). That would be a great improvement for me and some others i guess.

Talida

Yes, that would be a good idea. Thanks for all the work you put into this. Some other suggestions are options for improved might and improved totems.

Hubs · 10/28/07, 2:12 PM

I get an error using Excel 2007.

Upon opening the file i get: Excel Encountered an error and had to remove some formatting to avoid corrupting the workbook. Please re-check your formatting carefully.

dr_AllCOM3 · 10/28/07, 4:19 PM

I use 2007 and get no error.

I think there is an error with loading talents. I'll look into that later, after Illidan.

Edit: Ok, everything fixed I think.

Gandharva · 10/28/07, 7:27 PM

According to the ### 9.1.6 Spreadsheed [Soul Cleaver] is worse than my current [Lionheart Executioner] by 25 dps. Can this be correct?

/edit

*argh* Forgot to change Sword Spec to Axe Spec...

Amorpheus · 10/28/07, 8:45 PM

One thing came to my mind when I thought about gems today - why haven't we seen some pretty graphs about scaling yet? With a spreadsheet giving a fairly good estimation of values between stats, it would certainly illuminate the relationship between attack power, crit, hit, haste and armor penetration at various levels.

Like [Legguards of Endless Rage] vs. [Leggings of Divine Retribution] and at which point 350 armor penetration would be more beneficial than the raw stats on the other pants.

Talida · 10/29/07, 7:29 AM

In Sheet 9.1.4 the combination of 4 * T6 + Bloodboil Pants was the equip with the highest dps i tried. Now in 9.1.6 the combination of the Random Platedrops (Illidari Shatterer, Bloodboil Pants etc.) + the T6 Shoulders are the highest dps. I didn't change rings, trinkets, neck and weapons. Can someone explain this?

edit: found the mistake, problem was my own stupidity

Hozz · 10/29/07, 12:02 PM

I am working with the latest sheet, 17/44. Weapon Mastery is not as big a boost as I thought it would be. I dont see my DPS going up in 2.3. I tried a 21/40 build to get Deathwish, but losing Rampage is just too much of a hit.

gnuoyiy · 10/29/07, 12:13 PM

I believe the -2% dodge will still outweigh 2% hit from talents because specials can only be dodged/blocked/parried (only dodges from behind) with 9% hit. A dodged BT or WW is a potential 1000-3500 damage, whereas 1% more hit should only alleviate white DPS when special hit capped.

My question for theorycrafters if it hasn't already been discussed is if -1s on Whirlwind will outweigh 1% hit, i.e. completely dropping precision for Wpn Mastery (2 pts.) and another pt in Imp Whirlwind (hits with both wpns next patch)...

LodeRunner · 10/29/07, 12:15 PM

Two points in Imp Whirlwind will break the perfect rhythm attained through one point.