Development of A Soil Resistivity Calculator

Soil resistivity is an important parameter for designing electrical earthing system. The measurement of soil resistivity is greatly influenced by moisture content, temperature, porosity, degree of saturation, number of soil layer(s), and frequency of lightning current. Researchers have proposed various methodologies to provide an approximation of soil resistivity using the listed parameters. In order to ease the process of estimating soil resistivity at a particular area, there is a pressing need to devise a simple tool that enables the calculation of soil resistivity in the most accurate manner. As such, this research proposes a reliable tool for quick evaluation of soil resistivity based on various methodologies using Microsoft Excel’s built-in-functions and Visual Basic Application (VBA) Next, the developed tool was validated using two methods, in which the output value of the calculator was compared with data retrieved from IEEE Std 142-2007 and data reported in past studies. The validation results revealed that the developed calculator may serve as a significant application in future due to its time-saving and cost-effective attributes.

PENGARUH PENGGUNAAN POWERPOINT DENGAN VISUAL BASIC APPLICATION TERHADAP HASIL BELAJAR SISWA PADA MATERI FUNGSI INVERS DI SMK WIKRAMA BOGOR

The purpose of this study was to prove the effect of the use of powerpoint with Visual Basic Application (VBA) on student learning outcomes in the inverse function material. This VBA powerpoint is applied to students of SMK class XI Mathematics subject in Inverse Function at SMK Wikrama Bogor. The research method used is quantitative with a simple experimental design (Posttest Only Control Group Design). This study involved 2 groups, namely the control class and the experimental class. The experimental class was given treatment using powerpoint learning media with Visual Basic Application (VBA), while the control class was conventional learning. Each was given a post test. Based on the results of data processing, the results of the calculation of the average post-test value of each experimental class were 76.13 while the control class was 65.85. Based on these data, it shows that there are differences between the two groups, (1) The average value of the experimental class is above the minimum completeness criteria, which is 75, while the control class is below the minimum completeness criteria. (2) The experimental class gets more value for powerpoint learning media with Visual Basic Application (VBA) is able to improve student learning outcomes. ABSTRAKTujuan dari penelitian ini untuk membuktikan adanya pengaruh media pembelajaran powerpoint dengan Visual Basic Application (VBA) terhadap hasil belajar siswa pada materi fungsi invers. VBA powerpoint ini diterapkan pada siswa SMK kelas XI mata pelajaran Matematika materi Fungsi Invers di SMK Wikrama Bogor. Metode penelitian yang digunakan yaitu kuantitatif dengan desain eksperimen sederhana (Posttest Only Control Group Design). Penelitian ini melibatkan 2 kelompok yaitu kelas kontrol dan kelas eksperimen. Kelas ekperimen diberikan perlakuan menggunakan media pembelajaran powerpoint dengan Visual Basic Application (VBA), sedangkan kelas kontrol pembelajaran konvensional. Masing masing diberikan post test. Berdasarkan hasil pengolahan data menunjukkan hasil perhitungan nilai rata-rata post test dari masing masing kelas eksperimen 76,13 sedangkan kelas kontrol 65,85. Berdasarkan data tersebut menunjukkan adanya perbedaan dari kedua kelompok, yaitu (1) Nilai rata rata kelas eksperimen diatas kriteria ketuntasan minimal yaitu 75, sedangkan kelas kontrol dibawah kriteria ketuntasan minimal.(2) Kelas eksperimen memperoleh nilai lebih media pembelajaran powerpoint dengan Visual Basic Application (VBA) mampu meningkatkan hasil belajar siswa.

OPTIMALISASI JUMLAH KENDARAAN DAN RUTE DISTRIBUSI LOGISTIK PEMILIHAN DI KABUPATEN KEDIRI PADA MASA PANDEMI

