CORSA 2012: Data Processing for Registration, Timing, and Scoring

[David McMillan]

What other tools or processes are available from CORSA that can be utilized that 
we are not aware of?

Dave 




________________________________
From: "Lacki, Allan V" <AVLacki at pplweb.com>
To: "sarahvair at cfl.rr.com" <sarahvair at cfl.rr.com>
Cc: "conv-2012 at corvair.org" <conv-2012 at corvair.org>
Sent: Tue, January 18, 2011 8:29:55 AM
Subject: Re: CORSA 2012: Data Processing for Registration, Timing, and Scoring

Sarah and Ward,  That's good news.  I wasn't aware CORSA had such a data 
processing tool.  I'll refrain from further work on the Excel workbook that I 
proposed in yesterday's email.  Al Lacki


-----Original Message-----
From: sarahvair at cfl.rr.com [mailto:sarahvair at cfl.rr.com] 
Sent: Tuesday, January 18, 2011 8:09 AM
To: EDWARD BOURGONDIEN; Lacki, Allan V
Cc: conv-2012 at corvair.org
Subject: Re: CORSA 2012: Data Processing for Registration, Timing, and Scoring

Yes, we do have the program in place.  The latest and greatest program was done 
in 2001 and has had continuos improvements sent.  Not only will it do 
registrations, etc, with will also print out participants numbers (autocross, 
rally econo run)it will print out plaqards as well.

CORSA members have paid to have this developed, we need to use it.

Sarah


