scholarly journals Analisa Perhitungan Kelayakan Pembangkit Listrik Tenaga Air (Plta) Dengan Bantuan Software Visual Basic For Application (VBA)

Barometer ◽  
2021 ◽  
Vol 6 (2) ◽  
pp. 335-342
Author(s):  
Faris Fauzi ◽  
Agus Hermanto
Keyword(s):  
Input Data ◽  
Visual Basic ◽  
Payback Period ◽  
Data Input ◽  
Microsoft Excel ◽  
Visual Basic For Application

Kebutuhan energi semakin meningkat dengan berkembang pesatnya perkembangan teknologi, dan industri. Berbagai alternatif energi terus dikembangkan oleh pemerintah. Energi fosil terbatas jumlahnya oleh karena itu dibutuhkan sumber alternatif lain. Sumber energi yang mempunyai bahan baku dari air sebagai penggerak utama mempunyai potensi yang besar dan ketersediaannya sumber bahan baku yang mudah dan murah. Analisa dan perhitungan menggunakan software VBA sebagai add in ke sheet pada microsoft excel. Simulasi dilakukan dengan input data investment sebagai data awal yang dibutuhkan dan input beberapa parameter seperti VAT, interest, dll. Dari data input tersebut didapatkan hasil akhir untuk WACC yaitu 6.75%, IRR Project 10.88% (feasible), NPV Project 70.798.620 USD (feasible), BCR 1,36 (feasible), Payback Period 7 Tahun 8 Bulan, IRR Equity 12,95% (feasible), NPV Equity 30.057.140 USD (feasible). Hasil nilai NPV positif dan hasil perhitungan dikatakan feasible, maka proyek layak untuk dilaksanakan

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

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

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

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

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

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

AUTOMATION OF PROCESSING GEODETIC MEASUREMENTS BASED ON EVALUATION OF ACCURACY OF POSITIONING SPECIALIZED NETWORKS’ POINTS IN A PLANE COORDINATE SYSTEM

2020 ◽  
Author(s):  
Мурат Газизович Мустафин ◽  
Глеб Андреевич Фролов
Keyword(s):  
Coordinate System ◽  
Visual Basic ◽  
General Purpose ◽  
Automatic Evaluation ◽  
Microsoft Excel ◽  
Geodetic Measurements ◽  
Visual Basic For Applications ◽  
Visual Basic For Application

В данной работе рассматривается возможность использования вычислительных возможностей программ общего назначения при решении геодезических задач посредством использования пакетов Microsoft Excel, Visual Basic for Applications. В статье представлены результаты автоматизации процесса оценки плановой точности положения геодезических пунктов сети трилатерации. This paper reviews the implementation of computing capabilities of general-purpose programs for solving geodetic problems through Microsoft Excel, Visual Basic for Application. The paper presents solution for automatic evaluation of accuracy of positioning specialized networks’ points in a plane coordinate system.

scholarly journals AUTOMASI STOCK OPNAME BMN MELALUI PEMINDAIAN QR CODE MENGGUNAKAN APLIKASI VISUAL BASIC FOR APPLICATION

Jurnal Pari ◽  
2020 ◽  
Vol 5 (2) ◽  
pp. 125
Author(s):  
Edwin Yulia Setiawan
Keyword(s):  
Real Time ◽  
Visual Basic ◽  
Quick Response ◽  
Microsoft Excel ◽  
Response Code ◽  
Name Change ◽  
Software Application ◽  
Quick Response Code ◽  
Property Data ◽  
Visual Basic For Application

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.

scholarly journals Sistem Informasi Pembelian Bahan Baku Sockliner pada PT Sinar Utama Jaya Abadi

2021 ◽  
Vol 10 (2) ◽  
pp. 61-68
Author(s):  
Evita Sulis Tyanur ◽  
Rachmat Hidayat ◽  
Yusnia Budiarti
Keyword(s):  
Input Data ◽  
Visual Basic ◽  
Microsoft Excel ◽  
Purchase Order ◽  
Related Product

