Logical "or" (Vertical bar). Filter the column for content that matches text from either side of the bar
2
&& or AND
Logical "and". Filter the column for content that matches text from either side of the operator.
3
/\d/
Add any regex to the query to use in the query ("mig" flags can be included /\w/mig)
4
< <= >= >
Find alphabetical or numerical values less than or greater than or equal to the filtered query
5
! or !=
Not operator, or not exactly match. Filter the column with content that do not match the query. Include an equal (=), single (') or double quote (") to exactly not match a filter.
6
" or =
To exactly match the search query, add a quote, apostrophe or equal sign to the beginning and/or end of the query
7
- or to
Find a range of values. Make sure there is a space before and after the dash (or the word "to")
8
?
Wildcard for a single, non-space character.
8
*
Wildcard for zero or more non-space characters.
9
~
Perform a fuzzy search (matches sequential characters) by adding a tilde to the beginning of the query
10
text
Any text entered in the filter will match text found within the column
Logical "or" (Vertical bar). Filter the column for content that matches text from either side of the bar
2
&& or AND
Logical "and". Filter the column for content that matches text from either side of the operator.
3
/\d/
Add any regex to the query to use in the query ("mig" flags can be included /\w/mig)
4
< <= >= >
Find alphabetical or numerical values less than or greater than or equal to the filtered query
5
! or !=
Not operator, or not exactly match. Filter the column with content that do not match the query. Include an equal (=), single (') or double quote (") to exactly not match a filter.
6
" or =
To exactly match the search query, add a quote, apostrophe or equal sign to the beginning and/or end of the query
7
- or to
Find a range of values. Make sure there is a space before and after the dash (or the word "to")
8
?
Wildcard for a single, non-space character.
8
*
Wildcard for zero or more non-space characters.
9
~
Perform a fuzzy search (matches sequential characters) by adding a tilde to the beginning of the query
10
text
Any text entered in the filter will match text found within the column
Logical "or" (Vertical bar). Filter the column for content that matches text from either side of the bar
2
&& or AND
Logical "and". Filter the column for content that matches text from either side of the operator.
3
/\d/
Add any regex to the query to use in the query ("mig" flags can be included /\w/mig)
4
< <= >= >
Find alphabetical or numerical values less than or greater than or equal to the filtered query
5
! or !=
Not operator, or not exactly match. Filter the column with content that do not match the query. Include an equal (=), single (') or double quote (") to exactly not match a filter.
6
" or =
To exactly match the search query, add a quote, apostrophe or equal sign to the beginning and/or end of the query
7
- or to
Find a range of values. Make sure there is a space before and after the dash (or the word "to")
8
?
Wildcard for a single, non-space character.
8
*
Wildcard for zero or more non-space characters.
9
~
Perform a fuzzy search (matches sequential characters) by adding a tilde to the beginning of the query
10
text
Any text entered in the filter will match text found within the column
Logical "or" (Vertical bar). Filter the column for content that matches text from either side of the bar
2
&& or AND
Logical "and". Filter the column for content that matches text from either side of the operator.
3
/\d/
Add any regex to the query to use in the query ("mig" flags can be included /\w/mig)
4
< <= >= >
Find alphabetical or numerical values less than or greater than or equal to the filtered query
5
! or !=
Not operator, or not exactly match. Filter the column with content that do not match the query. Include an equal (=), single (') or double quote (") to exactly not match a filter.
6
" or =
To exactly match the search query, add a quote, apostrophe or equal sign to the beginning and/or end of the query
7
- or to
Find a range of values. Make sure there is a space before and after the dash (or the word "to")
8
?
Wildcard for a single, non-space character.
8
*
Wildcard for zero or more non-space characters.
9
~
Perform a fuzzy search (matches sequential characters) by adding a tilde to the beginning of the query
10
text
Any text entered in the filter will match text found within the column
Logical "or" (Vertical bar). Filter the column for content that matches text from either side of the bar
2
&& or AND
Logical "and". Filter the column for content that matches text from either side of the operator.
3
/\d/
Add any regex to the query to use in the query ("mig" flags can be included /\w/mig)
4
< <= >= >
Find alphabetical or numerical values less than or greater than or equal to the filtered query
5
! or !=
Not operator, or not exactly match. Filter the column with content that do not match the query. Include an equal (=), single (') or double quote (") to exactly not match a filter.
6
" or =
To exactly match the search query, add a quote, apostrophe or equal sign to the beginning and/or end of the query
7
- or to
Find a range of values. Make sure there is a space before and after the dash (or the word "to")
8
?
Wildcard for a single, non-space character.
8
*
Wildcard for zero or more non-space characters.
9
~
Perform a fuzzy search (matches sequential characters) by adding a tilde to the beginning of the query
10
text
Any text entered in the filter will match text found within the column
Oliver Ekman-Larsson, Jay Bouwmeester, Olli Maatta
Olli Maatta
Oliver Ekman-Larsson, Seth Jones
Tirs de Pénalité
Anthony Duclair, Vladimir Tarasenko, Tomas Plekanec, Sami Vatanen, Seth Jones
Gardien
#1 : Carey Price, #2 : Karri Ramo
Lignes d'Attaque Perso. en Prol.
, , , , , , , , , ,
Lignes de Défense Perso. en Prol.
, , , ,
Astuces sur les Filtres (Anglais seulement)
Priority
Type
Description
1
| or OR
Logical "or" (Vertical bar). Filter the column for content that matches text from either side of the bar
2
&& or AND
Logical "and". Filter the column for content that matches text from either side of the operator.
3
/\d/
Add any regex to the query to use in the query ("mig" flags can be included /\w/mig)
4
< <= >= >
Find alphabetical or numerical values less than or greater than or equal to the filtered query
5
! or !=
Not operator, or not exactly match. Filter the column with content that do not match the query. Include an equal (=), single (') or double quote (") to exactly not match a filter.
6
" or =
To exactly match the search query, add a quote, apostrophe or equal sign to the beginning and/or end of the query
7
- or to
Find a range of values. Make sure there is a space before and after the dash (or the word "to")
8
?
Wildcard for a single, non-space character.
8
*
Wildcard for zero or more non-space characters.
9
~
Perform a fuzzy search (matches sequential characters) by adding a tilde to the beginning of the query
10
text
Any text entered in the filter will match text found within the column
Logical "or" (Vertical bar). Filter the column for content that matches text from either side of the bar
2
&& or AND
Logical "and". Filter the column for content that matches text from either side of the operator.
3
/\d/
Add any regex to the query to use in the query ("mig" flags can be included /\w/mig)
4
< <= >= >
Find alphabetical or numerical values less than or greater than or equal to the filtered query
5
! or !=
Not operator, or not exactly match. Filter the column with content that do not match the query. Include an equal (=), single (') or double quote (") to exactly not match a filter.
6
" or =
To exactly match the search query, add a quote, apostrophe or equal sign to the beginning and/or end of the query
7
- or to
Find a range of values. Make sure there is a space before and after the dash (or the word "to")
8
?
Wildcard for a single, non-space character.
8
*
Wildcard for zero or more non-space characters.
9
~
Perform a fuzzy search (matches sequential characters) by adding a tilde to the beginning of the query
10
text
Any text entered in the filter will match text found within the column
Capacité de l'Aréna - Tendance du Prix des Billets - %
Niveau 1
Niveau 2
Niveau 3
Niveau 4
Luxe
Capacité de l'Aréna
6000
5000
2500
4000
1000
Prix des Billets
140
80
50
30
250
Assistance
205616
174735
99379
162066
41000
Attendance PCT
83.58%
85.24%
96.96%
98.82%
100.00%
Revenus
Matchs à domicile Restants
Assistance Moyenne - %
Revenus Moyen par Match
Revenus Annuels à ce Jour
Capacité de l'Aréna
Popularité de l'Équipe
0
16654 - 90.02%
1,532,829$
62,845,970$
18500
100
Dépenses
Salaire Total des Joueurs
Salaire Total Moyen des Joueurs
Salaire des Coachs
Valeur du Cap Salarial Spécial
55,358,000$
54,531,333$
0$
0$
Dépenses Annuelles à Ce Jour
Cap Salarial Par Jour
Cap salarial à ce jour
Taxe de Luxe Totale
53,483,979$
305,845$
52,981,219$
0$
Éstimation
Revenus de la Saison Éstimés
Jours Restants de la Saison
Dépenses Par Jour
Dépenses de la Saison Éstimées
0$
0
308,608$
0$
Total de l'Équipe Éstimé
Dépenses de la Saison Éstimées
Cap Salarial de la Saison Éstimé
Compte Bancaire Actuel
Compte Bancaire Projeté
0$
55,957,798$
128,435,235$
128,435,235$
Charte de Profondeur
Ailier Gauche
Centre
Ailier Droit
Loui Eriksson
AGE:30
PO:0
OV:70
Carl Hagelin
AGE:27
PO:0
OV:66
Darren Helm
AGE:28
PO:0
OV:66
Gustav Nyquist
AGE:26
PO:0
OV:66
Antoine Roussel
AGE:25
PO:0
OV:63
Martin Erat
AGE:34
PO:0
OV:63
Anthony Duclair
AGE:20
PO:0
OV:60
Pierre-Edouard Bellemare
AGE:30
PO:0
OV:58
Cal O'Reilly
AGE:29
PO:0
OV:56
Tanner Glass
AGE:31
PO:0
OV:56
*Corban Knight
AGE:25
PO:0
OV:56
Lucas Lessio
AGE:22
PO:0
OV:54
Brandon Crombeen
AGE:30
PO:0
OV:52
Zach Sill
AGE:27
PO:0
OV:52
*Jakub Vrana
AGE:19
PO:0
OV:49
*Ivan Barbashev
AGE:19
PO:0
OV:45
Oscar Moller
AGE:26
PO:0
OV:42
*Nick Moutrey
AGE:20
PO:0
OV:42
Justin Florek
AGE:25
PO:0
OV:40
*Dmytro Timashov
AGE:19
PO:0
OV:39
David Krejci
AGE:29
PO:0
OV:71
Logan Couture
AGE:26
PO:0
OV:71
Tomas Plekanec
AGE:32
PO:0
OV:71
Darren Helm
AGE:28
PO:0
OV:66
Bo Horvat
AGE:20
PO:0
OV:62
Jay McClement
AGE:32
PO:0
OV:62
Pierre-Edouard Bellemare
AGE:30
PO:0
OV:58
Cal O'Reilly
AGE:29
PO:0
OV:56
*Corban Knight
AGE:25
PO:0
OV:56
Zach Sill
AGE:27
PO:0
OV:52
Colin White
AGE:18
PO:0
OV:49
*Ivan Barbashev
AGE:19
PO:0
OV:45
*Ryan Kujawinski
AGE:20
PO:0
OV:44
Kellan Lain
AGE:26
PO:0
OV:42
*Matt Buckles
AGE:20
PO:0
OV:42
*Nick Moutrey
AGE:20
PO:0
OV:42
Vladimir Tarasenko
AGE:23
PO:0
OV:72
Loui Eriksson
AGE:30
PO:0
OV:70
Shane Doan
AGE:38
PO:0
OV:70
Darren Helm
AGE:28
PO:0
OV:66
Gustav Nyquist
AGE:26
PO:0
OV:66
Martin Erat
AGE:34
PO:0
OV:63
Anthony Duclair
AGE:20
PO:0
OV:60
Steve Downie
AGE:28
PO:0
OV:58
Pierre-Edouard Bellemare
AGE:30
PO:0
OV:58
Tanner Glass
AGE:31
PO:0
OV:56
*Corban Knight
AGE:25
PO:0
OV:56
Lucas Lessio
AGE:22
PO:0
OV:54
Brandon Crombeen
AGE:30
PO:0
OV:52
Ryan Hartman
AGE:21
PO:0
OV:52
Colin White
AGE:18
PO:0
OV:49
*Jakub Vrana
AGE:19
PO:0
OV:49
Eriah Hayes
AGE:27
PO:0
OV:48
*Ryan Kujawinski
AGE:20
PO:0
OV:44
Oscar Moller
AGE:26
PO:0
OV:42
*Nick Moutrey
AGE:20
PO:0
OV:42
Défense #1
Défense #2
Gardien
Oliver Ekman-Larsson
AGE:24
PO:0
OV:71
Erik Johnson
AGE:27
PO:0
OV:69
Jay Bouwmeester
AGE:32
PO:0
OV:69
Sami Vatanen
AGE:24
PO:0
OV:67
Seth Jones
AGE:21
PO:0
OV:66
Olli Maatta
AGE:21
PO:0
OV:64
Nate Schmidt
AGE:24
PO:0
OV:60
Mark Fraser
AGE:29
PO:0
OV:58
Adam Clendening
AGE:22
PO:0
OV:55
*Slater Koekkoek
AGE:21
PO:0
OV:52
Erik Gustafsson
AGE:26
PO:0
OV:47
*Carl Dahlstrom
AGE:20
PO:0
OV:46
*Dominik Masin
AGE:19
PO:0
OV:46
*Niklas Hansson
AGE:20
PO:0
OV:43
*Mason Geertsen
AGE:20
PO:0
OV:42
*Anton Cederholm
AGE:20
PO:0
OV:40
*Teemu Kivihalme
AGE:20
PO:0
OV:38
Carey Price
AGE:28
PO:0
OV:83
Karri Ramo
AGE:29
PO:0
OV:61
Anders Nilsson
AGE:25
PO:0
OV:54
Joacim Eriksson
AGE:25
PO:0
OV:44
Konstantin Barulin
AGE:31
PO:0
OV:44
*Calvin Petersen
AGE:20
PO:0
OV:40
Éspoirs
Astuces sur les Filtres (Anglais seulement)
Priority
Type
Description
1
| or OR
Logical "or" (Vertical bar). Filter the column for content that matches text from either side of the bar
2
&& or AND
Logical "and". Filter the column for content that matches text from either side of the operator.
3
/\d/
Add any regex to the query to use in the query ("mig" flags can be included /\w/mig)
4
< <= >= >
Find alphabetical or numerical values less than or greater than or equal to the filtered query
5
! or !=
Not operator, or not exactly match. Filter the column with content that do not match the query. Include an equal (=), single (') or double quote (") to exactly not match a filter.
6
" or =
To exactly match the search query, add a quote, apostrophe or equal sign to the beginning and/or end of the query
7
- or to
Find a range of values. Make sure there is a space before and after the dash (or the word "to")
8
?
Wildcard for a single, non-space character.
8
*
Wildcard for zero or more non-space characters.
9
~
Perform a fuzzy search (matches sequential characters) by adding a tilde to the beginning of the query
10
text
Any text entered in the filter will match text found within the column
Éspoir
Nom de l'Équipe
Année de Repêchage
Choix Total
Information
Lien
Caleb Jones
Colorado
2016
92
Connor Hall
Colorado
2016
65
Connor Hobbs
Colorado
2016
201
Ethan Bear
Colorado
2016
73
Jesse Gabrielle
Colorado
2016
83
Jordan Kyrou
Colorado
2016
53
Linus Lindstrom
Colorado
2016
100
Tyler Parsons
Colorado
2016
32
Ziyat Paigin
Colorado
2016
111
Choix au Repêchage
Année
R1
R2
R3
R4
R5
R6
R7
2017
Col
Col
Col
2018
Col
Ana
Col
Col
Col
2019
Col
Col
Col
Col
Col
Col
Col
2020
Col
Col
Col
Col
Col
Col
Col
2021
Col
Col
Col
Col
Col
Col
Col
[2016-09-16 21:11:35] - Tanner Glass was added to Colorado. [2016-09-16 21:11:38] - Martin Erat was added to Colorado. [2016-10-02 22:26:46] - Seth Jones was added to Colorado. [2016-10-02 22:26:48] - TRADE : From Anaheim to Colorado : Seth Jones (65), Y:2017-RND:3-Ana, Y:2018-RND:2-Ana. [2016-10-02 22:26:48] - TRADE : From Colorado to Anaheim : Evgeni Malkin (73), Y:2018-RND:7-Col. [2016-10-22 20:00:21] - Unknown Player is no longer captain for Colorado. [2016-10-22 20:00:21] - David Krejci has been selected as captain for Colorado. [2016-10-22 20:00:21] - Unknown Player is no longer as assistant for Colorado. [2016-10-22 20:00:21] - Logan Couture has been selected as assistant for Colorado. [2016-11-12 12:10:29] - Shane Doan was added to Colorado. [2016-11-12 12:10:30] - TRADE : From Ottawa to Colorado : Shane Doan (69). [2016-11-12 12:10:30] - TRADE : From Colorado to Ottawa : Y:2018-RND:2-Col, Y:2017-RND:3-Col, Y:2018-RND:5-Col. [2016-11-19 20:00:22] - New Record for Team's Most Shots Blocked (16) in 1 Game for Colorado! [2017-01-08 20:00:12] - New Record for Team's Most Shots Blocked (17) in 1 Game for Colorado! [2017-01-28 08:50:41] - Tomas Plekanec was added to Colorado. [2017-01-28 08:50:42] - TRADE : From Caroline to Colorado : Tomas Plekanec (71). [2017-01-28 08:50:42] - TRADE : From Colorado to Caroline : Erik Haula (62), Y:2017-RND:3-Ana, Y:2017-RND:2-Col.