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

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...

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

Images