alienangel

Sweet.

If you're going to make it do calculations to decide whether to wait or not, it would be bestI think to go with your current format and list how long the delay was in cases where it was determined to be worth waiting, so we can look at the results to see what the cutoff for various pairs of shots is.

Originally I was only thinking of highlighting cases of direct collision (not the waiting I think we're talking about above) where say arcane and chimera come off cooldown at the same time, and we use the priority on the shot-rotation tab to pick one to fire first - that'd be handy to identify potential problems with our shot priorities or talents/glyphs.

 

Shandara

Small update:
The rotation test doesn't calculate the optimum time to wait for each shot yet (I will have to work on that a bit) but it works on Arcane/Multi/Aimed and Kill Shot now.

WotLK Hunter DPS Spreadsheet

 

Rivkah

With regards to the talent checks, I actually liked that it wasn't strictly enforced before, it made it much easier to test the effects of a single talent point (i.e. focused fire) without having to shuffle a bunch of other points around to get the talent.

 

Shandara

It is just a visual reminder that the spec is invalid, don't worry. It doesn't actually disable talents that shouldn't be able to work in that spec.

WotLK Hunter DPS Spreadsheet

 

KergeKacsa

Bug: In the newest version on the target's debuffs part the Fearie fire 5% armor reduction doesn't add to total armor reduction.
(If I hand adjust 5%, it works.)

 

Drakbak

you know, i've been doing a lot of work with ArP Rating lately because I have a gut feeling that it's truly more powerful than most hunters give it credit for (at least for MM, not so sure about the others). To this effect, I've been playing around a lot with this spreadsheet as well as working with some of my own numbers. Which brings me to this post.

I feel that the calculation used for the Mjolnir Runestone trinket is too simplified and doesn't give an accurate representation of the proc effect. This would hold true for other such ArP proc effects.

1) The current calculation used by the spreadsheet works along the same lines as similar proc effects like AP, Crit, etc. which would be fine if it scaled similarly to those stats, but it doesn't.
2) ArP grows increasingly more powerful the more you stack. Therefore, when this trinket procs and you get roughly 50% Armor penetration, your DPS will skyrocket and especially so if you're already stacking ArP. Averaging out the ArP Rating from the proc doesn't give a good estimation on the trinket's power.
3) ArP rating caps out at ~1232. For those who are stacking ArP past 620 passive, the proc on this trinket will excede that cap, and they will not receive the full benefit. This needs to be taken into consideration.

In order to properly account for the strength of this trinket, we need to calculate in terms of DPS and not ArP rating. The way I worked out the calculation is that we calculate two DPS totals: One that's only for the passive ArP total, and one for the ArP total when the trinket procs. You take the difference between the two DPS totals and multiply it by the Uptime %. This calcs are for the hunter's personal dps, no pet dps is included.

Examples:
I am sitting at 620 (50.34%) passive ArP rating, and I have Mjolnir Runestone equipped. On my spreadsheet I have 6537.13 DPS without ArP procs. Now with the proc, I jump up to 1232 ArP (100.00%) and 7662.78 DPS. The difference between the two is 1125.65. The uptime is calc'd at 19.76%. So 1125.65 * 19.76% = 222.43 DPS increase.

Conversely, If I am sitting at the same 620 ArP and add the current calculation of an average 129.44 ArP with 100% uptime, I will see 6736.50 DPS for a difference of 199.37 * 100% = 199.37 DPS increase. The difference between these two examples is about 23 DPS, but it would vary depending on the specific hunter setup.



Conclusion: I think this model would be more accurate, however I will leave it up to Shandara to figure out whether it's worth the effort to add this into the spreadsheet. I do think though that this would give a much more accurate estimation, especially for those who would go over the cap once the trinket procs.

 

kuronekowai

Bug: Pet debuffs are not stacking properly either (Spore Cloud OR Sting) if Curse of Weakness or Faerie Fire are not checked.

Matter of fact, Faerie Fire is actually DECREASING DPS calculations

 

Shandara

Ok, I've re-uploaded v89d, hopefully fixing this and cleaning up the whole pet armor debuffs a bit.

WotLK Hunter DPS Spreadsheet

 

Kathucka

If the currently equipped weapon does not drop from one of the areas indicated on the gear planner (with the checkmarks), and I hit the "ranged weapons" button, the spreadsheet comes back with funky numbers for the delta of the numbers that do show up.

