| 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 |
| Capacity | Ticket Price | Attendance | Attendance PCT | Income | Expenses | Estimate | ||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| # | Team | Level1 | Level2 | Level1 | Level2 | Level1 | Level2 | Level1 | Level2 | Home Games Left | Average Attendance - % | Average Income per Game | Year to Date Revenue | Capacity | Team Popularity | Players Total Salaries | Players Total Salaries Cap | Year To Date Expenses | Salary Cap Per Days | Salary Cap To Date | Players In Salary Cap | Players Out of Salary Cap | Estimated Season Revenue | Remaining Season Days | Expenses Per Days | Estimated Season Expenses |
| 1 |  Admirals (NAS) | 2000 | 1000 | 30 | 4 | 71390 | 36988 | 96.47% | 99.97% | 6 | 2929 - 97.64% | 92,205$ | 3,411,583$ | 3000 | 100 | 3,246,700$ | 3,246,700$ | 3,281,079$ | 28,988$ | 2,432,804$ | 0 | 0 | 553,230$ | 27 | 37,917$ | 720,423$ |
| 2 |  Americans (BUF) | 2000 | 1000 | 26 | 15 | 71498 | 28175 | 96.62% | 76.15% | 6 | 2694 - 89.80% | 91,880$ | 3,399,544$ | 3000 | 100 | 3,438,533$ | 3,438,533$ | 3,685,876$ | 30,701$ | 2,855,489$ | 0 | 0 | 551,277$ | 27 | 39,630$ | 752,970$ |
| 3 |  Barracuda (SJS) | 2000 | 1000 | 15 | 10 | 74000 | 36491 | 100.00% | 98.62% | 6 | 2986 - 99.54% | 59,395$ | 2,197,616$ | 3000 | 100 | 3,652,366$ | 3,652,366$ | 3,713,661$ | 32,610$ | 3,090,877$ | 0 | 0 | 356,370$ | 27 | 39,307$ | 746,833$ |
| 4 |  Bears (WAS) | 2000 | 1000 | 19 | 14 | 73737 | 35930 | 99.64% | 97.11% | 6 | 2964 - 98.80% | 76,676$ | 2,836,995$ | 3000 | 100 | 5,508,342$ | 5,508,342$ | 5,195,315$ | 49,182$ | 4,572,586$ | 0 | 0 | 460,053$ | 27 | 55,878$ | 1,061,682$ |
| 5 |  Bruins (BOS) | 2000 | 1000 | 20 | 10 | 73068 | 36451 | 98.74% | 98.52% | 6 | 2960 - 98.67% | 73,528$ | 2,720,546$ | 3000 | 100 | 5,382,416$ | 5,382,416$ | 6,515,587$ | 48,057$ | 4,439,662$ | 0 | 0 | 441,170$ | 27 | 70,379$ | 1,337,201$ |
| 6 |  Canucks (VAN) | 2000 | 1000 | 35 | 15 | 51159 | 27705 | 69.13% | 74.88% | 6 | 2131 - 71.05% | 88,842$ | 3,287,151$ | 3000 | 100 | 2,414,833$ | 2,414,833$ | 2,866,019$ | 21,561$ | 2,035,622$ | 0 | 0 | 533,052$ | 27 | 30,490$ | 579,310$ |
| 7 |  Checkers (FLO) | 2000 | 1000 | 35 | 15 | 52077 | 28435 | 68.52% | 74.83% | 5 | 2119 - 70.62% | 88,193$ | 3,351,341$ | 3000 | 100 | 3,078,550$ | 3,078,550$ | 3,301,427$ | 27,487$ | 2,440,002$ | 0 | 0 | 440,966$ | 27 | 36,416$ | 691,904$ |
| 8 |  Comets (NJD) | 2000 | 1000 | 35 | 15 | 51185 | 27958 | 69.17% | 75.56% | 6 | 2139 - 71.30% | 89,031$ | 3,294,162$ | 3000 | 100 | 3,135,900$ | 3,135,900$ | 3,571,415$ | 27,999$ | 2,533,442$ | 0 | 0 | 534,188$ | 27 | 39,160$ | 744,040$ |
| 9 |  Condors (EDM) | 2000 | 1000 | 30 | 15 | 70718 | 27934 | 95.56% | 75.50% | 6 | 2666 - 88.88% | 102,309$ | 3,785,418$ | 3000 | 100 | 4,489,670$ | 4,489,670$ | 5,388,349$ | 40,086$ | 3,727,647$ | 0 | 0 | 613,852$ | 27 | 57,943$ | 1,100,917$ |
| 10 |  Crunch (TAM) | 2000 | 1000 | 35 | 15 | 51452 | 27889 | 69.53% | 75.38% | 6 | 2144 - 71.48% | 89,366$ | 3,306,541$ | 3000 | 100 | 2,615,800$ | 2,615,800$ | 2,986,654$ | 23,355$ | 2,156,307$ | 0 | 0 | 536,196$ | 27 | 32,284$ | 613,396$ |
| 11 |  Eagles (COL) | 2000 | 1000 | 35 | 15 | 53013 | 28246 | 69.75% | 74.33% | 5 | 2138 - 71.28% | 89,366$ | 3,395,924$ | 3000 | 100 | 2,932,117$ | 2,932,117$ | 3,024,996$ | 26,180$ | 2,402,268$ | 0 | 0 | 446,832$ | 27 | 32,876$ | 624,644$ |
| 12 |  Griffins (DET) | 2000 | 1000 | 35 | 15 | 53018 | 29177 | 69.76% | 76.78% | 5 | 2163 - 72.10% | 89,921$ | 3,416,996$ | 3000 | 100 | 3,106,850$ | 3,106,850$ | 3,230,931$ | 27,740$ | 2,400,585$ | 0 | 0 | 449,605$ | 27 | 36,668$ | 696,692$ |
| 13 |  Gulls (ANA) | 2000 | 1000 | 40 | 20 | 46652 | 21161 | 63.04% | 57.19% | 6 | 1833 - 61.09% | 92,191$ | 3,411,055$ | 3000 | 100 | 3,684,617$ | 3,684,617$ | 7,247,808$ | 32,898$ | 3,096,009$ | 0 | 0 | 553,144$ | 27 | 77,541$ | 1,473,279$ |
| 14 |  Heat (CAL) | 2000 | 1000 | 50 | 30 | 37727 | 18500 | 50.98% | 50.00% | 6 | 1520 - 50.65% | 98,314$ | 3,637,611$ | 3000 | 100 | 2,945,595$ | 2,945,595$ | 3,273,797$ | 26,300$ | 2,443,400$ | 0 | 0 | 589,883$ | 27 | 35,229$ | 669,351$ |
| 15 |  IceHogs (CHI) | 2000 | 1000 | 35 | 15 | 52488 | 28459 | 69.06% | 74.89% | 5 | 2130 - 71.01% | 88,771$ | 3,373,310$ | 3000 | 100 | 3,041,617$ | 3,041,617$ | 3,513,541$ | 26,264$ | 2,673,322$ | 0 | 0 | 443,857$ | 27 | 36,086$ | 685,634$ |
| 16 |  Islanders (NYI) | 2000 | 1000 | 30 | 15 | 70309 | 28686 | 95.01% | 77.53% | 6 | 2676 - 89.18% | 102,269$ | 3,783,946$ | 3000 | 100 | 2,706,250$ | 2,706,250$ | 2,952,235$ | 24,163$ | 2,292,121$ | 0 | 0 | 613,613$ | 27 | 31,261$ | 593,959$ |
| 17 |  Marlies (TOR) | 2000 | 1000 | 35 | 15 | 52780 | 28559 | 69.45% | 75.16% | 5 | 2141 - 71.35% | 89,231$ | 3,390,771$ | 3000 | 100 | 3,655,567$ | 3,655,567$ | 3,566,835$ | 31,304$ | 2,922,095$ | 0 | 0 | 446,154$ | 27 | 39,335$ | 747,365$ |
| 18 |  Monsters (CBJ) | 2000 | 1000 | 35 | 15 | 49881 | 28197 | 67.41% | 76.21% | 6 | 2110 - 70.34% | 87,338$ | 3,231,496$ | 3000 | 100 | 2,670,000$ | 2,670,000$ | 3,561,712$ | 23,839$ | 2,209,011$ | 0 | 0 | 524,026$ | 27 | 38,125$ | 724,375$ |
| 19 |  Moose (WPG) | 2000 | 1000 | 25 | 10 | 70786 | 36280 | 95.66% | 98.05% | 6 | 2894 - 96.46% | 85,874$ | 3,177,349$ | 3000 | 100 | 4,330,133$ | 4,330,133$ | 4,276,440$ | 38,662$ | 3,612,141$ | 0 | 0 | 515,246$ | 27 | 45,805$ | 870,295$ |
| 20 | Penguins (PIT) | 2000 | 1000 | 35 | 15 | 52165 | 27370 | 70.49% | 73.97% | 6 | 2150 - 71.65% | 90,057$ | 3,332,125$ | 3000 | 100 | 4,349,500$ | 4,349,500$ | 4,441,959$ | 38,835$ | 3,611,655$ | 0 | 0 | 540,345$ | 27 | 47,763$ | 907,497$ |
| 21 |  Phantoms (PHI) | 2000 | 1000 | 25 | 10 | 73660 | 37389 | 96.92% | 98.39% | 5 | 2922 - 97.41% | 86,867$ | 3,300,931$ | 3000 | 100 | 5,931,200$ | 5,931,200$ | 5,574,279$ | 52,957$ | 4,943,454$ | 0 | 0 | 434,333$ | 27 | 59,654$ | 1,133,426$ |
| 22 |  Reign (LAK) | 2000 | 1000 | 30 | 15 | 70899 | 28456 | 95.81% | 76.91% | 6 | 2685 - 89.51% | 102,843$ | 3,805,176$ | 3000 | 100 | 3,366,800$ | 3,366,800$ | 3,501,898$ | 30,061$ | 2,671,546$ | 0 | 0 | 617,056$ | 27 | 38,989$ | 740,791$ |
| 23 |  Roadrunners (ARZ) | 2000 | 1000 | 25 | 10 | 70994 | 36380 | 95.94% | 98.32% | 6 | 2902 - 96.73% | 86,124$ | 3,186,586$ | 3000 | 100 | 4,345,466$ | 4,345,466$ | 4,067,769$ | 38,799$ | 3,445,040$ | 0 | 0 | 516,744$ | 27 | 45,495$ | 864,405$ |
| 24 |  Rocket (MON) | 2000 | 1000 | 26 | 20 | 73448 | 21708 | 96.64% | 57.13% | 5 | 2504 - 83.47% | 91,902$ | 3,492,275$ | 3000 | 100 | 2,922,450$ | 2,922,450$ | 3,187,793$ | 26,093$ | 2,565,016$ | 0 | 0 | 459,510$ | 27 | 32,790$ | 623,010$ |
| 25 |  Senators (OTT) | 2000 | 1000 | 35 | 15 | 52199 | 28214 | 70.54% | 76.25% | 6 | 2173 - 72.44% | 90,615$ | 3,352,760$ | 3000 | 100 | 2,581,450$ | 2,581,450$ | 3,001,544$ | 23,049$ | 2,171,240$ | 0 | 0 | 543,691$ | 27 | 31,977$ | 607,563$ |
| 26 | Silver Knights (LVK) | 2000 | 1000 | 35 | 15 | 52650 | 28221 | 71.15% | 76.27% | 6 | 2186 - 72.86% | 91,255$ | 3,376,438$ | 3000 | 100 | 2,621,367$ | 2,621,367$ | 3,069,195$ | 23,405$ | 2,238,799$ | 0 | 0 | 547,530$ | 27 | 32,334$ | 614,346$ |
| 27 |  Stars (DAL) | 2000 | 1000 | 35 | 15 | 53235 | 28848 | 71.94% | 77.97% | 6 | 2218 - 73.95% | 92,458$ | 3,420,960$ | 3000 | 100 | 8,173,200$ | 8,173,200$ | 7,768,392$ | 72,975$ | 6,938,039$ | 0 | 0 | 554,750$ | 27 | 81,904$ | 1,556,176$ |
| 28 |  Thunderbirds (STL) | 2000 | 1000 | 28 | 12 | 74379 | 37457 | 97.87% | 98.57% | 5 | 2943 - 98.10% | 99,285$ | 3,772,822$ | 3000 | 100 | 5,285,534$ | 5,285,534$ | 5,990,112$ | 47,192$ | 4,298,254$ | 0 | 0 | 496,424$ | 27 | 65,049$ | 1,235,931$ |
| 29 |  Wild (MIN) | 2000 | 1000 | 25 | 10 | 72975 | 36765 | 98.61% | 99.36% | 6 | 2966 - 98.86% | 88,273$ | 3,266,116$ | 3000 | 100 | 5,343,116$ | 5,343,116$ | 5,369,137$ | 47,706$ | 4,538,740$ | 0 | 0 | 529,640$ | 27 | 56,635$ | 1,076,065$ |
| 30 |  Wolf Pack (NYR) | 2000 | 1000 | 35 | 15 | 52178 | 27518 | 70.51% | 74.37% | 6 | 2154 - 71.80% | 90,165$ | 3,336,111$ | 3000 | 100 | 2,675,200$ | 2,675,200$ | 3,013,315$ | 23,886$ | 2,182,999$ | 0 | 0 | 540,991$ | 27 | 32,814$ | 623,466$ |
| 31 |  Wolves (HAR) | 2000 | 1000 | 35 | 16 | 53272 | 26969 | 70.09% | 70.97% | 5 | 2112 - 70.39% | 90,028$ | 3,421,077$ | 3000 | 100 | 3,507,300$ | 3,507,300$ | 3,809,438$ | 31,315$ | 2,979,062$ | 0 | 0 | 450,142$ | 27 | 40,244$ | 764,636$ |