Sunday, April 17, 2011

Excel Spreadsheet for Agility Competition Records

Maxie clears the 8" tripple
on a beautiful QQ day.
Photo by Michael Loftis
Finding myself far behind in hand copying Maxie's records into his Agility Competition Recordbook, and realizing I need a second book for Lucky, and I'm doing more trials this year than last, I decided to scratch that inefficient, labor-intensive plan.  Besides which, it doesn't calculate.   Instead, I've been working on an Excel Spreadsheet to more easily keep track of all their runs, including all the stats.  It's taken me 3 days to scrounge up all the ribbons with their sticky tags on the back, find all the emails reporting my Trial Results and the photos I've taken at the trials of my "unofficial results" (which contain important fault data), etc., get them in chronological order and compile all this info into one place, plus devise formulas to let the program calculate things like Yards Per Second, Seconds over/under Course Time, etc.

Is my dog running faster now than last year?  Faster in cold weather? Does the score reported to AKC tally with the info given (it doesn't always, I've notice!  Those who tally the data make mistakes.) There's a place for such comments in the right column of each run.

Here's a tiny pic below of Page 1 so you can see the layout.  It prints on an 8.5 x 11 sheet.  Blogger doesn't allow me to upload a .pdf file at this point, in full size. I wrote them about that.

If anyone wants this form, let me know and I can customize a spreadsheet for your dog (Dog's name, typical # of runs per trial, etc.).  It would take me a few hours, so about $30 to work it out and email it to you.  All you need is Excel 2007 or higher on your computer to open and use the file, but you may have to further customize for each additional dog, so some familiarity with Excel is probably necessary. 

Or, for free, I can send you a blank page, headings only, and you can fill it in by hand, which is still labor intensive but far less so than flipping pages in the Agility Competition Recordbood.  And, you get to see your dog's career, Q's and Titles spread out on one page.  It's neat.  Just email me your request.

Upwards and onward!

1 comment:

Cynthia said...

if you google Agility Record Book ( it's a really neat software that runs on both Windows and Mac and it's free! It even tells you your percent of Q rate. :) I love it. This is not spam, I'm an agility competitor and I love this software! :)