Visual Basic Research Articles

Perancangan Sistem Informasi Pembayaran Administrasi SMK Negeri 1 Jiwan


 The rapid development of technology requires schools to provide optimal service to their students, especially in SMK Negeri 1 Jiwan. Improve the quality of information systems is one way to support services to students. The administration payment information system is designed in accordance with the circumstances in the school. The data were collected using interview method and observation method. This research produce information system design using Microsoft Visual Basic 6.0 which can help SMK Negeri 1 Jiwan to give service in administration payment of student.

A novel method of fuzzy fault tree analysis combined with VB program to identify and assess the risk of coal dust explosions.

Coal dust explosions (CDE) are one of the main threats to the occupational safety of coal miners. Aiming to identify and assess the risk of CDE, this paper proposes a novel method of fuzzy fault tree analysis combined with the Visual Basic (VB) program. In this methodology, various potential causes of the CDE are identified and a CDE fault tree is constructed. To overcome drawbacks from the lack of exact probability data for the basic events, fuzzy set theory is employed and the probability data of each basic event is treated as intuitionistic trapezoidal fuzzy numbers. In addition, a new approach for calculating the weighting of each expert is also introduced in this paper to reduce the error during the expert elicitation process. Specifically, an in-depth quantitative analysis of the fuzzy fault tree, such as the importance measure of the basic events and the cut sets, and the CDE occurrence probability is given to assess the explosion risk and acquire more details of the CDE. The VB program is applied to simplify the analysis process. A case study and analysis is provided to illustrate the effectiveness of this proposed method, and some suggestions are given to take preventive measures in advance and avoid CDE accidents.

PERANCANGAN SISTEM INFORMASI PKL DAN SKRIPSI YANG MAMPU MENGUKUR WAKTU PENYELESAIAN PENGAJUAN SURAT TUGAS PEMBIMBING

Computerized information system is neededs to help the Dikjar Unit to ease business processes at Faculty of Engineering, Universitas Pembangunan Nasional Veteran Jakarta to input data. Therefore, it is necessary to design information systems that can support the process. As for tools and construction techniques used in this design, such as flowchart, data flow diagram (DFD) and Entity Relationship Diagram (ERD). And use of software, such as Microsoft Visual Basic 2013 as a tool for designing programs based on web, Microsoft Excel 2013 as the database that will connect with the program designed. This research was limited to only discussing about the design and internal running test. The real appliying on the Dikjar Unit will be discuss on next period of this jurnal. The end result of this research is a web-based application program that used to perform data entry preceptor of thesis and work practice, which are able to assess the performance of the Dikjar's Unit completion time.

Analyzing the Clinical Outcomes of a Rapid Mass Conversion From Rosuvastatin to Atorvastatin in a VA Medical Center Outpatient Setting.

Background: Medication conversions occur frequently within the Veterans Health Administration. This manual process involves several pharmacists over an extended period of time. Macros can automate the process of converting a list of patients from one medication to a therapeutic alternative. Objectives: To develop a macro that would convert active rosuvastatin prescriptions to atorvastatin and to create an electronic dashboard to evaluate clinical outcomes. Methods: A conversion protocol was approved by the Pharmacy & Therapeutics Committee. A macro was developed using Microsoft Visual Basic. Outpatients with active prescriptions for rosuvastatin were reviewed and excluded if they had a documented allergy to atorvastatin or a significant drug-drug interaction. An electronic dashboard was created to compare safety and efficacy endpoints pre- and postconversion. Primary endpoints included low-density lipoprotein (LDL), creatine phosphokinase (CPK), aspartate transaminase (AST), alanine transaminase (ALT), and alkaline phosphatase. Secondary endpoints evaluated cardiovascular events, including the incidences of myocardial infarction, stroke, and stent placement. Results: The macro was used to convert 1520 patients from rosuvastatin to atorvastatin over a period of 20 hours saving $5760 in pharmacist labor. There were no significant changes in LDL, AST, ALT, or secondary endpoints (P > .05). There was a significant increase in alkaline phosphatase (P = .0035). Conclusions: A rapid mass medication conversion from rosuvastatin to atorvastatin saved time and money and resulted in no clinically significant changes in safety or efficacy endpoints. Macros and clinical dashboards can be applied to any Veterans Health Administration facility.

