Comparison Sheet Format In Excel 42254

Partial file snippet.

Sheet 1: Blended Instructions

Blended Calculation Spreadsheet Instructions

This spreadsheet is to be used in correlation with the EPA Guidance "Doing Inventory Control Right For Underground Storage Tanks" document. Please refer to www.TexasEnvirohelp.org or call 800.447.2827 for assistance.

You will need to use one calculation spreadsheet per tank at the facility. If the fuel dispensed is a blended fuel, use the Blended calculation spreadsheet for each of the tanks that blend together. If the fuel dispensed from the tank is not blended with another fuel, use the Non-blended calculation spreadsheet.

Analysis of Data

Analysis is the most important part of doing inventory control. Compare Sum of Over/Short (cell H43) to Leak Check value (cell E43). Use the absolute value (disregard the sign) of the Sum for Over/Short comparison.

Failed - Sum for Over/Short value is greater than Leak Check value.
Passed - Leak check value is greater than Sum for Over/Short value.

If failed for two periods in a row then you must report to TCEQ as a suspected release within 24 hours of the second failing comparison. Please see the Suspected Release (RG 475h) module in the PST Super Guide for instruction and further steps for this situation. The Superguide can be found at www.TexasEnviroHelp.org.

Each worksheet represents a 30-day period. On each sheet, there are three tables:

Basic Information

Daily Inventory

30-Day Calculations

Basic Information Table

Identify your facility and the tank here. This table begins in Cell A3 of each period's worksheet.

Cell A5: Facility name

Cell B5: Facility ID number found on PST registration information. This can also be found on your delivery certificate.

Cell C5: Enter the beginning and ending dates that you are the collecting data

Cell D5: Enter the year that you are collecting the data

Cell E5: Enter tank number as it is reported on the PST registration form

Cell F5: Enter the size of the tank (in gallons)

Cell G5: Enter the type of fuel in the tank (ex. Regular or Super)

Cell H5: Enter the percentage of Midgrade that is Regular (ex: 60%). You must know your fuel blend percentage for this part of the spreadsheet to work correctly.

Cell I5: Enter the percentage of Midgrade that is Super (ex: 40%). You must know your fuel blend percentage for this part of the spreadsheet to work correctly.

Daily Inventory Table

Enter your readings here each day. Some cells will be calculated for you. This table begins in Cell A7 of each period's worksheet.

Cells A9-A38: Enter the date for the data

Cells B9-B38: Enter the start stick or ATG reading in gallons for each day of operation

Cells C9-C38: Enter gallons of fuel dispensed for that day.

Cells D9-D38: Enter midgrade gallons of fuel dispensed for that day. This information is from your daily fuel sales.

Cells E9-E38: The worksheet calculates Daily Midgrade Gallons Dispensed % for you. Skip to the next column.

Cells F9-F38: Enter gallons delivered for the tank.

Cells G9-G38: The worksheet calculates the Book Inventory for you. Skip to the next column.

Cells H9-H38: Enter the closing stick or ATG reading for that day in gallons

Cells I9-I38: The worksheet calculates the Daily Over/Short for you. Skip to the next column.

Cells J9-J38: Enter the initials of the person that collected the data.

30-Day Calculations Table

30-day calculations and analysis will start in this table. This table begins in Cell A40 of each period's worksheet.

Cell A42: Enter the water level in the tank (in inches)

Cell B42: Enter the date that the water level data were collected

Cell C42: The worksheet calculates the Sum for Daily Gallons Dispensed for you. Skip to the next column.

Cell D42: The worksheet calculates the Math Check for you. Skip to the next column.

Cell E42: The worksheet calculates the Leak Check for you. Skip to the next column.

Cell F42: Enter the last stick/ATG reading for the period (in gallons)

Cell G42: The worksheet calculates the Sum for Gallons Delivered for you. Skip to the next column.

Cell H42: The worksheet calculates the Sum for Over/Short for you.

All calculations can be found in the EPA Guidance "Doing Inventory Control Right For Underground Storage Tanks".

30-Day Worksheet

Blended 30-Day Worksheet is located on the next tab. You need one worksheet for each tank.

