Tried using Chat GPT to help me but it didn't help enough. I came on here once before with a complicated question and the community was amazing so i'm upping the ante 
This is what i'm trying to do. I run a tennis doubles league with 4 teams of 12 players each. It runs for 16 weeks. Each week, 8 players get chosen by a captain to play so not every player will play the same number of weeks over the 16 weeks.
Each week 4 matches are played between 2 teams. No player can play in more than one match per night.
I want to track the player results from each of their matches (both teammates will obviously have the same results from the match. I want a weekly updated player ranking system of all 48 players that takes into account the results from the matches they have played so far as a weighted avg since not all players will play the same number of weeks over the course of the season.
I want some kind of strength of opposition modifier so that on a given week if one team is up against another team that has a higher average ranking than them
(want the ranking of the team to be the average of both teammates player ranking) they get the strength of modifier point result if the lower ranked team wins. The player ranking result should be based on something like 3 pts for a win, 1 for a loss, 1.5pts for a straight sets win, 0.5 pts for a comeback win and the points should be calculated by adding up all the points for win and any bonus points and then using that total plus the strength of opposition modifier (if applicable) to calculate the player point total for each of the players that played in the match
For team points, 4 are available per night (1 point for each match win your team has) and then add on the average of the player point totals for the night from your 8 players that participated
Is this possible and if so please help.
This is what i'm trying to do. I run a tennis doubles league with 4 teams of 12 players each. It runs for 16 weeks. Each week, 8 players get chosen by a captain to play so not every player will play the same number of weeks over the 16 weeks.
Each week 4 matches are played between 2 teams. No player can play in more than one match per night.
I want to track the player results from each of their matches (both teammates will obviously have the same results from the match. I want a weekly updated player ranking system of all 48 players that takes into account the results from the matches they have played so far as a weighted avg since not all players will play the same number of weeks over the course of the season.
I want some kind of strength of opposition modifier so that on a given week if one team is up against another team that has a higher average ranking than them
(want the ranking of the team to be the average of both teammates player ranking) they get the strength of modifier point result if the lower ranked team wins. The player ranking result should be based on something like 3 pts for a win, 1 for a loss, 1.5pts for a straight sets win, 0.5 pts for a comeback win and the points should be calculated by adding up all the points for win and any bonus points and then using that total plus the strength of opposition modifier (if applicable) to calculate the player point total for each of the players that played in the match
For team points, 4 are available per night (1 point for each match win your team has) and then add on the average of the player point totals for the night from your 8 players that participated
Is this possible and if so please help.