SISTEM INFORMASI PENJUALAN KREDIT PADA MOHAN GROSIR SOLO SECARA MULTIUSER

Mohan Grosir Solo is a store engaged in the field of Sales and Sales Cooperation Sales with Credit Sales System. Sales of credit that runs from direct submission to the cashier by submitting identity cards only. Customers do the taking of goods in accordance with the value of the approved filing then the customer will pay in accordance with the applicable provisions. With the credit sales information system is expected small errors up to the large can be resolved, especially the problem of payment arrears and repayment payment. System design that includes: Diagram Context, HIPO, Data Flow Diagrams, Document Flow Diagrams, Database Design, Input Design, Output Design, Implementation of the program by using appropriate data stimulation. The purpose of this research is to create and design multi-level loan sales information system at Mohan Grosir Solo. Then the results obtained from this system are Input of Goods Data, Input of Customer Data, Input of Supplier Data, Input of Data of Department of Goods, Input of Cashier Data, Purchase Transaction, Purchase Return Transaction, Credit Sale Transaction, Sales Return Transaction, Cash Transaction, Customer Data Report, Supplier Data Report, Department of Goods Data Report, Cashier Data Report, Purchase Transaction Report, Purchase Return Report, Credit Sales Transaction Report, Sales Returns Report, and Cash Advance Report. System information created using Microsoft Visual Basic 6 and SQL Server database has been done blackbox testing with a design that is appropriate. Keywords: Information System, Multiuser, Credit Sales.

Aplikasi Sistem Informasi Manajemen pada Usaha Peternakan (Studi Kasus: Kelompok Tani Serambi Mekah Padang Panjang)

Science and technology for society have been made in Serambi Mekah farmer groups with the aim to improving the managerial capacity of the business with the help of Management Information Systems (MIS). Event starts from the identification of the Standard Operational Procedure, making the algorithm, design tables, forms, queries and reports using Microsoft Access and Microsoft Visual Basic to a SIM application software. The results showed activities SIM can be used as a controller to support the business as a business decision and record all activities in a systematic and integrated transactions. SIM can provide information to support management decisions to be taken manager, enabling better decisions can be made quickly and accurately. Support bookkeeping in SIM allows manager can easily keep an eye on corporate wealth, monitor progress and provide reports to business stakeholders. Key words : information systems, management, dairy cattle, bookkeeping

Desarrollo de una aplicación para el cálculo de las propiedades de la mezcla amoniaco-agua

El diseño y la optimización de sistemas energéticos en la actualidad son de gran importancia. Algunos de estos sistemas emplean la mezcla amoniaco-agua como fluido de trabajo, por lo tanto, el cálculo de las propiedades termodinámicas se vuelve indispensable para su evaluación, diseño y optimización. En el presente trabajo se ha desarrollado una aplicación en ExcelTM empleando Visual Basic (VBA) a partir de una formulación basada en la energía de Gibbs de exceso, con la finalidad de simular diversos sistemas, como pueden ser de refrigeración, aire acondicionado, bombas de calor, cogeneración y ciclos de potencia, sin la necesidad de adquirir simuladores comerciales para tal propósito. Para validar dicho programa se han comparado los resultados con los datos arrojados por el software desarrollado por el National Institute of Standars and Technology (NIST) y datos experimentales reportados en literatura.

A developed case-based reasoning system for machine tool selection

PurposeSubtractive manufacturing process is the controlled removal of unwanted material from the parent workpiece for having the desired shape and size of the product. Several types of available machine tools are utilized to carry out this manufacturing operation. Selection of the most appropriate machine tool is thus one of the most crucial factors in deciding the success of a manufacturing organization. Ill-suited machine tool may often lead to reduced productivity, flexibility, precision and poor responsiveness. Choosing the best suited machine tool for a specific machining operation becomes more complex, as the process engineers have to consider a diverse range of available alternatives based on a set of conflicting criteria. The paper aims to discuss these issues.Design/methodology/approachCase-based reasoning (CBR), an amalgamated domain of artificial intelligence and human cognitive process, has already been proven to be an effective tool for ill-defined and unstructured problems. It imitates human reasoning process, using specific knowledge accumulated from the previously encountered situations to solve new problems. This paper elucidates development and application of a CBR system for machine tool selection while fulfilling varying user defined requirements. Here, based on some specified process characteristic values, past similar cases are retrieved and reused to solve a current machine tool selection problem.FindingsA software prototype is also developed in Visual BASIC 6.0 and three real time examples are illustrated to validate the application potentiality of CBR system for the said purpose.Originality/valueThe developed CBR system for machine tool selection retrieves a set of similar cases and selects the best matched case nearest to the given query set. It can successfully provide a reasonable solution to a given machine tool selection problem where there is a paucity of expert knowledge. It can also guide the process engineers in setting various parametric combinations for achieving maximum machining performance from the selected machine tool, although fine-tuning of those settings may often be required.

