WotLK DPS spreadsheet - Page 134

Zer0Cool · 08/16/09, 6:31 PM

Originally Posted by promdates

Ok, for those of you having issues with the current gear planner. Here's how to fix it.

1) Input your gear into the "Gear" page. Either download from armory or manual input.
2) Setup your talents and glyphs on "Talents".
3) Setup your raid buffs.
4) Prep your shot rotation on the "Shot Rotation" tab.
5) Set your Pet info on the Pet tab.
6) On the settings page, next to each gem in the "Re-Gem Options", set the gem cut in the Custom Values box. FILL IN EACH BOX. Even if you're only changing the 20agi to 20arp, set the others as they would be set, 10agi/10crit 10agi/10hit, etc. For the blue/greens, set them as Vivid and Shifting as normal. Do NOT set them as Nightmare Tear's, it will regem it wrong and you'll have to manually regem again.

If you're using JC gems, set that box to Yes, and set your JC gem of choice.

Note: Doing it this will, the Regem button will use blue and/or green gems for sockets. Don't be alarmed, but do double check that a cardinal ruby won't be a better choice in that blue socket over the purple/green gem. Boots of Living Scale is a great example. For my personal setup, going with 20arp+20agi is better than 20arp+10agi/15stam+12ap bonus by ~7dps. Double check any purple/green gems that the sheet puts in your gear.

Here's a picture of my gem settings for reference.

@promdates,

Thank you for taking your time with this detailed post. I had done exactly as you sad. My "Settings" Tab looks exactly like yours only I have "Delicate Dragons Eye 34 Agil" instead of the ArP in the last column. After Recalculating DPS unfortunately it didn’t help... Most of my gear is still BiS. My Mirror of Truth is showing to be BiS out of all Ulduar Trinkets... lol What am I doing wrong? Maybe if someone have few min to spare they can input my date in there spreadsheet to see that it’s not just me having these results... I would really appreciate this.

Thanks

Allara · 08/16/09, 6:34 PM

Originally Posted by Zer0Cool

My "Settings" Tab looks exactly like yours only I have "Delicate Dragons Eye 34 Agil" instead of the ArP in the last column

Pretty sure this is your issue. Just put non-JC epic gems in, and the regemmer should substitute JC gems on it's own for you as needed.

Zer0Cool · 08/16/09, 6:47 PM

Originally Posted by Allara

Pretty sure this is your issue. Just put non-JC epic gems in, and the regemmer should substitute JC gems on it's own for you as needed.

Im not exactly sure what you mean by this... In the last colum I tryed changing from a Epic JC gems to a normal 20 Agil but it still gave me my gear is BiS

Well I made a small mistake in my 1st reply. I forgat to change the 1st colum from Arp to Agil because I copyed promdates values. After I changed that and recalculated DPS the Planner was looking much closer to what it was before. However it still does have many differences compared to the v91a. For example T8.5 Chest is 2nd BiS in 91b for Ulduar and Embrace of the Gladiator is BiS with 28.69 Delta increase. In 91a T8.5 is BiS for Ulduar and Embrace of the Gladiator is #4 in line with the -89.95 Delta decrease. What gives? Was the DPS values changed for Embrace of the Gladiator in 91b? Same goes for Belt of Dragobs vs Death-Warmed Belt. In 91a DWB is #3 in line and BoD is BiS (for Ulduar) with 10.88 Dewlta increase. In 91b DWB is BiS and BoD is #2 with -8.78 Delta decrease.

promdates · 08/16/09, 8:10 PM

Originally Posted by Zer0Cool

@promdates,

Thank you for taking your time with this detailed post. I had done exactly as you sad. My "Settings" Tab looks exactly like yours only I have "Delicate Dragons Eye 34 Agil" instead of the ArP in the last column. After Recalculating DPS unfortunately it didn’t help... Most of my gear is still BiS. My Mirror of Truth is showing to be BiS out of all Ulduar Trinkets... lol What am I doing wrong? Maybe if someone have few min to spare they can input my date in there spreadsheet to see that it’s not just me having these results... I would really appreciate this.

Thanks

I put your info into my sheet, and it came out just fine. Either you're doing something wrong, or you're not following the steps properly. Here's the breakdown for you:

