Skip to content

Exporting to CSV

Results from the scan data, as well as manual annotations made in Insight, can be exported to CSV (Comma Separated Values) format files. Separate exports are available for:

  • Volume, mass, density, element concentrations, and attenuation segmentations
  • Core log categories and entries
  • Linear and planar structures

Exporting Volume, Mass, Density, Concentrations, and Attenuation Segmentations

To export volume, mass, density, element concentrations, and attenuation segmentations for the active hole, choose Hole → Export Data... in the menu bar:

Export Concentrations

The Export Hole Analysis Data to CSV File window will appear, where you can specify the export file path and name, and export parameters. Available grouping types are one row per 8 mm (highest granularity) and one row per interval (see Intervals).

Export Dialog

Choose OK to confirm the export. If you checked the Open exported file when finished, the resulting CSV will be opened using the application associated with CSV (.csv) files, for example Excel.

The output format is a CSV with the following columns:

  • Hole ID - Hole ID as text.
  • Depth From - From depth in meters.
  • Depth To - To depth in meters.
  • Volume (Measured) - Measured volume of rock in cm³.
  • Volume Error (Measured) - Measured volume error estimate in cm³. Since the volume is measured by thresholding of the 3D tomography, which is a regular grid of finite-sized voxels, the volume error is estimated as the volume of the single-voxel thick surface layer which cannot be reliably classified as air or rock. Currently this is done under the assumption of perfectly cylindrical (intact) core.
  • Mass (Measured) - Measured rock mass in grams. This is measured per loaded sample using the load cell in the GeoCore X10. See note below.
  • Mass Error (Measured) - Measured rock mass error estimate in grams. Since the sample is weighed on the load cell while inside the sample holder (tube), this error estimate incorporates both the load cell's limited precision and the expected variation in sample holder weight, which is subtracted from the measured weight to produce the rock mass.
  • Density (Measured) - Measured density in g/cm³. See note below.
  • Density Error (Measured) - Measured density error estimate in g/cm³. This is calculated from the measured mass and measured volume error estimates.
  • XRF Degraded - "Yes" if the XRF signals are degraded, otherwise "No" (see Degraded XRF Signals).
  • Mass (Predicted) - Predicted rock mass in grams.
  • Density (Predicted) - Predicted density in g/cm³. This density is calculated from the predicted mass and the rock volume considered in the mineralogical fit.
  • Next follows one column for each exported element, containing the concentration in gram per metric ton, with the chemical symbol as column heading. The columns are in alphabetical order. (See Element Concentrations for information about which elements this includes.)
  • Finally, one column for each attenuation region within the selected attenuation segmentation presets (see Attenuation Segmentation Presets), containing the volumetric concentration associated with the region, expressed as a percentage of the total rock volume.

In sections where the XRF signals are degraded, the Mass (Predicted), Density (Predicted) and element concentration columns will be empty.

Note

Since there is only one measured mass value available per scanned sample, the measured mass/density columns and their associated error columns are only present if the One row per interval option is used, and a row will only have a value in these columns if both interval boundaries coincide with the boundary of a scanned sample (see Intervals). The same applies to the measured volume error estimate.

See Rock Density for information about the difference between measured and predicted density.

Exporting Core Log

To export the core log of the currently active hole (see Core Logging), choose Hole → Export Core Log... in the menu bar:

Export Core Log

The Export Core Log to CSV File window will appear, where you can specify the export file path and name, and which log categories to include:

Export Core Log Dialog

Choose OK to confirm the export. If you checked the Open exported file when finished, the resulting CSV will be opened using the application associated with CSV (.csv) files.

The result is a CSV file with the following columns:

  • Hole ID - Hole ID as text.
  • From (m) - Start depth in meters.
  • To (m) - End depth in meters.
  • Next follows one column for each included log category, with the name of the category as column heading. The rows below the header then contain the log entries of the category, represented by the names of their associated log values.

The export consists of one data row per unique interval, as defined by the combined start and end points of the log entries of all included log categories. I.e. each interval starts and ends, at the closest pair of points that marks a change of log value in any of the included log categories.

Exporting Structures

To export the structures you have logged in the active hole (see Logging Structures), choose Hole → Export Structures... in the menu bar:

Export Structures

The Export Structures window will appear, where you can specify the export file path and name, and which structure classes to include:

Export Structures

Choose OK to confirm the export. If you checked the Open exported file when finished, the resulting CSV will be opened using the application associated with CSV (.csv) files.

The result is a CSV file with the following columns:

  • Hole ID - Hole ID as text.
  • Class - Linear or Planar
  • Type - Structure type as text.
  • Depth - Structure depth in meters.
  • Alpha - α angle (0° to 90°) of planar structure in degrees.
  • Beta - β angle (0° to 360°) of planar structure in degrees.
  • Gamma - γ angle (0° to 90°) of linear structure in degrees.
  • Delta - δ angle (0° to 360°) of linear structure in degrees.
  • Dip - Dip angle (0° to 90°) of planar structure in degrees.
  • Dip Direction - Direction angle (0° to 360°) of planar structure in degrees.
  • Plunge - Plunge angle (0° to 90°) of linear structure in degrees.
  • Trend - Trend angle (0° to 360°) of linear structure in degrees.
  • Hole Azimuth - Azimuth angle (0° to 360°) of the hole collar in degrees.
  • Hole Inclination - Inclination angle (-90° to 90°) of the hole collar in degrees.
  • Orientation Line Location - Location ('Top' or 'bottom') of the orientation line marker.
  • Comment - Optional text comment.

Please refer to Structure Orientations for definitions of the exported structure orientation and hole collar variables.