SIMULASI MONTE CARLO DENGAN MODEL PERSEDIAAN STOKASTIK PADA PT.BINGEI MEDAN

Inventory systems or inventory is very important for a company, especially if the company is engaged in the distribution of goods. PT. Bingei Medan is a company engaged in the sale of fertilizers. The availability of fertilizers in fulfilling customer orders to be very important, it is necessary to well-managed inventory. The purpose of this study is to make simulation using the programming language Microsoft Visual Basic Version 6.0 and simulations built a simulation model of the stochastic inventory system PT. Bingei Medan. And the results of this simulation to analyze the characteristics of inventory system such as the average level of availability of goods, the amount of goods ordered, the number of items that are not fulfilled (stock out) and the amount of time ordering goods

Development of online detection system for natural frequency of brake discs based on the improved least squares complex frequency domain method

This paper firstly introduced the theory and implementation of the least squares complex frequency domain (LSCF) method based on the truncated singular value decomposition (SVD) for noise reduction. The simulation results of signals with different signal noise ratios (SNR) show that this algorithm is stable and has excellent capacity of resisting noise disturbance. On this basis, an online detection system for natural frequency of brake discs is developed. This system takes the LAN-XI date acquisition module and LABSHOP software of B&K as platform and uses Visual Basic (VB) and MATLAB mixed programming technique for its secondary development. The LSCF method based on the truncated SVD is applied for curve fitting and modal parameter extracting. The qualified criterion is that the stably appearing natural frequencies are in the tolerance ranges. The practical application shows that this system intuitively and accurately displays the detection results and performs stably and efficiently.

Method and Excel VBA Algorithm for Modeling Master Recession Curve Using Trigonometry Approach.

A new method was developed and implemented into an Excel Visual Basic for Applications (VBAs) algorithm utilizing trigonometry laws in an innovative way to overlap recession segments of time series and create master recession curves (MRCs). Based on a trigonometry approach, the algorithm horizontally translates succeeding recession segments of time series, placing their vertex, that is, the highest recorded value of each recession segment, directly onto the appropriate connection line defined by measurement points of a preceding recession segment. The new method and algorithm continues the development of methods and algorithms for the generation of MRC, where the first published method was based on a multiple linear/nonlinear regression model approach (Posavec et al. 2006). The newly developed trigonometry-based method was tested on real case study examples and compared with the previously published multiple linear/nonlinear regression model-based method. The results show that in some cases, that is, for some time series, the trigonometry-based method creates narrower overlaps of the recession segments, resulting in higher coefficients of determination R2 , while in other cases the multiple linear/nonlinear regression model-based method remains superior. The Excel VBA algorithm for modeling MRC using the trigonometry approach is implemented into a spreadsheet tool (MRCTools v3.0 written by and available from Kristijan Posavec, Zagreb, Croatia) containing the previously published VBA algorithms for MRC generation and separation. All algorithms within the MRCTools v3.0 are open access and available free of charge, supporting the idea of running science on available, open, and free of charge software.

The Effect of Cooling Water Mass Flow Rate Variations on the Heat Pipe Solar Collector Performance

The thermal performance of FPHPSC has been studied experimentally and theoretically. The collector consists of copper absorber plate, single glass cover, glass wool insulation and aluminum case. Ten wickless heat pipes of 12.7 mm inner diameter. The experimental studies of collector performance have been performed on four different CWMFR (0.03, 0.04, 0.05 and 0.06) kg/s. The relation between the amount of useful heat, instantaneous collector efficiency and solar intensity is discussed. The collector are tested under the climate condition of Kut city (32.6 latitude and 45.7 longitude). It is investigated that the increasing of CWMFR increase the efficiency of the collector. The percentage increase in the efficiency of the solar collector is in order of (13%), when the cooling water mas flow rate changes from 0.03 kg/sec to 0.06 kg/sec at (45o) collector tilt angle. A computer program based on VISUAL BASIC language (version 6) used for the theoretical analysis. The experimental results are in agreement reasonably with the theoretical predictions.

