Best Possible DPS in Shandaras WotLK Spreadsheet - Page 11

Midnight · 02/17/09, 7: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, 7: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, 1: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, 3: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, 5:51 PM

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

Ingmar · 02/17/09, 6: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/17/09, 11:33 PM

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/17/09, 11:56 PM

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, 4: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, 11:37 AM

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, 6: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, 12: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.