Visual Basic Programming Research Articles

Analisa Model Evaporasi dan Evapotranspirasi Menggunakan Pemodelan Matematika pada Visual Basic di Kabupaten Maros

The approach to calculating evaporation and evapotranspiration, both potential and actual, varies widely. The models used to estimate the amount of evapotranspiration, particularly at the Maros Climatology Station, Maros Regency, South Sulawesi. Evaporation models use the Penman, Priestley, Bruin, and Valiantzas models while evapotranspiration models use the Penman, Hargreaves, Jensen-Haise, Penman-Monteith, Radiation, Turc, and Makkink models, where all of these methods use climate data, such as are the minimum temperature (Tn), maximum temperature (Tx), air temperature (Ta), average humidity (RH), rainfall (R), duration of sun exposure (SS), and maximum wind speed (U) in calculations using Visual basic program in Microsoft Excel in the form of code. Thus, it is necessary to conduct an analysis of the suitability of the model to the results of the observations in order to find out which model is suitable according to the results of the largest coefficient of determination (R2). Based on the results of the model suitability analysis, a selected model was obtained, namely the Valiantzas model with a value of 0.980 in the evaporation calculation and the Jensen-Haise model, namely 0.889.

Simulation of progressive shear failure in railway foundation

Railways are one of the largest transportation networks in the world. One of the key subgrade problems of railway track is associated with progressive shear failure (PSF). To-date, limited number of studies have addressed failure mechanism associated with the PSF, especially extending the mechanics of unsaturated soils. In this paper, the PSF mechanism is studied with the aid of computer program that was developed using a Visual Basic program in AutoCAD, extending Mohr-Coulomb failure criteria within the unsaturated soil mechanics framework. Simulation results suggest several parameters that include stress distribution, matric suction, cohesion, coefficient of lateral earth pressure at rest, and coefficient of residual friction as well as the angle of internal friction have a significant effect on the PSF and the shape of failure planes in the subgrade. The PSF in subgrade can be reduced by optimizing the combination of these parameters. The simulation results suggest the PSF can be well simulated with the Mohr-Coulomb failure criteria.

HMCA-Contour: A Visual Basic Program Based on Surfer Automation for Soil Heavy Metal Spatial Distribution and Contamination Assessment Mapping

Soil heavy metal contamination has become a major concern in many parts of the world. Grasping the spatial distribution patterns of heavy metals and evaluating soil heavy metal contamination are of great significance to policy makers for land use planning and pollution identification. However, these processes usually involve repetitive calculation and plotting, which are time-consuming and laborious, especially in a geochemical survey. In this paper, HMCA-Contour, which is a program written in Visual Basic based on Surfer 13.0, has been designed to simplify the pollution indices recalculation and plotting routines. This software is comprised of three functions, i.e., data processing, plotting, and template setting. With user-friendly interfaces, the user can easily and efficiently calculate pollution indices and generate batch publication-quality maps of heavy metal spatial distribution and pollution levels. To demonstrate the advantage of HMCA-Contour, a case study from the Gaerqin Mine area is used in this paper. HMCA-Contour, as a brand new software, is promising and will become a useful tool for environmental management.

Enkripsi Database Sekolah SMK Pembangunan Dengan Algoritma IDEA

One of the algorithms in cryptography that can be used for school database security is the IDEA (International Data Encryption Algorithm) algorithm. The IDEA algorithm is one of the cryptographic algorithms that has various applications in secure data transmission in the scope of networks and distributed measurement systems. Encryption results appear in the form of a notepad. The Open data button is used to find data that will be used for the encryption process. The key checklist is used to input the key length that will be used for the encryption decryption security process. The system displays the IDEA Cryptographic key, can use the IDEA Cryptographic key, the encryption and decryption change process is clearly visible. Encryption is done on the SMK Pembangunan school database with IDEA algorithm and designing the student database encryption application based on the name of the SMK Pembangunan using Visual Basic programming language.

