Excel VBA Research Articles

ANALISIS MOTIVASI BELAJAR SISWA SMP KELAS VII MENGGUNAKAN MEDIA VBA FOR EXCEL PADA MATERI ARITMATIKA SOSIAL

Social arithmetic is a very important mathematical material to be studied because it is concerned with everyday life. But in reality many students do not understand the concept of social arithmetic well so the need for VBA for Excel as a medium of learning to motivate students in learning social arithmetic. This study aims to analyze student’s learning motivation in the use VBA for Excel media on social arithmetic material. This research was conducted by using the qualitative descriptive research method. The subject of this research was a class VII junior high school student of 5 people, consisting of 2 male students and 3 female students. The instrument used in this study was a learning motivation indicators that amounted to 5 indicators and consisted of 10 positive and negative statements scale. The data processing technique used is the percentage scale of a student’s learning motivation attitude with the help of the Likert scale. This research indicated that learning using VBA for Excel media produces positive. These results can be seen from the average student response including strong categories, with a percentage of 68,5%.

Use of Worksheet events in Excel to save solver objective cell value from each iteration

Solver is a Microsoft Excel add-in program which is used to find an optimal value for a formula in the objective cell. Solver accomplishes this either by maximizing, minimizing or setting the objective cell value to a specific value. The article presents the utility of in built worksheet events in Excel VBA to save the value of objective cell from each iteration when solver is used for optimization.

Agricultural Advisory Diagnostics Using a Data-Based Approach: Test Case in an Intensively Managed Rural Landscape in the Ganga River Basin, India

Low technology adoption through agricultural extension may be a consequence of providing generic information without sufficient adaptation to local conditions. Data-rich paradigms may be disruptive to extension services and can potentially change farmer-advisor interactions. This study fills a gap in pre-existing, generic advisory programs by suggesting an approach to “diagnose” farm-specific agricultural issues quantitatively first in order to facilitate advisors in developing farm-centric advisories. A user-friendly Farm Agricultural Diagnostics (FAD) tool is developed in Microsoft Excel VBA that uses farmer surveys and soil testing to quantify current agricultural performance, classify farms into different performance categories relative to a localized performance target, and visualize farm performance within a user-friendly interface. The advisory diagnostics approach is tested in Kanpur, representative of an intensively managed rural landscape in the Ganga river basin in India. The developed open-source tool is made available online to generate data-based agricultural advisories. During the field testing in Kanpur, the tool identifies 24% farms as nutrient-limited, 34% farms as water-limited, 27% farms with nutrient and water co-limitations, and the remaining farms as satisfactory compared to the localized performance target. It is recommended to design advisories in terms of water and nutrient recommendations which can fulfill the farm needs identified by the tool. The tool will add data-based value to pre-existing demand based advisory services in agricultural extension programs. The primary users of the tools are academic, governmental and non-governmental agencies working in the agricultural sector, whose rigorous scientific research, soil testing capacity, and direct stakeholder engagement, respectively, can be harnessed to generate more data-based and customized advisories, potentially improving farmer uptake of agricultural advisories.

Impact of the Digital Transformation of Small‐ and Medium‐Sized Listed Companies on Performance: Based on a Cost‐Benefit Analysis Framework

The ultimate goals of digital transformation, which is the only means of realizing the sustainable development of current enterprises, are to achieve cost reduction, efficiency improvement, and innovation for enterprises. However, there are limited empirical quantitative studies on the investment costs and impact of organizational performance related to the digital transformation of small‐ and medium‐sized listed companies. This study first uses Excel VBA to sort the digital transformation panel data of 319 small‐ and medium‐sized listed companies in China’s Shanghai and Shenzhen A‐share markets from 2007 to 2020. Thereafter, Stata, a general‐purpose statistical software package, is used to analyze the impact of digital transformation on the performance of small‐ and medium‐sized listed companies. The results show that the digital transformation of small‐ and medium‐sized listed companies has a positive correlation with operational performance, and an inverted U‐shaped relationship with innovation performance; however, the U‐shaped relationship with financial performance is not significant. For small‐ and medium‐sized listed companies to promote digital transformation, first, it must help the organization to improve its internal operational efficiency; second, it can optimize and improve the organization’s financial efficiency; and finally, through innovative efficiency, the organization can continue to develop steadily and improve its organizational resilience.

