a Taj MuttHall Dog Diary: Fun With Databases

Tuesday, May 08, 2007

Fun With Databases

SUMMARY: Tika and I are improving; the data proves it.

At each of the last five trials, Tika has come home with at least one new USDAA title. That reflects two things: one, we're right in the numbers where we just need a couple of legs here and there to fill in some of those titles; two, we're actually getting Qs more consistently. In fact, we're approaching a 50% Q rate over the last year.

Got me a-wonderin': It seemed like ages and ages between legs for Tika for the longest time. How long WAS it? So I turned to my handy-dandy database of all of my runs, ever, in agility, and figured the following about Tika's Masters level runs:
  • The first ten Qs took 62 tries over 12 months. (The length of time, of course, is somewhat reflective of how many trials are available and that we attend.)
  • The second ten Qs took 50 tries over 8 months.
  • The next ten took 31 tries over 4 months.
  • The next 10 took 21 tries over 4months.
  • The next 10 took 25 tries over 6 months. (oh--that included several runs where I couldn't run worth beans because of my knee and several more where we tried having Ashley run her and she'd have none of it. So these numbers are a little skewed.)
  • The next ten took 22 tries over 2 months.
  • This last weekend, we got another 5 out of 9 tries.

I like the way the numbers are going.

But it's going to be a while for more titles, most likely, because we're now entering the gap between 15 Masters legs per class (Bronze title in each class) and 25 Masters legs (Silver titles) per class. That's a lot of Qing for us. Although we could finish our Tournament Silver the first weekend in June if our re-reformulated team manages a DAM Team Q.

But here's what really intrigues me: My impression was that, of all those missed Qs, we've missed a million legs by single knocked bars or missing the dogwalk up contact--but no! Only 17 were single knocked bars, and 4 missed dogwalk ups! We've had combinations of those, and those with other faults, but our single-fault non-Qs aren't as many as I had thought.

However, if you toss in Grand Prixs... another 4 one-bar runs, another seven dogwalk-up-onlys. Huh--wonder what it is about the GPs and our dogwalks? Go figure.

Meanwhile, I'd love to have the consistency of Luka and Ashley, who have now won every major AKC event this year. Sucks that Norway won't let them in to be on the US World Cup Team because of her docked tail. We'll have a big celebration in class Wednesday night, though, I'm sure, for this latest win at the Tryouts. And I'll just have to keep remembering that I'm not Ashley, I'm me.

2 comments:

  1. I think you sent me a link at one time to your database spreadsheet (or am I imagining things?). I don't know where I put it and wondered if you could send it again: Cedarfieldagility@yahoo.com.

    I'd love to figure out if Jaime and I are actually improving or if it just seems that way. I've been aiming for 50% Q rate and don't think I've reached it yet so congratulations on that.

    ReplyDelete
  2. I use a Filemaker Pro database that's not really ready for prime time. It's got a lot of kludges in it and also Filemaker itself has some quirks that I know how to work around but would be hard-put to express.

    I do have a Word tracking sheet with columns in which to put just about every bit of data one could want to know, and I fill out one of those per show and then use that to put it into my database, but you could just use it to write down everything, keep them in a binder, and then look back through it for info. I can send that to anyone if you send me your email address (send to elf (at) finchester (dot) org).

    -ellen

    ReplyDelete