Reply
 
Thread Tools Search this Thread Display Modes
 
Old 02-07-2010, 03:01 PM   #29
Rivet Master
 
streamer23's Avatar
 
NOVA SCOTIA , CANADA
Join Date: Feb 2004
Posts: 5,448
Images: 18
Quote:
Originally Posted by atobols View Post
Being the number crunching guy I am, I am pleased to see such analysis being done by someone. Unfortunately there's more interest from those of us that are "just curious" and like to see numbers analyzed than there is from the people actually running the club.

May I ask, Mike, do you have one big Excel sheet with everyone's names, unit, region, etc. on it and then every year you go page by page, line by line, and cross-check everything for changes? If so, I'm envious of your time and perseverance. If not, then patent your process and then tell me what it is!

-Jason
Hi Jason,

No Excel sheet for me although it would probably save me time.It's all done by hand.I compare the previous years directory to the new one and go through the listings one at a time listing the unit for each membership number.After all are tallied I go through the numerical listing in the back of the directory and subtract double listings (there are quite a few).
An example would be if there is a Bob Smith and a Mary Jones listed together for one membership number paying through Unit #1.It would appear twice in the directory,once under Smith and once under Jones.Since it is under one membership number I would have to subtract one listing from Unit #1.
This is part of what I do each year the directory is issued.
__________________

__________________
Mike

AIR #7916
Ex WBCCI #32083
streamer23 is offline   Reply With Quote
Old 02-07-2010, 11:12 PM   #30
Rivet Master
 
SteSpot's Avatar
 
1968 28' Ambassador
1982 24' Airstream 240
Ventura , California
Join Date: May 2006
Posts: 1,641
Images: 17
Your dedication is impressive.....

I have an interest in Region 12 numbers if you have time. Thank you very much, paula
__________________

__________________
Paula & Ed
Suite Spot
WBCCI # 8252 Air#13593
1968 28'Ambassador
2011 GMC Yukon Denali
1982 24'Motorhome (82Ste P)
SteSpot is offline   Reply With Quote
Old 02-08-2010, 12:18 AM   #31
Site Team
 
Aage's Avatar
 
1974 31' Sovereign
Ottawa , ON
Join Date: May 2008
Posts: 11,204
Images: 25
Quote:
Originally Posted by streamer23 View Post
After all are tallied I go through the numerical listing in the back of the directory and subtract double listings (there are quite a few).
An example would be if there is a Bob Smith and a Mary Jones listed together for one membership number paying through Unit #1.It would appear twice in the directory,once under Smith and once under Jones.Since it is under one membership number I would have to subtract one listing from Unit #1.
So, even if there are two members (Bob and Mary), you count them as one?

Hmmm...

I suppose it's how you define a member. To me, it's how many people there are, while to you, it's revenue.

I suppose either way is valid...
__________________
“Courage is being scared to death, but saddling up anyway.”
...John Wayne...........................
Aage is offline   Reply With Quote
Old 02-08-2010, 04:05 AM   #32
Rivet Master
 
streamer23's Avatar
 
NOVA SCOTIA , CANADA
Join Date: Feb 2004
Posts: 5,448
Images: 18
Quote:
Originally Posted by Aage View Post
So, even if there are two members (Bob and Mary), you count them as one?

Hmmm...

I suppose it's how you define a member. To me, it's how many people there are, while to you, it's revenue.

I suppose either way is valid...
I see your point but it has always been done that way by the club.If Bob Smith and Mary Jones were a married couple and had the same last name they would be counted as one membership unless they paid for an extra one.I think it is the best way.
Where do you draw the line if they have two kids.Even though they would be cosidered as four members they would be counted as one paid membership.
Regards
__________________
Mike

AIR #7916
Ex WBCCI #32083
streamer23 is offline   Reply With Quote
Old 02-08-2010, 04:16 AM   #33
Rivet Master
 
streamer23's Avatar
 
NOVA SCOTIA , CANADA
Join Date: Feb 2004
Posts: 5,448
Images: 18
Region 12

Quote:
Originally Posted by SteSpot View Post
I have an interest in Region 12 numbers if you have time. Thank you very much, paula
Here are the Region 12 units

Unit #008-Golden West California
2009-29 members 2010-19 members

Unit #010-Long Beach California
2009-36 members 2010-32 members

Unit #011-Northern California
2009-76 members 2010-81 members

Unit #014-El Camino Real
2009-73 members 2010-66 members

Unit #015-San Diego California
2009-41 members 2010-41 members

Unit #016-San Fernando Valley
2009-18 members 2010-14 members

Unit #017-San Joaquin California
2009-15 members 2010-16 members

Unit #018-Santa Clara California
2009-33 members 2010-30 members

Unit #019-South Coast California
2009-24 members 2010-21 members

Unit #020-Central Coast California
2009-33 members 2010-30 members

Unit #063-Nevada Unit
2009-21 members 2010-22 members

Unit #127-Monterey Bay California
2009-29 members 2010-21 members