Estimation of e-NRTL binary interaction parameters and its impact on the prediction of thermodynamic properties of multicomponent electrolyte systems

The main objective of the current work is to obtain and validate the binary interaction parameters of the e-NRTL model for different salts in water, using the data of mean ionic activity coefficients vs. molality compiled by Robinson and Stokes (Electrolyte Solutions, Dover Publications, 2012). This way, the interaction parameters τsalt,water and τwater,salt of the e-NRTL thermodynamic model for 171 binary (salt + water) electrolyte systems have been calculated by non-linear regression of the data available in the literature. The fitting was performed by the Marquardt-Levenberg algorithm which was computationally implemented in an Excel VBA homemade program. The e-NRTL equation was solved by using two different procedures: (i) included in the Excel VBA code or, (ii) implemented in Aspen Plus by linking the process simulator and the Excel VBA code via automation as the third-party software. The interaction parameters obtained by both approaches were able to adequately fit the experimental results. They were successfully validated by the thermodynamic prediction of multicomponent systems reported by other authors. Additionally, the current predictions were compared with those obtained with the parameters contained in the Aspen Properties database showing a significant improvement for several systems. Finally, this work demonstrates that it is possible enhancing the quality of the prediction of multicomponent systems with proper values of the binary electrolyte interaction parameters, without considering electrolyte-electrolyte interactions foreseen in the original e-NRTL model, which makes possible the simulation of processes containing a variety of chemical species regardless their nature.

Tool Evaluation & Design Analysis for Parking Pawl Mechanism

Abstract: Automatic Transmissions in vehicles are becoming the norm today and with the need to reduce fuel consumption, electric vehicles are increasing in number too. As the vehicles get smarter, transmissions have also felt the need to adapt so as to cope with the demands of the 21st century. Apart from providing the user with different driving modes, vehicles with an Automatic Transmission and electric vehicles have a device called a Park Lock. Park Lock Mechanisms are devices that are fitted to vehicles with an automatic transmission or electric vehicles which can secure the vehicle mechanically in addition to the parking brakes to prevent an unintended movement of the vehicle when the vehicle is brought to a stop. This system can face various kinds of loads coming from the transmission or from the wheel side. So, it is necessary to design a system which can withstand against it. Today, when a park lock mechanism is designed, it is designed in a way that it not only fits one vehicle variant but many variants (these variants can include either front wheel drive, rear wheel drive, vehicles with varying final gear to park lock gear ratios etc). Therefore, one Park Lock Mechanism needs to satisfy various conditions and requirements. Carrying out calculations with different notations for each variant becomes a cumbersome procedure, therefore it is prudent to have one common platform which can do the calculation in the early phases of design. In this paper, a closed form calculationsbased Excel VBA tool can able to estimate the loads coming on to the Park lock mechanism by doing some background calculation is presented followed by the simulation performed using Multi Body Dynamics software (‘ADAMS’). Results from MBD tool and a 1D tool are corelated to the test data to gain some confidence on the tool which created in Excel VBA. Keywords: Park Lock Mechanism, ADAMS, 1D Tool, Excel VBA, Drop in Speed, Torque Build up.

Practice of Visual Solution of Boundary Value Problems by Running VBA in Microsoft Excel

The article discusses the construction of a visual solution of boundary value problems for a linear differential equation of the second order by the tridiagonal sweep method in VBA in Excel. Creating macros in VBA allows you to visualize solutions to such boundary value problems.

Calibration of MEPDG permanent deformation models using Hamburg Wheel Rut Tester and field data

