| 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 58,500,000$ | Maximum Salary Cap | Available Salary Cap | Current Bank Account | Projected Bank Account |
| 1 | Avalanche | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 65 | 42 | 30 | 150 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 7 | 0 - 0% | 0$ | 0$ | 18000 | 100 | 60,541,501$ | 56,897,474$ | 0$ | 0$ | 0$ | 0$ | 20 | 0 | 0$ | 0$ | 23 | 0$ | 0$ | 0$ | 0$ | -58,500,000$ | 74,500,000$ | 74,500,000$ | 101,724,311$ | 101,724,311$ |
| 2 | Blackhawks | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 20 | 125 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 7 | 0 - 0% | 0$ | 0$ | 18000 | 100 | 46,708,762$ | 43,508,429$ | 0$ | 0$ | 0$ | 0$ | 20 | 0 | 0$ | 0$ | 23 | 0$ | 0$ | 0$ | 0$ | -58,500,000$ | 74,500,000$ | 74,500,000$ | 94,687,277$ | 94,687,277$ |
| 3 | Blue Jackets | 6000 | 5000 | 2000 | 4000 | 1000 | 90 | 62 | 30 | 15 | 170 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 7 | 0 - 0% | 0$ | 0$ | 18000 | 100 | 58,578,912$ | 52,909,787$ | 0$ | 0$ | 0$ | 0$ | 20 | 0 | 0$ | 0$ | 23 | 0$ | 0$ | 0$ | 0$ | -58,500,000$ | 74,500,000$ | 74,500,000$ | 129,894,909$ | 129,894,909$ |
| 4 | Blues | 6000 | 5000 | 2000 | 4000 | 1000 | 91 | 55 | 40 | 18 | 170 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 7 | 0 - 0% | 0$ | 0$ | 18000 | 100 | 56,285,000$ | 60,610,000$ | 0$ | 0$ | 0$ | 0$ | 20 | 0 | 0$ | 0$ | 23 | 0$ | 0$ | 0$ | 0$ | -58,500,000$ | 74,500,000$ | 74,500,000$ | 239,479,255$ | 239,479,255$ |
| 5 | Bruins | 7000 | 6000 | 3000 | 5000 | 1000 | 150 | 75 | 50 | 25 | 200 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 7 | 0 - 0% | 0$ | 0$ | 22000 | 100 | 47,241,000$ | 38,663,653$ | 0$ | 0$ | 0$ | 0$ | 20 | 0 | 0$ | 0$ | 23 | 0$ | 0$ | 0$ | 0$ | -58,500,000$ | 74,500,000$ | 74,500,000$ | 150,459,419$ | 150,459,419$ |
| 6 | Canadiens | 6000 | 5000 | 2000 | 4000 | 1000 | 85 | 58 | 39 | 27 | 135 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 7 | 0 - 0% | 0$ | 0$ | 18000 | 100 | 46,242,756$ | 41,856,756$ | 0$ | 0$ | 0$ | 0$ | 20 | 0 | 0$ | 0$ | 23 | 0$ | 0$ | 0$ | 0$ | -58,500,000$ | 74,500,000$ | 74,500,000$ | 71,324,423$ | 71,324,423$ |
| 7 | Canucks | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 55 | 35 | 20 | 200 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 7 | 0 - 0% | 0$ | 0$ | 18000 | 100 | 30,086,533$ | 29,286,614$ | 0$ | 0$ | 0$ | 0$ | 21 | 0 | 0$ | 0$ | 23 | 0$ | 0$ | 0$ | 0$ | -58,500,000$ | 74,500,000$ | 74,500,000$ | 20,610,804$ | 20,610,804$ |
| 8 | Capitals | 7000 | 6000 | 3500 | 4000 | 1500 | 80 | 60 | 35 | 25 | 200 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 7 | 0 - 0% | 0$ | 0$ | 22000 | 100 | 65,795,999$ | 53,717,155$ | 0$ | 0$ | 0$ | 0$ | 20 | 0 | 0$ | 0$ | 23 | 0$ | 0$ | 0$ | 0$ | -58,500,000$ | 74,500,000$ | 74,500,000$ | 117,078,871$ | 117,078,871$ |
| 9 | Coyotes | 6000 | 5000 | 2000 | 4000 | 1000 | 110 | 67 | 45 | 27 | 200 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 7 | 0 - 0% | 0$ | 0$ | 18000 | 100 | 33,797,946$ | 33,797,946$ | 0$ | 0$ | 0$ | 0$ | 20 | 0 | 0$ | 0$ | 23 | 0$ | 0$ | 0$ | 0$ | -58,500,000$ | 74,500,000$ | 74,500,000$ | 88,670,033$ | 88,670,033$ |
| 10 | Devils | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 20 | 200 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 7 | 0 - 0% | 0$ | 0$ | 18000 | 100 | 63,765,240$ | 61,782,240$ | 750,000$ | 0$ | 0$ | 0$ | 18 | 0 | 0$ | 0$ | 23 | 0$ | 0$ | 0$ | 0$ | -58,500,000$ | 74,500,000$ | 74,500,000$ | 22,641,705$ | 22,641,705$ |
| 11 | Ducks | 6000 | 5000 | 2000 | 4000 | 1000 | 90 | 70 | 40 | 25 | 180 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 7 | 0 - 0% | 0$ | 0$ | 18000 | 100 | 52,516,000$ | 50,365,090$ | 0$ | 0$ | 0$ | 0$ | 20 | 0 | 0$ | 0$ | 23 | 0$ | 0$ | 0$ | 0$ | -58,500,000$ | 74,500,000$ | 74,500,000$ | 125,917,983$ | 125,917,983$ |
| 12 | Flames | 6000 | 5000 | 2000 | 4000 | 1000 | 85 | 60 | 45 | 30 | 120 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 7 | 0 - 0% | 0$ | 0$ | 18000 | 100 | 67,149,612$ | 64,603,757$ | 0$ | 0$ | 0$ | 0$ | 21 | 0 | 0$ | 0$ | 23 | 0$ | 0$ | 0$ | 0$ | -58,500,000$ | 74,500,000$ | 74,500,000$ | 45,528,008$ | 45,528,008$ |
| 13 | Flyers | 6000 | 5000 | 2000 | 4000 | 1000 | 75 | 40 | 30 | 20 | 300 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 7 | 0 - 0% | 0$ | 0$ | 18000 | 100 | 29,639,488$ | 28,816,488$ | 2,250,000$ | 0$ | 0$ | 0$ | 20 | 0 | 0$ | 0$ | 23 | 0$ | 0$ | 0$ | 0$ | -58,500,000$ | 74,500,000$ | 74,500,000$ | 64,866,490$ | 64,866,490$ |
| 14 | Golden Knights | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 7 | 0 - 0% | 0$ | 0$ | 18000 | 100 | 52,927,124$ | 55,290,336$ | 0$ | 0$ | 0$ | 0$ | 20 | 0 | 0$ | 0$ | 23 | 0$ | 0$ | 0$ | 0$ | -58,500,000$ | 74,500,000$ | 74,500,000$ | 28,113,756$ | 28,113,756$ |
| 15 | Islanders | 6000 | 5000 | 2000 | 4000 | 1000 | 90 | 70 | 50 | 20 | 125 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 7 | 0 - 0% | 0$ | 0$ | 18000 | 100 | 74,083,000$ | 61,660,069$ | 0$ | 0$ | 0$ | 0$ | 22 | 0 | 0$ | 0$ | 23 | 0$ | 0$ | 0$ | 0$ | -58,500,000$ | 74,500,000$ | 74,500,000$ | 114,053,535$ | 114,053,535$ |
| 16 | Jets | 6000 | 5000 | 2000 | 4000 | 1000 | 85 | 45 | 35 | 15 | 165 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 7 | 0 - 0% | 0$ | 0$ | 18000 | 100 | 44,552,000$ | 42,466,000$ | 0$ | 0$ | 0$ | 0$ | 20 | 0 | 0$ | 0$ | 23 | 0$ | 0$ | 0$ | 0$ | -58,500,000$ | 74,500,000$ | 74,500,000$ | 4,472,609$ | 4,472,609$ |
| 17 | Kings | 6000 | 5000 | 2000 | 4000 | 1000 | 80 | 50 | 30 | 15 | 140 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 7 | 0 - 0% | 0$ | 0$ | 18000 | 100 | 61,278,890$ | 57,375,810$ | 0$ | 0$ | 0$ | 0$ | 20 | 0 | 0$ | 0$ | 23 | 0$ | 0$ | 0$ | 0$ | -58,500,000$ | 74,500,000$ | 74,500,000$ | 28,153,868$ | 28,153,868$ |
| 18 | Lightning | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 20 | 200 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 7 | 0 - 0% | 0$ | 0$ | 18000 | 100 | 63,986,333$ | 57,910,333$ | 0$ | 0$ | 0$ | 0$ | 20 | 0 | 0$ | 0$ | 23 | 0$ | 0$ | 0$ | 0$ | -58,500,000$ | 74,500,000$ | 74,500,000$ | 76,653,604$ | 76,653,604$ |
| 19 | Maple Leafs | 6000 | 5000 | 2000 | 4000 | 1000 | 91 | 60 | 42 | 19 | 145 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 7 | 0 - 0% | 0$ | 0$ | 18000 | 100 | 64,221,000$ | 62,812,333$ | 0$ | 0$ | 0$ | 0$ | 20 | 0 | 0$ | 0$ | 23 | 0$ | 0$ | 0$ | 0$ | -58,500,000$ | 74,500,000$ | 74,500,000$ | 79,944,855$ | 79,944,855$ |
| 20 | Oilers | 7000 | 6000 | 3500 | 4000 | 1500 | 88 | 62 | 45 | 22 | 125 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 7 | 0 - 0% | 0$ | 0$ | 22000 | 100 | 48,079,417$ | 42,663,339$ | 0$ | 0$ | 0$ | 0$ | 20 | 0 | 0$ | 0$ | 23 | 0$ | 0$ | 0$ | 0$ | -58,500,000$ | 74,500,000$ | 74,500,000$ | 148,443,171$ | 148,443,171$ |
| 21 | Panthers | 6000 | 5000 | 2000 | 4000 | 1000 | 102 | 62 | 37 | 22 | 200 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 7 | 0 - 0% | 0$ | 0$ | 18000 | 100 | 43,366,330$ | 46,077,830$ | 0$ | 0$ | 0$ | 0$ | 20 | 0 | 0$ | 0$ | 23 | 0$ | 0$ | 0$ | 0$ | -58,500,000$ | 74,500,000$ | 74,500,000$ | 78,492,265$ | 78,492,265$ |
| 22 | Penguins | 6000 | 5000 | 2000 | 4000 | 1000 | 125 | 65 | 35 | 25 | 225 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 7 | 0 - 0% | 0$ | 0$ | 18000 | 100 | 24,996,824$ | 24,477,210$ | 0$ | 0$ | 0$ | 0$ | 20 | 0 | 0$ | 0$ | 23 | 0$ | 0$ | 0$ | 0$ | -58,500,000$ | 74,500,000$ | 74,500,000$ | 50,594,217$ | 50,594,217$ |
| 23 | Predators | 6000 | 5000 | 2000 | 4000 | 1000 | 72 | 65 | 35 | 25 | 170 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 7 | 0 - 0% | 0$ | 0$ | 18000 | 100 | 46,083,975$ | 48,367,975$ | 0$ | 0$ | 0$ | 0$ | 20 | 0 | 0$ | 0$ | 23 | 0$ | 0$ | 0$ | 0$ | -58,500,000$ | 74,500,000$ | 74,500,000$ | 27,985,591$ | 27,985,591$ |
| 24 | Rangers | 6000 | 5000 | 2000 | 4000 | 1000 | 102 | 55 | 40 | 25 | 205 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 7 | 0 - 0% | 0$ | 0$ | 18000 | 100 | 43,037,861$ | 43,785,861$ | 0$ | 0$ | 0$ | 0$ | 20 | 0 | 0$ | 0$ | 23 | 0$ | 0$ | 0$ | 0$ | -58,500,000$ | 74,500,000$ | 74,500,000$ | 133,808,438$ | 133,808,438$ |
| 25 | Red Wings | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 20 | 200 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 7 | 0 - 0% | 0$ | 0$ | 18000 | 100 | 56,665,393$ | 53,293,649$ | 0$ | 0$ | 0$ | 0$ | 20 | 0 | 0$ | 0$ | 23 | 0$ | 0$ | 0$ | 0$ | -58,500,000$ | 74,500,000$ | 74,500,000$ | 159,885,473$ | 159,885,473$ |
| 26 | Sabres | 6000 | 5000 | 2000 | 4000 | 1000 | 118 | 95 | 70 | 50 | 200 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 7 | 0 - 0% | 0$ | 0$ | 18000 | 100 | 41,460,281$ | 39,120,781$ | 0$ | 0$ | 0$ | 0$ | 20 | 0 | 0$ | 0$ | 23 | 0$ | 0$ | 0$ | 0$ | -58,500,000$ | 74,500,000$ | 74,500,000$ | 99,853,695$ | 99,853,695$ |
| 27 | Senators | 6000 | 5000 | 2000 | 4000 | 1000 | 90 | 55 | 35 | 20 | 180 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 7 | 0 - 0% | 0$ | 0$ | 18000 | 100 | 78,500,341$ | 71,480,929$ | 0$ | 0$ | 0$ | 0$ | 21 | 0 | 0$ | 0$ | 23 | 0$ | 0$ | 0$ | 0$ | -58,500,000$ | 74,500,000$ | 74,500,000$ | 142,947,775$ | 142,947,775$ |
| 28 | Sharks | 6000 | 5000 | 2000 | 4000 | 1000 | 75 | 50 | 35 | 20 | 125 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 7 | 0 - 0% | 0$ | 0$ | 18000 | 100 | 64,733,702$ | 49,652,420$ | -3,000,000$ | 0$ | 0$ | 0$ | 20 | 0 | 0$ | 0$ | 23 | 0$ | 0$ | 0$ | 0$ | -58,500,000$ | 74,500,000$ | 74,500,000$ | 158,522,547$ | 158,522,547$ |
| 29 | Stars | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 20 | 200 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 7 | 0 - 0% | 0$ | 0$ | 18000 | 100 | 57,513,594$ | 50,992,594$ | 0$ | 0$ | 0$ | 0$ | 21 | 0 | 0$ | 0$ | 23 | 0$ | 0$ | 0$ | 0$ | -58,500,000$ | 74,500,000$ | 74,500,000$ | 131,527,253$ | 131,527,253$ |
| 30 | Whalers | 6000 | 5000 | 2000 | 4000 | 1000 | 110 | 65 | 40 | 24 | 212 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 7 | 0 - 0% | 0$ | 0$ | 18000 | 100 | 60,942,333$ | 50,845,130$ | 0$ | 0$ | 0$ | 0$ | 21 | 0 | 0$ | 0$ | 23 | 0$ | 0$ | 0$ | 0$ | -58,500,000$ | 74,500,000$ | 74,500,000$ | 111,877,052$ | 111,877,052$ |
| 31 | Wild | 6000 | 5000 | 2000 | 4000 | 1000 | 80 | 50 | 35 | 20 | 400 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 7 | 0 - 0% | 0$ | 0$ | 18000 | 100 | 66,728,500$ | 45,046,248$ | 0$ | 0$ | 0$ | 0$ | 22 | 0 | 0$ | 0$ | 23 | 0$ | 0$ | 0$ | 0$ | -58,500,000$ | 74,500,000$ | 74,500,000$ | 172,646,643$ | 172,646,643$ |
Barracuda
Bruins
Canucks
Comets
Condors
Crunch
Gulls
IceHogs
Monsters
Rocket
Senators
Wild
Wolf Pack
Wolves
Admirals
Americans
Bears
Checkers
Eagles
Griffins
Heat
Islanders
Marlies
Moose
Phantoms
Reign
Roadrunners
Stars
Thunderbirds