It’s easiest to just check out the spreadsheet yourself: We use slightly different formulas for every other square to adjust the ladder for week 2. Whoever wins moves up a rung, and whoever loses moves down. Then we add a column for week 2’s new rankings. We use the next column to allow the players to check off who won, and then enter the score: We use the (semi) elegant formula isodd() to assign the matches with one formula pasted throughout.
For the first week’s match, we have #1 play #2, #3 play #4 and so on. We’ll want to have a place each week for players to enter in who won and their match score (We’ll get to this later as we build the spreadsheet).įirst we sort the list by NTRP Rating and then add a new tab to paste the names in. We want a signup tab for players to enter in their name, contact information, and tennis skill level (We’ll use the NTRP rating system). We’ll do it in Google Sheets, because we want players to be able to input the scores from their matches every time they play.Įach week we want players to enter in their scores, then move players up or down depending on if they won or lost, and then assign the players a new match for the next week. In today’s post we’ll walk through how to build a weekly tennis ladder for a group of players.
