ExcelMate your new friend?

Timing System

Moderator: Jani Soderhall

Michael Stride
Octane Sport (RIP)
Octane Sport (RIP)
Posts: 594
Joined: Sat Jul 12, 2003 2:00 am
Location: UK
Contact:

Post by Michael Stride » Sun Dec 30, 2007 1:22 pm

Excellent work Marcus!

Can the number/time dispaly be put on sperate screens, or do you have to relay on the multiple screen mode on Windows to put them on a seperate display?

From my point of veiw legibility is a factor for displaying times. There are some great 'LCD' type fonts here: Link to Dafont.com

But that is mimicing an LCD display, if your using monitors you dont need to mimic anything except perhaps for aesthetics. For legibility using a 'monospace' font , where each numeral is put in an evenly spaced box makes for good legiblity when displaying two times next to each other or on top of each other. A font such as Courior Bold mimics an old typewriter, so the decimal point will always be in the same position for legibility.

Using yellow on black makes for a very good contrast too. Thats what most sports screens use.
Image

When one competitor gets a time in a differnt second the decimal point remains in the same place with 'monospace' fonts:
Image

Marcus Seyffarth
Posts: 607
Joined: Mon Sep 02, 2002 2:00 am
Location: Stockholm, Sweden
Contact:

Post by Marcus Seyffarth » Sat Dec 29, 2007 11:53 pm

latest version (1.2) is ready for download now.

http://www.ettsexett.com/200/ExcelMateSetup.msi

and the display here
http://www.ettsexett.com/200/SlalomDisplaySetup.msi

Todo: test more, update manual and supply a "digital look" font for the display.

Please try it and give me some feedback. Thanks!

Marcus Seyffarth
Posts: 607
Joined: Mon Sep 02, 2002 2:00 am
Location: Stockholm, Sweden
Contact:

Post by Marcus Seyffarth » Sat Dec 29, 2007 9:03 pm

Well, that was christmas.

We are running a small series of competitions in a garage here in Stockholm so we took the opportunity to test the system today and it worked GREAT!

We had two minor problems that was easialy fixed. First it was people that showed up late and needed to be put into the excel sheets after the race started. We just added them into the spreadsheet and switched back and forth between the worksheets (with the application) and they appered in the dropdowns and could be part of the race.

Second, the race was best of three runs, and the spreadsheet only had 2 runs so we saved the first two and then we overwrote the slowest if the third was faster.

I'm gonna adjust the size a bit, and fix some messages (only cosmetic changes that is) and then it will be available for download.

The new version have 2 tabs. One with settings such as filenames, ports used on the computer, if external displays should be used and what discipline we currently run. It looks like this:
Image

The next tab just shows the riders, the times and the save + reset buttons. The program with the excel sheets behind (like they are when the race is running) looks like this:
Image

As I said before I wrote up a display that could be used. The display starts showing running time 4 seconds after you press reset (at the fourth beep) and will show running time until the racer finishes when it will show the final raw time. This is only useful when people start AT the fourth beep since the time will start running and if you use "start whenever you feel like" the time will seem to be a certain amount once the racer crosses the line and then "jump" to the correct time. Not a problem at head 2 head but in single lane it might be confusing.

Anyways, the display looks like this:
Image

The window can be resized to any size and you can select your favourite font at any size.

First impression is that it was a very easy to use, made the timekeeping a breeze and no times were lost.

Jani Soderhall
ISSA President 2011-2024
ISSA President 2011-2024
Posts: 4702
Joined: Thu Aug 22, 2002 2:00 am
Location: Sweden, lives in France
Contact:

Re: Version 2

Post by Jani Soderhall » Mon Dec 24, 2007 12:38 pm

Marcus Seyffarth wrote:Version 2 with pc display is ready. Will upload app and pics soon. Now we need a display or lots of pc's
Yes!! A lot of PC's is not really a big problem. Do you think we can use PC displays instead of LCD displays like Michael's?

How did you get the clock moving in accordance with the TrackMate?

/Jani

Marcus Seyffarth
Posts: 607
Joined: Mon Sep 02, 2002 2:00 am
Location: Stockholm, Sweden
Contact:

Version 2

Post by Marcus Seyffarth » Fri Dec 21, 2007 5:17 pm

