CN112686013A - Cable number head compiling system and method - Google Patents

Cable number head compiling system and method Download PDF

Info

Publication number
CN112686013A
CN112686013A CN202011536504.7A CN202011536504A CN112686013A CN 112686013 A CN112686013 A CN 112686013A CN 202011536504 A CN202011536504 A CN 202011536504A CN 112686013 A CN112686013 A CN 112686013A
Authority
CN
China
Prior art keywords
cable
software
data
clicking
installation
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
Application number
CN202011536504.7A
Other languages
Chinese (zh)
Inventor
张超
戴金
蒋倩
龚俊
寇娟
许艺琼
郭婧
周睿
程宙强
唐晓璐
熊一
杨若思
甘露
胡俊
吴叙卓
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
State Grid Hubei Transmission And Transformation Engineering Co ltd
State Grid Corp of China SGCC
Original Assignee
State Grid Hubei Transmission And Transformation Engineering Co ltd
State Grid Corp of China SGCC
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by State Grid Hubei Transmission And Transformation Engineering Co ltd, State Grid Corp of China SGCC filed Critical State Grid Hubei Transmission And Transformation Engineering Co ltd
Priority to CN202011536504.7A priority Critical patent/CN112686013A/en
Publication of CN112686013A publication Critical patent/CN112686013A/en
Pending legal-status Critical Current

Links

Images

Landscapes

  • Management, Administration, Business Operations System, And Electronic Commerce (AREA)

Abstract

The invention discloses a cable number head compiling system and a method thereof, which comprises data import, data processing, data display and data export. The invention has the beneficial effects that: the secondary cable inventory that provides at the design institute is the template, utilizes the computer to handle a large amount of miscellaneous data, greatly improves work efficiency, reduces working strength, utilizes computer software's intelligent associative function to simplified the preparation work before the construction, through practice proves, not only can effectually improve the quality of writing, accelerated the speed of writing moreover by a wide margin.

Description