PERANCANGAN SISTEM INFORMASI PENCARIAN KERUSAKAN SEPEDA MOTOR SISTEM ELECTRONIC FUEL IGNATION (EFI)

Have researched a sistym information about malfunction problems sitem search motor cycle which the device uses advanced methods of reasoning in expert systems . Troubelshooting on motor cycle generally used manually, by determining the symptoms theoretically derived from the experiences so that a technician and student / student often neglected problem finding time and accuracy in solving the problems of motor cycle with EFI sistem repair problems .The method used is the observation on trouble shooting to EFI sensor sistem and collect data from any symptoms of damage to television later in the evaluation of the raw data is entered into a database to an expert system by utilizing visual basic programming .The results will produce a search expert software system that can damage on EFI sensor sparepart can help the technicians and users of the motor cycle itself to recognize and deal damage that occurs EFI component sistem .

Numerical investigation of fluid flow in fracture junctions with consideration to effect of fracture morphology

AbstractBecause the fracturing fluid flow at fracture junctions directly affects the proppant distribution in fracture networks, it is very important to quantitatively investigate the fluid flow in fracture junctions. In this study, the fluid flow in a laboratory‐size fracture junction was investigated, and equations for calculating the fluid split ratio were established. The correlations between the pressure loss coefficients and the width ratio, approaching angle, and fluid split ratio were obtained by simulation. Using a custom‐made Visual Basic program, the fluid split ratios in an actual‐size fracture or complex fracture networks with several secondary or tertiary fractures were calculated. The results reveal that the fluid split ratio is significantly affected by the approaching angle and width ratio in laboratory‐size fractures. In contrast, in an actual‐size fracture junction, the fluid split ratio is mainly affected by the length of the fracture channel and the width ratio. The split ratios in laboratory‐size and real‐size fracture networks with several secondary or tertiary fractures are quite different, which indicates that the split ratio should be quantitatively estimated when investigating the proppant distribution by experiment or simulation. The findings of this study can be useful in the quantitative investigation of the proppant distribution in fracture networks.

Automatic Feature Recognition of Cross Holes in Hollow Cylinders

Automatic Feature Recognition (AFR) techniques provide the capabilities for translating the data of the part definition between Computer Aided Design (CAD) system and the feature needed to be determined; these techniques take a general CAD model, which is commercially available for providing an automated interface to extract and recognize the manufacturing features from the CAD model. Standard for Exchange of Product (STEP) format is an international standard for transporting geometric and non-geometric data between CAD and Computer Aided Manufacturing systems. Many researches have investigated the AFR in symmetrical features in rotational parts, but few studies have tried to recognize the cross-hole feature because of the recognition difficulty of such feature. A cross hole is recognized with existence of (B-spline Curve with Knots) string in (STEP AP203) neutral file. Cross holes might be perpendicular, offset or inclined to cylinder’s axis, it also can be blind or through. Extraction of the necessary information from (STEP) file for generating the parameters of the manufacturing operation becomes a significant task. In this paper, a new approach for automatic recognition of cross hole feature in hollow cylinders is developed, This approach has been built by connecting the Visual Basic programming language (VB) to the SolidWorks software. The drawing is sent to the VB after saving it as a (STEP AP203) file. VB extracts and recognizes the cross-hole feature according to the rule-based reasoning, some case studies for demonstrating the application of this method on different cases of the cross-hole are presented.

Optimization and Fabrication of Customized Scaffold Using Additive Manufacturing to Match the Property of Human Bone

