Designing Excel-VBA Program for the Analysis of Force-Time Curve Profile | ||||
Journal of Applied Sports Science | ||||
Article 6, Volume 7, Issue 2, August 2017, Page 43-50 PDF (890.83 K) | ||||
Document Type: Original Article | ||||
DOI: 10.21608/jass.2017.84614 | ||||
View on SCiNiTO | ||||
Author | ||||
Tarek Gamal Alaaeldien | ||||
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. | ||||
Keywords | ||||
Excel-VBA program; Force-time curve; Force plate form; Spreadsheet, Dynamic chart | ||||
Statistics Article View: 125 PDF Download: 427 |
||||