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 |
Arena 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 | Arena 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 | Alberta Fire (CGY) | 2000 | 1000 | 65 | 25 | 9551 | 4735 | 95.51% | 94.70% | 33 | 2857 - 95.24% | 177,406$ | 887,028$ | 3000 | 100 | 2,445,433$ | 2,277,083$ | 0$ | 0$ | 0$ | 34 | 1 | 0$ | 0 | 0$ | 0$ |
2 | Cape Breton Roaring Moose (BUF) | 2000 | 1000 | 40 | 20 | 0 | 0 | 0.00% | 0.00% | 38 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 3,035,000$ | 3,259,850$ | 0$ | 0$ | 0$ | 33 | 0 | 0$ | 0 | 0$ | 0$ |
3 | Capital District Islanders (NYI) | 2000 | 1000 | 40 | 20 | 0 | 0 | 0.00% | 0.00% | 38 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 1,940,000$ | 1,928,306$ | 0$ | 0$ | 0$ | 28 | 0 | 0$ | 0 | 0$ | 0$ |
4 | Charlestown Chiefs (OTT) | 2000 | 1000 | 30 | 10 | 5470 | 2688 | 91.17% | 89.60% | 35 | 2719 - 90.64% | 76,392$ | 229,176$ | 3000 | 100 | 2,167,875$ | 2,435,070$ | 0$ | 0$ | 0$ | 35 | 0 | 0$ | 0 | 0$ | 0$ |
5 | Charlotte Checkers (CAR) | 2000 | 1000 | 40 | 20 | 13344 | 6583 | 95.31% | 94.04% | 31 | 2847 - 94.89% | 114,072$ | 798,504$ | 3000 | 100 | 2,713,750$ | 2,697,361$ | 0$ | 0$ | 0$ | 36 | 0 | 0$ | 0 | 0$ | 0$ |
6 | Charlottetown Mussle Shovelers (MIN) | 2000 | 1000 | 40 | 20 | 17161 | 8841 | 95.34% | 98.23% | 29 | 2889 - 96.30% | 115,101$ | 1,035,912$ | 3000 | 100 | 2,960,000$ | 3,250,828$ | 0$ | 0$ | 0$ | 35 | 2 | 0$ | 0 | 0$ | 0$ |
7 | Dahlonega Blood Miners (DAL) | 2000 | 1000 | 40 | 20 | 3568 | 1866 | 89.20% | 93.30% | 36 | 2717 - 90.57% | 108,024$ | 216,048$ | 3000 | 100 | 2,566,500$ | 2,383,001$ | 0$ | 0$ | 0$ | 39 | 0 | 0$ | 0 | 0$ | 0$ |
8 | Flint Admirals (VAN) | 2000 | 1000 | 40 | 20 | 0 | 0 | 0.00% | 0.00% | 38 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 2,833,833$ | 4,005,083$ | 0$ | 0$ | 0$ | 39 | 0 | 0$ | 0 | 0$ | 0$ |
9 | Florida Everblades (FLO) | 2000 | 1000 | 65 | 25 | 17393 | 8708 | 96.63% | 96.76% | 29 | 2900 - 96.67% | 179,766$ | 1,617,894$ | 3000 | 100 | 3,539,833$ | 3,347,122$ | 0$ | 0$ | 0$ | 40 | 2 | 0$ | 0 | 0$ | 0$ |
10 | Grand Rapids Griffins (DET) | 2000 | 1000 | 40 | 20 | 0 | 0 | 0.00% | 0.00% | 38 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 1,847,500$ | 1,840,333$ | 0$ | 0$ | 0$ | 32 | 0 | 0$ | 0 | 0$ | 0$ |
11 | Green Bay Lumberjacks (CBS) | 2000 | 1000 | 40 | 20 | 0 | 0 | 0.00% | 0.00% | 38 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 2,687,500$ | 2,970,600$ | 0$ | 0$ | 0$ | 34 | 0 | 0$ | 0 | 0$ | 0$ |
12 | Hershey Bears (WSH) | 2000 | 1000 | 40 | 20 | 0 | 0 | 0.00% | 0.00% | 38 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 2,687,500$ | 3,408,675$ | 0$ | 0$ | 0$ | 37 | 0 | 0$ | 0 | 0$ | 0$ |
13 | Indianapolis Knights (CHI) | 2000 | 1000 | 40 | 20 | 0 | 0 | 0.00% | 0.00% | 38 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 1,935,000$ | 1,856,333$ | 0$ | 0$ | 0$ | 34 | 0 | 0$ | 0 | 0$ | 0$ |
14 | Manitoba Moose (WPG) | 2000 | 1000 | 40 | 20 | 9554 | 4650 | 95.54% | 93.00% | 33 | 2841 - 94.69% | 114,038$ | 570,192$ | 3000 | 100 | 2,006,162$ | 2,758,292$ | 0$ | 0$ | 0$ | 32 | 0 | 0$ | 0 | 0$ | 0$ |
15 | Milwaukee Admirals (NSH) | 2000 | 1000 | 40 | 20 | 0 | 0 | 0.00% | 0.00% | 38 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 1,780,000$ | 1,700,750$ | 0$ | 0$ | 0$ | 27 | 0 | 0$ | 0 | 0$ | 0$ |
16 | Mississauga Wolves (TOR) | 2000 | 1000 | 40 | 20 | 0 | 0 | 0.00% | 0.00% | 38 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 2,613,833$ | 2,571,917$ | 0$ | 0$ | 0$ | 37 | 0 | 0$ | 0 | 0$ | 0$ |
17 | Naples Stingrays (TBL) | 2000 | 1000 | 40 | 20 | 17492 | 8635 | 97.18% | 95.94% | 29 | 2903 - 96.77% | 116,317$ | 1,046,856$ | 3000 | 100 | 2,427,500$ | 2,083,833$ | 0$ | 0$ | 0$ | 25 | 1 | 0$ | 0 | 0$ | 0$ |
18 | New Orleans Voodoo (NJD) | 2000 | 1000 | 34 | 17 | 5667 | 2761 | 94.45% | 92.03% | 35 | 2809 - 93.64% | 95,846$ | 287,538$ | 3000 | 100 | 2,722,875$ | 2,855,633$ | 0$ | 0$ | 0$ | 46 | 0 | 0$ | 0 | 0$ | 0$ |
19 | Oklahoma City Barons (EDM) | 2000 | 1000 | 40 | 20 | 0 | 0 | 0.00% | 0.00% | 38 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 2,673,333$ | 4,150,345$ | 0$ | 0$ | 0$ | 35 | 0 | 0$ | 0 | 0$ | 0$ |
20 | Pasadena Beavers (LAK) | 2000 | 1000 | 40 | 20 | 3460 | 1885 | 86.50% | 94.25% | 36 | 2673 - 89.08% | 105,660$ | 211,320$ | 3000 | 100 | 2,451,333$ | 1,910,733$ | 0$ | 0$ | 0$ | 32 | 0 | 0$ | 0 | 0$ | 0$ |
21 | Philadelphia Phantoms (PHI) | 2000 | 1000 | 40 | 20 | 7298 | 3536 | 91.23% | 88.40% | 34 | 2709 - 90.28% | 108,792$ | 435,168$ | 3000 | 100 | 2,289,250$ | 2,152,083$ | 0$ | 0$ | 0$ | 32 | 0 | 0$ | 0 | 0$ | 0$ |
22 | Portland Wild Cats (SJS) | 2000 | 1000 | 40 | 20 | 0 | 0 | 0.00% | 0.00% | 38 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 1,781,500$ | 1,705,633$ | 0$ | 0$ | 0$ | 31 | 0 | 0$ | 0 | 0$ | 0$ |
23 | Providence Bruins (BOS) | 2000 | 1000 | 67 | 27 | 11695 | 5762 | 97.46% | 96.03% | 32 | 2910 - 96.98% | 187,828$ | 1,126,967$ | 3000 | 100 | 2,535,000$ | 2,938,811$ | 0$ | 0$ | 0$ | 39 | 0 | 0$ | 0 | 0$ | 0$ |
24 | Quebec Aces (NYR) | 2000 | 1000 | 40 | 20 | 0 | 0 | 0.00% | 0.00% | 38 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 2,704,041$ | 3,008,944$ | 0$ | 0$ | 0$ | 39 | 0 | 0$ | 0 | 0$ | 0$ |
25 | Red Rock Aces (VGK) | 2000 | 1000 | 40 | 20 | 3770 | 1802 | 94.25% | 90.10% | 36 | 2786 - 92.87% | 112,104$ | 224,208$ | 3000 | 100 | 2,299,750$ | 2,849,450$ | 0$ | 0$ | 0$ | 31 | 0 | 0$ | 0 | 0$ | 0$ |
26 | Salt Lake City Lynx (PIT) | 2000 | 1000 | 40 | 20 | 0 | 0 | 0.00% | 0.00% | 38 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 2,201,250$ | 2,308,653$ | 0$ | 0$ | 0$ | 34 | 0 | 0$ | 0 | 0$ | 0$ |
27 | San Diego Gulls (ANA) | 2000 | 1000 | 40 | 20 | 5346 | 2702 | 89.10% | 90.07% | 35 | 2683 - 89.42% | 107,152$ | 321,456$ | 3000 | 100 | 2,708,500$ | 2,363,423$ | 0$ | 0$ | 0$ | 36 | 0 | 0$ | 0 | 0$ | 0$ |
28 | Sarasota Manatees (ARI) | 2000 | 1000 | 30 | 15 | 0 | 0 | 0.00% | 0.00% | 38 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 3,278,750$ | 3,798,222$ | 0$ | 0$ | 0$ | 34 | 0 | 0$ | 0 | 0$ | 0$ |
29 | Springfield Bulldogs (STL) | 2000 | 1000 | 40 | 20 | 17558 | 8600 | 97.54% | 95.56% | 29 | 2906 - 96.88% | 116,576$ | 1,049,184$ | 3000 | 100 | 2,812,375$ | 3,194,750$ | 0$ | 0$ | 0$ | 35 | 0 | 0$ | 0 | 0$ | 0$ |
30 | Tofino Whalers (COL) | 2000 | 1000 | 40 | 20 | 0 | 0 | 0.00% | 0.00% | 38 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 1,556,667$ | 1,588,917$ | 0$ | 0$ | 0$ | 26 | 0 | 0$ | 0 | 0$ | 0$ |
31 | Trois-Rivieres Voyageurs (MTL) | 2000 | 1000 | 40 | 20 | 5677 | 2798 | 94.62% | 93.27% | 35 | 2825 - 94.17% | 113,216$ | 339,648$ | 3000 | 100 | 2,392,750$ | 2,997,500$ | 0$ | 0$ | 0$ | 37 | 0 | 0$ | 0 | 0$ | 0$ |