All the data presented on this page is in one spreadsheet collected in many trips to the Wood Memorial Library. The only source used was the plan in the HAS Program Handbook. The data was not modified to show what actually occurred.

Trips listed in Program Handbooks

This spreadsheet lists HAS trips in Program Handbooks. Listed for each trip from 1912 until today is the date, name of the trip or place, and the leader. People who like data and HAS history tend to enjoy simply looking around the spreadsheet. It opens on the first tab at the bottom called "Trips". Click on the blue boxes at the top to sort the list.

Leader trip count summary

The fourth tab at the bottom of the trips spreadsheet is "Leaders". Clicking on the tab will open a single report drawn from the data in the "Trips" tab. The report gathers trips for each leader and summarizes the number of trips by decade for each leader. The 1990 decade is the 1990-1999 period.

A leader is the name or group of names listed for a trip in the Program/Handbook. Leaders who have led trips with more than one leader will appear on multiple lines. The report lists more than 600 leaders and 3000 trips.

In the right-hand column of the report is the total number of trips for each leader.

Number of members listed in each Program Handbook

The fifth tab at the bottom of the trips spreadsheet is "Members per Year". Clicking on the tab will open a graph with data from the Membership section of each Program/Handbook.

The counts are for individuals. Couples are counted as two people.

A word of caution about reading too much in to this chart. The main problem is that the criteria for listing members in the book has changed with time. I know how the criteria has changed recently, but there is no way to know how things were done earlier.

Since the 2015-2016 book the list only shows people whose dues are current. Most of the years in the two or three decades before that also included people whose dues had just expired in May.

There were very good reasons for including the extra members. Each year we have members who are late paying their dues. If they were removed from the membership list then a special mailing was made to them when they paid. This was a pain but it was also expensive because first class postage would have to be used. Moreover, membership was fairly stable and people were not especially concerned about membership counts.

My guess is that by including the people whose dues had just expired we were adding about 40 people to the membership count.

Advice

The Google spreadsheet viewer frequently has trouble with this Excel spreadsheet. Even if it opens, the blue boxes that sort will probably not work. I strongly recommend that you download the file and open it with Excel.