About the Excel Analysis and Excel Analysis Feature
As part of your Creo Behavioral Modeling activities, you can use an external Excel file to define the analysis that you want to perform on a Creo Parametricmodel. You can then capture the results of the Excel analysis in the Excel Analysis feature.
This functionality is intended for Windows machines. You cannot access Excel analysis on a UNIX workstation. If you retrieve a model with an Excel analysis on a UNIX workstation, the Analysis feature becomes frozen.
When you save an Excel analysis or create an Excel Analysis feature, the system saves the complete path to the .xls file. When you retrieve an Excel analysis or when an Excel Analysis feature is regenerated, the system searches for the .xls file in these locations in the following order:
• The original location of the file from which it was selected for the analysis
• The current working directory
• The directory specified by the configuration option excel_analysis_directory.
You can
create an Excel output file identical to the Excel file used to define the Analysis feature, but evaluated on updated values of the dimensions and parameters used in the Excel Analysis feature definition.