| 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 Average Salaries | 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 | 70 | 40 | 72993 | 36828 | 91.24% | 92.07% | 0 | 2746 - 91.52% | 172,794$ | 6,911,763$ | 3000 | 100 | 2,327,000$ | 2,308,500$ | 3,136,670$ | 11,254$ | 2,282,454$ | 0 | 0 | 0$ | 0 | 15,806$ | 15,806$ |
| 2 |  Americans (Buf) | 2000 | 1000 | 70 | 40 | 73627 | 37049 | 92.03% | 92.62% | 0 | 2767 - 92.23% | 174,191$ | 6,967,642$ | 3000 | 100 | 1,923,500$ | 1,893,500$ | 2,589,568$ | 9,570$ | 1,828,368$ | 0 | 0 | 0$ | 0 | 13,301$ | 13,301$ |
| 3 |  Barracuda (S.J) | 2000 | 1000 | 70 | 40 | 74112 | 37182 | 92.64% | 92.96% | 0 | 2782 - 92.75% | 175,222$ | 7,008,875$ | 3000 | 100 | 2,004,500$ | 2,004,500$ | 2,618,013$ | 9,973$ | 1,944,863$ | 0 | 0 | 0$ | 0 | 13,206$ | 13,206$ |
| 4 |  Bears (Was) | 2000 | 1000 | 70 | 40 | 74739 | 37757 | 93.42% | 94.39% | 0 | 2812 - 93.75% | 176,978$ | 7,079,111$ | 3000 | 100 | 2,027,500$ | 1,887,500$ | 2,575,920$ | 10,087$ | 2,005,903$ | 0 | 0 | 0$ | 0 | 12,823$ | 12,823$ |
| 5 |  Canucks (Van) | 2000 | 1000 | 70 | 40 | 74438 | 37679 | 93.05% | 94.20% | 0 | 2803 - 93.43% | 176,343$ | 7,053,709$ | 3000 | 100 | 2,267,000$ | 2,162,500$ | 2,596,043$ | 11,279$ | 2,259,985$ | 0 | 0 | 0$ | 0 | 12,896$ | 12,896$ |
| 6 |  Checkers (Flo) | 2000 | 1000 | 70 | 40 | 74546 | 37185 | 93.18% | 92.96% | 0 | 2793 - 93.11% | 176,023$ | 7,040,900$ | 3000 | 100 | 2,642,500$ | 2,307,500$ | 3,239,298$ | 13,147$ | 2,435,076$ | 0 | 0 | 0$ | 0 | 17,127$ | 17,127$ |
| 7 |  Comets (N.J) | 2000 | 1000 | 70 | 40 | 73274 | 36755 | 91.59% | 91.89% | 0 | 2751 - 91.69% | 173,234$ | 6,929,348$ | 3000 | 100 | 1,672,500$ | 1,632,500$ | 2,233,112$ | 8,321$ | 1,625,282$ | 0 | 0 | 0$ | 0 | 11,306$ | 11,306$ |
| 8 |  Condors (Edm) | 2000 | 1000 | 70 | 40 | 74440 | 36996 | 93.05% | 92.49% | 0 | 2786 - 92.86% | 175,629$ | 7,025,173$ | 3000 | 100 | 3,482,500$ | 3,297,500$ | 2,990,898$ | 17,326$ | 2,460,691$ | 0 | 0 | 0$ | 0 | 19,813$ | 19,813$ |
| 9 |  Crunch (T.B) | 2000 | 1000 | 70 | 40 | 73351 | 36909 | 91.69% | 92.27% | 0 | 2757 - 91.88% | 173,537$ | 6,941,477$ | 3000 | 100 | 1,710,000$ | 1,625,000$ | 2,101,504$ | 8,507$ | 1,585,354$ | 0 | 0 | 0$ | 0 | 10,995$ | 10,995$ |
| 10 |  Eagles (Col) | 2000 | 1000 | 70 | 40 | 74753 | 37037 | 93.44% | 92.59% | 0 | 2795 - 93.16% | 176,248$ | 7,049,901$ | 3000 | 100 | 2,990,000$ | 2,784,000$ | 3,089,329$ | 14,428$ | 2,427,747$ | 0 | 0 | 0$ | 0 | 18,109$ | 18,109$ |
| 11 |  Griffins (Det) | 2000 | 1000 | 70 | 40 | 76084 | 37815 | 95.11% | 94.54% | 0 | 2847 - 94.92% | 179,510$ | 7,180,404$ | 3000 | 100 | 3,607,500$ | 2,200,000$ | 3,730,694$ | 17,948$ | 2,769,267$ | 0 | 0 | 0$ | 0 | 22,177$ | 22,177$ |
| 12 |  Icehogs (Chi) | 2000 | 1000 | 70 | 40 | 74504 | 37394 | 93.13% | 93.49% | 0 | 2797 - 93.25% | 176,165$ | 7,046,591$ | 3000 | 100 | 2,206,000$ | 1,897,500$ | 2,814,265$ | 10,975$ | 2,094,205$ | 0 | 0 | 0$ | 0 | 14,458$ | 14,458$ |
| 13 |  Islander (NyI) | 2000 | 1000 | 70 | 40 | 74579 | 37098 | 93.22% | 92.75% | 0 | 2792 - 93.06% | 175,992$ | 7,039,673$ | 3000 | 100 | 1,575,000$ | 1,440,000$ | 2,477,214$ | 7,836$ | 1,677,072$ | 0 | 0 | 0$ | 0 | 11,816$ | 11,816$ |
| 14 |  Little Stars (Dal) | 2000 | 1000 | 70 | 40 | 74558 | 36968 | 93.20% | 92.42% | 0 | 2788 - 92.94% | 175,817$ | 7,032,667$ | 3000 | 100 | 1,802,000$ | 1,672,000$ | 2,646,590$ | 8,965$ | 1,883,534$ | 0 | 0 | 0$ | 0 | 12,697$ | 12,697$ |
| 15 |  Marlies (TOR) | 2000 | 1000 | 70 | 40 | 75051 | 36479 | 93.81% | 91.20% | 0 | 2788 - 92.94% | 176,209$ | 7,048,369$ | 3000 | 100 | 2,289,500$ | 2,254,500$ | 2,878,174$ | 11,391$ | 2,250,775$ | 0 | 0 | 0$ | 0 | 14,127$ | 14,127$ |
| 16 |  Moose (Win) | 2000 | 1000 | 70 | 40 | 73985 | 37435 | 92.48% | 93.59% | 0 | 2786 - 92.85% | 175,254$ | 7,010,166$ | 3000 | 100 | 2,110,000$ | 2,085,000$ | 3,551,451$ | 10,498$ | 2,597,580$ | 0 | 0 | 0$ | 0 | 15,224$ | 15,224$ |
| 17 |  Penguins (Pit) | 2000 | 1000 | 70 | 40 | 74480 | 36848 | 93.10% | 92.12% | 0 | 2783 - 92.77% | 175,547$ | 7,021,894$ | 3000 | 100 | 2,667,499$ | 2,295,000$ | 2,769,797$ | 13,271$ | 2,246,903$ | 0 | 0 | 0$ | 0 | 15,759$ | 15,759$ |
| 18 |  Phantoms (Phi) | 2000 | 1000 | 70 | 40 | 74332 | 37320 | 92.92% | 93.30% | 0 | 2791 - 93.04% | 175,771$ | 7,030,843$ | 3000 | 100 | 2,270,000$ | 2,152,500$ | 2,287,420$ | 11,045$ | 1,785,938$ | 0 | 0 | 0$ | 0 | 13,781$ | 13,781$ |
| 19 |  Punishers (Bos) | 2000 | 1000 | 70 | 40 | 72129 | 36759 | 90.16% | 91.90% | 0 | 2722 - 90.74% | 171,134$ | 6,845,357$ | 3000 | 100 | 2,429,500$ | 2,284,500$ | 2,172,125$ | 12,087$ | 1,813,962$ | 0 | 0 | 0$ | 0 | 13,580$ | 13,580$ |
| 20 |  Reign (L.A) | 2000 | 1000 | 70 | 40 | 74285 | 36990 | 92.86% | 92.48% | 0 | 2782 - 92.73% | 175,338$ | 7,013,527$ | 3000 | 100 | 3,012,500$ | 2,927,500$ | 2,833,334$ | 14,714$ | 2,082,377$ | 0 | 0 | 0$ | 0 | 18,719$ | 18,719$ |
| 21 |  Rocket (Mon) | 2000 | 1000 | 70 | 40 | 74034 | 37349 | 92.54% | 93.37% | 0 | 2785 - 92.82% | 175,254$ | 7,010,158$ | 3000 | 100 | 2,750,000$ | 2,675,000$ | 3,056,695$ | 13,682$ | 2,555,492$ | 0 | 0 | 0$ | 0 | 16,169$ | 16,169$ |
| 22 |  Senators (Ott) | 2000 | 1000 | 70 | 40 | 73839 | 36629 | 92.30% | 91.57% | 0 | 2762 - 92.06% | 174,140$ | 6,965,585$ | 3000 | 100 | 1,967,500$ | 1,967,500$ | 2,926,864$ | 9,366$ | 1,924,659$ | 0 | 0 | 0$ | 0 | 14,764$ | 14,764$ |
| 23 |  Silver Knights (Veg) | 2000 | 1000 | 70 | 40 | 74785 | 37903 | 93.48% | 94.76% | 0 | 2817 - 93.91% | 177,216$ | 7,088,624$ | 3000 | 100 | 1,832,500$ | 1,775,000$ | 2,325,317$ | 9,117$ | 1,793,105$ | 0 | 0 | 0$ | 0 | 11,604$ | 11,604$ |
| 24 |  Thunderbirds (Stl) | 2000 | 1000 | 70 | 40 | 75109 | 37582 | 93.89% | 93.96% | 0 | 2817 - 93.91% | 177,474$ | 7,098,955$ | 3000 | 100 | 1,807,500$ | 1,755,000$ | 2,466,006$ | 8,993$ | 1,798,048$ | 0 | 0 | 0$ | 0 | 12,226$ | 12,226$ |
| 25 |  Wolfpack (NyR) | 2000 | 1000 | 70 | 40 | 74804 | 37297 | 93.51% | 93.24% | 0 | 2803 - 93.42% | 176,614$ | 7,064,567$ | 3000 | 100 | 2,910,000$ | 2,865,000$ | 3,038,228$ | 14,478$ | 2,678,427$ | 0 | 0 | 0$ | 0 | 16,219$ | 16,219$ |
| 26 |  Wranglers (Cal) | 2000 | 1000 | 70 | 40 | 73566 | 36969 | 91.96% | 92.42% | 0 | 2763 - 92.11% | 173,995$ | 6,959,798$ | 3000 | 100 | 2,247,000$ | 2,074,500$ | 3,023,608$ | 11,179$ | 2,222,763$ | 0 | 0 | 0$ | 0 | 15,159$ | 15,159$ |