Fantasy football game with work colleagues how to automatically calculate results using excel spreadsheet
We have a friendly game in the office to predict football results each week.
Each person predicts results based on a win, lose or draw basis and score 1 point for each correct guess.
I have the attached spreadsheet where i've created a layout of what we use but instead of manually counting the scores and results each week i'd like excel to calculate peoples scores and add to their current leaderboard totals.
I assume i'd need to use IF statements of which im not familiar
Also we choose a BANKER game each week where we think the most likely result in our favour may be and this helps to separate players why may be on equal points.
If this does make sense then would someone be able to help with setting up calculations.
I have put some dummy predictions and results into the attached file so there is data to work from.
Big-8.xls
Each person predicts results based on a win, lose or draw basis and score 1 point for each correct guess.
I have the attached spreadsheet where i've created a layout of what we use but instead of manually counting the scores and results each week i'd like excel to calculate peoples scores and add to their current leaderboard totals.
I assume i'd need to use IF statements of which im not familiar
Also we choose a BANKER game each week where we think the most likely result in our favour may be and this helps to separate players why may be on equal points.
If this does make sense then would someone be able to help with setting up calculations.
I have put some dummy predictions and results into the attached file so there is data to work from.
Big-8.xls
File to make a start.
Not quite as described above, I had only assumed one prediction column but each entrant needs a prediction so have a table of predictions instead.
See attached.
Thanks
Rob H
Big-8.xls
Not quite as described above, I had only assumed one prediction column but each entrant needs a prediction so have a table of predictions instead.
See attached.
Thanks
Rob H
Big-8.xls
Before going any further (which I won't be able to now anyway until after the weekend), have you seen this web site:
http://www.footballsoftware.co.uk/
No point re-inventing the wheel.
Thanks
Rob H
http://www.footballsoftware.co.uk/
No point re-inventing the wheel.
Thanks
Rob H
Sorry looks like that is for Fantasy Teams rather than following real teams.
Thanks
Rob H
Thanks
Rob H
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you for all feedback.
I have selected to assign all points for the one answer as it provided the full solution and was supported by excellent documented information
I have selected to assign all points for the one answer as it provided the full solution and was supported by excellent documented information
So suggestion, Add columns for:
Predicted result, - Manual Entry
Scores ie Home team score & Away team score - Manual Entries
Calculated Result - formula (assuming 4 columns added) comparing home team score with away team score to determine Home Win, Away Win or Draw.
The allocation of points can then be a comparison of predicted result and actual result.
Possible results:
Correct prediction of Home Win = 1
Correct prediction of Away Win = 2
Correct prediction of Draw = x
Incorrect prediction = ?
Making a start on the file but need some clarification, particularly on how you are keeping the running total and the bankers.
Thanks
Rob H