Log in

Relevant bibliographies by topics / Visual Basic for Applications (VBA) / Journal articles

To see the other types of publications on this topic, follow the link: Visual Basic for Applications (VBA).

Journal articles on the topic 'Visual Basic for Applications (VBA)'

Author: Grafiati

Published: 4 June 2021

Last updated: 25 July 2025

Create a spot-on reference in APA, MLA, Chicago, Harvard, and other styles

Select a source type:

Consult the top 50 journal articles for your research on the topic 'Visual Basic for Applications (VBA).'

Next to every source in the list of references, there is an 'Add to bibliography' button. Press on it, and we will generate automatically the bibliographic reference to the chosen work in the citation style you need: APA, MLA, Harvard, Chicago, Vancouver, etc.

You can also download the full text of the academic publication as pdf and read online its abstract whenever available in the metadata.

Browse journal articles on a wide variety of disciplines and organise your bibliography correctly.

1

Suwanda, Totok, Fitroh Anugrah Kusuma Yudha, and Imam Crespo Padilah. "Pembuatan Dan Pelatihan Sistem Pengelolaan Nilai Menggunakan Microsoft Excel Berbasis Visual Basic for Applications." Jurnal Pengabdian Pada Masyarakat 8, no. 4 (2023): 983–89. http://dx.doi.org/10.30653/jppm.v8i4.541.

Full text

Abstract:

Tujuan pengabdian ini adalah untuk memfasilitasi pelaksanaan program pelatihan sistem manajemen nilai dalam lembaga pendidikan. Program pelatihan ini memanfaatkan Microsoft Excel, khususnya melalui pemanfaatan Visual Basic for Applications (VBA). Proses pengembangan sistem meliputi identifikasi kebutuhan mitra, perumusan desain sistem, implementasi VBA di Microsoft Excel, serta tahap pengujian dan evaluasi sistem selanjutnya. Selain itu, diadakan pula pelatihan bagi operator SDN 1 Kembangsari untuk memberikan pengarahan tentang pemanfaatan sistem tersebut. Pengabdian ini menunjukkan bahwa pema

APA, Harvard, Vancouver, ISO, and other styles

2

İnanç, Şahin, Onur Mesut Şenaras, Arzu Eren Şenaras, and Burcu Öngen Bilir. "Monte Carlo Simulation Via Visual Basic Application." Revista de Gestão Social e Ambiental 18, no. 10 (2024): e09063. http://dx.doi.org/10.24857/rgsa.v18n10-278.

Full text

Abstract:

Objective: The objective of this study is to implement the Monte Carlo Simulation method using Microsoft Excel's Visual Basic for Applications (VBA). This approach enables users to simulate complex systems easily and obtain statistical outputs for decision-making. Theoretical Framework: Implementing the results of the changes we desire on a real-life system through trial and error can lead to costly and risky outcomes. Simulation allows us to develop a computer model of an existing system, enabling us to understand the system's behavior. Method: Monte Carlo Simulation, a widely used simulation

APA, Harvard, Vancouver, ISO, and other styles

3

İnanç, Şahin. "Using Visual Basic for Applications to Implement Markov Analysis in Market Share Forecasting." Revista de Gestão Social e Ambiental 18, no. 11 (2024): e09269. http://dx.doi.org/10.24857/rgsa.v18n11-068.

Full text

Abstract:

Objective: This paper is an examination of the use of Markov analysis in market share prediction, and the use of Visual Basic for Applications (VBA) to increase the speed and precision of the computation and model. Theoretical Framework: The Markov analysis, used to predict future states from current transitions, sheds light on the consumer behavior and brand loyalty dynamics With VBA, the data processing can be automated, and transition matrices built that are dynamic, so that forecasts can be updated in real time. Method: Markov analysis is based on transition matrices, which define the prob

APA, Harvard, Vancouver, ISO, and other styles

4

Rodliyah, Iesyah, and Sari Saraswati. "PENGEMBANGAN SOAL STATISTIKA BERBASIS MICROSOFT POWER POINT VISUAL BASIC FOR APPLICATION (VBA)." Tunjuk Ajar: Jurnal Penelitian Ilmu Pendidikan 4, no. 2 (2021): 200. http://dx.doi.org/10.31258/jta.v4i2.200-217.

Full text

Abstract:

The purpose of this study is to describe the results of the development of statistical questions presented by utilizing Microsoft Power Point applications based on Visual Basic for Applications. The development model in this study uses the ADDIE model which stands for analysis, design, development, implementation, and evaluation. This research trial used several subjects including two validators, namely material experts and media experts, as well as mathematics education students who took statistics courses. Data collection techniques were carried out through test and questionnaire methods. Wh

APA, Harvard, Vancouver, ISO, and other styles

5

K., Keerthana, Bhuvaneswari B., and Vigneshwaran S. "Future Scope in Application Developement of Visual Basic." International Journal of Trend in Scientific Research and Development 3, no. 6 (2019): 641–45. https://doi.org/10.5281/zenodo.3588807.

Full text

Abstract:

Visual Basic for Applications is a computer programming language developed and owned by Microsoft. With VBA you can create macros to automate repetitive word and data processing functions .Applications are created with the help of Visual Basic and it is inbuilt with phone, memory devices and upcoming Artificial IntelligenceProgrammers can create both simple and complex graphical user interface applications. Programming in visual basic is a combination of visually arranging components or control some aform, specifying attributes and actions for that component. BASIC means Beginners All purpose

APA, Harvard, Vancouver, ISO, and other styles

6

