Pathfinder 2e General Discussion

79 readers

1 users here now

founded 2 years ago

MODERATORS

[email protected]

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

submitted 1 year ago by [email protected] to c/[email protected]

5 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

[–] [email protected] -2 points 1 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.