MS Excel Integration Setup

The integration between Decision List Viewer and Microsoft Excel is accomplished through the use of a preconfigured Excel spreadsheet template. The template consists of three worksheets:

Model Measures. Displays the imported Decision List Viewer measures, the custom Excel measures, and the calculation totals (defined on the Settings worksheet).

Settings. Provides the variables to generate calculations based on the imported Decision List Viewer measures and the custom Excel measures.

Configuration. Provides options for specifying which measures are imported from Decision List Viewer and for defining the custom Excel measures.

WARNING: The structure of the Configuration worksheet is rigidly defined. Do NOT edit any cells in the green shaded area.

• Metrics From Model. Indicates which Decision List Viewer metrics are used in the calculations.
• Metrics To Model. Indicates which Excel-generated metric(s) will be returned to Decision List Viewer. The Excel-generated metrics display as new measure columns in Decision List Viewer.

Note: Excel metrics do not remain with the model when you generate a new model; the metrics are valid only during the active session.