Modifying the Excel template
Although IBM® SPSS® Modeler is supplied with a default Excel template to use with the Interactive List viewer, you may want to change the settings or add your own. For example, the costs in the template may be incorrect for your organization and need amending.
Note: If you do modify an existing template, or create you own, remember to save the file with an Excel 2003 .xlt suffix.
To modify the default template with new cost and revenue details and update the Interactive List viewer with the new figures:
- In the Interactive List viewer, choose Organize Model Measures from the Tools menu.
- In the Organize Model Measures dialog box, click Connect to Excel™.
- Select the template_profit.xlt workbook, and click Open to launch the spreadsheet.
- Select the Settings worksheet.
- Edit the Fixed costs to be 3,250.00, and the
Revenue per respondent to be 150.00.
Figure 1. Modified values on Excel Settings worksheet 
- Save the modified template with a unique, relevant filename. Ensure it has
an Excel 2003 .xlt extension.
Figure 2. Saving modified Excel template 
- Use the Windows taskbar (or press Alt+Tab) to navigate back to the
Interactive List viewer.
In the Choose Inputs for Custom Measures dialog box, select the measures you want to display and click OK.
- In the Organize Model Measures dialog box, click OK to update the Interactive List viewer.
Obviously, this example has only shown one simple way of modifying the Excel template; you can make further changes that pull data from, and pass data to, the Interactive List viewer, or work within Excel to produce other output, such as graphs.
