CN111190951B - Production auxiliary material plan generation method based on EXCEL form - Google Patents
Production auxiliary material plan generation method based on EXCEL form Download PDFInfo
- Publication number
- CN111190951B CN111190951B CN201911258075.9A CN201911258075A CN111190951B CN 111190951 B CN111190951 B CN 111190951B CN 201911258075 A CN201911258075 A CN 201911258075A CN 111190951 B CN111190951 B CN 111190951B
- Authority
- CN
- China
- Prior art keywords
- width
- square tube
- cold
- excel
- plan
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Active
Links
- 239000000463 material Substances 0.000 title claims abstract description 37
- 238000004519 manufacturing process Methods 0.000 title claims abstract description 26
- 238000000034 method Methods 0.000 title claims description 21
- 238000012856 packing Methods 0.000 claims abstract description 39
- 238000005452 bending Methods 0.000 claims abstract description 34
- 238000004806 packaging method and process Methods 0.000 claims abstract description 25
- 239000002994 raw material Substances 0.000 claims abstract description 8
- 239000002671 adjuvant Substances 0.000 claims 1
- 235000021384 green leafy vegetables Nutrition 0.000 description 4
- 238000010586 diagram Methods 0.000 description 2
- 229910000831 Steel Inorganic materials 0.000 description 1
- 230000009286 beneficial effect Effects 0.000 description 1
- 230000007547 defect Effects 0.000 description 1
- 238000000605 extraction Methods 0.000 description 1
- 238000002360 preparation method Methods 0.000 description 1
- 239000010959 steel Substances 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/25—Integrating or interfacing systems involving database management systems
- G06F16/254—Extract, transform and load [ETL] procedures, e.g. ETL data flows in data warehouses
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2455—Query execution
- G06F16/24553—Query execution of query operations
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Databases & Information Systems (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Computational Linguistics (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention provides an EXCEL-form-based auxiliary material plan generation method for production, which comprises the following steps of: reading the specification, thickness, applicable standard and plan tonnage of the cold-bending square tube; inquiring by taking the standard number and the cold bending square tube specification as keywords, and importing the corresponding packaging mode result of the inquiring into a corresponding form of a working interface; extracting information height, width and thickness of a product according to the specification of the cold-bending square tube, and calculating the width of the raw material corresponding to the cold-bending square tube according to the information of the height, the width and the thickness; calculating the specification of the packing card according to the packing mode and the height and width information of the cold-bending square tube; calculating the number of packaging cards according to the width of the raw materials, the packaging mode and the planned tonnage; and storing the cold bending square tube specification, the packing card specification and the packing card number information into a summary table in the EXCEL by one key to generate a special auxiliary material planning sheet. The invention has the advantages of high efficiency and low error rate, and solves the problem that special personnel are required to compile auxiliary material plans for production.
Description
Technical Field
The invention relates to the field of steel production plans, in particular to an EXCEL-form-based auxiliary material plan generation method for production.
Background
The cold-bending square tube has a plurality of specifications, and thousands of specifications. In order to meet the diversified demands of customers, products are continuously developed, and the number of specifications is continuously increased. The cold-bending square tube has more auxiliary materials required in the production process, and certain special auxiliary materials (products with different specifications have different requirements on the specifications of the auxiliary materials, and the auxiliary materials are special auxiliary materials) do not have a large number of stocking conditions, so that the production of the cold-bending square tube products can be smoothly carried out according to the production sequence of each cold-bending square tube product in the production plan.
At present, the auxiliary material preparation for the cold-bending square tube product mainly adopts the following method:
according to the production plan of the cold-bending square tube, manually searching the specifications of special auxiliary materials used in the past production record one by one; and calculating the planned quantity of the special auxiliary material according to the planned production quantity of each specification.
Because the number of planned specifications per week can reach hundreds, the two steps are all required to arrange special posts for manual inquiry records and calculate the quantity of special auxiliary materials. And the manual inquiry and calculation processes have a larger error risk. Therefore, it is necessary to invent a method for automatically completing the special auxiliary material generation plan by a computer. .
Disclosure of Invention
Aiming at the defects of the prior art, the invention provides an EXCEL-form-based auxiliary material plan generation method for production, which has the advantages of high efficiency and low error rate, and solves the problem that special persons are required to compile an auxiliary material plan for production.
The invention provides an EXCEL-form-based auxiliary material plan generation method for production, which is characterized by comprising the following steps of:
step 1, reading the specification, thickness, applicable standard and plan tonnage of a cold-bent square tube
Step 2, inquiring by taking the standard number and the cold bending square tube specification as keywords, and importing the corresponding packaging mode result of the inquiry into a corresponding form of a working interface;
step 3, extracting the information height, width and thickness of the product according to the specification of the cold-bending square tube, calculating the width of the raw material corresponding to the cold-bending square tube according to the information of the height, width and thickness, and filling the information into a corresponding form of a working interface;
step 4, calculating the specification of the packing card according to the packing mode and the height and width information of the cold-bending square tube, and automatically filling the specification of the packing card into the corresponding position of the working interface; calculating the number of the packing cards according to the width of the raw materials, the packing mode and the plan tonnage, and automatically filling the number into the corresponding position of the working interface;
and 5, storing the cold bending square tube specification, the packing card specification and the packing card number information into a summary table in the EXCEL by one key, and generating a special auxiliary material plan list.
In the technical scheme, in the step 1, all cold bending square tube specifications are classified according to the standards of products and the EXCEL documents are recorded, and the standard numbers are used as the table names of the worksheets; all packing modes of the cold-bending square tube specifications are arranged according to standards, and the EXCEL document is input through structured data.
In the above technical solution, step 2 includes the following steps:
identifying the total number M of specifications filled by a user according to the specifications, tonnage and standard of the user filled in an EXCEL 'plan' workbook; setting circulation conditions according to the total number of specifications, and completing the following queries one by one from the 1 st specification to the M th specification:
and according to the "specification", "standard" input by the user, inquiring the "count per layer" and the "layer number" of the corresponding specification in the workbook named by the standard number, and filling the two data into the corresponding "count per layer" and "layer number" in the "planning" workbook.
In the above technical scheme, step 3 identifies the "specification" content filled in the EXCEL "plan" workbook by the user, and breaks down the "high-by-wide-by-thick" character string into three data of "high", "wide" and "thick" respectively filling in the corresponding positions; the width of the expansion of the cross section of the product section is calculated according to the data of the height, the width and the thickness.
In the above technical solution, the calculating the packing card specification in step 4 includes the following steps: identifying the total number M of specifications filled by a user according to the specifications, tonnage and standard of the user filled in an EXCEL 'plan' workbook; setting a circulation condition according to the total number of specifications, completing calculation of the width and the width of the packaging card one by one from the 1 st specification to the M th specification, and filling a calculation result into a corresponding position of the packaging card specification in a plan workbook in a format of the packaging card width and the packaging card height; wherein, package card width = count per layer product height +5; pack card height = number of layers +5 per layer width.
In the above technical solution, the calculating the number of the package cards in the step 4 includes the following steps: setting a circulation condition according to the total number of specifications, calculating the number of the packaging cards one by one from the 1 st specification to the M th specification, and filling the calculation result into the corresponding position of the number of the packaging cards in the plan workbook; wherein, the number of packed cards = tonnage/(spread thickness 2000 x 7.85/109 x number of counts per layer x number of layers).
In the process of planning auxiliary materials, the traditional mode of manually inquiring and calculating the specification and the dosage of the auxiliary materials according to the production scheduling plan is abandoned, and the method for automatically inquiring and calculating the specification and the dosage of the auxiliary materials by writing the code of the EXCEL macro file of the computer is innovatively provided. The method has the advantages of high efficiency and low error rate, and solves the problem that special personnel are required to compile auxiliary material plans for production.
Drawings
FIG. 1 is a schematic diagram of a packaging card of the present invention;
FIG. 2 is a schematic flow chart of the present invention;
fig. 3 is a schematic diagram of an application of the present invention.
Detailed Description
The invention will now be described in further detail with reference to the drawings and specific examples, which are given for clarity of understanding and are not to be construed as limiting the invention.
As shown in the figure, the invention provides an EXCEL-form-based auxiliary material plan generation method for production, aiming at the problems of the method for preparing special auxiliary materials required in the production process of the cold-bent square tube product.
The method specifically comprises the following steps:
1. classifying all cold bending square tube specifications according to product standards, inputting EXCEL documents, and taking standard numbers as worksheet names;
2. and (3) sorting the packaging modes of all the cold-bending square tube specifications in the step (1) according to the distinguishing standard, and inputting the EXCEL document by using structured data.
3. Through EXCEL macro code, the following functions are realized.
(1) And inquiring by taking the standard number and the cold bending square tube specification as keywords, and importing the corresponding packaging mode result of the inquiring into a corresponding table of the working interface.
The specific implementation method comprises the following steps:
step one: identifying the total number M of specifications filled by a user according to the specifications, tonnage and standard of the user filled in an EXCEL 'plan' workbook;
step two: the following inquiry is completed one by setting the circulation conditions according to the total number of specifications from the 1 st specification to the M th specification.
And according to the "specification", "standard" input by the user, inquiring the "count per layer" and the "layer number" of the corresponding specification in the workbook named by the standard number, and filling the two data into the corresponding "count per layer" and "layer number" in the "planning" workbook.
RowCount＝Sheets(1).[A90000].End(xlUp).Row
For i＝2 To RowCount
For j＝2 To Sheets(Sheets(1).Range("C"&i).Value).[A90000].End(xlUp).Row
If Sheets(1).Range("A"&i).Value＝Sheets(Sheets(1).Range("C"&i).Value).Range("A"&j).Value&"*"&Sheets(Sheets(1).Range("C"&i).Value).Range("B"&j).Value Then
Sheets(1).Range("D"&i).Value＝Sheets(Sheets(1).Range("C"&i).Value).Range("E"&j).Value
Sheets(1).Range("E"&i).Value＝Sheets(Sheets(1).Range("C"&i).Value).Range("F"&j).Value
End If
Next j
Next i
(2) And extracting the information height, width and thickness of the product according to the specification of the cold-bending square tube, calculating the width of the raw material corresponding to the cold-bending square tube according to the information of the height, width and thickness, and filling the information into a corresponding form of a working interface.
The specific implementation method comprises the following steps:
step one: and (3) identifying the content of the specification filled in the EXCEL 'plan' workbook according to the user, and disassembling the character string of the high-width thickness into three data of the high-width thickness and the thickness, and filling the three data into corresponding positions respectively.
Step two: the width (spread) of the product cross-section expansion was calculated from the "height", "width", "thickness" data.
Spread = high x 2+ wide x 2-6 x thickness
sArray＝Sheets(1).Range("A"&i).Value
If Mid$(sArray,1,1)＝"F"Or Mid$(sArray,1,1)＝"J"Then
r1＝1
r2＝0
r3＝0
For isarry＝1 To Len(sArray)
If Mid$(sArray,isarry,1)＝"*"Then
If r2＝0 And r3＝0 Then
r2＝isarry
Else
r3＝isarry
End If
End If
Next isarry
Sheets(1).Range("F"&i).Value＝CDbl(Mid$(sArray,r1+1,r2-1-r1))
Sheets(1).Range("G"&i).Value＝CDbl(Mid$(sArray,r2+1,r3-1-r2))
Sheets(1).Range("H"&i).Value＝CDbl(Mid$(sArray,r3+1,Len(sArray)-r3))
Sheets(1).Range("I"&i).Value＝Format(2*Sheets(1).Range("F"&i).Value+2*Sheets(1).Range("G"&i).Value-6*Sheets(1).Range("H"&i).Value,"#.00")
End If
(3) And (3) calculating the specification of the packing card according to the packing mode in the step (1) and the height and width information of the cold-bending square tube in the step (2), and automatically filling the specification of the packing card into the corresponding position of the working interface.
The specific implementation method comprises the following steps:
step one: identifying the total number M of specifications filled by a user according to the specifications, tonnage and standard of the user filled in an EXCEL 'plan' workbook;
step two: the following calculations were completed one by setting the circulation conditions according to the total number of specifications from the 1 st specification to the M-th specification. And filling the calculation result into the corresponding position of the packing card specification in the plan workbook in a format of the packing card width and the packing card height.
Pack card width = count per layer product height +5;
package card height = number of layers × width per layer +5;
RowCount＝Sheets(1).[A90000].End(xlUp).Row
For i＝2 To RowCount
If Sheets(1).Range("D"&i).Value<>0AndSheets(1).Range("E"&i).Value<>0Then
Sheets(1).Range("J"&i).Value＝Sheets(1).Range("D"&i).Value*Sheets(1).Range("F"&i).Value+5&"*"&Sheets(1).Range("E"&i).Value*Sheets(1).Range("G"&i).Value+5
End If
Next i
(4) and (3) calculating the number of the packing cards according to the raw material width in the step (2), the packing mode in the step (1) and the plan tonnage, and automatically filling the number into the corresponding position of the working interface.
The specific implementation method comprises the following steps:
the following calculations were completed one by setting the circulation conditions according to the total number of specifications from the 1 st specification to the M-th specification. And filling the calculation result into the corresponding position of the packing card number in the plan workbook.
Pack card number = tonnage/(spread thickness 2000 x 7.85/10) 9 * Number of layers per layer
RowCount＝Sheets(1).[A90000].End(xlUp).Row
For i＝2 To RowCount
If Sheets(1).Range("D"&i).Value<>0AndSheets(1).Range("E"&i).Value<>0Then
Sheets(1).Range("K"&i).Value＝Int((Sheets(1).Range("B"&i).Value/(Sheets(1).Range("I"&i).Value*Sheets(1).Range("H"&i).Value*2000*7.85/1000000000*Sheets(1).Range("D"&i).Value*Sheets(1).Range("E"&i).Value))/5)*5+5
End If
Next i
(5) And storing the cold bending square tube specification, the packing card specification and the packing card number information into a summary table in the EXCEL by one key to generate a special auxiliary material planning sheet.
RowCount1＝Sheets(1).[A90000].End(xlUp).Row
rowcount2 = Sheets ("summary") [ a90000]. End (xlUp). Row ]
j＝rowcount2+1
For i＝2 To RowCount1
If Sheets(1).Range("A"&i).Value<>""AndSheets(1).Range("B"&i).Value<>""And Sheets(1).Range("J"&i).Value<>""And Sheets(1).Range("K"&i).Value<>""Then
Shaets ("summary"). Range ("C" & j). Value=shaets (1). Range ("A" & i). Value)
Greens ("summary"). Range ("D" & J). Value=greens (1). Range ("J" & i). Value
Greens ("summary"). Range ("E" & j). Value=greens (1). Range ("K" & i). Value
Shaets ("summary"). Range ("J" & J). Value=shaets (1). Range ("B" & i). Value)
j＝j+1
End If
Next i
4. And sending the production auxiliary material planning sheet to a packing card producer, and producing the packing card according to the sequence number.
The technical scheme of the invention has the following beneficial effects:
the method has the advantages of high efficiency, low error rate and no need of manual inquiry and calculation, solves the problems of manual inquiry records of special persons and calculation of the quantity of special auxiliary materials (packing cards) in the past, and provides a better method for generating a special auxiliary material (packing card) plan.
The operation steps of embodiment 1 of the present invention are as follows:
1. and filling (pasting or filling) three columns of information of the standard gauge, the planning amount (tonnage) and the standard in the production plan of the cold-bending square tube product into three columns corresponding to the standard gauge, the tonnage and the standard in the figure 3. Clicking a button to acquire a packing mode, searching the EXCEL in a table corresponding to the standard according to the macro code instruction, and automatically filling in the searched result to each layer count and two layers. The searching process is to search one by one according to the standard information until the information in the standard is empty.
2. Clicking the button to obtain the widening, the EXCEL can complete the extraction of the information of the height, width and thickness of each specification according to the macro code instruction, and automatically fill the information into the corresponding height, width and thickness columns. And calculating the unfolding width (stretching) of each cold-bent square tube product according to the height, width and thickness of the product, and automatically filling the result into a corresponding stretching column.
3. Clicking a button to calculate the packaging card, and performing calculation on the packaging card specification by EXCEL according to the height and width of each product gauge and the number of packed layers and the number of layers, and then performing calculation on the number of the packaging cards by combining the planned tonnage of each product gauge. And finally, automatically filling the data into the corresponding packing card specification and the corresponding packing card number sequence.
4. Clicking the button "store", EXCEL will store all the data above in turn to the summary table, facilitating the delivery to the producer and later queries.
The foregoing is one of the embodiments of the present invention, and other auxiliary materials, except for the auxiliary material packaging card, are intended to be included in the scope of the present invention, as long as the other auxiliary materials are not in the same way as the above-described principle.
What is not described in detail in this specification is prior art known to those skilled in the art.
Claims (4)
1. The production auxiliary material plan generation method based on the EXCEL form is characterized by comprising the following steps of:
step 1, reading the specification, thickness, applicable standard and plan tonnage of a cold-bent square tube
Step 2, inquiring by taking the standard number and the cold bending square tube specification as keywords, and importing the corresponding packaging mode result of the inquiry into a corresponding form of a working interface;
step 3, extracting the information height, width and thickness of the product according to the specification of the cold-bending square tube, calculating the width of the raw material corresponding to the cold-bending square tube according to the information of the height, width and thickness, and filling the information into a corresponding form of a working interface;
step 4, calculating the specification of the packing card according to the packing mode and the height and width information of the cold-bending square tube, and automatically filling the specification of the packing card into the corresponding position of the working interface; calculating the number of the packing cards according to the width of the raw materials, the packing mode and the plan tonnage, and automatically filling the number into the corresponding position of the working interface;
step 5, storing the cold bending square tube specification, the packing card specification and the packing card number information into a summary form in EXCEL by one key, and generating a special auxiliary material plan list;
in the step 1, all cold bending square tube specifications are classified according to the standards of products and are input into EXCEL documents, and standard numbers are used as the table names of worksheets; the packaging modes of all cold-bending square tube specifications are arranged according to the standard, and structured data are input into the EXCEL document;
step 2 comprises the following steps:
identifying the total number M of specifications filled by a user according to the specifications, tonnage and standard of the user filled in an EXCEL 'plan' workbook; setting circulation conditions according to the total number of specifications, and completing the following queries one by one from the 1 st specification to the M th specification:
and according to the "specification", "standard" input by the user, inquiring the "count per layer" and the "layer number" of the corresponding specification in the workbook named by the standard number, and filling the two data into the corresponding "count per layer" and "layer number" in the "planning" workbook.
2. The method for generating the auxiliary material plan for production based on the EXCEL form according to claim 1, wherein the step 3 is characterized in that the character string of ' high-format and thickness ' is split into three data of ' high ', ' wide ' and ' thickness ' which are respectively filled in the corresponding positions according to the identification of the ' specification ' content filled in an EXCEL ' plan workbook by a user; the width of the expansion of the cross section of the product section is calculated according to the data of the height, the width and the thickness.
3. The EXCEL-form-based production auxiliary material plan generation method according to claim 2, characterized in that the calculation of the packing card specification in step 4 includes the steps of: identifying the total number M of specifications filled by a user according to the specifications, tonnage and standard of the user filled in an EXCEL 'plan' workbook; setting a circulation condition according to the total number of specifications, completing calculation of the width and the width of the packaging card one by one from the 1 st specification to the M th specification, and filling a calculation result into a corresponding position of the packaging card specification in a plan workbook in a format of the packaging card width and the packaging card height; wherein, package card width = count per layer product height +5; pack card height = number of layers +5 per layer width.
4. The method for generating an EXCEL-form-based adjuvant plan for production according to claim 3, characterized in that the calculation of the beat in step 4The number of package cards comprises the following steps: setting a circulation condition according to the total number of specifications, calculating the number of the packaging cards one by one from the 1 st specification to the M th specification, and filling the calculation result into the corresponding position of the number of the packaging cards in the plan workbook; wherein the number of packed cards = tonnage/(spread thickness 2000 x 7.85/10) 9 * Number of branches per layer).
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911258075.9A CN111190951B (en) | 2019-12-10 | 2019-12-10 | Production auxiliary material plan generation method based on EXCEL form |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911258075.9A CN111190951B (en) | 2019-12-10 | 2019-12-10 | Production auxiliary material plan generation method based on EXCEL form |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN111190951A CN111190951A (en) | 2020-05-22 |
| CN111190951B true CN111190951B (en) | 2024-03-05 |
Family
ID=70709207
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201911258075.9A Active CN111190951B (en) | 2019-12-10 | 2019-12-10 | Production auxiliary material plan generation method based on EXCEL form |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN111190951B (en) |
Citations (10)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| JP2004231247A (en) * | 2003-01-31 | 2004-08-19 | Toyota Motor Corp | Apparatus and method of optimally selecting subsidiary packing material |
| JP2004302553A (en) * | 2003-03-28 | 2004-10-28 | Idemitsu Petrochem Co Ltd | Manufacturing support device, method and program, manufacturing control device, manufacturing device, and recording medium with program recorded thereon |
| CN101706902A (en) * | 2009-11-10 | 2010-05-12 | 南京涛如雪工贸实业有限公司 | Excel multi-page form-based method for managing production and order |
| CN102534368A (en) * | 2011-12-21 | 2012-07-04 | 舞阳钢铁有限责任公司 | Low-alloy high-strength wide and thin steel plate and production method thereof |
| CN105441849A (en) * | 2015-12-28 | 2016-03-30 | 内蒙古包钢钢联股份有限公司 | Method for producing high-hardness galvanized plates by using low-carbon steels as raw materials |
| CN105771799A (en) * | 2016-03-11 | 2016-07-20 | 华中科技大学 | Composite enameled plate for high-pressure reaction kettle and production method of composite enameled plate |
| CN107457833A (en) * | 2017-08-15 | 2017-12-12 | 武汉方圆保温材料有限公司 | A kind of automatic XPS extruded sheets cutting packing integral machine |
| WO2018084384A1 (en) * | 2016-11-03 | 2018-05-11 | 유재현 | System and method for providing ready-made clothes and shoes by using standard size of auxiliary material |
| CN108646677A (en) * | 2016-05-13 | 2018-10-12 | 杭萧钢构（河北）建设有限公司 | Steel construction production control system |
| CN110503380A (en) * | 2019-09-09 | 2019-11-26 | 杭州安芯科技有限公司 | Wrap up the method and system of automatic classifying packing |
Family Cites Families (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| NL2008879C2 (en) * | 2012-05-25 | 2013-11-26 | Top B V | Apparatus and process for heat treating a packaged food product. |
-
2019
- 2019-12-10 CN CN201911258075.9A patent/CN111190951B/en active Active
Patent Citations (10)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| JP2004231247A (en) * | 2003-01-31 | 2004-08-19 | Toyota Motor Corp | Apparatus and method of optimally selecting subsidiary packing material |
| JP2004302553A (en) * | 2003-03-28 | 2004-10-28 | Idemitsu Petrochem Co Ltd | Manufacturing support device, method and program, manufacturing control device, manufacturing device, and recording medium with program recorded thereon |
| CN101706902A (en) * | 2009-11-10 | 2010-05-12 | 南京涛如雪工贸实业有限公司 | Excel multi-page form-based method for managing production and order |
| CN102534368A (en) * | 2011-12-21 | 2012-07-04 | 舞阳钢铁有限责任公司 | Low-alloy high-strength wide and thin steel plate and production method thereof |
| CN105441849A (en) * | 2015-12-28 | 2016-03-30 | 内蒙古包钢钢联股份有限公司 | Method for producing high-hardness galvanized plates by using low-carbon steels as raw materials |
| CN105771799A (en) * | 2016-03-11 | 2016-07-20 | 华中科技大学 | Composite enameled plate for high-pressure reaction kettle and production method of composite enameled plate |
| CN108646677A (en) * | 2016-05-13 | 2018-10-12 | 杭萧钢构（河北）建设有限公司 | Steel construction production control system |
| WO2018084384A1 (en) * | 2016-11-03 | 2018-05-11 | 유재현 | System and method for providing ready-made clothes and shoes by using standard size of auxiliary material |
| CN107457833A (en) * | 2017-08-15 | 2017-12-12 | 武汉方圆保温材料有限公司 | A kind of automatic XPS extruded sheets cutting packing integral machine |
| CN110503380A (en) * | 2019-09-09 | 2019-11-26 | 杭州安芯科技有限公司 | Wrap up the method and system of automatic classifying packing |
Non-Patent Citations (1)
| Title |
|---|
| 陈干."钢卷包装管理系统的设计与开发".《 中国计量协会冶金分会2015年会论文集》.2015,1-3. * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN111190951A (en) | 2020-05-22 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN104778540A (en) | BOM (bill of material) management method and management system for building material equipment manufacturing | |
| CN102360404B (en) | Method for compiling geological display map of chamber | |
| CN103823823B (en) | Denormalization policy selection method based on Frequent Itemsets Mining Algorithm | |
| CN102033954A (en) | Full text retrieval inquiry index method for extensible markup language document in relational database | |
| US8095871B2 (en) | System and method for GUI supported specifications for automating form field extraction with database mapping | |
| CN106570047A (en) | Intelligent management system generating system Hxcel technical method | |
| CN105447123A (en) | Data classification, storage and query methods | |
| CN104598625B (en) | Tables of data storage method based on automatic identification mark symbol | |
| CN103218448B (en) | Self-service report form generation method, device and system | |
| CN106776822A (en) | Conglomerate's report data extracting method and system | |
| CN102314647A (en) | Method for storing business data by using XBRL (extensible business reporting language) | |
| CN110609989A (en) | Operation method for rapidly generating information form by adopting predefined layout component and application | |
| CN111190951B (en) | Production auxiliary material plan generation method based on EXCEL form | |
| CN106408188A (en) | Production scheduling system | |
| JP2009116558A (en) | Production planning support system | |
| CN114064660B (en) | Data structured analysis method based on ElasticSearch | |
| CN107480235A (en) | A kind of database framework of data platform | |
| EP2056250A1 (en) | Production system creating system and production system creating method | |
| EP2037343A1 (en) | Production management system, production management method, and storage medium containing production program for executing the production management method | |
| CN103942634A (en) | Group consolidated statement offset number data processing method and system | |
| CN108733752A (en) | Autoreport storage method and system | |
| US6108677A (en) | Data processing apparatus | |
| CN106408235A (en) | Method for realizing material unit composite metering in supply chain system | |
| CN106933783A (en) | A kind of method and device on the intelligent extraction date from text | |
| CN104156386A (en) | Data processing method and system with image recognition function |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |