Any Excel users know of a formula to generate a list of dN numbers?
Any Excel users know of a formula to generate a list of dN numbers?
To save time running a game I thought it might be handy to have a pre-generated list of die rolls to use during encounters. A spreadsheet like Excel seems to be an ideal place to do this, but my knowledge of this type of app is sorely lacking in just how to do this.
You're viewing a single thread.
If you put the die type along the top row (just the numbers, no d) and this in A2 it should do what you want.
=RANDBETWEEN(1,A$1)
You can copy the cell without editing the formula and fill as much of the sheet as you want. Press F9 to reroll.
If you prefer a percentile die with zero, you can change it to
=RANDBETWEEN(0,9)*10
Or just combine the 2 dice as a single d100
This is basically what I do as well.
One thing I find useful is to list your party's Perception modifiers, use the formula above for a random d20 result for each PC, then add them together (for example, =B2+C2). Then when they walk into a room, hit F9 for an instant whole-party secret Perception roll.