Sheet of d20 rolls

[rusty2667]

I'm looking for a way to print up full sheets of d20 rolls without actually having to roll the dice.

Is there something out there that will help me this?

 

[Stormonu]

excel sheet with the formula "=INT(RAND()*20)+1" copied down the page ought to do it.

 

[rusty2667]

thanks!

 

[dm4hire]

Oddly enough, I was trying to figure this out the other day. Though I'm wanting to do more than d20 rolls.

 

[noffham]

Simple, just replace the "20" in the above formula with whatever size die you want rolled.

 

[Stormonu]

Here's an advanced trick, if you want different dice:

in cell A1, put the die type you want.

copy the following formula down the rest of the sheet:

"=INT(RAND()*$A$1)+1"

Now, if you want to change the die type, you just have to enter a new number in cell A1 and refresh the sheet. You can even make multiple columns and they'll still use the contents in the A1 cell.

 

[IronWolf]

Stormonu's Excel tricks are excellent.

You can also use Invisible Castle to roll whatever dice you want and then copy and paste the results into a document for later use.