Spreadsheet: 57310d1257421800-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
Median values in tan, values up and down move from there. ACTUAL/FOLDS |  |  |  |  |  |  |  |  |  |  |  |  | LENGTH | 1500 | 1 | 130 | -50 | 95 | 85 |  | <<< formula in Q6:different from formulas in Q7 down
Values are millimeters of curtain fabric. |  |  |  |  |  |  |  |  |  |  |  |  | FOLDS | 6.5 | 2 | 265 | -50 | 145 | 135
 |  |  |  | Diff from |  |  |  |  |  |  |  |  | Allowance | 45 | 3 | 450 | -25 | 195 | 185
SAMPLES |  | ACTUAL | Fold | Median | 1453 | -7 |  | (H10+B12) |  |  |  |  | [NAME] | 25 | 4 | 685 | 25 | 245 | 235
LENGTH | 1500 | 1430 | 1 | -50 | 358 | -7 | 351 | 396 |  | median |  |  |  |  | 5 | 970 | 50 | 295 | 285
FOLDS | 3.5 |  | 2 | 0 | 408 | -7 | 401 | 797 | 408 | 408.5714285714286 |  |  |  |  | 6 | 1305 | 50 | 345 | 335
Allowance | 45 |  | 3 | 50 | 458 | -7 | 451 | 1248
[NAME] | 25 |  |  |  |  |  |  |  |  |  |  |  |  |  | 6.5 | 195
 |  |  | 3.5 |  | 229 |  | 227 | 252 | (H14+B13)
 |  |  |  |  |  | -9
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
 |  |  |  |  |  |  |  |  |  |  |  |  | COMPLETED
 |  |  |  |  |  | -10  ?? |  |  |  |  |  |  | 1) Folds 1-?.5 populate by O7
 | 1500 | 1430 | 1 | -50 | 160 | -9 | 151 | 196
 | 5.5 |  | 2 | -50 | 210 | -9 | 201 | 397
 | 45 |  | 3 | 0 | 260 | -9 | 251 | 648 | 260 | 260
 | 25 |  | 4 | 50 | 310 | -9 | 301 | 949
 |  |  | 5 | 50 | 360 | -9 | 351 | 1300
 |  |  | 5.5 |  | 180 |  | 175 | 200
 |  |  |  |  |  | -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
 |  |  |  |  |  | -10  ?
 | 1500 | 1430 | 1 | -50 | 40 | -9 | 31 | 76
 | 7.5 |  | 2 | -50 | 90 | -9 | 81 | 157
 | 45 |  | 3 | -50 | 140 | -9 | 131 | 288
 | 25 |  | 4 | 0 | 190 | -9 | 181 | 469 | 190 | 190.6666666666667
 |  |  | 5 | 50 | 240 | -9 | 231 | 700
 |  |  | 6 | 50 | 290 | -9 | 281 | 981
 |  |  | 7 | 50 | 340 | -9 | 331 | 1312
 |  |  | 7.5 |  | 170 |  | 163 | 188
 |  |  |  |  |  | -10  ??
 | 2500 | 2430 | 1 | -50 | 110 | -9 | 101 | 146
 | 8.5 |  | 2 | -50 | 160 | -9 | 151 | 297
 | 45 |  | 3 | -50 | 210 | -9 | 201 | 498
 | 25 |  | 4 | -25 | 260 | -9 | 251 | 749 | 285 | 285.8823529411765
 |  |  | 5 | 25 | 310 | -9 | 301 | 1050
 |  |  | 6 | 50 | 360 | -9 | 351 | 1401
 |  |  | 7 | 50 | 410 | -9 | 401 | 1802
 |  |  | 8 | 50 | 460 | -9 | 451 | 2253
 |  |  | 8.5 |  | 230 |  | 222 | 247
 |  |  |  |  |  | -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