scholarly journals Hydropower Computation Using Visual Basic for Application Programming

2012 ◽  
Vol 24 ◽  
pp. 37-43
Author(s):  
Wang Yan ◽  
Hu Hongliang
Keyword(s):  
Visual Basic ◽  
Application Programming ◽  
Visual Basic For Application

scholarly journals Design of evaluation tool used to improve the production process

2019 ◽  
Vol 9 (1) ◽  
pp. 641-649
Author(s):  
Hlatká Martina ◽  
Korec Karel ◽  
Kampf Rudolf
Keyword(s):  
Production Process ◽  
Visual Basic ◽  
Process Capability Indices ◽  
Evaluation Tool ◽  
Statistical Parameters ◽  
Important Data ◽  
Statistical Process ◽  
Capability Indices ◽  
Application Programming ◽  
Visual Basic For Application

AbstractThis paper is devoted to the use of statistical methods to ensure the highest quality processes. Specifically, it deals with creating an application in MS Excel which evaluates standard statistical parameters and if the required process capability indices are complied with, then it is possible to proceed to SPC (statistical process control). The application was created in MS Excel using the Visual Basic for Application programming language. In addition to the required calculations, the application also generates forms with all important data. This application was designed to reduce reject rate and improve the production process in a contracting company.

scholarly journals Appennino: A GIS Tool for Analyzing Wildlife Habitat Use

2012 ◽  
Vol 2012 ◽  
pp. 1-5 ◽  
Author(s):  
Marco Ferretti ◽  
Marco Foi ◽  
Gisella Paci ◽  
Walter Tosi ◽  
Marco Bagliacca
Keyword(s):  
Habitat Use ◽  
Programming Language ◽  
Compositional Analysis ◽  
Visual Basic ◽  
Wildlife Habitat ◽  
Considerable Reduction ◽  
Land Uses ◽  
Statistical Software ◽  
Application Programming ◽  
Visual Basic For Application

The aim of the study was to test Appennino, a tool used to evaluate the habitats of animals through compositional analysis. This free tool calculates an animal’s habitat use within the GIS platform for ArcGIS and saves and exports the results of the comparative land uses to other statistical software. Visual Basic for Application programming language was employed to prepare the ESRI ArcGIS 9.x utility. The tool was tested on a dataset of 546 pheasant positions obtained from a study carried out in Tuscany (Italy). The tool automatically gave the same results as the results obtained by calculating the surfaces in ESRI ArcGIS, exporting the data from the ArcGIS, then using a commercial spreadsheet and/or statistical software to calculate the animal’s habitat use with a considerable reduction in time.

Implementation of CTR Dairy Model Using the Visual Basic for Application Language of Microsoft Excel

2018 ◽  
Vol 9 (3) ◽  
pp. 74-86 ◽  
Author(s):  
A. Ahmadi ◽  
P. H. Robinson ◽  
F. Elizondo ◽  
P. Chilibroste
Keyword(s):  
Visual Basic ◽  
Simulation Software ◽  
Access Time ◽  
Dairy Farmers ◽  
Microsoft Excel ◽  
Smart Client ◽  
Dynamic Simulation Model ◽  
Dairy Nutrition ◽  
Ruminal Digestion ◽  
Visual Basic For Application

The goal of the article is to implement the CTR Dairy model using the Visual Basic for Application (VBA) language of Microsoft Excel. CTR Dairy is a dynamic simulation model for grazing lactating dairy cows that predicts milk production and profit over feeding based on ruminal digestion and absorption of nutrients under discontinuous feeding schedules. The CTR Dairy model was originally developed as a research tool using a proprietary computer simulation software called SMART that required the SMART client to run the program. As SMART software is now discontinued, and its client is no longer available, rewriting the model in the VBA language using Microsoft Excel for inputs and outputs makes the program available to a broad range of users including dairy farmers, extension advisors, dairy nutrition consultants and researchers. Dairy farmers can use the new version of the CTR Dairy program to manipulate the herbage allowance and the access time to the grazing paddock, as well as the timing of supplemental feeding, to improve the utilization of the pasture and to increase the production of the milk.

scholarly journals Multimedia Development Using Visual Basic for Application (VBA) to Improve Students’ Learning Motivation in Studying Mathematics of Economics

2019 ◽  
Vol 2 (1) ◽  
pp. 34
Author(s):  
Siti Nurul Hasana ◽  
Alifiani Alifiani
Keyword(s):  
Mathematics Education ◽  
Visual Basic ◽  
Learning Motivation ◽  
Mathematical Concepts ◽  
Study Program ◽  
Mathematical Application ◽  
Multimedia Development ◽  
Education Study ◽  
Qualitative Descriptive ◽  
Visual Basic For Application

