Histogram, and other math.

Post/Author/DateTimePost
#1

Klaumbaz

Aug 12, 2014 23:02:00

I got bored, and made a histogram for both advantage and disadvantage. So those better at math can use it to work on hit/miss percentages, etc. it seems some theory crafters are scared to incorporate it. you can use a hlookup function to add the values together to get your hit/miss percentage off it.

 

Things to note i haven't seen others using in their math...with advantage, on a 20 crit chance is 9.75%, it goes to 19% on a 19.

 

I also got bored, and projected hit/miss percentages based on histogram. but then it got complicated to figure DPS per round. so i used the greataxe fighter and the rogue from the starter set beating on each other, and did craploads of simulations to see if the projected worked out. I have it doing 4000 attacks on each other to get values. figured it was enough.

 

If i protected/unprotected it right, you should be able to change to hit, AC, and weapon damage values.

 

But using the AC and attack values given, assuming the rogue always has advantage and thus sneak on every attack, and only 1 shortsword. compared to the fighter without advantage, it would be an interesting fight. If the fighter reliably gets advantage, the rogue is toast.

 

If you want to bash it, go elsewhere, if you have suggestions, let me know. I built it in excel first, then uploaded to google sheets, i had to fix some things, might have missed something.