WotLK DPS spreadsheet - Page 46

Sylvand · 11/25/08, 8:27 PM

If you're looking for a list of items to include, MMO champion has generated a really nice set. Speaking from personal experience, I recently banked most of my T6 gear, including breaking my 4pc bonus, and every new item I have is in these lists (and/or already in the spreadsheet).

Wrath of the Lich King - Leather Armor
Wrath of the Lich King - Mail Armor
Wrath of the Lich King - Miscellaneous Armor
Wrath of the Lich King - Physical Weapons

contraband · 11/25/08, 8:40 PM

this may be a bit of a silly question, but i cant find out how to change the profile O_o

im stuck on the profile "Shandara" atm :/ (tho i can change the name of the Shandara profile, i cant seem to add a new one

)

keep up the good work btw, amazing what your doing :>

edit: im using office 2007, am i missing a drop down selection box or something?

Dch48 · 11/25/08, 9:38 PM

Newest version is better but the crit box for ranged weapons still does not update--it stays stuck on 13 at all times

thehittmann1981 · 11/25/08, 10:43 PM

Noticed a few things missing a some not working correctly also.

Missing:

King Dred's Helm
Necromantic Wristguards
Azure Ringmail Leggings
Runeblade of Demonstrable Power

Not working correctly:
Masters Inscription of the Axe (importing from armory)
Icewalker Enchant (importing from armory)
Arcanum of Torment (importing from armory)

They all come up as unsupported even though they are in the list.

Tsook · 11/25/08, 11:42 PM

Regarding the questions of whether Agi will once again become better for us than comparable ivalues of AP, I investigated with some of the gear available in the sheet. I'm not claiming this solves the argument entirely or is even a particularly scientific approach to the problem, but these are my results.

This is for BM (54/17, but I doubt a few points here or there would dramatically change it). I didn't check for Marks and we already know agi is better than AP for survival. I used the "Level 80 Raid" buff set that comes with the sheet, and a Raptor pet. Again, I'm just looking for a trend here, so I'm not concerned about getting everything 100% kosher.

I selected what seems like a fairly representative sample of good 5-man/heroic gear. For reference, this left me with:
1428 Agi
2880 AP
630 Crit
284 Hit
80 ArP
94 Haste

At these levels, Agi is .788 DPS per item budget and AP is .859. So AP is about 9% better than agi.

Next I picked 10-man gear. This brings the stats up to
1526 Agi
2772 AP
673 Crit
299 Hit
126 ArP
156 Haste

At these levels, Agi is .858 DPS per item budget and AP is .921. So AP is 7.3% better.

Finally I picked 25-man gear. I pretty much just picked the top of everything in the gear planner.
1530 Agi
3146 AP
824 Crit
299 Hit
136 ArP
275 Haste

At this gear level, Agi is .901 DPS per item budget and AP is .952. So AP is 5.7% better.

So, with each gear increase, as AP continues to rise, agi becomes more valuable, just as we've come to expect in BC. I'm not going to speculate on what our future gear will look like exactly, but it seems pretty likely that in a tier or two we'll be back to 1 agi > 2 AP - at least in terms of what the spreadsheet says values are.

Dantastic · 11/26/08, 4:02 AM

Firstly huge gratitude for continuing the great work of cheeky, Im sure countless hunters will benefit from this

However, Ive just loaded my gear/spec and set raid buffs etc, and the dps Im getting out is 2300, compared to over 4k Ive been hitting on stand and nuke raid bosses. No doubt theres a few small errors in the setup - wrong buff food for example, but is there any other mistake I could have made to give this big a gulf, I considered shot rotation but thats a pretty simple steady spam while keeping serpent up so not sure how wrong I could have got it to be honest!

Also, is call of the wild modelled? Im fairly sure every raiding hunter will be using this awesome pet talent, and although I have yet to scour the sheet I cant see it mentioned with BW etc in the rotation part.

Any help would be much appreciated

Shandara · 11/26/08, 4:37 AM

Originally Posted by Dantastic

Firstly huge gratitude for continuing the great work of cheeky, Im sure countless hunters will benefit from this

However, Ive just loaded my gear/spec and set raid buffs etc, and the dps Im getting out is 2300, compared to over 4k Ive been hitting on stand and nuke raid bosses. No doubt theres a few small errors in the setup - wrong buff food for example, but is there any other mistake I could have made to give this big a gulf, I considered shot rotation but thats a pretty simple steady spam while keeping serpent up so not sure how wrong I could have got it to be honest!

Also, is call of the wild modelled? Im fairly sure every raiding hunter will be using this awesome pet talent, and although I have yet to scour the sheet I cant see it mentioned with BW etc in the rotation part.

Any help would be much appreciated

I've loaded your gear/spec into the spreadsheet and with a Wolf Pet (I don't know what you have), it gives me a predicted value of 4045 dps.

Have you checked the following:
a) Rotation filled in correctly for both hunter and pet? Remember Steady Shot needs to have the lowest priority (i.e. not #1). In your case Serpent Sting should be #1 and Steady Shot #2. Same goes for the pet.
b) Level of pet set at 80? Talent points set correctly?

