Measures Annex K Using Best of Utility

1.     This Utility gives the User the capability of combining the results of several Measures Files (CONTAINING THE SAME RACERS NAMES) and producing a result that tabulates the Best “x” results of “y” Races for each Racer in a total column.

a.  “x” = the number of Races or Runs that are to be included in the total. b.  “y” = the number of Races or Runs that are to be evaluated.

2.  BESTOF Allows you to:

• combine a number of Measures Races and produce the Best ‘x’ of ‘y’ Racers (Ie: Best 4 of 6).
• take the best 5 runs of say 7 two-run races. In other words of the 14 runs made you can get a BESTOF Result for say 5 of them.
• subtotal a number of Races then take the Best of the Subtotals.
• outputs the results to a ".csv" file (ie: Comma Separated Value File) which if double clicked on opens in Excel.
• produce an output that includes the Racers Name and other associated information including columns for each Race or Run that was included along with a column that contains the Total of the Best “x” results.
• Use races with different disciplines providing there are no sub-totals.

3.   The Utility handles “DNS’s, DNF’s and DSQ’s” by assigning a Race time of 600seconds or 10 minutes to those runs. This ensures that these runs will NOT be included in the calculation unless they are actually one of the racers BEST “x” times.

4.     This can happen in the case of a Racer “DNFing” all runs or possibly all but a couple of runs. If the program is asked to calculate say the best “2” or “4” runs and the racer has “DNF’d” say three of them then his/her total would be 600 plus the time of the run that they did actually complete.

5.     It is recommended; BUT not required, to use this program with 1 run races. This ensures that a Racer whom Did Not Finish run 1 will get full accreditation for a successful run 2. This is suggested because Measures will not report the results of a Racer’s run 2 if they DNS’d, DNF’d or DSQ’d Run 1. This is of course “FIS” rules.

2.  Installing the BestOf:

a.   If BestOf is already installed on your computer and you wish to install a new version make sure to uninstall the old version first. To do this Click on

i.  Start > Control Panel > Add/Remove Programs ii.  Click on ‘BestOf’, highlighting It, then Click on the Uninstall Button

b.  Once BestOf is uninstalled, Close the Add/Remove Programs screen by clicking on the “x” in the top right hand corner.

c.   To install the Utility, Open the Folder “BestOf Install” on the Measures CD or the Folder in which you unzipped the e-mailed zipped file BestOfxxx.zip (where xxx is the version).

d.   Once the folder is open simply double click on the setup.exe file and follow the instructions.

3.  Running BestOf:

a.   Once the Utility has been installed on the “SAME” computer that is running the “Measures” software, the program can be run by Clicking on:

Programs -> Measures -> BestOf

i.  Simply Click on preferences to change to “French” if you so desire.

ii.  Click on “Calculate Best Of” – the following window is displayed:

b.         Click on ‘Calculate Best of’ at top of window.  The following Utility Query is displayed

i.  SEVERAL will create subtotals of multiple results and produce a Total of these subtotaled results

ii.  SINGLE will produce either the BestOF result with a Total of all runs or just the best run.

Choose either SEVERAL(see paragraph 8) or SINGLE (see paragraph 10)

4. SEVERAL BEST OF RESULTS – SINGLE RUN RACES:

Click on the “SEVERAL” Button (if you wish to say, get the Best 1 of 2 One Run Races made in the morning and subtotal it, then get the Best 1 of 2 One Run Races made in the afternoon, then Total the two subtotals. What you are actually doing here is picking the best run made in the morning and the best run made in the afternoon then summing these two runs together to get the Total for each racer).  The following Utility Query appears:

Click on the number of BestOf Results that you wish to subtotal.

Following are several examples of reports that can be run.

Several Example 1:   In the “SEVERAL” figure above you would depress the [‘2’] Button.

• Runs:  4 – 1-run SGs
• Subtotals – 2 (1 after each 2 runs)
• Report Result:  Total of all 4 runs

Click on ‘1 Totals’. Use this when analyzing one run races or the total time of two run races.  The following query is displayed:

Enter the number of races the results are to be based on – in this example I have entered 2.  Click ‘Okay’.  The following query is displayed:

Enter the number of races to include in the Best of Total.  In this example, it is 2.  Click on ‘Okay’.  The following query is displayed:

Find the first Race File and select it.  Click on ‘Open’.  The following Query is displayed:

Find the second Race File and select it.  Click on ‘Open’.  The following query is displayed:

Click on ‘Okay’.  The following query is displayed:

Click on ‘1 Totals’ for 1-run races.  The  following query is displayed:

Enter the number of Races the Results are to be based on.  In this example, it is 2.  Click ‘Okay’ and the following query is displayed:

Enter the number of Races to include in the Best of Total.  In this example, it is 2.  Click on ‘Okay’ and the following query is displayed:

Select the first race file.  Click on ‘Open’.  The following query is displayed:

Click ‘Okay’ and the following Query is displayed:

Select the second race and click on ‘Open’.  The following query is displayed:

Click ‘Okay’.  The following query is displayed:

