yonderkens
New Member
- Joined
- Mar 9, 2018
- Messages
- 1
Hello everyone,
I need to report weighted averages of athletes' performances based on when they played, who they played against, and their positions.
Here is an example to clarify:
Let's say I'm looking at Team A. I want to know how all of the players in Position X who have played against Team A since Round n have performed on average against all teams since Round n.
The logical steps should look like this:
1. Find all of the players in Position X who played against Team A since round n by name, removing any duplicates.
2. Use those names to find the data of each game of each of those players since round n ( against Team A, Team B, Team C, and so on for however many teams they played against since Round n).
3. Calculate the weighted average
I've tried writing several codes to handle this, but I always get lost in complicated nested for loops and dynamic arrays.
I need to report weighted averages of athletes' performances based on when they played, who they played against, and their positions.
Here is an example to clarify:
Let's say I'm looking at Team A. I want to know how all of the players in Position X who have played against Team A since Round n have performed on average against all teams since Round n.
The logical steps should look like this:
1. Find all of the players in Position X who played against Team A since round n by name, removing any duplicates.
2. Use those names to find the data of each game of each of those players since round n ( against Team A, Team B, Team C, and so on for however many teams they played against since Round n).
3. Calculate the weighted average
I've tried writing several codes to handle this, but I always get lost in complicated nested for loops and dynamic arrays.
