| 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 48,800,000$ | Plafond salarial maximum | Plafond salarial disponible | Compte bancaire actuel | Compte bancaire projeté |
| 1 | Anaheim | 6000 | 5000 | 3000 | 3000 | 1500 | 175 | 90 | 65 | 40 | 325 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 18500 | 100 | 66,188,333$ | 66,188,333$ | -3,500,000$ | 0$ | 336,918$ | 0$ | 22 | 2 | 0$ | 0$ | 192 | 344,731$ | 66,188,352$ | 67,128,192$ | 61,188,256$ | 12,388,256$ | 66,000,000$ | 4,811,744$ | 165,648,249$ | 98,520,057$ |
| 2 | Boston | 6105 | 5180 | 2035 | 4070 | 1110 | 180 | 100 | 99 | 98 | 350 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 18500 | 100 | 65,550,836$ | 65,550,836$ | 0$ | 0$ | 336,723$ | 0$ | 23 | 0 | 0$ | 0$ | 192 | 341,411$ | 65,550,912$ | 67,158,144$ | 64,650,816$ | 15,850,816$ | 66,000,000$ | 1,349,184$ | 168,034,052$ | 100,875,908$ |
| 3 | Buffalo | 7500 | 6000 | 2500 | 4000 | 2000 | 125 | 75 | 50 | 30 | 200 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 22000 | 100 | 64,850,001$ | 64,564,287$ | 0$ | 0$ | 333,356$ | 0$ | 21 | 0 | 0$ | 0$ | 192 | 337,760$ | 64,849,920$ | 66,579,456$ | 64,004,352$ | 15,204,352$ | 66,000,000$ | 1,995,648$ | 145,115,699$ | 78,536,243$ |
| 4 | Calgary | 6500 | 5250 | 2250 | 4000 | 1500 | 200 | 100 | 100 | 100 | 400 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 19500 | 100 | 66,056,542$ | 66,056,542$ | 0$ | 0$ | 332,586$ | 0$ | 24 | 0 | 0$ | 0$ | 192 | 344,044$ | 66,056,448$ | 67,404,288$ | 63,856,512$ | 15,056,512$ | 66,000,000$ | 2,143,488$ | 281,049,167$ | 213,644,879$ |
| 5 | Caroline | 6000 | 5000 | 2000 | 4000 | 1000 | 140 | 82 | 64 | 42 | 299 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 18000 | 100 | 62,287,169$ | 65,501,455$ | 307,334$ | 0$ | 333,497$ | 0$ | 20 | 0 | 0$ | 0$ | 192 | 324,412$ | 62,287,104$ | 63,624,768$ | 64,338,758$ | 15,538,758$ | 66,000,000$ | 1,661,242$ | 146,671,840$ | 83,047,072$ |
| 6 | Chicago | 7000 | 6000 | 2500 | 5000 | 1500 | 200 | 100 | 99 | 98 | 400 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 22000 | 100 | 52,015,833$ | 53,015,833$ | 0$ | 0$ | 266,749$ | 0$ | 23 | 0 | 0$ | 0$ | 192 | 270,916$ | 52,015,872$ | 53,667,456$ | 51,215,808$ | 2,415,808$ | 66,000,000$ | 14,784,192$ | 440,283,578$ | 386,616,122$ |
| 7 | Colorado | 6000 | 5000 | 2500 | 4000 | 1000 | 160 | 100 | 65 | 40 | 300 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 18500 | 100 | 67,307,779$ | 67,450,636$ | 0$ | 0$ | 338,024$ | 0$ | 21 | 2 | 0$ | 0$ | 192 | 350,561$ | 67,307,712$ | 68,992,320$ | 64,900,608$ | 16,100,608$ | 66,000,000$ | 1,099,392$ | 261,235,711$ | 192,243,391$ |
| 8 | Columbus | 6700 | 5800 | 3000 | 5000 | 1500 | 135 | 70 | 50 | 35 | 260 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 22000 | 100 | 66,304,304$ | 67,023,351$ | -1,696,429$ | 0$ | 333,455$ | 0$ | 23 | 0 | 0$ | 0$ | 192 | 345,335$ | 66,304,320$ | 68,120,064$ | 62,326,931$ | 13,526,931$ | 66,000,000$ | 3,673,069$ | 271,732,471$ | 203,612,407$ |
| 9 | Dallas | 6000 | 5000 | 2000 | 4000 | 1000 | 115 | 67 | 65 | 27 | 275 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 18000 | 100 | 61,138,338$ | 61,138,338$ | 0$ | 0$ | 314,783$ | 0$ | 23 | 0 | 0$ | 0$ | 192 | 318,429$ | 61,138,368$ | 62,871,552$ | 60,438,336$ | 11,638,336$ | 66,000,000$ | 5,561,664$ | 111,664,593$ | 48,793,041$ |
| 10 | Detroit | 7500 | 6000 | 2000 | 5000 | 1500 | 150 | 100 | 99 | 98 | 400 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 22000 | 100 | 51,845,000$ | 51,916,429$ | 429$ | 0$ | 267,273$ | 0$ | 17 | 0 | 0$ | 0$ | 192 | 270,026$ | 51,844,992$ | 53,787,648$ | 51,316,845$ | 2,516,845$ | 66,000,000$ | 14,683,155$ | 322,153,182$ | 268,365,534$ |
| 11 | Edmonton | 6000 | 5000 | 2500 | 4000 | 1750 | 180 | 100 | 50 | 20 | 400 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 19250 | 100 | 69,935,000$ | 70,185,000$ | 0$ | 0$ | 347,357$ | 0$ | 24 | 0 | 0$ | 0$ | 192 | 364,245$ | 69,935,040$ | 71,190,336$ | 66,692,544$ | 17,892,544$ | 66,000,000$ | -692,544$ | 176,042,791$ | 104,852,455$ |
| 12 | Hartford | 7000 | 5000 | 2500 | 4000 | 1500 | 110 | 87 | 68 | 55 | 215 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 20000 | 100 | 68,805,002$ | 68,805,002$ | 0$ | 0$ | 335,964$ | 0$ | 22 | 3 | 0$ | 0$ | 192 | 358,359$ | 68,804,928$ | 70,218,624$ | 64,505,088$ | 15,705,088$ | 66,000,000$ | 1,494,912$ | 223,727,712$ | 153,509,088$ |
| 13 | Islanders | 6500 | 5000 | 2000 | 4000 | 1000 | 110 | 75 | 50 | 37 | 400 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 18500 | 100 | 67,546,666$ | 68,336,665$ | -4,571,429$ | 0$ | 334,473$ | 0$ | 25 | 1 | 0$ | 0$ | 192 | 351,806$ | 67,546,752$ | 69,036,096$ | 59,647,387$ | 10,847,387$ | 66,000,000$ | 6,352,613$ | 156,700,765$ | 87,664,669$ |
| 14 | Kansas City | 240 | 6000 | 3000 | 4000 | 1500 | 185 | 100 | 60 | 55 | 399 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 14740 | 100 | 60,978,333$ | 60,978,333$ | 0$ | 0$ | 317,595$ | 0$ | 22 | 0 | 0$ | 0$ | 192 | 317,595$ | 60,978,240$ | 62,859,072$ | 60,978,240$ | 12,178,240$ | 66,000,000$ | 5,021,760$ | 226,941,817$ | 164,082,745$ |
| 15 | LA Kings | 6000 | 5000 | 3500 | 4000 | 1500 | 120 | 70 | 30 | 25 | 160 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 20000 | 100 | 62,226,667$ | 62,226,667$ | 560,000$ | 0$ | 317,248$ | 0$ | 21 | 0 | 0$ | 0$ | 192 | 324,097$ | 62,226,624$ | 63,397,824$ | 61,471,616$ | 12,671,616$ | 66,000,000$ | 4,528,384$ | 222,928,657$ | 159,530,833$ |
| 16 | Las Vegas | 6000 | 5000 | 2000 | 4000 | 1000 | 200 | 100 | 99 | 98 | 400 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 18000 | 100 | 55,425,000$ | 55,425,000$ | 0$ | 0$ | 288,672$ | 0$ | 16 | 0 | 0$ | 0$ | 192 | 288,672$ | 55,425,024$ | 57,183,360$ | 55,425,024$ | 6,625,024$ | 66,000,000$ | 10,574,976$ | 130,530,788$ | 73,347,428$ |
| 17 | Minnesota | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 20 | 200 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 18000 | 100 | 56,461,669$ | 57,128,336$ | 3,500,000$ | 0$ | 297,543$ | 0$ | 24 | 0 | 0$ | 0$ | 192 | 294,071$ | 56,461,632$ | 58,145,856$ | 60,628,256$ | 11,828,256$ | 66,000,000$ | 5,371,744$ | 65,610,306$ | 7,464,450$ |
| 18 | Montreal | 6000 | 5000 | 2000 | 4000 | 1000 | 200 | 100 | 99 | 76 | 400 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 18000 | 100 | 64,883,723$ | 64,681,342$ | 1,896,000$ | 0$ | 333,757$ | 0$ | 22 | 0 | 0$ | 0$ | 192 | 337,936$ | 64,883,712$ | 66,438,336$ | 65,977,344$ | 17,177,344$ | 66,000,000$ | 22,656$ | 242,258,847$ | 175,820,511$ |
| 19 | Nashville | 6700 | 5800 | 3200 | 4500 | 1800 | 120 | 80 | 60 | 40 | 200 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 22000 | 100 | 35,267,502$ | 35,267,502$ | 13,816,556$ | 0$ | 183,685$ | 0$ | 20 | 0 | 0$ | 0$ | 192 | 183,685$ | 35,267,520$ | 37,336,896$ | 49,084,076$ | 284,076$ | 66,000,000$ | 16,915,924$ | 215,552,076$ | 178,215,180$ |
| 20 | Ottawa | 7500 | 6000 | 2000 | 5000 | 1500 | 175 | 100 | 99 | 95 | 400 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 22000 | 100 | 57,482,500$ | 57,482,500$ | 0$ | 0$ | 287,409$ | 0$ | 22 | 0 | 0$ | 0$ | 192 | 299,388$ | 57,482,496$ | 58,771,392$ | 55,182,528$ | 6,382,528$ | 66,000,000$ | 10,817,472$ | 305,554,325$ | 246,782,933$ |
| 21 | Philadelphie | 7000 | 5000 | 2500 | 3837 | 1200 | 110 | 80 | 60 | 50 | 150 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 19537 | 100 | 68,097,614$ | 66,601,582$ | 0$ | 0$ | 338,810$ | 0$ | 24 | 1 | 0$ | 0$ | 192 | 354,675$ | 68,097,600$ | 69,708,480$ | 65,051,520$ | 16,251,520$ | 66,000,000$ | 948,480$ | 163,439,479$ | 93,730,999$ |
| 22 | Pittsburgh | 6100 | 5150 | 2650 | 4300 | 1050 | 144 | 84 | 59 | 36 | 316 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 19250 | 100 | 62,700,000$ | 62,700,000$ | 0$ | 0$ | 310,625$ | 0$ | 23 | 0 | 0$ | 0$ | 192 | 326,562$ | 62,699,904$ | 64,242,240$ | 59,640,000$ | 10,840,000$ | 66,000,000$ | 6,360,000$ | 251,303,036$ | 187,060,796$ |
| 23 | Quebec | 7000 | 4000 | 3000 | 3500 | 1000 | 200 | 100 | 75 | 50 | 400 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 18500 | 100 | 66,625,834$ | 66,625,834$ | 0$ | 0$ | 340,760$ | 0$ | 22 | 0 | 0$ | 0$ | 192 | 347,010$ | 66,625,920$ | 67,704,000$ | 65,425,920$ | 16,625,920$ | 66,000,000$ | 574,080$ | 141,174,968$ | 73,470,968$ |
| 24 | Rangers | 6000 | 6000 | 2500 | 4000 | 1000 | 130 | 60 | 40 | 30 | 260 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 19500 | 100 | 67,252,222$ | 67,417,037$ | 4,571,429$ | 0$ | 327,693$ | 0$ | 27 | 1 | 0$ | 0$ | 192 | 350,272$ | 67,252,224$ | 68,665,728$ | 67,488,485$ | 18,688,485$ | 66,000,000$ | -1,488,485$ | 150,263,328$ | 81,597,600$ |
| 25 | San Jose | 6600 | 5600 | 2650 | 5000 | 1000 | 95 | 65 | 35 | 22 | 300 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 20850 | 100 | 63,460,334$ | 62,888,905$ | 0$ | 0$ | 322,859$ | 0$ | 20 | 0 | 0$ | 0$ | 192 | 330,523$ | 63,460,416$ | 65,248,128$ | 61,988,928$ | 13,188,928$ | 66,000,000$ | 4,011,072$ | 194,938,286$ | 129,690,158$ |
| 26 | Seattle | 6000 | 5000 | 2500 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 18500 | 100 | 65,683,611$ | 65,326,468$ | 0$ | 0$ | 323,445$ | 0$ | 24 | 2 | 0$ | 0$ | 192 | 342,102$ | 65,683,584$ | 67,668,288$ | 62,101,440$ | 13,301,440$ | 66,000,000$ | 3,898,560$ | 47,576,410$ | -20,091,878$ |
| 27 | St-Louis | 6500 | 5500 | 3500 | 3000 | 1500 | 200 | 100 | 99 | 75 | 395 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 20000 | 100 | 62,756,779$ | 61,873,446$ | 0$ | 0$ | 317,570$ | 0$ | 21 | 1 | 0$ | 0$ | 192 | 326,858$ | 62,756,736$ | 64,332,096$ | 60,973,440$ | 12,173,440$ | 66,000,000$ | 5,026,560$ | 388,324,463$ | 323,992,367$ |
| 28 | Tampa Bay | 6000 | 5000 | 2500 | 4000 | 1000 | 125 | 80 | 50 | 35 | 250 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 18500 | 100 | 68,690,000$ | 68,190,000$ | -2,200,000$ | 0$ | 345,208$ | 0$ | 24 | 0 | 0$ | 0$ | 192 | 357,760$ | 68,689,920$ | 70,228,224$ | 64,079,936$ | 15,279,936$ | 66,000,000$ | 1,920,064$ | 239,005,892$ | 168,777,668$ |
| 29 | Toronto | 6000 | 5000 | 2500 | 4000 | 1000 | 200 | 100 | 99 | 98 | 400 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 18500 | 100 | 61,926,668$ | 61,498,097$ | 0$ | 0$ | 320,303$ | 0$ | 22 | 0 | 0$ | 0$ | 192 | 322,535$ | 61,926,720$ | 64,142,784$ | 61,498,176$ | 12,698,176$ | 66,000,000$ | 4,501,824$ | 65,544,125$ | 1,401,341$ |
| 30 | Vancouver | 5000 | 7000 | 4000 | 4000 | 2000 | 150 | 100 | 99 | 98 | 400 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 22000 | 100 | 64,105,838$ | 64,605,838$ | 0$ | 0$ | 328,676$ | 0$ | 22 | 0 | 0$ | 0$ | 192 | 333,885$ | 64,105,920$ | 65,441,280$ | 63,105,792$ | 14,305,792$ | 66,000,000$ | 2,894,208$ | 133,935,698$ | 68,494,418$ |
| 31 | Washington | 6000 | 5000 | 2500 | 4000 | 1000 | 130 | 85 | 40 | 30 | 220 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 18500 | 100 | 69,865,628$ | 69,865,628$ | 0$ | 0$ | 342,503$ | 0$ | 24 | 2 | 0$ | 0$ | 192 | 363,883$ | 69,865,536$ | 71,387,136$ | 65,760,576$ | 16,960,576$ | 66,000,000$ | 239,424$ | 145,312,234$ | 73,925,098$ |
| 32 | Winnipeg | 6500 | 5500 | 2500 | 4000 | 1500 | 100 | 70 | 55 | 45 | 195 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 20000 | 100 | 69,243,449$ | 69,443,449$ | 0$ | 0$ | 347,622$ | 0$ | 23 | 0 | 0$ | 0$ | 192 | 360,643$ | 69,243,456$ | 70,534,464$ | 66,743,424$ | 17,943,424$ | 66,000,000$ | -743,424$ | 133,495,715$ | 62,961,251$ |
