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:

• Mass, density and element concentrations
• Core log categories and entries
• Linear and planar structures

Exporting Mass, Density and Concentrations

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

The Export Element Concentrations window will appear, where you can pick the export file name, what elements to export and choose some export parameters. You can also choose the grouping type, which is either 8 mm (highest granularity) or one row per interval (see Intervals).

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 (Estimated) - Estimated rock mass in grams.
• Density (Estimated) - Estimated density in g/cm³. This density is calculated from the estimated mass and the measured volume.
• 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.)

In sections where the XRF signals are degraded, the Mass (Estimated), Density (Estimated) 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)

See Rock Density for information about the difference between measured and estimated 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:

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

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:

The Export Structures window will appear, where you can pick the export file name, what structure class to export and choose some export parameters:

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.