whatIf? Wiki

With this method, the template will contain zeros for all data in the variable.

1. Right click on variable to import
2. Select Create Variable Instance > Microsoft Excel
3. Save Excel spreadsheet to use as a template for future imports

With this method, the template will contain existing values from the selected scenario. The user can then overwrite particular values as necessary.

1. Ensure that one and only one scenario is selected
2. Right click on variable to import
3. Select See Variable > Microsoft Excel
4. Save Excel spreadsheet to use as a template for future imports

1. Open Excel template and enter data for variable
2. Save Excel spreadsheet as tab-delimited text file with the variable name
3. Close the spreadsheet
4. Create an import view that uses that text file (see General View Writing for information on how to create and run views)