![]() I have 12 members that are playing and each member predicts the score of each match played and also the outcome e.g. So basically I am look at the English Premier League where there are 38 game weeks which contain 8 to 15 matches every game week. If the predict the correct OUTCOME they will get 2 points. What the scoring system is that if someone predicts the correct SCORE it equates to 5 points. Just a bit more insight to what I am trying to achieve. I would recommend thinking about doing your tracking by means of at least two different areas or sheets, one each for Input and Output. All of that compilation takes place on the Dashboard sheet. ![]() The key to my way of doing this is the database, a daily record, and that database (for the input of raw data) is separate from the output, the compilation of daily or long term results. I enter the scores of each person in the second tab of the workbook the front tab is a "Dashboard" that presents several different summaries of that data. This is a spreadsheet I've developed to track results of a group of four friends who daily engage in the recently popular word games (Wordle, Quordle, and three versions of Octordle). It's possible that the attached will help you to consider a different way of tracking and summarizing. This may not apply to others among the Excel experts who frequent this site, but I know for me, you're going to have to explain the thinking process here, how predictions and actual results come together to produce a weekly result, etc., etc. HOWEVER, while I do know how to use Excel to track scores in games and compare results of various people, I haven't the slightest understanding of how a football prediction league would work, what the numbers on your sample spreadsheet mean, and how to make sense of them. I hope that makes I don't know if I speak for others, but here's my dilemma: I'd love to be able to help you and suspect that Excel could be adapted quite readily to accomplish the task you have in front of you. I have attached hopefully a complete years spreadsheet from a previous year> SO for instance if I have 10 members predicting I can then add the fixtures for each member with their predictions and as the scores come in I can add the up to date scores into another part of the workbook so that it will update the main table as the scores change. What I would like to be able to do is to be able to input the matches onto the worksheet so that I can update the table much more easierly. ![]() With the replies I then compare them to the actual results and outcomes of the matches and manually input that data onto the spread sheet. Hi All, I have been running a football prediction league for the past 15 years and I have had to check everyones weekly predictions manually and then inputting onto an excel spread sheet to then form a table.So how it works is that I put onto facebook all the matches for that gameweek that the members can predict the score and the outcome on abd then they just add the scores to their own reply. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |