DIGITALISASI SISTEM PELAPORAN UNIT APRON MOVEMENT CONTROL DI BANDAR UDARA AJI PANGERAN TUMENGGUNG PRANOTO SAMARINDA // DIGITALIZATION OF THE REPORTING SYSTEM OF THE APRON MOVEMENT CONTROL UNIT AT AJI PANGERAN TUMENGGUNG PRANOTO AIRPORT SAMARINDA

Unit Apron Movement Control (AMC) Bandar Udara Aji Pangeran Tumenggung Pranoto Samarinda mengalami permasalahan dalam sistem pelaporan operasional yang masih menggunakan AMC Sheet berbasis Microsoft Excel secara lokal tanpa pencadangan cloud, sehingga rentan mengalami kehilangan data. Permasalahan lain yang timbul adalah proses double entry, yaitu data pada AMC Sheet harus diinput ulang secara manual ke dalam dokumen laporan harian dan bulanan yang terpisah, sehingga menimbulkan inefisiensi waktu kerja serta potensi selisih data. Selain itu, pimpinan unit belum memiliki akses data operasional secara real-time. Penelitian ini bertujuan merancang sistem digitalisasi pelaporan bernama "E-data AMC APT Pranoto" yang mengintegrasikan AMC Sheet berbasis Google Spreadsheet sebagai basis data dan media input terpusat dengan Google AppSheet sebagai dashboard visualisasi bagi pimpinan unit. Metode penelitian menggunakan Research and Development (R&D) Level 1 dengan tahapan potensi masalah, pengumpulan data, desain produk, validasi desain, hingga desain teruji. Hasil validasi oleh Ahli Materi memperoleh skor 96% dan Ahli Media 87%, dengan ratarata keseluruhan 91% pada kategori "Sangat Layak". Rancangan sistem ini terbukti mampu menghilangkan proses double entry melalui otomasi rumus Spreadsheet, menjamin keamanan data melalui penyimpanan cloud, serta menyediakan akses informasi secara real-time bagi pimpinan Unit AMC, sehingga direkomendasikan untuk diimplementasikan guna meningkatkan efisiensi dan akurasi pelaporan operasional. // The Apron Movement Control (AMC) Unit at Aji Pangeran Tumenggung Pranoto Airport Samarinda faces challenges in its reporting system, which still relies on a locally stored Microsoft Excel file called the AMC Sheet without cloud backup, making it vulnerable to data loss. Another issue is double entry, where data recorded in the AMC Sheet must be manually re-entered into separate daily and monthly reports, causing inefficiency and potential data discrepancies. Furthermore, unit leadership lacks real-time access to operational data. This research designs a digital reporting system called "E-data AMC APT Pranoto" that integrates a cloud-based AMC Sheet using Google Spreadsheet as the centralized database and input medium with Google AppSheet as a visualization dashboard for leadership. The research employs the Research and Development (R&D) Level 1 method, covering stages from potential and problems, data collection, product design, design validation, to tested design. Expert validation results show a score of 96% from the Material Expert and 87% from the Media Expert, with an overall average of 91%, categorized as "Highly Feasible." The system design proves capable of eliminating double entry through Spreadsheet formula automation, ensuring data security via cloud storage, and providing real-time information access for AMC leadership, and is recommended for implementation to improve reporting efficiency and accuracy.