---- EDWARD BOURGONDIEN <ward at lightningspeed.net> wrote: 
> If I;m not mistaken CORSA (Harry Jensen) has a program that does 
> everything you have listed.  It already has CORSA members in there 
> with assign numbers so we have records that match from convention to 
>convention.
> 
> I know we used one from CORSA in 1991 in Washington, DC and again in 
> Carlisle.  This saved us a lot of time and we didn't have to reinvent 
> the wheel.
> 
> Ward Bourgondien
> 
> On Mon, Jan 17, 2011 at 5:49 AM, Lacki, Allan V <AVLacki at pplweb.com> wrote:
> 
> > AUDIENCE:
> >
> > This email is likely to be of interest to folks who will be chairing 
> > the Registration, Concours, Autocross, Rally, EconoRun, Scoring and 
> > Awards activities.
> >
> >
> > BACKGROUND:
> >
> > The Convention is likely to require much coordination between folks 
> > who are involved in registration, concours, competition events, 
> > scoring, and awards, especially with respect to data processing.  
> > NECC encountered this same situation when we conducted the Corvair 
> > Olympics back in 2007.  To automate the data processing, we 
> > developed an online registration web page that enabled us to 
> > pre-load all of our timing and judging forms with information about 
> > each entrant.  Then, we pre-loaded all of this information into a large Excel 
>workbook that compiled the timings and scores from each event.
> >  The Excel workbook provided exhibits showing the results for each 
> > event, ranked by class and position for each entrant.  It also 
> > compiled overall scores for the NECC John Fitch Award, which is 
> > similar to the CORSA Ed Cole Award.
> >
> >
> > PROPOSED DATA PROCESSING SPREADSHEET:
> >
> > Over the weekend, I prepared a similar Excel workbook for the 2012 
> > Sturbridge CORSA Convention.  It is much too large to attach to an 
> > email, and so I uploaded it onto the NECC website.  Here is the address:
> >
> >
> > http://www.corvair.org/chapters/necc/tools/corsa_convention_scoring_
> > 2012.xls
> >
> > BEWARE!  This Excel workbook is 26 megabytes and takes a L-O-N-G 
> > time to download.  If you are running DSL or cable, the waiting time 
> > may be as high as 5 minutes.  If you are running dial-up, please 
> > don't attempt to download it. The reason it is so big is because it 
> > is designed to accommodate up to 1,000 entrants in each of the 
> > following events:  (1) Concours,  (2) Autocross,  (3) Rally,  (4) EconoRun.  
>That should be more than adequate!
> >
> > BEWARE!  This Excel workbook is fresh and may contain some bugs.  
> > While I have loaded it with dummy data to test it, I can't guarantee 
> > that it's perfect.  But it should be close.  As mentioned above, 
> > it's based on a similar workbook that we used with success at the 2007 
>Corvair Olympics.
> >  And we have a year-and-a-half to debug it.
> >
> > By way of this email, I am volunteering to improve and maintain this 
> > Excel workbook, providing it meets your collective approval.
> >
> >
> > FEATURES OF THE SPREADSHEET:
> >
> > Even if you choose not to download it, you may be interested in the 
> > Workbook's capabilities, and so here is a summary:
> >
> > Excel Workbook Purpose:
> >
> > The Excel workbook does all the data processing for events held at 
> > the CORSA International Convention, including Concours, Autocross, Rally, 
and
> > EconoRun.  It compiles scores and timings for each event. It adds up the
> > points and ranks the winners.
> >
> > Here is a list of exhibits it will produce for you:
> >
> > 1.  List of entrants, by driver name.
> > 2.  Timing form for autocross.
> > 3.  Concours Results, with point scores and rank for every Concours 
> > participant.
> > 4.  Autocross Results, with point scores and rank for every 
> > Autocross participant.
> > 5.  Rally Results, with point scores and rank for every Rally participant.
> > 6.  EconoRun Results, with point scores and rank for every EconoRun 
> > participant.
> > 7.  Ed Cole Award Results, with point scores and rank for every 
> > participant.
> >
> > All scoring is designed to be consistent with CORSA Rules.
> > Analysis of Rally results assumes a Continental / TSD rally.
> > All scoring equations can be changed, if necessary.
> >
> >
> > Excel Workbook Instructions:
> >
> > The Excel workbook, while very big, is also very easy to use.  All 
> > data is entered on one tab, and all data processing occurs 
> > automatically, without user interference.  There are no "macros" to invoke.
> >
> > 1.  Paste the Registrar's list of entries into the "Data Entry" tab.
> >        a.  Enter your data in the yellow cells.
> >        b.  Do NOT enter data in the grey cells.
> >        c.  The grey cells at the top and left side of the tab are 
> > reserved for cell formulas!
> > 2.  Edit the Data Entry tab.
> >        a.  Edit the entries for grammar and style, i.e. fixup the 
> > car descriptions, classes.
> >        b.  MAKE SURE EVERY DRIVER HAS A NAME, CAR NUMBER, ETC!
> >        c.  MAKE SURE THE CLASS CODES ARE CONSISTENT WITH THOSE SHOWN 
> > IN THE "LOOKUP CLASS" tab.
> >        d.  Incorrect class codes, e.g. "IS-4?", will create errors 
> > in this workbook.
> > 3.  As the events get underway, enter concours points, autocross run 
> > times, etc into the columns in the "Data Entry" tab!
> > 4.  Check the results.
> > 5.  Set the Print Area for each report and print 'em out.
> >
> >
> > Types of Workbook Tabs:
> >
> > 1.  The purpose of the Data Entry tab is self-evident!
> > 2.  Lookup tabs and Analysis tabs are not intended to serve as reports.
> >  They are for data processing.
> > 3.  Entrants tabs and Winners tabs are designed to be printed.  
> > Specify the "Print Area" or Pages to Print in Excel to accommodate 
> > the number of people who entered each event.
> >
> >
> > NEXT STEPS:
> >
> > Please let me know if you have any comments, suggestions, or 
> > objections to the use of the proposed Excel workbook.
> >
> >
> > Allan Lacki
> >
> >
> > The information contained in this message is intended only for the 
> > personal and confidential use of the recipient(s) named above. If 
> > the reader of this message is not the intended recipient or an agent 
> > responsible for delivering it to the intended recipient, you are 
> > hereby notified that you have received this document in error and 
> > that any review, dissemination, distribution, or copying of this 
> > message is strictly prohibited. If you have received this 
> > communication in error, please notify us immediately, and delete the 
> > original message.
> > _______________________________________________
> > Conv-2012 mailing list
> > Conv-2012 at corvair.org
> > http://www.vv.corvair.org/mailman/listinfo/conv-2012
> > For help, mailto:conv-2012-help at corvair.org
> >
> _______________________________________________
> Conv-2012 mailing list
> Conv-2012 at corvair.org
> http://www.vv.corvair.org/mailman/listinfo/conv-2012
> For help, mailto:conv-2012-help at corvair.org


The information contained in this message is intended only for the personal and 
confidential use of the recipient(s) named above. If the reader of this message 
is 

not the intended recipient or an agent responsible for delivering it to the 
intended 

recipient, you are hereby notified that you have received this document in error 

and that any review, dissemination, distribution, or copying of this message is 
strictly prohibited. If you have received this communication in error, please 
notify 

us immediately, and delete the original message.
_______________________________________________
Conv-2012 mailing list
Conv-2012 at corvair.org
http://www.vv.corvair.org/mailman/listinfo/conv-2012
For help, mailto:conv-2012-help at corvair.org