WotLK DPS spreadsheet - Page 23

Shandara · 11/11/08, 12:49 PM

Originally Posted by samfisher

Hmm I believe there is an error in the spreadsheet's Hit calculation? I'm over hit cap on a lvl 73 but it still says I only have 97.73% to hit on the gear tab, and on the calculations tab, under Hit Chance it says Tooltip Value 6.73%. Didn't use to be like this with v77 =(

Is this a bug or is it something else I'm doing wrong?

I had left a hand-adjusted -50 hit rating on the gear tab which I didn't clear out before uploading it. It's most likely that.

Whitefyst · 11/11/08, 2:01 PM

Since WoTLK is starting this week, I have finally started to care about what my level 80 needs will be. While looking things over for a level 80 character, I was a little shocked by the hit rating requirement. It does not seem to match up from what I expected.

The spreadsheet seems to indicate that I will need 410 hit rating to hit a level 83 target.

With assuming 9% hit required and 37 hit rating per percent, I come out with 333 hit rating required for a hunter without Focused Aim and 222 hit rating for a hunter with Focused Aim.

In addition, I would expect with no hit rating to have a 91% chance to hit without Focused Aim and 94% with it, but the spreadsheet provides 74% meaning that 410/26 = 15.77 hit rating per 1% hit coefficient that is active today.

This seems like an error to me. If it is not, can you please educate me on any misunderstanding or incorrect spreadsheet settings I may have.

Keep up the great work! Really appreciate having this resource.

Shandara · 11/11/08, 2:08 PM

Originally Posted by Whitefyst

Since WoTLK is starting this week, I have finally started to care about what my level 80 needs will be. While looking things over for a level 80 character, I was a little shocked by the hit rating requirement. It does not seem to match up from what I expected.

The spreadsheet seems to indicate that I will need 410 hit rating to hit a level 83 target.

With assuming 9% hit required and 37 hit rating per percent, I come out with 333 hit rating required for a hunter without Focused Aim and 222 hit rating for a hunter with Focused Aim.

In addition, I would expect with no hit rating to have a 91% chance to hit without Focused Aim and 94% with it, but the spreadsheet provides 74% meaning that 410/26 = 15.77 hit rating per 1% hit coefficient that is active today.

This seems like an error to me. If it is not, can you please educate me on any misunderstanding or incorrect spreadsheet settings I may have.

Keep up the great work! Really appreciate having this resource.

I'm not sure what you are doing. When I load the "Shandara as BM - Raid Buffed" level 80 profile, she's at exactly 296 hit rating vs a level 83 and ends up at 100,03% to hit.

If you can, upload the sheet somewhere so I can look at it. This is a first that someone has managed to make the sheet bug out on the hit rating.

Whitefyst · 11/11/08, 2:25 PM

Originally Posted by Shandara

I'm not sure what you are doing. When I load the "Shandara as BM - Raid Buffed" level 80 profile, she's at exactly 296 hit rating vs a level 83 and ends up at 100,03% to hit.

If you can, upload the sheet somewhere so I can look at it. This is a first that someone has managed to make the sheet bug out on the hit rating.

I found the problem. I figured that you must have a setting someplace to switch between level 70 and level 80 formulas. I neither saw anything for this on the Settings tab nor did entering 80 talent points cause the switch. Then it dawned on me, you now have the level setting on B10 of the Overview tab. I updated that to level 80, and everything worked out much better. So is the new hit rating coefficient around 32.83 then?

mersenne · 11/11/08, 4:24 PM

Originally Posted by Whitefyst

I found the problem. I figured that you must have a setting someplace to switch between level 70 and level 80 formulas. I neither saw anything for this on the Settings tab nor did entering 80 talent points cause the switch. Then it dawned on me, you now have the level setting on B10 of the Overview tab. I updated that to level 80, and everything worked out much better. So is the new hit rating coefficient around 32.83 then?

32.79 per +1% hit chance. Whitetooth derived the new rating conversions already:
Combat Ratings at level 80

Cranch · 11/11/08, 6:18 PM

Agreed, Shandara, we don't need a large number of items displayed.

On the gear planner, I just have the LK 5 man and crafted selectors enabled, and there aren't even 10 items available in each slot (the SS fills in with unselected items.) The reason I suggested what I did is with these selectors enabled my gear doesn't show up on the list, so I can't tell if items on the list are actually an upgrade or not. My gear should either be sorted into the list always, or just displayed as a separate line -- either will work for me.

