| 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 44,000,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 | 10854 | 8249 | 6000 | 6659 | 3882 | 90.45% | 82.49% | 100.00% | 83.24% | 97.05% | 39 | 17822 - 89.11% | 1,906,766$ | 3,813,531$ | 20000 | 100 | 78,785,000$ | 78,785,000$ | 0$ | 0$ | 0$ | 0$ | 24 | 0 | 0$ | 0$ | 6 | 0$ | 0$ | 0$ | 0$ | -44,000,000$ | 88,000,000$ | 88,000,000$ | 90,710,595$ | 90,710,595$ |
| 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 | 64,830,500$ | 64,830,500$ | 0$ | 0$ | 0$ | 0$ | 25 | 0 | 0$ | 0$ | 6 | 0$ | 0$ | 0$ | 0$ | -44,000,000$ | 88,000,000$ | 88,000,000$ | 38,855,861$ | 38,855,861$ |
| 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 | 47,117,500$ | 47,117,500$ | 0$ | 0$ | 0$ | 0$ | 23 | 0 | 0$ | 0$ | 6 | 0$ | 0$ | 0$ | 0$ | -44,000,000$ | 88,000,000$ | 88,000,000$ | 246,095,663$ | 246,095,663$ |
| 4 | Calgary Cowboys | 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 | 59,929,999$ | 59,929,999$ | 0$ | 0$ | 0$ | 0$ | 25 | 0 | 0$ | 0$ | 6 | 0$ | 0$ | 0$ | 0$ | -44,000,000$ | 88,000,000$ | 88,000,000$ | 75,105,773$ | 75,105,773$ |
| 5 | Chicago Cougars | 6400 | 5400 | 3400 | 4400 | 2400 | 100 | 75 | 55 | 30 | 175 | 10929 | 9197 | 5241 | 8800 | 3845 | 85.38% | 85.16% | 77.07% | 100.00% | 80.10% | 39 | 19006 - 86.39% | 1,879,879$ | 3,759,757$ | 22000 | 100 | 79,595,000$ | 79,595,000$ | 0$ | 0$ | 0$ | 0$ | 23 | 0 | 0$ | 0$ | 6 | 0$ | 0$ | 0$ | 0$ | -44,000,000$ | 88,000,000$ | 88,000,000$ | 309,019,928$ | 309,019,928$ |
| 6 | Cincinnati Stingers | 6200 | 5200 | 3200 | 4200 | 2200 | 100 | 75 | 50 | 30 | 175 | 11847 | 9101 | 6400 | 8318 | 3786 | 95.54% | 87.51% | 100.00% | 99.02% | 86.05% | 39 | 19726 - 93.93% | 1,937,103$ | 3,874,206$ | 21000 | 100 | 83,935,358$ | 83,935,358$ | 0$ | 0$ | 0$ | 0$ | 21 | 0 | 0$ | 0$ | 6 | 0$ | 0$ | 0$ | 0$ | -44,000,000$ | 88,000,000$ | 88,000,000$ | 248,714,681$ | 248,714,681$ |
| 7 | Cleveland Crusaders | 6300 | 5300 | 3300 | 4300 | 2300 | 100 | 75 | 50 | 30 | 175 | 11056 | 9404 | 6600 | 8468 | 4021 | 87.75% | 88.72% | 100.00% | 98.47% | 87.41% | 39 | 19775 - 91.97% | 1,936,634$ | 3,873,268$ | 21500 | 100 | 70,932,500$ | 70,932,500$ | 0$ | 0$ | 0$ | 0$ | 25 | 0 | 0$ | 0$ | 6 | 0$ | 0$ | 0$ | 0$ | -44,000,000$ | 88,000,000$ | 88,000,000$ | 86,535,232$ | 86,535,232$ |
| 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 | 74,145,000$ | 74,145,000$ | 0$ | 0$ | 0$ | 0$ | 25 | 0 | 0$ | 0$ | 6 | 0$ | 0$ | 0$ | 0$ | -44,000,000$ | 88,000,000$ | 88,000,000$ | 6,469,514$ | 6,469,514$ |
| 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 | 62,599,125$ | 62,599,125$ | 0$ | 0$ | 0$ | 0$ | 23 | 0 | 0$ | 0$ | 6 | 0$ | 0$ | 0$ | 0$ | -44,000,000$ | 88,000,000$ | 88,000,000$ | 77,854,696$ | 77,854,696$ |
| 10 | Detroit Gladiators | 6000 | 5000 | 3000 | 4000 | 2000 | 100 | 75 | 50 | 30 | 175 | 11010 | 9583 | 6000 | 8000 | 3783 | 91.75% | 95.83% | 100.00% | 100.00% | 94.58% | 39 | 19188 - 95.94% | 1,888,594$ | 3,777,187$ | 20000 | 100 | 87,400,000$ | 87,400,000$ | 0$ | 0$ | 0$ | 0$ | 23 | 0 | 0$ | 0$ | 6 | 0$ | 0$ | 0$ | 0$ | -44,000,000$ | 88,000,000$ | 88,000,000$ | 239,155,123$ | 239,155,123$ |
| 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 | 43,710,000$ | 43,710,000$ | 0$ | 0$ | 0$ | 0$ | 22 | 0 | 0$ | 0$ | 6 | 0$ | 0$ | 0$ | 0$ | -44,000,000$ | 88,000,000$ | 88,000,000$ | 183,633,591$ | 183,633,591$ |
| 12 | Houston Aeros | 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 | 64,592,500$ | 64,592,500$ | 0$ | 0$ | 0$ | 0$ | 25 | 0 | 0$ | 0$ | 6 | 0$ | 0$ | 0$ | 0$ | -44,000,000$ | 88,000,000$ | 88,000,000$ | 155,158,238$ | 155,158,238$ |
| 13 | Indiana Racers | 6000 | 5000 | 3000 | 4000 | 2000 | 100 | 75 | 50 | 30 | 175 | 11408 | 9059 | 6000 | 8000 | 3871 | 95.07% | 90.59% | 100.00% | 100.00% | 96.78% | 39 | 19169 - 95.85% | 1,898,531$ | 3,797,062$ | 20000 | 100 | 86,181,625$ | 86,181,625$ | 0$ | 0$ | 0$ | 0$ | 22 | 0 | 0$ | 0$ | 6 | 0$ | 0$ | 0$ | 0$ | -44,000,000$ | 88,000,000$ | 88,000,000$ | 72,151,943$ | 72,151,943$ |
| 14 | Laval Chiefs | 6400 | 5400 | 3400 | 4400 | 2400 | 100 | 75 | 50 | 30 | 175 | 11322 | 9529 | 6800 | 8788 | 3963 | 88.45% | 88.23% | 100.00% | 99.86% | 82.56% | 39 | 20201 - 91.82% | 1,965,025$ | 3,930,050$ | 22000 | 100 | 84,825,000$ | 84,825,000$ | 0$ | 0$ | 0$ | 0$ | 25 | 0 | 0$ | 0$ | 6 | 0$ | 0$ | 0$ | 0$ | -44,000,000$ | 88,000,000$ | 88,000,000$ | 170,335,606$ | 170,335,606$ |
| 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 | 86,959,917$ | 86,959,917$ | 0$ | 0$ | 0$ | 0$ | 25 | 0 | 0$ | 0$ | 6 | 0$ | 0$ | 0$ | 0$ | -44,000,000$ | 88,000,000$ | 88,000,000$ | 2,047,902$ | 2,047,902$ |
| 16 | Manhattan Raiders | 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 | 86,610,000$ | 86,610,000$ | 0$ | 0$ | 0$ | 0$ | 23 | 0 | 0$ | 0$ | 6 | 0$ | 0$ | 0$ | 0$ | -44,000,000$ | 88,000,000$ | 88,000,000$ | 37,993,777$ | 37,993,777$ |
| 17 | Miami ScreamingEagles | 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 | 85,025,000$ | 85,025,000$ | 0$ | 0$ | 0$ | 0$ | 22 | 0 | 0$ | 0$ | 6 | 0$ | 0$ | 0$ | 0$ | -44,000,000$ | 88,000,000$ | 88,000,000$ | 6,817,229$ | 6,817,229$ |
| 18 | Michigan Stags | 6000 | 5000 | 3000 | 4000 | 2000 | 100 | 75 | 51 | 30 | 175 | 11114 | 9377 | 5507 | 8000 | 4000 | 92.62% | 93.77% | 91.78% | 100.00% | 100.00% | 39 | 18999 - 95.00% | 1,897,208$ | 3,794,415$ | 20000 | 100 | 85,967,675$ | 85,967,675$ | 0$ | 0$ | 0$ | 0$ | 24 | 0 | 0$ | 0$ | 6 | 0$ | 0$ | 0$ | 0$ | -44,000,000$ | 88,000,000$ | 88,000,000$ | 86,574,011$ | 86,574,011$ |
| 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 | 47,250,000$ | 47,250,000$ | 0$ | 0$ | 0$ | 0$ | 24 | 0 | 0$ | 0$ | 6 | 0$ | 0$ | 0$ | 0$ | -44,000,000$ | 88,000,000$ | 88,000,000$ | 171,584,708$ | 171,584,708$ |
| 20 | New England Whalers | 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 | 45,737,500$ | 45,737,500$ | 0$ | 0$ | 0$ | 0$ | 22 | 0 | 0$ | 0$ | 6 | 0$ | 0$ | 0$ | 0$ | -44,000,000$ | 88,000,000$ | 88,000,000$ | 114,516,203$ | 114,516,203$ |
| 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 | 73,558,770$ | 73,558,770$ | 0$ | 0$ | 0$ | 0$ | 22 | 0 | 0$ | 0$ | 6 | 0$ | 0$ | 0$ | 0$ | -44,000,000$ | 88,000,000$ | 88,000,000$ | 45,851,792$ | 45,851,792$ |
| 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 | 64,512,500$ | 64,512,500$ | 0$ | 0$ | 0$ | 0$ | 23 | 0 | 0$ | 0$ | 6 | 0$ | 0$ | 0$ | 0$ | -44,000,000$ | 88,000,000$ | 88,000,000$ | 107,927,576$ | 107,927,576$ |
| 23 | Orlando SolarBears | 6000 | 5000 | 3000 | 4000 | 2000 | 100 | 75 | 50 | 30 | 175 | 10690 | 9077 | 6000 | 8000 | 3989 | 89.08% | 90.77% | 100.00% | 100.00% | 99.73% | 39 | 18878 - 94.39% | 1,867,407$ | 3,734,813$ | 20000 | 100 | 87,549,125$ | 87,549,125$ | 0$ | 0$ | 0$ | 0$ | 21 | 0 | 0$ | 0$ | 6 | 0$ | 0$ | 0$ | 0$ | -44,000,000$ | 88,000,000$ | 88,000,000$ | -1,231,633$ | -1,231,633$ |
| 24 | Ottawa Nationals | 6000 | 5000 | 3000 | 4000 | 2000 | 100 | 75 | 50 | 30 | 175 | 10619 | 9855 | 6000 | 8000 | 3843 | 88.49% | 98.55% | 100.00% | 100.00% | 96.08% | 39 | 19159 - 95.79% | 1,883,469$ | 3,766,938$ | 20000 | 100 | 84,430,000$ | 84,430,000$ | 0$ | 0$ | 0$ | 0$ | 25 | 0 | 0$ | 0$ | 6 | 0$ | 0$ | 0$ | 0$ | -44,000,000$ | 88,000,000$ | 88,000,000$ | 36,993,415$ | 36,993,415$ |
| 25 | Philly Blazers | 6400 | 5400 | 3400 | 4400 | 2400 | 100 | 75 | 50 | 30 | 175 | 10863 | 8998 | 6554 | 8537 | 3586 | 84.87% | 83.31% | 96.38% | 97.01% | 74.71% | 39 | 19269 - 87.59% | 1,857,819$ | 3,715,637$ | 22000 | 100 | 85,475,000$ | 85,475,000$ | 0$ | 0$ | 0$ | 0$ | 23 | 0 | 0$ | 0$ | 6 | 0$ | 0$ | 0$ | 0$ | -44,000,000$ | 88,000,000$ | 88,000,000$ | 58,478,382$ | 58,478,382$ |
| 26 | Phoenix Roadrunners | 6000 | 5000 | 3000 | 4000 | 2000 | 100 | 75 | 52 | 30 | 175 | 10648 | 9285 | 5166 | 8000 | 3878 | 88.73% | 92.85% | 86.10% | 100.00% | 96.95% | 39 | 18489 - 92.44% | 1,842,786$ | 3,685,571$ | 20000 | 100 | 87,850,000$ | 87,850,000$ | 0$ | 0$ | 0$ | 0$ | 22 | 0 | 0$ | 0$ | 6 | 0$ | 0$ | 0$ | 0$ | -44,000,000$ | 88,000,000$ | 88,000,000$ | 50,025,806$ | 50,025,806$ |
| 27 | Quebec Nordiques | 6400 | 5400 | 3400 | 4400 | 2400 | 95 | 72 | 55 | 35 | 160 | 12485 | 10573 | 5039 | 6608 | 4632 | 97.54% | 97.90% | 74.10% | 75.09% | 96.50% | 39 | 19669 - 89.40% | 1,998,048$ | 3,996,095$ | 22000 | 100 | 86,775,000$ | 86,775,000$ | 0$ | 0$ | 0$ | 0$ | 25 | 0 | 0$ | 0$ | 6 | 0$ | 0$ | 0$ | 0$ | -44,000,000$ | 88,000,000$ | 88,000,000$ | 190,260,692$ | 190,260,692$ |
| 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 | 71,292,500$ | 71,292,500$ | 0$ | 0$ | 0$ | 0$ | 25 | 0 | 0$ | 0$ | 6 | 0$ | 0$ | 0$ | 0$ | -44,000,000$ | 88,000,000$ | 88,000,000$ | 69,945,672$ | 69,945,672$ |
| 29 | San Francisco Shamrocks | 6400 | 5400 | 3400 | 4400 | 2400 | 100 | 75 | 50 | 30 | 175 | 11043 | 9775 | 6800 | 8580 | 4084 | 86.27% | 90.51% | 100.00% | 97.50% | 85.08% | 39 | 20141 - 91.55% | 1,968,454$ | 3,936,907$ | 22000 | 100 | 86,513,000$ | 86,513,000$ | 0$ | 0$ | 0$ | 0$ | 24 | 0 | 0$ | 0$ | 6 | 0$ | 0$ | 0$ | 0$ | -44,000,000$ | 88,000,000$ | 88,000,000$ | 136,391,961$ | 136,391,961$ |
| 30 | Toronto Toros | 6000 | 5000 | 3000 | 4000 | 2000 | 100 | 75 | 50 | 30 | 175 | 10514 | 9217 | 6000 | 8000 | 3630 | 87.62% | 92.17% | 100.00% | 100.00% | 90.75% | 39 | 18681 - 93.40% | 1,823,704$ | 3,647,407$ | 20000 | 100 | 85,992,500$ | 85,992,500$ | 0$ | 0$ | 0$ | 0$ | 25 | 0 | 0$ | 0$ | 6 | 0$ | 0$ | 0$ | 0$ | -44,000,000$ | 88,000,000$ | 88,000,000$ | 178,696,511$ | 178,696,511$ |
| 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 | 43,950,800$ | 43,950,800$ | 0$ | 0$ | 0$ | 0$ | 22 | 0 | 0$ | 0$ | 6 | 0$ | 0$ | 0$ | 0$ | -44,000,000$ | 88,000,000$ | 88,000,000$ | 227,612,274$ | 227,612,274$ |
| 32 | Winnipeg Jets | 6400 | 5400 | 3400 | 4400 | 2400 | 100 | 75 | 50 | 30 | 175 | 11878 | 9459 | 6429 | 8567 | 3859 | 92.80% | 87.58% | 94.54% | 97.35% | 80.40% | 39 | 20096 - 91.35% | 1,969,382$ | 3,938,763$ | 22000 | 100 | 84,665,957$ | 84,665,957$ | 0$ | 0$ | 0$ | 0$ | 23 | 0 | 0$ | 0$ | 6 | 0$ | 0$ | 0$ | 0$ | -44,000,000$ | 88,000,000$ | 88,000,000$ | 230,348,135$ | 230,348,135$ |