Is this possible?

**dzuyd** · 07-31-2010, 03:03 PM

thanks man, did you do the excel from scratch? what awesome use of excel and trig! I think i'm going to try this out for our local roads.

**Pepe** · 07-31-2010, 07:41 PM

pretty fuckin sweet for sure

**Dunc** · 08-01-2010, 05:47 PM

Originally Posted by dzuyd

thanks man, did you do the excel from scratch? what awesome use of excel and trig! I think i'm going to try this out for our local roads.

Yeah pretty much. I did find the "lat-long conversion" tab online when I was searching for information on the Haversine formula. It wasn't quite what I needed so that had to be modified. Everything else I had to do from scratch.

**CephasGT** · 08-01-2010, 07:47 PM

Wow, that's completely bad ass, man. I have RaceChrono on my phone, but haven't had a chance to try it out yet. (Also, my phone blows ass, so half the time the GPS won't work with anything but Google Maps for some reason). What phone are you using?

**Dunc** · 08-01-2010, 11:11 PM

Originally Posted by CephasGT

Wow, that's completely bad ass, man. I have RaceChrono on my phone, but haven't had a chance to try it out yet. (Also, my phone blows ass, so half the time the GPS won't work with anything but Google Maps for some reason). What phone are you using?

I'm using the Motorola Droid. Trackmaster is available on any Android phone according to their website.

**The_Wood** · 08-02-2010, 06:59 PM

you sir, kick ass.

**Azr6** · 08-02-2010, 08:29 PM

This is really sick. So you got a little rig for your phone on your bike or you just stash it in the tail?

**dzuyd** · 08-02-2010, 08:51 PM

^+1 i'm curious to how you got your mounting system set up

**Azr6** · 08-02-2010, 10:31 PM

Originally Posted by dzuyd

^+1 i'm curious to how you got your mounting system set up

Yesssss please. So you basically have your phone record the data then load it up into the excel sheet you made and it puts in the coordinates for whichever track you have input into the sheet?

**Dunc** · 08-03-2010, 12:07 AM

Originally Posted by dzuyd

^+1 i'm curious to how you got your mounting system set up

I bought this. It's a water proof box that the Droid just barely fits in. I took a Dremel with a sanding drum to the inside of the boxes corners to give it just a hair more room. Not a lot of material was taken off...just a quick touch of the sanding drum.

Then I just use that little rubber tie down strap that is supposed to hold the tool kit in the tail. The small box fits perfectly in the tail. The medium may fit, but it might be too big. The phones touch screen still works through that rubber film that comes with the box.

I figure that the box coupled with being inside of the tail should be plenty for crash protection. Not only that but you can still put on some rain tires and keep logging

Originally Posted by Azr6

Yesssss please. So you basically have your phone record the data then load it up into the excel sheet you made and it puts in the coordinates for whichever track you have input into the sheet?

Basically yes. The phone simply logs and can do instant reviews. The main portion of the work is done by Excel. It puts all the lat & long coordinates logged by the phone through some trigonometry equations and then out pops a track map in the right format that's needed for the animation software.

EDIT: I'm going to make a detail write on the Excel portion over the next couple of days for a local riding forum. Some of the guys here were interested in a step by step for the Excel part. If you guys are interested in that then just let me know and I'll post it here too.