Syamsuddin, I., and S. Syafaruddin. "Modeling arithmetic systems of elliptic curve cryptography using Microsoft Excel VBA." Naukovyi Visnyk Natsionalnoho Hirnychoho Universytetu, no. 1 (February 29, 2024): 162–66. http://dx.doi.org/10.33271/nvngu/2024-1/162.

Full text

Abstract:

Purpose. This study aims to develop a new teaching module to illustrate the arithmetic systems of Elliptic Curve Cryptography, a powerful yet simple algorithm for information security, by exploring the capability of the Visual Basic Applications of Microsoft Excel in user friendly way. Methodology. The research is performed using research and development approach, which is divided into five steps utilizing VBA features of Microsoft Excel. It starts with modeling arithmetic in Microsoft Excel spreadsheet, then testing the validity through calculation and setup of the actual arithmetic of Ellipt

APA, Harvard, Vancouver, ISO, and other styles

7

Perry, George L. W. "SpPack: spatial point pattern analysis in Excel using Visual Basic for Applications (VBA)." Environmental Modelling & Software 19, no. 6 (2004): 559–69. http://dx.doi.org/10.1016/j.envsoft.2003.07.004.

Full text

APA, Harvard, Vancouver, ISO, and other styles

8

Romanchenko, Tatyana Nikolaevna. "Creating an electronic textbook in EXCEL using the VBA programming language." Программные системы и вычислительные методы, no. 1 (January 2020): 18–30. http://dx.doi.org/10.7256/2454-0714.2020.1.32244.

Full text

Abstract:

The author gives the presentation of the content and structural components of an electronic textbook using Excel and the programming language Visual Basic for Applications using an example of a textbook fragment. The methods of presenting theoretical material, modeling with a visual demonstration, automatic verification of the results of assignments, automatic visual display of the results of mastering the topic using the built-in Excel functions are described in detail. The codes of programs for automatic presentation of individual tasks, automatic data modeling based on built-in Excel functi

APA, Harvard, Vancouver, ISO, and other styles

9

Oktorina, Fenty. "Otomatisasi Pembuatan Dokumen Administrasi Akademik Di Politeknik Kampar." Jurnal Sains dan Ilmu Terapan 4, no. 2 (2021): 20–23. http://dx.doi.org/10.59061/jsit.v4i2.25.

Full text

Abstract:

Bagian Administrasi Akademik (BAA-Departemen Administrasi Akademik) menghasilkan banyak dokumen setiap hari. Membuat dokumen dengan cara yang salah akan menghasilkan dokumen yang tidak valid. Selama ini, dokumen dibuat dengan cara yang tidak efektif. Akibatnya dokumen tidak memberikan informasi yang akurat. Selain itu, dokumen belum terstandarisasi, membuat formulir untuk dokumen yang sama. Oleh karena itu, perlu untuk menyediakan aplikasi yang dapat mengotomatisasi pembuatan dokumen dan arsip yang dapat dikelola dengan baik. Dengan menggunakan Visual Basic For Applications (VBA) di Microsoft

APA, Harvard, Vancouver, ISO, and other styles

10

Alam, Marzia, Mehreen Saleem Gul, and Tariq Muneer. "Radiation View Factor for Building Applications: Comparison of Computation Environments." Energies 12, no. 20 (2019): 3826. http://dx.doi.org/10.3390/en12203826.

Full text

Abstract:

Computation of view factors is required in several building engineering applications where radiative exchange takes place between surfaces such as ground and vertical walls or ground and sloping thermal or photovoltaics collectors. In this paper, view factor computations are performed for bifacial solar photovoltaic (PV) collectors based on the finite element method (FEM) using two programming languages known as Microsoft Excel-Visual Basic for Applications (VBA) and Python. The aim is to determine the computer response time as well as the performance of the two languages in terms of accuracy

APA, Harvard, Vancouver, ISO, and other styles

11

Effendy, Ibrahim Rully, and Yustin Ari Prihandini. "PENGEMBANGAN MANAJEMEN MENU GIZI DIET KESEHATAN BERBASIS VBA (VISUAL BASIC FOR APPLICATIONS) MACRO EXCEL." Jurnal Dunia Kesmas 13, no. 2 (2024): 130–36. http://dx.doi.org/10.33024/jdk.v13i2.16408.

Full text

Abstract:

Public health has become a primary concern in the era of globalization and modernization. However, food consumption surveys in Indonesia indicate low consumption of fatty foods and fruits. Therefore, it is crucial to maintain a balanced diet. Despite offering healthy menus, GoodMeal Catering still relies on manual calculations. This research aims to integrate Visual Basic for Applications (VBA) into Microsoft Excel for designing daily diet menus. This method can assist individuals in planning menus that align with their nutritional needs. Data from the Indonesian Food Composition Table (TKPI)

APA, Harvard, Vancouver, ISO, and other styles

12

Kalwar, Muhammad Ahmed, Muhammad Faisal Shahzad, Muzamil Hussain Wadho, Muhammad Ali Khan, and Shakeel Ahmed Shaikh. "Automation of order costing analysis by using Visual Basic for applications in Microsoft Excel." Journal of Applied Research in Technology & Engineering 3, no. 1 (2022): 29–59. http://dx.doi.org/10.4995/jarte.2022.16390.

Full text

Abstract:

In the modern world of technologies (sciences of arts), optimum operation time is the prime consideration. Technologies with greater operation time are needed to be modified or replaced as per the requirement of the current scenario. In small and medium enterprises of developing countries, almost all the reporting activities are conducted in Microsoft Excel. The manual operation in Microsoft Excel takes a long time (17.37 minutes, only if there was one order of only one article with one color) of the users; furthermore, there can also be a greater chance of error in the report. In the same way

