Sheet 1: Non-Blended 30-Day Instructions

	
	

		
Non-Blended Calculation Spreadsheet Instructions
	
	

		
This spreadsheet is to be used in correlation with the "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. Diesel, Regular, or Super)
	
	

		
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 non-blended fuel dispensed for that day. This information is from your daily fuel sales.
	
	

		
Cells D9-D38: Enter gallons delivered for the tank.
	
	

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

		
Cells F9-F38: Enter the closing stick or ATG reading for that day in gallons
	
	

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

		
Cells H9-H38: 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 
	
	

		
Non-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 layoutto landscape and click "Fit to one Page".
	
	

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

		
End of Worksheet