WotLK DPS spreadsheet - Page 59

Naneless · 01/28/09, 3:29 PM

Originally Posted by Garby

Do you have macros enabled?

No, nothing. Just downloaded the excel file and it is like this

Shandara · 01/28/09, 4:26 PM

Update:

- Fixed spelling on Vengance Shiv and Ritualistic Athame
- Added Anvil of Titans
- Fixed Tuskar's Vitality feet enchant
- corrected stats on arena gear and spelling on epic honor belt
- added Deadly Gladiator's Waraxe
- Hyperspeed Accelerators now have a 60s cooldown
- Shot Rotation priority queue now discounts invalid rotations (using Explosive/Arcane at the same time or Multi-Shot/Aimed Shot)
- Added Oracles/Frenzyheart trinkets
- Corrected ArP->Res on Savage Gladiator's Chain Spaulders
- Frog-Toe Band spelling fixed
- Fixed a bug with Glyph of Serpent Sting still providing +3s duration instead of +6s
- Added code for Mixology. So far only Flask of Endless rage numbers verified.
- Updated stats on Savage Cobalt Slicer
- Shot Rotation Test now uses IAotH properly
- Fixed some logic in the Shot Rotation test involving L&L
- Added Prismatic Sockets for gloves/bracers
- Added some more food options

I've tested the BS sockets with a few profiles I had, but please report if it gives any problems. You'll have to re-do your gear on import (because of the added sockets not being present in exported previous versions) but hopefully all your other settings should import properly.

The Mixology setting is present, but I could only find definite numbers for the flask of Endless Rage so far. If anyone has definite numbers on the improved version of other common elixirs/flasks I'll add them.

On the Shot Rotation Test tab I've made 2 changes. First when L&L procs Explosive Shot CD is reset immediatedly, in some cases before it wouldn't. Also it will now give a visual cue which Explosive Shots are because of L&L and which aren't.

EDIT:
One thing that might not be obvious right away is how to add BS sockets to an existing profile (rather than importing). Both gloves and wrist slots have an extra gem line now and you can change the socket type from 'no socket' to 'prismatic socket'. I'll have to work a bit on making this more user friendly for the next version but for now I'm already glad it works with the Armory.

jmlsteele · 01/28/09, 5:22 PM

[Corroded Saronite Woundbringer]
Change: 50 Hit Rating removed.

Kathris · 01/28/09, 5:51 PM

Socket Bonus on Chest not updating correctly. Socket Bonus always shows up as None regardless if you meet the color requirements.

Rezdan · 01/28/09, 9:15 PM

Originally Posted by Shandara

Update:
<snip>
On the Shot Rotation Test tab I've made 2 changes. First when L&L procs Explosive Shot CD is reset immediatedly, in some cases before it wouldn't. Also it will now give a visual cue which Explosive Shots are because of L&L and which aren't.
</snip>

Shandara, I don't believe that when L&L procs the Explosive Shot CD is reset. I've observed this on Live and currently Explosive Shot stays on cooldown if its used before an L&L proc. It is the *next* use of Explosive Shot that has no cooldown.

Example:
If you fire Explosive Shot at 0 seconds, it will only become available at 6 seconds regardless of whether or not LnL procced during the 6 second cooldown.

Perforate · 01/28/09, 10:14 PM

Originally Posted by Rezdan

Shandara, I don't believe that when L&L procs the Explosive Shot CD is reset. I've observed this on Live and currently Explosive Shot stays on cooldown if its used before an L&L proc. It is the *next* use of Explosive Shot that has no cooldown.

Example:
If you fire Explosive Shot at 0 seconds, it will only become available at 6 seconds regardless of whether or not LnL procced during the 6 second cooldown.

This is true. eats time from my LnL timer too, especially considering I interlace a ss in between each charge on a LnL proc. I still get both shots off, but its kind of annoying.

dotcow · 01/28/09, 10:17 PM

Just curious but why is the spreadsheet now showing Mirror of Truth > Bandit's Insignia? It was vice versa prior to this updated spreadsheet. Just wanted to make sure it wasnt an error

Hauraki · 01/28/09, 10:39 PM

