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
Gecko Wheels Alpine Pursuit			Newry to Neerim		2018			320	240	220	0	0	0	0	780		153	104	112		117	15%	NO BONUS FOR		5	OR MORE ERRORS
														% ALLOCATED TO THE BONUS POINTS ( NOTE THIS ROW MUST TOTAL 100 % )	0.00%		15.00%	30.00%	30.00%				5.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 DISTANCE PER DAY			PENALTIES			COURSE PENALTIES			Max 117		FINAL
#	TEAM NAME	DRIVER 1	DRIVER 2	NAVIGATOR 1	NAVIGATOR 2	NAVIGATOR 3	NAVIGATOR 4	A	B	C	D	E	SS1	SS2	Subtotal	PENALTIES	Day-A	Day-B	Day-C	LATE	PENALTY	SPEED	Day-A	Day-B	Day-C	# Bonus	TOTAL	AFT PEN / BONUS
1	Team Patrolapart	Tyler Steuart R=436	Peter Butcher R=3	Guy Steuart R=450	Elizabeth Butcher R=448			290	230	210					730	1	157	106	112	0		0	0	-5	0	113.6	838.6	1
2	Several Hands Racing	Gary Coates R=10	Barry Clay R=11	Lee Bumstead R=414	Steven Clay R=6			290	210	205					705	2	155	107	112	0		-5	0	0	-10	111.1	801.1	2
3	Have A Crack	Mathew Ball R=173	Marcus Bloodworth R=117	Chloe Foster R=0	Ben Lepp R=0	Darcy Bloodworth R=194		270	225	190					685	3	156	108	123	0	-10	0	0	-20	-10	98.2	743.2	3
4	Pantless Pirates, Locked and Loaded	Scott Mynard R=0	Mitch Mather R=0	John Mynard R=0	Peter Ing R=321	Ash Morrey R=0		235	225	190					650	4	158	108	103	-1		0	-20	0	-20	69.5	678.5	4
5	Cruiser Abuse Racing	Daniel Briscoe R=810	Brad Sherry R=0	Brian Mynard R=810	Mitch Briscoe R=0	Ashley Thornton R=0		250	200	180					630	6	154	111	116	0		-15	-10	-20	-30	91.8	646.8	5
6	LineMX 4x4 ORC	Joel Smith R=122	Damien Witts R=81	Anthony Craig R=171	Jason Stangherlin R=760			245	200	150					595	8	164	105	105	-15		0	-20	-10	-10	69.9	609.9	6
7	Simplessquuick	Troy Garner R=244	Craig Lasham R=286	Matt Jensick R=0	David Picknell R=430			250	195	190					635	5	166	112	114	-3		-10	-40	-30	-30	86.8	608.8	7
8	Team Choppy	Lauren Harling R=0		Kim Hardy R=12				290	180	130					600	7	159	109	99	-5		-5	0	-30	-20	58.6	598.6	8
9	PBA Automotive	Aaron Plant R=820	Jamie McMillan R=0	Beau Foster R=783	Rohan Start R=0	Stuart Harper R=0	Josh Young R=0	180	150	210					540	10	159	107	120	-7	-10	-15	-40	-20	-50	89.6	487.6	9
10	Lock, Stomp and Steer	Simon Cooper R=0	David Waldron R=546	Paul Trice R=0	Rhiannon Abbott R=0			240	210	120					570	9	158	107	153	-154		0	0	-10	-30	64.0	440.0	10
11	Polar Express	Troy Rowley R=0	Scott Rowley R=0	Lachlan Driscoll R=0	Kerran Pridmore R=0			100	155	160					415	14	160	114	113	0		0	-30	-10	-30	94.7	439.7	11
12	Wilderbeast-Team Dakar	Steve Golding R=604	Mike Farrow R=897	Tony Heathcote R=0	Jeremy Campbell R=0			120	190	165					475	11	155	131	113	-99		0	0	-40	0	69.7	405.7	12
13	No Straight Panel	Lukas Watt R=431	Thomas Saunders R=635	Michael Taylor R=0	Sean Eastaugh R=254	Robert Henrt R=0		100	180	160					440	13	150	117	114	-114		-25	-20	-20	-30	90.3	321.3	13
14	Route A Crack	Steve Graham R=154	Andrew Dean R=422	Steve Peacock R=252	Sean Peacock R=0			160	150	160					470	12	141	107	117	-198		-5	-10	-20	-20	77.7	294.7	14
15	Jeep Racing	Martin Cool R=180	Scott Rogers R=172	Samantha Kool R=0	Darren Reichert R=203			60	140	160					360	15	111	105	98	-99		0	-10	-20	-40	42.4	233.4	15
16					Ryan Balmer R=0										0											0.0