WotLK DPS spreadsheet - Page 113

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

Issue with Eternal Belt Buckles in the last version:

It won't let me add a gem to my belt after adding the Eternal Belt Buckle. The drop-down list won't show at all.

Ok, I can add the gem by typing it in, but the drop-down doesn't work.

Sapphique · 02/23/09, 4:06 PM

Originally Posted by Eraist

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.

Try using something like:
#showtooltip Explosive Shot
/console Sound_EnableSFX 0
/cast Kill Shot
/cast Kill Command
/cast Explosive Shot
/console Sound_EnableSFX 1

and

#showtooltip Steady Shot
/console Sound_EnableSFX 0
/cast Kill Shot
/cast Kill Command
/cast Steady Shot
/console Sound_EnableSFX 1

with your pet abilities Rabid, Rake, and Claw set to autocast. The days of spamming 1 button are over, for better or worse. You need at least 2 buttons now to be successful. Note that when you re-summon or revive your pet, mount and dismount, or cross a zone boundary, your pet abilities may be toggled (known bug). Make sure that each time your pet is "spawned," you check your autocast settings and make sure that they're correct. It may seem easier to put them in your macro, but it is more reliable in my experience to have them autocast and be vigilant to ensure that they're set properly.

If you have Aimed Shot talented, you should have a macro like the above for that, too, and you should be using it every cooldown.

With these changes, you should see your DPS get much closer to the spreadsheet theoretical.

Eraist · 02/23/09, 4:18 PM

Yeah, don't really care how many buttons to hit, I use a minimum of 3 sometimes 4, as I manully weave shots in and refresh Serpent sting.

On my old macros /13 always worked and Rabid always hit when it was up. I'm still not sure how these guys are hitting in the high 5K range.

I appreciate the help though, I'll test these out. Thx

Shandara · 02/23/09, 5:11 PM

Originally Posted by Nageya

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

Hit the "CalcAttributes" button to fix this, the reason the card is worth 0 dps is because agility is valued at 0 dps in the up-loaded sheet at the moment (I forgot to recalculate before I uploaded after testing some unrelated things).

Bokomatic · 02/23/09, 8:39 PM

I've never posted to this thread.
So, first I greatly appreciate Shandara for his effort in improvement of this amazing spreadsheet.
Before nerf of BM-spec I had my own spreadsheet made by me just for me, just for BM and just for my talent-spec.
Firs time after nerf i didn't know what to do... But, thanks God, i've found this thread and this spreadsheet.
Thanx, Shandara!

Of course i've faced with some problems:

1) I have russified Windows installed where comma is used as decimal point. So i see in spreadsheet pawn-string with decimal commas. Pawn doesn't understand them. It's fixable, i just changed regional settings in th Windows and my Excel put dots there. However, not all of us know how to do it and not all want this change.
As far as i know frech version of windows does the same with decimal point.

2) My character is troll and he has Bow crit bonus. In the pawn-string 'isBow=' was separated by semicolon instead comma. Am I right that it's already fixed in latest version?

In addition, using spreadsheet+pawn during some time, I noticed that i always do several manual operations:

3) Calculating what gem is best for each color of socket.
4) Calculating what better: achieve socket bonus or not.
5) Calculating of difference in enchants of two 1-handers or one two hander
6) Splitting stat weights into two pawn-sets, "Hitcapped" (zero weight of Hit rating) and "No hitcap" (original Shandara's weights).

I think that fruitful way for itemisation is collecting two gearset.
One of them accords with "Hitcapped" weights, it has small amount of +hit, but alot of another stats.
Second one is based on "No hitcap" weights, this gear has lots of +hit, wearing this set causes hit overcap.

There is easy procedure to combine them into one set:
1. Wear "No hitcap" set.
2. If there isn't overcap, finish procedure.
3. Find a slot where [ pawnvalue(No hitcap) - pawnvalue(Hitcapped)] is minimal.
4. Diswear item (in this slot) from "No hitcap", wear item from "Hitcapped", our overcap becomes smaller.
5. Go to (2)

Finally i'd made small spreadsheet. It's collection of small auxiliary tools.
It works as post-processor of Shandara's pawn string.
In other word you need to copy pawn-string from Shandara spreadsheet and paste into my one.

Spreadsheer is made in MS Excel 2007, saved for 2003, tested in 2003.
There is no macros, no VB, no iterations, just plain formulas.

Download here: PawnSplitter_v11.zip

NB! You should paste string by "Paste Special"->"Values" (available in right click menu)
In other case Excel becomes stupid and makes spreadsheet broken

What it can do:
1) It get as input pawn-string generated by Shandara spreadsheet.
2) Find best gems into socket of each color.
3) Provide patched pawn-string with best gems embedded.
4) Find best enchants for 2x1h and 1x2h.
5) Calculate difference between these enchants.
6) 'Socketing helper' tool: comparing achieveing socket bonus with best gem in all sockets.
7) 'Compare anything' tool: you enter stat combination, tool calculate equal dps. There is food now for example.
8) Split weights to "Hitcapped" and "No hitcap" sets, providing all described above tools for both of them.
9) Generate 3 output pawn-strings "Original", "Hitcapped" and "No hitcap" fixing there 'comma/dot' and 'isBow' issues.

I hope Shandara finds interesting ideas and/or excel tricks worthy for including in main spreadsheet.

thehittmann1981 · 02/24/09, 10:47 AM

@Eraist

I'm also at around 6100dps on the Spread Sheet
I think that you are gimping your dps somewhat by using that macro.

