| 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 | 170838 | 142733 | 56445 | 115477 | 27580 | 79.09% | 79.30% | 78.40% | 80.19% | 76.61% | 2 | 14252 - 79.18% | 1,053,938$ | 37,941,779$ | 18000 | 100 | 4,226,697$ | 4,226,697$ | 99,645$ | 3,948,239$ | 4,226,697$ | 3,757,158$ | 23 | 0 | 8,790,804$ | 2,107,877$ | 6 | 32,790$ | 196,740$ | 206,748$ | 4,351,849$ | 4,351,849$ | 5,500,000$ | 1,148,151$ | 203,631,617$ | 205,676,402$ |
| 2 | Bruins | 6000 | 5000 | 2000 | 4000 | 1000 | 75 | 50 | 30 | 20 | 750 | 180800 | 149749 | 59998 | 117726 | 28891 | 81.44% | 80.95% | 81.08% | 79.54% | 78.08% | 1 | 14518 - 80.66% | 1,076,747$ | 39,839,634$ | 18000 | 100 | 3,766,620$ | 3,766,620$ | 163,807$ | 3,803,124$ | 3,766,620$ | 3,612,071$ | 27 | 0 | 8,355,543$ | 1,076,747$ | 6 | 29,382$ | 176,292$ | 187,122$ | 3,910,340$ | 3,910,340$ | 5,500,000$ | 1,589,660$ | 145,047,117$ | 145,983,888$ |
| 3 | Canadiens | 6000 | 5000 | 2000 | 4000 | 1000 | 75 | 50 | 30 | 20 | 750 | 175403 | 148860 | 58884 | 116712 | 28236 | 81.21% | 82.70% | 81.78% | 81.05% | 78.43% | 2 | 14669 - 81.50% | 1,083,183$ | 38,994,587$ | 18000 | 100 | 3,638,863$ | 3,638,863$ | 76,960$ | 3,570,186$ | 3,638,863$ | 3,379,117$ | 27 | 0 | 7,656,681$ | 2,166,366$ | 6 | 28,436$ | 170,616$ | 181,398$ | 3,781,491$ | 3,781,491$ | 5,500,000$ | 1,718,509$ | 166,114,863$ | 168,193,609$ |
| 4 | Canucks | 6000 | 5000 | 2000 | 4000 | 1000 | 75 | 50 | 30 | 20 | 750 | 175673 | 146852 | 57701 | 113911 | 28547 | 81.33% | 81.58% | 80.14% | 79.10% | 79.30% | 2 | 14519 - 80.66% | 1,084,637$ | 39,046,940$ | 18000 | 100 | 4,661,623$ | 4,661,623$ | 152,796$ | 4,374,948$ | 4,661,623$ | 4,183,828$ | 27 | 0 | 10,070,814$ | 2,169,274$ | 6 | 36,012$ | 216,072$ | 226,734$ | 4,801,523$ | 4,801,523$ | 5,500,000$ | 698,477$ | 203,164,800$ | 205,200,753$ |
| 5 | Flames | 6000 | 5000 | 2000 | 4000 | 1000 | 75 | 50 | 30 | 20 | 750 | 180223 | 147904 | 59817 | 118141 | 29084 | 81.18% | 79.95% | 80.83% | 79.83% | 78.61% | 1 | 14464 - 80.36% | 1,077,025$ | 39,849,915$ | 18000 | 100 | 2,873,720$ | 2,873,720$ | 147,585$ | 2,950,319$ | 2,873,720$ | 2,759,214$ | 22 | 0 | 5,796,972$ | 1,077,025$ | 6 | 22,768$ | 136,608$ | 148,008$ | 3,030,220$ | 3,030,220$ | 5,500,000$ | 2,469,780$ | 177,131,747$ | 178,107,101$ |
| 6 | Flyers | 6000 | 5000 | 2000 | 4000 | 1000 | 75 | 50 | 30 | 20 | 750 | 171233 | 139413 | 56929 | 112631 | 27947 | 79.27% | 77.45% | 79.07% | 78.22% | 77.63% | 2 | 14115 - 78.42% | 1,056,216$ | 38,023,784$ | 18000 | 100 | 3,897,893$ | 3,897,893$ | 103,023$ | 3,961,119$ | 3,897,893$ | 3,770,014$ | 36 | 0 | 8,829,372$ | 2,112,432$ | 6 | 30,355$ | 182,130$ | 192,666$ | 4,034,893$ | 4,034,893$ | 5,500,000$ | 1,465,107$ | 185,224,291$ | 187,236,572$ |
| 7 | Islanders | 6000 | 5000 | 2000 | 4000 | 1000 | 75 | 50 | 30 | 20 | 750 | 170455 | 142367 | 57769 | 113251 | 28069 | 78.91% | 79.09% | 80.23% | 78.65% | 77.97% | 2 | 14220 - 79.00% | 1,061,374$ | 38,209,468$ | 18000 | 100 | 3,529,240$ | 3,529,240$ | 49,987$ | 3,552,122$ | 3,529,240$ | 3,361,004$ | 23 | 0 | 7,602,342$ | 2,122,748$ | 6 | 27,624$ | 165,744$ | 175,824$ | 3,656,040$ | 3,656,040$ | 5,500,000$ | 1,843,960$ | 159,140,783$ | 161,233,361$ |
| 8 | Maple Leafs | 6000 | 5000 | 2000 | 4000 | 1000 | 75 | 50 | 30 | 20 | 750 | 170485 | 142568 | 57069 | 114089 | 28191 | 78.93% | 79.20% | 79.26% | 79.23% | 78.31% | 2 | 14233 - 79.07% | 1,063,725$ | 38,294,093$ | 18000 | 100 | 2,222,560$ | 2,222,560$ | 79,666$ | 2,265,896$ | 2,222,560$ | 2,074,805$ | 21 | 0 | 3,743,745$ | 2,127,450$ | 6 | 17,945$ | 107,670$ | 117,606$ | 2,346,060$ | 2,346,060$ | 5,500,000$ | 3,153,940$ | 208,031,134$ | 210,183,949$ |
| 9 | Oilers | 6000 | 5000 | 2000 | 4000 | 1000 | 75 | 50 | 30 | 20 | 750 | 177004 | 149595 | 57804 | 118820 | 28777 | 79.73% | 80.86% | 78.11% | 80.28% | 77.78% | 1 | 14378 - 79.88% | 1,067,056$ | 39,481,070$ | 18000 | 100 | 3,992,417$ | 3,992,417$ | 123,918$ | 3,890,462$ | 3,992,417$ | 3,699,336$ | 23 | 0 | 8,617,338$ | 1,067,056$ | 6 | 31,055$ | 186,330$ | 197,274$ | 4,138,661$ | 4,138,661$ | 5,500,000$ | 1,361,339$ | 148,165,379$ | 149,108,728$ |
| 10 | Penguins | 6000 | 5000 | 2000 | 4000 | 1000 | 75 | 50 | 30 | 20 | 750 | 172360 | 144577 | 56314 | 115752 | 27710 | 79.80% | 80.32% | 78.21% | 80.38% | 76.97% | 2 | 14353 - 79.74% | 1,061,150$ | 38,201,386$ | 18000 | 100 | 4,041,410$ | 4,041,410$ | 168,160$ | 4,001,649$ | 4,041,410$ | 3,810,499$ | 25 | 0 | 8,950,827$ | 2,122,299$ | 6 | 31,418$ | 188,508$ | 197,514$ | 4,144,110$ | 4,144,110$ | 5,500,000$ | 1,355,890$ | 131,687,958$ | 133,757,269$ |
| 11 | Rangers | 6000 | 5000 | 2000 | 4000 | 1000 | 75 | 50 | 30 | 20 | 750 | 176385 | 145782 | 58238 | 116929 | 28561 | 79.45% | 78.80% | 78.70% | 79.01% | 77.19% | 1 | 14213 - 78.96% | 1,057,318$ | 39,120,780$ | 18000 | 100 | 3,371,760$ | 3,371,760$ | 93,729$ | 3,517,828$ | 3,371,760$ | 3,326,729$ | 22 | 0 | 7,499,517$ | 1,057,318$ | 6 | 26,457$ | 158,742$ | 168,102$ | 3,482,360$ | 3,482,360$ | 5,500,000$ | 2,017,640$ | 168,637,176$ | 169,597,854$ |
| 12 | Red Wings | 6000 | 5000 | 2000 | 4000 | 1000 | 30 | 20 | 10 | 5 | 60 | 222000 | 185000 | 74000 | 148000 | 37000 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 1 | 18000 - 100.00% | 323,000$ | 11,951,000$ | 18000 | 100 | 3,323,854$ | 3,323,854$ | 122,753$ | 3,381,091$ | 3,323,854$ | 3,189,917$ | 22 | 0 | 7,089,081$ | 323,000$ | 6 | 26,103$ | 156,618$ | 167,568$ | 3,470,254$ | 3,470,254$ | 5,500,000$ | 2,029,746$ | 137,925,160$ | 138,090,792$ |
CCCP
Jets
Mooseheads
Nordiques
Thunder
Tigers
Americans
Brass
Bulls
Gibsons
Scouts
Whalers