CN113268966A - Automatic generation method for cable inventory of automatic control system - Google Patents
Automatic generation method for cable inventory of automatic control system Download PDFInfo
- Publication number
- CN113268966A CN113268966A CN202110653170.XA CN202110653170A CN113268966A CN 113268966 A CN113268966 A CN 113268966A CN 202110653170 A CN202110653170 A CN 202110653170A CN 113268966 A CN113268966 A CN 113268966A
- Authority
- CN
- China
- Prior art keywords
- cable
- instrument
- auxiliary variable
- type
- excel
- 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
- 238000000034 method Methods 0.000 title claims abstract description 40
- 238000009434 installation Methods 0.000 claims abstract description 21
- 238000005259 measurement Methods 0.000 claims description 14
- 239000007788 liquid Substances 0.000 description 5
- 230000001105 regulatory effect Effects 0.000 description 5
- 238000006243 chemical reaction Methods 0.000 description 4
- 238000010276 construction Methods 0.000 description 4
- 238000001816 cooling Methods 0.000 description 2
- 238000010438 heat treatment Methods 0.000 description 2
- 230000009286 beneficial effect Effects 0.000 description 1
- 230000007547 defect Effects 0.000 description 1
- 238000007689 inspection Methods 0.000 description 1
- 238000009413 insulation Methods 0.000 description 1
- 229920000915 polyvinyl chloride Polymers 0.000 description 1
- 239000004800 polyvinyl chloride Substances 0.000 description 1
- 238000005057 refrigeration Methods 0.000 description 1
- 230000003252 repetitive effect Effects 0.000 description 1
- XLYOFNOQVPJJNP-UHFFFAOYSA-N water Substances O XLYOFNOQVPJJNP-UHFFFAOYSA-N 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
- G06F40/177—Editing, e.g. inserting or deleting of tables; using ruled lines
- G06F40/18—Editing, e.g. inserting or deleting of tables; using ruled lines of spreadsheets
-
- 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/06—Energy or water supply
Landscapes
- Engineering & Computer Science (AREA)
- Health & Medical Sciences (AREA)
- Business, Economics & Management (AREA)
- Theoretical Computer Science (AREA)
- General Health & Medical Sciences (AREA)
- General Physics & Mathematics (AREA)
- Physics & Mathematics (AREA)
- Economics (AREA)
- Water Supply & Treatment (AREA)
- Audiology, Speech & Language Pathology (AREA)
- Artificial Intelligence (AREA)
- General Engineering & Computer Science (AREA)
- Public Health (AREA)
- Computational Linguistics (AREA)
- Human Resources & Organizations (AREA)
- Marketing (AREA)
- Primary Health Care (AREA)
- Strategic Management (AREA)
- Tourism & Hospitality (AREA)
- General Business, Economics & Management (AREA)
- Electric Cable Installation (AREA)
Abstract
The invention provides an automatic generation method of a cable inventory of an automatic control system, which comprises the following steps: compiling an auxiliary table in an Excel form; compiling a cable inventory through compiling formulas and functions according to an auxiliary table, wherein the auxiliary table comprises the following contents: instrument serial number, mounted position, auxiliary variable, instrument type and instrument code number, the content of cable list includes: the measuring point description comprises a cable terminal point and an instrument type, wherein the instrument type corresponds to an instrument code number, the IO point type, the cable specification model and the cable pipe, the instrument position number corresponds to the cable number, the measuring point description comprises the instrument terminal point and the instrument type, the instrument number and the installation position are used as input quantities, and other contents with corresponding relations utilize auxiliary variables, the input quantities and the corresponding relations, and calculation is carried out by compiling formulas and functions in an Excel table. The accuracy and the design quality are improved, and the workload is reduced.
Description
Technical Field
The invention relates to the field of automatic control design, in particular to a design method for a cable inventory of an automatic control system, and particularly relates to an automatic generation method for the cable inventory of the automatic control system.
Background
The cable inventory is a common form in the field of automatic control and is used as a basis for construction paying-off and construction guidance. The cable is mainly composed of instrument position numbers, measurement point descriptions, IO point types, cable numbers, cable specification models, cable starting points, cable end points, lengths and cable pipes. The cable number is a mark for identifying the cable, the numbers of all the cables in a project cannot be repeated, and the cable number has certain meanings and rules, so that the cable number is convenient to design and construct. The common measuring points of the heating (cooling) project comprise pressure, temperature, flow, liquid level, a regulating valve, an electric valve, a water pump and the like, the common measuring points comprise DI, DO, AI, AO, RTD and the like, and the common control cable comprises a polyvinyl chloride insulation control cable: ZR-KVVP, ZR-KVV, etc.
At present, the method for designers to compile cable inventory is to manually copy, paste and edit in CAD or Excel, and input or modify the contents of instrument position number, measurement point description, IO point type, cable number, cable specification model, cable starting point, cable ending point, length, cable pipe and the like one by one. Some problems with the existing manual programming methods are found based on the authors' experience over many years in the design field. One is the workload problem. The workload of cable inventory compilation has a positive correlation with IO points. The more IO points, the greater the workload of compiling the cable inventory. For a small project, such as a heat exchange station, if the process and the automatic control system of the heat exchange station are designed conventionally, the total number of IO points is mostly within 100 points, and the workload of manually compiling a cable list for the project is not large. However, for large-scale projects such as heat supply plants and refrigeration stations, the total number of IO points can reach thousands or even thousands of points, cable inventory can reach thousands of lines, and the workload of manually compiling the cable inventory for such projects is huge. And the second is the repeatability problem of cable inventory. Because the small project and the large project measuring point are similar in types, most contents in the cable inventory are similar and repetitive. Thirdly, the accuracy problem of cable inventory. Although the cable inventory contents of the larger project and the small project are similar, due to the large workload of manual programming, various errors such as wrong cable numbers, wrong cable specification and model selection, wrong cable pipes and the like often occur in the cable inventory due to subjective reasons of designers. These errors are errors that designers often make, and are difficult to avoid, although they may be discovered during inspection of drawings or construction, or even if not discovered, have little impact on construction line deployment. However, the drawing accuracy represents the quality of drawing, and in order to avoid errors caused by subjective reasons of designers, improve the design quality, reduce the workload of repeated work of the designers and improve the working efficiency of the designers, an automatic cable inventory compiling method is urgently needed to replace the existing manual cable inventory compiling method.
Disclosure of Invention
The invention aims to research an automatic cable inventory compiling method according to the defects of the prior art, provides an automatic generation method of an automatic control system cable inventory, can automatically calculate and has high accuracy, and by adopting the method, the accuracy of the cable inventory can be greatly improved while the repeated work of designers is reduced, so that the method has better application prospect and application value.
The purpose of the invention is realized by the following ways:
an automatic generation method for a cable inventory of an automatic control system comprises the following steps:
and 2, compiling the cable inventory according to the auxiliary table by compiling formulas and functions.
Preferably, the auxiliary table content includes: instrument number, mounting location, auxiliary variable, instrument type, and instrument code.
Preferably, the meter numbers are consecutive or non-consecutive, and an appropriate numbering rule of the meter numbers is selected according to the characteristics of the project.
Preferably, the contents of the cable inventory include: instrument position number, measurement point description, IO point type, cable number, cable specification model, cable starting point, cable terminal point, cable length and cable pipe.
Preferably, the meter type corresponds to the meter code, the IO point type, the cable specification type, and the cable tube, the meter position number corresponds to the cable number, the measurement point description is composed of the cable end point and the meter type, the meter number and the installation position are used as input quantities, and other contents having a correspondence are calculated by writing a formula and a function in an Excel table by using the auxiliary variable, the input quantity, and the correspondence.
Preferably, the step 1 comprises:
and step 15, inputting the installation position.
Preferably, the step 2 comprises:
26, obtaining the cable terminal through an Excel formula according to the corresponding relation between the cable terminal and the installation position and the instrument type;
step 27, estimating the length of the cable length according to the process plan, the cable route and the position of the cable starting point;
and step 28, judging the specification and model of the cable through an IF function of Excel according to the corresponding relation between the cable pipe and the specification and model of the cable, and obtaining the cable pipe.
Preferably, the step 22 may further include:
and step 22', judging the value of the auxiliary variable through an IF function of Excel according to the corresponding relation between the measuring point description and the auxiliary variable, thereby obtaining the measuring point description.
Preferably, the starting point of the cable is a control cabinet or an instrument power distribution cabinet.
Preferably, the control cabinet is a PLC cabinet or a DCS cabinet.
The invention has the beneficial effects that:
according to the method and the steps, various formulas and functions of the auxiliary form and the cable inventory are compiled in the Excel form, and when the method and the device are used, the instrument number, the installation position and the cable length are input, so that a complete cable inventory can be automatically generated, the compiling workload of the cable inventory is greatly reduced, the accuracy is improved, the existing method for manually compiling the cable inventory is replaced, the error caused by the subjective reason of a designer can be avoided, the design quality is improved, the workload of repeated work of the designer is reduced, and the working efficiency of the designer is improved.
The above and other objects, advantages and features of the present invention will become more apparent to those skilled in the art from the following detailed description of specific embodiments thereof, taken in conjunction with the accompanying drawings.
Brief description of the drawings
FIG. 1 is a screenshot of an auxiliary form and cable inventory according to an embodiment of the invention.
Detailed Description
The invention discloses an automatic generation method of a cable inventory of an automatic control system, which comprises the following steps:
and 2, compiling a cable inventory according to the auxiliary table by compiling a formula and a function.
Wherein the auxiliary table content comprises: instrument number, mounting location, auxiliary variable, instrument type, and instrument code.
Wherein, the meter number is continuous or discontinuous, and the proper numbering rule of the meter number is selected according to the characteristics of the project.
Wherein, the content of cable list includes: instrument position number, measurement point description, IO point type, cable number, cable specification model, cable starting point, cable terminal point, cable length and cable pipe.
The instrument type corresponds to an instrument code, an IO point type, a cable specification model and a cable pipe, the instrument position number corresponds to a cable number, and the measurement point description comprises a cable terminal point and the instrument type. The instrument types of the heating and cooling project mainly comprise pressure, temperature, flow, liquid level, regulating valves, electric valves, pumps and the like. The instrument number and the installation position are used as input quantities, and other contents with corresponding relations are calculated by compiling formulas and functions in an Excel table by using auxiliary variables, the input quantities or the corresponding relations.
Wherein, step 1 includes:
Wherein, step 2 includes:
24, obtaining a cable number through an Excel formula according to the corresponding relation between the cable number and the instrument number; the cable number is a mark for identifying the cable, and the numbers of all the cables in one project cannot be repeated.
step 26, obtaining a cable terminal point through an Excel formula according to the corresponding relation between the cable terminal point and the installation position and the instrument type;
step 27, estimating the length of the cable length according to the process plan, the cable route and the position of the cable starting point;
and 28, judging the specification and model of the cable according to the corresponding relation between the cable pipe and the specification and model of the cable through an IF function of Excel, and obtaining the cable pipe.
Wherein, step 22 can also be replaced by:
and step 22', judging the value of the auxiliary variable through the IF function of Excel according to the corresponding relation between the measurement point description and the auxiliary variable, thereby obtaining the measurement point description.
The cable starting point is usually a control cabinet or an instrument power distribution cabinet, and in this embodiment, the control cabinet is a PLC cabinet or a DCS cabinet.
Referring to fig. 1, a screenshot of an auxiliary form and a cable inventory generated in a specific implementation process of this embodiment is shown, where the process includes:
1) and compiling an auxiliary table. The supplementary table content includes: instrument number, installation position, auxiliary variable, instrument type, instrument code. The method comprises the following steps:
a. and (3) assigning auxiliary variables to each type of instrument according to IO points of the instruments: pressure: 1, temperature: 2, flow rate: 3. 30, liquid level: 5, adjusting a valve: 6. 60, electrically operated valve: 21. 211, 212, 213, 214, 215, 216, pump frequency conversion: 22. 221, 222, 223, 224, 225, 226, 227, 228;
b. an instrument type IF (auxiliary variable 1, "pressure", IF (auxiliary variable 2, "temperature", IF (auxiliary variable 3, "flow", IF (auxiliary variable 5, "liquid level", IF (auxiliary variable 6, "regulating valve", IF (auxiliary variable 21, "electric valve", IF (auxiliary variable 22, "pump frequency"))))));
c. the instrument number is 5-IF (auxiliary variable is 1, "PT", IF (auxiliary variable is 2, "TE", IF auxiliary variable is 3, "FT", IF (auxiliary variable is 5, "LT", IF (auxiliary variable is 6, "TV", IF (auxiliary variable is 21, "FZV", IF (auxiliary variable is 211, "MST", IF (auxiliary variable is 212, "MSS", IF (auxiliary variable is 213, "ZA", IF (auxiliary variable is 214, "ZB", IF (auxiliary variable is 215, "ZC", IF (auxiliary variable is 216, "216", IF (auxiliary variable is 221, "MST", IF (auxiliary variable is 222, "MSS", IF (auxiliary variable is 223, "ZA", IF (auxiliary variable is 224, "ZB", IF (auxiliary variable is 225, "ZC", IF) (auxiliary variable is 228, "SSP", IF (auxiliary variable is 228, "ST 227", (auxiliary variable is 227, "ET"))))))))));
d. inputting a meter number;
e. the mounting position is input.
2) And compiling a cable list. The cable inventory content comprises: the cable comprises an instrument position number, a measurement point description, an IO point type, a cable number, a cable specification model, a cable starting point, a cable terminal point, a cable length and a cable pipe;
a. the instrument bit number is the instrument code number & "-" & instrument number;
b. for temperature, pressure, flow, level, regulating valves, the point description is installation position & meter type. For the electric valve, the measurement point specification is IF (auxiliary variable 21, installation position & instrument type, IF (auxiliary variable 211, "valve opening control", IF (auxiliary variable 212, "valve closing control", IF (auxiliary variable 213, "valve opening limit", IF (auxiliary variable 214, "valve closing limit", IF (auxiliary variable 215, "failure", IF (auxiliary variable 216, "remote/local")))))))))). For pump frequency conversion, the measurement point specification is IF (auxiliary variable 22, installation location & meter type, IF (auxiliary variable 221, "start", IF (auxiliary variable 222, "stop", IF (auxiliary variable 223, "run", IF (auxiliary variable 224, "fault", IF (auxiliary variable 225, "remote/local", IF (auxiliary variable 226, "frequency conversion given", IF (auxiliary variable 227, "frequency conversion feedback", IF (auxiliary variable 228, "motor current"))))))))))));
c. an IO point type IF (OR (auxiliary variable equal to 1, auxiliary variable equal to 5, auxiliary variable equal to 227, auxiliary variable equal to 228), "AI", IF (auxiliary variable equal to 226, "AO", IF (auxiliary variable equal to 60, "AI/AO", IF (auxiliary variable equal to 2, "RTD", IF (OR (auxiliary variable equal to 3, auxiliary variable equal to 6), "power", IF (auxiliary variable equal to 30, "RS 485"), IF (auxiliary variable equal to 21, "power", IF (OR (auxiliary variable equal to 211, auxiliary variable equal to 212, auxiliary variable equal to 221, auxiliary variable equal to 222), "DO", IF (OR (auxiliary variable equal to 213, auxiliary variable equal to 214, auxiliary variable equal to 215, auxiliary variable equal to 216, auxiliary variable equal to 223, auxiliary variable equal to 224, auxiliary variable equal to 225, DI));
d. the cable number is instrument number & C, instrument number & P, instrument number & a, instrument number & B, and the like;
e. the cable specifications are, IF (OR (auxiliary variable is 1, auxiliary variable is 30, auxiliary variable is 5), "ZR-KVVP3 × 1.0", IF (auxiliary variable is 2, "ZR-KVVP 4x1.0", IF (auxiliary variable is 60, "ZR-KVVP 5x1.0", IF (AND (auxiliary variable is 226, auxiliary variable is 227, auxiliary variable is 228), "ZR-KVVP 7x1.0", IF (OR (auxiliary variable is 3, auxiliary variable is 6), "ZR-KVVP3x 2.5", IF (auxiliary variable is 21, "ZR-kvp 5x2.5", AND (auxiliary variable is 211, auxiliary variable is 212), "ZR-KVV 5x1.0", IF (auxiliary variable is 221, auxiliary variable is 1, auxiliary variable is 223 x 1.224 ", auxiliary variable is 223 x1.0", IF (AND (assist variable 213, assist variable 214, assist variable 215, assist variable 216), "ZR-KVV 10x 1.0"))))))))));
f. a cable starting point is a control cabinet such as a PLC cabinet and a DCS cabinet or an instrument power distribution cabinet;
g. and the cable terminal point is the instrument installation position, the instrument type and the power distribution cabinet.
h. Estimating the length of the cable according to a process plan, a cable route and the position of a control cabinet or an instrument power distribution cabinet;
i. cable tube IF (cable specification model "ZR-KVVP 10x1.0", SC25, SC 20)).
For example, for a pressure transmitter, the gauge number is 1101, the installation location is the boiler feed pipe, its auxiliary variable is 1, the gauge type is pressure, and the gauge number is PT. Then the contents of the cable inventory are respectively as follows: the instrument position number: PT-1101, description of measurement points: boiler feed pipe pressure, IO point type: AI, Cable number: 1101C, cable specification model: ZR-KVVP3x1.0, cable origin: control cabinet, cable terminal: boiler feed pipe, cable length: according to the process plan, the cable route and the position estimation of the control cabinet, the cable pipe is as follows: SC 20. Except that the instrument number, the installation position and the cable length are manually input and modified by designers, other contents can be automatically generated.
The automatic generation method of the cable inventory of the automatic control system is described above by taking common pressure, temperature, flow, liquid level, regulating valve, electric valve, pump and the like as examples, wherein the specification and model of the cable can be selected according to different project requirements. For other instruments, such as flow switches, electromagnetic valves, fans, boilers, coolers, etc., which are not mentioned in the present invention, the cable inventory making method can refer to the method.
The technical solutions provided by the embodiments of the present invention are described in detail above, and the principles and embodiments of the present invention are explained herein by using specific examples, and the descriptions of the embodiments are only used to help understanding the principles of the embodiments of the present invention; meanwhile, a person skilled in the art may change the embodiments and the application scope according to the embodiments of the present invention, and in summary, the content of the present description should not be construed as limiting the present invention.
Claims (10)
1. An automatic generation method of a cable inventory of an automatic control system is characterized by comprising the following steps:
step 1, compiling an auxiliary table in an Excel form;
and 2, compiling the cable inventory according to the auxiliary table by compiling formulas and functions.
2. The method of claim 1, wherein the supplementary table content comprises: instrument number, mounting location, auxiliary variable, instrument type, and instrument code.
3. The method as claimed in claim 2, wherein the meter numbers are continuous or discontinuous, and the proper numbering rule of the meter numbers is selected according to the characteristics of the project.
4. The method of claim 3, wherein the cable inventory comprises: instrument position number, measurement point description, IO point type, cable number, cable specification model, cable starting point, cable terminal point, cable length and cable pipe.
5. The method as claimed in claim 4, wherein the meter type corresponds to the meter code, the IO point type, the cable specification and the cable tube, the meter position number corresponds to the cable number, the measurement point description comprises the cable end point and the meter type, the meter number and the installation position are used as input quantities, and other corresponding contents are calculated by writing a formula and a function in an Excel table by using the auxiliary variable, the input quantity and the corresponding relation.
6. The method for automatically generating a cable inventory of an automatic control system according to claim 5, wherein the step 1 comprises:
step 11, endowing each type of instrument with the auxiliary variable according to the IO point;
step 12, judging the value of the auxiliary variable through an IF function of Excel according to the corresponding relation between the instrument type and the auxiliary variable, thereby obtaining the instrument type;
step 13, judging the value of the auxiliary variable through an IF function of Excel according to the corresponding relation between the instrument code and the auxiliary variable so as to obtain the instrument code;
step 14, inputting the number of the meter;
and step 15, inputting the installation position.
7. The method of claim 6, wherein the step 2 comprises:
step 21, obtaining the instrument position number through an Excel formula according to the corresponding relation among the instrument position number, the instrument code number and the instrument number;
step 22, obtaining the measuring point description through an Excel formula according to the corresponding relation between the measuring point description and the installation position and the instrument type;
step 23, judging the value of the auxiliary variable through an IF function of Excel according to the corresponding relation between the IO point type and the auxiliary variable, thereby obtaining the IO point type;
step 24, obtaining the cable number through an Excel formula according to the corresponding relation between the cable number and the instrument number; the cable number is a mark for identifying the cable, and the numbers of all the cables in one project cannot be repeated;
step 25, judging the value of the auxiliary variable through an IF function of Excel according to the corresponding relation between the cable specification model and the auxiliary variable so as to obtain the cable specification model;
26, obtaining the cable terminal through an Excel formula according to the corresponding relation between the cable terminal and the installation position and the instrument type;
step 27, estimating the length of the cable length according to the process plan, the cable route and the position of the cable starting point;
and step 28, judging the specification and model of the cable through an IF function of Excel according to the corresponding relation between the cable pipe and the specification and model of the cable, and obtaining the cable pipe.
8. The method according to claim 7, wherein the step 22 is further performed by:
and step 22', judging the value of the auxiliary variable through an IF function of Excel according to the corresponding relation between the measuring point description and the auxiliary variable, thereby obtaining the measuring point description.
9. The method according to claim 7, wherein the cable is selected from a control cabinet and an instrument distribution cabinet.
10. The method of claim 9, wherein the control cabinet is a PLC cabinet or a DCS cabinet.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110653170.XA CN113268966B (en) | 2021-06-11 | 2021-06-11 | Automatic generation method for cable inventory of automatic control system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110653170.XA CN113268966B (en) | 2021-06-11 | 2021-06-11 | Automatic generation method for cable inventory of automatic control system |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN113268966A true CN113268966A (en) | 2021-08-17 |
| CN113268966B CN113268966B (en) | 2023-01-10 |
Family
ID=77234826
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202110653170.XA Active CN113268966B (en) | 2021-06-11 | 2021-06-11 | Automatic generation method for cable inventory of automatic control system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN113268966B (en) |
Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20080168341A1 (en) * | 2007-01-10 | 2008-07-10 | Raymond Payette | Digital spreadsheet formula automation |
| CN102567565A (en) * | 2011-11-10 | 2012-07-11 | 重庆电力设计院 | Cable parameter processing method and system utilizing same |
| CN104376171A (en) * | 2014-11-17 | 2015-02-25 | 陕西合信诚铭软件科技有限公司 | Automatic design method and system for terminal block drawing and cable detailed list |
| CN108153946A (en) * | 2017-12-12 | 2018-06-12 | 中国电建集团福建省电力勘测设计院有限公司 | Prefabricated cabin cable inventory based on standard wiring is derived automatically from method |
| CN111797625A (en) * | 2020-07-03 | 2020-10-20 | 国核电力规划设计研究院有限公司 | Transformer substation engineering method based on import Excel and three-dimensional model complementation |
| CN112686013A (en) * | 2020-12-23 | 2021-04-20 | 国家电网有限公司 | Cable number head compiling system and method |
| CN112686014A (en) * | 2020-12-23 | 2021-04-20 | 国家电网有限公司 | Cable number plate compiling system and method |
-
2021
- 2021-06-11 CN CN202110653170.XA patent/CN113268966B/en active Active
Patent Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20080168341A1 (en) * | 2007-01-10 | 2008-07-10 | Raymond Payette | Digital spreadsheet formula automation |
| CN102567565A (en) * | 2011-11-10 | 2012-07-11 | 重庆电力设计院 | Cable parameter processing method and system utilizing same |
| CN104376171A (en) * | 2014-11-17 | 2015-02-25 | 陕西合信诚铭软件科技有限公司 | Automatic design method and system for terminal block drawing and cable detailed list |
| CN108153946A (en) * | 2017-12-12 | 2018-06-12 | 中国电建集团福建省电力勘测设计院有限公司 | Prefabricated cabin cable inventory based on standard wiring is derived automatically from method |
| CN111797625A (en) * | 2020-07-03 | 2020-10-20 | 国核电力规划设计研究院有限公司 | Transformer substation engineering method based on import Excel and three-dimensional model complementation |
| CN112686013A (en) * | 2020-12-23 | 2021-04-20 | 国家电网有限公司 | Cable number head compiling system and method |
| CN112686014A (en) * | 2020-12-23 | 2021-04-20 | 国家电网有限公司 | Cable number plate compiling system and method |
Non-Patent Citations (1)
| Title |
|---|
| 张朝辉: "Visual Basic语言的自定义函数在电力系统设计中的应用", 《中国海上油气(工程)》 * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN113268966B (en) | 2023-01-10 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN107420743B (en) | Intelligent urban gas PE pipe network measurement and control system and measurement and control method | |
| Stefanizzi et al. | Experimental investigation and performance prediction modeling of a single stage centrifugal pump operating as turbine | |
| GB2554504A (en) | Plant builder system with integrated simulation and control system configuration | |
| CN108964041B (en) | Control method for maximum load supply capacity of electricity-gas interconnection comprehensive energy system | |
| CN111475913A (en) | Operation optimization method and system for steam power system | |
| CN111799777A (en) | Comprehensive energy planning method considering coupling of natural gas and electric power | |
| CN102545204A (en) | Automatic generation method and device of power grid fault set | |
| CN113268966B (en) | Automatic generation method for cable inventory of automatic control system | |
| CN109104095A (en) | Three Port Translation devices half switch the predicted current phase-shifting control method of periodic sampling | |
| CN115454395A (en) | Method and device for constructing computing interface of industrial digital twin system unit equipment | |
| CN113239645A (en) | System and method for dynamically tracking and calculating natural gas components in natural gas pipe network in real time | |
| CN116430821B (en) | Data processing method and device for industrial production process model | |
| KR101089170B1 (en) | Advanced process control method for district heat network | |
| CN113544607A (en) | Method for automatically explaining pipeline diagram | |
| Vodovozov et al. | PLC-based pressure control in multi-pump applications | |
| Singh et al. | Implementation of mass customization for MEP layout design to reduce manufacturing cost in one-off projects | |
| Santillán Martínez | Simulation-based Digital Twins of Industrial Process Plants: A Semi-Automatic Implementation Approach | |
| CN114519219A (en) | MFMEA information visualization method and system | |
| CN110704935B (en) | Automatic debugging and outputting method of SPS software | |
| CN113704936A (en) | Cable path multi-objective optimization method considering channel capacity and turning radius constraints | |
| Nakaya et al. | On-line simulator for plant operation | |
| CN112818552B (en) | Economical and reliable coordinated electric-gas system equipment site selection and volume determination method | |
| CN114154104A (en) | Method and device for judging lowest pressure point of pipe network | |
| CN115017663B (en) | Topological optimization method of current collection system considering actual current-carrying capacity of submarine cable | |
| CN116976153B (en) | Marine wind farm booster station site selection method based on integrated model |
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 | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |