Training Course Data Sheet

EAP121

Building MS Excel User Interfaces

For Aspen Plus Simulations Using

Aspen Simulation Workbook 

Course Number:

EAP121

Duration:

1 day

CEUs Awarded:

0.7

Level:

Introductory

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

Course Benefits

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

Who Should Attend

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

Approach

·         Course notes containing lecture materials, examples, and workshops are distributed

·         Lecture topics are reinforced with workshops throughout the day

·         Questions relating the course material to real life problems are encouraged

Prerequisites

·         Attend training course “EAP101 Aspen Plus: Process Modeling” 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^®

Building MS Excel User Interfaces for Aspen Plus Simulations Using Aspen Simulation Workbook

·         Overview of the ASW Environment and working with Model Variables

·         Use the Table Wizard to build tables of simulation variables

·         Workshop: Create a process flow diagram using ASW process icon library

·         Workshop: Link an Aspen Plus simulation process, add key model variables to the Variable Organizer and create tables of the variables in ASW

·         Workshop: Create a table template for creating multiple tables using the same layout and format

·         Insert ASW functions and assign ASW macros to add functionality

·         Enhance the interface using conditional formatting

·         Workshop: Add an ASW function to retrieve the simulation status and an ASW macro to change a column reflux ratio using a scroll bar

·         Workshop: Import key process data tags and map the tags to model variables.  Plot the model and plant variables for a column temperature profile.

·         Encapsulate model files or pointers to files in ASW workbooks for easier distribution to end-users through email, MS SharePoint, etc.

·         Deploy files over a web server

·         Workshop: Set access conditions on a flowsheet interface to prevent accessing the Aspen Plus model and Workbook Organizer and make the simulation active on startup of the ASW workbook

·         Change the location or name of the linked Aspen Plus simulation file

·         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 and development activities conducted by our organization in accordance with the definition established by the International Association of Continuing Education & Training (IACET). One CEU is granted for every 10 hours of class participation.