Automatic calculation and inspection method for process quota material

Abstract

The invention discloses an automatic calculation and inspection method for a process quota material, and the method comprises the following steps: S1, building a material code selection basic database, and constructing a combination unit calculation formula; s2, selecting data in a basic database based on the material codes, and performing calculation according to a combination unit calculation formula to obtain a material combination unit value; s3, selecting a basic database and a material combination unit value according to the material codes to obtain a BOM table; s4, constructing a process quota formula according to the BOM table, and obtaining a process quota material value through the process quota formula; and S5, checking according to a process quota material value, a material code, a material description, a repeated code replacement relationship, a unit and a material combination unit value through a BOM table. Through cooperative application of a database and a calculation formula, a process quota material value is automatically calculated, errors are checked, the accuracy and matching degree of codes and materials are improved, the accuracy is high, and the efficiency is high.

Description

Technical Field

[0001] The invention belongs to the technical field of automated production management, and in particular relates to an automatic calculation and inspection method for process quota materials. Background Art

[0002] In production management, process quota refers to the quantity standard of normal raw material consumption that should be achieved during the production and processing process. Completing the process quota material BOM table is an indispensable link. The accuracy of the BOM table information directly affects all subsequent product production and manufacturing links.

[0003] The traditional method is for technicians to determine the part material and specifications based on the drawings, select the material code, determine the cutting size, the number of parts that can be produced, etc., and manually calculate the material quota item by item. This has the following problems:

[0004] 1. The design drawings are from different eras, and the new and old material grades are represented in different ways, so the material coding selection often has duplicate or wrong codes;

[0005] 2. Material quota calculations are only related to the part's material density, specifications, blanking dimensions, and the number of parts that can be produced. They are not related to the material code. If there is a problem with the material code, the BOM information will be inaccurate and prone to errors. For example, if the material code unit is incorrect, the process requires 10 meters of φ1 copper wire, and the actual BOM data entered is 10 kilograms, but the process requires one piece of 20mm×20mm wool felt, the actual BOM data entered is 1 kilogram.

[0006] 3. The imported BOM table is missing items. For example, the material code in the BOM table is sheet material, but the blanking size is bar material, and the blanking size and the number of pieces that can be produced are missing.

[0007] 4. Materials are divided into sheets, bars, profiles, finished parts, blanks, etc. Different materials have different calculation formulas, which takes a long time to calculate, is inefficient, and prone to errors. Summary of the Invention

[0008] In order to solve the above technical problems, the present invention provides a method for automatically calculating and checking process quota materials.

[0009] The present invention is achieved through the following technical solutions.

[0010] The present invention provides a method for automatically calculating and checking process quota materials, comprising the following steps:

[0011] S1. Establish a basic database for material coding selection and construct a combination unit calculation formula. The content of the basic database for material coding selection includes material code, material description, density, specification, blanking size and repeated code replacement relationship. The combination unit calculation formula is used to generate the material combination unit value, including Kg / m calculation formula and Kg / m2 Calculation formula, the blanking size includes length and width;

[0012] S2. Select the data in the basic database based on the material code and calculate according to the combination unit calculation formula to obtain the material combination unit value;

[0013] S3. Obtain a BOM table based on the material code, selecting a basic database and a material combination unit value. The BOM table includes information such as material code, material description, unit, number of parts that can be produced, density, specification, blanking size, and material combination unit value.

[0014] S4. Construct a process quota formula based on the BOM table and obtain the process quota material value through the process quota formula;

[0015] S5. Check the BOM table according to the process quota material value, material code, material description, duplicate code replacement relationship, unit and material combination unit value to ensure that the process quota material value is accurate and valid.

[0016] Preferably, the Kg / m calculation formula includes: a round bar calculation formula, a hexagonal steel bar calculation formula, an octagonal steel calculation formula, a square steel calculation formula, an equilateral angle steel calculation formula, a round steel pipe calculation formula, a rectangular tube calculation formula, an I-beam calculation formula and a channel steel calculation formula.

[0017] Preferably, the Kg / m 2 The calculation formulas include: sheet material calculation formula.

[0018] Preferably, the material coding is imported into an Excel table by selecting a basic database and material combination unit value and importing it by referencing a formula.

[0019] Preferably, the determination rule of the process quota formula is: if And the unit is Kg, then the process quota calculation formula is if And the unit is Kg, then the process quota calculation formula is if And the unit is m 2 , then the process quota calculation formula is if And the unit is m, then the process quota calculation formula is Otherwise, the process quota calculation formula returns an error.

[0020] Preferably, the step S5, checking the material value, material code, material description, duplicate code replacement relationship, unit and material combination unit value through the BOM table, includes the following steps:

[0021] S51. Determine the content of the process quota material value cell in the BOM table. If it is wrong, proceed to step S52. Otherwise, end or maintain the basic database for material coding selection.

