sandramac
asked on
Performing Calculations for Relative Humidity and Heat Index
Hello, needing some help here.
Cell Sheet5 B13 and C13 has values that represent temperature and dewpoint in Fahrenheit. I need to convert each value into Celsius, the formala is 5/9*(Temp-32). Then for the first value I need to use this formula 6.11*10.0**(7.5*Tc/(237.7+ Tc)), where Tc is the value. Then for the second value I need 6.11*10.0**(7.5*Tdc/(237.7 +Tdc)), where Tdc is the second value. Finally I need to divide the number from the second equation by the number in the first equation and times it by 100.
Finally, I need to computer =16.923+(Temp*1.85212*(10^ -1))+(5.37 941*RH)-(( Temp*RH)*1 .00254*(10 ^-1))+((Te mp^2)*9.41 695*(10^-3 ))+((RH^2) *7.28898*( 10^-3))+(( Temp^2)*RH *3.45372*( 10^-4))-(T emp*(RH^2) *8.14971*( 10^-4))+(( RH^2)*(Tem p^2)*1.021 02*(10^-5) )-((Temp^3 )*3.8646*( 10^-5))+(( RH^3)*2.91 583*(10^-5 ))+(RH*(Te mp^3)*1.42 721*(10^-6 ))+((RH^3) *Temp*1.97 483*(10^-7 ))-((RH^2) *(Temp^3)* 2.18429*(1 0^-8))+((R H^3)*(Temp ^2)*8.4329 6*(10^-10) )-((RH^3)* (Temp^3)*4 .81975*(10 ^-11)). Temperature is the original Fahrenheit value and RH is what we calculated above.
Trying to shoot for some type of function as I will need to use this to calculate multiple cells. Thanks in advance for you help.
Cell Sheet5 B13 and C13 has values that represent temperature and dewpoint in Fahrenheit. I need to convert each value into Celsius, the formala is 5/9*(Temp-32). Then for the first value I need to use this formula 6.11*10.0**(7.5*Tc/(237.7+
Finally, I need to computer =16.923+(Temp*1.85212*(10^
Trying to shoot for some type of function as I will need to use this to calculate multiple cells. Thanks in advance for you help.
ASKER
David, thanks for the help. Still need some assistance. In your example, you have temperature and relative humidity as the given numbers. However, temperature and dew point are the given values, not the relative humidity. So I need to convert both temp and RH to Celsius, then use the formula 6.11*10.0**(7.5*T/(237.7+T )) for both values, T would the respective number that we got, when we converted the temp. Then divide the number from the second equation by the number in the first equation and times it by 100. Once we get that number, that is the RH,
then plug the values into this formula 16.923+(Temp*1.85212*(10^- 1))+(5.379 41*RH)-((T emp*RH)*1. 00254*(10^ -1))+((Tem p^2)*9.416 95*(10^-3) )+((RH^2)* 7.28898*(1 0^-3))+((T emp^2)*RH* 3.45372*(1 0^-4))-(Te mp*(RH^2)* 8.14971*(1 0^-4))+((R H^2)*(Temp ^2)*1.0210 2*(10^-5)) -((Temp^3) *3.8646*(1 0^-5))+((R H^3)*2.915 83*(10^-5) )+(RH*(Tem p^3)*1.427 21*(10^-6) )+((RH^3)* Temp*1.974 83*(10^-7) )-((RH^2)* (Temp^3)*2 .18429*(10 ^-8))+((RH ^3)*(Temp^ 2)*8.43296 *(10^-10)) -((RH^3)*( Temp^3)*4. 81975*(10^ -11)). Temperature is the original Fahrenheit value and RH is what we calculated above.
then plug the values into this formula 16.923+(Temp*1.85212*(10^-
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks, your functions helped me out tremendously
ee29019572.xlsx