ES_StableIF97 AddIn

How to Use Function Form

ES_StableIF97 AddIn Function Form provides the user with a tool for embed ES_StableIF97 AddIn functions into MS Excel cells without remembering the syntax of the functions.   Blow is the Form.

"Function" Combo Box

All functions available are shown in the "Function" combo box list.  The user can select a function from the list he wants to embed into a MS Excel cell.    From the list, the user can see the syntax of function.   

The Form above shows the function ESStb_HbyPT, which returns enthalpy value by pressure and temperature given.   The first two arguments in the parenthesis, Press and Temp, stands for the pressure and temperature values given.   The next three arguments, PUN, TUN and HUN, stands for Pressure Unit Number value, Temperature Unit Number value and Enthalpy Unit Number value respectively, that will be selected by the user in a separate form "ES_StableIF97 AddIn Unit Form.".   

"Equation" Text Box

The "Equation" text box shows the text to be actually embedded into the MS Excel cell.   The user may edit the text manually.   

For the pressure and temperature arguments, the user may type in the numbers he wants into "Cell Address" text boxes, e.g. 100 and 500 instead of cell addresses, and click "Embed" button.   Then, the function in the MS Excel cell works independently without connection to other MS Excel cells.

"Cell Select" Command Button

The "Cell Select" command button is to input a cell address by clicking a cell on a MS Excel sheet, like built-in functions of MS Excel.   If user clicks this "Cell Select" command button, the Function Form disappears and the following input box for cell address appears.

The picture above shows selection of the "Output" enthalpy cell because the "Output" text box was selected before clicking this command button.  Selection of a cell is done by clicking the text box, and then back color of the text box selected is changed to green.   The picture above shows that the cell "$D$2" has been selected.

As user clicks "OK" button, the input box disappears and the Function Form appears again with the new cell address of "$D$2".  It is seen also that the boundary line of the "Output" cell selected is changed to double solid line.

The following picture shows that the Arg1 Pressure text box is selected by clicking the text box.   Now  user is ready for selecting a cell on MS Excel sheet for Arg1 Pressure cell address input.

The following picture shows that the cell "$D$3" has been selected for Arg1 Pressure.

Clicking "OK" button in the input box pops up the Function Form again with Arg1 Pressure cell address "$D$3" input as below.    It is seen that the cell value of "100" has been input automatically.

The picture below is after Arg2 Temperature cell selection in the same way as in the Arg1 Pressure above.   It is seen that the enthalpy value of 3375 kJ/kg is shown in the Output Cell Value label as a result of the function calculation.

By Clicking the "Embed" command button of the Function Form, the function is embedded automatically into the Output cell of MS Excel as shown below.

 

Text Boxes under "Cell Select" Command Button

The text boxes under the "Cell Select" command button are for input of :cell addresses or cell values.   Cell address input is done by using Cell Select command button described above.   

Cell values can be input into these text boxes directly by user.   The picture below shows direct input of cell values by user and embedding of the function into the cell address of "$D$5".   When typing the cell values into these text boxes, the same values in Cell Value labels are shown automatically.

 

"Cell Value" Label

"Cell Value" labels shows the values of each item automatically. The values of Cell Value labels can not be edited.

 Argument Cells in Other Sheet

The argument cells may be located in other sheets.   In the picture shown below, (Arg1) and (Arg2) cells are located in "Example" sheet.   The picture below shows nozzle function of choking mass flow rate per unit nozzle throat area, i.e. ESStb_NzlWperAcbyPT.

The MS Excel sheet having Output cell is reference sheet.   Therefore, the address of Output cell can not have sheet name in any case.

 

"Absolute Cell Address for Argument Cells" Check Box

By clicking the checkbox of "Absolute Cell Address for Argument Cells", the argument cell addresses are input in absolute cell address type with dollar sign in front of column character and row number.    All pictures above shows the Function Form with this check box checked.

"Cell Address Input for Unit Number" Check Box

By clicking the checkbox of "Cell Address Input for Unit Number", the unit numbers in the function are replaced with the cell addresses of Unit Legend instead of integer numbers.   The cell addresses of Unit Legend are assigned by a separate form titled "ES_StableIF97 AddIn Unit Form".    Type of the cell addresses of unit numbers is either of absolute or normal, which will be selected in the Unit Form.

This Cell Address Input for Unit Number function is very useful for manipulating function's units by Unit Legend.   Since the cell address for Unit Legend is identified by sheet name inclusive, all sheets in a MS Excel workbook can be controlled by a unit legend.

 In the picture below, the cell address for PUN is seen as 'Unit'!$D$3, which means that the pressure unit number is located in cell "$D$3" of "Unit" sheet.   If user changes the pressure unit number in the cell "$D$3" of "Unit" sheet, the function value is changed to the new unit value automatically.

The function shown in the picture is nozzle function for sub-critical condition, i.e. ESStb_NzlWperA2byPT.   Choking pressure is 54.8401 bara as shown in the example above.   Since nozzle outlet pressure is 70 bara higher than choking pressure of 54.8401 bara, the nozzle is sub-critical state and the mass flow rate per unit nozzle throat area, WperA, is 39404257 kg/hr/m2 less than choking mass flow rate of 41727500 kg/hr/m2.

The Unit Legend in sheet "Unit" is as shown below.

 

"Embed Function Value instead of Equation" Check Box

If this check box is checked, the function value is embedded instead of function equation, as its name implies.   It is seen in the picture below that in the cell "$D$10" the nozzle mass flow rate value of 39404256.9512472 is embedded instead of the function equation.


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