APA, Harvard, Vancouver, ISO, and other styles

13

Pechter, David S. "Controlling a Twister II with VBA and the Zymark ZyRobot ICP." JALA: Journal of the Association for Laboratory Automation 7, no. 6 (2002): 92–95. http://dx.doi.org/10.1016/s1535-5535-04-00227-8.

Full text

Abstract:

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.

APA, Harvard, Vancouver, ISO, and other styles

14

Azwir, Hery Hamdi, and M. Yafi Maulidin. "IMPLEMENTING AN AUTOMATED SYSTEM TO SIMPLIFY THE DATA MANAGEMENT PROCESS AT PARTS STORAGE AREA OF PT. Z." J@ti Undip : Jurnal Teknik Industri 12, no. 2 (2017): 85. http://dx.doi.org/10.14710/jati.12.2.85-94.

Full text

Abstract:

This research concerns about the design and implementation of a new information system which will simplify the processes of the current system and its impact on the warehouse staffs. In order to automate the processes, a programmed information system is designed using Microsoft excel VBA, a basic programming function inside Microsoft excel. First, the current system is analyzed. Next, the user requirements and proposed system requirements are analyzed to make the system design. Then, the program is developed and tested by using VBA (Visual Basic for Applications). Then, the new system is imple

APA, Harvard, Vancouver, ISO, and other styles

15

Cruz, Benjamin Clark Roque, Andréa Lanza Cordeiro De Souza, José Renato Sátiro Santiago, Elton Pereira Texeira, and Gilson De Lima Lira. "Automação Dos Processos Da Gerência de Controle De Pesca (IPAAM): Uma Proposta De Modelo Utilizando A Ferramenta VBA No Microsoft Excel." IOSR Journal of Dental and Medical Sciences 23, no. 11 (2024): 46–54. https://doi.org/10.9790/0853-2311094654.

Full text

Abstract:

Este artigo apresenta uma proposta de automação dos processos administrativos da Gerência de Controle de Pesca (GECP) do Instituto de Proteção Ambiental do Amazonas (IPAAM) utilizando a ferramenta VBA (Visual Basic for Applications) no Microsoft Excel. O objetivo é apresentar a definição de automação o contexto da gestão arquivística e a ferramenta VBA da Microsoft destacando as características da interface interativa do VBA para automação de tarefas no Excel, descrever os processos atuais e identificar os desafios na gestão manual dos dados. A metodologia é caracterizada por uma pesquisa de n

APA, Harvard, Vancouver, ISO, and other styles

16

Fabulya, Zoltán. "Excel VBA függvények kialakítása háromdimenziós vektorok matematikai alkalmazására." Jelenkori Társadalmi és Gazdasági Folyamatok 14, no. 1 (2019): 29–34. http://dx.doi.org/10.14232/jtgf.2019.1.29-34.

Full text

Abstract:

A háromdimenziós vektorokkal végzett műveletek számítógépes támogatottsága nem megfelelő. A sokak által használt Excel táblázatkezelő program sem rendelkezik testreszabott szolgáltatásokkal a vektorműveletekhez. Ezt a hiányosságot az Excel Visual Basic for Applications nyújtotta lehetőségekkel megszüntethetjük. Kialakíthatunk felhasználói függvényeket, melyekkel kiszámíthatjuk a vektorok matematikai alkalmazási területéhez kapcsolódó eredményeket:  Vektor nagysága, abszolút értéke Két vektor által bezárt szög, illetve a szög koszinusza Két vektor skaláris szorzata

APA, Harvard, Vancouver, ISO, and other styles

17

He, Lin, L. M. Sun, Xian Feng Zhao, and Jun Wang. "Effect of Grinding Wheel Diameter Change on Geometrical Parameters of Ball-Nose End Mill." Advanced Materials Research 97-101 (March 2010): 4527–29. http://dx.doi.org/10.4028/www.scientific.net/amr.97-101.4527.

Full text

Abstract:

The grinding simulation system of ball-nose end mill rake face is developed based on the four axis linkage mathematical model using Solidworks and Visual Basic for Applications (VBA). Effects of grinding wheel diameter change due to wear on geometrical parameters of ball-nose end mill, such as ball-nose rake angle, column rake angle and edge strip width are investigated.

APA, Harvard, Vancouver, ISO, and other styles

18

Jia, Wei Hua, and Xiao Hua Li. "The Development of Stamping Mold Frame Based on VBA in Auto CAD." Advanced Materials Research 507 (April 2012): 222–25. http://dx.doi.org/10.4028/www.scientific.net/amr.507.222.

Full text

Abstract:

As re-development tools based on AutoCAD, VBA (Visual Basic for Applications) makes punching die of development, and compared with the traditional mold manufacture method it has a series of advantages like increasing productivity, improving product quality, reducing cost, and reducing labor intensity. This paper mainly introduces in VBA’s development environment to research parameter design through punch mould so as to improve the design efficiency.

APA, Harvard, Vancouver, ISO, and other styles

19

Hampel, György. "Khi-négyzet próba Excel VBA űrlapjának kialakítása." Jelenkori Társadalmi és Gazdasági Folyamatok 17, no. 3-4 (2022): 75–82. http://dx.doi.org/10.14232/jtgf.2022.3-4.75-82.

Full text

Abstract:

Normális eloszlású sokaság szórására vonatkozó hipotézis tesztelésére a khi-négyzet próbát kell alkalmazni. Ennek végrehajtását teszi egyszerűvé és jól áttekinthetővé a Microsoft Excel Visual Basic for Applications szolgáltatásával elkészült alkalmazás, melynek fejlesztése kerül bemutatásra. Egyetlen űrlap biztosítja az adatok megadását, valamint az eredmények megjelenítését az űrlapon elhelyezett vezérlőkkel. A program eseményvezérelt programozási technikával készült el, emiatt felhasználóbarát módon reagál a használat során bekövetkező eseményekre. Matematikai statisztikai ismeretek nélkül i

APA, Harvard, Vancouver, ISO, and other styles

20

Fabulya, Zoltán. "Excel VBA alkalmazás fejlesztése komplex szám gyökeinek kiszámítására." Jelenkori Társadalmi és Gazdasági Folyamatok 17, no. 1-2 (2022): 109–18. http://dx.doi.org/10.14232/jtgf.2022.1-2.109-118.

Full text

Abstract:

Komplex számokkal műveletek végzését már számológépeink is támogatják. Viszont a gyökvonás csak egyetlen eredményt ad, még számítógépes programokkal is, annak ellenére, hogy annyi különböző komplex számot kellene kapnunk, ahányadik gyököt vonunk. Ezért szükséges kifejleszteni az Excel táblázatkezelő program Visual Basic for Applications szolgáltatásával egy gyökvonást elvégző alkalmazást, mely az összes eredményt megjeleníti. A felhasználóbarát kezeléshez egyetlen űrlap biztosítja az adatok megadását és az eredmények megjelenítését különböző vezérlők segítségével. Az alkalmazás lehetőséget ad

APA, Harvard, Vancouver, ISO, and other styles

21

Lenort, Radim, David Staš, Pavel Wicher, and František Zapletal. "Decision Support System for Flame-Cutting Machines Scheduling." Applied Mechanics and Materials 708 (December 2014): 184–89. http://dx.doi.org/10.4028/www.scientific.net/amm.708.184.

Full text

Abstract:

The article presents Decision Support System for time scheduling of work orders in operations producing heavy plate cut shapes. The IPO (Input – Process – Output) diagram was used to design the mental model of the system. The heart of the system is based on Generalized Assignment Problem and Buffer Management. The mental model was programmed in MS Excel by means of Visual Basic for Applications (VBA) macros.

APA, Harvard, Vancouver, ISO, and other styles

22

Fabulya, Zoltán. "Excel VBA függvény kialakítása fontosabb irracionális számok felismerésére." Jelenkori Társadalmi és Gazdasági Folyamatok 16, no. 3-4 (2021): 77–86. http://dx.doi.org/10.14232/jtgf.2021.3-4.77-86.

Full text

Abstract:

Számítások során sokszor kapunk eredményként irracionális értéket, melynek megjelenítése tizedes tört alakban látható számológépünk vagy számítógépünk kijelzőjén. Viszont így nehezen értelmezhető az érték és pontatlan is. Ezért készítettünk olyan Excel függvényt, hogy a fontosabb irracionális értéken alapuló számokat, mint egy egész szám gyökeként vagy a Pi szám racionális törttel szorzásakor adódó irracionális számokat, meg tudjuk jeleníteni a „√” (gyök) vagy a „π” (Pi) karakterek segítségével. A programozás során kifejlesztett algoritmusok a Microsoft Excel táblázatkezelő program Visual Basi

APA, Harvard, Vancouver, ISO, and other styles

23

Korolev, A. L. "NUMERICAL SOLUTION OF NONLINEAR EQUATIONS IN ELECTRONIC TABLES AND VISUAL BASIC FOR APPLICATIONS." Informatics in school, no. 6 (October 10, 2020): 51–57. http://dx.doi.org/10.32517/2221-1993-2020-19-6-51-57.

Full text

Abstract:

The article discusses some methods for numerically finding the roots of nonlinear equations, which are determined by numerical methods using the construction of a spreadsheet Microsoft Excel and an application in the Visual Basic for Applications environment. The simplest methods are used: the binary division method and the chord method. The article presents the construction of spreadsheets, the algorithm, the method of creation the VBA application, and the text of the corresponding procedures. The material of the article can be used in informatics courses, both at school and at university, fo

APA, Harvard, Vancouver, ISO, and other styles

24

Hampel, György. "Alkalmazás fejlesztése egymintás u-próba kiértékelésére VBA vezérlőkkel Excel környezetben." Jelenkori Társadalmi és Gazdasági Folyamatok 17, no. 1-2 (2022): 119–26. http://dx.doi.org/10.14232/jtgf.2022.1-2.119-126.

Full text

Abstract:

Az egymintás u-próba elvégzésére kifejlesztett alkalmazás a Microsoft Excel programozhatóságát nyújtó Visual Basic for Applications szolgáltatással készült el. Egyetlen párbeszédablak biztosítja a felhasználói felületet az adatok megadásához és az eredmények megjelenítéséhez. Eseményvezérelt programozási technika teszi lehetővé, hogy felhasználóbarát módon viselkedjen a program, reagálva a kezelőfelület vezérlőin bekövetkező eseményekre. Az alkalmazás egyszerű kezelhetőségével az Excel táblázatkezelő program használatának ismerete nélkül végezhető el az egymintás u-próba kiértékelése, melynek

APA, Harvard, Vancouver, ISO, and other styles

25

