A method for automatic selection and pairing of cylinders

Abstract

The present invention provides a method for automatic cylinder selection, comprising the following steps: S1 classifies the major categories of cylinder models and the auxiliary components required for the major categories of cylinder models, and forms a database with the codes, names and brands corresponding to the cylinder models, and the codes and brands corresponding to the auxiliary components for storage; S2 inputs the cylinder model m-x required and the number y of the corresponding cylinder models; S3 obtains the auxiliary components and the number z corresponding to the major categories of the cylinder models; S4 obtains the total number R of the first category of auxiliary components of the corresponding model; S5 determines the number of the second category of auxiliary components; S6 forms a BOM table; S7 forms a cylinder automatic selection matching table; S8 stores the cylinder automatic selection matching table. Using the method of the present invention, the name, model, code and brand of the auxiliary components can be accurately and quickly determined according to the model and quantity of the cylinder, and the number and brand of the cylinder can be accurately and quickly determined.

Description

Technical Field

[0001] The invention relates to the technical field of automation equipment, and in particular to a method for automatic selection and pairing of cylinders. Background Art

[0002] Cylinders are widely used in many fields, such as printing, semiconductors, automatic control, robotics, etc. According to different movement modes, cylinders can be divided into single-acting cylinders, double-acting cylinders, diaphragm cylinders, impact cylinders and rodless cylinders, etc. In automated mechanical equipment, they provide power output for the machine structure, thereby realizing different movements for production operations.

[0003] In production operations, there are many different actions in mechanical equipment, and different actions may require different power outputs. At this time, different cylinders need to be selected according to specific production applications to achieve different power outputs. Therefore, different types of cylinders need to be determined according to different needs. Different cylinders require different numbers and models of auxiliary components. If they are determined manually one by one, it will take a lot of time, be inefficient, and prone to errors. Summary of the invention

[0004] The purpose of the present invention is to provide a method for automatic selection and matching of cylinders. By using the method of the present invention, the name, model, code and brand of auxiliary components can be accurately and quickly determined according to the model and quantity of the cylinders, and the number and brand of the cylinders can be accurately and quickly determined.

[0005] To achieve the above purpose, a method for automatic cylinder selection and pairing includes the following steps: S1 Classify the major categories of cylinder models and the auxiliary components required corresponding to the major categories of cylinder models into series 1, 2...n, and store the codes, names and brands corresponding to the cylinder models and the codes and brands corresponding to the auxiliary components in a database; where n≥3, the auxiliary components include solenoid valves, and the auxiliary components include first-category auxiliary components and second-category auxiliary components.

[0006] S2 Input the required cylinder model mx and the number of corresponding cylinder models y, where m represents the major category of cylinder models.

[0007] S3 matches the major categories of cylinder models in the database through m, obtains the auxiliary components corresponding to the major categories of cylinder models according to the classification of S1; and determines the quantity z of the first category of auxiliary components according to the quantity y.

[0008] S4 adds up the number of all first-category auxiliary components of the same model to obtain the total number R of first-category auxiliary components of the corresponding model.

[0009] S5 Determine the number of the second category auxiliary components; specifically: determine the number of buses according to the number of solenoid valves, determine the number of plugs, mufflers and air pipe joints according to the number of buses, and determine the number of blind plates according to the number of buses and solenoid valves.

[0010] S6 extracts the auxiliary components with quantity, name and model to form a BOM table; S7 obtains the code and brand of the corresponding auxiliary component from the database according to the model of the auxiliary component, obtains the code, name and brand of the corresponding cylinder model from the database according to the cylinder model and forms an automatic cylinder selection pairing table.

[0011] S8 stores the cylinder automatic selection pairing table.

[0012] The above method is based on a database and first determines the number of auxiliary components and first-category auxiliary components required for each cylinder model according to the cylinder model mx and the number y of corresponding cylinder models, then calculates the total number of the same model in the first-category auxiliary components, and then determines the number of second-category auxiliary components. A BOM table is formed through the above data, and then the codes and brands of the auxiliary components and the code, name and brand of the cylinder model are determined to form a cylinder automatic selection matching table; therefore, the cylinder automatic selection matching table can clearly display the name, model, code and brand of the auxiliary components required for the cylinder, and can accurately and quickly display the number and brand of the cylinder, thereby improving efficiency and reducing the error rate.

[0013] Further, in S3, the major categories of all cylinder models are arranged in column b, and columns c, d, ..., γ correspond to the models of auxiliary components corresponding to the major categories of cylinder models in column b, where γ≥4; the steps of matching the auxiliary components corresponding to the major categories of cylinder models are: S31 searches for the same value as m in column b in sequence according to m. If the first matching value is found, the value of the corresponding row in column c is returned and extracted. If an error occurs during the search process, a null value is returned.

