match and interpolation help.

[badmi]

Hi all,

I am facing issue for match and interpolation of values as below.
I need exact value and intermediate values if i select temperature and material group. [TABLE="width: 1067"]
<colgroup><col><col><col><col><col><col span="9"></colgroup><tbody>[TR]
[TD] [TABLE="width: 1067"]
<colgroup><col><col><col><col><col><col span="9"></colgroup><tbody>[TR]
[TD] [/TD]
[TD="colspan: 13"] Material Group No.:[/TD]
[/TR]
[TR]
[TD] Temp[/TD]
[TD] [/TD]
[TD] [/TD]
[TD="colspan: 5"] [/TD]
[TD="colspan: 6"] [/TD]
[/TR]
[TR]
[TD] deg C[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1.1[/TD]
[TD="align: right"]2.1[/TD]
[TD="align: right"]2.2[/TD]
[TD="align: right"]2.3[/TD]
[TD="align: right"]2.4[/TD]
[TD="align: right"]2.8[/TD]
[TD="align: right"]3.1[/TD]
[TD="align: right"]3.2[/TD]
[TD="align: right"]3.4[/TD]
[TD="align: right"]3.5[/TD]
[TD="align: right"]3.7[/TD]
[TD="align: right"]3.8[/TD]
[/TR]
[TR]
[TD] -29[/TD]
[TD="align: right"]0.89[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0.83[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0.83[/TD]
[TD="align: right"]0.5[/TD]
[TD="align: right"]0.83[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD="align: right"]38[/TD]
[TD="align: right"]0.89[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0.83[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0.83[/TD]
[TD="align: right"]0.5[/TD]
[TD="align: right"]0.83[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD="align: right"]94[/TD]
[TD="align: right"]0.83[/TD]
[TD="align: right"]0.94[/TD]
[TD="align: right"]0.83[/TD]
[TD="align: right"]0.86[/TD]
[TD="align: right"]0.7[/TD]
[TD="align: right"]0.98[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0.77[/TD]
[TD="align: right"]0.5[/TD]
[TD="align: right"]0.74[/TD]
[TD="align: right"]0.93[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD="align: right"]149[/TD]
[TD="align: right"]0.78[/TD]
[TD="align: right"]0.91[/TD]
[TD="align: right"]0.74[/TD]
[TD="align: right"]0.78[/TD]
[TD="align: right"]0.63[/TD]
[TD="align: right"]0.83[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0.73[/TD]
[TD="align: right"]0.5[/TD]
[TD="align: right"]0.69[/TD]
[TD="align: right"]0.89[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD="align: right"]205[/TD]
[TD="align: right"]0.73[/TD]
[TD="align: right"]0.88[/TD]
[TD="align: right"]0.65[/TD]
[TD="align: right"]0.72[/TD]
[TD="align: right"]0.58[/TD]
[TD="align: right"]0.69[/TD]
[TD="align: right"]0.98[/TD]
[TD="align: right"]0.67[/TD]
[TD="align: right"]0.5[/TD]
[TD="align: right"]0.67[/TD]
[TD="align: right"]0.85[/TD]
[TD="align: right"]0.98[/TD]
[TD="align: right"]0.98[/TD]
[/TR]
[TR]
[TD="align: right"]260[/TD]
[TD="align: right"]0.69[/TD]
[TD="align: right"]0.83[/TD]
[TD="align: right"]0.6[/TD]
[TD="align: right"]0.67[/TD]
[TD="align: right"]0.53[/TD]
[TD="align: right"]0.64[/TD]
[TD="align: right"]0.92[/TD]
[TD="align: right"]0.65[/TD]
[TD="align: right"]0.5[/TD]
[TD="align: right"]0.66[/TD]
[TD="align: right"]0.83[/TD]
[TD="align: right"]0.92[/TD]
[TD="align: right"]0.92[/TD]
[/TR]
[TR]
[TD="align: right"]316[/TD]
[TD="align: right"]0.65[/TD]
[TD="align: right"]0.76[/TD]
[TD="align: right"]0.58[/TD]
[TD="align: right"]0.63[/TD]
[TD="align: right"]0.5[/TD]
[TD="align: right"]0.6[/TD]
[TD="align: right"]0.84[/TD]
[TD="align: right"]0.63[/TD]
[TD="align: right"]0.5[/TD]
[TD="align: right"]0.66[/TD]
[TD="align: right"]0.8[/TD]
[TD="align: right"]0.84[/TD]
[TD="align: right"]0.84[/TD]
[/TR]
[TR]
[TD="align: right"]343[/TD]
[TD="align: right"]0.63[/TD]
[TD="align: right"]0.74[/TD]
[TD="align: right"]0.57[/TD]
[TD="align: right"]0.62[/TD]
[TD="align: right"]0.49[/TD]
[TD="align: right"]0.6[/TD]
[TD="align: right"]0.82[/TD]
[TD="align: right"]0.63[/TD]
[TD="align: right"]0.5[/TD]
[TD="align: right"]0.66[/TD]
[TD="align: right"]0.78[/TD]
[TD="align: right"]0.82[/TD]
[TD="align: right"]0.82[/TD]
[/TR]
[TR]
[TD="align: right"]371[/TD]
[TD]---[/TD]
[TD="align: right"]0.74[/TD]
[TD="align: right"]0.56[/TD]
[TD="align: right"]0.6[/TD]
[TD="align: right"]0.48[/TD]
[TD="align: right"]0.58[/TD]
[TD="align: right"]0.79[/TD]
[TD="align: right"]0.62[/TD]
[TD]--[/TD]
[TD="align: right"]0.66[/TD]
[TD="align: right"]0.77[/TD]
[TD="align: right"]0.79[/TD]
[TD="align: right"]0.79[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="colspan: 14"][/TD]
[/TR]
</tbody>[/TABLE]

below fetching exact value is done in different sheet and above are in different sheet.
[TABLE="width: 324"]
<colgroup><col><col><col><col></colgroup><tbody>[TR]
[TD][/TD]
[TD="colspan: 2"]Temperature[/TD]
[TD]-29[/TD]
[/TR]
[TR]
[TD="colspan: 3"] Material Group No.[/TD]
[TD]1[/TD]
[/TR]
</tbody>[/TABLE]

or i need to add one more row for intermediate value in next sheet.

 

[Gerald Higgins]

Hi, it's not clear to me what you want exactly.

You refer to interpolation and intermediate values, but in the example you refer to Temperature -29 and Material Group No. 1, which I guess should give a result of 0.89, correct ?
No interpolation required here.

Can you give us an example where interpolation is actually required, and what the results should be exactly ?

 

[badmi]

Sir,
Thanks for your interest.
for example: Material group-1
for temp 250 and 350. how do i fetch values?.

 

[Fluff]

What values would you expect to get with those two temperatures?