Artikel ini membahas tentang permasalahan distribusi logistik pemilihan kepala daerah (Pemilihan) yang berkaitan dengan penentuan jumlah kendaraan yang tepat dan pemilihan rute terdekat dengan mempertimbangkan jarak yang dapat dilalui oleh kendaraan roda 4 atau lebih. Penentuan jumlah kendaraan dan rute yang tepat ini sangat penting bagi Komisi Pemilihan Umum (KPU) karena aspek logistik dan distribusi sangat berpengaruh dalam memastikan suara masyarakat tersampaikan dengan baik. Selain itu aspek ini memiliki keterkaitan satu dengan lainnya baik bersifat strategis maupun teknis. Selama pandemi, distribusi logistik Pemilihan tidak hanya berkaitan dengan kebutuhan alat pemungutan suara namun juga alat pelindung diri (APD) selama pelaksanaan pemungutan. Oleh karena itu kegiatan logistik menjadi lebih banyak dengan tetap mempertimbangkan protokol kesehatan sehingga diperlukan sebuah aplikasi yang dapat menentukan jumlah kendaraan dan rute yang tepat sebagai dasar untuk mempercepat pengambilan keputusan. Penelitian ini fokus pada penentuan jumlah kendaraan dan rute distribusi logistik yang optimal pada Pemilihan tahun 2020 di masa pandemic COVID-19 di KPU Kabupaten Kediri menggunakan pendekatan vehicle routing problem dengan memperhatikan jarak dari google maps serta menggunakan algoritma nearest neighbor dalam menentukan jarak terdekat antar titik. Aplikasi yang dikembangkan adalah penentuan rute menggunakan Visual Basic Application (VBA) pada Microsoft Excel. Penelitian ini menghasilkan jumlah kendaraan sebanyak 12 kendaraan untuk pengiriman logistik Pemilihan maupun APD dengan batas maksimal total perjalanan setiap truk sepanjang 100 km. Selain itu terdapat 6 kecamatan yang dikunjungi dua kali karena total kebutuhan melebihi kapasitas kendaraan.

Penentuan Klasifikasi Tanah Sistem Uscs (Unified Soil Classification System) dengan Bantuan Ms Excel

Klasifikasi tanah sistem unified (USCS) dilakukan utamanya menggunakan data distribusi butiran dan kadar air batas cair serta kadar air batas plastis. Proses penentuan klasifikasi cukup memakan waktu, jika dilakukan secara manual. Penelitian ini dimaksudkan untuk memudahkan pengklasifikasian tanah dengan memanfaatkan Visual Basic Application (VBA) yang ada di Ms. Excel. Hasil penelitian menunjukkan bahwa dengan menentukan format hasil uji distribusi butir dan batas atterberg, aplikasi yang dibuat dengan segera bisa mengklasifikasikan tanah. Aplikasi yang dibuat bisa menganalisis semua klasifikasi tanah sesuai dengan klasifikasi sistem unified.

Achieving broad absorption band and high incident angles by stochastically-distributed oblique-flat-sheet metamaterial perfect absorbers

In this work, we integrated a periodic seed layer and oblique deposition method to fabricate a stochastically-distributed oblique-flat-sheet metamaterial perfect absorber (MPA). Such design could increase its absorption bandwidth and tolerance to high angle-incidence due to the fact that various oblique flat sheets offer different resonance conditions while even a single oblique flat sheet could provide different optical paths for resonance. On the other hand, a seed layer could reduce uncertainty regarding to direct oblique deposition and provide abilities to manipulate the bandwidth of the MPA. We also setup a simulation model in the aids of Visual Basic Application and examined the absorption behavior of the MPA under TM and TE oblique incidence that could achieve high absorbance under 80° and 60° incidence, respectively. Finally, in measurement, the fabricated sample owns 65% absorbance within 80–250 THz and over 90% absorbance within 250–320 THz at x-polarization normal incidence; as for the y-polarization normal incidence, we could achieve overall 70% absorbance within 80–300 THz. The measured results reveal similar tendency compared to the simulated ones.

Development of Visual Basic Application Based Learning Media On Flat Building Materials

<p><em>This study aims to produce learning media based on a visual basic application of triangles and rectangles. This research is research and development. The method used in this research is a research and development method with a 4-D model (Four-D Model). This development model is modified into 3-D, only until the development stage (Develop). The instrument used in this study was a questionnaire used to assess the validity and practicality of the teaching materials. The validity questionnaire was given to 2 experts in the field of mathematics education and media while the practicality questionnaire was given to students. This research produces learning media based on a visual basic application that is valid, very practical, and effective for use in learning</em><em></em></p>

Developing Excel-VBA Spreadsheet for Truss Element Analysis and Design

In this paper EXCEL Visual Basic application spreadsheet has used in analyzing and designing truss elements. EXCEL spreadsheet was developed to draw and analyzes different type of truss elements for tension and compression forces. The truss members were tested under dead, imposed, and wind load. Members capacity was provided according to BS 5950. Different type of joints connection was designed and recommended for support and internal joints.

