Development of A Soil Resistivity Calculator

2021 ◽  
Vol 3 (2) ◽  
pp. 14-20
Author(s):  
Muhd Anas Ezhar ◽  
Chun Lim Siow

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.

Author(s):  
Khaulah Afifah ◽  
Lala M Kolopaking ◽  
Zessy Ardinal Barlan

Head of a village election with e-voting system is a new thing for community The success level of e-voting system can be reached by fulfil several principles in order to the implementation going effective and the result of the election can be accepted by all. The objectives of this research is to analyze the relation between the success level of e-voting system with social capital of the community. This research is carried out with the quantitative approach and supported by qualitative data. This research takes 60 respondents using simple random sampling technique. The results showed that the success level of e-voting has a correlation with the level of social capital of the community. Based on the field study, the social capital of the community is classified as high. The high social capital makes the implementation of e-voting successful and the success level is also high, because in the election ten years ago occurred a conflict. The community considers e-voting easier and more practical, cost effective and time-saving, and the results of e-voting are also reliable. A practical and fast of e-voting system can be a solution especially for “rural-urban” community who are busy or work outside the village.Keywords: E-voting, the success level of the system, social capital Pemilihan kepala desa dengan sistem e-voting merupakan hal yang baru bagi masyarakat. Keberhasilan penerapan sistem e-voting dilihat dari terpenuhinya beberapa prinsip agar penerapannya berlangsung efektif dan hasilnya dapat diterima oleh seluruh masyarakat. Penelitian ini bertujuan untuk menganalisis hubungan tingkat keberhasilan sistem e-voting dalam pemilihan kepala desa dengan tingkat modal sosial masyarakat. Bentuk penelitian ini adalah penelitian kuantitatif yang didukung oleh analisis data kualitatif. Penelitian ini mengambil enam puluh responden dengan teknik simple random sampling. Hasil penelitian menunjukkan bahwa tingkat keberhasilan e-voting memiliki hubungan dengan tingkat modal sosial masyarakat. Berdasarkan kajian di lapang, modal sosial masyarakat tergolong tinggi. Tingginya modal sosial tersebut membuat pelaksanaan e-voting berhasil dan tingkat keberhasilannya juga tergolong tinggi karena pada pemilihan sepuluh tahun silam sempat terjadi konflik. Masyarakat menganggap sistem evoting lebih mudah dan praktis, hemat dalam segi biaya dan waktu, serta hasil dari pemilihan juga dapat dipertanggungjawabkan. Sistem e-voting yang praktis dan cepat dapat menjadi solusi khususnya bagi masyarakat daerah “desa-kota” yang memiliki kesibukan atau pekerjaan di luar desa.Kata Kunci: E-voting, keberhasilan sistem, modal sosial. 


2020 ◽  
Vol 16 (2) ◽  
pp. 135-144
Author(s):  
Ravneet K. Grewal ◽  
Baldeep Kaur ◽  
Gagandeep Kaur

Background: Amylases are the most widely used biocatalysts in starch saccharification and detergent industries. However, commercially available amylases have few limitations viz. limited activity at low or high pH and Ca2+ dependency. Objective: The quest for exploiting amylase for diverse applications to improve the industrial processes in terms of efficiency and feasibility led us to investigate the kinetics of amylase in the presence of metal ions as a function of pH. Methods: The crude extract from soil fungal isolate cultures is subjected to salt precipitation, dialysis and DEAE cellulose chromatography followed by amylase extraction and is incubated with divalent metal ions (i.e., Ca2+, Fe2+, Cu2+, and Hg2+); Michaelis-Menton constant (Km), and maximum reaction velocity (Vmax) are calculated by plotting the activity data obtained in the absence and presence of ions, as a function of substrate concentration in Lineweaver-Burk Plot. Results: Kinetic studies reveal that amylase is inhibited un-competitively at 5mM Cu2+ at pH 4.5 and 7.5, but non-competitively at pH 9.5. Non-competitive inhibition of amylase catalyzed starch hydrolysis is observed with 5mM Hg2+ at pH 9.5, which changes to mixed inhibition at pH 4.5 and 7.5. At pH 4.5, Ca2+ induces K- and V-type activation of amylase catalyzed starch hydrolysis; however, the enzyme has V-type activation at 7mM Ca2+ under alkaline conditions. Also, K- and V-type of activation of amylase is observed in the presence of 7mM Fe2+ at pH 4.5 and 9.5. Conclusion: These findings suggest that divalent ions modulation of amylase is pH dependent. Furthermore, a time-saving and cost-effective solution is proposed to overcome the challenges of the existing methodology of starch hydrolysis in starch and detergent industries.


