I'm completely terrible at math, I just dont have a clue what you were writing in here, would someone just simplified a bit the whole post? which one are our BIS or how is the order then?
Everybody wants everything handed to them on a platter lol
Megarises <Dread> US 16th 11/13 HM
Founder of the "Swag Wagon" channel Korgath's most exclusive chat channel.
Megazordd#1177 Twitch.tv/megazordd
No, its that the math is extremely tricky and not everyone is good at the advanced calculus/trig that it takes to try and figure out the insanity that is Blizz's proc rates.Everybody wants everything handed to them on a platter
Please stop being part of the problem with unhelpful and wrong headed posts like these... the fact is many would like a answer from those that enjoy theorycrafting and math. Putting them down for not being able to find the end answer to a complex puzzle helps no one.
Moderator for Heroes of the Storm
Hotdogs profile
Srey's solo queue tier list and builds
Lastest hero: Alarak, Highlord of the Tal'darim
Next hero: Zarya
Updated with the new goodness (and formulas)!
Enjoy!
---------- Post added 2013-03-14 at 12:09 PM ----------
use the spreadsheet and put in your haste values / stats weights (if you want to change them). You'll be able to see from the sheet which ones will (in a vacuum) give you the most dps.
Moderator for Heroes of the Storm
Hotdogs profile
Srey's solo queue tier list and builds
Lastest hero: Alarak, Highlord of the Tal'darim
Next hero: Zarya
Ditto the appreciation expressed in the post above, Conjor (minus the visit to your home and the awkward pda). Really great work and most helpful in providing a way of approaching a very confusing situation with RPPM and evaluating the trinkets.
How come in your spreadsheet Bottle is more dps than Renataki?
Bottle 2/2 with 40% uptime gives 1234 agility, while Renataki 522 with 20% uptime gives average 1466 agility. Is it because you value expertise more than mastery because there can be trouble with it?
Any cap stats I convert to the second highest valued secondary stat. In this case, I assume the stat priority is Crit > Mastery > Haste. So i treat all the Expertise on it as Mastery.
Bottle = 1574 Agility (3935 Agility * .4 Uptime), 788 Mastery, 525 Crit
Renataki = 1333 Agility (6665 Agility * .2 Uptime), 880 Mastery, 587 Crit
I'll doublecheck the base stats on the trinkets, but we seem to disagree on the average stat gains.
Doesn't Renataki give 7331 average agility for the 522 version?
(1333+2666+3999+5332+6665+7998+9331+10664+11997+13330)/10=7331.6
And about my earlier post, just noticed that I wasn't looking at the HC version of the Bottle, thus my average agility on that one was different from yours. My bad on that one.
Last edited by Noctifer616; 2013-03-14 at 05:57 PM.
Thanks man, I really Appreciate it =)
And if you can PM the translation of it I would appreciate it as well, cuz I really want to know the whole truth inside the calculations, If you have the time and want to do it, I will gladly receive it =), thanks
Last edited by Hiraishin; 2013-03-14 at 06:30 PM.
Thanks for this, I love playing around with these kind of spreadsheets. I'm not good on the math myself but I'm extremely thankful for those that are
I decided to add Normal bottle 2/2 (because I have that monstrosity) and it's at 8369,40 Averaged DPS.
Would you mind explaining the use of the cell Confidence DPS compared to Averaged DPS,and how I should read them?
Also, just to be clear, this basically means, that with 5% haste Relic of Xuen (or Heroic bottle 2/2) and Vicious Talisman will be BiS until heroic trinkets... gg. Unless you can get Thunderforged Renataki's, then it's better than Relic/Bottle.
I also ran some 'goal seeking' tests (no idea if that's the name of it in an english excel), and the following haste levels for normals is needed to surpass Relic;
Bad Juju - 22,67% (10203 rating)
Renataki's - 9,56% (4300 rating)
Rune of Re-Origination - 201% (90176 rating) :P This one is sketchy though, since this ones value also scales with how much mastery/haste you have.
Talisman of Bloodlust - 506,64% (227988 rating) xD As I understood on Conjor this one isn't showing its full potential in the spreadsheet, due to not stacking the proccs, and adding the extra proccs to your haste (for more RPPM goodness).
You use poisson formula for trinkets with ICD, while it should be actually linear, since they can't overwrite the proc.
The only thing not certain, is if the chance starts calculating from when ICD starts or from when ICD ends.
I used some math from here and here and made this spreadsheet, but I'm still not sure how to input "unlucky protection". It will increase average proc rate, since the chance is modified when it starts working.
Old Gods made me do it.