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 15,000,000$ | Plafond salarial maximum | Plafond salarial disponible | Compte bancaire actuel | Compte bancaire projeté |
1 | BANGOR BEAGLES | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 230445 | 195000 | 78000 | 156000 | 39000 | 98.48% | 100.00% | 100.00% | 100.00% | 100.00% | 3 | 17909 - 99.49% | 1,260,885$ | 49,174,500$ | 18000 | 100 | 37,287,096$ | 640,000$ | 0$ | 32,103,302$ | 37,287,096$ | 31,087,902$ | 23 | 0 | 620,314$ | 3,782,654$ | 12 | 246,071$ | 2,952,852$ | 3,252,333$ | 39,727,967$ | 24,727,967$ | 45,000,000$ | 5,272,033$ | 376,985,098$ | 377,765,572$ |
2 | BROOKLYN BLAZERS | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 226983 | 195000 | 78000 | 155927 | 39000 | 97.00% | 100.00% | 100.00% | 99.95% | 100.00% | 3 | 17818 - 98.99% | 1,251,961$ | 48,826,475$ | 18000 | 100 | 34,709,946$ | 760,000$ | 0$ | 30,045,684$ | 34,709,946$ | 29,001,466$ | 21 | 0 | 578,577$ | 3,755,883$ | 12 | 229,551$ | 2,754,612$ | 3,070,460$ | 37,392,396$ | 22,392,396$ | 45,000,000$ | 7,607,604$ | 356,424,145$ | 357,360,916$ |
3 | CALGARY COWBOYS | 7500 | 6500 | 3500 | 4500 | 2500 | 90 | 65 | 33 | 25 | 225 | 258703 | 215243 | 102777 | 172648 | 41173 | 86.23% | 82.79% | 73.41% | 95.92% | 41.17% | 2 | 19764 - 80.67% | 1,356,146$ | 54,245,831$ | 24500 | 100 | 35,271,003$ | 760,000$ | 0$ | 30,999,266$ | 35,271,003$ | 29,698,658$ | 23 | 0 | 592,580$ | 2,712,292$ | 12 | 235,128$ | 2,821,536$ | 3,151,723$ | 37,839,703$ | 22,839,703$ | 45,000,000$ | 7,160,297$ | 344,726,359$ | 344,728,585$ |
4 | CAPE BRETON CELTS | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 229709 | 194932 | 78000 | 155969 | 39000 | 98.17% | 99.97% | 100.00% | 99.98% | 100.00% | 3 | 17887 - 99.37% | 1,258,873$ | 49,096,045$ | 18000 | 100 | 33,009,258$ | 680,000$ | 0$ | 32,912,096$ | 33,009,258$ | 30,175,836$ | 22 | 0 | 602,066$ | 3,776,619$ | 12 | 225,425$ | 2,705,100$ | 2,994,805$ | 35,258,658$ | 20,258,658$ | 45,000,000$ | 9,741,342$ | 405,763,745$ | 406,713,551$ |
5 | CAPE FEAR PROWLERS | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 229748 | 195000 | 78000 | 156000 | 39000 | 98.18% | 100.00% | 100.00% | 100.00% | 100.00% | 3 | 17891 - 99.39% | 1,259,097$ | 49,104,800$ | 18000 | 100 | 40,603,343$ | 680,000$ | 0$ | 35,053,371$ | 40,603,343$ | 34,314,939$ | 22 | 0 | 684,838$ | 3,777,292$ | 12 | 265,406$ | 3,184,872$ | 3,503,021$ | 43,145,593$ | 28,145,593$ | 45,000,000$ | 1,854,407$ | 401,501,561$ | 402,025,009$ |
6 | CHICAGO CRUSHERS | 7000 | 6000 | 3000 | 5000 | 2000 | 100 | 70 | 40 | 30 | 175 | 246458 | 171693 | 98648 | 170195 | 54033 | 88.02% | 71.54% | 82.21% | 85.10% | 67.54% | 2 | 18526 - 80.55% | 1,379,296$ | 55,171,855$ | 23000 | 100 | 34,429,093$ | 1,000,000$ | 0$ | 31,603,222$ | 34,429,093$ | 29,780,120$ | 26 | 0 | 594,169$ | 2,758,593$ | 12 | 233,360$ | 2,800,320$ | 3,059,683$ | 36,561,393$ | 21,561,393$ | 45,000,000$ | 8,438,607$ | 412,857,701$ | 412,809,773$ |
7 | COLORADO WOLVES | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 70 | 50 | 30 | 250 | 227940 | 171125 | 70802 | 155744 | 36152 | 97.41% | 87.76% | 90.77% | 99.84% | 92.70% | 3 | 16968 - 94.27% | 1,333,927$ | 52,023,170$ | 18000 | 100 | 24,541,594$ | 760,000$ | 0$ | 21,514,203$ | 24,541,594$ | 20,711,125$ | 20 | 0 | 412,786$ | 4,001,782$ | 12 | 162,895$ | 1,954,740$ | 2,277,023$ | 27,433,808$ | 12,433,808$ | 45,000,000$ | 17,566,192$ | 463,173,079$ | 465,153,475$ |
8 | COQUITLAM KNIGHTS | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 65 | 40 | 30 | 225 | 226134 | 192195 | 78000 | 153924 | 37437 | 96.64% | 98.56% | 100.00% | 98.67% | 95.99% | 3 | 17633 - 97.96% | 1,314,542$ | 51,267,120$ | 18000 | 100 | 26,365,000$ | 880,000$ | 0$ | 23,978,843$ | 26,365,000$ | 22,342,077$ | 23 | 0 | 445,423$ | 3,943,625$ | 12 | 180,373$ | 2,164,476$ | 2,412,958$ | 28,536,500$ | 13,536,500$ | 45,000,000$ | 16,463,500$ | 367,246,052$ | 369,007,970$ |
9 | DETROIT RED WINGS | 6000 | 5000 | 2000 | 4000 | 1000 | 125 | 75 | 40 | 30 | 250 | 197332 | 176585 | 78000 | 155982 | 37894 | 84.33% | 90.56% | 100.00% | 99.99% | 97.16% | 3 | 16559 - 91.99% | 1,291,626$ | 50,373,400$ | 18000 | 100 | 31,173,249$ | 800,000$ | 0$ | 29,098,085$ | 31,173,249$ | 27,663,351$ | 23 | 0 | 551,844$ | 3,874,877$ | 12 | 209,792$ | 2,517,504$ | 2,863,291$ | 34,348,349$ | 19,348,349$ | 45,000,000$ | 10,651,651$ | 203,676,705$ | 204,856,279$ |
10 | EDMONTON BUSCHWACKERS | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 231789 | 194972 | 78000 | 156000 | 39000 | 99.06% | 99.99% | 100.00% | 100.00% | 100.00% | 3 | 17943 - 99.68% | 1,264,288$ | 49,307,220$ | 18000 | 100 | 28,979,124$ | 640,000$ | 0$ | 28,362,055$ | 28,979,124$ | 27,324,535$ | 22 | 0 | 545,023$ | 3,792,863$ | 12 | 192,969$ | 2,315,628$ | 2,650,560$ | 31,722,124$ | 16,722,124$ | 45,000,000$ | 13,277,876$ | 426,307,603$ | 427,617,146$ |
11 | HALIFAX HIGHLANDERS | 6200 | 5200 | 2200 | 4200 | 1200 | 111 | 78 | 51 | 35 | 239 | 219294 | 159091 | 67761 | 130516 | 41447 | 90.69% | 78.45% | 78.98% | 79.68% | 88.56% | 3 | 15849 - 83.42% | 1,361,773$ | 53,109,137$ | 19000 | 100 | 35,358,823$ | 1,334,000$ | 0$ | 30,535,430$ | 35,358,823$ | 29,612,367$ | 25 | 0 | 590,791$ | 4,085,318$ | 12 | 233,069$ | 2,796,828$ | 3,093,488$ | 38,141,519$ | 23,141,519$ | 45,000,000$ | 6,858,481$ | 477,592,548$ | 478,835,600$ |
12 | HAWAII TYPHOON | 7000 | 6000 | 3000 | 5000 | 2000 | 100 | 60 | 35 | 25 | 200 | 240090 | 208023 | 98086 | 167733 | 48859 | 87.95% | 88.90% | 83.83% | 86.02% | 62.64% | 3 | 19559 - 85.04% | 1,381,757$ | 53,888,515$ | 23000 | 100 | 35,223,634$ | 840,000$ | 0$ | 33,796,956$ | 35,223,634$ | 32,873,833$ | 26 | 0 | 656,064$ | 4,145,270$ | 12 | 232,203$ | 2,786,436$ | 3,066,495$ | 37,805,878$ | 22,805,878$ | 45,000,000$ | 7,194,122$ | 418,449,077$ | 419,779,622$ |
13 | LAS CRUCES SPURS | 7500 | 6500 | 3500 | 4500 | 2500 | 102 | 63 | 35 | 27 | 240 | 211920 | 216522 | 101376 | 168267 | 39678 | 72.45% | 85.41% | 74.27% | 95.88% | 40.70% | 3 | 18917 - 77.21% | 1,355,662$ | 52,870,815$ | 24500 | 100 | 35,578,713$ | 720,000$ | 0$ | 30,370,491$ | 35,578,713$ | 29,355,107$ | 23 | 0 | 585,649$ | 4,066,986$ | 12 | 235,120$ | 2,821,440$ | 3,138,068$ | 37,807,674$ | 22,807,674$ | 45,000,000$ | 7,192,326$ | 398,529,901$ | 399,775,635$ |
14 | MANHATTAN ISLANDERS | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 228333 | 194824 | 78000 | 155997 | 39000 | 97.58% | 99.91% | 100.00% | 100.00% | 100.00% | 3 | 17850 - 99.17% | 1,255,197$ | 48,952,665$ | 18000 | 100 | 31,969,603$ | 760,000$ | 0$ | 27,458,911$ | 31,969,603$ | 25,789,951$ | 21 | 0 | 514,344$ | 3,765,590$ | 12 | 216,523$ | 2,598,276$ | 2,945,220$ | 34,959,603$ | 19,959,603$ | 45,000,000$ | 10,040,397$ | 349,485,505$ | 350,557,187$ |
15 | NEWTON NIGHTMARES | 6000 | 5000 | 2000 | 4000 | 1000 | 90 | 70 | 45 | 30 | 150 | 233706 | 171657 | 75666 | 155686 | 39000 | 99.87% | 88.03% | 97.01% | 99.80% | 100.00% | 3 | 17326 - 96.26% | 1,204,489$ | 46,975,080$ | 18000 | 100 | 39,477,042$ | 1,770,000$ | 0$ | 36,811,123$ | 39,477,042$ | 35,380,339$ | 23 | 0 | 706,159$ | 3,613,468$ | 12 | 262,994$ | 3,155,928$ | 3,516,054$ | 42,676,181$ | 27,676,181$ | 45,000,000$ | 2,323,819$ | 263,401,697$ | 263,693,975$ |
16 | NORTH VAN ROCKERS | 7500 | 6500 | 5500 | 5000 | 1500 | 100 | 60 | 30 | 28 | 200 | 240589 | 213976 | 103013 | 170118 | 50236 | 82.25% | 84.41% | 48.02% | 87.24% | 85.87% | 3 | 19947 - 76.72% | 1,405,086$ | 54,798,354$ | 26000 | 100 | 27,290,263$ | 1,210,000$ | 0$ | 24,117,703$ | 27,290,263$ | 23,046,940$ | 20 | 0 | 459,452$ | 4,215,258$ | 12 | 182,373$ | 2,188,476$ | 2,580,816$ | 30,281,588$ | 15,281,588$ | 45,000,000$ | 14,718,412$ | 404,731,045$ | 406,663,735$ |
17 | PENSACOLA BADGERS | 6000 | 5000 | 2000 | 4000 | 1000 | 105 | 95 | 85 | 70 | 150 | 201456 | 127721 | 43845 | 67040 | 39000 | 86.09% | 65.50% | 56.21% | 42.97% | 100.00% | 3 | 12284 - 68.24% | 1,219,385$ | 47,556,000$ | 18000 | 100 | 38,816,363$ | 920,000$ | 0$ | 26,077,666$ | 38,816,363$ | 25,317,971$ | 23 | 0 | 504,911$ | 3,658,154$ | 12 | 254,098$ | 3,049,176$ | 3,324,555$ | 41,242,088$ | 26,242,088$ | 45,000,000$ | 3,757,912$ | 352,047,872$ | 352,461,471$ |
18 | PHILADELPHIA MADMEN | 6000 | 5000 | 2000 | 4000 | 1000 | 109 | 78 | 56 | 32 | 249 | 212350 | 168961 | 69720 | 127757 | 37892 | 90.75% | 86.65% | 89.38% | 81.90% | 97.16% | 3 | 15812 - 87.85% | 1,301,990$ | 50,777,608$ | 18000 | 100 | 34,613,192$ | 680,000$ | 0$ | 31,226,075$ | 34,613,192$ | 29,604,160$ | 23 | 0 | 590,625$ | 3,905,970$ | 12 | 231,495$ | 2,777,940$ | 3,113,847$ | 37,258,964$ | 22,258,964$ | 45,000,000$ | 7,741,036$ | 352,337,888$ | 353,374,570$ |
19 | PINCHER CREEK PREDATORS | 7000 | 6000 | 3000 | 5000 | 2000 | 100 | 70 | 40 | 30 | 175 | 244749 | 170314 | 99624 | 167597 | 53891 | 89.65% | 72.78% | 85.15% | 85.95% | 69.09% | 3 | 18876 - 82.07% | 1,406,171$ | 54,840,675$ | 23000 | 100 | 35,898,891$ | 920,000$ | 0$ | 34,272,778$ | 35,898,891$ | 33,341,408$ | 25 | 0 | 665,382$ | 4,218,513$ | 12 | 236,589$ | 2,839,068$ | 3,146,596$ | 38,051,841$ | 23,051,841$ | 45,000,000$ | 6,948,159$ | 340,635,880$ | 342,085,839$ |
20 | SAN JOSE BLASPHEMERS | 7000 | 6000 | 3000 | 5000 | 2000 | 100 | 60 | 35 | 25 | 200 | 242576 | 212381 | 99634 | 173884 | 49631 | 88.86% | 90.76% | 85.16% | 89.17% | 63.63% | 3 | 19951 - 86.75% | 1,404,127$ | 54,760,950$ | 23000 | 100 | 30,811,990$ | 960,000$ | 0$ | 29,997,354$ | 30,811,990$ | 29,074,284$ | 25 | 0 | 580,013$ | 4,212,381$ | 12 | 203,923$ | 2,447,076$ | 2,732,699$ | 33,361,490$ | 18,361,490$ | 45,000,000$ | 11,638,510$ | 442,402,641$ | 444,048,667$ |
21 | SYRACUSE BULLDOGS | 6000 | 5000 | 2000 | 4000 | 1000 | 105 | 95 | 85 | 75 | 150 | 192130 | 120823 | 41290 | 62447 | 38000 | 84.27% | 63.59% | 54.33% | 41.08% | 100.00% | 4 | 11966 - 66.48% | 1,198,553$ | 45,545,010$ | 18000 | 100 | 26,963,219$ | 920,000$ | 0$ | 27,014,683$ | 26,963,219$ | 26,291,012$ | 24 | 0 | 524,388$ | 4,794,212$ | 12 | 177,867$ | 2,134,404$ | 2,518,866$ | 30,406,349$ | 15,406,349$ | 45,000,000$ | 14,593,651$ | 343,035,348$ | 345,420,668$ |
22 | VANCOUVER MILLIONAIRES | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 228621 | 194998 | 78000 | 156000 | 39000 | 97.70% | 100.00% | 100.00% | 100.00% | 100.00% | 3 | 17862 - 99.23% | 1,256,205$ | 48,991,980$ | 18000 | 100 | 30,932,959$ | 920,000$ | 0$ | 29,927,553$ | 30,932,959$ | 28,302,945$ | 23 | 0 | 564,593$ | 3,768,614$ | 12 | 209,570$ | 2,514,840$ | 2,771,655$ | 33,164,559$ | 18,164,559$ | 45,000,000$ | 11,835,441$ | 195,282,169$ | 196,528,080$ |