Exporting Loss Results To CSV Files

You can export catastrophe peril analysis and non-catastrophe peril analysis loss results 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 both catastrophe peril analysis and non-catastrophe peril analysis, you can export  average annual losses (AAL) by contract and by LOB, as well as exposure data and AAL by contract, LOB, and geography. For comparative loss to CSV exports, 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.

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

1.     On the global menu bar, click Export, select Results, and then select Loss to CSV.

2.     On the Source Results tab:

a.     Select the analysis to export.

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

b.     In the Number of Cores fields, specify minimum and maximum number of cores to use.

3.     In the Reports to Generate tab, select one or more reports.

4.     In the Perspectives & Filters tab:

a.     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.

b.     Optionally deselect 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.

c.     In the Results Filters area, optionally define complex filters.

5.     Specify the destination for the exported data.

6.     Optionally, deselect Close on Export to keep AIR ExportExpress open after you submit the export job.

7.     Click Export.