Exporting T-Data to the Utilities Datasheet

RockWorks | Borehole Manager | File |
Export | T-Data | T-Data -> Utilities Datasheet

This program will export to the Utilities datasheet the borehole ID, T-data interval depths (top, base, middle), XYZ coordinates for the intervals (top, base, middle), date, and "G" value for the interval, for a selected T-Data track, for selected boreholes. This can be used to verify data stored in the database, or to model the data in another program.

Menu Options
Step-by-Step Summary

Menu Options

• Logs: Expand this heading as necessary to select the boreholes whose T-Data is to be exported.
  • Single Borehole: Click in this radio button to export the data for a single borehole only.
    • Log ID: Click on this item to select from a drop-down list the name of the borehole whose data is to be exported. 
  • All Enabled Boreholes: Click in this radio button if all boreholes that are currently enabled in the Borehole Manager are to be included in the export.
• Track: Click on this item to select the track or column in the T-Data (Time Intervals) tables containing the data values (G values) to be exported.  Expand this heading to access the data filtering options.
  • Spatial (XYZ) Filtering: Insert a check in this box to activate a data filter based on spatial coordinates. Expand this heading to establish the filter settings. 
  • Filter based on Date/Time: Insert a check in this box to export measurements for a specific date or range of dates.  Expand this heading to access the Filter Options.
    • Exact: Click in this button if you wish to enter a specific date (and time, if applicable) for the measurements to be exported.  Click on the date displayed after the Date/Time Target to type or pick from the calendar the specific date. 
    • Range: Click in this button if you prefer to enter a beginning and ending date to define the range of dates to be exported. Click on the dates displayed after the Starting and Ending prompts to type in or pick dates from the calendar. 
  • Filter Based on G-Values: Activate this option to establish a data filter based on the measured values, and expand the heading to establish the filter parameters.  (More.)
  • Resample at Regularly-Spaced Intervals: Check this box to resample the data.  (More.)
    Note: The Resampling option will be automatically disabled if anything other than "All Samples" (below) is selected.
  • Create Filter / Sampling Report: If you've selected any filter/resampling options, this tool will create a summary report of the results. (More.)
• Items to Include: Use these options to define what T-Data values to export:
  • All Samples: All G values for the selected track for the selected boreholes will be exported.
  • Lowest T-Data Value in Each Borehole:  Only the single, lowest T-Data value for the selected track for each borehole is to be recorded for the well in the output file.
  • Highest T-Data Value in Each Borehole:  Only the single, highest T-Data value for the selected track for each borehole will be recorded to the output file.
  • Sum Of All IT-Data Values in Each Borehole:  Output the sum of all values for the selected track for each borehole to the exported file.  For non-vertical boreholes, the xyz coordinates for this point will correspond with the midpoint of the last (lowest) T-Data interval in the borehole.
  • Average T-Data Value for Each Borehole:  The average of all of the values for the selected track for each borehole will be recorded in the output file.  For non-vertical boreholes, the xyz coordinates for this point will correspond with the midpoint of the last (lowest) T-Data interval in the borehole.

Step-by-Step Summary

1. Access the RockWorks Borehole Manager program tab.
2. Be sure there is T-Data listed for one or more boreholes.
3. Be sure the boreholes to be processed (if more than one) are shown as Enabled in the borehole listing.
4. Select the File | Export | T-Data | T-Data -> Utilities Datasheet menu option.
5. Enter the requested menu settings, described above.
6. Click the Process button to continue.

The program will extract the selected data from the database, and record the borehole ID, T-data interval depths (top, base, middle), XYZ coordinates for the intervals (top, base, middle), dates, and "G" value for each interval in the output file. The results will be listed in the Utilities datasheet. 

See also

• Exporting T-Data to a Text File
• Exporting T-Data to CSV
• Exporting T-Data to Shapefiles

  Back to Exporting Data 

RockWare home page