Data Export, Reports, and Printing

The File menu contains commands for exporting RAD7 Data in various formats, generating several different kinds of reports, and for printing RAD7 data graphs. These features are detailed in this section.

After RAD7 Data has been downloaded or opened from disk and made visible in a graph window, it may be exported in any of several formats.

The Export Selected Data command in the File menu includes options for exporting different types of files, as described below. Most of these will involve only the selected records, which are those found between the two Selection Bars. More information on using the Selection Bars is available in the Graph Navigation section.

Exporting RAD7 Data Files

The RAD7 Data File submenu command exports a R7CDT or R7RAW Data File containing only the data that is selected on the graph. The exported file will contain only valid data, and will therefore not produce any fatal error messages when opened for graphing. Choosing the RAD7 Data File option will present a Save As dialog box, in which the name and location of the exported file may be specified, as well as the file type.

Two file type options may be offered: "RAD7 Data File (With Supplemental Data)", and "RAD7 Data File (Without Supplemental Data)". The first option produces a R7CDT file which contains not only the radon data, but also information about the RAD7 from which the data came, as well as information on thoron concentrations and record run numbers. The second option produces a simpler R7RAW file, which contains only radon data. Such files adhere to the format seen when downloading data using the RAD7's "Data Com" or "Special ComAll" commands. This format is fully documented in the RAD7 manual, and may be preferable if the output is intended for use with third party applications or custom tools. Note that if the original data set does not contain information on the RAD7 from which it came, the option to include supplemental data will not be offered and the result will be a R7RAW file. More information on the R7RAW and R7CDT file formats is available in the File Formats section.

Exporting Column Based Text

The Export Selected Data command produces a submenu containing two related commands: Column Based Text File, and Column Based Text to Clipboard. These submenu commands produce textual data in a format suitable for importing into Microsoft Excel and other spreadsheet applications. The Column Based Text File command saves the data to a plain text file with the .txt file name extension, while the Column Based Text to Clipboard command simply puts it on the clipboard, making it possible to paste it into another program.

Both of these operations bring up the Column Based Text Window, which is shown in Figure 2, below. This window is used for specifying the desired fields for inclusion in the exported data. Each included field is exported as a separate column of tab- or comma-delimited text. The details of this window are explained below.

The RAD7 Fields section at the top of the Column Based Text dialog contains checkboxes representing the original 23 fields comprising each RAD7 data record. Below, the Derived Fields section contains additional checkboxes representing properties generated by CAPTURE. Note that any corresponding uncertainty values indicate statistical uncertainty; these values do not indicate the absolute uncertainty of the RAD7.

After selecting the desired data fields, use the checkboxes in the section of the window labeled Configuration to specify whether Forced SNIFF Mode, Humidity Correction, and/or B to A Spill Correction are applied to any derived data that is being exported.

Finally, use the Delineation pop-up menu to specify whether the columns of text will be separated by commas or tab characters. The appropriate choice here will depend on the requirements of the program in which the exported data will be viewed or processed. Selecting Tab Character here will produce a plain text file with a .txt file name extension. The Comma Character option produces a plain text file with a .csv file name extension. Files with the .csv extension can be directly opened in Microsoft Excel.

Once the desired selections have been made, click the OK button. If a column-based text file is being produced, the Save As dialog box will appear, where the name and location may be chosen for the resulting file. Note that although this data can be imported into a spreadsheet application or opened in a word processing application, the data will not be able to be imported into CAPTURE.

Exporting RAD7 Printer Data

The Export Printer Data command saves a textual Printer Data file, containing the supplementary printer data associated with each RAD7 record. This information is not available for all data sets. Choosing this option will present a Save As dialog box, in which the name and location of the exported file may be specified.

When RAD7 Data is visible in a graph window, it is possible to create several different kinds of reports using submenu under the File Menu's Create Report command. The report options are described below.

Figure 3: Create Report options in the File menu.

Creating a Data Summary Report

