WotLK DPS spreadsheet - Page 45

Wraith40k · 11/25/08, 1:47 PM

Working as a MM hunter with the shot rotation tab- Serpent Sting shows no dps when coupled with chimera shot.

If you remove CS it shows Serpent sting in the rotation (and net dps for it). With CS it shows zero.

My shot rotations i tried were

Rapid fire
Serpent Sting
Chimera Shot
Steady Shot

As well as
SS-RF-CS-StSh
CS-SS-RF-StSh

What am i doing wrong?

Har · 11/25/08, 1:49 PM

Originally Posted by Dralmoo

Couple of minor problems:* Kill Shot is never used (although this might be user error).

Kill shot is used in the calculations page- that's why there's a section asking how long your boss fight is and how much combat time you spend in the sub 20% range.

Dralmoo · 11/25/08, 2:01 PM

For me, changing the "Use Kill Shot" option has no effect on DPS, and on the Shot Rotation tab, Usage of Kill Shot box, everything in that box is 0. I have "Boss Fight Length" at 8, "Time spent sub 20%" at 2, and "Use Kill Shot" at "Sub-20%". If there is something else I need to change, it's unclear.

It's not a very big deal because 1 or 2 kill shots is not going to make a signficant difference to PvE dps no matter how much damage they do.

Here's what the Shot Rotation area has:

Usage of Kill Shot	
Current Kill Shot frequency	0.00
Possible Kill Shot frequency	0.00
Current Steady Shot Frequency	1.80
New Steady Frequency	0.00
Old Kill Shot DPS	0.00
New Kill Shot DPS	0.00
Old Steady DPS	1400.74
New Steady DPS	0.00
Gain	0.00
% of time spent sub-20%	25.00%
DPS gained using Kill Shot	0.00

Shandara · 11/25/08, 2:11 PM

The Kill Shot thing is a bug. It will be fixed next release.

A work-around is setting the Boss HP Percentage on the Settings tab to 15%.

Cyberbob · 11/25/08, 2:57 PM

Is there a "how to" guide on the spreadsheet? It's pretty overwhelming for first time users.

Har · 11/25/08, 3:04 PM

Originally Posted by Cyberbob

Is there a "how to" guide on the spreadsheet? It's pretty overwhelming for first time users.

If not, I'd be willing to help write one- I just figured it out for the first time yesterday, so all my dumb questions I had to look up are still fresh in my mind.

Tred · 11/25/08, 3:11 PM

I don't know much about spreadsheets but is it possible to import gear info from one sheet to another or do you always have to manually change the sheet to your gear when downloading the next version? I've tried the Export to File and Import to File but they don't seem to do anything at all for me. Thank you for all the hard work on the sheet.

Decker · 11/25/08, 3:15 PM

Small list of bugs.

Items:

Not listed correctly as leather:

Hood of the Furtive Assassin
Helm of the Avenging Protector
Ryft's Deathgaze

I'd check more, but I think the items need a good once over again.

Talents:

Surefooted: Reduces the duration of movement impairing effects by 30%. As such should be highlighted to red. Purely cosmetic, but want to ensure that the talent isn't using its old information. (+hit).

I'll be looking it over further today at work. I do a lot of excel stuff, and I always love to help this document as much as I can as it has helped me significantly.

As an aside I'd really love to make a proposal to finalize items in this spreadsheet. I'm in favour of grandfathering old TBC items and only including WOTLK items. With this I'd love to see more definition between what we currently have. As it stands we don't really have a good outline of the items. My proposal is to have the following for item designations/filtering (for the gear planner).

Raiding:
Naxx 10
Naxx 25
Obsidian 10
Obsidian 25
Malygos 10
Malygos 25
Dungeon
Dungeon Heroic
Badge Items

Other:
Quest
PVP
Arena
Leather
Crafted BOE
Crafted BOP (Alchemy, Blacksmithing, Engineering, Jewelcrafting, Leatherworking)
World Drop
Reputation

Although it's 17 checkboxes for the gear planner website it gives the gear planner a lot more added value IMO.

Work is picking up so I'll end my post here and continue later.

Great work though.

Ebonleaf · 11/25/08, 4:50 PM

Does it matter where it comes from? An upgrade is an upgrade is an upgrade. We can check Wowhead for the why's and wherefor's. I personally like the selection we have now.

Decker · 11/25/08, 5:03 PM

Originally Posted by Ebonleaf

Does it matter where it comes from? An upgrade is an upgrade is an upgrade. We can check Wowhead for the why's and wherefor's. I personally like the selection we have now.

It does matter. The reason is for preplanning. Even though I'll be the level 80 raider in the end game instance I'll just tick everything off. For the alts and people that are new to this I think we should be a lot more caring.

Sure they can use Lootrank.com or something, but why can't this item be the one stop shop for everything hunter related. I think we can work towards being a lot more inclusive than exclusive. We'll get a whole hell of a lot more people here if we do and more good comes from that then bad.

Ebonleaf · 11/25/08, 5:33 PM

Yea, I get the preplanning. I do that. I look for potential upgrades, find out where they drop, and compare them to the list i currently have. I plan and plot my gear as much as i can. I just didn't see the need for 17 different option on/off toggles. Either way is fine I'd think.

Osse · 11/25/08, 7:31 PM

Perhaps not the best place to ask but does anyone know if [Item not found!] procs off serpent sting?

Whitefyst · 11/25/08, 7:35 PM

I was missing around with haste in the latest version, and the Haste to Cap cell seems to be reporting lower. It seems to indicate that 401 haste is needed to be haste capped instead of the 523 for an MM build. This is the value that came out repeatably for me after hitting Calc Attributes and with adding the current haste rating from gear with this value. This was done with no haste buffs.

Is this an error? Or am I misunderstanding how that field works?

Thanks for all the hard work on this great spreadsheet!

germanboy3383 · 11/25/08, 7:47 PM

thank you very much!!!

Handa · 11/25/08, 8:18 PM