Results 1 to 3 of 3
  1. #1
    Lounger
    Join Date
    Apr 2001
    Location
    Glasgow, Lanarkshire, Scotland
    Posts
    36
    Thanks
    0
    Thanked 0 Times in 0 Posts

    WorldCup Excel (Office 2000)

    Greetings,

    World cup fever is amongst us!! Well in my company anyway!

    I've got a small competition that I am trying to organise. Entrants need to predict the scores correctly in each round of the World Cup - 3 points for the correct score, 1 point for the correct result, and 0 for incorrect score and result.

    Examples

    I predict France to beat Senegal 2-0.

    France beat Senegal 2-0 - I score 3 points
    France beat Senegal 1-0 - I score 1 point
    Senegal beat France 7-0 - I get 0 points.

    In the event of a draw, lets say I predict France draw with Senegal 1-1

    If the actual score is 1-1, then I get 3 points.
    If the actual score is 3-3, then I get 1 point.

    How can I build up a formula to give points based on these outcomes? I've included an attachment for you to see.

    Any help - much appreciated!!
    Attached Files Attached Files

  2. #2
    New Lounger
    Join Date
    May 2001
    Location
    QLD, Australia
    Posts
    24
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: WorldCup Excel (Office 2000)

    Hi Andrew,
    Not sure where you are from, but setting up a tipping comp is as close as I will get to the World Cup after my beloved Australia failed against Uruguay in the playoff.
    Anyway I have a file with a possible solution for you. It will need some work to 'pretty it up' but it has all the formulas etc you will need to successfully run your comp.

    I hope you like it !
    Attached Files Attached Files

  3. #3
    Lounger
    Join Date
    Apr 2001
    Location
    Glasgow, Lanarkshire, Scotland
    Posts
    36
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: WorldCup Excel (Office 2000)

    Craig,

    As a Scot, I can see where you are comming from re quality of football (there's always the Irish!!)

    I followed your example - and the logic you used was what I was looking for - i.e. breaking it down into two calculations - one for the score and one for the result. I was trying to do too much at once.

    There probably is a way of doing it in one fell swoop - but its outa my league!

    Thanks again - and enjoy the games.

    Andrew

Posting Permissions

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