Is there a way to restrict solver from changing the varibles (cells allowed to change)?
I have an optimization problem where only a certain amount of records can be used and I have to find the optimal solution. I am using 1s and 0s (1,0) to determine if the record should be included or not. Solver is being used to find the least cost solution based on all the records.
My problem is that I have not been able to find a way to restrict solver from changing my variables to something other than 1s or 0s.
Is this possible?
Also, I have more than the 200 records and thus will have to find a more advanced solver engine unfortunately. Does anyone on here have any recomendations? Perhaps something cheaper than Frontline?
Thanks
I have an optimization problem where only a certain amount of records can be used and I have to find the optimal solution. I am using 1s and 0s (1,0) to determine if the record should be included or not. Solver is being used to find the least cost solution based on all the records.
My problem is that I have not been able to find a way to restrict solver from changing my variables to something other than 1s or 0s.
Is this possible?
Also, I have more than the 200 records and thus will have to find a more advanced solver engine unfortunately. Does anyone on here have any recomendations? Perhaps something cheaper than Frontline?
Thanks
