WotLK DPS spreadsheet - Page 72

Quixotic · 12/30/08, 1:33 PM

[Avool's Sword of Jin] is misspelled as Avool's Sword of Kin.

Is the modeling for the [Figurine - Emerald Boar] include gems? I can't find a way to switch the gems in it (I wanted to test 2x [Delicate Scarlet Ruby] instead of the default hit gems), and even with the default gems the DPS seems lower than I would have thought.

zigmund555 · 12/30/08, 2:14 PM

Mining changed to +50 sta, which gives a very minor boost with Survivalist and Hunter vs. Wild.

Showing up as +500 hp on my sheet still.

drpachinko · 12/30/08, 2:55 PM

For some reason the 4% from blood of the rhino is not factored in for pet health.

The Function reads

=1+IF(PetFamily="Tenacity",Pet!M9*0.02,0)

I think if the Function were changed to

=1+IF(FamilyTree="Tenacity",Pet!M9*0.02,0)

it would then work fine

I think this is similar to the fix that was implimented for the armor calculations?

Thanks for all your hard work

xursa · 12/30/08, 3:14 PM

I took a look at the Hunter DPS spreadsheet. I thought for about 20 years now that I was a smart man. Guess not. Im a Civil Engineer and math is all I do everyday for 17 years. I cant figure this thing out to save my pet. Im sure its me, but any of you young people that wrote this magical device needs a job there is money to be made with the brain pan you have. Anyway, I took the "easy" route and went to MAXDPS.com and put my stats in with cat as my pet. It says that I should be at about 2.8k dps right now. I get about 2.2k-2.4k on avg. My rotation is Surpent S-SS (spammed to the max) and AS when CD same with AS when CD, and KS with BW everytime I can. Is the spamming of SS inturupting my Auto Shot cycle? Maybe that the loss of DPS? Remember Im an old guy, be nice.

"First, master the fundamentals"

drpachinko · 12/30/08, 3:44 PM

Originally Posted by xursa

I took a look at the Hunter DPS spreadsheet. I thought for about 20 years now that I was a smart man. Guess not. Im a Civil Engineer and math is all I do everyday for 17 years. I cant figure this thing out to save my pet. Im sure its me, but any of you young people that wrote this magical device needs a job there is money to be made with the brain pan you have. Anyway, I took the "easy" route and went to MAXDPS.com and put my stats in with cat as my pet. It says that I should be at about 2.8k dps right now. I get about 2.2k-2.4k on avg. My rotation is Surpent S-SS (spammed to the max) and AS when CD same with AS when CD, and KS with BW everytime I can. Is the spamming of SS inturupting my Auto Shot cycle? Maybe that the loss of DPS? Remember Im an old guy, be nice.

"First, master the fundamentals"

Start at the overview tab work your way left then back to the shot rotation tab.

Auto shots are no longer cliped by anything except volley

If you have a more specific question I would be happy to answer it for you. I don't mind to share my useless video game knowledge.

Sylvand · 12/30/08, 10:24 PM

Originally Posted by Onouris

I can't figure out whether the 4-piece T7 bonus is adding any DPS. I don't know if it's been asked or explained before, and I've tried looking through the thread but it's getting a bit unwieldy.

I've done a few things and it seems to make no difference whether I'm hitting 4 set T7 or not, but it's proving difficult to test. One thing I did is set it to use the rotation test only, then switch to 4 set T7, check my DPS, then update the test (which with the haste should have proved more DPS). It did, but only 5.

The way I worked out how much DPS the 4 set T6 added on the previous sheet was to break the password then just set the 'number of T6' to 4.

I would use custom gear to create an item identical to T7 (without the set association) and compare 3 T7 + custom to 4 T7.

Onouris · 12/30/08, 11:24 PM

Originally Posted by Sylvand

I would use custom gear to create an item identical to T7 (without the set association) and compare 3 T7 + custom to 4 T7.

Good idea. Exactly what I just did, and indeed the 4 set bonus is not being calculated.

dragoonvengance · 12/31/08, 11:40 AM

In regards to Aspect of the Beast and the PTR changes currently to hunters.
According to the spreadsheet survival is by far the highest DPS and should be the worst time to use Aspect of the Beast. I played with the spreadsheet with a 0/20/51 surv build and noticed something odd. It seems the spreadsheet is showing aspect of the beast as a 70dps increase over dragonhawk even as survival with a cat. If you use a scorpid it beats it by 120dps.

The numbers I'm seeing with my setup are
Cat No Aspect
Total - 5658
Me - 4333
Pet - 1229

Hawk
Total - +143
Me - +123
Pet - +17

Beast
Total - +215
Me - +0
Pet - +215

I have looked around and it seems beast has not been nurfed yet. Is there anything I'm missing or is beast the best aspect regardless?

Sthellesta · 12/31/08, 11:46 AM

Originally Posted by dragoonvengance

I have looked around and it seems beast has not been nurfed yet. Is there anything I'm missing or is beast the best aspect regardless?

Aspect of the Beast is currently bugged on live to give 21%(25.44% glyphed) pet AP instead of 10%(12% glyphed). The latest spreadsheet version calculates AotB in its bugged state. From what I've read, AotB will be fixed in the next patch.

Seoman · 12/31/08, 1:21 PM

I'm sorry to bring this up again, but can someone state clearly how the "Assume 100% Hit" button on the Gear Planner tab currently works?

I think I saw that currently, more hit after the cap still adds DPS, which Shandara is fixing in the next release - do the setting of this button change that as far as the Gear Planner is concerned even before the fix? Will the fix change this setting at all?

At 100% Hit, does the Gear Planner take into account lost Hit from current equipment as compared with gained Hit from the upgrade? Does it simply not consider Hit as at all valuable in its calculations, essentially assuming that the 100% Hit will be maintained by other gear? Or something else entirely?

Synergy · 12/31/08, 1:51 PM

I posted this in the simple questions thread but didn't get any answers so I'll post it here too. I asked if our 4 piece bonus was actually any good or not and I ended up testing it on my own but wanted help analyzing the results.

Ok I actually kinda tested this on my own but I was curious for input.... I tested on a dummy both with, and without 4 piece bonus and these were my results. I only shot Steady Shot and Auto Shot while in viper, I probably should have done serpent too now that I think of it to make it more realistic.

Time from approx. 0 mana to full with 4 piece - ~29 seconds
Time from approx. 0 mana to full without 4 piece ~32-33 seconds

So assuming you're in Viper from 0 mana to full mana (I have 11k mana) this will save you 2 GCDs while in Viper?

This is just what I thought to test, anyone else want to point out something I did wrong or should have done instead? And if these results are sufficient, does this mean 4 piece bonus is pretty bad assuming you don't have mana issues?

Someone told me to check DPS in both too so a quick test and not super carefully done showed me...

DPS with 4 piece - 1441 dps
DPS without 4 piece - 1335 dps

Which changes things a little...

mako · 12/31/08, 2:13 PM

Level 80 Cryptstalker's 4 piece set bonus is entirely useless if you do not have to use aspect of the viper, or if you only use viper while moving.

In a fight where you actually need to use viper from 0 to full, it would be worth ~115 dps according to your testing. If you account for the loss of dps incurred from switching non-tier pieces with the tier ones (particularly chest and/or helm) you'll find that the set bonus is relatively weak.

Stinkerbelle · 01/01/09, 3:03 AM

Is there a simple way for me to adjust the Overview/Server Set to allow downloading gear from a non-EU/US server? (Taiwan in particular.)

No worries if it's too complicated to bother with.

Shandara · 01/01/09, 6:25 AM

Originally Posted by Stinkerbelle

Is there a simple way for me to adjust the Overview/Server Set to allow downloading gear from a non-EU/US server? (Taiwan in particular.)

No worries if it's too complicated to bother with.

This will be in the next release. It was easy to add. It _seems_ to work properly since the Taiwanese Armory also provides data in English (thankfully). I'm finishing up some additions to the sheet right now and expect a release in a few days.

The 'Assume 100% hit' function will be changed slightly so it discounts any hit given by gems as well. It only affects the gear planner.

King-Slide · 01/01/09, 1:29 PM

I'm experiencing a strange problem with the spreadsheet. My "Haste to Cap" isn't calculated right. At the moment I selected some gear to sit at 286 Haste and the SS keeps telling me that Haste to Cap is 0. Is there a button to turn off serpent swiftness or anything similar? With Haste to Cap = 0 it weights haste much less than the other stats and keeps suggesting gear without haste. Could this be a msexcel 2k7 specific problem?