Additive manufacturing plays a major role in medical science. One of the applications is the development of bone scaffolds. During scaffold fabrication, obtaining the properties of the polyamide scaffolds to mimic the elastic properties of human subchondral bone is a challenging task. In order to overcome this challenge, the present numerical study validated by experimental routine allows optimizing, fabricating and automating the generation of open porous polyamide scaffolds. Human subchondral bone has an elastic modulus of 1.15 GPa and pore size of 800 μm which helps for cell ingrowth. The design parameters such as strut diameter (0.6-3 mm) and unit cell size (1.4-5 mm) were considered for this investigation. The optimized scaffold structure was fabricated using selective laser sintering method, one of the additive manufacturing (AM) processes and the structure was validated through uniaxial compression. Experimental test revealed a deviation in structural modulus of about 14, 10 and 17% for circular, square and hexagonal cross section, respectively. Optimized unit cell dimensions were found. The preliminary MTT (Methyl Thiazolyl diphenyl-Tetrazolium bromide) assay tests to evaluate the distributions of cells were performed, using in vitro perfusion culture experiments. It was found that the scaffold structure with square cross section has the maximum percentage of cell viability of 58.33%. A computer-aided design tool was developed using CATIA V5 Visual Basic program for modelling the bone scaffolds with better interconnectivity of unit blocks, porosity and compressive strength. This program facilitates automatic generation of optimized scaffold structure by providing necessary input parameters. The developed CAD tool was efficient enough to model the customized scaffold.

Adaptive fan control

The paper presents the possibility of management the fan performance in dependence on CO2 concentration. A mathematical calculation is made from the prediction of the electric energy consumption for a variant control algorithm. The most advantageous algorithm is programmed into the actual fan control system, and its power consumption is shown in graph. Finally, the saving of the adaptive control is compared to the classical control over time. To program the control algorithm, the CO2 mass balance equation is used. The equation depends on the input values, namely the number of CO2 sources, the room volume and the supply air. Due to the infinitely variable of fan control, it is possible to adjust the power setting depending on the expected development of the logarithmic rise of CO2 concentration in the room. This prediction is programmed with the Visual Basic code and program code can be used to the Arduino control unit, which controls the EC fan power with a 0-10 V signal. Although significant savings over a short period of time can not be expected, the ventilation system where the fan runs for a significant part of the year will be substantial. Therefore, the result will be presented by graphical diagrams of different ways of controlling the fan per year of operation.

Controlled Experiment for Assessing the Contribution of Ontology Based Software Redocumentation Approach to Support Program Understanding

Redocumentation is an approach that is used to recover knowledge from raw software artifacts by using alternative presentations. Several legacy systems have been developed based on event-driven programming which require redocumentation. However, these existing repository and query techniques emphasize only on lexical and syntactical based queries which come with limitations in providing the semantic relationship for program understanding. We are using ontology based approach that uses both ontology reasoning and querying techniques to generate software documentation from the knowledge repository. We present a controlled experiment for the empirical evaluation on the proposed ontology based approach and implemented in a tool called Ontology Based Software Redocumentation (OBSR). In this experiment, two existing tools namely Universal Report (UR) and Microsoft Visual Studio specifically for Visual Basic (VB) programming environment have been selected to be compared with the OBSR tool. The goal is to provide experimental evidence of the viability of our approach in the context of program understanding using HTML based semantic software documentation. The experiment shows that the software maintainers are able to understand and provide significant improvement in program understanding to accomplish the maintenance task easily. We describe in detail the experiment performed, discuss its results and reflect the lesson learned from the experiment.

ТРАНСЛЯЦИЯ ГЕОМЕТРИЧЕСКИХ МОДЕЛЕЙ ОДНОКОНТУРНЫХ ГЕОДЕЗИЧЕСКИХ КУПОЛОВ ИЗ ARCHICAD В НЕЙТРАЛЬНЫЙ STEP ФОРМАТ

