| 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 40,000,000$ | Cap Salarial Maximum | Cap Salarial Disponible | Compte Bancaire Actuel | Compte Bancaire Projeté |
| 1 | Avalanche | 6000 | 5000 | 3500 | 2000 | 1500 | 93 | 81 | 69 | 52 | 115 | 239360 | 199939 | 110761 | 82000 | 57244 | 97.30% | 97.53% | 77.19% | 100.00% | 93.08% | 0 | 16812 - 93.40% | 1,271,070$ | 52,113,875$ | 18000 | 100 | 63,344,000$ | 1,375,000$ | 0$ | 65,458,407$ | 324,841$ | 60,458,412$ | 21 | 0 | 0$ | 0$ | 0 | 350,482$ | 0$ | 0$ | 60,458,412$ | 20,458,412$ | 85,000,000$ | 24,541,588$ | 34,805,523$ | 34,805,523$ |
| 2 | Blackhawks | 6000 | 5500 | 2700 | 4000 | 1800 | 95 | 86 | 71 | 55 | 120 | 230684 | 164924 | 100304 | 113081 | 58719 | 93.77% | 73.14% | 90.61% | 68.95% | 79.57% | 0 | 16286 - 81.43% | 1,235,416$ | 50,652,046$ | 20000 | 100 | 69,975,000$ | 5,575,000$ | 0$ | 70,493,000$ | 358,846$ | 69,692,922$ | 20 | 0 | 0$ | 0$ | 0 | 362,949$ | 0$ | 0$ | 69,692,922$ | 29,692,922$ | 85,000,000$ | 15,307,078$ | 24,290,363$ | 24,290,363$ |
| 3 | Blues | 7000 | 5000 | 3000 | 3000 | 2000 | 89 | 78 | 61 | 50 | 115 | 253915 | 199196 | 120537 | 114592 | 57676 | 88.47% | 97.17% | 98.00% | 93.16% | 70.34% | 0 | 18193 - 90.97% | 1,290,726$ | 52,919,780$ | 20000 | 100 | 63,900,000$ | 3,475,000$ | 0$ | 66,865,210$ | 327,692$ | 65,215,254$ | 20 | 1 | 0$ | 0$ | 0 | 336,154$ | 0$ | 0$ | 65,215,254$ | 25,215,254$ | 85,000,000$ | 19,784,746$ | 23,175,492$ | 23,175,492$ |
| 4 | Bruins | 6700 | 5900 | 3500 | 2400 | 1500 | 95 | 83 | 71 | 59 | 120 | 239134 | 183493 | 104209 | 90170 | 58303 | 87.05% | 75.85% | 72.62% | 91.64% | 94.80% | 0 | 16471 - 82.35% | 1,285,777$ | 52,716,857$ | 20000 | 100 | 74,700,000$ | 0$ | 0$ | 69,303,278$ | 383,077$ | 67,303,174$ | 24 | 0 | 0$ | 0$ | 0 | 393,333$ | 0$ | 0$ | 67,303,174$ | 27,303,174$ | 85,000,000$ | 17,696,826$ | 28,023,866$ | 28,023,866$ |
| 5 | Canadiens | 6500 | 5000 | 3000 | 2000 | 1500 | 105 | 93 | 76 | 62 | 120 | 192040 | 152297 | 94957 | 81006 | 57107 | 72.06% | 74.29% | 77.20% | 98.79% | 92.86% | 0 | 14083 - 78.24% | 1,172,193$ | 48,059,897$ | 18000 | 100 | 74,550,000$ | 7,975,000$ | 0$ | 74,927,168$ | 382,308$ | 74,277,224$ | 20 | 0 | 0$ | 0$ | 0 | 385,641$ | 0$ | 0$ | 74,277,224$ | 34,277,224$ | 85,000,000$ | 10,722,776$ | 60,968,456$ | 60,968,456$ |
| 6 | Canucks | 7000 | 5400 | 2400 | 4000 | 1200 | 85 | 72 | 63 | 54 | 125 | 257212 | 207049 | 98400 | 116416 | 49200 | 89.62% | 93.52% | 100.00% | 70.99% | 100.00% | 0 | 17763 - 88.81% | 1,211,811$ | 49,684,241$ | 20000 | 100 | 54,869,167$ | 6,144,167$ | 0$ | 54,653,729$ | 281,380$ | 52,653,794$ | 21 | 0 | 0$ | 0$ | 0 | 291,637$ | 0$ | 0$ | 52,653,794$ | 12,653,794$ | 85,000,000$ | 32,346,206$ | 44,641,145$ | 44,641,145$ |
| 7 | Capitals | 7300 | 5700 | 2800 | 2000 | 1600 | 95 | 84 | 75 | 63 | 120 | 241573 | 182396 | 98537 | 81171 | 60423 | 80.71% | 78.05% | 85.83% | 98.99% | 92.11% | 0 | 16198 - 83.49% | 1,269,792$ | 52,061,482$ | 19400 | 100 | 69,800,000$ | 575,000$ | 0$ | 68,100,603$ | 357,949$ | 67,325,673$ | 20 | 0 | 0$ | 0$ | 0 | 361,923$ | 0$ | 0$ | 67,325,673$ | 27,325,673$ | 85,000,000$ | 17,674,327$ | 52,164,874$ | 52,164,874$ |
| 8 | Devils | 6700 | 5700 | 4000 | 2200 | 1300 | 97 | 82 | 71 | 59 | 115 | 204512 | 194501 | 103126 | 86591 | 53243 | 74.45% | 83.23% | 62.88% | 96.00% | 99.89% | 0 | 15658 - 78.68% | 1,187,837$ | 48,701,299$ | 19900 | 100 | 62,725,000$ | 2,075,000$ | 0$ | 68,897,337$ | 321,667$ | 63,697,328$ | 20 | 0 | 0$ | 0$ | 0 | 348,333$ | 0$ | 0$ | 63,697,328$ | 23,697,328$ | 85,000,000$ | 21,302,672$ | 9,795,391$ | 9,795,391$ |
| 9 | Ducks | 6500 | 5500 | 3500 | 1500 | 1500 | 91 | 79 | 65 | 58 | 125 | 243166 | 198918 | 122801 | 56500 | 52922 | 91.24% | 88.21% | 85.58% | 91.87% | 86.05% | 0 | 16447 - 88.90% | 1,226,596$ | 50,290,433$ | 18500 | 100 | 68,050,000$ | 1,150,000$ | 0$ | 70,829,740$ | 348,974$ | 69,029,768$ | 20 | 0 | 0$ | 0$ | 0 | 358,205$ | 0$ | 0$ | 69,029,768$ | 29,029,768$ | 85,000,000$ | 15,970,232$ | 12,641,723$ | 12,641,723$ |
| 10 | Flames | 7500 | 5500 | 2500 | 4500 | 2000 | 95 | 82 | 69 | 50 | 120 | 237810 | 199566 | 101753 | 129176 | 59855 | 77.34% | 88.50% | 99.27% | 70.01% | 72.99% | 0 | 17760 - 80.73% | 1,306,224$ | 53,555,168$ | 22000 | 100 | 81,100,000$ | 1,725,000$ | 0$ | 80,344,653$ | 415,897$ | 79,844,610$ | 20 | 0 | 0$ | 0$ | 0 | 418,462$ | 0$ | 0$ | 79,844,610$ | 39,844,610$ | 85,000,000$ | 5,155,390$ | 2,594,953$ | 2,594,953$ |
| 11 | Flyers | 6000 | 5000 | 3500 | 2000 | 1500 | 88 | 74 | 65 | 50 | 115 | 242624 | 202243 | 125023 | 82000 | 59251 | 98.63% | 98.66% | 87.12% | 100.00% | 96.34% | 0 | 17345 - 96.36% | 1,234,729$ | 50,623,872$ | 18000 | 100 | 64,338,000$ | 7,475,000$ | 0$ | 63,407,927$ | 329,938$ | 58,407,922$ | 25 | 1 | 0$ | 0$ | 0 | 355,579$ | 0$ | 0$ | 58,407,922$ | 18,407,922$ | 85,000,000$ | 26,592,078$ | 66,799,629$ | 66,799,629$ |
| 12 | Islanders | 6000 | 5000 | 2000 | 4000 | 1000 | 85 | 73 | 61 | 50 | 115 | 244936 | 203858 | 82000 | 118722 | 41000 | 99.57% | 99.44% | 100.00% | 72.39% | 100.00% | 0 | 16842 - 93.57% | 1,124,150$ | 46,090,149$ | 18000 | 100 | 67,700,000$ | 1,000,000$ | 0$ | 68,499,990$ | 347,179$ | 67,699,905$ | 20 | 0 | 0$ | 0$ | 0 | 351,282$ | 0$ | 0$ | 67,699,905$ | 27,699,905$ | 85,000,000$ | 17,300,095$ | 30,985,628$ | 30,985,628$ |
| 13 | Kings | 6500 | 5000 | 2500 | 2500 | 1500 | 90 | 79 | 75 | 65 | 120 | 251486 | 201527 | 96334 | 81118 | 57677 | 94.37% | 98.31% | 93.98% | 79.14% | 93.78% | 0 | 16784 - 93.24% | 1,294,843$ | 53,088,546$ | 18000 | 100 | 82,175,000$ | 4,425,000$ | 0$ | 84,856,762$ | 421,410$ | 83,152,183$ | 20 | 0 | 0$ | 0$ | 0 | 425,513$ | 0$ | 0$ | 83,152,183$ | 43,152,183$ | 85,000,000$ | 1,847,817$ | 31,540,267$ | 31,540,267$ |
| 14 | Maple Leafs | 6000 | 6000 | 4700 | 2000 | 1300 | 105 | 91 | 80 | 69 | 120 | 193746 | 172400 | 134890 | 77409 | 53299 | 78.76% | 70.08% | 70.00% | 94.40% | 100.00% | 0 | 15408 - 77.04% | 1,305,980$ | 53,545,166$ | 20000 | 100 | 66,600,000$ | 0$ | 0$ | 67,865,368$ | 341,538$ | 67,015,363$ | 20 | 0 | 0$ | 0$ | 0 | 345,897$ | 0$ | 0$ | 67,015,363$ | 27,015,363$ | 85,000,000$ | 17,984,637$ | 24,919,264$ | 24,919,264$ |
| 15 | Oilers | 6600 | 5800 | 2800 | 5000 | 1800 | 91 | 79 | 65 | 50 | 120 | 257787 | 210913 | 114800 | 143500 | 59053 | 95.26% | 88.69% | 100.00% | 70.00% | 80.02% | 0 | 19172 - 87.15% | 1,353,705$ | 55,501,907$ | 22000 | 100 | 75,638,167$ | 12,538,167$ | 0$ | 71,560,598$ | 387,888$ | 69,310,669$ | 24 | 0 | 0$ | 0$ | 0 | 399,426$ | 0$ | 0$ | 69,310,669$ | 29,310,669$ | 85,000,000$ | 15,689,331$ | 76,341,644$ | 76,341,644$ |
| 16 | Penguins | 6400 | 5400 | 4400 | 2400 | 1400 | 96 | 83 | 71 | 59 | 120 | 214063 | 178680 | 108389 | 88469 | 56451 | 81.58% | 80.70% | 60.08% | 89.91% | 98.35% | 0 | 15757 - 78.79% | 1,205,421$ | 49,422,243$ | 20000 | 100 | 68,650,000$ | 0$ | 0$ | 69,360,002$ | 352,051$ | 68,659,960$ | 20 | 0 | 0$ | 0$ | 0 | 355,641$ | 0$ | 0$ | 68,659,960$ | 28,659,960$ | 85,000,000$ | 16,340,040$ | 50,364,482$ | 50,364,482$ |
| 17 | Predators | 6500 | 5500 | 2500 | 4400 | 1100 | 90 | 78 | 65 | 51 | 115 | 250299 | 207953 | 102500 | 114016 | 45100 | 93.92% | 92.22% | 100.00% | 63.20% | 100.00% | 0 | 17558 - 87.79% | 1,235,052$ | 50,637,114$ | 20000 | 100 | 58,250,000$ | 13,500,000$ | 0$ | 58,696,742$ | 298,718$ | 57,921,807$ | 20 | 0 | 0$ | 0$ | 0 | 302,692$ | 0$ | 0$ | 57,921,807$ | 17,921,807$ | 85,000,000$ | 27,078,193$ | 66,409,671$ | 66,409,671$ |
| 18 | Rangers | 6000 | 5000 | 3000 | 2500 | 1500 | 96 | 82 | 71 | 58 | 120 | 213070 | 192986 | 101762 | 91016 | 58584 | 86.61% | 94.14% | 82.73% | 88.80% | 95.26% | 0 | 16035 - 89.08% | 1,220,923$ | 50,057,854$ | 18000 | 100 | 58,825,000$ | 6,000,000$ | 0$ | 60,705,815$ | 301,667$ | 59,905,792$ | 20 | 0 | 0$ | 0$ | 0 | 305,769$ | 0$ | 0$ | 59,905,792$ | 19,905,792$ | 85,000,000$ | 25,094,208$ | 75,104,109$ | 75,104,109$ |
| 19 | Red Wings | 6500 | 5000 | 4500 | 2000 | 1500 | 97 | 88 | 74 | 61 | 120 | 203973 | 160355 | 129150 | 81606 | 58568 | 76.54% | 78.22% | 70.00% | 99.52% | 95.23% | 0 | 15455 - 79.26% | 1,214,171$ | 49,781,026$ | 19500 | 100 | 81,500,000$ | 575,000$ | 0$ | 82,901,237$ | 417,949$ | 81,001,328$ | 20 | 0 | 0$ | 0$ | 0 | 427,692$ | 0$ | 0$ | 81,001,328$ | 41,001,328$ | 85,000,000$ | 3,998,672$ | -12,789,106$ | -12,789,106$ |
| 20 | Sabres | 6000 | 5000 | 4000 | 3000 | 1200 | 97 | 82 | 70 | 56 | 120 | 214855 | 197195 | 107333 | 111540 | 49200 | 87.34% | 96.19% | 65.45% | 90.68% | 100.00% | 0 | 16588 - 86.40% | 1,261,762$ | 51,732,239$ | 19200 | 100 | 74,350,000$ | 575,000$ | 0$ | 75,722,319$ | 381,282$ | 74,272,299$ | 20 | 0 | 0$ | 0$ | 0 | 388,718$ | 0$ | 0$ | 74,272,299$ | 34,272,299$ | 85,000,000$ | 10,727,701$ | 63,363,530$ | 63,363,530$ |
| 21 | Senateurs | 6500 | 5000 | 4000 | 2000 | 1500 | 91 | 82 | 73 | 58 | 115 | 249595 | 192610 | 114800 | 81968 | 57864 | 93.66% | 93.96% | 70.00% | 99.96% | 94.09% | 0 | 16996 - 89.45% | 1,276,009$ | 52,316,372$ | 19000 | 100 | 68,975,000$ | 1,100,000$ | 0$ | 74,589,839$ | 353,718$ | 72,034,248$ | 20 | 0 | 0$ | 0$ | 0 | 366,823$ | 0$ | 0$ | 72,034,248$ | 32,034,248$ | 85,000,000$ | 12,965,752$ | 23,508,548$ | 23,508,548$ |
| 22 | Sharks | 6500 | 5000 | 3000 | 4000 | 1500 | 100 | 81 | 65 | 50 | 120 | 199894 | 201348 | 121481 | 115942 | 58780 | 75.01% | 98.22% | 98.77% | 70.70% | 95.58% | 0 | 17011 - 85.05% | 1,249,325$ | 51,222,314$ | 20000 | 100 | 63,900,000$ | 1,150,000$ | 0$ | 66,374,358$ | 327,692$ | 63,974,298$ | 20 | 0 | 0$ | 0$ | 0 | 340,000$ | 0$ | 0$ | 63,974,298$ | 23,974,298$ | 85,000,000$ | 21,025,702$ | 49,771,100$ | 49,771,100$ |
| 23 | Stars | 6000 | 5000 | 2000 | 4000 | 1000 | 96 | 84 | 70 | 56 | 120 | 220772 | 181603 | 82000 | 112833 | 41000 | 89.74% | 88.59% | 100.00% | 68.80% | 100.00% | 0 | 15566 - 86.48% | 1,169,034$ | 47,930,405$ | 18000 | 100 | 60,862,000$ | 2,962,000$ | 0$ | 59,276,496$ | 312,113$ | 58,276,524$ | 24 | 1 | 0$ | 0$ | 0 | 317,241$ | 0$ | 0$ | 58,276,524$ | 18,276,524$ | 85,000,000$ | 26,723,476$ | 23,868,281$ | 23,868,281$ |
| 24 | Wild | 6500 | 5500 | 4000 | 3000 | 1000 | 93 | 71 | 51 | 50 | 999 | 220334 | 189704 | 137892 | 112671 | 32800 | 82.68% | 84.13% | 84.08% | 91.60% | 80.00% | 0 | 16912 - 84.56% | 2,077,941$ | 85,195,563$ | 20000 | 100 | 83,621,000$ | 4,075,000$ | 0$ | 82,838,335$ | 428,826$ | 79,838,314$ | 20 | 0 | 0$ | 0$ | 0 | 444,210$ | 0$ | 0$ | 79,838,314$ | 39,838,314$ | 85,000,000$ | 5,161,686$ | 60,560,904$ | 60,560,904$ |