Cable number head compiling system and method
Technical Field
The invention relates to a cable number head compiling method, in particular to a cable number head compiling system and a cable number head compiling method, and belongs to the technical field of cable information arrangement.
Background
The cable number head is a protection pipe for marking a cable core in the secondary cable wiring construction of the transformer substation engineering, is an important description of the functions of the cable core on a real object, and plays an important role in the operation and maintenance of the transformer substation. The conventional labeler has several disadvantages: the cable number head compiling system and the cable number head compiling method are provided based on the fact that a keyboard is difficult to operate, manual input amount is large, and storage is inconvenient.
Disclosure of Invention
The invention aims to provide a cable number head writing system and a method thereof for solving the problems.
The invention realizes the purpose through the following technical scheme: a cable number head compiling system and a method thereof comprise the following steps:
step one, data import, namely importing an excel-format cable inventory into software;
step two, data processing, namely extracting the required information in the cable inventory to a database of software, automatically classifying the extracted data in the database, and filling the information in the database in a template by using the software;
step three, data display, namely displaying the imported cable inventory file and checking whether the import is correct;
and step four, exporting data, and directly using the data for printing after the software is written.
As a still further scheme of the invention: in the first step, the used software provides a cable registration and a wiring diagram for a design institute as a data source, the computer automatically extracts the information of the cable number and the cable core number from the cable registration, and manually inputs the circuit number information by the wiring bluediagram association, and finally the information is combined into a cable number header document which can be directly used for printing.
As a still further scheme of the invention: in the first step, after the cable list is imported into the software, possible loop number combinations can be intelligently associated.
As a still further scheme of the invention: in the second step, the extracted data information comprises a cable number, a cable core number and a cable core loop number.
As a still further scheme of the invention: in the second step, the data is processed by editing the loop number, and the rules of the cable number head loop number are added, deleted, modified, inquired and the like.
As a still further scheme of the invention: and in the third step, the cable inventory file displays data in a read-only mode.
A cable number head writing system comprises an operation method of:
A. and (4) installing software, operating 'cable number head writing software' by double clicking, entering an installation guide, clicking 'next' to enter a license agreement interface, reading an 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 head compiling software is found under a folder of the cable number head compiling software in an installation path, exe' can operate the software by double clicking or directly click the cable number head compiling software shortcut on a desktop;
C. after clicking an import button, conducting inventory import on the electronic version cable of the design institute to software, selecting a cable inventory file to be written in a file list, selecting a worksheet to be operated, then clicking the import inventory, and automatically extracting required data into a database by the software;
D. the method comprises the steps of clicking the cable registration information displayed in a dialog box, editing, and displaying a printing mode of the cable, wherein the cable number and the core number can be obtained according to the registration information, the loop number needs to be input by contrast with a drawing, an intelligent association function is designed, and relevant rules such as B630, C630, N600 and the like can be automatically associated after the A630 or other regular loop numbers are input into the first loop number. Thereby maximally improving the input efficiency. After editing is finished, the generated number head is clicked, and then a number head document for direct printing can be generated;
E. and checking the cable head edition file in a read-only mode. So as to prevent the misoperation from leading to the modification of the file;
F. and exporting the data produced by editing and directly using the data for printing.
The invention has the beneficial effects that: the cable number head compiling system and the method thereof are reasonable in design, a secondary cable list provided by a design institute is used as a template, a computer is used for processing a large amount of complicated data, the working efficiency is greatly improved, the working intensity is reduced, the intelligent association function of computer software is used, the preparation work before construction is simplified, and practice proves that the compiling quality can be effectively improved, and the compiling speed is greatly accelerated.
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 writing system includes the following steps:
step one, data import, namely importing an excel-format cable inventory into software;
step two, data processing, namely extracting the required information in the cable inventory to a database of software, automatically classifying the extracted data in the database, and filling the information in the database in a template by using the software;
step three, data display, namely displaying the imported cable inventory file and checking whether the import is correct;
and step four, exporting data, and directly using the data for printing after the software is written.
In the embodiment of the invention, in the first step, the used software is a data source of a cable registration and a wiring diagram provided by a design institute, the computer automatically extracts the information of the cable number and the cable core number from the cable registration, manually inputs the circuit number information by the wiring bluediagram association, and finally combines the information into a cable number header document which can be directly used for printing.
In the embodiment of the invention, in the first step, after the cable inventory is imported into the software, the possible loop number combinations can be intelligently associated, so that the output process is simplified.
In the embodiment of the present invention, in the second step, the extracted data information includes a cable number, a cable core number, and a cable core loop number, so that the numbered cable number header information is completely labeled.
In the second step of the present invention, the data is processed by editing the loop number, and the rules of the loop number of the cable head are added, deleted, modified, and queried.
In the third step of the present invention, the cable registration file is data-displayed in the read-only mode to prevent the file from being modified due to the misoperation.
An operation method of a cable number head writing system comprises the following steps:
A. and (4) installing software, operating 'cable number head writing software' by double clicking, entering an installation guide, clicking 'next' to enter a license agreement interface, reading an 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 head compiling software is found under a folder of the cable number head compiling software in an installation path, exe' can operate the software by double clicking or directly click the cable number head compiling software shortcut on a desktop;
C. after clicking an import button, conducting inventory import on the electronic version cable of the design institute to software, selecting a cable inventory file to be written in a file list, selecting a worksheet to be operated, then clicking the import inventory, and automatically extracting required data into a database by the software;
D. the method comprises the steps of clicking the cable registration information displayed in a dialog box, editing, and displaying a printing mode of the cable, wherein the cable number and the core number can be obtained according to the registration information, the loop number needs to be input by contrast with a drawing, an intelligent association function is designed, and relevant rules such as B630, C630, N600 and the like can be automatically associated after the A630 or other regular loop numbers are input into the first loop number. Thereby maximally improving the input efficiency. After editing is finished, the generated number head is clicked, and then a number head document for direct printing can be generated;
E. and checking the cable head edition file in a read-only mode. So as to prevent the misoperation from leading to the modification of the file;
F. and exporting the data produced by editing and directly using the data for printing.
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 head writing system is characterized by comprising the following steps:
step one, data import, namely importing an excel-format cable inventory into software;
step two, data processing, namely extracting the required information in the cable inventory to a database of software, automatically classifying the extracted data in the database, and filling the information in the database in a template by using the software;
step three, data display, namely displaying the imported cable inventory file and checking whether the import is correct;
and step four, exporting data, and directly using the data for printing after the software is written.
2. The cable number writing system of claim 1, wherein: in the first step, the used software provides a cable registration and a wiring diagram for a design institute as a data source, the computer automatically extracts the information of the cable number and the cable core number from the cable registration, and manually inputs the circuit number information by the wiring bluediagram association, and finally the information is combined into a cable number header document which can be directly used for printing.
3. A cable header authoring system according to claim 1 or 2, wherein: in the first step, after the cable list is imported into the software, possible loop number combinations can be intelligently associated.
4. The cable number writing system of claim 1, wherein: in the second step, the extracted data information comprises a cable number, a cable core number and a cable core loop number.
5. The cable number writing system of claim 1, wherein: in the second step, the data is processed by editing the loop number, and the rules of the loop number of the cable head are added, deleted, modified and inquired.
6. The cable number writing system of claim 1, wherein: and in the third step, the cable inventory file displays data in a read-only mode.
7. An operation method of the cable number head writing system according to claim 1, wherein the operation method comprises:
A. and (4) installing software, operating 'cable number head writing software' by double clicking, entering an installation guide, clicking 'next' to enter a license agreement interface, reading an 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 head compiling software is found under a folder of the cable number head compiling software in an installation path, exe' can operate the software by double clicking or directly click the cable number head compiling software shortcut on a desktop;
C. after clicking an import button, conducting inventory import on the electronic version cable of the design institute to software, selecting a cable inventory file to be written in a file list, selecting a worksheet to be operated, then clicking the import inventory, and automatically extracting required data into a database by the software;
D. the method comprises the steps that cable inventory information displayed in a dialog box is clicked to edit, a printing mode of a cable can appear, wherein the number of the cable and the core number can be obtained according to the inventory information, the loop number needs to be input by contrast with a drawing, an intelligent association function is designed, when A630 or other regular loop numbers are input into a first loop number, rules of B630, C630 and N600 can be automatically associated, so that the input efficiency is improved to the maximum extent, and after the editing is finished, a generated number head is clicked, and a number head document for direct printing can be generated;
E. and checking the cable head edition file in a read-only mode. So as to prevent the misoperation from leading to the modification of the file;
F. and exporting the data produced by editing and directly using the data for printing.
CN202011536504.7A 2020-12-23 2020-12-23 Cable number head compiling system and method Pending CN112686013A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202011536504.7A CN112686013A (en) 2020-12-23 2020-12-23 Cable number head compiling system and method

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202011536504.7A CN112686013A (en) 2020-12-23 2020-12-23 Cable number head compiling system and method

