Well, I'm in the glorious data cleaning stage. I entered all the tests and comments and now it's time to clean the database and enter some additional information that I want in it, as well as check any issues I found.
Several things have come up in this process (and there's more to come). I had two tests where the entry information was hand-entered and they didn't put the ride time. Luckily both of those times could be derived by another test I did that day (and knowing what order the tests went in) so I estimated it by putting it 45 minutes away from the other test. I'm mostly interested in AM vs PM rides so it shouldn't be a big deal.
I'm also definitely missing my Silver Medal test!! Bummer, all I remember about it is that I got 5s on both of my voltes because I made them too large. I am also missing TC's one Second level test, which sucks too, I'm sure that one is somewhere nearby though. I'll look out for them but it's just two tests, so that's okay.
 |
How many tests were ridden in a tophat? No idea! |
Onto the fun stuff, results! I haven't run any interesting statistics but I did do a bunch of counts, and here is what I know so far:
I have 110 dressage test sheets, but that's not how many tests I've ridden. Some of those tests had two judges for one ride so I'm guessing my actual test count is around 100. That's pretty cool! I'll calculate the actual number eventually.
I have ridden at 41 rated dressage shows! I suppose it's 43 because of my missing tests. I did not count shows at the same facility over two days with different shows per day (for qualification purposes) because I thought it was silly to do, so I guess technically I've done more shows. But that's 42 weekends I've given up in my life for this sport.
 |
| So many pets for all the horses |
I've ridden for 42 different judges in my life! That's pretty cool. Three of them I've taken lessons from (after they were my judge), two of which were in my L program as instructors, and two pairs of them are parent-child relationships (like I rode with a judge and that judge's parent) at least that I know of. Nine of them are male and the rest are female.
I will change this when I figure out the double tests but here are the number of test sheets I have per level/test:
Training Level Test 1: 2
Training Level Test 2: 7
Training Level Test 3: 13
Training Level Test 4: 9
First Level Test 1: 13
First Level Test 2: 9
First Level Test 3: 6
First Level Test 4: 6
Second Level Test 1: 2 + 1
Second Level Test 2: 2
Second Level Test 3: 5
Second Level Test 4: 5
Third Level Test 1: 4
Third Level Test 2: 2
Third Level Test 3: 8
Fourth Level Test 1: 3
Fourth Level Test 2: 2
Prix St George: 4 + 1
Intermediare I: 1
Intermediare II: 2
Grand Prix: 3
Obviously some of these are skewed. The double tests are messing us up for sure. Plus, there are no more test 4s so at Training through Second, I used to do the 3rd and 4th tests more than the first two. And then some tests are just stupid and shouldn't be ridden (the new Third 2, Fourth 3) and so I avoided them. You can also see that I have primarily ridden at the FEI levels when I've been fairly tight budget-wise, so I was very selective about my shows and how much I showed. So I don't think this is useful data, but it's interesting.
 |
| Baby Rico and baby Megan |
My average score per movement is a 6.5, that's pretty cool. My average test score is 65.92% so that tracks.
Per horse, here are their average scores (I excluded Leo because I only did like four shows on him):
Larkin: 66.80%
Rico: 64.64%
TC: 68.85%
Well if that doesn't show improvement, I don't know what does!
Here are my top 5 scores:
75.83% on Larkin at Training 3 (Damn I should have celebrated this more).
74.23% on Larkin at Training 4 (same, seriously!).
73.44% on TC at First 2 (I did celebrate the crap out of this).
73.98% on Larkin at Training 4 (didn't know how good Larkin really was lol).
72.69% on Rico at Training 4 (Rico and I were really well spread score-wise).
 |
How many tests did I smile walking out of? No idea, but this was when I got my Silver medal, I knew I had the score because the test was pretty good
|
Here are my bottom 5 scores:
54.26% on Leo at Grand Prix (Leo was kind of off coming into this test so it was a disaster, as one's first Grand Prix almost always is!)
59.12% on Rico at First 2 (I hurt my back at this show and went off course twice in this test).
59.44% on Larkin at First 4 (Larkin was very tired).
59.53% on Rico at Third 3 (Half the letters blew down so Rico wouldn't get near the rail on one side lol).
60.00% on Rico at First 1 (no idea!).
My horse's average gaits scores are a 7, haven't separated them by horse but I'll be curious to know that!
Average impulsion is 6.6. Average submission is 6.4. Average rider position is 7.3. Average rider effectiveness is 6.9. Now, those rider scores are fairly new. My average rider score when it was just one score was a 6.7. So I've definitely looks like I improved my rider scores even if it doesn't seem like I have!
 |
How many shows in the double? Also not sure!
|
The next thing on my to do list is to hand enter every movement for every test I've done and categorize the movements. I was doing it at the same time as entering the scores and it was killing my soul so I left it for future Megan. Future Megan here, kind of regretting not doing it at the time but that's how it goes!
After that it's just making sure that everything is ready to be loaded into the database/into the dashboard. I have a rough idea of some of the pages I want to have in the dashboard but I usually just get in there and play around.
I don't actually need to put it into the database to make the dashboard, but I do if I want to run any additional statistics, which I do! I'm not sure what exactly I'll be doing, that's why the dashboard will be nice, I can play around in there and come up with some hypotheses and then test them statistically. I'd love to do things like hold certain variables statistically constant or compare movements with one another across horses. It won't be anything too exciting but that's okay!
 |
How much does my shadbelly cost per ride? Don't want to know! |
Hopefully the next update will be a dashboard! Or maybe just more of this, who knows. I'm trying not to burn myself out with this project but I am also really eager to get it off the ground.