Version 2 with pc display is ready. Will upload app and pics soon. Now we need a display or lots of pc's

Jani Soderhall
ISSA President 2011-2024
ISSA President 2011-2024
Posts: 4702
Joined: Thu Aug 22, 2002 2:00 am
Location: Sweden, lives in France
Contact:

Post by Jani Soderhall » Fri Dec 21, 2007 8:40 am

Wesley Tucker wrote:I must have got one " in between" the old phone-jack TrakMates and what is available now. Mine has a 15-pin DIN in the back, not a 9-pin on the side.

I guess a 15-pin DIN-to-USB converter might do the same job.
I'm sorry WT, I think you're out of luck on this one. You probably need to get a new Trackmate.

If anyone in Europe wants one the new ones, I can sell one. I bought extras just to persuade Trackmate to make the PC output. Now that it's done I'm hoping for Marcus to continue his excellent job, so that we can actually use it. I haven't had the time to worry about that part yet, but it would be cool if we could have this working for the 2008 race circuit!

/Jani

Michael Stride
Octane Sport (RIP)
Octane Sport (RIP)
Posts: 594
Joined: Sat Jul 12, 2003 2:00 am
Location: UK
Contact:

Post by Michael Stride » Thu Dec 20, 2007 9:50 pm

Cheapest ive found the display is here:
http://cgi.ebay.co.uk/ws/eBayISAPI.dll? ... :IT&ih=020

They do answer queries, as I was after the display with a clock function integrated and this they couldnt do....I have also looked all over my dispaly to see if it has a manufacturers mark on it but I cant find one.

Anyway, there probably is a place in China making these.

The advantage of the LCD is battery power. It runs on 9v. However at night youd want LEDs.....

I think one way to do displays is to build one out of 8" 7 segment LED dispaly which are available quite cheaply....

Mind you Id love a retro 'nixie' clock at a race one day.....cool as....
http://madlabs.info/assets/images/nixie ... _big_1.jpg

Marcus Seyffarth
Posts: 607
Joined: Mon Sep 02, 2002 2:00 am
Location: Stockholm, Sweden
Contact:

Post by Marcus Seyffarth » Thu Dec 20, 2007 9:49 pm

15 pin DIN? I checked and I have version 6.3, its got two 9 pins and one 25 pins on the back and one 9 pin on the side. Like this
Image


Sure you could use another PC as a display, although the reflecting displays could be seen further away. I'll build a PC display app first, its the same procedure to show the data so if we find a display its all in place already.
Last edited by Marcus Seyffarth on Thu Dec 20, 2007 9:52 pm, edited 1 time in total.

Wesley Tucker
1961-2013 (RIP)
1961-2013 (RIP)
Posts: 3279
Joined: Tue Aug 27, 2002 2:00 am

Post by Wesley Tucker » Thu Dec 20, 2007 8:02 pm

I must have got one " in between" the old phone-jack TrakMates and what is available now. Mine has a 15-pin DIN in the back, not a 9-pin on the side.

I guess a 15-pin DIN-to-USB converter might do the same job.
Image

Sj Kalliokoski
Posts: 253
Joined: Tue Jul 24, 2007 8:53 am
Location: Finland
Contact:

Post by Sj Kalliokoski » Thu Dec 20, 2007 7:43 pm

Cant you use additional PC screen as time display?
-pokkis
Image

Marcus Seyffarth
Posts: 607
Joined: Mon Sep 02, 2002 2:00 am
Location: Stockholm, Sweden
Contact:

Post by Marcus Seyffarth » Thu Dec 20, 2007 1:25 pm

I just got an email back from Howard (gunfighter.com) and he does not sell the display alone. I guess it must be someone that manufactures these where we can buy them, or some other display that we could use.

I don't think its a problem getting the running time to work ok in dual lane mode. However in single lane mode, people can start whenever they want after the beeps (sometime we don't even use the beeps in single lane) and the trackmate does not output any reaction time at all so we can't adjust the time to that either. Perhaps Daniel at Trackmate could do a firmware upgrade so that it outputs a "0.00" reaction time whenever the racer crosses the starting line. Then it would be possible.

I'll build something just to show the running time, but we do need to find a display.

Ideas?

Jani Soderhall
ISSA President 2011-2024
ISSA President 2011-2024
Posts: 4702
Joined: Thu Aug 22, 2002 2:00 am
Location: Sweden, lives in France
Contact:

