+ Reply to Thread
Results 1 to 2 of 2

Order & Production Tracking using Google Data and start-pause-stop timers

  1. #1
    Registered User
    Join Date
    10-26-2013
    Location
    United States
    MS-Off Ver
    Excel 2007
    Posts
    67

    Order & Production Tracking using Google Data and start-pause-stop timers

    My Friend has a company that makes stair treads. They need a solution for tracking their orders. Please help or offer solutions to how to achieve the desired outcome.

    They need to be able to track specific ask throughout the production process. I have created an icon for Start, Pause, and Stop. We want to keep up with the time it takes to complete the task per item. I also need to duplicate the row items every time we have a purchase order comes in. We can download a document from Google that gives us certain information about the product but word prefers to link to the Google Sheet and have it add the Purchase Order as they come in. Throughout the day we receive orders that we need to add to the system and then be able to sort the items so we can produce the product at the same time while we are in that particular component. The timers need to show time when they are running.

    An example is below:
    A customer goes to the online store and makes a purchase for a certain type of stair tread. Once the order is completed it sends a notification to us. once received, we need to be able to import the order. Once the order is received, we need to be able to track its process through production. Throughout the day we are cutting different types of Wood Grades, Maple, Walnut, Oak, etc. At any time we need to check the orders that have been added and sort them to be able to cut those specific materials while in that wood."

    Is there a way to automatically add orders as they come into the web store? If so how.

    Is there a way this can work in a Google Sheet so that more than one person can be working on it at a time?

    Let me know if the excel file did not load and I will re-upload the file.

    Thanks for any help you can provide.
    Last edited by LonnieLSmith; 03-15-2019 at 08:47 AM.

  2. #2
    Registered User
    Join Date
    10-26-2013
    Location
    United States
    MS-Off Ver
    Excel 2007
    Posts
    67

    Re: Order & Production Tracking using Google Data and start-pause-stop timers

    Is there anyone that can help me with this????????
    Last edited by LonnieLSmith; 03-12-2019 at 08:22 AM.

+ 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. Six 30 minute fixed countdown timers with start, stop and reset buttons.
    By Marty62 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-18-2014, 07:31 AM
  2. Replies: 2
    Last Post: 12-18-2014, 02:33 AM
  3. 2 Stop Timers on User Form
    By VJOSHI in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-24-2014, 10:50 AM
  4. Pause Other Timers when another is Started
    By kamalayan in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-01-2014, 07:41 AM
  5. to update stop watch in excel with start/pause and reset options.
    By harry_appu in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-25-2013, 01:42 PM
  6. Display time based data in excel - simple play, pause, stop through data - HELP
    By geekyhawkes in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-13-2012, 01:55 PM
  7. calculating multiple stop/start timers within a cell
    By kmfdm515 in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 01-24-2011, 02:20 PM

Tags for this Thread

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