CN105760955A - Wind turbine coordinate rapid extraction method based on AUTOCAD - Google Patents

Wind turbine coordinate rapid extraction method based on AUTOCAD Download PDF

Info

Publication number
CN105760955A
CN105760955A CN201610089501.0A CN201610089501A CN105760955A CN 105760955 A CN105760955 A CN 105760955A CN 201610089501 A CN201610089501 A CN 201610089501A CN 105760955 A CN105760955 A CN 105760955A
Authority
CN
China
Prior art keywords
blower fan
autocad
wind turbine
wind
method based
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
CN201610089501.0A
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.)
China Energy Engineering Group Jiangsu Power Design Institute Co Ltd
Original Assignee
China Energy Engineering Group Jiangsu Power Design Institute Co Ltd
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 China Energy Engineering Group Jiangsu Power Design Institute Co Ltd filed Critical China Energy Engineering Group Jiangsu Power Design Institute Co Ltd
Priority to CN201610089501.0A priority Critical patent/CN105760955A/en
Publication of CN105760955A publication Critical patent/CN105760955A/en
Pending legal-status Critical Current

Links

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06QINFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
    • G06Q10/00Administration; Management
    • G06Q10/04Forecasting or optimisation specially adapted for administrative or management purposes, e.g. linear programming or "cutting stock problem"
    • G06Q10/043Optimisation of two dimensional placement, e.g. cutting of clothes or wood
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F30/00Computer-aided design [CAD]
    • G06F30/10Geometric CAD
    • G06F30/18Network design, e.g. design based on topological or interconnect aspects of utility systems, piping, heating ventilation air conditioning [HVAC] or cabling
    • YGENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y02TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
    • Y02ATECHNOLOGIES FOR ADAPTATION TO CLIMATE CHANGE
    • Y02A90/00Technologies having an indirect contribution to adaptation to climate change
    • Y02A90/10Information and communication technologies [ICT] supporting adaptation to climate change, e.g. for weather forecasting or climate simulation

Landscapes

  • Engineering & Computer Science (AREA)
  • Business, Economics & Management (AREA)
  • Physics & Mathematics (AREA)
  • Human Resources & Organizations (AREA)
  • Theoretical Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Strategic Management (AREA)
  • Economics (AREA)
  • Geometry (AREA)
  • Development Economics (AREA)
  • Marketing (AREA)
  • Tourism & Hospitality (AREA)
  • Game Theory and Decision Science (AREA)
  • General Business, Economics & Management (AREA)
  • Operations Research (AREA)
  • Entrepreneurship & Innovation (AREA)
  • Computer Networks & Wireless Communication (AREA)
  • Computational Mathematics (AREA)
  • Quality & Reliability (AREA)
  • Mathematical Analysis (AREA)
  • Mathematical Optimization (AREA)
  • Pure & Applied Mathematics (AREA)
  • Computer Hardware Design (AREA)
  • Evolutionary Computation (AREA)
  • General Engineering & Computer Science (AREA)
  • Wind Motors (AREA)

Abstract

The invention discloses a wind turbine coordinate rapid extraction method based on AUTOCAD. The method is characterized by comprising the following steps that step 1) wind turbine set primitives are set as blocks, and wind turbines are arranged according to the base points of the wind turbine set blocks with combination of topographic map information; step 2) the wind turbine coordinates are extracted through framing; step 3) the wind turbine coordinates are imported into Excel; step 4) separators are arranged for column separation; and step 5) the wind turbine coordinates are automatically read by using the ActiveX control of compiled codes. The achieved beneficial effects of the method are that large quantities of wind turbine coordinates are generated in a short period of time so that smooth proceeding of subsequent wind resource analysis can be guaranteed, and working efficiency can be greatly enhanced; besides, range of application is wide, the method is especially suitable for projects having high planning capacity of wind power plants or having multiple wind power plants and has obvious advantages; meanwhile, the method is also suitable for common independent wind power plants and is further adaptive to parallel analytical calculation of multiple wind power plants.

Description

