Results 1 to 4 of 4

Thread: Calculating WL %age of last 20 games

  1. #1
    Neophyte chemmiah's Avatar
    Join Date
    Sep 2020
    Posts
    3
    Articles
    0
    Excel Version
    2016

    Calculating WL %age of last 20 games



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi all,


    I am working on a long term pet project of mine of analyzing trends in CFB. I have data in chart form (see attached). In the Scores Tab you will see the scores laid out in tabular form. On the next tab "List", I would like it to calculate what the win percentage of the last 20 games (W/(W+D+L)), but since the team can be in the home or away column i am racking my brain to come up with a efficient way to do so. I am willing to add more columns to the scores table if need be or create unique identifiers.


    Also, I would like to calculate the current Streak, so if it is a 3 game win streak it would report: W3 or if it was a 2 game draw streak it would report as D2, and so on.....


    Let me know if this is possible. Thanks!
    Attached Files Attached Files

  2. #2
    Neophyte chemmiah's Avatar
    Join Date
    Sep 2020
    Posts
    3
    Articles
    0
    Excel Version
    2016
    Anyone have any thoughts?

  3. #3
    Super Moderator p45cal's Avatar
    Join Date
    Dec 2012
    Posts
    1,782
    Articles
    0
    Excel Version
    365
    See attached, right-click the table at cell J1 and choose Refresh, which should fill in the blanks I deleted from the table just before I saved it.
    I added fictitious rows to the table as there weren't anywhere near 20 records for any team.
    Attached Files Attached Files

  4. #4
    Neophyte chemmiah's Avatar
    Join Date
    Sep 2020
    Posts
    3
    Articles
    0
    Excel Version
    2016
    Thank you p45cal. This is great!

Posting Permissions

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