To Create an Excel Analysis
Input values for the Excel analysis can be the following:
Model dimensions
Top-level model parameters
Analysis feature parameters
* 
The cells in an Excel file should not be merged or have any other type of formatting. Each cell should contain only a single piece of data.
The data must be on the first sheet of the Excel file.
1. Click Analysis > Excel Analysis. The Excel Analysis dialog box opens.
2. Click Load File and select a .xls file to open. If you want to create an Excel table on-the-fly, click New File. The system opens the Excel file so that you can specify input and output values for the analysis.
3. Specify input settings by associating a model dimension or parameter with the corresponding cell in the Excel spreadsheet.
To associate a dimension, click Add Dimension, in the model window. Select a dimension that you want to use in the analysis, and click the corresponding cell in the Excel spreadsheet. Accept the selection. Click Add Dimension to continue.
To associate a parameter, click Add Parameter. Select a parameter that you want to use in the analysis from the Parameters dialog box, and click the corresponding cell in the Excel spreadsheet. Accept the selection. Click Add Parameter to continue.
The dimension and parameter selected for the analysis appear in the PTC Creo Parametric to Excel table in the Excel Analysis dialog box. For each dimension or parameter, the table lists its current value and the corresponding cell in the spreadsheet.
To remove a dimension or parameter from the selection, select a row in the PTC Creo Parametric to Excel table and click Remove
4. Specify output settings by selecting what you want to compute from the spreadsheet. Click Output cells in the dialog box, in the spreadsheet click a cell that contains an output value, click Pick and Done Sel.
The selected cells appear in the Output cells field in the dialog box.
5. Click Compute. The system runs the Excel analysis. The results of the computation appear under Results in the Excel Analysis dialog box.
6. To view the results of the analysis in an Information window, click Info.
7. To save the analysis, click Saved Analyses, enter its name, and click .
8. To save this analysis in an analysis feature, click Add Feature and enter a name for the feature. A new analysis feature appears on the Model Tree.
9. Click Close to close the Excel Analysis dialog box.
Was this helpful?