A kind of rapid extraction blower fan coordinate method based on AUTOCAD
Technical field
The present invention relates to a kind of rapid extraction blower fan coordinate method based on AUTOCAD, belong to Data Integration field.
Background technology
Extract blower fan coordinate and be by the important step that wind energy turbine set generated energy calculates, along with wind energy turbine set installed capacity is increasing, the Wind turbines number of units of single wind energy turbine set gets more and more, in addition wind-resources need to consider the built wind energy turbine set impact on planning wind energy turbine set around when analyzing, and around the blower fan coordinate of built wind energy turbine set also needs typing wind-resources to analyze software.Therefore, for the wind energy turbine set of a conventional 100MW, it is considered to the wind energy turbine set project of a built 50~100MW around, only Wind turbines coordinate just needs typing 75~100, if around built wind energy turbine set is more, then typing blower fan coordinate is more.
Tradition is extracted blower fan coordinate and is adopted and clicks Wind turbines in AUTOCAD and obtain coordinate, then replicates and pastes each coordinate points to text.So not only efficiency is low, and as easy as rolling off a log confusion is made mistakes, and when especially blower fan number of units is many, the quantities of staff is huge, and the so simple work repeated too increases time cost, and 75~100 blower fan coordinates need just can complete the soonest for 20~30 minutes.In actual engineering design, time factor is also worthy of consideration, it is ensured that project progress and result are accurately of equal importance for smoothly completing engineering.
How fast and effeciently batch extracting blower fan coordinate is particularly significant, and when calculating for multiple wind energy turbine set parallel parsings, problem is more prominent.
Summary of the invention
For solving the deficiencies in the prior art, it is an object of the invention to provide a kind of rapid extraction blower fan coordinate method based on AUTOCAD, make full use of the advantage of computer software, make the short time can generate large batch of blower fan coordinate, ensure being smoothed out of follow-up wind-resources analysis, being greatly improved work efficiency, 75~100 blower fan coordinates only need to complete for 2~3 minutes.
In order to realize above-mentioned target, the present invention adopts the following technical scheme that:
A kind of rapid extraction blower fan coordinate method based on AUTOCAD, is characterized in that, comprise the steps:
Step 1): Wind turbines pel is set to block, arranges blower fan according to the basic point of wind turbine chunk and information of the ground map;
Step 2) frame choosing extraction blower fan coordinate;
Step 3) blower fan coordinate is imported in Excel;
Step 4) list separator is set carries out point row;
Step 5) use the ActiveX control of compiled code automatically to read blower fan coordinate.
Aforesaid a kind of rapid extraction blower fan coordinate method based on AUTOCAD, is characterized in that, described step 2) middle " list " functional block choosing extraction blower fan coordinate used in AUTOCAD.
Aforesaid a kind of rapid extraction blower fan coordinate method based on AUTOCAD, is characterized in that, described step 2) in every time frame select 30~40 blower fan coordinates of extraction.
Aforesaid a kind of rapid extraction blower fan coordinate method based on AUTOCAD, is characterized in that, described step 4) in list separator increases "=" separator.
Aforesaid a kind of rapid extraction blower fan coordinate method based on AUTOCAD, is characterized in that, described step 5) middle use VB language compiler, directly enumerate blower fan coordinate by the ActiveX control after clicking compiled code.
Aforesaid a kind of rapid extraction blower fan coordinate method based on AUTOCAD, is characterized in that, described step 5) in ActiveX control by from compiler realize.
The beneficial effect that the present invention reaches: generate large batch of blower fan coordinate in the short time, ensure being smoothed out of follow-up wind-resources analysis, it is greatly improved work efficiency, and it is applied widely, wind energy turbine set planned capacity is relatively big or periphery has the project particularly suitable of multiple wind energy turbine set, with the obvious advantage, it is simultaneously suitable for general independent wind power field, also accommodates multiple wind energy turbine set parallel parsing and calculate.
Accompanying drawing explanation
Fig. 1 is the flow chart of the present invention.
Detailed description of the invention
Below in conjunction with accompanying drawing, the invention will be further described.Following example are only for clearly illustrating technical scheme, and can not limit the scope of the invention with this.
Tradition is extracted blower fan and is sat calibration method inefficiency, and as easy as rolling off a log confusion is made mistakes.The method that the present invention proposes is as it is shown in figure 1, comprise the steps:
Step 1, in AUTOCAD according to information placement Wind turbines such as topography, Wind turbines pel is set to block, arranges blower fan according to the basic point of wind turbine chunk, close other figure layers after completing, only retain Wind turbines.
Step 2, " list " functional block choosing extraction blower fan coordinate used in AUTOCAD.
Step 3, AUTOCAD text window obtains all frames select the coordinate information of Wind turbines, replicate and paste MicrosoftExcel file.
Step 4, Excel arranges list separator coordinate information file is carried out point row.
Step 5, the ActiveX control of compiled code is used automatically to read blower fan coordinate, owing to the coordinate information after point row has certain rule, it is possible to realize automatically reading blower fan coordinate by writing VB code.
This rapid extraction blower fan coordinate method based on AUTOCAD both can Appropriate application computer resource, shorten the calculating time, can preventing again the mistake that artificial subjective factor causes, wind energy turbine set planned capacity is relatively big or periphery has the project of multiple wind energy turbine set and has remarkable result simultaneously.
In step 4, list separator is used to carry out point row, list separator to increase "=" separator.Excel arranges list separator coordinate information file is carried out point row, do not have in acquiescence list separator "=" separator, " other " Option Box need to be chosen, then input "=".The coordinate information content that AUTOCAD text window obtains is an entirety, list separator need to be arranged every piece of content is divided, facilitate down-stream to write, the concrete blower fan coordinate digital extracted with "=" be connected as a single entity, must individually increase "=" separator is divided comes.
In steps of 5, use VB language compiler, can directly enumerate blower fan coordinate by the ActiveX control after clicking compiled code.By inserting ActiveX control, the co-ordinate content unit after point row is carried out written in code, click ActiveX control button after completing and only information unit containing blower fan coordinate digital can be read and enumerate out.
This method can prevent the mistake that artificial subjective factor causes, making full use of the advantage of computer software, making extraction blower fan coordinate is no longer the uninteresting work repeated, but the short time can generate high-volume blower fan coordinate, ensure being smoothed out of follow-up wind-resources analysis, be greatly improved work efficiency.The inventive method is relatively big to wind energy turbine set planned capacity or periphery has the project particularly suitable of multiple wind energy turbine set, and advantage is obvious especially, is equally applicable to general independent wind power field, also accommodates multiple wind energy turbine set parallel parsing and calculates, is favorably improved work efficiency.
This method what propose on substantial amounts of wind energy turbine set engineering project basis, and theoretical foundation is abundant, focuses on engineers design's experience simultaneously, engineering practice of fitting, it is possible to the guidance method in seeking advice from as actual engineering design.
The above is only the preferred embodiment of the present invention; it should be pointed out that, for those skilled in the art, under the premise without departing from the technology of the present invention principle; can also making some improvement and deformation, these improve and deformation also should be regarded as protection scope of the present invention.

