Article Per Year (5 Year)
p-Index From 2021 - 2026
0.23
P-Index
This Author published in this journals
All Journal Journal of Information Technology and its Utilization
Andini Nareswari Rifaat
Sekolah Vokasi UGM
Computer Science & IT Engineering

Published : 1 Documents Claim Missing Document
Claim Missing Document
Check
Articles

Found 1 Documents
Search

 1 
Lightweight Retrieval-Augmented Generation Based on Google Sheets as a Dynamic Knowledge Base for the Maritime BMKG Teluk Bayur Shipping Safety Chatbot Andini Nareswari Rifaat; Budi Iman Samiaji
Journal of Information Technology and Its Utilization Vol 9 No 1 (2026): May 2026
Publisher : Sekolah Tinggi Multi Media

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.56873/jitu.9.1.6089

Abstract

Maritime weather information is critical for shipping safety in archipelagic countries such as Indonesia. However, current dissemination methods at the Teluk Bayur Maritime Meteorological Station rely on one-way infographic distribution through social media, lacking interactive communication capabilities. This study presents a lightweight Retrieval-Augmented Generation (RAG)-based chatbot that integrates Google Sheets as a dynamic knowledge base for real-time maritime weather dissemination through a conversational interface. The system was implemented using Python and Streamlit within a four-layer monolithic architecture and covers six information categories, including early warnings, three-day weather summaries, and vessel safety recommendations across nine maritime regions in West Sumatra for four vessel types. A rule-based decision support module classifies sailing conditions as safe (aman) or cautionary (waspada) based on wind speed and wave height thresholds defined by Meteorological, Climatological and Geophysics Agency of Indonesian (BMKG). Functional testing confirmed accurate responses across all menu features and free-form queries. Quantitative evaluation using 50 queries, scored on a 0–1 scale using ROUGE-L and TF-IDF cosine similarity, showed that the RAG-enabled model achieved an overall mean score of 0.2285, compared to 0.1425 for the non-RAG baseline (+0.0860) demonstrating that structured context grounding effectively reduces hallucination and enhances information reliability for maritime safety applications.
Co-Authors Budi Iman Samiaji