Using Excel^® with COMSOL Multiphysics^® Simulations

Name: Using Excel® with COMSOL Multiphysics® Simulations
Uploaded: 2016-02-11 15:00:23
Duration: 42 min 7 s
Description: Learn how to use Microsoft® Excel® with {:comoslmph} via LiveLink™ for Excel®. Watch the archived webinar here.

Duration: 42:07

Back to Video Gallery

Overview
Transcript

Watch this archived webinar to learn how to use the Microsoft^® Excel^® spreadsheet software together with the COMSOL Multiphysics^® simulation software via LiveLink™ for Excel^®. We discuss using the interfacing product to synchronize parameters, geometry, and results between Excel^® and COMSOL Multiphysics^® in order to streamline your modeling workflow. We also share how you can update all of your COMSOL Multiphysics^® model settings via Visual Basic^® for Applications inside Excel^®.

Want to learn more about LiveLink™ for Excel^®? Contact COMSOL for a software evaluation.

Microsoft, Excel, and Visual Basic are either registered trademarks or trademarks of Microsoft Corporation in the United States and/or other countries.

Chapter Selection

Introduction (0:00) Agenda (0:30) COMSOL Multiphysics^® (1:30) COMSOL Server™ (2:08) Deployment (3:00) Functionality (4:42) LiveLink™ for Excel^® (5:25) Supported Platforms (6:39) Poll Question (7:35) LiveLink™ for Excel^® Ribbon Interface (9:27) Import, and Update Data Using Ribbon (10:34) Demonstration of the Ribbon Interface (11:42) Interface Excel^® Spreadsheets in COMSOL Desktop^® (25:15) Interface Excel^® Spreadsheets From Simulation Applications (26:35) Using LiveLink™ for Excel^® with VBA (27:18) Visual Basic^® for Applications (VBA) Editor in Excel^® (28:11) Interface and Update Parameters (29:02) Extracting Parameter Data (29:48) Demonstration of VBA Usage (30:25) Use COMSOL Desktop^® as Code Generator (35:19) Documentation and Tutorials (36:39) Questions? (57:34)