IPB

Welcome Guest ( Log In | Register )

 
Reply to this topicStart new topic
> Anyone know of a good program to pre roll dice?, Need a sheet full of d6 rolls
cndblank
post Oct 13 2009, 02:13 PM
Post #1


Running Target
***

Group: Members
Posts: 1,210
Joined: 5-September 05
From: Texas
Member No.: 7,685



Thanks
Go to the top of the page
 
+Quote Post
TBRMInsanity
post Oct 13 2009, 02:33 PM
Post #2


Running Target
***

Group: Members
Posts: 1,002
Joined: 22-April 06
From: Canada
Member No.: 8,494



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.
Go to the top of the page
 
+Quote Post
DamienKnight
post Oct 13 2009, 07:27 PM
Post #3


Moving Target
**

Group: Members
Posts: 943
Joined: 24-January 04
From: MO
Member No.: 6,014



QUOTE (TBRMInsanity @ Oct 13 2009, 09:33 AM) *
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.


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.
Go to the top of the page
 
+Quote Post
cndblank
post Oct 14 2009, 05:07 PM
Post #4


Running Target
***

Group: Members
Posts: 1,210
Joined: 5-September 05
From: Texas
Member No.: 7,685



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.
Go to the top of the page
 
+Quote Post
DamienKnight
post Oct 14 2009, 07:49 PM
Post #5


Moving Target
**

Group: Members
Posts: 943
Joined: 24-January 04
From: MO
Member No.: 6,014



QUOTE (cndblank @ Oct 14 2009, 12: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.


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.

According to excel.tips.net the RANDBETWEEN function should work with excel 97.

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.

See this alternate version, with Calculation refresh set to Manual. In excel 2003 you press F9 to manually refresh.
Go to the top of the page
 
+Quote Post
Kagetenshi
post Oct 14 2009, 08:02 PM
Post #6


Manus Celer Dei
**********

Group: Dumpshocked
Posts: 17,006
Joined: 30-December 02
From: Boston
Member No.: 3,802



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
Go to the top of the page
 
+Quote Post
Blackb1rd
post Nov 10 2009, 03:55 AM
Post #7


Moving Target
**

Group: Members
Posts: 122
Joined: 28-October 09
From: West Point, New York
Member No.: 17,805



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. (IMG:style_emoticons/default/wobble.gif)
Go to the top of the page
 
+Quote Post

Reply to this topicStart new topic

 



RSS Lo-Fi Version Time is now: 26th November 2024 - 05:23 AM

Topps, Inc has sole ownership of the names, logo, artwork, marks, photographs, sounds, audio, video and/or any proprietary material used in connection with the game Shadowrun. Topps, Inc has granted permission to the Dumpshock Forums to use such names, logos, artwork, marks and/or any proprietary materials for promotional and informational purposes on its website but does not endorse, and is not affiliated with the Dumpshock Forums in any official capacity whatsoever.