Helm - 4th
Hands - 4th
Neck - 4th
Waist - 2nd
Shoulder - 9th
Legs - 6th
Back - 5th
Feet - 5th
Chest - 4th
Wrist - 7th
Ring1 - 7th
Ring2 - NA
Trink1 - 8th
Trink2 - 2
2h - 6th
Bow - 3rd

Bees · 08/16/09, 11:07 PM

not sure this is a bug, but maybe just an odd mechanic - in 91b the mp5 effect from Mana Spring Totem (91-109.2 MP5, depending on improvements) does not stack with the mp5 from food (Spicy Fried Herring). is this correct?

[edit] flask of pure mojo also doesn't stack with food and/or mana totem/blessing of wisdom

[edit2] in fact, it's not a stacking issue - the spreadsheet just ignores any mp5 from food & flasks.

Rødefar · 08/17/09, 6:58 AM

Bug in the name for "Etched Band of the Kirin Tor"
It is named Ring in the sheet, it have to be Band to load correct.

@promdates : Thanks for the post, now I have almost same item status as I did before patch.

Shandara · 08/17/09, 8:36 AM

I have nearly finished adding the missing items (and heroic version) to sheet as well as fixing the misnamed items. It's taking so long because I am also trying to make it easier for me to add items (adding the 100s of items in patch 3.2 takes a long time), plus I had to debug a new way of Armory Import based on itemID (since we'll now have items with the same name, but different IDs).

promdates · 08/17/09, 11:53 AM

Originally Posted by Rødefar

Bug in the name for "Etched Band of the Kirin Tor"
It is named Ring in the sheet, it have to be Band to load correct.

@promdates : Thanks for the post, now I have almost same item status as I did before patch.

I had to help Zer0cool over AIM last night to get his working. The directions are easy to follow (sort of), but you do have to make sure that everything is setup properly. Also, don't worry so much about "X item was YY:YY delta over Z item in 91a and only WW:WW delta over Z in 91b". If you're using the T8.5 chest, chances are you should have the T9H, T9-craftable, and the T9N chest above yours (in theory).

kabes · 08/17/09, 11:56 AM

My gear planner issue isn't that everything is BiS it's that I get discrepancies between what the gear planner tells me and when I actually equip the item in the gear tab. I'm going to feel stupid if "Delta" doesn't mean the DPS difference, because that is what I assume.

For example, if you were to load my gear and talents (MM spec) the gear planner tells me that Ancient pendant of arathor is 8.39 better than my currently equipped Broach of wailing night, but when I go and equip it my dps drops by approximately 15.

Another example is Mirror of Truth vs. Banner of Victory. The gear planner says that banner is only 3.37 over mirror, but when I equip Mirror vs. Banner, the difference is about 27 in favor of Banner.

Shandara · 08/17/09, 12:32 PM

Originally Posted by kabes

My gear planner issue isn't that everything is BiS it's that I get discrepancies between what the gear planner tells me and when I actually equip the item in the gear tab. I'm going to feel stupid if "Delta" doesn't mean the DPS difference, because that is what I assume.

For example, if you were to load my gear and talents (MM spec) the gear planner tells me that Ancient pendant of arathor is 8.39 better than my currently equipped Broach of wailing night, but when I go and equip it my dps drops by approximately 15.

Another example is Mirror of Truth vs. Banner of Victory. The gear planner says that banner is only 3.37 over mirror, but when I equip Mirror vs. Banner, the difference is about 27 in favor of Banner.

This is because most likely that after regemming, you'll have more DPS with your current equipped item. The next version should have also an entry for your current item with a regem.

Update:

- Fix for Armory Import of items not in the sheet
- Swordguard embroidery now procs from hits instead of crits
- If you don't have a pet selected, Bestial Wrath will do nothing now
- Added setting to set Lock&Load proc chance, change to 6,5% per talent point to mimick the tested 20% rate
- Corrected Colliseum-5man item stats
- Added notification on gear planner when the currently equipped item can produce more DPS with a regem.
- Rotation Test LastAutoShotCheck fix
- Food/Flask/Elixir buffs that provide Mp5 now stack with BoW again
- Change JoW calculations from PPM to fixed 50% proc chance
- Corrected spelling on Tuskar's Vitality enchant for Armory Import (+15 Stamina and Minor Speed Increase)

