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 Salaries Cap | 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 | Albany River Rats (CAR) | 2000 | 1000 | 35 | 15 | 25891 | 12970 | 99.58% | 99.77% | 40 | 2989 - 99.64% | 86,365$ | 1,122,750$ | 3000 | 100 | 2,251,033$ | 2,251,033$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 6 | 0$ | 0$ |
2 | Binghamton Senators (OTT) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0% | 0% | 53 | 0 - 0% | 0$ | 0$ | 3000 | 100 | 1,788,000$ | 1,788,000$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 6 | 0$ | 0$ |
3 | Bridgeport Sound Tigers (NYI) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0% | 0% | 53 | 0 - 0% | 0$ | 0$ | 3000 | 100 | 669,000$ | 669,000$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 6 | 0$ | 0$ |
4 | Chicago Wolves (WIN) | 2000 | 1000 | 100 | 99 | 2501 | 798 | 41.68% | 26.60% | 50 | 1100 - 36.66% | 111,895$ | 335,685$ | 3000 | 100 | 2,335,832$ | 2,335,832$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 6 | 0$ | 0$ |
5 | Grand Rapids Griffins (DET) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0% | 0% | 53 | 0 - 0% | 0$ | 0$ | 3000 | 100 | 2,260,458$ | 2,260,458$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 6 | 0$ | 0$ |
6 | Hamilton Bulldogs (MTL) | 2000 | 1000 | 35 | 15 | 15868 | 7956 | 99.18% | 99.45% | 45 | 2978 - 99.27% | 86,027$ | 688,215$ | 3000 | 100 | 2,625,709$ | 2,625,709$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 6 | 0$ | 0$ |
7 | Hartford Wolf Pack (NYR) | 2000 | 1000 | 30 | 20 | 0 | 0 | 0% | 0% | 53 | 0 - 0% | 0$ | 0$ | 3000 | 100 | 2,112,250$ | 2,112,250$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 6 | 0$ | 0$ |
8 | Hershey Bears (WAS) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0% | 0% | 53 | 0 - 0% | 0$ | 0$ | 3000 | 100 | 1,672,483$ | 1,672,483$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 6 | 0$ | 0$ |
9 | Houston Aeros (MIN) | 2000 | 1000 | 55 | 30 | 3945 | 2028 | 65.75% | 67.60% | 50 | 1991 - 66.37% | 94,457$ | 283,372$ | 3000 | 100 | 1,791,027$ | 1,791,027$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 6 | 0$ | 0$ |
10 | Idaho Steelheads (DAL) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0% | 0% | 53 | 0 - 0% | 0$ | 0$ | 3000 | 100 | 1,310,083$ | 1,310,083$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 6 | 0$ | 0$ |
11 | Iowa Chops (ANA) | 2000 | 1000 | 40 | 22 | 5899 | 2919 | 98.32% | 97.30% | 50 | 2939 - 97.98% | 102,061$ | 306,182$ | 3000 | 100 | 1,902,700$ | 1,902,700$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 6 | 0$ | 0$ |
12 | Lake Erie Monsters (COL) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0% | 0% | 53 | 0 - 0% | 0$ | 0$ | 3000 | 100 | 1,330,167$ | 1,330,167$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 6 | 0$ | 0$ |
13 | Lowell Devils (N-J) | 2000 | 1000 | 42 | 22 | 10302 | 5829 | 85.85% | 97.15% | 47 | 2689 - 89.62% | 95,357$ | 572,140$ | 3000 | 100 | 1,417,167$ | 1,417,167$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 6 | 0$ | 0$ |
14 | Manchester Monarchs (LAK) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0% | 0% | 53 | 0 - 0% | 0$ | 0$ | 3000 | 100 | 1,434,751$ | 1,434,751$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 6 | 0$ | 0$ |
15 | Manitoba Moose (VAN) | 2000 | 1000 | 35 | 20 | 17919 | 8925 | 99.55% | 99.17% | 44 | 2983 - 99.42% | 91,309$ | 821,778$ | 3000 | 100 | 1,839,835$ | 1,839,835$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 6 | 0$ | 0$ |
16 | Milwaukee Admiral (NAS) | 2000 | 1000 | 40 | 22 | 15795 | 7804 | 98.72% | 97.55% | 45 | 2950 - 98.33% | 102,445$ | 819,557$ | 3000 | 100 | 1,542,317$ | 1,542,317$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 6 | 0$ | 0$ |
17 | Nevada Gamblers (LAV) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0% | 0% | 53 | 0 - 0% | 0$ | 0$ | 3000 | 100 | 2,046,549$ | 2,046,549$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 6 | 0$ | 0$ |
18 | Norfolk Admirals (TBY) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0% | 0% | 53 | 0 - 0% | 0$ | 0$ | 3000 | 100 | 1,052,250$ | 1,052,250$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 6 | 0$ | 0$ |
19 | Peoria Riverman (STL) | 2000 | 1000 | 35 | 15 | 5902 | 2957 | 98.37% | 98.57% | 50 | 2953 - 98.43% | 85,314$ | 255,943$ | 3000 | 100 | 1,476,900$ | 1,476,900$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 6 | 0$ | 0$ |
20 | Philadelphia Phantoms (PHI) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0% | 0% | 53 | 0 - 0% | 0$ | 0$ | 3000 | 100 | 1,384,250$ | 1,384,250$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 6 | 0$ | 0$ |
21 | Portland Pirates (BUF) | 2000 | 1000 | 33 | 13 | 5796 | 3000 | 96.60% | 100.00% | 50 | 2932 - 97.73% | 78,291$ | 234,873$ | 3000 | 100 | 1,439,015$ | 1,439,015$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 6 | 0$ | 0$ |
22 | Providence Bruins (BOS) | 2000 | 1000 | 35 | 15 | 4000 | 2000 | 100.00% | 100.00% | 51 | 3000 - 100.00% | 86,700$ | 173,400$ | 3000 | 100 | 2,269,500$ | 2,269,500$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 6 | 0$ | 0$ |
23 | Quad City Flames (CAL) | 2000 | 1000 | 35 | 15 | 17850 | 8964 | 99.17% | 99.60% | 44 | 2979 - 99.31% | 86,044$ | 774,394$ | 3000 | 100 | 1,663,000$ | 1,663,000$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 6 | 0$ | 0$ |
24 | Rochester Americans (FLO) | 2000 | 1000 | 30 | 10 | 5890 | 3000 | 98.17% | 100.00% | 50 | 2963 - 98.78% | 70,278$ | 210,834$ | 3000 | 100 | 1,112,916$ | 1,112,916$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 6 | 0$ | 0$ |
25 | Rockford IceHogs (CHI) | 2000 | 1000 | 85 | 65 | 0 | 0 | 0% | 0% | 53 | 0 - 0% | 0$ | 0$ | 3000 | 100 | 2,092,833$ | 2,092,833$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 6 | 0$ | 0$ |
26 | San Antonio Rampage (ARZ) | 2000 | 1000 | 40 | 20 | 0 | 0 | 0% | 0% | 53 | 0 - 0% | 0$ | 0$ | 3000 | 100 | 1,554,866$ | 1,554,866$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 6 | 0$ | 0$ |
27 | Springfield Falcons (EDM) | 2000 | 1000 | 35 | 15 | 4000 | 1982 | 100.00% | 99.10% | 51 | 2991 - 99.70% | 86,563$ | 173,125$ | 3000 | 100 | 1,782,950$ | 1,782,950$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 6 | 0$ | 0$ |
28 | Syracuse Crunch (CLB) | 2000 | 1000 | 50 | 30 | 10809 | 5032 | 77.21% | 71.89% | 46 | 2263 - 75.43% | 100,748$ | 705,238$ | 3000 | 100 | 1,732,183$ | 1,732,183$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 6 | 0$ | 0$ |
29 | Toronto Marlies (TOR) | 2000 | 1000 | 65 | 50 | 12035 | 4722 | 66.86% | 52.47% | 44 | 1862 - 62.06% | 115,416$ | 1,038,742$ | 3000 | 100 | 1,725,848$ | 1,725,848$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 6 | 0$ | 0$ |
30 | WB Scranton Penguins (PIT) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0% | 0% | 53 | 0 - 0% | 0$ | 0$ | 3000 | 100 | 1,855,333$ | 1,855,333$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 6 | 0$ | 0$ |
31 | Worcester Sharks (SAJ) | 2000 | 1000 | 30 | 10 | 0 | 0 | 0% | 0% | 53 | 0 - 0% | 0$ | 0$ | 3000 | 100 | 1,273,468$ | 1,273,468$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 6 | 0$ | 0$ |