| 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 Average Salaries | 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 41,250,000$ | Maximum Salary Cap | Available Salary Cap | Current Bank Account | Projected Bank Account |
| 1 | Alberta Oilers | 6000 | 5000 | 3000 | 4000 | 2000 | 105 | 80 | 50 | 35 | 185 | 5370 | 4495 | 3000 | 3063 | 1821 | 89.50% | 89.90% | 100.00% | 76.58% | 91.05% | 40 | 17749 - 88.75% | 1,896,925$ | 1,896,925$ | 20000 | 100 | 81,785,000$ | 81,785,000$ | 0$ | 0$ | 0$ | 0$ | 24 | 0 | 0$ | 0$ | 8 | 0$ | 0$ | 0$ | 0$ | -41,250,000$ | 82,500,000$ | 82,500,000$ | 144,298,772$ | 144,298,772$ |
| 2 | Baltimore Blades | 6400 | 5400 | 3400 | 4400 | 2400 | 100 | 75 | 50 | 30 | 175 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 22000 | 100 | 70,367,813$ | 70,367,813$ | 0$ | 0$ | 0$ | 0$ | 25 | 0 | 0$ | 0$ | 8 | 0$ | 0$ | 0$ | 0$ | -41,250,000$ | 82,500,000$ | 82,500,000$ | 33,251,372$ | 33,251,372$ |
| 3 | Birmingham Bulls | 6400 | 5400 | 3400 | 4400 | 2400 | 100 | 75 | 55 | 30 | 175 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 22000 | 100 | 57,337,675$ | 57,337,675$ | 0$ | 0$ | 0$ | 0$ | 22 | 1 | 0$ | 0$ | 8 | 0$ | 0$ | 0$ | 0$ | -41,250,000$ | 82,500,000$ | 82,500,000$ | 208,618,124$ | 208,618,124$ |
| 4 | Calgary Cowboys | 6400 | 5400 | 3400 | 4400 | 2400 | 100 | 75 | 55 | 30 | 175 | 5818 | 4635 | 2878 | 4400 | 1899 | 90.91% | 85.83% | 84.65% | 100.00% | 79.13% | 40 | 19630 - 89.23% | 1,940,050$ | 1,940,050$ | 22000 | 100 | 47,216,625$ | 47,216,625$ | 0$ | 0$ | 0$ | 0$ | 23 | 0 | 0$ | 0$ | 8 | 0$ | 0$ | 0$ | 0$ | -41,250,000$ | 82,500,000$ | 82,500,000$ | 90,291,878$ | 90,291,878$ |
| 5 | Chicago Cougars | 6400 | 5400 | 3400 | 4400 | 2400 | 100 | 75 | 55 | 30 | 175 | 5683 | 4952 | 2791 | 4400 | 2019 | 88.80% | 91.70% | 82.09% | 100.00% | 84.13% | 40 | 19845 - 90.20% | 1,973,162$ | 1,973,162$ | 22000 | 100 | 41,739,625$ | 41,739,625$ | 0$ | 0$ | 0$ | 0$ | 24 | 0 | 0$ | 0$ | 8 | 0$ | 0$ | 0$ | 0$ | -41,250,000$ | 82,500,000$ | 82,500,000$ | 273,138,174$ | 273,138,174$ |
| 6 | Cincinnati Stingers | 6200 | 5200 | 3200 | 4200 | 2200 | 100 | 75 | 50 | 30 | 175 | 11004 | 8881 | 6400 | 8208 | 4068 | 88.74% | 85.39% | 100.00% | 97.71% | 92.45% | 39 | 19281 - 91.81% | 1,902,885$ | 3,805,769$ | 21000 | 100 | 76,265,000$ | 76,265,000$ | 0$ | 0$ | 0$ | 0$ | 21 | 0 | 0$ | 0$ | 8 | 0$ | 0$ | 0$ | 0$ | -41,250,000$ | 82,500,000$ | 82,500,000$ | 259,786,759$ | 259,786,759$ |
| 7 | Cleveland Crusaders | 6300 | 5300 | 3300 | 4300 | 2300 | 100 | 75 | 50 | 30 | 175 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 21500 | 100 | 46,275,000$ | 46,275,000$ | 0$ | 0$ | 0$ | 0$ | 22 | 1 | 0$ | 0$ | 8 | 0$ | 0$ | 0$ | 0$ | -41,250,000$ | 82,500,000$ | 82,500,000$ | 102,135,138$ | 102,135,138$ |
| 8 | Dayton Firebirds | 6400 | 5400 | 3400 | 4400 | 2400 | 100 | 75 | 50 | 30 | 175 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 22000 | 100 | 61,975,000$ | 61,975,000$ | 0$ | 0$ | 0$ | 0$ | 24 | 1 | 0$ | 0$ | 8 | 0$ | 0$ | 0$ | 0$ | -41,250,000$ | 82,500,000$ | 82,500,000$ | 24,095,676$ | 24,095,676$ |
| 9 | Denver Spurs | 6400 | 5400 | 3400 | 4400 | 2400 | 100 | 75 | 50 | 30 | 175 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 22000 | 100 | 75,021,500$ | 75,021,500$ | 0$ | 0$ | 0$ | 0$ | 25 | 1 | 0$ | 0$ | 8 | 0$ | 0$ | 0$ | 0$ | -41,250,000$ | 82,500,000$ | 82,500,000$ | 69,770,920$ | 69,770,920$ |
| 10 | Detroit Gladiators | 6000 | 5000 | 3000 | 4000 | 2000 | 100 | 75 | 50 | 30 | 175 | 10477 | 8911 | 6000 | 8000 | 3831 | 87.31% | 89.11% | 100.00% | 100.00% | 95.78% | 39 | 18610 - 93.05% | 1,829,032$ | 3,658,063$ | 20000 | 100 | 77,533,000$ | 77,533,000$ | 0$ | 0$ | 0$ | 0$ | 21 | 0 | 0$ | 0$ | 8 | 0$ | 0$ | 0$ | 0$ | -41,250,000$ | 82,500,000$ | 82,500,000$ | 255,086,732$ | 255,086,732$ |
| 11 | Halifax Icebreakers | 6000 | 5000 | 3000 | 4000 | 2000 | 100 | 75 | 50 | 30 | 175 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 20000 | 100 | 44,990,500$ | 44,990,500$ | 0$ | 0$ | 0$ | 0$ | 24 | 1 | 0$ | 0$ | 8 | 0$ | 0$ | 0$ | 0$ | -41,250,000$ | 82,500,000$ | 82,500,000$ | 149,548,366$ | 149,548,366$ |
| 12 | Houston Aeros | 6000 | 5000 | 3000 | 4000 | 2000 | 100 | 75 | 50 | 30 | 175 | 10966 | 9293 | 6000 | 8000 | 3930 | 91.38% | 92.93% | 100.00% | 100.00% | 98.25% | 39 | 19095 - 95.47% | 1,888,328$ | 3,776,656$ | 20000 | 100 | 72,975,000$ | 72,975,000$ | 0$ | 0$ | 0$ | 0$ | 23 | 0 | 0$ | 0$ | 8 | 0$ | 0$ | 0$ | 0$ | -41,250,000$ | 82,500,000$ | 82,500,000$ | 122,916,845$ | 122,916,845$ |
| 13 | Indiana Racers | 6000 | 5000 | 3000 | 4000 | 2000 | 100 | 75 | 50 | 30 | 175 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 20000 | 100 | 61,253,750$ | 61,253,750$ | 0$ | 0$ | 0$ | 0$ | 24 | 1 | 0$ | 0$ | 8 | 0$ | 0$ | 0$ | 0$ | -41,250,000$ | 82,500,000$ | 82,500,000$ | 107,766,315$ | 107,766,315$ |
| 14 | Laval Chiefs | 6400 | 5400 | 3400 | 4400 | 2400 | 100 | 75 | 50 | 30 | 175 | 11247 | 9450 | 6683 | 8800 | 3792 | 87.87% | 87.50% | 98.28% | 100.00% | 79.00% | 39 | 19986 - 90.85% | 1,934,500$ | 3,869,000$ | 22000 | 100 | 79,975,000$ | 79,975,000$ | 0$ | 0$ | 0$ | 0$ | 25 | 0 | 0$ | 0$ | 8 | 0$ | 0$ | 0$ | 0$ | -41,250,000$ | 82,500,000$ | 82,500,000$ | 307,153,555$ | 307,153,555$ |
| 15 | Los Angeles Sharks | 6000 | 5000 | 3000 | 4000 | 2000 | 100 | 75 | 50 | 30 | 175 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 20000 | 100 | 70,350,000$ | 69,650,000$ | 0$ | 0$ | 0$ | 0$ | 24 | 1 | 0$ | 0$ | 8 | 0$ | 0$ | 0$ | 0$ | -41,250,000$ | 82,500,000$ | 82,500,000$ | 45,355,015$ | 45,355,015$ |
| 16 | Manhattan Raiders | 6000 | 5000 | 3000 | 4000 | 2000 | 100 | 75 | 50 | 30 | 175 | 5752 | 4565 | 3000 | 4000 | 1915 | 95.87% | 91.30% | 100.00% | 100.00% | 95.75% | 40 | 19232 - 96.16% | 1,903,375$ | 1,903,375$ | 20000 | 100 | 79,132,500$ | 79,132,500$ | 0$ | 0$ | 0$ | 0$ | 24 | 0 | 0$ | 0$ | 8 | 0$ | 0$ | 0$ | 0$ | -41,250,000$ | 82,500,000$ | 82,500,000$ | 48,722,780$ | 48,722,780$ |
| 17 | Miami ScreamingEagles | 6000 | 5000 | 3000 | 4000 | 2000 | 100 | 75 | 50 | 30 | 175 | 11096 | 9420 | 6000 | 8000 | 3916 | 92.47% | 94.20% | 100.00% | 100.00% | 97.90% | 39 | 19216 - 96.08% | 1,900,875$ | 3,801,750$ | 20000 | 100 | 81,275,000$ | 81,275,000$ | 0$ | 0$ | 0$ | 0$ | 21 | 0 | 0$ | 0$ | 8 | 0$ | 0$ | 0$ | 0$ | -41,250,000$ | 82,500,000$ | 82,500,000$ | 23,005,306$ | 23,005,306$ |
| 18 | Michigan Stags | 6000 | 5000 | 3000 | 4000 | 2000 | 100 | 75 | 51 | 30 | 175 | 5891 | 4538 | 2719 | 4000 | 1964 | 98.18% | 90.76% | 90.63% | 100.00% | 98.20% | 40 | 19112 - 95.56% | 1,914,774$ | 1,914,774$ | 20000 | 100 | 80,188,375$ | 79,938,375$ | 0$ | 0$ | 0$ | 0$ | 25 | 0 | 0$ | 0$ | 8 | 0$ | 0$ | 0$ | 0$ | -41,250,000$ | 82,500,000$ | 82,500,000$ | 134,967,373$ | 134,967,373$ |
| 19 | Minnesota FightingSaints | 6500 | 5500 | 3500 | 4500 | 2000 | 95 | 72 | 50 | 30 | 160 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 22000 | 100 | 61,600,000$ | 61,600,000$ | 0$ | 0$ | 0$ | 0$ | 24 | 1 | 0$ | 0$ | 8 | 0$ | 0$ | 0$ | 0$ | -41,250,000$ | 82,500,000$ | 82,500,000$ | 125,483,969$ | 125,483,969$ |
| 20 | New England Whalers | 6400 | 5400 | 3400 | 4400 | 2400 | 100 | 75 | 50 | 30 | 175 | 11846 | 8737 | 6774 | 8702 | 3926 | 92.55% | 80.90% | 99.62% | 98.89% | 81.79% | 39 | 19993 - 90.88% | 1,954,178$ | 3,908,356$ | 22000 | 100 | 79,335,000$ | 79,335,000$ | 0$ | 0$ | 0$ | 0$ | 23 | 0 | 0$ | 0$ | 8 | 0$ | 0$ | 0$ | 0$ | -41,250,000$ | 82,500,000$ | 82,500,000$ | 95,040,382$ | 95,040,382$ |
| 21 | New Jersey Knights | 6000 | 5000 | 3000 | 4000 | 2000 | 100 | 75 | 50 | 30 | 175 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 20000 | 100 | 65,092,500$ | 65,092,500$ | 0$ | 0$ | 0$ | 0$ | 25 | 1 | 0$ | 0$ | 8 | 0$ | 0$ | 0$ | 0$ | -41,250,000$ | 82,500,000$ | 82,500,000$ | 52,876,516$ | 52,876,516$ |
| 22 | New York GoldenBlades | 6400 | 5400 | 3400 | 4400 | 2400 | 100 | 75 | 50 | 30 | 175 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 22000 | 100 | 54,875,000$ | 54,875,000$ | 0$ | 0$ | 0$ | 0$ | 22 | 1 | 0$ | 0$ | 8 | 0$ | 0$ | 0$ | 0$ | -41,250,000$ | 82,500,000$ | 82,500,000$ | 85,057,843$ | 85,057,843$ |
| 23 | Orlando SolarBears | 6000 | 5000 | 3000 | 4000 | 2000 | 100 | 75 | 50 | 30 | 175 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 20000 | 100 | 69,186,667$ | 69,186,667$ | 0$ | 0$ | 0$ | 0$ | 24 | 1 | 0$ | 0$ | 8 | 0$ | 0$ | 0$ | 0$ | -41,250,000$ | 82,500,000$ | 82,500,000$ | 40,968,469$ | 40,968,469$ |
| 24 | Ottawa Nationals | 6000 | 5000 | 3000 | 4000 | 2000 | 100 | 75 | 50 | 30 | 175 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 20000 | 100 | 70,625,000$ | 70,625,000$ | 0$ | 0$ | 0$ | 0$ | 25 | 1 | 0$ | 0$ | 8 | 0$ | 0$ | 0$ | 0$ | -41,250,000$ | 82,500,000$ | 82,500,000$ | 125,031,249$ | 125,031,249$ |
| 25 | Philly Blazers | 6400 | 5400 | 3400 | 4400 | 2400 | 100 | 75 | 50 | 30 | 175 | 10928 | 9494 | 6749 | 8772 | 4072 | 85.38% | 87.91% | 99.25% | 99.68% | 84.83% | 39 | 20008 - 90.94% | 1,948,787$ | 3,897,574$ | 22000 | 100 | 72,275,000$ | 72,275,000$ | 0$ | 0$ | 0$ | 0$ | 21 | 0 | 0$ | 0$ | 8 | 0$ | 0$ | 0$ | 0$ | -41,250,000$ | 82,500,000$ | 82,500,000$ | 116,565,691$ | 116,565,691$ |
| 26 | Phoenix Roadrunners | 6000 | 5000 | 3000 | 4000 | 2000 | 100 | 75 | 52 | 30 | 175 | 5343 | 4705 | 2891 | 4000 | 1834 | 89.05% | 94.10% | 96.37% | 100.00% | 91.70% | 40 | 18773 - 93.87% | 1,848,071$ | 1,848,071$ | 20000 | 100 | 78,422,500$ | 78,422,500$ | 0$ | 0$ | 0$ | 0$ | 24 | 0 | 0$ | 0$ | 8 | 0$ | 0$ | 0$ | 0$ | -41,250,000$ | 82,500,000$ | 82,500,000$ | 70,587,445$ | 70,587,445$ |
| 27 | Quebec Nordiques | 6400 | 5400 | 3400 | 4400 | 2400 | 95 | 72 | 55 | 35 | 160 | 12746 | 10429 | 4963 | 6648 | 4626 | 99.58% | 96.56% | 72.99% | 75.55% | 96.38% | 39 | 19706 - 89.57% | 2,004,727$ | 4,009,454$ | 22000 | 100 | 76,420,000$ | 76,420,000$ | 0$ | 0$ | 0$ | 0$ | 25 | 0 | 0$ | 0$ | 8 | 0$ | 0$ | 0$ | 0$ | -41,250,000$ | 82,500,000$ | 82,500,000$ | 217,711,671$ | 217,711,671$ |
| 28 | San Diego Mariners | 6400 | 5400 | 3400 | 4400 | 2400 | 100 | 75 | 50 | 30 | 175 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 22000 | 100 | 60,642,500$ | 60,642,500$ | 0$ | 0$ | 0$ | 0$ | 25 | 0 | 0$ | 0$ | 8 | 0$ | 0$ | 0$ | 0$ | -41,250,000$ | 82,500,000$ | 82,500,000$ | 74,716,640$ | 74,716,640$ |
| 29 | San Francisco Shamrocks | 6400 | 5400 | 3400 | 4400 | 2400 | 100 | 75 | 50 | 30 | 175 | 5193 | 4836 | 3333 | 4126 | 2124 | 81.14% | 89.56% | 98.03% | 93.77% | 88.50% | 40 | 19612 - 89.15% | 1,930,162$ | 1,930,162$ | 22000 | 100 | 72,120,000$ | 72,120,000$ | 0$ | 0$ | 0$ | 0$ | 25 | 0 | 0$ | 0$ | 8 | 0$ | 0$ | 0$ | 0$ | -41,250,000$ | 82,500,000$ | 82,500,000$ | 178,916,515$ | 178,916,515$ |
| 30 | Toronto Toros | 6000 | 5000 | 3000 | 4000 | 2000 | 100 | 75 | 50 | 30 | 175 | 5424 | 4766 | 3000 | 4000 | 2000 | 90.40% | 95.32% | 100.00% | 100.00% | 100.00% | 40 | 19190 - 95.95% | 1,899,812$ | 1,899,812$ | 20000 | 100 | 81,785,000$ | 81,460,000$ | 0$ | 0$ | 0$ | 0$ | 22 | 0 | 0$ | 0$ | 8 | 0$ | 0$ | 0$ | 0$ | -41,250,000$ | 82,500,000$ | 82,500,000$ | 181,932,109$ | 181,932,109$ |
| 31 | Vancouver Grizzlies | 6400 | 5400 | 3400 | 4400 | 2400 | 100 | 75 | 50 | 30 | 175 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 22000 | 100 | 44,263,300$ | 43,343,300$ | 0$ | 0$ | 0$ | 0$ | 24 | 1 | 0$ | 0$ | 8 | 0$ | 0$ | 0$ | 0$ | -41,250,000$ | 82,500,000$ | 82,500,000$ | 179,873,734$ | 179,873,734$ |
| 32 | Winnipeg Jets | 6400 | 5400 | 3400 | 4400 | 2400 | 100 | 75 | 50 | 30 | 175 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 22000 | 100 | 60,489,625$ | 60,489,625$ | 0$ | 0$ | 0$ | 0$ | 25 | 0 | 0$ | 0$ | 8 | 0$ | 0$ | 0$ | 0$ | -41,250,000$ | 82,500,000$ | 82,500,000$ | 270,368,075$ | 270,368,075$ |