NAVRUN - THE ULTIMATE IN NAVIGATIONAL CHALLENGES AND 4WD OFF ROAD ADVENTURES
Event Name Event Location Event Year Below are MAX scores Per Stage SS1 SS2 MAX / OR
REF SCORE
  REF DIST
KMS-DAY A
REF DIST
KMS-DAY B
REF DIST
KMS-DAY C
  KM Bonus
Multiplier
suggest COURSE PENALTY POINTS PER ERROR -5  
Amazing Race NE Victoria 2018 400 350 410 0 0 0 0 1160   174 126 180   174 15% NO BONUS FOR 5 OR MORE ERRORS  
        % ALLOCATED TO THE BONUS POINTS ( NOTE THIS ROW MUST TOTAL 100 % ) 0.00%   24.00% 23.00% 23.00%       10.00% 10.00% 10.00%   100%  
THIS TAB IS FOR - SORTING AND PRINTING OUT THE FINAL RESULTS
INPUT MADE FROM INPUT SHEET - WHEN COMPLETED - SORT THE UNPROTECTED CELLS AND SORT BY "AFT PEN / BONUS" IF CELLS ARE WRITTEN OVER YOU WILL NOT HAVE PROPER OUTPUT.
    DISTANCE MUST PENALTIES ARE VALUES LESS THAN " 0 "      
AUTO CALC POS BE FILLED AUTO CALC AUTO CALC POS
        Below Are the STAGE Names special stage   PRE  COMPETITOR DIST. PER DAY PENALTIES COURSE PENALTIES Max 174   FINAL
# TEAM NAME DRIVER 1 NAVIGATOR 1 NAVIGATOR 2 NAVIGATOR 3 A B C D E SS1 SS2 Subtotal PENALTIES Day-A Day-B Day-C LATE U-TURN SPEED Day-A Day-B Day-C # Bonus TOTAL AFT PEN / BONUS
1 ATOC-Z Aaron Carlton R=19 Brad Carlton R=440 Lucy Ventham R=0   360 340 380         1080 3 183 127 200 0     0 0 -6 163.5 1237.5 1
2 No Hands Racing Barry Clay R=11 Steven Clay R=6 Leanne Reidy R=152   400 330 380         1110 1 196 132 221 0     0 -5 -13 114.9 1206.9 2
3 Team 4wd NavChallenge Gary Coates R=10 Riki Coates R=314     340 340 370         1050 9 174 128 181 0     0 0 -11 165.5 1204.5 3
4 Team Ruffles Kerryl Fox R=0 Daniel Hose R=38     370 330 330         1030 15 176 128 182 0     0 0 0 172.5 1202.5 4
5 Team Cloggs Josh Boer R=54 Jack Boer R=43     355 320 380         1055 8 193 144 200 0     0 -5 -10 150.4 1190.4 5
6 Team Fourby Steve Eccles R=40 Sarah Cohen R=74     390 330 350         1070 5 184 134 214 0     0 -8 -21 142.8 1183.8 6
7 Totally Exhausted Dave Robinson R=186 Liam Connolly R=151 Amy Cumper R=452   390 330 360         1080 3 178 160 186 0     0 -5 -14 118.5 1179.5 7
8 Team Patrolapart Peter Butcher R=3 Elizabeth Butcher R=448     390 340 360         1090 2 191 128 224 0     0 0 -24 112.9 1178.9 8
9 Mallee Routers Aaron Hopfner R=17 Nigel Harris R=0 Wolf Hopfner R=0   360 350 330         1040 13 179 128 197 0     0 0 -23 152.7 1169.7 9
10 Another Crack Marcus Bloodworth R=117 Jake Harris R=0     355 340 350         1045 11 177 127 196 0     0 0 -28 152.3 1169.3 10
11 South Boys Sean Linley R=0 Kris Linley R=31     320 340 380         1040 13 177 133 188 0     -5 0 -21 154.0 1168.0 11
12 All The Perks Katrina Perkins R=319 Steele Perkins R=32     390 350 320         1060 7 185 127 215 0     0 -5 -35 143.8 1163.8 12
13 Team Frontera Andrew Stubbs R=192 Chase Stubbs R=199     370 280 380         1030 15 176 131 198 0     0 -5 -19 151.7 1157.7 13
14 Short Black Sean Daley R=52 Bec Daley R=93     360 330 360         1050 9 176 138 202 0     -17 -5 -18 146.7 1156.7 14
15 The Warrens' Jason Warren R=96 Fiona Warren R=95     400 310 360         1070 5 178 160 205 0     0 -11 -28 103.1 1134.1 15
16 Wonder Women Steph Forte R=0 Laura Robinson R=361     380 320 290         990 20 179 127 187 0     0 0 -21 156.4 1125.4 16
17 Team Choppy Lauren Harling R=0 Kim Hardy R=12     370 290 360         1020 17 176 191 187 0     -5 0 -14 121.4 1122.4 17
18 Team Chook Damien DeHaas R=28 Tristan DeHaas R=115 Chloe DeHaas R=520   360 320 365         1045 11 213 139 188 0     0 -8 -23 105.2 1119.2 18
19 Where's the Playground Michael Jenkins R=503 Kelly Jenkins R=503     320 320 380         1020 17 169 139 182 0     -19 -34 -11 141.5 1097.5 19
20 All Who Wander Are Not Lost David Gunton R=0 Rowena Gunton R=0     310 320 380         1010 19 169 139 182 0     -19 -34 -11 141.5 1087.5 20
21 Four Amigos Gerard Harrison R=136 Merlynn Harrison R=138 April Harrison R=666   310 320 340         970 21 182 145 196 0     0 -8 -27 140.7 1075.7 21
22 Mudflappers Russell Paulin R=18 Lesley Wiadrowski R=67     350 300 310         960 22 178 185 208 0     0 -5 -15 113.7 1053.7 22
23 Fukawi Dee Carlton R=188 Terry Hanley R=185     280 330 340         950 23 179 135 215 0     -5 0 -48 145.4 1042.4 23
24 LineMX Racing Joel Smith R=122 Tayla Smith R=0     315 310 300         925 24 184 124 219 -2 -10   -7 -5 -34 109.6 976.6 24
25 Didja Nail Her Kelvin Nayler R=0 Natalie Nayler R=0 Robyn Reeve R=0 Mick McGarry R=0 270 310 190         770 26 184 128 178 -5     -5 0 -11 162.6 911.6 25
26 Team Merrkat Igor Vasilyev R=283 Jana Vasilyev R=274     300 220 320         840 25 189 144 196 0   -5 -10 -23 -31 127.3 898.3 26
27 Team Naaray Ray Bingle R=0 Naarah Dawes R=0     315 120 320         755 27 177 162 186 -7 -10 -5 -6 -8 -27 108.0 800.0 27