Spreadsheet: 40200d1238516103-need-formula-or-macro-to-calculate-mutliple-scenarios-template
Sheet: Sheet1

 | data | data | data | data | data | 9 | -2.9 | b | data | -14.5 | -14.5 |  |  | -35 | 1.5 | 5
 | data | data | data | data | data | -23 | 0.3 | a | data | 19.5 | 5 |  |  | -34 | 1.4
 | data | data | data | data | data | -7 | -1.3 | a | data | 5 | 10 |  |  | -33 | 1.3
 | data | data | data | data | data | -3 | -1.7 | b | data | -8.5 | 1.5 |  |  | -32 | 1.2
 | data | data | data | data | data | -3 | -1.7 | b | data | -22.95 | -21.45 |  |  | -31 | 1.1
 | data | data | data | data | data | 0 | -2 | c | data | 0 | -21.45 |  |  | -30 | 1
 | data | data | data | data | data | -35 | 1.5 | b | data | -24.3 | -45.75 |  |  | -29 | 0.899999999999999
 | data | data | data | data | data | -2 | -1.8 | b | data | -109.35 | -155.1 |  |  | -28 | 0.799999999999999
 | data | data | data | data | data | -19 | -0.1 | a | data | 170.1 | 15 |  |  | -27 | 0.699999999999999
 |  |  |  |  |  |  |  |  |  |  |  |  |  | -26 | 0.599999999999999
 |  |  |  |  |  |  |  |  |  |  |  |  |  | -25 | 0.5
 |  |  |  |  |  |  |  |  |  |  |  |  |  | -24 | 0.4
 |  |  |  |  |  |  |  |  |  |  |  |  |  | -23 | 0.3
 |  |  |  |  |  |  |  |  |  |  |  |  |  | -22 | 0.2
 |  |  |  |  |  |  |  |  |  |  |  |  |  | -21 | 0.1
 |  |  |  |  |  |  |  |  |  |  |  |  |  | -20 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | -19 | -0.1
 |  |  |  |  |  |  |  |  |  |  |  |  |  | -18 | -0.2
 |  |  |  |  |  |  |  |  |  |  |  |  |  | -17 | -0.3
 |  |  |  |  |  |  |  |  |  |  |  |  |  | -16 | -0.4
 |  |  |  |  |  |  |  |  |  |  |  |  |  | -15 | -0.5
 |  |  |  |  |  |  |  |  |  |  |  |  |  | -14 | -0.6
 |  |  |  |  |  |  |  |  |  |  |  |  |  | -13 | -0.7
 |  |  |  |  |  |  |  |  |  |  |  |  |  | -12 | -0.8
 |  |  |  |  |  |  |  |  |  |  |  |  |  | -11 | -0.9
 |  |  |  |  |  |  |  |  |  |  |  |  |  | -10 | -1
 |  |  |  |  |  |  |  |  |  |  |  |  |  | -9 | -1.1
 |  |  |  |  |  |  |  |  |  |  |  |  |  | -8 | -1.2
 |  |  |  |  |  |  |  |  |  |  |  |  |  | -7 | -1.3
 |  |  |  |  |  |  |  |  |  |  |  |  |  | -6 | -1.4
 |  |  |  |  |  |  |  |  |  |  |  |  |  | -5 | -1.5
 |  |  |  |  |  |  |  |  |  |  |  |  |  | -4 | -1.6
 |  |  |  |  |  |  |  |  |  |  |  |  |  | -3 | -1.7
 |  |  |  |  |  |  |  |  |  |  |  |  |  | -2 | -1.8
 |  |  |  |  |  |  |  |  |  |  |  |  |  | -1 | -1.9
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | -2
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | -2.1
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | -2.2
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | -2.3
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | -2.4
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 | -2.5
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 | -2.6
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 7 | -2.7
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 | -2.8
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 9 | -2.9
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 10 | -3
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 11 | -3.1
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 12 | -3.2
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 13 | -3.3
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 14 | -3.4
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 15 | -3.5
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 16 | -3.6
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 17 | -3.7
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 18 | -3.8
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 19 | -3.9
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 20 | -4
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 21 | -4.1
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 22 | -4.2
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 23 | -4.3
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 24 | -4.4
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 25 | -4.5
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 26 | -4.6
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 27 | -4.7
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 28 | -4.8
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 29 | -4.9
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 30 | -5
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 31 | -5.1
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 32 | -5.2
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 33 | -5.3
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 34 | -5.4
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 35 | -5.5