Input your car's rear gear, tire specs, and columns of speed and RPM and this sheet will calculate what gear the car was in. Some people on this forum were wanting something to do this, so I wrote this up. It's my small contribution to the community for everything that I've learned (so far, there's much more to learn) around here.

Please give me feedback if it does or doesn't work for you. It may take some work to incorporate it into your log output file. I still haven't tried it but once I get a few things settled out I'll try it.

Spreadsheet is attached to the thread here:
http://www.ls1tech.com/forums/showthread.php?t=201355