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
- On the global menu bar, click .
-
On the Source Results tab:
-
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.
-
On the Perspectives & Filters tab:
- Specify the destination for the exported data.
- [Optional], clear the Close on Export check box if you want to keep ExportExpress open after you submit the export job.
- Click Export.