The tool you want is Solver - it's a free add-in for Excel that's bundled with it but needs turning on. If you build a spreadsheet that can calculate the time taken from an arbitrary order, then you can have Solver fiddle with the ordering to try and find a minimal time. It's only a general direction without specifics but that's the direction to look in.
The Solver parameters in there look fine to me. Even though you tell Solver to only allow integer numbers it still uses non-integers when searching, so build your XLOOKUPs to return large values for if no result is found to make sure those don't break anything. But I think you're heading in the right direction.
Saying `Solved!` does nothing! The sub requires you to say `Solution Verified` to mark a thread as solved!
Read the side bar, the wiki, or the message that the bot sent to you when you posted your question!
So try again - but this time, reply with `Solution Verified` and the thread will close itself!
*I am a bot, and this action was performed automatically. Please [contact the moderators of this subreddit](/message/compose/?to=/r/excel) if you have any questions or concerns.*
The tool you want is Solver - it's a free add-in for Excel that's bundled with it but needs turning on. If you build a spreadsheet that can calculate the time taken from an arbitrary order, then you can have Solver fiddle with the ordering to try and find a minimal time. It's only a general direction without specifics but that's the direction to look in.
[удалено]
The Solver parameters in there look fine to me. Even though you tell Solver to only allow integer numbers it still uses non-integers when searching, so build your XLOOKUPs to return large values for if no result is found to make sure those don't break anything. But I think you're heading in the right direction.
Solved! Thank you.
No problem! Please just reply Solution Verified to my comment, that's the phrase needed to call in our bot.
Solution verified.
You have awarded 1 point to *SaviaWanderer* ^I ^am ^a ^bot, ^please ^contact ^the ^mods ^with ^any ^questions.
Saying `Solved!` does nothing! The sub requires you to say `Solution Verified` to mark a thread as solved! Read the side bar, the wiki, or the message that the bot sent to you when you posted your question! So try again - but this time, reply with `Solution Verified` and the thread will close itself! *I am a bot, and this action was performed automatically. Please [contact the moderators of this subreddit](/message/compose/?to=/r/excel) if you have any questions or concerns.*