Shark with cue KaktusSoft presents BAS V3.16

Billiard Administration System
English version. Nederlandse versie hier. Download Download software Download
You are visitor number This program is SHAREWARE (182k). The Billiard Search Engine.
Introduction Installation and files Menu's and keys
Add Games Create reports Add players
Remove player Change player's name Update average manually
Update average Remove game Configuration
Change configuration Caroms to make Score layout
Registration Tips and tricks Start new season
Average update formulas Administrate multiple clubs Frequently asked questions
Compatibility What is new Author
Remark


Pay $15.00 to register!!

Introduction

Sorry but English isn't my native language! If you find any spelling or grammar error please notify me. This software has been translated from Dutch to English so that's why I created version 3.9. This program is used by the carambolage billiard league manager (called carom billiard in USA). The program has, after storing players, averages and configuration options the following capabilities:

In this document I'll explain all menu and configuration options.
Installation and files

The software contains two files BILLIARD.EXE and BILLIARD.DOC. Create a new directory for the databases. Next run from this directory the program BILLIARD.EXE with startup option INIT. PLAYERS.DBF, CAROM.DBF, CONFIG.DBF, RESULTS.DBF and REGIST.DBF will now be created automatically if they don't exist in the current directory. If no DBF-files are found in the current directory a question will be asked to create them. RESULTS.DBF will be created automatically if this is the only missing file (new season). The startup option INIT isn't required in this case. BILLIARD BW to force black/white mode. For example:

MD \BILLIARD
CD \BILLIARD
COPY A:\BILLIARD.EXE
COPY A:\BILLIARD.DOC
BILLIARD INIT

Files:

BILLIARD.EXEThe main program
BILLIARD.DOCThe Help file
PLAYERS.DBFThe players file
CAROM.DBFRelation average <-> Caroms to make
CONFIG.DBFThe configuration file
RESULTS.DBFThe results file
REGIST.DBFThe registration file
Next you can start the application with the following command: BILLIARD
Menu's and keys

You can select a menu option by means of the UP-ARROW, DOWN-ARROW, PG-UP, or PG-DOWN key. You can also select an option by typing the first character. Activating an option is done by pressing the ENTER key. ESC returns you to the previous menu. After activating the option the selected action will be executed. If the action concerns a submenu activation and this submenu contains no options, for example no players, the submenu isn't activated. You can move to another field in a form by pressing the ENTER, UP-ARROW or DOWN-ARROW key. Storing the data is done by PG-UP or PG-DN. Canceling the form is done by ESC.
Add games

If you select this option, a submenu displays all players. Select one of them and the same submenu appears again. Again select a player. Next you fill in all game data. You can change the period by CTRL-P (upward) and ALT-P (downwards). Only periods not filled in so far are possible and if there is no available period, the form doesn't appear. Storing misses and highest break can be activated by changing the configuration option. After validating the game data, the game will be added. An error for example can occur if a player has a higher average than his highest break. Canceling the form is done by ESC.
Create reports

The following options can be selected here:
  1. Results per player report
    		2. Next select start period and end period. The file RSLTxy.TXT is created for example RSLT0102.TXT. The TXT-file will be proceeded by file RESULT.STP if found, can be used for printer setup information and/or title.
  2. Results per player report in HTML
    		3. Next select start period and end period. The file RSLTxy.HTM is created for example RSLT0102.HTM.
  3. Results one player report
    		4. Next select start period and end period. The file RSLT.TXT is created. The TXT-file will be proceeded by file RESULT.STP if found, can be used for printer setup information and/or title.
  4. Results one player report in HTML
    		5. Next select start period and end period. The file RSLT.HTM is created.
  5. Intermediate score report
    		6. Next select start period and end period. The file SCORxy.TXT is created for example SCOR0102.TXT. The columns you want to be displayed in this file can be changed in the configuration. The TXT-file will be proceeded by file SCORE.STP if found, can be used for printer setup information and/or title.
  6. Intermediate score report in HTML
    		7. Next select start period and end period. The file SCORxy.HTM is created for example SCOR0102.HTM. The columns you want to be displayed in this file can be changed in the configuration.
  7. Players report
    		8.  The file PLAYERS.TXT is created. The TXT-file will be proceeded by file PLAYERS.STP if found, can be used for printer setup information and/or title.
  8. Players report in HTML
    		9. The file PLAYERS.HTM is created.
  9. Matrix report
    		10. Next you select the period you want. The file MATRIXx.TXT is created for example MATRIX01.TXT. The TXT-file will be proceeded by file MATRIX.STP if found, can be used for printer setup information and/or title.
  10. Matrix report in HTML
    		11. Next you select the period you want. The file MATRIXx.HTM is created for example MATRIX01.HTM.
  11. Games to play report
    		12. Next you select the period you want. The file GAMESx.TXT is created for example GAMES01.TXT. The TXT-file will be proceeded by file GAMES.STP if found, can be used for printer setup information and/or title.
  12. Games to play report in HTML
    		13. Next you select the period you want. The file GAMESx.HTM is created for example GAMES01.HTM.
