Updating Data in a Worksheet
Now that you have a workbook containing model definitions and data evaluation linked to a COMSOL model, you can easily modify and recompute the model from the workbook, while keeping the evaluated results up to date.
Follow the steps below to update the results in Sheet1 and Sheet2.
1
Make sure that Sheet 1 is active, then on the ribbon tab, Numerical Results group, click Update to update all the numerical results in the worksheet.
The point evaluation now includes results for different values of the busbar width.
2
To update the image in Sheet 1, delete the existing image first, then insert it again by clicking Insert Screenshot.
You can select Plot Group > Plot Data to display the solution for a different value of the busbar width.
3
To update the total heat source interpolation only, switch to Sheet2, and select the cell that contains the Interpolation comment, cell D3 if you did not change the worksheet format.
4
In the Numerical Results group click Update .
Note that the new values correspond to the busbar width set to 5 cm. You need to manually update the table header to reflect this.
5
You can continue to import data for other value of wbb, the easiest way is to copy the cell that contains the interpolation comment (D4) and paste it at the desired cell location, say I4.
6
Click the Interpolation button and select from the Parameter menu list the second parameter value (wbb = 0.1) and click OK. A COMSOL dialog appears, click OK to confirm replacing the contents of the destination cells.
7
Finally repeat the two previous steps to insert the results for the third width parameter value (wbb = 0.15) starting at cell N4.