• promdates

Go to the "Settings" tab and put the epic gem cuts in the list next to the rare gem cuts. It wasn't until I did this, that it started actually showing upgrades. It will use the epic gem cuts for all of the sockets instead of using the regular gems. If you have it set to use regular gems, but you have the epic gems equipped it things your gear is better (which it is at that point). Have it use epic cuts and it will fix itself.

"On a scale of one to mein kampf, how many racists does it take to make a guild look terrible?"

[03:28] L_J: it's "olololo hero class"

[01:09:39] <DeeNogger> Any of the resident grammer nazis on right now?

 

Kradish

I'm not sure whether it's due to my settings and i'm pulling from a limited supply of info but since the change to L'n'L the rotation test seems to be out. Like I said I know it's limited but on a 6 minute fight the rotation test is showing me as getting 3 L'n'L proc's while I got 3 on an Emalon kill that took just over 3 minutes, 5 procs on a 200 second Ignis fight and 4 procs on a 170 second Archavon.

 

Angelis

I've also noticed dispite the 22 sec CD of LnL, I've been getting at least 1 proc every minute. I wonder if they've increased the proc rate on BA to make it more consistent. However this is purely based on a days worth of heroic farming

 

benisapha

Looking at someone else's testing on the SV thread, it seems as if the proc rate is ~25%, and that is is very possible to get almost two a minute. This will need further testing, but difficult to do at work. I will test on Sat at a dummy, as at 1.5-2 procs a minute, I would like to see what this does to SV dps. I cant think that this is anythign but a Huge gain, and would be an immense help mana management fights.

 

Bikiniwax

Shandara,

Whenever you get around to it, the Frag Belt engineering enchant is not in the spreadsheet yet.

 

Æpic

I am in a strange spot with choosing my spec, in that I do have item]Grim Toll[/item] but I only have 123 ArP if I still gem agi. I changed my secondary spec to one that would maximize my dps off of the spreadsheet, but it still states that I should have a lower dps. Unless my [Grim Toll] and my [Darkmoon Card: Greatness] proc a lot more during a fight, my dps on the dummies is generally about 100 higher using my MM spec, which is contrary to the spreadsheet. Additionally, if I gem ArP instead of Agi, my dps should go down even further.

Speaking to the top hunter on my server, he says that I should stay Surv until I reach the ArP softcap of 619 with gems and then choose MM. If any hunter could Armory me at The World of Warcraft Armory and give me some educated suggestions as to what I should do, please let me know. It's jsut a little too expensive to regem twice right now.

Thanks,
Æpic

 

SpartanKillian

I'm having the same problem as the person you replied to. I changed all my default gems to +20 Agi and, while it's slightly different, the problem remains. Now items I -know- are significant upgrades are either showing up as not being an upgrade or being a much smaller upgrade than it should. For example, Windrunner's (H) shoulders show as a +14.27 upgrade over my current Shoulders of Misfortune on the Gear Planner. When I actually plug them in on my profile, the upgrade is closer to +90.

 

Scrith

In addition to adding quite a few missing items (see the link, from another post in this thread, to new 3.2 loot from MMO Champion) and a few that aren't spelled/worded correctly (so they aren't importing from the Armory, such as the Etched Band of the Kirin'Tor and Collar of Ceaseless Torment), I definitely agree that the new epic gems need to be made the default gems in the spreadsheet, because most people aren't remembering to update these and are now wondering why the Gear Planner is giving them unexpected results with their gear that is gemmed with the new epic gems.

 

Bees

Found a bug with Mana Regen from potions:

The named cell AAS should point to Assassin's Alchemist Stone in Trinkets!A18 but points to Darkmoon Card: Crusade in Trinkets!A27.

The named cell MAS should point to Mighty Alchemist's Stone in Trinkets!A44 but points to Mirror of Truth in in Trinkets!A10.

 

Kathucka

The re-gemmer consistently makes certain mistakes that lead to a sub-optimal gem setup. For instance, it insists on putting a [Deadly Ametrine] and [Delicate Cardinal Ruby] in my [Darkcore Leggings]. Given that there is a blue and a yellow slot here, it should either fill both slots with the matching color, or neither. Mis-matching one and not the other is almost always wrong.

This leads any new auto-gemmed gear setup to have lower DPS than my manually-gemmed current set up.

In turn, this leads the gear planner to show lower DPS for any non-equipped item, because the non-equipped item goes with a sub-optimal gem setup. So, everything looks like a downgrade.

The epic gems have only made this problem worse.

I expect that it is causing similar problems for the optimizer.

Change the gemming algorithm to match non-red gem slots only if the bonuses are sufficiently large. Matching two non-red slots would require a really big bonus. In this case, make sure it matches both of the slots.

