shangar
New Member
- Joined
- Feb 7, 2016
- Messages
- 2
Hi
I wonder if you could help. In an attempt to raise some funds for my football (soccer) team I'm looking at running a prediction competition during Euro 2016.
The idea is pretty basic, but I wish to use the power of Excel to minimise my admin duties. Unfortunately, my Excel knowledge doesn't extend far beyond the odd chart!
So, I’d be grateful if you could take a look at the following & propose how best to go about applying this to a spreadsheet.
Sheet1, will contain results of matches. This result will then populate columns D & E. Columns F & G will be populated by the actual prediction, see below –
<tbody>
</tbody>
What I wish to do in column H is allocate points in relation to the predicted score, for example -
A correct scoreline (4 2) = 5 points
A correct result (3 1) = 2 points
An incorrect result (for example, 1 1, or 1 2) = 0 points
It is this formula that is well beyond my Excel skills.
Thanks in anticipation for entertaining my post.
I wonder if you could help. In an attempt to raise some funds for my football (soccer) team I'm looking at running a prediction competition during Euro 2016.
The idea is pretty basic, but I wish to use the power of Excel to minimise my admin duties. Unfortunately, my Excel knowledge doesn't extend far beyond the odd chart!
So, I’d be grateful if you could take a look at the following & propose how best to go about applying this to a spreadsheet.
Sheet1, will contain results of matches. This result will then populate columns D & E. Columns F & G will be populated by the actual prediction, see below –
A | B | C | D | E | F | G | H | |
1 | Actual | Score | Predicted | Score | Points | |||
2 | France | v | Romania | 4 | 2 | 3 | 1 | ? |
3 |
<tbody>
</tbody>
What I wish to do in column H is allocate points in relation to the predicted score, for example -
A correct scoreline (4 2) = 5 points
A correct result (3 1) = 2 points
An incorrect result (for example, 1 1, or 1 2) = 0 points
It is this formula that is well beyond my Excel skills.
Thanks in anticipation for entertaining my post.