| 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 |
| Capacité de l'Aréna | Prix des Billets | Assistance | Assistance PCT | Revenus | Dépenses | Éstimation | Total de l'Équipe Éstimé | ||||||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| # | Équipe | Niveau1 | Niveau2 | Niveau3 | Niveau4 | Luxe | Niveau1 | Niveau2 | Niveau3 | Niveau4 | Luxe | Niveau1 | Niveau2 | Niveau3 | Niveau4 | Luxe | Niveau1 | Niveau2 | Niveau3 | Niveau4 | Luxe | Matchs à domicile Restants | Assistance Moyenne - % | Revenus Moyen par Match | Revenus Annuels à ce Jour | Capacité de l'Aréna | Popularité de l'Équipe | Salaire Total des Joueurs | Salaire Total Moyen des Joueurs | Valeur du Cap Salarial Spécial | Dépenses Annuelles à Ce Jour | Cap Salarial Par Jour | Cap salarial à ce jour | Joueurs Inclut dans la Cap Salariale | Joueurs Exclut dans la Cap Salariale | Taxe de Luxe Totale | Revenus de la Saison Éstimés | Jours Restants de la Saison | Dépenses Par Jour | Dépenses de la Saison Éstimées | Dépenses de la Saison Éstimées | Cap Salarial de la Saison Éstimé | Au dessus du Plafond Salarial Minimum of 56,000,000$ | Cap Salarial Maximum | Cap Salarial Disponible | Compte Bancaire Actuel | Compte Bancaire Projeté |
| 1 | ANAHEIM Ducks | 6000 | 5000 | 2000 | 5000 | 1000 | 195 | 190 | 185 | 180 | 225 | 122698 | 87718 | 30312 | 72132 | 29829 | 56.80% | 48.73% | 42.10% | 40.07% | 82.86% | 3 | 9519 - 50.10% | 2,552,719$ | 91,897,901$ | 19000 | 100 | 86,350,000$ | 86,350,000$ | 0$ | 75,488,259$ | 86,350,000$ | 74,421,259$ | 23 | 0 | 0$ | 7,658,158$ | 11 | 810,537$ | 8,915,907$ | 8,978,187$ | 86,350,000$ | 30,350,000$ | 89,650,000$ | 3,300,000$ | 190,575,306$ | 189,255,277$ |
| 2 | ARIZONA Coyotes | 6000 | 5000 | 2000 | 5000 | 1000 | 90 | 55 | 45 | 30 | 180 | 215914 | 180000 | 72000 | 180000 | 35847 | 99.96% | 100.00% | 100.00% | 100.00% | 99.58% | 3 | 18993 - 99.97% | 1,720,767$ | 61,947,608$ | 19000 | 100 | 62,141,000$ | 62,141,000$ | 0$ | 63,533,103$ | 62,141,000$ | 62,798,425$ | 21 | 0 | 0$ | 5,162,301$ | 11 | 582,954$ | 6,412,494$ | 6,691,564$ | 62,141,000$ | 6,141,000$ | 89,650,000$ | 27,509,000$ | 151,940,356$ | 150,411,093$ |
| 3 | BOSTON Bruins | 6000 | 5000 | 2000 | 5000 | 1000 | 95 | 70 | 55 | 40 | 190 | 215773 | 179983 | 72000 | 180000 | 35659 | 99.89% | 99.99% | 100.00% | 100.00% | 99.05% | 3 | 18984 - 99.91% | 1,976,707$ | 71,161,437$ | 19000 | 100 | 58,925,000$ | 58,925,000$ | 0$ | 54,757,565$ | 58,925,000$ | 54,381,256$ | 23 | 0 | 0$ | 5,930,120$ | 11 | 549,481$ | 6,044,291$ | 6,316,441$ | 58,925,000$ | 2,925,000$ | 89,650,000$ | 30,725,000$ | 125,769,420$ | 125,383,099$ |
| 4 | CALGARY Flames | 6000 | 5000 | 2000 | 5000 | 1000 | 115 | 90 | 60 | 55 | 250 | 214715 | 179353 | 72000 | 179968 | 28146 | 99.41% | 99.64% | 100.00% | 99.98% | 78.18% | 3 | 18727 - 98.56% | 2,316,393$ | 83,390,153$ | 19000 | 100 | 88,150,000$ | 88,150,000$ | 0$ | 77,952,326$ | 88,150,000$ | 77,188,871$ | 22 | 0 | 0$ | 6,949,179$ | 11 | 824,074$ | 9,064,814$ | 9,254,534$ | 88,150,000$ | 32,150,000$ | 89,650,000$ | 1,500,000$ | 53,135,997$ | 50,830,642$ |
| 5 | CHICAGO Blackhawks | 6000 | 5000 | 2000 | 5000 | 1000 | 100 | 68 | 42 | 27 | 210 | 215759 | 180000 | 72000 | 180000 | 35609 | 99.89% | 100.00% | 100.00% | 100.00% | 98.91% | 3 | 18982 - 99.91% | 1,904,866$ | 68,575,158$ | 19000 | 100 | 68,056,666$ | 68,056,666$ | 0$ | 62,328,392$ | 68,056,666$ | 60,717,998$ | 23 | 0 | 0$ | 5,714,596$ | 11 | 646,756$ | 7,114,316$ | 7,336,276$ | 68,056,666$ | 12,056,666$ | 89,650,000$ | 21,593,334$ | 90,042,854$ | 88,421,174$ |
| 6 | COLORADO Avalanche | 6000 | 5000 | 2000 | 5000 | 1000 | 175 | 170 | 165 | 125 | 200 | 134851 | 97881 | 33750 | 96436 | 35923 | 62.43% | 54.38% | 46.88% | 53.58% | 99.79% | 3 | 11079 - 58.31% | 2,520,121$ | 90,724,355$ | 19000 | 100 | 88,245,000$ | 88,245,000$ | 0$ | 78,557,575$ | 88,245,000$ | 77,794,096$ | 21 | 0 | 0$ | 7,560,363$ | 11 | 824,954$ | 9,074,494$ | 9,247,484$ | 88,245,000$ | 32,245,000$ | 89,650,000$ | 1,405,000$ | 74,293,823$ | 72,606,702$ |
| 7 | COLUMBUS Blue Jackets | 6000 | 5000 | 2000 | 5000 | 1000 | 195 | 190 | 185 | 180 | 225 | 122515 | 85971 | 30029 | 72048 | 29445 | 56.72% | 47.76% | 41.71% | 40.03% | 81.79% | 3 | 9445 - 49.71% | 2,532,265$ | 91,161,530$ | 19000 | 100 | 76,765,000$ | 76,765,000$ | 0$ | 69,828,360$ | 76,765,000$ | 68,946,339$ | 23 | 0 | 0$ | 7,596,794$ | 11 | 719,880$ | 7,918,680$ | 8,049,660$ | 76,765,000$ | 20,765,000$ | 89,650,000$ | 12,885,000$ | 220,187,235$ | 219,734,369$ |
| 8 | DETROIT Red Wings | 6000 | 5000 | 2000 | 5000 | 1000 | 125 | 100 | 90 | 79 | 250 | 219793 | 184266 | 72749 | 161047 | 28997 | 99.01% | 99.60% | 98.31% | 87.05% | 78.37% | 2 | 18023 - 94.86% | 2,651,166$ | 98,093,137$ | 19000 | 100 | 75,295,000$ | 75,295,000$ | 0$ | 69,132,300$ | 75,295,000$ | 68,503,614$ | 21 | 0 | 0$ | 5,302,332$ | 11 | 703,657$ | 7,740,227$ | 7,928,307$ | 75,295,000$ | 19,295,000$ | 89,650,000$ | 14,355,000$ | 118,998,442$ | 116,372,467$ |
| 9 | EDMONTON Oilers | 6000 | 5000 | 2000 | 5000 | 1000 | 125 | 105 | 97 | 80 | 220 | 213276 | 174766 | 56352 | 149748 | 34628 | 98.74% | 97.09% | 78.27% | 83.19% | 96.19% | 3 | 17466 - 91.93% | 2,714,973$ | 97,739,027$ | 19000 | 100 | 86,781,667$ | 86,781,667$ | 0$ | 77,110,136$ | 86,781,667$ | 76,240,456$ | 23 | 0 | 0$ | 8,144,919$ | 11 | 810,756$ | 8,918,316$ | 9,081,396$ | 86,781,667$ | 30,781,667$ | 89,650,000$ | 2,868,333$ | 126,617,421$ | 125,680,944$ |
| 10 | MINNESOTA Wild | 6000 | 5000 | 2000 | 5000 | 1000 | 100 | 60 | 40 | 30 | 200 | 215269 | 180000 | 72000 | 180000 | 35547 | 99.66% | 100.00% | 100.00% | 100.00% | 98.74% | 3 | 18967 - 99.83% | 1,846,430$ | 66,471,490$ | 19000 | 100 | 73,935,000$ | 73,935,000$ | 0$ | 65,051,810$ | 73,935,000$ | 64,378,194$ | 21 | 0 | 0$ | 5,539,291$ | 11 | 691,528$ | 7,606,808$ | 7,742,318$ | 73,935,000$ | 17,935,000$ | 89,650,000$ | 15,715,000$ | 28,187,470$ | 25,984,443$ |
| 11 | MONTREAL Canadiens | 6000 | 5000 | 2000 | 5000 | 1000 | 96 | 69 | 49 | 36 | 193 | 215790 | 180000 | 72000 | 180000 | 35785 | 99.90% | 100.00% | 100.00% | 100.00% | 99.40% | 3 | 18988 - 99.94% | 1,940,610$ | 69,861,964$ | 19000 | 100 | 88,435,000$ | 88,435,000$ | 0$ | 79,336,441$ | 88,435,000$ | 78,438,318$ | 23 | 0 | 0$ | 5,821,830$ | 11 | 828,102$ | 9,109,122$ | 9,350,622$ | 88,435,000$ | 32,435,000$ | 89,650,000$ | 1,215,000$ | 69,600,322$ | 66,071,530$ |
| 12 | NASHVILLE Predators | 6000 | 5000 | 2000 | 5000 | 1000 | 125 | 85 | 75 | 45 | 217 | 213968 | 179860 | 71856 | 180000 | 35687 | 99.06% | 99.92% | 99.80% | 100.00% | 99.13% | 3 | 18927 - 99.62% | 2,402,809$ | 86,501,116$ | 19000 | 100 | 74,185,000$ | 74,185,000$ | 0$ | 68,119,979$ | 74,185,000$ | 66,641,610$ | 22 | 0 | 0$ | 7,208,426$ | 11 | 702,139$ | 7,723,529$ | 7,935,209$ | 74,185,000$ | 18,185,000$ | 89,650,000$ | 15,465,000$ | 46,277,396$ | 45,550,613$ |
| 13 | NEW YORK Islanders | 6000 | 5000 | 2000 | 5000 | 1000 | 150 | 135 | 120 | 100 | 200 | 155604 | 118696 | 45216 | 115106 | 34847 | 74.10% | 67.83% | 64.59% | 65.77% | 99.56% | 4 | 13413 - 70.60% | 2,520,930$ | 88,232,535$ | 19000 | 100 | 82,250,000$ | 82,250,000$ | 0$ | 78,022,672$ | 82,250,000$ | 76,874,796$ | 22 | 0 | 0$ | 10,083,718$ | 11 | 773,407$ | 8,507,477$ | 8,745,047$ | 82,250,000$ | 26,250,000$ | 89,650,000$ | 7,400,000$ | 122,416,746$ | 123,755,417$ |
| 14 | NEW YORK Rangers | 6000 | 5000 | 2000 | 5000 | 1000 | 150 | 120 | 95 | 94 | 300 | 167213 | 142072 | 60765 | 137289 | 24342 | 77.41% | 78.93% | 84.40% | 76.27% | 67.62% | 3 | 14769 - 77.73% | 2,410,718$ | 86,785,840$ | 19000 | 100 | 86,840,000$ | 86,840,000$ | 0$ | 76,297,136$ | 86,840,000$ | 75,230,136$ | 23 | 0 | 0$ | 7,232,153$ | 11 | 815,074$ | 8,965,814$ | 9,077,634$ | 86,840,000$ | 30,840,000$ | 89,650,000$ | 2,810,000$ | 44,652,149$ | 42,806,668$ |
| 15 | OTTAWA Senators | 6000 | 5000 | 2000 | 5000 | 1000 | 95 | 94 | 90 | 89 | 190 | 215908 | 179358 | 69580 | 136628 | 35804 | 99.96% | 99.64% | 96.64% | 75.90% | 99.46% | 3 | 17702 - 93.17% | 2,424,985$ | 87,299,465$ | 19000 | 100 | 79,400,000$ | 79,400,000$ | 0$ | 70,385,653$ | 79,400,000$ | 69,487,498$ | 23 | 0 | 0$ | 7,274,955$ | 11 | 744,444$ | 8,188,884$ | 8,394,954$ | 79,400,000$ | 23,400,000$ | 89,650,000$ | 10,250,000$ | 17,272,819$ | 16,152,820$ |
| 16 | PHILADELPHIA Flyers | 6000 | 5000 | 2000 | 5000 | 1000 | 225 | 220 | 215 | 210 | 280 | 106701 | 75593 | 28800 | 72000 | 24560 | 49.40% | 42.00% | 40.00% | 40.00% | 68.22% | 3 | 8546 - 44.98% | 2,668,671$ | 96,072,170$ | 19000 | 100 | 90,189,286$ | 90,189,286$ | 0$ | 81,575,148$ | 90,189,286$ | 80,382,409$ | 21 | 0 | 0$ | 8,006,014$ | 11 | 847,382$ | 9,321,202$ | 9,539,242$ | 90,189,286$ | 34,189,286$ | 89,650,000$ | -539,286$ | 89,778,651$ | 88,245,423$ |
| 17 | PITTSBURGH Penguins | 6000 | 5000 | 2000 | 5000 | 1000 | 94 | 56 | 31 | 16 | 194 | 215927 | 180000 | 72000 | 180000 | 35828 | 99.97% | 100.00% | 100.00% | 100.00% | 99.52% | 3 | 18993 - 99.96% | 1,643,880$ | 59,179,678$ | 19000 | 100 | 57,790,000$ | 57,790,000$ | 0$ | 52,705,998$ | 57,790,000$ | 52,142,904$ | 23 | 0 | 0$ | 4,931,640$ | 11 | 540,898$ | 5,949,878$ | 6,171,698$ | 57,790,000$ | 1,790,000$ | 89,650,000$ | 31,860,000$ | 51,248,134$ | 50,008,076$ |
| 18 | QUEBEC Nordiques | 6000 | 5000 | 2000 | 5000 | 1000 | 94 | 63 | 37 | 33 | 240 | 215571 | 180000 | 72000 | 180000 | 28374 | 99.80% | 100.00% | 100.00% | 100.00% | 78.82% | 3 | 18776 - 98.82% | 1,821,213$ | 65,563,670$ | 19000 | 100 | 85,380,000$ | 85,130,000$ | 0$ | 77,106,819$ | 85,380,000$ | 75,310,502$ | 24 | 0 | 0$ | 5,463,639$ | 11 | 809,074$ | 8,899,814$ | 9,015,704$ | 85,380,000$ | 29,380,000$ | 89,650,000$ | 4,270,000$ | 33,320,514$ | 29,768,449$ |
| 19 | SEATTLE Totems | 6000 | 5000 | 2000 | 5000 | 1000 | 94 | 56 | 33 | 27 | 195 | 215884 | 180000 | 72000 | 180000 | 35779 | 99.95% | 100.00% | 100.00% | 100.00% | 99.39% | 3 | 18991 - 99.95% | 1,727,017$ | 62,172,606$ | 19000 | 100 | 89,750,000$ | 89,750,000$ | 0$ | 80,492,704$ | 89,750,000$ | 80,010,420$ | 21 | 0 | 0$ | 5,181,050$ | 11 | 835,991$ | 9,195,901$ | 9,370,201$ | 89,750,000$ | 33,750,000$ | 89,650,000$ | -100,000$ | 10,801,809$ | 6,612,658$ |
| 20 | ST-LOUIS Blues | 6000 | 5000 | 2000 | 5000 | 1000 | 140 | 120 | 95 | 70 | 200 | 168667 | 136091 | 58683 | 178941 | 35687 | 78.09% | 75.61% | 81.50% | 99.41% | 99.13% | 3 | 16057 - 84.51% | 2,522,760$ | 90,819,374$ | 19000 | 100 | 86,275,000$ | 86,275,000$ | 0$ | 79,498,413$ | 86,275,000$ | 77,935,644$ | 20 | 0 | 0$ | 7,568,281$ | 11 | 814,954$ | 8,964,494$ | 9,069,524$ | 86,275,000$ | 30,275,000$ | 89,650,000$ | 3,375,000$ | 96,958,826$ | 95,457,583$ |
| 21 | TAMPA BAY Lightning | 6000 | 5000 | 2000 | 5000 | 1000 | 90 | 70 | 55 | 40 | 190 | 215941 | 180000 | 72000 | 180000 | 35611 | 99.97% | 100.00% | 100.00% | 100.00% | 98.92% | 3 | 18988 - 99.93% | 1,935,197$ | 69,667,092$ | 19000 | 100 | 57,160,000$ | 57,160,000$ | 0$ | 56,747,895$ | 57,160,000$ | 56,395,788$ | 22 | 0 | 0$ | 5,805,591$ | 11 | 532,889$ | 5,861,779$ | 6,062,989$ | 57,160,000$ | 1,160,000$ | 89,650,000$ | 32,490,000$ | 60,297,504$ | 60,040,106$ |
| 22 | TORONTO Maple Leafs | 6000 | 5000 | 2000 | 5000 | 1000 | 115 | 95 | 80 | 65 | 205 | 214051 | 179532 | 71578 | 178803 | 35622 | 99.10% | 99.74% | 99.41% | 99.34% | 98.95% | 3 | 18877 - 99.35% | 2,568,926$ | 92,481,327$ | 19000 | 100 | 65,825,000$ | 65,825,000$ | 0$ | 63,292,866$ | 65,825,000$ | 62,529,457$ | 23 | 0 | 0$ | 7,706,777$ | 11 | 617,361$ | 6,790,971$ | 7,038,351$ | 65,825,000$ | 9,825,000$ | 89,650,000$ | 23,825,000$ | 98,859,769$ | 99,528,195$ |
| 23 | VANCOUVER Canucks | 6000 | 5000 | 2000 | 5000 | 1000 | 129 | 85 | 65 | 42 | 225 | 206967 | 178892 | 71880 | 180000 | 29369 | 95.82% | 99.38% | 99.83% | 100.00% | 81.58% | 3 | 18531 - 97.53% | 2,353,321$ | 84,719,560$ | 19000 | 100 | 70,150,000$ | 70,150,000$ | 0$ | 58,945,041$ | 70,150,000$ | 58,404,358$ | 23 | 0 | 0$ | 7,059,963$ | 11 | 655,111$ | 7,206,221$ | 7,438,881$ | 70,150,000$ | 14,150,000$ | 89,650,000$ | 19,500,000$ | 73,567,363$ | 73,188,445$ |
| 24 | VEGAS Golden Knights | 6000 | 5000 | 2000 | 5000 | 1000 | 215 | 210 | 205 | 200 | 250 | 108285 | 79172 | 28820 | 72000 | 26482 | 50.13% | 43.98% | 40.03% | 40.00% | 73.56% | 3 | 8743 - 46.02% | 2,589,128$ | 93,208,613$ | 19000 | 100 | 70,940,000$ | 70,940,000$ | 0$ | 61,481,774$ | 70,940,000$ | 60,306,995$ | 23 | 0 | 0$ | 7,767,384$ | 11 | 668,963$ | 7,358,593$ | 7,557,193$ | 70,940,000$ | 14,940,000$ | 89,650,000$ | 18,710,000$ | 145,110,100$ | 145,320,291$ |
| 25 | WASHINGTON Capitals | 6000 | 5000 | 2000 | 5000 | 1000 | 100 | 99 | 58 | 50 | 225 | 221571 | 184399 | 74000 | 185000 | 36046 | 99.81% | 99.68% | 100.00% | 100.00% | 97.42% | 2 | 18946 - 99.72% | 2,198,044$ | 81,327,636$ | 19000 | 100 | 85,100,000$ | 85,100,000$ | 0$ | 75,166,667$ | 85,100,000$ | 74,403,263$ | 22 | 0 | 0$ | 4,396,088$ | 11 | 795,833$ | 8,754,163$ | 8,914,913$ | 85,100,000$ | 29,100,000$ | 89,650,000$ | 4,550,000$ | 46,291,534$ | 41,772,709$ |
| 26 | WINNIPEG Jets | 6000 | 5000 | 2000 | 5000 | 1000 | 155 | 120 | 100 | 99 | 300 | 154176 | 137393 | 55685 | 124553 | 22674 | 71.38% | 76.33% | 77.34% | 69.20% | 62.98% | 3 | 13736 - 72.29% | 2,495,797$ | 89,848,680$ | 19000 | 100 | 82,682,858$ | 82,682,858$ | 0$ | 75,817,706$ | 82,682,858$ | 74,462,373$ | 20 | 0 | 0$ | 7,487,390$ | 11 | 779,554$ | 8,575,094$ | 8,757,294$ | 82,682,858$ | 26,682,858$ | 89,650,000$ | 6,967,142$ | 96,159,473$ | 94,889,569$ |