Exporting Results


All layouts generated in the optimization controller are saved to the Risk Data Set in which the optimization was run on. If the Risk Data Set is deleted, then so will the optimization data.


There are three export options from the optimization controller:

  • Export Layout - exports an excel of the detector coordinates, a Detect3D (.d3d) file, or DWG CAD file of the optimized layout

  • Export Detection Matrix - exports an excel file indicating which detector went into alarm for each dispersion case

  • Export Coverage Data - exports an excel file showing the order of devices used, coverage data points and graph of the coverage achieved


Export each of the above options for Gas Detector Layout 04:

  1. Open the optimization controller and right-click Gas Detector Layout 04

  2. Select the Export Layout ( Picture 24 ) option first, in the window that appears ensure that the Save as type is set to Excel Document (*.xlsx) and name the file

  3. Right-click Gas Detector Layout 04 and export the Detection Matrix ( Picture 25 )

  4. Right-click Gas Detector Layout 04 and export the Coverage Data ( Picture 26 )



Open the excel file generated from the Export Layout option. The tabs for the exported layout are shown below containing a cover page, a layout summary page and a listing of each of the point and open path devices with their coordinates in CSV format.


Picture 27

Tutorial 12 - Figure 19 - Excel export of optimized Gas Detector Layout 04



Open the Detection Matrix excel file. This file provides information on which gas detector picked up which dispersion case in the analysis. The rows are made up of the dispersion cases and the columns are the gas detectors. A dot will exist in the cell corresponding to a detected gas leak. A tab for the undetected simulations is also provided. Note the key in the upper left of the excel file indicating different icons for different alarms o for Lo and ⨂ for Hi.


Tutorial 12 - Figure 20 - Detector Matrix for Gas Detector Layout 04 showing which detectors detected which simulations



Lastly, open the Coverage Data excel file. This file provides the list of the devices used to achieve the coverage target in order or priority. The list also shows the contribution to 1ooN and 2ooN coverages along with the corresponding graph.


Tutorial 12 - Figure 21 - Exported coverage graph with listing of detectors used to achieve displayed coverages



Detect3D files may also be exported in Step 2 above, when seting the save directory choose .d3d as the file format, shown below. This allows for comparison of geographic gas mapping method with scenario, frequency and risk-based gas mapping methods.


Tutorial 12 - Figure 22 - Exporting a detector layout to .d3d file


Continue to the next section to create before and after images comparing the unmitigated risk contour to the risk contour with the optimized layout.