For example, I'm wearing the Rifle of the Platinum Guard, which drops in Ulduar-10. If I un-check the 10-man box and hit the "Ranged Weapons" button, it fills in a value of 2395.09 for the delta value of the Sen'jin Beakblade Longrifle. Other weapons listed also have bad numbers. It works fine if Ulduar-10 is checked, though.

 

Mondas

I downloaded the spreadsheet today and imported my wife's Hunter (Cianna of Runetotem) and swapped in her new leggings (T8.5). the default gems are 2xDelicate Scarlet Rubies. I swapped one out for a Deadly Monarch Topaz and the dps increased by over 150. That seems excessive to me. Am I missing something?

 

Kathucka

Here's a request: Add two options to simulate re-gemming for hit rating in the gear planner.

The two options are "Equate Hit Rating and Attack Power" and "Equate Hit Rating and Agility".

With this option, the spreadsheet translates the stats on the item in question as follows: Subtract the hit rating on the currently-equipped item from the hit rating on the item being evaluated. If the value is negative (losing hit rating), translate enough points of agility (or attack power), to hit rating to bring the item up to the hit cap. If the value is positive, translate excess hit rating (over the cap) to agility (or attack power).

Then, evaluate the DPS from the item based on the adjusted stats.

Right now, if I manually replace an item on the gear set and re-gem for hit rating, I get a value wildly different from what shows up on the gear planner. Something with hit rating will produce much higher DPS with a re-gem than it shows on the gear planner.

Or, simpler, just provide an option to add DPS for hit rating, even if you're over the cap. In other words, provide an option to ignore the cap when calculating values on the gear planner.

 

Shandara

Probably the meta-gem reactivating?

WotLK Hunter DPS Spreadsheet

 

Mondas

You're absolutely right. Sorry I missed it.

 

Cranch

The SS used to show a big red bar over the gem slot when the meta-gem wasn't activated. That might help the people that miss the "0" in the gem counts.

 

KergeKacsa

Shandra: Is it possible that settings and talents could be exported to/imported from file?
(Now, I need to reset them on every spreadsheet-update.)

 

Shandara

You should be able to export/import from the Overview page. If that doesn't work, you can export the profile on the overview page as well (near the bottom) and copy/paste that into the new sheet and import it (but sure to tick 'export everything' then).

Small update:

WotLK Hunter DPS Spreadsheet

 

Conditioned

Again about best survival: Im wondering why you are using 0/15/56 as the 'best' Survival specc. Both the best dps thread here on ej (Guessing you are already aware of that) and when I put 6/14/51 and change AI to MS I get about 95 more dps than 0/15/56.

 

Shandara

The 'best XX' profiles saved aren't best by any long shot. I just copied them over from an old sheet from the Best DPS thread for testing purposes.

I repeat, they are not my idea of best anything. In fact I'll rename them right away to take away any confusion.

WotLK Hunter DPS Spreadsheet

 

Sukandi

On the Buffs tab, it doesn't have the correct mp5 value for Flask of Pure Mojo with Mixology. It should be 51. (not that it will ever matter)

 

Soliloquy

I've noticed several items with Resilience on them showing up as Haste instead.

This does also apply to the +20 resilience armor enchant.

edit: This is when I import my PvP gear into the spreadsheet, of course.

 

Shandara

This happens when the sheet tries to get the item stats from the Armory?

WotLK Hunter DPS Spreadsheet

 

Soliloquy

Both that or when I manually choose my gear and choose the enchants.

Pick any Resilience Enchant on a chestpiece and select it, then you'll see it shows up as Haste instead. Also several resilience enchants are missing (for example the leg armor). I don't know if this is a priority for you, and I can understand if it's not, but it would be great to have this sorted.

 

Hirgux

Is there any way to simulate/edit uptimes of certain buffs - for example at thorim hardmode I just have ~70% uptime for sniper training, can this be taken into account, when calculating the dps?
And could the spreadsheet show uptimes for example from exposed weakness?

 

Shandara

You can find most uptimes for abilities/procs on the Calculations tab.

WotLK Hunter DPS Spreadsheet

 

Hirgux

And what's with an option to edit the uptime for sniper training for example, to be able to compare certain bosses where you have to move? Possible?

Thanks