| Spreadsheet Example VCSB 10 ppm Sulfur in Butane Precision Demonstration [PBMS0009: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 - The maximum allowable standard deviation computed from results of a minimum of 20 tests made over 20 days 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 D6667-16(Reapproved 2019). Example: A 10ppm sulfur in butane sample: maximum allowable standard deviation of 20 tests less than or equal 1.5*(1.152 ppm/2.77)=0.62383 ppm. 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. |
| Is 10 ppm Sulfur in Butane Precision Criterion Met? |
REQUIRED DATA MISSING |
|
| 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 Sulfur in Butane Accuracy Demonstration [PBMS0009: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 - 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.4678725 ppm, where maximum absolute difference = 0.75*(1.5*(1.152 ppm/2.77)). Individual test results shall be compensated for any known chemical interferences. |
|
|
|
|
| Accuracy Criterion for 1-10 ppm |
|
|
|
|
|
| gravimetric sulfur standard |
|
|
|
|
|
| Is 1-10 ppm Sulfur Accuracy Criterion Met? |
REQUIRED DATA MISSING |
|
|
|
|
|
| Arithmetic Average (ppm) |
REQUIRED DATA MISSING |
|
|
|
|
|
| Vendor Name of Gravimetric Standard |
|
|
|
|
|
|
| Lot Identification Number of Gravimetric Standard |
|
Concentration QC Check on ARV |
|
|
|
|
| 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 |
|
|
|
|
|
| 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 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 |
|
|
|
|
| Spreadsheet Example VCSB 10 ppm Sulfur in Butane Precision Demonstration [PBMS0009: 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 - 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 D6667-16(Reapproved 2019). Example: A 10ppm sulfur in butane sample: maximum allowable standard deviation of 20 tests less than or equal 1.5*(1.15 ppm/2.77)=0.62383 ppm. 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. |
| 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:05 AM |
6.021 |
OK |
| ######### |
3/30/2021 |
8:03 AM |
6.043 |
OK |
| ######### |
3/31/2021 |
8:05 AM |
5.993 |
OK |
| ######### |
4/1/2021 |
8:05 AM |
6.003 |
OK |
| ######### |
4/2/2021 |
8:03 AM |
6.092 |
OK |
| ######### |
4/3/2021 |
8:03 AM |
6.101 |
OK |
| ######### |
4/4/2021 |
8:03 AM |
6.045 |
OK |
| ######### |
4/5/2021 |
8:00 AM |
6.003 |
OK |
| ######### |
4/8/2021 |
8:00 AM |
6.021 |
OK |
| ######### |
4/9/2021 |
8:02 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:00 AM |
6.032 |
OK |
| ######### |
4/15/2021 |
8:15 AM |
6.053 |
OK |
| ######### |
4/16/2021 |
8:00 AM |
6.050 |
OK |
| ######### |
4/17/2021 |
8:07 AM |
5.989 |
OK |
| ######### |
4/18/2021 |
8:00 AM |
6.033 |
OK |
| ######### |
4/19/2021 |
8:00 AM |
5.939 |
OK |
| ######### |
4/22/2021 |
8:20 AM |
6.042 |
OK |
| Spreadsheet Example VCSB 10 ppm Sulfur in Butane Accuracy Demonstration [PBMS0009: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 - 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.4678725 ppm. Individual test results shall be compensated for any known chemical interferences. |
|
|
|
|
| Accuracy Criterion for 1-10 ppm |
|
|
|
|
|
| gravimetric sulfur standard |
|
|
|
|
|
| Is 1-10 ppm Sulfur Accuracy Criterion Met? |
PASSED |
|
|
|
|
|
| Arithmetic Average (ppm) |
7.95 |
|
|
|
|
|
| Vendor Name of Gravimetric Standard |
NIST |
|
|
|
|
|
| Lot Identification Number of Gravimetric Standard |
ALDS45680 |
Concentration QC Check on ARV |
|
|
|
|
| Accepted Reference Value (ARV) of Gravimetric Standard (ppm) |
8.00 |
OK |
|
|
|
|
| Difference between Arithmetic Average and ARV of Gravimetric Standard |
0.0515 |
|
|
|
|
|
| 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/23/2021 |
8:05 AM |
7.562 |
OK |
|
|
|
|
| ######### |
4/23/2021 |
8:10 AM |
7.894 |
OK |
|
|
|
|
| ######### |
4/23/2021 |
8:15 AM |
8.219 |
OK |
|
|
|
|
| ######### |
4/23/2021 |
8:20 AM |
8.234 |
OK |
|
|
|
|
| ######### |
4/23/2021 |
8:25 AM |
8.100 |
OK |
|
|
|
|
| ######### |
4/23/2021 |
8:30 AM |
8.114 |
OK |
|
|
|
|
| ######### |
4/23/2021 |
8:35 AM |
7.989 |
OK |
|
|
|
|
| ######### |
4/23/2021 |
8:40 AM |
7.687 |
OK |
|
|
|
|
| ######### |
4/23/2021 |
8:45am |
8.345 |
OK |
|
|
|
|