| 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 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 | 164223 | 138219 | 56135 | 111290 | 27969 | 94.38% | 95.32% | 96.78% | 95.94% | 96.44% | 11 | 17167 - 95.37% | 1,478,168$ | 42,866,865$ | 18000 | 100 | 68,320,000$ | 68,320,000$ | 0$ | 48,137,759$ | 399,532$ | 46,979,855$ | 23 | 0 | 6,250,875$ | 16,259,845$ | 52 | 408,304$ | 21,231,808$ | 22,026,908$ | 67,755,519$ | 28,755,519$ | 119,827,726$ | 52,072,207$ | 47,327,726$ | 43,528,620$ |
| 2 | Blackhawks | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 70 | 40 | 30 | 200 | 165524 | 138257 | 56077 | 110546 | 27866 | 95.13% | 95.35% | 96.68% | 95.30% | 96.09% | 11 | 17182 - 95.45% | 1,481,638$ | 42,967,507$ | 18000 | 100 | 70,750,000$ | 70,750,000$ | 0$ | 50,341,563$ | 413,743$ | 49,297,695$ | 21 | 0 | 9,455,154$ | 16,298,020$ | 52 | 422,515$ | 21,970,780$ | 22,668,280$ | 70,812,331$ | 31,812,331$ | 87,765,927$ | 16,953,596$ | 15,265,927$ | 10,846,107$ |
| 3 | Blues | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 70 | 40 | 30 | 200 | 167148 | 138578 | 55567 | 109965 | 27930 | 96.06% | 95.57% | 95.81% | 94.80% | 96.31% | 11 | 17213 - 95.63% | 1,487,977$ | 43,151,323$ | 18000 | 100 | 68,600,000$ | 68,600,000$ | 0$ | 47,765,951$ | 401,170$ | 46,677,344$ | 22 | 0 | 7,379,362$ | 16,367,743$ | 52 | 405,556$ | 21,088,912$ | 22,058,562$ | 67,538,184$ | 28,538,184$ | 93,675,026$ | 26,136,842$ | 21,175,026$ | 17,434,724$ |
| 4 | Bruins | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 70 | 40 | 30 | 200 | 167007 | 139427 | 55201 | 110409 | 27981 | 95.98% | 96.16% | 95.17% | 95.18% | 96.49% | 11 | 17242 - 95.79% | 1,490,126$ | 43,213,666$ | 18000 | 100 | 69,500,000$ | 69,500,000$ | 0$ | 50,083,202$ | 406,433$ | 48,837,580$ | 20 | 0 | 10,535,147$ | 16,391,391$ | 52 | 412,281$ | 21,438,612$ | 22,633,162$ | 69,972,096$ | 30,972,096$ | 76,705,006$ | 6,732,910$ | 4,205,006$ | -82,099$ |
| 5 | Canadiens | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 70 | 40 | 30 | 200 | 166809 | 140347 | 55163 | 112205 | 28346 | 95.87% | 96.79% | 95.11% | 96.73% | 97.74% | 11 | 17340 - 96.34% | 1,496,866$ | 43,409,119$ | 18000 | 100 | 70,525,000$ | 70,525,000$ | 0$ | 49,653,661$ | 412,427$ | 47,864,185$ | 22 | 0 | 8,256,474$ | 16,465,528$ | 52 | 421,199$ | 21,902,348$ | 22,650,148$ | 69,310,389$ | 30,310,389$ | 83,885,787$ | 14,575,398$ | 11,385,787$ | 7,075,649$ |
| 6 | Canucks | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 70 | 40 | 30 | 200 | 168178 | 139702 | 56265 | 111706 | 28226 | 96.65% | 96.35% | 97.01% | 96.30% | 97.33% | 11 | 17382 - 96.57% | 1,500,707$ | 43,520,507$ | 18000 | 100 | 67,775,000$ | 67,775,000$ | 0$ | 49,036,123$ | 396,345$ | 48,147,232$ | 21 | 2 | 4,192,581$ | 16,507,779$ | 52 | 402,193$ | 20,914,036$ | 21,670,686$ | 68,757,172$ | 29,757,172$ | 82,449,705$ | 13,692,533$ | 9,949,705$ | 6,907,226$ |
| 7 | Capitals | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 70 | 40 | 30 | 200 | 169468 | 141616 | 56994 | 111570 | 28046 | 97.40% | 97.67% | 98.27% | 96.18% | 96.71% | 11 | 17507 - 97.26% | 1,510,703$ | 43,810,379$ | 18000 | 100 | 70,800,000$ | 70,800,000$ | 0$ | 50,552,049$ | 414,035$ | 49,609,957$ | 21 | 0 | 11,798,918$ | 16,617,730$ | 52 | 419,298$ | 21,803,496$ | 22,566,796$ | 71,139,777$ | 32,139,777$ | 82,230,405$ | 11,090,628$ | 9,730,405$ | 5,724,360$ |
| 8 | Devils | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 70 | 40 | 30 | 200 | 164988 | 138331 | 55314 | 110593 | 27860 | 94.82% | 95.40% | 95.37% | 95.34% | 96.07% | 11 | 17141 - 95.23% | 1,478,516$ | 42,876,970$ | 18000 | 100 | 66,650,000$ | 66,650,000$ | 0$ | 46,478,058$ | 389,766$ | 45,633,025$ | 22 | 1 | 4,221,778$ | 16,263,678$ | 52 | 395,614$ | 20,571,928$ | 22,077,828$ | 65,900,857$ | 26,900,857$ | 98,190,910$ | 32,290,053$ | 25,690,910$ | 21,805,291$ |
| 9 | Ducks | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 70 | 40 | 30 | 200 | 168213 | 140232 | 55451 | 111998 | 28318 | 96.67% | 96.71% | 95.61% | 96.55% | 97.65% | 11 | 17387 - 96.59% | 1,502,103$ | 43,560,990$ | 18000 | 100 | 70,500,000$ | 70,500,000$ | 0$ | 50,758,667$ | 412,281$ | 49,283,514$ | 20 | 0 | 11,076,892$ | 16,523,134$ | 52 | 423,977$ | 22,046,804$ | 22,811,604$ | 70,722,126$ | 31,722,126$ | 77,077,047$ | 6,354,921$ | 4,577,047$ | 204,219$ |
| 10 | Flames | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 70 | 40 | 30 | 200 | 168560 | 138625 | 56034 | 111480 | 27686 | 96.87% | 95.60% | 96.61% | 96.10% | 95.47% | 11 | 17324 - 96.24% | 1,494,314$ | 43,335,119$ | 18000 | 100 | 68,750,000$ | 68,750,000$ | 0$ | 49,235,417$ | 402,047$ | 47,843,593$ | 21 | 0 | 7,203,980$ | 16,437,459$ | 52 | 413,743$ | 21,514,636$ | 22,421,436$ | 68,750,037$ | 29,750,037$ | 85,346,347$ | 16,596,310$ | 12,846,347$ | 8,766,626$ |
| 11 | Islanders | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 70 | 40 | 30 | 200 | 167836 | 138223 | 55585 | 112037 | 27707 | 96.46% | 95.33% | 95.84% | 96.58% | 95.54% | 11 | 17289 - 96.05% | 1,490,444$ | 43,222,887$ | 18000 | 100 | 71,150,000$ | 71,150,000$ | 0$ | 50,324,562$ | 416,082$ | 48,293,844$ | 22 | 0 | 24,616,632$ | 16,394,888$ | 52 | 424,854$ | 22,092,408$ | 22,820,208$ | 69,930,108$ | 30,930,108$ | 76,939,015$ | 7,008,907$ | 4,439,015$ | -70,793$ |
| 12 | Jets | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 70 | 40 | 30 | 200 | 160335 | 135188 | 54084 | 107936 | 26884 | 95.44% | 96.56% | 96.58% | 96.37% | 96.01% | 12 | 17301 - 96.12% | 1,489,862$ | 41,716,132$ | 18000 | 100 | 68,700,000$ | 68,700,000$ | 0$ | 49,178,330$ | 401,754$ | 48,134,465$ | 20 | 0 | 7,467,053$ | 17,878,342$ | 52 | 410,526$ | 21,347,352$ | 22,230,502$ | 69,025,673$ | 30,025,673$ | 80,060,472$ | 11,034,799$ | 7,560,472$ | 5,137,110$ |
| 13 | Kraken | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 70 | 40 | 30 | 200 | 160336 | 135465 | 54408 | 106842 | 26716 | 95.44% | 96.76% | 97.16% | 95.39% | 95.41% | 12 | 17277 - 95.99% | 1,488,467$ | 41,677,071$ | 18000 | 100 | 71,950,000$ | 71,950,000$ | 0$ | 50,158,523$ | 420,760$ | 49,158,738$ | 20 | 0 | 8,942,605$ | 17,861,602$ | 52 | 425,439$ | 22,122,828$ | 23,029,628$ | 71,038,258$ | 32,038,258$ | 78,948,020$ | 7,909,762$ | 6,448,020$ | 3,231,645$ |
| 14 | Lightning | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 70 | 40 | 30 | 200 | 156257 | 132372 | 52391 | 105022 | 26559 | 93.01% | 94.55% | 93.56% | 93.77% | 94.85% | 12 | 16879 - 93.77% | 1,455,976$ | 40,767,317$ | 18000 | 100 | 49,700,000$ | 49,700,000$ | 0$ | 38,147,942$ | 290,643$ | 36,650,854$ | 21 | 0 | 0$ | 17,471,707$ | 52 | 302,339$ | 15,721,628$ | 16,689,828$ | 51,764,290$ | 12,764,290$ | 90,329,372$ | 38,565,082$ | 17,829,372$ | 20,526,934$ |
| 15 | Mammoth | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 70 | 40 | 30 | 200 | 169417 | 141302 | 55505 | 110972 | 28082 | 97.37% | 97.45% | 95.70% | 95.67% | 96.83% | 11 | 17423 - 96.80% | 1,506,841$ | 43,698,391$ | 18000 | 100 | 68,800,000$ | 68,800,000$ | 0$ | 48,068,714$ | 402,339$ | 45,846,505$ | 21 | 0 | 5,888,311$ | 16,575,252$ | 52 | 416,959$ | 21,681,868$ | 22,350,518$ | 66,768,133$ | 27,768,133$ | 85,548,280$ | 18,780,147$ | 13,048,280$ | 9,198,447$ |
| 16 | Maple Leafs | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 70 | 40 | 30 | 200 | 159346 | 135230 | 54083 | 107181 | 27307 | 94.85% | 96.59% | 96.58% | 95.70% | 97.52% | 12 | 17255 - 95.86% | 1,488,463$ | 41,676,977$ | 18000 | 100 | 70,725,000$ | 70,725,000$ | 0$ | 48,783,619$ | 413,596$ | 47,793,867$ | 21 | 0 | 7,788,721$ | 17,861,562$ | 52 | 417,491$ | 21,709,532$ | 22,476,532$ | 69,300,859$ | 30,300,859$ | 119,463,616$ | 50,162,757$ | 46,963,616$ | 44,272,841$ |
| 17 | Oilers | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 70 | 40 | 30 | 200 | 166760 | 139378 | 55799 | 111903 | 28138 | 95.84% | 96.12% | 96.21% | 96.47% | 97.03% | 11 | 17310 - 96.16% | 1,492,982$ | 43,296,477$ | 18000 | 100 | 69,250,000$ | 69,250,000$ | 0$ | 48,854,650$ | 404,971$ | 48,297,961$ | 22 | 0 | 8,548,845$ | 16,422,802$ | 52 | 409,649$ | 21,301,748$ | 22,770,698$ | 69,356,453$ | 30,356,453$ | 94,155,692$ | 24,799,239$ | 21,655,692$ | 17,239,286$ |
| 18 | Panthers | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 70 | 40 | 30 | 200 | 167071 | 137991 | 54768 | 110846 | 27301 | 96.02% | 95.17% | 94.43% | 95.56% | 94.14% | 11 | 17172 - 95.40% | 1,480,834$ | 42,944,186$ | 18000 | 100 | 69,775,000$ | 69,775,000$ | 0$ | 49,424,680$ | 367,105$ | 45,994,907$ | 20 | 1 | 6,370,663$ | 16,289,174$ | 52 | 428,509$ | 22,282,468$ | 23,427,418$ | 65,084,367$ | 26,084,367$ | 82,535,106$ | 17,450,739$ | 10,035,106$ | 4,803,201$ |
| 19 | Penguins | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 70 | 40 | 30 | 200 | 160174 | 136310 | 54622 | 109913 | 27240 | 95.34% | 97.36% | 97.54% | 98.14% | 97.29% | 12 | 17438 - 96.88% | 1,498,671$ | 41,962,774$ | 18000 | 100 | 69,800,000$ | 69,800,000$ | 0$ | 49,184,500$ | 408,187$ | 48,488,588$ | 20 | 0 | 7,247,775$ | 17,984,046$ | 52 | 414,035$ | 21,529,820$ | 22,166,670$ | 69,714,312$ | 30,714,312$ | 107,183,071$ | 37,468,759$ | 34,683,071$ | 32,444,531$ |
| 20 | Predators | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 70 | 40 | 30 | 200 | 166419 | 139667 | 55847 | 110808 | 27872 | 95.64% | 96.32% | 96.29% | 95.52% | 96.11% | 11 | 17263 - 95.90% | 1,489,096$ | 43,183,776$ | 18000 | 100 | 68,800,000$ | 68,800,000$ | 0$ | 49,429,679$ | 402,339$ | 48,211,854$ | 20 | 0 | 7,759,424$ | 16,380,053$ | 52 | 412,573$ | 21,453,796$ | 22,419,046$ | 69,133,482$ | 30,133,482$ | 77,919,055$ | 8,785,573$ | 5,419,055$ | 1,284,120$ |
| 21 | Rangers | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 70 | 40 | 30 | 200 | 164393 | 138255 | 54657 | 109411 | 27313 | 94.48% | 95.35% | 94.24% | 94.32% | 94.18% | 11 | 17035 - 94.64% | 1,469,159$ | 42,605,612$ | 18000 | 100 | 67,050,000$ | 67,050,000$ | 0$ | 47,997,389$ | 392,105$ | 46,953,521$ | 22 | 0 | 6,297,570$ | 16,160,749$ | 52 | 400,877$ | 20,845,604$ | 21,592,654$ | 67,342,981$ | 28,342,981$ | 131,358,353$ | 64,015,372$ | 58,858,353$ | 55,370,261$ |
| 22 | Red Wings | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 70 | 40 | 30 | 200 | 166226 | 138674 | 55498 | 111669 | 27445 | 95.53% | 95.64% | 95.69% | 96.27% | 94.64% | 11 | 17225 - 95.69% | 1,482,658$ | 42,997,082$ | 18000 | 100 | 68,425,000$ | 68,425,000$ | 0$ | 48,694,877$ | 400,146$ | 47,016,505$ | 21 | 0 | 7,584,042$ | 16,309,238$ | 52 | 411,842$ | 21,415,784$ | 22,461,634$ | 67,824,097$ | 28,824,097$ | 82,289,180$ | 14,465,083$ | 9,789,180$ | 5,586,317$ |
| 23 | Sabres | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 70 | 40 | 30 | 200 | 168469 | 136934 | 56181 | 111105 | 28229 | 96.82% | 94.44% | 96.86% | 95.78% | 97.34% | 11 | 17273 - 95.96% | 1,493,353$ | 43,307,242$ | 18000 | 100 | 65,875,000$ | 65,875,000$ | 0$ | 51,002,035$ | 385,234$ | 50,306,124$ | 20 | 0 | 21,452,954$ | 16,426,885$ | 52 | 391,082$ | 20,336,264$ | 21,858,464$ | 70,338,292$ | 31,338,292$ | 77,831,315$ | 7,493,023$ | 5,331,315$ | 1,830,717$ |
| 24 | Senateurs | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 70 | 40 | 30 | 200 | 168708 | 139921 | 55486 | 112248 | 28346 | 96.96% | 96.50% | 95.67% | 96.77% | 97.74% | 11 | 17404 - 96.69% | 1,503,778$ | 43,609,554$ | 18000 | 100 | 68,850,000$ | 68,850,000$ | 0$ | 47,116,414$ | 402,632$ | 46,072,546$ | 23 | 0 | 1,985,202$ | 16,541,555$ | 52 | 411,404$ | 21,393,008$ | 22,389,308$ | 67,009,410$ | 28,009,410$ | 84,552,467$ | 17,543,057$ | 12,052,467$ | 8,161,364$ |
| 25 | Sharks | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 70 | 40 | 30 | 200 | 164554 | 140179 | 55167 | 110985 | 27659 | 94.57% | 96.68% | 95.12% | 95.68% | 95.38% | 11 | 17191 - 95.51% | 1,480,564$ | 42,936,352$ | 18000 | 100 | 71,738,888$ | 71,738,888$ | 0$ | 50,026,761$ | 399,058$ | 49,079,164$ | 21 | 1 | 8,425,457$ | 16,286,202$ | 52 | 425,081$ | 22,104,212$ | 22,849,762$ | 69,830,180$ | 30,830,180$ | 85,099,109$ | 15,268,929$ | 12,599,109$ | 7,963,555$ |
| 26 | Stars | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 70 | 40 | 30 | 200 | 164977 | 138108 | 54717 | 109129 | 27861 | 94.81% | 95.25% | 94.34% | 94.08% | 96.07% | 11 | 17062 - 94.79% | 1,475,173$ | 42,780,010$ | 18000 | 100 | 68,950,000$ | 68,950,000$ | 0$ | 49,000,856$ | 403,216$ | 48,130,975$ | 23 | 0 | 7,759,424$ | 16,226,900$ | 52 | 410,526$ | 21,347,352$ | 22,146,002$ | 69,098,207$ | 30,098,207$ | 85,284,757$ | 16,186,550$ | 12,784,757$ | 8,950,253$ |
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