[JONAT] Sector Coordinators Attendance Roster

[Mark Stephenson]

Greg,

I'd add one more column. It would require an additional question on the
entry form, though. It would be nice if the sector who registered the
person received credit for it. For example, Gary Singer, Dick Hile and I
are all starting in Colorado (at least that's the plan right now --
don't worry I'll have lots more), but the Arizona sector is responsible
for signing them up. Without something like this we have no way of
knowing who brought the people into the tour.

My problem is that I don't know what to call it.

"How did you hear about us?" is too broad. 

"What Sector Coordinator enticed you to join us?" might work. If they
answer none, we'd give credit to the SC of their starting sector,
because if the SC didn't sell it, the route must have been good enough
to pique their interest.

Re: the report layout. A couple weeks ago, I sent an example that was a
big chart with "X"es for each sector the entrant was taking. If our
entry form had a list of the sectors and allowed the entrant to check
the ones he was taking, it would make registration easy and handle
situations where people take non-contiguous sections of the tour --
Florida, for example, and perhaps in the NE where they could take part
in western NY and eastern NY. This creates an easy way to generate a
list by sector, and will result in a great chart to display
participation all along the route. If it's in an Excel spreadsheet, it
could be manipulated all kinds of ways. What would really look cool
would be arranging it by sector and then sorting the participants by
their starting sector. It would create a downward stepping graph that
would give anyone looking at the site the ability to see who was taking
the tour and if there was anyone they know in their area.

Mark - AZ

-----Original Message-----
From: jonat-admin@autox.team.net [mailto:jonat-admin@autox.team.net] On
Behalf Of Richard Jones
Sent: Friday, February 27, 2004 8:01 PM
To: jonat@autox.team.net
Subject: Re: [JONAT] Sector Coordinators Attendance Roster

  Greg,
  I think the following 9 line items* would be worth adding:

  *Leaving_at (city where the participant anticipates leaving the tour)
  *Car_color

  *Payment required (will be different for different registrations)
  Payment received to date
  *Payment due (collect from driver)
  Paid (flag)

  *On-site Registrant (flag)

  *Special Event (Name)
  *Special Event Fee (Amount required)
  *Special Event Fee Paid (flag)

  *A last cell at the right entitled "Comments"

  A simple Excel spreadsheet should do it.
  Dick.

  ----- Original Message -----
  From: "JONAT Webmaster" <webmaster@jonat.org>
  To: <jonat@autox.team.net>
  Sent: Friday, February 27, 2004 7:15 PM
  Subject: [JONAT] Sector Coordinators Attendance Roster


  > Hello SC's,
  > I would like your requirements for what you want to see on a Sector
  > participant list report. This is a real-time web report that you
could
  > monitor, and then print out just prior to starting your particular
  > sector. You could check attendance of those who are pre-paid, and
add
  > new people manually.
  >
  > This report is not meant to replace the printed registration form
that a
  > new user would be required to fill out when registering and paying
you
  > on-site, but it would act a printout so you can keep track of your
  > 'kids' as you tour about your state.
  >
  > I am at least going to have the following fields available on the
  > report:
  > Registration id (car sticker number to indicate prepayment)
  > First_name
  > Last_name
  > Car_model
  > Car_year
  > Joining_at (city where the participant will join the tour, if it's
in
  > your sector)
  > Number_in_car (number of people in the participant's car)
  > Paid (flag which notes whether the person is fully paid or not)
  > Total_Payment (total dollars that the person has already paid to
Regina)
  >
  > Do you have other additions?
  > Do you have recommendations for report layout?
  >
  > If I add contact info, (phone, email, cel_phone, home address) then
the
  > report will need to be kept "secret" and secured when printed so as
to
  > not compromise the privacy of our members.
  > http://jonat.org/privacy.cfm#disclosure
  >
  > Thanks! I want to make a report that will be useful for you.
  >
  > Greg
  >
  >
  >
  >
  >
  >
  > _______________________________________________
  > JAGUAR OWNER'S NORTH AMERICAN TOUR mailing list
  > REPLY TO : JONAT@autox.team.net
  > www.jonat.org
  > _______________________________________________


_______________________________________________
JAGUAR OWNER'S NORTH AMERICAN TOUR mailing list 
REPLY TO : JONAT@autox.team.net
www.jonat.org
_______________________________________________