WotLK DPS spreadsheet - Page 68

ra1330 · 02/23/09, 3: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, 4: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, 4: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, 4: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, 4: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?

Kharthus · 02/23/09, 4: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, 5: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, 5: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, 6: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, 9: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, 11: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, 5: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, 5: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, 5:43 AM

Armoury is probably down/unreachable for you

Shumee · 02/25/09, 8: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, 10: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, 10: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, 11: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, 11: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, 12:55 PM

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

Shandara · 02/25/09, 1:00 PM

Originally Posted by ankah

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

As long as Kill Shot is in your rotation the extra dps it provides sub-20% is automatically calculated and added.

I'm not sure what you mean with aspect of the hawk not adding dps though. It is properly giving the extra AP and with improved aspect of the Hawk is properly giving the auto-shot dps increase.

ankah · 02/25/09, 1:05 PM

Originally Posted by Shandara

As long as Kill Shot is in your rotation the extra dps it provides sub-20% is automatically calculated and added.

I'm not sure what you mean with aspect of the hawk not adding dps though. It is properly giving the extra AP and with improved aspect of the Hawk is properly giving the auto-shot dps increase.

Maybe its just my puter playing mind games with me, but on the talents page, it does not add or subtract dps with improved aspect of the hawk (I think I was not very detailed at first, my apologies).

I see what you mean about kill shot, and it is being calculated on the over all dps. I did not see it past timed used, so I thought it was not calculating properly, my apologies again.

Sartuk · 02/25/09, 1:09 PM

Originally Posted by Gaj

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.

The biggest thing I'm noticing is the lack of non-Explosive/Serpent Sting special shots you fired. While your guild's Patch time was definitely short (and obviously affected the number of specials you could get off) you only fired a combined 22 Steadies/Multishots. In a 3.24 minute Patch last night, for example, I fired a combined 75 Steady/Aimed shots. While I'm not digging too deep into your WWS, it seems like you're having a *lot* of open time where you could be fitting in more multishots or at the very least more Steadies. For some reference here's the WWS

thehittmann1981 · 02/25/09, 1:27 PM

Originally Posted by Sartuk

The biggest thing I'm noticing is the lack of non-Explosive/Serpent Sting special shots you fired. While your guild's Patch time was definitely short (and obviously affected the number of specials you could get off) you only fired a combined 22 Steadies/Multishots. In a 3.24 minute Patch last night, for example, I fired a combined 75 Steady/Aimed shots. While I'm not digging too deep into your WWS, it seems like you're having a *lot* of open time where you could be fitting in more multishots or at the very least more Steadies. For some reference here's the WWS

Yep i noted same plus a whole lot more missing buffs / debuffs etc, sent PM Gaj

Bokomatic · 02/26/09, 5:59 AM

Two day ago I found new sevice at wowhead.com
It's Stat Weighting tool, curently in beta state.
There is a possibility to import there Shandara's weights and next browse top gear by wowhead interface.

I added wowhead-url generating feature in my shandara-postprocessor.
New version available here: PawnSplitter_v13.zip

It generates urls like these: Boko without hitcap and Boko hitcapped.
Clicking to scale values in these pages you can change normalization modes: autonormalized, not normalized and percent normalization.
For seeing numbers corresponding Shandara spreadsheet you should set up not normalized mode.