Probability of outcome, given percentages, multiple scenarios

Hello All,
Not even sure if Excel can do this.. See attached
My friends and I have a competitive golf tournament each year. 2 Teams, 8 players each team.
Long story short, before the last competition Team A is up 14 points. (25-11 after Day 3) The last day there are a total of 24 points remaining. Total tournament 60 Points, 30.5 to win
There are 8 matches with 3 points awarded each match. Half points are possible, so you can score anywhere from 0.5 points to the full 3.0 points
I have put together the list of players and their probability of winning the match against the other players on the team.
For Example, The #1 seed on Team A playing the #8 seed on Team B would have a 99.99% chance of winning the full 3 points.

The first question I have is if there is a way in excel to run this probability that if Team A is up 14 points with 24 points remaining, what would be the likelihood of victory? A simulation of say 1000 Day 4 Outcomes, what would Team A's probability of victory be, needing only 5.5 of the 24 points?

The next question would be, the matchups are selected like so: Team B sends out first player for Match 1, Team A sends out opponent for Match 1. Team A then sends out player for Match 2, Team B sends out opponent for Match 2... so on until 8 Matches are set.
In this scenario is it possible, that Team A while up 14 points and needing 5.5 out of the 24 possible points to win, could all but guarantee winning by creating match-ups that would be highest probability of victory?
Team B is losing so they have to send out first golfer...Their best chance would be to have each match have 50% odds to get as many points as possible.
So Team B sends out #6 Seed, BUT Team A could send out #2 seed- Team A would have a 99.99% chance of winning 3 points.
Team A then sends out #5 Seed, Team B sends out #5 seed- Both teams have 50% chance of winning 3 points.
Team B then sends out #7 Seed, Team A sends out #4 seed- Team A would have 99.99% chance of winning 3 points.
This would give team A a high probability of winning atleast 3 points in two of those matches and winning the tournament
Instead of #1vs#1,#2vs#2...., each match having ~50% chance of winning 3 points.

Any sort of direction on this would be greatly appreciated!

Are you still using Excel 2010? If not, please update your profile.

There are instructions at the top of the page explaining how to attach your sample workbook.

Short but useless answer -- yes, there are ways of running this sort of thing in Excel. I'm not aware of anything pre-programmed, but, if you can help us understand the algorithm/procedure you want to use to perform this analysis, we should be able to help you program that algorithm/procedure into Excel.

You mention a "simulation", which suggests to me using a Monte Carlo type of algorithm. I put together a quick example here (https://www.excelforum.com/tips-and-...l-problem.html ). Basically, I see three parts to building this kind of simulation:

1) Come up with an algorithm/procedure for calculating the result of one scenario/match/game/combination. Enter that sequence of calculations so that it fits into a single row in the spreadsheet.
2) If you do part 1 well, calculating the result of multiple scenarios is as simple as making copies of that row.
3) After making multiple copies of the simulation row, analyze the results of all the simulations to estimate probabilities of outcomes.

Often, part 1 is the hardest part. It's not clear to me from your description exactly what a single simulation would look like. In any case, that's an overview of how I would approach this, if I decided I wanted to use a Monte Carlo simulation type of algorithm for this problem.

I know there aren't many specifics there, but does that help at all?