CCS2: Change Log

all datatables: v01

Change date format of the datatables to YYYY-MM-DD. If including time addition: HH:MM:SS AM/PM

To use universal format of time

all datatables: v01

Added filtering to the header row

To be able to check and filter

weightLogInfo v01

There were just two entries within this column, there is no way I can gather this info. So deteled

To get rid of missing values

weightLogInfo v01

There were two weight columns in weightLogInfo. One in kg and one in pounds

I will work with kg.

all tables with distance coulmns

In all tables were are columns with distance I have rounded it to two decimals

we do not need so high resolution in distance for this analysis. In this way will be easier to work with

weightLogInfo v01

Weight column rounded to two decimals

we do not need so high resolution in weight for this analysis. In this way will be easier to work with

All tables with calories v01

Calories rounded to four decimals

Probably two decimals would be sufficient, but wanted try four to to see how It will be to work with. We do not need so high resolution in calories

All tables v01(except the hourly data tables, those were copied to source folder)

Additional tab in spreadsheets

To to work with data efficiently while keeping the source data Except the data tables with hourly data which are to large in this case I have archived the original spreadsheet in source folder

All tables v01(except the hourly data tables, those were copied to source folder)

To keep the source data intakt to be able to compare with the transformed data

From all tables 01v

From this user we have only few entries (4 in Daily). So 33 users - 1 = 32

Daily activities merge

Added Day of the week so we can follow how active people are based on a day

CCS2_dailyActivityMerged_v02

To track if time in bed sums up with other activities for 24 Hours

CCS2_dailyActivityMerged_v02

Removed all entries [75] that had missing data (all data were missing expet Sedetery time)

CCS2_dailyActivityMerged_v02

Removed extreme entries [4]. With very low data (very low steps count with combinanation Sum up of all activities times and Sleep)

CCS2_dailyActivityMerged_v03

Times of many entries does no add up to 1440 when calculated. Some of them were over and some of them were under the times. =IFS(U8>1440, O8-(U8 -1440), U8<1440, O8+(1440-U8), U8=1440, O8)

CCS2_dailyActivityMerged_v04

Removed outlieres [7], entries that had counted steps and calories with 1440 minutes of sedetary activity

CCS2_dailyActivityMerged_v04

Removed outlieres [8], entries that had extremly low number of sterps (<100).

CCS2_dailyActivityMerged_v04

Because we do not have all entries with In bed time and Sleeping time. Created addtional Column SedetaryWithSleep. To be able to compare all data