[0014] S32 extracts the models of other auxiliary components in the corresponding columns respectively according to the method of S31.

[0015] According to the above method, the models of auxiliary components can be extracted one by one, and the accuracy of the acquired data is high.

[0016] Further, in S3, the step of determining the number z of the first type of auxiliary components based on the number y is: determining the corresponding relationship p between each cylinder model and the number of the first type of auxiliary components, searching in turn in the column where the number of cylinder models is input, if data is found, the number z of the first type of auxiliary components = y*p, if no data is found, a null value is returned. This method has high accuracy in obtaining data and is not prone to errors.

[0017] Furthermore, the specific step of S5 is: set the number of solenoid valves in the first type of auxiliary components in S4 to R1, set the number of bus bits to s, then the number of bus bits Q1 is: if R1 / s is an integer, then take the integer; if R1 / s is a non-integer, then take the integer after removing the decimal point plus 1. In this method, the number of bus bits can meet the needs of solenoid valves.

[0018] Furthermore, the number of plugs Q2=Q1*3+T-Q1, where T is the number of buses for unified gas outlet in the equipment.

[0019] Furthermore, the number of mufflers Q3 = Q1*2, and the number of air pipe joints Q4 = Q1*2.

[0020] Furthermore, the number of blind plates Q5=Q1*s-R1.

[0021] Furthermore, in S6, the quantity determined by S4 and S5 is set to be put into the W column, where the W column also includes cells with auxiliary components of 0, and the IF function is used to filter and convert the corresponding relative row number array based on the value of the cells in the W column area, and then the SMALL function is used to extract the corresponding value from this array according to the dynamically changing position, and finally the IFERROR function is used to handle the error situation, ensuring that a null value is returned when an error occurs; then the name, model and quantity of the current row number are extracted to form a BOM table. By forming a BOM table, the situation of the required auxiliary components can be clearly and intuitively seen.

[0022] Further, in S7, the corresponding auxiliary component model is found in the database according to the auxiliary component model, and the data row with the code and brand of the corresponding auxiliary component model in the database is extracted and returned as the final result. In this way, the code and brand of the auxiliary component can be quickly obtained.

[0023] Further, in S7, the corresponding cylinder model is found in the database according to the cylinder model, and the data row with the code, name and brand of the corresponding cylinder model in the database is extracted and returned as the final result. In this way, the code, name and brand of the cylinder can be quickly obtained. BRIEF DESCRIPTION OF THE DRAWINGS

[0024] Figure 1It is the work flow chart of the present invention. DETAILED DESCRIPTION

[0025] The present invention is further described in detail below with reference to the accompanying drawings and specific embodiments.

[0026] like Figure 1 As shown, the automatic cylinder selection and pairing method includes the following steps: S1 As shown in Table 1, the major categories of cylinder models and the auxiliary components required corresponding to the major categories of cylinder models are classified according to series 1, 2...n in accordance with the format of Table 1. As shown in Table 2, the codes, names and brands corresponding to the cylinder models are classified according to the format of Table 2. As shown in Table 3, the codes and brands corresponding to the auxiliary components are stored in a database in accordance with the format of Table 3; wherein n≥3, the auxiliary components include solenoid valves, and the auxiliary components include first-category auxiliary components and second-category auxiliary components. In this embodiment, the first-category auxiliary components include magnetic flux lines, speed control valves, solenoid valve connectors, solenoid valves, and bindings, and the second-category auxiliary components include busbars, plugs, mufflers, air pipe connectors, and blind plates. With respect to Tables 1, 2, and 3, the contents are not exhaustive, but merely represent an example to illustrate the technical solution of the present invention.

[0027]

[0028]

[0029]

[0030] S2 Input the required cylinder model mx and the number y of the corresponding cylinder model, where m represents the major category of the cylinder model. As shown in Table 4, assume that this embodiment requires three types of cylinders, whose models and quantities are ACQ63×10S, 2, MI40×40S, 1, MI20×20SU, 2, respectively. Enter the models and quantities into different cells, and the quantity corresponding to one model is in the same row.

[0031]

[0032] S3 matches the major categories of cylinder models in the database through m, obtains the auxiliary components corresponding to the major categories of cylinder models according to the classification of S1; and determines the quantity z of the first category of auxiliary components according to the quantity y.

[0033] In S3, the major categories of all cylinder models are arranged in column b, and columns c, d, ..., γ correspond to the models of auxiliary components corresponding to the major categories of cylinder models in column b, where γ≥4; the steps for matching the auxiliary components corresponding to the major categories of cylinder models are: S31 searches for the same value as m in column b in sequence according to m. If the first matching value is found, the value of the corresponding row in column c is returned and extracted. If an error occurs during the search process, a null value is returned.

[0034] S32 extracts the models of other auxiliary components in the corresponding columns respectively according to the method of S31.

