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 | 64385 | 39780 | 78.52% | 97.02% | 0 | 2541 - 84.69% | 103,580$ | 4,246,761$ | 3000 | 100 | 2,164,949$ | 2,161,333$ | 2,293,354$ | 0$ | 2,293,354$ | 0 | 0 | 0$ | 2 | 17,800$ | 0$ |
2 | Boisbriand Armada (BOS) | 2000 | 1000 | 35 | 15 | 63699 | 39243 | 77.68% | 95.71% | 0 | 2511 - 83.69% | 102,414$ | 4,198,981$ | 3000 | 100 | 1,937,417$ | 1,926,417$ | 2,045,740$ | 0$ | 2,045,740$ | 0 | 0 | 0$ | 2 | 15,979$ | 0$ |
3 | Brampton Battalion (EDM) | 2000 | 1000 | 35 | 15 | 63816 | 38842 | 77.82% | 94.74% | 0 | 2504 - 83.46% | 102,344$ | 4,196,121$ | 3000 | 100 | 2,025,916$ | 1,906,583$ | 2,152,413$ | 0$ | 2,152,413$ | 0 | 0 | 0$ | 2 | 16,687$ | 0$ |
4 | Bridgeport Sound Tigers (NYI) | 2000 | 1000 | 35 | 15 | 64296 | 39114 | 78.41% | 95.40% | 0 | 2522 - 84.07% | 103,103$ | 4,227,234$ | 3000 | 100 | 2,295,126$ | 2,272,626$ | 2,175,199$ | 0$ | 2,175,199$ | 0 | 0 | 0$ | 2 | 18,841$ | 0$ |
5 | Buffalo Bisons (BUF) | 2000 | 1000 | 30 | 13 | 79146 | 39207 | 96.52% | 95.63% | 0 | 2887 - 96.22% | 104,811$ | 4,297,265$ | 3000 | 100 | 2,209,333$ | 1,998,222$ | 2,421,688$ | 0$ | 2,421,688$ | 0 | 0 | 0$ | 2 | 18,155$ | 0$ |
6 | Calgary Hitman (CAL) | 2000 | 1000 | 35 | 15 | 63132 | 38881 | 76.99% | 94.83% | 0 | 2488 - 82.94% | 101,496$ | 4,161,327$ | 3000 | 100 | 2,467,916$ | 2,514,416$ | 2,400,965$ | 0$ | 2,400,965$ | 0 | 0 | 0$ | 2 | 20,223$ | 0$ |
7 | Chicago Wolves (QUE) | 2000 | 1000 | 25 | 10 | 81118 | 40613 | 98.92% | 99.06% | 0 | 2969 - 98.97% | 88,458$ | 3,626,780$ | 3000 | 100 | 2,452,250$ | 2,174,583$ | 2,533,031$ | 0$ | 2,533,031$ | 0 | 0 | 0$ | 2 | 20,098$ | 0$ |
8 | Chicoutimi Sagueneens (FLA) | 2000 | 1000 | 35 | 15 | 64305 | 39164 | 78.42% | 95.52% | 0 | 2524 - 84.12% | 103,142$ | 4,228,818$ | 3000 | 100 | 2,344,166$ | 2,129,933$ | 2,275,532$ | 0$ | 2,275,532$ | 0 | 0 | 0$ | 2 | 19,233$ | 0$ |
9 | Drummondville Voltigeurs (WAS) | 2000 | 1000 | 35 | 15 | 64439 | 38648 | 78.58% | 94.26% | 0 | 2514 - 83.81% | 103,031$ | 4,224,276$ | 3000 | 100 | 2,600,610$ | 2,559,610$ | 2,639,891$ | 0$ | 2,639,891$ | 0 | 0 | 0$ | 2 | 21,365$ | 0$ |
10 | Grand Rapids Griffins (DET) | 2000 | 1000 | 35 | 15 | 63889 | 38766 | 77.91% | 94.55% | 0 | 2504 - 83.46% | 102,396$ | 4,198,226$ | 3000 | 100 | 2,251,083$ | 2,205,083$ | 2,191,484$ | 0$ | 2,191,484$ | 0 | 0 | 0$ | 2 | 18,489$ | 0$ |
11 | Hamilton Bulldogs (CLB) | 2000 | 1000 | 35 | 22 | 62650 | 22206 | 76.40% | 54.16% | 0 | 2070 - 68.99% | 97,442$ | 3,995,109$ | 3000 | 100 | 1,651,833$ | 1,589,750$ | 1,750,341$ | 0$ | 1,750,341$ | 0 | 0 | 0$ | 2 | 13,775$ | 0$ |
12 | Hartford Wolf Pack (NYR) | 2000 | 1000 | 35 | 15 | 63209 | 38705 | 77.08% | 94.40% | 0 | 2486 - 82.86% | 101,498$ | 4,161,402$ | 3000 | 100 | 1,730,700$ | 1,759,450$ | 1,768,192$ | 0$ | 1,768,192$ | 0 | 0 | 0$ | 2 | 14,346$ | 0$ |
13 | Hershey Bears (TAM) | 2000 | 1000 | 35 | 15 | 64287 | 38818 | 78.40% | 94.68% | 0 | 2515 - 83.83% | 102,930$ | 4,220,147$ | 3000 | 100 | 1,579,611$ | 1,571,111$ | 1,813,858$ | 0$ | 1,813,858$ | 0 | 0 | 0$ | 2 | 13,117$ | 0$ |
14 | Lake Erie Monsters (CLF) | 2000 | 1000 | 30 | 10 | 78667 | 40449 | 95.94% | 98.66% | 0 | 2905 - 96.84% | 100,466$ | 4,119,106$ | 3000 | 100 | 2,111,000$ | 2,111,000$ | 2,126,201$ | 0$ | 2,126,201$ | 0 | 0 | 0$ | 2 | 17,368$ | 0$ |
15 | Laval Rockets (MTL) | 2000 | 1000 | 45 | 25 | 50672 | 20430 | 61.80% | 49.83% | 0 | 1734 - 57.81% | 101,429$ | 4,158,575$ | 3000 | 100 | 2,465,083$ | 2,269,083$ | 2,446,835$ | 0$ | 2,446,835$ | 0 | 0 | 0$ | 2 | 20,201$ | 0$ |
16 | London Knights (MON) | 2000 | 1000 | 35 | 15 | 62050 | 38259 | 75.67% | 93.31% | 0 | 2447 - 81.55% | 99,780$ | 4,090,998$ | 3000 | 100 | 1,109,251$ | 1,109,251$ | 1,163,195$ | 0$ | 1,163,195$ | 0 | 0 | 0$ | 2 | 9,455$ | 0$ |
17 | Lowell Devils (SEA) | 2000 | 1000 | 35 | 15 | 64445 | 39040 | 78.59% | 95.22% | 0 | 2524 - 84.13% | 103,252$ | 4,233,351$ | 3000 | 100 | 2,724,860$ | 2,718,610$ | 2,491,360$ | 0$ | 2,491,360$ | 0 | 0 | 0$ | 2 | 22,279$ | 0$ |
18 | Manchester Monarchs (NSH) | 2000 | 1000 | 30 | 12 | 79428 | 40235 | 96.86% | 98.13% | 0 | 2919 - 97.29% | 104,142$ | 4,269,836$ | 3000 | 100 | 2,167,999$ | 2,126,666$ | 2,205,433$ | 0$ | 2,205,433$ | 0 | 0 | 0$ | 2 | 17,824$ | 0$ |
19 | Manitoba Moose (VAN) | 2000 | 1000 | 35 | 15 | 65091 | 39270 | 79.38% | 95.78% | 0 | 2545 - 84.85% | 104,200$ | 4,272,184$ | 3000 | 100 | 2,087,167$ | 2,076,417$ | 2,022,767$ | 0$ | 2,022,767$ | 0 | 0 | 0$ | 2 | 17,177$ | 0$ |
20 | Milwaukee Admirals (WIN) | 2000 | 1000 | 24 | 10 | 80439 | 40097 | 98.10% | 97.80% | 0 | 2940 - 98.00% | 84,730$ | 3,473,944$ | 3000 | 100 | 2,426,049$ | 2,050,582$ | 1,939,604$ | 0$ | 1,939,604$ | 0 | 0 | 0$ | 2 | 19,968$ | 0$ |
21 | Peoria Riverman (STL) | 2000 | 1000 | 35 | 15 | 63466 | 39092 | 77.40% | 95.35% | 0 | 2501 - 83.38% | 102,036$ | 4,183,458$ | 3000 | 100 | 1,727,333$ | 1,690,333$ | 1,857,670$ | 0$ | 1,857,670$ | 0 | 0 | 0$ | 2 | 14,379$ | 0$ |
22 | Philadelphia Phantoms (PHI) | 2000 | 1000 | 35 | 15 | 63001 | 38983 | 76.83% | 95.08% | 0 | 2487 - 82.91% | 101,385$ | 4,156,774$ | 3000 | 100 | 1,996,166$ | 1,875,250$ | 2,034,849$ | 0$ | 2,034,849$ | 0 | 0 | 0$ | 2 | 16,529$ | 0$ |
23 | Quebec Rempart (COL) | 2000 | 1000 | 35 | 15 | 64222 | 39391 | 78.32% | 96.08% | 0 | 2527 - 84.24% | 103,160$ | 4,229,566$ | 3000 | 100 | 1,800,334$ | 1,802,084$ | 1,901,527$ | 0$ | 1,901,527$ | 0 | 0 | 0$ | 2 | 14,883$ | 0$ |
24 | Rimouski Oceanic (HAR) | 2000 | 1000 | 50 | 30 | 45518 | 17085 | 55.51% | 41.67% | 0 | 1527 - 50.90% | 101,336$ | 4,154,788$ | 3000 | 100 | 1,979,908$ | 1,961,158$ | 2,064,891$ | 0$ | 2,064,891$ | 0 | 0 | 0$ | 2 | 16,399$ | 0$ |
25 | Rochester Americans (CHI) | 2000 | 1000 | 35 | 15 | 63741 | 38835 | 77.73% | 94.72% | 0 | 2502 - 83.40% | 102,245$ | 4,192,056$ | 3000 | 100 | 2,201,803$ | 2,128,033$ | 2,378,265$ | 0$ | 2,378,265$ | 0 | 0 | 0$ | 2 | 18,174$ | 0$ |
26 | Seattle Thunderbirds (PIT) | 2000 | 1000 | 35 | 15 | 62511 | 38669 | 76.23% | 94.31% | 0 | 2468 - 82.26% | 100,590$ | 4,124,202$ | 3000 | 100 | 1,452,083$ | 1,404,250$ | 1,554,941$ | 0$ | 1,489,341$ | 0 | 0 | 0$ | 2 | 12,097$ | 0$ |
27 | Sherbrooke Phoenix (VGK) | 2000 | 1000 | 40 | 20 | 57957 | 25673 | 70.68% | 62.62% | 0 | 2040 - 67.99% | 102,910$ | 4,219,292$ | 3000 | 100 | 1,885,667$ | 1,869,334$ | 1,902,904$ | 0$ | 1,902,904$ | 0 | 0 | 0$ | 2 | 15,565$ | 0$ |
28 | Texas Stars (DAL) | 2000 | 1000 | 35 | 15 | 62757 | 38750 | 76.53% | 94.51% | 0 | 2476 - 82.53% | 100,947$ | 4,138,837$ | 3000 | 100 | 1,648,950$ | 1,618,250$ | 1,766,322$ | 0$ | 1,766,322$ | 0 | 0 | 0$ | 2 | 13,992$ | 0$ |
29 | Toronto Marlies (TOR) | 2000 | 1000 | 25 | 12 | 80224 | 39689 | 97.83% | 96.80% | 0 | 2925 - 97.49% | 90,195$ | 3,697,984$ | 3000 | 100 | 2,012,958$ | 1,975,375$ | 2,695,491$ | 0$ | 2,695,491$ | 0 | 0 | 0$ | 2 | 22,504$ | 0$ |
30 | TroisRivieres Lions (LAK) | 2000 | 1000 | 35 | 15 | 61813 | 38677 | 75.38% | 94.33% | 0 | 2451 - 81.70% | 99,707$ | 4,087,977$ | 3000 | 100 | 2,323,167$ | 1,836,708$ | 2,406,007$ | 0$ | 2,406,007$ | 0 | 0 | 0$ | 2 | 19,201$ | 0$ |
31 | Victoriaville Tigres (MIW) | 2000 | 1000 | 35 | 15 | 64019 | 39096 | 78.07% | 95.36% | 0 | 2515 - 83.83% | 102,741$ | 4,212,387$ | 3000 | 100 | 2,156,001$ | 2,116,001$ | 2,258,610$ | 0$ | 2,258,610$ | 0 | 0 | 0$ | 2 | 17,888$ | 0$ |
32 | Worcester Sharks (SJS) | 2000 | 1000 | 35 | 15 | 63400 | 38763 | 77.32% | 94.54% | 0 | 2492 - 83.06% | 101,772$ | 4,172,666$ | 3000 | 100 | 2,282,499$ | 2,266,166$ | 2,301,845$ | 0$ | 2,301,845$ | 0 | 0 | 0$ | 2 | 18,820$ | 0$ |