presidentofmalf · 11/11/08, 7:32 PM

Is it possible to get a spreadsheet that works without Excel? I have MS Works, and (obviously) it doesn't work. I don't want to have to buy a new program just to check it out. Maybe there's an online spreadsheet?

Cranch · 11/11/08, 8:11 PM

Originally Posted by presidentofmalf

Is it possible to get a spreadsheet that works without Excel? I have MS Works, and (obviously) it doesn't work. I don't want to have to buy a new program just to check it out. Maybe there's an online spreadsheet?

If you're still a student, the Student and Teacher Edition of Office 2003 is inexpensive (~$120) and has Excel. Get the 2003 version as you can just reinstall it as you upgrade your hardware.

Chasim · 11/11/08, 8:46 PM

EDIT: Below is my post... the problem was the Settings tab had a level 70 MoB versus a 73 Boss.

Using v.77a, I have 142 hit at level 70 but on the Overview tab after I hit Calc Attributes it shows I need -63 hit to cap? Is this a bug or am I missing a setting I need to change?

Thanks.

presidentofmalf · 11/11/08, 9:08 PM

Originally Posted by Cranch

If you're still a student, the Student and Teacher Edition of Office 2003 is inexpensive (~$120) and has Excel. Get the 2003 version as you can just reinstall it as you upgrade your hardware.

Thanks Cranch, but I was really trying to avoid paying $100 to look at my DPS

Your tip was appreciated though!

Kargos · 11/11/08, 10:59 PM

Originally Posted by presidentofmalf

Thanks Cranch, but I was really trying to avoid paying $100 to look at my DPS

Your tip was appreciated though!

What you can do is go to Microsoft's website and download a free 60 trial of office 2007 (professional, student/home,or excel) and use that for awhile ^_^.

samfisher · 11/12/08, 12:49 AM

Originally Posted by Shandara

I had left a hand-adjusted -50 hit rating on the gear tab which I didn't clear out before uploading it. It's most likely that.

