tidetimes2425.xlsx

	A	B	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF	AH	AI	AJ	AK	AL	AQ	AR	AU	AV	AW	AX	AY	AZ	BA	BB	BC	BD	BE	BG	BH	BI	BT	BU	BV	BW	BX	BY	BZ	CA	CB
1	Tides Aug 2024- Jul 2025																							Not done
2			Corrected for OSC from Port Office ----------------------------------------------------------------------------------------------												Diff> extr> to> turn>	0:40	Sat range & flow					Sun Start Sailing flow	Sun Start Sailing level	Tue Pamphlett			Ancillary tables from here on ...
3			Mon time	Mon height	Tue time	Tue height	Wed time	Wed height	Thu time	Thu height	Fri time	Fri height	Sat time	Sat height	Sun time	Sun height	Range -ve ebb	Flow -ve is ebb
4																	Range	6.3	max for 2m	Level start	& finish						511.93	07:45	7:45
5			Port Office is Bar+0:30 & Tennyson +0:50														Up to:	1.5	Very good	Windows:				Start			1.041889
6																	Up to:	3	Good	Start:		12:00		10:00	Mid
7			Use Port Office for 201617 on!					<-Done. Average change over first week +0:37, -0.12									Up to:	4.5	Medium	14:00	14:30	14:30		End	10:00
8																	>:	4.5	Bad	Finish	16:00	17:00		13:00
9																	Flows are at:	14:20	<Start	16:45	17:15						Lookup tables for badness:
10			Highlighting below:				<0.2	<0.3		>2.3	>2.4						at these	15:25	<Mid
11																	times	16:30	<End