The Data Summary Report command creates a textual Data Summary file, containing basic information about the selected records and the RAD7 used to record them. Choosing this option and clicking Next will present a Save As dialog box, in which the name and location of the exported file may be specified. A sample Data Summary file is shown in Figure 4, below.

Creating a Run Summaries Report

The Run Summaries Report command creates a textual Run Summaries file, containing information on each run, as shown in Figure 5. Choosing this option will present the Run Summaries dialog box, as shown in Figure 6. This is used to specify the types of data included in the Run Summaries file, the type(s) of correction applied to the data, and the formatting of the columns in the file. Each of these parameters is explained below.

The Data Source pop-up menu is used to specify the source of the concentration averages included in the Run Summaries file. This may be set to either Radon in Air or Radon in Water.

The Concentration Units pop-up menu is used to specify the unit of the concentration averages in the file. This may be set to Bq/L, Bq/m³, dpm/L, or pCi/L.

The Include Thoron Data checkbox controls whether the Run Summaries file will contain columns listing thoron concentration averages, in addition to radon concentration averages for each run.

The Starting Cycle pop-up menu is used to specify the first cycle from each run that is included in calculated averages. For example, if this menu is set to 3, then the reported concentration average for a run containing ten cycles would be calculated based on runs 3 through 10. Note that runs recorded in WAT mode or GRAB protocol are exempt from this rule.

The Apply Humidity Correction, Apply Forced SNIFF Mode, and Apply BA Spill Correction checkboxes determine which correction(s) are applied to the concentration averages reported in the Run Summaries file. Similar controls are found in the Graph Controls panel, and more information about corrections can be found in the Graph Controls Panel section.

The Format Document For pop-up menu has two options, Print and Spreadsheet. If Print is selected, the document will be laid out in an easy to read format, as shown in Figure 5, above. The Spreadsheet option produces a file that is not as easily readable, but better suited for data analysis applications. If this option is selected, the Delineation pop-up menu appears, making it possible to specify whether the document's columns will be separated by commas or tab characters.

Creating a Radon Inspection Report

The Radon Inspection Report command produces an HTML-based radon inspection report. The report includes a data summary, a high resolution graph image, and a table containing complete experimental results. The graph image is embedded inside the HTML document, making it a single portable file that can be viewed in any web browser.

Choosing the Export Radon Inspection Report command brings up the window pictured below. This window is used to specify the report parameters, including the name and address of the radon testing firm, the details of the property being tested, which data records are included in the report, and whether the Action Level is represented on the graph. If the Show Action Level Line checkbox is checked, a red line will be drawn horizontally across the graph indicating the radon concentration threshold at which a mitigation system is recommended.

Other parameters, such as whether the temperature and humidity graph lines are visible, the thickness of the graph lines, and the radon concentration unit used on the graph, are based on the configuration of the associated graph window.

Once the necessary information has been entered, click the Next... button and specify a name and location for the report. After the report has been generated, it will automatically open in a web browser window. From there it may be printed or exported as a PDF (provided the browser's Print command facilitates printing documents to the PDF format).

When a Graph Window is visible, the radon graph can be printed at high resolution. CAPTURE's print commands are located in the File menu. The Print command prints the current radon graph. On some systems, the Print dialog box may also be used to save, fax, or email a cross-platform PDF version of the graph image. The keyboard shortcut for this operation is Control-P on Windows, and Command-P on macOS.

The Image Output panel in the Preferences Window may be used to specify whether the selected region appears on the printout, and whether statistics will be included on the printout.

The File Menu's Page Setup command is used to configure the page orientation and other print settings. The Portrait orientation option places the graph on the top of the page, with graph statistics optionally appearing below the graph image. The Landscape orientation option rotates the graph image, allowing it to fill the entire sheet. When the Landscape option is selected, graph statistics are displayed on a second page. Use the keyboard shortcut Control-Shift-P (Windows) or Command-Shift-P (macOS) to bring up the Page Setup dialog.