Combat and Mutilate Spreadsheets (Obsolete as of 4.0.x) - Page 185

• Aldriana · 02/06/10, 8:29 PM

The key point is that the "MH Crit Rate" number reported on the front page is the amount you actually crit against a boss - that is, crit reduction is already applied to it. Hence, in order to be a useful comparison, the crit cap needs to report the cap on what your actual crit rate can be, rather than then the "tooltip" crit rate that will yield the appropriate amount of crit.

Hassam · 02/06/10, 10:10 PM

Originally Posted by miyazma

Thanks for the spreadsheet development Aldriana but one thing I'm getting is this error when changing gear.
I'm on a Macbook Pro, using OS X, when attempting to change the gear so it calculates different values it in fact will not and pops up a window saying this:

Microsoft Excel cannot calculate a formula.

The is a circular reference in an open workbook, but the references that caused it cannot be listed for you. Try editing the last formula you entered or removing it with the Undo commant (Edit Menu).

Dunno what to do about this :\

You will need to use OpenOffice to open this spreadsheet on any version of OS X. This is due to MS Excel for Mac not being able to resource a number of Windows-specific (e.g. proprietary) files. The download is free, and the software is stable, so save your money on a pack of office.

darigan · 02/08/10, 2:20 AM

Sorry for my bad english and if I'm too stupid to find a post concerning this error or whatever.

I have a problem concerning the current Mutilate-Sheet. When I remove all Buffs (setting all modifiers to "no") I miss 5% crit compared to the value ingame. I don't know if I just miss something or if there is an error in one/some of my Items. I couldn't check further because there is no option to wear no item on different slots.

First I thougt this would be the 5% forced Hit but unbuffed I'm way below the Critcap. Any Ideas what's happening?

This is my character: The World of Warcraft Armory - Darigan @ Krag'jin - Profile

So long,

Max

• Aldriana · 02/08/10, 3:11 AM

Sheet includes the 4.8% crit reduction that you experience against boss-level mobs, hence should report 4.8% lower than your tooltip crit with all buffs off.

Rosvall · 02/08/10, 12:08 PM

An interesting thing I've found is as mutilate, with non heroic BiS gear. It seems going with 4 set bonus and speccing in to full relentless and opportunity is an increase over the LR build. Even more so with Heartpierce,

Seditions · 02/08/10, 2:04 PM

With my setup which is a couple pieces short of BIS non-heroic I'm noticing the same thing on the Java app, but not Aldriana's sheet:

51/18/2 (w/Rib Spreader)
DPS: 11721
Haste EP: 2.04
Agility EP: 1.97

51/13/7 (w/Heartpierce)
DPS: 11703
Haste EP: 1.87
Agility EP: 2.03

iDPS Java app:

51/18/2 (w/Rib Spreader)
DPS: 12160
Haste EP: 2.04
Agility EP: 2.01

51/13/7 (w/Heartpierce)
DPS: 12306
Haste EP: 1.86
Agility EP: 2.06

The EP values are close like they always have been, but I don't understand why they go in such opposite directions with the spec change. Heartpierce is valued higher with 51/13/7, but even without that change the DPS difference is still there.

Xcuse · 02/08/10, 2:15 PM

Originally Posted by Rosvall

An interesting thing I've found is as mutilate, with non heroic BiS gear. It seems going with 4 set bonus and speccing in to full relentless and opportunity is an increase over the LR build. Even more so with Heartpierce,

I noticed the same thing. 4p t10 = RS > LR for me in the App

In the spreadsheet LR is just slightly ahead of RS, but not enough to warrant the worse "Putricide-Fight" damage for me.

Kaage · 02/09/10, 11:22 AM

Aldriana first I wanted to thank you for doing these spreadsheets and keeping them updated I know it helps alot of us out.

Second I was wondering if you updated the lich king weapons in the spreadsheets. Mut daggers no longer have arp, bow now has arp, etc.

Thanks

zhrgg · 02/09/10, 11:23 AM

Originally Posted by Kaage

Aldriana first I wanted to thank you for doing these spreadsheets and keeping them updated I know it helps alot of us out.

Second I was wondering if you updated the lich king weapons in the spreadsheets. Mut daggers no longer have arp, bow now has arp, etc.

Thanks

You can do it yourself quite easily.

Unhide the weapons tab and simply edit the arpen and haste columns as appropriate.

Sh@ft · 02/11/10, 3:36 AM

Originally Posted by Hassam

You will need to use OpenOffice to open this spreadsheet on any version of OS X. This is due to MS Excel for Mac not being able to resource a number of Windows-specific (e.g. proprietary) files. The download is free, and the software is stable, so save your money on a pack of office.

This isn't 100% completely true at least in regards to Aldriana's spreadsheets. I've been using them for quite some time under Mac OSX (10.6.2) with Excel 2008 for Mac 12.2.3 (091001), and have not experienced any problems. Though I do agree, Open Office is a great alternative for people having troubles in general.

Canio6 · 02/11/10, 6:18 PM

A quick question about the spreadsheets and my apologies if this has been answered before. I have my current gear etc plugged in and it says under 'Ranged' in suggested upgrades that Shrapnel Star is 30.86. When I actually plug Shrapnel Star in place of Crimson Star my estimated DPS goes up 98 points. I thought the 30.86 in suggested upgrades was the DPS increase. Can someone let me know what it is I am missing please.

Shaker · 02/11/10, 6:24 PM

It's an EP increase, not a DPS increase.

• Aldriana · 02/11/10, 6:25 PM

The values are in EP - that is, the units are not DPS, it's the amount of damage gained by 1 AP. In current content, however, 1 AP usually gives you "about" 1 DPS, so they'll run pretty close.

What you're seeing is the simple fact that your current ranged weapon is putting you way over cap on Expertise, so a bunch of it's itemization is being wasted. Hence, swapping to another ranged weapon that doesn't have expertise is going to be a significantly larger upgrade than the spreadsheet would predict.

antonmb · 02/12/10, 1:35 PM

I've tried searching the thread but can't seem to find a reply. For Hyperspeed Accelerators, what would be the optimal way to use it? I remember it being mentioned that Engineering tinkers/bombs should be used on CD.

Would it be best then to bind Hyperspeed to Sinister Strike? Or time it with KS (1.25m CD) whilst Hyperspeed is on 1m? I'm torn whether stacking Hyperspeed with other procs/trinkets or everytime I refresh SND would be worth the downtime, rather than just using it everytime it's up regardless of procs/CDs.

Thanks.

Milou · 02/12/10, 1:49 PM

Macro it to Blade Flurry and use it again 60 seconds later, you'll get more benefit from stacking it like this.