Trinket [Madness of the Betrayer] not included, while some other similar level TBC trinkets e.g. [Berserker's Call] are still available.

jmlsteele · 01/29/09, 12:06 AM

Updated Pawn String Exporting

Changed:
Adds name based on the profile you have loaded, not a constant string.
Takes into account 1% crit racial bonuses for trolls and Dwarves for their respective weapons.
Changed order/added spacing for better human readability.

="( Pawn: v1: """ & SelectedSet & """: " &
"Agility=" & ROUND(DPSAgility,3) & 
", Stamina=" & ROUND(DPSStamina,3) & 
", Intellect=" & ROUND(DPSInt,3) & 

", RedSocket=" & ROUND(RedGemDps,3) & 
", YellowSocket=" & ROUND(YellowGemDps,3) & 
", BlueSocket=" & ROUND(BlueGemDps,3) & 
", MetaSocket=" & ROUND(MetaGemDPS,3) & 


", HitRating=" & ROUND(DPSHit,3) & 
", CritRating=" & ROUND(DPSCrit,3) & 
", HasteRating=" & ROUND(DPSHaste,3) & 

", Ap=" & ROUND(DPSAP,3) & 
", Rap=" & ROUND(DPSAP,3) & 
", ArmorPenetration=" & ROUND(DPSArmPen,3) & 

", Mp5=" & ROUND(DPSMp5,3) & 

IF(RaceSelected="Dwarf",", IsGun=" & ROUND(DPSCrit*CritRating,3),"") & 
IF(RaceSelected="Troll",", IsBow=" & ROUND(DPSCrit*CritRating,3),"") & 

" )"

Kharthus · 01/29/09, 1:02 AM

Originally Posted by jmlsteele

Updated Pawn String Exporting

Changed:
Adds name based on the profile you have loaded, not a constant string.
Takes into account 1% crit racial bonuses for trolls and Dwarves for their respective weapons.
Changed order/added spacing for better human readability.

I was just about to grab Pawn, but how do you use this?

Swiftdraw · 01/29/09, 1:44 AM

Would it be possible to add the Engineering: Sonic Noisemaker, Mark of the War Prisoner, and Figurine-Twilight Serpent trinkets? I would setup a custom trinket, but don't see an option to do so.

Garby · 01/29/09, 1:46 AM

Originally Posted by Swiftdraw

Would it be possible to add the Mark of the War Prisoner and Figurine-Twilight Serpent trinkets? I would setup a custom trinket, but don't see an option to do so.

Why? Nothing we have scales with spell power.

Dch48 · 01/29/09, 1:51 AM

V83 will not import any values or gear from v82 and I do not have any of the added sockets.

Swiftdraw · 01/29/09, 2:26 AM

Originally Posted by Garby

Why? Nothing we have scales with spell power.

For the Hit Rating and how it would free up gem slots?

Garby · 01/29/09, 2:30 AM

Originally Posted by Swiftdraw

For the Hit Rating and how it would free up gem slots?

There's absolutely no way that spellpower gear is worth considering for hit rating. Get a physical hit trinket like the [Sphere of Red Dragon's Blood].

By the way, the [Sonic Booster] does not proc from ranged attacks.

Shandara · 01/29/09, 3:04 AM

Small update:

- Fixed chest slot socket bonus
- adjusted Corroded Saronite Woundbringer stats
- Added updated PAWN string courtesy of Jmlsteele
- added the accidentally deleted Madness of the Betrayer back in
- Adjusted L&L logic on shot rotation test again
- Fixed import issue

I retested L&L this morning and I couldn't reproduce my results from last night (then again the awful lag has cleared up). And I have to admit, ES doesn't reset immediatedly (although I swear it did for me last night, but I guess it was wishful thinking).

Swiftdraw · 01/29/09, 4:05 AM

Originally Posted by Garby

There's absolutely no way that spellpower gear is worth considering for hit rating. Get a physical hit trinket like the [Sphere of Red Dragon's Blood].

By the way, the [Sonic Booster] does not proc from ranged attacks.

Thank you for stating the obvious. I didn't ask for your opinion on what the better trinkets are. I understand there are better trinkets. I asked to have these added to the spreadsheet so I can see how they affect my DPS until I do acquire a better trinket. If they can't be added to the spreadsheet, can an option to make Custom trinkets be added?

I don't have the Sphere of Red Dragon's Blood yet. So, I'd like to know how using the Mark of the War Prisoner affects my DPS by replacing +hit gems with +AGI gems UNTIL I DO ACQUIRE A BETTER TRINKET.

As for the Sonic Booster....+STA affects DPS in Survival. I'm only asking to have them added so I can do comparisons. I thought that was the point of the spreadsheet. I don't care about the Sonic Booster proc.

BTW, the +HIT on Mark of the War Prisoner does affect ranged hit rating and has significantly more than the Sphere of Red Dragon's Blood.

Rezdan · 01/29/09, 4:38 AM

Originally Posted by Swiftdraw

Thank you for stating the obvious. I didn't ask for your opinion on what the better trinkets are. I understand there are better trinkets. I asked to have these added to the spreadsheet so I can see how they affect my DPS until I do acquire a better trinket. If they can't be added to the spreadsheet, can an option to make Custom trinkets be added?

Set your trinket to None and do a Hand Adjust with the trinket's relavent stats.

Swiftdraw · 01/29/09, 4:55 AM

Originally Posted by Rezdan

Set your trinket to None and do a Hand Adjust with the trinket's relavent stats.

Thank you. I'll have to do some research to see how to do a "Hand adjust".

jmlsteele · 01/29/09, 5:57 AM

Hand adjustments are done by changing the numbers at the bottom of the gear page in the blue row.

Swiftdraw · 01/29/09, 8:19 AM

Originally Posted by jmlsteele

Hand adjustments are done by changing the numbers at the bottom of the gear page in the blue row.

A ha! Thank you.

Midnight · 01/29/09, 9:16 AM

There´s no [Elixir of Accuracy] available as battle elixir. This is quite important to me as the 5 points hit rating it grants over the [Snapper Extreme] buff food make or break my reaching the hit cap.

daeranmoth · 01/29/09, 9:50 AM

hello everybody !

First time poster.
I have 290hit rating only given by stuff (0/3 FA) and the speardsheet says that +1 Hunter hit is 1,3dps value just behind the Agility at 1,436dps. I'm spec survival 2/18/51.
I would like to know WHY because I'm 26 over the hit cap.
Thank you by advance for your answers.
Have a nice day.

Seoman · 01/29/09, 11:32 AM

@daeranmoth

Where does hit +1 show a DPS boost after cap? Hand Adjusting +1 Hit on the Gear tab? I can't reproduce that. I see the Hit% increase, but DPS doesn't budge once capped. The Gear tab is going to be the best and most accurate place to see any actual benefit from any +'s or gear changes.

daeranmoth · 01/29/09, 11:49 AM

Thank you seoman but i was talking about the tab "overview" and in the hunter statistics section after hitting the buton "calcattributes" it shows me that hunter hit +1 is equal to 1,415dps and is the second best after the agility+1 which is equal to 1,423dps. In the "needed to cap hit" i have " -27" which is correct.
Is it a bug for the hunter hit +1 or not ?

ps: If i hand ajust in the gear tab and up my hit rating over 290 it doesn't change my total dps.

thank you for your answers mates !