Setting up league tables

[JakkeJakobsen]

Hi! I am setting up league tables for our bowling league. https://docs.google.com/spreadsheets/d/1GOAtCuudsmgxZjgPR9FXxSzzmiN1M2bExwD2QPuQRyM/edit?usp=sharing

That is the link.

Now, on the sheet "Kamper", I got each round with each match going along the rows. That is, row 1 is just saying "Date, round, time, home, away", row 2 is saying "The date, the round, the time, the home team name, the away team name". The next says "Players home, Game 1, Game 2, Game 3, Total per player". Row 4 says "1st player name, game 1 score, game 2 score, game 3 score, total".

You get where I'm going with this. Three matches per round, as there are 6 teams. 10 rounds.

For each team, I want to set up their score on their own sheet, like you can see the team "Rema 1000" is in the "Kamper" sheet, and they got their own sheet with all their opponents listed.

What I would like to get is the score from each match behind each opponent. Their first match was against "Outsiders", and they lost 3-1. I would love to get 3 and 1 in two separate cells in cell B3 on the sheet "Rema 1000", or rather 1 and 3, as it would be their points and the opponents points.

Since the teams never play the same time, team and home/away each time, the formula has to search for the name of the team and find their and their opponents points for the round in "Kamper".

I have done harder things, but I can't wrap around all these =row and =column and =match formulas, I just get stuck lol!

Cheers for all help, the bowling alley and the league players appreciate it, I'm sure! :D

 

[JakkeJakobsen]

Thinking about it, I would love to get all players from the "Kamper" sheet for each team into their respective teams sheet, so that below the list of matches in "Rema 1000", a list of players would be, and it would find their avg score based on how many games they've played.

This because one team can run with 4 players per match (swapping the lowest each game), and you can have unlimited players per team in total.

This so I can build both a team-based and overall list of avg and use this for the total score in the league tables so we can see the avg of each team in total.

 

[JakkeJakobsen]

Bump Would love to get this to go 100% automatically, so I don't have to do anything at all except fill in the "Kamper" sheet with names and game scores.