+ Reply to Thread
Results 1 to 4 of 4

Driver Trip Planning

  1. #1
    Registered User
    Join Date
    03-18-2020
    Location
    India
    MS-Off Ver
    2016
    Posts
    7

    Driver Trip Planning

    Hello Friends,

    I need little help with code or just logic I am unable to build a process flow for the below task; where I need to assign drivers to packages for drop off.

    I have a list of package delivery locations where Delivery Area 1 is closer to Delivery Area 2 and 2 to 3 and so on....and I also have a driver list with their range of packages From min that's the min they should have and max is the max they can have. And I'd like to assign drivers to drop the packages considering its range and delivery load.

    If there are 3 deliveries for Area 1 and 5 deliveries for Area 2, both these area are closer to each other so driver 1 who has 5 - 10 limit should be assigned to this and so on but this driver cant get Area 1 and Area 3 because those areas are far off.

    If there are not enough packages to fill everyone's minimum we can call off remaining drivers if there are extra packages we will request for more drivers

    Please guide with logic or code...this needs to be done using VBA

    Thanks
    Attached Files Attached Files

  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
    79,365

    Re: Driver Trip Planning

    You never acknowledged the solution you were offered here: https://www.excelforum.com/excel-for...employees.html

    We are happy to help, but not if you take the help you get for granted: you are not paying for it and those helping aren't being paid to do so. Please bear this in mind.
    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
    03-18-2020
    Location
    India
    MS-Off Ver
    2016
    Posts
    7

    Re: Driver Trip Planning

    AliGM, My Bad! I should have thanked the one who solved my problem. I have now added reputation to that answer. Thanks for reminding me.

  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
    79,365

    Re: Driver Trip Planning

    That's fine, however you really should post to the thread itself to say thanks and also mark it as solved. Thanks for your co-operation.

+ 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] [microsoft][ODBC Driver Manager] Data source name not found and no default driver specifie
    By FoxyladyAccountant in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 06-03-2019, 01:22 PM
  2. Color change when driver becomes eligible for another trip
    By bob19taylor in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-26-2018, 09:46 AM
  3. how many trip by location ?
    By Mak Man Ina in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-05-2018, 08:46 AM
  4. [SOLVED] Plot a line from beginning to the end of a trip
    By pezalmendra in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 03-04-2015, 03:02 PM
  5. How to calculate rolling time for a trip
    By mmslash in forum Excel General
    Replies: 2
    Last Post: 05-31-2012, 02:54 PM
  6. Excel 2007 : Identify Same Day Trip Starts
    By Ricker090 in forum Excel General
    Replies: 2
    Last Post: 07-04-2010, 09:30 PM
  7. Excel trip
    By tiyara in forum Excel General
    Replies: 1
    Last Post: 08-21-2008, 01: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