Explanation:
If L&L procs and you use your macro and you randomly get Explosive Shot, Explosive Shot, Explosive Shot... You've wasted your L&L by not letting each Explosive Shot get full benefit from the tics. Also like you said "if it does not proc from cast random you hit it manually" That is already a dps loss. If you had just manually cast it in the first place you wouldnt have had to waste another GCD and a cast time of a Steady Shot.

You do not need Your pets attacks in the Macro. You may also be reducing your pets damage by doing that.

The macro I use is:

#showtooltip Steady Shot
/castsequence reset=shift/target serpent sting, null
/cast [target=pettarget, exists] Kill Command
/cast Kill Shot
/cast Steady Shot
/script UIErrorsFrame:Clear()

I then manually shoot all Explosive shots, manually refresh stings (only in place of shooting a steady), manually weave multi every available CD (yes it even does more damage than steady on single targets).

I do around 5700 on Patch the other Hunter in my guild does around 5300.

Shumee · 02/25/09, 4:41 AM

Recently I have a problem when I want to refresh my gear from the armory, it says that my character doesn't exist on the server. It worked perfectly before.

I redownloaded the newest version and still have the same problem.
Also tried to just refresh the default values (Shandara) and get the same problem.

Changing computers and network didn't help either.

Any ideas?

Jerem · 02/25/09, 4:43 AM

Originally Posted by Shumee

Recently I have a problem when I want to refresh my gear from the armory, it says that my character doesn't exist on the server. It worked perfectly before.

I redownloaded the newest version and still have the same problem.
Also tried to just refresh the default values (Shandara) and get the same problem.

Changing computers and network didn't help either.

Any ideas?

This is typically what happens when the Armory is down, or not accessible (the Armory's URL might be blocked by your network settings, etc).

Iru · 02/25/09, 4:43 AM

Armoury is probably down/unreachable for you

Shumee · 02/25/09, 7:11 AM

Originally Posted by Iru

Armoury is probably down/unreachable for you

I though so aswell, but I can easily access eu.wowarmory.com, login, check my char etc.

Shandara · 02/25/09, 9:00 AM

Update for PTR:

- Fixed Spicy Wyrm burger (hopefully, finally). This involved re-doing some old parts of the buff tabs with new code, so hopefully it hasn't broken anything else.
- Wild Quiver now 80% nature damage with 4/8/12% proc chance
- RWS now a 3-pt talent for 1/3/5% extra damage
- Added Black Arrow to shot rotation tab and calculations
- Hunting Party now also grants +1% agility per talent point and is only 3-pt talent for 33/66/100% proc chance
- Sniper training settings changed to Yes/No. Now affects Black Arrow and no longer Arcane Shot.
- Lock And Load now procs off Black Arrow instead of Serpent Sting
- T.N.T. now increased Explosive Shot damage by 2/4/6% instead of critical strike chance
- Implemented Piercing Shots change like warrior's Deep Wounds (assumption for now)
- Changed Shot Rotation test calculations to use Black Arrow instead of Serpent Sting for L&L procs. Also added a visual marker for when Black Arrow's debuff is active.
- Added Ferocity pet tree talents: Shark Attack, Wild Hunt
- Glyphs changed/added: Aimed Shot, Aspect of the Hawk, Chimera Shot, Kill Shot
- Both Black Arrow and Serpent Sting now benefit 100% from their respective self-buff damage modifier instead of getting the avg out effect.
- Explosive Shot now 16% scaling
- Re-checked AP/Stamina scaling for pets, should be very accurate now
- Sunder Armor/Faerie Fire changed to %-based armor modifiers.
- Changed profiles to support new pet talents. Old talent settings in saved profiles will not load.
- Fixed some strange calculations involving Frenzy
- added damage debuff for Black Arrow

The current LIVE V84 can be downloaded from a link on the first page.

I've tried to add as a many PTR data as I could but I might have missed some, post here if you know of something not covered yet.

Jerem · 02/25/09, 9:05 AM

Amazing work Shandara, thanks.

I am getting the spreadsheet now and am going to check, but I think, from your patch note, that you maybe forgot:
- Glyph of Explosive Shot *new* -- Increases the critical strike chance of Explosive Shot by 4%.

EDIT: no, I am not getting the sheet, Not yet

Gaj · 02/25/09, 10:00 AM

Originally Posted by thehittmann1981

The macro I use is:

I then manually shoot all Explosive shots, manually refresh stings (only in place of shooting a steady), manually weave multi every available CD (yes it even does more damage than steady on single targets).

I do around 5700 on Patch the other Hunter in my guild does around 5300.

I'm doing something seriously wrong then. With close to the BiS surv gear, last night I only hit 4313 on Patch (2.37min kill). This isn't even close to what I can model on the Spreadsheet. Not trap dancing and manually weaving shots.

Shandara · 02/25/09, 10:31 AM

Small update:

- Added new Glyph of Explosive Shot
- Added Immolation Trap. You can set the amount of GCDs you need to lay down the trap on the settings tab.
- Implemented Glyph of Immolation Trap
- L&L will now proc from Immolation Trap periodic damage

Since Explosive Shot refreshing Immolation Trap isn't on the PTR (yet if ever) it hasn't been implemented.

ankah · 02/25/09, 11:55 AM

Maybe it's just me and something I am doing wrong, but this newest version of the spreadsheet is not adding any dps for Kill shot, or aspect of the hawk.

Is ISS being taken into account with Piercing shots? It does not look to me as if it is increasing the base dps of aimed or chimera