| 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 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 | Arena 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 39,000,000$ | Maximum Salary Cap | Available Salary Cap | Current Bank Account | Projected Bank Account |
| 1 | Avalanche | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 70 | 40 | 30 | 200 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 40 | 0 - 0% | 0$ | 0$ | 18000 | 100 | 67,325,000$ | 67,325,000$ | 0$ | 0$ | 0$ | 0$ | 22 | 0 | 6,250,875$ | 0$ | 4 | 0$ | 0$ | 0$ | 0$ | -39,000,000$ | 116,712,144$ | 116,712,144$ | 44,212,144$ | 44,212,144$ |
| 2 | Blackhawks | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 70 | 40 | 30 | 200 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 40 | 0 - 0% | 0$ | 0$ | 18000 | 100 | 71,700,000$ | 71,700,000$ | 0$ | 0$ | 0$ | 0$ | 22 | 0 | 9,455,154$ | 0$ | 4 | 0$ | 0$ | 0$ | 0$ | -39,000,000$ | 84,036,631$ | 84,036,631$ | 11,536,631$ | 11,536,631$ |
| 3 | Blues | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 70 | 40 | 30 | 200 | 12000 | 10000 | 4000 | 8000 | 2000 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 38 | 18000 - 100.00% | 1,552,500$ | 3,105,000$ | 18000 | 100 | 71,100,000$ | 71,100,000$ | 0$ | 0$ | 0$ | 0$ | 22 | 0 | 7,379,362$ | 0$ | 4 | 0$ | 0$ | 0$ | 0$ | -39,000,000$ | 92,724,671$ | 92,724,671$ | 20,224,671$ | 20,224,671$ |
| 4 | Bruins | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 70 | 40 | 30 | 200 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 40 | 0 - 0% | 0$ | 0$ | 18000 | 100 | 71,300,000$ | 71,300,000$ | 0$ | 0$ | 0$ | 0$ | 21 | 0 | 10,535,147$ | 0$ | 4 | 0$ | 0$ | 0$ | 0$ | -39,000,000$ | 77,876,543$ | 77,876,543$ | 5,376,543$ | 5,376,543$ |
| 5 | Canadiens | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 70 | 40 | 30 | 200 | 66000 | 55000 | 22000 | 44000 | 11000 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 29 | 18000 - 100.00% | 1,552,500$ | 17,077,500$ | 18000 | 100 | 71,525,000$ | 71,525,000$ | 0$ | 0$ | 0$ | 0$ | 22 | 0 | 8,256,474$ | 0$ | 4 | 0$ | 0$ | 0$ | 0$ | -39,000,000$ | 94,835,355$ | 94,835,355$ | 22,335,355$ | 22,335,355$ |
| 6 | Canucks | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 70 | 40 | 30 | 200 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 40 | 0 - 0% | 0$ | 0$ | 18000 | 100 | 72,000,000$ | 72,000,000$ | 0$ | 0$ | 0$ | 0$ | 21 | 0 | 7,225,877$ | 0$ | 4 | 0$ | 0$ | 0$ | 0$ | -39,000,000$ | 76,059,754$ | 76,059,754$ | 3,559,754$ | 3,559,754$ |
| 7 | Capitals | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 70 | 40 | 30 | 200 | 24000 | 20000 | 8000 | 16000 | 4000 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 36 | 18000 - 100.00% | 1,552,500$ | 6,210,000$ | 18000 | 100 | 70,800,000$ | 70,800,000$ | 0$ | 0$ | 0$ | 0$ | 21 | 0 | 11,798,918$ | 0$ | 4 | 0$ | 0$ | 0$ | 0$ | -39,000,000$ | 85,147,192$ | 85,147,192$ | 12,647,192$ | 12,647,192$ |
| 8 | Devils | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 70 | 40 | 30 | 200 | 60000 | 50000 | 20000 | 40000 | 10000 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 30 | 18000 - 100.00% | 1,552,500$ | 15,525,000$ | 18000 | 100 | 68,650,000$ | 68,650,000$ | 0$ | 0$ | 0$ | 0$ | 23 | 0 | 4,221,778$ | 0$ | 4 | 0$ | 0$ | 0$ | 0$ | -39,000,000$ | 111,657,685$ | 111,657,685$ | 39,157,685$ | 39,157,685$ |
| 9 | Ducks | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 70 | 40 | 30 | 200 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 40 | 0 - 0% | 0$ | 0$ | 18000 | 100 | 70,500,000$ | 70,500,000$ | 0$ | 0$ | 0$ | 0$ | 20 | 0 | 11,076,892$ | 0$ | 4 | 0$ | 0$ | 0$ | 0$ | -39,000,000$ | 74,287,290$ | 74,287,290$ | 1,787,290$ | 1,787,290$ |
| 10 | Flames | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 70 | 40 | 30 | 200 | 18000 | 15000 | 6000 | 12000 | 3000 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 37 | 18000 - 100.00% | 1,552,500$ | 4,657,500$ | 18000 | 100 | 69,550,000$ | 69,550,000$ | 0$ | 0$ | 0$ | 0$ | 22 | 0 | 7,203,980$ | 0$ | 4 | 0$ | 0$ | 0$ | 0$ | -39,000,000$ | 85,952,537$ | 85,952,537$ | 13,452,537$ | 13,452,537$ |
| 11 | Islanders | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 70 | 40 | 30 | 200 | 42000 | 35000 | 14000 | 28000 | 7000 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 33 | 18000 - 100.00% | 1,552,500$ | 10,867,500$ | 18000 | 100 | 71,150,000$ | 71,150,000$ | 0$ | 0$ | 0$ | 0$ | 22 | 0 | 24,616,632$ | 0$ | 4 | 0$ | 0$ | 0$ | 0$ | -39,000,000$ | 83,318,284$ | 83,318,284$ | 10,818,284$ | 10,818,284$ |
| 12 | Jets | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 70 | 40 | 30 | 200 | 18000 | 15000 | 6000 | 12000 | 3000 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 37 | 18000 - 100.00% | 1,552,500$ | 4,657,500$ | 18000 | 100 | 68,200,000$ | 68,200,000$ | 0$ | 0$ | 0$ | 0$ | 20 | 0 | 7,467,053$ | 0$ | 4 | 0$ | 0$ | 0$ | 0$ | -39,000,000$ | 82,541,928$ | 82,541,928$ | 10,041,928$ | 10,041,928$ |
| 13 | Kraken | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 70 | 40 | 30 | 200 | 12000 | 10000 | 4000 | 7978 | 2000 | 100.00% | 100.00% | 100.00% | 99.73% | 100.00% | 38 | 17989 - 99.94% | 1,552,121$ | 3,104,241$ | 18000 | 100 | 72,900,000$ | 72,900,000$ | 0$ | 0$ | 0$ | 0$ | 21 | 0 | 8,942,605$ | 0$ | 4 | 0$ | 0$ | 0$ | 0$ | -39,000,000$ | 79,025,941$ | 79,025,941$ | 6,525,941$ | 6,525,941$ |
| 14 | Lightning | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 70 | 40 | 30 | 200 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 40 | 0 - 0% | 0$ | 0$ | 18000 | 100 | 50,600,000$ | 50,600,000$ | 0$ | 0$ | 0$ | 0$ | 22 | 0 | 0$ | 0$ | 4 | 0$ | 0$ | 0$ | 0$ | -39,000,000$ | 94,252,391$ | 94,252,391$ | 21,752,391$ | 21,752,391$ |
| 15 | Mammoth | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 70 | 40 | 30 | 200 | 18000 | 15000 | 6000 | 12000 | 3000 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 37 | 18000 - 100.00% | 1,552,500$ | 4,657,500$ | 18000 | 100 | 68,800,000$ | 68,800,000$ | 0$ | 0$ | 0$ | 0$ | 21 | 0 | 5,888,311$ | 0$ | 4 | 0$ | 0$ | 0$ | 0$ | -39,000,000$ | 88,286,671$ | 88,286,671$ | 15,786,671$ | 15,786,671$ |
| 16 | Maple Leafs | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 70 | 40 | 30 | 200 | 24000 | 20000 | 8000 | 16000 | 4000 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 36 | 18000 - 100.00% | 1,552,500$ | 6,210,000$ | 18000 | 100 | 70,725,000$ | 70,725,000$ | 0$ | 0$ | 0$ | 0$ | 21 | 0 | 7,788,721$ | 0$ | 4 | 0$ | 0$ | 0$ | 0$ | -39,000,000$ | 124,023,618$ | 124,023,618$ | 51,523,618$ | 51,523,618$ |
| 17 | Oilers | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 70 | 40 | 30 | 200 | 36000 | 30000 | 12000 | 24000 | 6000 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 34 | 18000 - 100.00% | 1,552,500$ | 9,315,000$ | 18000 | 100 | 69,950,000$ | 69,950,000$ | 0$ | 0$ | 0$ | 0$ | 23 | 0 | 8,548,845$ | 0$ | 4 | 0$ | 0$ | 0$ | 0$ | -39,000,000$ | 100,499,036$ | 100,499,036$ | 27,999,036$ | 27,999,036$ |
| 18 | Panthers | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 70 | 40 | 30 | 200 | 36000 | 30000 | 12000 | 23998 | 6000 | 100.00% | 100.00% | 100.00% | 99.99% | 100.00% | 34 | 18000 - 100.00% | 1,552,489$ | 9,314,931$ | 18000 | 100 | 70,175,000$ | 70,175,000$ | 0$ | 0$ | 0$ | 0$ | 21 | 0 | 6,370,663$ | 0$ | 4 | 0$ | 0$ | 0$ | 0$ | -39,000,000$ | 86,841,384$ | 86,841,384$ | 14,341,384$ | 14,341,384$ |
| 19 | Penguins | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 70 | 40 | 30 | 200 | 12000 | 10000 | 4000 | 8000 | 2000 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 38 | 18000 - 100.00% | 1,552,500$ | 3,105,000$ | 18000 | 100 | 70,000,000$ | 70,000,000$ | 0$ | 0$ | 0$ | 0$ | 20 | 0 | 7,247,775$ | 0$ | 4 | 0$ | 0$ | 0$ | 0$ | -39,000,000$ | 108,232,930$ | 108,232,930$ | 35,732,930$ | 35,732,930$ |
| 20 | Predators | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 70 | 40 | 30 | 200 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 40 | 0 - 0% | 0$ | 0$ | 18000 | 100 | 70,350,000$ | 70,350,000$ | 0$ | 0$ | 0$ | 0$ | 22 | 0 | 7,759,424$ | 0$ | 4 | 0$ | 0$ | 0$ | 0$ | -39,000,000$ | 73,295,738$ | 73,295,738$ | 795,738$ | 795,738$ |
| 21 | Rangers | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 70 | 40 | 30 | 200 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 40 | 0 - 0% | 0$ | 0$ | 18000 | 100 | 67,700,000$ | 67,700,000$ | 0$ | 0$ | 0$ | 0$ | 23 | 0 | 6,297,570$ | 0$ | 4 | 0$ | 0$ | 0$ | 0$ | -39,000,000$ | 128,126,071$ | 128,126,071$ | 55,626,071$ | 55,626,071$ |
| 22 | Red Wings | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 70 | 40 | 30 | 200 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 40 | 0 - 0% | 0$ | 0$ | 18000 | 100 | 66,150,000$ | 66,150,000$ | 0$ | 0$ | 0$ | 0$ | 21 | 0 | 7,584,042$ | 0$ | 4 | 0$ | 0$ | 0$ | 0$ | -39,000,000$ | 79,475,685$ | 79,475,685$ | 6,975,685$ | 6,975,685$ |
| 23 | Sabres | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 70 | 40 | 30 | 200 | 60000 | 50000 | 20000 | 40000 | 10000 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 30 | 18000 - 100.00% | 1,552,500$ | 15,525,000$ | 18000 | 100 | 69,875,000$ | 69,875,000$ | 0$ | 0$ | 0$ | 0$ | 23 | 0 | 21,452,954$ | 0$ | 4 | 0$ | 0$ | 0$ | 0$ | -39,000,000$ | 90,676,601$ | 90,676,601$ | 18,176,601$ | 18,176,601$ |
| 24 | Senateurs | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 70 | 40 | 30 | 200 | 54000 | 45000 | 18000 | 36000 | 9000 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 31 | 18000 - 100.00% | 1,552,500$ | 13,972,500$ | 18000 | 100 | 71,600,000$ | 71,600,000$ | 0$ | 0$ | 0$ | 0$ | 24 | 0 | 1,985,202$ | 0$ | 4 | 0$ | 0$ | 0$ | 0$ | -39,000,000$ | 96,838,862$ | 96,838,862$ | 24,338,862$ | 24,338,862$ |
| 25 | Sharks | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 70 | 40 | 30 | 200 | 30000 | 25000 | 10000 | 20000 | 4996 | 100.00% | 100.00% | 100.00% | 100.00% | 99.92% | 35 | 17999 - 100.00% | 1,552,316$ | 7,761,580$ | 18000 | 100 | 71,338,888$ | 71,338,888$ | 0$ | 0$ | 0$ | 0$ | 22 | 0 | 8,425,457$ | 0$ | 4 | 0$ | 0$ | 0$ | 0$ | -39,000,000$ | 88,262,973$ | 88,262,973$ | 15,762,973$ | 15,762,973$ |
| 26 | Stars | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 70 | 40 | 30 | 200 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 40 | 0 - 0% | 0$ | 0$ | 18000 | 100 | 69,700,000$ | 69,700,000$ | 0$ | 0$ | 0$ | 0$ | 24 | 0 | 7,759,424$ | 0$ | 4 | 0$ | 0$ | 0$ | 0$ | -39,000,000$ | 80,806,578$ | 80,806,578$ | 8,306,578$ | 8,306,578$ |
Admirals
Americans
Bears
Canucks
Condors
Icehogs
Islander
Little Stars
Moose
Punishers
Roadrunners
Senators
Thunderbirds
Barracuda
Checkers
Comets
Crunch
Eagles
Firebirds
Griffins
Gulls
Marlies
Penguins
Rockets
Wolfpack
Wranglers