| 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 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 | Alberta Fire (CGY) | 2000 | 1000 | 65 | 25 | 0 | 0 | 0% | 0% | 42 | 0 - 0% | 0$ | 0$ | 3000 | 100 | 2,888,750$ | 2,888,750$ | 0$ | 0$ | 0$ | 36 | 0 | 0$ | 4 | 0$ | 0$ |
| 2 | Cape Breton Roaring Moose (BUF) | 2000 | 1000 | 40 | 20 | 6000 | 2880 | 100.00% | 96.00% | 39 | 2960 - 98.67% | 138,880$ | 416,640$ | 3000 | 100 | 2,848,250$ | 2,848,250$ | 0$ | 0$ | 0$ | 35 | 0 | 0$ | 4 | 0$ | 0$ |
| 3 | Capital District Islanders (NYI) | 2000 | 1000 | 40 | 20 | 12000 | 5903 | 100.00% | 98.38% | 36 | 2984 - 99.46% | 139,547$ | 837,284$ | 3000 | 100 | 3,580,000$ | 3,580,000$ | 0$ | 0$ | 0$ | 43 | 0 | 0$ | 4 | 0$ | 0$ |
| 4 | Charlestown Chiefs (OTT) | 2000 | 1000 | 30 | 10 | 0 | 0 | 0% | 0% | 42 | 0 - 0% | 0$ | 0$ | 3000 | 100 | 3,218,750$ | 3,218,750$ | 0$ | 0$ | 0$ | 36 | 0 | 0$ | 4 | 0$ | 0$ |
| 5 | Charlotte Checkers (CAR) | 2000 | 1000 | 40 | 20 | 6000 | 2875 | 100.00% | 95.83% | 39 | 2958 - 98.61% | 138,833$ | 416,500$ | 3000 | 100 | 2,747,500$ | 2,747,500$ | 0$ | 0$ | 0$ | 34 | 0 | 0$ | 4 | 0$ | 0$ |
| 6 | Flint Admirals (VAN) | 2000 | 1000 | 40 | 20 | 0 | 0 | 0% | 0% | 42 | 0 - 0% | 0$ | 0$ | 3000 | 100 | 2,609,083$ | 2,609,083$ | 0$ | 0$ | 0$ | 33 | 0 | 0$ | 4 | 0$ | 0$ |
| 7 | Florida Everblades (FLO) | 2000 | 1000 | 48 | 21 | 0 | 0 | 0% | 0% | 42 | 0 - 0% | 0$ | 0$ | 3000 | 100 | 3,544,872$ | 3,544,872$ | 0$ | 0$ | 0$ | 41 | 0 | 0$ | 4 | 0$ | 0$ |
| 8 | Grand Rapids Griffins (DET) | 2000 | 1000 | 40 | 20 | 4000 | 1984 | 100.00% | 99.20% | 40 | 2992 - 99.73% | 139,776$ | 279,552$ | 3000 | 100 | 2,457,500$ | 2,457,500$ | 0$ | 0$ | 0$ | 30 | 0 | 0$ | 4 | 0$ | 0$ |
| 9 | Green Bay Lumberjacks (CBS) | 2000 | 1000 | 40 | 20 | 0 | 0 | 0% | 0% | 42 | 0 - 0% | 0$ | 0$ | 3000 | 100 | 3,239,666$ | 3,239,666$ | 0$ | 0$ | 0$ | 40 | 0 | 0$ | 4 | 0$ | 0$ |
| 10 | Hartford Wolf Pack (NYR) | 2000 | 1000 | 40 | 20 | 0 | 0 | 0% | 0% | 42 | 0 - 0% | 0$ | 0$ | 3000 | 100 | 2,240,000$ | 2,240,000$ | 0$ | 0$ | 0$ | 29 | 0 | 0$ | 4 | 0$ | 0$ |
| 11 | Henderson Silver Knights (VGK) | 2000 | 1000 | 40 | 20 | 4000 | 1912 | 100.00% | 95.60% | 40 | 2956 - 98.53% | 138,768$ | 277,536$ | 3000 | 100 | 3,959,417$ | 3,959,417$ | 0$ | 0$ | 0$ | 37 | 0 | 0$ | 4 | 0$ | 0$ |
| 12 | Hershey Bears (WSH) | 2000 | 1000 | 40 | 20 | 16000 | 7822 | 100.00% | 97.78% | 34 | 2978 - 99.26% | 139,377$ | 1,115,016$ | 3000 | 100 | 2,569,078$ | 2,569,078$ | 0$ | 0$ | 0$ | 28 | 0 | 0$ | 4 | 0$ | 0$ |
| 13 | Indianapolis Knights (CHI) | 2000 | 1000 | 40 | 20 | 6000 | 2703 | 100.00% | 90.10% | 39 | 2901 - 96.70% | 137,228$ | 411,684$ | 3000 | 100 | 3,168,667$ | 3,168,667$ | 0$ | 0$ | 0$ | 36 | 0 | 0$ | 4 | 0$ | 0$ |
| 14 | Laval Rocket (MTL) | 2000 | 1000 | 40 | 20 | 10000 | 4912 | 100.00% | 98.24% | 37 | 2982 - 99.41% | 139,507$ | 697,536$ | 3000 | 100 | 4,033,375$ | 4,033,375$ | 0$ | 0$ | 0$ | 37 | 0 | 0$ | 4 | 0$ | 0$ |
| 15 | Manitoba Moose (WPG) | 2000 | 1000 | 40 | 20 | 10000 | 4830 | 100.00% | 96.60% | 37 | 2966 - 98.87% | 139,048$ | 695,240$ | 3000 | 100 | 2,982,556$ | 2,982,556$ | 0$ | 0$ | 0$ | 33 | 0 | 0$ | 4 | 0$ | 0$ |
| 16 | Milwaukee Admirals (NSH) | 2000 | 1000 | 40 | 20 | 0 | 0 | 0% | 0% | 42 | 0 - 0% | 0$ | 0$ | 3000 | 100 | 3,015,000$ | 3,015,000$ | 0$ | 0$ | 0$ | 35 | 0 | 0$ | 4 | 0$ | 0$ |
| 17 | Minnesota Duluth Lakers (MIN) | 2000 | 1000 | 40 | 20 | 8000 | 3893 | 100.00% | 97.32% | 38 | 2973 - 99.11% | 139,251$ | 557,004$ | 3000 | 100 | 3,745,333$ | 3,745,333$ | 0$ | 0$ | 0$ | 39 | 0 | 0$ | 4 | 0$ | 0$ |
| 18 | Mississauga Wolves (TOR) | 2000 | 1000 | 40 | 20 | 0 | 0 | 0% | 0% | 42 | 0 - 0% | 0$ | 0$ | 3000 | 100 | 2,381,250$ | 2,381,250$ | 0$ | 0$ | 0$ | 31 | 0 | 0$ | 4 | 0$ | 0$ |
| 19 | Naples Stingrays (TBL) | 2000 | 1000 | 40 | 20 | 0 | 0 | 0% | 0% | 42 | 0 - 0% | 0$ | 0$ | 3000 | 100 | 2,901,250$ | 2,901,250$ | 0$ | 0$ | 0$ | 31 | 0 | 0$ | 4 | 0$ | 0$ |
| 20 | Oklahoma City Barons (EDM) | 2000 | 1000 | 40 | 20 | 0 | 0 | 0% | 0% | 42 | 0 - 0% | 0$ | 0$ | 3000 | 100 | 2,967,500$ | 2,967,500$ | 0$ | 0$ | 0$ | 29 | 0 | 0$ | 4 | 0$ | 0$ |
| 21 | Phoenix Coyotes (PHI) | 2000 | 1000 | 40 | 20 | 18000 | 8918 | 100.00% | 99.09% | 33 | 2991 - 99.70% | 139,745$ | 1,257,704$ | 3000 | 100 | 3,122,583$ | 3,122,583$ | 0$ | 0$ | 0$ | 32 | 2 | 0$ | 4 | 0$ | 0$ |
| 22 | Portland Wild Cats (SJS) | 2000 | 1000 | 40 | 20 | 0 | 0 | 0% | 0% | 42 | 0 - 0% | 0$ | 0$ | 3000 | 100 | 2,832,250$ | 2,832,250$ | 0$ | 0$ | 0$ | 33 | 0 | 0$ | 4 | 0$ | 0$ |
| 23 | Providence Bruins (BOS) | 2000 | 1000 | 67 | 27 | 3713 | 2332 | 61.88% | 77.73% | 39 | 2015 - 67.17% | 145,476$ | 436,429$ | 3000 | 100 | 3,575,000$ | 3,575,000$ | 0$ | 0$ | 0$ | 42 | 0 | 0$ | 4 | 0$ | 0$ |
| 24 | Salt Lake City Lynx (PIT) | 2000 | 1000 | 40 | 20 | 0 | 0 | 0% | 0% | 42 | 0 - 0% | 0$ | 0$ | 3000 | 100 | 2,495,500$ | 2,495,500$ | 0$ | 0$ | 0$ | 30 | 0 | 0$ | 4 | 0$ | 0$ |
| 25 | San Antonio Rampage (LAK) | 2000 | 1000 | 40 | 20 | 0 | 0 | 0% | 0% | 42 | 0 - 0% | 0$ | 0$ | 3000 | 100 | 2,617,083$ | 2,617,083$ | 0$ | 0$ | 0$ | 28 | 1 | 0$ | 4 | 0$ | 0$ |
| 26 | San Diego Gulls (ANA) | 2000 | 1000 | 40 | 20 | 0 | 0 | 0% | 0% | 42 | 0 - 0% | 0$ | 0$ | 3000 | 100 | 2,331,250$ | 2,331,250$ | 0$ | 0$ | 0$ | 27 | 0 | 0$ | 4 | 0$ | 0$ |
| 27 | Seattle Thunderbirds (SEA) | 2000 | 1000 | 40 | 20 | 0 | 0 | 0% | 0% | 42 | 0 - 0% | 0$ | 0$ | 3000 | 100 | 3,365,483$ | 3,365,483$ | 0$ | 0$ | 0$ | 39 | 0 | 0$ | 4 | 0$ | 0$ |
| 28 | Springfield Bulldogs (STL) | 2000 | 1000 | 40 | 20 | 6000 | 2972 | 100.00% | 99.07% | 39 | 2991 - 99.69% | 139,739$ | 419,216$ | 3000 | 100 | 3,249,750$ | 3,249,750$ | 0$ | 0$ | 0$ | 40 | 0 | 0$ | 4 | 0$ | 0$ |
| 29 | Texas Stars (DAL) | 2000 | 1000 | 40 | 20 | 4000 | 1836 | 100.00% | 91.80% | 40 | 2918 - 97.27% | 137,704$ | 275,408$ | 3000 | 100 | 3,657,917$ | 3,657,917$ | 0$ | 0$ | 0$ | 38 | 0 | 0$ | 4 | 0$ | 0$ |
| 30 | Tofino Whalers (COL) | 2000 | 1000 | 40 | 20 | 22000 | 10831 | 100.00% | 98.46% | 31 | 2985 - 99.49% | 139,570$ | 1,535,268$ | 3000 | 100 | 3,695,000$ | 3,695,000$ | 0$ | 0$ | 0$ | 38 | 1 | 0$ | 4 | 0$ | 0$ |
| 31 | Tucson Roadrunners (UTA) | 2000 | 1000 | 30 | 15 | 0 | 0 | 0% | 0% | 42 | 0 - 0% | 0$ | 0$ | 3000 | 100 | 3,291,250$ | 3,291,250$ | 0$ | 0$ | 0$ | 39 | 0 | 0$ | 4 | 0$ | 0$ |
| 32 | Utica Comets (NJD) | 2000 | 1000 | 34 | 17 | 18000 | 9000 | 100.00% | 100.00% | 33 | 3000 - 100.00% | 119,000$ | 1,071,000$ | 3000 | 100 | 3,687,917$ | 3,687,917$ | 0$ | 0$ | 0$ | 40 | 0 | 0$ | 4 | 0$ | 0$ |