Contents - Index

Create Player List Text File

Once you have created a final grouped Player List by any of the available methods, you can create a comma-delimited text file of the Player List information via the corresponding choice from the Player List submenu of the Preparation Menu.  The name of the created file is PFtext.txt and it is located in the TRNLIST\TRNx folder, where "x" is the Tournament Number you are using (zero for Tournament Number 10).  This file may be useful for importing the information to programs such as Microsoft Excel for customized processing.  For example, one of our customers uses the file for preparing specialized locker room signs.  

All of the 15 fields in the Player List Records are in character format.  The following defines the fields as they appear from left to right in the record:

1     Group Number
2     Player Name
3     Handicap Type (I - Handicap Index, H - Course Handicap, C - Callaway or P - Peoria)
4     Handicap (the player's full Course Handicap)
5     Start Time (if used, in the format HH:MM-A/P where A = AM and P = PM)
6     Start Time Value (used internally by the GTM Program)
7     Tee Number
8     Player Number (present only if the Player List has been prepared from the Pairings feature)
9     Flight Number (if used)
10    Adjusted Handicap (Course Handicap as adjusted for Percent of Handicap, Maximum Handicap, etc.)
11    (Not Used)
12    Group Handicap (if available as a result of various automatic Pairings)
13    Points Quota (if applicable for various Scoring Formats)
14    Handicap Index (the player's USGA Handicap Index for players with the I Handicap Type)
15    (Not Used)

Example of a Text File Record: 1,JOE JONES,I,10,08:00-A,480,1,12345,,9,,,,9.2,

Fields that are not used have nothing between the commas in the record (or after the comma that follows the Handicap Index field).  In the above example the Flight Number,Group Handicap, Points Quota and the two Not Used fields are blank.

Importing the file into Excel is an easy process.  In Excel, select Data from the top menu bar, then Get External Data, then Import Text File.  Proceed through the windows that follow.  The only thing you need to know is that the text file is comma-delimited.  Once the spreadsheet has been created, you can edit it (e.g. to add a row of column headings, delete unwanted columns, etc.) and use it as you wish.  Also, if desired, you can use Excel's Save as Web Page feature to place the spreadsheet on a web page.