Claims (6)

1., based on a rapid extraction blower fan coordinate method of AUTOCAD, it is characterized in that, comprise the steps:
Step 1): Wind turbines pel is set to block, the basic point Combining with terrain figure information placement blower fan according to wind turbine chunk;
Step 2) frame choosing extraction blower fan coordinate;
Step 3) blower fan coordinate is imported in Excel;
Step 4) list separator is set carries out point row;
Step 5) use the ActiveX control of compiled code automatically to read blower fan coordinate.
2. a kind of rapid extraction blower fan coordinate method based on AUTOCAD according to claim 1, is characterized in that, described step 2) middle " list " functional block choosing extraction blower fan coordinate used in AUTOCAD.
3. a kind of rapid extraction blower fan coordinate method based on AUTOCAD according to claim 1, is characterized in that, described step 2) in every time frame select 30~40 blower fan coordinates of extraction.
4. a kind of rapid extraction blower fan coordinate method based on AUTOCAD according to claim 1, is characterized in that, described step 4) in list separator increases "=" separator.
5. a kind of rapid extraction blower fan coordinate method based on AUTOCAD according to claim 1, is characterized in that, described step 5) middle use VB language compiler, directly enumerate blower fan coordinate by the ActiveX control after clicking compiled code.
6. a kind of rapid extraction blower fan coordinate method based on AUTOCAD according to claim 5, is characterized in that, described step 5) in ActiveX control by from compiler realize.
CN201610089501.0A 2016-02-17 2016-02-17 Wind turbine coordinate rapid extraction method based on AUTOCAD Pending CN105760955A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201610089501.0A CN105760955A (en) 2016-02-17 2016-02-17 Wind turbine coordinate rapid extraction method based on AUTOCAD

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201610089501.0A CN105760955A (en) 2016-02-17 2016-02-17 Wind turbine coordinate rapid extraction method based on AUTOCAD