[0022] S52. Construct a material description search reference formula, a unit search reference formula, and a combined unit search reference formula;

[0023] S53. Obtain the material description search result using the material description search reference formula and determine if the material description search result is a material description. If not, proceed to step S54. Otherwise, perform duplicate code replacement or maintain the material coding selection base database.

[0024] S54. Obtain the unit search result through the unit search reference formula, and determine the unit search result content. If it is Kg, proceed to step S55. Otherwise, check the blanking size and the number of pieces that can be produced or modify the process quota material value.

[0025] S55. Obtain the combined unit search result through the combined unit search reference formula, and judge the combined unit search result content. If Kg / m 2 >0, Kg / m = 0 or Kg / m 2 =0, Kg / m>0, then check the material code, blanking size and number of pieces that can be made. If Kg / m 2 >0, Kg / m>0, then maintain the material code using the basic database.

[0026] Preferably, in said S51, otherwise ending or maintaining the material coding selection basic database specifically refers to:

[0027] If the cell content of the process quota material value is the display value, then the process ends; if it is empty, maintain the material code and select the material code in the basic database.

[0028] Preferably, in said S53, otherwise performing duplicate code replacement or maintaining the material code selection basic database specifically refers to:

[0029] Determine the content of the material description search result. If it is a material code, replace the duplicate code; if it is empty, maintain the material code and select the material code in the basic database.

[0030] Preferably, in said S54, otherwise, the blanking size and the number of pieces that can be produced are checked or the process quota material value is modified:

[0031] Determine the unit search result content, if it is m or m 2 , then check the cutting size and the number of pieces that can be produced; if it is pieces or pieces, modify the process quota material value to 1.

[0032] The beneficial effects of the present invention are:

[0033] 1. The present invention realizes the automatic calculation and inspection of process quota materials, and is suitable for automatic inspection before the calculation and ERP entry of process quota materials, replacing the traditional manual compilation of process quota materials and manual inspection of ERP entry information, thereby reducing manual operation, manual inspection and other processes, thereby achieving the purpose of rapid calculation and accurate inspection of such quota materials.

[0034] 2. Through the application of database and calculation formula, the process quota material value is automatically calculated, the error is checked, and the accuracy and matching degree of coding and materials are improved, with high accuracy and efficiency. BRIEF DESCRIPTION OF THE DRAWINGS

[0035] Figure 1 This is a flow chart of a method for automatically calculating and checking process quota materials provided by an embodiment of the present invention;

[0036] Figure 2 This is a diagram of the inspection principle provided by an embodiment of the present invention. DETAILED DESCRIPTION

[0037] The technical solution of the present invention is further described below, but the scope of protection claimed is not limited to the description.

[0038] like Figure 1 As shown, a method for automatically calculating and checking process quota materials includes the following steps:

[0039] S1. Establish a basic database for material coding selection and construct a combination unit calculation formula. The content of the basic database for material coding selection includes material code, material description, density, specification, blanking size and repeated code replacement relationship. The combination unit calculation formula is used to generate the material combination unit value, including Kg / m calculation formula and Kg / m 2 Calculation formula, the blanking size includes length and width;

[0040] The Kg / m calculation formula includes: round bar calculation formula, hexagonal steel bar calculation formula, octagonal steel calculation formula, square steel calculation formula, equilateral angle steel calculation formula, round steel pipe calculation formula, rectangular tube calculation formula, I-beam calculation formula and channel steel calculation formula.

[0041] Kg / m 2 The calculation formulas include: sheet material calculation formula.

[0042] Among them, Kg / m calculation formula and Kg / m 2 The specific expression of the calculation formula is shown in the following table:

[0043]

[0044]

[0045] S2. Select data from the basic database based on the material code, and calculate according to the combined unit calculation formula to obtain the material combined unit value;

[0046] S3. Obtain the BOM table according to the material code by selecting the basic database and the material combined unit value. The information of the BOM table includes material code, material description, unit, number of parts that can be manufactured, density, specification, cutting size, and material combined unit value;

[0047] In this embodiment, the BOM table further includes: net weight, gross weight, and drawing number, which are also used as parameters of the material. By importing the basic database selected by the material code into an Excel table, an Excel version of the BOM table is obtained.

[0048] Among them, the basic database selected by the material code and the material combined unit value are imported into the Excel table by using a reference formula.

[0049] S4. Construct a process quota formula according to the BOM table, and obtain the process quota material value through the process quota formula;

[0050] The determination rule of the process quota formula is: If and the unit is Kg, the process quota calculation formula is If and the unit is Kg, the process quota calculation formula is If and the unit is m 2 , the process quota calculation formula is If and the unit is m, the process quota calculation formula is Otherwise, the process quota calculation formula returns an error.

