Uploaded November 2016 | Updated November 2026, 1 day ago
I'm working on a track timer for my electric trike. I started with an invisible beam entry alert from RadioShack. In addition to the buzzer, there is a relay switch inside. Whenever the beam is interrupted, the Normally Open terminal contacts the Ground. To connect the entry alarm to my computer, I ordered a USB switch from P.I. Engineering. The device uses simple audio cables to trigger any action on a computer. The final bit of code I got from the Internet Geeks on How to Auto Insert time-stamp in Google Sheets. I changed the time-stamp format to include milliseconds. So now, when I pass by the invisible beam, the USB switch types the letter "B" for "Back Door", Google Sheets automatically inserts a time-stamp, and the difference is my lap time. Thanks for watching.
P.I. Engineering USB 3 Switch Interface $50 (12 Switch $100)
xkeys.com
Internet Geeks How to Auto Insert Timestamp in Google Sheet
youtube.com/watch?v=_z-L9a_TuBY
Seco-Larm Reflective Photoelectric Beam Sensor $50
seco-larm.com/sensors/photoelectric-beams/E-931-S35RRQ
RadioShack stopped making the invisible beam entry alert.
I'm working on a track timer for my electric trike. I started with an invisible beam entry alert from RadioShack. In addition to the buzzer, there is a relay switch inside. Whenever the beam is interrupted, the Normally Open terminal contacts the Ground. To connect the entry alarm to my computer, I ordered a USB switch from P.I. Engineering. The device uses simple audio cables to trigger any action on a computer. The final bit of code I got from the Internet Geeks on How to Auto Insert time-stamp in Google Sheets. I changed the time-stamp format to include milliseconds. So now, when I pass by the invisible beam, the USB switch types the letter "B" for "Back Door", Google Sheets automatically inserts a time-stamp, and the difference is my lap time. Thanks for watching.
P.I. Engineering USB 3 Switch Interface $50 (12 Switch $100)
xkeys.com
Internet Geeks How to Auto Insert Timestamp in Google Sheet
youtube.com/watch?v=_z-L9a_TuBY
Seco-Larm Reflective Photoelectric Beam Sensor $50
seco-larm.com/sensors/photoelectric-beams/E-931-S35RRQ
RadioShack stopped making the invisible beam entry alert.