The methods of data exchange between CAD and CAE systems are described. The first method is using direct conversion, the second method is using neutral formats. The description of the modular system for designing and analysis the strength and stability of single-contour and double-contour geodesic shells GeoTran is given. The direct translation of geometric models from ArchiCAD to Patran/Nastran / Dytran has the disadvantage of having to develop translators for each data exchange scheme. It is proposed to implement the translation of geometric models in a neutral STEP format, which reduces the number of required translators. It is noted that the STEP format is recognized by various CAE systems that implement the finite element method (Autodesk Mechanical Desktop, Bentley Microstation, CATIA V4, CATIA V5, MSC Patran/Nastran, UGS PLM Solutions NX). The characteristics of the OBJ format used for storing a geometric model in the ArchiCAD CAD system and the STEP format used for data exchange with CAE systems are studied. A translator of geometric models of single-contour geodesic shells from ArchiCAD to STEP format in the Visual Basic programming language has been developed. For this purpose a syntactically oriented approach was used. The translator has a graphical user interface that makes it easier to use. The translator allows you to automate the exchange of data between the ArchiCAD CAD system and various CAE systems designed for strength analysis and supporting import from the STEP format. The applicability of the translator for the exchange of data on geometric models of single-contour geodesic domes with triangular plates between ArchiCAD and the Delcam Exchange converter program is verified. It is demonstrated that the STEP file format generated by the OBJSTEPTranslator is recognized by an external program.

Thermal Analysis and Computer Aided Exhaust Valve Design Automation Using CREO and Microsoft Excel Spreadsheet

3D modeling has widely been used because of their ease in visualization, understanding and generation of manufacturing drawing sheets compared to 2D drafting. 3D Modeling is the timeconsuming process and many draftsmen does not have the skill to draw a 3D object inside a CAD packages. Internal combustion engine consists of two type of valves inlet valve and exhaust valve. The pair of inlet and exhaust valve is called as poppet valves. Exhaust valve is the mechanical object reputedly required nearly in all internal combustion engines. In this paper we are automate the exhaust valve design by creating graphical user tool using visual basic programming language inside the Microsoft excel spreadsheet. This excel spreadsheet is later integrated to CREO database for automatic 3D valve Modeling. Exhaust valve is the nose of the internal combustion engine to eject the exhaust gases out form the engine at a time of exhaust stroke. It is continuously come under the high temperature and pressure. Steady state thermal analysis has been carried out using FEA. To demonstrate our study, we are considered to design and analysis the exhaust valve for Honda CB Twister 110cc having chamfer angle of 45 degrees. For the 3D modeling we use CREO and ANSYS 18.0 is used for FEA analysis.

Programa computacional para verificação de perfil I laminado ou soldado conforme NBR 8800/2008

Devido ao grande número de verificações necessárias para o dimensionamento de perfis metálicos, vem a necessidade da elaboração de um programa computacional gratuito e com finalidade educacional para verificar o dimensionamento de perfis metálicos do tipo I, laminados e soldados, submetidos a esforços de tração, compressão, flexão, cisalhamento, flexo-tração e flexo-compressão, tendo como base a NBR 8800/2008 - Projeto de estruturas de aço e de estruturas mistas de aço e concreto de edifícios. O programa foi elaborado utilizando a linguagem de programação Visual Basic, que possibilitou a criação da interface gráfica, prática e acessível para o usuário. O programa determina, a partir dos dados informados pelo usuário, os esforços resistentes de cada perfil e os compara com os esforços solicitantes também informados pelo usuário. Por fim, o código conta, com uma ferramenta de informação de erros caso algum valor resultante encontre-se em desacordo com a norma em questão.

A Comparison of Different Estimation Methods to Handle Missing Data in Explanatory Variables

