One More Example

Algorithm

I decided I wanted to use 3-pointers made, and free throws made. However, most teams make about twice as many free throws as 3-pointers, so I multiplied the 3-pointers by two. On the 2019 spreadsheet, my equation was =N2*2+Q2

Sort

After I drug down the algorithm to all 68 teams, I then sorted my algorithm column Z to A because I wanted the teams with the highest score.

Scoring Algorithm

I created two more columns for the rank and my score. As a reminder, to calculate my score I take "Number of Tournament Wins" * "Rank". Then I add "Number of Tournament Wins" * "Cinderella" * 5 to add in any potential cinderella points.

Evaluate

I applied the scoring algorithm to my top 10 teams by dragging down the function. I then used "=SUM" to total my ten scores, and came out with an overall score of 71. Clearly my function needs some tweaks, so I will delete this copied sheet and try again.