| 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 | 98 | 73 | 58 | 41 | 191 | 58207 | 51798 | 22171 | 40017 | 10179 | 77.61% | 82.88% | 88.68% | 80.03% | 81.43% | 32 | 20264 - 81.05% | 2,077,972$ | 18,701,750$ | 25000 | 100 | 60,590,000$ | 60,590,000$ | 337,066$ | 0$ | 0$ | 0$ | 20 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -40,000,000$ | 65,000,000$ | 65,000,000$ | 30,991,496$ | 30,991,496$ |
| 2 | Arizona | 6500 | 5000 | 2000 | 4000 | 1000 | 87 | 56 | 43 | 32 | 175 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 41 | 0 - 0.00% | 0$ | 0$ | 18500 | 100 | 64,650,000$ | 64,650,000$ | 0$ | 0$ | 0$ | 0$ | 22 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -40,000,000$ | 65,000,000$ | 65,000,000$ | 29,637,415$ | 29,637,415$ |
| 3 | Boston | 7000 | 6000 | 2778 | 4500 | 1000 | 80 | 50 | 40 | 25 | 160 | 26850 | 23966 | 11112 | 18000 | 4000 | 95.89% | 99.86% | 100.00% | 100.00% | 100.00% | 37 | 20982 - 98.61% | 1,647,263$ | 6,589,053$ | 21278 | 100 | 60,200,000$ | 59,900,000$ | 2,400,000$ | 0$ | 0$ | 0$ | 22 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -40,000,000$ | 65,000,000$ | 65,000,000$ | 12,521,559$ | 12,521,559$ |
| 4 | Buffalo | 6000 | 5000 | 2000 | 4000 | 1000 | 87 | 62 | 42 | 32 | 165 | 12000 | 10000 | 4000 | 8000 | 2000 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 39 | 18000 - 100.00% | 1,632,150$ | 3,264,300$ | 18000 | 100 | 58,006,000$ | 58,006,000$ | 3,035,558$ | 0$ | 0$ | 0$ | 23 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -40,000,000$ | 65,000,000$ | 65,000,000$ | 16,880,713$ | 16,880,713$ |
| 5 | Chicago | 7200 | 6944 | 2778 | 5556 | 1389 | 98 | 79 | 60 | 45 | 188 | 29540 | 24413 | 10413 | 17591 | 5183 | 82.06% | 70.31% | 74.97% | 63.32% | 74.63% | 36 | 17428 - 73.02% | 1,947,868$ | 9,739,339$ | 23867 | 100 | 67,275,000$ | 67,275,000$ | 1,200,000$ | 0$ | 0$ | 0$ | 23 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -40,000,000$ | 65,000,000$ | 65,000,000$ | 32,654,936$ | 32,654,936$ |
| 6 | Columbus | 6500 | 6944 | 2778 | 5556 | 1000 | 85 | 58 | 45 | 25 | 180 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 41 | 0 - 0.00% | 0$ | 0$ | 22778 | 100 | 53,346,000$ | 53,346,000$ | 4,965,000$ | 0$ | 0$ | 0$ | 22 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -40,000,000$ | 65,000,000$ | 65,000,000$ | 21,029,788$ | 21,029,788$ |
| 7 | Dallas | 7233 | 6944 | 2778 | 5556 | 1389 | 80 | 60 | 40 | 20 | 130 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 41 | 0 - 0.00% | 0$ | 0$ | 23900 | 100 | 48,900,002$ | 48,900,002$ | 0$ | 0$ | 0$ | 0$ | 21 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -40,000,000$ | 65,000,000$ | 65,000,000$ | 13,701,081$ | 13,701,081$ |
| 8 | Detroit | 6000 | 5000 | 2000 | 4000 | 1000 | 125 | 80 | 60 | 45 | 220 | 75901 | 65000 | 26000 | 52000 | 13000 | 97.31% | 100.00% | 100.00% | 100.00% | 100.00% | 28 | 17839 - 99.10% | 1,988,638$ | 25,852,290$ | 18000 | 100 | 72,565,000$ | 72,565,000$ | 0$ | 0$ | 0$ | 0$ | 24 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -40,000,000$ | 65,000,000$ | 65,000,000$ | 14,877,001$ | 14,877,001$ |
| 9 | Edmonton | 8333 | 6944 | 2778 | 5556 | 1389 | 92 | 65 | 52 | 39 | 190 | 11605 | 9827 | 4101 | 7168 | 1820 | 69.63% | 70.76% | 73.81% | 64.51% | 65.51% | 39 | 17261 - 69.04% | 1,717,888$ | 3,435,776$ | 25000 | 100 | 55,895,000$ | 55,895,000$ | 0$ | 0$ | 0$ | 0$ | 23 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -40,000,000$ | 65,000,000$ | 65,000,000$ | 88,378,772$ | 88,378,772$ |
| 10 | Floride | 6000 | 5100 | 2778 | 5556 | 1000 | 85 | 60 | 40 | 30 | 175 | 36000 | 30600 | 16477 | 32478 | 6000 | 100.00% | 100.00% | 98.85% | 97.43% | 100.00% | 35 | 20259 - 99.14% | 1,705,370$ | 10,232,217$ | 20434 | 100 | 61,090,000$ | 61,090,000$ | 1,474,000$ | 0$ | 0$ | 0$ | 23 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -40,000,000$ | 65,000,000$ | 65,000,000$ | 20,360,800$ | 20,360,800$ |
| 11 | LosAngeles | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 78 | 58 | 40 | 200 | 21643 | 17905 | 7892 | 14471 | 3789 | 90.18% | 89.53% | 98.65% | 90.44% | 94.73% | 37 | 16425 - 91.25% | 1,767,396$ | 7,069,585$ | 18000 | 100 | 63,420,001$ | 63,420,001$ | 0$ | 0$ | 0$ | 0$ | 21 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -40,000,000$ | 65,000,000$ | 65,000,000$ | 11,235,728$ | 11,235,728$ |
| 12 | Minnesota | 6000 | 5000 | 2000 | 4000 | 1000 | 80 | 60 | 50 | 30 | 175 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 41 | 0 - 0.00% | 0$ | 0$ | 18000 | 100 | 59,472,000$ | 56,772,000$ | 1,875,000$ | 0$ | 0$ | 0$ | 20 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -40,000,000$ | 65,000,000$ | 65,000,000$ | 3,810,397$ | 3,810,397$ |
| 13 | Montreal | 6415 | 5870 | 2778 | 5556 | 1145 | 90 | 65 | 55 | 35 | 220 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 41 | 0 - 0.00% | 0$ | 0$ | 21764 | 100 | 69,755,000$ | 69,755,000$ | 525,000$ | 0$ | 0$ | 0$ | 24 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -40,000,000$ | 65,000,000$ | 65,000,000$ | 17,168,682$ | 17,168,682$ |
| 14 | NYRangers | 7000 | 6000 | 2778 | 5556 | 1389 | 125 | 80 | 60 | 45 | 220 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 41 | 0 - 0.00% | 0$ | 0$ | 22723 | 100 | 59,950,000$ | 59,950,000$ | 0$ | 0$ | 0$ | 0$ | 20 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -40,000,000$ | 65,000,000$ | 65,000,000$ | 17,949,669$ | 17,949,669$ |
| 15 | Nashville | 7000 | 6944 | 2778 | 5556 | 1100 | 80 | 65 | 50 | 22 | 184 | 20504 | 16229 | 6263 | 16311 | 3031 | 97.64% | 77.90% | 75.15% | 97.86% | 91.85% | 38 | 20779 - 88.88% | 1,766,205$ | 5,298,616$ | 23378 | 100 | 60,558,000$ | 60,558,000$ | 0$ | 0$ | 0$ | 0$ | 23 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -40,000,000$ | 65,000,000$ | 65,000,000$ | 46,918,008$ | 46,918,008$ |
| 16 | New Jersey | 6000 | 6000 | 2778 | 5556 | 1000 | 86 | 58 | 34 | 22 | 180 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 41 | 0 - 0.00% | 0$ | 0$ | 21334 | 100 | 60,000,000$ | 60,000,000$ | 0$ | 0$ | 0$ | 0$ | 23 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -40,000,000$ | 65,000,000$ | 65,000,000$ | 17,115,882$ | 17,115,882$ |
| 17 | Philadelphie | 6250 | 5500 | 2778 | 5556 | 1000 | 88 | 68 | 46 | 32 | 196 | 18577 | 14974 | 7676 | 12825 | 2779 | 99.08% | 90.75% | 92.10% | 76.94% | 92.63% | 38 | 18944 - 89.85% | 1,804,162$ | 5,412,487$ | 21084 | 100 | 66,288,000$ | 66,288,000$ | 1,065,000$ | 0$ | 0$ | 0$ | 21 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -40,000,000$ | 65,000,000$ | 65,000,000$ | 23,782,224$ | 23,782,224$ |
| 18 | Pittsburgh | 6200 | 5400 | 2600 | 4800 | 1075 | 89 | 63 | 38 | 30 | 187 | 12400 | 10800 | 5200 | 9600 | 1962 | 100.00% | 100.00% | 100.00% | 100.00% | 91.26% | 39 | 19981 - 99.53% | 1,779,634$ | 3,559,267$ | 20075 | 100 | 62,017,500$ | 63,017,500$ | 425,216$ | 0$ | 0$ | 0$ | 22 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -40,000,000$ | 65,000,000$ | 65,000,000$ | 23,490,178$ | 23,490,178$ |
| 19 | San Jose | 6000 | 5666 | 2778 | 5556 | 1000 | 125 | 80 | 60 | 45 | 220 | 64784 | 61293 | 27891 | 55267 | 10883 | 98.16% | 98.34% | 91.27% | 90.43% | 98.94% | 30 | 20011 - 95.29% | 2,136,251$ | 23,498,766$ | 21000 | 100 | 65,795,000$ | 65,795,000$ | 550,000$ | 0$ | 0$ | 0$ | 22 | 1 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -40,000,000$ | 65,000,000$ | 65,000,000$ | 38,994,283$ | 38,994,283$ |
| 20 | St. Louis | 6400 | 5810 | 2778 | 5200 | 1210 | 75 | 59 | 35 | 29 | 142 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 41 | 0 - 0.00% | 0$ | 0$ | 21398 | 100 | 48,799,000$ | 48,799,000$ | 1,000,000$ | 0$ | 0$ | 0$ | 26 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -40,000,000$ | 65,000,000$ | 65,000,000$ | 23,568,164$ | 23,568,164$ |
| 21 | Toronto | 6500 | 6944 | 2778 | 5556 | 1389 | 125 | 80 | 60 | 45 | 220 | 50766 | 49759 | 21282 | 39715 | 9498 | 86.78% | 79.62% | 85.12% | 79.42% | 75.98% | 32 | 19002 - 82.02% | 2,117,693$ | 19,059,236$ | 23167 | 100 | 71,979,999$ | 71,979,999$ | 1,582,500$ | 0$ | 0$ | 0$ | 23 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -40,000,000$ | 65,000,000$ | 65,000,000$ | 32,084,278$ | 32,084,278$ |
| 22 | Vancouver | 7000 | 6135 | 2778 | 5556 | 1089 | 125 | 80 | 60 | 45 | 220 | 23664 | 23418 | 10215 | 17792 | 4448 | 67.61% | 76.34% | 73.54% | 64.05% | 81.69% | 36 | 15907 - 70.52% | 1,950,356$ | 9,751,779$ | 22558 | 100 | 55,240,000$ | 55,240,000$ | 0$ | 0$ | 0$ | 0$ | 22 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -40,000,000$ | 65,000,000$ | 65,000,000$ | 19,149,089$ | 19,149,089$ |
| 23 | Washington | 6000 | 5326 | 2778 | 5556 | 1000 | 75 | 59 | 36 | 29 | 160 | 36000 | 31956 | 16622 | 32919 | 6000 | 100.00% | 100.00% | 99.72% | 98.75% | 100.00% | 35 | 20583 - 99.63% | 1,597,151$ | 9,582,903$ | 20660 | 100 | 72,242,500$ | 72,242,500$ | 900,000$ | 0$ | 0$ | 0$ | 23 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -40,000,000$ | 65,000,000$ | 65,000,000$ | 13,353,364$ | 13,353,364$ |
| 24 | Winnipeg | 6000 | 6000 | 2778 | 4000 | 1000 | 87 | 65 | 54 | 32 | 175 | 18000 | 15800 | 6104 | 12000 | 3000 | 100.00% | 87.78% | 73.24% | 100.00% | 100.00% | 38 | 18301 - 92.53% | 1,724,227$ | 5,172,682$ | 19778 | 100 | 64,250,000$ | 64,250,000$ | 2,100,000$ | 0$ | 0$ | 0$ | 23 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -40,000,000$ | 65,000,000$ | 65,000,000$ | 39,142,356$ | 39,142,356$ |