ABSTRACT This paper presents a new approach for calibration of Mechanistic-Empirical Pavement Design Guide (MEPDG) permanent deformation models using the Hamburg Wheel Rut Tester (HWRT) Data. The approach was applied on two Ontario mixes tested in HWRT to calibrate and validate the asphalt concrete (AC) rut models. Data from one Long-Term Pavement Performance (LTPP) programme test section in Ontario were also used for verification, calibration and validation of the AC and unbound pavement layer rut models. The section had two construction (CN) life spans, one before milling and overlay (CN1) and one after (CN2). The study used two finite element models and an Excel VBA sheet to run the verification, calibration and validation of the MEPDG rut models. Proposed calibration coefficients resulted in significant reduction in bias, sum of squared errors (SSE) and standard error of estimate (SEE) for rutting by at least 91% for the two HWRT mixes and by at least 67% for CN1 and CN2, when compared with the global and Ontario local calibration coefficients. The results support the conclusion that the approach of using laboratory wheel tracking device data for calibrating the MEPDG rut models is promising.

Excel VBA programming with Excel to compute the load tranceverse distribution coefficient of G-M method

In this paper, by analyzing the calculation principles of load transverse distribution coefficient of G-M method, using office software Excel, the calculation model of a universal worksheet is given, making the computation of load transverse distribution coefficient with G_M method more accurate and swift. The model is very practical, and can offer reference for bridge and highway designers.

A Site-Scale Tool for Performance-Based Design of Stormwater Best Management Practices

The objective of this research is to develop a module for the design of best management practices based on percent pollutant removal. The module is a part of the site-scale integrated decision support tool (i-DSTss) that was developed for stormwater management. The current i-DSTss tool allows for the design of best management practices based on flow reduction. The new water quality module extends the capability of the i-DSTss tool by adding new procedures for the design of best management practices based on treatment performance. The water quality module can be used to assess the treatment of colloid/total suspended solid and dissolved pollutants. We classify best management practices into storage-based (e.g., pond) and infiltration-based (e.g., bioretention and permeable pavement) practices for design purposes. Several of the more complex stormwater tools require expertise to build and operate. The i-DSTss and its component modules including the newly added water quality module are built on an accessible platform (Microsoft Excel VBA) and can be operated with a minimum skillset. Predictions from the water quality module were compared with observed data, and the goodness-of-fit was evaluated. For percent total suspended solid removal, both R2 and Nash–Sutcliffe efficiency values were greater than 0.7 and 0.6 for infiltration-based and storage-based best management practices, respectively, demonstrating a good fit for both types of best management practices. For percent total phosphorous and Escherichia. coli removal, R2 and Nash–Sutcliffe efficiency values demonstrated an acceptable fit. To enhance usability of the tool by a broad range of users, the tool is designed to be flexible allowing user interaction through a graphical user interface.

Primary School Students’ Learning Toward The Use of VBA For Excel Based Games In Learning Number

Tujuan penelitian ini adalah untuk mendeskripsikan motivasi belajar siswa SD Negeri di Cianjur dimana siswa Sekolah Dasar mengalami kesulitan proses dalam operasi hitung bilangan bulat, disebabkan kurangnya penguasaan kemampuan pemahaman siswa tentang dasar-dasar konsep bilangan bulat dan operasi bilangan bulat sehingga siswa mampu mengembangkan aplikasi matematika. Metode penelitian yang digunakan adalah metode kualitatif deskriptif. Subjek penelitian yang dilakukan yaitu pada 25 siswa SD Negeri di Cianjur kelas VI. Instrumen yang diberikan berupa angket skala motivasi belajar siswa yang terdiri dari 20 pernyataan dan 4 pilihan jawaban. Angket motivasi belajar yang berhubungan dengan media ICT berbasis VBA for Excel terdiri dari 4 indikator. Hasil penelitian menunjukan bahwa motivasi belajar siswa SD Negeri di Cianjur dengan menggunakan media ICT berbantuan VBA for Excel pada materi garis bilangan secara keseluruhan tergolong sangat baik dan terdapat 3 indikator yang masuk kriteria baik sekali yaitu untuk indikator Percaya diri dalam menggunakan matematika (sangat baik), indikator Flekibel dalam melakukan kerja matematika (sangat baik); indikator Kerelaan meninggalkan kewajiban atau tugas lain, (sangat baik). Terdapat 1 indikator yang masuk kriteria baik yaitu indikator Ketekunan dalam mengerjakan matematika (baik).

