569091 Need php / mysql code modified to calculate more than 1 user

Site runs Drupal but don't really need a drupal person specifically just a good php/mysql coder. My drupal database has a table that stores a players fitness test results. The player can log in to his account and see their results as well as 3 scores which are calculated by a custom module. Scores are 1-5 with a 5 being in the top 20% of athletes and 1 being the lowest 20%. There are 3 scores a Race Score, Battle Score, and Recover score. These scores are made up of different results from the fitness test data. Example of a score calculation: A race score is made up of your speed, agility and reaction time test results. Below are the steps taken to get a score. Step 1: Lets say there are 20 athletes and John has the second fastest time he would be ranked 2nd. Same thing is done for their agility and reaction results. Step 2: So John has a speed rank of 2, agility rank of 8 and reaction rank of 12. These are taken and divided by 3 to give us the result of 7.33 or for this purpose 7. Step 3: All of the users average ranks are taken and then they are ranked by this number. Let's say johns average rank of 7 is the 10th best average rank out of the 20 athletes, he has a “rank of average” of 10. Step 4: Simple percentile formula is done using the rank of average from step 3. P =1-(rank of average/(number of athletes in group+1)) or in this case P=1-(10/21) P=0.52 Step 5: convert percentile into a score of 1-5. In this case John would have a race score of 3 because he falls between 0.4 and 0.6 The same thing is then done for the Battle Score and Recover scores using different fitness test results in the database. Also of note the script takes into account missing test scores. For example if John did not take the agility test the step 4 automatically changes the equation from (speed + agility + reaction) / 3 = average rank to (speed + reaction) / 2 = average rank *this is very important This part all works great in the current module and you can use that modules script to help create what I need. This is what I am working on now: I've created a login for the trainer/coach so that they can view the scores of their group and the fitness test results. I was able to create the code for how to gather all of the actual fitness test data of players in a specific camp and display it in a table it works great. What I need is for someone to either take the code from the players score page that already works and implement it onto the coach page so that it gives the scores of all of the players in the group or create a new code that does this. So currently a player can login and see just his scores compared against his camp for Race Battle Recover What I need now is a script on a page for the coach that has a table of all the players in his camp and their scores like this Position PlayerName RaceScore BattleScore RecoverScore Clear as mud?