Engineering Function
Steam Water - IF97 Steam Table
=ee.STEAMxxx()
ex) Get Steam Entalpy with (Pressure, Temperature)
=ee.STEAMH_PT()
Input as 2 bara pressure and 150 deg.C Temperature
=ee.STEAMH_PT(2, 150)
=2769.09 kJ/kg Enthalpy of Steam
Humid Air - ASHRAE
=ee.HUMIDAIR_xxx()
ex) Get Denity with (Dry Temperature, Relative Humid Ratio and Ambient Pressure)
=ee.HUMIDAIR_RHO_TDRY_RH_P()
Input as 150 deg.C Temperature, 60% Relative Humid Ratio, and Ambient Pressure, bara
=ee.HUMIDAIR_RHO_TDRY_RH_P(35, 0.6, 1.013)
=1.13082 kg/m3 density of Air
Compressible Gas
GERG2008 - Gas Property
=ee.GASxxx()
ex) Get Denity with (Dry Temperature, Relative Humid Ratio and Ambient Pressure)
=ee.GASRHO_PT()
Input as 2 bara, 35 deg.C Temperature with FluidName
=ee.GASRHO_PT(2, 35, Methane[0.6]&Ethane[0.4])
=ee.GASRHO_PT(2, 35, B3_excel Range)
=1.70111 kg/m3 density of Gas
ISO 6976 - Natural Gas Heating Value
=ee.GASxxx()
ex) Get LHV Lower Heating Value_kJ/kg (option with temperature)
=ee.GASLHVMASS()
Input with FluidName
=ee.GASLHVMASS(Methane[0.6]&Ethane[0.4])
=48630.14 kJ/kg as LHV of Gas
Friction Factor of pipe
=ee.FRICTIONFACTOR()
ex) Get friction factor with (dia_mm, roughness_mm, reynolds)
Input as DN200, 202.74 mm pipe inner diameter, 0.046 carbon pipe absolute roughness, reynolds
=ee.FRICTIONFACTOR(202.74, 0.046, 213850)
=0.0171 friction factor
Interpolation as Linear, Cubic
=ee.INTERPOLATION1D()
ex) Get interpolated value with (X value, X-Table, Y-Table, “Linear”=Option Default)
-
linear method
=ee.INTERPOLATION1D(1.5, {1;2;3}, {10;20;50})
=ee.INTERPOLATION1D(1.5, B1:B3_excel Range, C1:C3_excel Range)
=15get result -
cubic method
=ee.INTERPOLATION1D(1.5, {1;2;3}, {10;20;50}, "cubic")
=ee.INTERPOLATION1D(1.5, B1:B3_excel Range, C1:C3_excel Range, "cubic")
=10get result