Write Excel report values to AVEVA Process Simulation

You can use the SCSetValue function to write values from your Excel report back to AVEVA Process Simulation. For detailed information on the AVEVA Process Simulation functions shipped with the Excel Add-In, see Understanding Excel functions.

Write a value back to AVEVA Process Simulation

1. In an empty cell, enter the SCSetValue function and include the required arguments. For example, enter the following function:

   =SCSetValue(100, "CWS1", "P", "kPa", "CWSim")

   You can leave the simulation argument ("CWSim" in this example) blank to use the default simulation. You can also set any argument to a cell reference instead of directly entering the value into the function, for example, =SCSetValue(A1, A2, A3).

2. On the AVEVA Process Simulation tab, in the Data group, select Write.

   The value that you wrote to AVEVA Process Simulation appears in the cell that contains the SCSetValue function.