Miller, Janice, Frances Gunn, Malcolm G. Dunlop, Farhat VN Din, and Yasuko Maeda. "Development of a customised data management system for a COVID-19-adapted colorectal cancer pathway." BMJ Health & Care Informatics 28, no. 1 (2021): e100307. http://dx.doi.org/10.1136/bmjhci-2020-100307.

Full text

Abstract:

ObjectivesA customised data management system was required for a rapidly implemented COVID-19-adapted colorectal cancer pathway in order to mitigate the risks of delayed and missed diagnoses during the pandemic. We assessed its performance and robustness.MethodsA system was developed using Microsoft Excel (2007) to retain the spreadsheets’ intuitiveness of direct data entry. Visual Basic for Applications (VBA) was used to construct a user-friendly interface to enhance efficiency of data entry and segregate the data for operational tasks.ResultsLarge data segregation was possible using VBA macr

APA, Harvard, Vancouver, ISO, and other styles

26

Hampel, György. "Excel VBA űrlap kialakítása egymintás t-próba kiértékeléséhez." Jelenkori Társadalmi és Gazdasági Folyamatok 16, no. 3-4 (2021): 65–75. http://dx.doi.org/10.14232/jtgf.2021.3-4.65-75.

Full text

Abstract:

A Microsoft Excel program Visual Basic for Applications szolgáltatásával kialakítottunk egy felhasználóbarát felületet egymintás t-próba elvégzésére. Így akár az Excel táblázatkezelő használatának ismerete nélkül is lehetőség van az egyik leggyakrabban megjelenő hipotézisvizsgálat, a t-próba elvégzésére. A használathoz elegendő megnyitni az elkészített alkalmazást, s a megjelenő ablakban a szükséges adatok és opciók beállítása után megkapjuk az eredményeket. A program vezérlőkkel biztosítja a könnyű kezelhetőséget, míg a működést eseményvezérelt programozási technikával alakítottuk ki. Az ered

APA, Harvard, Vancouver, ISO, and other styles

27

Irsyad, Fadli, Satyanto Krido Saptomo, and Budi Indra Setiawan. "Penentuan Awal dan Durasi Musim Kemarau Menggunakan Fungsi Polynomial dengan Aplikasi Visual Basic for Applications (VBA)." Agromet 28, no. 1 (2018): 40. http://dx.doi.org/10.29244/j.agromet.28.1.40-46.

Full text

Abstract:

Forecasting the occurrence of the onset of dry season and its length is important in determining the availability of water for irrigation, domestic and industrial uses. The length of dry season is used for reference in calculating water demand. Prediction of drought can be studied based on the rainfall patterns that have occurred. This is possible because there is a tendency that the rain will repeat a certain pattern at a certain time. The purpose of this study was to predict the onset of dry and rainy seasons as well as their length. Determination of the onset of dry season and its length wa

APA, Harvard, Vancouver, ISO, and other styles

28

Norton, Tomas, and Brijesh Tiwari. "Aiding the understanding of novel freezing technology through numerical modelling with visual basic for applications (VBA)." Computer Applications in Engineering Education 21, no. 3 (2010): 530–38. http://dx.doi.org/10.1002/cae.20498.

Full text

APA, Harvard, Vancouver, ISO, and other styles

29

Rohaeti, Euis Eti, Nelly Fitriani, and Padillah Akbar. "DEVELOPING AN INTERACTIVE LEARNING MODEL USING VISUAL BASIC APPLICATIONS WITH ETHNOMATHEMATICAL CONTENTS TO IMPROVE PRIMARY SCHOOL STUDENTS’ MATHEMATICAL REASONING." Infinity Journal 9, no. 2 (2020): 275. http://dx.doi.org/10.22460/infinity.v9i2.p275-286.

Full text

Abstract:

This study aims to examine the development of an interactive learning model using Visual Basic Application for Microsoft excel with ethnomathematical content on fractions, to improve primary school students’ mathematical reasoning abilities. The research method used is development through the stages of conducting preliminary studies and literature, designing interactive learning models, conducting FGDs, producing initial designs of interactive learning models, conducting limited trials in one primary school, making revisions, conducting extensive trials in four primary schools, producing trial

APA, Harvard, Vancouver, ISO, and other styles

30

Kalwar, Muhammad Ahmed, Muhammad Ali Khan, Asif Nawaz Wassan, Zuhaib Phul, Shakeel Ahmed Shaikh, and Hussain Bux Marri. "Automation of Post-Order Costing Analysis By Using Visual Basic For Applications In Microsoft Excel: A Case Study." WPOM-Working Papers on Operations Management 14, no. 2 (2023): 101–36. http://dx.doi.org/10.4995/wpom.18697.

Full text

Abstract:

Microsoft Excel is used to carry out reporting tasks in small and medium companies across the globe. Most people make reports manually in Microsoft Excel and the manual work takes a tremendous amount of time. The manual work can be easily automated with some effort in Microsoft Excel. This research is about the automation of report that was used to be made manually in Microsoft Excel.The present research is an extension of the previously conducted research (Kalwar, Shahzad, et al., 2022). The manual process to make the post-order costing analysis report in MS excel requires a lot of user time

APA, Harvard, Vancouver, ISO, and other styles

31

Fabulya, Zoltán. "Excel VBA párbeszédablak fejlesztése Shapiro-Wilk próbához Royston algoritmusával." Jelenkori Társadalmi és Gazdasági Folyamatok 18, Különszám (2023): 119–27. http://dx.doi.org/10.14232/jtgf.2023.kulonszam.119-127.

Full text

Abstract:

