Aspen Calc: Using and Configuring

Learn how to create calculations integrated with Aspen InfoPlus.21 without the need for programming languages. Create simple calculations integrated with Aspen InfoPlus.21 using CalcScript, - Excel spreadsheets, VBScript and Datasets. Learn how to incorporate standard Functions into a calculation, create a new formula and manage libraries. Learn how to create Ad Hoc and Shared calculations.

Audience:

  • End users who need to quickly build small applications involving calculations within Aspen InfoPlus.21 database
  • Advanced users who need to integrate complex calculations external to Aspen InfoPlus.21 into the InfoPlus.21 environment
  • Those designated as Aspen InfoPlus.21 system administrators or backup administrators.
  • System integrators
  • Anyone involved in technical evaluation of products

Training Details

  • Course Id:

    MES123

  • Duration:

    1.5 day(s)

  • CEUs Awarded:

    1.1

  • Level:

    Introductory

Approach

  • Although the course does not assume any prior experience with Aspen InfoPlus.21, those attendees that already have a working familiarity with the product will benefit greatly by discovering how calculations are integrated into InfoPlus.21 database processing
  • Short lecture sessions focused on concepts and terminology
  • Structured hands-on lab exercises that promote lasting learning experiences
  • Product features up to and including Aspen InfoPlus.21 version 2006.5 are covered

Pre-requisites

  • Some understanding of InfoPlus.21 database structure:
  • Attendance of PME122 or MES122 Aspen Process Explorer: Using and Configuring or PME201 or MES201 Aspen SQLplus for Aspen InfoPlus.21: Using and Configuring for Power Users Course is helpful though not mandatory

Subsequent Courses

MES311 Aspen InfoPlus.21: Applications Development

Agenda

Creating a New Calculation
  • Identify and explain Aspen Calc capabilities and show the access and navigation within the graphical user interface
  • Review the data entry requirements for creating a calculation and discuss the different calculation methods available
  • Workshop: Use CalcScript to calculate the average value of raw material tanks in a simulation.

Activation Methods
  • Describe how to execute a calculation on a scheduled basis
  • Show how to use the interval and periodic schedule groups
  • Show how to use an event driven execution
  • Workshop: Execute a calculation on a scheduled basis. Create a new schedule group. Execute a calculation on a trigger basis

Formulas
  • Identify and explain the role of Formulas and how the work
  • Show how to create and store formulas
  • Use a new formula in a calculation
  • Use a pre-defined function within a calculation
  • Create a new Function and use it in a calculation
  • Workshop: Create a new calculation that uses a formula to calculate the minimum value of a tag over a specific time range..

Calculation Types
  • Review how to create calculations using Excel
  • Review how to create calculations using VBScript
  • Workshop: Create a new calculation using an Excel spreadsheet as the calculation type

On Demand Calculations
  • Review different types of On Demand calculations; Ad Hoc, Stored and Shared
  • Review how to create an ADSA Data Source to be used with Stored calculations
  • Show examples of how to use On Demand calculations in client applications such as Aspen Process Explorer and Aspen Web.21
  • Workshop Create an Ad Hoc calculation in Process Explorer.
  • Workshop: Create an Ad Hoc calculation that uses in IF statement

Other Features
  • Review how to view reports.
  • Review Engineering Units and Types
  • Review Engineering Units conversion
  • Workshop: Complete the lab exercise to:
  • View AspenCalc reports
  • View a calculation as an XML file
  • Create a new Engineering Unit Type and Engineering Unit
  • Creating Multiple Calculations
  • Review how to create multiple calculations at the same time.
  • Workshop: Create calculation using the Excel spreadsheet provided.

Register for a Class

Date Class Type Location Price Language
Date(s): 11/25/2021 - 11/26/2021 Type: Public Virtual Location: Virtual-EMEA Price: (GBP) 1200.00 Language: English Register
Date(s): 10/13/2021 - 10/14/2021 Type: Public Virtual Location: Virtual-Americas Price: (USD) 1400.00 Language: English Register
Date(s): 11/15/2021 - 11/16/2021 Type: Public Virtual Location: Virtual-Americas Price: (USD) 1400.00 Language: English Register
Date(s): 12/6/2021 - 12/7/2021 Type: Public Virtual Location: Virtual-Latin America Price: (USD) 800.00 Language: Spanish Register
Date(s): 09/28/2021 - 09/29/2021 Type: Public Virtual Location: Virtual-Latin America Price: (USD) 800.00 Language: Spanish Register
Date(s): 10/25/2021 - 10/27/2021 Type: Public Virtual Location: Virtual-Latin America Price: (USD) 800.00 Language: Spanish Register
Date(s): 11/17/2021 - 11/18/2021 Type: Public Virtual Location: Virtual-Latin America Price: (USD) 800.00 Language: Spanish Register
Date(s): 01/10/2022 - 01/11/2022 Type: Public Virtual Location: Virtual-Americas Price: (USD) 1400.00 Language: English Register
Date(s): 02/17/2022 - 02/18/2022 Type: Public Virtual Location: Virtual-Americas Price: (USD) 1400.00 Language: English Register
Date(s): 04/26/2022 - 04/27/2022 Type: Public Virtual Location: Virtual-Americas Price: (USD) 1400.00 Language: English Register
Date(s): 05/17/2022 - 05/18/2022 Type: Public Virtual Location: Virtual-Americas Price: (USD) 1400.00 Language: English 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.