As a work-around for this problem have the gear planner re-gem the current setup, load the new item, and re-gem the gear with the new item in place, then compare both re-gemmed setups. It's not ideal, but at least it will be comparing equally broken gem configs.

 

SpartanKillian

I realized my mistake from my earlier post. I was looking at the +20 Agi value and not the gem's name and set everything to stormjewels. Switching to cardinal rubies solved the problem.

 

Bees

Found some more bugs, this time in 'Pet Skills', PetSkillMatrix, 'Talented?' column. Several of the abilities point to the wrong talent cells:

Bullheaded is pointing to G20, should be G19
Dash is pointing to G4, J4 and M4 - it should not include M4
Dive has the same issue as Dash
Road of Sacrifice points to M19, should also point to G22

[edit] Also, cooldown on Dive & Dash are wrong. they check for the Dive/Dash talent in G8 but it's also in J8. Bug exists in 'Pet Skills' cells F33 & F34

[edit2] Also, there are some non-damaging pet abilities that are marked as damaging in 'Pet Skills' column 'I':
* Furious Howl
* Dust Cloud
* Bad Attitude
* Snatch
* Tendon Rip
Aside from Furious Howl, they are also marked as critting, which means that they are proc'ing Kill Command when (i think) they shouldn't be

[edit3] Also, Nether Shock is not counted as a damaging ability. Seems it should be calculated the same way as spell attacks like Froststorm Breath, but with shadow debuffs

[edit4] Scorpid Poison is using 0.04 as its AP scaling factor, instead of PetSpellScaling which the other skills use. 0.15/3.5 = 0.042857..., so is a little off - pet DPS changes by 0.89 in my test setup. Spirit Strike uses 4% too.

[edit5] Scorpid Poison dps is being calculated as its max dps, using cooldown instead of frequency. mistake appears to be in Pet Calculations C218

[edit6] Poison Spit has its final DPS wrong, ignoring how many ticks can be applied given its frequency. I195 should be =IF(I193=0,0,I186*I188*I193)

[edit7] Venom Web Spray damage is not calculated. seems it should be calculated the same way as spell attacks and then multiplied by 4. it can never be fast enough for the frequency to be shorter than the cooldown, so there's no need to calculate applied dots

[edit8] For Spirit Strike, you apply hit/crit adjust for the initial hit, and not for the dot. This seems half right, because the dot can't crit, but if the initial hit doesn't hit, then the dot wont apply. Maybe I163 should be multiplied by PetHit?

[edit9] For the Spore Cloud uptime in I145 you use the (unadjusted for longevity) cooldown - it should use the final frequency (Sting has exactly the same issue)

[edit10] If you have 100% hit, the target has 0% dodge and you use Acid Spit, the armor reduction effect causes a divide by zero. The problem is in 'Pet Calculations'!S56 - need to check that AcidSpitChanceToStop isn't zero. Monstrous Bite already has this check.

[edit11] For both Acid Spit and Monstrous Bite stacking/uptime calculations, you use the (adjusted for longevity) cooldown - seems like you should be using the real frequency.

[edit12] Uptime calculations for Acid Spit and Monstrous Bite are always 100% - set the cooldown to 100 seconds and you'll still see it at 100% uptime. The needed tweak is to not count the '% time' for 0 stacks into the uptime calculation. Change T19 from =SUM(T15:T18) to =SUM(T16:T18) and T57 from =SUM(T54:T56) to =SUM(T55:T56). I suspect that Rabid might have a similar issue, but haven't looked into it yet.