This should have most of the Colliseum items in there (including hardmode/heroic drops from MMO's db). I still have to recheck any badge/other drops. If anyone spots an item that is missing post or PM so I can add it. There's a LOT of items in the sheet now so I suggest using the filters to limit its calculations.

Argg0 · 08/17/09, 3:36 PM

Using my current gear and spec, changing from 3 points on FA to 3 points on Imp Barrage then hitting Regem led me to weird stuff... Like Nightmare tear on my helmet (a red slot) and lots of stam/hit gems around the gear (even though the socket bonus are some weak things like 8 AP).

Also... on test rotation... on reference table, Rapid Fire is shown to give 40% Haste bonus and Berserk (should be Berserking, but no problem on that...) is shown as 0. Is that supposed to be right?

Shandara · 08/17/09, 3:49 PM

Originally Posted by Argg0

Using my current gear and spec, changing from 3 points on FA to 3 points on Imp Barrage then hitting Regem led me to weird stuff... Like Nightmare tear on my helmet (a red slot) and lots of stam/hit gems around the gear (even though the socket bonus are some weak things like 8 AP).

Also... on test rotation... on reference table, Rapid Fire is shown to give 40% Haste bonus and Berserk (should be Berserking, but no problem on that...) is shown as 0. Is that supposed to be right?

Using the default gems in the sheet, it fills most yellow sockets with +20 hit gems (because you switch 3/3 FA to something else it needs to make up for 3% hit naturally somehow). and the blues with +10 hit/+15 stamina. These are the default +hit filler gems defined in the sheet for me.

Your chestpiece's socket bonus is +6 hit so it tries to match that first, which leads to needing a +10 hit/+15 stamina gem in your Loop of the Agile. A better choice would've been to put +20 hit in your chestpiece's blue socket and a +16 agility gem in the ring. But in my sheet that gains you 2 dps.

One thing is that it tries to fill the meta-gem requirements with the Tears on the first pass, but it doesn't check at the end whether you've satisfied them already with yellow/blue gems for +hit reasons. Replacing it gains you 4 dps (but you can't replace it if you remove both blue +hit/+sta gems as outlined above).

EDIT:
As for the Troll racial, that's just a display issue, the actual calculations use the right value.

EDIT#2:
@Sean: Re-uploaded fixing that.

Sean · 08/17/09, 4:54 PM

Shandara - it looks like you accidently entered the ArP value on Sylvanas' Cunning as Haste instead.

Lilbitters · 08/17/09, 5:27 PM

Hellion Glaive (Heroic) - missing from dropdown menu
Waistguard of Deathly Dominion (Heroic) - Horde version of heroic item missing (has alliance version "Belt" and non-heroic "Waistguard" only) Also should be 90 Sta, 98 Agi instead of switched
Sylvanas' Cunning Should have 57 ArP rather than Haste

Lufan · 08/17/09, 5:55 PM

Using the newest spreadsheet, I get a run time error when I try to load my profile from the Armory.

Runtime error 1004
Application-defined or object-defined error

If Worksheets("Gear").Range("B50").value <> "None" Then
Worksheets("Gear").Range("A50").value = "Prismatic Socket"
End If

Line 1263 is the line the debug tool highlights, which I made it in bold.

Steps to replicate:
1) Go to overview tab and enter the following information:
Character: Lufan
Realm: Eredar
Server Set: U.S.
Level 80

2) Go to gear tab and hit the Load Gear from Armory button.

I tried to load up another random profile of a Hunter that has a prismatic socket, I do not get any errors.

Shandara · 08/17/09, 6:04 PM

I've re-uploaded v91c fixing the issues above. Because MMO's DB doesn't have the stats always in a fixed order I sometimes ended up imputting them in the wrong stats. I caught most of my own mistakes, but a few have slipped through I see.

Thanakar · 08/17/09, 6:33 PM

One of the trinkets I've been using is the Battlemaster Accuracy but for some reason it is the only Battlemaster trinket unsupported by the spreadsheet and I was wondering why?

Well, after going to the setting tabs and adjusting for my JC gem of choice, then recalculating on the gear planner, all my gear dropped out of the top 10 so does that mean I did it right? For example, before doing that it showed my Ancient Pendant of Arathor as being better than Fool's Trial but after setting the gems it shows the Fool's Trial at a +24.55 Delta to the Ancient Pendant of Arathor.

pabelanger · 08/17/09, 7:14 PM

