| 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 | 35 | 15 | 76020 | 37246 | 95.03% | 93.12% | 0 | 2832 - 94.39% | 84,509$ | 3,380,362$ | 3000 | 100 | 2,385,000$ | 2,050,500$ | 3,511,498$ | 11,925$ | 2,472,361$ | 0 | 0 | 0$ | 0 | 16,925$ | 0$ |
| 2 |  Barracuda (S.J) | 2000 | 1000 | 35 | 15 | 74981 | 37303 | 93.73% | 93.26% | 0 | 2807 - 93.57% | 83,577$ | 3,343,074$ | 3000 | 100 | 1,682,500$ | 1,085,000$ | 2,273,026$ | 8,412$ | 1,609,451$ | 0 | 0 | 0$ | 0 | 11,662$ | 0$ |
| 3 |  Bears (Was) | 2000 | 1000 | 35 | 15 | 75409 | 37315 | 94.26% | 93.29% | 0 | 2818 - 93.94% | 83,975$ | 3,358,989$ | 3000 | 100 | 1,829,500$ | 1,189,500$ | 2,375,013$ | 9,148$ | 1,802,928$ | 0 | 0 | 0$ | 0 | 11,898$ | 0$ |
| 4 |  Comets (Van) | 2000 | 1000 | 35 | 15 | 74730 | 36749 | 93.41% | 91.87% | 0 | 2787 - 92.90% | 83,128$ | 3,325,125$ | 3000 | 100 | 2,732,300$ | 2,065,000$ | 2,771,007$ | 13,662$ | 2,440,704$ | 0 | 0 | 0$ | 0 | 15,286$ | 0$ |
| 5 |  Condors (Edm) | 2000 | 1000 | 35 | 15 | 73275 | 37031 | 91.59% | 92.58% | 0 | 2758 - 91.92% | 81,902$ | 3,276,092$ | 3000 | 100 | 2,191,900$ | 1,682,400$ | 2,701,265$ | 10,610$ | 2,181,065$ | 0 | 0 | 0$ | 0 | 13,460$ | 0$ |
| 6 |  Crunch (T.B) | 2000 | 1000 | 35 | 15 | 74179 | 37368 | 92.72% | 93.42% | 0 | 2789 - 92.96% | 82,866$ | 3,314,621$ | 3000 | 100 | 1,497,500$ | 1,217,500$ | 1,897,624$ | 7,162$ | 1,363,266$ | 0 | 0 | 0$ | 0 | 9,988$ | 0$ |
| 7 |  Devils (N.J) | 2000 | 1000 | 35 | 15 | 73027 | 36832 | 91.28% | 92.08% | 0 | 2746 - 91.55% | 81,596$ | 3,263,848$ | 3000 | 100 | 1,615,000$ | 1,230,000$ | 2,351,375$ | 8,075$ | 1,578,875$ | 0 | 0 | 0$ | 0 | 11,825$ | 0$ |
| 8 |  Eagles (Col) | 2000 | 1000 | 35 | 15 | 75025 | 36952 | 93.78% | 92.38% | 0 | 2799 - 93.31% | 83,479$ | 3,339,168$ | 3000 | 100 | 1,740,000$ | 1,330,500$ | 2,428,045$ | 8,700$ | 1,798,810$ | 0 | 0 | 0$ | 0 | 11,700$ | 0$ |
| 9 |  Griffins (Det) | 2000 | 1000 | 35 | 15 | 74450 | 37693 | 93.06% | 94.23% | 0 | 2804 - 93.45% | 83,243$ | 3,329,703$ | 3000 | 100 | 2,137,000$ | 1,547,500$ | 2,973,574$ | 10,185$ | 2,098,019$ | 0 | 0 | 0$ | 0 | 14,935$ | 0$ |
| 10 |  Heat (Cal) | 2000 | 1000 | 35 | 15 | 74181 | 37312 | 92.73% | 93.28% | 0 | 2787 - 92.91% | 82,845$ | 3,313,812$ | 3000 | 100 | 2,092,500$ | 1,515,000$ | 2,926,368$ | 10,188$ | 2,107,700$ | 0 | 0 | 0$ | 0 | 14,462$ | 0$ |
| 11 |  Icehogs (Chi) | 2000 | 1000 | 35 | 15 | 75021 | 37075 | 93.78% | 92.69% | 0 | 2802 - 93.41% | 83,524$ | 3,340,953$ | 3000 | 100 | 2,305,000$ | 1,790,000$ | 3,020,297$ | 11,525$ | 2,297,687$ | 0 | 0 | 0$ | 0 | 15,025$ | 0$ |
| 12 |  Little Stars (Dal) | 2000 | 1000 | 35 | 15 | 74773 | 37174 | 93.47% | 92.94% | 0 | 2799 - 93.29% | 83,335$ | 3,333,399$ | 3000 | 100 | 2,775,000$ | 2,357,500$ | 3,026,478$ | 13,875$ | 2,017,728$ | 0 | 0 | 0$ | 0 | 18,875$ | 0$ |
| 13 |  Marlies (TOR) | 2000 | 1000 | 35 | 15 | 75121 | 36796 | 93.90% | 91.99% | 0 | 2798 - 93.26% | 83,506$ | 3,340,233$ | 3000 | 100 | 1,729,500$ | 1,480,000$ | 2,446,438$ | 8,648$ | 1,755,358$ | 0 | 0 | 0$ | 0 | 11,978$ | 0$ |
| 14 |  Monsters (Clb) | 2000 | 1000 | 35 | 15 | 75383 | 37189 | 94.23% | 92.97% | 0 | 2814 - 93.81% | 83,901$ | 3,356,052$ | 3000 | 100 | 1,607,000$ | 1,125,000$ | 2,095,985$ | 8,035$ | 1,535,735$ | 0 | 0 | 0$ | 0 | 10,785$ | 0$ |
| 15 |  Moose (Win) | 2000 | 1000 | 35 | 15 | 74552 | 37077 | 93.19% | 92.69% | 0 | 2791 - 93.02% | 83,094$ | 3,323,752$ | 3000 | 100 | 1,969,000$ | 1,540,000$ | 2,902,679$ | 9,845$ | 1,931,429$ | 0 | 0 | 0$ | 0 | 14,595$ | 0$ |
| 16 |  Penguins (Pit) | 2000 | 1000 | 35 | 15 | 75407 | 37347 | 94.26% | 93.37% | 0 | 2819 - 93.96% | 83,986$ | 3,359,426$ | 3000 | 100 | 1,722,000$ | 1,100,000$ | 2,332,676$ | 8,610$ | 1,830,176$ | 0 | 0 | 0$ | 0 | 11,110$ | 0$ |
| 17 |  Phantoms (Phi) | 2000 | 1000 | 35 | 20 | 74963 | 25114 | 93.70% | 62.79% | 0 | 2502 - 83.40% | 81,700$ | 3,267,991$ | 3000 | 100 | 1,827,000$ | 1,490,000$ | 2,366,485$ | 9,135$ | 1,850,860$ | 0 | 0 | 0$ | 0 | 11,635$ | 0$ |
| 18 |  Punishers (Bos) | 2000 | 1000 | 40 | 20 | 58529 | 26348 | 73.16% | 65.87% | 0 | 2122 - 70.73% | 72,031$ | 2,881,253$ | 3000 | 100 | 2,139,500$ | 1,720,000$ | 2,097,943$ | 10,200$ | 1,771,965$ | 0 | 0 | 0$ | 0 | 12,198$ | 0$ |
| 19 |  Rampage (Stl) | 2000 | 1000 | 35 | 15 | 75999 | 37340 | 95.00% | 93.35% | 0 | 2833 - 94.45% | 84,527$ | 3,381,068$ | 3000 | 100 | 1,515,000$ | 1,167,500$ | 2,233,123$ | 7,575$ | 1,558,123$ | 0 | 0 | 0$ | 0 | 10,825$ | 0$ |
| 20 |  Reign (L.A) | 2000 | 1000 | 35 | 15 | 73027 | 37162 | 91.28% | 92.91% | 0 | 2755 - 91.82% | 81,726$ | 3,269,042$ | 3000 | 100 | 2,022,000$ | 1,545,000$ | 2,827,461$ | 10,110$ | 2,061,711$ | 0 | 0 | 0$ | 0 | 13,860$ | 0$ |
| 21 |  Rocket (Mon) | 2000 | 1000 | 35 | 15 | 75057 | 37587 | 93.82% | 93.97% | 0 | 2816 - 93.87% | 83,759$ | 3,350,340$ | 3000 | 100 | 2,622,500$ | 1,620,000$ | 2,852,015$ | 13,112$ | 2,344,655$ | 0 | 0 | 0$ | 0 | 15,612$ | 0$ |
| 22 |  Senators (Ott) | 2000 | 1000 | 35 | 15 | 74547 | 37081 | 93.18% | 92.70% | 0 | 2791 - 93.02% | 83,091$ | 3,323,627$ | 3000 | 100 | 2,825,000$ | 2,380,000$ | 3,468,995$ | 13,875$ | 2,456,745$ | 0 | 0 | 0$ | 0 | 19,125$ | 0$ |
| 23 |  Sound Tigers (NyI) | 2000 | 1000 | 35 | 15 | 73894 | 37297 | 92.37% | 93.24% | 0 | 2780 - 92.66% | 82,576$ | 3,303,030$ | 3000 | 100 | 1,762,500$ | 1,385,000$ | 1,982,998$ | 8,812$ | 1,731,748$ | 0 | 0 | 0$ | 0 | 10,062$ | 0$ |
| 24 |  Thunderbirds (Flo) | 2000 | 1000 | 35 | 15 | 74007 | 37569 | 92.51% | 93.92% | 0 | 2789 - 92.98% | 82,787$ | 3,311,468$ | 3000 | 100 | 1,885,000$ | 1,655,000$ | 2,704,025$ | 9,425$ | 1,883,150$ | 0 | 0 | 0$ | 0 | 13,425$ | 0$ |
| 25 |  Wolfpack (NyR) | 2000 | 1000 | 35 | 15 | 74210 | 37448 | 92.76% | 93.62% | 0 | 2791 - 93.05% | 82,926$ | 3,317,027$ | 3000 | 100 | 2,105,000$ | 1,620,000$ | 2,460,925$ | 10,525$ | 2,098,675$ | 0 | 0 | 0$ | 0 | 12,275$ | 0$ |
| 26 |  Wolves (Veg) | 2000 | 1000 | 35 | 15 | 74978 | 37347 | 93.72% | 93.37% | 0 | 2808 - 93.60% | 83,591$ | 3,343,658$ | 3000 | 100 | 1,689,500$ | 1,529,500$ | 2,158,622$ | 8,448$ | 1,646,860$ | 0 | 0 | 0$ | 0 | 10,948$ | 0$ |
