+ Reply to Thread
Results 1 to 11 of 11

one stopwatch with 10 assigned hotkeys for splits

  1. #1
    Registered User
    Join Date
    11-17-2012
    Location
    Australia
    MS-Off Ver
    Excel 2007
    Posts
    5

    Red face one stopwatch with 10 assigned hotkeys for splits

    Hello all... before I start ………… please be kind and yes you will see I am very dumb... you are the guru’s

    I am trying to get an accurate excel timer (or as BEST AS one can be) to help me with multiple timing
    Basically, like a swim / track race I can have up ten competitors all starting at the same time.
    I was able to find this one: XCTIMER.XLSM in this forum… (Thank you guys for this)…..in which seems to do most of what I wanted expect for the items below
    So I need the following:
    1. Global start event Trigger 1 X button = START
    a. an assigned linked keyboard hotkey
    2. Global Stop event Trigger 1 X button = STOP
    a. an assigned linked keyboard hotkey
    3. Global Reset event Trigger 1 X button = RESET
    a. An assigned linked keyboard hotkey.
    Now the part I would have more trouble with:
    4. At least 10 split event triggers with 10 different assigned hotkeys running off the main timer, (i dont even know how to start or where to start)

    Functional description
    Start is activated and timer runs every split is recorded with its assigned hotkey next to it Cascaded down a column
    Stop and Reset... do exactly just that
    During whilts timer is running all non assigned keystrokes should be ignored

    If you are unable modify the attached timer macro to do the same as the could you please at least send me in the right direction as how to assign multiple hotkeys to the same function (split) and the how I could get it to identify which hot key was used to trigger the split.
    Any help will be very much appreciated

    attached is the xctimer also found elsewhere in this forum and a picture of how i would like to see the end result with suggested hot keys..
    Attached Images Attached Images
    Attached Files Attached Files

  2. #2
    Forum Expert p24leclerc's Avatar
    Join Date
    07-05-2010
    Location
    Québec
    MS-Off Ver
    Excel 2021
    Posts
    2,081

    Re: one stopwatch with 10 assigned hotkeys for splits

    Don't you want to also record laptime for all 10 competitors? You would get a mattrix of 10 x 10. One column for each competitor and one row for each lap or split time.
    Pierre Leclerc
    _______________________________________________________

    If you like the help you got,
    Click on the STAR "Add reputation" icon at the bottom.

  3. #3
    Registered User
    Join Date
    11-17-2012
    Location
    Australia
    MS-Off Ver
    Excel 2007
    Posts
    5

    Re: one stopwatch with 10 assigned hotkeys for splits

    Thanks for the quick response.. p24leclerc yes that would be a definate advantage. the triggers are to emulating a keyboard hotkey
    in doing so i will also be able to calculate speed through sections of the event. by placing sensors at various points.

    Currently everything is hand timed and the cost of a professional system to do as i asked is ridiculous.. i hope someone can help me modify the above timer to do just that...!

  4. #4
    Forum Expert p24leclerc's Avatar
    Join Date
    07-05-2010
    Location
    Québec
    MS-Off Ver
    Excel 2021
    Posts
    2,081

    Re: one stopwatch with 10 assigned hotkeys for splits

    It could take some times to come up with a solution, but I'll look into that. Keep looking here for development.

  5. #5
    Forum Expert p24leclerc's Avatar
    Join Date
    07-05-2010
    Location
    Québec
    MS-Off Ver
    Excel 2021
    Posts
    2,081

    Re: one stopwatch with 10 assigned hotkeys for splits

    Look at the attached file.
    Keyboard shortcut are programmed as follow:
    SART ="CTRL" s
    STOP = "CRTL" x
    RESET = "CTRL" z
    To record competitor 1 split time = "CTRL" q
    To record competitor 2 split time = "CTRL" w
    To record competitor 3 split time = "CTRL" e
    To record competitor 4 split time = "CTRL" r
    To record competitor 5 split time = "CTRL" t
    To record competitor 6 split time = "CTRL" y
    To record competitor 7 split time = "CTRL" u
    To record competitor 8 split time = "CTRL" i
    To record competitor 9 split time = "CTRL" o
    To record competitor 10 split time = "CTRL" p

    How is that? Good enough?
    Let me know.
    Attached Files Attached Files

  6. #6
    Registered User
    Join Date
    11-17-2012
    Location
    Australia
    MS-Off Ver
    Excel 2007
    Posts
    5

    Re: one stopwatch with 10 assigned hotkeys for splits

    Thank you, i can not get the macro to run currently wont trigger on hotkeys also i notice you have macro for each event trigger is that ok... the way it surposed to be.. thanks again

  7. #7
    Forum Expert p24leclerc's Avatar
    Join Date
    07-05-2010
    Location
    Québec
    MS-Off Ver
    Excel 2021
    Posts
    2,081

    Re: one stopwatch with 10 assigned hotkeys for splits

    I tried it again and it works well on my system.
    I programmed 13 macros. One for each hotkey.
    You have to hold the "Control" key and press the other letter to trigger the macros (as "CRTL" + s)

  8. #8
    Registered User
    Join Date
    11-19-2012
    Location
    Athens
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: one stopwatch with 10 assigned hotkeys for splits

    excelent work thank you!

  9. #9
    Registered User
    Join Date
    11-17-2012
    Location
    Australia
    MS-Off Ver
    Excel 2007
    Posts
    5

    Re: one stopwatch with 10 assigned hotkeys for splits

    very good thank you ... the ctrl key got me..lol
    also thank for you quick work....

    do you know the delay time to run the macro's ?

  10. #10
    Forum Expert p24leclerc's Avatar
    Join Date
    07-05-2010
    Location
    Québec
    MS-Off Ver
    Excel 2021
    Posts
    2,081

    Re: one stopwatch with 10 assigned hotkeys for splits

    On my PC, it seems to be around 0.05 second.
    If you press and hold the Control key then choose any letter for a competitor (say "w") and also hold this letter. This is the fastest the system can be. Look at differences between 2 data. It could be different on your system then mine (Processor, Memory, etc.)
    Regards

  11. #11
    Registered User
    Join Date
    11-17-2012
    Location
    Australia
    MS-Off Ver
    Excel 2007
    Posts
    5

    Re: one stopwatch with 10 assigned hotkeys for splits

    yep i iid the same and came up with between approx 4ms - 4.5ms
    on my main system it was always closer to 4ms so i change the code to reflect this By adding 4ms to the split displayed figure.
    see below(attached) see line 56 (stopwatch macro)

    Pierre Thank you.... you really have done a great job and many will use what you have helped create I just hope they appreciate the efforts people like you go to to !......for one i do !
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1