WotLK DPS spreadsheet - Page 51

turbo_012 · 12/01/08, 4:34 AM

Originally Posted by Shandara

And you use a Cat right? Cats use Claw and Rake, so unless you have your pet set to a Devilsaur this will indeed put Claw Dps and Family Skill DPS at 0.

As for the stats, I don't have the correct level 80 stats for most races yet (Orcs for instance), so it will be off a little bit.

Yea I use a Cat. When i change it to Cat it seems weird, it only shows as follows
Base DPS 321.95 100.00%
Claw Dps 0.00 0.00%
Family Skill DPS 0.00 0.00%
KC DPS 0.00 0.00%
Total Pet DPS 321.95 100%

Looks like we still gotta wait for more data, I'll just play around with talents and gear. But since the actual stats maybe off I guess I shouldn't use the pawn data.

Shandara · 12/01/08, 4:52 AM

Originally Posted by turbo_012

Yea I use a Cat. When i change it to Cat it seems weird, it only shows as follows
Base DPS 321.95 100.00%
Claw Dps 0.00 0.00%
Family Skill DPS 0.00 0.00%
KC DPS 0.00 0.00%
Total Pet DPS 321.95 100%

Looks like we still gotta wait for more data, I'll just play around with talents and gear. But since the actual stats maybe off I guess I shouldn't use the pawn data.

If you change it to a Cat, you should change the skills used in the Pet Rotation as well. Could you possibly upload your sheet somewhere for me to look at? I'd like to solve this problem since it seems to have happened to a few people already.

turbo_012 · 12/01/08, 5:23 AM

Originally Posted by Shandara

If you change it to a Cat, you should change the skills used in the Pet Rotation as well. Could you possibly upload your sheet somewhere for me to look at? I'd like to solve this problem since it seems to have happened to a few people already.

I think I understand what you're talking about. The problem is I guess people don't bother to change the pet skill rotation after they pick their pet.

Anyways here is the link for the spreadsheet I was working on, like we mentioned the stats are way off from the actual character's stats. Right now according to the pet's skill rotation, the rake skill is not being used at all. Also is there a way to find out how wow does the skill rotation if all the skills were on auto-run?

Download Hunter DPS 78b xls free at Uploading.com

mako · 12/01/08, 10:47 AM

I just wanted to point out a (minor) error with the spreadsheet. It appears that Valorous Cryptstalker Handguards
are set to leather, when they are clearly a mail piece. The gear planner page will remove them from the list when leather items are not set to display.

Ryannktsu · 12/01/08, 11:56 AM

I seem to have tripped over a semi-major error in the spreadsheet since the last build (78a). I go to load my character into the spreadsheet from the Armory via the handy 'load gear from armory' button in the gear tab, and I end up getting a Run-time error '91'. In the debug, it highlights and points me to this line : "sName = Node.Attributes.getNamedItem("name").Text"

Any idea what might be causing it, and if there's a way I could fix it? >_>;

Thanks for all the work you're putting into this, as well, Shandara

Shandara · 12/01/08, 12:00 PM

Originally Posted by Ryannktsu

I seem to have tripped over a semi-major error in the spreadsheet since the last build (78a). I go to load my character into the spreadsheet from the Armory via the handy 'load gear from armory' button in the gear tab, and I end up getting a Run-time error '91'. In the debug, it highlights and points me to this line : "sName = Node.Attributes.getNamedItem("name").Text"

Any idea what might be causing it, and if there's a way I could fix it? >_>;

Thanks for all the work you're putting into this, as well, Shandara

Looking at your Armory, the Armory itself gives a tooltip error loading your boots (non-indexed gear?). That's the reason it fails.

Iroared · 12/01/08, 12:22 PM

First, I am somewhat confused by how to save profiles in the spreadsheet. Like, I set up items talents rotations etc, but how do I save it so that it appears on a separate line in overview tab?

Moreover, when I closed the spreadsheet and re-opened it, in gear planner most of the items I picked (I picked top dps items or something close) were considered to lose to a lot of other items by more than 1000 DPS. Of course it is possible for the order to change but 1000 DPS is just unrealistic.

Namarus · 12/01/08, 4:24 PM

Elixir of Mighty Thoughts is listed as a battle elixir, when it is a guardian.

