Advanced Fantasy Hockey Examples Spreadsheet.xlsx

	A	B	C	D	E	F	G	H	I	K	L	M	N	O	P	Q	R	S
1	Simple Setup
2		Inputs: G, A, SOG, SA, SV
3		Assumptions: 9% league avg shooting percentage; 1.7 assist per goal
4		Inputs are hypothetical statistics accumulated during a given fantasy matchup period
5	Team A Roster:									Team B Roster:
6			G	A	SOG	Shots Against	Saves	SV%	SOGE			G	A	SOG	Shots Against	Saves	SV%	SOGE
7	C	Connor McDavid	0	5	7				39.7	C	Sidney Crosby	2	1	14				42.76
8	C	Tyler Seguin	1	6	12				62.35	C	Evgeni Kuznetsov	1	0	2				13.11
9	LW	Johnny Gaudreau	2	0	9				31.22	LW	Brandon Saad	1	3	5				35.73
10	LW	Artemi Panarin	1	2	11				35.19	LW	Gabreil Landeskog	0	1	5				11.54
11	RW	Mitch Marner	1	1	8				25.65	RW	David Pastrnak	3	1	15				54.87
12	RW	Wayne Simmonds	2	1	7				35.76	RW	Jakob Silferberg	2	2	5				40.3
13	D	Erik Karlsson	0	3	11				30.62	D	Shea Weber	3	0	11				44.33
14	D	John Klingberg	0	2	7				20.08	D	John Carlson	0	1	5				11.54
15	D	Keith Yandle	0	3	5				24.62	D	Rasmus Ristolainen	0	0	8				8
16	D	Brent Seabrook	0	1	11				17.54	D	Matt Niskanen	0	2	5				18.08
17	Util	Ryan Getzlaf	0	1	3				9.54	Util	James van Riemsdyk	0	1	6				12.54
18	G	Brayden Holtby				56	52	0.9285714286		G	Ben Bishop				51	47	0.9215686275
19	G	Marc-Andre Fleury				43	40	0.9302325581		G	Anders Nilsson				43	41	0.9534883721
20		Total:	7	25	91	99	92	0.9292929293	332.27		Total:	12	12	81	94	88	0.9361702128	292.8
21
22	Total Stats:		Team A		Team B
23
24	SOG	[shots on goal]	91		81
25	G	[goals]	7		12
26	A	[assists]	25		12
27
28	SV%	[saves / shots against]	0.9292929293		0.9361702128
29
30	SOGE	[shots on goal equivalent = SOG + 11.11G + 6.54A]	332.27		292.8
31
32	GE	[Goals Equivalent = SOGE * (1 - OppSV%)]	21.2087234		20.7030303	[Final Score]
33		[Goals Equivalent = SOGE * (1 - OppSV%)]
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