NPOA Handicap Calculations.xlsx

	A	B	C	D	E	F	G	I	J	K	L	N	O	P	Q	S	T	U	V	X	Y	Z	AA	AC	AD	AE	AF	AH	AI	AJ	AK	AM	AN	AO	AP	AR	AS	AT	AU	AW	AX	AY	AZ	BB	BC	BD	BE	BG	BH	BI	BJ	BL	BM	BN	BO	BQ	BR	BS	BT	BV	BW	BX	BY	CA	CB	CC	CD	CF	CG	CH	CI	CK	CL	CM	CN	CP	CQ	CR	CS	CU	CV
1				Race	Winning Time			Race	Winning Time			Race	Winning Time			Race	Winning Time			Race	Winning Time			Race	Winning Time			Race	Winning Time			Race	Winning Time			Race	Winning Time			Race	Winning Time			Race	Winning Time			Race	Winning Time			Race	Winning Time			Race	Winning Time			Race	Winning Time			Race	Winning Time			Race	Winning Time			Race	Winning Time			Race	Winning Time			Race	Winning Time
2	Boat	Handicap		2022 PC.1	0:45:40			2022 PC.2	0:49:23			2022 PC.3	1:05:11			2022 PC.4	0:37:07			2022 PC.5	0:41:56			2022 Athene	6,234.16			2023 PC.1	0:42:43			2023 PC.2	0:58:04			2023 PC.3	0:48:05			2023 PC.4	0:52:35			2023 PC.5	0:39:47			2024 PO.2	3,611.76			2024 PC.1	1:02:53			2024 PC.2	0:44:51			2024 PC.3	0:48:17			2024 PC.4	0:52:00			2024 PC.5	0:45:41			2024 FC.1	1:11:23			2024 FC.2	0:43:01			2024 FC.3	0:26:31
3				Elapsed	Correct	Order	% from winner	Elapsed	Correct	Order	% from winner	Elapsed	Correct	Order	% from winner	Elapsed	Correct	Order	% from winner	Elapsed	Correct	Order	% from winner	Elapsed	Correct	Order	% from winner	Elapsed	Correct	Order	% from winner	Elapsed	Correct	Order	% from winner	Elapsed	Correct	Order	% from winner	Elapsed	Correct	Order	% from winner	Elapsed	Correct	Order	% from winner	Elapsed	Correct	Order	% from winner	Elapsed	Correct	Order	% from winner	Elapsed	Correct	Order	% from winner	Elapsed	Correct	Order	% from winner	Elapsed	Correct	Order	% from winner	Elapsed	Correct	Order	% from winner	Elapsed	Correct	Order	% from winner	Elapsed	Correct	Order	% from winner	Elapsed	Correct

