Microsoft Excel File Format for Decision Tables

The Microsoft excel file needs to fomatted correctly before importing into the Decision Manager as a decision table.

The following figure shows the sample Microsoft excel file that can be imported as a decision table.

The Excel file format has the following characteristics:

Decision Table Excel File Format
Heading Notes
Version Version of this table, as stored in the RMS project.
Declarations Section
Path The project path to the entities used as arguments in the VRF
Alias The entity aliases
Property Not used in this release.
Decision Table Section
ID The row (rule) ID
Condition
Action
Custom Condition
Custom Action One column for each condition and action, as needed. Each regular Condition and Action column heading is followed by the name of the property whose values are used in the cells of the column.
Description Each rule can have an optional description, seen in the Properties view.
Priority Rule priority from 1 to 10, seen in the Properties view. Default is 5.
Exception Table Section
  Same as Decision Table section. Values appear only if an exception table is defined. See Exception Tables .