CN111507077A - Method for automatically generating production records of galvanized outlet - Google Patents
Method for automatically generating production records of galvanized outlet Download PDFInfo
- Publication number
- CN111507077A CN111507077A CN202010186883.5A CN202010186883A CN111507077A CN 111507077 A CN111507077 A CN 111507077A CN 202010186883 A CN202010186883 A CN 202010186883A CN 111507077 A CN111507077 A CN 111507077A
- Authority
- CN
- China
- Prior art keywords
- information
- production
- sheet
- excel
- automatically
- 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.)
- Pending
Links
- 238000004519 manufacturing process Methods 0.000 title claims abstract description 87
- 238000000034 method Methods 0.000 title claims abstract description 20
- 229910000831 Steel Inorganic materials 0.000 claims abstract description 36
- 239000010959 steel Substances 0.000 claims abstract description 36
- 239000002436 steel type Substances 0.000 claims abstract description 7
- 238000005516 engineering process Methods 0.000 claims abstract description 6
- 238000005246 galvanizing Methods 0.000 claims description 11
- 230000002159 abnormal effect Effects 0.000 claims description 8
- 238000005520 cutting process Methods 0.000 claims description 6
- 230000008569 process Effects 0.000 claims description 3
- 238000009966 trimming Methods 0.000 description 9
- HCHKCACWOHOZIP-UHFFFAOYSA-N Zinc Chemical compound [Zn] HCHKCACWOHOZIP-UHFFFAOYSA-N 0.000 description 6
- 239000011701 zinc Substances 0.000 description 6
- 229910052725 zinc Inorganic materials 0.000 description 6
- 238000012805 post-processing Methods 0.000 description 4
- 239000002994 raw material Substances 0.000 description 4
- 230000008676 import Effects 0.000 description 3
- 238000004381 surface treatment Methods 0.000 description 3
- 230000008719 thickening Effects 0.000 description 3
- LKPZQKREAUELRB-UHFFFAOYSA-N 4,5-dihydroxy-3-methoxy-6-[(3,4,5,6-tetrahydroxyoxan-2-yl)methoxy]oxane-2-carboxylic acid Chemical compound COC1C(O)C(O)C(OCC2OC(O)C(O)C(O)C2O)OC1C(=O)O LKPZQKREAUELRB-UHFFFAOYSA-N 0.000 description 2
- 230000008901 benefit Effects 0.000 description 2
- 238000004364 calculation method Methods 0.000 description 2
- 238000010586 diagram Methods 0.000 description 2
- 238000002360 preparation method Methods 0.000 description 2
- 241001442654 Percnon planissimum Species 0.000 description 1
- 230000009286 beneficial effect Effects 0.000 description 1
- 238000003490 calendering Methods 0.000 description 1
- 239000011248 coating agent Substances 0.000 description 1
- 238000000576 coating method Methods 0.000 description 1
- 239000013072 incoming material Substances 0.000 description 1
- 238000004806 packaging method and process Methods 0.000 description 1
- 230000000007 visual effect Effects 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/186—Templates
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q50/00—Information and communication technology [ICT] specially adapted for implementation of business processes of specific business sectors, e.g. utilities or tourism
- G06Q50/04—Manufacturing
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
- Y02P—CLIMATE CHANGE MITIGATION TECHNOLOGIES IN THE PRODUCTION OR PROCESSING OF GOODS
- Y02P90/00—Enabling technologies with a potential contribution to greenhouse gas [GHG] emissions mitigation
- Y02P90/30—Computing systems specially adapted for manufacturing
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- General Health & Medical Sciences (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Health & Medical Sciences (AREA)
- Business, Economics & Management (AREA)
- Artificial Intelligence (AREA)
- Audiology, Speech & Language Pathology (AREA)
- Computational Linguistics (AREA)
- General Engineering & Computer Science (AREA)
- Manufacturing & Machinery (AREA)
- Economics (AREA)
- Human Resources & Organizations (AREA)
- Marketing (AREA)
- Primary Health Care (AREA)
- Strategic Management (AREA)
- Tourism & Hospitality (AREA)
- General Business, Economics & Management (AREA)
- General Factory Administration (AREA)
Abstract
The invention relates to a method for automatically generating a galvanized outlet production record, which utilizes EXCE L and VB technology to manufacture an Excel template capable of automatically dividing a large steel coil basic information of a galvanized inlet into a plurality of small steel coils according to production process information in a galvanized MES production system and recording the specification, steel type and production process information of each small steel coil, runs a VB program on the Excel template in a background mode, and an operator can automatically complete information input and generation only by clicking a corresponding button in the Excel template once by a mouse.
Description
Technical Field
The application belongs to the technical field of galvanizing production management, and particularly relates to a method for automatically generating a galvanizing outlet production record.
Background
Because the production plan issued in the MES system (production management system) does not meet the recording requirements, after the production of the galvanizing production line is finished, no record is left in the MES system, so that the information of each small roll needs to be recorded when each roll (a large roll is divided into 2 or 3 small rolls) is produced at the outlet of the galvanizing production line, a production line code is added after the small roll, the recorded information comprises information such as specification, steel grade, weight, post-processing mode, zinc layer weight, oil coating type and the like, and the galvanizing outlet is required to make a production record and record the required information.
The average output of each shift of the galvanizing production line is 700t, and the average output is calculated according to 20t of one large coil, namely 35 large coils, and if each large coil is divided into 3 coils, the production records of 105 small coils need to be made. For a skilled worker, it takes 20-30 minutes to make this production record. And if a roll is manufactured, the risk of information error exists, and the roll is not required to be divided into more small rolls, so that the workload is greater.
Therefore, a method for automatically generating a production record according to a production plan needs to be designed, and the method is simple to operate, simple in operation rule, high in safety and capable of guaranteeing the correct operation of a program.
Disclosure of Invention
The technical problem to be solved by the invention is to provide a method for automatically generating the production record of the galvanized outlet, which has the advantages of simple operation, safety, reliability and accurate information, can automatically divide the basic information of the large steel coil at the galvanized inlet into a plurality of small steel coils, and records the specification, steel grade and production process information of each small steel coil.
In order to solve the problems, the technical scheme adopted by the invention is as follows:
a method for automatically generating a galvanized outlet production record utilizes EXCE L and VB technology to manufacture an Excel template which can automatically divide basic information (coil number and other information) of a large steel coil at a galvanized inlet into a plurality of small steel coils (such as one second or one third) according to production process information (such as coil number, steel type, surface treatment and the like) in a galvanized MES production system and record the specification, steel type and other production process information of each small steel coil;
and running a VB program on the Excel template background, wherein operators do not need skilled office technology, and only need to click a corresponding button in the Excel template once by a mouse, so that information input and generation can be automatically completed.
The technical scheme of the invention is further improved as follows: the method comprises the following specific steps:
step a, building a template, firstly building an Excel, starting macro application, respectively building 4 sheet tables in the Excel, and sequentially naming the sheet tables as sheet1 to sheet4, wherein the sheet1 is used as a main interface with the same table format as the production record, 3 macro loading buttons for operating the sheet tables from the sheet 2 to the sheet4 are inserted into the sheet1 interface, and the macro loading buttons are respectively named as MES information importing, one steel coil for two, and one steel coil for three; the sheet 2 is used for storing a production plan exported by the MES production system; sheet3 is used for making a one-to-two formula, sheet4 is used for making a one-to-three formula, and content information needs to correspond to final bundling information of production information; dividing the large steel coil into two-in-one or three-in-one small steel coils, and adding a production line code and a production number of the small steel coil after the large steel coil number (such as S1, S2 and S3, wherein S is the production line code).
B, operating a first background, writing codes in an Excel background by using a VB programming function, realizing one-key introduction of a production plan exported by an MES production system into a sheet 2 in the Excel through a macro loading button 1, correspondingly copying production information in the sheet3 and the sheet4 into the sheet1 through the macro loading button 2 or the macro loading button 3, and reserving a mode without a formula, so that an operator can conveniently copy and paste the production plan; when a new MES production plan exists, and the operations are repeated again, the background program can automatically clear useless information (the useless information is overdue information generated in the last operation) in the sheet1 and the sheet 2 and generate new bundling information;
and c, operating the second background, writing codes in the Excel background, automatically hiding the sheets 3 to 4 where the formulas are located when the Excel is opened every time, hiding the sheet 2 which does not need to be seen by an operator, and automatically clearing useless information in the sheets 1 and the sheet 2 (note that clearing in the step b is to realize multiple operations when the Excel is not closed, and the clearing mode in the step c is to ensure that template information is empty when the Excel is closed and opened again to prepare for the next operation), so that preparation is made for the next operation, the operator is forbidden to newly establish a sheet table or modify the formulas in the Excel template, and the Excel background is encrypted.
The technical scheme of the invention is further improved in that the one-to-two formula to the one-to-three formula are all horizontal search formula H L OOKUP functions.
The technical scheme of the invention is further improved as follows: in the step b, when the information in the sheet3 and the sheet4 is correspondingly copied into the sheet1 through the macro loading button 2 and the macro loading button 3, the copying process is to select pasting copying without a formula, so that the useless information in the sheet1 and the sheet 2 is synchronously cleared, the marking of important abnormal operation is synchronously realized in the production process, and key characters of determined edge cutting in the galvanizing edge cutting requirement are marked in a key mode.
The marking of important abnormal operation is synchronously realized in the production process, and key characters of the determined edge cutting in the galvanizing edge cutting requirement are marked with emphasis, for example: 1. when the steel coil needs to be subjected to post trimming or not trimmed during post-processing in the production process, marking Y or N in the trimming information column, and automatically thickening, inclining and marking red on the Y font identification needing trimming so as to remind an operator to operate; 2. the template will automatically identify 610 the inside diameter request as black, no slant, and 508 the sleeve as bold slant and red for an abnormal standard of curl inside diameter to alert the worker to the replacement of the coiler sleeve during production.
Due to the adoption of the technical scheme, the invention has the beneficial effects that: compared with manual recording by operators, the excel template provided by the invention can realize rapid recording generation, has no too many operation rules, is simple and practical in operation method, and saves a large amount of operation time. The labor efficiency is improved in the aspect of human resources, and great economic benefits are created for enterprises. Meanwhile, the method has good safety, strong stability and higher popularization and application values, and program misoperation cannot occur.
Drawings
FIG. 1 is a main interface view of a sheet1 of the present invention;
FIG. 2 is a sheet 2 production plan import interface diagram of the present invention;
FIG. 3 is a diagram of an interface including a formula search according to the present invention.
Detailed Description
The present invention will be described in further detail with reference to examples.
The invention discloses a method for automatically generating a galvanized outlet production record, which utilizes EXCE L and VB technology to manufacture an Excel template which can automatically divide basic information (coil number and other information) of a large steel coil at a galvanized inlet into a plurality of small steel coils (such as one-to-two or one-to-three) according to production process information (such as coil number, steel type, surface treatment and the like) in a galvanized MES production system and record the specification, steel type and other production process information of each small steel coil;
and running a VB program on the Excel template background, wherein operators do not need skilled office technology, and only need to click a corresponding button in the Excel template once by a mouse, so that information input and generation can be automatically completed.
The method comprises the following specific steps:
step a, building a template, firstly building an Excel, starting macro application, respectively building 4 sheet tables in the Excel, and sequentially naming the sheet tables as sheet1 to sheet4, wherein the sheet1 is used as a main interface with the same table format as the production record, 3 macro loading buttons for operating the sheet tables from the sheet 2 to the sheet4 are inserted into the sheet1 interface, and the macro loading buttons are respectively named as MES information importing, one steel coil for two, and one steel coil for three; the sheet 2 is used for storing a production plan exported by the MES production system; sheet3 is used for making a one-to-two formula, sheet4 is used for making a one-to-three formula, and content information needs to correspond to final bundling information of production information;
b, operating a first background, writing codes in an Excel background by using a VB programming function, realizing one-key introduction of a production plan exported by an MES production system into a sheet 2 in the Excel through a macro loading button 1, correspondingly copying production information in the sheet3 and the sheet4 into the sheet1 through the macro loading button 2 or the macro loading button 3, and reserving a mode without a formula, so that an operator can conveniently copy and paste the production plan; when a new MES production plan exists, and the operations are repeated again, the background program can automatically clear useless information (the useless information is overdue information generated in the last operation) in the sheet1 and the sheet 2 and generate new bundling information;
and c, operating the second background, writing codes in the Excel background, automatically hiding the sheets 3 to 4 where the formulas are located when the Excel is opened every time, hiding the sheet 2 which does not need to be seen by an operator, and automatically clearing useless information in the sheets 1 and the sheet 2 (note that clearing in the step b is to realize multiple operations when the Excel is not closed, and the clearing mode in the step c is to ensure that template information is empty when the Excel is closed and opened again to prepare for the next operation), so that preparation is made for the next operation, the operator is forbidden to newly establish a sheet table or modify the formulas in the Excel template, and the Excel background is encrypted.
Both the one-to-two formula and the one-to-three formula are horizontal search formula H L ook functions.
In the step b, when the information in the sheet3 and the sheet4 is correspondingly copied into the sheet1 through the macro loading button 2 and the macro loading button 3, the copying process is to select pasting copying without a formula, so that the useless information in the sheet1 and the sheet 2 is synchronously cleared, and the important abnormal operation is synchronously marked, for example: 1. when the steel coil needs to be subjected to post trimming or not trimmed during post-processing in the production process, marking Y or N in the trimming information column, and automatically thickening, inclining and marking red on the Y font identification needing trimming so as to remind an operator to operate; 2. the template will automatically identify 610 the inside diameter request as black, no slant, and 508 the sleeve as bold slant and red for an abnormal standard of curl inside diameter to alert the worker to the replacement of the coiler sleeve during production.
The following description will be given by taking a large steel coil as one-to-two and one-to-three.
1) Firstly, an Excel form is newly created, macro application is required to be started in the form, 4 sheet forms are respectively created, the sheet1 is a main interface (named as an export record generation template) and is used as a form format (figure 1) identical to that of a production record, three macro loading buttons are inserted into the interface and are respectively named as one-key import mes information, one-click and three-click, information in the sheet1 comprises a serial number, an incoming material roll number (8J 0621478), a raw material weight (22435), a galvanized roll number (8J 0621478S 1), finished steel product steel (DC 510+ Z/HX 340L AD + Z), a finished product thickness (1/1.25), a finished product width (1250/1500/1525), a finished product weight, a judgment result (qualified product or not), whether to cut edges exist or not (Y or N is selected, Y represents cut edges, N represents not to cut edges, a surface quality grade (such as FB), a sorting degree (S4 (FB 84 (FB), a zinc layer weight (80/120), a papa oil coated product type (F60, rit A) and an inner diameter (such as 4107 mm) 610mm and the.
sheet 2 (named MES information entry) is used for pasting a production plan exported by a MES production system (figure 2), and information in the sheet 2 comprises a serial number, a physical steel coil number (8J 0621478), a physical steel (22435), an export steel TYPE (such as DC510+ Z/HX 340L AD + Z/HC 340L AD + Z), an export thickness (such as 1.000/1.250-2.000/2.450), an export width (1250/1500/1525), a cut edge (N/Y), a maximum finished product (25.000/10.000/12.000), a minimum finished product (5.000/6.000/25.000), a finished product packaging mode (13 refined package I/44 refined package II XG), a zinc layer code (Z80/Z120/Z180), an inner diameter (610.000 mm), an end user (general user), an Oil TYPE (1-general antirust Oil (pascal F60/2-antirust Oil (calendered Oil HN 530-HN 3-normal antirust Oil (AMOR) and light Oil TYPE Oil (AMOR 4-O-5-Oil).
In sheet3 and sheet4, a two-in-two and a three-in-one formula is made, respectively, which prevents data errors caused by changes in the data columns in sheet 2 by using the horizontal search formula H L OOKUP, such as the formula "IF (OR (MES info entry! $ D2< >0, MES info entry! $ C2< >0, MES info entry! E2< >0), VA L UE (H L OOKUP (" real coil weight ", MES info entry! $ a $1: AT2, ROW (MES info entry! C2, 0)),") is a formula for realizing the search of the raw material weight column and the automatic recording of the raw material weight, the formula "IF (OR (MES info entry! $ D2< >0, MES info entry! $ C2< >0, information! $ E < > 2! $ 0, the formula" IF (OR (MES info entry! $ na $ 380), the formula "IF (OR (MES info entry! $ C $ 0, MES info entry! $ 730, $ Z $ 26: $ 26 j $ H3 + 15) for the calculation of the theoretical roll thickness (" kov "$ x, MES info (MES info) layer, the roll Z + x roll) and the calculation of the production layer (MES info is realized by using the numeric search for the number of the numeric search of the roll Z (" kov # wo) and the numeric search for the roll (kov # wo) code ("kov # wo layer (kov # 19).
For example, in sheet3, the information includes serial number, incoming coil number, raw material weight (kg), galvanized coil number, finished steel product, finished product thickness (mm), finished product width (mm), finished product weight (kg), determination result (qualified product or not), whether to cut edge (Y or N is selected, Y represents cut edge, N represents not cut edge), surface quality grade, sorting degree, zinc layer weight (both sides), surface treatment, surface structure, whether to finish, theoretical zinc consumption, zinc consumption positive and negative rate, remarks, and the like.
2) Writing codes in Excel background by utilizing a vb (visual basic) programming function, realizing one-key importing of a production plan exported by an MES production system into a sheet 2 in an Excel template, synchronously pasting information in the sheet3 or the sheet4 into the sheet1, pasting without a formula, synchronously realizing the removal of useless information in the sheet1 and the sheet 2, and synchronously realizing the marking of important abnormal operations, for example: 1. when the steel coil needs to be subjected to post trimming or not trimmed during post-processing in the production process, marking Y or N in the trimming information column, and automatically thickening, inclining and marking red on the Y font identification needing trimming so as to remind an operator to operate; 2. the template will automatically identify 610 the inside diameter request as black, no slant, and 508 the sleeve as bold slant and red for an abnormal standard of curl inside diameter to alert the worker to the replacement of the coiler sleeve during production.
Such as:
Dim FileName As String
Dim sht As Worksheet
file dialog (msoFileDialogFilePicker)' creating a dialog box for opening a file
If .Show = -1 Then
This code is used to implement part of the code that imports the production plan.
3) Writing codes in the Excel table background, automatically hiding the sheet3 and sheet4 where the formulas are located when the Excel table is opened every time, hiding the sheet 2 which is not seen by an operator, clearing useless information in the sheet1, preparing for the next operation, prohibiting the operator from newly building the sheet table in the template, modifying the formulas and encrypting the background. "Sheets (" MES info entry "). Visible = False" background code, is the code used to hide the sheet table.
Claims (4)
1. A method for automatically generating a production record of a galvanized outlet is characterized by comprising the following steps:
by using EXCE L and VB technology, an Excel template which can automatically divide the basic information of a large steel coil at a galvanizing inlet into a plurality of small steel coils according to the production process information in a galvanizing MES production system and record the specification, steel type and production process information of each small steel coil is manufactured;
and (3) running a VB program on the Excel template background, and automatically completing information input and generation only by clicking a corresponding button in the Excel template once by an operator through a mouse.
2. The method for automatically generating the production record of the galvanized outlet according to claim 1, which is characterized by comprising the following specific steps of:
step a, building a template, firstly building an Excel, starting macro application, respectively building 4 sheet tables in the Excel, and sequentially naming the sheet tables as sheet1 to sheet4, wherein the sheet1 is used as a main interface with the same table format as the production record, 3 macro loading buttons for operating the sheet tables from the sheet 2 to the sheet4 are inserted into the sheet1 interface, and the macro loading buttons are respectively named as MES information importing, one steel coil for two, and one steel coil for three; the sheet 2 is used for storing a production plan exported by the MES production system; sheet3 is used for making a one-to-two formula, sheet4 is used for making a one-to-three formula, and content information needs to correspond to final bundling information of production information;
b, operating a first background, writing codes in an Excel background by using a VB programming function, realizing one-key introduction of a production plan exported by an MES production system into a sheet 2 in the Excel through a macro loading button 1, correspondingly copying production information in the sheet3 and the sheet4 into the sheet1 through the macro loading button 2 or the macro loading button 3, and reserving a mode without a formula, so that an operator can conveniently copy and paste the production plan; when a new MES production plan exists, when the operations are repeated again, the background program can automatically clear useless information in the sheet1 and the sheet 2 and generate new bundling information;
and c, running a second background, writing codes in the Excel background, automatically hiding the sheets 3 to 4 where the formulas are located when the Excel is opened every time, hiding the sheet 2 which does not need to be seen by an operator, automatically clearing useless information in the sheets 1 and 2, preparing for next operation, prohibiting the operator from building a sheet table or modifying the formulas in the Excel template, and simultaneously encrypting the Excel background.
3. The method for automatically generating the galvanized outlet production record as claimed in claim 2, wherein the one-to-two formula or the one-to-three formula are all transverse search formula H L OOKUP functions.
4. The method for automatically generating the production record of the galvanized outlet according to claim 3, characterized in that: in the step b, when the information in the sheet 3-sheet 4 is correspondingly copied into the sheet1 through the macro loading button 2 and the macro loading button 3, the copying process is to select pasting copying without formulas, the removal of useless information in the sheet1 and the sheet 2 is synchronously realized, the marking of important abnormal operation is synchronously realized in the production process, and key characters of determined edge cutting in the galvanizing edge cutting requirement are marked in a key mode.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010186883.5A CN111507077A (en) | 2020-03-17 | 2020-03-17 | Method for automatically generating production records of galvanized outlet |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010186883.5A CN111507077A (en) | 2020-03-17 | 2020-03-17 | Method for automatically generating production records of galvanized outlet |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN111507077A true CN111507077A (en) | 2020-08-07 |
Family
ID=71871593
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202010186883.5A Pending CN111507077A (en) | 2020-03-17 | 2020-03-17 | Method for automatically generating production records of galvanized outlet |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN111507077A (en) |
Citations (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103605917A (en) * | 2013-12-11 | 2014-02-26 | 武钢集团昆明钢铁股份有限公司 | Spreadsheet system based on multi-user environment and implementation method of spreadsheet system |
| CN105183705A (en) * | 2015-10-16 | 2015-12-23 | 中铁五局（集团）有限公司 | Method for automatically compiling engineering data catalog by use of VBA codes |
| CN105446948A (en) * | 2015-11-13 | 2016-03-30 | 武汉鸿图节能技术有限公司 | Report automatic generation method and system |
| CN106445897A (en) * | 2016-08-30 | 2017-02-22 | 亚洲硅业（青海）有限公司 | Method for automatically filling data information and automatically judging product grade |
| CN108549624A (en) * | 2018-04-18 | 2018-09-18 | 宁夏通信规划设计院（有限责任公司） | Engineeing design for communication budget and illustrate text automation generate system and method |
| CN109492276A (en) * | 2018-10-24 | 2019-03-19 | 陕西泰德汽车空调有限公司 | The method for calculating air-conditioning duct processing technology based on VBA module in Excel |
| CN109658215A (en) * | 2018-12-10 | 2019-04-19 | 平安科技（深圳）有限公司 | Transaction account calculation method, device and computer readable storage medium |
| CN110414926A (en) * | 2019-07-03 | 2019-11-05 | 平安科技（深圳）有限公司 | Account management method, device and computer readable storage medium |
-
2020
- 2020-03-17 CN CN202010186883.5A patent/CN111507077A/en active Pending
Patent Citations (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103605917A (en) * | 2013-12-11 | 2014-02-26 | 武钢集团昆明钢铁股份有限公司 | Spreadsheet system based on multi-user environment and implementation method of spreadsheet system |
| CN105183705A (en) * | 2015-10-16 | 2015-12-23 | 中铁五局（集团）有限公司 | Method for automatically compiling engineering data catalog by use of VBA codes |
| CN105446948A (en) * | 2015-11-13 | 2016-03-30 | 武汉鸿图节能技术有限公司 | Report automatic generation method and system |
| CN106445897A (en) * | 2016-08-30 | 2017-02-22 | 亚洲硅业（青海）有限公司 | Method for automatically filling data information and automatically judging product grade |
| CN108549624A (en) * | 2018-04-18 | 2018-09-18 | 宁夏通信规划设计院（有限责任公司） | Engineeing design for communication budget and illustrate text automation generate system and method |
| CN109492276A (en) * | 2018-10-24 | 2019-03-19 | 陕西泰德汽车空调有限公司 | The method for calculating air-conditioning duct processing technology based on VBA module in Excel |
| CN109658215A (en) * | 2018-12-10 | 2019-04-19 | 平安科技（深圳）有限公司 | Transaction account calculation method, device and computer readable storage medium |
| CN110414926A (en) * | 2019-07-03 | 2019-11-05 | 平安科技（深圳）有限公司 | Account management method, device and computer readable storage medium |
Non-Patent Citations (1)
| Title |
|---|
| 陈海生 等: "Excel VBA 在医院基本药物数据统计中的应用", 《中国现代应用药学》 * |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN105069134B (en) | A kind of automatic collection method of Oracle statistical informations | |
| Walton | Theory and research on industrialization | |
| CN102236659B (en) | Method and system for filtering data from data source by using complex conditions | |
| CN110609830A (en) | Decision engine system based on auditing strategy | |
| CN114707430B (en) | Multi-user encryption based federated learning visualization system and method | |
| CN101650804A (en) | Method for managing process of third generation mobile communication operating and maintaining system | |
| CN109117470A (en) | A kind of evaluation relation extracting method and device for evaluating text information | |
| CN109636092A (en) | A kind of warehouse goods yard distribution method based on double factor optimization | |
| CN111507077A (en) | Method for automatically generating production records of galvanized outlet | |
| CN111858593B (en) | Data processing system and method for sub-service plate | |
| Kirkpatrick | Regionalisation, regionalism and East Asian economic cooperation | |
| CN108445853A (en) | A kind of shared workshop of the production capacity based on cloud data | |
| Jokic | The importance of considering internal audit as a decision-making by top-management of an agricultural company | |
| CN114493364A (en) | Model construction method and device, computer readable storage medium and electronic equipment | |
| CN114548916A (en) | Approval method for complex workflow and specified approver | |
| Razzolini | The Need to Go Beyond the Contract: Economic and Bureaucratic Dependence in Personal Work Relations | |
| CN106780095A (en) | Garment technology information system | |
| Coluccia | The second industrial revolution (late 1800s and early 1900s) | |
| CN110413620A (en) | Visualized data structure configuration method and system | |
| CN110175772A (en) | The power grid future models construction method and system stacked based on increment dynamic | |
| CN112131821B (en) | Word processing method applied to PCB processing | |
| Kajima | Light Industry: Socialist Industrialization and the Textile Industry | |
| CN117236804B (en) | Financial enterprise performance identification method, equipment and medium | |
| CN102855227A (en) | Document processing system and method | |
| CN107943988A (en) | A kind of data joining method and device |
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 | ||
| RJ01 | Rejection of invention patent application after publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20200807 |