ES_StableIF97 AddIn

How to Use Unit Form

 ES_StableIF97 AddIn Unit Form is to declare default units to be used for ES_StableIF97 functions.    Even though units are declared in Unit Form, the user may edit the units of each function manually in MS Excel sheet.

Another capability of the Unit Form is to embed or locate Unit Legends into MS Excel sheets, which shows the user's unit legend and, if user embeds ES_StableIF97 AddIn functions with the unit legend's cell addresses for unit numbers, function values are automatically changed by changing the unit numbers of the Unit Legend.   ES_StabeIF97 AddIn Function Form has a checkbox option to select Unit Legend's cell addresses for unit number arguments.

The picture below is ES_StableIF97 AddIn Unit Form.

"Unit" Combo Boxes

Water and steam property units can be selected by clicking the "Unit" combo-boxes in the Unit Form shown above.   The units of ES_StableIF97 AddIn functions are identified by integer numbers instead of character string.   The "Unit No." label in the Unit Form above shows the integer number of the unit the user selected in the "Unit" combo-box.

For example, a function of "=ESStb_HbyPT(100, 500, 2, 0,0)" looks up enthalpy in kcal/kg unit at 100 bara pressure and 500 oC temperature.   Syntax of the example function is "=ESStb_HbyPT(Press, Temp, PUN, TUN, HUN)".   Wherein, PUN(Pressure Unit Number) 2 stands for "bar a" unit, TUN(Temperature Unit Number) 0 for "oC" unit, and HUN(Enthalpy Unit Number) 0 for "kcal/kg" unit.

For the list of units and their integer number, please refer to Unit Summary.

"Cell Adrs(Address)" Labels

The "Cell Adrs" labels shows the cell addresses having the unit numbers in the Unit Legend.  If the "Embed or Locate <ESStb> Unit Legend" check box is not checked, these "Cell Adrs" labels are empty.

"Save as Default Units" Command Button

Default units are the units that are automatically invoked whenever the user starts ES_StableIF97 AddIn in MS Excel.   The units on the Unit Form at the moment user click this command button are saved as default units.

"Embed or Locate <ESStb> Unit Legend" Check Box

Unit Legend is a very useful tool of ES_StableIF97 AddIn.    By using Unit Legend, the user can change the units of all ES_StableIF97 AddIn functions in a MS Excel workbook simultaneously and automatically.    

The way to change the units of all functions is to change just the unit integer numbers in the Unit Legend.   The unit strings of Unit Legend change automatically when the unit integer numbers are changed by the user, so that the user can easily recognize the units he changed to.   The unit string cells of Unit Legend includes the Unit String Functions of ES_StableIF97 AddIn.

A Unit Legend embedded into a sheet of a MS Excel workbook influences all the sheets in the MS Excel workbook, because the Unit Legend cell addresses are identified with sheet name.   The user may embed one Unit Legend influencing all sheets in the MS Excel workbook, or embed as many Unit Legends as the user wants in a MS Excel workbook.   Among many Unit Legends in a MS Excel workbook, the user can change Unit Legend for a function by locating the Unit Legend before he embeds a function by using Function Form.   After locating new Unit Legend, the function embedded afterward will have the cell addresses of the new Unit Legend.

For use of Embed or Locate of Unit Legend, please see this (Embed) and this (Locate).  Embed means installation of a new Unit Legend and Locate means selection of an existing Unit Legend.

Use of unit cell addresses instead of unit numbers in ES_StableIF97 AddIn functions can be invoked by clicking "Cell Address Input for Unit Number" check box in ES_StableIF97 AddIn Function Form.

"Anchoring Cell Address of <ESStb> Unit Legend" Text Box and "Cell Select" Command Button

The user can select the anchoring cell of the Unit Legend by clicking "Cell Select" command button and invoking an input box to locate a MS Excel cell as below.    As seen in the picture below, the anchoring cell of Unit Legend is the cell having the string "<ESStb>", i.e. "$B$2" cell in the picture below.

User may type the cell address he wants directly into the "Anchoring Cell Address" text box.

"Sheet Name" Label

The "Sheet Name" is the name of the sheet onto which the Unit Legend will be embedded.   The "Sheet Name" can not be edited by the user, but input automatically only when the anchoring cell is selected by "Cell Select" command button.

"Absolute Cell Address for Unit Cell" Check Box

By clicking the checkbox of "Absolute Cell Address for Unit Cell", the Unit Cell addresses are input in absolute cell address type with dollar sign in front of column character and row number.

It is recommended to use Absolute Cell Addresses for Unit Cell.   It maintains the function's units, even though the cells having the functions are moved..

"Embed" or "Locate" Option Button

If "Embed" option button is selected, a Unit Legend is embedded into the anchoring cell.   

If "Locate" option button is selected and the anchoring cell address shows the cell address having the "<ESStb>" string of an existing Unit Legend, the units of the Unit Form coincide with those of the existing Unit Legend.   If "<ESStb>" string does not exist in the anchoring cell when the user selects "Locate" option button, a message box pops up requesting to select an anchoring cell having "<ESStb> string.

If the user wants to continue embedding of functions with the existing Unit Legend, he has to "Locate" the existing Unit Legend before starting function embedding.

Cautions for Unit Legend Use :

1) Since ES_StableIF97 AddIn gets the unit integer numbers by relative cell positions from "<ESStb>" cell, you must not disperse the Unit Legend cell positions.   Further you must not erase the string "<ESStb>" in the anchoring cell of the Unit Legend.   ES_StableIF97 AddIn recognises the Unit Legend by the string "<ESStb>".

2) When the user starts new Excel sheet or moves to an Excel sheet, the anchoring cell is set at "$A$1" as a default.    If the anchoring cell of existing Unit Legend is "$A$1", "Locate" of the existing Unit Legend does not respond.    If the case, click another cell and then click again the cell "$A$1".

3) If the mouse icon of MS Excel is hair pin shape, i.e. cell edit mode, the ES_StableIF97 AddIn menu as well as toolbar buttons does not respond.    The menu and toolbar buttons respond when MS Excel is in cell selection mode, i.e. thick cross icon, and a cell is selected with thick boundary line.   If a block of cells are selected, the anchoring cell shall be the upper-left corner cell of the block. (This caution applies to MS Excel 2003 or lower version.)

4) If there are so many functions in MS Excel that use Unit Legend cell addresses for unit numbers, it takes time for the Unit Form to be closed after selecting a existing Unit Legend.   That is because selecting of a existing Unit Legend causes recalculation of all those functions.      When selecting the existing Unit Legend in ENGSoft Steam Table MS Excel workbook that has about 4000 ES_StableIF97 functions, it takes around twenty(20) seconds for the Unit Form to be closed in a personal computer having 1.73 GHz processor with 1 GB RAM.


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