In the links below Steven Symansky is providing Excel files for scoring PC rallies and for USEA horse trials. These programs have received some testing but Mr. Symansky is not responsible for the results.The programs are being provided as a service to the equestrian community by Mr. Symansky. There is no charge. However several words of caution

• The PC rally programs were written for the Virginia region rallies. Since different regions run their rallies differently, your rally may not conform to the way these programs were set up
• You need to read the instructions before using these programs. Instructions have been included as a separate worksheet in each file. However, some of the instructions may need to be updated.
• These programs have been rewritten in 2007 but have not been tested. You need to test these programs before using them especially since Mr. Symansky has not scored a rally for several years and has never scored a SJ rally. He can say this strongly enough. TEST TEST and TEST before using at a rally.
• Even though familiarity with Excel is not needed, invariably something goes wrong and it helps to have someone that understands Excel to work with these programs.
• THe Horse Trial scoring program was updated in 08 for improvements and to incorporate rule changes.
• The major area for caution is when there is no ride. A blank space is different from a delete and can affect the mathematical operations
• Mr. Symansky is willing to fix problems. Therefore feel free to contact him by email as questions or issues arise. (ssymansky@imf.org)
• Each rally is contained within a WINZIP file. It has a blank file as well as ones with numbers in them. The numbers that are used are fictitious and in some cases do not even conform to plausible scores
• For PC rallies, written tests are included but added at the end of a scoresheet. The program works fine even if no written tests are given since it just adds or subtracts 0's as appropriate. However individual scores do not include the written test, but a column was added at the right of the score sheet to show individual scores with written tests.
• In most cases, scores are only entered in yellow cells. These are then manipulated and transferred to the actual score sheet. This is necessary to handle ghost scores as well as jumpoff rounds.
• Each program was developed at a different time and therefore even though there are similarities, the logic is different in each program

When you click on a link below, you will be prompted to save or run the attached file. I suggest saving and then unzipping the files. Remember where you save it and hopefully you have WINZIP in order to unzip these files.

Dressage rally: Assumes three dressage rides per individual but will work fine if only 2 rides. Allows for up to 2 musical rides per person. It does not allow for tests of choice. New dressage tests are included dressage rally file (date of posting - 3/20/07) (Updated 6/2 to fix error with 3rd level and to ensure mistakes are not made with imputting Eliminations)

SJ rally: Mr. Symansky has never scored a SJ rally but the program has been used. You need to fill in all HM and all rounds even if not ridden ( put all zeroes in). Note that you need to use "pivot" tables for jumpoff rounds. It is not as hard as it sounds. You enter scores, and then "refresh" the pivot table and the program awards the points.SJ rally file (date of posting - 3/20/07)

Eventing Rally: The key is to put in the right parameters (dressage test, if XC time is counted, XC distance etc). The program allows for XC time to be included or excluded Eventing rally file (date of posting - 3/20/07) UPDATED 4/2/07 - several errors discovered; New files added 6/2 to allow for teams with combined levels on same team)

USEA Horse Trial: This is the most widely used and tested program. About 15 USEA HTs use this program every year. It even creates all the USEA and USEF paperwork needed after the HT is over as well as HTML for posting results .USEA HT file (date of posting - 3/20/07) UPDATED 4/2/07, 5/8/07, 5/22/07, 6/27/07, 7/9/07, 9/09/07 and 6/1/08- several small errors and bugs discovered as well as some additional programming and improved instructions)

Please feel free to email Mr. Symansky (ssymansky@imf.org) as issues arise