Horizontal Tank Calibration Using Excel
Horizontal Tank Calibration Using Excel
Horizontal Tank Calibration Using Excel
net/publication/318901968
CITATION READS
1 2,892
5 authors, including:
Some of the authors of this publication are also working on these related projects:
All content following this page was uploaded by Adeolu Adesoji Adediran on 13 July 2018.
ORIGINAL PAPER
Abstract: Petroleum and petroleum products are expensive commodities due to their global demand as a major source of
energy. As a result of its expensiveness, there is need for proper inventory to know what is going in and coming out of the
storage tanks. Proper inventory is achieved by accurate measurement through the generation of a calibration chart for every
storage tank. Calibration chart (tank table) gives the needed information about the level (height) and the corresponding
volume of the petroleum product in the storage tank. Geometrical method (dry calibration) is the most widely used method
of computing tank table using the field data such as circumference, shell or plate thickness, length of barrel and lap/butt
strap while taking the necessary correction factors into consideration. Microsoft Excel is a powerful tool in Microsoft (MS)
office package used for computation and programming through the use of visual basic for application. In this study, MS
Excel was used to generate two different charts which were compared with the charts generated from customized spe-
cialized calibration software from Société Générale de Surveillance (SGS software) and the results were found to be within
the statistical controlled limit.
123
O. O. Agboola et al.
very difficult task for inclined or tilted tanks because there shell temperature. Though, there are two possible methods
is need to take into consideration the effect of tilt [10]. Tilt of physical measurements which are external and internal
is not always a desirable condition in the installation of measurement, however; the scope of this paper is limited to
horizontal tanks but it may be intentionally done in some external measurement because most of the storage tanks
rare conditions which include enhancing free flow from abide by external measurement except the insulated tanks
one section to the other. Correction for the effect of tilt and where internal measurements are adopted.
its optimization was given by Wei et al. [11] where a model
of oil volume marking for a tilted oil tank was validated. 2.2. Circumferential Measurement
Calibration of a horizontal storage tank should be done
once in every five (5) years [12]. Tank capacity table, which Horizontal tanks consist of two heads commonly called
is the output of tank calibration process, is a set of data ends. Amid the two heads is a cylindrical section called
relating the filled volume of storage tank to the gauge height/ barrel. It is important to note that for a flat-ended tank,
level. MS-Excel has been used over the years for mathe- there is only barrel but no head.
matical calculation instead of manual calculations [13]. Circumferences were measured at 20, 50 and 80% of the
When a correct program is written on a spreadsheet, the barrel length by winding a strapping tape round the shell at
output would definitely be right. Sanjid and Chaudhary [14] these various sections. The strapping tape was firmly held
designed a software for the calibration of angle block and under tension using ‘‘little John grip’’. The circumferences
validated it with the results obtained from MS-Excel calcu- obtained for two different Tank A and Tank A1 are as
lation. Validation could be done by comparing already shown in Tables 1 and 2.
existing method(s) with the new proposed method. Chunhui
and Johnson [15] researched into the bilateral comparison 2.3. Shell Plate Thickness
between NIM’s and NIST’s gas flow standards and found
that all the data are in compliance with ISO 9300 empirical The thickness of every section of the barrel as well as the
equation within its 0.3% expanded uncertainty limit. end thicknesses was taken using UTG for spot scanning.
Having searched extensively in Nigeria by meeting with The scanning was simultaneously done on the tank barrel.
the renowned calibration companies to know if there are The field data obtained was shown in the Tables 3 and 4,
commercialized softwares for Tank calibration, it was dis- respectively for Tanks A and A1.
covered that none ever existed up till date. However, most
companies combine various standards such as API, IP and ISO 2.4. Slope Measurement
together to do manual computations. In order to reduce this
rigorous task, the use of API 2551 was adopted in this work in No slope was found in Tank A because the value obtained
addition to the exact mathematical findings of Dan [8] to as both assumed shallow end and deep end were the same.
generate calibration charts using MS Excel programme. This However, for Tank A1, negligible tilt value was observed.
research aims at generating calibration charts for horizontal The observed value obtained in shallow end was 765 mm
cylindrical storage tanks using simple Microsoft Excel pro- while 759 mm was obtained at the deep end.
gramme. The programme interface is user-friendly. This
makes the task of generating calibration charts simple. 2.5. Temperature
123
Generation of Calibration Charts for Horizontal Petroleum Storage Tanks Using Microsoft Excel
123
O. O. Agboola et al.
Rh
330 2544 2544 0.02 Vcy ¼ L R2 cos1 ðR hÞ 2Rh h2
340 2658 2658 0.02 R
350 2773 2774 0.02 þ ð T1 þ T2 Þ ð6Þ
2660 40,122 40,143 0.05
where R radius of the cylindrical barrel (mm), h height
2670 40,236 40,257 0.05
(level) in mm measured from the dip point, L length of
2680 40,348 40,369 0.05
barrel in (mm), T1 and T2 are the corrections for the effect
2690 40,459 40,480 0.05
of tilt as shown in Eqs. 3 and 4.
2700 40,568 40,590 0.05 Equations (3–6) above is converted to Litres (L) by
2710 40,675 40,697 0.05 multiplying with 10-6.
2720 40,781 40,803 0.05
2730 40,886 40,908 0.05 2.12.2. Volume of the Ends
2740 40,988 41,010 0.05
2750 41,089 41,111 0.06 As earlier stated, the two heads were treated together as
2760 41,188 41,210 0.06 one. The three heads commonly encountered are discussed
2770 41,285 41,308 0.06 below.
123
Generation of Calibration Charts for Horizontal Petroleum Storage Tanks Using Microsoft Excel
123
O. O. Agboola et al.
Volume vs Height R h
M ¼ ð11Þ
50,000 R
40,000 cr cone rise (mm), R radius of the cylindrical section,
h measured height/level (mm) and Vcn conical ended vol-
volume(L)
30,000
ume [8].
20,000 y = 3E-06x2 + 16.042x - 2673.8
R² = 0.9957 2.12.4. Elliptical Ends
10,000
40,000
y = -6E-07x2 + 20.054x - 3328.9 When two hemispherical ends combine, they give a com-
20,000 R² = 0.9958
plete sphere. Hence, the volume of hemispherical ends Vh
0 is given as:
0 500 1,000 1,500 2,000 2,500 3,000 3,500
-20,000 ph2
Height (mm) Vh ¼ ð3R hÞ ð13Þ
3
Fig. 4 Volume against height for Tank A1 using Excel programme where Vh hemispherical heads volume, R radius of the
cylindrical section (mm), h measured height/level (mm)
1. When the measured height h is less greater than zero
but less than the radius of the cylindrical barrel R (i.e. 2.13. MS Excel Programme Interface
0 h\R).
2. When measured height h is equal to the radius of the The interface where the inputs are supplied is shown in
cylindrical barrel R (i.e. h = R). Fig. 1.
3. When radius of the cylindrical barrel R is less than the
measured height h but h too less than or equal to 2R
(i.e. R\h 2R). 3. Results
The volumes of the conical end at these three sections Information from Tanks A and A1 were fed into both the
are given in mathematical form as: MS-Excel programme and SGS software and the
For 0 h\R, chart generated for each of the tanks are displayed in
2cr R2 K Tables 5 and 6 respectively.
Conical end volume Vcn ¼ ð7Þ
3
For h = R,
4. Discussion
2
2cr R p
Conical end volume; Vcn ¼ ð8Þ
3 2 From the Tables 5 and 6, the maximum deviation and
average deviation for Tank A are 0.07 and 0.03 respec-
For R\h 2R,
tively while the maximum deviation and average deviation
2cr R2 for tank A1 are 0.11 and 0.06 respectively. The above
Conical end volume; Vcn ¼ ðp K Þ ð9Þ
3 deviations are consistent with the provision of 0.3% vari-
ation of the indicated volume [12]. Adetokunbo [16]
But
reported on the effectiveness of geometrical method of tank
1 pffiffiffiffiffiffiffiffiffiffiffiffiffiffiffi
K ¼ cos1 M þ M 3 cosh1 2M 1 M 2 ð10Þ calibration where it was observed that the maximum
M deviation noted for chat obtained from SGS and chart from
123
Generation of Calibration Charts for Horizontal Petroleum Storage Tanks Using Microsoft Excel
123