Exporting Loss Results To CSV Files

You can export loss results from a catastrophe peril analysis (either in Portfolio or Underwriting mode) to comma-separated values (CSV) files.

When you configure the export job, you choose the types of CSV files (or reports) to export. For example, you may export one report for event losses by portfolio and another for average annual losses by contract. You also choose the financial perspectives to include in the reports, whether to apply filters, and whether to include standard deviations and uncertainty percentages. For example, you may export only ground-up losses for locations with a given construction class code in one U.S. state.

In general, you can export event losses by portfolio, LOB, geography, geography and contract, geography and contract and layer, and layer and location. For a catastrophe peril analysis, you can export average annual losses (AAL) by contract and by LOB, and export exposure data and AAL by contract, LOB, and geography. When exporting comparative loss results to CSV files, you can include event losses by portfolio, average annual loss by LOB, average annual loss by geography, annual EP detail, and average annual loss by location.

Some reports are available only if you specified certain settings when you configured the loss analysis. For example, if you ran an analysis using workers' compensation exposure data with a peril supported for workers' compensation (earthquake or terrorism), and you included injury type as an output option, then you can export event losses by geography and injury.

You can view and export loss results from previous product versions. However, if the geography information has changed since Touchstone generated the losses, the exported report includes only the older geography information. The header in the report will not contain product version information.

Procedure

To export a set of loss results to a CSV file:

  1. On the global menu bar, click Export > Results > Loss to CSV.
  2. On the Source Results tab:
    1. Select the analysis to export.

      The yellow warning triangles on the remaining tabs indicate that you must fill in the fields.

      Note:

      AIR ExportExpress does not include results from deleted databases in the grid.

    2. In the Number of Cores fields, specify the minimum and maximum number of cores to use.
  3. On the Reports to Generate tab, select one or more reports.
  4. On the Perspectives & Filters tab:
    1. In the Financial Perspectives area, select the perspectives to include.

      You must select at least one perspective. The perspectives that you can choose depend on how you configured the loss analysis.

    2. [Optional] Clear the option to include Standard Deviation and Uncertainty Percentages.

      For more information, see Reports with Standard Deviations and Percentages. Column headings in the reports include identifying information.

    3. [Optional] In the Results Filters area, define complex filters.
  5. Specify the destination for the exported data.
  6. [Optional], clear Close on Export if you want to keep AIR ExportExpress open after you submit the export job.
  7. Click Export.