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 | 68544 | 34528 | 95.20% | 95.91% | 0 | 2863 - 95.44% | 95,612$ | 3,442,014$ | 3000 | 100 | 1,873,662$ | 1,553,624$ | 2,157,742$ | 9,560$ | 2,157,742$ | 0 | 0 | 0$ | 0 | 9,560$ | 0$ |
2 | Bakersfield Condors (EDM) | 2000 | 1000 | 32 | 13 | 69134 | 35280 | 96.02% | 98.00% | 0 | 2900 - 96.68% | 87,547$ | 3,151,693$ | 3000 | 100 | 332,500$ | 265,202$ | 402,729$ | 1,696$ | 402,729$ | 0 | 0 | 0$ | 0 | 1,696$ | 0$ |
3 | Belleville Senators (OTT) | 2000 | 1000 | 30 | 14 | 69735 | 35275 | 96.85% | 97.99% | 0 | 2917 - 97.23% | 84,760$ | 3,051,360$ | 3000 | 100 | 2,768,154$ | 2,540,606$ | 3,102,986$ | 14,123$ | 3,102,986$ | 0 | 0 | 0$ | 0 | 14,123$ | 0$ |
4 | Bridgeport Islanders (NYI) | 2000 | 1000 | 30 | 10 | 68459 | 35912 | 95.08% | 99.76% | 0 | 2899 - 96.64% | 79,089$ | 2,847,209$ | 3000 | 100 | 2,181,952$ | 1,885,606$ | 2,433,734$ | 11,132$ | 2,433,734$ | 0 | 0 | 0$ | 0 | 11,132$ | 0$ |
5 | Calgary Wranglers (CAL) | 2000 | 1000 | 35 | 15 | 68854 | 34408 | 95.63% | 95.58% | 0 | 2868 - 95.61% | 95,908$ | 3,452,694$ | 3000 | 100 | 1,263,250$ | 1,194,260$ | 1,481,025$ | 6,445$ | 1,481,025$ | 0 | 0 | 0$ | 0 | 6,445$ | 0$ |
6 | Charlotte Checkers (FLO) | 2000 | 1000 | 20 | 10 | 71729 | 35789 | 99.62% | 99.41% | 0 | 2987 - 99.55% | 58,753$ | 2,115,115$ | 3000 | 100 | 1,480,600$ | 934,000$ | 1,393,730$ | 7,554$ | 1,393,730$ | 0 | 0 | 0$ | 0 | 7,554$ | 0$ |
7 | Chicago Wolves (CAR) | 2000 | 1000 | 30 | 10 | 69425 | 35842 | 96.42% | 99.56% | 0 | 2924 - 97.47% | 80,016$ | 2,880,581$ | 3000 | 100 | 2,938,583$ | 1,889,500$ | 2,954,490$ | 14,993$ | 2,954,490$ | 0 | 0 | 0$ | 0 | 14,993$ | 0$ |
8 | Cleveland Monsters (CBJ) | 2000 | 1000 | 35 | 15 | 68547 | 35096 | 95.20% | 97.49% | 0 | 2879 - 95.97% | 95,894$ | 3,452,190$ | 3000 | 100 | 1,677,500$ | 1,332,702$ | 1,582,948$ | 8,559$ | 1,578,078$ | 0 | 0 | 0$ | 0 | 8,559$ | 0$ |
9 | Coachella Valley Firebirds (SEA) | 2000 | 1000 | 35 | 15 | 67385 | 34759 | 93.59% | 96.55% | 0 | 2837 - 94.58% | 94,395$ | 3,398,236$ | 3000 | 100 | 890,000$ | 712,500$ | 1,218,534$ | 4,541$ | 1,218,534$ | 0 | 0 | 0$ | 0 | 4,541$ | 0$ |
10 | Colorado Eagles (COL) | 2000 | 1000 | 20 | 10 | 71666 | 35847 | 99.54% | 99.58% | 0 | 2986 - 99.55% | 58,731$ | 2,114,312$ | 3000 | 100 | 1,249,800$ | 755,202$ | 1,240,243$ | 6,377$ | 1,240,243$ | 0 | 0 | 0$ | 0 | 6,377$ | 0$ |
11 | Grand Rapids Griffins (DET) | 2000 | 1000 | 41 | 19 | 49354 | 26187 | 68.55% | 72.74% | 0 | 2098 - 69.95% | 82,635$ | 2,974,861$ | 3000 | 100 | 1,203,250$ | 1,021,250$ | 1,729,894$ | 6,139$ | 1,729,894$ | 0 | 0 | 0$ | 0 | 6,139$ | 0$ |
12 | Hartford Wolf Pack (NYR) | 2000 | 1000 | 35 | 15 | 67402 | 34567 | 93.61% | 96.02% | 0 | 2832 - 94.42% | 94,321$ | 3,395,539$ | 3000 | 100 | 582,600$ | 420,202$ | 607,834$ | 2,972$ | 607,834$ | 0 | 0 | 0$ | 0 | 2,972$ | 0$ |
13 | Henderson Silver Knights (VGK) | 2000 | 1000 | 35 | 15 | 67888 | 34510 | 94.29% | 95.86% | 0 | 2844 - 94.81% | 94,850$ | 3,414,604$ | 3000 | 100 | 2,324,750$ | 1,673,606$ | 1,939,415$ | 11,861$ | 1,939,415$ | 0 | 0 | 0$ | 0 | 11,861$ | 0$ |
14 | Hershey Bears (WAS) | 2000 | 1000 | 35 | 15 | 68479 | 34616 | 95.11% | 96.16% | 0 | 2864 - 95.46% | 95,580$ | 3,440,885$ | 3000 | 100 | 1,201,000$ | 1,106,202$ | 1,210,443$ | 6,128$ | 1,210,443$ | 0 | 0 | 0$ | 0 | 6,128$ | 0$ |
15 | Iowa Wild (MIN) | 2000 | 1000 | 30 | 15 | 69473 | 34336 | 96.49% | 95.38% | 0 | 2884 - 96.12% | 85,197$ | 3,067,091$ | 3000 | 100 | 1,631,250$ | 1,113,000$ | 1,630,660$ | 8,323$ | 1,630,660$ | 0 | 0 | 0$ | 0 | 8,323$ | 0$ |
16 | Laval Rocket (MTL) | 2000 | 1000 | 35 | 15 | 67725 | 34599 | 94.06% | 96.11% | 0 | 2842 - 94.74% | 94,707$ | 3,409,443$ | 3000 | 100 | 617,500$ | 550,202$ | 607,834$ | 3,151$ | 607,834$ | 0 | 0 | 0$ | 0 | 3,151$ | 0$ |
17 | LeHigh Valley Phantoms (PHI) | 2000 | 1000 | 35 | 15 | 68950 | 34305 | 95.76% | 95.29% | 0 | 2868 - 95.61% | 95,968$ | 3,454,831$ | 3000 | 100 | 1,199,250$ | 984,452$ | 1,232,002$ | 6,119$ | 1,232,002$ | 0 | 0 | 0$ | 0 | 6,119$ | 0$ |
18 | Manitoba Moose (WPG) | 2000 | 1000 | 35 | 15 | 67825 | 34522 | 94.20% | 95.89% | 0 | 2843 - 94.77% | 94,784$ | 3,412,212$ | 3000 | 100 | 1,274,952$ | 1,155,808$ | 1,266,771$ | 6,505$ | 1,266,771$ | 0 | 0 | 0$ | 0 | 6,505$ | 0$ |
19 | Milwaukee Admirals (NAS) | 2000 | 1000 | 35 | 15 | 68708 | 34611 | 95.43% | 96.14% | 0 | 2870 - 95.67% | 95,840$ | 3,450,255$ | 3000 | 100 | 705,000$ | 360,000$ | 438,239$ | 3,597$ | 438,239$ | 0 | 0 | 0$ | 0 | 3,597$ | 0$ |
20 | Ontario Reign (LAK) | 2000 | 1000 | 40 | 30 | 52008 | 16641 | 72.23% | 46.23% | 0 | 1907 - 63.56% | 84,552$ | 3,043,870$ | 3000 | 100 | 2,081,650$ | 1,628,106$ | 1,950,423$ | 10,621$ | 1,950,423$ | 0 | 0 | 0$ | 0 | 10,621$ | 0$ |
21 | Providence Bruins (BOS) | 2000 | 1000 | 40 | 20 | 50982 | 25122 | 70.81% | 69.78% | 0 | 2114 - 70.47% | 83,312$ | 2,999,231$ | 3000 | 100 | 1,473,500$ | 1,160,058$ | 1,446,228$ | 7,518$ | 1,446,228$ | 0 | 0 | 0$ | 0 | 7,518$ | 0$ |
22 | Rochester Americans (BUF) | 2000 | 1000 | 23 | 7 | 71608 | 35986 | 99.46% | 99.96% | 0 | 2989 - 99.62% | 62,241$ | 2,240,684$ | 3000 | 100 | 994,250$ | 707,500$ | 1,161,145$ | 5,073$ | 1,161,145$ | 0 | 0 | 0$ | 0 | 5,073$ | 0$ |
23 | Rockford IceHogs (CHI) | 2000 | 1000 | 35 | 15 | 67875 | 34511 | 94.27% | 95.86% | 0 | 2844 - 94.80% | 94,836$ | 3,414,080$ | 3000 | 100 | 1,044,500$ | 810,000$ | 819,426$ | 5,329$ | 819,426$ | 0 | 0 | 0$ | 0 | 5,329$ | 0$ |
24 | San Diego Gulls (ANA) | 2000 | 1000 | 100 | 90 | 20470 | 5579 | 28.43% | 15.50% | 0 | 724 - 24.12% | 83,554$ | 3,007,950$ | 3000 | 100 | 1,238,000$ | 835,606$ | 935,451$ | 6,316$ | 935,451$ | 0 | 0 | 0$ | 0 | 6,316$ | 0$ |
25 | San Jose Barracuda (SJS) | 2000 | 1000 | 35 | 15 | 68172 | 34582 | 94.68% | 96.06% | 0 | 2854 - 95.14% | 95,211$ | 3,427,603$ | 3000 | 100 | 2,520,404$ | 2,116,414$ | 2,511,840$ | 12,859$ | 2,511,840$ | 0 | 0 | 0$ | 0 | 12,859$ | 0$ |
26 | Springfield Thunderbirds (STL) | 2000 | 1000 | 35 | 15 | 68770 | 34463 | 95.51% | 95.73% | 0 | 2868 - 95.59% | 95,839$ | 3,450,198$ | 3000 | 100 | 605,417$ | 482,702$ | 519,704$ | 3,089$ | 519,704$ | 0 | 0 | 0$ | 0 | 3,089$ | 0$ |
27 | Syracuse Crunch (TAM) | 2000 | 1000 | 35 | 15 | 67874 | 34665 | 94.27% | 96.29% | 0 | 2848 - 94.94% | 94,910$ | 3,416,768$ | 3000 | 100 | 2,042,000$ | 1,537,500$ | 2,096,329$ | 10,418$ | 2,095,897$ | 0 | 0 | 0$ | 0 | 10,418$ | 0$ |
28 | Texas Stars (DAL) | 2000 | 1000 | 42 | 22 | 48849 | 22837 | 67.85% | 63.44% | 0 | 1991 - 66.38% | 83,717$ | 3,013,806$ | 3000 | 100 | 1,988,000$ | 1,655,202$ | 2,012,811$ | 10,143$ | 2,003,371$ | 0 | 0 | 0$ | 0 | 10,143$ | 0$ |
29 | Toronto Marlies (TOR) | 2000 | 1000 | 35 | 15 | 66987 | 34642 | 93.04% | 96.23% | 0 | 2823 - 94.10% | 93,881$ | 3,379,725$ | 3000 | 100 | 1,014,250$ | 705,404$ | 1,090,603$ | 5,175$ | 1,090,603$ | 0 | 0 | 0$ | 0 | 5,175$ | 0$ |
30 | Tucson Roadrunners (ARI) | 2000 | 1000 | 30 | 15 | 69474 | 34119 | 96.49% | 94.78% | 0 | 2878 - 95.92% | 85,091$ | 3,063,284$ | 3000 | 100 | 1,583,000$ | 1,408,000$ | 1,477,785$ | 8,077$ | 1,477,785$ | 0 | 0 | 0$ | 0 | 8,077$ | 0$ |
31 | Utica Comets (NJD) | 2000 | 1000 | 50 | 25 | 41405 | 19934 | 57.51% | 55.37% | 0 | 1704 - 56.80% | 84,193$ | 3,030,950$ | 3000 | 100 | 1,376,650$ | 878,702$ | 1,245,202$ | 7,024$ | 1,241,368$ | 0 | 0 | 0$ | 0 | 7,024$ | 0$ |
32 | Wilkes-Barre/Scranton Penguins (PIT) | 2000 | 1000 | 35 | 15 | 68244 | 34774 | 94.78% | 96.59% | 0 | 2862 - 95.39% | 95,388$ | 3,433,976$ | 3000 | 100 | 2,291,250$ | 1,856,164$ | 2,123,598$ | 11,690$ | 2,117,988$ | 0 | 0 | 0$ | 0 | 11,690$ | 0$ |