| 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 0$ | Maximum Salary Cap | Available Salary Cap | Current Bank Account | Projected Bank Account |
| 1 | Blackhawks | 6000 | 5000 | 2000 | 4000 | 1000 | 75 | 50 | 30 | 20 | 750 | 23531 | 20576 | 8041 | 16310 | 3986 | 78.44% | 82.30% | 80.41% | 81.55% | 79.72% | 33 | 14489 - 80.49% | 1,079,594$ | 5,397,972$ | 18000 | 100 | 4,155,943$ | 4,155,943$ | 94,869$ | 482,202$ | 4,155,943$ | 456,249$ | 25 | 0 | 849,537$ | 35,626,615$ | 181 | 20,942$ | 3,790,502$ | 3,977,342$ | 4,272,043$ | 4,272,043$ | 5,500,000$ | 1,227,957$ | 196,792,939$ | 230,675,102$ |
| 2 | Bruins | 6000 | 5000 | 2000 | 4000 | 1000 | 75 | 50 | 30 | 20 | 750 | 23750 | 19527 | 8254 | 16229 | 3998 | 79.17% | 78.11% | 82.54% | 81.15% | 79.96% | 33 | 14352 - 79.73% | 1,075,811$ | 5,379,054$ | 18000 | 100 | 4,248,700$ | 4,248,700$ | 114,024$ | 577,476$ | 4,248,700$ | 551,502$ | 28 | 0 | 1,135,296$ | 35,501,756$ | 181 | 21,388$ | 3,871,228$ | 4,078,828$ | 4,388,720$ | 4,388,720$ | 5,500,000$ | 1,111,280$ | 156,771,302$ | 189,744,282$ |
| 3 | Canadiens | 6000 | 5000 | 2000 | 4000 | 1000 | 75 | 50 | 30 | 20 | 750 | 24849 | 19416 | 7969 | 16034 | 3925 | 82.83% | 77.66% | 79.69% | 80.17% | 78.50% | 33 | 14439 - 80.21% | 1,077,456$ | 5,387,278$ | 18000 | 100 | 3,520,290$ | 3,520,290$ | 81,381$ | 512,025$ | 3,520,290$ | 486,051$ | 28 | 0 | 938,943$ | 35,556,035$ | 181 | 17,886$ | 3,237,366$ | 3,402,062$ | 3,610,618$ | 3,610,618$ | 5,500,000$ | 1,889,382$ | 178,116,100$ | 211,879,879$ |
| 4 | Canucks | 6000 | 5000 | 2000 | 4000 | 1000 | 75 | 50 | 30 | 20 | 750 | 23647 | 20756 | 7739 | 16302 | 3776 | 78.82% | 83.02% | 77.39% | 81.51% | 75.52% | 33 | 14444 - 80.24% | 1,054,261$ | 5,271,306$ | 18000 | 100 | 4,437,260$ | 4,437,260$ | 139,635$ | 601,965$ | 4,437,260$ | 575,991$ | 27 | 0 | 1,208,763$ | 34,790,620$ | 181 | 22,295$ | 4,035,395$ | 4,203,724$ | 4,531,788$ | 4,531,788$ | 5,500,000$ | 968,212$ | 211,840,236$ | 244,003,491$ |
| 5 | Flames | 6000 | 5000 | 2000 | 4000 | 1000 | 75 | 50 | 30 | 20 | 750 | 23966 | 19300 | 8330 | 15869 | 3886 | 79.89% | 77.20% | 83.30% | 79.35% | 77.72% | 33 | 14270 - 79.28% | 1,061,519$ | 5,307,595$ | 18000 | 100 | 2,932,600$ | 2,932,600$ | 124,801$ | 403,167$ | 2,932,600$ | 377,217$ | 25 | 0 | 612,441$ | 35,030,127$ | 181 | 15,061$ | 2,726,041$ | 2,909,594$ | 3,044,752$ | 3,044,752$ | 5,500,000$ | 2,455,248$ | 189,554,315$ | 223,194,257$ |
| 6 | Flyers | 6000 | 5000 | 2000 | 4000 | 1000 | 75 | 50 | 30 | 20 | 750 | 23785 | 21025 | 7750 | 15860 | 3890 | 79.28% | 84.10% | 77.50% | 79.30% | 77.80% | 33 | 14462 - 80.34% | 1,071,395$ | 5,356,976$ | 18000 | 100 | 4,284,800$ | 4,284,800$ | 79,206$ | 582,174$ | 4,284,800$ | 556,200$ | 36 | 0 | 1,149,390$ | 35,356,042$ | 181 | 21,562$ | 3,902,722$ | 4,118,280$ | 4,434,000$ | 4,434,000$ | 5,500,000$ | 1,066,000$ | 187,822,076$ | 220,687,766$ |
| 7 | Islanders | 6000 | 5000 | 2000 | 4000 | 1000 | 75 | 50 | 30 | 20 | 750 | 24551 | 20052 | 8072 | 15695 | 3939 | 81.84% | 80.21% | 80.72% | 78.48% | 78.78% | 33 | 14462 - 80.34% | 1,080,220$ | 5,401,101$ | 18000 | 100 | 4,445,360$ | 4,445,360$ | 39,159$ | 602,991$ | 4,445,360$ | 577,044$ | 27 | 0 | 1,211,922$ | 35,647,267$ | 181 | 22,333$ | 4,042,273$ | 4,205,931$ | 4,534,460$ | 4,534,460$ | 5,500,000$ | 965,540$ | 172,637,825$ | 206,530,519$ |
| 8 | Maple Leafs | 6000 | 5000 | 2000 | 4000 | 1000 | 75 | 50 | 30 | 20 | 750 | 28272 | 23561 | 9820 | 19320 | 4716 | 78.53% | 78.54% | 81.83% | 80.50% | 78.60% | 32 | 14282 - 79.34% | 1,064,831$ | 6,388,983$ | 18000 | 100 | 1,863,000$ | 1,863,000$ | 65,084$ | 267,354$ | 1,863,000$ | 241,398$ | 23 | 0 | 204,984$ | 34,074,576$ | 181 | 9,918$ | 1,795,158$ | 1,982,863$ | 1,980,000$ | 1,980,000$ | 5,500,000$ | 3,520,000$ | 210,215,966$ | 244,725,028$ |
| 9 | Oilers | 6000 | 5000 | 2000 | 4000 | 1000 | 75 | 50 | 30 | 20 | 750 | 29344 | 23299 | 9303 | 18991 | 4674 | 81.51% | 77.66% | 77.53% | 79.13% | 77.90% | 32 | 14269 - 79.27% | 1,066,773$ | 6,400,635$ | 18000 | 100 | 3,927,807$ | 3,927,807$ | 101,296$ | 576,606$ | 3,927,807$ | 550,638$ | 25 | 0 | 1,132,704$ | 34,136,720$ | 181 | 19,845$ | 3,591,945$ | 3,768,751$ | 4,032,207$ | 4,032,207$ | 5,500,000$ | 1,467,793$ | 162,205,396$ | 194,941,856$ |
| 10 | Penguins | 6000 | 5000 | 2000 | 4000 | 1000 | 75 | 50 | 30 | 20 | 750 | 24529 | 19758 | 8099 | 15214 | 3786 | 81.76% | 79.03% | 80.99% | 76.07% | 75.72% | 33 | 14277 - 79.32% | 1,056,435$ | 5,282,177$ | 18000 | 100 | 3,862,110$ | 3,862,110$ | 136,085$ | 527,283$ | 3,862,110$ | 501,336$ | 27 | 0 | 984,798$ | 34,862,368$ | 181 | 19,529$ | 3,534,749$ | 3,705,154$ | 3,959,110$ | 3,959,110$ | 5,500,000$ | 1,540,890$ | 150,172,344$ | 183,664,889$ |
| 11 | Rangers | 6000 | 5000 | 2000 | 4000 | 1000 | 75 | 50 | 30 | 20 | 750 | 23149 | 20050 | 7926 | 15287 | 3910 | 77.16% | 80.20% | 79.26% | 76.44% | 78.20% | 33 | 14064 - 78.14% | 1,056,498$ | 5,282,491$ | 18000 | 100 | 3,625,440$ | 3,625,440$ | 107,835$ | 496,584$ | 3,625,440$ | 470,610$ | 24 | 0 | 892,620$ | 34,864,441$ | 181 | 18,392$ | 3,328,952$ | 3,503,682$ | 3,727,340$ | 3,727,340$ | 5,500,000$ | 1,772,660$ | 174,169,404$ | 207,987,963$ |
| 12 | Red Wings | 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% | 33 | 18000 - 100.00% | 323,000$ | 1,615,000$ | 18000 | 100 | 3,158,124$ | 3,158,124$ | 90,029$ | 434,953$ | 3,158,124$ | 408,981$ | 27 | 0 | 707,733$ | 10,659,000$ | 181 | 16,145$ | 2,922,245$ | 3,102,511$ | 3,266,424$ | 3,266,424$ | 5,500,000$ | 2,233,576$ | 150,410,561$ | 158,313,850$ |
CCCP
Jets
Mooseheads
Nordiques
Thunder
Tigers
Americans
Brass
Bulls
Gibsons
Scouts
Whalers