For Mathematics Education Study Program, Mathematics of Economics is a subject where Mathematics is applied in Economics. In this course, mathematical concepts and theories which have been studied in the previous semesters have to be applied in Economics that is new for the students. For this kind of subject, the lecturer has to be more creative in the class so that the lesson will be more interesting and understandable. The aim of this research is to know the improvement of learning motivation in Mathematics of Economics through the use of multimedia development using Visual Basic for Application (VBA) in the class. This multimedia is presented in the form of a game in Microsoft PowerPoint (PPt) program. Respondents of this study were 34 students of class A in the fourth semester of Mathematics Education study program of Teacher Training and Education Faculty at Universitas Islam Malang who were taking this course. This study uses a qualitative descriptive approach with data collection techniques using observation and interview techniques. The observation sheet and the interview guidelines used here are arranged based on indicators measuring learning motivation. The result shows that the use of multimedia development with VBA can improve the students’ learning motivation to study Mathematics of Economics. The recalling of mathematical concepts and theories which have been studied before can be more interesting in the form of a game, while the new Economics concepts and theories with the mathematical application inside can be understood easily in the form of competition that enhances the motivation.

scholarly journals Egymintás t-próba programozható kialakítása Excel VBA környezetben

2018 ◽  
Vol 13 (3-4) ◽  
pp. 169-175
Author(s):  
György Hampel
Keyword(s):  
Visual Basic ◽  
Visual Basic For Application

Az Excel számolótáblák egyszerűen használható lehetőséget biztosítanak számítások elvégzésére, s mindezt úgy, hogy adatváltozás esetén automatikus újraszámítás történik. Ezt kihasználva elegendő csak egyszer kialakítani a számolótáblát, melyet így újból felhasználhatunk más bemenő adatok esetén. A Visual Basic for Application (VBA) szolgáltatással minimális programozói ismeret birtokában a bemenő adatok cseréjét programozottan is elvégezhetjük. Egymintás t-próba többszöri végrehajtását automatizálni tudjuk. Statisztikai számításokat biztosító programok használata során az újabb kiértékeléseket csak manuálisan tudjuk kezdeményezni. Nagy előnyt biztosít számunkra az Excel VBA ismétlődő kiértékelések során. Bemutatásra kerül a számítások automatizált elvégzéséhez szükséges felhasználóbarát kezelőfelület kialakítása ez Excel táblázatkezelő program segítségével.

scholarly journals Interação algorítmica entre os softwares AutoCAD e excel aplicados ao detalhamento de sapatas isoladas através do VBA

2019 ◽  
Vol 6 (2) ◽  
pp. 23-31
Author(s):  
Arthur Gonçalves Ferreira Partata ◽  
Douglas Freitas Augusto dos Santos
Keyword(s):  
Visual Basic ◽  
Microsoft Excel ◽  
Microsoft Office ◽  
Visual Basic For Application

Na engenharia civil, fundação é aquele elemento que recebe o peso da estrutura e tem a função de distribuir de forma uniforme através da sua base ao solo. As fundações são dividias em dois grupos: rasas e profundas. É a primeira parte a ser construída e que faz contato direto com o solo. São utilizadas como base para as construções e de diferentes tamanhos, sendo construídas na maioria das vezes em concreto armado e próximas ao nível da superfície do terreno. Na atualidade os programas computacionais estão ligados diretamente ao dia-a-dia dos engenheiros civil, fazendo com que facilite o seu trabalho. Este trabalho pretende fazer o desenvolvimento de software atrelado ao MS Excel para dimensionamento de fundação sapata isolada através do visual Basic for Application VBA. O VBA é uma ferramenta que veio do VB (Visual Basic) linguagem esta que tem por base a linguagem BASIC, que é uma linguagem de alto nível. VBA foi desenvolvido para estar presente em aplicações do Microsoft Office, como: Excel, PowerPoint, Word entre outras. O programa tem como o objetivo fazer o dimensionamento de uma sapata isolada e por fim fazer o detalhamento das armaduras, de modo que os projetistas possam trabalhar com rapidez e eficiência. O programa pode ser usado também não só na criação de projetos de fundações como também na edição de projetos em execução, tornando os projetos mais competitivos, pelo fato de ser necessários apenas dois programas: AutoCAD da Autodesk e Microsoft Excel, duas ferramentas de muita importância no cotidiano do engenheiro civil. 

scholarly journals Penerapan Visual Basic for Application (VBA) Sebagai Alat Bantu Ajar Enkripsi dan Dekripsi DES

2011 ◽  
Vol 2 (1) ◽  
pp. 555
Author(s):  
Yasri Yasri
Keyword(s):  
Visual Basic ◽  
High Accuracy ◽  
Teaching Model ◽  
Long Time ◽  
Encryption Decryption ◽  
The Given ◽  
Visual Basic For Application ◽  
Very High

The DES encryption/decryption algorithm is quite a popular algorithm due to ease in learning. Calculations for DES using binary numbers however are very difficult, including 16 rounds required for a full encode. Teaching DES encryption manually is difficult since it requires a long time. It also requires high accuracy for the 64-bit binary numbers, the possibility of mistakes are very high. Besides, the students cannot perform self-check, whether the given task is done correctly. Application of Excel and VBA is used to facilitate observation, comparison, and understanding the DES algorithm. The result is a teaching model using DES for modern encryption. 

Sign in / Sign up

Export Citation Format

Share Document