Forum Discussion
Solved
Solving 'The Assignment Problem' with Lambda
The Setup The problem is simple. Given a 'cost matrix', assign tasks to workers to minimize total cost needed to complete the tasks. Workers may not perform more than 1 task. Assignment p...
In attached file PQ Assignment2 generates the required rows only
Though, it's slower than djclements initial approach (PQ Assignment1)
Great work! I'm sure I can't offer any improvements to your formula, but this inspired me to create something demonstrating the same with Python in Excel, though it doesn't deal with the "multiple solutions" part.
In case it's of interest:
https://www.linkedin.com/posts/owenhprice_linear-sum-assignment-using-python-in-excel-activity-7141472947608666112-IUqb
- Thanks for the reply! Your video looks interesting and I'll be watching it when I'm off work.
