scholarly journals Using the Bentley MicroStation environment to program calculations of predicted ground subsidence caused by underground mining exploitation

2019 ◽  
Vol 106 ◽  
pp. 01003
Author(s):  
Artur Krawczyk ◽  
Paweł Owsianka
Keyword(s):  
Underground Mining ◽  
Visual Basic ◽  
Ground Subsidence ◽  
Data Sets ◽  
Calculation Algorithm ◽  
Visual Basic For Applications ◽  
Calculation Methodology ◽  
Calculation Results ◽  
Executable File ◽  
Graphic Environment

The paper presents a new concept of creating a program for calculating ground subsidence caused by underground mining extraction, which is substantially different than previously used solutions. Instead of compiling the calculation algorithm to an executable file, the whole application algorithm has been written in the Bentley MicroStation graphic environment’s interpreted language. This graphic environment is used in mining for keeping mining maps and the format is used for storing finished and designed mining exploitation data sets. The paper describes S. Knothe’s theory of the influence of mining exploitation on the terrain surface in the context of the calculation methodology used for terrain subsidence computation. Based on the theory of influence, the structure of the created MVBA (MicroStation Visual Basic for Applications) algorithm for interpolating subsidence contours is described. The new application is called uDEFO. Calculation results from the program are compared with calculation results from software currently used in coal mines.

scholarly journals Slope ranking and geohazards correlation analysis for combined open-underground mining area

2018 ◽  
Author(s):  
Zhang Jin
Keyword(s):  
Correlation Analysis ◽  
Water Conservation ◽  
Laser Scanning ◽  
Underground Mining ◽  
Mining Area ◽  
Open Pit ◽  
Ground Subsidence ◽  
Data Sets ◽  
Mining Areas ◽  
Factor Data

Geohazards in mining areas are mainly ground subsidence, slope landslides and ground cracks, surface cover degradation and environmental ecological pattern destruction. The classification and rank of terrain slope and the feature area extraction of the slope are the important content for the correlation analysis with the geohazards. The slope classification and rank index system for soil and water conservation, land use and man-made ground disasters was analyzed. According to the characteristics of open pit and underground associated mining area, we comprehensively analyzed the spatial correlation between different ground disaster and terrain features and landform types, and propose a new slope ranking index, dividing slope zones and forming slope classification map. Especially slope area of 35-45 degrees and more than 45 degrees was extracted, and the relationship between regional geohazards and slope zone was analyzed. The application of terrestrial laser scanning technology to establish open-pit high precision digital elevation model, extraction of slope, slope type, gully density characteristic factor, topography factor data sets are established, and correlation analysis, to enhance disaster information content.

scholarly journals Slope ranking and geohazards correlation analysis for combined open-underground mining area

2018 ◽  
Author(s):  
Zhang Jin
Keyword(s):  
Correlation Analysis ◽  
Water Conservation ◽  
Laser Scanning ◽  
Underground Mining ◽  
Mining Area ◽  
Open Pit ◽  
Ground Subsidence ◽  
Data Sets ◽  
Mining Areas ◽  
Factor Data

Geohazards in mining areas are mainly ground subsidence, slope landslides and ground cracks, surface cover degradation and environmental ecological pattern destruction. The classification and rank of terrain slope and the feature area extraction of the slope are the important content for the correlation analysis with the geohazards. The slope classification and rank index system for soil and water conservation, land use and man-made ground disasters was analyzed. According to the characteristics of open pit and underground associated mining area, we comprehensively analyzed the spatial correlation between different ground disaster and terrain features and landform types, and propose a new slope ranking index, dividing slope zones and forming slope classification map. Especially slope area of 35-45 degrees and more than 45 degrees was extracted, and the relationship between regional geohazards and slope zone was analyzed. The application of terrestrial laser scanning technology to establish open-pit high precision digital elevation model, extraction of slope, slope type, gully density characteristic factor, topography factor data sets are established, and correlation analysis, to enhance disaster information content.

DEVELOPMENT OF AUTOMATED EVALUATION OF POSITIONING ACCURACY FOR SPECIALIZED NETWORKS’ POINTS IN TRILATERATION NETWORKS

2020 ◽  
Author(s):  
Мурат Газизович Мустафин ◽  
Глеб Андреевич Фролов
Keyword(s):  
Coordinate System ◽  
Visual Basic ◽  
Microsoft Excel ◽  
Positioning Accuracy ◽  
Automated Evaluation ◽  
Visual Basic For Applications ◽  
Multiple Configurations

В данной работе рассмотрен принцип работы созданного алгоритма, позволяющего автоматически определять среднюю квадратическую погрешность планового положения пунктов сетей трилатерации и представлены результаты автоматизации данного процесса при различных конфигурациях сети, с использованием пакетов Microsoft Excel, Visual Basic for Applications. This paper presents automatic solution for evaluating accuracy of positioning for specialized networks’ points in a plane coordinate system. The paper presents results of automation of this process through analysis of multiple configurations of trilateral networks using Microsoft Excel, Visual Basic for Applications.

