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 | 54000 | 45000 | 18000 | 36000 | 9000 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 33 | 18000 - 100.00% | 1,270,000$ | 11,430,000$ | 18000 | 100 | 37,287,096$ | 640,000$ | 0$ | 0$ | 0$ | 0$ | 23 | 0 | 682,324$ | 0$ | 10 | 0$ | 0$ | 0$ | 0$ | -15,000,000$ | 45,000,000$ | 45,000,000$ | 388,910,644$ | 388,910,644$ |
2 | BROOKLYN BLAZERS | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 24000 | 20000 | 8000 | 16000 | 4000 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 38 | 18000 - 100.00% | 1,270,000$ | 5,080,000$ | 18000 | 100 | 37,109,946$ | 880,000$ | 0$ | 0$ | 0$ | 0$ | 23 | 1 | 636,297$ | 0$ | 10 | 0$ | 0$ | 0$ | 0$ | -15,000,000$ | 45,000,000$ | 45,000,000$ | 362,464,159$ | 362,464,159$ |
3 | CALGARY COWBOYS | 7500 | 6500 | 3500 | 4500 | 2500 | 90 | 65 | 33 | 25 | 225 | 22209 | 18155 | 8888 | 13500 | 3658 | 98.71% | 93.10% | 84.65% | 100.00% | 48.77% | 39 | 22137 - 90.35% | 1,544,246$ | 4,632,739$ | 24500 | 100 | 35,371,003$ | 760,000$ | 0$ | 0$ | 0$ | 0$ | 23 | 0 | 651,299$ | 0$ | 10 | 0$ | 0$ | 0$ | 0$ | -15,000,000$ | 45,000,000$ | 45,000,000$ | 349,345,411$ | 349,345,411$ |
4 | CAPE BRETON CELTS | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 36000 | 30000 | 12000 | 24000 | 6000 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 36 | 18000 - 100.00% | 1,270,000$ | 7,620,000$ | 18000 | 100 | 38,171,758$ | 680,000$ | 0$ | 0$ | 0$ | 0$ | 22 | 0 | 663,572$ | 0$ | 10 | 0$ | 0$ | 0$ | 0$ | -15,000,000$ | 45,000,000$ | 45,000,000$ | 413,746,129$ | 413,746,129$ |
5 | CAPE FEAR PROWLERS | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 18000 | 15000 | 6000 | 12000 | 3000 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 39 | 18000 - 100.00% | 1,270,000$ | 3,810,000$ | 18000 | 100 | 40,638,343$ | 680,000$ | 0$ | 0$ | 0$ | 0$ | 22 | 0 | 752,426$ | 0$ | 10 | 0$ | 0$ | 0$ | 0$ | -15,000,000$ | 45,000,000$ | 45,000,000$ | 406,034,196$ | 406,034,196$ |
6 | CHICAGO CRUSHERS | 7000 | 6000 | 3000 | 5000 | 2000 | 100 | 70 | 40 | 30 | 175 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 42 | 0 - 0% | 0$ | 0$ | 23000 | 100 | 33,429,093$ | 920,000$ | 0$ | 0$ | 0$ | 0$ | 24 | 0 | 651,293$ | 0$ | 10 | 0$ | 0$ | 0$ | 0$ | -15,000,000$ | 45,000,000$ | 45,000,000$ | 412,854,743$ | 412,854,743$ |
7 | COLORADO WOLVES | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 70 | 50 | 30 | 250 | 12000 | 9844 | 4000 | 8000 | 2000 | 100.00% | 98.44% | 100.00% | 100.00% | 100.00% | 40 | 17922 - 99.57% | 1,414,540$ | 2,829,080$ | 18000 | 100 | 24,666,594$ | 760,000$ | 0$ | 0$ | 0$ | 0$ | 20 | 0 | 453,678$ | 0$ | 10 | 0$ | 0$ | 0$ | 0$ | -15,000,000$ | 45,000,000$ | 45,000,000$ | 468,199,792$ | 468,199,792$ |
8 | COQUITLAM KNIGHTS | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 65 | 40 | 30 | 225 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 42 | 0 - 0% | 0$ | 0$ | 18000 | 100 | 26,365,000$ | 880,000$ | 0$ | 0$ | 0$ | 0$ | 23 | 0 | 489,233$ | 0$ | 10 | 0$ | 0$ | 0$ | 0$ | -15,000,000$ | 45,000,000$ | 45,000,000$ | 368,794,761$ | 368,794,761$ |
9 | DETROIT RED WINGS | 6000 | 5000 | 2000 | 4000 | 1000 | 125 | 75 | 40 | 30 | 250 | 33698 | 29573 | 12000 | 24000 | 6000 | 93.61% | 98.58% | 100.00% | 100.00% | 100.00% | 36 | 17545 - 97.47% | 1,521,704$ | 9,130,225$ | 18000 | 100 | 31,198,249$ | 800,000$ | 0$ | 0$ | 0$ | 0$ | 23 | 0 | 603,684$ | 0$ | 10 | 0$ | 0$ | 0$ | 0$ | -15,000,000$ | 45,000,000$ | 45,000,000$ | 214,452,702$ | 214,452,702$ |
10 | EDMONTON BUSCHWACKERS | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 36000 | 30000 | 12000 | 24000 | 6000 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 36 | 18000 - 100.00% | 1,270,000$ | 7,620,000$ | 18000 | 100 | 28,979,124$ | 640,000$ | 0$ | 0$ | 0$ | 0$ | 22 | 0 | 593,188$ | 0$ | 10 | 0$ | 0$ | 0$ | 0$ | -15,000,000$ | 45,000,000$ | 45,000,000$ | 435,517,635$ | 435,517,635$ |
11 | HALIFAX HIGHLANDERS | 6200 | 5200 | 2200 | 4200 | 1200 | 159 | 105 | 70 | 54 | 389 | 44525 | 37163 | 14834 | 29207 | 8087 | 89.77% | 89.33% | 84.28% | 86.93% | 84.24% | 34 | 16727 - 88.04% | 1,867,121$ | 14,936,968$ | 19000 | 100 | 35,458,823$ | 1,294,000$ | 0$ | 0$ | 0$ | 0$ | 24 | 0 | 648,488$ | 0$ | 10 | 0$ | 0$ | 0$ | 0$ | -15,000,000$ | 45,000,000$ | 45,000,000$ | 494,603,787$ | 494,603,787$ |
12 | HAWAII TYPHOON | 7000 | 6000 | 3000 | 5000 | 2000 | 100 | 60 | 35 | 25 | 200 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 42 | 0 - 0% | 0$ | 0$ | 23000 | 100 | 35,179,482$ | 800,000$ | 0$ | 0$ | 0$ | 0$ | 25 | 0 | 715,612$ | 0$ | 10 | 0$ | 0$ | 0$ | 0$ | -15,000,000$ | 45,000,000$ | 45,000,000$ | 419,731,186$ | 419,731,186$ |
13 | LAS CRUCES SPURS | 7500 | 6500 | 3500 | 4500 | 2500 | 102 | 63 | 35 | 27 | 240 | 44172 | 38252 | 18675 | 27000 | 7888 | 98.16% | 98.08% | 88.93% | 100.00% | 52.59% | 36 | 22665 - 92.51% | 1,698,528$ | 10,191,165$ | 24500 | 100 | 35,578,713$ | 720,000$ | 0$ | 0$ | 0$ | 0$ | 23 | 0 | 644,812$ | 0$ | 10 | 0$ | 0$ | 0$ | 0$ | -15,000,000$ | 45,000,000$ | 45,000,000$ | 409,695,139$ | 409,695,139$ |
14 | MANHATTAN ISLANDERS | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 42 | 0 - 0% | 0$ | 0$ | 18000 | 100 | 31,969,603$ | 760,000$ | 0$ | 0$ | 0$ | 0$ | 21 | 0 | 567,501$ | 0$ | 10 | 0$ | 0$ | 0$ | 0$ | -15,000,000$ | 45,000,000$ | 45,000,000$ | 350,558,147$ | 350,558,147$ |
15 | NEWTON NIGHTMARES | 6000 | 5000 | 2000 | 4000 | 1000 | 90 | 70 | 45 | 30 | 150 | 18000 | 15000 | 6000 | 12000 | 3000 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 39 | 18000 - 100.00% | 1,250,000$ | 3,750,000$ | 18000 | 100 | 43,581,243$ | 1,890,000$ | 0$ | 0$ | 0$ | 0$ | 26 | 0 | 773,947$ | 0$ | 10 | 0$ | 0$ | 0$ | 0$ | -15,000,000$ | 45,000,000$ | 45,000,000$ | 267,554,626$ | 267,554,626$ |
16 | NORTH VAN ROCKERS | 7500 | 6500 | 5500 | 5000 | 1500 | 100 | 60 | 30 | 28 | 200 | 22325 | 19148 | 9368 | 14831 | 4500 | 99.22% | 98.19% | 56.78% | 98.87% | 100.00% | 39 | 23391 - 89.96% | 1,659,229$ | 4,977,688$ | 26000 | 100 | 27,290,263$ | 1,210,000$ | 0$ | 0$ | 0$ | 0$ | 20 | 0 | 504,809$ | 0$ | 10 | 0$ | 0$ | 0$ | 0$ | -15,000,000$ | 45,000,000$ | 45,000,000$ | 412,291,927$ | 412,291,927$ |
17 | PENSACOLA BADGERS | 6000 | 5000 | 2000 | 4000 | 1000 | 105 | 95 | 85 | 70 | 150 | 17822 | 11973 | 4385 | 6847 | 3000 | 99.01% | 79.82% | 73.08% | 57.06% | 100.00% | 39 | 14676 - 81.53% | 1,436,920$ | 4,310,760$ | 18000 | 100 | 28,416,363$ | 920,000$ | 0$ | 0$ | 0$ | 0$ | 23 | 0 | 569,214$ | 0$ | 10 | 0$ | 0$ | 0$ | 0$ | -15,000,000$ | 45,000,000$ | 45,000,000$ | 356,660,726$ | 356,660,726$ |
18 | PHILADELPHIA MADMEN | 6000 | 5000 | 2000 | 4000 | 1000 | 149 | 99 | 80 | 62 | 385 | 32558 | 28597 | 11563 | 22961 | 5960 | 90.44% | 95.32% | 96.36% | 95.67% | 99.33% | 36 | 16940 - 94.11% | 1,749,364$ | 10,496,185$ | 18000 | 100 | 34,613,192$ | 680,000$ | 0$ | 0$ | 0$ | 0$ | 23 | 0 | 648,189$ | 0$ | 10 | 0$ | 0$ | 0$ | 0$ | -15,000,000$ | 45,000,000$ | 45,000,000$ | 364,211,267$ | 364,211,267$ |
19 | PINCHER CREEK PREDATORS | 7000 | 6000 | 3000 | 5000 | 2000 | 100 | 70 | 40 | 30 | 175 | 20530 | 15114 | 8532 | 14171 | 4541 | 97.76% | 83.97% | 94.80% | 94.47% | 75.68% | 39 | 20963 - 91.14% | 1,557,355$ | 4,672,065$ | 23000 | 100 | 35,898,891$ | 920,000$ | 0$ | 0$ | 0$ | 0$ | 25 | 0 | 725,078$ | 0$ | 10 | 0$ | 0$ | 0$ | 0$ | -15,000,000$ | 45,000,000$ | 45,000,000$ | 346,676,803$ | 346,676,803$ |
20 | SAN JOSE BLASPHEMERS | 7000 | 6000 | 3000 | 5000 | 2000 | 100 | 60 | 35 | 25 | 200 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 42 | 0 - 0% | 0$ | 0$ | 23000 | 100 | 33,103,240$ | 1,040,000$ | 0$ | 0$ | 0$ | 0$ | 27 | 0 | 633,549$ | 0$ | 10 | 0$ | 0$ | 0$ | 0$ | -15,000,000$ | 45,000,000$ | 45,000,000$ | 443,695,028$ | 443,695,028$ |
21 | SYRACUSE BULLDOGS | 6000 | 5000 | 2000 | 4000 | 1000 | 105 | 95 | 85 | 75 | 150 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 42 | 0 - 0% | 0$ | 0$ | 18000 | 100 | 27,488,219$ | 960,000$ | 0$ | 0$ | 0$ | 0$ | 25 | 0 | 568,854$ | 0$ | 10 | 0$ | 0$ | 0$ | 0$ | -15,000,000$ | 45,000,000$ | 45,000,000$ | 345,204,461$ | 345,204,461$ |
22 | VANCOUVER MILLIONAIRES | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 18000 | 15000 | 6000 | 12000 | 3000 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 39 | 18000 - 100.00% | 1,270,000$ | 3,810,000$ | 18000 | 100 | 32,579,959$ | 920,000$ | 0$ | 0$ | 0$ | 0$ | 23 | 0 | 618,131$ | 0$ | 10 | 0$ | 0$ | 0$ | 0$ | -15,000,000$ | 45,000,000$ | 45,000,000$ | 200,173,246$ | 200,173,246$ |