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.

  • Riven@sh.itjust.works
    link
    fedilink
    arrow-up
    3
    ·
    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
      link
      fedilink
      English
      arrow-up
      1
      ·
      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.