CN103886144A - Cable and optical cable length statistical method - Google Patents
Cable and optical cable length statistical method Download PDFInfo
- Publication number
- CN103886144A CN103886144A CN201410086095.3A CN201410086095A CN103886144A CN 103886144 A CN103886144 A CN 103886144A CN 201410086095 A CN201410086095 A CN 201410086095A CN 103886144 A CN103886144 A CN 103886144A
- Authority
- CN
- China
- Prior art keywords
- cable
- equipment
- cable duct
- closest approach
- layer
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Granted
Links
Abstract
The invention discloses a cable and optical cable length statistical method. According to the method, CAD software is used for developing an interface function, CAD independent picture layer function distinguishing devices and cable walking paths are used as independent picture layers, the independent cable walking paths are used for reading the device name in an EXCEL, the spatial distance among the devices is automatically calculated, the shortest relative path is calculated to be fed back into the EXCEL form, and accordingly the automatic statistical function is achieved. The three-dimension design is adopted, all the cable paths are planned in advance, so that the shortest path needed by a cable and optical cable is calculated automatically through logic programming, and thus the length statistical function of the cable and optical cable can be achieved. The problem that the set workload is large in the prior art is effectively solved, and in an actual test, the cable length statistical work which needs to be completed in one week originally can be completed on only one day by the aid of the method.
Description
Technical field
The invention belongs to transformer station's technical field, relate to cable and cable length statistical method in a kind of Substation Design.
Background technology
In prior art, all need the process through cable laying for cable length statistics, artificial input cable is walked footpath.And cable laying function need arrange cable for every cable and walks footpath in prior art, thereby complete length statistical function, but in design, number of cables is various, workload is set huge.Therefore the work method of prior art cannot accomplish efficiently to complete in the time measuring.
Summary of the invention
The object of the invention is to overcome the shortcoming of above-mentioned prior art, a kind of cable and cable length statistical method are provided, the method is a kind of method of automatic calculating.Utilize and in three-dimensional design, plan in advance all cable traces, thereby by logical calculated, automatically calculate the required minimal path of cable and optical cable, thereby complete the length statistical function of cable and optical cable.
The object of the invention is to be achieved through the following technical solutions:
This cable and cable length statistical method, comprise the following steps:
1) on AUTOCAD design software, set up independently cable duct figure layer and equipment drawing layer, the axis that cable duct figure layer is only used for drawing cable duct; Equipment drawing layer is only used for rendering apparatus;
2) apparatus for establishing model on equipment drawing layer is drawn cable duct axis on cable duct figure layer;
3) the equipment utilization AUTOCAD on equipment drawing layer sets up the function of piece, and different equipment is established as to different pieces, and independent name and insertion point;
4) from the cable inventory of existing EXCEL form and optical cable inventory, read the starting point of cable, optical cable and the equipment that terminal connects, and in equipment drawing layer, find the insertion point of this relevant device;
5) insertion point of zequin and end device is to the distance S1=△ X1+ △ Y1+ △ Z1 of the cable duct axis closest approach of cable duct figure layer, S2=△ X2+ △ Y2+ △ Z2, what wherein △ X, △ Y, △ Z were equipment insertion point co-ordinate to cable duct closest approach coordinate is poor; And zequin equipment is to cable duct closest approach and end device to cable duct closest approach minimum distance S3 in cable duct, three are equipment room cable, cable length S=S1+S2+S3 apart from sum;
6) will record cable length and be backfilled to cable inventory, the optical cable inventory of EXCEL form.
Further, above method is set up following functional module:
Module for reading and writing: the cable inventory and the optical cable inventory that automatically read and write EXCEL form;
Search module: query facility insertion point co-ordinate in AUTOCAD drawing automatically;
Computing module: zequin and end device insertion point are to cable duct closest approach coordinate; Zequin and end device insertion point are to cable duct closest approach spacing; Zequin equipment is to cable duct closest approach to end device to cable duct length between cable duct closest approach; Cable length between zequin, end device.
The present invention has following beneficial effect:
The cable of this method and cable length statistical method arrange the too loaded down with trivial details problem of cable trace one by one in order to solve in the measuring of cable and cable length, and put forward a kind of method of automatic calculating.Utilize and in three-dimensional design, plan in advance all cable traces, thereby by logical calculated, automatically calculate the required minimal path of cable and optical cable, thereby complete the length statistical function of cable and optical cable.Efficiently solve the huge problem of workload is set in prior art.In actual test, originally need the cable length statistical work that complete for a week, only need one day by this method.
Embodiment
In transformer station's three-dimensional design process, general use is CAD Software for Design, utilizes CAD software development interface function, implants method of the present invention and uses.Utilize Graphs With Independent layer function differentiation equipment and the cable of CAD to walk footpath for Graphs With Independent layer.Utilize independently cable to walk footpath, device name in Read EXCEL, the space length between automatic computing equipment, calculates the shortest relative path, feeds back in Microsoft Excel, completes automatic statistical function.
Below the present invention is described in further detail:
This kind of cable of the present invention and cable length statistical method, comprise the following steps:
1) on AUTOCAD design software, set up independently cable duct figure layer and equipment drawing layer, the axis that cable duct figure layer is only used for drawing cable duct; Equipment drawing layer is only used for rendering apparatus;
2) apparatus for establishing model on equipment drawing layer is drawn cable duct axis on cable duct figure layer;
3) the equipment utilization AUTOCAD on equipment drawing layer sets up the function of piece, and different equipment is established as to different pieces, and independent name and insertion point;
4) from the cable inventory of existing EXCEL form and optical cable inventory, read the starting point of cable, optical cable and the equipment that terminal connects, and in equipment drawing layer, find the insertion point of this relevant device;
5) insertion point of zequin and end device is to the distance S1=△ X1+ △ Y1+ △ Z1 of the cable duct axis closest approach of cable duct figure layer, S2=△ X2+ △ Y2+ △ Z2, what wherein △ X1, △ X2, △ Y1, △ Y2, △ Z1, △ Z2 were equipment insertion point co-ordinate to cable duct closest approach coordinate is poor; And zequin equipment is to cable duct closest approach and end device to cable duct closest approach minimum distance S3 in cable duct, three are equipment room cable, cable length S=S1+S2+S3 apart from sum;
6) will record cable length and be backfilled to cable inventory, the optical cable inventory of EXCEL form.
Utilize this method to set up functional module:
1, module for reading and writing: the cable inventory and the optical cable inventory that automatically read and write EXCEL form.
2, search module: query facility insertion point co-ordinate in autocad drawing automatically.
3, computing module: zequin and end device insertion point are to cable duct closest approach coordinate; Zequin and end device insertion point are to cable duct closest approach spacing; Zequin equipment is to cable duct closest approach to end device to cable duct length between cable duct closest approach; Cable length between zequin, end device.
Claims (2)
1. cable and a cable length statistical method, is characterized in that, comprises the following steps:
1) on AUTOCAD design software, set up independently cable duct figure layer and equipment drawing layer, the axis that cable duct figure layer is only used for drawing cable duct; Equipment drawing layer is only used for rendering apparatus;
2) apparatus for establishing model on equipment drawing layer is drawn cable duct axis on cable duct figure layer;
3) the equipment utilization AUTOCAD on equipment drawing layer sets up the function of piece, and different equipment is established as to different pieces, and independent name and insertion point;
4) from the cable inventory of existing EXCEL form and optical cable inventory, read the starting point of cable, optical cable and the equipment that terminal connects, and in equipment drawing layer, find the insertion point of this relevant device;
5) insertion point of zequin and end device is to the distance S1=△ X1+ △ Y1+ △ Z1 of the cable duct axis closest approach of cable duct figure layer, S2=△ X2+ △ Y2+ △ Z2, what wherein △ X, △ Y, △ Z were equipment insertion point co-ordinate to cable duct closest approach coordinate is poor; And zequin equipment is to cable duct closest approach and end device to cable duct closest approach minimum distance S3 in cable duct, three are equipment room cable, cable length S=S1+S2+S3 apart from sum;
6) will record cable length and be backfilled to cable inventory, the optical cable inventory of EXCEL form.
2. cable according to claim 1 and cable length statistical method, is characterized in that, sets up following functional module:
Module for reading and writing: the cable inventory and the optical cable inventory that automatically read and write EXCEL form;
Search module: query facility insertion point co-ordinate in AUTOCAD drawing automatically;
Computing module: zequin and end device insertion point are to cable duct closest approach coordinate; Zequin and end device insertion point are to cable duct closest approach spacing; Zequin equipment is to cable duct closest approach to end device to cable duct length between cable duct closest approach; Cable length between zequin, end device.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410086095.3A CN103886144B (en) | 2014-03-10 | 2014-03-10 | A kind of cable and cable length statistical method |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410086095.3A CN103886144B (en) | 2014-03-10 | 2014-03-10 | A kind of cable and cable length statistical method |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN103886144A true CN103886144A (en) | 2014-06-25 |
| CN103886144B CN103886144B (en) | 2017-09-26 |
Family
ID=50955035
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201410086095.3A Active CN103886144B (en) | 2014-03-10 | 2014-03-10 | A kind of cable and cable length statistical method |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN103886144B (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105046017A (en) * | 2015-08-13 | 2015-11-11 | 深圳市置华机电设备有限公司 | Rapid node placement method and system for electromechanical seismic design |
| CN108509633A (en) * | 2018-04-10 | 2018-09-07 | 国云科技股份有限公司 | A kind of object classification analysis system and method exporting Excel data based on CAD |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102236734A (en) * | 2011-06-30 | 2011-11-09 | 内蒙古电力勘测设计院 | Method for automatically forming patterns in design of power system of thermal power plant |
| CN102254056A (en) * | 2011-04-08 | 2011-11-23 | 中国核电工程有限公司 | Method for designing cable path of nuclear power station |
| CN103020360A (en) * | 2012-12-17 | 2013-04-03 | 江苏省电力设计院 | Integration design method of intelligent substation based on three-dimensional design platform and professional software |
-
2014
- 2014-03-10 CN CN201410086095.3A patent/CN103886144B/en active Active
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102254056A (en) * | 2011-04-08 | 2011-11-23 | 中国核电工程有限公司 | Method for designing cable path of nuclear power station |
| CN102236734A (en) * | 2011-06-30 | 2011-11-09 | 内蒙古电力勘测设计院 | Method for automatically forming patterns in design of power system of thermal power plant |
| CN103020360A (en) * | 2012-12-17 | 2013-04-03 | 江苏省电力设计院 | Integration design method of intelligent substation based on three-dimensional design platform and professional software |
Non-Patent Citations (3)
| Title |
|---|
| 刘召杰: "智能变电站二次电光缆自动敷设设计及全流程管理", 《安徽电气工程职业技术学院学报》 * |
| 张志广: "基于ObjectARX的电厂电缆敷设技术研究", 《中国优秀博硕士学位论文全文数据库(硕士)-工程科技Ⅱ辑》 * |
| 董宇 等: "三维电缆敷设软件的开发与应用", 《内蒙古电力技术》 * |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105046017A (en) * | 2015-08-13 | 2015-11-11 | 深圳市置华机电设备有限公司 | Rapid node placement method and system for electromechanical seismic design |
| CN105046017B (en) * | 2015-08-13 | 2018-06-19 | 深圳市置华机电设备有限公司 | A kind of quick points distributing method and system of electromechanics Aseismic Design |
| CN108509633A (en) * | 2018-04-10 | 2018-09-07 | 国云科技股份有限公司 | A kind of object classification analysis system and method exporting Excel data based on CAD |
Also Published As
| Publication number | Publication date |
|---|---|
| CN103886144B (en) | 2017-09-26 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| KR102110123B1 (en) | Automated frame of reference calibration for augmented reality | |
| CN103530810B (en) | The modeling method of electric system logic-based relation | |
| CN108921946A (en) | A kind of hidden pipeline of engineering based on BIM+AR measures and spatial position automatic matching method | |
| CN102622476B (en) | CAD (Computer Aided Design) drawing integration system for field of building amount of computation | |
| CN102857701B (en) | Method for tracking virtual camera in three-dimensional scene | |
| CN103793178B (en) | Vector graph editing method of touch screen of mobile device | |
| CN106202406A (en) | A kind of 3D visualization machine room assets information management method and system | |
| CN105674926A (en) | Point cloud splicing method and system | |
| CN109460595A (en) | A kind of power cable laying design method | |
| CN114227677A (en) | Industrial robot spraying operation planning method, device, equipment and storage medium | |
| CN106658139A (en) | Focus control method and device | |
| CN103886144A (en) | Cable and optical cable length statistical method | |
| CN110082713A (en) | Localization method, terminal device and storage medium | |
| CN103418864A (en) | Electric spark machining method and system | |
| CN102789203A (en) | Dispensing method and system | |
| CN108664738A (en) | Three dimensional image processing method and device | |
| CN112036442A (en) | Method and device for tracking and labeling objects in multi-frame 3D point cloud data and storage medium | |
| CN109669539B (en) | Electric wearable field operation man-machine interaction method, device and system | |
| CN106227002A (en) | A kind of method improving the efficiency adjusting splicing and multiplying power size | |
| CN114510679B (en) | Device position information obtaining method and device, terminal device and storage medium | |
| CN114398742A (en) | Optical cable three-dimensional laying data processing system and processing method | |
| CN110162880A (en) | Optical cable laying method, device, equipment and medium | |
| CN111258554B (en) | Pipeline production flow virtual reality development system | |
| CN105740141B (en) | A kind of automated detection method and its device | |
| CN108052253B (en) | Virtual reality display content manufacturing method |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| TA01 | Transfer of patent application right |
Effective date of registration: 20170712 Address after: 710054 Xi'an, Shaanxi, Xiang Xiang Road, No. 99 Applicant after: China Energy Engineering Group Shaanxi Electric Ppower Design Institute Co., Ltd. Address before: 710054 Xi'an, Shaanxi, Xiang Xiang Road, No. 99 Applicant before: Shaanxi Electric Power Design Institute |
|
| TA01 | Transfer of patent application right | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |