A LEAN MANAGEMENT APPROACH TO DEVELOPING A MICROSOFT EXCEL SCORING CALCULATOR FOR DECATHLON AND HEPTATHLON
Article Sidebar
Main Article Content
Abstract
The objectives of this study were (1) to develop a Lean-managed spreadsheet program for calculating decathlon and heptathlon scores, and (2) to compare the scoring time between using the World Athletics (WA) standard scoring book and the spreadsheet program. An experiment was conducted with 30 participants in two phases. Phase 1 used the standard scoring book to record calculation times and to inform the Lean-based redesign of the scoring process within the spreadsheet program. Phase 2 compared the scoring times between the book and the program to evaluate the program’s time-reduction performance. Instruments included a program-use recording test and analysis with an independent t-test. The developed program computed scores exactly in accordance with World Athletics standards, simplified procedures, and reduced manual calculation errors. Expert validation by three specialists produced an index of item–objective congruence of 0.885, The reliability test has a value of 0.956. Regarding efficiency, scoring time decreased significantly: for the decathlon, the meantime fell from 28.36 to 16.83 minutes (a reduction of 11.53 minutes), and for the heptathlon from 16.23 to 11.28 minutes (a reduction of 4.55 minutes). In conclusion, the spreadsheet program effectively reduces scoring time for both decathlon and heptathlon while maintaining international accuracy standards, providing a practical approach to enhance the efficiency and standardization of athletics competitions.
Article Details
This work is licensed under a Creative Commons Attribution-NonCommercial-NoDerivatives 4.0 International License.
References
Allen, E., Fenton, A., & Parry, K. (2021). Computerised gymnastics judging scoring system implementation - An exploration of stakeholders' perceptions. Science of Gymnastics Journal, 13(3), 357–370. https://doi.org/10.52165/sgj.13.3.357-370
Blobel, T., Rumo, M., & Lames, M. (2021). Sports information systems: A systematic review. International Journal of Computer Science in Sport, (20)1, 1-22. https://doi.org/10.2478/ijcss-2021-0001
Bulus, M. (2021). Sample size determination and optimal design of randomized/non-equivalent pretest-posttest control-group designs. Adıyaman University Journal of Educational Sciences, 11(1), 48-69. https://doi.org/10.17984/adyuebd.941434
Csató, L. (2022). A comparative study of scoring systems by simulations. Journal of Sports Economics, 24(4) 526-545. https://doi.org/10.1177/15270025221134241
Edouard, P. & Hollander, K. (2025). Injuries by events in combined events (decathlon and heptathlon) during 11 international outdoor athletics championships. The Scandinavian Journal of Medicine & Science in Sports, 35(10), 1-11. https://doi.org/10.1111/sms.70142
Heavin, C,. & Power J. D. (2018). Challenges for digital transformation – towards a conceptual decision support guide for managers. Journal of Decision Systems, 27(1), 38-45. https://doi.org/10.1080/12460125.2018.1468697
IAAF. (2001). IAAF scoring tables for combined events. International Association of Athletics Federations.
Jana, P. & Tiwari, M. (2021). Lean Tools in Apparel Manufacturing. Woodhead Publishing.
Kanlaya Vanichbancha, K. (2007). Statistical analysis: Statistics for administration and research (10th ed.). Chulalongkorn University Press.
Kreeta Promtep & Panithan Mekkamol. (2022). Development of computer programs for judging athletics of courtyard type of competition decision results with distances. Journal of Buddhist Social Sciences and Anthropology, 7(4), 412–424.
Kumar, R., Kumar, P., Kumar, A., & Dvivedi, A. (2025). Prioritising elements of digitalisation for lean and green SME operations: an ISM-MICMAC study in the Indian context. Journal of Advances in Management Research, 22(5), 705-725. https://doi.org/10.1108/JAMR-11-2024-0449
Nation Group. (2022, December 18). Gartner’s key technology trends for 2023. https://www.springnews.co.th/digitaltech/technology/833470
Nipitpholt Sanitlou, Whachareeporn Sartphet, & Yada Naphaarrak. (2019). Sample size calculation using G*Power program. Journal of Suvarnabhumi Institute of Technology, 5(1), 496-507.
Palida Suttishe. (2025). Efficiency Improvement of information flow in the record keeping system using lean concept: A case study. Thai Industrial Engineering Network Journal, 11(1) 53-66.
Pornchai Tathisa, Luxsamee Chimwong, & Napassawan Charoenchaipinan. (2025). Artificial intelligence technology and raising the standards of volleyball refereeing. Journal of Sports Science and Health Innovation, Rajabhat University Group of Thailand, 4(2), 15-30.
Qi, Y., Sajadi, S. M., Baghaei, S., Rezaei, R., & Li, W. (2024). Digital technologies in sports: Opportunities, challenges, and strategies for safeguarding athlete wellbeing and competitive integrity in the digital era. Technology in Society, 77, 102496.
https://doi.org/10.1016/j.techsoc.2024.102496
Siripong Jungthawan. (2020). Lean: Think like a leader, act like a successful person. Doing Less Getting More.
Solikin, I., & Martinus, M. (2024). Development of a web-based application for monitoring and measuring the physical condition of badminton athletes. Journal of Telecommunication, Electronic and Computer Engineering, 16(4), 47–55. https://doi.org/10.54554/jtec.2024.16.04.007
Tachapon Tongterm. (2025). Engineering and sports technology in Thailand: current situation, opportunities, and challenges in the digital era. Journal of Sports Science and Health Innovation, Rajabhat University Group of Thailand, 4(2), 1-14.
Thanyamon Nisamaneewong. (2022). Information system for managing archery competitions. [Master’s thesis, Chulalongkorn University]. Chulalongkorn University Knowledge Repository. https://doi.org/10.58837/CHULA.IS.2022.90
Vater, T., & Vater, M. (2024). Heptathlon: The current scoring system and its biases: An analysis into the distribution of scores. Athens Journal of Sports, 11(3). 151-164. https://doi.org/10.30958/ajspo.11-3-2
Vial, G. (2019). Understanding digital transformation: A review and a research agenda. The Journal of Strategic Information Systems, 28(2), 118-144. https://doi.org/10.1016/j.jsis.2019.01.003
Wang, G. (2020). Video-based distance measurement for jump events. In Xiaohong Ruan (Eds.), The 2020 5th International Conference on Mechatronics, Control and Electronic Engineering (pp. 229-234). Central China Normal University.