Missing data is one of the problems that may occur in regression models. This problem is usually handled by deletion mechanism available in statistical software. This method reduces statistical inference values because deletion affects sample size. In this paper, Expectation Maximization algorithm (EM), Multicycle-Expectation-Conditional Maximization algorithm (MC-ECM), Expectation-Conditional Maximization Either (ECME), and Recurrent Neural Networks (RNN) are used to estimate multiple regression models when explanatory variables have some missing values. Experimental dataset were generated using Visual Basic programming language with missing values of explanatory variables according to a missing mechanism at random general pattern and some ratios of missing values (10%, 20%, and 30%) with error variance values of 0.5, 1. 5, and 2, which were included in sample sizes of 25, 50, 100, and 500 and evaluated using Mean Squared Error (MSE). Simulation results show that RNN outperforms the other methods, followed by EM at small sample sizes.

Aplikasi Pelaporan Kelebihan Jam Mengajar Jurusan Akuntansi PNP

This study aims to create a database application program that is able to process data on lecturer course activities and generate reports on the calculation of teaching fees periodically during the pandemic which requires lecturers to report lecture activities online. The system design method approach used is prototyping, namely by creating a program that most closely resembles user needs in a relatively short time. The prototype was generated using the Microsoft Access 2010 database application. The selection of microsoft access to create a prototype was based on the availability of complete facilities in Microsoft Access to design table relations, input forms, query processing, reports and the visual basic programming language for applications. Google Forms used to receive lecture data input online. The application development stages consist of design, testing and implementation stages. This application has succeeded in providing the right solution for the Padang State Polytechnic Accounting Department during the pandemic in calculating and reporting lecture activities and lecturers teaching fees.

Inner Product of RGB Unit Vectors for Simple and Versatile Detection of Color Transition.

We propose a novel concept for detecting color transition by the inner product (IP) of RGB unit vectors. A digital microscope-based detector and a Visual Basic program were developed in-house. The concept is applied to indicator-based flow titration. The IP is 1 or < 1 if the vector's direction is the same or different, respectively. The IP's change can be used as a criterion for the indicator's color transition. The present IP-based approach is simple, economical, and versatile because it is applicable to any color transition without selecting an analytical wavelength.

Earned Value Analysis on National Salt Warehouse Construction Project

Earned Value Analysis is one of the tools used in managing projects that integrate time and cost. The purpose of this study is to calculate Earned Value Analysis using a visual basic program on the time and cost of implementing the National Salt Warehouse construction project, and to get the cause of the delay in the implementation of the National Salt Warehouse construction project. From the results of the calculation of Earned Value Analysis using a visual basic program, (1) North Aceh National Salt Warehouse, in the first week, I experienced a delay of 7 days with a loss of Rp. 980,884 and in the second week finished on schedule, but suffered a loss of Rp. 251,380; (2) Indramayu National Salt Warehouse, in the first week experienced a delay of 5 days with a loss of Rp. 1,999,489 and in the second week experienced a delay of 1 day with a loss of Rp. 1,168,999; (3) Demak National Salt Warehouse, in the first week experienced a delay of 3 days, but experienced a profit of Rp. 1,036,163 and in the second week finished on schedule with a profit of Rp. 9,916,102; (4) Jepara National Salt Warehouse, in the first week experienced a delay of 6 days with a loss of Rp. 202,965 and in the second week experienced a delay of 2 days, but experienced a profit of Rp. 277,461; (5) Pati National Salt Warehouse, in the first week experienced a delay of 6 days with a loss of Rp. 1,167,771 and in the second week finished on schedule, but suffered a loss of Rp. 847,378; (6) Pamekasan National Salt Warehouse, in the first week experienced a delay of 4 days with a loss of Rp. 395,200 and in the second week finished on schedule, but suffered a loss of Rp. 408,000. The causes of the delay in the implementation of the National Salt Warehouse construction project include: (1) the occurrence of unexpected things such as storm floods, earthquakes, landslides, fires, bad weather; (2) improper / wrong construction methods / implementation techniques; (3) identification, duration, and work order plan that is incomplete and not well organized; (4) the owner’s payment system to the contractor that is not in accordance with the contract, (5) the way of inspecting / controlling bureaucratic work by the owner, (6) work accidents that occur to workers.

