Journal articles on the topic 'Microsoft Visual Basic for applications'
To see the other types of publications on this topic, follow the link: Microsoft Visual Basic for applications.
Create a spot-on reference in APA, MLA, Chicago, Harvard, and other styles
Consult the top 50 journal articles for your research on the topic 'Microsoft Visual Basic for applications.'
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
Ali Andre, Julfikar. "SISTEM SECURITY WEBCAM DENGAN MENGGUNAKAN MICROSOFT VISUAL BASIC (6.0)." Rabit : Jurnal Teknologi dan Sistem Informasi Univrab 1, no. 2 (July 10, 2016): 46–58. http://dx.doi.org/10.36341/rabit.v1i2.23.
Full textAbstract:
Webcam (Web Camera) is a designation for real-time cameras (meaning the current situation) whose images can be accessed or viewed through the World Wide Web, instant messaging programs, or video call applications. During this time, the webcam application is only used to record and display objects, but has never been used for other applications such as security applications that are used to detect object movements. Webcams can not provide information about the motion of an object, passive or active objects. Therefore, research to improve the system to be able to detect motion from images captured from this webcam needs to be done.The motion detection system of an object works if the captured object has a changed position, and will automatically activate an alarm. The image processing method used in motion detection is the edge detection method, while for the motion detection process, the pixel position comparison process is used.
2
Ashadi, Slamet, and April Firman Daru. "Aplikasi Perpustakaan menggunakan Microsoft Visual Basic 2010." Information Science and Library 2, no. 1 (June 3, 2021): 37. http://dx.doi.org/10.26623/jisl.v2i1.3415.
Full textAbstract:
<p class="BasicParagraph">Aplikasi perpustakaan secara manual masih diterapakan di MTs Miftahul Ulum Jragung yaitu semua alur kerja masih dicatat dalam buku, mulai dari kehadiran, pendaftaran untuk kartu anggota, peminjaman dan pengembalian buku. Hal tersebut membuat proses dalam mencari sebuah informasi perpustakaan menjadi lama. Oleh karena itu perlu adanya sebuah aplikasi perpustakaan yang handal untuk mempercepat dan mempermudah proses informasi perpustakaan. Dalam merancang dan membangaun aplikasi perpustakaan MTs Miftahul Ulum Jragung digunakan metode <em>waterfall</em>, bahasa pemprograman <em>Microsoft Visual Basic</em> 2010, <em>database Microsoft Access</em> 2007 dan <em>UML </em>(<em>Unified Modeling Language</em>). Aplikasi perpustakaan terbukti mampu dalam proses kerjanya, mulai dari memberikan kemudahan bagi para pustakawan dan para pemustaka. Proses pengelolaan perpustakaan berbasis komputer membuat para pustakawan semakin mudah dalam memonitoring proses transaksi mulai dari pendataan anggota, pendataan buku, pencarian buku, peminjaman, pengembalian, dan pelaporan-pelaporan yang lian.</p><p class="BasicParagraph"><em>Manual library applications are still being applied at MTs Miftahul Ulum Jragung, namely, all workflows are still recorded in books, starting from attendance, registration for membership cards, borrowing and returning books. This makes the process of searching for library information a long one. Therefore it is necessary to have a reliable library application to speed up and simplify the library information process. The waterfall method, Microsoft Visual Basic 2010 programming language, Microsoft Access 2007 database, and UML (Unified Modeling Language) were used in designing and building the library application for MTs Miftahul 'Ulum Jragung. The library application is proven to be able in its work process, starting from making it easy for librarians and visitors. The library management process computer-based librarians make it easier for librarians to monitor the transaction process starting from member data collection, book data collection, book search, borrowing, return, and other reports.</em></p>
3
BAROT, Tomáš. "SPECIFIC UTILIZATION OF MICROSOFT VISUAL BASIC FOR APPLICATION WITH PRINCIPLES OF SYSTEM MODELING." Journal of Technology and Information 4, no. 1 (April 1, 2012): 89–93. http://dx.doi.org/10.5507/jtie.2012.019.
Full text
4
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 (October 5, 2023): 983–89. http://dx.doi.org/10.30653/jppm.v8i4.541.
Full textAbstract:
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 pemanfaatan Microsoft Excel berbasis VBA menawarkan pendekatan yang cepat untuk mengelola nilai siswa secara efektif. Sistem manajemen nilai yang diimplementasikan memfasilitasi otomatisasi tugas pemrosesan data, seperti memasukkan nilai, menghitung rata-rata, dan menghasilkan laporan nilai yang komprehensif. Berdasarkan hasil pelatihan mengalami peningkatan pemahaman terkait microsoft excel dan VBA sebesar 73,3%. Penerapan sistem pengelolaan nilai berbasis Microsoft Excel dengan memanfaatkan VBA diharapkan dapat meningkatkan efisiensi, dan kecepatan pengolahan data nilai siswa. Selain itu, kemampuan untuk menyesuaikan sistem untuk memenuhi persyaratan khusus dari masing-masing lembaga pendidikan.
This service aims to facilitate the implementation of value management system training programs in educational institutions. This training program utilizes Microsoft Excel, specifically through Visual Basic for Applications (VBA). The system development process includes identifying partner needs, formulating a system design, implementing VBA in Microsoft Excel, and the next stage of system testing and evaluation. Apart from that, training was also held for SDN 1 Kembangsari operators to guide the use of the system. This service shows that utilizing VBA-based Microsoft Excel offers a fast approach to managing student grades effectively. The implemented grade management system facilitates automating data processing tasks, such as entering grades, calculating averages, and generating comprehensive grade reports. The training results show an increase in understanding regarding Microsoft Excel and VBA by 73.3%. Implementing a Microsoft Excel-based grade management system using VBA is expected to increase the efficiency and speed of processing student grade data additionally, the ability to customize the system to meet the specific requirements of each educational institution.
5
Zuhri, Zuhri, Irwan Iwan, and Suci Andriyani. "Rancang Bangun Aplikasi Perhitungan Anuitas Terhadap Pinjaman." JURNAL MATHEMATIC PAEDAGOGIC 6, no. 1 (September 15, 2021): 9–16. http://dx.doi.org/10.36294/jmp.v6i1.2238.
Full textAbstract:
AbstractFinancial problems cannot be separated from mathematics with calculations. Likewise in Financial Mathematics which discusses the annuity of a loan that takes into account the loan interest with a repayment period for a certain period. Many applications have been built by loan providers (creditors) to make it easier for borrowers (debtors) to simulate these loans. Applications made are web-based and desktop-based. One of application that can be used to create loan repayment applications (annuities) is Microsoft Visual Basic. By using Microsoft Visual Basic, you can build a loan repayment application that calculates the interest and length of repayment, which is combined with Microsoft Access as the database and Crystal Report to create the report. In addition to storing debtor data, the application also makes it easier for debtors to simulate loans and find out the amount of annuity they will pay. Keywords: Annuity; Debtor; Creditor; Visual Basic AbstrakMasalah Keuangan tidak terlepas dari Matematika dengan perhitungan-perhitungan. Demikian juga pada Matematika Keuangan yang membahas tentang Anuitas dari suatu pinjaman yang memperhitungkan bunga pinjaman dengan masa pelunasan selama periode tertentu. Banyak aplikasi yang telah diciptakan oleh penyedia pinjaman (kreditur) untuk memudahkan para debitur dalam melakukan simulasi pinjaman tersebut. Aplikasi yang ada dapat berbasis web ataupun juga berbasis desktop. Microsoft Visual Basic merupakan salah satu software ataupun aplikasi yang dapat digunakan untuk membuat aplikasi pelunasan pinjaman (Anuitas). Microsoft Visual Basic dapat membangun sebuah aplikasi pelunasan pinjaman yang memperhitungkan bunga dan lama pelunasan, yang mana Microsoft Access digunakan sebagai databasenya dan Crystal Report digunakan untuk membuat laporan. Selain menyimpan data debitur, aplikasi juga mempermudah para debitur untuk melakukan simulasi pinjaman dan mengetahui seberapa besar anuitas yang akan dibayarkan. Kata kunci: Anuitas; Debitur; Kreditur; Visual Basic
6
Marino, Dale J. "Physiologically Based Pharmacokinetic Modeling Using Microsoft Excel and Visual Basic for Applications." Toxicology Mechanisms and Methods 15, no. 2 (January 2005): 137–54. http://dx.doi.org/10.1080/15376520590918810.
Full text
7
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 (January 31, 2022): 29–59. http://dx.doi.org/10.4995/jarte.2022.16390.
Full textAbstract:
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, the order costing report at the ABC footwear company of Lahore is prepared manually in Microsoft Excel which used to take a long time to be prepared along with the greater probability of errors in the report. Because of the above-mentioned reasons, the order costing report was decided to be automated with the help of visual basic for applications (VBA) in Microsoft Excel. The manual procedure including all the activities was collected from the planning and costing department of ABC Company. Moreover, all the activities were listed down and their time study was conducted. VBA macros were programmed with the objectives of automating all the manual tasks of the order costing report in Microsoft Excel and eliminating the chance of error (calculation error made by the employee). Macros, were programmed by the use of conditional statements, (i.e. if and else conditions) and various types of loops, (i.e. Do while loop and for loop). Automated decisions were made with the help of conditional statements during the operation and the conditional statements were circulated with the help of loops across the whole worksheet. Two userforms were designed for the execution of macros by the click of command buttons (having macros at their back). Total eight worksheets were incorporated into the automated template. All the programmed VBA macros were explained with the help of flowcharts made in the Microsoft Visio. After the report was automated, a time study of operations performed after each click was conducted with the help of stop watch. The data obtained by the time study was entered into Microsoft Excel so that the time of old and suggested methods could be compared. Comparison of both methods indicated that the suggested method took 85.92% less time as compared to the old method of preparing the order costing report. At the same time, the report made by the suggested method was free of errors and the workload of employees was also reduced.
8
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 (August 4, 2021): 200. http://dx.doi.org/10.31258/jta.v4i2.200-217.
Full textAbstract:
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. While the data analysis technique used quantitative descriptive analysis. This development research resulted in a product in the form of statistical test questions in the form of multiple choice questions consisting of five questions and packaged in a macro VBA-based Microsoft Power Point application. The results showed that the questions developed met the valid, reliable, and sensitive categories. In addition, the products developed have also met the criteria of being valid, practical, and effective for use.
9
Tanjung, Sindi Raharjo, and Dedi Suhendro. "Aplikasi Sistem Akuntansi Rekapitulasi Pendapatan pada Perusahaan Daerah Air Minum (PDAM) Tirtauli Pematangsiantar." JURNAL PETIK 6, no. 1 (March 31, 2020): 7–17. http://dx.doi.org/10.31980/jpetik.v6i1.739.
Full textAbstract:
Abstact — The Tirtauli Pematangsiantar Regional Water Company (PDAM) is classified as a state-owned company that has operational objectives to meet the needs of the community. Revenues at the Tirtauli Regional Water Company (PDAM) are divided into two, namely water revenues and non-water revenues. Regional income recapitulation Tirtauli Pematangsaiantar still uses Microsoft Excel application where the application is still often an error in revenue recapitulation. Based on this, the authors designed a recapitulation income accounting system application program using Microsoft Basic Net and MySQL database to produce applications better than those running. Application of income recapitulation accounting system using Microsoft Visual Basic Net is designed to produce a better application using a MySQL database designed to perform database manipulation processes with various facilities. The purpose of the authors designed the application to facilitate the User in recapitulation of income with the Visual Basic Net application system so that it can help or simplify the process of inputing income recapitulation.Keywords : Application, Revenue Recapitulation, Microsoft Visual Basic Net, MySQL Database.Abstrak — Perusahaan Daerah Air Minum (PDAM) Tirtauli Pematangsiantar digolongkan sebagai perusahaan negara yang memiliki tujuan operasional untuk memenuhi kebutuhan masyarakat. Pendapatan pada Perusahaan Daerah Air Minum (PDAM) Tirtauli terbagi menjadi dua, yaitu penerimaan air dan pendapatan non-air. Rekapitulasi pendapatan perusahaan Daerah Air Minum (PDAM) Tirtauli Pematangsaiantar masih menggunakan aplikasi Microsoft Excel di mana aplikasi masih sering kesalahan dalam rekapitulasi pendapatan. Berdasarkan hal ini, penulis merancang program aplikasi sistem akuntansi pendapatan rekapitulasi dengan menggunakan Microsoft Basic Net dan database MySQL untuk menghasilkan aplikasi lebih baik yang sedang berjalan. Aplikasi sistem akuntansi rekapitulasi pendapatan menggunakan Microsoft Visual Basic Net dirancang untuk menghasilkan suatu aplikasi yang lebih baik dengan menggunakan database MySQL yang didesain untuk melakukan proses manipulasi database dengan berbagai fasilitas. Tujuan penulis merancang aplikasi untuk mempermudah User dalam melakukan rekapitulasi pendapatan dengan sistem aplikasi Visual Basic Net sehingga dapat membantu atau mempermudah proses penginputan rekapitulasi pendapatan.Kata Kunci : Aplikasi, Rekapitulasi Pendapatan, Microsoft Visual Basic Net, Database MySQL.
10
Tri S, Andri Anto. "SISTEM INFORMASI PEMBAYARAN KREDIT PADA PRISMA MOTOR LUBUKLINGGAU." CommIT (Communication and Information Technology) Journal 4, no. 1 (May 31, 2010): 54. http://dx.doi.org/10.21512/commit.v4i1.536.
Full textAbstract:
In its use, computer is not only used for office activities, but also used in designing and developing an application, of course, with the assistance of applications such as Microsoft Visual Basic, Microsoft Access and others. In this study, the authors try to design and create a database application relating to motorcycle loan payments. Developed application contains forms such as employee master data form, a form used to add, edit, and delete data related to employees, the motorcycle master form, a form motorcycle used to add, edit, and delete data related to motorcycles as well as the transaction form that serves to enter data related to credit payment transactions in the company. In the design and development of the database application, the author utilizes Microsoft Visual Basic 6.0 as a supporting application.Keywords: common people (users), Visual Basic 6.0, credit payment information system
11
Fertig, David. "A German Grammar Tutorial in Microsoft Excel." Journal of Educational Technology Systems 25, no. 2 (December 1996): 161–68. http://dx.doi.org/10.2190/bhe9-td2y-9px1-p88x.
Full textAbstract:
This project exploits the combined strengths of Microsoft Excel and Visual Basic for Applications to create a model of German grammar that can serve as a flexible foundation for sophisticated computer-aided language learning (CALL) applications. A structural representation of a sentence is first built using spreadsheet tables of inflectional forms and endings, a lexicon of appropriate vocabulary, and procedures that implement the basic rules of German grammar. The sentence is then presented to the student leaving some problem to be solved (such as endings left blank). Extensive feedback is available to the student, including step-by-step interactive guidance that leads to the correct answer while reinforcing understanding of the relevant principles. Tutorials such as this one can offer the kind of guidance that many students need in order to learn and practice grammar on their own and can thus make an important contribution to a balanced approach to language learning.
12
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 (June 20, 2018): 732. http://dx.doi.org/10.14419/ijet.v7i3.2.18738.
Full textAbstract:
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 is not just a number, it can also be used to process objects on shapes or drawings on images. This, of course, requires a function other than the mathematical functions of Visual Basic Applications, which can make math tools more interesting. The advantages of Microsoft Excel with Visual Basic for Application (VBA) are (1) the images are more interactive with different sizes and can make more; (2) more economical; (3)saving time; (4)the software is easy to find, and (5)improving students 'understanding of mathematical concepts and foster students' sense of trust, especially in junior high school students.
13
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 (June 27, 2023): 101–36. http://dx.doi.org/10.4995/wpom.18697.
Full textAbstract:
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 (22.80 minutes, just if there is a single order of only one article with one color), with the greater possibility of human error. Employees in ananonymous footwear company in Lahore used to generate the post-order costing report manually in Excel.Due to the above-mentioned reasons, it was proposedto automate the report using visual basic for applications (VBA) in Microsoft Excel.The planning and costing departmentof the company provided every single step required to make the report manually. A time study was conducted for each stepof report preparation using the stopwatch. VBA macros were programmed for automating all manual report-related processes in excel andthe accuracy of the report was also verified. After the report was automated, the time study was again conducted to measure the execution time after each click. A comparison of both methods indicated that the report automation saved 83.18% of employees' time Additionally, the automated method resulted in an error-free report, and the employee`sworkload was reducedas well.
14
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 textAbstract:
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 Elliptic Curve Cryptography using VBA Excel, before performing the test of the VBA application and finally visualizes the results in graphical mode. Findings. Novel teaching software based on of Microsoft Excel Visual Basic Applications is produced that is able to simulate arithmetic system behind Elliptic Curve Cryptography in an easy way for students. Originality. To the best of the authors’ knowledge, this is the first simulation based on Excel VBA to illustrate the arithmetic systems of Elliptic Curve Cryptography for teaching purposes. Practical value. In general, mastering cryptography will need a steep learning curve; however, using Microsoft Excel as a simulation platform will accelerate learning. The main practical value is the ease of Microsoft Excel, which will turn cryptography learning which was commonly very difficult for student to become easier and user friendly.
15
Novita, Sari Sami, Siti Nurul Khotimah, and Wahyu Hidayat. "Interactive Learning Media for Lenses and Their Applications Using Macro Visual Basic in Microsoft PowerPoint." Journal of Physics: Conference Series 739 (August 2016): 012114. http://dx.doi.org/10.1088/1742-6596/739/1/012114.
Full text
16
Suarez-Navarro, J. A., Ll Pujol, M. J. Suarez-Navarro, M. Arana, and G. Hernáiz. "A method for gamma background subtraction using Visual Basic for Applications code with Microsoft Excel." Journal of Radioanalytical and Nuclear Chemistry 319, no. 3 (January 3, 2019): 1159–63. http://dx.doi.org/10.1007/s10967-018-06411-7.
Full text
17
Momodahi, Juhuria, Yudi Klaus Patiro, Eliyah Acantha M. Sampetoding, and Esther Sanda Manapa. "Rancang Bangun Sistem Informasi Keuangan Badan Ta’mirul Masjid Nursalam Bantik Beo Kabupaten Kepulauan Talaud." JTIM : Jurnal Teknologi Informasi dan Multimedia 3, no. 1 (May 25, 2021): 14–20. http://dx.doi.org/10.35746/jtim.v3i1.127.
Full textAbstract:
The role of computers in data processing to produce an information system is very influential in an organization or institution. The involvement of computer technology tools is very helpful in carrying out data processing activities, especially the making of financial reports at BTM at the Nu Salam Bantik Mosque. In recording the receipt and expenditure of shalawat money, problems often occur such as missing or scattered data, torn, and takes a long time. As a result, financial information becomes inaccurate because it is still done manually without involving computer technology. The research conducted discusses the Making and Development of the Financial Information System for the Ta'mirul Mosque of Nur Saalam Bantik. In designing an application, it is carried out by means of insight techniques, observation and literature study. This study is to create an application for the Development of Financial Information Systems for the Ta'mirul Mosque of Nur Salam Bantik using Microsoft Visual Basic 6.0 (VB). Microsoft Visual Basic apart from being referred to as a programming language (Program Language), Visual Basic is also often referred to as a tool (Tool) to produce windows application programs. In general, there are several benefits that can be obtained from using the Microsoft Visual Basic program itself. Computer at Mosque using OS Windows, So the applications created are programming tools that make it easy to use controls for database design.
18
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 (December 5, 2020): 86–97. http://dx.doi.org/10.26760/rekaelkomika.v1i2.86-97.
Full textAbstract:
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 describes an easy programming language training activity for beginners, namelyVisual Basic for Applications (VBA)-Ms. Excel training.The advantage of this programming language iseasy to operate because manystudentsor employees are very familiar with Ms. Excel so that the adaptation process will be easy. The results of the post-test training that was attended bystudents showed a significant increase in the ability to design programming languages.
19
Tambunan, Leonard, and Karolina Talia Sela. "PERANCANGAN SISTEM INFORMASI PENDATAAN PEMAKAIAN BAHAN BAKAR KENDARAAN PADA PT.DAHEPA DAMAI PRATAMA DENGAN MENGGUNAKAN BAHASA PEMROGRAMAN VISUAL BASIC.NET DAN DATABASE SQL SERVER." JSR : Jaringan Sistem Informasi Robotik 2, no. 2 (December 3, 2018): 130–36. http://dx.doi.org/10.58486/jsr.v2i2.38.
Full textAbstract:
PT. Dahepa Damai Pratama is a company who working construction engineering & transportation services. In the process of processing Data collection of vehicles Fuel Consumption is still using Microsoft Excel applications, Microsoft Word in terms of recording or inputting data so it takes a long time in performing their duties and responsibilities respectively
This research carry out to develop data processing Data collection of vehicles Fuel Consumption system and make it easier. PT. Dahepa Damai Pratama need a new data processing information system by utilizing the computer system who support the application system Visual Basic and SQL Server. With this Visual Basic programming and SQL Server Database in Data collection of vehicles Fuel Consumption can help to entry data and reported
20
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 (May 31, 2014): 90–100. http://dx.doi.org/10.31686/ijier.vol2.iss5.188.
Full textAbstract:
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 facilitates the convenient prosecution of basic statistical analyses on contingency tables from within EXCEL, sparing us the additional cost, or the inconvenience of alternating between multiple platforms, often incurred in using a commercial statistical package.
21
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 textAbstract:
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, for the development of interdisciplinary connections between informatics and mathematics and expanding ideas about the possibilities of spreadsheets. The problems presented in the article were successfully solved by 10th grade students (profile "Mathematics. Informatics") and first-year students of pedagogical university of the profiles "Physics. Mathematics", "Physics. Informatics". The article reflects the author's personal experience of teaching the course "Informatics" at South Ural State University of Humanities and Education and at school.
22
Yanty, Rosi Very. "Sistem Informasi Pengarsipan Sertifikat Tanah pada Badan Pertanahan Nasional Aceh Besar." Jurnal JTIK (Jurnal Teknologi Informasi dan Komunikasi) 4, no. 2 (May 8, 2020): 52. http://dx.doi.org/10.35870/jtik.v4i2.107.
Full textAbstract:
The design of the land certificate filing system was built to facilitate the work process in managing land certificate records, especially in the field of archives at the Aceh Besar National Land Agency, which is intended to streamline computerized data processing to support technical implementation in carrying out more accurate land certificate data processing, effective and efficient. A land certificate is a tool or means to convey statements or information in writing from one party to another party. Such information can be in the form of notifications, statements, requests, reports, objections, thoughts, questions, and so on. The design of the system used by the Rapid Application Development (RAD) method, a software development process model classified as incremental (multilevel) techniques. Applications used for making applications are Microsoft Visual Basic .NET as interface design and Microsoft Office Access as a DBMS. The test results of this application are the systems that are built already meet the needs, the input data process has met the needs and the resulting report has met the needs.Keywords:Land Certificate Filing System, Information System, Visual Basic .NET
23
Ruung, Paula Aneke, Esther Sanda Manapa, Valian Yoga Pudya Ardhana, Hoxy R. Taluay, and Eliyah A. M. Sampetoding. "Prototype Application for Data Processing Teacher Performance Assessment at Christian Elementary School Imanuel Nunu." IJICS (International Journal of Informatics and Computer Science) 6, no. 1 (March 31, 2022): 57. http://dx.doi.org/10.30865/ijics.v6i1.4030.
Full textAbstract:
The Performance every employee appraisal is a method used to assess the work performance of an employee whether he or she has achieved the work target assigned.Teacher performance appraisal at Imanuel Nunu Christian Elementary School is currently still being carried out manually in the sense that the preparation of employee performance appraisal reports still uses word processing applications (Microsoft word and excel) resulting in inefficient and ineffective time and a greater risk of data loss. The purpose that the authors take from this research is to build a Data Processing Application for Teacher Performance Assessment at Imanuel Nunu Christian Elementary School using computerized visual basic 6.0. The Teacher Performance Assessment that was made was a Data Processing Application for Teacher Performance Assessment at Imanuel Nunu Christian Elementary School by using the Visual Basic 6.0 programming language and Microsoft Office Access as databases. The results obtained are a prototype of the teacher performance assessment report at the Imanuel Nunu Christian Elementary School
24
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 (July 17, 2017): 85. http://dx.doi.org/10.14710/jati.12.2.85-94.
Full textAbstract:
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 implemented and the implementation results are analyzed. The results found that the new system successfully fulfilled the objectives of this research and the user requirements, although there are still some improvements which need to be done. During two months’ period of implementation, there are some problems encountered which required the programmer to improve the system. Like every system, there are some advantages and disadvantages found in this new system.AbstrakPenelitian ini fokus kepada desain dan implementasi sistem informasi baru yang akan mengotomatisasi proses dari sistem saat ini dan dampaknya terhadap staf gudang. Dalam rangka untuk mengotomatisasi proses, sistem informasi yang terprogram dirancang menggunakan Microsoft excel VBA,sebuah fungsi dasar pemrograman dalam Microsoft excel. Pertama, sistem yang sekarang dianalisis. Selanjutnya, kebutuhan pengguna dan kebutuhan sistem yang diusulkan dianalisis untuk membuat desain sistem. Kemudian, program ini dikembangkan dan diuji dengan menggunakan VBA (Visual Basic for Applications). Kemudian, sistem baru diimplementasikan dan hasil dari implementasi dianalisis. Hasil penelitian menemukan bahwa sistem baru berhasil memenuhi tujuan penelitian ini dan kebutuhan pengguna, meskipun masih ada beberapa perbaikan yang perlu dilakukan. Selama periode dua bulan implementasi, ada beberapa masalah yang dihadapi yang membutuhkan programmer untuk mengembangkan sistemnya. Seperti setiap sistem, ada beberapa kelebihan dan kekurangan yang ditemukan dalam sistem baru ini.
25
Rahim, Jamaluddin, and Seacher Junaedi. "Rancangan Sistem Monitoring Indicator LED Transmitter ILS di Bandar Udara Tjilik Riwut Palangkaraya." AIRMAN: Jurnal Teknik dan Keselamatan Transportasi 1, no. 1 (June 29, 2018): 40–51. http://dx.doi.org/10.46509/ajtk.v1i1.39.
Full textAbstract:
Monitoring indicator led equipment Instrument Landing System (ILS) plays an important role in information services for aviation safety, the situation should always be monitored to anticipate the error on . The purpose of planning to design applications based on visual basic 6.0, to monitor the change of main Tx to Tx standby Instrument Landing System (ILS \) at the airport Tjilik Riiwut Palangkaraya. Design using Microsoft Visual Basic 6.0 and connect using Wi-Fi networks. The results of this planning monitoring progress towards the turn of the main Tx to Tx stand by to be able to overcome the instability of security. Therefore, it is advisable to arrange a more sophisticated monitoring system for equipment ILS (Instrument Landing System).
26
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 (September 29, 2020): 275. http://dx.doi.org/10.22460/infinity.v9i2.p275-286.
Full textAbstract:
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 in another primary school. The last obtaining a final model and conducting socialisation. The last, it provides a test of mathematical reasoning ability. The research subjects were teachers and students in six primary schools. The research instruments were interviews, validation sheets, documentation, learning observation sheets, questionnaires and mathematical reasoning ability test. The assessment criteria for the developed learning model include syntax, social system, principle of reaction, supports system and instructional impact. The results showed that 1) Development of VBA-assisted and ethnomatematically-loaded interactive learning models go through two major stages, namely product development and validation 2) The Interactive learning model was declared very valid; 3) The responses of teachers and students were generally positive; 4) The achievement of students’ mathematical reasoning abilities after gave learning with an interactive model using VBA for Microsoft Excel with ethnomathematical contents better than using ordinary learning.
27
Setiawan, Edwin Yulia. "AUTOMASI STOCK OPNAME BMN MELALUI PEMINDAIAN QR CODE MENGGUNAKAN APLIKASI VISUAL BASIC FOR APPLICATION." Jurnal Pari 5, no. 2 (February 26, 2020): 125. http://dx.doi.org/10.15578/jp.v5i2.8778.
Full textAbstract:
ABSTRAK:Dalam Sistem Stock Opname Barang Milik Negara sampai dengan saat ini masih dilakukansecara manual melalui pencatatan menggunakan kertas dan pengamatan menggunakan matasecara langsung. Metode ini menimbukan permasalahan pada kecepatan dan ketepatanpembacaan kode barang. Inovasi yang disampaikan pada artikel ini adalah memanfaatkan Quick Response Code yang dihasilkan oleh aplikasi Barang Milik Negara untuk melakukan prosesstockopnamesecara automatis menggunakan aplikasi yang diinstal pada handphone (sebagai alatpembaca Quick Response Code) dan PC Desktop/PCTablet (sebagai database Barang Milik Negara dan pengolah data). Sistem ini dibangun menggunakan platform desktop applicationmenggunakan software Visual Basic for Application dengan database menggunakan Microsoft Excel dan aplikasi android Scan-IT to Office. Penerapan sistem aplikasi stock opname melibatkan operator Barang Milik Negara, pelaksana stock opname, pengawasan oleh pejabat Administrator atau pejabat lainnya yang secara langsung melakukan pengawasan proses stock opname secara real time. Dengan menggunakan sistem automasi ini, dapat meningkatkan efektivitas dan efisiensipengelolaan Barang Milik Negara, yang meliputi pelaksanaan stock opname, pencatatan perubahandata nama dan spesifikasi barang, pemegang barang dan status barang, pelaporan hasil stock opname yang digunakan sebagai sumber perubahan data Barang Milik Negara.ABSTRACT:The stock opname to State-Owned Property up to now is still done manually through the use of paper and observation use the eye directly. This methode raises a problem with the speed and accuracy of reading item codes. Innovation delivered on this article is to harness Quick Response Codeproduced by application roll State-Owned Property existing to conduct the stock opname inautomatic use applications installed on mobile (as Quick Response Code reader equipment) and desktop/tablet pc (as State-Owned Property database and processors). The system was built using a desktop application platform that uses software application for visual basic with the database using microsoft excel and the android application Scan-IT to Office. The implementation of the applications involving State-Owned Property operator opname stock, the stock opname operator, supervision by an administrator or other officials directly to supervise the stock opname in real time. Using this automatic system, improving the effectiveness, and efficiency of State-Owned Property management, which includes the stock opname, the record of specification and item name change, the holder and status of the goods, reporting the stock opname result that is used as a source of State-Owned Property data.
28
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 (October 16, 2023): 6–21. http://dx.doi.org/10.62201/rmsj.v2i1.75.
Full textAbstract:
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 and efficient. Changes to the filing system are made with consideration of the effectiveness and efficiency of using the system, Visual Basic Application/VBA in Microsoft Excel can be used as a basis for making new filing system applications. VBA works with the Microsoft Excel program language which is then compiled into a company filing system application, the application is used to input incoming and outgoing mail data, and search for and delete data on company system applications so that the use of the filing system can be more effective and efficient.
29
Sukartini, Firman Surya, Welsi Haslina, Yusnani, and Ulfi Maryati. "Aplikasi Pelaporan Kelebihan Jam Mengajar Jurusan Akuntansi PNP." Akuntansi dan Manajemen 15, no. 2 (December 28, 2020): 43–49. http://dx.doi.org/10.30630/jam.v15i2.18.
Full textAbstract:
This study aims to create a database application program that is able to process data on lecturer course activities and generate reports on the calculation of teaching fees periodically during the pandemic which requires lecturers to report lecture activities online. The system design method approach used is prototyping, namely by creating a program that most closely resembles user needs in a relatively short time. The prototype was generated using the Microsoft Access 2010 database application. The selection of microsoft access to create a prototype was based on the availability of complete facilities in Microsoft Access to design table relations, input forms, query processing, reports and the visual basic programming language for applications. Google Forms used to receive lecture data input online. The application development stages consist of design, testing and implementation stages. This application has succeeded in providing the right solution for the Padang State Polytechnic Accounting Department during the pandemic in calculating and reporting lecture activities and lecturers teaching fees.
30
Joanda, Alfian Destha, Yusuf Priyandari, and Roni Zakaria. "PERANCANGAN SISTEM INFORMASI MANAJEMEN LAYANAN JASA TEKNOLOGI DAN KERJASAMA DI LEMBAGA DEF." Jurnal Sistem Informasi 10, no. 2 (January 5, 2015): 97. http://dx.doi.org/10.21609/jsi.v10i2.392.
Full textAbstract:
Layanan jasa seksi ABC information system is a system used by ABC lembaga DEF staff for process of saving and processing data of customer and customer’s product. This system facilitated by lembaga DEF to support making a document for testing. Previously seksi ABC lembaga DEF staff still use Microsoft Access and manual record. Therefore seksi ABC lembaga DEF staff require a new information system that quickly and efficiently so that improve customer services. In making this new information system the author uses Microsoft Visual Basic and MySql. The design of information system using prototyping method and using the database design with the concept of context diagram, Data flow Diagram (DFD), flowchart and Entity Relationship Diagram (ERD). The new application system is based on desktop applications and integration with SMS gateway.
31
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 (September 8, 2022): 119–26. http://dx.doi.org/10.14232/jtgf.2022.1-2.119-126.
Full textAbstract:
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 során a megjelenített eredmények értelmezése sem igényel matematikai statisztikai jártasságot. A számításokhoz szükséges adatok megadhatók a minta teljes adatsorával, de a minta elemszámával és átlagával is.
32
Oktorina, Fenty. "Otomatisasi Pembuatan Dokumen Administrasi Akademik Di Politeknik Kampar." Jurnal Sains dan Ilmu Terapan 4, no. 2 (December 1, 2021): 20–23. http://dx.doi.org/10.59061/jsit.v4i2.25.
Full textAbstract:
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 Excel, persyaratan aplikasi yang dapat terpenuhi secara otomatis karena VBA memiliki fitur yang mendukung dokumen otomatisasi.
33
Sulewski, Piotr. "Wielowymiarowe uogólnienie testu niezależności." Wiadomości Statystyczne. The Polish Statistician 2013, no. 12 (December 30, 2013): 27–41. http://dx.doi.org/10.59139/ws.2013.12.2.
Full textAbstract:
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.
34
Florea, Emilia Roxana, and Marian Gheorghe. "Structure and Components of a Turning Database System." Applied Mechanics and Materials 760 (May 2015): 451–56. http://dx.doi.org/10.4028/www.scientific.net/amm.760.451.
Full textAbstract:
Design and deployment of the manufacturing processes are based on complex data concerning product development, process structures, planning, costs. Applications within the computer-based engineering are conditioned by the information system. Storage and use of specific data are concentrating in databases. The present contribution is on the development of basic elements for creation a database system on turning processes, usable in engineering activities. The main part presents the information model that provides neutral data interfaces system for machining processes. Implemented under Microsoft Visual Basic macros, this database system supports the integration of manufacturing requests. Based on stored information and initial data provided by user, the designed database system offers variants of technological elements. Structures and relationships are provided.
35
Moon, Yong K., Yu H. Song, Jae H. Kim, Sang Sik Lee, and Joung H. Mun. "The Development Telemedicine System for Blood Pressure Monitoring via Ethernet." Key Engineering Materials 321-323 (October 2006): 1103–6. http://dx.doi.org/10.4028/www.scientific.net/kem.321-323.1103.
Full textAbstract:
The objective of this study was to develop an Ethernet-based telemedical blood pressure monitor. Although telemedical applications utilizing a variety of media are currently available, present systems do not provide remote signals with regard to integrated vital information, including blood pressure and pulse rate. In addition, the existing systems are largely embedded-structure, single-access, single-process models. Thus, we developed an Ethernet-based blood pressure monitor which includes a client/server structure, and is a real-time multi-access and multi-process system. The client for the developed system uses the Microsoft Comm Control in Microsoft Visual Basic and ODBC to connect Microsoft Chart Control with DB for a user interface. The server is programmed with the J2SE development platform, in a multi-thread structure. The system is capable of receiving data simultaneously. A TCP/IP socket was used for the Ethernet connection. The JDBC was applied to connect with the database for the saving, searching, and sampling of the data. The data transfer failure rate of the developed system was determined to be less than 0.05%.
36
Pardede, Ilda Aprisya, and Nasib Marbun. "Design of Goods Inventory Information System Using Visual Basic .Net (Case Study: CV. Barokah Medan)." Journal of Computer Networks, Architecture and High Performance Computing 6, no. 3 (July 2, 2024): 967–75. http://dx.doi.org/10.47709/cnahpc.v6i3.4009.
Full textAbstract:
CV Barokah Medan is a company engaged in the distributor of beverage powder. This company was founded in 2019. Currently, the inventory process at CV Barokah Medan is still carried out conventionally, namely by using ledger records and Microsoft Excel tools. By using the current system, it takes a lot of time to search for goods because of the large number of items, then the problem that occurs is that there is data redundancy and notebooks and inventory data files are damaged or lost so that the checking process takes a long time and is mistaken in the data recording process. Efforts to overcome these problems in this study the authors are interested in creating an inventory information system using the visual basic .net programming language at CV. Barokah Medan. Visual basic .net is visual basic that is re-engineered for use on the .NET platform so that applications created using visual basic .NET can run on computer systems supported by the windows operating system. The results of this study indicate that the proposed inventory information system at CV. Barokah Medan can be used to store and process data in the warehouse, namely item data reports, supplier data reports, and inventory reports per day, per month and per year. So that it can support the CV. Barokah Medan to achieve higher productivity, and save costs, energy, and time in collecting, retrieving and managing inventory data, as well as displaying information data quickly and accurately.
37
Bruce, Jarel C., Han-Sup Han, Abdullah E. Akay, and Woodam Chung. "ACCEL: Spreadsheet-Based Cost Estimation for Forest Road Construction." Western Journal of Applied Forestry 26, no. 4 (October 1, 2011): 189–97. http://dx.doi.org/10.1093/wjaf/26.4.189.
Full textAbstract:
Abstract A computer program has been developed to aid forest engineers in the cost estimation of forest road construction activities. This new tool, called ACCEL, uses Visual Basic for Applications within Microsoft Excel to compute the costs of construction components using interactive sheets, automated tasks, and advanced computer routines. The user is guided through road construction components and prompted for cost data, earthwork quantities, survey information, and the conditions of the construction environment to estimate total construction cost. Road design elements and site characteristics are variables used to optimize earthwork allocation, improving on using the mass diagram method. The program also estimates clearing and grubbing areas, rock surfacing volumes, and culvert lengths. ACCEL was validated by comparing the results to those of RoadEng (by Softree), ensuring that formulas were input correctly and showing close agreement in results. This program was created in a recognizable format, i.e., Microsoft Excel, and builds on basic quantity and cost estimation techniques. ACCEL is intended to improve the decisionmaking process for experienced forestry practitioners in forest road construction regardless of region, company, or agency affiliation by accepting their inputs and performing the calculations for different route alternative or varying design specifications.
38
Fabulya, Zoltán, György Hampel, Anita Kiss, and Bernadett Béresné Mártha. "Excel függvények fejlesztése Shapiro-Wilk próbához Royston algoritmusa alapján." Jelenkori Társadalmi és Gazdasági Folyamatok 18, no. 1-2 (October 17, 2023): 165–72. http://dx.doi.org/10.14232/jtgf.2023.1-2.165-172.
Full textAbstract:
Kutatásunk céljaként Excel számolótáblán alkalmazható függvényeket fejlesztettünk ki, melyek egy statisztikai sokaság normális eloszlásának tesztelésére alkalmasak. Függvényeink Royston algoritmusát alkalmazzák, mely a normalitás ellenőrzésére legerősebb Shapiro-Wilk próbának a kiterjesztése. Így 4 és 2000 közötti elemszámú minta kiértékelése közelítő számításokkal valósítható meg úgy, hogy szignifikanciaszint kiszámításával dönthessünk a normalitásról, elkerülve a Shapiro-Wilk próba táblázatban adott kritikus értékeinek használatát. Az Excel számolótáblán a kiértékelések automatizálhatók függvények használatával, ezért gyorsabb és kényelmesebb technikát nyújtva, mint a statisztikai programcsomagok. A függvények programozását a Microsoft Excel Visual Basic for Applications szolgáltatása biztosította. Royston képleteit átalakítva olyan függvény is készült, mellyel a próba kritikus értéke adódik tetszőleges elsőfajú hibavalószínűséghez.
39
Amalia Septi Reslili and Danang Danang. "APLIKASI PENJUALAN OXYGEN PADA PT. SINAR PURNAMA SAKTI SEMARANG." Jurnal Informatika Dan Tekonologi Komputer (JITEK) 4, no. 1 (March 13, 2024): 35–44. http://dx.doi.org/10.55606/jitek.v4i1.2953.
Full textAbstract:
Sinar Purnama Sakti Semarang is an agent with a trading business that is engaged in the sale of Gas Oxygen (O2), Acyteline (C2H2), Carbondioxide (CO2) and Argon (Ar) experiencing problems, namely in the process of data processing sales of goods are still completely manual. This results in a good accumulation of transaction data, so that the efficiency and completeness of the data is not guaranteed. The purpose of this paper is to create an application that can help process data quickly and efficiently at PT. Sinar Purnama Sakti Semarang. This sales application is very helpful for users. With the new system in the sales application, it will make it easier to process data and make sales reports. In addition, PT. Sinar Purnama Sakti Semarang can also provide proof of payment in the form of a note. Performance of PT. Sinar Purnama Sakti Semarang becomes faster and more efficient after the sales application. So to simplify the sales information system is done with a computerized system. There are several programs that can be used in processing sales applications, one of which is the Visual Basic 6.0 program. Microsoft Visual Basic 6.0 is one of the most popular programs used in programming. Many people have used it and many people already know it. As for storage, the author uses Microsoft Office Access. Based on the description above, the authors take the title in accordance with the need for data processing information in PT. Sinar Purnama Sakti Semarang.
40
Kalwar, Muhammad Ahmed, Asif Nawaz Wassan, Zuhaib Phul, Muzamil Hussain Wadho, Tanveer Sarwar Malik, and Muhammad Ali Khan. "Automation of material cost comparative analysis report using VBA Excel: a case of footwear company of Lahore." Journal of Applied Research in Technology & Engineering 4, no. 1 (January 31, 2023): 13–23. http://dx.doi.org/10.4995/jarte.2023.18776.
Full textAbstract:
Small and medium-sized firms in developing countries perform the majority of all reporting tasks in Microsoft excel. The material cost comparative analysis (MCCA) report took the user 58.51 minutes to complete and there was also a higher likelihood of calculation error. The report was created in Microsoft excel by the Lahore-based ABC footwear business. This used to take a lot of time to produce and there was a higher chance that the report would contain errors. This is because Microsoft excel visual basic for applications was used to automate the report. This report's manual preparation method was compiled by the company’s planning and costing division. Each activity was listed, followed by the completion of a time study. VBA macros were built in Excel to automate all manual report-related tasks and reduce the possibility of human error. Conditional statements were applied to help automated decision-making. To enable command buttons to run macros, one user form was created. There were various worksheets included in the MCA template. The automated template was found to consume only 16.26 minutes and it was quicker than the current technique.
41
Fainun, Ahmad. "SISTEM INFORMASI PENDATAAN FAKIR MISKIN DAN ANAK YATIM PADA KANTOR DESA TUMPOK LAMPOH KECAMATAN KUTA BARO KABUPATEN ACEH BESAR." Jurnal Indonesia : Manajemen Informatika dan Komunikasi 1, no. 1 (June 30, 2020): 35–41. http://dx.doi.org/10.35870/jimik.v1i1.11.
Full textAbstract:
Tumpok Lampoh Village Office, Kuta Baro Subdistrict, Aceh Besar District records the data of the poor and orphans according to the direction of financial assistance for the poor as recipients of government assistance and in accordance with the recommendations of the Aceh Qanun Draft Empowerment of Orphans and the Poor. The limitation of the problem is only on the Information System for Data Collection of the Poor and Orphans at the Tumpok Lampoh Village Office, Kuta Baro District, Aceh Besar Regency, in order to realize the information system using Visual Basic applications and the purpose of writing here consists of general goals and special objectives. There are two methods that the authors use to collect data, namely Field Study and Library Research. Based on observations and writers can draw a conclusion Information System for Data Collection of the Poor and Orphans at the Tumpok Lampoh Village Office, Kuta Baro District, Aceh Besar Regency is expected to help make data collection of the poor and orphans who are accurate and effective and built using Visual Basic and Microsoft Access as the database.
42
Muharromah, Isnaini Hidayatun, Nur Fatoni, and Dessy Noor Farida. "Desain Aplikasi Akuntansi pada LAZISMU Lamongan." Jurnal Akuntansi Indonesia 10, no. 2 (October 11, 2021): 129. http://dx.doi.org/10.30659/jai.10.2.129-146.
Full textAbstract:
This writing aims to design an information system that produces applications regarding accounting on zakat contained in amil zakat institutions, infaq and shadaqah Muhammadiyah Lamongan. Before the design is designed properly, it is necessary to analyze the financial recording system contained in LAZISMU Lamongan. The results of the analysis of the accounting application system used by LAZISMU Lamongan will be taken into consideration for the process of designing an accounting application system design. The method that can be used to design this system design is the System Development Life Cycle (SDLC) methodology. Where this method has a function as a helper to analyze, accelerate and can produce accuracy to present a solution and provide a sequential or sequential approach to the software life flow starting from the analysis, design, coding, testing and support stages. The form of design that will be applied to the Amil Zakat Institute for Infak and Shadaqah Lamongan is in the form of automation designed using Microsoft Excel combined with Visual Basic for Applications. In the design of the application design contains sheets where regarding the application of the accounting cycle starting from recording a list of accounts and account codes, classifying accounts, recording transactions in general journals then ledgers to several financial reports which include; statement of financial position, changes in funds, changes in assets under management, cash flow and a list of fixed assets (Statement of Financial Accounting Standards No. 109 concerning zakat).Keywords: Accounting Applications, General Ledger Excel, Visual Basic for Application, PSAK No 109.ABSTRAKPenulisan ini memiliki tujuan untuk mendesain sistem informasi yang menghasilkan aplikasi mengenai akuntansi pada zakat yang terdapat di lembaga amil zakat, infaq dan shadaqah muhammadiyah Lamongan. Sebelum desain dirancang secaa baik perlu melakukan analisis sitem pencatatan keuangan yang terdapat pada LAZISMU Lamongan. Hasil analisis dari sistem aplikasi akuntansi yang digunakan oleh LAZISMU Lamongan akan dijadikan pertimbangan untuk melakukan proses perancangan desain sistem aplikasi akuntansi. Adapun metode yang bisa digunakan untuk merancang desain sistem ini adalah metodologi System Development Life Cycle (SDLC). Dimana metode ini memiliki fungsi sebagai pembantu menganalisa, mempercepat dan bisa menghasilkan ketepatan untuk memaparkan sebuah solusi dan menyediakan pendekatan alur hidup perangkat lunak secara sekuensial atau urut mulai dari analisis, desain, pengkodean, pengujian dan tahap support. Bentuk desain yang akan diterapkan pada Lembaga Amil Zakat Infak dan Shadaqah Lamongan berupa otomatisasi yang dirancang menggunakan Microsoft excel dipadukan dengan Visual Basic for Application. Didalam perancangan desain aplikasi tersebut berisi sheet-sheet dimana mengenai pengaplikasian siklus akuntansi yang dimulai dari pencatatan daftar akun dan kode akun, penggolongan akun-akun, pencatatan transaksi pada jurnal umum kemudian buku besar sampai beberapa laporan keuangan yang meliputi; laporan posisi keuangan, perubahan dana, perubahan asset kelolaan, arus kas dan daftar aset tetap (Pernyataan Standar Akuntnasi Keuangan No 109 tentang zakat).Kata Kunci: Aplikasi Akuntansi, General Ledger Excel, Visual Basic for Aplication, PSAK No 109.
43
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 (December 17, 2021): 77–86. http://dx.doi.org/10.14232/jtgf.2021.3-4.77-86.
Full textAbstract:
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 Basic for Applications szolgáltatásával készültek el. A szám megfelelő megjelenítéséhez a függvényünknek fel kell ismernie az argumentumaként kapott számot, melyet szöveges formátumban jelenít meg rövidebb, és jobban értelmezhető formában, mint az eredeti, tizedes tört alakú irracionális szám.
44
Košťál, Igor, and Martin Mišút. "A COMPARISON OF CREATING AN ANDROID APPLICATION USER INTERFACE IN XAML AND IN C# CODE." Proceedings of CBU in Natural Sciences and ICT 2 (October 24, 2021): 52–62. http://dx.doi.org/10.12955/pns.v2.153.
Full textAbstract:
Almost every Android user application has some kind of user interface. Android programmers who create Xamarin.Forms applications and who uses the Microsoft Visual Studio development environment to do so can create user interfaces in the XAML (the Extensible Application Markup Language) or in the C# programming language. This paper deals with a comparison of creating this user interface by the first and the second way. We demonstrate the differences in the creation of Android application user interfaces in XAML and in C# by way of using two of our Android applications which were created by the Microsoft Visual Studio 2019 Enterprise, which work as text editors with the ability to store text to disc, and have user interfaces that are visually identical. However, the user interface of the first Android application was created in XAML with a C# support code, whereas the user interface of the second Android application was created entirely in C#. While comparing the source codes of the user interfaces of both these Android applications, we identify the advantages and disadvantages of both approaches to creating a user interface and we try to find out which of these approaches is better for maintaining and modifying user interfaces. In this study, we also contrast the processes of handling events of controls of a user interface created in the XAML code for the first Android application as well as that of the same user interface created in the C# code for the second Android application. Furthermore, we were interested in determining whether the different ways of creating user interfaces affected the execution time of basic operations that included disc files that were performed on the same data by both the applications. We assume that it does not fundamentally affect the execution time, and so, we performed an experiment to confirm or refute our assumption.
45
Surya, Firman, Elfitri Santi, Fera Sriyunianti, and Randy Heriyanto. "Desain Aplikasi Database Sistem Informasi Akuntansi Sekolah pada Yayasan Ainur Rahmah." Akuntansi dan Manajemen 18, no. 1 (June 28, 2023): 73–80. http://dx.doi.org/10.30630/jam.v18i1.215.
Full textAbstract:
This study aims to develop an accounting information system database application for Ainur Rahmah Foundation school in West Pasaman, West Sumatra Province. The problem faced by the Ainur Rahmah Foundation is the absent of an information system to manage student data, tuition fees, admission of new students, receipt and disbursement of cash, purchase and use of consumables, acquisition and depreciation of fixed assets. The developed accounting information system database application consists of two main subsystems, namely the back-end and front-end. The back-end system uses DBMS MySQL Server 8.0 while the front-end system is developed using Microsoft Access 2010. Application modules and reports are developed on the front-end using the Visual Basic for Application programming language which is available in Microsoft Access database tools. Applications that have been developed are then tested for use by users to find out if there are errors and adjustments that must be made. After making adjustments based on the user trial stage, the application can be accepted by users and can be operated according to needs.
46
Артемов, Владислав, Тетяна Мовчан, and Евеліна Бахчеван. "Методика розв’язання оптимізаційних задач із використанням макросів Microsoft Excel." Bulletin of Sumy National Agrarian University, no. 2 (88) (June 28, 2021): 3–8. http://dx.doi.org/10.32845/bsnau.2021.2.1.
Full textAbstract:
Метою статті є автоматизація розрахункового алгоритму розподільного методу для переходу від статичних обчислень до динамічних. У роботі досліджено різноманітні економіко-математичні методи та моделі, які застосовуються в різних сферах економіки і системі логістики. На основі аналізу досліджень науковців виявлено, що під час економіко-математичного моделювання найбільш розповсюджені методи лінійного програмування. Останнім часом широко застосовується логістика, яка реалізується органами керування, логістичними підрозділами та обладнанням, що виражається у реалізації транспортного, технічного, матеріального забезпечення. Математичне моделювання під час вивчення процесів різних сфер економіки застосовується з метою визначення оптимального поєднання сфер, тобто збалансування виробництва і використання ресурсів так, щоб забезпечити оптимальне використання наявних запасів. Система моделей будується за принципом цілеспрямованого розвитку галузей економіки та має на меті оптимізацію виробничої програми підприємств. Саме економіко-математичні моделі можуть бути важливим інструментом у руках менеджерів різних сфер для передбачення можливих наслідків будь-яких здійснених заходів. Роботу присвячено прогнозним моделям логістичного забезпечення різноманітних потреб, які реалізуються шляхом застосування розподільного методу для оптимізації використання ресурсів. Проведено аналіз та оцінку засобів постачання і забезпечення, що дало можливість змоделювати ситуацію, намітити конкретну мету, вибрати шляхи для її досягнення та отримати найкращий оптимальний результат. Для практичної реалізації складання опорного плану розв'язування оптимізаційної задачі шляхом автоматизації розрахунків застосовувалися засоби Visual Basic for Applications (VBA) у програмі Microsoft Excel. Наведена програма розрахунку опорного плану методом північно-західного кута на мові програмування VBA дає змогу в динамічному режимі змінювати кількість та запаси постачальників, кількість і потрібності споживачів та тарифи. Визначено напрям подальших досліджень, який полягає у вдосконаленні розробленої програми для автоматизації подальших розрахунків розподільного методу. Практична цінність статті полягає у тому, що текст програми може використовувати будь-який користувач шляхом вставки її в макроси Excel.
47
Binh, Tran Thuc, Le Thi Phuong Tram, Nguyen Van Hop, Nguyen Dang Giang Chau, Nguyen Duy Luu, and Nguyen Thi Quynh Trang. "Simultaneous Determination of Hydrochlorothiazide and Losartan Potassium in Pharmaceutical Product by UV-Vis Spectrophotometric Method with Kalman Filter Algorithm." Journal of Analytical Methods in Chemistry 2021 (July 20, 2021): 1–8. http://dx.doi.org/10.1155/2021/2754133.
Full textAbstract:
In this paper, hydrochlorothiazide (HCT) and losartan potassium (LSP) in tablets are simultaneously determined with UV-Vis spectrophotometry and chemometrics without separation. The spectra of standard and sample solutions were recorded in the wavelength from 220 to 300 nm at 1.0 nm intervals. The concentrations of HCT and LSP in the sample solutions were computed with the Kalman filter algorithm written on the Microsoft Excel 2016 and Visual Basic for Applications (VBA) platform. The method validation was determined via the accuracy and repeatability of measurements when analyzing HCT and LSP in the Splozarsin Plus tablet and comparing the mean values of their contents in the sample with those analyzed with HPLC. The proposed method is simple with a low cost compared with the standard HPLC method.
48
Kiswantono, Agus, E. Nur Cahyono, and Hermawan. "Profile of Automation of Electricity Distribution System Bhayangkara University Surabaya." JEECS (Journal of Electrical Engineering and Computer Sciences) 6, no. 2 (December 31, 2021): 1071–80. http://dx.doi.org/10.54732/jeecs.v6i2.201.
Full textAbstract:
Electrical Power Transmission is the process of distributing electricity from the power plant to the electricity distribution channel (substation distribution) so that it can be distributed to consumers who use electricity. Human Machine Interface (HMI) is a system that connects humans and machines. HMI can be in the form of controlling and visualizing status, either manually or through computer visualization that is real time. .Microsoft Visual Basic .NET is a tool for developing and building applications that run on top of the .NET Framework system. Arduino is a microcontroller that has been developed. Serial communication is one of the methods of data communication in which only one bit of data is transmitted over a strand of cable at a time
49
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 (December 28, 2022): 75–82. http://dx.doi.org/10.14232/jtgf.2022.3-4.75-82.
Full textAbstract:
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 is egyszerűen kezelhető a program. A tesztelendő hipotézis olyan listából válaszható ki, melyben minden lehetséges változat elérhető. Az adatok megadásához kiválasztható, hogy a statisztikai minta teljes adatsorát adnánk meg, vagy csak a minta azon jellemzőit, melyek a kiértékeléshez szükségesek. Az eredmények könnyen értelmezhetőek, a számított eredményeken túl egészmondatos válaszként is megjelenik a tesztelendő hipotézisre adott válasz.
50
Annisa, Syerlie, and Yurita Delvianti. "Heavy Equipment Rental Schedule Report Application Using Visual Basic.Net and MySQL Database." Knowbase : International Journal of Knowledge in Database 1, no. 2 (December 31, 2021): 140. http://dx.doi.org/10.30983/ijokid.v1i2.5096.
Full textAbstract:
The heavy equipment business in Indonesia is again excited in line with the increasing demand for heavy equipment by various sectors such as the mining sector, the agro-industry sector, and the construction sector. PT. Petronesia Benimel is one of the business fields engaged in renting heavy equipment. The management of the heavy equipment rental schedule to other companies has been carried out using a computerized system, namely using the Microsoft Excel application which is still not optimal in integrating, calling and processing data at once. Using these applications independently results in the management of heavy equipment rental reports being constrained because tenant data and rental management are often out of sync. The application uses Visual Basic programming language and MySQL database supported by research and product development methods and waterfall development models. Based on the trial results of using a schedule report application that can make it easier for staff to manage heavy unit rental schedules from various partner companies (stakeholders) so that better reports are obtained.