horizontal cylindrical tank volume calculator excel

The section sketch map of the horizontally tilted tank. Where ( ) can be calculated from (2.3), (3.4) and (3.5) as followsįigure 5. Then the relationship between and isīy using the method of cutting and filling, the oil volume of the tank can be shown as follows Similarly, let denote maximum distance from oil surface to bottom of tank (see Figure 3).

Thus, (3.3) implies the following relationship between and : Where is minimum distance from oil surface to bottom of tank (see Figure 3). Under normal circumstances, when the tank tilts vertically with an angle of (see Figure 2), the equation of intersection line met by the oil surface and vertical section of the tank can be obtained as follows: īased on the known data and the Cartesian coordinate system with taking the center point of the oil tank as origin, it is easy to get the following four equations for boundary contour of the tank: Then, we shall synthetically study the relationship among the oil volume of the tank, the oil height and the tilted parameter. Thus, we first consider the influence of vertically tilting angle and the horizontally tilting angle to the oil volume meter, respectively. The tank may tilt vertically or horizontally. Then, it follows from (2.1) and (2.2) that Is the radius of the spherical body, is the radius of the horizontal round section, is the width of the spherical body, is the oil height, is the random level section of the spherical body. In order to compute the oil volume, they should be considered respectively (see Figure 1).įrom Figure 1, we know that the volume of the shadowed part can be divided into two parts: cylinder part ( ) and spherical body ( ), and The tank consists of two differently shaped parts: the main body is a cylinder, the two sides are two spherical top. The Oil Volume of the Tank with No Tilting Finally, by using non-linear least squares method, parameters and will be estimated and the marking number of the tank-volume meter will be given.Ģ. Then, the relationship model between the oil volume and shall be synthesized when the tank tilts not only vertically but also horizontally. Secondly, based on the symmetry of the oil tank, the situations of the vertical tilted tank with oil on two sides and on only one side, and the situations of the horizontal tilted tank will be considered by turning into the corresponding oil volume in the situation of no tilting, respectively. The studying method presented in this paper is: the relationship between the oil volume and the height of the oil is first set up under the situation of no tilting. In this paper, the oil tank is more sophisticated geometric shape with a cylinder shape in the middle and two sphere-cal top on both sides. The oil volume stored in an inclined cylinder tank is discussed in and the oil volume stored in an inclined rectangular parallelepiped tank is studied in. Because of the deformation of the ground work, the oil tanks have been tilted after a period of time of operation, and it needs to remark the oil-volume meter regularly.

Through a real-time calculation on the relationship between the oil height and the oil volume, we can get the changing conditions of the oil height and the oil volume in the tank. It is well known that there are several oil tanks and corresponding “oil measuring management system” in gas station, which can measure the input or output oil volumes and the height of the oil in the tank by means of runoff meters and oil height meters. In, the oil-volume marking problem with tilted oil tank is shown and is also a practical one for some oil enterprises. Finally, parameters α = 2.2˚ and β = 3.05˚ are estimated by using nonlinear least squares method and the marking number of the tank-volume meter is given. Then, based on the data of the oil output volume at different time of day, an optimization model of oil-volume marking with tilted oil tank is established. In this paper, the relationship model between the oil volume and the vertically tilting parameter (α), the horizontally tilting parameter (β) and the displayed height of oil (h *) is first constructed with the tilted oil tank. Keywords: Optimization Model Oil Tank Tilt Oil-Volume Marking Problem Least Squares Method Parameter Estimation 1Department of Mathematics, Sichuan University of Science & Engineering, Zigong, ChinaĢSchool of Computer Science, Sichuan University of Science & Engineering, Zigong, ChinaģSchool of Automation and Electronic Information, Sichuan University of Science & Engineering, Zigong, ChinaĮmail: Septemrevised Octoaccepted October 22, 2012

Horizontal cylindrical tank volume calculator excel