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 | 28425 | 14344 | 94.75% | 95.63% | 0 | 2851 - 95.04% | 120,197$ | 1,802,953$ | 3000 | 100 | 1,721,334$ | 1,721,334$ | 2,258,136$ | 0$ | 1,764,926$ | 0 | 0 | 0$ | 2 | 30,018$ | 30,018$ |
2 | Bakersfield Condors (EDM) | 2000 | 1000 | 35 | 15 | 27763 | 13976 | 92.54% | 93.17% | 0 | 2783 - 92.75% | 117,347$ | 1,760,204$ | 3000 | 100 | 1,850,875$ | 1,850,875$ | 2,218,607$ | 0$ | 1,725,356$ | 0 | 0 | 0$ | 2 | 31,769$ | 31,769$ |
3 | Belleville Senators (OTT) | 2000 | 1000 | 35 | 15 | 27604 | 14117 | 92.01% | 94.11% | 0 | 2781 - 92.71% | 117,004$ | 1,755,063$ | 3000 | 100 | 2,337,249$ | 2,337,249$ | 2,778,533$ | 0$ | 2,285,273$ | 0 | 0 | 0$ | 2 | 38,341$ | 38,341$ |
4 | Bridgeport Islanders (NYI) | 2000 | 1000 | 35 | 15 | 27752 | 14124 | 92.51% | 94.16% | 0 | 2792 - 93.06% | 117,529$ | 1,762,937$ | 3000 | 100 | 1,672,833$ | 1,672,833$ | 2,094,351$ | 0$ | 1,601,101$ | 0 | 0 | 0$ | 2 | 29,363$ | 29,363$ |
5 | Calgary Wranglers (CGY) | 2000 | 1000 | 35 | 15 | 25823 | 13331 | 92.23% | 95.22% | 1 | 2797 - 93.22% | 117,473$ | 1,644,618$ | 3000 | 100 | 1,881,165$ | 1,881,165$ | 2,297,778$ | 0$ | 1,804,517$ | 0 | 0 | 117,473$ | 2 | 32,178$ | 32,178$ |
6 | Charlotte Checkers (FLA) | 2000 | 1000 | 35 | 15 | 27124 | 14099 | 90.41% | 93.99% | 0 | 2748 - 91.61% | 115,309$ | 1,729,630$ | 3000 | 100 | 2,026,917$ | 2,026,917$ | 2,484,222$ | 0$ | 1,990,962$ | 0 | 0 | 0$ | 2 | 34,148$ | 34,148$ |
7 | Chicago Wolves (CAR) | 2000 | 1000 | 35 | 15 | 27751 | 13984 | 92.50% | 93.23% | 0 | 2782 - 92.74% | 117,317$ | 1,759,758$ | 3000 | 100 | 1,759,584$ | 1,759,584$ | 2,195,372$ | 0$ | 1,702,114$ | 0 | 0 | 0$ | 2 | 30,535$ | 30,535$ |
8 | Cleveland Monsters (CBJ) | 2000 | 1000 | 35 | 15 | 27953 | 14005 | 93.18% | 93.37% | 0 | 2797 - 93.24% | 118,051$ | 1,770,760$ | 3000 | 100 | 1,651,579$ | 1,651,579$ | 2,133,968$ | 0$ | 1,640,728$ | 0 | 0 | 0$ | 2 | 29,075$ | 29,075$ |
9 | Coachella Valley Firebirds (SEA) | 2000 | 1000 | 35 | 15 | 28301 | 14015 | 94.34% | 93.43% | 0 | 2821 - 94.04% | 119,275$ | 1,789,132$ | 3000 | 100 | 1,676,209$ | 1,676,209$ | 2,076,780$ | 0$ | 1,583,523$ | 0 | 0 | 0$ | 2 | 29,408$ | 29,408$ |
10 | Colorado Eagles (COL) | 2000 | 1000 | 35 | 15 | 27587 | 13824 | 91.96% | 92.16% | 0 | 2761 - 92.02% | 116,508$ | 1,747,627$ | 3000 | 100 | 1,855,916$ | 1,855,916$ | 2,247,616$ | 0$ | 1,754,397$ | 0 | 0 | 0$ | 2 | 31,837$ | 31,837$ |
11 | Grand Rapids Griffins (DET) | 2000 | 1000 | 35 | 15 | 26083 | 13006 | 93.15% | 92.90% | 1 | 2792 - 93.07% | 117,922$ | 1,650,911$ | 3000 | 100 | 2,152,646$ | 2,152,646$ | 2,603,581$ | 0$ | 2,110,320$ | 0 | 0 | 117,922$ | 2 | 35,847$ | 35,847$ |
12 | Hartford Wolf Pack (NYR) | 2000 | 1000 | 35 | 15 | 27936 | 14210 | 93.12% | 94.73% | 0 | 2810 - 93.66% | 118,297$ | 1,774,457$ | 3000 | 100 | 1,641,375$ | 1,641,375$ | 2,211,573$ | 0$ | 1,718,312$ | 0 | 0 | 0$ | 2 | 28,938$ | 28,938$ |
13 | Henderson Silver Knights (VGK) | 2000 | 1000 | 35 | 15 | 28242 | 13822 | 94.14% | 92.15% | 0 | 2804 - 93.48% | 118,783$ | 1,781,742$ | 3000 | 100 | 1,625,467$ | 1,625,467$ | 2,085,251$ | 0$ | 1,591,990$ | 0 | 0 | 0$ | 2 | 28,723$ | 28,723$ |
14 | Hershey Bears (WSH) | 2000 | 1000 | 35 | 15 | 27629 | 14048 | 92.10% | 93.65% | 0 | 2778 - 92.62% | 116,988$ | 1,754,826$ | 3000 | 100 | 2,321,917$ | 2,321,917$ | 2,783,782$ | 0$ | 2,290,521$ | 0 | 0 | 0$ | 2 | 38,134$ | 38,134$ |
15 | Iowa Wild (MIN) | 2000 | 1000 | 35 | 15 | 27437 | 13703 | 91.46% | 91.35% | 0 | 2743 - 91.42% | 115,807$ | 1,737,103$ | 3000 | 100 | 2,069,332$ | 2,069,332$ | 2,532,944$ | 0$ | 2,039,696$ | 0 | 0 | 0$ | 2 | 34,721$ | 34,721$ |
16 | Laval Rocket (MTL) | 2000 | 1000 | 43 | 23 | 17696 | 7150 | 63.20% | 51.07% | 1 | 1775 - 59.16% | 98,486$ | 1,378,810$ | 3000 | 100 | 1,637,167$ | 1,637,167$ | 1,969,085$ | 0$ | 1,475,831$ | 0 | 0 | 98,486$ | 2 | 28,881$ | 28,881$ |
17 | Lehigh Valley Phantoms (PHI) | 2000 | 1000 | 35 | 15 | 27906 | 13791 | 93.02% | 91.94% | 0 | 2780 - 92.66% | 117,569$ | 1,763,528$ | 3000 | 100 | 2,188,583$ | 2,188,583$ | 2,595,878$ | 0$ | 2,102,617$ | 0 | 0 | 0$ | 2 | 36,332$ | 36,332$ |
18 | Manitoba Moose (WPG) | 2000 | 1000 | 35 | 15 | 25476 | 12873 | 90.99% | 91.95% | 1 | 2739 - 91.31% | 115,449$ | 1,616,283$ | 3000 | 100 | 2,102,167$ | 2,102,167$ | 2,566,972$ | 0$ | 2,073,784$ | 0 | 0 | 115,449$ | 2 | 35,164$ | 35,164$ |
19 | Milwaukee Admirals (NSH) | 2000 | 1000 | 35 | 15 | 27979 | 13833 | 93.26% | 92.22% | 0 | 2787 - 92.92% | 117,885$ | 1,768,273$ | 3000 | 100 | 1,751,500$ | 1,751,500$ | 2,212,076$ | 0$ | 1,718,824$ | 0 | 0 | 0$ | 2 | 30,426$ | 30,426$ |
20 | Ontario Reign (LAK) | 2000 | 1000 | 35 | 15 | 27451 | 13676 | 91.50% | 91.17% | 0 | 2742 - 91.39% | 115,815$ | 1,737,229$ | 3000 | 100 | 2,057,793$ | 2,057,793$ | 2,346,193$ | 0$ | 1,852,944$ | 0 | 0 | 0$ | 2 | 34,565$ | 34,565$ |
21 | Providence Bruins (BOS) | 2000 | 1000 | 35 | 15 | 27830 | 14227 | 92.77% | 94.85% | 0 | 2804 - 93.46% | 117,954$ | 1,769,306$ | 3000 | 100 | 1,820,999$ | 1,820,999$ | 2,275,929$ | 0$ | 1,782,668$ | 0 | 0 | 0$ | 2 | 31,365$ | 31,365$ |
22 | Rochester Americans (BUF) | 2000 | 1000 | 35 | 15 | 28077 | 14062 | 93.59% | 93.75% | 0 | 2809 - 93.64% | 118,567$ | 1,778,501$ | 3000 | 100 | 1,777,500$ | 1,777,500$ | 2,337,466$ | 0$ | 1,844,221$ | 0 | 0 | 0$ | 2 | 30,777$ | 30,777$ |
23 | Rockford IceHogs (CHI) | 2000 | 1000 | 35 | 15 | 28289 | 14155 | 94.30% | 94.37% | 0 | 2830 - 94.32% | 119,442$ | 1,791,635$ | 3000 | 100 | 2,034,084$ | 2,034,084$ | 2,509,563$ | 0$ | 2,016,327$ | 0 | 0 | 0$ | 2 | 34,244$ | 34,244$ |
24 | San Diego Gulls (ANA) | 2000 | 1000 | 35 | 15 | 28268 | 14144 | 94.23% | 94.29% | 0 | 2827 - 94.25% | 119,353$ | 1,790,297$ | 3000 | 100 | 1,665,207$ | 1,665,207$ | 2,211,028$ | 0$ | 1,717,794$ | 0 | 0 | 0$ | 2 | 29,260$ | 29,260$ |
25 | San Jose Barracuda (SJS) | 2000 | 1000 | 35 | 15 | 27728 | 14027 | 92.43% | 93.51% | 0 | 2784 - 92.79% | 117,301$ | 1,759,518$ | 3000 | 100 | 1,686,166$ | 1,686,166$ | 2,186,956$ | 0$ | 1,693,695$ | 0 | 0 | 0$ | 2 | 29,543$ | 29,543$ |
26 | Springfield Thunderbirds (STL) | 2000 | 1000 | 35 | 15 | 25691 | 12677 | 91.75% | 90.55% | 1 | 2741 - 91.35% | 115,937$ | 1,623,118$ | 3000 | 100 | 1,845,569$ | 1,845,569$ | 2,243,732$ | 0$ | 1,750,471$ | 0 | 0 | 115,937$ | 2 | 31,697$ | 31,697$ |
27 | Syracuse Crunch (TBL) | 2000 | 1000 | 45 | 25 | 21514 | 9661 | 76.84% | 69.01% | 1 | 2227 - 74.23% | 108,157$ | 1,514,191$ | 3000 | 100 | 1,862,834$ | 1,862,834$ | 2,163,323$ | 0$ | 1,670,092$ | 0 | 0 | 108,156$ | 2 | 31,930$ | 31,930$ |
28 | Texas Stars (DAL) | 2000 | 1000 | 35 | 15 | 28193 | 14010 | 93.98% | 93.40% | 0 | 2814 - 93.78% | 118,893$ | 1,783,389$ | 3000 | 100 | 1,824,917$ | 1,824,917$ | 2,185,068$ | 0$ | 1,691,820$ | 0 | 0 | 0$ | 2 | 31,418$ | 31,418$ |
29 | Toronto Marlies (TOR) | 2000 | 1000 | 35 | 15 | 28257 | 13952 | 94.19% | 93.01% | 0 | 2814 - 93.80% | 119,029$ | 1,785,428$ | 3000 | 100 | 2,164,362$ | 2,164,362$ | 2,215,523$ | 0$ | 1,722,274$ | 0 | 0 | 0$ | 2 | 36,005$ | 36,005$ |
30 | Tucson Roadrunners (ARZ) | 2000 | 1000 | 35 | 15 | 27839 | 13960 | 92.80% | 93.07% | 0 | 2787 - 92.89% | 117,587$ | 1,763,810$ | 3000 | 100 | 2,572,708$ | 2,572,708$ | 3,031,179$ | 0$ | 2,537,918$ | 0 | 0 | 0$ | 2 | 41,523$ | 41,523$ |
31 | Utica Comets (NJD) | 2000 | 1000 | 35 | 15 | 28462 | 14128 | 94.87% | 94.19% | 0 | 2839 - 94.64% | 120,004$ | 1,800,055$ | 3000 | 100 | 1,885,999$ | 1,885,999$ | 2,335,761$ | 0$ | 1,842,500$ | 0 | 0 | 0$ | 2 | 32,243$ | 32,243$ |
32 | Wilkes-Barre/Scranton Penguins (PIT) | 2000 | 1000 | 35 | 15 | 27733 | 14207 | 92.44% | 94.71% | 0 | 2796 - 93.20% | 117,587$ | 1,763,803$ | 3000 | 100 | 1,481,334$ | 1,481,334$ | 1,868,851$ | 0$ | 1,375,657$ | 0 | 0 | 0$ | 2 | 26,775$ | 26,775$ |