Multi-objective optimization of gas metal arc welding parameters and sequences for low-carbon steel (Q345D) T-joints

Q345D high-quality low-carbon steel has been extensively employed in structures with stringent welding quality requirements. A multi-objective optimization of welding stress and deformation was presented to design reasonable values of gas metal arc welding parameters and sequences of Q345D T-joints. The optimized factors included continuous variables (welding current (I), welding voltage (U) and welding speed (v)) and discrete variables (welding sequence (S) and welding direction (D)). The concepts of the pointer and stack in Visual Basic (VB) and the interpolation method were introduced to optimize the variables. The optimization objectives included the different combinations of the angular distortion and transverse welding stress along the transverse and longitudinal distributions. Based on the design of experiments (DOE) and the polynomial regression (PR) model, the finite element (FE) results of the T-joint were used to establish the mathematical models. The Pareto front and the compromise solutions were obtained by using a multi-objective particle swarm optimization (MOPSO) algorithm. The optimal results were validated by the corresponding results of the FE method, and the error between the FE results and the two-objective results as well as that between the FE results and the three-objective optimization results were less than 17.2% and 21.5%, respectively. The influence and setting regularity of different factors were discussed according to the compromise solutions.

Development of a decision support system for simulation of runoff and available soil moisture at field scale land holdings of watershed

A decision support system (DSS) is useful in generating alternate decision scenario for management of natural resources in an interactive and holistic way. The developed decision support system on runoff and soil moisture availability as a part of hydrological planning based on SCS curve number method uses the measured information on land use, soil type and rainfall. These conceptual decision and flow logic was formulated to link information through SCS curve number method and has transformed into a computer model using visual basic (VB) programming language. The output format provides daily rainfall and runoff and soil moisture status of the soil continuously for a given period of daily data. The DSS was validated for field scale land holdings of micro-watershed data and proposed for utilization by farmers and technocrats of line departments.

Design Models for Anaerobic Batch Digesters Producing Biogas from Municipal Solid Waste

Models for the design of anaerobic batch digesters producing biogas from municipal solid waste (MSW) in Port Harcourt metropolis, Nigeria have been formulated. Experimental and field data were used to determine relevant design parameters for the batch digesters, especially the bio-kinetic behavior of MSW. The research data were analyzed using material balance analysis. The anaerobic digester was then designed and simulated for fractional conversion values of 0.2 ≤ α ≤ 0.8 and percentage total solids (PTS) concentration of 10-30%, using Microsoft Visual Basic Version 6.0 computer program. The simulation results were interpreted with Microsoft Chart Editor. The evaluation of research results showed that an empirical optimum PTS concentration of 20% was best suited for the batch digester processing the MSW for biogas generation. At this level of PTS concentration, the MSW digestion was most effective in terms of digester sizing, time of digestion, volume of biogas produced and overall cost of the digester, for the same level of percent stabilization.

Coupling of a distributed stakeholder-built system dynamics socio-economic model with SAHYSMOD for sustainable soil salinity management. Part 2: Model coupling and application

Many simulation models focus on simulating a single physical process and do not constitute balanced representations of the physical, social and economic components of a system. The present study addresses this challenge by integrating a physical (P) model (SAHYSMOD) with a group (stakeholder) built system dynamics model (GBSDM) through a component modeling approach based on widely applied tools such as MS Excel, Python and Visual Basic for Applications (VBA). The coupled model (P-GBSDM) was applied to test soil salinity management scenarios (proposed by stakeholders) for the Haveli region of the Rechna Doab Basin in Pakistan. Scenarios such as water banking, vertical drainage, canal lining, and irrigation water reallocation were simulated with the integrated model. Spatiotemporal maps and economic and environmental trade-off criteria were used to examine the effectiveness of the selected management scenarios. After 20years of simulation, canal lining reduced soil salinity by 22% but caused an initial reduction of 18% in farm income, which requires an initial investment from the government. The government-sponsored Salinity Control and Reclamation Project (SCARP) is a short-term policy that resulted in a 37% increase in water availability with a 12% increase in farmer income. However, it showed detrimental effects on soil salinity in the long term, with a 21% increase in soil salinity due to secondary salinization. The new P-GBSDM was shown to be an effective platform for engaging stakeholders and simulating their proposed management policies while taking into account socioeconomic considerations. This was not possible using the physically based SAHYSMOD model alone.

