| 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 | Alberta Fire (CGY) | 2000 | 1000 | 65 | 25 | 39508 | 24183 | 54.87% | 67.18% | 6 | 1769 - 58.97% | 123,379$ | 4,441,633$ | 3000 | 100 | 2,888,750$ | 2,888,750$ | 2,646,552$ | 2,888,750$ | 2,640,203$ | 36 | 0 | 740,272$ | 34 | 16,348$ | 539,484$ |
| 2 | Cape Breton Roaring Moose (BUF) | 2000 | 1000 | 40 | 20 | 71602 | 30741 | 99.45% | 85.39% | 6 | 2843 - 94.76% | 135,291$ | 4,870,460$ | 3000 | 100 | 2,848,250$ | 2,848,250$ | 2,655,098$ | 2,848,250$ | 2,642,592$ | 35 | 0 | 811,743$ | 34 | 16,137$ | 532,521$ |
| 3 | Capital District Islanders (NYI) | 2000 | 1000 | 40 | 20 | 71191 | 30859 | 98.88% | 85.72% | 6 | 2835 - 94.49% | 134,743$ | 4,850,748$ | 3000 | 100 | 3,655,000$ | 3,655,000$ | 3,216,858$ | 3,655,000$ | 3,209,458$ | 44 | 0 | 808,458$ | 34 | 20,339$ | 671,187$ |
| 4 | Charlestown Chiefs (OTT) | 2000 | 1000 | 30 | 10 | 71929 | 36000 | 99.90% | 100.00% | 6 | 2998 - 99.93% | 97,917$ | 3,525,018$ | 3000 | 100 | 3,218,750$ | 3,218,750$ | 2,784,370$ | 3,218,750$ | 2,784,370$ | 36 | 0 | 587,503$ | 34 | 18,066$ | 596,178$ |
| 5 | Charlotte Checkers (CAR) | 2000 | 1000 | 40 | 20 | 70933 | 30415 | 98.52% | 84.49% | 6 | 2815 - 93.84% | 133,996$ | 4,823,868$ | 3000 | 100 | 2,747,500$ | 2,747,500$ | 2,412,028$ | 2,747,500$ | 2,405,671$ | 34 | 0 | 803,978$ | 34 | 15,612$ | 515,196$ |
| 6 | Flint Admirals (VAN) | 2000 | 1000 | 40 | 20 | 73537 | 31988 | 99.37% | 86.45% | 5 | 2852 - 95.07% | 135,506$ | 5,013,736$ | 3000 | 100 | 2,861,583$ | 2,861,583$ | 2,463,700$ | 2,861,583$ | 2,453,644$ | 35 | 1 | 677,532$ | 34 | 16,206$ | 534,798$ |
| 7 | Florida Everblades (FLO) | 2000 | 1000 | 51 | 21 | 47830 | 30166 | 64.64% | 81.53% | 5 | 2108 - 70.27% | 120,635$ | 4,463,510$ | 3000 | 100 | 3,736,122$ | 3,736,122$ | 3,244,164$ | 3,658,622$ | 3,233,940$ | 42 | 1 | 603,177$ | 34 | 20,761$ | 685,113$ |
| 8 | Grand Rapids Griffins (DET) | 2000 | 1000 | 40 | 20 | 71564 | 31071 | 99.39% | 86.31% | 6 | 2851 - 95.03% | 135,488$ | 4,877,572$ | 3000 | 100 | 2,457,500$ | 2,457,500$ | 2,293,886$ | 2,457,500$ | 2,285,966$ | 30 | 0 | 812,929$ | 34 | 14,102$ | 465,366$ |
| 9 | Green Bay Lumberjacks (CBS) | 2000 | 1000 | 40 | 20 | 71340 | 30969 | 99.08% | 86.02% | 6 | 2842 - 94.73% | 135,060$ | 4,862,172$ | 3000 | 100 | 3,239,666$ | 3,239,666$ | 3,352,289$ | 3,239,666$ | 3,342,295$ | 40 | 0 | 810,362$ | 34 | 20,780$ | 685,740$ |
| 10 | Hartford Wolf Pack (NYR) | 2000 | 1000 | 40 | 20 | 71224 | 30434 | 98.92% | 84.54% | 6 | 2824 - 94.13% | 134,464$ | 4,840,696$ | 3000 | 100 | 2,316,250$ | 2,316,250$ | 2,126,709$ | 2,241,250$ | 2,097,033$ | 29 | 1 | 806,783$ | 34 | 13,366$ | 441,078$ |
| 11 | Henderson Silver Knights (VGK) | 2000 | 1000 | 40 | 20 | 73630 | 31433 | 99.50% | 84.95% | 5 | 2840 - 94.65% | 135,227$ | 5,003,404$ | 3000 | 100 | 3,959,417$ | 3,959,417$ | 3,524,733$ | 3,959,417$ | 3,517,437$ | 37 | 0 | 676,136$ | 34 | 22,445$ | 740,685$ |
| 12 | Hershey Bears (WSH) | 2000 | 1000 | 40 | 20 | 73169 | 32076 | 98.88% | 86.69% | 5 | 2844 - 94.82% | 135,016$ | 4,995,592$ | 3000 | 100 | 2,494,078$ | 2,494,078$ | 2,388,304$ | 2,494,078$ | 2,385,080$ | 27 | 0 | 675,080$ | 34 | 14,292$ | 471,636$ |
| 13 | Indianapolis Knights (CHI) | 2000 | 1000 | 40 | 20 | 71128 | 30447 | 98.79% | 84.58% | 6 | 2822 - 94.05% | 134,325$ | 4,835,684$ | 3000 | 100 | 3,089,917$ | 3,089,917$ | 2,743,951$ | 3,089,917$ | 2,740,823$ | 35 | 0 | 805,947$ | 34 | 17,395$ | 574,035$ |
| 14 | Laval Rocket (MTL) | 2000 | 1000 | 40 | 20 | 72996 | 31467 | 98.64% | 85.05% | 5 | 2823 - 94.11% | 134,293$ | 4,968,852$ | 3000 | 100 | 4,033,375$ | 4,033,375$ | 2,876,808$ | 4,033,375$ | 2,859,424$ | 37 | 0 | 671,466$ | 34 | 22,309$ | 736,197$ |
| 15 | Manitoba Moose (WPG) | 2000 | 1000 | 40 | 20 | 71399 | 31130 | 99.17% | 86.47% | 6 | 2848 - 94.93% | 135,277$ | 4,869,984$ | 3000 | 100 | 2,982,556$ | 2,982,556$ | 2,818,732$ | 2,982,556$ | 2,805,704$ | 33 | 1 | 811,664$ | 34 | 16,836$ | 555,588$ |
| 16 | Milwaukee Admirals (NSH) | 2000 | 1000 | 40 | 20 | 73190 | 31543 | 98.91% | 85.25% | 5 | 2831 - 94.35% | 134,644$ | 4,981,844$ | 3000 | 100 | 2,862,500$ | 2,862,500$ | 2,500,209$ | 2,862,500$ | 2,497,084$ | 33 | 0 | 673,222$ | 34 | 16,211$ | 534,963$ |
| 17 | Minnesota Duluth Lakers (MIN) | 2000 | 1000 | 40 | 20 | 73101 | 31575 | 98.79% | 85.34% | 5 | 2829 - 94.30% | 134,534$ | 4,977,756$ | 3000 | 100 | 3,745,333$ | 3,745,333$ | 3,053,313$ | 3,745,333$ | 3,050,089$ | 39 | 0 | 672,670$ | 34 | 20,809$ | 686,697$ |
| 18 | Mississauga Wolves (TOR) | 2000 | 1000 | 40 | 20 | 71273 | 30748 | 98.99% | 85.41% | 6 | 2834 - 94.46% | 134,784$ | 4,852,232$ | 3000 | 100 | 2,508,750$ | 2,508,750$ | 2,236,086$ | 2,508,750$ | 2,222,853$ | 32 | 1 | 808,705$ | 34 | 14,368$ | 474,144$ |
| 19 | Naples Stingrays (TBL) | 2000 | 1000 | 40 | 20 | 70813 | 30445 | 98.35% | 84.57% | 6 | 2813 - 93.76% | 133,833$ | 4,817,988$ | 3000 | 100 | 3,051,250$ | 3,051,250$ | 2,607,343$ | 3,051,250$ | 2,590,574$ | 33 | 0 | 802,998$ | 34 | 17,194$ | 567,402$ |
| 20 | Oklahoma City Barons (EDM) | 2000 | 1000 | 40 | 20 | 72752 | 30932 | 98.31% | 83.60% | 5 | 2802 - 93.41% | 133,519$ | 4,940,208$ | 3000 | 100 | 2,967,500$ | 2,967,500$ | 2,648,810$ | 2,892,500$ | 2,636,439$ | 28 | 1 | 667,596$ | 34 | 16,758$ | 553,014$ |
| 21 | Phoenix Coyotes (PHI) | 2000 | 1000 | 40 | 20 | 73597 | 31261 | 99.46% | 84.49% | 5 | 2834 - 94.47% | 135,047$ | 4,996,740$ | 3000 | 100 | 3,242,583$ | 3,242,583$ | 3,412,879$ | 3,165,083$ | 3,389,495$ | 33 | 2 | 675,235$ | 34 | 20,795$ | 686,235$ |
| 22 | Portland Wild Cats (SJS) | 2000 | 1000 | 40 | 20 | 72322 | 31497 | 97.73% | 85.13% | 5 | 2806 - 93.53% | 133,296$ | 4,931,948$ | 3000 | 100 | 2,834,750$ | 2,834,750$ | 2,613,639$ | 2,834,750$ | 2,600,830$ | 33 | 1 | 666,479$ | 34 | 16,066$ | 530,178$ |
| 23 | Providence Bruins (BOS) | 2000 | 1000 | 67 | 27 | 37821 | 23024 | 52.53% | 63.96% | 6 | 1690 - 56.34% | 122,720$ | 4,417,916$ | 3000 | 100 | 3,497,500$ | 3,497,500$ | 3,206,246$ | 3,497,500$ | 3,199,886$ | 41 | 0 | 736,319$ | 34 | 19,518$ | 644,094$ |
| 24 | Salt Lake City Lynx (PIT) | 2000 | 1000 | 40 | 20 | 72746 | 31502 | 98.31% | 85.14% | 5 | 2818 - 93.92% | 133,941$ | 4,955,832$ | 3000 | 100 | 2,495,500$ | 2,495,500$ | 1,999,946$ | 2,403,000$ | 1,983,447$ | 29 | 1 | 669,707$ | 34 | 14,299$ | 471,867$ |
| 25 | San Antonio Rampage (LAK) | 2000 | 1000 | 40 | 20 | 73272 | 31323 | 99.02% | 84.66% | 5 | 2827 - 94.23% | 134,602$ | 4,980,276$ | 3000 | 100 | 2,617,083$ | 2,617,083$ | 2,382,072$ | 2,522,083$ | 2,352,983$ | 27 | 2 | 673,010$ | 34 | 14,933$ | 492,789$ |
| 26 | San Diego Gulls (ANA) | 2000 | 1000 | 40 | 20 | 73103 | 31348 | 98.79% | 84.72% | 5 | 2823 - 94.10% | 134,365$ | 4,971,512$ | 3000 | 100 | 2,331,250$ | 2,331,250$ | 2,214,755$ | 2,231,250$ | 2,188,819$ | 26 | 1 | 671,826$ | 34 | 13,444$ | 443,652$ |
| 27 | Seattle Thunderbirds (SEA) | 2000 | 1000 | 40 | 20 | 73419 | 31466 | 99.21% | 85.04% | 5 | 2835 - 94.49% | 134,933$ | 4,992,512$ | 3000 | 100 | 3,720,483$ | 3,720,483$ | 3,256,624$ | 3,720,483$ | 3,243,288$ | 43 | 0 | 674,664$ | 34 | 20,680$ | 682,440$ |
| 28 | Springfield Bulldogs (STL) | 2000 | 1000 | 40 | 20 | 71237 | 30960 | 98.94% | 86.00% | 6 | 2839 - 94.63% | 134,893$ | 4,856,152$ | 3000 | 100 | 3,249,750$ | 3,249,750$ | 2,924,324$ | 3,249,750$ | 2,924,324$ | 40 | 0 | 809,359$ | 34 | 18,228$ | 601,524$ |
| 29 | Texas Stars (DAL) | 2000 | 1000 | 40 | 20 | 71498 | 31110 | 99.30% | 86.42% | 6 | 2850 - 95.01% | 135,416$ | 4,874,968$ | 3000 | 100 | 3,657,917$ | 3,657,917$ | 3,252,782$ | 3,581,667$ | 3,237,459$ | 37 | 1 | 812,495$ | 34 | 20,354$ | 671,682$ |
| 30 | Tofino Whalers (COL) | 2000 | 1000 | 40 | 20 | 72910 | 31604 | 98.53% | 85.42% | 5 | 2825 - 94.16% | 134,267$ | 4,967,872$ | 3000 | 100 | 3,567,500$ | 3,567,500$ | 3,705,725$ | 3,567,500$ | 3,705,725$ | 37 | 2 | 671,334$ | 34 | 21,185$ | 699,105$ |
| 31 | Tucson Roadrunners (UTA) | 2000 | 1000 | 30 | 15 | 73993 | 36982 | 99.99% | 99.95% | 5 | 2999 - 99.98% | 104,982$ | 3,884,328$ | 3000 | 100 | 3,291,250$ | 3,291,250$ | 3,014,538$ | 3,291,250$ | 3,008,178$ | 39 | 0 | 524,909$ | 34 | 18,444$ | 608,652$ |
| 32 | Utica Comets (NJD) | 2000 | 1000 | 34 | 17 | 73669 | 36861 | 99.55% | 99.62% | 5 | 2987 - 99.58% | 118,485$ | 4,383,936$ | 3000 | 100 | 3,687,917$ | 3,687,917$ | 3,362,268$ | 3,687,917$ | 3,314,759$ | 40 | 0 | 592,424$ | 34 | 20,510$ | 676,830$ |