Building COMSOL Multiphysics® Models with Excel® and Visual Basic®

Kristoffer Raneflod March 15, 2017

Have you ever thought about customizing or building a model in the COMSOL Multiphysics® software that is based on data from Excel® spreadsheet software? Excel spreadsheets are used to present, collaborate, and store data within many science and engineering applications. Using Microsoft® Visual Basic® for Applications and LiveLink™ for Excel®, we can build and control model settings and parameters within the Excel® spreadsheet software. In this blog post, we illustrate this process and go over a few examples.

Read More

Lars Gregersen March 31, 2014

Modeling in COMSOL Multiphysics involves a lot of tasks, such as choosing the right physics, defining the geometry, and setting up boundary conditions and domain settings. Additionally, material properties have to be defined for the materials included in the model. Such material data may come from the Material Library, but it often has to be obtained experimentally or from literature and imported into COMSOL Multiphysics.

Read More

Phil Kinnane October 3, 2012

Recently, Fanny blogged about spreadsheets and how they are used in engineering. She mentioned that they are great for collating material properties and other experimental results, and for then using these in COMSOL models. The simulation results from these models can in turn be compared to the original data, and help calibrate material properties and optimize the design. With the release of COMSOL Multiphysics 4.3a, COMSOL has now made it much easier to perform these tasks and extend your modeling […]

Read More

Fanny Griesmer September 19, 2012

We’ve noticed that a lot of our customers use spreadsheets, such as Excel®, as part of the modeling process. They use them for storing material property and other data, such as from experiments or other information about workflow associated with their engineering project, and then import this data into COMSOL Multiphysics®. Spreadsheets are also the forum for taking in results from COMSOL software and using this to compare, optimize and verify these material properties. Let’s delve deeper into how spreadsheets […]

Read More