STL - Google Sheets

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S
1		Rel	Role	Name	Cap Hit	D.O.B.	GP	Waivers	Warning		DO NOT TOUCH RIGHT HAND SIDE OF SPREADSHEET - ONLY COLUMNS A THROUGH G SHOULD BE EDITED

2	C		C2	Antoine Vermette	$3,750,000	1982-07-20	670	Yes		1.00	Forwards
3	C		C4	Marcel Goc	$1,700,000	1983-08-24	488	Yes		1.00	Alexander Semin	$7,000,000	Tyler Bozak	$4,200,000	Phil Kessel	$5,400,000
4	C		B2	Jeff Halpern	$600,000	1976-05-03	907	Yes		1.00	Gabriel Landeskog	$3,575,000	Antoine Vermette	$3,750,000	Bobby Ryan	$5,100,000
5	C		M	Tim Brent		1984-03-10	207	No			Mattieu Perreault	$1,050,000	Olli Jokinen	$4,500,000	Mikkel Boedker	$2,550,000
6	C		M	Corey Locke		1984-05-08	9	No			Rob Klinkhammer	$625,000	Marcel Goc	$1,700,000	Chris Neil	$1,900,000
7	C		M	Perttu Lindgren		1987-08-26	1	No
8	C		C1	Tyler Bozak	$4,200,000	1986-03-19	249	Yes		1.00	Defense
9	C		C3	Olli Jokinen	$4,500,000	1978-12-05	1116	Yes		1.00	Dan Girardi	$3,325,000	Kevin Shattenkirk	$4,250,000
10	C		W5	Mattieu Perreault	$1,050,000	1988-01-05	207	Yes		1.00	P.K. Subban	$2,875,000	Jeff Petry	$1,750,000
11	W		W1	Alexander Semin	$7,000,000	1984-03-03	513	Yes		1.00	Francis Bouillon	$1,500,000	Dalton Prout	$666,667
12	W		W4	Bobby Ryan	$5,100,000	1987-03-17	378	Yes		1.00
13	W		M	Sebastian Wannstrom		1991-03-03	0	No			Goalie
14	W		W6	Mikkel Boedker	$2,550,000	1989-12-16	311	Yes		1.00	Darcy Kuemper	$776,667
15	W		W7	Rob Klinkhammer	$625,000	1986-08-12	84	No		1.00	Josh Harding	$1,900,000			Spent before relief:	$64,047,501
16	W		W8	Chris Neil	$1,900,000	1983-04-01	590	Yes		1.00					LTIR Relief:	$0
17	W		W3	Gabriel Landeskog	$3,575,000	1992-11-23	118	No		1.00	Bench				Total Spent:	$64,047,501
18	W		M	Scott Glennie	$1,620,000	1991-02-22	1	No		1.00	Hal Gill	$700,000			Cap Space:	$252,499
19	W		W2	Phil Kessel	$5,400,000	1987-10-02	561	Yes		1.00	Jeff Halpern	$600,000			Space from Floor:	$20,047,501
20	W		M	Marek Tvrdon	$925,000	1993-01-31	0	No		1.00	George Parros	$937,500
21	W		M	Kirill Kabanov	$898,889	1992-07-16	0	No		1.00					Total Contracts (/50):	39
22	W		M	Nikita Kucherov	$894,167	1993-06-17	0	No		1.00	Short Term IR				Total Players (/90):	53
23	W		M	J.T. Brown	$874,125	1990-07-02	5	No		1.00
24	W		M	Yannick Veilleux	$833,333	1993-02-22	0	No		1.00
25	W		M	Darren Archibald	$660,000	1990-02-09	0	No		1.00
26	W		M	Troy Bodie	$600,000	1985-01-25	107	No		1.00
27	W		M	Andrew Gordon	$550,000	1985-12-13	55	No		1.00
28	W		M	Henrik Bjorklund	$546,389	1990-09-22	0	No		1.00
29	W		M	Alexander Radulov		1986-07-05	154	No			Long Term IR		Cap Relief 1		Cap Relief 2		Cap Relief 3		Space
30	W		M	Ben Eager	$1,100,000	1984-01-22	400	Yes	!!!	1.00	Niklas Backstrom	$3,416,667		0		0		0	$3,416,667
31	W		B3	George Parros	$937,500	1979-12-29	461	Yes		1.00				0		0		0	$0
32	W		M	Juuso Puustinen		1988-04-05	0	No						0		0		0	$0
33	W		D4	Jeff Petry	$1,750,000	1987-12-09	175	Yes		1.00				0		0		0	$0
34	D		D2	Kevin Shattenkirk	$4,250,000	1989-01-29	201	Yes		1.00				0		0		0	$0
35	D		D1	Dan Girardi	$3,325,000	1984-04-29	488	Yes		1.00
36	D		D3	P.K. Subban	$2,875,000	1989-05-13	202	Yes		1.00
37	D		D5	Francis Bouillon	$1,500,000	1975-10-17	724	Yes		1.00
38	D		D6	Dalton Prout	$666,667	1990-03-13	33	No		1.00
39	D		M	Yannick Weber	$650,000	1988-09-23	117	No		1.00
40	D		B1	Hal Gill	$700,000	1975-04-06	1102	Yes		1.00
41	D		M	Jim Vandermeer		1980-02-21	461	No
42	D		M	Jonas Holos		1987-08-27	39	No
43	D		M	Stephen Silas		1992-06-26	0	No
44	D		M	Brennan Serville		1993-06-02	0	No
45	D		M	Nick Ebert		1994-05-11	263	No
46	D		M	Ian Cole	$825,000	1989-02-21	75	No		1.00
47	D		M	Nate Prosser	$825,000	1986-05-07	83	No		1.00
48	D		M	Maxime Fortunas	$575,000	1983-07-28	9	Yes	!!!	1.00
49	D		G1	Darcy Kuemper	$776,667	1990-05-05	19	No		1.00
50	G		G2	Josh Harding	$1,900,000	1984-06-18	151	Yes		1.00
51	G		M	Dennis Endras		1985-07-14	0	No
52	G		LTIR1	Niklas Backstrom	$3,416,667	1978-02-13	390	Yes		1.00
53	G		M	Stephen Michalek		1993-08-06	0	No
54	G		M	Oscar Dansk		1994-02-28	0	No
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