Unit #157-Sierra Nevada
2009-33 members 2010-35 members

__________________
Mike

AIR #7916
Ex WBCCI #32083
streamer23 is offline   Reply With Quote
Old 02-08-2010, 05:28 AM   #34
Restorations done right
Commercial Member
 
Frank's Trailer Works's Avatar
 
1962 26' Overlander
1961 26' Overlander
Vintage Kin Owner
Currently Looking...
Baltimore , Maryland
Join Date: Aug 2007
Posts: 5,547
Images: 2
Quote:
Originally Posted by streamer23 View Post
I took 4 random years as a sample and rounded off to the nearest percentage.

1996-10300 members
1996 Int'l Rally Att. 2150 21%

2000-8750 members
2000 Int'l Rally Att. 1310 15%

2005-7504 members
2005 Int'l Rally Att. 1154 15%

2009-6092 members
2009 Int'l Rally Att 903 15%

Looks like a pretty constant number and based on the membership number could be used to predict what the expected attendance should be for upcoming Int'ls.This may be done already.Of course a lot of other factors will also have an effect on that projection ie cost,location etc
I want to preface my statement by saying I am a rivet cruncher not a numbers cruncher, but I can usually follow along fairly well...
Using that trend to forecast future Internationals could be a vital tool for the guy who's job it is.
If the 2010 member number is 5947, and if 15% historically attend the International. Well, then wouldn't the expected attendance for Gillette be 892? is that correct? .15 x 5947 = 892.05
I have heard that they are expecting 1500 to attend this year. 1500*5947= 0.2522 x 100 = 25.22% Has there ever been an International with that high an attendance? I mean % of total members, not the total number that came. Last year they expected 1200 to attend and 903 came. 1200 members would have been 19% of the members attending. That is much closer a realistic number to attend and it was not met.

I find breaking it down this way fascinating. Thank you Mike for doing this analysis.
Frank's Trailer Works is offline   Reply With Quote
Old 02-08-2010, 05:36 PM   #35
Rivet Master
 
66Overlander's Avatar
 
1962 22' Safari
2016 30' Classic
Somewhere , in the USA
Join Date: Mar 2004
Posts: 1,974
Images: 41
Quote:
Originally Posted by 62overlander View Post
Well, then wouldn't the expected attendance for Gillette be 892? is that correct? .15 x 5947 = 892.05
I have heard that they are expecting 1500 to attend this year. 1500*5947= 0.2522 x 100 = 25.22% Has there ever been an International with that high an attendance? I mean % of total members, not the total number that came. Last year they expected 1200 to attend and 903 came. 1200 members would have been 19% of the members attending. That is much closer a realistic number to attend and it was not met.
Frank, I think you are getting your years mixed up. Last year (2009) break even was 1200 and they "hoped for" figure was 1515. I have heard this years break even is about 800, less that the 892 that the trend projects. I have heard no mention that anyone in WBCCI expects 1500 to attend in Gillette this year.
__________________
Joe
Wally Byam Caravan Club International Historian
Vintage Airstream Club Historian
WBCCI/VAC #6768

