WotLK DPS spreadsheet - Page 53

Shandara · 12/02/08, 12: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, 12: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, 1: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, 1: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, 1: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, 1: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, 2: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, 2: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, 2: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, 2:34 PM

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

Rexzoolza · 12/02/08, 2: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, 2: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, 3:11 PM

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

dragoonvengance · 12/02/08, 3: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, 4: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?