Marshal Log Book Project: #MarshalLogBook

It’s been a while since I had my log book signed.

Oh you’ve never heard of a log book? Well, marshals around the world record their event participation in a little book which they bring to the track to get signed each weekend by their flag chief or post chief, to validate that they indeed volunteered the event.

You may have tinkered with the idea on the SCCA web site if you volunteer in the US and are a member of the club. Because you get a worker incentive for participating in club events. Work 12 cumulative days and get $45 discount on your membership renewal. Work 8 days get $30 bucks credit, etc. But what about those pro events you worked? Nobody cares right? Wrong!

Registering for events thru DLBracing.com or Motorsportreg.com keeps track (a historic record) of events you signed up to work through those web sites. But again there’s no One/central database of all the events you volunteered: pro, club, international, etc.

It’s time to create a new Digital Marshal Log Book… I’ve been a long time user of several flight tracking databases like ba97 and OpenFlights for years, and there’s no reason such a simple solution can’t be used to quickly and conveniently keep track of all my Motorsport volunteering. Of course automating this process is a little beyond my programming skills so I’ll definitely need some help from the readers of this blog. But I have put together some samples manually, and the results are stunning!

So the simple list view of my Motorsport volunteering is:

marshal log book list Google Docs list: click here.

But here’s the cool part… the Analytics! You want to know the stats of Circuits by Days I spent at each event? I do:

circuits by day Google Docs: click here. The pie chart is interactive. Go ahead and play with it! Interestingly 7.7% (18 days) of all of my days spend at the race track happened at Lime Rock Park in Connecticut and at Hampton Downs in New Zealand. 6.4% (15 days) at Circuit of the Americas, and 6% (14 days) at Watkins Glen International.

How about Circuits by Frequency of returning to that track:

circuits frequency Google Docs: click here. Looking at these stats 10.6% (9 times) of all the time I returned to a particular circuit, it just happened to be to Lime Rock Park – my home track in the US. 7.1% (6 times) to Hampton Downs my former home track in New Zealand and to Watkins Glen International in New York. 5.9% (5 times) to both Circuit of the Americas in Texas and Summit Point in West Virginia. Quite a different perspective considering most events at Lime Rock are 2 day events, while the rest of the world it’s typically 3 days because there is no racing in Connecticut on Sundays.

How about Country stats by Days worked? Let’s see:

country by days Google Docs: click here. It turns out more than half of all the time (123 days out of 234 days total) I spent trackside, happened right here in America! (‘murica!) 15.2% (35 days) in New Zealand which is an amazing number considering I only spent less than half a year there and have been marshaling in the US for over three years now. And 7.4% (17 days) spent in Australia, which is cheeky because most of that came from the one month long trip I made down there in 2013 where I did something like six back to back events in a row.

How about Country by Frequency of participation:

country frequency Google Docs: click here. Number of times in the country correlates to the number of days on track. 56.5% (48 times) of all the events I’ve marshaled were in the US. 15.3% (13 times) in New Zealand. 7.1% (6 times) in Australia. 5.9% (5 times) in Canada. 3.5% (3 times) both in Malaysia and Singapore. Go ahead play with the interactive charts by following the Google Docs links, and see all the other stats.

I am working on integrating Circuits and participation onto Google Maps, but it’s a slightly more complicated process here are samples:

map countries

If you have any suggestions for creating fancy stats please share in the comments below and I’ll be happy to post them. More importantly if you’re really good at writing Google Docs Scripts I’d love to get some help in creating a usable Form and subsequent database that I will make available to all the marshals around the world. It’d be amazing to see people’s stats from Brazil, Singapore, Malaysia, France, the Netherlands, the rest of Europe, Asia, the Pacific and of course the Americas.

Remember to use #MarshalLogBook on Twitter and Facebook to spread the word. And like the new facebook page I created just for this project:  facebook.com/pages/Marshal-Log-Book/910500628968577