Belleville Senators
Charlotte Checkers
Cleveland Monsters
Grand Rapids Griffins
Hamilton Hammers
Hartford Wolf Pack
Hershey Bears
Laval Rocket
Lehigh Valley Phantoms
Providence Bruins
Rochester Americans
Springfield Thunderbirds
Syracuse Crunch
Toronto Marlies
Utica Comets
Wilkes-Barre Scranton Penguins
| 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 |  Abbotsford Canucks (VAN) | 2000 | 1000 | 45 | 20 | 0 | 0 | 0% | 0% | 36 | 0 - 0% | 0$ | 0$ | 3000 | 100 | 2,113,396$ | 2,113,396$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 185 | 15,283$ | 2,613,393$ |
| 2 |  Bakersfield Condors (EDM) | 2000 | 1000 | 40 | 20 | 0 | 0 | 0% | 0% | 36 | 0 - 0% | 0$ | 0$ | 3000 | 100 | 1,954,720$ | 1,954,720$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 185 | 14,355$ | 2,454,705$ |
| 3 | Belleville Senators (OTT) | 2000 | 1000 | 49 | 20 | 0 | 0 | 0% | 0% | 36 | 0 - 0% | 0$ | 0$ | 3000 | 100 | 3,045,032$ | 3,045,032$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 185 | 20,731$ | 3,545,001$ |
| 4 |  Calgary Wranglers (CGY) | 2000 | 1000 | 45 | 18 | 0 | 0 | 0% | 0% | 36 | 0 - 0% | 0$ | 0$ | 3000 | 100 | 2,788,432$ | 2,788,432$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 185 | 19,231$ | 3,288,501$ |
| 5 | Charlotte Checkers (FLA) | 2000 | 1000 | 50 | 20 | 0 | 0 | 0% | 0% | 36 | 0 - 0% | 0$ | 0$ | 3000 | 100 | 1,877,750$ | 1,877,750$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 185 | 13,905$ | 2,377,755$ |
| 6 |  Chicago Wolves (CAR) | 2000 | 1000 | 50 | 20 | 0 | 0 | 0% | 0% | 36 | 0 - 0% | 0$ | 0$ | 3000 | 100 | 1,705,249$ | 1,705,249$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 185 | 12,896$ | 2,205,216$ |
| 7 | Cleveland Monsters (CBJ) | 2000 | 1000 | 50 | 20 | 0 | 0 | 0% | 0% | 36 | 0 - 0% | 0$ | 0$ | 3000 | 100 | 1,788,867$ | 1,788,867$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 185 | 13,385$ | 2,288,835$ |
| 8 |  Coachella Valley Firebirds (SEA) | 2000 | 1000 | 50 | 20 | 0 | 0 | 0% | 0% | 36 | 0 - 0% | 0$ | 0$ | 3000 | 100 | 1,969,360$ | 1,969,360$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 185 | 14,441$ | 2,469,411$ |
| 9 |  Colorado Eagles (COL) | 2000 | 1000 | 55 | 25 | 0 | 0 | 0% | 0% | 36 | 0 - 0% | 0$ | 0$ | 3000 | 100 | 1,969,417$ | 1,969,417$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 185 | 14,441$ | 2,469,411$ |
| 10 | Grand Rapids Griffins (DET) | 2000 | 1000 | 45 | 25 | 0 | 0 | 0% | 0% | 36 | 0 - 0% | 0$ | 0$ | 3000 | 100 | 2,468,174$ | 2,468,174$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 185 | 17,358$ | 2,968,218$ |
| 11 | Hamilton Hammers (NYI) | 2000 | 1000 | 40 | 22 | 0 | 0 | 0% | 0% | 36 | 0 - 0% | 0$ | 0$ | 3000 | 100 | 2,106,918$ | 2,106,918$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 185 | 15,245$ | 2,606,895$ |
| 12 | Hartford Wolf Pack (NYR) | 2000 | 1000 | 50 | 20 | 0 | 0 | 0% | 0% | 36 | 0 - 0% | 0$ | 0$ | 3000 | 100 | 2,053,232$ | 2,053,232$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 185 | 14,931$ | 2,553,201$ |
| 13 |  Henderson Silver Knights (VGK) | 2000 | 1000 | 40 | 15 | 0 | 0 | 0% | 0% | 36 | 0 - 0% | 0$ | 0$ | 3000 | 100 | 2,127,102$ | 2,127,102$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 185 | 15,363$ | 2,627,073$ |
| 14 | Hershey Bears (WSH) | 2000 | 1000 | 40 | 20 | 0 | 0 | 0% | 0% | 36 | 0 - 0% | 0$ | 0$ | 3000 | 100 | 1,856,878$ | 1,856,878$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 185 | 13,783$ | 2,356,893$ |
| 15 |  Iowa Wild (MIN) | 2000 | 1000 | 36 | 17 | 0 | 0 | 0% | 0% | 36 | 0 - 0% | 0$ | 0$ | 3000 | 100 | 2,414,020$ | 2,414,020$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 185 | 17,041$ | 2,914,011$ |
| 16 | Laval Rocket (MTL) | 2000 | 1000 | 50 | 20 | 0 | 0 | 0% | 0% | 36 | 0 - 0% | 0$ | 0$ | 3000 | 100 | 1,877,357$ | 1,877,357$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 185 | 13,903$ | 2,377,413$ |
| 17 | Lehigh Valley Phantoms (PHI) | 2000 | 1000 | 50 | 20 | 0 | 0 | 0% | 0% | 36 | 0 - 0% | 0$ | 0$ | 3000 | 100 | 2,537,791$ | 2,537,791$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 185 | 17,765$ | 3,037,815$ |
| 18 |  Manitoba Moose (WPG) | 2000 | 1000 | 50 | 25 | 0 | 0 | 0% | 0% | 36 | 0 - 0% | 0$ | 0$ | 3000 | 100 | 1,932,333$ | 1,932,333$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 185 | 14,224$ | 2,432,304$ |
| 19 |  Milwaukee Admirals (NSH) | 2000 | 1000 | 50 | 20 | 0 | 0 | 0% | 0% | 36 | 0 - 0% | 0$ | 0$ | 3000 | 100 | 2,230,283$ | 2,230,283$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 185 | 15,967$ | 2,730,357$ |
| 20 |  Ontario Reign (LAK) | 2000 | 1000 | 50 | 20 | 0 | 0 | 0% | 0% | 36 | 0 - 0% | 0$ | 0$ | 3000 | 100 | 2,230,068$ | 2,230,068$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 185 | 15,965$ | 2,730,015$ |
| 21 | Providence Bruins (BOS) | 2000 | 1000 | 55 | 25 | 0 | 0 | 0% | 0% | 36 | 0 - 0% | 0$ | 0$ | 3000 | 100 | 3,174,336$ | 3,174,336$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 185 | 21,487$ | 3,674,277$ |
| 22 | Rochester Americans (BUF) | 2000 | 1000 | 55 | 25 | 0 | 0 | 0% | 0% | 36 | 0 - 0% | 0$ | 0$ | 3000 | 100 | 2,876,811$ | 2,876,811$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 185 | 19,747$ | 3,376,737$ |
| 23 |  Rockford IceHogs (CHI) | 2000 | 1000 | 50 | 21 | 0 | 0 | 0% | 0% | 36 | 0 - 0% | 0$ | 0$ | 3000 | 100 | 2,599,508$ | 2,599,508$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 185 | 18,126$ | 3,099,546$ |
| 24 |  San Diego Gulls (ANA) | 2000 | 1000 | 40 | 19 | 0 | 0 | 0% | 0% | 36 | 0 - 0% | 0$ | 0$ | 3000 | 100 | 2,084,027$ | 2,084,027$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 185 | 15,111$ | 2,583,981$ |
| 25 |  San Jose Barracuda (SJS) | 2000 | 1000 | 55 | 25 | 0 | 0 | 0% | 0% | 36 | 0 - 0% | 0$ | 0$ | 3000 | 100 | 2,548,572$ | 2,548,572$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 185 | 17,828$ | 3,048,588$ |
| 26 | Springfield Thunderbirds (STL) | 2000 | 1000 | 50 | 20 | 0 | 0 | 0% | 0% | 36 | 0 - 0% | 0$ | 0$ | 3000 | 100 | 1,960,865$ | 1,960,865$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 185 | 14,391$ | 2,460,861$ |
| 27 | Syracuse Crunch (TBL) | 2000 | 1000 | 50 | 20 | 0 | 0 | 0% | 0% | 36 | 0 - 0% | 0$ | 0$ | 3000 | 100 | 2,153,236$ | 2,153,236$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 185 | 15,516$ | 2,653,236$ |
| 28 |  Texas Stars (DAL) | 2000 | 1000 | 50 | 20 | 0 | 0 | 0% | 0% | 36 | 0 - 0% | 0$ | 0$ | 3000 | 100 | 2,096,354$ | 2,096,354$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 185 | 15,183$ | 2,596,293$ |
| 29 | Toronto Marlies (TOR) | 2000 | 1000 | 32 | 18 | 0 | 0 | 0% | 0% | 36 | 0 - 0% | 0$ | 0$ | 3000 | 100 | 2,209,543$ | 2,209,543$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 185 | 15,845$ | 2,709,495$ |
| 30 |  Tucson Roadrunners (UTA) | 2000 | 1000 | 50 | 20 | 0 | 0 | 0% | 0% | 36 | 0 - 0% | 0$ | 0$ | 3000 | 100 | 2,659,359$ | 2,659,359$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 185 | 18,476$ | 3,159,396$ |
| 31 | Utica Comets (NJD) | 2000 | 1000 | 50 | 20 | 0 | 0 | 0% | 0% | 36 | 0 - 0% | 0$ | 0$ | 3000 | 100 | 2,327,084$ | 2,327,084$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 185 | 16,533$ | 2,827,143$ |
| 32 | Wilkes-Barre Scranton Penguins (PIT) | 2000 | 1000 | 50 | 20 | 0 | 0 | 0% | 0% | 36 | 0 - 0% | 0$ | 0$ | 3000 | 100 | 2,160,333$ | 2,160,333$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 185 | 15,558$ | 2,660,418$ |