Advanced Fantasy Hockey Examples Spreadsheet.xlsx
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZ
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
GASOG
Shots Against
SavesSV%SOGEGASOG
Shots Against
SavesSV%SOGE
7
CConnor McDavid05739.7CSidney Crosby211442.76
8
CTyler Seguin161262.35CEvgeni Kuznetsov10213.11
9
LWJohnny Gaudreau20931.22LWBrandon Saad13535.73
10
LWArtemi Panarin121135.19LW
Gabreil Landeskog
01511.54
11
RWMitch Marner11825.65RWDavid Pastrnak311554.87
12
RWWayne Simmonds21735.76RWJakob Silferberg22540.3
13
DErik Karlsson031130.62DShea Weber301144.33
14
DJohn Klingberg02720.08DJohn Carlson01511.54
15
DKeith Yandle03524.62D
Rasmus Ristolainen
0088
16
DBrent Seabrook011117.54DMatt Niskanen02518.08
17
UtilRyan Getzlaf0139.54Util
James van Riemsdyk
01612.54
18
GBrayden Holtby56520.9285714286GBen Bishop51470.9215686275
19
GMarc-Andre Fleury43400.9302325581GAnders Nilsson43410.9534883721
20
Total:7259199920.9292929293332.27Total:12128194880.9361702128292.8
21
22
Total Stats:
Team ATeam B
23
24
SOG[shots on goal]9181
25
G[goals]712
26
A[assists]2512
27
28
SV%
[saves / shots against]
0.92929292930.9361702128
29
30
SOGE[shots on goal equivalent = SOG + 11.11G + 6.54A]332.27292.8
31
32
GE[Goals Equivalent = SOGE * (1 - OppSV%)]21.208723420.7030303
[Final Score]
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
Loading...
Main menu