Post by Jani Soderhall » Wed Dec 19, 2007 10:06 pm

Marcus Seyffarth wrote:You should probably have one screen for each lane then as well... Hmm. I'll check out the displays that you have used perhaps this is an easy task.
Good thinking Marcus, I've been looking at those displays and I'll immediately buy a couple if you can sort out the running times!

/Jani

Marcus Seyffarth
Posts: 607
Joined: Mon Sep 02, 2002 2:00 am
Location: Stockholm, Sweden
Contact:

Post by Marcus Seyffarth » Wed Dec 19, 2007 11:09 am

Possibly the first live tests... Looking forward to hear the outcome!

Vincent Berruchon
Vinzzzzz
Vinzzzzz
Posts: 575
Joined: Fri May 30, 2003 2:00 am
Location: Paris, France
Contact:

Post by Vincent Berruchon » Wed Dec 19, 2007 10:59 am

You rock Marcus ;)

Will try to test it during the next Pirate Race in January (22th)
[ www.pavel-skates.com ] [ www.riderz.net ]
"Dont care what the World say - I and I could a never go astray -Well wee gona have Things our Way" - Robert Nesta Marley

Marcus Seyffarth
Posts: 607
Joined: Mon Sep 02, 2002 2:00 am
Location: Stockholm, Sweden
Contact:

Post by Marcus Seyffarth » Wed Dec 19, 2007 10:00 am

I would say get a new Trackmate.

I haven't used or upgraded the 161 timer in a long while, standalone timers are the way to go I believe.

I guess you could output some running time on another COM port to a screen. Perhaps that is version 2.0. I wanted it to keep it as simple as possible for now.

The problem is that the trackmate does not give out any running time, only timestamps when a racer crosses the strip. So the running time would be a dummy time just to display something. I should probably work as long as you start the races from the application.

You should probably have one screen for each lane then as well... Hmm. I'll check out the displays that you have used perhaps this is an easy task.

Michael Stride
Octane Sport (RIP)
Octane Sport (RIP)
Posts: 594
Joined: Sat Jul 12, 2003 2:00 am
Location: UK
Contact:

Post by Michael Stride » Wed Dec 19, 2007 9:49 am

Excel - ent!

Of course the UKSSA Trackmate is the older one...... which makes it a difficult descision whether to upgrade or buy a newer one, or use the laptop only as a timer like in the excettset sytem?


personnally I like the idea of using a standalone timer, the Trackmate, with the PC like this.

What Id really like now is being able to diplay just the times as they run onto screens, either dedicated sports screens or flatscreens that are getting cheaper these days.

Well done!!!!

Marcus Seyffarth
Posts: 607
Joined: Mon Sep 02, 2002 2:00 am
Location: Stockholm, Sweden
Contact:

Post by Marcus Seyffarth » Wed Dec 19, 2007 9:41 am

Thank you, whats a man to do when there is nothing at work?

I can answer the question about the firmware upgrade. No there is no firmware upgrade.

I bought a new trackmate in december 2005 and it was said that it should come an upgrade. However when Jani finally got Daniel to create the new version a completely new port was added to the trackmate. So if you have the old ones (with "Start", "Stop" and "Speaker" ports) you need to get one that have the additional "To PC" port on the short side of the device.

On the other hand this is probably only needed at competitions so a few new ones on either side of the atlantic is probably enough. Given that you like the application of course.

As mentioned above there is a pic of how the new ones look in the PDF
http://www.ettsexett.com/200/ExcelMate.PDF

Donald Campbell
Pavel
Pavel
Posts: 2036
Joined: Mon Apr 26, 2004 8:49 pm
Location: germany
Contact:

Post by Donald Campbell » Wed Dec 19, 2007 8:08 am

thanks go to marcus in sweden for creating the program
marcus is somebody who cares and i highly appreciate his kind efforts!!!!!!!!!

thank you marcus!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

William Tway
Timing Guru
Timing Guru
Posts: 420
Joined: Fri Aug 30, 2002 2:00 am
Location: Vista, NY
Contact:

Post by William Tway » Wed Dec 19, 2007 4:55 am

Good question Pat.

I'll give Daniel at TM a call and see what he thinks.

Cheers,

Tway

