Excel table-based calculation method for riding wheel adjustment data of soda ash calcining furnace

Abstract

The invention relates to a soda ash calcining furnace riding wheel adjustment data calculation method based on an Excel table, and belongs to the technical field of equipment maintenance. According to the method, a parameter input area is established in an Excel table, the original diameter of a rolling ring, the diameter of the turned rolling ring, the original diameter of a riding wheel, the diameter of the turned riding wheel and the included angle between the center of the rolling ring and the center of the riding wheel are set, and the thickness and the translation amount of a riding wheel base plate are obtained after calculation. The method is accurate in calculation and high in calculation efficiency, only needs to master the basic operation of Excel, reduces the use threshold, is suitable for most maintainers, can be widely popularized in equipment maintenance in the sodium carbonate industry, improves the overall maintenance efficiency, and has remarkable progress compared with the prior art.

Description

Technical Field

[0001] The invention belongs to the technical field of equipment maintenance, and in particular relates to a method for calculating support roller adjustment data of a soda ash calcining furnace based on an Excel table. Background Art

[0002] The supporting rollers and rollers are important components of the heavy ash calciner. During the installation of the furnace body, the calciner must have a certain inclination to ensure that the material can flow to the heating section of the calciner and keep the return water unobstructed. However, when the equipment is running, the huge furnace body is supported by only four supporting rollers. At the same time, the weight of the furnace body, the weight of the material in the furnace, and the impulse generated during rotation, etc., all loads are attached to the four supporting rollers. After long-term operation, the surface of the supporting rollers and rollers will cause the center position of the furnace body to change due to wear, resulting in poor contact between the supporting rollers and the roller surfaces. This will also cause serious wear of the furnace nozzle and the feeding device, serious vibration of the furnace body, bursting of the expansion joint, frequent maintenance of the main transmission device, furnace head seal, alkali discharge chamber seal, steam shaft filler, steam chamber also leaking alkali and gas due to vibration, and a series of problems. It is necessary to maintain the stability of the center line of the furnace body by adjusting the thickness and translation of the supporting roller pads.

[0003] Traditional calculation methods mainly rely on formula calculations, which require the use of the principle of similar triangles. The calculation process is cumbersome and requires a high level of mathematical foundation. Computer-aided design (CAD) technology has a low penetration rate in the industry and is difficult to be widely used. Therefore, a method for calculating the roller adjustment data that is simple to operate and accurate in calculation is urgently needed to improve the shortcomings of existing technology. Summary of the Invention

[0004] The present invention aims to provide a method for calculating the adjustment data of the supporting rollers of a soda ash calcining furnace based on an Excel table.

[0005] In order to achieve the above object, the present invention provides the following technical solutions: A method for calculating the adjustment data of the supporting rollers of a soda ash calcining furnace based on an Excel spreadsheet comprises the following steps: S1. Parameter setting: Create a parameter input area in the Excel spreadsheet, set the original diameter A of the roller, the diameter a of the roller after turning, the original diameter B of the roller, the diameter b of the roller after turning, and the angle between the center of the roller and the center of the roller is 60°; S2. Calculation process: Create a calculation area in the Excel table; Original wheel center distance C1=A / 2+B / 2; The center distance of the rear wheel during turning is C2=a / 2+b / 2; Original height H1=(C1 2 -(C2 / 2) 2 ) 1 / 2 ; Height after turning: H2 = H2*C2 / C1; Raised height H=H1-H2; Translation distance D = C1 / 2 + C2 / 2; S3. Output results: Create an output area in the Excel table and output the pad height H and translation distance D.

[0006] The beneficial effects of the present invention are: Accurate calculation: The calculation results are calculated by Excel formula, and the deviation from the traditional formula calculation method is 0, which meets the control requirement of calcining furnace alignment within 3mm.

[0007] Improved efficiency: No need for complex manual calculations, just input parameters to quickly get results, saving a lot of computing time and reducing workload.

[0008] Easy to operate: No professional CAD skills are required, only basic Excel operations are required, which lowers the usage threshold and is suitable for most maintenance personnel.

