ES_StableIF97 AddIn

Syntax of Accessory Functions

Even though ES_StableIF97 AddIn accessory functions can be embedded into Excel easily by using "ES_StableIF97 AddIn Function" Form, the user had better know about the syntax of the functions in order to edit or manipulate the functions in Excel.

For the list of ES_Stable AddIn accessory functions, please see Accessory Function Summry.

Unit Conversion Functions

Unit conversion functions have a common structure of syntax consisting of the following characters in sequence.   It is helpful to remind ES_StabelIF97 AddIn unit conversion function of "ESStb_CvtP(Press, SourcePUN, OutputPUN)" to understand the following explanation.

"ESStb_" Prefix  

All ES_StableIF97 AddIn functions have "ESStb_" prefix that represent ENGSoft Steam Table.

"Cvt" Prefix 

All unit conversion functions have "Cvt" prefix following "ESStb_" prefix that represent Convert.

Conversion Property Character

The first character(or character string) after the "Cvt" prefix is the conversion property character..   Please refer to the Property Character List below.

The characters explained above consist of the function name.   After the function name, the arguments of the functions are followed in a parenthesis in the following sequence.

The Conversion Property Value Argument

The first argument is the conversion property value.   In case of the function "ESStb_CvtP", the conversion property value is pressure value, of which value will be converted from one pressure unit to another(or same) pressure unit.

Source Unit Number Argument

The argument following the conversion property value argument is the source unit number argument corresponding to the unit of the conversion property value argument described above.    In case of the function "ESStb_CvtP", the source unit number argument shall be one of pressure unit numbers, because the conversion property is pressure.

In the syntax expression of the functions, the abbreviated names for the unit number arguments are used with "Source" prefix., such as SouucePUN for pressure unit number.   For the abbreviation, please refer to the Unit Number Argument Abbreviation List below.

Output Unit Number Argument

The argument following the source unit number argument is the output unit number argument also corresponding to the unit of the conversion property argument.    In case of the function "ESStb_CvtP", the output unit number argument shall be one of pressure unit numbers, because the conversion property is pressure.

In the syntax expression of the functions, the abbreviated names for the unit number arguments are used with "Output" prefix., such as OutputPUN for pressure unit number.   For the abbreviation, please refer to the Unit Number Argument Abbreviation List below.

 

Unit String Functions

Unit string functions have a common structure of syntax consisting of the following characters in sequence.   It is helpful to remind ES_StabelIF97 AddIn unit conversion function of "ESStb_PUnitStr(PUN)" to understand the following explanation.

"ESStb_" Prefix  

All ES_StableIF97 AddIn functions have "ESStb_" prefix that represent ENGSoft Steam Table.

Function Character for Unit String

The first character(or character string) following the "ESStb_" prefix is the Function Character for unit string.   Please refer to the Function Character List below.

"UnitStr" Postfix 

All unit string functions have "UnitStr" postfix following the Function Character for unit string.   The "UnitStr" postfix represents Unit String.

The characters explained above consist of the function name.   After the function name, the argument for unit number is followed in a parenthesis.

Unit Number Argument

The only one argument in the parenthesis is the unit number argument to return unit string.    In case of the function "ESStb_PUnitStr", the unit number argument shall be one of pressure unit numbers.

In the syntax expression of the functions, the abbreviated names for the unit number arguments are used, such as PUN for pressure unit number.   For the abbreviation, please refer to the Unit Number Argument Abbreviation List below.

 

Syntax of "ESStb_CvtP" Function (Sample)

Returns converted pressure value from one pressure unit to another(or same) pressure unit.

Syntax :

ESStb_CvtP(Press, SoucePUN, OutputPUN)

 Arguments :

 Examples :

ESStb_CvtP($F$3,0,$C$5) returns pressure in the pressure unit number(OutputPUN) in cell "C5" converted from the pressure in cell "'F3" in the pressure unit number(SourcePUN) "0".   Pressure unit number "0" represents "kg/cm2 a".   In the function, the cell addresses were given in absolute type with "$" marks in front of cell column characters and row numbers.

ESStb_CvtP(100,0,6) returns 1422.334331 psia pressure converted from 100 kg/cm2 a pressure.   In the function, "100" pressure value is in source unit number "0" that represents "kg/cm2 a" unit.   The output unit number "6" represents "psia" unit.

 

Syntax of "ESStb_PUnitStr" Function (Sample)

Returns pressure unit string corresponding to a pressure unit number.

Syntax :

ESStb_PUnitStr(PUN)

 Arguments :

Examples :

ESStb_PUnitStr($C$5) returns pressure unit string in the pressure unit number(PUN) in cell "C5".   In the function, the cell addresses were given in absolute type with "$" marks in front of cell column characters and row numbers.

ESStb_PUnitStr(6) returns "psi a" string.   In the function the output unit number "6" represents "psi a" unit.

 

Property Character(or Character String) List

P

: Pressure

T

: Temperature

V

:Specific Volume

H

: Enthalpy

S

: Entropy

Visco

: Dynamic Viscosity

ViscoX

: Kinematic Viscosity

Vel

: Velocity

ThCond

: Thermal Conductivity

 

 

MFlow

: Mass Flow Rate

 Area

: Area

 

Unit Number Argument Abbreviation List

PUN

: Pressure Unit Number

TUN

: Temperature Unit Number

VUN

:Specific Volume Unit Number

HUN

: Enthalpy Unit Number

SUN

: Entropy Unit Number

ViscoUN

: Dynamic Viscosity Unit Number

ViscoXUN

: Kinematic Viscosity Unit Number

VelUN

: Velocity Unit Number

ThCondUN

: Thermal Conductivity Unit Number

 

 

MFlowUN

: Mass Flow Rate Unit Number

AreaUN

: Area Unit Number

 


Copyright (c) : ENGSoft Inc., Seoul, Korea, All right reserved since 2008.  / www.engsoft.co.kr