A matematikai statisztikában hipotézis kiértékelését végző próbák jelentős része csak normális eloszlású sokaságból származó mintán hajtható végre. A normalitás ellenőrzésére a legmegbízhatóbb Shapiro-Wilk próbát Royston kiterjesztése alapján kis és nagy elemszámú mintán is alkalmazhatjuk. Mivel kiértékelendő adataink táblázatkezelő programmal dolgozhatók fel kényelmesen, így nagy segítség a felhasználók számára, hogy a statisztikai számítások is elvégezhetők a táblázatkezelővel, nincs szükség statisztikai programokra és az adatok exportálására a további feldolgozásukhoz. Ezért volt szükséges

APA, Harvard, Vancouver, ISO, and other styles

32

Panesi, André Ricardo Quinteros. "APLICAÇÃO DO COMPUTADOR COMO FERRAMENTA DE APRENDIZADO EM DISCIPLINAS TÉCNICAS." Engevista 17, no. 4 (2015): 567. http://dx.doi.org/10.22409/engevista.v17i4.618.

Full text

Abstract:

O ensino de ciências principalmente de disciplinas técnicas como, por exemplo, resistência dos materiais em cursos superiores de tecnologia e engenharia, representa um desafio ao professor de dispor de ferramentas eficazes de aprendizado e avaliação, de modo a contribuir com o progresso dos estudantes. Fugindo um pouco da lousa e partindo para o auxílio de computadores é possível verificar que o uso de recursos computacionais particularmente o Visual Basic for Applications (VBA) onde possui muitos recursos e auxilia sem dúvida a compreensão dos alunos no processo de ensino e aprendizagem.

APA, Harvard, Vancouver, ISO, and other styles

33

Sulewski, Piotr. "Wielowymiarowe uogólnienie testu niezależności." Wiadomości Statystyczne. The Polish Statistician 2013, no. 12 (2013): 27–41. http://dx.doi.org/10.59139/ws.2013.12.2.

Full text

Abstract:

This paper discusses the theory of contingency tables with particular emphasis on three-dimension-tables. Their use in statistical surveys is stressed in the article. The three-dimension-table is presented as a chi-square test of independence and its implementation in VBA (Visual Basic for Applications) language. In this way, users are provided ready-made procedures and functions for carrying out surveys in Microsoft Excel. It has been examined also the ability of the three-dimension-table to detect the relationship between the measured traits, referred to as the power of the test.

APA, Harvard, Vancouver, ISO, and other styles

34

Rojas-Sola, José Ignacio, Gloria del Río-Cidoncha, Rafael Ortíz-Marín, and José María López-Pedregal. "Design and Development of Sheet-Metal Elbows Using Programming with Visual Basic for Applications in CATIA." Symmetry 13, no. 1 (2020): 33. http://dx.doi.org/10.3390/sym13010033.

Full text

Abstract:

This article introduces an innovative application of Visual Basic for Applications (VBA) (Visual Basic macro language) developed in CATIA (Computer-Aided Three-Dimensional Interactive Application), computer-aided manufacturing and engineering design software. Said application enables the three-dimensional (3D) representation and development to be obtained on a plane of the surfaces of cylindrical and conical elbows utilised to join two conduits, since CATIA lacks tools for the design of elements of metal fabrication. The application permits the geometric and dimensional parameters necessary fo

APA, Harvard, Vancouver, ISO, and other styles

35

Ramadhan, Fadillah, Hendang Setyo Rukmi, Arif Imran, Cahyadi Nugraha, and Risdan Ferdiansyah. "Software Design using Visual Basic for Application and Microsoft Excel Programming for Students." REKA ELKOMIKA: Jurnal Pengabdian kepada Masyarakat 1, no. 2 (2020): 86–97. http://dx.doi.org/10.26760/rekaelkomika.v1i2.86-97.

Full text

Abstract:

The rapid development of information technology has made people to have the ability to design software with a programming language. There are quite some engineers who have not mastered programming languages. It happens becausesome people think that developing software with a certain programming language is very difficult. The language is difficult to understand, the accuracy must be precise, and the user is not familiar with the platform. Difficulty in learning programming languages is a problem that is often encountered by university students, vocational students, or employees. This article d

APA, Harvard, Vancouver, ISO, and other styles

36

Slezák, Peter, Pavol Bokes, Pavol Námer, and Iveta Waczulíková. "Microsoft Excel add-in for the statistical analysis of contingency tables." International Journal for Innovation Education and Research 2, no. 5 (2014): 90–100. http://dx.doi.org/10.31686/ijier.vol2.iss5.188.

Full text

Abstract:

This paper introduces “Contingency table analysis”, a freely available menu-driven add-in program for Microsoft EXCEL, written in Visual Basic for Applications (VBA), for basic univariate and bivariate statistical analyses of contingency tables. The program provides modules for the statistical analysis of proportions, 2 × 2 tables, stratified 2 × 2 tables, and R × C tables. We compare the results of the analyses performed using our software with those obtained by commercially available statistical software. The comparison shows that our software performs equally well. The use of the add-in fac

APA, Harvard, Vancouver, ISO, and other styles

37

V. Rawat, D. R. Raman, and R. P. Anex. "Technical Note: Detecting and Subcategorizing Hard-coding Errors in Bioenergy-relevant Spreadsheets Using Visual Basic for Applications (VBA)." Applied Engineering in Agriculture 27, no. 3 (2011): 469–74. http://dx.doi.org/10.13031/2013.37064.

Full text

APA, Harvard, Vancouver, ISO, and other styles

38

