scholarly journals Evaluasi Metode Pendugaan Laju Evapotranspirasi Standar (ETo) Menggunakan Bahasa Pemograman Visual Basic Microsoft Excel di Kabupaten Nagan Raya Aceh

2021 ◽  
Vol 6 (1) ◽  
pp. 35-48
Author(s):  
Adlan ◽  
Budi Indra Setiawan ◽  
Chusnul Arif ◽  
Satyanto Krido Saptomo

Estimation of evaporation rate is needed in hydrological data, especially in irrigation and drainage planning data. The method for estimating the evapotranspiration rate recommended by FAO is the Penman - Monteith method, however apart from this method there are still several methods that can be used if the data obtained in the field are different. Evaluation of the method of estimating the rate of evapotranspration is expected to help in choosing the right method when different data is obtained, so with this evaluation, we can see the accuracy of the methods. The methods that are closest to accuracy with the Penman - Monteith method are Hargreaves, Makkink, Turc, Blaney-Cridlle and Penman. If ordered based on the ranking of the evaluation results, the method that is closest to the Penman - Monteith method is Hargreaves, because of all the evaluation variabels Hargreaves has the best evaluation value. While the closest model based on the best R2 value is the Jensen-Haise model, but the error value of this model is very high.

Author(s):  
Мурат Газизович Мустафин ◽  
Глеб Андреевич Фролов

В данной работе рассмотрен принцип работы созданного алгоритма, позволяющего автоматически определять среднюю квадратическую погрешность планового положения пунктов сетей трилатерации и представлены результаты автоматизации данного процесса при различных конфигурациях сети, с использованием пакетов Microsoft Excel, Visual Basic for Applications. This paper presents automatic solution for evaluating accuracy of positioning for specialized networks’ points in a plane coordinate system. The paper presents results of automation of this process through analysis of multiple configurations of trilateral networks using Microsoft Excel, Visual Basic for Applications.


2019 ◽  
Vol 11 (3) ◽  
pp. 328-341
Author(s):  
Rifki Ismal ◽  
Nurul Izzati Septiana

Purpose The demand for Saudi Arabian real (SAR) is very high in the pilgrimage (hajj) season while the authority, unfortunately, does not hedge the hajj funds. As such, the hajj funds are potentially exposed to exchange rate risk, which can impact the value of hajj funds and generate extra cost to the pilgrims. The purpose of this paper is to conduct simulations of Islamic hedging for pilgrimage funds to: mitigate and minimize exchange rate risk, identify and recommend the ideal time, amount and tenors of Islamic hedging for hajj funds, estimate cost saving by pursuing Islamic hedging and propose technical and general recommendations for the authority. Design/methodology/approach Forward transaction mechanism is adopted to compute Islamic forward between SAR and Rupiah (Indonesian currency) or IDR. Findings – based on simulations, the paper finds that: the longer the Islamic hedging tenors, the better is the result of Islamic hedging, the decreasing of IDR/USD is the right time to hedge the hajj funds and, on the other hand, the IDR/SAR appreciation is not the right time to hedge the hajj funds. Findings Based on simulations, the paper finds that: the longer the Islamic hedging tenors, the better is the result of Islamic hedging, the decreasing of IDR/USD is the right time to hedge the hajj funds and, on the other hand, the IDR/SAR appreciation is not the right time to hedge the hajj funds. Research limitations/implications The research suggests the authority to (and not to) hedge the hajj fund, depending on economic conditions and market indicators. Even though the assessment is for the Indonesian case, other countries maintaining hajj funds might also learn from this paper. Originality/value To the best of author’s knowledge, this is the first paper in Indonesia that attempts to simulate the optimal hedging of hajj funds.


Sensors ◽  
2021 ◽  
Vol 21 (12) ◽  
pp. 4141
Author(s):  
Wouter Houtman ◽  
Gosse Bijlenga ◽  
Elena Torta ◽  
René van de Molengraft

For robots to execute their navigation tasks both fast and safely in the presence of humans, it is necessary to make predictions about the route those humans intend to follow. Within this work, a model-based method is proposed that relates human motion behavior perceived from RGBD input to the constraints imposed by the environment by considering typical human routing alternatives. Multiple hypotheses about routing options of a human towards local semantic goal locations are created and validated, including explicit collision avoidance routes. It is demonstrated, with real-time, real-life experiments, that a coarse discretization based on the semantics of the environment suffices to make a proper distinction between a person going, for example, to the left or the right on an intersection. As such, a scalable and explainable solution is presented, which is suitable for incorporation within navigation algorithms.


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.


2011 ◽  
Vol 121-126 ◽  
pp. 867-871 ◽  
Author(s):  
Jie Li ◽  
Wei Wei Shan ◽  
Chao Xuan Tian

In order to evaluate the security of Application Specific Integrated Circuit (ASIC) implemented cryptographic algorithms at an early design stage, a Hamming distance model based power analysis is proposed. The Data Encryption Standard (DES) algorithm is taken as an example to illustrate the threats of differential power analysis (DPA) attack against the security of ASIC chip. A DPA attack against the ASIC implementation of a DES algorithm is realized based on hamming distance power model (HD model), and it realized the attack by successfully guessing the right 48-bit subkey. This result indicates that the power analysis attack based on the HD model is simple, rapid and effective for the design and evaluation of security chips.


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.


Author(s):  
A. V. Kedyk ◽  
M. V. Rishko ◽  
O. O. Kutsyn

Background. The lipid profiles of patients with overweight, obesity and healthy individuals, the citizens of Transcarpathia valley regions were analysed.Objective. The study was aimed at evaluation of dyslipidaemia frequency in patients with overweight and obesity, determination of expedience of statins prescription.Methods. All patients were divided into 2 groups: group 1 – patients with overweight; group 2 – patients with obesity of I and II degree. Estimation of lipid profile parameters was conducted by means of spectrophotometric device SIEMENS Dimension RxL Max. Statistical analysis of the data was conducted using Microsoft Excel 2007.Results. The patients with obesity had higher level of total cholesterol (6.03±0.53 mmol/l), lower HDL-C (1.15±0.07 mmol/l) and higher level of LDL-C (4.19±0.46 mmol/l) compare with overweight patients.In 46% of patients with overweight, dyslipidaemia was evidenced and required correction, 27% of them had high CVR and needed statin therapy, 19% of people with obesity had moderate CVR and didn’t need statins.77% of obese patients needed lipid correction, 54% of them with very high and averagely high level of CVR required statin therapy; 23% of people with obesity had moderate CVR and did not need statins.Conclusions. In the studied overweight and obese patients, atherogenic dyslipidaemia was established in 46% and 77% of cases respectively. Correction of dyslipidaemia with statin was compulsory for 27% of patients with overweight and for 54% with obesity.


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.  


2020 ◽  
Vol 7 (3) ◽  
pp. 358
Author(s):  
Widodo Arif Prabowo ◽  
Mesran Mesran ◽  
Siti Nurhabibah Hutagalung

The development of the computer world in the current era, the need to secure messages / data and for security in communication is very important. The author conducted this research aims to secure chat messages from client to server and vice versa. With this cryptographic technique used to convert chat messages into the form of certain codes with the intention that chat messages cannot be seen / read by anyone except people who have the right to read the chat messages. In this study, the Client and Server Message Chat encoding application is designed which implements the workings of encryption and decryption using the Spritz Algorithm. The results of this study are chat client and server message encoding applications with the Spritz algorithm that can encode confidential chat messages. This application was created using Microsoft Visual Basic 2008


Sign in / Sign up

Export Citation Format

Share Document