I'm not sure what you mean, is there something I should adjust in my spreadsheet? I can't seem to find the value you hand-adjusted though on the gear tab =(

Glodd · 11/12/08, 1:44 AM

Is there any chance of seeing a fully functional version of this sheet that is compatible with Open Office before we really get into the swing of 25-man raiding at level 80?

Shandara · 11/12/08, 3:45 AM

Originally Posted by Cranch

Agreed, Shandara, we don't need a large number of items displayed.

On the gear planner, I just have the LK 5 man and crafted selectors enabled, and there aren't even 10 items available in each slot (the SS fills in with unselected items.) The reason I suggested what I did is with these selectors enabled my gear doesn't show up on the list, so I can't tell if items on the list are actually an upgrade or not. My gear should either be sorted into the list always, or just displayed as a separate line -- either will work for me.

What I will do is the following:
- Add a line showing your current equipped item.
- Modify the DPS displayed to show the delta instead of the absolute value.

Kargos · 11/12/08, 8:37 AM

Originally Posted by samfisher

I'm not sure what you mean, is there something I should adjust in my spreadsheet? I can't seem to find the value you hand-adjusted though on the gear tab =(

On the Gear tab there is a row of blue highlighted, specifically row 96, that allows for hand adjustments to stats.

Edit: Column 'L' is the hit column, hope this all helps. You should see it as a -50 in the blue in the midst of zeros.

Whitefyst · 11/12/08, 11:40 AM

Haste is now the socket bonus for some gear (Hollowed Mandible Legplates from heroic Azjol-Nerub as an example). As a low priority, could you please add it as an option on the Custom Gear tab.

Nakari · 11/12/08, 11:53 AM

I found some minor errors with gear / enchants:

- [Blade-Scarred Tunic] has 286 AP in the spreadsheet, but only has 148 in the game. It was bugged for a while in beta and had two +AP stats (which still show up in wowhead).
- the shoulder enchant [Fortitude of the Scourge] is misspelled (Fortitude of the Scourage), and probably shouldn't be there in the first place since it's a tanking enchant and no longer obtainable
- the Inscription specific superior shoulder enchant Master's Inscription of the Axe is missing

Also, the ability to add sockets to the hand, bracer (Blacksmithing only) and waist slot (through [Eternal Belt Buckle]) doesn't seem to be implemented.

◊ Sarutobi · 11/12/08, 3:43 PM

There appears to be a bug with [Glyph of Serpent Sting].

Maybe I missed something, but I can't see any reason as to why increasing the duration of a buff that's automatically refreshed by Chimaera Shot in a MM build would cause a 55 DPS increase.
(Unless the hunter in question wasn't hit capped, which is not the case.)

vvv EDIT: That would explain it.

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

Originally Posted by Sarutobi

There appears to be a bug with [Glyph of Serpent Sting].

Maybe I missed something, but I can't see any reason as to why increasing the duration of a buff that's automatically refreshed by Chimaera Shot in a MM build would cause a 55 DPS increase.
(Unless the hunter in question wasn't hit capped, which is not the case.)

Chimaera Shot does damage based on the total amount of damage that serpent sting would do for it's full duration. Increasing it's duration increases this total amount of damage, and thus increases the damage done by each Chimaera Shot.

Mathorli · 11/12/08, 10:51 PM

Is an Open Office version a possibility?

Shandara · 11/13/08, 3:56 AM

Originally Posted by Mathorli

Is an Open Office version a possibility?

Yes. But I don't have the time or inclination to do it myself. A few people have offered to make one once the sheet is nearly finalized, but they have not kept in touch so I don't know whether they still want to.

Update:

- Elixirs and weapon enchants/hunter food properly stack again
- CS-Serpent now uses the actual Serpent Sting value (with or without frontloaded AP) to determine its damage
- Fixed Blade-scarred Tunic +Ap bonus and removed Fortitude of the Scourge shoulder enchant/Added Master Inscription of the Axe
- Reworked the Gear Planner. It now shows the delta DPS for compared items and even multi-slots (Rings/Trinkets/1-handed weapons) now properly compare both items (sorting is still based on the top ring/trinket and MH weapon). It also only shows the instances you selected instead of filling the remainder with non-selected items if there were less than 10.

With these fixes I think the MM calculations should be near perfect (unless I reintroduced a bug somewhere). That leaves Explosive Shot in SV to be tested but with WotLK now hitting I doubt I'll test that out before I hit 80. I've tried to make some improvements to readability (removing gridlines, fiddling with colors) but I remain open to any sensible suggestions on the UI.

drpachinko · 11/14/08, 3:35 PM

I see you have fixed the armor calculations and some other things for tenacity pets. I noticed something new it appears the grace of the mantis talent is adding to the dodge % of the hunters pet.

The talent spell reads:

"Apply Aura: Mod Attacker Melee Crit Chance Value: -2”

So if you select a Grace of the Mantis talent point the spread sheet currently adds 2% to dodge for your pet. I Would expect for this not to add any dodge % to the pet dodge calculation.

Another talent that is incorrectly adding to pet dodge is Pet Barding

The talent spell reads:

"Apply Aura: Mod Dodge Percent Value: 1"

So if you select Pet Barding it is adding a value of 3% to dodge. I would expect that this only adds 1 % per talent point to the pet dodge calculation.

Sources for spell text:

Pet Barding - Spell - World of Warcraft Barding
Grace of the Mantis - Spell - World of Warcraft Grace of the mantis

Note:
Wow head displays the armor bonus as "Resistance%" I'm not entirely sure how accurate wow heads spell descriptions are.
Edit: it appears that all the armor bonus talents use Resitance in there wording I guess you learn something new everyday.
Thanks for your time and effort

Cagney · 11/17/08, 12:05 AM

I wasnt sure where to post this but seeing how the other hunter threads are locked here goes. On my hunter i have been noticing with imp hawk up my ss is casting below 1.5 secs and doesnt seem to be delayed by the gcd. However when rapid fire is up and my ss is below 1 sec, it does seem to be delayed by the gcd.

So my question is is the gcd being lowered to 1sec or am i seeing some glitch?

wl04 · 11/17/08, 5:11 AM

hi Shandara thank you for a great work. Spreadshits helps us alot and makes some choices easier. m8 when i've tried to download my gearlist from armory server i found that Fur Lining-Attack Power isnt supported atm. Could you please add it?

dragoonvengance · 11/17/08, 8:33 AM

Sorry to bother you but for hte life of me i can't fiqure out why you multiple the usefulness of AP by 2.