2014 ◽  
Vol 31 (7) ◽  
pp. 788-810 ◽  
Author(s):  
Claudia Paciarotti ◽  
Giovanni Mazzuto ◽  
Davide D’Ettorre

Purpose – The purpose of this paper is to propose a cost-effective, time-saving and easy-to-use failure modes and effects analysis (FMEA) system applied on the quality control of supplied products. The traditional FMEA has been modified and adapted to fit the quality control features and requirements. The paper introduces a new and revised FMEA approach, where the “failure concept” has been modified with “defect concept.” Design/methodology/approach – The typical FMEA parameters have been modified, and a non-linear scale has been introduced to better evaluate the FMEA parameters. In addition, two weight functions have been introduced in the risk priority number (RPN) calculus in order to consider different critical situations previously ignored and the RPN is assigned to several similar products in order to reduce the problem of complexity. Findings – A complete procedure is provided in order to assist managers in deciding on the critical suppliers, the creation of homogeneous families overcome the complexity of single product code approach, in RPN definition the relative importance of factors is evaluated. Originality/value – This different approach facilitates the quality control managers acting as a structured and “friendly” decision support system: the quality control manager can easily evaluate the critical situations and simulate different scenarios of corrective actions in order to choose the best one. This FMEA technique is a dynamic tool and the performed process is an iterative one. The method has been applied in a small medium enterprise producing hydro massage bathtub, shower, spas and that commercializes bathroom furniture. The firm application has been carried out involving a cross-functional and multidisciplinary team.


Author(s):  
Shay I. Duvdevani ◽  
Hadas Knoller ◽  
Noa Rozendorn ◽  
Eran E. Alon ◽  
Ory Madgar

AbstractCongenital ear anomalies are associated with psychological morbidity. Ear deformities can usually be corrected by nonsurgical techniques such as splinting or molding in the neonatal period, initiated before 6 weeks. Without early corrections, many will require otoplasty during childhood. We introduce a novel silicone-based custom mold technique for congenital ear anomalies. The highly malleable silicone was pushed into every part of the auricle, enabling the auricle to remain in the desired shape, with new molds made weekly. Of 31 newborns (18 males, 13 females), 54 ears were treated. Average age at treatment initiation was 26.8 days. The mean treatment duration was 43.2 days, with a median of 28 days. Normal appearance and parent's satisfaction were achieved in 30 patients with 49 deformed ears and also in four newborns older than 6 weeks. Three concha type microtia in two patients achieved great improvements and parents' satisfaction. No complications were reported. Marked aesthetic improvements and normal appearance were achieved for all deformed auricles treated, and improvements in the concha type microtia will partially alleviate future surgical corrections. The results are not inferior to other techniques. The advantages are as follows: cost-effective, time-saving, simple to master, no need for hair shaving, and easy use for parents. Patients older than 6 weeks of age achieved normal auricle appearance, enabling the correction in older newborns. Custom made silicone auricle molding offers a simple nonsurgical technique for correcting congenital ear anomalies, alleviating the need for future surgical corrections.


2020 ◽  
Vol 70 (4) ◽  
pp. 439-447
Author(s):  
Juan J. González ◽  
Henry Quesada ◽  
Sailesh Adhikari ◽  
Brian Bond ◽  
Shawn Grushecky

Abstract This article introduces a total revenue forecasting tool designed for calculating the economic output of visually graded hardwood lumber. The tool integrates Monte Carlo simulation from previous studies' data, providing a pseudoestimation of total board-feet based on log grades. The lumber output from different log groups is modeled using probability distributions for each lumber grade. The estimated volume output is multiplied by the respective price for each grade, leading to an expected amount of economic output for given log-grades. The tool was implemented using Microsoft Excel 2016 and Visual Basic. This work provides hardwood lumber producers with a valuable and simple tool to determine different scenarios of total income from each log, as established by the user with a statistical perspective. This total revenue forecasting tool provides the industry with a way to reduce waste and estimate their potential revenue by maximizing the interaction between the log yield's variables and providing the economic output of log, leading to an improvement of the economy of the hardwood market.


