Printable Version of Topic

Posted by: cndblank Oct 13 2009, 02:13 PM

Thanks

Posted by: TBRMInsanity Oct 13 2009, 02:33 PM

Your easiest solution would be to use your favourite spreadsheet program (mine is IBM Lotus Symphony Spreadsheet, but this also works in OpenOffice Spreadsheet, and Microsoft Excel) and fill each cell with the following formula:

=randbetween(1,6)

Replicate to your hearts desire.

Posted by: DamienKnight Oct 13 2009, 07:27 PM

cndBlank, If your needs are more specific than this, tell us more and we may be able to help.

Do you have Microsoft Excel or are you an Open Office user? There are Dice Roller Macros in the SR4CG_DK sheet which are usable in excel, and use modular functions that could be used by other Macros to accomplish most any kind of dice rolling...

Elaborate and one of us Geeks will figure it out for you, or find a program or sheet where someone else already has.

Posted by: cndblank Oct 14 2009, 05:07 PM

Either open office or Excel 97.

Perhaps having a numbered column at the top so you can count off however many you need and having the five and sixes bolded.

And Thank you very much.

Posted by: DamienKnight Oct 14 2009, 07:49 PM

Try this little excel sheet out.

http://www.mediafire.com/file/zd4tmz4mmlz/rolld6_test1.zip

If you get ?NAME errors, try the following steps in Excel:

1. On the Tools menu, click Add-Ins.
2. In the Add-Ins available list, select the Analysis ToolPak box, and then click OK.
3. If necessary, follow the instructions in the setup program.

http://excel.tips.net/Pages/T002874_Picking_Different_Random_Numbers_from_a_Range.html

A note on calculation refreshing in excel:

A refresh happens Automatically/Manually/Before Save based on your settings in Tools->Options->Calculation

If it is set to Manually, you have to tell the sheet when the recalculate. If it is automatic, EVERY TIME you enter any data, all cells will refreshed. This means if you are entering in numbers and see a result you want to keep, the instant you enter in a new number all of the RANDBETWEEN functions will recalculate all all results will change.

http://www.mediafire.com/file/3mnn1irimnh/rolld6_test2.zip In excel 2003 you press F9 to manually refresh.

Posted by: Kagetenshi Oct 14 2009, 08:02 PM

Your actual easiest solution is to use something like Python. Something like:

from random import randint
print [randint(1,6) for x in range(10000)]

Adjust numbers as desired.

Also, end spreadsheet abuse.

~J

Posted by: Blackb1rd Nov 10 2009, 03:55 AM

This is what i use when my actual d6 block isn;t handy:

http://daegann.free.fr/page.php?id=240

Has options of opposed and extended tests, takes into account the rule of six, re-roll non hits when edged.... etecetera...
it's a good little program.