That formula is helpful although that doesnt quite solve the problem, yet.
Taking into account only quiver haste an SS would take 1.7 seconds to fire so 3x 1.7 (SS) + 1.5 (ES) + 4 x 0.2 (latency) = 7.4 meaning 1.4 second delay which is more than 0.85. The breaking point for a person with 200 ms latency would be around 1.4-0.85 = 0.55 s over 3 SS which means he would need to be around 1.517 seconds casting time per SS (which is pretty much the softcap) so actually for a person with around 200 ms latency the switch might never yield more DPS outside of the sandbox. This is even more clear when you take into account that the formula doesn't consider the increased mana cost of a tighter rotation.
However all of this only applies to a rotation where you do ES,3xSS, ES vs. ES,2xSS,ES whereas most of the time you will weave in more valuable shots than SS between your ES. So I still assume that for many people its never a good idea to cast 3 consecutive SS if specced survival and that haste rating below the softcap was overvalued before the newest version (which is moot now).
I have good gear (mostly T7.5, Blue Aspect helm, Slime stream bands, boots of renewed flight, envoy of mortality...) and my DPS is meager at best. I usually am MM with 11/53/7 The World of Warcraft Armory
I've done testing against the heroic target dummy and get ~2400 DPS (consistently). If i go to the spreadsheet, remove all buffs, gems, and enchants, I can get it close to what i've seen.
It is as if I am only doing damage according to auto shot and specials.
My son has a warrior with the same problem.
4 separate computers, with and without addons, but same router.
Anyone every seen this before?
I have good gear (mostly T7.5, Blue Aspect helm, Slime stream bands, boots of renewed flight, envoy of mortality...) and my DPS is meager at best. I usually am MM with 11/53/7 The World of Warcraft Armory
I've done testing against the heroic target dummy and get ~2400 DPS (consistently). If i go to the spreadsheet, remove all buffs, gems, and enchants, I can get it close to what i've seen.
It is as if I am only doing damage according to auto shot and specials.
My son has a warrior with the same problem.
4 separate computers, with and without addons, but same router.
Anyone every seen this before?
Well, are you using the same rotation as in the spreadsheet? Are all debuffs on your target removed? What numbers does the spreadsheet give you?
That formula is helpful although that doesnt quite solve the problem, yet.
Taking into account only quiver haste an SS would take 1.7 seconds to fire so 3x 1.7 (SS) + 1.5 (ES) + 4 x 0.2 (latency) = 7.4 meaning 1.4 second delay which is more than 0.85. The breaking point for a person with 200 ms latency would be around 1.4-0.85 = 0.55 s over 3 SS which means he would need to be around 1.517 seconds casting time per SS (which is pretty much the softcap) so actually for a person with around 200 ms latency the switch might never yield more DPS outside of the sandbox. This is even more clear when you take into account that the formula doesn't consider the increased mana cost of a tighter rotation.
However all of this only applies to a rotation where you do ES,3xSS, ES vs. ES,2xSS,ES whereas most of the time you will weave in more valuable shots than SS between your ES. So I still assume that for many people its never a good idea to cast 3 consecutive SS if specced survival and that haste rating below the softcap was overvalued before the newest version (which is moot now).
Alright so as SV should some floater talents be used to pump IAoTH until "soft haste capped" Even though the spreadsheet points to other talents as more of a dps gain Ex: Improved stings.
Also 2 points into GftT still seems to be a large dps gain ( compared to other floater / filler talents) (Also my crit raid buffed is slightly below 50%) Is this really the case or am I missing something.
I am also seeing increased dps from 2 points in GftT...which wasnt the case pre 3.1. Does this really apply in raiding?
Also concerning the gear planner. I have weird results. Gear that is giving me lets say a marginal DPS decrease, actually gives me an increase when putting it in the gear tab, and gemming accordingly. Ok someone may say that the new gear may have Hit rating that goes above the hit cap and isnt counting.
But this also happens when there is no hit rating involved. For example gear planner is showing [Blunderbuss of Khaz Modan] giving me 17 dps more than [Nesingwary 4000]. (Yes I have clicked the Ranged Weapon button).
When I actually change it on the gear tab, I have a dps decrease....and that happens fully buffed and unbuffed.
Hello.
A really silly question, and I'm sorry for bringing it up in here.
I'm using Office 2007 with excel macro protection disabled on a Vista OS. When I click on a macro it just selects the text as if there's no button there.
I asked around and poked my Vista a bit but alas the damn thing doesn't get fixed. Can I get any help in here? It's probably something stupid that I've overlooked. :<
Thanks.
It's a security setting in Excel when using macros. When you open up Excel do this:
Click on the Office Icon in the upper left corner.
In the window it brings up at the bottom right corner there should be a button "Excel Options",
When you bring that up there is a column in the window, second to last item in the column is Trust Center.
Open that and then enter the Trust Center Settings.
The next window it brings up also has a column of options, click on Macro Settings.
From here you can do a couple things. You can either just enable all macros or you can tell it to disable all with notification. If you choose the former you never have to worry about it, if you choose the latter you have to select to run macros when you open the spreadsheet everytime.
Request: Would it be possible to change the 2h/1h enchant comparisons? Set up a drop-down tab for 1h enchants like there is for the 2h weapon, so that its easier to compare different weapon setups using Accuracy vs Exceptional Agility (depending on current +hit) without changing my current gear layout.
a) i recently switched from a previous spreadsheet version (pre ulduar hard mode integration) to the new version currently online. my dps decreased significantly. is that correct (due to the spreadsheet being now closer to the reality), or did you miss something?
b) Could you maybe - i know its a pain in the ass - put the boss names in the gear tab? Because, I find it hard to keep track of all the items and their location. Usually when I raid, I just put my spreadsheet on the second display to check if a drop would be an upgrade to my current gear etc. I generally do alot checking and comparing via Spreadsheet. It would help alot if the location would be named after the boss, not the instance. For example: Kologarn-10 Hard instead of Ulduar-10 Hard. Everyone should know by now that Kologarn is from Ulduar
There's a change log on one of the tabs of the spreadsheet.
The change logs state that there were a few fixes that went through and these changes are probably the source of your lost dps. The biggest impacting ones in my mind would probably be that the old version's 2pc T7 was incorrectly giving the pet a +5% AP bonus and that Explosive Shot may have previously been awarding GftT focus.
Last edited by Rezdan : 05/07/09 at 6:11 AM.
Reason: removed quote - and apparently missed a few words
It's a security setting in Excel when using macros. When you open up Excel do this:
Click on the Office Icon in the upper left corner.
In the window it brings up at the bottom right corner there should be a button "Excel Options",
When you bring that up there is a column in the window, second to last item in the column is Trust Center.
Open that and then enter the Trust Center Settings.
The next window it brings up also has a column of options, click on Macro Settings.
From here you can do a couple things. You can either just enable all macros or you can tell it to disable all with notification. If you choose the former you never have to worry about it, if you choose the latter you have to select to run macros when you open the spreadsheet everytime.
I modeled both items with custom gear in the spreadsheet and, for a dwarf, giant's bane still comes up best with 19 dps more than the xbow in full BiS gear, unfortunately I couldn't find a way to make use of the extra hit from the xbow.
The staff is giving a 0.3 dps upgrade over Lotrafen, if socketed with x2 16 agi gems.
I might have modeled the items wrong somehow though, need official update!
I have a question about how to fill in the "shot rotation" tab...
As a MM hunter, I usually start the fight with SrS and never have to reapply it again (Chimera refreshes it) - how should that be entered into the shot roatation tab?
I also wait until my trincket is fully stacked (FoFF) before going Rapid Fire > Chimera > Aimed > Arcane > Steady > Steady >Chimera > Aimed > Arcane > Readiness (and then repeat) How should that be entered? :S
If some of the above can't be entered in exactly, thats cool - I just want to get it as accurate as possible.
I modeled both items with custom gear in the spreadsheet and, for a dwarf, giant's bane still comes up best with 19 dps more than the xbow in full BiS gear, unfortunately I couldn't find a way to make use of the extra hit from the xbow.
The staff is giving a 0.3 dps upgrade over Lotrafen, if socketed with x2 16 agi gems.
I might have modeled the items wrong somehow though, need official update!
Putting an 8agi/12stam gem would make more sense because you're not only 32agi boosted again but also get 12stam out of it.
Edit: Ooh, the other socket is yellow not red. My bad.
Hello everyone, i have been reading your forums and trying to find similar requests but have failed. I have only been playing a year and have enjoyed my dps up untill I got recount and was told about your sight. In the spreedsheet it says i do 2390.57 unbuffed and with pet it tops out at 2574.75. I follow the shot rotation on a target dummy and get about 2350dps. In a 5 man of UP last night with buffs i only got 1900dps following the same rotation. Am I missing something??
If there is a similar thread please point me there.
Hello everyone, i have been reading your forums and trying to find similar requests but have failed. I have only been playing a year and have enjoyed my dps up untill I got recount and was told about your sight. In the spreedsheet it says i do 2390.57 unbuffed and with pet it tops out at 2574.75. I follow the shot rotation on a target dummy and get about 2350dps. In a 5 man of UP last night with buffs i only got 1900dps following the same rotation. Am I missing something??
If there is a similar thread please point me there.
If you are looking at recount for the entire instance, yes it will be low. After completing a stand and shoot boss fight, check the most recent fight in recount. It would give you a better idea of where you are. As for the spread sheet, it's very very difficult to get near it's dps values. It's more helpful for compairing gear options than for telling you what dps you should do personally.
Also, you need to replace the anvil. It shares a cd with mirror, so you aren't getting the benifit of having it other than the static resiliance (not a help).
the 88a revision doesn't seem to notice when you aren't gemmed properly to receive the meta gem bonus. i could be wrong but think this used to work in the 87 or 86 version.
Needless to say, this totally threw off the gear planner (some gear was being listed as being worth negative total dps), though the regular gear tab was still working normally.
I am also seeing increased dps from 2 points in GftT...which wasnt the case pre 3.1. Does this really apply in raiding?
Also concerning the gear planner. I have weird results. Gear that is giving me lets say a marginal DPS decrease, actually gives me an increase when putting it in the gear tab, and gemming accordingly. Ok someone may say that the new gear may have Hit rating that goes above the hit cap and isnt counting.
But this also happens when there is no hit rating involved. For example gear planner is showing [Blunderbuss of Khaz Modan] giving me 17 dps more than [Nesingwary 4000]. (Yes I have clicked the Ranged Weapon button).
When I actually change it on the gear tab, I have a dps decrease....and that happens fully buffed and unbuffed.
I'm noticing some problems with 88a and trying to enter the new staff as a custom. Entering it as a main hand custom results in the spreadsheet thinking it has a socket bonus of 8 strength & 35.98 haste. Entering it as a custom off hand, the socket bonus isn't applied, although it's listed as Achieved.
Thank you for your reply I will check out my next boss fight dps. Also, i forgot to take Anvil off and re-equip Sphere of Red Dragon's blood. I Will continue to use your spreedsheet to tweek gems and Talents. Atleast I understand how to use it...
according to the spreadsheet the shoulders i currently have tier 7.5 are better than tier 8.5 from the gear planner tab. Is that a bug or is that suppose to be like that. I do have like 100 hit over the cap, so maybe that is it, but still pretty weird. Any explanation would be nice, thanks.