Spreadsheet: 818862d1677085455-need-to-calculate-and-group-lengths-based-on-a-given-maximum-in-the-order-listed-takeoff-run-length-calc-test-mrshorty
Sheet: Sheet1

 |  |  | [NAME]: | 96
 |  |  | WATTAGE | MRL
 |  |  | 7.5
 |  |  | wall number | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 |  | totals |  |  |  |  | INDIVIDUAL RUNS (FEET)
 |  |  | wall lengths | 335 | 108 | 100 | 205 | 48 | 185 | 135 | 175
 |  |  | divide
0 corners |  |  | drivers/wall |  |  |  |  |  |  |  |  |  |  | total drivers
 |  |  | tape lengths |  |  |  |  |  |  |  |  |  |  | total tape (should be same as perimeter length in N7) |  |  | [NAME]
all corners |  |  | perimeter
 |  |  | divide |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | corners lookup table |  |  | not currently being used, but I would not be surprised if, somewhere in development, I would end up wanting this lookup table.
 |  |  | drivers/perimeter |  |  |  |  |  |  |  |  |  |  | total drivers |  |  |  |  | corner | left wall | right wall
 |  |  | tape lengths |  |  |  |  |  |  |  |  |  |  | total tape (should be same as perimeter length in N7) |  |  |  |  | 1 | 1 | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 2 | 3
1 corner solutions |  |  | left wall | 1 | 3 | 4 | 5 | 6 | 7 | 8 |  |  |  |  |  |  |  |  | 3 | 3 | 4
 |  |  | right wall | 2 | 3 | 4 | 5 | 6 | 7 | 8 |  |  |  |  |  |  |  |  | 4 | 4 | 5
 |  |  | wall lengths |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 | 5 | 6
 |  |  | divide |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 | 6 | 7
 |  |  | drivers/wall |  |  |  |  |  |  |  |  |  |  | total drivers |  |  |  |  | 7 | 7 | 8
 |  |  | tape lengths |  |  |  |  |  |  |  |  |  |  | total tape (should be same as perimeter length in N7)
 |  |  | left wall | 1 | 2 | 4 | 5 | 6 | 7 | 8
 |  |  | right wall | 1 | 3 | 4 | 5 | 6 | 7 | 8
 |  |  | wall lengths
 |  |  | divide
 |  |  | drivers/wall |  |  |  |  |  |  |  |  |  |  | total drivers
 |  |  | tape lengths |  |  |  |  |  |  |  |  |  |  | total tape (should be same as perimeter length in N7)
 |  |  | left wall | 1 | 2 | 3 | 5 | 6 | 7 | 8
 |  |  | right wall | 1 | 2 | 4 | 5 | 6 | 7 | 8
 |  |  | wall lengths
 |  |  | divide
 |  |  | drivers/wall |  |  |  |  |  |  |  |  |  |  | total drivers
 |  |  | tape lengths |  |  |  |  |  |  |  |  |  |  | total tape (should be same as perimeter length in N7)
 |  |  | and so on until all 1 corner combinations are calculated
2 corner solutions
2 adjacent corners |  |  | left wall | 1 | 4 | 5 | 6 | 7 | 8 | 0
 |  |  | right wall | 3 | 4 | 5 | 6 | 7 | 8 | 0
 |  |  | wall lengths
 |  |  | divide
 |  |  | drivers/wall |  |  |  |  |  |  |  |  |  |  | total drivers
 |  |  | tape lengths |  |  |  |  |  |  |  |  |  |  | total tape (should be same as perimeter length in N7)
 |  |  | left wall | 1 | 2 | 5 | 6 | 7 | 8 | 0
 |  |  | right wall | 1 | 4 | 5 | 6 | 7 | 8 | 0
 |  |  | wall lengths
 |  |  | divide
 |  |  | drivers/wall |  |  |  |  |  |  |  |  |  |  | total drivers
 |  |  | tape lengths |  |  |  |  |  |  |  |  |  |  | total tape (should be same as perimeter length in N7)
 |  |  | left wall | 1 | 2 | 3 | 6 | 7 | 8 | 0
 |  |  | right wall | 1 | 2 | 5 | 6 | 7 | 8 | 0
 |  |  | wall lengths
 |  |  | divide
 |  |  | drivers/wall |  |  |  |  |  |  |  |  |  |  | total drivers
 |  |  | tape lengths |  |  |  |  |  |  |  |  |  |  | total tape (should be same as perimeter length in N7)
 |  |  | and so on until all 2 adjacent corner combinations are calculated
2 nonadjacent corners |  |  | left wall | 1 | 3 | 5 | 6 | 7 | 8 | 0
 |  |  | right wall | 2 | 4 | 5 | 6 | 7 | 8 | 0
 |  |  | wall lengths
 |  |  | divide
 |  |  | drivers/wall |  |  |  |  |  |  |  |  |  |  | total drivers
 |  |  | tape lengths |  |  |  |  |  |  |  |  |  |  | total tape (should be same as perimeter length in N7)
 |  |  | and so on until all 2 nonadjacent corner combinations are calculated
3 corner solutions
3 adjacent corners
2 adjacent corners + 1 non adjacent
3 nonadjacent corners
4 corner solutions
and so on until all possible combinations are calculated
At this point, I decided I understood the overall process, but I don’t like the “block” way I have arranged the calculations.
I would scratch everything at this point and start over, arranging the calculations so it is easier to copy/paste (meaning that each block becomes a single row).
Then you need to figure out how to “score” each combination based on your desired optimization criteria (number of drivers used, number of corners taped around, other criteria) so you can then program in your final decision algorithm that chooses which configuration to use in the final project.