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
Vladimir Tarasenko, Mikael Backlund, Josh Bailey, Andrew Ladd, Matt Cullen
Goalie
#1 : Calvin Pickard, #2 : Semyon Varlamov
Custom OT Lines Forwards
Vladimir Tarasenko, Mikael Backlund, Andrew Ladd, Josh Bailey, Matt Cullen, Matt Puempel, Matt Puempel, Kevin Porter, Alex Chiasson, Oskar Lindblom, Tyler Ennis
Custom OT Lines Defensemen
Nick Leddy, Ryan Ellis, Jacob Trouba, Carl Gunnarsson, Brandon Davidson
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
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
Anthony Salinitri
Colorado Avalanche
2016
166
Arnaud Durandeau
Colorado Avalanche
2017
198
Damien Riat
Colorado Avalanche
2016
106
Dylan Gambrell
Colorado Avalanche
2016
46
Erik Kallgren
Colorado Avalanche
2015
172
Gustav Olhaver
Colorado Avalanche
2015
142
Jake Pivonka
Colorado Avalanche
2018
130
Jonathan Dugan
Colorado Avalanche
2017
165
Kieffer Bellows
Colorado Avalanche
2016
16
Kirill Marchenko
Colorado Avalanche
2018
68
Linus Cronholm
Colorado Avalanche
2018
146
Luke Martin
Colorado Avalanche
2017
74
Maksim Sushko
Colorado Avalanche
2017
136
Michael Rasmussen
Colorado Avalanche
2017
13
Radovan Bondra
Colorado Avalanche
2015
112
Toni Utunen
Colorado Avalanche
2018
161
Ty Emberson
Colorado Avalanche
2018
99
Wouter Peeters
Colorado Avalanche
2016
76
Zach Gallant
Colorado Avalanche
2017
105
Draft Picks
Year
R1
R2
R3
R4
R5
R6
R7
2019
COL
COL
COL
COL WPG
COL
COL
2020
COL
COL
COL
COL
COL
COL
COL
2021
COL
COL
COL
COL
COL
COL
COL
2022
COL
COL
COL
COL
COL
COL
COL
2023
COL
COL
COL
COL
COL
COL
COL
[07.05.2019 22:22:53] - Colorado Avalanche was eliminated at round 2 of year 2018. [08.04.2019 23:05:15] - Tofino Whalers didn't make playoff for year 2018. [22.10.2018 20:10:38] - Nick Walters signed with Colorado Avalanche for 450.000 € for 1 year(s) / Signing Bonus of 175.000 €. [22.10.2018 20:10:38] - Nick Walters was added to Colorado Avalanche. [20.10.2018 23:21:11] - Marek Tvrdon signed with Colorado Avalanche for 450.000 € for 1 year(s) / Signing Bonus of 175.000 €. [20.10.2018 23:21:11] - Marek Tvrdon was added to Colorado Avalanche. [20.10.2018 23:20:07] - Travis Ewanyk signed with Colorado Avalanche for 450.000 € for 1 year(s) / Signing Bonus of 175.000 €. [20.10.2018 23:20:07] - Travis Ewanyk was added to Colorado Avalanche. [20.10.2018 23:18:58] - Ryan Rupert signed with Colorado Avalanche for 450.000 € for 1 year(s) / Signing Bonus of 175.000 €. [20.10.2018 23:18:58] - Ryan Rupert was added to Colorado Avalanche. [02.10.2018 18:40:53] - Tofino Whalers hired Mike Van Ryn for 250.000 € for 1 year(s). [02.10.2018 18:40:35] - Colorado Avalanche hired Gerry Fleming for 750.000 € for 1 year(s). [02.10.2018 18:39:02] - Colorado Avalanche fired A.J. MacLean. [29.09.2018 23:44:42] - Colorado Avalanche hired A.J. MacLean for 750.000 € for 1 year(s).
[23.05.2019 00:15:13] Evgeny Kuznetsov from Colorado Avalanche is back from Strained Right Elbow Injury.
[07.05.2019 22:22:48] Auto Lines Partial Function has been run for Colorado Avalanche.
[07.05.2019 22:22:48] Auto Roster Partial Function has been run for Colorado Avalanche. [07.05.2019 22:22:48] Colorado Avalanche roster errors : Not enough Defenseman available in Pro Team! 5 Dressed. 6 Required.
Not enough Players available in Pro Team! 17 Dressed. 18 Required.
Some errors will be automatically fixed.
[06.05.2019 21:39:55] Ryan Ellis from Colorado Avalanche is back from Exhaustion. [05.05.2019 20:45:15] Semyon Varlamov from Colorado Avalanche is back from Exhaustion. [05.05.2019 20:45:15] Jacob Larsson from Tofino Whalers is back from Torn Right Knee Ligaments Injury. [05.05.2019 20:45:14] Ryan Ellis from Colorado Avalanche is injured from Exhaustion.
[05.05.2019 20:45:09] Auto Lines Partial Function has been run for Colorado Avalanche.
[05.05.2019 20:45:09] Auto Roster Partial Function has been run for Colorado Avalanche. [05.05.2019 20:45:09] Colorado Avalanche roster errors : Not enough Goalie available in Pro Team! 1 Dressed. 2 Required.
Some errors will be automatically fixed.
[03.05.2019 23:16:43] Semyon Varlamov from Colorado Avalanche injured (Exhaustion)
[27.04.2019 23:20:24] Auto Lines Function has been run for Colorado Avalanche. [27.04.2019 23:20:24] Colorado Avalanche lines errors : Alex Chiasson is used twice in Normal line #2
[27.04.2019 23:20:24] Auto Lines Partial Function has been run for Colorado Avalanche. [27.04.2019 23:20:24] Colorado Avalanche lines errors : Alex Chiasson is used twice in Normal line #2
[24.04.2019 22:00:38] Successfully loaded Colorado Avalanche lines done with Web Base Client and SQLite Database. [16.04.2019 22:58:28] Jacob Trouba from Colorado Avalanche is back from Broken Right Foot Toe Injury.
[16.04.2019 22:54:57] Successfully loaded Colorado Avalanche lines done with Web Base Client and SQLite Database. [15.04.2019 22:56:13] Semyon Varlamov from Colorado Avalanche is back from Exhaustion. [14.04.2019 21:24:21] Semyon Varlamov from Colorado Avalanche injured (Exhaustion)
[12.04.2019 23:20:18] Alex Chiasson from Colorado Avalanche has scored a Hat Trick!
[10.04.2019 22:35:58] Auto Lines Partial Function has been run for Colorado Avalanche.
[10.04.2019 22:35:58] Auto Roster Partial Function has been run for Colorado Avalanche. [10.04.2019 22:35:58] Colorado Avalanche roster errors : Not enough Forward available in Pro Team! 11 Dressed. 12 Required.
Not enough Players available in Pro Team! 17 Dressed. 18 Required.
Some errors will be automatically fixed.
[08.04.2019 23:04:19] Vladimir Tarasenko from Colorado Avalanche is back from Exhaustion. [07.04.2019 22:43:13] Borna Rendulic from Tofino Whalers is back from Broken Right Index Finger Injury. [07.04.2019 22:43:13] Vladimir Tarasenko from Colorado Avalanche is injured from Exhaustion. [06.04.2019 23:05:44] Semyon Varlamov from Colorado Avalanche is back from Exhaustion.
[05.04.2019 22:43:52] Auto Lines Partial Function has been run for Colorado Avalanche.
[05.04.2019 22:43:52] Auto Roster Partial Function has been run for Colorado Avalanche. [05.04.2019 22:43:52] Colorado Avalanche roster errors : Not enough Defenseman available in Pro Team! 5 Dressed. 6 Required.
Not enough Goalie available in Pro Team! 1 Dressed. 2 Required.
Not enough Players available in Pro Team! 17 Dressed. 18 Required.
Some errors will be automatically fixed.
[03.04.2019 22:30:58] Nick Leddy from Colorado Avalanche is back from Exhaustion. [02.04.2019 21:16:49] Semyon Varlamov from Colorado Avalanche injured (Exhaustion) [02.04.2019 21:16:49] Nick Leddy from Colorado Avalanche is injured from Exhaustion.