[0035] For example: a cylinder needs to be equipped with 2 magnetic flux lines, 2 speed control valves, 2 solenoid valve connectors, 1 solenoid valve, and 2 bindings. This setting is determined according to the needs of the equipment. First, the model of the magnetic flux line is obtained according to the ACQ63×10S cylinder model, that is: in the a to γ ​​columns of Table 1 of the database, according to the model of the first row of column H of Table 4, according to the function "=IFERROR(INDEX($c$1:$c$n,MATCH(TRUE,ISNUMBER(SEARCH($b$1:$b$n,$H1)),0)),"")", the text in the $b$1 to $b$n area can be found in the current cell text. Once the first match is found, the value of the corresponding row cell in the $c$1 to $c$n area is returned and extracted. If an error occurs during the search process, a null value is returned. Use the above functions to obtain the speed control valve, solenoid valve connector, solenoid valve, binding tape and other models corresponding to the current cylinder model in turn.

[0036] In S3, the step of determining the number z of the first category of auxiliary components based on the number y is: determine the corresponding relationship p between each cylinder model and the number of the first category of auxiliary components. In this embodiment, the corresponding relationship between each cylinder model and the number of the first category of auxiliary components is: one cylinder needs to be equipped with 2 magnetic flux lines, 2 speed control valves, 2 solenoid valve connectors, 1 solenoid valve, and 2 bindings. Search in sequence in the column where the number of cylinder models is input. If data is found, the number of the first category of auxiliary components z=y*p. If no data is found, a null value is returned.

[0037] For example, use the function "=IF(J1="","",$J1*2)". The meaning of the current function is: if the value of cell J1 is null (no content), then return null; if cell J1 has a specific value, multiply the value by 2 and return the corresponding result. Use this formula to calculate the number of accessories that the current cylinder will use based on the number of current models in column J and the number of parts that each cylinder will use. The above J1 refers to the first row of column J in table 4.

[0038] The above method can be used to obtain the values ​​shown in Table 5. Table 5 is only an example and is only used to illustrate the above method.

[0039]

[0040] Table 5 S4 Add the quantity of all the first-class auxiliary components of the same model to obtain the total number R of the first-class auxiliary components of the corresponding model. For example: in columns BA to BC of Table 3, add the quantity of each model according to the scattered data in columns A1 to A7 of Table 4; in columns BA to BC of Table 3, use "=SUMIF($A1$1:$A1$n,$KBB,$A4$1:$A4$n) "The function searches $A1$1:$A1$n. If the data in BB1 appears, the data in $A4$1:$A4$n is added to get the total number of auxiliary components. The n in S4 represents the data in the nth row of Table 5. This is shown in the example in Table 6 below.

[0041]

[0042] S5 Determine the number of the second category auxiliary components; specifically: determine the number of buses according to the number of solenoid valves, determine the number of plugs, mufflers and air pipe joints according to the number of buses, and determine the number of blind plates according to the number of buses and solenoid valves.

[0043] In S5, the number of solenoid valves in the first type of auxiliary components in S4 is set to R1, and the number of bus bits is set to s. Then the number of bus bits Q1 is: if R1 / s is an integer, then the integer is taken; if R1 / s is a non-integer, then the integer after the decimal point is removed plus 1. For example: (1) The number of solenoid valves obtained in S4 is 20, and the number of bus bits is 10, so 20 / 10=2, so 2 bus bits are required.

[0044] (2) Assuming that the number of solenoid valves obtained in S4 is 22 and the number of bus bits is 10, then 22 / 10=2.2, and 2+1=3 bus bits are required.

[0045] (3) Assume that the number of solenoid valves obtained in S4 is 9 and the number of bus bits is 10, then 9 / 10=0.9, and 0+1=1 bus bits are required.

[0046] The number of plugs Q2=Q1*3+T-Q1, where T is the number of buses for unified gas outlet in the equipment, and the 3 in the formula is set according to needs.

[0047] The number of silencers Q3 = Q1*2, and the number of air pipe joints Q4 = Q1*2. The 2 in the formula is set according to needs.

[0048] The number of blind plates Q5=Q1*s-R1.

[0049] S6 extracts the auxiliary components with quantity, name and model to form a BOM table.

[0050] S7 obtains the code and brand of the corresponding auxiliary component from the database according to the model of the auxiliary component, obtains the code, name and brand of the corresponding cylinder model from the database according to the cylinder model and forms an automatic cylinder selection pairing table.

[0051] S8 stores the cylinder automatic selection pairing table.

