So I'm attempting to set up a Solver that will give me the highest projected points, but I'm running into a problem coming up with the constraints due to players having multiple position eligibility.
I've been able to come up with pretty good lineups using players that don't have multiple position eligibility, but I know I'm leaving some points on the table every night.
My first thought was to create a macro that would make a duplicate row below each player that has multiple positions. The first row would then contain the first position and the created row would contain the second position. I'm pretty bad at VBA so that isn't the most ideal approach, but I know it could be done that way.
Does anyone have any insight on this situation? Avoiding VBA would be the best solution
0% Agree (0 votes)