Excel reports

About Excel reports

AVEVA Process Simulation is shipped with a Microsoft Excel Add-In that you can select when you install the product. This add-in allows you to connect to an AVEVA Process Simulation Repository, open a particular simulation, and load specific snapshot data or the results of a simulation to create and maintain Excel reports. When you install the AVEVA Process Simulation Excel Add-In, the SimCentral tab will automatically be visible in Excel; from there, you can open a particular simulation and begin to create a report. You can refresh your report from within Excel, and the newest simulation data will be loaded. You can save and re-open a report and all links will function as long as the simulation is available in the Repository. To install the AVEVA Process Simulation Excel Add-In, you must either have Microsoft Excel 2019, 2016, 2013, or 2010 installed on your computer.

Concepts

• The AVEVA Process Simulation Excel Add-In connects directly to the AVEVA Process Simulation Repository

• You can create complex spreadsheets using functions that refer to columns and rows of model and variable names

• You can access more than one simulation or Snapshot to perform case comparisons

• You can save and re-open a report and all links will function as long as the simulation is available in the Repository

• A function retrieves values and UOMs from AVEVA Process Simulation in any cell

• You can refresh your report from within Microsoft Excel, and the newest simulation data will load

Actions

• Select a default simulation

• Select a default Snapshot

• Select a default UOM Slate

• View detailed function arguments

• Use the AVEVA Process Simulation function to report a variable's value in a cell

• Use the AVEVA Process Simulation function to report a value's UOM in a cell

• Overwrite the default Snapshot or default UOM Slate in the function