Transformasi Spreadsheet menjadi Diagram Business Process Model and Notation melalui Pendekatan Rule-Based
-
Teguh Budi Santoso
*
Universitas Islam Negeri Maulana Malik Ibrahim, Malang,
Indonesia
- Muhammad Ainul Yaqin Universitas Islam Negeri Maulana Malik Ibrahim, Malang, Indonesia (*) Corresponding Author
Abstract
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.
Downloads
References
Anjany, F., Al Kaamil, S. F., & Ainul Yaqin, M. (2025). Evaluasi Kemampuan ChatGPT dalam Mengonversi Kebutuhan Sistem Berbasis BPMN Menjadi Formula Linear Temporal Logic (LTL). Jurnal Pustaka Data (Pusat Akses Kajian Database, Analisa Teknologi, Dan Arsitektur Komputer), 5(1), 152–160. https://doi.org/10.55382/jurnalpustakadata.v5i1.1000
Azaro, K., Ekasari, K., & Indrawan, A. (2021). The Analysis of Business Process Management Notation (Purchase Order) in Small Medium Enterprise: A Case Study. Journal of Industrial Engineering & Management Research, 2(3). https://doi.org/10.7777/jiemar.v2i3
Bezerra, C., & Coutinho, E. (2023). Modeling software processes from different domains using SPEM and BPMN notations: An experience report of teaching software processes. Journal of Software Engineering Research and Development, 11(1). https://doi.org/10.5753/jserd.2023.3186
Chaerulisma, H. F., & Setiani, N. (2025). Redesigning HR Business Processes with Camunda BPMN and Chatbot Integration. Jurnal Sains, Nalar, Dan Aplikasi Teknologi Informasi, 4(2), 73–81. https://doi.org/10.20885/snati.v4.i2.40421
Choudhary, R., & Riaz, N. (2023). A business process re-engineering approach to transform business process simulation to BPMN model. PLOS ONE, 18(3), e0277217. https://doi.org/10.1371/journal.pone.0277217
Compagnucci, I., Corradini, F., Fornari, F., & Re, B. (2024). A Study on the Usage of the BPMN Notation for Designing Process Collaboration, Choreography, and Conversation Models. Business and Information Systems Engineering, 66(1), 43–66. https://doi.org/10.1007/s12599-023-00818-7
de Leoni, M., Felli, P., & Montali, M. (2021). Integrating BPMN and DMN: Modeling and Analysis. Journal on Data Semantics, 10(1–2), 165–188. https://doi.org/10.1007/s13740-021-00132-z
Delgado, A., Calegari, D., García, F., & Weber, B. (2022). Model-driven management of BPMN-based business process families. Software and Systems Modeling, 21(6), 2517–2553. https://doi.org/10.1007/s10270-022-00985-3
Garg, D., Zeng, S., Ganesh, S., & Ardon, L. (2025). Generating Structured Plan Representation of Procedures with LLMs. ArXiv. https://doi.org/10.48550/arXiv.2504.00029
Isken, M. W. (2025). Spreadsheet Modeling and Wrangling with Python. INFORMS Transactions on Education, 25(2), 152–168. https://doi.org/10.1287/ited.2023.0047
Kourani, H., Berti, A., Schuster, D., & van der Aalst, W. M. P. (2024). Process Modeling With Large Language Models (pp. 229–244). Enterprise, Business-Process and Information Systems Modeling. https://doi.org/10.1007/978-3-031-61007-3_18
Kourani, H., Berti, A., Schuster, D., & van der Aalst, W. M. P. (2025). Evaluating large language models on business process modeling: framework, benchmark, and self-improvement analysis. Software and Systems Modeling. https://doi.org/10.1007/s10270-025-01318-w
Licardo, J. T., Tankovic, N., & Etinger, D. (2025). BPMN Assistant: An LLM-Based Approach to Business Process Modeling. ArXiv. https://doi.org/10.48550/arXiv.2509.24592
Pamungkas, S. M., Aqimuddin, I., Gunawan, C., Yaqin, M. A., & Fauzan, Abd. C. (2023). Analisis Kemiripan Model Proses Bisnis PMBoK dan Scrum menggunakan Metode Jaccard Coefficient Similarity dan Semantic Similarity. ILKOMNIKA: Journal of Computer Science and Applied Informatics, 5(2), 53–64. https://doi.org/10.28926/ilkomnika.v5i2.396
Pfeiffer, P., Rombach, A., Majlatow, M., & Mehdiyev, N. (2025). From Theory to Practice: Real-World Use Cases on Trustworthy LLM-Driven Process Modeling, Prediction and Automation. ArXiv. https://doi.org/10.48550/arXiv.2506.03801
Polančič, G., & Kous, K. (2024). High-Level Process Modeling-An Experimental Investigation of the Cognitive Effectiveness of Process Landscape Diagrams. Mathematics, 12(9). https://doi.org/10.3390/math12091376
Sholiq, S., Sarno, R., & Astuti, E. S. (2022). Generating BPMN diagram from textual requirements. Journal of King Saud University - Computer and Information Sciences, 34(10), 10079–10093. https://doi.org/10.1016/j.jksuci.2022.10.007
Sholiq, S., & Yaqin, M. A. (2024). BPMN diagram dataset: Comprehensive collection of functional requirements. Data in Brief, 57, 110882. https://doi.org/10.1016/j.dib.2024.110882
Viteri-Sánchez, C., & Novillo-Villegas, S. (2025). A Framework for a Sustainable Adoption of Business Process Management. Sustainability, 17(21), 9827. https://doi.org/10.3390/su17219827
Wahab, M. B. A., Mazen, S. A., & Helal, I. M. A. (2025). Utilizing Large Language Models in Business Process Management: Applications and Challenges. Journal of Computer Science, 21(8), 1921–1932. https://doi.org/10.3844/jcssp.2025.1921.1932
Bila bermanfaat silahkan share artikel ini
Berikan Komentar Anda terhadap artikel Transformasi Spreadsheet menjadi Diagram Business Process Model and Notation melalui Pendekatan Rule-Based
Pages: 1003-1014
Copyright (c) 2025 Teguh Budi Santoso, Muhammad Ainul Yaqin
This work is licensed under a Creative Commons Attribution 4.0 International License.
Authors who publish with this journal agree to the following terms:
- Authors retain copyright and grant the journal right of first publication with the work simultaneously licensed under Creative Commons Attribution 4.0 International License that allows others to share the work with an acknowledgment of the work's authorship and initial publication in this journal.
- Authors are able to enter into separate, additional contractual arrangements for the non-exclusive distribution of the journal's published version of the work (e.g., post it to an institutional repository or publish it in a book), with an acknowledgment of its initial publication in this journal.
- Authors are permitted and encouraged to post their work online (e.g., in institutional repositories or on their website) prior to and during the submission process, as it can lead to productive exchanges, as well as earlier and greater citation of published work (Refer to The Effect of Open Access).
