Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

Method for performing power engineering coordinate combined survey computation in Excel by using VBA (Visual Basic for Applications) module

A power engineering and excel technology, applied in the field of power engineering coordinate joint measurement and calculation, can solve problems such as error-prone, cumbersome process, low efficiency, etc., and achieve the effect of reducing the intensity of internal work, improving calculation efficiency, and convenient two-two joint measurement.

Inactive Publication Date: 2012-07-04
CEEC JIANGSU ELECTRIC POWER DESIGN INST
View PDF0 Cites 5 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] my country's current "Technical Regulations for Engineering Measurement of Thermal Power Plants" (DL / T 5001-2004) regulates calculations in this area as a standard in the electric power industry. Coordinate joint measurement parameters, joint measurement of building coordinates to national coordinates, joint measurement of national coordinates to building coordinates, etc.), these calculation processes involve 4 parameters and multiple trigonometric functions, and the process is cumbersome when using manual and calculator calculations , the efficiency is low, and error-prone due to the complexity of the calibration process

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Method for performing power engineering coordinate combined survey computation in Excel by using VBA (Visual Basic for Applications) module
  • Method for performing power engineering coordinate combined survey computation in Excel by using VBA (Visual Basic for Applications) module
  • Method for performing power engineering coordinate combined survey computation in Excel by using VBA (Visual Basic for Applications) module

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0037] In order to further explain the technical means and effects that the present invention adopts to achieve the intended purpose of the invention, below in conjunction with the accompanying drawings and preferred embodiments, the specific implementation, structure, features and effects of the present invention will be described in detail as follows: back.

[0038] like figure 1 As shown, a method of using the VBA module to perform joint measurement and calculation of power engineering coordinates in Excel includes the following steps:

[0039] (1), develop VBA module

[0040] In the Visual Basic editor of Excel, establish a "commonly used function module for joint measurement of coordinates", and compile several sub-functions commonly used for joint measurement of coordinates in the module, including the azimuth angle sub-function "Alfa()", the angle format conversion function "DMS ()" and "DEG()";

[0041] (2) Design the software interface and each functional area in E...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

PUM

No PUM Login to View More

Abstract

The invention relates to a method for performing power engineering coordinate combined survey computation in Excel by using a VBA (Visual Basic for Applications) module and belongs to the field of power engineering measurement in geomatics. The method comprises the following steps of: 1, developing a VBA module; 2, designing a software interface and all functional regions in Excel and setting an operating control; 3, triggering the control, calling the VBA module and resolving coordinate combined survey parameters; 4, calling the VBA module according to the coordinate combined survey parameters to perform combined survey of building coordinates to country coordinates; and 5, calling the VBA module according to the coordinate combined survey parameters to perform combined survey of the country coordinates to the building coordinates. According to the method, since the Excel interface is used to perform software-based operation, the simple and visual effects are achieved and the effect of what you see is water you get is also achieved; moreover, pairwise combined survey of various coordinate systems can be implemented conveniently and quickly and power engineering coordinate combined survey computation can be implemented automatically; therefore the efficiency of coordinate combined survey computation is improved greatly and internal operation intensity of survey personnel is lowered.

Description

technical field [0001] The invention relates to a method for performing joint measurement and calculation of electric power engineering coordinates in Excel by using a VBA module, belonging to the field of electric power engineering measurement in the subject of surveying and mapping. Background technique [0002] In the current field of surveying and mapping, there are a wide variety of coordinate systems, such as national coordinate systems, city coordinate systems, building coordinate systems, etc. In the construction process of electric power engineering (such as thermal power plants, substations, high-voltage lines, etc.), it is often necessary to jointly measure one coordinate system to another coordinate system, and sometimes even two-two joint measurement of multiple coordinate systems, in order to Meet the needs of power planning, design, construction and other aspects. [0003] my country's current "Technical Regulations for Engineering Measurement of Thermal Powe...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

Application Information

Patent Timeline
no application Login to View More
IPC IPC(8): G06F17/50
Inventor 仲锋徐君民朱健
Owner CEEC JIANGSU ELECTRIC POWER DESIGN INST
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic, Popular Technical Reports.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com