| 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 (VAN) | 5000 | 2500 | 35 | 15 | 127782 | 75276 | 79.86% | 94.10% | 4 | 6346 - 84.61% | 260,820$ | 8,346,251$ | 7500 | 100 | 1,932,583$ | 1,932,583$ | 2,581,964$ | 9,810$ | 1,666,196$ | 0 | 0 | 1,043,281$ | 32 | 15,394$ | 508,002$ |
| 2 |  Bakersfield Condors (EDM) | 5000 | 2500 | 30 | 15 | 154633 | 77166 | 96.65% | 96.46% | 4 | 7244 - 96.58% | 272,120$ | 8,707,849$ | 7500 | 100 | 1,583,466$ | 1,583,466$ | 2,375,978$ | 8,038$ | 1,360,346$ | 0 | 0 | 1,088,481$ | 32 | 14,231$ | 469,623$ |
| 3 |  Belleville Senators (OTT) | 5000 | 2500 | 35 | 15 | 130379 | 76073 | 81.49% | 95.09% | 4 | 6452 - 86.02% | 265,609$ | 8,499,498$ | 7500 | 100 | 1,822,000$ | 1,822,000$ | 2,624,844$ | 9,249$ | 1,750,724$ | 0 | 0 | 1,062,437$ | 32 | 14,579$ | 481,107$ |
| 4 |  Bridgeport Islanders (NYI) | 5000 | 2500 | 35 | 15 | 126868 | 75036 | 79.29% | 93.80% | 4 | 6310 - 84.13% | 259,163$ | 8,293,221$ | 7500 | 100 | 2,308,216$ | 2,308,216$ | 2,668,020$ | 11,717$ | 1,835,551$ | 0 | 0 | 1,036,653$ | 32 | 16,793$ | 554,169$ |
| 5 |  Calgary Wranglers (CAL) | 5000 | 2500 | 35 | 15 | 126775 | 76004 | 79.23% | 95.01% | 4 | 6337 - 84.49% | 259,688$ | 8,310,005$ | 7500 | 100 | 2,068,833$ | 2,068,833$ | 2,578,439$ | 10,502$ | 1,829,191$ | 0 | 0 | 1,038,751$ | 32 | 15,070$ | 497,310$ |
| 6 |  Charlotte Checkers (FLA) | 5000 | 2500 | 35 | 15 | 126487 | 76535 | 79.05% | 95.67% | 4 | 6344 - 84.59% | 259,589$ | 8,306,853$ | 7500 | 100 | 2,665,167$ | 2,665,167$ | 3,182,076$ | 13,529$ | 2,212,321$ | 0 | 0 | 1,038,357$ | 32 | 19,442$ | 641,586$ |
| 7 |  Chicago Wolves (CAR) | 5000 | 2500 | 35 | 15 | 127543 | 75883 | 79.71% | 94.85% | 4 | 6357 - 84.76% | 260,855$ | 8,347,351$ | 7500 | 100 | 2,161,500$ | 2,161,500$ | 2,259,228$ | 10,972$ | 1,593,256$ | 0 | 0 | 1,043,419$ | 32 | 15,033$ | 496,089$ |
| 8 |  Cleveland Monsters (CLB) | 5000 | 2500 | 35 | 15 | 125224 | 73065 | 78.27% | 91.33% | 4 | 6197 - 82.62% | 255,107$ | 8,163,432$ | 7500 | 100 | 2,190,833$ | 2,190,833$ | 2,682,043$ | 11,121$ | 1,591,486$ | 0 | 0 | 1,020,429$ | 32 | 17,771$ | 586,443$ |
| 9 |  Coachella Valley Firebirds (SEA) | 5000 | 2500 | 35 | 15 | 127928 | 77907 | 77.53% | 94.43% | 3 | 6237 - 83.17% | 254,929$ | 8,412,669$ | 7500 | 100 | 1,892,611$ | 1,892,611$ | 2,481,204$ | 9,607$ | 1,565,428$ | 0 | 0 | 764,788$ | 32 | 15,191$ | 501,303$ |
| 10 |  Colorado Eagles (COL) | 5000 | 2500 | 35 | 15 | 127460 | 75924 | 79.66% | 94.91% | 4 | 6356 - 84.74% | 260,748$ | 8,343,940$ | 7500 | 100 | 2,287,708$ | 2,287,708$ | 2,728,282$ | 11,613$ | 1,729,279$ | 0 | 0 | 1,042,992$ | 32 | 17,704$ | 584,232$ |
| 11 |  Grand Rapids Griffins (DET) | 5000 | 2500 | 35 | 15 | 128987 | 75129 | 80.62% | 93.91% | 4 | 6379 - 85.05% | 264,003$ | 8,448,097$ | 7500 | 100 | 1,935,499$ | 1,935,499$ | 2,484,170$ | 9,825$ | 1,651,706$ | 0 | 0 | 1,056,012$ | 32 | 14,901$ | 491,733$ |
| 12 |  Hartford Wolf Pack (NYR) | 5000 | 2500 | 35 | 15 | 126901 | 76591 | 79.31% | 95.74% | 4 | 6359 - 84.79% | 260,303$ | 8,329,697$ | 7500 | 100 | 2,262,784$ | 2,262,784$ | 2,642,792$ | 11,486$ | 1,810,326$ | 0 | 0 | 1,041,212$ | 32 | 16,562$ | 546,546$ |
| 13 |  Henderson Silver Knights (VEG) | 5000 | 2500 | 35 | 15 | 124935 | 76017 | 78.08% | 95.02% | 4 | 6280 - 83.73% | 256,698$ | 8,214,340$ | 7500 | 100 | 2,096,886$ | 2,096,886$ | 2,744,540$ | 10,644$ | 1,745,616$ | 0 | 0 | 1,026,792$ | 32 | 16,735$ | 552,255$ |
| 14 |  Hershey Bears (WAS) | 5000 | 2500 | 35 | 15 | 126053 | 75846 | 78.78% | 94.81% | 4 | 6309 - 84.12% | 258,401$ | 8,268,824$ | 7500 | 100 | 2,113,662$ | 2,113,662$ | 2,864,383$ | 10,729$ | 1,782,147$ | 0 | 0 | 1,033,603$ | 32 | 17,328$ | 571,824$ |
| 15 |  Iowa Wild (MIN) | 5000 | 2500 | 35 | 15 | 125771 | 75629 | 78.61% | 94.54% | 4 | 6294 - 83.92% | 257,790$ | 8,249,266$ | 7500 | 101 | 1,970,333$ | 1,970,333$ | 3,063,370$ | 10,002$ | 1,689,762$ | 0 | 0 | 1,031,158$ | 32 | 18,377$ | 606,441$ |
| 16 |  Laval Rocket (MON) | 5000 | 2500 | 35 | 15 | 126809 | 74595 | 79.26% | 93.24% | 4 | 6294 - 83.92% | 258,759$ | 8,280,287$ | 7500 | 100 | 1,740,084$ | 1,740,084$ | 2,388,225$ | 8,833$ | 1,514,110$ | 0 | 0 | 1,035,036$ | 32 | 14,163$ | 467,379$ |
| 17 |  Lehigh Valley Phantoms (PHI) | 5000 | 2500 | 35 | 15 | 132193 | 78140 | 80.12% | 94.72% | 3 | 6374 - 84.98% | 261,827$ | 8,640,292$ | 7500 | 100 | 2,272,417$ | 2,272,417$ | 2,622,281$ | 11,535$ | 1,914,730$ | 0 | 0 | 785,481$ | 32 | 15,850$ | 523,050$ |
| 18 |  Manitoba Moose (WIN) | 5000 | 2500 | 35 | 15 | 126818 | 75462 | 79.26% | 94.33% | 4 | 6321 - 84.28% | 259,379$ | 8,300,134$ | 7500 | 100 | 2,460,606$ | 2,460,606$ | 2,843,075$ | 12,490$ | 1,956,473$ | 0 | 0 | 1,037,517$ | 32 | 17,896$ | 590,568$ |
| 19 |  Milwaukee Admirals (NAS) | 5000 | 2500 | 35 | 15 | 127214 | 75909 | 79.51% | 94.89% | 4 | 6348 - 84.63% | 260,337$ | 8,330,774$ | 7500 | 100 | 2,394,000$ | 2,394,000$ | 2,974,141$ | 12,152$ | 1,975,053$ | 0 | 0 | 1,041,347$ | 32 | 18,244$ | 602,052$ |
| 20 |  Ontario Reign (LAK) | 5000 | 2500 | 35 | 15 | 126922 | 75111 | 79.33% | 93.89% | 4 | 6314 - 84.18% | 259,304$ | 8,297,712$ | 7500 | 100 | 2,126,416$ | 2,126,416$ | 2,558,290$ | 10,794$ | 1,767,475$ | 0 | 0 | 1,037,214$ | 32 | 15,616$ | 515,328$ |
| 21 |  Providence Bruins (BOS) | 5000 | 2500 | 35 | 15 | 128676 | 77692 | 77.99% | 94.17% | 3 | 6254 - 83.38% | 255,966$ | 8,446,868$ | 7500 | 100 | 2,172,250$ | 2,172,250$ | 2,639,841$ | 11,027$ | 1,849,028$ | 0 | 0 | 767,897$ | 32 | 15,849$ | 523,017$ |
| 22 |  Rochester Americans (BUF) | 5000 | 2500 | 35 | 15 | 125794 | 76718 | 78.62% | 95.90% | 4 | 6329 - 84.38% | 258,588$ | 8,274,803$ | 7500 | 100 | 2,219,576$ | 2,219,576$ | 2,785,723$ | 11,267$ | 1,882,442$ | 0 | 0 | 1,034,350$ | 32 | 16,774$ | 553,542$ |
| 23 |  Rockford IceHogs (CHI) | 5000 | 2500 | 37 | 18 | 117779 | 52914 | 73.61% | 66.14% | 4 | 5334 - 71.12% | 247,260$ | 7,912,313$ | 7500 | 100 | 2,227,825$ | 2,227,825$ | 2,899,270$ | 11,309$ | 1,900,346$ | 0 | 0 | 989,039$ | 32 | 17,400$ | 574,200$ |
| 24 |  San Diego Gulls (ANA) | 5000 | 2500 | 35 | 15 | 125597 | 74544 | 78.50% | 93.18% | 4 | 6254 - 83.39% | 256,748$ | 8,215,941$ | 7500 | 100 | 2,428,914$ | 2,428,914$ | 2,561,214$ | 12,330$ | 1,978,490$ | 0 | 0 | 1,026,993$ | 32 | 15,883$ | 524,139$ |
| 25 |  San Jose Barracuda (SJS) | 5000 | 2500 | 35 | 15 | 130112 | 76523 | 81.32% | 95.65% | 4 | 6457 - 86.10% | 265,488$ | 8,495,631$ | 7500 | 100 | 2,163,833$ | 2,163,833$ | 2,606,384$ | 10,984$ | 1,690,640$ | 0 | 0 | 1,061,954$ | 32 | 16,568$ | 546,744$ |
| 26 |  Springfield Thunderbirds (STL) | 5000 | 2500 | 34 | 14 | 128584 | 75284 | 80.37% | 94.11% | 4 | 6371 - 84.95% | 261,434$ | 8,365,903$ | 7500 | 100 | 2,597,167$ | 2,597,167$ | 2,684,626$ | 13,184$ | 1,768,913$ | 0 | 0 | 1,045,738$ | 32 | 18,767$ | 619,311$ |
| 27 |  Syracuse Crunch (TBL) | 5000 | 2500 | 35 | 15 | 129562 | 76230 | 80.98% | 95.29% | 4 | 6431 - 85.75% | 264,387$ | 8,460,398$ | 7500 | 100 | 2,198,500$ | 2,198,500$ | 2,449,392$ | 11,160$ | 1,783,388$ | 0 | 0 | 1,057,550$ | 32 | 15,221$ | 502,293$ |
| 28 |  Texas Stars (DAL) | 5000 | 2500 | 35 | 15 | 127200 | 74827 | 79.50% | 93.53% | 4 | 6313 - 84.18% | 259,636$ | 8,308,364$ | 7500 | 100 | 1,888,151$ | 1,888,151$ | 2,691,804$ | 9,585$ | 1,692,839$ | 0 | 0 | 1,038,546$ | 32 | 15,676$ | 517,308$ |
| 29 |  Toronto Marlies (TOR) | 5000 | 2500 | 35 | 15 | 125442 | 74142 | 78.40% | 92.68% | 4 | 6237 - 83.16% | 256,215$ | 8,198,874$ | 7500 | 100 | 2,031,834$ | 2,031,834$ | 2,258,820$ | 10,314$ | 1,467,918$ | 0 | 0 | 1,024,859$ | 32 | 15,136$ | 499,488$ |
| 30 |  Tucson Roadrunners (UHC) | 5000 | 2500 | 35 | 15 | 126909 | 76439 | 79.32% | 95.55% | 4 | 6355 - 84.73% | 260,210$ | 8,326,719$ | 7500 | 100 | 1,789,667$ | 1,789,667$ | 2,550,693$ | 9,085$ | 1,580,833$ | 0 | 0 | 1,040,840$ | 32 | 14,998$ | 494,934$ |
| 31 |  Utica Comets (NJD) | 5000 | 2500 | 35 | 15 | 129680 | 76121 | 81.05% | 95.15% | 4 | 6431 - 85.75% | 264,504$ | 8,464,119$ | 7500 | 100 | 1,941,445$ | 1,941,445$ | 2,704,208$ | 9,855$ | 1,617,868$ | 0 | 0 | 1,058,015$ | 32 | 16,479$ | 543,807$ |
| 32 |  Wilkes-Barre/Scranton Penguins (PIT) | 5000 | 2500 | 35 | 15 | 126696 | 76967 | 79.19% | 96.21% | 4 | 6364 - 84.86% | 260,232$ | 8,327,409$ | 7500 | 100 | 2,311,834$ | 2,311,834$ | 3,011,149$ | 11,735$ | 1,966,401$ | 0 | 0 | 1,040,926$ | 32 | 18,106$ | 597,498$ |