Spreadsheet: 752786d1634946334-predicting-finish-time-for-running-races-time-prediction
Sheet: Sheet1

Pl | ID | Blank | LName | FName | City | FS | True Finish | Variable | Variable2 | Calculate Estimated Finish | Variable 2 Estimated Finish | Pl | ID | Blank | Lname | Fname | City | Finish |  | Variable Average | Variable2 Average
1 | 133 |  |  |  | Springfield | 5:54.5 |  |  |  |  |  | 1 | 3 |  |  |  | Springfield | 23:52.84
2 | 135 |  |  |  | Springfield | 5:57.7 |  |  |  |  |  | 2 | 133 |  |  |  | Springfield | 23:59.79
3 | 98 |  |  |  | Springfield | 5:59.3 |  |  |  |  |  | 3 | 8 |  |  |  | Springfield | 24:11.89
4 | 116 |  |  |  | Springfield | 5:59.3 |  |  |  |  |  | 4 | 51 |  |  |  | Springfield | 24:12.50
5 | 132 |  |  |  | Springfield | 5:59.3 |  |  |  |  |  | 5 | 98 |  |  |  | Springfield | 24:13.23
6 | 123 |  |  |  | Springfield | 5:59.3 |  |  |  |  |  | 6 | 4 |  |  |  | Springfield | 24:22.19
7 | 131 |  |  |  | Springfield | 5:59.4 |  |  |  |  |  | 7 | 60 |  |  |  | Springfield | 24:30.56
8 | 125 |  |  |  | Springfield | 5:59.5 |  |  |  |  |  | 8 | 64 |  |  |  | Springfield | 24:31.57
8 | 117 |  |  |  | Springfield | 5:59.5 |  |  |  |  |  | 9 | 116 |  |  |  | Springfield | 24:35.58
10 | 119 |  |  |  | Springfield | 5:59.5 |  |  |  |  |  | 10 | 111 |  |  |  | Springfield | 24:40.03
11 | 3 |  |  |  | Springfield | 5:59.7 |  |  |  |  |  | 11 | 132 |  |  |  | Springfield | 24:40.27
12 | 6 |  |  |  | Springfield | 5:59.7 |  |  |  |  |  | 12 | 129 |  |  |  | Springfield | 24:40.87
13 | 73 |  |  |  | Springfield | 5:59.7 |  |  |  |  |  | 13 | 73 |  |  |  | Springfield | 24:42.33
14 | 109 |  |  |  | Springfield | 5:59.7 |  |  |  |  |  | 14 | 53 |  |  |  | Springfield | 24:43.00
15 | 60 |  |  |  | Springfield | 5:59.8 |  |  |  |  |  | 15 | 104 |  |  |  | Springfield | 24:43.44
16 | 102 |  |  |  | Springfield | 5:59.8 |  |  |  |  |  | 16 | 123 |  |  |  | Springfield | 24:45.88
17 | 64 |  |  |  | Springfield | 5:59.8 |  |  |  |  |  | 17 | 109 |  |  |  | Springfield | 24:46.15
20 | 107 |  |  |  | Springfield | 6:00.0 |  |  |  |  |  | 18 | 110 |  |  |  | Springfield | 24:48.07
21 | 5 |  |  |  | Springfield | 6:00.0 |  |  |  |  |  | 19 | 131 |  |  |  | Springfield | 24:48.17
22 | 54 |  |  |  | Springfield | 6:00.1 |  |  |  |  |  | 20 | 16 |  |  |  | Springfield | 24:52.31
23 | 110 |  |  |  | Springfield | 6:00.1 |  |  |  |  |  | 21 | 65 |  |  |  | Springfield | 24:55.38
24 | 106 |  |  |  | Springfield | 6:00.1 |  |  |  |  |  | 22 | 107 |  |  |  | Springfield | 24:58.26
25 | 51 |  |  |  | Springfield | 6:00.2 |  |  |  |  |  | 23 | 127 |  |  |  | Springfield | 25:01.70
26 | 108 |  |  |  | Springfield | 6:00.3 |  |  |  |  |  | 24 | 134 |  |  |  | Springfield | 25:02.73
27 | 105 |  |  |  | Springfield | 6:00.6 |  |  |  |  |  | 25 | 1 |  |  |  | Springfield | 25:04.05
28 | 129 |  |  |  | Springfield | 6:00.7 |  |  |  |  |  | 26 | 102 |  |  |  | Springfield | 25:05.42
29 | 115 |  |  |  | Springfield | 6:00.8 |  |  |  |  |  | 27 | 14 |  |  |  | Springfield | 25:07.16
30 | 47 |  |  |  | Springfield | 6:00.8 |  |  |  |  |  | 28 | 54 |  |  |  | Springfield | 25:07.46
31 | 121 |  |  |  | Springfield | 6:01.0 |  |  |  |  |  | 29 | 62 |  |  |  | Springfield | 25:07.95
32 | 130 |  |  |  | Springfield | 6:01.0 |  |  |  |  |  | 30 | 2 |  |  |  | Springfield | 25:10.85
33 | 16 |  |  |  | Springfield | 6:01.1 |  |  |  |  |  | 31 | 5 |  |  |  | Springfield | 25:12.73
34 | 8 |  |  |  | Springfield | 6:01.1 |  |  |  |  |  | 32 | 58 |  |  |  | Springfield | 25:14.44
35 | 127 |  |  |  | Springfield | 6:01.1 |  |  |  |  |  | 33 | 19 |  |  |  | Springfield | 25:16.82
36 | 2 |  |  |  | Springfield | 6:01.2 |  |  |  |  |  | 34 | 119 |  |  |  | Springfield | 25:17.42
37 | 14 |  |  |  | Springfield | 6:01.3 |  |  |  |  |  | 35 | 26 |  |  |  | Springfield | 25:17.54
38 | 126 |  |  |  | Springfield | 6:01.4 |  |  |  |  |  | 36 | 117 |  |  |  | Springfield | 25:20.14
39 | 45 |  |  |  | Springfield | 6:01.5 |  |  |  |  |  | 37 | 6 |  |  |  | Springfield | 25:20.26
40 | 134 |  |  |  | Springfield | 6:01.7 |  |  |  |  |  | 38 | 101 |  |  |  | Springfield | 25:21.25
41 | 53 |  |  |  | Springfield | 6:01.9 |  |  |  |  |  | 39 | 66 |  |  |  | Springfield | 25:23.18
42 | 62 |  |  |  | Springfield | 6:02.0 |  |  |  |  |  | 40 | 56 |  |  |  | Springfield | 25:26.70
43 | 111 |  |  |  | Springfield | 6:02.0 |  |  |  |  |  | 41 | 47 |  |  |  | Springfield | 25:28.84
44 | 101 |  |  |  | Springfield | 6:02.0 |  |  |  |  |  | 42 | 45 |  |  |  | Springfield | 25:30.09
45 | 59 |  |  |  | Springfield | 6:02.1 |  |  |  |  |  | 43 | 7 |  |  |  | Springfield | 25:32.85
46 | 4 |  |  |  | Springfield | 6:02.4 |  |  |  |  |  | 44 | 130 |  |  |  | Springfield | 25:34.91
47 | 56 |  |  |  | Springfield | 6:02.4 |  |  |  |  |  | 45 | 135 |  |  |  | Springfield | 25:35.34
48 | 66 |  |  |  | Springfield | 6:02.5 |  |  |  |  |  | 46 | 121 |  |  |  | Springfield | 25:36.72
49 | 103 |  |  |  | Springfield | 6:02.6 |  |  |  |  |  | 47 | 106 |  |  |  | Springfield | 25:36.79
50 | 68 |  |  |  | Springfield | 6:02.8 |  |  |  |  |  | 48 | 125 |  |  |  | Springfield | 25:41.05
51 | 13 |  |  |  | Springfield | 6:03.0 |  |  |  |  |  | 49 | 61 |  |  |  | Springfield | 25:41.54
52 | 18 |  |  |  | Springfield | 6:03.3 |  |  |  |  |  | 50 | 24 |  |  |  | Springfield | 25:43.94
53 | 9 |  |  |  | Springfield | 6:03.5 |  |  |  |  |  | 51 | 9 |  |  |  | Springfield | 25:53.80
54 | 19 |  |  |  | Springfield | 6:03.7 |  |  |  |  |  | 52 | 13 |  |  |  | Springfield | 25:56.30
55 | 112 |  |  |  | Springfield | 6:04.0 |  |  |  |  |  | 53 | 52 |  |  |  | Springfield | 25:58.21
56 | 118 |  |  |  | Springfield | 6:06.6 |  |  |  |  |  | 54 | 115 |  |  |  | Springfield | 26:02.44
57 | 26 |  |  |  | Springfield | 6:06.7 |  |  |  |  |  | 55 | 68 |  |  |  | Springfield | 26:03.51
58 | 48 |  |  |  | Springfield | 6:06.8 |  |  |  |  |  | 56 | 10 |  |  |  | Springfield | 26:08.87
59 | 24 |  |  |  | Springfield | 6:06.9 |  |  |  |  |  | 57 | 55 |  |  |  | Springfield | 26:09.39
60 | 58 |  |  |  | Springfield | 6:07.1 |  |  |  |  |  | 58 | 21 |  |  |  | Springfield | 26:10.11
61 | 1 |  |  |  | Springfield | 6:07.2 |  |  |  |  |  | 59 | 126 |  |  |  | Springfield | 26:12.97
62 | 65 |  |  |  | Springfield | 6:07.7 |  |  |  |  |  | 60 | 59 |  |  |  | Springfield | 26:15.63
63 | 49 |  |  |  | Springfield | 6:10.3 |  |  |  |  |  | 61 | 40 |  |  |  | Springfield | 26:17.28
64 | 74 |  |  |  | Springfield | 6:10.6 |  |  |  |  |  | 62 | 23 |  |  |  | Springfield | 26:20.40
65 | 10 |  |  |  | Springfield | 6:11.7 |  |  |  |  |  | 63 | 78 |  |  |  | Springfield | 26:24.45
66 | 43 |  |  |  | Springfield | 6:12.4 |  |  |  |  |  | 64 | 118 |  |  |  | Springfield | 26:30.86
67 | 78 |  |  |  | Springfield | 6:14.2 |  |  |  |  |  | 65 | 103 |  |  |  | Springfield | 26:34.06
67 | 61 |  |  |  | Springfield | 6:14.2 |  |  |  |  |  | 66 | 49 |  |  |  | Springfield | 26:37.82
69 | 63 |  |  |  | Springfield | 6:14.5 |  |  |  |  |  | 67 | 80 |  |  |  | Springfield | 26:38.00
70 | 72 |  |  |  | Springfield | 6:14.8 |  |  |  |  |  | 68 | 18 |  |  |  | Springfield | 26:39.24
71 | 55 |  |  |  | Springfield | 6:15.0 |  |  |  |  |  | 69 | 67 |  |  |  | Springfield | 26:42.26
72 | 52 |  |  |  | Springfield | 6:15.1 |  |  |  |  |  | 70 | 48 |  |  |  | Springfield | 26:44.76
73 | 7 |  |  |  | Springfield | 6:16.7 |  |  |  |  |  | 71 | 75 |  |  |  | Springfield | 26:51.80
74 | 40 |  |  |  | Springfield | 6:17.1 |  |  |  |  |  | 72 | 41 |  |  |  | Springfield | 26:55.40
75 | 42 |  |  |  | Springfield | 6:18.4 |  |  |  |  |  | 73 | 79 |  |  |  | Springfield | 26:58.02
76 | 41 |  |  |  | Springfield | 6:18.7 |  |  |  |  |  | 74 | 81 |  |  |  | Springfield | 27:03.82
77 | 15 |  |  |  | Springfield | 6:18.7 |  |  |  |  |  | 75 | 42 |  |  |  | Springfield | 27:03.99
78 | 75 |  |  |  | Springfield | 6:18.9 |  |  |  |  |  | 76 | 74 |  |  |  | Springfield | 27:05.68
79 | 81 |  |  |  | Springfield | 6:19.2 |  |  |  |  |  | 77 | 100 |  |  |  | Springfield | 27:06.38
80 | 79 |  |  |  | Springfield | 6:19.3 |  |  |  |  |  | 78 | 105 |  |  |  | Springfield | 27:07.49
81 | 12 |  |  |  | Springfield | 6:19.6 |  |  |  |  |  | 79 | 12 |  |  |  | Springfield | 27:12.55
82 | 17 |  |  |  | Springfield | 6:20.0 |  |  |  |  |  | 80 | 72 |  |  |  | Springfield | 27:15.69
83 | 124 |  |  |  | Springfield | 6:20.8 |  |  |  |  |  | 81 | 25 |  |  |  | Springfield | 27:16.92
84 | 67 |  |  |  | Springfield | 6:22.0 |  |  |  |  |  | 82 | 43 |  |  |  | Springfield | 27:28.31
85 | 80 |  |  |  | Springfield | 6:22.2 |  |  |  |  |  | 83 | 37 |  |  |  | Springfield | 27:36.79
86 | 100 |  |  |  | Springfield | 6:22.3 |  |  |  |  |  | 84 | 32 |  |  |  | Springfield | 27:50.02
87 | 37 |  |  |  | Springfield | 6:23.0 |  |  |  |  |  | 85 | 28 |  |  |  | Springfield | 27:54.60
88 | 114 |  |  |  | Springfield | 6:24.1 |  |  |  |  |  | 86 | 69 |  |  |  | Springfield | 27:58.22
89 | 21 |  |  |  | Springfield | 6:25.0 |  |  |  |  |  | 87 | 36 |  |  |  | Springfield | 28:01.26
90 | 23 |  |  |  | Springfield | 6:25.0 |  |  |  |  |  | 88 | 20 |  |  |  | Springfield | 28:10.70
91 | 69 |  |  |  | Springfield | 6:26.7 |  |  |  |  |  | 89 | 76 |  |  |  | Springfield | 28:16.46
92 | 36 |  |  |  | Springfield | 6:32.4 |  |  |  |  |  | 90 | 17 |  |  |  | Springfield | 28:26.92
93 | 38 |  |  |  | Springfield | 6:32.8 |  |  |  |  |  | 91 | 71 |  |  |  | Springfield | 28:30.15
94 | 76 |  |  |  | Springfield | 6:33.1 |  |  |  |  |  | 92 | 15 |  |  |  | Springfield | 28:34.32
95 | 25 |  |  |  | Springfield | 6:34.9 |  |  |  |  |  | 93 | 30 |  |  |  | Springfield | 28:39.19
96 | 28 |  |  |  | Springfield | 6:35.5 |  |  |  |  |  | 94 | 27 |  |  |  | Springfield | 29:12.12
97 | 71 |  |  |  | Springfield | 6:35.7 |  |  |  |  |  | 95 | 22 |  |  |  | Springfield | 29:28.52
98 | 32 |  |  |  | Springfield | 6:36.4 |  |  |  |  |  | 96 | 38 |  |  |  | Springfield | 29:42.52
99 | 30 |  |  |  | Springfield | 6:38.7 |  |  |  |  |  | 97 | 114 |  |  |  | Springfield | 30:07.45
100 | 20 |  |  |  | Springfield | 6:39.0
101 | 50 |  |  |  | Springfield | 6:39.6
102 | 29 |  |  |  | Springfield | 6:46.0
103 | 31 |  |  |  | Springfield | 6:48.1
104 | 27 |  |  |  | Springfield | 6:52.1
105 | 22 |  |  |  | Springfield | 6:53.2