| 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,546,063$ | 399,532$ | 47,379,387$ | 23 | 0 | 6,250,875$ | 16,259,845$ | 51 | 408,304$ | 20,823,504$ | 21,602,702$ | 67,755,519$ | 28,755,519$ | 119,403,520$ | 51,648,001$ | 46,903,520$ | 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,764,078$ | 413,743$ | 49,711,438$ | 21 | 0 | 9,455,154$ | 16,298,020$ | 51 | 422,515$ | 21,548,265$ | 22,253,522$ | 70,812,331$ | 31,812,331$ | 87,329,019$ | 16,516,688$ | 14,829,019$ | 10,823,957$ |
| 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$ | 48,171,507$ | 401,170$ | 47,078,514$ | 22 | 0 | 7,379,362$ | 16,367,743$ | 51 | 405,556$ | 20,683,356$ | 21,633,613$ | 67,538,184$ | 28,538,184$ | 93,250,077$ | 25,711,893$ | 20,750,077$ | 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 | 70,800,000$ | 70,800,000$ | 0$ | 50,503,085$ | 414,035$ | 49,251,615$ | 21 | 0 | 10,535,147$ | 16,391,391$ | 51 | 419,883$ | 21,414,033$ | 22,207,735$ | 70,367,400$ | 31,367,400$ | 76,268,925$ | 5,901,525$ | 3,768,925$ | -92,753$ |
| 5 | Canadiens | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 70 | 40 | 30 | 200 | 172809 | 145347 | 57163 | 116205 | 29346 | 96.01% | 96.90% | 95.27% | 96.84% | 97.82% | 10 | 17362 - 96.46% | 1,498,721$ | 44,961,619$ | 18000 | 100 | 70,525,000$ | 70,525,000$ | 0$ | 50,074,860$ | 412,427$ | 48,276,612$ | 22 | 0 | 8,256,474$ | 14,987,206$ | 51 | 421,199$ | 21,481,149$ | 22,213,993$ | 69,310,389$ | 30,310,389$ | 85,002,132$ | 15,691,743$ | 12,502,132$ | 7,149,827$ |
| 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,438,316$ | 396,345$ | 48,543,577$ | 21 | 2 | 4,192,581$ | 16,507,779$ | 51 | 402,193$ | 20,511,843$ | 21,253,360$ | 68,757,172$ | 29,757,172$ | 82,208,632$ | 13,451,460$ | 9,708,632$ | 6,906,606$ |
| 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,971,347$ | 414,035$ | 50,023,992$ | 21 | 0 | 11,798,918$ | 16,617,730$ | 51 | 419,298$ | 21,384,198$ | 22,132,232$ | 71,139,777$ | 32,139,777$ | 81,795,841$ | 10,656,064$ | 9,295,841$ | 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,873,672$ | 389,766$ | 46,022,791$ | 22 | 1 | 4,221,778$ | 16,263,678$ | 51 | 395,614$ | 20,176,314$ | 21,652,096$ | 65,900,857$ | 26,900,857$ | 97,765,178$ | 31,864,321$ | 25,265,178$ | 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$ | 51,182,644$ | 412,281$ | 49,695,795$ | 20 | 0 | 11,076,892$ | 16,523,134$ | 51 | 423,977$ | 21,622,827$ | 22,372,331$ | 70,722,126$ | 31,722,126$ | 76,637,774$ | 5,915,648$ | 4,137,774$ | 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,649,160$ | 402,047$ | 48,245,640$ | 21 | 0 | 7,203,980$ | 16,437,459$ | 51 | 413,743$ | 21,100,893$ | 21,989,557$ | 68,750,037$ | 29,750,037$ | 84,914,468$ | 16,164,431$ | 12,414,468$ | 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,749,416$ | 416,082$ | 48,709,926$ | 22 | 0 | 24,616,632$ | 16,394,888$ | 51 | 424,854$ | 21,667,554$ | 22,380,798$ | 69,930,108$ | 30,930,108$ | 76,499,605$ | 6,569,497$ | 3,999,605$ | -70,793$ |
| 12 | Jets | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 70 | 40 | 30 | 200 | 166274 | 140188 | 55922 | 111936 | 27786 | 95.56% | 96.68% | 96.42% | 96.50% | 95.81% | 11 | 17314 - 96.19% | 1,490,746$ | 43,231,625$ | 18000 | 100 | 68,700,000$ | 68,700,000$ | 0$ | 49,588,856$ | 401,754$ | 48,536,219$ | 20 | 0 | 7,467,053$ | 16,398,203$ | 51 | 410,526$ | 20,936,826$ | 21,802,313$ | 69,025,673$ | 30,025,673$ | 81,147,776$ | 12,122,103$ | 8,647,776$ | 5,172,464$ |
| 13 | Kraken | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 70 | 40 | 30 | 200 | 165737 | 139965 | 56397 | 110689 | 27606 | 95.25% | 96.53% | 97.24% | 95.42% | 95.19% | 11 | 17255 - 95.86% | 1,485,840$ | 43,089,351$ | 18000 | 100 | 71,950,000$ | 71,950,000$ | 0$ | 50,583,962$ | 420,760$ | 49,579,498$ | 20 | 0 | 8,942,605$ | 16,344,237$ | 51 | 425,439$ | 21,697,389$ | 22,586,053$ | 71,038,258$ | 32,038,258$ | 80,091,959$ | 9,053,701$ | 7,591,959$ | 3,123,641$ |
| 14 | Lightning | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 70 | 40 | 30 | 200 | 161706 | 137372 | 54236 | 108516 | 27486 | 92.93% | 94.74% | 93.51% | 93.55% | 94.78% | 11 | 16873 - 93.74% | 1,455,692$ | 42,215,075$ | 18000 | 100 | 49,700,000$ | 49,700,000$ | 0$ | 38,450,281$ | 290,643$ | 36,941,497$ | 21 | 0 | 0$ | 16,012,615$ | 51 | 302,339$ | 15,419,289$ | 16,368,125$ | 51,764,290$ | 12,764,290$ | 91,625,065$ | 39,860,775$ | 19,125,065$ | 20,509,580$ |
| 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,485,673$ | 402,339$ | 46,248,844$ | 21 | 0 | 5,888,311$ | 16,575,252$ | 51 | 416,959$ | 21,264,909$ | 21,920,186$ | 66,768,133$ | 27,768,133$ | 85,117,948$ | 18,349,815$ | 12,617,948$ | 9,198,447$ |
| 16 | Maple Leafs | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 70 | 40 | 30 | 200 | 165346 | 140082 | 55988 | 110909 | 28213 | 95.03% | 96.61% | 96.53% | 95.61% | 97.29% | 11 | 17260 - 95.89% | 1,489,041$ | 43,182,189$ | 18000 | 100 | 70,725,000$ | 70,725,000$ | 0$ | 49,201,110$ | 413,596$ | 48,207,463$ | 21 | 0 | 7,788,721$ | 16,379,451$ | 51 | 417,491$ | 21,292,041$ | 22,043,701$ | 69,300,859$ | 30,300,859$ | 120,535,997$ | 51,235,138$ | 48,035,997$ | 44,295,942$ |
| 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$ | 49,264,299$ | 404,971$ | 48,702,932$ | 22 | 0 | 8,548,845$ | 16,422,802$ | 51 | 409,649$ | 20,892,099$ | 22,331,670$ | 69,356,453$ | 30,356,453$ | 93,716,664$ | 24,360,211$ | 21,216,664$ | 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,853,189$ | 367,105$ | 46,362,012$ | 20 | 1 | 6,370,663$ | 16,289,174$ | 51 | 428,509$ | 21,853,959$ | 22,976,010$ | 65,084,367$ | 26,084,367$ | 82,083,698$ | 16,999,331$ | 9,583,698$ | 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,598,535$ | 408,187$ | 48,896,775$ | 20 | 0 | 7,247,775$ | 17,984,046$ | 51 | 414,035$ | 21,115,785$ | 21,739,898$ | 69,714,312$ | 30,714,312$ | 106,756,299$ | 37,041,987$ | 34,256,299$ | 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,842,252$ | 402,339$ | 48,614,193$ | 20 | 0 | 7,759,424$ | 16,380,053$ | 51 | 412,573$ | 21,041,223$ | 21,987,168$ | 69,133,482$ | 30,133,482$ | 77,487,177$ | 8,353,695$ | 4,987,177$ | 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$ | 48,398,266$ | 392,105$ | 47,345,626$ | 22 | 0 | 6,297,570$ | 16,160,749$ | 51 | 400,877$ | 20,444,727$ | 21,176,836$ | 67,342,981$ | 28,342,981$ | 130,942,535$ | 63,599,554$ | 58,442,535$ | 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$ | 49,106,719$ | 400,146$ | 47,416,651$ | 21 | 0 | 7,584,042$ | 16,309,238$ | 51 | 411,842$ | 21,003,942$ | 22,028,875$ | 67,824,097$ | 28,824,097$ | 81,856,421$ | 14,032,324$ | 9,356,421$ | 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,393,117$ | 385,234$ | 50,691,358$ | 20 | 0 | 21,452,954$ | 16,426,885$ | 51 | 391,082$ | 19,945,182$ | 21,436,938$ | 70,338,292$ | 31,338,292$ | 77,409,789$ | 7,071,497$ | 4,909,789$ | 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,527,818$ | 402,632$ | 46,475,178$ | 23 | 0 | 1,985,202$ | 16,541,555$ | 51 | 411,404$ | 20,981,604$ | 21,979,734$ | 67,009,410$ | 28,009,410$ | 84,120,693$ | 17,111,283$ | 11,620,693$ | 8,139,164$ |
| 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,451,842$ | 399,058$ | 49,478,222$ | 21 | 1 | 8,425,457$ | 16,286,202$ | 51 | 425,081$ | 21,679,131$ | 22,409,770$ | 69,830,180$ | 30,830,180$ | 84,659,117$ | 14,828,937$ | 12,159,117$ | 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,411,382$ | 403,216$ | 48,534,191$ | 23 | 0 | 7,759,424$ | 16,226,900$ | 51 | 410,526$ | 20,936,826$ | 21,719,503$ | 69,098,207$ | 30,098,207$ | 85,032,800$ | 15,934,593$ | 12,532,800$ | 8,951,391$ |
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