Intisari— Proses pembelian bahan baku memiliki peranan penting dalam proses produksi. Karena pembelian bahan baku merupakan sebuah awal kegiatan perusahaan dalam menghasilkan pendapatan. Tidak mungkin dalam suatu perusahaan dapat menyediakan sendiri kebutuhan untuk menjalankan roda perusahaan. Permasalahan yang ada pada saat ini proses pembelian bahan baku prosesnya masih dilakukan secara konvensional, Purchase Order (PO) di buat dengan menggunakan Microsoft Excel lalu dicetak dan dikirim kepada supplier via email/fax, hal ini sering terjadi kesalahan pada proses input data dan penyimpanan data belum terintegrasi oleh sistem sehingga kesulitan pada saat pencarian data selain itu dalam pembuatan laporan penerimaan barang, laporan permintaan barang dan laporan pembelian memerlukan waktu yang cukup lama untuk mengolah dan menggabungkan banyak data dalam Microsoft Excel. Tujuan dari penelitian ini adalah agar mempermudah, mempercepat dan mengurangi kesalahan dalam sistem pembelian bahan baku sockliner pada PT Sinar Utama Jaya Abadi untuk membantu mengolah data pembelian serta laporan perusahaan dengan mudah, cepat dan akurat. Metode yang digunakan dalam penelitian ini adalah model SDLC air terjun (waterfall) dan dalam pembuatan sistem ini, menggunakan Visual Studio dan MySQL. Hasil dari sistem yang telah dibuat adalah berupa sistem informasi pembelian bahan baku sockliner yang dapat mengelola informasi data. Kata Kunci— Sistem Informasi, Permintaan Barang, Pembelian Barang, Penerimaan Barang, Waterfall Referensi : [1]   A. A. Andryadi, “Perancangan Sistem Informasi Purchase Orderinternal Non Related Product Berbasis Web (Studi Kasus PT Shafco Multi Trading) MEDIA Inform., vol. 16, no. 1, pp. 57–69, 2017. [2]   A. Sauki, Warsino, and Y. M. Ardi, “Perancangan Sistem Informasi Pembelian Bahan Baku Pada Pt Nani Wahyuni Industries Bekasi,” J. Ilm. SANTIKA, vol. 9, no. 1, pp. 865–872, 2019. [3]   V. M. M. Siregar, “Sistem Informasi Pembelian dan Penjualan Pakaian pada Galoenk Distro Pematang Siantar,” J. Chem. Inf. Model., vol. 53, no. 49, pp. 13–26, 2017. [4]   D. Uswara and H. Patrie, “Perancangan sistem informasi pembelian dan penjualan toko elisa rizki dengan metodologi berorientasi obyek,” IDEALIS, vol. 2, pp. 297–301, 2019. 5]     A. Kristanto, Perancangan Sistem Informasi Dan Aplikasinya. Klaten: Gava Media, 2018. [6]   J. Enterprise, Otodidak Visual Basic. PT Elex Media Komputindo, 2017. [7]   Hardiyanto, Abdussomad, E. Haryadi, R. Sopandi, and Asep, “Penerapan Model Waterfall dan UML Dalam Rancang Bangun Program Pembelian Barang Berorientasi Objek pada PT Fujita Indonesia,” INTERKOM, vol. 13, pp. 1–12, 2019. [8]   Raharjo, Belajar Otodidak MySQL. Informatika Bandung, 2018. [9]   R. A. Sukamto and M. Shalahuddin, Rekayasa Perangkat Lunak Terstruktur dan Berorientasi Objek. Bandung: Informatika Bandung, 2018. [10] E. R. Yunita and N. Safitri, “Sistem Informasi Pengadaan Bahan Baku Berbasis Desktop Pada PT Inti Technik Sejahtera Bekasi,” Inf. Syst. Educ. Prof., vol. 4 No.1, no. 1, pp. 85–94, 2019. [11] Munawar, Analisa Perancangan Sistem Berorientasi Objek Dengan UML. Informatika Bandung, 2018.  

scholarly journals Rancang Bangun Sistem Informasi Inventory Berbasis Client Server pada PT Arpan Bali Utama di Denpasar

2020 ◽  
Vol 10 (3) ◽  
pp. 94-102
Author(s):  
Ayu Dwi Setiawati ◽  
◽  
I Made Dwi Jendra Sulastra ◽  
Keyword(s):  
Information System ◽  
Programming Language ◽  
Input Data ◽  
Visual Basic ◽  
Data Input ◽  
Client Server ◽  
Microsoft Access ◽  
Visual Basic For Applications ◽  
Data Search ◽  
Industrial Company

