Results 1 to 4 of 4
  1. #1
    Join Date
    Jun 2007
    Posts
    18

    Unanswered: Fomatting, I am at a loss

    I have a spreadsheet that users enter the data into a form and it appends to the spreadsheet (Entry)
    What I am trying to do is go through the cells and do some checks for 2 many loads arriving in a time window.

    Example:

    Hub DTMI has 3 fruit loads arriving on 07/07/07 between the hours of 14:23 & 18:58. Depending on the volume on the trailer to unload we can only recieve 2 trailers within a 6 hour window.

    So the first trailer arrives at 14:23 takes approx 7 hours to unload putting it's finish time at about 21:00
    The next trailer arrives at 18:54 and will take approx 4 hours to unload putting it's finish time about 22:30
    The next trailer they schedule to arrive is 18:58 but there are already 2 loads out there meaing the next load can't arrive in our yard until 21:00 to be unloaded.

    Is there a way to flag that entry based on Hub Name, Date of Arrival and Finish Times or Arrival Time

    I included the spreadsheet highlighting the row with Red that would be a problem.

    Any Help Greatly Appreciated.
    Attached Files Attached Files

  2. #2
    Join Date
    May 2004
    Location
    New York State
    Posts
    1,178
    1) Do you know how many usable bays each hub has? Is this information in a table?

    2) Do you have the knowhow to compute - or even estimate - how long a trailer will take to unload?

    3) Do you demand that the drivers call ahead of time for delivery appointments? Do you record all appointments in the table?

    Sam

  3. #3
    Join Date
    Jun 2007
    Posts
    18
    The bays has nothing to do with this info. We have upto 30 dock doors. But we can only unload 2 trailers of fruit at a time.

    We compute the time to unload as for every 1000 packages it takes an hour.

    As for demand we give them the hours the hours that they can schedule the loads and then our ASR does the entry for each load at each hub.

    None of this is in a table. It is all in a spreadsheet as they requested.

  4. #4
    Join Date
    May 2004
    Location
    New York State
    Posts
    1,178
    I would suggest a VBA macro for this. You might have columns like this: Loc, Name, Date In, Est Time In, Est Hrs, Date Out, Est Time Out. Program a macro that will prompt you (with an input box) for two things: the date in, and the estimated hours (or, if you prefer, the quantity of packages, which can be divided). Give the macro the smarts to read the columns and decide the proper location (either 1 or 2) and estimate the earliest time in available, as well as the hours and estimated date/time out. The macro should either tell you (display) or actually fill in the appropriate cells with this info. You can then fill in the rest of the columns manually. (BTW, by Name I mean trucking company name.)

    Sam

Posting Permissions

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