Hi

I've done some basic linear programming in the past using Excel but that has always been with integer values.

In this case I'm trying to create an optimized workflow. Each employee works in a specific team and has a productivity associated with that team. Each employee can also work in other teams but will be less productive

e.g. Employee 1 productivity
Team A: 100%
Team B: 70%
Team C: 40%

I'm trying to optimize the workflow for given days but instead of changing a physical integer quantity, I would like to change the Team (e.g. from A to B if Team B is understaffed).

However, I don't know if it is possible to use solver for this sort of problem. I'm still trying to optimize production but not by changing an integer quantity but a category with an associated value.

Anyone know if this is possible?

Thanks.