| 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 Total Estimate | ||||||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| # | Team | Level1 | Level2 | Level3 | Level4 | Luxury | Level1 | Level2 | Level3 | Level4 | Luxury | Level1 | Level2 | Level3 | Level4 | Luxury | Level1 | Level2 | Level3 | Level4 | Luxury | Home Games Left | Average Attendance - % | Average Income per Game | Year to Date Revenue | Capacity | Team Popularity | Players Total Salaries | Players Total Salaries Cap | Special Salary Cap Value | Year To Date Expenses | Salary Cap Per Days | Salary Cap To Date | Players In Salary Cap | Players Out of Salary Cap | Luxury Taxe Total | Estimated Season Revenue | Remaining Season Days | Expenses Per Days | Estimated Season Expenses | Estimated Season Expenses | Estimated Season Salary Cap | Over Minimum Salary Cap of 10,000,000$ | Maximum Salary Cap | Available Salary Cap | Current Bank Account | Projected Bank Account |
| 1 | Boston Bruins | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 10525 | 8096 | 3392 | 6828 | 1665 | 87.71% | 80.96% | 84.80% | 85.35% | 83.25% | 39 | 15253 - 84.74% | 1,080,340$ | 2,160,680$ | 18000 | 100 | 22,605,000$ | 22,605,000$ | 0$ | 0$ | 0$ | 0$ | 20 | 0 | 0$ | 0$ | 2 | 0$ | 0$ | 0$ | 0$ | -10,000,000$ | 23,000,000$ | 23,000,000$ | 252,643,669$ | 252,643,669$ |
| 2 | Buffalo Sabres | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 15403 | 11960 | 5350 | 10329 | 2645 | 85.57% | 79.73% | 89.17% | 86.08% | 88.17% | 38 | 15229 - 84.61% | 1,077,458$ | 3,232,375$ | 18000 | 100 | 21,870,000$ | 21,870,000$ | 0$ | 0$ | 0$ | 0$ | 21 | 0 | 0$ | 0$ | 2 | 0$ | 0$ | 0$ | 0$ | -10,000,000$ | 23,000,000$ | 23,000,000$ | 289,265,655$ | 289,265,655$ |
| 3 | Calgary Flames | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 18000 | 100 | 20,622,500$ | 20,622,500$ | 0$ | 0$ | 0$ | 0$ | 22 | 0 | 0$ | 0$ | 2 | 0$ | 0$ | 0$ | 0$ | -10,000,000$ | 23,000,000$ | 23,000,000$ | 273,977,246$ | 273,977,246$ |
| 4 | Chicago Blackhawks | 6000 | 5000 | 2000 | 4000 | 1000 | 80 | 45 | 25 | 15 | 160 | 12000 | 10000 | 4000 | 8000 | 2000 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 39 | 18000 - 100.00% | 975,000$ | 1,950,000$ | 18000 | 100 | 22,065,000$ | 22,065,000$ | 0$ | 0$ | 0$ | 0$ | 22 | 0 | 0$ | 0$ | 2 | 0$ | 0$ | 0$ | 0$ | -10,000,000$ | 23,000,000$ | 23,000,000$ | 226,493,662$ | 226,493,662$ |
| 5 | Detroit Red Wings | 6000 | 5000 | 2000 | 4000 | 1000 | 91 | 51 | 30 | 18 | 174 | 12000 | 10000 | 4000 | 8000 | 2000 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 39 | 18000 - 100.00% | 1,107,000$ | 2,214,000$ | 18000 | 100 | 20,685,000$ | 20,685,000$ | 0$ | 0$ | 0$ | 0$ | 20 | 0 | 0$ | 0$ | 2 | 0$ | 0$ | 0$ | 0$ | -10,000,000$ | 23,000,000$ | 23,000,000$ | 297,718,973$ | 297,718,973$ |
| 6 | Edmonton Oilers | 6000 | 5000 | 2000 | 4000 | 1000 | 95 | 58 | 35 | 28 | 155 | 17909 | 13479 | 5071 | 8858 | 3000 | 99.49% | 89.86% | 84.52% | 73.82% | 100.00% | 38 | 16106 - 89.48% | 1,124,549$ | 3,373,646$ | 18000 | 100 | 21,980,000$ | 21,980,000$ | 0$ | 0$ | 0$ | 0$ | 22 | 0 | 0$ | 0$ | 2 | 0$ | 0$ | 0$ | 0$ | -10,000,000$ | 23,000,000$ | 23,000,000$ | 307,570,478$ | 307,570,478$ |
| 7 | Hartford Whalers | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 15730 | 12061 | 5026 | 9960 | 2605 | 87.39% | 80.41% | 83.77% | 83.00% | 86.83% | 38 | 15127 - 84.04% | 1,080,857$ | 3,242,570$ | 18000 | 100 | 16,690,000$ | 16,690,000$ | 0$ | 0$ | 0$ | 0$ | 21 | 0 | 0$ | 0$ | 2 | 0$ | 0$ | 0$ | 0$ | -10,000,000$ | 23,000,000$ | 23,000,000$ | 249,853,063$ | 249,853,063$ |
| 8 | Los Angeles Kings | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 10078 | 8561 | 3314 | 6703 | 1683 | 83.98% | 85.61% | 82.85% | 83.79% | 84.15% | 39 | 15170 - 84.28% | 1,070,813$ | 2,141,625$ | 18000 | 100 | 21,970,000$ | 21,970,000$ | 0$ | 0$ | 0$ | 0$ | 21 | 0 | 0$ | 0$ | 2 | 0$ | 0$ | 0$ | 0$ | -10,000,000$ | 23,000,000$ | 23,000,000$ | 276,967,960$ | 276,967,960$ |
| 9 | Minnesota North Stars | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 15693 | 12282 | 5373 | 9827 | 2468 | 87.18% | 81.88% | 89.55% | 81.89% | 82.27% | 38 | 15214 - 84.52% | 1,077,850$ | 3,233,550$ | 18000 | 100 | 22,630,000$ | 22,630,000$ | 0$ | 0$ | 0$ | 0$ | 20 | 0 | 0$ | 0$ | 2 | 0$ | 0$ | 0$ | 0$ | -10,000,000$ | 23,000,000$ | 23,000,000$ | 264,713,876$ | 264,713,876$ |
| 10 | Montreal Canadiens | 6000 | 5000 | 2000 | 4000 | 1000 | 95 | 55 | 35 | 25 | 180 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 18000 | 100 | 22,740,000$ | 22,740,000$ | 0$ | 0$ | 0$ | 0$ | 21 | 0 | 0$ | 0$ | 2 | 0$ | 0$ | 0$ | 0$ | -10,000,000$ | 23,000,000$ | 23,000,000$ | 294,604,464$ | 294,604,464$ |
| 11 | New Jersey Devils | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 199 | 9822 | 9233 | 3265 | 6624 | 1757 | 81.85% | 92.33% | 81.63% | 82.80% | 87.85% | 39 | 15351 - 85.28% | 1,082,849$ | 2,165,698$ | 18000 | 100 | 21,580,000$ | 21,580,000$ | 0$ | 0$ | 0$ | 0$ | 22 | 0 | 0$ | 0$ | 2 | 0$ | 0$ | 0$ | 0$ | -10,000,000$ | 23,000,000$ | 23,000,000$ | 249,496,556$ | 249,496,556$ |
| 12 | New York Islanders | 6000 | 5000 | 2000 | 4000 | 1000 | 75 | 40 | 25 | 15 | 130 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 18000 | 100 | 14,263,000$ | 14,263,000$ | 0$ | 0$ | 0$ | 0$ | 21 | 0 | 0$ | 0$ | 2 | 0$ | 0$ | 0$ | 0$ | -10,000,000$ | 23,000,000$ | 23,000,000$ | 240,409,954$ | 240,409,954$ |
| 13 | New York Rangers | 6000 | 5000 | 2000 | 4000 | 1000 | 125 | 65 | 45 | 30 | 250 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 18000 | 100 | 18,300,000$ | 18,300,000$ | 0$ | 0$ | 0$ | 0$ | 20 | 0 | 0$ | 0$ | 2 | 0$ | 0$ | 0$ | 0$ | -10,000,000$ | 23,000,000$ | 23,000,000$ | 254,361,629$ | 254,361,629$ |
| 14 | Ottawa Senators | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 18000 | 100 | 20,165,000$ | 20,165,000$ | 0$ | 0$ | 0$ | 0$ | 21 | 0 | 0$ | 0$ | 2 | 0$ | 0$ | 0$ | 0$ | -10,000,000$ | 23,000,000$ | 23,000,000$ | 28,603,411$ | 28,603,411$ |
| 15 | Philadelphia Flyers | 6000 | 5000 | 2000 | 4000 | 1000 | 70 | 45 | 20 | 18 | 140 | 12000 | 10000 | 4000 | 8000 | 2000 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 39 | 18000 - 100.00% | 897,000$ | 1,794,000$ | 18000 | 100 | 22,588,000$ | 22,588,000$ | 0$ | 0$ | 0$ | 0$ | 21 | 0 | 0$ | 0$ | 2 | 0$ | 0$ | 0$ | 0$ | -10,000,000$ | 23,000,000$ | 23,000,000$ | 237,199,767$ | 237,199,767$ |
| 16 | Pittsburgh Penguins | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 14972 | 12696 | 4985 | 10396 | 2513 | 83.18% | 84.64% | 83.08% | 86.63% | 83.77% | 38 | 15187 - 84.37% | 1,065,312$ | 3,195,935$ | 18000 | 100 | 17,325,000$ | 17,325,000$ | 0$ | 0$ | 0$ | 0$ | 20 | 0 | 0$ | 0$ | 2 | 0$ | 0$ | 0$ | 0$ | -10,000,000$ | 23,000,000$ | 23,000,000$ | 263,446,395$ | 263,446,395$ |
| 17 | Quebec Nordiques | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 10983 | 8083 | 3694 | 6249 | 1692 | 91.53% | 80.83% | 92.35% | 78.11% | 84.60% | 39 | 15351 - 85.28% | 1,103,598$ | 2,207,195$ | 18000 | 100 | 15,255,000$ | 15,255,000$ | 0$ | 0$ | 0$ | 0$ | 20 | 0 | 0$ | 0$ | 2 | 0$ | 0$ | 0$ | 0$ | -10,000,000$ | 23,000,000$ | 23,000,000$ | 252,657,225$ | 252,657,225$ |
| 18 | San Jose Sharks | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 18000 | 100 | 18,970,000$ | 18,970,000$ | 0$ | 0$ | 0$ | 0$ | 21 | 0 | 0$ | 0$ | 2 | 0$ | 0$ | 0$ | 0$ | -10,000,000$ | 23,000,000$ | 23,000,000$ | 62,558,072$ | 62,558,072$ |
| 19 | St-Louis Blues | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 15263 | 13318 | 4895 | 9716 | 2510 | 84.79% | 88.79% | 81.58% | 80.97% | 83.67% | 38 | 15234 - 84.63% | 1,080,535$ | 3,241,605$ | 18000 | 100 | 22,710,000$ | 22,710,000$ | 0$ | 0$ | 0$ | 0$ | 21 | 0 | 0$ | 0$ | 2 | 0$ | 0$ | 0$ | 0$ | -10,000,000$ | 23,000,000$ | 23,000,000$ | 267,836,238$ | 267,836,238$ |
| 20 | Tampa Bay Lightning | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 18000 | 100 | 20,060,000$ | 20,060,000$ | 0$ | 0$ | 0$ | 0$ | 21 | 0 | 0$ | 0$ | 2 | 0$ | 0$ | 0$ | 0$ | -10,000,000$ | 23,000,000$ | 23,000,000$ | 27,839,902$ | 27,839,902$ |
| 21 | Toronto Maple Leafs | 6000 | 5000 | 2000 | 4000 | 1000 | 93 | 53 | 29 | 20 | 175 | 17858 | 15000 | 6000 | 12000 | 2973 | 99.21% | 100.00% | 100.00% | 100.00% | 99.10% | 38 | 17944 - 99.69% | 1,130,023$ | 3,390,069$ | 18000 | 100 | 21,555,000$ | 21,555,000$ | 0$ | 0$ | 0$ | 0$ | 21 | 0 | 0$ | 0$ | 2 | 0$ | 0$ | 0$ | 0$ | -10,000,000$ | 23,000,000$ | 23,000,000$ | 288,568,220$ | 288,568,220$ |
| 22 | Vancouver Canucks | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 18000 | 100 | 22,525,000$ | 22,525,000$ | 0$ | 0$ | 0$ | 0$ | 21 | 0 | 0$ | 0$ | 2 | 0$ | 0$ | 0$ | 0$ | -10,000,000$ | 23,000,000$ | 23,000,000$ | 254,209,089$ | 254,209,089$ |
| 23 | Washington Capitals | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 16116 | 12024 | 5139 | 10299 | 2625 | 89.53% | 80.16% | 85.65% | 85.83% | 87.50% | 38 | 15401 - 85.56% | 1,098,460$ | 3,295,380$ | 18000 | 100 | 21,450,000$ | 21,450,000$ | 0$ | 0$ | 0$ | 0$ | 20 | 0 | 0$ | 0$ | 2 | 0$ | 0$ | 0$ | 0$ | -10,000,000$ | 23,000,000$ | 23,000,000$ | 286,890,334$ | 286,890,334$ |
| 24 | Winnipeg Jets | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 10482 | 8610 | 3210 | 6998 | 1707 | 87.35% | 86.10% | 80.25% | 87.48% | 85.35% | 39 | 15504 - 86.13% | 1,096,750$ | 2,193,500$ | 18000 | 100 | 18,150,000$ | 18,150,000$ | 0$ | 0$ | 0$ | 0$ | 20 | 0 | 0$ | 0$ | 2 | 0$ | 0$ | 0$ | 0$ | -10,000,000$ | 23,000,000$ | 23,000,000$ | 269,414,245$ | 269,414,245$ |
Fort Wayne Komets
Hamilton Canucks
Indianapolis Checkers
Kansas City Blades
Manitoba Moose
Milwaukee Admirals
Moncton Golden Flames
New Haven Nighthawks
Nova Scotia Oilers
Peoria Rivermen
St. Catharines Saints
Baltimore Skipjacks
Binghamton Whalers
Fredericton Express
Hartford Wolf Pack
Maine Mariners
Philadelphia Phantoms
Providence Bruins
Rochester Americans
Sherbrooke Canadiens
Springfield Indians