2019Waterford - Google Drive


1		2019 WATERFORD, 33nd Annual MICHIGAN HUMAN POWERED VEHICLE RALLY (August 10-11, 2019)
2
3				1-Hour Time Trial		Hill Climb			Coast Down		Hot Lap			200 ft Flying Start Speed				Road Race
4	#	Streamliner	Class	Place	Pts		Place	Pts	Place	Pts	Place	Pts	Sat.Pts.	Time-seconds	Avg MPH	Place	Pts	Place	Pts	Sun. Pts	Total Pts.
5	71	Dan Zolyniak	Streamliner	2	55		3	60	1	60	2	55	230	3.304	41.27	1	60	1	60	120	350
6	42	Dennis Grelk	Streamliner	1	60		1	55	2	55	3	50	220	3.323	41.04	2	55	2	55	110	330
7	17	John Simon	Streamliner	3	50		2	50	3	50	1	60	210	3.38	40.34	3	50	3	50	100	310
8	21	Dan Glatch	Streamliner	4	45		4	45	4	45	4	45	180			:	0	:	0	0	180
9	#	StreetLiner	Class	Place	Pts		Place	Pts	Place	Pts	Place	Pts	Sat.Pts.	Time-seconds	Avg MPH	Place	Pts	Place	Pts	Sun. Pts	Total Pts.
10	161	Tony Levand	Streetliner	1	60		4	45	2	55	1	60	220	3.5211	38.73	1	60	1	60	120	340
11	144	Jeff Hunn	Streetliner	3	50		3	50	1	60	2	55	215	3.846	35.46	4	45	2	55	100	315
12	104	Eric Winn	Streetliner	4	45		2	55	4	45	3	50	195	3.833	35.58	3	50	4	45	95	290
13	112	Michael Hinterseher	Streetliner	2	55		1	60	3	50	:	0	165	3.532	38.61	2	55	3	50	105	270
14				1-Hour Time Trial		Hill Climb			Coast Down		Hot Lap			200 ft Flying Start Speed				Road Race
15	#	Stock	Class	Place	Pts		Place	Pts	Place	Pts	Place	Pts	Sat.Pts.	Time-seconds	Avg MPH	Place	Pts	Place	Pts	Sun. Pts	Total Pts.
16	360	Dennis Grelk	Stock	1	60		2	55	1	60	4	45	220	3.631	37.56	2	55	1	60	115	335
17	372	Robert Lloyd	Stock	3	50		3	50	2	55	3	50	205	3.755	36.32	3	50	3	50	100	305
18	440	David JJohnson	Stock	6	39		4	45	4	45	5	42	171	4.205	32.43	7	36	5	42	78	249
19	313	Joseph Solecki	Stock	4	45		:	0	3	50	1	60	155	4.095	33.30	6	39	4	45	84	239
20	304	Eric Winn	Stock	7	36		1	60	5	42	:	0	138	4.185	32.58	5	42	6	39	81	219
21	340	Charles Brown	Stock	8	34		7	36	7	36	7	36	142	5.247	25.99	8	34	7	36	70	212
22	341	Ishtey Amminger	Stock	5	42		:	0	:	0	2	55	97	3.823	35.67	4	45	2	55	100	197
23	486	Paul Pancella	Stock	:	0		6	39	6	39	6	39	117	:		:	0	:	0	0	117
24	365	Mike Mowett	Stock	2	55		:	0	:	0	:	0	55	3.522	38.72	1	60	:	0	60	115
25	#	Women	Class	:	Pts		Place	Pts	Place	Pts	Place	Pts	Sat.Pts.	Time-seconds	Avg MPH	Place	Pts	Place	Pts	Sun. Pts	Total Pts.
26	671	Amanda Zolyniak	Women	1	60		1	60	1	60	:	0	180	4.445	30.68	1	60	1	60	120	300
27				1-Hour Time Trial		Hill Climb			Coast Down		Hot Lap		0	200 ft Flying Start Speed				Trike Race
28	#	Trike	Class	Place	Pts		Place	Pts	Place	Pts	Place	Pts	Sat.Pts.	Time-seconds	Avg MPH	Place	Pts	Place	Pts	Sun. Pts	Total Pts.
29	901	David Hull	Trike	1	60		1	60	1	60	1	60	240	5.125	26.61	1	60	1	60	120	360
30	934	Eric Penn	Trike	2	55		2	55	1	60	2	55	225	:		:	0	:	0	0	225
31				1-Hour Time Trial		Hill Climb			Coast Down		Hot Lap		0	200 ft Flying Start Speed				Road Race
32	#	Junior	Class	Place	Pts		Place	Pts	Place	Pts	Place	Pts	Sat.Pts.	Time-seconds	Avg MPH	Place	Pts	Place	Pts	Sun. Pts	Total Pts.
33	564	Johannes Hinterseher	Junior	1	60		1	60	1	60	2	55	235	5.91	23.07	1	60	1	60	120	355
34	572	Cameron Lloyd	Junior	4	45		2	55	2	55	1	60	215	6.224	21.91	3	50	2	55	105	320
35	599	Amalie Hinterseher	Junior	2	55		:	0	:	0	:	0	55	6.044	22.56	2	55	4	45	100	155
36	566	Elisabeth Hinterseher	Junior	3	50		:	0	:	0	:	0	50	6.72	20.29	4	45	3	50	95	145
37	VLOOKUP TABLE
38	1	60		q2
39	2	55
40	3	50
41	4	45
42	5	42
43	6	39
44	7	36
45	8	34
46	9	32
47	10	30
48	11	29
49	12	28
50	13	27
51	14	26
52	15	25
53	16	24
54	17	23
55	18	22
56	19	21
57	20	20
58	21	19
59	22	18
60	23	17
61	24	16
62	25	15
63	:	0
64	dnf	0
65	:	0
66