Publications (1)

Publication Number Publication Date
CN105760955A true CN105760955A (en) 2016-07-13

Family

ID=56330887

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201610089501.0A Pending CN105760955A (en) 2016-02-17 2016-02-17 Wind turbine coordinate rapid extraction method based on AUTOCAD

Country Status (1)

Country Link
CN (1) CN105760955A (en)

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN113627118A (en) * 2021-10-12 2021-11-09 广州中大中鸣科技有限公司 Method, device, equipment and storage medium for automatically extracting coordinates of lamp

Citations (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN101685471A (en) * 2008-09-26 2010-03-31 黑龙江工程学院 Highway route CAD aided design system
CN102830979A (en) * 2012-08-30 2012-12-19 江苏省交通科学研究院股份有限公司 CAD (computer-aided design) drawing information batch processing method based on ObjectArx
US20130246350A1 (en) * 2001-12-28 2013-09-19 Open Text S.A. System and method for the synchronization of a file in a cache

Patent Citations (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20130246350A1 (en) * 2001-12-28 2013-09-19 Open Text S.A. System and method for the synchronization of a file in a cache
CN101685471A (en) * 2008-09-26 2010-03-31 黑龙江工程学院 Highway route CAD aided design system
CN102830979A (en) * 2012-08-30 2012-12-19 江苏省交通科学研究院股份有限公司 CAD (computer-aided design) drawing information batch processing method based on ObjectArx

Cited By (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN113627118A (en) * 2021-10-12 2021-11-09 广州中大中鸣科技有限公司 Method, device, equipment and storage medium for automatically extracting coordinates of lamp
CN113627118B (en) * 2021-10-12 2022-02-22 广州中大中鸣科技有限公司 Method, device, equipment and storage medium for automatically extracting coordinates of lamp

Similar Documents

Publication Publication Date Title
CN102426590B (en) Quality evaluation method and device
CN105630459A (en) Method for converting PPT document to HTML page
CN105159822A (en) Software defect positioning method based on text part of speech and program call relation
CN110580263B (en) Method and system for generating wind resource data report
CN102750223A (en) Error positioning method based on object-oriented program slice spectrum
CN105159685A (en) Method for extracting detail content of computer aided design (CAD) drawing to Excel form
CN104462979A (en) Automatic dynamic detection method and device of application program
CN107977205A (en) Gui interface automatically creates method and system
CN109145359B (en) Steel structure material preparation method based on BIM system and CAD software
CN104516862A (en) Method and system for selecting and reading coded format of target document
CN112148774A (en) High-resolution spatial multi-region meteorological data processing system and method
CN104574461A (en) Graph modeling method and device
CN106802958A (en) Conversion method and system of the CAD data to GIS data
CN110175548A (en) Remote sensing images building extracting method based on attention mechanism and channel information
CN105760955A (en) Wind turbine coordinate rapid extraction method based on AUTOCAD
CN104504221A (en) Evaluation data processing method and system
CN105373864A (en) Rural power grid design method
CN107908731B (en) PSD-BPA-based Guangxi power grid area load data batch modification method
CN106802928A (en) Power network historical data management method and its system
CN105573972B (en) The generation method and device of report check formula
CN105302780A (en) Optimized SCD file editing method
CN113327097B (en) Analysis drawing method and device
KR101841385B1 (en) Apparatus and method for reconfiguring library by utilizing multiple distributions
CN102184174A (en) Method for recording mouse trace in network
CN104392490A (en) Power network resource grid meteorological influence scope analysis method based on GIS platform

Legal Events

Date Code Title Description
C06 Publication
PB01 Publication
C10 Entry into substantive examination
SE01 Entry into force of request for substantive examination
RJ01 Rejection of invention patent application after publication

Application publication date: 20160713

RJ01 Rejection of invention patent application after publication