Any Excel users know of a formula to generate a list of dN numbers? (lemmy.world)

submitted 1 year ago by Drunemeton@lemmy.world to c/pf2general@pathfinder.social

3 comments fedilink hide all child comments

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 are viewing a single comment's thread
view the rest of the comments

[-] Riven@sh.itjust.works 3 points 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 points 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.

this post was submitted on 27 Aug 2023

8 points (100.0% liked)

Pathfinder 2e General Discussion

2 readers

1 users here now

founded 1 year ago

MODERATORS

SenseiRat@pathfinder.social