1	Pos	Name	No.	Laps	Total Tm	Diff	Gap	Avg. Speed	Best Spd	In Lap	Class	PIC	Best Tm
2	1	Dennis Grelk	42	23	1:02:12	-	-	31.53	32.275	2	Streamliner	1	2:38.523
3	2	Dan Zolyniak	71	22	1:02:36	1 Lap	1 Lap	29.966	31.558	6	Streamliner	2	2:42.122
4	3	John Simon	17	22	1:04:48	+2:11.758	+2:11.758	28.95	30.722	3	Streamliner	3	2:46.536
5	4	Tony Levand	161	20	1:03:14	3 Laps	2 Laps	26.969	29.848	18	Streetliner	1	2:51.410
6	5	Michael Hinterseher	112	18	1:04:22	5 Laps	2 Laps	23.845	25.498	4	Streetliner	2	3:20.655
7	6	Jeff Hunn	144	18	1:04:38	+15.716	+15.716	23.748	25.264	15	Streetliner	3	3:22.516
8	7	Eric Winn	104	15	1:02:40	8 Laps	3 Laps	20.411	21.713	2	Streetliner	4	3:55.639
9	8	Dan Glatch	21	14	1:02:40	9 Laps	1 Lap	19.049	20.234	14	Streamliner	4	4:12.863
10	9	David Hull	901	13	1:03:29	10 Laps	1 Lap	17.462	18.828	1	Trike	1	4:31.733
11	10	Johannes Hinterseher	564	11	1:04:11	12 Laps	2 Laps	14.615	17.385	1	Junior	1	4:54.294
12	11	Eric Penn	934	11	1:07:55	+3:43.814	+3:43.814	13.813	15.577	1	Trike	2	5:28.456


1	Pos	Name	No.	Laps	Total Tm	Diff	Gap	Avg. Speed	Best Spd	In Lap	Class	PIC	Best Tm
2	1	Dennis Grelk	360	19	1:01:28	-	-	26.358	27.97	1	Stock	1	3:02.924
3	2	Mike Mowett	365	19	1:02:30	+1:01.606	+1:01.606	25.925	28.087	2	Stock	2	3:02.159
4	3	Robert Lloyd	372	18	1:03:47	1 Lap	1 Lap	24.063	25.374	1	Stock	3	3:21.638
5	4	Joseph Solecki	313	16	1:01:49	3 Laps	2 Laps	22.072	24.204	1	Stock	4	3:31.379
6	5	Ishtey Amminger	341	16	1:02:57	+1:07.844	+1:07.844	21.676	23.62	1	Stock	5	3:36.614
7	6	David JJohnson	440	16	1:04:26	+2:36.936	+1:29.092	21.176	23.619	1	Stock	6	3:36.619
8	7	Amanda Zolyniak	671	15	1:03:42	4 Laps	1 Lap	20.081	21.765	1	Women	1	3:55.076
9	8	Eric Winn	304	14	1:04:45	5 Laps	1 Lap	18.439	19.415	5	Stock	7	4:23.521
10	9	Charles Brown	340	13	1:05:50	6 Laps	1 Lap	16.838	18.887	1	Stock	8	4:30.891
11	10	Amalie Hinterseher	599	8	1:04:41	11 Laps	5 Laps	10.547	13.453	1	Junior	1	6:20.298
12	11	Elisabeth Hinterseher	566	7	1:01:02	12 Laps	1 Lap	9.78	12.844	1	Junior	2	6:38.340
13	12	Cameron Lloyd	572	1	6:15	18 Laps	6 Laps	13.643	13.747	1	Junior	3	6:12.181


