CN112686014A - Cable number plate compiling system and method - Google Patents
Cable number plate compiling system and method Download PDFInfo
- Publication number
- CN112686014A CN112686014A CN202011541692.2A CN202011541692A CN112686014A CN 112686014 A CN112686014 A CN 112686014A CN 202011541692 A CN202011541692 A CN 202011541692A CN 112686014 A CN112686014 A CN 112686014A
- Authority
- CN
- China
- Prior art keywords
- cable
- number plate
- document
- compiling
- clicking
- 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
Images
Landscapes
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention discloses a cable number plate compiling system and a method thereof, which comprises cable inventory import, cable inventory display, compiling mode selection, document creation, document combination, document storage and document printing. The invention has the beneficial effects that: the traditional work of repeatedly writing the number plate document by manual work is replaced by computer software. The electronic version cable provided by the design institute is registered and imported into the software, and the software automatically compiles the electronic version cable into a number plate document which can be directly printed. The practice proves that the system not only can effectively improve the compiling quality, but also greatly accelerates the compiling speed, simplifies the construction process, saves the human resource input, shortens the working period and reduces the loss of the number plate material through software research and development and application.
Description
Technical Field
The invention relates to a cable number plate compiling method, in particular to a cable number plate compiling system and a cable number plate compiling method, and belongs to the technical field of cable information arrangement.
Background
The cable number plate is a display plate for marking the number, the starting point, the area, the length, the specification, the model and other related information of the cable and various cables. Large scale use in substations and other industries. Before the construction of cable registration, the cable number plate is firstly compiled and printed, and in the prior engineering, the compiling of the cable number plate is completed by manual input. The following problems are typically encountered during the writing process:
1.1 the information label is incomplete;
1.2 the writing error rate is higher;
1.3 typesetting is not standard;
1.4 the layout is incorrect and leads to failure to print;
1.5 the labor intensity of the personnel is high, the working efficiency is low and the working period is long.
Based on the above, the application provides a cable number plate compiling system and a cable number plate compiling method.
Disclosure of Invention
The invention aims to provide a cable number plate writing system and a method thereof for solving the problems.
The invention realizes the purpose through the following technical scheme: a cable number plate writing system comprises the following steps:
step one, cable inventory import, namely importing the cable inventory in an excel format into software;
step two, cable inventory display, namely displaying the imported excel cable inventory and checking whether the import is correct;
selecting a compiling mode, selecting single-side or paired compiling, selecting single, local and overall compiling;
creating a document, classifying the data, importing the data into a word template for processing, and independently forming a word document after each line of excel data is processed;
step five, merging the documents, and merging all the independent word documents;
step six, saving and printing the document, wherein the document can be directly printed after being saved; the electronic document can also be saved for later printing.
As a still further scheme of the invention: in the first step, the cable inventory file for importing includes filling in a cable starting point, a cable specification, a cable length and a cable number at a specified position.
As a still further scheme of the invention: in the first step, the software for importing is based on a design institute cable inventory as a data source and a standard cable number plate writing module, and can be automatically written into a directly printable number plate document according to a cable number plate standard format and stored by importing the cable inventory.
As a still further scheme of the invention: in the second step, the displayed cable information includes the number, the starting point, the area, the length, the specification and the model of the cable.
As a still further scheme of the invention: in the third step, when the number plate documents are compiled for a single screen cabinet or terminal box device, a single-side compiling function can be used, and when the number plate documents at two ends of the cable are compiled, a pair compiling function can be used.
As a still further scheme of the invention: in the fourth step, the created document can be used on a mainstream operating system such as windows XP, windows 2000, windows ME, and windows 7.
An operation method of a cable number plate writing system, comprising:
A. and (4) installing software, operating 'cable number plate writing software' by double clicking, entering an installation guide, clicking 'next' to enter a license agreement interface, reading the installation use agreement and selecting 'I accept terms in the license agreement' to enter an installation program, or exiting the installation program. Clicking the next step, clicking the next step after the user name and the unit are filled, selecting the installation type, defaulting to ' complete installation ', clicking the next step ', clicking ' installation ', entering a software installation interface, waiting for the installation to be completed, and clicking ' completion ' after the installation is completed;
B. the software is opened and operated, and the cable number plate compiling software is found under a cable number plate compiling software folder under an installation path, exe' can be operated by double clicking, or a cable number plate compiling software shortcut is directly clicked on a desktop;
C. after clicking a lead-in key, selecting a storage position of a cable inventory to be written and opening the storage position;
D. selecting a worksheet: clicking a loading key to select a worksheet to be compiled in the cable inventory;
E. after the operation is finished, the writing work is started by clicking the writing, the work progress is displayed through the work progress bar, and a dialog box is popped up to prompt completion after the completion;
F. and clicking a confirmation button in the dialog box, namely opening the written word document for viewing and printing, saving the file in the word document, and waiting for printing at a later stage.
The invention has the beneficial effects that: the cable number plate compiling system and the method thereof are reasonable in design, and computer software is used for replacing the traditional work of manually and repeatedly compiling number plate documents. The electronic version cable provided by the design institute is registered and imported into the software, and the software automatically compiles the electronic version cable into a number plate document which can be directly printed. The practice proves that the system not only can effectively improve the compiling quality, but also greatly accelerates the compiling speed, simplifies the construction process, saves the human resource input, shortens the working period and reduces the loss of the number plate material through software research and development and application.
Drawings
FIG. 1 is a schematic flow chart of the system of the present invention.
Detailed Description
The technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the drawings in the embodiments of the present invention, and it is obvious that the described embodiments are only a part of the embodiments of the present invention, and not all of the embodiments. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention.
Referring to fig. 1, a cable number plate compiling system includes the following steps:
step one, cable inventory import, namely importing the cable inventory in an excel format into software;
step two, cable inventory display, namely displaying the imported excel cable inventory and checking whether the import is correct;
selecting a compiling mode, selecting single-side or paired compiling, selecting single, local and overall compiling;
creating a document, classifying the data, importing the data into a word template for processing, and independently forming a word document after each line of excel data is processed;
step five, merging the documents, and merging all the independent word documents;
step six, saving and printing the document, wherein the document can be directly printed after being saved; the electronic document can also be saved for later printing.
In the embodiment of the present invention, in the first step, the cable inventory file for importing includes filling in a cable start point, a cable specification, a length, and a cable number at a designated position, so that the numbered cable information is completely labeled.
In the embodiment of the invention, in the first step, the software for importing is based on a cable inventory of a design institute as a data source and a standard cable number plate writing module, and can be automatically written into a directly printable number plate document according to a standard format of the cable number plate and stored by importing the cable inventory.
In the embodiment of the present invention, in the second step, the displayed cable information includes a number, a starting point, an area, a length, a specification, and a model of the cable.
In the third step of the embodiment of the invention, when the number plate document is compiled for a single screen cabinet or terminal box device, a single-side compiling function can be used, when the number plate documents at two ends of the cable are compiled, a paired compiling function can be used, and proper functions can be selected according to specific requirements, so that the operation and the use are convenient.
In the fourth step of the embodiment of the present invention, the created document may be used in a mainstream operating system such as windows XP, windows 2000, windows ME, and windows 7, and the document has good compatibility and can be opened and viewed in different computer systems.
An operation method of a cable number plate writing system, comprising:
A. and (4) installing software, operating 'cable number plate writing software' by double clicking, entering an installation guide, clicking 'next' to enter a license agreement interface, reading the installation use agreement and selecting 'I accept terms in the license agreement' to enter an installation program, or exiting the installation program. Clicking the next step, clicking the next step after the user name and the unit are filled, selecting the installation type, defaulting to ' complete installation ', clicking the next step ', clicking ' installation ', entering a software installation interface, waiting for the installation to be completed, and clicking ' completion ' after the installation is completed;
B. the software is opened and operated, and the cable number plate compiling software is found under a cable number plate compiling software folder under an installation path, exe' can be operated by double clicking, or a cable number plate compiling software shortcut is directly clicked on a desktop;
C. after clicking a lead-in key, selecting a storage position of a cable inventory to be written and opening the storage position;
D. selecting a worksheet: clicking a loading key to select a worksheet to be compiled in the cable inventory;
E. after the operation is finished, the writing work is started by clicking the writing, the work progress is displayed through the work progress bar, and a dialog box is popped up to prompt completion after the completion;
F. and clicking a confirmation button in the dialog box, namely opening the written word document for viewing and printing, saving the file in the word document, and waiting for printing at a later stage.
It will be evident to those skilled in the art that the invention is not limited to the details of the foregoing illustrative embodiments, and that the present invention may be embodied in other specific forms without departing from the spirit or essential attributes thereof. The present embodiments are therefore to be considered in all respects as illustrative and not restrictive, the scope of the invention being indicated by the appended claims rather than by the foregoing description, and all changes which come within the meaning and range of equivalency of the claims are therefore intended to be embraced therein. Any reference sign in a claim should not be construed as limiting the claim concerned.
Furthermore, it should be understood that although the present description refers to embodiments, not every embodiment may contain only a single embodiment, and such description is for clarity only, and those skilled in the art should integrate the description, and the embodiments may be combined as appropriate to form other embodiments understood by those skilled in the art.
Claims (7)
1. A cable number plate writing system is characterized by comprising the following steps:
step one, cable inventory import, namely importing the cable inventory in an excel format into software;
step two, cable inventory display, namely displaying the imported excel cable inventory and checking whether the import is correct;
selecting a compiling mode, selecting single-side or paired compiling, selecting single, local and overall compiling;
creating a document, classifying the data, importing the data into a word template for processing, and independently forming a word document after each line of excel data is processed;
step five, merging the documents, and merging all the independent word documents;
step six, saving and printing the document, wherein the document can be directly printed after being saved; the electronic document can also be saved for later printing.
2. A cable number plate authoring system according to claim 1 wherein: in the first step, the cable inventory file for importing includes filling in a cable starting point, a cable specification, a cable length and a cable number at a specified position.
3. A cable number plate authoring system according to claim 1 wherein: in the first step, the software for importing is based on a design institute cable inventory as a data source and a standard cable number plate writing module, and can be automatically written into a directly printable number plate document according to a cable number plate standard format and stored by importing the cable inventory.
4. A cable number plate authoring system according to claim 1 wherein: in the second step, the displayed cable information includes the number, the starting point, the area, the length, the specification and the model of the cable.
5. A cable number plate authoring system according to claim 1 wherein: in the third step, when the number plate documents are compiled for a single screen cabinet or terminal box device, a single-side compiling function can be used, and when the number plate documents at two ends of the cable are compiled, a pair compiling function can be used.
6. A cable number plate authoring system according to claim 1 wherein: in the fourth step, the created document can be used on windows XP, windows 2000, windows ME, and windows 7 operating systems.
7. A method of operating a cable number plate writing system according to claim 1, characterized in that: the operation method comprises the following steps:
A. and (4) installing software, operating 'cable number plate writing software' by double clicking, entering an installation guide, clicking 'next' to enter a license agreement interface, reading the installation use agreement and selecting 'I accept terms in the license agreement' to enter an installation program, or exiting the installation program. Clicking the next step, clicking the next step after the user name and the unit are filled, selecting the installation type, defaulting to ' complete installation ', clicking the next step ', clicking ' installation ', entering a software installation interface, waiting for the installation to be completed, and clicking ' completion ' after the installation is completed;
B. the software is opened and operated, and the cable number plate compiling software is found under a cable number plate compiling software folder under an installation path, exe' can be operated by double clicking, or a cable number plate compiling software shortcut is directly clicked on a desktop;
C. after clicking a lead-in key, selecting a storage position of a cable inventory to be written and opening the storage position;
D. selecting a worksheet: clicking a loading key to select a worksheet to be compiled in the cable inventory;
E. after the operation is finished, the writing work is started by clicking the writing, the work progress is displayed through the work progress bar, and a dialog box is popped up to prompt completion after the completion;
F. and clicking a confirmation button in the dialog box, namely opening the written word document for viewing and printing, saving the file in the word document, and waiting for printing at a later stage.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011541692.2A CN112686014A (en) | 2020-12-23 | 2020-12-23 | Cable number plate compiling system and method |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011541692.2A CN112686014A (en) | 2020-12-23 | 2020-12-23 | Cable number plate compiling system and method |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN112686014A true CN112686014A (en) | 2021-04-20 |
Family
ID=75451229
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202011541692.2A Pending CN112686014A (en) | 2020-12-23 | 2020-12-23 | Cable number plate compiling system and method |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN112686014A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113268966A (en) * | 2021-06-11 | 2021-08-17 | 中国中元国际工程有限公司 | Automatic generation method for cable inventory of automatic control system |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103779799A (en) * | 2014-01-22 | 2014-05-07 | 山东送变电工程公司 | Virtual terminal graphical display method of field debugging of intelligent transformer substation |
| US20180091568A1 (en) * | 2016-06-06 | 2018-03-29 | Recognition Concepts, Inc. | Digital signage and digital signage content manager |
| CN108241605A (en) * | 2017-12-13 | 2018-07-03 | 广西电网有限责任公司电力科学研究院 | A kind of technical report standardization write method based on VC |
| CN110598187A (en) * | 2019-08-06 | 2019-12-20 | 中国华冶科工集团有限公司 | Batch manufacturing method of cable nameplates |
-
2020
- 2020-12-23 CN CN202011541692.2A patent/CN112686014A/en active Pending
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103779799A (en) * | 2014-01-22 | 2014-05-07 | 山东送变电工程公司 | Virtual terminal graphical display method of field debugging of intelligent transformer substation |
| US20180091568A1 (en) * | 2016-06-06 | 2018-03-29 | Recognition Concepts, Inc. | Digital signage and digital signage content manager |
| CN108241605A (en) * | 2017-12-13 | 2018-07-03 | 广西电网有限责任公司电力科学研究院 | A kind of technical report standardization write method based on VC |
| CN110598187A (en) * | 2019-08-06 | 2019-12-20 | 中国华冶科工集团有限公司 | Batch manufacturing method of cable nameplates |
Non-Patent Citations (3)
| Title |
|---|
| 吴绮荣: "一种新型的电缆牌制作流程", pages 1 - 3, Retrieved from the Internet <URL:https://www.doc88.com/p-574882987184.html> * |
| 热爱知识: "怎么把做好的电缆清册（Excel表格）直接转换成电缆牌（还是excel）", pages 1 - 2, Retrieved from the Internet <URL:https://zhidao.baidu.com/question/304662563.html> * |
| 端木怡雍谧: "怎么把做好的电缆清册（Excel表格）直接转换到电缆牌打印模版上", Retrieved from the Internet <URL:https://zhidao.baidu.com/question/247577718258039284.html> * |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113268966A (en) * | 2021-06-11 | 2021-08-17 | 中国中元国际工程有限公司 | Automatic generation method for cable inventory of automatic control system |
| CN113268966B (en) * | 2021-06-11 | 2023-01-10 | 中国中元国际工程有限公司 | Automatic generation method for cable inventory of automatic control system |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN109948134B (en) | Report automatic generation method, system, electronic equipment and storage medium | |
| CN109801347B (en) | Method, device, equipment and medium for generating editable image template | |
| US9207933B2 (en) | Identifying authors of changes between multiple versions of a file | |
| CN107886439A (en) | Insurance products development approach, device, equipment and computer-readable recording medium | |
| CN103324731A (en) | Method and device for converting spreadsheet file into web format file | |
| CN113609820B (en) | Method, device and equipment for generating word file based on extensible markup language file | |
| EP2273394A1 (en) | Document processing method, system and device | |
| CN110705237B (en) | Automatic document generation method, data processing device and storage medium | |
| CN111652232A (en) | Bill identification method and device, electronic equipment and computer readable storage medium | |
| CN110543303A (en) | Visual business platform | |
| CN110609989B (en) | Operation method and system for rapidly generating information form by adopting predefined layout component | |
| CN110968294A (en) | Business domain model establishing system and method | |
| US9135234B1 (en) | Collaborative generation of digital content with interactive reports | |
| CN112668290A (en) | Dynamic form generation method and system based on gridding design | |
| CN113255314B (en) | Configurable report template system implementation method, electronic equipment and storage medium | |
| CN112686014A (en) | Cable number plate compiling system and method | |
| CN112487334A (en) | Method, apparatus, computer device and medium for front end page language translation | |
| CN113723063A (en) | Method for converting RTF (real time function) into HTML (hypertext markup language) and realizing effect on PDF (Portable document Format) file | |
| CN107562710B (en) | Chart processing device and method | |
| CN113760287A (en) | Form creating method and device based on JSON structure | |
| CN102982624A (en) | Printing method for point-of-sale (POS) machine trading center based on threshold limit value (TLV) format data | |
| CN115964079A (en) | Automatic document generation method and system, electronic device and storage medium | |
| CN111736815A (en) | Test file script modular development tool, system and method | |
| CN108766513B (en) | Intelligent health medical data structured processing system | |
| CN114004591A (en) | Automatic user-defined form auditing method and device, electronic equipment and storage medium |
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 |