Home > Race Analysis > TraqMate Data Uploaded

TraqMate Data Uploaded

March 6th, 2009
Goto comments Leave a comment

Ladies and germs, I have uploaded the TraqMate data to our Google Docs page. Each of our drivers has access to the data for now. I haven’t uploaded it as an excel file but will probably do so later tonight or tomorrow. For some reason when I re-export the list out of the Google Spreadsheet function it throws the lap times into a mess. I have the original on Excel at home, just not at the office. But this is an interesting first stop and I’m pretty sure that you can manipulate the data on Google Spreadsheet pretty much like you could on Excel for fast lap times, etc. I’ve also noticed that we’re missing some data (like the second-half of my drive and some of Matt’s drive, maybe some of Brad’s too?). This data is all from Saturday, BTW.

I plan to do a little more analysis on this data, like throwing out obvious full-course yellows, so we can get some better accuracy on green flag avg times, etc., but this will get you started. Enjoy!

Oh, one thing of note. I’ve tried to cross-reference our track position, but it seems off by a few laps at the start of Sam’s run. I worked backwards from lap 58 in my drive because that’s where we know that we lost a lot of time due to the false black flag. If Brad could get the LeMons guys to get the MyLaps guys to let us have full access to their lap-by-lap data as part of his research for his story, I could get this chart a little more cleaned up. Hint.

Race Analysis

  1. Pat
    March 6th, 2009 at 13:40 | #1
    Reply | Quote

    I’ve got the AMB dataset from Brad now but it’s pretty hard to line up since the start/finish position on the TraqMate and on the AMB data aren’t in the same place. In fact, they’re almost half a track apart. I’m going to try to reform the TraqMate data tonight or over the weekend to get it closer together so we can match up the laptimes with the field position.

    In other words, don’t rely too heavily on the Google Docs spreadsheet for 100% final data just yet.

  2. Pat
    March 6th, 2009 at 15:07 | #2
    Reply | Quote

    I called down to MSR Houston and Sandra informs me that the AMB transponder line runs under the track right at the yellow walkway/flagstand that extends out over the track. Using the photos on the track website, Google Maps, and my memory of what the track looked like last weekend, I’ve come up with these approximate coordinates for the start/finish line:

    29°16′44.61″N
    95°25′20.83″W

    or

    29.279058
    -95.422453
    HDG 280.61
    Hopefully this will get us close enough when I reform the TraqMate data so that the AMB data can be of some use.

  1. No trackbacks yet.
You must be logged in to post a comment.