| 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 | 3L (WAS) | 2000 | 1000 | 30 | 15 | 15618 | 7875 | 97.61% | 98.44% | -7 | 2937 - 97.89% | 84,333$ | 674,663$ | 3000 | 100 | 2,437,354$ | 2,437,354$ | 463,954$ | 18,749$ | 458,647$ | 0 | 0 | -590,330$ | 105 | 18,749$ | 1,968,645$ |
| 2 | Armada (EDM) | 2000 | 1000 | 50 | 30 | 11781 | 5633 | 65.45% | 62.59% | -8 | 1935 - 64.50% | 96,861$ | 871,748$ | 3000 | 100 | 3,727,640$ | 3,727,640$ | 714,954$ | 28,674$ | 713,058$ | 0 | 0 | -774,887$ | 105 | 28,674$ | 3,010,770$ |
| 3 | Barons (FLO) | 2000 | 1000 | 35 | 15 | 15255 | 7889 | 95.34% | 98.61% | -6 | 2893 - 96.43% | 93,763$ | 750,100$ | 3000 | 100 | 2,306,440$ | 2,306,440$ | 444,522$ | 17,742$ | 444,522$ | 0 | 0 | -656,338$ | 105 | 17,742$ | 1,862,910$ |
| 4 | Bison (DAL) | 2000 | 1000 | 50 | 30 | 10545 | 5032 | 65.91% | 62.90% | -7 | 1947 - 64.90% | 97,493$ | 779,943$ | 3000 | 100 | 2,192,821$ | 2,192,821$ | 444,780$ | 16,868$ | 443,948$ | 0 | 0 | -682,450$ | 105 | 16,868$ | 1,771,140$ |
| 5 | Chops (TBL) | 2000 | 1000 | 50 | 30 | 12323 | 5552 | 68.46% | 61.69% | -7 | 1986 - 66.20% | 100,013$ | 900,115$ | 3000 | 100 | 2,556,534$ | 2,479,034$ | 452,058$ | 19,069$ | 445,578$ | 0 | 0 | -800,102$ | 105 | 19,666$ | 2,064,930$ |
| 6 |  Comets (VAN) | 2000 | 1000 | 35 | 15 | 15511 | 7860 | 96.94% | 98.25% | -6 | 2921 - 97.38% | 94,988$ | 759,904$ | 3000 | 100 | 2,442,730$ | 2,442,730$ | 497,762$ | 18,790$ | 497,762$ | 0 | 0 | -664,916$ | 105 | 18,790$ | 1,972,950$ |
| 7 |  Firebirds (SEA) | 2000 | 1000 | 35 | 15 | 15627 | 7890 | 97.67% | 98.63% | -7 | 2940 - 97.99% | 95,636$ | 765,089$ | 3000 | 100 | 3,042,038$ | 3,042,038$ | 606,299$ | 23,400$ | 604,451$ | 0 | 0 | -669,453$ | 105 | 23,400$ | 2,457,000$ |
| 8 |  Griffins (DET) | 2000 | 1000 | 38 | 22 | 17173 | 8593 | 95.41% | 95.48% | -7 | 2863 - 95.43% | 107,540$ | 967,863$ | 3000 | 100 | 2,374,629$ | 2,374,629$ | 456,650$ | 18,266$ | 456,650$ | 0 | 0 | -860,323$ | 105 | 18,266$ | 1,917,930$ |
| 9 | Heat (CGY) | 2000 | 1000 | 40 | 30 | 15258 | 4927 | 95.36% | 61.59% | -6 | 2523 - 84.10% | 108,981$ | 871,850$ | 3000 | 100 | 2,956,704$ | 2,956,704$ | 599,827$ | 22,744$ | 597,982$ | 0 | 0 | -762,869$ | 105 | 22,744$ | 2,388,120$ |
| 10 | Hobos (BUF) | 2000 | 1000 | 30 | 20 | 15317 | 7629 | 95.73% | 95.36% | -6 | 2868 - 95.61% | 87,988$ | 703,904$ | 3000 | 100 | 2,781,915$ | 2,781,915$ | 534,975$ | 21,399$ | 534,975$ | 0 | 0 | -615,916$ | 105 | 21,399$ | 2,246,895$ |
| 11 |  IceHogs (CHI) | 2000 | 1000 | 45 | 30 | 11684 | 4944 | 73.03% | 61.80% | -7 | 2079 - 69.28% | 96,902$ | 775,216$ | 3000 | 100 | 3,795,855$ | 3,795,855$ | 728,821$ | 29,199$ | 725,359$ | 0 | 0 | -678,314$ | 105 | 29,199$ | 3,065,895$ |
| 12 | Jarrets Noirs (ANA) | 2000 | 1000 | 50 | 30 | 10761 | 5026 | 67.26% | 62.83% | -7 | 1973 - 65.78% | 99,019$ | 792,155$ | 3000 | 100 | 3,348,948$ | 3,348,948$ | 644,025$ | 25,761$ | 644,025$ | 0 | 0 | -693,136$ | 105 | 25,761$ | 2,704,905$ |
| 13 | Lions (UTA) | 2000 | 1000 | 35 | 15 | 17616 | 8755 | 97.87% | 97.28% | -7 | 2930 - 97.67% | 95,563$ | 860,068$ | 3000 | 100 | 2,476,716$ | 2,406,716$ | 493,282$ | 18,513$ | 491,667$ | 0 | 0 | -764,505$ | 105 | 19,052$ | 2,000,460$ |
| 14 | Monster (TOR) | 2000 | 1000 | 45 | 25 | 12106 | 5953 | 75.66% | 74.41% | -7 | 2257 - 75.25% | 99,704$ | 797,635$ | 3000 | 100 | 3,071,943$ | 3,071,943$ | 580,355$ | 23,630$ | 580,355$ | 0 | 0 | -697,931$ | 105 | 23,630$ | 2,481,150$ |
| 15 | National (PIT) | 2000 | 1000 | 50 | 30 | 10389 | 4986 | 64.93% | 62.33% | -6 | 1922 - 64.06% | 96,173$ | 769,385$ | 3000 | 100 | 2,966,974$ | 2,966,974$ | 520,617$ | 22,823$ | 518,772$ | 0 | 0 | -673,212$ | 105 | 22,823$ | 2,396,415$ |
| 16 |  Phantoms (PHI) | 2000 | 1000 | 50 | 30 | 11406 | 5658 | 63.37% | 62.87% | -7 | 1896 - 63.20% | 94,561$ | 851,046$ | 3000 | 100 | 2,892,230$ | 2,892,230$ | 552,327$ | 22,248$ | 552,327$ | 0 | 0 | -756,485$ | 105 | 22,248$ | 2,336,040$ |
| 17 | Rambo (SJS) | 2000 | 1000 | 40 | 22 | 15705 | 7653 | 98.16% | 95.66% | -6 | 2920 - 97.33% | 114,506$ | 916,051$ | 3000 | 100 | 2,358,756$ | 2,358,756$ | 452,908$ | 18,144$ | 450,832$ | 0 | 0 | -801,545$ | 105 | 18,144$ | 1,905,120$ |
| 18 | Rapido (CLB) | 2000 | 1000 | 40 | 20 | 15056 | 7789 | 94.10% | 97.36% | -6 | 2856 - 95.19% | 108,965$ | 871,723$ | 3000 | 100 | 3,413,486$ | 3,413,486$ | 675,826$ | 26,258$ | 675,826$ | 0 | 0 | -762,758$ | 105 | 26,258$ | 2,757,090$ |
| 19 | Red Bull (CAR) | 2000 | 1000 | 50 | 30 | 10645 | 5044 | 66.53% | 63.05% | -7 | 1961 - 65.37% | 98,263$ | 786,105$ | 3000 | 100 | 2,110,923$ | 2,110,923$ | 410,864$ | 16,238$ | 410,095$ | 0 | 0 | -687,842$ | 105 | 16,238$ | 1,704,990$ |
| 20 |  Rocket (WPG) | 2000 | 1000 | 45 | 25 | 13199 | 6678 | 73.33% | 74.20% | -7 | 2209 - 73.62% | 97,227$ | 875,040$ | 3000 | 100 | 1,824,672$ | 1,824,672$ | 341,382$ | 14,036$ | 336,363$ | 0 | 0 | -777,813$ | 105 | 14,036$ | 1,473,780$ |
| 21 | Sea Dogs (MTL) | 2000 | 1000 | 50 | 30 | 10566 | 4870 | 66.04% | 60.88% | -7 | 1930 - 64.32% | 96,945$ | 775,559$ | 3000 | 100 | 3,141,026$ | 3,141,026$ | 641,832$ | 24,162$ | 641,832$ | 0 | 0 | -678,614$ | 105 | 24,162$ | 2,537,010$ |
| 22 |  Silver Knights (VGK) | 2000 | 1000 | 30 | 20 | 15733 | 7720 | 98.33% | 96.50% | -7 | 2932 - 97.72% | 90,044$ | 720,348$ | 3000 | 100 | 3,149,342$ | 3,149,342$ | 597,074$ | 24,226$ | 597,074$ | 0 | 0 | -630,304$ | 105 | 24,226$ | 2,543,730$ |
| 23 | Spartans (BOS) | 2000 | 1000 | 40 | 25 | 14948 | 5706 | 93.43% | 71.33% | -6 | 2582 - 86.06% | 106,457$ | 851,654$ | 3000 | 100 | 2,229,451$ | 2,159,451$ | 403,677$ | 16,611$ | 398,745$ | 0 | 0 | -745,197$ | 105 | 17,150$ | 1,800,750$ |
| 24 | Steelheads (NYI) | 2000 | 1000 | 50 | 30 | 12376 | 5660 | 68.76% | 62.89% | -7 | 2004 - 66.80% | 100,766$ | 906,891$ | 3000 | 100 | 3,014,189$ | 3,014,189$ | 591,650$ | 23,186$ | 591,650$ | 0 | 0 | -806,125$ | 105 | 23,186$ | 2,434,530$ |
| 25 |  Thunderbirds (STL) | 2000 | 1000 | 50 | 30 | 10175 | 5048 | 63.59% | 63.10% | -6 | 1903 - 63.43% | 94,902$ | 759,219$ | 3000 | 100 | 2,949,048$ | 2,949,048$ | 574,106$ | 22,685$ | 571,970$ | 0 | 0 | -664,317$ | 105 | 22,685$ | 2,381,925$ |
| 26 | Trashers (NAS) | 2000 | 1000 | 35 | 15 | 17198 | 8856 | 95.54% | 98.40% | -7 | 2895 - 96.50% | 93,887$ | 844,985$ | 3000 | 100 | 3,189,014$ | 3,189,014$ | 609,775$ | 24,531$ | 606,166$ | 0 | 0 | -751,098$ | 105 | 24,531$ | 2,575,755$ |
| 27 |  Wild (MIN) | 2000 | 1000 | 35 | 15 | 15675 | 7909 | 97.97% | 98.86% | -7 | 2948 - 98.27% | 95,919$ | 767,349$ | 3000 | 100 | 2,709,986$ | 2,709,986$ | 513,956$ | 20,846$ | 513,956$ | 0 | 0 | -671,430$ | 105 | 20,846$ | 2,188,830$ |
| 28 |  Wolf Pack (NYR) | 2000 | 1000 | 35 | 15 | 15467 | 7871 | 96.67% | 98.39% | -7 | 2917 - 97.24% | 94,790$ | 758,321$ | 3000 | 100 | 4,570,634$ | 4,570,634$ | 878,975$ | 35,159$ | 878,975$ | 0 | 0 | -663,531$ | 105 | 35,159$ | 3,691,695$ |