WotLK DPS spreadsheet - Page 43

Zyther · 12/28/08, 4:19 AM

Small issue here, I can not Import my Gear from the armory or even any other hunters for that matter if there on a US realm. EU toons work fine.

Zemekes · 12/28/08, 6:07 AM

Originally Posted by rthiago

Just a minor bug, if you set "Assume 100% hit" to Yes on the gear planner and hit CalcAttributes it gives a zero div error.

I fount this issue also. The problem is caused by the macro "DpsPerStat" when it reaches the following commands

Worksheets("Overview").Range("DPSHit").value = (Worksheets("Calculations").Range("TotalHunterDPS").value - HunterDPS) / HitToCap
Worksheets("Pet").Range("PetDPSHit").value = (Worksheets("Pet").Range("PetTotalDPS").value - PetDPS) / HitToCap

TEMPORARY UNSANCTIONED FIX:
Note: This "Fix" was not approved by the creator of the Spreadsheet. Use it at your own risk.
I'm sure there is a better way to fix this issue but the way i did was entered the debuger and changed the lines stated above in the "DpsPerStat" Macro to end with (HitToCap + 1E-20)
Doing this will make the macro never run into the Divide by Zero error. I tested it to also not assume 100% hit and it worked fine. Doing this will change the DPS per stat value on the Overview tab to "0" if you have it set to assume 100% hit.

Originally Posted by snail

Someone can correct me if I'm wrong but the 100% assumes 8% hit on the hunter while pets require 9% hit to be capped.

It should change the gear planner as long as you click the "CalcAttributes" button on the Overview tab.. However, due to the bug stated above, you get a Divide by Zero error if you have the gear planner tab set to assume 100% hit.

Garby · 12/29/08, 6:33 AM

Originally Posted by danglebombs

Hrm, it may be just me but I find it odd that its trying to tell me that Nerubian Conquerer is better than Envoy of Mortality >_<

I noticed that its because on my spreadsheet it shows 0 stats for Envoy, same for Final Voyage.

Every god damn page. This is the new "LOL OPENOFFICE VERSION?" it seems.

You have to hit the Ranged Weapon button when you add in another zone's worth of loot.

Hunterlin · 12/29/08, 6:42 AM

Originally Posted by Garby

Every god damn page. This is the new "LOL OPENOFFICE VERSION?" it seems.

You have to hit the Ranged Weapon button when you add in another zone's worth of loot.

I have same issue(Envoy of Mortality having 0 dps value) with every version of spreadsheet.
I have no good clue what causes this, but those buttons and filters are not cause of problem and recalculation of weapons does not fix this.
I am using Excel 2007 instead of 2003, so might be problem is caused by some incompatibilities between versions.

Garby · 12/29/08, 6:44 AM

Originally Posted by Hunterlin

I have same issue with every version of spreadsheet.
I have no good clue what causes this, but those buttons and filters are not cause of problem and recalculation of weapons does not fix this.
As I am using Excel 2007 instead of 2003, so might be problem is caused by some incompatibilities between versions.

I've never heard of it not being that, but my expertise with spreadsheets is nil beyond how to use it. PM Shandara or wait for a response here, I suppose.

Sylvand · 12/29/08, 7:24 AM

Originally Posted by Hunterlin

I have same issue(Envoy of Mortality having 0 dps value) with every version of spreadsheet.
I have no good clue what causes this, but those buttons and filters are not cause of problem and recalculation of weapons does not fix this.
I am using Excel 2007 instead of 2003, so might be problem is caused by some incompatibilities between versions.

I am using Excel 2007 and ranged weapons show up correctly after waiting for the Ranged Weapons calculation to run. It is showing me Envoy of Mortality at 709 dps right now, with the other weapons descending as you would expect. This is on 81a but I have also got it working on other recent versions (79+?).

Hunterlin · 12/29/08, 9:49 AM

Originally Posted by Sylvand

