Export Binary Phase Diagram data to an Excel report

You can export the data from your Binary Phase Diagram to a Microsoft Excel report.

By default, AVEVA Process Simulation exports data for temperature, pressure, liquid fractions for both components, and vapor fractions for both components.

For Binary Phase Diagrams that display binary vapor-liquid equilibrium (BVLE) data, the Excel report includes the following worksheets.

• Bubble Point: This worksheet displays the thermodynamic data for each data point on the bubble curve.

• Dew Point: This worksheet displays the thermodynamic data for each data point on the dew curve.

• Fluid Data: This worksheet displays the components in the binary system and the thermodynamic method that AVEVA Process Simulation uses for the calculations.

• gamma-x: This worksheet displays the activity coefficient values as a function of the liquid composition. This data is available only when you configure the Binary Phase Diagram at a constant temperature.

For Binary Phase Diagrams that display binary vapor-liquid-liquid equilibrium (BVLLE) data, the Excel report includes the following worksheets.

• Liquid-Liquid Equilibrium: This worksheet displays the thermodynamic data for each data point on the detailed liquid-liquid equilibrium diagram.

• Vapor-Liquid Equilibrium: This worksheet displays the thermodynamic data for each data point on the vapor-liquid-liquid equilibrium diagram.

• Fluid Data: This worksheet displays the components in the binary system and the thermodynamic method that AVEVA Process Simulation uses for the calculations.

• gamma-x1: This worksheet displays the activity coefficient values as a function of the liquid composition in the Liquid 1 phase (x1). This data is available only when you configure the Binary Phase Diagram at a constant temperature.

• gamma-x2: This worksheet displays the activity coefficient values as a function of the liquid composition in the Liquid 2 phase (x2). This data is available only when you configure the Binary Phase Diagram at a constant temperature.

The Excel report displays data in the UOMs that are specified in the UOM Slate for the Simulation.

Export Binary Phase Diagram data to Excel

1. On the Canvas, double-click the Binary Phase Diagram to open the Binary Phase Diagram with the configuration area expanded.

2. In the General section, select Mole Basis or Mass Basis to export the binary phase data in terms of mole fractions or mass fractions, respectively.

3. In the Configure section, in the Compositional Intervals box, enter the number of data points that you want to include in the Excel report.

4. In the Calculate at Constant list, select one of the following options:

   • Temperature:AVEVA Process Simulation calculates all data points at the specified temperature.

   • Pressure:AVEVA Process Simulation calculates all data points at the specified pressure.

5. In the Calculate at Constant box, enter the value of the constant temperature or constant pressure.

6. Expand the Report section.

7. Select Generate Excel Report.

   The Save As dialog appears.

8. Browse to the location in which you want to save the Excel report.

9. In the File name box, enter the name of the Excel report, and then select Save.

   AVEVA Process Simulation creates the .xlsx file, which you can then open in Excel.