Dantastic · 11/26/08, 4:44 AM

Hi, cheers for that. I think Ive got all those things right, but if youve loaded me in and got the right result (almost dead on patch, impressive

) then it proves its me being silly somehow (probably always the most likely explanation!). Ill keep fiddling, hopefully can get the same numbers out, Ill report back, the help is really appreciated

)

germanboy3383 · 11/26/08, 5:14 AM

i just got a quick question. i was just toying around with the spread sheet and i realized that on the pet tab i would get vastly different DPS result depending on what order i would put the pet abilities, in this case i switched around rake and claw and it is a difference of roughly 450 DPS.
I am wondering if that is working properly or if that may be a bug.
http://img114.imageshack.us/img114/2480/picture2gn2.png
http://img114.imageshack.us/img114/729/picture1gx4.png
if that is working properly then does it matter in game what order my pet uses rake and claw also (i have both on autocast in the pet spell book since i have no room in my pet bar).

Shandara · 11/26/08, 5:14 AM

On a non-related note, does anyone know what the tooltip text is for the blacksmithing bonus socket enchant?

Edit:
To the poster above, Claw is a spammable ability while Rake is on a CD. Putting Claw above Rake results in Rake not being used because there are no pet GCDs left to use it with.

Lerastes · 11/26/08, 6:10 AM

Found another missing item.

Ring of Indignant Rage
Binds when picked up
Finger
+27 Stamina
Equip: Improves hit rating by 20
Equip: Improves critical strike rating by 20
Equip: Increases attack power by 45.

I still haven't gotten it to work right, though with most of the items available it doesn't matter as much. I found I can change the level of the character and server location (US, EU) on the Overview page, but I cannot change the server or character name. Possibly related, but the Load from Armory button doesn't do anything. Stat cells in custom gear are unchangable no matter what I do. After poking around, it looks like every button on the spreadsheet does nothing for me (yes, macros are enabled) except for CalcAttributes, which works fine.

EDIT: At last, it works! I loaded it up on an old copy of Excel 2003 I finally found and it works beautifully. One thing, however, Hauberk of the Arcane Wraith is in the spreadsheet as Hauberk of the Arcane Wrath, so is listed as not supported.

Dch48 · 11/26/08, 6:21 AM

Originally Posted by germanboy3383

i just got a quick question. i was just toying around with the spread sheet and i realized that on the pet tab i would get vastly different DPS result depending on what order i would put the pet abilities, in this case i switched around rake and claw and it is a difference of roughly 450 DPS.
I am wondering if that is working properly or if that may be a bug.
http://img114.imageshack.us/img114/2480/picture2gn2.png
http://img114.imageshack.us/img114/729/picture1gx4.png
if that is working properly then does it matter in game what order my pet uses rake and claw also (i have both on autocast in the pet spell book since i have no room in my pet bar).

I really wish I knew how you people are getting these high dps figures. Mine are nowhere near that , but, I removed all buffs because I want to see what I do unbuffed. One thing I noticed from those pics though. You need to take those points that are showing in tenacity out because even though the pet is ferocity, if you have those other talents selected, they effect the stats. Just take out pet barding and see what happens to the armor on the pet if you don't believe me.

samfisher · 11/26/08, 6:25 AM

Hmm, the gear planner MIGHT have some calculation probs. Crossbow of Relentless Strikes = 176.92, Drake Mounted Crossbow = 349.77?? That's a huge increase if it's right xD This is after I click the Ranged Weapons button at the top. Also, Armory has been revamped, but it still works with the spreadsheet if anyone is worrying.

Mudflap · 11/26/08, 10:00 AM

I'm a bit confused at how the pet and shot rotation parts work. Currently I use either a gorilla for soloing/questing, and a cat for instances. I have a few questions after spending a couple hours playing with the spreadsheet.

Should I be putting spammed abilities (claw/smack) as lowest rank, and long cooldown abilities at the top?
Does the same go for my hunter shots?
Is there a way to save different talent specs, and different gear profiles? It seems to overwrite whatever is there if I use the save button.

And to whoever mentioned putting together a tutorial or new-user guide, that would be great! I'm new to the hunter world (hit 70 about a week before WOTLK), and very new to this site, so I'm just starting to dip my toes into theorycrafting physical dps after playing various mages for 3 years.

Thanks

SpartanKillian · 11/26/08, 10:09 AM

Is it possible to adjust the dropdowns in the gear tab to only include items from Crafting/WotLK (ala the Gear Planner tab)? There's a lot of TBC spam to sift through and it's going to get worse once all the blues are added.

Edit: I also noticed that when I test the 53/11/7 build and set my rotation priorities to Beast Within/Rapid Fire/Serpent Sting/Steady Shot, my Rotation Test tab still calculated Readiness at 3.20... despite refreshing. I can't seem to find a way to disable Readiness and it's obviously throwing non 50/21/0 numbers off. Any suggestions?