0362248690

Integrating Spreadsheets with COMSOL Multiphysics

The simulation capabilities of Excel® can be augmented by seamlessly integrating them with COMSOL Multiphysics®. Whether you are an engineer with years of Excel data describing your process and looking to utilise it in a COMSOL Multiphysics simulation, or you are a scientist wanting to utilise simulation to find and optimise the value of a material property, LiveLink™ for Excel® will provide you with the flexibility you need. It is only fully available in the Windows® operating system although it provides import and export capabilities when using the macOS and Linux® operating systems.

LiveLink™ for Excel® allows you to take advantage of the capabilities and structured simplicity offered by Excel to extend your COMSOL Multiphysics® modelling capacity. Parameters and variables that are defined and modelled in COMSOL Multiphysics are instantly available in Microsoft® Excel® and automatically synchronised with your physics model. Moreover, LiveLink™ adds the capability to create a COMSOL® material library from data stored in a worksheet and brings it into COMSOL Multiphysics, while also enabling support for loading Excel files for parameter and variable lists in the COMSOL Desktop®.

The COMSOL Multiphysics tab within Excel gives you access to a number of the features and functionalities that are available in COMSOL Multiphysics – such as opening and saving models, importing and re-defining parameters, variables, and functions, running mesh and solver routines, extracting and treating data, and presenting your results.

 
Working with Excel® in the COMSOL Multiphysics® Environment

LiveLink™ for Excel® provides tools to import data directly into COMSOL Multiphysics for further use in the modelling workflow. This can include importing several of the model definitions like parameters, variables and functions, from a worksheet. Furthermore, with LiveLink™ for Excel® you can create a material library within Excel and configure the export in such a way that COMSOL Multiphysics recognises the material properties and stores them appropriately in your Material Library. You can export results to Excel, where you can compare, optimise, and calibrate these material properties.

Microsoft, Excel, and Windows are either registered trademarks or trademarks of Microsoft Corporation in the United States and/or other countries. All other trademarks are the property of their respective owners. For a list of such trademark owners, see http://www.comsol.com/tm. COMSOL AB and its subsidiaries and products are not affiliated with, endorsed by, sponsored by, or supported by these trademark owners.

 

Working with COMSOL Multiphysics® Models in the Excel® Environment

LiveLink™ for Excel® lets you perform and control your COMSOL Multiphysics modelling from an Excel environment. When LiveLink™ for Excel® is installed, a COMSOL Multiphysics tab is immediately made available in the Excel ribbon.

With the provided COMSOL-specific icons in the Excel ribbon, you can control most of the steps in your modelling process. This includes opening and saving models; importing and re-defining parameters, variables, and functions; running mesh and solver routines; extracting and treating data; and presenting your results. Parameters are automatically synchronised with cells in the Excel worksheet, and they can be changed on-the-fly and re-synchronised, and the model can be solved again. Moreover, you can augment your COMSOL modelling with some of the tools and functionality provided by Excel. For instance, columns of data in the Excel worksheet can be used to define the point coordinates for evaluations to be performed based on the model solution. After the evaluation, extracted results will populate related Excel columns, and you can achieve curve-fitting of the extracted data by using tools from Excel.

When you open a COMSOL Multiphysics® model from Excel®, a COMSOL Multiphysics® server is started, where the model file is loaded. A graphics window allows you to track the progress of the actual modelling being controlled from Excel®, as it displays the model geometry, mesh, and result plots.

You do not need to have COMSOL Multiphysics® open in the background to be able to manage your modelling from Excel®. Additionally, LiveLink™ for Excel® provides seamless integration so you can insert your COMSOL Multiphysics® graphics along with your other figures and tables and produce a complete worksheet presentation.

 

Product Features

  • Perform and control your COMSOL Multiphysics modelling from the Excel environment
  • Open COMSOL Multiphysics models from an Excel workbook
  • Synchronise model parameters, variables, and functions with an Excel worksheet
  • Change parameters, variables, and functions in the worksheet, then update and solve the model
  • Run parametric sweeps from the Excel environment
  • Extract results from a model to an Excel worksheet
  • Track the progress of the solution through the COMSOL Model window
  • While modelling in the COMSOL Desktop, load and save model definitions from an Excel workbook
  • Create COMSOL material libraries from data in an Excel worksheet
Supported Formats for File Import
File Format
Extension
Import
Export

Want to know more?

I Want To Know More Form
(COMSOL®, COMSOL Multiphysics®, Capture the Concept, COMSOL Desktop®) are registered trademarks of COMSOL AB, LiveLink™ is an unregistered trademark of COMSOL AB, ACIS and SAT are registered trademarks of Spatial Corporation. AutoCAD, AutoCAD Inventor and Inventor are registered trademarks or trademarks of Autodesk, Inc., and/or its subsidiaries and/or affiliates in the USA and/or other countries. CATIA is a registered trademark of Dassault Systèmes or its subsidiaries in the US and/or other countries. Microsoft, Excel and Windows are registered trademarks or trademarks of Microsoft Corporation in the United States and/or other countries. Parasolid and Solid Edge are trademarks or registered trademarks of Siemens Product Lifecycle Management Software Inc. or its subsidiaries in the United States and in other countries. SolidWorks is a registered trademark of Dassault Systèmes SolidWorks Corporation. Creo and Pro/ENGINEER are trademarks or registered trademarks of PTC Inc. or its subsidiaries in the U.S. and in other countries. MATLAB is a registered trademark of The MathWorks, Inc. Amazon Web Services, the “Powered by Amazon Web Services” logo, Amazon EC2 and Amazon Elastic Compute Cloud are trademarks of Amazon.com, Inc. or its affiliates in the United States and/or other countries. Mac and Macintosh are trademarks of Apple Inc., registered in the U.S. and other countries. Linux is a registered trademark of Linus Torvalds. Red Hat is a registered trademark of Red Hat, Inc. in the U.S. and other countries. Neither COMSOL nor any COMSOL products are affiliated with, endorsed by, sponsored by, or supported by any of these other trademark owners. Other product names, brand names or logos are trademarks or registered trademarks of their respective holders.