I am using Excel 2007 and ranged weapons show up correctly after waiting for the Ranged Weapons calculation to run. It is showing me Envoy of Mortality at 709 dps right now, with the other weapons descending as you would expect. This is on 81a but I have also got it working on other recent versions (79+?).

Just after reading this got some idea and did test.
Now I found what causes problem with ranged weapons calculations. If you do anything( clicks anywhere ) while calculation is in progress, it does not run up to end and gets interrupted. Even if it looks like calculation is continuing for ~10 seconds after you look in other tab, it still gets interrupted.
After pressing button "Ranged Weapons" take hands off keyboard and mice and let calculation just run until end. This fixes problem.

Shandara · 12/29/08, 10:27 AM

Originally Posted by Hunterlin

Just after reading this got some idea and did test.
Now I found what causes problem with ranged weapons calculations. If you do anything( clicks anywhere ) while calculation is in progress, it does not run up to end and gets interrupted. Even if it looks like calculation is continuing for ~10 seconds after you look in other tab, it still gets interrupted.
After pressing button "Ranged Weapons" take hands off keyboard and mice and let calculation just run until end. This fixes problem.

This is unfortunately a limitation of how it works. Since all the code does is execute a macro (which in essence is a series of keypresses/inputs) it will disrupt if you start clicking during it.

If anyone knows how to stop errant user clicks from messing it up, PM me.

Hirgux · 12/29/08, 10:51 AM

Originally Posted by Hunterlin

Just after reading this got some idea and did test.
Now I found what causes problem with ranged weapons calculations. If you do anything( clicks anywhere ) while calculation is in progress, it does not run up to end and gets interrupted. Even if it looks like calculation is continuing for ~10 seconds after you look in other tab, it still gets interrupted.
After pressing button "Ranged Weapons" take hands off keyboard and mice and let calculation just run until end. This fixes problem.

Anywhere in the spreadsheet, or may I alt-tab out of excel and do something else? Because this calculation takes much time at my pc.

Shandara · 12/29/08, 11:06 AM

Originally Posted by Hirgux

Anywhere in the spreadsheet, or may I alt-tab out of excel and do something else? Because this calculation takes much time at my pc.

You can alt-tab or anything.

It helps to disable any loot instances you're not interested in to keep the amount of ranged weapons tested to a minimum.

Dralmoo · 12/29/08, 1:36 PM

deleted

Onouris · 12/29/08, 6:33 PM

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.

Rokh · 12/29/08, 8:01 PM

I don't think it's been reported, and I'm sort of surprised, but there appears to be a bug with the latest version and hit rating, in that adding hit rating always increases your DPS. I can add 1000 hit rating by hand and it'll bump my DPS up accordingly. I have it set to use the "assumed 8% option" or whatever, I'm not sure if it's limited to that or not.

Shandara · 12/30/08, 5:29 AM

Originally Posted by Rokh

I don't think it's been reported, and I'm sort of surprised, but there appears to be a bug with the latest version and hit rating, in that adding hit rating always increases your DPS. I can add 1000 hit rating by hand and it'll bump my DPS up accordingly. I have it set to use the "assumed 8% option" or whatever, I'm not sure if it's limited to that or not.

This will be fixed next release (and has been reported yes).

Sthellesta · 12/30/08, 12:14 PM

For those using OpenOffice, a fix to the Error:508:

Go to the calculations tab, and in cell B19 and change "TrueShotRankSet" to "TSARankSet." The whole line should look like:

=IF($Talents.H20>=1;1+VLOOKUP(IF(AutoSpells;VLOOKUP(Level_Selected;TrueShotRanks;2);TSARankSet);TrueShotTable;2;FALSE());1)

This should alllow those with OpenOffice to be able to at least use the spreadsheet, even if the macros don't work.

Quixotic · 12/30/08, 2: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, 3: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, 3: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, 4: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, 4: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, 11: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/31/08, 12:24 AM

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, 12:40 PM

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, 12:46 PM

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, 2: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?