Transformasi Spreadsheet menjadi Diagram Business Process Model and Notation melalui Pendekatan Rule-Based
TIN: Terapan Informatika Nusantara · 21.12.2025 · 6 (7) · 1003-1014
DOI: 10.47065/tin.v6i7.8868 ↗Kurz gefasst
Fachartikel in der Zeitschrift TIN: Terapan Informatika Nusantara, online erschienen am 21.12.2025. Verfasst von Teguh Budi Santoso und 1 weiteren Autor:innen. Der Volltext ist frei zugänglich (Open Access, CC BY 4.0).
Abstract (Originalsprache)
Business process modeling plays an essential role in helping organizations improve operational efficiency and maintain process consistency. However, many organizations still rely on spreadsheets as a medium for documenting processes, which requires manual interpretation before being converted into Business Process Model and Notation (BPMN) diagrams. This study develops an automated rule-based method to transform spreadsheet content directly into BPMN diagrams. Each row in the spreadsheet is analyzed and mapped into process elements such as activities, events, decision points, and process flows. The method includes data normalization, structural mapping, BPMN XML construction, and structural validation to ensure compliance with BPMN standards. The experiments were conducted using three business process datasets from cooperative finance, poultry farming, and academic writing services. Each process contained between 21 and 29 activities, providing sufficient structural variation to assess the reliability of the method. The similarity between the automatically generated diagrams and manually created diagrams was measured using a label-based similarity approach, yielding values ranging from 0.85 to 1.00. These results indicate that the automated rule-based method can produce BPMN diagrams that closely reflect the accuracy of human-created models. This study offers practical benefits such as faster process modeling, improved documentation consistency, and support for business process digitalization in organizations that rely on spreadsheets as their primary source of process information.
Zitieren
APA
Santoso, T. B., & Yaqin, M. A. (2025). Transformasi Spreadsheet menjadi Diagram Business Process Model and Notation melalui Pendekatan Rule-Based. TIN: Terapan Informatika Nusantara, 6(7), 1003-1014. https://doi.org/10.47065/tin.v6i7.8868
Vancouver
Santoso TB, Yaqin MA. Transformasi Spreadsheet menjadi Diagram Business Process Model and Notation melalui Pendekatan Rule-Based. TIN: Terapan Informatika Nusantara. 2025;6(7):1003-1014. doi:10.47065/tin.v6i7.8868
BibTeX
@article{Santoso2025,
author = {Santoso, Teguh Budi and Yaqin, Muhammad Ainul},
title = {Transformasi Spreadsheet menjadi Diagram Business Process Model and Notation melalui Pendekatan Rule-Based},
journal = {TIN: Terapan Informatika Nusantara},
year = {2025},
volume = {6},
number = {7},
pages = {1003--1014},
doi = {10.47065/tin.v6i7.8868}
}
EUVIMED