WotLK DPS spreadsheet - Page 112

Ufthak · 02/23/09, 4:38 AM

I must admit when I was playing around with DPS values for gems I would normally end up sorting by DPS & colour or by colour and DPS.

As an idea for the lazy, would it be possible to add a column to the end of the gear tab that would give the DPS for the socket if it was matched? That way you could get an quick estimate of whether it is worth matching the socket.

Shandara · 02/23/09, 7:04 AM

Update:

- Alpha sort for gem is now ascending
- Added 'DPS' sorting option for gems
- Sorting gems on Quality now works
- removed all TBC gems (excepting meta-gems)

Hirgux · 02/23/09, 8:59 AM

Seems to be bugged; I do not get any values at the DPS cells.
The german error says #BEZUG - what I think has to mean reference in this context.

Shandara · 02/23/09, 9:04 AM

Originally Posted by Hirgux

Seems to be bugged; I do not get any values at the DPS cells.
The german error says #BEZUG - what I think has to mean reference in this context.

I've re-uploaded a quick fix for this. Changing all the gemming messed up a reference to one of the meta-gems.

Sapphique · 02/23/09, 9:43 AM

Originally Posted by trunghung

Does anyone else notice a big difference between the estimate that the spreadsheet provides versus the actual dps. The spreadsheet says my dps should be 6400 dps, but the my H naxx dps is typically around 4500dps. I don't think I am missing too many raid buff. The damage by each of the shot are pretty close to what the spreadsheet describe but for some reason I just never been able to come with 500 dps of the theoretical dps from the spreadsheet. It used to be a lot closer in TBC when it comes to my actual dps and estimate.

I've found that relative DPS changes are fairly accurate with the sheet - that is, I can gain approximately x DPS by changing to Survival, or to this talent build, etc. However, I've found the DPS estimates across the board to be higher (in some cases significantly higher) than attainable in game, even with extremely generous latency settings.

Version 84a actually seems to highlight this further, as estimated DPS in all of my configurations went up even more. The gap between BM and SV also closed a little on the new spreadsheet (with my settings), which is surprising because the difference between BM and SV in-game has been greater than even the last version of the spreadsheet predicted.

I've been reviewing the calculations to see where the inaccuracy could be occurring, but so far everything I've looked at appears correct (as correct as we know about). From in-game testing, though, I still think Spirit Beast is being heavily overvalued.

Shandara · 02/23/09, 10:06 AM

Originally Posted by Sapphique

I've found that relative DPS changes are fairly accurate with the sheet - that is, I can gain approximately x DPS by changing to Survival, or to this talent build, etc. However, I've found the DPS estimates across the board to be higher (in some cases significantly higher) than attainable in game, even with extremely generous latency settings.

Version 84a actually seems to highlight this further, as estimated DPS in all of my configurations went up even more. The gap between BM and SV also closed a little on the new spreadsheet (with my settings), which is surprising because the difference between BM and SV in-game has been greater than even the last version of the spreadsheet predicted.

I've been reviewing the calculations to see where the inaccuracy could be occurring, but so far everything I've looked at appears correct (as correct as we know about). From in-game testing, though, I still think Spirit Beast is being heavily overvalued.

There are a few things that will affect the dps predicted:
a) Rotations are tighter in theory than in practice, this is especially important since latency is variable in-game but assumed static for the spreadsheet
b) The standard level 80 raid buff set might or might not be an accurate representation of the average buffs a 25-man raider would have (especially buffs with uptimes or limited ranges).
c) RNG affects crit rates for a non-trivial amount.
d) Some pets are most likely not yet modelled correctly.

That said I generally get results close to in-game for an unbuffed test vs a training dummy with my cat (the cat's unbuffed dps is particularly close to the predicted amount). My own dps varies depending on the crit rates achieved, naturally, but it is usually within a 100 dps of what has been predicted.

Sapphique · 02/23/09, 11:05 AM

Originally Posted by Shandara

There are a few things that will affect the dps predicted:
a) Rotations are tighter in theory than in practice, this is especially important since latency is variable in-game but assumed static for the spreadsheet
b) The standard level 80 raid buff set might or might not be an accurate representation of the average buffs a 25-man raider would have (especially buffs with uptimes or limited ranges).
c) RNG affects crit rates for a non-trivial amount.
d) Some pets are most likely not yet modelled correctly.

