+ Reply to Thread
Results 1 to 10 of 10

Which trucks and trailers are still in the yard

  1. #1
    Registered User
    Join Date
    03-07-2021
    Location
    toronto
    MS-Off Ver
    2016
    Posts
    5

    Which trucks and trailers are still in the yard

    Hi,

    Hope everyone is doing well.

    I am trying to figure a way to tell which trucks and trailers are remaining in the yard at an given time.

    Attached is same data for your reference. "N/A" under the trailer column refers to the fact that the truck came in/out without a trailer.
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft? Excel? for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,005

    Re: Which trucks and trailers are still in the yard

    What ouput is expected when you say "are remaining in the yard at an given time."

    Trock 2101 is in at 11:48 AM and out at 12:01 so at 11:45 "not in" and 12:05 "not in" .....

    Do you want number of trucks and trailers in/out in hourly periods?

  3. #3
    Registered User
    Join Date
    03-07-2021
    Location
    toronto
    MS-Off Ver
    2016
    Posts
    5

    Re: Which trucks and trailers are still in the yard

    Thank you John for your response.

    Yes I want to know number of trucks and trailers in/out every 4 hour periods but also I want to know the actual truck # and actual trailer # of those remaining in the yard.

  4. #4
    Valued Forum Contributor
    Join Date
    12-28-2014
    Location
    NSW, Australia
    MS-Off Ver
    MS365
    Posts
    604

    Re: Which trucks and trailers are still in the yard

    Hi, this might be too simple for what you want, but if you only want to know what is available "at the CURRENT moment" then this might work.

    This following formula counts the number of times the truck (or trailer) is listed in the spreadsheet.
    If the count is ODD then it assumes the truck is out, if EVEN then assumes it is available.

    Please Login or Register  to view this content.
    Edit: Just saw the responses that beat me. Looks like mine is too simple
    Good luck mate.
    Attached Files Attached Files
    Last edited by Beamernsw; 03-07-2021 at 10:16 AM.

  5. #5
    Registered User
    Join Date
    03-07-2021
    Location
    toronto
    MS-Off Ver
    2016
    Posts
    5

    Re: Which trucks and trailers are still in the yard

    Hi Beamernsw,

    Thank you for your response.

    I quickly looked at "Availability List" under column D for the trailer availability and took trailer 53126 as an example and it says it is "out" but it should actually be "Available" because it came into the yard at 11:48AM and it never left the yard.

  6. #6
    Valued Forum Contributor
    Join Date
    12-28-2014
    Location
    NSW, Australia
    MS-Off Ver
    MS365
    Posts
    604

    Re: Which trucks and trailers are still in the yard

    ahh true, thats because the data in your sample never showed it going out. I just assumed the data would show trucks and trailers going out before coming in.

  7. #7
    Registered User
    Join Date
    03-07-2021
    Location
    toronto
    MS-Off Ver
    2016
    Posts
    5

    Re: Which trucks and trailers are still in the yard

    Oh I see . Is there a way to make it dependent on the time in and time out so that if it is a time in entry that means it is "available" and if it is a time out entry that means it is "Out"?

  8. #8
    Forum Expert torachan's Avatar
    Join Date
    12-27-2012
    Location
    market harborough, england
    MS-Off Ver
    Excel 2010
    Posts
    4,295

    Re: Which trucks and trailers are still in the yard

    Macro on green button - no on sheet formula.
    torachan.
    Attached Files Attached Files
    Last edited by torachan; 03-09-2021 at 09:03 AM. Reason: new file - tweak to rid yard trailer list of N/A

  9. #9
    Registered User
    Join Date
    03-07-2021
    Location
    toronto
    MS-Off Ver
    2016
    Posts
    5

    Re: Which trucks and trailers are still in the yard

    Thank you so much Torachan the solution is working perfect. I greatly appreciate your help.

    Regards

  10. #10
    Forum Expert torachan's Avatar
    Join Date
    12-27-2012
    Location
    market harborough, england
    MS-Off Ver
    Excel 2010
    Posts
    4,295

    Re: Which trucks and trailers are still in the yard

    Thanks for the feedback.
    Happy to oblige.
    torachan.

+ 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. Using Excel for trailer Yard Inventory
    By stealthemoon in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 01-24-2023, 08:35 PM
  2. [SOLVED] Locate new trucks
    By makinmomb in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-10-2019, 04:13 AM
  3. Cubic yard calculator
    By dwetexas in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-13-2016, 01:56 PM
  4. Rebar yard optimization with excel
    By rsp1 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 02-05-2015, 12:38 AM
  5. Auto populate the amount of trailers used
    By nigeljohnson in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-18-2013, 07:05 PM
  6. Overhead yard inventory map
    By stealthemoon in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-12-2011, 01:20 PM
  7. finding data-column containing the number of trucks
    By SheriTingle in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-12-2005, 04:05 PM

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