| 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é | Cap Salarial Maximum | Cap Salarial Disponible | Compte Bancaire Actuel | Compte Bancaire Projeté |
| 1 | Anaheim | 6000 | 5000 | 3000 | 3000 | 1500 | 175 | 90 | 65 | 40 | 325 | 163316 | 154689 | 75623 | 123000 | 36263 | 66.39% | 75.46% | 61.48% | 100.00% | 58.96% | 0 | 13485 - 72.89% | 1,563,982$ | 64,123,280$ | 18500 | 100 | 44,058,000$ | 44,620,500$ | 0$ | 52,190,943$ | 228,652$ | 50,977,544$ | 22 | 1 | 0$ | 0$ | 1 | 238,278$ | 238,278$ | 250,626$ | 53,050,426$ | 60,000,000$ | 6,949,574$ | 112,377,940$ | 112,127,314$ |
| 2 | Boston | 6105 | 5180 | 2035 | 4070 | 1110 | 180 | 100 | 99 | 98 | 350 | 160333 | 139520 | 49163 | 66755 | 33772 | 64.06% | 65.69% | 58.92% | 40.00% | 74.21% | 0 | 10964 - 59.27% | 1,610,763$ | 66,041,267$ | 18500 | 100 | 47,830,000$ | 48,080,000$ | 0$ | 55,269,989$ | 255,775$ | 54,772,712$ | 24 | 0 | 0$ | 0$ | 1 | 258,449$ | 258,449$ | 276,834$ | 57,498,084$ | 60,000,000$ | 2,501,916$ | 119,855,458$ | 119,578,624$ |
| 3 | Buffalo | 7500 | 6000 | 2500 | 4000 | 2000 | 125 | 75 | 50 | 30 | 200 | 255305 | 212606 | 99587 | 162461 | 53243 | 83.03% | 86.43% | 97.16% | 99.06% | 64.93% | 0 | 19102 - 86.83% | 1,667,326$ | 68,360,355$ | 22000 | 100 | 47,645,891$ | 47,495,891$ | 0$ | 54,954,227$ | 254,791$ | 54,456,924$ | 25 | 0 | 0$ | 0$ | 1 | 257,465$ | 257,465$ | 269,055$ | 56,271,031$ | 60,000,000$ | 3,728,969$ | 89,202,367$ | 88,933,312$ |
| 4 | Calgary | 6500 | 5250 | 2250 | 4000 | 1500 | 200 | 100 | 100 | 100 | 400 | 143283 | 140480 | 48848 | 65600 | 29479 | 53.76% | 65.26% | 52.95% | 40.00% | 47.93% | 0 | 10431 - 53.49% | 1,608,317$ | 65,941,000$ | 19500 | 100 | 49,800,000$ | 51,590,000$ | 0$ | 51,616,053$ | 266,310$ | 51,118,709$ | 24 | 0 | 0$ | 0$ | 1 | 268,984$ | 268,984$ | 283,175$ | 53,707,355$ | 60,000,000$ | 6,292,645$ | 172,978,584$ | 172,695,409$ |
| 5 | Caroline | 6000 | 5000 | 2000 | 4000 | 1000 | 140 | 82 | 64 | 42 | 299 | 204645 | 169946 | 76814 | 158691 | 39111 | 83.19% | 82.90% | 93.68% | 96.76% | 95.39% | 0 | 15834 - 87.97% | 1,606,370$ | 65,861,179$ | 18000 | 100 | 54,771,607$ | 50,486,069$ | 0$ | 57,455,598$ | 292,896$ | 56,958,260$ | 21 | 0 | 0$ | 0$ | 1 | 295,570$ | 295,570$ | 313,219$ | 59,965,821$ | 60,000,000$ | 34,179$ | 85,758,634$ | 85,445,415$ |
| 6 | Chicago | 7000 | 6000 | 2500 | 5000 | 1500 | 200 | 100 | 99 | 98 | 400 | 141035 | 138363 | 49680 | 82000 | 29861 | 49.14% | 56.25% | 48.47% | 40.00% | 48.55% | 0 | 10755 - 48.88% | 1,632,732$ | 66,942,020$ | 22000 | 100 | 60,735,000$ | 61,801,667$ | 0$ | 56,855,904$ | 324,786$ | 56,358,543$ | 21 | 0 | 0$ | 0$ | 1 | 327,460$ | 327,460$ | 343,032$ | 59,281,919$ | 60,000,000$ | 718,081$ | 328,134,863$ | 327,791,831$ |
| 7 | Colorado | 6000 | 5000 | 2500 | 4000 | 1000 | 160 | 100 | 65 | 40 | 300 | 180800 | 138923 | 75479 | 159579 | 39342 | 73.50% | 67.77% | 73.64% | 97.30% | 95.96% | 0 | 14491 - 78.33% | 1,607,615$ | 65,912,195$ | 18500 | 100 | 55,786,000$ | 56,739,333$ | 0$ | 54,052,112$ | 298,321$ | 53,554,769$ | 25 | 0 | 0$ | 0$ | 1 | 300,995$ | 300,995$ | 318,005$ | 56,424,989$ | 60,000,000$ | 3,575,011$ | 161,484,980$ | 161,166,975$ |
| 8 | Columbus | 6700 | 5800 | 3000 | 5000 | 1500 | 135 | 70 | 50 | 35 | 260 | 249601 | 215211 | 103993 | 167489 | 51518 | 90.86% | 90.50% | 84.55% | 81.70% | 83.77% | 0 | 19215 - 87.34% | 1,782,030$ | 73,063,230$ | 22000 | 100 | 58,903,000$ | 55,894,666$ | 0$ | 58,217,744$ | 310,043$ | 57,042,761$ | 23 | 1 | 0$ | 0$ | 1 | 317,663$ | 317,663$ | 330,844$ | 59,433,408$ | 60,000,000$ | 566,592$ | 176,799,577$ | 176,468,733$ |
| 9 | Dallas | 6000 | 5000 | 2000 | 4000 | 1000 | 125 | 60 | 35 | 20 | 250 | 242700 | 204357 | 82000 | 164000 | 41000 | 98.66% | 99.69% | 100.00% | 100.00% | 100.00% | 0 | 17904 - 99.47% | 1,438,998$ | 58,998,920$ | 18000 | 100 | 48,952,000$ | 48,952,000$ | 0$ | 44,793,702$ | 251,080$ | 43,269,643$ | 24 | 1 | 0$ | 0$ | 1 | 264,449$ | 264,449$ | 275,391$ | 44,868,142$ | 60,000,000$ | 15,131,858$ | 70,176,323$ | 69,900,932$ |
| 10 | Detroit | 7500 | 6000 | 2000 | 5000 | 1500 | 150 | 100 | 99 | 98 | 400 | 188787 | 140463 | 48487 | 82000 | 29245 | 61.39% | 57.10% | 59.13% | 40.00% | 47.55% | 0 | 11926 - 54.21% | 1,631,672$ | 66,898,563$ | 22000 | 100 | 60,284,047$ | 58,192,381$ | 0$ | 54,742,443$ | 322,375$ | 54,245,128$ | 24 | 0 | 0$ | 0$ | 1 | 325,048$ | 325,048$ | 353,159$ | 59,895,508$ | 60,000,000$ | 104,492$ | 221,737,397$ | 221,384,238$ |
| 11 | Edmonton | 6000 | 5000 | 2500 | 4000 | 1750 | 150 | 100 | 60 | 25 | 300 | 193016 | 139333 | 81092 | 163922 | 39510 | 78.46% | 67.97% | 79.11% | 99.95% | 55.07% | 0 | 15046 - 78.16% | 1,553,714$ | 63,702,270$ | 19250 | 100 | 54,272,000$ | 54,589,428$ | 0$ | 54,540,280$ | 290,225$ | 54,042,979$ | 21 | 0 | 0$ | 0$ | 1 | 292,898$ | 292,898$ | 305,094$ | 56,177,859$ | 60,000,000$ | 3,822,141$ | 145,873,001$ | 145,567,907$ |
| 12 | Hartford | 7000 | 5000 | 2500 | 4000 | 1500 | 107 | 80 | 56 | 43 | 210 | 264657 | 194518 | 98386 | 160205 | 53133 | 92.21% | 94.89% | 95.99% | 97.69% | 86.40% | 0 | 18802 - 94.01% | 1,662,488$ | 68,162,001$ | 20000 | 100 | 51,352,000$ | 49,802,000$ | 0$ | 51,732,375$ | 263,914$ | 50,636,124$ | 20 | 1 | 0$ | 0$ | 1 | 277,283$ | 277,283$ | 293,501$ | 53,040,543$ | 60,000,000$ | 6,959,457$ | 175,360,612$ | 175,067,111$ |
| 13 | Islanders | 6500 | 5000 | 2000 | 4000 | 1000 | 100 | 70 | 45 | 32 | 400 | 260877 | 203370 | 82000 | 162585 | 29810 | 97.89% | 99.20% | 100.00% | 99.14% | 72.71% | 0 | 18016 - 97.38% | 1,491,227$ | 61,140,320$ | 18500 | 100 | 64,567,000$ | 62,186,048$ | 0$ | 57,842,853$ | 345,278$ | 57,345,494$ | 23 | 0 | 0$ | 0$ | 1 | 347,952$ | 347,952$ | 360,299$ | 59,555,840$ | 60,000,000$ | 444,160$ | 138,570,724$ | 138,210,425$ |
| 14 | Kansas City | 7500 | 6000 | 3000 | 4000 | 1500 | 160 | 90 | 60 | 55 | 399 | 176298 | 154659 | 82594 | 116904 | 30021 | 57.33% | 62.87% | 67.15% | 71.28% | 48.81% | 0 | 13670 - 62.14% | 1,590,856$ | 65,225,099$ | 22000 | 100 | 55,585,000$ | 54,610,000$ | 0$ | 54,021,380$ | 292,299$ | 53,281,658$ | 21 | 1 | 0$ | 0$ | 1 | 299,920$ | 299,920$ | 333,623$ | 59,969,240$ | 60,000,000$ | 30,760$ | 165,445,915$ | 165,112,292$ |
| 15 | LA Kings | 6000 | 5000 | 3500 | 4000 | 1500 | 125 | 75 | 35 | 30 | 175 | 243727 | 201928 | 110014 | 163335 | 55873 | 99.08% | 98.50% | 76.66% | 99.59% | 90.85% | 0 | 18899 - 94.50% | 1,565,350$ | 64,179,335$ | 20000 | 100 | 71,604,000$ | 71,487,333$ | 0$ | 61,198,468$ | 350,824$ | 56,979,158$ | 23 | 1 | 0$ | 0$ | 1 | 385,583$ | 385,583$ | 399,425$ | 59,492,433$ | 60,000,000$ | 507,567$ | 193,538,448$ | 193,139,023$ |
| 16 | Las Vegas | 6000 | 5000 | 2000 | 4000 | 1000 | 111 | 71 | 52 | 37 | 207 | 244558 | 203884 | 82000 | 161086 | 41000 | 99.41% | 99.46% | 100.00% | 98.22% | 100.00% | 0 | 17867 - 99.26% | 1,470,582$ | 60,293,881$ | 18000 | 100 | 48,198,000$ | 46,198,000$ | 0$ | 53,888,288$ | 253,465$ | 53,266,874$ | 24 | 1 | 0$ | 0$ | 1 | 260,417$ | 260,417$ | 271,075$ | 55,093,614$ | 60,000,000$ | 4,906,386$ | 69,451,317$ | 69,180,242$ |
| 17 | Minnesota | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 20 | 200 | 245735 | 204431 | 82000 | 164000 | 41000 | 99.89% | 99.72% | 100.00% | 100.00% | 100.00% | 0 | 17980 - 99.89% | 1,248,521$ | 51,189,360$ | 18000 | 100 | 56,465,000$ | 56,298,333$ | 0$ | 56,373,923$ | 301,952$ | 55,876,559$ | 22 | 0 | 0$ | 0$ | 1 | 304,626$ | 304,626$ | 318,772$ | 58,330,145$ | 60,000,000$ | 1,669,855$ | 82,932,502$ | 82,613,730$ |
| 18 | Montreal | 6000 | 5000 | 2000 | 4000 | 1000 | 145 | 97 | 77 | 52 | 375 | 194067 | 148438 | 65884 | 143382 | 31692 | 78.89% | 72.41% | 80.35% | 87.43% | 77.30% | 0 | 14231 - 79.06% | 1,610,719$ | 66,039,489$ | 18000 | 100 | 64,563,227$ | 60,117,393$ | 0$ | 57,502,107$ | 345,258$ | 57,004,801$ | 23 | 0 | 0$ | 0$ | 1 | 347,932$ | 347,932$ | 363,007$ | 59,855,356$ | 60,000,000$ | 144,644$ | 148,928,316$ | 148,565,309$ |
| 19 | Nashville | 6700 | 5800 | 3200 | 4500 | 1800 | 150 | 81 | 71 | 50 | 225 | 185275 | 172006 | 68893 | 115341 | 51513 | 67.45% | 72.33% | 52.51% | 62.52% | 69.80% | 0 | 14464 - 65.75% | 1,597,183$ | 65,484,496$ | 22000 | 100 | 57,292,000$ | 56,033,666$ | 0$ | 55,390,493$ | 306,374$ | 54,893,185$ | 25 | 0 | 0$ | 0$ | 1 | 309,048$ | 309,048$ | 324,205$ | 57,260,610$ | 60,000,000$ | 2,739,390$ | 148,602,830$ | 148,278,625$ |
| 20 | Ottawa | 7500 | 6000 | 2000 | 5000 | 1500 | 175 | 100 | 100 | 95 | 400 | 163374 | 141245 | 49299 | 82000 | 29777 | 53.13% | 57.42% | 60.12% | 40.00% | 48.42% | 0 | 11358 - 51.63% | 1,642,577$ | 67,345,650$ | 22000 | 100 | 43,103,000$ | 41,025,500$ | 0$ | 49,610,458$ | 225,551$ | 48,900,459$ | 23 | 1 | 0$ | 0$ | 1 | 233,171$ | 233,171$ | 249,109$ | 51,711,373$ | 60,000,000$ | 8,288,627$ | 235,259,810$ | 235,010,701$ |
| 21 | Philadelphie | 7000 | 5000 | 2500 | 3837 | 1200 | 110 | 80 | 60 | 50 | 150 | 260285 | 200205 | 81262 | 122151 | 49200 | 90.69% | 97.66% | 79.28% | 77.65% | 100.00% | 0 | 17393 - 89.02% | 1,536,854$ | 63,011,020$ | 19537 | 100 | 60,180,000$ | 60,460,477$ | 0$ | 57,584,296$ | 321,818$ | 57,086,953$ | 21 | 0 | 0$ | 0$ | 1 | 324,492$ | 324,492$ | 337,529$ | 59,309,222$ | 60,000,000$ | 690,778$ | 110,869,227$ | 110,531,698$ |
| 22 | Pittsburgh | 6100 | 5150 | 2650 | 4300 | 1050 | 150 | 75 | 50 | 35 | 300 | 186195 | 190801 | 95967 | 165153 | 38589 | 74.45% | 90.36% | 88.33% | 93.68% | 89.64% | 0 | 16505 - 85.74% | 1,627,644$ | 66,733,400$ | 19250 | 100 | 57,922,333$ | 57,201,499$ | 0$ | 55,141,233$ | 309,745$ | 54,643,869$ | 23 | 0 | 0$ | 0$ | 1 | 312,419$ | 312,419$ | 326,283$ | 57,304,697$ | 60,000,000$ | 2,695,303$ | 126,153,819$ | 125,827,536$ |
| 23 | Quebec | 7000 | 4000 | 3000 | 3500 | 1000 | 100 | 60 | 35 | 20 | 200 | 265492 | 164000 | 111783 | 143500 | 41000 | 92.51% | 100.00% | 90.88% | 100.00% | 100.00% | 0 | 17702 - 95.69% | 1,252,966$ | 51,371,605$ | 18500 | 100 | 68,146,111$ | 67,420,277$ | 0$ | 54,928,941$ | 364,418$ | 54,431,596$ | 25 | 0 | 0$ | 0$ | 1 | 367,092$ | 367,092$ | 378,106$ | 56,802,491$ | 60,000,000$ | 3,197,509$ | 80,100,530$ | 79,722,424$ |
| 24 | Rangers | 6000 | 6000 | 2500 | 4000 | 1000 | 135 | 70 | 40 | 30 | 250 | 242135 | 217544 | 101414 | 162274 | 41000 | 98.43% | 88.43% | 98.94% | 98.95% | 100.00% | 0 | 18643 - 95.61% | 1,636,368$ | 67,091,085$ | 19500 | 100 | 60,710,000$ | 60,930,000$ | 0$ | 56,371,907$ | 324,652$ | 55,635,579$ | 23 | 0 | 0$ | 0$ | 1 | 327,326$ | 327,326$ | 337,531$ | 57,385,277$ | 60,000,000$ | 2,614,723$ | 123,924,170$ | 123,586,639$ |
| 25 | San Jose | 6600 | 5600 | 2650 | 5000 | 1000 | 95 | 65 | 35 | 22 | 300 | 260442 | 217242 | 107480 | 185421 | 39126 | 96.25% | 94.62% | 98.92% | 90.45% | 95.43% | 0 | 19749 - 94.72% | 1,425,404$ | 58,441,582$ | 20850 | 100 | 45,790,000$ | 43,577,500$ | 0$ | 45,803,736$ | 244,866$ | 45,306,377$ | 24 | 0 | 0$ | 0$ | 1 | 247,540$ | 247,540$ | 280,924$ | 51,244,201$ | 60,000,000$ | 8,755,799$ | 179,396,756$ | 179,115,832$ |
| 26 | St-Louis | 6500 | 5500 | 3500 | 3000 | 1500 | 200 | 100 | 99 | 75 | 395 | 143157 | 140362 | 57588 | 77661 | 30070 | 53.72% | 62.24% | 40.13% | 63.14% | 48.89% | 0 | 10947 - 54.74% | 1,606,214$ | 65,854,758$ | 20000 | 100 | 58,248,000$ | 57,331,334$ | 0$ | 54,965,691$ | 311,487$ | 54,468,358$ | 24 | 0 | 0$ | 0$ | 1 | 314,160$ | 314,160$ | 337,379$ | 58,185,744$ | 60,000,000$ | 1,814,256$ | 299,780,706$ | 299,443,327$ |
| 27 | Tampa Bay | 6000 | 5000 | 2500 | 4000 | 1000 | 110 | 70 | 40 | 25 | 225 | 245159 | 203112 | 101967 | 163951 | 41000 | 99.66% | 99.08% | 99.48% | 99.97% | 100.00% | 0 | 18419 - 99.56% | 1,428,970$ | 58,587,785$ | 18500 | 100 | 58,909,000$ | 58,925,666$ | 0$ | 53,591,830$ | 315,021$ | 53,094,498$ | 24 | 0 | 0$ | 0$ | 1 | 317,695$ | 317,695$ | 334,915$ | 56,353,272$ | 60,000,000$ | 3,646,728$ | 172,126,362$ | 171,791,447$ |
| 28 | Toronto | 6000 | 5000 | 2500 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 245528 | 204549 | 102149 | 163971 | 41000 | 99.81% | 99.78% | 99.66% | 99.98% | 100.00% | 0 | 18468 - 99.83% | 1,285,371$ | 52,700,230$ | 18500 | 100 | 53,905,502$ | 50,615,500$ | 0$ | 54,747,608$ | 288,265$ | 53,474,925$ | 25 | 0 | 0$ | 0$ | 1 | 290,939$ | 290,939$ | 304,487$ | 56,405,202$ | 60,000,000$ | 3,594,798$ | 42,072,922$ | 41,768,435$ |
| 29 | Vancouver | 5000 | 7000 | 4000 | 4000 | 2000 | 100 | 60 | 40 | 20 | 200 | 205000 | 223404 | 107944 | 164000 | 54584 | 100.00% | 77.84% | 65.82% | 100.00% | 66.57% | 0 | 18413 - 83.70% | 1,278,507$ | 52,418,800$ | 22000 | 100 | 52,967,011$ | 53,017,011$ | 0$ | 51,740,093$ | 283,246$ | 51,242,730$ | 23 | 0 | 0$ | 0$ | 1 | 285,920$ | 285,920$ | 303,855$ | 54,088,758$ | 60,000,000$ | 5,911,242$ | 80,523,200$ | 80,219,345$ |
| 30 | Washington | 6000 | 5000 | 2500 | 4000 | 1000 | 130 | 85 | 40 | 30 | 220 | 243829 | 168731 | 101405 | 163661 | 41000 | 99.12% | 82.31% | 98.93% | 99.79% | 100.00% | 0 | 17527 - 94.74% | 1,547,584$ | 63,450,935$ | 18500 | 100 | 47,125,000$ | 47,625,000$ | 0$ | 56,068,583$ | 252,005$ | 55,571,236$ | 23 | 0 | 0$ | 0$ | 1 | 254,679$ | 254,679$ | 271,979$ | 58,774,127$ | 60,000,000$ | 1,225,873$ | 90,319,112$ | 90,047,133$ |
| 31 | Winnipeg | 6500 | 5500 | 2500 | 4000 | 1500 | 95 | 65 | 45 | 35 | 195 | 260825 | 214984 | 99950 | 160572 | 54152 | 97.87% | 95.34% | 97.51% | 97.91% | 88.05% | 0 | 19280 - 96.40% | 1,449,506$ | 59,429,745$ | 20000 | 100 | 58,073,000$ | 55,456,333$ | 0$ | 55,263,009$ | 292,422$ | 54,205,266$ | 25 | 3 | 0$ | 0$ | 1 | 313,225$ | 313,225$ | 329,423$ | 57,581,160$ | 60,000,000$ | 2,418,840$ | 99,433,523$ | 99,104,100$ |