4
5	Prawn	1117		1:06:52	0:59:52	15	31%	1:06:27	0:59:29	15	20%					0:50:32	0:45:14	17	22%	0:58:26	0:52:19	9	25%																									4,773.00	4,273.05	7	18%	1:10:54	1:03:28	3	1%	1:02:10	0:55:39	7	24%	1:00:19	0:54:00	9	12%	1:03:57	0:57:15	7	10%	0:56:41	0:50:45	7	11%
6	Goldeneye	996		0:49:08	0:49:20	4	8%	0:50:44	0:50:56	3	3%	1:07:38	1:07:54	5	4%	0:36:58	0:37:07	1	0%	0:44:48	0:44:59	5	7%	6,384	6,410	4	3%	0:50:31	0:50:43	7	19%									0:58:41	0:58:55	6	12%	0:43:01	0:43:11	8	9%	3,605.00	3,619.48	2	0%	1:03:02	1:03:17	2	1%	0:53:39	0:53:52	5	20%	0:53:48	0:54:01	10	12%	0:57:49	0:58:03	9	12%
7	Rushlight	976		0:52:24	0:53:41	7	18%	0:51:54	0:53:11	8	8%					0:43:05	0:44:09	16	19%	0:54:01	0:55:21	12	32%																	0:58:41	1:00:08	8	14%					4,797.00	4,914.96	8	36%	1:05:49	1:07:26	12	7%	0:54:58	0:56:19	11	26%	0:52:33	0:53:51	8	12%	0:56:35	0:57:58	8	11%	0:49:52	0:51:06	9	12%	1:21:33	1:23:33	10	17%	0:50:38	0:51:53	9	21%
8	Cavender	935		0:52:13	0:55:51	11	22%					1:08:20	1:13:05	11	12%	0:38:33	0:41:14	10	11%	0:58:18	1:02:21	17	49%					0:54:09	0:57:55	13	36%																	3,377.00	3,611.76	1	0%	1:00:48	1:05:02	7	3%	0:52:12	0:55:50	8	24%	0:50:05	0:53:34	6	11%	0:53:17	0:56:59	6	10%	0:48:55	0:52:19	10	15%	1:19:04	1:24:34	11	18%					0:27:03	0:28:56
9	Swallow 2	902		0:48:09	0:53:23	6	17%	0:46:21	0:51:23	4	4%	0:59:24	1:05:51	2	1%	0:34:52	0:38:39	4	4%	0:37:49	0:41:56	1	0%					0:50:45	0:56:16	12	32%	0:55:44	1:01:47	5	6%	0:43:22	0:48:05	1	0%	0:49:19	0:54:40	3	4%	0:35:53	0:39:47	1	0%					1:00:05	1:06:37	8	6%	0:47:54	0:53:06	4	18%	0:48:30	0:53:46	7	11%	0:48:02	0:53:15	2	2%	0:43:52	0:48:38	3	6%	1:08:44	1:16:12	5	7%					0:25:03	0:27:46
10	Gamecock	952						0:51:34	0:54:10	9	10%	1:07:22	1:10:46	9	9%	0:41:21	0:43:26	15	17%	0:54:26	0:57:11	13	36%					0:44:17	0:46:31	3	9%	0:56:34	0:59:25	2	2%	0:47:47	0:50:12	2	4%	0:53:51	0:56:34	4	8%	0:40:23	0:42:25	6	7%					1:07:26	1:10:50	15	13%	0:52:43	0:55:22	6	23%	0:49:41	0:52:11	4	8%	0:55:29	0:58:17	11	12%	0:47:43	0:50:07	5	10%	1:13:58	1:17:42	6	9%					0:27:04	0:28:26
11	Decoy	935		0:43:28	0:46:29	2	2%	0:46:10	0:49:23	1	0%	1:03:07	1:07:30	4	4%	0:35:13	0:37:40	3	1%	0:41:42	0:44:36	4	6%					0:42:35	0:45:33	2	7%	0:55:56	0:59:49	3	3%	0:47:26	0:50:44	3	6%	0:49:10	0:52:35	1	0%	0:37:23	0:39:59	2	1%	3,404.00	3,640.64	3	1%	0:59:32	1:03:40	4	1%	0:41:56	0:44:51	1	0%	0:45:09	0:48:17	1	0%	0:48:37	0:52:00	1	0%	0:47:43	0:51:02	8	12%
12	Greylag	884																										1:00:40	1:08:38	16	61%	1:11:51	1:21:17	14	40%	0:51:55	0:58:44	10	22%	0:55:26	1:02:42	12	19%	0:41:49	0:47:18	12	19%					0:59:03	1:06:48	9	6%	0:44:33	0:50:24	2	12%	0:47:52	0:54:09	11	12%	0:51:27	0:58:12	10	12%	0:40:23	0:45:41	1	0%	1:06:12	1:14:53	3	5%					0:26:18	0:29:45
13	Wild Goose	884		0:44:46	0:50:38	5	11%	0:46:35	0:52:42	7	7%	1:01:06	1:09:07	8	6%	0:34:57	0:39:32	5	7%	0:42:18	0:47:51	6	14%	6,038	6,830	8	10%	0:45:35	0:51:34	8	21%	0:59:10	1:06:56	8	15%	0:46:57	0:53:07	5	10%	0:52:15	0:59:06	7	12%	0:37:23	0:42:17	5	6%																									1:03:06	1:11:23	1	0%	0:42:32	0:48:07	3	12%	0:25:43	0:29:05
14	Pipit	884																																																																						1:06:42	1:15:27	4	6%	0:45:13	0:51:09	8	19%	0:28:37	0:32:22
15	Grebe	884																										0:46:12	0:52:16	9	22%	1:03:56	1:12:19	11	25%	0:51:55	0:58:44	10	22%	0:53:29	1:00:30	10	15%	0:40:53	0:46:15	11	16%					1:01:26	1:09:30	13	11%	0:51:32	0:58:18	14	30%	0:49:06	0:55:33	14	15%	0:53:23	1:00:23	14	16%	0:43:27	0:49:09	4	8%									0:27:53	0:31:33
16	Razerbill	879																						5,892	6,703	7	8%	0:42:31	0:48:22	5	13%	0:54:01	1:01:27	4	6%	0:48:02	0:54:39	7	14%	0:57:05	1:04:56	14	23%					3,475.00	3,953.36	5	9%	0:59:08	1:07:16	11	7%	0:50:48	0:57:48	13	29%	0:49:59	0:56:52	17	18%	0:52:45	1:00:01	13	15%	0:46:19	0:52:42	13	15%	1:11:17	1:21:06	8	14%	0:39:54	0:45:24	2	6%	0:24:33	0:27:56
17	Blackbird	847		0:38:41	0:45:40	1	0%	0:43:04	0:50:51	2	3%	0:55:13	1:05:11	1	0%	0:31:36	0:37:18	2	1%	0:37:39	0:44:27	3	6%	5,479	6,469	5	4%	0:36:11	0:42:43	1	0%	0:49:11	0:58:04	1	0%	0:44:00	0:51:57	4	8%	0:44:56	0:53:03	2	1%	0:35:06	0:41:26	4	4%					0:54:00	1:03:45	5	1%	0:44:33	0:52:36	3	17%	0:41:11	0:48:37	2	1%	0:46:43	0:55:09	3	6%	0:39:04	0:46:07	2	1%
18	Rainbow Trout	884		0:50:05	0:56:39	12	24%	0:50:33	0:57:11	13	16%	1:04:08	1:12:33	10	11%	0:37:03	0:41:55	12	13%	0:56:37	1:04:03	18	53%													0:51:25	0:58:10	9	21%	0:54:13	1:01:20	11	17%	0:38:53	0:43:59	9	11%					1:06:22	1:15:05	20	19%	0:54:32	1:01:41	20	38%	0:57:19	1:04:50	23	34%	0:56:44	1:04:11	19	23%	0:48:46	0:55:10	17	21%
19	Grayling	884																										0:54:53	1:02:05	14	45%	1:08:54	1:17:56	13	34%	0:52:00	0:58:49	12	22%	0:58:41	1:06:23	15	26%	0:42:44	0:48:20	13	22%					1:09:31	1:18:38	22	25%	0:54:20	1:01:28	19	37%	0:47:52	0:54:09	11	12%	0:59:04	1:06:49	21	29%	0:51:37	0:58:23	20	28%
20	Merlin	847		0:41:26	0:48:55	3	7%	0:44:19	0:52:19	5	6%	0:57:00	1:07:18	3	3%	0:34:23	0:40:36	8	9%	0:42:35	0:50:17	8	20%																									3,574.00	4,219.60	6	17%	1:01:30	1:12:37	18	15%	0:51:10	1:00:25	18	35%	0:49:23	0:58:18	20	21%	0:51:16	1:00:32	15	16%	0:44:32	0:52:35	12	15%	1:09:31	1:22:04	9	15%	0:36:26	0:43:01	1	0%	0:22:28	0:26:31
21	Peregrine	847		0:51:57	1:01:20	16	34%	0:49:40	0:58:38	14	19%	1:02:42	1:14:02	12	14%	0:39:03	0:46:06	18	24%	0:51:57	1:01:20	15	46%	5,858	6,916	9	11%	0:45:41	0:53:56	10	26%	1:01:40	1:12:48	12	25%	0:51:15	1:00:30	14	26%	0:58:01	1:08:30	16	30%	0:42:14	0:49:52	14	25%					1:06:52	1:18:57	23	26%	0:53:44	1:03:26	22	41%	0:49:31	0:58:28	21	21%	0:56:27	1:06:39	20	28%	0:47:11	0:55:42	18	22%
22	Cormorant	847		0:49:41	0:58:39	13	28%	0:50:25	0:59:31	16	21%	1:04:50	1:16:33	13	17%	0:36:15	0:42:48	14	15%	0:52:05	1:01:29	16	47%					0:45:58	0:54:16	11	27%	0:59:26	1:10:10	10	21%	0:54:50	1:04:44	15	35%													1:01:23	1:12:28	17	15%	0:49:56	0:58:57	17	31%	0:48:36	0:57:23	19	19%	0:53:03	1:02:38	18	20%	0:44:21	0:52:22	11	15%
23	Goosander	925														0:36:52	0:39:51	6	7%	0:50:13	0:54:17	11	29%	5,846	6,320	3	1%					1:00:50	1:05:46	6	13%	0:51:59	0:56:12	8	17%	0:55:50	1:00:22	9	15%	0:42:27	0:45:54	10	15%	3,616.00	3,909.19	4	8%	1:06:35	1:11:59	16	14%	0:53:56	0:58:18	15	30%	0:52:56	0:57:14	18	19%	0:56:50	1:01:26	16	18%					1:12:37	1:18:30	7	10%
24	Flamingo	884																																																		1:08:50	1:17:52	21	24%	0:55:50	1:03:10	21	41%	0:56:05	1:03:27	22	31%	1:01:40	1:09:46	22	34%	0:56:10	1:03:32	21	39%									0:27:42	0:31:20
25	White Eagle	847														0:36:03	0:42:34	13	15%	0:55:12	1:05:10	19	55%					0:56:59	1:07:17	15	57%					0:56:29	1:06:41	16	39%	1:08:19	1:20:39	17	53%	0:44:51	0:52:57	15	33%					1:03:00	1:14:23	19	18%	0:54:14	1:04:02	23	43%	0:45:12	0:53:22	5	11%	1:00:23	1:11:17	23	37%	0:48:41	0:57:29	19	26%	1:18:24	1:32:34	13	30%					0:25:22	0:29:57
26	Snow Goose	884																						5,732	6,484	6																										0:55:35	1:02:53	1	0%	0:49:44	0:56:16	9	25%	0:45:12	0:51:08	3	6%	0:49:55	0:56:28	5	9%	0:46:43	0:52:51	14	16%	1:05:25	1:14:00	2	4%	0:45:06	0:51:01	7	19%	0:24:49	0:28:04
27	Redwing	884		0:48:50	0:55:14	10	21%	0:49:59	0:56:33	12	15%	1:08:32	1:17:32	14	19%	0:36:32	0:41:20	11	11%	0:47:51	0:54:08	10	29%	5,586	6,319	2	1%																									0:57:13	1:04:43	6	3%	0:49:44	0:56:16	9	25%	0:49:45	0:56:17	15	17%	0:51:54	0:58:43	12	13%	0:44:25	0:50:15	6	10%					0:43:18	0:48:59	5	14%	0:25:18	0:28:37
28	Woodpecker	884		0:47:37	0:53:52	8	18%	0:49:16	0:55:44	11	13%	1:00:28	1:08:24	7	5%	0:35:21	0:39:59	7	8%	0:42:55	0:48:33	7	16%					0:44:50	0:50:43	6	19%	1:00:19	1:08:14	9	18%	0:52:20	0:59:12	13	23%	0:57:22	1:04:54	13	23%	0:37:32	0:42:28	7	7%					0:59:15	1:07:01	10	7%	0:51:42	0:58:29	16	30%	0:48:46	0:55:10	13	14%	0:49:49	0:56:21	4	8%	0:48:28	0:54:50	16	20%					0:42:45	0:48:22	4	12%
29	Jackdaw	847		0:45:39	0:53:54	9	18%	0:44:36	0:52:39	6	7%	0:57:45	1:08:11	6	5%	0:34:35	0:40:50	9	10%	0:37:21	0:44:06	2	5%					0:39:47	0:46:58	4	10%	0:56:31	1:06:44	7	15%	0:45:31	0:53:44	6	12%	0:48:58	0:57:49	5	10%	0:34:03	0:40:12	3	1%
30	Comet	884																						5,511	6,234	1	0%
31	Woodlark	1003	p	0:58:56	0:58:45	14	29%	0:55:46	0:55:36	10	13%									0:58:26	0:58:16	14	39%
32	Wahoo	856	p																																																	1:00:07	1:10:14	14	12%	0:49:13	0:57:30	12	28%	0:48:21	0:56:29	16	17%	0:53:02	1:01:57	17	19%	0:45:23	0:53:01	15	16%	1:15:07	1:27:45	12	23%	0:42:39	0:49:49	6	16%
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
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
100