Spreadsheet: 125274d1318951415-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 | Expected Dis/S | 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 | 2.725 | 198.5 | 198.5 | 1900-01-01 00:00:00 | 1
00:00:00.283 | 0 | 1900-01-01 00:00:00 | 0 |  |  |  |  |  |  | 195.775 | 195.775 | 00:00:01 |  | 4 | 2.725000000000001 | 187.6 | 4 | 2.725000000000001 | 187.6
00:00:00.283 | 0 | 1900-01-01 00:00:00 | 0 |  |  |  |  |  |  | 193.05 | 193.05 | 00:00:02 |  | 1 | 2.300000000000011 | 189.9 | 5 | 2.725000000000001 | 187.6
00:00:03.5 | 4 | 00:00:04 | 187.6 | 187.6 | 4 | 1 | 2.300000000000011 | 2.300000000000011 | 2.3 | 190.325 | 190.325 | 00:00:03 | 2 | 1 | 0.9000000000000057 | 189 | 6 | 2.725000000000001 | 187.6
00:00:03.585 | 4 | 00:00:04 | 0 |  |  |  |  |  |  | 187.6 | 187.6 | 00:00:04 |  | 1 | 15.30000000000001 | 204.3 | 7 | 2.725000000000001 | 187.6
00:00:03.5 | 4 | 00:00:04 | 0 |  |  |  |  |  |  | 189.9 | 189.9 | 00:00:05 |  | 1 | 14.60000000000002 | 189.7 | 8 | 2.300000000000011 | 189.9
00:00:04.587 | 5 | 00:00:05 | 189.9 | 189.9 | 5 | 1 | 0.9000000000000057 | 0.9000000000000057 | 0.9 | 189 | 189 | 00:00:06 | 3 | 1 | 0.1999999999999886 | 189.5 | 9 | 0.9000000000000057 | 189
00:00:04.5 | 5 | 00:00:05 | 0 |  |  |  |  |  |  | 204.3 | 204.3 | 00:00:07 |  | 3 | 0.06666666666666288 | 189.3 | 12 | 15.30000000000001 | 204.3
00:00:04.5 | 5 | 00:00:05 | 0 |  |  |  |  |  |  | 189.7 | 189.7 | 00:00:08 |  | 1.000000000000002 | 0.4999999999999991 | 189.8 | 13 | 14.60000000000002 | 189.7
00:00:06 | 6 | 00:00:06 | 189 | 189 | 6 | 1 | 15.30000000000001 | 15.30000000000001 | 15.3 | 189.5 | 189.5 | 00:00:09 | 4 | 0.9999999999999982 | 0.6000000000000238 | 189.2 | 14 | 0.1999999999999886 | 189.5
00:00:06 | 6 | 00:00:06 | 0 |  |  |  |  |  |  | 189.4333333333334 | 189.433333 | 00:00:10 |  | 1 | 0.700000000000017 | 189.9 | 15 | 0.06666666666666288 | 189.3
00:00:06 | 6 | 00:00:06 | 0 |  |  |  |  |  |  | 189.3666666666667 | 189.3666667 | 00:00:11 |  | 1 | 1.299999999999983 | 191.2 | 16 | 0.06666666666666288 | 189.3
00:00:07 | 7 | 00:00:07 | 204.3 | 204.3 | 7 | 1 | 14.60000000000002 | 14.60000000000002 | 14.6 | 189.3 | 189.3 | 00:00:12 | 5 | 1 | 1.399999999999977 | 189.8 | 17 | 0.06666666666666288 | 189.3
00:00:07 | 7 | 00:00:07 | 0 |  |  |  |  |  |  | 189.8 |  | 00:00:13 |  |  |  | 189.8 | 17 | 0.4999999999999991 | 189.8
00:00:07 | 7 | 00:00:07 | 0 |  |  |  |  |  |  | 189.2 |  | 00:00:14 |  |  |  | 190.4 | 17 | 0.6000000000000238 | 189.2
00:00:08 | 8 | 00:00:08 | 189.7 | 189.7 | 8 | 1 | 0.1999999999999886 | 0.1999999999999886 | 0.2 | 189.9 |  | 00:00:15 | 6 |  |  |  | 17 | 0.700000000000017 | 189.9
00:00:08 | 8 | 00:00:08 | 0 |  |  |  |  |  |  | 191.2 |  | 00:00:16 |  |  |  |  | 17 | 1.299999999999983 | 191.2
00:00:08 | 8 | 00:00:08 | 0 |  |  |  |  |  |  | 189.8 |  | 00:00:17 |  |  |  |  | 17 | 1.399999999999977 | 189.8
00:00:09 | 9 | 00:00:09 | 189.5 | 189.5 | 9 | 3 | 0.1999999999999886 | 0.06666666666666288 | 0.06666667 | #N/A |  | 00:00:18 | 7 |  |  |  | 17 |  | 189.8
00:00:09 | 9 | 00:00:09 | 0 |  |  |  |  |  |  |  |  | 00:00:19 |  |  |  |  | 17 |  | 189.8
00:00:09 | 9 | 00:00:09 | 0 |  |  |  |  |  |  |  |  | 00:00:20
00:00:12 | 12 | 00:00:12 | 189.3 | 189.3 | 12 | 1.000000000000002 | 0.5 | 0.4999999999999991 | 0.5 |  |  | 00:00:21 | 8
00:00:12 | 12 | 00:00:12 | 0 |  |  |  |  |  |  |  |  | 00:00:22
00:00:12 | 12 | 00:00:12 | 0 |  |  |  |  |  |  |  |  | 00:00:23
00:00:13 | 13 | 00:00:13 | 189.8 | 189.8 | 13 | 0.9999999999999982 | 0.6000000000000227 | 0.6000000000000238 | 0.6 |  |  | 00:00:24 | 9
00:00:13 | 13 | 00:00:13 | 0 |  |  |  |  |  |  |  |  | 00:00:25
00:00:13 | 13 | 00:00:13 | 0 |  |  |  |  |  |  |  |  | 00:00:26
00:00:14 | 14 | 00:00:14 | 189.2 | 189.2 | 14 | 1 | 0.700000000000017 | 0.700000000000017 | 0.7 |  |  | 00:00:27 | 10
00:00:14 | 14 | 00:00:14 | 0 |  |  |  |  |  |  |  |  | 00:00:28
00:00:14 | 14 | 00:00:14 | 0 |  |  |  |  |  |  |  |  | 00:00:29
00:00:15 | 15 | 00:00:15 | 189.9 | 189.9 | 15 | 1 | 1.299999999999983 | 1.299999999999983 | 1.3 |  |  | 00:00:30 | 11
00:00:15 | 15 | 00:00:15 | 0 |  |  |  |  |  |  |  |  | 00:00:31
00:00:15 | 15 | 00:00:15 | 0 |  |  |  |  |  |  |  |  | 00:00:32
00:00:16 | 16 | 00:00:16 | 191.2 | 191.2 | 16 | 1 | 1.399999999999977 | 1.399999999999977 | 1.4 |  |  | 00:00:33 | 12
00:00:16 | 16 | 00:00:16 | 0 |  |  |  |  |  |  |  |  | 00:00:34
00:00:16 | 16 | 00:00:16 | 0 |  |  |  |  |  |  |  |  | 00:00:35
00:00:17 | 17 | 00:00:17 | 0 |  | 17 | 1 |  |  | 0 |  |  | 00:00:36
00:00:17 | 17 | 00:00:17 | 0 |  |  |  |  |  |  |  |  | 00:00:37
00:00:17 | 17 | 00:00:17 | 189.8 | 189.8 |  |  | 0 |  |  |  |  | 00:00:38 | 13
[NAME] | 18 | 00:00:18 | 0 |  | 18 | 1 |  |  | 0.6 |  |  | 00:00:39
[NAME] | 18 | 00:00:18 | 0 |  |  |  |  |  |  |  |  | 00:00:40
[NAME] | 18 | 00:00:18 | 189.8 | 189.8 |  |  | 0.5999999999999943 |  |  |  |  | 00:00:41 | 14
00:00:19 | 19 | 00:00:19 | 0 |  | 19 | 1 |  |  | 0.7 |  |  | 00:00:42
00:00:19 | 19 | 00:00:19 | 190.4 | 190.4 |  |  | 0.700000000000017 |  |  |  |  | 00:00:43 | 15
00:00:19 | 19 | 00:00:19 | 0 |  |  |  |  |  |  |  |  | 00:00:44
00:00:20 | 20 | 00:00:20 | 0 |  | 20 |  |  |  | N/A |  |  | 00:00:45
00:00:20 | 20 | 00:00:20 | 0 |  |  |  |  |  |  |  |  | 00:00:46
00:00:20 | 20 | 00:00:20 | 189.7 | 189.7 |  |  | 0 |  |  |  |  | 00:00:47 | 16