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. [TABLE="width: 128"]
<colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody>[TR]
[TD="width: 64"]Distance[/TD]
[TD="width: 64"]Elevation[/TD]
[/TR]
[TR]
[TD="align: right"]100[/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD="align: right"]110[/TD]
[TD="align: right"]-2[/TD]
[/TR]
[TR]
[TD="align: right"]120[/TD]
[TD="align: right"]-3[/TD]
[/TR]
[TR]
[TD="align: right"]130[/TD]
[TD="align: right"]4[/TD]
[/TR]
[TR]
[TD="align: right"]140[/TD]
[TD="align: right"]5[/TD]
[/TR]
[TR]
[TD="align: right"]150[/TD]
[TD="align: right"]-6[/TD]
[/TR]
[TR]
[TD="align: right"]160[/TD]
[TD="align: right"]7[/TD]
[/TR]
[TR]
[TD="align: right"]170[/TD]
[TD="align: right"]-8[/TD]
[/TR]
[TR]
[TD="align: right"]180[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]190[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]200[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]210[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]220[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]230[/TD]
[TD="align: right"]-2[/TD]
[/TR]
[TR]
[TD="align: right"]240[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD="align: right"]250[/TD]
[TD="align: right"]3[/TD]
[/TR]
[TR]
[TD="align: right"]260[/TD]
[TD="align: right"]-2[/TD]
[/TR]
[TR]
[TD="align: right"]270[/TD]
[TD="align: right"]1[/TD]
[/TR]
</tbody>[/TABLE]























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.