APLIKASI LOG BOOK PEMELIHARAAN ALAT UJI BERKALA BERBASIS GOOGLE APPSHEET DI UPTD PKB KABUPATEN SRAGEN

UPTD PKB Sragen Regency monitors the function and condition of motor vehicle
periodic test equipment through a physical log book. The use of physical logbooks
lacks efficiency and effectiveness, including in the process of recording the results
of periodic test equipment maintenance. Digital logbook is a breakthrough to solve
the problem. By utilizing Google Appsheet as an extension that is integrated with
Google WorkSpace facilities (Google SpreadSheet, Google Calander, and Google
Drive), an application can be created with the function of digitizing previously used
physical logbooks. In its operation, data on the results of periodic test equipment
maintenance are stored in Google SpreadSheet as a data base. The application
provides 3 (three) main menus, namely the "Test Equipment" menu, with the
function of inputting maintenance data; the "Calendar" menu, with the function of
providing reminder schedules through calendars and pop up notifications; and the
"Guide" menu, with the function of providing access to periodic test equipment
maintenance manuals. To determine this application works, testing is carried out
through the black box test. From the design, the results obtained can accommodate
the data needed in the retrieval, although there are still shortcomings in the use of
language provision on the "Calendar" menu. The deficiency is caused by the
default of Google Calander.

Key Words: effectiveness, efficiency, menu, black box.