WotLK DPS spreadsheet - Page 98

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.