WotLK DPS spreadsheet - Page 57

Thelastdeadmouse · 12/05/08, 4:54 PM

Originally Posted by Uli

I have a question about how hit rating works on the spreadsheet.

On the Gear tab, I have 100.91% hit. So, theoretically, adding more hit to an item should not make my dps go up, right? But if I create a custom version of an item I already am wearing, and add hit to it, my DPS still goes up.

This is making it hard for me to evaluate items once I'm at the hit cap.

Am I right in saying that having >100% hit should not increase the dps on the spreadsheet? Is this a bug or am I missing something? Thanks.

Do you have points in Focused Aim? Hit from Focused Aim does NOT apply to pets, so you will see a DPS increase until your pet also gets to its hit cap.

dragoonvengance · 12/05/08, 5:45 PM

def don't use rawr for the numbers it gives you the hunter calculations are very outdated and wrong.

On another note I was messing with aspect of the beast and for a quick test I messed with the spread sheet again teh spreadsheet still is using the value state of 110% but it for some reason is giving the pet 21%. Wondering if mabye since my melee goes up my pet double dips? Doubtful and the numbers would probably nto add up, but on the real note.

If i look at my pet raid buffed then assume another 21% because of beast that means he would gain almost 600ap because of the aspect. So what I did was i setup the spreadsheet to have hawk on without pally blessing of 550 ap. DPS is 3927. Now with no aspect on and turning on the blessing for my pet that should "kinda of" model having beast give him 21% ap. The DPS is 4033.57dps

Suggesting that in a raid Beast would be better to use and I would gain over 100dps because of it.

Any opinons and has anyone tested this out in raid.

Shandara · 12/05/08, 5:48 PM

Update:

- Gear planner now has a 25-man and a 10-man filter
- Fixed some items which were attributed to the wrong instances on the Gear Planner
- Implemented Rapid Recuperation for hunter mana costs and pet focus costs during Rapid Fire
- You can now hand adjust the pet crit%/AP and %damage modifiers on the gear page
- Added option to use the new assumed 8% hit cap on bosses on the Settings tab (default= Yes)
- Fixed Pawn string. Gems with +AP will now add dps from AP correctly
- Careful Aim is now more accurate
- Added Fel Intelligence to buffs and fixed various buffs to be more in-line with the wotLK talents (exported buff profiles will fail to load, sorry)
- Added an option to use Aspect of the Beast during Bestial Wrath, this will reduce Hawk uptime
- Added Enchanted Tear/Pearl gems
- Various fixes to missing socket bonuses

Scrith · 12/05/08, 6:06 PM

Thanks so much for all your efforts to improve this wonderful spreadsheet in such a timely manner!

Elendril · 12/05/08, 6:36 PM

Finally got it working - thanks much for this. One note - the weapon enhancement category with oils is active for level 80, when oils/sharpening stones/etc no longer function on lvl 80 weapons. Not a major issue, since players can simply not toggle it on, but felt it was worth noting. Sorry if it's been mentioned before.

edit: Having an issue here with my rotation. In the first post, you said:

"A proper hunter rotation (for MM-spec) would look something like:
#1. Rapid Fire
#2. Chimera Shot
#3. Serpent Sting
#4. Steady Shot
A proper pet rotation (for a Cat) would look something like:
#1. Rabid
#2. Rake
#3. Claw
The most common mistake made is that people put Claw or Steady Shot as #1. In which case the other shots/abilities are NOT used."

I have set my rotation as:
#1. Rapid Fire
#2. Chimera Shot
#3. Kill Shot
#4. Readiness
#5. Serpent Sting
#6. Steady Shot

In the Rotation Test tab, the spreadsheet shows 0 instances of Serpent Sting cast.

Shandara · 12/05/08, 7:09 PM

Originally Posted by Elendril

I have set my rotation as:
#1. Rapid Fire
#2. Chimera Shot
#3. Kill Shot
#4. Readiness
#5. Serpent Sting
#6. Steady Shot

In the Rotation Test tab, the spreadsheet shows 0 instances of Serpent Sting cast.

Chimera refreshes serpent sting, so beyond the first cast (which is not shown) it's never re-cast.

