Balance System SD (with v4.X software) 143
5. The value of the Sway Index contained in the exported CSV file matches the value calculated
in the Excel spreadsheet after all of the formulas have been entered and applied (see Figure
C.10 below).
!
Figure C.10. CSV File Format Calculation – Final Results.
Calculation Using Formula on Excel Sheet – CTSIB Test – Multi-Trial:
This example is presented using a single condition and single trial for ease of understanding. In
the field, the CTSIB (/m-CTSIB) test can be performed using multiple conditions and multiple
trials. For multiple trials, the data will be displayed as Condition 1, Trial 1, Condition 2 Trial 2,
or as Condition 1 Trial 1, Condition 1 Trial 2, Condition 2 Trial 1, Condition 2 Trial 2, etc.
For the following example, the Sway index is displayed as 7.405 with one condition and two
trials.
Figure C.11. Excel Spreadsheet Illustrating the Sway Index.
The sway index for trial 1 is 10.44 and 0.71 for trial 2. Overall, the averaged sway index is
7.405. The data points calculation in this case is: (807+807) = 1614.