HC 23/24 Predictor Assistant V1.3

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF	AK	AL	AN	AO	AP	AQ	AR	AS	AT	AU	AV	AW	AY	AZ	BA	BB	BC
1		Date	Fixture	W	D	L	B	W Prob	TEAM A	Tries	Score		Score	Tries	TEAM B													Spreadsheet magic by @RugbyKino
2	Rd 1	08/12/2023	A1.1	0	0	1	0	#REF!	Connacht	1	5	v	41	6	Bordeaux-Bègles	A	Team	P	W	D	L	F	A	Diff	B	Pts		Spreadsheet magic by @RugbyKino
3	Rd 1	08/12/2023	C1.1	0	0	1	0		Glasgow Warriors	3	19	v	28	3	Northampton Saints	1	Bordeaux-Bègles	4	3	0	1	172	83	89	5	17		Original layout by @JustinDeegan_
4	Rd 1	09/12/2023	C1.2	0	0	1	1		Toulon	2	18	v	19	3	Exeter Chiefs	2	Bulls	4	3	0	1	132	102	30	3	15		Original layout by @JustinDeegan_
5	Rd 1	09/12/2023	B1.1	1	0	0	1		Bath	5	37	v	14	2	Ulster	3	Lyon	4	2	0	2	121	123	-2	4	12		** V1.3 Release Version. Current results input already.
6	Rd 1	09/12/2023	B1.2	1	0	0	1		Toulouse	7	52	v	7	1	Cardiff	4	Saracens	4	2	0	2	125	142	-17	2	10		** SF seeding bug fixed
7	Rd 1	09/12/2023	A1.2	1	0	0	0		Bulls	3	27	v	16	2	Saracens	5	Connacht	4	1	0	3	88	140	-52	2	6
8	Rd 1	09/12/2023	C1.3	0	1	0	0		Munster	2	17	v	17	2	Bayonne	6	Bristol Bears	4	1	0	3	80	128	-48	1	5	👉	SAVE THIS TO YOUR OWN ACCOUNT BEFORE INPUTTING SCORES & BPs							👈
9	Rd 1	09/12/2023	A1.3	1	0	0	1		Bristol Bears	5	36	v	34	5	Lyon												👉	YOU WILL NOT BE ABLE TO EDIT THIS VERSION SO DON'T ASK FOR ACCESS!							👈
10	Rd 1	10/12/2023	D1.1	1	0	0	0		Sale Sharks	3	28	v	5	1	Stade Français	B	Team	P	W	D	L	F	A	Diff	B	Pts
11	Rd 1	10/12/2023	D1.2	0	0	1	1		La Rochelle	0	9	v	16	1	Leinster	1	Toulouse	4	4	0	0	178	69	109	4	20	AS IT STANDS
12	Rd 1	10/12/2023	D1.3	1	0	0	1		Leicester Tigers	4	35	v	26	2	Stormers	2	Harlequins	4	3	0	1	151	109	42	3	15	AS IT STANDS
13	Rd 1	10/12/2023	B1.3	0	0	1	2		Racing 92	4	28	v	31	4	Harlequins	3	Bath	4	3	0	1	124	102	22	3	15	ROUND OF 16
14	Rd 2	15/12/2023	C2.1	0	0	1	1		Bayonne	1	11	v	12	2	Glasgow Warriors	4	Racing 92	4	1	0	3	116	117	-1	4	8	GAME	Seeding	TEAM A	Score		Score	TEAM B	W Prob	Seeding	W	D	L
15	Rd 2	15/12/2023	C2.2	1	0	0	1		Northampton Saints	4	22	v	19	2	Toulon	5	Ulster	4	1	0	3	88	147	-59	1	5	RD16 1	1	Toulouse	31	v	7	Racing 92		16	0	0	1	QF1	Toulouse	1	Exeter Chiefs	8
16	Rd 2	16/12/2023	A2.1	1	0	0	1		Saracens	8	55	v	36	5	Connacht	6	Cardiff	4	0	0	4	80	193	-113	3	3	RD16 2	2	Leinster	36	v	22	Leicester Tigers		15	0	0	1	QF2	Leinster	2	La Rochelle	10
17	Rd 2	16/12/2023	D2.1	1	0	0	0		Stormers	2	21	v	20	2	La Rochelle												RD16 3	3	Northampton Saints	24	v	14	Munster		14	0	0	1	QF3	Northampton Saints	3	Bulls	6
18	Rd 2	16/12/2023	A2.2	1	0	0	1		Bordeaux-Bègles	5	36	v	17	2	Bristol Bears	C	Team	P	W	D	L	F	A	Diff	B	Pts	RD16 4	4	Bordeaux-Bègles	45	v	12	Saracens		13	0	0	1	QF4	Bordeaux-Bègles	4	Harlequins	5
19	Rd 2	16/12/2023	A2.3	1	0	0	1		Lyon	5	29	v	28	3	Bulls	1	Northampton Saints	4	4	0	0	137	75	62	2	18	RD16 5	5	Harlequins	28	v	24	Glasgow Warriors		12	0	0	1
20	Rd 2	16/12/2023	D2.2	1	0	0	1		Leinster	5	37	v	27	3	Sale Sharks	2	Exeter Chiefs	4	3	0	1	87	99	-12	1	13	RD16 6	6	Bulls	59	v	19	Lyon		11	0	0	1
21	Rd 2	16/12/2023	B2.1	0	0	1	2		Cardiff	4	32	v	39	5	Bath	3	Glasgow Warriors	4	2	0	2	77	63	14	2	10	RD16 7	7	Stormers	21	v	22	La Rochelle		10	1	0	0
22	Rd 2	16/12/2023	B2.2	1	0	0	1		Ulster	4	31	v	15	3	Racing 92	4	Munster	4	1	1	2	93	93	0	3	9	RD16 8	8	Exeter Chiefs	21	v	15	Bath		9	0	0	1
23	Rd 2	17/12/2023	C2.3	1	0	0	1		Exeter Chiefs	4	32	v	24	4	Munster	5	Bayonne	4	1	1	2	82	107	-25	2	8
24	Rd 2	17/12/2023	B2.3	0	0	1	0		Harlequins	3	19	v	47	7	Toulouse	6	Toulon	4	0	0	4	60	99	-39	2	2
25	Rd 2	17/12/2023	D2.3	0	0	1	1		Stade Français	3	24	v	27	3	Leicester Tigers													GAME	TEAM A	Score		Score	TEAM B	W Prob
26	Rd 3	12/01/2023	C3.1	1	0	0	1		Northampton Saints	9	61	v	14	2	Bayonne	D	Team	P	W	D	L	F	A	Diff	B	Pts		QF1	Toulouse		v		Exeter Chiefs	#N/A					SF1
27	Rd 3	13/01/2023	C3.2	1	0	0	0		Exeter Chiefs	3	19	v	17	2	Glasgow Warriors	1	Leinster	4	4	0	0	123	53	70	3	19		QF2	Leinster		v		La Rochelle	#N/A					SF2
28	Rd 3	13/01/2023	A3.1	1	0	0	1		Lyon	4	34	v	20	2	Connacht	2	Stormers	4	3	0	1	102	99	3	2	14		QF3	Northampton Saints		v		Bulls	#N/A
29	Rd 3	13/01/2023	A3.2	0	0	1	0		Bristol Bears	3	17	v	31	4	Bulls	3	La Rochelle	4	2	0	2	111	68	43	4	12		QF4	Bordeaux-Bègles		v		Harlequins	#N/A
30	Rd 3	13/01/2023	C3.3	0	0	1	0		Toulon	2	18	v	29	4	Munster	4	Leicester Tigers	4	2	0	2	84	122	-38	1	9
31	Rd 3	13/01/2023	D3.1	1	0	0	1		Leinster	7	43	v	7	1	Stade Français	5	Sale Sharks	4	1	0	3	98	110	-12	1	5		GAME	TEAM A	Score		Score	TEAM B	W Prob
32	Rd 3	13/01/2023	D3.2	1	0	0	1		Stormers	4	31	v	24	3	Sale Sharks	6	Stade Français	4	0	0	4	56	122	-66	2	2		SF1			v								FINAL
33	Rd 3	13/01/2023	B3.1	0	0	1	0		Cardiff	2	15	v	54	8	Harlequins													SF2			v
34	Rd 3	13/01/2023	B3.2	0	0	1	0		Ulster	3	24	v	48	7	Toulouse		HOW TO USE
35	Rd 3	14/01/2023	B3.3	1	0	0	1		Bath	4	29	v	25	3	Racing 92	*	Enter relevant scores (TEAM A in column K, TEAM B in column M)											GAME	TEAM A	Score		Score	TEAM B	W Prob
36	Rd 3	14/01/2023	D3.3	1	0	0	1		La Rochelle	7	45	v	12	2	Leicester Tigers	*	Enter the number of tries scored by each team											FINAL			v
37	Rd 3	14/01/2023	A3.3	1	0	0	1		Bordeaux-Bègles	9	55	v	15	2	Saracens		(TEAM A tries in column J, TEAM B's tries in column N)
38	Rd 4	19/01/2023	A4.1	1	0	0	1		Connacht	4	27	v	10	1	Bristol Bears	*	Tables update automatically and accordingly
39	Rd 4	19/01/2023	C4.1	1	0	0	1		Glasgow Warriors	5	29	v	5	1	Toulon	*	'As It Stands' updates automatically also											Once scores entered into relevant team's box
40	Rd 4	20/01/2023	A4.2	1	0	0	1		Bulls	6	46	v	40	6	Bordeaux-Bègles													next stage of games automatically updates
41	Rd 4	20/01/2023	B4.1	1	0	0	1		Harlequins	7	47	v	19	3	Ulster
42	Rd 4	20/01/2023	D4.1	0	0	1	0		Leicester Tigers	1	10	v	27	4	Leinster
43	Rd 4	20/01/2023	B4.2	1	0	0	1		Racing 92	7	48	v	26	4	Cardiff
44	Rd 4	20/01/2023	C4.2	0	0	1	1		Munster	3	23	v	26	2	Northampton Saints
45	Rd 4	20/01/2023	D4.2	0	0	1	1		Stade Français	3	20	v	24	4	Stormers
46	Rd 4	20/01/2023	A4.3	1	0	0	1		Saracens	5	39	v	24	3	Lyon
47	Rd 4	21/01/2023	D4.3	0	0	1	0		Sale Sharks	3	19	v	37	4	La Rochelle
48	Rd 4	21/01/2023	B4.3	1	0	0	1		Toulouse	5	31	v	19	2	Bath
49	Rd 4	21/01/2023	C4.3	1	0	0	1		Bayonne	6	40	v	17	3	Exeter Chiefs
50
51