Quote:
Originally Posted by wilsonmw04
just a quick suggestion: figure out some way of weighting the elimiation wins more. I was just looking through the rankings. my team (2106) is ranked 490th (not complaining) while the winner of VCU (540) was ranked 709th. It looks like the QP's and seeds are given too much weight. I can't believe how much work went into this. Nicely done!
|
On the "variables" sheet you can add weight to the winner/finalist (or any of the other items you want to adjust). It is currently set at 20pts. I gave finalists a multiplier of 1 and winners a multiplier of 2. Then you'll have to resort the sheet you're looking at if you change any of the variables by the rank column.
To do this you "select all" by clicking the upper left corner of the sheet where the (2) column and row headers meet. then Data>Sort>Sort by rank and descending.