[edit14] The macro function Worksheet_Change() in the Pet sheet recalculates the list of skills to show in the pet rotation dropdowns. However, it only updates when you change pet family. If you change your pet spec to allow a new skill (e.g. Cunning pet spec'ing into Wolverine Bite) then it wont be available to put into the rotation unless you change the pet family again.

[edit15] Charge/Swoop is available to the wrong pets - every tenacity and ferocity pet can charge/swoop if spec'd into it - it's not a replacement for dive/dash since some pets (cats) can do both while some (bear) can only do one. The talent in the pet tree should be labelled "Charge/Swoop" in the ferocity tree only (not tenacity!) since 3 ferocity pets (carrion bird, moth, wasp) swoop in place of charging.

[edit16] Bug with populating the talented skills for pet families. Even if spec'd into it, Cunning can't use Roar of Sacrifice and Tenacity can't use Grace of the Mantis. The 'Talented Skills' box isn't currently large enough to hold all 6 talented skills in the tenacity tree (cunning has 5 and ferocity only 2).

[edit17] It's not clear to me why Rabid, Bullheaded and Call of the Wild aren't included in the pick list for pet rotations - other zero-focus-cost abilities are and there seems to be nothing special about these three.

[edit18] Grace of the Mantis appears in the rotation pick-list for cunning pets who spec'd into it, but it's a passive talent, not an ability. It's also is mis-spelled in the Cunning talent tree.

[edit19] Beatial Wrath still causes a damage bonus when you have your pet type set to None

[edit20] Mana gained from Beatial Wrath (calc'd in BeastManaBenefit - Calculations!N45) is not factored into mana expenditure at all

 

Doomglazer

The stats of Gloves of the dark exile are incorect
also Armbands of the Norythern Stalker isent in the database yet

 

Difool

A few more bugs with imports from Armory:

I got the error "+24 Crit is not a legitimate foot enchant" (not exact wording). I selected Nitro Boots as an enchant and it correctly put the +24 crit back on the boots.

On Talent import from WOW Armory I immediately got a Runtime Error (13) - type missmatch. FWIW I have my main spec selected, but my alt spec is currently 0/0/0.

When I hit the debugger on the latter it starts me at this line (I have no idea if that is the start location or the location where the error occurs):
Worksheets("Talents").Range("E2").value = CInt(Mid$(Talents, 1, 1))

 

Kharthus

Same issue here for people without dual specs.

 

Zer0Cool

I gat a popup saying that this cell is protected, and when i try to make the Sheet unprotected it is asking me for password... Is there a different way of changing a Delicate Scarlet Rudy to a Delicate Cardinal? Or maybe someone knows the pass?

Thanks

 

arlen

Change the values in the custom collumn. The default collumn isn't meant to be changed by users.

 

◊ arison

I see Shandara has been away and hasn't posted anything since 7/29. It would be interesting to see what DPS increase a 20% proc rate of LnL gets. Hopefully he will return I wonder if the DPS analyzer has a new proc rate yet.

 

• promdates

While this is true, changing the custom column for the epic gems, at some point the default one should be set to the epic gems. With the epics being so easy to get now (run some heroics, do some pvp, use 150 stone keeper's shards), there's no reason that it can't be set to the default.

"On a scale of one to mein kampf, how many racists does it take to make a guild look terrible?"

[03:28] L_J: it's "olololo hero class"

[01:09:39] <DeeNogger> Any of the resident grammer nazis on right now?

 

arlen

I agree, but as my post stated, the default column isn't meant to be changed by the user which is why the person I was replying to was getting an error. Shandara will have to change the default column since its password protected.

 

swiftfeet

Error with spreadsheet

I am encountering an error using the latest version of your DPS spreadsheet Version 91a.

I am using Excel 2003. If this is the root of the issue, please let me know. As far as I know, spreadsheets are relatively backwards compatible.

The error occurs when I try to mouse over the "Load Gear from Armory" button on the "Gear" tab. The MS Visual Basic debugger comes up and two error messages are displayed. They are the same and say: "Compile Error: Automation Error".

The debugger highlights the Private Sub Worksheet_Change(ByVal Target As Excel.Range) function when this occurs.

Thank you. I appreciate your work on this spreadsheet.


I am also getting this, any help on the matter?

 

Stara

I am also getting what I believe to be weird results in the gear planner, even after adjusting the settings to the epic quality ones.

For example: I currently have Favor of the Dragon Queen with a +8 AGI/+12 STA gem in it. Running the calculations and looking at the gear planner, it tells me Broach of the Wailing Night is an 86.81 DPS upgrade for me. So I swap that into my gear profile, and its actually a ~9 DPS upgrade. Now if I go back into the gear planner, suddenly Favor of the Dragon Queen now is the better trinket by 79.55 DPS. So thinking it has to do with it using an epic gem now, I'll swap it back in with an epic gem which nets me a ~2 DPS upgrade. And then again checking back into the gear planner the Broach is back up as a 76.44 DPS upgrade.

Now maybe the Broach is just bugged in the spread sheet or I suddenly don't know what I am doing, it just seems off.

I haven't tested any other gear yet, this was the first since I have more then enough badges for the Broach, but the way the gear planner is sorting things is making me take a second look.

 

Thorinson

The gear planner assumes you always regem when you switch any piece of gear. I bet that if you made the first swap you mentioned and hit the regem button, the DPS increase is exactly what the gear planner indicated.

 

• promdates

Yes, thanks for pointing out the obvious for me. I never realized that it was password protected at all The message I posted about moving the epics to the default was meant for Shandara. He has to make changes to it anyway (fixing item names, stats, procs, etc.), so he might as well adjust the default gems to the epic ones.

"On a scale of one to mein kampf, how many racists does it take to make a guild look terrible?"

[03:28] L_J: it's "olololo hero class"

[01:09:39] <DeeNogger> Any of the resident grammer nazis on right now?

 

Thorinson

Now that Shandara seems to be occupied, I'd like to add some new gear that's still missing to the spreadsheet myself. I'd really like them to show up in the gear planner.

Does anybody know if this is possible and more importantly how to do this?