Best Possible DPS in Shandaras WotLK Spreadsheet - Page 15

sharpshooter · 04/05/09, 6:16 PM

a SV hunter with 6k ap and 40crit can do how many dps in 25raid?how to dps?Explosive Shot, steady, steady for a cycle?shall i use aimed shot in it?

Koriani · 04/05/09, 6:57 PM

Ok I'm a newb at this spreadsheet thing but please bear with me - been reading for months and finally got around to getting Excel to try this out...

But I want to make sure I'm filling this out right and reading the results right

.

From what I understand (and what I've done)

I filled out current gear, talent spec, expected raid buffs, pet spec, shot rotations and saved all of that to the profile.

THEN I can go to "Gear Planner" and click on "sort" - and it will show me BiS based on all the above entered in information?

And then the overview is showing me an overview of my DPS and all that given the above saved information?

I wasn't really sure how "Gear Planner" and other buttons (sort, ranged weapons, etc) worked so I wanted to make sure I was reading it right

.

I don't have the standard Best BM Talent Spec right now (as given by the spreadsheet), nor access to Eye of Eternity (yet...we tried KT25 first time last night heh).

So I want to be sure I'm using this thing right and that its telling me the right BiSs for what I am right now

.

(For example, for me Tunic of Masked Suffering is BiS, but I know that for most of the other specs mentioned its not, Torn Web Wrapping isn't being listed as my best belt but again for most other of the specs it IS, And Grim Toll is a trinket on my list and I saw that for the other lists its not even on the top 10 heh).

Thanks for any advice/help!

stickums · 04/05/09, 7:22 PM

Originally Posted by Hunteralex

"Chest: [Valorous Cryptstalker Tunic] + [Powerful Stats], [Delicate Scarlet Ruby], [Delicate Dragon's Eye]"

Mostly everyone agrees that those are the best sockets for the Tunic but, I would like to disagree.

Option 1: 16 Agility Gem = 0.192 Critical Strike Chance + 16 Attack Power
Option 2: 7 Agility 11 Stamina Gem = 0.084 Critical Strike Chance + "X" amount of AP
+6 Critical Strike Rating Set Bonus = 0.130 Critical Strike Chance
(Socket Bonus From Valorous CryptStalker Tunic +6 Critical Strike Rating)

0.084+0.130 = 0.214 With Socket Bonus
*********** = 0.192 Without Socket Bonus
This small calculation I made shows that you will earn extra critical strike chance. This is why I disagree, if I am wrong will someone please correct me or tell me the reasoning behind the +16 agility socket.

For someone with JC they will put the Eye in the blue socket, giving the bonus anyway. Without JC a simpler calculation would be to weigh 9 AGI vs. +6 crit and ~3ap (30% of 11stam). Pretty sure the AGI would come out on top in that case.

shaoquin · 04/06/09, 4:31 AM

FWIW, I took the Best_DPS_84.xls spreadsheet from the first page and found a couple small upgrades for "BEST DPS SV" and "no consumables - no Heroic Presence". Someone correct me if these are not valid:

- Changed the [Delicate Dragon's Eye] on the [Chestguard of Flagrant Prowess] to [Delicate Scarlet Ruby]. The Socket Bonus of +6 Hit on the chest was not needed.
- Changed the [Delicate Scarlet Ruby] on the [Slime Stream Bands] to [Delicate Dragon's Eye]. This enables the +8 Attack Power on the wrist.
- Changed the [Elixir of Mighty Agility]/[Elixir of Mighty Thoughts] to [Flask of Endless Rage]. I know it has been common agreement that the 2 Elixir setup > 1 Flask but the spreadsheet disagrees for this particular gear/spec setup.

Pre-Change DPS:
Hunter - 5521.66
Pet - 1182.10
Total - 6703.76

Post-Change DPS:
Hunter - 5528.98
Pet - 1186.19
Total - 6715.16

Cheers!

Razeda · 04/09/09, 4:53 PM

I was using the PTR spreadsheet and my DPS is reading 7k+ am I missing something here? I have been reading posts that SV dps is worse on the PTR then on live? Can somebody clear this up for me ? Thanks.

Koonihc · 04/12/09, 8:56 PM

I play a tauren hunter and have completed all content available to date, including Twilight Vanquisher. I have read extensively about the spreadsheet and what the BiS items are for a SV hunter. I have a few of the "BiS" items and use the same rotation, people are saying i should see dps values of 6k +. I don't, plain and simple. I see maybe 3600 dps in naxx 25, and am like 9th or 10th on the recount.

My current, buffed only with Dragonhawk numbers are:

Agility 1283
Attack Power 4647
Hit 257
Speed 2.15
Crit 36.44%

My rotation includes, open with serpent sting, explosive shot, spam steady shot until explosive is ready again, than back to steady, When i get a lock and load proc, I hit explosive, multi shot, and than explosive, than back to my rotation.

I carry anywhere from 6fps to 15 fps, with an avg connection of 150 ms.

Any help to get me back on track would be appreciated, thank you

Malarahu · 04/12/09, 9:23 PM

You're gonna want to just do 3 Explosives in a row(with a half a second pause in between) when LnL procs, to get Explosive on cooldown as quickly as possible. The pause is to prevent clipping the last tick of Explosive Shot.

Rezdan · 04/12/09, 9:28 PM

To begin with, your shot rotation/priority is incorrect.
You should be using the following PRIORITY (not rotation):
Kill Shot
Explosive Shot
Multi / Aimed Shot
Serpent Sting
Steady Shot

The Survival thread will be able to give you more answers.

Anindor · 04/13/09, 4:06 AM

I'm still relatively new to the spreadseet game. In my current gear setup and planned 3.1 MM spec I am getting 6468 in the spreadsheet for my overall DPS. Is this decent for spreadsheet numbers? I was also wondering if it is possible to input a true rotation instead of a priority rotation. thanks.

Iru · 04/13/09, 10:47 AM

The BiS/MM profile in 86c (yes, I know I need to get the latest 3.1 sheet) shows a DPS of 6693, so I'd say you're doing ok - although I haven't looked at your gear.

Not sure what you mean by a "true" rotation - shot CDs of differing lengths make a genuine rotation impossible - but you should try looking at the shot rotation tab to see if that covers what you mean. You can then go to the Settings tab and tell the spreadsheet to use that rather than percentages if you're interested in the difference between the two (cell F13).

Anindor · 04/13/09, 3:57 PM

The Build that I'm playing with for MM is using gear to get me haste soft capped and using glyph of Chimera and Glyph of Aimed Shot, So my rotation would be Chimera, Aimed, Stead Steady Steady, repeat as needed. The only problem with this is putting in my opening rotation with Serpent sting and putting the rapid fires in the spreadsheet.

zápdos · 04/13/09, 7:10 PM

Originally Posted by Anindor

The Build that I'm playing with for MM is using gear to get me haste soft capped and using glyph of Chimera and Glyph of Aimed Shot, So my rotation would be Chimera, Aimed, Stead Steady Steady, repeat as needed. The only problem with this is putting in my opening rotation with Serpent sting and putting the rapid fires in the spreadsheet.

why no arcane shot?

Malta · 04/13/09, 11:55 PM

Originally Posted by Koonihc

I play a tauren hunter and have completed all content available to date, including Twilight Vanquisher. I have read extensively about the spreadsheet and what the BiS items are for a SV hunter. I have a few of the "BiS" items and use the same rotation, people are saying i should see dps values of 6k +. I don't, plain and simple. I see maybe 3600 dps in naxx 25, and am like 9th or 10th on the recount.

My current, buffed only with Dragonhawk numbers are:

Agility 1283
Attack Power 4647
Hit 257
Speed 2.15
Crit 36.44%

My rotation includes, open with serpent sting, explosive shot, spam steady shot until explosive is ready again, than back to steady, When i get a lock and load proc, I hit explosive, multi shot, and than explosive, than back to my rotation.

I carry anywhere from 6fps to 15 fps, with an avg connection of 150 ms.

Any help to get me back on track would be appreciated, thank you

Your Shot priorities aside, I'm in a similar boat. Although I am sitting a bit below hit cap (I tend to run with hit food at this point and I'm going to be re-evaluating my gear/gems come patch and Ulduar), my DPS output SHOULD be hitting over 6-7k at this point all things being equal.

I too get around 6-20fps (10-mans) on a good night and my MS is anywhere from 150-250. My priorities are correct, my procs, cooldowns, etc., are all correct. I get a bit higher DPS than you do, but overall, it's much lower than it should be... I've ran the numbers, I've seen the comparisons, I've explored every other possible situation including respecs, regears, regems, repets, refoods, re-everything (Current spec was another experiment). I can account for a loss in about 150-300 DPS here and there, but not nearly the 1-2k loss I'm seeing.

Sadly, I've come to the realization that the only way I'm fixing my DPS "cap" is to upgrade my video card, and worst case scenario, change servers to a closer time zone (PST on an EST server) so I can hit a higher FPS. Yes, horrible FPS such as the kind you and I are seeing can affect your DPS by as much as the 1-2k difference we're seeing over the course of a fight.

You can fix your shot priority a bit as was suggested, get hit capped, and yes, tweak something here or there, but I do honestly believe the bottom line is that with a bad fps and latency, there's a hard DPS "ceiling" that's hit that no amount of "Fixes" other than hardware will solve.

Added note, the length of a fight, the DPS of your raid, as well as the buffs you're running can greatly affect your DPS output. These are all things to consider. Try running the DPS scenarios with and without buffs as well and see if you're close either way. I've ran every situation both in game and in theory crafting/number crunching.

This is of course only my experience however, and the only solution left for me personally. YMMV.

P.S. ATI sucks I've come to find out. >.>

Anindor · 04/14/09, 2:38 AM

Originally Posted by zápdos

why no arcane shot?

Mistype. I meant to include Arcane. Chimera,Aimed,Arcane,Steady Steady Steady

Hunteralex · 04/14/09, 10:04 AM

Originally Posted by Koonihc

I play a tauren hunter and have completed all content available to date, including Twilight Vanquisher. I have read extensively about the spreadsheet and what the BiS items are for a SV hunter. I have a few of the "BiS" items and use the same rotation, people are saying i should see dps values of 6k +. I don't, plain and simple. I see maybe 3600 dps in naxx 25, and am like 9th or 10th on the recount.

My current, buffed only with Dragonhawk numbers are:

Agility 1283
Attack Power 4647
Hit 257
Speed 2.15
Crit 36.44%

My rotation includes, open with serpent sting, explosive shot, spam steady shot until explosive is ready again, than back to steady, When i get a lock and load proc, I hit explosive, multi shot, and than explosive, than back to my rotation.

I carry anywhere from 6fps to 15 fps, with an avg connection of 150 ms.

Any help to get me back on track would be appreciated, thank you

It's pretty plan and simple. You probably just do not have the right group composition. Unless you are following the spreadsheet exactly, then you will expect to see the numbers not as high up on the meters, also (As many posted before me) You need to work on your shot priorities which should be looked into on a different thread.