1	No.	Name	Best Tm	In Lap	Diff	Gap
2	161	Tony Levand	53.833	6	+1:20.139	+22.734
3	17	John Simon	54.483	12	+1:20.789	+0.650
4	313	Joseph Solecki	56.011	1	+1:22.317	+1.528
5	71	Dan Zolyniak	56.858	3	+1:23.164	+0.847
6	341	Ishtey Amminger	57.506	5	+1:23.812	+0.648
7	372	Robert Lloyd	1:01.003	7	+1:27.309	+3.497
8	42	Dennis Grelk	1:01.325	4	+1:27.631	+0.322
9	360	Dennis Grelk	1:02.582	5	+1:28.888	+1.257
10	440	David JJohnson	1:05.706	16	+1:32.012	+3.124
11	144	Jeff Hunn	1:06.152	4	+1:32.458	+0.446
12	671	Amanda Zolyniak	1:11.485	3	+1:37.791	+5.333
13	104	Eric Winn	1:12.132	5	+1:38.438	+0.647
14	486	Paul Pancella	1:15.348	2	+1:41.654	+3.216
15	340	Charles Brown	1:22.311	1	+1:48.617	+6.963
16	901	David Hull	1:23.137	3	+1:49.443	+0.826
17	572	Cameron Lloyd	1:30.872	3	+1:57.178	+7.735
18	934	Eric Penn	1:32.035	2	+1:58.341	+1.163
19	564	Johannes Hinterseher	1:34.09	5	+57.405	+1.681
20	21	Dan Glatch	1:34.619	1	+2:00.925	+2.584


1	Pos	Name	No.	Laps	Total Tm	Diff	Gap	Avg. Speed	Best Spd	In Lap	Class	PIC	Best Tm	Last Spd	Last Tm
2	1	Tony Levand	161	36	34:40.994	-	-	27.402	30.068	23	Streetliner	1	52.681	27.533	57.531
3	2	Dan Zolyniak	71	36	34:57.110	+16.116	+16.116	27.192	29.142	26	Streamliner	1	54.355	26.736	59.246
4	3	Dennis Grelk	42	35	35:14.658	1 Lap	1 Lap	26.217	28.023	27	Streamliner	2	56.526	26.614	59.518
5	4	John Simon	17	35	35:18.688	+4.030	+4.030	26.167	27.334	4	Streamliner	3	57.949	27.141	58.361
6	5	Jeff Hunn	144	30	35:41.001							2
7	6	Micheal Hinterseher	112	28	35:04.044	8 Laps	7 Laps	21.079	24.671	2	Streetliner	3	1:04.204	7.188	3:40.374
8	7	Eric Winn	104	27	35:42.305	9 Laps	1 Lap	19.964	22.16	2	Streetliner	4	1:11.479	19.638	1:20.660


1	Pos	Name	No.	Laps	Total Tm	Diff	Gap	Avg. Speed	Best Spd	In Lap	Class	PIC	Best Tm	Last Spd	Last Tm
2	1	Dennis Grelk	360	21	22:55.203	-	-	24.188	26.093	15	Stock	1	1:00.707	24.416	1:04.876
3	2	Ishtey Amminger	341	20	23:13.666	1 Lap	1 Lap	22.731	26.312	20	Stock	2	1:00.200	26.312	1:00.200
4	3	Robert Lloyd	372	20	23:21.098	+7.432	+7.432	22.611	24.484	12	Stock	3	1:04.694	17.38	1:31.141
5	4	Joseph Solecki	313	20	23:57.117	+43.451	+36.019	22.044	24.063	6	Stock	4	1:05.828	21.49	1:13.707
6	5	David JJohnson	440	19	23:44.930	2 Laps	1 Lap	21.121	22.958	2	Stock	5	1:08.996	17.23	1:31.933
7	6	Eric Winn	304	18	23:40.291	3 Laps	1 Lap	20.075	21.56	14	Stock	6	1:13.469	18.561	1:25.339
8	7	Amanda Zolyniak	671	18	23:48.269	+7.978	+7.978	19.963	21.813	4	Women	1	1:12.617	20.878	1:15.868
9	8	David Hull	901	16	23:18.149	5 Laps	2 Laps	18.127	19.602	2	Trike	1	1:20.809	18.78	1:24.346
10	9	Charles Brown	340	16	23:38.829	+20.680	+20.680	17.863	20.194	2	Stock	7	1:18.438	14.981	1:45.732
11	10	Johannes Hinterseher	564	15	24:22.747	6 Laps	1 Lap	16.243	18.7	2	Junior	1	1:24.707	16.048	1:38.701
12	11	Cameron Lloyd	572	13	23:31.454	8 Laps	2 Laps	14.589	16.892	2	Junior	2	1:33.773	15.07	1:45.107
13	12	Elisabeth Hinterseher	566	12	23:54.969	9 Laps	1 Lap	13.246	15.495	2	Junior	3	1:42.225	13.919	1:53.802
14	13	Amalie Hinterseher	599	11	24:45.010	10 Laps	1 Lap	11.733	14.282	2	Junior	4	1:50.911	9.728	2:42.821


1
2
3
4
5	https://docs.google.com/spreadsheets/d/1bXKa5iZGy3Y82b8xZQEXdNj5pez4mSrID5mwno2zOaQ/edit#gid=1257209333&range=A1