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 | Adirondack Angels (EDM) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 10 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 2,090,000$ | 2,090,000$ | 2,559,527$ | 13,660$ | 1,619,977$ | 0 | 0 | 0$ | 38 | 21,830$ | 829,540$ |
2 | Atlantic City Blackjacks (VGK) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 11 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 2,275,500$ | 2,285,500$ | 2,454,185$ | 14,873$ | 1,702,638$ | 0 | 0 | 0$ | 38 | 21,408$ | 813,504$ |
3 | Baltimore Patriots (WSH) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 10 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 2,506,800$ | 2,506,467$ | 2,799,943$ | 16,384$ | 2,048,303$ | 0 | 0 | 0$ | 38 | 22,920$ | 870,960$ |
4 | Binghamton Senators (OTT) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 10 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 2,341,515$ | 2,341,515$ | 2,548,643$ | 15,304$ | 1,721,833$ | 0 | 0 | 0$ | 38 | 22,494$ | 854,772$ |
5 | Bridgeport Sound Tigers (NYI) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 10 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 2,143,750$ | 2,137,250$ | 2,240,665$ | 14,011$ | 1,639,330$ | 0 | 0 | 0$ | 38 | 19,240$ | 731,120$ |
6 | Burlington Cougars (BOS) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 10 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 2,311,000$ | 2,352,875$ | 2,389,102$ | 15,105$ | 1,787,805$ | 0 | 0 | 0$ | 38 | 20,333$ | 772,654$ |
7 | Carolina Panthers (CAR) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 10 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 2,402,000$ | 2,410,333$ | 2,338,673$ | 15,699$ | 1,812,457$ | 0 | 0 | 0$ | 38 | 20,275$ | 770,450$ |
8 | Cleveland Monsters (STL) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 10 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 2,175,700$ | 2,175,700$ | 2,199,030$ | 14,220$ | 1,635,300$ | 0 | 0 | 0$ | 38 | 19,122$ | 726,636$ |
9 | Durham Pioneers (BUF) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 10 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 2,049,442$ | 2,049,442$ | 2,348,998$ | 13,395$ | 1,616,103$ | 0 | 0 | 0$ | 38 | 19,768$ | 751,184$ |
10 | Greenville Swamp Rabbits (COL) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 10 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 3,671,500$ | 3,671,500$ | 2,644,100$ | 23,997$ | 2,061,611$ | 0 | 0 | 0$ | 38 | 29,062$ | 1,104,356$ |
11 | Halifax Mooseheads (SJS) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 11 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 3,183,000$ | 3,176,750$ | 2,458,217$ | 20,804$ | 1,781,703$ | 0 | 0 | 0$ | 38 | 26,686$ | 1,014,068$ |
12 | Henderson Black Knights (VAN) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 11 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 2,311,000$ | 2,311,000$ | 2,441,599$ | 15,105$ | 1,765,167$ | 0 | 0 | 0$ | 38 | 20,987$ | 797,506$ |
13 | Hershey Bears (DET) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 10 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 1,735,000$ | 1,735,000$ | 2,046,459$ | 11,340$ | 1,294,820$ | 0 | 0 | 0$ | 38 | 17,876$ | 679,288$ |
14 | Iowa Wild (MIN) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 11 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 1,942,000$ | 1,922,000$ | 2,001,725$ | 12,693$ | 1,475,548$ | 0 | 0 | 0$ | 38 | 17,268$ | 656,184$ |
15 | Laval Rocket (MON) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 10 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 2,907,500$ | 2,907,500$ | 2,747,775$ | 19,003$ | 2,146,442$ | 0 | 0 | 0$ | 38 | 24,232$ | 920,816$ |
16 | Long Island Ducks (WPG) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 10 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 1,857,500$ | 1,857,500$ | 2,097,263$ | 12,141$ | 1,383,227$ | 0 | 0 | 0$ | 38 | 18,350$ | 697,300$ |
17 | Louisville Thunder (ANH) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 10 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 2,169,500$ | 2,162,833$ | 2,599,578$ | 14,180$ | 1,660,028$ | 0 | 0 | 0$ | 38 | 22,350$ | 849,300$ |
18 | Milwaukee Admirals (NSH) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 10 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 5,095,000$ | 4,719,000$ | 3,143,199$ | 33,301$ | 2,504,365$ | 0 | 0 | 0$ | 38 | 38,856$ | 1,476,528$ |
19 | Newfoundland Growlers (FLA) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 10 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 2,223,500$ | 2,220,500$ | 2,605,069$ | 14,533$ | 1,778,332$ | 0 | 0 | 0$ | 38 | 21,722$ | 825,436$ |
20 | North Bay Icemen (NYR) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 11 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 2,375,000$ | 2,375,000$ | 2,568,780$ | 15,523$ | 1,817,140$ | 0 | 0 | 0$ | 38 | 22,059$ | 838,242$ |
21 | Oakland Seals (LAK) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 10 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 2,279,500$ | 2,279,500$ | 2,282,509$ | 14,899$ | 1,643,622$ | 0 | 0 | 0$ | 38 | 20,454$ | 777,252$ |
22 | Ontario Reign (ARZ) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 10 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 2,228,000$ | 2,226,000$ | 2,515,744$ | 14,562$ | 1,576,197$ | 0 | 0 | 0$ | 38 | 22,732$ | 863,816$ |
23 | Pensacola Ice Flyers (TAM) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 10 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 2,019,500$ | 2,047,000$ | 2,278,462$ | 13,199$ | 1,526,822$ | 0 | 0 | 0$ | 38 | 19,735$ | 749,930$ |
24 | Philadelphia Phantoms (PHI) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 10 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 1,913,400$ | 1,963,400$ | 2,222,622$ | 12,506$ | 1,395,882$ | 0 | 0 | 0$ | 38 | 19,695$ | 748,410$ |
25 | Richmond Renegades (NJD) | 2000 | 1000 | 39 | 24 | 0 | 0 | 0.00% | 0.00% | 11 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 2,460,000$ | 2,451,250$ | 2,654,235$ | 16,078$ | 1,902,600$ | 0 | 0 | 0$ | 38 | 22,614$ | 859,332$ |
26 | Rockford IceHogs (CHI) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 10 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 2,057,500$ | 2,070,000$ | 2,278,122$ | 13,448$ | 1,526,482$ | 0 | 0 | 0$ | 38 | 19,984$ | 759,392$ |
27 | Seatac Aviators (SEA) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 10 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 2,638,500$ | 2,707,250$ | 2,480,712$ | 17,245$ | 1,954,550$ | 0 | 0 | 0$ | 38 | 21,820$ | 829,160$ |
28 | Stockton Heat (CGY) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 11 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 2,159,250$ | 2,159,250$ | 2,361,780$ | 14,113$ | 1,685,324$ | 0 | 0 | 0$ | 38 | 19,995$ | 759,810$ |
29 | Syracuse Crunch (CLB) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 10 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 2,707,500$ | 2,707,500$ | 2,219,778$ | 17,696$ | 1,618,456$ | 0 | 0 | 0$ | 38 | 22,925$ | 871,150$ |
30 | Texas Stars (DAL) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 10 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 2,173,900$ | 2,173,900$ | 2,553,472$ | 14,208$ | 1,613,922$ | 0 | 0 | 0$ | 38 | 22,378$ | 850,364$ |
31 | Toronto Marlies (TOR) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 10 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 2,602,500$ | 2,655,500$ | 2,558,041$ | 17,010$ | 1,956,706$ | 0 | 0 | 0$ | 38 | 22,239$ | 845,082$ |
32 | Wilkes Barre-Scranton (PIT) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 10 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 2,612,000$ | 2,596,375$ | 2,714,386$ | 17,072$ | 1,774,858$ | 0 | 0 | 0$ | 38 | 25,242$ | 959,196$ |