Optimasi Penggunaan Kontainer dengan Algoritma Hill-Climbing

Problems that often happen is the charge that would like included in the container exceeds or is far less than the maximum volume of container space. In the case of the process of door to door or door to port, overloaded force clients should reduce the number of items that must be sent in order to fit with container capacity. While less than the maximum load that makes a lot of wasted container space volume that causes the client to fill it with stuff that does not exist in the delivery plan or let it remain fully charged with the costs of ineffective. The purpose of this field study is to maximize the use of volume of space in the container with the method of hill-climbing algorithm and utilize software programs created with Microsoft Visual Basic 6.0. Processing the data shows that during the delivery of goods, the utilization rate of container volume ranges from 44.185% to 72.630%. By using optimization calculation based on hill-climbing algorithm in the program made, the utilization rate of container volume can be optimized from the original 66.563% to 91.895% with an increase of 25.332%. Keywords: Supply Chain, Hill-Climbing Algorithm, Optimization

Sistem Pendukung Keputusan Pemilihan Asisten Laboratorium Menggunakan Metode Simple Additive Weighting (SAW)

Acceptance laboratory assistant in STMIK of Palangka Raya is one example of a case in making decision.Lecturers who became a selector of a practicum lecture will do selection acceptance assistant to the student who has registered as a candidate for assistant so that the process undertaken inaccurate in the selection process. the role of information technology is expected to be used to assist the lecturer in the process of acceptance of a laboratory assistant, so as to speed up the process and can produce the best decisions about anyone assistants who is received so that made the supporting system of decision selection laboratory assistant in STMIK of Palangka Raya which use method of Simple Additive Weighting (SAW). To make this system uses a method of SAW and the programming language used is Microsoft Visual Basic 6.0, then the system is developed using development method of software waterfall with design tools such as DFD (Data Flow Diagram) , ERD (Entity Relationship Diagram) and Database. With there is the Decision Support System that can be easier for STMIK of Palangka Raya in aiding the selection of a laboratory assistant so that can improve the quality of laboratory assistant.

Integrasi Sistem Data Kecelakaan Lalu Lintas di Kabupaten Jember

The rapid development of technology can help people solve their problems faced every day. One of them is the problem in transportation sector related traffic accident data often occur in Jember. Many agencies and institutions that play a role, making the existing data to be different. Traffic accident report from police and patient report in emergency room from hospital is collected from 2012 to 2014. The result of this research is a good integration traffic accident database system between police and hospital using PostgreSQL, an information system about traffic accident recording with the location can be presented in digital map using Microsoft Visual Basic 6.0, and a recommendations to improve the accuracy of existing traffic accident data.

Development of a Microsoft Excel tool for one-parameter Rasch model of continuous items: an application to a safety attitude survey

BackgroundMany continuous item responses (CIRs) are encountered in healthcare settings, but no one uses item response theory’s (IRT) probabilistic modeling to present graphical presentations for interpreting CIR results. A computer module that is programmed to deal with CIRs is required.To present a computer module, validate it, and verify its usefulness in dealing with CIR data, and then to apply the model to real healthcare data in order to show how the CIR that can be applied to healthcare settings with an example regarding a safety attitude survey.MethodsUsing Microsoft Excel VBA (Visual Basic for Applications), we designed a computer module that minimizes the residuals and calculates model’s expected scores according to person responses across items. Rasch models based on a Wright map and on KIDMAP were demonstrated to interpret results of the safety attitude survey.ResultsThe author-made CIR module yielded OUTFIT mean square (MNSQ) and person measures equivalent to those yielded by professional Rasch Winsteps software. The probabilistic modeling of the CIR module provides messages that are much more valuable to users and show the CIR advantage over classic test theory.ConclusionsBecause of advances in computer technology, healthcare users who are familiar to MS Excel can easily apply the study CIR module to deal with continuous variables to benefit comparisons of data with a logistic distribution and model fit statistics.