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.

• 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

• 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.

• 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

• 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 Aspen Process Explorer.
• Workshop: Create an Ad Hoc calculation that uses in IF statement

• 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 

• Review how to create multiple calculations at the same time.
• Workshop: Create calculation using the Excel spreadsheet provided.

• Identify and explain the business case for using Aspen KPI Builder
•  Introduce the concepts associated with Aspen KPI Builder
• Discuss how Aspen KPI Builder can be integrated with other Aspen Plant Operations applications
• Show how to view and use KPIs within Aspen Process Explorer

• Identify and explain the KPI Wizard to build KPIs
• Workshop: Create several KPI tags using the KPI Wizard.

• Explain how to view and modify KPI properties
• Workshop: Reconfigure the KPI tags using the KPI Properties dialog.

• Provide an overview of the KPI Records using the Aspen InfoPlus.21 Administrator
• Workshop: Become familiar with the structure of KPIDef records using the Aspen InfoPlus.21 Administrator. Use an Aspen Calc calculation and a Aspen SQLplus Stored Procedure as alternate sources for the KPI and Target Values

• Identify and explain the advantages of using Excel add-in features
• Show how to setup the initial configuration to link Excel to the Aspen add-in
• Demonstrate the ability of the add-in to retrieve attributes and current values from the Aspen InfoPlus.21 database.
• Demonstrate how to use cell references within Excel
• Workshop: Retrieve attributes and current values from the Aspen InfoPlus.21 database
• Demonstrate how to retrieve historical data, Filtering the data and using the Timeline to cause the sheet to refresh
• Workshop: retrieve historical data, Filter data and use the Timeline to refresh the sheet

• Identify various features of Aspen SQLplus and the potential benefits of these features
• Interpret the Aspen Process Information database as a relational database so that SQL can be applied to it

• Use the Aspen SQLplus Query Writer to create and execute queries
• Apply the syntax of a SELECT statement to query the Aspen database
• Sort data from a query using the ORDER BY
• Workshop: Use the Aspen SQLplus editor to construct simple queries with the SELECT statement and become familiar with the Query Editor.

• Learn how to filter data using the WHERE clause with examples of the following
• logical and comparison operators
• character and timestamp constants
• Know which criteria to use to restrict results
• Learn the order of precedence when using Logical Operators
• Introduce Wildcards and show how they can be used in queries
• Workshop: Use a WHERE clause to restrict output from the database using various techniques.

• Create queries that use arithmetic functions, expressions, and apply the rules that govern their use
• Perform data conversion as performed by Aspen InfoPlus.21
• Use Pseudo Columns and Pseudo Tables to access system-type data from the Aspen InfoPlus.21 database
• Workshop: Use arithmetic functions, expressions, and Pseudo columns to enhance the SELECT statement.

• Create queries that use SET (Group) Functions effectively
• Create subsets using the GROUP BY clause
• Restrict the output with a HAVING clause and comparing with use of WHERE
• Create cross-tabulated lists
• Workshop: Use the SET functions to calculate values for groups of data.

• Save queries as files and as records in the InfoPlus.21 Database
• View the structure of a Query Record and see how the query is stored
• Execute query records using different methods of activation
• Demonstrate an understanding of the purpose of Compressed queries
• Create queries that use the system functions ACTIVATION_RECORD and ACTIVATION_FIELD within a Generic Query
• Outline the principles behind Ghost Select Queries
• Workshop: Create a query that is saved as a record. Activate the query using various methods. Set up a compressed query.
• Workshop: Create and populate a data record from a prepared custom definition record that allows a link to a query. Write a query to process this record.

• Understand basic procedural statements
• Use simple programming techniques
• Workshop: Use the Aspen SQLplus programming extensions to write some short program routines.
• Workshop: Modify the IQ task so that it can run in multi-threaded mode.

• Review Pseudo Columns and Pseudo Tables
• Review Aggregates and Evenly spaced History
• Workshop: Use Pseudo Columns. Use Pseudo Tables ALL_RECORDS, AGGREGATES, and HISTORY. Access history selectively by occurrence number, and by explicit occurrence number.