WotLK DPS spreadsheet - Page 52

Shandara · 12/01/08, 6:16 PM

Originally Posted by Samba

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?

It's too hard to judge a weapon's DPS just by the speed/damage range so the button tries each of the weapons one by one, records the DPS and shows the delta from a mythical 0 DPS ranged weapon (0-0 damage range 2.8 speed). That is what is shown.

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

Originally Posted by Samba

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

Yea of course. This would just be for people with 50/21/0 BM specs (even not having readiness can change the relative value of stats).

Esoth · 12/01/08, 9:38 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.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.

Our specs our fairly similar but I'm not getting anything close to this. I loaded your character into the sheet and didn't get anything even close to this. With a five minute fight they were weighted in the order: Hit (you're capped though) > ap > int (decreases by a lot with shorter fights) > agi > pen > crit > haste > mp5.

What duration did you set it at? What is your pet? What buffs?

thehittmann1981 · 12/01/08, 10:36 PM

Needed to cap Hit:

I believe there is an error on the Overview page where you calculate attributes.
My hit is currently 99.95% on level 83 Boss mobs. (1 point off cap)

But this box is showing that i am 97 points over cap.

And just a minor thing... Could "Mega Mammoth Meal" be added to food buffs. (80 AP 40 STAM)

dlanod · 12/01/08, 11:35 PM

Originally Posted by thehittmann1981

Needed to cap Hit:

I believe there is an error on the Overview page where you calculate attributes.
My hit is currently 99.95% on level 83 Boss mobs. (1 point off cap)

But this box is showing that i am 97 points over cap.

And just a minor thing... Could "Mega Mammoth Meal" be added to food buffs. (80 AP 40 STAM)

I've observed the same thing. My hit is 99.09% but my "To Hit Cap" cell reckons I need -69.

I'd also add a comment that it would be nice if a change of pet family results in an automatically updated Pet Rotation.

Apart from those minor nitpicks, I love the continued spreadsheet, especially the gear planner which compares well with Rawr in terms of ease of use.

Vec · 12/02/08, 1:28 AM

Originally Posted by Esoth

Our specs our fairly similar but I'm not getting anything close to this. I loaded your character into the sheet and didn't get anything even close to this. With a five minute fight they were weighted in the order: Hit (you're capped though) > ap > int (decreases by a lot with shorter fights) > agi > pen > crit > haste > mp5.

What duration did you set it at? What is your pet? What buffs?

Default 5 minute fight with default lv80 raid buffs and a cat. And actually that order you found is exactly what my findings were if you looked at it.

sihyunie · 12/02/08, 1:59 AM

I have a small question.
Is there any way to ignore hit cap? The way I like to cap hit is I ignore hit on all items, choose the best items for each slot, then exchange whatever item has the most hit gained per "pseudo-dps" lost until I'm capped.
One solution I thought of was make target level lower and figure the gear out and then change it to boss level.
If anyone has a more elegant solution, please let me know.

EDIT: I didn't notice new version. I would still like to know how other people are capping hit.

wl04 · 12/02/08, 4:02 AM

I've noticed a bug with ranged weapon delta calculation. My Thori'dal, the Stars' Fury is shown as 2nd best in game item after Envoy of Mortality. Blizzard changed the mechanics a bit and arrows/bullets damage adds to weapon damage. I also know that you assume this in spreadshit calculations. Here is how i see the problem. On gear tab when legendary bow is selected ammo is set to none. And if you press "Ranged weapons" button it would still use no ammo in calculations. I think that its true because if i manually set gun listed before and Mammoth Cutters then spreadshit shows about 150 dps increase. The way to solve the problem is to assume best availible ammo in "Ranged weapons" calculations. Also i think you dont take Dwarf racial +1% crit in consideration.

Ryannktsu · 12/02/08, 4:12 AM

Originally Posted by Shandara

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

Oh, well then, that would most definitely do it. >< No idea why the armory is having issues with the Pack Ice Striders, but hey. Don't I feel silly now for not checking that. Ugh, thank you.

Shandara · 12/02/08, 4:32 AM

Originally Posted by wl04

I've noticed a bug with ranged weapon delta calculation. My Thori'dal, the Stars' Fury is shown as 2nd best in game item after Envoy of Mortality. Blizzard changed the mechanics a bit and arrows/bullets damage adds to weapon damage. I also know that you assume this in spreadshit calculations. Here is how i see the problem. On gear tab when legendary bow is selected ammo is set to none. And if you press "Ranged weapons" button it would still use no ammo in calculations. I think that its true because if i manually set gun listed before and Mammoth Cutters then spreadshit shows about 150 dps increase. The way to solve the problem is to assume best availible ammo in "Ranged weapons" calculations. Also i think you dont take Dwarf racial +1% crit in consideration.

This is a bug yes. It can be circumvented by setting another weapon then Thor'idal on your gear tab before running the 'Ranged Weapons' button on the Gear Planner. I should have it fixed for next release.

The Dwarf racial should be working, it should show up on the Race line on the Gear tab when you have a gun selected as your weapon.

Sylvand · 12/02/08, 7:31 AM

[Depraved Linked Belt] - misspelled, currently Depraved Link Belt

Needed to cap Hit: seems to be double counting focused aim.

Feature request: better accounting for hit in the gear planner (or perhaps a 3rd +hit mode). this has probably been suggested before, but this is something that shouldn't be too hard to implement (I did it a little with Cheeky's unlocked spreadsheet). Consider the following situation:

With talents and buffs I need 5% hit or 164 hit rating. With no cape I'm at 150 hit rating, and I'm currently wearing [Cloak of the Gushing Wound] (so I'm somewhat above hit cap). When considering upgrades for the cloak, I would consider this to have 14 effective hit rating. To calculate the value of this effective hit rating, compare 163 hit rating vs. 164 hit rating (or maybe 162 and 163), and multiply by 14. Now, when considering replacements, find their effective hit rating which is min(itemhitrating,14).

What's probably more common, is that people are very close to hit rating. In this case, they'd want replacements for items that grant +hit to have equivalent/appropriate weighting for other items with +hit. Meanwhile items that don't grant hit wouldn't weight unreasonably toward items with a lot of +hit. It's sort of a mix between assuming 100% and not, but it should be more accurate for single slot upgrade scenarios across the board.

wl04 · 12/02/08, 7:31 AM

Originally Posted by Shandara

This is a bug yes. It can be circumvented by setting another weapon then Thor'idal on your gear tab before running the 'Ranged Weapons' button on the Gear Planner. I should have it fixed for next release.

The Dwarf racial should be working, it should show up on the Race line on the Gear tab when you have a gun selected as your weapon.

Yes this is my mistake havent noticed it in racial string.

Aim · 12/02/08, 7:39 AM

Hi Shandara,

Grats for this work !

I've corrected a few typo's :

Mispelled ranged enchant (ranged sheet):

Was :
Sun Scope	| Scope (+40 Haste Rating)

Must be :
Sun Scope	| Scope (+40 Ranged Haste Rating)

Mispelled belt (waist sheet):

Was :
Depraved Link Belt			

Must be :
Depraved Linked Belt

Just a little question :
How do we manage to save different profiles ?

How can i choose which one to load ?
I mean, i can only save my profile over yours, is it possible to make two profiles ? like the current one and my dream gear one ?

Thansk in advance

SpartanKillian · 12/02/08, 9:48 AM

Save the dummy profiles as one of the preset profiles (i.e. Open the Gear tab with Shandara's profile and scroll down the various "None" settings and click save). You should be able to then edit the profiles normally--you can't start a None profile as a blank slate. At least I haven't been able to.

Ghumganuk · 12/02/08, 11:08 AM

This was confusing me as well until I asked Shandara and was promptly answered (Thanks!).

You can click in any cell on the Overview tab in the Profiles table and name it whatever you want...

Then the actual selection/changing/edit of the profile happens in the Gear tab. In the titles of the columns the one listed by default as Shandara is a dropdown selector if you click on it. Any new profile names you have added, will now appear there and you can choose them.