Main Page/Research/MSB/Scripts/log of SMS consistency within each subject
From phurvitz
This list summarizes how to deal with individual SMS files *s01: cannot be conflated due to no timestamps on SMS
- s03: cannot be conflated due to no timestamps on SMS
- s06: cannot be conflated due to no timestamps on SMS
- s09: cannot be conflated due to no timestamps on SMS
- s10: cannot be conflated due to no timestamps on SMS
- s11: OK, any erroneous GPS timestamps are due to GPS initialization. These can be corrected by mode of offset between phone and GPS time
- SMS 2005-09-11 2005-09-13 2008-01-22 2008-01-23 2008-01-24 2008-01-25 2008-01-27 2008-01-28
- MXP 2008-01-21 2008-01-22 2008-01-23 2008-01-24 2008-01-25 2008-01-27 2008-01-28
- s12: Excellent, all records have good GPS timestamps.
- SMS 2008-01-21 2008-01-22 2008-01-23 2008-01-24 2008-01-25
- MXP 2008-01-21 2008-01-22 2008-01-23 2008-01-24 2008-01-25 2008-01-26 2008-01-27 2008-01-28
- s13: OK, any erroneous GPS timestamps are due to GPS initialization. These can be corrected by mode of offset between phone and GPS time
- SMS 2005-09-11 2008-01-22 2008-01-23 2008-01-24 2005-09-16 2008-01-25 2008-01-27 2008-01-28
- MXP 2006-03-01 2008-01-21 2008-01-22 2008-01-23 2008-01-24 2008-01-25 2008-01-26 2008-01-27 2008-01-28
- s15: OK, any erroneous GPS timestamps are due to GPS initialization. These can be corrected by mode of offset between phone and GPS time
- SMS 2008-01-29 2008-01-30 2008-01-31 2008-02-01 2008-02-02 2008-02-03 2008-02-04 2008-02-05 2005-09-13
- MXP 2006-01-29 2008-01-29 2008-01-30 2008-01-31 2008-02-01 2008-02-02 2008-02-03 2008-02-04 2008-02-05 2008-02-06
- s16: Excellent, all records have good GPS timestamps.
- SMS 2008-01-29 2008-01-30 2008-01-31 2008-02-01 2008-02-02 2008-02-03 2008-02-04 2008-02-05 2008-02-06
- MXP 2008-01-29 2008-01-30 2008-01-31 2008-02-01 2008-02-02 2008-02-03 2008-02-04 2008-02-05 2008-02-06
- s17: OK, any erroneous GPS timestamps are due to GPS initialization. These can be corrected by mode of offset between phone and GPS time
- SMS 2005-09-11 2008-02-20 2008-02-21 2008-02-22 2008-02-23 2008-02-24 2008-02-25 2008-02-26 2008-02-27
- MXP 2008-02-20 2008-02-21 2008-02-22 2008-02-23 2008-02-24 2008-02-25 2008-02-26 2008-02-27 2008-02-28
- s18: OK, any erroneous GPS timestamps are due to GPS initialization. These can be corrected by mode of offset between phone and GPS time
- SMS 2008-02-20 2005-09-11 2008-02-21 2008-02-22 2008-02-23 2008-02-24 2008-02-26 2008-02-27
- MXP 2008-02-20 2008-02-21 2008-02-22 2008-02-23 2008-02-24 2008-02-26 2008-02-27
- s19: OK, any erroneous GPS timestamps are due to GPS initialization. These can be corrected by mode of offset between phone and GPS time
- SMS 2005-09-11 2008-02-21 2005-09-15 2005-09-14 2005-09-16 2008-02-29 2008-03-01 2008-03-03 2008-03-04 2008-03-05
- MXP 2008-02-20 2008-02-21 2008-02-22 2008-02-27 2008-02-28 2008-02-29 2008-03-01 2008-03-02 2008-03-03 2008-03-04 2008-03-05 2008-03-06 2008-03-07
- s20: OK, any erroneous GPS timestamps are due to GPS initialization. These can be corrected by mode of offset between phone and GPS time
- SMS 2008-02-20 2008-02-21 2008-02-22 2008-02-23 2008-02-24 2008-02-25 2005-09-12 2005-09-13 2008-02-27 2008-02-28 2008-02-29
- MXP 2008-02-20 2008-02-21 2008-02-22 2008-02-23 2008-02-24 2008-02-25 2008-02-26 2008-02-27 2008-02-28 2008-02-29
- s21: Excellent, all records have good GPS timestamps.
- SMS 2008-03-03 2008-03-04 2008-03-05 2008-03-06 2008-03-10
- MXP 2005-10-14 2008-03-04 2008-03-05 2008-03-06 2008-03-07 2008-03-08 2008-03-09 2008-03-10
- s22: OK, any erroneous GPS timestamps are due to GPS initialization. These can be corrected by mode of offset between phone and GPS time
- SMS 2008-03-04 2005-09-11 2008-03-05 2008-03-06
- MXP 2005-11-23 2008-03-04 2008-03-05 2008-03-06 2008-03-09 2008-03-10 2008-03-11 2008-03-12
- s23: OK, any erroneous GPS timestamps are due to GPS initialization. These can be corrected by mode of offset between phone and GPS time
- SMS 2008-03-04 2008-03-05 2008-03-06 2008-03-07 2005-09-16 2008-03-08
- MXP 2008-03-03 2008-03-04 2008-03-05 2008-03-06 2008-03-07 2008-03-08 2008-03-09 2008-03-10
- s24: OK, any erroneous GPS timestamps are due to GPS initialization. These can be corrected by mode of offset between phone and GPS time
- SMS 2008-03-04 2008-03-05 2008-03-06 2008-03-07 2008-03-08 2008-03-10
- MXP 2008-03-04 2008-03-05 2008-03-06 2008-03-07 2008-03-08 2008-03-09 2008-03-10 2008-03-11
- s25: OK, any erroneous GPS timestamps are due to GPS initialization. These can be corrected by mode of offset between phone and GPS time
- SMS 2005-09-11 2008-03-05 2008-03-06 2008-03-07 2008-03-08 2008-03-10
- MXP 2008-03-05 2008-03-06 2008-03-07 2008-03-08 2008-03-09 2008-03-10 2008-03-11
- s26: Problems.
- 2006-03-01 12:04:46 (row 16) bad
- row 22-33: phone time reset and GPS times are unfixed. Cannot use records
- SMS 2008-03-03 2008-03-04 2008-03-05 2005-09-11 2008-03-11 2008-03-12 2005-09-15
- MXP 2006-03-01 2006-03-02 2006-03-03 2006-03-04
- s27: OK, any erroneous GPS timestamps are due to GPS initialization. These can be corrected by mode of offset between phone and GPS time
- SMS 2005-09-11 2008-03-04 2008-03-05
- MXP
- s28: Excellent, all records have good GPS timestamps.
- SMS 2008-03-05 2008-03-06
- MXP 2008-03-05 2008-03-06 2008-03-07 2008-03-08 2008-03-09 2008-03-10 2008-03-11 2008-03-12
- s29: OK, any erroneous GPS timestamps are due to GPS initialization. These can be corrected by mode of offset between phone and GPS time
- SMS 2005-09-11 2008-03-14 2008-03-15 2008-03-16 2008-03-17 2008-03-18
- MXP 2008-03-14 2008-03-15 2008-03-16 2008-03-17 2008-03-18 2008-03-19 2008-03-20
- s30: OK, any erroneous GPS timestamps are due to GPS initialization. These can be corrected by mode of offset between phone and GPS time
- SMS 2005-09-11 2008-03-14 2008-03-15 2005-09-17 2008-03-16 2008-03-17 2008-03-18 2008-03-20
- MXP 2006-03-01 2008-03-14 2008-03-15 2008-03-16 2008-03-17 2008-03-18 2008-03-19 2008-03-20 2008-03-21
- s31: OK, any erroneous GPS timestamps are due to GPS initialization. These can be corrected by mode of offset between phone and GPS time
- SMS 2005-09-11 2008-03-14 2008-03-15 2008-03-16 2008-03-17 2008-03-18 2008-03-19 2008-03-20 2005-09-15 2008-03-21
- MXP 2008-03-14 2008-03-15 2008-03-16 2008-03-17 2008-03-18 2008-03-19 2008-03-20 2008-03-21
- s32: Excellent, all records have good GPS timestamps.
- SMS 2008-03-19 2008-03-20
- MXP 2005-10-14 2008-03-14 2008-03-15 2008-03-16 2008-03-17 2008-03-18 2008-03-19 2008-03-20 2008-03-21
- s33: Excellent, all records have good GPS timestamps.
- SMS 2008-03-19 2008-03-20
- MXP 2008-03-14 2008-03-15 2008-03-16 2008-03-17 2008-03-18 2008-03-19 2008-03-20 2008-03-21
- s34: OK, any erroneous GPS timestamps are due to GPS initialization. These can be corrected by mode of offset between phone and GPS time
- SMS 2005-09-11 2008-03-14 2008-03-15 2008-03-19 2008-03-20
- MXP 2008-03-14 2008-03-15 2008-03-16 2008-03-17 2008-03-18 2008-03-19 2008-03-20 2008-03-21
- s35: Excellent, all records have good GPS timestamps.
- SMS 2008-03-19
- MXP 2006-05-26 2008-03-14 2008-03-15 2008-03-16 2008-03-17 2008-03-18 2008-03-19 2008-03-20 2008-03-21
- s37: OK, any erroneous GPS timestamps are due to GPS initialization. These can be corrected by mode of offset between phone and GPS time
- SMS 2008-03-18 2008-03-19 2005-09-11 2008-03-20 2005-09-13
- MXP 2008-03-14 2008-03-15 2008-03-16 2008-03-17 2008-03-18 2008-03-19 2008-03-20 2008-03-22 2008-03-23 2008-03-24 2008-03-25 2008-03-26 2008-03-27
- s38: OK, any erroneous GPS timestamps are due to GPS initialization. These can be corrected by mode of offset between phone and GPS time
- SMS 2005-09-11 2008-03-21 2005-09-16 2008-03-22 2008-03-23 2008-03-24 2005-09-12 2008-03-25 2008-03-26
- MXP 2006-03-01 2008-03-20 2008-03-21 2008-03-22 2008-03-23 2008-03-24 2008-03-25 2008-03-26
- s39: OK, any erroneous GPS timestamps are due to GPS initialization. These can be corrected by mode of offset between phone and GPS time
- SMS 2008-04-08 2008-04-09 2008-04-10 2008-04-11 2008-04-12 2005-09-11 2008-04-14
- MXP 2008-04-07 2008-04-08 2008-04-09 2008-04-10 2008-04-11 2008-04-12 2008-04-13 2008-04-14
- s45: OK, any erroneous GPS timestamps are due to GPS initialization. These can be corrected by mode of offset between phone and GPS time
- SMS 2008-04-09 2008-04-11 2005-09-11 2008-04-12 2008-04-13 2008-04-14 2008-04-15 2008-04-16
- MXP 2008-04-09 2008-04-10 2008-04-11 2008-04-12 2008-04-13 2008-04-14 2008-04-15 2008-04-16
- s46: OK, any erroneous GPS timestamps are due to GPS initialization. These can be corrected by mode of offset between phone and GPS time
- SMS 2005-09-11 2005-09-14 2005-09-15 2008-04-11 2008-04-12 2008-04-13
- MXP 2006-03-01 2008-04-09 2008-04-10 2008-04-11 2008-04-12 2008-04-13 2008-04-14 2008-04-15 2008-04-16
- s50: No good records
- SMS 2005-09-16
- MXP 2008-04-10 2008-04-11 2008-04-12 2008-04-13 2008-04-14 2008-04-15 2008-04-16 2008-04-17 2008-04-18
- s51: Excellent, all records have good GPS timestamps.
- SMS 2005-09-11 2008-04-18 2008-04-19 2008-04-20 2008-04-21 2008-04-22 2008-04-23
- MXP 2008-04-18 2008-04-19 2008-04-20 2008-04-21 2008-04-22 2008-04-23
- s52: Excellent, all records have good GPS timestamps.
- SMS 2005-09-11 2005-09-16 2005-09-17 2008-04-19 2005-09-18 2005-09-12 2008-04-21 2005-09-13 2008-04-22 2008-04-23 2008-04-24
- MXP 2008-04-18 2008-04-19 2008-04-20 2008-04-21 2008-04-22 2008-04-23 2008-04-24
- s54: OK, any erroneous GPS timestamps are due to GPS initialization. These can be corrected by mode of offset between phone and GPS time
- SMS 2005-09-11 2008-04-19 2008-04-20 2008-04-21 2008-04-22 2008-04-23 2008-04-24
- MXP 2008-04-18 2008-04-19 2008-04-20 2008-04-21 2008-04-22 2008-04-23 2008-04-24
- s55: Excellent, all records have good GPS timestamps.
- SMS 2008-04-18 2008-04-19 2008-04-21 2008-04-22 2008-04-23 2008-04-24
- MXP 2008-04-18 2008-04-19 2008-04-20 2008-04-21 2008-04-22 2008-04-23 2008-04-24
- s56: Excellent, all records have good GPS timestamps.
- SMS 2008-04-19 2008-04-20 2008-04-21 2005-09-12 2008-04-22 2008-04-23 2008-04-24 2008-04-25
- MXP 2008-04-19 2008-04-20 2008-04-21 2008-04-22 2008-04-23 2008-04-24 2008-04-25
- s58: OK, any erroneous GPS timestamps are due to GPS initialization. These can be corrected by mode of offset between phone and GPS time
- SMS 2005-09-11 2008-04-19 2008-04-22 2008-04-23 2005-09-16 2008-04-25 2008-04-26 2008-04-27 2008-04-28 2008-04-29
- MXP 2008-04-18 2008-04-19 2008-04-20 2008-04-21 2008-04-22 2008-04-23 2008-04-24 2008-04-25 2008-04-26 2008-04-27 2008-04-28 2008-04-29
- s61: Problems: phone has duplicate dates (2008-05-02 2008-05-03)
- MyExperience records need to be reviewed based on MSB seconds, if > 7228 for either of these dates, then a match can be made, otherwise discard the records from these dates.
- SMS 2008-04-30 2005-09-11 2008-05-01 2008-05-02 2008-05-03 2008-05-04 2008-05-05 2008-05-06
- MXP 2008-05-03 2008-05-02 2006-03-01 2008-05-04 2008-05-05 2008-05-06
- s62: OK, any erroneous GPS timestamps are due to GPS initialization. These can be corrected by mode of offset between phone and GPS time
- SMS 2008-04-30 2008-05-01 2005-09-16 2008-05-03 2008-05-04 2008-05-05 2008-05-06
- MXP 2008-04-29 2008-04-30 2008-05-01 2008-05-02 2008-05-03 2008-05-04 2008-05-05 2008-05-06
- s63: OK, any erroneous GPS timestamps are due to GPS initialization. These can be corrected by mode of offset between phone and GPS time
- SMS 2008-04-30 2008-05-03 2008-05-04 2008-05-05
- MXP 2008-04-29 2008-04-30 2008-05-01 2008-05-02 2008-05-03 2008-05-04 2008-05-05
- s64: Excellent, all records have good GPS timestamps.
- SMS 2008-04-30 2008-05-01 2008-05-02 2008-05-04 2008-05-05 2008-05-06
- MXP 2008-04-29 2008-04-30 2008-05-01 2008-05-02 2008-05-04 2008-05-05 2008-05-06
- s66: OK, any erroneous GPS timestamps are due to GPS initialization. These can be corrected by mode of offset between phone and GPS time
- SMS 2005-09-11 2008-05-01 2008-05-02 2008-05-04 2008-05-05 2005-09-13
- MXP 2008-04-30 2008-05-01 2008-05-02 2008-05-03 2008-05-04 2008-05-05 2008-05-06 2008-05-07
- s67: OK, any erroneous GPS timestamps are due to GPS initialization. These can be corrected by mode of offset between phone and GPS time
- SMS 2008-05-08 2008-05-09 2005-09-11 2008-05-12 2008-05-13 2008-05-14 2008-05-15 2005-09-15
- MXP 2008-05-08 2008-05-09 2008-05-12 2008-05-13 2008-05-14 2008-05-15
- s68: Excellent, all records have good GPS timestamps.
- SMS 2008-05-15 2008-05-16 2008-05-17 2008-05-18 2008-05-19 2008-05-20 2008-05-21 2008-05-22
- MXP 2008-05-15 2008-05-16 2008-05-17 2008-05-18 2008-05-19 2008-05-20 2008-05-21 2008-05-22
- s69: Excellent, all records have good GPS timestamps.
- SMS 2008-05-13 2008-05-14 2008-05-15 2008-05-17 2008-05-18 2008-05-19 2008-05-20 2008-05-21
- MXP 2008-05-13 2008-05-14 2008-05-15 2008-05-17 2008-05-18 2008-05-19 2008-05-20 2008-05-21
- s70: Excellent, all records have good GPS timestamps.
- SMS 2008-05-08 2008-05-09 2008-05-10 2008-05-11 2008-05-12 2008-05-13 2008-05-14 2008-05-15 2008-05-16
- MXP 2008-05-08 2008-05-09 2008-05-10 2008-05-11 2008-05-12 2008-05-13 2008-05-14 2008-05-15 2008-05-16