| 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 | Revenu | Dépenses | Estimation | Total de l’équipe estimé | ||||||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| # | É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 - % | Revenu moyen par match | Revenu annuel à ce jour | Capacité de l’aréna | Popularité de l’équipe | Salaire total des joueurs | Plafond Salariale total des joueurs | Valeur du plafond salarial spécial | Dépenses annuelles à ce jour | Plafond salarial par jour | Plafond salarial à ce jour | Joueurs Inclus dans le plafond salarial | Joueurs exclut du plafond Salarial | Taxe de luxe totale | Revenus de la saison estimés | Jours restants de la saison | Dépenses par jour | Dépenses de la saison estimées | Dépenses de la saison estimées | Cap Salarial de la Saison estimé | Au dessus du plancher salarial of 52,000,000$ | Plafond salarial maximum | Plafond salarial disponible | Compte bancaire actuel | Compte bancaire projeté |
| 1 | Boston Bruins | 7000 | 6000 | 3450 | 6000 | 1550 | 150 | 100 | 70 | 50 | 250 | 275183 | 235663 | 137162 | 235909 | 60671 | 98.28% | 98.19% | 99.39% | 98.30% | 97.86% | 1 | 23615 - 98.39% | 2,154,926$ | 86,197,049$ | 24000 | 110 | 57,150,000$ | 57,150,000$ | 0$ | 57,527,127$ | 443,023$ | 56,392,231$ | 20 | 0 | 0$ | 2,154,926$ | 7 | 452,326$ | 3,166,282$ | 3,404,894$ | 59,493,392$ | 7,493,392$ | 75,000,000$ | 15,506,608$ | 100,005,244$ | 99,198,060$ |
| 2 | Buffalo Sabres | 7050 | 6400 | 3750 | 6100 | 1700 | 150 | 100 | 70 | 50 | 250 | 281424 | 249394 | 147772 | 243075 | 64868 | 99.80% | 97.42% | 98.51% | 99.62% | 95.39% | 1 | 24663 - 98.65% | 2,249,691$ | 89,987,624$ | 25000 | 110 | 75,650,000$ | 75,650,000$ | 0$ | 72,283,712$ | 586,434$ | 69,919,389$ | 20 | 0 | 0$ | 2,249,691$ | 7 | 605,814$ | 4,240,698$ | 4,469,377$ | 74,024,427$ | 22,024,427$ | 75,000,000$ | 975,573$ | 123,967,156$ | 122,190,654$ |
| 3 | Calgary Flames | 7000 | 6000 | 3450 | 6000 | 1550 | 150 | 100 | 70 | 50 | 250 | 278855 | 239453 | 137676 | 238871 | 61332 | 99.59% | 99.77% | 99.77% | 99.53% | 98.92% | 1 | 23905 - 99.60% | 2,182,108$ | 87,284,307$ | 24000 | 110 | 76,800,000$ | 76,800,000$ | 0$ | 71,157,760$ | 595,349$ | 70,212,022$ | 22 | 0 | 0$ | 2,182,108$ | 7 | 603,101$ | 4,221,707$ | 4,514,494$ | 74,379,465$ | 22,379,465$ | 75,000,000$ | 620,535$ | 102,102,067$ | 100,217,556$ |
| 4 | Chicago Blackhawks | 6800 | 5800 | 3250 | 5800 | 1350 | 150 | 100 | 70 | 50 | 250 | 265062 | 225537 | 126750 | 225795 | 52650 | 99.95% | 99.71% | 100.00% | 99.82% | 100.00% | 2 | 22969 - 99.87% | 2,084,413$ | 81,292,088$ | 23000 | 110 | 77,400,000$ | 77,400,000$ | 0$ | 70,064,732$ | 600,000$ | 69,118,993$ | 20 | 0 | 0$ | 4,168,825$ | 7 | 607,752$ | 4,254,264$ | 4,526,371$ | 73,318,993$ | 21,318,993$ | 75,000,000$ | 1,681,007$ | 89,870,938$ | 89,958,576$ |
| 5 | Detroit Red Wings | 6800 | 5800 | 3250 | 5800 | 1350 | 150 | 100 | 70 | 50 | 250 | 271827 | 231836 | 130000 | 231793 | 54000 | 99.94% | 99.93% | 100.00% | 99.91% | 100.00% | 1 | 22986 - 99.94% | 2,085,630$ | 83,425,206$ | 23000 | 110 | 72,550,000$ | 72,550,000$ | 0$ | 70,245,726$ | 562,403$ | 69,347,293$ | 22 | 0 | 0$ | 2,085,630$ | 7 | 569,767$ | 3,988,369$ | 4,257,990$ | 73,284,114$ | 21,284,114$ | 75,000,000$ | 1,715,886$ | 59,533,969$ | 57,809,038$ |
| 6 | Edmonton Oilers | 6800 | 5800 | 3250 | 5800 | 1350 | 150 | 100 | 70 | 50 | 250 | 272000 | 232000 | 130000 | 231985 | 54000 | 100.00% | 100.00% | 100.00% | 99.99% | 100.00% | 1 | 23000 - 100.00% | 2,086,734$ | 83,469,362$ | 23000 | 110 | 78,900,000$ | 78,900,000$ | 0$ | 71,638,735$ | 611,628$ | 70,693,002$ | 22 | 0 | 0$ | 2,086,734$ | 7 | 619,380$ | 4,335,660$ | 4,710,320$ | 74,974,398$ | 22,974,398$ | 75,000,000$ | 25,602$ | 76,924,897$ | 74,748,009$ |
| 7 | Hartford Whalers | 7000 | 6000 | 3450 | 6000 | 1550 | 150 | 100 | 70 | 50 | 250 | 279525 | 239060 | 137686 | 238529 | 61360 | 99.83% | 99.61% | 99.77% | 99.39% | 98.97% | 1 | 23904 - 99.60% | 2,183,208$ | 87,328,338$ | 24000 | 110 | 73,300,000$ | 73,300,000$ | 0$ | 70,483,766$ | 568,217$ | 69,254,256$ | 20 | 0 | 0$ | 2,183,208$ | 7 | 578,295$ | 4,048,065$ | 4,402,716$ | 73,231,775$ | 21,231,775$ | 75,000,000$ | 1,768,225$ | 74,108,001$ | 72,335,678$ |
| 8 | Los Angeles Kings | 6800 | 5800 | 3250 | 5800 | 1350 | 150 | 100 | 70 | 50 | 250 | 271074 | 230814 | 130000 | 230725 | 54000 | 99.66% | 99.49% | 100.00% | 99.45% | 100.00% | 1 | 22915 - 99.63% | 2,079,923$ | 83,196,937$ | 23000 | 110 | 71,000,000$ | 71,000,000$ | 0$ | 69,728,319$ | 550,388$ | 68,782,577$ | 21 | 0 | 0$ | 2,079,923$ | 7 | 558,140$ | 3,906,980$ | 4,220,436$ | 72,635,293$ | 20,635,293$ | 75,000,000$ | 2,364,707$ | 108,089,911$ | 106,247,405$ |
| 9 | Montreal Canadiens | 10400 | 6800 | 5250 | 6700 | 1900 | 150 | 100 | 70 | 50 | 250 | 332800 | 248664 | 168000 | 248156 | 63186 | 80.00% | 91.42% | 80.00% | 92.60% | 83.14% | 1 | 26520 - 85.41% | 2,438,452$ | 97,538,095$ | 31050 | 110 | 71,700,000$ | 71,700,000$ | 0$ | 70,172,491$ | 555,814$ | 69,226,753$ | 21 | 0 | 0$ | 2,438,452$ | 7 | 563,566$ | 3,944,962$ | 4,305,982$ | 73,117,451$ | 21,117,451$ | 75,000,000$ | 1,882,549$ | 208,771,977$ | 207,351,449$ |
| 10 | New York Rangers | 7800 | 7400 | 5000 | 7600 | 2200 | 150 | 100 | 70 | 50 | 250 | 298122 | 255786 | 160247 | 251528 | 70401 | 95.55% | 86.41% | 80.12% | 82.74% | 80.00% | 1 | 25902 - 86.34% | 2,373,430$ | 94,937,216$ | 30000 | 110 | 70,775,000$ | 70,775,000$ | 0$ | 69,202,335$ | 548,643$ | 68,280,238$ | 21 | 0 | 0$ | 2,373,430$ | 7 | 556,202$ | 3,893,414$ | 4,204,802$ | 72,120,739$ | 20,120,739$ | 75,000,000$ | 2,879,261$ | 185,817,638$ | 184,284,324$ |
| 11 | Ottawa Senators | 6800 | 5800 | 3250 | 5800 | 1350 | 150 | 100 | 70 | 50 | 250 | 271188 | 231249 | 130000 | 230958 | 54000 | 99.70% | 99.68% | 100.00% | 99.55% | 100.00% | 1 | 22935 - 99.72% | 2,081,459$ | 83,258,350$ | 23000 | 110 | 70,700,000$ | 70,700,000$ | 0$ | 71,043,809$ | 548,062$ | 68,206,591$ | 22 | 1 | 0$ | 2,081,459$ | 7 | 571,318$ | 3,999,226$ | 4,326,949$ | 72,043,025$ | 20,043,025$ | 75,000,000$ | 2,956,975$ | 43,372,390$ | 41,571,050$ |
| 12 | Philadelphia Flyers | 6800 | 5800 | 3250 | 5800 | 1350 | 150 | 100 | 70 | 50 | 250 | 265200 | 226200 | 126750 | 226181 | 52650 | 100.00% | 100.00% | 100.00% | 99.99% | 100.00% | 2 | 23000 - 100.00% | 2,086,729$ | 81,382,442$ | 23000 | 110 | 78,450,000$ | 78,450,000$ | 0$ | 71,368,965$ | 608,140$ | 70,139,559$ | 24 | 0 | 0$ | 4,173,459$ | 7 | 618,217$ | 4,327,519$ | 4,560,334$ | 74,396,539$ | 22,396,539$ | 75,000,000$ | 603,461$ | 90,746,005$ | 90,807,229$ |
| 13 | Pittsburgh Penguins | 6800 | 5800 | 3250 | 5800 | 1350 | 150 | 100 | 70 | 50 | 250 | 271931 | 231965 | 130000 | 231960 | 54000 | 99.97% | 99.98% | 100.00% | 99.98% | 100.00% | 1 | 22996 - 99.98% | 2,086,413$ | 83,456,527$ | 23000 | 110 | 70,200,000$ | 70,200,000$ | 0$ | 67,672,509$ | 544,186$ | 66,821,318$ | 22 | 0 | 0$ | 2,086,413$ | 7 | 551,163$ | 3,858,141$ | 4,179,869$ | 70,630,620$ | 18,630,620$ | 75,000,000$ | 4,369,380$ | 67,077,921$ | 65,427,527$ |
| 14 | Quebec Nordiques | 7000 | 6000 | 3450 | 6000 | 1550 | 150 | 100 | 70 | 50 | 250 | 272288 | 232760 | 134447 | 233094 | 59759 | 99.74% | 99.47% | 99.92% | 99.61% | 98.86% | 2 | 23906 - 99.61% | 2,182,210$ | 85,106,198$ | 24000 | 110 | 69,600,000$ | 69,600,000$ | 0$ | 65,506,189$ | 539,535$ | 64,560,448$ | 20 | 0 | 0$ | 4,364,420$ | 7 | 547,287$ | 3,831,009$ | 4,171,756$ | 68,337,193$ | 16,337,193$ | 75,000,000$ | 6,662,807$ | 81,742,219$ | 82,383,268$ |
| 15 | San Jose Sharks | 7000 | 6000 | 3450 | 6000 | 1550 | 150 | 100 | 70 | 50 | 250 | 271614 | 232107 | 133684 | 232933 | 59847 | 99.49% | 99.19% | 99.36% | 99.54% | 99.00% | 2 | 23851 - 99.38% | 2,177,724$ | 84,931,217$ | 24000 | 110 | 75,750,000$ | 75,750,000$ | 0$ | 72,219,759$ | 587,209$ | 70,706,589$ | 20 | 0 | 0$ | 4,355,447$ | 7 | 599,612$ | 4,197,284$ | 4,507,429$ | 74,817,052$ | 22,817,052$ | 75,000,000$ | 182,948$ | 69,977,424$ | 70,122,918$ |
| 16 | St.Louis Blues | 7000 | 6000 | 3450 | 6000 | 1550 | 150 | 100 | 70 | 50 | 250 | 278442 | 238220 | 137296 | 238313 | 61184 | 99.44% | 99.26% | 99.49% | 99.30% | 98.68% | 1 | 23836 - 99.32% | 2,176,227$ | 87,049,069$ | 24000 | 110 | 66,500,000$ | 66,500,000$ | 0$ | 67,047,275$ | 515,504$ | 66,196,133$ | 23 | 0 | 0$ | 2,176,227$ | 7 | 522,481$ | 3,657,367$ | 3,964,212$ | 69,804,661$ | 17,804,661$ | 75,000,000$ | 5,195,339$ | 145,990,688$ | 144,648,010$ |
| 17 | Toronto Maple Leafs | 6800 | 5800 | 3250 | 5800 | 1350 | 150 | 100 | 70 | 50 | 250 | 271890 | 231917 | 130000 | 231681 | 54000 | 99.96% | 99.96% | 100.00% | 99.86% | 100.00% | 1 | 22987 - 99.94% | 2,085,884$ | 83,435,362$ | 23000 | 110 | 73,850,000$ | 73,850,000$ | 0$ | 69,358,524$ | 572,481$ | 68,153,096$ | 24 | 0 | 0$ | 2,085,884$ | 7 | 576,357$ | 4,034,499$ | 4,334,513$ | 72,160,463$ | 20,160,463$ | 75,000,000$ | 2,839,537$ | 55,056,650$ | 53,104,743$ |
| 18 | Vancouver Canucks | 7000 | 6000 | 3450 | 6000 | 1550 | 150 | 100 | 70 | 50 | 250 | 272015 | 232333 | 134348 | 231883 | 59711 | 99.64% | 99.29% | 99.85% | 99.10% | 98.78% | 2 | 23854 - 99.39% | 2,178,655$ | 84,967,540$ | 24000 | 110 | 74,650,000$ | 74,650,000$ | 0$ | 70,844,185$ | 578,682$ | 68,952,702$ | 22 | 0 | 0$ | 4,357,310$ | 7 | 594,186$ | 4,159,302$ | 4,546,788$ | 73,003,476$ | 21,003,476$ | 75,000,000$ | 1,996,524$ | 94,695,359$ | 94,804,095$ |
| 19 | Washington Capitals | 7000 | 6000 | 3450 | 6000 | 1550 | 150 | 100 | 70 | 50 | 250 | 279157 | 238598 | 137883 | 238833 | 61607 | 99.70% | 99.42% | 99.92% | 99.51% | 99.37% | 1 | 23902 - 99.59% | 2,182,982$ | 87,319,276$ | 24000 | 110 | 75,650,000$ | 75,650,000$ | 0$ | 70,766,274$ | 586,434$ | 69,536,828$ | 21 | 0 | 0$ | 2,182,982$ | 7 | 596,512$ | 4,175,584$ | 4,422,468$ | 73,641,866$ | 21,641,866$ | 75,000,000$ | 1,358,134$ | 136,125,986$ | 134,185,323$ |
| 20 | Winnipeg Jets | 7000 | 6000 | 3450 | 6000 | 1550 | 150 | 100 | 70 | 50 | 250 | 278473 | 237906 | 137630 | 237877 | 60999 | 99.45% | 99.13% | 99.73% | 99.12% | 98.39% | 1 | 23822 - 99.26% | 2,174,709$ | 86,988,362$ | 24000 | 110 | 69,900,000$ | 69,900,000$ | 0$ | 67,467,852$ | 541,860$ | 66,332,899$ | 22 | 0 | 0$ | 2,174,709$ | 7 | 551,163$ | 3,858,141$ | 4,138,927$ | 70,125,919$ | 18,125,919$ | 75,000,000$ | 4,874,081$ | 92,509,599$ | 90,842,226$ |