Excel 5.0 Based Bullseye Competition Scoring Program

by Edwin C. Hall

Note: Do not rename the program. This program uses macros which it cannot find if the program is renamed.

Description

This Excel package was designed to provide a basis for 2700 "Bullseye" competition management. This package is capable of tracking up to 998 competitors. (Actually, it can track far more than 998 for everything except awards.) It is not a commercial program, however it runs under Microsoft Excel, which is a commercially sold product. This version will display results for all matches through the Grand Aggregate. The order of matches is 22 Slow Fire through the Grand Aggregate patterned after an outdoor competition (2700). For the Sub Aggregate (.22, CF, .45) results, the preceding matches for that gun are also shown. In addition to the scores being tallied, the application also finds the Open (W)inner, (S)econd and (T)hird overall (if opted) and the place awards for each class grouping, based on decisions made on the "Options" sheet. For those familiar with Microsoft Excel, the results as well as other items, can be further groomed to fit most needs.

Features

Maintains a running file of all previous competitors (as long as you save it)
Finds stored competitors by last name or number
Shows the three most recent times a competitor has entered your matches
Small enough to run from one HD floppy
Creates final results suitable for printing
Creates report for sanctioned matches
Steps through rule checks to break ties
Calculates an award schedule which can be adjusted
Allows adjustable class and category combinations
Ranks shooters by scores within grouped categories
Finds winners of special categories like Junior, Senior and Woman
Automatically adds competitors addresses to a separate sheet for match mailing
Includes a Team Sheet which can be copied and pasted for additional teams
Includes Sheets for an EIC Score Card, BE Score Cards and a CMP Affidavit for printing
Includes a Sheet for SR1 Card printing - can be filled in from the shooters list

Be sure to check the "Changes" section at the end of the documentation. Some items in the changes section supercede items earlier in the document.

Download Bullseye.xls (apprx 660k)

Download Bullseye.xls (zipped) (apprx 160k)

Download BullseyeRifleVersion.zip (zipped) (apprx 165k) - Modified for Rifle Matches