[0009] Strong scalability: Excel software has a high penetration rate, and this method can be widely promoted in equipment maintenance in the soda ash industry to improve overall maintenance efficiency.

[0010] The above description is only an overview of the technical solution of the present invention. In order to more clearly understand the technical means of the present invention and implement it according to the contents of the specification, the following is a detailed description of the preferred embodiments of the present invention with reference to the accompanying drawings. BRIEF DESCRIPTION OF THE DRAWINGS

[0011] Figure 1 This is a schematic structural diagram of a supporting wheel and a roller ring according to an embodiment of the present invention; Figure 2 A schematic diagram of an Excel-based calculation table according to an embodiment of the present invention. DETAILED DESCRIPTION

[0012] See Figure 1 O is the center of the roller's initial installation, O1 and O2 are the centers of the two rollers' initial installation, and point A is the intersection of a line perpendicular to O1 and O2 and the line connecting O1 and O2. The angle between the tangent point between the roller and the roller and the line connecting the roller's center is defined as a. When the roller and roller change size due to wear after operation, the roller radius R decreases to R', and the roller radius decreases from r1 and r2 to r1' and r2', respectively.

[0013] During the inspection of the rollers and support rollers, in order to ensure that the center line of the furnace body remains unchanged, the support rollers are pushed inward and raised. As an existing technology, "Soda Ash Production Equipment Maintenance and Anti-corrosion" introduces a traditional calculation method for roller and support wear, which uses the main characteristics of similar triangles: corresponding angles are equal and corresponding sides are proportional. Formulas 2 and 3 can be used to calculate the amount of inward push and lift. The amount of lift is generally achieved by laying a pad of the same thickness on the support roller. The calculation formula is as follows: O1O1'=(R+r1)-(R'+r1') (Formula 1); O1a1=O1O1'·sina / 2 (Formula 2); O1'a1=O1O1'·cosa / 2 (Formula 3); in: O1O1': The reduction in the distance between the center of the supporting wheel and the rolling ring after wear; O1a1: displacement between the center of the worn supporting roller and the center of the standard supporting roller; O1'a1: The displacement of the center of the supporting wheel after wear compared to the standard; In order to save equipment maintenance costs, it was decided to turn the surfaces of the old rollers and supporting wheels while ensuring that the surface hardness layer of the rollers is not affected and that a complete circular surface can be turned. The following data are the dimensions before and after turning.

[0014] Original size After turning Roller outer diameter Φ3500mm Φ3484mm Support roller outer diameter Φ1200mm Φ1192mm Center distance between two supporting rollers 2350mm 2338mm Angle between the center of the roller and the center of the supporting wheel 60º 60º Center distance between roller and supporting wheel 2350mm 2338mm By plugging the above data into the three formulas, we can get: O1O1'=(R+r1)-(R'+r1')=(3500 / 2+1200 / 2)-(3484 / 2+1192 / 2)=12mm; O1a1=O1O1'·sina / 2=12·sin30º=6mm; O1'a1=O1O1'·cosa / 2=12·cos30º=10.39mm; In summary, through traditional calculation methods, it can be seen that after turning, the supporting wheel needs to be pushed inward by 6mm and a 10.39mm pad needs to be added.

[0015] The technical solution of the present invention will be clearly and completely described below with reference to the accompanying drawings. Obviously, the embodiments described are only some embodiments of the present invention, not all embodiments. All other embodiments obtained by ordinary technicians in this field based on the embodiments of the present invention without making any creative efforts shall fall within the scope of protection of the present invention.

[0016] In addition, the technical features involved in the different embodiments of the present invention described below can be combined with each other as long as they do not conflict with each other.

[0017] It is known from common sense that the angle between the center of the rolling ring and the center of the supporting roller is 60°, and the center distance between the two supporting rollers is equal to the center distance between the rolling ring and the supporting roller.

[0018] See Figure 2 The Excel-based calculation table shown in the present invention comprises the following steps: Step 1: Construction of input module, see Table 1; Table 1