[Spiced Mammoth Treats] should set as default pet food as it is greater then [Kibler's Bits]

Dch48 · 08/17/09, 7:31 PM

The latest version (91c) does not import from the previous one correctly. The profiles I have with Survival spec work perfectly but my main spec which is BM gives N/A's for all dps and attack power calculations when I load those profiles.
Actually, loading the sample BM spec given in the sheet does not work either. It also gives all N'A's so it seems it's not an import issue but something messed up in the BM calculations. All of the other default profiles load correctly.

Sean · 08/17/09, 7:49 PM

Yeah - something is broken with Bestial Wrath right now. Whenever you add it to the Shot Rotation it breaks the spreadsheet.

promdates · 08/17/09, 7:51 PM

Originally Posted by pabelanger

[Spiced Mammoth Treats] should set as default pet food as it is greater then [Kibler's Bits]

This is something that I was complaining about to Zer0Cool the other night. The ironic thing is, it's only a ~5-7dps increase to use the Spiced Mammoth Treats over the old Kibler's Bits. Also remember that it's ~5-7 if your pet is 100% dps time on the boss. So if you still have Kibler's Bits laying around, feel free to keep using them until you run out. You won't notice any real dps loss.

@Switching from 91b to 91c: There was an issue before where it wouldn't import properly. The best bet is to just start over and put all of your information in again if you're having issues with the import. If you're familiar with it, it shouldn't take you very long. Just as long as you're not having issues with the Amory import, but just the export/import from the Hunter_export_bin file.

Bees · 08/17/09, 9:21 PM

Originally Posted by Sean

Yeah - something is broken with Bestial Wrath right now. Whenever you add it to the Shot Rotation it breaks the spreadsheet.

[edit] i take back what i said - looks like a new bug. can't figure it out yet either

Bees · 08/17/09, 9:24 PM

i've updated rawr source to match 91c and uncovered a new bug in the process:

Silencing shot is able to be used in non-rotation-test mode without the talent

My spreadsheet bug list is now down to 18 issues: Rawr.Hunter module status & bug list (scroll down to "Spreadsheet Bugs (91c)")

[edit] a couple of new ones:

* chimera refreshes stings even if you don't have the talent (it correctly gets a 0 freq, however)

* rounding for serpent sting damage varies very slightly between serpent sting and chimera shot:

CS =ROUND(H82*PRODUCT(H87:H92,1+H93),1)/5*H95
SS =ROUND(H82/5*(PRODUCT(H86:H92)+H93,1)*H95

or in english:

CS =ROUND(BaseDamage * DamageAdjust ,1) / 5 * Ticks
SS =ROUND(BaseDamage * DamageAdjust / 5 ,1) * Ticks

Chimera shot also ignores H86 (crit adjustment) which only matters if the T9 2-piece bonus is in effect, but this might be intentional. seems like it's probably a bug though.

dvorjak · 08/18/09, 12:52 AM

Going from spreadsheet 91b-91c I have lost 111dps as SV. I was at 7506 and I am now sitting at 7395, the same happens when I switch to MM. Where is this huge dps loss coming from? I am currently logged out in my proper gear/spec.

Shandara · 08/18/09, 5:01 AM

Originally Posted by Bees

<snip>

Chimera shot also ignores H86 (crit adjustment) which only matters if the T9 2-piece bonus is in effect, but this might be intentional. seems like it's probably a bug though.

Trying to remember why I did this, but it seems to me that the fact that serpent sting ticks can crit doesn't change CS-Serpent. CS-Serpent is based on the pre-loaded amount of damage set when the sting is applied (or that's how the mechanic seems to me). Whether individual ticks crit randomly can't change that.

EDIT:
Re-uploaded v91c, fixing some of the bugs Bees' outlined (as well as the Beastmastery spec problem).

As for the remaining issues, there are various reasons for them in the sheet:

* Nether Shock/Venom Web Spray not implemented, because there has never been any testing on them (nor did I consider them raid-worthy pets).
* Rabid, Bullheaded and Call of the Wild not in pet abilitiy list: these are off the pet GCD as far as I know, so they are just averaged out instead of using frequencies. The pet frequency system is a legacy of when every ability was on the pet GCD, but with Blizzard's changes a few patches ago to most abilities it's less useful. It could probably be done away with at some point.
* This is also why CotWild uses the cooldown instead of a possible frequency.