Docstoc

Non-Blended Inventory Control Worksheet

Document Sample
Non-Blended Inventory Control Worksheet Powered By Docstoc
					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
This is the most important part of doing inventory control. Compare Sum of Over/Short (cell H43) to Leak Check
value (cell E43) and each other. Use the absolute value (disregard the sign) of the Sum for Over/Short
comparison. for Over/Short value is greater than Leak Check value.
Failed - Sum
Passed - Leak check value is greater than Sum for Over/Short value.
If failed for two months in a row then you must report to TCEQ as a suspected release within 24 hours. Please
see the Suspected Release (RG 475h) module in the PST Super Guide for instruction and further steps for this
Each worksheet represents a month. On each sheet, there are three tables:
Basic Information
Daily Inventory
Monthly Calculations
Monthly Worksheets
Print Instructions
At the end of this page is a list of links to each month's worksheet and print instructions. You can also click the
tab for each month at the bottom of this window.
Basic Information
Identify your facility and the tank here. This table begins in Cell A3 of each month's worksheet.
Cell A5: Facility name
Cell B5: Facility ID number found on PST registration information. This can also be found on your delivery
Cell C5: Enter the month that you are the collecting data
Cell D5: Enter the year that you are collecting the data
Cell E5: Enter tank number as it 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)
Daily Inventory
Enter your readings here each day. Some cells will be calculated for you. This table begins in Cell A7 of each
month's worksheet.the date for the data
Cells A9-A39: Enter
Cells B9-B39: Enter the start stick or ATG reading in gallons for each day of operation
Cells C9-C39: Enter gallons non-blended fuel dispensed for that day.
Cells D9-D39: Enter gallons delivered for the tank.
Cells E9-E39: The worksheet calculates the Book Inventory for you. Skip to the next column.
Cells F9-F39: Enter the closing stick or ATG reading for that day in gallons
Cells G9-G39: The worksheet calculates the Daily Over/Short for you. Skip to the next column.
Cells H9-H39: Put the initials of the person that collected the data.
Monthly Calculations
Monthly calculations and reading will start in this table. This table begins in Cell A41 of each month's worksheet.
Cell A43: Enter the water level in the tank (in inches)
Cell B43: Enter the date that the water level data were collected
Cell C 43: The worksheet calculates the Sum for Daily Gallons Dispensed for you. Skip to the next column.
Cell D43: The worksheet calculates the Math Check for you. Skip to the next column.
Cell E43: The worksheet calculates the Leak Check for you. Skip to the next column.
Cell F43: Enter the last stick/ATG reading for the month (in gallons)
Cell G43: The worksheet calculates the Sum for Gallons Delivered for you. Skip to the next column.
Cell H43: The worksheet calculates the Sum for Over/Short for you. Skip to the next column.
All calculations can be found in the "Doing Inventory Control Right For Underground Storage Tanks".
Monthly Worksheets
January
February
March
April
May
June
July
August
September
October
November
December
Print Instructions
To print instructions, change to portrait and print.
To print the spreadsheets, change to landscape and click "Fit to one Page".
                                                                 Non Blended Monthly

                                                             Basic Information
Facility Name   Facility ID             Month                 Year



                                                               Daily Entries for This Month
                Initial Stick Reading   Daily Gallons
Date            (gallons)               Dispensed             Gallons Delivered




                                                                     Monthly Calculations
Water Level                             Sum for Daily Gallons
Reading         Date of Water Level     Dispensed               Math Check
                                                              0                   0
ended Monthly

mation
         Tank Number         Tank Capacity            Fuel Type



ies for This Month
         Book Inventory Closing Stick Reading         Daily Over or
         (Gallons)        (gallons)                   (Short)               Initials
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0

ly Calculations
                                                      Sum for Gallons       Sum for
         Leak Check          Last Day Stick Reading   Delivered             Over/Short
                       130                                              0                0
                                                                 Non Blended Monthly

                                                             Basic Information
Facility Name   Facility ID             Month                 Year



                                                               Daily Entries for This Month
                Initial Stick Reading   Daily Gallons
Date            (gallons)               Dispensed             Gallons Delivered




                                                                     Monthly Calculations
Water Level                             Sum for Daily Gallons
Reading         Date of Water Level     Dispensed               Math Check
                                                              0                   0
