This is a complex problem to solve. I have been trying to prompt Gemini(AI) and Grok(AI) to produce SQL queries. The results are many CTE and windowed results. I don't think this can be done with excel (or google sheets) easily. At the start of the week there could be thousands of possible outcomes. I ran one query that Gemini(AI) came up with on a 22 person pool with 4 games remaining in the week and it took 20 minutes to return the results. Not saying the code is optimized, but damn that's a long time to wait for something rather trivial for a human to "observe" fairly quickly.

If anyone comes up with a solution for SQL query please let me know.