To run a club/class rating system download the AccelRat software.

I made a couple of bat files (in addition to the ones supplied with AccelRat) to help me run AccelRat and generate a club rating list. They are simple and short. I include them below: 

First you need to create an initial "empty" data base, ex. see b070325.tde below. 

Create a tournament file, ex. see t070506.tde below. The first one you create only needs the "NAME" and "RATING" attributes in the "## PLAYERS" section. The "SIGMA" attribute is calculated by AccelRat. The example shows an iteration where I copy the entire latest database (b0) as the player list for the new games file (t1). Add any new players for the run to the "## PLAYERS" section. If you don't copy the entire database into the "## PLAYERS" section, the reports will only show those players included in the "## PLAYERS" section. 

I prefix the player ids with the club/class initials to avoid confusing club/class ids with AGA ids. 

Add the game results in the "## GAMES" section. The comment ("# w-id b-id win handi komi") before the "## GAMES" shows the format for each game result. You can have one or more "## GAMES X" section. I ususally group each week's games into individual sections, but you can put all games for a run in one section. 

Edit variables (b0, t1, b1) in doit.bat before running, notice the lack of .tde extension. I use "t<date>" for tournament files and "b<date>" for database file which you will see in the doit.bat file example below. 

After running doit.bat, you will see a number of reports in various formats that will be generated for use by your club. AccelRat says mail the results, but since this is a local club rating, don't mail them as they would confuse the AGA. 

Each time you add results and run a report, start at the "create a tournament file" step. 

Copy everything between the dashed lines to create the named files. 

---------------------------------------------
b070325.tde (the initial "empty" database)
---------------------------------------------

## END
---------------------------------------------

t070506.tde (an example to show formatting, do not use)
---------------------------------------------
## TOURNEY Guang Hua Chinese School,Blue Bell PA, January, 2007
## RULES AGA
## PLAYERS
GH100 NAME="Chang, Derek" RATING=-25.62320 SIGMA=0.93784
GH101 NAME="Chang, Jonathan" RATING=-23.19197 SIGMA=0.94541
GH102 NAME="Chen, Kobe" RATING=-30.0 SIGMA=6.0
GH103 NAME="Chen, Kyle" RATING=-25.32458 SIGMA=1.23275
GH105 NAME="Philips, Roy" RATING=-24.22705 SIGMA=0.83512
GH107 NAME="Yin, Daniel" RATING=-20.74627 SIGMA=1.68241
GH108 NAME="Zhang, Alex" RATING=-28.90033 SIGMA=1.74100
GH109 NAME="Zhou, Evan" RATING=-26.56404 SIGMA=0.74294
GH106 NAME="Wang, Charlie" RATING=-26.58855 SIGMA=1.35215
GH111 NAME="Hu, Jeff" RATING=-13.34534 SIGMA=1.62984
GH112 NAME="Kong, Adam" RATING=-14.73142 SIGMA=5.42477
GH113 NAME="Qiu, Lawrance" RATING=-13.39810 SIGMA=1.64531
GH114 NAME="Zhu, Arichin" RATING=-14.11752 SIGMA=1.84691
GH115 NAME="Hu, Alan" RATING=-15.56834 SIGMA=0.86668
GH116 NAME="Shaw, Justin" RATING=-15.34052 SIGMA=2.00721
GH117 NAME="Mei, Tony" RATING=-16.07433 SIGMA=0.97240
GH118 NAME="Jin, Eric" RATING=-17.07192 SIGMA=1.56052
GH119 NAME="Chen, Jeff" RATING=-15.34052 SIGMA=2.00721

