Author Topic: [Resource] Shadowrun 5 Probability Tables (Excel)  (Read 2699 times)

Darzil

  • Omae
  • ***
  • Posts: 636
Based on this lovely Shadowrun 4th Edition probability table I whipped up some for Shadowrun 5th. Basic differences are glitch being more than half the dice being 1's, rather than half or more, and going up to 22 dice rather than 15. (though probably a lower number of simulations, as I used Excel, so only 65536 rolls of up to 22 dice.

Added columns for the limit needed to not waste hits 95% of the time, 75% of the time and 50% of the time. (As I play a decker, I can adjust the limits quite a bit during play, so this may prove handy)

Added a table for chance of success based on number of dice rolled by attacker and defender, where defender needs one net hit.

http://www.northshield.co.uk/Shadowrun/Shadowrun5ProbabilityTable.xls

Darzil

  • Omae
  • ***
  • Posts: 636
Re: [Resource] Shadowrun 5 Probability Tables (Excel)
« Reply #1 on: (06:52:49/01-25-15) »
Update - Can now specify a limit on the table that gives chance of success on attacker vs defender.

Edit - And now it actually works, too!
Edit 2 - Added chance of 2 net hits and 3 net hits by attacker vs defender
Edit 3 - Because it bugged me, now uses calculations, not simulation, doesn't change much.
« Last Edit: (05:05:49/01-26-15) by Darzil »

Zweiblumen

  • Ace Runner
  • ****
  • Posts: 1802
Re: [Resource] Shadowrun 5 Probability Tables (Excel)
« Reply #2 on: (14:37:54/01-28-15) »
I get a 404 error when following that link :(  Any chance you can make it a google document?
Speech, Thoughts, Comm/Text, Subvocal
Mams

Darzil

  • Omae
  • ***
  • Posts: 636
Re: [Resource] Shadowrun 5 Probability Tables (Excel)
« Reply #3 on: (17:32:24/01-28-15) »
Sorted the 404 error. Will see if I have a google account and if google docs can support all the functions. I like people to be able to see the calculations rather than just trust me!

Edit - I should get there, but ye gods it's slow !
Edit 2 - Can anyone advise on how to protect a sheet in google docs? The sheet is far less useful if you can't select a limit, but when I protect all except that cell from editing if I share as editable to public I can still edit everything else when I am not logged in! Surely there is a half way between all editable and none?
« Last Edit: (17:52:21/01-28-15) by Darzil »

ScytheKnight

  • Ace Runner
  • ****
  • Posts: 1913
Re: [Resource] Shadowrun 5 Probability Tables (Excel)
« Reply #4 on: (17:41:05/01-28-15) »
Google Sheets supports Excel style functions and displays them
From To<<Matrix message>>
"Speech"
Thoughts
Astral
Mentor

Darzil

  • Omae
  • ***
  • Posts: 636
Re: [Resource] Shadowrun 5 Probability Tables (Excel)
« Reply #5 on: (17:55:31/01-28-15) »
Google Sheets supports Excel style functions and displays them
Fortunately I built this without my Matrix spreadsheet's heavy reliance on VBA, so should work.

If I can just work out a way to allow people to see the code, but not edit anything other than the limit box. Not having any luck with public having edit access and the whole sheet being set to protected except the limit box. Me as anonymous can still edit everything.

catrone3

  • Newb
  • *
  • Posts: 9
Re: [Resource] Shadowrun 5 Probability Tables (Excel)
« Reply #6 on: (00:28:17/10-09-16) »
it looks like your probabilites are off once you get to 3 dice being rolled on critical glitches and right away on successes. the equation should be (dice goal^number wanted)x(dice fails^(wanted-total))x(total choose wanted).

for example the probability of getting 2 success on 3 dice would be ((2/6)^2)x((4/6)^1)x(3choose2)
this comes out to being 8.64%

you can run this in wolframalpha if you wish to check it.

((2/6)^x)*((4/6)^(y-x))*(ychoosex)
you can replace x and y with what ever you want for successes and dice rolled. for critical glitch it would be 1/6 and 3/6 due to not wanting any 5s or 6s. a glitch would be 1/6 and 5/6

 

Register