| 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 |  Abbotsford Canucks (CAL) | 2000 | 1000 | 31 | 11 | 14925 | 8473 | 82.92% | 94.14% | 31 | 2600 - 86.66% | 61,764$ | 555,878$ | 3000 | 100 | 1,425,300$ | 0$ | 350,721$ | 0$ | 350,721$ | 0 | 0 | 1,914,691$ | 143 | 7,581$ | 1,084,083$ |
| 2 |  Athens Rock Lobsters (FLA) | 2000 | 1000 | 31 | 11 | 13875 | 8558 | 77.08% | 95.09% | 31 | 2493 - 83.09% | 58,251$ | 524,263$ | 3000 | 100 | 2,015,900$ | 0$ | 482,535$ | 0$ | 482,535$ | 0 | 0 | 1,805,795$ | 143 | 10,723$ | 1,533,389$ |
| 3 |  Bakersfield Condors (EDM) | 2000 | 1000 | 36 | 15 | 13526 | 6971 | 75.14% | 77.46% | 31 | 2277 - 75.91% | 59,113$ | 532,019$ | 3000 | 100 | 2,642,100$ | 0$ | 632,969$ | 0$ | 632,969$ | 0 | 0 | 1,832,510$ | 143 | 14,054$ | 2,009,722$ |
| 4 |  Bloomington Bison (VAN) | 2000 | 1000 | 31 | 11 | 17817 | 10242 | 80.99% | 93.11% | 29 | 2551 - 85.03% | 60,454$ | 664,989$ | 3000 | 100 | 1,156,100$ | 0$ | 274,160$ | 0$ | 274,160$ | 0 | 0 | 1,753,153$ | 143 | 6,149$ | 879,307$ |
| 5 |  Bridgeport Islanders (NYI) | 2000 | 1000 | 35 | 15 | 13188 | 7323 | 82.43% | 91.54% | 32 | 2564 - 85.46% | 61,173$ | 489,381$ | 3000 | 100 | 1,171,400$ | 0$ | 280,395$ | 0$ | 280,395$ | 0 | 0 | 1,957,524$ | 143 | 6,231$ | 891,033$ |
| 6 |  Cleveland Monsters (CBJ) | 2000 | 1000 | 26 | 12 | 11612 | 4779 | 82.94% | 68.27% | 33 | 2342 - 78.05% | 56,700$ | 396,901$ | 3000 | 100 | 2,390,143$ | 0$ | 570,364$ | 0$ | 570,364$ | 0 | 0 | 1,871,105$ | 143 | 12,714$ | 1,818,102$ |
| 7 |  Coachella Valley Firebirds (SEA) | 2000 | 1000 | 31 | 11 | 12598 | 7168 | 78.74% | 89.60% | 32 | 2471 - 82.36% | 58,673$ | 469,386$ | 3000 | 100 | 3,112,500$ | 0$ | 722,676$ | 0$ | 722,676$ | 0 | 0 | 1,877,544$ | 143 | 16,556$ | 2,367,508$ |
| 8 |  Colorado Eagles (COL) | 2000 | 1000 | 31 | 11 | 12862 | 7463 | 80.39% | 93.29% | 32 | 2541 - 84.69% | 60,102$ | 480,815$ | 3000 | 100 | 1,771,000$ | 0$ | 475,770$ | 0$ | 475,770$ | 0 | 0 | 1,923,260$ | 143 | 9,420$ | 1,347,060$ |
| 9 |  Grand Rapids Griffins (DET) | 2000 | 1000 | 31 | 11 | 14818 | 8106 | 82.32% | 90.07% | 31 | 2547 - 84.90% | 60,947$ | 548,524$ | 3000 | 100 | 2,611,000$ | 0$ | 635,290$ | 0$ | 635,290$ | 0 | 0 | 1,889,360$ | 143 | 13,888$ | 1,985,984$ |
| 10 |  Greensboro Gargoyles (OTT) | 2000 | 1000 | 31 | 11 | 14273 | 8356 | 79.29% | 92.84% | 31 | 2514 - 83.81% | 59,375$ | 534,379$ | 3000 | 100 | 1,337,550$ | 0$ | 323,919$ | 0$ | 323,919$ | 0 | 0 | 1,840,639$ | 143 | 7,115$ | 1,017,445$ |
| 11 |  Greenville Swamp Rabbits (CAR) | 2000 | 1000 | 31 | 11 | 13107 | 7150 | 81.92% | 89.38% | 32 | 2532 - 84.40% | 60,621$ | 484,967$ | 3000 | 100 | 1,460,000$ | 0$ | 344,634$ | 0$ | 344,634$ | 0 | 0 | 1,939,868$ | 143 | 7,766$ | 1,110,538$ |
| 12 |  Henderson Silver Knights (VGK) | 2000 | 1000 | 31 | 11 | 13197 | 7509 | 82.48% | 93.86% | 32 | 2588 - 86.28% | 61,463$ | 491,706$ | 3000 | 100 | 1,398,056$ | 0$ | 347,381$ | 0$ | 347,381$ | 0 | 0 | 1,966,824$ | 143 | 7,436$ | 1,063,348$ |
| 13 |  Iowa Heartlanders (NYR) | 2000 | 1000 | 31 | 11 | 15252 | 8371 | 84.73% | 93.01% | 31 | 2625 - 87.49% | 62,766$ | 564,893$ | 3000 | 100 | 1,272,300$ | 0$ | 299,244$ | 0$ | 299,244$ | 0 | 0 | 1,945,743$ | 143 | 6,768$ | 967,824$ |
| 14 |  Laval Rocket (QUE) | 2000 | 1000 | 31 | 11 | 16498 | 9297 | 82.49% | 92.97% | 30 | 2580 - 85.98% | 61,371$ | 613,705$ | 3000 | 100 | 1,322,500$ | 0$ | 335,541$ | 0$ | 335,541$ | 0 | 0 | 1,841,115$ | 143 | 7,035$ | 1,006,005$ |
| 15 |  Lehigh Valley Phantoms (PHI) | 2000 | 1000 | 31 | 11 | 16370 | 9437 | 81.85% | 94.37% | 30 | 2581 - 86.02% | 61,128$ | 611,277$ | 3000 | 100 | 1,054,100$ | 0$ | 244,069$ | 0$ | 244,069$ | 0 | 0 | 1,833,831$ | 143 | 5,607$ | 801,801$ |
| 16 |  Macon Whoopee (STL) | 2000 | 1000 | 31 | 11 | 17441 | 10062 | 79.28% | 91.47% | 29 | 2500 - 83.34% | 59,214$ | 651,353$ | 3000 | 100 | 2,119,530$ | 0$ | 527,546$ | 0$ | 527,546$ | 0 | 0 | 1,717,203$ | 143 | 11,274$ | 1,612,182$ |
| 17 |  Milwaukee Admirals (SJS) | 2000 | 1000 | 31 | 11 | 13071 | 7167 | 81.69% | 89.59% | 32 | 2530 - 84.33% | 60,505$ | 484,038$ | 3000 | 100 | 1,327,500$ | 0$ | 317,745$ | 0$ | 317,745$ | 0 | 0 | 1,936,152$ | 143 | 7,061$ | 1,009,723$ |
| 18 |  Orlando Solar Bears (TBL) | 2000 | 1000 | 31 | 11 | 13923 | 8420 | 77.35% | 93.56% | 31 | 2483 - 82.75% | 58,248$ | 524,233$ | 3000 | 100 | 2,178,700$ | 0$ | 507,021$ | 0$ | 507,021$ | 0 | 0 | 1,805,691$ | 143 | 11,589$ | 1,657,227$ |
| 19 |  Pee Dee Pride (WPG) | 2000 | 1000 | 29 | 10 | 16522 | 8058 | 91.79% | 89.53% | 31 | 2731 - 91.04% | 63,620$ | 572,583$ | 3000 | 100 | 2,540,927$ | 0$ | 587,572$ | 0$ | 587,572$ | 0 | 0 | 1,972,230$ | 143 | 13,516$ | 1,932,788$ |
| 20 |  Providence Bruins (BOS) | 2000 | 1000 | 31 | 11 | 15874 | 9146 | 79.37% | 91.46% | 30 | 2502 - 83.40% | 60,101$ | 601,014$ | 3000 | 100 | 1,359,700$ | 0$ | 356,701$ | 0$ | 356,701$ | 0 | 0 | 1,803,042$ | 143 | 7,232$ | 1,034,176$ |
| 21 |  Reading Royals (LAK) | 2000 | 1000 | 26 | 12 | 18566 | 7502 | 92.83% | 75.02% | 30 | 2607 - 86.89% | 58,447$ | 584,472$ | 3000 | 100 | 2,860,078$ | 0$ | 635,182$ | 0$ | 635,182$ | 0 | 0 | 1,753,416$ | 143 | 15,213$ | 2,175,459$ |
| 22 |  Rochester Americans (PIT) | 2000 | 1000 | 31 | 11 | 14174 | 8131 | 78.74% | 90.34% | 31 | 2478 - 82.61% | 58,759$ | 528,835$ | 3000 | 100 | 2,028,500$ | 0$ | 485,550$ | 0$ | 485,550$ | 0 | 0 | 1,821,543$ | 143 | 10,790$ | 1,542,970$ |
| 23 |  Rockford IceHogs (CHI) | 2000 | 1000 | 31 | 11 | 11198 | 6587 | 79.99% | 94.10% | 33 | 2541 - 84.69% | 59,942$ | 419,595$ | 3000 | 100 | 1,433,000$ | 0$ | 369,968$ | 0$ | 369,968$ | 0 | 0 | 1,978,091$ | 143 | 7,622$ | 1,089,946$ |
| 24 |  San Diego Gulls (ANA) | 2000 | 1000 | 31 | 11 | 16280 | 9238 | 81.40% | 92.38% | 30 | 2552 - 85.06% | 60,630$ | 606,298$ | 3000 | 100 | 1,821,400$ | 0$ | 473,212$ | 0$ | 473,212$ | 0 | 0 | 1,818,894$ | 143 | 9,688$ | 1,385,384$ |
| 25 |  Savannah Ghost Pirates (TOR) | 2000 | 1000 | 31 | 11 | 9738 | 5637 | 81.15% | 93.95% | 34 | 2563 - 85.42% | 60,648$ | 363,885$ | 3000 | 100 | 2,091,800$ | 0$ | 477,435$ | 0$ | 477,435$ | 0 | 0 | 2,062,015$ | 143 | 11,127$ | 1,591,161$ |
| 26 |  Trois Rivieres Lions (MTL) | 2000 | 1000 | 31 | 11 | 18388 | 10040 | 83.58% | 91.27% | 29 | 2584 - 86.15% | 61,861$ | 680,468$ | 3000 | 100 | 1,759,700$ | 0$ | 426,913$ | 0$ | 426,913$ | 0 | 0 | 1,793,961$ | 143 | 9,360$ | 1,338,480$ |
| 27 |  Utica Devils (NJD) | 2000 | 1000 | 31 | 11 | 16243 | 9295 | 81.22% | 92.95% | 30 | 2554 - 85.13% | 60,578$ | 605,778$ | 3000 | 100 | 1,265,700$ | 0$ | 281,199$ | 0$ | 281,199$ | 0 | 0 | 1,817,334$ | 143 | 6,732$ | 962,676$ |
| 28 |  Wheeling Nailers (HAM) | 2000 | 1000 | 31 | 11 | 16318 | 9488 | 81.59% | 94.88% | 30 | 2581 - 86.02% | 61,023$ | 610,226$ | 3000 | 100 | 2,334,356$ | 0$ | 543,262$ | 0$ | 543,262$ | 0 | 0 | 1,830,678$ | 143 | 12,417$ | 1,775,631$ |