m.amin.sh
New member
Hey fellas.
Me & my friends running a football prediction competition for English Premier League. I was wondering if there is a formula that could automatically compare actual results with predicted results and assign points.
The scoring system is as like this:
Correct Result: 7 points
Correct Result With Goal Difference: 5 points
Only Correct Winner: 3 Points
Wrong Result: 1 Points
Example:
Like Liverpool vs Norwich
Actual Result: 3-1
Player 1: 3-1 (7 Points)
Player 2: 2-0 or 4-2 or 5-3 or ... (5 Points)
Player 3: 1-0 or 2-1 or 3-0 or ... (3 Points)
Player 4: 0-0 or 0-1 or 1-3 or ... (1 Points)
View attachment Example.xlsx
Thank You so much!
Me & my friends running a football prediction competition for English Premier League. I was wondering if there is a formula that could automatically compare actual results with predicted results and assign points.
The scoring system is as like this:
Correct Result: 7 points
Correct Result With Goal Difference: 5 points
Only Correct Winner: 3 Points
Wrong Result: 1 Points
Example:
Like Liverpool vs Norwich
Actual Result: 3-1
Player 1: 3-1 (7 Points)
Player 2: 2-0 or 4-2 or 5-3 or ... (5 Points)
Player 3: 1-0 or 2-1 or 3-0 or ... (3 Points)
Player 4: 0-0 or 0-1 or 1-3 or ... (1 Points)
View attachment Example.xlsx
Thank You so much!