| 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é | 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é | Popularité de l’équipe | Salaire total des joueurs | Salaire total moyen 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 40,000,000$ | Plafond salarial maximum | Plafond salarial disponible | Compte bancaire actuel | Compte bancaire projeté |
| 1 | Anaheim | 8333 | 6944 | 2778 | 5556 | 1389 | 85 | 61 | 45 | 30 | 173 | 259281 | 232330 | 102433 | 198290 | 43560 | 75.89% | 81.60% | 89.93% | 87.05% | 76.49% | 0 | 20388 - 81.55% | 1,788,094$ | 73,311,857$ | 25000 | 100 | 60,590,000$ | 60,590,000$ | 337,066$ | 66,514,282$ | 307,563$ | 62,875,867$ | 20 | 0 | 0$ | 0$ | 0 | 325,330$ | 0$ | 0$ | 63,212,933$ | 23,212,933$ | 65,000,000$ | 1,787,067$ | 11,984,902$ | 11,984,902$ |
| 2 | Arizona | 6500 | 5000 | 2000 | 4000 | 1000 | 87 | 56 | 43 | 32 | 175 | 256382 | 205000 | 82000 | 159848 | 40831 | 96.20% | 100.00% | 100.00% | 97.47% | 99.59% | 0 | 18148 - 98.10% | 1,632,242$ | 66,921,923$ | 18500 | 100 | 64,650,000$ | 64,650,000$ | 0$ | 68,051,767$ | 314,102$ | 60,073,637$ | 22 | 0 | 0$ | 0$ | 0 | 345,939$ | 0$ | 0$ | 60,073,637$ | 20,073,637$ | 65,000,000$ | 4,926,363$ | 29,637,415$ | 29,637,415$ |
| 3 | Boston | 7000 | 6000 | 2778 | 4500 | 1000 | 80 | 50 | 40 | 25 | 160 | 262469 | 235086 | 105139 | 184500 | 40934 | 91.45% | 95.56% | 92.31% | 100.00% | 99.84% | 0 | 20198 - 94.93% | 1,584,417$ | 64,961,080$ | 21278 | 100 | 64,700,000$ | 64,400,000$ | 2,400,000$ | 67,345,437$ | 319,617$ | 62,202,545$ | 21 | 0 | 0$ | 0$ | 0 | 346,193$ | 0$ | 0$ | 64,602,545$ | 24,602,545$ | 65,000,000$ | 397,455$ | 4,996,876$ | 4,996,876$ |
| 4 | Buffalo | 6000 | 5000 | 2000 | 4000 | 1000 | 87 | 62 | 42 | 32 | 165 | 244219 | 205000 | 82000 | 159321 | 40926 | 99.28% | 100.00% | 100.00% | 97.15% | 99.82% | 0 | 17841 - 99.11% | 1,598,151$ | 65,524,189$ | 18000 | 100 | 56,256,000$ | 56,256,000$ | 3,035,558$ | 62,181,075$ | 275,251$ | 58,673,634$ | 22 | 0 | 0$ | 0$ | 0 | 290,132$ | 0$ | 0$ | 61,709,192$ | 21,709,192$ | 65,000,000$ | 3,290,808$ | 13,001,124$ | 13,001,124$ |
| 5 | Chicago | 7200 | 6944 | 2778 | 5556 | 1389 | 98 | 79 | 60 | 45 | 188 | 193002 | 155458 | 64683 | 115268 | 34248 | 65.38% | 54.60% | 56.79% | 50.60% | 60.14% | 0 | 13723 - 57.50% | 1,537,750$ | 63,047,755$ | 23867 | 100 | 64,875,000$ | 64,875,000$ | 1,200,000$ | 67,796,260$ | 309,213$ | 62,117,525$ | 21 | 1 | 0$ | 0$ | 0 | 342,665$ | 0$ | 0$ | 63,317,525$ | 23,317,525$ | 65,000,000$ | 1,682,475$ | 22,608,365$ | 22,608,365$ |
| 6 | Columbus | 6500 | 6944 | 2778 | 5556 | 1000 | 85 | 58 | 45 | 25 | 180 | 249916 | 230248 | 101237 | 205045 | 35307 | 93.78% | 80.87% | 88.88% | 90.01% | 86.11% | 0 | 20043 - 87.99% | 1,686,160$ | 69,132,566$ | 22778 | 100 | 53,346,000$ | 53,346,000$ | 4,965,000$ | 55,882,392$ | 260,640$ | 51,606,673$ | 21 | 1 | 0$ | 0$ | 0 | 291,096$ | 0$ | 0$ | 56,571,673$ | 16,571,673$ | 65,000,000$ | 8,428,327$ | 20,578,860$ | 20,578,860$ |
| 7 | Dallas | 7233 | 6944 | 2778 | 5556 | 1389 | 80 | 60 | 40 | 20 | 130 | 256872 | 224507 | 103422 | 212431 | 46109 | 86.62% | 78.86% | 90.80% | 93.25% | 80.97% | 0 | 20569 - 86.06% | 1,626,392$ | 66,682,065$ | 23900 | 100 | 48,297,002$ | 48,297,002$ | 0$ | 57,743,131$ | 220,036$ | 54,901,494$ | 20 | 1 | 0$ | 0$ | 0 | 256,584$ | 0$ | 0$ | 54,901,494$ | 14,901,494$ | 65,000,000$ | 10,098,506$ | 12,724,207$ | 12,724,207$ |
| 8 | Detroit | 6000 | 5000 | 2000 | 4000 | 1000 | 90 | 63 | 46 | 28 | 148 | 202224 | 193893 | 79610 | 163135 | 40706 | 82.20% | 94.58% | 97.09% | 99.47% | 99.28% | 0 | 16575 - 92.08% | 1,521,816$ | 62,394,453$ | 18000 | 100 | 70,185,000$ | 70,185,000$ | 0$ | 71,806,336$ | 352,751$ | 65,032,092$ | 22 | 0 | 0$ | 0$ | 0 | 379,112$ | 0$ | 0$ | 65,032,092$ | 25,032,092$ | 65,000,000$ | -32,092$ | -11,355,989$ | -11,355,989$ |
| 9 | Edmonton | 8333 | 6944 | 2778 | 5556 | 1389 | 92 | 65 | 52 | 39 | 190 | 206479 | 191503 | 76443 | 131323 | 33672 | 60.44% | 67.26% | 67.12% | 57.65% | 59.13% | 0 | 15596 - 62.38% | 1,545,522$ | 63,366,403$ | 25000 | 100 | 55,895,000$ | 55,895,000$ | 0$ | 61,067,107$ | 277,701$ | 54,914,059$ | 23 | 0 | 0$ | 0$ | 0 | 309,112$ | 0$ | 0$ | 54,914,059$ | 14,914,059$ | 65,000,000$ | 10,085,941$ | 84,307,579$ | 84,307,579$ |
| 10 | Floride | 6000 | 5100 | 2778 | 5556 | 1000 | 85 | 60 | 40 | 30 | 175 | 244587 | 209100 | 103447 | 199710 | 40834 | 99.43% | 100.00% | 90.82% | 87.67% | 99.60% | 0 | 19456 - 95.21% | 1,666,461$ | 68,324,886$ | 20434 | 100 | 61,090,000$ | 61,090,000$ | 1,474,000$ | 65,570,395$ | 283,467$ | 58,026,803$ | 23 | 0 | 0$ | 0$ | 0 | 322,284$ | 0$ | 0$ | 59,500,803$ | 19,500,803$ | 65,000,000$ | 5,499,197$ | 8,117,569$ | 8,117,569$ |
| 11 | LosAngeles | 6000 | 5000 | 2000 | 4000 | 1000 | 96 | 70 | 50 | 34 | 185 | 197562 | 176237 | 79084 | 153750 | 34644 | 80.31% | 85.97% | 96.44% | 93.75% | 84.50% | 0 | 15641 - 86.89% | 1,540,764$ | 63,171,317$ | 18000 | 100 | 64,920,001$ | 64,920,001$ | 0$ | 65,315,155$ | 323,965$ | 59,409,380$ | 22 | 0 | 0$ | 0$ | 0 | 351,371$ | 0$ | 0$ | 59,409,380$ | 19,409,380$ | 65,000,000$ | 5,590,620$ | 2,870,413$ | 2,870,413$ |
| 12 | Minnesota | 6000 | 5000 | 2000 | 4000 | 1000 | 80 | 60 | 50 | 30 | 175 | 244684 | 205000 | 77335 | 164000 | 40813 | 99.47% | 100.00% | 94.31% | 100.00% | 99.54% | 0 | 17850 - 99.16% | 1,574,026$ | 64,535,058$ | 18000 | 100 | 59,472,000$ | 56,772,000$ | 1,875,000$ | 64,499,814$ | 288,183$ | 57,079,899$ | 20 | 0 | 0$ | 0$ | 0 | 319,655$ | 0$ | 0$ | 58,954,899$ | 18,954,899$ | 65,000,000$ | 6,045,101$ | 3,810,397$ | 3,810,397$ |
| 13 | Montreal | 6415 | 5870 | 2778 | 5556 | 1145 | 90 | 65 | 55 | 35 | 220 | 215289 | 189580 | 71243 | 151686 | 29568 | 81.85% | 78.77% | 62.55% | 66.59% | 62.98% | 0 | 16033 - 73.67% | 1,559,327$ | 63,932,411$ | 21764 | 100 | 69,155,000$ | 69,155,000$ | 525,000$ | 72,571,299$ | 328,426$ | 62,278,711$ | 23 | 1 | 0$ | 0$ | 0 | 364,239$ | 0$ | 0$ | 62,803,711$ | 22,803,711$ | 65,000,000$ | 2,196,289$ | 17,168,682$ | 17,168,682$ |
| 14 | NYRangers | 7000 | 6000 | 2778 | 5556 | 1389 | 125 | 80 | 60 | 45 | 220 | 153994 | 153655 | 65300 | 116306 | 28571 | 53.66% | 62.46% | 57.33% | 51.06% | 50.17% | 0 | 12630 - 55.58% | 1,546,871$ | 63,421,706$ | 22723 | 100 | 59,950,000$ | 59,950,000$ | 0$ | 67,043,628$ | 304,315$ | 62,452,463$ | 20 | 0 | 0$ | 0$ | 0 | 325,888$ | 0$ | 0$ | 62,452,463$ | 22,452,463$ | 65,000,000$ | 2,547,537$ | 17,949,669$ | 17,949,669$ |
| 15 | Nashville | 7000 | 6944 | 2778 | 5556 | 1100 | 80 | 65 | 50 | 22 | 184 | 256048 | 185618 | 77604 | 210686 | 34557 | 89.22% | 65.20% | 68.13% | 92.49% | 76.62% | 0 | 18647 - 79.76% | 1,572,843$ | 64,486,548$ | 23378 | 100 | 56,558,000$ | 56,558,000$ | 0$ | 62,128,409$ | 283,076$ | 59,836,925$ | 22 | 1 | 0$ | 0$ | 0 | 294,711$ | 0$ | 0$ | 59,836,925$ | 19,836,925$ | 65,000,000$ | 5,163,075$ | 41,179,332$ | 41,179,332$ |
| 16 | New Jersey | 6000 | 6000 | 2778 | 5556 | 1000 | 86 | 58 | 34 | 22 | 180 | 243806 | 236088 | 108591 | 212952 | 35780 | 99.11% | 95.97% | 95.34% | 93.48% | 87.27% | 0 | 20420 - 95.72% | 1,631,103$ | 66,875,234$ | 21334 | 100 | 60,000,000$ | 60,000,000$ | 0$ | 64,712,105$ | 304,569$ | 60,971,685$ | 23 | 0 | 0$ | 0$ | 0 | 322,335$ | 0$ | 0$ | 60,971,685$ | 20,971,685$ | 65,000,000$ | 4,028,315$ | 16,686,582$ | 16,686,582$ |
| 17 | Philadelphie | 6250 | 5500 | 2778 | 5556 | 1000 | 85 | 60 | 39 | 28 | 176 | 250059 | 223294 | 104482 | 202739 | 39481 | 97.58% | 99.02% | 91.73% | 89.00% | 96.30% | 0 | 20001 - 94.87% | 1,688,270$ | 69,219,073$ | 21084 | 100 | 66,288,000$ | 66,288,000$ | 1,065,000$ | 66,120,906$ | 336,487$ | 62,929,750$ | 21 | 0 | 0$ | 0$ | 0 | 352,604$ | 0$ | 0$ | 63,994,750$ | 23,994,750$ | 65,000,000$ | 1,005,250$ | 17,403,366$ | 17,403,366$ |
| 18 | Pittsburgh | 6200 | 5400 | 2600 | 4800 | 1075 | 89 | 63 | 38 | 30 | 187 | 225320 | 200597 | 102234 | 189320 | 33246 | 88.64% | 90.60% | 95.90% | 96.20% | 75.43% | 0 | 18310 - 91.21% | 1,624,902$ | 66,620,997$ | 20075 | 100 | 62,017,500$ | 63,017,500$ | 425,216$ | 67,953,406$ | 319,886$ | 63,724,047$ | 22 | 0 | 0$ | 0$ | 0 | 330,038$ | 0$ | 0$ | 64,149,263$ | 24,149,263$ | 65,000,000$ | 850,737$ | 19,930,911$ | 19,930,911$ |
| 19 | San Jose | 6000 | 5666 | 2778 | 5556 | 1000 | 85 | 56 | 43 | 32 | 170 | 245450 | 230625 | 103310 | 169542 | 40905 | 99.78% | 99.28% | 90.70% | 74.43% | 99.77% | 0 | 19264 - 91.73% | 1,666,090$ | 68,309,694$ | 21000 | 100 | 63,870,000$ | 63,870,000$ | 550,000$ | 64,576,216$ | 324,213$ | 62,562,953$ | 21 | 0 | 0$ | 0$ | 0 | 334,365$ | 0$ | 0$ | 63,112,953$ | 23,112,953$ | 65,000,000$ | 1,887,047$ | 15,043,537$ | 15,043,537$ |
| 20 | St. Louis | 6400 | 5810 | 2778 | 5200 | 1210 | 75 | 59 | 35 | 29 | 142 | 256690 | 229214 | 106315 | 199833 | 45662 | 97.82% | 96.22% | 93.34% | 93.73% | 92.04% | 0 | 20432 - 95.49% | 1,585,970$ | 65,024,775$ | 21398 | 100 | 48,799,000$ | 48,799,000$ | 1,000,000$ | 60,281,052$ | 232,946$ | 54,796,322$ | 26 | 0 | 0$ | 0$ | 0 | 258,371$ | 0$ | 0$ | 55,796,322$ | 15,796,322$ | 65,000,000$ | 9,203,678$ | 22,008,914$ | 22,008,914$ |
| 21 | Toronto | 6500 | 6944 | 2778 | 5556 | 1389 | 85 | 48 | 39 | 28 | 165 | 248799 | 230617 | 98569 | 194951 | 43036 | 93.36% | 81.00% | 86.54% | 85.58% | 75.57% | 0 | 19902 - 85.91% | 1,644,948$ | 67,442,874$ | 23167 | 100 | 68,900,000$ | 68,900,000$ | 1,582,500$ | 67,130,077$ | 349,746$ | 63,516,774$ | 20 | 0 | 0$ | 0$ | 0 | 367,513$ | 0$ | 0$ | 65,099,274$ | 25,099,274$ | 65,000,000$ | -99,274$ | 13,025,042$ | 13,025,042$ |
| 22 | Vancouver | 7000 | 6135 | 2778 | 5556 | 1089 | 110 | 80 | 55 | 45 | 200 | 173058 | 151011 | 70609 | 116508 | 32563 | 60.30% | 60.04% | 61.99% | 51.15% | 72.93% | 0 | 13262 - 58.79% | 1,539,534$ | 63,120,888$ | 22558 | 100 | 56,140,000$ | 56,140,000$ | 0$ | 57,094,548$ | 284,975$ | 54,932,118$ | 23 | 0 | 0$ | 0$ | 0 | 295,127$ | 0$ | 0$ | 54,932,118$ | 14,932,118$ | 65,000,000$ | 10,067,882$ | 9,397,310$ | 9,397,310$ |
| 23 | Washington | 6000 | 5326 | 2778 | 5556 | 1000 | 75 | 59 | 36 | 29 | 160 | 208178 | 172246 | 77651 | 141977 | 36163 | 84.63% | 78.88% | 68.18% | 62.33% | 88.20% | 0 | 15517 - 75.11% | 1,553,867$ | 63,708,555$ | 20660 | 100 | 72,792,500$ | 72,792,500$ | 900,000$ | 67,355,506$ | 353,926$ | 64,003,326$ | 24 | 0 | 0$ | 0$ | 0 | 377,119$ | 0$ | 0$ | 64,903,326$ | 24,903,326$ | 65,000,000$ | 96,674$ | 3,117,115$ | 3,117,115$ |
| 24 | Winnipeg | 6000 | 6000 | 2778 | 4000 | 1000 | 87 | 65 | 54 | 32 | 175 | 244289 | 191099 | 73248 | 160784 | 40774 | 99.30% | 77.68% | 64.31% | 98.04% | 99.45% | 0 | 17322 - 87.58% | 1,643,395$ | 67,379,187$ | 19778 | 100 | 63,350,000$ | 63,350,000$ | 2,100,000$ | 65,757,890$ | 317,553$ | 62,514,468$ | 22 | 0 | 0$ | 0$ | 0 | 328,680$ | 0$ | 0$ | 64,614,468$ | 24,614,468$ | 65,000,000$ | 385,532$ | 33,969,674$ | 33,969,674$ |