Difference between revisions of "Main Page/Research/MSB/Scripts/log of SMS consistency within each subject"
From phurvitz
Phil Hurvitz (talk | contribs) |
Phil Hurvitz (talk | contribs) |
||
Line 56: | Line 56: | ||
*: Assume all MyExperience records with no SMS will have the same offsets applied | *: Assume all MyExperience records with no SMS will have the same offsets applied | ||
*::28 2008-03-05 2008-03-06 | *::28 2008-03-05 2008-03-06 | ||
− | *s29: | + | *s29: OK, any erroneous GPS timestamps are due to GPS initialization. These can be corrected by mode of offset between phone and GPS time |
+ | *: Assume all MyExperience records with no SMS will have the same offsets applied | ||
*::29 2005-09-11 2008-03-14 2008-03-15 2008-03-16 2008-03-17 2008-03-18 | *::29 2005-09-11 2008-03-14 2008-03-15 2008-03-16 2008-03-17 2008-03-18 | ||
− | *s30: | + | *s30: OK, any erroneous GPS timestamps are due to GPS initialization. These can be corrected by mode of offset between phone and GPS time |
− | + | *: Assume all MyExperience records with no SMS will have the same offsets applied | |
*::30 2005-09-11 2008-03-14 2008-03-15 2005-09-17 2008-03-16 2008-03-17 2008-03-18 2008-03-20 | *::30 2005-09-11 2008-03-14 2008-03-15 2005-09-17 2008-03-16 2008-03-17 2008-03-18 2008-03-20 | ||
− | *s31: | + | *s31: OK, any erroneous GPS timestamps are due to GPS initialization. These can be corrected by mode of offset between phone and GPS time |
+ | *: Assume all MyExperience records with no SMS will have the same offsets applied | ||
*::31 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 | *::31 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 | ||
− | *s32: | + | *s32: Excellent, all records have good GPS timestamps. |
+ | *: Assume all MyExperience records with no SMS will have the same offsets applied | ||
*::32 2008-03-19 2008-03-20 | *::32 2008-03-19 2008-03-20 | ||
− | *s33: | + | *s33: Excellent, all records have good GPS timestamps. |
+ | *: Assume all MyExperience records with no SMS will have the same offsets applied | ||
*::33 2008-03-19 2008-03-20 | *::33 2008-03-19 2008-03-20 | ||
− | *s34: | + | *s34: OK, any erroneous GPS timestamps are due to GPS initialization. These can be corrected by mode of offset between phone and GPS time |
+ | *: Assume all MyExperience records with no SMS will have the same offsets applied | ||
*::34 2005-09-11 2008-03-14 2008-03-15 2008-03-19 2008-03-20 | *::34 2005-09-11 2008-03-14 2008-03-15 2008-03-19 2008-03-20 | ||
− | *s35: | + | *s35: Excellent, all records have good GPS timestamps. |
+ | *: Assume all MyExperience records with no SMS will have the same offsets applied | ||
*::35 2008-03-19 | *::35 2008-03-19 | ||
− | *s37: | + | *s37: OK, any erroneous GPS timestamps are due to GPS initialization. These can be corrected by mode of offset between phone and GPS time |
+ | *: Assume all MyExperience records with no SMS will have the same offsets applied | ||
*::37 2008-03-18 2008-03-19 2005-09-11 2008-03-20 2005-09-13 | *::37 2008-03-18 2008-03-19 2005-09-11 2008-03-20 2005-09-13 | ||
− | *s38: | + | *s38: OK, any erroneous GPS timestamps are due to GPS initialization. These can be corrected by mode of offset between phone and GPS time |
+ | *: Assume all MyExperience records with no SMS will have the same offsets applied | ||
*::38 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 | *::38 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 | ||
− | *s39: | + | *s39: OK, any erroneous GPS timestamps are due to GPS initialization. These can be corrected by mode of offset between phone and GPS time |
+ | *: Assume all MyExperience records with no SMS will have the same offsets applied | ||
*::39 2008-04-08 2008-04-09 2008-04-10 2008-04-11 2008-04-12 2005-09-11 2008-04-14 | *::39 2008-04-08 2008-04-09 2008-04-10 2008-04-11 2008-04-12 2005-09-11 2008-04-14 | ||
− | *s45: | + | *s45: OK, any erroneous GPS timestamps are due to GPS initialization. These can be corrected by mode of offset between phone and GPS time |
+ | *: Assume all MyExperience records with no SMS will have the same offsets applied | ||
*::45 2008-04-09 2008-04-11 2005-09-11 2008-04-12 2008-04-13 2008-04-14 2008-04-15 2008-04-16 | *::45 2008-04-09 2008-04-11 2005-09-11 2008-04-12 2008-04-13 2008-04-14 2008-04-15 2008-04-16 | ||
− | *s46: | + | *s46: OK, any erroneous GPS timestamps are due to GPS initialization. These can be corrected by mode of offset between phone and GPS time |
+ | *: Assume all MyExperience records with no SMS will have the same offsets applied | ||
*::46 2005-09-11 2005-09-14 2005-09-15 2008-04-11 2008-04-12 2008-04-13 | *::46 2005-09-11 2005-09-14 2005-09-15 2008-04-11 2008-04-12 2008-04-13 | ||
− | *s50: | + | *s50: No good records |
*::50 2005-09-16 | *::50 2005-09-16 | ||
*s51: | *s51: |
Revision as of 01:32, 20 January 2009
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
- Assume all MyExperience records with no SMS will have the same offsets applied
- 11 2005-09-11 2005-09-13 2008-01-22 2008-01-23 2008-01-24 2008-01-25 2008-01-27 2008-01-28
- Assume all MyExperience records with no SMS will have the same offsets applied
- s12: Excellent, all records have good GPS timestamps.
- Assume all MyExperience records with no SMS will have the same offsets applied
- 12 2008-01-21 2008-01-22 2008-01-23 2008-01-24 2008-01-25
- Assume all MyExperience records with no SMS will have the same offsets applied
- s13: OK, any erroneous GPS timestamps are due to GPS initialization. These can be corrected by mode of offset between phone and GPS time
- Assume all MyExperience records with no SMS will have the same offsets applied
- 13 2005-09-11 2008-01-22 2008-01-23 2008-01-24 2005-09-16 2008-01-25 2008-01-27 2008-01-28
- Assume all MyExperience records with no SMS will have the same offsets applied
- s15: OK, any erroneous GPS timestamps are due to GPS initialization. These can be corrected by mode of offset between phone and GPS time
- Assume all MyExperience records with no SMS will have the same offsets applied
- 15 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
- Assume all MyExperience records with no SMS will have the same offsets applied
- s16: Excellent, all records have good GPS timestamps.
- Assume all MyExperience records with no SMS will have the same offsets applied
- 16 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
- Assume all MyExperience records with no SMS will have the same offsets applied
- s17: OK, any erroneous GPS timestamps are due to GPS initialization. These can be corrected by mode of offset between phone and GPS time
- Assume all MyExperience records with no SMS will have the same offsets applied
- 17 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*s18: OK, any erroneous GPS timestamps are due to GPS initialization. These can be corrected by mode of offset between phone and GPS time
- Assume all MyExperience records with no SMS will have the same offsets applied
- 18 2008-02-20 2005-09-11 2008-02-21 2008-02-22 2008-02-23 2008-02-24 2008-02-26 2008-02-27
- Assume all MyExperience records with no SMS will have the same offsets applied
- s19: OK, any erroneous GPS timestamps are due to GPS initialization. These can be corrected by mode of offset between phone and GPS time
- Assume all MyExperience records with no SMS will have the same offsets applied
- 19 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
- Assume all MyExperience records with no SMS will have the same offsets applied
- s20: OK, any erroneous GPS timestamps are due to GPS initialization. These can be corrected by mode of offset between phone and GPS time
- Assume all MyExperience records with no SMS will have the same offsets applied
- 20 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
- Assume all MyExperience records with no SMS will have the same offsets applied
- s21: Excellent, all records have good GPS timestamps.
- Assume all MyExperience records with no SMS will have the same offsets applied
- 21 2008-03-03 2008-03-04 2008-03-05 2008-03-06 2008-03-10
- Assume all MyExperience records with no SMS will have the same offsets applied
- s22: OK, any erroneous GPS timestamps are due to GPS initialization. These can be corrected by mode of offset between phone and GPS time
- Assume all MyExperience records with no SMS will have the same offsets applied
- 22 2008-03-04 2005-09-11 2008-03-05 2008-03-06
- Assume all MyExperience records with no SMS will have the same offsets applied
- s23: OK, any erroneous GPS timestamps are due to GPS initialization. These can be corrected by mode of offset between phone and GPS time
- Assume all MyExperience records with no SMS will have the same offsets applied
- 23 2008-03-04 2008-03-05 2008-03-06 2008-03-07 2005-09-16 2008-03-08
- Assume all MyExperience records with no SMS will have the same offsets applied
- s24: OK, any erroneous GPS timestamps are due to GPS initialization. These can be corrected by mode of offset between phone and GPS time
- Assume all MyExperience records with no SMS will have the same offsets applied
- 24 2008-03-04 2008-03-05 2008-03-06 2008-03-07 2008-03-08 2008-03-10
- Assume all MyExperience records with no SMS will have the same offsets applied
- s25: OK, any erroneous GPS timestamps are due to GPS initialization. These can be corrected by mode of offset between phone and GPS time
- Assume all MyExperience records with no SMS will have the same offsets applied
- 25 2005-09-11 2008-03-05 2008-03-06 2008-03-07 2008-03-08 2008-03-10
- Assume all MyExperience records with no SMS will have the same offsets applied
- 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
- 26 2008-03-03 2008-03-04 2008-03-05 2005-09-11 2008-03-11 2008-03-12 2005-09-15
- s27: OK, any erroneous GPS timestamps are due to GPS initialization. These can be corrected by mode of offset between phone and GPS time
- Assume all MyExperience records with no SMS will have the same offsets applied
- 27 2005-09-11 2008-03-04 2008-03-05
- Assume all MyExperience records with no SMS will have the same offsets applied
- s28: Excellent, all records have good GPS timestamps.
- Assume all MyExperience records with no SMS will have the same offsets applied
- 28 2008-03-05 2008-03-06
- Assume all MyExperience records with no SMS will have the same offsets applied
- s29: OK, any erroneous GPS timestamps are due to GPS initialization. These can be corrected by mode of offset between phone and GPS time
- Assume all MyExperience records with no SMS will have the same offsets applied
- 29 2005-09-11 2008-03-14 2008-03-15 2008-03-16 2008-03-17 2008-03-18
- Assume all MyExperience records with no SMS will have the same offsets applied
- s30: OK, any erroneous GPS timestamps are due to GPS initialization. These can be corrected by mode of offset between phone and GPS time
- Assume all MyExperience records with no SMS will have the same offsets applied
- 30 2005-09-11 2008-03-14 2008-03-15 2005-09-17 2008-03-16 2008-03-17 2008-03-18 2008-03-20
- Assume all MyExperience records with no SMS will have the same offsets applied
- s31: OK, any erroneous GPS timestamps are due to GPS initialization. These can be corrected by mode of offset between phone and GPS time
- Assume all MyExperience records with no SMS will have the same offsets applied
- 31 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
- Assume all MyExperience records with no SMS will have the same offsets applied
- s32: Excellent, all records have good GPS timestamps.
- Assume all MyExperience records with no SMS will have the same offsets applied
- 32 2008-03-19 2008-03-20
- Assume all MyExperience records with no SMS will have the same offsets applied
- s33: Excellent, all records have good GPS timestamps.
- Assume all MyExperience records with no SMS will have the same offsets applied
- 33 2008-03-19 2008-03-20
- Assume all MyExperience records with no SMS will have the same offsets applied
- s34: OK, any erroneous GPS timestamps are due to GPS initialization. These can be corrected by mode of offset between phone and GPS time
- Assume all MyExperience records with no SMS will have the same offsets applied
- 34 2005-09-11 2008-03-14 2008-03-15 2008-03-19 2008-03-20
- Assume all MyExperience records with no SMS will have the same offsets applied
- s35: Excellent, all records have good GPS timestamps.
- Assume all MyExperience records with no SMS will have the same offsets applied
- 35 2008-03-19
- Assume all MyExperience records with no SMS will have the same offsets applied
- s37: OK, any erroneous GPS timestamps are due to GPS initialization. These can be corrected by mode of offset between phone and GPS time
- Assume all MyExperience records with no SMS will have the same offsets applied
- 37 2008-03-18 2008-03-19 2005-09-11 2008-03-20 2005-09-13
- Assume all MyExperience records with no SMS will have the same offsets applied
- s38: OK, any erroneous GPS timestamps are due to GPS initialization. These can be corrected by mode of offset between phone and GPS time
- Assume all MyExperience records with no SMS will have the same offsets applied
- 38 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
- Assume all MyExperience records with no SMS will have the same offsets applied
- s39: OK, any erroneous GPS timestamps are due to GPS initialization. These can be corrected by mode of offset between phone and GPS time
- Assume all MyExperience records with no SMS will have the same offsets applied
- 39 2008-04-08 2008-04-09 2008-04-10 2008-04-11 2008-04-12 2005-09-11 2008-04-14
- Assume all MyExperience records with no SMS will have the same offsets applied
- s45: OK, any erroneous GPS timestamps are due to GPS initialization. These can be corrected by mode of offset between phone and GPS time
- Assume all MyExperience records with no SMS will have the same offsets applied
- 45 2008-04-09 2008-04-11 2005-09-11 2008-04-12 2008-04-13 2008-04-14 2008-04-15 2008-04-16
- Assume all MyExperience records with no SMS will have the same offsets applied
- s46: OK, any erroneous GPS timestamps are due to GPS initialization. These can be corrected by mode of offset between phone and GPS time
- Assume all MyExperience records with no SMS will have the same offsets applied
- 46 2005-09-11 2005-09-14 2005-09-15 2008-04-11 2008-04-12 2008-04-13
- Assume all MyExperience records with no SMS will have the same offsets applied
- s50: No good records
- 50 2005-09-16
- s51:
- 51 2005-09-11 2008-04-18 2008-04-19 2008-04-20 2008-04-21 2008-04-22 2008-04-23
- s52:
- 52 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
- s54:
- 54 2005-09-11 2008-04-19 2008-04-20 2008-04-21 2008-04-22 2008-04-23 2008-04-24
- s55:
- 55 2008-04-18 2008-04-19 2008-04-21 2008-04-22 2008-04-23 2008-04-24
- s56:
- 56 2008-04-19 2008-04-20 2008-04-21 2005-09-12 2008-04-22 2008-04-23 2008-04-24 2008-04-25
- s58:
- 58 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
- s61:
- 61 2008-04-30 2005-09-11 2008-05-01 2008-05-02 2008-05-03 2008-05-04 2008-05-05 2008-05-06
- s62:
- 62 2008-04-30 2008-05-01 2005-09-16 2008-05-03 2008-05-04 2008-05-05 2008-05-06
- s63:
- 63 2008-04-30 2008-05-03 2008-05-04 2008-05-05
- s64:
- 64 2008-04-30 2008-05-01 2008-05-02 2008-05-04 2008-05-05 2008-05-06
- s66:
- 66 2005-09-11 2008-05-01 2008-05-02 2008-05-04 2008-05-05 2005-09-13
- s67:
- 67 2008-05-08 2008-05-09 2005-09-11 2008-05-12 2008-05-13 2008-05-14 2008-05-15 2005-09-15
- s68:
- 68 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:
- 69 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:
- 70 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