Question About the Solver

I am trying to solve a peculiar problem using Excel, and would appreciate any approaches or ideas anyone can offer. Context. I am scoring a season of sailboat races in which each boat may have sailed a different number of races and each race may have had a different number of boats. Each boat is scored based on its best 7 races by dividing the sum of the number of points earned by the sum of the number of points they could have earned had they won each of their best 7 races. The challenge is in determining which races are arithmetically "best". My working hypothesis had been that the 7 best individual race scores (points earned over possible points) would lead to the best score. It turns out that this is not the case because a race with more competitors has more impact on the aggregate score than a race with fewer competitors. The maximum number of races that a boat could have sailed is 17. Mathematically, I would express the problem like this: For a series of fractions X1/Y1, X2/Y2, X3/Y3...Xn/Yn where n is greater than or equal to 7, select the seven pairs that maximize the sum of X / the sum of Y. I am wondering if the solver could be useful in this problem, but would appreciate info from anyone who has any thoughts about approaches that my work. I can provide a data set for 1 or more boats if that would be helpful. Many thanks, Larry