(11-28-2017, 02:41 PM)bovovovo Wrote:Just tested it lol
I like it!
Would you set it so each user can only submit once? That would keep people from changing their predictions after they’ve sent them in. Would you only count the users most recent predictions if they fill it out more than once?
The only way to restrict one entry per user is to require them to log into Google and that's something I don't want to force people to do.
As you said, we would only count the most recent predictions if they filled it out more than once. This is very easy to filter out and identify any multiple entries a user. Basically I would:
1) Filter out duplicate entries by one user and remove oldest entry
2) Input formula to calculate scores
3) Alphabetize list of users with scores for output