PBMS0008 Spreadsheet Example VCSB 10 ppm Gasoline Sulfur Pre

Fuels Regulatory Streamlining (Non-Substantive Change)

draft vcsb-sulfur-gas-test-method-sprdsht-example-5-10-2022.xlsx

Fuels Regulatory Streamlining

OMB: 2060-0731

Document [xlsx]
Download: xlsx | pdf

Overview

10 ppm S Precision
Sulfur ppm Accuracy
EX - 10 ppm S Precision
EX - Sulfur ppm Accuracy


Sheet 1: 10 ppm S Precision

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


Sheet 2: Sulfur ppm Accuracy

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

Sheet 3: EX - 10 ppm S Precision

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

Sheet 4: EX - Sulfur ppm Accuracy

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
File Typeapplication/vnd.openxmlformats-officedocument.spreadsheetml.sheet
File Modified0000-00-00
File Created0000-00-00

© 2024 OMB.report | Privacy Policy