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 -----------------------------------------------------