Select where you want the .csv file to go.  Name the file (ie:  Best of 1 Run Test) and click ‘Open’.  The following query is displayed:

Click ‘Yes’.  The following query is displayed:

Click on ‘Okay’.

Following is an excerpt of the .csv file that was created.  (opened with Excel):

Several Example 2:

• Runs – 2 1-run SGs

• Subtotals – None

• Report Result – Best run of the 2 runs

Click on Several, and the following is displayed:

Click on ‘1’, and the following is displayed:

Click on ‘1 Totals’, and the following is displayed:

Enter 2 and click on ‘Okay’.  The following is displayed:

Enter 1 and click on ‘Okay’.  The following is displayed:

Select the first race file and click on ‘Open’.  The following is displayed:

Click on ‘Okay’.  The following window is opened:

Select your second race file, and click on ‘Open’.  The following window is displayed:

Click ‘Okay’ and the following window is displayed:

Name your .csv file and select where to save it.  Click ‘Open’ and the following window is displayed:

Click ‘Yes’ to create a new file; and the following is displayed.

Following is an excerpt of the file created:

Several Example 3:

• Runs – 4 1-run SGs

• Subtotals – 2 (1 after each 2 runs)

• Report Result – Best time of either subtotal 1 or 2

Click on ‘Several’.  The following window is shown:

Click on ‘2’ and the following window is shown:

Click on ‘1 Totals’ and the following is displayed

Enter 2 and click on ‘Okay’ and the following is displayed:

Enter 1 and click on ‘Okay’ the following window is displayed:

Select the first race and click on ‘Open’ and the following window is displayed

Click ‘Okay’ and the following window is displayed:

Select the 2^nd race and click ‘Open’ and the following is displayed:

Click on ‘Okay’ and the following is displayed

Click on ‘1 Totals’ and the following is displayed:

Enter 2 for the 2^nd best of sub total and click on ‘Okay’.  The following window is displayed

Enter 1 for the number of races to be included in the best of total – 2^nd best of subtotal and click on ‘Okay’

Select the 1^st of the 2^ndraces and click on ‘Okay’, the following is displayed:

Click on ‘Okay’, the following window is displayed:

Select the 2^nd run and click ‘Okay’.  The following window is displayed:

Click ‘Okay’ and the following window is displayed:

Name your .csv file and select where to save it.  Click ‘Open’ and the following window is displayed:

Click ‘Yes’ to create a new file; and the following is displayed.

Following is an excerpt of the file created:

Several Example 4:

• Runs – 4 1-run SGs

• Subtotals – None

• Report Result – Best of 4 runs

Click on ‘Several’.  The following window is shown:

Click on ‘1’ and the following window is shown:

Click on ‘1 Totals’ and the following window is shown:

Enter 4 and click ‘Okay’, and the following window is shown:

Enter 1 and click ‘Okay’, and the following window is shown:

Select Race 1 and click ‘Open’, and the following window is shown:

Click ‘Okay’ and the ‘Open Race File window is displayed.  Select the next 3 races and the following window is displayed:

Note that I have selected 3 DH’s and 1 SG.  Click on ‘Okay’ and the following is displayed:

Name the file and click ‘open’ to save the file and the following is displayed:

Click ‘yes’ and the following is displayed:

Click ‘Okay’ to finish the report.

Following is an excerpt of the file created:

Several Example 5:

• Runs – 6 1-run Races

• Subtotals – 3 (1 subtotal after every 2 races)

• Report Result – Grand Total of all 6 races

Click on ‘Several’.  The following window is shown:

Click on ‘3’ and the following window is shown:

Click on ‘1 Totals’ and the following window is shown:

Enter 2 and click ‘Okay’.  The following is displayed:

Enter 2 (this will give a total of both races) and click on ‘Okay’

Select the first race and click ‘Open’

Click ‘Okay’ and select the second race and click ‘Open’

Click Okay:

Click ‘1 Totals’ and

Enter 2 and click ‘Okay’’

Enter 2 and click ‘Okay’

Repeat for 3^rd^ best of sub total

And save .csv file

Following is an excerpt of the file created:

9.        SEVERAL BEST OF RESULTS – 2 RUN RACES:

Example 1:  Several 2-Run Race

• Runs:  2– 2-run GSs

• Subtotals – 2 (1 after each 2 runs)

• Report Result:  Total of all 4 runs

Click on ‘Several’.  The following window is shown:

Click on ‘2’ and the following window is shown:

Click on ‘2 Runs’ and the following is displayed

Enter 1 and click ‘okay’

Enter 2 and click ‘okay’

Select the first race and click ‘open’

Click ‘Okay’

Click on ‘2 runs’

Enter ‘1’ and click ‘Okay’

Enter 2 and click ‘okay’

Select the 2^nd race and click ‘open’

Name the .csv file and select the desired directory and folder.  Click ‘open’

Click ‘Yes’

Click ‘okay’

Following is an excerpt of the .csv file produced:

Example 2:  Several 2-Run Race

• Runs:  2– 2-run GSs

• Subtotals – None

• Report Result:  best time of the 4 runs

