Daily summaries csv

The daily summaries csv file contains summary data for each day of the recording. When produced by the batch processing tool PALbatch, the data from multiple files are included in a single csv file.

Column headingDescription
FolderContaining folder of datx file
FilenameFile name of the datx file
Serial NumberDevice serial number
File CodeFile identifier set on recording setup
Download IdentifierFile identifier set on download of recording from the device
Day of WeekDay name (Mon-Sun)
DateDate in DD MMM YYYY format e.g. 17 May 2018
Valid DayPasses validation algorithm criteria (0 – Fail, 1 – Pass)
Inverted wear correctionAuto-correction for inverted wear applied (0 – No, 1 – Yes)
Alignment (%)Data quality index: device alignment orthogonal to the thigh axis
(100% – fully aligned, 50% – 45 degree angle offset)
Total TimeTotal recording time (in minutes) in the day
Total Num StepsNumber of steps counted in the day
Num Cycling StepsSteps detected as cycling based on leg orientation (note: these steps are included in total num steps for backwards compatibility)
Upright TimeTotal upright time (in minutes) in the day
Standing TimeTotal standing time (in minutes) in the day
Total Stepping TimeTotal stepping time (in minutes) in the day
Cycling TimeTotal cycling time (in minutes) in the day (note: cycling time is included in total stepping time for backwards compatibility)
Sitting TimeTotal sitting time (in minutes) in the day
Seated Transport TimeTotal seated transport time (in minutes) in the day (note: transport time is included in total sitting time for backwards compatibility)
Primary Lying TimeTotal primary lying time (in minutes) in the day
Secondary Lying TimeTotal secondary lying time (in minutes) in the day
Non Wear TimeTotal non-wear time (in minutes) in the day
Num Sit To Stand TransitionsTotal number of sit to stand transitions in the day
Num Stand To Sit TransitionsTotal number of stand to sit transitions in the day
Activity ScoreActivity Score for the day in MET.h
Num Sitting Bouts >30mTotal number of sitting bouts in the day longer than 30 minutes
Num Sitting Bouts >60mTotal number of sitting bouts in the day longer than 60 minutes
Time Spent In Sitting Bouts >30mTotal time spent in sitting bouts longer than 30 minutes during the day
Time Spent In Sitting Bouts >60mTotal time spent in sitting bouts longer than 60 minutes during the day
Stepping Time(m) (duration <1m)Total time spent in stepping bouts of duration less than 1 minute
Stepping Time(m) (duration >1m <=5m)Total time spent in stepping bouts of duration between 1 and 5 minutes
Stepping Time(m) (duration >5m <=10m)Total time spent in stepping bouts of duration between 5 and 10 minutes
Stepping Time(m) (duration >10m <=20m)Total time spent in stepping bouts of duration between 10 and 20 minutes
Stepping Time(m) (duration >20m)Total time spent in stepping bouts of duration greater than 20 minutes
Num Steps (duration <=1m)Total number of steps in stepping bouts of duration less than 1 minute
Num Steps (duration >1m <=5m)Total number of steps in stepping bouts of duration between 1 and 5 minutes
Num Steps (duration >5m <=10m)Total number of steps in stepping bouts of duration between 5 and 10 minutes
Num Steps (duration >10m <=20m)Total number of steps in stepping bouts of duration between 10 and 20 minutes
Num Steps (duration >20m)Total number of steps in stepping bouts of duration greater than 20 minutes
Stepping Time(m) (Cadence>=75)Total time spent in stepping bouts with cadence >= 75 (Note: stepping bouts
with less than 10 steps are excluded)
Stepping Time(m) (Cadence>=75, duration>1m)Total time spent in stepping bouts with cadence >= 75 and stepping bout duration greater than a minute
Num Steps (Cadence>=75)Total number of steps accumulated in stepping bouts with cadence >= 75 (Note: stepping bouts with less than 10 steps are excluded)
Num Steps (Cadence>=75, duration>1m)Total number of steps accumulated in stepping bouts with cadence >= 75 and duration greater
than a minute (Note: stepping bouts with less than 10 steps are excluded)
Stepping Time(m) (Cadence>=100) Total time spent in stepping bouts with cadence >= 100 (Note: stepping bouts with less than 10 steps are excluded)
Stepping Time(m) (Cadence>=100, duration>1m)Total time spent in stepping bouts with cadence >= 100 and stepping bout duration greater than a minute
Num Steps (Cadence>=100)Total number of steps accumulated in stepping bouts with cadence >= 100 (Note: stepping bouts
with less than 10 steps are excluded)
Num Steps (Cadence>=100, duration>1m)Total number of steps accumulated in stepping bouts with cadence >= 100 and duration greater
than a minute (Note: stepping bouts with less than 10 steps are excluded)

Related Articles