2009 ◽  
Vol 24 (1) ◽  
pp. 245-252 ◽  
Author(s):  
Robert Ianoş

Single-phase nanocrystalline 4CaO·Al2O3·Fe2O3 powders were prepared directly from the combustion reaction using a new cost-effective, time-saving, and environmentally friendly version of solution combustion synthesis. Instead of a single fuel, a fuel mixture of urea and β-alanine was used. It was shown by x-ray diffraction, energy-dispersive x-ray analysis, thermogravimetric analysis, and optical microscopy that this new version of the solution combustion synthesis allows the maximization of the exothermic effect associated with the combustion reaction. On the other hand, it was shown that the traditional version of combustion synthesis involving the use of a single fuel, such as urea or β-alanine, does not ensure the formation of Ca4Al2Fe2O10 unless subsequent thermal treatments are applied. It was suggested that the occurrence of combustion reactions cannot be regarded only in terms of adiabatic temperature, as the kinetic aspects overrule the thermodynamic ones.


2019 ◽  
Vol 3 (2) ◽  
pp. 95-107
Author(s):  
Euis Eti Rohaeti ◽  
Martin Bernard ◽  
Chandra Novtiar

Penelitian ini memiliki tujuan mengetahui pengaruh media pembelajaran Visual Basic Application (VBA) for Microsoft Powerpoint dan Excel pada materi peluang terhadap kemampuan penalaran matematis siswa SMP. Sampel pada penelitian ini adalah 23 siswa kelas VIII salah satu SMP di Kota Cimahi Tahun Pelajaran 2018/2019. Pengambilan data diperoleh dengan metode tes untuk menentukan kemampuan penalaran matematis siswa yang kemudian dianalisis ketercapaian dan kesulitan siswa pada setiap indikator yang menjadi dasar pengembangan media pembelajaran. Media kemudian diujicobakan kembali dalam pembelajaran. Hasil dari penelitian ini adalah adanya pengaruh media pembelajaran Visual Basic Application (VBA) for Microsoft Powerpoint dan Excel dalam meningkatkan kemampuan penalaran siswa pada materi peluang, dan media tersebut dapat membantu guru saat menggunakan pendekatan Open-Ended sehingga pembelajaran di kelas lebih efektif, serta menciptakan pembelajaran peluang menjadi interaktif dan menyenangkan.


2021 ◽  
Vol 3 (1) ◽  
pp. 1-25
Author(s):  
Eka Wisnu Wardhana ◽  
Oki Anita Candra Dewi

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.


2018 ◽  
Vol 7 (3.2) ◽  
pp. 732 ◽  
Author(s):  
Martin Bernard ◽  
Eva Dwi Minarti ◽  
Masta Hutajulu

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.  


2011 ◽  
Vol 9 (2) ◽  
pp. 300-304 ◽  
Author(s):  
S. Negrão ◽  
C. Almadanim ◽  
I. Pires ◽  
K. L. McNally ◽  
M. M. Oliveira

Rice is a salt-sensitive species with enormous genetic variation for salt tolerance hidden in its germplasm pool. The EcoTILLING technique allows us to assign haplotypes, thus reducing the number of accessions to be sequenced, becoming a cost-effective, time-saving and high-throughput method, ideal to be used in laboratories with limited financial resources. Aiming to find alleles associated with salinity tolerance, we are currently using the EcoTILLING technique to detect single nucleotide polymorphisms (SNPs) and small indels across 375 germplasm accessions representing the diversity available in domesticated rice. We are targeting several genes known to be involved in salt stress signal transduction (OsCPK17) or tolerance mechanisms (SalT). So far, we found a total of 15 and 23 representative SNPs or indels in OsCPK17 and SalT, respectively. These natural allelic variants are mostly located in 3′-untranslated region, thus opening a new path for studying their potential contribution to the regulation of gene expression and possible role in salt tolerance.


Sign in / Sign up

Export Citation Format

Share Document