Scoring TICA Title and Regional Points
Excel Spreadsheet Directions

This spreadsheet can help you to keep track of the points your cats have won, both for titles and for regional/international awards. It is an Excel v7.0 (from Office95) spread sheet, originally written on a Wintel PC clone running Windows95.

The URL to download the spreadsheet is:

http://www.lunarcoons.com/scores.zip

Save the file scores.zip to a temp directory on your PC's hard drive. The file needs to be decompressed using PKZip or WinZip (available on the net for free in many places) to obtain the file scores.xls.

The spread sheet requires some basic working knowledge of the Excel spread sheet program. My advice is once you've decompressed the file scores.xls, make a copy and play with it for a while to get the feel of how it works.

Enter the name and reg number, sire/dam and owner/breeder of your cat. Then, for each ring your cat competes in, enter the date, catalog number, the club name, the judge's name, type of ring (AB or SP). There are some dummy rings I've entered already, simply overwrite them. As your cat gets shown throughout the season, it will be necessary to copy the row for an already entered ring, insert the copied row at the end, and then overwrite this copy with the new ring's information.

There are four sets of three columns each to enter information required to calculate the scores for final awards, breed awards, division awards and color awards. You need to enter the place (not the points) your cat received for each category, and the count associated with each category. Each of these four categories has a "Score" column. This column contains the formula used to calculate the appropriate number of points. The program handles all of the arithmetic involved, and the result will automatically appear in the box. Important note: Don't enter anything in the Score columns, it is automatic.

The last five columns are Ring Score, Cumulative, Cumulative Average, Top 50, and For Title. To ensure the accuracy of the Top 50 rings score, you must now sort the spreadsheet. To do this, highlight (left mouse click, drag, release) all columns for all rows entered. Make sure you include all the columns (A-W) for all of the rows your cat has competed in. Then, from the drop-down menus at the top, click Data and select Sort. A dialog box will pop up. Ensure that the "Sort By" entry contains Column S. This is very important. Also ensure that "Descending" is selected. You can leave the two "Then By" spaces blank. Finally, ensure that "No Header Row" is selected. Now click okay.

<Drum roll please> Your cat's current regional points tally based on the fifty highest scoring rings now appears in the column labeled Top 50. The current score for Title (based on all of the rings) appears in the For Title column (please note: the For Title tally counts points only, the spread sheet does not consider if enough finals have been awarded from different judges to advance title.)

To use this for a kitten, you'll have to change the formula in the Top 50 column to reflect only the top 30 rings (you can change the column heading to "Top 30" too). If you still need to keep track of title points after competing in 100 rings, you'll need to change the formula in the For Title column to reflect this. Hopefully, everybody will have supremed by then, though. :)

The formulas, I believe, calculate the regional and title scores correctly. A friend on the TICA list, who is a former regional scorer, was kind enough to test drive this spread sheet, and did not find any mistakes. A final note of caution: this spread sheet is not bullet-proof. While there is some error checking incorporated, it is possible to get an incorrect score if incorrect information is entered. For example, if the "Rule of 25" applies to a particlar ring, say the count was only 24, and you enter a 10th Best final, the program will count these points, even though only 9 cats were actually finaled in that ring. The "Low Count Deduction" is incorporated in the formulas, however.

Okay...that's all I know. Caveat Emptor, and enjoy!

Best regards,
--Paul