flimflam · 12/05/08, 7:14 PM

With the latest version the [Envoy of Mortality] is -353.16 to [Nerubian Conquerer] in the gear planner where before it used to be the top ranged weapon.

Final Voyage and Arrowsong are also -353.16

Did i mess something up?

Shandara · 12/05/08, 7:21 PM

Originally Posted by flimflam

With the latest version the [Envoy of Mortality] is -353.16 to [Nerubian Conquerer] in the gear planner where before it used to be the top ranged weapon.

Final Voyage and Arrowsong are also -353.16

Run the "Ranged Weapon' button.

In an effort to speed up this slow calculation it's only calculating the items you haven't filtered out. The rest are put to 0 DPS (also gives less trouble with the sorting). So if you then change the filters and sort without hitting the button they will end up at the bottom.

Anak · 12/05/08, 7:37 PM

I realize this is slightly out-of-date now, but when I imported from 73c to 73d, I lost about 250 DPS. I finally tracked it down to an increase in base stats and mana at 80, meaning that Steadyshot was relatively much more expensive, so I was spending more time in AotV. I didn't notice this in the change notes, and was wondering if the base stats @ 80 are correct as of 73d.

Also, I don't see the 4pc T7 bonus being calculated anywhere. I see where it should be added in the Calculations tab, since there is a spot for it along with other hasting effects. However, the value never changes from 100% no matter how many pieces of T7 I wear. Am I missing where this calculation is carried out?

Lastly, Raging Construct Bands should have +18 hit instead of +16.

Sorry if these issues have already been fixed/mentioned. I'm looking forward to updating to the new version tonight!

Thanks for your hard work.

Anak

Lufan · 12/05/08, 7:56 PM

I am having some confusion with 'Ranged Weapons' button. I used to load gear off Armory as well my talents. Today, for the first time, I ran the Ranged button. After checking the thread in more detailed, the only information I could find in regards to that are the following:

Notes:
The gear planner compares all ranged weapons with a mythical 0-0 damage/0 dps/0 stats weapon which fires at 2,8 speed. It basically tries all the weapons in the spreadsheet one by one, so it's a tad slow (takes about a minute on my Core Duo E8500)

I still don't quite understand it. After running the ranged weapon button, some of the items that I believe are clearly better is no longer the case. I am hit capped and I have set that on the top right hand side of the gear planner tab, but some items that are clearly superior from my stand point is no longer the case. Here are some examples:

[Favor of the Dragon Queen] beats [Titanium Impact Choker] by 3 Delta.
[Titanium Impact Band] beats [Ring of Invincibility] by 7.64 Delta.
[Blackened Naaru Sliver] beats [Mirror of Truth] by almost 20 Delta.
[Armguard of the Tower Archer] beats [Slime Stream Bands] by almost 17 Delta.
[Sovereign's Belt] beats [Spectral Rider's Girdle] by almost 10 Delta.

I am just confused and any assistance is greatly appreciated.

This can be easily replicated by simply loading my Armory Profile (Lufann, Eredar, US), load my talents, then run the 'Ranged Weapon' button on the gear planner tab.

zigokubasi · 12/05/08, 7:57 PM

Originally Posted by Shandara

Update:

- Gear planner now has a 25-man and a 10-man filter
- Fixed some items which were attributed to the wrong instances on the Gear Planner
- Implemented Rapid Recuperation for hunter mana costs and pet focus costs during Rapid Fire
- You can now hand adjust the pet crit%/AP and %damage modifiers on the gear page
- Added option to use the new assumed 8% hit cap on bosses on the Settings tab (default= Yes)
- Fixed Pawn string. Gems with +AP will now add dps from AP correctly
- Careful Aim is now more accurate
- Added Fel Intelligence to buffs and fixed various buffs to be more in-line with the wotLK talents (exported buff profiles will fail to load, sorry)
- Added an option to use Aspect of the Beast during Bestial Wrath, this will reduce Hawk uptime
- Added Enchanted Tear/Pearl gems
- Various fixes to missing socket bonuses

