Hello excel Forum people!
I have to find a way to calculate the most number of customers that I can visit in 6 different cities. I have all the permutations of these cities. The issue is that customers are not all available on every day. I have the list of which day each customer is available. I have 1 day in each city over 2 weeks. How can I go about optimizing my flights to visit the most number of customers?
I have included the sheet. Any help would be HUGELY appreciated!!!
This proposed solution employs six helper columns (AI:AN) which may be moved and/or hidden for aesthetic purposes.
The helper columns are populated using*:Formula:
Please Login or Register to view this content.
*Denotes an array entered formula which needs to be confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.
Column AO is populated using: =SUM(AI5:AN5)
The MAX number of customers that may be visited is displayed in cell AB62 using: =MAX(AO5:AO724)
The permutations that produce the max number of customers that may be visited are highlighted in yellow (i.e. columns AC:AO in rows 143, 176, 177 ...).
Let us know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks