Menu | <<<< | >>>> | [Create *.lst File with Comparative Charts, Pivot Tables, …List…]

Clicking the [Create *.lst File with Comparative Charts, Pivot Tables, Filtered List for selected Variables and Solutions] button on the Solution Manager control screen brings up this menu. You select variables to be included by clicking on Sheets, Variables, Categories, and Time Periods. There is a limit of 8000 variables per list so for a large model you must create lists made of sub-sets of variables that you want to examine. First, verify or change the name of the pivot table/list being created (1). A default name is created from 2 selected solutions but you can change it manually. The list of existing *.list files is shown. If an existing name is used, the existing file will be over-written by the new *.lst file. Clicking the [2.ßUpdate Selections] button selects variables and then clicking the [3. Create Pivot Table/List Workbook] button creates the pivot table/filtered list workbook. When selecting solutions to include in the list, the first solution listed becomes the basis of comparison for difference and percentage difference tables. A prompt before this menu appears allows you to specify the solution to be used as a basis of comparison.