COMSOL 6.4 - Evaluating the Results

With LiveLink™ for Excel® you can evaluate and insert simulation results into a worksheet. The tools needed for this are grouped under on the tab in the Excel user interface. To perform the evaluations at least one solution dataset needs to be present in the model.

To evaluate data found in the Derived Value nodes defined in the model, select a cell in the worksheet, then click the (

)button and select the Derived Values node to import the data from. The evaluated data is inserted to the right and down from the selected cell. A link to the model, represented by a comment inserted in the selected cell, assures that the evaluation can be updated with changes to the model solution.

To evaluate expressions on specified geometry vertices select a cell in the worksheet and click the (

) button. In the window, select the solution dataset, one or more points, and specify the expression to evaluate. Click to insert the evaluated data to the right and down from the selected cell. A link to the model, represented by a comment inserted in the selected cell, assures that the point evaluation can be updated with changes to the model solution.

To evaluate expressions at arbitrary location select a cell in the worksheet, click

to open the window.

Select the solution dataset, if a parametric solution dataset specify the parameter value. Enter the expression to evaluate, and the cell range that contains the point coordinates for the evaluation. The coordinates need to be formatted so there is one point per row, with the coordinates in different columns. The number of evaluation points correspond to the number of rows.

The evaluated data is inserted to the right and down from the selected cell. A link to the model, represented by a comment inserted in the selected cell, assures that the point evaluation can be updated with changes to the model solution.

To evaluate expressions along particle trajectories, first select a cell in the worksheet then, under , click the (

) button.

In the window, select a valid particle tracing solution dataset. Then specify the time for data evaluation in the list. Under the section select what to extract to the worksheet: the , the , and an , which you can enter in the text field. Finally you can define the number of particles for which you want to perform the evaluation. The amount of particles in the particle dataset is available in the field, under the list.

The evaluated data is inserted to the right and down from the selected cell. A link to the model, represented by a comment inserted in the selected cell, ensures that the point evaluation can be updated with changes to the model solution.

To evaluate expressions along ray trajectories, first select a cell in the worksheet then, under , click the (

) button.

In the dialog, select a valid ray tracing solution dataset. Then specify the time for data evaluation in the list. Under , you select what to extract in the worksheet: the position, the velocity, and a specified expression. Finally, you can define the number of rays for which you want to perform the evaluation. The amount of rays in the Ray dataset is available in the field under the list.

The evaluated data is inserted to the right and down from the selected cell. A link to the model, represented by a comment inserted in the selected cell, ensures that the point evaluation can be updated with changes to the model solution.

To extract data from tables defined in the model, select a cell in the worksheet, click the (

) button, and select the table to insert into the worksheet. The evaluated data is inserted to the right and down from the selected cell. A link to the model, represented by a comment inserted in the selected cell, ensures that the point evaluation can be updated with changes to the model solution.

You can modify the settings for an existing data evaluation by following these steps:

To update the existing evaluations after recomputing a solution, see Updating Data in Cells Linked to the Model.