CN111190951A - 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
- CN111190951A CN111190951A CN201911258075.9A CN201911258075A CN111190951A CN 111190951 A CN111190951 A CN 111190951A CN 201911258075 A CN201911258075 A CN 201911258075A CN 111190951 A CN111190951 A CN 111190951A
- Authority
- CN
- China
- Prior art keywords
- width
- cold
- excel
- height
- specifications
- 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.)
- Granted
Links
- 239000000463 material Substances 0.000 title claims abstract description 37
- 238000000034 method Methods 0.000 title claims abstract description 30
- 238000004519 manufacturing process Methods 0.000 title claims abstract description 28
- 238000004806 packaging method and process Methods 0.000 claims abstract description 45
- 238000005452 bending Methods 0.000 claims abstract description 39
- 238000012856 packing Methods 0.000 claims abstract description 27
- 239000002994 raw material Substances 0.000 claims abstract description 8
- 230000008569 process Effects 0.000 description 3
- 238000010586 diagram Methods 0.000 description 2
- 238000002360 preparation method Methods 0.000 description 2
- 229910000831 Steel Inorganic materials 0.000 description 1
- 238000009825 accumulation Methods 0.000 description 1
- 230000009286 beneficial effect Effects 0.000 description 1
- 230000007547 defect Effects 0.000 description 1
- 239000000284 extract Substances 0.000 description 1
- 230000008676 import Effects 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 239000010959 steel Substances 0.000 description 1
- 238000003860 storage Methods 0.000 description 1
Images
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 a production auxiliary material plan generation method based on an EXCEL form, which comprises the following steps: reading the specification, thickness, applicable standard and planned tonnage of the cold-bending square-rectangular tube; taking the standard number and the specification of the cold-bending square and rectangular tubes as the query of keywords, and importing the queried corresponding packaging mode results into corresponding tables of a working interface; extracting the information of height, width and thickness of the product according to the specification of the cold-bending square-rectangular tube, and calculating the width of the raw material corresponding to the cold-bending square-rectangular tube according to the information of height, width and thickness; calculating the specification of the packaging card according to the packaging mode and the height and width information of the cold-bending square and rectangular tube; calculating the number of the packaging cards according to the width of the raw materials, the packaging mode and the planned tonnage; and storing the specification of the cold-bending square tube, the specification of the packing card and the number information of the packing card into a summary table in EXCEL by one key to generate a special auxiliary material plan list. The invention has the advantages of high efficiency and low error rate, and solves the problem that a specially-assigned person is required to compile a production auxiliary material plan.
Description
Technical Field
The invention relates to the field of steel production plans, in particular to a production auxiliary material plan generation method based on an EXCEL form.
Background
The cold-bending square-rectangular tube products have various specifications, and the number of the cold-bending square-rectangular tube products is thousands. In addition, 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 and rectangular tubes need more auxiliary materials in the production process, 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 the condition of large accumulation for standby, and the cold-bending square and rectangular tubes need to be prepared in time according to the production sequence of the cold-bending square and rectangular tube products in the production plan, so that the production of the cold-bending square and rectangular tube products can be carried out smoothly.
At present, the preparation of auxiliary materials for cold-bending square and rectangular tube products mainly adopts the following method:
manually searching the specifications of special auxiliary materials used in past production records one by one according to the production plan of the cold-bending square-rectangular pipe; and calculating the planned amount of the special auxiliary materials according to the planned production amount of each specification.
As the planning specification number of each week can reach more than one hundred, the two steps are required to arrange a special post for manual inquiry record and calculate the quantity of special auxiliary materials. And a large error risk exists in the manual inquiry and calculation processes. Therefore, it is necessary to invent a method for automatically generating a special auxiliary material plan by a computer. .
Disclosure of Invention
The invention aims to provide a production auxiliary material plan generation method based on an EXCEL form, which has the advantages of high efficiency and low error rate and solves the problem that a specially-assigned person is required to compile a production auxiliary material plan, aiming at the defects of the prior art.
The invention provides a production auxiliary material plan generation method based on an EXCEL form, which is characterized by comprising the following steps of:
and 5, storing the specification of the cold-bending square and rectangular pipe, the specification of the packing card and the number information of the packing card into a summary table in the EXCEL by one key, and generating a special auxiliary material plan list.
In the technical scheme, all specifications of the cold-bending square and rectangular tubes in the step 1 are classified according to the standards of products and input into EXCEL documents, and standard numbers are used as the names of the worksheets; all the packaging modes of the cold-bending square and rectangular tube specification are arranged according to the standard, and the structured data is recorded into an EXCEL document.
In the above technical solution, step 2 includes the following steps:
identifying the total number M of the specifications filled by the user according to the specifications, the tonnage and the standards of the specifications filled in the EXCEL plan workbook by the user; setting circulation conditions according to the total number of the specifications, and completing the following queries from the 1 st specification to the Mth specification one by one:
according to the specification and the standard input by the user, the workbook named with the standard number is inquired about the number of each layer and the number of layers of the corresponding specification, and the two data are filled into the corresponding number of each layer and the number of layers in the plan workbook.
In the technical scheme, the step 3 is to identify according to the ' specification ' content filled in the EXCEL ' plan ' workbook by the user, and to split the character string of ' height, width and thickness ' into three data of ' height ', width and thickness ', and to fill the three data into the corresponding positions respectively; and calculating the expanded width of the cross section of the product according to the data of height, width and thickness.
In the above technical solution, the calculating the packaging card specification in step 4 includes the following steps: identifying the total number M of the specifications filled by the user according to the specifications, the tonnage and the standards of the specifications filled in the EXCEL plan workbook by the user; setting circulation conditions according to the total number of the specifications, completing the calculation of the width and the width of the packaging card from the 1 st specification to the Mth specification one by one, and filling the calculation result into the corresponding position of the specification of the packaging card in a plan workbook in a format of packaging card width and packaging card height; wherein, the width of the packaging card is equal to the number of each layer and the height of the product is equal to 5; pack card height +5 layers by width of each layer.
In the above technical solution, the calculating the number of the packing cards in step 4 includes the following steps: setting circulation conditions according to the total number of the specifications, calculating the number of the packing cards one by one from the 1 st specification to the Mth specification, and filling the calculation result into the position corresponding to the number of the packing cards in the plan workbook; wherein, the number of the packing cards is tonnage/(widening thickness 2000 7.85/109 count per layer).
In the auxiliary material planning process, the traditional mode of manually inquiring and calculating the auxiliary material specification and the auxiliary material consumption according to a production scheduling plan is abandoned, and the method for automatically inquiring and calculating the auxiliary material specification and the auxiliary material consumption by compiling the EXCEL macro file code of the computer is innovatively provided. The method has the advantages of high efficiency and low error rate, and solves the problem that a specially-assigned person is required to compile a production auxiliary material plan.
Drawings
FIG. 1 is a schematic view of a packaging card of the present invention;
FIG. 2 is a schematic flow diagram of the present invention;
fig. 3 is a schematic diagram of the application of the present invention.
Detailed Description
The invention will be further described in detail with reference to the following drawings and specific examples, which are not intended to limit the invention, but are for clear understanding.
As shown in the figure, the invention provides a production auxiliary material plan generation method based on an EXCEL form, aiming at the problems of the preparation method of the special auxiliary material required in the production process of the cold-bending square and rectangular tube product.
The method specifically comprises the following steps:
1. classifying all specifications of the cold-bending square tube according to product standards, inputting EXCEL documents, and taking standard numbers as the names of worksheets;
2. and (3) sorting all the packaging modes with the specification of the cold-bending square and rectangular tubes in the step 1 by the distinguishing standard, and inputting the structured data into an EXCEL document.
3. By the EXCEL macro code, the following functions are realized.
① query with standard number and specification of cold-bending square-rectangular tube as key words, and import the query corresponding packaging mode result into the corresponding table of the working interface.
The specific implementation method comprises the following steps:
the method comprises the following steps: identifying the total number M of the specifications filled by the user according to the specifications, the tonnage and the standards of the specifications filled in the EXCEL plan workbook by the user;
step two: and setting circulation conditions according to the total number of the specifications, and completing the following queries from the 1 st specification to the Mth specification one by one.
According to the specification and the standard input by the user, the workbook named with the standard number is inquired about the number of each layer and the number of layers of the corresponding specification, and the two data are filled into the corresponding number of each layer and the number of layers in the plan 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
② extracting the height, width and thickness of the product according to the specification of the cold-bending square and rectangular tube, calculating the width of the raw material corresponding to the cold-bending square and rectangular tube according to the height, width and thickness information, and filling the information in the corresponding table of the working interface.
The specific implementation method comprises the following steps:
the method comprises the following steps: and recognizing according to the content of the specification filled in the EXCEL plan workbook by the user, and splitting the character string of the height, the width and the thickness into three data of the height, the width and the thickness which are respectively filled in corresponding positions.
Step two: and calculating the expanded width (widening) of the cross section of the product according to the data of height, width and 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
③ calculating the specification of the packing card according to the packing mode of ① and the height and width information of the rectangular tube of the cold bending in ②, and automatically filling and writing the specification of the packing card to the corresponding position of the working interface.
The specific implementation method comprises the following steps:
the method comprises the following steps: identifying the total number M of the specifications filled by the user according to the specifications, the tonnage and the standards of the specifications filled in the EXCEL plan workbook by the user;
step two: and setting circulation conditions according to the total number of the specifications, and completing the following calculation from the 1 st specification to the Mth specification one by one. And filling the calculation result into the corresponding position of the packing card specification in the plan workbook in a packing card width packing card height format.
The width of the packaging card is equal to the number of each layer and the height of the product is + 5;
packaging card height +5 layers by width of each 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("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
④ calculating the number of packing cards according to the width of raw material ②, the packing mode in ① and the planned tonnage, and automatically filling the number to the corresponding position of the working interface.
The specific implementation method comprises the following steps:
and setting circulation conditions according to the total number of the specifications, and completing the following calculation from the 1 st specification to the Mth specification one by one. And filling the calculation result into the corresponding position of the packing card number in the plan workbook.
Number of packing cards (tonnage/(widening thickness 2000) 7.85/10)9Number 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
⑤, storing the cold-bending square tube specification, the packaging card specification and the packaging card number information into a summary table in EXCEL by one key to generate a special auxiliary material plan list.
RowCount1＝Sheets(1).[A90000].End(xlUp).Row
rowcount2 ═ Sheets ("summary") [ a90000]. end (xlup)
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
Sheets ("summary"). Range ("C" & j) Value ═ Sheets (1) Range ("a" & i) Value
Sheets ("summary"). Range ("D" & J) Value ═ Sheets (1) Range ("J" & i) Value
Sheets ("summary"). Range ("E" & j) Value ═ Sheets (1) Range ("K" & i) Value
Sheets ("summary"). Range ("J" & J), Value ═ Sheets (1), Range ("B" & i), Value
j＝j+ 1
End If
Next i
4. And sending the production auxiliary material plan list to a packaging card making party, and making the packaging 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 that in the past, a specially-assigned post needs to arrange manual inquiry records and the number of special auxiliary materials (packaging cards) needs to be calculated, and provides a better method for generating a planning list of the special auxiliary materials (packaging cards).
The operation steps of the specific implementation 1 of the invention are as follows:
1. and filling (pasting or filling) three columns of information of the gauge, the planned amount (tonnage) and the standard in the production plan of the cold-bending square-rectangular tube product into three columns corresponding to the gauge, the tonnage and the standard in the figure 3. And clicking a button to obtain a packaging mode, wherein the EXCEL searches in a table corresponding to a standard according to a macro code instruction, and automatically filling a search result into the number of each layer and two columns of the layer. The retrieval process is to retrieve one by one according to the specification information until the information in the specification is empty.
2. And clicking a button to obtain the broadening, and the EXCEL extracts the height, width and thickness information of each specification according to the macro code instruction and automatically fills the information into corresponding height, width and thickness columns. And calculating the expansion width (widening) of each cold-bending square-rectangular tube product according to the height, width and thickness of the product, and automatically filling the result into a corresponding widening column.
3. And clicking a button to calculate the packaging card, wherein the EXCEL can complete the calculation of the packaging card specification according to the height and the width of each product gauge and the number of the packed layers and the number of the layers, and then completes the calculation of the number of the packaging cards by combining the planned tonnage of each product gauge. And finally, automatically filling the data to the corresponding packaging card specification and packaging card number sequence.
4. And when the button 'storage' is clicked, the EXCEL stores all the data to a summary table in sequence, so that the data are favorably transmitted to a manufacturer and inquired in the later period.
The above is one embodiment of the present invention, and other modifications or alternatives to the packaging card of the auxiliary materials are also contemplated within the scope of the present invention.
Details not described in this specification are within the skill of the art that are well known to those skilled in the art.
Claims (6)
1. A production auxiliary material plan generation method based on an EXCEL form is characterized by comprising the following steps:
step 1, reading the specification, thickness, applicable standard and planned tonnage of the cold-bending square-rectangular tube
Step 2, query by using the standard number and the specification of the cold-bending square and rectangular tube as keywords, and importing the queried corresponding packaging mode result into a corresponding table of a working interface;
step 3, extracting the height, width and thickness of the product information according to the specification of the cold-bending square and rectangular tube, calculating the width of the raw material corresponding to the cold-bending square and rectangular tube according to the height, width and thickness information, and filling the information into a corresponding table of a working interface;
step 4, calculating the specification of the packaging card according to the packaging mode and the height and width information of the cold-bending square and rectangular tube, and automatically filling the specification of the packaging card to the corresponding position of the working interface; calculating the number of the packing cards according to the width of the raw material, the packing mode and the planned tonnage, and automatically filling the number to the corresponding position of the working interface;
and 5, storing the specification of the cold-bending square and rectangular pipe, the specification of the packing card and the number information of the packing card into a summary table in the EXCEL by one key, and generating a special auxiliary material plan list.
2. The EXCEL form-based auxiliary material for production plan generation method according to claim 1, characterized in that in step 1 all cold-formed square and rectangular tube specifications have been classified according to product standards and entered into EXCEL documents, with standard number as worksheet name; all the packaging modes of the cold-bending square and rectangular tube specification are arranged according to the standard, and the structured data is recorded into an EXCEL document.
3. The EXCEL form-based manufacturing lot creation method according to claim 2, characterized in that step 2 comprises the steps of:
identifying the total number M of the specifications filled by the user according to the specifications, the tonnage and the standards of the specifications filled in the EXCEL plan workbook by the user; setting circulation conditions according to the total number of the specifications, and completing the following queries from the 1 st specification to the Mth specification one by one:
according to the specification and the standard input by the user, the workbook named with the standard number is inquired about the number of each layer and the number of layers of the corresponding specification, and the two data are filled into the corresponding number of each layer and the number of layers in the plan workbook.
4. The EXCEL-format-based auxiliary material for production schedule generation method according to claim 3, wherein step 3 is performed by recognizing the "specification" content filled in the EXCEL "schedule" workbook by the user, and dividing the character string of "height, width and thickness" into three data of "height", "width" and "thickness" to be filled in the corresponding positions respectively; and calculating the expanded width of the cross section of the product according to the data of height, width and thickness.
5. The EXCEL form-based manufacturing lot creation method according to claim 4, wherein the calculating of the packaging card specification in step 4 comprises the steps of: identifying the total number M of the specifications filled by the user according to the specifications, the tonnage and the standards of the specifications filled in the EXCEL plan workbook by the user; setting circulation conditions according to the total number of the specifications, completing the calculation of the width and the width of the packaging card from the 1 st specification to the Mth specification one by one, and filling the calculation result into the corresponding position of the specification of the packaging card in a plan workbook in a format of packaging card width and packaging card height; wherein, the width of the packaging card is equal to the number of each layer and the height of the product is equal to 5; pack card height +5 layers by width of each layer.
6. The EXCEL form-based manufacturing lot creation method according to claim 5, characterized in that the calculating of the number of package cards in step 4 comprises the steps of: setting circulation conditions according to the total number of the specifications, calculating the number of the packing cards one by one from the 1 st specification to the Mth specification, and filling the calculation result into the position corresponding to the number of the packing cards in the plan workbook; wherein, the number of the packing cards is tonnage/(widening thickness 2000 7.85/10)9Counts per layer by layers).
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 true CN111190951A (en) | 2020-05-22 |
| CN111190951B 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 (11)
| 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 |
| US20130316051A1 (en) * | 2012-05-25 | 2013-11-28 | Top B.V. | Apparatus and process for heat treating a packaged food product |
| 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 |
-
2019
- 2019-12-10 CN CN201911258075.9A patent/CN111190951B/en active Active
Patent Citations (11)
| 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 |
| US20130316051A1 (en) * | 2012-05-25 | 2013-11-28 | Top B.V. | Apparatus and process for heat treating a packaged food product |
| 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 |
|---|
| 陈干: ""钢卷包装管理系统的设计与开发"", pages 1 - 3 * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN111190951B (en) | 2024-03-05 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN104778540A (en) | BOM (bill of material) management method and management system for building material equipment manufacturing | |
| CN102033954A (en) | Full text retrieval inquiry index method for extensible markup language document in relational database | |
| CN102023989B (en) | Information retrieval method and system thereof | |
| CN103853820B (en) | Data processing method and data processing system | |
| CN100524306C (en) | Method for leading-in and deriving data in browser/servicer system | |
| CN103329122B (en) | Storage of a document using multiple representations | |
| CN101206670B (en) | System and method for transferring non construction information to content | |
| CN103823823B (en) | Denormalization policy selection method based on Frequent Itemsets Mining Algorithm | |
| EP1225516A1 (en) | Storing data of an XML-document in a relational database | |
| CN102314647A (en) | Method for storing business data by using XBRL (extensible business reporting language) | |
| CN109408906B (en) | BIM model-based engineering quantity expression and statistics method | |
| CN100444591C (en) | Method for acquiring front-page keyword and its application system | |
| CN104915449A (en) | Faceted search system and method based on water conservancy object classification labels | |
| CN102609490B (en) | Column-storage-oriented B+ tree index method for DWMS (data warehouse management system) | |
| CN111260413A (en) | Vector graph-based rapid calculation method for construction cost of power main network engineering | |
| CN101515269A (en) | Method for achieving view search engine ranking | |
| CN102446184B (en) | Industrial data storage and index method based on time series | |
| CN102207948A (en) | Method for generating incident statement sentence material base | |
| CN101571861A (en) | Method and device for converting data table | |
| CN101355457A (en) | Test method and test equipment | |
| CN105022806A (en) | Method and system for establishing mobile page based on internet webpage of translation template | |
| CN102024046A (en) | Data repeatability checking method and device as well as system | |
| CN114064660B (en) | Data structured analysis method based on ElasticSearch | |
| CN107480235A (en) | A kind of database framework of data platform | |
| CN103942634A (en) | Group consolidated statement offset number data processing method and system |
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 |