| 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 |  Bakersfield Condors (EDM) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 19 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 2,255,600$ | 2,155,600$ | 1,392,027$ | 0$ | 1,137,309$ | 0 | 0 | 0$ | 54 | 25,996$ | 1,351,792$ |
| 2 |  Belleville Senators (OTT) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 19 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 4,052,420$ | 3,848,900$ | 2,320,132$ | 0$ | 2,065,415$ | 0 | 0 | 0$ | 54 | 42,947$ | 2,233,244$ |
| 3 |  Binghamton Devils (NJD) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 19 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 2,227,500$ | 2,227,500$ | 1,416,509$ | 0$ | 1,161,791$ | 0 | 0 | 0$ | 54 | 25,731$ | 1,338,012$ |
| 4 |  Bridgeport Sound Tigers (NYI) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 19 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 2,101,400$ | 2,101,400$ | 1,207,383$ | 0$ | 952,674$ | 0 | 0 | 0$ | 54 | 24,542$ | 1,276,184$ |
| 5 |  Charlotte Checkers (FLA) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 19 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 3,039,500$ | 3,039,500$ | 1,778,104$ | 0$ | 1,523,386$ | 0 | 0 | 0$ | 54 | 33,392$ | 1,736,384$ |
| 6 |  Chicago Wolves (CAR) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 19 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 4,352,000$ | 4,132,000$ | 2,467,027$ | 0$ | 2,212,309$ | 0 | 0 | 0$ | 54 | 45,774$ | 2,380,248$ |
| 7 |  Cleveland Monsters (CBJ) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 19 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 3,968,300$ | 3,843,300$ | 2,490,070$ | 0$ | 2,235,352$ | 0 | 0 | 0$ | 54 | 42,154$ | 2,192,008$ |
| 8 |  Colorado Eagles (COL) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 19 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 2,384,860$ | 2,169,900$ | 1,536,413$ | 0$ | 1,281,695$ | 0 | 0 | 0$ | 54 | 27,216$ | 1,415,232$ |
| 9 |  Grand Rapids Griffins (DET) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 19 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 3,474,000$ | 3,107,500$ | 1,965,886$ | 0$ | 1,711,168$ | 0 | 0 | 0$ | 54 | 37,491$ | 1,949,532$ |
| 10 |  Hartford Wolf Pack (NYR) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 18 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 4,069,100$ | 4,069,100$ | 2,320,569$ | 0$ | 2,065,851$ | 0 | 0 | 0$ | 54 | 43,105$ | 2,241,460$ |
| 11 |  Hershey Bears (WSH) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 18 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 4,102,200$ | 3,798,600$ | 2,317,481$ | 0$ | 2,062,766$ | 0 | 0 | 0$ | 54 | 43,417$ | 2,257,684$ |
| 12 |  Iowa Wild (MIN) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 19 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 1,406,000$ | 1,406,000$ | 987,395$ | 0$ | 732,677$ | 0 | 0 | 0$ | 54 | 17,981$ | 935,012$ |
| 13 |  Laval Rocket (MTL) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 19 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 3,523,100$ | 3,123,100$ | 2,044,880$ | 0$ | 1,790,162$ | 0 | 0 | 0$ | 54 | 37,954$ | 1,973,608$ |
| 14 |  Lehigh Valley Phantoms (PHI) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 19 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 3,239,300$ | 3,239,300$ | 1,922,981$ | 0$ | 1,668,263$ | 0 | 0 | 0$ | 54 | 35,276$ | 1,834,352$ |
| 15 |  Manitoba Moose (WPG) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 19 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 3,119,860$ | 2,987,500$ | 1,940,353$ | 0$ | 1,685,635$ | 0 | 0 | 0$ | 54 | 34,150$ | 1,775,800$ |
| 16 |  Milwaukee Admirals (NSH) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 19 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 1,751,800$ | 1,701,800$ | 1,149,175$ | 0$ | 894,457$ | 0 | 0 | 0$ | 54 | 21,243$ | 1,104,636$ |
| 17 |  Ontario Reign (LAK) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 18 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 2,646,100$ | 2,646,100$ | 1,577,308$ | 0$ | 1,322,590$ | 0 | 0 | 0$ | 54 | 29,680$ | 1,543,360$ |
| 18 |  Providence Bruins (BOS) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 19 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 3,154,500$ | 3,154,500$ | 1,925,456$ | 0$ | 1,670,738$ | 0 | 0 | 0$ | 54 | 34,476$ | 1,792,752$ |
| 19 |  Rochester Americans (BUF) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 19 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 3,533,400$ | 3,533,400$ | 2,095,482$ | 0$ | 1,840,764$ | 0 | 0 | 0$ | 54 | 38,051$ | 1,978,652$ |
| 20 |  Rockford IceHogs (CHI) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 19 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 2,853,740$ | 2,801,000$ | 1,697,455$ | 0$ | 1,442,737$ | 0 | 0 | 0$ | 54 | 31,639$ | 1,645,228$ |
| 21 |  San Diego Gulls (ANA) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 19 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 3,007,900$ | 2,873,800$ | 1,787,022$ | 0$ | 1,532,304$ | 0 | 0 | 0$ | 54 | 33,093$ | 1,720,836$ |
| 22 |  San Jose Barracuda (SJS) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 19 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 4,210,360$ | 4,147,900$ | 2,366,006$ | 0$ | 2,111,288$ | 0 | 0 | 0$ | 54 | 44,437$ | 2,310,724$ |
| 23 |  Springfield Thunderbirds (STL) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 19 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 2,663,500$ | 2,663,500$ | 1,624,918$ | 0$ | 1,370,200$ | 0 | 0 | 0$ | 54 | 29,844$ | 1,551,888$ |
| 24 |  Stockton Heat (CGY) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 19 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 3,833,700$ | 3,833,700$ | 2,195,622$ | 0$ | 1,940,904$ | 0 | 0 | 0$ | 54 | 40,884$ | 2,125,968$ |
| 25 |  Syracuse Crunch (TBL) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 19 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 3,815,300$ | 3,439,700$ | 2,157,107$ | 0$ | 1,902,396$ | 0 | 0 | 0$ | 54 | 40,710$ | 2,116,920$ |
| 26 |  Texas Stars (DAL) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 19 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 4,229,900$ | 4,229,900$ | 2,380,387$ | 0$ | 2,125,669$ | 0 | 0 | 0$ | 54 | 44,622$ | 2,320,344$ |
| 27 |  Toronto Marlies (TOR) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 19 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 1,885,800$ | 1,869,500$ | 1,218,800$ | 0$ | 964,086$ | 0 | 0 | 0$ | 54 | 22,508$ | 1,170,416$ |
| 28 |  Tucson Roadrunners (PHX) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 18 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 2,661,500$ | 2,661,500$ | 1,596,607$ | 0$ | 1,341,889$ | 0 | 0 | 0$ | 54 | 29,825$ | 1,550,900$ |
| 29 |  Utica Comets (VAN) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 19 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 2,197,400$ | 2,197,400$ | 1,386,557$ | 0$ | 1,131,839$ | 0 | 0 | 0$ | 54 | 25,447$ | 1,323,244$ |
| 30 |  Wilkes-Barre/Scranton Penguins (PIT) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 19 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 4,099,500$ | 3,859,500$ | 2,338,936$ | 0$ | 2,084,219$ | 0 | 0 | 0$ | 54 | 43,392$ | 2,256,384$ |