After creating the TXT-files a preview automatically appears on the screen. Also an option is available to print directly on LPT1, LPT2 or LPT3. You can use STP-files to transmit special codes to your printer, for example small characters or PORTRAIT or LANDSCAPE output. If your printer manual doesn't describe these codes, you can also use a DOS-printer setup program delivered with your printer. If you don't get the right output, you can also use a DOS word processor (for example WP) and the right printer driver to print the file the way you want. The translation of special characters like ë and á to HTML isn't supported yet. You can read the HTML Character Set that describes how to translate them. Possibly you need billiard pictures to make your WEB page cool. You can find them here. Links to billiard clubs using my HTML-report option.
Add player

If you choose this option, a screen appears where you can fill in the name and average. The name must be unique and the average greater than 0. Maximum number of players is 99.
Remove player

If you choose this option, a submenu containing all players appears on the screen. Next choose a player. You can now remove the selected player in the following way.
  1. Out of the players file.
  2. As player out of the results file.
  3. As opponent out of the results file.
  4. Totally.
Fill in at options 2 and 3 which period it concerns.
Change player's name

If you choose this option, a submenu containing all players appears on the screen. Next choose a player. The new player's name must be unique.
Update average manually

If you choose this option, a submenu containing all players appears on the screen. Next choose a player and the average appears on the screen. Now you can change the average. By means of CTRL-A the average will be automatically updated following the rules of the "Average update formula". See configuration option.
Update average

All players' averages will be automatically updated following the rules of the "Average update formula". (see configuration)
Remove game

Select the data concerning the game and the game will be removed. The data are player, opponent and period.
Configuration

After selecting this option you have the following capabilities:
  1. Change configuration.
  2. Caroms to make.
  3. Score layout.
Change configuration

Here you can change the following configuration options:
Play day Which day the games will be played? Assume you select Wednesday. When adding games the default date will be last Wednesday.
Average points Does a player get an extra point if he plays better than his average. This is important for the score, matrix report and the games per player. This is only valid if "10 points system" and "Special Points System" have their value set to NO.
Store misses Do you want to store made misses? If yes, then the misses do appear in the results per player report.
Store highest break Do you want to store the highest break? If yes, then the highest break does appear in the results per player report.
10 points system Do you work with the 10 points system? If yes, then a player receives "10*caroms made/caroms to make" as game points (truncated). This is only valid if "Special Points System" is NO.
Special Points System Special function made by and for the user. Default now is 0.
Win,Draw,Loss If yes, these fields appear in the results per player report.
Check game. Must the program check whether or not the game is over yet? (at least one of both players did make his caroms)? Only select no if you have a time limit. The one with the highest percentage of caroms (caroms made/caroms to make) is the winner.
Maximum innings What is the maximum number of innings a game can last? If you want to stop the games after a certain number of innings, you can store the maximum number of innings. More innings are not allowed in played games. If the played innings are equal to the maximum number of innings, sometimes the game is not over. The one with the highest percentage of caroms (caroms made/caroms to make) is the winner.
Change period The default period. This will be used if asked for a period, for example a matrix report. This is also the default period, if not played yet, for adding games.
Change maximum period The number of periods per season. This is the maximum period you can select in matrix report for example.
Average update formula If all games in a certain period or season are played, you usually update all averages. How to do so is described in this formula. You can use the following constants and functions:
  • _CP: Current period
  • _MP: Maximum period
  • _CM: Current average
  • Moy(x,y): Average of period x till y inclusive. If x>y than average of period y till x inclusive.
  • Moy(x): Average of period x.
  • AvgMoy(x,y): Average average of period x till y inclusive. If x>y than average average from period y till x inclusive.
  • AvgMoy(x): Average of period x. This is the same as Moy(x).
  • Place(x,y): Player's place in the score (for example winner(1) or runner up(2)) if you only count period x till y inclusive.
  • Place(x): Player's place in the score (for example winner(1) or runner up(2)) if you only count period x.