[0019] Set up tables B3 and B4 for inputting the original roller diameter and roller diameter, respectively. Set up tables C3 and C4 for inputting the roller diameter and roller diameter after turning, respectively. Tables B5 and C5 are the original dimensions and the center distances of the two supporting rollers after turning, namely: B5=B3 / 2+B4 / 2 C5=C3 / 2+C4 / 2 Tables B7 and C7 are the center distances between the roller and the supporting roller of the original size and after turning, respectively. Since the angle between the center of the roller and the center of the supporting roller is 60°, it can be seen that the center distance between the roller and the supporting roller is equal to the center distance between the two supporting rollers, that is: B7=B5 C7=C5; Step 2: Construction of the computing module Please refer to Table 1. Set E3 and E4 as the original roller radius and roller radius, respectively. Set F3 and F4 as the roller radius and roller radius after turning, respectively. Then, set E5 and F5 as the original size and the center distance of the two rollers after turning, that is: E5=E3+E4 F5=F3+F4 See Figure 1 , OO2, OA, AO2 form a right triangle, where AO2 is half of the center distance between the two rollers. Set E6 and F6 to be half of the center distance between the two rollers after the original size and turning, respectively, that is: E6=E5 / 2 F6=F5 / 2 The calculation results are shown in Table 2; Table 2

[0020] For further information, see Table 3 Table 3

[0021] The calculation steps are as follows: G3=E5^2-E6^2 (A right triangle is called a Pythagorean triangle, and the sum of the squares of its two right-angled sides is equal to the square of its hypotenuse.) H4=G3^(1 / 2) (In the initial installation, the height of the line passing through the center of the roller ring and perpendicular to the line connecting the centers of the two supporting rollers.) H5=C5 / B5*(H4) (After turning, the height of the straight line passing through the center point of the roller and perpendicular to the line connecting the center points of the two supporting rollers.) H6=H4-H5 (height to be raised) H7=B7 / 2-C7 / 2 (the distance to be moved inward) Step 3: Output the results Set B8 as the pad height and B9 as the translation distance, that is, B8=H6, B9=H7, the results are shown in Table 4; Table 4

[0022] It can be seen that as long as the original and turned roller outer diameters and the outer diameter of the supporting wheel are entered in the Excel table, it can be known that the turned supporting wheel needs to be pushed inward by 6mm and raised by 10.39mm, which means that a 10.39mm pad needs to be added.

[0023] It can also be seen that the deviation between the calculation method shown in the present invention and the traditional calculation method is 0. In summary, the present invention is suitable for practical applications.

[0024] The technical features of the above-mentioned embodiments can be combined arbitrarily. In order to make the description concise, not all possible combinations of the technical features in the above-mentioned embodiments are described. However, as long as there is no contradiction in the combination of these technical features, they should be considered to be within the scope of this specification.

[0025] The above-described embodiments merely illustrate several implementations of the present invention, and while their descriptions are relatively specific and detailed, they should not be construed as limiting the scope of the patent. It should be noted that a person skilled in the art would be able to make numerous variations and improvements without departing from the spirit of the present invention, all of which fall within the scope of protection of the present invention. Therefore, the scope of protection of the patent for this invention shall be determined by the appended claims.

Claims

1. A method for calculating the adjustment data of the supporting rollers of a soda ash calcining furnace based on an Excel table, characterized in that: The following steps are involved: S1. Parameter setting: Create a parameter input area in the Excel spreadsheet, set the original diameter A of the roller, the diameter a of the roller after turning, the original diameter B of the roller, the diameter b of the roller after turning, and the angle between the center of the roller and the center of the roller is 60°; S2. Calculation process: Create a calculation area in the Excel table; Original wheel center distance C1=A / 2+B / 2; The center distance of the rear wheel during turning is C2=a / 2+b / 2; Original height H1=(C1 2 -(C2 / 2) 2 ) 1 / 2 ; Height after turning: H2 = H2*C2 / C1; Raised height H=H1-H2; Translation distance D = C1 / 2 + C2 / 2; S3. Output results: Create an output area in the Excel table and output the pad height H and translation distance D.

Images