That said I generally get results close to in-game for an unbuffed test vs a training dummy with my cat (the cat's unbuffed dps is particularly close to the predicted amount). My own dps varies depending on the crit rates achieved, naturally, but it is usually within a 100 dps of what has been predicted.

I understand. My configured buff set is -exactly- correct for my guild A-team composition. I'm not one of the "take the stock settings and run with them" people. Every setting on my sheet is exactly as it is in game. I calibrate my latency setting based on actual performance data prior to testing. For better or worse, I spend more time working with this sheet than is probably healthy! As others have said, thank you for putting in the time to make the sheet as accurate as possible.

I'm also being reasonable about my assessment with respect to rotation tightness and making allowances accordingly. I'm still seeing BM too close to Survival on the spreadsheet in many cases, and I've found Survival to be the more accurate of the two specs with respect to live (with BM being overvalued slightly). It's not FAR off, but it is consistently off. I don't think there's any harm in questioning the spreadsheet's accuracy sometimes when my data doesn't agree with it. Another pair of eyes studying the calculations can never be harmful.

pheinle · 02/23/09, 12:15 PM

This spreadsheet doesn't work at all for me. Is it because I have a new iMac that uses OS 10.5 even though I have excel or what? None of the buttons seem to work at all or the macros.

Nagisamuro · 02/23/09, 12:37 PM

Originally Posted by pheinle

This spreadsheet doesn't work at all for me. Is it because I have a new iMac that uses OS 10.5 even though I have excel or what? None of the buttons seem to work at all or the macros.

As of the 2008 version, Office for Mac no longer includes VBA (the whole macro editor, debugger, language, etc.).

Microsoft to bring back Visual Basic in Office for Mac | Macworld

You can:
a) find an older version of Office of Mac (I think 2004 was the last to include VBA, there may be legal ways to acquire it today, I don't know).
b) run it on Windows w/ a copy of Office for Windows.
c) try your luck with OpenOffice.org and the instructions for getting the spreadsheet to work in that program, posted in this thread by a third party.

Sorry.

Nageya · 02/23/09, 1:37 PM

It seems that Darkmoon Card: Greatness no longer has a value associated with it in the latest beta spreadsheet.

ra1330 · 02/23/09, 2:49 PM

I'm still seeing the Spiced Wyrm Burger doing 40 hit/40 stamina (instead of the correct 40 crit/40 stamina). I've got version 84a-beta2, according to the change log sheet, so it shouldn't be a caching issue (I don't think). Are you sure the change got made in 84a-beta?

Edit: Also, I'm noticing that I can't get a dropdown for the Eternal Belt Buckle slot. The other gem slots seem to work fine, but the extra Prismatic slot granted by that enchant won't appear. The gem itself still functions, and I can copy/paste into it from another gem still.

Kharthus · 02/23/09, 3:16 PM

Originally Posted by Nagisamuro

You can:
a) find an older version of Office of Mac (I think 2004 was the last to include VBA, there may be legal ways to acquire it today, I don't know).

Even with the older Mac versions of Office I had problems with the spreadsheet. Most stuff would work, but pulldowns didn't always work correctly. I've since upgraded to 2008 and lost all VBA functionality.

I end up just messing with it at work in my free time.

Eraist · 02/23/09, 3:19 PM

I've been using this sheet now for a while and cannot attain even close to the theoretical DPS the sheet states I should.

With my current spec and gear, in theory I should hit 6100 is dps if all the buffs and timing is perfect. Obviously that is not possible but I should be able to get within 500 DPS or so and I am not even close.

I'm not trap dancing, just using the right glyphs and my shot rotation is.

Mark target, hit serpent sting, Explosion shot, steady, steady, etc

refresh serpent as needed, and manually weave in a multi or aimed once in a while.

Macro
#showtooltip
/console Sound_EnableSFX 0
/cast Kill Shot
/castrandom Steady Shot, Explosive Shot
/cast [target=pettarget,exists] Rabid
/cast [target=pettarget,exists] Rake
/cast [target=pettarget,exists] Claw
/use 13
/console Sound_EnableSFX 1

If Cast Random doesn't pop ES, I hit it manually, right away. Also have an addon for Lock and load procs.

My DPS is decent, but no where near what I'm seeing on WWS from some equally geared hunters. I think I'm losing ground somewhere and I'd appreciate any advice I can get.

I'm maxing around 4400-4500 DPS on patchwerk each week. As Bm pre nerf I was hitting around 5300, but have gotten quite a few upgrades since.

Latency is around 100ms when raiding.

I just cannot figure out how those guys are hitting over 5K.

alienangel · 02/23/09, 3:23 PM

How fast are your kills?

Nor do you need to macro pet abilities except maybe kill command, and you should really not be trying to mix explosive and steady in the same macro anyway. /castrandom bad.

Eraist · 02/23/09, 3:28 PM

Originally Posted by alienangel

How fast are your kills?

Nor do you need to macro pet abilities except maybe kill command, and you should really not be trying to mix explosive and steady in the same macro anyway. /castrandom bad.

Patchwerk goes down in 3 mins.

Why not put the pet commands in the macro? They do not seem to auto proc.

Can someone share their macro?