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
    link
    fedilink
    31 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

    • DrunemetonOP
      link
      English
      11 year ago

      Oh that works even better since there’s no “21” showing up! Thank you.

      Does PF2E even use percentile dice? LOL

      • Riven
        link
        fedilink
        21 year ago

        Does PF2E even use percentile dice?

        …huh. I guess not. Somehow I never noticed that before.

    • @[email protected]
      link
      fedilink
      English
      11 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.

  • ma11en
    link
    21 year ago

    In Cell A1 type your Die number

    In Cell A2 type =(RAND()*$A$1)+1

    Drag A2 down as many lines as you need

    • DrunemetonOP
      link
      English
      11 year ago

      Thank you, that works!

      However I’m getting “21” on a “20” Die Number but I think I’ll just treat those as 20’s. (GM wink)

  • Uprise42
    link
    fedilink
    -21 year ago

    I’m not sure about a formula but you can use Visual Basic to make a random number generator for a bunch of rolls and place those values in an array and then place the array in the appropriate cells.

    I can’t tell you exactly how to do
    This as I haven’t used excel or Visual Basic in a while and never actually linked them together myself. I don’t know if you can even do it for free as I think visual studio costs money, though that may show how long I’ve been away from that side.

    I can say you can also do the same as what I describe above using Google Sheets and App Scripts in probably 20 lines of code. I am more fluent with those and I think it would be pretty easy even if you don’t know how to code.