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 | Binghampton Senators (OTT) | 2000 | 1000 | 35 | 15 | 31168 | 16350 | 74.21% | 77.86% | 20 | 2263 - 75.43% | 94,802$ | 1,990,835$ | 3000 | 100 | 2,520,851$ | 2,334,518$ | 1,276,305$ | 0$ | 1,276,305$ | 0 | 0 | 1,896,033$ | 80 | 17,799$ | 1,334,925$ |
2 | Boisbriand Armada (BOS) | 2000 | 1000 | 35 | 15 | 32086 | 16339 | 76.40% | 77.80% | 20 | 2306 - 76.87% | 97,070$ | 2,038,461$ | 3000 | 100 | 1,820,452$ | 1,823,452$ | 923,380$ | 0$ | 923,380$ | 0 | 0 | 1,941,391$ | 80 | 13,038$ | 977,850$ |
3 | Brampton Battalion (EDM) | 2000 | 1000 | 35 | 15 | 31936 | 16609 | 76.04% | 79.09% | 20 | 2312 - 77.06% | 96,985$ | 2,036,675$ | 3000 | 100 | 1,992,250$ | 1,992,250$ | 990,955$ | 0$ | 990,955$ | 0 | 0 | 1,939,690$ | 80 | 14,257$ | 1,069,275$ |
4 | Bridgeport Sound Tigers (NYI) | 2000 | 1000 | 35 | 15 | 32752 | 16788 | 77.98% | 79.94% | 20 | 2359 - 78.63% | 99,201$ | 2,083,230$ | 3000 | 100 | 1,765,165$ | 1,714,665$ | 888,266$ | 0$ | 888,266$ | 0 | 0 | 1,984,029$ | 80 | 12,587$ | 944,025$ |
5 | Calgary Hitman (CAL) | 2000 | 1000 | 35 | 15 | 32399 | 16437 | 77.14% | 78.27% | 20 | 2326 - 77.52% | 97,951$ | 2,056,973$ | 3000 | 100 | 2,189,922$ | 2,189,922$ | 1,086,376$ | 0$ | 1,086,376$ | 0 | 0 | 1,959,022$ | 80 | 15,517$ | 1,163,775$ |
6 | Chicago Wolves (QUE) | 2000 | 1000 | 25 | 10 | 39284 | 19677 | 98.21% | 98.39% | 21 | 2948 - 98.27% | 87,826$ | 1,756,516$ | 3000 | 100 | 1,580,834$ | 1,555,834$ | 819,357$ | 0$ | 819,357$ | 0 | 0 | 1,844,342$ | 80 | 11,316$ | 848,700$ |
7 | Chicoutimi Sagueneens (FLA) | 2000 | 1000 | 35 | 15 | 31395 | 15605 | 78.49% | 78.03% | 21 | 2350 - 78.33% | 99,301$ | 1,986,021$ | 3000 | 100 | 2,282,717$ | 2,232,717$ | 1,063,819$ | 0$ | 1,063,819$ | 0 | 0 | 2,085,322$ | 80 | 16,198$ | 1,214,850$ |
8 | Drummondville Voltigeurs (WAS) | 2000 | 1000 | 35 | 15 | 30316 | 15609 | 75.79% | 78.05% | 21 | 2296 - 76.54% | 96,492$ | 1,929,841$ | 3000 | 100 | 1,853,125$ | 1,825,958$ | 922,406$ | 0$ | 922,406$ | 0 | 0 | 2,026,333$ | 80 | 13,194$ | 989,550$ |
9 | Grand Rapids Griffins (DET) | 2000 | 1000 | 35 | 15 | 30309 | 15774 | 75.77% | 78.87% | 21 | 2304 - 76.81% | 96,658$ | 1,933,164$ | 3000 | 100 | 2,134,367$ | 2,134,367$ | 1,031,777$ | 0$ | 1,031,777$ | 0 | 0 | 2,029,822$ | 80 | 15,134$ | 1,135,050$ |
10 | Hartford Wolf Pack (NYR) | 2000 | 1000 | 35 | 15 | 32718 | 16455 | 77.90% | 78.36% | 20 | 2342 - 78.05% | 98,763$ | 2,074,013$ | 3000 | 100 | 1,896,917$ | 1,819,085$ | 1,192,661$ | 0$ | 1,192,661$ | 0 | 0 | 1,975,250$ | 80 | 17,220$ | 1,291,500$ |
11 | Hershey Bears (TAM) | 2000 | 1000 | 35 | 15 | 32006 | 16180 | 76.20% | 77.05% | 20 | 2295 - 76.49% | 96,702$ | 2,030,735$ | 3000 | 100 | 1,665,472$ | 1,595,472$ | 1,068,961$ | 0$ | 1,068,961$ | 0 | 0 | 1,934,033$ | 80 | 15,279$ | 1,145,925$ |
12 | Lake Erie Monsters (CLF) | 2000 | 1000 | 30 | 10 | 37701 | 19762 | 94.25% | 98.81% | 21 | 2873 - 95.77% | 98,984$ | 1,979,689$ | 3000 | 100 | 1,473,117$ | 1,360,451$ | 753,041$ | 0$ | 753,041$ | 0 | 0 | 2,078,673$ | 80 | 10,660$ | 799,500$ |
13 | Las Vegas Wranglers (LAK) | 2000 | 1000 | 35 | 15 | 30195 | 15860 | 75.49% | 79.30% | 21 | 2303 - 76.76% | 96,457$ | 1,929,139$ | 3000 | 100 | 2,086,949$ | 2,079,449$ | 1,072,158$ | 0$ | 1,072,158$ | 0 | 0 | 2,025,596$ | 80 | 14,944$ | 1,120,800$ |
14 | Laval Rockets (MTL) | 2000 | 1000 | 45 | 25 | 24338 | 9223 | 60.85% | 46.12% | 21 | 1678 - 55.94% | 98,771$ | 1,975,417$ | 3000 | 100 | 2,143,363$ | 2,119,280$ | 1,052,889$ | 0$ | 1,052,889$ | 0 | 0 | 2,074,188$ | 80 | 15,299$ | 1,147,425$ |
15 | London Knights (MON) | 2000 | 1000 | 35 | 15 | 30129 | 15394 | 75.32% | 76.97% | 21 | 2276 - 75.87% | 95,764$ | 1,915,283$ | 3000 | 100 | 1,174,867$ | 1,174,867$ | 652,144$ | 0$ | 652,144$ | 0 | 0 | 2,011,047$ | 80 | 8,516$ | 638,700$ |
16 | Lowell Devils (SEA) | 2000 | 1000 | 35 | 15 | 32542 | 16682 | 77.48% | 79.44% | 20 | 2344 - 78.13% | 98,567$ | 2,069,909$ | 3000 | 100 | 2,054,557$ | 2,085,969$ | 1,055,330$ | 0$ | 1,055,330$ | 0 | 0 | 1,971,342$ | 80 | 14,583$ | 1,093,725$ |
17 | Manchester Monarchs (NSH) | 2000 | 1000 | 30 | 12 | 37812 | 19077 | 94.53% | 95.39% | 21 | 2844 - 94.82% | 102,292$ | 2,045,841$ | 3000 | 100 | 1,814,990$ | 1,804,990$ | 968,443$ | 0$ | 968,443$ | 0 | 0 | 2,148,133$ | 80 | 13,345$ | 1,000,875$ |
18 | Manitoba Moose (VAN) | 2000 | 1000 | 35 | 15 | 31925 | 16341 | 76.01% | 77.81% | 20 | 2298 - 76.61% | 96,672$ | 2,030,111$ | 3000 | 100 | 2,046,258$ | 2,117,925$ | 1,104,123$ | 0$ | 1,104,123$ | 0 | 0 | 1,933,439$ | 80 | 14,526$ | 1,089,450$ |
19 | Milwaukee Admirals (WIN) | 2000 | 1000 | 24 | 10 | 39669 | 19712 | 99.17% | 98.56% | 21 | 2969 - 98.97% | 85,614$ | 1,712,272$ | 3000 | 100 | 1,590,161$ | 1,542,749$ | 781,747$ | 0$ | 781,747$ | 0 | 0 | 1,797,886$ | 80 | 11,380$ | 853,500$ |
20 | Peoria Riverman (STL) | 2000 | 1000 | 35 | 15 | 31316 | 15736 | 78.29% | 78.68% | 21 | 2353 - 78.42% | 99,242$ | 1,984,830$ | 3000 | 100 | 2,379,000$ | 2,374,000$ | 1,196,086$ | 0$ | 1,196,086$ | 0 | 0 | 2,084,072$ | 80 | 17,097$ | 1,282,275$ |
21 | Philadelphia Phantoms (PHI) | 2000 | 1000 | 35 | 15 | 30801 | 15623 | 77.00% | 78.12% | 21 | 2321 - 77.37% | 97,772$ | 1,955,447$ | 3000 | 100 | 2,088,748$ | 2,525,332$ | 1,030,713$ | 0$ | 1,030,713$ | 0 | 0 | 2,053,219$ | 80 | 14,819$ | 1,111,425$ |
22 | Portland Pirates (BUF) | 2000 | 1000 | 30 | 13 | 38630 | 19063 | 96.58% | 95.32% | 21 | 2885 - 96.16% | 104,801$ | 2,096,013$ | 3000 | 100 | 2,035,541$ | 2,017,953$ | 959,847$ | 0$ | 959,847$ | 0 | 0 | 2,200,814$ | 80 | 14,452$ | 1,083,900$ |
23 | Quebec Rempart (COL) | 2000 | 1000 | 35 | 15 | 31456 | 15855 | 78.64% | 79.28% | 21 | 2366 - 78.85% | 99,739$ | 1,994,789$ | 3000 | 100 | 2,770,601$ | 2,535,268$ | 1,149,046$ | 0$ | 1,149,046$ | 0 | 0 | 2,094,528$ | 80 | 19,521$ | 1,464,075$ |
24 | Rimouski Oceanic (ANA) | 2000 | 1000 | 35 | 15 | 30349 | 15818 | 75.87% | 79.09% | 21 | 2308 - 76.95% | 96,812$ | 1,936,235$ | 3000 | 100 | 1,801,018$ | 1,679,351$ | 959,553$ | 0$ | 959,553$ | 0 | 0 | 2,033,047$ | 80 | 12,835$ | 962,625$ |
25 | Rochester Americans (CHI) | 2000 | 1000 | 35 | 15 | 30966 | 15569 | 77.42% | 77.85% | 21 | 2327 - 77.56% | 98,142$ | 1,962,844$ | 3000 | 100 | 2,053,660$ | 2,069,993$ | 1,117,444$ | 0$ | 1,117,444$ | 0 | 0 | 2,060,986$ | 80 | 18,715$ | 1,403,625$ |
26 | Seattle Thunderbirds (PIT) | 2000 | 1000 | 35 | 15 | 30785 | 15676 | 76.96% | 78.38% | 21 | 2323 - 77.44% | 97,790$ | 1,955,798$ | 3000 | 100 | 1,627,750$ | 1,597,750$ | 851,234$ | 0$ | 851,234$ | 0 | 0 | 2,053,588$ | 80 | 11,640$ | 873,000$ |
27 | Sherbrooke Phoenix (VGK) | 2000 | 1000 | 40 | 20 | 26891 | 11751 | 67.23% | 58.76% | 21 | 1932 - 64.40% | 97,644$ | 1,952,882$ | 3000 | 100 | 1,625,167$ | 1,566,917$ | 871,500$ | 0$ | 871,500$ | 0 | 0 | 2,050,526$ | 80 | 11,622$ | 871,650$ |
28 | Texas Stars (DAL) | 2000 | 1000 | 35 | 15 | 30368 | 15171 | 75.92% | 75.86% | 21 | 2277 - 75.90% | 96,138$ | 1,922,764$ | 3000 | 100 | 1,733,834$ | 1,738,917$ | 854,066$ | 0$ | 854,066$ | 0 | 0 | 2,018,902$ | 80 | 12,371$ | 927,825$ |
29 | Toronto Marlies (TOR) | 2000 | 1000 | 25 | 12 | 41224 | 20327 | 98.15% | 96.80% | 20 | 2931 - 97.70% | 90,430$ | 1,899,039$ | 3000 | 100 | 1,642,080$ | 2,272,080$ | 853,993$ | 0$ | 853,993$ | 0 | 0 | 1,808,609$ | 80 | 11,825$ | 886,875$ |
30 | Victoriaville Tigres (MIW) | 2000 | 1000 | 35 | 15 | 32648 | 16625 | 77.73% | 79.17% | 20 | 2346 - 78.21% | 98,770$ | 2,074,163$ | 3000 | 100 | 1,921,583$ | 1,921,583$ | 983,460$ | 0$ | 983,460$ | 0 | 0 | 1,975,393$ | 80 | 13,666$ | 1,024,950$ |
31 | Worcester Sharks (SJS) | 2000 | 1000 | 35 | 15 | 30656 | 15284 | 76.64% | 76.42% | 21 | 2297 - 76.57% | 97,015$ | 1,940,308$ | 3000 | 100 | 1,980,833$ | 1,980,833$ | 1,048,934$ | 0$ | 1,048,934$ | 0 | 0 | 2,037,323$ | 80 | 14,075$ | 1,055,625$ |