Hampel, György, and Zoltán Fabulya. "Developing Excel VBA Functions for the Mathematical Modeling of Three-Dimensional Vectors." Analecta Technica Szegedinensia 18, no. 3 (2024): 82–87. http://dx.doi.org/10.14232/analecta.2024.3.82-87.

Full text

Abstract:

The current computer support for operations involving three-dimensional vectors is insufficient, even in widely used programs like Excel. These programs lack customised features specifically designed for vector operations. However, this limitation can be overcome by using the options provided by Visual Basic for Applications. By creating user functions, we can effectively calculate various results related to the mathematical application of vectors. These functions include determining the magnitude and absolute value of a vector, calculating the angle between two vectors or the cosine of that a

APA, Harvard, Vancouver, ISO, and other styles

39

Da Silva Pizzo, Henrique, and Vinícius Martins Galil. "Detention Reservoir: Proposal for Flood Control in the Ipiranga Stream Basin, Juiz de Fora, MG, Brazil." Journal of Mechanical, Civil and Industrial Engineering 2, no. 2 (2021): 34–43. http://dx.doi.org/10.32996/jmcie.2021.2.1.6.

Full text

Abstract:

In order to provide parameters for sizing a damping reservoir, which was intended to control the floods that occur in the Ipiranga Stream basin, a routine developed in Visual Basic for Applications (VBA) is used. From the identification of the most critical point of the flood, hydrological flow data are presented, estimated by dividing the basin into sub-basins, using the Rational method, resulting in a value of flow higher than the admissible one for the stream channel. The method used in dimensioning the reservoir was flood routing. After making a pre-selection of the most interesting place

APA, Harvard, Vancouver, ISO, and other styles

40

Hong, Jae-Dong, Yuanchang Xie, and Ki-Young Jeong. "An Efficient VBA Spreadsheet Algorithm and Model for the System Optimum Traffic Assignment." International Journal of Applied Industrial Engineering 1, no. 2 (2012): 36–52. http://dx.doi.org/10.4018/ijaie.2012070104.

Full text

Abstract:

The traffic assignment involves assigning traffic to a transportation network consisting of highways, arterials, or transit routes. To obtain an optimal traffic assignment scheme, a mathematical program (MP) should be formulated and solved. The process of formulating an MP requires identifying all possible paths connecting each origin-to-destination pair through the network, since the number of those paths turns out to be the number of the decision variables. Consequently, formulating and solving such an MP is difficult due to the large number of the decision variables and constraints. For tha

APA, Harvard, Vancouver, ISO, and other styles

41

Saragih, Rizki Mario Armando, and Mohammad Rizal Gaffar. "MAKING APPLICATIONS FOR ARCHIVING INCOMING AND OUTGOING LETTERS AT PT FELIXINDO JAYA PERKASA BASE ON VBA EXCEL." Records Management System Journal 2, no. 1 (2023): 6–21. http://dx.doi.org/10.62201/rmsj.v2i1.75.

Full text

Abstract:

Information regarding incoming and outgoing mail is very important for companies to make decisions on the work being carried out, mistakes often occur when searching for archival data because the filing system is not detailed and irregular, therefore changes need to be made to the filing system so that it can manage data and information according to company needs. PT Felixindo Jaya Perkasa has an electronic filing system in the form of a sheet in Microsoft Excel, but the electronic archive does not include complete information so that the process of searching for archival data is not effective

APA, Harvard, Vancouver, ISO, and other styles

42

Kristia Yuliawan and Juridno Wilson. "Implementasi Pengolahan Dokumen Menggunakan VBA dan Microsoft Excel." Jurnal Teknologi dan Informatika 2, no. 1 (2024): 13–27. https://doi.org/10.70539/jti.v2i1.21.

Full text

Abstract:

Efficient data management is essential for organizations, especially in the face of large volumes of data. Digitization of archives through document collection, scanning, and manipulation can improve operational efficiency, reduce the risk of data loss, and facilitate information access. operational efficiency, reduce the risk of data loss, and facilitate access to information. This research focuses on implementation of a document classification system in BKPSDM Nabire using VBA and Microsoft Excel to improve efficiency of data processing. The method used is the waterfall model, which includes

APA, Harvard, Vancouver, ISO, and other styles

43

Khan, Muhammad Ali, Muhammad Ahmed Kalwar, and Abdul Karim Chaudhry. "Optimization of material delivery time analysis by using Visual Basic for applications in Excel." Journal of Applied Research in Technology & Engineering 2, no. 2 (2021): 89. http://dx.doi.org/10.4995/jarte.2021.14786.

Full text

Abstract:

<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 th

APA, Harvard, Vancouver, ISO, and other styles

44

Bernard, Martin, Eva Dwi Minarti, and Masta Hutajulu. "Constructing Student’s Mathematical Understanding Skills and Self Confidence: Math Game with Visual Basic Application for Microsoft Excel in Learning Phytagoras at Junior High School." International Journal of Engineering & Technology 7, no. 3.2 (2018): 732. http://dx.doi.org/10.14419/ijet.v7i3.2.18738.

Full text

Abstract:

Learning media in Mathematics by using Microsoft Excel software that assisted Visual Basic application is a tool that can be applied for a more interactive visualization so that students better understand about mathematical concepts. Microsoft Excel is a software that serves to process data in the form of numbers that are always associated with mathematical commands. In addition, the functions of commands in Microsoft Excel can be applied in various fields such as Statistics, Economics and Finance, Mathematical Logic, and Engineering. If using mathematical concepts with data processing. But it

APA, Harvard, Vancouver, ISO, and other styles

45

