| 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 | Plafond Salariale total 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 20,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 | 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 | 44,684,218$ | 44,684,218$ | 0$ | 0$ | 0$ | 0$ | 19 | 0 | 886,793$ | 0$ | 7 | 0$ | 0$ | 0$ | 0$ | -20,000,000$ | 55,000,000$ | 55,000,000$ | 425,315,116$ | 425,315,116$ |
| 2 | BROOKLYN BLAZERS | 6500 | 5500 | 2500 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 19500 | 16500 | 7500 | 12000 | 3000 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 39 | 19500 - 100.00% | 1,367,500$ | 4,102,500$ | 19500 | 100 | 37,899,190$ | 37,899,190$ | 0$ | 0$ | 0$ | 0$ | 24 | 0 | 746,531$ | 0$ | 7 | 0$ | 0$ | 0$ | 0$ | -20,000,000$ | 55,000,000$ | 55,000,000$ | 385,373,290$ | 385,373,290$ |
| 3 | CALGARY COWBOYS | 7500 | 6500 | 3500 | 4500 | 2500 | 90 | 65 | 33 | 25 | 225 | 15000 | 12624 | 6419 | 9000 | 2724 | 100.00% | 97.11% | 91.70% | 100.00% | 54.48% | 40 | 22884 - 93.40% | 1,610,144$ | 3,220,287$ | 24500 | 100 | 43,015,622$ | 43,015,622$ | 0$ | 0$ | 0$ | 0$ | 25 | 0 | 804,114$ | 0$ | 7 | 0$ | 0$ | 0$ | 0$ | -20,000,000$ | 55,000,000$ | 55,000,000$ | 405,720,591$ | 405,720,591$ |
| 4 | CAPE BRETON CELTS | 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 | 41,265,063$ | 41,265,063$ | 0$ | 0$ | 0$ | 0$ | 22 | 0 | 755,957$ | 0$ | 7 | 0$ | 0$ | 0$ | 0$ | -20,000,000$ | 55,000,000$ | 55,000,000$ | 444,157,818$ | 444,157,818$ |
| 5 | CAPE FEAR PROWLERS | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 12000 | 10000 | 4000 | 8000 | 2000 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 40 | 18000 - 100.00% | 1,270,000$ | 2,540,000$ | 18000 | 100 | 44,001,981$ | 44,001,981$ | 0$ | 0$ | 0$ | 0$ | 20 | 0 | 951,954$ | 0$ | 7 | 0$ | 0$ | 0$ | 0$ | -20,000,000$ | 55,000,000$ | 55,000,000$ | 435,191,547$ | 435,191,547$ |
| 6 | CHICAGO CRUSHERS | 7000 | 6000 | 3000 | 5000 | 2000 | 100 | 70 | 40 | 30 | 175 | 21000 | 16432 | 8619 | 15000 | 5194 | 100.00% | 91.29% | 95.77% | 100.00% | 86.57% | 39 | 22082 - 96.01% | 1,651,317$ | 4,953,950$ | 23000 | 100 | 39,190,704$ | 39,190,704$ | 0$ | 0$ | 0$ | 0$ | 20 | 0 | 661,071$ | 0$ | 7 | 0$ | 0$ | 0$ | 0$ | -20,000,000$ | 55,000,000$ | 55,000,000$ | 473,351,102$ | 473,351,102$ |
| 7 | COLORADO WOLVES | 6000 | 5000 | 2000 | 4000 | 1000 | 120 | 70 | 50 | 40 | 300 | 16496 | 15000 | 6000 | 10720 | 3000 | 91.64% | 100.00% | 100.00% | 89.33% | 100.00% | 39 | 17072 - 94.84% | 1,552,773$ | 4,658,320$ | 18000 | 100 | 28,641,532$ | 28,641,532$ | 0$ | 0$ | 0$ | 0$ | 20 | 0 | 523,590$ | 0$ | 7 | 0$ | 0$ | 0$ | 0$ | -20,000,000$ | 55,000,000$ | 55,000,000$ | 534,226,491$ | 534,226,491$ |
| 8 | COQUITLAM KNIGHTS | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 65 | 40 | 30 | 225 | 30000 | 25000 | 10000 | 20000 | 5000 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 37 | 18000 - 100.00% | 1,350,000$ | 6,750,000$ | 18000 | 100 | 36,407,000$ | 36,407,000$ | 0$ | 0$ | 0$ | 0$ | 21 | 0 | 637,076$ | 0$ | 7 | 0$ | 0$ | 0$ | 0$ | -20,000,000$ | 55,000,000$ | 55,000,000$ | 427,363,479$ | 427,363,479$ |
| 9 | DETROIT RED WINGS | 6000 | 5000 | 2000 | 4000 | 1000 | 125 | 75 | 40 | 30 | 250 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 42 | 0 - 0% | 0$ | 0$ | 18000 | 100 | 34,938,668$ | 34,938,668$ | 0$ | 0$ | 0$ | 0$ | 23 | 0 | 632,013$ | 0$ | 7 | 0$ | 0$ | 0$ | 0$ | -20,000,000$ | 55,000,000$ | 55,000,000$ | 255,426,960$ | 255,426,960$ |
| 10 | EDMONTON BUSCHWACKERS | 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 | 34,662,110$ | 34,662,110$ | 0$ | 0$ | 0$ | 0$ | 20 | 0 | 670,938$ | 0$ | 7 | 0$ | 0$ | 0$ | 0$ | -20,000,000$ | 55,000,000$ | 55,000,000$ | 481,579,829$ | 481,579,829$ |
| 11 | HALIFAX HIGHLANDERS | 6700 | 5700 | 2200 | 4200 | 1700 | 139 | 89 | 69 | 58 | 299 | 60398 | 53972 | 20341 | 35888 | 13096 | 90.15% | 94.69% | 92.46% | 85.45% | 77.04% | 32 | 18370 - 89.61% | 1,855,567$ | 18,555,669$ | 20500 | 100 | 41,402,860$ | 41,402,860$ | 0$ | 0$ | 0$ | 0$ | 24 | 0 | 729,488$ | 0$ | 7 | 0$ | 0$ | 0$ | 0$ | -20,000,000$ | 55,000,000$ | 55,000,000$ | 580,826,963$ | 580,826,963$ |
| 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 | 31,737,869$ | 31,737,869$ | 0$ | 0$ | 0$ | 0$ | 23 | 0 | 673,821$ | 0$ | 7 | 0$ | 0$ | 0$ | 0$ | -20,000,000$ | 55,000,000$ | 55,000,000$ | 474,595,117$ | 474,595,117$ |
| 13 | LAS CRUCES SPURS | 7500 | 6500 | 3500 | 4500 | 2500 | 102 | 63 | 35 | 27 | 240 | 56147 | 51528 | 26496 | 36000 | 11134 | 93.58% | 99.09% | 94.63% | 100.00% | 55.67% | 34 | 22663 - 92.50% | 1,693,097$ | 13,544,778$ | 24500 | 100 | 37,994,876$ | 37,994,876$ | 0$ | 0$ | 0$ | 0$ | 25 | 0 | 730,808$ | 0$ | 7 | 0$ | 0$ | 0$ | 0$ | -20,000,000$ | 55,000,000$ | 55,000,000$ | 477,479,746$ | 477,479,746$ |
| 14 | MANHATTAN ISLANDERS | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 66000 | 55000 | 22000 | 44000 | 11000 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 31 | 18000 - 100.00% | 1,270,000$ | 13,970,000$ | 18000 | 100 | 38,216,384$ | 38,216,384$ | 0$ | 0$ | 0$ | 0$ | 22 | 0 | 714,561$ | 0$ | 7 | 0$ | 0$ | 0$ | 0$ | -20,000,000$ | 55,000,000$ | 55,000,000$ | 395,574,636$ | 395,574,636$ |
| 15 | NEWTON NIGHTMARES | 6000 | 5000 | 2000 | 4000 | 1000 | 90 | 70 | 45 | 30 | 150 | 54000 | 44988 | 18000 | 36000 | 9000 | 100.00% | 99.97% | 100.00% | 100.00% | 100.00% | 33 | 17999 - 99.99% | 1,249,907$ | 11,249,160$ | 18000 | 100 | 41,392,408$ | 41,392,408$ | 0$ | 0$ | 0$ | 0$ | 26 | 0 | 786,196$ | 0$ | 7 | 0$ | 0$ | 0$ | 0$ | -20,000,000$ | 55,000,000$ | 55,000,000$ | 303,136,735$ | 303,136,735$ |
| 16 | NORTH VAN ROCKERS | 7500 | 6500 | 5500 | 5000 | 1500 | 100 | 60 | 30 | 28 | 200 | 22498 | 19071 | 9308 | 14894 | 4500 | 99.99% | 97.80% | 56.41% | 99.29% | 100.00% | 39 | 23424 - 90.09% | 1,663,444$ | 4,990,332$ | 26000 | 100 | 39,490,651$ | 39,490,651$ | 0$ | 0$ | 0$ | 0$ | 20 | 0 | 695,867$ | 0$ | 7 | 0$ | 0$ | 0$ | 0$ | -20,000,000$ | 55,000,000$ | 55,000,000$ | 503,500,479$ | 503,500,479$ |
| 17 | PENSACOLA BADGERS | 6000 | 5000 | 2000 | 4000 | 1000 | 105 | 95 | 85 | 70 | 150 | 12000 | 7946 | 2889 | 4806 | 2000 | 100.00% | 79.46% | 72.23% | 60.08% | 100.00% | 40 | 14821 - 82.34% | 1,448,428$ | 2,896,855$ | 18000 | 100 | 37,338,336$ | 37,338,336$ | 0$ | 0$ | 0$ | 0$ | 22 | 0 | 727,373$ | 0$ | 7 | 0$ | 0$ | 0$ | 0$ | -20,000,000$ | 55,000,000$ | 55,000,000$ | 401,182,998$ | 401,182,998$ |
| 18 | PHILADELPHIA MADMEN | 6500 | 5500 | 2000 | 4000 | 1500 | 89 | 56 | 49 | 35 | 210 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 42 | 0 - 0% | 0$ | 0$ | 19500 | 100 | 31,970,411$ | 31,970,411$ | 0$ | 0$ | 0$ | 0$ | 25 | 0 | 588,859$ | 0$ | 7 | 0$ | 0$ | 0$ | 0$ | -20,000,000$ | 55,000,000$ | 55,000,000$ | 413,575,499$ | 413,575,499$ |
| 19 | PINCHER CREEK PREDATORS | 7000 | 6000 | 3000 | 5000 | 2000 | 100 | 70 | 40 | 30 | 175 | 35000 | 27022 | 15000 | 24716 | 9118 | 100.00% | 90.07% | 100.00% | 98.86% | 91.18% | 37 | 22171 - 96.40% | 1,665,734$ | 8,328,670$ | 23000 | 100 | 36,162,879$ | 36,162,879$ | 0$ | 0$ | 0$ | 0$ | 19 | 0 | 741,751$ | 0$ | 7 | 0$ | 0$ | 0$ | 0$ | -20,000,000$ | 55,000,000$ | 55,000,000$ | 423,730,967$ | 423,730,967$ |
| 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 | 35,096,531$ | 35,096,531$ | 0$ | 0$ | 0$ | 0$ | 24 | 0 | 690,613$ | 0$ | 7 | 0$ | 0$ | 0$ | 0$ | -20,000,000$ | 55,000,000$ | 55,000,000$ | 498,372,732$ | 498,372,732$ |
| 21 | SYRACUSE BULLDOGS | 6000 | 5000 | 2000 | 4000 | 1000 | 86 | 85 | 84 | 75 | 200 | 30000 | 23904 | 8340 | 12556 | 5000 | 100.00% | 95.62% | 83.40% | 62.78% | 100.00% | 37 | 15960 - 88.67% | 1,450,820$ | 7,254,100$ | 18000 | 100 | 35,563,098$ | 35,563,098$ | 0$ | 0$ | 0$ | 0$ | 22 | 0 | 672,267$ | 0$ | 7 | 0$ | 0$ | 0$ | 0$ | -20,000,000$ | 55,000,000$ | 55,000,000$ | 389,962,651$ | 389,962,651$ |
| 22 | VANCOUVER MILLIONAIRES | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 30000 | 25000 | 10000 | 20000 | 5000 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 37 | 18000 - 100.00% | 1,270,000$ | 6,350,000$ | 18000 | 100 | 41,440,000$ | 41,440,000$ | 0$ | 0$ | 0$ | 0$ | 23 | 0 | 724,450$ | 0$ | 7 | 0$ | 0$ | 0$ | 0$ | -20,000,000$ | 55,000,000$ | 55,000,000$ | 241,526,135$ | 241,526,135$ |
BANGOR PUPPIES
CHICAGO UNDERTAKERS
COQUITLAM EXPRESS
DETROIT STEELERS
HAWAII PUNCH
LAS CRUCES MESCALEROS
NEWTON NIGHTHAWKS
NORTH VAN ROCKERS
PENSACOLA BLACK BEARS
PHILADELPHIA PHANTOMS
VANCOUVER THOUSANDAIRES
BROOKLYN GRINDERS
CALGARY WRANGLERS
CAPE BRETON LEPRECHAUNS
CAPE FEAR WILDCATS
COLORADO CUBS
EDMONTON OILERS
HALIFAX HELL
MANHATTAN SWEDES
PINCHER CREEK WOLVERINES
SAN JOSE AVACADOES
SYRACUSE BABY BULLS