WotLK DPS spreadsheet - Page 242

Mendrek · 09/27/09, 8:31 AM

Originally Posted by Mendrek

Since v92 i get #NV dps results after reading from Armory (though items are imported without error). v91 still works fine - what changed?
(Excel 2002)

Figured it out, since v92 you can't use the sample profiles (BM/SV/MM) as templates for your own anymore.
(load sample profile, changing name & server + load armory == #NV results)
Yea, I was lazy :P

Tais · 09/27/09, 9:52 AM

Originally Posted by Mendrek

Figured it out, since v92 you can't use the sample profiles (BM/SV/MM) as templates for your own anymore.
(load sample profile, changing name & server + load armory == #NV results)
Yea, I was lazy :P

Did you remember to remove Blood Fury from your shot rotation?

Mendrek · 09/27/09, 10:42 AM

Originally Posted by Tais

Did you remember to remove Blood Fury from your shot rotation?

darn Horde racials, thanks

Shandara · 09/27/09, 12:36 PM

Originally Posted by Mendrek

Figured it out, since v92 you can't use the sample profiles (BM/SV/MM) as templates for your own anymore.
(load sample profile, changing name & server + load armory == #NV results)
Yea, I was lazy :P

This shouldn't be happening, I'll look into it.

It's probably not rerunning/recalculating the shots properly when you load from the Armory and the priority queue has invalid shots in it.

Nandei · 09/27/09, 12:50 PM

I have the heroic [Forsaken Bonecarver], which the spreadsheet fails to load from my armory profile for some reason. It says it "is not a known item for slot 16". If I try to load it from armory, there are two matches and the sheet skips it. On the other hand my heroic [Blood Fury] loads just fine.

Solidus-Snake · 09/27/09, 4:18 PM

There is an item stat discrepancy for True-aim Long Rifle - Item - World of Warcraft
It is still listed as 141.50 DPS in the spreadsheet.

Ferlog · 09/28/09, 12:50 PM

Hello Shandra,
On the profile templates, you've included the orc racial into the rotation, so what's happening is when you load gear from armory and aren't an orc it is giving "N/A" ### errors and such and breaking the spreadsheet. Basically user's can manually fix this by removing the racials (took me a while to find this, although I see above someone already mentioned this as the fix). Can you please update the profiles to remove the orc racial, so that the rotation can still be used?

Thanks a lot for your effort!

Shandara · 09/28/09, 1:18 PM

Originally Posted by Ferlog

Hello Shandra,
On the profile templates, you've included the orc racial into the rotation, so what's happening is when you load gear from armory and aren't an orc it is giving "N/A" ### errors and such and breaking the spreadsheet. Basically user's can manually fix this by removing the racials (took me a while to find this, although I see above someone already mentioned this as the fix). Can you please update the profiles to remove the orc racial, so that the rotation can still be used?

Thanks a lot for your effort!

This is fixed next release. It won't break on having a bad racial in the rotation upon import any more then.

tim36145 · 09/29/09, 12:28 AM

Found a slight error - Spaulders of the Snow Bandit have 61 haste not hit

dvorjak · 09/29/09, 12:25 PM

Does the spreadsheet take into consideration that Serpent Sting crits now proc EW? If so, would 1/3 in EW be sufficient now for max dps?

Gemfire · 09/29/09, 2:36 PM

It may have been stated already and if so I apologize, but - On the spreadsheet it says "Sample SV Spec 0/15/56." On the talent tab, however, it's 2/18/51. Which of the two is correct?

Edit: If I had been thinking I would have just tried moving the points around. The 2/18/51 is higher by ~60ish dps, so nevermind. :x At least you know there's a discrepancy, at any rate.

Kinigos · 09/29/09, 10:56 PM

Small error in version 92 - for [Attrition]. The values for the haste and ArP are reversed in the spreadsheet from what they should be.

Lactose · 10/01/09, 7:06 AM

Feature request:
New button next to the Regem button -- Regem with output.
If clicked, does the regem as usual, then compares old gems to new gems, and fills a text box with a list of gems that were changed (ignoring any unchanged gems), preferably in a copy-to-Notepad friendly format.

Example output:

REGEM RESULTS

Shoulders:
Blue Socket: Delicate Cardinal Ruby (20 agi)  --> Nightmare Tear (+10 stats)

Legs:
Red Socket: Fractured Cardinal Ruby (20 arp) --> Delicate Cardinal Ruby (20 agi)
Blue Socket: Nightmare Tear (+10 stats) --> Delicate Cardinal Ruby (20 agi)

Example output if no changed gems:

REGEM RESULTS

No changes made!

Shandara · 10/01/09, 7:11 AM

Update:

- Many item stat fixes
- If you have Marked For Death talent, Steady Shot always gains the bonus 10% damage from Glyph of Steady Shot.
- Having a racial in the shot rotation now won't break the sheet upon import of a character with a different race. Remember to adjust your rotation still to suit your talent build.
- Serpent Sting now counts each separate tick as a possible crit for procs
- Serpent Sting can now proc talents/items from crits if you have 2t9

@Lactose:
That's a good idea and it should be fairly easy to implement.

kovacs · 10/01/09, 7:59 AM

I have used this spreadsheet for quite some time now - great work -thank you!

This morning when I tried to import my settings from my last version, 92PTR2, to the current version 92a. Several calculations appear to have an error, #VALUE, if I choose either of the T9 shoulders. If I choose any other shoulders, the error is corrected and actual values are displayed. Am I missing something?

Kovacs