| View previous topic :: View next topic |
| Author |
Message |
MacRauri
Ensign
Joined: 26 Nov 2011
Posts: 47
Location: Twin Cities MN
|
 Posted: Thu Jan 12, 2012 8:18 pm Post subject: d6 probability spreadsheets |
 |
|
I enjoy the crazy storytelling a cinematic action the d6 system allows, but I'm also interested in its mechanical structure and the probability distributions it creates. Problem was the wild die made it mathematically inapproachable for the longest time. Surfing around I found "Da Bum's" spreadsheet and graphs. Great stuff.
http://www.daemonstorm.com/role-playing/d6-system/D6-Probabilities-with-the-Wild-Die
I used his experimental cumulative probabilities to create my own spreadsheet that has probabilities of rolling higher, and higher by 4+, 9+, 13+ and 16+ for various amounts of dice. I wanted to know the likelihood of beating an opponent's dodge and the likelihoods of getting them to a certain wound level.
I haven't seen any tool like this available and would like to make my document available to the community. Problem is I don't have a FileShare and the spreadsheet is in Numbers (sorry). If there's interest please PM me. |
|
| Back to top |
|
 |
S-Foil
Sub-Lieutenant
Joined: 21 Feb 2011
Posts: 70
|
| Posted: Fri Jan 13, 2012 2:17 am Post subject: |
|
|
What synchronicity, I wrote a similar perl script before Christmas to do something very similar. I'm attempting to roll a very simplistic combat simulation to compare two characters based on their skill and equipment. I'm calculating the average number of turns needed for a character to incapacitate a Stormtrooper (or get incapacitated themselves).
If I ever finish it I'll post the results because I've found my preliminary numbers heavily affected by the presence of the Wild Die. |
|
| Back to top |
|
|
Fallon Kell
Commodore
Joined: 07 Mar 2011
Posts: 1846
Location: Tacoma, WA
|
| Posted: Fri Jan 13, 2012 2:46 am Post subject: |
|
|
Thank you for the powerful maths! I will be able to make great use of this!
_________________
Or that excessively long "Noooooooooo" was the Whining Side of the Force leaving him. - Dustflier
Complete Starship Construction System |
|
| Back to top |
|
|
Bren
Vice Admiral
Joined: 19 Aug 2010
Posts: 3868
Location: Maryland, USA
|
| Posted: Fri Jan 13, 2012 2:28 pm Post subject: Re: d6 probability spreadsheets |
|
|
| Cool stuff. 8) I think your spreadsheets might make a good addition to the D6 magazine as a follow on to the article they had in Issue #1 on probabilities for D6. |
|
| Back to top |
|
|
Barrataria
Commander
Joined: 28 Dec 2005
Posts: 295
Location: Republic of California
|
| Posted: Tue Oct 23, 2012 5:26 pm Post subject: Re: d6 probability spreadsheets |
|
|
| MacRauri wrote: |
I haven't seen any tool like this available and would like to make my document available to the community. Problem is I don't have a FileShare and the spreadsheet is in Numbers (sorry). If there's interest please PM me. |
I was looking for just such a thing, and I have looked an enjoyed greatly. Thanks for sharing it.
A dumb question though... why does the chart, for instance, say that there's only a 94% probability when rolling 3D to get a 2? Does this assume the wild die comes up one and is ignored? Sorry if this is a stupid question.
_________________
"A special effect without a story is a pretty boring thing"- George Lucas |
|
| Back to top |
|
|
atgxtg
Rear Admiral
Joined: 22 Mar 2009
Posts: 2460
|
| Posted: Sat Nov 03, 2012 9:42 pm Post subject: |
|
|
Has anybody noticed that the table is off?
For instance, according to the table the odds of rolling a 5+ on 1D is the same as rolling 6+ (33.31% according tot he table). That's not right!
The chance of rolling 5+ on 1D (wild die) is 33.33% (close enough to 33.31%), but the chance of rolling 6+ is 16.67% not 33.31%. And the chance of roll 7+ should be the same as rolling 6+ since you reroll the 6 on the wild die. |
|
| Back to top |
|
|
cheshire
Arbiter-General (Moderator)
Joined: 04 Jan 2004
Posts: 4849
|
| Posted: Sat Nov 03, 2012 10:32 pm Post subject: Re: d6 probability spreadsheets |
|
|
| Barrataria wrote: | | MacRauri wrote: |
I haven't seen any tool like this available and would like to make my document available to the community. Problem is I don't have a FileShare and the spreadsheet is in Numbers (sorry). If there's interest please PM me. |
I was looking for just such a thing, and I have looked an enjoyed greatly. Thanks for sharing it.
A dumb question though... why does the chart, for instance, say that there's only a 94% probability when rolling 3D to get a 2? Does this assume the wild die comes up one and is ignored? Sorry if this is a stupid question. |
IIRC The author of the charts was using a 2nd ed, not an R&E rule set. In this rule set if you role a 1, you roll the wild die again to see what happens. Therefore, the probability of getting less than 3 is reduced.
_________________
__________________________________
Before we take any of this too seriously, just remember that in the middle episode a little rubber puppet moves a spaceship with his mind. |
|
| Back to top |
|
|
Barrataria
Commander
Joined: 28 Dec 2005
Posts: 295
Location: Republic of California
|
| Posted: Mon Nov 12, 2012 4:33 pm Post subject: |
|
|
| atgxtg wrote: | Has anybody noticed that the table is off?
For instance, according to the table the odds of rolling a 5+ on 1D is the same as rolling 6+ (33.31% according tot he table). That's not right!
The chance of rolling 5+ on 1D (wild die) is 33.33% (close enough to 33.31%), but the chance of rolling 6+ is 16.67% not 33.31%. And the chance of roll 7+ should be the same as rolling 6+ since you reroll the 6 on the wild die. |
Yes, I stopped working with this as I didn't understand the math underlying it.
And thanks cheshire for your response. I've never used R&E so I've always assumed the mechanics are the same.
_________________
"A special effect without a story is a pretty boring thing"- George Lucas |
|
| Back to top |
|
|
|
