To Create an Excel Analysis Feature
You can create an Excel Analysis feature by using the results of an Excel analysis.
1. Click Analysis > Analysis. The ANALYSIS dialog box opens.
2. Under Name, type a name for the analysis or accept the default name.
3. Under Type, click Excel Analysis.
4. Under RegenRequest, specify the regeneration option by clicking one of the following options:
Always—Always regenerate the analysis feature during the model regeneration.
Read Only—Exclude the analysis feature from the model regeneration.
Only Design Study—Regenerate the analysis feature only when it is used by a design study.
5. Click Next. The Excel Analysis dialog box opens.
6. To retrieve a previously saved analysis, click Saved Analyses and select the name of the .xls file.
To load an existing Excel file, click Load File and select an .xls file. To create a new Excel file, click New File.
7. After loading or creating the Excel file, define the analysis as required.
* 
If you created a new file, you must save and reload it into the current analysis feature.
8. Click Compute to run the analysis.
9. Click Close to return to the ANALYSIS dialog box.
The Result params window opens. All cells selected for the output settings appear in the Result params table. The table lists the parameter status, parameter name, and description.
10. To create a parameter, select it from the Result params table and click YES under Create.
11. Under Param name, accept the default name or type a name for the parameter.
The default parameter name XL_<rownumber>_<columnletter> reflects the position of the corresponding output cell in the Excel spreadsheet.
12. Click Next to create output files.
The Result datums window opens. The table lists the create file status, datum name, and description.
13. To create a output file, select it from the Result datums table and click YES under Create.
14. To change the output filename, enter the name of the file in Datum name box.
15. Click to create the Excel Analysis feature or click to exit without saving any changes.