I am looking to add a new constraint to my query. I am not sure how to start setting this up.
I want to add a constraint to set a maximum number of times a value can be used in my solutions. My loop will run for 1 to a maximum of 150 times. This will be set prior to running the solution.
For example, I may want Row 1 ($A$2) to be included a maximum of 6 times, Row 2 ($A$3) 4 times, Row 3($A$4) - 6 times, row 4($A$5) - 2 times, etc up to the may number of rows (Generally less than 200). These can be set anywhere from 0 to the max number of solutions on an individual basis.
I am solving for 6 out of the up to 200 rows at a time and looping for each value, when the row has been used the maximum number of times, it should be removed from consideration for any remaining solves.
My "A" column is the change variable, I have 2 other columns that can be used for a unique identifier for each row. The Name (Column B) and an ID Column (Column C)
I'm not sure how to set up a counter for each row and if I need to set up some type of error notice if there are not enough variables to create all of the solutions based on the other constraints.
Note: I asked a similar question in a previous thread but did not receive any replies. Please let me know if this makes sense, if not, I can try to reword/clarify it.
I want to add a constraint to set a maximum number of times a value can be used in my solutions. My loop will run for 1 to a maximum of 150 times. This will be set prior to running the solution.
For example, I may want Row 1 ($A$2) to be included a maximum of 6 times, Row 2 ($A$3) 4 times, Row 3($A$4) - 6 times, row 4($A$5) - 2 times, etc up to the may number of rows (Generally less than 200). These can be set anywhere from 0 to the max number of solutions on an individual basis.
I am solving for 6 out of the up to 200 rows at a time and looping for each value, when the row has been used the maximum number of times, it should be removed from consideration for any remaining solves.
My "A" column is the change variable, I have 2 other columns that can be used for a unique identifier for each row. The Name (Column B) and an ID Column (Column C)
I'm not sure how to set up a counter for each row and if I need to set up some type of error notice if there are not enough variables to create all of the solutions based on the other constraints.
Note: I asked a similar question in a previous thread but did not receive any replies. Please let me know if this makes sense, if not, I can try to reword/clarify it.
