Best Possible DPS in Shandaras WotLK Spreadsheet - Page 7

Midnight · 02/17/09, 8:20 AM

For one thing it seems like he did his changes on the original spreadsheet not on the one downloaded here which kind of doubles my work. Also he did all the changes with Open Office and I don´t really trust those values. I assume there´s just something that breaks because it doesn´t process the contained scripting properly which leads to the higher result.

In short: if the results should be included in the op please either
- use my linked spreadsheet and describe the changes made to them (like in post #128) or
- give a full description of everything that isn´t fixed as per op (like in post #3 and #4) or
- upload your own spreadsheet with the template in question

That beeing said I did miss the changes proposed by Schanaha and Ingmar which did lead to an 73.44 DPS upgrade to the BM template. I changed it now though.

thesmoosh · 02/17/09, 8:48 AM

Apologies if someone has already done this, but is there any chance anyone could host the spreadsheet with the top DPS sets using a hosting site other than rapidshare? For some reason rapidshare tells me that my IP is already downloading and the only way I can download the spreadsheet is by paying for a premium account.

I have the original spreadsheet, but it'd be nice to download the one with the BIS sets already included.

Riqi · 02/17/09, 2:04 PM

Originally Posted by Midnight

For one thing it seems like he did his changes on the original spreadsheet not on the one downloaded here which kind of doubles my work.

Two reasons I chose to start with Shandara's sheet, in the absence of any specific instructions (which now exist). First, the name of the thread. Second, I wanted to avoid any possible problems that might have existed in Middi's sheet.

It turns out that I was correct: there are errors in Middi's sheet which is what caused me problems in the very beginning.

After gaining access to Excel (2003), I have learned that OOo and Excel come up with the same results for the sheets, so OOo compatibility is no longer in question. I will be updating my original post to remove the edits and make it "easier" to follow along.

The Target Debuffs contain (copy/paste?) errors:

- Hunter's Mark (not you) has modifier "100%" instead of "Both". Hunter's Mark isn't mentioned in The List of buffs, but "100%" isn't a valid choice anyway.
- Blood Frenzy/Savage Combat has no modifier at all, instead of "100%".

These two corrections raised the default SV spec from 6556.39 to 6701.15. BM and MM will both go up, but I'll wait for these corrections to make it to Middi's sheet before doing anything else.

Midnight · 02/17/09, 4:01 PM

First off, my apologies if my post came over rude, it wasn´t my intention. Also thanks for pointing out the errors, I just fixed them. You guessed right in that they originated in my copy&pasting the debuffs when the additional Hunter's Mark line was introduced to the spreadsheet.

The reason why I´m so picky about how changes are communicated is that it´s really time consuming and prone to errors (as has just been demonstrated) to get new templates in and carry them over from version to version. Now if you do it on one of the original sheets I´ll have to first get one of those, recreate your path, verify the result and then do it all over again in the other spreadsheet.

Also please forgive me if I´m still a bit sceptical about OO compatibility with the spreadsheet. Last time I used it, it didn´t work properly and I kept reading about people who have problems with it too in Shandara's thread. That´s not to say your results are wrong or that it cannot work of course.

hahapwnt · 02/17/09, 6:51 PM

Hey doods..I was curious what attack power these hunters hit when they are pulling around 6k dps.

Ingmar · 02/17/09, 7:08 PM

Originally Posted by hahapwnt

Hey doods..I was curious what attack power these hunters hit when they are pulling around 6k dps.

If you read the first post you can easily see for yourself what stats the best templates have.

It ranges from 7604 (MM), 7646 (BM), to 8838RAP (SV), excluding procs.

Hunteralex · 02/18/09, 12:33 AM

As i was looking through this, I had noticed that you had used [Darkmoon Card: Greatness] (That particular item has strength.) I figured it was probably intended to be 90+ agility. As i stated earlier, just picking out the errors.

Originally Posted by Danzou

Survival Layout

v82 spreadsheet: 6798.95 dps (Hunter: 5678.57, Pet: 1120.38).

Race: Dwarf (Gun Specialization)
Professions: Jewelcrafting + Blacksmithing
Spec: 6/14/51
Pet Spec: Raptor
Glyphs: Serpent Sting, IAotH, Steady Shot
Buffs/debuffs: Exactly as OP
Consumables: Elixir of Mighty Agility, Elixir of Mighty Thoughts, Blacked Dragonfin, Spiced Mammoth Treats
Shot Priority: Rapid Fire > Serpent Sting > Kill Shot > Explosive Shot > Multi-Shot > Steady Shot
Pet Priority: Savage Rend > Claw

Gear:
Melee - [Journey's End] + [Item not found!]
Head - [Blue Aspect Helm] + [Arcanum of Torment] + [Relentless Earthsiege Diamond] + [Glinting Monarch Topaz]
Neck - [Favor of the Dragon Queen] + [Delicate Dragon's Eye]
Shoulders - [Valorous Cryptstalker Spaulders] + [Greater Inscription of the Axe] + [Delicate Scarlet Ruby]
Back - [Drape of the Deadly Foe] + [Scroll of Enchant Cloak - Superior Agility]
Chest - [Chestguard of Flagrant Prowess] + [Formula: Enchant Chest - Powerful Stats] + [Delicate Scarlet Ruby] + [Delicate Dragon's Eye]
Wrists - [Slime Stream Bands] + [Scroll of Enchant Bracers - Greater Assault] + Socket Bracers + [Delicate Scarlet Ruby] + [Delicate Scarlet Ruby]
Hands - [Frosted Adroit Handguards] + [Scroll of Enchant Gloves - Major Agility] + Socket Gloves + [Delicate Scarlet Ruby]
Waist - [Torn Web Wrapping] + [Eternal Belt Buckle] + [Delicate Scarlet Ruby]
Legs - [Valorous Cryptstalker Legguards] + [Icescale Leg Armor] + [Delicate Scarlet Ruby] + [Delicate Dragon's Eye]
Feet - [Boots of the Renewed Flight] + [Scroll of Enchant Boots - Superior Agility]
Rings - [Surge Needle Ring] + [Strong-Handed Ring]
Trinkets - [Fury of the Five Flights] + [Darkmoon Card: Greatness]
Ranged - [Envoy of Mortality] + [Heartseeker Scope]
Other - [Dragonscale Ammo Pouch] + [Mammoth Cutters]

had to use custom item on Wrist's and Gloves due to the fact that the spreadsheet doesn't have the option to add blacksmithing socket to them. but i just took the basic stats and added 16agi so it should be exactly the same as adding a socket.

Rezdan · 02/18/09, 12:56 AM

The wowhead item tag is defaulting to the Str one, just like in your post. Think everyone reading this thread should know or can assume he's using the Agility one, since its the only one modelled in the spreadsheet.

Sylvand · 02/18/09, 5:33 AM

Please verify and update:

Downloaded Best_DPS_84.xls

Load "Best DPS SV" (default)

Switch Ring from "Greatring of Collision" to "Strong-Handed Ring".
Switch gem in the helm from "Rigid Autumn's Glow" to "Delicate Scarlet Ruby"

Dps 6701.96 (was 6701.15).

14 hit rating over the cap, but there doesn't seem to be any good place to shed it.

Thanks!

baklava · 02/19/09, 12:37 PM

For Beast Master

Hunter DPS 3431,97
Pet DPS 2614,01
Total DPS 6045,99
Health 24839
Armor 11448
Mana 13645,5
Dodge 16,11%

Same Items as Best_DPS_84
Change Spec to Talent Calculator - World of Warcraft (BM 52/12/7)
Use Survival Hunter Items at default
change every agility gems with AP version, like 16 Agility to 32 AP, and 27 Agility to 54 AP (3 gems).
change leggings with "Leggings of Failed Escape" put the same gems
change socket of belt with "Pristine Monarch Topaz (16 AP, 8 Hit)"
change head ench with "Rigid Autumn's Glow (16 Hit)"
Change Boot Ench with "Greater Assault".
Glove Ench with "Crusher".
Remove Agility + Intellect Pot and Put Flask of Relentless Rage Pot
and change food with "Poached Northern Sculpin"
Glyphs - Glyph of Bestial Wrath + Glyph of Steady Shot + Glyph of Aspect of the Hawk

Change pet to Devilsaur with Monstrous Bite > Bite

Shot Rotation
Rapid Fire - Serpent Sting - Kill Shot - Bestial Wrath - Multi-Shot - Blood Fury - Arcane Shot - Steady Shot

For MM

change race to Orc
Shot Rotation - Rapid Fire Blood Fury Serpent Sting Chimera Shot Kill Shot Arcane Shot Aimed Shot Readiness None Steady Shot

Hunter DPS 5024,65
Pet DPS 1198,06
Total DPS 6222,71
Health 24706
Armor 12218
Mana 14892,9
Dodge 21,22%

Vitaro · 02/19/09, 7:46 PM

Originally Posted by baklava

For MM

change race to Orc
Shot Rotation - Rapid Fire Blood Fury Serpent Sting Chimera Shot Kill Shot Arcane Shot Aimed Shot Readiness None Steady Shot

Hunter DPS 5024,65
Pet DPS 1198,06
Total DPS 6222,71
Health 24706
Armor 12218
Mana 14892,9
Dodge 21,22%

For this to work you'd have to change the Buff Profile to "No Heroic Presence". Doing so leads to the lower DPS figure of 6019.62.

aremyk · 02/20/09, 1:20 AM

With the best dps gear posted with ArP, such as the boots, legs, and neckpiece. Would they still be a higher dps than equivilent gear with specifically ap/crit/haste gear with a warrior tanking?

Granted, the boots and the neckpiece are level 226 and there isnt items without ArP at that level.

Rezdan · 02/20/09, 2:29 AM

The BIS gear setups assume a full stack of Sunder Armor as stated in the OP's "buffs to include".

Slunter · 02/20/09, 5:06 AM

Originally Posted by baklava

For Beast Master
...
Change Spec to Talent Calculator - World of Warcraft (BM 52/12/7)
...
Change pet to Devilsaur with Monstrous Bite > Bite
...

Cannot use a Devilsaur without the Beast Mastery talent.

baklava · 02/20/09, 5:48 AM

Originally Posted by Slunter

Cannot use a Devilsaur without the Beast Mastery talent.

ow true, but devilsaur isnt bringing much dps, you can edit it with raptor anyway.

Mizzle4190 · 02/23/09, 5:25 PM

Now im an Enchanter/JC and i think Chanting> LW because with the ring stats which is +32 atck power and the +50 Atck power chant you get 124 Atck power bonus instead of just the 114 + from LW

C/D?

axol · 02/23/09, 5:54 PM

Originally Posted by Mizzle4190

Now im an Enchanter/JC and i think Chanting> LW because with the ring stats which is +32 atck power and the +50 Atck power chant you get 124 Atck power bonus instead of just the 114 + from LW

C/D?

The two ring enchants + 50AP to bracers would equal 114AP not 124.

alienangel · 02/23/09, 5:59 PM

Originally Posted by axol

The two ring enchants + 50AP to bracers would equal 114AP not 124.

To translate to Mizzle's language, I believe the answer would be "D".

(Please capitalize and spell correctly Mizzle)

Zina · 02/27/09, 10:21 PM

I see non has posted this setup yet. And its the best SV setup i've personally come up with.

Version: 84
Race: Orc
Spec: 6/14/51
Pet: Raptor

RAP: 6746(seems really low tho, but thats what it shows.)
ArP: 68
Agi: 2272

Dps - Hunter: 5527.31
Dps - Pet: 1180.68
Dps - Total: 6707.99

Crit vs 83: 58.86%
Hit vs 83: 100.26%

that was with Draenei Aura and Heartseeker Scope tho. but lets be Realistic.. a Orc can't get Draenei Aura so can't add that really.

With hit scope:
Dps - Hunter: 5495.37
Dps - Pet: 1180.68
Dps- Total: 6676.05

Crit vs 83: 57.99%
Hit vs 83: 100.18%

Weapon: [Journey's End] Enchant: Massacre(110 AP).
Ranged: [Envoy of Mortality] Scope: [Schematic: Biznicks 247x128 Accurascope]

Head: [Valorous Cryptstalker Headpiece] Enchant: [Arcanum of Torment], Gems: [Relentless Earthsiege Diamond], [Delicate Dragon's Eye]
Neck: [Favor of the Dragon Queen] Gem: 16 agi
Shoulders: [Valorous Cryptstalker Spaulders] Enchant: [Greater Inscription of the Axe] Gem: [Delicate Scarlet Ruby]
Cloak: [Drape of the Deadly Foe] Enchant: 22 agi
Chest: [Chestguard of Flagrant Prowess] Enchant: 10+ Stats, Gems: [Delicate Scarlet Ruby] [Delicate Dragon's Eye]
Bracers: [Slime Stream Bands] Enchant: 50 AP, Gem: [Design: Delicate Scarlet Ruby]
Gloves: [Frosted Adroit Handguards] Enchant: 22 agi
Belt: [Torn Web Wrapping] Gem: [Delicate Scarlet Ruby]
Legs: [Leggings of Failed Escape] Enchant: [Icescale Leg Armor] gem: [Delicate Scarlet Ruby] [Delicate Dragon's Eye]
Boots: [Boots of the Renewed Flight] Enchant: 16 agi
Rings: [Surge Needle Ring] / [Strong-Handed Ring] Enchant: 32 AP
Trinkets: [Fury of the Five Flights] / [Darkmoon Card: Greatness]

With this setup, I'm completely hit capped.

i could reach higher dps if i changed scope and added Draenei Aura, but since Orc is the best race and Draenei is Alliance race i can't get that.

Originally Posted by Rezdan

Current spreadsheet version as stated in the OP is v84. Not 83c.

Yeah, sorry fixed it. Didn't notice i had a 9th Feb on my computer stored somewhere else and only got the PTR one.

Updated.

Rezdan · 02/27/09, 10:36 PM

Current spreadsheet version as stated in the OP is v84. Not 83c.

Midnight · 03/01/09, 5:19 AM

I checked the configuration and as far as I can tell it can´t top the current best sv template (I´m getting 6676,05). In any case I don´t think it´s very useful to try to get better templates at this momemnt, because with 3.1 just around the corner we´ll have to redo most of it anyway. I guess I´ll pick up here again by the time v86 is ready or something.

Zina · 03/01/09, 11:14 AM

I downloaded the Spreadsheet you had linked on first page.

did following changes:

- Changed Head to T7.5
- Changed JC gem from Neck to Head, and added 16 agi gem to Neck.
- Changed Chest to Chestguard of Flagrant Prowess

and dps went up by 2.

so ended with this.

Total dps: 6703.76

FrostmaneMaul · 03/04/09, 3:04 PM

I was just wondering, why is the Raptor listed as the best dps pet in the speccs?
I've been testing on a target dummy with both a cat and a raptor, and the cat comes out 30-40 dps more than the raptor (when I use the raptor, I time Kill Command and Savage Rend, and when i use the cat, I just hit kill command). Am I doing anything wrong? I've just been hitting autoshot meanwhile.

Har · 03/04/09, 3:09 PM

Originally Posted by FrostmaneMaul

I was just wondering, why is the Raptor listed as the best dps pet in the speccs?
I've been testing on a target dummy with both a cat and a raptor, and the cat comes out 30-40 dps more than the raptor (when I use the raptor, I time Kill Command and Savage Rend, and when i use the cat, I just hit kill command). Am I doing anything wrong? I've just been hitting autoshot meanwhile.

This was gone over a few times in the spreadsheet thread, but it's still a valid question. Shandara has said that due to the long cooldown on the raptor ability, once averaged out, it will look like more dps than a cat. It's streaky, however, and cats are consistent. Depending on the length of your test, that can contribute to the differences.

Spatrick · 03/04/09, 3:11 PM

Originally Posted by FrostmaneMaul

I was just wondering, why is the Raptor listed as the best dps pet in the speccs?
I've been testing on a target dummy with both a cat and a raptor, and the cat comes out 30-40 dps more than the raptor (when I use the raptor, I time Kill Command and Savage Rend, and when i use the cat, I just hit kill command). Am I doing anything wrong? I've just been hitting autoshot meanwhile.

Savage rend is dependent on pet crits. I assume Raptor's come out ahead in raids due to buffs.