[0051] In this embodiment, the BOM table is an Excel table, and the expression of the process quota formula is as follows:

[0052] IFERROR(IF(AND(㎏ / ㎡*length*width / number of parts that can be manufactured / <1000000>0, unit

[0053] ="KG"),㎏ / ㎡*length*width / number of parts that can be manufactured / 1000000,IF(AND(AA1*length / number of parts that can be manufactured / 1000>0, unit="KG"),AA1*length / number of parts that can be manufactured / 1000,IF(AND(length*width / number of parts that can be manufactured / <1000000>0, unit="M2"),length*width / number of parts that can be manufactured / 1000000,IF(AND(length / number of parts that can be manufactured / 1000>0, unit="M"),length / number of parts that can be manufactured / 1000,"error")))),"") <0000l49>

[0054] Among them, IFERROR is an error check function used to check whether there are errors in the material code. The IF function is used to determine whether there are errors in the material code and material description, and select the corresponding calculation formula. The AND function is used to determine whether the material combination unit value and unit correspond. AA1 represents the Kg / m value.

[0055] In the BOM table, you only need to pull down and fill in the process quota formula in the process quota material value cell to automatically calculate the process quota material value.

[0056] S5. Check the BOM table according to the process quota material value, material code, material description, duplicate code replacement relationship, unit and material combination unit value to ensure that the process quota material value is accurate and valid.

[0057] like Figure 2 As shown, the S5, checking according to the process quota material value, material code, material description, duplicate code replacement relationship, unit and material combination unit value through the BOM table, includes the following steps:

[0058] S51. Determine the content of the process quota material value cell in the BOM table. If it is wrong, proceed to step S52. Otherwise, end or maintain the basic database for material coding selection.

[0059] In the above S51, otherwise, ending or maintaining the material coding selection basic database specifically refers to:

[0060] If the cell content of the process quota material value is the display value, then the process ends; if it is empty, maintain the material code and select the material code in the basic database.

[0061] According to the process quota formula, the process quota material value cell in the BOM table can have three possible results. If a value is displayed in the process quota material value cell, it is correct and the process ends. If there is no content in the process quota material value cell, it means that the material code does not exist and the material code needs to be maintained, using the material code in the basic database. If the result is incorrect, it is necessary to proceed to step S52 for further inspection.

[0062] S52. Construct a material description search reference formula, a unit search reference formula, and a combined unit search reference formula;

[0063] S53. Obtain the material description search result using the material description search reference formula and determine if the material description search result is a material description. If not, proceed to step S54. Otherwise, perform duplicate code replacement or maintain the material coding selection base database.

[0064] In the above S53, if not, performing duplicate code replacement or maintaining the material code selection basic database specifically refers to:

[0065] Determine the content of the material description search result. If it is a material code, replace the duplicate code; if it is empty, maintain the material code and select the material code in the basic database.

[0066] In the BOM table, the material description cell can display three results. If the material description cell displays a material code, it means the previously selected material code is a duplicate and needs to be replaced with a new material code. If the material description cell is blank, the material code needs to be maintained and selected from the basic database. If it is a material description, proceed to step S54 for further inspection.

[0067] S54. Obtain the unit search result through the unit search reference formula, and determine the unit search result content. If it is Kg, proceed to step S55. Otherwise, check the blanking size and the number of pieces that can be produced or modify the process quota material value.

[0068] In the above S54, if not, check the blanking size and the number of pieces that can be produced or modify the process quota material value:

[0069] Determine the unit search result content, if it is m or m 2 , then check the cutting size and the number of pieces that can be produced; if it is pieces or pieces, modify the process quota material value to 1.

[0070] In the BOM table, five results are displayed in the unit cell.

[0071] When the unit is m, the parameters of this material should be: length>0, width=0, number of pieces that can be produced>0. If there is any difference, it means that the cutting size or the number of pieces that can be produced is incorrect and needs to be checked.

[0072] When the unit is m 2 The parameters of this material should be: length>0, width>0, number of pieces that can be produced>0. If there are any differences, it means that the blanking size or the number of pieces that can be produced is incorrect and needs to be checked.

[0073] When the unit is piece or unit, the process quota material value will be modified to 1.

[0074] S55. Obtain the combined unit search result through the combined unit search reference formula, and judge the combined unit search result content. If Kg / m 2 >0, Kg / m = 0 or Kg / m 2 =0, Kg / m>0, then check the material code, blanking size and number of pieces that can be made. If Kg / m 2 >0, Kg / m>0, then maintain the material code using the basic database.

[0075] When the unit is Kg, and Kg / ㎡>0, Kg / m=0, the parameters of this material should be length>0, width>0, and number of pieces that can be produced>0. If there are any differences, it means that the material code, cutting size or number of pieces that can be produced may be incorrect and needs to be checked.

