Gamal Alaaeldien, T. (2017). Designing Excel-VBA Program for the Analysis of Force-Time Curve Profile. Journal of Applied Sports Science, 7(2), 43-50. doi: 10.21608/jass.2017.84614
Tarek Gamal Alaaeldien. "Designing Excel-VBA Program for the Analysis of Force-Time Curve Profile". Journal of Applied Sports Science, 7, 2, 2017, 43-50. doi: 10.21608/jass.2017.84614
Gamal Alaaeldien, T. (2017). 'Designing Excel-VBA Program for the Analysis of Force-Time Curve Profile', Journal of Applied Sports Science, 7(2), pp. 43-50. doi: 10.21608/jass.2017.84614
Gamal Alaaeldien, T. Designing Excel-VBA Program for the Analysis of Force-Time Curve Profile. Journal of Applied Sports Science, 2017; 7(2): 43-50. doi: 10.21608/jass.2017.84614
Designing Excel-VBA Program for the Analysis of Force-Time Curve Profile
Faculty of Physical Education for Boys, Alexandria University, Alexandria, Egypt
Abstract
This paper presents a novel Excel-Visual basic for application (VBA) program that simplifies the process for sport-science students and researchers dealing with Bertec force plate form outputs, without the need for knowing any programming language or using sophisticated-expensive software programs. The designed program automatically facilitates the following tasks: starting from reading, decoding, importing, graphing, extracting, calculating, reporting and finally archiving force–time variables measured by faceplate form to an Excel spreadsheet file. The imported input variables extracted from force plate text file are: serial numbers, time, ground reaction forces in three dimension (Fx, Fy, Fz), that help in creating the calculated force-time variables in an excel report sheet including: sampling frequency, start and end time, time range of ground reaction forces in three dimensions; the maxima, minima, time and duration of both extremes, in addition to the total impulses, both positive, and negative, with their time ranges.