I'm impressed. You're going to burn out releasing updates this quickly, but I have to say I really appreciate the effort you're putting into this. I can speak for all ZERG's hunters when I say "thank you".

Rokh · 12/06/08, 3:40 AM

Originally Posted by Lufan

I am having some confusion with 'Ranged Weapons' button. I used to load gear off Armory as well my talents. Today, for the first time, I ran the Ranged button. After checking the thread in more detailed, the only information I could find in regards to that are the following:

I still don't quite understand it. After running the ranged weapon button, some of the items that I believe are clearly better is no longer the case. I am hit capped and I have set that on the top right hand side of the gear planner tab, but some items that are clearly superior from my stand point is no longer the case. Here are some examples:

[Favor of the Dragon Queen] beats [Titanium Impact Choker] by 3 Delta.
[Titanium Impact Band] beats [Ring of Invincibility] by 7.64 Delta.
[Blackened Naaru Sliver] beats [Mirror of Truth] by almost 20 Delta.
[Armguard of the Tower Archer] beats [Slime Stream Bands] by almost 17 Delta.
[Sovereign's Belt] beats [Spectral Rider's Girdle] by almost 10 Delta.

I am just confused and any assistance is greatly appreciated.

This can be easily replicated by simply loading my Armory Profile (Lufann, Eredar, US), load my talents, then run the 'Ranged Weapon' button on the gear planner tab.

Make sure you're recalculating stat values each time you switch gear; without that, those numbers in the gear planner will be significantly off.

Shandara · 12/06/08, 3:50 AM

Originally Posted by Anak

I realize this is slightly out-of-date now, but when I imported from 73c to 73d, I lost about 250 DPS. I finally tracked it down to an increase in base stats and mana at 80, meaning that Steadyshot was relatively much more expensive, so I was spending more time in AotV. I didn't notice this in the change notes, and was wondering if the base stats @ 80 are correct as of 73d.

Anak

@Anak:
A lot of people have PM'ed me the base stats for their race at level 80. With the use of Armory I verified and entered these values. Not all races have been done yet.

If in doubt use Night Elf as a race (and hand-adjust any +crit bonus your race has) because I paid very close attention to those stats as I levelled.

The 4-piece T7 bonus is currently only used when you select 'Viper' as your aspect. Since the effect depends on your time spent in viper and the time spent in Viper depends on your auto-shot it leads to a circular calculation when I adjust the effect currently. I have to find some other way of calculating it first.

@Lufann:
I've been trying to replicate this, but I have failed so far. Using the "level 80 raid buffs" profile, your talents and gear and for the rest no changes.

I hit the CalcAttributes button on the Overview page and then Sort the gear planner. Then I run the Ranged Weapon button. I haven't changed any other settings from the defaults. "Assumme 100% hit" is set to "Yes" on the Gear Planner.

* Favor of the Dragon Queen is better than Titanium Impact Choker.
This one is, in my opinion, not surprising. The stats on the Favor are just much better.
* Titanium Impact band loses to Ring of Invincibility.
With Rings it is a bit tricky. The sorting is based on the delta DPS from the first (top) ring slot. Your Surge-Needle Ring is best-in-slot for that at the moment, so both represent a DPS loss. Compared to your Signet of the Edward the Odd both are an upgrade, but the Ring of Invincibility is, again, the best. Looking at the stats I can't but agree.
* Blackened Naaru Sliver loses to Mirror of Truth
Compared to the Mirror, the Sliver is almost a 20 DPS loss
* Slime Stream Bands beat Armguards of the Tower by 1 DPS
Really close, which is due to you being hit-capped
* Spectral Rider's Belt beats Sovereign's Belt by 25 DPS
This is what'd you expect

So I'm not sure how you got the results you had.

Shandara · 12/06/08, 4:48 AM

Quick update:

- Accuracy enchant fixed
- Corrected pet +hit gained from hunter when using the new assumed 8% hit cap
- Raging Construct bands now have +18 hit
- Added Mammoth Meal food (+60 AP)

KergeKacsa · 12/06/08, 9:21 AM

There is a new bug:
If you select untalented Greater Blessing of Kings in Pet buffs, it does nothing, no 550 AP.