| 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 | Aces (Veg) | 2000 | 1000 | 200 | 100 | 0 | 0 | 0% | 0% | 39 | 0 - 0% | 0$ | 0$ | 3000 | 100 | 1,760,000$ | 1,760,000$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 1 | 0$ | 0$ |
| 2 |  Admirals (Nsh) | 2000 | 1000 | 200 | 100 | 0 | 0 | 0% | 0% | 39 | 0 - 0% | 0$ | 0$ | 3000 | 100 | 2,070,000$ | 2,070,000$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 1 | 0$ | 0$ |
| 3 | Americans (Buf) | 2000 | 1000 | 200 | 100 | 0 | 0 | 0% | 0% | 39 | 0 - 0% | 0$ | 0$ | 3000 | 100 | 2,255,000$ | 2,255,000$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 1 | 0$ | 0$ |
| 4 |  Barracuda (SJS) | 2000 | 1000 | 101 | 25 | 0 | 0 | 0% | 0% | 39 | 0 - 0% | 0$ | 0$ | 3000 | 100 | 1,955,000$ | 1,955,000$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 1 | 0$ | 0$ |
| 5 |  Bears (Wsh) | 2000 | 1000 | 200 | 100 | 0 | 0 | 0% | 0% | 39 | 0 - 0% | 0$ | 0$ | 3000 | 100 | 1,760,000$ | 1,760,000$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 1 | 0$ | 0$ |
| 6 |  Bruins (Bos) | 2000 | 1000 | 200 | 100 | 6270 | 3344 | 78.38% | 83.60% | 35 | 2404 - 80.12% | 555,940$ | 2,223,760$ | 3000 | 100 | 1,865,000$ | 1,865,000$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 1 | 0$ | 0$ |
| 7 |  Crunch (TBL) | 2000 | 1000 | 200 | 100 | 13661 | 6789 | 85.38% | 84.86% | 31 | 2556 - 85.21% | 593,486$ | 4,747,887$ | 3000 | 100 | 2,080,000$ | 2,080,000$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 1 | 0$ | 0$ |
| 8 |  Devils (NJD) | 2000 | 1000 | 199 | 99 | 0 | 0 | 0% | 0% | 39 | 0 - 0% | 0$ | 0$ | 3000 | 100 | 1,625,000$ | 1,625,000$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 1 | 0$ | 0$ |
| 9 | Falcons (Ari) | 2000 | 1000 | 200 | 100 | 11693 | 5825 | 83.52% | 83.21% | 32 | 2503 - 83.42% | 584,220$ | 4,089,540$ | 3000 | 100 | 2,166,352$ | 2,166,352$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 1 | 0$ | 0$ |
| 10 | Firebirds (Sea) | 2000 | 1000 | 115 | 65 | 12000 | 6000 | 100.00% | 100.00% | 33 | 3000 - 100.00% | 294,000$ | 1,764,000$ | 3000 | 100 | 2,980,000$ | 2,980,000$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 1 | 0$ | 0$ |
| 11 |  Griffins (Det) | 2000 | 1000 | 60 | 30 | 12000 | 6000 | 100.00% | 100.00% | 33 | 3000 - 100.00% | 210,000$ | 1,260,000$ | 3000 | 100 | 1,970,000$ | 1,970,000$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 1 | 0$ | 0$ |
| 12 |  Gulls (Anh) | 2000 | 1000 | 200 | 100 | 6418 | 3104 | 80.23% | 77.60% | 35 | 2381 - 79.35% | 557,900$ | 2,231,600$ | 3000 | 100 | 2,395,000$ | 2,395,000$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 1 | 0$ | 0$ |
| 13 | Heat (Cal) | 2000 | 1000 | 125 | 59 | 6000 | 3000 | 100.00% | 100.00% | 36 | 3000 - 100.00% | 432,600$ | 1,297,800$ | 3000 | 100 | 2,000,500$ | 2,000,500$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 1 | 0$ | 0$ |
| 14 |  Ice Hogs (Chi) | 2000 | 1000 | 200 | 100 | 0 | 0 | 0% | 0% | 39 | 0 - 0% | 0$ | 0$ | 3000 | 100 | 1,995,000$ | 1,995,000$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 1 | 0$ | 0$ |
| 15 |  Marlies (Tor) | 2000 | 1000 | 200 | 100 | 10031 | 4850 | 83.59% | 80.83% | 33 | 2480 - 82.67% | 581,280$ | 3,487,680$ | 3000 | 100 | 2,680,500$ | 2,680,500$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 1 | 0$ | 0$ |
| 16 |  Monsters (Clb) | 2000 | 1000 | 200 | 100 | 0 | 0 | 0% | 0% | 39 | 0 - 0% | 0$ | 0$ | 3000 | 100 | 1,987,500$ | 1,987,500$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 1 | 0$ | 0$ |
| 17 |  Moose (Fla) | 2000 | 1000 | 150 | 75 | 0 | 0 | 0% | 0% | 39 | 0 - 0% | 0$ | 0$ | 3000 | 100 | 1,947,500$ | 1,947,500$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 1 | 0$ | 0$ |
| 18 | Oil Kings (Edm) | 2000 | 1000 | 200 | 100 | 10168 | 5155 | 84.73% | 85.92% | 33 | 2554 - 85.13% | 594,790$ | 3,568,740$ | 3000 | 100 | 2,252,500$ | 2,252,500$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 1 | 0$ | 0$ |
| 19 |  Penguins (Pit) | 2000 | 1000 | 200 | 100 | 4990 | 2165 | 83.17% | 72.17% | 36 | 2385 - 79.50% | 566,767$ | 1,700,300$ | 3000 | 100 | 2,030,000$ | 2,030,000$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 1 | 0$ | 0$ |
| 20 |  Phantoms (Phi) | 2000 | 1000 | 200 | 100 | 0 | 0 | 0% | 0% | 39 | 0 - 0% | 0$ | 0$ | 3000 | 100 | 1,640,000$ | 1,640,000$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 1 | 0$ | 0$ |
| 21 |  Rampage (Col) | 2000 | 1000 | 150 | 60 | 0 | 0 | 0% | 0% | 39 | 0 - 0% | 0$ | 0$ | 3000 | 100 | 1,675,000$ | 1,675,000$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 1 | 0$ | 0$ |
| 22 |  Reign (LA ) | 2000 | 1000 | 200 | 100 | 10182 | 4967 | 84.85% | 82.78% | 33 | 2525 - 84.16% | 591,057$ | 3,546,340$ | 3000 | 100 | 2,250,000$ | 2,250,000$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 1 | 0$ | 0$ |
| 23 |  Rocket (Mon) | 2000 | 1000 | 200 | 100 | 0 | 0 | 0% | 0% | 39 | 0 - 0% | 0$ | 0$ | 3000 | 100 | 2,345,000$ | 2,345,000$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 1 | 0$ | 0$ |
| 24 |  Senators (Ott) | 2000 | 1000 | 200 | 100 | 0 | 0 | 0% | 0% | 39 | 0 - 0% | 0$ | 0$ | 3000 | 100 | 2,235,000$ | 2,235,000$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 1 | 0$ | 0$ |
| 25 |  Sound Tigers (NYI) | 2000 | 1000 | 200 | 100 | 0 | 0 | 0% | 0% | 39 | 0 - 0% | 0$ | 0$ | 3000 | 100 | 1,840,000$ | 1,840,000$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 1 | 0$ | 0$ |
| 26 |  Stars (Dal) | 2000 | 1000 | 200 | 100 | 4681 | 2419 | 78.02% | 80.63% | 36 | 2367 - 78.89% | 549,780$ | 1,649,340$ | 3000 | 100 | 2,210,000$ | 2,210,000$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 1 | 0$ | 0$ |
| 27 | Swamp Rabbits (Car) | 2000 | 1000 | 200 | 100 | 2996 | 1564 | 74.90% | 78.20% | 37 | 2280 - 76.00% | 528,920$ | 1,057,840$ | 3000 | 100 | 1,801,500$ | 1,801,500$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 1 | 0$ | 0$ |
| 28 | Thunderbirds (STL) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0% | 0% | 39 | 0 - 0% | 0$ | 0$ | 3000 | 100 | 2,420,000$ | 2,420,000$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 1 | 0$ | 0$ |
| 29 | Wheat Kings (Jet) | 2000 | 1000 | 175 | 88 | 6000 | 2650 | 100.00% | 88.33% | 36 | 2883 - 96.11% | 598,827$ | 1,796,480$ | 3000 | 100 | 2,210,000$ | 2,210,000$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 1 | 0$ | 0$ |
| 30 |  Wild (Min) | 2000 | 1000 | 200 | 100 | 4782 | 2411 | 79.70% | 80.37% | 36 | 2398 - 79.92% | 558,833$ | 1,676,500$ | 3000 | 100 | 1,660,000$ | 1,660,000$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 1 | 0$ | 0$ |
| 31 | Wolfpack (NYR) | 2000 | 1000 | 200 | 100 | 0 | 0 | 0% | 0% | 39 | 0 - 0% | 0$ | 0$ | 3000 | 100 | 2,215,000$ | 2,215,000$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 1 | 0$ | 0$ |
| 32 |  Wolves (Van) | 2000 | 1000 | 190 | 90 | 12305 | 6286 | 87.89% | 89.80% | 32 | 2656 - 88.53% | 585,892$ | 4,101,244$ | 3000 | 100 | 2,270,000$ | 2,270,000$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 1 | 0$ | 0$ |