Advertisement
If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)
Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie

excel spreadsheet

Options
  • 03-09-2010 9:08am
    #1
    PaddyCar
    Registered Users Posts: 696 ✭✭✭


    Hi. Apologies if this is elsewere. My mates and I are currently having a competition to see who can predict the most correct scores in the English premier league between now and Christmas. Looking to set up a spreadsheet that will automatically add up the points based on everyone’s prediction once I enter in the actual game results. Im not much good on excel so any help appreciated.
    This is the points scoring system we are using
    Correct Result = 30 Pts
    Correct Draw = 20 Pts
    Correct Goal Diff = 15 Pts
    Correct Outcome = 10 Pts
    Wrong Outcome = -10 Pts


Comments

  • Options
    #2
    DS
    Registered Users Posts: 654 ✭✭✭DS


    Try this. Scoring is a bit vague so maybe you need to rejig the formula if I've got it wrong:

    Correct Result = 30 Pts (only for a win?)
    Correct Draw = 20 Pts (exact score draw?)
    Correct Goal Diff = 15 Pts (only for a win?)
    Correct Outcome = 10 Pts
    Wrong Outcome = -10 Pts


Advertisement