Total Number of Founders Award Recipients?

[Dave P.]

.....................

[John W.]

Re: Total Number of Founders Award Recipients?

Dave,

We are looking into your question. So far it looks like the number is correct, but doing further investigation.

[John W.]

Re: Total Number of Founders Award Recipients?

Re-Founders are a separate award and I did look at them. Nothing has changed in the Query that derives the number in a couple years or more. In looking at strictly the raw numbers for Founders Award it looks to be correct.

[John W.]

Re: Total Number of Founders Award Recipients?

Dave,

I just did a search on all of the Founders Awards that we imported from Roy Sinor's records. That showed 234 records imported. That leaves only 48 Founders Awards provided since Dave Brigham took over. There is no way to verify the records that Roy provided. We found numerous errors in those records but we were only able to correct ones that were obvious.

[John W.]

Re: Total Number of Founders Award Recipients?

I did go back to the original database file we got from Roy in 2012. I was able to open it in Access. I looked through the column for Founders and found lots of check marks. There isn't a good way to count them other than scroll down one page at a time and hand count. Too many to do that way.

If I have time tomorrow I will see if I can export them into a csv file where I can import them into Excel and maybe let the computer count them for me.

[John W.]

Re: Total Number of Founders Award Recipients?

OK, I was able to export the table to Excel where I could more easily dissect it. The first Founders Awards were issued at Steamboat Springs Convention in 1995 where 17 Founders Awards were issued. Seems like the Award was a lot more popular early on. In 1996 in St. Paul, MN National 18 Founders Awards were issued.

From 1995 to 2009 235 Founders Awards were issued. Obviously the number has slowed way down in the last 12 years, but I think I can stand with our overall number of 282 Founders Awards.

[Don H.]

Re: Total Number of Founders Award Recipients?

John
thank you for all the effort you put in to validate that number.
Don

[John W.]

Re: Total Number of Founders Award Recipients?

Here is a little further proof. This spreadsheet shows the number of Founders Awards by model year.

Award	Car Year		Level	No. of Cars
Founders	1956		PASS	8
Founders	1957		PASS	8
Founders	1958		PASS	5
Founders	1959		PASS	3
Founders	1960		PASS	9
Founders	1961		PASS	12
Founders	1962		PASS	14
Founders	1963		PASS	17
Founders	1964		PASS	16
Founders	1965		PASS	28
Founders	1966		PASS	32
Founders	1967		PASS	26
Founders	1968		PASS	1
Founders	1969		PASS	9
Founders	1970		PASS	7
Founders	1971		PASS	9
Founders	1972		PASS	11
Founders	1973		PASS	2
Founders	1974		PASS	1
Founders	1975		PASS	5
Founders	1976		PASS	4
Founders	1977		PASS	4
Founders	1978		PASS	7
Founders	1979		PASS	1
Founders	1980		PASS	3
Founders	1981		PASS	2
Founders	1982		PASS	16
Founders	1984		PASS	1
Founders	1985		PASS	3
Founders	1986		PASS	2
Founders	1987		PASS	2
Founders	1988		PASS	1
Founders	1989		PASS	1
Founders	1990		PASS	1
Founders	1991		PASS	2
Founders	1992		PASS	2
Founders	1993		PASS	2
Founders	1994		PASS	1
Founders	1996		PASS	2
Founders	1998		PASS	1
Founders	2001		PASS	1
			Total	282