Spreadsheet: 57368d1257461017-table-that-calculates-curtain-folds-based-on-4-specific-criteria-book21
Sheet: Sheet1

Need to create ONE chart that expands and contracts itself to show each of the sample values, shown. |  |  |  |  |  |  |  |  |  |  |  |  | This is the goal.  Changes in column O
There are many other values, so hardcoding won't work. [NAME] of permutations. |  |  |  |  |  |  |  |  |  |  |  |  | cause P and Q to calculate values with no helpers
Changing the values in column N should cause the appropriate matching numbers to be calculated, not looked up. |  |  |  |  |  |  |  |  |  |  |  |  | to match samples on the left
If these values can be made to appear, all the other should work, too.
Helper columns in blue, won't be there in final form, just the yellow cells. |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | RESULT |  |  |  | 1500-3.5 | 1500-4.5 | 1500-5.5 | 1500-6.5 | 1500-7.5 | 2500-8.5 | 2500-9.5
Median values in tan, values up and down move from there. ACTUAL/FOLDS |  |  |  |  |  |  |  |  |  |  |  |  | LENGTH | 1500 | 1 | 279 | -50 | 242 | 234 | 396 | 279 | 195 | 130 | 75 | 145 | 90
Values are millimeters of curtain fabric. |  |  |  |  |  |  |  |  |  |  |  |  | FOLDS | 4.5 | 2 | 563 | -25 | 292 | 284 | 797 | 563 | 395 | 265 | 155 | 295 | 185
 |  |  |  | Diff from |  |  |  |  |  |  |  |  | Allowance | 45 | 3 | 897 | 25 | 342 | 334 | 1248 | 897 | 645 | 450 | 285 | 495 | 330
SAMPLES |  | ACTUAL | Fold | Median | 1453 | -7 |  | (H10+B12) |  |  |  |  | [NAME] | 25 | 4 | 1281 | 50 | 392 | 384 |  | 1281 | 945 | 685 | 465 | 745 | 525
LENGTH | 1500 | 1430 | 1 | -50 | 358 | -7 | 351 | 396 |  | median |  |  |  |  |  |  |  |  |  | 252 |  | 1295 | 970 | 695 | 1045 | 770
FOLDS | 3.5 |  | 2 | 0 | 408 | -7 | 401 | 797 | 408 | 408.5714285714286 |  |  |  |  | 4.5 | 219 |  |  |  |  | 219 |  | 1305 | 975 | 1395 | 1065
Allowance | 45 |  | 3 | 50 | 458 | -7 | 451 | 1248 |  |  |  |  |  |  |  |  |  |  |  |  |  | 205 |  | 1305 | 1795 | 1410
[NAME] | 25 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 195 |  | 2245 | 1805
 |  |  | 3.5 |  | 229 |  | 227 | 252 | 1500 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 195 |  | 2250
 |  |  |  |  |  |  | 227 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 255
 |  |  |  |  |  | -9 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 250
LENGTH | 1500 | 1430 | 1 | -50 | 243 | -9 | 234 | 279
FOLDS | 4.5 |  | 2 | -25 | 293 | -9 | 284 | 563 | 318 | 317.7777777777778
Allowance | 45 |  | 3 | 25 | 343 | -9 | 334 | 897
[NAME] | 25 |  | 4 | 50 | 393 | -9 | 384 | 1281
 |  |  | 4.5 |  | 197 |  | 194 | 219 | 1500
 |  |  |  |  |  |  |  |  |  |  |  |  | COMPLETED
 |  |  |  |  |  | -10 |  |  |  |  |  |  | 1) Folds 1-?.5 populate by O7
 | 1500 | 1430 | 1 | -50 | 160 | -10 | 150 | 195
 | 5.5 |  | 2 | -50 | 210 | -10 | 200 | 395
 | 45 |  | 3 | 0 | 260 | -10 | 250 | 645 | 260 | 260
 | 25 |  | 4 | 50 | 310 | -10 | 300 | 945
 |  |  | 5 | 50 | 360 | -10 | 350 | 1295
 |  |  | 5.5 |  | 180 |  | 180 | 205 | 1500
 |  |  |  |  |  | -10
 | 1500 | 1430 | 1 | -50 | 95 | -10 | 85 | 130
 | 6.5 |  | 2 | -50 | 145 | -10 | 135 | 265
 | 45 |  | 3 | -25 | 195 | -10 | 185 | 450 | 220 | 220
 | 25 |  | 4 | 25 | 245 | -10 | 235 | 685
 |  |  | 5 | 50 | 295 | -10 | 285 | 970
 |  |  | 6 | 50 | 345 | -10 | 335 | 1305
 |  |  | 6.5 |  | 172 |  | 170 | 195 | 1500
 |  |  |  |  |  | -10  ?
 | 1500 | 1430 | 1 | -50 | 40 | -10 | 30 | 75
 | 7.5 |  | 2 | -50 | 90 | -10 | 80 | 155
 | 45 |  | 3 | -50 | 140 | -10 | 130 | 285
 | 25 |  | 4 | 0 | 190 | -10 | 180 | 465 | 190 | 190.6666666666667
 |  |  | 5 | 50 | 240 | -10 | 230 | 695
 |  |  | 6 | 50 | 290 | -10 | 280 | 975
 |  |  | 7 | 50 | 340 | -10 | 330 | 1305
 |  |  | 7.5 |  | 170 |  | 170 | 195 | 1500
 |  |  |  |  |  | -10
 | 2500 | 2430 | 1 | -50 | 110 | -10 | 100 | 145
 | 8.5 |  | 2 | -50 | 160 | -10 | 150 | 295
 | 45 |  | 3 | -50 | 210 | -10 | 200 | 495
 | 25 |  | 4 | -25 | 260 | -10 | 250 | 745 | 285 | 285.8823529411765
 |  |  | 5 | 25 | 310 | -10 | 300 | 1045
 |  |  | 6 | 50 | 360 | -10 | 350 | 1395
 |  |  | 7 | 50 | 410 | -10 | 400 | 1795
 |  |  | 8 | 50 | 460 | -10 | 450 | 2245
 |  |  | 8.5 |  | 230 |  | 230 | 255 | 2500
 |  |  |  |  |  | -10
 | 2500 | 2430 | 1 | -50 | 55 | -10 | 45 | 90
 | 9.5 |  | 2 | -50 | 105 | -10 | 95 | 185
 | 45 |  | 3 | -50 | 155 | -10 | 145 | 330
 | 25 |  | 4 | -50 | 205 | -10 | 195 | 525
 |  |  | 5 | 0 | 255 | -10 | 245 | 770 | 255 | 255.7894736842105
 |  |  | 6 | 50 | 305 | -10 | 295 | 1065
 |  |  | 7 | 50 | 355 | -10 | 345 | 1410
 |  |  | 8 | 50 | 405 | -10 | 395 | 1805
 |  |  | 9 | 50 | 455 | -10 | 445 | 2250
 |  |  | 9.5 |  | 227 |  | 225 | 250 | 2500