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 |
Coaches Name | Team Name | PH | DF | OF | PD | EX | LD | PO | CNT | Age | Contract | Salary |
---|---|---|---|---|---|---|---|---|---|---|---|---|
Alain Vigneault | Panthers | 72 | 96 | 79 | 66 | 93 | 74 | 55 | CAN | 52 | 2 | 3,500,000$ |
Barry Trotz | Stars | 69 | 83 | 75 | 86 | 83 | 80 | 56 | CAN | 51 | 1 | 1,150,000$ |
Bruce Boudreau | Jets | 80 | 68 | 89 | 76 | 49 | 71 | 49 | CAN | 58 | 3 | 2,250,000$ |
Claude Julien | Rangers | 82 | 83 | 74 | 74 | 59 | 61 | 55 | CAN | 53 | 3 | 1,000,000$ |
Dave Tippett | Devils | 83 | 81 | 74 | 80 | 71 | 73 | 55 | CAN | 52 | 1 | 2,000,000$ |
Guy Boucher | Golden Knights | 73 | 78 | 72 | 78 | 38 | 78 | 65 | CAN | 42 | 2 | 2,000,000$ |
Jacques Lemaire | Capitals | 69 | 92 | 80 | 76 | 99 | 99 | 39 | Can | 67 | 2 | 900,000$ |
Jacques Martin | Islanders | 79 | 85 | 97 | 76 | 99 | 99 | 46 | CAN | 61 | 1 | 4,000,000$ |
Joel Quenneville | Senateurs | 78 | 73 | 74 | 78 | 90 | 82 | 52 | CAN | 55 | 4 | 1,500,000$ |
John Tortorella | Lightning | 91 | 58 | 90 | 63 | 79 | 59 | 52 | Can | 54 | 2 | 1,500,000$ |
Jon Cooper | Blackhawks | 69 | 66 | 68 | 69 | 35 | 55 | 79 | Can | 48 | 3 | 1,500,000$ |
Ken Hitchcock | Kings | 66 | 78 | 72 | 87 | 99 | 70 | 45 | CAN | 62 | 1 | 2,000,000$ |
Lindy Ruff | Flames | 87 | 64 | 75 | 78 | 88 | 88 | 54 | CAN | 53 | 1 | 2,000,000$ |
Marc Crawford | Maple Leafs | 74 | 71 | 92 | 70 | 81 | 72 | 55 | CAN | 52 | 4 | 2,150,000$ |
Martin St-Louis | Canucks | 82 | 83 | 87 | 73 | 99 | 88 | 37 | CAN | 43 | 2 | 2,000,000$ |
Mike Babcock | Canadiens | 75 | 83 | 81 | 78 | 77 | 77 | 57 | Can | 52 | 4 | 2,000,000$ |
Mike Keenan | Avalanche | 86 | 74 | 84 | 71 | 99 | 73 | 43 | CAN | 64 | 1 | 600,000$ |
Pat Burns | Penguins | 79 | 89 | 88 | 76 | 99 | 99 | 46 | CAN | 61 | 1 | 2,000,000$ |
Patrick Roy | Sharks | 79 | 85 | 67 | 58 | 37 | 80 | 59 | Can | 51 | 2 | 900,000$ |
Paul Kariya | Blues | 62 | 77 | 79 | 82 | 55 | 70 | 67 | CAN | 40 | 1 | 650,000$ |
Peter Laviolette | Flyers | 83 | 88 | 82 | 77 | 69 | 86 | 58 | USA | 49 | 4 | 2,500,000$ |
Randy Carlyle | Blue Jackets | 87 | 77 | 83 | 67 | 62 | 87 | 50 | CAN | 57 | 2 | 1,500,000$ |
Ron Wilson | Bruins | 83 | 81 | 64 | 66 | 55 | 71 | 49 | USA | 58 | 3 | 750,000$ |
Ted Nolan | Predators | 78 | 80 | 77 | 80 | 76 | 56 | 52 | CAN | 55 | 2 | 2,000,000$ |
Terry Murray | Red Wings | 70 | 74 | 86 | 93 | 95 | 85 | 44 | CAN | 63 | 1 | 2,200,000$ |
Todd McLellan | Oilers | 66 | 62 | 78 | 79 | 43 | 69 | 57 | CAN | 50 | 1 | 500,000$ |
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 |
Coaches Name | Team Name | PH | DF | OF | PD | EX | LD | PO | CNT | Age | Contract | Salary |
---|---|---|---|---|---|---|---|---|---|---|---|---|
Adams Oates | Moose | 53 | 56 | 85 | 72 | 37 | 59 | 54 | CAN | 53 | 1 | 950,000$ |
Alex Kovalev | Penguins | 66 | 64 | 69 | 70 | 40 | 42 | 58 | RUS | 47 | 3 | 500,000$ |
André Tourigny | Sound Tigers | 75 | 58 | 63 | 70 | 34 | 62 | 47 | Can | 60 | 1 | 750,000$ |
Claude Noël | Punishers | 69 | 65 | 65 | 70 | 41 | 51 | 49 | Can | 57 | 1 | 300,000$ |
Craig MacTavish | Heat | 78 | 75 | 69 | 75 | 76 | 67 | 52 | CAN | 55 | 3 | 800,000$ |
Dale Hunter | Barracuda | 77 | 81 | 66 | 64 | 43 | 68 | 54 | Can | 66 | 2 | 650,000$ |
Dave Semenko | Condors | 73 | 79 | 66 | 71 | 91 | 63 | 53 | CAN | 54 | 2 | 500,000$ |
Denis Savard | Crunch | 60 | 52 | 95 | 76 | 60 | 65 | 55 | Can | 63 | 2 | 500,000$ |
Doug Gilmour | Icehogs | 67 | 66 | 80 | 70 | 37 | 80 | 57 | CAN | 50 | 1 | 700,000$ |
Gerard Gallant | Bears | 65 | 66 | 64 | 72 | 38 | 65 | 57 | CAN | 2 | 2 | 550,000$ |
Guy Carbonneau | Monsters | 75 | 91 | 58 | 89 | 43 | 77 | 54 | CAN | 52 | 2 | 750,000$ |
Jack Capuano | Wolfpack | 63 | 70 | 61 | 56 | 47 | 44 | 58 | USA | 49 | 2 | 350,000$ |
Joël Bouchard | Eagles | 80 | 75 | 63 | 79 | 61 | 63 | 50 | CAN | 57 | 1 | 600,000$ |
Kevin Dineen | Phantoms | 73 | 65 | 66 | 79 | 32 | 72 | 57 | Can | 49 | 4 | 500,000$ |
Kirk Muller | Griffins | 79 | 74 | 72 | 83 | 34 | 67 | 60 | CAN | 47 | 2 | 850,000$ |
Lanne MacDonald | Comets | 75 | 58 | 63 | 70 | 34 | 62 | 37 | USA | 71 | 1 | 325,000$ |
Larry Robinson | Devils | 77 | 93 | 56 | 82 | 99 | 83 | 45 | Can | 75 | 1 | 750,000$ |
Mario Lemieux | Senators | 58 | 69 | 72 | 72 | 51 | 55 | 55 | CAN | 53 | 1 | 1,000,000$ |
Michel Therrien | Reign | 81 | 73 | 81 | 76 | 72 | 74 | 57 | CAN | 50 | 3 | 750,000$ |
Mike Yeo | Little Stars | 61 | 64 | 68 | 67 | 35 | 37 | 66 | CAN | 41 | 2 | 750,000$ |
Paul Maurice | Wolves | 73 | 94 | 61 | 68 | 78 | 82 | 61 | Can | 50 | 4 | 500,000$ |
Pavel Bure | Thunderbirds | 54 | 60 | 76 | 66 | 33 | 45 | 63 | RUS | 47 | 4 | 800,000$ |
Peter DeBoer | Marlies | 67 | 71 | 73 | 86 | 54 | 63 | 62 | Can | 56 | 3 | 666,000$ |
Rick Tocchet | Rocket | 71 | 64 | 73 | 69 | 34 | 49 | 58 | USA | 42 | 2 | 500,000$ |
Teemu Selanne | Rampage | 77 | 69 | 73 | 90 | 87 | 74 | 45 | Fin | 40 | 2 | 650,000$ |
Wayne Gretzky | Admirals | 70 | 62 | 82 | 91 | 52 | 68 | 55 | Can | 64 | 2 | 850,000$ |
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 |
Coaches Name | PH | DF | OF | PD | EX | LD | PO | CNT | Age | Contract | Salary |
---|---|---|---|---|---|---|---|---|---|---|---|
Brent Sutter | 90 | 64 | 69 | 87 | 40 | 59 | 56 | Can | 50 | 1 | 250,000$ |
Dan Bylsma | 77 | 70 | 68 | 70 | 49 | 50 | 64 | USA | 43 | 0 | 800,000$ |
Dominique Ducharme | 69 | 60 | 69 | 75 | 38 | 65 | 55 | Can | 43 | 1 | 250,000$ |
Joe Sacco | 61 | 66 | 65 | 62 | 31 | 55 | 63 | USA | 43 | 1 | 250,000$ |
John Anderson | 67 | 73 | 66 | 66 | 45 | 85 | 51 | Can | 55 | 1 | 250,000$ |
Mario Tremblay | 68 | 75 | 64 | 67 | 47 | 57 | 50 | Can | 56 | 1 | 250,000$ |
Tony Granato | 69 | 61 | 65 | 82 | 49 | 59 | 58 | USA | 48 | 1 | 250,000$ |
Tony Twist | 76 | 56 | 69 | 70 | 33 | 56 | 63 | USA | 53 | 3 | 550,000$ |