+ Reply to Thread
Results 1 to 4 of 4

HUGE THANK YOU!! You helped build this!!

  1. #1
    Registered User
    Join Date
    06-12-2012
    Location
    Wichita, Kansas
    MS-Off Ver
    Excel 2010, 2016, 2021-22
    Posts
    87

    HUGE THANK YOU!! You helped build this!!

    First I want to thank everyone who has been helping me over the last couple years. I completed a project that I didn't think was even possible but in the last 2 weeks I have been asked about my project several times and how I did it. So I'd like to share it here in case it can help someone out. I'll give a brief description on what it is... and attach the project.

    First off, it's a Production time tracker and "Takt Timer" which basically records production rates.

    It has a countdown timer that starts when you press start.
    After the countdown timer hits zero, another countdown timer starts that tracks the accumulated time or "overage"
    You put in a production rate, say 5 minutes per part and every 5 minutes the "goal" counter will add 1 to the goal count to see where you should be.
    There's another counter "actual" that tells you how many you actually completed.

    There are 22 toggle buttons, that uses Shift+Ctrl+A and Shift+Ctrl+B and so on that will trigger the toggle switches.
    When all 22 toggle switches are activated, the toggle switches reset, a count is added to "actual" and timer restarts.
    (You can also press "Enter" to bypass the toggle buttons and add a count and reset timer.
    on another tab you'll see that it logs the time for all 22 buttons (stations) so it records station and cycle time
    *This system was set up using programmable USB buttons around a production area that were programmed for the Alt+Ctrl+A and so-on commands.
    Attached Files Attached Files
    Last edited by crowmagnus; 04-12-2018 at 03:19 AM.

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,595

    Re: HUGE THANK YOU!! You helped build this!!

    Thank you for sharing - we rarely get to see the final result of the help we offer, so this is a treat. I'm sure those who helped you get it done will be pleased.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  3. #3
    Registered User
    Join Date
    06-12-2012
    Location
    Wichita, Kansas
    MS-Off Ver
    Excel 2010, 2016, 2021-22
    Posts
    87

    Re: HUGE THANK YOU!! You helped build this!!

    If it wasn't for this community I would have abandoned it long ago, lol.

    But I wanted to share after the 15th time I was asked about the countdown timer, and how it triggered a second timer when it hit 00:00 so I didn't want to be selfish and wanted to share it.
    I think it would be great for someone to reverse engineer and borrow ideas from. Since it involves timers, time logs, dynamic toggles, automatic pauses at break times, and auto export the reports at the end of the day.

  4. #4
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,595

    Re: HUGE THANK YOU!! You helped build this!!

    I wish more of our 'seeking' members thought like you. Some of them can't even be bothered to acknowledge the help given, let alone say "thank you". Luckily, they are the minority.

    Anyway, well done! I shall be having a peek later.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Helped need in modifying VBA code
    By Ash_Maverick in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-16-2017, 10:49 AM
  2. VLOOKUP with Multiple Criteria in Multiple Worksheets
    By fpgary in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-18-2015, 05:58 PM
  3. New to Forum Hope I Can Help as Well as be Helped.
    By jaroesner in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 02-14-2013, 02:56 PM
  4. I have clairified some info., maybe, I can be helped now .........
    By Denny Crane in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-03-2006, 12:55 AM
  5. [SOLVED] huge huge excel file... why?
    By Josh in forum Excel General
    Replies: 12
    Last Post: 02-09-2006, 06:00 PM
  6. [SOLVED] Thanks Jon for your Jan 2001 post......it helped me today!
    By CLR in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 08-14-2005, 12:05 AM

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