Hydro-logic data Interpolation en Excell 2007

[mrkhalidiwfm]

I have some excel Hydrologic data. But there are some missing data. I want to find what is the procedure od data interpolatiion. Please help me.

Distance	Elevation
100	2
110	-2
120	-3
130	4
140	5
150	-6
160	7
170	-8
180
190
200
210
220
230	-2
240	1
250	3
260	-2
270	1

<colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody>
</tbody>

Personal Web :

 

[shg]

Cross-posted at Hydro-logic data Interpolation en Excell 2007

 

[Teeroy]

The easiest way is a linear interpolation (but keep in mind the remaining data is far from linear). For a linear interpolation put in B10 (assuming your sample starts at A1) the formula "=B9+(B$15-B$9)/(ROW(B$15)-ROW(B$9))" and fill down.