Extract TOP 3 players for each team from a data sheet
Budget: €30 – €250 EUR
Hello everyone,
What I need is something that can help me to make some statistics through a big database.
As you will see enclosed, I’ve put a sample of the data I have for one season. But I have 10 seasons for 30 countries.
You will see that for each soccer games, I have details of the games (Country, Season, Date, Home Team, Away Team, Round, Scores and Players of the games).
I need to make some data with specifics details of the games :
- notes
- golas
- assists
So, I would like to extract the Top 3 players of each team by :
- notes
- golas
- assists
These Top 3, will be calculated with the data of the last games since the beginning of the season.
It means that, for example, if you are looking the first game of the round 4 (line 813) : Guingamp vs Olympique de Marseille, I would like to know the players of the top 3 for Guingamp and Olympique de Marseille for the goals, the assists and the notes, thanks to the data of their games 1, 2 and 3 of the season 15/16.
Another example, If you are looking for the first game of the round 17 (line 4355 - OGC Nice vs PSG), you will do the same but with the data of their games from the round 1 to the round 16 of the season 15/16.
The Top 3 would be extract in the 2nd sheet « Top 3 » in the adapted column, as you will see on the sample (from column I to AT).
Then, in the column after each Top 3 players name, I just need to get the information (Yes or NO), if the player has played in the next game.
So still in the same example of line 813 with Guingamp vs Olympique de Marseille for the round 4, I have to check if one of the players in the Top 3 (for notes, goals and assists - remember the data has been extracted with the data of the games 1, 2, and 3) have played in the game 4.
And you can check the data thanks to the players names from the line 813 to 839.
Hope my brief is clear for you.
If not don’t hesitate to reach me.
Best
Christophe
What I need is something that can help me to make some statistics through a big database.
As you will see enclosed, I’ve put a sample of the data I have for one season. But I have 10 seasons for 30 countries.
You will see that for each soccer games, I have details of the games (Country, Season, Date, Home Team, Away Team, Round, Scores and Players of the games).
I need to make some data with specifics details of the games :
- notes
- golas
- assists
So, I would like to extract the Top 3 players of each team by :
- notes
- golas
- assists
These Top 3, will be calculated with the data of the last games since the beginning of the season.
It means that, for example, if you are looking the first game of the round 4 (line 813) : Guingamp vs Olympique de Marseille, I would like to know the players of the top 3 for Guingamp and Olympique de Marseille for the goals, the assists and the notes, thanks to the data of their games 1, 2 and 3 of the season 15/16.
Another example, If you are looking for the first game of the round 17 (line 4355 - OGC Nice vs PSG), you will do the same but with the data of their games from the round 1 to the round 16 of the season 15/16.
The Top 3 would be extract in the 2nd sheet « Top 3 » in the adapted column, as you will see on the sample (from column I to AT).
Then, in the column after each Top 3 players name, I just need to get the information (Yes or NO), if the player has played in the next game.
So still in the same example of line 813 with Guingamp vs Olympique de Marseille for the round 4, I have to check if one of the players in the Top 3 (for notes, goals and assists - remember the data has been extracted with the data of the games 1, 2, and 3) have played in the game 4.
And you can check the data thanks to the players names from the line 813 to 839.
Hope my brief is clear for you.
If not don’t hesitate to reach me.
Best
Christophe