Reza Agung Gumelar and Sutawanir Darwis. "Solusi Numerik Teorema Probabilitas Total Gempa Menggunakan Komputasi Sekuensial dengan (VBA)." Bandung Conference Series: Statistics 5, no. 1 (2025): 51–60. https://doi.org/10.29313/bcss.v5i1.16755.

Full text

Abstract:

Abstract. Earthquakes are natural phenomena mentioned in the Qur'an as signs of Allah's power and have significant impacts on human life. One of the regions vulnerable to earthquakes is Pelabuhanratu, which has a history of high seismic activity and complex geological conditions. Therefore, seismic hazard analysis is essential to identify potential threats and mitigate possible impacts. This study aims to apply a numerical solution using the sequential earthquake point method to solve the Teorema Probabilitas Total by Probabilistic Seismic Hazard Analysis (PSHA). This method allows for the obs

APA, Harvard, Vancouver, ISO, and other styles

46

ARTAIL, HASSAN A. "A WAVELET ANALYSIS TOOLBOX FOR EXCEL." International Journal of Wavelets, Multiresolution and Information Processing 03, no. 01 (2005): 103–23. http://dx.doi.org/10.1142/s0219691305000737.

Full text

Abstract:

This paper presents an implementation of a wavelet analysis toolbox and its integration within Excel. The toolbox includes the discrete wavelet transform, inverse wavelet transform, wavelet-based de-noising, and an associated plotting utility. The transforms and the de-noising algorithms were implemented in a DLL using C++ while the user interfaces were developed using Visual Basic for Applications (VBA) forms. A simple technique was used to automate the transfer of data, associated properties, and user selections from the worksheet to the DLL, and the computed values from the DLL back to the

APA, Harvard, Vancouver, ISO, and other styles

47

Wahab, Agrian, Nurfatzma Ayu, Muh Thariq Fayiz Syahputra A, and Adha Mashur Sajiah. "PENGEMBANGAN SISTEM INFORMASI ARSIP KWH SULAWESI TENGGARA MENGGUNAKAN METODE AGILE BERBASIS EXCEL MACRO VBA." JATI (Jurnal Mahasiswa Teknik Informatika) 8, no. 6 (2024): 11973–78. https://doi.org/10.36040/jati.v8i6.11763.

Full text

Abstract:

Pengembangan sistem informasi arsip kilowatt-hour (KWH) Telkom Witel Sulawesi Tenggara, khususnya di unit Stasiun Telepon Otomatis 1 Kendari, merupakan langkah strategis untuk mengatasi tantangan pengelolaan dokumen yang semakin kompleks dan penting. Proyek ini menggunakan metode Agile untuk memberikan fleksibilitas dalam merespons perubahan kebutuhan pengguna serta mengimplementasikan solusi berbasis Excel Macro Visual Basic for Applications (VBA). Excel dipilih karena merupakan program lembar kerja yang umum digunakan di lingkungan kerja KWH Sulawesi Tenggara, sementara VBA memungkinkan otom

APA, Harvard, Vancouver, ISO, and other styles

48

El Masmodi, Rim, and Bouabid El Mansouri. "Development of an Importance Scale for Seawater Intake Types Based on Physical Parameters Database." E3S Web of Conferences 607 (2025): 02003. https://doi.org/10.1051/e3sconf/202560702003.

Full text

Abstract:

This article presents an advanced Geographic Information Systems (GIS) based interface that innovates coastal water resource management in Morocco, with specific application to the ASSILAH region. This solution integrates spatial analysis with multi-criteria decision support, particularly focusing on the geographical distribution and territorial challenges of the Moroccan coastline, using programming tools such as Excel Visual Basic for Applications (VBA). The methodology combines GIS spatial analysis capabilities with the Analytic Hierarchy Process (AHP) to evaluate complex geographical param

APA, Harvard, Vancouver, ISO, and other styles

49

Jafarizadeh, Babak, and Reidar B. Bratvold. "The Option Value of Refracturing Oil Wells: Implementation in a Binomial Lattice." SPE Journal 24, no. 04 (2019): 1903–11. http://dx.doi.org/10.2118/195585-pa.

Full text

Abstract:

Summary The steep production decline of unconventional oil wells means that positive cash flows only last for a short while. The operator must then decide whether to continue, abandon, or hydraulically refracture the well. The decision of when to refracture the reservoir has an economic effect on the value of a well, especially with the uncertain oil prices of the future. In this paper, we develop a flexible Markov-decision process that assumes that the optimal refracture or abandonment time depends on the stochastic mean-reverting behavior of prices (described in a binomial lattice) and the t

APA, Harvard, Vancouver, ISO, and other styles

50

Esanakula, Dr Jayakiran Reddy. "A Process for Creating and Designing Automated CAD Models Through the SolidWorks API." International Journal of Innovation in Multidisciplinary Scientific Research 02, no. 02 (2024): 23–41. http://dx.doi.org/10.61239/ijimsr.2024.2219.

Full text

Abstract:

This study proposes a novel method for speeding up CAD modelling procedures by combining parametric modelling strategies, Knowledge-Based Systems (KBS), and Visual Basic for Applications (VBA) inside the SolidWorks environment. The suggested system accepts client design requirements through a user-friendly graphical user interface (GUI), utilising the power of knowledge representation and automation to speed up the design process. This technique greatly decreases the amount of time needed to model CAD, improves design correctness, and equips engineers to quickly convert client demands into rea

APA, Harvard, Vancouver, ISO, and other styles

We offer discounts on all premium plans for authors whose works are included in thematic literature selections. Contact us to get a unique promo code!