WotLK DPS spreadsheet - Page 71

Zyther · 12/28/08, 3: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, 5: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, 5: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, 5: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, 5: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, 6: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, 8: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, 9: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, 9: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, 10: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, 12:36 PM

deleted

Onouris · 12/29/08, 5: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, 7: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, 4: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, 11:14 AM

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.