CN112417908A - Electronic code scanning method for inputting in-out information - Google Patents
Electronic code scanning method for inputting in-out information Download PDFInfo
- Publication number
- CN112417908A CN112417908A CN202011253148.8A CN202011253148A CN112417908A CN 112417908 A CN112417908 A CN 112417908A CN 202011253148 A CN202011253148 A CN 202011253148A CN 112417908 A CN112417908 A CN 112417908A
- Authority
- CN
- China
- Prior art keywords
- test instrument
- information
- inputting
- code
- code scanning
- 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
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06K—GRAPHICAL DATA READING; PRESENTATION OF DATA; RECORD CARRIERS; HANDLING RECORD CARRIERS
- G06K7/00—Methods or arrangements for sensing record carriers, e.g. for reading patterns
- G06K7/10—Methods or arrangements for sensing record carriers, e.g. for reading patterns by electromagnetic radiation, e.g. optical sensing; by corpuscular radiation
- G06K7/10544—Methods or arrangements for sensing record carriers, e.g. for reading patterns by electromagnetic radiation, e.g. optical sensing; by corpuscular radiation by scanning of the records by radiation in the optical part of the electromagnetic spectrum
- G06K7/10821—Methods or arrangements for sensing record carriers, e.g. for reading patterns by electromagnetic radiation, e.g. optical sensing; by corpuscular radiation by scanning of the records by radiation in the optical part of the electromagnetic spectrum further details of bar or optical code scanning devices
- G06K7/10861—Methods or arrangements for sensing record carriers, e.g. for reading patterns by electromagnetic radiation, e.g. optical sensing; by corpuscular radiation by scanning of the records by radiation in the optical part of the electromagnetic spectrum further details of bar or optical code scanning devices sensing of data fields affixed to objects or articles, e.g. coded labels
-
- 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
- G06Q10/00—Administration; Management
- G06Q10/08—Logistics, e.g. warehousing, loading or distribution; Inventory or stock management
- G06Q10/087—Inventory or stock management, e.g. order filling, procurement or balancing against orders
Abstract
The invention discloses an electronic code scanning method for inputting warehouse entry and exit information, which belongs to the technical field of power equipment and comprises the following steps: coding the information of the test instrument, establishing a test instrument database to store the template information of the test instrument customized by a user, forming an EXCEL table, using a VLOOKUP function in the EXCEL table, searching and calling the complete data information of the test instrument, and automatically recording and locking the time of the test instrument for ex-warehouse and in-warehouse through the iteration of IF and NOW functions; the two-dimensional code information of the test instrument is scanned by the scanner, the test instrument information is input into an EXCEL table, an input and output recording table is automatically generated according to the template information of the test instrument, and the time for the operation link of preparing for the management of an input and output library in the emergency repair of the transformer substation accident can be effectively shortened.
Description
Technical Field
The invention relates to the technical field of power equipment, in particular to an electronic code scanning method for inputting warehouse entry and exit information.
Background
The electric power system is the important support and guarantee of economic society development, the transformer substation is then the "heart" of power transmission, according to the requirement, after equipment breaks down in the transformer substation, require that the first-aid repair personnel must prepare in the short time, the regulation is usually in 15 minutes, nevertheless according to statistics present transformer substation accident emergency repair preparation average time of using is 23 minutes/time, reach the requirement that is less than 15 minutes/time, the safe operation level of electric power system has been influenced, in transformer substation accident emergency repair preparation process, according to the step can divide into: 4 links of warehouse entry and exit management operation, personnel preparation, work order preparation and vehicle inspection are carried out, investigation is carried out when different links are used, according to accident emergency repair tasks, required test instruments are firstly prepared and whether complete or not is checked before starting, then the device name, the serial number, the user, the using time, the manager, the signature confirmation and other contents are filled, all the test instruments are finally carried to a transport vehicle, statistical analysis is carried out in investigation, the time consumption of frequently writing warehouse entry and exit records is more than 70% of the total time consumption of warehouse entry and exit management operation, and the time consumption of preparing the warehouse entry and exit management operation link in the current transformer substation accident emergency repair is larger.
Disclosure of Invention
In order to shorten the preparation time of emergency repair of the transformer substation accident, the invention aims to provide the electronic code scanning method for inputting the warehousing-in and warehousing-out information, which can effectively shorten the time of the operation link of warehousing-in and warehousing-out preparation of emergency repair of the transformer substation accident.
In order to achieve the purpose, the invention adopts the following scheme: an electronic code scanning method for entering in-out information is characterized by comprising the following steps:
step one, encoding test instrument information:
a two-dimension code master is used for carrying out two-dimension code coding on the test instrument to generate a two-dimension code carrying information of the test instrument;
step two, establishing a database:
establishing a test instrument database to store test instrument template information customized by a user, wherein the test instrument template information comprises asset numbers, equipment names, models, delivery numbers, precision grades, measuring ranges, manufacturers, use dates and use time limit information to form an EXCEL table, using VLOOKUP functions in the EXCEL table to search and call complete data information of a test instrument, and automatically recording and locking the time of delivery and storage of the test instrument through iteration of IF and NOW functions;
step three, two-dimensional code scanning and debugging:
scanning the two-dimensional code information of the test instrument by adopting a scanner, further inputting the test instrument information into an EXCEL form, automatically generating an out-of-warehouse record table according to the test instrument template information, counting the accuracy of code scanning inputting, and performing scanning debugging operation so as to ensure that the code scanning inputting is accurate to 100%.
Further, the two-dimensional code carrying the information of the test instrument is a unique lifelong ID code of the power grid asset entity corresponding to the test instrument.
Through the design scheme, the invention can bring the following beneficial effects: the invention provides an electronic code scanning method for inputting in-out information, which adopts an electronic scanning mode to input test instrument information, can accurately search a test instrument, improve the efficiency of equipment management, realize the rapid in-out and in-out of a warehouse of the test instrument, and effectively shorten the time for preparing for the emergency repair of a transformer substation accident in the in-out management operation link, thereby integrally shortening the preparation time for the emergency repair of the transformer substation accident.
Detailed Description
In order to more clearly illustrate the invention, the invention is further illustrated below with reference to specific examples, which will be understood by those skilled in the art; the following detailed description is illustrative and not restrictive, and is not to be construed as limiting the scope of the invention, which is defined by the appended claims.
The invention provides an electronic code scanning method for inputting warehouse entry and exit information, which comprises the following steps:
s1: encoding information of a test instrument:
carrying out two-dimensional code coding on the name of the test instrument by using a two-dimensional code master to generate a two-dimensional code carrying information of each test instrument so as to distinguish each test instrument;
s2: establishing a database:
establishing a test instrument ledger, namely a database to store test instrument template information customized by a user, wherein the test instrument template information comprises asset numbers, equipment names, models, delivery numbers, precision levels, measuring ranges, manufacturers, use dates and use time limit information to form an EXCEL table, then using a VLOOKUP function in the EXCEL table to search and call complete data information of the test instrument, and automatically recording and locking the time of delivery and storage of the test instrument through iteration of IF and NOW functions;
s3: scanning and debugging the two-dimensional code:
scanning the two-dimensional code information of the test instrument by adopting a scanner, further quickly inputting the test instrument information into an EXCEL form, automatically generating an input and output record table according to the test instrument template information, counting the accuracy of code scanning input, and performing scanning debugging operation so as to ensure that the code scanning input is accurate to 100%.
The two-dimensional code carrying the test instrument information is a unique lifelong ID code of the power grid asset entity corresponding to the test instrument.
Example 1
Taking the 66kV transformer accident first-aid repair as an example, the time required by each step of the warehousing and ex-warehouse operation is counted into four groups, and the time-consuming investigation results of each link of the warehousing and ex-warehouse operation are shown in table 1.
TABLE 1 time-consuming questionnaire for each link of warehousing and delivery operations
The operation of the entrance and exit management is carried out by dividing into 4 groups, adopting a scanner to carry out the operation of the entrance and exit management, counting the preparation time of the emergency repair before and after the activity and comparing with the original time, as shown in the table 2.
TABLE 2 statistics table for emergency repair preparation before and after accident
The preparation time of emergency repair of the fourth group accident is 13.3 minutes at most, and the average time is 12.8 minutes and less than 14 minutes. From the above table, it can be seen that the emergency repair preparation time for an accident after using the scanner is reduced from the original average 23 minutes to an average 12.8 minutes, which is 14 minutes below the target value.
Making consolidation measures
1. The electronic warehouse entry and exit management operation is compiled, the electronic warehouse entry and exit management operation is brought into a maintenance and test work area (test professional) equipment management system of a maintenance company, and the electronic warehouse entry and exit management operation is actively popularized to warehouse entry and exit management of other industries.
2. The adopted electronic scanning mode is used for compiling the warehouse entry and exit management operation standardization criterion and standardizing the operation flow, so that the legal and the chapter can be found in the actual operation in the future.
3. The design steps, compiler and operation instruction of the electronic warehousing and warehousing management operation are saved in the file.
4. The method for using and maintaining the electronic warehouse entry and exit management operation and the cautions are trained and explained, and a specially-assigned person is dispatched to carry out inspection and maintenance regularly.
Taking 2019 from 9 to 12 months as an example of a consolidation period, statistics is carried out on the time for emergency repair preparation of accidents, as shown in table 3.
Table 3 statistics table for emergency repair preparation of accident after movement
Therefore, the consolidation measure of the activity is continuously effective, and the activity effect is achieved.
Claims (2)
1. An electronic code scanning method for entering in-out information is characterized by comprising the following steps:
step one, encoding test instrument information:
a two-dimension code master is used for carrying out two-dimension code coding on the test instrument to generate a two-dimension code carrying information of the test instrument;
step two, establishing a database:
establishing a test instrument database to store test instrument template information customized by a user, wherein the test instrument template information comprises asset numbers, equipment names, models, delivery numbers, precision grades, measuring ranges, manufacturers, use dates and use time limit information to form an EXCEL table, using VLOOKUP functions in the EXCEL table to search and call complete data information of a test instrument, and automatically recording and locking the time of delivery and storage of the test instrument through iteration of IF and NOW functions;
step three, two-dimensional code scanning and debugging:
scanning the two-dimensional code information of the test instrument by adopting a scanner, further inputting the test instrument information into an EXCEL form, automatically generating an out-of-warehouse record table according to the test instrument template information, counting the accuracy of code scanning inputting, and performing scanning debugging operation so as to ensure that the code scanning inputting is accurate to 100%.
2. The electronic code scanning method for entering in and out information of claim 1, wherein: the two-dimensional code carrying the test instrument information is a unique lifelong ID code of the power grid asset entity corresponding to the test instrument.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011253148.8A CN112417908A (en) | 2020-11-11 | 2020-11-11 | Electronic code scanning method for inputting in-out information |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011253148.8A CN112417908A (en) | 2020-11-11 | 2020-11-11 | Electronic code scanning method for inputting in-out information |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN112417908A true CN112417908A (en) | 2021-02-26 |
Family
ID=74781569
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202011253148.8A Pending CN112417908A (en) | 2020-11-11 | 2020-11-11 | Electronic code scanning method for inputting in-out information |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN112417908A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113807791A (en) * | 2021-09-28 | 2021-12-17 | 重庆允成互联网科技有限公司 | Method for rapidly entering and exiting warehouse |
Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104636904A (en) * | 2015-02-14 | 2015-05-20 | 中国科学院合肥物质科学研究院 | Intelligent warehousing management method and system for agricultural materials based on two-dimension code and RFID (Radio Frequency Identification Devices) |
| CN107944789A (en) * | 2017-11-15 | 2018-04-20 | 惠州市蓝微电子有限公司 | A kind of input method of PACK products |
-
2020
- 2020-11-11 CN CN202011253148.8A patent/CN112417908A/en active Pending
Patent Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104636904A (en) * | 2015-02-14 | 2015-05-20 | 中国科学院合肥物质科学研究院 | Intelligent warehousing management method and system for agricultural materials based on two-dimension code and RFID (Radio Frequency Identification Devices) |
| CN107944789A (en) * | 2017-11-15 | 2018-04-20 | 惠州市蓝微电子有限公司 | A kind of input method of PACK products |
Non-Patent Citations (5)
| Title |
|---|
| 姜茂刚等: "基于Excel的医用耗材管理系统开发及应用", 《中国医学装备》 * |
| 张亮: "利用Excel提高卷烟喷码录入准确率", 《电脑知识与技术》 * |
| 张朝辉: "用Excel设计制作仓库管理系统", 《办公自动化》 * |
| 蒋佳男等: "QR二维码在手术室贵重仪器管理中的应用", 《海南医学》 * |
| 马艳等: "QR二维码在实验室仪器管理中的应用", 《蚕学通讯》 * |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113807791A (en) * | 2021-09-28 | 2021-12-17 | 重庆允成互联网科技有限公司 | Method for rapidly entering and exiting warehouse |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN113408890A (en) | Artificial intelligence-based method and system for generating evaluation report after industrial investment project | |
| CN112100219B (en) | Report generation method, device, equipment and medium based on database query processing | |
| CN111786385A (en) | Power grid operation and maintenance scheme planning method, system and equipment | |
| CN114202239A (en) | Engineering cost risk early warning system | |
| CN110109678A (en) | A kind of code audit rule library generating method, device, equipment and medium | |
| CN112417908A (en) | Electronic code scanning method for inputting in-out information | |
| CN116485220A (en) | Staff performance assessment method and device, electronic equipment and storage medium | |
| CN111680082B (en) | Government financial data acquisition system and method based on data integration | |
| CN112966946A (en) | Method and device for generating material balance index system framework | |
| CN113642669B (en) | Feature analysis-based fraud prevention detection method, device, equipment and storage medium | |
| CN114416686B (en) | Vehicle equipment fingerprint CARID identification system and identification method | |
| CN115526594A (en) | Method, device, equipment and medium for detecting implementation situation of planning control requirement | |
| CN113919609A (en) | Power distribution network model quality comprehensive evaluation method and system | |
| CN112396450A (en) | Special unit label information processing method and device for electric power spot market | |
| JPH0876992A (en) | Device and method for evaluation and management of quality of software | |
| CN111814457A (en) | Power grid engineering contract text generation method | |
| CN112308608B (en) | Data processing method and device for manufacturing cost of transformer substation, electronic equipment and storage medium | |
| CN113435701B (en) | Method and device for processing consumption quality information | |
| CN116342300B (en) | Method, device and equipment for analyzing characteristics of insurance claim settlement personnel | |
| CN116070938A (en) | Automatic generation method, device, equipment and storage medium of performance standard | |
| CN112418599A (en) | Enterprise growth path planning method and system based on index set | |
| CN115358433A (en) | Steam turbine thermal performance test instrument management system | |
| CN117952325A (en) | Standardized information management system | |
| Antonopoulos et al. | Management analysis of nuclear allocation for the generation of electricity | |
| CN114004205A (en) | Method and system for generating electric energy report |
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: 20210226 |