Request for Race Data

Debates and discussions on the various race scheduling methods that can be used and their fairness and accuracy in determining the winners.
Post Reply
User avatar
Stan Pope
Pine Head Legend
Pine Head Legend
Posts: 6888
Joined: Sat Jul 05, 2003 7:01 pm
Location: Morton, Illinois
Contact:

Request for Race Data

Post by Stan Pope » Tue Jan 24, 2012 12:33 pm

I would like to receive the complete (less personally identifying information) heat-by-heat detail data from your PW races, especially those which are highly competitive, i.e. close. To facilitate use in other software and to make it easier to strip personally identifying information, I would like to receive the data in CSV (comma separated values?) format.

I understand that software like GPRM can easily export such data in CSV format.

The data will be used to test some hypotheses regarding competition models. Third party statistical analysis will be involved, so excluding personally identifying information is important.

Thanks in advance!


Stan
"If it's not for the boys, it's for the birds!"

User avatar
Darin McGrew
Pine Head Legend
Pine Head Legend
Posts: 1735
Joined: Fri Jul 18, 2003 1:23 pm
Location: Mountain View, CA
Contact:

Re: Request for Race Data

Post by Darin McGrew » Tue Jan 24, 2012 1:14 pm

Do you need times? Or is finish order enough for those of us without timers?



rpcarpe
Master Pine Head
Master Pine Head
Posts: 734
Joined: Wed Mar 17, 2010 11:58 am
Location: Huntsville, Alabama

Re: Request for Race Data

Post by rpcarpe » Tue Jan 24, 2012 1:27 pm

Stan,
I'm involved in a total of three derbies, I believe all using timers.
Bad thing - they're all using slightly different rules. Will that matter?

I'll try to get you some data. I might have heat-by-heat data from a District race. Let me check.

Yes, I do have a file. But it's a 44 page .pdf. It lists all heats and results by Scout. Do you still want it?


My wife started a new support group... Widows of the Pinewood Derby.

User avatar
gpraceman
Site Admin
Site Admin
Posts: 4605
Joined: Fri Jun 20, 2003 12:46 am
Location: Highlands Ranch, CO
Contact:

Re: Request for Race Data

Post by gpraceman » Tue Jan 24, 2012 1:55 pm

One thing to consider when looking at the data. How is the start detected? Optical sensor systems can add a lot of variability if it is the first car to break the beam.

Of course, other variables to consider are track profile, track length, start gate height, etc.


Randy Lisano
Romans 5:8

Awana Grand Prix and Pinewood Derby racing - Where a child, an adult and a small block of wood combine for a lot of fun and memories.

User avatar
Stan Pope
Pine Head Legend
Pine Head Legend
Posts: 6888
Joined: Sat Jul 05, 2003 7:01 pm
Location: Morton, Illinois
Contact:

Re: Request for Race Data

Post by Stan Pope » Tue Jan 24, 2012 2:23 pm

Heat by heat! With times if available. If CSV format is not available, PDF will do ... just makes a bunch more work for me to extract data and strip the P.I.I. before sending on.

I believe that the competition models being compared are independent of how the start was sensed, what the track looked like and the details of car specs.

No special coordination with me is needed... just email to me with the race file attached. I'll acknowledge receipt and ask questions if I don't understand something.


Stan
"If it's not for the boys, it's for the birds!"

User avatar
PeterT
Pine Head
Pine Head
Posts: 60
Joined: Wed Dec 21, 2011 10:53 am
Location: Pittsburgh area, PA

Re: Request for Race Data

Post by PeterT » Tue Jan 24, 2012 9:30 pm

Just sent you five years of data in CSV format, heat by heat with lane information, times, finish order, etc.

We strip personally identifiable information from race results and publish to our Pack website each year, so the data is already set to go.

When I first started doing this three years ago, it was because two dads asked for the data file. After stripping the PI info, I published to our website and did not have a chance to notify anyone. I did not want to make a big deal out of it, and would see both of those dads in another two days.

Much to my surprise, a completely different dad with whom I had never spoken emailed me 4 hours later with data analysis, graphs and histograms of the race results! So the tradition began. We've had a six-sigma guy take apart the data looking for lane bias as well as other insights.

Our local council refuses to provide race results, but there is an extremely well produced video we've bought each year which contains - among other things - complete race results data. Stan: if you think extracting race results from a PDF takes time, try from a DVD video!!! Um, no thanks!



User avatar
Stan Pope
Pine Head Legend
Pine Head Legend
Posts: 6888
Joined: Sat Jul 05, 2003 7:01 pm
Location: Morton, Illinois
Contact:

Re: Request for Race Data

Post by Stan Pope » Tue Jan 24, 2012 10:38 pm

One down, 49 to go! :)


Stan
"If it's not for the boys, it's for the birds!"

rpcarpe
Master Pine Head
Master Pine Head
Posts: 734
Joined: Wed Mar 17, 2010 11:58 am
Location: Huntsville, Alabama

Re: Request for Race Data

Post by rpcarpe » Wed Jan 25, 2012 11:02 am

Stan,
The .pdf sheet should be in your inbox. Good Luck!


My wife started a new support group... Widows of the Pinewood Derby.

Post Reply