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
Jamie Oleksiak, Marcus Pettersson, Robert Bortuzzo
Jamie Oleksiak
Jamie Oleksiak, Marcus Pettersson
Tirs de Pénalité
, , , Mathew Barzal, Colton Sissons
Gardien
#1 : , #2 :
Lignes d'Attaque Perso. en Prol.
, , , Mathew Barzal, Colton Sissons, Alex Galchenyuk, Alex Galchenyuk, Michael Frolik, Mathieu Joseph, Tobias Rieder,
Lignes de Défense Perso. en Prol.
Jacob Trouba, Dan Girardi, John Moore, Jamie Oleksiak, Marcus Pettersson
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
2000
4000
1000
Prix des Billets
100
60
35
25
200
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
Dépenses Annuelles à Ce Jour
Salaire Total des Joueurs
Salaire Total Moyen des Joueurs
Salaire des Coachs
Valeur du Cap Salarial Spécial
0$
59,510,833$
59,510,833$
0$
0$
Cap Salarial Par Jour
Cap salarial à ce jour
Taxe de Luxe Totale
Joueurs Inclut dans la Cap Salariale
Joueurs Exclut dans la Cap Salariale
0$
0$
0$
21
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$
11
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$
11,317,937$
11,317,937$
Charte de Profondeur
Ailier Gauche
Centre
Ailier Droit
Dustin Brown
AGE:35
PO:0
OV:81
Alex Galchenyuk
AGE:26
PO:0
OV:74
Colton Sissons
AGE:26
PO:0
OV:74
Michael Frolik
AGE:32
PO:0
OV:72
*Taro Hirose
AGE:23
PO:0
OV:70
Mathieu Joseph
AGE:23
PO:0
OV:69
Tobias Rieder
AGE:27
PO:0
OV:67
Andreas Martinsen
AGE:29
PO:0
OV:65
Tage Thompson
AGE:22
PO:0
OV:65
Phil Varone
AGE:29
PO:0
OV:62
Matt Puempel
AGE:27
PO:0
OV:60
Connor McDavid
AGE:23
PO:0
OV:88
Mathew Barzal
AGE:22
PO:0
OV:76
Alex Galchenyuk
AGE:26
PO:0
OV:74
Colton Sissons
AGE:26
PO:0
OV:74
Alan Quine
AGE:27
PO:0
OV:65
*Joel L'Esperance
AGE:24
PO:0
OV:62
Phil Varone
AGE:29
PO:0
OV:62
Alexander Radulov
AGE:33
PO:0
OV:82
Dustin Brown
AGE:35
PO:0
OV:81
Colton Sissons
AGE:26
PO:0
OV:74
Michael Frolik
AGE:32
PO:0
OV:72
Mathieu Joseph
AGE:23
PO:0
OV:69
Tobias Rieder
AGE:27
PO:0
OV:67
Andreas Martinsen
AGE:29
PO:0
OV:65
Tage Thompson
AGE:22
PO:0
OV:65
*Joel L'Esperance
AGE:24
PO:0
OV:62
Phil Varone
AGE:29
PO:0
OV:62
Matt Puempel
AGE:27
PO:0
OV:60
Défense #1
Défense #2
Gardien
Jacob Trouba
AGE:26
PO:0
OV:79
Dan Girardi
AGE:35
PO:0
OV:72
John Moore
AGE:29
PO:0
OV:70
Jamie Oleksiak
AGE:27
PO:0
OV:69
Marcus Pettersson
AGE:23
PO:0
OV:69
Robert Bortuzzo
AGE:31
PO:0
OV:68
Slater Koekkoek
AGE:26
PO:0
OV:68
Joe Hicketts
AGE:23
PO:0
OV:64
Josh Brown
AGE:26
PO:0
OV:62
Jack Campbell
AGE:28
PO:0
OV:77
Ryan Miller
AGE:39
PO:0
OV:63
Richard Bachman
AGE:32
PO:0
OV:52
É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
Antoine Bibeau
Oilers
Blake Lizotte
Oilers
13
194
Brett Lernout
Oilers
Brett Pollock
Oilers
Carter Verhaeghe
Oilers
Charles-Edouard d'Astous
Oilers
13
176
Chris Martenet
Oilers
2015
103
David Tendeck
Oilers
12
208
Dawson Davidson
Oilers
13
207
Ethan Keppen
Oilers
13
119
Filip Gustavsson
Oilers
Igor Rykov
Oilers
2016
132
Jesse Graham
Oilers
Kyle Wood
Oilers
Matej Tomek
Oilers
2015
90
Matthew Highmore
Oilers
Maxwell Crozier
Oilers
13
154
Nick Henry
Oilers
Owen Tippett
Oilers
Sergey Zborovskiy
Oilers
Stephen Johns
Oilers
Trevor Murphy
Oilers
Tristan Langan
Oilers
Tye Felhaber
Oilers
13
192
Ukko-Pekka Luukkonen
Oilers
2017
57
Zach Fischer
Oilers
Choix au Repêchage
Année
R1
R2
R3
R4
R5
R6
R7
14
EDM
EDM
EDM TOR
EDM
15
EDM
EDM CLB
EDM
EDM
EDM
16
EDM
EDM
EDM
EDM
EDM
EDM
EDM
17
EDM
EDM
EDM
EDM
EDM
EDM
EDM
18
EDM
EDM
EDM
EDM
EDM
EDM
EDM
[2020-04-09 09:16:14] - Oilers didn't make playoff for year 13. [2020-02-21 14:01:55] - TRADE : From Rangers to Oilers : Y:14-RND:3-TOR. [2020-02-21 14:01:55] - TRADE : From Oilers to Rangers : Brett Connolly (73). [2020-02-21 14:01:29] - TRADE : From Flyers to Oilers : Tage Thompson (65), Carter Verhaeghe (P), Igor Rykov (P). [2020-02-21 14:01:29] - TRADE : From Oilers to Flyers : Radek Faksa (73), Y:15-RND:5-EDM. [2020-02-20 09:08:20] - TRADE : From Oilers to Blue Jackets : Andrew Shaw (77), Niklas Hjalmarsson (74), Y:15-RND:6-EDM. [2020-02-20 09:08:20] - TRADE : From Blue Jackets to Oilers : Blake Lizotte (P), Stephen Johns (P), Y:15-RND:2-CLB. [2019-09-30 20:32:34] - Alan Quine was added to Oilers. [2019-09-02 16:04:59] - TRADE : From Maple Leafs to Oilers : Alex Galchenyuk (74), David Tendeck (P). [2019-09-02 16:04:59] - TRADE : From Oilers to Maple Leafs : Josh Anderson (77). [2019-07-10 19:23:45] - Tristan Langan has been added to Oilers. [2019-07-04 22:53:04] - Oilers drafts Dawson Davidson as the #207 overall pick in the Entry Draft of year 13. [2019-07-04 22:13:51] - Mitchell Wheaton has been deleted from Oilers. [2019-07-04 22:13:47] - Jaedon Descheneau has been deleted from Oilers. [2019-07-04 21:57:59] - Taro Hirose was added to Oilers. [2019-07-04 21:57:52] - Joel L'Esperance was added to Oilers. [2019-07-04 21:40:19] - Oilers drafts Tye Felhaber as the #192 overall pick in the Entry Draft of year 13. [2019-07-03 23:20:38] - Oilers drafts Charles-Edouard d'Astous as the #176 overall pick in the Entry Draft of year 13. [2019-07-03 16:55:53] - Oilers drafts Maxwell Crozier as the #154 overall pick in the Entry Draft of year 13. [2019-07-03 16:55:19] - Oilers drafts Joel L'Esperance as the #150 overall pick in the Entry Draft of year 13. [2019-07-03 16:44:17] - TRADE : From Senateurs to Oilers : Y:13-RND:5-CLB. [2019-07-03 16:44:17] - TRADE : From Oilers to Senateurs : Y:14-RND:5-MTL. [2019-07-03 16:43:48] - TRADE : From Bruins to Oilers : Y:13-RND:6-BOS, Y:13-RND:7-BOS. [2019-07-03 16:43:48] - TRADE : From Oilers to Bruins : Y:14-RND:6-NYI, Y:14-RND:7-EDM. [2019-06-30 22:28:47] - Oilers drafts Ethan Keppen as the #119 overall pick in the Entry Draft of year 13. [2019-06-26 22:55:03] - Oilers drafts Taro Hirose as the #25 overall pick in the Entry Draft of year 13.
[2020-04-08 13:09:29] Richard Bachman of Oilers was sent to farm.
[2020-04-07 08:28:07] Auto Lines Partial Function has been run for Oilers.
[2020-04-07 08:28:06] Auto Roster Partial Function has been run for Oilers.
[2020-04-07 08:28:06] Richard Bachman of Oilers was sent to pro.
[2020-04-07 08:28:06] Oilers roster errors : Not enough Goalie available in Pro Team! 0 Dressed. 2 Required.
Not enough Players available in Pro Team! 14 Dressed. 18 Required.
Some errors will be automatically fixed.
[2020-04-06 07:48:33] Game 1237 - Jack Campbell from Oilers is injured (Broken Nose) and is out for 2 months. [2020-04-05 11:03:45] Connor McDavid from Oilers is back from Exhaustion.
[2020-04-05 11:03:37] Auto Lines Partial Function has been run for Oilers.
[2020-04-05 11:03:37] Auto Roster Partial Function has been run for Oilers.
[2020-04-05 11:03:37] Oilers roster errors : Not enough Goalie available in Pro Team! 0 Dressed. 2 Required.
Not enough Players available in Pro Team! 14 Dressed. 18 Required.
Some errors will be automatically fixed.
[2020-04-03 09:21:31] Connor McDavid from Oilers is injured from Exhaustion.
[2020-04-03 09:21:19] Auto Lines Partial Function has been run for Oilers.
[2020-04-03 09:21:19] Auto Roster Partial Function has been run for Oilers.
[2020-04-03 09:21:19] Oilers roster errors : Not enough Goalie available in Pro Team! 0 Dressed. 2 Required.
Not enough Players available in Pro Team! 14 Dressed. 18 Required.
Some errors will be automatically fixed.
[2020-04-01 09:28:35] Auto Lines Partial Function has been run for Oilers.
[2020-04-01 09:28:35] Auto Roster Partial Function has been run for Oilers.
[2020-04-01 09:28:35] Oilers roster errors : Not enough Goalie available in Pro Team! 0 Dressed. 2 Required.
Not enough Players available in Pro Team! 14 Dressed. 18 Required.
Some errors will be automatically fixed.
[2020-03-30 12:18:59] Andreas Martinsen of Oilers was sent to farm.
[2020-03-29 13:40:59] Successfully loaded Oilers lines done with Web Base Client and SQLite Database.
[2020-03-29 13:36:20] Successfully loaded Oilers lines done with Web Base Client and SQLite Database.
[2020-03-28 11:01:46] Oilers lines for next game are empty. Current rosters/lines are not erased. [2020-03-25 10:07:10] Taro Hirose from Oilers is back from Sprained Left Finger Injury.
[2020-03-25 10:07:10] Oilers lines for next game are empty. Current rosters/lines are not erased.
[2020-03-25 10:05:51] Auto Lines Partial Function has been run for Oilers.
[2020-03-25 10:05:51] Auto Roster Partial Function has been run for Oilers.
[2020-03-25 10:05:51] Oilers roster errors : Not enough Goalie available in Pro Team! 1 Dressed. 2 Required.
Some errors will be automatically fixed.