WotLK DPS spreadsheet - Page 56

• Intermission · 12/04/08, 6:37 PM

Originally Posted by Elendril

I've gotten the error about 10 times now across several days of trying :-P

I have also been getting this error repeatedly for days. Some screenies are attached.

Also, the follow slots were not filled in by the import, if this also helps you diagnose the problem:
Main Hand
Off Hand
Back
Wrist
Feet
Rings
Trinkets
Ranged Weapon

Thanks!

edit: to clarify, when I hit Debug on that popup box, I see a page with code with that text highlighted.

Cranch · 12/04/08, 7:05 PM

Bug report for 78e spreadsheet:

1. Exceptional Intellect (1H enchant) does not appear to be available in the game.

2. Incisor Fragment mean armor penetration rating of 291*20/120 not reflected in dps calculation.

3. Note that trinkets aren't handled correctly yet in Gear Planner (it only uses the static stats, not the proc/triggerable effects.)

4. "Deadly Gladiator's Wristguard of Triump" is missing the final "h".

5. DPS for equipped Rings in Gear Planner appear to be bugged. I had Ring of Foul Mojo and Jagged Ice band, and the deltas were listed as +78 and +66. The actual spreadsheet DPS gains for these two rings by equipping them versus None were +57 and +80, respectively. Are the numbers swapped, perhaps?

Lohegrin · 12/04/08, 8:24 PM

I also went and tried the 8% hit theory.
With 8.36% hit I didnt miss against a boss a single time, over 2000 shots fired.

Hauraki · 12/04/08, 11:26 PM

thanks for the work

a couple of issues still exist in 78e

1. when i swap the default red gem in "Settings" to bright scarlet ruby, the red socket value in pawn string becomes 0, click CalcAttributes does not solve this problem.

2. swift skyflare diamond when selected, does not add AP value, despite that meta requirement is met.

3. Invigorating Earthsiege Diamond (42 AP, Regen 2% HP) or Persistent Earthsiege Diamond (42 AP, 15% Reduced Stun), when selected, does add AP value to calculation, but the result seems far lower than it should be (lower dps than 12 Agi meta gem).

please have a look, thanks.

Shandara · 12/05/08, 6:49 AM

Originally Posted by Hauraki

3. Invigorating Earthsiege Diamond (42 AP, Regen 2% HP) or Persistent Earthsiege Diamond (42 AP, 15% Reduced Stun), when selected, does add AP value to calculation, but the result seems far lower than it should be (lower dps than 12 Agi meta gem).

please have a look, thanks.

The Invigorating Diamond doesn't have the +3% critical damage bonus the Relentless Earthstorm Diamond has. That is the big difference.

Krikkit · 12/05/08, 7:35 AM

Hunter T7 and T7.1 pet damage bonus isn't added to the pet damage increments.

Orc, 5%
Beast Tamers Shouders 3%

T7 + 7.1 2piece = 2%

Thank you.

Shandara · 12/05/08, 8:16 AM

Originally Posted by Krikkit

Hunter T7 and T7.1 pet damage bonus isn't added to the pet damage increments.

Orc, 5%
Beast Tamers Shouders 3%

T7 + 7.1 2piece = 2%

Thank you.

It is done on the Pet Calculations tab. And isn't it +5% damage for 2-piece?

zigokubasi · 12/05/08, 8:43 AM

I appreciate you taking over where Cheeky left off. However, the current version of your spreadsheet still seems to be missing the gem "enchanted tear" and the titanium weapon chain enchant is not properly reflecting the +28 hit rating that it grants.

Ufthak · 12/05/08, 8:55 AM

Originally Posted by Hauraki

snip

1. when i swap the default red gem in "Settings" to bright scarlet ruby, the red socket value in pawn string becomes 0, click CalcAttributes does not solve this problem.

snip

I also noticed this, it appears to be due to the PAWN string for GEMS looking for the RAP field for the gem rather than the AP field. I suspect that the AP contribution of any gem is not being picked up for the PAWN string generator.

Dralmoo · 12/05/08, 1:10 PM

So the latest findings in the hit thread seem to be the following:

- Hit cap is 8% for Pet and Hunter
- Focused Aim does NOT transfer hit to the pet
- Pet hit from gear is based on the FLOOR of the Hunter's hit % from gear - if you have 7.95% hit from gear, the pet will have 7% hit.

While bizzare, all these behaviors seem modelable. In particular I am curious as to the value of +hit vs other stats in the case where you have 3/3 FA, so your pet is benifiting from additional +hit on gear, but you are not.

Thelastdeadmouse · 12/05/08, 1:35 PM

Originally Posted by Dralmoo

So the latest findings in the hit thread seem to be the following:

- Hit cap is 8% for Pet and Hunter
- Focused Aim does NOT transfer hit to the pet
- Pet hit from gear is based on the FLOOR of the Hunter's hit % from gear - if you have 7.95% hit from gear, the pet will have 7% hit.

While bizzare, all these behaviors seem modelable. In particular I am curious as to the value of +hit vs other stats in the case where you have 3/3 FA, so your pet is benifiting from additional +hit on gear, but you are not.

Keep in mind however that since a pet only benefits from a full point of hit, there won't be any shown improvement in DPS until you accumulate an extra full point of hit, at which point you could take a point out of FA and place it elsewhere to increase your DPS.

Whitemane · 12/05/08, 3:43 PM

I just downloaded this and looked through the gear planner and when comparing this with Rawr and what I read earlier that the Rawr hunter model is fairly messed up atm, but how much? I'm getting very different values with the spreadsheet. All I really want to know is, what to use?

Namarus · 12/05/08, 4:00 PM

Originally Posted by Shandara

It is done on the Pet Calculations tab. And isn't it +5% damage for 2-piece?

Your correct it is 5%.

Enchant Cloak - Greater Speed is missing from the back enchant list, 23 haste. Furthermore I can't find the enchant enchant cloak - haste that you have listed in there.

Uli · 12/05/08, 4:11 PM

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.

Fendryl · 12/05/08, 4:35 PM

Originally Posted by Intermission

I have also been getting this error repeatedly for days. Some screenies are attached.

I was having this error for a while, I believe it was due to the Armory not having [Pack-Ice Striders] set up correctly; for quite a while my armory page refused to show them. Checking just now the armory seems to support them correctly now & the spreadsheet imports everything correctly.