“Old Techniques for New Times”: the RMaCzek package for producing Czekanowski’s diagrams

Summary Inspired by the MaCzek Visual Basic program we pprovide an R package, RMaCzek, that produces Czekanowski’s diagrams. Our package permits any seriation and distance method the user provides. In this paper we focus on the “OLO” and “QAP_2SUM” methods from the seriation package. We illustrate the possibilities of our package with three anthropological studies, one socioeconomic study and a phylogenetically motivated simulation study.

Theoretical Approach for the Calculation of the Pressure Drop in a Multibranch Horizontal Well with Variable Mass Transfer.

In this study, the pressure drop obtained from physical experiments and theoretical approaches of a single horizontal wellbore is reviewed and a comprehensive wellbore pressure-drop model is derived for a multibranch well. We propose a new coupling model for fluid flow in multibranch wells and reservoirs. Based on this coupling model, we introduce a theoretical approach for the calculation of the pressure drop in a multibranch horizontal well with variable mass transfer. To facilitate the understanding of the physical model, the entire coupling model was divided into three parts: (1) the pressure-drop model of the wellbore, (2) the reservoir inflow model, and (3) the coupling model. By incorporating the acceleration, friction, mixing, confluence, and gravity pressure drops, a coupling model with a finite-conductivity multibranch horizontal well was developed. Newton–Raphson iterations and Visual Basic programming were employed to solve the coupling model and to obtain the pressure and the inflow rate of the wellbore. The wellbore pressure-drop model was verified by comparing it with different models for the same case study, which has been previously introduced in a different research work. Furthermore, the forecast and sensitivity analysis were conducted, and then the results are discussed. In the proposed new model, several factors are considered, including the wellbore structure, the wellbore completion method, the wellbore, and the fluids and formation properties. The presented approach can be used as a valuable tool to analyze the influence of the pressure drop on the productivity of complex-structured wells and vice versa, and to quantitatively investigate the various pressure drops in wellbores, including the friction, acceleration, mixing, confluence, and gravity pressure losses.

Risk identification framework in construction of Egyptian mega housing projects

Egypt's population is increasing and expected to exceed 120 million by 2050. Egypt constructed mega housing projects (M.H.P) to cater with that escalation in population. The Egyptian strategy 2030 prioritized the construction of M.H.P. Contractors’ in Egypt have struggled to manage construction risks and deliver housing projects successfully. The aim of the paper is to develop a conceptual risk identification framework to improve contractors’ risk identification practices during the construction of mega housing projects in Egypt. The objectives of the paper are to analyse risk management practices in Egyptian M.H.P and to develop a risk identification framework (CRIF). The paper reviewed the literature of identified risks in construction of mega projects. Through a constructivism paradigm, the paper adopted the interview technique and allocated contractors’ recent risk practice. Qualitative risk information is analysed using NVivo tool for qualitative analysis. The paper used the ISO 31,000 as a backdrop to design a conceptual risk identification framework (CRIF), and a computerized risk identification database (CRID) using visual basic programming. The paper further produced generic guidelines to support the use of the CRIF during construction of M.H.P. Availability of resources, poor financial status, and weak technical training were the most common risks in construction of mega projects worldwide. The paper presented a risk breakdown structure (R.B.S) that included M.H.P common opportunities and challenges in Egypt. Egypt’s main challenges in construction of M.H.P included Management of Resources, Project Management, and Cash flow issues. The CRIF guides contractors’ in Egypt to improve risk knowledge, and management. The CRID improves the management of identified risks by providing a database for future M.H.P. The guidelines support contractors’ in using the conceptual risk identification framework. The paper updates risk identification process by adding multidisciplinary risk elements including risk communication, risk knowledge, and considering the context in building frameworks. The paper enhances contractors’ capability in management and identification of risks in construction of M.H.P. The paper allowed researchers to manage challenges and opportunities in construction of mega housing project in Egypt.