this post was submitted on 02 Apr 2024
36 points (100.0% liked)
Tabletop Gaming
1327 readers
1 users here now
All things relating to and about tabletop gaming and board gaming generally!
See also Tabletop Gaming's sister community Gaming.
This community's icon was made by Aaron Schneider, under the CC-BY-NC-SA 4.0 license.
founded 1 year ago
MODERATORS
you are viewing a single comment's thread
view the rest of the comments
view the rest of the comments
I looked at the results of each roll and then entered it directly into a spreadsheet
The stat cards are generated straight from the data
Using some formulas in the spreadsheet I tell it to see which numbers come up in a range of cells, then count each instance of the numbers, then order the results in a table from most common to least common.
The averages are generated in a similar way. Basically I tell the spreadsheet to add the number of cells that have data in them in a specific range together, then have it divide by the number of faces on the die (the magic number here bugs me but I'll let it slide for now), and then it puts the result into a cell.