Both nominal concentration- and on-column-mass-based APH Analytical Method Calculation Worksheets utilizing the analytical information presented in Final Method for the Determination of Air- phase Petroleum Hydrocarbons (APH) Appendix 5, Tables 8 - 11 have been developed using a Microsoft Office Excel platform.  These worksheets are intended to be used by laboratories for individual sample calculations or to "proof" Laboratory Information Management System (LIMS) calculations for range and target analyte concentrations using the APH Method.

A. Nominal Concentration-Based Calculation Worksheet xls format of APH Analytical Method Calculation Worksheets

This Worksheet provides (1) an example nominal concentration based RRF calculations for APH aliphatic and aromatic ranges and the target analytes based on multi-point calibration data and (2) example calculations of sample concentrations for APH aliphatic and aromatic ranges and the target analytes based on the calculated RRFs, simulated area counts and other sample-specific data. The relevant analytical data for the target analytes are extracted from Table 6-8 of the aforementioned Appendix 5.

Note: Some minor differences in calculated values as compared to Appendix 5 may be observed due to the Microsoft Excel calculation algorithms.

B. On-Column Mass-Based Calculation Worksheet xls format of APH On-Column Mass-Based Calculation Worksheet

This Worksheet provides (1) an example on-column-mass-based RRF calculations for APH aliphatic and aromatic ranges and the target analytes based on multi-point calibration data and (2) example calculations of sample concentrations for APH aliphatic and aromatic ranges and the target analytes based on the calculated RRFs, simulated area counts and other sample-specific data. The relevant analytical data for the target analytes are extracted from Table 6-8 of the aforementioned Appendix 5.

Note: Some minor differences in calculated values as compared to Appendix 5 may be observed due to the Microsoft Excel calculation algorithms.