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
Introduction – What is Aspen Simulation Workbook (ASW) · Brief introduction about Aspen Simulation workbook and the add in tool in MS Excel^® Basic Features of ASW · Manage the ASW Add-in inside Excel · 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 Adding Automation to Your ASW Interface · 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 an ASW function to retrieve the simulation status and an ASW macro to change a column reflux ratio using a scroll bar	Running Scenarios · Overview of Scenarios and setting up Scenario Tables to run multiple cases · Workshop: Create a Scenario analysis to evaluate the effect of changing the reactor conversion of benzene to cyclohexane on reactor heat duty 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.  Plot the model and plant variables for a column temperature profile. Publishing and Deploying Models · Restrict end-user access to ASW features · 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 Troubleshooting Common ASW Issues · 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.