Spreadsheet: 125235d1318942386-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
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 | 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 | 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 | 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 | 189.3 | 189.3 | 00:00:12 | 5 | 1 |  |  | 17 | 0.06666666666666288 | 189.3
00:00:07 | 7 | 00:00:07 | 0 |  |  |  |  |  | 189.8 |  | 00:00:13 |  |  |  |  | 17 | 0.4999999999999991 | 189.8
00:00:07 | 7 | 00:00:07 | 0 |  |  |  |  |  | 189.2 |  | 00:00:14 |  |  |  |  | 17 | 0.6000000000000238 | 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 |  |  |  | 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 |  |  |  |  |  |  |  | 00:00:17 |  |  |  |  | 17
00:00:09 | 9 | 00:00:09 | 189.5 | 189.5 | 9 | 3 | 0.1999999999999886 | 0.06666666666666288 |  |  | 00:00:18 | 7 |  |  |  | 17
00:00:09 | 9 | 00:00:09 | 0 |  |  |  |  |  |  |  | 00:00:19 |  |  |  |  | 17
00:00:09 | 9 | 00:00:09 | 0
00:00:12 | 12 | 00:00:12 | 189.3 | 189.3 | 12 | 1.000000000000002 | 0.5 | 0.4999999999999991 |  |  |  | 8
00:00:12 | 12 | 00:00:12 | 0
00:00:12 | 12 | 00:00:12 | 0
00:00:13 | 13 | 00:00:13 | 189.8 | 189.8 | 13 | 0.9999999999999982 | 0.6000000000000227 | 0.6000000000000238 |  |  |  | 9
00:00:13 | 13 | 00:00:13 | 0
00:00:13 | 13 | 00:00:13 | 0
00:00:14 | 14 | 00:00:14 | 189.2 | 189.2 | 14 | 1 | 0.700000000000017 | 0.700000000000017 |  |  |  | 10
00:00:14 | 14 | 00:00:14 | 0
00:00:14 | 14 | 00:00:14 | 0
00:00:15 | 15 | 00:00:15 | 189.9 | 189.9 | 15 | 1 | 1.299999999999983 | 1.299999999999983 |  |  |  | 11
00:00:15 | 15 | 00:00:15 | 0
00:00:15 | 15 | 00:00:15 | 0
00:00:16 | 16 | 00:00:16 | 191.2 | 191.2 | 16 | 1 |  |  |  |  |  | 12
00:00:16 | 16 | 00:00:16 | 0
00:00:16 | 16 | 00:00:16 | 0
00:00:17 | 17 | 00:00:17 | 0 |  | 17 | 1
00:00:17 | 17 | 00:00:17 | 0
00:00:17 | 17 | 00:00:17 | 189.8 | 189.8 |  |  | 0 |  |  |  |  | 13
[NAME] | 18 | 00:00:18 | 0 |  | 18 | 1
[NAME] | 18 | 00:00:18 | 0
[NAME] | 18 | 00:00:18 | 189.8 | 189.8 |  |  |  |  |  |  |  | 14
00:00:19 | 19 | 00:00:19 | 0 |  | 19 | 1
00:00:19 | 19 | 00:00:19 | 190.4 | 190.4 |  |  |  |  |  |  |  | 15
00:00:19 | 19 | 00:00:19 | 0
00:00:20 | 20 | 00:00:20 | 0 |  | 20
00:00:20 | 20 | 00:00:20 | 0
00:00:20 | 20 | 00:00:20 | 189.7 | 189.7