rainer1966

Dear Roch,
below you will find the link to the table. I hope the table can clarify my points and the results I want (at best). If not, please feel free to contact me.

https://docs.google.com/spreadsheets/d/1e2Hs5kL-KMOYgHqZvMYoD5ES5IWA4SBsCRw-Zfbepl8/edit?usp=sharing

I’m not sure if it’s possible, but WP is based on a database and so I was hoping we could implement a SQL query like “SELECT TOP 6 * FROM xy ORDER BY yz DESC”. Unfortunately, I don’t have the experience or the correct table names to know or verify if this could be a solution. But, if it is not possible, I can do this 1 step manually in a new result table for the 6 highest values.

Many thanks for the detailed answer. A large part of the “requirements” seems to be feasible. I have looked at the link https://www.themeboy.com/blog/creating-automatic-custom-scoring-system-sport/, but unfortunately must admit that even the beginning to implement this fails. This e.b: because here always 2 teams compete against each other and at the end then a winner is determined. Who has the most wins at the end of the season.
With my construct, however, it looks a little different. Here not 2 teams fight, but each for himself. Whoever has shot the most rings wins the victory in the current month.At the end of the season (end of the year) the shooter who has shot the highest sum of the shot rings with his 6 best attempts wins.

Maybe it will help me to understand the system better if I reproduce the example once and see what happens.

Below are my considerations for the first view of the data:

1. Teams – I’ll create two teams for now, called Gryffindor and Slytherin. I’ll add more later.
   Here I would create Team for all Groups (Kompanien) von denen Mitglieder mitschießen.
2. Players – Quidditch needs seven players on each team so I’ll add them and others later on.
   Shooters of the different groups. The number of shooters within the groups is different.
3. Season – I’ll create one season to start and go from there as my website and user-base grows.
   I´ll plan for 1 season first too, but results for old season to check are available
4. Tournament – I don’t need a tournament running yet.
   not needed yet, but if it works and I understand it 😊 it will be an option too
5. leagues – I’ll add one leaugue for now, called Hogwarts.
   I plan two Leagues ( Men and Women)
6. Event Results – In Quidditch, goals are counted as well as the snitch when it’s caught so I’ll add both.
   ???
7. Player Performance – Similarly, I’ll add goals and the snitch here as well since that’s what I want calculated for the event outcomes.
   Here the sum of the shot rings is decisive
8. Table Columns – I’ll add wins, losses, goals for the home team, goals against the home team and the number of snitches caught by only the players in the seeker position since they’re the only ones that can catch them.
   Shot ring count per month / event in the season
9. Player Statistics – I’m going to add both win and loss ratios so they can be displayed on my website for each player.
   Total rings shot, number of events to reach the total, average value two decimal places (total rings divided by event count).
10. Sponsors – I only need one sponsor to start, the Honeydukes candy shop.
    Also here I plan first a sponsor, the landlord with the restaurant, with which we use the shooting range

Rainer