| 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 |
| Arena 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 | Arena 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 | 70 | 40 | 0 | 0 | 0% | 0% | 40 | 0 - 0% | 0$ | 0$ | 3000 | 100 | 2,307,500$ | 2,307,500$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 0 | 0$ | 0$ |
| 2 |  Americans (Buf) | 2000 | 1000 | 70 | 40 | 4000 | 1994 | 100.00% | 99.70% | 38 | 2997 - 99.90% | 188,874$ | 377,748$ | 3000 | 100 | 2,090,000$ | 2,090,000$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 0 | 0$ | 0$ |
| 3 |  Barracuda (S.J) | 2000 | 1000 | 70 | 40 | 0 | 0 | 0% | 0% | 40 | 0 - 0% | 0$ | 0$ | 3000 | 100 | 1,860,000$ | 1,860,000$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 0 | 0$ | 0$ |
| 4 |  Bears (Was) | 2000 | 1000 | 70 | 40 | 5960 | 2979 | 99.33% | 99.30% | 37 | 2980 - 99.32% | 187,726$ | 563,178$ | 3000 | 100 | 1,930,000$ | 1,930,000$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 0 | 0$ | 0$ |
| 5 |  Canucks (Van) | 2000 | 1000 | 70 | 40 | 6000 | 2980 | 100.00% | 99.33% | 37 | 2993 - 99.78% | 188,720$ | 566,160$ | 3000 | 100 | 2,035,000$ | 2,035,000$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 0 | 0$ | 0$ |
| 6 |  Checkers (Flo) | 2000 | 1000 | 70 | 40 | 0 | 0 | 0% | 0% | 40 | 0 - 0% | 0$ | 0$ | 3000 | 100 | 1,815,000$ | 1,815,000$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 0 | 0$ | 0$ |
| 7 |  Comets (N.J) | 2000 | 1000 | 70 | 40 | 24000 | 12000 | 100.00% | 100.00% | 28 | 3000 - 100.00% | 189,000$ | 2,268,000$ | 3000 | 100 | 2,040,000$ | 2,040,000$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 0 | 0$ | 0$ |
| 8 |  Condors (Edm) | 2000 | 1000 | 70 | 40 | 13995 | 7000 | 99.96% | 100.00% | 33 | 2999 - 99.98% | 188,947$ | 1,322,632$ | 3000 | 100 | 2,670,000$ | 2,670,000$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 0 | 0$ | 0$ |
| 9 |  Crunch (T.B) | 2000 | 1000 | 70 | 40 | 10000 | 5000 | 100.00% | 100.00% | 35 | 3000 - 100.00% | 189,000$ | 945,000$ | 3000 | 100 | 1,717,500$ | 1,717,500$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 0 | 0$ | 0$ |
| 10 |  Eagles (Col) | 2000 | 1000 | 70 | 40 | 4000 | 2000 | 100.00% | 100.00% | 38 | 3000 - 100.00% | 189,000$ | 378,000$ | 3000 | 100 | 2,222,000$ | 2,222,000$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 0 | 0$ | 0$ |
| 11 |  Firebirds (Sea) | 2000 | 1000 | 70 | 40 | 3931 | 2000 | 98.28% | 100.00% | 38 | 2966 - 98.85% | 186,464$ | 372,928$ | 3000 | 100 | 2,510,000$ | 2,510,000$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 0 | 0$ | 0$ |
| 12 |  Griffins (Det) | 2000 | 1000 | 70 | 40 | 10000 | 4964 | 100.00% | 99.28% | 35 | 2993 - 99.76% | 188,698$ | 943,488$ | 3000 | 100 | 2,280,000$ | 2,280,000$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 0 | 0$ | 0$ |
| 13 |  Gulls (Ana) | 2000 | 1000 | 70 | 40 | 15974 | 7993 | 99.84% | 99.91% | 32 | 2996 - 99.86% | 188,724$ | 1,509,795$ | 3000 | 100 | 1,785,000$ | 1,785,000$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 0 | 0$ | 0$ |
| 14 |  Icehogs (Chi) | 2000 | 1000 | 70 | 40 | 8000 | 4000 | 100.00% | 100.00% | 36 | 3000 - 100.00% | 189,000$ | 756,000$ | 3000 | 100 | 1,737,500$ | 1,737,500$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 0 | 0$ | 0$ |
| 15 |  Islander (NyI) | 2000 | 1000 | 70 | 40 | 0 | 0 | 0% | 0% | 40 | 0 - 0% | 0$ | 0$ | 3000 | 100 | 1,660,000$ | 1,660,000$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 0 | 0$ | 0$ |
| 16 |  Little Stars (Dal) | 2000 | 1000 | 70 | 40 | 0 | 0 | 0% | 0% | 40 | 0 - 0% | 0$ | 0$ | 3000 | 100 | 1,804,500$ | 1,804,500$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 0 | 0$ | 0$ |
| 17 |  Marlies (TOR) | 2000 | 1000 | 70 | 40 | 8000 | 4000 | 100.00% | 100.00% | 36 | 3000 - 100.00% | 189,000$ | 756,000$ | 3000 | 100 | 2,092,500$ | 2,092,500$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 0 | 0$ | 0$ |
| 18 |  Moose (Win) | 2000 | 1000 | 70 | 40 | 0 | 0 | 0% | 0% | 40 | 0 - 0% | 0$ | 0$ | 3000 | 100 | 2,035,000$ | 2,035,000$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 0 | 0$ | 0$ |
| 19 |  Penguins (Pit) | 2000 | 1000 | 70 | 40 | 0 | 0 | 0% | 0% | 40 | 0 - 0% | 0$ | 0$ | 3000 | 100 | 1,652,500$ | 1,652,500$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 0 | 0$ | 0$ |
| 20 |  Punishers (Bos) | 2000 | 1000 | 70 | 40 | 11972 | 5996 | 99.77% | 99.93% | 34 | 2995 - 99.82% | 188,629$ | 1,131,774$ | 3000 | 100 | 2,137,500$ | 2,137,500$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 0 | 0$ | 0$ |
| 21 |  Roadrunners (Uta) | 2000 | 1000 | 70 | 40 | 21965 | 11000 | 99.84% | 100.00% | 29 | 2997 - 99.89% | 188,766$ | 2,076,428$ | 3000 | 100 | 1,855,000$ | 1,855,000$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 0 | 0$ | 0$ |
| 22 |  Rockets (Mtl) | 2000 | 1000 | 70 | 40 | 0 | 0 | 0% | 0% | 40 | 0 - 0% | 0$ | 0$ | 3000 | 100 | 2,095,000$ | 2,095,000$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 0 | 0$ | 0$ |
| 23 |  Senators (Ott) | 2000 | 1000 | 70 | 40 | 24000 | 11986 | 100.00% | 99.88% | 28 | 2999 - 99.96% | 188,951$ | 2,267,412$ | 3000 | 100 | 2,390,000$ | 2,390,000$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 0 | 0$ | 0$ |
| 24 |  Thunderbirds (Stl) | 2000 | 1000 | 70 | 40 | 0 | 0 | 0% | 0% | 40 | 0 - 0% | 0$ | 0$ | 3000 | 100 | 1,750,000$ | 1,750,000$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 0 | 0$ | 0$ |
| 25 |  Wolfpack (NyR) | 2000 | 1000 | 70 | 40 | 4000 | 1983 | 100.00% | 99.15% | 38 | 2992 - 99.72% | 188,643$ | 377,286$ | 3000 | 100 | 2,110,000$ | 2,110,000$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 0 | 0$ | 0$ |
| 26 |  Wranglers (Cal) | 2000 | 1000 | 70 | 40 | 0 | 0 | 0% | 0% | 40 | 0 - 0% | 0$ | 0$ | 3000 | 100 | 2,185,000$ | 2,185,000$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 0 | 0$ | 0$ |