+ Reply to Thread
Results 1 to 2 of 2

Excel World Championship Football

  1. 06-03-2014, 09:52 AM #1
    tomsheek
    tomsheek is offline
    Registered User
    Join Date
    11-26-2011
    Location
    Granada, Spain
    MS-Off Ver
    Excel 2003
    Posts
    20

    Excel World Championship Football

    Hi all,
    would it be possible to create some kind of excel sheet with all matches (groups) schedule , play offs (auto fill after the regular match)

    We are making some kind of competition here at work.
    We tried to create some kind of rules (ex : I give the score of the match, if I have the correct score, I have 3 points, if I have guess the winner 1 point ( ex: I said 2-0 for Brasil - Croatia but it finish 3-1 I have 1 point). Of course 0 point if I have no good results.

    We are about 11 - 12 people in this internal competition.
    Would it be possible to create some file for me (idea is to fill only score of the match and the other will be autofilled (points....)

    Regards,
    Reply With QuoteRegister To Reply
  2. 06-03-2014, 10:38 AM #2
    nathansav
    nathansav is offline
    Valued Forum Contributor
    Join Date
    09-21-2011
    Location
    Birmingham UK
    MS-Off Ver
    Excel 2003/7/10
    Posts
    2,188

    Re: Excel World Championship Football

    i've done this for someone else on the forum.

    If you keep the scores separate, so have Home Team, Away Team Home Goals Away Goals

    then you can either have a helper column so if(a1>b1,"Home",if(a1<b1,"Away","Draw") to determine home or away win. Have the same helper on the prediction,

    so

    A1 = Home Team
    b1= Away Team
    c1=home goals
    d1=away goals
    e1=if(c1>d1,"Home",if(c1<d1,"Away","Draw")
    f1= home prediction
    g1=away prediction
    h1=if(f1>g1,"Home",if(f1<g1,"Away","Draw")
    i1=if(and(c1=f1,d1=g1),3,if(h1=e1,1,0))


    something like that.
    Hope this helps

    Sometimes its best to start at the beginning and learn VBA & Excel.

    Please dont ask me to do your work for you, I learnt from Reading books, Recording, F1 and Google and like having all of this knowledge in my head for the next time i wish to do it, or wish to tweak it.
    Available for remote consultancy work PM me
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] World Football Elo Ratings model
    By zartem in forum Excel - New Users/Basics
    Replies: 4
    Last Post: 06-26-2014, 10:18 AM
  2. Awareness Post: ModelOff 2013 (Excel Financial Modeling World Championship)
    By The_Snook in forum The Water Cooler
    Replies: 0
    Last Post: 09-25-2013, 08:03 AM
  3. Awareness Post: ModelOff 2013 (Excel Financial Modeling World Championship)
    By The_Snook in forum Excel General
    Replies: 0
    Last Post: 09-25-2013, 08:03 AM
  4. [SOLVED] World Football ELO Ratings
    By Chuzzy17 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-25-2013, 12:53 PM
  5. Calculate the score for a football championship
    By Nuno Fale in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-20-2012, 07:14 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1