See also Tips and tricks.
Special Points Formula Game points computed by a formula. The following constants can be used:
  • _C: Caroms
  • _B: Innings
  • _HS: Highest break
  • _PDL: Misses
  • _GP: Game Points (win=2,draw=1,loss=0)
  • _MP: Average points
  • _PNT10: Ten Points System
  • _UIT: Is the game over (.T. or .F.)
  • _M2M: Average to make
  • _C2M: Caroms to make
  • _aC: Caroms opponent
  • _aHS: Highest break opponent
  • _aPDL: Misses opponent
  • _aMP: Average points opponent
  • _aPNT10: Ten Points System opponent
  • _aM2M: Average to make opponent
  • _aC2M: Caroms to make opponent
Fixed amount of innings You play a fixed amount of innings. This is equal to "maximum innings". The one with the highest percentage of caroms (caroms made/caroms to make) is the winner. Of course there's no check if one of the players made their caroms.
Complete last inning Each player may complete his last inning when he reaches his "caroms to make". The one with the highest percentage of caroms (caroms made/caroms to make) is the winner.
Date format Here you can change the date format, for example: dd-mm-yyyy or yy/mm/dd
Club name You can here fill in your club name. This name will appear on all reports and on the screen. Now you can manage more clubs very easy.
Special characters output That replaces the "Box drawing characters" to normal characters. So you can open your output now from any windows word processor. After that you can change the FONT, MARGINS, FONT-SIZE and even print LANDSCAPE.
Caroms to make

Now you see 3 columns with the following headers: Average till, Average times and Extra caroms. Now you can define more average groups and the caroms to make. For example: You play 30 times tour average plus 5 extra caroms and a minimum of 20. At an average of (20-5)/30=0.5 you have to make 20 caroms. If your average is lower you have to make less caroms, which isn't allowed. The caroms to make looks like this:
Average till:Average times:Extra caroms:
0.5000.00020.000
99.99930.0005.000
You can add a scale by pressing CTRL-INS and remove the one selected by pressing CTRL-DEL. Update mode will be activated by pressing ENTER. Also you can start a wizard by pressing F2.
Score layout

Here you can select which items you want in the intermediate score report columns. You can choose out of 20 options that are described on the right of the screen. If you select 0 nothing is filled in. For example 1,2,0 is the same as 1,0,2. So you determine what is displayed yourself. Also you determine the sequence of options.
Registration

Fill in your name and registration code which you will receive when you register the program. How to register the software will be displayed when you exit the program. The unregistered version can store a maximum number of 100 records in the results file. This means 50 games. Costs of registration are 15 dollar or equal money.
Pay $15.00 to register!!
Tips and tricks

Start a new season

If you want to close a season you have to do the following actions to start a new season: Probably the averages have to be updated so select "Update average" if needed. Next you set the "Current period" to 1. Now you exit the program and remove the results file (DEL RESULTS.DBF). Next you start the program once with startup option INIT (BILLIARD INIT).
Average update formulas

Formula: Description:
IF(_CP=_MP,Moy(1,_CP),_CM)Only update at end of season.
Moy(1,_CP)Update each period.
Moy(_CP)Update each period. The new average will be determined by selecting only the last period.
MAX(AvgMoy(1,_CP),_CM)Update each period. The new average is the average average of all periods. The average isn't allowed to get a lower value.
(Moy(_CP)+_CM)/2 Update each period. The new average will be determined by the last period's average and the current average.
(Moy(_CP)+_CM)/2*IF(Place(_CP)=1,1.1,1)Update each period. The new average will be determined by the last period's average and the current average. If he is the current period's winner, his average will be 10 percent higher (*1.1).

When the averages have been updated, you have to change the "Current period" (add 1 to it). If you use an unknown function or variable the program crashes at updating averages. The formula you use must be a valid CLIPPER 5.2 standard code block.
Administrate multiple clubs

C:\BILLIARD
BILLIARD.EXE
BILLIARD.DOC

C:\BILLIARD\CLUB1
PLAYERS.DBF
RESULTS.DBF
CONFIG.DBF
CAROM.DBF
REGIST.DBF

C:\BILLIARD\CLUB2
PLAYERS.DBF
RESULTS.DBF
CONFIG.DBF
CAROM.DBF
REGIST.DBF

C:\BILLIARD\CLUB3
PLAYERS.DBF
RESULTS.DBF
CONFIG.DBF
CAROM.DBF
REGIST.DBF
Frequently asked questions

