Page 1 of 1

Request for Race Data

Posted: Tue Jan 24, 2012 11:33 am
by Stan Pope
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!

Re: Request for Race Data

Posted: Tue Jan 24, 2012 12:14 pm
by Darin McGrew
Do you need times? Or is finish order enough for those of us without timers?

Re: Request for Race Data

Posted: Tue Jan 24, 2012 12:27 pm
by rpcarpe
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?

Re: Request for Race Data

Posted: Tue Jan 24, 2012 12:55 pm
by gpraceman
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.

Re: Request for Race Data

Posted: Tue Jan 24, 2012 1:23 pm
by Stan Pope
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.

Re: Request for Race Data

Posted: Tue Jan 24, 2012 8:30 pm
by PeterT
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!

Re: Request for Race Data

Posted: Tue Jan 24, 2012 9:38 pm
by Stan Pope
One down, 49 to go! :)

Re: Request for Race Data

Posted: Wed Jan 25, 2012 10:02 am
by rpcarpe
Stan,
The .pdf sheet should be in your inbox. Good Luck!