Gruntle

Did you try the FIxIt button?

If that doesn't work do the following (in the 9.1.6 sheet):
1. Remove Mongoose enchant (from both weapons)
2. Go to the Buffed dps page and find the "Use Circular refs" cell.
3. Change the value in that cell to "=FALSE()" => You should now have values instead of N/A
4. Change the value back to "=TRUE()" => N/A should not reappear you will now have "correct"
values for flurry uptime and everything else
5. Reapply Mongoose to your weapons.

If that doesn't work I can't really help you.

edit: for the buttons/scripts to work you have to answer yes to the question excel asks you when you open the sheet.

 

Gruntle

Well we do know that the spreadsheet computes a theoretical upper limit to the dps that you can achieve. Any deviation from the perfect cycle will result in a lower average dps. Maybe the theoretical dps output from a slam build is higher than the DW one. The question we should be asking is perhaps whether we're able to actually do the perfect cycle for a full bossfight. I would estimate that in most boss fight I do the 3BT/2WW cycle about 90% of the time, the remaining 10 percent is spent getting kickbacked, being cc'd or whatever ability the bosses have or just being unfocused and missing cd's. The thing is, that with a DW build I can still move around a fair bit without destroying the cycle, I just need to stay at attack range.

With a slam build I'd guess that in an average fight, you would lose more than 10% moving about. It's also more vulnerable to player mistakes, if you do one slam in ten 0.5 sec too late that will result in lowered dps. I'm not sure we'll be able to simulate this in a spreadsheet, we should perhaps just accept that the sheet is a good tool for comparing gear and minor talent adjustments, but not really good for comparing builds.

I can't find anything wrong in the theorycrafting in the current sheets so I don't really think there is something wrong with the models (assuming that the theorycrafting is not fundamentally wrong somewhere)

 

Rhaeti

I don't think a slam build is naturally better than DW simply because you have much more rage dual wielding.

Also, klisk you're using the test version it looks like. Download the version from the first post in this thread.

 

Prinsesa

I apologize if my SearchFu was not strong enough to discover if this has been answered before, but:

How does Improved Mortal Strike's damage bonus work? Does it simply increase the 210 bonus damage (assuming rank 6) to 220 or is the 5% bonus applied to the entire damage range?

"We do want Sanctuary to be the tanking seal"

- Ghostcrawler

 

Gruntle

But the rage generation is also simulated in the sheet. Maybe there is something wrong with how the rage is calculated, but it seems to be fairly correct for me at least (based on how much rage I have to do HS for in a typical fight). Too high rage generation for the 2h builds perhaps?

 

• Ren

Do you realize how incredibly weak Imp MS would be if the 5% bonus only applied to the bonus damage? Think about it, 5 talent points for 10 more damage is ridiculous. It would be 5 points of talent for -1sec off MS, rather underwhelming.

 

lazerpewpew

Can someone post a 2h fury build good for 2.3 patch?

I want to try it out after 2.3 patch.

 

Grayson Carlyle

I went with this in my practice for 2.3: Talent Calculator - World of Warcraft

I was 33/28 before I saw the patch notes. This spec has upped my DPS by quite a bit over 33/28, though Rampage is often difficult to keep up, not because of the lack of rage or time to put it up, but it seems I quite often go 10s without critting and blow my opportunity to refresh it. Partially unlucky drops and partially tough choices with my sockets. I'm ~3600 AP minimum while raid buffed, 4000 when the shaman procs and my crusader goes off, but only 35% crit if I'm lucky to have a druid in the group. My highest MS was 3500, but now it's pretty easy to get 4k BTs.

Places to add variation in the spec: Iron Will, Imp Demo (I'm the demo ho, and we always use CoR while I'm alive), Imp Execute vs Imp Intercept: I don't even use execute unless the target is being moved around and can't slam, but I've found a ton of uses for Imp Intercept. And lastly Precision; if you have the hit, you could easily put those anywhere else that you like, but I don't have the items to support it, so I have to get those points.

 

lazerpewpew

You sure this is the build from 2.3? deathwish didn't get moved.
And there is no blood frenzy. Isn't 4% increase in melee damage very good for 2h DPS warrior?

 

Tectonic

The bonus is on the +210. This was questioned a year ago in the beta but nothing was done about it. With 5/5 Improved Mortal Strike the tooltip state +220-221 damage.

Here are some screenshots of 2/5 and 5/5 Improved MS

 

Prinsesa

That's why I decided to ask. I recall hearing about it on the forums so long ago and just ran with it, but with 2.3's incoming Arms/Fury changes, I was thinking about advising my Warrior about going deeper Arms for it if the talent actually worked like I thought it originally would.