I get the following error message:
Error DBFNTX/1001 Open error: players.DBF (DOS Error 2)
Solution: See Installation and files
I get the following error message:
Error DBFNTX/1001 Open error: players.DBF (DOS Error 5)
Solution: Remove the READONLY attribute.
attrib -r players.dbf
I get the following message: Valid 0..0
Reason: The Caroms to make aren't filled in the way it should be.
We compute our caroms over 30 innings. Sometimes if a game is over in 30 innings, the winner doesn't get an average point.
Reason: A player gets an average point if he plays better than his average. This isn't automatically so when the game is over in 30 innings (rounding).
Solution: Set "Special Points System" to YES and fill in the "Special Points Formula" in the following manner:
_GP+IF(_GP<>0  .AND.  _B=30,1,_MP)
See also Change configuration
We have a player on our club who stops during the second period. I want to remove this player out of the files, but the first period's games played against this player must count for the average and game points for the other players.
Solution: Choose option "Remove player". Select the corresponding player and select "As player in result file". Next select all periods. Now select "As opponent in result file". Now select period 2. Next select "Out of the players file". The player doesn't appear anymore on the reports and you can't select this player.

Compatibility

Compatible with V3.9 (the first English release), V3.10, V3.11, V3.12, V3.13, V3.14 and V3.15. If you want to use the English version instead of the Dutch one you have to rename some files, please send me e-mail, and I'll explain how to do so.
Dutch file nameEnglish file nameRemark
SPELERS.DBFPLAYERS.DBF
UITSLAG.DBFRESULTS.DBF
CONFIG.DBFCONFIG.DBF
REGIST.DBFREGIST.DBF
CARAMBOL.DBFCAROM.DBF
WEDSTRYD.STPGAMES.STPIf used
SPELERS.STPPLAYERS.STPIf used
UITSLAG.STPRESULT.STPIf used
MATRIX.STPMATRIX.STPIf used
STAND.STPSCORE.STPIf used
What is new

BASV3.9: Nothing. This is the first English release.
BASV3.10: Changed many English messages. Changed Special Points field from 2 to 3 positions, this will be activated when creating RESULTS.DBF (done when you start a new season). Solved the year 2000 problem, years from 80 to 99 will be 19xx and otherwise 20xx. You can change the date format by setting an environment variable for example: SET CLIP_DATE=yy/mm/dd or SET CLIP_DATE=dd/mm/yyyy. When you specify a wrong date format the format will be dd-mm-yyyy. The amount of played games determines the ranking if players have equal game points. Now there is also an option for changing a player's name.
BASV3.11: Now you can change the date format by means of a configuration option (was CLIP_DATE see version 3.10). Also you can set a fix amount of innings or a player may complete his last inning, see configuration option. Your configuration file will be converted automatically, so these 3 fields will be stored as well. File CONFIG.DBT is gone after the conversion.
BASV3.12: Now you can set your club name by means of a configuration option. Also added an extra check , when "complete last inning" has been set to YES. RESULTS.DBF will be created automatically if this is the only missing file (new season).
BASV3.13: Start with: BILLIARD BW to force black/white mode. Extra options for "special points formula" (refer to opponent). Fixed some minor bugs. Now it also runs on fast machines without problems (266 MHz and faster).
BASV3.14: Enhanced error messages: When a dos error occurs the message is also displayed in plain english. When adding a game with a wrong "Special Points Formula" the game was partially added and the program crashed. Now the game is removed totally and the program doesn't crash anymore. Instead an error message is displayed. The same is happening when "Update average." with a wrong "Average update formula." A new configuration option has been added. "Special characters output." That replaces the "Box drawing characters" to normal characters. So you can open your output now from any windows word processor. After that you can change the FONT, MARGINS, FONT-SIZE and even print LANDSCAPE.
BASV3.15: Immediately write to disk after each database change. This has been implemented because some users do close the DOS-BOX prior to ending the application. Never do this with a DOS-program!! Results one player report. Changed function "write to printer". New "Windows only" printers gave problems.
BASV3.16: Extra report "Results one player report in HTML.". Matrix size is shorter when not using special points system. Program does consume less CPU time (did use almost 100% in previous versions).
Author

This program has been made by:

R.G. Clarijs
Luxemburglaan 219
1946 SC, Beverwijk
The Netherlands
tel. (31)251-259989
E-MAIL :
For latest version see: Ron's Homepage Ron's Homepage
If you have questions, problems or remarks please write, call or e-mail me.
Remark

If using WINDOWS don't print the output-files (*.TXT) within WINDOWS. If doing so, by pressing right mouseclick (WINDOWS 95), or drag and drop on printer icon (WINDOWS 95), NOTEPAD will be executed (associated with extension .TXT) and windows uses the ANSI character set! Simply print from a DOS-box (ASCII) using EDIT is my advice.

KaktusSoft