How to show all possible ordered outcomes of 4 dice

Question

I'm working on a project that requires I add a unique result for each and every possible ordered outcome of a roll of $4$ dice at one time. I'm stuck on how to show this in Excel or Google Sheets. Any ideas? Really appreciate it.

Answer 1

Use the following formulas:

$$n\bmod6+1,\\\left\lfloor\frac n6\right\rfloor\bmod6+1,\\\left\lfloor\frac n{36}\right\rfloor\bmod6+1,\\\left\lfloor\frac n{216}\right\rfloor\bmod6+1$$ for $n$ from $0$ to $1295$. They give you the four dice.