1 | Stage 1 Score | Time | Stage 2 Score | Time | Stage 3 Score | Time | Stage 4-8 Score | Time | Finish Score | Time | Total Score | Total time | Points per Hour | |||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2 | 1 | 29 | MV | RUSH | 810 | 4:07:00 | 1370 | 6:52:00 | 1890 | 11:09:00 | 4160 | 23:15:00 | 4160 | 23:15:00 | 179 | |||
3 | 2 | 20 | MO | Tiger Adventure Yellow Mens | 810 | 4:21:00 | 1370 | 7:19:00 | 1890 | 11:00:00 | 3750 | 21:32:00 | 4140 | 23:42:00 | 175 | |||
4 | 3 | 33 | MV | Tiger Adventure Vintage | 810 | 3:48:00 | 1370 | 6:40:00 | 1890 | 11:39:00 | 3710 | 22:59:00 | 4010 | 23:57:00 | 167 | |||
5 | 4 | 9 | MO | Mass Nutrition Noosa | 810 | 3:49:00 | 1370 | 6:23:00 | 1890 | 11:17:00 | 3810 | 22:44:00 | 3940 | 23:40:00 | 166 | |||
6 | 5 | 49 | XO | Tiger Adventure Yellow Mixed | 810 | 4:26:00 | 1370 | 7:25:00 | 1770 | 11:41:00 | 3650 | 22:51:00 | 3820 | 23:49:00 | 160 | |||
7 | 6 | 41 | XO | Calories | 670 | 3:23:00 | 1230 | 6:13:00 | 1680 | 9:50:00 | 3410 | 22:01:00 | 3780 | 23:53:00 | 158 | |||
8 | 7 | 44 | XO | Husband & Wife | 810 | 5:03:00 | 1370 | 8:05:00 | 1570 | 11:14:00 | 3710 | 23:15:00 | 3710 | 23:15:00 | 160 | |||
9 | 8 | 48 | XO | Teamexplore | 810 | 4:39:00 | 1370 | 8:09:00 | 1820 | 12:30:00 | 2820 | 20:51:00 | 3690 | 23:44:00 | 155 | |||
10 | 9 | 24 | MV | Borum Boys | 670 | 4:41:00 | 1130 | 7:30:00 | 1610 | 12:20:00 | 3170 | 20:50:00 | 3600 | 23:36:00 | 153 | |||
11 | 10 | 58 | XV | Tri Adventure Petite | 670 | 3:50:00 | 1230 | 6:40:00 | 1350 | 9:06:00 | 3400 | 22:31:00 | 3570 | 23:05:00 | 155 | |||
12 | 11 | 23 | MV | Bike On | 670 | 3:38:00 | 1050 | 5:42:00 | 1480 | 10:18:00 | 2970 | 20:06:00 | 3560 | 23:51:00 | 149 | |||
13 | 12 | 7 | MO | Jones and Jones | 620 | 3:45:00 | 1180 | 7:01:00 | 1580 | 10:50:00 | 2990 | 20:33:00 | 3550 | 23:50:00 | 149 | |||
14 | 13 | 28 | MV | JR Racing | 760 | 4:35:00 | 1260 | 8:11:00 | 1440 | 10:05:00 | 3220 | 21:35:00 | 3540 | 23:49:00 | 149 | |||
15 | 14 | 50 | XV | Bicycles Without Bruce | 670 | 4:27:00 | 1170 | 7:36:00 | 1570 | 10:59:00 | 3180 | 21:25:00 | 3500 | 23:55:00 | 146 | |||
16 | 15 | 4 | MO | He Aint Heavy | 670 | 4:06:00 | 1230 | 6:49:00 | 1750 | 11:40:00 | 3160 | 21:34:00 | 3480 | 23:55:00 | 146 | |||
17 | 16 | 25 | MV | Clubk | 670 | 4:08:00 | 1230 | 6:55:00 | 1470 | 9:08:00 | 3140 | 22:06:00 | 3340 | 23:46:00 | 141 | |||
18 | 17 | 51 | XV | Dated Loaf and Pikelet | 600 | 3:59:00 | 1160 | 7:46:00 | 1460 | 11:03:00 | 2970 | 20:09:00 | 3330 | 24:02:00 | 139 | |||
19 | 18 | 30 | MV | Running on Empty | 620 | 4:10:00 | 1000 | 6:17:00 | 1450 | 11:14:00 | 3220 | 23:18:00 | 3220 | 23:18:00 | 138 | |||
20 | 19 | 10 | MO | No Ones | 620 | 4:04:00 | 1180 | 7:37:00 | 1700 | 12:36:00 | 2630 | 19:46:00 | 3190 | 23:41:00 | 135 | |||
21 | 20 | 57 | XV | The Visitors | 670 | 4:28:00 | 1030 | 6:56:00 | 1340 | 10:27:00 | 2910 | 20:17:00 | 3170 | 23:45:00 | 133 | |||
22 | 21 | 8 | MO | Living on a Spur | 710 | 6:13:00 | 930 | 7:41:00 | 1110 | 9:55:00 | 2550 | 19:18:00 | 3140 | 23:43:00 | 132 | |||
23 | 22 | 12 | MO | Outlandish | 710 | 4:41:00 | 1270 | 7:50:00 | 1570 | 12:15:00 | 2880 | 22:04:00 | 3090 | 23:32:00 | 131 | |||
24 | 23 | 15 | MO | The Hopeless Jokes | 670 | 4:18:00 | 1170 | 7:10:00 | 1350 | 9:11:00 | 2670 | 20:04:00 | 3060 | 22:32:00 | 136 | |||
25 | 24 | 40 | XO | AV Club | 620 | 4:20:00 | 1000 | 6:56:00 | 1450 | 11:39:00 | 2960 | 23:15:00 | 2960 | 23:15:00 | 127 | |||
26 | 25 | 27 | MV | Isodopes | 620 | 4:40:00 | 940 | 6:42:00 | 1180 | 8:44:00 | 2750 | 22:09:00 | 2950 | 23:21:00 | 126 | |||
27 | 26 | 35 | WO | Tri Adventure Girls | 620 | 4:55:00 | 940 | 6:45:00 | 1120 | 9:08:00 | 2360 | 19:31:00 | 2910 | 23:51:00 | 122 | |||
28 | 27 | 37 | WV | Tri Adventure Vintage | 550 | 3:55:00 | 1110 | 6:36:00 | 1230 | 9:05:00 | 2430 | 20:14:00 | 2820 | 23:42:00 | 119 | |||
29 | 28 | 47 | XO | Soldier On | 710 | 4:57:00 | 1210 | 8:29:00 | 1610 | 12:32:00 | 2520 | 22:01:00 | 2810 | 23:54:00 | 118 | |||
30 | 29 | 1 | MO | Australia's Next Top Models | 620 | 4:34:00 | 990 | 6:53:00 | 1210 | 10:53:00 | 2380 | 20:04:00 | 2680 | 23:56:00 | 112 | |||
31 | 30 | 42 | XO | Cameltoes | 530 | 5:08:00 | 910 | 7:48:00 | 1220 | 12:04:00 | 2550 | 22:04:00 | 2620 | 22:34:00 | 116 | |||
32 | 31 | 34 | MV | Tyred and Cranky | 620 | 4:24:00 | 940 | 6:20:00 | 1120 | 8:34:00 | 1960 | 18:58:00 | 2580 | 23:32:00 | 110 | |||
33 | 32 | 18 | MO | The Lost Boys2 | 670 | 5:02:00 | 1230 | 9:06:00 | 1600 | 14:18:00 | 2510 | 22:39:00 | 2450 | 22:39:00 | 108 | |||
34 | 33 | 52 | XV | For Better or Worse | 600 | 4:53:00 | 980 | 7:30:00 | 1160 | 9:32:00 | 1960 | 17:35:00 | 2410 | 22:19:00 | 108 | |||
35 | 34 | 14 | MO | TerraTrac | 620 | 4:31:00 | 990 | 6:53:00 | 1060 | 10:57:00 | 2000 | 19:09:00 | 2390 | 22:56:00 | 104 | |||
36 | 35 | 16 | MO | The Goats A Team | 620 | 4:25:00 | 1050 | 7:22:00 | 1500 | 12:52:00 | 2130 | 20:55:00 | 2330 | 23:09:00 | 101 | |||
37 | 36 | 17 | MO | The Goats B Team | 620 | 4:25:00 | 1050 | 7:22:00 | 1500 | 12:52:00 | 2130 | 20:56:00 | 2330 | 23:09:00 | 101 | |||
38 | 37 | 3 | MO | Deep Fried Trail Mix | 620 | 4:43:00 | 990 | 7:17:00 | 1290 | 11:35:00 | 1890 | 19:34:00 | 2280 | 22:50:00 | 100 | |||
39 | 38 | 2 | MO | BroCann | 620 | 3:45:00 | 1180 | 7:01:00 | 1580 | 10:50:00 | 2280 | 18:56:00 | 2230 | 23:09:00 | 96 | |||
40 | 39 | 56 | XV | Team of Seaside | 670 | 4:37:00 | 1140 | 8:54:00 | 1450 | 14:31:00 | 2230 | 23:50:00 | 2230 | 23:50:00 | 94 | |||
41 | 40 | 45 | XO | MOJO AR Escapees | 490 | 4:24:00 | 810 | 6:03:00 | 840 | 7:09:00 | 1770 | 15:33:00 | 2070 | 21:10:00 | 98 | |||
42 | 41 | 59 | XSV | Megvan | 550 | 4:55:00 | 930 | 7:29:00 | 1050 | 10:19:00 | 1430 | 17:24:00 | 2020 | 23:36:00 | 86 | |||
43 | 42 | 22 | MON | Newlands | 330 | 3:39:00 | 650 | 6:00:00 | 850 | 9:53:00 | 1500 | 20:00:00 | 1810 | 23:31:00 | 77 | |||
44 | 43 | 31 | MV | Salmon-Yak Attack | 370 | 3:20:00 | 630 | 5:28:00 | 810 | 7:12:00 | 1170 | 13:30:00 | 1760 | 23:56:00 | 74 | |||
45 | 44 | 13 | MO | Team FOMO | 490 | 6:00:00 | 490 | 6:00:00 | 490 | 6:00:00 | 1660 | 19:54:00 | 1730 | 21:08:00 | 82 | |||
46 | 45 | 46 | XO | Monkeys On The Loose | 490 | 5:33:00 | 810 | 8:04:00 | 930 | 11:11:00 | 1110 | 15:00:00 | 1700 | 22:16:00 | 76 | |||
47 | 46 | 26 | MV | Grilled Dropbears on Toast | 370 | 3:20:00 | 630 | 5:28:00 | 810 | 7:26:00 | 1700 | 23:15:00 | 1700 | 23:15:00 | 73 | |||
48 | 47 | 19 | MO | Tiger Adventure Black | 670 | 3:34:00 | 1230 | 6:26:00 | 1440 | 10:22:00 | 1570 | 11:15:00 | 1640 | 21:34:00 | 76 | |||
49 | 48 | 60 | XV | Fleabags | 620 | 6:07:00 | 840 | 8:51:00 | 870 | 9:59:00 | 1150 | 15:45:00 | 1610 | 23:02:00 | 70 | |||
50 | 49 | 32 | MV | The Lost Boys1 | 490 | 4:43:00 | 710 | 6:35:00 | 740 | 8:57:00 | 1380 | 18:53:00 | 1580 | 22:15:00 | 71 | |||
51 | 50 | 53 | XV | MOJO AR Marauders | 280 | 4:55:00 | 540 | 7:38:00 | 540 | 8:44:00 | 1250 | 18:18:00 | 1550 | 22:09:00 | 70 | |||
52 | 51 | 38 | XO | Adventure Angels | 620 | 4:05:00 | 620 | 4:05:00 | 850 | 7:51:00 | 1400 | 14:00:00 | 1470 | 21:09:00 | 70 | |||
53 | 52 | 21 | MON | Excess Baggage | 560 | 4:29:00 | 880 | 6:43:00 | 950 | 10:57:00 | 1290 | 15:14:00 | 1290 | 16:59:00 | 76 | |||
54 | 53 | 54 | XV | Puff n Puffin | 560 | 5:01:00 | 1060 | 8:22:00 | 1060 | 8:22:00 | 1140 | 12:15:00 | 1140 | 23:06:00 | 49 | |||
55 | 54 | 43 | XO | Death or Glory | 490 | 7:12:00 | 490 | 7:12:00 | 490 | 7:12:00 | 880 | 22:17:00 | 880 | 22:17:00 | 39 | |||
56 | 5 | Unranked | Heavily Loaded Bags (now with 21) | 560 | 4:29:00 | 880 | 6:43:00 | 950 | 10:57:00 | 1290 | 15:14:00 | 1290 | 22:57:00 | 56 | ||||
57 | 36 | Unranked | Giddy Up Girls | 490 | 3:55:00 | 700 | 5:12:00 | 820 | 9:06:00 | 820 | 9:06:00 | 820 | 21:06:00 | 39 | ||||
58 | 11 | MO | Outdoor Academy with ARea51 | 490 | 4:42:00 | 670 | 6:21:00 | DNF | 106 | |||||||||
59 | 6 | MO | Hunters | 560 | 6:45:00 | DNF | 83 | |||||||||||
60 | 39 | XO | At First They Stood Quietly | DNS | 0 | |||||||||||||
61 | 55 | XV | Team Lantana (navlight used by 33) | DNS | 0 | |||||||||||||
62 | ||||||||||||||||||
63 | ||||||||||||||||||
64 | ||||||||||||||||||
65 | ||||||||||||||||||
66 | ||||||||||||||||||
67 | ||||||||||||||||||
68 | ||||||||||||||||||
69 | ||||||||||||||||||
70 | ||||||||||||||||||
71 | ||||||||||||||||||
72 | ||||||||||||||||||
73 | ||||||||||||||||||
74 | ||||||||||||||||||
75 | ||||||||||||||||||
76 | ||||||||||||||||||
77 | ||||||||||||||||||
78 | ||||||||||||||||||
79 | ||||||||||||||||||
80 | ||||||||||||||||||
81 | ||||||||||||||||||
82 | ||||||||||||||||||
83 | ||||||||||||||||||
84 | ||||||||||||||||||
85 | ||||||||||||||||||
86 | ||||||||||||||||||
87 | ||||||||||||||||||
88 | ||||||||||||||||||
89 | ||||||||||||||||||
90 | ||||||||||||||||||
91 | ||||||||||||||||||
92 | ||||||||||||||||||
93 | ||||||||||||||||||
94 | ||||||||||||||||||
95 | ||||||||||||||||||
96 | ||||||||||||||||||
97 | ||||||||||||||||||
98 | ||||||||||||||||||
99 |
1 | When filling out the admin page do the following | |||||||||
---|---|---|---|---|---|---|---|---|---|---|
2 | ||||||||||
3 | 1) Don't leave any empty rows down the CP column. I drag them in down into code and use them, but I ignore after the blank row. Put zero's for the stage for CP's that are HH, test or transition punches, briefing punches anything that doesn't have a stage. They will be used to break up stages (If no transition punch occurs in either team mates, then I will use the last CP of that stage as the time to complete the stage). | |||||||||
4 | 2) Due to keeping the code clean and simple, I have used the fact that Navlight uses the following file name format TeamNumber____TagID. Please don't change the format of the files from that. I will get the team numbers from the file names prior to the underscores ("____") and update the google spreadsheet for the row that has that team number. | |||||||||
5 | 3) Enter the team numbers down without spaces and in sorted team number order. This is only used by the VLookup on the Results tab, but as I get the Results using team number, this has to be correct to be dynamically updated. Though no C# code uses that data. Team member names are optional, you could add another VLookup to put them on the right of the path if you want. | |||||||||
6 | 4) Borders, fonts, highlighting is ignored. Feel free to enhance the imagery of your Results page to your preference. | |||||||||
7 | 6) To repeat - Briefing, text, finish any other punches which are not a CP need to have a stage of ZERO. ie 0 | |||||||||
8 | 7) Only 4 stages have been coded. It can't be changed without a code change and they have to be numeric 1,2,3,4. Admin punches get 0. If you only have one stage like 90% of rogaines, then just put in 0 or 1. | |||||||||
9 | 8) The start race time is currently only used for calculating the points per hour. If the points per hour look weird, it is likely someone didn't select the date and time correctly before processing the files. Just delete all paths, select the race start date and time correctly and reprocess all files to correct it. | |||||||||
10 | 9) I should explain how to reprocess files. This code doesn't have to only be used at the end of a race, but can be used as many times during the race. This is because I look at the path of the team and if they have added more checkpoints, I update their row only. If you need to reprocess, just delete their path. You could with a dedicated team in a large event, have laptops with mobile coverage at water points or transition areas updating constantly during the race to give a semi "Live" feel. Whose strategy was giving the best points per minute during the race. | |||||||||
11 | 10) I don't insert teams into the spreadsheet. It will only look them up down the left hand column. So, once you start your new spreadsheet, remember to add all the race team numbers down the left of the 'Results' tab prior to processing your first file. | |||||||||
12 | 11) Unfortunately when dealing with the google API list feed (which I do to get the data in), it wipes out formula's, in order to make your job easier, after posting all the data into the spreadsheet, I put all the formula's back in as well. This means they are set in code and can't be changed, so don't add any columns before the 'Path' column. |
1 | CP Number | CP Stage (HH or check punches=0) | Setup Team Number | Race Grouping | Setup Team Name | Setup Team Category | Team Members | |
---|---|---|---|---|---|---|---|---|
2 | 1 | 1 | 1 | 24 | Australia's Next Top Models | MO | Rob Shaw, Pete Shaw | |
3 | 2 | 1 | 2 | 24 | BroCann | MO | Andrew Cann, Lukas Cann | |
4 | 3 | 1 | 3 | 24 | Deep Fried Trail Mix | MO | Matthew Kerr, Allan Mains | |
5 | 4 | 1 | 4 | 24 | He Aint Heavy | MO | Glenn Seaby, Jason Seaby | |
6 | 5 | 1 | 5 | 24 | Heavily Loaded Bags | MO | Geoff Davis, Rawson Armitage | |
7 | 6 | 1 | 6 | 24 | Hunters | MO | Nic Droste, Billy Tindall | |
8 | 7 | 1 | 7 | 24 | Jones and Jones | MO | Stephen Wallis, Michael Cann | |
9 | 8 | 1 | 8 | 24 | Living on a Spur | MO | Thomas McPhail, Jon Gooding | |
10 | 9 | 1 | 9 | 24 | Mass Nutrition Noosa | MO | Glenn Kirby, Alex Austin | |
11 | 10 | 1 | 10 | 24 | No Ones | MO | Adam Power, Merrick Ekins | |
12 | 11 | 1 | 11 | 24 | Outdoor Academy with ARea51 | MO | Wayne Benton, Michael McMahon | |
13 | 12 | 1 | 12 | 24 | Outlandish | MO | Alan Ferris, Jeremy Tibbits | |
14 | 13 | 1 | 13 | 24 | Team FOMO | MO | Jamie Whitworth, David Carruthers | |
15 | 14 | 2 | 14 | 24 | TerraTrac | MO | Lyle Jacobson, Gary Beutel | |
16 | 15 | 2 | 15 | 24 | The Hopeless Jokes | MO | Greg Lewis, Paul Lutz | |
17 | 16 | 2 | 16 | 24 | The Goats A Team | MO | Paul Maxwell, James Maxwell | |
18 | 17 | 2 | 17 | 24 | The Goats B Team | MO | Nathan Godfrey, John Ruhle | |
19 | 18 | 2 | 18 | 24 | The Lost Boys2 | MO | Lucas Mansbridge, Andrew Manbridge | |
20 | 19 | 2 | 19 | 24 | Tiger Adventure Black | MO | Shaun Jackson, Craig Keeling | |
21 | 20 | 2 | 20 | 24 | Tiger Adventure Yellow Mens | MO | Paul Melloy, Shane Crook | |
22 | 21 | 2 | 21 | 24 | Excess Baggage | MON | Jason Cameron, Barry McCauliffe | |
23 | 22 | 2 | 22 | 24 | Newlands | MON | Gavin Hodges, Brendan Ellis | |
24 | 23 | 2 | 23 | 24 | Bike On | MV | Justin Wyatt, Howard McCann | |
25 | 24 | 2 | 24 | 24 | Borum Boys | MV | Michael Clauson, Gary Palmer | |
26 | 25 | 2 | 25 | 24 | Clubk | MV | John Kenafake, Bernard Sauvage | |
27 | 26 | 2 | 26 | 24 | Grilled Dropbears on Toast | MV | Brad Teys, Adam Daniec | |
28 | 27 | 2 | 27 | 24 | Isodopes | MV | Andrew Earle, Andrew Paszkowski | |
29 | 28 | 2 | 28 | 24 | JR Racing | MV | Ross McKinnon, Jock Mitchell | |
30 | 29 | 2 | 29 | 24 | RUSH | MV | Clive Bishop, Brad Harrison | |
31 | 30 | 2 | 30 | 24 | Running on Empty | MV | Russell Stringer, Shaun Lauder | |
32 | 31 | 3 | 31 | 24 | Salmon-Yak Attack | MV | Peter Hickey, Sean Lever | |
33 | 32 | 3 | 32 | 24 | The Lost Boys1 | MV | Vik Stork, Anthony Mayer | |
34 | 33 | 3 | 33 | 24 | Tiger Adventure Vintage | MV | Trevor Mullens, Brett Stevens | |
35 | 34 | 3 | 34 | 24 | Tyred and Cranky | MV | Peter Dean, Bob Houghton | |
36 | 35 | 3 | 35 | 24 | Tri Adventure Girls | WO | Kelsey Harvey, Nicola Jelinek | |
37 | 36 | 3 | 36 | 24 | Giddy Up Girls | WV | Mandy Caldwell, Jen Ferguson | |
38 | 37 | 3 | 37 | 24 | Tri Adventure Vintage | WV | Jan Leverton, Gina Dunsdon | |
39 | 38 | 3 | 38 | 24 | Adventure Angels | XO | Seb Mitaros, Michael Rowley | |
40 | 39 | 3 | 39 | 24 | At First They Stood Quietly | XO | Mark Devery, Joanne Eadie | |
41 | 40 | 3 | 40 | 24 | AV Club | XO | Vetti Fawcett, Alex Morgan | |
42 | 41 | 3 | 41 | 24 | Calories | XO | Leo Theoharis, Bec Wilson | |
43 | 42 | 3 | 42 | 24 | Cameltoes | XO | Polly Weston, Bryce Crage | |
44 | 43 | 3 | 43 | 24 | Death or Glory | XO | Frances Theoharis, Michael O'Brien | |
45 | 44 | 3 | 44 | 24 | Husband & Wife | XO | Chris Delaney, Michelle Delaney | |
46 | 45 | 3 | 45 | 24 | MOJO AR Escapees | XO | Suwati Lowth, Guy O'Neill | |
47 | 46 | 3 | 46 | 24 | Monkeys On The Loose | XO | Yvonne Conyers, Nathan Walker | |
48 | 47 | 3 | 47 | 24 | Soldier On | XO | Timothy Foley, Olga Poberezovska | |
49 | 48 | 3 | 48 | 24 | Teamexplore | XO | Paul Elby, Angela Harris | |
50 | 49 | 3 | 49 | 24 | Tiger Adventure Yellow Mixed | XO | Andrea Peebles, David Talbot | |
51 | 50 | 3 | 50 | 24 | Bicycles Without Bruce | XV | Richard Robinson, Tamsin Barnes | |
52 | 51 | 3 | 51 | 24 | Dated Loaf and Pikelet | XV | Rob Garden, Marquita Gelderman | |
53 | 52 | 3 | 52 | 24 | For Better or Worse | XV | Michele Krome, Greg Krome | |
54 | 53 | 3 | 53 | 24 | MOJO AR Marauders | XV | Jaime McGuire, Joanne Thomae | |
55 | 54 | 3 | 54 | 24 | Puff n Puffin | XV | Kerrie Gagel, Alex Gagel | |
56 | 55 | 3 | 55 | 24 | Team Lantana | XV | Michael Schafer, Janelle Schafer | |
57 | 56 | 3 | 56 | 24 | Team of Seaside | XV | Nina Blacklock, Ramon Pollach | |
58 | 57 | 4 | 57 | 24 | The Visitors | XV | Catch Heppelthwaite, Nick Collins | |
59 | 58 | 4 | 58 | 24 | Tri Adventure Petite | XV | Kim Beckinsale, Matthew Fulton | |
60 | 59 | 4 | 59 | 24 | Megvan | XSV | Sue Clarke, Walter Kellerman | |
61 | 60 | 4 | 60 | 24 | Fleabags | XV | Maree Price, Douglas McDonald | |
62 | 61 | 4 | ||||||
63 | 62 | 4 | ||||||
64 | 63 | 4 | ||||||
65 | 64 | 4 | ||||||
66 | 65 | 4 | ||||||
67 | 66 | 4 | ||||||
68 | ||||||||
69 | ||||||||
70 | ||||||||
71 | ||||||||
72 | ||||||||
73 | ||||||||
74 | ||||||||
75 | ||||||||
76 | ||||||||
77 | ||||||||
78 | ||||||||
79 | ||||||||
80 | ||||||||
81 | ||||||||
82 | ||||||||
83 | ||||||||
84 | ||||||||
85 | ||||||||
86 | ||||||||
87 | ||||||||
88 | ||||||||
89 | ||||||||
90 | ||||||||
91 | ||||||||
92 | ||||||||
93 | ||||||||
94 | ||||||||
95 | ||||||||
96 | ||||||||
97 | ||||||||
98 | ||||||||
99 | ||||||||
100 | ||||||||
101 | ||||||||
102 | ||||||||
103 | ||||||||
104 | ||||||||
105 | ||||||||
106 | ||||||||
107 | ||||||||
108 | ||||||||
109 | ||||||||
110 | ||||||||
111 | ||||||||
112 | ||||||||
113 | ||||||||
114 | ||||||||
115 | ||||||||
116 | ||||||||
117 | ||||||||
118 | ||||||||
119 | ||||||||
120 | ||||||||
121 | ||||||||
122 | ||||||||
123 | ||||||||
124 | ||||||||
125 | ||||||||
126 | ||||||||
127 | ||||||||
128 | ||||||||
129 | ||||||||
130 | ||||||||
131 | ||||||||
132 | ||||||||
133 | ||||||||
134 | ||||||||
135 | ||||||||
136 | ||||||||
137 | ||||||||
138 | ||||||||
139 | ||||||||
140 | ||||||||
141 | ||||||||
142 | ||||||||
143 | ||||||||
144 | ||||||||
145 | ||||||||
146 | ||||||||
147 |
1 | Place | Team | Group | Cat | Team Name | Total Points | Stage 1 Points | Stage 1 Time In | Stage 2 Points | Stage 2 Time In | Stage 3 Points | Stage 3 Time In | Stage 4 Points | Stage 4 Time In | Finish Time | System Points | Additional Points from Admin (manually enter here) | Last Updated | Points per hour | Path and Minutes | ||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2 | 1 | 1 | #N/A | #N/A | #N/A | 0 | ||||||||||||||||
3 | 2 | 2 | #N/A | #N/A | #N/A | 0 | ||||||||||||||||
4 | 3 | 3 | #N/A | #N/A | #N/A | 0 | ||||||||||||||||
5 | 4 | 4 | #N/A | #N/A | #N/A | 0 | ||||||||||||||||
6 | 5 | 5 | #N/A | #N/A | #N/A | 0 | ||||||||||||||||
7 | 6 | 6 | #N/A | #N/A | #N/A | 0 | ||||||||||||||||
8 | 7 | 7 | #N/A | #N/A | #N/A | 0 | ||||||||||||||||
9 | 8 | 8 | #N/A | #N/A | #N/A | 0 | ||||||||||||||||
10 | 9 | 9 | #N/A | #N/A | #N/A | 0 | ||||||||||||||||
11 | 10 | 10 | #N/A | #N/A | #N/A | 0 | ||||||||||||||||
12 | 11 | 11 | #N/A | #N/A | #N/A | 0 | ||||||||||||||||
13 | 12 | 12 | #N/A | #N/A | #N/A | 0 | ||||||||||||||||
14 | 13 | 13 | #N/A | #N/A | #N/A | 0 | ||||||||||||||||
15 | 14 | 14 | #N/A | #N/A | #N/A | 0 | ||||||||||||||||
16 | 15 | 15 | #N/A | #N/A | #N/A | 0 | ||||||||||||||||
17 | 16 | 16 | #N/A | #N/A | #N/A | 0 | ||||||||||||||||
18 | 17 | 17 | #N/A | #N/A | #N/A | 0 | ||||||||||||||||
19 | 18 | 18 | #N/A | #N/A | #N/A | 0 | ||||||||||||||||
20 | 19 | 19 | #N/A | #N/A | #N/A | 0 | ||||||||||||||||
21 | 20 | 20 | #N/A | #N/A | #N/A | 0 | ||||||||||||||||
22 | 21 | 21 | #N/A | #N/A | #N/A | 0 | ||||||||||||||||
23 | 22 | 22 | #N/A | #N/A | #N/A | 0 | ||||||||||||||||
24 | 23 | 23 | #N/A | #N/A | #N/A | 0 | ||||||||||||||||
25 | 24 | 24 | #N/A | #N/A | #N/A | 0 | ||||||||||||||||
26 | 25 | 25 | #N/A | #N/A | #N/A | 0 | ||||||||||||||||
27 | 26 | 26 | #N/A | #N/A | #N/A | 0 | ||||||||||||||||
28 | 27 | 27 | #N/A | #N/A | #N/A | 0 | ||||||||||||||||
29 | 28 | 28 | #N/A | #N/A | #N/A | 0 | ||||||||||||||||
30 | 29 | 29 | #N/A | #N/A | #N/A | 0 | ||||||||||||||||
31 | 30 | 30 | #N/A | #N/A | #N/A | 0 | ||||||||||||||||
32 | 31 | 31 | #N/A | #N/A | #N/A | 0 | ||||||||||||||||
33 | 32 | 32 | #N/A | #N/A | #N/A | 0 | ||||||||||||||||
34 | 33 | 33 | #N/A | #N/A | #N/A | 0 | ||||||||||||||||
35 | 34 | 34 | #N/A | #N/A | #N/A | 0 | ||||||||||||||||
36 | 35 | 35 | #N/A | #N/A | #N/A | 0 | ||||||||||||||||
37 | 36 | 36 | #N/A | #N/A | #N/A | 0 | ||||||||||||||||
38 | 37 | 37 | #N/A | #N/A | #N/A | 0 | ||||||||||||||||
39 | 38 | 38 | #N/A | #N/A | #N/A | 0 | ||||||||||||||||
40 | 39 | 39 | #N/A | #N/A | #N/A | 0 | ||||||||||||||||
41 | 40 | 40 | #N/A | #N/A | #N/A | 0 | ||||||||||||||||
42 | 41 | 41 | #N/A | #N/A | #N/A | 0 | ||||||||||||||||
43 | 42 | 42 | #N/A | #N/A | #N/A | 0 | ||||||||||||||||
44 | 43 | 43 | #N/A | #N/A | #N/A | 0 | ||||||||||||||||
45 | 44 | 44 | #N/A | #N/A | #N/A | 0 | ||||||||||||||||
46 | 45 | 45 | #N/A | #N/A | #N/A | 0 | ||||||||||||||||
47 | 46 | 46 | #N/A | #N/A | #N/A | 0 | ||||||||||||||||
48 | 47 | 47 | #N/A | #N/A | #N/A | 0 | ||||||||||||||||
49 | 48 | 48 | #N/A | #N/A | #N/A | 0 | ||||||||||||||||
50 | 49 | 49 | #N/A | #N/A | #N/A | 0 | ||||||||||||||||
51 | 50 | 50 | #N/A | #N/A | #N/A | 0 | ||||||||||||||||
52 | 51 | 51 | #N/A | #N/A | #N/A | 0 | ||||||||||||||||
53 | 52 | 52 | #N/A | #N/A | #N/A | 0 | ||||||||||||||||
54 | 53 | 53 | #N/A | #N/A | #N/A | 0 | ||||||||||||||||
55 | 54 | 54 | #N/A | #N/A | #N/A | 0 | ||||||||||||||||
56 | 55 | 55 | #N/A | #N/A | #N/A | 0 | ||||||||||||||||
57 | 56 | 56 | #N/A | #N/A | #N/A | 0 | ||||||||||||||||
58 | 57 | 57 | #N/A | #N/A | #N/A | 0 | ||||||||||||||||
59 | 58 | 58 | #N/A | #N/A | #N/A | 0 | ||||||||||||||||
60 | 59 | 59 | #N/A | #N/A | #N/A | 0 | ||||||||||||||||
61 | 60 | 60 | #N/A | #N/A | #N/A | 0 | ||||||||||||||||
62 | 61 | 61 | #N/A | #N/A | #N/A | 0 | ||||||||||||||||
63 | 62 | 62 | #N/A | #N/A | #N/A | 0 | ||||||||||||||||
64 | 63 | 63 | #N/A | #N/A | #N/A | 0 | ||||||||||||||||
65 | 64 | 64 | #N/A | #N/A | #N/A | 0 | ||||||||||||||||
66 | 65 | 65 | #N/A | #N/A | #N/A | 0 | ||||||||||||||||
67 | 66 | 66 | #N/A | #N/A | #N/A | 0 | ||||||||||||||||
68 | 67 | 67 | #N/A | #N/A | #N/A | 0 | ||||||||||||||||
69 | 68 | 68 | #N/A | #N/A | #N/A | 0 | ||||||||||||||||
70 | 69 | 69 | #N/A | #N/A | #N/A | 0 | ||||||||||||||||
71 | 70 | 70 | #N/A | #N/A | #N/A | 0 | ||||||||||||||||
72 | 71 | 71 | #N/A | #N/A | #N/A | 0 | ||||||||||||||||
73 | 72 | 72 | #N/A | #N/A | #N/A | 0 | ||||||||||||||||
74 | 73 | 73 | #N/A | #N/A | #N/A | 0 | ||||||||||||||||
75 | 74 | 74 | #N/A | #N/A | #N/A | 0 | ||||||||||||||||
76 | 75 | 75 | #N/A | #N/A | #N/A | 0 | ||||||||||||||||
77 | 76 | 76 | #N/A | #N/A | #N/A | 0 | ||||||||||||||||
78 | 77 | 77 | #N/A | #N/A | #N/A | 0 | ||||||||||||||||
79 | 78 | 78 | #N/A | #N/A | #N/A | 0 | ||||||||||||||||
80 | 79 | 79 | #N/A | #N/A | #N/A | 0 | ||||||||||||||||
81 | 80 | 80 | #N/A | #N/A | #N/A | 0 | ||||||||||||||||
82 | 81 | 81 | #N/A | #N/A | #N/A | 0 | ||||||||||||||||
83 | 82 | 82 | #N/A | #N/A | #N/A | 0 | ||||||||||||||||
84 | 83 | 83 | #N/A | #N/A | #N/A | 0 | ||||||||||||||||
85 | 84 | 84 | #N/A | #N/A | #N/A | 0 | ||||||||||||||||
86 | 85 | 85 | #N/A | #N/A | #N/A | 0 | ||||||||||||||||
87 | 86 | 86 | #N/A | #N/A | #N/A | 0 | ||||||||||||||||
88 | 87 | 87 | #N/A | #N/A | #N/A | 0 | ||||||||||||||||
89 | 88 | 88 | #N/A | #N/A | #N/A | 0 | ||||||||||||||||
90 | 89 | 89 | #N/A | #N/A | #N/A | 0 | ||||||||||||||||
91 | 90 | 90 | #N/A | #N/A | #N/A | 0 | ||||||||||||||||
92 | 91 | 91 | #N/A | #N/A | #N/A | 0 | ||||||||||||||||
93 | 92 | 92 | #N/A | #N/A | #N/A | 0 | ||||||||||||||||
94 | 93 | 93 | #N/A | #N/A | #N/A | 0 | ||||||||||||||||
95 | 94 | 94 | #N/A | #N/A | #N/A | 0 | ||||||||||||||||
96 | 95 | 95 | #N/A | #N/A | #N/A | 0 | ||||||||||||||||
97 | 96 | 96 | #N/A | #N/A | #N/A | 0 | ||||||||||||||||
98 | 97 | 97 | #N/A | #N/A | #N/A | 0 | ||||||||||||||||
99 | 98 | 98 | #N/A | #N/A | #N/A | 0 | ||||||||||||||||
100 | 99 | 99 | #N/A | #N/A | #N/A | 0 | ||||||||||||||||
101 | 100 | 100 | #N/A | #N/A | #N/A | 0 | ||||||||||||||||
102 | 101 | 101 | #N/A | #N/A | #N/A | 0 | ||||||||||||||||
103 | 102 | 102 | #N/A | #N/A | #N/A | 0 | ||||||||||||||||
104 | 103 | 103 | #N/A | #N/A | #N/A | 0 | ||||||||||||||||
105 | 104 | 104 | #N/A | #N/A | #N/A | 0 | ||||||||||||||||
106 | 105 | 105 | #N/A | #N/A | #N/A | 0 | ||||||||||||||||
107 | 106 | 106 | #N/A | #N/A | #N/A | 0 | ||||||||||||||||
108 | 107 | 107 | #N/A | #N/A | #N/A | 0 | ||||||||||||||||
109 | 108 | 108 | #N/A | #N/A | #N/A | 0 | ||||||||||||||||
110 | 109 | 109 | #N/A | #N/A | #N/A | 0 | ||||||||||||||||
111 | 110 | 110 | #N/A | #N/A | #N/A | 0 | ||||||||||||||||
112 | 111 | 111 | #N/A | #N/A | #N/A | 0 | ||||||||||||||||
113 | 112 | 112 | #N/A | #N/A | #N/A | 0 | ||||||||||||||||
114 | 113 | 113 | #N/A | #N/A | #N/A | 0 | ||||||||||||||||
115 | 114 | 114 | #N/A | #N/A | #N/A | 0 | ||||||||||||||||
116 | 115 | 115 | #N/A | #N/A | #N/A | 0 | ||||||||||||||||
117 | 116 | 116 | #N/A | #N/A | #N/A | 0 | ||||||||||||||||
118 | 117 | 117 | #N/A | #N/A | #N/A | 0 | ||||||||||||||||
119 | 118 | 118 | #N/A | #N/A | #N/A | 0 | ||||||||||||||||
120 | 119 | 119 | #N/A | #N/A | #N/A | 0 | ||||||||||||||||
121 | 120 | 120 | #N/A | #N/A | #N/A | 0 | ||||||||||||||||
122 | 121 | 121 | #N/A | #N/A | #N/A | 0 | ||||||||||||||||
123 | 122 | 122 | #N/A | #N/A | #N/A | 0 | ||||||||||||||||
124 | 123 | 123 | #N/A | #N/A | #N/A | 0 | ||||||||||||||||
125 | 124 | 124 | #N/A | #N/A | #N/A | 0 | ||||||||||||||||
126 | 125 | 125 | #N/A | #N/A | #N/A | 0 | ||||||||||||||||
127 | 126 | 126 | #N/A | #N/A | #N/A | 0 | ||||||||||||||||
128 | 127 | 127 | #N/A | #N/A | #N/A | 0 | ||||||||||||||||
129 | 128 | 128 | #N/A | #N/A | #N/A | 0 | ||||||||||||||||
130 | 129 | 129 | #N/A | #N/A | #N/A | 0 | ||||||||||||||||
131 | 130 | 130 | #N/A | #N/A | #N/A | 0 | ||||||||||||||||
132 | 131 | 131 | #N/A | #N/A | #N/A | 0 | ||||||||||||||||
133 | 132 | 132 | #N/A | #N/A | #N/A | 0 | ||||||||||||||||
134 | 133 | 133 | #N/A | #N/A | #N/A | 0 | ||||||||||||||||
135 | 134 | 134 | #N/A | #N/A | #N/A | 0 | ||||||||||||||||
136 | 135 | 135 | #N/A | #N/A | #N/A | 0 | ||||||||||||||||
137 | 136 | 136 | #N/A | #N/A | #N/A | 0 | ||||||||||||||||
138 | 137 | 137 | #N/A | #N/A | #N/A | 0 | ||||||||||||||||
139 | 138 | 138 | #N/A | #N/A | #N/A | 0 | ||||||||||||||||
140 | 139 | 139 | #N/A | #N/A | #N/A | 0 | ||||||||||||||||
141 | 140 | 140 | #N/A | #N/A | #N/A | 0 | ||||||||||||||||
142 | 141 | 141 | #N/A | #N/A | #N/A | 0 | ||||||||||||||||
143 | 142 | 142 | #N/A | #N/A | #N/A | 0 | ||||||||||||||||
144 | 143 | 143 | #N/A | #N/A | #N/A | 0 | ||||||||||||||||
145 | 144 | 144 | #N/A | #N/A | #N/A | 0 | ||||||||||||||||
146 | 145 | 145 | #N/A | #N/A | #N/A | 0 | ||||||||||||||||
147 | 146 | 146 | #N/A | #N/A | #N/A | 0 |