[0052] The above method is based on a database and first determines the number of auxiliary components and first-category auxiliary components required for each cylinder model according to the cylinder model mx and the number y of corresponding cylinder models, then calculates the total number of the same model in the first-category auxiliary components, and then determines the number of second-category auxiliary components. A BOM table is formed through the above data, and then the codes and brands of the auxiliary components and the code, name and brand of the cylinder model are determined to form a cylinder automatic selection matching table; therefore, the cylinder automatic selection matching table can clearly display the name, model, code and brand of the auxiliary components required for the cylinder, and can accurately and quickly display the number and brand of the cylinder, thereby improving efficiency and reducing the error rate.

Claims

1. A method for automatic selection and pairing of cylinders, characterized in that: The following steps are involved: S1 Classify the cylinder models and the auxiliary components required by the cylinder models according to series 1, 2, ...n, and store the codes, names and brands corresponding to the cylinder models and the codes and brands corresponding to the auxiliary components in a database; where n≥3, the auxiliary components include solenoid valves, and the auxiliary components include first-category auxiliary components and second-category auxiliary components; S2 Input the required cylinder model mx and the number of corresponding cylinder models y, where m represents the major category of cylinder models; S3 matches the major category of cylinder models in the database through m, obtains the auxiliary components corresponding to the major category of cylinder models according to the classification of S1; determines the number z of the first category of auxiliary components according to the number y; S4. Add the number of all first-category auxiliary components of the same model to obtain the total number R of first-category auxiliary components of the corresponding model; S5 Determine the number of the second category auxiliary components; specifically: determine the number of busbars according to the number of solenoid valves, determine the number of plugs, mufflers and air pipe joints according to the number of busbars, and determine the number of blind plates according to the number of busbars and solenoid valves; S6 extracts the auxiliary components with quantity, name and model to form a BOM table; S7 obtains the code and brand of the corresponding auxiliary component from the database according to the model of the auxiliary component, obtains the code, name and brand of the corresponding cylinder model from the database according to the cylinder model and forms an automatic cylinder selection pairing table; S8 stores the cylinder automatic selection pairing table.

2. The method for automatic cylinder selection and pairing according to claim 1, characterized in that: In S3, the major categories of all cylinder models are arranged in column b, and columns c, d, ..., γ correspond to the models of auxiliary components corresponding to the major categories of cylinder models in column b, where γ≥4; the steps for matching the auxiliary components corresponding to the major categories of cylinder models are: S31 Search for the same value as m in column b in sequence according to m. If the first matching value is found, return the value of the corresponding row in column c and extract it. If an error occurs during the search process, return a null value. S32 extracts the models of other auxiliary components in the corresponding columns respectively according to the method of S31.

3. A method for automatic cylinder selection and pairing according to claim 1 or 2, characterized in that: In S3, the step of determining the quantity z of the first category of auxiliary components based on the quantity y is: determine the corresponding relationship p between each cylinder model and the quantity of the first category of auxiliary components, and search in turn in the column where the quantity of cylinder models is input. If data is found, the quantity z of the first category of auxiliary components = y*p. If no data is found, a null value is returned.

4. The method for automatic cylinder selection and pairing according to claim 1, characterized in that: The specific steps of S5 are: set the number of solenoid valves in the first type of auxiliary components in S4 to R1, set the number of bits of the bus to s, then the number of buses Q1 is: if R1 / s is an integer, then take the integer; if R1 / s is a non-integer, then take the integer after removing the decimal point plus 1.

5. The method for automatic cylinder selection and pairing according to claim 4, characterized in that: The number of plugs Q2=Q1*3+T-Q1, where T is the number of buses for unified gas outlet in the equipment.

6. The method for automatic cylinder selection and pairing according to claim 4, characterized in that: The number of mufflers Q3 = Q1*2, the number of air pipe joints Q4 = Q1*2.

7. The method for automatic cylinder selection and pairing according to claim 4, characterized in that: The number of blind plates Q5=Q1*s-R1.

8. The method for automatic cylinder selection and pairing according to claim 1, characterized in that: In S6, the quantities determined by S4 and S5 are set to be placed in column W, where column W also includes cells with auxiliary components set to 0. The IF function is used to filter and convert the corresponding relative row number array based on the values ​​of the cells in the W column area. The SMALL function is then used to extract the corresponding values ​​from the array according to the dynamically changing positions. Finally, the IFERROR function is used to handle errors to ensure that a null value is returned when an error occurs. The name, model, and quantity of the current row number are then extracted to form a BOM table.

9. The method for automatic cylinder selection and pairing according to claim 1, characterized in that: In S7, the corresponding auxiliary component model is found in the database according to the auxiliary component model, and the data row with the code and brand of the corresponding auxiliary component model in the database is extracted and returned as the final result.

10. The method for automatic cylinder selection and pairing according to claim 1, characterized in that: In S7, the corresponding cylinder model is found in the database according to the cylinder model, and the data row with the code, name and brand of the corresponding cylinder model in the database is extracted and returned as the final result.

Images