WotLK DPS spreadsheet - Page 39

Shandara · 11/13/08, 2: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, 2: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/16/08, 11:05 PM

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, 4: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, 7: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.

Shandara · 11/17/08, 7:44 AM

Originally Posted by dragoonvengance

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

Because for each point of item budget, you can get 2 points of AP compared to 1 point of agility, etc..

Bifuu · 11/17/08, 8:53 AM

The following item is missing from the data base:

[Wodin's Second-Best Shanker]

It seems like a direct upgrade from a Mojo dagger so it would be nice to have it listed =)

Decker · 11/17/08, 9:10 AM

Originally Posted by Bifuu

The following item is missing from the data base:

[Wodin's Second-Best Shanker]

It seems like a direct upgrade from a Mojo dagger so it would be nice to have it listed =)

It's a quest item, and for the most part only Dungeon and Raid items are in the file unless they're spectacular. I wouldn't mind seeing a ton more items contributed (I've been doing it myself manually) to this list...hell...I'd like to see all of them that pertain to us to assist with the Gear Upgrade when leveling. I don't think this should only be used at 60/70/80, but that's just one mans opinion. Right now it's not worth the effort for someone to go through the spreadsheet and set it up to find out which items are slight upgrades, which is a shame. Sure we spend most of our time at 80, but there is a whole lot of time before that.

Also there are many Equivalencey Point Mods...why not collaborate and get all data from the spreadsheet into the game for immediate use with leveling? I know it won't spit out a perfect hunter rotation, but it should give you an idea of which items are better. I'm not looking for this as much for me as I'd be looking for it for other people to easily use. I can get my EP into mods such as ItemValue and they work great. I just don't have the knowledge to work on an ingame mod from the ground up implementing the formulas in the Hunter DPS Spreadsheet. It'd be a lot of learning from both aspects (understanding the formulas in the spreadsheet more, and understanding the LUA code better as well).

Before we get into "Bring us solutions, not problems" I've contacted Shandara in regards to this, but no response yet (not sure if it's in the works, and I don't want to waste anyone times by doubling the efforts on separate projects!).

Bifuu · 11/17/08, 9:50 AM

Originally Posted by Decker

It's a quest item, and for the most part only Dungeon and Raid items are in the file unless they're spectacular. I wouldn't mind seeing a ton more items contributed (I've been doing it myself manually) to this list...hell...I'd like to see all of them that pertain to us to assist with the Gear Upgrade when leveling. I don't think this should only be used at 60/70/80, but that's just one mans opinion. Right now it's not worth the effort for someone to go through the spreadsheet and set it up to find out which items are slight upgrades, which is a shame. Sure we spend most of our time at 80, but there is a whole lot of time before that.

Also there are many Equivalencey Point Mods...why not collaborate and get all data from the spreadsheet into the game for immediate use with leveling? I know it won't spit out a perfect hunter rotation, but it should give you an idea of which items are better. I'm not looking for this as much for me as I'd be looking for it for other people to easily use. I can get my EP into mods such as ItemValue and they work great. I just don't have the knowledge to work on an ingame mod from the ground up implementing the formulas in the Hunter DPS Spreadsheet. It'd be a lot of learning from both aspects (understanding the formulas in the spreadsheet more, and understanding the LUA code better as well).

Before we get into "Bring us solutions, not problems" I've contacted Shandara in regards to this, but no response yet (not sure if it's in the works, and I don't want to waste anyone times by doubling the efforts on separate projects!).

Good point, I used the Custom gear to look at it anyways, its still an up for me but not for long

But i did find another error though [Bjarngrim Family Signet] is misspelled as "Gjarngrim Family Signet" within the spreadsheet

Iru · 11/17/08, 11:15 AM

Shandara,

I love the new gear planner, saves me doing a bunch of what I used to do manually to that sheet.

I have on request, though. Would it be possible to add a '10-man only' selector to the gear filter? This would help people in smaller guilds, like myself, who expect to run 10 man content frequently but may not get to the 25-man versions of the WotLK end game content.

dragoonvengance · 11/17/08, 8:23 PM

Some hunters were pointing out that in game beast seems to be giving the pet approx 21% ap increase. They are not sure why, but I think the spreadsheet gives it the correct 10% and not the actual 21% ish.

Chul · 11/17/08, 11:36 PM

A few (very) minor things:

Missing Aspect of the Dragonhawk (more for completeness sake)
If you turn off firing of all specials then you get a lot of #DIV/0, including for pet DPS and autoshot DPS.

Kargos · 11/18/08, 6:02 AM

Sorry if this info has already been stated, just doing a quick post before I run off to work.

- Prison Warden's Shotgun is a typo, currently listed as Prison Warden's Gun in the spreadsheet.

- I'm also getting an error that reads "+85 Attack Power is not a supported Melee enchant." I would assume that's something up with how it's referencing the enchant.

Also, I picked these up from using the Load Gear from Armory Button, just to clarify how I came across these.

Thanks for your time and keep up the good work!

Edit: Greater Savagery is listed as an enchant in the spreadsheet (85 ap).

greendef · 11/18/08, 6:12 AM

I got lucky and was able to tame Loque'nahak. Are there any tests done with it's special attack and if not, what kind of information does the community need to evaluate it's usefulness in pve?

Smoggers · 11/18/08, 6:21 AM

Originally Posted by greendef

I got lucky and was able to tame Loque'nahak. Are there any tests done with it's special attack and if not, what kind of information does the community need to evaluate it's usefulness in pve?

If you are attempting to maximize your dps as a 51pt bm hunter, then a devilsaur will provide higher dps than a spirit beast.

EDIT: Is anyone else experiencing an odd result dealing with improved hunter's mark? As cookie cutter survival, I'm getting a higher dps return per point than imp aoth. I've tried glyphing for both respected abilities, and glyphed mark coupled with 3/3 improved mark produces more dps (almost twice the increase) as 3pts invest in a glyphed imp aoth. From what I've read and seen, imp mark is pretty terrible outside of a deep marks build and imp aoth is generally where survival dumps its points. Am I missing something?