WinTD will allow you to import a finished cross table from a text file or spreadsheet. This can be useful if you want to create a USCF or FIDE rating report, or do some other type of post-tournament processing. 


WinTD does the import one section at a time. You need to create the section(s) first, using standard means. Make sure that the import file has the correct format (as described below). Then use the Section-Import Cross Table… function. Make sure you choose the correct file type.


Import File Format

There should be one line per player, and the data must already be parsed into fields. If you're doing a "Copy and Paste" from a web site, this will usually paste into a spreadsheet in something reasonably close to the correct format. If, however, the downloaded file is "preformatted" text, you'll have to use your spreadsheet's parsing operation to separate the text into columns. (This is done with Text to Columns on the Data menu in Excel).


The first row in the file should include the column labels. For many of the fields, WinTD is looking for a specific field title, or it could permit one of a few alternatives. If the file has a field with a title not given below, WinTD will skip it. If it's important that the field be processed, change the field title on the input file. For instance, if the player number field has a blank title on your file, you'll need to alter the file to show one of the four alternatives below.


No.

(or Plr or Plr# or #) The cross table reference number for the player (required!!)

Name

Player's name (should be last, first, if possible)

ID

(or USCF ID) Player's ID

Exp.

(or Exp) Expiration date

Ttl

(or Title) Title

Rate

(or USCF or Rtng or Rating) Player's rating

St

Player's state or country (up to three characters)

Gr

Player's prize group (up to two characters)

Team

Player's team code (up to six characters)

Club

Player's club code (up to five characters)

Ty

Player's sex (M, F)


Round fields can have any titles containing the round number. For instance, "R1", "R2", … or "1","2",…


The content for the round fields must be Wnnn for wins, Dnnn for draws and Lnnn for losses, where nnn is the opponent's number. (Spaces are permitted between the result code and the player number). Byes and forfeits should have B for a full point bye, H for a half point bye, N or U or blank for an unplayed game or zero point bye, F for a forfeit loss, X for a forfeit win and Z for a forfeit "draw." In all of these, spaces or dashes can be included in the code, so -B- or B alone can be used for a full point bye.


Example (Partial)


# Name                 USCF ID  USCF Rd 1 Rd 2 Rd 3 Rd 4 Rd 5 Rd 6 Rd 7 Rd 8 Rd 9  

1 Smirin, Ilya         12544869 2794 W--- D192 W11  W8   D7   W20  W2   D4   D3  

2 Onischuk, Alexander  12625186 2746 W188 W72  W21  W28  W38  D4   L1   D9   W16  

3 Akobian, Varuzhan    12740522 2570 W95  W62  D5   D6   W184 W21  D27  W38  D1  

4 Finegold, Benjamin   11264417 2639 W51  D91  W131 W41  W37  D2   W19  D1   D6  


How WinTD Imports the Information

A cross table includes quite a bit less information than would be available in a full tournament file. For instance, the colors and board assignments for games are missing. Because of this, the imported file should only be used for limited types of post-tournament processing which don't require the greater detail. Don't try to import half a tournament intending to switch to WinTD unless you're willing to spend a considerable amount of time correcting the color assignments in the existing games. Note also that WinTD will import each game twice. If player 1 beats player 8 in round 3, WinTD will create one game record for the W8 for player 1, and another for the L1 for player 8. (WinTD does this so the import can be done one player at a time without complicated cross checking).