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
#
Player Name
Team Name
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
Filter Tips
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
#
Goalie Name
Team Name
GP
W
L
OTL
PCT
GAA
MP
PIM
SO
GA
SA
SAR
A
EG
PS %
PSA
ST
BG
S1
S2
S3
Filter Tips
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
Penalty Shots
, , , Mathew Barzal, Colton Sissons
Goalie
#1 : , #2 :
Custom OT Lines Forwards
, , , Mathew Barzal, Colton Sissons, Alex Galchenyuk, Alex Galchenyuk, Michael Frolik, Mathieu Joseph, Tobias Rieder,
Custom OT Lines Defensemen
Jacob Trouba, Dan Girardi, John Moore, Jamie Oleksiak, Marcus Pettersson
Filter Tips
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
Day
Game
Visitor Team
Score
Home Team
Score
ST
OT
SO
RI
Link
Arena Capacity - Ticket Price Attendance - %
Level 1
Level 2
Level 3
Level 4
Luxury
Arena Capacity
6000
5000
2000
4000
1000
Ticket Price
100
60
35
25
200
Attendance
0.00%
0.00%
0.00%
0.00%
0.00%
Attendance PCT
0.00%
0.00%
0.00%
0.00%
0.00%
Income
Home Games Left
Average Attendance - %
Average Income per Game
Year to Date Revenue
Arena Capacity
Team Popularity
41
0 - 0.00%
0$
0$
18000
100
Expenses
Year To Date Expenses
Players Total Salaries
Players Total Average Salaries
Coaches Salaries
Special Salary Cap Value
0$
59,510,833$
59,510,833$
0$
0$
Salary Cap Per Days
Salary Cap To Date
Luxury Taxe Total
Players In Salary Cap
Players Out of Salary Cap
0$
0$
0$
21
0
Estimate
Estimated Season Revenue
Remaining Season Days
Expenses Per Days
Estimated Season Expenses
0$
11
0$
0$
Team Total Estimate
Estimated Season Expenses
Estimated Season Salary Cap
Current Bank Account
Projected Bank Account
0$
0$
11,317,937$
11,317,937$
Depth Chart
Left Wing
Center
Right Wing
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
Defense #1
Defense #2
Goalie
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
Prospects
Filter Tips
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
Prospect
Team Name
Draft Year
Overall Pick
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
Draft Picks
Year
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.