Claim Missing Document
Check
Articles

Found 13 Documents
Search

Pengembangan aplikasi persuratan berbasis Excel VBA untuk mengoptimalisasi layanan administrasi di Desa Batulaya Ade Mulawarman; Farid Wajidi; Rahmiyatal Munaja; Andi Nur Fiqhi Utami; Candaria Candaria
SELAPARANG: Jurnal Pengabdian Masyarakat Berkemajuan Vol 9, No 4 (2025): Juli
Publisher : Universitas Muhammadiyah Mataram

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.31764/jpmb.v9i4.32541

Abstract

Abstrak Program pengabdian masyarakat di Desa Batulaya bertujuan untuk meningkatkan efisiensi administrasi desa melalui pengembangan aplikasi berbasis Excel VBA. Aplikasi ini dirancang untuk mempermudah pembuatan dan pengelolaan surat menyurat, yang sebelumnya dilakukan secara manual. Proses manual ini sering kali memakan waktu lama dan rentan terhadap kesalahan administratif. Melalui pelatihan dan pendampingan implementasi, aparat desa diajarkan cara mengoperasikan aplikasi, memodifikasi template surat, dan mengotomatisasi tugas administratif lainnya. Evaluasi terhadap hasil implementasi menunjukkan adanya peningkatan signifikan dalam efisiensi kerja aparat desa, dengan pengurangan waktu pembuatan surat dari rata-rata 15 menit menjadi hanya 5 menit. Selain itu, aplikasi ini berhasil mengurangi kesalahan administratif yang sering terjadi pada proses manual, meningkatkan akurasi data, dan memperbaiki sistem pengarsipan. Dengan antarmuka sederhana, aplikasi ini mudah digunakan bahkan bagi pengguna dengan pengetahuan teknologi terbatas. Inovasi ini memberikan solusi teknologi yang tepat guna dan berpotensi untuk direplikasi di desa-desa lain dengan tantangan serupa. Program ini juga memberikan dampak jangka panjang berupa peningkatan kapasitas sumber daya manusia desa dalam memanfaatkan teknologi informasi untuk mendukung administrasi yang lebih modern dan efisien. Kata kunci: aplikasi excel VBA; administrasi desa; efisiensi administrasi; pelatihan teknologi informasi; pengarsipan surat  Abstract The community service program in Batulaya Village aims to improve administrative efficiency through the development of an Excel VBA-based application. This application is designed to simplify the creation and management of letters, which were previously done manually. Manual processes often took a long time and were prone to administrative errors. Through training and implementation assistance, village officials were taught how to operate the application, modify letter templates, and automate other administrative tasks. The evaluation of the implementation results showed a significant improvement in the work efficiency of village officials, reducing the time required to create a letter from an average of 15 minutes to just 5 minutes. Additionally, the application successfully reduced administrative errors, enhanced data accuracy, and improved the document archiving system. With its simple interface, the application is easy to use even for users with limited technological knowledge. This innovation provides an appropriate technological solution and has the potential to be replicated in other villages facing similar challenges. The program also delivers long-term impacts by enhancing the human resource capacity of the village in utilizing information technology to support more modern and efficient administration. Keywords: excel VBA application; village administration; administrative efficiency; information technology training; letter archiving
Spatial Statistic Modeling for Rice Field Area Prediction Year 2026 to 2030 in Polewali Mandar Regency Mulawarman, Ade; Utami A, Widyanti; Priadmodjo, Anggit; Munaja, Rahmiyatal; Erwin, Muh. Alfarezi; Al-faridzi, Muh. Reza
Journal of Green Science and Technology Vol 10 No 1 (2026): Journal of Green Science and Technology Vol. 10 No.1 March 2026
Publisher : Faculty of Engineering, Universitas Swadaya Gunung Jati

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.33603/jgst.v10i1.11646

Abstract

The sustainability of rice fields is fundamental to maintaining regional food security, particularly in agricultural production centers such as Polewali Mandar Regency, West Sulawesi, Indonesia. Rapid population growth and spatial development have intensified pressure on productive agricultural land, increasing the risk of long-term decline in rice field availability. This study develops a spatial statistical modeling framework to predict the distribution of rice field conversion for the period 2026–2030 using an integration of Frequency Ratio (FR) and Spatial Multi-Criteria Analysis (SMCA) within a Geographic Information System (GIS) environment. Land cover data from 2010 and 2020 were used to identify historical conversion patterns and to construct predictive variables. Ten driving factors—including topography, slope, geomorphology, soil type, rainfall, accessibility, settlement characteristics, and spatial policy direction—were evaluated alongside protected agricultural zones as limiting constraints. Model validation using the Receiver Operating Characteristic (ROC) curve produced an AUC of 0.83 (success rate) and 0.75 (predictive rate), indicating good and reliable model performance. The projection results demonstrate continued pressure on rice field areas, particularly in zones influenced by infrastructure and settlement expansion. By providing spatially explicit predictions, this study offers a decision-support tool for proactive land-use regulation, agricultural protection policies, and strategic planning interventions aimed at safeguarding food self-sufficiency in the medium term.
GIS-Based Evaluation of The Integrated Waste Management Site in Sidodadi Village Al-Faridzi, Muh. Reza; Mulawarman, Ade; Priadmodjo, Anggit; Mukhlis, Jafar; Saputra, Ade Guna
Journal of Green Science and Technology Vol 10 No 1 (2026): Journal of Green Science and Technology Vol. 10 No.1 March 2026
Publisher : Faculty of Engineering, Universitas Swadaya Gunung Jati

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.33603/jgst.v10i1.11650

Abstract

This study evaluates the effectiveness of the Integrated Waste Management Facility (TPST) service in Sidodadi Sub-district, Wonomulyo District, Polewali Mandar Regency, using a spatial analysis approach based on the location–allocation method implemented in ArcGIS. The research is motivated by the high population density of Sidodadi, which has led to an increase in waste generation, while only a single TPST facility is currently operational. A quantitative descriptive method was applied, utilizing primary data from field observations and secondary spatial data, including building point data, road network data, and high-resolution satellite imagery. Spatial analysis was conducted by mapping waste generation at the building level, performing network-based distance analysis along the road network (as opposed to straight-line/Euclidean distance), and modeling TPST service coverage using a location– allocation model. The model parameters included a service distance cutoff of ≤ 1 km and facility capacity constraints based on the maximum number of households that can be served within a given facility. The results indicate that the existing TPST can serve approximately 600 households, corresponding to only about 15,84 % of the total residential buildings in Sidodadi Sub-district. Consequently, a significant proportion of densely populated residential areas remains outside the effective service coverage. This limited coverage is primarily influenced by insufficient facility capacity and service distances exceeding the defined cutoff. The study recommends the development of additional TPST facilities at strategically selected locations to increase service coverage percentage and enhance the efficiency and sustainability of waste management in Sidodadi Sub-district.