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 | 54647 | 33882 | 78.07% | 96.81% | 6 | 2529 - 84.31% | 103,060$ | 3,607,104$ | 3000 | 100 | 2,249,699$ | 2,246,083$ | 1,888,278$ | 0$ | 1,888,278$ | 0 | 0 | 618,361$ | 37 | 18,478$ | 406,516$ |
2 | Boisbriand Armada (BOS) | 2000 | 1000 | 35 | 15 | 52655 | 32412 | 77.43% | 95.33% | 7 | 2502 - 83.40% | 102,070$ | 3,470,364$ | 3000 | 100 | 1,950,417$ | 1,904,750$ | 1,707,475$ | 0$ | 1,707,475$ | 0 | 0 | 714,487$ | 37 | 16,083$ | 353,826$ |
3 | Brampton Battalion (EDM) | 2000 | 1000 | 35 | 15 | 53140 | 32185 | 78.15% | 94.66% | 7 | 2510 - 83.65% | 102,664$ | 3,490,585$ | 3000 | 100 | 2,025,916$ | 1,906,583$ | 1,785,919$ | 0$ | 1,785,919$ | 0 | 0 | 718,650$ | 37 | 16,687$ | 367,114$ |
4 | Bridgeport Sound Tigers (NYI) | 2000 | 1000 | 35 | 15 | 54667 | 33201 | 78.10% | 94.86% | 6 | 2511 - 83.68% | 102,655$ | 3,592,925$ | 3000 | 100 | 2,295,126$ | 2,272,626$ | 1,760,697$ | 0$ | 1,760,697$ | 0 | 0 | 615,930$ | 37 | 18,841$ | 414,502$ |
5 | Buffalo Bisons (BUF) | 2000 | 1000 | 30 | 13 | 65402 | 32659 | 96.18% | 96.06% | 7 | 2884 - 96.14% | 104,590$ | 3,556,074$ | 3000 | 100 | 2,288,083$ | 2,076,972$ | 2,022,288$ | 0$ | 2,022,288$ | 0 | 0 | 732,133$ | 37 | 18,785$ | 413,270$ |
6 | Calgary Hitman (CAL) | 2000 | 1000 | 35 | 15 | 51905 | 32193 | 76.33% | 94.69% | 7 | 2473 - 82.45% | 100,775$ | 3,426,361$ | 3000 | 100 | 2,467,916$ | 2,259,416$ | 1,948,859$ | 0$ | 1,948,859$ | 0 | 0 | 705,427$ | 37 | 20,223$ | 444,906$ |
7 | Chicago Wolves (QUE) | 2000 | 1000 | 25 | 10 | 69149 | 34613 | 98.78% | 98.89% | 6 | 2965 - 98.82% | 88,330$ | 3,091,535$ | 3000 | 100 | 2,408,750$ | 2,081,250$ | 2,075,991$ | 0$ | 2,075,991$ | 0 | 0 | 529,977$ | 37 | 19,750$ | 434,500$ |
8 | Chicoutimi Sagueneens (FLA) | 2000 | 1000 | 35 | 15 | 53140 | 32510 | 78.15% | 95.62% | 7 | 2519 - 83.97% | 102,878$ | 3,497,847$ | 3000 | 100 | 2,344,166$ | 2,129,933$ | 1,865,946$ | 0$ | 1,865,946$ | 0 | 0 | 720,145$ | 37 | 19,233$ | 423,126$ |
9 | Drummondville Voltigeurs (WAS) | 2000 | 1000 | 35 | 15 | 54755 | 32951 | 78.22% | 94.15% | 6 | 2506 - 83.53% | 102,626$ | 3,591,927$ | 3000 | 100 | 2,523,110$ | 2,482,110$ | 2,184,981$ | 0$ | 2,184,981$ | 0 | 0 | 615,759$ | 37 | 20,745$ | 456,390$ |
10 | Grand Rapids Griffins (DET) | 2000 | 1000 | 35 | 15 | 53138 | 32277 | 78.14% | 94.93% | 7 | 2512 - 83.74% | 102,722$ | 3,492,532$ | 3000 | 100 | 2,251,083$ | 2,205,083$ | 1,785,336$ | 0$ | 1,785,336$ | 0 | 0 | 719,051$ | 37 | 18,489$ | 406,758$ |
11 | Hamilton Bulldogs (CLB) | 2000 | 1000 | 35 | 22 | 53541 | 19086 | 76.49% | 54.53% | 6 | 2075 - 69.17% | 97,651$ | 3,417,802$ | 3000 | 100 | 1,651,833$ | 1,589,750$ | 1,447,291$ | 0$ | 1,447,291$ | 0 | 0 | 585,909$ | 37 | 13,775$ | 303,050$ |
12 | Hartford Wolf Pack (NYR) | 2000 | 1000 | 35 | 15 | 52714 | 31990 | 77.52% | 94.09% | 7 | 2491 - 83.04% | 101,883$ | 3,464,007$ | 3000 | 100 | 1,730,700$ | 1,759,450$ | 1,453,190$ | 0$ | 1,453,190$ | 0 | 0 | 713,178$ | 37 | 14,346$ | 315,612$ |
13 | Hershey Bears (TAM) | 2000 | 1000 | 35 | 15 | 54722 | 32956 | 78.17% | 94.16% | 6 | 2505 - 83.50% | 102,580$ | 3,590,316$ | 3000 | 100 | 1,579,611$ | 1,571,111$ | 1,525,284$ | 0$ | 1,525,284$ | 0 | 0 | 615,483$ | 37 | 13,117$ | 288,574$ |
14 | Lake Erie Monsters (CLF) | 2000 | 1000 | 30 | 10 | 67401 | 34522 | 96.29% | 98.63% | 6 | 2912 - 97.07% | 100,777$ | 3,527,203$ | 3000 | 100 | 2,100,667$ | 2,094,667$ | 1,744,879$ | 0$ | 1,744,879$ | 0 | 0 | 604,663$ | 37 | 17,285$ | 380,270$ |
15 | Laval Rockets (MTL) | 2000 | 1000 | 45 | 25 | 42949 | 17452 | 61.36% | 49.86% | 6 | 1726 - 57.52% | 100,852$ | 3,529,818$ | 3000 | 100 | 2,223,916$ | 2,207,916$ | 2,006,273$ | 0$ | 2,006,273$ | 0 | 0 | 605,112$ | 37 | 18,271$ | 401,962$ |
16 | London Knights (MON) | 2000 | 1000 | 35 | 15 | 51682 | 31759 | 76.00% | 93.41% | 7 | 2454 - 81.80% | 100,148$ | 3,405,032$ | 3000 | 100 | 1,109,251$ | 1,109,251$ | 957,025$ | 0$ | 957,025$ | 0 | 0 | 701,036$ | 37 | 9,455$ | 208,010$ |
17 | Lowell Devils (SEA) | 2000 | 1000 | 35 | 15 | 54859 | 33272 | 78.37% | 95.06% | 6 | 2518 - 83.93% | 102,986$ | 3,604,526$ | 3000 | 100 | 2,648,610$ | 2,648,610$ | 2,003,052$ | 0$ | 2,003,052$ | 0 | 0 | 617,919$ | 37 | 21,669$ | 476,718$ |
18 | Manchester Monarchs (NSH) | 2000 | 1000 | 30 | 12 | 65562 | 33259 | 96.41% | 97.82% | 7 | 2907 - 96.88% | 103,685$ | 3,525,295$ | 3000 | 100 | 2,254,332$ | 2,212,999$ | 1,798,103$ | 0$ | 1,798,103$ | 0 | 0 | 725,796$ | 37 | 18,515$ | 407,330$ |
19 | Manitoba Moose (VAN) | 2000 | 1000 | 35 | 15 | 53960 | 32538 | 79.35% | 95.70% | 7 | 2544 - 84.80% | 104,154$ | 3,541,242$ | 3000 | 100 | 2,000,167$ | 1,989,417$ | 1,657,501$ | 0$ | 1,657,501$ | 0 | 0 | 729,079$ | 37 | 16,481$ | 362,582$ |
20 | Milwaukee Admirals (WIN) | 2000 | 1000 | 24 | 10 | 66649 | 33371 | 98.01% | 98.15% | 7 | 2942 - 98.06% | 84,723$ | 2,880,597$ | 3000 | 100 | 2,535,049$ | 2,145,249$ | 1,487,656$ | 0$ | 1,487,656$ | 0 | 0 | 593,064$ | 37 | 20,840$ | 458,480$ |
21 | Peoria Riverman (STL) | 2000 | 1000 | 35 | 15 | 52422 | 32410 | 77.09% | 95.32% | 7 | 2495 - 83.17% | 101,711$ | 3,458,170$ | 3000 | 100 | 1,807,866$ | 1,770,866$ | 1,529,750$ | 0$ | 1,529,750$ | 0 | 0 | 711,976$ | 37 | 15,023$ | 330,506$ |
22 | Philadelphia Phantoms (PHI) | 2000 | 1000 | 35 | 15 | 52077 | 32287 | 76.58% | 94.96% | 7 | 2481 - 82.71% | 101,101$ | 3,437,432$ | 3000 | 100 | 1,996,166$ | 1,875,250$ | 1,673,747$ | 0$ | 1,673,747$ | 0 | 0 | 707,707$ | 37 | 16,529$ | 363,638$ |
23 | Quebec Rempart (COL) | 2000 | 1000 | 35 | 15 | 54513 | 33599 | 77.88% | 96.00% | 6 | 2517 - 83.92% | 102,680$ | 3,593,791$ | 3000 | 100 | 1,896,584$ | 1,864,584$ | 1,557,931$ | 0$ | 1,557,931$ | 0 | 0 | 616,078$ | 37 | 15,653$ | 344,366$ |
24 | Rimouski Oceanic (HAR) | 2000 | 1000 | 50 | 30 | 39058 | 14627 | 55.80% | 41.79% | 6 | 1534 - 51.13% | 101,818$ | 3,563,645$ | 3000 | 100 | 1,979,908$ | 1,961,158$ | 1,707,533$ | 0$ | 1,707,533$ | 0 | 0 | 610,911$ | 37 | 16,399$ | 360,778$ |
25 | Rochester Americans (CHI) | 2000 | 1000 | 35 | 15 | 52888 | 32304 | 77.78% | 95.01% | 7 | 2506 - 83.52% | 102,356$ | 3,480,105$ | 3000 | 100 | 2,201,803$ | 2,128,033$ | 1,990,217$ | 0$ | 1,990,217$ | 0 | 0 | 716,492$ | 37 | 18,174$ | 399,828$ |
26 | Seattle Thunderbirds (PIT) | 2000 | 1000 | 35 | 15 | 52174 | 32271 | 76.73% | 94.91% | 7 | 2484 - 82.79% | 101,239$ | 3,442,132$ | 3000 | 100 | 1,452,083$ | 1,404,250$ | 1,297,907$ | 0$ | 1,232,307$ | 0 | 0 | 708,674$ | 37 | 12,097$ | 266,134$ |
27 | Sherbrooke Phoenix (VGK) | 2000 | 1000 | 40 | 20 | 47935 | 21192 | 70.49% | 62.33% | 7 | 2033 - 67.77% | 102,601$ | 3,488,447$ | 3000 | 100 | 1,885,667$ | 1,869,334$ | 1,564,994$ | 0$ | 1,564,994$ | 0 | 0 | 718,210$ | 37 | 15,565$ | 342,430$ |
28 | Texas Stars (DAL) | 2000 | 1000 | 35 | 15 | 53449 | 33059 | 76.36% | 94.45% | 6 | 2472 - 82.39% | 100,749$ | 3,526,232$ | 3000 | 100 | 1,648,950$ | 1,618,250$ | 1,460,968$ | 0$ | 1,460,968$ | 0 | 0 | 604,497$ | 37 | 13,992$ | 307,824$ |
29 | Toronto Marlies (TOR) | 2000 | 1000 | 25 | 12 | 66574 | 32776 | 97.90% | 96.40% | 7 | 2922 - 97.40% | 90,174$ | 3,065,916$ | 3000 | 100 | 2,012,958$ | 1,975,375$ | 2,200,353$ | 0$ | 2,200,353$ | 0 | 0 | 631,218$ | 37 | 22,504$ | 495,088$ |
30 | TroisRivieres Lions (LAK) | 2000 | 1000 | 35 | 15 | 51377 | 32034 | 75.55% | 94.22% | 7 | 2453 - 81.78% | 99,861$ | 3,395,270$ | 3000 | 100 | 2,323,167$ | 1,836,708$ | 1,983,585$ | 0$ | 1,983,585$ | 0 | 0 | 699,026$ | 37 | 19,201$ | 422,422$ |
31 | Victoriaville Tigres (MIW) | 2000 | 1000 | 35 | 15 | 53093 | 32474 | 78.08% | 95.51% | 7 | 2517 - 83.89% | 102,782$ | 3,494,594$ | 3000 | 100 | 2,156,001$ | 2,116,001$ | 1,872,934$ | 0$ | 1,872,934$ | 0 | 0 | 719,475$ | 37 | 17,888$ | 393,536$ |
32 | Worcester Sharks (SJS) | 2000 | 1000 | 35 | 15 | 54202 | 33019 | 77.43% | 94.34% | 6 | 2492 - 83.07% | 101,846$ | 3,564,611$ | 3000 | 100 | 2,359,999$ | 2,343,666$ | 1,877,429$ | 0$ | 1,877,429$ | 0 | 0 | 611,076$ | 37 | 19,440$ | 427,680$ |