Spreadsheet: 41477d1239952734-asigning-values-above-and-below-median-waterfall
Sheet: Waterfall

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2020 |  |  | 5.5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 70
 |  | 2116 track | 25mm | Gradiant folds with Flaps
 |  | gear drive | 90mm | i | ii | iii |  |  |  |  |  |  |  |  |  | 233.6363636363636 |  |  | 1 | 327.7272727272727
 |  | workable fabric 1500 mm | 1 | (272)  - 50 = | 172 - 9 = | 163 | 233 |  | 272 |  | 172 |  | 163.6363636363636 |  |  | 447.2727272727273 |  |  | 2 | 600.4545454545455
 |  |  | 2 | (272) - 50  = | 222 - 9 = | 213 | 446 |  | 272 |  | 222 |  | 213.6363636363636 |  |  | 710.9090909090909 |  | 3 | 3 | 873.1818181818182
 |  | take middle fold as datum{ | 3 | (272) ± 0 = | 272 - 9 = | 263 | 709 |  | 272 |  | 272 |  | 263.6363636363636 |  |  | 1024.545454545455 |  |  | 4 | 1145.909090909091
 |  |  | 4 | (272) + 50  = | 322 - 9 = | 313 | 1022 |  | 272 |  | 322 |  | 313.6363636363636 |  |  | 1388.181818181818 |  |  | 5 | 1418.636363636364
finished drop of blind |  |  | 5 | (272) + 50 = | 372 - 9 = | 363 | 1385 |  | 272 |  | 372 |  | 363.6363636363636 |  |  | 266.818181818182 |  |  | 1/2 flap | 136.3636363636364
1655 mm |  |  | 1/2 flap | (-136-) | 186 | 182 | 182 |  | 136 |  | 186 |  | 181.8181818181818
 |  | 2004 bottom weight bar | 40mm
 |  |  |  |  |  |  |  |  | 1496 |  | 1546 |  | 1500
 | For example:- 1655[NAME] drop
i | 1655mm - 155mm = 1500[NAME] workable fabric |  |  |  |  |  |  |  |  |  |  |  |  |  | ******* | these calculations are right
 | 25mm gradiant, 5 folds |  |  |  |  |  |  |  |  |  |  |  |  |  |  | what I now need to do is  apply them to [NAME]
 | 1500 |  |  |  |  |  | 1655 | 1795 | 25 | 50
 | 5.5  = | 272 mm rounded down to the nearest mm |  |  |  |  | 155 |  |  |  |  |  |  |  |  | T5 is where the row numbers are formed from
 |  |  |  |  |  |  | 1500 |  |  |  | 8.363636363636363 |  |  |  |  | changing it to 3.5 will show 1,2,3
ii | Adjust to form gradiant by adding or subtracting 2 x gradiant (50 mm)
 | the new total is now 1546 mm but there is only 1500 mm of workable fabric so there is a deficit of 46mm. |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A-G are the workings, the formulas need to work like E,F,G
 | 46
 | 5.5 | spaces = 8.36 mm |  |  |  |  |  |  |  |  |  |  |  |  |  | thanks for your help
 | Therefore adjust each space down by 9mm as in step iii. |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Also having a problem with median when there are even numbers
 | The new Total will be 1497 mm and if you plan form the bottom it only increases the final top space by 3mm. |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ie 6
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | -50
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | -50
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | -25
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | 25
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 | 50
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 | 50
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | median would be 3.5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | I am looking for excel to return 3,4 as median and asign half of the gradiant |  |  |  |  |  |  | ******