Publications (1)

Publication Number Publication Date
CN112686013A true CN112686013A (en) 2021-04-20

Family

ID=75451014

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202011536504.7A Pending CN112686013A (en) 2020-12-23 2020-12-23 Cable number head compiling system and method

Country Status (1)

Country Link
CN (1) CN112686013A (en)

Cited By (1)

* Cited by examiner, † Cited by third party
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 (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN104376171A (en) * 2014-11-17 2015-02-25 陕西合信诚铭软件科技有限公司 Automatic design method and system for terminal block drawing and cable detailed list
CN110782047A (en) * 2019-10-25 2020-02-11 小波科技有限公司 Intelligent label system
CN111400899A (en) * 2020-03-13 2020-07-10 广州轨道交通建设监理有限公司 Processing method, system and storage medium for cable laying modeling

Patent Citations (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN104376171A (en) * 2014-11-17 2015-02-25 陕西合信诚铭软件科技有限公司 Automatic design method and system for terminal block drawing and cable detailed list
CN110782047A (en) * 2019-10-25 2020-02-11 小波科技有限公司 Intelligent label system
CN111400899A (en) * 2020-03-13 2020-07-10 广州轨道交通建设监理有限公司 Processing method, system and storage medium for cable laying modeling

Non-Patent Citations (1)

* Cited by examiner, † Cited by third party
Title
吴绮荣: "一种新型的电缆牌制作流程", pages 1 - 3, Retrieved from the Internet <URL:https://www.doc88.com/p-574882987184.html> *

Cited By (2)

* Cited by examiner, † Cited by third party
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
CN110852065A (en) Document auditing method, device, system, equipment and storage medium
CN109933796B (en) Method and device for extracting key information of bulletin text
CN113918138A (en) Flow processing method and device and computer system
US7512451B2 (en) System and method for interactive process management
CN112651218A (en) Automatic generation method and management method of bidding document, medium and computer
CN111784801B (en) Automatic drawing method and system for parking space plan of completion monomer building
CN111144116B (en) Document knowledge structured extraction method and device
CN102915476A (en) Visual business process design method
CN112686013A (en) Cable number head compiling system and method
CN110400101A (en) Industry reports analysis system and method
CN109086985B (en) Professional test information management system for spacecraft assembly
CN110675121A (en) Method for collecting picture type file material
CN117332761A (en) PDF document intelligent identification marking system
CN110413659B (en) General shopping ticket data accurate extraction method
CN115602277A (en) Medical electronic medical record labeling method, device, system and storage medium
CN112052652B (en) Automatic generation method and device for electronic courseware script
Minggao et al. Research on the Application of LLM in Power Finance Middle Platform
CN111708572B (en) Automatic control flow chart generation method based on Clang program structure
CN114118098A (en) Contract review method, equipment and storage medium based on element extraction
CN114549014A (en) Supply chain financial wind control method and system based on combination of automatic and manual auditing
CN114139521A (en) Online visualization template file based generation method
CN114035783A (en) Software code knowledge graph construction method and tool
CN112686014A (en) Cable number plate compiling system and method
Tilley Documenting software systems with views VI: lessons learned from 15 years of research & practice
CN118036731A (en) Semi-automatic labeling method and device for building process knowledge graph

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