D
Dale
Can someone help me. I would like to use excel to predict or forecast a
number. I would like to plug in the following scenarios:
1st 2nd 1st 2nd 1st 2nd
$ $ RT RT VST VST Increase % Increase
0.51 1.21 1.35 1.95 1.15 1.4 0.7 137%
0.66 1.5 1.85 2 1.25 1.33 0.84 127%
4.16 5.7 1.8 1.99 1.22 1.33 1.54 37%
4.52 11.12 1.31 2 1.23 1.47 6.6 146%
6.27 7.75 1.33 1.8 1.22 1.4 1.48 24%
6.74 14.5 0.96 2 1.13 1.54 7.76 115%
9.15 15.25 1.02 1.77 1.26 1.54 6.1 67%
11.86 23.64 1.67 2 1.41 1.55 11.78 99%
13.1 29.95 0.63 1.91 1.15 1.53 16.85 129%
14.76 25.9 1.12 1.84 1.27 1.49 11.14 75%
16.44 21.02 1.27 1.67 1.42 1.26 4.58 28%
22.74 23.7 1.17 1.23 1.23 1.25 0.96 4%
23.09 31.61 1.81 1.88 1.47 1.52 8.52 37%
27.41 30.61 1.83 1.83 1.27 1.26 3.2 12%
42.4 45.3 1.2 1.41 1.19 1.28 2.9 7%
50.49 52.9 1 1.08 1.22 1.24 2.41 5%
And then based on all the previous scenarios then with only the 1st
price, 1st RT, 1st VST I would like to forecast the 2nd RT, the 2nd VST,
the increase and % increase.
***** Posted via: http://www.ozgrid.com
Excel Templates, Training & Add-ins.
Free Excel Forum http://www.ozgrid.com/forum *****
number. I would like to plug in the following scenarios:
1st 2nd 1st 2nd 1st 2nd
$ $ RT RT VST VST Increase % Increase
0.51 1.21 1.35 1.95 1.15 1.4 0.7 137%
0.66 1.5 1.85 2 1.25 1.33 0.84 127%
4.16 5.7 1.8 1.99 1.22 1.33 1.54 37%
4.52 11.12 1.31 2 1.23 1.47 6.6 146%
6.27 7.75 1.33 1.8 1.22 1.4 1.48 24%
6.74 14.5 0.96 2 1.13 1.54 7.76 115%
9.15 15.25 1.02 1.77 1.26 1.54 6.1 67%
11.86 23.64 1.67 2 1.41 1.55 11.78 99%
13.1 29.95 0.63 1.91 1.15 1.53 16.85 129%
14.76 25.9 1.12 1.84 1.27 1.49 11.14 75%
16.44 21.02 1.27 1.67 1.42 1.26 4.58 28%
22.74 23.7 1.17 1.23 1.23 1.25 0.96 4%
23.09 31.61 1.81 1.88 1.47 1.52 8.52 37%
27.41 30.61 1.83 1.83 1.27 1.26 3.2 12%
42.4 45.3 1.2 1.41 1.19 1.28 2.9 7%
50.49 52.9 1 1.08 1.22 1.24 2.41 5%
And then based on all the previous scenarios then with only the 1st
price, 1st RT, 1st VST I would like to forecast the 2nd RT, the 2nd VST,
the increase and % increase.
***** Posted via: http://www.ozgrid.com
Excel Templates, Training & Add-ins.
Free Excel Forum http://www.ozgrid.com/forum *****