samtheman88
New Member
- Joined
- Feb 6, 2013
- Messages
- 7
Hi,
I have the following table with one set of relationships.....
<colgroup><col><col><col><col><col></colgroup><tbody>
</tbody>
Then, I have this table with another set of data...
<colgroup><col span="5"><col></colgroup><tbody>
</tbody>
To determine the outflow in the second table, I need to interpolate for outflow (O) using the first table and my first value of 50 for 2S/Δt + O in the second table. Any ideas how to do simple linear interpolation in excel???? Someone mentioned vlookup, but I can't seem to get it to work.
I have the following table with one set of relationships.....
Stage (H) | Outflow (O) | Storage (S) | 2S/Δt | 2S/Δt + O |
feet | cfs | acre-ft | cfs | cfs |
0 | 0.00 | 0 | 0 | 0.00 |
0.1 | 24.44 | 0.4 | 9.68 | 34.12 |
0.2 | 34.57 | 0.8 | 19.36 | 53.93 |
0.3 | 42.34 | 1.2 | 29.04 | 71.38 |
0.4 | 48.89 | 1.6 | 38.72 | 87.61 |
0.5 | 54.66 | 2 | 48.4 | 103.06 |
0.6 | 59.88 | 2.4 | 58.08 | 117.96 |
0.7 | 64.67 | 2.8 | 67.76 | 132.43 |
0.8 | 69.14 | 3.2 | 77.44 | 146.58 |
0.9 | 73.33 | 3.6 | 87.12 | 160.45 |
1 | 77.30 | 4 | 96.8 | 174.10 |
<colgroup><col><col><col><col><col></colgroup><tbody>
</tbody>
Then, I have this table with another set of data...
<colgroup><col span="3"><col><col></colgroup><tbody> </tbody> |
<colgroup><col span="5"><col></colgroup><tbody>
</tbody>
To determine the outflow in the second table, I need to interpolate for outflow (O) using the first table and my first value of 50 for 2S/Δt + O in the second table. Any ideas how to do simple linear interpolation in excel???? Someone mentioned vlookup, but I can't seem to get it to work.