6.3 EXCEL TABLES OF ANALYSIS VALUES

A description of the Excel table generated by SwayStar™ is given below. The first five columns of the table are fixed to maintain a reference to the patient name and the protocol (called ExpName). Thus, horizontal scrolling occurs after the first 5 columns. Click and drag the horizontal scroll bar beginning in column 6 to see the rest of the data for the recordings (shown in blue). A fuller description of the variables heading each column with an abbreviated label is presented in section 2.7:

If the reference values have been assigned the following coding is used:

Blue value less than 5% percentile of the reference value

Green value within the 5 and 95% percentile of the reference value

Red value greater than the 95% percentile of the reference value


	Analysis Variables Table for log file
Abbreviation	Parameter	Unit	Definition
Identification	Subject type		User defined text field
External Link	Link parameter to statistical program		User defined text field
Complaint	Subject's symptoms		User defined text field
Subject	Last name, first name
ExpName	Protocol name

ExpId	Number of protocol	N
ExpTime	Date and time of recording
SubjectID	Number of patient	N	Chronological number of entry into database
VisitId	Number of visit	N	Chronological number of entry into patients' visit database
RecId	Number of recording	N
Sex	Subject's sex, loss balance indicated	m/f+/-	+ for no loss, - loss of balance, ~ unknown
Age	Subject's age	yrs
RecID	Subject/visit/number of recording	N

Total Duration	Trial duration	s	Time from the start to the end of actual recording. Not the analysis period!
Chosen Duration	Duration chosen for analysis	s	Time from the start to the end of recording period used for analysis.
MVPath	Mean path velocity	°/s	Mean velocity of the vector movement of roll and pitch angular displacement over the complete trial
MVRms	Mean velocity RMS	°/s	Square root of the squared mean velocity of the vector movement of roll and pitch ang. displacement
TotAngArea	Total Angular Area	(deg)²	Area defined by the envelop of the pitch and roll angular excursions over the complete trial
TotVelArea	Total Velocity Area	(°/s)²	Area defined by the envelop of the pitch and roll velocity excursions over the complete trial

RoAngMedian	Median value of roll excursion	deg	Median value of roll excursion with respect to first sample
RoAngRange	Peak-to-peak roll excursion	deg	Extent of trunk roll angular displacement over the complete trial
RoAng90%	90% range of roll excursion	deg	90% percentile range of trunk roll angular displacement over the complete trial
RoVelMedian	Median value of roll velocity excursion	°/s	Median value of roll velocity excursion
RoVelRange	Peak-to-peak roll velocity excursion	°/s	The extent of trunk roll angular velocity over the complete trial
RoVel90%	90% range of roll velocity excursion	°/s	90% percentile range of trunk roll angular velocity

PiAngMedian	Median value of pitch excursion	deg	Median value of pitch excursion with respect to first sample
PiAngRange	Peak-to-peak pitch excursion	deg	Extent of trunk pitch angular displacement over the complete trial
PiAng90%	90% range of pitch excursion	deg	90% percentile range of trunk pitch angular displacement over the complete trial
PiVelMedian	Median value of pitch velocity excursion	°/s	Median value of pitch excursion
PiVelRange	Peak-to-peak pitch velocity excursion	°/s	The extent of trunk pitch angular velocity over the complete trial
PiVel90%	90% range of pitch velocity excursion	°/s	90% percentile range of trunk pitch angular velocity


RoFreq 1.2	Spectral density of roll velocity	(°/s)²	Square root of 3 averaged adjacent spectral density weights at freqs: 0.8, 1.2, 1.6
RoFreq 2.4	Spectral density of roll velocity	(°/s)²	Square root of 3 averaged adjacent spectral density weights at freqs: 2.0, 2.4, 2.8
RoFreq18.0	etc	(°/s)²	…
RoFreq19.2	etc	(°/s)²	…

PiFreq 1.2	Spectral density of pitch velocity	(°/s)²	Square root of 3 averaged adjacent spectral density weights at freqs: 0.8, 1.2, 1.6
PiFreq 2.4	Spectral density of pitch velocity	(°/s)²	Square root of 3 averaged adjacent spectral density weights at freqs: 2.0, 2.4, 2.8
PiFreq18.0	…		…
PiFreq19.2	…		…

MP0Begin	Marker Pair 0, begin	s	Time of the beginning of the Marker Pair 0
MP0Int	Marker Pair 0, interval between markers	s	Interval between the markers of the Pair 0
MP0RoBegAng	Marker Pair 0, roll begin angular value	deg	Roll angular value at the time of the beginning of the Marker Pair 0
MP0RoEndAng	Marker Pair 0, roll end angular value	deg	Roll angular value at the time of the end of the Marker Pair 0
MP0RoAngDif	Marker Pair 0, roll ang. amplitude difference	deg	Roll angular value of the difference amplitude of the Marker Pair 0
MP0RoBegVel	Marker Pair 0, roll begin velocity value	°/s	Roll velocity value at the time of the beginning of the Marker Pair 0
MP0RoEndVel	Marker Pair 0, roll end velocity value	°/s	Roll velocity value at the time of the end of the Marker Pair 0
MP0RoMeanVel	Marker Pair 0, mean roll velocity value	°/s	Roll velocity mean value inside the interval defined with Marker Pair 0
MP0RoVelDiff	Marker Pair 0, roll vel. amplitude difference	°/s	Roll velocity value of the difference amplitude of the Marker Pair 0
MP0PiBegAng	Marker Pair 0, pitch begin angular value	s	Pitch angular value at the time of the beginning of the Marker Pair 0
MP0PiEndAng	Marker Pair 0, pitch end angular value	s	Pitch angular value at the time of the end of the Marker Pair 0
MP0PiAngDif	Marker Pair 0, pitch ang. amplitude difference	s	Pitch angular value of the difference amplitude of the Marker Pair 0
MP0PiBegVel	Marker Pair 0, pitch begin velocity value	°/s	Pitch velocity value at the time of the beginning of the Marker Pair 0