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 | 59661 | 34935 | 76.49% | 89.58% | 0 | 2426 - 80.85% | 99,798$ | 3,892,123$ | 3000 | 100 | 2,423,835$ | 2,368,418$ | 2,289,180$ | 0$ | 2,289,180$ | 0 | 0 | 0$ | 0 | 19,405$ | 0$ |
2 | Boisbriand Armada (BOS) | 2000 | 1000 | 35 | 15 | 60010 | 34741 | 76.94% | 89.08% | 0 | 2430 - 80.98% | 100,153$ | 3,905,982$ | 3000 | 100 | 1,885,582$ | 1,885,582$ | 1,956,828$ | 0$ | 1,956,828$ | 0 | 0 | 0$ | 0 | 15,278$ | 0$ |
3 | Brampton Battalion (EDM) | 2000 | 1000 | 35 | 15 | 60254 | 34534 | 77.25% | 88.55% | 0 | 2430 - 81.02% | 100,361$ | 3,914,082$ | 3000 | 100 | 2,100,500$ | 2,100,500$ | 2,112,749$ | 0$ | 2,112,749$ | 0 | 0 | 0$ | 0 | 16,879$ | 0$ |
4 | Bridgeport Sound Tigers (NYI) | 2000 | 1000 | 35 | 15 | 60472 | 34501 | 77.53% | 88.46% | 0 | 2435 - 81.17% | 100,634$ | 3,924,712$ | 3000 | 100 | 2,005,424$ | 1,852,924$ | 2,072,351$ | 0$ | 2,072,351$ | 0 | 0 | 0$ | 0 | 16,136$ | 0$ |
5 | Calgary Hitman (CAL) | 2000 | 1000 | 35 | 15 | 62249 | 35176 | 79.81% | 90.19% | 0 | 2498 - 83.27% | 103,397$ | 4,032,470$ | 3000 | 100 | 2,197,083$ | 2,224,583$ | 2,270,557$ | 0$ | 2,270,557$ | 0 | 0 | 0$ | 0 | 17,633$ | 0$ |
6 | Chicago Wolves (QUE) | 2000 | 1000 | 25 | 10 | 75332 | 37968 | 96.58% | 97.35% | 0 | 2905 - 96.84% | 86,458$ | 3,371,843$ | 3000 | 100 | 2,927,833$ | 4,012,833$ | 2,236,815$ | 0$ | 2,236,815$ | 0 | 0 | 0$ | 0 | 23,342$ | 0$ |
7 | Chicoutimi Sagueneens (FLA) | 2000 | 1000 | 35 | 15 | 60164 | 34607 | 77.13% | 88.74% | 0 | 2430 - 81.00% | 100,283$ | 3,911,018$ | 3000 | 100 | 2,544,416$ | 2,501,516$ | 2,563,058$ | 0$ | 2,563,058$ | 0 | 0 | 0$ | 0 | 20,347$ | 0$ |
8 | Drummondville Voltigeurs (WAS) | 2000 | 1000 | 35 | 15 | 61030 | 34158 | 78.24% | 87.58% | 0 | 2441 - 81.36% | 101,183$ | 3,946,147$ | 3000 | 100 | 2,523,995$ | 2,496,828$ | 2,336,872$ | 0$ | 2,336,872$ | 0 | 0 | 0$ | 0 | 20,187$ | 0$ |
9 | Grand Rapids Griffins (DET) | 2000 | 1000 | 35 | 15 | 61865 | 34445 | 79.31% | 88.32% | 0 | 2469 - 82.32% | 102,464$ | 3,996,108$ | 3000 | 100 | 2,012,666$ | 2,012,666$ | 2,011,801$ | 0$ | 2,011,801$ | 0 | 0 | 0$ | 0 | 16,193$ | 0$ |
10 | Hamilton Bulldogs (CLB) | 2000 | 1000 | 35 | 22 | 61816 | 27407 | 79.25% | 70.27% | 0 | 2288 - 76.26% | 101,220$ | 3,947,570$ | 3000 | 100 | 1,198,528$ | 1,189,778$ | 1,591,418$ | 0$ | 1,591,418$ | 0 | 0 | 0$ | 0 | 9,930$ | 0$ |
11 | Hartford Wolf Pack (NYR) | 2000 | 1000 | 35 | 15 | 61652 | 34727 | 79.04% | 89.04% | 0 | 2471 - 82.38% | 102,341$ | 3,991,298$ | 3000 | 100 | 2,482,116$ | 2,493,534$ | 3,056,475$ | 0$ | 3,056,475$ | 0 | 0 | 0$ | 0 | 24,079$ | 0$ |
12 | Hershey Bears (TAM) | 2000 | 1000 | 35 | 15 | 60286 | 34398 | 77.29% | 88.20% | 0 | 2428 - 80.93% | 100,326$ | 3,912,708$ | 3000 | 100 | 1,370,584$ | 1,351,306$ | 1,784,729$ | 0$ | 1,784,729$ | 0 | 0 | 0$ | 0 | 11,176$ | 0$ |
13 | Lake Erie Monsters (CLF) | 2000 | 1000 | 30 | 10 | 73627 | 38173 | 94.39% | 97.88% | 0 | 2867 - 95.56% | 98,972$ | 3,859,903$ | 3000 | 100 | 2,116,917$ | 2,116,917$ | 2,171,335$ | 0$ | 2,171,335$ | 0 | 0 | 0$ | 0 | 17,007$ | 0$ |
14 | Laval Rockets (MTL) | 2000 | 1000 | 45 | 25 | 47355 | 19002 | 60.71% | 48.72% | 0 | 1701 - 56.72% | 99,564$ | 3,882,979$ | 3000 | 100 | 2,688,203$ | 2,708,203$ | 2,705,271$ | 0$ | 2,705,271$ | 0 | 0 | 0$ | 0 | 21,588$ | 0$ |
15 | London Knights (MON) | 2000 | 1000 | 35 | 15 | 58217 | 33853 | 74.64% | 86.80% | 0 | 2361 - 78.69% | 97,247$ | 3,792,630$ | 3000 | 100 | 2,569,001$ | 2,269,001$ | 2,269,278$ | 0$ | 2,269,278$ | 0 | 0 | 0$ | 0 | 20,539$ | 0$ |
16 | Lowell Devils (SEA) | 2000 | 1000 | 35 | 15 | 61773 | 35275 | 79.20% | 90.45% | 0 | 2488 - 82.95% | 102,817$ | 4,009,859$ | 3000 | 100 | 2,398,429$ | 2,398,429$ | 2,569,429$ | 0$ | 2,569,429$ | 0 | 0 | 0$ | 0 | 19,206$ | 0$ |
17 | Manchester Monarchs (NSH) | 2000 | 1000 | 30 | 12 | 75779 | 38123 | 97.15% | 97.75% | 0 | 2921 - 97.35% | 104,332$ | 4,068,962$ | 3000 | 100 | 2,604,664$ | 2,538,081$ | 2,543,613$ | 0$ | 2,543,613$ | 0 | 0 | 0$ | 0 | 20,818$ | 0$ |
18 | Manitoba Moose (VAN) | 2000 | 1000 | 35 | 15 | 59923 | 34325 | 76.82% | 88.01% | 0 | 2417 - 80.55% | 99,799$ | 3,892,148$ | 3000 | 100 | 2,246,292$ | 2,246,292$ | 2,186,466$ | 0$ | 2,186,466$ | 0 | 0 | 0$ | 0 | 18,018$ | 0$ |
19 | Milwaukee Admirals (WIN) | 2000 | 1000 | 24 | 10 | 76209 | 38271 | 97.70% | 98.13% | 0 | 2935 - 97.85% | 84,499$ | 3,295,471$ | 3000 | 100 | 1,990,166$ | 1,990,166$ | 1,908,452$ | 0$ | 1,908,452$ | 0 | 0 | 0$ | 0 | 16,017$ | 0$ |
20 | Peoria Riverman (STL) | 2000 | 1000 | 35 | 15 | 60484 | 34170 | 77.54% | 87.62% | 0 | 2427 - 80.90% | 100,460$ | 3,917,941$ | 3000 | 100 | 2,363,833$ | 2,343,833$ | 2,374,081$ | 0$ | 2,374,081$ | 0 | 0 | 0$ | 0 | 19,014$ | 0$ |
21 | Philadelphia Phantoms (PHI) | 2000 | 1000 | 35 | 15 | 60084 | 34473 | 77.03% | 88.39% | 0 | 2425 - 80.82% | 100,099$ | 3,903,851$ | 3000 | 100 | 2,593,163$ | 2,417,384$ | 2,582,551$ | 0$ | 2,582,551$ | 0 | 0 | 0$ | 0 | 20,728$ | 0$ |
22 | Portland Pirates (BUF) | 2000 | 1000 | 30 | 13 | 74693 | 37322 | 95.76% | 95.70% | 0 | 2872 - 95.74% | 104,146$ | 4,061,707$ | 3000 | 100 | 2,452,616$ | 2,465,116$ | 2,272,730$ | 0$ | 2,272,730$ | 0 | 0 | 0$ | 0 | 19,630$ | 0$ |
23 | Quebec Rempart (COL) | 2000 | 1000 | 35 | 15 | 60880 | 34652 | 78.05% | 88.85% | 0 | 2450 - 81.65% | 101,266$ | 3,949,364$ | 3000 | 100 | 2,780,418$ | 2,848,585$ | 2,672,462$ | 0$ | 2,672,462$ | 0 | 0 | 0$ | 0 | 22,191$ | 0$ |
24 | Rimouski Oceanic (HAR) | 2000 | 1000 | 50 | 30 | 49476 | 20916 | 63.43% | 53.63% | 0 | 1805 - 60.16% | 99,450$ | 3,878,531$ | 3000 | 100 | 2,198,492$ | 2,178,492$ | 2,293,108$ | 0$ | 2,293,108$ | 0 | 0 | 0$ | 0 | 17,644$ | 0$ |
25 | Rochester Americans (CHI) | 2000 | 1000 | 35 | 15 | 60694 | 34633 | 77.81% | 88.80% | 0 | 2444 - 81.48% | 101,006$ | 3,939,238$ | 3000 | 100 | 1,705,174$ | 1,722,674$ | 1,751,848$ | 0$ | 1,751,848$ | 0 | 0 | 0$ | 0 | 13,790$ | 0$ |
26 | Seattle Thunderbirds (PIT) | 2000 | 1000 | 35 | 15 | 60233 | 34315 | 77.22% | 87.99% | 0 | 2424 - 80.81% | 100,207$ | 3,908,090$ | 3000 | 100 | 1,839,333$ | 1,839,333$ | 1,878,606$ | 0$ | 1,878,606$ | 0 | 0 | 0$ | 0 | 14,839$ | 0$ |
27 | Sherbrooke Phoenix (VGK) | 2000 | 1000 | 40 | 20 | 51984 | 23347 | 66.65% | 59.86% | 0 | 1932 - 64.39% | 97,282$ | 3,793,989$ | 3000 | 100 | 2,147,416$ | 2,147,416$ | 1,882,134$ | 0$ | 1,882,134$ | 0 | 0 | 0$ | 0 | 17,245$ | 0$ |
28 | Texas Stars (DAL) | 2000 | 1000 | 35 | 15 | 60581 | 34122 | 77.67% | 87.49% | 0 | 2428 - 80.94% | 100,562$ | 3,921,922$ | 3000 | 100 | 2,023,750$ | 1,998,750$ | 2,041,983$ | 0$ | 2,041,983$ | 0 | 0 | 0$ | 0 | 16,279$ | 0$ |
29 | Toronto Marlies (TOR) | 2000 | 1000 | 25 | 12 | 76571 | 38063 | 98.17% | 97.60% | 0 | 2939 - 97.98% | 90,586$ | 3,532,838$ | 3000 | 100 | 1,890,750$ | 1,870,750$ | 1,970,748$ | 0$ | 1,970,748$ | 0 | 0 | 0$ | 0 | 15,240$ | 0$ |
30 | TroisRivieres Lions (LAK) | 2000 | 1000 | 35 | 15 | 60578 | 34230 | 77.66% | 87.77% | 0 | 2431 - 81.03% | 100,620$ | 3,924,184$ | 3000 | 100 | 2,385,417$ | 2,400,850$ | 2,370,921$ | 0$ | 2,370,921$ | 0 | 0 | 0$ | 0 | 19,105$ | 0$ |
31 | Victoriaville Tigres (MIW) | 2000 | 1000 | 35 | 15 | 60311 | 34677 | 77.32% | 88.92% | 0 | 2436 - 81.19% | 100,519$ | 3,920,248$ | 3000 | 100 | 1,688,001$ | 1,651,001$ | 1,901,249$ | 0$ | 1,901,249$ | 0 | 0 | 0$ | 0 | 13,813$ | 0$ |
32 | Worcester Sharks (SJS) | 2000 | 1000 | 35 | 15 | 60871 | 34864 | 78.04% | 89.39% | 0 | 2455 - 81.82% | 101,375$ | 3,953,632$ | 3000 | 100 | 2,505,958$ | 2,505,958$ | 2,334,022$ | 0$ | 2,334,022$ | 0 | 0 | 0$ | 0 | 20,047$ | 0$ |