ended Monthly

mation
         Tank Number         Tank Capacity            Fuel Type



ies for This Month
         Book Inventory Closing Stick Reading         Daily Over or
         (Gallons)        (gallons)                   (Short)               Initials
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0

ly Calculations
                                                      Sum for Gallons       Sum for
         Leak Check          Last Day Stick Reading   Delivered             Over/Short
                       130                                              0                0
                                                                 Non Blended Monthly

                                                             Basic Information
Facility Name   Facility ID             Month                 Year



                                                               Daily Entries for This Month
                Initial Stick Reading   Daily Gallons
Date            (gallons)               Dispensed             Gallons Delivered




                                                                     Monthly Calculations
Water Level                             Sum for Daily Gallons
Reading         Date of Water Level     Dispensed               Math Check
                                                              0                   0
ended Monthly

mation
         Tank Number         Tank Capacity            Fuel Type



ies for This Month
         Book Inventory Closing Stick Reading         Daily Over or
         (Gallons)        (gallons)                   (Short)               Initials
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0

ly Calculations
                                                      Sum for Gallons       Sum for
         Leak Check          Last Day Stick Reading   Delivered             Over/Short
                       130                                              0                0
                                                                 Non Blended Monthly

                                                             Basic Information
Facility Name   Facility ID             Month                 Year



                                                               Daily Entries for This Month
                Initial Stick Reading   Daily Gallons
Date            (gallons)               Dispensed             Gallons Delivered




                                                                     Monthly Calculations
Water Level                             Sum for Daily Gallons
Reading         Date of Water Level     Dispensed               Math Check
                                                              0                   0
ended Monthly

mation
         Tank Number         Tank Capacity            Fuel Type



ies for This Month
         Book Inventory Closing Stick Reading         Daily Over or
         (Gallons)        (gallons)                   (Short)               Initials
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0

ly Calculations
                                                      Sum for Gallons       Sum for
         Leak Check          Last Day Stick Reading   Delivered             Over/Short
                       130                                              0                0
                                                                 Non Blended Monthly

                                                             Basic Information
Facility Name   Facility ID             Month                 Year



                                                               Daily Entries for This Month
                Initial Stick Reading   Daily Gallons
Date            (gallons)               Dispensed             Gallons Delivered




                                                                     Monthly Calculations
Water Level                             Sum for Daily Gallons
Reading         Date of Water Level     Dispensed               Math Check
                                                              0                   0
ended Monthly

mation
         Tank Number         Tank Capacity            Fuel Type



ies for This Month
         Book Inventory Closing Stick Reading         Daily Over or
         (Gallons)        (gallons)                   (Short)               Initials
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0

ly Calculations
                                                      Sum for Gallons       Sum for
         Leak Check          Last Day Stick Reading   Delivered             Over/Short
                       130                                              0                0
                                                                 Non Blended Monthly

                                                             Basic Information
Facility Name   Facility ID             Month                 Year



                                                               Daily Entries for This Month
                Initial Stick Reading   Daily Gallons
Date            (gallons)               Dispensed             Gallons Delivered




                                                                     Monthly Calculations
Water Level                             Sum for Daily Gallons
Reading         Date of Water Level     Dispensed               Math Check
                                                              0                   0
ended Monthly

mation
         Tank Number         Tank Capacity            Fuel Type



ies for This Month
         Book Inventory Closing Stick Reading         Daily Over or
         (Gallons)        (gallons)                   (Short)               Initials
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0

ly Calculations
                                                      Sum for Gallons       Sum for
         Leak Check          Last Day Stick Reading   Delivered             Over/Short
                       130                                              0                0
                                                                 Non Blended Monthly

                                                             Basic Information
Facility Name   Facility ID             Month                 Year



                                                               Daily Entries for This Month
                Initial Stick Reading   Daily Gallons
Date            (gallons)               Dispensed             Gallons Delivered




                                                                     Monthly Calculations
Water Level                             Sum for Daily Gallons
Reading         Date of Water Level     Dispensed               Math Check
                                                              0                   0
ended Monthly

mation
         Tank Number         Tank Capacity            Fuel Type



ies for This Month
         Book Inventory Closing Stick Reading         Daily Over or
         (Gallons)        (gallons)                   (Short)               Initials
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0

