AnsweredAssumed Answered

Temperature / Humidity Correction Factor

Question asked by james.arackal on Oct 26, 2017
Latest reply on Aug 24, 2018 by bbregenzer

Hi ,

 

I'm trying to lookup / Calculate an interpolated correction factor in AF from Temperature / Humidity input Table.

 

The table looks as follows in Excel.      

             Input 1  : Ambient Temperature

             Input 2  : Relative Humidity

            Required Result : Interpolated Lookup for Blue font values

 

Can any one guide how to do this ?

 

Ambient Temperature -
  Deg. C
Relative Humidity-Percent 15 20 25 30 35 40 45 51
01.00 1.00 1.01 1.03 1.06 1.10 1.13 1.12
101.00 1.00 1.01 1.03 1.06 1.10 1.14 1.12
201.00 1.00 1.02 1.03 1.06 1.09 1.13 1.12
301.00 1.00 1.02 1.03 1.04 1.07 1.09 1.10
401.00 1.01 1.01 1.02 1.03 1.05 1.06 1.06
501.00 1.00 1.01 1.01 1.02 1.02 1.03 1.03
601.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00
701.00 1.00 0.99 0.99 0.98 0.98 0.97 0.97
801.00 0.99 0.99 0.98 0.97 0.96 0.94 0.95
900.99 0.99 0.98 0.97 0.95 0.94 0.92 0.92
1000.99 0.98 0.97 0.96 0.94 0.91 0.89 0.89

Outcomes