Spreadsheet: 125304d1318960133-if-statement-with-absolutes-aaa
Sheet: Sheet1

Measured Time | Measued Time as dec | Measured Time Rounded | Measured Dist | IF E>0 | If are = only disp one | Subtraction of sec. | [NAME] | AVG Dist/Sec | Calculated dist | Expected Calculated Dist | Continous time
00:00:00.283 | 0 | 1900-01-01 00:00:00 | 198.5 | 198.5 | 0 | 4 | 10.90000000000001 | 2.725000000000001 | 198.5 | 198.5 | 1900-01-01 00:00:00 | 1 |  | Expected N |  | Expected P |  | Expected R |  | Expected T |  | Expected V |  | Expected X
00:00:00.283 | 0 | 1900-01-01 00:00:00 | 0 |  |  |  |  |  | 195.775 | 195.775 | 00:00:01 |  | 4 | 4 | 2.725000000000001 | 2.725 | 187.6 | 187.6 | 4 | 4 | 2.725000000000001 | 2.725 | 187.6 | 187.6
00:00:00.283 | 0 | 1900-01-01 00:00:00 | 0 |  |  |  |  |  | 193.05 | 193.05 | 00:00:02 |  | 1 | 1 | 2.300000000000011 | 2.3 | 189.9 | 189.9 | 5 | 5 | 2.725000000000001 | 2.725 | 187.6 | 187.6
00:00:03.5 | 4 | 00:00:04 | 187.6 | 187.6 | 4 | 1 | 2.300000000000011 | 2.300000000000011 | 190.325 | 190.325 | 00:00:03 | 2 | 1 | 1 | 0.9000000000000057 | 0.9 | 189 | 189 | 6 | 6 | 2.725000000000001 | 2.725 | 187.6 | 187.6
00:00:03.585 | 4 | 00:00:04 | 0 |  |  |  |  |  | 187.6 | 187.6 | 00:00:04 |  | 1 | 1 | 15.30000000000001 | 15.3 | 204.3 | 204.3 | 7 | 7 | 2.725000000000001 | 2.725 | 187.6 | 187.6
00:00:03.5 | 4 | 00:00:04 | 0 |  |  |  |  |  | 189.9 | 189.9 | 00:00:05 |  | 1 | 1 | 14.60000000000002 | 14.6 | 189.7 | 189.7 | 8 | 8 | 2.300000000000011 | 2.3 | 189.9 | 189.9
00:00:04.587 | 5 | 00:00:05 | 189.9 | 189.9 | 5 | 1 | 0.9000000000000057 | 0.9000000000000057 | 189 | 189 | 00:00:06 | 3 | 1 | 1 | 0.1999999999999886 | 0.2 | 189.5 | 189.5 | 9 | 9 | 0.9000000000000057 | 0.9 | 189 | 189
00:00:04.5 | 5 | 00:00:05 | 0 |  |  |  |  |  | 204.3 | 204.3 | 00:00:07 |  | 3 | 3 | 0.06666666666666288 | 0.066667 | 189.3 | 189.3 | 12 | 12 | 15.30000000000001 | 15.3 | 204.3 | 204.3
00:00:04.5 | 5 | 00:00:05 | 0 |  |  |  |  |  | 189.7 | 189.7 | 00:00:08 |  | 1.000000000000002 | 1 | 0.4999999999999991 | 0.5 | 189.8 | 189.8 | 13 | 13 | 14.60000000000002 | 14.6 | 189.7 | 189.7
00:00:06 | 6 | 00:00:06 | 189 | 189 | 6 | 1 | 15.30000000000001 | 15.30000000000001 | 189.5 | 189.5 | 00:00:09 | 4 | 0.9999999999999982 | 1 | 0.6000000000000238 | 0.6 | 189.2 | 189.2 | 14 | 14 | 0.1999999999999886 | 0.2 | 189.5 | 189.5
00:00:06 | 6 | 00:00:06 | 0 |  |  |  |  |  | 189.4333333333334 | 189.433333 | 00:00:10 |  | 1 | 1 | 0.700000000000017 | 0.7 | 189.9 | 189.9 | 15 | 15 | 0.06666666666666288 | 0.066667 | 189.3 | 189.3
00:00:06 | 6 | 00:00:06 | 0 |  |  |  |  |  | 189.3666666666667 | 189.3666667 | 00:00:11 |  | 1 | 1 | 1.299999999999983 | 1.3 | 191.2 | 191.2 | 16 | 16 | 0.06666666666666288 | 0.066667 | 189.3 | 189.3
00:00:07 | 7 | 00:00:07 | 204.3 | 204.3 | 7 | 1 | 14.60000000000002 | 14.60000000000002 | 189.3 | 189.3 | 00:00:12 | 5 | 1 | 1 | 1.399999999999977 | 1.4 | 189.8 | 189.8 | 17 | 17 | 0.06666666666666288 | 0.066667 | 189.3 | 189.3
00:00:07 | 7 | 00:00:07 | 0 |  |  |  |  |  | 189.8 |  | 00:00:13 |  |  | 1 |  | 0 | 189.8 | 189.8 | 17 | 18 | 0.4999999999999991 | 0.5 | 189.8 | 189.8
00:00:07 | 7 | 00:00:07 | 0 |  |  |  |  |  | 189.2 |  | 00:00:14 |  |  | 1 |  | 0.6 |  | 190.4 | 17 | 19 | 0.6000000000000238 | 0.6 | 189.2 | 189.2
00:00:08 | 8 | 00:00:08 | 189.7 | 189.7 | 8 | 1 | 0.1999999999999886 | 0.1999999999999886 | 189.9 |  | 00:00:15 | 6 |  | 1 |  | 0.7 |  | 189.7 | 17 | 20 | 0.700000000000017 | 0.7 | 189.9 | 189.9
00:00:08 | 8 | 00:00:08 | 0 |  |  |  |  |  | 191.2 |  | 00:00:16 |  |  |  |  |  |  |  | 17 | 21 | 1.299999999999983 | 1.3 | 191.2 | 191.2
00:00:08 | 8 | 00:00:08 | 0 |  |  |  |  |  | 189.8 |  | 00:00:17 |  |  |  |  |  |  |  | 17 |  | 1.399999999999977 | 1.4 | 189.8 | 189.8
00:00:09 | 9 | 00:00:09 | 189.5 | 189.5 | 9 | 3 | 0.1999999999999886 | 0.06666666666666288 | #N/A |  | 00:00:18 | 7 |  |  |  |  |  |  | 17 |  |  | 0 | 189.8 | 189.8
00:00:09 | 9 | 00:00:09 | 0 |  |  |  |  |  | #N/A |  | 00:00:19 |  |  |  |  |  |  |  | 17 |  |  | 0.6 | 189.8 | 190.4
00:00:09 | 9 | 00:00:09 | 0 |  |  |  |  |  | #N/A |  | 00:00:20 |  |  |  |  |  |  |  | 17 |  |  | 0.7 | 189.8 | 189.7
00:00:12 | 12 | 00:00:12 | 189.3 | 189.3 | 12 | 1.000000000000002 | 0.5 | 0.4999999999999991 | #N/A |  | 00:00:21 | 8 |  |  |  |  |  |  | 17 |  |  |  | 189.8
00:00:12 | 12 | 00:00:12 | 0 |  |  |  |  |  | #N/A |  | 00:00:22 |  |  |  |  |  |  |  | 17 |  |  |  | 189.8
00:00:12 | 12 | 00:00:12 | 0 |  |  |  |  |  | #N/A |  | 00:00:23 |  |  |  |  |  |  |  | 17 |  |  |  | 189.8
00:00:13 | 13 | 00:00:13 | 189.8 | 189.8 | 13 | 0.9999999999999982 | 0.6000000000000227 | 0.6000000000000238 | #N/A |  | 00:00:24 | 9 |  |  |  |  |  |  | 17 |  |  |  | 189.8
00:00:13 | 13 | 00:00:13 | 0 |  |  |  |  |  | #N/A |  | 00:00:25 |  |  |  |  |  |  |  | 17 |  |  |  | 189.8
00:00:13 | 13 | 00:00:13 | 0 |  |  |  |  |  | #N/A |  | 00:00:26 |  |  |  |  |  |  |  | 17 |  |  |  | 189.8
00:00:14 | 14 | 00:00:14 | 189.2 | 189.2 | 14 | 1 | 0.700000000000017 | 0.700000000000017 | #N/A |  | 00:00:27 | 10 |  |  |  |  |  |  | 17 |  |  |  | 189.8
00:00:14 | 14 | 00:00:14 | 0 |  |  |  |  |  | #N/A |  | 00:00:28 |  |  |  |  |  |  |  | 17 |  |  |  | 189.8
00:00:14 | 14 | 00:00:14 | 0 |  |  |  |  |  | #N/A |  | 00:00:29 |  |  |  |  |  |  |  | 17 |  |  |  | 189.8
00:00:15 | 15 | 00:00:15 | 189.9 | 189.9 | 15 | 1 | 1.299999999999983 | 1.299999999999983 | #N/A |  | 00:00:30 | 11 |  |  |  |  |  |  | 17 |  |  |  | 189.8
00:00:15 | 15 | 00:00:15 | 0 |  |  |  |  |  | #N/A |  | 00:00:31 |  |  |  |  |  |  |  | 17 |  |  |  | 189.8
00:00:15 | 15 | 00:00:15 | 0 |  |  |  |  |  | #N/A |  | 00:00:32 |  |  |  |  |  |  |  | 17 |  |  |  | 189.8
00:00:16 | 16 | 00:00:16 | 191.2 | 191.2 | 16 | 1 | 1.399999999999977 | 1.399999999999977 | #N/A |  | 00:00:33 | 12 |  |  |  |  |  |  | 17 |  |  |  | 189.8
00:00:16 | 16 | 00:00:16 | 0 |  |  |  |  |  | #N/A |  | 00:00:34 |  |  |  |  |  |  |  | 17 |  |  |  | 189.8
00:00:16 | 16 | 00:00:16 | 0 |  |  |  |  |  | #N/A |  | 00:00:35 |  |  |  |  |  |  |  | 17 |  |  |  | 189.8
00:00:17 | 17 | 00:00:17 | 0 |  | 17 | 1 |  | 0 | #N/A |  | 00:00:36 |  |  |  |  |  |  |  | 17 |  |  |  | 189.8
00:00:17 | 17 | 00:00:17 | 0 |  |  |  |  |  | #N/A |  | 00:00:37 |  |  |  |  |  |  |  | 17 |  |  |  | 189.8
00:00:17 | 17 | 00:00:17 | 189.8 | 189.8 |  |  | 0 |  | #N/A |  | 00:00:38 | 13 |  |  |  |  |  |  | 17 |  |  |  | 189.8
[NAME] | 18 | 00:00:18 | 0 |  | 18 | 1 |  | 0.5999999999999943 | #N/A |  | 00:00:39 |  |  |  |  |  |  |  | 17 |  |  |  | 189.8
[NAME] | 18 | 00:00:18 | 0 |  |  |  |  |  | #N/A |  | 00:00:40 |  |  |  |  |  |  |  | 17 |  |  |  | 189.8
[NAME] | 18 | 00:00:18 | 189.8 | 189.8 |  |  | 0.5999999999999943 |  | #N/A |  | 00:00:41 | 14 |  |  |  |  |  |  | 17 |  |  |  | 189.8
00:00:19 | 19 | 00:00:19 | 0 |  | 19 | 1 |  | 0.700000000000017 | #N/A |  | 00:00:42 |  |  |  |  |  |  |  | 17 |  |  |  | 189.8
00:00:19 | 19 | 00:00:19 | 190.4 | 190.4 |  |  | 0.700000000000017 |  | #N/A |  | 00:00:43 | 15 |  |  |  |  |  |  | 17 |  |  |  | 189.8
00:00:19 | 19 | 00:00:19 | 0 |  |  |  |  |  | #N/A |  | 00:00:44 |  |  |  |  |  |  |  | 17 |  |  |  | 189.8
00:00:20 | 20 | 00:00:20 | 0 |  | 20 | -20 |  | 0 | #N/A |  | 00:00:45 |  |  |  |  |  |  |  | 17 |  |  |  | 189.8
00:00:20 | 20 | 00:00:20 | 0 |  |  |  |  |  | #N/A |  | 00:00:46 |  |  |  |  |  |  |  | 17 |  |  |  | 189.8
00:00:20 | 20 | 00:00:20 | 189.7 | 189.7 |  |  | 0 |  | #N/A |  | 00:00:47 | 16 |  |  |  |  |  |  | 17 |  |  |  | 189.8
 |  |  |  |  | 0