PT Arpan Bali Utama as an industrial company must always be responsive to the company's needs, because the company's production supplies the existing inventory. In this study, the design of an inventory information system for stock opname and warehouse card activities at PT Arpan Bali Utama. The design of this inventory information system is intended to solve problems related to the management of stock opname data and warehouse cards, both in data input and in computerization of stock opname reports and warehouse cards. This system was developed using the Visual Basic for Applications (VBA) programming language and a database developed using the Microsoft Access 2016 application. The results obtained from this study are an inventory information system designed to assist accounting and warehouse departments in carrying out stock opname activities. data input, data search, and production of stock opname reports and warehouse cards. In addition, this system can also help the accounting department through warehouse cards to see the movements of goods in the warehouse.

Mermaid

2018 ◽  
Vol 9 (3) ◽  
pp. 38-53
Author(s):  
F. S. Conte ◽  
A. Ahmadi
Keyword(s):  
Decision Support ◽  
Decision Support Tool ◽  
Visual Basic ◽  
National Standards ◽  
Decision Support Tools ◽  
Microsoft Excel ◽  
Support Tool ◽  
Support Tools ◽  
Visual Basic For Application ◽  
The U.S

Mermaid is a new decision support tool for managing shellfish growing areas. It is written in Visual Basic for Application (VBA) language and uses Microsoft Excel for input, calculation, and output modules. The program automatically imports the regulatory agency's data and generates scattergrams that can be used as decision support tools to help decide which shellfish growing areas should be closed and which ones should be open for harvest. The Mermaid program uses the equations developed by the Pearl model that provide more sensitive and accurate measures of sanitation safety for consumption of shellfish, and are more accurate than the U.S. National Standards.

scholarly journals Pengembangan Aplikasi Regresi Parameter Cuaca Berbasis Visual Basic For Application

2020 ◽  
Vol 6 (3) ◽  
Author(s):  
Bayu Bagus Riyandiarto ◽  
Nanda Noor Fadjrin
Keyword(s):  
Regression Analysis ◽  
Visual Basic ◽  
Field Analysis ◽  
Design Stage ◽  
P Value ◽  
Microsoft Excel ◽  
Application Program ◽  
Stage Of Development ◽  
Weather Parameters ◽  
Visual Basic For Application

Abstract — This research is the development of the Microsoft Excel VBA application to perform regression analysis between weather parameters in terms of data centering measures (PAMER11). The combination of parameters and data centering measures obtained 55 parameters that can be combined into 1,677,255,139,725 annual regression analysis outputs. The case study used in this study only calculates air humidity with temperature and air pressure observation variables, then the analysis results are compared with the results of the Excel Toolpak analysis data with the Anova. The development of this application method is carried out in 4 stages, namely: define, design, develop, adn dissemination. The defined stage includes analysis of the needs of researchers in the BMKG field, analysis coverage of the needs of BMKG in the form of regression analysis. The design stage includes format selection, application program selection, and initial design (prototype 1). The development stage includes validation (prototype 2) obtained a programming aspect value of 4.1325 valid criteria, comparison of Anova results from the output of the PAMER11 application and analysis of the Excel toolpak, the f-value is  with a p-value of 99% which results in the two calculations are significantly equal, for the display aspect get a value of 4,8175 valid criteria, limited and field product trials (prototype 3), where a limited trial was carried out on all faculty lecturers getting a score of 4.2440 very good criteria. Field trials conducted on the BMKG Cilacap got a score of 4.8333 very good criteria and data analysis at each stage of development has been improved towards the application program. Keywords — Development; Microsoft Excel; Visual Basic for Application (VBA); Regression Analysis; Weather Parameters

scholarly journals Excel alkalmazása normális eloszlás tesztelésére Shapiro-Wilk próbával

2018 ◽  
Vol 13 (1-2) ◽  
pp. 77-82
Author(s):  
György Hampel
Keyword(s):  
Visual Basic ◽  
Microsoft Excel ◽  
Visual Basic For Application

A Microsoft Excel Visual Basic fór Application programok segítségével nagyméretű adathalmazok szűrésével kapott adatsorain képes programozottan megismételni a számításokat. Több statisztikai programmal tudnánk a Shapiro-Wilk próbát alkalmazni normális eloszlás ellenőrzésére, de programozható módon erre csak az Excelt használhatjuk. Az Excel táblázatkezelő program segítségével felhasználóbarát kezelőfelületet alakítunk ki a számítások automatizált elvégzéséhez.

Sign in / Sign up

Export Citation Format

Share Document