+ Reply to Thread
Results 1 to 5 of 5

Football Prediction Game Season 2010-11

  1. #1
    Registered User
    Join Date
    06-13-2010
    Location
    Plymouth, England
    MS-Off Ver
    Excel 2010
    Posts
    58

    Football Prediction Game Season 2010-11

    Hi All

    Let me firstly start by adding in advance a big thank you to JBeacucaire and Marcol for whom there contribution has been very invaluable

    However I now face a new problem in the calculation of this game so all input would be of great appreciation.

    Below is how it works at present
    1. the correct score gets 3 points
    2. a player who predicts the correct win gets 1 point
    3. when no scrores are entered the player gets 0 points

    The problem with the formula is that when the outcome of the score is a draw any player whom hasn't entered, scores 3 or 1 point instead of recieving 0 points

    Many Thanks In Advance

    Jedi
    Attached Files Attached Files
    Enjoy ! ! !

  2. #2
    Registered User
    Join Date
    06-12-2009
    Location
    Manchester, UK
    MS-Off Ver
    Excel 2010
    Posts
    68

    Re: Football Prediction Game Season 2010-11

    =IF($D4="","",IF(AND($D4=H4,$F4=I4),3,IF(SIGN($D4-$F4)=SIGN(H4-I4),1,0)))

    extracted from my own prediction game where you can see how it works
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    06-13-2010
    Location
    Plymouth, England
    MS-Off Ver
    Excel 2010
    Posts
    58

    Re: Football Prediction Game Season 2010-11

    thanks 1.zer0

    however your prediction game does the same if you give the 1st result as 1 1 and no body enters a score then that player is still awarded 1 point and if the score is 0 0 then they score 3 points there must be a formula out there that if the player doesn't enter a score doesn't earn any points!!

    Cheers

    Lee

  4. #4
    Registered User
    Join Date
    06-13-2010
    Location
    Plymouth, England
    MS-Off Ver
    Excel 2010
    Posts
    58

    Re: Football Prediction Game Season 2010-11

    looking at your game sheet 1.zer0 I do like the way you can scroll in any direction but the names stay locked would love to know how you do that

    cheers

    lee

  5. #5
    Registered User
    Join Date
    06-13-2010
    Location
    Plymouth, England
    MS-Off Ver
    Excel 2010
    Posts
    58

    Re: Football Prediction Game Season 2010-11

    is there an easy way of getting the particular fixtures rather than entering them all by hand??

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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