Introduction to Aspen Simulation Workbook using Aspen Plus

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.

Audience:

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

Training Details

  • Course Id:

    EAP121

  • Duration:

    1 day(s)

  • CEUs Awarded:

    0.7

  • Level:

    Introductory

Benefits

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

Approach

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

Pre-requisites

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®

Agenda

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

Register for a Class

Date Class Type Location Price Language
Date(s): 12/3/2025 - 12/3/2025 Type: Public Classroom Location: 2500 Citywest Blvd, Suite 1600
Houston , Texas USA 77042 		Price: (USD) 1000.00 Language: English Register
Date(s): 12/3/2025 - 12/3/2025 Type: Public Virtual Location: Virtual-Americas Price: (USD) 1000.00 Language: English Register
Date(s): 11/21/2025 - 11/21/2025 Type: Public Classroom Location: C2, Reading International Business Park, Basingstoke Road
Reading , United Kingdom RG2 6DT 		Price: (USD) 1000.00 Language: English Register
Date(s): 12/15/2025 - 12/15/2025 Type: Public Virtual Location: Virtual-EMEA Price: (USD) 1000.00 Language: English Register
Date(s): 01/23/2026 - 01/23/2026 Type: Public Virtual Location: Virtual-EMEA Price: (USD) 1000.00 Language: English Register
Date(s): 03/20/2026 - 03/20/2026 Type: Public Virtual Location: Virtual-EMEA Price: (USD) 1000.00 Language: English Register
Date(s): 04/24/2026 - 04/24/2026 Type: Public Virtual Location: Virtual-EMEA Price: (USD) 1000.00 Language: English Register
Date(s): 02/20/2026 - 02/20/2026 Type: Public Classroom Location: C2, Reading International Business Park, Basingstoke Road
Reading , United Kingdom RG2 6DT 		Price: (USD) 1000.00 Language: English Register
Date(s): 05/22/2026 - 05/22/2026 Type: Public Classroom Location: C2, Reading International Business Park, Basingstoke Road
Reading , United Kingdom RG2 6DT 		Price: (USD) 1000.00 Language: English Register
Date(s): 09/22/2026 - 09/22/2026 Type: Public Classroom Location: B8, Wison, No 699, Zhongke Road, Zhangjiang High-Tech Zone, Pudong
Shanghai , China 201210 		Price: (CNY) 1400.00 Language: Chinese Register

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.