+ Reply to Thread
Results 1 to 10 of 10

Football prediction point system

  1. #1
    Forum Contributor
    Join Date
    08-29-2006
    Location
    London
    MS-Off Ver
    Excel 2016
    Posts
    314

    Football prediction point system

    Hi Guys

    I got one for you. I have a sheet that i have attached

    Is there a way I can come up with a function/formula that will check all the
    predictions against the actual match results as I enter them.


    Points are scored as follows:

    HOME WIN PREDICTED
    SPOT ON =*40 pts
    CLOSE = 20 PTS (-3 PER GOAL OUT)
    WRONG = 0 PTS (-3 PER GOAL OUT)

    DRAW PREDICTED
    SPOT ON =*50 pts
    CLOSE = 30 PTS (-3 PER GOAL OUT)
    WRONG = 0 PTS (-3 PER GOAL OUT)

    AWAY WIN PREDICTED
    SPOT ON =*50 pts
    CLOSE = 30 PTS (-3 PER GOAL OUT)
    WRONG = 0 PTS (-3 PER GOAL OUT)



    I am using Excel 2003.

    I would really appreciate it if someone could come up with the answer to
    this beauty!!

    Thanks
    Attached Files Attached Files

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Football prediction point system

    Hi,

    Try the following in G6 and copied down

    Please Login or Register  to view this content.
    I wasn't sure whether -3 per goal out means less than 3 or less than or equal to 3. Change the If test if necessary.

    Regards
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Forum Contributor
    Join Date
    08-29-2006
    Location
    London
    MS-Off Ver
    Excel 2016
    Posts
    314

    Re: Football prediction point system

    Thank you my friend but it didnt work because;

    I put Blackburn V Wolwes 1-1 but the macth score was 2-1 to Wolves, so I my match prediction was wrong for this match. I get zero points plus I predicted Wolves goals wrongly, it is one goal diffrence so i get -3 for the game.

    Fulham V Aston Villa , My prediction was 2-1 to Villa but the match score was 0-0 so becaose my match prediction was wrong for the game I get 0 points for the game plus I predicted 3 golas wrong so 3* (-3) = -9 is my score for the game

    I hope It is clear now. Can you change the formula?

    Thanks

  4. #4
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Football prediction point system

    Hi,

    It would assist if you would enter the actual results you expect to see, then we won't be guessing what you mean by -3 per goal out. Please make sure you list all possible combinations and ranges of scores.

    What in fact does -3 per goal out actually mean and how does it affect the points awarded.

    For instance does Wrong mean a wrong result, e.g. predicted a Home win and result is a draw and in which case if the value of that is zero what do you mean by saying it's -3 per goal out.

    Regards

  5. #5
    Forum Contributor
    Join Date
    08-29-2006
    Location
    London
    MS-Off Ver
    Excel 2016
    Posts
    314

    Re: Football prediction point system

    I have expleined how things work please see the amended atachment. Please let me know if it is not clear
    Attached Files Attached Files

  6. #6
    Forum Contributor
    Join Date
    08-29-2006
    Location
    London
    MS-Off Ver
    Excel 2016
    Posts
    314

    Re: Football prediction point system

    Any help please
    Regards
    Last edited by lapot; 08-19-2011 at 07:52 AM.

  7. #7
    Forum Contributor
    Join Date
    08-29-2006
    Location
    London
    MS-Off Ver
    Excel 2016
    Posts
    314

    Re: Football prediction point system

    Any help please?

  8. #8
    Forum Contributor
    Join Date
    08-29-2006
    Location
    London
    MS-Off Ver
    Excel 2016
    Posts
    314

    Re: Football prediction point system

    It looks like it is a hard combination I had no reply

  9. #9
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Football prediction point system

    Hi,

    See attached

    Regards
    Attached Files Attached Files

  10. #10
    Forum Contributor
    Join Date
    08-29-2006
    Location
    London
    MS-Off Ver
    Excel 2016
    Posts
    314

    Re: Football prediction point system

    thank you very very much , I will check it when I get home becuse your attachement not compateble with Eexel 2003.

    kind regards

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1