| 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é de l'Aréna | Prix des Billets | Assistance | Assistance PCT | Revenus | Dépenses | Éstimation | Total de l'Équipe Éstimé | ||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| # | É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 - % | Revenus Moyen par Match | Revenus Annuels à ce Jour | Capacité de l'Aréna | Popularité de l'Équipe | Salaire Total des Joueurs | Salaire Total Moyen des Joueurs | Valeur du Cap Salarial Spécial | Dépenses Annuelles à Ce Jour | Cap Salarial Par Jour | Cap salarial à ce jour | Joueurs Inclut dans la Cap Salariale | Joueurs Exclut dans la Cap Salariale | Taxe de Luxe Totale | Revenus de la Saison Éstimés | Jours Restants de la Saison | Dépenses Par Jour | Dépenses de la Saison Éstimées | Dépenses de la Saison Éstimées | Compte Bancaire Actuel | Compte Bancaire Projeté |
| 1 | Adirondack Mountaineers | 2100 | 1250 | 1050 | 800 | 800 | 72 | 58 | 40 | 29 | 136 | 84000 | 50000 | 42000 | 32000 | 32000 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 0 | 6000 - 100.00% | 397,700$ | 15,908,000$ | 6000 | 210 | 1,245,000$ | 1,245,000$ | 0$ | 1,274,204$ | 0$ | 1,198,759$ | 0 | 0 | 0$ | 0$ | 0 | 7,952$ | 0$ | 0$ | 189,348,919$ | 189,348,919$ |
| 2 | Albany Indians | 3167 | 1775 | 1395 | 1475 | 700 | 59 | 48 | 38 | 29 | 136 | 108407 | 63795 | 46191 | 43190 | 27988 | 85.58% | 89.85% | 82.78% | 73.20% | 99.96% | 0 | 7239 - 85.05% | 406,808$ | 16,272,309$ | 8512 | 90 | 1,207,000$ | 1,207,000$ | 0$ | 1,316,014$ | 0$ | 1,239,551$ | 0 | 0 | 0$ | 0$ | 0 | 7,729$ | 0$ | 0$ | 200,465,157$ | 200,465,157$ |
| 3 | Binghamton Roadrunners | 1675 | 1100 | 850 | 660 | 570 | 130 | 96 | 64 | 48 | 280 | 67000 | 44000 | 34000 | 26400 | 22665 | 100.00% | 100.00% | 100.00% | 100.00% | 99.41% | 0 | 4852 - 99.93% | 568,085$ | 22,723,400$ | 4855 | 140 | 1,428,000$ | 1,428,000$ | 0$ | 1,372,559$ | 0$ | 1,297,120$ | 0 | 0 | 0$ | 0$ | 0 | 9,054$ | 0$ | 0$ | 316,925,138$ | 316,925,138$ |
| 4 | Boston Eagles | 2000 | 1250 | 750 | 2000 | 700 | 140 | 94 | 58 | 36 | 252 | 43993 | 28613 | 25218 | 26576 | 14494 | 54.99% | 57.23% | 84.06% | 33.22% | 51.76% | 0 | 3472 - 51.83% | 373,013$ | 14,920,510$ | 6700 | 75 | 1,321,000$ | 1,321,000$ | 0$ | 1,454,986$ | 0$ | 1,228,644$ | 0 | 0 | 0$ | 0$ | 0 | 9,313$ | 0$ | 0$ | 181,170,227$ | 181,170,227$ |
| 5 | Buffalo Wings | 2900 | 1374 | 771 | 1600 | 802 | 90 | 65 | 43 | 32 | 216 | 116000 | 54960 | 30840 | 64000 | 32080 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 0 | 7447 - 100.00% | 607,895$ | 24,315,800$ | 7447 | 160 | 1,510,000$ | 1,510,000$ | 0$ | 1,379,902$ | 0$ | 1,329,586$ | 0 | 0 | 0$ | 0$ | 0 | 9,398$ | 0$ | 0$ | 283,710,258$ | 283,710,258$ |
| 6 | Burlington Cougars | 2000 | 800 | 700 | 500 | 1000 | 122 | 90 | 58 | 43 | 252 | 80000 | 32000 | 28000 | 20000 | 40000 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 0 | 5000 - 100.00% | 630,100$ | 25,204,000$ | 5000 | 300 | 1,275,000$ | 1,275,000$ | 0$ | 1,359,311$ | 0$ | 1,258,689$ | 0 | 0 | 0$ | 0$ | 0 | 8,283$ | 0$ | 0$ | 338,986,374$ | 338,986,374$ |
| 7 | Catskill Bears | 2000 | 1500 | 1250 | 800 | 500 | 108 | 72 | 54 | 20 | 156 | 80000 | 60000 | 50000 | 32000 | 20000 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 0 | 6050 - 100.00% | 485,500$ | 19,420,000$ | 6050 | 290 | 1,381,000$ | 1,381,000$ | 0$ | 1,325,381$ | 0$ | 1,234,843$ | 0 | 0 | 0$ | 0$ | 0 | 8,861$ | 0$ | 0$ | 254,830,006$ | 254,830,006$ |
| 8 | Durham Panthers | 3500 | 1950 | 1200 | 1200 | 1500 | 82 | 65 | 51 | 40 | 202 | 134791 | 77210 | 46504 | 39117 | 45600 | 96.28% | 98.99% | 96.88% | 81.49% | 76.00% | 0 | 8581 - 91.77% | 730,477$ | 29,219,096$ | 9350 | 125 | 1,251,000$ | 1,251,000$ | 0$ | 1,265,071$ | 0$ | 1,192,122$ | 0 | 0 | 0$ | 0$ | 0 | 7,973$ | 0$ | 0$ | 403,177,099$ | 403,177,099$ |
| 9 | Hartford Red Devils | 3300 | 1575 | 1350 | 1250 | 900 | 100 | 68 | 52 | 36 | 169 | 88750 | 56618 | 40146 | 38303 | 34931 | 67.23% | 89.87% | 74.34% | 76.61% | 97.03% | 0 | 6469 - 77.24% | 552,372$ | 22,094,863$ | 8375 | 110 | 1,183,000$ | 1,183,000$ | 0$ | 1,262,935$ | 0$ | 1,202,570$ | 0 | 0 | 0$ | 0$ | 0 | 7,488$ | 0$ | 0$ | 269,505,698$ | 269,505,698$ |
| 10 | Kingston Kings | 3375 | 1875 | 1450 | 2427 | 825 | 68 | 54 | 40 | 26 | 134 | 109486 | 63295 | 47538 | 47017 | 31541 | 81.10% | 84.39% | 81.96% | 48.43% | 95.58% | 0 | 7472 - 75.08% | 455,336$ | 18,213,434$ | 9952 | 95 | 1,389,000$ | 1,389,000$ | 0$ | 1,480,882$ | 0$ | 1,229,378$ | 0 | 0 | 0$ | 0$ | 0 | 9,873$ | 0$ | 0$ | 261,130,993$ | 261,130,993$ |
| 11 | New Haven Hawks | 4500 | 2750 | 2275 | 1675 | 1100 | 73 | 64 | 50 | 26 | 160 | 117000 | 71520 | 59160 | 44755 | 30059 | 65.00% | 65.02% | 65.01% | 66.80% | 68.32% | 0 | 8062 - 65.55% | 551,234$ | 22,049,350$ | 12300 | 90 | 1,388,000$ | 1,388,000$ | 0$ | 1,449,865$ | 0$ | 1,208,402$ | 0 | 0 | 0$ | 0$ | 0 | 9,807$ | 0$ | 0$ | 317,003,468$ | 317,003,468$ |
| 12 | Orono Mohawks | 3170 | 2100 | 1500 | 1100 | 650 | 62 | 46 | 40 | 26 | 144 | 126800 | 83298 | 59804 | 44000 | 26000 | 100.00% | 99.16% | 99.67% | 100.00% | 100.00% | 0 | 8498 - 99.74% | 474,337$ | 18,973,468$ | 8520 | 125 | 1,329,000$ | 1,329,000$ | 0$ | 1,300,352$ | 0$ | 1,234,956$ | 0 | 0 | 0$ | 0$ | 0 | 8,398$ | 0$ | 0$ | 222,364,139$ | 222,364,139$ |
| 13 | Providence Englishmen | 4000 | 2500 | 2000 | 1500 | 1000 | 54 | 46 | 33 | 26 | 130 | 160000 | 99663 | 78892 | 60000 | 40000 | 100.00% | 99.66% | 98.62% | 100.00% | 100.00% | 0 | 10964 - 99.67% | 564,698$ | 22,587,934$ | 11000 | 150 | 1,317,000$ | 1,317,000$ | 0$ | 1,320,131$ | 0$ | 1,249,700$ | 0 | 0 | 0$ | 0$ | 0 | 8,355$ | 0$ | 0$ | 323,579,815$ | 323,579,815$ |
| 14 | Rochester Lakers | 2600 | 1800 | 1200 | 1000 | 800 | 72 | 58 | 46 | 32 | 184 | 103226 | 63895 | 46068 | 40000 | 25589 | 99.26% | 88.74% | 95.98% | 100.00% | 79.97% | 0 | 6969 - 94.18% | 481,142$ | 19,245,686$ | 7400 | 95 | 1,464,000$ | 1,464,000$ | 0$ | 1,405,633$ | 0$ | 1,335,212$ | 0 | 0 | 0$ | 0$ | 0 | 9,241$ | 0$ | 0$ | 236,582,794$ | 236,582,794$ |
| 15 | Syracuse Bulls | 2350 | 1550 | 1200 | 900 | 1050 | 108 | 72 | 58 | 36 | 192 | 81416 | 53591 | 36071 | 35775 | 28299 | 86.61% | 86.44% | 75.15% | 99.38% | 67.38% | 0 | 5879 - 83.39% | 536,623$ | 21,464,906$ | 7050 | 110 | 1,477,000$ | 1,477,000$ | 0$ | 1,394,982$ | 0$ | 1,319,543$ | 0 | 0 | 0$ | 0$ | 0 | 9,349$ | 0$ | 0$ | 271,390,371$ | 271,390,371$ |
| 16 | Worcester Plainsmen | 3800 | 2410 | 1600 | 1010 | 800 | 80 | 56 | 40 | 28 | 140 | 90595 | 56331 | 39762 | 37966 | 27159 | 59.60% | 58.43% | 62.13% | 93.98% | 84.87% | 0 | 6295 - 65.44% | 421,448$ | 16,857,924$ | 9620 | 80 | 1,312,000$ | 1,312,000$ | 0$ | 1,279,690$ | 0$ | 1,234,415$ | 0 | 0 | 0$ | 0$ | 0 | 8,175$ | 0$ | 0$ | 208,999,009$ | 208,999,009$ |