Jeremy explores the probabilities of shooting. The spreadsheet is available here: https://drive.google.com/open?id=0Bz2nymfnpBm-ZUZqSEJ4TldObFE