| 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 Average Salaries | 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 0$ | Maximum Salary Cap | Available Salary Cap | Current Bank Account | Projected Bank Account |
| 1 | Barons | 6000 | 5000 | 2000 | 4000 | 1000 | 30 | 20 | 10 | 5 | 60 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 39 | 0 - 0.00% | 0$ | 0$ | 18000 | 100 | 3,596,500$ | 3,596,500$ | 260,200$ | 0$ | 0$ | 0$ | 23 | 0 | 7,862,742$ | 0$ | 10 | 0$ | 0$ | 0$ | 0$ | 0$ | 5,000,000$ | 5,000,000$ | 198,962,310$ | 198,962,310$ |
| 2 | Blackhawks | 6000 | 5000 | 2000 | 4000 | 1000 | 30 | 20 | 10 | 9 | 60 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 39 | 0 - 0.00% | 0$ | 0$ | 18000 | 100 | 3,474,500$ | 3,474,500$ | 141,267$ | 0$ | 0$ | 0$ | 20 | 0 | 9,388,785$ | 0$ | 10 | 0$ | 0$ | 0$ | 0$ | 0$ | 5,000,000$ | 5,000,000$ | 209,045,635$ | 209,045,635$ |
| 3 | Blues | 6000 | 5000 | 2000 | 4000 | 1000 | 29 | 14 | 11 | 6 | 49 | 18000 | 15000 | 5590 | 10783 | 3000 | 100.00% | 100.00% | 93.17% | 89.86% | 100.00% | 36 | 17458 - 96.99% | 284,803$ | 854,409$ | 18000 | 100 | 2,950,500$ | 2,950,500$ | 101,700$ | 0$ | 0$ | 0$ | 23 | 0 | 5,900,127$ | 0$ | 10 | 0$ | 0$ | 0$ | 0$ | 0$ | 5,000,000$ | 5,000,000$ | 202,331,503$ | 202,331,503$ |
| 4 | Bruins | 6000 | 5000 | 2000 | 4000 | 1000 | 32 | 21 | 12 | 6 | 75 | 18000 | 15000 | 5919 | 12000 | 2761 | 100.00% | 100.00% | 98.65% | 100.00% | 92.03% | 36 | 17893 - 99.41% | 351,646$ | 1,054,939$ | 18000 | 100 | 2,689,000$ | 2,689,000$ | 178,567$ | 0$ | 0$ | 0$ | 23 | 0 | 5,407,350$ | 0$ | 10 | 0$ | 0$ | 0$ | 0$ | 0$ | 5,000,000$ | 5,000,000$ | 217,990,667$ | 217,990,667$ |
| 5 | Canadiens | 6000 | 5000 | 2000 | 4000 | 1000 | 30 | 20 | 10 | 5 | 60 | 30000 | 25000 | 10000 | 20000 | 5000 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 34 | 18000 - 100.00% | 323,000$ | 1,615,000$ | 18000 | 100 | 3,188,000$ | 3,188,000$ | 157,650$ | 0$ | 0$ | 0$ | 23 | 0 | 6,676,212$ | 0$ | 10 | 0$ | 0$ | 0$ | 0$ | 0$ | 5,000,000$ | 5,000,000$ | 203,560,006$ | 203,560,006$ |
| 6 | Canucks | 6000 | 5000 | 2000 | 4000 | 1000 | 38 | 28 | 18 | 8 | 88 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 39 | 0 - 0.00% | 0$ | 0$ | 18000 | 100 | 2,967,500$ | 2,967,500$ | 143,700$ | 0$ | 0$ | 0$ | 23 | 0 | 5,812,926$ | 0$ | 10 | 0$ | 0$ | 0$ | 0$ | 0$ | 5,000,000$ | 5,000,000$ | 203,156,309$ | 203,156,309$ |
| 7 | Capitals | 6000 | 5000 | 2000 | 4000 | 1000 | 35 | 25 | 15 | 7 | 65 | 35518 | 29766 | 10902 | 22864 | 5978 | 98.66% | 99.22% | 90.85% | 95.27% | 99.63% | 33 | 17505 - 97.25% | 382,419$ | 2,294,512$ | 18000 | 100 | 2,678,000$ | 2,678,000$ | 367,800$ | 0$ | 0$ | 0$ | 20 | 0 | 5,476,737$ | 0$ | 10 | 0$ | 0$ | 0$ | 0$ | 0$ | 5,000,000$ | 5,000,000$ | 206,185,740$ | 206,185,740$ |
| 8 | Flyers | 6000 | 5000 | 2000 | 4000 | 1000 | 30 | 20 | 10 | 9 | 60 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 39 | 0 - 0.00% | 0$ | 0$ | 18000 | 100 | 2,073,500$ | 2,073,500$ | 142,100$ | 0$ | 0$ | 0$ | 24 | 0 | 3,661,350$ | 0$ | 10 | 0$ | 0$ | 0$ | 0$ | 0$ | 5,000,000$ | 5,000,000$ | 207,254,501$ | 207,254,501$ |
| 9 | Golden Seals | 6000 | 5000 | 2000 | 4000 | 1000 | 30 | 20 | 10 | 5 | 60 | 12000 | 10000 | 4000 | 8000 | 2000 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 37 | 18000 - 100.00% | 323,000$ | 646,000$ | 18000 | 100 | 3,737,427$ | 3,737,427$ | 297,650$ | 0$ | 0$ | 0$ | 22 | 0 | 8,558,622$ | 0$ | 10 | 0$ | 0$ | 0$ | 0$ | 0$ | 5,000,000$ | 5,000,000$ | 205,504,911$ | 205,504,911$ |
| 10 | Islanders | 6000 | 5000 | 2000 | 4000 | 1000 | 30 | 20 | 10 | 5 | 60 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 39 | 0 - 0.00% | 0$ | 0$ | 18000 | 100 | 2,608,500$ | 2,608,500$ | 376,700$ | 0$ | 0$ | 0$ | 21 | 0 | 5,062,293$ | 0$ | 10 | 0$ | 0$ | 0$ | 0$ | 0$ | 5,000,000$ | 5,000,000$ | 165,446,364$ | 165,446,364$ |
| 11 | Kings | 6000 | 5000 | 2000 | 4000 | 1000 | 30 | 20 | 10 | 5 | 60 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 39 | 0 - 0.00% | 0$ | 0$ | 18000 | 100 | 2,441,000$ | 2,441,000$ | 80,500$ | 0$ | 0$ | 0$ | 21 | 0 | 4,844,856$ | 0$ | 10 | 0$ | 0$ | 0$ | 0$ | 0$ | 5,000,000$ | 5,000,000$ | 138,556,072$ | 138,556,072$ |
| 12 | Maple Leafs | 6000 | 5000 | 2000 | 4000 | 1000 | 40 | 28 | 15 | 8 | 70 | 11634 | 8919 | 3543 | 6821 | 1958 | 96.95% | 89.19% | 88.58% | 85.26% | 97.90% | 37 | 16438 - 91.32% | 407,943$ | 815,885$ | 18000 | 100 | 2,862,000$ | 2,862,000$ | 433,200$ | 0$ | 0$ | 0$ | 23 | 0 | 5,937,468$ | 0$ | 10 | 0$ | 0$ | 0$ | 0$ | 0$ | 5,000,000$ | 5,000,000$ | 205,664,050$ | 205,664,050$ |
| 13 | North Stars | 6000 | 5000 | 2000 | 4000 | 1000 | 30 | 20 | 10 | 5 | 45 | 24000 | 20000 | 8000 | 16000 | 4000 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 35 | 18000 - 100.00% | 310,250$ | 1,241,000$ | 18000 | 100 | 2,905,000$ | 2,905,000$ | 286,300$ | 0$ | 0$ | 0$ | 23 | 0 | 6,185,376$ | 0$ | 10 | 0$ | 0$ | 0$ | 0$ | 0$ | 5,000,000$ | 5,000,000$ | 204,104,923$ | 204,104,923$ |
| 14 | Oilers | 6000 | 5000 | 2000 | 4000 | 1000 | 30 | 20 | 10 | 5 | 60 | 30000 | 25000 | 10000 | 20000 | 5000 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 34 | 18000 - 100.00% | 323,000$ | 1,615,000$ | 18000 | 100 | 3,161,000$ | 3,161,000$ | 109,967$ | 0$ | 0$ | 0$ | 22 | 0 | 6,955,116$ | 0$ | 10 | 0$ | 0$ | 0$ | 0$ | 0$ | 5,000,000$ | 5,000,000$ | 212,900,482$ | 212,900,482$ |
| 15 | Rangers | 6000 | 5000 | 2000 | 4000 | 1000 | 30 | 20 | 10 | 5 | 60 | 12000 | 10000 | 4000 | 8000 | 2000 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 37 | 18000 - 100.00% | 323,000$ | 646,000$ | 18000 | 100 | 2,453,000$ | 2,453,000$ | 189,900$ | 0$ | 0$ | 0$ | 22 | 0 | 4,829,763$ | 0$ | 10 | 0$ | 0$ | 0$ | 0$ | 0$ | 5,000,000$ | 5,000,000$ | 207,985,609$ | 207,985,609$ |
| 16 | Red Wings | 6000 | 5000 | 2000 | 4000 | 1000 | 34 | 15 | 3 | 1 | 62 | 12000 | 10000 | 4000 | 8000 | 2000 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 37 | 18000 - 100.00% | 298,350$ | 596,700$ | 18000 | 100 | 3,492,000$ | 3,492,000$ | 24,667$ | 0$ | 0$ | 0$ | 23 | 0 | 7,788,969$ | 0$ | 10 | 0$ | 0$ | 0$ | 0$ | 0$ | 5,000,000$ | 5,000,000$ | 207,305,937$ | 207,305,937$ |
| 17 | Sabres | 6000 | 5000 | 2000 | 4000 | 1000 | 32 | 22 | 10 | 7 | 65 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 39 | 0 - 0.00% | 0$ | 0$ | 18000 | 100 | 2,511,000$ | 2,511,000$ | 88,100$ | 0$ | 0$ | 0$ | 21 | 0 | 4,896,342$ | 0$ | 10 | 0$ | 0$ | 0$ | 0$ | 0$ | 5,000,000$ | 5,000,000$ | 207,899,424$ | 207,899,424$ |
| 18 | Scouts | 6000 | 5000 | 2000 | 4000 | 1000 | 30 | 20 | 10 | 5 | 60 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 39 | 0 - 0.00% | 0$ | 0$ | 18000 | 100 | 2,360,500$ | 2,360,500$ | 15,900$ | 0$ | 0$ | 0$ | 20 | 0 | 5,185,353$ | 0$ | 10 | 0$ | 0$ | 0$ | 0$ | 0$ | 5,000,000$ | 5,000,000$ | 208,456,404$ | 208,456,404$ |
Americans
Bears
Brass
Bulls
Canadiens
Cougars
Generals
Golden Gophers
Grizzlies
Growlers
Marlboros
Mooseheads
Nailers
Rush
Stingers
Thunderbirds
Tigers
Wolves