The COVID-19 Infodemic: The complex task of elevating signal and eliminating noise

In Situation Report #3 and 39 days before declaring COVID-19 a pandemic, the WHO declared a -19 infodemic. The volume of coronavirus tweets was far too great for one to find accurate or reliable information. Healthcare workers were flooded with which drowned the of valuable COVID-19 information. To combat the infodemic, physicians created healthcare-specific micro-communities to share scientific information with other providers. We analyzed the content of eight physician-created communities and categorized each message in one of five domains. We coded 1) an application programming interface to download tweets and their metadata in JavaScript Object Notation and 2) a reading algorithm using visual basic application in Excel to categorize the content. We superimposed the publication date of each tweet into a timeline of key pandemic events. Finally, we created NephTwitterArchive.com to help healthcare workers find COVID-19-related signal tweets when treating patients. We collected 21071 tweets from the eight hashtags studied. Only 9051 tweets were considered signal: tweets categorized into both a domain and subdomain. There was a trend towards fewer signal tweets as the pandemic progressed, with a daily median of 22% (IQR 0-42%. The most popular subdomain in Prevention was PPE (2448 signal tweets). In Therapeutics, Hydroxychloroquine/chloroquine wwo Azithromycin and Mechanical Ventilation were the most popular subdomains. During the active Infodemic phase (Days 0 to 49), a total of 2021 searches were completed in NephTwitterArchive.com, which was a 26% increase from the same time period before the pandemic was declared (Days −50 to −1). The COVID-19 Infodemic indicates that future endeavors must be undertaken to eliminate noise and elevate signal in all aspects of scientific discourse on Twitter. In the absence of any algorithm-based strategy, healthcare providers will be left with the nearly impossible task of manually finding high-quality tweets from amongst a tidal wave of noise.

The COVID-19 Infodemic (Preprint)

BACKGROUND In Situation Report #13 and 39 days before declaring COVID-19 a pandemic, the WHO declared a “COVID-19 infodemic”. The volume of coronavirus tweets was far too great for one to find accurate or reliable information. Healthcare workers were flooded with “noise” which drowned the “signal” of valuable COVID-19 information. To combat the infodemic, physicians created healthcare-specific micro-communities to share scientific information with other providers. OBJECTIVE Our objective was to eliminate noise and elevate signal tweets related to COVID-19 and provide easy access to the most educational tweets for medical professionals who were searching for information. METHODS We analyzed the content of eight physician-created communities and categorized each message in one of five domains. We coded 1) an application programming interface to download tweets and their metadata in JavaScript Object Notation and 2) a reading algorithm using visual basic application in Excel to categorize the content. We superimposed the publication date of each tweet into a timeline of key pandemic events. Finally, we created NephTwitterArchive.com to help healthcare workers find COVID-19-related signal tweets when treating patients. RESULTS We collected 21071 tweets from the eight hashtags studied. Only 9051 tweets were considered signal: tweets categorized into both a domain and subdomain. There was a trend towards fewer signal tweets as the pandemic progressed, with a daily median of 22% (IQR 0-42%). The most popular subdomain in Prevention was PPE (2448 signal tweets). In Therapeutics, Hydroxychloroquine/chloroquine wwo Azithromycin and Mechanical Ventilation were the most popular subdomains. During the active Infodemic phase (Days 0 to 49), a total of 2021 searches were completed in NephTwitterArchive.com, which was a 26% increase from the same time period before the pandemic was declared (Days -50 to -1). CONCLUSIONS The COVID-19 Infodemic indicates that future endeavors must be undertaken to eliminate noise and elevate signal in all aspects of scientific discourse on Twitter. In the absence of any algorithm-based strategy, healthcare providers will be left with the nearly impossible task of manually finding high-quality tweets from amongst a tidal wave of noise. CLINICALTRIAL not applicable

Shortest Route Application via Dynamic Programming in the Transportation Networks

The purpose of this study is to develop an application for finding the shortest path in the transportation sector. The application was developed using the dynamic programming method in MS Excel Visual Basic application. These types of problems are also called stagecoach problems. The purpose of the problem is finding the shortest path between the starting point (node) and the destination point. Values are related to the roads in the network to specify the distance between two nodes. In case of a small number of nodes (activities), a solution can be reached by evaluating all options. But the number of possible options to be scanned for real problems is quite large. In such cases, a suitable method is needed for the solution. It can produce effective solutions with the dynamic programming approach.