Optimization Problem of a Linear Induction Generator with a Liquid Working Fluid

2021 ◽  
Vol 64 (6) ◽  
pp. 16-21
Author(s):  
Konstantin Kim ◽  
◽  
Konstantin Kim ◽  
Andrey Vataev ◽  
◽  
...  
Keyword(s):  
Computer Technology ◽  
Optimization Problem ◽  
Magnetic System ◽  
Optimality Criteria ◽  
Working Fluid ◽  
Conducting Liquid ◽  
Calculation Algorithm ◽  
Linear Induction ◽  
Induction Generators ◽  
Calculation Results

We present the problem of optimization of cylindrical linear induction generators. The stator winding is located on the inner and outer cores of the magnetic system. The working fluid is a well-conducting liquid moving at a constant speed along the length of the channel. Since the generator is one of the elements of a complex installation the problem of optimizing it should be coordinated with a similar problem for the installation as a whole. This is done with the help the parameters common to all installation elements. Such parameters are the speed and flow rate of the working fluid. We describe the calculation algorithm with the use of computer technology. The efficiency and specific gravity of the generator are accepted as optimality criteria. The calculation results for a generator with the power of 20 MW are presented.

scholarly journals Optimization of material delivery time analysis by using Visual Basic for applications in Excel

2021 ◽  
Vol 2 (2) ◽  
pp. 89
Author(s):  
Muhammad Ali Khan ◽  
Muhammad Ahmed Kalwar ◽  
Abdul Karim Chaudhry
Keyword(s):  
Small And Medium Enterprises ◽  
Visual Basic ◽  
Delivery Time ◽  
Time Analysis ◽  
Monthly Basis ◽  
Visual Basic For Applications ◽  
Manual Tasks ◽  
Medium Enterprises ◽  
Automated Methods ◽  
Planning Production

<p>In small and medium enterprises, huge numbers of reports are prepared regarding the procurement, planning, production etc on daily, weekly, monthly, quarterly and yearly basis. If the interval between preparation of same report is longer then there is the greater probability that employee can forget the procedure of preparing the report; thus it is beneficial to automate these types of reports especially when there is no cost required for automation. In the same way, material delivery analysis is a kind of report which is prepared on monthly basis and as per the employees` feedback they usually forget some of the steps of report formation; therefore, there was the chance of mistake at the end of employee. Therefore, this report was automated for to minimize the chance of error and report preparation time. All the manual tasks were enlisted and were programmed for automation by the help of VBA macros. For the execution of macros, userform was designed in visual basic editor (in MS excel) consisted on four command buttons and macros were called on command buttons` click. On pressing ‘ctrl + q’ userform used to appear on the screen. Furthermore, the comparison of old and automated methods was conducted to reflect the best suitable method. The report used to take 1.55 minutes to be made manually. Comparison of time of both methods of report formation indicated that suggested method took 70.86% less time as compared to the old method of preparing material delivery time analysis report.</p>

scholarly journals DEVELOPMENT AND TESTING OF ALGORITHM FOR CALCULATION OF OPERATING PARAMETERS OF TRAWLING SYSTEMS

2019 ◽  
Vol 198 ◽  
pp. 221-229 ◽  
Author(s):  
E. A. Zakharov ◽  
O. N. Kruchinin ◽  
D. L. Shabelsky
Keyword(s):  
Experimental Data ◽  
Visual Basic ◽  
Educational Process ◽  
Resistance Force ◽  
Operating Parameters ◽  
Calculation Algorithm ◽  
Model Application ◽  
Bottom Trawling ◽  
Good Convergence ◽  
Expansion Force

Numerical model of trawling system is developed on the base of equilibrium principle, using F.I. Baranov’s scheme of its power and geometric parameters interdependence. The model application to bottom trawling takes into account the effect of bottom grounds on the resistance force and expansion force of the trawling system. Algorithm is proposed for calculation of operating parameters of bottom and midwater trawls, with an operation to minimize the error of iteration. The model and the calculation algorithm were tested in MS Office Excel environment, using Visual Basic programming, and showed good convergence of the calculated and experimental data that indicates reliability of the model. This algorithm and the program for calculation of operating parameters could be used for trawl designing, in accounting surveys to determine the trawl opening, and in educational process for training the industrial fishery scholars.

Controlling a Twister II with VBA and the Zymark ZyRobot ICP

2002 ◽  
Vol 7 (6) ◽  
pp. 92-95
Author(s):  
David S. Pechter
Keyword(s):  
Visual Basic ◽  
Normal Operation ◽  
Automated Measurement ◽  
Direct Control ◽  
Visual Basic For Applications

A Visual Basic for Applications program was developed for direct control of a Twister II robot using the Zymark ZyRobot_ICP. Direct control enables automated check-out of the robot, and automated measurement of the plate stacks prior to a robot run. Normal operation of the robot program is performed with just two buttons.

Sign in / Sign up

Export Citation Format

Share Document