Application of google sheets in managing outbound shipping document data

Abstract

This research aimed to explore the application of Google sheets for managing outbound maritime document data and to reduce the time required for data entry and the calculation of outbound cargo weight. The sample group consisted of five employees from the outbound documentation department of a case study company, who were responsible for managing data and documents for customers. The researcher employed Google sheets experimentally with the purposive sample group. Data analysis involved structure repetitive workflow diagrams and using fishbone diagram (Ishikawa model) to identify the core problems, subsequently applying. Google sheets.  The performance was evaluated through a pre- and post- implementation trial using a total of 40 sets of export tasks. The findings revealed that: 1) the application of Google sheets in managing outbound maritime document data improved operational efficiency and generated positive organizational outcomes. Furthermore, it efficiently assisted in calculating large volumes of numerical data and facilitated effective data modification during operation. 2) The implementation of Google sheets resulted in time reduction.  Prior to implementation, the average total time was 15.79 minutes, while post – implementation, the average total time was 5.74 minutes. This contributed to a reduction in operational errors and minimized the overall time consumption by 10.05 minutes.