Samba · 12/01/08, 4:40 PM

A few minor things at the moment (ill come back with a more complete list later):

Necklace of the Chrono-Lord not Necklace of the Chrono Lord - It shows up as unsupported with your spelling.
Also Titanium Weapon Chains I feel should be added. Yes they are primarily melee weapon enchants but with 28 hit rating per chain you cannot ignore them as viable.
Dragonscale Ammo Pouch doesnt show up as a selection, minor since the haste rating is the same for this item as it is for the Netherscale pouch.

More to come!

*edit* Woops! looks like the chains were added over night! Ignore that part and thank you!

Rune of Finite Variation shows up as unsupported as well.

*edit2* Cheeky's old spreadsheet had an option in the gear planner to assume 100% hit. Is it possible to impliment this again? Your spreadsheet doesnt seem to be accounting for the Focused Aim talents and therefore ranking gear with hit higher than gear without if you dont have 100% hit from gear. Minor detail that I assume could be fixed pretty easy.

Shandara · 12/01/08, 5:06 PM

I can only apologize for all the spelling errors, heh. It was a long haul somewhere halfway in beta where I added nearly a 1000 items (the gems were the worst part). It was a very long day then.

Most of the missing stuff is things that were added since then (like not all crafting professions having their full craft list known at that time).

As for Focused Aim, you are correct I am not accounting for that, but it should be easy to fix.

Thelastdeadmouse · 12/01/08, 5:23 PM

Tauren 80 base stats:

Strength: 79
Agility: 176
Stamina: 130
Intellect: 85
Spirit: 99
Armor: 352
Health: 8810
Mana: 6041
RAP: 326

Shandara · 12/01/08, 5:34 PM

Small update:

- Level 83 Boss now has 13083 armor as per testing
- Invigorating Earthsiege Diamond now has +42 AP
- Necklace of the Chrono-Lord spelling fixed
- Hit Rating to Cap now accounts for Focused Aim (and thus corrects the Gear Planner)
- Added an option to the Gear Planner to assume 100% hit fixed
- Rune of Finite Variation spelling fixed

I'm going by this on Boss armor.

Samba · 12/01/08, 6:07 PM

Originally Posted by Shandara

I can only apologize for all the spelling errors, heh. It was a long haul somewhere halfway in beta where I added nearly a 1000 items (the gems were the worst part). It was a very long day then.

Most of the missing stuff is things that were added since then (like not all crafting professions having their full craft list known at that time).

As for Focused Aim, you are correct I am not accounting for that, but it should be easy to fix.

No need for apologies, completely understandable and thanks for the update!

*edit*

BTW i also noticed the thing with pet dps as stated by a poster above. I found that once you switch the pet you must change the rotation so that it matches your pets rotationa nd skills. When you do this all is corrected and numbers appear as they should.

One question I have is how the ranged weapon ranking works. When i do an initial gear and talent load from the armory I show my N4K as being 2nd highest dps after sorting the gear planner, which obviously is not correct, If i click the Ranged Weapon button on the page they seem to rearrange themselves into the correct order. can you explain what its doing exactly?

Vec · 12/01/08, 6:09 PM

I would like to compare the weighting of some of the stats that I'm seeing from the spreadsheet with other people if possible. With my gear (pre raid), 50/21/0 spec, and lv80 buffs, I'm getting the following weights:

1 AP = 1
1 Agility = 1.75
1 Crit Rating = 1.08
1 Hit Rating = 2.84
1 Int = depends too much on fight length
1 Armor Pen Rating = 1.2
1 Haste Rating = 0.78

I thought it was interesting to see the value of crit rating so low.

Samba · 12/01/08, 6:13 PM

Originally Posted by Vec

I would like to compare the weighting of some of the stats that I'm seeing from the spreadsheet with other people if possible. With my gear (pre raid), 50/21/0 spec, and lv80 buffs, I'm getting the following weights:

1 AP = 1
1 Agility = 1.76
1 Crit Rating = 1.09
1 Hit Rating = 2.86
1 Int = depends too much on fight length
1 Armor Pen Rating = 0.97
1 Haste Rating = 0.77

I thought it was interesting to see the value of crit rating so low.

I would assume that those weights would vary from one spec to another... is this correct?