12	August		Mon	29	Tue	30	Wed	31	Thu	1	Fri	2	Sat	3	Sun	4											12ths rule		sin 30x	diffs (sum 1)	* 6
13			04:14	1.71	05:28	1.55	01:20	0.64	02:35	0.54	03:30	0.46	04:17	0.40	04:56	0.39											0	1	0	0.5	3
14			10:44	0.33	11:46	0.36	06:47	1.48	07:59	1.49	08:57	1.54	09:45	1.59	10:25	1.64								0.73	0.51		1	2	0.5	0.3660254038	2.196152423
15			17:28	2.01	18:40	2.09	12:50	0.36	13:52	0.34	14:50	0.32	15:38	0.30	16:20	0.29	-1.3	-3.7	Start	0.49	0.36						2	3	0.8660254038	0.1339745962	0.8038475773
16			23:50	0.69	00:20	0.00	19:45	2.19	20:40	2.26	21:27	2.30	22:08	2.31	22:46	2.31	2.0	-1.7	Mid	0.48	0.59						3	3	1										-------------------------------					-------------------------------
17																		0.5	End								4	2											Lookup table for height					Lookup table for flow
18			Mon	5	Tue	6	Wed	7	Thu	8	Fri	9	Sat	10	Sun	11											5	1	For 6-hour	Flow rate			Height?
19			05:32	0.39	06:03	0.40	06:31	0.39	00:20	2.19	00:49	2.11	01:20	1.98	01:52	1.83											6	0	tide					Sum/max				Time range	Time cutoff	Height	Interval	Increment	Increment	Time cutoff	Increment	Time range
20			11:01	1.68	11:35	1.71	12:06	1.74	06:56	0.38	07:22	0.37	07:50	0.38	08:22	0.40	-1.6	0.4	Start					1.42	1.51		20 min resolution		Minutes-10	sin(angle)	Increment	Inc as 6ths	Sum incs	Fraction				mins	mins	0..1		(20min)	(12ths)	mins	/max	mins
21	Apogee 09		16:58	0.30	17:33	0.32	18:05	0.36	12:40	1.76	13:17	1.77	13:58	1.76	14:44	1.74	1.4	-1.5	Mid	1.76	1.71						0	0.09115348193	-10	0	0.1736481777	1.041889066	0	0.000	1			-10..0..9	-10	0.00000
22			23:20	2.28	23:50	2.25	00:20	0.00	18:40	0.42	19:16	0.51	19:56	0.62	20:43	0.74	-1.1	-2.9	End	1.24	1.04						1	0.2706907934	10	0.1736481777	0.1683719657	1.010231794	0.1736481777	0.015	0.9396926208			10..20..29	10	0.00760	0..10..20	0.00760		0	0.08749	0..10..19
23																											2	0.442003302	30	0.3420201433	0.1579798567	0.94787914	0.515668321	0.045	0.7660444431			30..40..49	30	0.03015	20..30..40	0.02256		20	0.25981	20..30..39
24			Mon	12	Tue	13	Wed	14	Thu	15	Fri	16	Sat	17	Sun	18											3	0.599885764	50	0.5	0.1427876097	0.8567256581	1.015668321	0.089	0.5			50..60..69	50	0.06699		0.03683	0.80	40	0.42423
25	RNA Show		02:32	1.66	03:24	1.50	04:40	1.39	00:36	0.78	01:52	0.65	02:53	0.52	03:45	0.39											4	0.7395410006	70	0.6427876097	0.1232568334	0.7395410006	1.658455931	0.145	0.1736481777			70..80..89	70	0.11698		0.04999		60	0.57577
26			09:01	0.45	09:52	0.50	11:00	0.52	06:03	1.39	07:12	1.46	08:12	1.56	09:05	1.68	1.0	-1.0	Start	0.28	0.30			0.50	1.12		5	0.8567256581	90	0.7660444431	0.09998096067	0.599885764	2.424500374	0.212	-0.1736481777	30	0.045	90..100..109	90	0.17861		0.06163		80	0.70981
27			15:41	1.73	16:50	1.77	18:05	1.86	12:13	0.47	13:17	0.38	14:16	0.28	15:11	0.18	-1.3	1.6	Mid								6	0.94787914	110	0.8660254038	0.073667217	0.442003302	3.290525778	0.288	-0.5			110.120.129	110	0.25000		0.07139	2.20	100	0.82228
28			21:43	0.83	23:05	0.86	00:20	0.00	19:11	2.00	20:08	2.15	20:59	2.30	21:45	2.42	2.0	4.5	End	1.03	1.20						7	1.010231794	130	0.9396926208	0.04511513223	0.2706907934	4.230218398	0.370	-0.7660444431			130..140..149	130	0.32899	120..130..140	0.07899		120	0.90977	120..130..139
29																											8	1.041889066	150	0.984807753	0.01519224699	0.09115348193	5.215026151	0.456	-0.9396926208			150..160..169	150	0.41318		0.08419		140	0.96962
30			Mon	19	Tue	20	Wed	21	Thu	22	Fri	23	Sat	24	Sun	25											9	1.041889066	170	1			6.215026151	0.544	-1			170..180..189	170	0.50000		0.08682	3.00	160	1.00000
31			04:32	0.29	05:16	0.21	05:57	0.15	06:36	0.13	00:34	2.34	01:13	2.15	01:56	1.92											10	1.010231794	190	0.984807753	1	6	7.199833904	0.630	-0.9396926208			190..200..209	190	0.58682		0.08682		180	1.00000
32			09:55	1.79	10:44	1.88	11:31	1.97	12:18	2.03	07:12	0.15	07:47	0.19	08:23	0.25	-2.0	0.5	Start					1.80			11	0.94787914	210	0.9396926208	^^^ Check totals ^^^		8.139526525	0.712	-0.7660444431			210..220.229	210	0.67101		0.08419		200	0.96962
33			16:05	0.10	16:55	0.05	17:43	0.06	18:29	0.13	13:04	2.06	13:52	2.06	14:46	2.04	1.9	-2.2	Mid	2.06	1.99			1.81			12	0.8567256581	230	0.8660254038			9.005551929	0.788	-0.5			230..240..249	230	0.75000		0.07899	3.00	220	0.90977
34	Working bee - low tide early?		22:30	2.49	23:12	2.52	23:53	2.47	00:20	0.00	19:16	0.25	20:05	0.41	21:03	0.57	-1.7	-4.2	End	1.31	1.02						13	0.7395410006	250	0.7660444431			9.771596372	0.855	-0.1736481777			250..260..269	250	0.82139		0.07139		240	0.82228
35																											14	0.599885764	270	0.6427876097			10.41438398	0.911	0.1736481777			270..280..289	270	0.88302		0.06163		260	0.70981
36	September		Mon	26	Tue	27	Wed	28	Thu	29	Fri	30	Sat	31	Sun	1											15	0.442003302	290	0.5			10.91438398	0.955	0.5			290..300.309	290	0.93301		0.04999	2.20	280	0.57577
37			02:46	1.67	03:54	1.45	05:25	1.35	01:23	0.62	02:26	0.50	03:12	0.41	03:51	0.36											16	0.2706907934	310	0.3420201433			11.25640413	0.985	0.7660444431			310..320..329	310	0.96985		0.03683		300	0.42423
38	Perigee 31		09:07	0.33	10:05	0.42	11:19	0.48	06:52	1.38	07:58	1.48	08:49	1.59	09:29	1.67	1.2	-2.2	Start	0.37	0.35			0.42	1.08		17	0.09115348193	330	0.1736481777			11.4300523	1.000	0.9396926208			330..340..349	330	0.99240		0.02256		320	0.25981
39			15:50	2.01	17:05	2.01	18:22	2.04	12:36	0.47	13:45	0.42	14:40	0.35	15:26	0.31	-1.2	0.5	Mid								18	0	350	0			11.4300523	1.000	1			350..360..369	350	1.00000		0.00760	0.80	340	0.08749
40	Working bee - low tide late?		22:17	0.69	23:54	0.71	00:20	0.00	19:29	2.11	20:22	2.17	21:06	2.21	21:45	2.23	1.9	3.3	End	0.89	1.04						19	0.09115348193	370	-0.1736481777			11.25640413	0.985	0.9396926208			370..380..389	370	0.99240		-0.00760		360	-0.08749
41																											20	0.2706907934	390	-0.3420201433	12	Check all	10.91438398	0.955				390..400..409	390	0.96985		-0.02256		380	-0.25981
42			Mon	2	Tue	3	Wed	4	Thu	5	Fri	6	Sat	7	Sun	8											21	100000	410	100000	3	Check 3						Out of range	410	100000
43	Race day 1		04:26	0.34	04:57	0.32	05:25	0.31	05:50	0.29	06:15	0.27	06:39	0.28	00:41	1.86											22	100000	430	100000	2.196152423	Check 2						Out of range	430	100000
44			10:05	1.74	10:37	1.79	11:08	1.84	11:39	1.88	12:11	1.91	12:46	1.91	07:05	0.31	1.6	-1.9		1.71	1.61			1.72			23	100000	450	100000	0.8038475773	Check 1						Out of range	450	100000
45	Apogee 05	Medium ebb	16:06	0.28	16:42	0.29	17:16	0.31	17:48	0.35	18:20	0.42	18:55	0.51	13:22	1.89	-1.4	-3.6		0.81	0.71	4.1	1.75	1.65	-1.5	#REF!	24	100000	470	100000								Out of range	470	100000
46			22:20	2.22	22:50	2.20	23:19	2.16	23:46	2.09	00:13	1.99	00:20	0.00	19:32	0.61		-4.4				1.3	1.78				Scale:	3
47																						-4.0	0.98
48			Mon	9	Tue	10	Wed	11	Thu	12	Fri	13	Sat	14	Sun	15											Tide intervals:		Check!	Min & max:
49	Race day 2		01:12	1.71	01:50	1.55	02:41	1.40	04:06	1.31	05:43	1.34	01:30	0.59	02:29	0.43											(Times	01:10:00	1.0486	0.43	1.71
50	School hol Sat		07:35	0.36	08:09	0.43	08:58	0.51	10:11	0.56	11:39	0.52	06:57	1.48	07:56	1.64	0.9							0.72	1.62		are in	05:27:00	0.2271	0.36	1.64
51		Bad flood	14:03	1.86	14:53	1.82	16:01	1.81	17:22	1.86	18:36	2.00	12:52	0.41	13:57	0.28	-1.1	2.3		0.57	0.66	-4.1	0.57				days)	05:55:00	0.2465	0.28	2.00
52			20:15	0.71	21:11	0.79	22:33	0.82	00:13	0.74	00:20	0.00	19:37	2.16	20:30	2.30	1.8	4.5		1.51	1.79	-0.4	0.37					06:45:00	0.2813	0.00	2.30
53																		5.5				6.1	1.20
54			Mon	16	Tue	17	Wed	18	Thu	19	Fri	20	Sat	21	Sun	22
55	Race day 3		03:19	0.29	04:04	0.18	04:46	0.10	05:25	0.06	06:01	0.06	06:35	0.09	00:49	1.92								1.90				06:28:00	0.2694	0.06	1.92
56	School hol		08:49	1.79	09:37	1.93	10:25	2.05	11:11	2.16	11:56	2.23	12:42	2.25	07:08	0.16	2.2	-2.6		1.97	1.84			0.76				06:07:00	0.2549	0.16	2.25
57	Perigee 18	Bad ebb	14:56	0.16	15:51	0.08	16:42	0.05	17:31	0.08	18:19	0.17	19:06	0.30	13:30	2.22	-2.0	-5.5		0.86	0.58	5.3	2.04					06:24:00	0.2667	0.05	2.22
58		Mud late	21:18	2.40	22:03	2.44	22:45	2.41	23:27	2.31	00:07	2.13	00:20	0.00	19:57	0.45	-0.3	-6.1				1.7	2.06					05:14:00	-0.7819	0.00	2.44
59																						-5.5	1.11
60	October		Mon	23	Tue	24	Wed	25	Thu	26	Fri	27	Sat	28	Sun	29
61	Race day 4		01:34	1.68	02:28	1.46	03:48	1.30	05:25	1.29	01:04	0.57	01:58	0.46	02:39	0.38								1.46				06:58:00	0.2903	0.38	1.68
62	School hol		07:45	0.27	08:29	0.40	09:30	0.53	10:57	0.61	06:44	1.40	07:42	1.54	08:26	1.67	1.1							1.71				05:44:00	0.2389	0.27	1.67
63		Good flood	14:21	2.15	15:23	2.06	16:37	1.99	17:54	1.99	12:23	0.57	13:29	0.49	14:20	0.41	-1.1	0.4	Start	0.51	0.63	-3.9	0.77					05:47:00	0.2410	0.41	2.15
64		Mud start	20:57	0.60	22:18	0.68	23:50	0.66	00:20	0.00	19:00	2.02	19:52	2.07	20:35	2.11	1.6	2.8	Mid			-1.0	0.41					06:23:00	0.2660	0.00	2.11
65																		4.8	End	1.35	1.62	4.8	1.19
66			Mon	30	Tue	1	Wed	2	Thu	3	Fri	4	Sat	5	Sun	6
67	Race day 5		03:15	0.32	03:48	0.28	04:17	0.25	04:44	0.22	05:10	0.20	05:35	0.20	06:01	0.23								1.84				06:23:00	0.2660	0.20	0.32
68			09:04	1.78	09:38	1.86	10:10	1.93	10:42	1.99	11:14	2.04	11:46	2.06	12:19	2.06	1.9	-4.1		1.60	1.33			0.90				06:11:00	0.2576	1.78	2.06
69	Apogee 02	Bad ebb	15:05	0.35	15:44	0.33	16:20	0.33	16:56	0.35	17:31	0.39	18:05	0.45	18:39	0.53	-1.6	-5.0				0.0	2.04					06:19:00	0.2632	0.33	0.53
70		Mud finish	21:13	2.12	21:46	2.11	22:17	2.08	22:45	2.02	23:12	1.94	23:41	1.83	00:11	1.72	1.4	-4.1		0.65	0.57	-3.4	1.61					05:36:00	0.2333	1.72	2.12
71																						-3.9	0.78
72			Mon	7	Tue	8	Wed	9	Thu	10	Fri	11	Sat	12	Sun	13
73	Race day 6		06:27	0.28	00:45	1.59	01:25	1.47	02:23	1.36	03:51	1.32	05:25	1.40	00:57	0.50												05:39:00	0.2354	0.28	1.59
74	Champ day 1		12:53	2.03	06:56	0.35	07:33	0.43	08:24	0.51	09:39	0.57	11:10	0.54	06:36	1.57	-0.9	4.6		1.23	1.36			1.09				05:45:00	0.2396	0.35	2.03
75	King's b'day	Bad flood	19:16	0.61	13:33	1.98	14:21	1.93	15:25	1.91	16:44	1.94	17:58	2.05	12:28	0.43	1.5	4.6				-2.1	0.43	1.92				06:48:00	0.2833	0.43	2.05
76			00:20	0.00	19:58	0.68	20:54	0.74	22:15	0.74	23:46	0.65	00:20	0.00	19:01	2.17	-2.1	2.7		1.98	2.03	3.9	0.93					06:22:00	0.2653	0.00	2.17
77																						4.9	1.80
78			Mon	14	Tue	15	Wed	16	Thu	17	Fri	18	Sat	19	Sun	20
79	Race day 7		01:54	0.35	02:44	0.22	03:29	0.12	04:10	0.05	04:48	0.03	05:24	0.04	05:59	0.10								0.22				06:24:00	0.2667	0.03	0.35
80			07:35	1.75	08:27	1.93	09:17	2.09	10:04	2.23	10:50	2.34	11:35	2.40	12:21	2.39	2.4	-6.1		1.60	1.42	1.9	2.36	0.46				06:11:00	0.2576	1.75	2.40
81	Perigee 17	2nd worst ebb!	13:35	0.31	14:37	0.21	15:35	0.16	16:28	0.14	17:19	0.17	18:08	0.25	18:59	0.36	-2.2	-6.7			0.71	-4.5	1.81					06:33:00	0.2729	0.14	0.36
82		Mud finish	19:55	2.26	20:45	2.30	21:31	2.28	22:16	2.20	23:00	2.06	23:44	1.89	00:20	0.00	1.6	-5.5		0.49	0.40	-5.8	0.65					05:36:00	0.2333	0.00	2.30
83
84			Mon	21	Tue	22	Wed	23	Thu	24	Fri	25	Sat	26	Sun	27
85	Race day 8		00:29	1.70	01:19	1.52	02:18	1.38	03:35	1.30	05:02	1.33	00:20	0.55	01:11	0.47								1.52				00:00:00	1.0000	0.47	1.70
86			06:34	0.19	07:12	0.32	07:57	0.47	08:59	0.61	10:26	0.69	06:14	1.45	07:09	1.60	0.9	3.3	Start	1.03	1.14			2.13				05:54:00	0.2458	0.19	1.60
87		Medium flood	13:08	2.33	13:59	2.22	14:55	2.10	16:00	2.00	17:10	1.95	11:51	0.66	12:57	0.59	-0.8	4.0	Mid			-2.6	0.64					05:37:00	0.2340	0.59	2.33
88	LTS1	Mud finish	19:52	0.48	20:53	0.58	22:06	0.63	23:18	0.62	00:20	0.00	18:13	1.95	19:07	1.97	1.3	3.7	End	1.84	1.89	1.8	0.88					06:22:00	0.2653	0.00	1.97
89																						4.2	1.68
90	November		Mon	28	Tue	29	Wed	30	Thu	31	Fri	1	Sat	2	Sun	3
91	Race day 9		01:53	0.39	02:30	0.31	03:03	0.25	03:34	0.20	04:03	0.17	04:31	0.17	05:00	0.19								0.31				06:19:00	0.2632	0.17	0.39
92			07:54	1.74	08:33	1.87	09:09	1.98	09:43	2.07	10:17	2.13	10:50	2.18	11:24	2.19	2.0					-0.5	2.11	0.66				06:19:00	0.2632	1.74	2.19
93	Apogee 29	Bad ebb	13:50	0.52	14:35	0.46	15:18	0.43	15:58	0.41	16:37	0.42	17:15	0.45	17:52	0.49	-1.7	-5.4	Start	1.24	1.09	-5.2	1.27					06:25:00	0.2674	0.41	0.52
94	LTS2	Mud end	19:51	1.98	20:31	1.98	21:06	1.96	21:40	1.91	22:12	1.85	22:44	1.78	23:16	1.70	1.3	-5.4	Mid		0.60	-3.1	0.52					05:29:00	0.2285	1.70	1.98
95																		-2.3	End	0.45	0.45
96			Mon	4	Tue	5	Wed	6	Thu	7	Fri	8	Sat	9	Sun	10
97	Race day 10		05:29	0.22	05:58	0.28	00:30	1.55	01:17	1.47	02:19	1.42	03:37	1.42	04:59	1.52								1.61				05:36:00	0.2333	0.22	1.55
98	Champ day 2		11:58	2.18	12:35	2.15	06:32	0.34	07:14	0.41	08:08	0.48	09:20	0.54	10:42	0.53	-0.9	3.4		1.75	1.93	1.3	0.76	2.13				05:43:00	0.2382	0.34	2.18
99		Very good flood	18:30	0.54	19:09	0.60	13:15	2.11	14:04	2.08	15:03	2.06	16:10	2.07	17:18	2.11	1.5	1.2				4.9	1.53					06:50:00	0.2847	0.54	2.11
100	LTS3		23:51	1.62	00:20	0.00	19:55	0.64	20:51	0.66	22:01	0.63	23:12	0.54	00:16	0.42	-1.5	0.4		2.05	1.93	1.3	2.11					07:02:00	0.2931	0.00	1.62