| 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 Average Salaries | 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) | 2000 | 1000 | 35 | 15 | 11506 | 5511 | 95.88% | 91.85% | 35 | 2836 - 94.54% | 41,257$ | 247,540$ | 3000 | 100 | 21,223,668$ | 1,675,000$ | 2,709,408$ | 0$ | 2,709,408$ | 0 | 0 | 1,443,983$ | 159 | 112,892$ | 18,514,288$ |
| 2 |  Bakersfield Condors (EDM) | 2000 | 1000 | 35 | 15 | 9300 | 4513 | 93.00% | 90.26% | 36 | 2763 - 92.09% | 40,106$ | 200,530$ | 3000 | 100 | 22,099,000$ | 5,150,000$ | 2,821,152$ | 0$ | 2,821,152$ | 0 | 0 | 1,443,816$ | 159 | 117,548$ | 19,277,872$ |
| 3 |  Bellerive Senators (OTT) | 2000 | 1000 | 35 | 15 | 9216 | 4743 | 92.16% | 94.86% | 36 | 2792 - 93.06% | 40,158$ | 200,789$ | 3000 | 100 | 24,288,584$ | 1,710,000$ | 3,100,680$ | 0$ | 3,100,680$ | 0 | 0 | 1,445,681$ | 159 | 129,195$ | 21,187,980$ |
| 4 |  Bridgeport Islanders (NYI) | 2000 | 1000 | 35 | 15 | 9424 | 4492 | 94.24% | 89.84% | 36 | 2783 - 92.77% | 40,516$ | 202,582$ | 3000 | 100 | 19,477,812$ | 3,650,000$ | 2,486,520$ | 0$ | 2,486,520$ | 0 | 0 | 1,458,590$ | 159 | 103,605$ | 16,991,220$ |
| 5 |  Charlotte Checkers (FLA) | 2000 | 1000 | 35 | 15 | 9277 | 4704 | 92.77% | 94.08% | 36 | 2796 - 93.21% | 40,316$ | 201,580$ | 3000 | 100 | 15,556,500$ | 800,000$ | 1,985,928$ | 0$ | 1,985,928$ | 0 | 0 | 1,451,376$ | 159 | 82,747$ | 13,570,508$ |
| 6 |  Chicago Wolves (CAR) | 2000 | 1000 | 35 | 15 | 11135 | 5342 | 92.79% | 89.03% | 35 | 2746 - 91.54% | 39,938$ | 239,626$ | 3000 | 100 | 15,815,000$ | 0$ | 2,018,928$ | 0$ | 2,018,928$ | 0 | 0 | 1,397,818$ | 159 | 84,122$ | 13,796,008$ |
| 7 |  Cleveland Monsters (CBS) | 2000 | 1000 | 35 | 15 | 9066 | 4478 | 90.66% | 89.56% | 36 | 2709 - 90.29% | 39,217$ | 196,085$ | 3000 | 100 | 18,033,750$ | 1,808,750$ | 2,302,176$ | 0$ | 2,302,176$ | 0 | 0 | 1,411,812$ | 159 | 95,924$ | 15,731,536$ |
| 8 |  Coachella Valley Firebirds (SEA) | 2000 | 1000 | 35 | 15 | 11184 | 5691 | 93.20% | 94.85% | 35 | 2813 - 93.75% | 40,529$ | 243,171$ | 3000 | 100 | 25,025,650$ | 5,086,004$ | 3,092,640$ | 0$ | 3,092,640$ | 0 | 0 | 1,418,498$ | 159 | 133,115$ | 21,830,860$ |
| 9 |  Colorado Eagles (COL) | 2000 | 1000 | 35 | 15 | 9347 | 4848 | 93.47% | 96.96% | 36 | 2839 - 94.63% | 40,786$ | 203,931$ | 3000 | 100 | 20,430,832$ | 5,232,500$ | 2,608,200$ | 0$ | 2,608,200$ | 0 | 0 | 1,468,303$ | 159 | 108,675$ | 17,822,700$ |
| 10 |  Grand Rapids Griffins (DET) | 2000 | 1000 | 35 | 15 | 10844 | 5631 | 90.37% | 93.85% | 35 | 2746 - 91.53% | 39,440$ | 236,642$ | 3000 | 100 | 18,730,000$ | 2,560,000$ | 2,391,072$ | 0$ | 2,391,072$ | 0 | 0 | 1,380,412$ | 159 | 99,628$ | 16,338,992$ |
| 11 |  Hartford Wolf Pack (NYR) | 2000 | 1000 | 35 | 15 | 11651 | 5698 | 97.09% | 94.97% | 35 | 2892 - 96.38% | 41,927$ | 251,560$ | 3000 | 100 | 17,125,000$ | 3,375,000$ | 2,186,160$ | 0$ | 2,186,160$ | 0 | 0 | 1,467,433$ | 159 | 91,090$ | 14,938,760$ |
| 12 |  Henderson Silver Knights (VGK) | 2000 | 1000 | 35 | 15 | 9069 | 4499 | 90.69% | 89.98% | 36 | 2714 - 90.45% | 39,260$ | 196,299$ | 3000 | 100 | 20,927,000$ | 925,000$ | 2,671,536$ | 0$ | 2,671,536$ | 0 | 0 | 1,413,353$ | 159 | 111,314$ | 18,255,496$ |
| 13 |  Hershey Bears (WSH) | 2000 | 1000 | 35 | 15 | 9345 | 4801 | 93.45% | 96.02% | 36 | 2829 - 94.31% | 40,707$ | 203,536$ | 3000 | 100 | 17,020,000$ | 865,000$ | 2,172,768$ | 0$ | 2,172,768$ | 0 | 0 | 1,465,459$ | 159 | 90,532$ | 14,847,248$ |
| 14 |  Iowa Wild (MIN) | 2000 | 1000 | 35 | 15 | 8923 | 4550 | 89.23% | 91.00% | 36 | 2695 - 89.82% | 38,817$ | 194,083$ | 3000 | 100 | 16,540,000$ | 900,000$ | 2,111,496$ | 0$ | 2,111,496$ | 0 | 0 | 1,397,398$ | 159 | 87,979$ | 14,428,556$ |
| 15 |  Laval Rockets (MTL) | 2000 | 1000 | 35 | 15 | 11786 | 5600 | 98.22% | 93.33% | 35 | 2898 - 96.59% | 42,203$ | 253,220$ | 3000 | 100 | 15,491,000$ | 0$ | 1,977,576$ | 0$ | 1,977,576$ | 0 | 0 | 1,477,117$ | 159 | 82,399$ | 13,513,436$ |
| 16 |  Lehigh Valley Phantoms (PHI) | 2000 | 1000 | 35 | 15 | 11181 | 5760 | 93.18% | 96.00% | 35 | 2824 - 94.12% | 40,608$ | 243,645$ | 3000 | 100 | 15,590,000$ | 0$ | 1,990,224$ | 0$ | 1,990,224$ | 0 | 0 | 1,421,262$ | 159 | 82,926$ | 13,599,864$ |
| 17 |  Manitoba Moose (WPG) | 2000 | 1000 | 35 | 15 | 10788 | 5741 | 89.90% | 95.68% | 35 | 2755 - 91.83% | 39,414$ | 236,485$ | 3000 | 100 | 16,198,750$ | 0$ | 2,073,444$ | 0$ | 2,073,444$ | 0 | 0 | 1,379,496$ | 159 | 86,164$ | 14,130,896$ |
| 18 |  Milwaukee Admirals (NSH) | 2000 | 1000 | 35 | 15 | 9004 | 4841 | 90.04% | 96.82% | 36 | 2769 - 92.30% | 39,551$ | 197,755$ | 3000 | 100 | 19,540,000$ | 0$ | 2,494,464$ | 0$ | 2,494,464$ | 0 | 0 | 1,423,836$ | 159 | 103,936$ | 17,045,504$ |
| 19 |  Ontario Reign (LAK) | 2000 | 1000 | 35 | 15 | 9104 | 4555 | 91.04% | 91.10% | 36 | 2732 - 91.06% | 39,471$ | 197,353$ | 3000 | 100 | 16,137,500$ | 0$ | 2,060,112$ | 0$ | 2,060,112$ | 0 | 0 | 1,420,942$ | 159 | 85,838$ | 14,077,432$ |
| 20 |  Providence Bruins (BOS) | 2000 | 1000 | 35 | 15 | 8950 | 4730 | 89.50% | 94.60% | 36 | 2736 - 91.20% | 39,188$ | 195,942$ | 3000 | 100 | 20,843,750$ | 3,395,000$ | 2,619,683$ | 0$ | 2,619,683$ | 0 | 0 | 1,410,782$ | 159 | 110,871$ | 18,182,844$ |
| 21 |  Rochester Americans (BUF) | 2000 | 1000 | 35 | 15 | 9557 | 4443 | 95.57% | 88.86% | 36 | 2800 - 93.33% | 40,916$ | 204,582$ | 3000 | 100 | 16,989,666$ | 3,395,000$ | 2,168,904$ | 0$ | 2,168,904$ | 0 | 0 | 1,472,990$ | 159 | 90,371$ | 14,820,844$ |
| 22 |  Rockford IceDogs (CHI) | 2000 | 1000 | 35 | 15 | 11406 | 5507 | 95.05% | 91.78% | 35 | 2819 - 93.96% | 40,954$ | 245,726$ | 3000 | 100 | 20,121,250$ | 4,195,000$ | 2,568,672$ | 0$ | 2,568,672$ | 0 | 0 | 1,433,402$ | 159 | 107,028$ | 17,552,592$ |
| 23 |  San Diego Gulls (ANA) | 2000 | 1000 | 35 | 15 | 11042 | 5636 | 92.02% | 93.93% | 35 | 2780 - 92.66% | 40,036$ | 240,214$ | 3000 | 100 | 18,200,000$ | 0$ | 2,323,416$ | 0$ | 2,323,416$ | 0 | 0 | 1,401,248$ | 159 | 96,809$ | 15,876,676$ |
| 24 |  San Jose Barracuda (SJS) | 2000 | 1000 | 35 | 15 | 9200 | 4819 | 92.00% | 96.38% | 36 | 2804 - 93.46% | 40,217$ | 201,086$ | 3000 | 100 | 17,863,332$ | 2,495,000$ | 2,280,432$ | 0$ | 2,280,432$ | 0 | 0 | 1,447,819$ | 159 | 95,018$ | 15,582,952$ |
| 25 |  Scranton Penguins (PIT) | 2000 | 1000 | 35 | 15 | 9435 | 4707 | 94.35% | 94.14% | 36 | 2828 - 94.28% | 40,885$ | 204,424$ | 3000 | 100 | 17,150,000$ | 0$ | 2,189,352$ | 0$ | 2,189,352$ | 0 | 0 | 1,471,853$ | 159 | 91,223$ | 14,960,572$ |
| 26 |  Springfield Thunderbirds (STL) | 2000 | 1000 | 35 | 15 | 9078 | 4482 | 90.78% | 89.64% | 36 | 2712 - 90.40% | 39,266$ | 196,329$ | 3000 | 100 | 15,263,664$ | 0$ | 1,948,560$ | 0$ | 1,948,560$ | 0 | 0 | 1,413,569$ | 159 | 81,190$ | 13,315,160$ |
| 27 |  Stockton Heat (CGY) | 2000 | 1000 | 35 | 15 | 11468 | 5587 | 95.57% | 93.12% | 35 | 2843 - 94.75% | 41,241$ | 247,444$ | 3000 | 100 | 18,320,832$ | 840,000$ | 2,338,824$ | 0$ | 2,338,824$ | 0 | 0 | 1,443,423$ | 159 | 97,451$ | 15,981,964$ |
| 28 |  Syracuse Crunch (TBL) | 2000 | 1000 | 35 | 15 | 9304 | 4513 | 93.04% | 90.26% | 36 | 2763 - 92.11% | 40,120$ | 200,600$ | 3000 | 100 | 17,118,332$ | 0$ | 2,185,320$ | 0$ | 2,185,320$ | 0 | 0 | 1,444,320$ | 159 | 91,055$ | 14,933,020$ |
| 29 |  Texas Stars (DAL) | 2000 | 1000 | 35 | 15 | 9674 | 4764 | 96.74% | 95.28% | 36 | 2888 - 96.25% | 41,825$ | 209,126$ | 3000 | 100 | 16,395,000$ | 1,795,000$ | 2,092,968$ | 0$ | 2,092,968$ | 0 | 0 | 1,505,707$ | 159 | 87,207$ | 14,301,948$ |
| 30 |  Toronto Marlies (TOR) | 2000 | 1000 | 35 | 15 | 9762 | 4650 | 97.62% | 93.00% | 36 | 2882 - 96.08% | 41,965$ | 209,824$ | 3000 | 100 | 15,750,000$ | 850,000$ | 2,010,648$ | 0$ | 2,010,648$ | 0 | 0 | 1,510,733$ | 159 | 83,777$ | 13,739,428$ |
| 31 |  Tucson Roadrunners (ARZ) | 2000 | 1000 | 35 | 15 | 10957 | 5641 | 91.31% | 94.02% | 35 | 2766 - 92.21% | 39,789$ | 238,736$ | 3000 | 100 | 24,113,332$ | 7,810,833$ | 3,177,240$ | 0$ | 3,177,240$ | 0 | 0 | 1,392,627$ | 159 | 128,262$ | 21,034,968$ |
| 32 |  Utica Comets (NJD) | 2000 | 1000 | 35 | 15 | 9406 | 4739 | 94.06% | 94.78% | 36 | 2829 - 94.30% | 40,830$ | 204,151$ | 3000 | 100 | 24,218,646$ | 2,450,000$ | 3,091,752$ | 0$ | 3,091,752$ | 0 | 0 | 1,469,887$ | 159 | 128,823$ | 21,126,972$ |