Video Tutorial: Adding Data from Excel® to a COMSOL Model

Andrew Griesmer | January 1, 2013

We have been adding a lot of content to our website lately, involving the new LiveLink™ for Excel®. It’s a welcomed addition to the COMSOL family and we can’t stop talking about it. We want to make sure everyone knows about the strengths of LiveLink™ for Excel®, and how it can make your modeling easier, more efficient, and more powerful. Now we have another video for you, and this one demonstrates how to add data from Excel® to a COMSOL model.

In any typical engineering company there will be a team of engineers all working together on different aspects of a project, seeking to achieve a unified end-result. The video below demonstrates how you can streamline this workflow via integration. The LiveLink™ products are made to integrate the work of COMSOL users with their colleagues’, who may not be as familiar with COMSOL. With LiveLink™ for Excel® you can create COMSOL models using the data from Excel® that your colleagues gathered.

The video shows the design of a heat circuit. Here you will see how easy it is to change a constant thermal conductivity to a variable thermal conductivity, dependent on temperature. One of the main themes of the video is temperature uniformity, which is the aim of the model in general, to provide as uniform of a temperature as possible throughout the model. A variable thermal conductivity will produce more accurate results in the form of a minimized ΔT.

The model is a depiction of a possible example of two engineers working together, with one using COMSOL and the other using Excel®. Let’s suppose your colleague has sent you an Excel® file of experimental thermal conductivities at different temperatures. Having already created a model in COMSOL, using a constant thermal conductivity, you now must use a variable thermal conductivity instead. As you can see in the video, importing the data into COMSOL to use the variable thermal conductivity is simple, and you don’t have to recreate the model. Once the changes have been made you can re-compute the model, view the new results, and in turn, relay the new information back to your colleague.

Get more information and material content on LiveLink™ for Excel®.

Excel® is registered trademark of Microsoft or its subsidiaries in the U.S and/or in other countries. LiveLink™ for Excel® is not affiliated with, endorsed by, sponsored by, or supported by Microsoft or any of its subsidiaries in the U.S and/or in other countries.

Article Categories

Article Tags

Share this article
List us on Facebook Folow us on Twitter Join us on Google+ Connect with us on LinkedIn
Loading Comments...