Comment on Any Excel users know of a formula to generate a list of dN numbers?
Riven@sh.itjust.works 1 year ago
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
Echinoderm@aussie.zone 1 year ago
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.