Compare the Leak Check Result in Cell E42 and the absolute value of the Sum for Daily Over/Short in Cell H42.

Answer the question, "Is the Sum for Daily Over/Short greater than the Leak Check result?" If yes for two consecutive months, follow steps to report a suspected release.

Print Instructions

To print these instructions, change page layout to portrait and print.

To print the spreadsheets, change page layout to landscape and click "Fit to one Page".

More information can be found on EPA's website: www.epa.gov/ust

End of Worksheet

Sheet 2: Blended 30-Day Regular

Blended 30-Day Worksheet

Basic Information

Facility Name
Facility ID
30-Day Period
Year
Tank Number
Tank Capacity
Fuel Type
Midgrade % Regular
Midgrade % Super

Regular

Daily Entries for This Period

Date
Initial Stick Reading (Regular Gallons)
Daily Regular Gallons Dispensed
Daily Midgrade Gallons Dispensed
Daily Midgrade Gallons Dispensed % Regular
Regular Gallons Delivered
Book Inventory (Regular Gallons)
Closing Stick Reading (Regular Gallons)
Daily Over or (Short)
Initials

0.00

30-Day Calculations

Water Level Reading
Date of Water Level
Sum for Daily Gallons Dispensed
Math Check
Leak Check
Last Day Stick Reading
Sum for Gallons Delivered
Sum for Daily Over/Short (absolute value)

0
0
130

0
0

Is the Sum for Daily Over/Short greater than the Leak Check result?

Yes
No

End of Worksheet

The words contained in this file might help you see if this file matches what you are looking for:

...Sheet blended instructions calculation spreadsheet this is to be used in correlation with the epa guidance quot doing inventory control right for underground storage tanks document please refer wwwtexasenvirohelporg or call assistance you will need use one per tank at facility if fuel dispensed a each of that blend together from not another nonblended analysis data most important part compare sum overshort cell h leak check value e absolute disregard sign comparison failed greater than passed two periods row then must report tceq as suspected release within hours second failing see rg module pst super guide instruction and further steps situation superguide can found worksheet represents day period on there are three tables basic information daily calculations table identify your here begins s name b id number registration also delivery certificate c enter beginning ending dates collecting d year it reported form f size gallons g type ex regular percentage midgrade know work correctly ...

Related files

Share

Help

Blended 30-Day Worksheet

Basic Information
Facility Name	Facility ID	30-Day Period	Year	Tank Number	Tank Capacity	Fuel Type	Midgrade % Regular	Midgrade % Super
						Regular

Daily Entries for This Period
Date	Initial Stick Reading (Regular Gallons)	Daily Regular Gallons Dispensed	Daily Midgrade Gallons Dispensed	Daily Midgrade Gallons Dispensed % Regular	Regular Gallons Delivered	Book Inventory (Regular Gallons)	Closing Stick Reading (Regular Gallons)	Daily Over or (Short)	Initials
				0.00		0.00		0
				0.00		0.00		0
				0.00		0.00		0
				0.00		0.00		0
				0.00		0.00		0
				0.00		0.00		0
				0.00		0.00		0
				0.00		0.00		0
				0.00		0.00		0
				0.00		0.00		0
				0.00		0.00		0
				0.00		0.00		0
				0.00		0.00		0
				0.00		0.00		0
				0.00		0.00		0
				0.00		0.00		0
				0.00		0.00		0
				0.00		0.00		0
				0.00		0.00		0
				0.00		0.00		0
				0.00		0.00		0
				0.00		0.00		0
				0.00		0.00		0
				0.00		0.00		0
				0.00		0.00		0
				0.00		0.00		0
				0.00		0.00		0
				0.00		0.00		0
				0.00		0.00		0
				0.00		0.00		0

30-Day Calculations
Water Level Reading	Date of Water Level	Sum for Daily Gallons Dispensed	Math Check	Leak Check	Last Day Stick Reading	Sum for Gallons Delivered	Sum for Daily Over/Short (absolute value)
		0	0	130		0	0
Is the Sum for Daily Over/Short greater than the Leak Check result?					Yes	No
End of Worksheet

Related files

Share

Share to social media

Help

Login Area