| 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 45,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 | 242610 | 200434 | 118482 | 82000 | 59076 | 98.62% | 97.77% | 82.57% | 100.00% | 96.06% | 0 | 17137 - 95.20% | 1,522,953$ | 62,441,058$ | 18000 | 100 | 61,225,000$ | 925,000$ | 0$ | 62,750,120$ | 315,593$ | 60,760,480$ | 20 | 0 | 0$ | 0$ | 1 | 325,902$ | 325,902$ | 325,902$ | 61,076,073$ | 16,076,073$ | 90,000,000$ | 28,923,927$ | 35,577,269$ | 35,251,367$ |
| 2 | Blackhawks | 6000 | 5500 | 2700 | 4000 | 1800 | 95 | 86 | 71 | 55 | 120 | 213650 | 178011 | 99873 | 129512 | 59898 | 86.85% | 78.94% | 90.22% | 78.97% | 81.16% | 0 | 16608 - 83.04% | 1,503,806$ | 61,656,042$ | 20000 | 100 | 70,975,000$ | 5,000,000$ | 0$ | 74,881,343$ | 365,851$ | 69,907,154$ | 20 | 0 | 0$ | 0$ | 1 | 391,624$ | 391,624$ | 391,624$ | 70,273,005$ | 25,273,005$ | 90,000,000$ | 19,726,995$ | 28,512,469$ | 28,120,845$ |
| 3 | Blues | 7000 | 5000 | 3000 | 3000 | 2000 | 89 | 78 | 61 | 50 | 115 | 254783 | 200047 | 120225 | 115081 | 65030 | 88.77% | 97.58% | 97.74% | 93.56% | 79.30% | 0 | 18419 - 92.09% | 1,543,916$ | 63,300,539$ | 20000 | 100 | 61,200,000$ | 6,750,000$ | 0$ | 61,705,489$ | 315,464$ | 60,710,581$ | 20 | 0 | 0$ | 0$ | 1 | 320,619$ | 320,619$ | 320,619$ | 61,026,045$ | 16,026,045$ | 90,000,000$ | 28,973,955$ | 25,658,935$ | 25,338,316$ |
| 4 | Bruins | 6700 | 5900 | 3500 | 2400 | 1500 | 95 | 83 | 71 | 59 | 120 | 243842 | 211503 | 125990 | 91875 | 58620 | 88.77% | 87.43% | 87.80% | 93.37% | 95.32% | 0 | 17850 - 89.25% | 1,634,959$ | 67,033,311$ | 20000 | 100 | 66,400,000$ | 3,500,000$ | 0$ | 67,802,533$ | 342,268$ | 65,812,889$ | 20 | 0 | 0$ | 0$ | 1 | 352,577$ | 352,577$ | 352,577$ | 66,155,157$ | 21,155,157$ | 90,000,000$ | 23,844,843$ | 21,230,178$ | 20,877,601$ |
| 5 | Canadiens | 6500 | 5000 | 3000 | 2000 | 1500 | 105 | 93 | 76 | 62 | 120 | 233743 | 180591 | 108868 | 80985 | 58750 | 87.71% | 88.09% | 88.51% | 98.76% | 95.53% | 0 | 16169 - 89.83% | 1,623,025$ | 66,544,026$ | 18000 | 100 | 70,600,000$ | 8,575,000$ | 0$ | 74,850,980$ | 363,918$ | 69,876,782$ | 20 | 0 | 0$ | 0$ | 1 | 389,691$ | 389,691$ | 389,691$ | 70,240,700$ | 25,240,700$ | 90,000,000$ | 19,759,300$ | 37,834,352$ | 37,444,661$ |
| 6 | Canucks | 7000 | 5400 | 2400 | 4000 | 1200 | 85 | 72 | 63 | 54 | 125 | 255656 | 209665 | 98400 | 129528 | 48952 | 89.08% | 94.70% | 100.00% | 78.98% | 99.50% | 0 | 18102 - 90.51% | 1,473,379$ | 60,408,553$ | 20000 | 100 | 53,519,167$ | 1,819,167$ | 0$ | 55,180,875$ | 275,872$ | 53,191,238$ | 20 | 0 | 0$ | 0$ | 1 | 286,181$ | 286,181$ | 286,181$ | 53,467,110$ | 8,467,110$ | 90,000,000$ | 36,532,890$ | 50,178,941$ | 49,892,760$ |
| 7 | Capitals | 7300 | 5700 | 2800 | 2000 | 1600 | 95 | 84 | 75 | 63 | 120 | 262138 | 205745 | 103441 | 81557 | 61646 | 87.58% | 88.04% | 90.11% | 99.46% | 93.97% | 0 | 17427 - 89.83% | 1,644,309$ | 67,416,667$ | 19400 | 100 | 75,050,000$ | 800,000$ | 0$ | 75,529,068$ | 386,856$ | 74,534,334$ | 20 | 0 | 0$ | 0$ | 1 | 392,010$ | 392,010$ | 392,010$ | 74,921,190$ | 29,921,190$ | 90,000,000$ | 15,078,810$ | 24,588,258$ | 24,196,248$ |
| 8 | Devils | 6500 | 5700 | 4000 | 2200 | 1500 | 97 | 85 | 76 | 65 | 115 | 235423 | 205296 | 142611 | 83141 | 57715 | 88.34% | 87.85% | 86.96% | 92.17% | 93.85% | 0 | 17663 - 88.76% | 1,661,609$ | 68,125,977$ | 19900 | 100 | 63,150,000$ | 2,075,000$ | 0$ | 64,183,192$ | 325,515$ | 62,690,916$ | 20 | 0 | 0$ | 0$ | 1 | 333,247$ | 333,247$ | 333,247$ | 63,016,431$ | 18,016,431$ | 90,000,000$ | 26,983,569$ | 4,211,007$ | 3,877,760$ |
| 9 | Ducks | 6500 | 5500 | 3500 | 1500 | 1500 | 91 | 79 | 65 | 58 | 125 | 249947 | 207995 | 128420 | 61500 | 56601 | 93.79% | 92.24% | 89.49% | 100.00% | 92.03% | 0 | 17182 - 92.88% | 1,525,795$ | 62,557,592$ | 18500 | 100 | 62,800,000$ | 575,000$ | 0$ | 65,926,476$ | 323,711$ | 60,952,181$ | 20 | 0 | 0$ | 0$ | 1 | 349,485$ | 349,485$ | 349,485$ | 61,275,892$ | 16,275,892$ | 90,000,000$ | 28,724,108$ | 17,264,366$ | 16,914,881$ |
| 10 | Flames | 7500 | 5500 | 2500 | 4500 | 2000 | 95 | 82 | 69 | 50 | 120 | 269250 | 200548 | 101943 | 161550 | 72073 | 87.56% | 88.93% | 99.46% | 87.56% | 87.89% | 0 | 19643 - 89.29% | 1,738,512$ | 71,278,976$ | 22000 | 100 | 78,025,000$ | 2,075,000$ | 0$ | 82,597,052$ | 402,191$ | 77,622,863$ | 20 | 0 | 0$ | 0$ | 1 | 427,964$ | 427,964$ | 427,964$ | 78,025,054$ | 33,025,054$ | 90,000,000$ | 11,974,946$ | -3,656,505$ | -4,084,469$ |
| 11 | Flyers | 6000 | 5000 | 3500 | 2000 | 1500 | 88 | 74 | 65 | 50 | 115 | 243780 | 202741 | 130779 | 82000 | 58806 | 99.10% | 98.90% | 91.14% | 100.00% | 95.62% | 0 | 17515 - 97.30% | 1,464,379$ | 60,039,522$ | 18000 | 100 | 63,950,000$ | 2,550,000$ | 0$ | 68,379,446$ | 329,639$ | 63,405,251$ | 20 | 0 | 0$ | 0$ | 1 | 355,412$ | 355,412$ | 355,412$ | 63,734,890$ | 18,734,890$ | 90,000,000$ | 26,265,110$ | 32,254,980$ | 31,899,568$ |
| 12 | Islanders | 6000 | 5000 | 2000 | 4000 | 1000 | 85 | 73 | 61 | 50 | 115 | 244442 | 203270 | 82000 | 129719 | 41000 | 99.37% | 99.16% | 100.00% | 79.10% | 100.00% | 0 | 17084 - 94.91% | 1,360,027$ | 55,761,107$ | 18000 | 100 | 64,010,000$ | 660,000$ | 0$ | 69,143,965$ | 329,948$ | 64,169,698$ | 20 | 0 | 0$ | 0$ | 1 | 355,722$ | 355,722$ | 355,722$ | 64,499,646$ | 19,499,646$ | 90,000,000$ | 25,500,354$ | 4,844,282$ | 4,488,560$ |
| 13 | Kings | 6500 | 5000 | 2500 | 2500 | 1500 | 120 | 99 | 85 | 79 | 145 | 252660 | 195464 | 97379 | 95900 | 59067 | 94.81% | 95.35% | 95.00% | 93.56% | 96.04% | 0 | 17085 - 94.91% | 1,819,933$ | 74,617,258$ | 18000 | 100 | 83,850,000$ | 0$ | 0$ | 89,366,912$ | 432,216$ | 84,392,591$ | 20 | 0 | 0$ | 0$ | 1 | 457,990$ | 457,990$ | 457,990$ | 84,824,807$ | 39,824,807$ | 90,000,000$ | 5,175,193$ | -7,442,733$ | -7,900,723$ |
| 14 | Maple Leafs | 6000 | 6000 | 4700 | 2000 | 1300 | 105 | 91 | 80 | 69 | 120 | 217128 | 215400 | 168730 | 76414 | 53014 | 88.26% | 87.56% | 87.56% | 93.19% | 99.46% | 0 | 17822 - 89.11% | 1,784,508$ | 73,164,822$ | 20000 | 100 | 66,800,000$ | 1,000,000$ | 0$ | 71,415,709$ | 344,330$ | 66,441,510$ | 20 | 0 | 0$ | 0$ | 1 | 370,103$ | 370,103$ | 370,103$ | 66,785,840$ | 21,785,840$ | 90,000,000$ | 23,214,160$ | 11,935,717$ | 11,565,614$ |
| 15 | Oilers | 6600 | 5800 | 2800 | 5000 | 1800 | 91 | 79 | 65 | 50 | 120 | 258267 | 217822 | 114800 | 180500 | 65752 | 95.44% | 91.60% | 100.00% | 88.05% | 89.09% | 0 | 20418 - 92.81% | 1,716,559$ | 70,378,910$ | 22000 | 100 | 75,888,334$ | 12,538,334$ | 0$ | 70,745,746$ | 391,177$ | 69,750,859$ | 24 | 0 | 0$ | 0$ | 1 | 396,332$ | 396,332$ | 396,332$ | 70,142,036$ | 25,142,036$ | 90,000,000$ | 19,857,964$ | 55,627,125$ | 55,230,793$ |
| 16 | Penguins | 6400 | 5400 | 4400 | 2400 | 1400 | 96 | 83 | 71 | 59 | 120 | 232611 | 194981 | 155760 | 90578 | 55966 | 88.65% | 88.07% | 86.34% | 92.05% | 97.50% | 0 | 17802 - 89.01% | 1,621,913$ | 66,498,450$ | 20000 | 100 | 69,100,000$ | 0$ | 0$ | 69,530,325$ | 356,186$ | 68,634,998$ | 20 | 0 | 0$ | 0$ | 1 | 360,825$ | 360,825$ | 360,825$ | 68,991,184$ | 23,991,184$ | 90,000,000$ | 21,008,816$ | 19,311,195$ | 18,950,370$ |
| 17 | Predators | 6500 | 5500 | 2500 | 4400 | 1100 | 90 | 78 | 65 | 51 | 115 | 248943 | 208188 | 102500 | 141496 | 45100 | 93.41% | 92.32% | 100.00% | 78.43% | 100.00% | 0 | 18201 - 91.00% | 1,520,256$ | 62,330,494$ | 20000 | 100 | 62,300,000$ | 1,750,000$ | 0$ | 63,570,497$ | 321,134$ | 60,585,949$ | 20 | 0 | 0$ | 0$ | 1 | 336,598$ | 336,598$ | 336,598$ | 60,907,083$ | 15,907,083$ | 90,000,000$ | 29,092,917$ | 52,304,907$ | 51,968,309$ |
| 18 | Rangers | 6000 | 5000 | 3000 | 2500 | 1500 | 96 | 82 | 71 | 58 | 120 | 210078 | 186540 | 102677 | 93228 | 59394 | 85.40% | 91.00% | 83.48% | 90.95% | 96.58% | 0 | 15900 - 88.34% | 1,457,468$ | 59,756,185$ | 18000 | 100 | 55,458,330$ | 8,258,330$ | 0$ | 59,114,264$ | 285,868$ | 55,134,934$ | 20 | 0 | 0$ | 0$ | 1 | 306,486$ | 306,486$ | 306,486$ | 55,420,802$ | 10,420,802$ | 90,000,000$ | 34,579,198$ | 68,498,393$ | 68,191,907$ |
| 19 | Red Wings | 6000 | 5500 | 4500 | 2000 | 1500 | 97 | 88 | 74 | 61 | 140 | 230308 | 208062 | 170100 | 81479 | 58845 | 93.62% | 92.27% | 92.20% | 99.36% | 95.68% | 0 | 18263 - 93.66% | 1,748,019$ | 71,668,773$ | 19500 | 100 | 81,450,000$ | 1,150,000$ | 0$ | 82,757,701$ | 419,845$ | 80,867,464$ | 20 | 0 | 0$ | 0$ | 1 | 429,639$ | 429,639$ | 429,639$ | 81,287,309$ | 36,287,309$ | 90,000,000$ | 8,712,691$ | -35,164,088$ | -35,593,727$ |
| 20 | Sabres | 6000 | 5000 | 4000 | 3000 | 1200 | 97 | 82 | 70 | 56 | 120 | 206201 | 186096 | 128422 | 107504 | 49200 | 83.82% | 90.78% | 78.31% | 87.40% | 100.00% | 0 | 16523 - 86.05% | 1,482,163$ | 60,768,668$ | 19200 | 100 | 74,536,667$ | 1,836,667$ | 0$ | 77,563,566$ | 384,210$ | 72,589,377$ | 21 | 1 | 0$ | 0$ | 1 | 409,983$ | 409,983$ | 409,983$ | 72,973,587$ | 27,973,587$ | 90,000,000$ | 17,026,413$ | 66,925,456$ | 66,515,473$ |
| 21 | Senateurs | 6500 | 5000 | 4000 | 2000 | 1500 | 91 | 82 | 73 | 58 | 115 | 251547 | 187498 | 143600 | 81974 | 58661 | 94.39% | 91.46% | 87.56% | 99.97% | 95.38% | 0 | 17641 - 92.85% | 1,583,326$ | 64,916,358$ | 19000 | 100 | 67,100,000$ | 1,100,000$ | 0$ | 71,603,140$ | 345,876$ | 66,628,950$ | 20 | 0 | 0$ | 0$ | 1 | 371,649$ | 371,649$ | 371,649$ | 66,974,826$ | 21,974,826$ | 90,000,000$ | 23,025,174$ | 17,291,566$ | 16,919,917$ |
| 22 | Sharks | 6500 | 5000 | 3000 | 4000 | 1500 | 100 | 81 | 65 | 50 | 120 | 211498 | 200178 | 120052 | 129517 | 57469 | 79.36% | 97.65% | 97.60% | 78.97% | 93.45% | 0 | 17530 - 87.65% | 1,536,954$ | 63,015,121$ | 20000 | 100 | 65,863,333$ | 1,438,333$ | 0$ | 70,437,763$ | 339,502$ | 65,463,570$ | 20 | 0 | 0$ | 0$ | 1 | 365,275$ | 365,275$ | 365,275$ | 65,803,072$ | 20,803,072$ | 90,000,000$ | 24,196,928$ | 32,850,261$ | 32,484,986$ |
| 23 | Stars | 6000 | 5000 | 2000 | 4000 | 1000 | 96 | 84 | 70 | 56 | 120 | 203545 | 167024 | 82000 | 129005 | 41000 | 82.74% | 81.48% | 100.00% | 78.66% | 100.00% | 0 | 15185 - 84.36% | 1,350,881$ | 55,386,134$ | 18000 | 100 | 62,950,000$ | 1,500,000$ | 0$ | 66,751,313$ | 324,485$ | 61,777,112$ | 20 | 0 | 0$ | 0$ | 1 | 350,258$ | 350,258$ | 350,258$ | 62,101,597$ | 17,101,597$ | 90,000,000$ | 27,898,403$ | 531,219$ | 180,961$ |
| 24 | Wild | 6500 | 5500 | 2500 | 4500 | 1000 | 80 | 65 | 60 | 17 | 150 | 254414 | 217469 | 121273 | 140758 | 32708 | 95.46% | 96.44% | 118.32% | 76.29% | 79.78% | 0 | 18698 - 93.49% | 1,965,495$ | 80,585,275$ | 20000 | 100 | 85,420,000$ | 0$ | 0$ | 87,158,186$ | 440,309$ | 84,173,635$ | 20 | 0 | 0$ | 0$ | 1 | 455,773$ | 455,773$ | 455,773$ | 84,613,944$ | 39,613,944$ | 90,000,000$ | 5,386,056$ | 116,786,183$ | 116,330,410$ |