|
Re: White Paper Discuss: Spreedsheet to Calculate the Ranking of Teams
Not so much a bug, rather a question of implementation. The final tiebreaker in the standings is the "random electronic coin toss", and you are using the Rand() function to generate this number for all teams.
The problem I noticed is that Rand() recalculates after every data refresh. So, while two teams are tied, their ranking will fluctuate each time new data is inputted. Perhaps this column should be made static at the initial entry of all team data? This way these fluctuations would be eliminated.
Thoughts?
__________________
:: Karthik Kanagasabapathy :: "Enthusiasm is one of the most powerful engines of success. When you do a thing, do it with all your might. Put your whole soul into it. Stamp it with your own personality. Be active, be energetic, be enthusiastic and faithful and you will accomplish your object. Nothing great was ever achieved without enthusiasm" -- R.W. Emerson
My TEDx Talk - The Subtle Secrets of Success
Full disclosure: I work for IFI and VEX Robotics, and am the Chairman of the VEX Robotics and VEX IQ Game Design Committees .
|