Click on ‘Several’.  The following window is shown:

Click on ‘1’ and the following window is shown:

Click on ‘2 Runs’ and the following is displayed

Enter 2 and click ‘okay’

Enter 1 and click on ‘okay’

Select the first race and click on ‘open’

Click on ‘okay’

Repeat the above 2 figures for the second race

Name the file and select the desired directory and file folder.  Click on ‘Open’

Click on ‘Yes’

Click on ‘Okay’

Following is an excerpt of the .csv file

10.       SINGLE BESTOF RESULTS:

Click on the “SINGLE” Button (if you simply wish to get the Best 2 runs of 4 One run Races. In this Case it simply picks the best 2 One Run Races and Totals them, They could be both from the morning, or both from the afternoon or One from the morning and one from the afternoon.)

Single Example 1:

• Runs – 3 1-run Races

• Subtotals – None

• Report Result – Best Run of the 3

Click on ‘Single’ and the following query is displayed:

Click on 1 Total when analyzing one run races or the total time of two run races.

Enter the number of race results the report is to be based on and click ‘Okay’

Enter the number of races to include in the best of total (can be between 1 and 3).  Click on ‘Okay’

Select the first race file and click ‘Open’.  Repeat for the number of races you have selected above.

When you above window indicates the desired number of races – click ‘Okay’

Name the .csv file and select the file folder you want to save it to and click ‘Open’

Click on ‘Yes’

Click ‘Okay’

The following is an excerpt from the .csv file

** ‘SINGLE’ Example 2:**

• Runs – 2 1-run Races

• Subtotals – None

• Report Result – Grand Total of all 2 races

Click on ‘Single’ and the following query is displayed:

Click on 1 Total when analyzing one run races or the total time of two run races.

Enter the number of races to be included in the report – 2 and click on ‘Okay’

Enter the number of races to include in the best of total – ‘2’ and click ‘okay’

Select the first race and click ‘open’

Repeat the above 2 steps for the next races

When all the races have been loaded click ‘okay’

Name and save the file to the desired folder and click ‘open’

Click ‘Yes’

Click ‘Okay’

Below is an excerpt from the .csv file

Description of the Excel “csv” File:

1.     The “csv” file that was produced by the “Best Of” utility can be opened in Excel by simply double click on the file.

2.     The File will have the following columns:

a.      Contains the Bib Numbers that the Racer had in the “Last” Measures File Loaded. b.      Contains the Racers Name c.      Contains the Racers “Card Number” d.      Contains the Racers Category (ie: U 18, U 21) etc as shown in the “Last” Measures File. e.      Contains the Racers “Nation or Division”, if present in the “Last” Measures File. f.       Contains the Racers Club Name, if present in the “Last” Measures File g.      Contains the first Races Totals or the First Run Times of the First File h.      There are as many columns of the above information as there is Races or Runs. i.       The Next Column will contain the Total or Subtotal of the “x” Best Races or Runs. j.       If “SEVERAL” was chosen then the above will be repeated the number of times request and then one last column will be added with the Total of all of the subtotals.

Suggestions for Cleanup of Excel:

1.  Once the file is opened it is suggested that the following cleanup actions be taken:

a.      It is recommended that each column that contains times be formatted as numeric with 2 digits of decimal places. This can be done in the following manner:

i)      Click on the Header letter of the first time column, then slide the horizontal slide bar at the bottom of the screen to the right until the last column containing data is visible, holding down the shift key, click on the Header Letter of the last column that contains data. This should highlight all of the columns that contain time data.

ii)     Release the shift key.

b)    Click on the word “Format” at the top of the screen c)     Click on the word “Cells” in the drop down from the “Format” command d)    In the drop down box that appears Click on the word “Number” e)     Make sure that the “Decimal Places” contains “2” and click on the “Ok” button f)     This will format all of the data columns to be numeric with 2 decimal places.

b.      Double click on the vertical bar between the header alphabetical characters. In other words, place the cursor between the “A” and the “B” on the “|” between them and double click. This will size the “A” column. Continue to do this on the vertical bar “|” between every column, thus sizing each column to the data that is contained within it.

c.      It is suggested that you save the spread sheet by clicking on the “File” command then the “Save As” command. Change the “Save as type” to the first entry in the drop down list. It is “Microsoft Excel Workbook (*.xls)” (NOTE: To find this entry, slide the vertical slide bar, that appeared, to the top). Once this is chosen click on the “Save” button.

d.      It is recommended that you add whatever Titles etc you wish too then click on “File” then on “Save” to save your changes. KEEP IN MIND that once you have exited the spread sheet you will need to double click on the “xls” file not the original “csv” file in order to see the changes that you have made.

e.      In order to print the entire spread sheet it is suggested that you click on the blank space that it to the right of the “A” column header letter and above the “1” of the row counter. This will highlight the entire spread sheet. You may then click on file “File” then on “Print Area” and on “set print area”. If you now click on “Save” the print area of the entire spread sheet (that contains data) will be set for future prints. You may now click on “File” and then “Print”.

6.     Click on the  “Ok” button to print your spread sheet to the printer.