Spreadsheet: 268657d1380725643-how-to-find-next-highest-value-from-a-table-of-a-calculated-value-according-to-dn-table
Sheet: Sheet4

DN | Sch5 | Sch10 | Sch20 | Sch30 | STD | Sch40 | XS | Sch60 | Sch80 | Sch100 | Sch120 | Sch140 | Sch160 | XSS | Max.t
10 |  | 1.65 |  | 1.85 |  | 2.31 |  |  | 3.2 |  |  |  |  |  | 3.2
15 | 1.65 | 2.109999999999999 | 0 | 2.41 | 0 | 2.77 | 0 | 0 | 3.73 | 0 | 0 | 0 | 4.78 | 7.47 | 7.47 |  | Calculated Value | DN
20 | 1.65 | 2.109999999999999 |  | 2.41 |  | 2.869999999999999 |  |  | 3.91 |  |  |  | 5.56 | 7.82 | 7.82 |  | 3.3 | 100
25 | 1.65 | 2.77 |  | 2.9 |  | 3.379999999999999 |  |  | 4.550000000000001 |  |  |  | 6.35 | 9.09 | 9.09
32 | 1.649999999999999 | 2.77 |  | 2.969999999999999 |  | 3.559999999999999 |  |  | 4.850000000000001 |  |  |  | 6.35 | 9.7 | 9.7 |  | Next Higher value
40 | 1.649999999999999 | 2.77 |  | 3.18 |  | 3.68 |  |  | 5.08 |  |  |  | 7.140000000000001 | 10.15 | 10.15
50 | 1.649999999999999 | 2.77 |  | 3.18 |  | 3.91 |  |  | 5.539999999999999 |  |  |  | 8.740000000000002 | 11.07 | 11.07
65 | 2.109999999999999 | 3.049999999999997 |  | 4.780000000000001 |  | 5.16 |  |  | 7.009999999999998 |  |  |  | 9.530000000000001 | 14.02 | 14.02
80 | 2.109999999999999 | 3.049999999999997 |  | 4.780000000000001 |  | 5.490000000000002 |  |  | 7.619999999999997 |  |  |  | 11.13 | 15.24 | 15.24
90 | 2.109999999999999 | 3.049999999999997 |  | 4.780000000000001 |  | 5.740000000000002 |  |  | 8.079999999999998 |  |  |  |  |  | 8.079999999999998
100 | 2.109999999999999 | 3.049999999999997 |  | 4.780000000000001 |  | 6.020000000000003 |  |  | 8.560000000000002 |  | 11.13 |  | 13.49 | 17.12 | 17.12
125 | 2.769999999999996 | 3.400000000000006 |  |  |  | 6.549999999999997 |  |  | 9.530000000000001 |  | 12.7 |  | 15.88 | 19.05 | 19.05
150 | 2.769999999999996 | 3.400000000000006 |  |  |  | 7.109999999999999 |  |  | 10.97 |  | 14.27 |  | 18.26000000000001 | 21.95 | 21.95
200 | 2.769999999999996 | 3.760000000000005 | 6.349999999999994 | 7.040000000000006 |  | 8.179999999999993 |  | 10.31 | 12.7 | 15.09 | 18.26000000000001 | 20.62 | 23.01000000000001 | 22.23 | 23.01000000000001
250 | 3.400000000000006 | 4.189999999999998 | 6.349999999999994 | 7.800000000000011 |  | 9.269999999999996 |  | 12.7 | 15.09 | 18.26000000000001 | 21.44 | 25.40000000000001 | 28.58 |  | 28.58
300 | 3.960000000000008 | 4.569999999999993 | 6.349999999999994 | 8.379999999999995 | 9.530000000000001 | 10.31 | 12.69999999999999 | 14.27000000000001 | 17.47999999999999 | 21.44 | 25.40000000000001 | 28.58000000000001 | 33.31999999999999 |  | 33.31999999999999
350 | 3.960000000000008 | 6.349999999999994 | 7.919999999999987 |  | 9.530000000000001 | 11.13 | 12.69999999999999 | 15.09 | 19.05000000000001 | 23.82999999999998 | 27.78999999999999 | 31.75 | 35.71000000000001 |  | 35.71000000000001
400 | 4.189999999999998 | 6.349999999999994 | 7.919999999999987 |  | 9.530000000000001 | 12.69999999999999 |  | 16.66 | 21.44 | 26.19 | 30.96000000000001 | 36.53 | 40.49000000000001 |  | 40.49000000000001
450 | 4.189999999999998 | 6.349999999999994 | 7.919999999999987 | 11.13 | 9.530000000000001 | 14.27000000000001 | 12.69999999999999 | 19.05000000000001 | 23.82999999999998 | 29.36000000000001 | 34.93000000000001 | 39.67000000000002 | 45.24000000000001 |  | 45.24000000000001
500 | 7.780000000000001 | 6.349999999999994 | 9.530000000000001 |  | 9.530000000000001 | 15.09 | 12.69999999999999 | 20.62 | 26.19 | 32.53999999999999 | 38.09999999999999 | 44.44999999999999 | 50.00999999999999 |  | 50.00999999999999
550 | 4.779999999999973 | 6.350000000000023 | 9.529999999999973 |  | 9.529999999999973 |  | 12.69999999999999 | 22.23000000000002 | 28.57999999999998 | 34.93000000000001 | 41.28 | 47.63 | 53.97999999999999 |  | 53.97999999999999
600 | 5.54000000000002 | 6.350000000000023 | 9.529999999999973 | 14.26999999999998 | 9.529999999999973 | 17.48000000000002 | 12.69999999999999 | 24.61000000000001 | 30.95999999999998 | 38.88999999999999 | 46.01999999999998 | 52.37 | 59.53999999999999 |  | 59.53999999999999
650 |  | 7.920000000000016 | 12.69999999999999 |  | 9.529999999999973 |  | 12.69999999999999 |  |  |  |  |  |  |  | 12.69999999999999
700 |  | 7.920000000000016 | 12.69999999999999 | 15.88 | 9.529999999999973 |  | 12.69999999999999 |  |  |  |  |  |  |  | 15.88
750 | 6.350000000000023 | 7.920000000000016 | 12.69999999999999 | 15.88 | 9.529999999999973 |  | 12.69999999999999 |  |  |  |  |  |  |  | 15.88
800 |  | 7.920000000000016 | 12.69999999999999 | 15.88 | 9.529999999999973 | 17.48000000000002 | 12.69999999999999 |  |  |  |  |  |  |  | 17.48000000000002
850 |  | 7.920000000000016 | 12.69999999999999 | 15.88 | 9.529999999999973 | 17.48000000000002 | 12.69999999999999 |  |  |  |  |  |  |  | 17.48000000000002
900 |  | 7.920000000000016 | 12.69999999999999 | 15.88 | 9.529999999999973 | 19.05000000000001 | 12.69999999999999 |  |  |  |  |  |  |  | 19.05000000000001
950 |  |  |  |  | 9.529999999999973 |  | 12.69999999999999 |  |  |  |  |  |  |  | 12.69999999999999
1000 |  |  |  |  | 9.529999999999973 |  | 12.69999999999999 |  |  |  |  |  |  |  | 12.69999999999999
1050 |  |  |  |  | 9.529999999999973 |  | 12.70000000000005 |  |  |  |  |  |  |  | 12.70000000000005
1100 |  |  |  |  | 9.529999999999973 |  | 12.70000000000005 |  |  |  |  |  |  |  | 12.70000000000005
1150 |  |  |  |  | 9.529999999999973 |  | 12.70000000000005 |  |  |  |  |  |  |  | 12.70000000000005
1200 |  |  |  |  | 9.529999999999973 |  | 12.70000000000005 |  |  |  |  |  |  |  | 12.70000000000005