A British Agility Record Book Program … thing.

I was up very late last night, and for whatever unknown reason I thought how good it would be to have a British version of the Agility Record Book program. It would work out your Agility Warrant points and your BAA League Table points (and probably your UKA titling points as well) and would be a wonderful computerised way of keeping track of your dog’s progression.

And then I read that the advanced Agility Record Book program had originally started as a MS Excel Spreadsheet, and my sleep-deprived brain thought “ah! I can work with Excel! It will merely be a matter of throwing together some If Statements and VLookup tables and we’ll be off! How hard can it be?!”

Remind me never to say that again.

Still, 14 hours later and I have a working prototype running. It currently calculates BAA League Table Points and Agility Warrant points (including different points for the different BAA levels and different AW points for agility/jumping classes) depending on clear round places. UKA might take me longer because I don’t really know how their system works, but that’s project for next week. And then I’ll try and add some kind of Calender, although I don’t really need that because there’s the online Agility Organiser which is far better than anything I could come up with!

Although I originally intended this to be for personal use (I’m a geek, I like to keep track!) would anyone be interested in downloading a more polished version? If so, what other stuff would you like available?

Currently the format is pretty simple, and only works for one dog:
Sheet 1 = Dog Information (Call name, registered name, breed, DOB, registration number(s), grade/level)
Sheet 2 = Show Records
Sheet 3 (Locked) = Points Tables

Obviously it would be good to have it work for more than one dog, and I have got the foundations of that in there but I haven’t quite worked out which is the best way to do it yet.