+ Reply to Thread
Results 1 to 10 of 10

How to automatize a scoring table for tennis table competition?

  1. #1
    Forum Contributor
    Join Date
    11-07-2020
    Location
    Paris
    MS-Off Ver
    Microsoft office 365
    Posts
    236

    How to automatize a scoring table for tennis table competition?

    Good morning to the community.
    I am working on the file "Scoing Table Tennis Table".
    I would like to create a tournament for tennis table.
    I would like to automatize the process to make the scoring table for a competition.
    In the exemple, in the table A1:E5, the player 1 loses against the player 2 (9-11), wins against the player 3 (11-2), loses against the player 3 (10-12).
    The table located in the table range J8:012 represents the cumulative score of game1 and game2.

    I would like to add player (player 5, 6) and have a table ranking that change with this supplements of players. I would like for exemple to add player 5 in J6 and J13.
    I would like to have an update of the score when I enter a new score. I would like for exemple that the table located can cumulate the score of many games (game 1, game 2, game3).

    Thank you for your help.

    Capture.JPG
    Attached Files Attached Files

  2. #2
    Forum Guru HansDouwe's Avatar
    Join Date
    06-21-2022
    Location
    Nederland
    MS-Off Ver
    365 V2403 (Build 17330.20000)
    Posts
    6,466

    Re: How to automatize a scoring table for tennis table competition?

    Please try in N3 and copy to N10, N17 and so on:
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    and try in U10 and copy to U17 and so on:
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Attached Files Attached Files

  3. #3
    Forum Contributor
    Join Date
    11-07-2020
    Location
    Paris
    MS-Off Ver
    Microsoft office 365
    Posts
    236

    Re: How to automatize a scoring table for tennis table competition?

    Thank you for your answer @HansDouwe and the time you took.

    It's almost working perfectly.

    1. In cell P12 and Q12, the score of the player2 is 0 W and 0 L. It should be 0 W and 3 L.

    2. I've forgotten to mention that I would like to add in column U and AD, the number of points with a filter. I would like in the example to have this ranking for the game 1:
    The team has a best rank if she has more points. If two teams have the same amount of points, the team with the best difference has a better rank. (i put the results in the picture)

    3. I would like to add a player 5, 6... and have an update of the leaderscoreboard.

    Scoring Table Tennis Table 2.xlsx
    Attached Images Attached Images

  4. #4
    Forum Guru HansDouwe's Avatar
    Join Date
    06-21-2022
    Location
    Nederland
    MS-Off Ver
    365 V2403 (Build 17330.20000)
    Posts
    6,466

    Re: How to automatize a scoring table for tennis table competition?

    Here are corrected formulas:

    Please try in O3, and copy to O10, O17 and so on:
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    and try in X3 =O3# and try in X10 and copy to X17 and so on:
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Attached Files Attached Files

  5. #5
    Forum Contributor
    Join Date
    11-07-2020
    Location
    Paris
    MS-Off Ver
    Microsoft office 365
    Posts
    236

    Re: How to automatize a scoring table for tennis table competition?

    Wonderful, it's working perfectly.
    Thank you a lot @HansDouwe.

  6. #6
    Forum Guru HansDouwe's Avatar
    Join Date
    06-21-2022
    Location
    Nederland
    MS-Off Ver
    365 V2403 (Build 17330.20000)
    Posts
    6,466

    Re: How to automatize a scoring table for tennis table competition?

    Glad to have helped, thanks for the feedback and rep .

  7. #7
    Forum Expert
    Join Date
    01-05-2013
    Location
    Singapore
    MS-Off Ver
    H&B2019
    Posts
    4,542

    Re: How to automatize a scoring table for tennis table competition?

    Mine not as elegant, but I think it gives the results you wanted. Please check as the results differ from Hans.

    For Game 1:
    W =SUM(IF(IFERROR(FILTER($B$4:$E$7,$A$4:$A$7=$G4)-TRANSPOSE(FILTER($B$4:$E$7,$B$3:$E$3=$G4)),0)>0,1,0))
    L =SUM(IF(IFERROR(FILTER($B$4:$E$7,$A$4:$A$7=$G4)-TRANSPOSE(FILTER($B$4:$E$7,$B$3:$E$3=$G4)),0)<0,1,0))
    Points + =SUM(FILTER($B$4:$E$7,$A$4:$A$7=$G4))
    Points - =SUM(FILTER($B$4:$E$7,$B$3:$E$3=$G4))

    Need to re-range for Game 2 and Game 3.
    Attached Files Attached Files

  8. #8
    Forum Expert
    Join Date
    01-05-2013
    Location
    Singapore
    MS-Off Ver
    H&B2019
    Posts
    4,542

    Re: How to automatize a scoring table for tennis table competition?

    File attached with players increased to 5.
    Attached Files Attached Files

  9. #9
    Forum Contributor
    Join Date
    11-07-2020
    Location
    Paris
    MS-Off Ver
    Microsoft office 365
    Posts
    236

    Re: How to automatize a scoring table for tennis table competition?

    Thank you josephteh. I check your reply tomorrow.

  10. #10
    Forum Contributor
    Join Date
    11-07-2020
    Location
    Paris
    MS-Off Ver
    Microsoft office 365
    Posts
    236

    Re: How to automatize a scoring table for tennis table competition?

    I checked your proposal @josephteh.
    + Your proposal introduces the idea of total for the points difference.
    - Your proposal doesn't update the number of player if I add one or I remove one.

    But in summary, it is showing me an other solution. Thank you again.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Tennis scoring macro
    By davidofyfea in forum Excel Programming / VBA / Macros
    Replies: 26
    Last Post: 01-27-2023, 05:27 AM
  2. Table Tennis Predictor
    By davidofyfea in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-20-2020, 08:38 AM
  3. Help with competition scoring formula
    By elevensk8 in forum Excel General
    Replies: 10
    Last Post: 07-28-2019, 12:46 AM
  4. Competition Scoring with RANK & IF functions...
    By redwings73 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-25-2013, 11:32 AM
  5. Table Tennis Rankings (elo?) Help with design
    By stanlycam in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-17-2013, 03:41 PM
  6. Scoring chart for racing competition
    By Richie83 in forum Excel General
    Replies: 4
    Last Post: 11-18-2010, 03:38 PM
  7. [SOLVED] I need a template for scoring tennis matches
    By Jack in forum Excel General
    Replies: 0
    Last Post: 10-06-2005, 08:05 PM

Tags for this Thread

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1