Export Heat Curve data to an Excel report

You can export the data from your Heat Curve to a Microsoft Excel report.

By default, AVEVA Process Simulation exports data for temperature, pressure, phase fractions, and molar and mass-based enthalpy. You can also include phase-specific property data and transport properties in the Excel report.

If the fluid includes two liquid phases, the Excel report includes data for the bulk liquid phase as well as each individual liquid phase.

The configuration of the Heat Curve determines the following for the Excel report:

• Which worksheets appear.

• The temperature range.

• The pressure range.

• The number of data points.

• The step change between data points.

• Whether additional thermophysical property data and transport property data appear in the report.

The Excel report includes the following worksheets:

• Heat Curve_MassBasis and HeatCurve_MoleBasis

  These two worksheets display the thermodynamic data for each data point on the Heat Curve on a mass basis and molar basis, respectively.

  If the Heat Curve displays multiple isobaric curves (that is, you set the Heat Curve Type to MultipleIsobaric), the Excel report doesn't include the Heat Curve_MassBasis and HeatCurve_MoleBasis worksheets. Instead, it includes two similar worksheets for each isobaric curve, one on a mass basis (HeatCurve@<Pressure>) and one on a molar basis (HeatCurve@<Pressure> (2)).

• Summary

  This worksheet displays the details for the fluid, including the thermodynamic method that AVEVA Process Simulation uses for the calculations, the components in the fluid, and the compositions for each of those components. However, when you select Stream in the Configuration section of the Heat Curve, the Summary worksheet also includes the temperature conditions for the Start (inlet) and End (outlet) streams, overall heat transfer duty between the streams, and the total mass flow rate in the streams.

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

Export Heat Curve data to Excel

1. On the Canvas, double-click the Heat Curve to open the Heat Curve with the configuration area expanded.

2. In the Configuration section, review and update the Heat Curve configuration as needed.

   See Configure a Heat Curve for more information.

3. Expand the Report section.

   By default, the Excel report includes the following properties:

   • Pressure

   • Temperature

   • Enthalpy

   • Vapor weight fraction

   • Critical pressure calculated according to Kay's rule

   • Critical temperature calculated according to Kay's rule

4. If you want to include the thermophysical property data for each phase in the Excel report, select the Thermophysical properties for each phase checkbox.

   For the vapor phase and the liquid phase, the thermophysical properties available in the Excel report include:

   • Density

   • Viscosity

   • Specific heat capacity

   • Thermal conductivity

   • Enthalpy

   • Molecular weight

     In addition, the Excel report for a liquid phase also includes the surface tension and latent heat of vaporization properties.

     When the associated Fluid Type uses vapor-liquid-liquid equilibrium (VLLE) calculations, the latent heat of vaporization is available only for the bulk liquid phase and not the individual liquid phases. The following properties are available only for the individual liquid phases and not for the bulk liquid phase:

   • Specific heat capacity

   • Thermal conductivity

   • Enthalpy

   • Surface tension

5. For a Stream configuration type, select the Phase flow rates checkbox to include the following flow rate properties in the Excel report:

   • Total flow rates for vapor and liquid

   • Enthalpy rates for vapor, liquid, and the total

6. Select Generate Excel Report.

   The Save As dialog appears.

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

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

   AVEVA Process Simulation creates the .xlsx file and automatically opens it in Excel.