WotLK DPS spreadsheet - Page 32

Sylvand · 12/02/08, 8: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, 8: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, 8: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, 10: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, 12:08 PM

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.

Shandara · 12/02/08, 1:03 PM

Originally Posted by Sylvand

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).

This is how the current Gear Planner works, it only considers what hit could actually be used when you replace an item. If you are very close to the hit cap any item with a lot of +hit will have 'wasted' a lot of this +hit and so be less of an upgrade.

Dch48 · 12/02/08, 1:12 PM

Hit rating is bugged now in 78d . It seemed to be fine for me in the previous version , even accounting for focused aim. The previous version said I needed 15 hit to be capped which worked out in the sheet. The new version says I need -50 to the cap (showing me over the cap) even though it still shows my hit % against a boss as the same 99.53%. I don't think any change needed to be made. 78d also shows me with more dps than the previous one. Also, the level 80 dummy target is missing.

I have 2 points in focused aim and the sheet is calculating it for 3. Like I said , it worked fine before and carried over to the main page perfectly, now it's off. It also has thrown the gear planner out of whack which was working right before. I'm sticking with 78c.

I see what it's doing now. It's giving 66 hit rating for every point in focused aim instead of the 33 it gave before.

Hit to cap always did take focused aim into account, now it seems to be doing it twice.

Namarus · 12/02/08, 2:13 PM

Could you unprotect <settings> -> Gem Options, so that it is possible to change the default gemming. I find that I am well over hit cap on my calculations, and having to manually change the gems from vivid to balanced everytime I look at a different piece of gear is annoying.

I also note that I do not seem to be getting any value from my [Meteorite Whetstone]. The crit seems to be taken into account, but not the haste proc.

Shandara · 12/02/08, 2:25 PM

Originally Posted by Namarus

Could you unprotect <settings> -> Gem Options, so that it is possible to change the default gemming. I find that I am well over hit cap on my calculations, and having to manually change the gems from vivid to balanced everytime I look at a different piece of gear is annoying.

I also note that I do not seem to be getting any value from my [Meteorite Whetstone]. The crit seems to be taken into account, but not the haste proc.

Use the yellow fields next to them, which are labeled 'custom values'.

Updated:

- Fixed HitRatingToCap
- Depraved Linked Belt spelling corrected
- Sun Scope fixed
- Added every quest/reputation reward to the "non-Raid" filter on the Gear Planner together with all 5-man content gear.

Sylvand · 12/02/08, 2:28 PM

Originally Posted by Shandara

This is how the current Gear Planner works, it only considers what hit could actually be used when you replace an item. If you are very close to the hit cap any item with a lot of +hit will have 'wasted' a lot of this +hit and so be less of an upgrade.

Cool, sorry for the noise. It seems likely that what I'm seeing is just a manifestation of the focused aim bug then (i.e. this exact cloak seems to be devalued because of its hit rating while I'm actually slightly under cap).

Rexzoolza · 12/02/08, 2:37 PM

Originally Posted by Ghumganuk

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.

Just in case people (like me) have a hard time figuring out where to load profiles.

After you put a name in the in the Profiles Table in the Overview tab you can then load that profile in the gear tab. The drop down box is in Column B, Row 7 and here is a picture.

Hope that helps people find where to save.

I also wanted to inquire, I know for some this Spreadsheet is intuitive, but is there a FAQ in the works? Maybe there is and I just have not found it yet.

Kargos · 12/02/08, 3:22 PM

Originally Posted by Rexzoolza

I also wanted to inquire, I know for some this Spreadsheet is intuitive, but is there a FAQ in the works? Maybe there is and I just have not found it yet.

I believe Drotara over at Less QQ More PewPew will be updating the old Cheeky's guide for Shandara's.

Æthien · 12/02/08, 3:28 PM

Originally Posted by Rexzoolza

Hope that helps people find where to save.

I also wanted to inquire, I know for some this Spreadsheet is intuitive, but is there a FAQ in the works? Maybe there is and I just have not found it yet.

This screenshot is... scary.
How did my name end up in there?

Shandara · 12/02/08, 3:32 PM

Originally Posted by Æthien

This screenshot is... scary.
How did my name end up in there?

Oops, I was just randomly loading some profiles for testing and must've forgotten to clear out those names.

Æthien · 12/02/08, 3:34 PM

Can;t say I'm all that bothered by it... it just freaked me out a bit.

Rexzoolza · 12/02/08, 3:37 PM

It may have been mentioned but I found this issue today, and I don't know how to debug the Code so I'll leave it to the gurus.

I get run time errors if I do the following:

1. Create Profile in Overview Tab
2. Change Character, Realm and Server settings in the Overview tab.
3. Go to Gear Tab, select the new profile.
4. Click, "Load from Armory"
5. Run Time Errors.

However...no errors if:

1. Create Profile in Overview tab.
2. Change Character, Realm and Server settings in the Overview tab.
3. Leave Shandara as the selected Profile in the Gear Tab.
4. Click "Load from Armory"
5. Gear loads (some problems with items not found or supported)
6. Change Profile from Shandara to new profile created in Step one by accessing the drop down box in Column B, Row 7.
7. Save Profile.

Forgive me if I'm double posting. Do you need a SS of the debug tool?

Rexzoolza · 12/02/08, 3:38 PM

Originally Posted by Æthien

Can;t say I'm all that bothered by it... it just freaked me out a bit.

I'm sorry, I just put up what was in the Profiles section. I will scrub em out...

Fixed

dragoonvengance · 12/02/08, 4:11 PM

Valorous Cryptstalker Legguards
The socket bonus is showing up as nothing when it should be 12ap

dragoonvengance · 12/02/08, 4:51 PM

for Careful Aim your forumla is
.33 * Talents * Int

When you do that you are losing fiqures. In my case I'm losing 4ap. Yes I know it's only 4ap.. but ap is ap it adds up.

Why not talents/3 *int of course you have to make sure talents is not 0.

Unless blizz does it via .33*talents you will lose ap.

if you don't want to go the if statment route always do the wonderful (1.0 / 3.0) * talents * int

Thelastdeadmouse · 12/02/08, 5:11 PM

When trying to change the name of a saved spec on the Talents tab, it gives a pop up error.

The value you have entered is not valid.

A user has restricted values that can be entered into this cell.

Working as intended, bug, or user error?

Shandara · 12/02/08, 5:12 PM

Originally Posted by Thelastdeadmouse

When trying to change the name of a saved spec on the Talents tab, it gives a pop up error.

Working as intended, bug, or user error?

Use the list on the Overview tab, you can change those values.

Chul · 12/02/08, 6:57 PM

A few comments:

On the gear planner, if you just have WotLK selected, you get two 5-man necks showing up
I would like to request the ability to turn off 25-man (or heroic) loot for those who are just doing the 10-man route
Trinket Grim Toll only drops in 25-man Naxx not 10-man Naxx
There are some items, like Loatheb's Shadow, that drop in both 10man and 25man instances. Your spreadsheet doesn't handle that at the moment. Perhaps just have the location as 'Naxxramas' so it's clear it'll drop from either.

Nyutu · 12/02/08, 7:36 PM

Perhaps i am being bling. But is there any way rapid recuperation is taken into account?

Because I dont see any dps increase on it, neither less time in viper.

Sorry if this is obvious

sihyunie · 12/02/08, 8:31 PM

Am I blind??
I can't seem to find how to fix hit at 100%.

ishootthings · 12/02/08, 8:44 PM

Originally Posted by sihyunie

Am I blind??
I can't seem to find how to fix hit at 100%.

gear planner page

top right hand corner