ly Calculations
                                                      Sum for Gallons       Sum for
         Leak Check          Last Day Stick Reading   Delivered             Over/Short
                       130                                              0                0
                                                                 Non Blended Monthly

                                                             Basic Information
Facility Name   Facility ID             Month                 Year



                                                               Daily Entries for This Month
                Initial Stick Reading   Daily Gallons
Date            (gallons)               Dispensed             Gallons Delivered




                                                                     Monthly Calculations
Water Level                             Sum for Daily Gallons
Reading         Date of Water Level     Dispensed               Math Check
                                                              0                   0
ended Monthly

mation
         Tank Number         Tank Capacity            Fuel Type



ies for This Month
         Book Inventory Closing Stick Reading         Daily Over or
         (Gallons)        (gallons)                   (Short)               Initials
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0

ly Calculations
                                                      Sum for Gallons       Sum for
         Leak Check          Last Day Stick Reading   Delivered             Over/Short
                       130                                              0                0
                                                                 Non Blended Monthly

                                                             Basic Information
Facility Name   Facility ID             Month                 Year



                                                               Daily Entries for This Month
                Initial Stick Reading   Daily Gallons
Date            (gallons)               Dispensed             Gallons Delivered




                                                                     Monthly Calculations
Water Level                             Sum for Daily Gallons
Reading         Date of Water Level     Dispensed               Math Check
                                                              0                   0
ended Monthly

mation
         Tank Number         Tank Capacity            Fuel Type



ies for This Month
         Book Inventory Closing Stick Reading         Daily Over or
         (Gallons)        (gallons)                   (Short)               Initials
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0

ly Calculations
                                                      Sum for Gallons       Sum for
         Leak Check          Last Day Stick Reading   Delivered             Over/Short
                       130                                              0                0
                                                                Non Blended Monthly

                                                             Basic Information
Facility Name   Facility ID             Month                 Year



                                                               Daily Entries for This Month
                Initial Stick Reading   Daily Gallons
Date            (gallons)               Dispensed             Gallons Delivered




                                                                     Monthly Calculations
Water Level                             Sum for Daily Gallons
Reading         Date of Water Level     Dispensed               Math Check
                                                              0                   0
ended Monthly

mation
         Tank Number         Tank Capacity            Fuel Type



ies for This Month
         Book Inventory Closing Stick Reading         Daily Over or
         (Gallons)        (gallons)                   (Short)               Initials
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0

ly Calculations
                                                      Sum for Gallons       Sum for
         Leak Check          Last Day Stick Reading   Delivered             Over/Short
                       130                                              0                0
                                                                Non Blended Monthly

                                                              Basic Information
Facility Name   Facility ID             Month                 Year



                                                                Daily Entries for This Month
                Initial Stick Reading   Daily Gallons
Date            (gallons)               Dispensed             Gallons Delivered




                                                                     Monthly Calculations
Water Level                             Sum for Daily Gallons
Reading         Date of Water Level     Dispensed               Math Check
                                                              0                   0
ended Monthly

mation
         Tank Number         Tank Capacity            Fuel Type



ies for This Month
         Book Inventory Closing Stick Reading         Daily Over or
         (Gallons)        (gallons)                   (Short)               Initials
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0

ly Calculations
                                                      Sum for Gallons       Sum for
         Leak Check          Last Day Stick Reading   Delivered             Over/Short
                       130                                              0                0
                                                                Non Blended Monthly

                                                              Basic Information
Facility Name   Facility ID             Month                 Year



                                                                Daily Entries for This Month
                Initial Stick Reading   Daily Gallons
Date            (gallons)               Dispensed             Gallons Delivered




                                                                     Monthly Calculations
Water Level                             Sum for Daily Gallons
Reading         Date of Water Level     Dispensed               Math Check
                                                              0                   0
ended Monthly

mation
         Tank Number         Tank Capacity            Fuel Type



ies for This Month
         Book Inventory Closing Stick Reading         Daily Over or
         (Gallons)        (gallons)                   (Short)               Initials
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0
                     0.00                                               0

ly Calculations
                                                      Sum for Gallons       Sum for
         Leak Check          Last Day Stick Reading   Delivered             Over/Short
                       130                                              0                0

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:12
posted:11/11/2011
language:English
pages:26