| 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 | Alaska Miners (VEG) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 54 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 1,833,749$ | 1,756,249$ | 682,023$ | 0$ | 682,023$ | 0 | 0 | 0$ | 150 | 6,999$ | 1,196,829$ |
| 2 | Austin Air Force (HOU) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 54 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 1,921,612$ | 1,807,112$ | 702,277$ | 0$ | 702,277$ | 0 | 0 | 0$ | 150 | 7,334$ | 1,254,114$ |
| 3 | Baltimore Bombers (PIT) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 53 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 2,189,084$ | 2,055,500$ | 751,157$ | 0$ | 751,157$ | 0 | 0 | 0$ | 150 | 8,355$ | 1,428,705$ |
| 4 | Boston Highlanders (BOS) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 54 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 1,939,918$ | 1,894,084$ | 698,268$ | 0$ | 698,268$ | 0 | 0 | 0$ | 150 | 7,404$ | 1,266,084$ |
| 5 | Calgary Cubs (CGY) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 54 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 2,254,361$ | 2,191,861$ | 824,218$ | 0$ | 824,218$ | 0 | 0 | 0$ | 150 | 8,604$ | 1,471,284$ |
| 6 | Chicago Hitmen (SAD) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 54 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 2,214,335$ | 2,164,335$ | 751,372$ | 0$ | 751,372$ | 0 | 0 | 0$ | 150 | 8,452$ | 1,445,292$ |
| 7 | Cleveland Lizards (JAX) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 54 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 2,432,300$ | 2,369,800$ | 799,658$ | 0$ | 799,658$ | 0 | 0 | 0$ | 150 | 9,284$ | 1,587,564$ |
| 8 | Colorado Chowderheads (DEN) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 54 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 2,151,861$ | 2,068,111$ | 723,669$ | 0$ | 723,669$ | 0 | 0 | 0$ | 150 | 8,213$ | 1,404,423$ |
| 9 | Fresno Poneys (SJS) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 53 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 2,020,528$ | 1,890,528$ | 671,637$ | 0$ | 671,637$ | 0 | 0 | 0$ | 150 | 7,712$ | 1,318,752$ |
| 10 | Green Bay Wolfpack (DET) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 53 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 2,424,543$ | 2,358,168$ | 743,873$ | 0$ | 743,873$ | 0 | 0 | 0$ | 150 | 9,254$ | 1,582,434$ |
| 11 | Hamilton Owls (TOR) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 54 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 2,034,250$ | 1,994,250$ | 719,669$ | 0$ | 719,669$ | 0 | 0 | 0$ | 150 | 7,764$ | 1,327,644$ |
| 12 | Laval Titans (MTL) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 54 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 1,993,833$ | 1,865,083$ | 703,150$ | 0$ | 703,150$ | 0 | 0 | 0$ | 150 | 7,610$ | 1,301,310$ |
| 13 | London HC (PHI) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 54 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 2,199,583$ | 2,141,750$ | 744,570$ | 0$ | 744,570$ | 0 | 0 | 0$ | 150 | 8,395$ | 1,435,545$ |
| 14 | Louisville Loggers (NOK) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 53 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 1,785,668$ | 1,735,668$ | 668,117$ | 0$ | 668,117$ | 0 | 0 | 0$ | 150 | 6,816$ | 1,165,536$ |
| 15 | Markham Toros (HAL) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 54 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 1,881,667$ | 1,831,667$ | 675,480$ | 0$ | 675,480$ | 0 | 0 | 0$ | 150 | 7,182$ | 1,228,122$ |
| 16 | Memphis Generals (NSH) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 54 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 1,836,417$ | 1,811,417$ | 624,937$ | 0$ | 624,937$ | 0 | 0 | 0$ | 150 | 7,009$ | 1,198,539$ |
| 17 | Miami Crocs (MIA) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 54 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 2,522,057$ | 2,433,307$ | 901,806$ | 0$ | 901,806$ | 0 | 0 | 0$ | 150 | 9,626$ | 1,646,046$ |
| 18 | New Jersey Dragons (DAL) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 53 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 1,956,084$ | 1,928,584$ | 702,198$ | 0$ | 702,198$ | 0 | 0 | 0$ | 150 | 7,466$ | 1,276,686$ |
| 19 | Ontario Wave (LAT) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 54 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 2,366,210$ | 2,298,710$ | 817,021$ | 0$ | 817,021$ | 0 | 0 | 0$ | 150 | 9,031$ | 1,544,301$ |
| 20 | Ottawa Red Saints (OTT) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 54 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 2,372,042$ | 2,322,042$ | 799,630$ | 0$ | 799,630$ | 0 | 0 | 0$ | 150 | 9,054$ | 1,548,234$ |
| 21 | Philadelphia Royals (HAR) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 54 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 2,124,847$ | 2,037,347$ | 709,779$ | 0$ | 709,779$ | 0 | 0 | 0$ | 150 | 8,110$ | 1,386,810$ |
| 22 | Portland Timbers (ORE) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 54 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 1,885,917$ | 1,873,417$ | 643,165$ | 0$ | 643,165$ | 0 | 0 | 0$ | 150 | 7,198$ | 1,230,858$ |
| 23 | Quebec Pumas (QUE) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 53 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 2,057,194$ | 2,034,194$ | 678,920$ | 0$ | 678,920$ | 0 | 0 | 0$ | 150 | 7,852$ | 1,342,692$ |
| 24 | Raleigh Blazers (REG) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 53 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 1,974,817$ | 1,927,317$ | 728,007$ | 0$ | 728,007$ | 0 | 0 | 0$ | 150 | 7,537$ | 1,288,827$ |
| 25 | San Diego Seals (SAN) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 54 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 2,668,500$ | 2,618,500$ | 915,883$ | 0$ | 915,883$ | 0 | 0 | 0$ | 150 | 10,185$ | 1,741,635$ |
| 26 | Seattle Steel (HLW) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 54 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 1,915,916$ | 1,793,416$ | 665,483$ | 0$ | 665,483$ | 0 | 0 | 0$ | 150 | 7,313$ | 1,250,523$ |
| 27 | Stockton Surf (SAC) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 54 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 2,748,584$ | 2,668,584$ | 766,253$ | 0$ | 766,253$ | 0 | 0 | 0$ | 150 | 10,491$ | 1,793,961$ |
| 28 | Syracuse Express (NYC) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 54 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 2,236,333$ | 2,128,833$ | 714,484$ | 0$ | 714,484$ | 0 | 0 | 0$ | 150 | 8,536$ | 1,459,656$ |
| 29 | Tampa Bay Scorpions (TAM) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 53 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 2,660,667$ | 2,340,667$ | 836,172$ | 0$ | 836,172$ | 0 | 0 | 0$ | 150 | 10,155$ | 1,736,505$ |
| 30 | Wyoming Mountain Lions (UTA) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 54 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 2,044,208$ | 1,977,958$ | 704,919$ | 0$ | 704,919$ | 0 | 0 | 0$ | 150 | 7,802$ | 1,334,142$ |
