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