| 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 | Binghampton Senators (OTT) | 2000 | 1000 | 35 | 15 | 45425 | 26997 | 81.12% | 96.42% | 13 | 2587 - 86.22% | 106,153$ | 2,972,295$ | 3000 | 100 | 2,292,501$ | 2,292,501$ | 1,599,530$ | 0$ | 1,599,530$ | 0 | 0 | 1,379,994$ | 45 | 16,567$ | 745,515$ |
| 2 | Boisbriand Armada (BOS) | 2000 | 1000 | 35 | 15 | 47053 | 27477 | 81.13% | 94.75% | 12 | 2570 - 85.67% | 105,790$ | 3,067,922$ | 3000 | 100 | 2,333,083$ | 2,333,083$ | 1,614,502$ | 0$ | 1,614,502$ | 0 | 0 | 1,269,485$ | 45 | 16,923$ | 761,535$ |
| 3 | Brampton Battalion (EDM) | 2000 | 1000 | 35 | 15 | 46067 | 27698 | 79.43% | 95.51% | 12 | 2544 - 84.79% | 104,188$ | 3,021,443$ | 3000 | 100 | 1,946,250$ | 1,946,250$ | 1,362,952$ | 0$ | 1,362,952$ | 0 | 0 | 1,250,252$ | 45 | 14,129$ | 635,805$ |
| 4 | Bridgeport Sound Tigers (NYI) | 2000 | 1000 | 35 | 15 | 45480 | 27520 | 78.41% | 94.90% | 12 | 2517 - 83.91% | 102,995$ | 2,986,856$ | 3000 | 100 | 2,158,484$ | 2,158,484$ | 1,370,394$ | 0$ | 1,370,394$ | 0 | 0 | 1,235,940$ | 45 | 15,623$ | 703,035$ |
| 5 | Buffalo Bisons (BUF) | 2000 | 1000 | 30 | 13 | 56209 | 28061 | 96.91% | 96.76% | 12 | 2906 - 96.86% | 105,382$ | 3,056,084$ | 3000 | 100 | 2,260,028$ | 2,260,028$ | 1,575,681$ | 0$ | 1,575,681$ | 0 | 0 | 1,264,586$ | 45 | 16,380$ | 737,100$ |
| 6 | Calgary Hitman (CAL) | 2000 | 1000 | 35 | 15 | 44900 | 26921 | 80.18% | 96.15% | 13 | 2565 - 85.50% | 105,115$ | 2,943,219$ | 3000 | 100 | 2,134,000$ | 2,134,000$ | 1,498,040$ | 0$ | 1,498,040$ | 0 | 0 | 1,366,495$ | 45 | 15,451$ | 695,295$ |
| 7 | Chicago Wolves (QUE) | 2000 | 1000 | 25 | 10 | 54174 | 27612 | 96.74% | 98.61% | 13 | 2921 - 97.36% | 86,764$ | 2,429,400$ | 3000 | 100 | 1,741,249$ | 1,741,249$ | 1,246,516$ | 0$ | 1,246,516$ | 0 | 0 | 1,127,936$ | 45 | 12,727$ | 572,715$ |
| 8 | Chicoutimi Sagueneens (FLA) | 2000 | 1000 | 35 | 15 | 46499 | 27980 | 80.17% | 96.48% | 12 | 2568 - 85.61% | 105,182$ | 3,050,274$ | 3000 | 100 | 2,221,833$ | 2,221,833$ | 1,510,594$ | 0$ | 1,510,594$ | 0 | 0 | 1,262,182$ | 45 | 16,069$ | 723,105$ |
| 9 | Drummondville Voltigeurs (WAS) | 2000 | 1000 | 35 | 15 | 44913 | 27877 | 77.44% | 96.13% | 12 | 2510 - 83.67% | 102,250$ | 2,965,264$ | 3000 | 100 | 1,988,999$ | 1,988,999$ | 1,431,220$ | 0$ | 1,431,220$ | 0 | 0 | 1,227,006$ | 45 | 14,430$ | 649,350$ |
| 10 | Grand Rapids Griffins (DET) | 2000 | 1000 | 35 | 15 | 45927 | 27970 | 79.18% | 96.45% | 12 | 2548 - 84.94% | 104,146$ | 3,020,221$ | 3000 | 100 | 2,327,874$ | 2,327,874$ | 1,575,706$ | 0$ | 1,575,706$ | 0 | 0 | 1,249,747$ | 45 | 16,816$ | 756,720$ |
| 11 | Hamilton Bulldogs (CLB) | 2000 | 1000 | 35 | 22 | 46321 | 16902 | 79.86% | 58.28% | 12 | 2180 - 72.67% | 102,403$ | 2,969,689$ | 3000 | 100 | 1,753,000$ | 1,753,000$ | 1,178,856$ | 0$ | 1,178,856$ | 0 | 0 | 1,228,837$ | 45 | 12,768$ | 574,560$ |
| 12 | Hartford Wolf Pack (NYR) | 2000 | 1000 | 35 | 15 | 45953 | 27704 | 79.23% | 95.53% | 12 | 2540 - 84.66% | 103,987$ | 3,015,634$ | 3000 | 100 | 2,459,306$ | 2,459,306$ | 1,586,917$ | 0$ | 1,586,917$ | 0 | 0 | 1,247,849$ | 45 | 17,759$ | 799,155$ |
| 13 | Hershey Bears (TAM) | 2000 | 1000 | 35 | 15 | 43830 | 26347 | 78.27% | 94.10% | 13 | 2506 - 83.54% | 102,664$ | 2,874,589$ | 3000 | 100 | 680,834$ | 680,834$ | 530,452$ | 0$ | 530,452$ | 0 | 0 | 1,334,631$ | 45 | 5,217$ | 234,765$ |
| 14 | Lake Erie Monsters (CLF) | 2000 | 1000 | 30 | 10 | 55851 | 28717 | 96.29% | 99.02% | 12 | 2916 - 97.20% | 100,842$ | 2,924,424$ | 3000 | 100 | 2,100,250$ | 2,100,250$ | 1,430,557$ | 0$ | 1,430,557$ | 0 | 0 | 1,210,106$ | 45 | 15,213$ | 684,585$ |
| 15 | Laval Rockets (MTL) | 2000 | 1000 | 45 | 25 | 37179 | 14972 | 64.10% | 51.63% | 12 | 1798 - 59.94% | 105,192$ | 3,050,558$ | 3000 | 100 | 2,040,583$ | 2,040,583$ | 1,377,358$ | 0$ | 1,377,358$ | 0 | 0 | 1,262,300$ | 45 | 14,793$ | 665,685$ |
| 16 | London Knights (MON) | 2000 | 1000 | 35 | 15 | 44645 | 26497 | 79.72% | 94.63% | 13 | 2541 - 84.69% | 104,302$ | 2,920,445$ | 3000 | 100 | 1,247,583$ | 1,247,583$ | 871,872$ | 0$ | 871,872$ | 0 | 0 | 1,355,921$ | 45 | 9,208$ | 414,360$ |
| 17 | Lowell Devils (SEA) | 2000 | 1000 | 35 | 15 | 45434 | 27168 | 78.33% | 93.68% | 12 | 2504 - 83.45% | 102,641$ | 2,976,587$ | 3000 | 100 | 2,306,496$ | 2,306,496$ | 1,742,446$ | 0$ | 1,742,446$ | 0 | 0 | 1,231,691$ | 45 | 16,708$ | 751,860$ |
| 18 | Manchester Monarchs (NSH) | 2000 | 1000 | 30 | 12 | 56651 | 28288 | 97.67% | 97.54% | 12 | 2929 - 97.63% | 104,762$ | 3,038,085$ | 3000 | 100 | 2,310,334$ | 2,310,334$ | 1,664,289$ | 0$ | 1,664,289$ | 0 | 0 | 1,257,139$ | 45 | 16,793$ | 755,685$ |
| 19 | Manitoba Moose (VAN) | 2000 | 1000 | 35 | 15 | 45849 | 27806 | 79.05% | 95.88% | 12 | 2540 - 84.66% | 103,879$ | 3,012,490$ | 3000 | 100 | 2,370,084$ | 2,370,084$ | 1,956,309$ | 0$ | 1,956,309$ | 0 | 0 | 1,246,548$ | 45 | 20,916$ | 941,220$ |
| 20 | Milwaukee Admirals (WIN) | 2000 | 1000 | 24 | 10 | 57538 | 28940 | 99.20% | 99.79% | 12 | 2982 - 99.40% | 85,820$ | 2,488,767$ | 3000 | 100 | 2,624,334$ | 2,624,334$ | 1,748,353$ | 0$ | 1,748,353$ | 0 | 0 | 1,029,835$ | 45 | 18,904$ | 850,680$ |
| 21 | Peoria Riverman (STL) | 2000 | 1000 | 35 | 15 | 46401 | 27373 | 80.00% | 94.39% | 12 | 2544 - 84.80% | 104,538$ | 3,031,599$ | 3000 | 100 | 2,585,118$ | 2,585,118$ | 1,506,071$ | 0$ | 1,506,071$ | 0 | 0 | 1,254,455$ | 45 | 18,628$ | 838,260$ |
| 22 | Philadelphia Phantoms (PHI) | 2000 | 1000 | 35 | 15 | 44116 | 26757 | 78.78% | 95.56% | 13 | 2531 - 84.37% | 103,524$ | 2,898,668$ | 3000 | 100 | 2,208,882$ | 2,208,882$ | 1,478,226$ | 0$ | 1,478,226$ | 0 | 0 | 1,345,810$ | 45 | 15,978$ | 719,010$ |
| 23 | Quebec Rempart (COL) | 2000 | 1000 | 50 | 30 | 31566 | 11956 | 54.42% | 41.23% | 12 | 1501 - 50.03% | 99,521$ | 2,886,098$ | 3000 | 100 | 2,306,249$ | 2,306,249$ | 1,410,565$ | 0$ | 1,410,565$ | 0 | 0 | 1,194,247$ | 45 | 16,664$ | 749,880$ |
| 24 | Rimouski Oceanic (HAR) | 2000 | 1000 | 50 | 30 | 32122 | 12012 | 55.38% | 41.42% | 12 | 1522 - 50.73% | 101,035$ | 2,930,027$ | 3000 | 100 | 2,526,888$ | 2,526,888$ | 1,693,760$ | 0$ | 1,693,760$ | 0 | 0 | 1,212,425$ | 45 | 18,218$ | 819,810$ |
| 25 | Rochester Americans (CHI) | 2000 | 1000 | 35 | 15 | 44308 | 26922 | 79.12% | 96.15% | 13 | 2544 - 84.80% | 104,013$ | 2,912,370$ | 3000 | 100 | 2,235,292$ | 2,235,292$ | 1,506,962$ | 0$ | 1,506,962$ | 0 | 0 | 1,352,172$ | 45 | 16,206$ | 729,270$ |
| 26 | Seattle Thunderbirds (PIT) | 2000 | 1000 | 35 | 15 | 45385 | 27352 | 78.25% | 94.32% | 12 | 2508 - 83.61% | 102,695$ | 2,978,146$ | 3000 | 100 | 1,875,250$ | 1,875,250$ | 1,273,893$ | 0$ | 1,273,893$ | 0 | 0 | 1,232,336$ | 45 | 13,629$ | 613,305$ |
| 27 | Sherbrooke Phoenix (VGK) | 2000 | 1000 | 40 | 20 | 41150 | 18198 | 70.95% | 62.75% | 12 | 2046 - 68.22% | 103,270$ | 2,994,839$ | 3000 | 100 | 2,154,917$ | 2,154,917$ | 1,450,029$ | 0$ | 1,450,029$ | 0 | 0 | 1,239,244$ | 45 | 15,640$ | 703,800$ |
| 28 | Texas Stars (DAL) | 2000 | 1000 | 35 | 15 | 45987 | 27445 | 79.29% | 94.64% | 12 | 2532 - 84.40% | 103,849$ | 3,011,618$ | 3000 | 100 | 2,032,944$ | 2,032,944$ | 1,420,547$ | 0$ | 1,420,547$ | 0 | 0 | 1,246,187$ | 45 | 14,739$ | 663,255$ |
| 29 | Toronto Marlies (TOR) | 2000 | 1000 | 25 | 12 | 57002 | 28373 | 98.28% | 97.84% | 12 | 2944 - 98.13% | 90,712$ | 2,630,636$ | 3000 | 100 | 2,413,350$ | 2,413,350$ | 1,588,698$ | 0$ | 1,588,698$ | 0 | 0 | 1,088,539$ | 45 | 17,418$ | 783,810$ |
| 30 | TroisRivieres Lions (LAK) | 2000 | 1000 | 35 | 15 | 46640 | 27770 | 80.41% | 95.76% | 12 | 2566 - 85.53% | 105,274$ | 3,052,934$ | 3000 | 100 | 2,138,166$ | 2,138,166$ | 1,571,382$ | 0$ | 1,571,382$ | 0 | 0 | 1,263,283$ | 45 | 15,480$ | 696,600$ |
| 31 | Victoriaville Tigres (MIW) | 2000 | 1000 | 35 | 15 | 45845 | 27672 | 79.04% | 95.42% | 12 | 2535 - 84.50% | 103,768$ | 3,009,285$ | 3000 | 100 | 1,910,583$ | 1,910,583$ | 1,402,414$ | 0$ | 1,402,414$ | 0 | 0 | 1,245,221$ | 45 | 13,877$ | 624,465$ |
| 32 | Worcester Sharks (SJS) | 2000 | 1000 | 35 | 15 | 45191 | 26763 | 80.70% | 95.58% | 13 | 2570 - 85.66% | 105,531$ | 2,954,864$ | 3000 | 100 | 2,062,917$ | 2,062,917$ | 1,361,286$ | 0$ | 1,361,286$ | 0 | 0 | 1,371,901$ | 45 | 15,070$ | 678,150$ |