Hi All,
I offered to put this on here for my work colleague who is trying to do a predictions league for the up and coming world cup.
Problem is as follows.
The 'WC-2014-EntrySheet' is the main sheet where the actual scores are recorded for the games. The 'Player' sheets are for the individual players to record their predictions (i have filled them out on 'player 1' tab. At the moment my colleague will have to compare the players predictions and the actual results and type in 'Y' under the 5 different point columns ( i have done the first 3 as an example).
Is there a way for the sheet to automatically fill in the points for each player?
Point structure is:
Wrong Outcome = -10 points
Correct outcome but wrong score = 10 points
Correct outcome with Correct goal difference = 15 points
Correct Draw but wrong score = 20 points
Completely Correct result = 30 points
The sheet will then populate the second round table with the names of the teams that go through (column BM), once score are entered for this round then it will populate the third round table and so on. However we're not sure on the best way to calculate the points....any suggestions?
Any help would be fantastic
Thanks
Bookmarks