Spreadsheet: 752955d1635140902-predicting-finish-time-for-running-races-time-prediction
Sheet: Sheet1

Pl | ID | Blank | LName | FName | City | FS | True Finish | Variable | Variable2 | time first seen | time finish | prediction | delta |  |  |  | time first seen | time finish |  |  | Calculate Estimated Finish | Variable 2 Estimated Finish | Pl | ID | Blank | Lname | Fname | City | Finish |  | Variable Average | Variable2 Average
11 | 3 |  |  |  | Springfield | 5:59.7 |  |  |  |  |  |  |  |  |  |  | 00:05:54.500000 | 00:23:59.790000 |  |  |  |  | 1 | 3 |  |  |  | Springfield | 23:52.84
1 | 133 |  |  |  | Springfield | 5:54.5 |  |  |  |  |  |  |  |  | all arrived runners |  | 00:05:57.700000 | 00:25:35.340000 |  |  |  |  | 2 | 133 |  |  |  | Springfield | 23:59.79
34 | 8 |  |  |  | Springfield | 6:01.1 |  |  |  |  |  |  |  |  |  | 0 | 00:05:59.300000 | 00:24:13.230000 |  |  |  |  | 3 | 8 |  |  |  | Springfield | 24:11.89
25 | 51 |  |  |  | Springfield | 6:00.2 |  |  |  |  |  |  |  |  | runners with 1st time < 06:10 |  | 00:05:59.300000 | 00:24:35.580000 |  |  |  |  | 4 | 51 |  |  |  | Springfield | 24:12.50
3 | 98 |  |  |  | Springfield | 5:59.3 |  |  |  |  |  |  |  |  |  | 0 | 00:05:59.300000 | 00:24:40.270000 |  |  |  |  | 5 | 98 |  |  |  | Springfield | 24:13.23
46 | 4 |  |  |  | Springfield | 6:02.4 |  |  |  |  |  |  |  |  | runners with 1st time > 06:10 |  | 00:05:59.300000 | 00:24:45.880000 |  |  |  |  | 6 | 4 |  |  |  | Springfield | 24:22.19
15 | 60 |  |  |  | Springfield | 5:59.8 |  |  |  |  |  |  |  |  |  | 0 | 00:05:59.400000 | 00:24:48.170000 |  |  |  |  | 7 | 60 |  |  |  | Springfield | 24:30.56
17 | 64 |  |  |  | Springfield | 5:59.8 |  |  |  |  |  |  |  |  |  |  | 00:05:59.500000 | 00:25:17.420000 |  |  |  |  | 8 | 64 |  |  |  | Springfield | 24:31.57
4 | 116 |  |  |  | Springfield | 5:59.3 |  |  |  |  |  |  |  |  |  |  | 00:05:59.500000 | 00:25:20.140000 |  |  |  |  | 9 | 116 |  |  |  | Springfield | 24:35.58
43 | 111 |  |  |  | Springfield | 6:02.0 |  |  |  |  |  |  |  |  |  |  | 00:05:59.500000 | 00:25:41.050000 |  |  |  |  | 10 | 111 |  |  |  | Springfield | 24:40.03
5 | 132 |  |  |  | Springfield | 5:59.3 |  |  |  |  |  |  |  |  |  |  | 00:05:59.700000 | 00:23:52.840000 |  |  |  |  | 11 | 132 |  |  |  | Springfield | 24:40.27
28 | 129 |  |  |  | Springfield | 6:00.7 |  |  |  |  |  |  |  |  |  |  | 00:05:59.700000 | 00:24:42.330000 |  |  |  |  | 12 | 129 |  |  |  | Springfield | 24:40.87
13 | 73 |  |  |  | Springfield | 5:59.7 |  |  |  |  |  |  |  |  |  |  | 00:05:59.700000 | 00:24:46.150000 |  |  |  |  | 13 | 73 |  |  |  | Springfield | 24:42.33
41 | 53 |  |  |  | Springfield | 6:01.9 |  |  |  |  |  |  |  |  |  |  | 00:05:59.700000 | 00:25:20.260000 |  |  |  |  | 14 | 53 |  |  |  | Springfield | 24:43.00
6 | 123 |  |  |  | Springfield | 5:59.3 |  |  |  |  |  |  |  |  |  |  | 00:05:59.800000 | 00:24:30.560000 |  |  |  |  | 15 | 104 |  |  |  | Springfield | 24:43.44
14 | 109 |  |  |  | Springfield | 5:59.7 |  |  |  |  |  |  |  |  |  |  | 00:05:59.800000 | 00:24:31.570000 |  |  |  |  | 16 | 123 |  |  |  | Springfield | 24:45.88
23 | 110 |  |  |  | Springfield | 6:00.1 |  |  |  |  |  |  |  |  |  |  | 00:05:59.800000 | 00:25:05.420000 |  |  |  |  | 17 | 109 |  |  |  | Springfield | 24:46.15
7 | 131 |  |  |  | Springfield | 5:59.4 |  |  |  |  |  |  |  |  |  |  | 00:06:00 | 00:24:58.260000 |  |  |  |  | 18 | 110 |  |  |  | Springfield | 24:48.07
33 | 16 |  |  |  | Springfield | 6:01.1 |  |  |  |  |  |  |  |  |  |  | 00:06:00 | 00:25:12.730000 |  |  |  |  | 19 | 131 |  |  |  | Springfield | 24:48.17
62 | 65 |  |  |  | Springfield | 6:07.7 |  |  |  |  |  |  |  |  |  |  | 00:06:00.100000 | 00:24:48.070000 |  |  |  |  | 20 | 16 |  |  |  | Springfield | 24:52.31
20 | 107 |  |  |  | Springfield | 6:00.0 |  |  |  |  |  |  |  |  |  |  | 00:06:00.100000 | 00:25:07.460000 |  |  |  |  | 21 | 65 |  |  |  | Springfield | 24:55.38
35 | 127 |  |  |  | Springfield | 6:01.1 |  |  |  |  |  |  |  |  |  |  | 00:06:00.100000 | 00:25:36.790000 |  |  |  |  | 22 | 107 |  |  |  | Springfield | 24:58.26
40 | 134 |  |  |  | Springfield | 6:01.7 |  |  |  |  |  |  |  |  |  |  | 00:06:00.200000 | 00:24:12.500000 |  |  |  |  | 23 | 127 |  |  |  | Springfield | 25:01.70
61 | 1 |  |  |  | Springfield | 6:07.2 |  |  |  |  |  |  |  |  |  |  | 00:06:00.600000 | 00:27:07.490000 |  |  |  |  | 24 | 134 |  |  |  | Springfield | 25:02.73
16 | 102 |  |  |  | Springfield | 5:59.8 |  |  |  |  |  |  |  |  |  |  | 00:06:00.700000 | 00:24:40.870000 |  |  |  |  | 25 | 1 |  |  |  | Springfield | 25:04.05
37 | 14 |  |  |  | Springfield | 6:01.3 |  |  |  |  |  |  |  |  |  |  | 00:06:00.800000 | 00:25:28.840000 |  |  |  |  | 26 | 102 |  |  |  | Springfield | 25:05.42
22 | 54 |  |  |  | Springfield | 6:00.1 |  |  |  |  |  |  |  |  |  |  | 00:06:00.800000 | 00:26:02.440000 |  |  |  |  | 27 | 14 |  |  |  | Springfield | 25:07.16
42 | 62 |  |  |  | Springfield | 6:02.0 |  |  |  |  |  |  |  |  |  |  | 00:06:01 | 00:25:34.910000 |  |  |  |  | 28 | 54 |  |  |  | Springfield | 25:07.46
36 | 2 |  |  |  | Springfield | 6:01.2 |  |  |  |  |  |  |  |  |  |  | 00:06:01 | 00:25:36.720000 |  |  |  |  | 29 | 62 |  |  |  | Springfield | 25:07.95
21 | 5 |  |  |  | Springfield | 6:00.0 |  |  |  |  |  |  |  |  |  |  | 00:06:01.100000 | 00:24:11.890000 |  |  |  |  | 30 | 2 |  |  |  | Springfield | 25:10.85
60 | 58 |  |  |  | Springfield | 6:07.1 |  |  |  |  |  |  |  |  |  |  | 00:06:01.100000 | 00:24:52.310000 |  |  |  |  | 31 | 5 |  |  |  | Springfield | 25:12.73
54 | 19 |  |  |  | Springfield | 6:03.7 |  |  |  |  |  |  |  |  |  |  | 00:06:01.100000 | 00:25:01.700000 |  |  |  |  | 32 | 58 |  |  |  | Springfield | 25:14.44
10 | 119 |  |  |  | Springfield | 5:59.5 |  |  |  |  |  |  |  |  |  |  | 00:06:01.200000 | 00:25:10.850000 |  |  |  |  | 33 | 19 |  |  |  | Springfield | 25:16.82
57 | 26 |  |  |  | Springfield | 6:06.7 |  |  |  |  |  |  |  |  |  |  | 00:06:01.300000 | 00:25:07.160000 |  |  |  |  | 34 | 119 |  |  |  | Springfield | 25:17.42
8 | 117 |  |  |  | Springfield | 5:59.5 |  |  |  |  |  |  |  |  |  |  | 00:06:01.400000 | 00:26:12.970000 |  |  |  |  | 35 | 26 |  |  |  | Springfield | 25:17.54
12 | 6 |  |  |  | Springfield | 5:59.7 |  |  |  |  |  |  |  |  |  |  | 00:06:01.500000 | 00:25:30.090000 |  |  |  |  | 36 | 117 |  |  |  | Springfield | 25:20.14
44 | 101 |  |  |  | Springfield | 6:02.0 |  |  |  |  |  |  |  |  |  |  | 00:06:01.700000 | 00:25:02.730000 |  |  |  |  | 37 | 6 |  |  |  | Springfield | 25:20.26
48 | 66 |  |  |  | Springfield | 6:02.5 |  |  |  |  |  |  |  |  |  |  | 00:06:01.900000 | 00:24:43 |  |  |  |  | 38 | 101 |  |  |  | Springfield | 25:21.25
47 | 56 |  |  |  | Springfield | 6:02.4 |  |  |  |  |  |  |  |  |  |  | 00:06:02 | 00:24:40.030000 |  |  |  |  | 39 | 66 |  |  |  | Springfield | 25:23.18
30 | 47 |  |  |  | Springfield | 6:00.8 |  |  |  |  |  |  |  |  |  |  | 00:06:02 | 00:25:07.950000 |  |  |  |  | 40 | 56 |  |  |  | Springfield | 25:26.70
39 | 45 |  |  |  | Springfield | 6:01.5 |  |  |  |  |  |  |  |  |  |  | 00:06:02 | 00:25:21.250000 |  |  |  |  | 41 | 47 |  |  |  | Springfield | 25:28.84
73 | 7 |  |  |  | Springfield | 6:16.7 |  |  |  |  |  |  |  |  |  |  | 00:06:02.100000 | 00:26:15.630000 |  |  |  |  | 42 | 45 |  |  |  | Springfield | 25:30.09
32 | 130 |  |  |  | Springfield | 6:01.0 |  |  |  |  |  |  |  |  |  |  | 00:06:02.400000 | 00:24:22.190000 |  |  |  |  | 43 | 7 |  |  |  | Springfield | 25:32.85
2 | 135 |  |  |  | Springfield | 5:57.7 |  |  |  |  |  |  |  |  |  |  | 00:06:02.400000 | 00:25:26.700000 |  |  |  |  | 44 | 130 |  |  |  | Springfield | 25:34.91
31 | 121 |  |  |  | Springfield | 6:01.0 |  |  |  |  |  |  |  |  |  |  | 00:06:02.500000 | 00:25:23.180000 |  |  |  |  | 45 | 135 |  |  |  | Springfield | 25:35.34
24 | 106 |  |  |  | Springfield | 6:00.1 |  |  |  |  |  |  |  |  |  |  | 00:06:02.600000 | 00:26:34.060000 |  |  |  |  | 46 | 121 |  |  |  | Springfield | 25:36.72
8 | 125 |  |  |  | Springfield | 5:59.5 |  |  |  |  |  |  |  |  |  |  | 00:06:02.800000 | 00:26:03.510000 |  |  |  |  | 47 | 106 |  |  |  | Springfield | 25:36.79
67 | 61 |  |  |  | Springfield | 6:14.2 |  |  |  |  |  |  |  |  |  |  | 00:06:03 | 00:25:56.300000 |  |  |  |  | 48 | 125 |  |  |  | Springfield | 25:41.05
59 | 24 |  |  |  | Springfield | 6:06.9 |  |  |  |  |  |  |  |  |  |  | 00:06:03.300000 | 00:26:39.240000 |  |  |  |  | 49 | 61 |  |  |  | Springfield | 25:41.54
53 | 9 |  |  |  | Springfield | 6:03.5 |  |  |  |  |  |  |  |  |  |  | 00:06:03.500000 | 00:25:53.800000 |  |  |  |  | 50 | 24 |  |  |  | Springfield | 25:43.94
51 | 13 |  |  |  | Springfield | 6:03.0 |  |  |  |  |  |  |  |  |  |  | 00:06:03.700000 | 00:25:16.820000 |  |  |  |  | 51 | 9 |  |  |  | Springfield | 25:53.80
72 | 52 |  |  |  | Springfield | 6:15.1 |  |  |  |  |  |  |  |  |  |  | 00:06:06.600000 | 00:26:30.860000 |  |  |  |  | 52 | 13 |  |  |  | Springfield | 25:56.30
29 | 115 |  |  |  | Springfield | 6:00.8 |  |  |  |  |  |  |  |  |  |  | 00:06:06.700000 | 00:25:17.540000 |  |  |  |  | 53 | 52 |  |  |  | Springfield | 25:58.21
50 | 68 |  |  |  | Springfield | 6:02.8 |  |  |  |  |  |  |  |  |  |  | 00:06:06.800000 | 00:26:44.760000 |  |  |  |  | 54 | 115 |  |  |  | Springfield | 26:02.44
65 | 10 |  |  |  | Springfield | 6:11.7 |  |  |  |  |  |  |  |  |  |  | 00:06:06.900000 | 00:25:43.940000 |  |  |  |  | 55 | 68 |  |  |  | Springfield | 26:03.51
71 | 55 |  |  |  | Springfield | 6:15.0 |  |  |  |  |  |  |  |  |  |  | 00:06:07.100000 | 00:25:14.440000 |  |  |  |  | 56 | 10 |  |  |  | Springfield | 26:08.87
89 | 21 |  |  |  | Springfield | 6:25.0 |  |  |  |  |  |  |  |  |  |  | 00:06:07.200000 | 00:25:04.050000 |  |  |  |  | 57 | 55 |  |  |  | Springfield | 26:09.39
38 | 126 |  |  |  | Springfield | 6:01.4 |  |  |  |  |  |  |  |  |  |  | 00:06:07.700000 | 00:24:55.380000 |  |  |  |  | 58 | 21 |  |  |  | Springfield | 26:10.11
45 | 59 |  |  |  | Springfield | 6:02.1 |  |  |  |  |  |  |  |  |  |  | 00:06:10.300000 | 00:26:37.820000 |  |  |  |  | 59 | 126 |  |  |  | Springfield | 26:12.97
74 | 40 |  |  |  | Springfield | 6:17.1 |  |  |  |  |  |  |  |  |  |  | 00:06:10.600000 | 00:27:05.680000 |  |  |  |  | 60 | 59 |  |  |  | Springfield | 26:15.63
90 | 23 |  |  |  | Springfield | 6:25.0 |  |  |  |  |  |  |  |  |  |  | 00:06:11.700000 | 00:26:08.870000 |  |  |  |  | 61 | 40 |  |  |  | Springfield | 26:17.28
67 | 78 |  |  |  | Springfield | 6:14.2 |  |  |  |  |  |  |  |  |  |  | 00:06:12.400000 | 00:27:28.310000 |  |  |  |  | 62 | 23 |  |  |  | Springfield | 26:20.40
56 | 118 |  |  |  | Springfield | 6:06.6 |  |  |  |  |  |  |  |  |  |  | 00:06:14.200000 | 00:25:41.540000 |  |  |  |  | 63 | 78 |  |  |  | Springfield | 26:24.45
49 | 103 |  |  |  | Springfield | 6:02.6 |  |  |  |  |  |  |  |  |  |  | 00:06:14.200000 | 00:26:24.450000 |  |  |  |  | 64 | 118 |  |  |  | Springfield | 26:30.86
63 | 49 |  |  |  | Springfield | 6:10.3 |  |  |  |  |  |  |  |  |  |  | 00:06:14.800000 | 00:27:15.690000 |  |  |  |  | 65 | 103 |  |  |  | Springfield | 26:34.06
85 | 80 |  |  |  | Springfield | 6:22.2 |  |  |  |  |  |  |  |  |  |  | 00:06:15 | 00:26:09.390000 |  |  |  |  | 66 | 49 |  |  |  | Springfield | 26:37.82
52 | 18 |  |  |  | Springfield | 6:03.3 |  |  |  |  |  |  |  |  |  |  | 00:06:15.100000 | 00:25:58.210000 |  |  |  |  | 67 | 80 |  |  |  | Springfield | 26:38.00
84 | 67 |  |  |  | Springfield | 6:22.0 |  |  |  |  |  |  |  |  |  |  | 00:06:16.700000 | 00:25:32.850000 |  |  |  |  | 68 | 18 |  |  |  | Springfield | 26:39.24
58 | 48 |  |  |  | Springfield | 6:06.8 |  |  |  |  |  |  |  |  |  |  | 00:06:17.100000 | 00:26:17.280000 |  |  |  |  | 69 | 67 |  |  |  | Springfield | 26:42.26
78 | 75 |  |  |  | Springfield | 6:18.9 |  |  |  |  |  |  |  |  |  |  | 00:06:18.400000 | 00:27:03.990000 |  |  |  |  | 70 | 48 |  |  |  | Springfield | 26:44.76
76 | 41 |  |  |  | Springfield | 6:18.7 |  |  |  |  |  |  |  |  |  |  | 00:06:18.700000 | 00:26:55.400000 |  |  |  |  | 71 | 75 |  |  |  | Springfield | 26:51.80
80 | 79 |  |  |  | Springfield | 6:19.3 |  |  |  |  |  |  |  |  |  |  | 00:06:18.700000 | 00:28:34.320000 |  |  |  |  | 72 | 41 |  |  |  | Springfield | 26:55.40
79 | 81 |  |  |  | Springfield | 6:19.2 |  |  |  |  |  |  |  |  |  |  | 00:06:18.900000 | 00:26:51.800000 |  |  |  |  | 73 | 79 |  |  |  | Springfield | 26:58.02
75 | 42 |  |  |  | Springfield | 6:18.4 |  |  |  |  |  |  |  |  |  |  | 00:06:19.200000 | 00:27:03.820000 |  |  |  |  | 74 | 81 |  |  |  | Springfield | 27:03.82
64 | 74 |  |  |  | Springfield | 6:10.6 |  |  |  |  |  |  |  |  |  |  | 00:06:19.300000 | 00:26:58.020000 |  |  |  |  | 75 | 42 |  |  |  | Springfield | 27:03.99
86 | 100 |  |  |  | Springfield | 6:22.3 |  |  |  |  |  |  |  |  |  |  | 00:06:19.600000 | 00:27:12.550000 |  |  |  |  | 76 | 74 |  |  |  | Springfield | 27:05.68
27 | 105 |  |  |  | Springfield | 6:00.6 |  |  |  |  |  |  |  |  |  |  | 00:06:20 | 00:28:26.920000 |  |  |  |  | 77 | 100 |  |  |  | Springfield | 27:06.38
81 | 12 |  |  |  | Springfield | 6:19.6 |  |  |  |  |  |  |  |  |  |  | 00:06:22 | 00:26:42.260000 |  |  |  |  | 78 | 105 |  |  |  | Springfield | 27:07.49
70 | 72 |  |  |  | Springfield | 6:14.8 |  |  |  |  |  |  |  |  |  |  | 00:06:22.200000 | 00:26:38 |  |  |  |  | 79 | 12 |  |  |  | Springfield | 27:12.55
95 | 25 |  |  |  | Springfield | 6:34.9 |  |  |  |  |  |  |  |  |  |  | 00:06:22.300000 | 00:27:06.380000 |  |  |  |  | 80 | 72 |  |  |  | Springfield | 27:15.69
66 | 43 |  |  |  | Springfield | 6:12.4 |  |  |  |  |  |  |  |  |  |  | 00:06:23 | 00:27:36.790000 |  |  |  |  | 81 | 25 |  |  |  | Springfield | 27:16.92
87 | 37 |  |  |  | Springfield | 6:23.0 |  |  |  |  |  |  |  |  |  |  | 00:06:24.100000 | 00:30:07.450000 |  |  |  |  | 82 | 43 |  |  |  | Springfield | 27:28.31
98 | 32 |  |  |  | Springfield | 6:36.4 |  |  |  |  |  |  |  |  |  |  | 00:06:25 | 00:26:10.110000 |  |  |  |  | 83 | 37 |  |  |  | Springfield | 27:36.79
96 | 28 |  |  |  | Springfield | 6:35.5 |  |  |  |  |  |  |  |  |  |  | 00:06:25 | 00:26:20.400000 |  |  |  |  | 84 | 32 |  |  |  | Springfield | 27:50.02
91 | 69 |  |  |  | Springfield | 6:26.7 |  |  |  |  |  |  |  |  |  |  | 00:06:26.700000 | 00:27:58.220000 |  |  |  |  | 85 | 28 |  |  |  | Springfield | 27:54.60
92 | 36 |  |  |  | Springfield | 6:32.4 |  |  |  |  |  |  |  |  |  |  | 00:06:32.400000 | 00:28:01.260000 |  |  |  |  | 86 | 69 |  |  |  | Springfield | 27:58.22
100 | 20 |  |  |  | Springfield | 6:39.0 |  |  |  |  |  |  |  |  |  |  | 00:06:32.800000 | 00:29:42.520000 |  |  |  |  | 87 | 36 |  |  |  | Springfield | 28:01.26
94 | 76 |  |  |  | Springfield | 6:33.1 |  |  |  |  |  |  |  |  |  |  | 00:06:33.100000 | 00:28:16.460000 |  |  |  |  | 88 | 20 |  |  |  | Springfield | 28:10.70
82 | 17 |  |  |  | Springfield | 6:20.0 |  |  |  |  |  |  |  |  |  |  | 00:06:34.900000 | 00:27:16.920000 |  |  |  |  | 89 | 76 |  |  |  | Springfield | 28:16.46
97 | 71 |  |  |  | Springfield | 6:35.7 |  |  |  |  |  |  |  |  |  |  | 00:06:35.500000 | 00:27:54.600000 |  |  |  |  | 90 | 17 |  |  |  | Springfield | 28:26.92
77 | 15 |  |  |  | Springfield | 6:18.7 |  |  |  |  |  |  |  |  |  |  | 00:06:35.700000 | 00:28:30.150000 |  |  |  |  | 91 | 71 |  |  |  | Springfield | 28:30.15
99 | 30 |  |  |  | Springfield | 6:38.7 |  |  |  |  |  |  |  |  |  |  | 00:06:36.400000 | 00:27:50.020000 |  |  |  |  | 92 | 15 |  |  |  | Springfield | 28:34.32
104 | 27 |  |  |  | Springfield | 6:52.1 |  |  |  |  |  |  |  |  |  |  | 00:06:38.700000 | 00:28:39.190000 |  |  |  |  | 93 | 30 |  |  |  | Springfield | 28:39.19
105 | 22 |  |  |  | Springfield | 6:53.2 |  |  |  |  |  |  |  |  |  |  | 00:06:39 | 00:28:10.700000 |  |  |  |  | 94 | 27 |  |  |  | Springfield | 29:12.12
93 | 38 |  |  |  | Springfield | 6:32.8 |  |  |  |  |  |  |  |  |  |  | 00:06:52.100000 | 00:29:12.120000 |  |  |  |  | 95 | 22 |  |  |  | Springfield | 29:28.52
88 | 114 |  |  |  | Springfield | 6:24.1 |  |  |  |  |  |  |  |  |  |  | 00:06:53.200000 | 00:29:28.520000 |  |  |  |  | 96 | 38 |  |  |  | Springfield | 29:42.52
26 | 108 |  |  |  | Springfield | 6:00.3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 97 | 114 |  |  |  | Springfield | 30:07.45
55 | 112 |  |  |  | Springfield | 6:04.0
69 | 63 |  |  |  | Springfield | 6:14.5
83 | 124 |  |  |  | Springfield | 6:20.8
101 | 50 |  |  |  | Springfield | 6:39.6
102 | 29 |  |  |  | Springfield | 6:46.0
103 | 31 |  |  |  | Springfield | 6:48.1