EUVIMEDEUVIMED entdecken
Open Access · CC BY 4.0

Transformasi Spreadsheet menjadi Diagram Business Process Model and Notation melalui Pendekatan Rule-Based

Teguh Budi Santoso, Muhammad Ainul Yaqin

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).

AbstractBibliografische AngabenZitierenVerwandte Studien

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}
}
Kostenlos starten →