| 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 |  Abbotsford Heat (CGY) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 37 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 6,428,998$ | 6,428,998$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 226 | 25,512$ | 5,791,224$ |
| 2 |  Adirondack Phantoms (PHI) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 37 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 7,522,471$ | 7,522,471$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 226 | 29,851$ | 6,776,177$ |
| 3 |  Albany Devils (NJD) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 37 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 8,068,700$ | 8,068,700$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 226 | 32,019$ | 7,268,313$ |
| 4 |  Binghamton Senators (OTT) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 37 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 5,590,182$ | 5,590,182$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 226 | 22,183$ | 5,035,541$ |
| 5 |  Bridgeport Sound Tigers (NYI) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 37 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 8,448,272$ | 8,448,272$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 226 | 33,525$ | 7,610,175$ |
| 6 |  Charlotte Checkers (CAR) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 37 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 7,642,226$ | 7,642,226$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 226 | 30,326$ | 6,884,002$ |
| 7 |  Chicago Wolves (VAN) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 36 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 7,281,720$ | 7,281,720$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 226 | 28,896$ | 6,559,392$ |
| 8 |  Chicago Wolves (VGK) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 37 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 6,109,624$ | 6,109,624$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 226 | 24,245$ | 5,503,615$ |
| 9 |  Connecticut Whale (NYR) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 37 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 5,859,160$ | 5,859,160$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 226 | 23,251$ | 5,277,977$ |
| 10 |  Grand Rapids Griffins (DET) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 37 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 7,100,352$ | 7,100,352$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 226 | 28,176$ | 6,395,952$ |
| 11 |  Hamilton Bulldogs (MTL) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 37 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 6,439,082$ | 6,439,082$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 226 | 25,552$ | 5,800,304$ |
| 12 |  Hershey Bears (WSH) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 37 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 8,210,800$ | 8,210,800$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 226 | 32,583$ | 7,396,341$ |
| 13 |  Houston Aeros (MIN) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 36 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 5,685,504$ | 5,685,504$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 226 | 22,562$ | 5,121,574$ |
| 14 |  Lake Erie Monsters (COL) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 37 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 6,891,900$ | 6,891,900$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 226 | 27,349$ | 6,208,223$ |
| 15 |  Manchester Monarchs (LAK) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 37 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 7,399,200$ | 7,399,200$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 226 | 29,362$ | 6,665,174$ |
| 16 |  Milwaukee Admirals (NSH) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 36 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 7,342,386$ | 7,342,386$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 226 | 29,136$ | 6,613,872$ |
| 17 |  Norfolk Admirals (TBL) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 37 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 6,547,164$ | 6,547,164$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 226 | 25,981$ | 5,897,687$ |
| 18 |  Oklahoma City Barons (EDM) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 37 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 7,724,976$ | 7,724,976$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 226 | 30,655$ | 6,958,685$ |
| 19 |  Palm Springs (SEA) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 36 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 4,709,903$ | 4,709,903$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 226 | 18,690$ | 4,242,630$ |
| 20 |  Peoria Rivermen (STL) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 37 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 7,552,326$ | 7,552,326$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 226 | 29,970$ | 6,803,190$ |
| 21 |  Portland Pirates (ARI) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 37 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 6,724,408$ | 6,724,408$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 226 | 26,684$ | 6,057,268$ |
| 22 |  Providence Bruins (BOS) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 37 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 7,296,986$ | 7,296,986$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 226 | 28,956$ | 6,573,012$ |
| 23 |  Rochester Americans (BUF) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 37 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 6,630,812$ | 6,630,812$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 226 | 26,313$ | 5,973,051$ |
| 24 |  Rockford IceHogs (CHI) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 37 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 7,196,922$ | 7,196,922$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 226 | 28,559$ | 6,482,893$ |
| 25 |  San Antonio Rampage (FLA) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 36 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 8,049,358$ | 8,049,358$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 226 | 31,942$ | 7,250,834$ |
| 26 |  Springfield Falcons (CBJ) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 37 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 6,225,162$ | 6,225,162$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 226 | 24,703$ | 5,607,581$ |
| 27 |  St. John's (WPG) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 37 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 6,581,058$ | 6,581,058$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 226 | 26,115$ | 5,928,105$ |
| 28 |  Syracuse Crunch (ANA) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 36 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 7,112,390$ | 7,112,390$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 226 | 28,224$ | 6,406,848$ |
| 29 |  Texas Stars (DAL) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 37 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 7,940,076$ | 7,940,076$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 226 | 31,508$ | 7,152,316$ |
| 30 |  Toronto Marlies (TOR) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 36 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 5,543,302$ | 5,543,302$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 226 | 21,997$ | 4,993,319$ |
| 31 |  Wilkes-Barre/Scranton Penguins (PIT) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 36 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 6,899,210$ | 6,899,210$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 226 | 27,378$ | 6,214,806$ |
| 32 |  Worcester Sharks (SJS) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 37 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 6,517,967$ | 6,517,967$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 226 | 25,865$ | 5,871,355$ |