Announcement

Collapse
No announcement yet.

Excel Sheet Basketball World Cup

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Excel Sheet Basketball World Cup

    Hi All,

    I need someone to help me understand how the ranking of the groups works as I want to try to create an excel sheet for the world cup.
    if anyone can help me I will be very thankful.
    I am no expert in Excel, but I know the basics and it should be straight forward as long as I know how standings in the group works.
    Regards

  • #2
    Actually, this is a very interesting question, which I have also been unable to answer so far

    It requires two sheets and 8, I believe, columns for the first sheet

    I am pretty sure that the team names should be included in the first two columns(e.g. Serbia in column 1, Argentina in column 2, the final score (85-78) in the third, the correct score per team in the following two (85 in c.4, 78 in c.5, both to be added via a type which deducts the figures from column 3), margin and total points in the 6th column (=c.4-c.5) and the winning or losing sign in the last two columns (on a "1" or "2" for loss/win, depending on the sign before the number of column 6)

    However, what I cannot be sure of is how the teams are being ranked in the second sheet, when all the results are being transfered. I can try to check it and let you know, but I am not definite I can make it work
    Sexuality when one reaches their 30s is either mainstream or sick, but no matter what, it isn't pure

    Comment


    • #3
      Originally posted by wardjdim View Post
      However, what I cannot be sure of is how the teams are being ranked in the second sheet, when all the results are being transfered. I can try to check it and let you know, but I am not definite I can make it work
      hi Wardjdim, and thanks for your reply, actually this is exactly what I was asking about, yeah we are both not sure about the same thing, if you can get more info so we can work on it that will be wonderful..
      thanks

      Comment


      • #4
        Hi, if you don´t want to lose your time on it, you got a finished excel sheet just to download here

        DepositFiles provides you with a legitimate technical solution, which enables you to upload, store, access and download text, software, scripts, images, sounds, videos, animations and any other materials in form of one or several electronic files.


        The only trouble is that it is in spanish...., but you can easily change the names of the countries

        Comment


        • #5
          that 's actually a lot better, thank you very much for your help

          Comment


          • #6
            Thanks Sykes
            "...I got the hand that will rock your craddle / cream you like cheese spread you on my bagel..." - Shaq

            Comment


            • #7
              Great work. I checked and the 1/8 Finals are defined automatically in accordance with group standings.
              Bronze Medal - IBN 2014 FIBA Basketball World Cup Prediction Game

              Comment


              • #8
                Excellent job

                Thanks a lot
                Sexuality when one reaches their 30s is either mainstream or sick, but no matter what, it isn't pure

                Comment

                Working...
                X

                Debug Information