Methods for plotting function graphs in computers using modern software and programming languages

The article discusses methodological issues and implementation features in MS Office software environments (in particular, MS EXCEL VBA) and Borland Delphi (Pascal) of the algorithm for plotting graphs offunctions studied in the course of mathematics. The programs presented in the article, which perform graphing with given coefficients, can be used as a visual aid for users, applicants, etc. in the study of functions, as well as as a demo example in the study of the programming environment MS Office and Borland Delphi (Pascal)

An Excel VBA‐based educational module for bed roughness predictors

AbstractEstimation of flow resistance coefficients plays an inevitable role in open‐channel flows in hydraulic modeling and water resources engineering. Despite many equations and methods recommended for estimating roughness coefficients, only two standard resistance equations (original Manning's and Keulegan's equations) have been widely taught and utilized in practice. There can be various reasons for not using new bed roughness predictors (BRPs), one of which is the absence of teaching BRPs. A rigorous analysis of available BRPs for estimating grain and form roughness coefficients delineates that most of them are comprised of a scheme rather than a single equation. Also, each BRP is tailored to solve a distinct type of problem; however, a proper definition of a problem statement helps shedding light on this application. This study presents an Excel VBA‐based educational estimator to address the gap. For this purpose, the problem statement is first revisited to accomplish a better understanding in light of proper problem classification. On the basis of different groups of input and output data, each BRP is implemented into an Excel spreadsheet and VBA codes are presented for BRPs incorporating both grain and form roughness. This computer application can help students in open‐channel engineering courses not only to become familiar with modified BRPs but also to acknowledge the merit of the Excel spreadsheet for estimating flow resistance coefficients. Finally, as the VBA codes are presented in detail, they can be modified by users in accordance with their priorities for both educational and practical purposes.

Using VBA for microsoft excel based on 6-questions cognitive theory in teaching fraction

Learning media is a tool that is used to make the teaching and learning process easier. In this modern era, most of the students complained that mathematics is hard and boring. Other than that, the traditional teaching method makes students less practical and not mastering the concept taught, which is why there is a need of a learning media innovation using Information and Communication Technology (ICT). Learning fraction in primary school can be helped using VBA for Microsoft excel in supporting the fraction subchapter so that it will be more interesting and easier to understand. The purpose of this research is to develop a VBA for Microsoft excel on fraction, which then is evaluated on their validity and practicality as a learning media. The design of this research is using the experimental design with pre-test and post-test to compare the students’ understanding ability on fraction between the class that uses VBA for Microsoft excel and the traditional teaching method. The result of this research shows that the learning media, we can conclude that VBA for Microsoft excel based on the 6-questions cognitive theory can improve the students’ understanding ability significantly.

Microsoft Excel VBA on mathematical resilience of primary school teacher education students

This research is motivated by the low student mathematical resilience. The purpose of this study is to look at the achievement of mathematical resilience of students who obtain learning using Microsoft Excel VBA with those using conventional learning. This study uses a quasi-experimental method with a non-equivalent pretest and posttest control group design. The subjects of this study were 70 second semester elementary school teacher candidates at IKIP Siliwangi. The instruments in this study used non-tests in the form of questionnaires and interviews. The results show that, 1) the achievement of mathematical resilience of students who get learning using Microsoft Excel VBA is better than those using conventional learning; 2) students who learn with Microsoft Excel VBA tend to be able to overcome difficulties if given difficult math problems, anxiety and fear in working on math problems are reduced, and more confident in expressing mathematical opinions/ideas; 3) mathematical resilience is not an instant thing to change so it needs environmental support so that students’ mathematical resilience becomes better.

Regional Trial Data Bulk Extraction and Aggregation Software Based on Excel VBA: Development and Application

