Practical: Roll a D20 with Google Sheets
Generate those Random Numbers!
(Link to example spreadsheet )
If you saw either of my posts about Random Variables or the Uniform Distribution, you might be wondering how you can start creating RNG for yourself in Google Sheets.
So let’s gooooooo!
In Google Sheets, you can simulate the outcome of a D6 die with
=RANDBETWEEN(1,6)
or you can simulate the outcome of a D20 with
=RANDBETWEEN(1,20)
just as easily.
You also don’t restrict yourself to dice, you can generate a number between 60 and 100 if you want to generate some damage output based on a sword hit
=RANDBETWEEN(60,100)
Try it for yourself!