(Looking for a vintage 1960's fiberglass front window guard)
66Overlander is offline   Reply With Quote
Old 02-08-2010, 05:51 PM   #36
Rivet Master
 
wkerfoot's Avatar
 
1979 23' Safari
1954 29' Liner
Orange , California
Join Date: Feb 2005
Posts: 3,667
The budget for the Gillette Rally, which I have seen is based on 700 rigs.

Bill
__________________
Bill Kerfoot, WBCCI/VAC/CAC/El Camino Real Unit #5223
Just my personal opinion
1973 Dodge W200 PowerWagon, 1977 Lincoln Continental, 2014 Dodge Durango
1979 23' Safari, and 1954 29' Double Door Liner Orange, CA

http://billbethsblog.blogspot.com/
wkerfoot is offline   Reply With Quote
Old 02-08-2010, 05:55 PM   #37
Restorations done right
Commercial Member
 
Frank's Trailer Works's Avatar
 
1962 26' Overlander
1961 26' Overlander
Vintage Kin Owner
Currently Looking...
Baltimore , Maryland
Join Date: Aug 2007
Posts: 5,547
Images: 2
I hear a lot of misinformation... like the number 6600 as 2009s total members... Oh well, thanks for straightening me out, you paint a much rosier picture.
Frank's Trailer Works is offline   Reply With Quote
Old 02-08-2010, 07:38 PM   #38
Rivet Master
 
66Overlander's Avatar
 
1962 22' Safari
2016 30' Classic
Somewhere , in the USA
Join Date: Mar 2004
Posts: 1,974
Images: 41
Quote:
Originally Posted by 62overlander View Post
I hear a lot of misinformation... like the number 6600 as 2009s total members... Oh well, thanks for straightening me out, you paint a much rosier picture.
It's interesting that you keep hearing numbers that I as a member do not hear. I wonder where they're coming from? The WBCCI membership totals are not a completely rosy picture, but as long as we're all honest and not knowingly spreading mis-information, all is fair game for discussion. Please understand that I am not accusing you of anything, but I am curious where this "information" is coming from.

And quite frankly, I am getting tired of the WBCCI bashing here on AirForums - it's getting old as it spreads to every thread that happens to mention the name WBCCI. It's got me again thinking about asking for a WBBB refund because I don't want to be around those that bash the club incessantly and that is what I am believing the WBBB will degrade into. I get that feeling from the continual bashing in this and other AirForums threads.

And to not degrade this thread away from it's original intent, if we want to continue the discussion WBCCI mis-information, lets move it to another thread. We owe Mike thanks for providing the factual information posted in this thread and should not take it off subject to discuss yet more hearsay. I hope you agree.
__________________
Joe
Wally Byam Caravan Club International Historian
Vintage Airstream Club Historian
WBCCI/VAC #6768

(Looking for a vintage 1960's fiberglass front window guard)
66Overlander is offline   Reply With Quote
Old 02-08-2010, 11:41 PM   #39
Rivet Master
 
RoadKingMoe's Avatar
 
2001 34' Limited
The State of , Ohio
Join Date: Sep 2002
Posts: 1,605
Images: 23
Every year, we put the new directory in the truck and move the year-old one to the trailer. And every time I do that, I think of you, Mike, making the numbers meaningful for us. Thank you for this.

Every year, the new directory is smaller. It's obvious when they're side-by-side. It seems like every other year lately, the loss of members is roughly double that of the previous year. I expect the dues increase will ensure that's at least the case for 2011.
__________________
Maurice
RoadKingMoe is offline   Reply With Quote
Old 02-09-2010, 04:19 AM   #40
Rivet Master
 
streamer23's Avatar
 
NOVA SCOTIA , CANADA
Join Date: Feb 2004
Posts: 5,448
Images: 18
Quote:
Originally Posted by RoadKingMoe View Post
Every year, we put the new directory in the truck and move the year-old one to the trailer. And every time I do that, I think of you, Mike, making the numbers meaningful for us. Thank you for this.

Every year, the new directory is smaller. It's obvious when they're side-by-side. It seems like every other year lately, the loss of members is roughly double that of the previous year. I expect the dues increase will ensure that's at least the case for 2011.

I appreciate your comments and the karma(thanks) Maurice and others.
Here is your units total

Unit #029
Pensacola Florida Unit
2009-75 members 2010-79 members
__________________
Mike

AIR #7916
Ex WBCCI #32083
streamer23 is offline   Reply With Quote
Old 02-09-2010, 09:12 AM   #41
Rivet Master
 
1977 31' Sovereign
1963 26' Overlander
1989 34' Excella
Johnsburg , Illinois
Join Date: Jul 2005
Posts: 2,941
I just read the February newsletter from the International President. He quotes the total number of members in WBCCI as 6,235. I wonder where he gets his numbers from?

He just got aback from the January IBT meeting and claimed they had 154 members listening to the streaming broadcasts. He says they have sold 635 tickets to Gillette. There will always be a few cancellations, but he is getting pretty close to his 700 break even number. I wonder if he would have sold more, if he had decided to offer a cheaper rate for just providing 3 amp service instead of the 30 amp service for $500. The reported average temperature of Gillette in June and July does not indicate air conditioning would be necessary. We certainly did not need it in Madison this year. My '63, which I took, does not have air and it was nice in Madison without air. The Cam-plex brochure indicates they have 3 amp serve sites available as well as no service sites at a lower cost.
.
__________________
dwightdi is offline   Reply With Quote
Old 02-09-2010, 10:54 AM   #42
Rivet Master
 
RickDavis's Avatar

 
1961 24' Tradewind
1969 29' Ambassador
1970 21' Globetrotter
Jamestown , Tennessee
Join Date: Jul 2008
Posts: 1,781
He would have had at least one more at Gillette. We were at the sign up table when it opened and then found out, no 3 amp.
None the less, i hope they make their break even numbers. Obviously this one was planned with a touch of reality that was not the case with Madison
__________________

__________________
Rick Davis 1602 K8DOC
61 tradewind, plus a few others
13 Ram 2500 TD
99 Dodge TD 577K miles

RickDavis is offline   Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
2008 WBCCI Directory Membership Totals streamer23 WBCCI Forum 7 01-18-2008 09:59 PM
2007 WBCCI Membership totals streamer23 WBCCI Forum 49 01-14-2007 06:31 PM
WBCCI member at large totals as compared to total membership streamer23 WBCCI Forum 20 10-15-2006 09:32 AM
WBCCI 2003 Membership Directory Kistler Our Community 23 01-14-2003 11:00 AM


Virginia Campgrounds

Reviews provided by




Copyright 2002- Social Knowledge, LLC All Rights Reserved.

All times are GMT -6. The time now is 02:33 AM.


Powered by vBulletin® Version 3.8.8 Beta 1
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.

Airstream is a registered trademark of Airstream Inc. All rights reserved. Airstream trademark used under license to Social Knowledge LLC.