September 2, 2010
Canstats - Horseshoe Canada Association
CANSTATS - Horseshoe Canada
How to submit results:
The fastest way to incorporate them into the system is when the results are presented using the Excel models.
But our experience has proved that we can import data (after some editing in Excel) coming from HS Master or even the Shoes program,
by using the MDB file (for HSMaster) or DBF files named Competor and Results (for the Shoes program).
If you lack time, we can always edit results coming from other formats. But we do recommend you use the Excel models. There are three worksheets or tabs corresponding to the tables (Members, Tournaments, Results).
The fields that absolutely need to be filled are in "bold". But we recommend you also provide (in the results table): the wins and losses in order to compile the data for the National Awards.
Membership numbers:
We need a distinct membership number for each pitcher because the Canstats program does not accept two pitchers with the same number.
Whenever that information was not available, we assigned a temporary membership number to some pitchers.
Their number usually include “TC” or “TM” in the middle (ex.: 63TC01). We count on you to provide the correct numbers or corrections when necessary.
Division the players belong to:
The division in which a member belongs has to be entered manually into the system. We don’t recommend using a formula that would automatically classify a pitcher. For two reasons: no birthdates available for a lot of members, plus the fact some members don’t automatically enter for example the Senior 30’ division when they reach 65 years old.
Sometimes, when entering results involving new members, we can hardly tell in which division they belong and we assume... Feel free to provide the necessary corrections.
We also need to know when a player moves to another division and when that change occurred.
Out of province pitchers and Canadians in US:
We suggest that you send, to Canstats, the complete results of a tournament including out of province and US pitchers. For Canadians playing in the US, we usually obtain those results from the Natstats director. But if you do receive such results, we suggest you forward them to Canstats as well, in case they are missing from our files.
We count on you to provide the results with regularity, but also to make any corrections necessary!