WotLK DPS spreadsheet - Page 61

Shandara · 12/10/08, 10:57 AM

I've tried your Armory profile and it loads fine.

The only other reason I can imagine why your bow isn't showing up on the Gear Planner is because the v80 has 25-man loot filtered out currently (just tick the box on the Gear Planner and resort).

Iru · 12/10/08, 12:03 PM

Something I just noticed with the spreadsheet: where do I add in the effects of the Kill command, or do the calculations just assume that I hit it every time I hit BW?

Vaxum · 12/10/08, 5:15 PM

I noticed a bug with the HitRatingToCap value shown on the Overview tab - it is using Excel formatting to round down, which makes it report one less hit than is actually needed to be on the correct side of hitcapped.

One fix is to change Overview!M41 to also do the appropriate CEILING or FLOOR functions, e.g.:

Change Overview!M41: =IF(M42>0,CEILING(M42, 1), FLOOR(M42,-1))
Add Overview!M42: =(1-Calculations!B55)*HitRating*100

Bikiniwax · 12/10/08, 7:55 PM

I'm getting a #DIV/0! error on the Overiew tab, cell H4.

I was getting other #DIV/0! errors but somehow they went away and this is the only one left.

Zeel · 12/11/08, 3:43 AM

Shandara: could you please add support for Enchant Cloak - Greater Speed ?

CrowneVict · 12/11/08, 10:22 AM

Hi all - I'm on a mac, and since the macros don't work I'm plugging stuff in manually... I can't seem to get the LnL talent to apply a dps increase for Arcane Shot. Actually, I think the calculations tab showed it as a -4.77 dps gain (version 80 of the spreadsheet). I just wanted to test out a hybrid AS build.

Tleilax · 12/11/08, 12:28 PM

Minor nitpick here that I noticed today:

The BC "Glyph of Ferocity" head enchant has been re-named to "Arcanum of Ferocity" in-game but is still titled "Glyph of Ferocity" in the spreadsheet.

P.S. Thank you very much for all your work on this spreadsheet Shandara, it's an excellent tool.

Selmarix · 12/11/08, 12:34 PM

Is it possible to add a general gear multiplier for all stats that you get from your gear?
That way we could estimate scaling and scaling issues better by checking what your dps would be with 10% better gear (or whatever multiplier you prefer). Not quite correct for hit, but at least it is an estimate where you will be in future tiers.

Additionally there could then be a calculated value similar to the attribute tab with its dps gain per item budget that shows general scaling with the kind of gear you wear and your talent and rotation choices by dividing your dps with a gear multiplier of x (e.g. 10%) by your current dps. That value divided by x would then be a good scaling estimate.

Dch48 · 12/11/08, 1:06 PM

I've been playing with v80 and all the upcoming nerfs. I'm seeing an overall dps loss of about 6%, That's not too bad and better than what I was afraid of. On bosses it's more though, almost 15 % with the crit loss figured in. I'm not sure we lose that much crit though. I don't lose more than 2%.

DrasticK · 12/11/08, 2:01 PM

Shandara, could you please add support for blacksmithing? Socket Gloves and Socket Bracers. Thank you.

zigmund555 · 12/11/08, 2:17 PM

I think I'm confused.

What would be a shot rotation order for a MM build like a 7/57/7 (with Aimed).

I was seeing the highest DPS in the sheet with (glyphed aimed, arcane, hawk)

1. Rapid Fire
2. Serpent
3. Chimera
4. Aimed
5. Arcane
6. Steady

Can someone with some MM experience correct this?

Anak · 12/11/08, 2:22 PM

Just wondering if the Engineering Glove Enchant "Hyperspeed Accelerators" is modeled yet? I see it in the dropdown list for Hand Enchants, but it doesn't seem to add any DPS versus "None" for enchant. I couldn't find a model in the Calculations tab either. Thanks!

Discomonger · 12/11/08, 2:33 PM

Great spreadsheet, thanks for your hard work maintaining it. I've been using it on my newly mained hunter as I approach 80 and it has been relatively accurate, which I realize is a hard thing to correctly do.

I did, however, notice one minor bug that causes IAotH to be overvalued, and especially its glyph:

On the calculations tab, under the cell IAotHShotSpeed, the speed of a weapon under the effects of IAotH are miscalculated. The formula there is: IAotHBaseSpeed * (1 - IAotHEffect). However, as I'm sure you know because it is correct in other places on the spread sheet, haste works by increasing the number of expected shots by x%, not by decreasing the the delay between shots by x%, as described here.

In other words, the correct formula is: IAotHBaseSpeed / (1 + IAotHEffect). The previous formula overestimates the contribution of IAotH buff to white damage, and becomes more apparent when it is glyphed.

The problem can be demonstrated with a simple test by checking your weapon speed after IAotH proc and comparing it to the value listed in this cell, from which the effect of IAotH is calculated.

Thanks, and keep up the good work!

Iru · 12/11/08, 3:47 PM

Shandara, while doing some modelling of the upcoming changes (see here) I have found a weird change between version 79a and version 80.

Using identical gear, racial, talents and buffs, the version 80 spreadsheet produced a decrease of 4.2% crit (which I can understand from the lethal shots thread) and 120 AP, which I cannot explain. Are you calculating AP differently somehow now?

Aern · 12/11/08, 4:32 PM

Well I'm playing with the v79 and v80 of the spreadsheet to try and see exactly what my dps drop is going to be and currently the same spec and gear and buffs and pet (scorpid) are showing a dps increase from 4946 to 5218, with my pet gaining over 400 dps going from 2389 to 2806 dps. Now I'm not the best at running this thing, haven't really played around with it that much, but I would have expected a much more substantial nerf than this, what exactly am I doing wrong?