@Tectonic: Thanks for the response and the illustrations, but I was also wondering if someone had made empirical tests (although I imagine that might take some time until you hit an outlier of 5%), since I don't see how you could represent the 5% increase in weapon damage on the tooltip.

"We do want Sanctuary to be the tanking seal"

- Ghostcrawler

 

King Brasidas

Just having a play with the warrior DPS spreadsheet, dr_AllCOM3's new one, and it keeps telling me to do "4x Slam, BT>WW" when I'm DWing in 17/44 spec. Can anyone tell me what I've done wrong and what I need to do? I've already pressed the 'Fix it' button.

In fact, is there anywhere I can find a r'tard's guide to the spreadsheet? I haven't found one searching the forum, and the previous megathread is hardly helpful.

Keep up the excellent work. Great forum.

 

dr_AllCOM3

If you can't even run the sheet in Excel you won't be able to use the results properly anyway. That's my point of view, so I won't ever make a guide.


RapidShare: Testversion 2
This looks much better I think. Cycles are seperate and as a whole, so no rage gets lost and they are very flexible. I think I'll leave it.
The only annoying thing now are the random numbers from the circular references, I have to even that out. It's irritating, when you get different DPS all the time.

 

Danath

Is DW finally better than 2H?

Can we download it in place of the last non-test version?

 

dr_AllCOM3

What exactly don't you understand in "testversion"?
If you have nothing of value to contribute, then please refrain from posting.

 

• frmorrison

I took a quick look at the sheet, it shows DW > 2H (which should be the case).

However, when I loaded the 17/44 build and DW Test1 Gear, the cycle still was showing Slam and MS.

 

dr_AllCOM3

If you have no clue about Excel, please don't use testversions. Thank you.

 

Olon97

Just change cell B2 on the gear tab to be

=IF('Buffed DPS'!L89>'Buffed DPS'!L75, 'Buffed DPS'!J89, Buffed DPS'!J75)

 

King Brasidas

I don't wish to derail the thread, but I would like to point out to the good doctor that the DPS spreadsheet is vastly complicated, even for someone with 'advanced' Excel knowledge. That said, I'll have a play with the 'non-test version' and see if I can get it to work better.

 

Olon97

Apologies if this was already fixed, I was looking at this dodge in the negatives phenomenon on the spreadsheet just now. First test version since version 2 link points to root of the rapidshare site atm.

In the dodge calculation cells, E17, E23, H24, H30, and H36, a part of the forumula is:

(Expertise from gear + Expertise from racial*0.25)/100

Shouldn't the expertise from gear also be multiplied by 0.25? Otherwise a single 19 expertise item reduces enemy from 3.6% to -1.22% - which I think is about 4x as much bang/buck as it is supposed to provide. If both expertise values are multiplied by 0.25, the single 19 expertise item lowers enemy dodge from 3.6% to 2.4%, which seems a bit more sane.

 

Gruntle

I believe this bug is still in the latest testversion (if that is the version the latest link points to).

Another thing with the latest version, would you mind making the flurry calculations work without circular refs again? It's quite good to be able to disable circular refs when testing and fixing bugs (makes it a lot easier to convert the spreadsheet to OpenOffice), in the current version the flurry uptime is set to 0 per default if you don't use circular refs, this means that you cannot "initialize" the values any longer. I would guess that this would mess with the FixIt macro as well, but perhaps you changed that.

I was able to make the flurry in non-circular mode work again by setting cell H12 (Instant attacks per sec) to "=IF(B12;N5/N3;0.2)", assuming a value of 0.2 instants per sec without circ. refs. Then change the Flurry uptime cell to:
=IF(Talents_Buffs.E30;IF(B12;1-(1-H27)^((3/(1/B31+IF(B34>0;(1/B34);0))*H12+3));1-(1-H27)^((3/(1/B30+IF(B33>0;(1/B33);0))*H12+3)));0)

Bolded part added, instead of 0.

 

Ego

There seems to be an error with the offhand crit % when orc/human racials are considered in test v2. My crit rate was almost double what it should be when racials were considered.

I changed the formula slightly, from the origional =MIN((1-H30-H31-H32),(B17-(B7-B2*5)*0.0004)+H20) to: =MIN((1-H30-H31-H32),(B17-(B7-B2*5)*0.0004)) and the problem seems to have been corrected.

 

Hozz

Regarding Expertise...does the spreadsheet model it correctly? If so, according to what I got, the following items are the best available for DPS in their respective slots for 17/44 now...

[Brooch of Deftness]
[Belt of One-Hundred Deaths]
[Shoulderpads of the Stranger]

 

Graul

My DPS jumps up by 100 by just swapping in that belt by entering it's Expertise "rating", but if I convert it into actual Expertise, my DPS drops by 20.

 

Hozz

Are you saying the spreadsheet wants skill entered and not rating, for Expertise?