Ever played without special dice?

[Konyaha]

Is there a system for using just regular d6 die instead of having to buy d20? I'm not sure how it would work, but maybe someone found a way.

??? *clueless*

Thanks for any ideas.

 

[Patryn of Elvenshae]

Pretty much no.

However, you can download, from the internet, any number of dice-rolling programs.

Heck, put the following in Excel and it works, too:

=RAND()*19+1

That gives you a number between 1 and 20. Round it to 0 decimal places, and you've got a virtual d20.

Chance the first number (19, above) to (die size - 1) to change the formula.

 

[Konyaha]

Whoa thanks.

Thing is, I don't always have access to a computer. Maybe i could put it into a scientific calculator...

hmmm.....

*under to do list, writes "find dice roller for calculator"

Later, buddy!

 

[Konyaha]

Haha, whaddya know. I found my calculator does random numbers! Any range you want, too! This oughtta save alot of space

 

[CyberSpyder]

Pretty much no.

However, you can download, from the internet, any number of dice-rolling programs.

Heck, put the following in Excel and it works, too:

=RAND()*19+1

That gives you a number between 1 and 20. Round it to 0 decimal places, and you've got a virtual d20.

Chance the first number (19, above) to (die size - 1) to change the formula.

Ah, that gives a number between 1 and 19. The random number generator never spits out 1.0, so when you round down, you get a maximum of 18+1. You just want RAND()*20 + 1.

This should make sense - twenty sides, so you need to multiply by twenty.

 

[Greylock]

Write the numbers 1 through 20 on little even sized chits. Put them in a Yahtzee cup. Voila', you're good to go.

HTH

 

[Pseudonym]

You just want RAND()*20 + 1.

That will occasionally give you a value of 21, if you set it to 0 decimal places.

 

[Altamont Ravenard]

You could use the RANDBETWEEN(1,20) function, but you have to install the complimentary macros ("Tools" menu, under "Macro").

EDIT: If you need to use the RAND function, you have to use it so:
=TRUNCATE(RAND()*20,0)+1

You'll never get a 21 because RAND() E [0;1[

Konyaha, a set of D&D dice should cost less than 5£... hell, give me your adress and I'll send you a set

AR the Excel Geek.

 

[Patryn of Elvenshae]

Ah, that gives a number between 1 and 19. The random number generator never spits out 1.0, so when you round down, you get a maximum of 18+1. You just want RAND()*20 + 1.

This should make sense - twenty sides, so you need to multiply by twenty.

Not quite.

The RAND function returns a value between 0 and 1.

Multiply that by 19 and you get a value between 0 and 19.

Add 1 and you get a value between 1 and 20.

Round to 0 decimal places (not truncate), and you get a whole number between 1 and 20.

My Excel-fu is strong, and will defeat your Limp Macro Boxing style!

 

[Altamont Ravenard]

Not quite.

The RAND function returns a value between 0 and 1.

Multiply that by 19 and you get a value between 0 and 19.

Add 1 and you get a value between 1 and 20.

Round to 0 decimal places (not truncate), and you get a whole number between 1 and 20.

My Excel-fu is strong, and will defeat your Limp Macro Boxing style!

One problem with rounding: your distribution isn't uniform anymore.

To get a "1", Rand()*19+1 must E [1,1.5[
To get a "2", Rand()*19+1 must E [1.5,2.5[
To get a "3", Rand()*19+1 must E [2.5,3.5[
...
To get a "19", Rand()*19+1 must E [18.5,19.5[
To get a "20", Rand()*19+1 must E [19.5,20[

You'll only have half the normal chances of getting a 1 or a 20...

AR