|
The Exec programming language allows you to build ENCORE! applications that can
be run by other people. It allows you to present an intuitive user interface and automate certain modeling tasks.
It is especially well equipped to import data from outside of ENCORE! (i.e. ASCII or CSV format), consolidating
and manipulating data within ENCORE!, and generating reports with a single mouse click.
Below is a partial list of Exec commands, organized by function. Download the Exec Help File for a complete listing.
Controlling Program Flow
- While / EndWhile
- Repeat / Until
- IF/ THEN / ELSE
- Call
- Jump
- Exit
- Procedure / EndProc Matrix Management
- CreateMatrix / Close Matrix
- LoadMatrix
- OpenMatrix
- SaveMatrix
- IsMatrixModified
- Import (CSV, or WK1 files)
Logic
- Calculate
- CompileLogic
- DrillDown
- QuickLogic
Matrix Rows and Columns
- InsertCols / DeleteCols
- InsertRows / DeleteRows
- GetColName
- GetRowName
- GetFlexName
- GetRowNum
Matrix Variables
- GetMatrixVar
- SetMatrixVar
Row Class Information
Data Access
Matrix Math and Analysis
- AddMatrix (and Sub, Div, Mult, Pct)
- AddRows (and Sub, Div, Mult, Pct)
- RankRows
- ColRegress, RowRegress
Consolidating and Extracting
- Consolidate
- Extract (by row number or by row name) Matrix
Display, Data Entry, and Reporting
- InputForm
- CloseInputForm
- Report
User Interaction
- CheckBoxDialog
- EditBoxDialog
- FileDialog
- ListBoxDialog
- RadioDialog
- InfoBox
- Menu
- Popup
- CreateTextWindow
- DestroyTestWindow
- WriteLineTextWindow
String Manipulation
- Chr
- CSVWord
- Format
- LastPos
- Left / Right
- Length
- Lower / Upper
- Mid
- Num
- Pos
- Str
- Word
Arithmetic
- +, -, *, /
- Abs
- Int
- Min
- Max
- Round
Text file and INI file input / output
- CloseFile
- EOF
- Read
- ReadINI
- ReadLine
- Write
- WriteINI
- WriteLine
Miscellaneous
- StartTimer
- ElapsedTime
- Date
- IsNumeric
- DIR
|