3.1. Export to Microsoft Excel (Windows Only)

An option in the Ansys Chemkin Visualizer allows you to export all the selected solution data to an Excel workbook so Excel can be used to generate custom plots. This option serves as an alternative to Chemkin’s native Visualizer on Windows platforms. The Use Excel to Post-Process option is available on the Select Post-Processing Variables panel after you have chosen to plot results using the Analyze Results node. If the option is selected when the Process Solution Data button is used, all the solution data will be collected in a single unsaved workbook in Excel. For a nominal run, the workbook includes the following worksheets:

  • Basic solution data as selected by user in the Select Post-Processing Variables panel

  • Single-point data (such as ignition delay time and flame speed) in a transient simulation or 1-D steady-state simulation if selected

  • Sensitivity data if selected

  • Rate-of-production data if selected

For a parameter study, the workbook includes the following worksheets:

  • Basic solution data collected from each parameter study run

  • Single-point data collected from each parameter study run if selected

  • Sensitivity data collected from each parameter study run if selected

  • Rate-of-production data collected from each parameter study run if selected

  • Single-point data vs. the parameters varied in the parameter study

  • End-point data in a transient simulation or 1-D steady-state simulation vs. the parameters varied in the parameter study

All the solution data loaded into Excel is in column-based format. Because Excel imposes a limit on the number of columns in a single worksheet, data sets that exceed this limit will be automatically divided up into subsets so that each subset will satisfy the limit. Please note that the contour data sets available to Ansys Chemkin’s native Visualizer are not available to Excel because it cannot handle that type of data.