Originally Posted by Aldriana
Spreadsheet is a bit off because the trinket has a max of 20 stacks - hence the "# of consecutive misses" should cap out after 20 noncrits in a row, which will drop the value of the trinket ever so slightly.
|
Yep I wrote a simulator to just perform 100,000,000 swings with every crit %, applying the Wrath mechanics, and count the number of crits. From 11% upwards, my numbers are virtually identical to yours. Below that your numbers are higher, presumably due to this 20 stack max.
Edit: hmm, just noticed, you fixed it in your sheet. Not sure what's causing it then. Here's the differences between my numbers and yours..
Base Mine Yours
00% 6.584% 6.86%
01% 6.227% 6.44%
02% 5.889% 6.06%
03% 5.575% 5.70%
04% 5.280% 5.37%
05% 4.998% 5.07%
06% 4.739% 4.79%
07% 4.491% 4.53%
08% 4.265% 4.29%
09% 4.045% 4.07%
10% 3.844% 3.86%
11% 3.660% 3.67%
12% 3.475% 3.49%
13% 3.313% 3.32%
14% 3.157% 3.16%
15% 3.006% 3.01%
16% 2.871% 2.87%
17% 2.739% 2.74%
18% 2.618% 2.61%
19% 2.495% 2.50%
20% 2.384% 2.39%
..and then they carry on being almost identical all the way to 100%.