Great British F Class Rifle Association

Case Study -

GBFCA

Automating Competition Scoring, Rankings and Results with Excel

The Issue

The Great British F Class Rifle Association needed a more efficient way to calculate and rank competition scores for up to 250 competitors, each firing 20 shots per match across 12 matches over 3 days.

The process was previously managed manually, including complex countback calculations to determine rankings where competitors achieved identical scores. This involved comparing their final shots and working backwards, shot by shot, until a difference was identified. The same process was required for daily aggregate scores, making the task extremely time-consuming and prone to human error.

The Solution

Excel Ace developed a bespoke Excel-based scoring system that automates the entire process. Now, organisers simply enter each competitor’s individual shot scores, and Excel instantly calculates their match totals, rankings and any necessary countbacks.

The system also automatically generates daily and overall competition aggregates, including countbacks, eliminating the need for repetitive manual calculations.

A live scoreboard displays up-to-date rankings throughout each match, allowing competitors and spectators to see results almost instantly.

At the touch of a button, organisers can also generate PDF result sheets for quick and easy circulation.

The result is a faster, more accurate and streamlined scoring process, significantly reducing the administrative workload and allowing organisers to focus on running the competition.

How it was built

Data Validation
VBA
Tables
Linked Files
Conditional Formatting
Filters
Protect Sheet

Formulas: IF, OR, XLOOKUP, XMATCH, TEXTJOIN, SORT, FILTER, SEQUENCE, ROUND, TAKE, CHOOSECOLS, BYROW, COUNTIF, SUM, RANK.EQ, INDEX, SUMIF, CONCATENATE, SORTBY

What Richie Says

Our automated scoring system built by Excel Ace has completely revolutionised how efficiently we can deal with large volumes of statistics at our competitions. Before we had our system, aggregating scores and manually processing endless numbers of countbacks was a massive headache for our stats team, extremely time consuming, and prone to an element of human error.

Excel Ace stepped in and engineered a flawless, custom solution for our needs that now automates the entire process in real-time.

The software is incredibly fast, intuitive, and gives our stats team and competitors instant and accurate insights into their scores and overall rankings throughout any day of competition. It has saved my team countless hours of administrative work and elevated the overall professionalism of our events.

If you’re searching for a system to help streamline your statistics, look no further than Excel Ace.