Spreadsheet Example VCSB 10 ppm Gasoline Sulfur Precision Demonstration [PBMS0008:OMB #2060-0731: Expires 1/31/2024]. This collection of information is approved by OMB under the Paperwork Reduction Act, 44 U.S.C. 3501 et seq. OMB Control No 2060-0731. Responses to this collection of information are voluntary 1090 CFR 1360 through 1090 1365. An agency may not conduct or sponsor, and a person is not required to respond to, a collection of information unless it displays a currently valid OMB control number. The public reporting and recordkeeping burden for this collection of information is estimated to average 180 hours per response. Send comments on the Agency’s need for this information, the accuracy of the provided burden estimates and any suggested methods for minimizing respondent burden to the Regulatory Support Division Director, U.S. Environmental Protection Agency (2821T), 1200 Pennsylvania Ave., NW, Washington, D.C. 20460. Include the OMB control number in any correspondence. Do not send the completed form to this address. |
|
|
Test Method |
|
|
Name of Method: |
|
|
|
Laboratory Identification |
|
|
Laboratory Name: |
|
|
|
Laboratory Street Address: |
|
|
|
Laboratory City: |
|
|
|
Laboratory State: |
|
|
|
Laboratory Zip code: |
|
|
|
Laboratory Contact Person: |
|
|
|
Laboratory Contact Phone Number |
|
|
|
Laboratory Contact Facsimile Number |
|
|
|
Laboratory Contact E-mail Address |
|
|
|
10 ppm Sulfur Precision Criterion (§1090.1365(b)) - The maximum allowable standard deviation computed from results of a minimum of 20 tests made over 20 days (You may make up to 4 separate measurements in a 24-hour period, as long as the interval between measurements is at least 4 hours.) on samples using good laboratory practices taken from a single homogenous commercially available gasoline must be less than or equal to 1.5 times the repeatability (r) divided by 2.77, where "r" equalts the ASTM repeatability of ASTM D7039-15a(R2020). Example: A 10ppm sulfur gasoline sample: maximum allowable standard deviation of 20 tests less than or equal 1.5*(1.73 ppm/2.77)=0.94ppm. |
|
|
Is 10 ppm Sulfur Precision Criterion Met? |
REQUIRED DATA MISSING |
|
|
0.938442659870986 |
Standard Deviation |
REQUIRED DATA MISSING |
|
|
|
Laboratory Test Identification Number |
Date |
Time |
Test Result (ppm) |
Data Entry QC Check on Test Result |
|
|
|
|
|
|
DATA REQUIRED IN CELL D18 |
|
|
|
|
|
|
DATA REQUIRED IN CELL D19 |
|
|
|
|
|
|
DATA REQUIRED IN CELL D20 |
|
|
|
|
|
|
DATA REQUIRED IN CELL D21 |
|
|
|
|
|
|
DATA REQUIRED IN CELL D22 |
|
|
|
|
|
|
DATA REQUIRED IN CELL D23 |
|
|
|
|
|
|
DATA REQUIRED IN CELL D24 |
|
|
|
|
|
|
DATA REQUIRED IN CELL D25 |
|
|
|
|
|
|
DATA REQUIRED IN CELL D26 |
|
|
|
|
|
|
DATA REQUIRED IN CELL D27 |
|
|
|
|
|
|
DATA REQUIRED IN CELL D28 |
|
|
|
|
|
|
DATA REQUIRED IN CELL D29 |
|
|
|
|
|
|
DATA REQUIRED IN CELL D30 |
|
|
|
|
|
|
DATA REQUIRED IN CELL D31 |
|
|
|
|
|
|
DATA REQUIRED IN CELL D32 |
|
|
|
|
|
|
DATA REQUIRED IN CELL D33 |
|
|
|
|
|
|
DATA REQUIRED IN CELL D34 |
|
|
|
|
|
|
DATA REQUIRED IN CELL D35 |
|
|
|
|
|
|
DATA REQUIRED IN CELL D36 |
|
|
|
|
|
|
DATA REQUIRED IN CELL D37 |
|
|
Spreadsheet Example VCSB 10 ppm Gasoline Sulfur Accuracy Demonstration [PBMS0008:OMB #2060-0731, EPA ICR number 2607.02: Expires 1/31/2024] |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Test Method |
|
|
|
|
|
|
|
|
|
Name of Method: |
0 |
|
|
|
|
|
|
|
|
|
Laboratory Identification |
|
|
|
|
|
|
|
|
|
Laboratory Name: |
0 |
|
|
|
|
|
|
|
|
|
Laboratory Street Address: |
0 |
|
|
|
|
|
|
|
|
|
Laboratory City: |
0 |
|
|
|
|
|
|
|
|
|
Laboratory State: |
0 |
|
|
|
|
|
|
|
|
|
Laboratory Zip code: |
0 |
|
|
|
|
|
|
|
|
|
Laboratory Contact Person: |
0 |
|
|
|
|
|
|
|
|
|
Laboratory Contact Phone Number |
0 |
|
|
|
|
|
|
|
|
|
Laboratory Contact Facsimile Number |
0 |
|
|
|
|
|
|
|
|
|
Laboratory Contact E-mail Address |
0 |
|
|
|
|
|
|
|
|
|
1 to 10 ppm Accuracy Criterion (§1090.1365(c)(3)(i)) - the arithmetic average of a continuous series of at least 10 tests performed on a commercially available gravimetric sulfur standard in the range of 1 to 10 ppm sulfur, say 10 ppm., shall not differ from the accepted reference value (ARV) of that standard by more than 0.70 ppm. Individual test results shall be compensated for any known chemical interferences. You may omit any of these ranges if you do not perform testing with fuel in that range. |
|
|
10 to 20 ppm Accuracy Criterion (§1090.1365(c)(3)(i) - the arithmetic average of a continuous series of at least 10 tests performed on a commercially available gravimetric sulfur standard in the range of 10 to 20 ppm, say 20 ppm. sulfur shall not differ from the accepted reference value (ARV) of that standard by more than 1.02 ppm. Individual test results shall be compensated for any known chemical interferences. You may omit any of these ranges if you do not perform testing with fuel in that range. |
|
21 to 95 ppm Accuracy Criterion (§1090.1365(c)(3)(i) - the arithmetic average of a continuous series of at least 10 tests performed on a commercially available gravimetric sulfur standard in the range of 21 to 95 ppm, say 80 ppm. sulfur shall not differ from the accepted reference value (ARV) of that standard by more than 2.16 ppm. Individual test results shall be compensated for any known chemical interferences. You may omit any of these ranges if you do not perform testing with fuel in that range. |
Accuracy Criterion for 1-10 ppm |
|
|
|
Accuracy Criterion for 10-20 ppm |
|
|
Accuracy Criterion for 21-95 ppm |
|
gravimetric sulfur standard |
|
|
|
gravimetric sulfur standard |
|
|
gravimetric sulfur standard |
|
Is 1-10 ppm Sulfur Accuracy Criterion Met? |
REQUIRED DATA MISSING |
|
|
|
Is 10-20 ppm Sulfur Accuracy Criterion Met? |
REQUIRED DATA MISSING |
|
|
Is 10-20 ppm Sulfur Accuracy Criterion Met? |
REQUIRED DATA MISSING |
|
Arithmetic Average (ppm) |
REQUIRED DATA MISSING |
|
|
|
Arithmetic Average (ppm) |
REQUIRED DATA MISSING |
|
|
Arithmetic Average (ppm) |
REQUIRED DATA MISSING |
|
Vendor Name of Gravimetric Standard |
|
|
|
|
Vendor Name of Gravimetric Standard |
|
|
|
Vendor Name of Gravimetric Standard |
|
|
Lot Identification Number of Gravimetric Standard |
|
Concentration QC Check on ARV |
|
|
Lot Identification Number of Gravimetric Standard |
|
Concentration QC Check on ARV |
|
Lot Identification Number of Gravimetric Standard |
|
Concentration QC Check on ARV |
Accepted Reference Value (ARV) of Gravimetric Standard (ppm) |
|
ARV TOO LOW IN CONCENTRATION |
|
|
Accepted Reference Value (ARV) of Gravimetric Standard (ppm) |
|
ARV TOO LOW IN CONCENTRATION |
|
Accepted Reference Value (ARV) of Gravimetric Standard (ppm) |
|
ARV TOO LOW IN CONCENTRATION |
Difference between Arithmetic Average and ARV of Gravimetric Standard |
REQUIRED DATA MISSING |
|
|
|
Difference between Arithmetic Average and ARV of Gravimetric Standard |
REQUIRED DATA MISSING |
|
|
Difference between Arithmetic Average and ARV of Gravimetric Standard |
REQUIRED DATA MISSING |
|
Laboratory Test Identification Number |
Date |
Time |
Test Result (ppm) |
Data Entry QC Check on Test Result |
|
|
Laboratory Test Identification Number |
Date |
Time |
Test Result (ppm) |
Data Entry QC Check on Test Result |
|
Laboratory Test Identification Number |
Date |
Time |
Test Result (ppm) |
Data Entry QC Check on Test Result |
|
|
|
|
DATA REQUIRED IN CELL D26 |
|
|
|
|
|
|
DATA REQUIRED IN CELL J26 |
|
|
|
|
|
DATA REQUIRED IN CELL J26 |
|
|
|
|
DATA REQUIRED IN CELL D27 |
|
|
|
|
|
|
DATA REQUIRED IN CELL J27 |
|
|
|
|
|
DATA REQUIRED IN CELL J27 |
|
|
|
|
DATA REQUIRED IN CELL D28 |
|
|
|
|
|
|
DATA REQUIRED IN CELL J28 |
|
|
|
|
|
DATA REQUIRED IN CELL J28 |
|
|
|
|
DATA REQUIRED IN CELL D29 |
|
|
|
|
|
|
DATA REQUIRED IN CELL J29 |
|
|
|
|
|
DATA REQUIRED IN CELL J29 |
|
|
|
|
DATA REQUIRED IN CELL D30 |
|
|
|
|
|
|
DATA REQUIRED IN CELL J30 |
|
|
|
|
|
DATA REQUIRED IN CELL J30 |
|
|
|
|
DATA REQUIRED IN CELL D31 |
|
|
|
|
|
|
DATA REQUIRED IN CELL J31 |
|
|
|
|
|
DATA REQUIRED IN CELL J31 |
|
|
|
|
DATA REQUIRED IN CELL D32 |
|
|
|
|
|
|
DATA REQUIRED IN CELL J32 |
|
|
|
|
|
DATA REQUIRED IN CELL J32 |
|
|
|
|
DATA REQUIRED IN CELL D33 |
|
|
|
|
|
|
DATA REQUIRED IN CELL J33 |
|
|
|
|
|
DATA REQUIRED IN CELL J33 |
|
|
|
|
DATA REQUIRED IN CELL D34 |
|
|
|
|
|
|
DATA REQUIRED IN CELL J34 |
|
|
|
|
|
DATA REQUIRED IN CELL J34 |
|
|
|
|
DATA REQUIRED IN CELL D35 |
|
|
|
|
|
|
DATA REQUIRED IN CELL J35 |
|
|
|
|
|
DATA REQUIRED IN CELL J35 |
Spreadsheet Example VCSB 10 ppm Gasoline Sulfur Precision Demonstration [PBMS0008:OMB #2060-0731, EPA ICR number 2607.02: Expires 1/31/2024] |
Test Method |
Name of Method: |
Total Sulfur in Liquid Aromatic Hydrocarbons and Their Derivatives by XRF |
Laboratory Identification |
Laboratory Name: |
USEPA National and Vehicle Fuels Emissions Laboratory/OAR |
Laboratory Street Address: |
2565 Plymouth Road, Mailcode AATSG |
Laboratory City: |
Ann Arbor |
Laboratory State: |
Michigan |
Laboratory Zip code: |
48105 |
Laboratory Contact Person: |
John Doe |
Laboratory Contact Phone Number |
xxx-xxx-xxxx |
Laboratory Contact Facsimile Number |
xxx-xxx-xxxx |
Laboratory Contact E-mail Address |
[email protected] |
10 ppm Sulfur Precision Criterion (§1090.1365(b)) - The maximum allowable standard deviation computed from results of a minimum of 20 tests made over 20 days (7 or fewer tests per week and 2 or fewer tests per day) on samples using good laboratory practices taken from a single homogenous commercially available gasoline must be less than or equal to 1.5 times the repeatability (r) divided by 2.77, where "r" equalts the ASTM repeatability of ASTM D7039-13. Example: A 10ppm sulfur gasoline sample: maximum allowable standard deviation of 20 tests less than or equal 1.5*(1.73 ppm/2.77)=0.94ppm. §1090.1350(a)(2), §1090.1360(a)(2) & §1090.1365(b)(3) Table 1. |
Is 10 ppm Sulfur Precision Criterion Met? |
PASSED |
|
standard deviation |
0.04 |
|
Laboratory Test Identification Number |
Date |
Time |
Test Result (ppm) |
Data Entry QC Check on Test Result |
######### |
3/26/2021 |
8:00 AM |
6.003 |
OK |
######### |
3/29/2021 |
8:01 AM |
6.021 |
OK |
######### |
3/30/2021 |
8:20 AM |
6.043 |
OK |
######### |
3/31/2021 |
8:23 AM |
5.993 |
OK |
######### |
4/1/2021 |
8:00 AM |
6.003 |
OK |
######### |
4/2/2021 |
8:00 AM |
6.092 |
OK |
######### |
4/3/2021 |
8:20 AM |
6.101 |
OK |
######### |
4/4/2021 |
8:20 AM |
6.045 |
OK |
######### |
4/5/2021 |
8:00 AM |
6.003 |
OK |
######### |
4/8/2021 |
8:01 AM |
6.021 |
OK |
######### |
4/9/2021 |
8:20 AM |
5.989 |
OK |
######### |
4/10/2021 |
8:00 AM |
5.962 |
OK |
######### |
4/11/2021 |
8:00 AM |
6.010 |
OK |
######### |
4/12/2021 |
8:01 AM |
6.032 |
OK |
######### |
4/15/2021 |
8:20 AM |
6.053 |
OK |
######### |
4/16/2021 |
8:01 AM |
6.050 |
OK |
######### |
4/17/2021 |
8:00 AM |
5.989 |
OK |
######### |
4/18/2021 |
8:00 AM |
6.033 |
OK |
######### |
4/19/2021 |
8:01 AM |
5.939 |
OK |
######### |
4/22/2021 |
8:20 AM |
6.042 |
OK |
Spreadsheet Example VCSB 10 ppm Gasoline Sulfur Accuracy Demonstration [PBMS0008:OMB #2060-0731, EPA ICR number 2607.02: Expires 1/31/2024] |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Test Method |
|
|
|
|
|
|
|
|
|
Name of Method: |
Total Sulfur in Liquid Aromatic Hydrocarbons and Their Derivatives by XRF |
|
|
|
|
|
|
|
|
|
|
Laboratory Identification |
|
|
|
|
|
|
|
|
|
Laboratory Name: |
USEPA National and Vehicle Fuels Emissions Laboratory/OAR |
|
|
|
|
|
|
|
|
|
Laboratory Street Address: |
2565 Plymouth Road, Mailcode AATSG |
|
|
|
|
|
|
|
|
|
Laboratory City: |
Ann Arbor |
|
|
|
|
|
|
|
|
|
Laboratory State: |
Michigan |
|
|
|
|
|
|
|
|
|
Laboratory Zip code: |
48105 |
|
|
|
|
|
|
|
|
|
Laboratory Contact Person: |
John Doe |
|
|
|
|
|
|
|
|
|
Laboratory Contact Phone Number |
xxx-xxx-xxxx |
|
|
|
|
|
|
|
|
|
Laboratory Contact Facsimile Number |
xxx-xxx-xxxx |
|
|
|
|
|
|
|
|
|
Laboratory Contact E-mail Address |
[email protected] |
|
|
|
|
|
|
|
|
|
1 to 10 ppm Accuracy Criterion (§1090.1365(c)(3)(i)) - the arithmetic average of a continuous series of at least 10 tests performed on a commercially available gravimetric sulfur standard in the range of 1 to 10 ppm sulfur, say 10 ppm., shall not differ from the accepted reference value (ARV) of that standard by more than 0.70 ppm. Individual test results shall be compensated for any known chemical interferences. You may omit any of these ranges if you do not perform testing with fuel in that range. |
|
|
10 to 20 ppm Accuracy Criterion (§1090.1365(c)(3)(i)) - the arithmetic average of a continuous series of at least 10 tests performed on a commercially available gravimetric sulfur standard in the range of 10 to 20 ppm, say 20 ppm. sulfur shall not differ from the accepted reference value (ARV) of that standard by more than 1.02 ppm. Individual test results shall be compensated for any known chemical interferences. You may omit any of these ranges if you do not perform testing with fuel in that range. |
|
21 to 95 ppm Accuracy Criterion (§1090.1365(c)(3)(i)) - the arithmetic average of a continuous series of at least 10 tests performed on a commercially available gravimetric sulfur standard in the range of 21 to 95 ppm, say 80 ppm. sulfur shall not differ from the accepted reference value (ARV) of that standard by more than 2.16 ppm. Individual test results shall be compensated for any known chemical interferences. You may omit any of these ranges if you do not perform testing with fuel in that range. |
Accuracy Criterion for 1-10 ppm |
|
|
|
Accuracy Criterion for 10-20 ppm |
|
|
Accuracy Criterion for 21-95 ppm |
|
gravimetric sulfur standard |
|
|
|
gravimetric sulfur standard |
|
|
gravimetric sulfur standard |
|
Is 1-10 ppm Sulfur Accuracy Criterion Met? |
PASSED |
|
|
|
Is 10-20 ppm Sulfur Accuracy Criterion Met? |
PASSED |
|
|
Is 21-95 ppm Sulfur Accuracy Criterion Met? |
PASSED |
|
Arithmetic Average (ppm) |
7.95 |
|
|
|
Arithmetic Average (ppm) |
13.91 |
|
|
Arithmetic Average (ppm) |
79.99 |
|
Vendor Name of Gravimetric Standard |
NIST |
|
|
|
Vendor Name of Gravimetric Standard |
NIST |
|
|
Vendor Name of Gravimetric Standard |
NIST |
|
Lot Identification Number of Gravimetric Standard |
ALDS45680 |
Concentration QC Check on ARV |
|
|
Lot Identification Number of Gravimetric Standard |
ALDS53481 |
Concentration QC Check on ARV |
|
Lot Identification Number of Gravimetric Standard |
ALDS53481 |
Concentration QC Check on ARV |
Accepted Reference Value (ARV) of Gravimetric Standard (ppm) |
8.00 |
OK |
|
|
Accepted Reference Value (ARV) of Gravimetric Standard (ppm) |
13.50 |
OK |
|
Accepted Reference Value (ARV) of Gravimetric Standard (ppm) |
80.00 |
OK |
Difference between Arithmetic Average and ARV of Gravimetric Standard |
0.0515 |
|
|
|
Difference between Arithmetic Average and ARV of Gravimetric Standard |
0.407499999999999 |
|
|
Difference between Arithmetic Average and ARV of Gravimetric Standard |
0.014199999999988 |
|
Laboratory Test Identification Number |
Date |
Time |
Test Result (ppm) |
Data Entry QC Check on Test Result |
|
|
Laboratory Test Identification Number |
Date |
Time |
Test Result (ppm) |
Data Entry QC Check on Test Result |
|
Laboratory Test Identification Number |
Date |
Time |
Test Result (ppm) |
Data Entry QC Check on Test Result |
######### |
4/23/2021 |
8:00 AM |
7.341 |
OK |
|
|
######### |
4/26/2021 |
8:00 AM |
13.239 |
OK |
|
######### |
4/27/2021 |
8:00 AM |
81.123 |
OK |
######### |
4/23/2021 |
8:05 AM |
7.562 |
OK |
|
|
######### |
4/26/2021 |
8:05 AM |
14.231 |
OK |
|
######### |
4/27/2021 |
8:05 AM |
80.000 |
OK |
######### |
4/23/2021 |
8:10 AM |
7.894 |
OK |
|
|
######### |
4/26/2021 |
8:10 AM |
13.899 |
OK |
|
######### |
4/27/2021 |
8:10 AM |
80.000 |
OK |
######### |
4/23/2021 |
8:15 AM |
8.219 |
OK |
|
|
######### |
4/26/2021 |
8:15 AM |
14.035 |
OK |
|
######### |
4/27/2021 |
8:15 AM |
79.567 |
OK |
######### |
4/23/2021 |
8:20 AM |
8.234 |
OK |
|
|
######### |
4/26/2021 |
8:20 AM |
14.001 |
OK |
|
######### |
4/27/2021 |
8:20 AM |
80.567 |
OK |
######### |
4/23/2021 |
8:25 AM |
8.100 |
OK |
|
|
######### |
4/26/2021 |
8:25 AM |
13.980 |
OK |
|
######### |
4/27/2021 |
8:25 AM |
81.000 |
OK |
######### |
4/23/2021 |
8:30 AM |
8.114 |
OK |
|
|
######### |
4/26/2021 |
8:30 AM |
13.211 |
OK |
|
######### |
4/27/2021 |
8:30 AM |
79.000 |
OK |
######### |
4/23/2021 |
8:35 AM |
7.989 |
OK |
|
|
######### |
4/26/2021 |
8:35 AM |
14.345 |
OK |
|
######### |
4/27/2021 |
8:35 AM |
78.567 |
OK |
######### |
4/23/2021 |
8:40 AM |
7.687 |
OK |
|
|
######### |
4/26/2021 |
8:40 AM |
13.678 |
OK |
|
######### |
4/27/2021 |
8:40 AM |
80.034 |
OK |
######### |
4/23/2021 |
8:45am |
8.345 |
OK |
|
|
######### |
4/26/2021 |
8:45am |
14.456 |
OK |
|
######### |
4/27/2021 |
8:45am |
80.000 |
OK |