Drive Creo Simulate through Microsoft Excel

[kdaenerys]

Hello All,
I am trying to link excel ad Creo simulate for automated analysis. The loads and supports can be specified with help of named selections created in the part/assembly features itself. And the static analysis should be run and generate a report with the stress and displacement snapshots.
Is this possible in Creo? If not excel, are there any other ways of achieving the same objective (maybe mapkeys)?

Objective here is to create a simplified interface and complete designer level analysis on numerous concepts without designer going through a training.

 

[kayla_engineer]

See if this helps!

You use the Graphtool window to view and manage different types of graphs. In Creo Simulate, the Graphtool can draw functions or graph various analysis results. After you display your graph, you can interact with it in several ways. To find out the x and y values for any graph point, click on this point and a message box opens showing the values. To work with the graph and manage its appearance, use toolbar buttons or the following menu commands:
• File
◦ Export Excel—This option is available on Windows platforms only. Use it to save the graph data as a Microsoft Excel spreadsheet. When you click this command, Creo Simulate displays the Export To Excel dialog box. Enter a path and a file name on the dialog box. When you click OK, Creo Simulate creates a file with a .xls extension. The file contains a pictorial rendition of the graph as well as a numeric table of graph results at given intervals.
◦ Export Text—Save the graph data as a text file. When you click this command, Creo Simulate displays the Export To Text dialog box. Enter a path and a file name on the dialog box. When you click OK, Creo Simulate creates a file with a .grt extension.
◦ Print—Send your graph to a printer.
◦ Exit—Close the Graphtool window.
• View
◦ Toggle Grid—Display grid lines for your graph or turn them off.
◦ Repaint—Refresh the view of your graph, removing all temporarily displayed information.
◦ Refit—Restore a graph to its original state. Use this command after you zoom in on a particular graph segment to return to an unsegmented state. Creo Simulate automatically redraws the complete graph in the current window.
◦ Zoom In—Zoom in on the graph to get a close-up view. This command is especially useful when your graph contains too many points, 100 or more. Zooming in on certain points helps you to display a specific segment of interest.
• Format
• Graph—Open the Graph Window Options dialog box to manage your graph and its display window.
Return to Graph Function Dialog Box.