+ Reply to Thread
Results 1 to 6 of 6

Excel 2007 logic formula help

  1. #1
    Registered User
    Join Date
    01-17-2011
    Location
    North Carolina
    MS-Off Ver
    Excel 2007
    Posts
    3

    Excel 2007 logic formula help

    Hello all! I've reached a point where I've spent so much time trying to figure out the formula format that I'm resorting to help. Thats rare for me

    I'm new here, so if this is in the wrong location, please move or let me know and I'll move it.

    I'm working with Excel 2007.

    I have a very basic spreadsheet that I use to record car racing lap times, etc. This works great but I have to manually enter everything and want to make it more user friendly. Instead of recording each car's number and time on a piece of paper by hand, I'd like to just enter the time into the spreadsheet right away as the cars cross the start/finish line. However, with 20+ vehicles passing by quickly, it can be difficult to identify the vehicle number, find it in the spreadsheet, look at the time, enter it in the appropriate lap's cell, etc. Way too much work and time consuming for a race and have it be accurate.

    What I'd like to do (trying to do) is develop a formula table that as each vehicle passes by the finish line, use a USB numerical keypad to just enter the vehicle number. I'd like the table to timestamp each vehicle's lap as I enter it and then transpose that time in the appropriate cell for the lap for each vehicle.

    I'm OK with Excel but I've never used it to this degree and can't figure out the best way to develop the table or the formula format. I think I have it figured out for 1 vehicle number using the IF logic function but I may have more than 20+ vehicles numbers it needs to be able to work with that many vehicle numbers.

    I'm a little lost and frustrated. Anyone have any ideas? I know there are some Excel gurus out there.


    Thanks in advance!
    Rob

  2. #2
    Forum Guru (RIP) Marcol's Avatar
    Join Date
    12-23-2009
    Location
    Fife, Scotland
    MS-Off Ver
    Excel '97 & 2003/7
    Posts
    7,216

    Re: Excel 2007 logic formula help

    See if this workbook gives you any ideas.

    Enter the Car IDs before the race begins.

    Click on each car as it finishes. Times will only be as good as you are.

    Hope this helps
    Attached Files Attached Files
    If you need any more information, please feel free to ask.

    However,If this takes care of your needs, please select Thread Tools from menu above and set this topic to SOLVED. It helps everybody! ....

    Also
    اس کی مدد کرتا ہے اگر
    شکریہ کہنے کے لئے سٹار کلک کریں
    If you are satisfied by any members response to your problem please consider using the small Star icon bottom left of their post to show your appreciation.

  3. #3
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,164

    Re: Excel 2007 logic formula help

    Hi Rob,

    Find the attached where I expect you to enter a car number in F2 and the lap time will appear. If you start in F2 and enter a number you will end up in F2 again to enter the next car number. This is a little different than the above method.
    Attached Files Attached Files
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  4. #4
    Registered User
    Join Date
    01-17-2011
    Location
    North Carolina
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: Excel 2007 logic formula help

    Wow you guys are fast!


    OK, I like both options but how about something with multiple laps?

    I'm still lost on the forumla developement and trying to adapt what was posted for multiple laps.
    Last edited by Rob#1; 01-17-2011 at 05:59 PM.

  5. #5
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,164

    Re: Excel 2007 logic formula help

    Hi,
    The way mine works is by using VBA code behind your sheet1. If the cell A1 changes then I run the code. The code searches for that car number in the table below it and put in the time you pressed Enter. It also calculates the time since the last lap. I've added some code so it copies the lap times to the table to the right.

    This should be a good enough example to get you learning VBA. You can do a lot more things like draw graphs or do differences between lap times from this starting example.

    See the attached file with a few more features.
    Attached Files Attached Files

  6. #6
    Registered User
    Join Date
    01-17-2011
    Location
    North Carolina
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: Excel 2007 logic formula help

    Hmm, that looks like a good start.

    I'm not familar with VBA, so its time to start learning!

    Thanks for the help! I'm sure I'll be back with more questions

+ 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