Hi,
I'm setting up a competition at work for the upcoming Euros and looking to make my life a little bit easier when running it.
It's a score prediction game and the below are the scoring rules we're using:
3 points - Outcome (I.e. Score Prediction is 3 - 1 Turkey v Italy, the Full Time Result finishing 2 - 0 Turkey v Italy, this would result in 3 points as the person got the correct outcome in picking Turkey to Win).
5 points - Team Score Correct (I.e. Prediction is 3 - 1 Turkey v Italy, the Full Time Result finishing 3 - 0 Turkey v Italy, this would result in 5 points as the person got the correct outcome in picking Turkey to Win but also how many goals Turkey would win).
7 points - Correct Score (I.e. Score Prediction is 3 - 1 Turkey v Italy, the Full Time Result finishing 3 - 1 Turkey v Italy, this would result in 7 points as they've correctly picked the correct final score).
0 points - Incorrect outcome (I.e. Score Prediction is 3 - 1 Turkey v Italy, the Full Time Result finishing 0 - 2 Turkey v Italy, this would result in 0 points as they've incorrectly picked the correct final outcome).
Is there any quick way of doing a formula or macro which could populate the points column below?
Thanks in advance.
MW
I'm setting up a competition at work for the upcoming Euros and looking to make my life a little bit easier when running it.
It's a score prediction game and the below are the scoring rules we're using:
3 points - Outcome (I.e. Score Prediction is 3 - 1 Turkey v Italy, the Full Time Result finishing 2 - 0 Turkey v Italy, this would result in 3 points as the person got the correct outcome in picking Turkey to Win).
5 points - Team Score Correct (I.e. Prediction is 3 - 1 Turkey v Italy, the Full Time Result finishing 3 - 0 Turkey v Italy, this would result in 5 points as the person got the correct outcome in picking Turkey to Win but also how many goals Turkey would win).
7 points - Correct Score (I.e. Score Prediction is 3 - 1 Turkey v Italy, the Full Time Result finishing 3 - 1 Turkey v Italy, this would result in 7 points as they've correctly picked the correct final score).
0 points - Incorrect outcome (I.e. Score Prediction is 3 - 1 Turkey v Italy, the Full Time Result finishing 0 - 2 Turkey v Italy, this would result in 0 points as they've incorrectly picked the correct final outcome).
Is there any quick way of doing a formula or macro which could populate the points column below?
Date | Time | Team1 | Actual Score | Matt's score predictions | Points |
Friday 11th June | 20:00 | Turkey v Italy | 3 - 1 | 3 - 0 | |
Saturday 12th June | 14:00 | Wales v Switzerland | 2 - 1 | 2 - 1 | |
Saturday 12th June | 17:00 | Denmark v Finland | 1 - 0 | 4 - 3 | |
Saturday 12th June | 20:00 | Belgium v Russia | 0 - 0 | 2 - 0 |
Thanks in advance.
MW