Hi,
I posted this on another Excel Help forum but have not found a working solution yet. I was wondering if anyone here could shed some light on code complexity:
http://www.excelforum.com/showpost.php?p=1822310&postcount=3
Possible code logic might be something like this:
1. Starts at the first row of the sorted input table and stores the flow and length values in temporary variables
2. Proceeds to the next row of the sorted table and stores the flow and length values in a second set of variables.
3. Proceeds to the next row and stores a third set of variables.
4. Performs a calculation on the stored variables to determine if the sum of the flows falls within the necessary range.
5. If so, populate the first row in the output table with the results and delete the three rows from the input table and resort.
6. If not, replace the third input row with the next available input row and recalculate. Continue looping through the subsequent rows until a set can be made. This might require nested loops because if no acceptable third variable makes a matched set, the second and then the first input rows would have to be increase by 1 (while also making sure that row is not already being used in the variable set) each time the loop runs without a successful "hit" meeting the conditions.
7. Repeat until no additional matched sets are found.
How much of a programming job would this be? I'm not knowledgeable enough in VBA to write the code myself...thanks!
I posted this on another Excel Help forum but have not found a working solution yet. I was wondering if anyone here could shed some light on code complexity:
http://www.excelforum.com/showpost.php?p=1822310&postcount=3
Possible code logic might be something like this:
1. Starts at the first row of the sorted input table and stores the flow and length values in temporary variables
2. Proceeds to the next row of the sorted table and stores the flow and length values in a second set of variables.
3. Proceeds to the next row and stores a third set of variables.
4. Performs a calculation on the stored variables to determine if the sum of the flows falls within the necessary range.
5. If so, populate the first row in the output table with the results and delete the three rows from the input table and resort.
6. If not, replace the third input row with the next available input row and recalculate. Continue looping through the subsequent rows until a set can be made. This might require nested loops because if no acceptable third variable makes a matched set, the second and then the first input rows would have to be increase by 1 (while also making sure that row is not already being used in the variable set) each time the loop runs without a successful "hit" meeting the conditions.
7. Repeat until no additional matched sets are found.
How much of a programming job would this be? I'm not knowledgeable enough in VBA to write the code myself...thanks!
