My Points System

Every time I share pictures of my collection Instagram and Facebook and talk about their average points I get questions about my points system, so I thought I should do a quick blog post about how I work out the points for each of my horses.

The Points

Let's start off very simply with the points. Each placing that a horse can get is allocated a number of points. The points get higher the better the placing. Below is how many points each placing is allocated.

Overall Champion = 100

Overall Reserve Champion = 85

Overall Reserve to Reserve Champion = 70

Section Champion = 50

Section Reserve Champion = 40

Section Reserve to Reserve Champion = 30

Champion = 25

Reserve Champion = 15

Reserve to Reserve Champion = 10

Top 10 = 25

Best of Breed/Group Winner = 8

1st Place = 6

2nd Place = 5

3rd Place = 4

4th Place = 3

5th Place = 2

6th Place = 1

Points are doubled for shows which the horse had to qualify for (BMECS/BILS/MECS/LEMS/Southern Champs/Northern Champs/NAN)

Here is a handy image that you can save/pin/print off for quick reference!

Keeping Records

So how do I keep the records?

All placings are written into a PowerPoint presentation. There is a slide with basic information about the horse and then a slide for all of their placings. Here is the one for CRS Fiery Rose:

In terms of keeping a record of points I have this recorded on my massive horse spreadsheet.

You can see the points in the end three columns:

First Column = Total Points

Second Column = Number of shows attended

Third Column = Average Points (Points/Shows Attended = Average)

The formula you will need for column three is very simple it is just: =AF30/AG30 (enter the columns you are actually using)

I use filters on the top of each column for sorting which allows me to sort the average column from highest to lowest. This lets me know who my best horses are.

It's worth noting that my records have been developed over 20 years, if I was starting from scratch now I probably wouldn't have the PowerPoints and would instead record individual show records on Excel and have it work out total points for me, but I'm not re-doing the whole thing! I already don't have every horse in the massive horse spreadsheet because I only started this about 10 years ago!

Average or Total?

The next point is whether you work out your best horses by average or total. I used to use total points but increasingly it meant that horses that had been to more shows were obviously always classed as the best. This works fine for your first few shows as a new hobbyist but I recommend going for average long term.

If you look at the list above you can clearly see this, the second horse down has over 1000 points total but I've owned him for quite some time! The one above only has 128 points but I only got him 2 years ago. That's why average works out as a fairer and more accurate record of how well horses have done.

If you want a template for the massive horse spreadsheet please just shout. Free downloads don't work on the new website but I'm working on a category of free downloads that you can 'order' the same way as a paid for digital product but obviously it is free!

Show String Rankings: How To

 When you've been showing for years it often becomes hard to identify which are your best and worst models. Sometimes you probably feel like you take the same models to every show and although you feel like they are your best they aren't actually doing as well as you would like.

So today I'm going to share with you a quick and easy way to rank your horses and get a good picture of who is still succeeding and who is falling short. All you will need is MS Excel (or similar) and a bit of time and patience.

Scoring System

The first step is to create your own scoring system. You will need to allocate a number of points to each of the different awards your models can win. How many points you award is up to you but it needs to be consistent.

My points system is below: 

Overall Champion = 100
Overall Reserve Champion = 85
Overall Reserve To Reserve Champion = 70

Section Champion = 50
Section Reserve Champion = 40
Section Reserve to Reserve Champion = 30

Top 10 = 25

Champion = 20
Reserve Champion = 15
Reserve To Reserve Champion = 10

Best of Breed/Group Winner = 8

1st Place = 6
2nd Place = 5
3rd Place = 4
4th Place = 3
5th Place = 2
6th Place = 1

I also double my points for BMECS/NAN placings.

Now you have a scoring system in place you are ready to start your spreadsheet and start ranking.

Setting Up Your Spreadsheet

Set up a spreadsheet with columns as follows:

1. Horse's Name

2. Points

3. Show's Attended

4. Average

To work out the average points you will need to enter the following formula into D2

Now you can go about populating your spreadsheet. This is going to be extremely time consuming if you have been showing for years and just starting out so maybe try to aim for a year a week or something similar!

Start by recording the total points for every horses in Column B

Next go back over your show lists and record the total numbers of shows each horse has attended in Column C

Important Note: Even if a horse has zero points if they have attended a show you will still need to make a note of this.

You should notice that column D automatically populates with the average points.

You should end up with something like this:

I have applied filters to make organising easier! You can do this under the 'Data' tab.

Sorting Your Horses

You can now sort your horses by two main methods either their total points or their average points. To illustrate the difference between the two look at the list of my top OF horses. The first is sorted by total points:

And the second is sorted by average points:

You will see the two lists are very different. One of the reasons you want to use average points over total points to see your top horses is that if you have a model that you have been showing for years (like Bushka for example) they will have a LOT of points and it will be hard for newer models (like Sultan for example) to make their way onto the list. Look at how many shows Bushka has attended compared to Sultan! Using average points therefore allows you to ensure that new horses that are doing well fit into your show string and old horses that maybe did well in the past but haven't placed in years drop out.

Final Tips

The final thing I would say is try to split by finish, that way you know your best horses for each finish:

I have also started linking these into my Massive Horse Spreadsheet. This means that I can sort by things such as make, scale and breed to tell you who my best OF Arabian or best CM Thoroughbred is. This is really helpful when it comes to specialist shows.