Multiline extended calculator and notepad. Variables, expressiona, comments
ECalcPad home Download ECalcPad free DataOdyssey Projects home DataOdyssey Express - Data Mining made easy EasySql4Fox - VFP adapt to SQL(MySQL,ORACLE) quickly

Variables, expressions, comments

Type a unique name for a calculation variable in the "Variable" cell. Only correct mathematical expressions are allowed in "Expression" cell.

To create a new row with a variable and expression, you can:

маркированный список Click Button_Add_End.gif (109 bytes) button. An empty row with a new generated unique variable will be added to the end of the calculation.
маркированный список Click Button_Insert.gif (109 bytes) button. An empty row with a new generated unique variable will be added after the current row.

In your expressions, you can use the following:

маркированный список Digits;
маркированный список Mathematical operators + - / *
маркированный список Mathematical functions (sin, cos, ...) . Click Button_Func.gif (107 bytes) button to call the functions list.
маркированный список Financial functions (Payment, FV, PV (mortgage calculation)) . Click Button_Func.gif (107 bytes) button  to call the functions list.
маркированный список Names of variables pre-defined in a calculation to refer a "Result" cell of previous lines.
маркированный список Names of variables pre-defined in a calculation with indexes (1-5) in a brackets to refer a "Value1 ... 5" cells of previous lines.
маркированный список VALUE1,VALUE2,VALUE3,VALUE4,VALUE5 to refer a "Value..." cells in a same line.

If an expression has not a = sign then the result of a correct expression will be shown in "Result" cell. But you can assign a values to any "Value" cell before, after or instead of a main expression. This assignments and a main expression must be separated with ; . For example:

VALUE1=(A+B)*5;VALUE2=VALUE1+100;VALUE3=VALUE2-VALUE1;VALUE3/2

Create a calorie calculation, add a dish and select ECalcPad style for more samples of value assignments. But also you can fill a "Value..." cells manually.

If the entered expression has a syntax error you will receive an error message. Rows with errors will be marked red and underlined.

ECalcPad_VarExpr.gif (19935 bytes)


Maximum length of "Expression" cell is 200 characters. Set maximum size of the calculator window and "Expression" cell size will be increased. You can change size and order of any column in calculation. Drag a column and drop it before another one to change its order. Drag the right border of a column to change its size.

You can write any text into "Comments" cell of any row.

ECalcPad

Vallmind