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
Hi there,
There is an issue with role permissions that is being worked on at the moment.
If you are having trouble with access or permissions on regional forums please post here to get access: https://www.boards.ie/discussion/2058365403/you-do-not-have-permission-for-that#latest

excel spreadsheet

  • 03-09-2010 8:08am
    #1
    PaddyCar
    Registered Users, Registered Users 2 Posts: 702 ✭✭✭


    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

  • #2
    DS
    Registered Users, Registered Users 2 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