58
Quantitative Data Analysis
Advanced User Guide
Release Date: March 2012
Analyst
®
1.6.1 Software
81 of 94
Customize Reports
The Report Template Editor provides a way to customize reports by setting up headers, footers,
and page layouts. Use report templates with both printed output and data exported to another
application.
Printed output includes several types of elements.
•
Window: Windows in the Analyst software appear in the working area of the
software window, below the toolbar and to the right of the Navigation bar. Printing a
window will print everything that is shown in that space.
•
Pane: Panes are parts of a window arranged in such a way that they do not overlap
and are always fully visible. For example, the Method Editor window contains two
panes: the Browser pane and the Method Editor pane. Information from each pane in
the window can be printed.
•
Report: Reports are structured sets of information created in the software. Some
reports can be directly printed, such as calibration reports; other information must be
exported, such as batches and quantitation Results Tables.
•
Workspace: A workspace is a particular arrangement of windows and panes along
with an associated file or files. Printing a workspace involves printing each open
window and pane in the current mode.
Preview, Print, and Export Reports
Acquisition methods, batches, quantitation Results Tables, and graph Results Tables can be
exported as reports. Other forms of information, such as calculator data, can be exported but
cannot be customized with a report template.
Most areas seen on the screen can be printed. Graphs can be previewed, scaled, or copied
using the Print Preview feature.
An exported report is saved in a file format that is appropriate for programs such as Notepad,
Microsoft Word or Excel, or certain LIMS (Laboratory Information Management System)
software.
Export reports in the following formats:
•
.csv
•
.doc
•
.pdf
•
.txt
The formats available depend on the information being exported. For example, a graph can be
exported as a .pdf; a table of data can be exported as a .txt file.
To include additional information in the header and footer of the report, print the report using an
appropriate template.
Table 6-11 Previewing, Printing, and Exporting Reports
To do this...
...do this
Preview a graph
1. Click File > Print Preview > Pane.
2. Edit the Print Preview dialog.
3. Click Print.
53
Quantitative Data Analysis
Analyst
®
1.6.1 Software
82 of 94
Advanced User Guide
Release Date: March 2012
Results Tables
Results Tables summarize the calculated concentration of analyte in each unknown sample
based on the calibration curve. They also include the calibration curves and statistics for the
results.
Export the data from a Results Table to a .txt file for use in other applications, such as Microsoft
Excel. All possible data in the table or just the data in the visible columns can be exported.
The data in a Results Table can be sorted in three different ways:
•
Quickly sort the table on one to three columns, using one of the Sort buttons. This
sort criteria cannot be saved.
•
Create a table-specific sort to save the sort criteria with the current table. Table-
specific sorts enable sorting the current table on one to three columns and saving
the criterion for use with that table.
•
Use a previously created preset sort. Create and save a sort and later apply it to a
Results Table.
Define the Layout of Results Tables
Four predefined views of the Results Table are available.
•
Right-click in the Results Table and then click one of the following:
• To view the Full layout, click Full.
All the analytes are displayed.
• To view the Summary layout, click Summary and then click a field name.
Print a report without a
template
Click File > Print, and then click the report.
Print a report with a template 1. Click File > Print & Report Setup.
2. In the Report Template section, select the template.
3. Click OK.
Export a report
1. Click File > Export.
2. In the File field, type the name of the file.
3. In the Save as type list, select the appropriate file type.
4. If exporting a report in Quantitate mode, select either All
Columns or Visible Columns from the Export section and
then click Save.
Tip! To save a sort or any other table setting, right-click in the table and
then click Table Settings > Export To New Table Settings. The sort and
other parameters can be used in the current project. To use the table
settings in a different project, copy it to another project. Click Tools >
Project > Copy Data. A new project must be created and selected to be
available for use.
Table 6-11 Previewing, Printing, and Exporting Reports (Continued)
To do this...
...do this
24
Quantitative Data Analysis
Advanced User Guide
Release Date: March 2012
Analyst
®
1.6.1 Software
83 of 94
• To view the Analyte layout, click Analyte and then click a single analyte if
more than one analyte exists.
• To view the Analyte Group layout, click Analyte Group and then click an
analyte group.
The table opens with the selected layout.
Sort Data in Results Tables
1. Select up to three columns in the Results Table in the order they need to be sorted.
2. Do one of the following:
• To sort in ascending order, click A-Z.
• To sort in descending order, click Z-A.
Sort a Results Table and Save the Sort Criteria
1. Right-click in the Results Table and then click Sort > New.
Figure 6-12 Sort dialog
2. In the Name field, type the name for the new sort.
Tip! A new analyte group must be created first. To do this, right-click in
the Results Table and then click Analyte Group > New.
Tip! To go back to the full view, right-click and click Full.
22
Quantitative Data Analysis
Analyst
®
1.6.1 Software
84 of 94
Advanced User Guide
Release Date: March 2012
3. For each sorting rule to be set, in the Sort By section, do the following:
i. In the Group list, select the type of column.
ii. In the Column list, select the column.
iii. Select the direction of the sort: Ascending or Descending.
4. Do one of the following:
• To perform the sort, save the sort criteria, and close the Sort dialog, click
Save/Execute.
• To perform the sort and close the Sort dialog without saving the sort criteria,
click Execute.
Save Default Sort Criteria for Future Results Tables
1. Click Tools > Settings > New Quantitation Results Table Settings.
Figure 6-13 Table Settings dialog
2. Expand the Table Settings folder and then double-click the Default folder.
3. From the expanded Default folder, select the Sorts folder.
4. Click New.
27
Quantitative Data Analysis
Advanced User Guide
Release Date: March 2012
Analyst
®
1.6.1 Software
85 of 94
Figure 6-14 Sort dialog
5. In the Name field, type a name.
6. For each sorting rule to be set, in the Sort By section, do the following:
i. In the Group list, select the type of column.
ii. In the Column list, select the column.
iii. Select the direction of the sort: Ascending or Descending.
7. To save the criteria and close the Sort dialog, click OK.
8. Click Done.
Sort a Results Table using Preset Sort Criteria
•
Right-click in the Results Table, click Sort and then select the name of the sort.
About using Queries with Results Tables
A query is a request for records in a Results Table that the certain conditions set using textual or
mathematical selection criteria. Apply a query either during the process of generating a Results
Table or after one has been generated. These two types of queries are called default and table-
specific queries. For more information, refer to Default Queries and Table-Specific Queries on
page 75.
Compare Results Between Batches
When more than one Results Table is displayed, obtain statistical information about the
standards and QCs for additional batches in the Statistics window. Normally results are
34
Quantitative Data Analysis
Analyst
®
1.6.1 Software
86 of 94
Advanced User Guide
Release Date: March 2012
compared between batches to look for trends in the standards or QCs or to verify that the method
is valid.
For two or more open Results Tables, compare results in the Statistics window. Both sets of
statistics appear in the Statistics window.
How Concentration Levels Affect Results
The concentration is defined for all QCs and standards. If there is a change in the accuracy of the
concentration level by more than the amount defined in the Max. Variation field in the Create
Default Query dialog, then this information is shown in the Results Table.
Results Table Layouts
The software has four predefined views of the Results Table.
•
Full Layout View
•
Summary Layout View
•
Analyte Layout View
•
Analyte Group Layout View
Each analyte from a multiple analytes sample can be seen in the Analyte Layout view. The preset
view is Full layout.
Full Layout View
The preset Full Layout view shows the data for all analytes in the quantitation batch. The
columns that are displayed depend on the columns selected in the Results Table Columns
dialog, and the settings selected on the second page of the Quantitation Method Wizard.
Figure 6-15 Sample Full Layout view
Note: The number of analytes and the number of analyte names must be the same for
the data to be combined in the Statistics window.
21
Quantitative Data Analysis
Advanced User Guide
Release Date: March 2012
Analyst
®
1.6.1 Software
87 of 94
Summary Layout View
The Summary Layout view contains the locked columns and the chosen field for each analyte in
the remaining columns. For example, if Analyte Peak Area is selected from the menu for two
analytes, then the Sample Name and Analyte Peak Area columns for those analyte names are
seen. The Summary Layout view also includes the Formula and Custom columns, if these exist.
Figure 6-16 Sample Summary Layout View
Analyte Layout View
The Analyte Layout view contains the data for a particular analyte; all other analytes are hidden.
For example, if analyte A is selected, all the data for analyte A is seen. The columns that are
displayed depend on the columns selected in the Results Table Columns dialog, and the settings
selected on the second page of the Quantitation Method Wizard.
An Analyte Layout view, with Peak 1 selected, might look like Figure6-17. If this layout is
compared with the Full Layout view, notice that every other row has been excluded.
Figure 6-17 Sample Analyte Layout view
41
Quantitative Data Analysis
Analyst
®
1.6.1 Software
88 of 94
Advanced User Guide
Release Date: March 2012
Analyte Group Layout View
The Analyte Group Layout view contains the data for the analytes that belong to a particular
group. Columns that are selected as shown in the Results Table Columns dialog appear in the
Results Table as shown in Figure6-18. Display the Analyte Peak Name column in the Results
Table to show the names of the analytes that belong in the group.
Figure 6-18 Sample Analyte Group Layout view
Results Table Fields
Add columns to the standard Results Table to display DAD (diode array detector) data for the
Analyte, Internal Standard, and Record fields.
Formula Fields
The Formula fields display the result of a spreadsheet-style formula defined by users. The
Formula field located at the top of the Results Table is shown only if at least one Formula column
is in the Results Table. The Formula field becomes active when Formula column cells are
selected. The Delete Formula Column button below the Formula field also becomes available
when the Formula column is selected.
Custom Fields
Custom fields contain information defined during the acquisition process. When acquiring
samples, users can create custom columns and define the type of data that goes in them. Once
the custom column is part of the Results Table, it can be treated like any other column (for
example, move it, hide it, base a formula on it).
Internal Standards Column Fields
The Internal Standard Results fields display information about the internal standard after
analysis. Table6-12 shows the available fields.
Table 6-12 Internal Standards Column Fields
Field
Definition
IS Peak Name
The name of the internal standard peak.
IS Units
The units in which the internal standard is given.
IS Peak Area
The area of the internal standard peak.
IS Peak Height
The height of the internal standard peak.
68
Quantitative Data Analysis
Advanced User Guide
Release Date: March 2012
Analyst
®
1.6.1 Software
89 of 94
IS Concentration
The known concentration of the internal standard, this
applies to standard and quality control sample types.
Zeroes are displayed for solvent, blank, and double blank
sample types; N/A is displayed for unknowns.
IS Retention Time
The chromatographic retention time as determined by the
software.
IS Expected Retention Time
The retention time of the representative sample. Taken
from the quantitation method.
IS Retention Time Window
The retention time window as specified in the quantitation
method.
IS Centroid Location
The intensity-weighted average retention time for the
analyte. The peak areas up to and after this time are
identified.
IS Start Scan
The cycle number associated with the period/experiment
combination where the peak begins.
IS Start Time
The time associated with the period/experiment
combination where the peak begins.
IS Stop Scan
The cycle number associated with the period/experiment
combination where the peak ends.
IS Stop Time
The time associated with the period/experiment
combination where the peak ends.
IS Integration Type
The method by which the baseline was found and
integrated when the peak was found. The types are:
manual, automatic (Baseline-to-Baseline, Valley,
Exponential Skim, and Exponential Child).
IS Signal to Noise
The signal-to-noise ratio of the peak.
IS Peak Width
The ratio of the peak height to its width.
IS UV Range
The UV range of the internal standard.
IS UV Channel
The UV channel of the internal standard.
IS Peak Width at 50 Percent (min.) A read-only column displaying the peak width at 50% of
peak height.
IS Baseline Slope (%/min.)
A read-only column displaying the slope of the baseline.
IS Peak Asymmetry
A read-only column displaying the peak asymmetry which
is calculated by the following formula:
[(Peak End Time) – (Retention Time)] / [(Retention Time) –
(Peak Start Time)]
Values near 1.0 indicate symmetric peaks, values greater
than 1.0 indicate tailing peaks, and values less than 1.0
indicate fronting peaks.
IS Processing Alg
A read-only column displaying the processing algorithm
used.
Table 6-12 Internal Standards Column Fields (Continued)
Field
Definition
62
Quantitative Data Analysis
Analyst
®
1.6.1 Software
90 of 94
Advanced User Guide
Release Date: March 2012
Record Fields
The Record fields display additional information about each sample record (information that is
applicable only to the analyte, not the internal standard). Table6-13 shows the available fields.
Sample Column Fields
The Analyte Results fields display information about each analyte and internal standard (if one
was used) after analysis. Table6-14 shows the available fields.
IS Integration Quality
The Integration Quality™ Index indicates how well the
peak is integrated. Values closer to 1 indicate well-
integrated peaks and values closer to 0 indicate poorly
integrated peaks.
Table 6-13 Record Fields
Field
Definition
Use Record
Indicates whether this record should be included for calibration.
Applies to standards and QCs. If the check box is cleared, then the
unused standards and QCs are struck out in the Statistics Table.
Record Modified
Indicates whether the quantitation method used for the record was
modified in any way from the original.
Calculated Concentration
The calculated concentration of the analyte as calculated using the
calibration curve.
Relative Retention Time
The ratio of the retention times of the internal standard and the
analyte.
Accuracy
The calculated concentration divided by the known concentration
(as a percentage).
Response Factor
The peak area or height (depending on the regression option)
divided by the analyte concentration.
Table 6-14 Results Tables: Sample Column Fields
Field
Definition
Analyte Peak Name
The name of the analyte.
Analyte Units
The units in which the analyte concentrations are given.
Analyte Peak Area
The area of the analyte.
Analyte Peak Height
The height of the analyte peak.
Analyte Concentration
The actual, known concentration of the analyte, this applies to
standard and quality control sample types. Zeroes are
displayed for solvent, blank, and double blank sample types;
N/A is displayed for unknowns.
Analyte Retention Time
The chromatographic retention time as determined by the
software.
Table 6-12 Internal Standards Column Fields (Continued)
Field
Definition
Documents you may be interested
Documents you may be interested
