I want to implement a very simple random number generator in Google Sheets to play DnD with my friends. There is a built in, but the problem is that it does not take a seed, and every time we roll it each person sees a different result.
I want an example of a simple, non-recursive, with non-overflowing intermediate results function that I can easily implement using Google Sheets so that I can feed it an integer input and return a random output in the range of 1 to 6.
It does not have to be foolproof, just random enough to withstand casual scrutiny and be equally likely to generate all possible outcomes for the first 200 rolls or so