Pat Chewning
Pat C.
Pat C.
Posts: 1400
Joined: Mon Sep 16, 2002 2:00 am
Location: Portland Oregon

Is there an upgrade path from current trackmates to 5.1?

Post by Pat Chewning » Wed Dec 19, 2007 2:04 am

For those of us with older Trackmate systems, is there an upgrade path to get the computer connection and the FW upgrade to enable connecting to a computer?

Or do we have to buy a new Trackmate?

============================

GOOD JOB MARCUS! This will be a real boon for racing...

William Tway
Timing Guru
Timing Guru
Posts: 420
Joined: Fri Aug 30, 2002 2:00 am
Location: Vista, NY
Contact:

Post by William Tway » Wed Dec 19, 2007 1:10 am

Brilliant.

Feliz Navidad.

Guillermo.

Marcus Seyffarth
Posts: 607
Joined: Mon Sep 02, 2002 2:00 am
Location: Stockholm, Sweden
Contact:

Post by Marcus Seyffarth » Tue Dec 18, 2007 11:59 pm

Please do. At least to the ones that might host a race. Thank you!

Daniel Gesmer
Seismic Skate Sys.
Seismic Skate Sys.
Posts: 227
Joined: Fri Aug 23, 2002 2:00 am
Location: Seismic Skate Systems, Inc.
Contact:

Post by Daniel Gesmer » Tue Dec 18, 2007 11:48 pm

Marcus, many of the addresses on your email list are out-of-date. Would you like me to forward your announcement to everyone on my active racer list?
Dan Gesmer
Head of Seismic Skate Systems
Email : dan@seismicskate.com
Tel : +1 720-937-8948

Marcus Seyffarth
Posts: 607
Joined: Mon Sep 02, 2002 2:00 am
Location: Stockholm, Sweden
Contact:

Post by Marcus Seyffarth » Tue Dec 18, 2007 11:44 pm

Yes. I thought it was 6.0 but perhaps its 5.1. Anyways, the newer ones with the "TO PC" on the short side. There's a picture of it in the ExcelMate PDF.

/Marcus

Wesley Tucker
1961-2013 (RIP)
1961-2013 (RIP)
Posts: 3279
Joined: Tue Aug 27, 2002 2:00 am

Post by Wesley Tucker » Tue Dec 18, 2007 11:41 pm

Marcus,

Before EVERYBODY gets excited, I am assuming your system required Trak Mate 5.1 and above with the DIN ports?

Image
Image

Marcus Seyffarth
Posts: 607
Joined: Mon Sep 02, 2002 2:00 am
Location: Stockholm, Sweden
Contact:

ExcelMate your new friend?

Post by Marcus Seyffarth » Tue Dec 18, 2007 11:31 pm

=========================================================================
Note!
Find latest versions on the ISSA resource page.

Support for ExcelMate is not done by Marcus anymore.
And the www.ettsexett.com website does not exist anymore.

But, please continue posting here if you need.
And help will come from the ISSA community.

=========================================================================

Finally its here, the small helper program that connects the new version of Trackmates to Dan Gesmers legendary Excel spread sheets.

Please download it, try it and give me feedback so that 2008 can be the year where no typos were made!

The program will run on pretty much any PC. If people like it I'll do my best to port it to Mac, however I think it will be pretty hard compared to borrowing someones PC.

Download an installer file from here (always gives the latest version):
http://www.ettsexett.com/200/ExcelMateSetup.msi

Download a quick guide here (it is part of the package above)
http://www.ettsexett.com/200/ExcelMate.PDF


2014 update: copies of useful links to the original top post of this thread...

Update: Display applications
In order to be able to run 2 display applications on one computer I have compiled 2 different versions that uses different internal .Net threads and delegate names. Computer mumbo jumbo, but trust me its got to be that way if you intend to show both lanes on one computer.

Download them at:
http://www.ettsexett.com/200/SlalomDisp ... pLane1.msi
http://www.ettsexett.com/200/SlalomDisp ... pLane2.msi

Older version:
http://www.ettsexett.com/200/SlalomDisplaySetup.msi

Neil Orta wrote:How do you set Windows 7 to treat a program as 32 bit?
http://windows.microsoft.com/en-US/wind ... of-Windows

Let me know what you think!

/Marcus

Post Reply