Lap Timing - a fun sheet to think about
Lap Timing - a fun sheet to think about
(OP)
I organize a local low-key track day and we use stopwatch timing to keep things inexpensive.
I've been using a program for a while that has been adapted from slot cars. One of our drivers suggested that we try to come up with one in Excel.
What are your thoughts? I'd like to have a single button for each driver that you click that will put the times down each lap. A simple one that the other driver came up with is one that has a macro button for each LAP that simply checks a cell with the NOW() function in it and subtracts it from the last lap and converts to a lap time. The problem is that we do between 10 and 15 laps per stint which means I would have to set up 75 buttons for 5 people being on the track...
I've been using a program for a while that has been adapted from slot cars. One of our drivers suggested that we try to come up with one in Excel.
What are your thoughts? I'd like to have a single button for each driver that you click that will put the times down each lap. A simple one that the other driver came up with is one that has a macro button for each LAP that simply checks a cell with the NOW() function in it and subtracts it from the last lap and converts to a lap time. The problem is that we do between 10 and 15 laps per stint which means I would have to set up 75 buttons for 5 people being on the track...
If you "heard" it on the internet, it's guilty until proven innocent. - DCS
http://www.eng-tips.com/supportus.cfm





RE: Lap Timing - a fun sheet to think about
If so, then a single button per track should be doable. Your macro would simply move the active cell downward on each lap and store either the absolute time or the calculate the laptime on the fly. How long is a typical lap?
Given free rein and some money, it might be cooler to do all this in a Labview-like environment and some sort of PC I/O card, and have some sort of automatic lap switch being read by Labview for each track. That would allow Labview to correctly determine laptimes to less than 0.1 seconds or so. One could imagine using some sort of photo-interruptor switch on each track as an example.
Labview is obviously gross overkill, but there may be something substantially cheaper that could be found.
TTFN
FAQ731-376: Eng-Tips.com Forum Policies
RE: Lap Timing - a fun sheet to think about
Why couldn't you use 5 buttons... one per car/driver? Excel keeps track of how many laps are elapsed based on how many times a given driver's button has been pushed.
=====================================
Eng-tips forums: The best place on the web for engineering discussions.
RE: Lap Timing - a fun sheet to think about
the DI-148 has 6 digital I/O lines, and the software that comes with it can output to Excel.
the price is $50, which supposedly comes with the the Lite version of the software, which appears to be adequate for your application.
TTFN
FAQ731-376: Eng-Tips.com Forum Policies
RE: Lap Timing - a fun sheet to think about
Currently it handles 3 cars and 18 laps, but it's modular car wise, so if you need to handle more cars, just add more buttons.
http://f
One user form controls everything. Here's how to use it.
Enter the car numbers for the session in the text boxes - one car number per box.
Click the "Set Car #s" button. This will relabel the important buttons and fill in some row and column headings on sheet1.
When the green flag drops on the session, click the "Start Session" button. This will set the start time for all cars.
As each car crosses the line, click the button with that car number. This will record the time that that car crossed the line in the next open lap number for that car.
That's it.
If you need lap times you can do the subtraction on a separate sheet, or modify the code.
RE: Lap Timing - a fun sheet to think about
If you "heard" it on the internet, it's guilty until proven innocent. - DCS
http://www.eng-tips.com/supportus.cfm
RE: Lap Timing - a fun sheet to think about
Then you'll need to open the VBA editor (Alt-F11), open UserForm1 and manually run it.
I didn't put in any fancy frills like AutoRun.
RE: Lap Timing - a fun sheet to think about
Thanks MintJulep!
If you "heard" it on the internet, it's guilty until proven innocent. - DCS
http://www.eng-tips.com/supportus.cfm
RE: Lap Timing - a fun sheet to think about
CODE
Target.NumberFormat = "hh:mm:ss"
Target.Value = "=now()"
Target.Copy
Target.PasteSpecial Paste:=xlPasteValues
End Sub
It will work as is, but would improve with a bit of refining:
» In its present crude incarnation, you would need to open the spreadsheet WITHOUT macros activated to construct your table. Then save and re-open WITH macros to record your actual times. Then save and re-open WITHOUT macros to play with the results. It should not be too hard to have the time-insertion facility able to be turned on and off from within the spreadsheet itself.
» Protection could be used to prevent the inadvertent clobberation of non-time cells.
» Successive clicks in the one cell (without an intermediate click in a different cell) does not update the entry (because the "selection" has not "changed"). I'm sure there would be a way around this, but don't have the time to pursue it right now.