| 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 | 74980 | 37043 | 93.73% | 92.61% | 0 | 2801 - 93.35% | 83,473$ | 3,338,938$ | 3000 | 100 | 2,283,500$ | 2,098,500$ | 3,094,047$ | 11,085$ | 2,232,296$ | 0 | 0 | 0$ | 0 | 15,211$ | 0$ |
| 2 |  Barracuda (S.J) | 2000 | 1000 | 35 | 15 | 72081 | 36810 | 90.10% | 92.03% | 0 | 2722 - 90.74% | 80,718$ | 3,228,729$ | 3000 | 100 | 2,019,500$ | 2,019,500$ | 2,661,966$ | 9,803$ | 1,992,123$ | 0 | 0 | 0$ | 0 | 12,959$ | 0$ |
| 3 |  Bears (Was) | 2000 | 1000 | 35 | 15 | 74396 | 37533 | 93.00% | 93.83% | 0 | 2798 - 93.27% | 83,130$ | 3,325,198$ | 3000 | 100 | 2,379,500$ | 1,887,500$ | 2,903,156$ | 11,551$ | 2,345,893$ | 0 | 0 | 0$ | 0 | 14,221$ | 0$ |
| 4 |  Comets (Van) | 2000 | 1000 | 35 | 15 | 74825 | 37871 | 93.53% | 94.68% | 0 | 2817 - 93.91% | 83,657$ | 3,346,287$ | 3000 | 100 | 2,155,000$ | 2,065,000$ | 2,696,401$ | 10,461$ | 2,357,612$ | 0 | 0 | 0$ | 0 | 12,039$ | 0$ |
| 5 |  Condors (Edm) | 2000 | 1000 | 35 | 15 | 75075 | 37592 | 93.84% | 93.98% | 0 | 2817 - 93.89% | 83,777$ | 3,351,080$ | 3000 | 100 | 2,957,500$ | 2,615,000$ | 3,058,814$ | 14,357$ | 2,531,892$ | 0 | 0 | 0$ | 0 | 16,784$ | 0$ |
| 6 |  Crunch (T.B) | 2000 | 1000 | 35 | 15 | 75660 | 36832 | 94.58% | 92.08% | 0 | 2812 - 93.74% | 84,015$ | 3,360,613$ | 3000 | 100 | 2,527,500$ | 1,730,000$ | 2,774,271$ | 12,269$ | 2,263,498$ | 0 | 0 | 0$ | 0 | 14,697$ | 0$ |
| 7 |  Devils (N.J) | 2000 | 1000 | 35 | 15 | 75552 | 37982 | 94.44% | 94.96% | 0 | 2838 - 94.61% | 84,369$ | 3,374,756$ | 3000 | 100 | 1,834,000$ | 1,574,500$ | 2,591,423$ | 8,903$ | 1,813,373$ | 0 | 0 | 0$ | 0 | 12,544$ | 0$ |
| 8 |  Eagles (Col) | 2000 | 1000 | 35 | 15 | 73746 | 37210 | 92.18% | 93.03% | 0 | 2774 - 92.46% | 82,406$ | 3,296,225$ | 3000 | 100 | 1,796,000$ | 1,539,000$ | 2,402,867$ | 8,718$ | 1,777,764$ | 0 | 0 | 0$ | 0 | 11,631$ | 0$ |
| 9 |  Griffins (Det) | 2000 | 1000 | 35 | 15 | 73964 | 37250 | 92.46% | 93.13% | 0 | 2780 - 92.68% | 82,622$ | 3,304,866$ | 3000 | 100 | 2,432,500$ | 2,200,000$ | 3,465,960$ | 11,808$ | 2,606,096$ | 0 | 0 | 0$ | 0 | 15,934$ | 0$ |
| 10 |  Heat (Cal) | 2000 | 1000 | 35 | 15 | 75246 | 37504 | 94.06% | 93.76% | 0 | 2819 - 93.96% | 83,900$ | 3,355,981$ | 3000 | 100 | 2,167,500$ | 1,875,000$ | 2,941,967$ | 10,522$ | 2,112,184$ | 0 | 0 | 0$ | 0 | 14,405$ | 0$ |
| 11 |  Icehogs (Chi) | 2000 | 1000 | 35 | 15 | 74878 | 37440 | 93.60% | 93.60% | 0 | 2808 - 93.60% | 83,536$ | 3,341,447$ | 3000 | 100 | 2,989,000$ | 2,420,000$ | 3,254,542$ | 14,170$ | 2,536,754$ | 0 | 0 | 0$ | 0 | 17,908$ | 0$ |
| 12 |  Little Stars (Dal) | 2000 | 1000 | 35 | 15 | 74809 | 36512 | 93.51% | 91.28% | 0 | 2783 - 92.77% | 83,107$ | 3,324,294$ | 3000 | 100 | 2,744,500$ | 2,604,500$ | 2,951,942$ | 12,862$ | 2,185,335$ | 0 | 0 | 0$ | 0 | 16,964$ | 0$ |
| 13 |  Marlies (TOR) | 2000 | 1000 | 35 | 15 | 74528 | 37861 | 93.16% | 94.65% | 0 | 2810 - 93.66% | 83,380$ | 3,335,216$ | 3000 | 100 | 2,125,000$ | 2,120,000$ | 2,314,558$ | 10,316$ | 1,609,092$ | 0 | 0 | 0$ | 0 | 13,549$ | 0$ |
| 14 |  Monsters (Clb) | 2000 | 1000 | 35 | 15 | 74969 | 36405 | 93.71% | 91.01% | 0 | 2784 - 92.81% | 83,212$ | 3,328,491$ | 3000 | 100 | 2,016,500$ | 1,926,500$ | 2,798,129$ | 9,789$ | 2,036,911$ | 0 | 0 | 0$ | 0 | 13,430$ | 0$ |
| 15 |  Moose (Win) | 2000 | 1000 | 35 | 15 | 73601 | 37754 | 92.00% | 94.39% | 0 | 2784 - 92.80% | 82,487$ | 3,299,461$ | 3000 | 100 | 2,326,500$ | 1,976,500$ | 3,208,984$ | 11,294$ | 2,233,988$ | 0 | 0 | 0$ | 0 | 15,905$ | 0$ |
| 16 |  Penguins (Pit) | 2000 | 1000 | 35 | 15 | 73909 | 36878 | 92.39% | 92.20% | 0 | 2770 - 92.32% | 82,425$ | 3,296,986$ | 3000 | 100 | 1,832,500$ | 1,365,000$ | 2,375,428$ | 8,896$ | 1,861,596$ | 0 | 0 | 0$ | 0 | 11,323$ | 0$ |
| 17 |  Phantoms (Phi) | 2000 | 1000 | 35 | 20 | 74311 | 23762 | 92.89% | 59.41% | 0 | 2452 - 81.73% | 80,748$ | 3,229,933$ | 3000 | 100 | 1,987,000$ | 1,769,500$ | 2,650,138$ | 9,646$ | 2,141,725$ | 0 | 0 | 0$ | 0 | 12,073$ | 0$ |
| 18 |  Punishers (Bos) | 2000 | 1000 | 40 | 20 | 53883 | 23787 | 67.35% | 59.47% | 0 | 1942 - 64.73% | 69,065$ | 2,762,613$ | 3000 | 100 | 1,619,000$ | 1,449,000$ | 1,928,363$ | 7,859$ | 1,604,467$ | 0 | 0 | 0$ | 0 | 9,316$ | 0$ |
| 19 |  Rampage (Stl) | 2000 | 1000 | 35 | 15 | 74864 | 37312 | 93.58% | 93.28% | 0 | 2804 - 93.48% | 83,473$ | 3,338,918$ | 3000 | 100 | 1,644,500$ | 1,474,500$ | 2,515,761$ | 7,498$ | 1,843,743$ | 0 | 0 | 0$ | 0 | 11,138$ | 0$ |
| 20 |  Reign (L.A) | 2000 | 1000 | 35 | 15 | 73328 | 36884 | 91.66% | 92.21% | 0 | 2755 - 91.84% | 81,893$ | 3,275,726$ | 3000 | 100 | 2,815,000$ | 1,915,000$ | 3,394,693$ | 13,665$ | 2,625,739$ | 0 | 0 | 0$ | 0 | 17,306$ | 0$ |
| 21 |  Rocket (Mon) | 2000 | 1000 | 35 | 15 | 75324 | 36695 | 94.16% | 91.74% | 0 | 2800 - 93.35% | 83,653$ | 3,346,106$ | 3000 | 100 | 2,900,000$ | 2,800,000$ | 3,198,101$ | 14,078$ | 2,683,910$ | 0 | 0 | 0$ | 0 | 16,505$ | 0$ |
| 22 |  Senators (Ott) | 2000 | 1000 | 35 | 15 | 72990 | 37671 | 91.24% | 94.18% | 0 | 2767 - 92.22% | 81,893$ | 3,275,701$ | 3000 | 100 | 2,947,500$ | 2,655,000$ | 3,077,873$ | 14,308$ | 2,067,531$ | 0 | 0 | 0$ | 0 | 19,163$ | 0$ |
| 23 |  Sound Tigers (NyI) | 2000 | 1000 | 35 | 15 | 74598 | 37773 | 93.25% | 94.43% | 0 | 2809 - 93.64% | 83,410$ | 3,336,402$ | 3000 | 100 | 1,935,000$ | 1,645,000$ | 2,624,076$ | 9,393$ | 1,855,112$ | 0 | 0 | 0$ | 0 | 13,034$ | 0$ |
| 24 |  Thunderbirds (Flo) | 2000 | 1000 | 35 | 15 | 76182 | 38060 | 95.23% | 95.15% | 0 | 2856 - 95.20% | 84,978$ | 3,399,132$ | 3000 | 100 | 3,675,000$ | 3,485,000$ | 3,608,555$ | 17,840$ | 2,805,388$ | 0 | 0 | 0$ | 0 | 21,723$ | 0$ |
| 25 |  Wolfpack (NyR) | 2000 | 1000 | 35 | 15 | 74727 | 37758 | 93.41% | 94.40% | 0 | 2812 - 93.74% | 83,523$ | 3,340,905$ | 3000 | 100 | 3,210,000$ | 2,850,000$ | 2,952,206$ | 15,291$ | 2,573,680$ | 0 | 0 | 0$ | 0 | 17,282$ | 0$ |
| 26 |  Wolves (Veg) | 2000 | 1000 | 35 | 15 | 72674 | 36955 | 90.84% | 92.39% | 0 | 2741 - 91.36% | 81,320$ | 3,252,813$ | 3000 | 100 | 1,510,000$ | 1,435,000$ | 2,444,028$ | 7,330$ | 1,933,122$ | 0 | 0 | 0$ | 0 | 9,757$ | 0$ |