jagomart
digital resources
picture1_Excel Sheet Download 31096 | Guidance Inventory Record


 163x       Filetype XLSX       File size 0.31 MB       Source: www.gov.mb.ca


File: Excel Sheet Download 31096 | Guidance Inventory Record
sheet 1 temperature compensation tc temperature compensation temperature compensation pumps middot for your system to work and your inventory books to be done correctly your pumps the product that is ...

icon picture XLSX Filetype Excel XLSX | Posted on 08 Aug 2022 | 3 years ago
Partial file snippet.
Sheet 1: Temperature Compensation (TC)
TEMPERATURE COMPENSATION









Temperature Compensation Pumps









·For your system to work and your inventory books to be done correctly, your pumps, the product that is delivered to your tanks and the product in your tank(s) must be temperature compensated.









·When product is delivered to your tank(s) make sure that the temperature compensation volume on your bill of lading is used. This volume is then added to column C (Deliveries).









Your dispensing pump(s) are converted to temperature compensation by a contractor. The conversion is a hardware change.









·Make sure you read the temperature compensated meter reading on your pump(s). The reading on your pump(s) is then added to column D [Daily Sales Volume (Meter Sales)].









·The product in your tank(s) should be temperature compensated at the same time as your daily dip your tank(s), unless you have automatic dipping equipment.









~In that case your automatic dipping equipment would provide temperature readings as well.









~In the case of manual dipping you would lower a petroleum resistant thermometer into the tank. The temerature of your product should be taken 12 to 18 inches from the bottom of your tank.









~Once the temperature is obtained from the product in your tank(s) you would use the conversion chart to get a temperature correction factor. This factor is then multipled by the volume in your tank to get your temperature compensated volume. This temperature compensated volume is then added to column F (Closing Physical Inventory).









NOTE: The failure to temperature compensate your product in your tank(s) can create errors in your inventory books.









Non-Temperature Compensated Pumps







If you do not have temperature compensated pumps, the only requirement would be to make sure that when product is delivered to your tank(s) only the non-temperature compensated volume on the bill of lading is used. This volume is then added to column C (Delivery) under Daily Inventory Balance Record.

Sheet 2: TC Decision Tree






TEMPERATURE &






NON-TEMPERATURE COMPENSATED PUMPS





























Sheet 3: TC Conv Chart
CONVERSION CHART FOR TEMPATURE CORRECTION










TEMPERATURE CORRECTION CHART: 1


DESCRIPTION: GASOLINE










Deg. C Factor Deg. C Factor Deg. C Factor Deg. C Factor Deg. C Factor
-20 1.0431 -19 1.0413 -18 1.0407 -17 1.0395 -16 1.0383
-15 1.0371 -14 1.0359 -13 1.0346 -12 1.0334 -11 1.0322
-10 1.0310 -9 1.0297 -8 1.0285 -7 1.0273 -6 1.0261
-5 1.0248 -4 1.0236 -3 1.0224 -2 1.0211 -1 1.0199
0 1.0187 1 1.0174 2 1.0162 3 1.0149 4 1.0137
5 1.0125 6 1.0112 7 1.0100 8 1.0087 9 1.0075
10 1.0062 11 1.0050 12 1.0037 13 1.0025 14 1.0013
15 1.0000 16 0.9987 17 0.9975 18 0.9962 19 0.9950
20 0.9937 21 0.9925 22 0.9912 23 0.9900 24 0.9887
25 0.9874 26 0.9862 27 0.9849 28 0.9837 29 0.9824
30 0.9811 31 0.9799 32 0.9786 33 0.9773 34 0.9761
35 0.9748 36 0.9735 37 0.9723 38 0.9710 39 0.9697
40 0.9684



























TEMPERATURE CORRECTION CHART: 2


DESCRIPTION: DIESEL










Deg. C Factor Deg. C Factor Deg. C Factor Deg. C Factor Deg. C Factor
-20 1.0292 -19 1.0284 -18 1.0276 -17 1.0268 -16 1.026
-15 1.0251 -14 1.0243 -13 1.0235 -12 1.0226 -11 1.0218
-10 1.0210 -9 1.0201 -8 1.0193 -7 1.0185 -6 1.0176
-5 1.0168 -4 1.0160 -3 1.0151 -2 1.0143 -1 1.0134
0 1.0126 1 1.0118 2 1.0109 3 1.0101 4 1.0093
5 1.0084 6 1.0076 7 1.0067 8 1.0059 9 1.0051
10 1.0042 11 1.0034 12 1.0025 13 1.0017 14 1.0008
15 1.0000 16 0.9992 17 0.9983 18 0.9975 19 0.9966
20 0.9958 21 0.9949 22 0.9941 23 0.9932 24 0.9924
25 0.9915 26 0.9907 27 0.9898 28 0.9890 29 0.9881
30 0.9873 31 0.9864 32 0.9856 33 0.9847 34 0.9836
35 0.9830 36 0.9822 37 0.9813 38 0.9805 39 0.9796
40 0.9788








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

...Sheet temperature compensation tc pumps middot for your system to work and inventory books be done correctly the product that is delivered tanks in tank s must compensated when make sure volume on bill of lading used this then added column c deliveries dispensing pump are converted by a contractor conversion hardware change you read meter reading d should at same time as daily dip unless have automatic dipping equipment case would provide readings well manual lower petroleum resistant thermometer into temerature taken inches from bottom once obtained use chart get correction factor multipled f closing physical note failure compensate can create errors nontemperature if do not only requirement delivery under balance record decision tree amp conv tempature description gasoline deg diesel...

no reviews yet
Please Login to review.