During the season, we are a few who bet on the Soccer games in UEFA Champions League. Each game can have the outcome 1, X, 2.
1 for Home team victory
X for Draw
2 for Away team victory
I want to be able to send out an email to the participants with a unique link or at least an individual identifier, which takes the Particiant to a webpage where he fills out a Google Form with hs guess for how it's going to go in each of the games in this round.
The Google form needs to have the games from this webpage in it:
http://www.uefa.com/uefachampionsleague/season=2016/matches/day=2/[url removed, login to view]
I then mark which games are in the round for this weeks guesses and send out the link to the form.
The Participants take their guesses and their responses are recorded back into the Excelsheet which powers the Google Form.
After the games are played, I create the correct list, filling out the correct result for each game and then want the system to automatically correct all the Participant's guesses. For each correct guess, you get one point, for each wrong guess you get zero points.
I then want to be able to send out a summary, of who won this round, who got the most points in this round and also a total, since this goes over the entire soccer season, the Participants collect points each week so we get a marathon table with all the different rounds summed up.
So, in summary:
1. Be able to scrape/import/download the UEFA Champions League games, with date, time, Home team, Away team and Arena name.
2. Let the Participants signup and enter their email address.
3. Be able to select what games are in this round and send out to the registered emails of the Participants.
4. Let the Participants fill out their guesses, and have a deadline for when no more guesses can be sent in (so no one can cheat and send in after the game has started)
5. Recieve and record their guesses back into a Google Spreadsheet.
6. Manually enter the correct results and automatically score the Participant's guesses.
7. Be able to email out the result of this round and the total, accumulated, point standings.
I do have a webhosting in place hould this need to be hosted somehwhere.
I will be available for any and all questions along the way.