Introduction to Aspen Simulation Workbook using Aspen Plus

Course Id:  EAP121   |   Duration:  1.00 day(s)   |   CEUs Awarded:  0.7   |   Level:  Introductory

Course Objective

Learn how to embed and link an Aspen Plus Simulation case and variables within MS Excel without using any programming languages. User can hide complex interfaces & technical details and perform analysis in Excel. User can link models to online plant data for on-demand advisory.

Course Overview

  • Create user interfaces to complex simulations for end-users unfamiliar with Aspen Plus
  • Use MS Excel® functionality such as plots, calculations, formatting, etc. to enhance the display of simulation results
  • Link simulation models to online plant data for on-demand advisory


Learn to embed and link an Aspen Plus Simulation case and variables within MS Excel® without using any programming languages.


Engineers who want to develop MS Excel® user interfaces to Aspen Plus simulations


  • Instruction on basic topics
  • Instructor-guided demonstrations of features
  • Hands-on workshops that apply learned concepts
  • Detailed course notes


Attend training course “EAP101 Introduction to Process Modeling using Aspen Plus” or extended experience in using Aspen Plus product for process modeling.

Subsequent Courses

  • EAP2121 Process Flowsheet Convergence in Aspen Plus
  • EAP250 Aspen Plus: Distillation Modeling
  • EAP2311 Building Custom Simulation Models using Aspen Custom Modeler®

Class Schedule

Class Agenda

EAP121: Introduction to Aspen Simulation Workbook using Aspen Plus

Introduction – What is Aspen Simulation Workbook (ASW)

  • Recognize ASW as an Excel Add-In Tool 
  • Identify the key applications of ASW
  • Differentiate between the Model Author and Model End-User
  • Recognize the compatibility of ASW with other Aspen products 
  • Review ASW column examples to become familiar with the ASW interface 
Basic Features of Aspen Simulation Workbook (ASW)
  • Describe the Workflow on how to link a model to Excel with ASW
  • Attach a model to Microsoft Excel
  • Build a process flow diagram in Excel
  • Workshop: Create PFD and Attach Model to ASW
Aspen Simulation Workbook Tables
  • Select model variables to add to ASW
  • Create and add model tables
  • Create and use table templates 
  • Workshop: Add tables to MethylChlorate Column Advisor
Aspen Simulation Workbook Automation
  • Add MS Excel equations and create plots of Aspen Plus variables 
  • Insert ASW functions and assign ASW macros to add functionality
  • Enhance the interface using conditional formatting
  • Workshop: Add ASW functions and macros to enhance the user interface
Running Scenarios
  • Create Scenario Tables to run multiple simulation cases
  • Workshop: Evaluate the effect of column reboiler temperature on product water content
Linking Models to Process Data
  • Link simulation model variables with plant process data and create Plant Data Tables
  • Workshop: Import key process data tags and map the tags to model variables
Publishing and Deploying Models
  • Restrict end-user access to ASW features 
  • Encapsulate model files or pointers to files in ASW workbooks
  • Deploy files over a web server
  • Workshop: Publish the MethyChlorate Column Advisor user interface
Troubleshooting Common ASW Issues
  • Change the location or name of the linked Aspen Plus simulation file
  • Explain best practice to minimize breaking links between workbook and model variables
  • Create automatic Backups of ASW data
  • Verify workbook data before saving

Aspen Technology, Inc. awards Continuing Education Units (CEUs) for training classes conducted by our organization. One CEU is granted for every 10 hours of class participation.