Excel Based Bullseye Competition Scoring Program

by Edwin C. Hall

Back to Homepage

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
• 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 Indoor and Outdoor BE Score Cards 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 supersede items earlier in the document.

Download Bullseye2018.xlsm (apprx 350k)

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