Now create a table with weeks along the top and projects along the side. Each entry in the table should indicate how many hours are spent on each project each week. IF functions work here. Finally, create one more table with weeks along the top and managers along the side and use SUMIF functions, based on the data in the previous table, to calculate the number of hours each manager is working each week.

As you can probably guess, you’ll need to use Evolutionary Solver if you set it up this way. Also, you might have to let Evolutionary Solver run for a long time. This is not an easy problem!)