# w-id b-id win handi komi 
## GAMES 1
# jan 7, 2007
GH106 GH108 W 0 0
GH103 GH109 W 0 0
GH108 GH106 B 0 0
GH109 GH108 W 0 0
GH103 GH106 B 0 0
# upper section
GH115 GH119 W 0 5
GH113 GH112 W 0 5
GH117 GH114 B 0 5
GH112 GH117 W 0 5
GH118 GH115 B 0 5
GH119 GH107 W 0 5
GH105 GH119 B 0 5
GH113 GH115 W 0 5
## GAMES 2
# jan 21, 2007
GH106 GH108 W 0 0
GH103 GH106 W 0 0
GH112 GH107 W 0 5
GH113 GH111 W 0 5
GH105 GH111 B 0 5
GH116 GH114 B 0 5
GH112 GH115 W 0 5
GH107 GH119 W 0 5
GH113 GH111 B 0 5
GH105 GH116 B 0 5
## END
---------------------------------------------

doit.bat (need to edit variables (b0, t1, b1) before running, notice the lack of .tde extension)
---------------------------------------------
REM original base
set b0=b070325

REM new games to be added
set t1=t070506

REM new base
set b1=b070506

call arlocal %b0% %t1% %b1%

call arlist %b1%
pause
---------------------------------------------

arlist.bat (generates a report of all players)
---------------------------------------------
@echo off
rem
rem This script creates local club rating lists.
rem

rem Check input requirements
if X%1==X goto ARGS
if not X%2==X goto ARGS
goto READYGO

:ARGS
echo The following command line argument is expected:
echo 1. base ratings file
echo For example,
echo %0 base 
echo.
goto STOPBAT

:READYGO
rem Verify existence of base ratings file.
if exist %1.TDE goto RG1
echo %1.TDE not found
goto STOPBAT

:RG1
rem Erase any previous efforts and temporary files
if exist RATSLRCW.TXT erase RATSLRCW.TXT
if exist RATSLNCW.TXT erase RATSLNCW.TXT
if exist RATSLRWP.TXT erase RATSLRWP.TXT
if exist RATSLNWP.TXT erase RATSLNWP.TXT
if exist RATSLRWEB.HTM erase RATSLRWEB.HTM
if exist RATSLNWEB.HTM erase RATSLNWEB.HTM
if exist *.LOG erase *.LOG

echo Processing ...

rem Write ratings list in constant width font format.
arexe30 areportp %1 /tag=name /tag=rating /tag=id /out=RATSLNCW
if errorlevel 1 goto STOPBAT
arexe30 areportp %1 /tag=rating /tag=name /tag=id /out=RATSLRCW
if errorlevel 1 goto STOPBAT

rem Write ratings list with a tab before each field.
arexe30 areportp %1 /tag=name /tag=rating /tag=id /wp /out=RATSLNWP
if errorlevel 1 goto STOPBAT
arexe30 areportp %1 /tag=rating /tag=name /tag=id /wp /out=RATSLRWP
if errorlevel 1 goto STOPBAT

rem Write ratings list in HTML.
arexe30 areportp %1 /tag=name /tag=rating /tag=id /html /out=RATSLNWEB
if errorlevel 1 goto STOPBAT
arexe30 areportp %1 /tag=rating /tag=name /tag=id /html /out=RATSLRWEB
if errorlevel 1 goto STOPBAT
rename RATSLNWEB.TXT RATSLNWEB.HTM
rename RATSLRWEB.TXT RATSLRWEB.HTM

rem
rem Clean up.
rem

rem Erase temporary files
erase *.LOG

rem
rem Tell the user what was output.
rem

echo Look for the following output files:
echo RATSLNCW.TXT - ratings list, name order, assuming constant width font
echo RATSLRCW.TXT - ratings list, rating order, assuming constant width font
echo RATSLNWP.TXT - ratings list, name order, with tabs for word processor
echo RATSLRWP.TXT - ratings list, rating order, with tabs for word processor
echo RATSLNWEB.HTM - ratings list, name order, for web browser
echo RATSLRWEB.HTM - ratings list, rating order, for web browser
echo 

goto DONE

:STOPBAT
echo Script execution stopped due to error.

:DONE
-----------------------------------------------------