[Home] [Overview] [Pre-registration] [Registration] [Volunteers] [Set-up] [Notes] [Updates] [Tutorials]

Preparing IAC Forms A, B, & C

    Copying and assembling sequence forms for judge's clipboards is arguably the most onerous task the registrar faces.  The Contest Ledger simplifies this somewhat by automatically printing the Chief Judge's clipboard from the order of flight data.  This still leaves the B and C forms and the grading judge clipboards to be copied and assembled.  To address this, two options are available.

Option 1

    Pilot name labels, printed in the order of flight and formatted for a commonly available commercial stick-on labels (Avery 05267) can be printed via the "Contest Ledger"  "Print" menu and selecting the "Form A Labels" checkbox.  The program will pause to allow you to load the label sheets and then print the categories selected.  The registrar can pre-assemble the clipboards and, once the order of flight is determined, add the labels in the order they are printed on the sheet.  Note that Frees vary for each pilot and must be handled manually as before. 

On the left side of the "Form A Labels" worksheet are the formatting parameters for the labels, preset for Avery 05267 (80 labels = 16 competitors x 5 judges per sheet):

Parameters for: Avery 05267  
Columns 4 minimum of 3
Rows 20 minimum of 10
Vertical Margins 0.50 this may not be possible with non-laser printers
Horizontal Margins 0.40  
Horizontal Spacers 0.40 to move printing away from edge of labels
max values are 5 x 25, note margins may not be compatible with non-laser printers  
 

These values can be edited to suit other label sheets, although it is advisable to have at least 3 columns and 10 rows (this will handle 6 competitors).  If there is any question about formatting or printer suitability, print a test page on blank paper using the "Test" button on the Contest Ledger Print dialog box.

Label Information:
Laser White Address & Shipping Labels
1/2" x 1-3/4", White, Laser, Permanent, 80 labels per sheet
05267 25 Sheets per Package $12.25  

Option 2

    A VBA program "PrintClipboards.BAS" for Visio can be loaded into the Visio files for the contest Knowns and Unknowns for each category and run to print out the remaining B's and C's and the complete grading judge clipboards:

  1. for the Chief Judge:  2 B's and 2 C's (place after the Contest Ledger Chief Judge Penalty Form)

  2. for the Boundary Judges: 2 sets of B's & C's (place one set after the each Contest Ledger Boundary Judge Worksheet)

  3. for each Grading Judge: 1 Form A for each pilot followed by 2 B's and 2 C's

Note that Frees vary for each pilot and must be handled as before. 

Requirements:  The order of flight is read from a current copy of the Contest Ledger backup file (Ledger.BAK), assumed to be stored in the same directory as the Visio sequence files.  The Visio files are assumed to be generated by Aresti 6 and utilize named shapes in the  Form A to supply contest name, date, judge number, flight order number, and pilot name.  Printing these forms can require a sizeable number of copies (e.g., for 15 competitors there will be 5x15 A's + 16 B's and C's + 7 separator sheets = 114 sheets total) and require a fast (10 pages a minute or faster) printer.  Note that a direct connection to the printer is likely to be faster (perhaps by an order of 2X) than a network printer.   In one trial, direct connection to a HP LaserJet 4 with limited (8MB) memory printed 16 A's, B', & C's in about 5 minutes, and might have taken over an hour to print a full order of flight for 15 competitors.  However, the registrar is free to do other tasks while this is happening and the assembly of the clipboards is made much simpler.

To Use:  Start Visio and load the sequence file (which should be stored in the same directory as Contest Ledger for convenience).  If not done previously, go to the "Tools" "Macros"  "Visual Basic Editor" menu.  Visual Basic for Applications (VBA) will load.  Once there, go to the "Files" "Import" menu and, in the resulting window, browse to the directory the Contest Ledger is stored in.  Locate and load the "FormsPrint.BAS" file and return to Visio.  Once loaded, you can print the forms by using the  "Tools" "Macros"  "Module1"  "PrintForms" menu.  If you save the sequence file, it will have the macro saved with it and you will need not reload it.  Note, however, that each sequence file needs to have the macro program loaded into it.  As the forms are printed they are separated by sheets identifying the following pages.  Separate them accordingly, combine with the output from the Contest Ledger ("Contest Ledger"  "Print" menu, select the "Clipboards" radio button and "Print" button) and place into the clipboards.