[0076] When the unit is Kg, Kg / ㎡=0, Kg / m>0, the parameters of this material should be length>0, width=0, number of pieces that can be produced>0. If there are any differences, it means that the material code, cutting size or number of pieces that can be produced may be incorrect and needs to be checked.

[0077] When the unit is Kg, if Kg / ㎡>0, Kg / m>0, the database is wrong and needs to be maintained.

[0078] The present invention realizes the automatic calculation and inspection of process quota materials, and is suitable for automatic inspection before the calculation and ERP entry of process quota materials, replacing the traditional method of manually compiling process quota materials and manually checking ERP entry information, thereby reducing manual operations, manual inspections and other processes, thereby achieving the purpose of rapid calculation and accurate inspection of such quota materials; through the coordinated application of databases and calculation formulas, the process quota material values ​​are automatically calculated, errors are checked, and the accuracy and matching degree of coding and materials are improved, with high accuracy and efficiency.

Claims

1. A method for automatically calculating and checking process quota materials, characterized in that: The following steps are involved: S1. Establish a basic database for material coding selection and construct a combination unit calculation formula. The content of the basic database for material coding selection includes material coding, material description, density, specification, material size and repeated code replacement relationship. The combination unit calculation formula is used to generate material combination unit value, including Kg / m calculation formula and Kg / m 2 Calculation formula, the cutting size includes length and width; S2. Select the data in the basic database based on the material code, calculate according to the combination unit calculation formula, and obtain the material combination unit value; S3. According to the material code, a basic database and a material combination unit value are selected to obtain a BOM table, wherein the information of the BOM table includes material code, material description, unit, number of pieces that can be manufactured, density, specification, blanking size and material combination unit value; S4. Construct a process quota formula according to the BOM table, and obtain the process quota material value through the process quota formula; S5. Check the process quota material value, material code, material description, duplicate code replacement relationship, unit and material combination unit value through the BOM table to ensure that the process quota material value is accurate and valid.

2. The automatic calculation checking method according to claim 1, characterized in that: The Kg / m calculation formula includes: a round bar calculation formula, a hexagonal steel bar calculation formula, an octagonal steel calculation formula, a square steel calculation formula, an equilateral angle steel calculation formula, a round steel pipe calculation formula, a rectangular tube calculation formula, an I-beam calculation formula and a channel steel calculation formula.

3. The automatic calculation checking method according to claim 1, characterized in that: Kg / m 2 The calculation formulas include: sheet material calculation formula.

4. The automatic calculation checking method according to claim 1, characterized in that: The determination rule of the process quota formula is: if And the unit is Kg, then the process quota calculation formula is: if And the unit is Kg, then the process quota calculation formula is: if And the unit is m 2 , then the process quota calculation formula is if And the unit is m, then the process quota calculation formula is Otherwise, the process quota calculation formula returns an error.

5. The automatic calculation checking method according to claim 1, characterized in that: The S5, checking according to the process quota material value, material code, material description, duplicate code replacement relationship, unit and material combination unit value through the BOM table, includes the following steps: S51, judging the content of the process quota material value cell in the BOM table, if it is wrong, proceeding to step S52, otherwise ending or maintaining the basic database for material coding selection; S52. Construct a material description search reference formula, a unit search reference formula, and a combined unit search reference formula; S53, obtain the material description search result through the material description search reference formula, judge the material description search result, if it is a material description, go to step S54, otherwise, replace the duplicate code or maintain the material code selection basic database; S54, obtain the unit search result through the unit search reference formula, and judge the content of the unit search result. If it is Kg, go to step S55, otherwise check the blanking size and the number of pieces that can be produced or modify the process quota material value; S55. Obtain the combined unit search result through the combined unit search reference formula, and determine the combined unit search result content. If Kg / m 2 >0, Kg / m = 0 or Kg / m 2 =0, Kg / m>0, then check the material code, material size and number of pieces that can be produced. If Kg / m 2 >0, Kg / m>0, then maintain the material code using the basic database.

6. The automatic calculation checking method according to claim 5, characterized in that: In the S51, otherwise, ending or maintaining the material coding selection basic database specifically refers to: If the cell content of the process quota material value is the display value, then end; if it is empty, maintain the material code and select the material code in the basic database.

7. The automatic calculation checking method according to claim 5, characterized in that: In the above S53, otherwise, performing duplicate code replacement or maintaining the material code selection basic database specifically refers to: Determine the content of the material description search result. If it is a material code, replace the duplicate code; if it is empty, maintain the material code and select the material code in the basic database.

8. The automatic calculation checking method according to claim 5, characterized in that: In S54, otherwise, check the blanking size and the number of pieces that can be produced or modify the process quota material value: Determine the unit search result content, if it is m or m 2 , then check the cutting size and the number of pieces that can be produced; if it is pieces or pieces, modify the process quota material value to 1.

Images