Spreadsheet: 783958d1655311827-cross-country-tie-breaking-formula-xc-tie-breaking-formulas
Sheet: Sheet2

Pl |  | Team | Pts | [NAME] I'd Like | College Tie Break Rank | HS Tie Break Rank | Tie Brieak College | Tie Break HS | 1 | 2 | 3 | 4 | 5 | [6] | [7] |  |  |  |  |  |  | Tie Points
 |  | Team 1 |  |  |  |  |  |  | 1 | 9 | 11 | 12 | 21
 |  |  |  |  |  |  |  |  | [NAME] 1 | [NAME] | [NAME] 3 | [NAME] 4 | [NAME] 5 | [NAME] 6
 |  |  |  |  |  |  |  |  | 00:24:16.300000 | 00:24:32.700000 | 00:24:35.600000 | 00:24:37.600000 | 00:24:37.700000 | 00:26:13.500000
 |  | Team 2 |  |  |  |  |  |  | 2 | 8 | 9 | 13 | 22 | 26 | 28
 |  |  |  |  |  |  |  |  | [NAME] 1 | [NAME] | [NAME] 3 | [NAME] 4 | [NAME] 5 | [NAME] 6 | [NAME] 7
 |  |  |  |  |  |  |  |  | 00:23:43.500000 | 00:23:55.400000 | 00:24:15.500000 | 00:24:58.400000 | 00:24:58.900000 | 00:25:11.300000 | 00:25:15.400000
 |  | Team 3 |  |  |  |  |  |  | 5 | 6 | 12 | 15 | 17 | 26 | 31
 |  |  |  |  |  |  |  |  | [NAME] 1 | [NAME] | [NAME] 3 | [NAME] 4 | [NAME] 5 | [NAME] 6 | [NAME] 7
 |  |  |  |  |  |  |  |  | 00:24:12.900000 | 00:24:14.300000 | 00:24:40.500000 | 00:24:46.400000 | 00:25:01.700000 | 00:25:06.500000 | 00:25:26.600000
 |  | Team 4 |  |  |  |  |  |  | 3 | 9 | 15 | 19 | 28 | 35 | 37
 |  |  |  |  |  |  |  |  | [NAME] 1 | [NAME] | [NAME] 3 | [NAME] 4 | [NAME] 5 | [NAME] 6 | [NAME] 7
 |  |  |  |  |  |  |  |  | 00:24:06.200000 | 00:24:28.700000 | 00:24:42.100000 | 00:24:49.600000 | 00:25:02.500000 | 00:25:50.300000 | 00:26:09
 |  | Team 5 |  |  |  |  |  |  | 4 | 16 | 17 | 18 | 19 | 29 | 33
 |  |  |  |  |  |  |  |  | [NAME] 1 | [NAME] | [NAME] 3 | [NAME] 4 | [NAME] 5 | [NAME] 6 | [NAME] 7
 |  |  |  |  |  |  |  |  | 00:24:09.500000 | 00:24:44.400000 | 00:24:47 | 00:24:50.600000 | 00:24:55.800000 | 00:25:16.100000 | 00:25:30.900000
 |  | Team 6 |  |  |  |  |  |  | 32 | 36 | 43 | 44 | 48 | 52 | 53
 |  |  |  |  |  |  |  |  | [NAME] 1 | [NAME] | [NAME] 3 | [NAME] 4 | [NAME] 5 | [NAME] 6 | [NAME] 7
 |  |  |  |  |  |  |  |  | 00:25:27.900000 | 00:26:16 | 00:26:37.900000 | 00:26:41.100000 | 00:26:57.800000 | 00:27:05.900000 | 00:27:05.900000
 |  | Team 7 |  |  |  |  |  |  | 30 | 35 | 45 | 57 | 63 | 66 | 67
 |  |  |  |  |  |  |  |  | [NAME] 1 | [NAME] | [NAME] 3 | [NAME] 4 | [NAME] 5 | [NAME] 6 | [NAME] 7
 |  |  |  |  |  |  |  |  | 00:25:24.100000 | 00:26:36 | 00:26:45.400000 | 00:27:14.500000 | 00:27:33.900000 | 00:27:50.500000 | 00:27:57.200000
 |  | Team 8 |  |  |  |  |  |  | 34 | 49 | 50 | 54 | 55 | 65 | 71
 |  |  |  |  |  |  |  |  | [NAME] 1 | [NAME] | [NAME] 3 | [NAME] 4 | [NAME] 5 | [NAME] 6 | [NAME] 7
 |  |  |  |  |  |  |  |  | 00:25:43 | 00:26:46.800000 | 00:26:58.400000 | 00:27:06.200000 | 00:27:08.500000 | 00:27:38.700000 | 00:28:39.800000
 |  | Team 9 |  |  |  |  |  |  | 36 | 41 | 49 | 56 | 60 | 64
 |  |  |  |  |  |  |  |  | [NAME] 1 | [NAME] | [NAME] 3 | [NAME] 4 | [NAME] 5 | [NAME] 6
 |  |  |  |  |  |  |  |  | 00:25:53.300000 | 00:26:25.400000 | 00:26:58 | 00:27:11.600000 | 00:27:26 | 00:27:37.600000
 |  | Team 10 |  |  |  |  |  |  | 47 | 51 | 58 | 59 | 61 | 62 | 68
 |  |  |  |  |  |  |  |  | [NAME] 1 | [NAME] | [NAME] 3 | [NAME] 4 | [NAME] 5 | [NAME] 6 | [NAME] 7
 |  |  |  |  |  |  |  |  | 00:26:47.500000 | 00:27:04.800000 | 00:27:17.600000 | 00:27:19.600000 | 00:27:26.900000 | 00:27:32.700000 | 00:28:05.500000
 |  | Team 11 |  |  |  |  |  |  | 41 | 68 | 70 | 72 | 73 | 74 | 75
 |  |  |  |  |  |  |  |  | [NAME] 1 | [NAME] | [NAME] 3 | [NAME] 4 | [NAME] 5 | [NAME] 6 | [NAME] 7
 |  |  |  |  |  |  |  |  | 00:26:30.700000 | 00:28:16.100000 | 00:28:35.200000 | 00:29:03.500000 | 00:29:48.400000 | 00:30:16.100000 | 00:30:49.800000