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 58,546,442$ | Plafond salarial maximum | Plafond salarial disponible | Compte bancaire actuel | Compte bancaire projeté |
1 | ![]() | 6000 | 5000 | 5000 | 5000 | 1000 | 100 | 50 | 30 | 15 | 180 | 108928 | 124708 | 102555 | 116292 | 26000 | 69.83% | 95.93% | 78.89% | 89.46% | 100.00% | 15 | 18403 - 83.65% | 1,526,060$ | 39,677,554$ | 22000 | 100 | 74,272,500$ | 74,272,500$ | -3,000,000$ | 49,356,316$ | 74,272,500$ | 47,811,187$ | 22 | 1 | 0$ | 22,890,897$ | 55 | 533,142$ | 29,322,810$ | 29,322,810$ | 71,272,500$ | 12,726,058$ | 78,061,923$ | 6,789,423$ | 106,806,033$ | 100,374,120$ |
2 | ![]() | 5000 | 4000 | 4144 | 4000 | 1000 | 75 | 45 | 30 | 15 | 125 | 130000 | 104000 | 102564 | 103938 | 26000 | 100.00% | 100.00% | 95.19% | 99.94% | 100.00% | 15 | 17942 - 98.89% | 1,278,878$ | 33,250,828$ | 18144 | 100 | 76,686,666$ | 76,686,666$ | 0$ | 46,902,693$ | 76,686,666$ | 45,666,572$ | 22 | 0 | 0$ | 19,183,170$ | 55 | 546,435$ | 30,053,925$ | 30,053,925$ | 76,686,666$ | 18,140,224$ | 78,061,923$ | 1,375,257$ | -34,270,837$ | -45,141,592$ |
3 | ![]() | 6000 | 5000 | 4000 | 4000 | 1000 | 125 | 105 | 75 | 45 | 400 | 84891 | 65000 | 52000 | 52000 | 13014 | 54.42% | 50.00% | 50.00% | 50.00% | 50.05% | 15 | 10266 - 51.33% | 1,655,159$ | 43,034,142$ | 20000 | 100 | 55,074,167$ | 55,074,167$ | 2,500,000$ | 39,045,016$ | 55,074,167$ | 37,808,897$ | 24 | 1 | 0$ | 24,827,390$ | 55 | 396,348$ | 21,799,140$ | 21,799,140$ | 57,574,167$ | -972,275$ | 78,061,923$ | 20,487,756$ | 211,716,230$ | 214,744,480$ |
4 | ![]() | 7000 | 6000 | 6000 | 5000 | 1000 | 82 | 50 | 16 | 10 | 180 | 143040 | 121686 | 113660 | 122507 | 26000 | 78.59% | 78.00% | 72.86% | 94.24% | 100.00% | 15 | 20265 - 81.06% | 1,463,479$ | 38,050,444$ | 25000 | 100 | 60,945,000$ | 60,945,000$ | 0$ | 42,317,615$ | 60,945,000$ | 41,390,530$ | 22 | 2 | 0$ | 21,952,179$ | 55 | 433,646$ | 23,850,530$ | 23,850,530$ | 60,945,000$ | 2,398,558$ | 78,061,923$ | 17,116,923$ | 74,681,941$ | 72,783,590$ |
5 | ![]() | 6000 | 5000 | 3193 | 4000 | 1000 | 84 | 52 | 37 | 15 | 175 | 145904 | 120656 | 80602 | 103930 | 26000 | 93.53% | 92.81% | 97.09% | 99.93% | 100.00% | 15 | 18350 - 95.61% | 1,582,911$ | 41,155,693$ | 19193 | 100 | 57,742,333$ | 57,742,333$ | 3,370,046$ | 40,009,925$ | 57,742,333$ | 39,268,223$ | 23 | 0 | 0$ | 23,743,669$ | 55 | 409,322$ | 22,512,710$ | 22,512,710$ | 61,112,379$ | 2,565,937$ | 78,061,923$ | 16,949,544$ | 107,231,753$ | 108,462,712$ |
6 | ![]() | 6000 | 5000 | 4750 | 4500 | 1027 | 80 | 55 | 25 | 14 | 175 | 150061 | 126083 | 112179 | 116853 | 27729 | 92.63% | 93.39% | 87.47% | 96.18% | 100.00% | 14 | 19737 - 92.76% | 1,558,012$ | 42,066,331$ | 21277 | 100 | 61,449,999$ | 61,449,999$ | 0$ | 49,936,132$ | 61,449,999$ | 49,318,049$ | 19 | 2 | 0$ | 21,812,172$ | 55 | 433,681$ | 23,852,455$ | 23,852,455$ | 61,449,999$ | 2,903,557$ | 78,061,923$ | 16,611,924$ | 104,401,668$ | 102,361,385$ |
7 | ![]() | 5000 | 4000 | 3174 | 4000 | 1000 | 85 | 55 | 40 | 22 | 125 | 129990 | 104000 | 75336 | 78913 | 26000 | 99.99% | 100.00% | 91.29% | 75.88% | 100.00% | 15 | 15932 - 92.77% | 1,419,436$ | 36,905,327$ | 17174 | 100 | 73,700,000$ | 73,700,000$ | 0$ | 45,955,647$ | 73,700,000$ | 45,337,627$ | 25 | 0 | 0$ | 21,291,535$ | 55 | 518,750$ | 28,531,250$ | 28,531,250$ | 73,700,000$ | 15,153,558$ | 78,061,923$ | 4,361,923$ | 9,709,753$ | 2,470,038$ |
8 | ![]() | 6000 | 5000 | 5668 | 6000 | 1500 | 80 | 50 | 30 | 15 | 150 | 140789 | 123515 | 102904 | 114724 | 31043 | 90.25% | 95.01% | 69.83% | 73.54% | 79.60% | 15 | 19730 - 81.64% | 1,541,766$ | 40,085,920$ | 24168 | 100 | 59,080,833$ | 59,080,833$ | 0$ | 39,730,762$ | 59,080,833$ | 38,494,644$ | 23 | 1 | 0$ | 23,126,492$ | 55 | 424,172$ | 23,329,460$ | 23,329,460$ | 59,080,833$ | 534,391$ | 78,061,923$ | 18,981,090$ | 146,962,696$ | 146,759,728$ |
9 | ![]() | 5500 | 4500 | 3000 | 3500 | 1000 | 84 | 56 | 36 | 19 | 195 | 135286 | 111750 | 75000 | 87500 | 25000 | 98.39% | 99.33% | 100.00% | 100.00% | 100.00% | 16 | 17381 - 99.32% | 1,600,828$ | 40,020,690$ | 17500 | 100 | 64,896,641$ | 64,896,641$ | 0$ | 41,572,368$ | 64,896,641$ | 40,954,282$ | 20 | 1 | 0$ | 25,613,242$ | 55 | 457,616$ | 25,168,880$ | 25,168,880$ | 64,896,641$ | 6,350,199$ | 78,061,923$ | 13,165,282$ | 117,695,520$ | 118,139,882$ |
10 | ![]() | 4575 | 4375 | 3390 | 3375 | 800 | 100 | 60 | 40 | 25 | 300 | 105726 | 96927 | 76088 | 68893 | 16388 | 88.88% | 85.21% | 86.33% | 78.51% | 78.79% | 15 | 14001 - 84.78% | 1,501,930$ | 39,050,185$ | 16515 | 100 | 75,103,000$ | 75,103,000$ | 903,675$ | 47,228,190$ | 75,103,000$ | 46,301,146$ | 23 | 0 | 0$ | 22,528,953$ | 55 | 531,965$ | 29,258,075$ | 29,258,075$ | 76,006,675$ | 17,460,233$ | 78,061,923$ | 2,055,248$ | 239,812,740$ | 233,083,618$ |
11 | ![]() | 5300 | 4300 | 4300 | 4418 | 1300 | 95 | 70 | 30 | 20 | 185 | 109701 | 81219 | 101444 | 83971 | 29228 | 79.61% | 72.65% | 90.74% | 73.10% | 86.47% | 15 | 15599 - 79.51% | 1,503,573$ | 39,092,900$ | 19618 | 100 | 73,966,667$ | 73,966,667$ | 0$ | 48,588,438$ | 73,966,667$ | 46,116,198$ | 22 | 1 | 0$ | 22,553,596$ | 55 | 541,435$ | 29,778,925$ | 29,778,925$ | 73,966,667$ | 15,420,225$ | 78,061,923$ | 4,095,256$ | 25,654,621$ | 18,429,292$ |
12 | ![]() | 6000 | 5000 | 5000 | 6000 | 1000 | 85 | 60 | 20 | 12 | 200 | 139522 | 94759 | 106598 | 115077 | 23163 | 89.44% | 72.89% | 82.00% | 73.77% | 89.09% | 15 | 18428 - 80.12% | 1,493,653$ | 38,834,989$ | 23000 | 100 | 77,777,499$ | 77,777,499$ | 0$ | 48,785,817$ | 77,777,499$ | 47,549,735$ | 22 | 0 | 0$ | 22,404,801$ | 55 | 554,010$ | 30,470,550$ | 30,470,550$ | 77,777,499$ | 19,231,057$ | 78,061,923$ | 284,424$ | 144,826,631$ | 136,760,882$ |
13 | ![]() | 6500 | 5600 | 3500 | 4800 | 1400 | 75 | 44 | 32 | 12 | 165 | 143177 | 124539 | 90877 | 115240 | 29618 | 84.72% | 85.54% | 99.86% | 92.34% | 81.37% | 15 | 19364 - 88.82% | 1,455,381$ | 37,839,896$ | 21800 | 100 | 76,669,167$ | 76,669,167$ | 0$ | 46,888,575$ | 76,669,167$ | 46,270,537$ | 23 | 0 | 0$ | 21,830,709$ | 55 | 539,369$ | 29,665,295$ | 29,665,295$ | 76,669,167$ | 18,122,725$ | 78,061,923$ | 1,392,756$ | 53,738,941$ | 45,904,355$ |
14 | ![]() | 6000 | 5000 | 2600 | 4000 | 1000 | 90 | 55 | 45 | 20 | 200 | 119999 | 121966 | 66640 | 88339 | 24249 | 76.92% | 93.82% | 98.58% | 84.94% | 93.27% | 15 | 16200 - 87.10% | 1,554,381$ | 40,413,896$ | 18600 | 100 | 78,375,000$ | 78,375,000$ | -2,750,000$ | 45,291,849$ | 78,375,000$ | 42,819,617$ | 22 | 0 | 0$ | 23,315,709$ | 55 | 572,049$ | 31,462,695$ | 31,462,695$ | 75,625,000$ | 17,078,558$ | 78,061,923$ | 2,436,923$ | 41,568,070$ | 33,421,084$ |
15 | ![]() | 6000 | 5000 | 3250 | 5000 | 1000 | 80 | 50 | 35 | 15 | 200 | 145908 | 123273 | 84500 | 113478 | 23983 | 93.53% | 94.83% | 100.00% | 87.29% | 92.24% | 15 | 18890 - 93.28% | 1,564,074$ | 40,665,913$ | 20250 | 100 | 75,791,666$ | 75,791,666$ | 500,000$ | 48,546,669$ | 75,791,666$ | 47,001,540$ | 22 | 1 | 0$ | 23,461,104$ | 55 | 543,692$ | 29,903,060$ | 29,903,060$ | 76,291,666$ | 17,745,224$ | 78,061,923$ | 1,770,257$ | 113,148,523$ | 106,706,567$ |
16 | ![]() | 6350 | 5500 | 4350 | 4000 | 2500 | 100 | 60 | 35 | 20 | 200 | 108206 | 102334 | 101083 | 86950 | 32500 | 65.54% | 71.56% | 89.37% | 83.61% | 50.00% | 15 | 16580 - 73.04% | 1,646,882$ | 42,818,940$ | 22700 | 100 | 67,385,000$ | 67,385,000$ | 0$ | 42,867,788$ | 67,385,000$ | 41,631,667$ | 21 | 0 | 0$ | 24,703,235$ | 55 | 481,840$ | 26,501,200$ | 26,501,200$ | 67,385,000$ | 8,838,558$ | 78,061,923$ | 10,676,923$ | 80,663,835$ | 78,865,870$ |
17 | ![]() | 7000 | 5000 | 4500 | 5000 | 1500 | 70 | 56 | 25 | 12 | 85 | 148909 | 122390 | 106299 | 116940 | 34394 | 81.82% | 94.15% | 90.85% | 89.95% | 88.19% | 15 | 20344 - 88.45% | 1,390,383$ | 36,149,956$ | 23000 | 100 | 72,705,000$ | 72,705,000$ | 0$ | 46,373,037$ | 72,705,000$ | 44,209,866$ | 20 | 0 | 0$ | 20,855,744$ | 55 | 529,201$ | 29,106,055$ | 29,106,055$ | 72,705,000$ | 14,158,558$ | 78,061,923$ | 5,356,923$ | 169,145,317$ | 160,895,006$ |
18 | ![]() | 6000 | 5000 | 2652 | 4000 | 1000 | 86 | 46 | 43 | 18 | 180 | 148323 | 124241 | 68284 | 102538 | 26000 | 95.08% | 95.57% | 99.03% | 98.59% | 100.00% | 15 | 18053 - 96.79% | 1,600,762$ | 41,619,813$ | 18652 | 100 | 75,675,500$ | 75,675,500$ | 1,000,250$ | 47,451,507$ | 75,675,500$ | 46,771,636$ | 22 | 0 | 0$ | 24,011,431$ | 55 | 533,163$ | 29,323,965$ | 29,323,965$ | 76,675,750$ | 18,129,308$ | 78,061,923$ | 1,386,173$ | -742,651$ | -6,055,185$ |
19 | ![]() | 6000 | 5000 | 4000 | 4000 | 1000 | 125 | 105 | 75 | 45 | 400 | 83081 | 62500 | 50000 | 50000 | 12508 | 55.39% | 50.00% | 50.00% | 50.00% | 50.03% | 16 | 10324 - 51.62% | 1,665,869$ | 41,646,728$ | 20000 | 100 | 77,380,832$ | 77,380,832$ | 0$ | 49,419,301$ | 77,380,832$ | 47,565,161$ | 21 | 0 | 0$ | 26,653,906$ | 55 | 558,200$ | 30,701,000$ | 30,701,000$ | 77,380,832$ | 18,834,390$ | 78,061,923$ | 681,091$ | -4,661,399$ | -8,708,493$ |
20 | ![]() | 4000 | 4000 | 3500 | 3000 | 1700 | 71 | 60 | 35 | 15 | 150 | 104000 | 97557 | 90952 | 78000 | 30202 | 100.00% | 93.80% | 99.95% | 100.00% | 68.33% | 15 | 15412 - 95.14% | 1,267,706$ | 32,960,346$ | 16200 | 100 | 73,065,000$ | 73,065,000$ | 0$ | 46,810,655$ | 73,065,000$ | 44,973,877$ | 23 | 0 | 0$ | 19,015,584$ | 55 | 528,229$ | 29,052,595$ | 29,052,595$ | 73,065,000$ | 14,518,558$ | 78,061,923$ | 4,996,923$ | 283,531,550$ | 273,494,539$ |