I found the following paper and am attempting to put Saturated Pressure and Saturated Temperature into excel. I got Saturated Pressure to work, but can't get saturated Temperature to work.
Saturated Pressure (working)
=(B18+273.15)/647.096 [cacluates Tr from C]
=EXP(9.56756 + 5.39806*LN(B19) - 6.16183*(LN(B19))^2 + 1.49572*(LN(B19))^4 + 0.433*B19^5 )
Saturated Temperature (not working)
=B15/22064 [calculates Pr from kPa]
=EXP((0.00937817 + 0.000498951*B16 + 0.0000111049*B16^2 + 0.000000334995*B16^3 + 0.0000000344102*B16^4)^(-0.4))
I thought maybe it was outputting in K, but that did not solve it.
Either I didn't correctly translate the equation, or the equation is wrong. Thoughts? Thanks!