Product Info

ePonger is based on Microsoft Excel, and is really a very large spreadsheet with over a dozen sheets, plus a few thousand lines of Visual Basic for Excel (VBA) code.  This makes it easy to use… if you’re comfortable using Excel, you can learn to use ePonger in a few minutes.  Let’s get started on our tour!
Screen-By-Screen Tour
  

Here’s how you would use ePonger for a typical “league night”.  In this example, the league is playing three rounds of play, with just six players (to keep things simple!).  The first round is round robin, 2 games per match.  The second round is round robin, 3 games per match.  The final round is a single-elimination playoff for the top 4 finishers.
First, you’d open ePonger, activate the main Check-In sheet, and click Start to get everything initialized for the day’s play.  As part of this, the signup sheet prints automatically.  It lists all players who have played in the last few weeks.  This is typically printed out and put on the sign-in table, so players can sign in as they arrive.

Here’s the check-in sheet, where you check in the day’s players, either by letting the players check themselves in directly on the computer, or by looking at the printed check-in sheet.  Either  way, you just click on the “NO” in each player’s row, changing their checked-in status from “NO” to “YES”, and highlighting the entire row in green.  You can sort the whole table by first name, last name, rating, and/or checked-in status.Here’s the same check-in sheet before anyone has checked in, and again after 6 players (highlighted in green) have checked in.
<CLICK ON ANY OF THE SCREENSHOTS TO SEE THEM FULL-SCREEN!>

 

ePonger v207 start screen no results yet

 

ePonger v207 start screen 6 checked in

 

Now it’s time to set up the first round.  You click on the Set Up Groups button, which takes you through a five-step wizard, shown in the five screenshots below.  The steps are:

  1. Select which round of play and how you want to assign players to groups, There are 3 different methods available for assigning players to groups: MIXED (players are assigned to groups so that each group has a mixture of high and low rated players, BY RATINGS (players are assigned to groups based on their rating) and BY WINNERS (same as by ratings, but makes sure that the first round’s winners are assigned to the top groups in the 2nd round).  There is also an “accelerator” feature in the admin screen not shown here, where you can set up your leagues so that a player’s rating is temporarily adjusted up or down based on whether they won or lost their previous round-robin; this helps better players move up to higher groups faster than they would by rating alone.  Regardless of which method you use, you can always manually override the assignments in step 4.
  2. Review the sorted list and make sure everyone’s signed in correctly,
  3. Select number of groups (1 to 12) and number of games per match (1, 2, 3, 4 or 5 games, or best 2 of 3 or 3 of 5),
  4. Review the assignments and make changes if needed, and
  5. Confirm and print the score sheets.

ePonger v207 start screen start wizard 1

ePonger v207 start screen start wizard 2

ePonger v207 start screen start wizard 3

ePonger v207 start screen start wizard 4

ePonger v207 start screen start wizard 5

ePonger then creates score sheets that can be printed and handed out to the players.  The program can handle up to 12 groups and 8 players per group, for a total of 96 players.  Here’s a score sheet at the start of play, before any results are entered:

ePonger v207 score sheet before play

Here’s the same score sheet after entering the results entered.  Yellow boxes indicate the results entered manually; the program calculates everything else.  If you’ve selected “best 2 of 3” or “best 3 of 5”, you enter both the number of wins and number of losses in each match.  If you’ve selected a fixed number of games per match, you just enter the number of wins and ePonger enters the number of losses.  You can also handle defaults by noting the number of matches won or lost by default and leaving that match result empty.  And if you want, you can just leave a match empty if those 2 players simply did not play; in this case ePonger will warn you that you missed a match but you can override that and leave it empty.

ePonger v207 score sheet after play

Once you’ve entered the results and checked them for accuracy (!), click Save Group Results.  This saves the results in a .PDF file and updates the info in various places including the Check-In sheet, as shown here:

ePonger v207 start screen after 1st round

Now it’s time for the second round of play.  You’d use the Set-Up wizard same as before (not shown here).  This time let’s say you want to play 3 games per match.  Here are the results of the 2nd round:

ePonger v207 score sheet after 2nd round play

And here is the Check-In sheet after the 2nd round results are in.  Notice that ratings have been updated after each round.

ePonger v207 start screen after 2nd round

Finally, let’s have a single-elimination playoff for the top 4 players.  You enter them in the Playoff sheet by picking their names from a pick-list, then enter the number of games won and lost.  The program automatically advances the winning player(s).

ePonger v207 playoff screen

At the end, click Save Results to Playoff Results Sheet, which produces this:

ePonger v207 playoff results screen

Now you’re done with playing for the day.  The program has automatically created aresults summary sheet that can be emailed to members afterwards.

ePonger v207 results

There are also a few useful administrative screens.   Here is the database sheet that holds a history of all results.  It’s got one row per player and one column per league play date.

ePonger v207 player list

Here’s a useful help screen:

ePonger v207 help screen

Here’s the screen that describes how to donate to keep ePonger up and running:

ePonger v207 donation screen

Here’s the Admin screen for various settings (described in detail on the screen itself via Tool Tips):

ePonger v207 admin screen

And finally, here’s the sheet that defines how ratings are adjusted based on games won/lost and matches won/lost.  If you want, you can (carefully) edit the yellow boxes which contain the rules for how ratings are affected by wins and losses.  The rest of the boxes are automatically calculated by ePonger and are used to adjust player ratings.

ePonger v207 rating screen