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
#
Nom du Joueur
Nom de l'Équipe
POS
GP
G
A
P
+/-
PIM
PIM5
HIT
HTT
SHT
OSB
OSM
SHT%
SB
MP
AMG
PPG
PPA
PPP
PPS
PPM
PKG
PKA
PKP
PKS
PKM
GW
GT
FO%
FOT
GA
TA
EG
HT
P/20
PSG
PSS
FW
FL
FT
S1
S2
S3
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
#
Nom du Gardien
Nom de l'Équipe
GP
W
L
OTL
PCT
GAA
MP
PIM
SO
GA
SA
SAR
A
EG
PS %
PSA
ST
BG
S1
S2
S3
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
Adam Henrique, Evander Kane, Tobias Rieder, Alexandre Burrows, Nikolay Kulemin
Gardien
#1 : Jaroslav Halak, #2 : Kari Lehtonen
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
Jour
Match
Équipe Visiteuse
Score
Équipe Locale
Score
ST
OT
SO
RI
Lien
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
3500
2000
1500
Prix des Billets
93
81
69
52
115
Assistance
0.00%
0.00%
0.00%
0.00%
0.00%
Attendance PCT
0.00%
0.00%
0.00%
0.00%
0.00%
Revenus
Matchs à domicile Restants
Assistance Moyenne - %
Revenus Moyen par Match
Revenus Annuels à ce Jour
Capacité de l'Aréna
Popularité de l'Équipe
41
0 - 0.00%
0$
0$
18000
100
Dépenses
Salaire Total des Joueurs
Salaire Total Moyen des Joueurs
Salaire des Coachs
Valeur du Cap Salarial Spécial
49,922,333$
0$
0$
0$
Dépenses Annuelles à Ce Jour
Cap Salarial Par Jour
Cap salarial à ce jour
Taxe de Luxe Totale
0$
0$
0$
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
0$
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$
0$
48,534,602$
48,534,602$
Charte de Profondeur
Ailier Gauche
Centre
Ailier Droit
Evander Kane
AGE:25
PO:73
OV:78
Alexandre Burrows
AGE:35
PO:64
OV:77
Nikolay Kulemin
AGE:30
PO:30
OV:74
*Johan Larsson
AGE:24
PO:65
OV:72
Chris Bourque
AGE:30
PO:31
OV:68
Tanner Glass
AGE:33
PO:1
OV:67
*Jacob De La Rose
AGE:21
PO:87
OV:64
*Daniel O'Regan
AGE:24
PO:79
OV:57
Adam Henrique
AGE:28
PO:68
OV:82
*Sam Reinhart
AGE:21
PO:87
OV:75
Zack Smith
AGE:28
PO:35
OV:75
Alexander Burmistrov
AGE:25
PO:72
OV:72
Ryan Potulny
AGE:32
PO:63
OV:72
Matt Hendricks
AGE:35
PO:1
OV:70
*Scott Laughton
AGE:22
PO:53
OV:65
*Stephen Gionta
AGE:33
PO:1
OV:65
Joel Ward
AGE:36
PO:1
OV:79
Tobias Rieder
AGE:23
PO:54
OV:77
Kevin Hayes
AGE:24
PO:63
OV:74
*Markus Granlund
AGE:23
PO:71
OV:70
*Matt Puempel
AGE:23
PO:71
OV:67
Drew Miller
AGE:32
PO:1
OV:67
Jordin Tootoo
AGE:33
PO:1
OV:65
*Brock Boeser
AGE:21
PO:95
OV:59
*Jordan Szwarz
AGE:25
PO:51
OV:57
Défense #1
Défense #2
Gardien
Alexander Edler
AGE:30
PO:20
OV:81
Aaron Ekblad
AGE:20
PO:61
OV:80
Ron Hainsey
AGE:35
PO:6
OV:78
Dan Hamhuis
AGE:34
PO:16
OV:77
Roman Polak
AGE:30
PO:5
OV:75
Jason Garrison
AGE:33
PO:4
OV:75
*Griffin Reinhart
AGE:22
PO:51
OV:70
*Joel Edmundson
AGE:24
PO:71
OV:69
*Keith Aulie
AGE:28
PO:34
OV:69
*Patrik Nemeth
AGE:24
PO:61
OV:68
*Philip Samuelsson
AGE:25
PO:52
OV:66
Brett Carson
AGE:31
PO:60
OV:65
*Tim Erixon
AGE:25
PO:59
OV:64
*Dillon Simpson
AGE:25
PO:71
OV:54
Kari Lehtonen
AGE:33
PO:33
OV:87
Jaroslav Halak
AGE:31
PO:67
OV:86
Anders Lindback
AGE:30
PO:47
OV:82
*Matt Hackett
AGE:26
PO:43
OV:76
*Kristers Gudlevskis
AGE:24
PO:66
OV:74
*Cristopher Nilstorp
AGE:32
PO:1
OV:70
*Anthony Stolarz
AGE:24
PO:79
OV:67
É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
Alexei Lipanov
Avalanche
Brandon Halverson
Avalanche
Cole Fraser
Avalanche
Daniel Altshuller
Avalanche
Evgeny Grachev
Avalanche
Fabrice Herzog
Avalanche
Jacob Bryson
Avalanche
James Livingston
Avalanche
James Lodge
Avalanche
Jan Kostalek
Avalanche
Joachim Nermark
Avalanche
Julius Bergman
Avalanche
Kasper Bjorkqvist
Avalanche
Michael Amadio
Avalanche
Owen Tippett
Avalanche
Ryan Haggerty
Avalanche
Steven Fogarty
Avalanche
Vinny Saponari
Avalanche
Yegor Korshkov
Avalanche
Choix au Repêchage
Année
R1
R2
R3
R4
R5
R6
13
COL
COL
COL
COL
COL
COL MIN
14
COL
COL
COL
COL
COL
COL
15
COL
COL
COL
COL
COL
COL
16
COL
COL
COL
COL
COL
COL
17
COL
COL
COL
COL
COL
COL
[2018-05-16 14:50:09] - Tom Kostopoulos retired from Avalanche [2018-05-07 19:07:55] - Avalanche was eliminated at round 2 of year 12. [2018-04-25 09:50:11] - Avalanche didn't make playoff for year 12. [2018-03-20 20:05:35] - TRADE : From Avalanche to Wild : Mark Streit (84). [2018-03-20 20:05:35] - TRADE : From Wild to Avalanche : Ron Hainsey (79), Y:13-RND:6-MIN, Conditional Draft Pick - Y:14-RND:5-MIN. [2018-03-20 20:05:34] - Ron Hainsey was added to Avalanche. [2017-12-19 23:51:44] - New Record for Team's Most Shots (54) in 1 Game for Avalanche! [2017-10-13 10:58:16] - Cole Fraser has been added to Avalanche. [2017-10-13 10:39:14] - Jacob Bryson has been added to Avalanche. [2017-10-06 10:32:20] - Alexei Lipanov has been added to Avalanche. [2017-10-01 10:51:03] - Owen Tippett has been added to Avalanche. [2017-10-01 10:23:37] - Daniel O'Regan was added to Avalanche. [2017-09-30 14:55:59] - Stephen Gionta was added to Avalanche. [2017-09-30 14:55:53] - Jordin Tootoo was added to Avalanche. [2017-09-30 14:55:47] - Tanner Glass was added to Avalanche. [2017-09-30 14:55:41] - Matt Hendricks was added to Avalanche. [2017-09-30 14:07:23] - Avalanche hired Bryan Trottier for 500 000 $ for 3 year(s). [2017-09-30 11:17:48] - Michal Handzus was released. [2017-09-30 11:17:48] - Avalanche paid 0 $ to release Michal Handzus. [2017-09-24 16:40:17] - Mathias Tjarnqvist retired from Avalanche [2017-08-13 09:26:07] - Dillon Simpson has been deleted from Avalanche. [2017-08-13 09:26:02] - Brock Boeser has been deleted from Avalanche. [2017-08-13 09:25:59] - Anthony Stolarz has been deleted from Avalanche. [2017-08-13 09:25:36] - Dillon Simpson was added to Avalanche. [2017-08-13 09:25:31] - Brock Boeser was added to Avalanche. [2017-08-13 09:25:26] - Anthony Stolarz was added to Avalanche. [2017-07-30 10:41:15] - David Jones retired from Avalanche [2017-07-30 10:36:01] - Patrik Elias retired from Avalanche [2017-07-27 13:44:52] - Niko Kapanen retired from Avalanche [2017-07-23 11:26:43] - Mark Popovic retired from Avalanche [2017-07-16 18:42:55] - Denis Grebeshkov retired from Avalanche
[2018-05-16 14:51:03] Auto Lines Function has been run for Avalanche.
[2018-05-16 14:50:09] Tom Kostopoulos retired from Avalanche
[2018-05-07 19:07:55] Avalanche lines for next game are empty. Current rosters/lines are not erased.
[2018-05-06 20:16:08] Avalanche lines for next game are empty. Current rosters/lines are not erased.
[2018-05-05 19:33:28] Avalanche lines for next game are empty. Current rosters/lines are not erased.
[2018-05-04 19:58:58] Avalanche lines for next game are empty. Current rosters/lines are not erased.
[2018-05-03 18:43:22] Avalanche lines for next game are empty. Current rosters/lines are not erased.
[2018-04-29 22:54:12] Avalanche lines for next game are empty. Current rosters/lines are not erased.