Hello my fellow Excellers!
I have a practical issue which appears simple at first but reveals itself being tricky (at least for me) , the problem is the following :
In my Solver Model there are several variables which can range from let's say 1000 to 100000+ and are sold by multiples of 100s.
So basically I would need the Solver to iterate over the variables by integers multiples of 100 in order to save computational power and increase speed.
I've already made half a step forward when I added a column with the Solver variable and the unit which is the variable multiplied by a scalar, so for instance:
B3 = 2 C3 = B3*100 = 200
In this case, getting the unit number for 100 to 200 requires (if my thinking is correct) less steps as it iterates over less numbers (1 to 2 instead of 100 to 200).
But I imagine that there would be more efficient solutions ,so I should be grateful if you have some ideas as to improve the efficiency.
Thank you for your help and have a great day!
I have a practical issue which appears simple at first but reveals itself being tricky (at least for me) , the problem is the following :
In my Solver Model there are several variables which can range from let's say 1000 to 100000+ and are sold by multiples of 100s.
So basically I would need the Solver to iterate over the variables by integers multiples of 100 in order to save computational power and increase speed.
I've already made half a step forward when I added a column with the Solver variable and the unit which is the variable multiplied by a scalar, so for instance:
B3 = 2 C3 = B3*100 = 200
In this case, getting the unit number for 100 to 200 requires (if my thinking is correct) less steps as it iterates over less numbers (1 to 2 instead of 100 to 200).
But I imagine that there would be more efficient solutions ,so I should be grateful if you have some ideas as to improve the efficiency.
Thank you for your help and have a great day!