Export loss results to *.csv files

You can export loss results from a detailed loss analysis 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. You can export average annual losses (AAL) by contract and by LOB, and export exposure data and AAL by contract, LOB, and geography.

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

  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 warning triangles on the remaining tabs indicate that you must fill in the fields. Note that 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.

    If you chose to save loss results by sub-peril, by selecting Sub-Peril in the Additional Details area of the Output Options pane, the application automatically enables the Include Sub-perils check box in all reports that have a by-event depiction of losses. You can deselect the check box.

  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 Include available Standard Deviation for selected financial perspectives check box.
      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 the Close on Export check box if you want to keep ExportExpress open after you submit the export job.
  7. Click Export.