Basic dice calculator tool

Guide / How-to

I've created a simple tool in Google Sheets - you just input a number of dice (one type or several) and modifiers if applicable and it'll give you the average outcome along with the min, max and range. It doesn't do any wild calculations people couldn't do otherwise but hopefully it'll be handy for working out expected damage outputs or comparing dice against one another.

Given that rolling more dice means that the result is more likely to be closer to the average, I think this could be helpful in a range of situations, for example:
The DM wants the players to roll for loot but wants to minimise the chances of them getting a particularly high or low number. Instead of, say, 5d20, you could input that and check the average (52) and find another option that's more predictable like 11d8 (ave 49) +3.
The DM wants to minimise the risk of an NPC attack doing an excessive or pointless amount of damage. 2d12+1 (ave 14) could be replaced with 4d6 (ave 14) or 2d8+5 (ave 9,+5). In the d8 case we're using a mod rather than extra dice to increase predictability.

Please let me know if you find this useful, you think it could be improved, or you spot an error. I'm also planning on creating a much more developed version which uses probabilities to provide more information/guidance, which should still be straightforward to use and understand without any stats/probability knowledge so I'd like to know if that's something people would be interested in.

Thanks, enjoy, and sorry for rambling.

Link: https://docs.google.com/spreadsheets/d/1VwtiqzYQpoFIvdntQySsQZtQOEvqxrv4Csn0oCUWWuA/edit?usp=sharing

Posted Sep 9, 2020, 10:03 PM UTC

02
Splicex42•

We also have Anydice: https://anydice.com Maybe you can see where the limits are and expand on this?

1
TefticlesOP•

Yeah my intention is to use that type of data but instead of returning a bunch of probabilities that need interpreting it'd give certain characteristics, essentially tailoring the results to what a DM might want.
And also for the more in-depth version to have the ability to search for a mean and get a list of results that are close to it and a maybe a 50% confidence range on them.
But perhaps I'm just trying to fill a niche that isn't there!

1