WotLK DPS spreadsheet - Page 41

Fimbo · 11/21/08, 12:04 PM

Interesting effect going on with the Spreadsheet.

I wanted to test the difference in gain between Longevity and Animal Handler.

So I loaded up the "default 50/21" spec and got a Total DPS figure of 1638, with two points in Longevity.
Changing the setting to 1 point the DPS number immeadiately increased to 1656.
Going down to 0 point reduced it to 6118.

Looks likely there's a maths bug somewhere.

As a note however: Shandara - If I were you I really wouldn't even be thinking of maintaing this while levelling! The community appreciates your efforts and I look forward to seeing the spreadsheet evolve AFTER you've got to 80 and killed Sarth.

rabidfire · 11/21/08, 1:48 PM

Longevity 3/3 is better than 1/3 which is better than 2/3 if you're using a cat, so your numbers are in-line. This was covered before.

What I haven't seen any information about is the spreadsheet weighting 2AP much, much higher than 1Agi. It kinda makes sense if you think about it, but I still want some confirmation before going AP for everything. Can anyone confirm this?

Rokh · 11/21/08, 2:09 PM

I'm really interested in the +1 int being the best stat for my gear, according to the sheet. Gemming and enchanting Int is showing more a DPS increase than anything else. I get the mana return, AP from talents, ect. Just seems really really odd that that's how it'd work out.

Also worth noting it's all depending on what fight, what buffs, ect you have. So yeah, mostly ignoring that for now in the sheet.

rabidfire · 11/21/08, 2:31 PM

The higher 'Viper Damage Penalty' is in Shot Rotation tab, the more value will be given to Int. In the Settings tab you can change 'Aspect Behavior' to 'Always On', that will de-value Int by quite a bit.

edit: Missing [Ring of Invincibility] from the spreadsheet

Tsook · 11/21/08, 6:40 PM

Originally Posted by rabidfire

What I haven't seen any information about is the spreadsheet weighting 2AP much, much higher than 1Agi. It kinda makes sense if you think about it, but I still want some confirmation before going AP for everything. Can anyone confirm this?

It doesn't for me. Do you have absurdly high crit and low AP? Is Blessing of Kings on?

EDIT: Actually, you're right. The spreadsheet is showing 2 AP as about 10% better than 1 agi with early level 80 levels of gear, for BM spec. Of course, that lead should decrease as your gear improves and you start getting more AP, which will increase the relative value of crit and thus agi.

EDIT2: Caught up with the continuing discussion in the simple questions thread. Does assuming 10% AP bonus at all times to match Blessing of Kings mean that AP and agi will keep their current relative strength as gear improves? Perhaps. It's an interesting question, and one that maybe is best resolved by experimentation in the sheet.

Khallas · 11/21/08, 10:30 PM

I have noticed that there are a lot of decent blue items that are not listed in the pre-existing gear list. There are a lot of quest rewards and and rep rewards that are very decent weapons and gear that aren't listed. A few that I have been using that aren't listed are:

Zombie Sweeper Shotgun (Argent Crusade - Revered)
Traditional Fleshing Knife (Kalu'ak - Revered)
Dragonstompers (Crafted: Leatherworking) (Most of the other LW crafted gear as well, haven't started wearing it yet due to not breaking my T6 4pc)
Ring of Foul Mojo (Quest Reward)
Spiked Collar of Servitude (Quest Reward)

Burakan · 11/22/08, 1:24 AM

I'm having an issue with custom gear and profiles.

When I load custom gear into a profile, no issues occur.

However, when I make a second profile, also with custom gear, and save, it will display that new custom gear in the first profile when loaded, but the stats of the first profile are unchanged from the original save. If I were to save the profile again, it would then change the custom gear on the first profile, which should not happen.

Summary of problem:

When you have two profiles with custom gear, the stats on the gear from the second-made profile are being displayed in the first profile gear (custom gear). No change occurs to the DPS stats of the first profile, even though the gear is displaying inaccurately.

As an ancient hunter theorycrafter, I have to say that the spreadsheet is well done. I would suggest future development should be focused on user-friendliness, as the one criticism I could make about the current one is the lack of such user-friendliness.

In particular, I would like to see gear profiles handled better than they are. If you look back at Rooke's spreadsheet from OG WoW, you will see that she separated each gear set into a different tab. This allowed the user to intuitively create a set of gear, and view the results, side by side with the other sets. The profile system of the current sheet is a bit awkward, and as you can see from the above, can lead to problems (unless my problem is unique).

Well done, overall.

Edit: Also, Thunderstomp is not displaying damage and frequency values.

Kargos · 11/22/08, 7:47 AM

Quick item that isn't listed.

Eternal Belt Buckle (Crafted, Blacksmithing)

Adds a socket for belts.

Keep up the good work and have fun leveling!

Khallas · 11/22/08, 3:07 PM

An additional note, the fur lining wrist enchants and icewalker boot enchant are not importing in from armory. The spreadsheet is saying they could not be found as a supported enchant even though they are in the list already.

Vail · 11/22/08, 4:03 PM

First off, thank you so much for continuing Cheeky's work, secondly is there a way to use this without Microsoft Excel? I don't feel like purchasing it at the moment and was hoping for another means of using it.

Ocelotmgs3 · 11/23/08, 1:12 AM

wtb some info on a macro that contains steady shot with serpent sting in it for the 10% increased steady shot from the glyph

Maa · 11/23/08, 8:18 AM

Poached Northern Sculpin is missing from the food buffs section.

Shandara · 11/23/08, 1:44 PM

Update:

- Various spelling errors and stats on items fixed. Added a few missing ones.
- Rotation Test tab will now properly do nothing if no shots are selected
- Added Aspect of the Dragonhawk

Added a lot of items, probably missed some stuff. Also adjusted quite a few calculations to live patch numbers (damages on abilities etc..). Too much to list.

Dch48 · 11/23/08, 1:47 PM

Cheeky's always worked for me. I downloaded this one and no matter what I do, it shows N/A for all the calculations. What do I have to do to make this thing work?

flimflam · 11/23/08, 2:36 PM

Getting an error with the latest version 78 when trying to load gear from the armory.

Run-time error '91':
Object variable or With block variable not set

Then highlights this line:

sName = Node.Attributes.getNamedItem("name").Text

sUrl variable is: http://www.wowarmory.com/item-info.xml?i=44081&lang=en_us