| 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 76,900,000$ | Plafond salarial maximum | Plafond salarial disponible | Compte bancaire actuel | Compte bancaire projeté |
| 1 | Blackhawks | 6000 | 5000 | 5000 | 5000 | 1000 | 100 | 50 | 30 | 15 | 180 | 45738 | 53355 | 44996 | 45670 | 11000 | 69.30% | 97.01% | 81.81% | 83.04% | 100.00% | 31 | 18251 - 82.96% | 1,524,741$ | 16,772,156$ | 22000 | 100 | 101,900,000$ | 101,900,000$ | 2,250,000$ | 27,940,744$ | 101,900,000$ | 27,389,024$ | 23 | 0 | 0$ | 47,266,985$ | 105 | 716,552$ | 75,237,960$ | 75,237,960$ | 104,150,000$ | 27,250,000$ | 104,000,000$ | -150,000$ | 70,336,771$ | 42,365,796$ |
| 2 | Blue Jackets | 5000 | 4000 | 4144 | 4000 | 1000 | 75 | 45 | 30 | 15 | 125 | 60000 | 48000 | 46927 | 48000 | 12000 | 100.00% | 100.00% | 94.37% | 100.00% | 100.00% | 30 | 17911 - 98.71% | 1,277,403$ | 15,328,838$ | 18144 | 100 | 103,005,000$ | 103,005,000$ | 0$ | 28,659,466$ | 103,005,000$ | 27,831,869$ | 23 | 0 | 0$ | 38,322,095$ | 105 | 731,069$ | 76,762,245$ | 76,762,245$ | 103,005,000$ | 26,105,000$ | 104,000,000$ | 995,000$ | -81,777,660$ | -120,217,810$ |
| 3 | Blues | 6000 | 5000 | 4000 | 4000 | 1000 | 125 | 105 | 75 | 45 | 400 | 40493 | 30000 | 24000 | 24000 | 6069 | 56.24% | 50.00% | 50.00% | 50.00% | 50.58% | 30 | 10380 - 51.90% | 1,678,637$ | 20,143,646$ | 20000 | 100 | 72,126,750$ | 72,126,750$ | 3,437,500$ | 21,029,800$ | 72,126,750$ | 20,478,080$ | 24 | 1 | 0$ | 50,359,115$ | 105 | 511,219$ | 53,677,995$ | 53,677,995$ | 75,564,250$ | -1,335,750$ | 104,000,000$ | 28,435,750$ | 213,643,745$ | 210,324,865$ |
| 4 | Canadiens | 7000 | 6000 | 6000 | 5000 | 1000 | 82 | 50 | 16 | 10 | 180 | 61513 | 51508 | 48635 | 51273 | 11000 | 79.89% | 78.04% | 73.69% | 93.22% | 100.00% | 31 | 20357 - 81.43% | 1,475,148$ | 16,226,629$ | 25000 | 100 | 83,661,728$ | 83,661,728$ | 0$ | 24,312,884$ | 83,661,728$ | 23,485,294$ | 22 | 0 | 0$ | 45,729,591$ | 105 | 597,667$ | 62,755,035$ | 62,755,035$ | 83,661,728$ | 6,761,728$ | 104,000,000$ | 20,338,272$ | 54,175,372$ | 37,149,928$ |
| 5 | Canucks | 6000 | 5000 | 3193 | 4000 | 1000 | 82 | 50 | 36 | 15 | 178 | 69076 | 55881 | 38316 | 47944 | 12000 | 95.94% | 93.14% | 100.00% | 99.88% | 100.00% | 30 | 18601 - 96.92% | 1,576,025$ | 18,912,301$ | 19193 | 100 | 81,783,334$ | 81,783,334$ | 620,046$ | 24,820,491$ | 81,783,334$ | 24,268,771$ | 23 | 2 | 0$ | 47,280,752$ | 105 | 577,816$ | 60,670,680$ | 60,670,680$ | 82,403,380$ | 5,503,380$ | 104,000,000$ | 21,596,620$ | 112,709,619$ | 99,319,691$ |
| 6 | Capitals | 6000 | 5000 | 4750 | 4500 | 1027 | 80 | 55 | 25 | 14 | 175 | 67575 | 56608 | 48823 | 52165 | 12324 | 93.85% | 94.35% | 85.65% | 96.60% | 100.00% | 30 | 19791 - 93.02% | 1,567,856$ | 18,814,268$ | 21277 | 100 | 103,218,333$ | 103,218,333$ | 0$ | 28,861,959$ | 103,218,333$ | 28,310,238$ | 21 | 0 | 0$ | 47,035,670$ | 105 | 725,644$ | 76,192,620$ | 76,192,620$ | 103,218,333$ | 26,318,333$ | 104,000,000$ | 781,667$ | 90,752,751$ | 61,595,801$ |
| 7 | Ducks | 5000 | 4000 | 3174 | 4000 | 1000 | 87 | 60 | 38 | 18 | 132 | 60000 | 46192 | 37506 | 47920 | 12000 | 100.00% | 96.23% | 98.47% | 99.83% | 100.00% | 30 | 16968 - 98.80% | 1,447,438$ | 17,369,255$ | 17174 | 100 | 102,053,589$ | 102,053,589$ | 0$ | 28,398,576$ | 102,053,589$ | 28,067,540$ | 22 | 0 | 0$ | 43,423,138$ | 105 | 712,094$ | 74,769,870$ | 74,769,870$ | 102,053,589$ | 25,153,589$ | 104,000,000$ | 1,946,411$ | -18,450,920$ | -49,797,652$ |
| 8 | Flyers | 6000 | 5000 | 5668 | 6000 | 1500 | 80 | 50 | 30 | 15 | 150 | 61561 | 51135 | 44283 | 48152 | 12953 | 93.27% | 92.97% | 71.03% | 72.96% | 78.50% | 31 | 19826 - 82.03% | 1,554,388$ | 17,098,271$ | 24168 | 100 | 103,738,778$ | 103,738,778$ | 0$ | 28,669,522$ | 103,738,778$ | 28,393,676$ | 21 | 0 | 0$ | 48,186,036$ | 105 | 722,336$ | 75,845,280$ | 75,845,280$ | 103,738,778$ | 26,838,778$ | 104,000,000$ | 261,222$ | 131,737,833$ | 104,078,589$ |
| 9 | Golden Knights | 5500 | 4500 | 3000 | 3500 | 1000 | 88 | 58 | 38 | 18 | 220 | 59040 | 50215 | 35307 | 41135 | 10360 | 89.45% | 92.99% | 98.08% | 97.94% | 86.33% | 30 | 16338 - 93.36% | 1,579,922$ | 18,959,059$ | 17500 | 100 | 102,914,974$ | 102,914,974$ | 0$ | 29,306,064$ | 102,914,974$ | 28,478,464$ | 22 | 0 | 0$ | 47,397,648$ | 105 | 730,448$ | 76,697,040$ | 76,697,040$ | 102,914,974$ | 26,014,974$ | 104,000,000$ | 1,085,026$ | 125,932,509$ | 96,633,117$ |
| 10 | Jets | 4575 | 4375 | 3390 | 3375 | 800 | 100 | 60 | 40 | 25 | 300 | 49616 | 46990 | 35159 | 31595 | 7549 | 90.38% | 89.50% | 86.43% | 78.01% | 78.64% | 30 | 14242 - 86.24% | 1,520,040$ | 18,240,485$ | 16515 | 100 | 102,920,857$ | 102,920,857$ | 249,750$ | 28,945,406$ | 102,920,857$ | 28,428,166$ | 23 | 0 | 0$ | 45,601,212$ | 105 | 720,144$ | 75,615,120$ | 75,615,120$ | 103,170,607$ | 26,270,607$ | 104,000,000$ | 829,393$ | 220,399,603$ | 190,385,695$ |
| 11 | Kings | 5300 | 4300 | 4300 | 4418 | 1300 | 95 | 70 | 30 | 20 | 185 | 51389 | 39407 | 46719 | 39948 | 13712 | 80.80% | 76.37% | 90.54% | 75.35% | 87.90% | 30 | 15931 - 81.21% | 1,536,897$ | 18,442,766$ | 19618 | 100 | 101,975,000$ | 101,975,000$ | -2,437,500$ | 28,306,567$ | 101,975,000$ | 27,478,967$ | 23 | 0 | 0$ | 46,106,915$ | 105 | 723,966$ | 76,016,430$ | 76,016,430$ | 99,537,500$ | 22,637,500$ | 104,000,000$ | 4,462,500$ | -8,940,486$ | -38,850,001$ |
| 12 | Lightning | 6000 | 5000 | 5000 | 6000 | 1000 | 100 | 65 | 30 | 10 | 220 | 49470 | 43242 | 50463 | 58542 | 10377 | 68.71% | 72.07% | 84.10% | 81.31% | 86.48% | 30 | 17675 - 76.85% | 1,507,381$ | 18,088,569$ | 23000 | 100 | 95,150,100$ | 95,150,100$ | 5,750,000$ | 26,796,799$ | 95,150,100$ | 26,245,073$ | 22 | 0 | 0$ | 45,221,422$ | 105 | 670,001$ | 70,350,105$ | 70,350,105$ | 100,900,100$ | 24,000,100$ | 104,000,000$ | 3,099,900$ | 139,533,286$ | 114,404,603$ |
| 13 | Mammoth | 4000 | 4000 | 3500 | 3000 | 1700 | 71 | 60 | 35 | 15 | 150 | 44000 | 42135 | 38471 | 33000 | 13136 | 100.00% | 95.76% | 99.92% | 100.00% | 70.25% | 31 | 15522 - 95.81% | 1,281,940$ | 14,101,340$ | 16200 | 100 | 102,496,667$ | 102,496,667$ | -1,000,000$ | 29,314,303$ | 102,496,667$ | 28,486,728$ | 20 | 0 | 0$ | 39,740,140$ | 105 | 727,563$ | 76,394,115$ | 76,394,115$ | 101,496,667$ | 24,596,667$ | 104,000,000$ | 2,503,333$ | 219,586,017$ | 182,932,042$ |
| 14 | Maple Leafs | 6500 | 5600 | 3500 | 4800 | 1400 | 70 | 45 | 30 | 25 | 165 | 67176 | 58653 | 42000 | 31743 | 14043 | 86.12% | 87.28% | 100.00% | 55.11% | 83.59% | 30 | 17801 - 81.66% | 1,454,287$ | 17,451,438$ | 21800 | 100 | 104,954,583$ | 104,954,583$ | -7,000,000$ | 28,429,404$ | 104,954,583$ | 27,991,475$ | 26 | 0 | 0$ | 43,628,595$ | 105 | 737,618$ | 77,449,890$ | 77,449,890$ | 97,954,583$ | 21,054,583$ | 104,000,000$ | 6,045,417$ | 23,025,354$ | -10,795,941$ |
| 15 | Oilers | 6000 | 5000 | 2600 | 4000 | 1000 | 90 | 55 | 45 | 20 | 200 | 53776 | 54639 | 30461 | 40171 | 12000 | 74.69% | 91.07% | 97.63% | 83.69% | 100.00% | 30 | 15921 - 85.59% | 1,542,045$ | 18,504,534$ | 18600 | 100 | 69,033,333$ | 69,033,333$ | 21,750,000$ | 19,183,022$ | 69,033,333$ | 18,079,576$ | 24 | 0 | 0$ | 46,261,335$ | 105 | 503,678$ | 52,886,190$ | 52,886,190$ | 90,783,333$ | 13,883,333$ | 104,000,000$ | 13,216,667$ | 41,792,177$ | 35,167,322$ |
| 16 | Penguins | 6000 | 5000 | 3250 | 5000 | 1000 | 80 | 50 | 38 | 14 | 200 | 72467 | 62731 | 40674 | 56958 | 13000 | 92.91% | 96.51% | 96.27% | 87.63% | 100.00% | 29 | 18910 - 93.38% | 1,590,510$ | 20,676,632$ | 20250 | 100 | 114,762,499$ | 114,762,499$ | -11,000,000$ | 30,929,704$ | 114,762,499$ | 30,377,984$ | 20 | 0 | 0$ | 46,124,794$ | 105 | 805,259$ | 84,552,195$ | 84,552,195$ | 103,762,499$ | 26,862,499$ | 104,000,000$ | 237,501$ | 128,161,061$ | 89,733,660$ |
| 17 | Rangers | 6350 | 5500 | 4350 | 4000 | 2500 | 100 | 60 | 35 | 20 | 200 | 47557 | 46824 | 46445 | 40409 | 15000 | 62.41% | 70.95% | 88.98% | 84.19% | 50.00% | 30 | 16353 - 72.04% | 1,614,030$ | 19,368,354$ | 22700 | 100 | 111,433,274$ | 111,433,274$ | -9,750,000$ | 31,047,114$ | 111,433,274$ | 30,771,235$ | 24 | 0 | 0$ | 48,420,885$ | 105 | 775,402$ | 81,417,210$ | 81,417,210$ | 101,683,274$ | 24,783,274$ | 104,000,000$ | 2,316,726$ | 23,054,402$ | -9,941,923$ |
| 18 | Red Wings | 7000 | 5000 | 4500 | 5000 | 1500 | 65 | 55 | 25 | 10 | 85 | 64337 | 49399 | 44793 | 52198 | 13948 | 83.55% | 89.82% | 90.49% | 94.91% | 84.53% | 31 | 20425 - 88.80% | 1,351,128$ | 14,862,407$ | 23000 | 100 | 93,833,749$ | 93,833,749$ | -2,000,000$ | 29,590,047$ | 93,833,749$ | 28,624,527$ | 22 | 0 | 0$ | 41,884,965$ | 105 | 671,267$ | 70,483,035$ | 70,483,035$ | 91,833,749$ | 14,933,749$ | 104,000,000$ | 12,166,251$ | 139,514,761$ | 110,916,691$ |
| 19 | Senators | 6000 | 5000 | 2652 | 4000 | 1000 | 81 | 43 | 42 | 17 | 190 | 67742 | 57375 | 31690 | 47787 | 12000 | 94.09% | 95.63% | 99.58% | 99.56% | 100.00% | 30 | 18050 - 96.77% | 1,536,884$ | 18,442,603$ | 18652 | 100 | 102,950,000$ | 102,950,000$ | 0$ | 29,042,770$ | 102,950,000$ | 28,532,411$ | 22 | 0 | 0$ | 46,106,508$ | 105 | 722,759$ | 75,889,695$ | 75,889,695$ | 102,950,000$ | 26,050,000$ | 104,000,000$ | 1,050,000$ | -11,552,065$ | -41,335,252$ |
| 20 | Sharks | 6000 | 5000 | 4000 | 4000 | 1000 | 125 | 105 | 75 | 45 | 400 | 39328 | 30000 | 24000 | 24000 | 6046 | 54.62% | 50.00% | 50.00% | 50.00% | 50.38% | 30 | 10281 - 51.41% | 1,659,413$ | 19,912,956$ | 20000 | 100 | 98,214,280$ | 98,214,280$ | 0$ | 27,639,121$ | 98,214,280$ | 26,811,521$ | 21 | 0 | 0$ | 49,782,390$ | 105 | 698,030$ | 73,293,150$ | 73,293,150$ | 98,214,280$ | 21,314,280$ | 104,000,000$ | 5,785,720$ | 10,091,851$ | -13,418,909$ |