Regional Trial Data Bulk Extraction and Aggregation Software Based on Excel VBA: Development and Application

The Effect of VBA for Microsoft Excel as Teaching Material to Improve Prospective Elementary School Teachers' Mathematical Conceptual Understanding

This research is motivated by the low ability to understand mathematical concepts possessed by prospective elementary school teacher students. This study aims to see the achievement and improvement of students' mathematical understanding abilities that use Microsoft Excel-based VBA teaching materials with those using conventional learning. This study uses a quasi-experimental method with a non-equivalent pre-test and post-test control group design. This study's population were all second-semester elementary school teacher candidates in one private university in West Java, Indonesia. The sample in this study was 70 prospective 2nd-grade elementary school teacher candidates. The instrument used in this study was a test of understanding mathematical concepts. The results showed: 1) learning using VBA Microsoft Excel as a teaching material was able to improve students' ability to understand mathematical concepts; 2) learning using Microsoft Excel VBA as teaching material is better than conventional learning; and 3) students can be enthusiastic, active and motivated in learning mathematics with VBA Microsoft Excel.

Dynamic progressive collapse of steel moment frames under different fire scenarios

Dynamic mechanisms for progressive collapse of steel moment-resisting frames are studied under different durations of a column removal due to different fire scenarios. Development process of natural fire and gas temperature are modeled and predicted by software fire dynamics simulator (FDS). The steel temperature is then predicted reliably using the method recommended by EN19993–1-2 incorporating the predicted gas temperature by FDS. Steel frames and columns exposed to fire are simulated by BEAM188 in ANSYS with APDL and then validated against experimental data obtained from other researchers. It can be found that the failure duration of a column is different under standard and natural fire conditions, similarly under different boundary conditions, namely, axial load, initial imperfection, axial restraint stiffness ratio and rotational restraint stiffness. Finally, a step-by-step analysis procedure is established using SAP2000 API with Excel VBA to determine structural response versus duration of a column failure. The decay trend of maximum displacement can be described quantitatively by a one-phase exponential decay function, which is drawn after extensive analysis of dynamic response for different structures with various spans, member sections, loads, levels of a building and total number of floors

A steepest descent algorithm for the optimal control of a cascaded hydropower system

Optimal power generation along the cascaded Kainji-Jebba hydroelectric power system had been very difficult to achieve. The reservoirs operating heads are being affected by possible variation in impoundments upstream, stochastic factors that are weather-related, availability of the turbo-alternators and power generated at any time. Proposed in this paper, is an algorithm for solving the optimal release of water on the cascaded hydropower system based on steepest descent method. The uniqueness of this work is the conversion of the infinite dimensional control problem to a finite one, the introduction of clever techniques for choosing the steepest descent step size in each iteration and the nonlinear penalty embedded in the procedure. The control algorithm was implemented in an Excel VBA® environment to solve the ormulated Lagrange problem within an accuracy of 0.03%. It is recommended for use in system studies and control design for the optimal power generation in the cascaded hydropower system.

Determination of the Hansen solubility parameters and the Hansen sphere radius with the aid of the solver add-in of Microsoft Excel

This paper describes the use Excel’s Solver of Microsoft and desirability function for the determination of Hansen’s solubility parameters (HSPs). The Excel’s solver is powerful while at the same time being user-friendly and easy to comprehend. Results of HSPs for different polymers and oils were evaluated and compared with the results obtained by the use of other tools; no significant differences were found between the Microsoft Excel solution and either the professional program HSPiP or other software platform used by different authors. Improvements introduced in the Excel book developed by Steven Abbott for this purpose, by the inclusion of some restrictions and functions, allow simultaneously optimizing the diameter of the Hansen sphere together with the determination of Hansen’s parameters, so that a tool, available to professional and researcher, can be used for these determinations with a high degree of precision, using any of the nonlinear optimization algorithms available in the Solver add-in. Finally, it is illustrated how the use of programming in Excel VBA can lead to a friendly interface for these determinations.